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.
From India, Mumbai
1i)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.
From India, Mumbai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Salary Sheet & PF PT Calculation & Challan Nov 2010.xls