This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates. How to find a loan payment amount and build an amortization schedule.Excel Loan Amortization =PMT formula. This example teaches you how to create a loan amortization schedule in Excel. 1. We use the PMT function to calculate the monthly payment on a loan. Use our free commercial real estate loan calculator to calculate the details of a commercial mortgage easily and quickly. For example, when a borrower encounters a financial hardship, and conditions warrant payment relief, banks have the flexibility to reamortize a. Otherwise, you can use Table 1 to determine your qualified loan limit and deductible home mortgage interest. You can get quotes from up to five lenders in minutes through LendingTree. Then input a loan term in years and the payment interval.