Latest Updates


Steps to Calculate ISPMT in Excel

I have made above video tutorial in which I have explain the steps of calculating ISPMT 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.

Remember : You have to show PV negative.

Share This:

Vinod Kumar ( Educator )

Vinod Kumar ( Educator ) is founder of this website

No Comment to " Steps to Calculate ISPMT in Excel "

  • To add an Emoticons Show Icons
  • To add code Use [pre]code here[/pre]
  • To add an Image Use [img]IMAGE-URL-HERE[/img]
  • To add Youtube video just paste a video link like http://www.youtube.com/watch?v=0x_gnfpL3RM