The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. Ryan O'Connell, CFA, FRM shows how to create a loan amortization table in Excel.It is a sombre obligation. It is also an important opportunity. Cause: The Department's method for calculating cash draws does not include. This is a milestone for IFORS as we close the first Fifty Years of Conferences and start the first conference in the new millennium.