This calculator works out the remaining balance on a loan at any point in its term—what you still owe after a certain number of payments. You enter the loan amount, annual interest rate (APR), loan term in years, and the number of payments already made; you get back the current closing balance, plus the monthly payment and total interest for reference.
Formula
The closing balance after k payments is:
Bk = P × (1 + r)k − PMT × ((1 + r)k − 1) / r
where:
- Bk = remaining balance after k payments (in $)
- P = original loan amount (in $)
- r = monthly interest rate = APR / 1200 (APR is the annual percentage rate, as a percent, so divide by 100 to get a decimal, then by 12 for monthly)
- k = number of payments already made
- PMT = level monthly payment = P × r / (1 − (1 + r)−n), where n = total number of monthly payments (years × 12)
The formula subtracts the accumulated value of all payments made from the accumulated value of the original loan. Each payment reduces principal, but interest accrues on the remaining balance each month, so the balance does not drop linearly.
Worked Example
Using the defaults: P = $20,000, APR = 8%, term = 5 years, k = 12 payments.
- Monthly rate r = 8 / 1200 = 0.0066667
- Total months n = 5 × 12 = 60
- Monthly payment PMT = 20000 × 0.0066667 / (1 − (1 + 0.0066667)−60) = 20000 × 0.0066667 / (1 − 0.67121) = 133.333 / 0.32879 = 405.53 (rounded to cents)
- Balance after 12 payments: 20000 × (1.0066667)12 − 405.53 × ((1.0066667)12 − 1) / 0.0066667
- (1.0066667)12 = 1.082999
- First term: 20000 × 1.082999 = 21659.98
- Second term: 405.53 × (1.082999 − 1) / 0.0066667 = 405.53 × 0.082999 / 0.0066667 = 405.53 × 12.4498 = 5048.53
- Balance = 21659.98 − 5048.53 = $16,611.45
The calculator shows the same: $16,611.45. After one year of payments on a 5-year loan, you still owe most of the principal because early payments are mostly interest.
Assumptions
- Fixed interest rate for the entire term (no adjustable-rate changes)
- Payments are made monthly, at the end of each month
- Interest compounds monthly at APR / 12
- The monthly payment is rounded to the cent and applied identically each month
- No fees, taxes, insurance, PMI, or escrow are included—those would change the balance
- No extra payments, late fees, or skipped payments
Why the Closing Balance Matters
The closing balance is the exact amount you would need to pay off the loan today (the payoff amount, before any prepayment penalty). Lenders use this figure when you request a payoff quote, refinance, or sell the collateral (like a car or house). It is different from the remaining principal shown on a statement because it includes accrued interest up to the payoff date. This calculator gives the balance at the start of a month after a payment; a payoff quote will include interest up to the actual payoff day, which is slightly higher.
Knowing the balance helps you plan: how much equity you have in a house, how much you still owe on a car before trading it in, or what a consolidation loan would need to cover. It also shows how much interest you will avoid by paying extra.
Common Mistakes When Calculating the Balance
- Using the annual rate instead of the monthly rate. Always divide APR by 1200, not by 12. If you use 8/12 = 0.667 instead of 0.00667, the balance will be wildly wrong.
- Counting payments incorrectly. If you have made 12 payments, k = 12, not 11. The balance after the 12th payment is what you owe immediately after that payment.
- Rounding the payment too early. Use the exact payment in the balance formula, then round the final balance to cents. Rounding the payment to $405.53 before calculating the balance is fine because that is the actual payment, but do not round intermediate values like (1+r)^k.
- Forgetting that the balance is not principal remaining. The balance includes unpaid interest; it is not simply P − (PMT × k).
- Assuming a linear decrease. The balance drops slowly at first and faster later—this is amortization, not a straight line.
How to Use the Result
Once you have the closing balance, you can compare it to a payoff quote from your lender (the quote will be slightly higher due to per-diem interest). You can also use it to see how much interest you would save by making an extra payment now: the extra payment reduces the principal, so future interest is lower. To estimate the new balance, subtract the extra amount from the current balance and recalculate with fewer remaining months, or simply ask the lender for a new payoff quote.
If you are considering refinancing, the closing balance is the amount the new loan would need to pay off. Lenders will verify this with a payoff statement, so your calculation is a planning tool, not the final figure.
Limits of the Formula
This formula assumes a fixed-rate, fully amortizing loan with level payments. It does not work for:
- Adjustable-rate mortgages (ARM) where the rate changes
- Interest-only periods
- Balloon payments or negative amortization
- Loans with fees added to the balance
- Biweekly payment schedules (the formula would need a different compounding period)
For those, you need a more detailed amortization schedule or a lender-provided statement.
Frequently Asked Questions
What is the difference between closing balance and payoff amount?
The closing balance is the amount you owe after a scheduled payment, including all interest accrued up to that date. The payoff amount is what you would pay to settle the loan on a specific day, which includes interest for the days between your last payment and the payoff date. Payoff quotes are usually a few dollars to a few hundred dollars higher, depending on the rate and days elapsed.
Can I calculate the balance after any number of months, not just full years?
Yes. The variable k can be any whole number of payments, from 0 to the total term. For example, after 30 months of a 60-month loan, enter k = 30. The formula works for any payment count, as long as you have not paid off the loan early.
Why does the balance go down slowly at first?
In the early years, most of each payment goes toward interest, not principal. For a $20,000 loan at 8% over 5 years, the first payment includes about $133 of interest and only $272 of principal. As the balance decreases, the interest portion shrinks, so more of the payment reduces principal—this is why the balance drops faster later.
Does making an extra payment change the closing balance immediately?
Yes. An extra payment reduces the principal balance immediately, so the closing balance after that payment is lower than the scheduled balance. The interest that accrues afterward is also lower. To see the effect, subtract the extra amount from the balance and recalculate with the same remaining term, or use the lender’s payoff quote after the extra payment.
Is the closing balance the same as what I owe on my statement?
Usually, but not always. Your monthly statement shows the principal balance, which is the amount before the current month’s interest is added. The closing balance in this calculator includes interest accrued up to the payment date, so it is slightly higher than the principal balance shown on a statement. The lender’s payoff quote is the authoritative figure.
What if my loan has a different payment frequency, like biweekly?
This formula assumes monthly payments. For biweekly payments (26 per year), you would need to adjust the rate and number of periods: use a biweekly rate of APR / 26 and a term in biweekly periods. The result will differ because more frequent payments reduce interest faster. Most lenders can provide a payoff quote for any schedule.
This calculator gives an estimate based on standard amortization; your lender’s disclosure and payoff statement provide the exact figures for your 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 in k | Payments already made | - | 12 | 0 | 600 out bal | Closing balance | $ | 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 | 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
- JS Bank Credit Card: Features & How to Apply$405.53
- JD Gift Card Balance: How to Check It$60.00
- JD Bank Credit Card: How It Works & What to Know$405.53
- In-N-Out Gift Card Balance: Check & Use Guide$30.00
- JCPenney Credit Card Balance: How to Check It27 months
- Houston Metro Q Card Balance: Check & Add Funds$35.00