Want to know the impact of "extra payments" on your mortgage? Check out this easy to use Excel mortgage calculator.The indepth Watch Me Build is a 25 minute behemoth, showing you how to build a more complex, dynamic amortization table in Excel. 13, Payment number, Payment date, Beginning balance, Scheduled payment, Extra payment, Total Download a Loan Amortization Table spreadsheet for Excel to create your own amortization schedule, table, or calculator. Free amortization spreadsheet. This Microsoft Excel template illustrates how to create a loan amortization schedule, as well as dealing with additional payments and variable interest rates. Have a loan you want to pay off? Try this amortization schedule Excel template to calculate your payments and track your payoff progress. This Excel spreadsheet makes it easy to view the amortization of a home loan with optional extra monthly payments.