New balance numbers on a loan are the amounts still owed at different points in the repayment schedule, usually after each payment. This calculator estimates the balance after a chosen number of monthly payments; enter the original loan amount, APR, term, and payments made to see the remaining principal.
Formula
The balance after a series of level monthly payments is calculated as:
B = P(1 + r)k − M[(1 + r)k − 1] / r
- B is the estimated new balance, in dollars.
- P is the original amount borrowed, in dollars.
- r is the monthly interest rate, calculated as APR ÷ 1,200. For an APR of 8%, for example, r = 0.08 ÷ 12.
- k is the number of monthly payments made.
- M is the fixed monthly payment, rounded to cents. It is calculated from the loan amount, APR, and full term.
The payment formula is M = P × r / [1 − (1 + r)−n], where n is the total number of monthly payments in the term. The calculator uses the cent-rounded payment in the balance calculation, reflecting a payment amount that can be stated in dollars and cents.
Worked Example
Using the calculator’s defaults: P = $20,000, APR = 8%, term = 5 years, and k = 12 payments. The monthly rate is 0.08 ÷ 12 = 0.0066667, and the term is 5 × 12 = 60 months.
- Calculate the monthly payment: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] = about $405.53 after rounding to cents.
- Calculate the growth factor after 12 payments: (1.0066667)12 = about 1.082999.
- Apply the balance formula: $20,000 × 1.082999 − $405.53 × (1.082999 − 1) ÷ 0.0066667.
- The estimated new balance is $16,460.91. The total of the 12 scheduled payments is 12 × $405.53 = $4,866.36.
These figures are estimates using the stated formula and rounded payment. A lender’s schedule may differ slightly because of payment dates, daily interest calculations, rounding conventions, or other account-specific details.
Assumptions
- The interest rate stays fixed for the full period being modelled.
- 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, and any extra payments. It assumes the stated payment is made as scheduled.
What a New Balance Number Tells You
A new balance is a snapshot of the amount remaining after the payments counted in the calculation. On a standard amortizing loan, each payment covers interest accrued for the period and reduces principal by what remains. Early in repayment, the interest portion is generally larger because it is calculated against a higher outstanding balance. As principal falls, less interest accrues per period, so more of the same payment goes toward principal.
For the example, the borrower pays $4,866.36 over 12 months, but the balance falls by only $3,539.09, from $20,000 to $16,460.91. The difference is not a missing payment: it represents interest included in the scheduled payments, subject to the assumptions above. “New balance” does not mean the total of payments made, nor does it necessarily equal a lender’s payoff quote.
How to Use the Calculator
- Loan amount: Enter the original principal borrowed, not the amount of all future payments.
- APR: Enter the annual percentage rate as a percentage, such as 8 for 8%. Use the rate that applies to the loan, not a monthly rate.
- Loan term: Enter the original repayment length in years. This sets the scheduled payment used by the calculation.
- Payments made: Enter the number of monthly payments that have been applied. Use a whole number for completed payments; the calculator accepts zero to 600.
At zero payments, the estimated balance is the original principal. To estimate a balance after three years of monthly payments, enter 36. The term must describe the original schedule, even when you are checking a point partway through repayment. This calculator assumes the standard payment continues unchanged; it does not infer a payment from a statement balance.
Why Your Statement May Show a Different Balance
Loan statements can use “balance” to mean different things. A principal balance is the amount of borrowed principal remaining. A current account balance may include interest accrued since the last payment or other posted charges. A payoff amount is typically a figure calculated for a specified date and may account for interest through that date and applicable charges. The calculator estimates principal under a simplified monthly schedule; it is not a payoff quote.
Differences can arise when payment dates do not align with monthly periods, interest accrues daily, payments arrive late, extra principal is paid, the rate changes, or fees are added. A variable-rate loan cannot be represented accurately over a long period by one unchanged APR. For an exact current figure, check the loan servicer’s account information or request the relevant payoff amount directly.
Common Misreadings and Limits
- APR is not the monthly rate: The calculator converts annual percentage APR to a monthly rate by dividing by 12 and converting percent to a decimal.
- Balance is not remaining payments: The sum of future installments includes future interest, while the balance estimate is the principal remaining under the model.
- Extra payments change the schedule: Additional principal payments usually lower the balance faster, but this calculator does not include them.
- Rounding matters: The monthly payment is rounded to cents. Small differences can accumulate over many periods, and lenders may use different rounding methods.
The formula is intended for fixed-rate, fully amortizing loans with equal monthly payments. It does not model interest-only periods, balloon payments, skipped or irregular installments, changing rates, or fees. If the monthly payment does not follow the schedule assumed here, the result may not match the account’s actual principal.
Frequently Asked Questions
Does the new balance include interest?
The calculator reports estimated remaining principal after scheduled payments. The payments include interest, but accrued interest that has not yet been covered by a payment is not separately added to the result.
Why is the balance reduction smaller than the payments I made?
Part of each scheduled payment pays interest. Only the remainder reduces principal, so the total paid over a period is normally greater than the drop in principal balance.
Is a new balance the same as a payoff amount?
No. A payoff amount may include interest through a particular date and other applicable charges. Use the lender’s date-specific figure when you need an exact payoff amount.
Can I use this for a variable-rate loan?
Only as a simplified estimate for a period where the entered APR remains applicable. If the rate changes, the payment and balance path may change too; this calculator does not model rate adjustments.
What should I enter for payments made?
Enter the number of monthly payments that have actually been applied to the loan. For example, enter 12 for one year of completed monthly payments, not the number of payments remaining.
The result is an estimate, 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 | $ | pmt * 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
- Plan 2 Repayment Amount? Calculate Your Monthly Payment243.45 £
- Plan 2 Repayment Calculator: Estimate Monthly Deductions20.29 £
- New Standard Repayment Plan: Estimate Monthly Payments$405.53
- Pay As You Earn Repayment Calculator and Guide$405.53
- Federal Loan Repayment Plan Calculator$405.53
- Loan Repayment Comparison Calculator: Compare Payments$405.53