BuildHer Final Model - 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	BuildHer		Color Key
3	Title of Pathway	Jenga Wanawake kwa Ufundi (Empowering Women through Construction)			Requires User Input
4	Date of Analysis	12/12/2023			Automatically Calculated Based on Inputs
5	Country of Activity	Kenya			Skip Section
6	Intervention Type	Vocational Training
7	ROI	9
8
9	Inputs			Source // Reasoning
10	GitLab Foundation Inputs	GitLab Foundation Grant Amount	$250,000
11	GitLab Foundation Inputs	Year 1	$250,000
12	GitLab Foundation Inputs	Year 2 Discounted	$0
13
14	Adjustable Assumptions	GitLab Foundation overhead rate	23%	From current estimated financial data
15	Adjustable Assumptions	Discount rate	10%	Standard discount rate
16	Adjustable Assumptions	Number of years	30	Standard lifetime working years assumption - 30 years, assume impact starts at Year 1
17
18	Grantee Inputs (Depth)	Comparison (counterfactual) annual income after One Year	$600	Click on the counterfactual sheet link
19	Grantee Inputs (Depth)	Grantee Participant Annual Income (post) after One Year	$1,560	Click on the counterfactual sheet link
20
21	User Input	Does the Model Require a Customized Approach to Annual Income Increase or Reach Estimates?	Yes	Yes, the income gains fluctuate year-over-year so can not use a fixed annual income increase model
22
23	Grantee Inputs (Depth)	How does the income effect change over time?	No Change	If yes, assume that the income increase widens/narrows for program participants over time
24	Grantee Inputs (Depth)	What is the annual income change starting value?	$0.00	Increase in income after one year
25	Grantee Inputs (Depth)	What is the annual income change percentage?	0.00%	Annual percentage growth or decline
26	Grantee Inputs (Depth)	For how many additional years does this effect occur?	0.0	The income widens/narrows for x number of years because of y assumptions
27
28	Grantee Inputs (Scale)	Number of people impacted attributable to GitLab Foundation	400	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)
29	Grantee Inputs (Scale)	Does the number of people impacted change over time?	No	If yes, assume that the total number of people reached increases each year
30	Grantee Inputs (Scale)	What is the number of people impacted after one year?	0	Starting number of people reached
31	Grantee Inputs (Scale)	What is the annual growth rate of people impacted per year?	0%	Annual growth of total people reached (e.g. 10% growth)
32	Grantee Inputs (Scale)	For how many additional years does the growth rate apply?	0	Assume 3 years of attribution to grant funding if supporting pilot program
33
34
35	Conditional Section: Variable or Customized Income & Reach Calculations
36	Calculations for Changing Income or Reach Over Time
37			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
38			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
39		Income Increase Difference	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960	$960
40		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
41		Number of People Impacted	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400
42		PV of Aggregate Income Gain	$349,091	$317,355	$288,505	$262,277	$238,434	$216,758	$197,053	$179,139	$162,853	$148,049	$134,590	$122,354	$111,231	$101,119	$91,927	$83,570	$75,972	$69,066	$62,787	$57,079	$51,890	$47,173	$42,884	$38,986	$35,442	$32,220	$29,291	$26,628	$24,207	$22,006	$20,006	$18,187	$16,534	$15,031	$13,664	$12,422	$11,293	$10,266	$9,333	$8,484
43
44	Manual Income or Reach Calculations
45			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
46			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
47		Income Increase Difference	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0	$960.0
48		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
49		Number of People Impacted	38	100	175	250	325	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400
50		PV of Aggregate Income Gain	$32,727.3	$79,338.8	$126,220.9	$163,923.2	$193,727.5	$216,758.0	$197,052.7	$179,138.8	$162,853.5	$148,048.6	$134,589.7	$122,354.2	$111,231.1	$101,119.2	$91,926.5	$83,569.6	$75,972.4	$69,065.8	$62,787.1	$57,079.2	$51,890.1	$47,172.9	$42,884.4	$38,985.8	$35,441.7	$32,219.7	$29,290.6	$26,627.8	$24,207.1	$22,006.5	$0.0	$0.0	$0.0	$0.0	$0.0	$0.0	$0.0	$0.0	$0.0	$0.0
51		Undiscounted Aggregate Income Gain	$36,000.0	$96,000.0	$168,000.0	$240,000.0	$312,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$384,000.0	$0.0	$0.0	$0.0	$0.0	$0.0	$0.0	$0.0	$0.0	$0.0	$0.0
52
53	Outputs
54	GitLab Foundation Cost	Total Gitlab Foundation Grant Size Including Overhead Cost	$307,500	shows the total amount paid by the Foundation
55	Grantee Outputs (Depth)	Additional annual income gained due to grantee after one year	$960	shows the increase in annual income between the participant and counterfactual non-participant)
56	Grantee Outputs (Depth)	Percentage change in annual income due to grantee after one year	160%	demonstrates the annual income increase as a percentage to understand depth of income change
57
58	ROI Absolute Income Change	Aggregate Present Value Income Increase	$2,760,211	the present value increase in lifetime earnings for all participants combined
59	ROI Absolute Income Change	Undiscounted Aggregate Income Gain	$10,452,000
60	ROI Absolute Income Change	Net Present Value of Investment	$2,452,711	the present value increase in lifetime earnings for all participants combined subracted by the total amount paid by the Foundation
61	ROI Absolute Income Change	North Star ROI (Benefit/Cost Ratio)	9
62
63	ROI Absolute Income Change	Present Value Lifetime Income Gain per Person	$6,901	shows total increase in lifetime income per person reached
64	ROI Absolute Income Change	Counterfactual - Aggregate Present Value Lifetime Income	$1,725,132
65	ROI Absolute Income Change	% Increase in Present Value Lifetime Income Gain per Person	160.00%
66	Grantee Costs	Cost to Impact One Person (not including Foundation's Overhead Rate)	$625
67
68
69
70
71
72
73	Calculating the Counterfactual Aggregate Present Value Lifetime Income
74			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
75			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
76		Counterfactual Annual Income	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600	$600
77		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
78		Number of People Impacted	38	100	175	250	325	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400	400
79		PV of Aggregate Income Gain	$20,455	$49,587	$78,888	$102,452	$121,080	$135,474	$123,158	$111,962	$101,783	$92,530	$84,119	$76,471	$69,519	$63,200	$57,454	$52,231	$47,483	$43,166	$39,242	$35,674	$32,431	$29,483	$26,803	$24,366	$22,151	$20,137	$18,307	$16,642	$15,129	$13,754	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100