Amortization calculator
The full amortization schedule of any fixed-rate loan, month by month and year by year, with extra payments and a CSV download.
Loading tool…
Fixed rate, compounded monthly.
Your loan
Monthly payment $1,199.10, total interest $231,677.04.
- Monthly payment
- $1,199.10
- Total interest
- $231,677.04
- Total paid
- $431,677.04
- Paid off
- Sep 2056
- 30 years
| Principal | $200,000.00 (46.3%) |
|---|---|
| Interest | $231,677.04 (53.7%) |
| Total paid | $431,677.04 |
First payment: $1,000.00 interest and $199.10 principal. The last payment (Sep 2056) is $1,200.14.
Amortization schedule
Yearly totals; open a year to see each month. The last payment is adjusted so the balance ends at exactly 0.
| Year | Payments | Principal | Interest | Balance |
|---|---|---|---|---|
| Sep 2027 | $14,389.20 | $2,456.01 | $11,933.19 | $197,543.99 |
| Sep 2028 | $14,389.20 | $2,607.49 | $11,781.71 | $194,936.50 |
| Sep 2029 | $14,389.20 | $2,768.30 | $11,620.90 | $192,168.20 |
| Sep 2030 | $14,389.20 | $2,939.07 | $11,450.13 | $189,229.13 |
| Sep 2031 | $14,389.20 | $3,120.33 | $11,268.87 | $186,108.80 |
| Sep 2032 | $14,389.20 | $3,312.80 | $11,076.40 | $182,796.00 |
| Sep 2033 | $14,389.20 | $3,517.13 | $10,872.07 | $179,278.87 |
| Sep 2034 | $14,389.20 | $3,734.06 | $10,655.14 | $175,544.81 |
| Sep 2035 | $14,389.20 | $3,964.35 | $10,424.85 | $171,580.46 |
| Sep 2036 | $14,389.20 | $4,208.86 | $10,180.34 | $167,371.60 |
| Sep 2037 | $14,389.20 | $4,468.45 | $9,920.75 | $162,903.15 |
| Sep 2038 | $14,389.20 | $4,744.06 | $9,645.14 | $158,159.09 |
| Sep 2039 | $14,389.20 | $5,036.67 | $9,352.53 | $153,122.42 |
| Sep 2040 | $14,389.20 | $5,347.31 | $9,041.89 | $147,775.11 |
| Sep 2041 | $14,389.20 | $5,677.13 | $8,712.07 | $142,097.98 |
| Sep 2042 | $14,389.20 | $6,027.29 | $8,361.91 | $136,070.69 |
| Sep 2043 | $14,389.20 | $6,399.04 | $7,990.16 | $129,671.65 |
| Sep 2044 | $14,389.20 | $6,793.71 | $7,595.49 | $122,877.94 |
| Sep 2045 | $14,389.20 | $7,212.70 | $7,176.50 | $115,665.24 |
| Sep 2046 | $14,389.20 | $7,657.58 | $6,731.62 | $108,007.66 |
| Sep 2047 | $14,389.20 | $8,129.90 | $6,259.30 | $99,877.76 |
| Sep 2048 | $14,389.20 | $8,631.33 | $5,757.87 | $91,246.43 |
| Sep 2049 | $14,389.20 | $9,163.70 | $5,225.50 | $82,082.73 |
| Sep 2050 | $14,389.20 | $9,728.89 | $4,660.31 | $72,353.84 |
| Sep 2051 | $14,389.20 | $10,328.94 | $4,060.26 | $62,024.90 |
| Sep 2052 | $14,389.20 | $10,966.02 | $3,423.18 | $51,058.88 |
| Sep 2053 | $14,389.20 | $11,642.38 | $2,746.82 | $39,416.50 |
| Sep 2054 | $14,389.20 | $12,360.46 | $2,028.74 | $27,056.04 |
| Sep 2055 | $14,389.20 | $13,122.81 | $1,266.39 | $13,933.23 |
| Sep 2056 | $14,390.24 | $13,933.23 | $457.01 | $0.00 |
A fixed-rate loan repaid monthly, rounded to the cent as a lender does. This is an estimate to help you plan, not financial advice: lenders, card issuers and investments set their own terms, fees and rounding. Everything is calculated in your browser; nothing you type is sent anywhere.
How it works
This amortization calculator shows how any fixed-rate loan is repaid: the monthly payment, how much of each payment is interest and how much is principal, and the balance after every month. For example, a $200,000 loan at 6% for 30 years has a payment of $1,199.10; in the first month $1,000.00 of it is interest and only $199.10 repays the loan.
The schedule is shown year by year, with each year opening to its twelve months, and it downloads as a CSV file for Excel or Google Sheets. Add an extra monthly payment or a one-off lump sum to see how much sooner the loan ends and how much interest you save.
Use it for a mortgage, a car loan, a personal or student loan, or any loan repaid in equal monthly instalments. Every figure here is an estimate to help you plan, not financial advice: lenders, card issuers and investments set their own terms, fees and rounding.
How an amortization schedule is calculated
First the fixed payment: M = P × r × (1 + r)^n ÷ ((1 + r)^n − 1), with P the loan amount, r the monthly rate (yearly rate ÷ 12) and n the number of months (M = P ÷ n at 0%). Then, every month: interest = balance × r, rounded to the cent; principal = payment − interest; new balance = balance − principal. The last payment is adjusted so the balance ends at exactly 0, so the principal column always adds up to the loan amount.
Because interest is charged on the balance, the interest share falls every month and the principal share rises. An extra payment is taken straight off the balance; the regular payment stays the same, so the loan simply ends earlier.
Amortization schedule example: $200,000 at 6% for 30 years
Monthly payment $1,199.10. Yearly totals for selected years; the calculator above lists every year and month.
| Year | Interest paid | Principal paid | Balance at year end |
|---|---|---|---|
| Year 1 | $11,933.19 | $2,456.01 | $197,543.99 |
| Year 2 | $11,781.71 | $2,607.49 | $194,936.50 |
| Year 3 | $11,620.90 | $2,768.30 | $192,168.20 |
| Year 4 | $11,450.13 | $2,939.07 | $189,229.13 |
| Year 5 | $11,268.87 | $3,120.33 | $186,108.80 |
| Year 10 | $10,180.34 | $4,208.86 | $167,371.60 |
| Year 15 | $8,712.07 | $5,677.13 | $142,097.98 |
| Year 20 | $6,731.62 | $7,657.58 | $108,007.66 |
| Year 25 | $4,060.26 | $10,328.94 | $62,024.90 |
| Year 30 | $457.01 | $13,933.23 | $0.00 |
Total interest over 30 years: $231,677.04. Half of the loan is repaid only in year 21.
Monthly payment by loan amount and term
At a 7% yearly rate, principal and interest:
| Loan | 3 years | 5 years | 10 years | 15 years | 20 years | 30 years |
|---|---|---|---|---|---|---|
| $10,000 | $308.77 | $198.01 | $116.11 | $89.88 | $77.53 | $66.53 |
| $25,000 | $771.93 | $495.03 | $290.27 | $224.71 | $193.82 | $166.33 |
| $50,000 | $1,543.85 | $990.06 | $580.54 | $449.41 | $387.65 | $332.65 |
| $100,000 | $3,087.71 | $1,980.12 | $1,161.08 | $898.83 | $775.30 | $665.30 |
| $200,000 | $6,175.42 | $3,960.24 | $2,322.17 | $1,797.66 | $1,550.60 | $1,330.60 |
| $300,000 | $9,263.13 | $5,940.36 | $3,483.25 | $2,696.48 | $2,325.90 | $1,995.91 |
More money calculators
- Mortgage calculator: payment with tax, insurance and PMI
- Refinance calculator: savings and break-even
- Compound interest calculator: savings growth with contributions
- Retirement calculator: how much you need and how long it lasts
- Credit card payoff calculator: months and interest
- Debt payoff calculator: snowball vs avalanche
- Loan EMI calculator: instalment and schedule for any loan
- Salary after tax calculators: take-home pay by country
How to use it
- Enter the loan amount and the yearly interest rate.
- Enter the term in years or in months.
- Read the monthly payment, the total interest and the payoff date.
- Add extra payments to compare, open any year to see its months, or download the schedule as CSV.
Frequently asked questions
What is an amortization schedule?
A table of every payment on a loan showing how much goes to interest, how much repays the principal and the balance left afterwards. On a fixed-rate loan the payment stays the same while the interest part shrinks and the principal part grows.
Why is most of my early payment interest?
Interest is charged on the balance, which is highest at the start. On a $200,000 loan at 6%, the first month’s interest is $1,000 of a $1,199.10 payment; by the last year it is only a few dollars a month.
How do extra payments change the schedule?
An extra payment reduces the balance straight away, so every later month charges less interest and more of the regular payment repays principal. The loan ends earlier; the calculator shows the months and the interest saved against the same loan without extra payments.
Can I download the amortization schedule?
Yes. "Download CSV" saves every month (payment, extra payment, principal, interest and balance) as a CSV file that opens in Excel, Numbers or Google Sheets. It is created in your browser; nothing is uploaded.
Does this work for car loans and personal loans?
Yes, for any loan with a fixed rate and equal monthly payments. Loans quoted with a flat rate, or with fees and insurance added to the payment, will differ; enter the reducing-balance rate (APR) for the closest match.
Why does the last payment differ?
Each payment is rounded to the cent, so tiny differences add up over the term. The last payment absorbs them so the balance ends at exactly zero, as on a bank statement.
Related tools
- Mortgage CalculatorMonthly mortgage payment with property tax, insurance, PMI and HOA, total interest, an amortization schedule and extra payments.
- Refinance CalculatorCompare your current loan with a new one: the new payment, monthly savings, closing costs, the break-even month and the lifetime difference.
- Credit Card Payoff CalculatorHow long a credit card takes to pay off and the interest it costs, by fixed payment or target date, compared with paying the minimum.
- Debt Payoff CalculatorSnowball vs avalanche for all your debts: payoff order and dates, debt-free date, total interest and the savings against minimum payments.
- Compound Interest CalculatorHow savings grow with compound interest and regular contributions: daily to continuous compounding, a year-by-year table, a growth chart and inflation.
- Loan EMI CalculatorMonthly instalment, total interest and an amortisation schedule for any loan from principal, rate and term.