calculate-loan

01 Loan payments

Calculate Outstanding Loan Balance: Formula and Example

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

Outstanding loan balance $16,611.20
Monthly payment
$405.53
Level-payment formula, rounded to the cent
Payments made in total
$4,866.33
= Monthly payment × payments made
Original loan amount
$20,000
Input
You enter
Original loan amount ($), Interest rate (APR) (%), Loan term (years), Payments made
You get
Outstanding loan balance ($), Monthly payment ($), Payments made in total ($)
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.

This calculator estimates the balance remaining after a set number of monthly payments on a fixed-rate loan. Enter the original loan amount, annual percentage rate (APR), loan term, and number of payments already made to calculate the outstanding principal balance and related payment details.

Formula

For a fixed-rate loan with equal monthly payments, the balance after k payments is:

B = P(1 + r)k − M[((1 + r)k − 1) / r]

  • B is the estimated outstanding principal balance, 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 already made.
  • M is the fixed monthly payment, in dollars, calculated from the original principal, APR, and total term.

The payment formula is M = P × r ÷ [1 − (1 + r)−n], where n is the total number of monthly payments, or years × 12. The calculator uses the formula payment without cent-rounding inside the balance expression, while its displayed payment is rounded to cents. Consequently, a lender’s balance can differ slightly if its actual payment schedule uses rounded payments.

Worked Example

Using the calculator’s defaults: original principal P = $20,000, APR = 8%, term = 5 years, and k = 12 payments made.

  1. Convert the APR to a monthly rate: r = 8 ÷ 1,200 = 0.0066667, or about 0.6667% per month.
  2. Find the number of scheduled payments: n = 5 × 12 = 60.
  3. Calculate the monthly payment: M = 20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] ≈ $405.53 when rounded to cents.
  4. Apply the balance formula after 12 payments: B = 20,000(1.0066667)12 − 405.5303 × [((1.0066667)12 − 1) ÷ 0.0066667] ≈ $16,319.34.
  5. Payments made in total, using the displayed rounded payment: $405.53 × 12 = $4,866.36.

The estimated outstanding principal is $16,319.34. The payments made are not all principal reduction: part of each scheduled payment covers interest, especially earlier in the repayment period.

Assumptions

  • The loan has a fixed APR throughout its stated term.
  • Payments are equal, made monthly, and the entered count represents payments already posted.
  • Interest is modelled monthly at APR divided by 12, with each payment applied at the end of its monthly period.
  • Fees, taxes, insurance, PMI, escrow, late charges, and payment timing differences are not included.

How to Use the Result

The result is an estimate of unpaid principal after the number of payments entered. It is not necessarily the amount required to settle the loan on a particular date. A payoff quote may include interest accumulated since the last payment, fees, or other amounts specified in the loan account. Check the lender’s current statement or request a payoff figure when an exact transaction amount is needed.

Use the original amount borrowed, rather than the amount originally scheduled to be repaid including interest. Enter APR as a percent per year: for example, enter 8 for 8%, not 0.08. The payment count is a whole number of payments, not elapsed years; for two years of monthly payments, enter 24. If the first scheduled payment has not been made, enter zero.

The input permits up to 600 payments, while a term can extend to 50 years. For a meaningful balance, the number of payments should not exceed the total scheduled payments. If you enter more payments than the term contains, the expression extrapolates beyond the intended loan schedule and should not be treated as a valid payoff calculation.

What Changes the Balance

The remaining principal depends on the original amount, the interest rate, the term, and the payments actually credited. A higher rate generally means a larger share of early scheduled payments goes to interest under the same term and payment structure. A longer term generally lowers the scheduled payment for a given principal and rate, but spreads repayment across more months. These are formula relationships, not a prediction of any lender’s terms.

Extra principal payments can reduce a real loan’s balance faster, but this calculator does not include them. Nor does it model skipped or late payments, variable rates, interest-only periods, irregular payment dates, or changes in the payment amount. Those features require a payment-by-payment schedule or the lender’s account figures.

Common Calculation Differences

  • Rounding: Lenders may round interest or payments at each billing cycle. Small rounding differences can accumulate over time.
  • Payment posting: A payment can be pending, delayed, or credited on a different date from the assumed monthly schedule.
  • APR and contract rate: APR can reflect borrowing costs beyond the interest rate alone. This simplified formula treats the entered APR as the periodic interest basis; use the rate and method appropriate to the loan schedule for a closer estimate.
  • Principal versus payoff amount: Outstanding principal is not necessarily the same as a dated payoff quote, which can account for accrued interest and other charges.
  • Loan structure: Balloon payments, variable rates, interest-only periods, and non-monthly schedules do not follow the assumptions used here.

Frequently Asked Questions

How do I calculate my outstanding loan balance?
Convert the annual rate to a monthly rate, calculate the scheduled monthly payment, then apply the balance formula for the number of payments made. The calculator performs those steps for a fixed-rate, level-payment loan.

Is outstanding balance the same as remaining payments?
No. The balance is principal still owed under the model. Remaining scheduled payments include future interest as well as principal, so their total can be greater than the current principal balance.

Why does my lender show a different balance?
Possible causes include payment posting dates, daily rather than simplified monthly interest calculations, cent-rounding, fees, extra payments, and the difference between principal balance and a payoff quote.

Does the calculator include extra payments?
No. It assumes the same scheduled monthly payment throughout. To estimate the effect of extra payments, use a schedule that records when each additional amount is paid and how the lender applies it.

Can I use this for a variable-rate loan?
Not accurately when the rate changes. The formula assumes one fixed APR for the entire period. A variable-rate estimate needs the rate for each relevant period and the actual payment rules.

What number should I enter for payments made?
Enter the count of monthly payments credited to the loan, not simply the number of months since borrowing. For an exact current amount, consult the lender’s account information. The result is an estimate, 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 | Outstanding loan balance | $ | p * (1 + apr / 1200) ^ k - (p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * ((1 + apr / 1200) ^ k - 1) / (apr / 1200) | 2
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out paid | Payments made in 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

The whole Loan payments section →