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

Vinod Kumar

Educator

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

0 comments:

Post a Comment