Community Investment Impact System (CIIS) CIIS 8.1 CDFI TLR Content February 2011

1. US Department of the Treasury Community Development Financial Institutions Fund Community Investment Impact System (CIIS) CIIS 8.1 CDFI TLR Content February 2011

2. Agenda • Introduction to CIIS • TLR Instructions • Certifying CIIS Reports • Questions - throughout

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

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 – 2009 • NACA with FA 2003 – 2009 • 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 2010 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 • 1990 FIPS Code • 11-digit FIPS code that identifies the correct 1990 census tract. 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 (cenus 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 Minority Owned/Controlled Date Business Established Women Owned/Controlled Entity Structure Low-Income 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 • (RE) Include construction jobs / Exclude tenant jobs • (Bus) Include jobs in business • 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” or “paid in full” • 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 Number of Times 60+ Days Past Due Fair Value at Origination 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 • Subset of Total Project Cost

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

18. TLR Instructions - Projected Impacts Purpose Real Estate Business Projected Jobs to be Created - Business • Projected Jobs to be Created • Construction • Projected Jobs to be Created at Tenant Businesses • 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 the CIIS home page

20. 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