How Do You Calculate an Employee's CTC? Looking for Guidance and Resources

Dear Friends,

One more time, I need your help. Can anyone tell me how to calculate the CTC of an employee? Please send me any Excel sheet or any document that will guide me to do so.

Waiting to hear from you all.

Regards,
Anjum Joshi

Hi,

The contents of the salary breakup are as follows. You can prepare it according to your own suitability. HRA would be 50% or 60% of the basic salary.

- Basic
- HRA
- CCA - ₹825/- is exempted from tax
- Other Allowances
- 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 medical claim facility provided to employees who are not covered under ESI as the maximum ceiling for ESI is ₹10,000/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