Wage Calculator_2Year.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC
1
2	Inputs			LEGEND
3	Starting Wage	15
4	Journeyworker Wage	30			In-Sheet Link
5	Hours a week	30
6	Weeks / Month	4			Input
7	Weeks / year	48
8	GI Bill	1233			Calculation
9	GI Bill Decrease	20%
10	Effective Tax Rate	19%			Result
11
12	Indices
13	Month	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24

14	GI Bill Term	0	0	0	0	0	1	1	1	1	1	1	2	2	2	2	2	2	3	3	3	3	3	3	4
15
16
17	Calculations																									Total		721403.9689
18	Monthly Wages	1,800	1,800	1,800	1,800	1,800	2,219	2,219	2,219	2,219	2,219	2,219	2,640	2,640	2,640	2,640	2,640	2,640	3,060	3,060	3,060	3,060	3,060	3,060	3,600	60,117.00
19	(Less Taxes)	(340)	(340)	(340)	(340)	(340)	(419)	(419)	(419)	(419)	(419)	(419)	(498)	(498)	(498)	(498)	(498)	(498)	(577)	(577)	(577)	(577)	(577)	(577)	(679)	(11,344)	Average
20	Equivalent Hourly Wage	15.00	15.00	15.00	15.00	15.00	18.50	18.50	18.50	18.50	18.50	18.50	22.00	22.00	22.00	22.00	22.00	22.00	25.50	25.50	25.50	25.50	25.50	25.50	30.00		21
21	Percentage of Journeyman Wage	50%	50%	50%	50%	50%	62%	62%	62%	62%	62%	62%	73%	73%	73%	73%	73%	73%	85%	85%	85%	85%	85%	85%	100%		70%
22	Non-GI Bill Apprentice Takehome	1,460	1,460	1,460	1,460	1,460	1,801	1,801	1,801	1,801	1,801	1,801	2,142	2,142	2,142	2,142	2,142	2,142	2,483	2,483	2,483	2,483	2,483	2,483	2,921	48,773
23	Monthly GI Bill	1,233	1,233	1,233	1,233	1,233	986	986	986	986	986	986	740	740	740	740	740	740	493	493	493	493	493	493	247	19,728
24	GI Bill Apprentice Takehome	2,693	2,693	2,693	2,693	2,693	2,787	2,787	2,787	2,787	2,787	2,787	2,882	2,882	2,882	2,882	2,882	2,882	2,976	2,976	2,976	2,976	2,976	2,976	3,167	68,501
25
26	Journeyman's Reference	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	3,600	86,400
27	(Less Taxes)	(679)	(679)	(679)	(679)	(679)	(679)	(679)	(679)	(679)	(679)	(679)	(679)	(679)	(679)	(679)	(679)	(679)	(679)	(679)	(679)	(679)	(679)	(679)	(679)	(16,304)
28	Journeyman's Takehome	2,921	2,921	2,921	2,921	2,921	2,921	2,921	2,921	2,921	2,921	2,921	2,921	2,921	2,921	2,921	2,921	2,921	2,921	2,921	2,921	2,921	2,921	2,921	2,921	70,096
29
30	Pre-Tax Savings for Employer	1,800	1,800	1,800	1,800	1,800	1,381	1,381	1,381	1,381	1,381	1,381	960	960	960	960	960	960	540	540	540	540	540	540	0	26,283
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