Amortization Calculator
Builds the repayment schedule for any fixed-rate loan. Enter the loan amount, the interest rate, the term and how often interest is compounded and payments are made (monthly, bi-weekly, weekly and more). You get the regular payment, the total paid, the total interest and a year-by-year amortization table showing how much of each year's payments goes to principal and to interest and what balance remains. Add an extra payment each period to see how much sooner the loan is repaid and how much interest you save.
- Fixed interest rate and equal payments for the whole term.
- Fees, insurance and taxes are not included.
Formula
Payment = L × i ÷ (1 − (1 + i)^−n), where i = (1 + r/m)^(m/p) − 1 is the rate per payment period and n = years × p
- L is the loan amount, r the annual rate, m the compounding frequency and p the number of payments per year. With continuous compounding, i = e^(r/p) − 1.
- When payments and compounding have the same frequency, i is simply r ÷ p.
- Each period the interest is the balance × i; the rest of the payment (plus any extra payment) reduces the balance.
- Amounts are not rounded to cents each period, so a lender's schedule may differ by a few cents.
100,000 at 6% for 10 years, monthly
Inputs
- Loan amount: 100000
- Annual interest rate: 6 %
- Term: years: 10 yrs
- Term: months: 0 mos
- Compounding frequency: 12
- Payment frequency: 12
- Extra payment each period: 0
i = 0.06 ÷ 12 = 0.005 and n = 120. Payment = 100,000 × 0.005 ÷ (1 − 1.005^−120) = 1,110.21 a month. Over 10 years you pay 133,224.60, of which 33,224.60 is interest.
Sources & references
Frequently asked questions
What is amortization?
Repaying a loan in regular instalments that cover both interest and principal, so the balance reaches zero at the end of the term. Early payments are mostly interest; later ones are mostly principal.
How do extra payments change an amortization schedule?
Extra payments go straight to principal, so every later payment carries less interest and the loan ends early. On a 100,000 loan at 6% over 10 years, an extra 100 a month saves several thousand in interest.
Why do compounding and payment frequency matter?
The quoted annual rate is converted into a rate per payment period. If interest compounds less often than you pay, the rate per payment is slightly lower than r ÷ p; if it compounds more often, slightly higher.
Does paying bi-weekly save interest?
Paying half the monthly amount every two weeks means 26 half-payments, or 13 full payments a year, which repays the loan faster. Choosing a bi-weekly frequency here recalculates the payment for 26 periods a year instead.
Related calculators
Mortgage Payment Calculator Calculates the monthly payment on a fixed-rate mortgage from the home price, down payment, interest rate and loan term, and adds property tax, home insurance, HOA fees and private mortgage insurance (PMI) to give the full monthly housing cost. It shows the loan amount, loan-to-value ratio, total interest over the life of the loan and a year-by-year amortization summary. Add an extra monthly payment to see how much sooner the loan is repaid and how much interest you save, and enter a start date to get the payoff date. EMI Calculator Calculates the equated monthly instalment (EMI) for a home, car, personal or education loan on a reducing balance. Enter the loan amount, the annual interest rate and the tenure in years or months to get the fixed monthly payment, the total interest and the total amount payable, with the split between principal and interest. A year-by-year schedule shows how much principal and interest you pay each year and the balance left at the end of it. Car Loan Calculator Works out how much you need to borrow for a car and what the loan will cost. Enter the car's price, your down payment, the trade-in value of your old car, the sales tax rate and any fees, then the interest rate and loan term. You get the loan amount, the monthly payment, the total interest and the total cost of the car, with a yearly breakdown of principal and interest. Sales tax can be charged on the full price or, as in most US states, on the price minus the trade-in.