Does anyone have a template for a loan amortization schedule with interest accruing as of origination but payments deferred 6 months? Create automatic loan amortization schedule table with PMT, IPMT, PPMT formulas in Microsoft ExcelThe tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. 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. Ever want to add an Interest-only period to an amortization schedule? This spreadsheet-based calculator creates an amortization schedule for a fixed-rate loan, with optional extra payments. This Excel spreadsheet makes it easy to view the amortization of a home loan with optional extra monthly payments. If you take out a loan or mortgage, it's important to keep track of your payments.