CTC vs NET LABOUR LAW ADVISOR.xlsx

	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
5	CTC vs NET
6	Prepared by : Labour Law Advisor and Mr. Parth Mehta

7	☑️Payroll, Excel & Labour Law Courses for career growth: https://lpt.institute/courses/
8	www.youtube.com/LabourLaw Advisor
9	Name	ANNUAL CTC	CASH IN HAND	Gross Salary	70.00%	30%	Employee Share			Employer Share					MONTHLY CTC	MONTHLY CASH IN HAND	Difference (%)
10		ANNUAL CTC	CASH IN HAND		Basic	HRA	PF	ESI	PT	PF	ESI	Bonus	Gratuity	LWW
11		EXPECTATION	REALITY		Basic	HRA	12%	0.75%	80/150/200	13.00%	3.25%	8.33%	4.82%	4.82%
12	A	118596	84288	7820	5474	2346	657	59	80	712	254	456	264	377	9883	7024	71%
13	B	180000	126084	11730	8211	3519	985	88	150	1067	381	684	396	565	15000	10507	70%
14	C	237144	170148	15827	11079	4748	1329	119	200	1440	514	684	534	763	19762	14179	72%
15	D	296424	214824	19925	13948	5978	1674	149	200	1813	648	684	672	960	24702	17902	72%
16	E	360000	278916	25243	17670	7573	1800	0	200	2004	0	684	852	1217	30000	23243	77%
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115