Personal Finance Insider writes about products, strategies, and tips to help you make smart decisions with your money. We may receive a small commission from our partners, like American Express, but our reporting and recommendations are always independent and objective. Terms apply to offers listed on this page. Read our editorial standards.
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 & Year | Monthly Payment | Principal | Interest | Balance |
Jan. 2022 | $898 | $315 | $583 | $199,685 |
Feb. 2022 | $898 | $316 | $582 | $199,370 |
Mar. 2022 | $898 | $317 | $581 | $199,053 |
Apr. 2022 | $898 | $318 | $581 | $198,735 |
May 2022 | $898 | $318 | $580 | $198,417 |
June 2022 | $898 | $319 | $579 | $198,098 |
July 2022 | $898 | $320 | $578 | $197,777 |
Aug. 2022 | $898 | $321 | $577 | $197,456 |
Sep. 2022 | $898 | $322 | $576 | $197,134 |
Oct. 2022 | $898 | $323 | $575 | $196,811 |
Nov. 2022 | $898 | $324 | $574 | $196,487 |
Dec. 2022 | $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 & Year | Monthly Payment | Principal | Interest | Balance |
Jan. 2052 | $898 | $867 | $31 | $9,708 |
Feb 2052 | $898 | $870 | $28 | $8,838 |
Mar. 2052 | $898 | $872 | $26 | $7,966 |
Apr. 2052 | $898 | $875 | $23 | $7,091 |
May 2052 | $898 | $877 | $21 | $6,214 |
June 2052 | $898 | $880 | $18 | $5,334 |
July 2052 | $898 | $883 | $16 | $4,451 |
Aug. 2052 | $898 | $885 | $13 | $3,566 |
Sep. 2052 | $898 | $888 | $10 | $2,679 |
Oct. 2052 | $898 | $890 | $8 | $1,788 |
Nov. 2052 | $898 | $893 | $5 | $895 |
Dec. 2052 | $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 & Year | Monthly Payment | Principal | Interest | Balance |
Jan. 2022 | $1,405 | $864 | $542 | $199,136 |
Feb. 2022 | $1,405 | $866 | $539 | $198,270 |
Mar. 2022 | $1,405 | $868 | $537 | $197,402 |
Apr. 2022 | $1,405 | $871 | $535 | $196,531 |
May 2022 | $1,405 | $873 | $532 | $195,658 |
June 2022 | $1,405 | $875 | $530 | $194,783 |
July 2022 | $1,405 | $878 | $528 | $193,905 |
Aug. 2022 | $1,405 | $880 | $525 | $193,025 |
Sep. 2022 | $1,405 | $883 | $523 | $192,142 |
Oct. 2022 | $1,405 | $885 | $520 | $191,257 |
Nov. 2022 | $1,405 | $887 | $518 | $190,370 |
Dec. 2022 | $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 & Year | Monthly Payment | Principal | Interest | Balance |
Jan. 2037 | $1,405 | $1,360 | $45 | $15,210 |
Feb. 2037 | $1,405 | $1,364 | $41 | $13,846 |
Mar. 2037 | $1,405 | $1,368 | $38 | $12,478 |
Apr. 2037 | $1,405 | $1,372 | $34 | $11,107 |
May 2037 | $1,405 | $1,375 | $30 | $9,732 |
June 2037 | $1,405 | $1,379 | $26 | $8,353 |
July 2037 | $1,405 | $1,383 | $23 | $6,970 |
Aug. 2037 | $1,405 | $1,386 | $19 | $5,583 |
Sep. 2037 | $1,405 | $1,390 | $15 | $4,193 |
Oct. 2037 | $1,405 | $1,394 | $11 | $2,799 |
Nov. 2037 | $1,405 | $1,398 | $8 | $1,402 |
Dec. 2037 | $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 & Year | Monthly Payment | Principal | Interest | Balance |
Jan. 2021 | $898 | $315 | $583 | $199,685 |
Feb. 2021 | $898 | $316 | $582 | $199,370 |
Mar. 2021 | $898 | $317 | $581 | $199,053 |
Apr. 2021 | $898 | $318 | $581 | $198,735 |
May 2021 | $5,898 | $5,318 | $580 | $193,417 |
June 2021 | $898 | $334 | $564 | $193,083 |
July 2021 | $898 | $335 | $563 | $192,748 |
Aug. 2021 | $898 | $336 | $562 | $192,412 |
Sep. 2021 | $898 | $337 | $561 | $192,075 |
Oct. 2021 | $898 | $338 | $560 | $191,737 |
Nov. 2021 | $898 | $339 | $559 | $191,399 |
Dec. 2021 | $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.
Powered by WPeMatico