Loan Amortization Generator

Generate a full period-by-period amortization schedule for any loan. See payment, principal, interest, and remaining balance for monthly, biweekly, or weekly payments.

$
%
yr
per period
$
Payment
$1,580.17
per month
Total Interest
$318,861.00
Total interest over loan life
Total Paid
$568,861.00
Sum of all values
Payoff
30 years
360 payments

Yearly Summary

Click a year to expand the full period-by-period schedule.

YearPrincipalInterestEnd Balance
โ–ถ Year 1$2,794.31$16,167.73$247,205.69
โ–ถ Year 2$2,981.45$15,980.59$244,224.23
โ–ถ Year 3$3,181.13$15,780.91$241,043.10
โ–ถ Year 4$3,394.17$15,567.87$237,648.93
โ–ถ Year 5$3,621.49$15,340.55$234,027.44
โ–ถ Year 6$3,864.03$15,098.02$230,163.42
โ–ถ Year 7$4,122.81$14,839.23$226,040.61
โ–ถ Year 8$4,398.92$14,563.12$221,641.69
โ–ถ Year 9$4,693.52$14,268.52$216,948.17
โ–ถ Year 10$5,007.86$13,954.18$211,940.32
โ–ถ Year 11$5,343.24$13,618.80$206,597.07
โ–ถ Year 12$5,701.09$13,260.95$200,895.99
โ–ถ Year 13$6,082.90$12,879.14$194,813.09
โ–ถ Year 14$6,490.28$12,471.76$188,322.80
โ–ถ Year 15$6,924.95$12,037.09$181,397.85
โ–ถ Year 16$7,388.73$11,573.31$174,009.13
โ–ถ Year 17$7,883.56$11,078.48$166,125.56
โ–ถ Year 18$8,411.54$10,550.50$157,714.02
โ–ถ Year 19$8,974.88$9,987.16$148,739.15
โ–ถ Year 20$9,575.94$9,386.10$139,163.21
โ–ถ Year 21$10,217.26$8,744.78$128,945.95
โ–ถ Year 22$10,901.53$8,060.51$118,044.42
โ–ถ Year 23$11,631.62$7,330.42$106,412.80
โ–ถ Year 24$12,410.61$6,551.43$94,002.18
โ–ถ Year 25$13,241.78$5,720.26$80,760.41
โ–ถ Year 26$14,128.60$4,833.44$66,631.80
โ–ถ Year 27$15,074.82$3,887.22$51,556.98
โ–ถ Year 28$16,084.41$2,877.63$35,472.57
โ–ถ Year 29$17,161.61$1,800.43$18,310.96
โ–ถ Year 30$18,310.96$651.08$0.00
Planning notes, formulas, and examples

About the Loan Amortization Generator

An amortization schedule shows exactly how each loan payment is split between principal and interest over the entire life of the loan. Early payments are mostly interest; later payments are mostly principal. Understanding this breakdown is essential for financial planning, tax preparation, and deciding whether to make extra payments.

The Loan Amortization Generator creates a complete period-by-period schedule for any loan amount, rate, and term. Choose monthly, biweekly, or weekly payment frequencies. Each row shows the payment number, payment amount, principal portion, interest portion, and remaining balance.

Use this calculator for mortgages, auto loans, personal loans, student loans, or any fixed-rate amortizing loan. The yearly summary provides a quick high-level view, while the full schedule gives granular detail. Seeing exactly how much of each payment goes to principal versus interest empowers you to evaluate extra payment strategies and understand the true timeline of your debt. Amortization awareness is the foundation of smart loan management.

When This Page Helps

Most loan calculators show only the monthly payment and total interest. An amortization schedule reveals the full story โ€” how much of each payment reduces your balance, when you cross the halfway point, and how dramatically the interest-to-principal ratio shifts over time. This information helps you decide when extra payments have the most impact.

How to Use the Inputs

  1. Enter the loan amount, interest rate, and term.
  2. Select the payment frequency (monthly, biweekly, or weekly).
  3. Optionally enter an extra payment amount applied each period.
  4. View the yearly summary for a high-level overview.
  5. Expand any year to see the full period-by-period schedule.
  6. Note how early payments are mostly interest and later payments are mostly principal.
Formula used
Payment = P ร— r(1+r)^n / ((1+r)^n โˆ’ 1). Period interest = Remaining balance ร— periodic rate. Period principal = Payment โˆ’ Period interest. New balance = Previous balance โˆ’ Period principal.

Example Calculation

Result: $1,580.17/month, $318,861 total interest

A $250,000 loan at 6.5% for 30 years (360 payments) has a monthly payment of $1,580.17. In month 1, $1,354.17 goes to interest and only $226.00 goes to principal. By month 180 (halfway), interest drops to $886.77 and principal rises to $693.40. In the final month, nearly the entire payment is principal. Total interest over 30 years: $318,861.

Tips & Best Practices

  • Early in the loan, 60-90% of each payment goes to interest โ€” extra payments here have the biggest impact.
  • Biweekly payments (26 per year = 13 monthly equivalents) pay off a 30-year mortgage ~4-5 years early.
  • Print or save your amortization schedule for tax purposes โ€” mortgage interest is tax-deductible.
  • Check your schedule against your lender's statement to verify they are applying payments correctly.
  • Use the extra payment feature to see how even $50/month extra accelerates payoff.
  • The crossover point (where principal exceeds interest) typically occurs 60-70% through the loan term.

Reading Your Amortization Schedule

Each row contains five key columns: payment number, total payment, principal portion, interest portion, and remaining balance. Watch how the principal and interest columns shift over time โ€” this is the amortization curve in action. The remaining balance column shows your progress toward payoff.

The Power of Extra Payments

Adding even small amounts to your regular payment has an outsized impact early in the loan. A $200/month extra payment on a $300,000 mortgage at 7% saves over $120,000 in interest and cuts 8 years off the term. The earlier you start making extra payments, the more you save.

Biweekly vs Monthly

Switching from monthly to biweekly payments is one of the easiest ways to accelerate loan payoff without significantly increasing your budget. Since most people are paid biweekly, aligning loan payments with paychecks can also improve cash flow management.

Using the Schedule for Tax Planning

Mortgage interest is tax-deductible for many homeowners. Your amortization schedule shows exactly how much interest you paid each year, which should match your lender's Form 1098. In the early years, the deduction is largest because interest comprises the majority of each payment.

Sources & Methodology

Last updated:

Methodology

This worksheet applies the standard fixed-rate amortization formula and expands it into a full period-by-period schedule using the selected payment frequency. Each row recalculates interest on the remaining balance, allocates the remainder to principal, and reduces the balance until payoff.

The generator is designed for scenario planning and repayment tracking, not lender statements or legal disclosure documents.

Sources

  • Amortized loans (Consumer Financial Protection Bureau) โ€” Consumer explanation of amortization and fixed-payment repayment.
  • Installment loan basics (U.S. Securities and Exchange Commission) โ€” Fixed-installment loan structure and repayment basics.

Frequently Asked Questions

  • Amortization is the process of spreading a loan into a series of fixed payments over time. Each payment includes both principal (reducing the balance) and interest (cost of borrowing). The schedule ensures the loan is fully repaid by the end of the term.