Amortization Schedule by Year: Calculate Annual Totals

An amortization schedule by year groups a loan’s payments into annual totals, showing how much goes to principal and interest and what balance remains at each year-end. Enter the loan amount, APR, and term to calculate the fixed monthly payment and total interest; the yearly breakdown can then be built from those payment and balance figures.

Formula

The calculator uses the standard level-payment loan formula. It calculates a monthly payment that, under the stated assumptions, pays down the balance to zero over the selected number of months:

M = P × r / [1 − (1 + r)−n]

• P is the starting principal, in dollars.
• APR is the annual percentage rate entered as a percentage.
• r is the monthly rate as a decimal: APR ÷ 1,200.
• n is the number of monthly payments: years × 12.
• M is the monthly payment, rounded to cents.

Total interest in this calculator is monthly payment × number of payments − principal. Because the monthly payment is rounded to cents before the total is calculated, the total reflects repeated payments at that rounded amount. Small differences from a lender’s final figures can result from rounding, payment dates, fees, or a final adjusted payment.

Worked Example

Using the defaults—$20,000 principal, 8% APR, and a five-year term—the term is 5 × 12 = 60 monthly payments, and the monthly rate is 8 ÷ 1,200 = 0.0066667.

1. Monthly payment = 20,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)⁻⁶⁰].
2. The unrounded payment is about $405.53, so the payment rounded to cents is $405.53 per month.
3. Total of payments = $405.53 × 60 = $24,331.80.
4. Total interest = $24,331.80 − $20,000 = $4,331.80.

Those figures describe the full loan, not the amount paid in each individual year. To make an annual schedule, calculate each payment’s interest from that month’s opening balance, subtract it from the payment to find principal paid, and update the balance. Then add the 12 monthly principal and interest amounts for each full year.

Assumptions

• The APR and payment amount remain fixed for the modeled term.
• Payments are level monthly payments made at the end of each monthly period.
• Interest accrues monthly using APR ÷ 12; this is the calculator’s simplified monthly compounding convention.
• Fees, taxes, insurance, mortgage insurance, and escrow are not included.

How an Annual Amortization Schedule Works

Amortization means paying down debt through scheduled payments. Each payment contains interest for the period and principal that reduces the amount owed. With a fixed rate and level payment, the total payment stays the same, but its components change: as principal falls, the interest charge generally falls too, leaving more of the payment to reduce principal.

For month t, a basic schedule uses these calculations:

• Interest = opening balance × monthly rate.
• Principal paid = monthly payment − interest.
• Closing balance = opening balance − principal paid.

The next month begins with the previous month’s closing balance. An annual table is a summary of those monthly rows. A useful table has columns for year, opening balance, payments made, principal repaid, interest paid, and closing balance. The first year’s opening balance is the original principal; each later year begins with the prior year’s ending balance.

For a term shorter than 12 months, the final schedule year contains only the remaining payments. For a longer term, a calendar-year summary may contain payments from two different loan years, depending on the start date. “Year” should therefore be defined as either a 12-payment loan year or a calendar year.

Building the Year-by-Year Breakdown

The calculator provides the payment and whole-loan interest total; it does not display each annual row. To create a by-year schedule, apply the monthly calculations repeatedly, grouping every 12 payments. For example, if the monthly payment is $405.53, the scheduled payment total for a complete 12-payment year is $4,866.36. That figure is not the year’s principal reduction: part of it pays interest.

The year-end balance can also be calculated directly after k payments, where k is the number of monthly payments completed:

Bk = P(1 + r)k − M × [(1 + r)k − 1] ÷ r

Here, B_k is the remaining balance, P is starting principal, r is the monthly rate, and M is the monthly payment. For the end of the first full year, use k = 12; for the second, use k = 24. Annual principal repaid is the opening balance minus closing balance. Annual interest can be found by adding monthly interest entries, or by subtracting that year’s principal reduction from that year’s payments.

As a consistency check, annual principal reductions should add up to the original principal by the end of the loan, subject to rounding. Annual interest totals should add up to total interest. If they do not, check whether the final partial year, payment dates, extra payments, or rounding treatment was handled differently.

Reading Results and Common Mistakes

• Confusing interest with the payment: the payment includes both interest and principal; it is not all interest.
• Calling all annual totals equal: the scheduled payment total is usually the same for each full year in a fixed-payment model, but principal and interest portions change.
• Mixing APR and monthly rate: enter an annual percentage such as 8, not 0.08. The formula converts it to a monthly decimal by dividing by 1,200.
• Assuming calendar years: the calculator’s term is measured in 12-month periods, not necessarily January through December.
• Ignoring rounding: calculating with unrounded payments and then comparing with a cent-rounded schedule can create small discrepancies. Actual servicing may adjust a final payment.
• Leaving out extra payments: an additional principal payment changes later balances and interest, so a standard schedule will not represent that payment pattern.

What the Estimate Does Not Show

This calculation assumes a fixed APR and regular monthly payments. It does not model variable rates, irregular payment dates, skipped or late payments, payment holidays, additional principal, fees, or a lender’s particular day-count and rounding practices. A changing rate requires recalculating future interest using the applicable rate and balance; the schedule cannot be inferred from one fixed-rate result.

The entered APR is an input, not a claim about what a lender currently offers. Use the rate and payment terms supplied for the specific loan when making an estimate. A disclosed payment can differ if it includes charges or uses different assumptions. The result is an estimate, and the lender’s disclosure gives the exact figures.

Frequently Asked Questions

What does an amortization schedule by year show?
It summarizes each year’s payments, principal repaid, interest paid, and remaining balance. A detailed schedule starts with monthly rows and groups them into years.

Why does the principal portion increase each year?
With a fixed rate and level payment, interest is calculated on the outstanding balance. As that balance declines, less of a payment goes to interest and more goes to principal.

Is annual payment total the same as annual principal paid?
No. Annual payment total includes both principal and interest. Annual principal paid is only the part that reduces the balance.

How do I calculate the balance after one year?
Use the balance formula with 12 completed payments, or apply the monthly interest, principal, and closing-balance steps 12 times. The answer depends on the starting principal, monthly rate, and payment.

Does an extra payment change an amortization schedule?
Yes. If an extra amount is applied to principal, the balance falls faster, which generally changes subsequent interest and may shorten the payoff period. This calculator does not include extra payments.

Why might my lender’s schedule differ?
Differences can come from the exact APR, payment timing, fees, extra payments, daily interest conventions, or rounding. Compare the assumptions and use the lender’s disclosed figures for the actual account.

Related

• Prime Interest Rate: Meaning and How It Works
• Interest Rate Parity: Meaning, Formula and Example
• Interest Rate Parity Formula and Calculator

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 | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2