Calculate an estimate of your loan balance after a chosen number of monthly payments using the original loan amount, APR, term, and payments made. Enter the loan details to see the remaining principal, along with the scheduled monthly payment and total interest for the full term.
Formula
The balance after a specified number of payments is the original principal grown by monthly interest, minus the accumulated value of the payments already made:
B = P(1 + r)k − M × ((1 + r)k − 1) / r
- B is the estimated balance after payments, in dollars.
- P is the starting loan principal, in dollars.
- r is the monthly interest rate, calculated as APR ÷ 1,200 when APR is entered as a percentage.
- k is the number of monthly payments made.
- M is the scheduled monthly payment, in dollars, calculated from the principal, APR, and full term.
The scheduled level payment is M = P × r / (1 − (1 + r)−n), where n is the number of monthly payments in the full term (years × 12). The calculator uses that unrounded payment within the balance formula and displays results to the nearest cent. A lender’s actual payment schedule can differ because payments are generally rounded to cents and because contract details may differ.
Worked Example
Using the calculator defaults: a $20,000 principal, 8% APR, a five-year term, and 12 monthly payments made.
- Convert the annual percentage rate to a monthly decimal rate: r = 8 ÷ 1,200 = 0.0066667.
- Find the number of payments over the full term: n = 5 × 12 = 60.
- Calculate the scheduled monthly payment: M = 20,000 × 0.0066667 ÷ (1 − (1.0066667)−60) ≈ $405.53.
- Apply the balance formula after 12 payments: B = 20,000(1.0066667)12 − 405.53 × ((1.0066667)12 − 1) ÷ 0.0066667 ≈ $16,444.21.
- Calculate total scheduled interest over the full term using the displayed payment: $405.53 × 60 − $20,000 = $4,331.80.
The calculator’s balance expression uses the formula’s computed payment before display rounding, so tiny cent-level differences from an example using $405.53 in every intermediate step are possible.
Assumptions
- The interest rate remains fixed for the entire calculation.
- Payments are equal monthly payments made at the end of each monthly period.
- Interest accrues monthly at APR divided by 12.
- The estimate excludes fees, taxes, insurance, PMI, escrow, late charges, and other account adjustments.
When to Use an Up-to-Date Balance Estimate
A balance estimate is useful for understanding how scheduled payments reduce principal over time. You can compare the result at different payment counts to see the direction and pace of amortization, or use it as a planning figure when reviewing a loan statement. It is not a payoff quote: a payoff amount may include interest accrued since the last payment and other contract-specific amounts.
The result assumes payments follow the original schedule. If you have made extra principal payments, skipped or late payments, or had a rate change, enter the current principal and current terms if you know them—or use the account’s transaction history to work out the appropriate starting point. A loan statement or the servicer’s balance is the authoritative source for the account’s current figure.
How to Read the Result
“Balance after payments” is the model’s estimated principal remaining immediately after the number of scheduled payments entered. It does not mean the amount needed to close the loan on a particular date. For instance, the default example estimates about $16,444.21 after one year of payments, but a payoff figure on a different date may include additional accrued interest.
“Scheduled monthly payment” is the level payment implied by the entered principal, APR, and term. “Total scheduled interest” is the sum of those scheduled payments over the full term minus the starting principal. It is a full-term estimate, not the interest paid so far or an amount added to the current balance.
Common Balance Calculation Problems
- Confusing APR and a monthly rate: enter APR as an annual percentage, such as 8, not as 0.08 or a monthly rate. The calculator converts it to a monthly decimal.
- Using the wrong payment count: enter the number of payments actually made, not the number remaining. At zero payments, the modeled balance is the starting principal.
- Assuming an approximate result is a payoff quote: the estimate omits daily interest and account-specific charges or credits.
- Ignoring a variable rate or extra payments: a fixed-rate, equal-payment formula cannot reproduce a schedule that changes over time unless you recalculate from an updated balance and applicable terms.
- Expecting exact statement cents: lenders may round each payment’s interest and principal portions separately, while this formula uses the mathematical amortization result.
Limits and Related Calculations
This calculator models a standard amortizing loan: each regular payment covers interest due for the period and reduces principal, with the payment amount set to repay the loan over the stated term. It does not model interest-only periods, balloon payments, daily simple-interest methods, irregular payment dates, fees financed into the loan, or a changing APR. If any of those features apply, the remaining balance can differ materially from this estimate.
To estimate a balance at another point in the schedule, change the payment count. To examine the effect of a different APR or term, change those inputs while recognizing that the result is a new mathematical scenario, not a prediction of lender terms. For an exact current balance or payoff amount, check the latest statement or request a dated payoff figure from the loan servicer.
Frequently Asked Questions
Is the estimated balance the same as my payoff amount?
No. A payoff amount may include interest accrued through a specified date and other loan-specific adjustments not modeled here.
What should I enter for monthly payments made?
Enter the number of scheduled monthly payments that have already posted. If you have made extra or irregular payments, this standard schedule will not fully reflect them.
Why does my statement differ by a few cents?
Payment rounding, the dates interest accrues, and the lender’s posting method can create small differences. A variable rate or account adjustments can create larger ones.
Can I use this for a variable-rate loan?
Only as a fixed-rate snapshot. The formula assumes one APR applies throughout the modeled period; rate changes require a schedule that accounts for each rate period.
Does total scheduled interest mean interest already paid?
No. It estimates interest across the entire original term under the entered assumptions. It does not report the interest paid up to the selected payment count.
This result is an estimate for educational use; the lender’s disclosure gives the exact figures.
Related
Formula used
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 | Monthly payments made | payments | 12 | 0 | 600 out bal | Balance after payments | $ | p * (1 + apr / 1200) ^ k - (p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * ((1 + apr / 1200) ^ k - 1) / (apr / 1200) | 2 out pmt | Scheduled monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2 out int | Total scheduled interest | $ | pmt * yrs * 12 - p | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- United Test and Balance: What It Means in Finance
- Trade Date Balance: Meaning and How It Works
- UBS Trade Date Balance: Meaning and How It Works
- Time Left on Loan Calculator: Estimate Payoff Time60 months
- The Balance in Journaling: Finding a Sustainable Practice
- Ledger Balance on a Certain Date: What It Means