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.I need to build an amortization schedule for a 30year loan. It's based on 12 payments and the loan documents have the payment amount. This spreadsheet-based calculator creates an amortization schedule for a fixed-rate loan, with optional extra payments. Download a Loan Amortization Table spreadsheet for Excel to create your own amortization schedule, table, or calculator. Free amortization spreadsheet. Download a Loan Amortization Table spreadsheet for Excel to create your own amortization schedule, table, or calculator. Free amortization spreadsheet. A form to create a new amortization template will open. 3.