CCalclabhub

Loans & Mortgages

Payoff time with extra

Solves the amortisation formula for the number of months at the higher payment.

Last updated

The Formula

n = -ln(1 - r x balance / (payment + extra)) / ln(1 + r)

Solves the amortisation formula for the number of months at the higher payment.

SymbolMeaning
BBalance
PPayment
EExtra
rMonthly rate

What Each Symbol Means

Bcurrency

Balance

Amount still owed.

Pcurrency

Payment

Required monthly payment.

Ecurrency

Extra

Additional principal each month.

rrate

Monthly rate

Annual rate divided by twelve.

See It Worked With Real Numbers

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

Common Questions

What is the formula for Payoff time with extra?

The formula for Payoff time with extra is n = -ln(1 - r x balance / (payment + extra)) / ln(1 + r). Solves the amortisation formula for the number of months at the higher payment.

What units should I use with Payoff time with extra?

Substitute B in money (any currency, as long as every money input uses the same one), P in money (any currency, as long as every money input uses the same one), E in money (any currency, as long as every money input uses the same one), r as a rate. 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 Payoff time with extra?

Prepaying before building an emergency fund. Money in a mortgage is illiquid. An emergency fund should come first, or a job loss could force expensive borrowing against the very home you are trying to free up.