HomeLoanCalc.io home page

Annual Amortization Calculator: Build a Yearly Schedule

By Sohaib Ibrahim · Published November 18, 2026

Cover image for the article: Annual Amortization Calculator: Build a Yearly Schedule

The quickest way to use an annual amortization calculator is to enter the loan amount, the yearly interest rate and the term in years, find the one yearly payment with the formula payment = P × r ÷ (1 − (1 + r)^−n), and then split each payment into interest on the opening balance and principal. You can do it in a spreadsheet in about five minutes. The result is a table with one row per year showing the payment, interest, principal and remaining balance.

Most online tools assume you pay monthly. If your loan is paid once a year, as many farm, land and private loans are, a monthly tool understates your interest. A yearly loan lets interest build on the full balance for twelve months before you repay anything, and on a $100,000 loan that gap is worth thousands of dollars.

This guide covers four steps and carries one example through all of them: $100,000 at 6% over five years. You get the formula, a spreadsheet setup you can copy, the full yearly table, and a way to cross-check your numbers with the free Amortization Calculator at HomeLoanCalc.io.

Why annual payments change the amortization math

An annual amortization schedule lists one payment per year and shows how much of each payment pays interest and how much reduces the balance. Because you pay only once a year, interest accrues on the whole balance for twelve months before any principal comes off.

How yearly and monthly schedules differ

Take $100,000 at 6% over five years. Paid yearly, the payment is $23,739.64 once a year. Paid monthly at the same nominal rate, it is $1,933.28 sixty times. The yearly loan costs more in total because your balance falls only five times instead of sixty.

A side-by-side comparison of yearly and monthly payments on a $100,000 loan at 6% over five years.

How yearly and monthly schedules differ
Payment frequency Payment Number of payments Total paid Total interest
Annual $23,739.64 5 $118,698.19 $18,698.19
Monthly $1,933.28 60 $115,996.80 $15,996.80

The yearly schedule costs about $2,701 more in interest on this loan.

Paying once a year costs more interest than paying monthly, because the balance sits untouched for twelve months at a time.

When you need a yearly schedule

Reach for a yearly schedule when your loan agreement says "annual installment." That is common on farm and land loans, equipment financing, family loans and some business loans. Most home mortgages are paid monthly, so for those you are better off with a monthly calculator.

Step 1. Gather four loan inputs

You need four numbers from your loan agreement or term sheet before you calculate anything. Pull them out first so you do not guess halfway through.

A loan agreement with a pen, a desk calendar and a calculator on a desk.

The four numbers

  • Loan amount. The amount you actually borrow, after any down payment. In our example, $100,000.
  • Annual interest rate. The nominal yearly rate on the agreement. In our example, 6%.
  • Term in years. The number of yearly payments. In our example, 5.
  • Payment timing. Whether the first payment falls one year after the loan starts. This guide assumes payments at the end of each year.

Convert the rate if your lender compounds monthly

Some lenders quote a yearly rate that compounds monthly even though you pay once a year. In that case the rate you plug into the yearly formula is the effective annual rate: (1 + rate ÷ 12)^12 − 1. For a 6% rate compounded monthly, that comes to about 6.17%. If your agreement compounds yearly, use the stated rate as it is. The loan documents say which one applies, and if they do not, ask the lender before you build the schedule.

Use the rate that matches how interest compounds, not just the rate printed on the first page.

Step 2. Calculate the annual payment

The annual payment is the fixed amount that repays the loan in full over the term, and one formula gives it. Everything in the schedule builds on this single number.

The formula

Use this, where P is the loan amount, r is the yearly rate as a decimal and n is the number of years:

Payment = P × r ÷ (1 − (1 + r)^−n)

For our loan: 100,000 × 0.06 ÷ (1 − 1.06^−5) = 6,000 ÷ 0.252742 = $23,739.64. This is the standard fixed-rate amortization formula that lenders use, applied with one period per year.

The spreadsheet shortcut

Excel and Google Sheets do the same math with PMT. Put this in any cell:

=PMT(0.06, 5, -100000)

The negative sign on the loan amount makes the result positive. If you see a negative payment, the signs are the only problem. Change the three numbers to match your own loan.

One PMT cell or one formula gives you the payment, and every other number in the schedule follows from it.

Step 3. Build the yearly amortization schedule

Build the schedule by repeating three calculations for each year, using the previous year's closing balance as the new opening balance. Interest comes first, and principal is whatever is left of the payment.

The three rules per row

  1. Interest = opening balance × yearly rate.
  2. Principal = payment − interest.
  3. Closing balance = opening balance − principal.

Applying them to our loan gives this yearly amortization schedule:

The three rules per row
Year Payment Interest Principal Closing balance
1 $23,739.64 $6,000.00 $17,739.64 $82,260.36
2 $23,739.64 $4,935.62 $18,804.02 $63,456.34
3 $23,739.64 $3,807.38 $19,932.26 $43,524.08
4 $23,739.64 $2,611.44 $21,128.20 $22,395.88
5 $23,739.63 $1,343.75 $22,395.88 $0.00

In year 1, about 25% of your payment is interest. By year 5, it is under 6%. The last payment is a cent lower because of rounding, which is normal.

Set it up in a spreadsheet

Use columns for year, opening balance, payment, interest, principal and closing balance. Enter these formulas in rows 2 and 3, then fill row 3 down to your final year:

A laptop with a spreadsheet grid, a notepad with pencil and a calculator.

A2: 1
B2: 100000
C2: =PMT(0.06,5,-100000)
D2: =B2*0.06
E2: =C2-D2
F2: =B2-E2

A3: =A2+1
B3: =F2
C3: =C2
D3: =B3*0.06
E3: =C3-D3
F3: =B3-E3

Swap 0.06, 5 and 100000 for your own rate, term and loan amount.

Every row of a yearly schedule uses the same payment, so only the interest and principal split changes from year to year.

Step 4. Check the schedule and compare it

Check your work before you rely on the table. Three quick tests catch almost every error, and a second calculator shows what the same loan would cost if you paid monthly.

Three checks that catch errors

  • The principal column adds up to the loan amount. Here, $100,000.00.
  • The closing balance in the last year is zero, give or take a few cents of rounding.
  • Total interest equals total payments minus the loan amount. Here, $118,698.19 − $100,000 = $18,698.19.

If the balance never reaches zero, the usual cause is a rate typed as 6 instead of 0.06, or a term that does not match your payment count.

Cross-check with HomeLoanCalc.io

The Amortization Calculator at HomeLoanCalc.io takes the loan amount, annual interest rate and term in years, then returns the payment, total interest and total cost. You can switch the schedule between an annual summary and a detailed monthly view. It models monthly payments, so it will not reproduce a once-a-year payment. Use it to see what your loan would cost on a monthly schedule. For our example, it should show about $1,933.28 a month and roughly $16,000 of total interest.

If your lender lets you choose, that comparison tells you whether switching to monthly payments is worth asking about. To test paying extra principal, the Extra Mortgage Payment Calculator shows time and interest saved. In a yearly schedule the same logic holds: any extra amount lowers next year's opening balance, which lowers next year's interest. Treat every result as a planning estimate. The lender's own figures decide what you actually owe.

A yearly schedule is correct when the principal adds up, the balance ends at zero, and the interest total matches.

Your yearly schedule in short

To build an annual amortization schedule, gather the loan amount, rate and term, calculate one payment with the formula or PMT, then fill in interest, principal and balance for each year. Check that principal adds up to the loan and the balance ends at zero. Paying once a year costs more interest than paying monthly, so run both versions before you commit.

For a quick second opinion on the monthly side, try the free HomeLoanCalc.io Amortization Calculator. It needs no signup, and you can switch between an annual summary and a monthly view.

This article is for general information and is not financial advice. Confirm figures with your lender or an official source before you decide.

Run your own numbers

Use our free calculators to see what this means for your loan.

View calculators

More articles