Case 095LBO modelling testsCore
Model debrief: your model shows about 31% IRR on Rs 300 crore of revenue, margin rising from 30% to 40%, entry at 20x EBITDA with 6x debt and exit at 18x in year 5. Which three assumptions drive the IRR, and what is it if the margin stays at 30%?
1The situation
You built the model for Orvel Software, a vertical software company, in the three-hour test. Revenue Rs 300 crore growing 18% a year; EBITDA margin 30% today rising in a straight line to 40% by year 5; entry at 20x EBITDA of Rs 90 crore, Rs 1,800 crore, with 6x debt at 9%; depreciation and capex Rs 10 crore each; tax 25%; all cash repays debt; exit at 18x in year 5. The model prints an IRR of about 31%.
In the debrief the interviewer asks which three assumptions the return rests on, in order, and what the IRR is if the margin never moves.
2Your task
Rank the drivers, give the IRR with a flat 30% margin, and say what the ranking means for diligence.
Quick check
Entry is 20x and exit 18x. Does the multiple contraction stop this deal from working?
Worked solution
Try it on paper, then open one step at a time.
30-second answerThe answer to give first
Margin first, exit multiple second, growth third; with a flat 30% margin the IRR drops from about 31% to about 23%. Moving margin between 30% and 45% swings IRR from 23% to 35%; the exit multiple between 14x and 22x swings it from 25% to 37%; growth between 10% and 26% swings it from 21% to 41%. Ten points of margin on Rs 686 crore of year 5 revenue is Rs 69 crore of EBITDA at 18x, and that is most of the return.
Step 1How do you find out which assumption carries the answer?
Move each one alone and watch the IRR, the way you would test which tap is leaking by closing them one at a time. Hold two of the three at base, swing the third across a plausible range, and the width of each swing is that assumption's weight. The base case has EBITDA rising from Rs 90 crore to about Rs 275 crore, exit value of about Rs 4,942 crore and debt down to about Rs 17 crore, so Rs 1,260 crore of equity becomes about Rs 4,924 crore, 3.91x. The debrief is not asking you to recite the model; it is asking whether you know which cell you would check first if the deal went wrong.
Step 2What happens if the margin never moves?
Year 5 revenue is about Rs 686 crore either way. At 40% that is Rs 275 crore of EBITDA; at 30% it is Rs 206 crore, Rs 69 crore less, which at 18x is Rs 1,235 crore of exit value gone; the IRR falls to about 23%. Less cash is generated along the way too, so debt at exit is about Rs 153 crore instead of Rs 17 crore. The return does not vanish, because 18% growth at 18x still works, but it goes from a top-quartile deal to an ordinary one on a single assumption, and that is the sentence the interviewer is waiting for.
| Case | Year 5 EBITDA | Exit equity | MOIC | IRR |
|---|---|---|---|---|
| Base: 18% growth, 40% margin, 18x | 275 | 4,924 | 3.91x | 31.3% |
| Margin stays at 30% | 206 | 3,553 | 2.82x | 23.0% |
| Exit at 14x | 275 | 3,826 | 3.04x | 24.9% |
| Growth 10% | 193 | 3,304 | 2.62x | 21.3% |
| Margin 45% | 309 | 5,610 | 4.45x | 34.8% |
Step 3What does the ranking mean for diligence and for the memo?
That the margin plan is the deal. Ten points of margin on a software company means cutting sales and marketing as a share of revenue, raising prices, or pushing gross margin up by moving customers to cloud; each is a different plan with different evidence, and the memo should say which one and show the cost lines that move. The exit multiple is second: a 18x exit on a business that has just finished expanding margin assumes a buyer who still sees growth, so the model should show 14x as a downside, not a stress. Growth is third, which is unusual for software and is a direct result of entering at 20x, where the price already pays for the growth. Say the limit: the tornado moves one input at a time, and in a real downturn margin, multiple and growth fall together.
Where candidates lose it
The usual loss is naming growth first because it is the headline of every software deck. In this model the entry multiple has already paid for the growth, and the margin walk from 30% to 40% is where the equity gain comes from.
The second is answering the flat margin question with a guess. The interviewer has the model open; say the number, say why it moved, and say what debt does in that case.
What the interviewer asks next
- Margin reaches 40% but only in year 5, flat at 30% until year 4. What is the IRR?
- The lender caps leverage at 5x. Does that change which assumption matters most?
- Build the two-way table of IRR against exit margin and exit multiple. Where does the deal clear 25%?
Asked at Vista Equity Partners, Technology, Media and Telecom (TMT), Austin, 2024 (Wall Street Oasis): Coffee chat with the recruiter, followed by CCAT, model test, model debrief, then 4 1:1 interviews
Company names and figures are illustrative.
