Loan Balance Calculator: Estimate What You Still Owe

A loan balance calculator estimates how much principal remains after a chosen number of payments on a fixed-rate, level-payment loan. Enter the original loan amount, annual percentage rate (APR), term, and number of monthly payments made to see the estimated remaining balance and the payment amount used in the calculation.

Formula

The calculator finds the balance after k monthly payments by growing the original principal with monthly interest, then subtracting the accumulated value of the payments already made:

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

• B is the estimated remaining balance, in dollars.
• P is the original amount borrowed, in dollars.
• r is the monthly interest rate as a decimal: APR ÷ 1,200.
• k is the number of monthly payments made.
• M is the monthly payment, rounded to cents using the standard fixed-payment formula: P × r ÷ (1 − (1 + r)⁻ⁿ).
• n is the scheduled number of monthly payments: years × 12.

The calculation assumes payments are made monthly and uses the rounded monthly payment in the balance formula. For example, an 8% APR is entered as 8, then divided by 1,200 to give a monthly rate of 0.0066667.

Worked Example

Using the calculator’s defaults: a $20,000 loan, 8% APR, a five-year term, and 12 payments made.

1. Convert APR to a monthly rate: r = 8 ÷ 1,200 = 0.0066667.
2. Find the scheduled payment count: n = 5 × 12 = 60 months.
3. Calculate the level payment: M = 20,000 × 0.0066667 ÷ (1 − (1 + 0.0066667)⁻⁶⁰), which rounds to $405.53 per month.
4. Apply the balance formula after 12 payments: B = 20,000(1.0066667)¹² − 405.53 × ((1.0066667)¹² − 1) ÷ 0.0066667.

The estimated balance is $16,620.28. This is an estimate based on the rounded payment and stated assumptions; an actual lender balance may differ because of payment dates, rounding, fees, or loan terms.

Assumptions

• The interest rate stays fixed throughout the modeled term.
• Payments are equal, monthly, and made at the end of each monthly period.
• Interest accrues monthly at APR divided by 12, with no separate daily-interest adjustment.
• The calculation excludes fees, taxes, insurance, private mortgage insurance, escrow, late charges, and extra payments.

When to Use a Loan Balance Calculator

Use a balance estimate to understand how scheduled payments reduce principal over time, compare the result with a statement, or explore how far into a repayment schedule a particular balance might occur. It can also provide a starting figure when reviewing a possible payoff amount, but it is not a payoff quote: interest can accrue between the calculation date and the date funds are received, and a lender may include other amounts.

Enter the original amount borrowed, not the total of all scheduled payments. Use the APR stated for the loan, expressed as a percentage rather than a decimal: enter 8 for 8%, not 0.08. The term should represent the original scheduled repayment period. Payments made means completed monthly installments; it does not mean the number of months since borrowing if payments were skipped, deferred, or made on a different schedule.

How to Read the Result

The remaining balance is an estimate of principal and accrued interest under the model, not necessarily the exact amount required to close the loan today. The monthly payment shown is calculated from the entered principal, APR, and term. The scheduled payment count is the total number of installments in the original term; it is not the number already paid.

At the start of a standard amortizing loan, a larger share of each payment generally goes to interest because the balance is higher. As principal falls, the interest portion typically falls and more of a level payment reduces principal. This is why paying 12 installments does not usually mean that one-fifth of a five-year loan has been paid off: payment portions are not all principal.

Common Sources of Differences

• Extra or missed payments: Additional principal payments can lower the balance faster, while missed or delayed payments can alter interest and repayment timing. This calculator assumes every scheduled payment is made as modeled.
• Variable rates: If the rate changes, one APR cannot represent the whole repayment history. A calculation would need the rate and payment history for each period.
• Rounding: Lenders may round interest or payments differently or calculate interest daily. Small differences can accumulate over many installments.
• Fees and bundled costs: Charges, escrow, taxes, or insurance can appear in an actual monthly bill without reducing the loan principal. They are not included here.
• Wrong payment count: The count should match completed installments, from zero through the scheduled term. For this five-year example, 60 is the final scheduled payment count.

A common misconception is that the balance equals the original loan minus the amount of principal payments inferred from total payments. Each payment includes interest, so the principal reduction is smaller than the full payment amount, especially earlier in repayment.

Frequently Asked Questions

How do I calculate my loan balance after payments?
Convert the annual APR to a monthly decimal rate, calculate the fixed monthly payment for the term, then apply the balance formula for the number of installments made. The calculator performs these steps using its stated monthly-payment assumptions.

Does the loan balance include interest?
This estimate reflects the modeled amortization balance, which accounts for interest accruing between monthly payments. It does not necessarily include interest accrued since the last payment or other amounts a lender may include in a current payoff figure.

Can I use this for a variable-rate loan?
Only as a rough estimate if the rate has changed. The formula assumes one fixed APR for all periods; a more accurate calculation would need each rate change and the actual payment history.

Why is my lender’s balance different?
Possible reasons include daily interest calculations, payment timing, rate changes, extra or missed payments, fees, and different rounding. Check the loan statement or ask the lender for the balance calculated for a specific date.

Is the remaining balance the payoff amount?
No. A payoff amount may account for interest through a particular date and other contract-specific amounts. Request an official payoff figure from the lender when an exact amount is needed.

This result is an estimate for educational purposes, and the lender’s disclosure gives the exact figures.

Related

• Trade-In Value: How to Estimate Your Car’s Equity
• Trade In a PC for a New PC? Compare the Costs
• Trade-In Value: Estimate Your Vehicle’s Trade-In

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 | - | 12 | 0 | 600
out bal | Remaining loan balance | $ | p * (1 + apr / 1200) ^ k - (round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2)) * ((1 + apr / 1200) ^ k - 1) / (apr / 1200) | 2
out pmt | Monthly payment | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out n | Scheduled payments | - | yrs * 12 | 0