Yearly Amortization Schedule Calculator: Annual Loan Breakdown

A yearly amortization schedule calculator summarizes a fixed-rate loan’s payments by year, showing how much goes to principal and interest and what balance remains. Enter the loan amount, annual percentage rate (APR), and term; this calculator estimates the monthly payment and total interest, then explains how to build the yearly breakdown from those figures.

Formula

The calculator uses the standard fixed-payment loan formula. It calculates a monthly payment and total interest over the full term; the yearly schedule is obtained by grouping the monthly principal and interest portions into calendar or loan years.

• Monthly payment: M = P × r / [1 − (1 + r)⁻ⁿ]
• Total interest: I = M × n − P
• Monthly interest rate: r = APR / 1,200
• Number of monthly payments: n = years × 12

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, n is the number of monthly payments, M is the payment in dollars, and I is total interest in dollars. The payment output is rounded to cents. The total-interest output uses that rounded payment, as a real payment schedule would.

Worked Example

Using the calculator’s defaults—$20,000 principal, 8% APR, and a five-year term—the schedule has 60 monthly payments.

1. Convert APR to a monthly decimal rate: r = 8 / 1,200 = 0.0066667.
2. Find the number of payments: n = 5 × 12 = 60.
3. Substitute into the payment formula: M = 20,000 × 0.0066667 / [1 − (1.0066667)⁻⁶⁰].
4. Round the monthly payment to cents: $405.53.
5. Calculate total interest using the rounded payment: I = $405.53 × 60 − $20,000 = $4,331.80.

The yearly schedule is not simply $4,331.80 divided into equal annual interest amounts. Interest is calculated on the balance still outstanding, so the interest portion generally declines over time while the principal portion rises.

Assumptions

• The interest rate stays fixed for the entire term.
• Payments are equal monthly payments made at the end of each monthly period.
• Interest accrues monthly at APR divided by 12; the APR is treated as a nominal annual rate for this calculation.
• Fees, taxes, insurance, mortgage insurance, escrow, late charges, and additional payments are not included.

How a Yearly Amortization Schedule Works

Each monthly payment has two parts. Interest for the period is calculated on the balance before that payment. The rest of the payment reduces principal. In a standard level-payment loan, the payment remains the same, but its allocation changes as the balance falls.

For a particular month, calculate interest as the opening balance multiplied by the monthly rate. Subtract that interest from the monthly payment to get the principal reduction. Subtract the principal reduction from the opening balance to get the closing balance. Repeat for each month, then add that year’s 12 interest amounts and 12 principal amounts. The closing balance for one year becomes the opening balance for the next.

For example, on the default loan, the first month’s interest is approximately $133.33 ($20,000 × 0.0066667). Of the $405.53 payment, about $272.20 therefore reduces principal, leaving an estimated balance of $19,727.80. Small differences can occur when displayed values are rounded; calculations should retain extra precision internally and round the amounts shown.

When to Use a Yearly View

A yearly summary is useful when you want a broad view of how a balance changes over a loan term, rather than a line for every payment. It can help with budgeting and with understanding the timing of interest and principal, but it is an estimate based on the inputs and assumptions above—not a statement from a lender.

A complete annual table commonly includes these columns:

• Year number or the dates covered
• Opening balance
• Total payments made during the year
• Principal repaid during the year
• Interest charged during the year
• Closing balance

For a year containing 12 regular payments, annual payments equal 12 times the monthly payment. Principal paid is the opening balance minus the closing balance, provided there are no extra transactions. Interest paid can be checked by subtracting annual principal from annual payments. For a partial first or final year, include only the payments that fall in that period.

How to Read the Results and Avoid Errors

The calculator’s headline answer is the monthly payment, not a full year-by-year table. Its total-interest figure covers the entire modeled term. To produce yearly rows, apply the monthly balance steps above and aggregate by year; do not treat total interest as evenly distributed.

• Check the APR unit: enter 8 for 8%, not 0.08. The formula converts a percent to a monthly decimal by dividing by 1,200.
• Check the term unit: the input is years, and the formula multiplies it by 12 to get monthly periods.
• Do not confuse APR with a periodic rate: the calculation uses APR divided by 12. A loan with fees or a different interest calculation may not match this simplified model.
• Expect rounding differences: a lender may calculate interest daily, use different payment dates, or apply rounding at different stages. Summing displayed monthly figures can differ by cents from a balance calculated at full precision.
• Account for extra payments separately: they generally change the balance path and may shorten the payoff period, so this standard schedule does not include them.

Limits and Other Loan Structures

This formula describes a fully amortizing loan with a fixed rate and equal monthly payments. It does not model variable rates, interest-only periods, balloon payments, skipped or irregular payments, fees added to the balance, or payment changes. For those arrangements, a simple fixed-payment schedule may not reproduce the contract’s figures.

A yearly schedule and a monthly schedule represent the same payment process at different levels of detail. The monthly version shows exactly how each payment is divided; the yearly version totals those entries for easier overview. If a lender provides an amortization schedule or payment disclosure, use it for the contractual figures and compare the assumptions carefully.

Frequently Asked Questions

What is a yearly amortization schedule?
A yearly amortization schedule groups a loan’s payments by year and reports annual principal repaid, interest paid, and the remaining balance. It is derived from the loan’s payment-by-payment amortization.

How do I calculate yearly principal and interest?
For each month, calculate interest on the opening balance, subtract it from the payment to find principal repaid, and update the balance. Add the 12 monthly principal amounts and interest amounts for each full year.

Why does the interest portion decrease over time?
With a fixed rate and level payments, interest is charged on the outstanding balance. As principal is repaid, that balance falls, so less of each later payment is interest and more reduces principal.

Does this calculator show a complete yearly table?
No. It calculates the monthly payment and full-term total interest. The annual figures can be built by applying the stated monthly calculation and grouping the results into years.

Why might my lender’s schedule differ?
Differences can arise from payment dates, daily rather than monthly interest accrual, fees, rate changes, extra payments, or rounding conventions. Check the lender’s disclosed assumptions and figures.

This result is an estimate, and the lender’s disclosure gives the exact figures.

Related

• Truck Amortization Schedule Calculator and Example
• HELOC Amortization Schedule: How Payments Change
• Sample Amortization Schedule: Monthly Loan Breakdown

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