The tutorial shows how to build an amortization schedule in Excel to detail periodic payments on an amortizing loan or mortgage. To use our amortization calculator, type in a dollar figure under "Loan amount.13, Payment number, Payment date, Beginning balance, Scheduled payment, Extra payment, Total The indepth Watch Me Build is a 25 minute behemoth, showing you how to build a more complex, dynamic amortization table in Excel. Adding extra principal payments in order to pay off the loan earlier than the loan contract calls for. In this tutorial we will add this feature. Use our free loan payment calculator to estimate monthly payments, interest, and repayment timelines. Check out the web's best free mortgage calculator to save money on your home loan today. All currency related amount are indicated in the company's associated stock exchange currency. Download.