Sample Salary Structure
Uploaded by
K Srinivasa RaoSample Salary Structure
Uploaded by
K Srinivasa RaoComponents Monthly
Basic 16,667
HRA 6,667
Special Allowance 18,333
Component 1 0
Component 2 0
Total Cost to Company 41,667
*The sheet is formula driven. You can change the formula in Annual componen
**Edit the components as per your requirement, if applicable.
Annual Details
200,000 40% of CTC
80,000 40% of Basic
220,000 Balancing amount
0 Add component, if applicable. e.g LTA
0 Add component, if applicable. e.g LTA
500,000
in Annual component fields to update as per your requirement
Enter Annual CTC 500000 INR Enter Annual CTC in the highlighted cell
Components Monthly
Basic 16,667
HRA 6,667
Special Allowance 14,583
Component 1 0
Component 2 0
Retirals
PF - Employer contribution 3,750
Total Cost to Company 41,667
*The sheet is formula driven. You can change the formula in Annual componen
**Edit the components as per your requirement, if applicable.
*** Edit PF formula as per your requirement. Assumption is the PF is included i
Annual Details Enter Annual
200,000 40% of CTC
80,000 40% of Basic
175,000 Balancing amount
0 Add component, if applicable. e.g LTA
0 Add component, if applicable. e.g LTA
45,000 (Basic+Special Allowance )*12%
500,000
in Annual component fields to update as per your requirement
s the PF is included in CTC
500000 INR Enter Annual CTC in the highlighted cell
