The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. Loan Amortization Schedule outlines the interest and principal payments owed on a mortgage, including the outstanding balance.To reach the formula for compound interest, you algebraically rearrange the formula for CAGR. Use these calculator templates to help you navigate your loans, budgets, net worth, and more. Just convert the "daily compound interest" into "effective monthly interest". This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates. Open a new spreadsheet and add the below components of loans in the mentioned Cells. PMT (Payment Function): It calculates the fixed monthly payment for a loan based on the interest rate, loan term, and loan amount. The rounding option is for comparison with other calculators that do not round the payment or interest.