Valuing Basil & Co: A Five-Year DCF

Finance
medium60 min0 submissions
Morgan Stanley
Scenario

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.

Supporting data

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
Your task

Value the business and advise on the asking price. Provide:

  1. Analysis — a five-year free cash flow projection, your WACC, and a terminal value.
  2. Risks — the assumptions your valuation is most sensitive to.
  3. Recommendation — is ₹1217 Cr attractive? What would you pay?

Show your calculations. State assumptions explicitly where the case is silent.

Ready to move forward? Up next: Halcyon Bank: Can We Raise Prices 16%?Next question
How you'll be graded

100 points, 60% to pass.

  • discount rate20
  • recommendation20
  • terminal value20
  • cash flow projection25
  • sensitivity analysis15
Hint
Reveal suggested structure
  1. Free cash flow for each of years 1-5: FCF = EBIT × (1 − t) + D&A − capex − ΔNWC

  2. 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
  3. 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.

  4. Discount everything to today, sum, and compare with the asking price.

  5. Sensitivity across WACC and terminal growth.