As usual, begin with setting up the input cells. 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. It is actually quite simple. You just need to make a table in excel showing Opening Balance, adding interest and reducing through payments. This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates. Final values may vary subject to bank's policy. E10 is the average of the inflation adjusted earnings per share of a company over the past 10 years. Use this calculator to work out your daily interest for a fixed number of days or months. It's useful for bitcoin and other crypto currency trading.