Valuing Northwind Energy: A Five-Year DCF
A private equity client is considering acquiring Northwind Energy, a renewables business in Europe. You have been asked to build the valuation case.
The company generated €312 M of revenue last year at an EBIT margin of 12%. 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 8% of revenue and depreciation & amortisation at 6%. Changes in net working capital consume roughly 5% of incremental revenue. The effective tax rate is 24%.
The company's equity beta is 1.03, the risk-free rate is 5.3%, and the equity risk premium is 4.6%. Debt carries a pre-tax cost of 7% and makes up 28% of the capital structure.
The seller is asking €2398 M for the enterprise.
operating
- revenue m
- 312
- tax rate pct
- 24
- ebit margin pct
- 12
- da pct of revenue
- 6
- revenue growth pct
- 15
- capex pct of revenue
- 8
- nwc pct of incremental revenue
- 5
transaction
- asking enterprise value m
- 2398
capital structure
- equity beta
- 1.03
- debt weight pct
- 28
- risk free rate pct
- 5.3
- equity risk premium pct
- 4.6
- pre tax cost of debt pct
- 7
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 €2398 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.3% + 1.03 × 4.6% = 10.04%
- After-tax cost of debt = 7% × (1 − 24%) = 5.32%
- WACC = 72% × cost of equity + 28% × 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.