How To Calculate The Returns From Your Mutual Fund Holdings?
December 12, 2012 2 Comments
If you have made a one time lump sum investment and opted for the growth/dividend reinvestment options here is the formula: CAGR = [(final amount/amount invested)^(1/tenure)] – 1
In case you have a SIP and have opted for the growth option,then use the IRR feature in excel to calculate your returns.
In every other case use the XIRR feature in excel.
Remember that money out of your pocket is marked”-” and money into your pocket is “+” while calculating IRR and XIRR. For worked samples see this link.


The festival of Diwali is associated with Laxmi, the goddess of wealth; it is considered an auspicious time for spending and earning money. The customary trading tradition on the day of Diwali is unique to India where markets open for a short duration in the evening to pay obeisance to Lakshmi, the Hindu goddess of wealth and prosperity. This Muhurat Trading is a centuries old tradition. The day holds significance as it marks the beginning of the New Year, as per the Marwari tradition.Also the Gujarati new year begins a day after Diwali.
ou have a ladder of fixed income instruments or are looking to take on debt,it helps to be able to have a feel for the interest rate cycle.I came across come interesting inputs to help in this effort in yesterday’s 



