ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Park Slope Parents Nanny Compensation SpreadsheetInstructions: Please make a copy of this spreadsheet in order to use it. (We find that if we give access folks can mess it up!)Input rate, hours, spending cash and metrocard expenses into the orange boxes.
3
4
Disclaimer: this spreadsheet is for approximation purposes only.Enter data or delete data in highlighted cellsClick the red triangles/comments for extra helpTo find more specific rates from the 2025 PSP Compensation Survey, go here. Those data include rates by hours work as well as number of children. You may decide to use 50th percentile rather than the average, the latter of which is more influenced by outliers. The 2 child rate is for one family, not a nanny share.
5
6
Hourly Rate(Ave--1 child ave = $21.86; Ave 2 children = $23.90) up to 40 hours$26.57
7
Overtime Rate$39.86Overtime
8
Hours worked per week (Pay over 40 is 1.5 timesx)40
9
Weekly pay before paying on the books$1,062.80
10
Approximate cost with on the books taxes/fees included (approx. 15% on top of gross)$1,222.22What is Guaranteed Pay?
11
12
OPTIONAL
13
Spending Cash/week$30Pay Standards
14
Metrocard (30 day unlimited is $132/month)$132Metrocard tip
15
Total per year (Spending cash x 50 weeks; Metrocard x 12 months)$3,084
16
YEARLY TOTALS
17
Yearly Pay$63,555.44
18
Yearly Spending Cash (50 of 52 wks)$1,500.00
19
Yearly Bonus (typically paid in December)$1,222.22
20
Yearly Metrocard Stipend$3,084
21
22
TOTAL YEARLY CHILDCARE EXPENDITURE$69,361.66
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
101