finance calculator

Amortization Schedule Calculator

Generate a full amortization schedule with monthly principal and interest breakdowns, total interest, and standard payment for any loan.

Results

Monthly payment (P&I)
$2,212
Total interest
$446,406
Total paid
$796,406

Overview

This amortization schedule calculator turns a loan’s big picture—amount, APR, and term—into a month-by-month breakdown of principal and interest. Instead of guessing how long it will take for payments to “start hitting principal,” you can see the exact balance, interest, and principal for every payment from month one to payoff.

How to use this calculator

  1. Enter the loan amount you plan to borrow or the current principal balance if you are analyzing an existing loan.
  2. Enter the annual interest rate (APR) as a percentage and the loan term in whole years. For mortgages this is often 15 or 30 years; for auto or personal loans, shorter terms are common.
  3. Review the calculated monthly payment, total interest, and total paid over the life of the loan at the top of the results.
  4. Scroll through the amortization schedule to see how much of each payment goes to interest versus principal and how the remaining balance falls over time.
  5. Experiment with different terms or rates by adjusting the inputs and regenerating the schedule to compare how payment amount and total interest change.
  6. Use the schedule as a reference when planning extra payments or refinancing, even though this baseline calculator models the standard payment only.

Inputs explained

Loan amount
The principal you are borrowing or the remaining balance you want to model. For a new mortgage this is typically the purchase price minus your down payment; for other loans it may be the full amount financed.
Interest rate (APR %)
The annual percentage rate charged on the loan, expressed as a percentage (for example, 6.5). The calculator converts this APR to a monthly rate for amortization and assumes it remains fixed for the entire term.
Term (years)
The length of the loan in years. We convert years to months by multiplying by 12 to determine how many fixed monthly payments are in the schedule.

Outputs explained

Monthly payment (P&I)
The fixed monthly principal-and-interest payment that exactly pays off the loan over the chosen term at the specified APR. Escrow items like taxes and insurance are not included here.
Total interest
The sum of all interest charges across every payment in the schedule. This number shows the true cost of borrowing over the entire term at the rate you entered.
Total paid
The total of all monthly payments (principal plus interest) over the life of the loan. It equals the loan amount plus total interest, assuming you make every scheduled payment on time and do not prepay.

How it works

First, the calculator computes your fixed monthly principal-and-interest payment using the standard amortization formula. It converts the annual percentage rate (APR) into a monthly rate by dividing by 12 and multiplies your term in years by 12 to get the total number of monthly payments.

With the monthly payment set, the tool builds an amortization table month by month. For each row, it multiplies the current balance by the monthly interest rate to get that month’s interest charge, then subtracts this interest from the payment to find the principal portion.

The principal portion of each payment reduces the balance: New balance = Old balance − Principal paid. As the balance falls over time, interest charges shrink and more of each payment goes to principal.

Across the full schedule, the calculator keeps a running total of interest paid so you can see the lifetime cost of borrowing for a given rate and term. It also sums principal and interest together to show the total of payments over the life of the loan.

Because the formula assumes a fully amortizing, fixed-rate loan, the payment stays the same each month, but the mix of principal and interest shifts steadily toward principal as the loan ages.

Formula

Let P = loan amount, APR = annual percentage rate, r = APR ÷ 12 (monthly rate in decimal), and n = term years × 12 (number of monthly payments).\n\nMonthly payment = P × r ÷ (1 − (1 + r)^{−n})\nFor each month m:\nInterest_m = Balance_{m−1} × r\nPrincipal_m = Payment − Interest_m\nBalance_m = Balance_{m−1} − Principal_m\nTotal interest = Σ Interest_m over all months

When to use it

  • Understanding how a 30-year mortgage payment is allocated between interest and principal during the first few years versus the last few years of the loan.
  • Comparing total interest paid on a 30-year versus 15-year mortgage, or on different rate offers, to see the long-run savings from a shorter term or lower APR.
  • Checking whether extra principal payments you plan to make (modeled separately) would save enough interest to justify refinancing costs or an aggressive payoff timeline.
  • Helping borrowers visualize why refinancing into a lower rate can reduce both the monthly payment and the lifetime interest burden, even if the remaining term is shorter.
  • Creating a reference schedule for budgeting or accounting, so you can forecast interest expense and outstanding balance by month.

Tips & cautions

  • Shorter terms (such as 15 years instead of 30) increase the monthly payment but dramatically reduce total interest. Use the schedule to quantify that trade-off before committing.
  • Even a small reduction in APR can save tens of thousands of dollars over a long mortgage. Plug competing rate quotes into the calculator and compare total interest and monthly payment side by side.
  • If you expect to make regular extra principal payments, treat this schedule as the baseline and then layer in your own projections—early principal reduction accelerates the shift from interest-heavy to principal-heavy payments.
  • Use the early-year portion of the schedule to estimate mortgage interest deductions for planning conversations with a tax professional, but remember this calculator does not compute tax outcomes directly.
  • For auto and personal loans, shorter terms can reduce interest but may make the payment too tight for your budget. Test several combinations to find a comfortable balance between affordability and interest savings.
  • The calculator assumes a fixed-rate, fully amortizing loan with equal monthly payments. It does not model interest-only periods, balloon payments, graduated payment structures, or adjustable-rate mortgages.
  • Taxes, insurance, mortgage insurance (PMI), HOA dues, and other escrowed or ancillary costs are not included. The monthly payment shown covers principal and interest only.
  • Extra principal payments, skipped payments, or irregular schedules are not built into this baseline version. Real-world loan histories that include prepayments or delinquencies will differ from the theoretical schedule.
  • Closing costs, origination fees, and points are not capitalized or amortized here unless you include them in the loan amount yourself. For APR-based comparisons, use a dedicated APR calculator.
  • Results are rounded to cents for readability. Minor rounding differences may exist versus a lender’s internal system, but the pattern of principal and interest will be conceptually similar.

Worked examples

Example 1: $350,000 mortgage at 6.5% APR for 30 years

  • Inputs: Loan amount = $350,000; APR = 6.5%; Term = 30 years (360 months).
  • Monthly rate r = 0.065 ÷ 12 ≈ 0.0054167; n = 30 × 12 = 360 payments.
  • Monthly payment ≈ $2,212 for principal and interest.
  • Over the full schedule, total interest paid is roughly $446,000, bringing total paid (principal plus interest) to about $796,000.
  • Early months show most of the $2,212 going to interest, but by the final years the majority of each payment reduces principal.

Example 2: $250,000 loan at 5.0% APR for 15 years

  • Inputs: Loan amount = $250,000; APR = 5.0%; Term = 15 years (180 months).
  • Monthly payment is about $1,976—higher than many 30-year payments on the same amount, but the term is half as long.
  • Total interest over 15 years is roughly $105,700, far less than a 30-year schedule at a similar rate.
  • The amortization table shows principal catching up to and then overtaking interest much earlier in the life of the loan.

Example 3: Comparing 30-year vs 20-year term on the same $300,000 loan at 6.0%

  • Scenario A: 30-year term at 6.0% APR produces a lower monthly payment but significantly more total interest over 360 months.
  • Scenario B: 20-year term at 6.0% APR increases the monthly payment but reduces the number of payments by a third.
  • When you plug both into the calculator and compare total interest, the shorter term saves many tens of thousands of dollars over the life of the loan.

Deep dive

Use this amortization schedule calculator to generate a full month-by-month breakdown of principal and interest for any fixed-rate loan. Enter the loan amount, APR, and term to see the standard monthly payment, total interest, total paid, and a detailed amortization table.

It’s ideal for comparing loan offers, planning payoff strategies, and understanding how quickly your balance falls over time. You can scan early rows to see interest-heavy payments and later rows to confirm when principal finally dominates.

FAQs

Can I include extra principal payments in this amortization schedule?
This version shows the baseline schedule with the standard fixed payment only. To see the impact of extra principal payments on payoff time and interest savings, use a dedicated payoff or prepayment calculator, or manually model extra payments alongside this table.
Does the monthly payment shown include taxes, insurance, or mortgage insurance (PMI)?
No. The calculated payment covers principal and interest only. Property taxes, homeowners insurance, HOA dues, and PMI are usually handled through a separate escrow portion of your mortgage bill and are not part of the amortization formula.
Why is so much of my early payment going to interest?
In an amortizing loan, interest is calculated on the remaining balance each month. Because your balance is largest at the start of the loan, interest charges are highest early on. As you pay down principal, interest charges shrink and more of each fixed payment goes toward principal.
Will my lender’s amortization schedule match this exactly?
The pattern of principal and interest should be very similar, but small differences can arise from rounding rules, the exact APR used internally, or specific day-count conventions. Always rely on your lender’s official disclosures for final numbers, and treat this calculator as a planning tool.
Is this amortization schedule suitable for adjustable-rate mortgages (ARMs)?
No. ARMs change the interest rate over time based on an index and margin, which alters payments and interest allocation. This calculator assumes a single fixed APR for the entire term and does not model rate adjustments or payment resets.

Related calculators

This amortization schedule calculator is for educational and planning purposes only. It assumes a fixed-rate, fully amortizing loan with equal monthly payments and does not account for taxes, insurance, mortgage insurance, fees, prepayments, or adjustable rates. Always review official disclosures from your lender and consult a qualified financial professional before making borrowing or refinancing decisions.