Leverage Tables.xlsx

State Small Business Credit Initiative Allocation Agreement

Leverage Tables.xlsx

OMB: 1505-0227

Document [xlsx]
Download: xlsx | pdf

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












File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy