VICI Properties Inc. (VICI) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
VICI Properties Inc. (VICI) Bundle
Whether you’re an investor or analyst, this VICI Properties Inc. (VICI) DCF Calculator is your go-to resource for accurate valuation. Preloaded with VICI's real data, you can easily adjust forecasts and observe the effects in real-time.
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 | 894.8 | 1,225.6 | 1,509.6 | 2,600.7 | 3,612.0 | 3,759.5 | 3,913.0 | 4,072.8 | 4,239.1 | 4,412.2 |
Revenue Growth, % | 0 | 36.97 | 23.17 | 72.28 | 38.89 | 4.08 | 4.08 | 4.08 | 4.08 | 4.08 |
EBITDA | 846.3 | 1,257.1 | 1,447.6 | 1,704.9 | 3,341.1 | 3,372.5 | 3,510.2 | 3,653.5 | 3,802.7 | 3,958.0 |
EBITDA, % | 94.58 | 102.57 | 95.89 | 65.56 | 92.5 | 89.71 | 89.71 | 89.71 | 89.71 | 89.71 |
Depreciation | 52.3 | 321.0 | 75.6 | 990.9 | 4.3 | 565.9 | 589.0 | 613.1 | 638.1 | 664.2 |
Depreciation, % | 5.84 | 26.19 | 5.01 | 38.1 | 0.11899 | 15.05 | 15.05 | 15.05 | 15.05 | 15.05 |
EBIT | 794.0 | 936.1 | 1,371.9 | 714.0 | 3,336.8 | 2,825.9 | 2,941.3 | 3,061.4 | 3,186.4 | 3,316.5 |
EBIT, % | 88.74 | 76.38 | 90.88 | 27.46 | 92.38 | 75.17 | 75.17 | 75.17 | 75.17 | 75.17 |
Total Cash | 1,161.4 | 336.0 | 739.6 | 426.3 | 522.6 | 1,558.4 | 1,622.1 | 1,688.3 | 1,757.2 | 1,829.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 61.7 | 6.9 | 8.2 | 16,759.7 | 18,236.3 | 1,564.0 | 1,627.8 | 1,694.3 | 1,763.5 | 1,835.5 |
Account Receivables, % | 6.9 | 0.56569 | 0.54009 | 644.43 | 504.88 | 41.6 | 41.6 | 41.6 | 41.6 | 41.6 |
Inventories | .0 | 342.9 | -.9 | -7.3 | .0 | 207.8 | 216.3 | 225.1 | 234.3 | 243.9 |
Inventories, % | 0.000000112 | 27.98 | -0.0585598 | -0.28254 | 0 | 5.53 | 5.53 | 5.53 | 5.53 | 5.53 |
Accounts Payable | .6 | .7 | .0 | .0 | .0 | 1.0 | 1.0 | 1.1 | 1.1 | 1.2 |
Accounts Payable, % | 0.07152452 | 0.0598903 | 0 | 0 | 0 | 0.02628297 | 0.02628297 | 0.02628297 | 0.02628297 | 0.02628297 |
Capital Expenditure | -2.7 | -2.8 | -2.5 | -1.9 | -4.0 | -6.6 | -6.9 | -7.2 | -7.5 | -7.8 |
Capital Expenditure, % | -0.30443 | -0.22585 | -0.16594 | -0.07213451 | -0.11171 | -0.17601 | -0.17601 | -0.17601 | -0.17601 | -0.17601 |
Tax Rate, % | 1.37 | 1.37 | 1.37 | 1.37 | 1.37 | 1.37 | 1.37 | 1.37 | 1.37 | 1.37 |
EBITAT | 779.7 | 930.5 | 1,355.6 | 700.5 | 3,291.1 | 2,787.2 | 2,901.0 | 3,019.5 | 3,142.8 | 3,271.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 768.2 | 960.8 | 1,770.6 | -15,055.5 | 1,807.3 | 19,812.1 | 3,410.9 | 3,550.1 | 3,695.1 | 3,846.0 |
WACC, % | 7.33 | 7.35 | 7.34 | 7.32 | 7.33 | 7.33 | 7.33 | 7.33 | 7.33 | 7.33 |
PV UFCF | ||||||||||
SUM PV UFCF | 29,774.3 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 4,000 | |||||||||
Terminal Value | 120,003 | |||||||||
Present Terminal Value | 84,241 | |||||||||
Enterprise Value | 114,015 | |||||||||
Net Debt | 17,106 | |||||||||
Equity Value | 96,909 | |||||||||
Diluted Shares Outstanding, MM | 1,016 | |||||||||
Equity Value Per Share | 95.40 |
What You Will Get
- Real VICI Financial Data: Pre-filled with VICI Properties Inc.'s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See VICI’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Customizable Investment Metrics: Adjust essential factors such as rental income growth, occupancy rates, and capital investment.
- Instant DCF Valuation: Computes intrinsic value, NPV, and other financial metrics in real-time.
- High-Precision Accuracy: Leverages VICI’s actual financial data for reliable valuation results.
- Effortless Scenario Analysis: Evaluate various assumptions and analyze results effortlessly.
- Efficiency Booster: Avoid the complexity of creating intricate valuation models from the ground up.
How It Works
- 1. Access the Template: Download and open the Excel file containing VICI Properties Inc. (VICI) preloaded data.
- 2. Adjust Key Inputs: Modify essential assumptions such as growth rates, WACC, and capital expenditures.
- 3. Instant Results: The DCF model automatically calculates intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation outcomes.
- 5. Make Informed Decisions: Present comprehensive valuation insights to back your investment choices.
Why Choose This Calculator for VICI Properties Inc. (VICI)?
- Comprehensive Tool: Features DCF, WACC, and financial ratio analyses tailored for real estate investment trusts.
- Customizable Inputs: Modify yellow-highlighted cells to explore different investment scenarios.
- Detailed Insights: Automatically computes VICI's intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points for analysis.
- Professional Quality: Perfect for real estate analysts, investors, and financial consultants.
Who Should Use VICI Properties Inc. (VICI)?
- Real Estate Investors: Gain insights into investment opportunities with a trusted property management company.
- Financial Analysts: Streamline your analysis with comprehensive data on VICI's portfolio and performance metrics.
- Consultants: Easily tailor reports and presentations for clients interested in real estate investment trusts (REITs).
- Real Estate Enthusiasts: Enhance your knowledge of the REIT market with practical examples from VICI's operations.
- Educators and Students: Utilize VICI's case studies as a resource for finance and real estate education.
What the Template Contains
- Historical Data: Includes VICI Properties Inc.'s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate VICI's intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of VICI's financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.