The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates.Ryan O'Connell, CFA, FRM shows how to create a loan amortization table in Excel. Expenditures reported on the Schedule are reported on the cash basis of accounting. I am pleased to present the Ohio Housing Finance Agency's (OHFA) 2011 Qualified Allocation.