Tax Calculation Issue - Xls Download

Hi Everyone,
I am working as a executive HR spoc in France Based MNC.I am unable to Understand the tax calculation and its not part of my job but i have to do it because i a m suffering from last 2 month mentally torcher.please guide me for this.Details are mentioned below
Name ABC
Basic 22000
HRA 11000
Conveyance Allowance 2000
Education Allowance 400
Special Allowance 3000
Monthly Gross 38400
Annual Gross 460800
Annual Bonus 50000
Annual Income Total 510800

PF 2640
Annual PF 31680
P.Tax 150
Annual P.tax 1800
Please provide the tax calculation wid annual income after deduction tax for unmarried men & women and Married Men& women urgent basis
Thanks & Regards,

Hi
I am enclosing a tool for calculating the tax. hope it might help you to calculate. I feel it is better if you could have added the medical allowance to reduce the tax
To calculate the TDS you should require all the savings details also.
These tax calculations are done by finance team rite?

you can update the relevant details in the relevant fields. So by default it will calculate the tax

Dear Sweksha,
As you asked, there is no bar for married/unmarried or Fale/Female in Income Tax.
Mr. Jeeva has helped you with a tool thru which TDS (Income Tax) can be calculated.
But before reaching on any Tax deductions, there are many Exemptions, Allowance, Deduction which can be deducted from salary before making any Tax Deduction. The scenario can be different person to person. For better understanding, pls note the below:-
HRA Exemption (almost 50%)- Can b more or less as per actual situation
Conveyance - 19600/pa
80 c Deductions-1.50 L/pa
However, I have made calculation as per detail provided by u. Hope this will meet your requirement.

I have just joined this forum. All the queries sought by me reg tax calculation intt calculation have been provided by u n it will be of great help for me.

how to calculate salary increment sheet with pf & esi calculation