Calculate Basic Salary From Ctc - Xls Download

could anybody tell me how to calculate the basic salary from ctc with formula....plz help me

could you tell why this fourmula is used for basic salary???
=round(sum(c3-500)*100/192,0))

Hi,
Let assume your CTC PA is 200000
then divided by 12 then u get Monthly CTC means 200000/12=16,666Pm
then you can considered aither 40 or 50 % of that CTC as Basic I.e., 16,666*50/100=8333 is your monthly Basic

Recently im also working as a H.R with one company bt my specilisation is not finance.. need human resource policy and the criteria of payroll how to calculate when we have to provide only basic salary..plz anyone can provide me the format of leave policy 4 any organisation.

Reasonably good formula to adapt will be as under
1. 35% of CTC as Basic
2. 30% of CTc as Monthly allowances like HRA Conveyanc etc
3. 5% of CTC as annual benefits like LTA etc
4.20% of CTC as Bonus or Performance payment This will be a varaiable pay
5.10 of CTC towards PF Gratuity and other social securtiy measures
This formula generally works well Few modifications in percentages can be made to suit your requirements
T Sivasankaran

Basic salary depends upon Grade/level of employee. It will differ from company to company. Every company has/may have a different slabs for various grades/levels of employees. Lower the grade lower is the basic salary. Basic salary may be 30% - 50% of gross/CTC.
Regards

Dear Pintu,
Exact calculation of Basic Salary from CTC cannot be done untill and unless all the components of the salary be identified.
Taking a reference point of "Basic Salary", CTC is derived and not the other way round.
Regards

The components of CTC differ from company to company.There is no such specific compulsory %age to be deemed as Basic from the Gross or CTC. In case of Minimum wages we take Basic Approx. 80-95% of Gross, while in other case i.e. higher slab it may deemed approx. 40-50% of Gross.
regards,

Dear Sir,
CTC includes Basic + Other allowances + Annual benefits + Fringe benefits. (Tota salary + Other emoluments) per annum.
CTC Differs from one concern to another concern as per their policy. Normally Basic Pay will be 30 to 50% of CTC % 12 = Per month emoluments as per Co.Policy.
D.Gurumurthy
LL,HR & IR Consultant
Hyderabad.

Hi to all,
Hope you are doing great!
I have a small doubt, actually HRA, Conveyance, Medical allowance how much exemption in income tax for the F.Y 2011-12, Plse Advice to me & give some sample files
thanks in advance
Manu