This finance video tutorial explains how to create an amortization table in excel. This short video shows how to easily create a simple amortization table in Excel.Have a loan you want to pay off? Try this amortization schedule Excel template to calculate your payments and track your payoff progress. 1. Download the amortization schedule from Microsoft. 2. Open the template in Excel. 3. Check out our excel loan interest calculator selection for the very best in unique or custom, handmade pieces from our templates shops. Current amortization schedule is crafted on a 15-year payback period. Here is a simple tutorial. Which collectively comprise the City's basic financial statements as listed in the table of contents.