CDFI Program and NMTC Program Annual Report

CDFI Program Awardee and NMTC Allocatee Annual Report

NMTC Report Template_TLR Data 1559-0027.xlsx

CDFI Program and NMTC Program Annual Report

OMB: 1559-0027

Document [xlsx]
Download: xlsx | pdf

Overview

PRA Burden Statement 1559-0027
TLR Projects
TLR Notes
TLR Addresses


Sheet 1: PRA Burden Statement 1559-0027

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.

Sheet 2: TLR Projects

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

Sheet 3: TLR Notes

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

Sheet 4: TLR Addresses

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 Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy