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

---

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