« Are you running your own mutual fund? Is it doing well? Should you sell off your equity funds since the market is overvalued? »

How do you measure the performance of an individual mutual fund?

Posted on 15 Jul 2021
Author: Sayan Sircar

Tags: Portfolio Review

7 mins read
📢Get new post notifications on WhatsApp!

Learn how to evaluate your active fund against a benchmark by combining return and risk

Evaluating a mutual fund against benchmark

We have already covered why you need to regularly check how a mutual fund is performing against the benchmark. This is important since as per the definition of an active fund, the fund manager is taking high fees to beat the benchmark. It is just basic common sense for you as the investor to know if you are getting your money’s worth.

Many websites offer various return metrics (1 week, 6 months, 1 year, 2 years etc) of the fund versus benchmark and peers. They also provide a risk number measured by standard deviation over 3 years or 5 years of data. However, these are snapshots and do not give a sense of consistency over time.

📚 Topics covered:

Rolling return and risk
Getting the data
Calculating rolling risk and return
- Rolling return
- Rolling risk
Interpreting the result
How to use the metrics to evaluate the fund performance

Rolling return and risk

Consistency is measured by rolling return and rolling risk plotted in a chart vs. time. The concept is like this:

Find returns for the holding period of 1st Jan 2019 to 31st Dec 2019 (this is the first point in the chart)
Find returns for the holding period of 2nd Jan 2019 to 1st Jan 2020 (this is the second point in the chart)
Find returns for the holding period of 3rd Jan 2019 to 2nd Jan 2020 (this is the third point in the chart) and so on

Repeat the same for rolling risk (for say 1-year price movement) and plot it in a chart. A few mutual fund portals have started providing this information but most keep it behind a paywall. However, it is easy to get the data and calculate it yourself.

Getting the data

We need daily price data (date, NAV or price, fund name) for the fund and peer(s) and the benchmark index.

For funds, this data comes from

https://www.amfiindia.com
https://www.mfapi.in

Benchmark index data is found in https://www.nseindia.com or https://www.bseindia.com

There is a caveat that the fund may change the benchmark from time to time and it is important that the right benchmark’s data is used to do this calculation in various periods. Since price levels of different indices are not comparable, they need to be compared using the return series. For example if a fund had benchmark X in 2019 and shifted to Y in 2020 then the return series will have returns of X in 2019 and returns of Y in 2020. Do not use returns of Y in 2019 since that will be an incorrect comparison.

Did you know that we have a private Facebook group which you can join for free and ask your own questions? Please click the button below to join.

Calculating rolling risk and return

Rolling return

1 year rolling return for time today = Price(t=today)/Price(t=today-365)-1
1 year rolling return for time today-1 = Price(t=today-1)/Price(t=today-366)-1

and so on.

Alternatively, daily price return data (Price_today/Price_yesterday-1) can be used to find rolling return using the geometric mean function in Excel i.e. rolling return of 1 year = Geometric Mean (1+Price series of 1 year)^250-1.

Since there are 250 data points in the rolling window, we need at least 250 points to get one value in the rolling chart. If there are 5 years of rolling price data (1250 data points), then the chart will have 1000 rolling values.

Rolling risk

We use the standard deviation of daily price return data to calculate this using the STDEV function in Excel. Since 1 year has 250 trading days, the rolling risk of 1 year = STDEV (Price series of 1 year) * sqrt(250).

Interpreting the result

We have taken a popular active fund and compared that against the Nifty 50 price index and an index fund that tracks the Nifty 50. Regular plans for all are taken to get a longer period of data (since direct plans came in 2013 onwards). The conclusions will not be materially impacted by this decision of choosing regular funds. The fund names are deliberately not mentioned since the focus is on teaching this evaluation framework.

Rolling return chart

This chart shows rolling returns since July 2011 to date using 250 daily price returns as the window size. We are looking for periods where the rolling return is higher compared to the benchmark.

We see that in the period from Dec-2013 to Sep-2014 there was a huge outperformance against the index but after that time, the performance fell rapidly but stayed above the index until the end of 2017. This streak of underperformance continued until mid-2019.

Outperformance started again after Mar 2020 and has stayed mostly like that until the time of publication.

Rolling risk chart

This chart shows rolling risk since Jul-2011 to date using 250 daily price returns as the window size. We are looking for periods where the rolling risk is lower compared to the benchmark.

We see that from Jul-2011 until Sep-2014 the risk of the fund has been lower than the benchmark. The opposite is seen in Mar-2017 to Feb-2020 which indicates that the fund was riskier to invest in during this period.

Combining risk and return

We combine risk and return together in one metric by dividing rolling return by rolling risk and create another chart. This is not Sharpe Ratio which is (Return-Risk Free Rat)/Risk. This Return/Risk is a very simple metric that allows you to quickly compare the fund vs the benchmark using one number. We also create a flag called Invest (value of 0 and 1) where Invest = 1 when the return of the fund is more than the index and risk is less compared to the index.

We see that the risk and return metric is showing those periods where the return per unit risk taken is higher compared to the index. However, a more interesting trend is seen using the Invest flag since it marks the period where there has been considerable fluctuation from Nov-2016 to Feb-2020.

How to use the metrics to evaluate the fund performance

These metrics should be used to indicate changes in fund performance that require detailed scrutiny of fund performance going forward. They should not be used to predict what kind of return is expected to be got by holding the fund. The metrics may oscillate (Aug-2012 to Sep-2012) or stay fixed for long periods (May-16 to Nov-16). Whenever there is an indication of a change of trend, due to the tendency of oscillation, it is better to review a month or two later. Many other metrics can be constructed using this data.

You should realize by looking at this data that it is very difficult to predict in advance when the fund will give better performance compared to the index in the future. This is why active funds require continuous monitoring and require switching in case the investor does not have the conviction that the fund will eventually outperform the index going forward. Since switching has costs due to capital gains tax, you will permanently lose money every time you switch. The solution to this problem is to switch to index funds.

What's next? You can join the Arthgyaan WhatsApp community

You can stay updated on our latest content and learn about our webinars. Our community is fully private so that no one, other than the admin, can see your name or number. Also, we will not spam you.

To understand how this article can help you:

If you have a comment or question about this article

The following button will open a form with the link of this page populated for context:

If you liked this article, please leave us a rating

The following button will take you to Trustpilot:

Discover an article from the archives

Worked out case studies for goal-based investing

Case study: how can this middle-aged investor with two children plan for retirement and children's goals?

This article shows how a single-income middle-aged couple with two small children reach their retirement and children’s goals.
Case study: can this double income single kid family reach FIRE at 50?

This article shows how a double-income couple with a 2-year old reach their FIRE dream at the age of 50.
Case study: how a family in their mid-30s with a newborn kid can FIRE and invest in real estate?

This article shows how a double-income couple with a newborn child can invest for their future goals of FIRE and real-estate investment.
Case study: how this double income recently married family can perform DIY goal-based investment planning

This article shows how a young just-married couple can invest for future goals using the Arthgyaan goal-based investing tool.
Case Study: How should couples in their 40s with a new baby plan their financial future?

Did you welcome a bundle of joy in your 40s? This article will discuss ways of planning the child’s (and your’s financial future)
Case study: how this double income single kid family can perform DIY goal-based investment planning

This article shows how a very typical salaried couple with one child can invest for future goals using the Arthgyaan goal-based investing tool.

Previous and next articles:

<p>When you are investing in stocks directly, are you measuring your performance as a fund manager?</p>

Portfolio Review

Are you running your own mutual fund? Is it doing well?

When you are investing in stocks directly, are you measuring your performance as a fund manager?

Published: 6 July 2021

6 MIN READ

<p>The stock market cannot be predicted, but lessons from history and some basic rules can help you decide what to do as the market keeps moving up.</p>

Portfolio Review Market Movements

Should you sell off your equity funds since the market is overvalued?

The stock market cannot be predicted, but lessons from history and some basic rules can help you decide what to do as the market keeps moving up.

Published: 16 July 2021

5 MIN READ

Latest articles:

<p>This article looks at the various stages of your career from the perspective of maximum wealth creation.</p>

Portfolio Construction

Which stage of your career is most important for wealth creation?

This article looks at the various stages of your career from the perspective of maximum wealth creation.

Published: 17 April 2024

4 MIN READ

<p>This article explains the new rules regarding income tax return verification which are now in place for tax returns to be filed 1st April 2024 onwards.</p>

News Tax

When should you verify your Income Tax return as per the new rules effective from 1st April 2024?

This article explains the new rules regarding income tax return verification which are now in place for tax returns to be filed 1st April 2024 onwards.

Published: 16 April 2024

2 MIN READ

Topics you will like:

Asset Allocation (21) Basics (8) Behaviour (12) Budgeting (12) Calculator (25) Case Study (6) Children (17) Choosing Investments (40) FAQ (12) FIRE (13) Gold (21) Health Insurance (5) House Purchase (28) Insurance (16) International Investing (12) Life Stages (2) Loans (17) Market Data (7) Market Movements (16) Mutual Funds (46) NPS (7) NRI (19) News (18) Pension (8) Portfolio Construction (52) Portfolio Review (27) Reader Questions (8) Real Estate (7) Research (5) Retirement (38) Review (15) Risk (6) Safe Withdrawal Rate (5) Set Goals (28) Step by step (15) Tax (59)

Next steps:

1. Email me with any questions.

2. Use our goal-based investing template to prepare a financial plan for yourself.

Don't forget to share this article on WhatsApp or Twitter or post this to Facebook.

Discuss this post with us via Facebook or get regular bite-sized updates on Twitter.