How to Calculate the Number of Months to Pay Off a Loan

When you make monthly payments on a loan, it helps to know how long you have left to pay it off so you can better budget your money. By using a formula and some basic information about your loan, you can calculate the number of months until you're free of the debt. This formula works for a typical mortgage, auto loan or personal loan that is fully amortizing, which means its payments include both principal and interest and its balance reduces to zero over a fixed term.

Advertisement

Things You'll Need

  • Most recent loan statement

  • Scientific calculator

Step 1

Find your monthly principal and interest payment, outstanding balance and annual interest rate on your most recent loan statement. Exclude any property taxes, insurance or other charges from the payment.

For example, assume you have a 30-year mortgage with a current balance of $167,371.45, a monthly payment of $1,199.10 and a 6 percent annual interest rate.

Step 2

Divide your annual interest rate by 12 to calculate your monthly interest rate.

Advertisement

In the example, divide 0.06 by 12 to get a monthly interest rate of 0.005:

0.06 / 12 = 0.005

Step 3

Substitute the loan balance, monthly payment, and monthly interest rate into the loan term formula:

N = –[ln(1 – [(PV * i) / PMT_] ) / ln(1 + _i)]

In the formula, "ln" stands for natural logarithm, a math function used to calculate exponents. The formula also contains four variables:

Advertisement

N = the number of months remaining

PV = present value, or outstanding loan balance

PMT = monthly payment

i = monthly interest rate

In the example, substitute $167,371.45 for PV, $1,199.10 for PMT and 0.005 for i:

Advertisement

N = –[ln(1 – [($167,371.45 * 0.005) / $1,199.10] ) / ln(1 + 0.005)]

Step 4

Multiply the balance by the monthly interest rate and divide the result by the monthly payment in the numerator.

In the example, multiply $167,371.45 by 0.005 to get $836.86. Divide $836.86 by $1,199.10 to get 0.6979.

N = –[ln(1 – 0.6979) / ln(1 + 0.005)]

Advertisement

Step 5

Subtract the figures in parentheses in the numerator, and add the figures in the parentheses in the denominator.

In the example, subtract 0.6979 from 1 to get 0.3021 in the numerator. Add 1 and 0.005 to get 1.005 in the denominator:

N = –[ln(0.3021) / ln(1.005)]

Step 6

Input the figure in parentheses in the numerator into the scientific calculator, and push the natural logarithm button, "ln," to calculate the natural logarithm in the numerator.

Advertisement

In the example, input "0.3021" in the calculator, and push "ln" to get –1.197:

N = –[–1.197 / ln(1.005)]

Step 7

Input the figure in parentheses in the denominator into the calculator, and push the natural logarithm button to figure the natural logarithm in the denominator.

In the example, input "1.005" in the calculator, and push "ln" to get 0.00499:

Advertisement

N = –(–1.197 / 0.00499)

Step 8

Divide the remaining figures in parentheses.

In the example, divide –1.197 by 0.00499 to get –239.9:

N = –(–239.9)

Step 9

Apply the negative sign outside the parentheses to the number in parentheses to calculate the number of months remaining on your loan.

Advertisement

In the example, apply the negative sign to –239.9 to get positive 239.9, or approximately 240 months left on the loan:

N = 240

This means if you make all your payments on time, you will pay off the loan in 240 months, or 20 years, from the current month.

Advertisement