|
|
|
|
|
|
|
|
|
|
|
|
Legend: |
Static Field |
|
|
|
|
|
|
|
|
|
|
Calculated Field |
|
|
|
|
|
|
|
|
|
|
To be Completed by Applicant |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Summary |
|
|
Output |
|
|
|
|
|
|
|
|
|
Total Maximum Leverage Ratio: |
|
|
|
|
|
|
|
|
|
|
General Assumptions |
|
|
|
|
|
|
|
|
|
Total Amounts Allocated |
$16 |
|
|
|
|
|
|
|
|
|
Statutory Allocation |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Capital Access Programs |
|
|
Output |
|
|
|
|
|
|
|
|
|
Maximum Leverage Ratio: |
|
|
|
|
|
|
|
|
|
|
General Assumptions |
|
|
|
|
|
|
|
|
|
Amount to be Allocated to Program |
|
|
|
|
|
|
|
|
|
|
Federal Contributions |
|
|
|
|
|
|
|
|
|
|
Borrower Premium Contribution |
|
|
|
|
|
|
|
|
|
|
Financial Institution Lender Premium Contribution |
|
|
|
|
|
|
|
|
|
|
Total Loan Loss Referve Percentage |
0% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| VC (Accelerator Example) |
|
|
Output |
|
Portfolio Composition Assumptions |
|
|
|
Maximum Leverage Ratio: |
15.03 |
|
Funding Round |
Federal Funds % |
Round Success % |
Cumulative Success % |
Round Size ($000's) |
|
|
|
General Assumptions |
|
1 |
50% |
|
100.00% |
$150 |
|
|
|
Amount to be Allocated to Program |
|
|
2 |
8% |
50% |
50.00% |
$450 |
|
|
|
|
|
|
3 |
0% |
17% |
8.50% |
$2,500 |
|
|
|
|
|
|
4 |
0% |
25% |
2.13% |
$10,000 |
|
|
|
|
|
|
5 |
0% |
50% |
1.06% |
$20,000 |
|
|
|
|
|
|
6+ |
0% |
90% |
0.96% |
$50,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| VC Program |
|
|
Output |
|
Portfolio Composition Assumptions |
|
|
|
Maximum Leverage Ratio: |
30.25 |
|
Funding Round |
Federal Funds % |
Round Success % |
Cumulative Success % |
Round Size ($000's) |
|
|
|
General Assumptions |
|
1 |
8% |
|
100.00% |
$450 |
|
|
|
Amount to be Allocated to Program |
$4 |
|
2 |
4% |
17% |
17.00% |
$2,500 |
|
|
|
|
|
|
3 |
0% |
25% |
4.25% |
$10,000 |
|
|
|
|
|
|
4 |
0% |
50% |
2.13% |
$20,000 |
|
|
|
|
|
|
5 |
0% |
75% |
1.59% |
$- |
|
|
|
|
|
|
6+ |
0% |
0% |
0.00% |
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Loan Participation Program |
|
|
Output |
|
Portfolio Composition Assumptions |
|
|
|
Maximum Leverage Ratio: |
17.38 |
|
Loan Tenor (yrs) |
Multiple |
% of total portfolio |
|
|
|
|
|
General Assumptions |
|
1 |
4.92 |
0% |
|
|
|
|
|
Amount to be Allocated to Program |
$4 |
|
3 |
1.98 |
5% |
|
|
|
|
|
Time until recycling (yrs) |
4 |
|
5 |
1.98 |
90% |
|
|
|
|
|
Time Horizon (yrs) |
10 |
|
10 |
1.00 |
5% |
|
|
|
|
|
Average % Participation |
10% |
|
Total |
100% |
|
|
|
|
|
Assumed Loss % |
2% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Loan Guarantee Program |
|
|
Output |
|
Portfolio Composition Assumptions |
|
|
|
Maximum Leverage Ratio: |
7.52 |
|
Loan Tenor (yrs) |
Multiple |
% of total portfolio |
|
|
|
|
|
General Assumptions |
|
revolving |
1.5 |
20% |
|
|
|
|
|
Amount to be Allocated to Program |
$4 |
|
1 |
4.2 |
5% |
|
|
|
|
|
Time until recycling (yrs) |
5 |
|
3 |
1.8 |
25% |
|
|
|
|
|
Time Horizon (yrs) |
10 |
|
5 |
1 |
50% |
|
|
|
|
|
Average % Loan Guarantee |
65% |
|
10 |
1 |
0% |
|
|
|
|
|
% of Guarantee set aside as cash reserve |
25% |
|
Total |
100% |
|
1.46 |
|
|
|
Assumed loss % |
20% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Collateral Support Program |
|
|
Output |
|
Portfolio Composition Assumptions |
|
|
|
Maximum Leverage Ratio: |
8.31 |
|
Loan Tenor (yrs) |
Term of Collateral Support |
Multiple |
% of total portfolio |
|
|
|
|
General Assumptions |
|
1 |
1 |
4.92 |
5% |
|
|
|
|
Amount to be Allocated to Program |
$4 |
|
3 |
3 |
1.98 |
25% |
|
|
|
|
Time until recycling (yrs) |
4 |
|
5 |
3.5 |
1.98 |
65% |
|
|
|
|
Time Horizon (yrs) |
10 |
|
10 |
7 |
1 |
5% |
|
|
|
|
Avg % of principal as Collateral Support |
20% |
|
Total |
100% |
|
|
|
|
Assumed Loss % |
2% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Legend: |
Static Field |
|
|
|
|
|
|
|
|
|
|
Calculated Field |
|
|
|
|
|
|
|
|
|
|
To be Completed by Applicant |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| TOTAL AMOUNTS ALLOCATED ON LEVERAGE CALCULATIONS |
$16 |
|
|
|
|
|
|
|
|
|
|
| TOTAL FUNDED AMOUNT FOR OCSPs |
$110,032,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Applicant Aggregate Projections for OCSPs |
2022 |
2023 |
2024 |
2025 |
2026 |
2027 |
2028 |
2029 |
2030 |
2031 |
|
| Totla Number of New Investments per Year |
33 |
53 |
74 |
81 |
88 |
89 |
91 |
51 |
54 |
60 |
|
| Total Cumulative Number of New Investments |
33 |
86 |
160 |
241 |
329 |
418 |
510 |
561 |
615 |
674 |
|
| Total Annual Federal Funds |
$6,004,400 |
$10,004,400 |
$14,004,400 |
$15,004,400 |
$16,004,400 |
$16,002,000 |
$15,002,000 |
$6,002,000 |
$6,002,000 |
$6,002,000 |
|
| Total Cumulative Federal Funds |
$6,004,400 |
$16,008,800 |
$30,013,200 |
$45,017,600 |
$61,022,000 |
$77,024,000 |
$92,026,000 |
$98,028,000 |
$104,030,000 |
$110,032,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Venture Capital Fund (VC) Program: |
|
|
|
|
|
|
|
|
|
|
|
| Program Total Funded Amount |
$60,000,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Venture Capital Fund Program - Projections |
2022 |
2023 |
2024 |
2025 |
2026 |
2027 |
2028 |
2029 |
2030 |
2031 |
|
| Number of New Investments per Year |
20 |
35 |
50 |
50 |
50 |
50 |
45 |
|
|
|
|
| Federal Contributions Deployed |
$4,000,000 |
$7,000,000 |
$10,000,000 |
$10,000,000 |
$10,000,000 |
$10,000,000 |
$9,000,000 |
$- |
$- |
$- |
|
| Cumulative Number of Investments |
20 |
55 |
105 |
155 |
205 |
255 |
300 |
300 |
300 |
300 |
|
| Cumulative Federal Funds |
4,000,000 |
11,000,000 |
21,000,000 |
31,000,000 |
41,000,000 |
51,000,000 |
60,000,000 |
60,000,000 |
60,000,000 |
60,000,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Loan Participation Programs |
|
|
|
|
|
|
|
|
|
|
|
| Program Total Funded Amount |
$50,000,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Loan Participation Programs - Projections |
2022 |
2023 |
2024 |
2025 |
2026 |
2027 |
2028 |
2029 |
2030 |
2031 |
|
| Number of New Loans (count Federal + Private funds as one loan) |
10 |
15 |
21 |
28 |
35 |
36 |
43 |
48 |
51 |
57 |
|
| Federal Contributions |
$2,000,000 |
$3,000,000 |
$4,000,000 |
$5,000,000 |
$6,000,000 |
$6,000,000 |
$6,000,000 |
$6,000,000 |
$6,000,000 |
$6,000,000 |
|
| Cumulative Number of Investments |
10 |
25 |
46 |
74 |
109 |
145 |
189 |
237 |
288 |
344 |
|
| Cumulative Federal Funds |
$2,000,000 |
$5,000,000 |
$9,000,000 |
$14,000,000 |
$20,000,000 |
$26,000,000 |
$32,000,000 |
$38,000,000 |
$44,000,000 |
$50,000,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Loan Guarantee Program |
|
|
|
|
|
|
|
|
|
|
|
| Program Total Funded Amount |
$12,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Loan Guarantee Program - Projections |
2022 |
2023 |
2024 |
2025 |
2026 |
2027 |
2028 |
2029 |
2030 |
2031 |
|
| Number of New Loans |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
| Federal Contributions |
$2,400 |
$2,400 |
$2,400 |
$2,400 |
$2,400 |
|
|
|
|
|
|
| Cumulative Number of Investments |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
|
| Cumulative Federal Funds |
$2,400 |
$4,800 |
$7,200 |
$9,600 |
$12,000 |
$12,000 |
$12,000 |
$12,000 |
$12,000 |
$12,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Collateral Support Program (CSP) |
|
|
|
|
|
|
|
|
|
|
|
| Program Total Funded Amount |
$20,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| CSP - Projections |
2022 |
2023 |
2024 |
2025 |
2026 |
2027 |
2028 |
2029 |
2030 |
2031 |
|
| Number of New Loans |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
|
| Federal Contributions |
$2,000 |
$2,000 |
$2,000 |
$2,000 |
$2,000 |
$2,000 |
$2,000 |
$2,000 |
$2,000 |
$2,000 |
|
| Cumulative Number of Investments |
2 |
4 |
6 |
8 |
10 |
12 |
14 |
16 |
18 |
20 |
|
| Cumulative Federal Funds |
2,000 |
4,000 |
6,000 |
8,000 |
10,000 |
12,000 |
14,000 |
16,000 |
18,000 |
20,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|