There are seven installed templates in Microsoft Excel 2007.All those help us to easily prepare our day to day needs. We may not use it frequently; but still it helps in someway. Loan Amortization is one of the installed templates in excel. It helps to calculate Total loan amount to be re payed, Scheduled number of payments, total early payments, Total interest and loan re-payment schedule of a Loan Account.