How To Calculate The Ctc Xls Download
MOONSKY Started The Discussion:
Please provide information about how to calculate the CTC. regards Satish Kumar Yadav
Hi Satish,

Plz find below the Breakup Part in one's CTC:-

Basic= 40% of CTC(varry from 30% to 40% from company to company)
HRA= 50% of Basic (for Metros) and 40% of Basic(for rest part)
Convayance Allow
Medical Allow
Special Allow
Other Allow

Summing all above gives Gross Salary
Further If Company gives their contribution as PF ,Gratuity , Superannuation then adding these to gross becomes CTC ie. Cost to Company.

Hope you got your question answered!!!!

Rachna Sinha
Hi Satish,

CTC is actually the total Cost to Company and varies depending on individual company's philosohy regarding compensation positioning.
Some companies do calculate the benefits given to staff also under the term of CTC while certain companies keep those separate. It depends on company how they want to articulate it, but primarily CTC comprises of -

Annual Base Salary - In Indian context, , the term "Base salary" is generally construed as "Basic" salary, while in European context, there is only the Base salary and no other "cash allowances". You might like to keep this in mind while designing the structure

Cash Allowances (Both monthly +Annual) - Includes components like HRA,Conveyance,LTA,Spl Allowance,CCA etc. There are NO mandated heads which need to be necessary part of this.

Annual Guaranteed Cash - Is a summation of Annual Base salary + Cash Allowances as mentioned above

Annual Total Cash - Is the addition of Annual Guaranteed Cash + Variable Pay/Sales Incentive/Profit Sharings

Annual Total Remuneration - Annual Total Cash + Non cash benefits like Loans/Car/Petrol/maintenance/Driver/Club Membership/Housing/Insurance premium etc

CTC would be the sum of Annual Total Remuneration given above + retirals like Gratuity/PF/Superannuation costs added to the same
Dear Friend,

Kindly click on the following link, it will give you some required information,

Pls let me know was this information useful,,

If not let me try out more & give information,,,,

In CiteHR you will get A to Z information on HRů..


M.Peer Mohamed Sardhar
093831 93832
i am uploading a file used by me. hope this will help you
Attached FilesProvided by community member nandishsheregar. Register to join your network of peers.
File Type: xls ctc_184.xls (18.0 KB, 2066 views)
Hi Can any of you help me how to calculate Variable pay for Managers in MAnufacturing industry. THanks


Found This Useful? +Vote Up This Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network