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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||||||||||||||||||||||||
2 | |||||||||||||||||||||||||||||||||
3 | Organization: | Upwardly Global | |||||||||||||||||||||||||||||||
4 | Date of Application: | February 2023 | |||||||||||||||||||||||||||||||
5 | Investment details | Overview of intervention | This program will offer online, self-paced training to build critical competencies for recent immigrants, refugees and asylees navigating the U.S. labor market to secure skill-aligned, professional employment. This grant will also expand a technology platform that will provide this service to large scale resettlement and immigrant support organizations, greatly increasing training access. | ||||||||||||||||||||||||||||||
6 | Organization | Upwardly Global | |||||||||||||||||||||||||||||||
7 | Project title | Refugee & Immigrant Training Platform Expansion | |||||||||||||||||||||||||||||||
8 | Sector | Various | |||||||||||||||||||||||||||||||
9 | Geography | United States | Upwardly Global if Given $10 million | ||||||||||||||||||||||||||||||
10 | $10,000,000 | ||||||||||||||||||||||||||||||||
11 | Headline numbers | 38,149 | people reached | ||||||||||||||||||||||||||||||
12 | Total GitLab Foundation investment | Total GTLF investment + overhead | North Star impact | PV of total NS earnings (less funding) | PV of total add. NS earnings | PV of NS increase PP | ROI (w/ overhead) | IRR (WO/ overhead) | Relative income gain in first year | People | Cost per person | $2,907,022,762 | aggregate lifetime earning improvements | ||||||||||||||||||||
13 | Projected impact | 750,000 | 923,250 | 291 | 267,674,967 | 268,390,876 | 214,537 | 29070% | 5322% | 324.9% | 3522 | $262 | $76,202 | $2,907,022,762 | aggregate lifetime earning improvements | ||||||||||||||||||
14 | $200,189 | ||||||||||||||||||||||||||||||||
15 | North Star financial projection | USD | Notes: | ||||||||||||||||||||||||||||||
16 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | 2037 | 2038 | 2039 | 2040 | 2041 | 2042 | 2043 | 2044 | 2045 | 2046 | 2047 | 2048 | 2049 | 2050 | 2051 | 2052 | |||
17 | |||||||||||||||||||||||||||||||||
18 | GitLab Foundation funding | 375,000 | 375,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||
19 | GitLab Foundation upfront funding | 375,000 | 375,000 | ||||||||||||||||||||||||||||||
20 | GitLab Foundation ongoing funding | ||||||||||||||||||||||||||||||||
21 | |||||||||||||||||||||||||||||||||
22 | Baseline annual earning per person | 10,000 | 10,200 | 10,404 | 10,612 | 10,824 | 11,041 | 11,262 | 11,487 | 11,717 | 11,951 | 12,190 | 12,434 | 12,682 | 12,936 | 13,195 | 13,459 | 13,728 | 14,002 | 14,282 | 14,568 | 14,859 | 15,157 | 15,460 | 15,769 | 16,084 | 16,406 | 16,734 | 17,069 | 17,410 | 17,758 | ||
23 | |||||||||||||||||||||||||||||||||
24 | Total increase in annual earning (all people) | - | 22,335,419 | 23,727,244 | 24,672,360 | 25,617,476 | 26,562,592 | 27,093,844 | 27,635,721 | 28,188,435 | 28,752,204 | 29,327,248 | 29,913,793 | 30,512,069 | 31,122,310 | 31,744,757 | 32,379,652 | 33,027,245 | 33,687,790 | 34,361,545 | 35,048,776 | 35,749,752 | 36,464,747 | 37,194,042 | 37,937,923 | 38,696,681 | 39,470,615 | 40,260,027 | 41,065,227 | 41,886,532 | 42,724,263 | ||
25 | Additional annual earning per person | - | 32,486 | 27,888 | 24,329 | 21,758 | 19,813 | 20,209 | 20,613 | 21,025 | 21,446 | 21,875 | 22,312 | 22,759 | 23,214 | 23,678 | 24,152 | 24,635 | 25,127 | 25,630 | 26,142 | 26,665 | 27,199 | 27,743 | 28,297 | 28,863 | 29,441 | 30,029 | 30,630 | 31,243 | 31,867 | ||
26 | Total people impacted | 284 | 688 | 851 | 1,014 | 1,177 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | ||
27 | |||||||||||||||||||||||||||||||||
28 | Total increase in annual earning (all people) less funding | (375,000) | 21,960,419 | 23,727,244 | 24,672,360 | 25,617,476 | 26,562,592 | 27,093,844 | 27,635,721 | 28,188,435 | 28,752,204 | 29,327,248 | 29,913,793 | 30,512,069 | 31,122,310 | 31,744,757 | 32,379,652 | 33,027,245 | 33,687,790 | 34,361,545 | 35,048,776 | 35,749,752 | 36,464,747 | 37,194,042 | 37,937,923 | 38,696,681 | 39,470,615 | 40,260,027 | 41,065,227 | 41,886,532 | 42,724,263 | ||
29 | |||||||||||||||||||||||||||||||||
30 | Discount factor | 1.00 | 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 | ||
31 | Present Value of all income without intervention | 2,836,067 | 6,375,286 | 7,315,646 | 8,085,506 | 8,704,691 | 9,191,047 | 8,522,608 | 7,902,782 | 7,328,034 | 6,795,086 | 6,300,898 | 5,842,651 | 5,417,731 | 5,023,714 | 4,658,353 | 4,319,564 | 4,005,413 | 3,714,111 | 3,443,994 | 3,193,521 | 2,961,265 | 2,745,900 | 2,546,199 | 2,361,021 | 2,189,310 | 2,030,087 | 1,882,445 | 1,745,540 | 1,618,591 | 1,500,876 | ||
32 | Present Value of additional income with intervention | - | 20,304,927 | 19,609,293 | 18,536,709 | 17,497,081 | 16,493,280 | 15,293,769 | 14,181,495 | 13,150,113 | 12,193,741 | 11,306,924 | 10,484,602 | 9,722,085 | 9,015,025 | 8,359,387 | 7,751,431 | 7,187,691 | 6,664,950 | 6,180,226 | 5,730,755 | 5,313,973 | 4,927,502 | 4,569,138 | 4,236,837 | 3,928,704 | 3,642,980 | 3,378,036 | 3,132,360 | 2,904,552 | 2,693,312 | ||
33 | Present Value of additional income with intervention less funding | (375,000) | 19,964,018 | 19,609,293 | 18,536,709 | 17,497,081 | 16,493,280 | 15,293,769 | 14,181,495 | 13,150,113 | 12,193,741 | 11,306,924 | 10,484,602 | 9,722,085 | 9,015,025 | 8,359,387 | 7,751,431 | 7,187,691 | 6,664,950 | 6,180,226 | 5,730,755 | 5,313,973 | 4,927,502 | 4,569,138 | 4,236,837 | 3,928,704 | 3,642,980 | 3,378,036 | 3,132,360 | 2,904,552 | 2,693,312 | ||
34 | 19,589,018 | 39,198,310 | 57,735,019 | 75,232,100 | 91,725,380 | 107,019,149 | 121,200,643 | 134,350,756 | 146,544,498 | 157,851,421 | 168,336,023 | 178,058,109 | 187,073,134 | 195,432,520 | 203,183,951 | 210,371,642 | 217,036,592 | 223,216,818 | 228,947,573 | 234,261,545 | 239,189,047 | 243,758,186 | 247,995,023 | 251,923,727 | 255,566,706 | 258,944,742 | 262,077,103 | 264,981,655 | 267,674,967 | ||||
35 | Investment assumptions | Notes | 14.64% | 21.57% | 28.11% | 34.27% | 39.98% | 45.28% | 50.19% | 54.75% | 58.97% | 62.89% | 66.52% | 69.89% | 73.01% | 75.91% | 78.59% | 81.08% | 83.39% | 85.53% | 87.52% | 89.36% | 91.06% | 92.65% | 94.12% | 95.48% | 96.74% | 97.91% | 98.99% | 100.00% | |||
36 | Growth rate | 2.0% | US Average Inflation Rate | ||||||||||||||||||||||||||||||
37 | Discount rate | 10% | Sourced from the GitLab Foundation handbook | ||||||||||||||||||||||||||||||
38 | |||||||||||||||||||||||||||||||||
39 | Analysis | Notes: | |||||||||||||||||||||||||||||||
40 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | 2037 | 2038 | 2039 | 2040 | 2041 | 2042 | 2043 | 2044 | 2045 | 2046 | 2047 | 2048 | 2049 | 2050 | 2051 | 2052 | |||
41 | Projected impact | ||||||||||||||||||||||||||||||||
42 | Additional annual earning per person completing the initiative | - | 32,486 | 27,888 | 24,329 | 21,758 | 19,813 | 20,209 | 20,613 | 21,025 | 21,446 | 21,875 | 22,312 | 22,759 | 23,214 | 23,678 | 24,152 | 24,635 | 25,127 | 25,630 | 26,142 | 26,665 | 27,199 | 27,743 | 28,297 | 28,863 | 29,441 | 30,029 | 30,630 | 31,243 | 31,867 | ||
43 | |||||||||||||||||||||||||||||||||
44 | |||||||||||||||||||||||||||||||||
45 | Total NET people impacted (Direct Service + Jobversity expansion) | 284 | 688 | 851 | 1,014 | 1,177 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | 1,341 | ||
46 | Total Cumulative NET people impacted (Direct Service) | 120 | 241 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||
47 | People enrolled in the initiative (Attributed to GitLab Foundation) | 367 | 367 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||
48 | Less - people dropping out of the initiative | (85) | (85) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||
49 | Less - people unable to find placement (job) | (161) | (161) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||
50 | Jobversity Estimated Impacts Per Year (Total, less falloff and placement) | 163 | 163 | 163 | 163 | 163 | 163 | ||||||||||||||||||||||||||
51 | Less - people no longer benefiting from the intervention (retention rate) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||
52 | Direct Service % | 52.5% | 42.4% | 35.6% | 30.7% | 26.9% | |||||||||||||||||||||||||||
53 | |||||||||||||||||||||||||||||||||
54 | ASSUMPTIONS | NOTES | Sensitivity Testing | 5 year totals | 980 | Jobversity | |||||||||||||||||||||||||||
55 | Full budget number (All funders, total program budget) | 4,812,000 | Estimated based on cost per student | North Star impact | Attributed | 361 | Direct | ||||||||||||||||||||||||||
56 | Attribution to GitLab Foundation | 16% | 291 | 1,341 | Total | Actual Results 2024 | Actual Results 2025 | TOTAL | |||||||||||||||||||||||||
57 | Number of direct service students during grant period | 4711 | This does not include Jobversity | Job Seekers Enrolled | 2577 | 2134 | 4711 | ||||||||||||||||||||||||||
58 | Jobversity Indirectly served students during grant period | 3986 | Job Seekers Completed | 2078 | 80.6% | 1537 | 72.0% | 3615 | 77% | ||||||||||||||||||||||||
59 | Number of students attributed to GitLab Foundation | 734 | Completed at least one reskilling | 1262 | 49.0% | 1011 | 47.4% | 2273 | 48% | ||||||||||||||||||||||||
60 | Graduation rate: | 77% | Applicant provided data | Placed into Jobs | 1140 | 44% | 872 | 41% | 2012 | 43% | |||||||||||||||||||||||
61 | Placement rate: | 43% | Applicant provided data | job placement numbers | 912 | Avg Salary | 65084 | 68406 | $66,745.0 | ||||||||||||||||||||||||
62 | Program Growth rate | 5% | Estimation | job placement goal | 1000 | $67k + | 42% | 44% | |||||||||||||||||||||||||
63 | Prior cohort % unemployed | N/A | Applicant provided data | implied placement rate | 0.456 | Cost per job seeker | $7,835 | $5,887 | 75.1% | ||||||||||||||||||||||||
64 | Median Pre-program income (actual shared by applicant) | $10,000 | WeGlow Platform Users | 1610 | 2376 | 3986 | |||||||||||||||||||||||||||
65 | Average annual salary | $66,745 | |||||||||||||||||||||||||||||||
66 | Inflation | 3.80% | Avg 30 year inflation rate | ||||||||||||||||||||||||||||||
67 | Post program income | $66,745 | Percent of participants from Jobversity, 2028 | 73.1% | |||||||||||||||||||||||||||||
68 | Program Earning Increase Effect | $56,745 | Grantee Post-Income | $29,424 | |||||||||||||||||||||||||||||
69 | Jobversity Earning Increase Effect | $5,675 | Counterfactual Income | $10,000 | |||||||||||||||||||||||||||||
70 | Jobversity Graduation Rate | 38% | Estimated @ 50% of direct programs | ||||||||||||||||||||||||||||||
71 | Jobversity Placement Rate | 21% | Estimated @ 50% of direct programs | Number of direct service | 361 | ||||||||||||||||||||||||||||
72 | Total Jobversity Students with Lifetime earnings impacted first two years year | 326.5783365 | Total x grad rates x placement rates | Income | $66,745 | ||||||||||||||||||||||||||||
73 | Additional Assumptions (narrative) | Std Dev | $20,024 | ||||||||||||||||||||||||||||||
74 | Only 5 years of program activity are modelled, with lifetime impacts of early participants continuing beyond those 5 years. | Number of JobVersity | 980 | ||||||||||||||||||||||||||||||
75 | Only 2 years of funding is modeled, but we expect continued expansion of the program based on other funders participating. | Income | $15,675 | ||||||||||||||||||||||||||||||
76 | Std Dev | $4,702 | |||||||||||||||||||||||||||||||
77 | |||||||||||||||||||||||||||||||||
78 | |||||||||||||||||||||||||||||||||
79 | Counterfactual | 1,341 | |||||||||||||||||||||||||||||||
80 | Income | $10,000 | |||||||||||||||||||||||||||||||
81 | Std Dev | $3,000 | |||||||||||||||||||||||||||||||
82 | |||||||||||||||||||||||||||||||||
83 | |||||||||||||||||||||||||||||||||
84 | |||||||||||||||||||||||||||||||||
85 | |||||||||||||||||||||||||||||||||
86 | |||||||||||||||||||||||||||||||||
87 | |||||||||||||||||||||||||||||||||
88 | |||||||||||||||||||||||||||||||||
89 | |||||||||||||||||||||||||||||||||
90 | |||||||||||||||||||||||||||||||||
91 | |||||||||||||||||||||||||||||||||
92 | |||||||||||||||||||||||||||||||||
93 | |||||||||||||||||||||||||||||||||
94 | |||||||||||||||||||||||||||||||||
95 | |||||||||||||||||||||||||||||||||
96 | |||||||||||||||||||||||||||||||||
97 | |||||||||||||||||||||||||||||||||
98 | |||||||||||||||||||||||||||||||||
99 | |||||||||||||||||||||||||||||||||
100 |