How to Calculate Loan Payments (Formula, Examples and Calculator)

How to Calculate Loan Payments: Formula and examples
Spread the love

Before you sign for a car loan, personal loan or mortgage, it’s worth knowing what the monthly payment will be and how much interest you’ll pay in total. A loan calculator does the maths instantly, but the formula behind it is simple enough to understand.

Quick answer

For a fixed-rate loan that you repay in equal monthly payments, use this formula:

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

  • M = monthly payment
  • P = amount borrowed (principal)
  • r = monthly interest rate (annual rate ÷ 12, as a decimal)
  • n = number of monthly payments

Worked example: a car loan

For example, say you borrow $20,000 at 7% a year for 5 years (60 payments).

  1. First, find the monthly rate: 7 ÷ 100 ÷ 12 = 0.005833.
  2. Next, plug it into the formula: M = 20,000 × 0.005833 × (1 + r)60 ÷ ((1 + r)60 − 1).
  3. As a result, the monthly payment is $396.02.
  4. Finally, the total paid is $23,761.44, so total interest is $3,761.44.

How each payment is split

At first, payments are mostly interest, because lenders charge interest on the outstanding balance. As the balance falls, however, more of each payment goes to the principal. Lenders call this amortization.

Month Payment Interest Principal Balance
1 $396.02 $116.67 $279.36 $19,720.64
2 $396.02 $115.04 $280.99 $19,439.66
3 $396.02 $113.40 $282.63 $19,157.03
4 $396.02 $111.75 $284.27 $18,872.76

Worked example: a mortgage

Loan Rate Term Monthly payment Total interest
$300,000 6.5% 30 years $1,896.20 $382,633.47
$300,000 6.5% 15 years $2,613.32 $170,397.98

The 15-year loan costs $717.12 more a month but saves $212,235.49 in interest. In addition, mortgage payments often include property tax and insurance, which this formula doesn’t cover.

What changes your payment

  • Interest rate: for example, on the $20,000 loan, each extra percentage point adds about $9.50 a month.
  • Term: longer terms lower the payment but raise total interest.
  • Extra payments: similarly, anything above the required amount goes to principal (check that your lender applies it that way), which cuts the interest and the term.
  • APR vs rate: the APR includes certain fees, so it’s the better figure for comparing offers.

Zero-interest loans

If the rate is 0%, the formula doesn’t work (it divides by zero). In that case, the payment is simply P ÷ n. For instance, $12,000 over 48 months is $250 a month.

Also, for working with rates, see how to calculate a percentage and percent to decimal.

Frequently asked questions

How do I calculate a monthly loan payment?

Use M = P × r × (1 + r)^n ÷ ((1 + r)^n − 1), where r is the monthly rate and n the number of payments, or use a loan calculator.

What is the monthly payment on $20,000 at 7% for 5 years?

$396.02.

How does loan interest work?

Each month, the lender multiplies the outstanding balance by the monthly rate. The rest of your payment then reduces the balance.

Does paying extra shorten a loan?

Yes, if the extra goes to principal: it lowers the balance that interest is charged on.

Related guides

Related guides

Leave a Reply

Your email address will not be published. Required fields are marked *