calculate-loan

01 Loan payments

Loan Calculator: Calculate the Term to Repay

Calculator No. 01-8354 · Updated · Formula and assumptions shown below

Monthly payment $405.53
Total interest
$4,331.67
= Monthly payment × loan term × 12 − loan amount
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

A loan calculator can calculate the term—the number of payment periods needed to repay a balance—if you enter the loan amount, interest rate, and payment amount. This calculator estimates the payoff term in months and years for a fixed-rate loan with regular monthly payments; it also shows the payment needed for the stated term.

Formula

This calculator answers how much the scheduled monthly payment would be for the entered term, and how much interest those rounded payments add up to. To calculate an unknown payoff term from a payment you already make, use the inverse formula below; the calculator’s term field here is an input, not an output. This distinction matters because payment, balance, interest rate, and term are linked: you need enough known values to solve for the one you want.

For a fixed monthly payment, the mathematical number of months to repay a principal balance is:

n = -ln(1 - r × P / M) / ln(1 + r)

  • P is the starting loan balance, in dollars.
  • M is the monthly payment, in dollars.
  • r is the monthly interest rate as a decimal, calculated here as APR / 1200.
  • n is the calculated number of monthly payments. A practical payoff estimate rounds this up to a whole month, because a fractional monthly payment period is not a normal scheduled installment.
  • ln is the natural logarithm.

The inverse calculation is possible only when the payment exceeds the interest accruing for the period: M > r × P. If it does not, the balance will not decline under this model. The calculator block instead works forward from the entered term: n = yrs × 12, then M = P × r / (1 - (1 + r)-n). Its interest output is the rounded monthly payment times the number of payments, minus the initial principal.

Worked Example

Using the calculator’s default inputs—$20,000 principal, 8% APR, and a five-year term—first convert the annual percentage rate to a monthly decimal rate:

  • r = 8 / 1200 = 0.0066667
  • n = 5 × 12 = 60 monthly payments
  • M = 20,000 × 0.0066667 / (1 - (1 + 0.0066667)-60)
  • M ≈ $405.53 per month, rounded to cents
  • Total interest = $405.53 × 60 - $20,000 = $4,331.80

The term entered is 60 months, or five years. If instead you wanted to find the term from a known payment, insert that payment as M in the inverse formula. For example, using the formula’s unrounded mathematical result and then rounding up to a whole month gives the estimated payoff period. The exact final installment may be smaller than the regular payment because the remaining balance can be less than a full scheduled amount.

Assumptions

  • The interest rate is fixed over the modeled term.
  • Payments are made monthly at the end of each period, with the first payment one month after borrowing.
  • Interest accrues monthly at APR divided by 12; this is a standard simplifying assumption, not a statement about every loan’s day-count method.
  • Fees, taxes, insurance, PMI, escrow, late charges, and payment changes are not included.
  • The payment is rounded to cents, and total interest uses that rounded payment for every scheduled month.

When a Calculator Can Find the Term

A loan calculator can solve for a term when you know the current balance, the interest rate, and the payment amount, and the payment is large enough to reduce principal. The expression for n comes from the standard amortization equation, which treats each payment as covering that month’s interest first and then reducing the balance. It assumes the same payment and rate throughout.

To estimate a term, use the balance that remains now—not necessarily the original amount borrowed—and the payment that actually goes toward the loan. If the payment includes insurance or other charges, separate those from principal-and-interest before using the formula. A lender’s account statement or payoff information may use timing, fees, or accrued interest not captured by a simple estimate.

How to Read the Result

The forward calculation above gives a monthly payment and total interest for a chosen term. A term calculator reverses that relationship and reports an estimated number of months. For example, a result of 48 months means about four years of monthly installments under the stated assumptions, not a guaranteed payoff date.

Interest is charged on the remaining balance, so early payments generally contain a larger interest portion than later payments in a standard amortizing schedule. The balance falls over time as payments cover interest and repay principal. When a payment amount is rounded to cents, the final payment can differ slightly from the regular amount, and a lender’s payoff quote can also include interest accrued since the last scheduled payment.

Common Errors and Limits

  • Mixing annual and monthly rates: enter APR as a percent per year. The formula divides it by 1200 to convert to a monthly decimal; do not enter 0.08 for an 8% APR.
  • Using the wrong payment: a total bill that includes taxes, insurance, or fees is not necessarily the loan payment used in amortization.
  • Assuming any payment produces a payoff date: if the payment is no greater than monthly interest, the formula has no finite repayment result.
  • Ignoring variable rates or changing payments: this model cannot represent rate resets, skipped payments, extra payments, or a changing minimum due.
  • Treating a rounded estimate as a lender quote: cents, payment dates, daily interest, and contract terms can shift the actual payoff amount or date.

For irregular payments or a changing rate, the balance is better modeled period by period using the actual payment dates, rates, and charges. A simple level-payment equation is useful for understanding the relationship among the key figures, but does not reproduce every loan agreement.

Frequently Asked Questions

Can a loan calculator calculate the loan term?
Yes, if you provide the balance, interest rate, and regular payment. The calculator can estimate how many monthly periods are needed, provided the payment exceeds the interest due each period.

What information do I need to calculate a loan term?
You need the outstanding principal balance, the interest rate and its compounding convention, and the amount of each regular payment. Include only the part of a combined payment that services the loan.

Why does the calculator say it cannot calculate a term?
A common reason is that the payment is too small to cover interest at the stated rate. In that case the balance does not decline under the formula, so there is no finite payoff term.

Does a shorter loan term always mean less total interest?
For the same principal and fixed rate under this model, a shorter term requires larger payments and reduces the number of periods over which interest accrues. Actual comparisons depend on the figures and charges entered; this calculation is not a recommendation.

Why may the actual payoff date differ from the estimate?
Actual results can differ because of payment dates, daily interest calculations, fees, rate changes, extra or missed payments, or a final installment adjusted to the remaining balance. Check the lender’s statement or payoff disclosure for the exact figures.

This result is an estimate, and the lender’s disclosure gives the exact figures.

Related

Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →