Mortgage Amortization Schedule: Understanding Your Loan Repayment Breakdown

July 2024 · 11 minute read
2024-07-22T20:03:11Z JUMP TO Section Chevron icon It indicates an expandable section or menu, or sometimes previous / next navigation options.
  • 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 & YearMonthly PaymentPrincipalInterestBalance
    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 & YearMonthly PaymentPrincipalInterestBalance
    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:

    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.

    spanLaura 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./spanspanShe 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./span 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 spanAly 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./spanspanExperience/spanspanAly began her journalism career as reporter, and later an editor, for several neighborhood sections of the Dallas Morning News./spanspanHer 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. /spanspanHer 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)./spanspanExpertise/spanspanAly’s areas of personal finance expertise include:/spanullispanMortgages/span/lilispanLoans/span/lilispanReal estate/span/lilispanInsurance/span/lilispan/span/li/ulspanEducation/spanspanAly is a graduate of Texas Christian University, where she received a bachelor’s degree in radio/TV/film and news-editorial journalism./span 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:EducationAly is a graduate of Texas Christian University, where she received a bachelor’s degree in radio/TV/film and news-editorial journalism. Read more Read less Top Offers From Our Partners Chime® Checking Account Set up Direct Deposit and get your paycheck up to 2 days before your coworkers.** No overdraft fees. No monthly fees. A tooltip Chime is a financial technology company, not a bank. Banking services provided by The Bancorp Bank, N.A. or Stride Bank, N.A., Members FDIC. **Early access to direct deposit funds depends on the timing of the submission of the payment file from the payer. We generally make these funds available on the day the payment file is received, which may be up to 2 days earlier than the scheduled payment date. Start Banking

    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