Gaming and Leisure Properties, Inc. (GLPI) 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
Gaming and Leisure Properties, Inc. (GLPI) Bundle
Empower your valuation analysis of Gaming and Leisure Properties, Inc. (GLPI) with our sophisticated DCF Calculator! This Excel template comes preloaded with real (GLPI) data, enabling you to adjust forecasts and assumptions to accurately compute the intrinsic value of Gaming and Leisure Properties, Inc. (GLPI).
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,153.5 | 1,153.2 | 1,216.4 | 1,311.7 | 1,440.4 | 1,523.6 | 1,611.6 | 1,704.7 | 1,803.1 | 1,907.3 |
| Revenue Growth, % | 0 | -0.02670197 | 5.48 | 7.84 | 9.81 | 5.78 | 5.78 | 5.78 | 5.78 | 5.78 |
| EBITDA | 956.1 | 1,010.9 | 1,072.1 | 1,220.3 | 1,342.9 | 1,355.9 | 1,434.2 | 1,517.0 | 1,604.6 | 1,697.3 |
| EBITDA, % | 82.89 | 87.66 | 88.14 | 93.03 | 93.23 | 88.99 | 88.99 | 88.99 | 88.99 | 88.99 |
| Depreciation | 423.1 | 385.3 | 396.3 | 346.0 | 276.4 | 451.7 | 477.8 | 505.4 | 534.6 | 565.5 |
| Depreciation, % | 36.68 | 33.41 | 32.58 | 26.37 | 19.19 | 29.65 | 29.65 | 29.65 | 29.65 | 29.65 |
| EBIT | 533.1 | 625.6 | 675.7 | 874.3 | 1,066.5 | 904.2 | 956.4 | 1,011.6 | 1,070.0 | 1,131.8 |
| EBIT, % | 46.22 | 54.25 | 55.55 | 66.66 | 74.04 | 59.34 | 59.34 | 59.34 | 59.34 | 59.34 |
| Total Cash | 26.8 | 486.5 | 724.6 | 239.1 | 684.0 | 517.4 | 547.3 | 578.9 | 612.3 | 647.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 303.7 | .0 | 1,201.7 | 1,903.2 | 2,062.6 | 990.7 | 1,047.9 | 1,108.4 | 1,172.5 | 1,240.2 |
| Account Receivables, % | 26.33 | 0 | 98.79 | 145.1 | 143.2 | 65.02 | 65.02 | 65.02 | 65.02 | 65.02 |
| Inventories | 31.1 | .0 | .0 | .0 | .0 | 8.2 | 8.7 | 9.2 | 9.7 | 10.3 |
| Inventories, % | 2.69 | 0 | 0.0000000822 | -0.0000000762 | 0 | 0.53839 | 0.53839 | 0.53839 | 0.53839 | 0.53839 |
| Accounts Payable | 1.0 | .4 | 63.5 | 6.6 | 7.0 | 19.3 | 20.4 | 21.6 | 22.8 | 24.1 |
| Accounts Payable, % | 0.08721487 | 0.0325192 | 5.22 | 0.5002 | 0.48674 | 1.27 | 1.27 | 1.27 | 1.27 | 1.27 |
| Capital Expenditure | -3.0 | -3.6 | -16.2 | -24.0 | -47.4 | -21.4 | -22.7 | -24.0 | -25.4 | -26.8 |
| Capital Expenditure, % | -0.26156 | -0.31253 | -1.33 | -1.83 | -3.29 | -1.41 | -1.41 | -1.41 | -1.41 | -1.41 |
| Tax Rate, % | 3.05 | 3.05 | 3.05 | 3.05 | 3.05 | 3.05 | 3.05 | 3.05 | 3.05 | 3.05 |
| EBITAT | 526.7 | 620.8 | 641.6 | 831.0 | 1,034.0 | 877.0 | 927.7 | 981.2 | 1,037.9 | 1,097.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 613.0 | 1,336.6 | -116.7 | 394.4 | 1,104.0 | 2,383.3 | 1,326.2 | 1,402.8 | 1,483.8 | 1,569.5 |
| WACC, % | 7.58 | 7.58 | 7.51 | 7.51 | 7.54 | 7.55 | 7.55 | 7.55 | 7.55 | 7.55 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 6,690.6 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 1,624 | |||||||||
| Terminal Value | 40,153 | |||||||||
| Present Terminal Value | 27,910 | |||||||||
| Enterprise Value | 34,600 | |||||||||
| Net Debt | 6,195 | |||||||||
| Equity Value | 28,406 | |||||||||
| Diluted Shares Outstanding, MM | 265 | |||||||||
| Equity Value Per Share | 107.19 |
What You Will Get
- Pre-Filled Financial Model: Gaming and Leisure Properties, Inc.’s actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
- Instant Calculations: Automatic updates ensure you see results as you make changes.
- Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
- Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as rental income growth, property operating margins, and capital investments.
- Instant DCF Valuation: Quickly determines intrinsic value, NPV, and additional financial metrics.
- High-Precision Accuracy: Leverages GLPI's actual financial data for dependable valuation results.
- Simplified Scenario Analysis: Effortlessly explore various assumptions and assess their impact on results.
- Efficiency Booster: Avoid the complexities of creating detailed valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Gaming and Leisure Properties, Inc.'s (GLPI) pre-filled financial data and forecasts.
- Step 3: Modify critical inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the outputs and utilize the results for your investment decisions.
Why Choose This Calculator for Gaming and Leisure Properties, Inc. (GLPI)?
- Comprehensive Tool: Features DCF, WACC, and financial ratio analyses tailored for the gaming and leisure sector.
- Customizable Inputs: Modify the highlighted cells to explore different investment scenarios.
- Detailed Insights: Automatically computes GLPI’s intrinsic value and Net Present Value.
- Preloaded Data: Access historical and projected data for reliable analysis.
- Professional Quality: Perfect for financial analysts, investors, and consultants in the gaming industry.
Who Should Use This Product?
- Real Estate Investors: Develop comprehensive valuation models for gaming and leisure properties.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the industry.
- Consultants and Advisors: Deliver precise valuation insights for Gaming and Leisure Properties, Inc. (GLPI).
- Students and Educators: Utilize real-world data to learn and teach financial modeling in the gaming sector.
- Gaming Industry Enthusiasts: Gain insights into how companies like Gaming and Leisure Properties, Inc. (GLPI) are valued in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Gaming and Leisure Properties, Inc. (GLPI) 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 Gaming and Leisure Properties, Inc. (GLPI).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.