Open a new Excel sheet and create input cells for the known components of your loan. Accurate entries are essential for correct calculations.Create automatic loan amortization schedule table with PMT, IPMT, PPMT formulas in Microsoft Excel You will create an amortization schedule for Loan Option 3 in cells C12:F35. All payments are end-of-the-period payments. Create an amortization schedule for Loan Option 2 in cells C12:F71. This finance video tutorial explains how to create an amortization table in excel. Use this free loan amortization template to create a monthly loan amortization table for any loan period up to 30 years.