Use Excel to prepare a mortgage amortization schedule for the 10 years. Step 1: Set up your amortization table.Open a new Excel sheet and create input cells for the known components of your loan. In a good amortization Excel template, you only need to enter a few numbers, and formulas will take over and fill out the entire table for you. As management, we assert that, to the best of our knowledge and belief, this financial report is complete and reliable in all material respects.