Cost To Company Calculation Methods - XLS Download

SALARY DETAILSPer AnnumPer MonthlyGross Salary3,500 BASIC 2,100 HRA 315 CONVEYANCE315 CITY CAMPANSATION ALLOWANCE 315 MEDICAL ALLOWANCE462 OTHER ALLOWANCE Gross Salary3,507 PF Employees Contribution252 ESI61 PT 120 MLWF(IF 3500<0,"6" or 3500>0,"12")2 P.M. Net Salary2,994 PF Employer Contribution 252 ESI Employer Contribution166 MLWF Employer Contribution6 BOUNS174.93 GRATUTY168.27 Current Cost to the Company4,274
14th November 2008 From India, Thana

Hi Asmita, This is Pushpak from Hyd. could you please make your calculations more clear without putting it in a single line.
14th November 2008 From India, Hyderabad

Hi, I m Ila from Ahmedabad. I m hereby attaching the salary calculation sheet. thanks, Ila
17th November 2008 From India, Ahmadabad

Attached Files

Membership is required for download. Create An Account First

Salary_break_up_calculator_(1).xls (17.5 KB, 2533 views)

In calculating the CTC, following are also considered:
1. Allowances like
a. Children education allowances, hostel subsidy, etc.
b. News paper / periodical allowances
c. Washing allowances
d. Tea / coffee / refreshment reimbursement
2. If company provides housing & vehicle advances then it might have less interest rates (than market / external bank rates). This advantage in interest is considered as an income and so, considered for CTC also.
3. Medical allowances / insurances & related expenses. Here also, every company has laid down margins. Some say unlimited. Some say Rs.15,000 and anything above this as taxable. Some may have other formats for disbursing this benifit.
4. Apart from bonus, performance linked incentives (which are calculated on the basis of your reviewer's rating with respect to your appraisal) are also considered.
5. Leave travel allowances.
6. Regular uniforms / boiler suits / safety shoes / regular shoes, if provided by the company. All these are considered.
7. Similar to housing and vehicle advances, some company have schemes of providing furniture / households and PC / Laptops on hire basis wherein the employee has to buy back these after a certain perion of time. Advantage of interests here are also considered.
8. Expenses for maintenance / upgradation of above are also provided by some companies and are considered for CTC.

Yet, there may be other considerations too beyond these. Can anyone share any comprehensive derivation of a typical CTC ? I need one badly. Guys, help me.

Regards,
Ayon
24th November 2008 From India, Delhi

Hi, I am Lakshmanan from Chennai. Could you please attach the calculation for Excel Sheet. Regards, Lakshmanan M 9840344092
24th November 2008 From India, Madras

hi Ila, Actually u have made very easy to calculate the salary but, i would suggest that the Basic should be 40% of Gross, Hra Should be 40% on Basic, other things dont matter me
9th December 2008 From India, Bangalore

Dear Ayon,
Thanks for CTC details... Whether Performance pay or incentives are also part of CTC?If yes, its quite possible that an employee will not get certain amount since he/she has not performed right>?
Whether GRATUITY is also part of CTC? Which as per Gratuity Act payable only after 5 yrs. right?
PLS REPLY
CHINMAY
EXECUTIVE - HR
SAPAT INTERNATIONAL PVT. LTD.
16th December 2008 From India, Mumbai