“As a financial analyst, you're asked in an interview: "Walk me through how you would build a full discounted cash flow (DCF) valuation from scratch — project the unlevered free cash flows, determine the discount rate, estimate a terminal value, and bridge the result down to an equity value per share." Walk through how you'd answer that question, using a five-year operating forecast to build the complete model end to end.”
As a financial analyst, you're asked in an interview: "Walk me through how you would build a full discounted cash flow (DCF) valuation from scratch — project the unlevered free cash flows, determine the discount rate, estimate a terminal value, and bridge the result down to an equity value per share." Walk through how you'd answer that question, using a five-year operating forecast to build the complete model end to end.
Task: take a five-year operating forecast and build it into a full enterprise-to-equity valuation, the same way you would size up any company from scratch.
The forecast starts from a Year 0 revenue base, together with the operating, financing, and capital structure assumptions needed to build the model end to end.
| Line Item | Value |
|---|---|
| Current Year (Year 0) Revenue | $500.0m |
| Year 1 Revenue Growth | 10.0% (0.10) |
| Year 2 Revenue Growth | 8.0% (0.08) |
| Year 3 Revenue Growth | 7.0% (0.07) |
| Year 4 Revenue Growth | 6.0% (0.06) |
| Year 5 Revenue Growth | 5.0% (0.05) |
| EBITDA Margin (all years) | 22.0% (0.22) |
| D&A (% of Revenue) | 4.0% (0.04) |
| CapEx (% of Revenue) | 5.0% (0.05) |
| Increase in Net Working Capital (% of Revenue growth) | 2.0% (0.02) |
| Tax Rate | 25.0% (0.25) |
| Cost of Equity (Re) | 11.0% (0.11) |
| Pre-Tax Cost of Debt (Rd) | 5.0% (0.05) |
| Target Equity Weight, E/(D+E) | 60.0% (0.60) |
| Target Debt Weight, D/(D+E) | 40.0% (0.40) |
| Terminal Growth Rate (g) | 2.5% (0.025) |
| Net Debt | $300.0m |
| Shares Outstanding | 100.0m |
Revenue (Year t) = Revenue (Year t-1) × (1 + Growth Rate, Year t)
Using this formula, compute Revenue for Year 1 through Year 5.
EBITDA = Revenue × EBITDA Margin; D&A = Revenue × D&A %; EBIT = EBITDA - D&A
Using this formula, compute EBITDA, D&A, and EBIT for each year.
Unlevered FCF = EBIT × (1 - Tax Rate) + D&A - CapEx - Increase in Net Working Capital
Using this formula, compute Unlevered FCF for each year.
WACC = (E/(D+E) × Re) + (D/(D+E) × Rd × (1 - Tax Rate))
Using this formula, compute the discount rate used for the entire model.
Terminal Value = FCF (Year 5) × (1 + g) / (WACC - g)
Using this formula, compute the Terminal Value as of the end of Year 5.
PV = Cash Flow (Year t) / (1 + WACC)^t; Enterprise Value = Sum of PV(Unlevered FCF, Year 1-5) + PV(Terminal Value)
Using this formula, discount each year's Unlevered FCF and the Terminal Value back to the present, then sum them into an Enterprise Value.
Equity Value = Enterprise Value - Net Debt; Value Per Share = Equity Value / Shares Outstanding
Using this formula and the assumptions given in Step 1, compute Equity Value and the implied Value Per Share.
Try answering out loud first — then reveal the model answer and compare.
No comments yet — be the first to ask a question.