This loan balance calculator with payment shows your remaining loan balance after a certain number of payments, given your original loan amount, interest rate (APR), loan term, and monthly payment. You enter those four numbers and get back the outstanding balance at any point in the loan’s life, plus the total interest paid up to that point. It is a useful tool for understanding how much you still owe and how your payments are split between interest and principal.
Formula
The calculator uses two standard formulas. First, it computes the fixed monthly payment for a fully amortizing loan:
Monthly payment = P × (r / (1 − (1 + r)^(−n)))
where:
- P = original loan amount (in dollars)
- r = monthly interest rate = APR ÷ 1200 (APR is a yearly percentage, so divide by 100 to get a decimal, then by 12 for the monthly rate)
- n = total number of monthly payments = loan term in years × 12
Then, the remaining balance after k payments is:
Balance = P × (1 + r)^k − Payment × ((1 + r)^k − 1) / r
Here k is the number of payments already made. The first term grows the original principal by the accumulated interest, and the second term subtracts the accumulated value of all payments made so far. The result is the outstanding principal plus any unpaid interest.
Worked Example
Using the default values: P = $20,000, APR = 8%, term = 5 years, and k = 12 payments made.
- Monthly rate r = 8 ÷ 1200 = 0.0066667.
- Total payments n = 5 × 12 = 60.
- Monthly payment = 20000 × (0.0066667 / (1 − (1.0066667)^(−60))).
- Compute (1.0066667)^(−60) ≈ 0.67121. So 1 − 0.67121 = 0.32879.
- Payment = 20000 × (0.0066667 / 0.32879) = 20000 × 0.020276 = $405.53 (rounded to the cent).
- Balance after 12 payments = 20000 × (1.0066667)^12 − 405.53 × ((1.0066667)^12 − 1) / 0.0066667.
- (1.0066667)^12 ≈ 1.082999. So first term = 20000 × 1.082999 = $21,659.98.
- Second term: (1.082999 − 1) = 0.082999. Divide by 0.0066667 gives 12.4499. Multiply by 405.53 gives $5,049.87.
- Balance = 21,659.98 − 5,049.87 = $16,610.11.
So after one year of payments, the remaining balance is about $16,610.11. The principal paid is $20,000 − $16,610.11 = $3,389.89. The interest paid so far is (405.53 × 12) − 3,389.89 = 4,866.36 − 3,389.89 = $1,476.47.
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 monthly payment is exactly the level payment that would pay off the loan in the given term. If you make a different payment, the balance will be different.
- Fees, taxes, insurance, PMI, and escrow are not included. They would change the actual balance.
How to Use the Results
The remaining balance tells you how much you would need to pay off the loan in full at that moment, assuming no prepayment penalty. It also shows how much of your payments have gone toward interest versus principal. In the early years, most of your payment goes to interest; later, more goes to principal. This is called amortization.
You can use the calculator to plan extra payments. For example, if you make an extra payment, the balance drops faster. To see the effect, you would need to recalculate with a new payment amount or a shorter term. This calculator only shows the balance at a point in time, not the effect of prepayments.
Common Mistakes
- Using the APR as a monthly rate. Always divide the APR by 1200 to get the monthly decimal rate. Using 8% directly as a monthly rate would give a wildly wrong balance.
- Rounding the payment too early. The formula for balance assumes the exact payment. If you round the payment to the cent (as you must in real life), the balance will be slightly different. This calculator rounds the payment to the cent and then uses that rounded value, so it matches reality.
- Mixing up months and years. The term is in years, the payments made are in months. Make sure k is in months, not years.
- Ignoring the payment timing. If your first payment is due immediately (unusual), the balance after k payments would be different.
Why the Balance Matters
Knowing your remaining balance is essential for several reasons:
- If you want to refinance, the new lender needs the payoff amount, which is the remaining balance plus any accrued interest and fees.
- If you sell an asset (like a car or home) that secures the loan, you need to know how much you still owe to calculate your equity.
- If you are considering paying off the loan early, the balance tells you the principal amount you need to pay.
- If you are tracking your net worth, your debt balance is a key number.
This calculator gives you that number quickly, without needing to log into a lender portal or call customer service.
Limitations of the Formula
The formula assumes a fixed interest rate and constant monthly payments. If you have an adjustable-rate mortgage or a variable-rate personal loan, the balance will differ. Also, if you have missed payments, made partial payments, or paid extra, the balance will not match. The formula also ignores any fees added to the loan balance, such as late fees or origination fees that were financed.
For most standard fixed-rate loans, however, this is the exact mathematical balance. Lenders use the same amortization formula, so the result should match your statement within a few cents (due to rounding).
Frequently Asked Questions
What is the difference between remaining balance and payoff amount?
The remaining balance is the outstanding principal plus interest accrued to date. The payoff amount is the amount you need to pay to close the loan on a specific day, which may include a few days of additional interest, prepayment penalties, or fees. The payoff amount is usually slightly higher than the balance shown here.
Can I use this calculator for a car loan or mortgage?
Yes, the formula works for any fixed-rate amortizing loan, including auto loans, mortgages, student loans, and personal loans. The key is that the interest rate is fixed and the payment is level. If your loan has a variable rate, this calculator will not be accurate.
How do I find out how much interest I will pay in total?
If you want total interest over the whole loan, you can use a standard loan payment calculator. This calculator shows interest paid so far. To get total interest, multiply the monthly payment by the total number of payments and subtract the original loan amount. For the default example, that is $405.53 × 60 − $20,000 = $4,331.80.
What if I make extra payments?
Extra payments reduce the principal faster, so the balance after a given number of months will be lower than what this calculator shows. To model extra payments, you would need a more advanced calculator that accounts for the extra amount and the timing. This calculator assumes you make exactly the required payment every month.
Why does the balance go down so slowly at first?
In the early months, most of your payment goes toward interest. For a $20,000 loan at 8% for 5 years, the first payment is about $405.53, of which $133.33 is interest and only $272.20 is principal. As the principal decreases, the interest portion shrinks, so more of your payment goes to principal later.
This result is an estimate based on the inputs you provide. Your lender’s statement or payoff quote will give the exact figures, including any fees or 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 made | months | 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 | Principal paid | $ | p - bal | 2 out int | Interest paid so far | $ | (p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * k - (p - bal) | 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
- Car Loan Payment Calculator and Formula$405.53
- VA Down Payment Assistance Calculator and Guide$15,000.00
- Low Down Payment Home Loans: Costs and Trade-Offs$405.53
- Down Payment vs Advance Payment: Key Differences
- Down Payment Assistance Grant Calculator$5,000.00