Does anyone have a template for a loan amortization schedule with interest accruing as of origination but payments deferred 6 months? The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage.An amortization schedule is a table format that lists periodic payments on a loan or mortgage over a period of time. Use these calculator templates to help you navigate your loans, budgets, net worth, and more. This calculator can create a loan amortization schedule given only three of four necessary variables.