Skip to main content

    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
    ABCDEFG
    1Project Ridge · LBO cash flow & debt ($M)
    2
    3Assumptions
    4Revenue, Year 0$500.0
    5Revenue growth6%
    6EBITDA margin20%
    7D&A (% of revenue)3%
    8Capex (% of revenue)4%
    9NWC (% of change in revenue)10%
    10Tax rate25%
    11Interest rate8%
    12Opening debt$450.0
    13
    14Year12345
    15Revenue$530.0$561.8$595.5$631.2$669.1
    16EBITDA$106.0$112.4$112.4$126.2$133.8
    17D&A$15.9$16.9$17.9$18.9$20.1
    18EBIT$90.1$95.5$94.5$107.3$113.8
    19Interest expense$36.0$36.0$33.1$30.2$29.4
    20Taxes$22.5$14.9$15.3$19.3$21.1
    21Net income$31.6$44.6$46.0$57.8$63.3
    22Capex$21.2$22.5$23.8$25.2$26.8
    23Increase in NWC$3.0$3.2$3.4$3.6$3.8
    24Free cash flow$23.3$35.8$36.7$10.1$52.8
    25Beginning debt$450.0$450.0$414.2$377.5$367.4
    26Debt paydown$23.3$35.8$36.7$10.1$52.8
    27Ending debt$426.7$414.2$377.5$367.4$314.6