Community Investment Impact System (CIIS) CIIS 3.4 Release CDFI TLR Content May 2006

1. US Department of the Treasury Community Development Financial Institutions Fund Community Investment Impact System (CIIS) CIIS 3.4 Release CDFI TLR Content May 2006

2. Presentation Outline • Introduction to CIIS • TLR Instructions • Certifying CIIS Reports • Useful Information

3. Introduction to CIIS • What is CIIS? • Community Investment Impact System • System for CDFIs to report activity to the Fund • CIIS Reports Due Dates • Annual • Report period = CDFI’s fiscal year • (2005 Report period = CDFI’s fiscal year ending in 2005) • CIIS due date is 180 days after report period end • (If CDFI’s 2005 fiscal year end is 12-31-2005, 2005 reports are due 6-30-2006)

4. Introduction to CIIS • Institution Level Report (ILR) • Institution level data • Required for all Awardees with current reporting period (see Assistance Agreement). • Transaction Level Report (TLR) • Transaction level data (Portfolio) • Include each transaction that was active during report period. • Data must represent the report period end date. • Required for the following CDFI Awardees with current reporting period (see Assistance Agreement): • FA 2003 – 2005 • NACA with FA 2003 – 2005 • Any Awardee or Certified CDFI may provide a voluntary TLR.

5. TLR Instructions HINT: If you Certified a TLR in a previous report period, begin the FY 2005 TLR by downloading the previous report to the Manual/Online entry or to a current Excel Template.

6. TLR Instructions – Reading the Instructions • Data point instructions in this presentation: • Originator Transaction ID • “Loan Number” • Used to track loan/investment across report periods Double border: MANDATORY data point Thick Border: CONDITIONALLY REQUIRED data point Business Description • Open-ended text field Blue background: Data point used for COMPLIANCE

7. TLR Instructions – Reading the Instructions • Data point instructions in the TLR Instructions: Double border: MANDATORY data point Thick Border: CONDITIONALLY REQUIRED data point Blue background: Data point used for COMPLIANCE

8. TLR Instructions - Transaction Identifiers • Assign a unique identifier to each transaction: • Assign a unique identifier to distinct investees (clients/borrowers): • Report whether loan/investment to individual, business, or CDFI • Originator Transaction ID • “Loan Number” • Used to track loan/investment across report periods • ClientID • Project Level • Used to track investee across loans/investments & report periods • Investee Type • Nonprofits are Businesses

9. TLR Instructions - Transaction Profile • Basic information about each transaction. • Key data points for General Validations. Date Originated Original Loan/Investment Amount • Purpose • If multiple purposes, select the purpose with the largest %. • Loans to CDFI = Other • Transaction Type • Debt, Line of Credit, Debt with Equity, Equity

10. TLR Instructions - Transaction Identifiers (Debt Terms) Transaction Type Debt (Term Loan, LOC, Debt w/Equity) Equity Interest Rate Date First Payment Due Interest Type Guarantee Points Lien Position Origination Fees Collateral Type Amortization Type Collateral Value Equity-Like Features Equity Injection Amount Term Forgivable Loan

11. TLR Instructions - Address • Addresses • Users may provide addresses or 11-digit FIPS codes (census tract) • Must pass Address Verification • Verify that address is “geocodable.” • CIIS cannot geocode PO Boxes or Rural Routes. Investee Address Project Address(es) • User may provide multiple Project Addresses. • May be the same as the Investee Address.

12. TLR Instructions - Borrower/Investee Profile • Information about the borrower/investee. NAICS Low-Income Owned/Controlled SIC Code Date Business Established Entity Structure Minority Owned/Controlled Women Owned/Controlled

13. TLR Instructions - Borrower/Investee Profile • Complete impact data must be provided in either the ILR or TLR. • For business lending: • Jobs at Time of Loan/Investment • If Purpose = Business, include jobs in business • Exclude construction jobs • Exclude tenant jobs • Exclude other “multiplier jobs” • Jobs at Reporting Period End • Update in “Status Section”

14. TLR Instructions - Transaction Status • Transaction Status section requires an annual update. • Loan Status • Active = “On-the-books” or “Open” • Closed = “Off-the-books,” “Paid in full,” or “Exited” • Sold / Charged Off / Refinanced = “Off-the-books”, but not paid off

15. TLR Instructions - Transaction Status (Debt Terms) Transaction Type Debt (Term Loan, LOC, Debt w/Equity) Equity Principal Balance Outstanding Fair Value at Origination Number of Times 60+ Days Past Due Number of Times Loan was Restructured Days Delinquent Fair Value at End of Reporting Period Amount Charged Off Number of Times Loan was Refinanced Amount Recovered

16. TLR Instructions - Impact Profile (Total Project Cost) • Total funding for “Project” financed by the transaction. Total Project Cost • Total Project Cost – Public Sources • Subset of Total Project Cost • Total Project Cost – Affiliates & Related Programs • *CIIS FY 2006* • Subset of Total Project Cost

17. TLR Instructions - Projected Impacts Purpose Real Estate Business Project Level Capacity of Community Facility • Capacity of Community Facility in CIIS FY 2006 • CIIS will have distinct data points for educational, childcare, healthcare, arts center, and other community facilities. Square Feet of RE – Manufacturing/Office/Retail Total Square Feet of RE in CIIS FY 2006 Affordable/Housing Units – Sale/Rental

18. TLR Instructions - Projected Impacts Purpose Real Estate Business • Projected Jobs to be Created • (Purpose = RE) Include construction jobs / Exclude tenant jobs • (Purpose = Bus) Include jobs in business • Projected Jobs to be Created • *CIIS FY 2006* • CIIS will have distinct data points for Business Jobs, Construction Jobs, and Tenant Jobs. • Other Impacts (Description, #) • Add your own impacts • If user provides Description, must provide #

19. Certifying CIIS Reports • CIIS has a single Certification for the ILR and TLR. • Organizations may only Certify one time per Report Period. • Users may Certify TLR when: • ILR is complete. • TLR – There are one or more Pre-Certified Transactions. • TLR – There are no Transactions in the Pending List. • How to Certify: Select “Certify” from CIIS home page

20. Useful information • Additional CIIS information is available at www.cdfifund.gov/what_we_do/ciis.asp • Contact the CIIS Help Desk at ciishelp@kearneyco.com or (703) 373 -1516