What You'll Learn Today
🔄 Where We Left Off (Session 16)
In Session 16, we built the entry model for Apex Capital's acquisition of NovaTech Industries:
✅ What We Built
- Sources & Uses table (₹6,219.50 Cr)
- Debt structure: Senior ₹2,200 + HY ₹800 + Mezz ₹350 = ₹3,350 Cr
- Sponsor equity check: ₹2,719.50 Cr (the "plug")
- Entry EV/EBITDA: 12.4x on ₹480 Cr EBITDA
- Base-case IRR: ~15.7% (below 20% target)
🔨 What We'll Build Today
- Operating model — 5-year EBITDA projection
- Debt schedule — mandatory amortization + cash sweep
- Cash flow waterfall — from EBITDA to debt repayment
- Sponsor returns — MOIC, IRR under 3 scenarios
- Value creation bridge — decompose returns by lever
Building the Operating Model
Projecting EBITDA growth — the engine that drives the entire LBO
Remember the house you bought for ₹1 Cr? After buying it, you didn't just sit and wait — you actively managed it. You renovated the kitchen (increased rent from ₹40K to ₹45K/month), negotiated better rates with the plumber (reduced maintenance costs), and listed the house on premium rental platforms (new revenue channels).
In an LBO, the PE firm does exactly this with the company — they build an operating model that projects how much EBITDA will grow through revenue increases and cost improvements. This is Lever 1 (EBITDA Growth) from Session 16 — and it's the most important value driver.
📊 NovaTech — 5-Year Operating Projection
Apex Capital's business plan for NovaTech: grow revenue 5-6% annually while improving EBITDA margins from 20% to 22.5% through procurement optimization and capacity utilization.
| Metric | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|---|
| Revenue (₹ Cr) | 2,400 | 2,520 | 2,672 | 2,832 | 3,003 | 3,183 |
| Revenue Growth % | — | 5.0% | 6.0% | 6.0% | 6.0% | 6.0% |
| Margin Improvements | ||||||
| COGS (% of Revenue) | 80.0% | 79.5% | 79.0% | 78.5% | 78.0% | 77.5% |
| EBITDA (₹ Cr) | 480 | 517 | 561 | 609 | 661 | 716 |
| EBITDA Margin % | 20.0% | 20.5% | 21.0% | 21.5% | 22.0% | 22.5% |
| D&A | 120 | 126 | 133 | 140 | 147 | 154 |
| EBIT (₹ Cr) | 360 | 391 | 428 | 469 | 514 | 562 |
EBITDA grows from ₹480 Cr to ₹716 Cr — a 49% increase over 5 years (8.4% CAGR). This comes from a combination of revenue growth (32% cumulative) and margin expansion (from 20.0% to 22.5%). The PE firm's operational playbook — better procurement, capacity utilization, and pricing power — drives this improvement.
Building the Debt Schedule
Modeling mandatory amortization, cash sweeps, and PIK accretion
Your ₹80 Lakh home loan has two parts: (1) Mandatory EMI — you MUST pay ₹75,000/month (interest + principal), no exceptions. (2) Optional prepayment — if you get a bonus at work, you can choose to pay down extra principal, reducing future interest and shortening the loan term.
In an LBO debt schedule, the same logic applies: Senior debt has mandatory amortization (like an EMI — you must repay some principal every year). If there's excess cash after all payments, a "cash sweep" mechanism applies the extra to prepay debt faster. High-yield bonds are bullet maturity — interest-only, all principal due at maturity (like an interest-only home loan).
📖 Three Types of Debt Repayment in an LBO
🏦 Mandatory Amortization
What: Fixed annual principal repayment — NON-NEGOTIABLE.
Typically 5-10% of original senior debt per year. Like your home loan EMI — skip it and you default.
Mandatory Amort = Original Principal × Amort %
NovaTech: ₹2,200 Cr × 5% = ₹110 Cr/year
💸 Cash Sweep (Excess CF Prepayment)
What: Optional prepayment using excess cash — speeds up debt reduction.
After mandatory amort, if excess cash flow is positive, 50-75% goes to prepay senior debt. Like using your annual bonus to prepay the home loan.
Cash Sweep = Sweep% × MAX(0, Excess CF)
NovaTech: 50% of excess CF after mandatory amort
📈 PIK Accretion (Negative Amortization)
What: Interest that ADDS to principal instead of being paid in cash.
Mezzanine debt has PIK feature — the 2% PIK interest accrues, increasing the principal balance each year. Like negative amortization — the loan GROWS over time.
PIK Accretion = Opening Balance × PIK Rate
NovaTech: ₹350 Cr × 2% = ₹7 Cr/year (grows to ₹386 Cr by Year 5)
✏️ Worked Example 1: Complete 5-Year Debt Schedule
Scenario: Model the repayment of NovaTech's ₹3,350 Cr total debt over 5 years using mandatory amortization and cash sweep for senior debt.
| Debt Schedule (₹ Cr) | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|---|
| Senior Secured Term Loan (9.5%) | ||||||
| Opening Balance | 2,200 | 2,200 | 2,045 | 1,852 | 1,635 | 1,391 |
| Mandatory Amort (5%) | — | (110) | (110) | (110) | (110) | (110) |
| Cash Sweep (50%) | — | (45) | (83) | (107) | (134) | (164) |
| Closing Balance | 2,200 | 2,045 | 1,852 | 1,635 | 1,391 | 1,117 |
| High-Yield Bonds (13.0% — Bullet) | ||||||
| Opening / Closing Balance | 800 | 800 | 800 | 800 | 800 | 800 |
| Mezzanine Debt (16% Cash + 2% PIK) | ||||||
| Opening Balance | 350 | 350 | 357 | 364 | 372 | 379 |
| + PIK Accretion (2%) | — | 7 | 7 | 8 | 7 | 7 |
| Closing Balance | 350 | 357 | 364 | 372 | 379 | 386 |
| Total Debt | 3,350 | 3,202 | 3,016 | 2,807 | 2,570 | 2,303 |
• Senior debt reduced from ₹2,200 → ₹1,117 Cr — ₹1,083 Cr repaid (49% paid down)
• HY bonds stay flat at ₹800 Cr — bullet maturity, no principal repayment until Year 7
• Mezzanine GREW from ₹350 → ₹386 Cr — PIK accretion adds ₹36 Cr over 5 years
• Total debt reduced by ₹1,047 Cr (from ₹3,350 to ₹2,303) — 31% reduction
The Cash Flow Waterfall
Tracing every rupee from EBITDA to debt repayment — the LBO's circulatory system
Imagine you earn ₹1 Lakh/month. Your "cash flow waterfall" goes like this:
1. Salary (Revenue) → ₹1,00,000
2. Minus tax → (₹20,000) — mandatory
3. Minus rent → (₹25,000) — mandatory
4. Minus groceries & bills → (₹15,000) — mandatory
5. Minus home loan EMI → (₹30,000) — mandatory (senior debt service!)
6. Free cash = ₹10,000 — this is yours to save or invest
7. Extra prepayment on loan → (₹5,000) — optional (cash sweep!)
8. Cash remaining = ₹5,000 — your pocket money
The LBO cash flow waterfall works identically — it's a priority ranking of where every rupee of cash goes. Senior lenders get paid first, then junior lenders, and equity holders get whatever is left.
📖 The LBO Cash Flow Waterfall — Order of Priority
✏️ Worked Example 2: Year 1 Cash Flow Waterfall
Free Cash Flow is negative ₹9 Cr in Year 1! The interest burden of ₹369 Cr consumes 71% of EBITDA. After capex and mandatory debt repayment, the company is ₹119 Cr short. This shortfall is funded by the ₹150 Cr cash from the balance sheet (from the S&U table). No cash sweep is possible — there's no excess cash. This is why PE firms need strong cash flow companies — Year 1 is always tight.
📊 Full 5-Year Cash Flow Waterfall
| Waterfall (₹ Cr) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| EBITDA | 517 | 561 | 609 | 661 | 716 |
| − Cash Interest | (369) | (355) | (338) | (319) | (297) |
| EBIT after Interest | 148 | 206 | 271 | 342 | 419 |
| − Tax | (37) | (52) | (68) | (86) | (105) |
| − Capex | (105) | (111) | (118) | (125) | (133) |
| − ΔNWC | (15) | (18) | (20) | (22) | (24) |
| Free Cash Flow | (9) | 25 | 65 | 109 | 157 |
| − Mandatory Amort | (110) | (110) | (110) | (110) | (110) |
| Excess Cash Flow | (119) | (85) | (45) | (1) | 47 |
| Cash Sweep (50%) | 0 | 0 | 0 | 0 | (23) |
Notice the pattern: FCF goes from negative ₹9 Cr (Year 1) → positive ₹157 Cr (Year 5). This is the classic LBO "J-Curve" — returns are initially low or negative because the interest burden is heaviest in early years. As EBITDA grows AND debt is paid down (reducing interest), cash flow improves dramatically. By Year 5, the company generates ₹157 Cr of free cash flow — enough to fund the mandatory ₹110 Cr amortization AND a ₹23 Cr cash sweep with ₹24 Cr left over.
Sponsor Returns & Scenario Analysis
The final verdict: does this deal work for Apex Capital?
📊 Three Exit Scenarios for NovaTech
🐻 Bear Case — Market Downturn
EBITDA grows modestly to ₹640 Cr. Indian auto-components sector faces headwinds — exit at 10.0x (below entry). Limited debt paydown.
| Exit EBITDA × Exit Multiple | ₹640 × 10.0x = ₹6,400 Cr |
| − Net Debt at Exit | (₹2,500 Cr) |
| Exit Equity Value | ₹3,900 Cr |
| Entry Equity | ₹2,719.50 Cr |
| MOIC | 1.43x |
| IRR (5 years) | 7.5% |
📊 Base Case — Business Plan Achieved
EBITDA grows to ₹716 Cr per plan. Exit at 11.0x (slight multiple compression from 12.4x entry). Steady debt paydown.
| Exit EBITDA × Exit Multiple | ₹716 × 11.0x = ₹7,876 Cr |
| − Net Debt at Exit | (₹2,303 Cr) |
| Exit Equity Value | ₹5,573 Cr |
| Entry Equity | ₹2,719.50 Cr |
| MOIC | 2.05x |
| IRR (5 years) | 15.4% |
🐂 Bull Case — Operational Excellence + Market Tailwinds
EBITDA grows to ₹790 Cr (margin beats plan). Sector re-rates — exit at 13.0x (slight expansion). Aggressive debt paydown.
| Exit EBITDA × Exit Multiple | ₹790 × 13.0x = ₹10,270 Cr |
| − Net Debt at Exit | (₹2,100 Cr) |
| Exit Equity Value | ₹8,170 Cr |
| Entry Equity | ₹2,719.50 Cr |
| MOIC | 3.00x |
| IRR (5 years) | 24.6% |
✏️ Worked Example 3: Value Creation Bridge (Base Case)
Decompose the base-case return of ₹2,854 Cr of equity value created into the three LBO levers.
Entry: EV = ₹5,950 Cr (₹480 EBITDA × 12.4x) | Debt = ₹3,350 | Equity = ₹2,719.50 Cr
Exit: EV = ₹7,876 Cr (₹716 EBITDA × 11.0x) | Debt = ₹2,303 | Equity = ₹5,573 Cr
Equity Value Created = ₹5,573 − ₹2,719.50 = ₹2,854 Cr
ΔEBITDA × Entry Multiple = (₹716 − ₹480) × 12.4x = ₹236 × 12.4 = ₹2,926 Cr
If only EBITDA grew and everything else stayed constant, equity would increase by ₹2,926 Cr
Exit EBITDA × ΔMultiple = ₹716 × (11.0 − 12.4) = ₹716 × (−1.4) = (₹1,002 Cr)
The exit multiple is LOWER than entry — this DESTROYS ₹1,002 Cr of value. This is the risk of buying at a high multiple.
Entry Debt − Exit Debt = ₹3,350 − ₹2,303 = ₹1,047 Cr
Every ₹1 of debt repaid = ₹1 added to equity value. This is the financial engineering contribution.
Total = ₹2,926 + (₹1,002) + ₹1,047 = ₹2,971 Cr
(Small difference from ₹2,854 due to PIK accretion on mezzanine and cash balance changes)
| Value Creation Lever | Amount (₹ Cr) | % of Total | Direction |
|---|---|---|---|
| 📈 EBITDA Growth (Operational) | 2,926 | ~98% | Positive ✓ |
| 🔄 Multiple Compression (Market) | (1,002) | ~(34%) | Negative ✗ |
| 💰 Debt Paydown (Financial) | 1,047 | ~35% | Positive ✓ |
| Net Equity Value Created | ~2,971 | 100% |
📖 Multiple Expansion vs. Compression — The Make-or-Break Factor
📈 Multiple Expansion (Good)
Buy at 8x, sell at 10x. Each rupee of EBITDA is worth more at exit.
Example: ₹500 EBITDA × (10−8) = ₹1,000 Cr pure profit from multiple change
When it happens: Improving growth profile, sector re-rating, market bull run, PE firm fixes "ugly" company
📉 Multiple Compression (Bad — NovaTech's Risk)
Buy at 12.4x, sell at 11.0x. Each rupee of EBITDA is worth LESS at exit.
Example: ₹716 EBITDA × (11.0−12.4) = (₹1,002 Cr) value destroyed
When it happens: Bought too expensive, sector downturn, rising interest rates, market correction
Apex Capital bought NovaTech at 12.4x EBITDA — a rich valuation. In the base case, they can only exit at 11.0x — that compression destroys ₹1,002 Cr of value. Even though EBITDA grew by ₹236 Cr and debt was paid down by ₹1,047 Cr, the multiple compression eats almost 34% of the value created by the other two levers combined. This is why PE firms fight to buy companies at the lowest possible entry multiple.
📊 IRR Sensitivity: Exit Multiple × Exit EBITDA
| Exit EBITDA ↓ Exit Multiple → |
Exit EV/EBITDA Multiple | |||
|---|---|---|---|---|
| 10.0x | 11.0x ★ | 12.4x | 14.0x | |
| ₹640 Cr (Bear) | 7.5% / 1.4x | 9.8% / 1.6x | 13.1% / 1.9x | 16.5% / 2.3x |
| ₹716 Cr (Base) | 11.3% / 1.7x | 15.4% / 2.1x | 20.8% / 2.7x | 26.1% / 3.4x |
| ₹790 Cr (Bull) | 14.6% / 2.0x | 19.2% / 2.5x | 24.6% / 3.2x | 30.4% / 4.1x |
★ = Base case (11.0x). Cells show IRR% / MOIC. Green cells meet 20%+ IRR target. Entry equity = ₹2,719.50 Cr.
Hands-On Practice Exercises
Complete the LBO model in Excel
🏋️ Exercise 1: Build a 5-Year Debt Schedule (30 min)
Objective: Model the complete debt repayment for the GreenPly Furniture acquisition (from Session 16)
| Assumption | Value |
|---|---|
| Senior Debt (₹ Cr) | 1,225 @ 10.0% |
| Mandatory Amortization | 5% of original/year |
| Cash Sweep | 50% of excess CF after mandatory |
| Subordinated Debt | 600 @ 14.0% (bullet, no amort) |
| Mezzanine | 100 @ 18% cash + 3% PIK |
| Revenue CAGR | 8% for 5 years |
| EBITDA Margin Improvement | Starts at 16.7% → 19.0% by Year 5 |
| Capex | 4% of revenue annually |
| Tax Rate | 25.17% |
Year 0: Revenue = ₹2,100 × 16.7% = EBITDA = ₹350 Cr
Year 5: Revenue = ₹2,100 × (1.08)^5 = ₹3,085 × 19.0% = EBITDA = ₹586 Cr
Mandatory amort = ₹1,225 × 5% = ₹61.25 Cr/year
By Year 5, mandatory repay = ₹306.25 Cr. Cash sweep accelerates further.
Year 1: ₹100 × 3% = ₹3 → Closing = ₹103 Cr
Year 5: Closing Mezz ≈ ₹116 Cr (PIK grows the balance each year)
Senior: ~₹830 Cr | Sub: ₹600 Cr | Mezz: ~₹116 Cr
Total Debt at Exit ≈ ₹1,546 Cr (vs. ₹1,925 at entry)
🏋️ Exercise 2: Build a Cash Flow Waterfall (25 min)
Objective: Construct the Year 1 cash flow waterfall for GreenPly
Given: Year 1 EBITDA = ₹390 Cr | Total Cash Interest ≈ ₹224 Cr | Capex = ₹88 Cr | Tax Rate = 25.17% | ΔNWC = ₹12 Cr
🏋️ Exercise 3 (Advanced): Full Returns Analysis (20 min)
Objective: Calculate IRR, MOIC, and value creation bridge for GreenPly under three scenarios
| Scenario | Exit EBITDA | Exit Multiple | Net Debt at Exit |
|---|---|---|---|
| Bear | ₹480 Cr | 6.5x | ₹1,600 Cr |
| Base | ₹586 Cr | 7.5x | ₹1,200 Cr |
| Bull | ₹650 Cr | 8.5x | ₹900 Cr |
| Metric | Bear | Base | Bull |
|---|---|---|---|
| Exit EBITDA (₹ Cr) | 480 | 586 | 650 |
| × Exit Multiple | 6.5x | 7.5x | 8.5x |
| Exit Enterprise Value | 3,120 | 4,395 | 5,525 |
| − Net Debt at Exit | (1,600) | (1,200) | (900) |
| Exit Equity Value | 1,520 | 3,195 | 4,625 |
| Entry Equity | 596.30 | 596.30 | 596.30 |
| MOIC | 2.55x | 5.36x | 7.76x |
| IRR (5 years) | 20.6% | 40.0% | 50.7% |
GreenPly was bought at 7.0x EBITDA (cheaper) vs. NovaTech at 12.4x (expensive).
Even the bear case (20.6% IRR) beats NovaTech's base case (15.4%).
Base case IRR of 40% is exceptional — 5.36x MOIC in 5 years.
📚 Key Terms — Click to Flip
Test Your Understanding
10 objective questions on LBO Modeling – II
Key Takeaways
📝 What We Covered Today
- The operating model projects EBITDA growth through revenue increases and margin improvements — it's the engine of the LBO. NovaTech's EBITDA grows from ₹480 to ₹716 Cr (8.4% CAGR)
- The debt schedule models three types of repayment: mandatory amortization (like EMI), cash sweep (like bonus prepayment), and PIK accretion (negative amortization that grows the loan balance)
- The cash flow waterfall traces every rupee from EBITDA through interest, taxes, capex, and debt repayment — following a strict priority order where senior lenders are paid first
- LBO cash flows follow a J-Curve pattern — early years are cash-negative due to heavy interest, then improve as EBITDA grows and debt is reduced
- Multiple compression is the biggest risk in the NovaTech deal — buying at 12.4x and selling at 11.0x destroys ₹1,002 Cr of value, wiping out 34% of what the other levers created
- The base-case IRR of 15.4% is marginal — below the 20-25% PE target. The deal only meets the hurdle in the bull case (24.6% IRR) requiring EBITDA outperformance and exit at a higher multiple
- Entry valuation is critical: GreenPly (7.0x entry) generates far better returns than NovaTech (12.4x entry) even with similar operational improvements — cheaper entry = better LBO returns
Session 18: IPO Modeling
We shift from private equity exits to public markets: model the IPO process including underwriting fees, offering size determination, pricing mechanisms, and post-IPO capitalization. We'll use a real-world Indian IPO case study. Read: McKinsey Ch. 10