Loan payoff calculator

Enter a loan balance and interest rate, then either the monthly payment or the number of months. The calculator gives the payoff time or the payment, the total interest, the payoff schedule, and how much interest and time an extra monthly payment saves. It also says when a payment is too small to ever repay the loan.

Calculator

I know
Time to pay off
5 years
60 payments; the last is $115.28
Total interest
$3,715.28
Total of payments
$23,715.28
First month's interest
$116.67
The payment must be more than this.
With the extra payment
3 years 10 months
46 payments, $2,841.25 interest
Interest saved
$874.03
and 1 year 2 months sooner

Balance over time

Payoff schedule

One row per year. Open a year to see its months.

Payoff schedule with the extra payment
YearPaidPrincipalInterestOf which extraBalance
$6,000.00$4,750.49$1,249.51$1,200.00$15,249.51
$6,000.00$5,093.88$906.12$1,200.00$10,155.63
$6,000.00$5,462.15$537.85$1,200.00$4,693.48
$4,841.25$4,693.48$147.77$900.00$0.00
Total$22,841.25$20,000.00$2,841.25$4,500.00

How it is calculated

Two ways in

Given a monthly payment, the calculator runs the schedule month by month until the balance reaches zero and counts the payments. Given a term in months, it computes the level payment that repays the balance over exactly that term, rounded to the cent.

The annual rate is treated as a nominal rate compounded monthly: each month's interest is the balance times the annual rate divided by 12, rounded to the cent. Most installment loans, such as car and personal loans, are quoted this way.

When the payment is too small

If the payment does not exceed the first month's interest, the balance never falls, and the loan is never repaid. The calculator shows a dash and the interest the payment would need to beat, rather than a number of months.

Extra payments

An extra monthly payment goes to principal every month. The schedule is run again with it; the difference in interest and in months is the saving. The last payment is whatever remains, so the schedule's rows add up to its totals exactly.

The formula

r = annual rate ÷ 12
interest(month) = balance × r, rounded to the cent
payment for a term of n months = balance × r ÷ (1 − (1 + r)^−n)
months at a payment P (closed form) = −ln(1 − balance × r ÷ P) ÷ ln(1 + r)

Worked example: $20,000 at 7% with $400 a month

A $20,000 balance at 7% a year, paid at $400 a month, is repaid in 60 payments. The first month's interest is $116.67. Total interest comes to $3,715.28, and the final payment is $115.28.

Adding $100 a month, for $500 in all, repays the loan in 46 payments with $2,841.25 of interest: a saving of $874.03 and 14 months.

Questions and answers

How do I calculate how long it will take to pay off a loan?

Run the balance forward month by month: add a month's interest (the balance times the annual rate divided by 12) and subtract the payment, until the balance reaches zero. The closed form is n = −ln(1 − B × r ÷ P) ÷ ln(1 + r). A $20,000 loan at 7% paid at $400 a month takes 60 payments.

How much does paying extra on a loan save?

Every extra dollar reduces the principal, so all later interest is charged on a smaller balance. On a $20,000 loan at 7% paid at $400 a month, an extra $100 a month saves $874.03 of interest and 14 months, provided the lender applies extra payments to principal.

What happens if my payment does not cover the interest?

If the monthly payment is less than or equal to the month's interest, the balance does not fall, and with a smaller payment it grows. The loan is then never repaid. A $20,000 balance at 7% accrues $116.67 of interest in the first month, so any payment at or below that amount never repays it.

Does this work for credit cards?

Only approximately. Credit card interest is usually charged on the average daily balance at a daily rate, and the minimum payment changes as the balance falls. This calculator assumes a fixed monthly payment and interest of the annual rate divided by 12 on the balance.

Sources

Updated . Results are arithmetic on the figures you enter, not advice.

Cite this page

Funkfolio, “Loan payoff calculator: time to repay and interest saved”. https://funkfolio.com/tools/loan-payoff-calculator