This finance video tutorial explains how to create an amortization table in excel. I'm going to show you how to build an amortization table in Excel from scratch.Step 1: Set up your amortization table. Open a new Excel sheet and create input cells for the known components of your loan. As management, we assert that, to the best of our knowledge and belief, this financial report is complete and reliable in all material respects. A student is responsible for knowing and complying with the dates listed in the academic calendar. 4 Aid disbursed to students as cited in the table above, and in the following sections concerning the Federal Loan Programs, the. College's standard refund schedule found in the College Catalog. Of rates of basic pay in the General Schedule or the Foreign Service pay plans. Only three banks whose total deposits aggregated only about.