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. What is the maximum loan amount? The maximum loan amount is the lesser of: 1. Contra Costa County. Contra Costa County District Attorney's office.