# 17+ Loan Schedule Templates in Google Docs | Google Sheets | XLS | Word | Numbers | Pages

With the increase in the general value of goods applying for a loan has become quite common for the average person. It starts almost as early as college days when a person applies for a student loan. Once these loans are taken, they need to be paid off over a certain period of time. It becomes almost like paying monthly electricity bills. But you need to keep a tag on when each installment needs to be paid for otherwise a heavy fine might be incurred. That is why you should be making use of an schedule sample. You can also see more templates like Schedule of Value.

## 1. Loan Payment Schedule Template

If you have a number of loans that need paying off and you find it very difficult to keep track of them, then you should consider using a loan payment schedule. We have prepared this sample template which you can just download and start using immediately. All you would have to do is enter the correct information in the correct place and the sheet will handle the calculation portion itself.

## 2. Loan Amortization Schedule Template

If you need help creating an effective loan amortization schedule, you don’t need to look any further than this site. Our team of experts has created this sheet to make sure that you are able to pay your loan on time without having to incur any unnecessary charges. So if you are interested in making things easier for you, consider downloading this simple template.

## 5 Steps to Create a Loan Schedule in MS Excel

### Step 1: Create a New Document

We are going to be using certain calculation functions. That is why it is recommended that you use spreadsheet software like Google Sheets format or Microsoft Excel. For this example, we shall use MS Excel format and we would suggest that you do so too. However, you can use any other software of your choice and get similar results.

### Step 2: Enter Loan Details

In the first section write down the loan details. Use four columns to spread the information horizontally. In the first column, write down ‘Original Principle’, ‘Loan Term’ and ‘Annual Interest’ in three successive cells. Write down the corresponding value in the cells of the column adjacent to it.

### Step 3: Payment Details

Write down the payment details after leaving a column gap to the right side of the previous one. Just like last time write down ‘Number of Payments,’ ‘Payment’ and ‘Monthly Interest Rate’ in the three cells. Fill out the adjacent cells with the required information. Right underneath these four columns write the date when the load starts.

### Step 4: Create the Payment List

In order to stay organized, we are going to create a table that records the payments made. So, we are going to use a six-columned table. The label for the first column is going to be ‘month’, for the second, ‘payment,’ for the third, ‘interest,’ for the fourth, ‘principle,’ for the fifth, ‘balance’ and finally for the fifth, ‘scheduled payment date’ respectively.

### Step 5: Populate the List

Next, we are going to populate the table with the correct data. The first column needs to contain the month number. However, for the first row, we are going to put 0 in this cell and for the balance cell, we shall write the original principal. From the second row onwards every cell needs to be filled. If you are good at excel you can automate some of the calculations.

## 3. Car Loan Amortization Schedule Template

If after months of contemplation you have bought your dream car using a car loan scheme, then there is another that you need to do as well and that is preparing a car loan amortization sample schedule. It is likely that you are unfamiliar with the process of creating one. That is totally fine because we have created this printable template that can help you with that task. So download it now.

## 4. Loan Payment Schedule Template

Looking for some help to create a loan repayment simple schedule? Let us save some of your time and energy. Download and edit this schedule in Excel to get started. Most of the work related to adding functions to columns has already been done and all you have to do is enter the correct details in the correct places. If you would like it in some other format, check out our site for that. We are sure you will find it.

## 5. Free Schedule of Charges for Home Loan

janabank.com

Waited long enough and finally bought the place that you could call your own? Congratulations. However, if you have taken a loan which you most probably have, then you would have to maintain a payment basic schedule for the same. The good news is that we have created something that you can use right now. So download this basic template and get organized.

## 6. Free Sample Student Loan Repayment Schedule Template

financialaid.wvu.edu

With higher education becoming more and more costly, student loans have become a norm these days. However, this might be the first time you are paying back a loan. It is important that you maintain a loan payment schedule to stay organized. If you would like some help in creating one then you can take a look at our schedule in Sheets. Alternatively, you can just download the one that we have selected for you. You can also see more templates like Loan Proposals.

## 7. Free Loan Repayment Schedule Template

miller-motte.edu

In case you were looking for a comprehensive loan repayment schedule explaining the processes then this is the standard template you should be looking at. We have curated some of the best templates available on the internet and believe that they can be of immense help to you. If you would like to look at some other design templates as well, check out our site. You will be amazed by our collection.

## 8. Free Sample Loan Repayment Schedule Template

sautech.edu

If you have just sat down with your iPad with the intention of creating a creative schedule, we believe we can save you some time and energy. Check out our schedule in Pages to know more. If you don’t have the time to check them out individually you can just download this one and use it as a reference. But if you do have time, please check them out. They will be really helpful to you.

## 9. Free Sample Loan Schedule in PDF Format

cleanviewcapital.com

If there are a number of loans that your company is having to take care of at once, it makes perfect sense to use schedule templates for the same. The good news is we have plenty of them. All you have to do is find out the one that is most suitable for your business needs and download it. The templates are editable and printable so you can mold them according to your requirements. You can also see more templates like Study Schedules.

## 10. Free Student Loan Repayment Schedule Template

pnc.com

Student loans are so common these days that it has become a part of life for most people. The best we can do to help people out is by making sure that they are able to pay their loan on time so that they don’t forget one of the payments and incur additional costs. That is why we have this sample repayment schedule template that you can use right away or use as a reference to create your own schedule in Word. You can also see more templates like Payroll Schedules.

## 11. Free Term Loan Schedule Template

sbsbank.co.nz

If you need a term loan schedule template look no further than this modern template. We host some of the best templates that you can find on the internet. Our team of experts ensures that each of them is of high quality. So you can fully trust these and use them in any situation that you see fit. If you would like to check out some of our other professional schedule templates, then feel free to do so.

## 12. Free Home Loan Interest Rate Schedule Template

sccu.com.au

Home loans can be a messy affair if you don’t take an organized approach to it. That is why we suggest making use of a schedule template. If you would like to create one on your iPad, you can take a look at our schedule template samples. If you don’t have the time to go through them individually you can use this one instead. All of our layout templates are of high quality and so there is no need to worry.  You can also see more templates like Agency Schedules.

## 13. Free Formal Loan Schedule Template

manukaunissan.co.nz

If your company deals with financial services and would like to create a formal loan schedule template that your customers can use, you’ll be glad to know that we have already created one for you. Download it now to see it. If you feel that you need to change certain things in it, you can easily do that because like all of our model templates it is 100% editable. So check it out now.

## 14. Free Loan Payment Schedule Template

treasurer.ca.gov

Creating a loan payment schedule can prove to be quite beneficial for you if you have to deal with a number of them. So if you have your iPad lying around, let’s create one. No, you don’t have to do much for we have already done most of the work. All you need to do is download our schedule in Numbers and enter the correct information in the right place. You can also download this template in PDF as well.

## 15. Free Home Loan Schedule Template

idbibank.in

If you are a company that provides loans to the clients, then you need to have a comprehensive home loan editable schedule handy so that customers won’t have to create one themselves. We have already got a number of professional ones that you can try out. Start by downloading this one. If you find something that you feel like changing or adding, you can easily do it since it is fully editable. You can also see more templates like Work From Home Schedule.

## 16. Free Loan Fee Schedule Template

powerfinancetexas.com

If the free design schedule templates that you have been going through on the various sites are not proving to be helpful in your task of creating a multi-payment loan fee schedule, then you are probably looking at the wrong place. We have this outline template that has been specifically created for the purpose. It is 100% editable. So all you have to do is download it and start editing.

policecu.com.au