In this article, we will introduce you to five Excel functions that make it easy to create an amortization schedule to track our monthly payment. Fill in the column titled "Period" with your payment dates.Input the month and year for the first payment loan within cell A8. An amortization schedule is a table that shows periodic payments on a loan breaks down each payment into principal and interest.