Ctc Calculation Xls Download

Dear sir,
Can anyone please calculate the Gross pay for Rs.264000/- pa (CTC) using the following components and send it to me
BASIC
HRA
CONVEYANCE
SPL ALL.
LTA
MED ALL
EX-GRATIA
GRATUITY

hey hi......tell me whether this is right or not ok....
BASIC 128000
HRA 51200
CONVEYANCE 15360
SPL ALL. 11570.5
LTA 8000
MED ALL 25600
EX-GRATIA 11570.5 (Ex gratia is for one time payment what Special Allowance is for monthly.....)
GRATUITY[/QUOTE] 12699 (4.81%)

Dear Laxmi,
Salary Components Monthly Figures
Basic 8800
HRA 4400
Convenyance 800
S.A 3934
Medical 1250
LTA 2083
Ex Gratia 733.04
Annual Salary 264000 SUM(total components)*12
Regards,
Preyrna
HR Proffesional

Dear Lakshmi,
In CTC you can include all amount which is visible in salary slip+ employer contribution ( P F/ ESI( if applicable)+Bonus/ ex- gratia + any monetary benefit which is given to employee by company.
This is called CTC means Cost to company.In this you have to include all those monetary benefit, which is given by company as compensation.

I have a doubt as to whether non monatory benefits are also included in CTC like- Hospital facility, canteen facility, housing facility. Please give ur opinion on this.

Dear Lakshmi,
As a general practice the companies is not including in kind facilities while defining CTC. The CTC normally includes the monetary payments to the employees. In general the CTC may defined as the sum of:
All Allowances (by whatever name u called),Reimbursement of actual expenses, annual bonus and the retirals.

Madam,
Pl. find a attachment for your ref. - hope it is helpful to you.
Renu

Dear all,
Can anyone help me how to calculate this structure with formulas
BASIC
HRA
CONVEYANCE
SPL ALL.
LTA
MED ALL
EX-GRATIA
GRATUITY
thanks,
Dhanasekar.