Valuing Kirana Connect: A Five-Year DCF

Finance
medium60 min0 submissions
Razorpay
Scenario

A private equity client is considering acquiring Kirana Connect, a retail tech business in India. You have been asked to build the valuation case.

The company generated ₹895 Cr of revenue last year at an EBIT margin of 26%. Management projects revenue growth of 10% per year for five years, after which the business is expected to settle into mature, GDP-like growth.

Capital expenditure runs at 7% of revenue and depreciation & amortisation at 6%. Changes in net working capital consume roughly 2% of incremental revenue. The effective tax rate is 27%.

The company's equity beta is 1.16, the risk-free rate is 4.6%, and the equity risk premium is 4.8%. Debt carries a pre-tax cost of 10.8% and makes up 34% of the capital structure.

The seller is asking ₹2662 Cr for the enterprise.

Supporting data

operating

revenue cr
895
tax rate pct
27
ebit margin pct
26
da pct of revenue
6
revenue growth pct
10
capex pct of revenue
7
nwc pct of incremental revenue
2

transaction

asking enterprise value cr
2662

capital structure

equity beta
1.16
debt weight pct
34
risk free rate pct
4.6
equity risk premium pct
4.8
pre tax cost of debt pct
10.8
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 ₹2662 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 = 4.6% + 1.16 × 4.8% = 10.17%
    • After-tax cost of debt = 10.8% × (1 − 27%) = 7.88%
    • WACC = 66% × cost of equity + 34% × 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.