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
Kindly Refer to
Privacy Policy &
Complete Terms of Use and Disclaimer.
I purchase 1 bhk flat at 12,75,000/- in 2010 (index II ) and sold it at 37,25,000/- in 2023 (index II) in year 2021 i purchase new flat at 57,65,200/- can I pay all funds to reduce loan on my new flat ? or shall I have to invest in cap funds ? please advice
santosh angal
Please contact me for more information
Name: S Govindarajan
Contact No: 9840175522
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
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
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
What is the password for the excel Sheet??
can we get the password for unprotecting the sheet
ANY SOFTWARE OR EXCEL FOR CALCULATING SHORT TERM & LONG TERM CAPITAL GAIN ON SHARES?
hi sir pls send me long term capital gain ( share and mutual fund )
Many Thanks. Do you have calculator for counting CG on sale of Properties with CII ?
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
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
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.
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.
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.
we sold a shop purchse in 1991 how can alculate sold shop 2016-17
“Automatic Capital Gain Calculator in Excel Format”
There are many other more useful calculators. You don’t have to enter buy and sell in one line.
Pl share if you have any other calculator for long term / short term capital gain working on shares
Which file is this? and for which year? Are you kiddingor what?
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.
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
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.