Corporate Finance Analysis: The Cheesecake Factory (CAKE)
A Complete FP&A Portfolio | 3-Statement Model · Variance Analysis · Break-Even · KPI Drivers · Capital Budgeting
PORTFOLIO OVERVIEW — FOR HIRING MANAGERS
This article presents a complete corporate finance analysis of The Cheesecake Factory, built from publicly available 10-K filings and applied to five core FP&A competencies. Each section demonstrates a distinct skill relevant to Financial Analyst and FP&A roles.
Skills Demonstrated
3-Statement Modeling Variance Analysis Break-Even Analysis KPI Frameworks NPV / IRR WACC Sensitivity Analysis FP&A Reporting Executive CommunicationTools & Methods
Excel (linked model) DCF Pro Forma Statements Budget vs. Actual Contribution Margin EV/EBITDA SEC 10-K AnalysisSource data: CAKE 10-K FY2024, SEC EDGAR. All projections are hypothetical models built for educational and portfolio purposes. Download the Excel workbook at the bottom of this page.
Section 1 — Building a 5-Year 3-Statement Financial Model
FY2022A–FY2028P | Income Statement · Cash Flow · Sensitivity Analysis
The 3-statement model is the foundation of every FP&A role. It links the Income Statement, Balance Sheet, and Cash Flow Statement into a single dynamic model where every projection cell flows from a stated assumption rather than a hardcoded number. For The Cheesecake Factory, we anchor to four years of actuals from the 10-K and extend through FY2028.
The Core Linkage Logic
Net Income flows to retained earnings. Operating cash flow starts with Net Income and adds back non-cash charges. CapEx reduces cash and increases PP&E. When one assumption changes, all three statements update. This is what makes a model dynamic rather than a static spreadsheet.
Revenue Forecast Drivers
Revenue is decomposed into three levers management actually controls: unit count growth, comparable sales growth, and average check. Projections assume modest same-store sales recovery and disciplined unit expansion of 9–11 net new locations per year, consistent with FY2024 10-K guidance.
| Revenue Driver | FY2022A | FY2023A | FY2024A | FY2025P | FY2026P | FY2027P | FY2028P |
|---|---|---|---|---|---|---|---|
| Unit Count (EOP) | 305 | 319 | 328 | 337 | 347 | 358 | 369 |
| Same-Store Sales Growth | 2.1% | 3.2% | 1.4% | 2.5% | 2.8% | 3.0% | 3.2% |
| Avg Check Growth | 3.8% | 2.7% | 3.8% | 2.5% | 2.0% | 2.0% | 2.0% |
| Revenue Growth (Total) | — | 2.3% | 1.9% | 3.0% | 3.2% | 3.3% | 3.5% |
| Total Revenue ($M) | $3,467 | $3,549 | $3,617 | $3,726 | $3,845 | $3,972 | $4,111 |
Income Statement Projection
Each cost line is expressed as a percentage of revenue, anchored to historical actuals and adjusted for known trends. Food & Beverage cost is projected to decline 50 basis points by FY2028 through menu engineering and supply chain optimization. Labor declines 40 bps as scheduling technology offsets wage inflation.
| Income Statement ($M) | FY2022A | FY2023A | FY2024A | FY2025P | FY2026P | FY2027P | FY2028P |
|---|---|---|---|---|---|---|---|
| Revenue | $3,467 | $3,549 | $3,617 | $3,726 | $3,845 | $3,972 | $4,111 |
| Cost Structure | |||||||
| Food & Bev Cost % | 27.2% | 27.1% | 27.0% | 26.8% | 26.7% | 26.6% | 26.5% |
| Food & Bev Cost ($M) | ($942) | ($962) | ($977) | ($999) | ($1,026) | ($1,057) | ($1,089) |
| Labor Cost % | 35.5% | 35.3% | 35.2% | 35.1% | 35.0% | 34.9% | 34.8% |
| Labor Cost ($M) | ($1,231) | ($1,253) | ($1,273) | ($1,308) | ($1,346) | ($1,386) | ($1,431) |
| Other Restaurant Costs ($M) | ($423) | ($430) | ($434) | ($447) | ($461) | ($477) | ($493) |
| Gross Profit ($M) | $871 | $904 | $933 | $972 | $1,012 | $1,052 | $1,098 |
| Gross Margin % | 25.1% | 25.5% | 25.8% | 26.1% | 26.3% | 26.5% | 26.7% |
| SG&A ($M) | ($208) | ($209) | ($213) | ($216) | ($219) | ($226) | ($230) |
| D&A ($M) | ($156) | ($160) | ($163) | ($168) | ($173) | ($179) | ($185) |
| EBIT — Operating Income ($M) | $507 | $535 | $557 | $588 | $620 | $647 | $683 |
| EBIT Margin % | 14.6% | 15.1% | 15.4% | 15.8% | 16.1% | 16.3% | 16.6% |
| Interest Expense ($M) | ($27) | ($29) | ($31) | ($31) | ($32) | ($32) | ($33) |
| Income Tax | ($62) | ($70) | ($74) | ($78) | ($83) | ($86) | ($91) |
| Net Income ($M) | $418 | $436 | $452 | $479 | $505 | $529 | $559 |
| Net Margin % | 12.1% | 12.3% | 12.5% | 12.9% | 13.1% | 13.3% | 13.6% |
| EBITDA ($M) | $663 | $695 | $720 | $756 | $793 | $826 | $868 |
| EBITDA Margin % | 19.1% | 19.6% | 19.9% | 20.3% | 20.6% | 20.8% | 21.1% |
Free Cash Flow
| Cash Flow ($M) | FY2022A | FY2023A | FY2024A | FY2025P | FY2026P | FY2027P | FY2028P |
|---|---|---|---|---|---|---|---|
| Net Income | $418 | $436 | $452 | $479 | $505 | $529 | $559 |
| Add: D&A | $156 | $160 | $163 | $168 | $173 | $179 | $185 |
| Working Capital Changes | $69 | $71 | $72 | $75 | $77 | $79 | $82 |
| Operating Cash Flow | $643 | $667 | $687 | $722 | $755 | $787 | $826 |
| Less: CapEx | ($139) | ($138) | ($137) | ($149) | ($154) | ($155) | ($156) |
| Free Cash Flow | $504 | $529 | $550 | $573 | $601 | $632 | $670 |
| FCF Margin % | 14.5% | 14.9% | 15.2% | 15.4% | 15.6% | 15.9% | 16.3% |
Sensitivity Analysis — FY2026P Net Income ($M)
A model without sensitivity analysis is incomplete. The table below stress-tests Net Income against revenue growth and margin assumptions — the two variables management can influence most directly.
| Net Income FY2026P | Rev Growth → | +1% | +2% | +3% Base | +4% | +5% |
|---|---|---|---|---|---|
| Margin +100 bps | $532 | $547 | $562 | $578 | $595 |
| Margin +50 bps | $519 | $534 | $548 | $563 | $579 |
| Base Case | $491 | $505 | $520 | $536 | $552 |
| Margin -50 bps | $463 | $476 | $490 | $504 | $519 |
| Margin -100 bps | $436 | $449 | $462 | $476 | $490 |
Section 2 — Budget vs. Actual Variance Analysis
Q3 FY2025 | FP&A Case Study | CFO-Level Reporting Format
Every FP&A analyst spends a significant portion of each month explaining why actual results differed from plan. Variance analysis is the structured process of quantifying those differences, identifying their drivers, and communicating actionable findings to management. The structure is consistent regardless of company: What was the plan? What happened? How large is the gap? What caused it?
Volume vs. Price vs. Mix — The Three Variance Drivers
Volume: More or fewer covers than planned. Price: Average menu price realization. Mix: Which items guests ordered vs. what was assumed. Identifying the correct driver determines the management response — they are not interchangeable.
Q3 FY2025 — Full P&L Variance Table
| Metric | Budget | Actual | Variance | Var % | Primary Driver |
|---|---|---|---|---|---|
| REVENUE | |||||
| Total Revenue ($M) | $916.5 | $902.3 | ($14.2) | (1.5%) | Traffic softness; comp traffic -1.8% vs. +0.5% budgeted |
| Same-Store Sales Growth | 3.2% | 1.4% | (180 bps) | — | Pricing insufficient to offset volume decline |
| Average Check ($) | $28.45 | $28.90 | +$0.45 | +1.6% | Favorable premium menu mix shift |
| FOOD & BEVERAGE COST | |||||
| Food & Bev Cost ($M) | $244.9 | $251.1 | ($6.2) | (2.5%) | Commodity inflation: poultry +4.2%, dairy +2.8% |
| Food & Bev Cost % | 26.7% | 27.8% | (110 bps) | — | Spot market exposure above hedging coverage |
| LABOR COST | |||||
| Labor Cost ($M) | $321.1 | $326.8 | ($5.7) | (1.8%) | CA minimum wage increase July 2025; OT premium |
| Labor Cost % | 35.0% | 36.2% | (120 bps) | — | Understaffing-driven overtime; scheduling gap |
| OPERATING PERFORMANCE | |||||
| SG&A ($M) | $52.2 | $53.7 | ($1.5) | (2.9%) | Legal accruals + marketing spend pulled forward |
| EBITDA ($M) | $188.5 | $158.3 | ($30.2) | (16.0%) | Cumulative: revenue miss + commodity + labor |
| EBITDA Margin % | 20.6% | 17.5% | (310 bps) | — | Largest single-quarter margin miss in four years |
| Net Income ($M) | $112.3 | $88.7 | ($23.6) | (21.0%) | Operating overruns; no tax benefit to offset |
Executive Summary — CFO Presentation Notes
1. Revenue missed budget by $14.2M. Traffic softness in casual dining persists; pricing is working but cannot fully compensate for volume decline.
2. Food & Beverage cost exceeded budget by 110 bps. Unhedged commodity exposure in poultry and dairy was the primary driver. Forward contracts must be extended into Q4.
3. Labor cost variance of 120 bps reflects CA wage floor increases and overtime premiums from scheduling execution gaps. Scheduling technology rollout must accelerate.
4. EBITDA of $158.3M missed the $188.5M plan by $30.2M — the largest quarterly shortfall in four years. A formal Q4 recovery plan is required.
5. Q4 recovery levers: expand commodity hedging, accelerate scheduling optimization, evaluate targeted menu price adjustments, freeze discretionary SG&A.
Section 3 — Break-Even Analysis: New Restaurant Location
Unit Economics | Fixed vs. Variable Cost Framework | Sensitivity Analysis
Before management approves a new location, the first question is: at what revenue level does this restaurant stop losing money? Break-even analysis defines that threshold. The sensitivity analysis around it defines the risk envelope.
Contribution Margin % = 1 − Total Variable Cost %
Break-Even Revenue = Total Fixed Costs ÷ Contribution Margin %
Break-Even Covers/Day = (Break-Even Revenue ÷ 365) ÷ Average Check
Fixed Cost Structure (Annual, $K per unit)
| Fixed Cost Item | Annual ($K) | Notes |
|---|---|---|
| Base Rent (NNN Lease) | $420.0 | ~$35K/month; 8,500 sq ft typical CAKE footprint |
| Salaried Management Labor | $385.0 | GM, Kitchen Manager, 4 Shift Managers, Training Manager |
| Utilities — Fixed Component | $96.0 | Base contracts; fixed regardless of volume |
| Liability & Property Insurance | $78.0 | CAKE portfolio insurance rate per unit |
| Depreciation (Leasehold, 10yr) | $145.0 | $1.45M buildout amortized over lease term |
| Technology & POS Licensing | $36.0 | POS, reservation management, loyalty platform |
| Equipment Loan Amortization | $62.0 | Equipment financing at 6.5% over 7 years |
| Marketing — Local Allocation | $48.0 | Corporate allocation for new location market entry |
| Other Fixed Overhead | $55.0 | Uniforms, smallwares, administrative support |
| TOTAL ANNUAL FIXED COSTS | $1,325.0 | Must be covered before the unit generates any profit |
Variable Cost Structure & Break-Even Calculation
| Variable Cost Item | % of Revenue | Notes |
|---|---|---|
| Food & Beverage Cost | 27.0% | CAKE FY2024 average |
| Hourly Labor (FOH + BOH) | 25.5% | Scales directly with covers served |
| Variable Utilities | 2.5% | Energy proportional to kitchen output |
| Credit Card Processing | 2.2% | Average merchant fee |
| Supplies & Paper Goods | 1.5% | Take-out packaging, cleaning supplies |
| TOTAL VARIABLE COST % | 58.7% | $0.587 of every revenue dollar goes to variable costs |
| CONTRIBUTION MARGIN % | 41.3% | $0.413 of every dollar is available to cover fixed costs |
| Break-Even Metric | Value | Interpretation |
|---|---|---|
| Break-Even Revenue (Annual) | $3,208K | = $1,325K ÷ 41.3% |
| Break-Even Revenue per Day | $8,789 | = $3,208K ÷ 365 |
| Break-Even Covers per Day | 304 | = $8,789 ÷ $28.90 avg check |
| CAKE Fleet Avg Covers/Day | ~1,600 | Mature units: margin of safety is substantial |
| Management Profitability Target | $3,850K | 120% of break-even; ~400 covers/day |
Sensitivity Analysis
| Scenario | Food Cost % | Traffic Change | B/E Revenue ($K) | vs. Base ($K) |
|---|---|---|---|---|
| Base Case | 27.0% | — | $3,208 | — |
| Food Cost +2% | 29.0% | — | $3,419 | +$211 |
| Food Cost +4% | 31.0% | — | $3,664 | +$456 |
| Traffic -5% | 27.0% | -5% | $3,377 | +$169 |
| Traffic -10% | 27.0% | -10% | $3,564 | +$356 |
| Combined Stress | 29.5% | -5% | $3,660 | +$452 |
| Best Case | 25.5% | +5% | $2,976 | ($232) |
Even in the combined stress scenario, break-even revenue only rises to $3.66M — well below a typical CAKE unit's Year 1 ramp revenue. The business model is resilient because fixed costs are low relative to the revenue a mature unit generates.
Section 4 — Operational KPIs That Drive Valuation
FY2022A–FY2024A | Revenue, Margin & EV/EBITDA Impact Framework
Stock price is ultimately a function of the market's expectations about future cash flows. For restaurant companies, those cash flows are driven by a small set of operational KPIs. Understanding how each KPI links to revenue, margin, and the EV/EBITDA multiple is the core competency of a financial analyst in this industry.
| KPI | FY2022A | FY2023A | FY2024A | Trend |
|---|---|---|---|---|
| REVENUE DRIVERS | ||||
| Same-Store Sales Growth | 2.1% | 3.2% | 1.4% | ▼ Decelerating |
| Guest Traffic (covers/wk/unit) | 5,840 | 5,950 | 5,780 | ▼ Pressure |
| Average Check ($) | $27.10 | $27.85 | $28.90 | ▲ Expanding |
| Unit Count (EOP) | 305 | 319 | 328 | ▲ Steady |
| Avg Unit Volume — AUV ($M) | $11.4M | $11.1M | $11.0M | ▼ Modest decline |
| MARGIN DRIVERS | ||||
| Food & Beverage Cost % | 27.2% | 27.1% | 27.0% | ▲ Improving |
| Labor Cost % | 35.5% | 35.3% | 35.2% | ▲ Improving |
| EBITDA Margin % | 19.1% | 19.6% | 19.9% | ▲ Expanding |
| Restaurant-Level Margin % | 20.2% | 20.8% | 21.1% | ▲ Best-in-class |
| VALUATION METRICS | ||||
| EV / EBITDA Multiple | 9.2x | 10.1x | 10.8x | ▲ Multiple expansion |
| P/E Ratio (trailing) | 18.3x | 20.4x | 22.1x | ▲ Premium to peers |
KPI Valuation Impact — Per 1-Unit Change
The table below quantifies how a single-unit change in each KPI flows through to EBITDA and enterprise value, assuming a 10.5x EV/EBITDA multiple on a $3.6B revenue base.
| KPI Change | Revenue Impact | EBITDA Impact | EV Impact | EPS Impact |
|---|---|---|---|---|
| REVENUE LEVERS | ||||
| Comp Sales +1% | +$36M | +$29M | +$305M | +$0.58 |
| Traffic +100 covers/wk/unit | +$17M | +$14M | +$147M | +$0.28 |
| New Unit (+10 locations) | +$110M | +$23M | +$242M | +$0.46 |
| COST LEVERS (highest leverage per bps) | ||||
| Food Cost -100 bps | — | +$36M | +$378M | +$0.72 |
| Labor Cost -100 bps | — | +$36M | +$378M | +$0.72 |
| Food Cost +100 bps (headwind) | — | ($36M) | ($378M) | ($0.72) |
Section 5 — NPV & IRR: Should CAKE Open 10 New Locations?
Capital Budgeting Case Study | WACC · DCF · Payback Period · Downside Scenarios
Every significant capital allocation decision requires demonstrating that projected returns exceed the cost of capital. For a $1.45M per-unit investment, management must show the board that the NPV is positive and the IRR clears the WACC hurdle before committing capital.
WACC Calculation — CAKE:
E/V = 84% equity | Re = 10.5% (CAPM) | D/V = 16% | Rd = 6.0% | Tax = 14%
WACC = (0.84 × 10.5%) + (0.16 × 6.0% × 0.86) = 8.3%
Cash Flow Projection — Per Unit ($K)
| Item | Yr 0 | Yr 1 | Yr 2 | Yr 3 | Yr 4 | Yr 5 | Yr 7 | Yr 10 |
|---|---|---|---|---|---|---|---|---|
| Capital Investment | ($1,450) | — | — | — | — | — | — | — |
| Revenue | — | $9,500 | $10,260 | $11,081 | $11,303 | $11,529 | $11,995 | $12,729 |
| Restaurant-Level EBITDA | — | $2,137 | $2,309 | $2,493 | $2,543 | $2,594 | $2,699 | $2,864 |
| Corp Overhead + Maint. CapEx | — | ($180) | ($180) | ($180) | ($180) | ($180) | ($180) | ($180) |
| Free Cash Flow per Unit | ($1,450) | $1,957 | $2,129 | $2,313 | $2,363 | $2,414 | $2,519 | $2,684 |
NPV / IRR Decision Summary
| Decision Metric | Per Unit | 10-Unit Program | Threshold | Signal |
|---|---|---|---|---|
| NPV | +$9,247K | +$92,470K | > $0 | APPROVE ✓ |
| IRR | 155% | 155% | > 8.3% WACC | APPROVE ✓ |
| Payback Period | < 1 year | < 1 year | Target < 6 yrs | Exceptional ✓ |
| EV/EBITDA at Cost (Yr 1) | 0.68x | 0.68x | < 8x target | Well below ✓ |
Downside Scenario Analysis
| Scenario | Yr 1 AUV ($K) | NPV/Unit ($K) | IRR | Payback (yrs) | Decision |
|---|---|---|---|---|---|
| Base Case | $9,500 | $9,247 | 155% | <1 | Approve ✓ |
| AUV -20% | $7,600 | $6,578 | 102% | 1.1 | Approve ✓ |
| AUV -30% | $6,650 | $5,244 | 76% | 1.3 | Approve ✓ |
| AUV -50% (severe stress) | $4,750 | $2,576 | 24% | 2.0 | Approve ✓ |
| AUV -65% (failure case) | $3,325 | ($247) | 7.8% | 2.9 | Marginal ✗ |
Management Decision: APPROVE the 10-Unit Program
NPV is strongly positive at $92.5M for the program. IRR of 155% far exceeds the 8.3% WACC hurdle. Payback in under 12 months is among the fastest in casual dining. The NPV only turns negative if AUV falls 65% below the base case — a fundamentally broken site selection outcome that CAKE's location scoring process is designed to prevent. The real management question is not whether to expand, but how fast organizational capacity allows.
Download the Excel Financial Model
The complete 5-tab CAKE workbook — 3-Statement Model, Variance Analysis, Break-Even, KPI Dashboard, and Capital Budget — with 140 linked formulas, industry-standard color coding, and source documentation.
Download CAKE Financial Model (.xlsx)Microsoft Excel required. Tested with Excel 2016+ and Google Sheets.
Disclaimer: All analysis and projections in this article are hypothetical models constructed for educational and portfolio purposes only. Numbers do not represent actual reported results. Source data: CAKE 10-K FY2024, SEC EDGAR. This is not investment advice. Past performance does not guarantee future results.