A house loan payoff calculator works out how much you still owe on your mortgage at any point in time, and how long it will take to clear the balance if you keep making your current monthly payment. You enter your original loan amount, interest rate, loan term, and how many payments you have already made, and the calculator returns your remaining balance, your regular monthly payment, and the total interest you will pay over the life of the loan.
Formula
The calculator uses the standard amortization formula for a fixed-rate loan. The monthly payment is calculated as:
M = P × r × (1 + r)^n / ((1 + r)^n − 1)
Where:
- P = the original loan amount (the principal), in dollars.
- r = the monthly interest rate, which is the annual percentage rate (APR) divided by 12 and then divided by 100. For example, an 8% APR gives r = 8 / 1200 = 0.0066667.
- n = the total number of monthly payments, which is the loan term in years multiplied by 12.
- M = the monthly payment, in dollars, rounded to the nearest cent.
To find the remaining balance after a certain number of payments, the calculator uses the formula:
B = P × (1 + r)^k − M × ((1 + r)^k − 1) / r
Where k is the number of payments already made, and M is the rounded monthly payment. This balance is the amount you would need to pay in one lump sum to settle the loan at that point, assuming no prepayment penalties or extra fees.
Worked Example
Let’s use the default values from the calculator: a $20,000 loan at an 8% APR for 5 years.
- Convert the APR to a monthly rate: r = 8 / 1200 = 0.0066667.
- Find the total number of payments: n = 5 × 12 = 60.
- Plug into the payment formula: M = 20000 × 0.0066667 × (1.0066667)^60 / ((1.0066667)^60 − 1).
- Calculate (1.0066667)^60: (1.0066667)^60 ≈ 1.48985.
- Compute the numerator: 20000 × 0.0066667 × 1.48985 ≈ 198.647.
- Compute the denominator: 1.48985 − 1 = 0.48985.
- Divide: 198.647 / 0.48985 ≈ 405.53.
So the monthly payment is $405.53 (rounded to the cent). Over 60 payments, you pay 405.53 × 60 = $24,331.80 in total. Subtract the original $20,000, and the total interest is $4,331.80. The calculator shows the same numbers.
Assumptions
- The interest rate is fixed for the entire loan term.
- Payments are made at the end of each month, starting one month after the loan is taken out.
- Interest compounds monthly, at a rate of APR / 12.
- The loan has no prepayment penalties, and the payment amount never changes.
- Fees such as origination fees, closing costs, property taxes, homeowner’s insurance, and PMI are not included. Those are separate costs that affect your total out-of-pocket but not the loan balance calculation.
When to Use a Payoff Calculator
You might use a payoff calculator in several situations:
- To see how much you still owe: If you are considering selling your home, you need to know the payoff amount to estimate your net proceeds.
- To plan a lump-sum payment: If you receive a bonus or inheritance, you might want to know the exact balance needed to close the loan early.
- To compare loan offers: When refinancing, you can compare the remaining balance on your current loan with the new loan’s terms.
- To track your amortization: You can see how much of each payment goes to interest versus principal, which helps you understand how equity builds over time.
The calculator gives you a snapshot. For an exact payoff figure, you would need to contact your lender, because the actual payoff amount may include interest accrued up to the day you pay, plus any fees.
How to Read the Results
The monthly payment is the amount you pay each month, and it stays the same for the entire term (assuming a fixed rate). The total interest is the sum of all interest charges over the life of the loan. If you are looking at a payoff balance, remember that the balance decreases each month as you make payments, so the payoff amount changes daily due to interest accrual.
For example, if you have made 12 payments on a 5-year loan, the remaining balance is not simply the original amount minus 12 × principal portion. The balance is calculated using the formula above, which accounts for the fact that early payments are mostly interest. In the worked example, after 12 payments, the remaining balance would be about $16,700, not $16,000.
Common Mistakes
- Using the annual rate instead of the monthly rate: Always divide the APR by 12. Using 8% instead of 0.6667% in the formula will give a wildly wrong payment.
- Forgetting to convert years to months: A 5-year loan has 60 payments, not 5. Multiply years by 12.
- Rounding too early: If you round the monthly rate to 0.0067, you might get a slightly different payment. Keep full precision until the final step.
- Ignoring fees: The payoff amount from your lender may include a processing fee or a prepayment penalty. The calculator does not include those.
- Assuming the balance is simply principal minus payments: Because interest is front-loaded, you pay more interest early, so the principal balance decreases slowly at first.
Limits of the Formula
The formula works perfectly for a fixed-rate loan with equal monthly payments. It does not handle:
- Adjustable-rate mortgages (ARMs): If your rate changes, the payment changes, and the remaining balance calculation becomes more complex.
- Interest-only periods: Some loans allow interest-only payments for a few years. During that time, the principal does not decrease, so the standard amortization formula does not apply.
- Biweekly payments: If you pay every two weeks instead of monthly, you make 26 half-payments per year, which is equivalent to 13 full payments. The formula assumes 12 payments per year.
- Extra payments: If you make extra principal payments, the loan will be paid off faster, and the total interest will be lower. The standard formula does not account for those unless you adjust the inputs.
For those situations, you would need a more flexible calculator that allows variable payments or rate changes.
Frequently Asked Questions
How do I find my current payoff amount?
Your lender can provide a payoff statement, which gives the exact amount needed to close the loan on a specific date. It includes the remaining principal plus interest accrued up to that date and any fees. The calculator gives an estimate; the lender’s figure is the one you use for actual payment.
Can I use this calculator for an auto loan or personal loan?
Yes, the math is the same for any fixed-rate installment loan. The formula works regardless of what the loan is for. Just enter the loan amount, APR, and term in years, and you get the payment and total interest.
What is the difference between payoff balance and remaining principal?
The remaining principal is the amount you borrowed that has not been repaid yet. The payoff balance includes that principal plus any interest that has accrued since your last payment, and possibly a prepayment penalty or fee. The payoff balance is always equal to or higher than the principal balance.
Why does my payment go mostly to interest at the beginning?
Interest is calculated on the outstanding balance. Early in the loan, the balance is high, so the interest portion is large. As you pay down the principal, the interest portion decreases, and more of your payment goes to principal. This is called amortization.
Does making extra payments reduce my total interest?
Yes, because extra payments reduce the principal faster, which reduces the balance on which interest is calculated. This shortens the loan term and lowers the total interest paid. You can use the calculator to see the effect by reducing the term or by manually calculating the balance after extra payments.
What if I have an adjustable-rate mortgage?
This calculator assumes a fixed rate. For an ARM, the rate changes periodically, so the payment and remaining balance would need to be recalculated each time the rate changes. You would need a more specialized calculator or a lender’s amortization schedule.
Remember, this calculator provides an estimate based on the inputs you provide. Your lender’s disclosure statement gives the exact figures for your specific loan.
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
- Jet Fuel Cost per Gallon? Prices and What Affects Them
- High Amount Personal Loan Interest Rate Calculator$405.53
- Fuel Costs and Home Loans: How They Connect$405.53
- Fuel Costs Perth: Prices, Factors and Savings
- Car Quote for a Used-Car Trade-In: What It Means
- Cost of Fuel: Calculate Your Trip’s Fuel Expense$42.00