Amortization Schedule Calculator USA
See how each loan payment splits between interest and principal, when the balance starts falling faster, and whether extra principal payments save enough time and interest to be worth reviewing.
See the amortization formula, frequency assumptions and model boundaries
Formula and constants
For a positive periodic rate: Payment = P × r × (1 + r)n ÷ ((1 + r)n − 1). At 0%, Payment = P ÷ n.
The stated annual rate is divided by 12, 24, 26 or 52 for monthly, semi-monthly, bi-weekly or weekly schedules. The term is multiplied by the same periods-per-year value.
Model version: NH-AMORT-US-2026.07. Source review: 2026-07-31.
Extra principal and rounding
Recurring extra principal is applied after interest on each payment. A one-time amount is applied at the selected payment number. The annual amount is applied after the last scheduled payment in each payment year: payment 12, 24, 26 or 52 by frequency.
Cents mode rounds each row to two decimals; full-precision mode retains internal decimals. The last payment is capped so the balance reaches zero without becoming negative.
Included in this estimate
- Fixed stated rate and regular amortizing payments
- Principal, interest, remaining balance and payoff date
- Recurring, one-time and once-per-payment-year extra principal
- Original-loan and remaining-balance schedules
Outside this estimate
- Taxes, homeowners insurance, PMI, HOA dues and escrow
- Fees, APR components, ARM resets and refinance closing costs
- Daily-interest conventions, lender-specific compounding and servicing rules
- Prepayment limits or penalties; check the loan agreement
Official sources that define the model and its boundaries
These sources support the principal-and-interest split, balance-based interest, exclusions from total housing payment, extra-principal effect and prepayment caution.
Build the schedule from the numbers that drive the loan
Start with the loan amount, annual rate, term, payment frequency and first scheduled payment month. Then test recurring or one-time extra principal payments to see whether the payoff date, interest cost and balance curve change enough to matter.
Set the balance, rate and payoff strategy
Correct the values below before calculating the amortization schedule.
Keep these defaults unless you are modeling a loan already in progress or need a lender-style rounding view. Taxes, insurance, escrow and refinance costs are intentionally not included here.
Large extra payments can be limited by lender rules, prepayment penalties or loan-servicing policies. Check the loan agreement before treating a strategy as final.
Checks before you trust the payoff date
In a standard fixed-rate amortizing schedule, early payments are interest-heavy because the balance is still large.
Extra principal works best when it reduces the balance early enough to affect future interest.
A lender schedule may differ because of due dates, rounding, fees or servicing rules.
Calculate first, then export the full schedule and yearly payoff milestones.
AmortizationMap™ Payment Flow
Follow the loan from the first scheduled payment to the payoff date and see exactly how interest, principal, extra payments and balance reduction interact.
Your payment-flow verdict
Which payoff strategy changes the loan enough to matter?
Compare the baseline schedule with extra principal strategies. A scenario is recommended only when the saved interest, shortened payoff time or saved-per-extra-dollar result is material.
Extra-payment scenarios are planning estimates. Some lenders restrict prepayments, apply payments differently, or charge penalties. Always check how extra principal is handled before sending a large lump sum.
How the amortization result is built
Trace the scheduled payment, interest cost, principal reduction, extra-payment effect and payoff decision in one reconciled view.
| Component | Amount | Note |
|---|
Follow the balance year by year
Annual rows show how much interest is paid, how much principal is removed, and when the payoff path starts gaining momentum.
| Year | Payments | Interest | Principal | Extra principal | Ending balance | Paid off |
|---|
Open the complete payment-by-payment schedule
Each row shows the beginning balance, interest, scheduled principal, extra principal, ending balance and cumulative payoff progress.
| # | Payment date | Beginning balance | Scheduled payment | Interest | Scheduled principal | Extra principal | Total principal | Ending balance | Cumulative interest | Cumulative principal | % paid off |
|---|
The final payment is adjusted so the balance does not go below zero. Actual lender schedules may differ because of due dates, rounding, escrow handling, fees or servicing rules.
See how interest fades and principal momentum builds
Each chart answers a different payoff question instead of repeating the schedule table.
Balance decline: baseline versus accelerated
Shows whether extra principal meaningfully changes the balance curve and payoff date.
Interest versus principal split
Reveals how the payment changes from interest-heavy to principal-heavy over time.
Extra-payment strategy comparison
Compares interest saved and months saved across payoff scenarios.
Cumulative interest cost
Shows how much interest accumulates over the life of the loan and how extra principal changes that curve.
Your calculated results, tables, scenario comparison and Excel export remain available with the same values.
Export the complete amortization workbook
Download a styled Excel report built from the latest result object. The workbook includes the verdict, payoff comparison, yearly milestones, full schedule, scenario data, chart data and methodology notes.
- 01Summary
- 02Baseline Schedule
- 03Accelerated Schedule
- 04Yearly Summary
- 05Scenario Comparison
- 06Chart Data
- 07Assumptions & Methodology
Build a schedule that matches the loan agreement
Use the numbers from the loan agreement or lender quote. A small rate or term change can move thousands of dollars between interest and principal over the full schedule.
Enter the amount being amortized
Use the loan balance that the payment is based on. For a new loan, use the original principal shown in the agreement. For a loan already in progress, use remaining-balance mode in Advanced.
Match the rate, term and frequency
The scheduled payment depends on the periodic interest rate and number of payments. Monthly, bi-weekly and weekly schedules should not be mixed when comparing payoff dates.
Test extra principal separately
Extra principal should be treated as a strategy, not as part of the scheduled payment. That keeps the baseline and accelerated schedules easy to compare.
Read the verdict before the table
Start with total interest, crossover month, months saved and saved per extra dollar. The full schedule is useful, but the decision is driven by those headline relationships. If the payment itself may be too aggressive for household income, check the wider approval and comfort zone with the Mortgage Affordability Calculator USA before treating the amortization schedule as a green light.
Read the four numbers that control the payoff
Amortization is the path from debt balance to zero. The payment may stay level, but the inside of that payment changes every period as the balance falls.
Total interest over the schedule
The scheduled payment tells you the monthly obligation. Total interest tells you the real cost of carrying the loan over time. A low payment can still be expensive if the term is long and the rate is high.
Principal crossover
This is the first payment where principal exceeds interest. Before that point, the loan can feel slow because a large share of each payment is still paying interest.
Interest saved
Interest saved is useful only when compared with the extra cash required. A strategy that saves interest but consumes too much cash flow may not be practical.
Months saved
Months saved shows how much sooner the debt disappears. It matters most when the earlier payoff frees cash flow for another goal.
Choose between scheduled payoff, extra principal and refinancing
A stronger payoff decision balances interest savings, cash-flow pressure, lender rules and the opportunity cost of using money for extra principal.
Early payments are mostly interest
This is normal for long loans, but it is also where early extra principal can have the biggest lifetime effect.
The loan is amortizing normally
The schedule is working, but the decision depends on whether the interest cost is acceptable for the term.
Extra principal changes the payoff timeline
A payoff strategy becomes more compelling when it saves both meaningful interest and meaningful time.
The math may not match lender rules
Prepayment limits, penalty windows, escrow handling and exact due dates can change the real-world result.
Three loan schedules that behave very differently
Each case below was calculated with model NH-AMORT-US-2026.07 using a first scheduled payment in August 2026. They show why balance, rate, remaining term and the timing of extra principal must be read together.
A $200 monthly extra on a new 30-year mortgage
$350,000 at 6.50% for 30 years; $2,212.24 scheduled monthly payment.
A $100 monthly extra on a six-year auto loan
$35,000 at 9.50% for 6 years; $639.61 scheduled monthly payment.
A $7,500 lump sum on a remaining-balance schedule
$187,500 at 4.75% with 17 years remaining; $1,341.34 monthly payment and the lump sum at payment 6.
Amortization assumptions that distort the payoff date
Most wrong payoff decisions come from mixing payment types, ignoring lender rules, or treating interest savings as automatically better than liquidity.
Comparing different payment frequencies casually
A monthly schedule and a bi-weekly schedule do not always represent the same annual cash flow. Compare total annual payments before drawing conclusions.
Ignoring prepayment rules
Some loans restrict lump sums or apply extra payments in a specific way. The strategy is only useful if the lender applies the money to principal.
Forgetting escrow and fees
Taxes, insurance, PMI and servicing fees can affect cash flow but are not part of the principal-and-interest amortization formula. If PMI is part of the loan, estimate the removal timeline with the PMI Removal Date Calculator USA instead of assuming it disappears automatically. If property tax is the missing cost layer, isolate it with the Property Tax Calculator USA. For the full housing-cost picture beyond principal and interest, compare the result with the Total Cost of Homeownership Calculator USA.
Using all spare cash for extra principal
Paying down debt faster can be smart, but not if it removes the cash buffer needed for repairs, emergencies or higher-priority debt.
From periodic interest to the final zero-balance payment
The scheduled payment is calculated first. Then each payment period updates the balance by applying interest, scheduled principal and any extra principal.
Scheduled payment formula
For a positive periodic rate, the scheduled payment is:
P is the loan amount, r is the periodic interest rate, and n is the number of scheduled payments. If the rate is zero, the payment equals principal divided by payment count.
Interest first, then scheduled and extra principal
Interest equals beginning balance multiplied by the periodic rate. Scheduled principal equals scheduled payment minus interest. Extra principal is added only after interest is covered.
Why the last payment can be smaller
The last payment is reduced when needed so the ending balance reaches zero without going negative. This prevents exaggerated final-period principal.
Costs outside the principal-and-interest schedule
Property taxes, insurance, PMI, HOA dues, escrow, tax deductions, refinance closing costs, ARM resets and prepayment penalties are not modeled in the payment formula.
Amortization schedule questions
These answers explain how to read the schedule and why the lender’s version may not match every row exactly.
An amortization schedule is a payment-by-payment table showing how each loan payment is split between interest and principal until the balance reaches zero.
The payment is calculated from the loan amount, periodic interest rate and number of payments. If the rate is zero, the principal is divided evenly across the payment count.
Interest is based on the current balance. Early in the loan, the balance is high, so the interest charge takes a larger share of each scheduled payment.
Principal overtakes interest when the scheduled principal portion of a payment becomes larger than the interest portion. The exact payment number depends on the rate, term and balance.
Extra principal reduces the balance faster. A lower balance means future interest charges are smaller, which can shorten the payoff time and reduce total interest.
Yes. After calculation, the Excel export includes the summary, baseline schedule, accelerated schedule, yearly summary, scenario comparison, chart data and methodology notes.
Lender schedules can differ because of exact payment dates, rounding, servicing rules, escrow handling, fees, holidays or how extra payments are applied.
No. The schedule models principal and interest. Property tax, insurance, PMI, HOA dues and escrow items belong to total housing-cost analysis, not the amortization formula.
No. The calculator can show the math effect of extra principal, but it does not model lender penalties or restrictions. Check the loan agreement before making a large extra payment.
No. It can model many standard amortizing loans, including mortgages, auto loans and personal loans, as long as the payment follows a regular amortization structure.