Amortization Schedule

An amortization schedule is a table that shows how each payment on a loan is divided between principal and interest over the entire life of the loan. It maps out the gradual reduction of the loan balance from the first payment to the last, revealing exactly how much of each monthly payment goes toward reducing the debt and how much goes toward the cost of borrowing.

How Amortization Works

In a standard fully amortizing mortgage, the monthly payment amount stays the same for the entire term, but the allocation between principal and interest shifts dramatically over time. Early payments are almost entirely interest. Late payments are almost entirely principal.

This happens because interest is calculated on the outstanding balance. When the balance is high at the beginning of the loan, the interest charge consumes most of the payment. As the balance decreases, the interest charge shrinks, and more of the fixed payment goes toward reducing principal.

Example: $100,000 Loan at 6% for 30 Years

After five years (60 payments) of a 30-year loan, the borrower has paid over $35,000 total but reduced the balance by less than $7,000. This front-loading of interest is one of the fundamental mechanics that makes mortgage note investing powerful -- borrowers who have been paying for years may still owe far more than investors expect.

Why Amortization Schedules Matter to Note Investors

Pricing Performing and Re-Performing Loans

When evaluating a performing loan or re-performing loan, the amortization schedule tells you exactly what the future cash flow stream looks like. You can calculate the remaining principal balance at any point in the future, project total interest income, and determine whether the price you are paying delivers your target yield.

Structuring Loan Modifications

When you modify a non-performing loan into a new payment plan, you are creating a new amortization schedule. The key variables you control are:

• Principal balance -- the UPB or a negotiated reduced balance
• Interest rate -- market rate or a discounted rate to improve affordability
• Term -- the number of months over which the loan will be repaid
• Structure -- fully amortizing, interest-only, or balloon

Each combination produces a different monthly payment and a different amortization schedule. The goal is to find the combination that the borrower can realistically afford while delivering an acceptable return. Going beyond 30 years is generally not recommended -- the difference in monthly payment between a 30-year and a 40-year amortization is often just a few dollars, while adding a full decade of payments.

Modeling Partial Sales

When selling a partial interest in a note -- for example, the first 60 payments -- the amortization schedule shows you exactly how much principal will be paid down during those 60 payments and what balance will remain when the partial expires and your reversion interest begins. Without modeling both the partial buyer's schedule and the underlying loan's schedule, you cannot accurately assess your reversion value.

Amortization Schedule Variations

Building an Amortization Schedule

The monthly payment for a fully amortizing loan is calculated using the standard annuity formula:

Payment = P x [r(1+r)^n] / [(1+r)^n - 1]

Where P is the principal balance, r is the monthly interest rate (annual rate divided by 12), and n is the total number of payments.

From there, each row of the schedule is calculated iteratively:

1. Interest = Remaining balance x monthly interest rate
2. Principal = Monthly payment - interest
3. New balance = Previous balance - principal paid

Spreadsheet tools and financial calculators automate this process. Most loan servicers can also generate amortization schedules for any loan in their portfolio. For note investors who regularly model modifications and pricing scenarios, building a reusable amortization template in a spreadsheet is a foundational skill.