Valuing Basil & Co: A Five-Year DCF
A private equity client is considering acquiring Basil & Co, a quick service restaurants business in India. You have been asked to build the valuation case.
The company generated ₹881 Cr of revenue last year at an EBIT margin of 23%. Management projects revenue growth of 6% 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 5%. Changes in net working capital consume roughly 2% of incremental revenue. The effective tax rate is 27%.
The company's equity beta is 1.46, the risk-free rate is 6.4%, and the equity risk premium is 6.4%. Debt carries a pre-tax cost of 10.3% and makes up 45% of the capital structure.
The seller is asking ₹1217 Cr for the enterprise.
operating
- revenue cr
- 881
- tax rate pct
- 27
- ebit margin pct
- 23
- da pct of revenue
- 5
- revenue growth pct
- 6
- capex pct of revenue
- 9
- nwc pct of incremental revenue
- 2
transaction
- asking enterprise value cr
- 1217
capital structure
- equity beta
- 1.46
- debt weight pct
- 45
- risk free rate pct
- 6.4
- equity risk premium pct
- 6.4
- pre tax cost of debt pct
- 10.3
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 ₹1217 Cr 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 = 6.4% + 1.46 × 6.4% = 15.74%
- After-tax cost of debt = 10.3% × (1 − 27%) = 7.52%
- 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.