ECIP Disaggregate Qualified Lending Data (Banks & Holdin

Emergency Capital Investment Program Reporting

ECIP_DQLD_BHC_Template.xlsx

OMB: 1505-0275

Document [xlsx]
Download: xlsx | pdf
3/30/2022 Version 1




















Template Name: ECIP Disaggregate Qualified Lending Data (BHC)




















Instructions to Reporter:
a. Do not change the cell formatting.
b. Do not reformat the template.
c. Only input numbers (No symbols such as "$", ",").
d. Only input whole dollar amounts (No fractions or decimals).
Step 1 - Populate your data in the .XLSX file, starting on row 8.
Step 2 - Save the fully populated file as .CSV file.
Step 3 - Upload the .CSV file to the portal.





















Field ID ISR_ID__c Lending_Plan_Category__c Dollar_Originations_TO__c_ LMI_Borrowers__c Other_Targeted_Populations__c Low_Income_Borrowers__c MTGE_Lending_Other_Targeted_Populations__c Rural_Communities__c Urban_Low_Income_Communities__c Underserved_Communities__c Minority_Communities__c Persistent_Poverty_Counties__c IN_Country_Indian_REZ_Native_Hawaiian__c U_S_Territories__c Small_Businesses_or_Farms__c Underserved_Small_Businesses__c Affordable_Housing__c Public_Welfare_Comm_Dev_Investments1__c Community_Service_Facility__c Deeply_Affordable_Housing__c Public_Welfare_Comm_Dev_Investments2__c
Label ISR ID Lending Plan Category (Column A) Total Loan Originations Qualified Lending Originations (including Deep Impact Lending Originations) : People : (Column B) LMI Borrowers Qualified Lending Originations (including Deep Impact Lending Originations) : People : (Column C) Other Targeted Populations Qualified Lending Originations (including Deep Impact Lending Originations) : People : Deep Impact Lending : (Column D) Low-Income Borrowers Qualified Lending Originations (including Deep Impact Lending Originations) : People : Deep Impact Lending : (Column E) Mortgage Lending to Other Targeted Populations Qualified Lending Originations (including Deep Impact Lending Originations) : Places : (Column F) Rural Communities Qualified Lending Originations (including Deep Impact Lending Originations) : Places : (Column G) Urban Low-Income Communities Qualified Lending Originations (including Deep Impact Lending Originations) : Places : (Column H) Underserved Communities Qualified Lending Originations (including Deep Impact Lending Originations) : Places : (Column I) Minority Communitites Qualified Lending Originations (including Deep Impact Lending Originations) : Places : Deep Impact Lending : (Column J) Persistent Poverty Counties Qualified Lending Originations (including Deep Impact Lending Originations) : Places : Deep Impact Lending : (Column K) [Indian Country] /
[Indian Reservations and Native Hawaiian Homelands]
Qualified Lending Originations (including Deep Impact Lending Originations) : Places : Deep Impact Lending : (Column L) U.S. Territories Qualified Lending Originations (including Deep Impact Lending Originations) : Businesses : (Column M) Small Businesses or Farms Qualified Lending Originations (including Deep Impact Lending Originations) : Businesses : Deep Impact Lending : (Column N) Underserved Small Businesses Qualified Lending Originations (including Deep Impact Lending Originations) : Borrowers or projects that create direct benefits for LMI communities or to Other Targeted Populations : (Column O) Affordable Housing Qualified Lending Originations (including Deep Impact Lending Originations) : Borrowers or projects that create direct benefits for LMI communities or to Other Targeted Populations : (Column P) Public Welfare and Community Development Investments1 Qualified Lending Originations (including Deep Impact Lending Originations) : Borrowers or projects that create direct benefits for LMI communities or to Other Targeted Populations : (Column Q) Community Service Facility Qualified Lending Originations (including Deep Impact Lending Originations) : Borrowers or projects that create direct benefits for LMI communities or to Other Targeted Populations : Deep Impact Lending : (Column R) Deeply Affordable Housing Qualified Lending Originations (including Deep Impact Lending Originations) : Borrowers or projects that create direct benefits for LMI communities or to Other Targeted Populations : Deep Impact Lending : (Column S) Public Welfare and Community Development Investments2
Required or Optional Required Required Required Required Required Required Required Required Required Required Required Required Required Required Required Required Required Required Required Required Required
Help Text - - - - - - - - - - - - - - - - - - - - -

1 Loans secured by construction land development and other land loans 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

2 Loans secured by farmland 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

3 Loans secured by 1-4 family residential properties 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

4 Loans secured by multifamily (5 or more) residential properties 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

5 Loans secured by nonfarm nonresidential properties 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

6 Loans to finance agricultural production and other loans to farmers 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

7 Commercial and industrial loans 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

8 Loans to individuals for household family and other personal expenditures 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

9 Lease financing receivables 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

10 Direct and indirect investments in real estate ventures 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

11 Equity investments without readily determinable fair values 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy