SSBCI Application

---

Overview

Leverage Calculations
Enrolled Loan Data Tables

---

Sheet 1: Leverage Calculations

	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%

---

Sheet 2: Enrolled Loan Data Tables

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