Vantage Analytics: Two Projects, One Budget
Vantage Analytics, a B2B SaaS company in India, has two capital projects competing for approval and only ₹267 Cr of approved capital this year.
Project A — Automation upgrade. Requires ₹57 Cr upfront and is expected to generate ₹34 Cr of incremental after-tax cash flow per year for 6 years.
Project B — New production line. Requires ₹388 Cr upfront and is expected to generate ₹88 Cr per year for 11 years.
The company's hurdle rate is 12%.
Two complications. First, the finance team has already spent ₹18 Cr 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
- 6
- investment cr
- 57
- annual cash flow cr
- 34
project b
- life years
- 11
- investment cr
- 388
- annual cash flow cr
- 88
constraints
- hurdle rate pct
- 12
- capital budget cr
- 267
- already spent on b studies cr
- 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 Cr 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.