Dear Ravi Sankar Iyer,
Good Evening!
Please find attached the revised sheet for the 5.0 and 3.5 Lakh packages as required.
Suggestions:
1) In your 5 Lakh salary structure, you will be paying 39160.42 + 2835 + 2500 = 44495.83 X 12 (months) = 533940 CTC. It is showing the wrong CTC, higher by 33940 yearly. You can make the same changes in the 3.5 CTC structure as well.
2) In your 3.5 Lakh salary structure, you have calculated Employer's PF (13.61%) on HRA, which is incorrect. It should be on Basic.
3) As per the latest amendments in PF laws, the PF Ceiling Limit has increased from 6500 to 15000. In the 5 Lakh salary structure, the Basic is above 15000, so you may exclude PF if it is not required by the Employee. In the 3.5 CTC, PF becomes compulsory as the Basic is 14584.
4) Even considering the ceiling limit, you may decide the PF max limit up to 1800 (15000*12% OR 15000*13.61% = 2042) if your company policy allows. This will lower your manpower cost without violating government laws.
Please revert in case you require any more information.
All the best!