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.
Build the schedule from the numbers that drive the loan
Start with the loan amount, annual rate, term, payment frequency and start date. Then test recurring or one-time extra principal payments to see whether the payoff date, interest cost and balance curve change enough to matter.
Loan inputs
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.
Quick payoff notes
Early payments are usually 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
The visual interpretation will appear after calculation.
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.
The balance-path interpretation will appear here.
Interest versus principal split
Reveals how the payment changes from interest-heavy to principal-heavy over time.
The payment-split interpretation will appear here.
Extra-payment strategy comparison
Compares interest saved and months saved across payoff scenarios.
The scenario comparison interpretation will appear here.
Cumulative interest cost
Shows how much interest accumulates over the life of the loan and how extra principal changes that curve.
The cumulative-interest interpretation will appear here.
Your Smart Results, tables, scenario comparison and Excel export remain available with the same calculation 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
How to use the amortization schedule calculator
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, that is usually the original principal. 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 usually comes from those headline relationships.
What your amortization result actually means
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.
How to make a loan payoff decision
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.
Real amortization scenarios
The same payment can tell very different stories depending on the rate, remaining term and how early extra principal is applied.
New 30-year mortgage
A borrower sees a manageable payment but notices the first-year interest share is high.
The payment is normal, but the balance falls slowly in the early years. A small recurring extra payment can be more powerful when started early.
Main risk: Judging the loan only by monthly payment.Auto loan with a high rate
The balance is smaller than a mortgage, but the interest rate is high enough that early payoff may be attractive.
If the saved-per-extra-dollar result is strong and there is no prepayment penalty, extra principal may beat waiting.
Main risk: Using extra cash without keeping an emergency buffer.Loan already halfway through
The borrower has a lower remaining balance and principal already makes up more of each payment.
Extra payments can still help, but the biggest interest-saving window may have already passed.
Main risk: Expecting the same savings as an early-loan payoff strategy.Common amortization mistakes
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.
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.
How the amortization calculation works
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.
Each schedule row
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.
Final payment adjustment
The last payment is reduced when needed so the ending balance reaches zero without going negative. This prevents exaggerated final-period principal.
What is not included
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.