Case 066Leveraged buyoutsHard
Modelling test: Vastrakala Garments has a Rs 250 crore term loan with a 100% cash sweep, a Rs 100 crore PIK note at 14%, a Rs 50 crore revolver and a Rs 10 crore cash floor. Fill in the three-year debt schedule.
1The situation
A sponsor has bought Vastrakala Garments, an apparel exporter. EBITDA is Rs 80 crore and grows 10% a year. Each year the business spends Rs 15 crore on capex, Rs 10 crore on tax and Rs 5 crore on working capital. Opening cash is Rs 10 crore, and the model must keep at least Rs 10 crore of cash at all times.
The debt: a Rs 250 crore term loan at 10% with a 100% cash sweep, so every rupee above the cash floor repays it; a Rs 100 crore PIK note at 14%, whose interest is added to principal rather than paid; and an undrawn revolver of up to Rs 50 crore at 9%, drawn only if cash would otherwise fall below the floor. Interest is on opening balances. The template's lines for interest, sweep, balances and cash are blank.
2Your task
Fill in the three-year schedule: cash available, interest on each instrument, the sweep, the revolver, and the closing balances. Then say what the schedule tells you about the deal.
Quick check
In year 1, how much of the term loan is repaid?
Worked solution
Try it on paper, then open one step at a time.
30-second answerThe answer to give first
The term loan falls from Rs 250 crore to Rs 141.65 crore, the PIK note grows to Rs 148.15 crore, the revolver is never drawn and cash sits at Rs 10 crore throughout. Cash before interest is 50, 58 and 66.8; term loan interest on the opening balance is 25, 22.5 and 18.95; the sweep is 25, 35.5 and 47.85. Total debt falls only from Rs 350 crore to Rs 290 crore, because the PIK adds back Rs 48 crore of what the sweep repays.
Step 1What is the order of operations each year?
Cash first, then the instruments in the order the documents rank them. Start with cash before interest, pay cash interest, hold back the floor, repay any revolver balance, and only then sweep what is left into the term loan; the PIK note accrues on its own line and takes no cash at all. A household does the same at month end: pay the card interest, keep an emergency balance, clear the overdraft, then prepay the home loan with whatever is left. The cash sweepA loan term that requires surplus cash above an agreed minimum to be used to repay the loan early, rather than kept or distributed. is the prepayment; the PIK notePayment-in-kind debt: interest is added to the principal each period instead of being paid in cash, so the balance compounds. is the relative who agreed to be paid at the end, with interest on interest.
Step 2What goes in each blank?
Year 1: EBITDA 80 less 30 of capex, tax and working capital leaves 50. Term loan interest is 10% of 250, 25. Cash already sits at the Rs 10 crore floor, so 25 sweeps and the loan closes at 225. The PIK accrues 14 and closes at 114. Year 2: cash is 58, interest 22.5 on the lower balance, sweep 35.5, loan 189.5; PIK accrues 15.96 to 129.96. Year 3: cash 66.8, interest 18.95, sweep 47.85, loan 141.65; PIK closes at 148.15. The revolver never moves because cash never threatens the floor.
| Year | EBITDA | Cash before interest | TL interest | Sweep | TL closing | PIK accrual | PIK closing | Revolver | Cash |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 80.0 | 50.0 | 25.00 | 25.00 | 225.00 | 14.00 | 114.00 | 0 | 10 |
| 2 | 88.0 | 58.0 | 22.50 | 35.50 | 189.50 | 15.96 | 129.96 | 0 | 10 |
| 3 | 96.8 | 66.8 | 18.95 | 47.85 | 141.65 | 18.19 | 148.15 | 0 | 10 |
Step 3When does the revolver come in, and how do you model it?
Only when cash would otherwise fall below the floor, and the test is checking that you built it that way rather than drawing it by hand. If year 1 EBITDA were Rs 50 crore instead of 80, cash before interest would be 20 against 25 of interest, cash would fall to 5, and the revolver would draw exactly 5 to restore the floor; nothing would sweep. In that downside, year 2's surplus of 4.55 repays most of the revolver before any term loan repayment, and the term loan only starts to shrink in year 3. Build the draw as the shortfall below the floor, capped at the Rs 50 crore limit, and the repayment as the first use of any surplus.
Step 4What does the finished schedule tell you about the deal?
That the headline deleveraging is flattered by the PIK. The term loan falls by Rs 108 crore in three years, but the PIK note grows by Rs 48 crore, so total debt only falls from Rs 350 crore to Rs 290 crore and leverage from 4.4x to 3.0x. The sponsor is paying 14% compounding for the privilege of sending every rupee to the 10% loan, which makes sense only if the term loan's covenants are the binding constraint. Say the checks you would run next: the interest circularity if interest were on average balances, the tax shield on PIK interest, which the flat Rs 10 crore of tax ignores, and whether the sweep is really 100% or steps down as leverage falls.
Where candidates lose it
The common miss is paying the PIK interest in cash, which cuts the sweep by Rs 14 crore in year 1 and leaves the note at Rs 100 crore. PIK means the interest becomes principal; the cash flow statement never sees it.
The second is drawing the revolver as a plug for any shortfall in the sweep rather than for a breach of the cash floor. In the base case there is no shortfall, and a model that shows a revolver balance has misread the floor.
What the interviewer asks next
- Interest is charged on average rather than opening balances. How do you handle the circularity?
- The sweep steps down to 50% once leverage is below 3.0x. Rebuild year 3.
- Why might a sponsor choose a PIK note over more term loan, given it costs 14%?
Asked at Carlyle Group, Credit, New York, 2023 (Wall Street Oasis): LBO modeling test conducted remotely, 90min, with a revolver, cash sweep, and PIK note. Template was given but line items were blank
Asked at Carlyle Group, Credit, New York, 2023 (Wall Street Oasis): The modeling test and filling in the blank lines
Company names and figures are illustrative.
