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(0)
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(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Salary Sheet & PF PT Calculation & Challan Nov 2010.xls