Caesars Entertainment, Inc. (CZR) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Caesars Entertainment, Inc. (CZR) Bundle
Designed for accuracy, our (CZR) DCF Calculator enables you to evaluate the valuation of Caesars Entertainment, Inc. with real-world financial data and complete flexibility to modify all essential parameters for enhanced 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 | 2,528.2 | 3,474.0 | 9,570.0 | 10,821.0 | 11,528.0 | 16,053.1 | 22,354.5 | 31,129.4 | 43,348.6 | 60,364.4 |
| Revenue Growth, % | 0 | 37.41 | 175.47 | 13.07 | 6.53 | 39.25 | 39.25 | 39.25 | 39.25 | 39.25 |
| EBITDA | 635.8 | 193.0 | 2,832.0 | 3,066.0 | 3,555.0 | 3,835.7 | 5,341.4 | 7,438.0 | 10,357.7 | 14,423.4 |
| EBITDA, % | 25.15 | 5.56 | 29.59 | 28.33 | 30.84 | 23.89 | 23.89 | 23.89 | 23.89 | 23.89 |
| Depreciation | 224.6 | 597.0 | 1,165.0 | 1,259.0 | 1,261.0 | 1,952.6 | 2,719.0 | 3,786.3 | 5,272.6 | 7,342.3 |
| Depreciation, % | 8.88 | 17.18 | 12.17 | 11.63 | 10.94 | 12.16 | 12.16 | 12.16 | 12.16 | 12.16 |
| EBIT | 411.2 | -404.0 | 1,667.0 | 1,807.0 | 2,294.0 | 1,883.1 | 2,622.3 | 3,651.7 | 5,085.1 | 7,081.2 |
| EBIT, % | 16.27 | -11.63 | 17.42 | 16.7 | 19.9 | 11.73 | 11.73 | 11.73 | 11.73 | 11.73 |
| Total Cash | 241.0 | 1,758.0 | 1,070.0 | 1,038.0 | 1,005.0 | 2,877.6 | 4,007.1 | 5,580.0 | 7,770.3 | 10,820.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 53.9 | 342.0 | 472.0 | 611.0 | 608.0 | 893.5 | 1,244.2 | 1,732.6 | 2,412.7 | 3,359.8 |
| Account Receivables, % | 2.13 | 9.84 | 4.93 | 5.65 | 5.27 | 5.57 | 5.57 | 5.57 | 5.57 | 5.57 |
| Inventories | 18.4 | 44.0 | 42.0 | 59.0 | 46.0 | 108.4 | 151.0 | 210.2 | 292.7 | 407.7 |
| Inventories, % | 0.72695 | 1.27 | 0.43887 | 0.54524 | 0.39903 | 0.67533 | 0.67533 | 0.67533 | 0.67533 | 0.67533 |
| Accounts Payable | 62.0 | 167.0 | 254.0 | 314.0 | 408.0 | 525.0 | 731.1 | 1,018.1 | 1,417.7 | 1,974.2 |
| Accounts Payable, % | 2.45 | 4.81 | 2.65 | 2.9 | 3.54 | 3.27 | 3.27 | 3.27 | 3.27 | 3.27 |
| Capital Expenditure | -170.8 | -198.0 | -832.0 | -963.0 | -1,294.0 | -1,325.1 | -1,845.2 | -2,569.5 | -3,578.2 | -4,982.7 |
| Capital Expenditure, % | -6.75 | -5.7 | -8.69 | -8.9 | -11.22 | -8.25 | -8.25 | -8.25 | -8.25 | -8.25 |
| Tax Rate, % | 1410 | 1410 | 1410 | 1410 | 1410 | 1410 | 1410 | 1410 | 1410 | 1410 |
| EBITAT | 266.5 | -435.2 | 1,295.2 | 1,675.9 | -30,051.4 | 1,262.7 | 1,758.3 | 2,448.5 | 3,409.6 | 4,748.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 310.1 | -244.9 | 1,587.2 | 1,875.9 | -29,974.4 | 1,659.3 | 2,444.9 | 3,404.6 | 4,741.0 | 6,602.1 |
| WACC, % | 8.82 | 11.4 | 9.77 | 10.86 | 4.09 | 8.99 | 8.99 | 8.99 | 8.99 | 8.99 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 13,864.1 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 6,833 | |||||||||
| Terminal Value | 124,517 | |||||||||
| Present Terminal Value | 80,973 | |||||||||
| Enterprise Value | 94,837 | |||||||||
| Net Debt | 24,066 | |||||||||
| Equity Value | 70,771 | |||||||||
| Diluted Shares Outstanding, MM | 216 | |||||||||
| Equity Value Per Share | 327.65 |
What You Will Get
- Pre-Filled Financial Model: Caesars Entertainment’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
- Real-Life CZR Data: Pre-filled with Caesars Entertainment's historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures as needed.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Testing: Develop multiple forecast scenarios to evaluate various valuation outcomes.
- User-Friendly Design: Intuitive, organized, and crafted for both professionals and newcomers.
How It Works
- Download the Template: Gain immediate access to the Excel-based CZR DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates Caesars Entertainment’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator?
- Accuracy: Utilizes real Caesars Entertainment financials for precise data.
- Flexibility: Allows users to experiment and adjust inputs as needed.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Simple to navigate, even for those without extensive financial modeling skills.
Who Should Use This Product?
- Casino Management Students: Discover operational strategies and apply them using real-world case studies.
- Researchers: Integrate industry-specific models into your academic projects or papers.
- Investors: Validate your investment hypotheses and evaluate valuation scenarios for Caesars Entertainment, Inc. (CZR).
- Market Analysts: Enhance your analysis with a ready-to-use, customizable financial model.
- Entrepreneurs: Understand the metrics used to assess large entertainment corporations like Caesars Entertainment, Inc. (CZR).
What the Template Contains
- Historical Data: Includes Caesars Entertainment's past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Caesars Entertainment'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 Caesars Entertainment's financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.