QSR Template CU

Emergency Capital Investment Program Reporting

QSR_Template_CU.xlsx

Quarterly Supplemental Report Schedules C & D***

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 Non-commercial loans / lines of credit 1A 23 1B $5,780,152.00 1C 10 1D $20,000,000.00 1E 10 1F $10,000,000.00
2 Commercial loans / lines of credit 2A 0 2B $- 2C 0 2D $- 2E 0 2F $-














Sum of Data Uploaded
3 Total 3A 23 3B $5,780,152.00 3C 10 3D $20,000,000.00 3E 10 3F $10,000,000.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 Non-commercial loans / lines of credit 1A
1B $55,000 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 Unsecured credit card loans 2A
2B $5,000 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 Payday alternative loans (PALs I and PALs II) (FCU only) 3A
3B $5,000 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 Non-federally guaranteed student loans 4A
4B $5,000 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 All other unsecured loans/lines of credit 5A
5B $5,000 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 New vehicle loans 6A
6B $5,000 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 Used vehicle loans 7A
7B $5,000 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 Leases receivable 8A
8B $5,000 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 All other secured non-real estate loans / lines of credit 9A
9B $5,000 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 Loans / lines of credit secured by first lien on single 1-4 family res property 10A
10B $5,000 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 Loans / lines of credit secured by junior lien on single 1-4 family res property 11A
11B $5,000 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 All other real estate loans / lines of credit 12A
12B $5,000 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 $-
13 Commercial loans / lines of credit 13A
13B $10,000 13C
13D $- 13E
13F $- 13G
13H $- 13I
13J $- 13K $- 13L $- 13M $- 13N $- 13O $- 13P $- 13Q
13R $- 13S
13T $- 13U
13V $- 13W
13X $- 13Y
13Z $- 13AA
13AB $- 13AC
13AD $- 13AE
13AF $- 13AG
13AH $- 13AI
13AJ $-
14 Commercial loans / lines of credit real estate secured 14A
14B $5,000 14C
14D $- 14E
14F $- 14G
14H $- 14I
14J $- 14K $- 14L $- 14M $- 14N $- 14O $- 14P $- 14Q
14R $- 14S
14T $- 14U
14V $- 14W
14X $- 14Y
14Z $- 14AA
14AB $- 14AC
14AD $- 14AE
14AF $- 14AG
14AH $- 14AI
14AJ $-
15 Commercial loans / lines of credit not real estate secured 15A
15B $5,000 15C
15D $- 15E
15F $- 15G
15H $- 15I
15J $- 15K $- 15L $- 15M $- 15N $- 15O $- 15P $- 15Q
15R $- 15S
15T $- 15U
15V $- 15W
15X $- 15Y
15Z $- 15AA
15AB $- 15AC
15AD $- 15AE
15AF $- 15AG
15AH $- 15AI
15AJ $-
16 Total 16A
16B $65,000 16C
16D $- 16E
16F $- 16G
16H $10,000,000 16I
16J $- 16K $- 16L $- 16M $- 16N $- 16O $- 16P $- 16Q
16R $- 16S
16T $- 16U
16V $- 16W
16X $- 16Y
16Z $- 16AA
16AB $- 16AC
16AD $- 16AE
16AF $- 16AG
16AH $- 16AI
16AJ $-











































































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


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 Non-commercial loans / lines of credit
$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 Unsecured credit card 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
3 Payday alternative loans (PALs I and PALs II) (FCU only)
$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 Non-federally guaranteed student 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
5 All other unsecured loans/lines of credit
$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 New vehicle 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
7 Used vehicle 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 Leases receivable
$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 All other secured non-real estate loans / lines of credit
$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 Loans / lines of credit secured by first lien on single 1-4 family res property
$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 Loans / lines of credit secured by junior lien on single 1-4 family res property
$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 All other real estate loans / lines of credit
$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
13 Commercial loans / lines of credit
$10,000.00
$10,000.00
$10,000.00
$10,000.00
$10,000.00
$10,000.00
$10,000.00
$10,000.00
$10,000.00
$10,000.00
$10,000.00
$10,000.00
$10,000.00
$10,000.00
$10,000.00
$10,000.00
$10,000.00
$10,000.00
14 Commercial loans / lines of credit real estate secured
$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
15 Commercial loans / lines of credit not real estate secured
$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
16 Total
$65,000.00
$65,000.00
$65,000.00
$65,000.00
$65,000.00
$65,000.00
$65,000.00
$65,000.00
$65,000.00
$65,000.00
$65,000.00
$65,000.00
$65,000.00
$65,000.00
$65,000.00
$65,000.00
$65,000.00
$65,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 Non-commercial loans / lines of credit
$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 Unsecured credit card 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
3 Payday alternative loans (PALs I and PALs II) (FCU only)
$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 Non-federally guaranteed student 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 All other unsecured loans/lines of credit
$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 New vehicle 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
7 Used vehicle 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 Leases receivable
$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 All other secured non-real estate loans / lines of credit
$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 Loans / lines of credit secured by first lien on single 1-4 family res property
$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 Loans / lines of credit secured by junior lien on single 1-4 family res property
$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 All other real estate loans / lines of credit
$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
13 Commercial loans / lines of credit
$10,000.00
$10,000.00
$10,000.00
$10,000.00
$10,000.00
$10,000.00
$10,000.00
$10,000.00
$10,000.00
$10,000.00
14 Commercial loans / lines of credit real estate secured
$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
15 Commercial loans / lines of credit not real estate secured
$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
16 Total
$65,000.00
$65,000.00
$65,000.00
$65,000.00
$65,000.00
$65,000.00
$65,000.00
$65,000.00
$65,000.00
$65,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

© 2024 OMB.report | Privacy Policy