calculate-loan

01 Loan payments

Future Loan Balance Calculator: How It Works

Calculator No. 01-24929 · Updated · Formula and assumptions shown below

Remaining balance $16,611.20
Total paid so far
$4,866.33
From the formula below, to the cent
Interest paid so far
$1,477.53
From the formula below, to the cent
Loan amount
$20,000
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years), Payments already made
You get
Remaining balance ($), Total paid so far ($), Interest paid so far ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

This calculator works out the remaining balance on a loan after a certain number of payments, based on the loan amount, interest rate, term, and how many payments you have already made. You enter those four numbers, and it returns the exact principal still owed at that point, plus the total interest paid so far. It uses the standard amortization formula, so the result matches what your lender’s statement should show for a fixed-rate loan.

Formula

The remaining balance after k payments is calculated with this standard amortization formula:

B = P × (1 + r)^k − PMT × ((1 + r)^k − 1) / r

Where:

  • B = remaining balance (what you still owe)
  • P = original loan amount (principal)
  • r = monthly interest rate = APR / 1200 (APR is the annual percentage rate)
  • k = number of payments already made
  • PMT = the fixed monthly payment, calculated as PMT = P × r / (1 − (1 + r)^−n), where n is the total number of months in the loan term

All amounts are in dollars, rates are in percent per year, and k and n are in months. The formula assumes the payment is made at the end of each month (ordinary annuity).

Worked Example

Using the default values from the calculator: loan amount $20,000, APR 8%, term 5 years, and 12 payments already made.

  1. Monthly rate r = 8 / 1200 = 0.0066667
  2. Total months n = 5 × 12 = 60
  3. Monthly payment PMT = 20000 × 0.0066667 / (1 − (1 + 0.0066667)^−60) = 405.53 (rounded to cents)
  4. Balance after 12 payments: B = 20000 × (1.0066667)^12 − 405.53 × ((1.0066667)^12 − 1) / 0.0066667
  5. (1.0066667)^12 = 1.0829995
  6. 20000 × 1.0829995 = 21659.99
  7. 405.53 × (1.0829995 − 1) / 0.0066667 = 405.53 × 12.4499 = 5048.95
  8. B = 21659.99 − 5048.95 = 16611.04

So after 12 payments, the remaining balance is $16,611.04. The total paid so far is 12 × 405.53 = $4,866.36, and the interest paid so far is $4,866.36 − ($20,000 − $16,611.04) = $1,477.40.

Assumptions

  • Fixed interest rate for the entire loan term
  • Payments are made monthly, at the end of each period
  • Interest compounds monthly at APR / 12
  • No late fees, prepayment penalties, or other charges are included
  • This calculator does not model variable rates, interest-only periods, or balloon payments

Why You Might Need This Number

Knowing your future loan balance is useful in several real situations. If you are considering selling the collateral—a car or a house—you need to know how much you still owe to figure out your equity. If you plan to pay off the loan early, the remaining balance is what you would need to pay to close it out (though some lenders may add a prepayment penalty, which is not included here).

Another common use is refinancing. When you compare a new loan offer, you need your current payoff amount, not the original balance. This calculator gives you that figure for any point in the loan’s life, assuming you have made every payment on time.

You might also want to track your progress. Many people are surprised that early payments go mostly toward interest. This calculator shows exactly how much principal you have paid off after a given number of months, which can help you understand your amortization schedule.

How to Use the Calculator Correctly

Enter the original loan amount, the annual interest rate (APR), the original term in years, and the number of payments you have already made. The calculator then gives you the balance right after that k-th payment. If you have made 12 payments, the balance shown is what you owe after the 12th payment, not before it.

Make sure you use the original loan amount and rate, not the current balance or a new rate. If you have missed payments or made extra payments, this calculator will not be accurate because it assumes exactly one payment per month at the calculated amount.

For a loan with a term in months rather than years, convert to years by dividing by 12 (e.g., 48 months = 4 years). The calculator’s years input accepts decimals, so 3.5 years is fine.

Common Mistakes and Misconceptions

  • Using the current balance as the principal – The formula needs the original loan amount. If you enter the current balance, the result will be wrong.
  • Confusing APR with the monthly rate – APR is annual; the formula divides by 1200 to get the monthly rate. Do not enter 0.0067 as the APR.
  • Forgetting that early payments are mostly interest – After 12 payments on a 5-year loan, you might have paid $4,866 total but only reduced the principal by $3,389. That is normal.
  • Assuming the balance drops linearly – It does not. The balance decreases slowly at first and faster later, because interest is calculated on the remaining balance.
  • Ignoring rounding – The monthly payment is rounded to cents in reality, which causes a tiny difference (usually less than a dollar) over the life of the loan. This calculator uses the rounded payment, so it matches a real amortization schedule closely.

Limitations of This Formula

This formula works only for fixed-rate, fully amortizing loans where every payment is the same amount and made on time. It does not apply to credit cards with revolving balances, interest-only loans, or loans with variable rates that change over time. If your loan has fees added to the balance, or if you made extra principal payments, the formula will not match your actual statement.

For adjustable-rate mortgages or student loans with changing rates, you would need a more complex model that recalculates the payment each time the rate changes. This calculator is a snapshot for a fixed-rate scenario only.

Frequently Asked Questions

What is the difference between remaining balance and payoff amount?
The remaining balance is the principal still owed. The payoff amount is what you must pay to close the loan on a specific date, which may include accrued interest since your last payment, plus any prepayment penalty or fees. This calculator gives the remaining balance, not the payoff amount.

Can I use this for a mortgage?
Yes, for a fixed-rate mortgage with monthly payments. Enter the original loan amount, the APR, the original term (e.g., 30 years), and the number of payments made. The result is your principal balance, but it excludes escrow, taxes, and insurance, which are not part of the principal.

What if I make extra payments?
This calculator assumes you make exactly the required payment each month. If you make extra principal payments, your balance will be lower than what this calculator shows. You would need to enter the actual number of payments made, but even then, the formula would not account for the extra amounts. For that, use a separate extra-payment calculator.

Why does the balance seem high after a year?
Because in the early years of a loan, a large portion of each payment goes toward interest. For a $20,000 loan at 8% for 5 years, after 12 payments you have paid $4,866 but only reduced the principal by $3,389. That is how amortization works—interest is front-loaded.

Does this work for a loan with a different payment frequency?
No. The formula assumes monthly payments. If you make biweekly payments or quarterly payments, the interest compounding and payment schedule change, so the result would not be accurate.

Is the result exactly what my lender will show?
It should be very close, within a few cents, if your loan is fixed-rate and you have made every payment on time. However, lenders may round differently or include small fees, so your statement is the final authority.

This calculator gives an estimate based on standard amortization math; your lender’s disclosure provides 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 paid | Total paid so far | $ | (p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * k | 2
out int | Interest paid so far | $ | (p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * k - (p - (p * (1 + apr / 1200) ^ k - (p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * ((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

The whole Loan payments section →