Get Access to World’s largest Template Library & Tools

Table of Contents

  1. Schedule Template Bundle
  2. 6 Steps to Prepare an Amortization Schedule in Excel
  3. 6+ Amortization Schedule Templates
  4. 1. Amortization Schedule Template
  5. 2. Loan Amortization Schedule Template
  6. 3. Simple Amortization Schedule Template
  7. 4. Car Loan Amortization Schedule Template
  8. 5. Amortization Schedule in PDF
  9. 6. Request for Amortization Schedule
  10. 7. Amortization Schedule Example

6+ Amortization Schedule Templates in Google Docs | Word | Pages | PDF | XLS | Numbers

An amortization schedule shows the list of due payments along with the interest rates that are applied to the loan amount. It is very easy to list the detailed payments so that you can determine the interest charges and principal rate of the amount and calculate all the due payments you have. To create such a schedule, the best possible way is to use schedule templates for reference.

Schedule Template Bundle

schedule template bundle
Details
File Format
  • MS Word
  • Google Docs
  • PDF

Download Now

6 Steps to Prepare an Amortization Schedule in Excel

Step 1: Open Spreadsheet

We will be doing our Amortization Schedule in Excel. So the first step is to open a new spreadsheet in Microsoft Excel. Go to File Menu and select New Document option. A blank spreadsheet will open in front of you.

Step 2: Create Labels

Create a table on the blank spreadsheet. Add the different labels on the table: Loan Amount, Interest Rates, Months and Payments. These labels are the terms that you need to add to the schedule.

Step 3: Add Loan Details

Loan and debt amounts take different forms like bonds that require interest payments. Now you have to add the amortizing loan interest rate as a percentage amount to the adjacent cells of the labels that you have given. They mainly include mortgages and leases.

Step 4: Enter Interest Rate

Now you need to add the interest rate in the table under the respective label. Interest rates are added to the loan amounts by banks based on the principal amount that is owed after every payment is made. The principal increases with time while the interest amount decreases.

Step 5: Calculate Payment

To calculate the loan’s interest, you need to divide the rate by 12 to get the monthly rate. The monthly interest rate needs to be multiplied with the principal loan amount to find a single month’s interest. Now you have to subtract this interest from the monthly amount and you will get your principal payment amount. In Excel, you can use formulae to do this calculation automatically.

Step 6: Complete the Table

Add Total Payments and Total Interest to the Loan Summary to complete the schedule. Use the formulae SUM to calculate the total amounts and your amortization schedule table is done. Make sure the final ending is zero by using the AutoFill Option.

6+ Amortization Schedule Templates

1. Amortization Schedule Template

amortization schedule template
Details
File Format
  • Google Docs
  • Google Sheets
  • Excel
  • Word
  • Numbers
  • Pages

Size: A4 & US

Download Now

In case you have due payments to make, our amortization schedule template can be useful to you. It comes in different file formats of Microsoft like MS Word and Excel, besides others so that you can make your payments on time! You can use its pre-loaded format and add your billings after you edit it in your available editing programs. The best part is it is customizable with standard Google fonts so you can edit whenever required.

2. Loan Amortization Schedule Template

loan amortization schedule template
Details
File Format
  • Google Docs
  • Google Sheets
  • Excel
  • Word
  • Numbers
  • Pages

Size: A4 & US

Download Now

It is very important to make a loan and payment schedule based on your initial loan. The best way to keep track of all your due payments by using a loan amortization schedule. So without further wait, download this template in Google Docs and Google Sheets format on your device for adding your list of payments with the deadline so that they remind you anytime you see it.

3. Simple Amortization Schedule Template

simple amortization schedule template
Details
File Format
  • Google Docs
  • Google Sheets
  • Excel
  • Word
  • Numbers
  • Pages

Size: A4 & US

Download Now

Our simple amortization schedule template is a premium template that you can use to create your payment table in any format you wish like MS Excel or even Google files. It has a professional design that allows you to add your principal amount and the interest rates together to make easy calculations. With better customization, you can print this ready-made sample template instantly in universal paper sizes, too!

4. Car Loan Amortization Schedule Template

car loan amortization schedule template
Details
File Format
  • Google Docs
  • Google Sheets
  • Excel
  • Word
  • Numbers
  • Pages

Size: A4 & US

Download Now

Buying your dream car should not be tough. Take a car loan and fulfill your dream, leaving the rest to us. Get this Car Loan Amortization Schedule template in Apple Pages and Numbers that lets you determine the loan amount, the duration of paying it back and the interest rates applied on the amount. You will be able to calculate your car loan amortization without any hassles with this schedule template.

5. Amortization Schedule in PDF

amortization schedulenelson.com
Details
File Format
  • PDF

Size: 8.5 KB

Download Now

If you need to keep your amortization obligations at bay, you can create a table using our loan schedule template. You can download the Amortization Schedule on your device in PDF format which supports Google fonts and suggestive content. Also, you can edit any part of the content to suit your needs! We can guarantee that you will enjoy creating a loan schedule.

6. Request for Amortization Schedule

request for amortization scheduleWorldbank.org
Details
File Format
  • PDF

Size: 20.3 KB

Download Now

If you are worried about how to make your due payments in time, then you will need o to create a proper amortization schedule to help you add all the details of your loans, interest rates and calculate the total amount in an organized way. Download this Request for amortization schedule sample which you can modify the way you want it and also print it out instantly whenever you need it!

7. Amortization Schedule Example

example of amortization schedulemacs.citadel.edu
Details
File Format
  • PDF

Size: 288.0 KB

Download Now

If you require an efficient loan scheduling document, make sure you have our Amortization Schedule Example which makes it easier for you to create a loan summary and payment schedule whenever you need one. It’s better to be prepared as early as possible rather than regretting later when the deadline is over. Get this sample amortization schedule right away!

More in Schedule Templates

10+ Schedule Rotation Templates in PDF | DOC11+ Supplemental Salary Schedule Templates in PDF | DOC
7+ Credentialed Block Class Instructor Salary Schedule Templates in PDF | DOC5+ Mental Health Counselor Salary Schedule Templates in PDF | Word
11+ Classified Employee Salary Schedule Templates in PDF | DOC10+ Administrator Salary Schedule Templates in PDF
10+ Homework Planner Templates in Docs | Word | Pages | PDF | Sheets | Excel | Numbers | AI | PSD | InDesign10+ Yearly Schedule Templates in Google Docs | Google Sheets | Word | Excel | Numbers | Pages | PDF
FREE 10+ Research Interview Schedule Templates in PDF10+ Employee Schedule Templates in Google Docs | Google Sheets | Excel | Word | Numbers | Pages | PDF
20+ Bathroom Cleaning Schedule Templates - PDF, DOC10+ Monthly Planners in Docs | Word | Pages | Sheets | Excel | Numbers | Illustrator | Photoshop | Publisher | InDesign
11+ Retirement Daily Schedule Templates in PDF | DOC11+ Mortgage Amortization Schedule Templates in PDF | DOC
11+ Mortgage Payment Schedule Templates in Google Docs | PDF | MS Word | Pages | MS Excel | Google Sheets | Numbers12+ Child Care Schedule Templates in PDF | Doc
10+ Class Schedule in Docs | Word | Pages | Sheets | Excel | Number | PDFFREE 11+ Investment Schedule Templates in PDF | XLS | MS Word
10+ Weekly Planner in Docs | Word | Pages | Excel | Numbers | Illustrator | InDesign | Photoshop | PDF10+ Staff Training Schedule Templates in PDF | DOC
11+ Audit Lead Schedule Templates in PDF | Word11+ School Timetable Templates In Excel | Numbers
10+ Office Cleaning Schedule Templates in Google Docs | Google Sheets | Excel | Word | Numbers | Pages | PDF15+ Camp Schedule Templates
11+ Audit Schedule Templates in PDF | Word | Google Docs | Pages7+ Retail Work Schedule Templates in PDF
10+ School Schedule Templates in PDF | DOC11+ Church Service Schedule Templates in DOC | PDF
19+ Depreciation Schedule Templates in PDF | DOC28+ Real Estate Schedule Templates in PDF
10+ Repayment Schedule Templates5+ Work Training Schedule Templates Google Docs | Google Sheets | PDF | Word | Pages | Numbers | XLS
13+ Training Program Schedule Templates in Google Docs| Word | Pages | PDF7+ Loan Payment Schedule Templates in Google Docs | Google Sheets | XLS | Word | Numbers | Pages | PDF
17+ Loan Schedule Templates in Google Docs | Google Sheets | XLS | Word | Numbers | Pages5+ Equipment Maintenance Schedule Templates in Google Docs | Google Sheets | XLS | Word | Numbers | Pages | PDF
6+ Employee Training Schedule Templates in Google Docs | Google Sheets | XLS | Word | Number | Pages | PDF7+ Employee Work Schedule Templates in Google Docs | Google Sheets | Word | Pages | Numbers | Excel | PDF
7+ Home Maintenance Schedule Templates in Google Docs | Google Sheets | Word | Pages | Numbers | XLS | PDF22+ Sample Schedule Templates in Google Docs | Pages | Word | Pages | PDF | XLS
10+ Kindergarten Schedule Templates6+ Amortization Schedule Templates in Google Docs | Word | Pages | PDF | XLS | Numbers
12+ Schedule Templates in PDF13+ Schedule Templates in Word | Google Docs | Google Sheets | XLS | Numbers | Page | PDF | DOC
24 Hours Schedule Templates - 33+ Samples in PDF, DOC, Excel13+ Office Schedule Templates in Google Docs | Google Sheets | XLS | Word | Numbers | Pages | PDF
11+ Safety Schedule Templates12+ Preventive Maintenance Schedule Templates in Google Docs | Google Sheets | Word | Excel | Pages | Numbers | PDF
12+ Family Schedule Templates in Google Docs | Word | Pages | PDF | XLS20+ Maintenance Schedule Templates in Google Docs | Google Sheets | XLS | Word | Numbers | Pages | Word | PDF
5+ Yearly Schedule Templates in Google Docs | Word | Pages | PDF8+ Medication Schedule Templates in Google Docs | Google Sheets | XLS | Word | Numbers | Pages | PDF
9+ Rent Schedule Templates in Google Docs | Google Sheets | XLS | Word | Numbers | Pages | PDF9+ Production Schedule Templates in Google Docs | Word | Pages | XLS | Numbers | PDF
12+ Summer Schedule Templates in Google Docs | Word | Pages | PDF | XLS14+ Shift Schedule Templates in Google Docs | Google Sheets | XLS | Word | Numbers | Pages | PDF
13+ Time Schedule Templates in Google Docs | Word | Pages | PDF5+ Vacation Schedule Templates in Google Docs | Google Sheets | Word | Pages | Numbers | XLS | PDF
23+ Payment Schedule Templates in Google Docs | Google Sheets | XLS | Word | Numbers | Pages | PDF22+ Weekly Schedule Templates in Google Docs | Google Sheets | XLS | Word | Numbers | Pages | PDF
26+ Simple Schedule Templates10+ Program Schedule Templates
10+ Shooting Schedule Templates in Google Docs | Word | Pages | PDF | XLS15+ Payroll Schedule Templates in Google Docs | Word | Pages | PDF
10+ Study Schedule Templates in Google Docs | Google Sheets | Word | Pages | Numbers | Excel | PDF14+ Staff Schedule Templates in Google Docs | Google Sheets | Numbers | XLS | Word | Pages | PDF
21+ Work Schedule Templates in Google Docs | Google Sheets | XLS | Word | Pages | PSD | PDF20+ Monthly Schedule Templates in Google Docs | Google Sheets | XLS | Word | Numbers | Pages | PDF
15+ Family Schedule Templates in Google Docs | Pages | Word | PDF15+ Project Schedule Templates in Google Docs | Word | Pages | Numbers | XLS | PDF
6+ Bathroom Schedule Templates in Google Docs | Google Sheets | XLS | Word | Numbers | Pages | PDF11+ Activity Schedule Templates in Google Docs | Word | Pages | PDF
8+ Beginners Schedule Templates in Google Docs | Word | Pages | PDF11+ Interview Schedule Templates in Google Docs | Pages | Word | XLS | Numbers | Sheets | PDF
6+ Kid's Schedule Templates in Google Docs | Word | Pages | PDF | XLS18+ Annual Schedule Templates
8+ Chore Schedule Templates in Google Docs | Word | PDF | Pages12+ Kitchen Schedule Templates in Google Docs | XLS | Word | Pages | Number | PDF
9+ Lunch Schedule Templates in Google Docs | Word | Pages | PDF | XLS12+ Hourly Schedule Templates in Google Docs | Google Sheets | XLS | Numbers | Word | Pages | PDF
11+ Delivery Schedule Templates in Google Sheets | Google Docs | XLS | Word | Pages | Numbers | PDF26+ Daily Schedule Templates in Google Docs | Google Sheets | Excel | Word | Pages | PDF
13+ Holiday Schedule Templates in Google Docs | Word | Pages | PDF | XLS18+ Equipment Schedule Templates
10+ Kindergarten Daily Schedule Templates18+ Work Schedule Templates
18+ Production Schedule Templates10+ Travel Schedule Templates
5+ Residential Building Schedule Templates in PDF10+ Cleaning Planner Templates
12+ Residential Construction Schedule Templates in Google Docs | Google Sheets | Word | Pages | Numbers | XLS| PDF19+ Preschool Daily Schedule Templates in PDF | DOC
15+ Preschool Schedule Templates in Google Docs | Word | Pages | PDF10+ Workout Planner Templates
21+ Meeting Schedule Templates in Google Docs | Google Sheets | Word | XLS | Pages | Numbers | PDF15+ Company Schedule Templates in Google Docs | Word | Pages | PDF
15+ Student Planner Templates11+ Construction Work Schedule Templates
17+ Event Schedule Templates in Google Docs | Google Sheets | XLS | Word | Pages | Numbers | PDF6+ Time Schedule Templates
bottom banner