Category: Mutual Funds

  • Four years of SIP with DSP Tax Saver Fund

    Four years of SIP with DSP Tax Saver Fund

    Last year I blogged about 3 years with DSP Tax Saver Fund and L&T Tax Advantage Fund. I continued with DSP Tax Saver and discontinued L&T Tax Advantage Fund. Below are my key takeaways.

    • I started investing in this fund entirely based on my (limited) research.
    • My first couple of instalments were in regular plan before realising that there is something called as direct plan which has lower expense ratio (thank you Economic Times). I switched to direct plan after first three instalments. The below analysis is combination of both regular and direct plans.
    • From 2021 I started another SIP in the fund so you will see more steps in my ‘Return’ chart.
    • I used the COVID market crash to buy more units as lump sum investments.
    • My investment in DSP Tax Saver is beating Nifty 50 Index. Yay! At least of now. And I am planning to continue with this fund in near future.

    Returns

    Profit

    XIRR


    Related reading

  • Three years of SIP with Aditya Birla Sun Life MNC Fund

    Three years of SIP with Aditya Birla Sun Life MNC Fund

    Three years ago I started investing in Aditya Birla Sun Life MNC Fund with advice from my MF advisor. The fund invests mainly in the shares of multinational companies which was very different from the large cap funds. So I decided to invest more in it via direct plan while also continuing my regular plan. So my returns here are combination of regular and direct plan of Aditya Birla Sun Life MNC Fund. Below are my key takeaways.

    • I have a monthly SIP in both regular and direct plan.
    • For me, the fund has been underperforming Nifty 50 Index since Oct-2020.
    • I am planning to continue with this fund in the near future.

    Return

    Profit

    XIRR

  • Three years of SIP with Axis Bluechip Fund

    Three years of SIP with Axis Bluechip Fund

    Three years ago I started investing in Axis Bluechip Fund with advice from my MF advisor. As it was via a distributor it is a regular plan. Below are my key takeaways.

    • I have a monthly SIP and I haven’t missed any instalment.
    • Till Sep-2021, my returns with Axis Bluechip Fund was comparable to that of Nifty 50 Index Fund. But post that, there has been a sustained underperformance which has only increased during the recent market crash.
    • I am planning to continue with this fund in the near future.

    Returns

    Profit

    XIRR

  • Three years of SIP with Mirae Asset Emerging Bluechip Fund

    Three years of SIP with Mirae Asset Emerging Bluechip Fund

    Three years ago I started investing in Mirae Asset Emerging Bluechip Fund with advice from my MF advisor. As it was via a distributor it is a regular plan. Below are my key takeaways.

    • I have a monthly SIP and I haven’t missed any instalment. In fact I wanted to increase my SIP amount but Mirae Asset has restricted further inflows in the fund.
    • My investment in Mirae Asset Emerging Bluechip Fund has outperformed Nifty 50 Index fund—that too with regular plan where I have higher expense ratio.
    • The best XIRR that I saw was in Sep-2021 where it went till 45%. Since then due to market correction it is now at 25%.
    • I am planning to continue with this fund in the near future.

    Return

    Profit

    XIRR

  • Four years with Motilal Oswal Long Term Equity Fund

    Four years with Motilal Oswal Long Term Equity Fund

    Last year I blogged about three years with Motilal Oswal Long Term Equity Fund. I continue to hold this fund and continue to be in dilemma that should I completely exit it. Now that all my units in this fund have completed 3 years, I can exit this fund. The world has changed in last one year—Covid is (nearly) gone, war has started and much more. I did not make any further investments in this fund.

    Returns

    Profit

    XIRR

  • Three years with Motilal Oswal Long Term Equity Fund

    Three years with Motilal Oswal Long Term Equity Fund

    Three years ago I went on a quest to save taxes by investing in something other than PPF. I invested in three ELSS funds and soon realised that it was too many. I have already blogged about my experience with DSP Tax Saver and L&T Tax Advantage. Here I will talk about Motilal Oswal Long Term Equity Fund, where I invested only for one year via monthly SIP.

    One significant activity during my SIP was that – this fund had invested in Manpasand Beverages and in May 2018, the auditor for Manpasand Beverages resigned sending the stock price into a free fall. I remember Motilal Oswal Fund sending an email explaining the situation.

    SIP Return

    I think, I think, the underperformance that started from Oct 2018 was a direct result of Manpasand Beverages fiasco.

    Profit

    XIRR

    I plan to sell off my entire holding in this fund by next year when all my units have completed 3 years and hope by that time the XIRR will have improved from current level of 12%.

    NOTE: XIRR for initial months varies wildly and is not useful for any analysis. But once the investments complete minimum of 1 year, XIRR gives me a much better picture. So I calculate ‘XIRR (>1 year)’ which calculates XIRR only for the investments which have completed minimum of one year while ‘XIRR’ continues to calculate for all the investments irrespective of how much time has been completed. There are some periods where ‘XIRR’ and ‘XIRR (>1 year)’ calculate to the same amount as for that time all my investments had completed more minimum of 1 year.

  • 3 years with DSP Tax Saver Fund and L&T Tax Advantage Fund

    3 years with DSP Tax Saver Fund and L&T Tax Advantage Fund

    3 years ago I decided to start investing in an ELSS fund, apart from PPF, to save taxes. After a thorough research (eeny, meeny, miny, moe), I decided to go with DSP Tax Saver Fund and L&T Tax Advantage Fund. I went via the SIP route. My first couple of instalments were in Regular plan before realising that there is something called as Direct plan which has lower expense ratio (thank you Economic Times). Below are the key steps that I did over last three years.

    1. Started SIP in April 2018
    2. SIP frequency was monthly
    3. Increased SIP every year
      • DSP Tax Saver
        • Apr 2019: + 60%
        • Apr 2020: + 87.5%
      • L&T Tax Advantage
        • Apr 2019: + 20%
        • Apr 2020: + 16.7 %
    4. If I had surplus funds in a month, then I used to invest them in the fund as lumpsum. Being one of the lucky folks who did not lose his job due to pandemic (no increments though), I was able to invest surplus amount during the blood bath in stock markets of Mar-Jun 2020.

    I have plotted the SIP Return, Profit and XIRR of both these funds from April 2018 to Mar 2021.

    DSP Tax Saver Fund

    SIP Return Chart

    From Mar to Jul 2020, I was able to invest additional fund as lumpsum, that’s why the steps are not uniform as they were in previous two years. I continued investing lumpsum after wards also, albeit less frequent, as the market seemed to be very expensive.

    Profit Chart

    During the market crash from Mar to Jun 2020, two years worth of my investments went down by ~28%. But as of Mar 2021, I am looking at a profit of ~35%.

    XIRR Chart

    The market crash of Mar-Jun 2020 was so bad that the XIRR calculations went bonkers and resulted in 0% values for sometime during Mar-Jun 2020. From Mar 2020 to Mar 2021 the XIRR has gone from ~-30% to ~+30%.

    L&T Tax Advantage Fund

    SIP Return Chart

    Similar to DSP Tax Saver, from Mar to Jul 2020, I invested additional fund as lumpsum. But the returns in L&T Tax Advantage were always inferior to DSP Tax Saver. That resulted in me pouring more money in DSP Tax Saver.

    Profit Chart

    During the market crash of Mar-Jun 2020, two years worth of my investments went down by ~35%. But as of Mar 2021, I am looking at a profit of ~30%.

    XIRR Chart

    Similar to DSP Tax Saver, the market crash from Mar to Jun 2020 caused the XIRR calculations to go bonkers and resulted in 0% values for sometime. From Mar 2020 to Mar 2021 the XIRR has gone from ~-30% to ~+20%.

  • Get MUTF_IN codes for mutual fund to use in GOOGLEFINANCE function in Google Sheets

    Get MUTF_IN codes for mutual fund to use in GOOGLEFINANCE function in Google Sheets

    Update 30-Jul-2023

    I am not sure if this was already there, but when I wrote this blog I couldn’t find this option. The below post becomes excessive in light of this new information.

    Go to https://www.google.com/finance/ and start searching for the mutual fund. The search results in the dropdown and page shows the MUTF_IN code. And that’s it!

    I have been searching for a long time on how to get the MUTF_IN code for Indian mutual funds. It has been a hit-and-miss for me trying to search on Google. Finally, I think, I figured out a sure shot way to get the MUTF_IN code.

    Go to Morning Star India. Search for your mutual fund in the search box and go to the search result page.

    Get the name of the mutual fund as it appears in the Morning Star page. For some reason Morning Star does not allow you to copy text from its site so you will have to type it. For those who are aware about Inspect Element I don’t think I need to say anything else.

    Type this name in Google search and you should get MUTF_IN code. You can then use the MUTF_IN code in the GOOGLEFINANCE in Google Sheets.

    Additional points to note

    1. This seems to work only for equity funds. Not debt or arbitrage funds (honestly, I don’t even know what an arbitrage fund is).
    2. If there is an hyphen (-) in the name of mutual fund as per Morning Star India, add space before and after it when searching it on Google.