Loan calculator

Amortization Calculator

An amortization calculator shows how each loan payment is split between principal and interest over time.

Calculator

Loan amortization schedule

Build your loan amortization schedule

Enter the loan, choose a payment frequency, and optionally add extra payments. The full schedule, payoff date, and interest savings update instantly.

Works for any fixed-rate loan — mortgage, auto, personal, or student. This compares principal & interest only; fees, escrow, taxes, and insurance are not part of amortization.

Basic loan details$250,000 · 6.50% · 30 years · Monthly

The core loan: amount, rate, term, start date, and payment frequency.

$

The amount borrowed (the starting balance).

%

Decimals supported, e.g. 6.5. Enter 0 for an interest-free loan.

In the unit selected on the right.

360 months · 360 monthly payments.

Used to label payment dates.

Standard monthly schedule — 12 payments/year.

Extra paymentsNone — optional

Optional. Add extra principal to pay the loan off sooner and cut total interest. Leave blank for a standard schedule.

$

Added to principal every month.

When the extra per-period amount begins.

$

A lump sum once a year.

The yearly extra recurs in this calendar month.

One-time extra payments

$
$
$

Up to 10 one-time rows. Rows with a zero amount are ignored. Extra payments are capped at the remaining balance.

Lenders may apply extra payments differently — some require you to designate them as principal-only. Check your loan terms.

Schedule settingsRounded to nearest unit

Display preferences for the schedule and result figures.

Affects how result figures are displayed; the underlying math is always to the cent.

Monthly payment

$1,580

First payment: $1,354 interest / $226 principal. Payoff Jun 2056.

Formula verified 14 June 2026

6-sheet workbook:SummaryMonthly scheduleYearly summaryExtra paymentsFormulasDisclaimer & sources
Built in your browser from your inputs · no upload

Total principal

$250,000

The amount borrowed.

Total interest

$318,862

Cost of borrowing over the loan.

Total paid

$568,862

Principal + interest.

Payoff date

Jun 2056

Last scheduled payment.

Final payment

$1,581

Trimmed to clear the exact balance.

Add extra payments above to see how much sooner you could be debt-free and how much interest you would save.

Educational estimate — principal & interest only. Your lender's schedule may differ due to fees, escrow, payment timing, and rounding.

Loan payoff summary

Original loan$250,000
Interest rate6.50%
Term30 years
FrequencyMonthly
Monthly payment$1,580
Extra/period
Payoff dateJun 2056
Total interest$318,862
Total paid$568,862
Interest saved
Time saved
First payment split$1,354.17 int / $226.00 prin
Final payment$1,580.55

Planning estimate only. Not a lender payoff statement, APR disclosure, or financial advice.

APR and fees estimateOptional — add fees to estimate APR impact

Estimate how loan fees affect the total cost of borrowing. Add any upfront fees and choose whether they are paid at closing or rolled into the loan.

This is not an official APR disclosure. Official APR requires day-count conventions, prepaid interest, and lender-specific fee categorizations not modelled here.
$

Lender fee charged to originate the loan.

%

Points paid to buy down the rate.

$

Processing, underwriting, or other fees.

Upfront fees reduce net proceeds; rolled-in fees increase the loan balance.

Monthly cost add-onsOptional — property tax, insurance, PMI, HOA

Add monthly ownership costs to see the total housing payment. These are separate from the amortization schedule — they do not affect how principal and interest are calculated.

$

Annual tax ÷ 12.

$

Annual premium ÷ 12.

$

Typically 0.5–1.5% of loan/year ÷ 12.

$

Homeowners association dues.

$

Any other recurring monthly cost.

The amortization schedule above uses only principal & interest. Add-ons are shown here for context; they do not affect principal reduction, interest calculations, or the payoff date.

Scenario comparison

Compare three strategies side by side: no extras, your current extra payment plan, and a shorter loan term.

Loan scenario comparison
MetricBase loan
No extra payments
With extras
Current plan
20-year term
No extra payments
Payment$1,580.17$1,863.93
Total interest$318,862$197,345
Total paid$568,862$447,345
Payoff dateJun 2056Jun 2046
Time saved vs base10 years
Interest saved vs base$121,517

Educational estimate. Shorter-term scenario uses the same rate and no extra payments. Payment amounts may differ from lender quotes.

Key takeaways

  • Your monthly payment is $1,580.17 for 360 periods (30 years).
  • Over the loan you pay about $318,862 in interest — roughly 128% of the amount borrowed.
  • The first payment is mostly interest ($1,354.17) and only $226.00 principal; that shifts as the balance falls.
  • Adding extra principal — even a small amount each period — would shorten the term and cut total interest; try it in the extra-payments section.

Visual breakdown

How the loan splits and shrinks over time. Each chart has a data table beneath it for exact figures.

Cumulative principal vs interest

How much of what you have paid is principal versus interest, by year.

Over the loan you pay $250,000 of principal and $318,862 of interest.

Show data table
Cumulative principal vs interest
YearPrincipalInterest
2026$1,375$8,107
2027$4,261$24,182
2028$7,341$40,065
2029$10,626$55,741
2030$14,132$71,197
2031$17,873$86,418
2032$21,865$101,389
2033$26,123$116,092
2034$30,667$130,510
2035$35,515$144,624
2036$40,688$158,413
2037$46,207$171,856
2038$52,096$184,929
2039$58,379$197,608
2040$65,083$209,866
2041$72,237$221,675
2042$79,869$233,005
2043$88,012$243,824
2044$96,701$254,097
2045$105,971$263,789
2046$115,862$272,859
2047$126,416$281,268
2048$137,677$288,969
2049$149,692$295,916
2050$162,511$302,059
2051$176,189$307,343
2052$190,783$311,711
2053$206,355$315,102
2054$222,969$317,449
2055$240,696$318,684
2056$250,000$318,862

Balance over time

How the remaining balance falls toward zero.

The balance reaches zero at Jun 2056.

Show data table
Balance over time
YearBalance
0$250,000
5$234,027
10$211,940
15$181,398
20$139,163
25$80,761
30$0
35$0
40$0
45$0
50$0

Total interest vs principal

The cost of borrowing next to the amount borrowed.

You pay $318,862 interest on $250,000 borrowed.

Show data table
Total interest vs principal
Amount
Principal$250,000
Interest$318,862

Annual interest paid

Interest paid each calendar year — highest in the first years, falls as the balance shrinks.

Interest payments peak in the first year and fall each year until payoff.

Show data table
Annual interest paid
YearInterest paidPrincipal paid
2026$8,107$1,375
2027$16,076$2,886
2028$15,882$3,080
2029$15,676$3,286
2030$15,456$3,506
2031$15,221$3,741
2032$14,971$3,991
2033$14,703$4,259
2034$14,418$4,544
2035$14,114$4,848

Amortization schedule

First 12 payments shown by default. Switch to yearly summary or show the full schedule. On phones: compact cards.

Payment-by-payment amortization schedule
#DateBeginningPaymentExtraPrincipalInterestEndingCum. interest
1Jul 2026$250,000$1,580.17$226.00$1,354.17$249,774$1,354
2Aug 2026$249,774$1,580.17$227.23$1,352.94$249,547$2,707
3Sep 2026$249,547$1,580.17$228.46$1,351.71$249,318$4,059
4Oct 2026$249,318$1,580.17$229.70$1,350.47$249,089$5,409
5Nov 2026$249,089$1,580.17$230.94$1,349.23$248,858$6,759
6Dec 2026$248,858$1,580.17$232.19$1,347.98$248,625$8,107
7Jan 2027$248,625$1,580.17$233.45$1,346.72$248,392$9,453
8Feb 2027$248,392$1,580.17$234.71$1,345.46$248,157$10,799
9Mar 2027$248,157$1,580.17$235.98$1,344.19$247,921$12,143
10Apr 2027$247,921$1,580.17$237.26$1,342.91$247,684$13,486
11May 2027$247,684$1,580.17$238.55$1,341.62$247,446$14,827
12Jun 2027$247,446$1,580.17$239.84$1,340.33$247,206$16,168
Monthly payment$1,580.17
Result

What this tool shows

Build a full schedule for monthly, biweekly, weekly, or semi-monthly payments, model extra payments to see your early payoff date, and compare scenarios side by side.

  • Payment for monthly, biweekly, weekly, or semi-monthly frequency
  • Full payment-by-payment schedule with CSV export
  • Yearly summary of principal, interest, and balance
  • Extra monthly, yearly, and one-time payments with early payoff
  • Scenario comparison: base vs extras vs shorter term
  • APR and fees estimator (optional, collapsible)
  • Monthly cost add-ons: tax, insurance, PMI, HOA (optional)
  • A downloadable 6-sheet Excel model
Full payment schedule Biweekly / weekly Extra-payment payoff Scenario comparison Excel model

Principal & interest only, not a lender quote. Fees, escrow, and rounding can make a lender's schedule differ.

Updated 8 June 2026 · Works in any currency

An amortization calculator shows how each loan payment is split between principal and interest over time — and how the balance falls to zero by the end of the term.

At a glance

Formula shown
M = P × r(1+r)ⁿ ÷ ((1+r)ⁿ − 1); each period interest = balance × r, principal = payment − interest.
Scenario support
Compare base, extra-payment, and shorter-term plans side by side across monthly, biweekly, weekly, or semi-monthly frequencies.
Workbook export
6-sheet Excel (XLSX) export
Educational estimate
Planning support from the values you enter — not professional advice.

The first payment on $250,000 at 6.5% is $1,354 interest and $226 principal

Amortization is the gradual reduction of a loan balance through scheduled payments, and the ordering inside each payment is the whole story: interest on the current balance is covered first, and only what is left reduces principal. A $250,000 loan at 6.5% over 30 years produces a monthly payment of $1,580.17. The very first payment is $1,354.17 interest and just $226.00 principal — roughly 86% interest — which is why the balance barely moves early on. Over the full term, total interest comes to about $318,862, more than the original loan itself, for a total paid of about $568,862.

The payment stays fixed for the whole term, but what it buys changes every row. Early rows are interest-heavy because the balance is largest at the start; later rows are principal-heavy as the balance — and the interest charged on it — shrinks. The yearly summary rolls that up so you can read the trend without scrolling hundreds of rows.

One payment formula, four period rates: ÷ 12, ÷ 26, ÷ 52, ÷ 24

r is the period rate, and the frequency selector is what sets it: annual rate ÷ 12 for monthly, ÷ 26 for biweekly, ÷ 52 for weekly, ÷ 24 for semi-monthly, with n counted on the same basis. Inside every period the fixed payment covers interest first; the remainder, plus any extra principal, reduces the balance. The final payment is trimmed so the balance ends at exactly zero, and an extra payment is capped at the remaining balance so it can never overshoot. Everything below the payment line is arithmetic on the figures you enter: estimates, not a lender quote.

Payment

M = P × r(1+r)ⁿ / ((1+r)ⁿ − 1)

P is the loan amount, r the period rate (annual ÷ periods per year ÷ 100), n the number of periods.

Interest & principal each period

interest = balance × r; principal = payment − interest + extra

Ending balance = MAX(0, balance − principal − extra) — never below zero.

$100 a month buys back 4.7 years and $58,000

On that same 30-year $250,000 loan at 6.5%, adding $100 a month to principal pays it off roughly 4.7 years early and saves about $58,000 in interest. The leverage is in the timing, not the size: because interest is charged on the outstanding balance, a dollar paid early erases interest for every remaining year, so $100 applied in year 25 is worth a fraction of $100 applied in year 1.

The scenario table prices your own version of that trade. It puts the base loan, an extra-payment plan and a shorter term side by side, which is the fastest way to see what a few hundred extra dollars a year is actually worth before you commit to them. Read your note for a prepayment penalty first, because a lender fee for paying early can cancel the saving this schedule shows.

A real biweekly is the rate ÷ 26, not half the monthly payment

Biweekly amortization uses a period rate of annual rate ÷ 26. With 26 payments a year you make the equivalent of 13 monthly payments instead of 12, and the extra amount goes to principal. This calculator computes that properly: it does not simply halve the monthly payment, which would give the wrong payment amount and understate the savings. Some lender biweekly programs do exactly that, remitting twelve payments a year, and save no interest at all. Switch the frequency selector and compare the payoff date against the monthly base to see which of the two you are being offered.

The note rate builds the schedule; the APR only ranks the offers

The interest rate determines your payment and therefore every row below it. The APR folds that same rate together with certain loan fees into one yearly figure, which makes it the better number for comparing two offers, and lenders are required to disclose it. Use the rate to build the schedule and the APR to choose the lender. The optional APR and fees estimator here is a planning aid, not an official APR disclosure, and it deliberately does not feed the schedule: change it and not one payment row moves.

The row where the balance reaches 80% of the purchase price cancels your PMI

PMI, private mortgage insurance, is required on conventional loans when the down payment is below 20%, and the lender cancels it automatically once the balance reaches 80% of the original home value — typically somewhere around year 9 to 11 on a 30-year loan at standard rates. The schedule replaces that rule of thumb with a date: scan the balance column for the first row where balance ÷ original value falls to 80%, and extra payments visibly pull that row forward. The monthly add-ons for property tax, insurance, PMI and HOA sit outside the amortization itself; they raise your total monthly cost without touching the principal-and-interest rows the payoff date is built from.

Eight currencies, six sheets: the schedule leaves the page intact

Switch to INR, GBP, EUR, CAD, AUD, SGD or AED and every figure redisplays in that currency, the schedule and the Excel export included, while the underlying amortization math stays the same. The full payment-by-payment schedule exports as CSV or as part of the six-sheet Excel workbook, and the on-page table prints straight from the browser.

A balloon, a rate reset or a lender’s own rounding breaks this schedule

This page assumes a fixed rate and a loan that pays down to exactly zero at the end of the term. It does not model a balloon payment or a lease’s residual value, both of which rewrite the final payment, and it cannot model a variable or resetting rate. It also leaves out lender fees, escrow, property taxes, insurance, late payments and lender-specific compounding rules, so a servicer’s printed schedule can differ row by row even when the inputs match. Those limitations are structural rather than a rounding gap, and the results depend entirely on the values you enter. For an ordinary fixed-payment loan with no balloon it works exactly as built, a car loan included, though the Auto Loan Calculator goes further on trade-ins and rebates.

Related calculators

Amortization underlies most loans — these related tools build on the same math:

LoanWork out the monthly payment, total interest, and payoff date for any fixed-rate loan from the amount, rate, and term.
MortgageEstimate monthly payments, interest, taxes, insurance, PMI, and amortization using practical home-loan assumptions.
Mortgage RefinanceCompare your current mortgage to a new rate and term — monthly saving and break-even time on closing costs.
Auto LoanCalculate a car-loan payment from price, down payment, trade-in, rate, and term, including the total cost of financing.
Personal LoanEstimate repayments on an unsecured personal loan and see how the rate and term change what you pay overall.
Interest LedgerSettle a private loan transaction by transaction — every advance, part-payment and rate change on its own date, under the day-count convention and allocation rule both sides agreed.
APRTurn a loan rate plus fees into the true annual percentage rate so you can compare offers on equal terms.
Debt PayoffSimulate up to 20 debts with snowball, avalanche, custom, or hybrid payoff order and find your debt-free date.
Credit Card PayoffPlan up to 20 cards with issuer-style minimums, promo APRs, five payoff orders, and a balance-transfer scenario.
Home AffordabilityEstimate the home price you can afford using the 28/36 debt-to-income rule on your income, debts, down payment, and rate.

More in Finance, or browse all calculators.

Read the guides

For why early payments barely touch the balance, and how extra payments change that, see How Amortization Works: Principal, Interest, and Loan Balance Explained.

For how this schedule fits into the full cost of a home purchase, see Mortgage Payment vs Total Loan Cost: What Borrowers Often Miss.

Sources and methodology

Every row in this schedule is arithmetic on the figures you enter — this page fetches no live rates, escrow amounts or lender fees. The sources below cover the fixed-payment formula that builds the schedule, the interest-and-principal split each payment is divided into, the effect of an extra principal payment on the payoff date, and the prepayment penalty that can cancel that saving. Links open in a new tab.

Finance disclaimer

This calculator is for educational and planning purposes only. It is not financial, lending, tax, accounting, or legal advice and is not a lender quote. It models principal and interest using standard fixed-rate amortization math. Actual lender schedules can differ because of fees, escrow, payment timing, compounding conventions, prepayment rules, late payments, and rounding. Verify with your lender or loan documents before deciding.

How we calculate · Found an error? email us

Learn more

How Amortization Works: Principal, Interest, and Loan Balance Explained

Why early loan payments barely touch the balance: how a fixed payment splits between interest and principal, and how extra payments cut total interest.

Read the guide

Authorship & verification

Written and maintained by , a business operator who builds spreadsheet-based calculators.

What's changed (4 updates)

Published 8 June 2026

  1. Published the amortization calculator with a full payment schedule, extra payments, a biweekly option, and Excel export.
  2. Added a downloadable Excel/CSV workbook generated from your inputs.
  3. Added a full payment-by-payment schedule.
  4. Reviewed the formula and assumptions for accuracy.

Show it to your clients, not just tell them

Mortgage brokers, accountants, and advisors embed this to walk clients through the numbers live — nothing they enter ever leaves their browser.