River
Y CombinatorBacked by Y Combinator
Log InStart Free
FREE TEMPLATE

Debt Schedule and Maturity Template

One document and four sheets that build each loan's schedule from its own agreement, then stack every maturity onto one ladder.

Edit with AIDownload (.docx + .csv)

Free download  ·  No account needed

What you get

Pack of 5 files: 1 document, 4 spreadsheets

Debt Schedule and Maturity Template
  • Debt RegisterSpreadsheet
  • Amortization ScheduleSpreadsheet
  • Interest AccrualSpreadsheet
  • Maturity LadderSpreadsheet
  • Debt Summary NoteDocument

A debt schedule template usually lists one line per loan: balance, rate, next payment. It assumes every instrument earns interest the same way, balance times the annual rate divided by twelve. Real credit agreements do not all promise that. One law firm's worked comparison shows an 8% loan computed on a 360-day year returning 8.11% annually. That is an extra $11,111 a year on a $10,000,000 balance, money the flat-rate shortcut never charges. A schedule built on one assumed convention is wrong about at least one loan from the first period.

Averdale Millworks, a fictional custom cabinetry manufacturer, carries three instruments. A $4,000,000 term loan runs fixed at 7.35% on an Actual/360 basis. A $900,000 equipment note floats at one-month Term SOFR plus 275 basis points, and a $450,000 equipment lease runs fixed at 6.40%. Actual/360 alone lifts the term loan's effective rate to 7.4521%, adding $4,658.95 to year-one interest a flat annual-rate-over-twelve calculation misses entirely. The term loan's balloon and the equipment note's bullet payment both fall due in April 2028: a $2,330,261.16 wall neither lender's own paperwork discloses.

The pack extracts term, rate and amortization from each agreement into a Debt Register. Then it builds the Amortization Schedule, Interest Accrual and Maturity Ladder from those terms, not a default convention. A Debt Summary Note carries the wall and the reset history in language the CFO reads without opening a spreadsheet. Reminders fire ahead of each maturity and each SOFR reset. It sits beside the lender covenant reporting package for the covenant math those same agreements also drive.

Three lenders, three conventions, one wall

Each instrument scheduled on its own terms, then stacked onto one ladder to size the combined maturity.

Debt Schedule and Maturity Template
RiverDebt Register

Debt Register

Averdale Millworks, Inc., an illustrative custom cabinetry manufacturer. As of 1 July 2024.

InstrumentLenderRateDay-CountMaturityDue at Maturity
Term Loan AMarsh Point Bank, N.A.Fixed 7.35%Actual/360Apr 20281,430,261.16 balloon
Equipment Term NoteColter Ridge Finance Co.SOFR + 275bpsActual/365Apr 2028900,000.00 bullet
Equipment LeaseNorthfield Leasing Corp.Fixed 6.40%Actual/360Jun 20270.00, fully amortizing

Three lenders, three conventions, three different maturity structures. Nothing on any single agreement says the two 2028 maturities land in the same month.

RiverAmortization

Amortization Schedule, Term Loan A

$4,000,000.00 fixed at 7.35%, Actual/360, an 84-month amortization with a balloon at month 60.

PeriodDateDaysBegin BalanceInterestPrincipalEnd Balance
1May 2023304,000,000.0024,500.0036,557.403,963,442.60
11Mar 2024293,628,963.9921,486.4939,570.913,589,393.08
60Apr 2028311,430,261.169,052.361,430,261.16 balloon0.00

Actual/360 versus the flat annual-rate-over-twelve shortcut, year one

MethodYear 1 interest
Actual/360, per the agreement283,742.35
Flat annual rate divided by twelve279,083.40

The shortcut misses 4,658.95 in the first year alone, and lifts the loan's effective annual rate to 7.4521% against its stated 7.35%.

RiverInterest Accrual

Interest Accrual, Quarter Ended 1 Jul 2024

91 days, 1 April to 1 July 2024. Each instrument on its own rate and day-count basis.

InstrumentRate BasisInterest Accrued
Term Loan AFixed 7.35%, Actual/36065,248.24
Equipment Term NoteSOFR 4.55% + 275bps, Actual/36516,380.00
Equipment LeaseFixed 6.40%, Actual/3604,771.77
Total86,400.01

The equipment note reset on 1 April

Rate usedBasisThis period's interest
Actual reset rate, 7.30%SOFR 4.55% + 275bps16,380.00
Prior quarter's rate held stale, 7.45%SOFR 4.70% + 275bps16,716.58

Holding the stale rate one quarter too long overstates this instrument's accrual by 336.58. The same mistake compounds every quarter the wrong rate is carried.

RiverMaturity Ladder

Maturity Ladder

Every instrument's own maturity or balloon date, stacked onto one twelve-month grid.

InstrumentMaturityBucketAmount Due
Equipment LeaseJun 2027Jun 2026 - May 20270.00, fully amortizing
Term Loan AApr 2028Apr 2027 - Mar 20281,430,261.16 balloon
Equipment Term NoteApr 2028Apr 2027 - Mar 2028900,000.00 bullet
Combined, Apr 2027 - Mar 2028 bucket2,330,261.16

4,613,676.43 of total debt is outstanding today. Over half of it comes due in a single twelve-month window, split across two lenders who have never read each other's agreement.

Edit with AI

What's in the pack

01

Debt Register

Lender, rate, day-count convention and amortization term per instrument, pulled from the agreement itself, not a servicer summary.

02

Amortization Schedule

Term Loan A's period-by-period balance under its own Actual/360 basis, including the balloon balance due at the 60-month mark.

03

Interest Accrual

This period's interest per instrument, checking each floating-rate reset against its real date instead of carrying last quarter's rate forward.

04

Maturity Ladder

Every maturity and balloon date on one twelve-month grid, with the combined total flagged whenever more than one instrument lands in the same bucket.

05

Debt Summary Note

The register's totals, the reset history and the maturity wall written in prose a CFO or a board packet can use without opening a spreadsheet.

How to use it

  1. 1

    Take it blank, or worked

    Download the empty Word and CSV files with no signup, or open the pack in River and hand it every loan and lease agreement instead of retyping four sheets.

  2. 2

    Send the agreements first

    Every loan, lease and amendment on file. That alone builds the Debt Register with each instrument's real rate, day-count convention and maturity structure, not a guessed default.

  3. 3

    Build the schedule and the ladder

    The Amortization Schedule and Interest Accrual compute from each instrument's own convention. The Maturity Ladder stacks every balloon and bullet date onto one grid.

  4. 4

    Refresh it every reset and close

    A floating-rate reset or a new instrument added mid-year changes the numbers. Rerun the pack each close so the Debt Summary Note always matches the register underneath it.

Frequently asked questions

Is this template free?

Yes. The whole pack comes down as Word documents and CSV sheets, no signup and no card. Edit with AI is the optional route for anyone who would rather hand River the loan and lease agreements than retype four sheets. The rest of the library is at free templates.

Does it handle floating-rate debt, not just fixed?

Yes. A floating-rate instrument's coupon is an index, usually Term SOFR, plus a spread, reset on whatever schedule the agreement states. The Interest Accrual sheet checks each reset date against the period being closed, so a rate that changed mid-quarter does not get carried stale into the next accrual.

What is Actual/360, and why does the difference matter?

It is a day-count convention some agreements state: the annual rate divided by 360, times the actual days elapsed, rather than divided by twelve. On Averdale's $4,000,000 term loan, that convention lifts the effective rate from a stated 7.35% to 7.4521%, adding $4,658.95 to the first year's interest alone.

Does the pack cover leases, or only loans?

Both. A finance lease amortizes like a loan and belongs on the same register and the same Amortization Schedule, on whatever day-count basis its own agreement states. The pack does not distinguish a lease from a loan by type; it distinguishes fully amortizing from balloon from bullet, since that is what changes the math.

How does the Debt Register feed into covenant math?

Total Funded Debt is usually the other half of a leverage ratio, and it is exactly what the Debt Register totals across every instrument. Feed that total into the covenant headroom forecast once new debt is added or a balloon is refinanced, so the leverage projection is not still running on last quarter's balance.

What if my facility is asset-based, with a borrowing base instead of a covenant set?

The base itself belongs on the borrowing base certificate pack, but any term debt or equipment financing alongside that facility still needs its own schedule. A borrowing base tells a lender what collateral supports today's draw; it says nothing about when a separate term loan's balloon comes due.

Why does it matter if two maturities land in the same window?

The OCC's own guidance on refinance risk tells banks to monitor the volume and cadence of upcoming loan maturities at the portfolio level, not loan by loan. A borrower needs the same view for the same reason. Two instruments maturing in the same window are one refinancing conversation, not two, and neither lender's own paperwork will tell you that on its own.

Sources

  1. reinhartlaw.comOne law firm's worked comparison (opens in a new tab)
  2. OCCCommercial Lending: Refinance Risk (opens in a new tab)

Written by

Chandler Supple

Co-founder & CEO, River

Chandler has spent the last six years working in AI, building tools for millions of users and Fortune 100 companies. In 2025, he co-founded River to build a new kind of operating system for AI agents.

LinkedInGitHubX

Reviewed by

Brian Joseff, Co-founder, River

LinkedInX

Related workspaces

Lender covenant reporting pack

For the full covenant set the same agreements also drive, with this register's totals feeding straight into the leverage math.

Covenant headroom forecast

Projects the leverage ratio forward from the Total Funded Debt this register keeps current.

Borrowing base certificate pack

For the collateral side of an asset-based facility, alongside whatever term debt sits on this register.

More free templates

Borrowing Base Certificate Template

Free borrowing base certificate template that cuts the AR rate for dilution and caps inventory at the lesser of cost or an appraisal, not a flat rate.

Covenant Waiver Request Letter Template

Free covenant waiver letter template that leads with a quantified cure plan and drafts your lender's own credit committee brief alongside it.

Excess Cash Flow Calculation Template

Free Excess Cash Flow template that traces every addition and deduction to its own credit agreement clause, then nets voluntary prepayments before the sweep.

Monthly Lender Reporting Package Template

Free lender reporting package template: compliance certificate, lettered covenant calculation and borrowing base, built from your own credit agreement.

Build the register your agreements actually specify

Download the blank pack as Word and CSV files, or open it in River and let the agent extract rate, term and amortization from your own loan and lease agreements.

Edit with AI