CCalclabhub

Credit & Debt

Payments needed to clear a balance

Setting the balance after n payments to zero and solving for n gives the number of payments directly. The argument of the logarithm must be positive, which is the condition that the payment covers the interest.

Last updated

The Formula

n = -ln(1 - r x B / P) / ln(1 + r)

Setting the balance after n payments to zero and solving for n gives the number of payments directly. The argument of the logarithm must be positive, which is the condition that the payment covers the interest.

SymbolMeaning
rMonthly rate
BBalance
PPayment
nPayments

What Each Symbol Means

rpercent

Monthly rate

Annual rate divided by twelve.

Bcurrency

Balance

The amount outstanding at the start.

Pcurrency

Payment

The fixed payment made each month.

npayments

Payments

How many payments clear the balance.

See It Worked With Real Numbers

A formula on its own does not tell you which number goes where. The how to pay off debt 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 Pay Off Debt, filed under Finance. Every number the guide produces comes from substituting into this one line.

Common Questions

What is the formula for Payments needed to clear a balance?

The formula for Payments needed to clear a balance is n = -ln(1 - r x B / P) / ln(1 + r). Setting the balance after n payments to zero and solving for n gives the number of payments directly. The argument of the logarithm must be positive, which is the condition that the payment covers the interest.

What does each symbol in Payments needed to clear a balance stand for?

r is monthly rate; B is balance; P is payment; n is payments.

What units should I use with Payments needed to clear a balance?

Substitute r as a percentage, 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), n in payments. 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 Payments needed to clear a balance?

Dividing the balance by the payment. That only works at a zero interest rate. On any real balance it understates the schedule, because each payment first covers a month of interest.