As SSC CGL Tier II has been complete and soon CPT schedules will out, today I am sharing previous year's CPT Sheet sheet based on memory.
| Name | Basic salary (Monthly) | DA | HRA | Medical allowance | Convience | Tax | Net salary |
|---|---|---|---|---|---|---|---|
| Ramesh | 14000 | ||||||
| Suresh | 19000 | ||||||
| Rahul | 25000 | ||||||
| Mahesh | 32000 |
- DA is 90% of the basic salary
- HRA is 35% of Basic salary + DA
- Medical allowance is 15% of Basic salary + DA
- Convience is Rs 5% of Basic salary
- Annnual income upto Rs 2,00,000 is tax free.
- Tax slabs : Upto 2 lakhs - Nil, 2 lakh to 3 lakh - 10% , More than 3 lakh - 20% + 10 % surcharge on gross tax
Make an excel sheet using follwoing steps :-
- Make an excel sheet
- Enter the given data
- Set font as Arial 12 px and margins 1 inches
- Adjust height, width and borders of the worksheet
- Calculate Net salary using excel formaule and print the worksheet
