CCalclabhub

Loans & Mortgages

Monthly payment on an amortising loan

The payment that clears the principal exactly over n payments, with interest charged monthly on the outstanding balance. Negative exponents are allowed directly in the expression.

Last updated

The Formula

M = P x r / (1 - (1+r)^-n)

The payment that clears the principal exactly over n payments, with interest charged monthly on the outstanding balance. Negative exponents are allowed directly in the expression.

SymbolMeaning
PPrincipal
rMonthly rate
nPayments
MMonthly payment

What Each Symbol Means

Pcurrency

Principal

The amount borrowed.

rpercent

Monthly rate

Annual rate divided by twelve.

nmonths

Payments

Months in the term.

Mcurrency

Monthly payment

The fixed payment each month.

See It Worked With Real Numbers

A formula on its own does not tell you which number goes where. The how to compare loan offers page applies this equation to a concrete case, shows every intermediate step, and names the mistakes that produce a wrong answer even when the algebra is right.

Where This Formula Appears

This equation is the working core of How To Compare Loan Offers, filed under Finance. Every number the guide produces comes from substituting into this one line.

Common Questions

What is the formula for Monthly payment on an amortising loan?

The formula for Monthly payment on an amortising loan is M = P x r / (1 - (1+r)^-n). The payment that clears the principal exactly over n payments, with interest charged monthly on the outstanding balance. Negative exponents are allowed directly in the expression.

What does each symbol in Monthly payment on an amortising loan stand for?

P is principal; r is monthly rate; n is payments; M is monthly payment.

What units should I use with Monthly payment on an amortising loan?

Substitute P in money (any currency, as long as every money input uses the same one), r as a percentage, n in months, M in money (any currency, as long as every money input uses the same one). Convert every input to those units before you start, because the equation only returns the right answer when the units on both sides agree.

What is a common mistake when using Monthly payment on an amortising loan?

Comparing only the monthly payment. A longer term always gives a smaller payment and always costs more in total. Ranking on the payment alone systematically favours the longest loan on the list.