This loan balance calculator works out how much you still owe on a loan after a certain number of payments. You enter the original loan amount, the annual interest rate (APR), the original loan term, and how many payments you’ve already made; it returns your current remaining balance, plus the total interest paid so far. The result is an estimate based on a standard fixed-rate, level-payment loan.
Formula
The calculator uses two standard formulas from amortization math. First, it computes the fixed monthly payment for a fully amortizing loan:
Monthly payment = P × (r / (1 − (1 + r)^(−n)))
Then it uses that payment to find the balance after k payments:
Balance after k payments = P × (1 + r)^k − PMT × ((1 + r)^k − 1) / r
Where:
- P = original loan amount (in $)
- r = monthly interest rate = APR / 12 / 100 (as a decimal, e.g., 8% APR → 0.08/12 = 0.0066667)
- n = total number of monthly payments (term in years × 12)
- k = number of payments already made
- PMT = the level monthly payment (in $)
The formula assumes each payment is made exactly on time, and interest is compounded monthly at a rate equal to APR/12.
Worked Example
Using the default values: loan amount P = $20,000, APR = 8%, term = 5 years (n = 60 months), and k = 12 payments made.
- Monthly rate r = 8 / 12 / 100 = 0.0066667.
- Monthly payment = 20000 × (0.0066667 / (1 − (1 + 0.0066667)^(−60))) = 20000 × (0.0066667 / (1 − 0.67121)) = 20000 × (0.0066667 / 0.32879) = 20000 × 0.020276 = $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.4499 ≈ 5048.96.
- Balance = 21659.98 − 5048.96 = $16,611.02.
The calculator shows a remaining balance of $16,611.02, which matches the step-by-step result. The monthly payment is $405.53 and total paid so far is $4,866.36 (405.53 × 12).
Assumptions
- The loan has a fixed interest rate for the entire term.
- Payments are made monthly at the end of each period.
- Interest is compounded monthly at a rate equal to APR/12.
- The payment amount is constant (level payment) and covers both interest and principal.
- No fees, penalties, taxes, insurance, or other charges are included.
- You have made exactly the scheduled number of payments, no extra payments, and no missed or late payments.
When to Use This Calculator
Use this tool when you want to know your outstanding principal balance on a fixed-rate loan—for example, to estimate how much you’d need to pay off a car loan or personal loan early, or to see how much principal remains after a year of payments. It’s also useful for checking your lender’s statement: if your actual balance differs significantly from the estimate, it may indicate fees, escrow, or a different payment schedule.
The calculator works for any amortizing loan with a fixed rate and level payments: auto loans, personal loans, student loans, and fixed-rate mortgages. It does not apply to credit cards (which have revolving balances and variable payments) or to interest-only loans.
How to Read the Result
The remaining balance is the principal you still owe—the amount that would be required to pay off the loan in full at that moment (assuming no prepayment penalty). The monthly payment is the fixed amount you pay each month. The total paid so far is simply your payment times the number of payments made; it includes both principal and interest.
A common surprise: early in a loan, most of your payment goes to interest, so the balance drops slowly. In the example, after 12 of 60 payments (20% of the term), you’ve paid $4,866 but the balance only dropped from $20,000 to $16,611—a reduction of $3,389. That’s normal amortization.
Common Mistakes and Limitations
- Using the wrong rate: Always enter the annual APR, not the monthly rate. The calculator converts APR to a monthly rate internally.
- Mixing units: The term is in years, but payments are monthly. The calculator handles the conversion (years × 12), but if you manually compute, don’t forget to multiply by 12.
- Counting payments incorrectly: If you’ve made 12 payments, k = 12, not 1. Each payment reduces the balance.
- Ignoring extra payments: If you’ve paid extra, the balance will be lower than the estimate. This calculator assumes only the scheduled payment is made.
- Variable rates: If your rate changes (e.g., an adjustable-rate mortgage), this formula won’t be accurate after the change.
- Rounding: The payment is rounded to cents in the calculation; the balance uses that rounded payment. Small rounding differences are normal.
The formula also assumes you make payments on time. Late fees or grace periods are not modeled.
How to Choose the Right Balance Calculation
If you’re trying to pay off a loan early, you might want a payoff calculator that includes the exact payoff date and any prepayment penalties. If you’re considering refinancing, you need the current balance (this calculator) plus the new loan terms. If you’re comparing extra payment strategies, you’d use a calculator that lets you add extra amounts. This calculator is specifically for finding the balance after a given number of payments—nothing more.
For a mortgage, note that your monthly statement often includes escrow for taxes and insurance, so the actual payment is higher than the principal-and-interest payment shown here. The balance, however, should match the principal outstanding.
Frequently Asked Questions
Why does my balance not match my lender’s statement?
Lenders may include fees, interest accrual differences (e.g., if your payment date is not exactly monthly), or escrow adjustments. Also, if you’ve made any extra payments or if your rate is adjustable, the balance will differ. Check your statement for the exact payoff amount, which is the true figure.
What if I make an extra payment?
An extra payment reduces your principal immediately, which lowers the balance faster and reduces total interest. This calculator assumes no extra payments, so if you’ve made any, your actual balance will be lower than the estimate. To see the effect, you’d need a calculator that allows extra payments.
Can I use this for a mortgage?
Yes, for a fixed-rate mortgage with level payments, the formula works. However, if you have an adjustable-rate mortgage, a balloon payment, or interest-only periods, the estimate won’t be accurate. Also, mortgage payments often include escrow, which is not part of the principal-and-interest calculation.
How do I find the payoff amount?
The payoff amount is the balance plus any accrued interest up to the payoff date, plus any prepayment penalties or fees. Your lender can provide an official payoff quote. This calculator gives you an estimate of the principal balance, which is the main component.
What is the difference between balance and payoff?
Balance is the remaining principal at a point in time, assuming all scheduled payments have been made. Payoff amount is the total you’d need to pay today to close the loan, which includes interest accrued since the last payment and any fees. The payoff is usually slightly higher than the balance.
Does the calculator work for loans with different payment frequencies?
No, it assumes monthly payments. If you make biweekly or weekly payments, the amortization changes. You’d need to adjust the formula or use a calculator designed for that payment frequency.
Remember, this is an estimate for educational purposes. Your lender’s disclosure and monthly 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 | 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 pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2 out paid | Total paid so far | $ | pmt * k | 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
- QNB Car Loan Payment Calculator and Guide$405.53
- VA Down Payment Assistance Calculator and Guide$15,000.00
- Car Loan Payment Calculator and Formula$405.53
- Low Down Payment Home Loans: Costs and Trade-Offs$405.53
- Down Payment vs Advance Payment: Key Differences
- DIB Bank Car Loan Calculator and Payment Guide$405.53