Loan Balance Equation: Formula and Calculator

The loan balance equation estimates the principal still owed after a specified number of regular payments. Enter the original loan amount, annual percentage rate (APR), term, and number of payments made; the calculator returns the scheduled monthly payment and total interest for the full term, while the balance formula below shows how to calculate the remaining amount.

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 estimated remaining balance, in dollars.
• P is the original principal, 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 regular monthly payment, in dollars.

The calculator’s payment formula is M = P × r / (1 − (1 + r)⁻ⁿ), where n is the total number of monthly payments, calculated as years × 12. Its total-interest result is the scheduled payment multiplied by the number of payments, minus the original principal. Payment is rounded to cents before that total is calculated.

Worked Example

Using the calculator’s exact defaults—$20,000 principal, 8% APR, and a 5-year term—the number of payments is 5 × 12 = 60. The monthly rate is 8 ÷ 1200 = 0.0066667.

1. Monthly payment: $20,000 × 0.0066667 ÷ (1 − (1 + 0.0066667)⁻⁶⁰) = $405.53 when rounded to cents.
2. Total scheduled payments: $405.53 × 60 = $24,331.80.
3. Total interest: $24,331.80 − $20,000 = $4,331.80.

To illustrate the balance equation after 12 payments, use P = $20,000, r = 0.0066667, k = 12, and M = $405.53. Substitution gives $20,000(1.0066667)¹² − $405.53 × ((1.0066667)¹² − 1) ÷ 0.0066667, or approximately $16,577.35. The balance is an estimate because the equation assumes the stated payment schedule and rate throughout.

Assumptions

• The interest rate stays fixed for the full term.
• Payments are equal, monthly, and made at the end of each monthly period.
• Interest accrues monthly at APR divided by 12.
• The calculation excludes fees, taxes, insurance, PMI, escrow, and any charges not included in the principal or APR input.

How the Loan Balance Equation Works

Each payment has two parts: interest accrued since the previous payment and principal repayment. At the start, the balance is larger, so a greater share of a level payment usually goes to interest. As principal falls, the interest portion tends to shrink and more of each payment reduces the balance. The equation captures this sequence by growing the original principal at the monthly rate and subtracting the accumulated value of payments.

The equation applies to a standard amortizing loan with regular payments. It is not simply the original amount minus payments made: that shortcut ignores interest. Nor does the remaining balance equal total future payments, because future payments include interest that has not yet accrued. The balance is principal still owed under the model, not the sum of every payment left on the schedule.

Using the Result and Choosing the Payment Count

The calculator reports payment and total interest for the full stated term; it does not request a payment count, so use the balance equation separately for a particular point in time. Set k to the number of payments that have actually posted. For example, if 18 monthly payments have cleared, use k = 18—not the number of calendar months since the loan began if the first payment was delayed or a payment was missed.

To estimate a balance after a whole number of years, multiply that number by 12 only when payments have been monthly and uninterrupted. For a payoff quote on a particular date, the lender’s figure can differ because of daily interest, payment processing dates, accrued interest, fees, or other account activity.

Common Problems and Limits

• APR units: Enter APR as a percentage, such as 8 for 8%, not 0.08. The formula divides the percentage by 1200 to obtain a monthly decimal rate.
• Term units: The input is in years, while the calculation uses years × 12 monthly periods. Do not enter months as years.
• Payment rounding: Real payment schedules generally use currency precision. Rounding can create a small difference from a formula that carries many decimal places throughout.
• Extra or missed payments: Extra principal payments, skipped payments, late payments, and payment changes alter the schedule. The standard equation does not model them.
• Rate changes: A variable rate or a period with a different rate requires separate calculations for each rate period; one fixed-rate equation cannot represent the whole history.

For a zero-interest loan, the balance after k equal payments is P − kM, subject to the loan’s payment schedule. The calculator requires a positive APR because its payment expression divides by the monthly rate. A balance estimate should not be treated as an account statement or an exact payoff amount.

Frequently Asked Questions

What is the loan balance equation?
The standard fixed-rate balance equation is B_k = P(1 + r)^k − M((1 + r)^k − 1) / r. It estimates principal remaining after k equal monthly payments.

How do I calculate a loan balance after 12 payments?
Use k = 12, the original principal, monthly rate (APR ÷ 1200), and the scheduled monthly payment in the balance equation. This assumes all 12 payments were made as scheduled.

Does the loan balance equation include interest?
Yes. It accounts for interest accruing on the unpaid balance and the effect of each payment. It does not automatically include separate fees, insurance, or other charges.

Why is my lender’s balance different from this estimate?
Possible reasons include payment timing, daily interest, rounding, a changing rate, extra payments, fees, or transactions after the date used in the estimate. The account’s exact figures come from the lender’s records.

Is the loan balance the same as the payoff amount?
Not necessarily. A payoff amount may account for interest accrued through a specified date and other amounts under the account terms, while this equation estimates the scheduled principal balance at a payment count.

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

Related

• Trade-In Value Calculator: Estimate Your Vehicle Equity
• Trade In an Old Laptop for a New One?
• Trade In an Old Phone: Value, Steps, and Alternatives

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