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 DateSIP AmountQuantity PurchasedPurchase NAV
1-Jan-165,00066.8474.81
1-Feb-165,00071.4370.00
1-Mar-165,00075.9865.80
1-Apr-165,00071.5569.89
2-May-165,00068.9372.54
1-Jun-165,00067.3374.26
1-Jul-165,00065.5776.26
1-Aug-165,00062.1980.40
1-Sep-165,00062.8479.56
3-Oct-165,00061.3081.56
1-Nov-165,00061.3381.53
1-Dec-165,00066.9774.66
Total60,000802.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 DateQuantity PurchasedPurchase NAVPurchase ValueSell ValueCapital GainsShort Term Capital GainsLong Term Capital Gains
1-Jan-1666.8474.815,0005,9409400940
1-Feb-1671.4370.005,0006,3481,34801,348
1-Mar-1675.9865.805,0006,7531,75301,753
1-Apr-1671.5569.895,0006,3581,35801,358
2-May-1668.9372.545,0006,1261,12601,126
1-Jun-1667.3374.265,0005,9849840984
1-Jul-1665.5776.265,0005,8278278270
1-Aug-1662.1980.405,0005,5275275270
1-Sep-1662.8479.565,0005,5855855850
3-Oct-1661.3081.565,0005,4484484480
1-Nov-1661.3381.535,0005,4504504500
1-Dec-1666.9774.665,0005,9529529520
Total802.25 60,00071,29811,2983,7897,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 DateQuantity PurchasedPurchase NAVPurchase ValueSell ValueCapital GainsShort Term Capital GainsLong Term Capital Gains
1-Jan-1666.8474.815,0006,7731,77301,773
1-Feb-1671.4370.005,0007,2382,23802,238
1-Mar-1675.9865.805,0007,6992,69902,699
1-Apr-1671.5569.895,0007,2502,25002,250
2-May-1668.9372.545,0006,9841,98401,984
1-Jun-1667.3374.265,0006,8221,82201,822
1-Jul-1665.5776.265,0006,6441,64401,644
1-Aug-1662.1980.405,0006,3021,30201,302
1-Sep-1662.8479.565,0006,3681,36801,368
3-Oct-1661.3081.565,0006,2121,21201,212
1-Nov-1661.3381.535,0006,2141,21401,214
1-Dec-1666.9774.665,0006,7861,78601,786
Total802.25 60,00081,29121,291021,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 DateQuantity PurchasedPurchase NAVPurchase ValueSell ValueCapital GainsShort Term Capital GainsLong Term Capital Gains
1-Jan-1666.8474.815,0004,984-16-160
1-Feb-1671.4370.005,0005,3273273270
1-Mar-1675.9865.805,0005,6666666660
1-Apr-1671.5569.895,0005,3363353350
2-May-1668.9372.545,0005,1401401400
1-Jun-1667.3374.265,0005,02121210
1-Jul-1665.5776.265,0000000
1-Aug-1662.1980.405,0000000
1-Sep-1662.8479.565,0000000
3-Oct-1661.3081.565,0000000
1-Nov-1661.3381.535,0000000
1-Dec-1666.9774.665,0000000
Total 31,4741,4741,4740

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 GainsTypeTax Rate (pre FY 2018-19)Tax before FY 2018-19Tax Rate (post FY 2018-19)Tax in FY 2018-19
3,789Short Term15.45% (including cess)58415.60% (including cess)591
7,509Long Term0%010.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 GainsTypeTax Rate (pre FY 2018-19)Tax before FY 2018-19Tax Rate (post FY 2018-19)Tax in FY 2018-19
0Short Term15.45% (including cess)015.60% (including cess)0
7,509Long Term0%010.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 GainsTypeTax Rate (pre FY 2018-19)Tax before FY 2018-19Tax Rate (post FY 2018-19)Tax in FY 2018-19
1,474Short Term15.45% (including cess)22815.60% (including cess)230
0Long Term0%010.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 Comment

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