This week's audit · resets in 8h 4m
An AI built this model. Five cells are wrong.
An AI drafted this LBO cash flow and debt schedule for Ridge Packaging. It looks finished. Five cells are wrong. Find them and fix them; every fix is graded against hidden scenarios, so a typed-in number won't pass.
Project Ridge · LBO cash flow + debt schedule · 65 formulas. Tap a cell to see its formula, fix the wrong ones. Hints cost 30 seconds. Free, no signup.
—fx
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Project Ridge · LBO cash flow & debt ($M) | ||||||
| 2 | |||||||
| 3 | Assumptions | ||||||
| 4 | Revenue, Year 0 | $500.0 | |||||
| 5 | Revenue growth | 6% | |||||
| 6 | EBITDA margin | 20% | |||||
| 7 | D&A (% of revenue) | 3% | |||||
| 8 | Capex (% of revenue) | 4% | |||||
| 9 | NWC (% of change in revenue) | 10% | |||||
| 10 | Tax rate | 25% | |||||
| 11 | Interest rate | 8% | |||||
| 12 | Opening debt | $450.0 | |||||
| 13 | |||||||
| 14 | Year | 1 | 2 | 3 | 4 | 5 | |
| 15 | Revenue | $530.0 | $561.8 | $595.5 | $631.2 | $669.1 | |
| 16 | EBITDA | $106.0 | $112.4 | $112.4 | $126.2 | $133.8 | |
| 17 | D&A | $15.9 | $16.9 | $17.9 | $18.9 | $20.1 | |
| 18 | EBIT | $90.1 | $95.5 | $94.5 | $107.3 | $113.8 | |
| 19 | Interest expense | $36.0 | $36.0 | $33.1 | $30.2 | $29.4 | |
| 20 | Taxes | $22.5 | $14.9 | $15.3 | $19.3 | $21.1 | |
| 21 | Net income | $31.6 | $44.6 | $46.0 | $57.8 | $63.3 | |
| 22 | Capex | $21.2 | $22.5 | $23.8 | $25.2 | $26.8 | |
| 23 | Increase in NWC | $3.0 | $3.2 | $3.4 | $3.6 | $3.8 | |
| 24 | Free cash flow | $23.3 | $35.8 | $36.7 | $10.1 | $52.8 | |
| 25 | Beginning debt | $450.0 | $450.0 | $414.2 | $377.5 | $367.4 | |
| 26 | Debt paydown | $23.3 | $35.8 | $36.7 | $10.1 | $52.8 | |
| 27 | Ending debt | $426.7 | $414.2 | $377.5 | $367.4 | $314.6 | |