Insider’s experts choose the best products and services to help make smart decisions with your money (here’s how). In some cases, we receive a commission from our our partners, however, our opinions are our own. Terms apply to offers listed on this page.
A mortgage amortization schedule provides the numbers that can help you decide which term length to get, or whether to refinance.
Tempura/Getty Images
What is a mortgage amortization schedule?
Amortization is the process of paying off a loan by making regular payments.
A mortgage amortization schedule shows how much you’ll pay each month toward your mortgage. The schedule breaks down each payment by showing how much of the payment goes toward your principal (the amount you borrow) and toward interest (the fee a lender charges for loaning you money).
The amortization schedule also tracks how much you have left to pay on your principal after each monthly payment is complete.
The schedule will show that you pay the same amount each month, but the amount you’ll pay toward the principal and interest changes monthly. More of your payment goes toward interest at the beginning, and by the end, most of your payment covers the principal.
This logic may seem weird, but think of it like this, assuming a hypothetical interest rate of 3.5%: 3.5% of $200,000 is less than 3.5% of $150,000, so it makes sense that you’re paying less in interest once you’ve paid down more of your principal.
A mortgage amortization schedule can help you keep track of how much you have left to pay on your mortgage and understand how much you’re paying toward interest. Tracking these numbers can help you make decisions, such as whether you want to refinance for a lower rate or make extra payments toward your principal. Or you just may want to stay informed about what you’re paying.
If you haven’t gotten a mortgage yet, sample mortgage amortization schedules can help you decide which term length you want to get. For instance, a schedule will reveal that a 30-year mortgage results in lower monthly payments than a 15-year mortgage, but also that you’ll pay a lot more in interest over the years.
You’ll have other monthly house-related expenses, like property taxes and insurance, but these aren’t factored into your amortization schedule, because they aren’t debt-related — you aren’t trying to pay off mortgage insurance the same way you’re trying to pay off a mortgage.
30-year mortgage amortization schedule example
Let’s look at an amortization schedule example for a 30-year mortgage. A 30-year fixed-rate mortgage requires you to pay off your loan for 30 years, or 360 months, and you’ll pay the same rate the entire time.
In this example, you have a $200,000 mortgage at a 3.5% interest rate. We’ve rounded each number to the nearest dollar. Here is your mortgage amortization schedule for the first year:
Month & YearMonthly PaymentPrincipalInterestBalanceJan. 2023$898$315$583$199,685Feb. 2023$898$316$582$199,370Mar. 2023$898$317$581$199,053Apr. 2023$898$318$581$198,735May 2023$898$318$580$198,417June 2023$898$319$579$198,098July 2023$898$320$578$197,777Aug. 2023$898$321$577$197,456Sep. 2023$898$322$576$197,134Oct. 2023$898$323$575$196,811Nov. 2023$898$324$574$196,487Dec. 2023$898$325$573$196,162
As you can see, you’ll pay $898 each month, with most of that money going toward interest at first. You’ll gradually start putting more toward the principal and less toward interest each month.
Now let’s look at your payment schedule for the last year of your 30-year mortgage:
Month & YearMonthly PaymentPrincipalInterestBalanceJan. 2053$898$867$31$9,708Feb 2053$898$870$28$8,838Mar. 2053$898$872$26$7,966Apr. 2053$898$875$23$7,091May 2053$898$877$21$6,214June 2053$898$880$18$5,334July 2053$898$883$16$4,451Aug. 2053$898$885$13$3,566Sep. 2053$898$888$10$2,679Oct. 2053$898$890$8$1,788 Nov. 2053$898$893$5$895Dec. 2053$898$895$3$0
Almost 30 years later, you’re still paying $898 per month, but most of your payment is going toward your principal.
15-year mortgage amortization schedule example
Let’s see how an amortization schedule breaks down for a 15-year fixed-rate mortgage. In this example, you’re borrowing $200,000 for 15 years, at a 3.25% interest rate. We’ve chosen a lower rate than we did for the 30-year example, because shorter terms usually come with lower interest rates.
Again, we’ve rounded each payment to the nearest dollar.
Month & YearMonthly PaymentPrincipalInterestBalanceJan. 2023$1,405$864$542$199,136Feb. 2023$1,405$866$539$198,270Mar. 2023$1,405$868$537$197,402Apr. 2023$1,405$871$535$196,531May 2023$1,405$873$532$195,658June 2023$1,405$875$530$194,783July 2023$1,405$878$528$193,905Aug. 2023$1,405$880$525$193,025Sep. 2023$1,405$883$523$192,142Oct. 2023$1,405$885$520$191,257Nov. 2023$1,405$887$518$190,370Dec. 2023$1,405$890$516$189,480
You’ll see quite a few differences with a 15-year mortgage than with a 30-year mortgage. First, monthly payments are several hundred dollars higher. Second, more money is going toward your principal than your interest right off the bat, because you have to put more toward the principal to pay off your mortgage in half the time.
You’ll also notice that your outstanding balance dwindles much faster with a 15-year mortgage.
Here is the amortization schedule for the final year of your hypothetical 15-year mortgage:
Month & YearMonthly PaymentPrincipalInterestBalanceJan. 2038$1,405$1,360$45$15,210Feb. 2038$1,405$1,364$41$13,846Mar. 2038$1,405$1,368$38$12,478Apr. 2038$1,405$1,372$34$11,107May 2038$1,405$1,375$30$9,732June 2038$1,405$1,379$26$8,353July 2038$1,405$1,383$23$6,970Aug. 2038$1,405$1,386$19$5,583Sep. 2038$1,405$1,390$15$4,193Oct. 2038$1,405$1,394$11$2,799 Nov. 2038$1,405$1,398$8$1,402Dec. 2038$1,405$1,402$4$0
Just like with a 30-year mortgage, almost all of your monthly payment is going toward the principal by the end of your term.
How extra payments affect your amortization schedule
You do have the option to pay extra toward your mortgage, which will alter your amortization schedule.
Paying extra can be a good way to save money in the long run, because the money will go toward your principal, not the interest. However, ask your lender if it charges any prepayment fees before you schedule an extra payment. You may decide paying the fee is worth it, but you don’t want any surprises.
There are couple ways to pay extra. You can pay a little more every month, or you can make one or more larger payments toward your mortgage.
For example, maybe you get a $5,000 bonus every May for your annual work anniversary, and you put that $5,000 straight toward your principal. Here’s how that extra payment would affect your mortgage amortization schedule for a 30-year mortgage:
Month & YearMonthly PaymentPrincipalInterestBalanceJan. 2023$898$315$583$199,685Feb. 2023$898$316$582$199,370Mar. 2023$898$317$581$199,053Apr. 2023$898$318$581$198,735May 2023$5,898$5,318$580$193,417June 2023$898$334$564$193,083July 2023$898$335$563$192,748Aug. 2023$898$336$562$192,412Sep. 2023$898$337$561$192,075Oct. 2023$898$338$560$191,737Nov. 2023$898$339$559$191,399Dec. 2023$898$340$558$191,059
Before your $5,000 payment, principal payments and interest payments only shift by around $1 per month. But the $5,000 payment alters both by $16 from May to June, and by the end of the year, you’ve paid off an extra $5,000 of your principal.
If you schedule a $5,000 payment every May, you’ll pay off your mortgage over 12 years earlier, and you’ll pay tens of thousands of dollars less in interest.
How to create a mortgage amortization schedule
You can ask your lender for an amortization schedule, but not all lenders offer them. They’ll likely say they can give you a monthly payment schedule, which won’t break down what goes toward the principal and interest each month.
The simplest way to see a personalized mortgage amortization schedule is to use an online calculator on websites like Bankrate or NerdWallet. Online calculators let you play around with how your schedule would change if you were to, say, get a 20-year term instead of a 30-year term, or pay a little extra every month.
You can also make your own amortization schedule on Microsoft Excel or Google Sheets. You don’t have to do all the math yourself — there are plenty of explainers online about what formulas to use to create an amortization table relatively quickly.
Either way, be prepared to enter the amount you borrow for your mortgage, the interest rate, and the term length to get accurate numbers. Hopefully, seeing the details of your payments will help you have a better handle on your money and make any big decisions about your mortgage.