Last Updated on December 29, 2021 at 5:02 pm
Here is a simple way to select mutual funds that have beat the category benchmark in terms of both return and risk over the last one, two, three, four and five years simultaneously! That is higher than the benchmark return and lower than benchmark risk.
Unlike return, risk can be measured in many ways. The simplest and most common measure of risk is the standard deviation. We look at a mutual fund’s daily returns and determine how much they deviate from the average daily return over say a year or three years. This tells us how volatile the fund is. A fund with lower risk is one with a lower standard deviation than a benchmark.
The excess return of the fund = Five-year return of the fund minus the five-year return of the index. We need this to be positive. We have used a five-year return as an example here.
🔥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 👈
The Excess risk of the fund = Five-year standard deviation of the fund minus five-year standard deviation of the index. So if the excess risk of the fund is negative it means the fund has taken lower risk than the index and vice versa.
Both these measures are plotted against each other for five years for funds across categories. Clearly, we are looking for funds with higher return and lower risk. That is we are looking for funds with a positive excess return and negative excess risk.
This screening is only over five years. To gauge performance consistency, we repeat the above test for one, two, three, four and five year periods. That is a fund must be within the blue box for all the periods simultaneously!
These are the number of qualifying funds in each category. The total number of funds are mentioned within brackets.
| Category | No of qualifying funds |
| Aggressive Hybrid Fund | 6 (33) |
| ELSS | 0 (42) |
| Focussed Fund | 2 (18) |
| Large & Mid Cap Fund | 2 (24) |
| Large Cap Fund | 3 (29) |
| Mid Cap Fund | 4 (23) |
| Multi-cap Fund | 4 (34) |
| Sectoral/ Thematic | 4 (85) |
| Contra funds | 0 (3) |
| Dividend Yield | 0 (6) |
| Small cap Funds | 1 (20) |
| Value Funds | 0 (14) |
Only 51 out of 331 or 15% make the shortlist! This lower risk, higher reward screening is automatically applied in the monthly freefincal equity mutual fund screener. This is the September 2020 Equity Mutual Fund Performance Screener which also has rolling return and rolling downside capture screening capability. This is a video guide for using the screener.