Case 099LBO modelling testsCore
Stress test the model: base EBITDA Rs 100 crore, debt Rs 550 crore, leverage covenant 6.0x. In the downside, revenue is flat at Rs 700 crore and margin falls 300 basis points. Does the company breach, and what does IRR fall to?
1The situation
Your model of Lumora Pet Foods, a maker of dry dog and cat food, has base-case EBITDA of Rs 100 crore on revenue of Rs 700 crore, a 14.3% margin, growing Rs 6 crore a year. The sponsor paid 9x, Rs 900 crore, with Rs 550 crore of debt at 10% and Rs 350 crore of equity. The loan carries a leverage covenant of 6.0x net debt to EBITDA, tested yearly. Depreciation and capex are Rs 20 crore each, tax 25%, all cash repays debt, exit in year 5 at 9x.
The partner asks for a downside: revenue flat for five years and margin 300 basis points lower, from a grain price spike the company cannot pass on.
2Your task
Work the downside EBITDA and leverage, say whether the covenant is breached and by how much, and give the IRR in both cases.
Quick check
Leverage at close is 5.5x against a 6.0x covenant. How much can EBITDA fall before a breach?
Worked solution
Try it on paper, then open one step at a time.
30-second answerThe answer to give first
Yes, the downside breaches: EBITDA falls to Rs 79 crore and leverage to 6.96x against a 6.0x covenant, and the IRR falls from about 18% to about -13%. Three hundred basis points on Rs 700 crore is Rs 21 crore of EBITDA; the covenant allows only Rs 8.3 crore of loss. Even after year 1 cash repays some debt, leverage is 6.92x at the first test. The equity is worth about 0.5x at a 9x exit, and the covenant is broken in year one, so the lender holds the company before the sponsor does.
Step 1What is the covenant actually testing?
Not the return: the lender's cushion. A bank that lends against a salary sets a limit on the loan as a multiple of income, and a pay cut can break the limit long before the borrower is in trouble. Rs 550 crore of debt at a 6.0x covenant needs EBITDA of at least Rs 91.7 crore, so the company can lose only Rs 8.3 crore, 8.3%, before the lender can call a default. Half a turn of headroom at close is thin, and the first question in any model debrief is how many points of margin that half turn represents.
Step 2What does the downside do to EBITDA and leverage?
Convert the basis points into rupees. Margin falls from 14.3% to 11.3%; on Rs 700 crore of revenue that is Rs 79 crore of EBITDA, Rs 21 crore less, and Rs 550 crore over Rs 79 crore is 6.96x, nearly a full turn through the covenant. Year 1 cash of about Rs 3 crore repays a little debt, so leverage at the first test is 6.92x, still a breach. The downside passes only if debt were Rs 474 crore or less, or if the margin loss were capped near 8% of EBITDA, which is what a covenant resetA renegotiation of the covenant levels with the lender, usually in exchange for a fee, a higher margin or tighter terms elsewhere. conversation would be about.
| Rs crore | Base | Downside |
|---|---|---|
| Revenue | 700 growing | 700 flat |
| EBITDA margin | 14.3% | 11.3% |
| EBITDA, year 1 | 106 | 79 |
| Leverage at close | 5.50x | 6.96x |
| Leverage at first test | 4.97x | 6.92x |
| Debt at exit | 366 | 533 |
| MOIC and IRR at 9x | 2.30x, 18.1% | 0.51x, -12.6% |
| MOIC and IRR at 8x exit | 0.28x, -22.3% |
Step 3What does the IRR fall to, and why is that the second question?
With EBITDA flat at Rs 79 crore, less cash repays debt, so debt at exit is about Rs 533 crore instead of Rs 366 crore, and exit equity at 9x is Rs 178 crore against Rs 804 crore in the base. The IRR falls from about 18% to about -13%, 0.51x the money, and to about -22% if a buyer pays 8x for a business that has not grown; with Rs 550 crore of debt against Rs 79 crore of EBITDA, almost no cash reaches the loan and the equity is worth half what went in. A stress case that reports only the IRR says the sponsor loses half its money in year 5; one that tests the covenant says the lender gets a seat at the table in year one, which is sooner and worse. The partner asked for the second kind.
Close with what you would change. Either less debt, Rs 474 crore passes the downside, or a covenant set at 7.0x for the first two years with a step-down, or an equity cure right that lets the sponsor inject cash to fix a breach. Say which you would ask for and what it costs, because the model's job is to put a price on the cushion before the lender does.
Where candidates lose it
The usual loss is running the downside through to the IRR and reporting it as the answer. The IRR arrives in year 5; the covenant breaks in year 1, and the interviewer asked about the covenant for that reason.
The second is reading 300 basis points as 3% of EBITDA. It is 3% of revenue, Rs 21 crore, which is 21% of EBITDA and more than twice the headroom.
What the interviewer asks next
- The sponsor has a Rs 30 crore equity cure right. Does one cure fix the problem, or only year one?
- Grain prices normalise in year 3 and margin recovers. When is the covenant back in compliance?
- How would the answer change if the covenant were tested on net debt and the company held Rs 40 crore of cash?
Company names and figures are illustrative.
