How to Calculate Loan Term from Payment and APR

This calculator estimates how many monthly payments it takes to repay a loan when you know the balance, APR, and fixed payment amount. Enter those three figures to get an estimated payoff term in months and years, plus the interest paid over that period.

Formula

For a fixed-rate loan with level monthly payments, the term is the number of payment periods needed to amortize the balance. The formula is n = ceil(−ln(1 − rP/M) / ln(1 + r)), where n is the estimated number of monthly payments, r is the monthly interest rate, P is the starting loan balance, and M is the monthly payment. Convert APR to a monthly rate using r = APR / 1200, when APR is entered as a percentage.

The calculator rounds the result up to a whole monthly payment period. The extra-payment condition is important: a payment must exceed the interest that accrues in a month, which is P × r at the start. If the payment is equal to or below that amount, this formula cannot produce a payoff term. The calculator blocks a payment that does not cover the initial month’s interest.

The interest output is an estimate calculated as M × n − P, using the rounded-up whole number of payments. This treats every payment as equal, so it does not model a smaller final payoff amount. Actual lenders commonly adjust the final payment to match the remaining balance; use the lender’s amortization schedule or payoff quote for an exact figure.

Worked Example

Use the calculator’s defaults: balance P = $20,000, APR 8%, and monthly payment M = $405.53.

1. Convert the annual percentage rate to a monthly decimal rate: r = 8 / 1200 = 0.0066667.
2. Check that the payment covers initial monthly interest: $20,000 × 0.0066667 ≈ $133.33. The $405.53 payment exceeds that amount.
3. Substitute into the term formula: n = ceil(−ln(1 − 0.0066667 × 20,000 / 405.53) / ln(1.0066667)).
4. Evaluate and round the formula’s intermediate result to six decimal places: it is approximately 59.999 months. Round up to a whole payment period: 60 months.
5. Convert months to years: 60 / 12 = 5.00 years.
6. Estimate total interest using the calculator’s rounded payment and term: $405.53 × 60 − $20,000 = $4,331.80.

The displayed result is therefore 60 months (5.00 years), with estimated total interest of $4,331.80. Values may differ slightly from a lender’s schedule because of payment dates, daily interest, rounding, and the final payment amount.

Assumptions

• The interest rate stays fixed for the full estimated term.
• Payments are equal, made monthly, and applied at the end of each monthly period.
• Interest compounds monthly at APR divided by 12.
• The calculation excludes fees, taxes, insurance, PMI, escrow, and other charges; none are inputs in this calculator.

What You’ll Need

• Current loan balance: use the principal balance remaining, not necessarily the original amount borrowed. For a new loan, use the amount financed.
• APR: enter the annual percentage rate as a percentage, such as 8 for 8%. Get the applicable rate and any rate-change details from the lender’s documents.
• Monthly payment: enter the regular amount that goes toward principal and interest. If a quoted payment includes insurance, taxes, or fees, separate those amounts first if possible.
• A calculator or spreadsheet is useful for checking the result, but the on-page calculator performs the arithmetic.

Step-by-Step

1. Find the balance to repay. Check a recent statement or loan account record. If payments have already been made, use the remaining principal rather than the original loan amount. A statement balance can differ from a payoff quote because interest may accrue between dates.
2. Enter the APR as a percent. Do not enter a decimal equivalent: type 8 for 8%, not 0.08. The formula converts APR to a monthly rate by dividing by 1,200. If the loan has a variable rate, this fixed-rate estimate will not forecast future changes.
3. Enter the recurring monthly payment. Use the amount applied to the loan each month, excluding separate insurance or escrow charges. If the payment changes over time or includes irregular extra payments, a single-payment calculation cannot represent that schedule exactly.
4. Check that the payment exceeds monthly interest. At the start, multiply the balance by the monthly rate. If the payment is not greater than that amount, the balance will not be paid down under the assumed schedule. The calculator may show “Cannot compute” for this case.
5. Read the term in months first. The result is rounded up to a whole monthly period, since a fraction of a regular payment period is not displayed as a partial month. The years figure is a conversion of months divided by 12, not a separate calculation of exact calendar dates.
6. Use the interest figure as an estimate. It multiplies the entered payment by the rounded-up number of months and subtracts the starting balance. Since a real last payment may be smaller, and lender calculations may use different timing or rounding, this total is not a payoff quote.
7. Compare with the loan’s schedule. If the result is being used to understand an existing loan, check the estimated term against the lender’s amortization schedule. Ask the lender for an updated schedule or payoff amount when exact dates and amounts matter.

When to Use This Calculation

This method is useful for estimating the remaining duration of a fixed-rate loan when the balance, APR, and payment are known. It can also show how a changed payment amount affects the mathematical payoff period, but it does not tell you whether to change a payment or enter into a loan. Treat each result as a scenario, using figures confirmed by the lender.

Common Mistakes

• Mixing up percentage and decimal formats: enter APR as 8 for 8%. The formula handles the conversion.
• Using the original loan amount: for an existing loan, the current principal balance is usually the relevant starting value.
• Entering the full bill as the loan payment: taxes, insurance, and escrow may not reduce principal. Include only the amount represented by the fixed loan payment.
• Using a payment that only covers interest: the loan will not amortize under the formula unless the payment is greater than initial monthly interest.
• Expecting exact dates or cents: the result is a whole number of payment periods and an estimated interest total. Daily accrual, posting dates, and final-payment adjustments can change actual figures.

Tips

• Use the same date basis for balance and payment information where possible; a balance may change as interest accrues.
• Keep a record of the figures and their source so you can update the estimate when the balance or payment changes.
• For a variable-rate loan or a schedule with irregular payments, calculate separate scenarios only as rough comparisons and request a lender schedule for the actual terms.
• Check whether your payment amount includes items that do not pay down the loan before entering it.

Troubleshooting

If the calculator says it cannot compute, first verify the APR, balance, and payment units. Make sure the APR is a percentage, the balance is positive, and the monthly payment is larger than the balance multiplied by APR divided by 1,200. If it is not, the assumed payment does not cover the initial interest; confirm the figures with the lender rather than forcing a term estimate.

If the estimated term differs from your statement, check whether the statement uses a different balance date, payment amount, rate, or payment frequency. A variable rate, fees added to the balance, skipped or late payments, or daily-interest conventions can also explain differences. Ask the lender for a current amortization schedule when the discrepancy affects a planned payment or payoff date.

Frequently Asked Questions

How do I calculate a loan term from the monthly payment?
Use the remaining balance, APR, and monthly payment in the amortization term formula. Convert APR to a monthly rate, solve for the number of periods, and round up to a whole payment month.

Can I calculate the term if I know only the loan amount?
No. You also need the interest rate and payment amount. Different rates or payments can produce different payoff periods for the same balance.

Why must the payment be higher than monthly interest?
If a payment does not cover the interest due for the period, it cannot reduce principal under this model. A payment equal to interest leaves the balance unchanged; a smaller payment can cause it to grow.

Does the calculator give an exact payoff date?
No. It estimates a number of monthly periods, not a calendar date. The actual date and final amount depend on payment timing, interest accrual, and lender processing.

Does this method work for variable-rate loans?
Only as a snapshot assuming the entered APR stays unchanged. Future rate changes or changing payments alter the payoff schedule.

Why is the interest estimate different from my lender’s total?
The calculator assumes equal payments and monthly compounding, then uses the rounded-up term. Lender schedules may account for daily interest, dates, fees, payment adjustments, and a smaller final payment.

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

Related

• U.S. Bank Balance Transfer Calculator and Guide
• Bank Rate Term Loan Calculator: Estimate Payments
• L&T Balance Sheet: How to Read Its Financial Position

in p | Loan balance | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in pay | Monthly payment | $ | 405.53 | 0.01 | 1000000
out mos | Estimated loan term | months | ceil(round(-ln(1 - (apr / 1200) * p / pay) / ln(1 + apr / 1200), 6)) + 0 * sqrt(pay - p * (apr / 1200)) | 0
out yrs | Estimated loan term | years | mos / 12 | 2
out int | Estimated total interest | $ | pay * mos - p | 2