How to Calculate Loan Amortization: Step-by-Step Guide (with Examples)

Step 1: Gather Your Loan Details

Before you can calculate loan amortization, you need three key pieces of information: the loan principal (the amount you borrow), the annual interest rate, and the total number of payments you will make. For a fixed-rate loan, these are set at the start.

You'll also need to know how often you make payments—typically monthly, but some loans have quarterly or other schedules. The examples below use monthly payments, which is the most common for mortgages and auto loans.

• Loan principal (P): the original amount borrowed
• Annual interest rate (as a decimal or percentage)
• Number of payments (n): total payments over the loan term

Sources: Investopedia, Consumer Financial Protection Bureau (CFPB)

Step 2: Calculate Monthly Payment Using the Formula

With your loan details in hand, you can calculate the fixed monthly payment using a standard amortization formula. The formula is: M = P × [r(1+r)^n] / [(1+r)^n − 1], where M is the monthly payment, P is the loan principal, r is the monthly interest rate (annual rate divided by 12), and n is the total number of monthly payments. Investopedia presents this formula in its explanation of amortization schedules.

As an example, consider a $30,000 car loan with a 3% annual interest rate for 4 years. The total number of payments is 4 years × 12 months = 48. Plugging these into the formula gives a monthly payment of $664.03, as shown in Investopedia's worked example.

This payment amount is your fixed monthly obligation for the life of the loan. In the next step, you'll split that payment into interest and principal parts for each period.

Sources: Investopedia, Wall Street Prep

Step 3: Build the Amortization Schedule

An amortization schedule is a table that shows, for each payment period, the interest due, the principal paid, and the remaining balance. The process is repetitive and follows a clear pattern.

For each period, follow these steps:

First, calculate the interest for that period by multiplying the current outstanding balance by the monthly interest rate. Then subtract that interest amount from your total monthly payment to find the principal portion. Finally, subtract the principal portion from the previous balance to get the new outstanding balance. Repeat this for each subsequent period.

Using the car loan example, the first month's interest is $30,000 × 0.0025 = $75. For the next month, you'd compute interest on that new balance, and so on.

1. Calculate the interest for the period: outstanding balance × monthly interest rate.
2. Determine the principal portion: total payment − interest for the period.
3. Update the balance: previous balance − principal portion.
4. Repeat for each payment period

Sources: Investopedia, Wall Street Prep

Step 4: Verify Your Schedule

After building the schedule, it's wise to check its accuracy. A simple check is to confirm that the final balance after the last payment is zero (or a very small rounding difference). You can also verify that the total of all principal portions equals the original loan amount, and that the sum of all interest portions matches the total interest paid over the life of the loan.

Cross-checking your manual schedule against an online calculator or a spreadsheet function can help catch errors. Many financial calculators and websites provide amortization schedules, but they may not include outside costs like taxes or insurance.

• Sum of principal payments equals the loan principal.
• Compare with a reliable calculator to catch mistakes.

Sources: Investopedia, Wall Street Prep, Consumer Financial Protection Bureau (CFPB)

Using Online Amortization Calculators

Online calculators can quickly produce an amortization schedule, but keep in mind their limitations. Most mortgage calculators, for example, compute only principal and interest. They do not automatically include property taxes, homeowner's insurance, mortgage insurance, or homeowners association (HOA) dues. To get a true picture of your monthly housing cost, you need to add those items separately.

When you use an online tool, double-check that it uses the same payment frequency and interest rate structure you expect. If the results differ from your manual calculation, re-check your inputs and the calculator's assumptions.

To generate a schedule with an online calculator, start by entering the loan amount, annual interest rate, and loan term in years or months. Then choose the payment frequency (usually monthly). The calculator will display the monthly payment and often a full amortization schedule. Review the schedule to ensure the final balance reaches zero and that the payment amount matches your manual calculation.

• Most calculators handle only principal and interest.
• Add taxes, insurance, and HOA dues yourself.
• Verify calculator assumptions against your loan terms.

Sources: Consumer Financial Protection Bureau (CFPB)

Using Spreadsheet Templates (Excel/Google Sheets)

Spreadsheets offer a flexible way to build an amortization schedule and explore different loan scenarios. In Excel or Google Sheets, you can recreate the manual steps with formulas, or use built-in financial functions to speed up the process.

Three functions are particularly useful: PMT calculates the fixed periodic payment, PPMT returns the principal portion of a payment for a given period, and IPMT returns the interest portion for that period. Wall Street Prep highlights these functions in its amortization tutorial. You can build a schedule by entering the loan terms, then using these functions to fill in each row.

With a spreadsheet, you can easily change the interest rate, term, or principal to see how your payment and schedule change. This is a good way to test different loan scenarios before committing.

• PMT: calculates the monthly payment.
• IPMT: returns the interest portion for a given period.
• PPMT: returns the principal portion for a given period.

Sources: Wall Street Prep

Common Mistakes to Avoid

When calculating loan amortization, a few common errors can lead to incorrect schedules. One is using the annual interest rate instead of the monthly rate in the payment formula—remember to divide by 12 if you're making monthly payments. Another is mixing up the order of operations or forgetting to subtract the interest from the payment before applying it to the principal.

Also, be aware that some calculators only show principal and interest and omit costs like taxes and insurance. Always account for these separately if you're estimating your total payment. And if your loan has a different payment frequency, adjust the rate and number of periods accordingly, because the formula assumes consistent periods.

• Using annual rate instead of monthly rate.
• Forgetting to subtract interest before reducing principal.
• Ignoring taxes, insurance, or other fees in total cost.

Sources: Investopedia, Wall Street Prep, Consumer Financial Protection Bureau (CFPB)