calculate-loan

01 Loan payments

Calculate Current Loan Balance With This Formula

Calculator No. 01-16288 · Updated · Formula and assumptions shown below

Current loan balance $16,611.17
Monthly payment
$405.53
Level-payment formula, rounded to the cent
Total scheduled interest
$4,331.80
= Monthly payment × loan term × 12 − original loan amount
Original loan amount
$20,000
Input
You enter
Original loan amount ($), Interest rate (APR) (%), Loan term (years), Monthly payments made
You get
Current loan balance ($), Monthly payment ($), Total scheduled interest ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

Calculate your current loan balance by entering the original loan amount, annual APR, loan term, and number of monthly payments already made. The calculator estimates the remaining principal under a fixed-rate, monthly-payment schedule and also shows the scheduled payment and total interest.

Formula

The calculator first determines the scheduled monthly payment, rounded to cents, then applies the amortization balance formula for the number of payments made:

  • Monthly rate: r = APR ÷ 1,200, where APR is entered as a percentage per year.
  • 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.

Here, P is the original amount borrowed in dollars, r is the monthly interest rate as a decimal, M is the rounded monthly payment in dollars, k is the number of monthly payments made, and B is the estimated remaining principal in dollars. For example, an APR of 8% becomes a monthly rate of 0.08 ÷ 12, or about 0.006667. The calculation assumes a standard fixed-rate amortizing loan.

Worked Example

Using the calculator’s default inputs: P = $20,000, APR = 8%, term = 5 years, and k = 12 payments.

  1. Convert the APR to a monthly rate: r = 8 ÷ 1,200 = 0.0066667.
  2. Find the number of scheduled payments: n = 5 × 12 = 60.
  3. Calculate the payment: M = round[$20,000 × 0.0066667 ÷ (1 − (1.0066667)−60), 2] = $405.53 per month.
  4. Apply the balance formula after 12 payments: B = 20,000 × (1.0066667)12 − 405.53 × [(1.0066667)12 − 1] ÷ 0.0066667 = $16,478.33, rounded to cents.

The scheduled interest over the full term is calculated using the displayed rounded payment: $405.53 × 60 − $20,000 = $4,331.80. The remaining balance is not the same as the sum of the payments still due: future payments also include interest that has not yet accrued.

Assumptions

  • The interest rate remains fixed for the full term.
  • Payments are equal monthly payments made at the end of each month, with the first payment one month after borrowing.
  • Interest compounds monthly at APR divided by 12; the APR is treated as a nominal annual rate.
  • The estimate excludes fees, taxes, insurance, PMI, escrow, late charges, and any other amounts not entered.
  • Payments are made on schedule, and no extra principal payments, skipped payments, rate changes, or payment-date adjustments occur.

When to Use a Loan Balance Estimate

This calculation can help you understand how an ordinary installment loan amortizes and estimate the principal left after a chosen number of payments. It applies the same basic method to many fixed-rate personal, auto, and home loans, but it does not reproduce every lender’s account statement. Enter the original principal—not the purchase price or the total of all scheduled payments—and count completed monthly payments rather than months since the application or approval.

If your loan has a variable rate, the interest rate has changed, or payments were irregular, the result may differ substantially from the account balance. A lender’s payment history and current payoff quote reflect the actual dates, posted transactions, accrued interest, and applicable charges. Use those figures when you need an exact amount for a particular date.

How to Read the Result and Common Errors

The headline figure is the estimated principal remaining after k completed payments. It is not necessarily the amount required to pay off the account today. A payoff amount may include interest accrued since the last payment and other account-specific items; the calculator has no inputs for them.

  • APR entry: Enter 8 for 8%, not 0.08. The formula converts the percentage to a monthly decimal.
  • Payment count: Use whole monthly payments actually made. A payment that is scheduled but not yet posted should not automatically be counted as complete.
  • Term: Enter the original scheduled term, not the number of years remaining.
  • Rounding: The payment is rounded to cents before calculating the balance. A lender’s day-count method and payment posting can create a small difference.
  • Extra payments: Additional principal payments generally change the amortization path; this calculator does not accept them and cannot account for their effect.

Limits and Other Balance Figures

The formula is for a fully amortizing loan with equal payments and a positive APR. It does not model interest-only periods, balloon payments, deferred interest, negative amortization, skipped or late payments, or multiple rate periods. It also treats APR as the rate used to accrue loan interest; some disclosures include costs in APR that are not part of the note rate used to calculate the account balance. If your APR and contractual interest rate differ, the balance estimate can therefore be misleading.

“Current balance,” “principal balance,” and “payoff amount” can mean different things in account interfaces and lender documents. The principal balance is the unpaid loan principal. A payoff quote is an amount calculated for a specific date and may account for interest accrued and account-specific charges. Check the lender’s statement or contact the servicer for the balance definition and exact figure relevant to your purpose.

Frequently Asked Questions

How do I calculate the remaining balance on a loan?
Find the scheduled monthly payment from principal, monthly rate, and total payment count. Then use the amortization balance formula for the number of payments already made: P(1 + r)k − M[(1 + r)k − 1] ÷ r.

Is current loan balance the same as payoff amount?
Not always. The balance estimate represents principal under the stated assumptions. A payoff quote is date-specific and may include accrued interest or other amounts, so request it from the lender when an exact payoff figure is needed.

Does this calculation include extra payments?
No. It assumes the same scheduled payment each month and no extra principal. To estimate a loan with extra payments, you need the timing and amount of each payment and must recalculate the amortization schedule.

Why does the calculator differ from my lender’s balance?
Possible causes include a different interest rate basis, payment dates, rounding, extra or late payments, fees, or a rate change. The estimate also assumes payments post at regular monthly intervals.

How many payments should I enter?
Enter the number of completed monthly payments applied to the loan. If you are uncertain how many have posted, check the account history rather than relying only on elapsed time.

This result is an estimate for educational arithmetic; 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 | Monthly payments made | - | 12 | 0 | 600
out bal | Current loan 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 int | Total scheduled interest | $ | pmt * yrs * 12 - p | 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

The whole Loan payments section →