Loan Balance After Payment: Calculate What Remains

This calculator estimates the remaining balance after a set number of monthly payments on a fixed-rate loan. Enter the original loan amount, APR, loan term, and payments already made to see the estimated balance still owed.

Formula

The block calculates the scheduled monthly payment and total interest for a fully amortizing loan. To calculate the balance after a particular number of payments, use the balance formula below; the block does not take payment count as an input, so its outputs describe the full scheduled term rather than a selected point in it.

Let the monthly rate be r = APR / 1200, the number of scheduled payments be n = years × 12, the original principal be P, and the monthly payment be M. The payment formula is:

M = round(P × r / [1 − (1 + r)⁻ⁿ], 2)

After k monthly payments, the theoretical remaining balance is:

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

• P: original principal, in dollars.
• APR: annual percentage rate entered as a percentage, such as 8 for 8%.
• r: monthly interest rate as a decimal; APR divided by 1,200.
• n: full term in monthly payments.
• M: monthly payment, in dollars, rounded to cents.
• k: number of payments already applied; use a whole number from zero through the scheduled term.
• B_k: estimated balance after payment k, in dollars.

The balance equation assumes each payment is the same, arrives at the end of its monthly period, and is applied according to the stated interest model. For practical estimates, round the resulting balance to cents. A real lender’s balance can differ because of payment dates, daily interest accrual, rounding methods, fees, or extra transactions.

Worked Example

Using the calculator’s default values: P = $20,000, APR = 8%, and a five-year term. The monthly rate is 8 ÷ 1,200 = 0.0066667, and the scheduled term is 5 × 12 = 60 payments.

1. Calculate the payment: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = approximately $405.53 after rounding to cents.
2. Calculate the calculator’s total interest using that rounded payment: ($405.53 × 60) − $20,000 = $4,331.80.
3. For an illustration of a balance partway through the term, after 12 payments: $20,000 × (1.0066667)¹² − $405.53 × [(1.0066667)¹² − 1] ÷ 0.0066667 ≈ $16,507.29.

The calculator’s first result is the monthly payment, not a balance after a selected payment count. The example’s $16,507.29 is a separate application of the balance formula, showing how to estimate a balance after 12 payments.

Assumptions

• The interest rate is fixed for the modeled term.
• Payments are equal monthly installments, made at the end of each payment period.
• Interest compounds monthly using APR divided by 12.
• The estimate excludes fees, taxes, insurance, PMI, escrow, late charges, and extra or missed payments.

How a Payment Changes the Balance

A loan payment usually covers interest accrued for the period first, then reduces principal with whatever remains. Early in a level-payment loan, the balance is relatively large, so the interest portion is generally larger. As principal is repaid, the interest portion tends to shrink and more of each scheduled payment goes toward principal.

For example, at the start of the default loan, one month’s modeled interest is $20,000 × 0.0066667, or about $133.33. From the $405.53 payment, about $272.20 therefore reduces principal. Later installments have a different split because the balance has changed. This is why subtracting the entire payment from the original amount does not give the correct remaining balance.

“Balance after payment” can also mean different amounts on a lender’s account: principal outstanding, a statement balance, or a payoff amount through a particular date. A payoff figure may include accrued interest since the last payment and other items not represented by the simple amortization estimate. Check the lender’s current account information when an exact figure is needed.

When to Use the Estimate

This calculation is useful for understanding a fixed-payment loan’s amortization, checking an approximate remaining principal, or comparing a formula estimate with a statement. The calculator supplies the scheduled payment and total interest for the full term. To estimate a balance after k payments, insert those values into the balance equation using the actual payment count and the assumptions described above.

For a loan with an original amount of $20,000, the balance immediately after zero payments is $20,000. After each payment, the modeled balance falls as principal is repaid. At the end of the full amortizing schedule, it should be approximately zero, subject to rounding. If the balance formula produces a small negative value at the end, that can be a rounding artifact; real contracts may adjust the final payment.

The payment and total-interest results are estimates, not a statement of what a lender will collect. Use the APR and original principal from the loan documents, and verify the payment schedule and current balance with the servicer or lender. If the interest rate changes, payments are irregular, or the loan has a different compounding convention, this fixed-rate estimate may not match the account.

Common Calculation Mistakes and Limits

• Mixing percentage and decimal rates: Enter 8 for an 8% APR. The formula converts it to a monthly decimal by dividing by 1,200.
• Counting payments incorrectly: A five-year monthly schedule has 60 payments. The number made is not necessarily the number of months since the loan began if payments were delayed or skipped.
• Subtracting payments from principal: Part of each payment covers interest, so the principal balance does not fall by the full payment amount.
• Ignoring payment timing: Interest may accrue daily in an actual account, and the date a payment posts can affect accrued interest.
• Assuming all balances mean payoff: A payoff amount can differ from principal outstanding because it may account for interest through a specified date and other contract items.

The formula is designed for level monthly payments on a fixed-rate, fully amortizing loan. It does not model variable rates, interest-only periods, balloon payments, payment holidays, fees financed into the balance, or irregular additional principal payments. A lender’s disclosure and account records govern the actual figures for that loan.

Frequently Asked Questions

How do I calculate my loan balance after a payment?
Use the amortization balance formula with the original principal, monthly rate, scheduled monthly payment, and total number of payments made. The payment must cover interest and principal under the assumed schedule.

Does the whole payment reduce my loan balance?
No. The interest due for the period is generally covered first, and the remainder reduces principal. The exact allocation depends on the loan terms and payment timing.

Why is my lender’s balance different from this estimate?
Possible reasons include daily rather than monthly interest accrual, posting dates, rounding, fees, extra payments, or a rate or payment schedule that differs from the assumptions. Compare the estimate with the lender’s account details.

Is the loan balance the same as the payoff amount?
Not necessarily. A payoff amount may include interest accrued after the latest payment and other amounts specified by the lender for a particular payoff date. Request a dated payoff figure when precision matters.

Can I use this for a variable-rate loan?
Not accurately across periods in which the rate changes. The formula assumes one fixed APR throughout. A changing rate requires recalculating the schedule for each applicable period using the loan’s terms.

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

Related

• Trade In an Old Laptop for a New One?
• Trade In an Old Phone: Value, Steps, and Alternatives
• Trade In an Old iPhone: Options, Value and Steps

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 int | Total interest | $ | pmt * yrs * 12 - p | 2