Loan Amortization Formula​​ In order to create a loan amortization schedule in Excel, we can utilize the following built-in functions: Excel PMT Function. Step 1: Set up your amortization table.Open a new Excel sheet and create input cells for the known components of your loan. This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates. To use our amortization calculator, type in a dollar figure under "Loan amount. Expense tracker apps help you collect and classify your purchases so that you recognize spending patterns and spot where to trim your costs. How do expense trackers work?