HUD 53235 CN FY 2014 Implementation Grant Sizing Worksheet

---

Overview

Select City & State
TDC Limit Calculation
Maximum Grant Calculation
Sheet2

---

Sheet 1: Select City & State

CHOICE NEIGHBORHOODS IMPLEMENTATION GRANTS
FY2014 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 on July 7, 2014in accordance with HUD Notice PIH 2011-38. If your City is not shown, contact the HUD Office of Public Housing Investments, (202) 401-8812.
		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.)
				City	COLUMBUS
				StateName	OHIO
			Bedrooms	Type	Data
	Detached / Semi-Detached	TDC Limit per Unit	0	Detached/Semi-Detached	Sum of 0 Bedrooms, TDC	120,169.00
			1		Sum of 1 Bedrooms, TDC	158,153.00
			2		Sum of 2 Bedrooms, TDC	189,655.00
			3		Sum of 3 Bedrooms, TDC	228,595.00
			4		Sum of 4 Bedrooms, TDC	269,383.00
			5		Sum of 5 Bedrooms, TDC	294,505.00
			6		Sum of 6 Bedrooms, TDC	316,966.00
		HCC Limit per Unit	0		Sum of 0 Bedrooms, HCC	68,668.00
			1		Sum of 1 Bedrooms, HCC	90,373.00
			2		Sum of 2 Bedrooms, HCC	108,375.00
			3		Sum of 3 Bedrooms, HCC	130,626.00
			4		Sum of 4 Bedrooms, HCC	153,933.00
			5		Sum of 5 Bedrooms, HCC	168,289.00
			6		Sum of 6 Bedrooms, HCC	181,124.00
	Elevator	TDC Limit per Unit	0	Elevator	Sum of 0 Bedrooms, TDC	101,082.00
			1		Sum of 1 Bedrooms, TDC	141,515.00
			2		Sum of 2 Bedrooms, TDC	181,948.00
			3		Sum of 3 Bedrooms, TDC	242,598.00
			4		Sum of 4 Bedrooms, TDC	303,247.00
			5		Sum of 5 Bedrooms, TDC	343,680.00
			6		Sum of 6 Bedrooms, TDC	384,113.00
		HCC Limit per Unit	0		Sum of 0 Bedrooms, HCC	63,177.00
			1		Sum of 1 Bedrooms, HCC	88,447.00
			2		Sum of 2 Bedrooms, HCC	113,718.00
			3		Sum of 3 Bedrooms, HCC	151,624.00
			4		Sum of 4 Bedrooms, HCC	189,530.00
			5		Sum of 5 Bedrooms, HCC	214,800.00
			6		Sum of 6 Bedrooms, HCC	240,071.00
	Row House	TDC Limit per Unit	0	Row House	Sum of 0 Bedrooms, TDC	113,542.00
			1		Sum of 1 Bedrooms, TDC	149,767.00
			2		Sum of 2 Bedrooms, TDC	180,027.00
			3		Sum of 3 Bedrooms, TDC	218,050.00
			4		Sum of 4 Bedrooms, TDC	259,306.00
			5		Sum of 5 Bedrooms, TDC	285,948.00
			6		Sum of 6 Bedrooms, TDC	310,976.00
		HCC Limit per Unit	0		Sum of 0 Bedrooms, HCC	64,881.00
			1		Sum of 1 Bedrooms, HCC	85,581.00
			2		Sum of 2 Bedrooms, HCC	102,872.00
			3		Sum of 3 Bedrooms, HCC	124,600.00
			4		Sum of 4 Bedrooms, HCC	148,175.00
			5		Sum of 5 Bedrooms, HCC	163,399.00
			6		Sum of 6 Bedrooms, HCC	177,701.00
	Walkup	TDC Limit per Unit	0	Walkup	Sum of 0 Bedrooms, TDC	94,561.00
			1		Sum of 1 Bedrooms, TDC	130,623.00
			2		Sum of 2 Bedrooms, TDC	165,671.00
			3		Sum of 3 Bedrooms, TDC	216,362.00
			4		Sum of 4 Bedrooms, TDC	269,719.00
			5		Sum of 5 Bedrooms, TDC	303,634.00
			6		Sum of 6 Bedrooms, TDC	337,075.00
		HCC Limit per Unit	0		Sum of 0 Bedrooms, HCC	54,035.00
			1		Sum of 1 Bedrooms, HCC	74,642.00
			2		Sum of 2 Bedrooms, HCC	94,669.00
			3		Sum of 3 Bedrooms, HCC	123,636.00
			4		Sum of 4 Bedrooms, HCC	154,125.00
			5		Sum of 5 Bedrooms, HCC	173,505.00
			6		Sum of 6 Bedrooms, HCC	192,615.00

---

Sheet 2: TDC Limit Calculation

CHOICE NEIGHBORHOODS IMPLEMENTATION GRANTS
FY2014 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):				COLUMBUS	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).
	(c) Confirm correct State (selected in Step 2):				OHIO
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)
	BUILDING TYPE	BR's	Number of Units	HCC Limit per Unit	HCC Totals	Community Renewal Allowance Total	TDC Limit per Unit for New Const.	TDC Limit Totals
	Detached / Semi-Detached	1BR					$158,153	$-
		2BR					$189,655	$-
		3BR					$228,595	$-
		4BR					$269,383	$-
		5BR					$294,505	$-
	Elevator	1BR					$141,515	$-
		2BR					$181,948	$-
		3BR					$242,598	$-
		4BR					$303,247	$-
		5BR					$343,680	$-
	Row House	1BR					$149,767	$-
		2BR					$180,027	$-
		3BR					$218,050	$-
		4BR					$259,306	$-
		5BR					$285,948	$-
	Walkup	1BR					$130,623	$-
		2BR					$165,671	$-
		3BR					$216,362	$-
		4BR					$269,719	$-
		5BR					$303,634	$-
		Subtotal New Units:	0
		Table 6(b): REHABILITATION UNITS (existing public and/or assisted housing units to be rehabilitated)*
	BUILDING TYPE	BR's	Number of Units	HCC Limit per Unit	HCC Totals	Comm Renewal Allowance Total	TDC Limit per Unit for Rehab*	TDC Limit Totals
	Detached / Semi-Detached	1BR					$142,338	$-
		2BR					$170,690	$-
		3BR					$205,736	$-
		4BR					$242,445	$-
		5BR					$265,055	$-
	Elevator	1BR					$127,364	$-
		2BR					$163,753	$-
		3BR					$218,338	$-
		4BR					$272,922	$-
		5BR					$309,312	$-
	Row House	1BR					$134,790	$-
		2BR					$162,024	$-
		3BR					$196,245	$-
		4BR					$233,375	$-
		5BR					$257,353	$-
	Walkup	1BR					$117,561	$-
		2BR					$149,104	$-
		3BR					$194,726	$-
		4BR					$242,747	$-
		5BR					$273,271	$-
		Subtotal Rehab Units:	0
6(c)	Totals for all New and Rehabilitation Units		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.

---

Sheet 3: Maximum Grant Calculation

OMB Approval No. 2577-0269 (exp. 1/31/2015)

FY2014 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).

---

Sheet 4: Sheet2

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