Amortization Schedule Templates

Organizing is Hard, So Make a List of Each Payment on Your Mortgage Over Time with’s Free Sample Amortization Schedule Template. Create 30 Year Mortgage Due Plans or a 15 year Monthly Interest Plan, or Customize Your Own Plan with Our Templates to Guide You. Create Yours Today!See more

There are tons of loan amortization for you to use, but choosing the right one to fit your needs can be tricky and exhausting. The type of amortization schedule you'll use depends on the frequency of interest you wish your loan compounds. If you are looking for simple amortization schedules, then you're in the right place. We've got schedule templates for loan amortization, monthly amortization, car loan amortization, and blank amortization, all ready-made for you to use. Available and editable in Google Docs, Google Sheets, MS Excel, MS Word, Numbers, and Apple Pages, both in A4 & US letter size formats. Professionally written and 100% customizable. Download now and remind yourself when payments are to be made.

What Is an Amortization Schedule?

An amortization schedule is a complete table of periodic loan payments. This shows the amount of principal with the amount of interest of a loan until it is completely paid off by the end of the term. Commonly, borrowers and lenders use an amortization schedule to keep track of loans such as mortgages, car loans, home loans, personal loans, and term loans such as those indicated in a loan agreement.

How to Create an Amortization Schedule

amortization schedule template

Studies show that people tend to forget loans that do not have written evidence. There are different types of loans, an amortized loan is one of them. When you have this loan, you will have a scheduled periodic payment on both your principal loan and its interest. This continues until you are able to finish paying for your loan. To keep track with your progress, you will need an amortization schedule.  

1. Input Basic Information

Before everything else, input basic information of your borrowers in your sample schedule. Write their name and other necessary contact details. Specify the amount they wish to loan, include the yearly loan interest rate and the period on how long they need to pay their debt. You may also input the required amount to be paid per month.

2. Create a Table

Create a table for your payment schedule and reflect their scheduled payments, interest expenses, principal repayment, and the cumulative interest. To do this, place a column for the month of their payment, loan balance, principal amount, and interest rate. Include their payment as well as the total interest every time they fail to pay for the specified month. 

3. Add Balance

At the beginning of the loan, the interest cost is at its highest amount and so does the balance amount. Your borrower will be paying constantly on the principal amount along with the interest rates until their loan reaches to zero. Their loan balance is commonly set at the left side of the table, written in a decreasing amount.

4. Specify Principal and Interest

Like the balance amount, your interest rate starts high and will gradually decrease as payments are given monthly. Every month, your borrower pays in different amount but their total payment remains equal each period. This commonly happens with a monthly loan payment, but amortization is an accounting term that may be applied to other types of balances as well. 

5. Include Payment

Specify the loan payments of your borrowers in your table. You may require them to have a monthly payment or a yearly payment, it's up to you. if they have extra payments and additional fees besides the interest, you may include them as well. Soon they can finally pay a 30-year mortgage from you.

6. Total Everything

Now that everything is set, you may begin to total the entire amount. There is a specific formula to calculate the entire thing, you may use a mortgage calculator to help you with it. When you calculate, their total monthly loan payments don't really change but may differ on the ratio of payments until the total debt is eliminated.