How to use the Calculator
1) Ensure that you have MS Office 2010 or later to get this CG calculator working. (Macros should be enabled)
2) It is a simple calculator, by seeing it anyone can fairly understand it.
3) Insert the scrip name date of purchase and date of sale and respective amounts, it will automatically calculate the stock and STCG/LTCG and also the period of holding. Ensure that you put Purchase and Sale date in one line or else the formula wont for work for stock and it would show mismatch.
4) After inserting all the details click on Quickbar button at the top and there will  be options to insert rows, column, calculate STCG and LTCG and intra day etc. Once you click the report will be generated and automatically it will set the print area accordingly so that you can just take print out or take a pdf file and email it to the client.
5) The sheet is only for educational purpose and hence it is totally unlocked. You can also insert or edit formulas the way you like.

(Submitted byAnish Gandhi.CA Student from Mumbai)

 ALSO READ
S.NO. INCOME TAX SLAB
INCOME TAX CALCULATORS
1. Income Tax Slabs for FY 2016-17 / AY 2017-18
2. Income Tax Slab for FY 2015-16 AY 2016-17
3. Income Tax Slab for FY 2014-15 AY 2015-16
4.
5.  Income tax Slab for FY 2012-13 / AY 2013-14 Income Tax Calculator FY 2012-13 / AY 2013-14
6. Income tax calculator for FY 2006-07 to FY 2016-17
7. Income Tax Slab Rates from AY 1992-93 to AY 2015-16

Join Taxguru’s Network for Latest updates on Income Tax, GST, Company Law, Corporate Laws and other related subjects.

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Telegram

taxguru on telegram GROUP LINK

Review us on Google

More Under Income Tax

25 Comments

  1. Vimal Goyal says:

    Till you run macro, you can edit the excel sheet. Once macro (through Quick bar) is run, then for any further changes, the message comes to unprotect the sheet and asks for a password. Pl share the password

  2. Vimal Goyal says:

    Formula given in column N appears to be wrong. It states: =IF((C6-I6)0,C6-I6,”-“) where C6 is purchase qty, I6 is sale qty. By this formula, when purchase qty is higher /lower than sale qty, then that difference in qty appears, if both purchase and sale qty are same, then _ sign appears

  3. T V Venugopal says:

    Purchased flat in the year 2016 ₹18,00,000/-+1,00,000/- ( Stamp & Registration Charges) + 2,00,000/- maintenance of the flat.

    Want to sell the flat: now the rate is approximately ₹ 35,00,000/-
    Iam a retired senior citizen 🧓. ( General Candidate Worked in Pvt. CO’s. No Pension so want sell the flat)
    What’s the capital gain how much I have to pay or any other schemes to save the tax amount
    Please advise

  4. Ronald Dsouza says:

    I purchased a plot on 13/01/2014 for Rs. 378420/- and sold it on 18/07/2019 for Rs. 1410000/- How much money would I have to invest in LTCG Capital Bonds

  5. Ronald Dsouza says:

    I purchased a plot on 13/01/2014 for Rs 282000/- plus expenses of Rs. 96420/- which includes stamp duty, registration etc. I sold the plot on 18/07/2019 for Rs. 1410000/- How much money would I have to invest in capital bonds

  6. Rameswar Nandy says:

    I purchased a plot of land of 2560 sq.ft. by Rs.80,000/- in 1994 at Halisahar, Dist. North 24 Parganas, West Bengal. I have then constructed my house of 900 sq.ft. on that plot of land by Rs.6,00,000/- in the year-1999.
    Now I want to sell the whole property e.g.above land including the house (constructed in1999) by Rs.40,00,000/-
    Please inform me the amount of capital gain.

  7. LN Das says:

    How to arrive at LTCG value i.e. what are added to acqusition price i.e. stamp duty on purchase, modifications carried out in House etc. Pl explain.

  8. Ganti venkata ravi Kumar says:

    I was inherited a property purchased by My father, I am only son, which he brought for Rs.20000/- in the year 1970, Now I wanted to sell this property the market value of the property is around Rs.18500000/- please let me know the exact amount of capital gain.

  9. CA. PARAG JANI says:

    Good attempt but sheet will not work when transactions are voluminous. And there is no facility of stock register in case of multiple scrip names. Lot of improvement is required.

  10. Dinesh Khairatkar says:

    Good for small investors to understand and thanks for leaving the scope for editing or adding the formulas the way it requires as the law will keep changing…

    Best wishesh
    Good day

    Regards

  11. REENA says:

    WHEN WE ARE PUTTING THE DATE OF SELL IT IS NOT TAKING GIVING ERROR MESSAGE THAT THE DATE OF SELL SHOULD EITHER EQUAL OR GREATER THAN THE DATE OF PURCHASE.

Leave a Comment

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

Search Posts by Date

May 2022
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031