calculate-loan

01 Loan payments

Scheduled Balance Loan: Meaning and Payment Calculator

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

Monthly payment $405.53
Scheduled balance after 12 payments
$16,611.17
Level-payment formula, rounded to the cent
Total interest
$4,331.80
= Monthly payment × loan term × 12 − loan amount
Loan amount
$20,000
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Scheduled balance after 12 payments ($), Total 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.

This calculator estimates the scheduled balance of a fixed-rate loan after a chosen number of monthly payments. Enter the starting loan amount, annual percentage rate (APR), loan term, and number of payments made; the result is an estimated remaining principal balance, alongside the monthly payment and total interest for the full term.

Formula

A scheduled balance loan is not a distinct, universally standardized loan product. In ordinary loan and accounting usage, “scheduled balance” means the principal balance expected to remain after the payments specified in a loan’s repayment schedule, assuming those payments are made as planned. The phrase describes a calculated balance, not a special kind of loan.

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

B_k = P(1 + r)^k - M × ((1 + r)^k - 1) / r

  • B_k is the remaining balance after k monthly payments, in dollars.
  • P is the original loan principal, in dollars.
  • r is the monthly interest rate, calculated here as APR divided by 1,200.
  • k is the number of scheduled monthly payments made.
  • M is the monthly payment, rounded to cents by this calculator.

The level-payment formula is M = P × r / (1 - (1 + r)^(-n)), where n is the total number of monthly payments. Total interest in this simplified model is the sum of the rounded monthly payments over the term minus the original principal.

Worked Example

Using the calculator’s defaults: principal is $20,000, APR is 8%, the term is 5 years, and the balance is measured after 12 payments.

  1. Convert the annual rate to a monthly rate: r = 8 / 1,200 = 0.0066667, or about 0.66667% per month.
  2. Convert the term to payments: n = 5 × 12 = 60.
  3. Calculate the payment: M = 20,000 × 0.0066667 / (1 - (1.0066667)^(-60)), which rounds to $405.53.
  4. Calculate the scheduled balance after 12 payments: B₁₂ = 20,000 × (1.0066667)^12 - 405.53 × ((1.0066667)^12 - 1) / 0.0066667, which rounds to $16,507.35.
  5. Calculate total interest using the rounded payment: $405.53 × 60 - $20,000 = $4,331.80.

Assumptions

  • The interest rate remains fixed for the full term.
  • Payments are equal, made monthly, and applied at the end of each monthly period.
  • Interest compounds monthly at APR divided by 12; the APR is treated as a nominal annual rate for this arithmetic.
  • The calculation excludes fees, taxes, insurance, PMI, escrow, late charges, skipped payments, and any extra principal payments.

What the Term Means and How to Use the Result

“Scheduled balance loan” is best understood as informal descriptive wording rather than a formal loan category. It may appear in a calculator, spreadsheet, servicing document, or discussion comparing a planned balance with the amount actually owed. The word “scheduled” points to the payment timetable; “balance” is the amount of principal still outstanding under that timetable. There is no single special contract or repayment method implied by the phrase alone.

For example, someone might write, “The scheduled balance after the first year is about $16,507.” That sentence means the modeled principal remaining after 12 planned payments, under the stated assumptions. It does not establish that every lender uses this exact label, nor does it mean the borrower has a separate “scheduled balance” loan. In a real statement, check the surrounding definitions and the lender’s own balance figures.

The balance generally falls as payments are made, but each payment is split between interest and principal. Early in a level-payment loan, more of a payment may go toward interest than principal; later, the principal portion usually grows. The calculator’s balance is the expected principal remaining, not a payoff quote. A payoff amount may also reflect accrued interest through a particular date or other contract-specific amounts, which are not modeled here.

To use the result, enter the principal and APR shown in the loan documents, the full term, and the number of payments that have actually been made or are being modeled. The displayed balance is set to 12 payments in this version. It assumes all payments were made in full and on schedule. If the loan has a variable rate, irregular payments, fees added to principal, or extra payments, the calculated figure will differ from the actual account balance.

Common Confusions and Calculation Limits

A scheduled balance is not the same as the original amount borrowed, the total of future payments, or necessarily the amount required to pay the loan off today. It is also not a statement about whether a borrower qualifies for credit. Those are different quantities and require different information.

  • APR versus monthly rate: The input is an annual percentage. The formula divides it by 1,200 to obtain a monthly rate; do not enter 8 for an 8% monthly rate.
  • Term versus payments made: The term determines the scheduled payment and total number of installments. The balance formula uses a separate count of installments already completed.
  • Rounding: Monthly payments are rounded to cents. A lender’s exact calculation may retain additional precision internally or apply a different rounding convention, creating a small difference.
  • Other loan structures: Interest-only periods, balloon payments, daily interest, changing rates, and payment dates that do not follow monthly periods require a different model.

The displayed balance is meaningful only when the inputs describe the same loan and the payment history follows the assumed schedule. If the lender’s statement differs, its transaction history and contract terms—not this simplified estimate—determine the amount shown on the account.

Frequently Asked Questions

Is a scheduled balance loan a type of loan?
No. The phrase is not a standard name for a distinct loan product. It usually refers to the expected outstanding balance on a loan’s payment schedule.

What does scheduled balance mean?
It means the projected or recorded balance remaining at a point in a planned repayment schedule. The exact meaning can depend on the document using the phrase.

How do I calculate a scheduled loan balance?
For a fixed-rate loan with equal monthly payments, use the balance formula above, based on the original principal, monthly rate, payment amount, and number of payments made.

Is scheduled balance the same as payoff balance?
Not necessarily. A scheduled balance is a model of principal under planned payments; a payoff quote can reflect the date of payoff and other amounts not included in this calculator.

Why does my lender’s balance differ from this estimate?
Possible reasons include payment dates, rounding, variable rates, fees, extra or missed payments, and interest calculation methods that differ from the monthly model.

This result is an estimate for educational arithmetic; 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
out pmt | Monthly payment | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out bal | Scheduled balance after 12 payments | $ | p * (1 + apr / 1200) ^ 12 - pmt * ((1 + apr / 1200) ^ 12 - 1) / (apr / 1200) | 2
out int | Total 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 →