# Automatic Capital Gain Calculator in Excel Format

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

GROUP LINK

GROUP LINK

GROUP LINK

GROUP LINK

GROUP LINK

GROUP LINK

GROUP LINK

GROUP LINK

GROUP LINK

GROUP LINK

GROUP LINK

### 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. SA says:

What is the password for the excel Sheet??

5. harsh says:

can we get the password for unprotecting the sheet

6. Nikunj Desai says:

ANY SOFTWARE OR EXCEL FOR CALCULATING SHORT TERM & LONG TERM CAPITAL GAIN ON SHARES?

1. umesh says:

hi sir pls send me long term capital gain ( share and mutual fund )

7. Janak says:

Many Thanks. Do you have calculator for counting CG on sale of Properties with CII ?

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

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

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

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

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

13. bachan singh bisht says:

we sold a shop purchse in 1991 how can alculate sold shop 2016-17

14. J a says:

“Automatic Capital Gain Calculator in Excel Format”

15. Vijay says:

There are many other more useful calculators. You don’t have to enter buy and sell in one line.

1. Vimal Goyal says:

Pl share if you have any other calculator for long term / short term capital gain working on shares

16. Amol Joglekar says:

Which file is this? and for which year? Are you kiddingor what?

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

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

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