The indepth Watch Me Build is a 25 minute behemoth, showing you how to build a more complex, dynamic amortization table in Excel. Review and compare 11 best Excel amortization template sites.For each, we list its pros and cons. Use the following formulas to show the total payment, interest portion of the payment, and principal portion of the payment. A few simple formulas can be used to create an amortization schedule that can be copied all the way down for the entire amortized life of every asset you own. This amortization calculator returns monthly payment amounts as well as displays a schedule, graph, and pie chart breakdown of an amortized loan. This amortization calculator returns monthly payment amounts as well as displays a schedule, graph, and pie chart breakdown of an amortized loan. Use our amortization schedule calculator to estimate your monthly loan repayments, interest rate, and payoff date on a mortgage or other type of loan. Make math easier with these free calculator templates. To use our amortization calculator, type in a dollar figure under "Loan amount.