Circular Formula & Reverse calculation

[Rajesh S]

Hi,

I am working on the CTC structure changes for India. While computing for the restriction due to Minimum Wages, I have the below challenge.

Sample case:
Total CTC agreed is Rs. 75000/- out of which Statutory bonus will be Rs 3500/-. Remaining amount under CTC is Rs. 71500/-. Since CTC will comprise the Employer contribution in PF & ESI apart from Basic, reverse computation of Basic is mandated. Employer contribution in PF will be 12% & in ESI will be 4.75%. Need to arrive the basic so that the total CTC incl bonus is 75000.

It would be better if excel formulae is used for this calculation instead of Macro.

Please help.

Regards

S Rajesh

 

[Syedali]

Can anyone help me please

Hi Mr Rajesh , You already putted formula.
What is your exact requirement Can you post with example data set.
Can you elaborate.

 

[NARAYANK991]

Hi Rajesh ,

See if this is OK.

Narayan

 

[Rajesh S]

Hi,

I have given the formula for understanding. My requirement is elaborated in my mail content.

Sample case:
Total CTC agreed is Rs. 75000/- out of which Statutory bonus will be Rs 3500/-. Remaining amount under CTC is Rs. 71500/-. Since CTC will comprise the Employer contribution in PF & ESI apart from Basic, reverse computation of Basic is mandated. Employer contribution in PF will be 12% & in ESI will be 4.75%. Need to arrive the basic so that the total CTC incl bonus is 75000.

Basic to be auto-calculated (reverse gross up) based on the values being picked up in PF employer & ESI employer contribution which is itself a resultant figure of basic change.

 

[Rajesh S]

Thanks Narayan. This is really fantastic. Working fine.