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 creates an amortization schedule for a fixed-rate loan, with optional extra payments. Use this calculator to determine your payment or loan amount for different payment frequencies. Use these calculator templates to help you navigate your loans, budgets, net worth, and more. Download a Loan Amortization Table spreadsheet for Excel to create your own amortization schedule, table, or calculator. Free amortization spreadsheet. Payment on this note is deferred until December 31, 2026, at which time semi annual payments of principal are due based on an amortization schedule.