Kibo School 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	Kibo School		Color Key
3	Title of Pathway	Scaling Automation Assitant Program assuming reaching 300 new students per year by 2025 for 5 additional years			Requires User Input
4	Date of Analysis	8/14/2023			Automatically Calculated Based on Inputs
5	Country of Activity	Nigeria			Skip Section
6	Intervention Type	Computer Programming Skills Training
7
8	Inputs			Source // Reasoning
9	GitLab Foundation Inputs	GitLab Foundation Grant Amount	$180,000
10
11	Adjustable Assumptions	GitLab Foundation overhead rate	23%	From current estimated financial data
12	Adjustable Assumptions	Discount rate	10%	Standard discount rate
13	Adjustable Assumptions	Number of years	30	Standard lifetime working years assumption - 30 years, assume impact starts at Year 1
14
15	Grantee Inputs (Depth)	Comparison (counterfactual) annual income	$9,111	Click on the counterfactual sheet link
16	Grantee Inputs (Depth)	Grantee Participant Annual Income (post)	$12,648	Click on the counterfactual sheet link
17
18	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
19
20	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
21	Grantee Inputs (Depth)	What is the annual income change starting value?	$0.00	Increase in income after one year
22	Grantee Inputs (Depth)	What is the annual income change percentage?	0.00%	Annual percentage growth or decline
23	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
24
25	Grantee Inputs (Scale)	Number of people impacted attributable to GitLab Foundation after one year	50	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)
26	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
27	Grantee Inputs (Scale)	What is the number of people impacted after one year?	0	Starting number of people reached
28	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)
29	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
30
31
32	Conditional Section: Variable or Customized Income & Reach Calculations
33	Calculations for Changing Income or Reach Over Time
34			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
35			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
36		Income Increase Difference	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537	$3,537
37		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
38		Number of People Impacted	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50	50
39		PV of Aggregate Income Gain	$160,763	$146,148	$132,862	$120,784	$109,803	$99,821	$90,746	$82,497	$74,997	$68,179	$61,981	$56,346	$51,224	$46,567	$42,334	$38,485	$34,987	$31,806	$28,915	$26,286	$23,896	$21,724	$19,749	$17,954	$16,322	$14,838	$13,489	$12,263	$11,148	$10,134	$9,213	$8,376	$7,614	$6,922	$6,293	$5,721	$5,201	$4,728	$4,298	$3,907
40
41	Manual Income or Reach Calculations
42			Year 1 (2024)	Year 2 (2025)	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
43			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
44		Income Increase Difference	$2,008	$2,728	$2,959	$3,126	$3,221	$3,539	$3,570	$3,600	$3,600	$3,600	$3,600	$3,600	$3,600	$3,600	$3,600	$3,600	$3,600	$3,600	$3,600	$3,600	$3,600	$3,600	$3,600	$3,600	$3,600	$3,600	$3,600	$3,600	$3,600	$3,600
45		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
46		Number of People Impacted	50	350	650	950	1,250	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550
47		PV of Aggregate Income Gain	$91,265	$789,045	$1,444,967	$2,028,267	$2,499,755	$3,096,513	$2,839,217	$2,603,111	$2,366,465	$2,151,332	$1,955,756	$1,777,960	$1,616,327	$1,469,388	$1,335,808	$1,214,371	$1,103,973	$1,003,612	$912,375	$829,431	$754,029	$685,481	$623,164	$566,513	$515,012	$468,192	$425,629	$386,936	$351,760	$319,782	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
48		Undiscounted Aggregate Income Gain	$100,392	$954,744	$1,923,252	$2,969,586	$4,025,880	$5,485,661	$5,532,830	$5,580,000	$5,580,000	$5,580,000	$5,580,000	$5,580,000	$5,580,000	$5,580,000	$5,580,000	$5,580,000	$5,580,000	$5,580,000	$5,580,000	$5,580,000	$5,580,000	$5,580,000	$5,580,000	$5,580,000	$5,580,000	$5,580,000	$5,580,000	$5,580,000	$5,580,000	$5,580,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
49
50	Outputs
51	GitLab Foundation Cost	Total Gitlab Foundation Grant Size Including Overhead Cost	$221,400	shows the total amount paid by the Foundation
52	Grantee Outputs (Depth)	Additional annual income gained due to grantee after one year	$3,537	shows the increase in annual income between the participant and counterfactual non-participant)
53	Grantee Outputs (Depth)	Percentage change in annual income due to grantee after one year	39%	demonstrates the annual income increase as a percentage to understand depth of income change
54
55	ROI Absolute Income Change	Aggregate Present Value Income Increase	$38,225,434	the present value increase in lifetime earnings for all participants combined
56	ROI Absolute Income Growth	Undiscounted Aggregate Income Gain	$149,332,345
57	ROI Absolute Income Change	Net Present Value of Investment	$38,004,034	the present value increase in lifetime earnings for all participants combined subracted by the total amount paid by the Foundation
58	ROI Absolute Income Change	North Star ROI (Benefit/Cost Ratio)	173
59
60	ROI Absolute Income Change	Present Value Lifetime Income Gain per Person	$24,662	shows total increase in lifetime income per person reached
61	ROI Absolute Income Change	Counterfactual - Aggregate Present Value Lifetime Income	$88,587,290
62	ROI Absolute Income Change	% Increase in Present Value Lifetime Income Gain per Person	43.15%
63	Grantee Costs	Cost to Impact One Person (not including Foundation's Overhead Rate) at year 1	$3,600	$143
64	Grantee Costs	Cost to Impact One Person (not including Foundation's Overhead Rate) at year 30	$116
65	Grantee Scale	Change in people impacted from Year 1 to Year 30	31
66
67
68
69
70	Calculating the Counterfactual Aggregate Present Value Lifetime Income
71			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
72			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
73		Counterfactual Annual Income	$392	$392	$391	$2,814	$4,267	$6,205	$8,142	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080	$10,080
74		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
75		Number of People Impacted	50	350	650	950	1,250	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550	1,550
76		PV of Aggregate Income Gain	$17,825	$113,435	$190,747	$1,825,978	$3,312,069	$5,428,850	$6,476,450	$7,288,711	$6,626,101	$6,023,728	$5,476,117	$4,978,288	$4,525,716	$4,114,288	$3,740,261	$3,400,238	$3,091,125	$2,810,114	$2,554,649	$2,322,408	$2,111,280	$1,919,345	$1,744,860	$1,586,236	$1,442,033	$1,310,939	$1,191,763	$1,083,420	$984,928	$895,389	$813,990	$739,991	$672,719	$611,563	$555,966	$505,424	$459,476	$417,706	$379,732	$345,211
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100