Vornado Realty Trust (VNO) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Vornado Realty Trust (VNO) Bundle
Assess Vornado Realty Trust's (VNO) financial outlook like an expert! This (VNO) DCF Calculator provides you with pre-filled financial data and the flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
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 | 1,924.7 | 1,528.0 | 1,589.2 | 1,800.0 | 1,811.2 | 1,798.8 | 1,786.6 | 1,774.5 | 1,762.4 | 1,750.4 |
| Revenue Growth, % | 0 | -20.61 | 4.01 | 13.26 | 0.62045 | -0.68009 | -0.68009 | -0.68009 | -0.68009 | -0.68009 |
| EBITDA | 3,486.8 | 228.3 | 792.5 | 423.3 | 845.6 | 845.5 | 839.7 | 834.0 | 828.4 | 822.7 |
| EBITDA, % | 181.16 | 14.94 | 49.87 | 23.52 | 46.69 | 47 | 47 | 47 | 47 | 47 |
| Depreciation | 1,630.3 | 1,607.8 | 1,350.8 | 1,463.5 | 457.6 | 1,353.7 | 1,344.5 | 1,335.3 | 1,326.3 | 1,317.2 |
| Depreciation, % | 84.7 | 105.22 | 85 | 81.3 | 25.26 | 75.25 | 75.25 | 75.25 | 75.25 | 75.25 |
| EBIT | 1,856.5 | -1,379.5 | -558.3 | -1,040.2 | 388.0 | -235.0 | -233.4 | -231.8 | -230.2 | -228.7 |
| EBIT, % | 96.46 | -90.28 | -35.13 | -57.79 | 21.42 | -13.06 | -13.06 | -13.06 | -13.06 | -13.06 |
| Total Cash | 1,515.0 | 1,624.5 | 1,760.2 | 1,361.7 | 997.0 | 1,472.9 | 1,462.9 | 1,453.0 | 1,443.1 | 1,433.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 837.9 | 751.7 | 736.0 | 776.1 | 771.2 | 808.6 | 803.1 | 797.6 | 792.2 | 786.8 |
| Account Receivables, % | 43.54 | 49.2 | 46.31 | 43.12 | 42.58 | 44.95 | 44.95 | 44.95 | 44.95 | 44.95 |
| Inventories | -4.3 | .0 | -18.9 | -183.8 | .0 | -41.8 | -41.6 | -41.3 | -41.0 | -40.7 |
| Inventories, % | -0.22481 | -0.00111254 | -1.19 | -10.21 | 0 | -2.33 | -2.33 | -2.33 | -2.33 | -2.33 |
| Accounts Payable | 440.0 | 427.2 | 613.5 | 450.9 | 411.0 | 493.5 | 490.1 | 486.8 | 483.5 | 480.2 |
| Accounts Payable, % | 22.86 | 27.96 | 38.6 | 25.05 | 22.7 | 27.43 | 27.43 | 27.43 | 27.43 | 27.43 |
| Capital Expenditure | -438.9 | -395.1 | -3.0 | -3.0 | .0 | -176.3 | -175.1 | -174.0 | -172.8 | -171.6 |
| Capital Expenditure, % | -22.81 | -25.85 | -0.18877 | -0.16667 | 0 | -9.8 | -9.8 | -9.8 | -9.8 | -9.8 |
| Tax Rate, % | -69.85 | -69.85 | -69.85 | -69.85 | -69.85 | -69.85 | -69.85 | -69.85 | -69.85 | -69.85 |
| EBITAT | 1,700.0 | -1,498.3 | -498.7 | -1,102.6 | 659.1 | -226.0 | -224.5 | -223.0 | -221.4 | -219.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 2,497.8 | -216.6 | 1,070.1 | 320.0 | 897.9 | 1,038.3 | 946.7 | 940.3 | 933.9 | 927.5 |
| WACC, % | 7.86 | 8.06 | 7.81 | 8.06 | 8.06 | 7.97 | 7.97 | 7.97 | 7.97 | 7.97 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 3,840.3 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 965 | |||||||||
| Terminal Value | 24,309 | |||||||||
| Present Terminal Value | 16,569 | |||||||||
| Enterprise Value | 20,409 | |||||||||
| Net Debt | 7,987 | |||||||||
| Equity Value | 12,422 | |||||||||
| Diluted Shares Outstanding, MM | 192 | |||||||||
| Equity Value Per Share | 64.75 |
What You Will Get
- Real Vornado Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Vornado Realty Trust’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- 🔍 Real-Life VNO Financials: Pre-filled historical and projected data for Vornado Realty Trust (VNO).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Vornado’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Vornado’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Vornado Realty Trust’s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as rental income growth, capitalization rates, and operating expenses (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the results and utilize them for your investment strategies.
Why Choose Vornado Realty Trust (VNO)?
- Time-Efficient: Skip the hassle of building a real estate model from the ground up – it's ready for you.
- Enhanced Precision: Dependable market data and calculations minimize valuation discrepancies.
- Completely Customizable: Adjust the model to align with your investment assumptions and forecasts.
- User-Friendly: Intuitive visuals and outputs simplify the analysis of results.
- Endorsed by Professionals: Crafted for industry experts who prioritize accuracy and functionality.
Who Should Use This Product?
- Real Estate Investors: Develop comprehensive and accurate valuation models for property analysis.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for Vornado Realty Trust (VNO) to clients.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Market Analysts: Gain insights into how real estate investment trusts like Vornado Realty Trust (VNO) are valued in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Vornado Realty Trust (VNO) 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 Vornado Realty Trust (VNO).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.