*Dummy data provided in Data Upload table below for illustrative purposes. Users will be provided a .csv template and will upload their data in a prior step. | |||||||||
Baseline Qualified Lending | |||||||||
Data Upload* | |||||||||
ID | Lending Activity Categories | Total Originations | Qualified Lending Originations (including Deep Impact Lending Originations) |
||||||
(Column A) # of Originations |
(Column B) $ of Originations |
(Column C) # of Originations |
(Column D) $ of Originations |
||||||
1 | Loans secured by construction, land development, and other land loans | 1A | 23 | 1B | 5780152 | 1C | 10 | 1D | 2457876 |
2 | Loans secured by farmland | 2A | 0 | 2B | 0 | 2C | 0 | 2D | 0 |
3 | Loans secured by 1-4 family residential properties | 3A | 384 | 3B | 115204608 | 3C | 284 | 3D | 70315276 |
4 | Loans secured by multifamily (5 or more) residential properties | 4A | 9 | 4B | 14500000 | 4C | 0 | 4D | 0 |
5 | Loans secured by nonfarm nonresidential properties | 5A | 19 | 5B | 69000000 | 5C | 3 | 5D | 18000000 |
6 | Loans to finance agricultural production and other loans to farmers | 6A | 0 | 6B | 0 | 6C | 0 | 6D | 0 |
7 | Commercial and industrial loans | 7A | 12 | 7B | 25500000 | 7C | 2 | 7D | 10000000 |
8 | Loans to individuals for household, family, and other personal expenditures | 8A | 148 | 8B | 740000 | 8C | 35 | 8D | 75000 |
9 | Lease financing receivables | 9A | 0 | 9B | 0 | 9C | 0 | 9D | 0 |
10 | Direct and indirect investments in real estate ventures | 10A | 0 | 10B | 0 | 10C | 0 | 10D | 0 |
11 | Equity investments without readily determinable fair values | 11A | 0 | 11B | 0 | 11C | 0 | 11D | 0 |
Data Output | |||||||||
12A | Total Originations Reported by Recipient (sum of Column B) | $230,724,760 | |||||||
12B | Total Qualified Lending Reported by Recipient (sum of Column D) | $100,848,152 | |||||||
Recipient Input | |||||||||
13A | Enter the Recipient determination of Baseline Qualified Lending in whole dollars. | ||||||||
13B | Upload a narrative explanation of the metholodogy the Recipient used to generate the data provided in items 1 - 11 to the Supplemental Data tab (see here). | ||||||||
13C | Enter a narrative explanation if amount Recipient entered in item 13A is different than the amount in item 12B. | ||||||||
13D | I, the undersigned CEO or CFO (or equivalents) of the Recipient, attest that this Initial Supplemental Report has been prepared in conformance with the instructions issued by Treasury and is true and correct to the best of my knowledge and belief. | ||||||||
13E | Enter the title of the person certifying this report. | ||||||||
Legend | |||||||||
Input by Recipient | |||||||||
Output by Portal |
File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
File Modified | 0000-00-00 |
File Created | 0000-00-00 |