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

Hi Friends,

My manager asked me to prepare a salary breakup 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.

It's urgent. Please help me with the Excel.

Thanks & Regards.

Hi,

Please find the below salary breakup as per the details given:

Component Monthly Yearly
Basic 10,720 128,640
HRA 5,360 64,320
Transport Allowance 1,600 19,200
Special Allowance 7,834 94,008
Gross 25,514 306,168
PF Employee 1,286 15,432
In-hand 24,228 290,736
PF Employer 1,286 15,432
CTC 26,800 321,600

Regards,
Govind
9555046934

Mr. Govind,

Thank you so much.