Showing posts with label Microsoft Office. Show all posts
Showing posts with label Microsoft Office. Show all posts

March 11, 2012

How to prepare Loan Repayment schedule in Excel?

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.