calculate-loan

01 Loan payments

Loan Amount Due Calculator: Find Your Payoff

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

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

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.

This calculator works out the total amount you still owe on a loan at any point in time, plus the remaining interest and the payoff balance if you settled it today. You enter the original loan amount, the annual interest rate (APR), the original term in years, and the number of payments already made; you get back the current principal balance, the total interest paid so far, and the exact payoff amount including accrued interest.

Formula

The remaining balance after k payments is calculated with the standard amortization formula:

Bk = P × (1 + r)k − PMT × ((1 + r)k − 1) / r

Where:

  • P = original loan amount (in $)
  • r = monthly interest rate = APR / 1200 (APR in % per year)
  • k = number of payments already made (months)
  • PMT = fixed monthly payment = P × r / (1 − (1 + r)−n), where n = total number of months (years × 12)

The payoff amount adds one month’s interest to the remaining balance, assuming you pay on the next due date. The calculator uses a 30-day month approximation (30 / 30.4167) to estimate the daily interest accrual.

Worked Example

Using the default values: P = $20,000, APR = 8%, term = 5 years, and k = 12 payments made.

  1. Monthly rate r = 8 / 1200 = 0.0066667
  2. Total months n = 5 × 12 = 60
  3. Monthly payment PMT = 20000 × 0.0066667 / (1 − (1.0066667)^−60) = 20000 × 0.0066667 / (1 − 0.67121) = 20000 × 0.0066667 / 0.32879 = 20000 × 0.020276 = $405.53 (rounded to cents)
  4. Remaining balance after 12 payments: B12 = 20000 × (1.0066667)^12 − 405.53 × ((1.0066667)^12 − 1) / 0.0066667
  5. (1.0066667)^12 = 1.082999
  6. B12 = 20000 × 1.082999 − 405.53 × (1.082999 − 1) / 0.0066667 = 21659.98 − 405.53 × 12.4499 = 21659.98 − 5049.99 = $16,609.99
  7. Interest paid so far = total payments − principal reduction = (405.53 × 12) − (20000 − 16609.99) = 4866.36 − 3390.01 = $1,476.35
  8. Payoff today = 16609.99 × (1.0066667)^(30/30.4167) = 16609.99 × 1.006579 = $16,719.33

So after one year of payments on a $20,000 loan at 8% for 5 years, you still owe about $16,610, and the payoff amount is about $16,719.

Assumptions

  • Fixed interest rate for the entire term (no rate changes).
  • Payments are made at the end of each month (standard amortization).
  • Interest compounds monthly at APR / 12.
  • The payoff amount assumes you pay on the next due date; if you pay early or late, the exact amount will differ.
  • This calculator does not include fees, taxes, insurance, PMI, or prepayment penalties unless you add them separately.

When to Use This Calculator

You might need the remaining balance for several reasons:

  • You want to refinance and need to know your current payoff to compare offers.
  • You’re considering paying off the loan early and want to see the exact amount required.
  • You’re selling an asset (like a car or house) and need to know how much you owe to clear the title.
  • You want to track how much of your payment goes to interest vs. principal over time.

The payoff amount is what you would actually pay to close the loan today. It includes the remaining principal plus any interest accrued since your last payment. Lenders may also charge a small fee for a payoff statement, which is not included here.

How to Read the Results

The remaining balance is the amount of principal left after your last payment. The interest paid so far is the total interest you have paid up to this point. The payoff amount is the total you would need to send to the lender today to satisfy the loan.

Notice that the payoff amount is always slightly higher than the remaining balance because interest accrues daily between payments. The difference is small if you just made a payment, but larger if you’re halfway through the month.

Also, the remaining balance is not the same as the “principal balance” shown on your statement, because your statement may not include interest accrued since the last payment. That’s why the payoff amount is the number to use when you’re actually ready to pay off the loan.

Common Mistakes

  • Using the original loan amount instead of the current balance. The calculator takes the original amount and the number of payments made, so don’t enter the balance you see on your statement.
  • Confusing APR with the monthly rate. APR is annual, so the calculator divides by 1200. If you enter the monthly rate as the APR, the result will be wildly wrong.
  • Entering the term in months instead of years. The calculator expects years. If your loan is 60 months, enter 5 years, not 60.
  • Forgetting to round the monthly payment to cents. The calculator uses the exact formula, but your actual payment may be rounded to the nearest cent, which can cause a tiny difference over many months.
  • Ignoring extra payments. If you have made extra principal payments, this calculator will overestimate your remaining balance. You would need to adjust the number of payments or use a more detailed amortization schedule.

Limits of the Formula

The amortization formula assumes a fixed interest rate and a constant payment. If your loan has a variable rate, interest-only periods, or balloon payments, this calculator will not be accurate. Also, if you have missed payments or made partial payments, the balance will differ. The formula also assumes that each payment is made exactly on the due date; if you pay early or late, the interest calculation shifts.

For most standard fixed-rate loans (like many auto loans, personal loans, and student loans), this method is very accurate. For mortgages, the same formula works, but you must include escrow and insurance separately if you want your total monthly cost.

Frequently Asked Questions

What is the difference between remaining balance and payoff amount?

The remaining balance is the principal you owe after your last payment, not counting interest that has accrued since then. The payoff amount is the total you need to pay today to close the loan, which includes the remaining balance plus the interest that has built up since your last payment (and possibly a small fee). The payoff amount is always slightly higher.

Why does my statement show a different balance than the calculator?

Your statement may show the principal balance as of the last payment date, not including interest accrued since then. The calculator’s remaining balance is also as of the last payment, so it should match if you enter the correct original amount, rate, term, and number of payments made. If you made extra payments, your actual balance will be lower.

Can I use this for a car loan?

Yes, as long as the loan has a fixed interest rate and equal monthly payments. Most auto loans work this way. If you have a simple interest loan (common for cars), interest accrues daily, and the payoff amount may differ slightly from this estimate. Check with your lender for the exact payoff figure.

How do I find out how many payments I’ve made?

Count from your first payment date to your last payment date. For example, if you made your first payment in January 2023 and your last payment was in December 2023, you have made 12 payments. You can also look at your loan statement, which often shows the payment number.

What if I made extra payments?

If you made extra principal payments, the calculator will overestimate your balance because it assumes only the regular scheduled payments. To get an accurate balance, you would need to use a calculator that allows extra payments, or contact your lender for a payoff quote.

Does the payoff amount include prepayment penalties?

No, this calculator does not include prepayment penalties, which some loans charge if you pay off early. Check your loan agreement to see if a penalty applies. The lender’s payoff statement will include any such fees.

This calculator gives an estimate based on standard amortization. Your lender’s payoff statement provides the exact amount, including any fees or daily interest adjustments.

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
in k | Payments already made | - | 12 | 0 | 600
out bal | Remaining balance | $ | p * (1 + apr / 1200) ^ k - (p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * ((1 + apr / 1200) ^ k - 1) / (apr / 1200) | 2
out paid_int | Interest paid so far | $ | (p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * k - (p - bal) | 2
out payoff | Payoff amount today | $ | bal * (1 + apr / 1200) ^ (30 / 30.4167) | 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 →