Valuation and returns · in 5 models

Returns analysis

Exit value, MOIC, IRR and the bridge.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: returns analysis.Updated 30 September 2026

Part of m&a and private equity models, with the models, labs and guides around it.

Part of project finance and infrastructure models, with the models, labs and guides around it.

Part of healthcare financial models, with the models, labs and guides around it.

What it does

The answer sheet of a buyout. Exit EBITDA times the exit multiple gives enterprise value; less net debt on that date gives the equity; divided by the equity invested gives the multiple of money; annualised over the hold gives the IRR. A value-creation bridge then says how much of the gain came from earnings growth, how much from the multiple, and how much from paying debt down.

Where it lives

The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.

Leveraged buyout model
  • Assumptions, row 43: Exit multiple, EV / EBITDA
  • Returns, rows 6–9: Exit EBITDA, Year 5, Exit enterprise value, Less net debt at exit, Exit equity value
  • Returns, rows 12–18: Total equity invested at close, Total equity cash flows, Multiple of money (MOIC), IRR…
  • Returns, rows 21–27: EBITDA growth, Multiple expansion / (contraction), Net debt reduction, Less transaction and financing fees…
Carve-out and standalone cost model
  • Buyer, rows 52–61: Exit EBITDA: FY5 run-rate standalone, Exit enterprise value, Less: net debt at exit, Exit equity value…
Telecom tower model: tenancies per tower
  • Valuation, rows 24–34: Entry enterprise value, Transaction costs, Equity cheque at close, Entry price above or below the DCF…
  • Valuation, rows 37–40: Equity value at the hurdle return, Highest entry enterprise value at the hurdle, Highest entry multiple at the hurdle, Highest entry multiple above or below the entry multiple
Healthcare services model: hospital operator
  • Assumptions, row 76: Exit multiple, EV / FY5 EBITDA
  • Returns, rows 17–21: EBITDA, FY5, Enterprise value at exit, Less: loan outstanding, Add: cash…
  • Returns, rows 24–26: Equity cash flow, Equity IRR, Multiple of money
  • Returns, rows 29–34: EBITDA growth at the entry multiple, Change in multiple, Debt repaid and cash built, Less: transaction fees…
ICG management buyout model
  • Assumptions, rows 84–85: Exit multiple, EV / EBITDA, Holding period
  • Exit & Returns, rows 21–31: Exit EBITDA, Exit enterprise value, Less net debt at exit, Equity proceeds…
  • Exit & Returns, rows 34–40: Ordinary equity cash flows, Preferred investor cash flows, Ordinary MOIC, Ordinary IRR…
  • Exit & Returns, rows 43–47: Team shares at the offer price, Cash taken at close, Exit proceeds, Cash at close + exit proceeds…
  • Exit & Returns, rows 50–60: EBITDA growth at the entry multiple, Multiple expansion / (contraction), Net debt reduction, Less transaction and financing costs…

What a reviewer looks for

  • IRR computed on the wrong number of years.
  • Net debt at exit taken from the wrong year.
  • A bridge that does not add up to the gain, because the fees were forgotten.

Learn it, then build it

Vocabulary: IRR, Leverage Model.

Other valuation and returns