🧮 Financial Modeling Lab: Five-Year DCF and Sensitivity Grid

2D interactive simulation · educational model

The science

Free cash flow. Revenue grows at g for five years; EBIT = margin × revenue; NOPAT = EBIT(1−tax); free cash flow is FCF = NOPAT − reinvestment, where reinvestment is a fixed share of NOPAT (a deliberate simplification: real models tie it to capital turnover).

Discounting. EV = Σ FCFt/(1+WACC)t + TV/(1+WACC)5 with the Gordon terminal value TV = FCF5(1+gT)/(WACC−gT). It requires WACC > gT; as they approach, the value explodes, which is why the sensitivity grid exists.

Checks. The terminal value is compared with an explicit 2,000-year cash-flow sum, and the no-growth case with the perpetuity NOPAT/WACC.

Honest simplifications. One revenue line, no working capital, debt, depreciation or share count; a constant margin; inputs are illustrative. A real model is as good as its assumptions. This is not investment advice.