Struggling with PF Calculation in CTC? Need Help with Excel Formula for Accurate Results

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.

Hi Vjdarne,

A model is attached for your review. Feel free to make any amendments to suit your requirements.