QSR Template BHC

Emergency Capital Investment Program Reporting

QSR_Template_BHC.xlsx

OMB: 1505-0275

Document [xlsx]
Download: xlsx | pdf

Overview

Sch A
Sch B
Sch C1 People
Sch C2 Business
Sch D1 Rural
Sch D2 Urban
Sch D3 Underserved
Sch D4 Minority
Sch D5 Poverty
Sch D6 Reserv
Sch D7 Terr or PR
Sch D8 Projects


Sheet 1: Sch A

Quarterly Supplemental Report (QSR)
Schedule A - Summary Qualified Lending

ID Lending Activity Categories Total Originations Qualified Lending Originations Deep Impact Lending Originations

(Column A)
# of Originations
(Column B)
$ of Originations
(Column C)
# of Originations
(Column D)
$ of Originations
(Column E)
# of Originations
(Column F)
$ of Originations


1 Loans secured by construction, land development, and other land loans 1A 23 1B $5,780,152.00 1C 10 1D $2,457,876.00 1E 10 1F $2,457,876.00
2 Loans secured by farmland 2A 0 2B $- 2C 0 2D $- 2E 0 2F $-
3 Loans secured by 1-4 family residential properties 3A 384 3B $115,204,608.00 3C 284 3D $70,315,276.00 3E 284 3F $70,315,276.00
4 Loans secured by multifamily (5 or more) residential properties 4A 9 4B $14,500,000.00 4C 0 4D $- 4E 0 4F $-
5 Loans secured by nonfarm nonresidential properties 5A 19 5B $69,000,000.00 5C 3 5D $18,000,000.00 5E 3 5F $-
6 Loans to finance agricultural production and other loans to farmers 6A 0 6B $- 6C 0 6D $- 6E 0 6F $-
7 Commercial and industrial loans 7A 12 7B $25,500,000.00 7C 2 7D $10,000,000.00 7E 2 7F $10,000,000.00
8 Loans to individuals for household, family, and other personal expenditures 8A 148 8B $740,000.00 8C 35 8D $75,000.00 8E 35 8F $-
9 Lease financing receivables 9A 0 9B $- 9C 0 9D $- 9E 0 9F $-
10 Direct and indirect investments in real estate ventures 10A 0 10B $- 10C 0 10D $- 10E 0 10F $-
11 Equity investments without readily determinable fair values 11A 0 11B $- 11C 0 11D $- 11E 0 11F $-















Sum of Data Uploaded
12 Total 12A 595 12B $230,724,760.00 12C 334 12D $100,848,152.00 12E 334 12F $82,773,152.00
















Sheet 2: Sch B

Quarterly Supplemental Report (QSR)
Schedule B - Disaggregated Qualified Lending
ID Lending Activity Categories Qualified Lending Originations (including Deep Impact Lending Originations)
People Places Businesses Borrowers or projects that create direct benefits for LMI communities or to Other Targeted Populations

Deep Impact Lending
Deep Impact Lending
Deep Impact Lending
Deep Impact Lending
LMI Borrowers Other Targeted Populations Low-Income Borrowers Mortgage Lending to Other Targeted Populations Rural Communities Urban Low-Income Communities Underserved Communities Minority Communities Persistent Poverty Counties Indian Reservations and Native Hawaiian Homelands U.S. Territories Small Businesses or Farms Underserved Small Businesses Affordable Housing Public Welfare and Community Development Investments1 Community Service Facility Deeply Affordable Housing Public Welfare and Community Development Investments2
(Column A)
# of Originations
(Column B)
$ of Originations
(Column C)
# of Originations
(Column D)
$ of Originations
(Column E)
# of Originations
(Column F)
$ of Originations
(Column G)
# of Originations
(Column H)
$ of Originations
(Column I)
# of Originations
(Column J)
$ of Originations
(Column K)
# of Originations
(Column L)
$ of Originations
(Column M)
# of Originations
(Column N)
$ of Originations
(Column O)
# of Originations
(Column P)
$ of Originations
(Column Q)
# of Originations
(Column R)
$ of Originations
(Column S)
# of Originations
(Column T)
$ of Originations
(Column U)
# of Originations
(Column V)
$ of Originations
(Column W)
# of Originations
(Column X)
$ of Originations
(Column Y)
# of Originations
(Column Z)
$ of Originations
(Column AA)
# of Originations
(Column AB)
$ of Originations
(Column AC)
# of Originations
(Column AD)
$ of Originations
(Column AE)
# of Originations
(Column AF)
$ of Originations
(Column AG)
# of Originations
(Column AH)
$ of Originations
(Column AI)
# of Originations
(Column AJ)
$ of Originations
1 Loans secured by construction, land development, and other land loans 1A
1B $55,000.00 1C
1D $- 1E
1F $- 1G
1H $- 1I
1J $- 1K
1L $- 1M $- 1N $- 1O $- 1P $- 1Q $- 1R $- 1S
1T $- 1U
1V $- 1W
1X $- 1Y
1Z $- 1AA
1AB $- 1AC
1AD $- 1AE
1AF $- 1AG
1AH $- 1AI
1AJ $-
2 Loans secured by farmland 2A
2B $5,000.00 2C
2D $- 2E
2F $- 2G
2H $- 2I
2J $- 2K
2L $- 2M $- 2N $- 2O $- 2P $- 2Q $- 2R $- 2S
2T $- 2U
2V $- 2W
2X $- 2Y
2Z $- 2AA
2AB $- 2AC
2AD $- 2AE
2AF $- 2AG
2AH $- 2AI
2AJ $-
3 Loans secured by 1-4 family residential properties 3A
3B $5,000.00 3C
3D $- 3E
3F $- 3G
3H $- 3I
3J $- 3K
3L $- 3M $- 3N $- 3O $- 3P $- 3Q $- 3R $- 3S
3T $- 3U
3V $- 3W
3X $- 3Y
3Z $- 3AA
3AB $- 3AC
3AD $- 3AE
3AF $- 3AG
3AH $- 3AI
3AJ $-
4 Loans secured by multifamily (5 or more) residential properties 4A
4B $5,000.00 4C
4D $- 4E
4F $- 4G
4H $- 4I
4J $- 4K
4L $- 4M $- 4N $- 4O $- 4P $- 4Q $- 4R $- 4S
4T $- 4U
4V $- 4W
4X $- 4Y
4Z $- 4AA
4AB $- 4AC
4AD $- 4AE
4AF $- 4AG
4AH $- 4AI
4AJ $-
5 Loans secured by nonfarm nonresidential properties 5A
5B $5,000.00 5C
5D $- 5E
5F $- 5G
5H $- 5I
5J $- 5K
5L $- 5M $- 5N $- 5O $- 5P $- 5Q $- 5R $- 5S
5T $- 5U
5V $- 5W
5X $- 5Y
5Z $- 5AA
5AB $- 5AC
5AD $- 5AE
5AF $- 5AG
5AH $- 5AI
5AJ $-
6 Loans to finance agricultural production and other loans to farmers 6A
6B $5,000.00 6C
6D $- 6E
6F $- 6G
6H $- 6I
6J $- 6K
6L $- 6M $- 6N $- 6O $- 6P $- 6Q $- 6R $- 6S
6T $- 6U
6V $- 6W
6X $- 6Y
6Z $- 6AA
6AB $- 6AC
6AD $- 6AE
6AF $- 6AG
6AH $- 6AI
6AJ $-
7 Commercial and industrial loans 7A
7B $5,000.00 7C
7D $- 7E
7F $- 7G
7H $- 7I
7J $- 7K
7L $- 7M $- 7N $- 7O $- 7P $- 7Q $- 7R $- 7S
7T $- 7U
7V $- 7W
7X $- 7Y
7Z $- 7AA
7AB $- 7AC
7AD $- 7AE
7AF $- 7AG
7AH $- 7AI
7AJ $-
8 Loans to individuals for household, family, and other personal expenditures 8A
8B $5,000.00 8C
8D $- 8E
8F $- 8G
8H $- 8I
8J $- 8K
8L $- 8M $- 8N $- 8O $- 8P $- 8Q $- 8R $- 8S
8T $- 8U
8V $- 8W
8X $- 8Y
8Z $- 8AA
8AB $- 8AC
8AD $- 8AE
8AF $- 8AG
8AH $- 8AI
8AJ $-
9 Lease financing receivables 9A
9B $5,000.00 9C
9D $- 9E
9F $- 9G
9H $- 9I
9J $- 9K
9L $- 9M $- 9N $- 9O $- 9P $- 9Q $- 9R $- 9S
9T $- 9U
9V $- 9W
9X $- 9Y
9Z $- 9AA
9AB $- 9AC
9AD $- 9AE
9AF $- 9AG
9AH $- 9AI
9AJ $-
10 Direct and indirect investments in real estate ventures 10A
10B $5,000.00 10C
10D $- 10E
10F $- 10G
10H $- 10I
10J $- 10K
10L $- 10M $- 10N $- 10O $- 10P $- 10Q $- 10R $- 10S
10T $- 10U
10V $- 10W
10X $- 10Y
10Z $- 10AA
10AB $- 10AC
10AD $- 10AE
10AF $- 10AG
10AH $- 10AI
10AJ $-
11 Equity investments without readily determinable fair values 11A
11B $5,000.00 11C
11D $- 11E
11F $- 11G
11H $- 11I
11J $- 11K
11L $- 11M $- 11N $- 11O $- 11P $- 11Q $- 11R $- 11S
11T $- 11U
11V $- 11W
11X $- 11Y
11Z $- 11AA
11AB $- 11AC
11AD $- 11AE
11AF $- 11AG
11AH $- 11AI
11AJ $-
12 Total 12A
12B $5,000.00 12C
12D $- 12E
12F $- 12G
12H $- 12I
12J $- 12K
12L $- 12M $- 12N $- 12O $- 12P $- 12Q $- 12R $- 12S
12T $- 12U
12V $- 12W
12X $- 12Y
12Z $- 12AA
12AB $- 12AC
12AD $- 12AE
12AF $- 12AG
12AH $- 12AI
12AJ $-











































































1 if they primarily benefit LMI Borrowers or communities








































































2 if they primarily benefit Low-Income Borrowers, Minority borrowers, or Minority Businesses








































































Sheet 3: Sch C1 People

Quarterly Supplemental Report (QSR)
Schedule C - Additional Demographic Data for Qualified Lending (People)
ID Lending Activity Categories
People

Deep Impact Lending
LMI Borrowers Other Targeted Populations Mortgage Lending to Other Targeted Populations
50% or Below of AMI 51 - 80% of AMI 81 - 100% of AMI 101 - 120% of AMI Black American Native American Asian American Native Alaskan Native Hawaiian Pacific Islander Hispanic American
(of any race)
Black American Native American Asian American Native Alaskan Native Hawaiian Pacific Islander Hispanic American
(of any race)
(Column A)
# of Originations
(Column B)
$ of Originations
(Column C)
# of Originations
(Column D)
$ of Originations
(Column E)
# of Originations
(Column F)
$ of Originations
(Column G)
# of Originations
(Column H)
$ of Originations
(Column I)
# of Originations
(Column J)
$ of Originations
(Column K)
# of Originations
(Column L)
$ of Originations
(Column M)
# of Originations
(Column N)
$ of Originations
(Column O)
# of Originations
(Column P)
$ of Originations
(Column Q)
# of Originations
(Column R)
$ of Originations
(Column S)
# of Originations
(Column T)
$ of Originations
(Column U)
# of Originations
(Column V)
$ of Originations
(Column W)
# of Originations
(Column X)
$ of Originations
(Column Y)
# of Originations
(Column Z)
$ of Originations
(Column AA)
# of Originations
(Column AB)
$ of Originations
(Column AC)
# of Originations
(Column AD)
$ of Originations
(Column AE)
# of Originations
(Column AF)
$ of Originations
(Column AG)
# of Originations
(Column AH)
$ of Originations
(Column AI)
# of Originations
(Column AJ)
$ of Originations
1 Loans secured by construction, land development, and other land loans
$55,000.00
$55,000.00
$55,000.00
$55,000.00
$55,000.00
$55,000.00
$55,000.00
$55,000.00
$55,000.00
$55,000.00
$55,000.00
$55,000.00
$55,000.00
$55,000.00
$55,000.00
$55,000.00
$55,000.00
$55,000.00
2 Loans secured by farmland
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
3 Loans secured by 1-4 family residential properties
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
4 Loans secured by multifamily (5 or more) residential properties
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
5 Loans secured by nonfarm nonresidential properties
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
6 Loans to finance agricultural production and other loans to farmers
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
7 Commercial and industrial loans
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
8 Loans to individuals for household, family, and other personal expenditures
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
9 Lease financing receivables
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
10 Direct and indirect investments in real estate ventures
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
11 Equity investments without readily determinable fair values
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
12 Total
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00

Sheet 4: Sch C2 Business

Quarterly Supplemental Report (QSR)
Schedule C - Additional Demographic Data for Qualified Lending (Business)
ID Lending Activity Categories
Business
Deep Impact Lending
Underserved Small Businesses
Gross annual revenues that do not exceed $100,000 Majority owned by
Low-Income Borrowers
Majority owned by
Black Americans
Majority owned by
Native Americans
Majority owned by
Asian Americans
Majority owned by
Native Alaskans
Majority owned by
Native Hawaiians
Majority owned by
Pacific Islanders
Majority Owned by Minority Individuals of Multiple Races Majority owned by
Hispanic Americans
(of any race)
(Column A)
# of Originations
(Column B)
$ of Originations
(Column C)
# of Originations
(Column D)
$ of Originations
(Column E)
# of Originations
(Column F)
$ of Originations
(Column G)
# of Originations
(Column H)
$ of Originations
(Column I)
# of Originations
(Column J)
$ of Originations
(Column K)
# of Originations
(Column L)
$ of Originations
(Column M)
# of Originations
(Column N)
$ of Originations
(Column O)
# of Originations
(Column P)
$ of Originations
(Column Q)
# of Originations
(Column R)
$ of Originations
(Column S)
# of Originations
(Column T)
$ of Originations
1 Loans secured by construction, land development, and other land loans
$55,000.00
$55,000.00
$55,000.00
$55,000.00
$55,000.00
$55,000.00
$55,000.00
$55,000.00
$55,000.00
$55,000.00
2 Loans secured by farmland
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
3 Loans secured by 1-4 family residential properties
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
4 Loans secured by multifamily (5 or more) residential properties
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
5 Loans secured by nonfarm nonresidential properties
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
6 Loans to finance agricultural production and other loans to farmers
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
7 Commercial and industrial loans
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
8 Loans to individuals for household, family, and other personal expenditures
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
9 Lease financing receivables
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
10 Direct and indirect investments in real estate ventures
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
11 Equity investments without readily determinable fair values
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
12 Total
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00
$5,000.00

Sheet 5: Sch D1 Rural

Quarterly Supplemental Report (QSR)
Schedule D1 - Add'l Place-Based Data on Qualified Lending (Rural Communities)
ID State
(Column A)
County/County Equivalent (Column B) State and County
FIPS Code (5 digits)
(Column C)
# of Originations
(Column D)
$ of Originations
(Column E)
1



$-
2



$-
3



$-
4



$-
5



$-
6



$-
7



$-
8



$-
9



$-
10



$-
11



$-
12



$-
13



$-
14



$-
15



$-
16



$-
17



$-
18



$-
19



$-
20



$-
21



$-
22



$-
23



$-
24



$-
25



$-
26



$-
27



$-
28



$-
29



$-
30



$-
31



$-
32



$-
33



$-
34



$-
35



$-
36



$-
37



$-
38



$-
39



$-
40



$-
41



$-
42



$-
43



$-
44



$-






* For more information regarding Federal Information Processing Series Codes (FIPS Codes) see: https://www.census.gov/library/reference/code-lists/ansi.html




Schedule D1 requires aggregation of investments up to the County or County Equivalent Level. Report the State and County or County Equivalent.




Example: For Summit County, Colorado report 08117





Sheet 6: Sch D2 Urban

Quarterly Supplemental Report (QSR)
Schedule D2 - Add'l Place-Based Data on Qualified Lending (Urban Low-Income Communities)
ID State
(Column A)
County/County Equivalent (Column B) State/County/Census Tract
FIPS Code (11 digits)
(Column C)*
# of Originations
(Column D)
$ of Originations
(Column E)
1



$-
2



$-
3



$-
4



$-
5



$-
6



$-
7



$-
8



$-
9



$-
10



$-
11



$-
12



$-
13



$-
14



$-
15



$-
16



$-
17



$-
18



$-
19



$-
20



$-
21



$-
22



$-
23



$-
24



$-
25



$-
26



$-
27



$-
28



$-
29



$-
30



$-
31



$-
32



$-
33



$-
34



$-
35



$-
36



$-
37



$-
38



$-
39



$-
40



$-
41



$-
42



$-
43



$-
44



$-






* For more information regarding Federal Information Processing Series Codes (FIPS Codes) see: https://www.census.gov/library/reference/code-lists/ansi.html




Schedule D2 requires aggregation of investments up to census tract level. Use the census tract reference maps located here: https://www.census.gov/geographies/reference-maps/2010/geo/2010-census-tract-maps.html




Example: For a census tract within Summit County, Colorado with a 4.01 census tract, report 08117000401





Sheet 7: Sch D3 Underserved

Quarterly Supplemental Report (QSR)
Schedule D3 - Add'l Place-Based Data on Qualified Lending (Underserved Communities)
ID State
(Column A)
County/County Equivalent (Column B) State/County/Census Tract
FIPS Code (11 digits)
(Column C)*
# of Originations
(Column D)
$ of Originations
(Column E)
1



$-
2



$-
3



$-
4



$-
5



$-
6



$-
7



$-
8



$-
9



$-
10



$-
11



$-
12



$-
13



$-
14



$-
15



$-
16



$-
17



$-
18



$-
19



$-
20



$-
21



$-
22



$-
23



$-
24



$-
25



$-
26



$-
27



$-
28



$-
29



$-
30



$-
31



$-
32



$-
33



$-
34



$-
35



$-
36



$-
37



$-
38



$-
39



$-
40



$-
41



$-
42



$-
43



$-
44



$-






* For more information regarding Federal Information Processing Series Codes (FIPS Codes) see: https://www.census.gov/library/reference/code-lists/ansi.html




Schedule D3 requires aggregation of investments up to census tract level. Use the census tract reference maps located here: https://www.census.gov/geographies/reference-maps/2010/geo/2010-census-tract-maps.html




Example: For a census tract within Summit County, Colorado with a 4.01 census tract, report 08117000401





Sheet 8: Sch D4 Minority

Quarterly Supplemental Report (QSR)
Schedule D4 - Add'l Place-Based Data on Qualified Lending (Minority Communities)
ID State
(Column A)
County/County Equivalent (Column B) State/County/Census Tract
FIPS Code (11 digits)
(Column C)*
# of Originations
(Column D)
$ of Originations
(Column E)
1



$-
2



$-
3



$-
4



$-
5



$-
6



$-
7



$-
8



$-
9



$-
10



$-
11



$-
12



$-
13



$-
14



$-
15



$-
16



$-
17



$-
18



$-
19



$-
20



$-
21



$-
22



$-
23



$-
24



$-
25



$-
26



$-
27



$-
28



$-
29



$-
30



$-
31



$-
32



$-
33



$-
34



$-
35



$-
36



$-
37



$-
38



$-
39



$-
40



$-
41



$-
42



$-
43



$-
44



$-






* For more information regarding Federal Information Processing Series Codes (FIPS Codes) see: https://www.census.gov/library/reference/code-lists/ansi.html




Schedule D4 requires aggregation of investments up to census tract level. Use the census tract reference maps located here: https://www.census.gov/geographies/reference-maps/2010/geo/2010-census-tract-maps.html




Example: For a census tract within Summit County, Colorado with a 4.01 census tract, report 08117000401





Sheet 9: Sch D5 Poverty

Quarterly Supplemental Report (QSR)
Schedule D5 - Add'l Place-Based Data on Qualified Lending (Persistent Poverty Counties)
ID State
(Column A)
County/County Equivalent (Column B) State and County
FIPS Code (5 digits)
(Column C)*
# of Originations
(Column D)
$ of Originations
(Column E)
1



$-
2



$-
3



$-
4



$-
5



$-
6



$-
7



$-
8



$-
9



$-
10



$-
11



$-
12



$-
13



$-
14



$-
15



$-
16



$-
17



$-
18



$-
19



$-
20



$-
21



$-
22



$-
23



$-
24



$-
25



$-
26



$-
27



$-
28



$-
29



$-
30



$-
31



$-
32



$-
33



$-
34



$-
35



$-
36



$-
37



$-
38



$-
39



$-
40



$-
41



$-
42



$-
43



$-
44



$-






* For more information regarding Federal Information Processing Series Codes (FIPS Codes) see: https://www.census.gov/library/reference/code-lists/ansi.html




Schedule D5 requires aggregation of investments up to the County or County Equivalent Level. Report the State and County or County Equivalent.




Example: For Summit County, Colorado report 08117





Sheet 10: Sch D6 Reserv

Quarterly Supplemental Report (QSR)
Schedule D6 - Add'l Place-Based Data on Qualified Lending (Indian Reservations & Native Hawaiian Homelands)
ID American Indian Area Name (Column A) American Indian Area Code
(Column B)
State/County/Census Tract
FIPS Code (11 digits)
(Column C)*
# of Originations
(Column D)
$ of Originations
(Column E)
1



$-
2



$-
3



$-
4



$-
5



$-
6



$-
7



$-
8



$-
9



$-
10



$-
11



$-
12



$-
13



$-
14



$-
15



$-
16



$-
17



$-
18



$-
19



$-
20



$-
21



$-
22



$-
23



$-
24



$-
25



$-
26



$-
27



$-
28



$-
29



$-
30



$-
31



$-
32



$-
33



$-
34



$-
35



$-
36



$-
37



$-
38



$-
39



$-
40



$-
41



$-
42



$-
43



$-
44



$-






A list of American Indian Area Names and Codes is available at the following link: https://www.census.gov/library/reference/code-lists/ansi.html#aia




* For more information regarding Federal Information Processing Series Codes (FIPS Codes) see: https://www.census.gov/library/reference/code-lists/ansi.html




Schedule D6 requires aggregation of investments up to the American Indian Area Code level.




Example: For Allegany Reservation, use Area Code 0080





Sheet 11: Sch D7 Terr or PR

Quarterly Supplemental Report (QSR)
Schedule D7 - Add'l Place-Based Data on Qualified Lending (U.S. Territories or Puerto Rico)
ID U.S. Terr / PR Muni Name (Column A) State/County/Census Tract
FIPS Code (11 digits)
(Column B)*
# of Originations
(Column C)
$ of Originations
(Column D)
1


$-
2


$-
3


$-
4


$-
5


$-
6


$-
7


$-
8


$-
9


$-
10


$-
11


$-
12


$-
13


$-
14


$-
15


$-
16


$-
17


$-
18


$-
19


$-
20


$-
21


$-
22


$-
23


$-
24


$-
25


$-
26


$-
27


$-
28


$-
29


$-
30


$-
31


$-
32


$-
33


$-
34


$-
35


$-
36


$-
37


$-
38


$-
39


$-
40


$-
41


$-
42


$-
43


$-
44


$-





* For more information regarding Federal Information Processing Series Codes (FIPS Codes) see: https://www.census.gov/library/reference/code-lists/ansi.html



Schedule D7 requires aggregation of investments up to census tract level. Use the census tract reference maps located here: https://www.census.gov/geographies/reference-maps/2010/geo/2010-census-tract-maps.html



Example: For a census tract within Arroyo Municipo, Puerto Rico with a 2081.02 census tract, report 72015280102




Sheet 12: Sch D8 Projects

Quarterly Supplemental Report (QSR)
Schedule D8 - Add'l Place-Based Data on Qualified Lending (Projects Benefiting LMI Communities or OTP)
ID Project / Investment Type
(Column A)
State
(Column B)
County Name
(Column C)
State and County
FIPS Code (5 digits)
(Column D)*
# of Originations
(Column E)
$ of Originations
(Column F)
1




$-
2




$-
3




$-
4




$-
5




$-
6




$-
7




$-
8




$-
9




$-
10




$-
11




$-
12




$-
13




$-
14




$-
15




$-
16




$-
17




$-
18




$-
19




$-
20




$-
21




$-
22




$-
23




$-
24




$-
25




$-
26




$-
27




$-
28




$-
29




$-
30




$-
31




$-
32




$-
33




$-
34




$-
35




$-
36




$-
37




$-
38




$-
39




$-
40




$-
41




$-
42




$-
43




$-
44




$-







* For more information regarding Federal Information Processing Series Codes (FIPS Codes) see: https://www.census.gov/library/reference/code-lists/ansi.html





Schedule D8 requires aggregation of investments up to the County or County Equivalent Level. Report the State and County or County Equivalent.





Example: For Summit County Colorado report 08117




File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy