Skip to content

Loan Calculator with Amortization Schedule

Enter the loan amount, the interest rate and the term. You see the monthly payment, the total interest and an amortization schedule that lists every month.

Advertisement

How the monthly payment works

This calculator is for a loan with equal monthly payments. Each payment pays the interest on the balance you still owe and repays part of the balance itself. Because the balance falls, the interest part gets smaller and the repayment part gets larger every month. The table that lists this for each month is called an amortization schedule.

Formula

Payment = P × i × (1 + i) to the power of n ÷ ((1 + i) to the power of n − 1). P is the loan amount, i is the monthly interest rate as a decimal, which is the annual rate divided by 12 and by 100, and n is the number of monthly payments. At an interest rate of 0 the payment is simply the loan amount divided by n.

Example: 10,000 at 5 percent over 12 months gives a payment of 856.07. You repay 10,272.90 in total, so the interest is 272.90.

Interest rate and APR

Enter the interest rate of the loan. According to the Consumer Financial Protection Bureau, the interest rate is the yearly cost of borrowing as a percentage, while the annual percentage rate (APR) is a broader measure that also includes points, broker fees and other charges you pay to get the loan. This calculator does not add any fees and does not calculate an APR. The effective annual rate shown with the result follows only from the interest rate and monthly compounding: (1 + monthly rate) to the power of 12, minus 1.

Everything is calculated exactly and only the display is rounded to two decimal places, so interest plus principal in the table can be off by 0.01 from the payment. Your loan agreement is what counts.

Frequently asked questions

What is an amortization schedule?

A table with every payment, showing how much of it is interest, how much repays the loan, and the balance that is left.

Why does the interest get smaller every month?

Interest is worked out from the balance you still owe. Every payment lowers the balance.

What happens at 0 percent interest?

There is no interest and every payment only repays the loan: the loan amount divided by the number of months.

How long can the term be?

From 1 to 100 years, or from 1 to 1200 months.

Does the calculator work out the APR?

No. It uses the interest rate you enter and adds no fees, so the payment can differ from an offer that includes fees or insurance. It does show the effective annual rate, a figure calculated only from that interest rate and monthly compounding.

Can I use it for a car loan or a mortgage?

It works for any loan with a fixed interest rate and equal monthly payments. Taxes, insurance and fees that your lender adds to the payment are not included.