- What is a mortgage amortization schedule?
- How does it work?
- How to read it
- How to create a mortgage amortization schedule
- FAQs
Affiliate links for the products on this page are from partners that compensate us (see our advertiser disclosure with our list of partners for more details). However, our opinions are our own. See how we rate mortgages to write unbiased product reviews.
Mortgages can be expensive, so it's important to understand just what you're getting into before taking one out.
An amortization schedule can help you do this. These financial breakdowns detail how much you'll pay for your mortgage each month, as well as what portion of it goes toward interest and your principal balance.
Are you preparing to take out a mortgage? Here's what to know about amortization before you do.
What is a mortgage amortization schedule?
Amortization is when you spread the cost of something out over even payments across a set period of time. A schedule helps you understand those costs in more detail.
Definition
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 mortgage 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.
Purpose
An amortization 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 your mortgage for a lower rate or make extra mortgage 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.
How does a mortgage amortization schedule work?
Here's how a mortgage amortization schedule works and how to calculate yours.
Amortization calculation
Calculating an amortization schedule is a little complicated. You'll need to know the initial loan amount, the interest rate, and the length of the loan.
The exact formula for calculating the monthly payment is:
Loan amount x [monthly interest x (1 + monthly interest)number of payments / (1 + monthly interest)number of payments -1]
If you don't want to calculate amortization yourself, there are plenty of online tools that can do it for you. We'll go more into this later on.
Early payments are mostly interest, with a gradual shift toward principal
Due to the nature of amortization, your early payments are largely interest. By the time you get to the end of your loan, you're paying much more toward the principal balance instead.
To see how this works in action, 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. 2024 | $898 | $315 | $583 | $199,685 |
Feb. 2024 | $898 | $316 | $582 | $199,370 |
Mar. 2024 | $898 | $317 | $581 | $199,053 |
Apr. 2024 | $898 | $318 | $581 | $198,735 |
May 2024 | $898 | $318 | $580 | $198,417 |
June 2024 | $898 | $319 | $579 | $198,098 |
July 2024 | $898 | $320 | $578 | $197,777 |
Aug. 2024 | $898 | $321 | $577 | $197,456 |
Sep. 2024 | $898 | $322 | $576 | $197,134 |
Oct. 2024 | $898 | $323 | $575 | $196,811 |
Nov. 2024 | $898 | $324 | $574 | $196,487 |
Dec. 2024 | $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. 2054 | $898 | $867 | $31 | $9,708 |
Feb 2054 | $898 | $870 | $28 | $8,838 |
Mar. 2054 | $898 | $872 | $26 | $7,966 |
Apr. 2054 | $898 | $875 | $23 | $7,091 |
May 2054 | $898 | $877 | $21 | $6,214 |
June 2054 | $898 | $880 | $18 | $5,334 |
July 2054 | $898 | $883 | $16 | $4,451 |
Aug. 2054 | $898 | $885 | $13 | $3,566 |
Sep. 2054 | $898 | $888 | $10 | $2,679 |
Oct. 2054 | $898 | $890 | $8 | $1,788 |
Nov. 2054 | $898 | $893 | $5 | $895 |
Dec. 2054 | $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.
Final payment
As you can see in the above example, you're making the same payment for every month no matter what year of the loan you're in. The difference is how much goes toward principal and how much goes toward interest.
When you make your final monthly payment (in December 2054, in the above example), you will have fully paid off the loan.
How to read a mortgage amortization schedule
An amortization schedule comes with a bunch of numbers. Here's how you can read yours.
Column breakdown
These are the columns you'll typically see in an amortization schedule and what they each mean:
- Payment number: This is the number of payments you've made so far on the loan.
- Payment date: This is the month the payment is due.
- Beginning balance: This one notes what the total loan balance is prior to the current payment.
- Payment amount: This is your monthly payment.
- Principal paid: This one is how much of your payment is going toward the principal balance for the month.
- Interest paid: This is how much of your payment is going toward interest.
- Ending balance: This is your new loan balance once the payment has been applied.
Interpreting the data
Amortization schedules make it easy to spot trends in your payments and track your loan balance as you move further into your loan term. They can also help you understand how much you're currently paying toward principal and interest.
Why is an amortization schedule important?
An amortization schedule can be a valuable tool when weighing your mortgage options, as well as once you're already in a home. You can use one for:
Financial planning
You can use amortization schedules to compare different mortgage options and to ensure a mortgage loan meets your financial needs and budget. It can also help you understand your long-term financial commitment when taking out a loan.
Tracking progress
Once you have a mortgage, you can also use amortization schedules to track your payoff progress. It clearly breaks down what you've paid down, what you have left, and how quickly you're progressing in your payoff timeline.
Evaluating refinancing or early payoff
You can also use amortization schedules to evaluate how extra payments or paying off your loan early could benefit you financially. If you're considering a refinance, an amortization schedule can also clue you into the financial savings your new loan might net you.
How to create a mortgage amortization schedule
You can ask your lender for an amortization schedule, but this might not be as helpful if you're looking to see how extra payments could impact that schedule. Fortunately, there are other options, too.
Online calculators
The simplest way to see a personalized mortgage amortization schedule is to use an online calculator on websites like HSH. 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.
Spreadsheets
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.
Mortgage amortization schedule FAQs
What happens if I miss a mortgage payment? Chevron icon It indicates an expandable section or menu, or sometimes previous / next navigation options.If you miss a mortgage payment, late fees will typically apply, and it could negatively impact your credit score. If you miss several payments, your lender could foreclose on your house. If you think you may have trouble making payments, contact your lender immediately for options.
Can I pay off my mortgage early? Chevron icon It indicates an expandable section or menu, or sometimes previous / next navigation options.Yes, you can usually make extra principal payments to accelerate your mortgage loan payoff. Check with your lender to see if you'd owe any prepayment penalties first.
How does refinancing affect my amortization schedule? Chevron icon It indicates an expandable section or menu, or sometimes previous / next navigation options.Refinancing creates a new loan with a new amortization schedule based on the new loan amount, interest rate, and term. Make sure you compare the amortization tables for both loans to fully understand your long-term costs.
How can I calculate amortization? Chevron icon It indicates an expandable section or menu, or sometimes previous / next navigation options.While you can learn how to calculate mortgage amortization manually, it's easiest to use an online calculator or ask your lender for an amortization schedule.
What are the benefits of an amortization schedule? Chevron icon It indicates an expandable section or menu, or sometimes previous / next navigation options.The big perks of an amortization schedule is that it can help you understand the progress you're making toward paying off your loan. You can also see how much of your payments are being put toward your principal balance and interest.
What's the difference between mortgage amortization vs. loan payoff? Chevron icon It indicates an expandable section or menu, or sometimes previous / next navigation options.Amortization is spreading your total loan costs out over a length of time in equal monthly payments. An amortization schedule can help you understand your loan payoff progress.
Laura Grace Tarpley, CEPF Personal Finance Reviews Editor Laura Grace Tarpley (she/her) is an expert in mortgage rates, refinance rates, lenders, bank accounts, and borrowing and savings tips for Personal Finance Insider. She worked on Business Insider's "The Road to Home" series, which won a Silver award from the National Associate of Real Estate Editors.She has written about personal finance for over seven years. Before joining the Business Insider team, she was a freelance finance writer for companies like SoFi and The Penny Hoarder, as well as an editor at FluentU. Read more Read less Aly J. Yale Aly J. Yale is a writer and editor with more than 10 years of experience covering personal finance topics including mortgages and real estate. She contributes to Personal Finance Insider’s mortgages and loans coverage.ExperienceAly began her journalism career as reporter, and later an editor, for several neighborhood sections of the Dallas Morning News.Her work has been published in several national publications, including Bankrate, CBS, Forbes, Fortune, Money, Newsweek, US News and World Report, the Wall Street Journal, and Yahoo Finance. She’s also contributed to a variety of mortgage and real-estate publications, such as The Balance, Builder Magazine, Housingwire, MReport, and The Mortgage Reports. Her favorite personal finance tip is to schedule regular check-ins to make sure your credit cards, savings accounts, and other financial vehicles still align with your budget and financial goals. She is a member of the National Association of Real Estate Editors (NAREE).ExpertiseAly’s areas of personal finance expertise include:- Mortgages
- Loans
- Real estate
- Insurance
Editorial Note: Any opinions, analyses, reviews, or recommendations expressed in this article are the author’s alone, and have not been reviewed, approved, or otherwise endorsed by any card issuer. Read our editorial standards.
Please note: While the offers mentioned above are accurate at the time of publication, they're subject to change at any time and may have changed, or may no longer be available.
**Enrollment required.
Reference
ncG1vNJzZmivp6x7o8HSoqWeq6Oeu7S1w56pZ5ufonyxsdGspqeZnGKzqrrAp5qeZ52kv7WzwKCcrGedpL%2B1s8CgnGaZnaS%2FtbXZmquip55iwKS0xJ2spZ0%3D