This spreadsheet-based calculator creates an amortization schedule for a fixed-rate loan, with optional extra payments. This finance video tutorial explains how to create an amortization table in excel.Does anyone have a template for a loan amortization schedule with interest accruing as of origination but payments deferred 6 months? Download a Loan Amortization Table spreadsheet for Excel to create your own amortization schedule, table, or calculator. Free amortization spreadsheet. The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. Use our free loan payment calculator to estimate monthly payments, interest, and repayment timelines. 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.