Buy the Simple Sheets Loan Amortization Schedule Template
https://www.simplesheets.co/a/2147525395/v7Aj9zMx
All purchases help to support this channel - thanks!

Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/04/Amortisation-Schedule.xlsx

In this video I demonstrate how to build an amortization schedule in Microsoft Excel. An amortization schedule displays principle and interest payments for each month over the term of a loan.

The schedule is fully dynamic in that it expands and contracts to display the correct number of rows for loan's tenure.

The template features the EMI calculation which I explain in this video https://youtu.be/ilREyNLfqqE

If you have Excel 365, please watch this video instead https://youtu.be/ALIUFPSnd5Y
------------------------