Here is the excel file
Here is the PDF file
Here is an update of the file
tutorial of the utility
https://www.youtube.com/watch?v=suMFs_c7okw
yes, you are right, i
I shall make necessary changes in the new calculator.
________________________________________________________________________________________________________________________________________________________
(a) Surcharge: The amount of income-tax shall be increased by a surcharge at the rate of 10% of such tax, where total income exceeds one crore rupees. However, the surcharge shall be subject to marginal relief (where income exceeds one crore rupees, the total amount payable as income-tax and surcharge shall not exceed total amount payable as income-tax on total income of one crore rupees by more than the amount of income that exceeds one crore rupees).
(b) Education Cess: The amount of income-tax and the applicable surcharge, shall be further increased by education cess calculated at the rate of two per cent of such income-tax and surcharge.
(c) Secondary and Higher Education Cess: The amount of income-tax and the applicable surcharge, shall be further increased by secondary and higher education cess calculated at the rate of one per cent of such income-tax and surcharge.
______________________________________________________________________________________________________________________________________
Difference between straight and break up calculation of Education cess is very marginal and ignorable.
Just fill the personal data carefully.
What do you mean by Trans. All? Please let me know the details of the exemption and how do you want to show it. It will be a good help to me if you kindly send me a sheet showing the details of the same. I shall make necessary changes to the new utility which I shall prepare for the financial year 2015-16 after acceptance of the Union Budget.
3% cess has been separated in two slab. Firstly deducted 2% as education cess and there after 1% as SHEC and I think it is the correct procedure. If the whole amount is deducted with 3%, you will get a different figure which is very marginal and the same is always ignorable as the income tax department doesn’t care the marginal amounts upto rupees 100.