HUD-53235 Choice Neighborhoods Implementation Grants - FY 2017 Gra

CHOICE NEIGHBORHOODS IMPLEMENTATION GRANTS
FY2017 Grant Sizing Worksheet
FOLLOW THE STEP-BY-STEP INSTRUCTIONS

Page 1

Note: If completing attachment manually, rather than using the Excel workbook, start at Step 4 (page 2).
Step 1.

Select your City from the menu below.
Click as indicated to see the lists of cities, scroll through the list, click on your City, and click "OK."

Step 2.

Repeat Step 1 to select your State from the menu below.
Click as indicated to see the lists of states, scroll through the list, click on your State, and click "OK."
This table includes all Total Development Cost (TDC) dollar limits published in February 2017 in accordance with PIH Notice 2011-38.
https://portal.hud.gov/hudportal/documents/huddoc?id=tdcs_2017.pdf
If your City is not shown, send an email to ChoiceNeighborhoods@hud.gov.
If you have selected a valid City/State combination, a table will be created that extends down to row 82. The TDC limits for each unit type
shown on this table will be transferred automatically to the table on the next worksheet, "TDC Limit Calculation."

Step 3.

After selecting the appropriate City and State, go to Step 4, page 2. (If using the Excel file,
click on the worksheet tab entitled "TDC Limit Calculation" at the bottom of this window.)

TDC Limit
per Unit
Detached /
SemiDetached
HCC Limit
per Unit

TDC Limit
per Unit

Elevator

HCC Limit
per Unit

TDC Limit
per Unit

Row House

HCC Limit
per Unit

TDC Limit
per Unit

Walkup

HCC Limit
per Unit

Bedrooms
0
1
2
3
4
5
6
0
1
2
3
4
5
6
0
1
2
3
4
5
6
0
1
2
3
4
5
6
0
1
2
3
4
5
6
0
1
2
3
4
5
6
0
1
2
3
4
5
6
0
1
2
3
4
5
6

StateName
City

ALABAMA
BIRMINGHAM

<-- Select your City from list here
<-- Select your State from list here

Type
Detached/Semi-Detached

Data
Sum of 0 Bedrooms, TDC
Sum of 1 Bedrooms, TDC
Sum of 2 Bedrooms, TDC
Sum of 3 Bedrooms, TDC
Sum of 4 Bedrooms, TDC
Sum of 5 Bedrooms, TDC
Sum of 6 Bedrooms, TDC
Sum of 0 Bedrooms, HCC
Sum of 1 Bedrooms, HCC
Sum of 2 Bedrooms, HCC
Sum of 3 Bedrooms, HCC
Sum of 4 Bedrooms, HCC
Sum of 5 Bedrooms, HCC
Sum of 6 Bedrooms, HCC
Sum of 0 Bedrooms, TDC
Sum of 1 Bedrooms, TDC
Sum of 2 Bedrooms, TDC
Sum of 3 Bedrooms, TDC
Sum of 4 Bedrooms, TDC
Sum of 5 Bedrooms, TDC
Sum of 6 Bedrooms, TDC
Sum of 0 Bedrooms, HCC
Sum of 1 Bedrooms, HCC
Sum of 2 Bedrooms, HCC
Sum of 3 Bedrooms, HCC
Sum of 4 Bedrooms, HCC
Sum of 5 Bedrooms, HCC
Sum of 6 Bedrooms, HCC
Sum of 0 Bedrooms, TDC
Sum of 1 Bedrooms, TDC
Sum of 2 Bedrooms, TDC
Sum of 3 Bedrooms, TDC
Sum of 4 Bedrooms, TDC
Sum of 5 Bedrooms, TDC
Sum of 6 Bedrooms, TDC
Sum of 0 Bedrooms, HCC
Sum of 1 Bedrooms, HCC
Sum of 2 Bedrooms, HCC
Sum of 3 Bedrooms, HCC
Sum of 4 Bedrooms, HCC
Sum of 5 Bedrooms, HCC
Sum of 6 Bedrooms, HCC
Sum of 0 Bedrooms, TDC
Sum of 1 Bedrooms, TDC
Sum of 2 Bedrooms, TDC
Sum of 3 Bedrooms, TDC
Sum of 4 Bedrooms, TDC
Sum of 5 Bedrooms, TDC
Sum of 6 Bedrooms, TDC
Sum of 0 Bedrooms, HCC
Sum of 1 Bedrooms, HCC
Sum of 2 Bedrooms, HCC
Sum of 3 Bedrooms, HCC
Sum of 4 Bedrooms, HCC
Sum of 5 Bedrooms, HCC
Sum of 6 Bedrooms, HCC

Total

Elevator

Row House

Walkup

131,507
171,897
208,385
254,359
299,148
326,634
351,096
75,147
98,227
119,077
145,348
170,942
186,648
200,627
107,090
149,927
192,763
257,017
321,271
364,107
406,943
66,931
93,704
120,477
160,636
200,794
227,567
254,340
120,991
158,237
192,166
235,450
279,125
307,157
333,344
69,138
90,421
109,809
134,543
159,500
175,518
190,482
105,208
145,440
184,615
241,388
300,849
338,766
376,157
60,119
83,109
105,494
137,936
171,914
193,581
214,947
(HUD-53235)

CHOICE NEIGHBORHOODS IMPLEMENTATION GRANTS
FY2017 Grant Sizing Worksheet
Page 2
Step 4. Enter name of the Lead Applicant:
Step 5. (a) Enter name of targeted public and/or assisted hsg site(s):
(b) Confirm correct City (selected in Step 1):
(c) Confirm correct State (selected in Step 2):

ALABAMA
BIRMINGHAM

Note: If the selected City or State is wrong, return to Page 1, Steps 1 and 2, to correct your
selections (navigate back to Step 1 by clicking on "Select City & State" tab below).

Step 6. In the appropriate "BUILDING TYPE' and bedroom ("BR") categories below, enter the number of
"NEW UNITS" (use Table 6(a)), and/or "REHABILITATION UNITS" (use Table 6(b)), proposed for funding under this application.
The Excel form will calculate TDC limit subtotals for each unit type, and overal TDC limit totals, based on City and State selected at Steps 1 and 2.
If you are completing this attachment manually, use the applicable TDC limits for each unit type found in HUD Notice PIH 2011-38.

Definitions
NEW UNITS (Table 6(a)): include all on-site and off-site replacement units. Also include any homeownership units (including lease-purchase), that will be newly-constructed or acquired (with or
without rehabilitation) utilizing any Choice Neighborhoods grant funds or other public housing capital assistance for development.
REHABILITATION UNITS (Table 6(b)): include only existing (i.e, in HUD's inventory) public housing and/or assisted units that are proposed for rehabilitation utilizing Choice Neighborhoods grant
funds or other public housing capital assistance.

Building Types
Detached buildings are single-family dwellings.
Semi-Detached buildings, also referred to as "duplex" units, are structures that include only two units.
Elevator buildings include only those structures with an elevator and four or more floors above ground.
Row House refers to any structure with three or more units that has only vertical common walls.
If a building with three or more units has upper/lower units (and is not an elevator building), it is classified as a Walkup.
Walkup buildings include all structures with three or more units that are not classified as Elevator or Row House.

Table 6(a): NEW UNITS (new construction, acquisition, and units to be acquired and rehabilitated)
Number
of Units

HCC Limit
per Unit

HCC
Totals

Community Renewal
Allowance Total

TDC Limit per Unit
for New Const.

TDC Limit
Totals

BUILDING
TYPE

BR's

Detached / SemiDetached

1BR
2BR
3BR
4BR
5BR

$
$
$
$
$

171,897
208,385
254,359
299,148
326,634

$
$
$
$
$

-

Elevator

1BR
2BR
3BR
4BR
5BR

$
$
$
$
$

149,927
192,763
257,017
321,271
364,107

$
$
$
$
$

-

Row House

1BR
2BR
3BR
4BR
5BR

$
$
$
$
$

158,237
192,166
235,450
279,125
307,157

$
$
$
$
$

-

$
$
$
$
$

145,440
184,615
241,388
300,849
338,766

$
$
$
$
$

-

1BR
2BR
3BR
Walkup
4BR
5BR
Subtotal New Units:

0
Table 6(b): REHABILITATION UNITS (existing public and/or assisted housing units to be rehabilitated)*
HCC Limit
per Unit

Comm Renewal
Allowance Total

TDC Limit per Unit
for Rehab*

TDC Limit
Totals

BR's

Detached / SemiDetached

1BR
2BR
3BR
4BR
5BR

$
$
$
$
$

154,707
187,547
228,923
269,233
293,970

$
$
$
$
$

-

Elevator

1BR
2BR
3BR
4BR
5BR

$
$
$
$
$

134,934
173,486
231,315
289,144
327,697

$
$
$
$
$

-

Row House

1BR
2BR
3BR
4BR
5BR

$
$
$
$
$

142,413
172,950
211,905
251,212
276,441

$
$
$
$
$

-

$
$
$
$
$

130,896
166,153
217,249
270,764
304,889

$
$
$
$
$

-

$

-

1BR
2BR
3BR
Walkup
4BR
5BR
Subtotal Rehab Units:
6(c)

Number
of Units

BUILDING
TYPE

Totals for all New and Rehabilitation
Units

HCC Totals

0
0

* TDC limits shown for Rehabilitation Units are 90% of the TDC limit for New Construction Units. If rehabilitation activity will change the number of units or the unit
configuration (Building Types or number of Bedrooms) at the original project site, enter the number and configuration of units that will exist after rehabilitation, not the number
of units and unit configuration before rehabilitation.
(HUD-53235)

OMB Approval No. 2577-0269
(exp. 4/30/2018)
Public Reporting Burden for this collection of information is estimated to average one hour per response, including the time for reviewing instructions, searching existing data sources,
gathering and maintaining the data needed, and completing and reviewing the collection of information. Response to this collection of information is mandatory to obtain a benefit. The
information requested does not lend itself to confidentiality. HUD may not conduct or sponsor, and an applicant is not required to respond to a collection of information unless it displays a
currently valid OMB control number.

CHOICE NEIGHBORHOODS IMPLEMENTATION GRANTS

FY2017 Grant Sizing Worksheet
COMPLETE THIS WORKSHEET LAST

Page 3
To determine the maximum grant amount that may be requested in this Choice Neighborhoods Implementation application, enter the
requested information. If you are using the Excel form, totals are calculated automatically.
If you are manually calculating the maximum grant amount that may be requested on this attachment, follow the calculation instructions
provided below on this worksheet.

6(d) TDC limit, unadjusted (entered automatically from "TDC Limit Calculation")

$

-

$

-

$

-

$

-

$

-

$

-

(To calculate manually, enter the TDC Limit Total for all New and Rehabilitation Units from line 6(c), page 2)

Step 7. Enter Choice Neighborhoods request for Supportive Services (SS) funding.
(from Sources and Uses Budget)
(Note: request for Supportive Services funding may not exceed 15% of total grant requested. Any amount requested above 5% of
grant must be matched by other sources.)

Step 8. Enter Choice Neighborhoods request for Critical Commumity Improvements (CCI) funding.
(from Sources and Uses Budget)

(Note: request for Critical Community Improvements funding may not exceed 15% of total grant requested)

$

Step 9. Enter Choice Neighborhoods funds requested for demolition and remediation of dwelling units.

-

(Enter the combined total of the dwelling unit remediation and dwelling unit demolition line items from
the Sources and Uses Budget)

-

Step 10. Enter number of public and/or assisted units to be demo'd (after date of application only).
Step 11. Enter number of public and/or assisted units to be built back on the original site.

- )

(

(Do not include existing public and/or assisted units to be rehabilitated)

-

11(a) Number of public and/or assisted units to be demolished and not replaced back on original site
(Number of units identified in Step 10, minus the number of units identified in Step 11)

11(b) Percent of original public and/or assisted units to be demo'd & not replaced back on orig. site

#DIV/0! %

(Number of units identified in 11(a), divided by number of units identified in Step 10)
Example: Step 10 = 100 units to be demolished. Step 11 = 40 replacement units to be built back on original site.
11(a) = 60 units demolished and not built back on original site. 11(b) = 60/100 = 60%

11(c) Demo/abatement costs attributable to units to be demolished and not replaced on orig. site
(Dollar amount identified in Step 9, multiplied by percentage identified in 11(b))

Step 12. Enter Choice Neighborhoods request for "extraordinary site costs" (certified by architect or engineer).
12(a) Subtotal: TDC limit, adjusted (for SS, CCI, abatement/demo, & extraord. site costs)
(Total of amounts above: 6(d) + Step 7 + Step 8 + Step 11(c) + Step 12)

Step 13. Enter all other HUD PH capital assistance proposed for Choice Neighborhoods development.

( $

- )

(Include any project funds from the following sources: Public Housing Capital Funds or Mod funds (e.g., CIAP or CGP funds);
Public Housing Development grants; previously-awarded HOPE VI demolition-only grants; and any borrowed funds secured by
Capital Funds (from Sources and Uses Budget))

13(a) Subtotal: Adjusted maximum allowable grant, after accounting for additional capital assistance

$

-

$

-

$

-

(Total of Subtotal in 11(a), minus amount identified in Step 12)

13(b) Maximum allowable Choice Neighborhoods Implementation Grant

$30,000,000

(In accordance with provisions of the HUD Choice Neighborhoods Notice of Funding Availability).

13(c) Maximum allowable Choice Neighborhoods Implementation Grant request
(The lesser of 13(a) (adjusted max. possible grant), and 13(b) ($30,000,000))

Step 14. Enter the amount of your Choice Neighborhoods Implementation Grant request
(If less than maximum allowable grant request, above)
(Note: The maximum for CN Planning Grantees must be reduced, in accordance with the NOFA).

(HUD-53235)

Cross Tab
Region Order
RegionLabel
StateName
StateAbbrev
City
SortOrder
Type
0 Bedrooms, HCC
0 Bedrooms, TDC
1 Bedrooms, HCC
1 Bedrooms, TDC
2 Bedrooms, HCC
2 Bedrooms, TDC
3 Bedrooms, HCC
3 Bedrooms, TDC
4 Bedrooms, HCC
4 Bedrooms, TDC
5 Bedrooms, HCC
5 Bedrooms, TDC
6 Bedrooms, HCC
6 Bedrooms, TDC

2017 Test-sheet
Region Order
Region Order
RegionLabel
RegionLabel
StateName
StateName
StateAbbrev
StateAbbrev
City
City
SortOrder
SortOrder
Type
Type
0 Bedrooms, HCC
0 Bedrooms, HCC
0 Bedrooms, TDC
0 Bedrooms, TDC
1 Bedrooms, HCC
1 Bedrooms, HCC
1 Bedrooms, TDC
1 Bedrooms, TDC
2 Bedrooms, HCC
2 Bedrooms, HCC
2 Bedrooms, TDC
2 Bedrooms, TDC
3 Bedrooms, HCC
3 Bedrooms, HCC
3 Bedrooms, TDC
3 Bedrooms, TDC
4 Bedrooms, HCC
4 Bedrooms, HCC
4 Bedrooms, TDC
4 Bedrooms, TDC
5 Bedrooms, HCC
5 Bedrooms, HCC
5 Bedrooms, TDC
5 Bedrooms, TDC
6 Bedrooms, HCC
6 Bedrooms, HCC
6 Bedrooms, TDC
6 Bedrooms, TDC