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.
Download Automatic Capital Gain Calculator in Excel Format
(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 |
Income tax Calculator for FY 2016-17 / AY 2017-18
|
| 2. | Income Tax Slab for FY 2015-16 AY 2016-17 |
Income tax Calculator for F.Y. 2015-16 / A.Y. 2016-17
|
| 3. | Income Tax Slab for FY 2014-15 AY 2015-16 |
Income Tax Calculator For FY 2014-15 / AY 2015-16
|
| 4. |
Income Tax rates for FY 2013-14 / AY 2014-15
|
Income Tax Calculator for FY 2013-14 / AY 2014-15
|
| 5. | Income tax Slab for FY 2012-13 / AY 2013-14 | Income Tax Calculator FY 2012-13 / AY 2013-14 |
| 6. |
Income Tax Slab from Assessment year 2001-2002 to A.Y. 2012-2013
|
Income tax calculator for FY 2006-07 to FY 2016-17 |
| 7. | Income Tax Slab Rates from AY 1992-93 to AY 2015-16 |
Download Income Tax Calculator for A.Y. 2012-13, 2011-12, 2010-2011
|