A commercial loan payoff calculator estimates the remaining balance and the total amount needed to pay off a business loan early, given the original loan amount, interest rate, term, and the number of payments already made. You enter those four figures, and the calculator returns the current payoff amount (principal plus accrued interest) and the interest you would save by paying it off today. This is the same arithmetic lenders use to quote a payoff statement, minus any prepayment penalties or fees.
Formula
The payoff amount is the outstanding principal balance plus the interest that has accrued up to the payoff date. In a standard amortizing loan, the remaining balance after k payments is:
B = P × (1 + r)^k − PMT × [((1 + r)^k − 1) / r]
Where:
- B = payoff balance (in dollars)
- P = original loan amount (in dollars)
- r = monthly interest rate = APR / 1200 (as a decimal)
- k = number of payments already made
- PMT = monthly payment = P × r / [1 − (1 + r)^(−n)], where n = total months
The monthly payment uses the standard annuity formula. The payoff balance is what you would owe if you made the next payment immediately after the k-th payment. In practice, lenders add per-diem interest for the days between the statement date and the actual payoff date, which this calculator does not model.
Worked Example
Using the defaults: loan amount $200,000, APR 8%, term 10 years, 36 payments made.
- Monthly rate r = 8 / 1200 = 0.0066667.
- Total months n = 10 × 12 = 120.
- Monthly payment PMT = 200000 × 0.0066667 / [1 − (1.0066667)^(−120)] = 200000 × 0.0066667 / (1 − 0.450523) = 200000 × 0.0066667 / 0.549477 ≈ 200000 × 0.012133 = 2426.60 (rounded to the cent).
- Balance after 36 payments: B = 200000 × (1.0066667)^36 − 2426.60 × [((1.0066667)^36 − 1) / 0.0066667].
- (1.0066667)^36 ≈ 1.270237. So B = 200000 × 1.270237 − 2426.60 × (0.270237 / 0.0066667) = 254047.40 − 2426.60 × 40.5355 ≈ 254047.40 − 98360.00 = 155687.40.
- The payoff amount is approximately $155,687.40.
The calculator’s first output shows the same rounded figure. The interest saved is the difference between the remaining scheduled payments and the payoff amount: (2426.60 × 84) − 155687.40 ≈ 203834.40 − 155687.40 = 48147.00.
Assumptions
- Fixed interest rate for the entire term; the APR is divided by 12 for monthly compounding.
- Payments are made exactly on the first day of each month, and the payoff is calculated immediately after the k-th payment.
- No fees, prepayment penalties, late fees, or per-diem interest are included.
- The loan uses standard amortization with level monthly payments.
When to Use a Payoff Calculator
Business owners use a payoff calculator when they are considering paying off a commercial loan early, refinancing, or negotiating a lump-sum settlement. The key number is the payoff amount, which is different from the remaining principal shown on a statement. The statement may show the principal balance, but the actual payoff includes interest accrued since the last payment. A payoff calculator gives you a quick estimate to compare with the lender’s official payoff quote.
You might also use it to see how much interest you would save by paying off early. That figure can help you decide whether to use excess cash to retire the loan or invest elsewhere—though that decision involves opportunity cost and tax considerations beyond simple math.
How to Read the Results
The first output, the payoff amount, is the lump sum you would need to pay today (assuming no extra fees). The second output is your regular monthly payment, which you already know but is shown for reference. The third output, interest saved, is the total interest you would avoid if you paid the payoff amount now instead of continuing to make scheduled payments.
Note that the interest saved is not the same as the total interest remaining on the amortization schedule. The remaining interest on the schedule is the sum of all future interest payments, but the payoff amount includes the principal plus interest accrued to date. The difference between the remaining scheduled payments and the payoff amount is the true saving.
Common Mistakes and Misconceptions
- Using the principal balance as the payoff amount. The payoff includes accrued interest, so it is always higher than the principal shown on a statement.
- Ignoring the payment date. If you pay mid-cycle, the lender will add per-diem interest. This calculator assumes payoff right after a payment.
- Confusing APR with the monthly rate. APR is annual; you must divide by 12 for the monthly rate.
- Rounding too early. Rounding the monthly payment to the cent before computing the balance can cause small errors. The calculator rounds only the final outputs.
- Assuming no prepayment penalty. Some commercial loans have prepayment penalties, especially with fixed rates. Check your loan agreement.
Limits of the Calculator
This calculator models a simple fixed-rate amortizing loan. Real commercial loans can have variable rates, interest-only periods, balloon payments, or tiered rates. It also does not include fees such as origination fees, documentation fees, or prepayment penalties. For an exact payoff figure, you must request a payoff statement from the lender, which will include per-diem interest and any contractual fees.
If your loan has a variable rate, the payoff amount will change as the rate changes. If you have made extra payments, the number of payments made (k) should reflect the actual payment count, not the number of scheduled payments, because extra payments reduce the balance faster. The calculator assumes exactly k regular payments have been made; it does not handle irregular payment schedules.
Frequently Asked Questions
What is the difference between payoff and principal balance?
The principal balance is the remaining amount you borrowed, not including interest. The payoff amount is the principal plus any interest that has accrued since your last payment. Because interest accrues daily on most loans, the payoff is always slightly higher than the principal balance, and it increases each day until you pay.
Can I use this for a loan with a prepayment penalty?
No. This calculator does not include prepayment penalties. If your loan has a prepayment penalty, you must add that amount to the payoff figure. The penalty is usually a percentage of the remaining balance or a certain number of months of interest—check your loan agreement or ask your lender.
How do extra payments affect the payoff amount?
Extra payments reduce the principal faster, so the payoff amount will be lower than if you had made only scheduled payments. To use this calculator with extra payments, you would need to adjust the number of payments made (k) to reflect the equivalent number of regular payments that would leave the same balance, which is not straightforward. For accurate results, use a calculator that specifically handles extra payments.
What is per-diem interest?
Per-diem interest is the daily interest that accrues on the loan. When you pay off a loan, the lender calculates interest from the date of your last payment to the date the payoff is received. This calculator assumes the payoff happens right after a payment, so it does not include per-diem interest. The lender’s payoff statement will show the exact per-diem amount.
Why does the interest saved seem too high?
The interest saved is the difference between the total of your remaining scheduled payments and the payoff amount. If you have many years left, that difference can be large because you are avoiding all future interest. However, this does not account for the opportunity cost of using that lump sum—if you could earn a higher return elsewhere, the financial decision might differ.
Does this work for a loan with a balloon payment?
No. A balloon loan has a large final payment that is not amortized. The standard amortization formula used here assumes the loan is fully repaid with equal monthly payments over the term. For a balloon loan, the payoff calculation is different and depends on the balloon structure.
The result from this calculator is an estimate based on standard amortization; the lender’s payoff statement gives the exact figures.
Related
Formula used
in p | Loan amount | $ | 200000 | 1 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in yrs | Loan term | years | 10 | 0.0833 | 50 in k | Payments made | # | 36 | 0 | 600 out bal | Payoff amount | $ | p * (1 + apr / 1200) ^ k - (p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * ((1 + apr / 1200) ^ k - 1) / (apr / 1200) | 2 out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2 out int_saved | Interest saved if paid now | $ | (pmt * (yrs * 12 - k)) - (bal - (p - (p * (1 + apr / 1200) ^ k - pmt * ((1 + apr / 1200) ^ k - 1) / (apr / 1200)))) | 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