Asked me to prepare a salary break up for Rs 3,21,600 CTC per year - please share excel file

HR GRADUATE

Hi Friennds, My manager asked me to prepare a salary break up for Rs 3,21,600 ctc per year. The components are as follows:
Basic, HRA, Transport Allowance, Special Allowance, Gross Total, Employer's PF Contribution.
Its urgent please help me with the excel .
Thanks & Regards.
25th June 2019 From India, Banjara Hills

Add Reply → Start New →

GR Sharma

Hi,
Please find the below salary breakup as per given your details.
Component Monthly Yearly
Basic 10720 128640
HRA 5360 64320
Transpot All 1600 19200
Special All 7834 94008
Gross 25514 306168
PF Emp 1286 15432
Inhand 24228 290736
PF Empr 1286 15432
CTC 26800 321600
Regards
GovinD
9555046934
25th June 2019 From India, Delhi

HR GRADUATE

Mr. Govind, Thank you so much.
25th June 2019 From India, Banjara Hills

If You Are Knowledgeable About Any Fact, Resource or Experience Related to This Topic and Want to Be Part of Such Discussions in Future - Please Register and Log In to Cite Community.

Other Similar User Discussions On Cite.Co

Break up of salary for a take home amounting to rs.18000

Need a salary slip break up for rs 12lac annually - xls download

Salary break up for rs 20,000 / month basic, hra, pt, pf, tds

Related Files & Downloads Shared By Members

 Salary Break Up.xlsx

 New Comart Salary Break up-Calculator.z ip

 Salary Break up calculator.xls

Asked me to prepare a salary break up for Rs 3,21,600 CTC per year - please share excel file

Login Or Register

If You Are Knowledgeable About Any Fact, Resource or Experience Related to This Topic and Want to Be Part of Such Discussions in Future - Please Register and Log In to Cite Community.