This finance video tutorial explains how to create an amortization table in excel. Download a Loan Amortization Table spreadsheet for Excel to create your own amortization schedule, table, or calculator.Free amortization spreadsheet. Step 1: Set up your amortization table. Open a new Excel sheet and create input cells for the known components of your loan. Determine your balance at retirement with this free 401(k) calculator. Everything you fill out on a loan application will be verified and lying will get you into serious trouble. So that you can keep your belongings safe in the transition period between homes.