A current balance calculator estimates how much principal remains on a fixed-rate, level-payment loan after a specified number of monthly payments. Enter the original loan amount, annual percentage rate (APR), loan term, and payments already made to estimate the remaining balance and show how it relates to the payment schedule.
Formula
The calculator first finds the scheduled monthly payment, then applies the balance formula for the number of payments already made. It assumes payments are made monthly and on time.
- Monthly rate: r = APR / 1,200, where APR is entered as a percentage per year and r is the monthly rate as a decimal.
- Number of scheduled payments: n = loan term in years × 12.
- Monthly payment: M = round[P × r / (1 − (1 + r)−n), 2].
- Balance after k payments: B = P(1 + r)k − M[(1 + r)k − 1] / r.
P is the original principal in dollars, M is the monthly payment in dollars, k is the number of payments made, and B is the estimated remaining balance in dollars. The payment is rounded to cents before it is used in the balance calculation, matching a schedule that charges a cent-rounded regular payment. The calculator requires k to be no greater than n; otherwise it cannot produce a valid result.
Worked Example
Using the default inputs: P = $20,000, APR = 8%, term = 5 years, and k = 12 payments.
- Convert the APR to a monthly rate: r = 8 / 1,200 = 0.0066666667.
- Find the number of payments: n = 5 × 12 = 60.
- Calculate and round the scheduled payment: M = round[$20,000 × 0.0066666667 / (1 − (1.0066666667)−60), 2] = $405.53.
- Apply the balance formula: B = $20,000(1.0066666667)12 − $405.53 × [(1.0066666667)12 − 1] / 0.0066666667 = $16,444.67.
The estimate after 12 payments is $16,444.67, with 48 scheduled payments remaining. Small differences can occur if a lender uses a different day-count method or payment schedule.
Assumptions
- The interest rate stays fixed for the full term.
- Payments are equal, monthly, and made at the end of each monthly period.
- Interest compounds monthly using APR divided by 12.
- Payments are made as scheduled; no missed payments, extra principal payments, or payment changes are included.
- Fees, taxes, insurance, PMI, and escrow are not included.
What a Current Balance Means
“Current balance” can refer to different figures depending on where it appears. In a loan schedule, it commonly means the principal remaining after payments have been credited. A payoff amount, by contrast, may include interest accrued since the last payment and other charges specified by the loan account. This calculator estimates the scheduled principal balance; it does not quote a lender’s exact payoff amount.
At the beginning of a fully amortizing loan, each payment covers interest for the period and reduces principal by the remainder. As principal falls, the interest portion generally falls too, while the scheduled payment remains level under the assumptions above. That is why the balance does not decline by the full payment amount each month.
For example, a borrower who has made 12 payments on a five-year loan has not necessarily paid one-fifth of the principal. The early payments include interest, so the remaining principal depends on the rate and payment timing as well as the number of payments made.
How to Use and Interpret the Estimate
Use the original amount borrowed, not the amount of the latest payment. Enter APR as a percentage: an 8% rate is entered as 8, not 0.08. Enter the original term in years and the number of completed monthly payments. If the first payment has not yet been made, enter zero payments.
The result is most useful as a planning estimate or a way to understand an amortization schedule. It can also help explain why a statement balance differs from the original amount minus payments made. For a precise account figure, use the balance shown by the servicer or lender and check its “as of” date and definition of balance.
- Confirm whether your rate is fixed. A variable rate can make this estimate diverge after a rate change.
- Count payments actually credited, rather than months since the loan began.
- Use the original repayment term, not the remaining term, alongside the original loan amount.
- Compare like with like: a principal balance and a payoff quote may include different items.
Limits and Common Sources of Difference
This formula models a standard amortizing loan with one fixed APR and regular monthly payments. It does not model an interest-only period, balloon payment, irregular payment dates, fees added to the loan, rate resets, or extra payments. If extra payments were applied directly to principal, the actual balance would usually be lower than this estimate, but the amount depends on the lender’s posting and servicing rules.
Rounding also matters. This calculator rounds the scheduled payment to cents and uses that amount for each period, but lenders can use detailed daily interest calculations, different rounding practices, or payment dates that do not fall at uniform monthly intervals. Even small differences can accumulate over time. The calculator’s result should therefore be treated as an estimate, not as an account statement or payoff demand.
A common misconception is that multiplying the monthly payment by the number of payments made gives the principal repaid. That total includes both principal and interest. Another is that “balance” always means the amount needed to close an account today; accrued interest and other account-specific amounts can make a payoff figure different.
Frequently Asked Questions
What does current balance mean on a loan?
It usually means the amount still owed at a stated date, but the exact definition varies. A statement may show principal remaining, while a payoff quote may also account for interest accrued and other amounts.
How do I calculate my remaining loan balance?
For a fixed-rate loan with equal monthly payments, calculate the monthly payment and apply the amortization balance formula using the number of payments already made. The calculator above performs those steps with the stated assumptions.
Why is my loan balance not the original amount minus my payments?
Each regular payment includes interest as well as principal. Only the principal portion reduces the balance, and the split changes over the repayment schedule.
Is this the amount I need to pay off my loan today?
No. It estimates principal remaining under a simplified schedule. Ask the lender or servicer for a dated payoff quote, which can reflect accrued interest and account-specific items.
Can I use this calculator if I made extra payments?
Not exactly. The formula assumes only the scheduled payment was made each month. Extra payments can reduce principal sooner, so use a payment history or lender-provided amortization schedule for a more accurate balance.
This result is an estimate for educational purposes, 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 paid | Payments remaining | - | yrs * 12 - k | 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