{"text_format":"2","workbook":"xls","n_sheets":12,"sheets":["Instructions","Unit Mix","Select City & State","Match Resources","MS Area Rejuv Resources","Constr S&U p1","Constr S&U p2","Constr S&U p3","Permanent S&U p1","Permanent S&U p2","Permanent S&U p3","TDC Limit calculations"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":13,"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":"Instructions","index":0,"n_rows":93,"n_cols":16,"rows_kept":93,"cut":false,"hidden":false,"merged":[[84,2,84,14],[78,2,78,14],[56,2,56,11],[83,2,83,14],[79,2,79,14],[14,2,14,14],[12,2,12,14],[53,2,53,14],[21,2,21,14],[22,2,22,14],[24,2,24,14],[16,2,16,14],[17,2,17,14],[19,2,19,14],[45,2,45,14],[28,2,28,14],[47,2,47,14],[49,2,49,14],[50,2,50,14],[31,2,31,14],[11,2,11,14],[7,10,10,14],[0,0,0,5],[0,7,0,10],[0,12,0,16],[5,2,5,14],[2,0,2,16],[7,3,7,9],[8,3,8,8],[9,3,9,8],[15,2,15,14],[74,2,74,14],[70,2,70,14],[80,2,80,14],[58,2,58,14],[57,2,57,14],[54,2,54,14],[29,2,29,14],[52,2,52,14],[25,2,25,14],[82,2,82,14],[77,2,77,14],[20,2,20,14],[73,2,73,14],[76,2,76,14],[68,2,68,14],[69,2,69,14],[72,2,72,14],[26,2,26,14],[27,2,27,14],[40,2,40,14],[41,2,41,14],[62,2,62,14],[81,2,81,14],[64,2,64,14],[65,2,65,14],[66,2,66,14],[32,2,32,15],[33,2,33,15],[35,2,35,15],[42,2,42,14],[43,2,43,14],[60,2,60,14],[61,2,61,14]],"flags":["formulas_cached_only"]}
["HOPE VI Main Street\nApplication Data Sheet",{"$nulls":6},"U.S. Department of Housing\nand Urban Development\nOffice of Public and Indian Housing\nOffice of Urban Revitalization",{"$nulls":4}," OMB Approval No. 2577-0208\n (exp. XX/XXXX)"]
[]
[]
[]
[]
[null,null,"Instructions: HOPE VI Main Street Application Data Sheet"]
[]
[null,null,"Tips: ","Enter information only into cells with blue borders."]
[null,null,"  ","All other cells are locked, and all calculations are automated. "]
[null,null," ","Print these Instructions for easy reference, then begin at Step 1."]
[]
[]
[null,null,"Step 1.  On the \"Unit Mix\" Page, Enter Your Applicant Local Government Name and the Name of the Main Street Area."]
[]
[null,null,"Step 2.  On the \"Unit Mix\" Page, Enter the Number of Each Type and Size of the Affordable Units that are Going to be Developed\nas part of the Main Street Affordable Housing Project Funded through this NOFA."]
[null,null,"> Select the appropriate column(s) for the proposed units based on structure type, size and development method.  "]
[null,null,"•  Rent-to-Own units are to be counted as Rental Units."]
[null,null,"•  Possible development methods are Rehabilitation (of uninhabitable housing already owned by the applicant or partner owner entity only) or \nNew Construction (which includes acquisition of commercial space or uninhabitable housing)."]
[]
[null,null,"> Enter the number of units proposed, by Structure Type, in the appropriate row based on the Number of Bedrooms. "]
[null,null,"•  TDC limit applies to all Main Street affordable housing project units where HOPE VI Main Street grant funds will be used for development."]
[null,null,"•  The TDC limit for rehabilitation of existing housing units is 90% of the published TDC limit for a given structure and unit type."]
[null,null,"-  The \"TDC Limit calculations\" worksheet reflects all such applicability as described above."]
[]
[null,null,"•  Definitions of the structure types specified on the Unit Mix worksheet:"]
[null,null,"-  Detached:  A structure that consists of a single living unit surrounded by permanent open space on all sides."]
[null,null,"-  Semi-detached:  A structure containing two living units separated by a common vertical wall."]
[null,null,"-  Elevator:  Any structure of four or more stories above ground in which an elevator is provided."]
[null,null,"-  Row House:  A structure containing three or more living units separated only by vertical walls."]
[null,null,"-  Walk-up:  A multi-level low-rise structure containing one or more living units, in which housing units are separated by a ceiling/floor from other housing units or mixed-use space."]
[]
[null,null,"Step 3.  On the \"Select City and State\" Page, Choose the Applicant's City and State"]
[null,null,"> Click on the down arrow for City.   Click on the name of your city, county or your Metropolitan/Micropolitan Statistical Area."]
[null,null,"- You can look up your MSA at OMB's website, http://www.census.gov/population/www/estimates/metrodef.html  or call your local HUD office."]
[null,null," > Click \"OK\""]
[null,null," > Click on the down arrow for State.   Click on the name of your State."]
[null,null," > Click \"OK\""]
[]
[{"$nulls":8},"Page 1 of 13",{"$nulls":6},"form HUD-52861 (1/2008)"]
[]
[null,null,"Step 4.  Enter All Match and All Main Street Rejuvenation Leverage Resources"]
[null,null,"> The total value of the Match must be greater than 5 percent of the requested grant amount. It must be committed to the Main Street Affordable Housing Project\n    that you intend to rehabilitate or buid.  You are not eligible for grant award if these funds are not available.  Match may be cash or in-kind contributions. Please state which they are."]
[null,null,"> The total value of Main Street Area Rejuvenation Effort Leverage is measured in a Rating Factor. It does NOT include the Match for the Main Street Affordable Housing Project.   "]
[null,null,"    It does include all other public and private funds expended over the last few years on the rejuvenation of the Main Street Area.  It may be cash or in-kind services. Please state which it is."]
[]
[null,null,"Step 5.  At the top of the \"Construction S&U p1\" tab, enter the name of the contact person concering information about the Sources and Uses.  "]
[null,null," > Also enter the name of the organization that the person is from and the listed contact information. "]
[null,null,"-If there is a recognized developer, this person probably represents that developer. "]
[]
[null,null,"Step 6.  On the three \"Construction S&U\" Pages, Fill in All Proposed Main Street Affordable Housing Project Costs that Will Be Incurred During Construction and All Sources of Funding that Will Be Used During the Construction Period  "]
[null,null,"> Entry areas for costs that are not allowable under the HOPE VI Main Street Program are grayed out."]
[]
[null,null,"Step 7.  On the three \"Permanent S&U\" Pages, Fill in All Proposed Main Street Affordable Housing Project Costs that Will Have Been Incurred by the End of Development and All Sources of Funding that Paid for Those Costs.  "]
[null,null," > Do not include construction financing that will be paid off when development is finished. Instead, include any permanent loans, grants or equity that are\n    used to pay off the construction financing.  "]
[null,null,"> Entry areas for costs that are not allowable under the HOPE VI Main Street Program are grayed out."]
[]
[null,null,"Step 8.  Confirm that Sources are Equal to Uses"]
[null,null,"> Confirm that the HOPE VI Main Street grant funds and any other sources of Public Housing Capital Assistance funds are included."]
[null,null,"> Confirm that sources of HOPE VI/Public Housing funds are equal to uses of HOPE VI/Public Housing funds.  "]
[]
[null,null,"Step 9.  Enter any Extraordinary Site Cost (a component of Additional Project Costs -- not subject to TDC limit) "]
[null,null,"> Enter any Extraordinary Site Cost in the cell provided. This may be some or all of the funds entered in BLI 1450."]
[null,null,"•  Extraordinary Site Costs must be verified by an independent registered engineer, and must be approved by HUD in accordance with 24 CFR 941.103."]
[]
[null,null,"Step 10. Review TDC Limit Calculation Results (note that HCC does not apply to the HOPE VI Main Street program)"]
[null,null,"> Review the results of the TDC limit calculations."]
[null,null,"•  The TDC limit analysis results are shown on the lower left \"TDC Limit calculations\" worksheet.  "]
[]
[null,null,"Step 11.  Enter any Extraordinary Site Cost (a component of Additional Project Costs -- not subject to TDC limit) "]
[null,null,"> Enter any Extraordinary Site Cost in the cell provided. This may be some or all of the funds entered in BLI 1450 on the HOPE VI Budget Form."]
[null,null,"•  Extraordinary Site Costs must be verified by an independent registered engineer, and must be approved by HUD in accordance with 24 CFR 941.103."]
[]
[null,null,"Step 12. Review TDC Limit Calculation Results (note that HCC does not apply to the HOPE VI Main Street program)"]
[null,null,"> Review the results of the TDC limit calculations."]
[null,null,"•  The TDC limit analysis results are shown on the lower left \"TDC Limit calculations\" worksheet.  "]
[]
[null,null,"Step 13.  Save and Submit this Form With Your Application "]
[null,null,"> To save this form so that your information cannot be changed without your permission:"]
[null,null,"•  Click on the File menu, then on the Save As… menu item;"]
[null,null,"•  In the upper right of the Save As window, click on Tools and then General Options;"]
[null,null,"•  In the Save Options window, enter a password in the Password to Modify block, then click OK;"]
[null,null,"•  In the Confirm Password window, re-enter the password to verify, then click OK;"]
[null,null,"•  In the Save As… window, click Save;"]
[null,null,"•  When prompted, click \"Yes\" to replace the form file with the password protected form file that you finished filling in."]
[null,null,"> To submit this form as part of your application, follow the instructions in Section IV. of the HOPE VI Main Street NOFA and in the Grants.gov Application Package."]
{"$rows_empty":7}
[{"$nulls":8},"Page 2 of 13",{"$nulls":6},"form HUD-52861 (1/2008)"]

{"sheet":"Unit Mix","index":1,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,4,35,5],[34,4,34,5],[17,2,21,2],[22,2,26,2],[27,2,31,2],[2,2,2,7],[3,2,3,7],[5,5,5,7],[7,5,7,7],[4,2,4,7],[12,2,16,2],[10,4,10,5],[10,6,10,7],[5,2,5,4],[9,2,9,7],[7,2,7,4]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,"Unit Mix and Accessibility Summary, Post-Revitalization"]
[]
[null,null,"Step 2. Enter the Local Government Name, the Main Street Area Name"]
[null,null,"Applicant (Local Govt.) Name: "]
[]
[null,null,"Main Street Rejuvenation Project Name: "]
[]
[null,null,"Step 3.  Enter the Number of Units of Each Type and Size that are to be Developed in the Main Street Affordable Housing Project Funded Through this NOFA."]
[{"$nulls":4},"Rental Units",null,"Homeownership Units"]
[null,null," Structure\n Type"," Number of\n Bedrooms"," Rehabilitation\n of Existing \nApplicant / Partnership Owned Housing"," New Construction or Acquisition (with or without Rehabilitation)"," Rehabilitation\n of Existing \nApplicant / Partnership Owned Housing"," New Construction or Acquisition (with or without Rehabilitation)"]
[null,null,"Detached and\nSemi-\nDetached",0,0,0,0,0]
[null,null,null,1,0,0,0,0]
[null,null,null,2,0,0,0,0]
[null,null,null,3,0,0,0,0]
[null,null,null,4,0,0,0,0]
[null,null,"Elevator",0,0,0,0,0]
[null,null,null,1,0,0,0,0]
[null,null,null,2,0,0,0,0]
[null,null,null,3,0,0,0,0]
[null,null,null,4,0,0,0,0]
[null,null,"Rowhouse",0,0,0,0,0]
[null,null,null,1,0,0,0,0]
[null,null,null,2,0,0,0,0]
[null,null,null,3,0,0,0,0]
[null,null,null,4,0,0,0,0]
[null,null,"Walkup",0,0,0,0,0]
[null,null,null,1,0,0,0,0]
[null,null,null,2,0,0,0,0]
[null,null,null,3,0,0,0,0]
[null,null,null,4,0,0,0,0]
[null,null,null,"Totals: ",0,0,0,0]
[]
[]
[{"$nulls":4},"Page 3 of 13",null,null,null,"form HUD-52861 (1/2008)"]

{"sheet":"Select City & State","index":2,"n_rows":68,"n_cols":13,"rows_kept":68,"cut":false,"hidden":false,"merged":[[67,3,67,5],[27,6,27,11],[2,2,2,11],[21,6,25,11],[15,6,19,11],[9,6,13,11],[3,2,3,11],[4,2,4,11]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,"Step 6.  Using the Drop-down Lists Provided, Select the City (or Metropolitan Area) and State"]
[null,null," that is located nearest to the Main Street Area rejuvenation effort."]
[]
[]
[null,null,"City","(All)"]
[null,null,"StateName","(All)"]
[]
[null,null,"Type","Data","Total",null,"Note 1:  For valid City/State combinations, a table will show the TDC limits from HUD Notice PIH 2006-22, effective from June 21, 2006 through June 30, 2007 (or as extended by HUD)."]
[null,null,"Detached/Semi-Detached","Sum of 0 Bedrooms, TDC",42078279]
[null,null,null,"Sum of 1 Bedrooms, TDC",55625517]
[null,null,null,"Sum of 2 Bedrooms, TDC",72763402]
[null,null,null,"Sum of 3 Bedrooms, TDC",87177823]
[null,null,null,"Sum of 4 Bedrooms, TDC",102983181]
[null,null,null,"Sum of 5 Bedrooms, TDC",113582840,null,"Note 2:  If the desired City/State combination is not included in the list here, you may contact the local HUD Field Office.  They will assist in determining the most appropriate City/State combination."]
[null,null,null,"Sum of 6 Bedrooms, TDC",122364146]
[null,null,null,"Sum of 0 Bedrooms, HCC",24044752]
[null,null,null,"Sum of 1 Bedrooms, HCC",31786013]
[null,null,null,"Sum of 2 Bedrooms, HCC",41579083]
[null,null,null,"Sum of 3 Bedrooms, HCC",49815914]
[null,null,null,"Sum of 4 Bedrooms, HCC",58847541,null,"Note 3:  Total Development Cost limits from this table will be transferred automatically to the \"TDC & HCC Limit calculations\" worksheet."]
[null,null,null,"Sum of 5 Bedrooms, HCC",64904477]
[null,null,null,"Sum of 6 Bedrooms, HCC",69922363]
[null,null,"Elevator","Sum of 0 Bedrooms, TDC",32721136]
[null,null,null,"Sum of 1 Bedrooms, TDC",45809597]
[null,null,null,"Sum of 2 Bedrooms, TDC",58898045]
[null,null,null,"Sum of 3 Bedrooms, TDC",78530736]
[null,null,null,"Sum of 4 Bedrooms, TDC",98163414]
[null,null,null,"Sum of 5 Bedrooms, TDC",111251864]
[null,null,null,"Sum of 6 Bedrooms, TDC",124340324]
[null,null,null,"Sum of 0 Bedrooms, HCC",20450704]
[null,null,null,"Sum of 1 Bedrooms, HCC",28630986]
[null,null,null,"Sum of 2 Bedrooms, HCC",36811276]
[null,null,null,"Sum of 3 Bedrooms, HCC",49081710]
[null,null,null,"Sum of 4 Bedrooms, HCC",61352128]
[null,null,null,"Sum of 5 Bedrooms, HCC",69532413]
[null,null,null,"Sum of 6 Bedrooms, HCC",77712700]
[null,null,"Row House","Sum of 0 Bedrooms, TDC",37207280]
[null,null,null,"Sum of 1 Bedrooms, TDC",48865008]
[null,null,null,"Sum of 2 Bedrooms, TDC",63186829]
[null,null,null,"Sum of 3 Bedrooms, TDC",75951771]
[null,null,null,"Sum of 4 Bedrooms, TDC",89422872]
[null,null,null,"Sum of 5 Bedrooms, TDC",98464618]
[null,null,null,"Sum of 6 Bedrooms, TDC",105791617]
[null,null,null,"Sum of 0 Bedrooms, HCC",21261304]
[null,null,null,"Sum of 1 Bedrooms, HCC",27922869]
[null,null,null,"Sum of 2 Bedrooms, HCC",36106761]
[null,null,null,"Sum of 3 Bedrooms, HCC",43400999]
[null,null,null,"Sum of 4 Bedrooms, HCC",51098798]
[null,null,null,"Sum of 5 Bedrooms, HCC",56265497]
[null,null,null,"Sum of 6 Bedrooms, HCC",60452356]
[null,null,"Walkup","Sum of 0 Bedrooms, TDC",30588505]
[null,null,null,"Sum of 1 Bedrooms, TDC",41287210]
[null,null,null,"Sum of 2 Bedrooms, TDC",52592070]
[null,null,null,"Sum of 3 Bedrooms, TDC",69878122]
[null,null,null,"Sum of 4 Bedrooms, TDC",86583137]
[null,null,null,"Sum of 5 Bedrooms, TDC",97688130]
[null,null,null,"Sum of 6 Bedrooms, TDC",108226301]
[null,null,null,"Sum of 0 Bedrooms, HCC",17479144]
[null,null,null,"Sum of 1 Bedrooms, HCC",23592685]
[null,null,null,"Sum of 2 Bedrooms, HCC",30052610]
[null,null,null,"Sum of 3 Bedrooms, HCC",39930361]
[null,null,null,"Sum of 4 Bedrooms, HCC",49476081]
[null,null,null,"Sum of 5 Bedrooms, HCC",55821796]
[null,null,null,"Sum of 6 Bedrooms, HCC",61843586]
[]
[null,null,null,"Page 4 of 13",{"$nulls":8},"form HUD-52861 (1/2008)"]

{"sheet":"Match Resources","index":3,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,6],[2,1,2,6]],"flags":["formulas_cached_only"]}
[]
[]
[null,"Match Resources"]
[null,"Source of Match","Resource Contact","Contact Title","Contact Email","Dollar Value ","Cash or\nIn-Kind Svc."]
[1,{"$nulls":4},0]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[{"$nulls":4},"TOTAL",0]
[]
[null,null,"Page 5 of 13",null,null,null,"form HUD-52861 (1/2008)"]

{"sheet":"MS Area Rejuv Resources","index":4,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,1,1,6]],"flags":["formulas_cached_only"]}
[]
[null,"Main Street Area Rejuvenation Effort Leverage Resources"]
[null,"Source of Leverage Financing","Resource Contact","Contact Title","Contact Email","Dollar Value ","Cash or\nIn-Kind Svc."]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[{"$nulls":4},"TOTAL",0]
[]
[null,null,"Page 6 of 13",null,null,null,"form HUD-52861 (1/2008)"]

{"sheet":"Constr S&U p1","index":5,"n_rows":54,"n_cols":6,"rows_kept":54,"cut":false,"hidden":false,"merged":[[7,2,7,4],[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,2,4,4],[5,2,5,4],[6,2,6,4]],"flags":["formulas_cached_only"]}
["\nConstruction Period Sources and Uses\nFor the HOPE VI Main Street Affordable Housing Project"]
["Local Government:  "]
["Main Street Area:  "]
[]
[null,"Name of Person that Completed S&U:  "]
[null,"Organization Name :  "]
[null,"Email: "]
[null,"Phone:  "]
[]
["Sources ($)","HOPE VI\nMain Street","Other\nGovt","Tax Credit Equity","Other Private Sector","Total"]
["Public Housing Funds"]
["  HOPE VI Main Street",{"$nulls":4},0]
["  Public Housing ",{"$nulls":4},0]
["Sub-Total",0,0,0,0,0]
[]
["Other HUD Funds"]
["  HOME",{"$nulls":4},0]
["  CDBG",{"$nulls":4},0]
["  Other Funds",{"$nulls":4},0]
["Sub-Total",0,0,0,0,0]
[]
["Total HUD Funds",0,0,0,0,0]
[]
["Non-HUD Public Funds"]
["  State Funds",{"$nulls":4},0]
["  Local Funds",{"$nulls":4},0]
["  Other Funds",{"$nulls":4},0]
["  Other Funds",{"$nulls":4},0]
["  Other Funds",{"$nulls":4},0]
["Sub-Total",0,0,0,0,0]
[]
["Total Public Funds",0,0,0,0,0]
[]
[]
["  Private Funds"]
["  Tax Exempt Bonds",{"$nulls":4},0]
["  Taxable Bonds",{"$nulls":4},0]
["  Private LIHTC",{"$nulls":4},0]
["  Other Equity",{"$nulls":4},0]
["  Homebuyer Down Payment",{"$nulls":4},0]
["  Donations/Grants",{"$nulls":4},0]
["  Private Lender",{"$nulls":4},0]
["  Other",{"$nulls":4},0]
["  Other:",{"$nulls":4},0]
["  Other",{"$nulls":4},0]
["  Other:",{"$nulls":4},0]
[]
["Total Private Funds",0,0,0,0,0]
[]
[]
[]
["Total Sources During Construction",0,0,0,0,0]
[]
[null,null,"Page 7 of 13",null,null,"form HUD-52861 (1/2008)"]

{"sheet":"Constr S&U p2","index":6,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[3,0,3,5],[0,0,0,5],[1,0,1,5],[2,0,2,5]],"flags":["formulas_cached_only"]}
["\nConstruction Period Sources and Uses\nFor the HOPE VI Main Street Affordable Housing Project"]
["Local Government:  "]
["Main Street Area:  "]
[]
["Uses ($)*","HOPE VI\nMain Street","Other\nGovt","Tax Credit Equity","Other Private Sector","Total"]
[]
["Administration"]
["  Administration",{"$nulls":4},0]
["Management Improvements"]
["  Management Improvements - Dev",{"$nulls":4},0]
["  Management Improvements - CSS",{"$nulls":4},0]
["Acquisition"]
["  Site Acquisition",{"$nulls":4},0]
["  Building Acquisition",{"$nulls":4},0]
["  Building Acquisition, Non-Dwelling",{"$nulls":4},0]
["Building Remediation/Demolition"]
["  Remediation, Dwelling Units/Site",{"$nulls":4},0]
["  Demolition, Interior",{"$nulls":4},0]
["  Remediation, Non-Dwelling Units",{"$nulls":4},0]
["  Demolition, Non-Dwelling Units",{"$nulls":4},0]
["  Demolition, Other",{"$nulls":4},0]
["Site Improvements"]
["  Site Remediation",{"$nulls":4},0]
["  Site Infrastructure (Utilities & Roads)",{"$nulls":4},0]
["  Site Improvements (Other)",{"$nulls":4},0]
["Construction"]
["  Dwelling Structures - Hard Costs",{"$nulls":4},0]
["  Non-Dwelling - Hard Costs",{"$nulls":4},0]
["  General Requirements",{"$nulls":4},0]
["  Builder’s Profit",{"$nulls":4},0]
["  Builder’s Overhead",{"$nulls":4},0]
["  Bond Premium",{"$nulls":4},0]
["  Hard Cost Contingency",{"$nulls":4},0]
["Equipment"]
["  Dwelling Equipment",{"$nulls":4},0]
["  Non-Dwelling Equipment",{"$nulls":4},0]
["Professional Fees/Consultant Services"]
["  Program Management Services",{"$nulls":4},0]
["  Architectural",{"$nulls":4},0]
["  Engineering",{"$nulls":4},0]
["  Construction Management Services",{"$nulls":4},0]
["  Appraisal",{"$nulls":4},0]
["  Environmental",{"$nulls":4},0]
["  Market Study",{"$nulls":4},0]
["  Historic Preservation Documentation",{"$nulls":4},0]
["  Other",{"$nulls":4},0]
["Legal"]
["  Organizational",{"$nulls":4},0]
["  Syndication",{"$nulls":4},0]
["  Main Street Outside Counsel",{"$nulls":4},0]
["  Other",{"$nulls":4},0]
["Tax Credits"]
["  Accounting",{"$nulls":4},0]
["  Tax Credit Application",{"$nulls":4},0]
["  Tax Credit Monitoring Fee",{"$nulls":4},0]
["  Syndication",{"$nulls":4},0]
["  Other",{"$nulls":4},0]
[]
["Total Uses During Construction Page 1",0,0,0,0,0]
[]
[null,null,"Page 8 of 13",null,null,"form HUD-52861 (1/2008)"]

{"sheet":"Constr S&U p3","index":7,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[3,0,3,5],[0,0,0,5],[1,0,1,5],[2,0,2,5]],"flags":["formulas_cached_only"]}
["\nConstruction Period Sources and Uses\nFor the HOPE VI Main Street Affordable Housing Project"]
["Local Government:  "]
["Main Street Area:  "]
[]
["Uses ($)*","HOPE VI\nMain Street","Other\nGovt","Tax Credit Equity","Other Private Sector","Total"]
[]
["Other Development Costs "]
["(Soft Costs)"]
["  Accounting Fees",{"$nulls":4},0]
["  Financing Fees",{"$nulls":4},0]
["  Permit Fees",{"$nulls":4},0]
["  Title/Recording/Settlement Fees",{"$nulls":4},0]
["  Real Estate Taxes During Construction",{"$nulls":4},0]
["  Insurance During Construction",{"$nulls":4},0]
["  Interest During Construction",{"$nulls":4},0]
["  Bridge Loan Interest",{"$nulls":4},0]
["  Marking/Rent-up Expenses",{"$nulls":4},0]
["  Reserves",{"$nulls":4},0]
["  Soft Cost Contingency",{"$nulls":4},0]
["  Other",{"$nulls":4},0]
["Relocation"]
["  Relocation Costs",{"$nulls":4},0]
["Developer Fee"]
["  Developer Fee",{"$nulls":4},0]
["Reserves"]
["  Operating Reserve",{"$nulls":4},0]
["  Other Reserves",{"$nulls":4},0]
[]
["Total Uses During Construction Page 2 ",0,0,0,0,0]
[]
[]
["GRAND TOTAL USES:",0,0,0,0,0]
[]
[null,"Page 9 of 13",null,null,null,"form HUD-52861 (1/2008)"]

{"sheet":"Permanent S&U p1","index":8,"n_rows":54,"n_cols":6,"rows_kept":54,"cut":false,"hidden":false,"merged":[[3,0,3,5],[0,0,0,5],[1,0,1,5],[2,0,2,5]],"flags":["formulas_cached_only"]}
["\nPermanent (Long-Term) Sources and Uses\nFor the HOPE VI Main Street Affordable Housing Project"]
["Local Government:  "]
["Main Street Area:  "]
[]
[null,null,"Name of Person that Completed S&U: "]
[null,null,"Organization Name:  "]
[null,null,"Email:  "]
[null,null,"Phone:  "]
[]
["Sources ($)","HOPE VI\nMain Street","Other\nGovt","Tax Credit Equity","Other Private Sector","Total"]
["Public Housing Funds"]
["  HOPE VI Main Street",{"$nulls":4},0]
["  Public Housing ",{"$nulls":4},0]
["Sub-Total",0,0,0,0,0]
[]
["Other HUD Funds"]
["  HOME",{"$nulls":4},0]
["  CDBG",{"$nulls":4},0]
["  Other Funds",{"$nulls":4},0]
["Sub-Total",0,0,0,0,0]
[]
["Total HUD Funds",0,0,0,0,0]
[]
["Non-HUD Public Funds"]
["  State Funds",{"$nulls":4},0]
["  Local Funds",{"$nulls":4},0]
["  Other Funds",{"$nulls":4},0]
["  Other Funds",{"$nulls":4},0]
["  Other Funds",{"$nulls":4},0]
["Sub-Total",0,0,0,0,0]
[]
["Total Public Funds",0,0,0,0,0]
[]
[]
["  Private Funds"]
["  Tax Exempt Bonds",{"$nulls":4},0]
["  Taxable Bonds",{"$nulls":4},0]
["  Private LIHTC",{"$nulls":4},0]
["  Other Equity",{"$nulls":4},0]
["  Homebuyer Down Payment",{"$nulls":4},0]
["  Donations/Grants",{"$nulls":4},0]
["  Private Lender",{"$nulls":4},0]
["  Other",{"$nulls":4},0]
["  Other:",{"$nulls":4},0]
["  Other",{"$nulls":4},0]
["  Other:",{"$nulls":4},0]
[]
["Total Private Funds",0,0,0,0,0]
[]
[]
[]
["Total Long-Term Sources",0,0,0,0,0]
[]
[null,null,"Page 10 of 13",null,null,"form HUD-52861 (1/2008)"]

{"sheet":"Permanent S&U p2","index":9,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[3,0,3,5],[0,0,0,5],[1,0,1,5],[2,0,2,5]],"flags":["formulas_cached_only"]}
["\nPermanent (Long-Term) Sources and Uses\nFor the HOPE VI Main Street Affordable Housing Project"]
["Local Government:  "]
["Main Street Area:  "]
[]
["Uses ($)*","HOPE VI\nMain Street","Other\nGovt","Tax Credit Equity","Other Private Sector","Total"]
[]
["Administration"]
["  Administration",{"$nulls":4},0]
["Management Improvements"]
["  Management Improvements - Dev",{"$nulls":4},0]
["  Management Improvements - CSS",{"$nulls":4},0]
["Acquisition"]
["  Site Acquisition",{"$nulls":4},0]
["  Building Acquisition",{"$nulls":4},0]
["  Building Acquisition, Non-Dwelling",{"$nulls":4},0]
["Building Remediation/Demolition"]
["  Remediation, Dwelling Units/Site",{"$nulls":4},0]
["  Demolition, Interior",{"$nulls":4},0]
["  Remediation, Non-Dwelling Units",{"$nulls":4},0]
["  Demolition, Non-Dwelling Units",{"$nulls":4},0]
["  Demolition, Other",{"$nulls":4},0]
["Site Improvements"]
["  Site Remediation",{"$nulls":4},0]
["  Site Infrastructure (Utilities & Roads)",{"$nulls":4},0]
["  Site Improvements (Other)",{"$nulls":4},0]
["Construction"]
["  Dwelling Structures - Hard Costs",{"$nulls":4},0]
["  Non-Dwelling - Hard Costs",{"$nulls":4},0]
["  General Requirements",{"$nulls":4},0]
["  Builder’s Profit",{"$nulls":4},0]
["  Builder’s Overhead",{"$nulls":4},0]
["  Bond Premium",{"$nulls":4},0]
["  Hard Cost Contingency",{"$nulls":4},0]
["Equipment"]
["  Dwelling Equipment",{"$nulls":4},0]
["  Non-Dwelling Equipment",{"$nulls":4},0]
["Professional Fees/Consultant Services"]
["  Program Management Services",{"$nulls":4},0]
["  Architectural",{"$nulls":4},0]
["  Engineering",{"$nulls":4},0]
["  Construction Management Services",{"$nulls":4},0]
["  Appraisal",{"$nulls":4},0]
["  Environmental",{"$nulls":4},0]
["  Market Study",{"$nulls":4},0]
["  Historic Preservation Documentation",{"$nulls":4},0]
["  Other",{"$nulls":4},0]
["Legal"]
["  Organizational",{"$nulls":4},0]
["  Syndication",{"$nulls":4},0]
["  Main Street Outside Counsel",{"$nulls":4},0]
["  Other",{"$nulls":4},0]
["Tax Credits"]
["  Accounting",{"$nulls":4},0]
["  Tax Credit Application",{"$nulls":4},0]
["  Tax Credit Monitoring Fee",{"$nulls":4},0]
["  Syndication",{"$nulls":4},0]
["  Other",{"$nulls":4},0]
[]
["Total Long-Term Uses Page 1 ",0,0,0,0,0]
[]
[null,null,"Page 11 of 13",null,null,"form HUD-52861 (1/2008)"]

{"sheet":"Permanent S&U p3","index":10,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[3,0,3,5],[0,0,0,5],[1,0,1,5],[2,0,2,5]],"flags":["formulas_cached_only"]}
["\nPermanent (Long-Term) Sources and Uses\nFor the HOPE VI Main Street Affordable Housing Project"]
["Local Government:  "]
["Main Street Area:  "]
[]
["Uses ($)*","HOPE VI\nMain Street","Other\nGovt","Tax Credit Equity","Other Private Sector","Total"]
[]
["Other Development Costs "]
["(Soft Costs)"]
["  Accounting Fees",{"$nulls":4},0]
["  Financing Fees",{"$nulls":4},0]
["  Permit Fees",{"$nulls":4},0]
["  Title/Recording/Settlement Fees",{"$nulls":4},0]
["  Real Estate Taxes During Construction",{"$nulls":4},0]
["  Insurance During Construction",{"$nulls":4},0]
["  Interest During Construction",{"$nulls":4},0]
["  Bridge Loan Interest",{"$nulls":4},0]
["  Marking/Rent-up Expenses",{"$nulls":4},0]
["  Reserves",{"$nulls":4},0]
["  Soft Cost Contingency",{"$nulls":4},0]
["  Other",{"$nulls":4},0]
["Relocation"]
["  Relocation Costs",{"$nulls":4},0]
["Developer Fee"]
["  Developer Fee",{"$nulls":4},0]
["Reserves"]
["  Operating Reserve",{"$nulls":4},0]
["  Other Reserves",{"$nulls":4},0]
[]
["Total Long-Term Uses Page 2 ",0,0,0,0,0]
[]
[]
["GRAND TOTAL USES:",0,0,0,0,0]
[]
[null,null,"Page 12 of 13",null,null,"form HUD-52861 (1/2008)"]

{"sheet":"TDC Limit calculations","index":11,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":false,"merged":[[71,3,71,5],[65,7,68,9],[38,2,38,5],[51,2,51,5],[52,2,52,5],[40,2,40,5],[41,2,41,5],[42,2,42,5],[49,8,49,9],[62,7,62,9],[12,2,16,2],[27,2,31,2],[17,2,21,2],[22,2,26,2],[35,2,35,5],[62,2,62,3],[43,2,43,5],[46,8,46,9],[38,8,40,9],[50,8,50,9],[53,2,53,5],[60,2,60,3],[44,2,44,5],[37,2,37,5],[2,2,2,9],[10,6,10,7],[8,2,8,9],[10,2,10,5],[64,2,68,3],[57,2,57,5],[54,2,54,5],[63,2,63,3],[48,5,48,8],[39,2,39,5],[61,2,61,3],[50,2,50,5],[44,8,44,9],[43,8,43,9],[55,2,55,5],[46,2,46,5],[45,2,45,5]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,"Total Development Cost (TDC) Limit Calculations\n(NOTE: Housing Cost Cap does not apply to the HOPE VI Main Street program)"]
[]
[null,null,null,"Applicant Name:  "]
[]
[null,null,null,"Main Street Area Name:  "]
[]
[null,null,"Using TDC Limits published in Notice PIH 2006-22 for:  (All), (All)"]
[]
[null,null,"Step 3. Unit Mix (Note: enter this information on the \"Unit Mix\" worksheet)",null,null,null,"TDC Limits"]
[null,null,"Structure Type"," BRs"," Rehab\n of Owned\n Housing"," New\n Const.","Per Unit ","Total for All Units"]
[null,null,"Detached/Semi-Detached",0,0,0,42078279,0]
[null,null,null,1,0,0,55625517,0]
[null,null,null,2,0,0,72763402,0]
[null,null,null,3,0,0,87177823,0]
[null,null,null,4,0,0,102983181,0]
[null,null,"Elevator",0,0,0,113582840,0]
[null,null,null,1,0,0,122364146,0]
[null,null,null,2,0,0,24044752,0]
[null,null,null,3,0,0,31786013,0]
[null,null,null,4,0,0,41579083,0]
[null,null,"Row House",0,0,0,49815914,0]
[null,null,null,1,0,0,58847541,0]
[null,null,null,2,0,0,64904477,0]
[null,null,null,3,0,0,69922363,0]
[null,null,null,4,0,0,32721136,0]
[null,null,"Walkup",0,0,0,45809597,0]
[null,null,null,1,0,0,58898045,0]
[null,null,null,2,0,0,78530736,0]
[null,null,null,3,0,0,98163414,0]
[null,null,null,4,0,0,111251864,0]
[{"$nulls":4},0,0,null,0,"TDC Limit"]
[]
[]
[null,null,"     Total Public Housing Sources, Including Requested HOPE VI Main Street\n     Grant and All Other Public Housing Sources\n     (from the Permanent Sources and Uses Pages)",null,null,null,0,0]
[]
[null,null,"Total Uses, All Uses of the HOPE VI Main Street Grant Funds\n     (from the Permanent Sources and Uses pages)"]
[null,null,"1408 Community and Supportive Services (\"CSS\")",null,null,null,0,"Not in TDC",""]
[null,null,"1408 Management Improvements",null,null,null,0]
[null,null,"1430 Fees and Costs (planning, program mgmt, insurance, Reserves, etc.)",null,null,null,0]
[null,null,"1440 Site Acquisition (cost of acquiring sites without structures to be retained as housing)",null,null,null,0]
[null,null,"1450 Site Improvement (streets, site improvements and public improvements)",null,null,null,0]
[null,null,"1460 Dwelling Structures, New Construction and Rehab of Acquisitions",null,null,null,0]
[null,null,"1465 Dwelling Equipment",null,null,null,0]
[null,null,"1485 Demolition (including associated environmental remediation costs)",null,null,null,0]
[null,null,"1495 Relocation (moving expenses, and direct Local Government cost of full-time relocation staff)",null,null,null,0]
[null,null,"Total HOPE VI Main Street Uses",{"$nulls":4},0]
[{"$nulls":5},"Total PH Sources must equal Total PH Uses."]
[]
[]
[]
[]
[null,null,"Community & Supportive Services (\"CSS\")",null,null,null,0]
[null,null,"(Minus) CSS (Not subject to TDC limit)",{"$nulls":4},0]
[null,null,"Total Uses of Public Housing Capital Assistance Subject to TDC Limit",{"$nulls":4},0]
[]
[]
[]
[]
[null,null,"TDC Calculation Results"]
[null,null,"     HOPE VI Main Street TDC Limit Analysis:"]
[null,null,"          Total Development Cost as Percentage of TDC Limit.\n          If TDC is greater than 100%, the Project violates TDC limit(s) for this NOFA."]
[]
[null,null,{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[null,null,null,"Page 13 of 13",{"$nulls":6},"form HUD-52861 (1/2008)"]