Skip to content
NumzalChange country:

Payment Calculator

Work out the monthly payment on a loan, or start from the payment you can afford and find the term, the interest rate or how much you can borrow.

Calculate the
Term in

Monthly payment

$1,797.66

Term
15 years (180 payments)
Total of payments
$323,578.18
Total interest
$123,578.18

Amortization schedule

Loan balance by year: the balance at the end of each year, from $200,000.00 to $0 over 15 years.
Amortization by year
YearInterestPrincipalBalance
1$13,752.28$7,819.60$192,180.40
2$13,187.00$8,384.88$183,795.53
3$12,580.86$8,991.02$174,804.51
4$11,930.90$9,640.98$165,163.53
5$11,233.95$10,337.93$154,825.60
6$10,486.62$11,085.26$143,740.35
7$9,685.27$11,886.61$131,853.74
8$8,825.98$12,745.89$119,107.84
9$7,904.58$13,667.30$105,440.55
10$6,916.57$14,655.31$90,785.24
11$5,857.14$15,714.74$75,070.50
12$4,721.12$16,850.76$58,219.74
13$3,502.98$18,068.90$40,150.84
14$2,196.77$19,375.10$20,775.73
15$796.15$20,775.73$0.00
Total$123,578.18$200,000.00
Monthly schedule (180 payments)

This is an estimate, not financial, legal or tax advice. Check with a professional for your situation.

A fixed loan payment is M = P × r(1 + r)ⁿ ÷ ((1 + r)ⁿ − 1), where P is the amount borrowed, r the annual interest rate ÷ 12 and n the number of monthly payments. Borrowing $200,000 at 7% for 15 years costs $1,797.66 a month, and $123,578.18 in interest over the life of the loan.

How it's calculated

Payment. The fixed monthly payment that pays the loan off over the term:

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

where P is the amount borrowed, r the annual interest rate ÷ 12 (6.5% a year is 0.065 ÷ 12 per month) and n the number of monthly payments (360 for 30 years). At 0% interest the payment is simply P ÷ n.

Term. From the payment, the number of payments is n = −ln(1 − r × P ÷ M) ÷ ln(1 + r) (P ÷ M at 0%). It is rounded up to whole months, and the last payment is smaller. If your payment is the standard payment for a whole number of months rounded to the cent, the term is that number of months and the last payment absorbs the rounding, as a lender would do.

Loan amount. P = M × (1 − (1 + r)⁻ⁿ) ÷ r (M × n at 0%).

Interest rate. There is no formula for the rate, so the calculator searches for it by bisection: it halves the range between 0% and 100% a year until the monthly rate is pinned down to within 1e-14 (far closer than the 3 decimals it shows).

When there is no answer. If the payment is no more than the first month's interest (P × r), the balance never goes down and the loan is never paid off. If the payments add up to less than the amount borrowed, no interest rate fits.

The calculator keeps full precision and rounds only what it shows you. A lender rounds the payment to the cent and adjusts the last payment, so its schedule can differ from this one by a few cents.

These are estimates, not a quote from a lender: your Loan Estimate shows the lender’s own figures.

Worked example

  • Payment: $200,000 at 7% for 15 years. r = 0.07 ÷ 12, n = 180, so M = $1,797.66. In the first month $1,166.67 is interest and $630.99 goes to principal. All 180 payments add up to $323,578.18.
  • Term: paying $2,000.00 a month on the same loan pays it off in 12 years 7 months (151 payments, the last one $1,036.78).
  • Rate: borrowing $25,000.00 and repaying $500.00 a month for 60 months means an interest rate of 7.42%.
  • Amount: $500.00 a month for 60 months at 7% repays a loan of $25,251.00.
  • 0% interest: $25,000.00 over 60 months is $25,000.00 ÷ 60 = $416.67 a month.

Frequently asked questions

How do I calculate a monthly loan payment?

Use M = P × r(1 + r)^n ÷ ((1 + r)^n − 1): P is the amount borrowed, r the annual interest rate divided by 12, and n the number of monthly payments. For $200,000 at 7% for 15 years, r = 0.07 ÷ 12 and n = 180, so the payment is $1,797.66. At 0% interest, divide the amount by the number of payments.

How do I calculate a loan payment in Excel?

Use the PMT function with the monthly rate, the number of payments and the amount borrowed as a negative number: =PMT(7%/12, 180, -200000) returns $1,797.66. Excel's NPER, RATE and PV functions work the other way round, for the number of payments, the rate per period and the loan amount.

What is the difference between the interest rate and the APR?

The interest rate is the yearly cost of borrowing the money, as a percentage, and does not include fees. The APR (annual percentage rate) is a broader measure that also includes points, broker fees and other charges you pay to get the loan, so it is usually higher. Enter the interest rate here, because the monthly payment is worked out from it, and use the APR to compare offers from different lenders. On a mortgage Loan Estimate, the interest rate is on page 1 and the APR on page 3.

Why does the calculator say my payment never pays off the loan?

Each month, interest is charged on the balance first. If your payment is no more than that interest, nothing is left to reduce the balance, so it never goes down. On $200,000 at 7%, the first month's interest is $1,166.67, so any payment of that or less never pays the loan off.

How is the interest calculated each month?

Interest = balance × annual rate ÷ 12. On $200,000 at 7% the first month's interest is $1,166.67, so $630.99 of a $1,797.66 payment goes to principal. As the balance falls, the interest part shrinks and more of each payment goes to principal. The amortization schedule shows the split for every payment.

How much interest will I pay in total?

Total interest = monthly payment × number of payments − amount borrowed. For $200,000 at 7% over 15 years that is $1,797.66 × 180 − $200,000 = $123,578.18 (the calculator works with the unrounded payment). A shorter term or a lower rate cuts this the most.

How do I find the interest rate on a loan from the payment?

Choose "Rate" and enter the amount, the term and the monthly payment. The calculator searches for the rate that makes the standard payment formula match your payment. For example, $25,000.00 repaid at $500.00 a month for 60 months is 7.42% a year.

Add this calculator to your site

Free to use. Paste this code into your page and keep the link below the calculator visible.