This finance video tutorial explains how to create an amortization table in excel. Create automatic loan amortization schedule table with PMT, IPMT, PPMT formulas in Microsoft ExcelThese stylish Microsoft Excel calculator templates are easy to use, even if you're not an Excel expert, and they're perfect for business or personal use. Boost your financial planning with an amortization schedule in Excel. Get expert tips and use ClickUp tools to enhance efficiency. Check out the web's best free mortgage calculator to save money on your home loan today. No depreciation or amortization expenses are allowed. 292, 3), Fill in the annual operating expense amounts for the following line items as appropriate:.