Amortization Schedule

The row-by-row loan schedule that doesn't drift by the last payment

Builds a full period-by-period amortization schedule — principal, interest, PMI, extra-principal, running balance — for monthly or daily-accrual loans, with the last payment corrected to actually zero the balance instead of drifting by rounding error. Handles biweekly acceleration, one-off or recurring extra principal, and PMI cancellation at 80/78% LTV.

1264.14 / period

1264.14 per monthly period at 6.5% (monthly compounding): 360 periods, total interest 255085.82. Payoff after 360 periods.

Total interest
255085.82
Total PMI
0.00
Payoff
period 360
Final payment
1259.56 (-4.58)

Schedule (first 12 and last 3 rows)

#DateInterestPrincipalExtraPaymentBalance
11083.33180.811264.14199819.19
21082.35181.791264.14199637.40
31081.37182.771264.14199454.63
41080.38183.761264.14199270.87
51079.38184.761264.14199086.11
61078.38185.761264.14198900.35
71077.38186.761264.14198713.59
81076.37187.771264.14198525.82
91075.35188.791264.14198337.03
101074.33189.811264.14198147.22
111073.30190.841264.14197956.38
121072.26191.881264.14197764.50
35820.301243.841264.142503.35
35913.561250.581264.141252.77
3606.791252.771259.560.00

Worth knowing

  • The final payment is 1259.56, not 1264.14. Every other row pays the standard amount; the last one is recomputed as the remaining balance plus that period's interest so the schedule ends at exactly zero, instead of drifting by rounding error the way a naive spreadsheet does over this many rows.
  • Not a lender payoff quote. This is a planning estimate built from the numbers supplied, not a payoff quote, a TILA/RESPA disclosure, or tax advice. It does not model an ARM rate change, an escrow shortage, a late fee, or a servicer applying its own rounding. Check it against a real statement rather than in place of one.

Built for agents too

The API and MCP surfaces accept the full shape — including extraPrincipal (one-off or recurring) and pmi (cancellation at 78% or 80% LTV) — which this simple form leaves out to stay usable.

curl -X POST 'https://amortize.gumballtools.com/api/v1/run' -H 'content-type: application/json' -d '{"principal":200000,"annualRatePercent":6.5,"termMonths":360,"compounding":"monthly"}'

API and MCP setup · llms.txt

Questions people actually ask

Why does my real amortization table end with a different final payment than every other row?

Because the standard payment formula only pays a loan to exactly zero in infinite-precision arithmetic. Once every payment is rounded to the cent, rounding compounds across dozens or hundreds of rows, so the last row almost never has exactly the standard payment's worth of principal left. This tool recomputes the final row as the remaining balance plus that row's interest, so it ends at exactly zero instead of a few cents or dollars off — and reports the delta explicitly rather than hiding it.

Should I pick monthly or daily compounding?

Monthly compounding (rate ÷ 12 applied once per payment) is the norm for fixed-rate mortgages. Daily accrual — interest computed on the actual number of days since the last payment — is how most HELOCs, many auto loans, and most private student loans actually work. Check your note or disclosure statement; it usually says "interest accrues daily" or gives a per-diem rate if it is a daily-accrual loan. Guessing wrong produces a plausible but genuinely different schedule, not just a rounding difference.

Why do I need to give a start date for daily compounding?

Because daily accrual depends on how many days are actually in each period — 28 to 31 for a monthly payment, and one extra during a leap year if February falls inside the period. A real loan has a start date, so this tool reads those day counts straight off the calendar instead of asking you whether your term happens to cross a leap year. Only a hypothetical loan with no dates falls back to an assumed day-count basis (30/360, actual/365, or actual/actual) — and in that case, because every period is assumed the same length, all three bases and monthly compounding actually produce the same numbers. The conventions only diverge once real dates introduce months of different lengths.

What does an extra $200 a month actually do to my payoff date?

It depends on your balance, rate, and how far into the loan you are — there is no fixed rule of thumb, which is why this needs an actual recalculation rather than an estimate. Supply `extraPrincipal` as either a one-off amount at a specific payment number or a recurring amount starting from a given payment number, and the tool returns the schedule both with and without it, so the periods and interest saved are explicit rather than guessed.

When does PMI actually drop off?

The Homeowners Protection Act requires automatic termination once your balance reaches 78% of the home's original value, on the original amortization schedule. You can also request cancellation earlier, at 80%. This tool models both thresholds against your ACTUAL balance (including any extra principal you have paid), which can put its cancellation point earlier than your servicer's — the servicer is legally permitted to use the original schedule instead unless your payment history qualifies you for early cancellation. Confirm the exact date with your servicer, especially if you have overpaid.

What happens if my payment is too small to ever pay off the loan?

This is a real condition called negative amortization: if a payment does not exceed the interest charged in the very first period, the balance can never shrink, and a schedule would run forever. This tool refuses to produce a schedule in that case and states the minimum payment that would actually make progress on principal, rather than silently returning a table that never reaches zero.

Is a biweekly payment actually a lower rate?

No — "biweekly" here means paying half of the standard monthly payment every 14 days. Since a year has 26 fourteen-day periods rather than 24 half-months, that works out to 13 full monthly payments a year instead of 12. The extra payment, not a rate discount, is what shortens the payoff.

Is this a substitute for my lender's payoff statement?

No. This is a planning estimate built from the numbers you supply. It does not know about an ARM's future rate changes, escrow, late fees, or a servicer's specific rounding or PMI-timing rules. Use it to sanity-check a statement or plan ahead of one, not to replace one.

This is not a lender's payoff quote, a TILA/RESPA disclosure, or tax or accounting advice, and it does not model rate changes on an ARM, escrow shortages, late fees, or a servicer's specific PMI-cancellation policy (which by law may use the original amortization schedule rather than your actual balance). Treat its numbers as a planning estimate to check your statement against, not a substitute for it.