Fill in the "Period" column. Fill in the column titled "Period" with your payment dates.In this video we're going to talk about how to create an amortization schedule. Today we're going to talk about how to build a simple amortization schedule you could use this to do a mortgage. For a basic amortization schedule, you can fill the labels in these cells: Cell A1: Here you can enter "Principal or Loan amount. The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. I'm going to show you how to build an amortization table in Excel from scratch. This free Roth IRA calculator estimates your account balance at retirement and determines how much you are eligible to contribute in 2024.