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 calculator can create a loan amortization schedule given only three of four necessary variables. Include comments and an amortization schedule from the lender if the payments are not based on standard amortization. During the year ended December.