Income Tax Calculator A Y 2016 – 17 Excel Download

 (Link Working)
Income Tax Calculator A Y 2016 – 17 Excel Download
Income Tax Calculator Assessment Year 2016 – 17 Excel Download
Income Tax Calculator F Y 2015 – 16 Excel Download
Income Tax Calculator Financial Year 2015 – 16 Excel Download

No Change in the Rate of Personal Income-Tax and The Rate of Tax for Companies on Income in Financial Year 2015-16 Surcharge @12% Levied on Individuals, HUFs, AOPs, BOIs, Artificial Juridical Persons, Firms, Cooperative Societies and Local Authorities Having Income Exceeding Rs 1 Crore The Union Finance Minister Shri Arun Jaitley in his Budget Speech in Lok Sabha today proposed no change in the rate of personal Income-tax.

He announced the tax proposals with no change in the rate of tax for companies in respect of the income earned in the financial year 2015-16, assessable in the assessment year 2016-17.

However, Finance Minister Shri Arun Jaitley proposed to levy a surcharge at the rate of 12% on individuals, HUFs, AOPs, BOIs, artificial juridical persons, firms, cooperative societies and local authorities having income exceeding Rs 1 crore.

Surcharge in the case of domestic companies having income exceeding Rs 1 crore and upto Rs 10 crore is proposed to be levied @ 7% and surcharge @ 12% is proposed to be levied on domestic companies having income exceeding Rs 10 crore.

Shri Jaitley further proposed that in the case of foreign companies the surcharge will continue to be levied @ 2% if the income exceeds Rs 1 crore and is upto Rs 10 crore, and @ 5% if the income exceeds Rs 10 crore.

It is also proposed to levy a surcharge @ 12% as against current rate of 10% on additional income-tax payable by companies on distribution of dividends and buyback of shares, or by mutual funds and securitization trusts on distribution of income.

The education cess on income-tax @ 2% for fulfillment of the commitment of the Government to provide and finance universalized quality based education and 1% of additional surcharge called ‘Secondary and Higher Education Cess’ on tax and surcharge is proposed to be continued for the financial year 2015-16 for all taxpayers.

Income Slabs Tax Rates:
i. Where the total income does not exceed Rs. 2,50,000/-. NIL
ii. Where the total income exceeds Rs. 2,50,000/- but does not exceed Rs. 5,00,000/-. 10% of amount by which the total income exceeds Rs. 2,50,000/-.
Less ( in case of Resident Individuals only ) : Tax Credit u/s 87A – 10% of taxable income upto a maximum of Rs. 2000/-.
iii. Where the total income exceeds Rs. 5,00,000/- but does not exceed Rs. 10,00,000/-. Rs. 25,000/- + 20% of the amount by which the total income exceeds Rs. 5,00,000/-.
iv. Where the total income exceeds Rs. 10,00,000/-. Rs. 125,000/- + 30% of the amount by which the total income exceeds Rs. 10,00,000/-.
Surcharge : 10% of the Income Tax, where total taxable income is more than Rs. 1 crore. (Marginal Relief in Surcharge, if applicable)

Education Cess : 3% of the total of Income Tax and Surcharge.

* Abbreviations used : 
   NRI – Non Resident Individual; HUF – Hindu Undivided Family; AOP – Association of Persons; BOI – Body of Individuals; AJP – Artificial Judicial Person

Individual resident who is of the age of 60 years or more but below the age of 80 years at any time during the previous year (i.e. born on or after 1st April 1934 but before 1st April 1954)

Income Slabs Tax Rates:

i. Where the total income does not exceed Rs. 3,00,000/-. NIL

ii. Where the total income exceeds Rs. 3,00,000/- but does not exceed Rs. 5,00,000/- 10% of the amount by which the total income exceeds Rs. 3,00,000/-.
Less : Tax Credit u/s 87A – 10% of taxable income upto a maximum of Rs. 2000/-.

iii. Where the total income exceeds Rs. 5,00,000/- but does not exceed Rs. 10,00,000/- Rs. 20,000/- + 20% of the amount by which the total income exceeds Rs. 5,00,000/-.
iv. Where the total income exceeds Rs. 10,00,000/- Rs. 120,000/- + 30% of the amount by which the total income exceeds Rs. 10,00,000/-.
Surcharge : 10% of the Income Tax, where total taxable income is more than Rs. 1 crore. (Marginal Relief in Surcharge, if applicable)

Education Cess : 3% of the total of Income Tax and Surcharge.

Individual resident who is of the age of 80 years or more at any time during the previous year (i.e. born before 1st April 1934)

Income Slabs Tax Rates:

i. Where the total income does not exceed Rs. 5,00,000/-. NIL

ii. Where the total income exceeds Rs. 5,00,000/- but does not exceed Rs. 10,00,000/- 20% of the amount by which the total income exceeds Rs. 5,00,000/-.

iii. Where the total income exceeds Rs. 10,00,000/- Rs. 100,000/- + 30% of the amount by which the total income exceeds Rs. 10,00,000/-.
Surcharge : 10% of the Income Tax, where total taxable income is more than Rs. 1 crore. (Marginal Relief in Surcharge, if applicable)

Education Cess : 3% of the total of Income Tax and Surcharge.

Co-operative Society:
Income Slabs Tax Rates
i. Where the total income does not exceed Rs. 10,000/-. 10% of the income.
ii. Where the total income exceeds Rs. 10,000/- but does not exceed Rs. 20,000/-. Rs. 1,000/- + 20% of income in excess of Rs. 10,000/-.
iii. Where the total income exceeds Rs. 20,000/- Rs. 3.000/- + 30% of the amount by which the total income exceeds Rs. 20,000/-.
Surcharge : 10% of the Income Tax, where total taxable income is more than Rs. 1 crore. (Marginal Relief in Surcharge, if applicable)

Education Cess : 3% of the total of Income Tax and Surcharge.

Firm:
Income Tax : 30% of total income.
Surcharge : 10% of the Income Tax, where total taxable income is more than Rs. 1 crore. (Marginal Relief in Surcharge, if applicable)
Education Cess : 3% of the total of Income Tax and Surcharge.
Local Authority
Income Tax : 30% of total income.
Surcharge : 10% of the Income Tax, where total taxable income is more than Rs. 1 crore. (Marginal Relief in Surcharge, if applicable)
Education Cess : 3% of the total of Income Tax and Surcharge.

Domestic Company:
Income Tax : 30% of total income.
Surcharge : The amount of income tax as computed in accordance with above rates, and after being reduced by the amount of tax rebate shall be increased by a surcharge
At the rate of 5% of such income tax, provided that the total income exceeds Rs. 1 crore. (Marginal Relief in Surcharge, if applicable)
At the rate of 10% of such income tax, provided that the total income exceeds Rs. 10 crores.
Education Cess : 3% of the total of Income Tax and Surcharge.
Company other than a Domestic Company

Income Tax :
@ 50% of on so much of the total income as consist of (a) royalties received from Government or an Indian concern in pursuance of an agreement made by it with the Government or the Indian concern after the 31st day of March, 1961 but before the 1st day of April, 1976; or (b) fees for rendering technical services received from Government or an Indian concern in pursuance of an agreement made by it with the Government or the Indian concern after the 29th day of February, 1964 but before the 1st day of April, 1976, and where such agreement has, in either case, been approved by the Central Government.
@ 40% of the balance

Surcharge :
The amount of income tax as computed in accordance with above rates, and after being reduced by the amount of tax rebate shall be increased by a surcharge as under
At the rate of 2% of such income tax, provided that the total income exceeds Rs. 1 crore. (Marginal Relief in Surcharge, if applicable)
At the rate of 5% of such income tax, provided that the total income exceeds Rs. 10 crores.
Education Cess : 3% of the total of Income Tax and Surcharge.

Marginal Relief : When an assessee’s taxable income exceeds Rs. 1 crore, he is liable to pay Surcharge at prescribed rates mentioned above on Income Tax payable by him. However, the amount of Income Tax and Surcharge shall not increase the amount of income tax payable on a taxable income of Rs. 1 crore by more than the amount of increase in taxable income.
Example :

In case of an individual assesseee (< 60 years) having taxable income of Rs. 1,00,01,000/-

1. Income Tax Rs. 28,30,300
2. Surcharge @10% of Income Tax Rs. 2,83,030
3. Income Tax on income of Rs. 1 crore Rs. 28,30,000
4. Maximum Surcharge payable
(Income over Rs. 1 crore less income tax on income over Rs. 1 crore) Rs. 700/- (1000 – 300)
5. Income Tax + Surcharge payable Rs. 28,31,000
6. Marginal Relief in Surcharge Rs. 2,82,330/- (2,83,030 – 700)

CLICK HERE OR CLICK HERE TO DOWNLOAD INCOME TAX CALCULATOR A Y 2016-17 EXCEL CALCULATOR (NOTE: SKIP 5 SEC AD IN DOWNLOAD PAGE)

4 thoughts on “Income Tax Calculator A Y 2016 – 17 Excel Download”

Leave a Comment