Last Updated on September 2, 2018 at 8:43 pm
Use this sheet to gauge the performance of equity mutual funds on a risk-adjusted basis for investment durations ranging from the past 1 year to the past 10 years. Version 6 now includes six nifty strategy indices (smart beta) for analysing mutual fund performance.
The Nifty strategic indices are tougher benchmarks for mutual funds to beat. Therefore, using these benchmarks would be a better way to separate the wheat from the chaff. A couple of these indices were also studied in detail:
- Nifty50 Value 20 Index (NV20) as a mutual fund benchmark
- Nifty Low Volatility 50: A Benchmark Index to watch out for
This version also incorporates the recently released downside protection calculator
This analyzer can be used by ALL retail investors. NO knowledge of risk and return analysis is required to use the sheet and understand the results!
🔥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 👈
How to use this analyzer
- Choose the fund category.
- List all funds in that category at Value Research Online.
- Spot the funds which have been in the top 10 in terms of returns over the past 3, 5 and 10 years (3,5 alone should also do).
- Create a shortlist based on the above criterion. About 5 funds, not more.
- Analyze the funds with this sheet and look for a consistent risk-return score and consistent downside protection and invest in one of them.
- This will take you about 30 minutes or so.
Features of the risk and return analyzer
For equity mutual funds, you can determine SIP and lump sum returns for investment duration up to 10 years.
Evaluate performance taking into account the risk taken for the return achieved (13 metrics are computed. See the list here). A percentage score is assigned to the fund for each investment duration based on values of the 13 different risk/return metrics.
- Compare Fund versus benchmark. Indices available: A total of 53 Indices, including Nifty TRI, Sensex TRI, BSE 200 TRI, BSE 500 TRI,Nifty, CNX 100, CNX Mid Cap, CNX 500, Sensex, BSE Small Cap, Mid Cap, BSE 100,200, 50 etc.Indices available: A total of 47 Indices, including Nifty TRI, Sensex TRI, BSE 200 TRI, BSE 500 TRI,Nifty, CNX 100, CNX Mid Cap, CNX 500, Sensex, BSE Small Cap, Mid Cap, BSE 100,200, 50 etc.
TRI refers to total returns index. That is the index has been calculated with dividends reinvested.
The user needs to obtain them manually from the S&P website (updated up to 4th April 2016). Links for updating each index is provided in the sheet.
The TRI indices are stored in the sheet while other indices are downloaded from Moneycontrol.
The six strategic indices are:
NV20 – 20 value stock from within Nifty.
NQ30 – 30 quality stocks from NSE listing.
Alpha50 – 50 alpha generators from top 300 NSE stocks (market cap)
NDivOpp – Top 50 dividend yield stocks from top 300 NSE stocks (market cap)
NLV50 – 50 least volatile stocks from top 300 NSE stocks (market cap)
NGS15 – Top 15 growth stocks from top 50% market cap of all sectors with PB and PE greater than the Nifty.
The strategy indices also need to updated from the NSE site (updated currently up to June 30th 2016).
Benchmark recommendations:
Large Cap: Nifty Value 20 (NV20) and NIfty TRI
Mid-cap: Nifty Alpha 50 (Alpha50) and BSE 200 TRI and Nifty Mid-cap
Multi-cap: Nifty Next 50 (Jr), Nifty Low Volatility 50 (NLV50), Quality30 (NQ30) or BSE 500 TRI.
Div yield funds: Nifty Div Opp 50 (NDivOpp)
Small cap: BSE Small cap
- Compare Fund and benchmark performance wrt a risk–free rate that you choose for each investment duration
- Compare Fund and benchmark performance wrt a minimum acceptable rate that you choose for each investment duration
Read more: Understanding Upside and Downside Capture ratios
New feature: Upside and downside cagr
Upside CAGR is the annualized returns from monthly gains and downside CAGR, the annualized CAGR from monthly losses.
Download Version 6.0 of the mutual fund risk and return analyzer (Aug 18th 2016)
Download Version 5.0 of the mutual fund risk and return analyzer (May 5th 2016)
Download Version 4.0 of the mutual fund risk and return analyzer (Jun 18th 2015)
We are on Google News
Use this button to add freefincal.com as a preferred personal finance source on Google News.
Explore 1,400+ videos on YouTube!
Subscribe to get posts via email!
Join 32,000+ readers and get free money management solutions delivered to your inbox! (Link takes you to our email sign-up form)Join our WhatsApp Channel
Explore our products
🔥Join our community of 9000+ users! 🔥- Use our Robo-advisory Tool to create a complete financial plan! More than 3,500 investors and advisors use this! Use the discount code robo25 for 20% off. Plan your retirement (early, normal, before, and after), plus non-recurring financial goals (such as child education) and recurring financial goals (such as holidays and appliance purchases). The tool helps anyone aged 18 to 80 plan for retirement, plus six non-recurring and four recurring financial goals, with a detailed cash flow summary.
- Our Flagship Course! Learn to manage your portfolio like a pro to achieve your goals regardless of market conditions! More than 3,500 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 conditions! Watch the first lecture for free! One-time payment! No recurring fees! Lifelong access to videos! Reduce fear, uncertainty and doubt while investing! Learn how to plan for your goals before and after retirement with confidence.
- Join the freefincal investor circle! An exclusive space for investors, advisors, fintech employees and students to access financial planning and insurance tools, mutual fund and stock analysis tools, coding strategies and Excel macros for data extraction. 750+ members are now part of our investor circle.
- Increase your income by getting people to pay for your skills! More than 900 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 seeking more clients through online visibility, or a salaried individual looking for side or passive income, we will show you how to do it by showcasing your skills and building a community that trusts and pays you. (Watch the 1st lecture for free). One-time payment! No recurring fees! Lifelong access to videos!
- Portfolio Tracker! Track your mutual funds and stock investments with our Google Sheet!
- We also publish monthly screeners for
Our Podcast: Let's Get Rich With Pattu
On Spotify: Let's Get RICH With PATTU! Every single Indian CAN grow their wealth! On Audible: Listen to the Let's Get Rich with Pattu Podcast
Listen to the Let's Get Rich With Pattu podcast on YouTube.
Now watch Let's Get Rich With Pattu தமிழில் (in Tamil)!About The Author
Dr M Pattabiraman giving a lecture
- Dr 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 14 years of experience publishing news analysis, research and financial product development. He has over 28 years of teaching and research experience. He is also a public speaker and keynote presenter.
- He is a patron and co-founder of “Fee-only India,” an organisation promoting unbiased, commission-free, AUM-independent investment advice.
- Connect with him via @pattufreefincal on X LinkedIn YouTube
- Pattabiraman has co-authored three print books.
This book helps you ask the right questions and find the right answers. It also includes nine online calculators to create custom solutions.
(2) Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want. 
Both the boy and girl versions of "Chinchu Gets a Superpower".
Most investor problems stem from a lack of poor decision-making. We made bad decisions and money mistakes when we started earning, and we spent years undoing them. Why should our children go through the same pain? What is this book about? As parents, what if we had to groom one ability in our children that matters not only for money management and investing but for every aspect of life? My answer: Sound decision-making. So, in this book, we meet Chinchu, who is about to turn 10. The story follows what he wants for his birthday and how his parents plan it, while also teaching him key ideas about decision-making and money management. What readers say! 
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 a young age. The importance of money management and decision-making based on their wants and needs. Very nicely written in simple terms. - Arun.
About freefincal & its content policy
Freefincal is a News Media organisation 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: To get in touch, please use our contact form. (Sponsored posts or paid collaborations will not be entertained.)Our publications
- Your Ultimate Guide to Travel. This is an in-depth exploration of vacation planning, including how to find affordable flights, budget accommodations, and practical travel tips. It also examines the benefits of travelling slowly, both financially and psychologically, with links to relevant web pages and guidance at every step. Get the PDF for Rs 300 (instant download)
- How to profit from content writing: Our ebook is for those interested in getting a side income via content writing. It is available at a 50% discount for Rs. 500 only!