This current loan balance calculator estimates how much principal remains after a specified number of monthly payments on a fixed-rate loan. Enter the original loan amount, annual percentage rate (APR), loan term, and payments already made to calculate the remaining balance and the estimated amount paid so far.
Formula
The balance after a given number of regular payments is the original principal grown by monthly interest, minus the accumulated value of the payments made:
B = P(1 + r)k − M[((1 + r)k − 1) / r]
- B is the estimated remaining balance, in dollars.
- P is the original principal, in dollars.
- r is the monthly interest rate as a decimal: APR ÷ 1200.
- k is the number of monthly payments made.
- M is the monthly payment in dollars, rounded to cents using the standard fixed-payment formula: P × r ÷ [1 − (1 + r)−n].
- n is the total number of monthly payments: loan term in years × 12.
The calculator uses the rounded monthly payment when estimating the balance. The condition that payments made cannot exceed the full scheduled term is built into the balance expression; an invalid combination displays “Cannot compute.” This standard amortization calculation assumes payments are made monthly and on schedule.
Worked Example
Using the defaults: principal P = $20,000, APR = 8%, term = 5 years, and k = 12 payments.
- Convert the APR to a monthly decimal rate: r = 8 ÷ 1200 = 0.0066667.
- Find the number of scheduled payments: n = 5 × 12 = 60.
- Calculate the payment: M = 20,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)−60] ≈ $405.53 per month.
- Calculate the balance after 12 payments: B = 20,000(1.0066667)12 − 405.53 × {[(1.0066667)12 − 1] ÷ 0.0066667} ≈ $16,475.74.
- For context, the total of the 12 scheduled payments is 12 × $405.53 = $4,866.36. That amount is not the same as principal repaid because part of each payment covers interest.
What a Current Balance Means
“Current balance” can refer to different figures depending on the lender’s statement and the question being asked. In this calculator, it means the estimated principal still owed after the stated number of regular payments, under the entered loan terms. It does not mean the total of all future payments or necessarily the exact amount required to close the loan today.
Each scheduled payment usually has an interest portion and a principal portion. Early in a conventional amortizing loan, the balance is relatively high, so monthly interest is calculated on a larger amount. As the principal falls, the interest portion generally falls too, and more of a level payment goes toward principal. That is why subtracting the full amount of payments made from the original loan amount gives the wrong balance.
How to Use the Estimate
Use the original amount borrowed, not the total of all scheduled payments. Enter the APR as a percentage—for example, enter 8 for 8%, not 0.08. The term is in years, and payments made is a count of monthly payments already posted. If a payment is currently due but has not been made, do not count it as paid.
For a practical comparison, suppose a statement reports that 18 monthly payments have posted. Enter 18, even if the loan has been open for 19 calendar months because the first due date or a payment posting was delayed. The calculator follows payment count, not elapsed calendar time. If the loan has a different payment schedule, such as biweekly payments, this monthly model will not match it directly.
The “Payments made” output is simply the monthly payment multiplied by the entered payment count. It is a cash-flow total, not the amount of principal reduction. The balance output is the figure that estimates principal remaining; fees, unpaid charges, and other account adjustments are outside this calculation.
Why the Calculator May Differ From a Statement
A lender’s displayed balance can differ because its account records actual payment dates, daily interest accrual, rounding, late or partial payments, rate changes, and transactions that this simplified model does not include. A payoff quote may also account for interest accruing through a particular date and other contract-specific amounts. Therefore, do not treat this estimate as a payoff quote.
- Extra principal payments: Additional payments can reduce the balance faster, but this calculator assumes only the regular fixed payment.
- Variable rates: If the APR changed during the loan, one rate cannot reproduce the full payment history.
- Skipped, late, or irregular payments: The formula assumes every counted payment was made in full and on schedule.
- Rounding: The payment is rounded to cents, and small differences can accumulate over many payments.
- Fees or other additions: Charges, insurance, taxes, and account adjustments are not included in the principal estimate.
Assumptions and Limits
- The interest rate is fixed for the entire term.
- Payments are equal, monthly, and made at the end of each monthly period.
- Interest compounds monthly at APR ÷ 12; the APR is treated as a nominal annual rate.
- The scheduled payment is calculated from the entered principal, APR, and full term, then rounded to the nearest cent.
- Fees, taxes, insurance, PMI, escrow, extra payments, and lender-specific payoff adjustments are not included.
The result is an estimate for educational use, not financial advice. For an account-specific balance or payoff figure, check the lender’s current statement or request its dated payoff amount. The lender’s disclosure gives the exact figures.
Frequently Asked Questions
Is current balance the same as payoff amount?
No. This calculator estimates remaining principal under a regular-payment model. A payoff amount may include interest through a specified date and other account-specific adjustments; request it from the lender.
Why is my balance not the original loan minus payments made?
Because payments include interest as well as principal. The interest portion is not deducted from the amount borrowed, so only part of each payment reduces the balance.
Can I use this calculator after making extra payments?
Not accurately if the extra amounts reduced principal. The formula assumes level scheduled payments only, so use the lender’s account balance or a model that records each extra payment.
What if I have made more payments than the loan term allows?
The input is invalid for this calculation. The number of payments made must be no greater than the total scheduled months in the term.
Does APR mean the monthly rate?
No. Here APR is entered as a yearly percentage. The model converts it to a monthly decimal by dividing the percentage by 1200.
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 | months | 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 made | $ | 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
- 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