Hi all,
According to my company standards, the CTC breakup is as below:
i) Basic - 40% of CTC
ii) HRA - 50% of basic
iii) LTA - 1 month basic in a year
iv) Other allowance - "x" value
We also include employer's PF in CTC, which is capped at a maximum of 1800 per month and is calculated based on basic and other allowance. So here, I have 2 values that are unknown, i.e., PF calculation and OA. Please help me out with an Excel formula to work out the same.
From India, Mumbai
Acknowledge(1)
Amend(0)
1According to my company standards, the CTC breakup is as below:
i) Basic - 40% of CTC
ii) HRA - 50% of basic
iii) LTA - 1 month basic in a year
iv) Other allowance - "x" value
We also include employer's PF in CTC, which is capped at a maximum of 1800 per month and is calculated based on basic and other allowance. So here, I have 2 values that are unknown, i.e., PF calculation and OA. Please help me out with an Excel formula to work out the same.
From India, Mumbai
Acknowledge(1)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.
PF CHALLAN & CALCULATION SHEET.xls
PF not applicable on CTC 18.3.2014.pdf