CTC Calculation - Ctc Calculation Excel

Dear Friends,
One more time need your help.
Can anyone tell me how to calculate CTC of an employee?
Please send me any excel sheet or any document which will guide me to do so.
Waiting to hear from you all.
Regards,
Anjum Joshi

hi,
The contents of the salary break up is as below, you can prepare it at the suitability of your own. HRA would be 50 or 60% of basic.
Basic
HRA
CCA - 825/- is exempted from tax
Other Allowance
Mobile Reimbursement
Medical Reimbursement of 1250/month is exempted from tax
Gross Per Month = Sum of all the above.
Gross Per Annum= 12*Gross/Month
PF Contribution= 12% of Basic/Annum
ESI Contribution = 4.75% of Gross/Annum
Medical = the medi claim facility provided to an employee who are not covered under ESI as the maximum ceiling for ESI is 10000/Month.
Getting more than this will be covered under Medi claim or it depends on company policy
EX-Gratia/Bonus = A fixed amount as Bonus
Annual Fixed Gross Cost= Gross/Annum+ Ex-gratia
Annual Total Cost = AFGC + PF+ESIC
Annual total cost is also called as CTC.
Regards
Shivani