Skip to main content
Advertiser Disclosure
We do receive compensation from some partners whose offers appear on this page. We have not reviewed all available products or offers. Compensation may impact the order in which offers appear on page, but our editorial opinions and ratings are not influenced by compensation.

Ascent-logo

  • Credit Cards
  • Banking
  • Brokerages
  • Loans
  • Mortgages
  • Knowledge
  • Latest Picks
  • Search Icon Click here to search

Credit Cards

Top Picks
  • Best of February 2021
  • Cash Back
  • Balance Transfer
  • Travel
  • 0% APR
  • Rewards
  • Bad Credit
Knowledge
  • Beginners Guide to Credit Cards
  • How to Rebuild Your Credit
  • Maximize Your Credit Card Rewards
  • Learn More About Credit Cards
Credit Card Tools
  • Compare Cards
Looking for a new credit card?

Explore the best credit cards in every category as of February 2021.

Get started!

Banking

Top Picks
  • Best Savings Accounts
  • Best Bank Accounts
  • Best Money Market Accounts
  • Best CDs
  • Best Checking Account Bonuses
Knowledge
  • Beginners Guide to Banking
  • Everything You Need to Know About Savings
  • Money Market Accounts Made Easy
  • Learn More About Banking
Looking for a place to park your cash?

Check out our top picks of the best online savings accounts for February 2021.

Get Started!

Brokerages

Top Picks
  • Best Brokers of February 2021
  • Best Online Brokers for Beginners
  • Best Options Brokers
  • Best IRA Accounts
  • Best Roth IRA Accounts
  • Best Robo Advisors
Knowledge
  • How to Open a Brokerage Account
  • Beginner's Guide to Brokerages
  • Learn More About Brokerage
Just getting started?

Explore our picks of the best brokerage accounts for beginners for February 2021.

Get Started!

Loans

Top Picks
  • Best Loans of February 2021
  • Best Personal Loans for Bad Credit
  • Best Loans for Debt Consolidation
  • Best Low-Interest Personal Loans
  • Best Personal Loans for Good Credit
  • Best Personal Loans for Fair Credit
Knowledge
  • Personal Loans Made Easy
  • Debt Consolidation Guide
  • How to Pay Off Debt
  • Learn More About Loans
Thinking about taking out a loan?

Before you apply for a personal loan, here's what you need to know.

Get Started!

Mortgages

Top Picks
  • Best Mortgage Lenders of February 2021
  • Best Mortgage Lenders for Poor Credit
  • Best Refinance Lenders
  • Best VA Mortgage Lenders
Knowledge
  • First Time Homebuyers Guide
  • Home Loans Made Easy
  • The Complete Guide to Refinancing
  • How to Get a Mortgage with Bad Credit
  • Learn More About Mortgages
Tools & Calculators
  • Mortgage Calculator
Compare Rates
  • Today's Mortgage Rates
  • Refinance Rates
  • 15-Year Mortgage Rates
  • 20-Year Mortgage Rates
  • 30-Year Mortgage Rates
  • Jumbo Mortgage Rates
  • VA Loan Rates
  • 5/1 ARM Rates
  • 7/1 ARM Rates
  • FHA Mortgage Rates

Knowledge

Knowledge Section
  • All Articles
  • Credit Card Articles
  • Banking Articles
  • Brokerage Articles
  • Personal Loan Articles
  • Mortgage Articles
  • Personal Finance Articles
Recent Articles
  • 5 Perks of Having Great Credit

    Credit Cards

    5 Perks of Having Great Credit
  • Judge Says CDC's Eviction Ban Is Unconstitutional. Here's What That Means for Renters

    Personal Finance

    Judge Says CDC's Eviction Ban Is Unconstitutional. Here's What That Means for Renters
  • 3 Money Mistakes I Made as a New Parent

    Personal Finance

    3 Money Mistakes I Made as a New Parent
  • Here's Why I Track My Net Worth

    Personal Finance

    Here's Why I Track My Net Worth
  • The Ascent
  • Personal Finance
  • How Is a Loan Amortization Schedule Calculated?

How Is a Loan Amortization Schedule Calculated?

by: Dan Caplinger  |  Feb. 3, 2021

The Ascent is reader-supported: we may earn a commission from offers on this page. It’s how we make money. But our editorial integrity ensures our experts’ opinions aren’t influenced by compensation.

There are many different types of loans that people take. Whether you get a mortgage loan to buy a home, a home equity loan to do renovations or get access to cash, an auto loan to buy a vehicle, or a personal loan for any number of purposes, most loans have two things in common: They provide for a fixed period of time to pay back the loan, and they charge you a fixed rate of interest over your repayment period.

When you take out a loan with a fixed rate and set repayment term, you'll typically receive a loan amortization schedule. This schedule gives you important information about how much your monthly payments will be, and it lets you calculate the total amount of interest that you'll pay over the course of the loan as well as the speed with which you'll pay down the loan's principal balance. By understanding how to calculate a loan amortization schedule, you'll be in a better position to consider valuable moves like making extra payments to pay down your loan faster.

What is a loan amortization schedule?

A loan amortization schedule gives you the most basic information about your loan and how you'll repay it. It typically includes a full list of all the payments that you'll be required to make over the lifetime of the loan. Each payment on the schedule gets broken down according to the portion of the payment that goes toward interest and principal. You'll typically also be given the remaining loan balance owed after making each monthly payment, so you'll be able to see the way that your total debt will go down over the course of repaying the loan.

You'll also typically get a summary of your loan repayment, either at the bottom of the amortization schedule or in a separate section. The summary will total up all the interest payments that you've paid over the course of the loan, while also verifying that the total of the principal payments adds up to the total outstanding amount of the loan.

How to calculate a loan amortization schedule if you know your monthly payment

It's relatively easy to produce a loan amortization schedule if you know what the monthly payment on the loan is. Starting in month one, take the total amount of the loan and multiply it by the interest rate on the loan. Then for a loan with monthly repayments, divide the result by 12 to get your monthly interest. Subtract the interest from the total monthly payment, and the remaining amount is what goes toward principal. For month two, do the same thing, except start with the remaining principal balance from month one rather than the original amount of the loan. By the end of the set loan term, your principal should be at zero.

Take a simple example: Say you have a 30-year mortgage for $240,000 at a 5% interest rate that carries a monthly payment of $1,288. In month one, you'd take $240,000 and multiply it by 5% to get $12,000. Divide that by 12, and you'd have $1,000 in interest for your first monthly payment. The remaining $288 goes toward paying down principal.

For month two, your outstanding principal balance is $240,000 minus $288, or $239,712. Multiply that by 5% and divide by 12, and you get a slightly smaller amount -- $998.80 -- going toward interest. Gradually over the ensuing months, less money will go toward interest, and your principal balance will get whittled down faster and faster. By month 360, you owe just $5 in interest, and the remaining $1,283 pays off the balance in full.

Calculating an amortization schedule if you don't know your payment

Sometimes, when you're looking at taking out a loan, all you know is how much you want to borrow and what the rate will be. In that case, the first step will be to figure out what the monthly payment will be. Then you can follow the steps above to calculate the amortization schedule.

There are a couple ways to go about it. The simplest is to use a calculator that gives you the ability to input your loan amount, interest rate, and repayment term. For instance, our mortgage calculator will give you a monthly payment on a home loan. You can also use it to figure out payments for other types of loans simply by changing the terms and removing any estimates for home expenses.

If you're a do-it-yourselfer, you can also use an Excel spreadsheet to come up with the payment. The PMT function gives you the payment based on the interest rate, number of payments, and principal balance for the loan. For instance, to calculate the monthly payment in the example above, you could set an Excel cell to =PMT(5%/12,360,240000). It would give you the $1,288 figure you saw in that example.

Why an amortization schedule can be helpful

There are many ways that you can use the information in a loan amortization schedule. Knowing the total amount of interest you'll pay over the lifetime of a loan is a good incentive to get you to make principal payments early. When you make extra payments that reduce outstanding principal, they also reduce the amount of future payments that have to go toward interest. That's why just a small additional amount paid can have such a huge difference.

To demonstrate, in the example above, say that instead of paying $1,288 in month one, you put an extra $300 toward reducing principal. You might figure that the impact would be to save you $300 on your final payment, or maybe a little bit extra. But thanks to reduced interest, just $300 extra is enough to keep you from making your entire last payment. In other words, $300 now saves you more than $1,300 later.

Be smart about your loans

Even when your lender gives you a loan amortization schedule, it can be easy just to ignore it in the pile of other documents you have to deal with. But the information on an amortization schedule is crucial to understanding the ins and outs of your loan. By knowing how a schedule gets calculated, you can figure out exactly how valuable it can be to get your debt paid down as quickly as possible.

About the Author

Dan Caplinger
Dan Caplinger icon-button-linkedin-2x icon-button-twitter-2x

Dan is a lawyer and financial planner living in Williamstown, Massachusetts. With experience in tax and estate planning, trust administration, and wealth management, Dan led The Motley Fool's investment planning bureau when he started writing in 2006 and covers a host of topics ranging from retirement and tax planning to personal finance.

Like this page? Share it!

Facebook Icon This icon shares the page you are on via Facebook
Blue Twitter Icon Share this website with Twitter
LinkedIn Icon This image links to share the page over LinkedIn.
Email Icon Share this website with email

We’re firm believers in the Golden Rule, which is why editorial opinions are ours alone and have not been previously reviewed, approved, or endorsed by included advertisers. The Ascent does not cover all offers on the market. Editorial content from The Ascent is separate from The Motley Fool editorial content and is created by a different analyst team. The Motley Fool has a Disclosure Policy. The Author and/or The Motley Fool may have an interest in companies mentioned.

The Ascent Logo

The Ascent is a Motley Fool service that rates and reviews essential products for your everyday money matters.

btn_facebook-yellow btn_twitter-yellow btn_instagram-yellow

Copyright © 2018 - 2021 The Ascent. All rights reserved.

About The Ascent
About Us Contact Us Newsroom How We Make Money Editorial Integrity Ratings Methodology
Legal
Terms of Use Privacy Policy Accessibility Policy Terms and Conditions Copyright, Trademark and Patent Information
Learn
Credit Cards Banking Brokerage Loans Recent Articles

By submitting your email address, you consent to us sending you money tips along with products and services that we think might interest you. You can unsubscribe at any time. Please read our Privacy Statement and Terms & Conditions.

Back to The Motley Fool