| Community Development Financial Institutions Program CDFI Program Awardee and NMTC Allocatee Annual Report OMB Approval Number 1559-0027 PAPERWORK REDUCTION ACT NOTICE Public reporting burden for this collection of information is estimated to average 60 hours per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. An agency may not conduct or sponsor, and a person is not required to respond to, a collection of information unless it displays a valid OMB control number. The valid OMB control number for this collection is 1559-0027. Send comments regarding this burden estimate or any other aspect of this collection of information to the Department of Treasury, CDFI Fund, 1500 Pennsylvania Avenue NW, Washington, DC 20220. |
| Generated By: | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Organization: | Test Organization, LLC. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Report Type: | TLR | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Fiscal Year: | 2019 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Submission Date: | 1/1/2020 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Certification Date: | 1/1/2020 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Certfied Transactions: | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Project Number | QLICI Type | Investee Type | Multi-CDE Project Number | Legacy ID | Organization | Fiscal Year | Last Certified Date | Fiscal year for which last certified | Total Project Cost | Total Project Cost Public Sources | Total Project Cost Other CDEs | Total Project Cost Private Investment | Loan-to-Value Ratio | Projected Debt Service Coverage Ratio | Loan Loss Reserve Requirement | Client ID | Investee TIN | Investee CDE Certification Number | Date Business Established | Entity Structure | Minority Owned or Controlled | Women Owned or Controlled | Low-Income Owned or Controlled | Race | Hispanic Origin | Business Description - Primary | Business Description - Narrative | NAICS | Original Loan/Investment Amount | Annual Gross Revenue (Loan/Investment) | Annual Gross Revenue (Reporting Period) | Type of Jobs Reported | Jobs at Time of Loan/Investment | Projected Permanent Jobs (Financed) | Projected Jobs (Construction) | Projected Permanent Jobs (Tenant) | Actual Jobs Created (Financed) | Actual Jobs Created (Construction) | Actual Jobs Created (Tenant) | Source of Job Estimates | Source of Job Estimates - Other | Square Feet of Real Estate - Manufacture | Square Feet of Real Estate - Office | Square Feet of Real Estate - Retail | Housing Units - Sale | Housing Units - Rental | Affordable Housing Units - Sale | Affordable Housing Units - Rental | Community Facility | Capacity of Educational Community | Capacity of Childcare Community Facility | Capacity of Healthcare Community | Capacity of Arts Center Community | QALICB Type | NMTC Eligibility Criteria | Related Entity | Front End Sources (Investors) | Front End Sources (Borrowers/Investees) | Front End Sources (Other Entities) | On-going Sources (Investors) | On-going Sources (Borrowers/Investees) | On-going Sources (Other Entities) | Back-end Sources (Investors) | Back-end Sources (Borrowers/Investees) | Back-end Sources (Other Entities) | Other Sources (Investors) | Other Sources (Borrowers/Investees) | Other Sources (Other Entities) | Total QEI Proceeds Retained by the CDE | Below Market Interest Rate | Blended Interest Rate | Comparable Blended Interest Rate | Lower than Standard Origination Fees | Standard Origination Fees (Project) | Higher than Standard Loan to Value Ratio | Standard Loan to Value Ratio | More Flexible Borrower Credit Standards | Lower than Standard Debt Service Ratio | Standard Debt Service Coverage Ratio | Lower than Standard Loan Loss Req | Standard Loan Loss Reserve Requirement | Poverty Rates >25% and <30% | Poverty Rates Greater than 30% | Median Income <60% of Area Median Income | Median Income 60-70% Area Median Income | Unemployment rates 1.25 - 1.5 Nation AVG | Unemployment rates 1.5X national average | Designated for Redevelopment | Designated EZ, EC, or RC | SBA Designated HUB Zone | Designated Native American | Brownfield Redevelopment Area | Encompassed HOPE VI Redevelopment Plan | Located in a Hot Zone | Appalachian Commission/ Delta Authority | Colonias | Medically Underserved Area | TIF District or Enterprise Zone Program | High Migration Rural County | Non-Metropolitan Census Tract | FEMA | TAA Program | Food Desert | Targeted Populations | Other Areas of Higher Distress |
| TLR Project | Organization | Originator Transaction ID | Fiscal year for which last certified | Last Certified Date | Purpose | Transaction Type | Loan Status | Date Originated | Original Loan/Investment Amount | Refinancing | Construction or Permanent Financing | Take-out or Acquisition Financing | Acquisition or Rehabilitation | Rehabilitation Amount | Loan Origination Fees | Interest Rate at Origination | Interest Rate | Interest Type | Points | Amortization Type | Length of Amortization Period | Period of Interest Only Payments | Term | Guarantee | Lien Position | Collateral Type | Collateral Value at Origination | Equity-Like Features | Equity Injection Amount | Advanced Purchase Commitment | Seller Organization | Lower than Standard Origination Fees | Standard Origination Fees | Longer than Period Interest Only Payment | Standard Period of Interest Only Payment | Longer than Standard Amortization Period | Standard Amortization Period | Standard Amortization Period Comparable? | Standard Amortization Period Comp Other | Nontraditional Forms of Collateral | Traditional Form of Collateral | Traditional Collateral Comparable? | Traditional Collateral Comparable Other | Equity Product | Equity-Equivalent Terms & Conditions | Debt with Equity Features | Subordinated Debt | Below Market Interest Rate Origination | Comparable Interest Rate at Origination | Below Market Rates or Flexible Terms | Below Market Interest Rate | What is Interest Rate Comparable? | Interest Rate Comparable Other | QLICI Level | Principal Balance Outstanding | NRE Activities Finance Amount | New Restructured Loan Transaction ID | Days Delinquent | Number of 60 Days or More Delinquent | Number of Times the Loan Restructured | Amount Charged Off | Amount Recovered | Actual Rate of Return | Projected Residual Value of QLICI |
| Project Number | TLR Project | Multi-CDE Project Number | Fiscal year for which last certified | Last Certified Date | Investee Address | Investee Street Address Line 1 | Investee Street Address Line 2 | Investee City | Investee State | Investee Zip Code | Investee Zip Code +4 | Investee FIPS Code | Investee Longitude | Investee Latitude | Project Address | Project Street Address Line 1 | Project Street Address Line 2 | Project City | Project State | Project Zip Code | Project FIPS Code | Project Longitude | Project Latitude | Metro/Non Metro | Census Tract Error Message | Calculated FIPS code | Census Tract (Calculated) | Metro/Non Metro (Calculated) | Census Tract Error Message (Calculated) |
| File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
| File Modified | 0000-00-00 |
| File Created | 0000-00-00 |