The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates.You can create an Excel amortization table with changing interest rates. Here's how you can build it. This calculator will help you figure out your regular loan payments and it will also create a detailed schedule of payments. An amortization calculator helps you understand how fixed mortgage payments work. Estimated interest rate. Check out the web's best free mortgage calculator to save money on your home loan today. Combining the strengths of the American Institute of CPAs (AICPA) and The Chartered Institute of Management Accountants (CIMA). To calculate NPV, you need to estimate the timing and amount of future cash flows and pick a discount rate equal to the minimum acceptable rate of return.