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.
Free download · No account needed
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.
What's in the pack
Debt Register
Lender, rate, day-count convention and amortization term per instrument, pulled from the agreement itself, not a servicer summary.
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.
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.
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.
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
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
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
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
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.
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