Recently I wrote a post “Top 10 Best Mutual Funds to invest in India for 2015” and a reader commented that he is investing in two funds called HDFC Top 200 and HDFC Equity. He asked my opinion. I found that 72% of his investments in these two funds overlap. So is it a better investment?
Usually mutual fund investors choose funds based on star ratings or recent performance. They try to invest in those funds, which are top rated and given high return. By concentrating on this activity, they usually select funds from the same category like 2-3 large cap funds. However, what about the underlying sector or stock? If these 2-3 funds invest in the same sector or stocks, then what purpose it servers to hold 2-3 funds? Therefore, it is very much important to check overlapping, especially for stocks.
Few also commented that by investing in different AMCs (Mutual Fund Companies) they feel it as diversification. Here again, they forgot the underlying stocks. Now the question is, where one can check this overlapping of the portfolio? The answer is Mr. Pattu of freefincal.com. He developed this Excel calculator long back, but now I found it very much necessary to share with you all.
Once you open this calculator, then on first sheet you need select the funds you are investing and along with that investment value. If you enter the investment value as of your SIP amount then it will show you the overlap investment in each SIP. Otherwise, if you enter the total current value of the fund, then result will show the overlapping to entire portfolios. Here you have the option to choose maximum three funds. I requested him to create more option. Because I found that many investors hold around 4-5 funds. However, he suggested that by doing so it might create confusion among investors. It is true also. If you have more than three funds, then select three funds each time to know about overlapping of investments. For understanding purpose, I selected HDFC Top 200 Fund and HDFC Equity Fund.
When you click on the tab “Click to compare,” then the results will be in next sheet called “Results-Simple” and “Results-Advanced.” In “Results-Simple” sheet, you will find overall overlap percentage among funds. In this example, the overlap is 72%. It also shows the number of stocks each fund holding. In the same sheet, you also find the sector wise holding of each fund in a graphical view.
In “Results-Advanced” sheet, you will find the percentage of holding in each stock by the fund. This gives a clear indication of how much stock your mutual fund portfolio holds. For example, if we invest Rs.20, 000 between HDFC Top 200 Fund and HDFC Equity Fund by dividing equally of Rs.10, 000 in each fund, then our investment in SBI alone will be Rs.1, 916. This gives a clear indication of a risk involved in exposing ourselves in particular stocks.
So how much overlapping is good?
There is no thumb rule. However, minimizing the overlapping is best idea to diversify. Ideally restrict to around 30% to 40%.
Download the Calculator HERE. Also let us say a big thanks for Mr.Pattu for creating such wonderful calculators.
EPF Scheme 2026 explained fully: EPF withdrawal, EPS pension, and EDLI insurance changes with examples,…
Chasing financial freedom? Do health, time, relationships and contentment matter just as much? Sadly, we…
Your "safe" SIPs, SGBs, PPF, or Index Funds are secretly sabotaging your wealth. Peltzman Effect…
Thinking your retirement plan is foolproof? Why LUCK - not asset or fund selection or…
Nifty 50 Index Funds Vs Active Large Cap Funds — Can we really compare them…
Should you pick Nifty 500 Multicap 50:25:25, Nifty 500, or Nifty LargeMidcap 250 Index Fund?…
View Comments
Do you define any permissible over lap exposure % for 2 funds.
For instance less 35% is ok to continue the investments in both funds.
Vandhi-There is no such standard rule. But lesser the overlap better for your portfolio.
Hi Basu avra,
One small question, please help me understand.
As we check for the possible overlap of 2 same catogary funds, as the individual fund managers keep changing the stocks as per their analysis, if 2 funds are not overlaping today may overlap heavily in future at some point of time? do one needs to followup this over time?? or fund managers of different fund houses normally choose stock with less overlap??
Prashant-Yes, your question is valid. Hence, keeping 2-3 funds enough to avoid such overlap. One large cap, one mid cap and one small cap. Also, equity investing is not like investing today and forget forever. You have to keep an eye.
Hello Basavaraj Tonagatti,
I would like to cut down number of portfolio. Currently I have below which I believe too many to manage.
Could you please help me with your expert eyes which one should I discontinue as it may overlap?
Or if you can advice for other?
Axis Liquid Fund - Direct Plan (G)
Axis Long Term Equity Fund - Regular Plan (G) (13)
Birla Sun Life Top 100 Fund (G) (4)
DSP BlackRock Micro Cap Fund - Regular Plan (G)(13)
Franklin India Smaller Companies Fund (D) (8)
ICICI Prudential Value Discovery Fund (G) (4)
Indiabulls Ultra Short Term Fund - Direct Plan (G)
Reliance Small Cap Fund (G) (5)
UTI Long Term Advantage Fund - Series V - Regular Plan (G)
UTI Mid Cap Fund (D) (10)
Regards,
Arpan
Arpan-At first, I don't know for which goal you created this portfolio and time horizon of the same. In my view, Liquid Fund (to manage your liquid cash), Ultra Short Term Fund (for managing debt part), one large, mid and small cap (to manage your equity) are enough.
Thats a good tool. Much better than Morning star Xray. I would like to see a tutorial of how to add more MFs though...
Hi Basu,
I am 50 yrs. old. My portfolio is as follows.
SIPs
1. Reliance growth - Rs. 1000
2. Reliance equity opportunities - 2000
3. Axis long term - 4000
4. Hdfc balanced - 1000
5. Icici pru discovery - 1000
6. Franklin high growth - 1000
..........
LIC
20,000 per annum
..........
PPF
10,000 per annum
I want to start Birla front line instead of franklin high growth. Is it ok?
Pratap-Without knowing your goal details, it is hard for me to guide you.
Calculator is not functional
Any updated or any changes ?
Thank you
Sir, could you please provide the link to the fund-overlap-calculator ? the one I downloaded earlier (and again now) doesn't seem to work now, although it did work almost a couple of months back.
i am just stared sip in icici balanced fund - direct - rs.10000/month.i want to invest another 16000/month , pls suggest me two funds without much overlap with above fund and also suggest allocation . i am also investing rs.10000/month in PPF & RD. pls suggest me .
Thank u sir.
Chandra-Include one small and mid cap fund and also a multi cap fund. But strictly for your long term goals. Remember the asset allocation between equity and debt part.
Sir,
In the overlap calculator, what r the meaning of the terms - '% equity portfolio displayed by VR Online' and
'% debt portfolio displayed by VR Online'? Also, Why does the total of these two don't add to 100% ?
Gourav-Because data will be fetched from that portal. It will not exactly match to 100% because results depends on how much total % VR displays.
Great tool ....But do we need that level of research while investing in mutual funds or may be we just invest in 1-2 funds only
Sam-Two to three funds are enough to build portfolio.