Assignment – 1
🔹 Objective:
Prepare a salary breakup that results in a Net Pay of ₹50,000.
🔹 Instructions:
- Use the provided Excel Salary Breakup Calculator.
- Create a complete salary structure based on the tool.
- Adjust the Gross Salary (increase or decrease as needed) until the Net Pay equals ₹50,000.
💡 Tip: Keep modifying the Gross Salary value until the Net Pay in the calculator matches exactly ₹50,000.
Excel Calculator
Sheet1
| A | B | |
|---|---|---|
| 1 | State | |
| 2 | Gross (Adjust) -> | |
| 3 | Earnings | |
| 4 | Basic + DA | |
| 5 | HRA | |
| 6 | Others | |
| 7 | Deductions | |
| 8 | ESI Employee | |
| 9 | PF Employee | |
| 10 | PT | |
| 11 | Net Pay | |
| 12 | ESI Employer | |
| 13 | PF Employer | |
| 14 | Bonus | |
| 15 | Gratuity | |
| 16 | CTC | |