Carina - Final North Star ROI Model

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP
1
2	Grantee Name	Carina		Color Key
3	Title of Pathway	Facilitating Job Matches through Data Capture and Exchange			Requires User Input
4	Date of Analysis	4/9/2024			Automatically Calculated Based on Inputs
5	Country of Activity	United States of America			Skip Section
6	Intervention Type	Computer Programming Skills Training
7	ROI	107
8
9	Inputs			Source // Reasoning
10	GitLab Foundation Inputs	GitLab Foundation Grant Amount	$250,000
11	GitLab Foundation Inputs	Grant Years	1
12	GitLab Foundation Inputs	Year 1	$250,000
13	GitLab Foundation Inputs	Year 2 Discounted	$0
14	GitLab Foundation Inputs	Year 3 Discounted	$0
15
16	Adjustable Assumptions	GitLab Foundation overhead rate	13.8%	From current estimated financial data
17	Adjustable Assumptions	Discount rate	10%	Standard discount rate
18	Adjustable Assumptions	Number of years	30	Standard lifetime working years assumption - 30 years, assume impact starts at Year 1
19
20	Grantee Inputs (Depth)	Comparison (counterfactual) annual income after One Year	$6,560	Click on the counterfactual sheet link
21	Grantee Inputs (Depth)	Grantee Participant Annual Income (post) after One Year	$13,000	Click on the counterfactual sheet link
22
23	Grantee Inputs (Scale)	Number of people impacted attributable to GitLab Foundation	500	e.g., unrestricted grant which accounts for 2.3% of their budget, so 230 students reached out of 10,000 total students (*see additional notes)
24	User Input	Does the Model Require a Customized Approach to Annual Income Increase or Reach Estimates?	Yes	If Yes, this means the income gains fluctuate year-over-year, or the number of people impacted changes year-over-year, so the model can't use a fixed input model
25
26
27
28	Conditional Section: Customized Income & Reach Calculations
29
30	Manual Income or Reach Calculations
31			Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10	Year 11	Year 12	Year 13	Year 14	Year 15	Year 16	Year 17	Year 18	Year 19	Year 20	Year 21	Year 22	Year 23	Year 24	Year 25	Year 26	Year 27	Year 28	Year 29	Year 30	Year 31	Year 32	Year 33	Year 34	Year 35	Year 36	Year 37	Year 38	Year 39	Year 40
32			1	2	3	4	5	6	7	8	9	10	11	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
33		Income Increase Difference	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0	$6,440.0
34		Discount Factor	0.91	0.83	0.75	0.68	0.62	0.56	0.51	0.47	0.42	0.39	0.35	0.32	0.29	0.26	0.24	0.22	0.20	0.18	0.16	0.15	0.14	0.12	0.11	0.10	0.09	0.084	0.076	0.069	0.063	0.057	0.052	0.047	0.043	0.039	0.036	0.032	0.029	0.027	0.024	0.022
35		Number of People Impacted	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500
36		PV of Aggregate Income Gain	$2,927,272.7	$2,661,157.0	$2,419,233.7	$2,199,303.3	$1,999,366.7	$1,817,606.1	$1,652,369.1	$1,502,153.8	$1,365,594.3	$1,241,449.4	$1,128,590.4	$1,025,991.2	$932,719.3	$847,926.6	$770,842.4	$700,765.8	$637,059.8	$579,145.3	$526,495.7	$478,632.5	$435,120.4	$395,564.0	$359,603.7	$326,912.4	$297,193.1	$270,175.6	$245,614.1	$223,285.6	$202,986.9	$184,533.5	$0.0	$0.0	$0.0	$0.0	$0.0	$0.0	$0.0	$0.0	$0.0	$0.0
37		Undiscounted Aggregate Income Gain	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$3,220,000.0	$0.0	$0.0	$0.0	$0.0	$0.0	$0.0	$0.0	$0.0	$0.0	$0.0
38
39	Outputs
40	GitLab Foundation Cost	Total Gitlab Foundation Grant Size Including Overhead Cost	$284,500	shows the total amount paid by the Foundation
41	Grantee Outputs (Depth)	Additional annual income gained due to grantee after one year	$6,440	shows the increase in annual income between the participant and counterfactual non-participant)
42	Grantee Outputs (Depth)	Percentage change in annual income due to grantee after one year	98%	demonstrates the annual income increase as a percentage to understand depth of income change
43
44	ROI Absolute Income Change	Aggregate Present Value Income Increase	$30,354,665	the present value increase in lifetime earnings for all participants combined
45	ROI Absolute Income Change	Undiscounted Aggregate Income Increase	$96,600,000
46	ROI Absolute Income Change	Net Present Value of Investment	$30,070,165	the present value increase in lifetime earnings for all participants combined subracted by the total amount paid by the Foundation
47	ROI Absolute Income Change	North Star ROI (Benefit/Cost Ratio)	107
48
49	ROI Absolute Income Change	Present Value Lifetime Income Gain per Person	$60,709	shows total increase in lifetime income per person reached
50	ROI Absolute Income Change	Counterfactual - Aggregate Present Value Lifetime Income	$30,920,279
51	ROI Absolute Income Change	% Increase in Present Value Lifetime Income Gain per Person	98.17%
52	Grantee Costs	Cost to Impact One Person (not including Foundation's Overhead Rate)	$500
53
54
55
56
57	Calculating the Counterfactual Aggregate Present Value Lifetime Income
58			Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10	Year 11	Year 12	Year 13	Year 14	Year 15	Year 16	Year 17	Year 18	Year 19	Year 20	Year 21	Year 22	Year 23	Year 24	Year 25	Year 26	Year 27	Year 28	Year 29	Year 30	Year 31	Year 32	Year 33	Year 34	Year 35	Year 36	Year 37	Year 38	Year 39	Year 40
59			1	2	3	4	5	6	7	8	9	10	11	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
60		Counterfactual Annual Income	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560	$6,560
61		Discount Factor	0.91	0.83	0.75	0.68	0.62	0.56	0.51	0.47	0.42	0.39	0.35	0.32	0.29	0.26	0.24	0.22	0.20	0.18	0.16	0.15	0.14	0.12	0.11	0.10	0.09	0.08	0.08	0.07	0.06	0.06	0.05	0.05	0.04	0.04	0.04	0.03	0.03	0.03	0.02	0.02
62		Number of People Impacted	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500	500
63		PV of Aggregate Income Gain	$2,981,818	$2,710,744	$2,464,313	$2,240,284	$2,036,622	$1,851,474	$1,683,159	$1,530,144	$1,391,040	$1,264,582	$1,149,620	$1,045,109	$950,099	$863,727	$785,206	$713,824	$648,931	$589,937	$536,306	$487,551	$443,228	$402,935	$366,304	$333,004	$302,731	$275,210	$250,191	$227,446	$206,769	$187,972	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
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