HUD Choice Neighborhoods Implementation Grants - Grants Sizi

Choice Neighborhoods

CN Implementation Grant Sizing Worksheet.xlsx

Choice Neighborhoods

OMB: 2577-0269

Document [xlsx]
Download: xlsx | pdf

Overview

Select City & State
TDC Limit Calculation
Maximum Grant Calculation


Sheet 1: Select City & State

CHOICE NEIGHBORHOODS IMPLEMENTATION GRANTS
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 HUD Notice PIH 2010-20. 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 - multiple -






StateName NORTH CAROLINA














Bedrooms Type Data



Detached / Semi-Detached TDC Limit
per Unit
0 Detached/Semi-Detached Sum of 0 Bedrooms, TDC 115,764


1
Sum of 1 Bedrooms, TDC 150,735


2
Sum of 2 Bedrooms, TDC 180,869


3
Sum of 3 Bedrooms, TDC 217,233


4
Sum of 4 Bedrooms, TDC 256,012


5
Sum of 5 Bedrooms, TDC 280,144


6
Sum of 6 Bedrooms, TDC 303,936


HCC Limit
per Unit
0
Sum of 0 Bedrooms, HCC 66,151


1
Sum of 1 Bedrooms, HCC 86,134


2
Sum of 2 Bedrooms, HCC 103,354


3
Sum of 3 Bedrooms, HCC 124,133


4
Sum of 4 Bedrooms, HCC 146,293


5
Sum of 5 Bedrooms, HCC 160,082


6
Sum of 6 Bedrooms, HCC 173,678


Elevator TDC Limit
per Unit
0 Elevator Sum of 0 Bedrooms, TDC 93,937


1
Sum of 1 Bedrooms, TDC 131,512


2
Sum of 2 Bedrooms, TDC 169,087


3
Sum of 3 Bedrooms, TDC 225,449


4
Sum of 4 Bedrooms, TDC 281,811


5
Sum of 5 Bedrooms, TDC 319,386


6
Sum of 6 Bedrooms, TDC 356,961


HCC Limit
per Unit
0
Sum of 0 Bedrooms, HCC 58,711


1
Sum of 1 Bedrooms, HCC 82,195


2
Sum of 2 Bedrooms, HCC 105,679


3
Sum of 3 Bedrooms, HCC 140,906


4
Sum of 4 Bedrooms, HCC 176,132


5
Sum of 5 Bedrooms, HCC 199,616


6
Sum of 6 Bedrooms, HCC 223,100


Row House TDC Limit
per Unit
0 Row House Sum of 0 Bedrooms, TDC 106,504


1
Sum of 1 Bedrooms, TDC 138,190


2
Sum of 2 Bedrooms, TDC 164,042


3
Sum of 3 Bedrooms, TDC 195,720


4
Sum of 4 Bedrooms, TDC 230,560


5
Sum of 5 Bedrooms, TDC 252,505


6
Sum of 6 Bedrooms, TDC 273,253


HCC Limit
per Unit
0
Sum of 0 Bedrooms, HCC 60,859


1
Sum of 1 Bedrooms, HCC 78,966


2
Sum of 2 Bedrooms, HCC 93,738


3
Sum of 3 Bedrooms, HCC 111,840


4
Sum of 4 Bedrooms, HCC 131,749


5
Sum of 5 Bedrooms, HCC 144,288


6
Sum of 6 Bedrooms, HCC 156,144


Walkup TDC Limit
per Unit
0 Walkup Sum of 0 Bedrooms, TDC 83,995


1
Sum of 1 Bedrooms, TDC 113,858


2
Sum of 2 Bedrooms, TDC 143,432


3
Sum of 3 Bedrooms, TDC 186,267


4
Sum of 4 Bedrooms, TDC 226,737


5
Sum of 5 Bedrooms, TDC 252,781


6
Sum of 6 Bedrooms, TDC 277,528


HCC Limit
per Unit
0
Sum of 0 Bedrooms, HCC 47,997


1
Sum of 1 Bedrooms, HCC 65,061


2
Sum of 2 Bedrooms, HCC 81,961


3
Sum of 3 Bedrooms, HCC 106,438


4
Sum of 4 Bedrooms, HCC 129,564


5
Sum of 5 Bedrooms, HCC 144,447


6
Sum of 6 Bedrooms, HCC 158,588











Sheet 2: TDC Limit Calculation

CHOICE NEIGHBORHOODS IMPLEMENTATION GRANTS

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): GREENSBORO 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): NORTH CAROLINA














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 2010-20.















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



$150,735 $-



2BR



$180,869 $-



3BR



$217,233 $-



4BR



$256,012 $-



5BR



$280,144 $-















Elevator 1BR



$131,512 $-



2BR



$169,087 $-



3BR



$225,449 $-



4BR



$281,811 $-



5BR



$319,386 $-















Row House 1BR



$138,190 $-



2BR



$164,042 $-



3BR



$195,720 $-



4BR



$230,560 $-



5BR



$252,505 $-















Walkup 1BR



$113,858 $-



2BR



$143,432 $-



3BR



$186,267 $-



4BR



$226,737 $-



5BR



$252,781 $-




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



$135,661 $-



2BR



$162,782 $-



3BR



$195,509 $-



4BR



$230,411 $-



5BR



$252,129 $-















Elevator 1BR



$118,361 $-



2BR



$152,178 $-



3BR



$202,904 $-



4BR



$253,630 $-



5BR



$287,447 $-















Row House 1BR



$124,371 $-



2BR



$147,637 $-



3BR



$176,148 $-



4BR



$207,504 $-



5BR



$227,254 $-















Walkup 1BR



$102,472 $-



2BR



$129,089 $-



3BR



$167,641 $-



4BR



$204,064 $-



5BR



$227,503 $-




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. xxx
(exp. Xx/xx/xxxx)













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 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 funding. $-



(from Sources and Uses Budget)




(Note: request for Critical Community Improvements funding may not exceed 15% of total grant requested, as described in part b of the NOFA Secion I.C definition for critical community improvements (i.e. activities to promote economic development, such as development or improvement of transit, retail, community financial institutions, public services, facilities, assets or other community resources).
















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 - %




(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, Commun. Improvmts., 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

$31,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) ($31,000,000))
















Step 14. Enter the amount of your Choice Neighborhoods Implementation Grant request







$-



(If less than maximum allowable grant request, above)


























form HUD-xx (exp. xx)
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy