How to Use ISPMT Function in Excel

ISPMT is the interest payment on any specific period. Suppose, you have invested 1000 your money in bank fixed deposit for 5 years with 10%, you may be interested its 18 month interest. You have just open ms excel and then you have to write formula =ISPMT (10%/ 12; 18; 5*12; -1000). You will got your required interest. It will be helpful for your future planning.

If you want to buy our Basic Computer Course VCDs Set, you can buy at our online store http://www.krantikari.org/2015/11/basic-computer-course-vcds-set.html