Loan Balance Formula: Calculate What You Still Owe

The loan balance formula calculates the principal still owed after a specified number of payments, using the original loan amount, periodic interest rate, payment amount, and payments already made. Enter the loan amount, APR, term, and number of monthly payments made to estimate the remaining balance and see how the calculation works.

Formula

For a fixed-rate loan with equal monthly payments, the balance after k payments is:

B_k = P(1 + r)^k − M × [(1 + r)^k − 1] / r

• B_k is the outstanding balance after the payments, in dollars.
• P is the original amount borrowed, in dollars.
• r is the monthly interest rate as a decimal: APR ÷ 1200.
• k is the number of monthly payments already made.
• M is the fixed monthly payment, in dollars.

The payment for a fully amortizing loan is calculated as M = P × r / [1 − (1 + r)⁻ⁿ], where n is the total number of monthly payments. The calculator’s provided block calculates the scheduled monthly payment and total scheduled interest from the loan amount, APR, and term. It does not ask how many payments have been made, so its outputs are payment and total interest—not a specific current balance. To use the balance formula, you also need the payment count and the actual payment amount.

Worked Example

Using the calculator’s defaults—$20,000 borrowed, 8% APR, and a five-year term—the loan has 60 scheduled monthly payments. The monthly rate is 8 ÷ 1200 = 0.0066667.

1. Calculate the payment: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = $405.53 per month, rounded to cents.
2. Calculate total payments using that rounded payment: $405.53 × 60 = $24,331.80.
3. Subtract the amount borrowed: $24,331.80 − $20,000 = $4,331.80 total interest.
4. For illustration, after 12 payments, substitute k = 12 and M = $405.53 into the balance formula: $20,000 × (1.0066667)¹² − $405.53 × [(1.0066667)¹² − 1] ÷ 0.0066667 ≈ $16,448.67 remaining.

The balance example uses the same default loan and payment, but it is an additional calculation: the provided calculator block does not output that balance. Small differences can result if a lender uses a different payment schedule, rounding method, or interest calculation.

Assumptions

• The interest rate stays fixed for the full term.
• Payments are equal, made monthly, and applied at the end of each monthly period.
• Interest compounds monthly at APR divided by 12.
• Fees, taxes, insurance, PMI, and escrow are not included. The calculator assumes no extra payments, missed payments, or changes to the schedule.

How the Balance Changes

Each payment first covers the interest accrued for that period; whatever remains reduces principal. At the start of a conventional amortizing loan, the balance is relatively large, so more of each payment goes to interest. As principal falls, the interest portion generally falls too, leaving more of the same payment to reduce principal.

The balance formula represents that process in one expression. The first term, P(1 + r)^k, grows the initial principal as if interest accrued over the elapsed periods. The second term accounts for the accumulated value of payments made along the way. Subtracting it leaves the modeled amount still owed.

At zero interest, the expression involving division by r is not usable as written. The zero-interest balance is instead B_k = P − kM, provided the scheduled payments and payment count are consistent. The calculator’s APR minimum is 0.01%, so it avoids a zero-rate input; real loan calculations should follow the lender’s stated method.

When to Use It and What It Shows

A balance estimate can help explain amortization, check a schedule, or provide a rough figure for a particular point in a loan’s term. Use the number of payments actually completed, not simply the number of months since borrowing: the first payment may not fall exactly one month after the loan is issued, and a deferred first payment changes elapsed interest.

To estimate a balance accurately, gather the original principal, the applicable interest rate, actual monthly payment, number and timing of payments, and any extra principal payments or missed payments. If the rate changed, the simple fixed-rate formula is not enough; calculate each period using the applicable rate and payment history or consult the lender’s payoff information.

A balance is also not necessarily the same as the amount needed to close a loan on a particular date. A payoff figure may account for interest accrued since the latest payment and other contract-specific items. The calculator is for arithmetic estimates and does not reproduce a lender’s account ledger.

Common Mistakes and Limits

• Using APR as the monthly rate: Convert a percent APR to a monthly decimal by dividing by 1200. For 8% APR, the monthly rate is about 0.0066667—not 8 or 0.08.
• Mixing payment periods: This version assumes monthly payments and a monthly rate. A balance after 24 payments means 24 completed monthly periods, not 24 years or an arbitrary number of days.
• Using the original payment after changes: Extra payments, skipped payments, payment changes, or a variable rate can make the scheduled-payment model differ from the real balance.
• Rounding every intermediate step: Keep adequate precision during calculation and round the final displayed dollar amount to cents. Actual servicing systems may use their own rounding conventions.
• Confusing interest with principal reduction: A payment is not necessarily all principal. Early payments on an interest-bearing amortizing loan include interest, so subtracting the full payment from the original balance gives the wrong result.

The payment and interest outputs in this calculator are derived from the entered amount, APR, and term. They do not include fees or predict a lender’s accounting treatment. Rates and other loan details should be taken from the relevant lender disclosure, rather than assumed from this example.

Frequently Asked Questions

What is the formula for remaining loan balance?
For a fixed monthly rate, use B_k = P(1 + r)^k − M[(1 + r)^k − 1] ÷ r. Here, P is principal, r is the monthly decimal rate, k is payments made, and M is the monthly payment.

How do I calculate my loan balance after 12 payments?
Use the loan’s principal, monthly rate, and actual scheduled payment in the balance formula, with k = 12. Include any extra or missed payments separately; the basic formula assumes the same payment was made each month.

Is loan balance the same as principal?
Not necessarily. The outstanding balance is the amount remaining under the loan’s accounting method. Principal is the amount borrowed or the unpaid principal portion; accrued interest and payoff adjustments can make a dated payoff figure different from unpaid principal.

Why does my lender’s balance differ from this estimate?
Possible reasons include payment dates, daily rather than monthly interest calculations, rounding, rate changes, fees, extra payments, or a payoff quote that includes accrued interest. Compare the calculator’s assumptions with the loan statement or disclosure.

Does the formula work for a variable-rate loan?
Not as a single fixed-rate calculation across the whole term. A variable rate requires accounting for the rate and payment applicable in each period, along with the dates those changes take effect.

This result is an estimate; the lender’s disclosure gives the exact figures.

Related

• Used Vehicle Trade-In Value: Estimate Your Offer
• TT Trade-In Value Calculator and Guide
• Used Car Trade-In Value: How to Estimate It

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
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2