Business Debt Schedule
All your business loans in one place: debt service by month and year, what's current vs. long-term on the balance sheet, the maturity ladder, and the weighted-average rate.
Ben / Reviewed Sep 27, 2026 / v2.0.0
Results
Showing the numbers you calculatedHeads up
- Variable-rate debt is projected at today's rate: Credit union line of credit.
- Equipment note: the payment doesn't pay the debt off by maturity — a $20,814.29 balloon is due 06/01/2029.
- Total debt
- $167,000.00
- 3 debts · weighted avg 6.69%
- Current portion
- $55,820.23
- Principal due in the next 12 months
- Long-term portion
- $111,179.77
- Weighted-average rate
- 6.69%
- Debt service, next 12 months
- $65,575.72
- Principal + interest
- Interest to maturity
- $20,136.16
- Last maturity
- 12/15/2030
By debt
Swipe the table sideways to see all 8 columns.
| Debt | Balance | Rate | Payment | Matures | Balloon | Current | Long-term |
|---|---|---|---|---|---|---|---|
| First National — term loan | $100,000.00 | 6.00% | $2,348.50 | 12/15/2030 | $0.00 | $22,802.30 | $77,197.70 |
| Equipment note | $42,000.00 | 7.25% | $900.00 | 06/01/2029 | $20,814.29 | $8,017.93 | $33,982.07 |
| Credit union line of credit | $25,000.00 | 8.50% | $177.08 | 09/05/2027 | $25,000.00 | $25,000.00 | $0.00 |
Maturities (principal due)
12-month windows after the reporting date — the footnote table.
| Period | After | Through | Principal |
|---|---|---|---|
| Year 1 | 12/31/2026 | 12/31/2027 | $55,820.23 |
| Year 2 | 12/31/2027 | 12/31/2028 | $32,827.65 |
| Year 3 | 12/31/2028 | 12/31/2029 | $51,064.92 |
| Year 4 | 12/31/2029 | 12/31/2030 | $27,287.20 |
| Year 5 | 12/31/2030 | 12/31/2031 | $0.00 |
| Thereafter | 12/31/2031 | — | $0.00 |
Debt service by year
Swipe the table sideways to see all 6 columns.
| Year | Beginning | Interest | Principal | Debt service | Ending |
|---|---|---|---|---|---|
| 2027 | $167,000.00 | $9,755.49 | $55,820.23 | $65,575.72 | $111,179.77 |
| 2028 | $111,179.77 | $6,154.35 | $32,827.65 | $38,982.00 | $78,352.12 |
| 2029 | $78,352.12 | $3,331.37 | $51,064.92 | $54,396.29 | $27,287.20 |
| 2030 | $27,287.20 | $894.95 | $27,287.20 | $28,182.15 | $0.00 |
Debt service by month
Swipe the table sideways to see all 8 columns.
| Month | Beginning | Interest | Principal | Extra | Balloon | Debt service | Ending |
|---|---|---|---|---|---|---|---|
| Jan 2027 | $167,000.00 | $930.83 | $2,494.75 | $0.00 | $0.00 | $3,425.58 | $164,505.25 |
| Feb 2027 | $164,505.25 | $917.69 | $2,507.89 | $0.00 | $0.00 | $3,425.58 | $161,997.36 |
| Mar 2027 | $161,997.36 | $904.47 | $2,521.11 | $0.00 | $0.00 | $3,425.58 | $159,476.25 |
| Apr 2027 | $159,476.25 | $891.18 | $2,534.40 | $0.00 | $0.00 | $3,425.58 | $156,941.85 |
| May 2027 | $156,941.85 | $877.82 | $2,547.76 | $0.00 | $0.00 | $3,425.58 | $154,394.09 |
| Jun 2027 | $154,394.09 | $864.39 | $2,561.19 | $0.00 | $0.00 | $3,425.58 | $151,832.90 |
| Jul 2027 | $151,832.90 | $850.90 | $2,574.68 | $0.00 | $0.00 | $3,425.58 | $149,258.22 |
| Aug 2027 | $149,258.22 | $837.32 | $2,588.26 | $0.00 | $0.00 | $3,425.58 | $146,669.96 |
| Sep 2027 | $146,669.96 | $823.68 | $2,601.90 | $0.00 | $25,000.00 | $28,425.58 | $119,068.06 |
| Oct 2027 | $119,068.06 | $632.88 | $2,615.62 | $0.00 | $0.00 | $3,248.50 | $116,452.44 |
| Nov 2027 | $116,452.44 | $619.10 | $2,629.40 | $0.00 | $0.00 | $3,248.50 | $113,823.04 |
| Dec 2027 | $113,823.04 | $605.23 | $2,643.27 | $0.00 | $0.00 | $3,248.50 | $111,179.77 |
Every payment
Swipe the table sideways to see all 8 columns.
| Date | Debt | # | Payment | Interest | Principal | Balloon | Balance |
|---|---|---|---|---|---|---|---|
| 01/01/2027 | Equipment note | 1 | $900.00 | $253.75 | $646.25 | $0.00 | $41,353.75 |
| 01/05/2027 | Credit union line of credit | 1 | $177.08 | $177.08 | $0.00 | $0.00 | $25,000.00 |
| 01/15/2027 | First National — term loan | 1 | $2,348.50 | $500.00 | $1,848.50 | $0.00 | $98,151.50 |
| 02/01/2027 | Equipment note | 2 | $900.00 | $249.85 | $650.15 | $0.00 | $40,703.60 |
| 02/05/2027 | Credit union line of credit | 2 | $177.08 | $177.08 | $0.00 | $0.00 | $25,000.00 |
| 02/15/2027 | First National — term loan | 2 | $2,348.50 | $490.76 | $1,857.74 | $0.00 | $96,293.76 |
| 03/01/2027 | Equipment note | 3 | $900.00 | $245.92 | $654.08 | $0.00 | $40,049.52 |
| 03/05/2027 | Credit union line of credit | 3 | $177.08 | $177.08 | $0.00 | $0.00 | $25,000.00 |
| 03/15/2027 | First National — term loan | 3 | $2,348.50 | $481.47 | $1,867.03 | $0.00 | $94,426.73 |
| 04/01/2027 | Equipment note | 4 | $900.00 | $241.97 | $658.03 | $0.00 | $39,391.49 |
| 04/05/2027 | Credit union line of credit | 4 | $177.08 | $177.08 | $0.00 | $0.00 | $25,000.00 |
| 04/15/2027 | First National — term loan | 4 | $2,348.50 | $472.13 | $1,876.37 | $0.00 | $92,550.36 |
| 05/01/2027 | Equipment note | 5 | $900.00 | $237.99 | $662.01 | $0.00 | $38,729.48 |
| 05/05/2027 | Credit union line of credit | 5 | $177.08 | $177.08 | $0.00 | $0.00 | $25,000.00 |
| 05/15/2027 | First National — term loan | 5 | $2,348.50 | $462.75 | $1,885.75 | $0.00 | $90,664.61 |
| 06/01/2027 | Equipment note | 6 | $900.00 | $233.99 | $666.01 | $0.00 | $38,063.47 |
| 06/05/2027 | Credit union line of credit | 6 | $177.08 | $177.08 | $0.00 | $0.00 | $25,000.00 |
| 06/15/2027 | First National — term loan | 6 | $2,348.50 | $453.32 | $1,895.18 | $0.00 | $88,769.43 |
| 07/01/2027 | Equipment note | 7 | $900.00 | $229.97 | $670.03 | $0.00 | $37,393.44 |
| 07/05/2027 | Credit union line of credit | 7 | $177.08 | $177.08 | $0.00 | $0.00 | $25,000.00 |
| 07/15/2027 | First National — term loan | 7 | $2,348.50 | $443.85 | $1,904.65 | $0.00 | $86,864.78 |
| 08/01/2027 | Equipment note | 8 | $900.00 | $225.92 | $674.08 | $0.00 | $36,719.36 |
| 08/05/2027 | Credit union line of credit | 8 | $177.08 | $177.08 | $0.00 | $0.00 | $25,000.00 |
| 08/15/2027 | First National — term loan | 8 | $2,348.50 | $434.32 | $1,914.18 | $0.00 | $84,950.60 |
What this does
Most small businesses have more than one loan — a term loan, an equipment note, a line of credit. This puts them on one schedule so you can see total debt service by month and year, what's due when, and how the debt should be split on the balance sheet.
It's the schedule a lender, a CPA, or a buyer asks for: balances, rates, maturities, current vs. long-term. The spreadsheet has every debt's schedule plus the consolidated and maturity views, all as formulas.
How the math works
Each debt gets its own amortization schedule from its next payment through maturity (the same engine as the other loan calculators). Then everything is rolled up:
- Debt service by month and by year = the sum of every debt's payments dated in that month or year.
- Ending balance each month = every debt's balance after its last payment in or before that month — debts without a payment that month still count.
- Current portion = principal contractually due in the 12 months after the reporting date (including any balloon). The rest is long-term.
- Maturity ladder = the same contractual principal, bucketed into the next five 12-month periods and "thereafter" — the table that goes in the footnotes.
weighted-average rate = Σ (balance × rate) ÷ Σ balance
The current portion is principal only. Accrued interest is a separate current liability, and the monthly interest is an expense — neither belongs in "current portion of long-term debt."
Check my math: a worked example
3 debts totaling $167,000.00 as of the reporting date, at a weighted-average rate of 6.69%.
- First National — term loan: $100,000.00 at 6.00%, $2,348.50 per payment — $22,802.30 current, $77,197.70 long-term.
- Equipment note: $42,000.00 at 7.25%, $900.00 per payment, $20,814.29 balloon at 06/01/2029 — $8,017.93 current, $33,982.07 long-term.
- Credit union line of credit: $25,000.00 at 8.50%, $177.08 per payment, $25,000.00 balloon at 09/05/2027 — $25,000.00 current, $0.00 long-term.
- Next 12 months of debt service: $65,575.72.
On the balance sheet: $55,820.23 current portion of long-term debt, $111,179.77 long-term. Total interest from here to the last maturity (12/15/2030): $20,136.16.
These numbers come straight from the calculator using its example inputs — if the math ever changes, this example changes with it.
Mistakes I see a lot
- Putting a whole loan in current liabilities because it matures "soon." Only the principal due within 12 months is current (unless the whole thing is due within the year).
- Forgetting the line of credit balloon. An interest-only line that matures in 9 months is entirely current.
- Using the payment instead of the principal for the current portion. The interest part of next year's payments isn't a liability yet.
- Leaving variable-rate debt at today's rate forever. Fine for a projection, but flag it for anyone reading the schedule.
Questions people ask
- What balance should I enter?
- The principal balance as of the reporting date — usually from the lender statement or your loan account reconciliation. The next payment date should be after the reporting date.
- How do I show a balloon?
- Enter the actual payment. If it doesn't pay the loan off by maturity, the remaining principal is a balloon due with the last payment. For interest-only debt, choose "interest only" and the whole balance is due at maturity.
- Do extra payments change the current portion?
- No. Voluntary prepayments aren't contractual, so the classification and maturity ladder use the contractual schedule. The debt-service projection does include your planned extras.
- Does the spreadsheet recalculate?
- Balances, rates, payments, extras, and the reporting date are live inputs. Dates and payment frequency set the rows for each debt, so change those on the website and download again.
Assumptions and limits
- Balances are as of the reporting date; each debt's schedule runs from its next payment through maturity (the last payment date on its cycle that's on or before the maturity date).
- Leave a debt's payment blank and it's the level payment that pays it off by maturity. Enter a smaller payment and whatever is left is a balloon due at the last payment; interest-only debts pay interest and the full balance at maturity.
- Current portion = principal (including balloons) contractually due in the 12 months after the reporting date. Voluntary extra principal doesn't change the classification — it isn't an obligation.
- The maturity ladder uses the same contractual principal in 12-month windows after the reporting date: years 1–5 and thereafter.
- Weighted-average rate = Σ (balance × rate) ÷ Σ balances, as of the reporting date.
- Fixed-rate math with lender-style rounding. Variable-rate debt is projected at today's rate. No fees, covenants, or lines of credit drawn up and down.
Disclaimer: Educational and planning use only. Results depend on what you enter and may not match your lender, your tax return, or professional accounting treatment. Informational content + opinions only — not tax/legal advice.