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

More Under Income Tax

16 Comments

  1. 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

  2. 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

  3. 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.

  4. 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.

  5. 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.

    1. D. K. SEN says:

      Sir,
      We are inherited aproperty purchase by my father we are three brother wchis is brought 300000/- in the year my past away in the year 1981. now we are agreement with ndeveloper to cash valuerecieved 30000000/- on feb 2018as per market value.Please let me known the computation of capital gain and will paid. thaking you .
      regardsD, K, Sen

      1. lav kumar pagadala says:

        my sister inherited a property from her father which was purchased in the year 1957 now she is intend to sell for Rs 60,000/- what will be her capital gains tax and other taxes to be paid, a reply will be highly appreciated.

  6. 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.

  7. 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

  8. 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

October 2020
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031