Salry Breakup Required - Xls Download

Hi!
I am in urgent need of a tax friendly (both for employee as well as employer)salary breakup which can be used for all employees. I also need to know as to what are the things which needs to be kept in mind while calculating the breakup.
Hope to get a prompt reply.
Regards,
Sweetner.

Hi,
Please find the attachment. It may be useful to you. Just enter the CTC amount in the the CTC colum. If you want to know the calculation Just select each column and press F2.Do not Enter a CTC over and above 500000/-. It will affect the calculation of TDS.If You know Tax you will be able to understand what i mean.

Dear Sir,
We have new company, presently we have only consolidated salary structure only. Now we wish to bring PF facility to all the employees. Before this I would like to know how to give break-up the CTC into Basic,HRA etc... which should be benefited to employees. Kindly advise me.
thanking
V.V.SARMA
MANAGER, ACCOUNTS
WETELL GROUP

Hi,
how do we calculate the following for a ctc of 350000rupees.
1)Basic.2)HRA. 3)Conveyance.4)professional tax.5)medical allowance.6)medical insurance

dear sir,
I need 5 lac ctc urgent required