Waddle Street
Programs
  • All programs
  • Insight programs
  • What changed
  • Competitions
Networking
  • Contacts
  • Find people
  • Write a note
Prep
  • Learn
  • Drills
  • My answers
  • Markets
  • Resume review
  • Resources
Industries
  • Overview
  • Find your fit
  • Guides
Waddle Street
LearnDrillsMy answersMarketsResume reviewResources

Learn

Learn/LBO modeling in depth
LearnLBO modeling in depth

0 of 7 lessons, sign in to save

B Basic

  • The debt schedule, tranche by tranche10m
  • Interest, average balances, and the circularityPro10m
  • Returns math, fast, and which levers matterPro11m

A Advanced

  • The cash sweep under a credit agreementPro12m
  • PIK, OID, and financing fees in the modelPro12m
  • Partial exits, follow ons, and IRR with many cash flowsPro12m
  • The equity waterfall: rollover, options, and preferredPro13m
  • FlashcardsPro0/15
  • Basic quizPro80% passes
  • Advanced quizPro80% passes
  • Terms

Basic, lesson 1 of 3

The debt schedule, tranche by tranche

A buyout is financed with several kinds of debt, and each one has its own rules for drawing, repaying, and prepaying. The debt schedule is where those rules live.

10 min, 3 checks

1The tranches and their rules

The debt schedule tracks every tranche from the close to the exit: beginning balance, draws, mandatory repayment, optional repayment, ending balance, and interest. Before you build it you need to know what each tranche allows.

TrancheWho lendsAmortizationPrepayable?Rate
RevolverBanksNone; drawn and repaid as neededYes, any timeFloating, plus a fee on the undrawn amount
Term loan ABanksHeavy, often 5% to 10% a year or moreYes, at parFloating
Term loan BInstitutional loan investorsLight, usually 1% a year, rest at maturityYes, often at par after a short soft callFloating, wider spread than TLA
Senior or subordinated notesBond investorsNone; bullet at maturityOnly with a call premium after a non call periodUsually fixed, higher
A typical buyout capital structure, top of the stack first

The pattern to remember: the higher a tranche sits in the stack and the more it amortizes, the cheaper it is and the more control the lenders keep. Notes are expensive partly because the sponsor cannot pay them off early for free.

Check 1

A $400m term loan B amortizes 1% of the original principal each year. What is the mandatory repayment in year one, in $m?

$m

2Mandatory versus optional repayment

Mandatory repayment is the scheduled amortization in the credit agreement. It is owed whether or not the company had a good year. Optional repayment is anything above that, paid from excess cash. In a model, mandatory payments come first and the optional sweep uses whatever cash is left.

The usual order of the optional sweep in a model is revolver first (the cheapest to redraw later, so clear it), then term loans, and never the notes. Some credit agreements require term loan prepayments to be shared pro rata between TLA and TLB; a simple model pays them in order of seniority. Say which convention you used.

Check 2

A model sweeps excess cash to repay debt. Which tranche is normally left out of the sweep?

3The revolver as the plug

The revolver is the only line that can go up. When free cash flow after mandatory payments is negative, and the cash above the minimum balance is not enough to cover it, the company draws on the revolver. When cash comes back, the revolver is the first thing repaid.

Revolver draw = MAX(0, -(FCF - Mandatory repayment + Beginning cash - Minimum cash))

Capped at the commitment. If the draw would exceed it, the company is out of liquidity and the model should flag it.

Worked example

A bad year at Harlow Packaging

  1. 1Free cash flow before debt repayment is -$12m after a working capital build.
  2. 2Mandatory amortization is $4m.
  3. 3Beginning cash is $20m and the minimum the company keeps is $10m, so $10m is free.
  4. 4Cash available: -$12m - $4m + $10m = -$6m.

The company draws $6m on the revolver and ends the year with exactly $10m of cash. Debt went up in a year the sponsor hoped to pay it down.

An undrawn revolver still costs money: lenders charge a commitment fee on the unused amount, often a fraction of a percent. On a $75m undrawn revolver at 0.375%, that is about $0.28m a year. Small, but it belongs in interest expense.

Check 3

FCF before debt repayment is -$8m, mandatory amortization $5m, beginning cash $25m, minimum cash $15m. How much is drawn on the revolver, in $m?

$m

Terms in this lesson: Leveraged buyout, Amortization, Revolving credit facility, Sponsor.

How this gets asked in an interview

Interviewers ask about the debt stack to see whether you know why a sponsor uses several tranches and what each costs. Name the tranche, its amortization, and whether it can be prepaid.

  • Walk me through a typical LBO capital structure.
  • What is the difference between a term loan A and a term loan B?
  • Why does the revolver usually start undrawn, and when does it get used?
Drill LBO mechanics, ten questions

3 checks in this lesson. Sign in to keep your progress.

Next lesson