A current balance calculator estimates the amount of principal still owed on a fixed-rate loan after a specified number of monthly payments. Enter the original loan amount, annual percentage rate (APR), term, and payments already made to see the estimated remaining balance and the payment used in the calculation.
Formula
The balance after k regular monthly payments is the original principal grown by monthly interest, minus the accumulated value of the payments made:
Bk = P(1 + r)k − M × [(1 + r)k − 1] / r
- Bk is the estimated balance after k payments, in dollars.
- P is the starting principal, in dollars.
- r is the monthly interest rate as a decimal, calculated as APR ÷ 1,200.
- k is the number of monthly payments made.
- M is the fixed monthly payment, in dollars, rounded to cents.
For a fully amortizing fixed-rate loan, the scheduled payment is M = P × r ÷ [1 − (1 + r)−n], where n is the total number of monthly payments. The calculator rounds this payment to the nearest cent before applying it to the balance, consistent with the stated payment and balance calculations.
Worked Example
Using the defaults: a $20,000 loan, 8% APR, a five-year term, and 12 payments made.
- Convert the APR to a monthly decimal rate: 8 ÷ 1,200 = 0.0066667, or about 0.66667% per month.
- Find the number of scheduled payments: 5 × 12 = 60.
- Calculate the scheduled payment: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] = $405.53 per month, rounded to cents.
- Apply the balance formula after 12 payments: $20,000 × (1.0066667)12 − $405.53 × [((1.0066667)12 − 1) ÷ 0.0066667].
- The estimated current balance is $16,425.87.
This is a mathematical estimate under the calculator’s assumptions. A lender’s payoff amount may differ because it can include interest accrued since the last payment or other account-specific amounts.
Assumptions
- The interest rate stays fixed for the entire period.
- Payments are equal, made monthly, and applied at the end of each monthly period.
- Interest compounds monthly at APR divided by 12.
- The calculation excludes fees, taxes, insurance, PMI, escrow, late charges, extra payments, skipped payments, and lender-specific adjustments.
When to Use a Current Balance Estimate
A balance estimate can help you understand how repayment changes the amount of principal remaining. It can be useful for checking a loan statement, planning a rough payoff timeline, or comparing the scheduled balance at different payment counts. For example, entering 24 payments instead of 12 shows the model’s balance after two years, provided the loan has followed the assumed fixed-rate, on-time payment schedule.
“Current balance” can mean different things in everyday use. This calculator estimates the principal balance after a selected number of payments; it does not produce an official payoff quote. A payoff quote may include daily interest through a particular date and account-specific charges or credits. For a transaction or exact settlement figure, use the amount provided by the loan servicer.
How to Enter the Numbers
- Original loan amount: Enter the principal when repayment began, not the total of all future payments.
- APR: Use the annual rate applicable to this loan. The calculator converts it to a monthly rate by dividing by 12 and converting percent to decimal.
- Term: Enter the original scheduled repayment term in years. The formula treats each year as 12 monthly periods.
- Payments made: Enter completed monthly payments, not the number of months since the loan started if payments were missed or deferred.
The payment count cannot exceed the number of scheduled payments. If the loan has a different payment frequency, variable rates, or irregular payments, this monthly fixed-payment model will not represent its exact schedule.
Reading the Result and Common Mistakes
The first result is the estimated remaining balance. The second is the rounded scheduled monthly payment, and the third is the number of payments in the original term. The result is not the total amount remaining to be paid: that total would include future interest as well as principal, and it is not calculated here.
One common misconception is that every payment reduces principal by the same amount. With a standard amortizing loan, each payment covers that period’s interest first; the remainder reduces principal. Early in repayment, interest generally accounts for a larger share of the payment than it does later. That is why the balance may decline slowly at first even when payments are made regularly.
Rounding and timing also matter. The calculator rounds the scheduled monthly payment to cents, while a lender may use its own daily-interest conventions and exact posting dates. Small differences can accumulate over many payments. The model also assumes that all entered payments were made in full and on schedule; extra principal payments or late payments change the result.
Limits and Alternatives
This formula is intended for a conventional fixed-rate loan with level monthly payments. It is not an exact model for an adjustable-rate loan, a loan with a balloon payment, a revolving credit account, or a schedule with fees added to principal. A promotional rate change, payment pause, or extra payment can also make the estimate diverge from the account’s actual balance.
For a more accurate figure, review the latest statement and ask the servicer for the balance or payoff amount as of the date you need. If you are checking a statement, make sure you compare like with like: a principal balance is different from an amount that includes accrued interest or other charges.
Frequently Asked Questions
Is current balance the same as payoff amount?
No. This calculator estimates principal remaining after a payment count. A payoff amount may include interest accrued through a specified date and other account-specific items.
Why does the balance fall slowly at first?
Each payment first covers interest for that period. When the balance is higher, the interest portion is larger, leaving less of the fixed payment to reduce principal.
Can I include extra payments?
Not directly. Extra payments reduce principal differently from the standard schedule and can change later interest and payment timing. Use the loan’s actual payment history or a calculator designed for extra payments.
What if I have made no payments yet?
Enter 0 for payments made. The estimated balance will equal the starting principal under this model.
Why does my statement show a different amount?
Possible reasons include payment dates, daily interest, rounding, variable rates, fees, missed or extra payments, or a difference between principal balance and payoff amount.
This result is an estimate, and the lender’s disclosure gives the exact figures.
Related
Formula used
in p | Original 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 | Current balance | $ | p * (1 + apr / 1200) ^ k - round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) * ((1 + apr / 1200) ^ k - 1) / (apr / 1200) + 0 * sqrt(yrs * 12 - k) | 2 out pmt | Monthly payment | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2 out n | Scheduled payments | - | yrs * 12 | 0
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
- Closing Costs on a House Loan: What to Expect$405.53
- Secured Loan for Home Refinancing: Payment Calculator$405.53
- Closing Cost House Calculator: Estimate Buyer Costs$8,500.00
- Closing Cost House Estimate Calculator
- Loan Repayment Extension Request Letter: What to Include$405.53
- Refinance Calculator With PMI and Loan Term