How to Calculate Loan Balance After Payments

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

Formula

The balance after a set number of regular payments is the original principal grown by monthly interest, minus the accumulated value of the payments made:

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

• B is the estimated remaining balance in dollars.
• P is the original loan principal in dollars.
• r is the monthly interest rate as a decimal, calculated as APR ÷ 1,200.
• k is the number of monthly payments counted.
• M is the monthly payment in dollars, rounded to the nearest cent.

The calculator uses a level-payment formula to find M from the loan amount, APR, and term. It counts the full monthly payments in the entered term, using the whole-number part of years × 12. For example, 2.5 years means 30 payments. This setup estimates the balance after all scheduled payments for the entered term; it does not provide a separate input for an earlier payoff date.

Worked Example

Using the calculator’s default values: principal P = $20,000, APR = 8%, and term = 5 years.

1. Convert the annual percentage rate to a monthly decimal: r = 8 ÷ 1,200 = 0.0066667.
2. Find the number of monthly payments: k = 5 × 12 = 60.
3. Calculate the level monthly payment: M = 20,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)⁻⁶⁰] = $405.53, rounded to cents.
4. Apply the balance formula: B = 20,000 × (1 + 0.0066667)⁶⁰ − 405.53 × [(1 + 0.0066667)⁶⁰ − 1] ÷ 0.0066667.
5. The estimated balance after 60 payments is $0.00 when rounded to cents. The calculator also reports the monthly payment as $405.53 and the payment count as 60.

Because the payment is rounded to cents, a real account can have a small residual amount or a slightly adjusted final payment. The example’s displayed balance is rounded to two decimal places.

Assumptions

• The interest rate is fixed for the full term.
• Payments are equal, monthly, and made at the end of each period.
• Interest is compounded monthly at APR divided by 12.
• The model excludes fees, taxes, insurance, PMI, escrow, late charges, and other account adjustments.
• It assumes each scheduled payment is made in full and on time, with no extra payments.

What You’ll Need

• The original principal, not the amount you still owe today.
• The loan’s annual percentage rate (APR), expressed as a percentage.
• The full loan term in years.
• Your lender’s payment history if you need a balance for a particular date. This calculator uses the term’s full payment count, so it cannot substitute an arbitrary number of payments.

Step-by-Step

1. Find the original loan amount. Use the principal shown in the loan documents. If the amount financed included charges, use the principal on which interest is actually calculated, as stated by the lender.
2. Enter the APR. Use the fixed APR in the loan disclosure, not a monthly rate. If the rate changes over time, this fixed-rate estimate will not reproduce the actual account balance.
3. Enter the original term. Convert the full repayment period to years if needed. The calculator treats a year as 12 monthly periods and counts whole payments.
4. Read the estimated monthly payment. The payment is calculated from the principal, rate, and term and rounded to cents. Compare it with the scheduled principal-and-interest payment on your statement; differences may indicate that the assumptions do not match your loan.
5. Read the balance result. The first output is the estimated balance after the payment count shown. For this calculator, that count is the full term in months. A result near zero at the end of the term is expected under the model.
6. For an actual current balance, check the lender’s records. A statement or payoff quote accounts for the date, payment posting, accrued interest, and account-specific adjustments. Do not treat this estimate as a payoff amount.

Common Mistakes

• Entering a monthly rate as an APR: The APR field expects a yearly percentage such as 8, not 0.6667. The formula divides the annual percentage by 1,200.
• Using the amount currently owed as the original principal: The formula needs the starting principal. Substituting a current balance creates a different hypothetical loan calculation.
• Mixing years and months: The term field is in years. Entering 60 to mean 60 months would be interpreted as 60 years.
• Assuming every loan has monthly level payments: Variable-rate loans, interest-only periods, irregular payment schedules, and loans with changing installments need a different calculation.
• Rounding too early: Keep the displayed APR and payment assumptions intact. Rounding the monthly rate or intermediate values manually can shift the estimate.
• Confusing balance with payoff amount: A payoff figure can include interest through a specific date and other account items not represented here.

Tips

• Copy the APR, principal, and term directly from current loan documents rather than relying on memory.
• Check whether the stated APR and payment schedule match the calculator’s fixed-rate, monthly-payment assumptions.
• Use the result as a planning estimate, then ask the lender or servicer for the balance on a specific date.
• When reviewing your statement, distinguish principal-and-interest payments from taxes, insurance, or escrow amounts.
• Keep a record of the date and figures used so you can reproduce an estimate later.

Troubleshooting

The estimated payment differs from the statement: Confirm the original principal, APR, term, and payment frequency. Check whether the actual payment includes fees or escrow, or whether the loan has a variable rate or unusual schedule.

The balance is not what you currently owe: This calculator applies payments over the full term; it does not accept the number of payments made so far. A current balance requires the actual payment history and timing. Request the current principal balance or a dated payoff quote from the lender.

The result is slightly above or below zero at the end: Cent rounding, payment posting conventions, or a final-payment adjustment can cause a small difference. The lender’s amortization schedule is the reference for the contractual account balance.

Your rate changed or you made extra payments: The fixed-rate level-payment formula no longer describes the full history. Use the lender’s transaction records or a calculation that models each rate period and payment separately.

Frequently Asked Questions

How do I calculate the remaining balance on a loan?
Use the original principal, monthly rate, number of payments made, and scheduled payment in the balance formula. This calculator shows the formula-based estimate for the full term entered.

Is APR the same as the monthly interest rate?
No. This calculator converts APR to a monthly rate by dividing the percentage by 1,200. Loan disclosures may use conventions that differ from this simplified monthly model.

Can I use this to find my payoff amount today?
No. A payoff amount is date-specific and may include accrued interest or other account adjustments. Ask the lender for an official payoff quote.

Why does the result not match my loan statement?
Possible reasons include a rate change, payment timing, extra or missed payments, fees, rounding, or a payment schedule other than equal monthly installments.

Does this work for a variable-rate loan?
Only as a simplified estimate for a period when the rate is fixed. To model a rate that changes, calculate each period using its actual rate and payment history.

What does a zero balance at the end mean?
It means the formula’s scheduled payments repay the modeled principal and interest by the end of the entered term, after rounding. The lender’s records determine the actual final amount.

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

Related

• Trade in Retail: Meaning, Process, and Examples
• Trade-In Quote Calculator: Estimate Your Loan Balance
• Trade In PS5: How It Works and What to Check

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 bal | Balance after payments | $ | p * (1 + apr / 1200) ^ floor(yrs * 12) - round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) * ((1 + apr / 1200) ^ floor(yrs * 12) - 1) / (apr / 1200) | 2
out pmt | Monthly payment | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out k | Payments counted | - | floor(yrs * 12) | 0