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)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.