Use these calculator templates to help you navigate your loans, budgets, net worth, and more. 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. This calculator can create a loan amortization schedule given only three of four necessary variables. 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. Loan Amortization Table. (ii) the entire amount of the levy certified in the prior calendar year according to sections 124D.