1c Guarantee Application - Appendix B-ID-Charts and Templat

Bond Guarantee Program

Guarantee Application Appendix B-ID-Charts and Templates.xlsx

Bond Guarantee Program

OMB: 1559-0044

Document [xlsx]
Download: xlsx | pdf

Overview

B-ID-4-Proposed Uses
B-ID-9A-Portfolio QualityReport
B-ID-9A-Instructions
B-ID-9A Definitions
B-ID-9B-Pipeline (History)
B-ID-9B-Pipeline
B-ID-9C-Portfolio
B-ID-10A-Grant
B-ID-10G-Revenue
B-ID-10H-Debt Statistics
B-ID-10I-Restricted Funds


Sheet 1: B-ID-4-Proposed Uses

Appendix: Examples of Document and Chart Formatting









B-ID-4-Proposed Uses










Advance 1 Advance 2 Advance 3 Advance 4 Advance 5 Advance 6 Advance 7 Advance 8 Advance 9 Advance 10
Sources









Bond Loan Proceeds









Contribution for Risk Share Pool









Other Pledged Loans (Overcollateralization)









Cash on Hand









Total Sources




















Uses









Secondary Loans









Other Pledged Loans









Bond Issuance Fees









Deposit to Risk Share Pool Account









Total Uses































Summary of Bond Loan Terms









Date of Disbursement









Payment Frequency (Must be same for all)









Date of First Principal Payment









Date of Advance Maturity









Total $ Amount of Loans Pledged as Collateral









Number of Pledged Loans









Average Size of Pledged Loans









Estimated Bond Loan Rate (%)









Estimated Net Interest Margin (%)









Allocation to Approved Asset Class(es) (%)









Add up to 12 rows as necessary









Add up to 12 rows as necessary









Add up to 12 rows as necessary









Add up to 12 rows as necessary










Sheet 2: B-ID-9A-Portfolio QualityReport

Appendix: Examples of Document and Chart Formatting




B-ID-9A-Portfolio Quality Report






CDFI Bond Guarantee Program




Phone: (202) 653-0421 Email: [email protected]

B-ID-9A-Portfolio Quality Report



(Follow form instructions)



OMB Form No.
CDFI Name
Reporting Period Reporting Period
1559-0044










13. ECDFI Portfolio Quality


Number Dollar Amount
13a. Unsecured Outstanding Loans




13b. Loan Commitments During Reporting Period




13c. Loan Disbursements During Reporting Period




13d. Loans 30-59 Days Past Due




13e. Loans 60-89 Days Past Due




13f. Loans 90 Days or More Past Due




13g. Restructured and/or Rescheduled Loans, or Troubled Debt Restructuring




13h. Other Modifications




13i. Other Real Estate Owned Assets




13j. Total Nonperforming Assets




13k. Loans Charged Off During Reporting Period




13l. Recoveries on Previously Charged Off Loans










14. Explanatory Comments Regarding Financial Performance During Current Reporting Period


























































































Sheet 3: B-ID-9A-Instructions

Appendix: Examples of Document and Chart Formatting














CDFI Bond Guarantee Program





Phone: (202) 653-0421 Email: [email protected]





B-ID-9A-PORTFOLIO QUALITY REPORT
OMB Approval No.



Instructions



1559-0044




11/30/2017










Line
Reporting Item

Instructions



Selected Balance Sheet Information








Note: This portion of the form only includes selected data points; therefore "total" lines will not necessarily foot.








ECDFI Portfolio Quality








13a.
Unsecured Outstanding Loans
Report the Number and Dollar Amount of "Unsecured Outstanding Loans" at the reporting period end.




13b.
Loan Commitments During Reporting Period
Report the Number and Dollar Amount of "Loan Commitments During Reporting Period" for the indicated reporting period.




13c.
Loan Disbursements During Reporting Period
Report the Number and Dollar Amount of "Loan Disbursements During Reporting Period" for the indicated reporting period




13d.
Loans 30-59 Days Past Due
Report the Number and Dollar Amount of all outstanding loans to borrowers that are between 30 and 59 days "Past Due" at the end of the reporting period. This delinquency history should consider "Past Due" payments that have occurred since the origination date.




13e.
Loans 60-89 Days Past Due
Report the Number and Dollar Amount of all outstanding loans to borrowers that are between 60 and 89 days "Past Due" at the end of the reporting period. This delinquency history should consider "Past Due" payments that have occurred since the origination date.




13f.
Loans 90 Days or More Past Due
Report the Number and Dollar Amount of all outstanding loans to borrowers that are 90 or more "Past Due" at the end of the reporting period. This delinquency history should consider "Past Due" payments that have occurred since the origination date.




13g.
Restructured and/or Rescheduled Loans, or Troubled Debt Restructuring
Report the Number and Dollar Amount of "Restructured and/or Rescheduled Loans, or Troubled Debt Restructuring" at the reporting period end.




13h.
Other Modifications
Report the Number and Dollar Amount of "Other Modifications" at the reporting period end.




13i.
Other Real Estate Owned Assets
Report the Number and Dollar Amount of "Other Real Estate Owned (OREO) Assets" at the reporting period end.




13j.
Total Nonperforming Assets
Report the Number and Dollar Amount of "Total Nonperforming Assets" at the reporting period end. This shall be equal to the values of 13f plus 13g plus 13i within this FCM Report.




13k.
Loans Charged Off During Reporting Period
Report the Number and Dollar Amount of "Loans Charged Off During Reporting Period" at the reporting period end.




13l.
Recoveries on Previously Charged Off Loans
Report the Number and Dollar Amount of "Recoveries on Previously Charged Off Loans" at the reporting period end.




Explanatory Comments Regarding Financial Performance During Current Reporting Period








14
Comments
If necessary or desired, provide summary comments clarifying or explaining specific data point values, and/or variations in individual data points or overall organization financial performance that have occurred during the current reporting period.





Sheet 4: B-ID-9A Definitions

Appendix: Examples of Document and Chart Formatting

















CDFI Bond Guarantee Program








Phone: (202) 653-0421 Email: [email protected]







B-ID-9A-PORTFOLIO QUALITY REPORT







Instructions Form Expiration Date





1559-0044




11/30/2017















Term


Definition







Loan Commitments During Reporting Period


The gross value of loan commitments by the CDFI that occurred during the indicated reporting period start and end dates. Commitments are defined as internally approved transactions with an executed term sheet.







Loan Disbursements During Reporting Period


The gross value of loan disbursements by the CDFI that occurred during the indicated reporting period start and end dates (exclude refinancings).







Loans Charged Off During Reporting Period


The principal amount of debt that is deemed uncollectable and is subsequently written off during the current reporting period.







Other Modifications


Loans for which one or more terms have been modified for reasons other than to accommodate borrower hardship or difficulty, or to avoid default.







Other Real Estate Owned (OREO) Assets


"The total value of real estate assets acquired through any means in full or partial satisfaction of a debt previously contracted" (per the Office of the Comptroller of the Currency).








Past Due

The unpaid principal balance of all loan receivables with payments currently outstanding and beyond the indicated number of days, exclusive of charge-offs.







Recoveries on Previously Charged Off Loans


The amount of all gross recoveries on charged-off loans, less any related expenses, collected during the current reporting period.







Restructured and/or Rescheduled Loans, or Troubled Debt Restructuring


Loans for which one or more terms has been modified to accommodate borrower hardship or difficulty, or to avoid default. This includes troubled debt restructuring, forbearance or forgiveness of principal amounts owed, extension of the term,











interest rate reduction, and he origination of any new loans that replace the outstanding balance of an older or existing loan for such purposes.







Total Nonperforming Assets


Total loans that are 90 days or more past due. Includes other real estate owned, restructured, rescheduled loans, and troubled debt restructuring.







Unsecured Outstanding Loans


The gross value of all loans outstanding that are not secured or otherwise supported by collateral.








Sheet 5: B-ID-9B-Pipeline (History)

Appendix: Examples of Document and Chart Formatting






B-ID-9B-Pipeline












Historical Lending Activities for Proposed Asset Classes





Asset Class* Historical Lending Activities





Cumulative Lent** Lent in Last 5 Years Social Impact 1 Social Impact 2 Social Impact 3






















Total





*Asset Class according to Secondary Loan Requirements





**If available, provide amount of cumulative funding since inception





Sheet 6: B-ID-9B-Pipeline

Appendix: Examples of Document and Chart Formatting















B-ID-9B-Pipeline















Borrower ID Amount of Other Debt with the ECDFI Approved Asset Class Proposed Loan Amount ($) Total Project Debt from All Sources ($) Total Project Costs including Soft Costs ($) Estimated Closing Date Projected Debt Service Coverage (DSC) Collateral Type (if applicable) Collateral Value ($) Refinancing of Loan Currently in Portfolio? (Y/N) Loan-to-Value Ratio (%) Valuation Date Source of Value Estimate


BGP Pipeline

1














2














3














4














5














6














7














8














9














10















Non-BGP Pipeline

1














2














3














4














5














6














7














8














9














10














Sheet 7: B-ID-9C-Portfolio

Appendix: Examples of Document and Chart Formatting























B-ID-9C-Portfolio Listing






















Loan Number Borrower ID Loan Type Outstanding Principal Balance ($) Outstanding Principal Balance (%) Unfunded Commitment ($) Total Commitment ($) Interest Rate (%) Borrowing Date Disbursement Date Maturity Date Principal Repayment Terms/ Amortized Payment Amount Delinquent Amount ($) Delinquency Date Days Past Due Security Status (Secured/ Unsecured) Security Position (First, Senior, Subordinate) Form of Collateral (Real estate, leasehold mortgage, etc.) Value of Security Valuation Date Risk Rating Date of Most Recent Modification (if applicable) Troubled Debt Restructuring (TDR)? (Yes/No)









































































































































































































































































Sheet 8: B-ID-10A-Grant

Appendix: Examples of Document and Chart Formatting




















B-ID-10A-Grant Information








































Total Grants for Lending















Likelihood of Receiving Grant






Actual

Projected













Funder Name Grant Name Federal/State/Local/Private FY14 FY15 FY16 FY17 FY18 FY19 FY20 Total Key Terms Key Covenants and Restrictions Costs Associated with Deployment of Grant (i.e.Programs/Staff)

FY18 FY19 FY20

1



















2



















3



















4



















5



















6



















7



















8



















9



















10




















Total Grants for Lending




























































Total Grants for Operations















Likelihood of Receiving Grant






Actual

Projected













Funder Name Grant Name Federal/State/Local/Private FY14 FY15 FY16 FY17 FY18 FY19 FY20 Total Key Terms Key Covenants and Restrictions Costs Associated with Deployment of Grant (i.e.Programs/Staff)

FY18 FY19 FY20

1



















2



















3



















4



















5



















6



















7



















8



















9



















10




















Total Grants for Operations


















Sheet 9: B-ID-10G-Revenue

Appendix: Examples of Document and Chart Formatting













B-ID-10G-Revenue Discussion















2012
2013
2014
2015
2016 YTD

No. Earned Revenue Sources Type (Fee, Interest, Release from Restriction, etc.) $ % of total $ % of total $ % of total $ % of total $ % of total

1












2












3












4












5













Total Earned Revenue

100%
100%
100%
100%
100%

Sheet 10: B-ID-10H-Debt Statistics

Appendix: Examples of Document and Chart Formatting













B-ID-10H-Debt Statistics


















Line of Credit Term Loan






Lender Amount Committed ($) Amount Funded ($) Interest Rate (%) Type (i.e., Term Loan or Revolving Credit) Date of Expiration Date of Origination Date of Maturity Security Status (Secured, Unsecured) Form of Collateral (if applicable) Principal Repayment Terms/Amortized Payment Amount Restrictions (if applicable)

Current












1












2












3












4












5












6












7












8












9












10












Proposed












1












2












3












4












5












6












7












8












9












10



























Weighted Average Cost of Debt

Formula

Weighted Average Term to Maturity


Formula

Sheet 11: B-ID-10I-Restricted Funds

Appendix: Examples of Document and Chart Formatting






B-ID-10I-Restricted Funds (Cash & Investments)













Source Amount of Total Investments ($) Amount of Total Cash ($) Description of Restrictions Conditions under which Restrictions may be lifted

1





2





3





4





5





6





7





8





9





10






Total



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

© 2024 OMB.report | Privacy Policy