The 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.Want to Calculate Loan Payments Offline? Excel Mortgage Calculator. This spreadsheet-based calculator creates an amortization schedule for a fixed-rate loan, with optional extra payments. Download this Mastering Loan Repayment With Moratorium Period: A Comprehensive Guide Excel template for free right now! I have 6 months payment holiday at the start of the 2 year loan. I need to adjust the formulas to account for this 6 month holiday. Use this amortization schedule calculator to create a printable table for a loan or mortgage with fixed principal payments. Fundwave makes it possible for investors to plugin variables such as principal, interest rates, moratorium periods, etc to set up an amortization schedule.