Financial loan Amortization Calculator (Set up Excel Template)
This video displays how to open up and use the Financial loan Amortization Calculator observed in Microsoft Excel 2007/2010. Calculator enables you to enter loan sum, once-a-year curiosity fee, time frame, number of payments for each calendar year, get started day and any solution more payments. The calculator will output the cumulative loan, basic principle for each payment, curiosity for each payment and additional. This video also demonstrates how to unprotect the sheet.