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
From India, Mumbai
Acknowledge(0)
Amend(0)
2One 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
From India, Mumbai
Acknowledge(0)Amend(0)
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
From India, Delhi
Acknowledge(0)Amend(0)
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
From India, Delhi
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
CTC CALCULATION SHEET.xls