Financing schedules · in 18 models

Debt schedule

Tranches, interest, amortisation and the sweep.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: debt schedule.Updated 30 September 2026

Part of m&a and private equity models, with the models, labs and guides around it.

Part of credit and restructuring models, with the models, labs and guides around it.

Part of project finance and infrastructure models, with the models, labs and guides around it.

Part of healthcare financial models, with the models, labs and guides around it.

Part of technology company financial models, with the models, labs and guides around it.

What it does

The financing engine of a model. Each tranche has an opening balance, draws or repayments, and a closing balance; interest is charged on the balance and flows to the income statement; the repayments flow to financing cash flow. In an LBO the schedule also decides how excess cash is used, which is the cash sweep. It is the schedule most often examined in a modelling test.

Where it lives

The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.

Integrated three-statement model
  • Assumptions, rows 40–44: Minimum cash balance, Term loan scheduled amortisation, Term loan interest rate, Revolver interest rate…
  • Income Statement, rows 24–29: Interest expense, Interest income, Profit before tax, Tax…
  • Cash Flow, rows 16–20: Term loan repayment, Dividends paid, Cash flow before revolver, Revolver draw / (repayment)…
  • Debt, rows 6–9: Opening cash, Cash flow before revolver, Cash before revolver draw / (repayment), Minimum cash
  • Debt, rows 12–15: Opening balance, Scheduled amortisation, Closing balance, Interest on term loan
  • Debt, rows 18–21: Opening balance, Draw / (repayment), Closing balance, Interest on revolver
  • Debt, rows 24–29: Total interest expense, Interest income, Total debt, Net debt…
Leveraged buyout model
  • Assumptions, rows 18–28: Revolver commitment, Revolver drawn at close, Revolver interest rate, Term loan B, multiple of LTM EBITDA…
  • Operating Model, rows 12–14: Amortisation of financing fees, Interest expense, Interest income
  • Debt, rows 6–10: Opening cash, Free cash flow before debt repayment, Cash after mandatory amortisation, Minimum cash…
  • Debt, rows 13–16: Opening balance, Draw / (repayment), Closing balance, Interest
  • Debt, rows 19–23: Opening balance, Mandatory amortisation, Cash sweep, Closing balance…
  • Debt, rows 26–28: Opening balance, Closing balance (bullet), Interest
  • Debt, rows 31–38: Closing cash, Interest income on opening cash, Total interest expense, Total debt…
Merger model: accretion and dilution
  • Pro Forma EPS, rows 12–15: Less interest on new debt, Less interest forgone on cash used, Less financing fee amortisation
Credit model
  • Assumptions, rows 22–36: Cash at close, Minimum operating cash, Revolver commitment, Revolver interest rate…
  • Assumptions, row 39: Cash sweep to term loan B
  • Debt, rows 6–13: EBITDA, Revolver interest and commitment fee, Term loan A interest, Term loan B interest…
  • Debt, rows 16–20: Term loan A scheduled amortisation, Term loan B scheduled amortisation (balance at maturity), Senior notes repaid at maturity, Mandatory repayment…
  • Debt, rows 23–26: Cash above the minimum after mandatory repayment, Revolver draw, Revolver repayment, Revolver drawn, closing
  • Debt, rows 29–30: Cash above the minimum after the revolver, Swept to term loan B
  • Debt, rows 33–44: Term loan A, Term loan B, Senior unsecured notes, Total debt…
Carve-out and standalone cost model
  • Buyer, rows 34–49: Term loan, opening, Revolver, opening, Interest on opening balances, Cash before the revolver and the sweep…
Regulated utility model: electricity network
  • Assumptions, rows 33–34: Interest rate on debt, FFO / debt threshold for the rating
  • Financing, rows 6–12: Net income, Add: depreciation, Add: write-off of disallowed capital spending, Funds from operations (FFO)…
  • Financing, rows 15–18: Opening debt, Debt issued, Closing debt, Interest
  • Financing, rows 41–47: FFO / debt, Headroom over the rating threshold, Below the threshold, FFO interest cover…
Aircraft leasing model
  • Assumptions, rows 16–22: Loan-to-value at close, Interest rate to maturity, fixed, Arrangement fee, Scheduled amortisation, annual…
  • Financing, rows 6–8: Loan drawn at close, Arrangement fee, Equity at close
  • Financing, rows 11–22: Opening balance, Drawn at close, Interest rate in force, Interest…
Data centre colocation model
  • Assumptions, rows 46–48: Interest rate, term loan, Amortisation, annual, Arrangement fee, term loan
  • Financing, rows 25–33: Opening balance, Drawn at conversion, Interest, Scheduled amortisation…
Telecom tower model: tenancies per tower
  • Assumptions, rows 64–67: Net debt at close, multiple of FY0 EBITDAaL, Share of growth capital spending funded by debt, Interest rate, Tax rate
  • Cash Flow & Debt, rows 32–41: Debt, opening, Debt raised: share of growth capital spending, Debt, closing, Interest…
Mining model: copper-gold mine NAV
  • Assumptions, rows 62–65: Project loan, FY0, Years to repay, Interest rate, real, Cash, FY0
  • Debt, rows 6–10: Opening balance, Repaid, Closing balance, Interest…
  • Debt, rows 13–19: Debt service cover ratio, Free cash flow while the loan is outstanding, Year of final repayment, Debt service cover ratio, lowest year…
Container shipping model: liner company
  • Assumptions, rows 63–70: Existing debt, FY0, Existing debt repaid each year, % of FY0, Vessel loan, % of delivered cost, Vessel loan tenor…
  • Debt, rows 6–8: Opening balance, Repaid, Closing balance
  • Debt, rows 11–15: Opening balance, Drawn on delivery, Drawn to date, Repaid…
  • Debt, rows 18–24: Interest, Dividends, Cash before the revolver, Revolver, opening…
  • Debt, rows 27–34: Gross debt, Net debt, Net debt / EBITDA, EBITDA / interest…
Healthcare services model: hospital operator
  • Assumptions, rows 71–73: Interest rate, Mandatory amortisation, % of original debt a year, Cash sweep, % of cash after debt service
  • Debt, rows 6–12: Opening balance, Interest, Free cash flow, after interest, Mandatory amortisation…
  • Debt, rows 15–20: Cash, Net debt, Net debt / EBITDA, EBITDA / interest…
Pharma royalty and licensing model
  • Assumptions, rows 34–38: Share of the price funded with new debt, Existing debt, end of Y0, Cash before the purchase, end of Y0, Interest rate…
  • Debt, rows 6–10: New debt for the purchase, Opening balance, Interest, Repayment…
  • Debt, rows 13–20: Cash flow before financing, Cash flow after debt service, Cash, Net debt…
Airline operating and valuation model
  • Assumptions, rows 88–94: Cash, FY0A, Aircraft debt, FY0A, Debt raised, % of delivery spending, Scheduled repayment, % of opening debt…
  • Financials, rows 7–8: Interest on debt, Interest on cash
  • Financials, rows 15–18: Opening debt, Debt raised for deliveries, Less scheduled repayment, Closing debt
Restaurant franchise roll-out model
  • Assumptions, rows 76–87: Securitised notes, FY0, Coupon, Scheduled amortisation, % of original principal, Non-amortisation test: notes / EBITDA at or below…
  • Debt, rows 6–13: Opening balance, Opening notes / previous year’s EBITDA, Scheduled amortisation applies (1 = yes), Less: scheduled amortisation…
  • Debt, rows 16–23: Dividends, Cash before buybacks, Share buybacks, Cash…
  • Debt, rows 26–32: Net debt, Net debt / EBITDA, Rent on company restaurants, Rent capitalised…
Telecom operator model: mobile and fibre
  • Assumptions, rows 79–87: Bonds, FY0, Share of the auction payment funded by a new bond, Interest rate, Cash, FY0…
  • Debt & Dividends, rows 6–9: Bonds, Spectrum bond, opening, Issued in the auction year, Spectrum bond, closing
  • Debt & Dividends, rows 12–19: Interest, Dividend per share, Dividends, Cash before the revolver…
  • Debt & Dividends, rows 22–26: Gross debt, Net debt, Net debt / EBITDAaL, Headroom to the policy ceiling…
  • Debt & Dividends, rows 29–31: Dividend cover: equity free cash flow / dividends, Dividend cover after spectrum, Dividends / net income
ICG management buyout model
  • Assumptions, rows 25–39: Facility B, euro term loan, Original Revolving Facility, Of which drawable for the Acquisition on a certain funds basis, Senior facilities available for the Acquisition…
  • Assumptions, rows 42–47: Preferred equity subscribed, Of which paid for the Profit Share Securities, Issue discount on the subscription, Preferred Return on the preference shares…
  • Cash Flow & Debt, rows 6–7: Group EBITDA, Less lease payments
  • Cash Flow & Debt, rows 10–17: Less working capital outflow, Less senior interest, Less cash tax, Excess cash flow…
  • Cash Flow & Debt, rows 20–36: Opening senior debt, Facility B, opening, Scheduled amortisation, Mandatory cash sweep…
  • Cash Flow & Debt, rows 39–44: Lease liabilities, Net debt, Net debt / EBITDA, EBITDA / senior interest…
  • Cash Flow & Debt, rows 47–49: EBITDA after lease payments, Net Debt Cover: senior debt less cash / EBITDA after leases, Interest cover: EBITDA after leases / senior interest
AerCap operating model
  • Derived, rows 23–29: Debt at the start of the year, Average debt: mean of the year ends, Interest expense / average debt, Net spread: lease yield - interest expense / average debt…
  • Forecast, rows 42–46: Interest expense / average debt, base (editorial), Interest expense / average debt, downside (editorial), Interest expense / average debt, upside (editorial), Interest expense / average debt, selected…
  • P&L & Cash Flow, row 46: Debt at the year end
  • One Lease, rows 22–25: Scheduled repayment, Interest on the opening balance, Balance repaid at the sale, Loan at the year end

What a reviewer looks for

  • A sweep that runs before mandatory amortisation.
  • Interest on average balances without an iteration switch.
  • A revolver that draws to fund the sweep.
  • A tranche allowed to go negative because the repayment was not capped at the balance.

Learn it, then build it

Vocabulary: PIK Interest, Covenant, Leverage Model, Net Debt.

Other financing schedules