Loan Amortization Schedule Excel Spreadsheet
Originally published: 22/10/2018 07:29
Last version published: 24/07/2020 08:47
Publication number: ELQ-14839-5
View all versions & Certificate

Loan Amortization Schedule Excel Spreadsheet

Manage Your Loan Payments Yourself, With This Simple Spreadsheet.

This is an easy to use loan amortization spreadsheet for all individuals who have taken on a loan or who are planing to take a loan from a bank or any other financial institution.

It's straightforward, just enter the inputs values in the BLUE cells and the spreadsheet will automatically calculate your payments per month for the loan and how much of principle and interest you are paying.

In EMI or PMT, you just have to adapt the three values in BLUE i,e. amount borrowed, tenure, and rate of interest.

I have created the spreadsheet taking the amount of 4 lac and a tenure of 7 years with an interest rate of 11%.

The spreadsheet is fully formulated and will calculate all the effective calculations i.e. Payment per month, interest p.m and principle p.m.

Why is this Loan Amortization Spreadsheet helpfull?

With the help of this spreadsheet you can easily evaluate how much you will be paying each and every month and you can manage your monthly budget effectively. You can also calculate what total extra interest cost you are going to pay on different tenures on your initial borrowing, and can evaluate it with your different options available offered in the market.

- Jatin

This Best Practice includes
1 Excel Spreadsheet

Acquire business license for $19.00

Add to cart

Add to bookmarks


Further information

Break up interest and principal amount separately

To manage your EMIs effectively


5.0 / 5 (1 votes)

please wait...