{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["HUD 52860-B","Locality Finder"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"HUD 52860-B","index":0,"n_rows":106,"n_cols":7,"rows_kept":106,"cut":false,"hidden":false,"merged":[[63,0,63,4],[65,0,65,4],[67,0,67,4],[69,0,69,4],[9,0,9,1],[10,2,10,3],[58,0,58,4],[9,3,9,4],[66,0,66,4],[5,0,5,7],[7,0,7,7],[61,0,61,4],[15,0,15,4],[60,0,60,4],[48,0,48,3],[49,0,49,3],[51,0,51,3],[59,0,59,4]],"flags":["formulas_cached_only"]}
[]
["Total Development Cost (TDC)",null,null,"U.S. Department of Housing","OMB Approval No. 2577-0075"]
["and Rehab Cost Estimate Addendum ",null,null,"and Urban Development","(exp. 08/31/2023)"]
["HUD-52860-B",null,null,"Office of Public and Indian Housing"]
[]
[]
[]
[" Public reporting burden for this collection of information is estimated to average 1 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.  Comments regarding the accuracy of this burden estimate and any suggestions for reducing this burden can be sent to the Reports Management Officer, Office of Policy Development and Research, REE, Department of Housing and Urban Development, 451 7th St SW, Room 4176, Washington, DC 20410-5000.  When providing comments, please refer to OMB Approval No. 2577-0075. 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. Do not send this form to the above address. \nThis information is required as a supplement to the HUD-52860 for all SAC applications that propose a demolition based on physical obsolescence under 24 CFR 970.15 or a disposition under 24 CFR 970.17 based on physical obsolescence.  HUD will use this information to determine whether, and under what circumstances, to approve SAC applications as well as to track removals for other record keeping requirements. Please refer to the instructions for guidance on completing this form. The information requested does not lend itself to confidentiality. There is no personal information contained in this application. Information on activities and expenditures of grant funds is public information and is generally available for disclosure. Recipients are responsible for ensuring confidentiality when disclosure is not required. In accordance with the Paperwork Reduction Act. The information collected will not be held confidential."]
[" "]
["1.  SAC Application Number in IMS/PIC ",null,"DDA","_____________________________"]
["   Project (AMP) Name & Number in IMS/PIC",null,"         ____________________________________"]
[]
["2. Total Development Cost (TDC) Calculation"]
["    Based on HUD Notice PIH-2011-38 or subsequent notices",null,"Year:","20_______  ","For Locality _____________________"]
[]
["Complete the calculations below for the units (dwelling buildings) proposed for demolition and/or disposition based on physical obsolescence:  "]
[]
["Size - Type","Number of units","Times","TDC Per Unit                                      ","= TDC"]
["0 - Bdr Detached and Semi detached",0,"X",0,0]
["0 -  Bdr Row Dwelling",null,"X",null,0]
["0 -  Bdr Walk-Up",null,"X",null,0]
["0 -  Bdr elevator",null,"X",null,0]
["1 -  Bdr Detached and Semi detached",null,"X",null,0]
["1 -  Bdr Row Dwelling",null,"X",null,0]
["1 -  Bdr Walk-Up",null,"X",null,0]
["1 -  Bdr elevator",null,"X",null,0]
["2 -  Bdr Detached and Semi detached",null,"X",null,0]
["2 -  Bdr Row Dwelling",null,"X",null,0]
["2 -  Bdr Walk-Up",null,"X",null,0]
["2 -  Bdr elevator",null,"X",null,0]
["3 -  Bdr Detached and Semi detached",null,"X",null,0]
["3 -  Bdr Row Dwelling",null,"X",null,0]
["3 -  Bdr Walk-Up",null,"X",null,0]
["3 -  Bdr Elevator",null,"X",null,0]
["4 -  Bdr Detached and Semi detached",null,"X",null,0]
["4 -  Bdr Row Dwelling",null,"X",null,0]
["4 -  Bdr Walk-Up",null,"X",null,0]
["4 -  Bdr Elevator",null,"X",null,0]
["5 -  Bdr Detached and Semi detached",null,"X",null,0]
["5 -  Bdr Row Dwelling",null,"X",null,0]
["5 -  Bdr Walk-Up",null,"X",null,0]
["5 -  Bdr Elevator",null,"X",null,0]
["6 -  Bdr Detached and Semi detached",null,"X",null,0]
["6 -  Bdr Row Dwelling",null,"X",null,0]
["6 -  Bdr Walk-Up",null,"X",null,0]
["6 -  Bdr Elevator",null,"X",null,0]
["Total Units",0,null,null,0]
[]
["3.  Estimated Cost of Rehabilitation"]
["          Attach a document showing rehabalition needs by line item and dollar amount"]
[]
["4.   Rehabilitation Cost %  (estimated cost of Rehabilitation/Total TDC) x 100 = ",null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[]
["                                                                                       "]
["Provide attachments as needed.  All attachments                                                                                     "]
["must reference the Section and line number to which they apply",null,null,"Page 1 of 2","form HUD-52860-B (04/2018)"]
["Previous versions obsolete"]
[]
["Instructions Form HUD-52860-B \n\n"]
["Refer to SAC website at www.hud.gov/sac for more information"]
["PHAs proposing to demolish or dispose of public housing developments based on physical obsolosecence under 24 CFR part 970 must complete this HUD-52860-B in order to demonstrate to HUD that no reasonable program of modification is cost-effective to return the development to their useful life.  "]
["Item 1: Insert the number of the PIH Notice from which the PHA extracted the Total Development Cost (TDC) data.  The year of the PIH Notice should coincide with the year the rehabilitation estimate  was generated, which should not be more than two years prior to the SAC application submission date.  Insert the name of the nearest locality to the proposed developments."]
[]
["Item 2:  TDC Calculation: Complete the TDC calculation for the proposed developments."]
[]
["Item 3: Rehabilitation Calculation:  Attach an excel document showing rehabilitation needs by line item and dollar amount for the proposed developments in accordance with 24 CFR 970.15 and PIH Notice 2021-07 (or any replacement notice).  Soft costs associated with the rehabilitation (e.g. construction contingency, architectural/engineer’s design and construction monitoring fees; profit & overhead fees for specialty sub-contractor; general condition fees; and PHA administrative costs) should all be listed as separate line items.  Certain costs may require additional third-party documentation.  "]
["In accordance with 24 CFR 905.314(g), PHAs are permitted to rehabilitate and address the capital needs of projects provided the rehabilitation costs do not exceed 90% of total development cost TDC. Accordingly, per 24 CFR 970.15(b)(2), if a project’s rehabilitation costs are between 57.14% (or 62.5% if elevator) and 90% of TDC, the PHA may either voluntarily pursue a demolition or disposition action for the project or may rehabilitate the project with Capital Funds. However, if rehabilitation costs for a project exceed 90% of TDC, the PHA’s only choice is to pursue a demolition or disposition or use funds other than Capital Funds to address the project’s capital needs."]
{"$rows_empty":33}
["                                                                                         "]
[{"$nulls":4}," "]
["Provide attachments as needed.  All attachments                                                                                     "]
["must reference the Section and line number to which they apply",null,null,"Page 2 of 2","form HUD-52860-B (04/2018)"]
["Previous versions obsolete"]
[{"$nulls":4}," "]

{"sheet":"Locality Finder","index":1,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,2,0,3],[1,0,8,0],[9,0,13,0]],"flags":["formulas_cached_only"]}
["Region 1",null,"Region 2",null,"Region 3","Region 4","Region 5","Region 6","Region 7","Region 8","Region 9","Region 10"]
["Connecticut","Bridgeport"]
[null,"Hartford"]
[null,"Meriden"]
[null,"New Britain"]
[null,"New Haven"]
[null,"New London"]
[null,"Stamford"]
[null,"Waterbury"]
["Maine","Augusta"]
[null,"Bangor"]
[null,"Lewiston"]
[null,"Portland"]
[null,"Waterville"]
["…"]