Annual Amortization Schedule Calculator and Loan Breakdown

An annual amortization schedule calculator shows how each year’s loan payments are divided between interest and principal, and how much balance remains. Enter the loan amount, annual percentage rate (APR), and term to estimate the monthly payment, total interest, and year-end balances.

Formula

This calculator uses the standard fixed-payment loan formula to find a monthly payment, then calculates total interest over the full term. It does not produce a year-by-year schedule table; use the recurrence below to calculate each annual balance and the interest and principal paid during each year.

Monthly payment: M = P × r ÷ [1 − (1 + r)⁻ⁿ]. Here, P is the starting loan principal in dollars, r is the monthly interest rate as a decimal (APR ÷ 1,200), n is the number of monthly payments (term in years × 12), and M is the monthly payment in dollars.

Total interest: I = M × n − P. Because the calculator’s payment is rounded to cents, this total uses that rounded payment.

To build the annual schedule, start with balance B₀ = P. For month t, interest is J_t = B_t−1 × r; principal repaid is C_t = M − J_t; and the new balance is B_t = B_t−1 − C_t. For each year, add its 12 monthly interest amounts and principal amounts. The balance after the year is the balance after that year’s twelfth payment.

Worked Example

Using the calculator’s default inputs—$20,000 principal, 8% APR, and a five-year term—there are 60 monthly payments. The monthly rate is 8 ÷ 1,200 = 0.0066667.

1. Monthly payment = 20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = $405.53, rounded to cents.
2. Total paid using the rounded payment = $405.53 × 60 = $24,331.80.
3. Total interest = $24,331.80 − $20,000 = $4,331.80.

For an annual view, the balance after k monthly payments can be calculated as B_k = P(1 + r)^k − M × [(1 + r)^k − 1] ÷ r. Applying this with the rounded payment gives an estimated balance of about $16,499.73 after 12 payments, $12,696.90 after 24, $8,571.33 after 36, and $4,098.02 after 48. The final payment may differ slightly from the regular payment because cent rounding can leave a small residual balance; the lender’s payoff schedule determines the actual final amount.

Assumptions

• The interest rate stays fixed throughout the term.
• Payments are level, made monthly, and applied at the end of each monthly period.
• Interest compounds monthly using APR ÷ 12.
• Fees, taxes, insurance, mortgage insurance, escrow, and extra payments are not included.

How to Read an Annual Amortization Schedule

A schedule commonly has columns for year, starting balance, payments made, principal repaid, interest charged, and ending balance. The annual payment total is generally 12 times the monthly payment, while the principal and interest portions vary over time. Each year’s principal reduction should equal the starting balance minus the ending balance, subject to rounding.

For a fully amortizing fixed-rate loan, interest is calculated on the outstanding balance. Early in the loan, that balance is larger, so a greater portion of each level payment goes to interest. As principal falls, the interest portion usually declines and more of each payment goes to principal. This does not mean the interest rate itself is rising or falling; the changing split follows from the changing balance.

“Annual” refers to the grouping of payments and balances by year, not necessarily to annual payments. A loan paid monthly can be summarized annually by adding the 12 monthly entries in each calendar or loan year. A schedule organized by calendar year may show a partial first or final year if payments begin partway through a calendar year.

When to Use It and What It Leaves Out

An annual schedule can help explain the path of a loan balance, estimate cumulative interest over a selected period, or compare the planned principal reduction with account statements. It is also useful when a reader wants a simpler yearly summary rather than a long list of individual monthly transactions. The calculator’s headline outputs are the monthly payment and total interest; annual balances require the separate balance calculation described above.

Enter the principal actually being financed, not the purchase price if a down payment or other financing changes the borrowed amount. Use the APR as a percentage—for example, enter 8 for 8%, not 0.08. The term field is in years. Get the actual rate, payment schedule, and any applicable charges from the lender’s loan disclosure; this calculator has no inputs for fees or a variable rate.

Common Errors and Limits

• Confusing APR with a monthly rate: The formula converts annual percentage APR to a monthly decimal by dividing by 1,200. Dividing by 12 alone leaves the rate in percentage units and produces an incorrect result.
• Rounding every intermediate step: Rounding monthly interest and balances to cents can make a manually built annual table differ by a few cents from a lender’s system. Keep extra precision in intermediate calculations and round displayed amounts consistently.
• Assuming every loan is level-payment: The formula applies to a fixed rate with equal monthly payments. Interest-only periods, variable rates, irregular payments, deferred payments, and balloon balances need different calculations.
• Reading total interest as the entire borrowing cost: It is only the modeled interest. Fees and other charges are excluded, and actual treatment can depend on the loan agreement.

Extra payments, payment dates that differ from the assumed timing, and lender-specific rounding can change the schedule. The formula is an estimate rather than an account ledger, and it does not calculate a payoff quote or account for a payment posted late or early.

Frequently Asked Questions

What is an annual amortization schedule?
An annual amortization schedule summarizes a loan’s payments, interest, principal reduction, and remaining balance by year. It can be created by grouping monthly schedule entries into yearly totals.

How do I calculate the balance after one year?
Use the balance formula with k = 12 monthly payments, the starting principal, monthly rate, and monthly payment. For later years, use k = 24, 36, and so on, or continue updating the balance one month at a time.

Why does the principal portion rise over time?
With a fixed rate and level payment, interest is charged on the remaining balance. As the balance declines, each month’s interest generally declines, leaving more of the same payment to reduce principal.

Does the calculator include extra payments?
No. It assumes the regular level payment only. Extra principal payments generally change the balance path and may affect the time or total interest, so they require a schedule that includes their amount and timing.

Why might my lender’s schedule differ?
The loan may have different payment dates, fees, rate terms, rounding conventions, or payment amounts. Compare the assumptions and use the lender’s disclosure or account schedule for the contractual figures.

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

Related

• Amortization Schedule With Annual Totals Calculator
• Amortization Schedule Using Payment Amount
• Amortization Schedule by Month: Payment and Interest

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