Loan Balance After n Payments: Formula and Calculator

Calculate a loan’s balance after n payments by applying the monthly interest rate for n periods and subtracting the value of those payments. Enter the original loan amount, APR, term, and number of payments made to estimate the remaining principal under a fixed-rate, monthly-payment schedule.

Formula

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

B_n = P(1 + r)ⁿ − M × [(1 + r)ⁿ − 1] / r

• B_n is the remaining principal after payment n, in dollars.
• P is the original principal, in dollars.
• r is the monthly interest rate as a decimal, calculated here as APR ÷ 1,200.
• n is the number of monthly payments already made.
• M is the fixed monthly payment, in dollars. This calculator first derives it from the loan amount, APR, and term, then rounds it to cents.

The payment calculation is M = round[P × r ÷ (1 − (1 + r)^−N), 2], where N is the full number of scheduled payments: loan term in years × 12. The balance formula assumes the same rounded payment is made each month. Enter n directly in the calculator; it represents payments completed, not the original loan term.

Worked Example

Using the calculator’s default loan amount of $20,000, APR of 8%, and five-year term:

1. Convert the annual percentage rate to a monthly decimal: r = 8 ÷ 1,200 = 0.0066667.
2. Find the number of scheduled payments: N = 5 × 12 = 60.
3. Calculate and round the monthly payment: M = round[$20,000 × 0.0066667 ÷ (1 − (1.0066667)⁻⁶⁰), 2] = $405.53.
4. For a concrete balance, take the result after 12 payments. Substitute P = $20,000, r = 0.0066667, n = 12, and M = $405.53 into the balance formula. The estimated remaining balance is $16,464.23.
5. Payments made total 12 × $405.53 = $4,866.36. The principal repaid is $20,000 − $16,464.23 = $3,535.77, so the estimated interest paid is $1,330.59.

The calculator’s “Balance after n payments” output is the main result: set n to the actual count of completed payments. The example uses 12 to demonstrate the calculation; it is not an additional input default.

Assumptions

• The interest rate is fixed for the calculation period.
• Payments are equal, made monthly, and applied at the end of each monthly period; the first payment follows one month of interest accrual.
• Interest compounds monthly at APR ÷ 12. The APR input is expressed as a percentage per year.
• The estimate excludes fees, taxes, insurance, PMI, escrow, late charges, and other costs because they are not calculator inputs.
• No extra payments, skipped payments, rate changes, or payment-date adjustments are modelled.

How the Balance Changes

Each payment covers the interest accrued for that period first; whatever remains reduces principal. Early in a typical amortizing schedule, the outstanding principal is larger, so more of a payment goes to interest. As principal declines, the interest portion generally falls and more of each unchanged payment goes toward principal. The balance is therefore not simply the original loan minus the total amount paid.

For example, after 12 payments in the worked example, $4,866.36 has been paid, but the principal has fallen by only $3,535.77. The difference, $1,330.59, is the estimated interest paid under the model. This distinction matters when estimating payoff amounts or tracking progress: total payments and principal reduction are different quantities.

Using the Result Carefully

Use the output as an estimate of scheduled principal remaining after the selected number of payments. For the balance formula to apply, n should be a whole number from zero through the scheduled number of payments. At zero payments, the formula returns the original principal. After the last scheduled payment, a fully amortizing loan should be close to zero, subject to cent rounding and the lender’s actual payment schedule.

• Enter the loan’s original principal, not the total of all scheduled payments.
• Enter APR as a percent: for example, enter 8 for 8%, not 0.08 or 8 in a decimal-rate field.
• Count payments that have actually posted. A payment due or pending may not yet have reduced the account balance.
• Use the contractual term in years. The calculator converts it to months to determine the scheduled payment.
• Compare the estimate with a recent statement or payoff quote when an exact account figure is needed; the balance on a particular date can differ because of timing and accrued interest.

Limits and Common Misunderstandings

This formula represents a standard level-payment, fixed-rate amortizing loan. It may not match a loan with a variable rate, irregular payment dates, interest-only periods, a balloon payment, deferred interest, or a different compounding convention. Extra principal payments change the schedule: if you made them, the estimate based only on the standard payment will generally not reflect that additional reduction. Fees and other amounts included in an account payoff are also outside this principal-balance calculation.

A common mistake is to subtract all payments from principal as if none went to interest. Another is to use the annual APR directly as the monthly rate; this formula divides the percentage APR by 1,200 to get a monthly decimal. Rounding also matters: the calculator rounds its derived payment to cents and then uses that amount in the balance formula, while a lender’s system may handle individual periods and a final adjustment according to its own schedule.

Frequently Asked Questions

How do I calculate a loan balance after n payments?
Convert APR to a monthly decimal, calculate the scheduled monthly payment, and use B_n = P(1 + r)ⁿ − M[(1 + r)ⁿ − 1] ÷ r. Here, n is the number of payments made.

Does n mean the number of months or payments?
For a monthly-payment loan, they are the same count: one payment per month. Enter the number of completed payments, not the number of payments remaining.

Is the loan balance the same as the payoff amount?
Not necessarily. This calculation estimates remaining principal. A payoff figure may account for interest accrued through a particular date or other amounts not modelled here, so request the applicable figure from the lender.

How do extra payments affect the balance?
An extra payment applied to principal generally reduces principal faster than the standard schedule assumes. This calculator does not track extra payments, so its result may not match a loan with additional principal reductions.

Why is the balance not the original loan minus payments made?
Because each scheduled payment covers interest as well as principal. Only the principal portion reduces the loan balance; the split changes over the amortization schedule.

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

Related

• AT&T Trade-In Program: How It Works and What to Know
• Trade-In Value: Calculate Your Loan Equity
• Trade-In Value and Loan Calculator

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 | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out bal | Balance after n payments | $ | p * (1 + apr / 1200) ^ n - pmt * ((1 + apr / 1200) ^ n - 1) / (apr / 1200) | 2
out int | Total interest paid | $ | pmt * n - (p - bal) | 2