Simple how-to articles and free tools for financing your goals, managing your money, mutual fund and stock investments

Aug 2016: List of Equity Mutual Fund Returns & Up/Down Capture Ratios

Here is the August 2016 list of equity mutual fund lump sum and SIP returns; upside capture, downside capture and capture ratios over 1,2,3,4,5,6,7,8,9 year periods.

I am slowly developing a portal that lists mutual fund metrics for screening/analysis with a monthly update.

The seeds for this were sown earlier with a listing of downside capture ratio of all mid-cap equity mutual funds and the publication of a tool to compare your mid-cap fund performance with category peers.

Pranav Date played a key role in making this listing possible. He wrote a code to match the Value Research fund name and category with appropriate AMFI scheme code. This is a crucial step as it would be very difficult to manually do this for 387 equity funds.

The next step is to assign a benchmark for each category. This is controversial as one can argue that the upside and downside capture ratios should be calculated only with the benchmark used by the AMC. However, considering that we are going to relatively evaluate them, using one benchmark per category is not a terrible idea, as long as the choice is reasonable.

I will leave it you to judge if these choices are okay. If there are objections, I am happy to re-calculate with a revised benchmark. More total returns indices have been added this month.

DescriptionCategoryBenchmark used
BankingEQ-BANKCNX Bank Nifty
Infrastructure fundsEQ-INFRACNX Infra
international fundsEQ-INTLNifty-TRI
Large CapEQ-LCNifty Value 20
Mid CapEQ-MCBSE-midcap-TRI
Multi CapEQ-MLCNifty Low Volatility 50
PharmaEQ-PHBSE Healthcare TRI
Small CapEQ-SCBSE Small Cap TRI
Tax planning or ELSSEQ-TPNifty Low Volatility 50

You can read more about the choice of benchmarks here: Nifty Strategy Indices as Mutual Fund Benchmarks

Out of the 287 equity funds, data for 34 funds could not be calculated (this list can be found along with the full list). Out of this 34, 14 of them are ETFs. I shall try and reduce this number in future releases.

Here are a couple of screenshots

equity-mutual-fund-listing-1 equity-mutual-fund-listing-2

Users can use the sort option to list only the category that they want.


Do let me know if you have any feedback.

Aug 2016: Download the freefincal equity mutual fund risk-reward listing

July 2016: Download the freefincal equity mutual fund risk-reward listing

Subscribe and join the freefincal Youtube community!

 Don't like ads but want to support the site? Subscribe to the ad-free newsletter! 
You will get the full post-ad-free delivered to your inbox for Rs. 3000 a year. Follow this link to read the terms and sign up! 
Want to conduct a sales-free "basics of money management" session in your office?
I conduct free seminars to employees or societies. Only the very basics and getting-started steps are discussed (no scary math):For example: How to define financial goals, how to save tax with a clear goal in mind; How to use a credit card for maximum benefit; When to buy a house; How to start investing; where to invest; how to invest for and after retirement etc. depending on the audience. If you are interested, you can contact me: freefincal [at] Gmail [dot] com. I can do the talk via conferencing software, so there is no cost for your company. If you want me to travel, you need to cover my airfare (I live in Chennai)

Connect with us on social media

Do check out my books

You Can Be Rich Too with Goal-Based InvestingYou can be rich too with goal based investing

My first book is meant to help you ask the right questions, seek the right answers and since it comes with nine online calculators, you can also create customg solutions for your lifestye!Get it now.  It is also available in Kindle format.

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 want My second book is meant for young earners to get their basics right from day one! It will also help you travel to exotic places at low cost! Get it or gift it to a youngearner

The ultimate guide to travel by Pranav Surya

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

Create a "from start to finish" financial plan with this free robo advisory software template

Free Apps for your Android Phone

All calculators from our book, “You can be Rich Too” are now available on Google Play!
Install Financial Freedom App! (Google Play Store)
Install Freefincal Retirement Planner App! (Google Play Store)
Find out if you have enough to say "FU" to your employer (Google Play Store)

About Freefincal

Freefincal has open-source, comprehensive Excel spreadsheets, tools, analysis and unbiased, conflict of interest-free commentary on different aspects of personal finance and investing. If you find the content useful, please consider supporting us by (1) sharing our articles and (2) disabling ad-blockers for our site if you are using one. We do not accept sponsored posts, links or guest posts request from content writers and agencies.

Blog Comment Policy

Your thoughts are vital to the health of this blog and are the driving force behind the analysis and calculators that you see here. We welcome criticism and differing opinions. I will do my very best to respond to all comments asap. Please do not include hyperlinks or email ids in the comment body. Such comments will be moderated and I reserve the right to delete the entire comment or remove the links before approving them.
Updated: August 29, 2016 — 12:11 pm


  1. Pattu Sir, one hell of a job. Thank you so much!

    1. Thank you.

  2. This is very very helpful Pattu sir. I am a newbie to investment. using your blogs and calculators me and my husband have started monthly sip. This monthly evaluation is good start towards review.
    Thanks a ton

    1. Good to know. Thank you.

  3. Dear Pattu – Reliance Regular Savings fund – debt option Scheme -dividend payout
    how 7 what is tax treatment in this scheme? either as equity or debt?
    wat will be tax rates? pl clarify.

    1. As a debt fund.

  4. Excellent Work Sirji, jus a Clarification, higher the “CAPTURE RATIO” , better it is right ?

    1. Yes,thank you.

  5. What is the Date with reference to which the returns have been calculated? It should be specified to remove ambiguity.

    1. The last NAV date chosen was 26th Aug 2016. So 1Y return refers to an investment made 1Y ago and so on. I shall include this from next months listing.

  6. Data for Benchmark Used is missing in Sheets EQ-bank, EQ-FMCG, EQ-Infra, EQ-Pharma, EQ-IT and EQ-Others.

  7. 8Y ret and 9Y ret figures for EQ-LC Benchmark NV20 are also missing.

    Please also clarify whether Upside, Downside and Capture Ratio figures are for SIP or Lumpsum returns.

  8. Can you include Balanced Funds also in the analysis?

    1. I need an appropriate benchmark. Once I get this, I can.

Comments are closed.

freefincal © 2019 Frontier Theme