CCalclabhub

Loans & Mortgages

Maximum loan (Home Affordability)

The reverse amortisation formula that converts a payment into a loan.

Last updated

The Formula

Loan = Mortgage payment x (1 - (1 + r)^-n) / r

The reverse amortisation formula that converts a payment into a loan.

SymbolMeaning
MMortgage payment
rMonthly rate
nPayments

What Each Symbol Means

Mcurrency

Mortgage payment

The cap minus tax and insurance.

rrate

Monthly rate

Annual rate divided by twelve.

ncount

Payments

Term in months.

See It Worked With Real Numbers

A formula on its own does not tell you which number goes where. The how to calculate home affordability 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 Calculate Home Affordability, filed under Finance. Every number the guide produces comes from substituting into this one line.

Common Questions

What is the formula for Maximum loan (Home Affordability)?

The formula for Maximum loan (Home Affordability) is Loan = Mortgage payment x (1 - (1 + r)^-n) / r. The reverse amortisation formula that converts a payment into a loan.

What units should I use with Maximum loan (Home Affordability)?

Substitute M in money (any currency, as long as every money input uses the same one), r as a rate, n as a plain count. 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 Maximum loan (Home Affordability)?

Leaving out the car loan or student loans. The back-end ratio counts every monthly debt. Omitting one overstates the housing cap and leads to a payment that strains the budget.