A home loan scheduled balance is the principal still owed after a specified number of payments, assuming payments are made as scheduled and the loan terms do not change. Enter the original loan amount, annual interest rate, term, and number of payments made to estimate that balance and see how the calculation works.
Formula
The scheduled balance after k monthly payments is the original principal grown by monthly interest, minus the accumulated value of the payments made:
Bk = P(1 + r)k − M × ((1 + r)k − 1) / r
- Bk is the estimated balance after k payments, in dollars.
- P is the original loan 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 principal-and-interest payment, in dollars, rounded to cents.
For a fully amortizing fixed-rate loan, the scheduled payment is M = P × r / [1 − (1 + r)−n], where n is the total number of monthly payments, or years × 12. The calculator uses the payment rounded to the nearest cent when estimating the balance, reflecting how a real payment is denominated. Small differences can arise from lender-specific rounding and payment processing.
Worked Example
Using the calculator’s defaults: a $300,000 principal, 6% APR, 30-year term, and 60 payments made.
- Convert the annual rate to a monthly decimal: r = 6 ÷ 1200 = 0.005, or 0.5% per month.
- Calculate the number of scheduled payments: n = 30 × 12 = 360.
- Calculate the monthly principal-and-interest payment: M = 300,000 × 0.005 ÷ [1 − (1.005)−360] ≈ $1,798.65.
- Apply the balance formula after 60 payments: B60 = 300,000(1.005)60 − 1,798.65 × [(1.005)60 − 1] ÷ 0.005 ≈ $278,938.12.
- The 60 payments total 60 × $1,798.65 = $107,919.00. That is not the amount of principal repaid: early scheduled payments include a larger interest portion.
The estimated scheduled balance is $278,938.12. The exact unrounded result can vary slightly depending on the lender’s payment rounding and accounting conventions.
Assumptions
- The interest rate is fixed for the full period shown, and the loan has equal monthly principal-and-interest payments.
- Payments are made monthly on schedule; the balance is calculated immediately after the stated number of payments.
- Interest is compounded monthly using the APR divided by 12.
- The estimate excludes fees, taxes, homeowners insurance, mortgage insurance, escrow deposits, late charges, and other amounts not entered.
- The calculation assumes no extra principal payments, skipped or late payments, rate changes, refinancing, or loan modifications.
How to Use a Scheduled Balance
Use the calculator to estimate the remaining principal at a particular point in a loan’s planned repayment schedule. Enter the original amount borrowed—not the home’s current value—along with the loan’s stated APR and original term. Then enter the number of monthly payments already made. For example, 60 represents five years of monthly payments, provided none were missed or added.
The result is a model of principal outstanding, not a payoff quote. A payoff amount may also account for interest accrued since the last payment and other amounts due under the loan’s terms. For a transaction or exact payoff date, request the applicable figure from the loan servicer rather than treating this estimate as definitive.
Reading the Result and Common Confusions
A scheduled balance is not the same as the sum of future payments. Future payments include interest that has not yet accrued, while the balance estimate represents the principal remaining under the calculation’s assumptions. Nor is the balance the same as home equity: equity involves the home’s value and other relevant debts, which this calculator does not establish.
A frequent misconception is that paying a fixed amount each month reduces principal by that same amount. In a standard amortizing loan, each payment covers the interest due for that period first, with the remainder reducing principal. As the balance falls, the interest portion generally declines and a larger portion of each scheduled payment goes toward principal. This is why the balance does not usually decrease in a straight line.
Check that the payment count is consistent with the term. A 30-year monthly-payment loan has 360 scheduled payments; a count above the total term is outside the intended use of this calculator. Enter APR as a percent, such as 6 for 6%, not as 0.06. The formula converts the percentage to a monthly decimal. Rounding the monthly payment, APR, or payment count prematurely can shift the estimated balance.
What Can Make the Actual Balance Differ?
The calculation describes a simplified fixed-rate, level-payment schedule. An adjustable rate can change the payment and the pace at which principal is repaid. Extra principal payments, missed payments, payment timing, fees added to the account, or a different lender calculation method can also make the actual account balance diverge from the estimate. The entered APR may not by itself capture every loan cost or account charge.
For a useful comparison with a statement, use the same date and determine whether the statement shows principal balance, total amount due, or a payoff figure. Those are different quantities. A statement balance may be updated on a date that falls between payments, while this formula models the balance immediately after the specified scheduled payment. Ask the servicer to clarify a figure if its label or timing is unclear.
Frequently Asked Questions
What does scheduled balance mean on a home loan?
It is the principal expected to remain after a given number of on-time scheduled payments, based on the loan’s assumed rate and payment schedule.
Is scheduled balance the same as payoff amount?
No. A payoff quote can include accrued interest and other amounts due through a particular date. The scheduled balance calculator estimates principal under its stated assumptions.
Why does the balance fall slowly at first?
Each payment includes interest calculated on the outstanding principal. When the balance is relatively high, more of the scheduled payment goes to interest and less goes to principal.
Do extra payments change the scheduled balance?
Yes. Additional principal payments can reduce the balance faster than the original schedule assumes. This calculator does not include extra payments, so its result will not model that change.
Can I use this for a variable-rate home loan?
Only as a simplified estimate if you supply one rate for the entire modeled period. If the rate changed, the actual payment history and changing rates are needed for a more representative calculation.
This result is an educational estimate; the lender’s disclosure gives the exact figures.
Related
Formula used
in p | Original loan amount | $ | 300000 | 1 | 100000000 in apr | Interest rate (APR) | % | 6 | 0.01 | 100 in yrs | Loan term | years | 30 | 0.0833 | 50 in k | Payments made | - | 60 | 0 | 600 out bal | Scheduled 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 principal-and-interest payment | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2 out paid | Payments made to date | $ | 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
- United Test and Balance: What It Means in Finance
- Up-to-Date Loan Balance Calculator$16,611.20
- Trade Date Balance: Meaning and How It Works
- UBS Trade Date Balance: Meaning and How It Works
- Time Left on Loan Calculator: Estimate Payoff Time60 months
- The Balance in Journaling: Finding a Sustainable Practice