Case 060LBO modelling testsCore
Standard one-hour LBO test: revenue Rs 600 crore growing 12% at a 15% margin, bought at 10x with 5x debt, exit at 10x in year 5. Give the returns and a two-way sensitivity of entry and exit multiple.
1The situation
Tikhi Mirch Snacks makes regional savoury snacks sold through general trade. Revenue is Rs 600 crore growing 12% a year, and EBITDA margin is 15% and holds, so EBITDA is Rs 90 crore today. Cash conversion before interest, after capex, tax and working capital, is 50% of EBITDA, and all cash after interest repays debt.
The fund pays 10x, Rs 900 crore, with 5x debt, Rs 450 crore, at 10% on opening balances, and Rs 450 crore of equity. The base exit is at 10x after five years. You have an hour and a blank workbook.
2Your task
Give the base MOIC and IRR, build a two-way table of IRR for entry multiples of 9x to 11x against exit multiples of 9x to 11x, and say what the diagonal means.
Quick check
Entry at 10x and exit at 10x: what is the IRR driven by?
Worked solution
Try it on paper, then open one step at a time.
30-second answerThe answer to give first
About 2.8x and 23% in the base case. EBITDA grows at 12% to Rs 159 crore, worth Rs 1,586 crore at 10x; five years of cash after 10% interest repay Rs 108 crore, leaving Rs 342 crore of debt, so equity is Rs 1,244 crore on Rs 450 crore. In the two-way table the diagonal, where entry equals exit, shows the return from operations alone, 25% to 21%, and every cell off it is a bet on the market re-pricing the business.
Step 1What do you build in the first twenty minutes?
Operating lines, debt schedule, returns, in that order, with every input in one block at the top so the sensitivity table can drive them. Think of a tailor who cuts the pattern before touching the cloth: the inputs block is the pattern. Revenue compounds at 12%, EBITDA is 15% of it, half of EBITDA is cash before interest, interest is 10% of opening debt, and the difference repays debt. Year 1 cash before interest is Rs 50.4 crore against Rs 45.0 crore of interest, so only Rs 5.4 crore is repaid; by year 5 it is Rs 41.0 crore. At 5x leverage the sweep is slow, and you should say so.
| Year | Revenue | EBITDA | Cash before interest | Interest | Debt repaid | Debt at year end |
|---|---|---|---|---|---|---|
| 1 | 672 | 100.8 | 50.4 | 45.0 | 5.4 | 444.6 |
| 2 | 753 | 112.9 | 56.4 | 44.5 | 12.0 | 432.6 |
| 3 | 843 | 126.4 | 63.2 | 43.3 | 20.0 | 412.7 |
| 4 | 944 | 141.6 | 70.8 | 41.3 | 29.5 | 383.1 |
| 5 | 1057 | 158.6 | 79.3 | 38.3 | 41.0 | 342.1 |
| Total | 320.2 | 212.3 | 107.9 | 342.1 |
Step 2What is the base return, and which engine is it?
Exit equity over entry equity. Rs 1,586 crore less Rs 342 crore is Rs 1,244 crore on Rs 450 crore, 2.76x and 22.6%, of which EBITDA growth at a constant 10x contributes Rs 686 crore and paydown Rs 108 crore. Growth is the engine; the debt is there to make the equity cheque small rather than to be repaid. A cash sweepA loan term that sends all free cash flow to repay the loan rather than letting the company keep it. on a 5x deal with 50% conversion starts slowly because interest alone is Rs 45 crore in year 1.
Step 3What does the two-way table show, and why does the diagonal matter?
Nine returns, one of which is the business and eight of which are the market. Along the diagonal, where you sell at the multiple you paid, the return is 25% at 9x, 23% at 10x and 21% at 11x: growth and paydown only, falling as the equity cheque grows. Above the diagonal you are paid for the market re-rating the business; below it you are punished for buying high and selling low, and 11x in with 9x out earns 15%. The investment committee reads the diagonal first, because that is the return the fund controls.
Step 4What do you say in the discussion after the model?
That the base case clears a 20% hurdle on growth alone, and what would break it. The 12% growth is the whole story; at 6% growth the diagonal falls to about 14% even before the slower paydown that lower EBITDA brings. So diligence is about distribution reach and whether general trade growth holds as modern trade takes share, and the structure point is that 5x at 10% leaves little room for a bad year. The limitation: the model holds the margin at 15% and conversion at 50% as revenue doubles, and a snacks business adding capacity usually does neither in the build years.
Where candidates lose it
The usual loss is hard-coding the entry equity, so the sensitivity table changes the exit value but not the cheque, and every entry row shows the same IRR pattern. Entry equity must be a formula off the entry multiple for the table to mean anything.
The second is reading the best cell as the answer. The committee reads the diagonal; a return that needs the market to pay a turn more than you did is a view on the market, and you should say so before they do.
What the interviewer asks next
- Margin expands to 17% by year 5. Rework the diagonal.
- Leverage is 4x at 9% instead of 5x at 10%. Does the IRR rise or fall?
- What does the table look like if the exit is in year 3 instead of year 5?
- Why does the IRR fall along the diagonal as the multiple rises, even though the multiple is unchanged?
Asked at Warburg Pincus, Technology Consulting, New York, 2020 (Wall Street Oasis): This was followed by a typical LBO modeling test.
Company names and figures are illustrative.
