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 employers PF in CTC which is capped to maximum 1800 pm and is calculated on basic and Other allowance. So here i have 2 values that are unknown ie PF calculation and OA. Please help me out with an excel formula to work out the same.
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 employers PF in CTC which is capped to maximum 1800 pm and is calculated on basic and Other allowance. So here i have 2 values that are unknown ie PF calculation and OA. Please help me out with an excel formula to work out the same.