This finance video tutorial explains how to create an amortization table in excel. This fun and simple excel amortization simple allows you to look at each individual payment to see the amount of interest vs.Principal that you are paying. Loan Amortization Schedule outlines the interest and principal payments owed on a mortgage, including the outstanding balance. Create automatic loan amortization schedule table with PMT, IPMT, PPMT formulas in Microsoft Excel Have a loan you want to pay off? Try this amortization schedule Excel template to calculate your payments and track your payoff progress. A business loan, on the other hand, funds more than just your basic real estate. If the loan is an interest only (IO) loan in the interest only period, enter only the interest amount. By "cash" we mean both physical currency and money in a checking account.