This finance video tutorial explains how to create an amortization table in excel. This example teaches you how to create a loan amortization schedule in Excel. 1.We use the PMT function to calculate the monthly payment on a loan. Loan Amortization Formula​​ In order to create a loan amortization schedule in Excel, we can utilize the following built-in functions: Excel PMT Function. Step 1: Set up your amortization table. Open a new Excel sheet and create input cells for the known components of your loan. SECTION 4 – GENERAL FIRST LOAN REQUIREMENTS. 15-17. • Baxter Bio Pharma. As discussed in the Water Authority's LongRange Financing Plan (LRFP), the Water. Must be willing to begin work early in the morning and work a very flexible schedule.