The end-of-year balance calculator estimates how much principal remains on a fixed-rate loan after one year of monthly payments. Enter the original loan amount, APR, and term to see the balance after 12 payments, along with the estimated monthly payment and total interest over the full term.
Formula
The balance after 12 monthly payments is the original principal grown at the monthly rate for 12 months, minus the accumulated value of those 12 payments:
B12 = P(1 + r)12 − M × ((1 + r)12 − 1) / r
- B12 is the estimated balance after one year, in dollars.
- P is the original loan principal, in dollars.
- r is the monthly interest rate as a decimal: APR ÷ 1,200.
- M is the monthly payment in dollars, rounded to cents.
The monthly payment is calculated using the standard level-payment formula: M = P × r / (1 − (1 + r)−n), where n is the total number of monthly payments (term in years × 12). Total interest is estimated as the rounded monthly payment multiplied by the number of payments, minus the original principal.
Worked Example
Using the calculator’s default values—$20,000 principal, 8% APR, and a five-year term—the term is 60 months and the monthly rate is 0.08 ÷ 12 = 0.0066667.
- Calculate the unrounded payment: $20,000 × 0.0066667 ÷ (1 − (1.0066667)−60) ≈ $405.53.
- Use the cent-rounded payment of $405.53 in the balance calculation: $20,000 × (1.0066667)12 − $405.53 × ((1.0066667)12 − 1) ÷ 0.0066667.
- The estimated balance after 12 payments is $16,414.27.
- Total scheduled payments are $405.53 × 60 = $24,331.80. Estimated total interest is $24,331.80 − $20,000 = $4,331.80.
Assumptions
- The interest rate stays fixed for the entire loan term.
- Payments are equal, made monthly, and applied at the end of each monthly period.
- Interest compounds monthly at APR divided by 12.
- Fees, taxes, insurance, escrow, and any separate charges are not included.
What an End-of-Year Balance Means
An end-of-year balance is the amount of principal still owed after the payments for the first 12 months have been credited. It is not the amount originally borrowed, the sum of the next year’s payments, or necessarily the payoff quote a lender would provide on a particular date. The balance changes over time as interest accrues and payments are applied.
With a standard amortizing loan, each payment covers interest accrued for that period and reduces principal by the amount left over. Early in the schedule, the interest portion is often larger because interest is calculated on a higher outstanding balance. As the principal declines, less interest accrues each month and a larger share of a level payment goes toward principal.
For example, the calculator’s default loan has $3,000 in scheduled payments during its first year, but the balance falls by about $3,585.73? No: that would be inconsistent, because the first-year payments total $4,866.36 and also cover the interest accrued during the year. The balance falls from $20,000 to $16,414.27, a principal reduction of $3,585.73. This distinction is why payment totals and balance reduction should not be treated as the same quantity.
When to Use the Estimate
This calculation can help explain an amortization schedule or provide a rough comparison point when reviewing a loan statement. It answers a specific question: under the entered assumptions, what balance remains immediately after 12 regular monthly payments? The figure is a mathematical estimate, not an account balance retrieved from a lender.
For a different point in the schedule, use the same balance formula with the number of payments actually made in place of 12. For instance, the balance after 24 payments uses (1 + r)24 and the accumulated value of 24 payments. A calculator designed for the exact number of months is more convenient when checking a date other than the end of year one.
Common Differences from a Statement
A lender’s reported balance may not match this result because the calculator uses a simplified, regular monthly schedule. Payment dates, rounding practices, the way interest accrues between payment dates, and the timing of payments can all affect the displayed amount. A statement may also show accrued interest or other account adjustments separately.
- Extra or missed payments: The estimate assumes exactly 12 equal payments. Additional principal payments generally change the remaining balance; late or skipped payments also alter the schedule.
- Variable rates: The calculation assumes one fixed APR. A rate change means the monthly rate is not constant and requires a schedule that reflects each rate period.
- Fees and add-ons: Charges financed into the loan, account fees, and other costs are not represented unless included in the entered principal or modeled separately.
- Rounding: The monthly payment is rounded to cents before calculating the balance and total interest. Small differences can result if a lender rounds interest separately each month.
Do not confuse an amortization balance with a payoff amount. A payoff figure may include interest accrued since the latest payment and other account-specific amounts, so it can differ from a balance calculated at a month-end boundary.
Frequently Asked Questions
How do I calculate my loan balance after one year?
Find the monthly rate by dividing APR by 1,200, calculate the fixed monthly payment, then apply the balance formula after 12 payments. The calculator performs these steps using the principal, APR, and term you enter.
Does the end-of-year balance include interest?
The remaining balance reflects interest accrued and payments applied during the modeled periods. It is not simply the original principal minus 12 payments, because part of each payment covers interest.
Why is my lender’s balance different?
Possible reasons include a different payment date, daily interest accrual, extra payments, variable rates, rounding, fees, or a balance that includes accrued interest. The lender’s account statement or payoff information is specific to the actual loan.
Is the balance after 12 payments the payoff amount?
Not necessarily. A payoff amount can include interest through a specified date and account-specific adjustments, while this estimate assumes a regular monthly schedule and a balance just after payment 12.
Can I use this for a variable-rate loan?
Only as a rough illustration if you enter a single rate. A variable-rate loan needs a calculation that accounts for each rate change and any resulting payment adjustment.
This result is an estimate, and 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 bal | Balance after one year | $ | p * (1 + apr / 1200) ^ 12 - round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) * ((1 + apr / 1200) ^ 12 - 1) / (apr / 1200) | 2 out pmt | Monthly payment | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 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
- 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