Salary Breakup Calculator Excel 663bw

NAME Yearly & Monthly Break Up of Gross Salary Basic 30% HRA 20% City Compensatory All. 30% Conveyance Rs.800 per month Special Allowance Balance

Yearly Gross Salary Basic HRA City Compensatory All Employers Contribution 12% of basic or Rs. 780/- whichever is less Conveyance Yearly Bonus Special Allowance Less : Deduction P.F. ( Employees Contribution 12% of Basic or Rs 780/- whicever is less P.F. ( Employers Contribution 12% of Basic or Rs 780/- whicever is less Professional Tax Net Salary Payable Add Performance Bonus

Grand Totals 800,000 240,000 160,000 240,000 9,360 9,600 29,988 111,052

800,000

9,360 9,360 1,800

20,520 779,480 0 779,480

Enter Values only in Yellow Cells

715649 750

Monthly 66,667 20,000 13,333 20,000 780 800 2,499 9,254

66,667

780 780 150

1,710 64,957