Loan Payoff Estimator: Calculate Your Payoff Time

A loan payoff estimator calculates how many monthly payments you may need to repay a loan when you enter its balance, annual percentage rate (APR), and planned monthly payment. This calculator estimates the payoff time and shows the interest cost implied by that payment; it assumes a fixed rate and regular monthly payments.

Formula

The calculator finds the number of monthly periods needed for repeated payments to reduce a balance to zero under a fixed monthly interest rate. It uses:

n = ceil(round(−ln(1 − rP / M) / ln(1 + r), 6))

• P is the current loan balance in dollars.
• APR is the annual percentage rate entered as a percentage, such as 8 for 8%.
• r is the monthly rate, calculated as APR ÷ 1,200.
• M is the monthly payment in dollars.
• n is the estimated number of monthly payments; the result rounds up to a whole payment period.

The payment must exceed the interest that accrues in a month: M > rP. If it does not, the balance will not be paid off under this model, so the expression cannot produce a valid payoff time. The total paid is M × n, and estimated interest is total paid minus the starting balance. These totals use the entered payment for every period, including the final period; an actual final payment is often smaller because the remaining balance is less than a full scheduled payment.

Worked Example

Using the calculator’s default inputs: balance P = $20,000, APR = 8%, and monthly payment M = $500.

1. Convert the APR to a monthly rate: r = 8 ÷ 1,200 = 0.0066667, or about 0.6667% per month.
2. Substitute into the payoff formula: n = ceil(−ln(1 − 0.0066667 × 20,000 ÷ 500) ÷ ln(1.0066667)).
3. Evaluate: n = ceil(−ln(0.7333333) ÷ ln(1.0066667)) = ceil(46.75) = 47 months.
4. Total of scheduled payments: $500 × 47 = $23,500.00.
5. Estimated interest: $23,500 − $20,000 = $3,500.00.

Because the formula applies a full $500 payment in month 47, the totals are a simplified estimate. A lender’s amortization schedule would normally calculate the exact final payment from the balance remaining after month 46, and may therefore show a lower total.

Assumptions

• The interest rate stays fixed at the APR entered.
• Payments are equal, made monthly, and applied at the end of each monthly period.
• Interest compounds monthly using APR ÷ 12; this is a simplified standard estimate, not every lender’s day-by-day calculation.
• The calculation excludes fees, taxes, insurance, PMI, escrow, late charges, and any other amounts not entered.

When to Use a Loan Payoff Estimator

Use an estimator to explore how a chosen monthly payment relates to payoff time and interest on a fixed-rate loan. It can help you compare hypothetical payment amounts or check the broad effect of changing an input. It does not determine whether a payment fits your budget, whether a lender will accept it, or whether extra payments will be applied to principal as assumed.

For a reliable estimate, use the current principal balance rather than the original amount borrowed. The balance shown on a statement may differ from a payoff quote, which can include interest accrued through a specific date or other amounts. Use the APR and payment terms that apply to the account, and confirm how the lender handles additional payments and payment dates.

How to Read the Results

The first result is a whole number of months. Divide it by 12 for an approximate number of years, remembering that the remaining months matter: 47 months is 3 years and 11 months. The total-payment and interest figures are model estimates based on the entered payment repeated for every month, not a lender-issued payoff amount.

Interest is not a fixed fee added once to the original balance. In a typical amortizing loan, each payment covers interest accrued since the previous payment and reduces principal with what remains. As principal falls, the interest portion generally falls too, assuming the rate and timing stay constant. This is why payoff time depends on all three inputs: balance, rate, and payment.

Common Errors and Limits

• Entering the original loan amount: For an existing loan, use the current balance if available; past payments have already changed principal.
• Confusing APR with a monthly rate: Enter an annual APR as a percentage. Do not enter 0.0067 for a rate of 8%; the calculator converts 8 to a monthly rate.
• Using a payment that only covers interest: If the payment is equal to or below the monthly interest, the balance does not decline under the model. Check the payment and rate inputs.
• Assuming the final payment is full-sized: Rounding the period up creates a full-payment total that can overstate the last payment and interest.
• Ignoring fees or variable rates: Fees, changing rates, skipped or irregular payments, and lender-specific interest calculations are outside this formula.

The estimate is most useful when payments are regular and the rate is fixed. For a variable-rate loan or one with payment changes, calculate separate scenarios or use the lender’s current amortization details rather than treating one result as a prediction.

Frequently Asked Questions

How do I calculate how long it will take to pay off a loan?
Enter the current balance, APR, and monthly payment in the formula above. It converts APR to a monthly rate, solves for the number of payment periods, then rounds up to a whole month.

What if my monthly payment is less than the interest?
The payment will not reduce principal under this fixed-rate model, so there is no finite payoff time. A payment equal to monthly interest also leaves the balance unchanged.

Does this estimator include extra payments?
No. Enter the total monthly amount you expect to pay as the payment input to model a consistent larger payment. The calculator does not model one-off extra payments, changing amounts, or how a lender allocates them.

Why is my lender’s payoff amount different?
A lender’s figure may use an exact payoff date and account for accrued daily interest, a smaller final payment, fees, or other account-specific details. This estimator uses simplified monthly periods and the inputs you provide.

Can I use this for a variable-rate loan?
Only as a scenario using one assumed rate. Because future rate changes can alter the interest and payment schedule, the result cannot represent the actual payoff time unless the rate remains as entered.

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

Related

• JS Bank Car Loan Calculator and Payment Guide
• IAA Loan Payoff Calculator and Explanation
• Car Loan Down Payment: Is One Required?

in p | Loan balance | $ | 20000 | 0.01 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in pay | Monthly payment | $ | 500 | 0.01 | 100000000
out mos | Estimated months to payoff | months | ceil(round(-ln(1 - (apr / 1200) * p / pay) / ln(1 + apr / 1200), 6)) | 0
out paid | Total of scheduled payments | $ | pay * mos | 2
out int | Estimated interest paid | $ | paid - p | 2