Last Updated on April 21, 2022 at 7:33 am
Use this free Mutual Fund Portfolio Overlap Tool to compare five mutual funds and find out the common stocks and percentage portfolio overlap.
Update April 2022: This tool is now available on Google Sheets.
How to use the mutual fund portfolio overlap comparison tool?
If you are trying to build a diversified mutual fund portfolio (see how you can do this), then simply choose funds with an investment strategy that does not overlap much. For example, choose a bluechip fund and a mid/small-cap fund. Or a single multi-cap fund. Just 1/2 funds are enough for a market-cap and sector diversified portfolio.
🔥Secure your future with our Robo-advisory tool trusted by over 3,500 investors and advisors. From effortless retirement planning to funding your children’s biggest dreams, turn your financial goals into reality. 🔥
Subscribe for money management solutions via email! (Link takes you to our email sign-up form) Join 32,000+ readers in our community.
👉 New Tool Alert! NaviPlan: A Privacy-Focused Multi-asset Tracker and Goal Planner 👈
Most investors hold anywhere between 5- 50 mutual funds. Track the portfolio of the large cap funds in your portfolio for a couple of months and check the portfolio overlap. If it is anywhere above 60-70%, then there is not much point holding both funds (unless your portfolio is large and you are scared about putting it all in one AMC). That this, this tool can be used to ruthlessly trim down your portfolio.
Screenshots of mutual fund portfolio comparison tool
The main input sheet where I have chosen PPFAS LTVF, Quantum Long term Equity and HDFC Balanced for comparison.
The results are shown below. Should be reasonably self-explanatory.
Notice that the overlap is quite small. You can get the sector-wise comparison also.
As an experiment, I have added a debt fund rating summary as well
