How to Calculate Tax on SIP in Mutual Funds?

SIP or Systematic Invest Plan in Mutual Funds have become quite popular among investors. However, most people are not clear about how their SIP would be taxed on redemption.

To answer the taxation aspect, we need to understand what SIP is?

SIP is buying of mutual funds every month (or daily) with a fixed amount. The only difference is the entire process of investment has been automated for a period of time. Each SIP installment for all practical purpose is like a fresh investment in mutual fund. So, on redemption the capital gains are calculated based on investment in each SIP installment. We explain this by an example:

Suppose I have invested in IDFC Premier Equity Direct-G using SIP of Rs 5,000 from January to December 2016 on 1st of every month (total 12 installments).

At the end of SIP total number of units was 802 units as shown in table below:

SIP Date SIP Amount Quantity Purchased Purchase NAV
1-Jan-16 5,000 66.84 74.81
1-Feb-16 5,000 71.43 70.00
1-Mar-16 5,000 75.98 65.80
1-Apr-16 5,000 71.55 69.89
2-May-16 5,000 68.93 72.54
1-Jun-16 5,000 67.33 74.26
1-Jul-16 5,000 65.57 76.26
1-Aug-16 5,000 62.19 80.40
1-Sep-16 5,000 62.84 79.56
3-Oct-16 5,000 61.30 81.56
1-Nov-16 5,000 61.33 81.53
1-Dec-16 5,000 66.97 74.66
Total 60,000 802.25  

Also Read: 23 most common Investments and how they are Taxed?

Now we take different scenarios and calculate Long Term and Short-Term Capital Gains/Loss.

Tax on SIP in Mutual Funds
Tax on SIP in Mutual Funds

Just to reinstate, for equity funds gains/losses from units sold after 1 year of investment is classified as long-term capital gains/losses while units sold with-in 1 year of investment is short-term capital gains/losses.

Scenario 1: Redemption Within 1 Year of completion of SIP

I sell all units on June 2, 2017. What would be my Long Term and Short-Term Capital Gains/Loss?

All SIP installments between January 1 to June 1, 2016 have completed at least 1 year of investment, so would qualify for Long Term Capital Gains, while SIP between July to December would be short term capital gains. The table below explains the calculation.

Selling all Units on June 2, 2017 with NAV of Rs 88.8727
SIP Date Quantity Purchased Purchase NAV Purchase Value Sell Value Capital Gains Short Term Capital Gains Long Term Capital Gains
1-Jan-16 66.84 74.81 5,000 5,940 940 0 940
1-Feb-16 71.43 70.00 5,000 6,348 1,348 0 1,348
1-Mar-16 75.98 65.80 5,000 6,753 1,753 0 1,753
1-Apr-16 71.55 69.89 5,000 6,358 1,358 0 1,358
2-May-16 68.93 72.54 5,000 6,126 1,126 0 1,126
1-Jun-16 67.33 74.26 5,000 5,984 984 0 984
1-Jul-16 65.57 76.26 5,000 5,827 827 827 0
1-Aug-16 62.19 80.40 5,000 5,527 527 527 0
1-Sep-16 62.84 79.56 5,000 5,585 585 585 0
3-Oct-16 61.30 81.56 5,000 5,448 448 448 0
1-Nov-16 61.33 81.53 5,000 5,450 450 450 0
1-Dec-16 66.97 74.66 5,000 5,952 952 952 0
Total 802.25   60,000 71,298 11,298 3,789 7,509

Download: Tax Planning Guide for FY 2018-19

Scenario 2: Redemption after 1 Year of completion of SIP

I sell all units on December 28, 2017. What would be my Long Term and Short-Term Capital Gains/Loss?

All SIP installments between January to December 2016 have completed at least 1 year of investment, so would qualify for Long Term Capital Gains, and there would be NO short-term capital gains. The table below explains the calculation.

Selling all Units on December 28, 2017 with NAV of Rs 101.3288
SIP Date Quantity Purchased Purchase NAV Purchase Value Sell Value Capital Gains Short Term Capital Gains Long Term Capital Gains
1-Jan-16 66.84 74.81 5,000 6,773 1,773 0 1,773
1-Feb-16 71.43 70.00 5,000 7,238 2,238 0 2,238
1-Mar-16 75.98 65.80 5,000 7,699 2,699 0 2,699
1-Apr-16 71.55 69.89 5,000 7,250 2,250 0 2,250
2-May-16 68.93 72.54 5,000 6,984 1,984 0 1,984
1-Jun-16 67.33 74.26 5,000 6,822 1,822 0 1,822
1-Jul-16 65.57 76.26 5,000 6,644 1,644 0 1,644
1-Aug-16 62.19 80.40 5,000 6,302 1,302 0 1,302
1-Sep-16 62.84 79.56 5,000 6,368 1,368 0 1,368
3-Oct-16 61.30 81.56 5,000 6,212 1,212 0 1,212
1-Nov-16 61.33 81.53 5,000 6,214 1,214 0 1,214
1-Dec-16 66.97 74.66 5,000 6,786 1,786 0 1,786
Total 802.25   60,000 81,291 21,291 0 21,291

Also Read:  Best Tax Saving Investments u/s 80C

Scenario 3: Redemption in between of SIP

I had an emergency and head to sell units midway when the SIP was on. So, I sell all units available on June 3, 2016.  What would be my Long Term and Short-Term Capital Gains/Loss?

Many think that when SIP is running the units cannot be sold. This is NOT true. As we stated earlier, each SIP installment is like individual investment but automated. So, you can sell all units accumulated till date even while SIP is running. Like in the present scenario, we have accumulated 422 units from January to June. We can redeem all of it if required.

As SIP installments between January to June 2016 have not completed 1 year of investment, so would qualify Short-term capital gains. There would be NO Long-term capital gains in this case. The table below explains the calculation.

Selling Units accumulated till June 2, 2016 (mid way of SIP) with NAV of Rs 74.5744 
SIP Date Quantity Purchased Purchase NAV Purchase Value Sell Value Capital Gains Short Term Capital Gains Long Term Capital Gains
1-Jan-16 66.84 74.81 5,000 4,984 -16 -16 0
1-Feb-16 71.43 70.00 5,000 5,327 327 327 0
1-Mar-16 75.98 65.80 5,000 5,666 666 666 0
1-Apr-16 71.55 69.89 5,000 5,336 335 335 0
2-May-16 68.93 72.54 5,000 5,140 140 140 0
1-Jun-16 67.33 74.26 5,000 5,021 21 21 0
1-Jul-16 65.57 76.26 5,000 0 0 0 0
1-Aug-16 62.19 80.40 5,000 0 0 0 0
1-Sep-16 62.84 79.56 5,000 0 0 0 0
3-Oct-16 61.30 81.56 5,000 0 0 0 0
1-Nov-16 61.33 81.53 5,000 0 0 0 0
1-Dec-16 66.97 74.66 5,000 0 0 0 0
Total   31,474 1,474 1,474 0

Once you are able to determine your losses as long term or short term the taxation is easy.

Also Read: 3 Reasons Why Growth Option is better than Dividend Option in Equity Mutual Fund?

Long/Short Term Capital Gains Tax on Mutual Funds:

For Equity Mutual Funds:

Starting April 1, 2018 Long Term Capital Gains of more than Rs 1 Lakh would be taxed at the rate of 10.4% (including cess). This was introduced in Budget 2018. Until last financial year (FY 2016-17) the long-term capital gains from equity funds were tax free.

The Short-Term Capital Gains are taxed at 15.6% (including cess).

Also Read: Detailed Taxation of Equity & Debt Mutual Fund

We would take the above three scenarios and calculate tax on the same.

Scenario 1:

We calculate the taxes before and after FY 2018-19 as the rules changed from April 1, 2018.

Capital Gains Type Tax Rate (pre FY 2018-19) Tax before FY 2018-19 Tax Rate (post FY 2018-19) Tax in FY 2018-19
3,789 Short Term 15.45% (including cess) 584 15.60% (including cess) 591
7,509 Long Term 0% 0 10.4% (if capital gains > 1 Lakh) 781

Scenario 2:

We calculate the taxes before and after FY 2018-19 as the rules changed from April 1, 2018.

Capital Gains Type Tax Rate (pre FY 2018-19) Tax before FY 2018-19 Tax Rate (post FY 2018-19) Tax in FY 2018-19
0 Short Term 15.45% (including cess) 0 15.60% (including cess) 0
7,509 Long Term 0% 0 10.4% (if capital gains > 1 Lakh) 2,214

Also Read: SIP Vs. Lumpsum – Which is the Best way to Invest in Mutual Fund?

Scenario 3:

We calculate the taxes before and after FY 2018-19 as the rules changed from April 1, 2018.

Capital Gains Type Tax Rate (pre FY 2018-19) Tax before FY 2018-19 Tax Rate (post FY 2018-19) Tax in FY 2018-19
1,474 Short Term 15.45% (including cess) 228 15.60% (including cess) 230
0 Long Term 0% 0 10.4% (if capital gains > 1 Lakh) 0

For Debt Mutual Funds:

Long Term Capital Gains/Losses: If the redemption of mutual fund happens after 3 year of investment [Changed in Budget 2014], the gains or losses are classified as long term capital gains/losses in case of equity mutual fund.

Short Term Capital Gains/Losses: If the redemption of mutual fund happens with-in 3 year of investment, the gains or losses are classified as short term capital gains/losses in case of equity mutual fund.

For Debt Funds the tax calculation a bit more complicated as you need to consider indexation too.

Long Term Capital Gains are taxed at the rate of 20.8% (including cess) after taking indexation benefit.

The Short Term Capital Gains are added to the total income and taxed at the marginal income tax slabs.

Also Read: How SWP in Debt Mutual Funds is better than Fixed Deposit for Regular Income?

To Conclude:

Each SIP installment for all practical purpose is like a fresh investment in mutual fund. So, on redemption the capital gains are calculated based on investment in each SIP installment. We hope the tax calculation examples above would have cleared the taxation on SIP in Mutual Funds.

5 thoughts on “How to Calculate Tax on SIP in Mutual Funds?”

  1. How to calculate ltcg tax on mf if holding period is more than 2 years? Do we have to consider 2 lacs as tax free(for two years).
    Scenario: I have purchased mf on 1 april 2018 and I am selling on 2 april 2020 and my profit is 2 lakh, so in this scenario do I have to pay any ltcg tax.

  2. Hi Mr. Amit, why should one pay any tax if Long Term capital gain is less than Rs. 1lac? In scenario 1 & 2 shouldn’t there be any tax on Long Term gains, right?

    1. This might not be the only long term capital gains for the person. So I have mentioned in case the LTCG is greater than 1 lakh!

Leave a Reply to Sabarish Cancel Reply

Your email address will not be published. Required fields are marked *