Valuing Halcyon Bank: A Five-Year DCF
A private equity client is considering acquiring Halcyon Bank, a retail banking business in UK. You have been asked to build the valuation case.
The company generated £200 M of revenue last year at an EBIT margin of 16%. Management projects revenue growth of 15% per year for five years, after which the business is expected to settle into mature, GDP-like growth.
Capital expenditure runs at 9% of revenue and depreciation & amortisation at 6%. Changes in net working capital consume roughly 3% of incremental revenue. The effective tax rate is 25%.
The company's equity beta is 1.49, the risk-free rate is 5.4%, and the equity risk premium is 6.4%. Debt carries a pre-tax cost of 9.5% and makes up 45% of the capital structure.
The seller is asking £1428 M for the enterprise.
operating
- revenue m
- 200
- tax rate pct
- 25
- ebit margin pct
- 16
- da pct of revenue
- 6
- revenue growth pct
- 15
- capex pct of revenue
- 9
- nwc pct of incremental revenue
- 3
transaction
- asking enterprise value m
- 1428
capital structure
- equity beta
- 1.49
- debt weight pct
- 45
- risk free rate pct
- 5.4
- equity risk premium pct
- 6.4
- pre tax cost of debt pct
- 9.5
Value the business and advise on the asking price. Provide:
- Analysis — a five-year free cash flow projection, your WACC, and a terminal value.
- Risks — the assumptions your valuation is most sensitive to.
- Recommendation — is £1428 M attractive? What would you pay?
Show your calculations. State assumptions explicitly where the case is silent.
100 points, 60% to pass.
- discount rate20
- recommendation20
- terminal value20
- cash flow projection25
- sensitivity analysis15
Reveal suggested structure
-
Free cash flow for each of years 1-5: FCF = EBIT × (1 − t) + D&A − capex − ΔNWC
-
WACC:
- Cost of equity = 5.4% + 1.49 × 6.4% = 14.94%
- After-tax cost of debt = 9.5% × (1 − 25%) = 7.13%
- WACC = 55% × cost of equity + 45% × after-tax cost of debt
-
Terminal value at year 5, using either perpetuity growth (g below long-run GDP) or an exit EBITDA multiple. Sanity-check one against the other.
-
Discount everything to today, sum, and compare with the asking price.
-
Sensitivity across WACC and terminal growth.