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.

Vinod Kumar


Prof. Vinod Kumar is an Indian Educator, Motivational Speaker, Naturopathic Practitioner and Entrepreneur . He is the founder of Svtuition... read more »


Post a Comment