-->

Latest Updates

Menu

How to Use IPMT Function in Excel






IPMT is the interest payment for an investment


Formula = IPMT(rate; per; nper; pv; [fv]; )

Rate :  rate of interest per period. It may be monthly or yearly.
per : Period. It may be 1 for one month or one year, 2 for two months or two years or any
nper :  Total No. of Periods for your investment. Means 4 years, 3 years or 5 years or any

PV: Present Value or initial Value of Investment

FV : If it is given. Otherwise it will be written as 0

Example 1.  Interest payment for a $1000 investment that earns 10% annually for 10 years. The interest payment is calculated for the 4th year and payments are due at the end of each year.





$79.23

Example 2.  Interest payment for a $1000 investment that earns 10% annually for 10 years. The interest payment is calculated for the 4th month and payments are due at the end of each month.



$8.21

Share This:

Vinod Kumar ( Educator )

Vinod Kumar ( Educator ) is founder of this website

No Comment to " How to Use IPMT Function 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