The Cheesecake Factory Incorporated (CAKE) 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
The Cheesecake Factory Incorporated (CAKE) Bundle
Discover the true value of The Cheesecake Factory Incorporated (CAKE) with our expert-level DCF Calculator! Adjust key assumptions, explore various scenarios, and assess how modifications affect The Cheesecake Factory Incorporated (CAKE) valuation – all within one comprehensive Excel template.
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,482.7 | 1,983.2 | 2,927.5 | 3,303.2 | 3,439.5 | 3,821.8 | 4,246.5 | 4,718.5 | 5,242.9 | 5,825.5 |
| Revenue Growth, % | 0 | -20.12 | 47.62 | 12.83 | 4.13 | 11.11 | 11.11 | 11.11 | 11.11 | 11.11 |
| EBITDA | 230.4 | -255.9 | 208.5 | 174.5 | 202.9 | 112.2 | 124.7 | 138.5 | 153.9 | 171.0 |
| EBITDA, % | 9.28 | -12.9 | 7.12 | 5.28 | 5.9 | 2.94 | 2.94 | 2.94 | 2.94 | 2.94 |
| Depreciation | 87.5 | 91.5 | 89.3 | 91.3 | 93.1 | 127.3 | 141.5 | 157.2 | 174.7 | 194.1 |
| Depreciation, % | 3.53 | 4.61 | 3.05 | 2.76 | 2.71 | 3.33 | 3.33 | 3.33 | 3.33 | 3.33 |
| EBIT | 142.8 | -347.4 | 119.3 | 83.2 | 109.8 | -15.1 | -16.8 | -18.7 | -20.8 | -23.1 |
| EBIT, % | 5.75 | -17.52 | 4.07 | 2.52 | 3.19 | -0.39638 | -0.39638 | -0.39638 | -0.39638 | -0.39638 |
| Total Cash | 58.4 | 154.1 | 189.6 | 114.8 | 56.3 | 165.9 | 184.4 | 204.9 | 227.7 | 253.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 118.1 | 75.8 | 136.7 | 82.3 | 79.4 | 137.9 | 153.3 | 170.3 | 189.2 | 210.3 |
| Account Receivables, % | 4.76 | 3.82 | 4.67 | 2.49 | 2.31 | 3.61 | 3.61 | 3.61 | 3.61 | 3.61 |
| Inventories | 47.2 | 39.3 | 42.8 | 55.6 | 57.7 | 66.5 | 73.9 | 82.1 | 91.3 | 101.4 |
| Inventories, % | 1.9 | 1.98 | 1.46 | 1.68 | 1.68 | 1.74 | 1.74 | 1.74 | 1.74 | 1.74 |
| Accounts Payable | 61.9 | 58.4 | 54.1 | 66.6 | 63.2 | 85.2 | 94.6 | 105.1 | 116.8 | 129.8 |
| Accounts Payable, % | 2.5 | 2.95 | 1.85 | 2.02 | 1.84 | 2.23 | 2.23 | 2.23 | 2.23 | 2.23 |
| Capital Expenditure | -75.9 | -50.9 | -67.5 | -113.1 | -153.2 | -120.8 | -134.3 | -149.2 | -165.8 | -184.2 |
| Capital Expenditure, % | -3.06 | -2.57 | -2.31 | -3.43 | -4.45 | -3.16 | -3.16 | -3.16 | -3.16 | -3.16 |
| Tax Rate, % | -1.34 | -1.34 | -1.34 | -1.34 | -1.34 | -1.34 | -1.34 | -1.34 | -1.34 | -1.34 |
| EBITAT | 129.6 | -247.2 | 120.5 | 109.1 | 111.2 | -14.0 | -15.5 | -17.3 | -19.2 | -21.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 37.8 | -159.9 | 73.4 | 141.4 | 48.4 | -52.9 | -21.6 | -24.0 | -26.7 | -29.6 |
| WACC, % | 8.17 | 7.79 | 8.35 | 8.35 | 8.35 | 8.21 | 8.21 | 8.21 | 8.21 | 8.21 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -125.7 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | -31 | |||||||||
| Terminal Value | -652 | |||||||||
| Present Terminal Value | -439 | |||||||||
| Enterprise Value | -565 | |||||||||
| Net Debt | 1,804 | |||||||||
| Equity Value | -2,369 | |||||||||
| Diluted Shares Outstanding, MM | 49 | |||||||||
| Equity Value Per Share | -48.29 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real CAKE financials.
- Real-World Data: Historical data and forward-looking estimates (as illustrated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect The Cheesecake Factory’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for The Cheesecake Factory (CAKE).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs for accurate analysis.
- Customizable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates to fit your projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to The Cheesecake Factory (CAKE).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered The Cheesecake Factory (CAKE) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for The Cheesecake Factory’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for The Cheesecake Factory (CAKE)?
- Comprehensive Tool: Combines DCF, WACC, and financial ratio analyses tailored for CAKE.
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios for The Cheesecake Factory.
- Detailed Insights: Automatically computes the intrinsic value and Net Present Value for CAKE.
- Preloaded Data: Includes historical and forecasted data for accurate analysis of The Cheesecake Factory.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on CAKE.
Who Should Use This Product?
- Investors: Evaluate The Cheesecake Factory's (CAKE) market value before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methods and assess financial forecasts for The Cheesecake Factory.
- Restaurant Entrepreneurs: Understand how established brands like The Cheesecake Factory are valued in the industry.
- Consultants: Create detailed valuation reports for clients in the food and beverage sector.
- Students and Educators: Utilize current data to learn and teach valuation principles relevant to the restaurant business.
What the Template Contains
- Pre-Filled DCF Model: The Cheesecake Factory's (CAKE) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate The Cheesecake Factory's (CAKE) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.