Northwind Energy: Two Projects, One Budget
Northwind Energy, a renewables company in Europe, has two capital projects competing for approval and only €133 M of approved capital this year.
Project A — Automation upgrade. Requires €68 M upfront and is expected to generate €16 M of incremental after-tax cash flow per year for 9 years.
Project B — New production line. Requires €154 M upfront and is expected to generate €106 M per year for 7 years.
The company's hurdle rate is 12%.
Two complications. First, the finance team has already spent €18 M on engineering studies for Project B, and the COO argues this money "shouldn't be wasted". Second, Project B's cash flows depend on a customer contract that is signed but renews annually.
project a
- life years
- 9
- investment m
- 68
- annual cash flow m
- 16
project b
- life years
- 7
- investment m
- 154
- annual cash flow m
- 106
constraints
- hurdle rate pct
- 12
- capital budget m
- 133
- already spent on b studies m
- 18
Recommend how to allocate the capital budget. Provide:
- Analysis — NPV, IRR and payback for each project.
- Risks — including how you treat the engineering spend and the contract renewal risk.
- Recommendation — which project (or projects) to fund.
100 points, 60% to pass.
- assumptions20
- recommendation30
- risk assessment20
- financial analysis30
Reveal suggested structure
- NPV of each project using the annuity form: NPV = CF × [(1 − (1+r)^−n) ÷ r] − I₀
- IRR — the rate at which NPV = 0. Note that IRR alone misranks projects of different scale.
- Payback as a liquidity check, not a decision rule.
- Sunk cost — the €18 M is spent and irrecoverable. It must not enter the decision.
- Profitability index (NPV ÷ investment) when capital is rationed.
- Risk-adjust Project B for the annual renewal.