Do It Yourself Mutual Fund Analysis: HDFC Top 100 ( earlier Top 200) Fund

Published: September 8, 2013 at 2:23 pm

Last Updated on October 5, 2019 at 4:36 pm

Analyzing the performance of a mutual fund is not rocket science.  Anybody can do it, just as anybody can select a mutual fund following a few simple rules.

I would like to prove my point with a do it yourself mutual fund analysis using HDFC Top 200 fund – one of the most popular mutual funds in India. Recently many investors have become disillusioned with the fund: “I thought Top 200 was the best fundand Prashant Jain was the best fund manager.  I am disappointed with its recent performance. My portfolio is in the red for months together”

One way or another, whether you are an individual investor or a financial advisor/planner, such a comment should be familiar enough to you.

My goal in this post is to analyse the performance of HDFC Top 200 fund over the last 5 years and find out how justified such sentiments are. The analysis will be done in two ways:

Join over 32,000 readers and get free money management solutions delivered to your inbox! Subscribe to get posts via email!
🔥Enjoy massive discounts on our robo-advisory tool & courses! 🔥
  • Using available resources online.  The goal is anybody, even a layman with a little inclination and minimal effort should be able to analyse the performance of the fund.
  • Using my Excel Rolling returns calculator.


  • A significant part of my portfolio is held in HDFC Top 200.  I have an ongoing SIP in it. So when I made the analysis, only one question was running through my mind: Should I stay invested in HDFC Top 200? Should I exit and invest elsewhere?

Method 1: Using available resources online.

Step 1:

(a) What kind of mutual fund is HDFC Top 200?

It is a diversified equity mutual fund investing in stocks that are part of the BSE 200.

The BSE 200 is a diversified  list of 200 stocks chosen from the BSE: predominantly large-cap stocks and mid-cap stocks. The health of the stocks and their growth potential is taken into account before they are included/excluded from the list.

Therefore, Top 200 can be part of ones core-equity portfolio.  Its performance may also be compared with the Sensex and Nifty indices.

(b) Why did I invest in HDFC Top 200?  Only you can answer this (my reasons are clear).  The nature of the goal and its time frame should be considered: Check out my step-by-step guide to goal-based investing

Step 2: Check out the Funds webpage

Let us face it, all AMCs present data in a confusing way.  Their goal is to ensure that the data published does not present the fund in a bad light.  HDFC is no different.

If you go to Top 200’s page, you will need to locate an obscure link titled ‘returns and benchmarks’ which will take you to the bottom of the same page! You will now need to click Please click here to view Scheme Performance Summary (Fund Manager-Wise)

 In the page that loads, you will have to click on Mr. Prashant Jain and see:

Snapshot HDFC Top 200’s performance. Source: HDFC

From 28-06-2011 to 28-06-2013, the fund has severely underperformed when compared to its benchmark as well as Sensex.  However, from 28-06-2010 to 28-06-2013, the fund has beaten its benchmark comfortably but has performed just a little lower than Sensex.

Although this information is not very illuminating, considering the funds history (last entry in the table), the longer we stay invested in the fund, the higher is the expected outperformance (with respect to both BSE 200 and Sensex).

This vague inference can be confirmed by looking at Money Control’s Top 200 page

Step 3: Observe the plot comparing the scheme with its benchmark.  Screenshot of the 5-year period is shown below:

Plot of HDFC Top 200 NAV vs Benchmark (BSE 200) over a 5 year period (dated 8th Sep. 2013). Source: MoneyControl

The outperformance is clear. Even for a 3-year period the fund has managed to stay above the benchmark. If we have bothered to choose funds with a good record of accomplishment, we must give it space to perform – a period of at least 5 years.

Ignore the star rating (2-star FYI!) and most important, ignore this nonsense:

Moneycontrol mutual fund meter for HDFC Top 200 (dated 8th Sep. 2013)
Moneycontrol mutual fund meter for HDFC Top 200 (dated 8th Sep. 2013)

Step 4: Value Research Online’s Top 200 page

Let us look at two specific tables and ignore the rest:

Screen shot from Value Research Onlines HDFC Top 200 Page (dated 8th Sep. 2013)
Screen shot from Value Research Onlines HDFC Top 200 Page (dated 8th Sep. 2013)

The table on the left is part of VR Online’s front page (snapshot) while that on the right in part of the performance tab.

The trailing returns table for a most part paints a poor picture.  Investors should learn to ignore trailing returns.  They depend entirely on the date on which you choose to observe the returns.

An annual return, on the other hand, is between two fixed points and is far more reliable.  Notice that whenever the market rallies, Top 200 has given good returns.  Therefore, to benefit from this fund (or any other equity fund for that matter), we should periodically rebalance our portfolio after each market rally.  To learn more about the benefits of rebalancing, and how it reduces volatility in portfolio returns, you could use this tool.

Step 6: Morning Star India’s Top 200 Page

 Screenshot from Morning Star India's HDFC Top 200 page (dated 8th Sep. 2013)
Screenshot from Morning Star India’s HDFC Top 200 page (dated 8th Sep. 2013)

Do not worry too much about the graph (although it is quite reassuring!).  Observe the performance of the fund compared with large-cap category averages and judge for yourself.

Also look at the turnover ratio.  This is a measure of how much the fund managers has modified his/her portfolio.  During the 2008-2009 recession, the fund manager has churned the portfolio quite a bit.  As a result, the fund lost much less than other funds and recovered much more.

The turnover ratio in 2012 was quite low. This suggests that the manager believes in his stock picks and is waiting for the economy to turn around. Considering his past performance, I would like to trust him (of course he could be wrong).

 I think it is safe to say that HDFC Top 200 fund remains a compelling pick.  I am going to stay invested in it. We will need to watch what happens in the months after the election next year.

That is it.  This analysis would take no more than 10-15 minutes.  If I have money invested in this fund, should I not take the effort of spending this much time in analysing the funds performance? All it takes is a little bit of commonsense.

Do not ask a mutual fund agent or financial advisor if you should change your mutual fund without making such an analysis.  Many times fund changes are suggested just to pacify clients. Many financial advisors and agents are worried about losing clients if they advise them to stay invested in a fund that appears to be going through a bad phase. Analyse the funds performance yourself and make an informed choice.

Method 2: Using my rolling returns calculator

If you want additional evidence of the fund performance then you could use my rolling returns calculator

To use this, we need the NAV history and the benchmark index (BSE 200) data. I have chosen a period between 8th June 2009 to 5th Sep. 2013. In this period the market had recovered from the 2008 crash.

The benchmark history is available here.

The NAV history can be obtained from here

Update: Here is the automated version of the rolling returns calculator

 Download the Rolling Returns Calculator for HDFC  Top 200 Fund.

Here are the results. Please go ahead make your own conclusions. As far as I am concerned, these results do not change the above conclusions. I am going to stay invested.

Rolling Returns analysis for HDFC Top 200 Fund
Rolling Returns analysis for HDFC Top 200 Fund

Your Say: What do you think? Do you agree with the above analysis?


Do share this article with your friends using the buttons below.

🔥Enjoy massive discounts on our courses, robo-advisory tool and exclusive investor circle! 🔥& join our community of 5000+ users!
Use our Robo-advisory Tool for a start-to-finish financial plan! More than 1,000 investors and advisors use this!
New Tool! => Track your mutual funds and stock investments with this Google Sheet!
We also publish monthly equity mutual funds, debt and hybrid mutual funds, index funds and ETF screeners and momentum, low-volatility stock screeners.
Follow Freefincal on Google News
Follow Freefincal on Google News
Subscribe to the freefincal Youtube Channel. Subscribe button courtesy: Vecteezy.
Subscribe to the freefincal Youtube Channel.
Follow freefincal on WhatsApp Channel
Follow freefincal on WhatsApp
Podcast: Let's Get RICH With PATTU! Every single Indian CAN grow their wealth! 
Listen to the Lets Get Rich with Pattu Podcast
Listen to the Let's Get Rich with Pattu Podcast
You can watch podcast episodes on the OfSpin Media Friends YouTube Channel.
Lets Get RICH With PATTU podcast on YouTube
Let's Get RICH With PATTU podcast on YouTube.
🔥Now Watch Let's Get Rich With Pattu தமிழில் (in Tamil)! 🔥
  • Do you have a comment about the above article? Reach out to us on Twitter: @freefincal or @pattufreefincal
  • Have a question? Subscribe to our newsletter using the form below.
  • Hit 'reply' to any email from us! We do not offer personalized investment advice. We can write a detailed article without mentioning your name if you have a generic question.

Join over 32,000 readers and get free money management solutions delivered to your inbox! Subscribe to get posts via email!

About The Author

Pattabiraman editor freefincalDr M. Pattabiraman(PhD) is the founder, managing editor and primary author of freefincal. He is an associate professor at the Indian Institute of Technology, Madras. He has over ten years of experience publishing news analysis, research and financial product development. Connect with him via Twitter(X), Linkedin, or YouTube. Pattabiraman has co-authored three print books: (1) You can be rich too with goal-based investing (CNBC TV18) for DIY investors. (2) Gamechanger for young earners. (3) Chinchu Gets a Superpower! for kids. He has also written seven other free e-books on various money management topics. He is a patron and co-founder of “Fee-only India,” an organisation promoting unbiased, commission-free investment advice.
Our flagship course! Learn to manage your portfolio like a pro to achieve your goals regardless of market conditions! More than 3,000 investors and advisors are part of our exclusive community! Get clarity on how to plan for your goals and achieve the necessary corpus no matter the market condition is!! Watch the first lecture for free!  One-time payment! No recurring fees! Life-long access to videos! Reduce fear, uncertainty and doubt while investing! Learn how to plan for your goals before and after retirement with confidence.
Our new course!  Increase your income by getting people to pay for your skills! More than 700 salaried employees, entrepreneurs and financial advisors are part of our exclusive community! Learn how to get people to pay for your skills! Whether you are a professional or small business owner who wants more clients via online visibility or a salaried person wanting a side income or passive income, we will show you how to achieve this by showcasing your skills and building a community that trusts and pays you! (watch 1st lecture for free). One-time payment! No recurring fees! Life-long access to videos!   
Our new book for kids: “Chinchu Gets a Superpower!” is now available!
Both boy and girl version covers of Chinchu gets a superpower
Both the boy and girl-version covers of "Chinchu Gets a superpower".
Most investor problems can be traced to a lack of informed decision-making. We made bad decisions and money mistakes when we started earning and spent years undoing these mistakes. Why should our children go through the same pain? What is this book about? As parents, what would it be if we had to groom one ability in our children that is key not only to money management and investing but to any aspect of life? My answer: Sound Decision Making. So, in this book, we meet Chinchu, who is about to turn 10. What he wants for his birthday and how his parents plan for it, as well as teaching him several key ideas of decision-making and money management, is the narrative. What readers say!
Feedback from a young reader after reading Chinchu gets a Superpower (small version)
Feedback from a young reader after reading Chinchu gets a Superpower!
Must-read book even for adults! This is something that every parent should teach their kids right from their young age. The importance of money management and decision making based on their wants and needs. Very nicely written in simple terms. - Arun.
Buy the book: Chinchu gets a superpower for your child!
How to profit from content writing: Our new ebook is for those interested in getting side income via content writing. It is available at a 50% discount for Rs. 500 only!
Do you want to check if the market is overvalued or undervalued? Use our market valuation tool (it will work with any index!), or get the Tactical Buy/Sell timing tool!
We publish monthly mutual fund screeners and momentum, low-volatility stock screeners.
About freefincal & its content policy. Freefincal is a News Media Organization dedicated to providing original analysis, reports, reviews and insights on mutual funds, stocks, investing, retirement and personal finance developments. We do so without conflict of interest and bias. Follow us on Google News. Freefincal serves more than three million readers a year (5 million page views) with articles based only on factual information and detailed analysis by its authors. All statements made will be verified with credible and knowledgeable sources before publication. Freefincal does not publish paid articles, promotions, PR, satire or opinions without data. All opinions will be inferences backed by verifiable, reproducible evidence/data. Contact information: letters {at} freefincal {dot} com (sponsored posts or paid collaborations will not be entertained)
Connect with us on social media
Our publications

You Can Be Rich Too with Goal-Based Investing

You can be rich too with goal based investingPublished by CNBC TV18, this book is meant to help you ask the right questions and seek the correct answers, and since it comes with nine online calculators, you can also create custom solutions for your lifestyle! Get it now.
Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want Gamechanger: Forget Start-ups, Join Corporate and Still Live the Rich Life you wantThis book is meant for young earners to get their basics right from day one! It will also help you travel to exotic places at a low cost! Get it or gift it to a young earner.

Your Ultimate Guide to Travel

Travel-Training-Kit-Cover-new This is an in-depth dive into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, and how travelling slowly is better financially and psychologically, with links to the web pages and hand-holding at every step. Get the pdf for Rs 300 (instant download)