{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Instructions","Project Info","Dev Team","Closing S&U","Inc & Exp","Pro Forma","Sheet1","Gap Analysis","Exh A","Risk Sharing","Change Log","Module1","Module2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":89,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Instructions","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7]]}
["New Hampshire Housing Financing Application - Supportive Housing Program - FY 2025"]
[]
[]
[null,"All sections of the applicationmust be completed in full.  Staff reserves the right to reject partially completed applications."]
[]
[null,"Please ensure that when submitting the completed application, that Section 2 of the Development Team tab is"]
[null,"signed."]
[]
[]
[null,"Details for each tab:"]
[]
[null,"Dev Team","This tab captures the members of the project's development team."]
[]
[null,"Project Info","This tab is used to gather general information about the project, including unit details"]
[null,null,"and building features."]
[]
[null,"Closing S&U","This tab details the project financing sources and uses. "]
[]
[null,"Inc & Exp","This tab captures rent and other income information, operating expenses, and debt service. "]
[null,null,"Please use the FY 2025 HUD rent limits found on NH Housing's Website, and the maximum rents for "]
[null,null,"shared bedrooms and SRO units found in the FY 25 Supportive Housing NOFO, to complete this section. "]
[]
[null,"Pro Forma","This tab automatically populated and is used to analyze  income/expense trending."]

{"sheet":"Project Info","index":1,"n_rows":268,"n_cols":10,"rows_kept":268,"cut":false,"hidden":false,"merged":[[170,3,172,8],[2,4,2,8],[3,4,3,8],[4,4,4,6],[18,2,25,8],[90,2,97,8],[247,5,247,6],[242,4,242,8],[244,4,244,8],[245,4,246,8],[174,3,176,8],[178,3,180,8],[183,3,184,8],[238,4,238,5],[205,2,206,8],[195,5,195,8],[243,7,243,8]]}
["PROJECT INFORMATION"]
[]
[1,".","Project Name:"]
[{"$f":"A3+1","v":2},".","Project Address:"]
[{"$f":"A4+1","v":3},".","Project Community:",null,null,null,null,"                NH"]
[null,null,null,null,"                                    (city/town)",null,null,"(state)","(zip code)"]
[]
["Development Plan"]
[]
[4,".","Development Type (please check all that apply):"]
[null,{"$f":"IF(LEN(TRIM(G11))>0,1,0)","v":{"$error":"#VALUE!"}},"   New construction",null,null,null,null,"Mark with an \"X\""]
[null,{"$f":"IF(LEN(TRIM(G12))>0,1,0)","v":{"$error":"#VALUE!"}},"   Acquisition and rehabilitation of existing housing",null,null,null,null,"Mark with an \"X\""]
[null,{"$f":"IF(LEN(TRIM(G13))>0,1,0)","v":{"$error":"#VALUE!"}},"   Acquisition, minimal or no rehab of existing housing",null,null,null,null,"Mark with an \"X\""]
[null,{"$f":"IF(LEN(TRIM(G14))>0,1,0)","v":{"$error":"#VALUE!"}},"   Other",null,null,null,null,"Mark with an \"X\""]
[]
[5,".","Project Description:"]
[null,null,"Please describe the proposed project in a few sentences.  Indicate the population served and the type and number of "]
[null,null,"housing units.  Describe the current condition of the site and its  ownership.  Note whether the site is distressed. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[6,".","Funding Applied For:"]
[null,null,"Please indicate the funding that is being applied for at this time with this application:"]
[null,null,null,null,null,null,"Yes or No ","Amount "]
[null,null,"NH Housing Capital Subsidy (Deferred Payment Loan)"]
[null,null,"NH Housing Project Based Vouchers"]
[]
[]
[]
[7,".","Development Schedule:",null,null,null,"Projected Dates"]
[null,null,null,null,null,null,"MM/YYYY"]
[null,null,"NH Housing Conditional Funding Award Date"]
[null,null,"Site Control Obtained"]
[null,null,"Local Planning and Zoning Approval date"]
[null,null,"Construction/Rehab Plans Specifications Completed"]
[null,null,"Construction Contracts Executed"]
[null,null,"All Environmenal Reports/Assessments Completed"]
[null,null,"All Financing commitments/Grants Obtained"]
[null,null,"NH Housing Financing Commitment"]
[null,null,"Construction Begins"]
[null,null,"Construction Completed"]
[null,null,"Project Placed in Service"]
[]
[]
[]
[8,".","Unit Mix (Indicate the number of units by household income and unit type):"]
[]
[null,null,null,"Market Rate","30% AMI","50% AMI","60% AMI","80% AMI"]
[null,null,"Shared Bedroom*"]
[null,null,"SRO**"]
[null,null,"0 Bedrooms"]
[null,null,"1 Bedrooms"]
[null,null,"2 Bedrooms"]
[null,null,"3 Bedrooms"]
[null,null,"4+ Bedrooms"]
[null,null,"Total Units",{"$f":"SUM(D55:D61)","v":0},{"$f":"SUM(E55:E61)","v":0},{"$f":"SUM(F55:F61)","v":0},0,0,{"$f":"D62+E62+F62+G62+H62","v":0}]
[]
[9,".","Unit Size (Indicate the average size of units, in square feet, by by household income and unit type):"]
[]
[null,null,null,{"$f":"D54","v":"Market Rate"},"30% AMI","50% AMI","60% AMI","80% AMI"]
[null,null,"Shared Bedroom*"]
[null,null,"SRO**"]
[null,null,"0 Bedrooms"]
[null,null,"1 Bedrooms"]
[null,null,"2 Bedrooms"]
[null,null,"3 Bedrooms"]
[null,null,"4+ Bedrooms"]
[]
[null,null,"For the purposes of this financing application: "]
[null,null,"*Shared bedroom units are defined as bedroom units in which two or more unrelated individuals will reside, with kitchen "]
[null,null,"and/or sanitary spaces shared among residents."]
[null,null,"**Single Room Occupancy (SRO) units are defined as bedroom units occupied by one individual only, "]
[null,null,"with kitchen and/or sanitary spaces shared among residents"]
[]
[null,null,"Shared Bedroom - Bed Count (if applicable)"]
[null,null," Indicate the number of beds there will be within the shared bedroom units based on income limit."]
[]
[null,null,null,{"$f":"D54","v":"Market Rate"},"30% AMI","50% AMI","60% AMI","80% AMI"]
[null,null,"Beds per bedroom"]
[null,null,"Total Beds",{"$f":"D85*D55","v":0},{"$f":"E85*E55","v":0},0,0,0,{"$f":"D86+E86+F86+G86+H86","v":0}]
[]
[10,null,"Shared Bedroom / SRO Unit description (if applicable)"]
[null,null,"Please indicate how many beds there will be within each shared bedroom unit, the number of "]
[null,null,"shared bathrooms/kitchens per household, etc. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"New"," ","Existing/"," "," "]
[11,".","Number of buildings planned:",null,"Construction",null,"Rehabilitation",null,"Total"]
[null,null,null,null,null,null,null,null,{"$f":"E105+G105","v":0}]
[]
[null,null,null,null,"Yes",null,"No"]
[12,".","Scattered Sites:"]
[]
[13,".","Number of units:",null,null,null,null,null,{"$f":"E110+G110","v":0}]
[]
[14,".","Gross Square Footage"]
[null,null,"     a.  Residential",null,null,null,null,null,{"$f":"E113+G113","v":0}]
[null,null,"     b.  Commercial",null,null,null,null,null,{"$f":"E114+G114","v":0}]
[]
[{"$f":"A112+1","v":15},".","Net Rentable Square Footage:",null,null,"Total"]
[null,null,"     a.  Residential",null,null,null," s.f."]
[null,null,"     b.  Commercial",null,null,null," s.f."]
[]
[{"$f":"A116+1","v":16},null,"Number of units that will be fully accessible in "]
[null,null,"accordance with ICC/ANSI A117.1, Type A, Fully"]
[null,null,"Accessible guidelines. "]
[]
[{"$f":"A120+1","v":17},null,"Number of accessible parking spaces for"]
[null,null,"Type A Fully Accessible units"]
[]
[{"$f":"A124+1","v":18},".","Fire Code Type (check):"]
[null,null,"       a.  Concrete frame",null,null," (Mark one box with an \"X\")",null,{"$f":"IF(E128<>\" \",1,0)","v":0}]
[null,null,"       b.  Wood frame",null,null," (Mark one box with an \"X\")",null,{"$f":"IF(E129<>\" \",1,0)","v":0}]
[null,null,"       c.  Protected steel",null,null," (Mark one box with an \"X\")",null,{"$f":"IF(E130<>\" \",1,0)","v":0}]
[null,null,"       d.  Masonry bearing wall",null,null," (Mark one box with an \"X\")",null,{"$f":"IF(E131<>\" \",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(F133=\"yes\",F133=\"y\"),\"How Many?\",\"\")","v":"How Many?"}]
[{"$f":"A127+1","v":19},".","Will buildings include elevators?",null,null,null," (\"yes\" or \"no\")","If yes, number:"]
[]
[{"$f":"A133+1","v":20},".","Are the following provided with the housing units:"]
[null,null,"       a.  Range?",null,null," (\"yes\" or \"no\")",null,"      Type (gas or electric)?  "]
[null,null,"       b.  Refrigerator?",null,null," (\"yes\" or \"no\")"]
[null,null,"       c.  Microwave?",null,null," (\"yes\" or \"no\")"]
[null,null,"       d.  Dishwasher?",null,null," (\"yes\" or \"no\")"]
[null,null,"       e.  Disposal?",null,null," (\"yes\" or \"no\")"]
[null,null,"       f.  Washer/Dryer Hookup?",null,null," (\"yes\" or \"no\")"]
[null,null,"       g.  Washer & Dryer?",null,null," (\"yes\" or \"no\")"]
[null,null,"       h.  Wall-to-wall Carpet?",null,null," (\"yes\" or \"no\")"]
[null,null,"       i.  Window Air Conditioner?",null,null," (\"yes\" or \"no\")"]
[null,null,"       j.  Central Air Conditioning?",null,null," (\"yes\" or \"no\")"]
[]
[{"$f":"A135+1","v":21},".","Are the following included in the rent:"]
[null,null,"       a.  Heat?",null,null," (\"yes\" or \"no\")"]
[null,null,"       b.  Domestic Electricity?",null,null," (\"yes\" or \"no\")"]
[null,null,"       c.  Cooking Fuel?",null,null," (\"yes\" or \"no\")"]
[null,null,"       d.  Hot Water?",null,null," (\"yes\" or \"no\")"]
[null,null,"       e.  Central A/C (if any)?",null,null," (\"yes\" or \"no\")"]
[null,null,null,null,"Space Heating:",null,null,"Hot Water:"]
[{"$f":"A147+1","v":22},".","Type of heating fuel:",null,null,"Propane",{"$f":"IF(E154<>\" \",1,0)","v":0},null,"Propane"]
[null,null,"                   (Check one with \"X\")",null,null,"Natural Gas",{"$f":"IF(E155<>\" \",1,0)","v":0},null,"Natural Gas"]
[null,null,null,null,null,"Oil",{"$f":"IF(E156<>\" \",1,0)","v":0},null,"Oil"]
[null,null,null,null,null,"Electric",{"$f":"IF(E157<>\" \",1,0)","v":0},null,"Electric"]
[]
[{"$f":"A154+1","v":23},".","No. of parking spaces:",null,null,null,null,null,{"$f":"IF(E159+G159=0,0,(E159+G159))","v":0}]
[null,null,null,null,"Enclosed",null,"Outdoor",null,"Total"]
[]
[24,null,"Will project in include community space? ",null,null,null," (\"yes\" or \"no\")","if yes, sq. ft. "]
[]
[]
[]
[25,".","Will acquisition/rehabilitation require relocation of existing tenants?",null,null,null,null,null," (\"yes\" or \"no\")"]
[null,null,"   ( If yes, please include relocation plan with Project Application.)"]
[]
[{"$f":"A166+1","v":26},".","Scope of rehabilitation.  If rehabilitation, please describe the following (or type N/A)."]
[null,null,"       a.  Major systems to be replaced:"]
[]
[]
[]
[null,null,"       b.  Substandard conditions and structural deficiencies to be repaired:"]
[]
[]
[]
[null,null,"       c.  Special features/adaptations for special needs clients to be housed:"]
[]
[]
[]
[]
[{"$f":"A169+1","v":27},".","Amount of demolition, if any:"]
[]
[]
[]
[]
["Information on Site and Existing Buildings"]
[]
[null,null,null,null,"Square Feet","Square Feet","Acres","Acres"]
[{"$f":"A183+1","v":28},".","Size of Site:",null,null,{"$f":"IF(E191>0,\"\",IF(G191>0,G191*43560,\" \"))","v":" "},null,{"$f":"IF(G191>0,\"\",IF(E191>0,E191/43560,\" \"))","v":" "}]
[{"$f":"A191+1","v":29},".","Buildable area:",null,null,{"$f":"IF(E192>0,\"\",IF(G192>0,G192*43560,\" \"))","v":" "},null,{"$f":"IF(G192>0,\"\",IF(E192>0,E192/43560,\" \"))","v":" "}]
[null,null,null,null,null,null,null,{"$f":"IF(G193>0,G193*43560,\" \")","v":" "}]
[]
[null,null,"Existing Conditions: "]
[{"$f":"A192+1","v":30},".","What is the present use of the property?"]
[{"$f":"A196+1","v":31},".","Number of existing structures:"]
[{"$f":"A197+1","v":32},".","Gross s.f. of existing structures:"]
[{"$f":"A198+1","v":33},".","If rehabilitation:",null,null,null,"units","bedrooms"]
[null,null,"   a.  Number of existing residential units/bedrooms:"]
[null,null,"   b.  Number of units/bedrooms currently occupied:"]
[{"$f":"A199+1","v":34},".","If site includes commercial space:"]
[null,null,"   a.  Square footage of existing commercial space:",null,null,null,null,"  square feet"]
[null,null,"   b.  Square footage currently occupied:",null,null,null,null,"  square feet"]
[{"$f":"A202+1","v":35},".","What are the surrounding land uses?"]
[]
[]
[]
[null,null,"Utilities:"]
[{"$f":"A205+1","v":36},".","Please answer \"yes\" or \"no\" as to whether the following utilities are available on the site:"]
[null,null,"a. San. sewer",null," If no, distance from site:",null,null,"  feet",{"$f":"IF(OR(D211=\"yes\",D211=\"no\"),1,0)","v":1}]
[null,null,"b. Storm sewer",null," If no, distance from site:",null,null,"  feet",{"$f":"IF(OR(D212=\"yes\",D212=\"no\"),1,0)","v":1}]
[null,null,"c. Public water",null," If no, distance from site:",null,null,"  feet",{"$f":"IF(OR(D213=\"yes\",D213=\"no\"),1,0)","v":1}]
[null,null,"d. Electricity",null," If no, distance from site:",null,null,"  feet",{"$f":"IF(OR(D214=\"yes\",D214=\"no\"),1,0)","v":1}]
[null,null,"e. Gas",null," If no, distance from site:",null,null,"  feet",{"$f":"IF(OR(D215=\"yes\",D215=\"no\"),1,0)","v":1}]
[null,null,"f. If any of the above are not available, is plan attached telling how such service will be extended"]
[null,null,"    to the site?",null," (\"yes\" or \"no\")",null,"(Please attach as part of Exhibit 1.)"]
[]
[]
[]
[]
[null,null,"Zoning:"]
[{"$f":"A210+1","v":37},".","Does the zoning permit the proposed development?",null,null,null,null,null," (\"yes\" or \"no\")",{"$f":"IF(OR(H223=\"yes\",H223=\"no\"),1,0)","v":1}]
[]
[]
[{"$f":"A223+1","v":38},".","If zoning does not allow for the proposed development, has the needed zoning"]
[null,null,"relief/variance/special permit/subdivision approval/site plan approval ",null,null,null,null,null," (\"yes\" or \"no\")"]
[null,null,"been obtained?"]
[]
[]
[{"$f":"A226+1","v":39},".","Are any other efforts for local approvals required?",null,null,null,null,null," (\"yes\" or \"no\")"]
[null,null,"    Please detail in permit status letter. "]
[]
[null,null,"Site Control:"]
[{"$f":"A231+1","v":40},".","What form of site control do you have?  ",null,null,null," (Mark one box)"]
[null,{"$f":"IF(LEN(TRIM(H236))>0,1,0)","v":1},null,null,"Ownership ",null,null," (Mark one box with an \"X\")"]
[null,{"$f":"IF(LEN(TRIM(H237))>0,1,0)","v":1},null,null,"Purchase and Sale Agreement(s) ",null," "," (Mark one box with an \"X\")"]
[null,{"$f":"IF(LEN(TRIM(H238))>0,1,0)","v":1},null,null,"Option ",null," "," (Mark one box with an \"X\")"]
[null,{"$f":"IF(LEN(TRIM(H239))>0,1,0)","v":1},null,"Other:  ",null,null," "," (Mark one box with an \"X\")"]
[null,null,null,null,null,null,"Evidence of site control must be submitted with application"]
[]
[{"$f":"A235+1","v":41},".","If site not presently owned by sponsor, please answer the following:"]
[null,null,"    a.  Type of Agreement:"]
[null,null,"    b.  Agreement Date:",null,"",null,"Expiration Date:  "]
[null,null,"    c.  Name of Seller:"]
[null,null,"    d.  Principals of seller corporation:",null,""]
[]
[null,null,"    e.  Purchase price if under agreement:$",null,null,""]
[null,null,"    f.   Is there any identity of interest between buyer and seller?",null,null,null,null,null," (\"yes\" or \"no\")"]
[]
[{"$f":"A242+1","v":42},".","In the past three years, have there been any defaults on any mortgage on the property or other "]
[null,null,"forms of financial distress?",null,null," (\"yes\" or \"no\")",null,{"$f":"IF(E252<>\" \",1,0)","v":0}]
[null,null,"    If yes, please attach description with Project Application"]
[]
[{"$f":"A251+1","v":43},".","Are there any outstanding liens on the property?",null,null,null,null," (\"yes\" or \"no\")",null,{"$f":"IF(G255<>\" \",1,0)","v":0}]
[]
[null,null,"Amenities and Services:"]
[{"$f":"A255+1","v":44},".","Please indicate distance from site and locate on city/town map."]
[null,null,null,null,null,"Distance"]
[null,null,"       a.  Shopping facilities",null,null,null,"  miles"]
[null,null,"       b.  Schools ",null,null,null,"  miles"]
[null,null,"       c.  Hospitals ",null,null,null,"  miles"]
[null,null,"       d.  Parks and recreational facilities ",null,null,null,"  miles"]
[null,null,"       e.  Police station ",null,null,null,"  miles"]
[null,null,"       f.  Fire station ",null,null,null,"  miles"]
[null,null,"       g.  Public transportation ",null,null,null,"  miles"]
[null,null,"       h.  Houses of worship",null,null,null,"  miles"]
[null,null,"       i.  City/Town Hall ",null,null,null,"  miles"]

{"sheet":"Dev Team","index":2,"n_rows":142,"n_cols":10,"rows_kept":142,"cut":false,"hidden":false,"merged":[[64,5,64,8],[65,5,65,8],[66,5,66,8],[51,5,51,8],[57,5,57,8],[60,5,60,6],[60,7,60,8],[58,5,58,8],[59,5,59,8],[56,5,56,8],[101,3,111,8],[63,5,63,8],[81,5,81,8],[67,5,67,8],[96,5,96,6],[96,7,96,8],[76,5,76,8],[93,5,93,8],[94,5,94,8],[95,5,95,8],[77,5,77,8],[82,5,82,8],[86,5,86,6],[86,7,86,8],[78,5,78,6],[78,7,78,8],[34,5,34,8],[13,5,13,8],[12,5,12,8],[32,5,32,8],[40,5,40,8],[14,5,14,8],[24,5,24,8],[39,5,39,8],[15,5,15,6],[36,5,36,6],[36,7,36,8],[48,5,48,8],[49,5,49,8],[43,5,43,8],[55,5,55,8],[35,5,35,8],[52,5,52,6],[52,7,52,8],[44,5,44,6],[44,7,44,8],[50,5,50,8],[42,5,42,8],[47,5,47,8],[41,5,41,8],[0,0,0,9],[31,5,31,8],[33,5,33,8],[7,3,7,5],[23,5,23,8],[25,7,25,8],[25,5,25,6],[18,5,18,8],[19,5,19,8],[20,5,20,8],[21,5,21,8],[22,5,22,8],[1,3,1,7],[10,5,10,8],[11,5,11,8],[15,7,15,8],[91,5,91,8],[92,5,92,8],[73,5,73,8],[75,5,75,8],[68,5,68,6],[68,7,68,8],[85,5,85,8],[83,5,83,8],[84,5,84,8],[74,5,74,8]]}
["DEVELOPMENT TEAM SUMMARY"]
[null,null,null,{"$f":"'Closing S&U'!A2","v":"Un-named Project"}]
[]
[1,".","Developer/Sponsor Type (Please check one box)",null,null,null,null,"(check one)"]
[null,null,"         Any form of for-profit corporation, partnership, or individual",null,null,null,null,null,null,{"$f":"IF(H5<>\" \",1,0)","v":0}]
[null,null,"         Non-profit corporation",null,null,null,null,null,null,{"$f":"IF(H6<>\" \",1,0)","v":0}]
[null,null,"         Limited equity housing cooperative",null,null,null,null," ",null,{"$f":"IF(H7<>\" \",1,0)","v":0}]
[null,null,"         Other:     ",null,null,null,null," ",null,{"$f":"IF(H8<>\" \",1,0)","v":0}]
[]
[{"$f":"A4+1","v":2},".","Developer/Sponsor:",null," "]
[null,null,null,"Legal Name"]
[null,null,null,"Address"]
[]
[null,null,null,"Contact Person"]
[null,null,null,"Email Address"]
[null,null,null,"Telephone No.  /  Fax. No."]
[]
[{"$f":"A10+1","v":3},".","Proposed Owner/Mortgagor:"]
[null,null,null,"Form of Legal Entity"]
[null,null,null,"Legal Name"]
[null,null,null,"Address"]
[]
[null,null,null,"Principals"]
[null,null,null,"Contact Person"]
[null,null,null,"Email Address"]
[null,null,null,"Telephone No.  /  Fax. No."]
[]
[]
[]
[]
[4,".","Architect:"]
[null,null,null,"Company Name"]
[null,null,null,"Address"]
[]
[null,null,null,"Contact Person"]
[null,null,null,"Email Address"]
[null,null,null,"Telephone/Fax#"]
[]
[5,".","Development Consultant:"]
[null,null,null,"Company Name"]
[null,null,null,"Address"]
[]
[null,null,null,"Contact Person"]
[null,null,null,"Email Address"]
[null,null,null,"Telephone/Fax#"]
[]
[6,".","Contractor:"]
[null,null,null,"Company Name"]
[null,null,null,"Address"]
[]
[null,null,null,"Contact Person"]
[null,null,null,"Email Address"]
[null,null,null,"Telephone/Fax#"]
[]
[7,".","Solar/Energy Consultant (if applicable):"]
[null,null,null,"Company Name"]
[null,null,null,"Address"]
[]
[null,null,null,"Contact Person"]
[null,null,null,"Email Address"]
[null,null,null,"Telephone/Fax#"]
[]
[8,".","Historic Consultant (if applicable): "]
[null,null,null,"Company Name"]
[null,null,null,"Address"]
[]
[null,null,null,"Contact Person"]
[null,null,null,"Email Address"]
[null,null,null,"Telephone/Fax#"]
[]
[]
[]
[9,".","Management Agent:"]
[null,null,null,"Company Name"]
[null,null,null,"Address"]
[]
[null,null,null,"Contact Person"]
[null,null,null,"Email Address"]
[null,null,null,"Telephone/Fax#"]
[]
[{"$f":"A73+1","v":10},".","Attorney (Real Estate):"]
[null,null,null,"Company Name"]
[null,null,null,"Address"]
[]
[null,null,null,"Contact Person"]
[null,null,null,"Email Address"]
[null,null,null,"Telephone/Fax#"]
[]
[]
[]
[{"$f":"A63+1","v":9},".","Service Provider or Coordinator:"]
[null,null,null,"Name"]
[null,null,null,"Address"]
[]
[null,null,null,"Contact Person"]
[null,null,null,"Email Address"]
[null,null,null,"Telephone/Fax#"]
[]
[10,".","Is there any identity of interest between any members of the development team?"]
[null,null,null,null," (\"yes\" or \"no\")",null,"If yes, explain below."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CERTIFICATION PAGE"]
[]
[null,null,"Project Name",{"$f":"IF(+'Project Info'!E3=\"\",\"Un-named Project\",+'Project Info'!E3)","v":"Un-named Project"}]
[]
[null,null,"Date:"]
[null,null,null,"(month)","(day)","(year)"]
[]
[null,null,"The applicant hereby certifies that this application is complete and accurate to the best of"]
[null,null,"their knowledge, and that no material misrepresentation is made herein by the applicant.  "]
[null,null,"The  applicant  agrees that this application may be relied upon by  New Hampshire Housing "]
[null,null,"Finance Authority and other funding sources. "]
[]
[null,null,"In the event of any extraordinary circumstances, the applicant  agrees to pay for any reasonable"]
[null,null," legal and third party costs incurred by the Authority which are associated with processing this "]
[null,null,"application."]
[]
[null,null,"The applicant hereby certifies that they have read and understand all applicable NH Housing Rules"]
[null,null,"and Standards included in the Supportive Housing Program Notice of Funding Opportunity. "]
[]
[null,null,"By submitting this application, applicant gives permission to New Hampshire Housing Finance Authority "]
[null,null,"and its agents to investigate all representations made and attachments included. This includes permission"]
[null,null,"to access personal and business credit reports. "]
[]
[]
[]
[]
[]
[null,null,null,"Applicant Signature",null,null,"Date"]

{"sheet":"Closing S&U","index":3,"n_rows":123,"n_cols":10,"rows_kept":123,"cut":false,"hidden":false,"merged":[[0,0,0,9],[104,7,104,8],[2,0,2,9],[1,0,1,9],[117,7,117,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[37,7,37,8],[38,7,38,8],[40,7,40,8],[41,7,41,8],[42,7,42,8],[43,7,43,8],[58,7,58,8],[62,7,62,8],[63,7,63,8],[113,7,113,8],[114,7,114,8],[85,7,85,8],[77,7,77,8],[78,7,78,8],[79,7,79,8],[100,7,100,8],[101,7,101,8],[86,7,86,8],[87,7,87,8],[88,7,88,8],[89,7,89,8],[90,7,90,8],[96,7,96,8],[115,7,115,8],[116,7,116,8],[110,7,110,8],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[105,7,105,8],[24,4,24,8],[25,4,25,8],[54,7,54,8],[55,7,55,8],[56,7,56,8],[57,7,57,8],[13,3,13,4],[15,2,15,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[16,2,16,5],[17,3,17,4],[18,3,18,4],[19,2,19,4],[29,7,29,8],[30,7,30,8],[49,2,49,3],[49,7,49,8],[51,7,51,8],[52,7,52,8],[53,7,53,8],[82,7,82,8],[83,7,83,8],[84,7,84,8],[64,7,64,8],[65,7,65,8],[66,7,66,8],[67,7,67,8],[68,7,68,8],[69,7,69,8],[70,7,70,8],[73,7,73,8],[74,7,74,8],[75,7,75,8],[76,7,76,8],[61,7,61,8],[97,7,97,8],[98,7,98,8],[99,7,99,8],[91,7,91,8],[92,7,92,8],[93,7,93,8],[94,7,94,8],[95,7,95,8]]}
["CLOSING SOURCES AND USES OF FUNDS"]
[{"$f":"IF(+'Project Info'!E3=\"\",\"Un-named Project\",+'Project Info'!E3)","v":"Un-named Project"}]
["Sources of Funds"]
[]
[1,null,"Type of Funding","Source of Funding",null,"Amount  $"]
[null,".","Developer Fee Loan","N/A"]
[null,".","Developer's Cash Equity"]
[null,".","Other Equity"]
[null,".","Other Equity"]
[null,null,"Grant"]
[null,".","Grant"]
[null,".","Grant",null,null,null,"Rate %","Amortize (years)","Term (years)","Lien Position"]
[null,null,"NHH Capital Subsidy (Deferred Payment) Loan","NH Housing Afforable Housing Fund",null,null,0,"N/A",30]
[null,".","NHH Long-Term Loan","NH Housing"]
[null,null,"Other Long-Term Loan"]
[null,null,"Total Long-Term Sources",null,null,{"$f":"SUM(F6:F15)","v":0}]
[null,null,null,null,null,null,"Rate  %","Term (months)","Lien Position"]
[null,".","Construction Loan"]
[null,".","Other Bridge Financing"]
[null,null,"Total Construction Only Sources",null,null,{"$f":"SUM(F18:F19)","v":0}]
[]
[]
[null,null,"Uses of Funds"]
[null,null,"Direct Construction:"]
[2,".","Who prepared the estimates?"]
[{"$f":"A25+1","v":3},".","What is basis for estimates?"]
[]
[]
[null,null,"Development Budget:"]
[]
[4,null,"ACQUISITION ",null,"Residential","Non-Residential","Total","Comments/Explanation of Costs"]
[null,".","Land",null,null,null,{"$f":"E32+F32","v":0}]
[null,".","Existing Building",null,null,null,{"$f":"E33+F33","v":0}]
[null,".","Transfer Tax",null,null,null,{"$f":"E34+F34","v":0}]
[null,".","Other (indicate)",null,null,null,{"$f":"E35+F35","v":0}]
[null,null,"Subtotal",null,{"$f":"SUM(E32:E35)","v":0},{"$f":"SUM(F32:F35)","v":0},{"$f":"SUM(G32:G35)","v":0}]
[]
[5,null,"CONSTRUCTION",null,"Residential","Non-Residential","Total","Comments/Explanation of Costs"]
[null,null,"Construction Budget",null,null,null,{"$f":"SUM(E39:F39)","v":0}]
[null,null,"Construction Contingency",null,null,null,{"$f":"SUM(E40:F40)","v":0},"% of construction",{"$f":"(E40/E39)","v":{"$error":"#DIV/0!"}}]
[null,null,"Site Improvements",null,null,null,0]
[null,null,"General Requirements",null,null,null,0]
[null,null,"Builder Overhead",null,null,null,0]
[null,null,"Builder Profit",null,null,null,0]
[null,null,"Other (indicate)",null,null,null,0]
[null,null,"Other (indicate)",null,null,null,0]
[null,null,"Other (indicate)",null,null,null,0]
[null,null,"Subtotal",null,{"$f":"SUM(E39:E47)","v":0},{"$f":"SUM(F39:F44)","v":0},0]
[]
[6,null,"ARCHITECTURAL/ ENGINEERING/PROFESSIONAL FEES",null,"Residential","Non-Residential","Total","Comments/Explanation of Costs"]
[null,".","Architect Fee-Design",null,null,null,{"$f":"E51+F51","v":0},{"$f":"IF(AND(G51>0,G39>0),+G51/G39,0)","v":0},"% of construct."]
[null,null,"Architect Fee-Inspection",null,null,null,0]
[null,".","Engineering Fees",null,null,null,0]
[null,".","Historic Consultant Fees",null,null,null,0]
[null,".","Solar Consultant Fees",null,null,null,0]
[null,".","Site Survey",null,null,null,0]
[null,null,"Other (indicate)",null,null,null,0]
[null,null,"Other (indicate)",null,null,null,0]
[null,".","Other (indicate)",null,null,null,0]
[null,null,"Subtotal",null,{"$f":"SUM(E51:E59)","v":0},{"$f":"SUM(F51:F59)","v":0},{"$f":"SUM(G51:G59)","v":0}]
[]
[7,null,"INTERIM CONSTRUCTION EXPENSE",null,"Residential","Non-Residential","Total","Comments/Explanation of Costs"]
[null,".","Construction Period Insurance",null,null,null,{"$f":"E63+F63","v":0}]
[null,".","Taxes During Construction",null,null,null,0]
[null,".","P&P Bond/Letter of Credit",null,null,null,0]
[null,".","Construction Period Interest",null,null,null,0]
[null,".","Construction Lender's Counsel",null,null,null,0]
[null,".","Construction  Loan Origination Fee",null,null,null,0]
[null,null,"Other (indicate)",null,null,null,0]
[null,null,"Other (indicate)",null,null,null,0]
[null,".","Other (indicate)",null,null,null,0]
[null,null,"Subtotal",null,{"$f":"SUM(E63:E71)","v":0},{"$f":"SUM(F63:F71)","v":0},{"$f":"SUM(G63:G71)","v":0}]
[]
[8,null,"FINANCING FEES AND EXPENSE",null,"Residential","Non-Residential","Total","Comments/Explanation of Costs"]
[null,".","Long-Term Loan Origination Fee",null,null,null,{"$f":"E75+F75","v":0}]
[null,".","Title Insurance and Record",null,null,null,0]
[null,".","Long-Term Lender's Counsel",null,null,null,0]
[null,null,"NHH AHF Monitoring Fee",null,null,null,{"$f":"(E78+F78)","v":0}]
[null,".","Other (indicate)",null,null,null,0]
[null,".","Other (indicate)",null,null,null,0]
[null,null,"Subtotal",null,{"$f":"SUM(E75:E80)","v":0},{"$f":"SUM(F75:F80)","v":0},{"$f":"SUM(G75:G80)","v":0}]
[]
[9,null,"OTHER SOFT COSTS",null,"Residential","Non-Residential","Total","Comments/Explanation of Costs"]
[null,".","Appraisal",null,null,null,{"$f":"E84+F84","v":0}]
[null,".","Market Study",null,null,null,0]
[null,".","Environmental Report",null,null,null,0]
[null,".","Relocation Costs",null,null,null,0]
[null,".","Borrower Legal Fees",null,null,null,0]
[null,".","Accounting Fees",null,null,null,0]
[null,".","NH Housing Lender Inspector",null,null,null,0]
[null,null,"Furnishings, Fixtures and Equipment",null,null,null,0]
[null,null,"Owner's Project Manager",null,null,null,0]
[null,null,"Marketing and Lease-up",null,null,null,0]
[null,null,"Building Permits",null,null,null,0]
[null,null,"Other Permits",null,null,null,0]
[null,null,"Impact Fees",null,null,null,0]
[null,null,"Water and Sewer Fees ",null,null,null,0]
[null,null,"Soft Cost Contingency",null,null,null,0]
[null,null,"Other (indicate)",null,null,null,0]
[null,null,"Other (indicate)",null,null,null,0]
[null,null,"Other (indicate)",null,null,null,0]
[null,".","Other (indicate)",null,null,null,0]
[null,null,"Subtotal",null,{"$f":"SUM(E84:E102)","v":0},{"$f":"SUM(F84:F102)","v":0},{"$f":"SUM(G84:G102)","v":0}]
[]
[]
[10,null,"DEVELOPER FEE",null,"Residential","Non-Residential","Total","Comments/Explanation of Costs"]
[null,".","Developer Fee",null,null,null,{"$f":"E107+F107","v":0}]
[null,".","Development Consultant Fee",null,null,null,{"$f":"E108+F108","v":0},"Must be netted from Developer Fee"]
[null,null,"Subtotal",null,{"$f":"SUM(E107:E108)","v":0},{"$f":"SUM(F107:F108)","v":0},{"$f":"E109+F109","v":0}]
[]
[11,null,"RESERVES (see NH Housing Underwriting Standards)",null,"Residential","Non-Residential","Total","Comments/Explanation of Costs"]
[null,".","Operating Reserve",null,null,null,{"$f":"E112+F112","v":0},"Calculated",{"$f":"('Inc & Exp'!G133/12*4)+('Inc & Exp'!G141/12*4)","v":0}]
[null,".","Replacement Reserve",null,null,null,0,"Calculated ",{"$f":"'Project Info'!I62*500","v":0}]
[null,".","Insurance Escrow",null,null,null,0]
[null,".","Real Estate Tax Escrow",null,null,null,0]
[null,".","Other (indicate)",null,null,null,0]
[null,".","Other (indicate)",null,null,null,0]
[null,null,"Subtotal",null,{"$f":"SUM(E112:E117)","v":0},{"$f":"SUM(F112:F117)","v":0},{"$f":"SUM(G112:G117)","v":0}]
[]
[12,".","Total Development Cost",null,{"$f":"E118+E109+E103+E81+E72+E60+E48+E36","v":0},{"$f":"F118+F109+F103+F81+F72+F60+F48+F36","v":0},{"$f":"G118+G109+G103+G81+G72+G60+G48+G36","v":0},{"$f":"IF(F16<>G120,\"Sources and Uses do NOT Match!\",\"Sources and Uses Match!\")","v":"Sources and Uses Match!"}]
[]
[null,null,"Debt Service Requirements:"]
[13,null,"Minimum Debt Service Coverage",null,null,1.1499999999999999]

{"sheet":"Inc & Exp","index":4,"n_rows":145,"n_cols":10,"rows_kept":145,"cut":false,"hidden":false,"merged":[[72,6,72,7],[56,7,56,8],[58,7,58,8],[69,6,69,7],[0,0,0,9],[1,0,1,9],[3,0,3,9],[70,6,70,7],[71,6,71,7],[64,7,64,8],[62,7,62,8]]}
["OPERATING PRO-FORMA"]
[{"$f":"'Closing S&U'!A2","v":"Un-named Project"}]
[]
["Operating Income"]
[null,null,"Rent Schedule:"]
[1,null,{"$f":"'Project Info'!D54","v":"Market Rate"},"FMR","Contract Rent","Utility Allowance","Gross Rent","# of Units ","Total Beds","Annual Rent"]
[null,null,"Shared bedroom units",null,null,null,{"$f":"E7+F7","v":0},{"$f":"'Project Info'!D55","v":0},{"$f":"'Project Info'!D86","v":0},{"$f":"(E7*I7)*12","v":0}]
[null,null,"SRO",null,null,null,{"$f":"E8+F8","v":0},{"$f":"'Project Info'!D56","v":0},"--",{"$f":"(E8*H8)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,{"$f":"E9+F9","v":0},{"$f":"'Project Info'!D56","v":0},"--",{"$f":"(E9*H9)*12","v":0}]
[null,null,"1 Bedroom",null,null,null,0,{"$f":"'Project Info'!D57","v":0},"--",0]
[null,null,"2 Bedroom",null,null,null,{"$f":"E11+F11","v":0},{"$f":"'Project Info'!D58","v":0},"--",0]
[null,null,"3 Bedroom",null,null,null,0,{"$f":"'Project Info'!D59","v":0},"--",0]
[null,null,"4 Bedroom",null,null,null,{"$f":"E13+F13","v":0},{"$f":"'Project Info'!D60","v":0},"--",{"$f":"(E13*H13)*12","v":0}]
[null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(J7:J13)","v":0}]
[]
[2,null,{"$f":"'Project Info'!E54","v":"30% AMI"},"Rent Limit","Contract Rent","Utility Allowance","Gross Rent","# of Units ","Total Beds","Annual Rent"]
[null,null,"Shared bedroom units",null,null,null,{"$f":"E17+F17","v":0},{"$f":"'Project Info'!E55","v":0},{"$f":"'Project Info'!E86","v":0},{"$f":"(E17*I17)*12","v":0}]
[null,null,"SRO",null,null,null,{"$f":"E18+F18","v":0},{"$f":"'Project Info'!E56","v":0},"--",{"$f":"(E18*H18)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,{"$f":"E19+F19","v":0},{"$f":"'Project Info'!E57","v":0},"--",{"$f":"(E19*H19)*12","v":0}]
[null,null,"1 Bedroom",null,null,null,0,{"$f":"'Project Info'!E58","v":0},"--",0]
[null,null,"2 Bedroom",null,null,null,{"$f":"E21+F21","v":0},{"$f":"'Project Info'!E59","v":0},"--",0]
[null,null,"3 Bedroom",null,null,null,{"$f":"E22+F22","v":0},{"$f":"'Project Info'!E60","v":0},"--",0]
[null,null,"4 Bedroom",null,null,null,{"$f":"E23+F23","v":0},{"$f":"'Project Info'!E61","v":0},"--",{"$f":"(E23*H23)*12","v":0}]
[null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(J17:J23)","v":0}]
[]
[3,null,{"$f":"'Project Info'!F54","v":"50% AMI"},"Rent Limit","Contract Rent","Utility Allowance","Gross Rent","# of Units ","Total Beds","Annual Rent"]
[null,null,"Shared bedroom units",null,null,null,{"$f":"E27+F27","v":0},{"$f":"'Project Info'!F55","v":0},{"$f":"'Project Info'!F86","v":0},{"$f":"(E27*I27)*12","v":0}]
[null,null,"SRO",null,null,null,{"$f":"E28+F28","v":0},{"$f":"'Project Info'!F56","v":0},"--",{"$f":"(E28*H28)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,{"$f":"E29+F29","v":0},{"$f":"'Project Info'!F57","v":0},"--",{"$f":"(E29*H29)*12","v":0}]
[null,null,"1 Bedroom",null,null,null,0,{"$f":"'Project Info'!F58","v":0},"--",0]
[null,null,"2 Bedroom",null,null,null,{"$f":"E31+F31","v":0},{"$f":"'Project Info'!F59","v":0},"--",0]
[null,null,"3 Bedroom",null,null,null,{"$f":"E32+F32","v":0},{"$f":"'Project Info'!F60","v":0},"--",0]
[null,null,"4 Bedroom",null,null,null,{"$f":"E33+F33","v":0},{"$f":"'Project Info'!F61","v":0},"--",{"$f":"(E33*H33)*12","v":0}]
[null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(J27:J33)","v":0}]
[]
[4,null,{"$f":"'Project Info'!G54","v":"60% AMI"},"Rent Limit","Contract Rent","Utility Allowance","Gross Rent","# of Units ","Total Beds","Annual Rent"]
[null,null,"Shared bedroom units",null,null,null,{"$f":"E37+F37","v":0},{"$f":"'Project Info'!G55","v":0},{"$f":"'Project Info'!G86","v":0},{"$f":"(E37*I37)*12","v":0}]
[null,null,"SRO",null,null,null,{"$f":"E38+F38","v":0},{"$f":"'Project Info'!G56","v":0},"--",{"$f":"(E38*H38)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,{"$f":"E39+F39","v":0},{"$f":"'Project Info'!G57","v":0},"--",{"$f":"(E39*H39)*12","v":0}]
[null,null,"1 Bedroom",null,null,null,0,{"$f":"'Project Info'!G58","v":0},"--",0]
[null,null,"2 Bedroom",null,null,null,{"$f":"E41+F41","v":0},{"$f":"'Project Info'!G59","v":0},"--",0]
[null,null,"3 Bedroom",null,null,null,{"$f":"E42+F42","v":0},{"$f":"'Project Info'!G60","v":0},"--",0]
[null,null,"4 Bedroom",null,null,null,{"$f":"E43+F43","v":0},{"$f":"'Project Info'!G61","v":0},"--",{"$f":"(E43*H43)*12","v":0}]
[null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(J37:J43)","v":0}]
[]
[5,null,{"$f":"'Project Info'!H54","v":"80% AMI"},"Rent Limit","Contract Rent","Utility Allowance","Gross Rent","# of Units ","Total Beds","Annual Rent"]
[null,null,"Shared bedroom units",null,null,null,{"$f":"E47+F47","v":0},{"$f":"'Project Info'!H55","v":0},{"$f":"'Project Info'!H86","v":0},{"$f":"(E47*I47)*12","v":0}]
[null,null,"SRO",null,null,null,{"$f":"E48+F48","v":0},{"$f":"'Project Info'!H56","v":0},"--",{"$f":"(E48*H48)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,{"$f":"E49+F49","v":0},{"$f":"'Project Info'!H57","v":0},"--",{"$f":"(E49*H49)*12","v":0}]
[null,null,"1 Bedroom",null,null,null,0,{"$f":"'Project Info'!H58","v":0},"--",0]
[null,null,"2 Bedroom",null,null,null,{"$f":"E51+F51","v":0},{"$f":"'Project Info'!H59","v":0},"--",0]
[null,null,"3 Bedroom",null,null,null,{"$f":"E52+F52","v":0},{"$f":"'Project Info'!H60","v":0},"--",0]
[null,null,"4 Bedroom",null,null,null,{"$f":"E53+F53","v":0},{"$f":"'Project Info'!H61","v":0},"--",{"$f":"(E53*H53)*12","v":0}]
[null,null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(J47:J53)","v":0}]
[]
[]
[6,null,"Residential Income:",null,null,null,null,"Annual Rental Income",null,{"$f":"J54+J44+J34+J24+J14","v":0}]
[null,null,null,null,null,null,null,"Less Vacancy",0.05,{"$f":"J57*I58","v":0}]
[null,null,null,null,null,null,null,"Effective Gross Rental Income",null,{"$f":"J57-J58","v":0}]
[]
[]
[null,null,"Commercial Income:",null,null,"(average) $ / sq. ft."]
[6,null,"Square Feet:",{"$f":"'Project Info'!F118","v":0},"@   ",null,"       = ","Annual Commercial Rental Income",null,{"$f":"(D63*F63)*12","v":0}]
[null,null,null,null,null,null,null,"Less Vacancy",0.05,{"$f":"J63*I64","v":0}]
[null,null,null,null,null,null,null,"Effective Gross Commercial Rental Income",null,{"$f":"J63-J64","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Amount (annual)"]
[7,null,"Laundry Income:",null,null,null,null,null,"$"]
[]
[{"$f":"A68+1","v":8},null,"Other Income:",null,null,null,"Source",null,null,"Amount (annual)"]
[null,null,null,null,null,null,null,null,"$"]
[null,null,null,null,null,null,null,null,"$"]
[null,null,null,null,null,null,null,null,"$"]
[]
[]
[]
[9,".",null,null,null,null,"Total Effective Gross Income:",null,null,{"$f":"J73+J72+J71+J68+J63+J59","v":0}]
[]
[]
["Operating Expenses"]
[]
[null,"Annual Operating Exp.:",null,null,"Residential","Commercial","Total","Comments"]
[{"$f":"A77+1","v":10},null,"Management Fee",null,null,null,{"$f":"E83+F83","v":0},{"$f":"IF(J77=0,\"\",G83/J77)","v":""},"of total op. Inc."]
[{"$f":"A83+1","v":11},null,"Payroll, Administrative",null,null,null,0]
[12,null,"Payroll Taxes & Benefits, Admin",null,null,null,0]
[13,null,"Legal",null,null,null,0]
[14,null,"Audit",null,null,null,0]
[15,null,"Marketing",null,null,null,0]
[16,null,"Telephone",null,null,null,0]
[17,null,"Office Supplies",null,null,null,{"$f":"E90+F90","v":0}]
[18,null,"Accounting & Data Processing",null,null,null,0]
[19,null,"Other Fees:",null,null,null,0]
[20,null,"Other:",null,null,null,0]
[21,null,"Other:"," ",null,null,0]
[22,null,"Subtotal: Administrative",null,{"$f":"SUM(E83:E94)","v":0},{"$f":"SUM(F83:F94)","v":0},{"$f":"SUM(G83:G94)","v":0}]
[null,null,null,null,""]
[{"$f":"A95+1","v":23},null,"Payroll, Maintenance",null,null,null,{"$f":"E97+F97","v":0}]
[{"$f":"A97+1","v":24},null,"Payroll Taxes & Benefits, Maint",null,null,null,0]
[25,null,"Janitorial Materials",null,null,null,0]
[26,null,"Landscaping",null,null,null,0]
[27,null,"Decorating (inter. only)",null,null,null,0]
[28,null,"Repairs (inter. & ext.)",null,null,null,0]
[29,null,"Elevator Maintenance",null,null,null,0]
[30,null,"Trash Removal",null,null,null,0]
[31,null,"Snow Removal",null,null,null,0]
[32,null,"Extermination",null,null,null,0]
[33,null,"Recreation",null,null,null,0]
[34,null,"Other:",null,null,null,0]
[35,null,"Subtotal: Maintenance",null,{"$f":"SUM(E97:E108)","v":0},{"$f":"SUM(F97:F108)","v":0},{"$f":"SUM(G97:G108)","v":0}]
[null,null,null,null," "]
[{"$f":"A109+1","v":36},null,"Direct Service Staff / Contract staff",null,null,null,{"$f":"E111+F111","v":0}]
[null,null,"Food Supplies",null,null,null,{"$f":"E112+F112","v":0}]
[null,null,"Program Supplies",null,null,null,{"$f":"E113+F113","v":0}]
[null,null,"Subtotal: Resident Services",null,{"$f":"SUM(E111:E113)","v":0},{"$f":"SUM(F111:F113)","v":0},{"$f":"SUM(G111:G113)","v":0}]
[]
[{"$f":"A111+1","v":37},null,"Security",null,null,null,{"$f":"E116+F116","v":0}]
[]
[{"$f":"A116+1","v":38},null,"Electricity",null,null,null,{"$f":"E118+F118","v":0}]
[{"$f":"A118+1","v":39},null,"Natural Gas",null,null,null,{"$f":"E119+F119","v":0}]
[{"$f":"A119+1","v":40},null,"Oil",null,null,null,{"$f":"E120+F120","v":0}]
[{"$f":"A120+1","v":41},null,"Water & Sewer",null,null,null,{"$f":"E121+F121","v":0}]
[{"$f":"A121+1","v":42},null,"Subtotal: Utilities",null,{"$f":"SUM(E118:E121)","v":0},{"$f":"SUM(F118:F121)","v":0},{"$f":"SUM(G118:G121)","v":0}]
[null,null,null,null," "]
[{"$f":"A122+1","v":43},null,"Replacement Reserve",null,null,null,{"$f":"E124+F124","v":0},"Calculated",{"$f":"500*'Project Info'!I62","v":0}]
[null,null,null,null," "]
[{"$f":"A124+1","v":44},null,"Real Estate Taxes",null,null,null,{"$f":"E126+F126","v":0}]
[{"$f":"A126+1","v":45},null,"Other Taxes",null,null,null,{"$f":"E127+F127","v":0}]
[46,null,"Insurance",null,null,null,{"$f":"E128+F128","v":0}]
[47,null,"Mortgage Insurance Premium",null,null,null,{"$f":"E129+F129","v":0}]
[48,null,"Other",null,null,null,{"$f":"E130+F130","v":0}]
[49,null,"Other"]
[50,null,"Subtotal: Taxes, Insurance",null,{"$f":"SUM(E126:E130)","v":0},{"$f":"SUM(F126:F130)","v":0},{"$f":"E132+F132","v":0}]
[{"$f":"A132+1","v":51},null,"Total All Expenses",null,{"$f":"E95+E109+E114+E116+E122+E124+E132","v":0},{"$f":"F95+F109+F114+F116+F122+F124+F132","v":0},{"$f":"G95+G109+G114+G116+G122+G124+G132","v":0}]
[]
[null,null,"Debt Service:",null,null,null,"Annual"]
[null,null,null,null,null,null,"Payment"]
[52,null,"NHHFA Permanent Loan",null,null,null,{"$f":"IF('Closing S&U'!H14<>0,(PMT(('Closing S&U'!G14/12),('Closing S&U'!H14*12),-'Closing S&U'!F14)*12),0)","v":0}]
[{"$f":"A137+1","v":53},null,"Other Permanent Mortgage"]
[null,null,"       Source:",{"$f":"'Closing S&U'!D15","v":0},null,null,{"$f":"IF('Closing S&U'!H15<>0,(PMT(('Closing S&U'!G15/12),('Closing S&U'!H15*12),-'Closing S&U'!F15)*12),0)","v":0}]
[]
[54,null,"Total Debt Service (Annual)",null,null,null,{"$f":"G139+G137","v":0}]
[]
[{"$f":"A141+1","v":55},null,"Net Operating Income",null,null,null,{"$f":"J77-G133","v":0}," (in year one)"]
[]
[{"$f":"A143+1","v":56},null,"Debt Service Coverage Ratio",null,null,null,{"$f":"IF(G141>0,G143/G141,0)","v":0}," (in year one)"]

{"sheet":"Pro Forma","index":5,"n_rows":61,"n_cols":14,"rows_kept":61,"cut":false,"hidden":false,"merged":[[5,12,5,13]]}
[]
[null,"NH Housing Financing Application"]
[null,{"$f":"'Closing S&U'!A2","v":"Un-named Project"}]
[null,"20-Year Operating Proforma (Years 1-5)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Trending Assumptions"]
[null,null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5",null,null,"Vacancy",0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,"Income",0.02]
[null,null,"Effective Gross Income",null,null,{"$f":"'Inc & Exp'!J77","v":0},{"$f":"F9*(1+N8)","v":0},{"$f":"G9*(1+N8)","v":0},{"$f":"H9*(1+N8)","v":0},{"$f":"I9*(1+N8)","v":0},null,null,"Expenses",0.03]
[null,null,"Total Operating Expenses",null,null,{"$f":"'Inc & Exp'!G133","v":0},{"$f":"F10*(1+N9)","v":0},{"$f":"G10*(1+N9)","v":0},{"$f":"H10*(1+N9)","v":0},{"$f":"I10*(1+N9)","v":0}]
[null,null,"NET OPERATING INCOME",null,null,{"$f":"F9-F10","v":0},{"$f":"G9-G10","v":0},0,0,0]
[]
[null,null,"Debt Service",null,null,{"$f":"'Inc & Exp'!G141","v":0},{"$f":"'Inc & Exp'!G141","v":0},{"$f":"'Inc & Exp'!G141","v":0},{"$f":"'Inc & Exp'!G141","v":0},{"$f":"'Inc & Exp'!G141","v":0}]
[null,null,"Debt Service Coverage",null,null,{"$f":"IF(F13>0,F11/F13,\"\")","v":""},{"$f":"IF(G13>0,G11/G13,\"               \")","v":"               "},{"$f":"IF(H13>0,H11/H13,\"               \")","v":"               "},{"$f":"IF(I13>0,I11/I13,\"               \")","v":"               "},{"$f":"IF(J13>0,J11/J13,\"               \")","v":"               "}]
[null,null,"Project Cash Flow",null,null,{"$f":"F11-F13","v":0},{"$f":"G11-G13","v":0},{"$f":"H11-H13","v":0},{"$f":"I11-I13","v":0},{"$f":"J11-J13","v":0}]
[null,null,"Operating Expense Ratio",null,null,{"$f":"F10/F9","v":{"$error":"#DIV/0!"}},{"$f":"G10/G9","v":{"$error":"#DIV/0!"}},{"$f":"H10/H9","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,{"$f":"B2","v":"NH Housing Financing Application"}]
[null,"20-Year Operating Proforma (Years 6-10)"]
[]
[]
[null,null,null,null,null,"Year 6","Year 7","Year 8","Year 9","Year 10"]
[]
[null,null,"Effective Gross Income",null,null,{"$f":"J9*(1+N8)","v":0},{"$f":"F24*(1+N8)","v":0},{"$f":"G24*(1+N8)","v":0},{"$f":"H24*(1+N8)","v":0},{"$f":"I24*(1+N8)","v":0}]
[null,null,"Total Operating Expenses",null,null,{"$f":"J10*(1+N9)","v":0},{"$f":"F25*(1+N9)","v":0},{"$f":"G25*(1+N9)","v":0},{"$f":"H25*(1+N9)","v":0},{"$f":"I25*(1+N9)","v":0}]
[null,null,"NET OPERATING INCOME",null,null,{"$f":"F24-F25","v":0},{"$f":"G24-G25","v":0},{"$f":"H24-H25","v":0},{"$f":"I24-I25","v":0},{"$f":"J24-J25","v":0}]
[]
[null,null,"Debt Service",null,null,{"$f":"'Inc & Exp'!G141","v":0},{"$f":"'Inc & Exp'!G141","v":0},{"$f":"'Inc & Exp'!G141","v":0},{"$f":"'Inc & Exp'!G141","v":0},{"$f":"'Inc & Exp'!G141","v":0}]
[null,null,"Debt Service Coverage",null,null,{"$f":"IF(F28>0,F26/F28,\"\")","v":""},{"$f":"IF(G28>0,G26/G28,\"               \")","v":"               "},{"$f":"IF(H28>0,H26/H28,\"               \")","v":"               "},{"$f":"IF(I28>0,I26/I28,\"               \")","v":"               "},{"$f":"IF(J28>0,J26/J28,\"               \")","v":"               "}]
[null,null,"Project Cash Flow",null,null,{"$f":"F26-F28","v":0},{"$f":"G26-G28","v":0},{"$f":"H26-H28","v":0},{"$f":"I26-I28","v":0},{"$f":"J26-J28","v":0}]
[null,null,"Operating Expense Ratio",null,null,{"$f":"F25/F24","v":{"$error":"#DIV/0!"}},{"$f":"G25/G24","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,{"$f":"B18","v":"NH Housing Financing Application"}]
[null,"20-Year Operating Proforma (Years 11-15)"]
[]
[]
[null,null,null,null,null,"Year 11","Year 12","Year 13","Year 14","Year 15"]
[]
[null,null,"Effective Gross Income",null,null,{"$f":"J24*(1+N8)","v":0},{"$f":"F39*(1+N8)","v":0},{"$f":"G39*(1+N8)","v":0},{"$f":"H39*(1+N8)","v":0},{"$f":"I39*(1+N8)","v":0}]
[null,null,"Total Operating Expenses",null,null,{"$f":"J25*(1+N9)","v":0},{"$f":"F40*(1+N9)","v":0},{"$f":"G40*(1+N9)","v":0},{"$f":"H40*(1+N9)","v":0},{"$f":"I40*(1+N9)","v":0}]
[null,null,"NET OPERATING INCOME",null,null,{"$f":"F39-F40","v":0},{"$f":"G39-G40","v":0},{"$f":"H39-H40","v":0},{"$f":"I39-I40","v":0},{"$f":"J39-J40","v":0}]
[]
[null,null,"Debt Service",null,null,{"$f":"'Inc & Exp'!G141","v":0},{"$f":"'Inc & Exp'!G141","v":0},{"$f":"'Inc & Exp'!G141","v":0},{"$f":"'Inc & Exp'!G141","v":0},{"$f":"'Inc & Exp'!G141","v":0}]
[null,null,"Debt Service Coverage",null,null,{"$f":"IF(F43>0,F41/F43,\"\")","v":""},{"$f":"IF(G43>0,G41/G43,\"               \")","v":"               "},{"$f":"IF(H43>0,H41/H43,\"               \")","v":"               "},{"$f":"IF(I43>0,I41/I43,\"               \")","v":"               "},{"$f":"IF(J43>0,J41/J43,\"               \")","v":"               "}]
[null,null,"Project Cash Flow",null,null,{"$f":"F41-F43","v":0},{"$f":"G41-G43","v":0},{"$f":"H41-H43","v":0},{"$f":"I41-I43","v":0},{"$f":"J41-J43","v":0}]
[null,null,"Operating Expense Ratio",null,null,{"$f":"F40/F39","v":{"$error":"#DIV/0!"}},{"$f":"G40/G39","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,{"$f":"B33","v":"NH Housing Financing Application"}]
[null,"20-Year Operating Proforma (Years 16-20)"]
[]
[]
[null,null,null,null,null,"Year 16","Year 17","Year 18","Year 19","Year 20"]
[]
[null,null,"Effective Gross Income",null,null,{"$f":"J39*(1+N8)","v":0},{"$f":"F54*(1+N8)","v":0},{"$f":"G54*(1+N8)","v":0},{"$f":"H54*(1+N8)","v":0},{"$f":"I54*(1+N8)","v":0}]
[null,null,"Total Operating Expenses",null,null,{"$f":"J40*(1+N9)","v":0},{"$f":"F55*(1+N9)","v":0},{"$f":"G55*(1+N9)","v":0},{"$f":"H55*(1+N9)","v":0},{"$f":"I55*(1+N9)","v":0}]
[null,null,"NET OPERATING INCOME",null,null,{"$f":"F54-F55","v":0},{"$f":"G54-G55","v":0},{"$f":"H54-H55","v":0},{"$f":"I54-I55","v":0},{"$f":"J54-J55","v":0}]
[]
[null,null,"Debt Service",null,null,{"$f":"'Inc & Exp'!G141","v":0},{"$f":"'Inc & Exp'!G141","v":0},{"$f":"'Inc & Exp'!G141","v":0},{"$f":"'Inc & Exp'!G141","v":0},{"$f":"'Inc & Exp'!G141","v":0}]
[null,null,"Debt Service Coverage",null,null,{"$f":"IF(F58>0,F56/F58,\"\")","v":""},{"$f":"IF(G58>0,G56/G58,\"               \")","v":"               "},{"$f":"IF(H58>0,H56/H58,\"               \")","v":"               "},{"$f":"IF(I58>0,I56/I58,\"               \")","v":"               "},{"$f":"IF(J58>0,J56/J58,\"               \")","v":"               "}]
[null,null,"Project Cash Flow",null,null,{"$f":"F56-F58","v":0},{"$f":"G56-G58","v":0},{"$f":"H56-H58","v":0},{"$f":"I56-I58","v":0},{"$f":"J56-J58","v":0}]
[null,null,"Operating Expense Ratio",null,null,{"$f":"F55/F54","v":{"$error":"#DIV/0!"}},{"$f":"G55/G54","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Sheet1","index":6,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Income Limit/Program "]
["LIHTC 20% AMI",null,"NHH AHF Loan"]
["LIHTC 30% AMI","Yes","NHH HOME Loan"]
["LIHTC 40% AMI","No","NHH HOME-ARP Loan"]
["LIHTC 50% AMI",null,"NHH HTF Loan"]
["LIHTC 60% AMI",null,"NHH InvestNH Loan"]
["LIHTC 70% AMI",null,"NHH Other Loan"]
["LIHTC 80% AMI"]
["LIHTC 30% AMI/HTF"]
["LIHTC 50% AMI/LOW HOME"]
["LIHTC 60% AMI/HIGH HOME"]
["LIHTC 20% AMI PBV"]
["LIHTC 30% AMI PBV"]
["LIHTC 40% AMI PBV"]
["LIHTC 50% AMI PBV"]
["LIHTC 20% AMI/HTF PBV"]
["LIHTC 30% AMI/HTF PBV"]
["LIHTC 50% AMI/LOW HOME PBV"]
["LIHTC 30% Section 811"]

{"sheet":"Gap Analysis","index":7,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[{"$f":"'Project Info'!E3","v":0}]
[null,"LIHTC GAP ANALYSIS"]
[]
[]
["Note: For use by NH Housing Only"]
[]
["EQUITY GAP DETERMINATION"]
[]
["Total Sources of Mortgage Debt ",null,null,{"$f":"'Closing S&U'!#REF!+'Closing S&U'!#REF!+'Closing S&U'!#REF!+'Closing S&U'!#REF!+'Closing S&U'!#REF!+'Closing S&U'!#REF!+'Closing S&U'!#REF!+'Closing S&U'!#REF!","v":{"$error":"#REF!"}}]
["Developer fee loan",null,null,{"$f":"'Closing S&U'!#REF!","v":{"$error":"#REF!"}}]
["Grants",null,null,{"$f":"'Closing S&U'!#REF!+'Closing S&U'!#REF!","v":{"$error":"#REF!"}}]
["Other ",null,null,{"$f":"'Closing S&U'!#REF!","v":{"$error":"#REF!"}}]
["     Total Non-Credit Sources of Funds",null,null,{"$f":"SUM(D9:D12)","v":{"$error":"#REF!"}}]
[]
["Total Equity Needed",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["Historic Tax Credits (20% of elig historic basis)",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["     Historic Tax Credit purchase rate:",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["   Calculated Equity from Historic Tax Credits",null,null,{"$f":"C18*C17","v":{"$error":"#REF!"}}]
[]
["Equity Needed from LIHTC",null,null,{"$f":"D15-D19","v":{"$error":"#REF!"}}]
[]
["30 Percent PV Credit Rate","Total Acquis Credit Allowable",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["   Assumed Credit Rate:",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["QCT/DDA Credit Rate Allowed","Yes=1.3, No=0",null,{"$f":"IF(#REF!=\"yes\",1.3,0)","v":{"$error":"#REF!"}}]
["If Yes, Rehab/Construct Basis increased to 130% of Eligible Basis"]
[]
["70 Percent PV Credit Rate","Total Rehab Credit Allowable",null,{"$f":"IF(D26=1.3,+(#REF!*B30*D26),(#REF!*B30))","v":{"$error":"#REF!"}}]
["   Assumed Credit Rate:",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["Total Low Income Tax Credit  - \"Basis Eligible\"",null,null,{"$f":"D29+D23","v":{"$error":"#REF!"}}]
[]
["Low Income Equity Purchase Rate",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Annual Credit Allocation-Maximum Needed",null,null,{"$f":"IF(C34=0,\"\",(D21/C34)/10)","v":{"$error":"#REF!"}}]
[]
["Recommened Credit Allocation:",null,{"$f":"IF(D32>D35,D35,D32)","v":{"$error":"#REF!"}}]
["TOTAL EQUITY FROM LIHTC",null,null,{"$f":"(C37*10)*C34","v":{"$error":"#REF!"}}]
["FINANCING GAP",null,null,{"$f":"'Closing S&U'!E115-D38-D19-D13","v":{"$error":"#REF!"}}]

{"sheet":"Exh A","index":8,"n_rows":135,"n_cols":8,"rows_kept":135,"cut":false,"hidden":true,"merged":[]}
[null,null,"9% credit",null,0.09,null,"Total 9% Basis",{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Credit Rate Assumptions:",null,"4% credit",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,"Total 4% Basis",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,"Month of Lock In (for 4% Acq. Credits)",null,{"$f":"1/2020","v":"00:00:42.772"},null,"Total # of Buildings",{"$f":"'Project Info'!I105","v":0}]
[]
["Carryover Allocation Agreement - Exhibit A",null,null,null,null,"Table Page 1 of  1"]
[]
["Project Name:",{"$f":"'Project Info'!E3:I3","v":{"$error":"#VALUE!"}}]
[]
["Building BIN #","NH-11-00000","NH-11-00000","NH-11-00000","NH-11-00000","NH-11-00000","NH-11-00000","Total"]
["Building Address or"]
["Site Description"]
[]
["Building Type: New Construction"]
[" Rehab or Acquisition","New Construct",{"$f":"B14","v":"New Construct"},{"$f":"B14","v":"New Construct"},{"$f":"B14","v":"New Construct"},{"$f":"B14","v":"New Construct"},{"$f":"B14","v":"New Construct"}]
[]
["Expected Placed"]
["in Service Date",{"$f":"1/0/0","v":{"$error":"#DIV/0!"}},{"$f":"B17","v":{"$error":"#DIV/0!"}},{"$f":"C17","v":{"$error":"#DIV/0!"}},{"$f":"D17","v":{"$error":"#DIV/0!"}},{"$f":"E17","v":{"$error":"#DIV/0!"}},{"$f":"F17","v":{"$error":"#DIV/0!"}}]
[]
["Reasonably Anticipated"]
["Eligible Basis ",{"$f":"$H$1/$H$3","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["Eligible for DDA/QCT?",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"B22","v":{"$error":"#REF!"}},{"$f":"C22","v":{"$error":"#REF!"}},{"$f":"D22","v":{"$error":"#REF!"}},{"$f":"E22","v":{"$error":"#REF!"}},{"$f":"F22","v":{"$error":"#REF!"}}]
["Adjusted Eligible Basis",{"$f":"IF(B22=\"yes\",($A$24*B20),B20)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[1.3]
["Estimated Applicable"]
["Fraction**",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"B26","v":{"$error":"#REF!"}},{"$f":"B26","v":{"$error":"#REF!"}},{"$f":"B26","v":{"$error":"#REF!"}},{"$f":"B26","v":{"$error":"#REF!"}},{"$f":"B26","v":{"$error":"#REF!"}}]
[]
["Estimated Qualified Basis",{"$f":"B23*B26","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["Maximum Credit Percentage ***",{"$f":"$E$1","v":0.09},0.09,0.09,0.09,0.09,0.09]
[]
["Maximum Credit Allocated ****",{"$f":"ROUND((B30*B28),0.1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(B32:G32)","v":{"$error":"#REF!"}}]
[]
["Maximum Credit Calculated",{"$f":"B30*B28","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(B34:G34)","v":{"$error":"#REF!"}}]
["* Required to be provided only if the owner has elected to fix the credit percentage pursuant to Section 42(b)(2)(A)(ii)(I)."]
[]
["**If provided, these figures are estimates for computation purposes only.  For purposes of the Carryover Allocation Agreement, \"reasonably expected basis\""]
["pursuant to Section 42(h)(1)(E)(ii) need not be the same as eligible basis and is computed for an entire project, rather than building by building."]
[]
["***If the Owner has elected to fix the credit percentage pursuant to Section 42(b)(2)(A)(ii)(I), this credit percentage is fixed and binding upon all buildings"]
["in the project with respect to which the election is made, and upon the Owner and all successors as Owners of those buildings"]
["in the project.  If no such election has been made, this credit percentage is an estimate for purposes of making the Carryover Allocation Agreement."]
[]
["****If a separate housing credit dollar amount is not identified with respect to each building in the project, this allocation is made on a project basis pursuant to"]
["Section 42(h)(1)(F) of the Code."]
[]
[]
[]
["Carryover Allocation Agreement - Exhibit A",null,null,null,null,"Table Page 2 of  3"]
[]
["Project Name:",{"$f":"B7","v":{"$error":"#VALUE!"}}]
[]
["Building BIN #","NH-07-00000","NH-07-00000","NH-07-00000","NH-07-00000","NH-07-00000","NH-07-00000","Total"]
["Building Address or"]
["Site Description"]
[]
["Building Type: New Construction"]
[" Rehab or Acquisition","New Construct","New Construct","New Construct","New Construct","New Construct","New Construct"]
[]
["Expected Placed"]
["in Service Date",{"$f":"B17","v":{"$error":"#DIV/0!"}},{"$f":"B61","v":{"$error":"#DIV/0!"}},{"$f":"C61","v":{"$error":"#DIV/0!"}},{"$f":"D61","v":{"$error":"#DIV/0!"}},{"$f":"E61","v":{"$error":"#DIV/0!"}},{"$f":"F61","v":{"$error":"#DIV/0!"}}]
[]
["Reasonably Anticipated"]
["Eligible Basis ",{"$f":"$H$1/$H$3","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["Eligible for DDA/QCT?",{"$f":"B22","v":{"$error":"#REF!"}},{"$f":"B66","v":{"$error":"#REF!"}},{"$f":"C66","v":{"$error":"#REF!"}},{"$f":"D66","v":{"$error":"#REF!"}},{"$f":"E66","v":{"$error":"#REF!"}},{"$f":"F66","v":{"$error":"#REF!"}}]
["Adjusted Eligible Basis",{"$f":"IF(B66=\"yes\",($A$24*B64),B64)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[1.3]
["Estimated Applicable"]
["Fraction**",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"B70","v":{"$error":"#REF!"}},{"$f":"B70","v":{"$error":"#REF!"}},{"$f":"B70","v":{"$error":"#REF!"}},{"$f":"B70","v":{"$error":"#REF!"}},{"$f":"B70","v":{"$error":"#REF!"}}]
[]
["Estimated Qualified Basis",{"$f":"B67*B70","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["Maximum Credit Percentage ***",{"$f":"$E$1","v":0.09},{"$f":"$E$1","v":0.09},0.09,0.09,0.09,0.09]
[]
["Maximum Credit Allocated ****",{"$f":"ROUND((B74*B72),0.1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(B76:G76)","v":{"$error":"#REF!"}}]
[]
["Maximum Credit Calculated",{"$f":"B74*B72","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(B78:G78)","v":{"$error":"#REF!"}}]
["* Required to be provided only if the owner has elected to fix the credit percentage pursuant to Section 42(b)(2)(A)(ii)(I)."]
[]
["**If provided, these figures are estimates for computation purposes only.  For purposes of the Carryover Allocation Agreement, \"reasonably expected basis\""]
["pursuant to Section 42(h)(1)(E)(ii) need not be the same as eligible basis and is computed for an entire project, rather than building by building."]
[]
["***If the Owner has elected to fix the credit percentage pursuant to Section 42(b)(2)(A)(ii)(I), this credit percentage is fixed and binding upon all buildings"]
["in the project with respect to which the election is made, and upon the Owner and all successors as Owners of those buildings"]
["in the project.  If no such election has been made, this credit percentage is an estimate for purposes of making the Carryover Allocation Agreement."]
[]
["****If a separate housing credit dollar amount is not identified with respect to each building in the project, this allocation is made on a project basis pursuant to"]
["Section 42(h)(1)(F) of the Code."]
[]
[]
[]
[]
[]
["Carryover Allocation Agreement - Exhibit A",null,null,null,null,"Table Page 3 of  3"]
[]
["Project Name:",{"$f":"B7","v":{"$error":"#VALUE!"}}]
[]
["Building BIN #","NH-07-00000","NH-07-00000","NH-07-00000","NH-07-00000","NH-07-00000","NH-07-00000","Total"]
["Building Address or"]
["Site Description"]
[]
["Building Type: New Construction"]
[" Rehab or Acquisition","New Construct","New Construct","New Construct","New Construct","New Construct","New Construct"]
[]
["Expected Placed"]
["in Service Date",{"$f":"B61","v":{"$error":"#DIV/0!"}},{"$f":"B107","v":{"$error":"#DIV/0!"}},{"$f":"C107","v":{"$error":"#DIV/0!"}},{"$f":"D107","v":{"$error":"#DIV/0!"}},{"$f":"E107","v":{"$error":"#DIV/0!"}},{"$f":"F107","v":{"$error":"#DIV/0!"}}]
[]
["Reasonably Anticipated"]
["Eligible Basis ",{"$f":"$H$1/$H$3","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["Eligible for DDA/QCT?",{"$f":"B66","v":{"$error":"#REF!"}},{"$f":"B112","v":{"$error":"#REF!"}},{"$f":"C112","v":{"$error":"#REF!"}},{"$f":"D112","v":{"$error":"#REF!"}},{"$f":"E112","v":{"$error":"#REF!"}},{"$f":"F112","v":{"$error":"#REF!"}}]
["Adjusted Eligible Basis",{"$f":"IF(B112=\"yes\",($A$24*B110),B110)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[1.3]
["Estimated Applicable"]
["Fraction**",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["Estimated Qualified Basis",{"$f":"B113*B116","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["Maximum Credit Percentage ***",{"$f":"$E$1","v":0.09},0.09,0.09,0.09,0.09,0.09]
[]
["Maximum Credit Allocated ****",{"$f":"ROUND((B120*B118),0.1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(B122:G122)","v":{"$error":"#REF!"}}]
[]
["Maximum Credit Calculated",{"$f":"B120*B118","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(B124:G124)","v":{"$error":"#REF!"}}]
["* Required to be provided only if the owner has elected to fix the credit percentage pursuant to Section 42(b)(2)(A)(ii)(I)."]
[]
["**If provided, these figures are estimates for computation purposes only.  For purposes of the Carryover Allocation Agreement, \"reasonably expected basis\""]
["pursuant to Section 42(h)(1)(E)(ii) need not be the same as eligible basis and is computed for an entire project, rather than building by building."]
[]
["***If the Owner has elected to fix the credit percentage pursuant to Section 42(b)(2)(A)(ii)(I), this credit percentage is fixed and binding upon all buildings"]
["in the project with respect to which the election is made, and upon the Owner and all successors as Owners of those buildings"]
["in the project.  If no such election has been made, this credit percentage is an estimate for purposes of making the Carryover Allocation Agreement."]
[]
["****If a separate housing credit dollar amount is not identified with respect to each building in the project, this allocation is made on a project basis pursuant to"]
["Section 42(h)(1)(F) of the Code."]

{"sheet":"Risk Sharing","index":9,"n_rows":341,"n_cols":3,"rows_kept":341,"cut":false,"hidden":true,"merged":[]}
["NHHFA","Sources and Uses of Funds"]
["Section 911 Subsidy Layering Review"]
[]
["Project Name:",{"$f":"'Project Info'!E3","v":0}]
["NHHFA Project No.:"]
[]
["SOURCES"]
["Debt Sources:"]
["HUD Loans/programs (HOME)"]
["Other Government Assistance"]
["Other Loans"]
["   NHHFA Tax Exempt Bond",0]
["   Deferred Developer Fee",0]
["   Other"]
["Debt Subtotal",0]
[]
["Equity:"]
["Grants"]
["Estimated Net Syndication Proceeds",0]
["Additional Sponsor Equity - Investsment Earnings",0]
["Other Equity Sources"]
["Equity Subtotal",0]
["TOTAL SOURCES",0]
[]
[]
["USES"]
[]
["Mortgageable Replacement Cost Uses"]
["Acquisition",0]
["Construction",0]
["General Requirements","included in construction estimate"]
["Builders General Overhead","included in construction estimate"]
["Construction Contingency","included in construction estimate"]
["Furnishings, Fixtures and Equipment","included in construction estimate"]
["Permits",0]
["Architect",0]
["Engineer",0]
["Construction Administration/Consulting",0]
["Origination Fee",0]
["Construction Interest",0]
["Construction Insurance",0]
["Bond Issuance",0]
["Credit Enhancement ",0]
["Transfer Tax",0]
["Title Ins. and Recording",0]
["Tax Credit Fee",0]
["Lender Legal",0]
["Appraisal",0]
["Market Study",0]
["Environmental Report",0]
["Survey",0]
["Legal",0]
["Accounting",0]
["Taxes",0]
["Insurance",0]
["Soft Cost Contingency",0]
["Rent Up Reserve",0]
["Relocation",0]
["Marketing Reserve",0]
["Replacement Reserve",0]
["Asbestos Removal",0]
["Prepaid Tax Credit Monitoring Fee",0]
["Subtotal  Mortgageable Replacement Cost Uses",0]
[]
["Non-Mortgageable Replacement Cost Uses"]
[]
["Working Capital Reserve"]
["Operating Deficit Reserve",0]
[]
["Developer Fee",0]
["Subtotal  Non-Mortgageable Uses",0]
[]
["Total Uses",0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NEW HAMPSHIRE HOUSING FINANCE AUTHORITY"]
["SECTION 911 SUBSIDY LAYER REVIEW"]
[null,0]
["STANDARD 1:  BUILDERS PROFIT"]
[]
["Project Name",0]
["NHHFA Project No.",0]
[]
["Identity of Interest","No"]
["NCSHA Standards for Tax Credit Administration","Yes"]
["NHHFA Tax Credit Allocation Plan","Yes"]
[]
["Construction Costs (everything)",0]
[]
["See Note below"]
["DETERMINATION:","Actual","Maximum"]
[]
["General Conditions"]
["Percent of Construction Costs"]
["Builder's Overhead"]
["Percent of Construction Costs"]
["Builder's Profit"]
["Percent of Construction Costs"]
[]
["Note: Project not yet bid."]
[]
[]
[]
[]
[]
["NEW HAMPSHIRE HOUSING FINANCE AUTHORITY"]
["SECTION 911 SUBSIDY LAYERING REVIEW"]
[null,0]
["STANDARD 2: DEVELOPER'S FEE"]
[]
["Project Name:",null,0]
["NHHFA Project No.:",null,0]
[]
["Identity of Interest:",null,"No"]
["NHHFA Tax Credit Allocation Plan:",null,"Yes"]
[]
["Total Rehab/Const Cost",null,0]
["Total Development Cost",null,0]
["    less Developer fee in Budget",null,0]
["Adjusted Total Development Cost",null,0]
["Adjusted Rehab/Const Cost:",null,0]
[]
["Percent Rehabilitation to Adjusted TDC",null,"ERR"]
[]
["See Attached NHHFA QAP Developer Fee Schedule for Project"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["STANDARD 3: SYNDICATION EXPENSES"]
[]
["Project Name:",0]
["NHHFA Project No.:",0]
[null,0]
[]
["Gross Syndication Proceeds:",0]
["Type of Syndication:"]
[]
["Syndication Expenses:"]
["Commissions/Finders Fees:"]
["Consultant's Fees:"]
["Legal"]
["Accounting"]
["Other"]
["Total Syndication Expenses:",0]
[]
["Net Syndication Proceeds:",0]
[]
["DETERMINATION:","Actual","Maximum Allowed"]
["Total Syndication Expenses:",0,0]
["Percent of Gross Syndication Proceeds","ERR","ERR"]
[]
[]
[]
[]
[]
[]
[]
[]
["SECTION 542(C)","DATA ELEMENTS"]
["(Risk Sharing Program)","APPENDIX 11"]
[]
["HOUSING FINANCE AGENCY INFORMATION"]
["HFA:","New Hampshire Housing Finance Authority"]
["Contact:"]
["Phone:"]
[]
["Project Name:"]
["Project Number:"]
["Project Number - Section 8:"]
["City:"]
["Street Address"]
["State"]
["Zip Code"]
["Congressional District"]
["Project Census Tract"]
["Project County Code"]
["PMSA"]
["Superseded Project No.  :"]
["Mortgage Amount"]
["Total Number of Units"]
["Number of Section 8 Units"]
["Occupant type"]
["Sponsor/Mortgagor Type"]
["Production Method"]
[]
[]
[]
[]
["Initial Endorsement:"]
["Final Endorsement:"]
["Addendum to the Risk Sharing Agreement:"]
[]
["# Units Affordable by families at:"]
["50% median income      #units"]
["50% median income      %units"]
["60% median income      #units"]
["60% median income      %units"]
[]
["Type of Building"]
["Total Buildings in Project"]
["Year Built"]
["Unit Type (#of bedrooms)"]
["Units Efficiency"]
["Units One Bedroom"]
["Units Two Bedroom"]
["Units Three Bedroom"]
["Four Plus Bedroom"]
["Units Elderly"]
["Units Handicapped"]
["Non-revenue Units"]
["Units - Total"]
["SRO"]
["B&C"]
["Non-Elderly"]
["Commercial Square FT"]
["Elevator"]
["Non-Elevator"]
["Replacement Cost    $"]
["Acquisition Cost   $"]
["Per Unit Per Annum Expenses"]
["Total annual project expense"]
["Debt Service Coverage"]
["Loan to Value Ratio"]
["Loan to Replacement Cost"]
["Mortgagor Name"]
["Type of Permanent Financing Code"]
["Bond Interest Rate"]
["Variable Bond Rate"]
["Maturity Date"]
["Mortgage Term in Months"]
["Holding Mortgagee Number"]
["Servicing Mortgagee Number"]
["1st MIP Paid Amount"]
["1st Payment Date"]
["Financed with/Tax Exempt Bonds"]
["Tax Credit Financing"]
["Special Financing Grants and Loans"]
["Federal Loans"]
["Federal Grants"]
["State Loans"]
["State Grants"]
["Local Loans"]
["Local Grants"]
["Other with remarks"]
["Mortgage Insurance Premium"]
["Total HFA's Fees "]
["Other Fees, if any "]
["Initial Operating Deficit",0]
["Term of Deficit Escrow in months",0]
[]
["THIS INFORMATION WILL BE PUT INTO THE SYSTEM BY FO STAFF BASED ON"]
["INFORMATION RECEIVED FROM HFAs AT REQUEST FOR HUD-RETAINED REVIEW"]
["PROJECT SPECIFIC INFORMATION"]
[]
["PROCESSING STAGE"]
[]
["HUD Regional Office:","HUD ENTERED"]
["HUD Office Jurisdiction:","HUD ENTERED"]
["Designated HUD Field Office:","HUD ENTERED"]
["Date of Request for HUD","HUD ENTERED"]
["Retained Reviews:","HUD ENTERED","Date project proposal submitted to HUD"]
[]
["Section of Act:",null,"YHA/YHB/YHD"]
["Project Name:"]
["Project Number:"]
["Project Number - Section 8:"]
["City:"]
["Street Address"]
["State"]
["Zip Code"]
["Congressional District"]
["Project Census Tract"]
["Project County Code"]
["PMSA"]
["Superseded Project No.  :"]
["Mortgage Amount"]
["Total Number of Units"]
["Number of Section 8 Units"]
["Occupant type"]
["Sponsor/Mortgagor Type"]
["Production Method"]
["Military Impact Area"]
["Previous Participation (Approved/Disapproved)",null,"A or D"]
["Previous Participation Date:",null,"Date"]
["Environmental Review (Approved/Disapproved)",null,"A or D"]
["Environmental Review Date:",null,"Date"]
["Intergovernmental Review:",null,"Intergovernmental Review  (one date - four codes)"]
["Intergovernmental Review Date:",null,"1 - N/A"]
[null,null,"2 - No Objections"]
[null,null,"3 - Objections Resolved"]
[null,null,"4 - Objections Not Resolved"]
["Market Comments:"]
[]
["Market Comments Date:"]
["Subsidy Layering Review:"]
["Subsidy Layering Review  Date:"]
[" Date of HUD Firm Approval Letter:"]
["Application Rejected Date:"]
[" HFA Withdrew Application Date:"]
[" Reopen Reject Date:"]
[]
["Initial Endorsement Date, if applicable:"]
["Final Endorsement Date:","n/a"]
["Remarks - Housing Development"]
["Risk Apportionment Percentage:",null,"HFA %"]

{"sheet":"Change Log","index":10,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Change Date","Item","Notes"]
["2019-02-21","Fixed Control C macro error","No more errors,  Ctrl+c now works."]
["2019-02-21","Renamed tabs to ease navigation & colored based on project type","Not married to these names, however, we should be more descriptive on what the tabs are"]
["2019-02-21","Added instruction tab","This will help alleviate some questions on what to fill out for different project types"]
["2018-04-09","Updated tabs for income averaging"]
["2018-04-09","Changed active X controls","Application can be edited online now"]
["2019-04-09","Deleted print summary tab"]
["2019-04-09","Increased the developer fee 12%","Cleaned up writing on tab, naming of project type. Will delete on publishing."]
["2019-04-09","Change font on application tabs"]
["2019-04-15","Changes to the Gap Analysis tab & Exh A "]
["2019-04-15","Add additional cagetories to professional fees.  Renamed category."]
["2019-04-15","Added upfront MIP, trustee fee, and application fee to Financing Fees and Expenses"]
["2019-04-23","Split financial page into three tabs"]
["2019-04-23","Updated income bands on rent tab to auto poplulate"]
["2019-04-23","Cleaned up broken links, formulas.  "]
["2019-04-23","Updated construction tab for a 24 month construction period."]
["2019-04-30","Updated LIHTC boost language rows 14 & 20 on the LIHTC tab"]
["2019-04-30","Moved basis/not in basis warning to top of development budget/basis calculation section."]
["2019-04-30","Added row 31 & 31 on the LIHTC tab"]
["2019-04-30","Broke out equity types in sources.  Linked to LIHTC tab.  "]
["2019-04-30","Removed reference to max LIHTC's for a GO."]
["2019-04-30","Removed developer fee calc on Closing S&U tab - was only pulling GO"]
["2019-04-30","Added TDC/Basis warning calc to LIHTC tab"]
["2019-04-30","Added % of TDC for budget categories - Closing S&U tab ","These are hidden unless the category has information filled out."]
["2019-05-02","Added choice for propane or natural gas on line 22 of Project Info."]
["2019-05-02","Added FFB Operating Reserve to line 126 of Closing S&U tab"]
["2019-05-02","Corrected cell H157 on the Inc & Exp tab to include the commerical management fee","Discussed with Ginny"]
["2019-05-06","Removed the auto-update for the date."]
["2019-05-06","Update print preview on all tabs."]
["2019-05-06","Updated dev team tab to accommodate an email address for contacts. "]
["2019-05-06","Added energy/solar, and HTC consultant to dev team tab."]
["2019-05-06","Hid the NHHFA-only tabs."]

{"sheet":"Module1","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Module2","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}