A loan’s new balance is the amount still owed at a particular point in time, after payments, interest, and any other posted transactions have changed the account. This calculator estimates the balance after a chosen number of monthly payments on a fixed-rate, level-payment loan; enter the original amount, APR, term, and payments made to see the estimated remaining principal.
Formula
The calculator first finds the scheduled monthly payment, then applies the balance formula for the number of payments made. In symbols:
- Monthly rate:
r = APR / 1200, where APR is entered as a percentage per year. - 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; r is the monthly interest rate as a decimal; n is the total term in months (years × 12); M is the monthly payment in dollars; k is the number of payments already made; and B is the estimated balance in dollars. The payment is rounded to cents before the balance is calculated, reflecting a regular payment amount. A real account may differ because its lender can use different posting dates, rounding, or payment allocation.
Worked Example
Using the defaults: principal $20,000, APR 8%, term 5 years, and 12 payments made:
- Convert the APR to a monthly rate:
r = 8 / 1200 = 0.0066667. - Convert the term to months:
n = 5 × 12 = 60. - Calculate the scheduled payment:
M = round[20,000 × 0.0066667 / (1 − (1.0066667)−60), 2] = $405.53. - Apply the balance formula after 12 payments:
B = 20,000 × (1.0066667)12 − 405.53 × [(1.0066667)12 − 1] / 0.0066667 = $16,602.13, rounded to cents.
The estimated new balance is $16,602.13. The 12 scheduled payments total $405.53 × 12 = $4,866.36. That total is not the amount by which the principal fell: part of each payment covered interest.
What “New Balance” Means
“New balance” is not a single universal accounting term. On a loan, it commonly means the amount owed after a transaction or payment has been recorded. The figure might refer to principal remaining, or it might include accrued interest, fees, or other posted amounts, depending on the lender’s statement and how it labels the field. This calculator specifically estimates the unpaid loan principal under the formula shown; it does not reproduce an account statement or calculate a payoff quote.
A credit-card statement may also use “new balance” for the statement balance at the end of a billing cycle. That is a different context: purchases, credits, fees, and interest during the cycle affect the amount. The fixed-payment installment-loan formula here should not be used to estimate a card balance with changing purchases, variable rates, or different payment rules.
How the Balance Changes
Each scheduled payment is divided between interest and principal. In an ordinary amortizing loan, interest for a period is calculated on the outstanding balance; the payment covers that interest first, and the remainder reduces principal. Early in the schedule, the balance is comparatively large, so the interest portion is larger. As principal declines, less interest accrues per period and more of a level payment goes toward principal.
For the example, the first month’s interest under the monthly-rate assumption is about $20,000 × 0.0066667 = $133.33. From the $405.53 payment, approximately $272.20 reduces principal. The next month’s interest is calculated on the lower balance. This is why subtracting total payments from the original loan amount gives the wrong remaining balance: it treats every dollar paid as principal.
When to Use This Estimate
Use the calculator for a straightforward estimate when the loan has a fixed APR, equal monthly payments, and no extra transactions. The payments-made input should count payments actually applied to the loan, not simply months that have passed. Enter zero to see the starting balance; enter the full term in months to estimate the balance after the final scheduled payment (small residuals can occur because the payment is rounded).
- Check the original principal and APR against the loan documents.
- Enter the contractual term in years and the number of completed monthly payments.
- Compare the result with a statement only after accounting for its statement date and posted activity.
- For an exact payoff amount, request the current payoff figure from the loan servicer; it may include interest through a specified date or other amounts not modelled here.
Assumptions and Limits
- The interest rate remains fixed for the full modeled period.
- Payments are equal, monthly, and made at the end of each period, as in a standard amortization calculation.
- Interest compounds monthly at APR divided by 12.
- The model excludes fees, taxes, insurance, PMI, escrow, late charges, skipped or partial payments, and extra principal payments.
- It assumes the payment is applied according to the formula and does not model lender-specific daily-interest methods or posting cutoffs.
These limits matter when comparing an estimate with an account balance. A variable-rate loan, an irregular payment schedule, a payment made mid-cycle, or an extra payment can change the result. Rounding each installment to cents can also create a small difference over the life of a loan. If a payment is late or does not cover accrued interest, the account may behave differently from this standard amortization model.
Frequently Asked Questions
Does new balance mean the amount I originally borrowed?
No. It generally refers to the amount owed after recorded activity at a particular time. The original principal is the starting amount; payments and interest change the balance afterward.
Why is my new balance higher than this estimate?
Possible reasons include interest accrued since the last payment, fees, a different payment date or interest method, a variable rate, or payments that have not yet posted. Check the lender’s transaction history and statement definitions.
Is the new balance the same as a payoff amount?
Not necessarily. A payoff figure may include interest through a future payment date and other account-specific amounts. Use the lender’s current payoff quote when an exact amount is needed.
Does every payment reduce principal by the full payment amount?
No. Interest is generally covered first under a standard amortizing schedule. Only the remainder reduces principal, which is why total payments cannot simply be subtracted from the original loan amount.
Can I use this for a credit-card new balance?
Not reliably. Credit-card statement balances reflect billing-cycle transactions and may involve changing balances, rates, and payment rules. This calculator models a fixed-rate installment loan with equal monthly payments.
This result is an estimate for educational purposes, and 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 | Payments made | - | 12 | 0 | 600 out bal | New balance | $ | 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 paid | Payments made total | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) * k | 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
- Up-to-Date Loan Balance Calculator$16,611.20
- 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