calculate-loan

01 Loan payments

Balance Due Interest Calculator: Estimate Loan Balance

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

Balance due $16,611.17
Payments made total
$4,866.36
Level-payment formula, rounded to the cent
Interest accrued through payment k
$1,477.53
Level-payment formula, rounded to the cent
Original loan amount
$20,000
Input
You enter
Original loan amount ($), Interest rate (APR) (%), Loan term (years), Payments made
You get
Balance due ($), Payments made total ($), Interest accrued through payment k ($)
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.

A balance due interest calculator estimates the unpaid balance on a fixed-rate loan after a chosen number of payments, including the effect of interest and payments already made. Enter the original loan amount, annual APR, loan term, and number of payments made to see the estimated balance still due and the interest accrued over that period.

Formula

The calculator uses the standard fixed-rate amortization balance formula:

Bk = P(1 + r)k − M × ((1 + r)k − 1) / r

  • Bk is the remaining balance after k payments, in dollars.
  • P is the original principal, in dollars.
  • r is the monthly interest rate, calculated as APR ÷ 1,200.
  • k is the number of monthly payments made.
  • M is the scheduled monthly payment, rounded to cents. It is calculated as P × r ÷ [1 − (1 + r)−n].
  • n is the full loan term in months, calculated as years × 12.

The interest-accrued output is the original balance grown at the monthly rate, less the principal repaid by the payments made. The calculator uses the rounded monthly payment in its balance calculation, which reflects how cent-rounded scheduled payments can produce small differences from an unrounded mathematical schedule.

Worked Example

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

  1. Convert the term to months: n = 5 × 12 = 60.
  2. Convert APR to a monthly rate: r = 8 ÷ 1,200 = 0.0066667.
  3. Calculate the payment: M = $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] = $405.53 per month, rounded to cents.
  4. Grow the original principal for 12 months: $20,000 × (1.0066667)12 ≈ $21,662.94.
  5. Subtract the accumulated value of the 12 payments: $405.53 × [(1.0066667)12 − 1] ÷ 0.0066667 ≈ $4,503.69.
  6. Subtracting gives an estimated balance of $17,159.25. The 12 scheduled payments total 12 × $405.53 = $4,866.36.

Assumptions

  • The interest rate remains fixed for the full period.
  • Payments are equal monthly payments made at the end of each monthly period.
  • Interest compounds monthly at APR divided by 12.
  • The calculation excludes fees, taxes, insurance, PMI, escrow, missed or extra payments, and lender-specific payment allocation or rounding.

When to Use a Balance Due Calculator

Use this estimate when you want to understand how much principal remains after a particular number of regular payments. For example, it can help you check a loan statement, estimate the balance at a future point in a payment schedule, or compare the effect of different loan amounts, terms, and APR inputs. It is a mathematical estimate, not a payoff quote: a lender’s payoff figure may include interest accrued since the last payment and other amounts not represented here.

Enter the loan’s original principal, not the sum of all scheduled payments. Use the annual percentage rate as a percentage—for example, enter 8 for 8%, not 0.08. The payment count is the number of payments that have actually posted, not simply the number of months since borrowing if payments were deferred or missed. The calculator accepts a count up to the term’s number of months; a count beyond that is inconsistent with the schedule.

How to Read the Results

Balance due is the estimated principal and accumulated scheduled interest still outstanding immediately after the specified payment. It normally declines over time on a fully amortizing loan, but early payments can reduce principal slowly because a larger share goes toward interest. Payments made total is the count entered multiplied by the scheduled payment; it is not the same as principal repaid. Interest accrued through payment k estimates the interest portion represented by the payment schedule through that point.

For the example, 12 payments total $4,866.36, but the balance falls by only $2,840.75 from the original $20,000. The difference reflects interest charged during those periods. This is why adding up payments and subtracting them from the original loan amount does not correctly calculate the remaining balance.

Common Errors and Calculator Limits

  • Mixing percent and decimal formats: APR input is a percentage, so 8% is entered as 8.
  • Using the wrong payment count: Count completed monthly payments, not the current month or a payment that has not posted.
  • Assuming APR describes every charge: APR may reflect certain costs in a lender’s disclosure, but this calculator uses it as a periodic interest rate and does not separately model fees.
  • Expecting an exact payoff amount: Daily interest, payment posting dates, fees, extra payments, rate changes, and lender rounding can change the amount required to close an account.
  • Applying the formula to irregular debt: Credit cards, variable-rate loans, interest-only periods, and loans with changing payments need different calculations or additional inputs.

For a precise amount to pay on a specific date, request a payoff statement from the lender and check the loan’s actual terms. Use the APR, scheduled payment, and posted-payment count shown in your records; the lender’s disclosure is the source for the contractual figures and payment details.

Frequently Asked Questions

What does balance due mean on a loan?
It generally means the amount still owed at a particular point in time. A statement balance and a payoff amount can differ because a payoff quote may include interest through a specified date or other amounts.

How do I calculate a loan balance after payments?
Convert APR to a monthly rate, calculate the scheduled payment, then apply the amortization balance formula for the number of payments made. This calculator performs those steps using the inputs above.

Is the remaining balance the same as total payments left?
No. Total payments remaining are the scheduled monthly payment multiplied by the number of payments left. That total includes future interest; the current balance is the amount outstanding at the calculation point under the model.

Why does my lender’s balance differ from this estimate?
The lender may use actual payment dates, daily interest, a different rounding method, variable rates, fees, or adjustments for extra and late payments. The calculator assumes a fixed rate and regular end-of-month payments.

Can I use this for a payoff quote?
No. It estimates the scheduled balance after a payment, not the exact amount required to pay off the loan on a particular date. Ask the lender for a date-specific payoff figure.

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 | Balance due | $ | 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 paid | Payments made total | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) * k | 2
out int | Interest accrued through payment k | $ | p * ((1 + apr / 1200) ^ k - 1) - (round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) * (((1 + apr / 1200) ^ k - 1) / (apr / 1200) - 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

The whole Loan payments section →