There actually is a free loan amortization calculator that's sort of built into Microsoft Excel. This video provides a basic introduction into the top 10 most important formulas used in excel.This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates. 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. Are you saving enough money for retirement? Use our retirement savings calculator to help find out how much money you need to save for retirement. Antero Resources (MEX:AR) Beneish M-Score as of today (January 09, 2025) is -1.96. Beneish M-Score explanation, calculation, historical data and more. All currency related amount are indicated in the company's associated stock exchange currency. Download.