Skip to content

Dynamic Amortization Schedule Excel 365 Template | EMI Calculator with Repayment Schedule in Excel


    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

    If you have do not have Excel 365, please watch this video instead

    Click here to download the featured file.

    Click here to Buy Simple Sheets Loan Amortization Schedule Template

    Calculate your loans (business, mortgage, auto, etc.) with our Loan Amortization Schedule spreadsheet. Equipped with a fully automated dashboard to view up to 5 loans and your payment + interest data.

    All purchases help to support this blog – thanks!