Seven Hills Realty Trust (SEVN) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Seven Hills Realty Trust (SEVN) Bundle
Looking to evaluate the intrinsic value of Seven Hills Realty Trust? Our (SEVN) DCF Calculator integrates real-world data with comprehensive customization features, allowing you to adjust forecasts and enhance your investment choices.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 72.1 | -54.3 | 30.2 | 34.1 | 34.9 | 18.8 | 10.1 | 5.4 | 2.9 | 1.6 |
| Revenue Growth, % | 0 | -175.37 | -155.67 | 12.8 | 2.36 | -46.21 | -46.21 | -46.21 | -46.21 | -46.21 |
| EBITDA | 69.5 | -54.5 | .0 | 52.3 | .0 | 11.1 | 6.0 | 3.2 | 1.7 | .9 |
| EBITDA, % | 96.47 | 100.31 | 0 | 153.44 | 0 | 59.29 | 59.29 | 59.29 | 59.29 | 59.29 |
| Depreciation | -54.8 | 73.0 | 7.9 | 10.6 | .6 | -4.4 | -2.4 | -1.3 | -.7 | -.4 |
| Depreciation, % | -76.05 | -134.45 | 26.05 | 31 | 1.73 | -23.45 | -23.45 | -23.45 | -23.45 | -23.45 |
| EBIT | 124.3 | -127.5 | -7.9 | 41.8 | -.6 | 10.2 | 5.5 | 3.0 | 1.6 | .9 |
| EBIT, % | 172.52 | 234.75 | -26.05 | 122.44 | -1.73 | 54.44 | 54.44 | 54.44 | 54.44 | 54.44 |
| Total Cash | .0 | 103.3 | 26.2 | 741.0 | 87.9 | 7.0 | 3.8 | 2.0 | 1.1 | .6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 2.6 | 91.9 | 570.8 | .0 | 3.6 | .5 | .3 | .2 | .1 | .0 |
| Account Receivables, % | 3.56 | -169.18 | 1887.94 | 0 | 10.41 | 2.79 | 2.79 | 2.79 | 2.79 | 2.79 |
| Inventories | 7.2 | 103.7 | 29.3 | .0 | .0 | .3 | .1 | .1 | .0 | .0 |
| Inventories, % | 10.04 | -190.95 | 96.95 | 0.000002932379 | 0 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 |
| Accounts Payable | .2 | .0 | 1.6 | 1.9 | .0 | .4 | .2 | .1 | .1 | .0 |
| Accounts Payable, % | 0.33208 | 0 | 5.16 | 5.58 | 0 | 2.22 | 2.22 | 2.22 | 2.22 | 2.22 |
| Capital Expenditure | .0 | .0 | -4.9 | .0 | .0 | -.6 | -.3 | -.2 | -.1 | -.1 |
| Capital Expenditure, % | 0 | 0 | -16.24 | 0 | 0 | -3.25 | -3.25 | -3.25 | -3.25 | -3.25 |
| Tax Rate, % | 0.69811 | 0.69811 | 0.69811 | 0.69811 | 0.69811 | 0.69811 | 0.69811 | 0.69811 | 0.69811 | 0.69811 |
| EBITAT | 124.3 | -105.5 | -7.8 | 41.3 | -.6 | 9.8 | 5.3 | 2.8 | 1.5 | .8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 60.0 | -218.5 | -407.8 | 652.3 | -5.5 | 8.1 | 2.7 | 1.5 | .8 | .4 |
| WACC, % | 7.26 | 6.35 | 7.19 | 7.2 | 7.22 | 7.04 | 7.04 | 7.04 | 7.04 | 7.04 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 12.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 0 | |||||||||
| Terminal Value | 9 | |||||||||
| Present Terminal Value | 6 | |||||||||
| Enterprise Value | 18 | |||||||||
| Net Debt | 367 | |||||||||
| Equity Value | -348 | |||||||||
| Diluted Shares Outstanding, MM | 15 | |||||||||
| Equity Value Per Share | -23.82 |
What You Will Get
- Authentic SEVN Data: Preloaded financials – encompassing revenue to EBIT – derived from actual and projected figures.
- Comprehensive Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Immediate Valuation Updates: Automatic recalculations to evaluate the effects of changes on Seven Hills Realty Trust’s fair value.
- Flexible Excel Template: Designed for quick modifications, scenario analysis, and thorough projections.
- Efficient and Precise: Avoid the hassle of building models from the ground up while ensuring accuracy and adaptability.
Key Features
- Comprehensive Market Data: Access Seven Hills Realty Trust’s (SEVN) historical performance metrics and comprehensive forecasts.
- Customizable Assumptions: Modify key variables such as cap rates, occupancy rates, and revenue projections.
- Real-Time Valuation: Instantly view the recalculated intrinsic value of Seven Hills Realty Trust (SEVN) as inputs change.
- Intuitive Visualizations: Interactive dashboard displays valuation outcomes and essential performance indicators.
- Designed for Professionals: A robust tool tailored for real estate analysts, investors, and finance professionals.
How It Works
- Download the Template: Gain immediate access to the Excel-based SEVN DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Seven Hills Realty Trust’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation impacts.
- Analyze and Decide: Leverage the results to inform your investment or financial strategy.
Why Choose This Calculator for Seven Hills Realty Trust (SEVN)?
- Accurate Data: Utilize real financials from Seven Hills Realty Trust for dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Built-in calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the real estate sector.
- User-Friendly: An intuitive design and clear step-by-step guidance make it accessible for all users.
Who Should Use Seven Hills Realty Trust (SEVN)?
- Real Estate Investors: Make informed investment choices with our comprehensive market analysis tools.
- Property Analysts: Streamline your workflow with our user-friendly valuation models tailored for real estate.
- Real Estate Consultants: Effortlessly customize reports and presentations for your clients using our templates.
- Real Estate Enthusiasts: Enhance your knowledge of market trends and property valuation through practical examples.
- Educators and Students: Leverage our resources as a hands-on learning aid in real estate and finance courses.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Seven Hills Realty Trust (SEVN) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Seven Hills Realty Trust (SEVN).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.