Balance Charges: Calculate a Loan Balance Step by Step

This loan balance calculator estimates how much principal remains after a set number of monthly payments. Enter the original loan amount, APR, term, and payments already made to see the estimated balance and payment amount. It assumes a fixed rate and regular monthly payments.

Formula

The balance after a number of level monthly payments is the original principal grown at the monthly rate, minus the accumulated value of the payments made:

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

• B_k is the estimated remaining balance, in dollars.
• P is the starting loan principal, in dollars.
• r is the monthly interest rate, calculated as APR ÷ 1,200. APR is entered as a percentage per year.
• k is the number of monthly payments made.
• M is the scheduled monthly payment, rounded to the nearest cent.

The monthly payment is calculated using the standard fixed-payment formula: M = round(P × r / (1 − (1 + r)⁻ⁿ), 2), where n is the total number of monthly payments, or loan term in years × 12. Rounding the payment to cents before calculating the balance reflects how a regular payment is typically expressed; an actual lender may use different rounding or payment-allocation practices.

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 monthly payment: M = round(20,000 × 0.0066667 ÷ (1 − (1.0066667)⁻⁶⁰), 2) = $405.53.
4. Apply the balance formula after 12 payments: B₁₂ = 20,000 × (1.0066667)¹² − 405.53 × ((1.0066667)¹² − 1) ÷ 0.0066667.
5. The estimated balance is $16,435.09 after rounding to cents.

Assumptions

• The interest rate is fixed throughout the modeled term.
• Payments are equal, made monthly, and applied at the end of each month.
• Interest compounds monthly at APR ÷ 12.
• The calculation excludes fees, taxes, insurance, PMI, escrow, late charges, extra payments, and other account adjustments.

What You’ll Need

• The original principal shown on the loan paperwork.
• The annual percentage rate (APR) as a percentage, not a decimal.
• The scheduled loan term in years.
• The number of regular monthly payments already made. Enter zero if none have been made.
• Your lender’s current statement if you need the actual payoff or account balance; this calculator provides an estimate.

Step-by-Step

1. Confirm the starting principal. Use the amount borrowed, rather than the total of all scheduled payments. If the loan has already been modified or refinanced, use the principal and terms for the current agreement.
2. Enter the APR. Type the annual rate as a percentage—for example, enter 8 for 8%. Do not type 0.08, because the calculator converts a percent to a monthly decimal rate.
3. Enter the original term. Use the term in years from the loan agreement. This determines the scheduled monthly payment. If your agreement gives the term in months, divide it by 12 to enter years.
4. Count payments made. Enter completed scheduled monthly payments, not the number of months since the loan began if a payment was skipped or deferred. The formula models consecutive, equal payments.
5. Read the estimated remaining balance. The first result is the calculated balance after the entered number of payments. The monthly payment and total scheduled payment count appear as supporting figures.
6. Compare with your statement carefully. If the balance differs, check the payment count and terms first. Then compare the lender’s rate, payment amount, posting dates, and any additional charges or credits with the calculator’s assumptions.
7. For a precise payoff figure, request one from the lender. A payoff quote may include interest accrued since the last payment and other account-specific amounts that this calculation does not include.

Common Mistakes

• Entering APR as a decimal. Enter 8 for 8%, not 0.08. The latter is interpreted as 0.08%.
• Counting elapsed months instead of paid installments. A skipped, paused, or late payment changes the payment history, so simply counting calendar months may produce a misleading result.
• Using the total of payments as the principal. The principal is the amount borrowed or the current starting principal for the terms being modeled—not the sum of future installments.
• Expecting an exact statement or payoff amount. Daily interest, payment dates, fees, extra payments, and lender-specific rounding can make the real figure different.
• Mixing up term and payments made. The term sets the original scheduled payment; payments made determine how far through that schedule the balance calculation advances.

Tips

• Use the APR and scheduled payment shown in the same loan agreement or statement, and keep the APR in percentage form.
• For a useful comparison, recalculate with the exact number of installments actually posted—not merely payments sent.
• Keep unrounded values for intermediate hand calculations and round the final balance to cents. The displayed monthly payment is rounded to cents before the balance is estimated.
• If you have made extra payments or the rate changes, use your lender’s transaction history or a calculator designed to model those details; this formula assumes a fixed rate and equal payments.

Troubleshooting

The result is higher than expected: Verify that the APR was entered as a whole percentage and that the number of payments is correct. Early payments include more interest than principal under a standard amortizing schedule, so the balance may decline gradually at first.

The result does not match a statement: Check whether the statement balance is dated after a payment, whether the lender uses a different payment amount, and whether there were late or extra payments, rate changes, or fees. The calculator cannot reproduce account activity it does not ask you to enter.

The result is zero or negative: The entered payment count may exceed the original term. The formula is intended for payments within the scheduled term; check the term and count, and use the lender’s records for a loan that has been paid off or extended.

You need the amount to close the loan today: Do not treat the estimated balance as a payoff quote. Ask the lender for a dated payoff amount because interest can accrue between billing dates and account-specific items may apply.

Frequently Asked Questions

What does “balance a loan” mean here?
It means estimating the remaining principal on an amortizing loan after a specified number of regular monthly payments.

Is the result the amount I need to pay off the loan?
No. It estimates the remaining balance under the stated assumptions. Request a dated payoff quote from the lender for the amount required to close the account.

Can I use this for a variable-rate loan?
Only as a simplified estimate if you use one rate for the full period. The calculation does not model rate changes or their effect on payments.

Can I include extra payments?
Not directly. Extra payments change principal sooner than this equal-payment formula assumes, so use a transaction-based calculation or lender statement for a closer figure.

Why does my statement show a different balance?
Possible reasons include payment timing, daily interest, rounding, fees, missed or extra payments, or a different rate or payment history. Compare the inputs and ask the lender to explain account-specific differences.

Is the monthly payment exact?
It is calculated from the entered principal, APR, and term and rounded to cents. The lender’s payment schedule may differ because of contract details or rounding conventions.

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

Related

• Trade Vehicle Hire: Costs, Terms and How It Works
• Trade-In Vehicle Value Calculator: Estimate Your Equity
• Trade Plate Vehicle Movements: How They Work

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 | Loan balance after payments | $ | 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 | Total scheduled payments | - | yrs * 12 | 0