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 functions used in this video are SEQUENCE, OFFSET, IPMT, PPMT, SUBTOTAL and IF.

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

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