This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates. An amortization schedule is a table that shows periodic payments on a loan breaks down each payment into principal and interest.Ryan O'Connell, CFA, FRM shows how to create a loan amortization table in Excel. Base Formula. Population. Joint Applications: Applicants must submit the joint application including this Excel file using the CDLAC online application portal.