ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABB
1
2
Grantee NameRelative ROI ModelColor Key
3
Title of PathwayRequires User Input
4
Date of Analysis9/9/2023Automatically Calculated Based on Inputs
5
Country of ActivityKenyaSkip Section
6
Intervention TypeVocational Training
7
DIL - Cost to Double Lifetime Earnings$3,580
8
Relative Income Gain ROI per Dollar0.84
9
10
InputsSource // Reasoning
11
GitLab Foundation InputsGitLab Foundation Grant Amount$553
https://rethinkpriorities.org/publications/livelihood-interventions
12
GitLab Foundation InputsHow long is the grant term (years)?1
McKenzie and Puerto (2021) partnered with the ILO to test the effectiveness of the Gender and Enterprise Together (GET Ahead) business training program on women’s business outcomes.
13
GitLab Foundation InputsYear 1$553
14
GitLab Foundation InputsYear 2 (Discounted)0
15
3500baseline
16
Adjustable AssumptionsGitLab Foundation overhead rate23%From current estimated financial data665additional profit
17
Adjustable AssumptionsDiscount rate10%Standard discount rate0.19% change
18
Adjustable AssumptionsNumber of years30
Standard lifetime working years assumption - 30 years, assume impact starts at Year 1
19
20
Grantee Inputs (Depth)Comparison (counterfactual) annual income$3,500Click on the counterfactual sheet link
21
Grantee Inputs (Depth)Grantee Participant Annual Income (post-program)$4,165Click on the counterfactual sheet link
22
23
Grantee Inputs (Scale)Number of people impacted attributable to GitLab Foundation1
e.g., unrestricted grant which accounts for 2.3% of their budget, so 230 students reached out of 10,000 total students
24
25
26
User InputDoes the Model Require a Customized Approach to Annual Income Increase or Reach Estimates?No
If yes, the income gains may fluctuate year-over-year so can not use a fixed annual income increase model, or the program will scale up to reach more people and need to customize the people impacted numbers
27
28
29
30
Optional Section: Customized Income & Reach Calculations
31
32
Customized Income or Reach Calculations
33
Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11Year 12Year 13Year 14Year 15Year 16Year 17Year 18Year 19Year 20Year 21Year 22Year 23Year 24Year 25Year 26Year 27Year 28Year 29Year 30Year 31Year 32Year 33Year 34Year 35Year 36Year 37Year 38Year 39Year 40
34
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950
35
Income Increase Difference19%40%30%20%10%10%10%10%10%10%10%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%5%
36
Lifetime Relative Income Points19.0040.0030.0020.0010.0010.0010.0010.0010.0010.0010.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.005.00
37
Discount Factor0.910.830.750.680.620.560.510.470.420.390.350.320.290.260.240.220.200.180.160.150.140.120.110.100.090.0840.0760.0690.0630.0570.0520.0470.0430.0390.0360.0320.0290.0270.0240.0220.0200.0180.0170.0150.0140.0120.0110.0100.0090.009
38
Number of People Impacted11111111111111111111111111111111111111111111111111
39
PV of Aggregate Income Gain17.333.122.513.76.25.65.14.74.23.93.51.61.41.31.21.11.00.90.80.70.70.60.60.50.50.40.40.30.30.30.30.20.20.20.20.20.10.10.10.10.10.10.10.10.10.10.10.10.00.0
40
41
42
Outputs
43
GitLab Foundation CostTotal Gitlab Foundation Grant Size Including Overhead Cost$680
shows the total amount paid by the Foundation
44
Grantee Outputs (Depth)Additional annual income gained due to grantee after one year$665
shows the increase in annual income between the participant and counterfactual non-participant)
45
Grantee Outputs (Depth)Percentage change in annual income due to grantee after one year19%
demonstrates the annual income increase as a percentage to understand depth of income change
46
47
ROI Relative Income ChangeTotal Present Value Lifetime Relative Income Change Points570.0
the present value percentage point increase in lifetime earnings for all participants combined
48
ROI - Relative Income Change RatiosRelative Income Points per Dollar Spent (1 point = increase income 1% for 1 year for 1 person)0.84
increasing income xx% for 1 year per dollar spent
49
ROI - Relative Income Change RatiosCost to Increase Income 1% for 1 year for 1 person$1.19cost to increase income 1% for 1 year
50
ROI - Relative Income Change RatiosCost to Increase Lifetime Income 100% (DIL - Double Income for Lifetime)$3,579.9
cost to double lifetime income for 1 person
51
52
Grantee CostsCost to Impact One Person (not including Foundation's Overhead Rate)$553
53
Grantee CostsCost to Impact One Person (including Foundation's Overhead Rate)$680
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