Ventas, Inc. (VTR) 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
Ventas, Inc. (VTR) Bundle
Looking to evaluate Ventas, Inc.'s intrinsic value? Our VTR DCF Calculator integrates real-world data with comprehensive customization features, enabling you to adjust forecasts and enhance your investment strategies.
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 | 3,872.8 | 3,795.4 | 3,828.0 | 4,129.2 | 4,497.8 | 4,673.9 | 4,856.8 | 5,047.0 | 5,244.5 | 5,449.8 |
| Revenue Growth, % | 0 | -2 | 0.86026 | 7.87 | 8.93 | 3.91 | 3.91 | 3.91 | 3.91 | 3.91 |
| EBITDA | 1,934.4 | 1,723.1 | 1,604.4 | 1,651.9 | 1,831.0 | 2,037.6 | 2,117.3 | 2,200.2 | 2,286.3 | 2,375.8 |
| EBITDA, % | 49.95 | 45.4 | 41.91 | 40 | 40.71 | 43.59 | 43.59 | 43.59 | 43.59 | 43.59 |
| Depreciation | 2,870.9 | 3,050.8 | 3,224.3 | 3,595.8 | 1,165.9 | 3,288.1 | 3,416.8 | 3,550.5 | 3,689.5 | 3,833.9 |
| Depreciation, % | 74.13 | 80.38 | 84.23 | 87.08 | 25.92 | 70.35 | 70.35 | 70.35 | 70.35 | 70.35 |
| EBIT | -936.6 | -1,327.8 | -1,619.9 | -1,943.9 | 665.1 | -1,250.5 | -1,299.4 | -1,350.3 | -1,403.2 | -1,458.1 |
| EBIT, % | -24.18 | -34.98 | -42.32 | -47.08 | 14.79 | -26.75 | -26.75 | -26.75 | -26.75 | -26.75 |
| Total Cash | 106.4 | 413.3 | 149.7 | 122.6 | 508.8 | 297.5 | 309.2 | 321.3 | 333.8 | 346.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 704.6 | 605.6 | 530.1 | 537.1 | 194.1 | 610.6 | 634.5 | 659.3 | 685.1 | 712.0 |
| Account Receivables, % | 18.19 | 15.96 | 13.85 | 13.01 | 4.32 | 13.06 | 13.06 | 13.06 | 13.06 | 13.06 |
| Inventories | 556.1 | .0 | 448.7 | 451.4 | .0 | 346.0 | 359.5 | 373.6 | 388.2 | 403.4 |
| Inventories, % | 14.36 | 0.0000000263 | 11.72 | 10.93 | 0 | 7.4 | 7.4 | 7.4 | 7.4 | 7.4 |
| Accounts Payable | 1,145.9 | 1,133.1 | 1,090.3 | 1,031.7 | 957.1 | 1,254.4 | 1,303.5 | 1,354.5 | 1,407.5 | 1,462.6 |
| Accounts Payable, % | 29.59 | 29.85 | 28.48 | 24.99 | 21.28 | 26.84 | 26.84 | 26.84 | 26.84 | 26.84 |
| Capital Expenditure | -560.6 | -528.6 | -433.0 | -454.1 | -259.4 | -528.0 | -548.6 | -570.1 | -592.4 | -615.6 |
| Capital Expenditure, % | -14.48 | -13.93 | -11.31 | -11 | -5.77 | -11.3 | -11.3 | -11.3 | -11.3 | -11.3 |
| Tax Rate, % | -2.85 | -2.85 | -2.85 | -2.85 | -2.85 | -2.85 | -2.85 | -2.85 | -2.85 | -2.85 |
| EBITAT | -1,058.9 | -1,691.8 | -1,293.2 | -1,375.2 | 684.1 | -1,126.9 | -1,171.0 | -1,216.8 | -1,264.5 | -1,314.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1,136.6 | 1,472.6 | 1,082.0 | 1,698.4 | 2,310.3 | 1,168.0 | 1,708.8 | 1,775.7 | 1,845.2 | 1,917.4 |
| WACC, % | 8.61 | 8.61 | 8.28 | 8.13 | 8.61 | 8.45 | 8.45 | 8.45 | 8.45 | 8.45 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 6,534.7 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 1,994 | |||||||||
| Terminal Value | 44,856 | |||||||||
| Present Terminal Value | 29,906 | |||||||||
| Enterprise Value | 36,441 | |||||||||
| Net Debt | 13,177 | |||||||||
| Equity Value | 23,264 | |||||||||
| Diluted Shares Outstanding, MM | 402 | |||||||||
| Equity Value Per Share | 57.90 |
What You Will Receive
- Customizable Excel Template: A fully adaptable Excel-based DCF Calculator featuring pre-filled real VTR financials.
- Real-World Insights: Historical data and forward-looking projections (as indicated in the highlighted cells).
- Flexible Forecasting: Adjust forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Ventas, Inc.'s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Layout: Organized for clarity and simplicity, complete with step-by-step guidance.
Key Features
- Comprehensive VTR Data: Pre-populated with Ventas, Inc.'s historical performance and future projections.
- Customizable Assumptions: Modify revenue growth rates, profit margins, discount rates, tax implications, and capital investments.
- Interactive Valuation Framework: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on user inputs.
- Multiple Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- Intuitive User Interface: Designed to be straightforward and accessible for both industry professionals and newcomers.
How It Works
- Step 1: Download the Excel file for Ventas, Inc. (VTR).
- Step 2: Review pre-entered Ventas data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) according to your analysis.
- Step 4: Observe automatic recalculations for Ventas’s intrinsic value.
- Step 5: Utilize the outputs for investment decisions or reporting.
Why Choose This Calculator for Ventas, Inc. (VTR)?
- User-Friendly Interface: Tailored for both newcomers and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Feedback: Observe immediate updates to Ventas, Inc.'s (VTR) valuation as you tweak the inputs.
- Preloaded Data: Comes with Ventas, Inc.'s (VTR) actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use Ventas, Inc. (VTR)?
- Real Estate Investors: Leverage insights from a leading healthcare real estate investment trust to make informed decisions.
- Financial Analysts: Utilize comprehensive market data to streamline analysis and reporting on healthcare properties.
- Consultants: Adapt Ventas, Inc. (VTR) resources for impactful client presentations and strategic recommendations.
- Healthcare Sector Enthusiasts: Explore the intricacies of healthcare real estate investment through practical examples and case studies.
- Educators and Students: Use Ventas, Inc. (VTR) as a real-world case study in finance and real estate courses.
What the Template Contains
- Pre-Filled Data: Includes Ventas, Inc.'s (VTR) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Ventas, Inc.'s (VTR) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.