01 / Learn the method
Learning outcomes
Compare two valuation lenses and expose sensitivity instead of hiding it. Calculate the result, reconcile it and communicate its limitations.
Method
Discount unlevered free cash flow at a consistent enterprise discount rate. With end-of-year cash flows and perpetual growth, terminal value at year N is FCF(N) × (1+g) / (r-g), requiring r > g. Discount terminal value back N years. Comparable multiples are a cross-check, not evidence that every business deserves the median.
Smaller worked example
A separate $100 cash flow received in one year has a $90.91 present value at 10%. A terminal value computed at the end of year 3 must be divided by (1+r)^3, not (1+r)^4.
02 / Put it to work
Business context and rules
Fictional Brook Software, valuation date 30 September 2026. All money is USD thousands. The three forecast years have unlevered FCF 100 / 120 / 140 paid at each year end. Base discount rate 10%; perpetual growth 2%. Reference EBITDA 150. Synthetic peer EV / EBITDA values are 5x, 6x, 7x and are already sorted; assume the EBITDA definition is matched. No net debt bridge is required. Sensitivity grid: discount rates 8%, 10%, 12% and terminal growth 1%, 2%, 3%. These are teaching assumptions, not live market estimates.
Original synthetic inputs
| Input | Value | Unit |
|---|---|---|
| Year 1 unlevered free cash flow | 100 | USD thousands |
| Year 2 unlevered free cash flow | 120 | USD thousands |
| Year 3 unlevered free cash flow | 140 | USD thousands |
| Base discount rate | 0.1 | fraction |
| Base terminal growth | 0.02 | fraction |
| Comparable reference EBITDA | 150 | USD thousands |
| Synthetic peer A EV / EBITDA | 5 | multiple |
| Synthetic peer B EV / EBITDA | 6 | multiple |
| Synthetic peer C EV / EBITDA | 7 | multiple |
Required deliverables
Deliver a three-year DCF, a 3×3 sensitivity table, low / median / high comparable EV and a 200-word valuation note. Explain the divergence and name diligence questions on reinvestment, cash conversion and peer comparability. Do not average incompatible results without rationale.
Use formulas for derived amounts and preserve source data. Put narrative deliverables in the workbook response area; expand it as needed. Compare amounts within 0.01 of the stated unit and percentages within 0.1 percentage point. No unsupported balancing plugs.
03 / Review your work
Try the assignment before opening the answer.
Open the worked answer and teaching notes
Worked numerical schedule
| Measure | Value | Unit |
|---|---|---|
| PV year 1 FCF | 90.91 | USD thousands |
| PV year 2 FCF | 99.17 | USD thousands |
| PV year 3 FCF | 105.18 | USD thousands |
| Terminal value at end year 3 | 1,785.00 | USD thousands |
| PV terminal value | 1,341.10 | USD thousands |
| DCF enterprise value | 1,636.36 | USD thousands |
| Peer low EV | 750.00 | USD thousands |
| Peer median EV | 900.00 | USD thousands |
| Peer high EV | 1,050.00 | USD thousands |
| Terminal value share of DCF | 0.82 | fraction |
| DCF: 8% discount / 1% growth | 1,910.15 | USD thousands |
| DCF: 8% discount / 2% growth | 2,195.93 | USD thousands |
| DCF: 8% discount / 3% growth | 2,596.02 | USD thousands |
| DCF: 10% discount / 1% growth | 1,475.67 | USD thousands |
| DCF: 10% discount / 2% growth | 1,636.36 | USD thousands |
| DCF: 10% discount / 3% growth | 1,842.98 | USD thousands |
| DCF: 12% discount / 1% growth | 1,199.56 | USD thousands |
| DCF: 12% discount / 2% growth | 1,301.02 | USD thousands |
| DCF: 12% discount / 3% growth | 1,425.03 | USD thousands |
| Base DCF versus sensitivity residual | 0.00 | USD thousands |
Interpretation and recommended actions
Base terminal value is 1,785 (USD thousands). Base EV is about 1,636.36, compared with 750 / 900 / 1,050 from peers. Most DCF value is terminal, so the implied mature cash conversion and reinvestment deserve scrutiny. Present both ranges with assumptions; do not call the peer range observed market evidence because it is synthetic. A higher perpetual growth rate must be consistent with the reinvestment needed to support it.
Scoring rubric - 100 points
| Dimension | Points | Awarding guidance |
|---|---|---|
| Calculation | 40 | Yearly DCF 12; terminal value 8; sensitivities 12; comparable values 8. |
| Interpretation | 25 | Correct application of the case rules 10; explain the business decision 10; identify evidence or limitations 5. |
| Controls / audit trail | 20 | Traceable formulas 8; independent reconciliation 8; explicit units and signs 4. |
| Communication | 15 | Decision and numerical headline 5; actions with owners and evidence 5; concise response covering all required deliverables 5. |
Award method credit after an isolated arithmetic error rather than repeatedly deducting for it. Equivalent account labels and well-supported alternative recommendations are acceptable. Numerical tolerance is 0.01 in the stated units; no universal passing score is prescribed.
Common mistakes
Discounting terminal value one extra year; using a growth rate at or above the discount rate; treating synthetic peers as market evidence.
Staged hints
Calculate yearly PV first. Put terminal value at year 3. The 10% / 2% grid result must equal the base DCF.
Instructor notes
Prerequisites: Free cash flow, discounting and multiples. Suggested use of the estimated 90 minutes: spend roughly 15% on the lesson and smaller example, 55% on the independent task, 20% on comparing approaches and 10% on the decision discussion. Timing is untested. Ask learners to explain why the numerical check is necessary but not sufficient.
For a simpler class, provide the model structure and work through one driver. For an extension, change one operational assumption and require a new reconciliation and recommendation. Verify the new key before distributing any variant. Open files in the intended spreadsheet application before class. Solutions are learning resources, not secure hiring examinations. Expert review remains pending.
Continue this learning path
IBA-01 · From Enterprise Value to Equity Value
IBA-03 · Should We Buy It? An Acquisition Investment Case
AI-assisted synthetic teaching case. Expert review and native Excel / Sheets testing pending.