Optimizely Parental Leave Financial Model
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDE
1
Optimizely - Modeling the Cost of Parental Leave
2
To edit, make a copy ("File->Make a copy...") and then update YELLOW fields in model for cost estimates
3
DISCLAIMER: Should you choose to use this model to advocate for increased parental leave policy at your company or organization, be sure to work in concert with your financial and legal teams to ensure the financial implications are accurate for your business.
4
Input your company's data in the YELLOW cells > scroll to bottom for est. cost
5
6
Headcount# Employees
7
# US employees TODAY400
// exclude non-US countries
8
# FUTURE employees600
// for scenario analysis
9
10
CurrentCost (USD)
11
Annual emp. cost$100,000.00
12
Weekly emp. cost$1,923.08
13
14
Parental Leave Plan# Weeks
15
Maternity17
16
Paternity17
17
18
# of your company's employees that self-identify genderFemaleMaleTotal
19
<20 years000
20
20-24 years363672
21
25-29 years7272144
22
30-44 years7272144
23
Total180180360
24
25
Annual cost of proposed parental leave program
26
27
Est. cost of proposed parental leave
28
...per mother$32,692.31
// across mothers only; based on avg annual cost per employee per week
29
...per father$32,692.31
// across fathers only; based on avg annual cost per employee per week
30
...per US Employee$1,634.62
// across all US employees
31
32
# of US EmployeesEst. total cost
33
Today (400)$653,846.15
34
Future state (600)$980,769.23
Loading...
 
 
 
Form Responses 1
Parental Leave Model
Assumptions & number crunching