Profit Share Template.xlsx

	B	C	D	E	F	G	H	I	J	K
1
2	PROFIT SHARE TEMPLATE
3		Hours	Total Hours	% of Total	Bonus Pool	%	Max Per Yr	QTRLY	50% Per QTR	Year End
4		Hours	Total Hours	% of Total	Bonus Pool	%	Max Per Yr	QTRLY	50% Per QTR	Year End
5	Employee 1	38	98.5	38.58	$6,000	38.58	$2,315	$578.70	$289.35	$1,157.40
6	Employee 1	38	98.5	38.58	$6,000	38.58	$2,315	$578.70	$289.35	$1,157.40
7	Employee 2			#DIV/0!		#DIV/0!	$0	$0.00	$0.00	$0.00
8	Employee 2			#DIV/0!		#DIV/0!	$0	$0.00	$0.00	$0.00
9	Employee 3			#DIV/0!		#DIV/0!	$0	$0.00	$0.00	$0.00
10	Employee 3			#DIV/0!		#DIV/0!	$0	$0.00	$0.00	$0.00
11	NOTE: Please fill out only the REQUIRED FIELD.
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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