Ctc - Xls Download [thread 71142]

amit_sainik
Hi,
Can any Inform me How to calculate Cost to Company CTC?
Mail me in [Login to view]
Amitmhrm
Hi Amit,
The contents of the salary break up is as below, you can prepare it at the suitability of your own. HRA would be 40 to 60% of basic.
Basic
HRA
TA
Other Allowance
Mobile Reimbursement / Month
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 mediclaim 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 Mediclaim 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.
Hope it would help you to prepare the same at your end..
Regards,
Amit Seth.
sharad jauhri
hello
i am attaching an excel file where i have developed my own ctc calculation, the one on the right side
regards,
sharad
1 Attachment(s) [Login To View]

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute