ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Payroll Assumptions & Rates
3
4
5
Editable Inputs
6
Company Name
TealWave Solutions Inc.
Used on Dashboard header.
7
Pay PeriodMonthlyPayroll is processed once per month.
8
Federal Tax Rate12.0%Flat assumed federal withholding rate (demo data).
9
State Tax Rate4.0%Flat assumed state withholding rate (demo data).
10
Retirement (401k) Contribution Rate
5.0%Employee contribution, % of gross pay.
11
Health Insurance (Monthly Flat Fee)$150Flat deduction per employee per month.
12
CurrencyUSD ($)Display currency for this workbook.
13
14
Legend
15
Blue text / yellow fill = editable input cell
16
Black text = calculated formula (do not overwrite)
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