Lumni ROI Model

	B	C	E	F	H	I
1
2	Date of Analysis	3/26/2025			Color Key
3	GTLF Analyst Name	Spencer MacColl				Requires User Input
4	Grant Information		Modeling Results			Automatically Updated Based on Inputs
5	Grantee Name	Lumni	North Star ROI	84		Skip Section
6	Grantee Website	https://www.lumni.net/	Relative ROI: Cost-Per-DIL	$790
7	Grant Title	Opportunities Without Borders: Degree Accreditation Pathway
8	Country of Activity	Colombia	Number of people impacted	160
9	Strategic Alignment	Colombia
10	Grant Type	Scaling	Counterfactual Income	$3,598
11	Intervention Type	Workforce Skills and Training	Post-Intervention Income	$8,265
12	Grant Start Date		Annual Income Change Due to Grant ($)	$4,667
13	Grant Duration (Years)	1	Annual Income Change Due to Grant (%)	129.68%
14	Grant Amount	$125,000.00	Total Lifetime Earnings Increase (NPV)	$11,380,004
15	Total Investment (including overhead)	$137,125	PV of aggregate lifetime income gain	$11,517,129
16			Undiscounted of aggregate lifetime income gain (simplified)	$18,745,909
17			PV of lifetime income gain per person	$115,704
18			Undiscounted lifetime income gain per person (simplified)	$22,351,958
19
20
21	ROI Summary		Living Wage Analysis
22	A $250,000 investment to Lumni (Fundación Zigma) will enable them to place 319 migrants into higher paying formal employment jobs over the next 20 years. While Lumni will initial work with 150 migrants, due to a 72% job placement percentage, the first year will have 108 migrants placed into formal work. Due to the repayment and recycle payment model, Lumni will be able to provide funding to a total of 319 migrants over 20 years. Migrant workers start with an estimated counterfactual income of $3,598 per year (less than minimum wage), but after completing the program, their incomes will be at least twice minimum wage, $8,265 USD). This is an annual increase of $4,667 in income, resulting in an aggregate income increase of $23 million in present value dollars. This translates to a North Star ROI of 84x per dollar and a cost per DIL of $782, which meets our cost effective threshold.		Living Wage Threshold	$6,776
23			Percentage earning below living wage	100%
24			Percentage earning above living wage after intervention	73%
25			Percentage earning above living wage due to intervention	73%
26
27
28			Evidence Maturity Score Summary
29			Evidence Maturity Score - Grantee Applicant	2.67
30			Evidence Maturity Score - by GTLF Staff	3.33
31			Evidence Maturity Summary	moderate evidence risk
32			Write Evidence Risk Score Summary Here
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
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