What is the Formula to calculate rater of Interest for SIP based Mutual Funds

[godrama]

What is the Formula to calculate rater of Interest for SIP(Systematic Investment Plan) based Mutual Funds?

I have been investing Rs.1000/- every month in SBI Magnum since year 2004, I wish to caliculate the rate of Interest that I got for a particular year/each year in this Scheme upon my Investment.

thanks in advance

 

[blueninja]

What is the Formula to calculate rater of Interest for SIP(Systematic Investment Plan) based Mutual Funds?

I have been investing Rs.1000/- every month in SBI Magnum since year 2004, I wish to caliculate the rate of Interest that I got for a particular year/each year in this Scheme upon my Investment.

thanks in advance

Hi refer to the below link

http://goodfundsadvisor.blogspot.com/2009/03/formula-for-calculating-sip-return.html

 

[yodlee99]

In excel spreadsheet, IRR or MIRR can be used to estimate returns on investment, even if you have lumpsum investments on various dates randomly.
If yours is a plain simple SIP, its much easier to punch in your portfolio with valueresearchonline and look under "Gains & Loss" tab under "My Portfolio". This would give you gain in Rs., in %, annual returns and an in-depth analysis specifically targeted towards mutual fund investors.

 

[godrama]

I finally found it, I think this is the formula I am looking for.

http://en.wikipedia.org/wiki/Compound_annual_growth_rate