calculate-loan

01 Loan payments

Loan Amount Left Calculator: Find Remaining Balance

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

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

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 how much principal you still owe on a loan after a certain number of payments. You enter the original loan amount, the annual interest rate (APR), the loan term, and the number of payments already made; it returns your remaining balance, plus the amount of principal paid so far and the interest paid so far.

Formula

The remaining balance after k payments is calculated using the standard amortization formula:

Bk = P × (1 + r)k − PMT × [((1 + r)k − 1) / r]

Where:

  • Bk = remaining balance after k payments (in dollars)
  • P = original loan amount (principal, in dollars)
  • r = monthly interest rate = APR / 1200 (as a decimal, e.g., 8% APR → 0.006667)
  • k = number of payments already made
  • PMT = the level monthly payment = P × r / [1 − (1 + r)−n], where n is the total number of payments (years × 12)

The formula calculates how much your original principal has grown with interest over k months, then subtracts the accumulated value of all the payments you have made. The difference is what you still owe.

Worked Example

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

  1. Monthly rate: r = 8 / 1200 = 0.0066667
  2. Total payments: n = 5 × 12 = 60
  3. Monthly payment: PMT = 20000 × 0.0066667 / [1 − (1.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. Compute: (1.0066667)12 = 1.0829995
  6. First term: 20000 × 1.0829995 = 21659.99
  7. Second term: 405.53 × [(1.0829995 − 1) / 0.0066667] = 405.53 × 12.4499 = 5048.87
  8. Remaining balance = 21659.99 − 5048.87 = $16,611.12

So after one year of payments, you still owe about $16,611.12. The calculator shows the same result.

Assumptions

  • Fixed interest rate for the entire loan term (no rate changes).
  • Payments are made monthly, at the end of each month.
  • Interest compounds monthly at APR / 12.
  • All payments are exactly the required monthly amount, on time.
  • No extra fees, penalties, taxes, insurance, or other charges are included.

Why You Might Need This Number

Knowing your remaining balance is useful in several common situations:

  • Paying off a loan early: You want to know the payoff amount (though the lender will add any per-diem interest and fees).
  • Refinancing: You need your current balance to compare a new loan’s terms.
  • Selling an asset: If you sell a car or house, you need to know how much you owe to determine your net proceeds.
  • Budgeting: Tracking how much debt you still carry helps plan future finances.
  • Verifying lender statements: Checking your balance against the lender’s statement can catch errors.

This calculator gives the principal balance—the amount you borrowed that is still unpaid. The actual payoff amount from a lender may be slightly higher because interest accrues daily until the payment date.

How to Read the Result

The main output is the remaining balance. The two secondary outputs give context:

  • Principal paid so far = original loan amount minus remaining balance. This is the portion of the loan you have actually paid down.
  • Interest paid so far = total of all payments made minus principal paid. This shows how much of your early payments went to interest rather than principal.

In the example above, after 12 payments you have paid $405.53 × 12 = $4,866.36 total. Of that, $3,388.88 went to principal (20,000 − 16,611.12) and $1,477.48 went to interest. Early in a loan, a large share of each payment goes to interest; as the balance shrinks, more goes to principal.

Common Mistakes and Misconceptions

  • Using the simple interest formula: Some people compute balance as P − (payment × k). That ignores interest entirely and gives a number that is too low.
  • Mixing up APR and monthly rate: APR is annual; you must divide by 12 (and by 100 to get a decimal) before using it in the formula.
  • Counting payments from the wrong date: The number of payments made must be exact. If you made 13 payments, use 13, not 12.
  • Assuming the balance drops linearly: Because interest is front-loaded, the balance decreases slowly at first and faster later.
  • Forgetting rounding: The monthly payment is rounded to cents in real life. Using an unrounded payment in the formula gives a slightly different balance. This calculator uses the rounded payment to match real loans.

Limits of This Formula

This calculation works for fixed-rate, fully amortizing loans—where the payment is constant and the loan reaches zero at the end of the term. It does not apply to:

  • Adjustable-rate loans (where r changes over time)
  • Interest-only loans (where the payment does not reduce principal)
  • Balloon loans (where the final payment is much larger)
  • Loans with fees added to the balance or prepayment penalties

For those, the balance path is different. Also, if you have made extra payments, the formula above will not be accurate unless you adjust the payment amount. To handle extra payments, you would need a more detailed amortization schedule that recalculates each month.

Using This Calculator for Planning

You can use this tool to see how your balance changes over time. For example, enter 24 payments to see the balance at the halfway point of a 5-year loan, or enter 59 to see how much remains just before the final payment. This can help you understand how much equity you have in an asset or how much debt you would need to refinance.

To find out how many payments remain, you can compare the remaining balance to the original loan term. But if you want to know how many months are left given a specific payoff amount, you would use a different calculation—the number of periods needed to repay a balance with a given payment.

Frequently Asked Questions

How is the remaining balance different from the payoff amount?

The remaining balance is the principal you owe as of the last payment date. The payoff amount is what you must pay on a specific day to close the loan, which includes interest accrued since the last payment (per-diem interest) and sometimes a small processing fee. The payoff amount is usually a few dollars higher than the balance shown here.

Can I use this calculator for a mortgage?

Yes, if your mortgage has a fixed rate and you make regular monthly payments. However, mortgages often include escrow for taxes and insurance, which are not part of the loan balance. This calculator only looks at the principal and interest portion. For an adjustable-rate mortgage, the balance would differ because the interest rate changes.

What if I made extra payments?

This calculator assumes you made exactly the required monthly payment each month. If you made extra payments, your remaining balance will be lower than the result. To get an accurate number, you would need to recalculate the amortization schedule with the extra payments applied. Many lenders provide an online portal showing your current balance.

Why does the interest paid so far seem so high?

Because interest is calculated on the remaining balance, early payments are mostly interest. For example, in the default scenario, after 12 payments you have paid about $1,477 in interest, which is 30% of your total payments. This is normal for amortized loans; the interest portion decreases each month as the balance shrinks.

Does the remaining balance include fees or late penalties?

No. This calculation only covers principal and interest. Late fees, origination fees, insurance, or other charges are not included. If you have unpaid fees, the lender will add them to the payoff amount, making it higher than the balance shown here.

How do I find out my exact remaining balance?

The most reliable way is to check your latest loan statement or contact your lender. The lender’s statement shows the principal balance as of the statement date. For a payoff quote, you can request one from the lender; it will be valid for a specific period, usually 10 to 30 days.

This calculator gives an estimate based on the inputs you provide. Your lender’s statement or payoff quote gives the exact figures.

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 prin | Principal paid so far | $ | 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

The whole Loan payments section →