Spreadsheet: 806e88a9-4275-4abd-bbc1-e016cbac1742
Sheet: Sheet1

RECIPIENT REPORT: GRANT OR LOAN | Unnamed: 1 | Unnamed: 2
PRIME RECIPIENT
REPORTING INFORMATION
1 | Data Element | Tax Credit Assistance Program (TCAP)
2 | Award Type: | Select "Grant"
3 | Award Number: | Enter the Grantee Number provided in box 2 of your Grant Agreement.
4 | Final Report: | Select ‘‘Yes’’ only if this is the final report for the project/grant period specified; otherwise select "No".
AWARD RECIPIENT INFORMATION
5 | Recipient DUNS Number: | Enter the same DUNS that was provided in the TCAP submission to HUD.
6 | Recipient Account Number: | If applicable, enter the account number or any other identifying number assigned by the recipient to the award. This field is optional.
7 | Recipient Congressional District: | Enter the congressional district corresponding to the recipient's DUNS address zip code. (You may search for your Congressional District by visiting http://www.house.gov/. Enter the zip code where the Prime Recipient is located in the search box in the top left corner and the congressional district will be displayed.)
AWARD INFORMATION
8 | Funding Agency Code: | Enter "8600"
9 | Awarding Agency Code: | Enter "8600"
10 | [NAME]: | Enter the award date (Date of Obligation) as found in box 10 of the TCAP Grant Agreement.
11 | Award Amount: | Enter the dollar amount as found in box 7 of the TCAP Grant Agreement.
12 | CFDA Number: | Enter "14.258."
13 | Program Source (TAS): | Select "(86-0203) HOME Investment Partnerships Program"
14 | Sub Account Number for Program Source (TAS): | N/A - HUD does not use TAS sub-account numbers. This field is optional.
15 | Total Number of sub-awards to individuals: | N/A - Sub-awards are not made to individuals.
16 | Total amount of sub-awards to individuals: | N/A - Sub-awards are not made to individuals.
17 | Total number of payments to vendors less than $25,000/award: | Enter the total number of vendors who received awards of less than $25,000/award. Additional guidance regarding who is a vendor is available in OMB's Implementing Guidance for Reports on Use of Funds Pursuant to the American Recovery and Reinvestment Act of 2009 (http://www.recovery.gov/?q=content/recipient-reporting).
18 | Total amount of payments to vendors less than $25,000: | Enter the total dollar value of awards less than $25,000 awarded to vendors.
19 | Total number of sub-awards less than $25,000/award: | Enter the total number of sub-awardees that received a total grant award of  less than $25,000. Additional guidance regarding who is a sub-recipient is available in OMB's Implementing Guidance for Reports on Use of Funds Pursuant to the American Recovery and Reinvestment Act of 2009 (http://www.recovery.gov/?q=content/recipient-reporting).
20 | Total amount of sub-awards less than $25,000: | Enter the total dollar value of awards less than $25,000 awarded to sub-recipients.
21 | Award Description: | Enter "Develop affordable housing."
PROJECT INFORMATION
22 | Project Name: | Enter "Tax Credit Assistance Program (TCAP)"
23 | Project Status: | For formula grants, and other awards funding multiple services and products, recipients need to provide a best estimate of completion status (as a percentage, i.e., 100% complete, 50% complete, less than 50% complete) of all projects or activities supported by the whole grant.  We understand that for formula grants, this will be a rough estimate.  For grants that are distributed by formula to sub-recipients, and then used by the sub-recipients for a variety of expenses, the prime recipient should use the percentage of its award that the prime recipient has drawn down to measure the project status.
24 | Total Federal Amount ARRA Funds Received/Invoiced: | Enter the amount the Prime Recipient has drawn-down. This information is available in IDIS as well.
25 | Number of Jobs: | Please see HUD's guidance regarding job creation.
26 | Description of Jobs Created: | Please see HUD's guidance regarding job creation.
27 | Quarterly Activities/Project Description: | Enter "Objective: To provide affordable housing.  Results: xx number of rental housing will be developed."
28 | Activity Code: (Up to 10 activity codes may be entered) | Enter "L04 - Housing Development, Construction and Management"; and/or "L04.02 - Affordable Housing".
29 | Total Federal Amount of ARRA Expenditure: | Enter the cumulative total amount of expenditures for this grant. Please see OMB's Implementing Guidance for Reports on Use of Funds Pursuant to the American Recovery and Reinvestment Act of 2009 and OMB's Recipient Reporting Data Model for guidance regarding expenditure reporting (http://www.recovery.gov/?q=content/recipient-reporting).
30 | Total Federal ARRA Infrastructure Expenditure: | N/A - Low-Income Housing Tax Credit projects are not considered Infrastructure; therefore this is not applicable.
31 | Infrastructure Contact Name:
32 | Infrastructure Contact Street Address 1:
33 | Infrastructure Contact Street Address 2:
34 | Infrastructure Contact Street Address 3:
35 | Infrastructure Contact City:
36 | Infrastructure Contact State:
37 | Infrastructure Contact Zip Code + 4:
38 | Infrastructure Contact Email:
39 | Infrastructure Contact Phone:
40 | Infrastructure Contact Ext:
41 | Infrastructure Purpose and Rationale: | Enter: "This is not applicable."
PRIMARY PLACE OF PERFORMANCE
42 | Street Address 1: | Enter the Prime Recipient's address as indicated in box 1 of the Grant Agreement, unless the Primary Place of Performance is different.
43 | Street Address 2:
44 | City:
45 | State:
46 | Country:
47 | Zip Code + 4:
48 | Congressional District: | Enter the congressional district corresponding to the recipient's DUNS address zip code if the primary place of performance is not dfferent. (You may search for your Congressional District by visiting http://www.house.gov/. Enter the zip code where the Prime Recipient is located in the search box in the top left corner and the congressional district will be displayed.)
RECIPIENT HIGHLY COMPENSATED OFFICERS
49 | Indication of Reporting Applicability: | See definition of "Recipient Officer Name" as found in OMB's Recipient Reporting Data Model (see page 20 of version 2.0.1 at http://www.recovery.gov/?q=content/recipient-reporting).  If the criteria identified in that definition are met, select "Yes" and report this information for the SEA. If the criteria are not met, select "No".
50 | Prime Recipient Highly Compensated Name (5): | If the criteria are met, report this information for the SEA.
51 | Prime Recipient Highly Compensated Compensation(5): | If the criteria are met, report this information for the SEA.
52 | Government Contracting Office Code:
RECIPIENT REPORT: GRANT OR LOAN
SUB-RECIPIENT
REPORTING INFORMATION
53 | Award Type: | Select "Grant" or "Loan"
54 | Award Number: | This is the Grantee Number provided by HUD to the Prime Recipient. Enter the Grantee Number provided in box 2 of the Prime Recipient's Grant Agreement.  If the subrecipient is reporting directly, this number must be provided to them.
55 | Recipient DUNS No.: | Enter the Prime Recipient's DUNS that was provided in the TCAP submission to HUD.  If the subrecipient is reporting directly, this DUNS number must be provided to the subrecipient.
56 | Final Report: | Select ‘‘Yes’’ only if this is the final report for the project/grant period specified; otherwise select "No".
SUB-RECIPIENT INFORMATION
57 | Sub-recipient DUNS No.: | Enter the sub-recipient’s DUNS number.
58 | Sub-award Number: | Enter the award number or other identifying number assigned to the sub-recipient by the prime recipient.
59 | Sub-recipient Congressional District: | Enter the congressional district corresponding to the Sub-recipient's DUNS address zip code.  (You may search for your Congressional District by visiting http://www.house.gov/. Enter the zip code where the Sub-recipient is located in the search box in the top left corner and the congressional district will be displayed.)
SUB-AWARD INFORMATION
60 | Amount of Sub-award: | Enter the anticipated total amount of funds to be disbursed to the sub-recipient over the life of the award.
61 | Total Sub-award Funds Disbursed: | Enter the cumulative amount of the sub-award disbursed to or by the sub-recipient as of this reporting period.
62 | Sub-award Date: | Enter the date the sub-award was signed.
SUB-RECIPIENT PLACE OF PERFORMANCE
63 | Street Address 1: | Enter the address of the project.  This should be where the LIHTC project is under development.
64 | Street Address 2:
65 | City:
66 | State:
67 | County:
68 | Zip Code + 4:
69 | Congressional District: | Enter the congressional district corresponding to the project under development.  (You may search for your Congressional District by visiting http://www.house.gov/. Enter the zip code where the Sub-recipient is located in the search box in the top left corner and the congressional district will be displayed.)
SUB-RECIPIENT HIGHLY COMPENSATED OFFICERS
70 | Indication of Reporting Applicability: | See definition of "Recipient Officer Name" as found in OMB's Recipient Reporting Data Model (see page 20 of version 2.0.1 at http://www.recovery.gov/?q=content/recipient-reporting).  If the criteria identified in that definition are met, select "yes" and report this information for the LEA. If the criteria are not met, select "No".
71 | Name: | If the criteria are met, enter this information for the LEA.
72 | Compensation: | If the criteria are met, enter this information for the LEA.
RECIPIENT REPORT: GRANT OR LOAN
VENDORS
REPORTING INFORMATION
73 | Award Type: | Select "Grant"
74 | Award Number: | This is the Grantee Number provided by HUD to the prime recipient. Enter the Grantee Number provided in box 2 of the Prime Recipient's Grant Agreement.  If the subrecipient is reporting directly, please provide them with this number.
75 | Recipient DUNS Number: | Enter the Prime Recipient's DUNS for which was provided in the TCAP submission to HUD.  If the subrecipient is reporting directly, this DUNS number must be provided to the subrecipient.
76 | Sub-award Number - Sub-recipient Vendor: | The sub-award number is only required if the vendor is a vendor for a sub-recipient. If the vendor is a vendor for the sub-recipient, enter the award number or other identifying number assigned to the vendor by the sub-recipient.
77 | Vendor [NAME] Number: | Enter the vendor's DUNS number. If this information is not available,  you are required to provide both the vendor name and vendor's headquarter's Zip Code.
78 | Vendor Name: | Enter the vendor's name.
79 | Vendor HQ Zip Code: | Enter the zip code corresponding to the address of the vendor's headquarters.
80 | Product and Service Description: | Enter a description of the product or service provided by the vendor. This field is optional for vendors of sub-recipients.
81 | Payment Amount: | Enter the amount invoiced to the vendor (aggregated) that will be paid with TCAP funds. This field is optional for vendors of sub-recipients.