{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Instructions","Project Info","Closing S&U","Inc & Exp","Dev Team","Pro Forma","LIHTC Info","Mgt Agt Quest","Const S&U","Dev Fee","Gap Analysis","Exh A","Risk Sharing","Change Log","Module1","Module2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":95,"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":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[[7,2,7,5]]}
[]
[]
[null,"NHHFA Financing Application Instructions:"]
[]
[null,"This financing application has color coded tabs that must be completed, based on the financing type"]
[null,"being requested by the applicant:"]
[]
[null,null,"Type of financing:"]
[null,null,"LIHTC 4%/9%","New Construction/  Sub Rehab","Refinance - No Construction","Refinance - with Construction"]
[null,"Blue Tabs","x","x","x","x"]
[null,"Green Tabs","x"]
[null,"Red Tabs","x","x",null,"x"]
[]
[null,"All sections of the tab are required.  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 and mailed to the Authority along with the applicable application fee."]
[]
[]
[null,"Details for each tab:"]
[]
[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 lists the financing sources and the construction/soft cost uses for closing/"]
[null,null,"construction. "]
[]
[null,"Inc & Exp","This tab captures rent and other income information, and lists the proposed"]
[null,null,"operating budget."]
[]
[null,"Dev Team","This tab captures the members of the project's development team."]
[]
[null,"Pro Forma","This tab is pre-filled, and is used to analyze the income/expense trending."]
[]
[null,"LIHTC Info","This tab is filled out when applying for 4% and/or 9% LIHTC's.  "]
[]
[null,"Mgt Agt Quest","This tab is filled out when applying for 9% LIHTC's."]
[]
[null,"Const S&U","This tab should be filled out when monthly construction draws are anticipated,"]
[null,null,"usually in conjunction with a CM or GC monthly draw schedule."]
[]
[null,"Dev Fee","This tab is used to calculate the maximum developer fee, based on occupancy type"]
[null,null,"and the level of rehabilitation."]

{"sheet":"Project Info","index":1,"n_rows":326,"n_cols":15,"rows_kept":326,"cut":false,"hidden":false,"merged":[[171,3,173,8],[3,4,3,8],[4,4,4,8],[5,4,5,6],[36,2,43,8],[244,4,244,8],[246,4,246,8],[247,4,248,8],[175,3,177,8],[179,3,181,8],[184,3,185,8],[240,4,240,5],[205,2,206,8],[195,5,195,8]]}
["PROJECT INFORMATION"]
[]
[]
[1,".","Project Name:"]
[{"$f":"A4+1","v":2},".","Project Address:"]
[{"$f":"A5+1","v":3},".","Project Community:",null,null,null,null,"                NH"]
[null,null,null,null,"                                    (city/town)",null,null,"(state)","(zip code)"]
[]
[null,null,null,null,null,null,null,"Date Application Values Entered",{"$f":"TODAY()","v":"2022-05-18"}]
[]
["Development Plan"]
[]
[{"$f":"A6+1","v":4},".","Development Type (please check all that apply):"]
[null,{"$f":"IF(LEN(TRIM(G14))>0,1,0)","v":{"$error":"#VALUE!"}},"   New construction",null,null,null,null,"Mark with an \"X\""]
[null,{"$f":"IF(LEN(TRIM(G15))>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(G16))>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(G17))>0,1,0)","v":{"$error":"#VALUE!"}},"   Refinancing of residential property to extend affordability",null,null,null,null,"Mark with an \"X\""]
[null,{"$f":"IF(LEN(TRIM(G18))>0,1,0)","v":{"$error":"#VALUE!"}},"   Other",null,null,null,null,"Mark with an \"X\""]
[null,null," ",null,null,null," "]
[{"$f":"A13+1","v":5},".","Proposed Housing Type (please check one box):",null,null,null," "]
[null,{"$f":"IF(LEN(TRIM(G21))>0,1,0)","v":{"$error":"#VALUE!"}},"   Rental (except SRO or Assisted Living, see below)",null,null,null,null,"Mark with an \"X\""]
[null,{"$error":"#VALUE!"},"   Limited Equity Cooperative",null,null,null,null,"Mark with an \"X\""]
[null,{"$error":"#VALUE!"},"   Manufactured Housing Rental Park",null,null,null,null,"Mark with an \"X\""]
[null,{"$error":"#VALUE!"},"   Single Room Occupancy (SRO)",null,null,null,null,"Mark with an \"X\""]
[null,{"$error":"#VALUE!"},"   Assisted Living",null,null,null,null,"Mark with an \"X\""]
[null,{"$error":"#VALUE!"},"   Other:",null,null,null,null,"Mark with an \"X\""]
[]
[6,null,"Project Age Designation (choose one box only):"]
[null,null,"  General Occupancy (No age restriction)",null,null,null,null,"Mark with an \"X\""]
[null,null,"  Age-Restricted (62+, LIHTC)",null,null,null,null,"Mark with an \"X\""]
[null,null,"  Age-Restricted (other, no LIHTC)",null,null,null,null,"Mark with an \"X\""]
[null,null," "]
[{"$f":"A28+1","v":7},".","Project Description:"]
[null,null,"Please describe the proposed project in a few sentences.  Indicate whom the"]
[null,null,"project is designed to serve.  Describe the current condition of the site and its"]
[null,null,"ownership.  Note whether the site is distressed. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"A33+1","v":8},".","Development Schedule:",null,null,"Projected Dates"]
[null,null,null,null,null,"MM/YYYY"]
[null,{"$f":"IF(LEN(FIXED(G48,0,TRUE))<4,+G48+1900,+G48)","v":1900},"Construction Loan Closing"]
[null,1900,"Construction Start",null,null,null,null,{"$f":"IF(F49+G49=0,\"\",IF(F49>12,\"Use month number from 1 to 12\",IF(B49<1900+(YEAR(TODAY())-1900),\"year should be \"&FIXED(1900+(YEAR(TODAY())-1900),0,TRUE)&\" or later\",\"\")))","v":""}]
[null,1900,"50% Construction Completion",null,null,null,null,""]
[null,1900,"Construction Completion",null,null,null,null,null,null,null,null,null,null,{"$f":"G51","v":0}]
[null,1900,"First Certificate of Occupancy",null,null,null,null,""]
[null,1900,"Final Certificate of Occupancy",null,null,null,null,""]
[null,1900,"Permanent Loan Closing",null,null,null,null,""]
[null,1900,null,null,null,null,null,""]
[]
[]
[]
[{"$f":"A46+1","v":9},".","Unit Mix: "]
[]
[null,null,null,"LIHTC  Band"]
[null,null,null,"Market Rate","LIHTC","LIHTC","LIHTC","LIHTC","Low HOME","High HOME","HTF","811 units","Rental Assisted","Total"]
[null,null,"SRO",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D63:M63)","v":0}]
[null,null,"0 Bedrooms",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"1 Bedrooms",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"2 Bedrooms",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D66:M66)","v":0}]
[null,null,"3 Bedrooms",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"4+ Bedrooms",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Total Units",{"$f":"SUM(D63:D68)","v":0},{"$f":"SUM(E63:E68)","v":0},{"$f":"SUM(F63:F68)","v":0},0,{"$f":"SUM(H63:H68)","v":0},0,0,{"$f":"SUM(K63:K68)","v":0},0,0,0]
[]
[null,null,"BR Count",{"$f":"(D63*1)+(D64*1)+(D65*1)+(D66*2)+(D67*3)+(D68*4)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(D71:M71)","v":0}]
[]
[{"$f":"A59+1","v":10},".","Unit Size (Indicate the average size of units, in square feet, by bedroom size and income):"]
[]
[null,null,null,{"$f":"D61","v":"LIHTC  Band"},{"$f":"E61","v":0},0,0,0," "," "," "," "," "]
[null,null,null,{"$f":"D62","v":"Market Rate"},"LIHTC","LIHTC","LIHTC","LIHTC",{"$f":"I62","v":"Low HOME"},{"$f":"J62","v":"High HOME"},{"$f":"K62","v":"HTF"},{"$f":"L62","v":"811 units"},{"$f":"M62","v":"Rental Assisted"}]
[null,null,"0 Bedrooms"]
[null,null,"1 Bedrooms"]
[null,null,"2 Bedrooms"]
[null,null,"3 Bedrooms"]
[null,null,"4+ Bedrooms"]
[]
[{"$f":"A73+1","v":11},".","Bathroom facilities (indicate the number of bathrooms in each of the units):"]
[]
[null,null,null,{"$f":"D61","v":"LIHTC  Band"},{"$f":"E61","v":0},{"$f":"F61","v":0},{"$f":"G61","v":0},{"$f":"H61","v":0}," "," "," "," "," "]
[null,null,null,{"$f":"D76","v":"Market Rate"},"LIHTC","LIHTC","LIHTC","LIHTC","Low HOME","High HOME","HTF","811 units","Rental Assisted"]
[null,null,"0 Bedrooms",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D87:M87)","v":0}]
[null,null,"1 Bedrooms",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D88:M88)","v":0}]
[null,null,"2 Bedrooms",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D89:M89)","v":0}]
[null,null,"3 Bedrooms",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D90:M90)","v":0}]
[null,null,"4+ Bedrooms",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D91:M91)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total BR",{"$f":"SUM(N87:N91)","v":0}]
[{"$f":"A83+1","v":12},".","Funding Applied For:"]
[null,null,"Please check all the funding that is being applied for at this time, with this application:",null,null,null,null,null,null,null,"NHHFA  Debt/Capital Subsidy Financing"]
[]
[null,null,"Low Income Housing Tax Credit Allocation",null,null,"Mark with an \"X\"",null,null,null,null," Permanent Financing - Authority Funds",null,null,null,"Mark with an \"X\""]
[null,null,"Tax Exempt Bond-Related",null,null,"Mark with an \"X\"",null,null,null,null," Permanent Financing - Tax Exempt Bond",null,null,null,"Mark with an \"X\""]
[null,null,"Regular NHHFA Allocation",null,null,"Mark with an \"X\"",null," (See NHHFA QAP)",null,null," Permanent Financing - Taxable Bond",null,null,null,"Mark with an \"X\""]
[null,null,"Initial Application",null,null,"Mark with an \"X\"","Carryover",null,"Mark with an \"X\"",null," Construction Financing - Authority Funds",null,null,null,"Mark with an \"X\""]
[null,null,"Commitment",null,null,"Mark with an \"X\"","Final Allocation",null,"Mark with an \"X\""]
[null,null,null,null,null,null,null,null,null,null,"Capital Subsidy Funding through NHHFA",null,null,null,"Mark with an \"X\""]
[null,{"$f":"IF(LEN(TRIM(E102))>0,1,0)","v":{"$error":"#VALUE!"}},"Project Based Vouchers",null,null,"Mark with an \"X\""]
[]
[]
[]
[null,null,null,null,"New"," ","Existing/"," "," "]
[{"$f":"A93+1","v":13},".","Number of buildings planned:",null,"Construction",null,"Rehabilitation",null,"Total"]
[null,null,"       a.  Single-family",null,null,null,null,null,{"$f":"E108+G108","v":0}]
[null,null,"       b.  2-4 family",null,null,null,null,null,0]
[null,null,"       c.  Townhouse",null,null,null,null,null,0]
[null,null,"       d.  Low/Mid rise",null,null,null,null,null,0]
[null,null,"       e.  High-rise",null,null,null,null,null,0]
[null,null,"       f.   Other",null,null,null,null,null,0]
[null,null,"       TOTAL",null,{"$f":"SUM(E108:E113)","v":0},null,{"$f":"SUM(G108:G113)","v":0},null,0]
[]
[null,null,null,null,"Yes",null,"No"]
[14,".","Scattered Sites:"]
[]
[15,".","Number of units:",null,null,null,null,null,{"$f":"E119+G119","v":0}]
[]
[{"$f":"A119+1","v":16},".","Gross Square Footage"]
[null,null,"     a.  Residential",null,null,null,null,null,{"$f":"E122+G122","v":0}]
[null,null,"     b.  Commercial",null,null,null,null,null,{"$f":"E123+G123","v":0}]
[]
[{"$f":"A121+1","v":17},".","Net Rentable Square Footage:",null,null,"Total",null,"Percent of Gross"]
[null,null,"     a.  Residential",null,null,null," s.f.",{"$f":"IF(I122>0,F126/I122,\"                     \")","v":"                     "}]
[null,null,"     b.  Commercial",null,null,null," s.f.",{"$f":"IF(F127>0,IF(I123>0,F127/I123,\"                        \"),\"             \")","v":"             "}]
[]
[{"$f":"A125+1","v":18},".","Number of accessible units"]
[]
[{"$f":"A129+1","v":19},".","Fire Code Type (check):"]
[null,null,"       a.  Concrete frame",null,null," (Mark one box with an \"X\")",null,{"$f":"IF(E132<>\" \",1,0)","v":0}]
[null,null,"       b.  Wood frame",null,null," (Mark one box with an \"X\")",null,{"$f":"IF(E133<>\" \",1,0)","v":0}]
[null,null,"       c.  Protected steel",null,null," (Mark one box with an \"X\")",null,{"$f":"IF(E134<>\" \",1,0)","v":0}]
[null,null,"       d.  Masonry bearing wall",null,null," (Mark one box with an \"X\")",null,{"$f":"IF(E135<>\" \",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(F137=\"yes\",F137=\"y\"),\"How Many?\",\"\")","v":"How Many?"}]
[{"$f":"A131+1","v":20},".","Will buildings include elevators?",null,null,null," (\"yes\" or \"no\")","If yes, number:"]
[]
[{"$f":"A137+1","v":21},".","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":"A139+1","v":22},".","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,null,null,null,"Hot Water:"]
[{"$f":"A151+1","v":23},".","Type of heating fuel:",null,null,"Propane",{"$f":"IF(E158<>\" \",1,0)","v":0},null,"Propane"]
[null,null,"                   (Check one with \"X\")",null,null,"Natural Gas",{"$f":"IF(E159<>\" \",1,0)","v":0},null,"Natural Gas"]
[null,null,null,null,null,"Oil",{"$f":"IF(E160<>\" \",1,0)","v":0},null,"Oil"]
[null,null,null,null,null,"Electric",{"$f":"IF(E161<>\" \",1,0)","v":0},null,"Electric"]
[]
[{"$f":"A158+1","v":24},".","No. of parking spaces:",null,null,null,null,null,{"$f":"IF(E163+G163=0,0,(E163+G163))","v":0}]
[null,null,null,null,"Enclosed",null,"Outdoor",null,"Total"]
[]
[]
[{"$f":"A163+1","v":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 as Exhibit 29.)"]
[]
[{"$f":"A167+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":"A170+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":"A184+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 present zoning permit the proposed development?",null,null,null,null,null," (\"yes\" or \"no\")",{"$f":"IF(OR(H223=\"yes\",H223=\"no\"),1,0)","v":1}]
[null,null," Please attach evidence of present zoning (Exhibit 19), including zoning map and"]
[null,null," regulations.   Highlight any special use or dimensional restrictions on the property."]
[]
[{"$f":"A223+1","v":38},".","If the present zoning does not allow for the proposed use as designed, has the needed zoning"]
[null,null,"change/variance/special permit/subdivision approval been obtained?",null,null,null,null,null," (\"yes\" or \"no\")"]
[null,null,"If not, please attach (as part of Exhibit 19) the current status and"]
[null,null,"current schedule for obtaining necessary approval."]
[]
[{"$f":"A227+1","v":39},".","Are any other efforts for local approvals being undertaken?",null,null,null,null,null," (\"yes\" or \"no\")"]
[null,null,"If yes, please attach (as part of Exhibit 19) the current status and anticipated"]
[null,null,"schedule for such efforts."]
[]
[null,null,"Site Control:"]
[{"$f":"A232+1","v":40},".","What form of site control do you have?  ",null,null,null," (Mark one box)"]
[null,{"$f":"IF(LEN(TRIM(H238))>0,1,0)","v":1},null,null,"Ownership ",null,null," (Mark one box with an \"X\")"]
[null,{"$f":"IF(LEN(TRIM(H239))>0,1,0)","v":1},null,null,"Purchase and Sale Agreement(s) ",null," "," (Mark one box with an \"X\")"]
[null,{"$f":"IF(LEN(TRIM(H240))>0,1,0)","v":1},null,null,"Option ",null," "," (Mark one box with an \"X\")"]
[null,{"$f":"IF(LEN(TRIM(H241))>0,1,0)","v":1},null,"Other:  ",null,null," "," (Mark one box with an \"X\")"]
[null,null,null,null,null,null,"Include copies of the appropriate site control documents as part of Exhibit 3."]
[]
[{"$f":"A237+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":"A244+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(E254<>\" \",1,0)","v":0}]
[null,null,"    If yes, please attach description as part of Exhibit 10."]
[]
[{"$f":"A253+1","v":43},".","Are there any outstanding liens on the property?",null,null,null,null," (\"yes\" or \"no\")",null,{"$f":"IF(G257<>\" \",1,0)","v":0}]
[]
[]
[null,null,"Amenities and Services:"]
[{"$f":"A257+1","v":44},".","Please indicate distance from site and locate on city/town map (Exhibit 1)."]
[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"]
[]
[]
[]
["Environmental Information"]
[]
[{"$f":"A261+1","v":45},".","Is there any evidence of underground storage tanks or releases of",null,null,null,null,null," (\"yes\" or \"no\")",{"$f":"IF(H277<>\" \",1,0)","v":0}]
[null,null,"oil or hazardous materials, including hazardous wastes, on the site or"]
[null,null,"within close proximity to the site?"]
[]
[{"$f":"A277+1","v":46},".","Has a \"Level 1\" environment assessment, including radon tests,",null,null,null,null,null," (\"yes\" or \"no\")",{"$f":"IF(H281<>\" \",1,0)","v":0}]
[null,null,"been performed ? (If not, NHHFA will commission one.)"]
[null,null,"    (If yes, include a copy with Exhibit 2.)"]
[]
[{"$f":"A281+1","v":47},".","Is there any evidence that the premises contain lead paint?",null,null,null,null,null," (\"yes\" or \"no\")",{"$f":"IF(H285<>\" \",1,0)","v":0}]
[null,null,"   (If yes, then a lead paint inspection and a plan for abatement are"]
[null,null,"    required, and should be included in Exhibit 2.  Include information"]
[null,null,"    on how the budget will cover expense of deleading all units,"]
[]
[{"$f":"A285+1","v":48},".","Is there any evidence that the premises contains asbestos?",null,null,null,null,null," (\"yes\" or \"no\")",{"$f":"IF(H290<>\" \",1,0)","v":0}]
[null,null,"    (If yes, then an asbestos report, and a plan for abatement are"]
[null,null,"     required, and should be included in Exhibit 2.)"]
[]
[{"$f":"A290+1","v":49},".","Is there any evidence that the premises are insulated with urea ",null,null,null,null,null," (\"yes\" or \"no\")"]
[null,null,"formaldehyde foam (UFFI)?"]
[null,null,"    (If yes, please include test results as part of Exhibit 2.)"]
[]
[{"$f":"A294+1","v":50},".","Is the building listed on the National Register for Historic Places,",null,null,null,null,null," (\"yes\" or \"no\")",{"$f":"IF(H298<>\" \",1,0)","v":0}]
[null,null,"or is it a contributing site or building to a local Historic District or a"]
[null,null,"National Register Historic District?"]
[null,null,"     (If unknown, NHHFA will arrange appropriate determination.)"]
[]
[{"$f":"A298+1","v":51},".","Are there any aboveground storage containers with flammable or ",null,null,null,null,null," (\"yes\" or \"no\")",{"$f":"IF(H303<>\" \",1,0)","v":0}]
[null,null,"explosive petroleum products or chemicals within 1/2 mile of the site?"]
[]
[{"$f":"A303+1","v":52},".","Is any part of the site located in a floodplain or wetlands area?",null,null,null,null,null," (\"yes\" or \"no\")",{"$f":"IF(H306<>\" \",1,0)","v":0}]
[null,null,"    (If  close then a map of the wetlands or floodplain areas, and determinations"]
[null,null,"    made by the local Conservation Commission and/or Department of"]
[null,null,"    Environmental  Services should be included in Exhibit 2.)"]
[]
[{"$f":"A306+1","v":53},".","Does the site contain endangered animal or plant species?",null,null,null,null,null," (\"yes\" or \"no\")",{"$f":"IF(H311<>\" \",1,0)","v":0}]
[]
[{"$f":"A311+1","v":54},".","Is the site subject to noise impact from jet airports within 5 miles, major"]
[null,null,"highways within 1,000 feet, rail traffic within 3,000 feet, or is it within",null,null,null,null,null,null,{"$f":"IF(H315<>\" \",1,0)","v":0}]
[null,null,"an airport flight path?",null,null,null,null,null," (\"yes\" or \"no\")"]
[""]
[{"$f":"A313+1","v":55},".","Is the site subject to the jurisdiction of Coastal Zone Management, "]
[null,null,"a Wild & Scenic Waterway, or other state, Federal or deed",null,null,null,null,null," (\"yes\" or \"no\")"]
[null,null,"restriction?"]
[null,null,"   (If yes, then submit details in Exhibit 2)"]
[]
[]
[]
[]
[]
[null,null,{"$f":"C57","v":0}]

{"sheet":"Closing S&U","index":2,"n_rows":205,"n_cols":13,"rows_kept":205,"cut":false,"hidden":false,"merged":[[32,11,36,11],[2,0,2,9],[1,0,1,9],[0,0,0,9],[169,7,169,8],[14,8,15,8],[40,6,40,9],[16,6,16,7],[13,6,13,9],[14,6,15,7],[112,7,112,8],[113,11,113,12],[114,11,114,12],[51,3,51,4],[48,3,48,4],[45,3,45,4]]}
["CLOSING SOURCES AND USES OF FUNDS"]
[{"$f":"IF(+'Project Info'!E4=\"\",\"Un-named Project\",+'Project Info'!E4)","v":"Un-named Project"}]
["Sources of Funds"]
[]
[null,null,"Private Equity:",null,null,null,"Amount  $"]
[1,".","Developer's Cash Equity"]
[{"$f":"A6+1","v":2},null,"LIHTC Equity ",null,null,null,null,"Calculated",{"$f":"'LIHTC Info'!H42","v":0}]
[3,".","HTC Equity",null,null,null,null,"Calculated",{"$f":"'LIHTC Info'!H43","v":0}]
[4,".","Other Equity:"]
[5,".","Developer Fee Loan"]
[6,".","Other Source:"]
[7,null,"Total Private Equity",null,null,null,{"$f":"SUM(G6:G11)","v":0},"             Equity/Subsidy Per Unit:"]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR((G7+F20)/'Project Info'!N69,0)","v":0}]
[null,null,"Public Equity:","Source",null,"Amount  $",{"$f":"IFERROR(IF((((G7+F20)/'Project Info'!N69)>230000),\"EQUITY & SUBSIDY EXCEEDS QAP MAXIMUM\",\"\"),\"\")","v":""}]
[{"$f":"A12+1","v":8},".","Grant:",null,null,null,"Does project fall into a high-cost category per HFA:109.04.C? Yes/No"]
[{"$f":"A15+1","v":9},".","Grant:"]
[{"$f":"A16+1","v":10},".","Total Public Equity",null,null,{"$f":"SUM(F15:F16)","v":0},"LIMIT for TDC Weighted Avg:",null,{"$f":"IF(I15=\"yes\",300000,280000)","v":300000}]
[]
[null,null,"Subordinate Debt:",null,null,"Amount $","Rate %","Amortize Yrs","Term Yrs",null,null,"Capital Subsidy Limits: Refer to Underwriting Standards for Multi-Family Finance, Part 2, Section 2.04 for current Capital Subsidy Limits"]
[{"$f":"A17+1","v":11},".","NH Housing Capital Subsidy Funds",null,null,null,0,0]
[]
[{"$f":"A20+1","v":12},".","Subordinate Debt",null,null,null,0]
[null,null,"       Source:"]
[{"$f":"A22+1","v":13},".","Subordinate Debt",null,null,null," ",null," "]
[null,null,"       Source:"]
[{"$f":"A24+1","v":14},".","Subordinate Debt",null,null,null," "," "," "]
[null,null,"       Source:"]
[{"$f":"A26+1","v":15},".","Subordinate Debt",null,null,null,null," "," "]
[null,null,"       Source:"]
[{"$f":"A28+1","v":16},".","Total Subordinate Debt",null,null,{"$f":"F20+F22+F24+F26+F28","v":0}]
[]
[null,null,"Long Term Debt (Senior):",null,null,"Amount $","Rate %","Amortize Yrs","Term Yrs"]
[{"$f":"A30+1","v":17},".","NH Housing Long-Term Loan",null,null,null,null,null,null,null,null,"Long Term Debt Limits, Rate, Amortization, and Term: Refer to Underwriting Standards for Multi-Family Finance, Part 2 Sections 2.04-2.07"]
[null,".",null,null,null,""]
[{"$f":"A33+1","v":18},".","Other Long-Term Mortgage"]
[null,null,"       Source:"]
[{"$f":"A35+1","v":19},".","Other Long-Term Mortgage",null,null," "]
[null,null,"       Source:",null,null,null,null,"TDC/bedroom:",{"$f":"IFERROR(F41/'Project Info'!N71,0)","v":0}]
[{"$f":"A37+1","v":20},".","Total Long-Term Senior Debt",null,null,{"$f":"F33+F35+F37","v":0},null,"TDC/Unit:",{"$f":"IFERROR(F41/'Project Info'!N69,0)","v":0}]
[null,null,null,null,null,null,null,"TDC Wtd Avg:",{"$f":"((2*I39)+I38)/3","v":0}]
[{"$f":"A39+1","v":21},".","Total Long-Term Sources",null,null,{"$f":"G12+F17+F30+F39","v":0},{"$f":"IFERROR(IF(I40>I17,\"WARNING - TDC EXCEEDS QAP LIMIT!!\",\"\"),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(F41<>G195,\"Sources and Uses do NOT Match!\",\"Ok, Sources and Uses Match!\")","v":"Ok, Sources and Uses Match!"},null,null,{"$f":"IF(F41<>G195,F41-G195,\"\")","v":""}]
[null,null,"Construction/Bridge Financing:",null,null,"Amount  $","Rate  %","Term    Mos"]
[{"$f":"A41+1","v":22},".","Construction Loan"]
[null,null,"    Source:"]
[null,null,"    Repaid at:",null,null," (event)"]
[{"$f":"A44+1","v":23},".","Other Interim Loan",null,null,null,null," "]
[null,null,"    Source:"]
[null,null,"    Repaid at:",null,null," (event)"]
[{"$f":"A47+1","v":24},".","Tax Credit Bridge Loan",null,null,null," "," "]
[null,null,"    Source:"]
[null,null,"    Repaid at:",null,null," (event)"]
[]
[]
[null,null,"Uses of Funds"]
[null,null,"NOTE:  Construction cost breakout by trade is only required on the final application submitted to Apricot"]
[]
[null,null,"Direct Construction:"]
[{"$f":"A50+1","v":25},".","Who prepared the estimates?"]
[{"$f":"A59+1","v":26},".","What is basis for estimates?"]
[]
[null,null,"Division","Trade Item",null,"Amount   $","Trade Description"]
[{"$f":"A60+1","v":27},".",3,"Concrete"]
[{"$f":"A63+1","v":28},".",4,"Masonry"]
[29,".",5,"Metals"]
[30,".",6,"Rough Carpentry"]
[31,".",6,"Finish Carpentry"]
[32,".",7,"Waterproofing"]
[33,".",7,"Insulation"]
[34,".",7,"Roofing"]
[35,".",7,"Siding"]
[36,".",8,"Doors"]
[37,".",8,"Windows"]
[38,".",8,"Glass"]
[39,".",9,"Drywall"]
[40,".",9,"Acoustical"]
[41,".",9,"Wood Flooring"]
[42,".",9,"Resilient Flooring"]
[43,".",9,"Paint & Decorating"]
[44,".",9,"Tile"]
[45,".",10,"Specialties"]
[46,".",11,"Special Equipment"]
[47,".",11,"Cabinets"]
[48,".",11,"Appliances"]
[49,".",12,"Blinds & Shades"]
[50,".",12,"Carpet"]
[51,".",13,"Special Construction"]
[52,".",14,"Elevators"]
[53,".",15,"Plumbing & Hot Water"]
[54,".",15,"Heat & Ventilation"]
[55,".",15,"Air Conditioning"]
[56,".",16,"Electrical"]
[57,".",null,"Accessory Buildings"]
[58,".",null,"Other/Misc"]
[59,".",null,"Subtotal Structural",null,{"$f":"SUM(F63:F94)","v":0}]
[60,null,2,"Demolition"]
[61,".",2,"Earth Work"]
[62,".",2,"Site Utilities"]
[63,".",2,"Roads & Walks"]
[64,".",2,"Site Improvement"]
[65,".",2,"Lawns & Planting"]
[66,".",2,"Unusual Site Conditions"]
[67,".",null,"Subtotal Site Work",null,{"$f":"SUM(F96:F102)","v":0}]
[68,".",null,"Total Improvements",null,{"$f":"F103+F95","v":0}]
[69,".",null,"General Conditions",null,null,null,"As % of Total Improvements:",{"$f":"IF(F104=0,\"\",F105/F104)","v":""}]
[70,".",null,"Subtotal",null,{"$f":"F105+F104","v":0}]
[71,".",null,"Builders Overhead",null,null,null,"As % of Subtotal:",{"$f":"IF(F106=0,\"\",F107/F106)","v":""}]
[72,".",null,"Builders Profit",null,null,null,"As % of Subtotal:",{"$f":"IF(F106=0,\"\",F108/F106)","v":""}]
[73,".",null,"TOTAL","(computed for you)",{"$f":"SUM(F106:F108)","v":0},null,"Cost/Sq.Ft.: ",{"$f":"IF('Project Info'!I122+'Project Info'!I123>0,F109/('Project Info'!I122+'Project Info'!I123),0)","v":0}]
[]
[]
[null,null,"Development Budget:"]
[null,null,null,null,"Residential","Non-","Total","Comments"]
[null,null,"ACQUISITION & CONSTRUCTION",null,null,"Residential",null,null,null,null,null,"Construction Costs "]
[{"$f":"A109+1","v":74},".","Land",null,null,null,{"$f":"E115+F115","v":0},null,null,null,null,"Including Contingency"]
[{"$f":"A115+1","v":75},".","Existing  Building",null,null,null,{"$f":"E116+F116","v":0},null,null,null,null,"Total Construction",{"$f":"G117+G118","v":0}]
[{"$f":"A116+1","v":76},".","Construction Budget",null,{"$f":"F109","v":0},null,{"$f":"E117+F117","v":0}]
[{"$f":"A117+1","v":77},".","Construction Contingency",null,null,null,{"$f":"E118+F118","v":0},{"$f":"IF(AND(G117>0,G118>0),+G118/G117*100,0)","v":0},"% of construct.",null,null,"Construction Per Sq FT",{"$f":"IFERROR(M116/'Project Info'!I122,\"\")","v":""}]
[{"$f":"A118+1","v":78},".",null,null,null,null,{"$f":"E119+F119","v":0}]
[null,null,"Subtotal",null,{"$f":"SUM(E115:E119)","v":0},{"$f":"SUM(F115:F119)","v":0},{"$f":"SUM(G115:G119)","v":0},null,null,{"$f":"IF(G120=0,\"\",G120/$G$195)","v":""},null,"Construction Per unit",{"$f":"IFERROR(M116/'Project Info'!N69,\"\")","v":""}]
[null,null,"ARCHITECTURAL/ ENGINEERING/PROFESSIONAL FEES"]
[{"$f":"A119+1","v":79},".","Architect Fee-Design",null,null,null,{"$f":"E122+F122","v":0},{"$f":"IF(AND(G122>0,G117>0),+G122/G117*100,0)","v":0},"% of construct."]
[{"$f":"A122+1","v":80},null,"Architect Fee-Inspection",null,null,null,0]
[81,".","Engineering Fees",null,null,null,0]
[82,".","Historic Consultant Fees",null,null,null,0]
[83,".","Solar Consultant Fees",null,null,null,0]
[84,".",null,null,null,null,0]
[85,".",null,null,null,null,0]
[null,null,"Subtotal",null,{"$f":"SUM(E122:E128)","v":0},{"$f":"SUM(F122:F128)","v":0},{"$f":"SUM(G122:G128)","v":0},null,null,{"$f":"IF(G129=0,\"\",G129/$G$195)","v":""}]
[null,null,"INTERIM CONSTRUCTION EXPENSE"]
[{"$f":"A128+1","v":86},".","Const. Loan Origination Fee",null,null,null,{"$f":"E131+F131","v":0}]
[{"$f":"A131+1","v":87},".","Const. Interest",null,null,null,0]
[88,".","Const. Insurance",null,null,null,0]
[89,".","Const. Bond Fee",null,null,null,0]
[90,".","Lender's Counsel",null,null,null,0]
[91,".","Taxes During Construction",null,null,null,0]
[92,null,"Permits",null,null,null,0]
[93,".",null,null,null,null,0]
[94,".",null,null,null,null,0]
[null,null,"Subtotal",null,{"$f":"SUM(E131:E139)","v":0},{"$f":"SUM(F131:F139)","v":0},{"$f":"SUM(G131:G139)","v":0},null,null,{"$f":"IF(G140=0,\"\",G140/$G$195)","v":""}]
[null,null,"FINANCING FEES AND EXPENSE"]
[{"$f":"A139+1","v":95},".","Perm. Loan Origination Fee",null,null,null,{"$f":"E142+F142","v":0}]
[{"$f":"A142+1","v":96},".","Perm. Loan Credit Enhance",null,null,null,0]
[97,".","Tax Credit Fee",null,null,null,0]
[98,".","Title Insurance and Record",null,null,null,0]
[99,".","Transfer Tax",null,null,null,0]
[100,".","Lender's Counsel",null,null,null,0]
[101,".","Bond Premium",null,null,null,0]
[102,".","Financing Application Fee",null,null,null,0]
[103,".","Upfront MIP Fee",null,null,null,0]
[{"$f":"A149+1","v":103},".","FFB Trustee Fee",null,null,null,0]
[{"$f":"A150+1","v":104},".","Soft Cost Contingency",null,null,null,0]
[{"$f":"A152+1","v":105},".",null,null,null,null,0]
[null,null,"Subtotal",null,{"$f":"SUM(E142:E153)","v":0},{"$f":"SUM(F142:F153)","v":0},{"$f":"SUM(G142:G153)","v":0},null,null,{"$f":"IF(G154=0,\"\",G154/$G$195)","v":""}]
[null,null,"OTHER SOFT COSTS"]
[{"$f":"A153+1","v":106},".","Appraisal",null,null,null,{"$f":"E156+F156","v":0}]
[{"$f":"A156+1","v":107},".","Market Study",null,null,null,0]
[108,".","Environmental Report",null,null,null,0]
[109,".","Site Survey",null,null,null,0]
[110,".","Relocation Costs",null,null,null,0]
[111,".","Legal Fees",null,null,null,0]
[112,".","Accounting Fees",null,null,null,0]
[{"$f":"A161+1","v":112},".","NHHFA Const. Admin. Svcs. Fee",null,null,null,0]
[{"$f":"A162+1","v":113},".",null,null,null,null,0]
[null,null,"Subtotal",null,{"$f":"SUM(E156:E164)","v":0},{"$f":"SUM(F156:F164)","v":0},{"$f":"SUM(G156:G164)","v":0},null,null,{"$f":"IF(G165=0,\"\",G165/$G$195)","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Identity of Interest"]
[null,null,null,null,"Residential","Non-","Total","Comments",null,null,null,"If construction > $2.5 Million = 18% MAX"]
[null,null,"DEVELOPER FEE",null,null,"Residential",null,null,null,null,null,"If construction < $2.5 Million = 20% MAX"]
[{"$f":"A164+1","v":114},".","Devel. Overhead and Profit",null,null,null,{"$f":"E172+F172","v":0},"Reference \"Dev Fee\" Tab",null,null,null,"Identity of Interest Check",{"$f":"SUM((F105+F107+F108+E174)/E195)","v":{"$error":"#DIV/0!"}}]
[{"$f":"A172+1","v":115},".","Development Consultant Fee",null,null,null,{"$f":"E173+F173","v":0},"Must be taken from dev. Fee"]
[null,null,"Subtotal",null,{"$f":"SUM(E172:E173)","v":0},{"$f":"SUM(F172:F173)","v":0},{"$f":"E174+F174","v":0},null,null,{"$f":"IF(G174=0,\"\",G174/$G$195)","v":""}]
[null,null,"SYNDICATION EXPENSES"]
[{"$f":"A173+1","v":116},".","Syndication Legal",null,null,null,{"$f":"E176+F176","v":0}]
[{"$f":"A176+1","v":117},".","Syndication Accounting",null,null,null,0]
[118,".","Syndication Fees",null,null,null,0]
[119,".","Syndication Consultant",null,null,null,0]
[120,".","Bridge Loan Origination Fee",null,null,null,0]
[121,".","Bridge Loan Interest",null,null,null,0]
[122,".","Investor Servicing (capital)",null,null,null,0]
[123,".",null,null,null,null,0]
[null,null,"Subtotal",null,{"$f":"SUM(E176:E183)","v":0},{"$f":"SUM(F176:F183)","v":0},{"$f":"SUM(G176:G183)","v":0},null,null,{"$f":"IF(G184=0,\"\",G184/$G$195)","v":""}]
[null,null,"RESERVES (see NHHFA Policies)"]
[{"$f":"A183+1","v":124},".","Operating Reserve",null,null,null,{"$f":"E186+F186","v":0},"Calculated",{"$f":"('Pro Forma'!F43/12*4)+('Inc & Exp'!G217/12*4)","v":0}]
[{"$f":"A186+1","v":125},".","FFB Operating Reserve",null,null,null,{"$f":"E187+F187","v":0},"Calculated ",{"$f":"'Inc & Exp'!G211/12*2","v":0}]
[{"$f":"A187+1","v":126},".","Replacement Reserve",null,null,null,0,"Calculated ",{"$f":"'Inc & Exp'!F206*'Project Info'!N69","v":0}]
[{"$f":"A188+1","v":127},".","Insurance Escrow",null,null,null,0]
[128,".","Real Estate Tax Escrow",null,null,null,0]
[129,".","Tax Credit Monitor Fee",null,null,null,0,"Calculated ",{"$f":"IF(ISBLANK('Project Info'!E96),'Project Info'!N69*530, 'Project Info'!N69*690)","v":0}]
[130,".",null,null,null,null,0,"HOME/HTF Monitoring Fee $1000 each"]
[null,null,"Subtotal",null,{"$f":"SUM(E186:E192)","v":0},{"$f":"SUM(F186:F192)","v":0},{"$f":"SUM(G186:G192)","v":0},null,null,{"$f":"IF(G193=0,\"\",G193/$G$195)","v":""}]
[]
[{"$f":"A192+1","v":131},".","Total Development Cost",null,{"$f":"E120+E129+E140+E154+E165+E174+E184+E193","v":0},{"$f":"F120+F129+F140+F154+F165+F174+F184+F193","v":0},{"$f":"F195+E195","v":0}]
[]
[{"$f":"A195+1","v":132},".","Total Net* Development Cost",null,{"$f":"E195-E184","v":0},{"$f":"F195-F184","v":0},{"$f":"SUM(E197:F197)","v":0}]
[null,null,"*TDC less any costs associated with syndicating tax credits"]
[]
[null,null,null,null,null,null,{"$f":"IF(F41<>G195,\"             Sources and Uses do NOT Match!\",\"                  Ok, Sources and Uses Match!\")","v":"                  Ok, Sources and Uses Match!"}]
[null,null,null,null,null,null,{"$f":"IF(F41>G195,\"Sources exceed Uses by:\",IF(F41<G195,\"Uses exceed Sources by:\",\"\"))","v":""},{"$f":"IF(F41<>G195,F41-G195,\"\")","v":""},{"$f":"IF(E200<>G200,E200-G200,\"\")","v":""}]
[]
[]
[null,null,"Debt Service Requirements:"]
[{"$f":"A197+1","v":133},null,"Minimum Debt Service Coverage",null,null,1.1499999999999999]

{"sheet":"Inc & Exp","index":3,"n_rows":244,"n_cols":17,"rows_kept":244,"cut":false,"hidden":false,"merged":[[107,3,107,4],[0,0,0,9],[1,0,1,9],[3,0,3,9]]}
["OPERATING PRO-FORMA"]
[{"$f":"'Closing S&U'!A2","v":"Un-named Project"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Lesser of Test - Rents"]
["Operating Income",null,null,null,null,null,null,null,null,null,null,null,"See Underwriting Standards for Policy"]
[null,null,"Rent Schedule:","Max LIHTC","Contract","Utility","% of LIHTC","Contract Rent","No. of",null,null,null,"Market Rents per market study report:"]
[1,null,{"$f":"'Project Info'!D62","v":"Market Rate"},"Gross Rent","Rent","Allowance","Max","+ Utility Allow.","Units",null,null,null,null,null,"@ 90%"]
[null,null,"SRO",null,null,null,{"$f":"IFERROR(H7/D7,\"\")","v":""},{"$f":"IF(I7>0,E7+F7,\"\")","v":""},{"$f":"'Project Info'!D63","v":0},{"$f":"(E7*I7)*12","v":0},null,null,"1 BD",null,{"$f":"N7*0.9","v":0}]
[null,null,"0 Bedroom",null,null,null,"","",{"$f":"'Project Info'!D64","v":0},0,null,null,"2 BD",null,{"$f":"N8*0.9","v":0}]
[null,null,"1 Bedroom",null,null,null,"","",{"$f":"'Project Info'!D65","v":0},0,null,null,"3 BD",null,{"$f":"N9*0.9","v":0}]
[null,null,"2 Bedroom",null,null,null,"","",{"$f":"'Project Info'!D66","v":0},0]
[null,null,"3 Bedroom",null,null,null,"","",{"$f":"'Project Info'!D67","v":0},0,null,null,"HTF Rents (see HTF Rents)",null,null,null,"Lesser of Results"]
[null,null,"4 Bedroom",null,null,null,"","",{"$f":"'Project Info'!D68","v":0},0,null,null,null,null,"@ 98%"]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I7:I12)","v":0},null,null,null,"1 BD",null,{"$f":"N13*0.98","v":0}]
[{"$f":"A6+1","v":2},null,{"$f":"'Project Info'!E62","v":"LIHTC"},{"$f":"'Project Info'!E61","v":0},null,null,null,null,null,null,null,null,"2 BD",null,{"$f":"N14*0.98","v":0}]
[null,null,"SRO",null,null,null,{"$f":"IFERROR(H15/D15,\"\")","v":""},{"$f":"IF(I15>0,E15+F15,\"\")","v":""},{"$f":"'Project Info'!E63","v":0},{"$f":"(E15*I15)*12","v":0},null,null,"3 BD",null,{"$f":"N15*0.98","v":0}]
[null,null,"0 Bedroom",null,null,null,"","",{"$f":"'Project Info'!E64","v":0},0]
[null,null,"1 Bedroom",null,null,null,"","",{"$f":"'Project Info'!E65","v":0},0,null,null,"HOME Rents",null,null,null,"Lesser of Results"]
[null,null,"2 Bedroom",null,null,null,"","",{"$f":"'Project Info'!E66","v":0},0,null,null,null,null,"@ 98%"]
[null,null,"3 Bedroom",null,null,null,"","",{"$f":"'Project Info'!E67","v":0},0,null,null,"1 BD LH",null,{"$f":"N19*0.98","v":0}]
[null,null,"4 Bedroom",null,null,null,"","",{"$f":"'Project Info'!E68","v":0},0,null,null,"2 BD LH",null,0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I15:I20)","v":0},null,null,null,"3 BD LH",null,0]
[{"$f":"A14+1","v":3},null,{"$f":"'Project Info'!G62","v":"LIHTC"},{"$f":"'Project Info'!F61","v":0},null,null,null,null,null,null,null,null,"1 BD HH",null,0]
[null,null,"SRO",null,null,null,{"$f":"IFERROR(H23/D23,\"\")","v":""},{"$f":"IF(I23>0,E23+F23,\"\")","v":""},{"$f":"'Project Info'!F63","v":0},{"$f":"(E23*I23)*12","v":0},null,null,"2 BD HH",null,0]
[null,null,"0 Bedroom",null,null,null,"","",{"$f":"'Project Info'!F64","v":0},0,null,null,"3 BD HH",null,0]
[null,null,"1 Bedroom",null,null,null,"","",{"$f":"'Project Info'!F65","v":0},0]
[null,null,"2 Bedroom",null,null,null,"","",{"$f":"'Project Info'!F66","v":0},0,null,null,"LIHTC 50% Rents",null,null,null,"Lesser of Results"]
[null,null,"3 Bedroom",null,null,null,"","",{"$f":"'Project Info'!F67","v":0},0,null,null,null,null,"@ 98%"]
[null,null,"4 Bedroom",null,null,null,"","",{"$f":"'Project Info'!F68","v":0},0,null,null,"1 BD",null,{"$f":"N28*0.98","v":0}]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I23:I28)","v":0},null,null,null,"2 BD",null,{"$f":"N29*0.98","v":0}]
[{"$f":"A22+1","v":4},null,{"$f":"'Project Info'!G62","v":"LIHTC"},{"$f":"'Project Info'!G61","v":0},null,null,null,null,null,null,null,null,"3 BD",null,{"$f":"N30*0.98","v":0}]
[null,null,"SRO",null,null,null,{"$f":"IFERROR(H31/D31,\"\")","v":""},{"$f":"IF(I31>0,E31+F31,\"\")","v":""},{"$f":"'Project Info'!G63","v":0},{"$f":"(E31*I31)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,"","",{"$f":"'Project Info'!G64","v":0},0,null,null,"LIHTC 60% Rents",null,null,null,"Lesser of Results"]
[null,null,"1 Bedroom",null,null,null,"","",{"$f":"'Project Info'!G65","v":0},0,null,null,null,null,"@ 98%"]
[null,null,"2 Bedroom",null,null,null,"","",{"$f":"'Project Info'!G66","v":0},0,null,null,"1 BD",null,{"$f":"N34*0.98","v":0}]
[null,null,"3 Bedroom",null,null,null,"","",{"$f":"'Project Info'!G67","v":0},0,null,null,"2 BD",null,{"$f":"N35*0.98","v":0}]
[null,null,"4 Bedroom",null,null,null,"","",{"$f":"'Project Info'!G68","v":0},0,null,null,"3 BD",null,{"$f":"N36*0.98","v":0}]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I31:I36)","v":0}]
[{"$f":"A30+1","v":5},null,{"$f":"'Project Info'!H62","v":"LIHTC"},{"$f":"'Project Info'!H61","v":0},null,null,null,null,null,null,null,null,"811 Rents",null,null,null,"Greater of Results"]
[null,null,"SRO",null,null,null,{"$f":"IFERROR(H39/D39,\"\")","v":""},{"$f":"IF(I39>0,E39+F39,\"\")","v":""},{"$f":"'Project Info'!H63","v":0},{"$f":"(E39*I39)*12","v":0},null,null,null,null,"FMR","Market (98%)"]
[null,null,"0 Bedroom",null,null,null,"","",{"$f":"'Project Info'!H64","v":0},0,null,null,"1 BD",null,null,null,{"$f":"IF(O40>P40,O40,P40)","v":0}]
[null,null,"1 Bedroom",null,null,null,"","",{"$f":"'Project Info'!H65","v":0},0,null,null,"2 BD",null,null,null,{"$f":"IF(O41>P41,O41,P41)","v":0}]
[null,null,"2 Bedroom",null,null,null,"","",{"$f":"'Project Info'!H66","v":0},0,null,null,"3 BD",null,null,null,{"$f":"IF(O42>P42,O42,P42)","v":0}]
[null,null,"3 Bedroom",null,null,null,"","",{"$f":"'Project Info'!H67","v":0},0]
[null,null,"4 Bedroom",null,null,null,"","",{"$f":"'Project Info'!H68","v":0},0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I39:I44)","v":0},null,null,null,"Lesser of Test Results = Contract Rent + UA"]
[]
[]
[]
[null,null,"Rent Schedule (Continued):"]
[null,null,null,"Max LIHTC","Contract","Utility","% ofLIHTC","Contract Rent","No. of"]
[{"$f":"A38+1","v":6},null,{"$f":"'Project Info'!I62","v":"Low HOME"},"Gross Rent","Rent","Allowance","Max","+ Utility Allow.","Units"]
[null,null,"SRO",null,null,null,{"$f":"IFERROR(H52/D52,\"\")","v":""},{"$f":"IF(I52>0,E52+F52,\"\")","v":""},{"$f":"'Project Info'!I63","v":0},{"$f":"(E52*I52)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,"","",{"$f":"'Project Info'!I64","v":0},0]
[null,null,"1 Bedroom",null,null,null,"","",{"$f":"'Project Info'!I65","v":0},0]
[null,null,"2 Bedroom",null,null,null,"","",{"$f":"'Project Info'!I66","v":0},0]
[null,null,"3 Bedroom",null,null,null,"","",{"$f":"'Project Info'!I67","v":0},0]
[null,null,"4 Bedroom",null,null,null,"","",{"$f":"'Project Info'!I68","v":0},0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I52:I57)","v":0}]
[{"$f":"A51+1","v":7},null,{"$f":"'Project Info'!J62","v":"High HOME"}]
[null,null,"SRO",null,null,null,{"$f":"IFERROR(H60/D60,\"\")","v":""},{"$f":"IF(I60>0,E60+F60,\"\")","v":""},{"$f":"'Project Info'!J63","v":0},{"$f":"(E60*I60)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,"","",{"$f":"'Project Info'!J64","v":0},0]
[null,null,"1 Bedroom",null,null,null,"","",{"$f":"'Project Info'!J65","v":0},0]
[null,null,"2 Bedroom",null,null,null,"","",{"$f":"'Project Info'!J66","v":0},0]
[null,null,"3 Bedroom",null,null,null,"","",{"$f":"'Project Info'!J67","v":0},0]
[null,null,"4 Bedroom",null,null,null,"","",{"$f":"'Project Info'!J68","v":0},0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I60:I65)","v":0}]
[{"$f":"A59+1","v":8},null,{"$f":"'Project Info'!K62","v":"HTF"}]
[null,null,"SRO",null,null,null,{"$f":"IFERROR(H68/D68,\"\")","v":""},{"$f":"IF(I68>0,E68+F68,\"\")","v":""},{"$f":"'Project Info'!K63","v":0},{"$f":"(E68*I68)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,"","",{"$f":"'Project Info'!K64","v":0},0]
[null,null,"1 Bedroom",null,null,null,"","",{"$f":"'Project Info'!K65","v":0},0]
[null,null,"2 Bedroom",null,null,null,"","",{"$f":"'Project Info'!K66","v":0},0]
[null,null,"3 Bedroom",null,null,null,"","",{"$f":"'Project Info'!K67","v":0},0]
[null,null,"4 Bedroom",null,null,null,"","",{"$f":"'Project Info'!K68","v":0},0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I68:I73)","v":0}]
[{"$f":"A67+1","v":9},null,{"$f":"'Project Info'!L62","v":"811 units"}]
[null,null,"SRO",null,null,null,{"$f":"IFERROR(H76/D76,\"\")","v":""},{"$f":"IF(I76>0,E76+F76,\"\")","v":""},{"$f":"'Project Info'!L63","v":0},{"$f":"(E76*I76)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,"","",{"$f":"'Project Info'!L64","v":0},0]
[null,null,"1 Bedroom",null,null,null,"","",{"$f":"'Project Info'!L65","v":0},0]
[null,null,"2 Bedroom",null,null,null,"","",{"$f":"'Project Info'!L66","v":0},0]
[null,null,"3 Bedroom",null,null,null,"","",{"$f":"'Project Info'!L67","v":0},0]
[null,null,"4 Bedroom",null,null,null,"","",{"$f":"'Project Info'!L68","v":0},0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I76:I81)","v":0}]
[{"$f":"A75+1","v":10},null,{"$f":"'Project Info'!M62","v":"Rental Assisted"}]
[null,null,"SRO",null,null,null,{"$f":"IFERROR(H84/D84,\"\")","v":""},{"$f":"IF(I84>0,E84+F84,\"\")","v":""},{"$f":"'Project Info'!M63","v":0},{"$f":"(E84*I84)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,"","",{"$f":"'Project Info'!M64","v":0},0]
[null,null,"1 Bedroom",null,null,null,"","",{"$f":"'Project Info'!M65","v":0},0]
[null,null,"2 Bedroom",null,null,null,"","",{"$f":"'Project Info'!M66","v":0},0]
[null,null,"3 Bedroom",null,null,null,"","",{"$f":"'Project Info'!M67","v":0},0]
[null,null,"4 Bedroom",null,null,null,"","",{"$f":"'Project Info'!M68","v":0},0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I84:I89)","v":0}]
[]
[]
[]
[null,null,"Commercial Income:",null,null,"(average) $ / sq. ft."]
[{"$f":"A83+1","v":11},null,"Square Feet:",{"$f":"'Project Info'!F127","v":0},"@   ",null,"       = Comm. Income:",null,{"$f":"D95*F95","v":0}]
[]
[null,null,"Vacancy Rates:","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6 and up"]
[{"$f":"A95+1","v":12},null,"Market Rate",0.05,0.05,0.05,0.05,0.05,0.05]
[{"$f":"A98+1","v":13},null,"LIHTC",0.05,0.05,0.05,0.05,0.05,0.05]
[14,null,"HOME",0.05,0.05,0.05,0.05,0.05,0.05]
[15,null,"HTF",0.05,0.05,0.05,0.05,0.05,0.05]
[16,null,811,0.05,0.05,0.05,0.05,0.05,0.05]
[17,null,"Rent Assisted",0.05,0.05,0.05,0.05,0.05,0.05]
[18,null,"Commercial Space",0.05,0.05,0.05,0.05,0.05,0.05]
[]
[{"$f":"A104+1","v":19},null,"Laundry Income (annual):",null,null,"$"]
[]
[{"$f":"A106+1","v":20},null,"Other Income:",null,null,"$"]
[null,null,"Trending Assumptions"]
[null,null,"      for Rents:",null,"Year 2   %","Year 3   %","Year 4 %","Year 5    %","Years 6-20        %"]
[{"$f":"A108+1","v":21},null,"Market Rate",null,0.02,0.02,0.02,0.02,2.5000000000000001E-2,{"$f":"IF(AND(I13>0,SUM(E111:H111)<0.000001),1,0)","v":0}]
[{"$f":"A111+1","v":22},null,"LIHTC",null,0.02,0.02,0.02,0.02,2.5000000000000001E-2,{"$f":"IF(AND(I21>0,SUM(E112:H112)<0.000001),1,0)","v":0}]
[23,null,"HOME",null,0.02,0.02,0.02,0.02,2.5000000000000001E-2,{"$f":"IF(AND(I29>0,SUM(E113:H113)<0.000001),1,0)","v":0}]
[24,null,"HTF",null,0.02,0.02,0.02,0.02,2.5000000000000001E-2,{"$f":"IF(AND(I37>0,SUM(E114:H114)<0.000001),1,0)","v":0}]
[{"$f":"A113+1","v":24},null,811,null,0.02,0.02,0.02,0.02,2.5000000000000001E-2,{"$f":"IF(AND(I44>0,SUM(E115:H115)<0.000001),1,0)","v":0}]
[{"$f":"A114+1","v":25},null,"Rent Assisted",null,0.02,0.02,0.02,0.02,2.5000000000000001E-2,{"$f":"IF(AND(I45>0,SUM(E116:H116)<0.000001),1,0)","v":0}]
[26,null,"Commercial Space Rental",null,0.02,0.02,0.02,0.02,2.5000000000000001E-2,{"$f":"IF(AND(D95>0,SUM(E117:H117)<0.000001),1,0)","v":0}]
[27,null,"Other Income",null,0.02,0.02,0.02,0.02,2.5000000000000001E-2]
[]
[null,null,"Note: Current Authority underwriting standard on trending: 2% on income, 3% on oper exp incl replacement reserve."]
[]
[null,null,"Operating Subsidy and Capitalized Operating Reserves:"]
[]
[{"$f":"A118+1","v":28},null,"Yearly Draws on Subsidies and Reserves:(if any)",null,null,null,"Note: This section locked …for Authority staff only"]
[]
[null,null,"Source I  ($)","Source II  ($)","Source III ($)",null,"Source I  ($)","Source II  ($)","Source III ($)"]
[null,"NAME ",null,"","Operating Reserves",null,{"$f":"C127","v":0},{"$f":"D127","v":""},{"$f":"E127","v":"Operating Reserves"}]
[null,"Year 1  ",0,null,null,"Year 11  ",{"$f":"C137*1.0125","v":0}]
[null,"Year 2  ",{"$f":"C128*1.0125","v":0},null,null,"Year 12  ",{"$f":"G128*1.0125","v":0}]
[null,"Year 3  ",0,null,null,"Year 13  ",0]
[null,"Year 4  ",0,null,null,"Year 14  ",0]
[null,"Year 5  ",0,null,null,"Year 15  ",0]
[null,"Year 6  ",0,null,null,"Year 16  ",0]
[null,"Year 7  ",0,null,null,"Year 17  ",0]
[null,"Year 8  ",0,null,null,"Year 18  ",0]
[null,"Year 9  ",0,null,null,"Year 19  ",0]
[null,"Year 10  ",0,null,null,"Year 20  ",0]
[]
[{"$f":"A124+1","v":29},".","Annual Operating Income (year 1) :",null,null,{"$f":"(SUM(J7:J12)*(1-D98))+(SUM(J15:J20)*(1-D99))+(SUM(J23:J28)*(1-D99))+(SUM(J31:J36)*(1-D99))+(SUM(J39:J44)*(1-D99))+(SUM(J52:J57)*(1-D100))+(SUM(J60:J65)*(1-D100))+(SUM(J68:J73)*(1-D101))+(SUM(J76:J81)*(1-D102))+(SUM(J84:J89)*(1-D103)+(SUM(I95*(1-D104))+G106+G108+(C128+D128+E128)))","v":0}]
[]
[]
["Operating Expenses"]
[]
[null,"Annual Operating Exp.:",null,null,"Residential","Commercial","Total","Comments"]
[{"$f":"A139+1","v":30},null,"Management Fee",null,null,null,{"$f":"E145+F145","v":0},{"$f":"IF(F139=0,\"\",G145/F139)","v":""},"of total op. Inc."]
[{"$f":"A145+1","v":31},null,"Payroll, Administrative",null,null,null,0]
[32,null,"Payroll Taxes & Benefits, Admin",null,null,null,0]
[33,null,"Legal",null,null,null,0]
[34,null,"Audit",null,null,null,0]
[35,null,"Marketing",null,null,null,0]
[36,null,"Telephone",null,null,null,0]
[37,null,"Office Supplies",null,null,null,0]
[38,null,"Accounting & Data Processing",null,null,null,0]
[39,null,"Investor Servicing Fees",null,null,null,0,"Paid  \"below the line\""]
[40,null,"Other Fees:",null,null,null,0]
[41,null,"Other:",null,null,null,0]
[42,null,"Other:"," ",null,null,0]
[43,null,"Subtotal: Administrative",null,{"$f":"SUM(E145:E157)","v":0},{"$f":"SUM(F145:F157)","v":0},{"$f":"SUM(G145:G157)","v":0}]
[null,null,null,null,""]
[{"$f":"A158+1","v":44},null,"Payroll, Maintenance",null,null,null,{"$f":"E160+F160","v":0}]
[{"$f":"A160+1","v":45},null,"Payroll Taxes & Benefits, Maint",null,null,null,0]
[46,null,"Janitorial Materials",null,null,null,0]
[47,null,"Landscaping",null,null,null,0]
[48,null,"Decorating (inter. only)",null,null,null,0]
[49,null,"Repairs (inter. & ext.)",null,null,null,0]
[50,null,"Elevator Maintenance",null,null,null,0]
[51,null,"Trash Removal",null,null,null,0]
[52,null,"Snow Removal",null,null,null,0]
[53,null,"Extermination",null,null,null,0]
[54,null,"Recreation",null,null,null,0]
[55,null,"Other:",null,null,null,0]
[56,null,"Subtotal: Maintenance",null,{"$f":"SUM(E160:E171)","v":0},{"$f":"SUM(F160:F171)","v":0},{"$f":"SUM(G160:G171)","v":0}]
[null,null,null,null," "]
[{"$f":"A172+1","v":57},null,"Direct Service Staff / Contract staff",null,null,null,{"$f":"E174+F174","v":0}]
[null,null,"Food Supplies",null,null,null,{"$f":"E175+F175","v":0}]
[null,null,"Program Supplies",null,null,null,{"$f":"E176+F176","v":0}]
[null,null,"Subtotal: Resident Services",null,{"$f":"SUM(E174:E176)","v":0},{"$f":"SUM(F174:F176)","v":0},{"$f":"SUM(G174:G176)","v":0}]
[]
[{"$f":"A174+1","v":58},null,"Security",null,null,null,{"$f":"E179+F179","v":0}]
[]
[{"$f":"A179+1","v":59},null,"Electricity",null,null,null,{"$f":"E181+F181","v":0}]
[{"$f":"A181+1","v":60},null,"Natural Gas",null,null,null,{"$f":"E182+F182","v":0}]
[{"$f":"A182+1","v":61},null,"Oil",null,null,null,{"$f":"E183+F183","v":0}]
[{"$f":"A183+1","v":62},null,"Water & Sewer",null,null,null,{"$f":"E184+F184","v":0}]
[{"$f":"A184+1","v":63},null,"Subtotal: Utilities",null,{"$f":"SUM(E181:E184)","v":0},{"$f":"SUM(F181:F184)","v":0},{"$f":"SUM(G181:G184)","v":0}]
[null,null,null,null," "]
[{"$f":"A185+1","v":64},null,"Replacement Reserve",null,null,null,{"$f":"E187+F187","v":0},"Calculated",{"$f":"500*'Project Info'!N69","v":0}]
[null,null,null,null," "]
[{"$f":"A187+1","v":65},null,"Real Estate Taxes",null,null,null,{"$f":"E189+F189","v":0}]
[{"$f":"A189+1","v":66},null,"Other Taxes",null,null,null,{"$f":"E190+F190","v":0}]
[{"$f":"A190+1","v":67},null,"Insurance",null,null,null,{"$f":"E191+F191","v":0}]
[{"$f":"A191+1","v":68},null,"Other",null,null,null,{"$f":"E192+F192","v":0}]
[{"$f":"A192+1","v":69},null,"Subtotal: Taxes, Insurance",null,{"$f":"SUM(E189:E192)","v":0},{"$f":"SUM(F189:F192)","v":0},{"$f":"E193+F193","v":0}]
[null,null,null,"Total Expenses (w/o Res. Serv)",{"$f":"E158+E172+E177+E179+E185+E193","v":0},{"$f":"F158+F172+F177+F179+F185+F193","v":0},{"$f":"G158+G172+G177+G179+G185+G193","v":0},"PUPM"]
[{"$f":"A193+1","v":70},null,"Total All Expenses",null,{"$f":"E158+E172+E177+E179+E185+E187+E193","v":0},{"$f":"F158+F172+F177+F179+F185+F187+F193","v":0},{"$f":"G158+G172+G177+G179+G185+G187+G193","v":0},{"$f":"IF('Project Info'!N69<=0,\"\",G195/'Project Info'!N69/12)","v":""}]
[]
[null,null,"Other Operating Expense Assumptions"]
[null,null,"Trending Assumptions for Expenses",null,null,"Year 2    %","Year 3   %","Year 4 %","Year 5-15  %"]
[{"$f":"A195+1","v":71},null,"Sewer & Water",null,null,0.03,0.03,0.03,0.03]
[{"$f":"A199+1","v":72},null,"Real Estate Taxes",null,null,0.03,0.03,0.03,0.03]
[{"$f":"A200+1","v":73},null,"All Other Operating Expenses, incl repl reserve",null,null,0.03,0.03,0.03,0.03]
[]
[]
[]
[null,null,"Reserve Requirements:"]
[{"$f":"A201+1","v":74},null,"Replacement Reserve Requirement 1st Yr",null,null,null,"   per unit per year"]
[{"$f":"A206+1","v":75},null,"Operating Reserve Requirement",null,null,null,"   per unit per year"]
[]
[null,null,"Debt Service:",null,null,null,"Annual"]
[null,null,null,null,null,null,"Payment"]
[{"$f":"A207+1","v":76},null,"NHHFA Permanent Loan",null,null,null,{"$f":"IF('Closing S&U'!H33<>0,(PMT(('Closing S&U'!G33/12),('Closing S&U'!H33*12),-'Closing S&U'!F33)*12),0)","v":0}]
[{"$f":"A211+1","v":77},null,null,null,null,null,{"$f":"IF('Closing S&U'!H34<>0,(PMT(('Closing S&U'!G34/12),('Closing S&U'!H34*12),-'Closing S&U'!F34)*12),0)","v":0}]
[{"$f":"A212+1","v":78},null,"Other Permanent Mortgage",null,null,null,{"$f":"IF('Closing S&U'!H35<>0,(PMT(('Closing S&U'!G35/12),('Closing S&U'!H35*12),-'Closing S&U'!F35)*12),0)","v":0}]
[null,null,"       Source:",{"$f":"IF('Closing S&U'!D36=\"\",\"\",IF(LEN(TRIM('Closing S&U'!D36))>1,+'Closing S&U'!D36,\"\"))","v":""}]
[{"$f":"A213+1","v":79},null,"Other Permanent Mortgage",null,null,null,{"$f":"IF('Closing S&U'!H37<>0,(PMT(('Closing S&U'!G37/12),('Closing S&U'!H37*12),-'Closing S&U'!F37)*12),0)","v":0}]
[null,null,"       Source:",{"$f":"IF('Closing S&U'!D38=\"\",\"\",IF(LEN(TRIM('Closing S&U'!D38))>1,+'Closing S&U'!D38,\"\"))","v":""}]
[{"$f":"A215+1","v":80},null,"Total Debt Service (Annual)",null,null,null,{"$f":"SUM(G211:G213)+G215","v":0}]
[]
[{"$f":"A217+1","v":81},null,"Net Operating Income",null,null,null,{"$f":"F139-G195","v":0}," (in year one)"]
[]
[{"$f":"A219+1","v":82},null,"Debt Service Coverage Ratio",null,null,null,{"$f":"IF(G217>0,G219/G217,0)","v":0}," (in year one)"]
[]
[]
[null,null,"Affordability:  Income Information and Maximum Allowable Rents"]
[null,null,null,"See website for income limits and rents <www.nhhfa.org >under  Data section"]
[{"$f":"A221+1","v":83},null,"Median Income For Site:",null,null,"Median Area Income    $"]
[]
[{"$f":"A226+1","v":84},null,"As of (date): ",null,null,"Area used is"]
[]
[{"$f":"A228+1","v":85},null,"Income, Adjusted by Household Size:",null,null,null,0.8,0.6,0.5]
[null,null,null,null,{"$f":"0.7*$H$226","v":0},"1 person",null,{"$f":"E231*0.6","v":0},{"$f":"E231*0.5","v":0}]
[null,null,null,null,{"$f":"0.8*$H$226","v":0},"2 person",null,0,0]
[null,null,null,null,{"$f":"0.9*$H$226","v":0},"3 person",null,0,0]
[null,null,null,null,{"$f":"$H$226","v":0},"4 person",null,0,0]
[null,null,null,null,{"$f":"1.1*$H$226","v":0},"5 person",null,0,0]
[null,null,null,null,{"$f":"1.2*$H$226","v":0},"6 person",null,0,0]
[]
[{"$f":"A230+1","v":86},null,"HOME Designated Units"]
[null,null,null,"High Home"]
[null,null,null,"Low Home"]
[null,null,null,"Total"]
[]
[]
[null,null,null,null,""]

{"sheet":"Dev Team","index":4,"n_rows":193,"n_cols":10,"rows_kept":193,"cut":false,"hidden":false,"merged":[[71,5,71,8],[91,5,91,8],[104,5,104,8],[92,5,92,6],[92,7,92,8],[155,3,165,8],[149,5,149,8],[148,5,148,8],[147,5,147,8],[145,5,145,8],[144,2,144,3],[138,5,138,8],[139,5,139,8],[140,5,140,8],[141,5,141,8],[150,5,150,6],[150,7,150,8],[146,5,146,8],[142,5,142,6],[142,7,142,8],[72,5,72,8],[73,5,73,8],[74,5,74,8],[90,5,90,8],[47,5,47,8],[46,5,46,8],[45,5,45,8],[57,5,57,8],[58,5,58,8],[59,5,59,8],[67,5,67,8],[50,5,50,6],[64,5,64,8],[79,5,79,8],[80,5,80,8],[81,5,81,8],[82,5,82,8],[83,5,83,8],[13,5,13,8],[12,5,12,8],[11,5,11,8],[60,5,60,6],[60,7,60,8],[65,5,65,8],[68,5,68,6],[68,7,68,8],[14,5,14,8],[25,5,25,8],[36,5,36,8],[48,5,48,8],[42,5,42,8],[30,5,30,8],[31,5,31,8],[75,5,75,8],[41,5,41,8],[55,5,55,8],[49,5,49,8],[135,5,135,6],[135,7,135,8],[99,5,99,8],[122,5,122,8],[123,5,123,8],[124,5,124,8],[112,5,112,8],[114,5,114,8],[115,5,115,8],[113,5,113,8],[117,5,117,6],[117,7,117,8],[125,5,125,6],[125,7,125,8],[132,5,132,8],[133,5,133,8],[134,5,134,8],[120,5,120,8],[100,5,100,8],[105,5,105,8],[109,5,109,6],[109,7,109,8],[0,0,0,9],[87,5,87,8],[89,5,89,8],[50,7,50,8],[121,5,121,8],[7,3,7,5],[24,5,24,8],[26,7,26,8],[26,5,26,6],[35,5,35,8],[37,5,37,8],[18,5,18,8],[19,5,19,8],[20,5,20,8],[21,5,21,8],[22,5,22,8],[23,5,23,8],[97,5,97,8],[101,5,101,6],[101,7,101,8],[116,5,116,8],[106,5,106,8],[107,5,107,8],[29,5,29,8],[1,3,1,7],[32,5,32,8],[33,5,33,8],[34,5,34,8],[130,5,130,8],[131,5,131,8],[96,5,96,8],[98,5,98,8],[76,5,76,6],[76,7,76,8],[108,5,108,8],[84,5,84,6],[84,7,84,8],[38,5,38,6],[38,7,38,8],[44,5,44,8],[43,5,43,8],[88,5,88,8],[56,5,56,8],[63,5,63,8],[66,5,66,8],[10,5,10,8],[15,7,15,8],[15,5,15,6]]}
["DEVELOPMENT TEAM SUMMARY"]
[null,null,null,{"$f":"'Closing S&U'!A2","v":"Un-named Project"},null,null,null,null,null,{"$f":"IF('Project Info'!J9=\"\",\"\",'Project Info'!J9)","v":""}]
[]
[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,"Soc.Sec.No./Fed Tax ID#"]
[null,null,null,"Principals"]
[null,null,null,"Contact Person"]
[null,null,null,"Email Address"]
[null,null,null,"Telephone No.  /  Fax. No."]
[]
[{"$f":"A18+1","v":4},".","General Partner (if applicable):"]
[null,null,null,"Form of Legal Entity"]
[null,null,null,"Legal Name"]
[null,null,null,"Address"]
[]
[null,null,null,"Soc.Sec.No./Fed Tax ID#"]
[null,null,null,"Principal (if corporation)"]
[null,null,null,"Contact Person"]
[null,null,null,"Email Address"]
[null,null,null,"% of Ownership"]
[null,null,null,"Telephone No.  /  Fax. No."]
[]
[{"$f":"A29+1","v":5},".","General Partner (if applicable):"]
[null,null,null,"Form of Legal Entity"]
[null,null,null,"Legal Name"]
[null,null,null,"Address"]
[]
[null,null,null,"Soc.Sec.No./Fed Tax ID#"]
[null,null,null,"Principal (if corporation)"]
[null,null,null,"Contact Person"]
[null,null,null,"Email Address"]
[null,null,null,"% of Ownership"]
[null,null,null,"Telephone No.  /  Fax. No."]
[]
[]
[]
[{"$f":"A41+1","v":6},".","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#"]
[]
[{"$f":"A130+1","v":15},".","Solar/Energy 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#"]
[]
[{"$f":"A120+1","v":13},".","Historic 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#"]
[]
[{"$f":"A55+1","v":7},".","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#"]
[]
[{"$f":"A79+1","v":8},".","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#"]
[]
[]
[{"$f":"A87+1","v":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":"A96+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":"A104+1","v":11},".","Attorney (Tax):"]
[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":"A112+1","v":12},".","Syndicator or Other Buyer of Equity:"]
[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":"A71+1","v":14},".","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#"]
[{"$f":"A63+1","v":16},".","Local Elected Town Official (CEO - to be contacted by NH Housing "]
[null,null,"as per Section 42 requirements)"]
[null,null,null,"Name"]
[null,"Please do not",null,"Address"]
[null,"use Town Manager",null,"Contact Person"]
[null,"Must be \"ELECTED\"",null,"Email Address"]
[null,null,null,"Telephone/Fax#"]
[]
[{"$f":"A137+1","v":17},"."]
[null,null,"  Other role","Company Name"]
[null,null,null,"Address"]
[]
[null,null,null,"Contact Person"]
[null,null,null,"Email Address"]
[null,null,null,"Telephone/Fax#"]
[]
[{"$f":"A145+1","v":18},".","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'!E4=\"\",\"Un-named Project\",+'Project Info'!E4)","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,"his/her 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 the N.H. Housing "]
[null,null,"Housing 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,"By submitting this application, applicant gives permission to N.H. Housing Finance Authority and its "]
[null,null,"agents to investigate all representations made and attachments included."]
[null,null,"This includes permission to access personal and business credit reports. "]
[]
[]
[]
[]
[]
[null,null,null,"Applicant Signature",null,null,"Date"]

{"sheet":"Pro Forma","index":5,"n_rows":210,"n_cols":10,"rows_kept":210,"cut":false,"hidden":false,"merged":[]}
[]
[null,"NH Housing Financing Application",null,null,null,null,null,null,null,"Page 1 of 4"]
[null,{"$f":"'Closing S&U'!A2","v":"Un-named Project"}]
[null,"20-Year Operating Proforma (Years 1-5)"]
[]
[]
[null,null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,null,null,null,"Calendar Year :",{"$f":"IF(+'Project Info'!G51>0,+'Project Info'!B51,\"             N/A \")","v":"             N/A "},{"$f":"IF(F8>0,F8+1,\"             N/A \")","v":"             N/A "},{"$f":"IF(G8>0,G8+1,\"             N/A \")","v":"             N/A "},{"$f":"IF(H8>0,H8+1,\"             N/A \")","v":"             N/A "},{"$f":"IF(I8>0,I8+1,\"             N/A \")","v":"             N/A "}]
[null,null,"INCOME:"]
[null,null,null,"Market Rate Units",null,{"$f":"SUM('Inc & Exp'!J7:J12)","v":0},{"$f":"F10*(1+'Inc & Exp'!E111)","v":0},{"$f":"G10*(1+'Inc & Exp'!F111)","v":0},{"$f":"H10*(1+'Inc & Exp'!G111)","v":0},{"$f":"I10*(1+'Inc & Exp'!H111)","v":0}]
[null,null,null,"Tax Credit Units",null,{"$f":"SUM('Inc & Exp'!J15:J44)","v":0},{"$f":"F11*(1+'Inc & Exp'!E112)","v":0},{"$f":"G11*(1+'Inc & Exp'!F112)","v":0},{"$f":"H11*(1+'Inc & Exp'!G112)","v":0},{"$f":"I11*(1+'Inc & Exp'!H112)","v":0}]
[null,null,null,"HOME Units",null,{"$f":"SUM('Inc & Exp'!J52:J65)","v":0},{"$f":"F12*(1+'Inc & Exp'!E113)","v":0},{"$f":"G12*(1+'Inc & Exp'!F113)","v":0},{"$f":"H12*(1+'Inc & Exp'!G113)","v":0},{"$f":"I12*(1+'Inc & Exp'!H113)","v":0}]
[null,null,null,"HTF Units",null,{"$f":"SUM('Inc & Exp'!J68:J73)","v":0},{"$f":"F13*(1+'Inc & Exp'!E114)","v":0},{"$f":"G13*(1+'Inc & Exp'!F114)","v":0},{"$f":"H13*(1+'Inc & Exp'!G114)","v":0},{"$f":"I13*(1+'Inc & Exp'!H114)","v":0}]
[null,null,null,"811 Units",null,{"$f":"SUM('Inc & Exp'!J76:J81)","v":0},{"$f":"F14*(1+'Inc & Exp'!E115)","v":0},{"$f":"G14*(1+'Inc & Exp'!F115)","v":0},{"$f":"H14*(1+'Inc & Exp'!G115)","v":0},{"$f":"I14*(1+'Inc & Exp'!H115)","v":0}]
[null,null,null,"Rental Assisted Units",null,{"$f":"SUM('Inc & Exp'!J84:J89)","v":0},{"$f":"F15*(1+'Inc & Exp'!E116)","v":0},{"$f":"G15*(1+'Inc & Exp'!F116)","v":0},{"$f":"H15*(1+'Inc & Exp'!G116)","v":0},{"$f":"I15*(1+'Inc & Exp'!H116)","v":0}]
[null,null,"Gross Potential Income",null,null,{"$f":"SUM(F10:F15)","v":0},{"$f":"SUM(G10:G15)","v":0},{"$f":"SUM(H10:H15)","v":0},{"$f":"SUM(I10:I15)","v":0},{"$f":"SUM(J10:J15)","v":0}]
[null,null,null,"   Less vacancy",null,{"$f":"(F10*'Inc & Exp'!$D$98)+(F11*'Inc & Exp'!$D$99)+(F12*'Inc & Exp'!$D$100)+(F13*'Inc & Exp'!$D$101)+(F14*'Inc & Exp'!D102)+(F15*'Inc & Exp'!D103)","v":0},{"$f":"(G10*'Inc & Exp'!E$98)+(G11*'Inc & Exp'!E$99)+(G12*'Inc & Exp'!E$100)+(G13*'Inc & Exp'!E$101)+(G14*'Inc & Exp'!E102)+(G15*'Inc & Exp'!E$103)","v":0},{"$f":"(H10*'Inc & Exp'!F$98)+(H11*'Inc & Exp'!F$99)+(H12*'Inc & Exp'!F$100)+(H13*'Inc & Exp'!F$101)+(H14*'Inc & Exp'!F102)+(H15*'Inc & Exp'!F$103)","v":0},{"$f":"(I10*'Inc & Exp'!G$98)+(I11*'Inc & Exp'!G$99)+(I12*'Inc & Exp'!G$100)+(I13*'Inc & Exp'!G$101)+(I14*'Inc & Exp'!G102)+(I15*'Inc & Exp'!G$103)","v":0},{"$f":"(J10*'Inc & Exp'!H$98)+(J11*'Inc & Exp'!H$99)+(J12*'Inc & Exp'!H$100)+(J13*'Inc & Exp'!H$101)+(J14*'Inc & Exp'!H102)+(J15*'Inc & Exp'!H$103)","v":0}]
[null,null,"Effective Gross Residential Income",null,null,{"$f":"F16-F17","v":0},{"$f":"G16-G17","v":0},{"$f":"H16-H17","v":0},{"$f":"I16-I17","v":0},{"$f":"J16-J17","v":0}]
[null,null,null,"Commercial Income",null,{"$f":"'Inc & Exp'!I95","v":0},{"$f":"F19*(1+'Inc & Exp'!E117)","v":0},{"$f":"G19*(1+'Inc & Exp'!F117)","v":0},{"$f":"H19*(1+'Inc & Exp'!G117)","v":0},{"$f":"I19*(1+'Inc & Exp'!H117)","v":0}]
[null,null,null,"   Less vacancy",null,{"$f":"F19*'Inc & Exp'!$D104","v":0},{"$f":"G19*'Inc & Exp'!$E104","v":0},{"$f":"H19*'Inc & Exp'!$F104","v":0},{"$f":"I19*'Inc & Exp'!$G104","v":0},{"$f":"J19*'Inc & Exp'!$H104","v":0}]
[null,null,null,"Net Commercial Income",null,{"$f":"F19-F20","v":0},{"$f":"G19-G20","v":0},{"$f":"H19-H20","v":0},{"$f":"I19-I20","v":0},{"$f":"J19-J20","v":0}]
[null,null,"Effective Rental Income",null,null,{"$f":"F18+F21","v":0},{"$f":"G18+G21","v":0},{"$f":"H18+H21","v":0},{"$f":"I18+I21","v":0},{"$f":"J18+J21","v":0}]
[null,null,null,"Other Income",null,{"$f":"'Inc & Exp'!G106+'Inc & Exp'!G108","v":0},{"$f":"F23*(1+'Inc & Exp'!E118)","v":0},{"$f":"G23*(1+'Inc & Exp'!F118)","v":0},{"$f":"H23*(1+'Inc & Exp'!G118)","v":0},{"$f":"I23*(1+'Inc & Exp'!H118)","v":0}]
[null,null,"Total Gross Income",null,null,{"$f":"F22+F23","v":0},{"$f":"G22+G23","v":0},{"$f":"H22+H23","v":0},{"$f":"I22+I23","v":0},{"$f":"J22+J23","v":0}]
[null,null,null,"Operating Subsidies",null,{"$f":"'Inc & Exp'!C128+'Inc & Exp'!D128","v":0},{"$f":"'Inc & Exp'!C129+'Inc & Exp'!D129","v":0},{"$f":"'Inc & Exp'!C130+'Inc & Exp'!D130","v":0},{"$f":"'Inc & Exp'!C131+'Inc & Exp'!D131","v":0},{"$f":"'Inc & Exp'!C132+'Inc & Exp'!D132","v":0}]
[null,null,null,"Draw on Operating Reserves",null,{"$f":"'Inc & Exp'!E128","v":0},{"$f":"'Inc & Exp'!E129","v":0},{"$f":"'Inc & Exp'!E130","v":0},{"$f":"'Inc & Exp'!E131","v":0},{"$f":"'Inc & Exp'!E132","v":0}]
[null,null,"Total Effective Income",null,null,{"$f":"F24+F25+F26","v":0},{"$f":"G24+G25+G26","v":0},{"$f":"H24+H25+H26","v":0},{"$f":"I24+I25+I26","v":0},{"$f":"J24+J25+J26","v":0}]
[]
[null,null,"EXPENSES:"]
[null,null,null,"Administrative",null,{"$f":"'Inc & Exp'!G158","v":0},{"$f":"F30*(1+'Inc & Exp'!F$201)","v":0},{"$f":"G30*(1+'Inc & Exp'!G200)","v":0},{"$f":"H30*(1+'Inc & Exp'!H200)","v":0},{"$f":"I30*(1+'Inc & Exp'!I200)","v":0}]
[null,null,null,"Maintenance & Repair",null,{"$f":"'Inc & Exp'!G172","v":0},{"$f":"F31*(1+'Inc & Exp'!F$201)","v":0},{"$f":"G31*(1+'Inc & Exp'!G201)","v":0},{"$f":"H31*(1+'Inc & Exp'!H201)","v":0},{"$f":"I31*(1+'Inc & Exp'!I201)","v":0}]
[null,null,null,"Resident Services",null,{"$f":"'Inc & Exp'!G177","v":0},{"$f":"F32*(1+'Inc & Exp'!F$201)","v":0},{"$f":"G32*(1+'Inc & Exp'!G$201)","v":0},{"$f":"H32*(1+'Inc & Exp'!H$201)","v":0},{"$f":"I32*(1+'Inc & Exp'!I$201)","v":0}]
[null,null,null,"Security",null,{"$f":"'Inc & Exp'!G179","v":0},{"$f":"F33*(1+'Inc & Exp'!F$201)","v":0},{"$f":"G33*(1+'Inc & Exp'!G$201)","v":0},{"$f":"H33*(1+'Inc & Exp'!H$201)","v":0},{"$f":"I33*(1+'Inc & Exp'!I$201)","v":0}]
[null,null,null,"Electricity",null,{"$f":"'Inc & Exp'!G181","v":0},{"$f":"F34*(1+'Inc & Exp'!F$201)","v":0},{"$f":"G34*(1+'Inc & Exp'!G$201)","v":0},{"$f":"H34*(1+'Inc & Exp'!H$201)","v":0},{"$f":"I34*(1+'Inc & Exp'!I$201)","v":0}]
[null,null,null,"Gas ",null,{"$f":"'Inc & Exp'!G182","v":0},{"$f":"F35*(1+'Inc & Exp'!F$201)","v":0},{"$f":"G35*(1+'Inc & Exp'!G$201)","v":0},{"$f":"H35*(1+'Inc & Exp'!H$201)","v":0},{"$f":"I35*(1+'Inc & Exp'!I$201)","v":0}]
[null,null,null,"Oil",null,{"$f":"'Inc & Exp'!G183","v":0},{"$f":"F36*(1+'Inc & Exp'!F$201)","v":0},{"$f":"G36*(1+'Inc & Exp'!G$201)","v":0},{"$f":"H36*(1+'Inc & Exp'!H$201)","v":0},{"$f":"I36*(1+'Inc & Exp'!I$201)","v":0}]
[null,null,null,"Water & Sewer",null,{"$f":"'Inc & Exp'!G184","v":0},{"$f":"F37*(1+'Inc & Exp'!F199)","v":0},{"$f":"G37*(1+'Inc & Exp'!G199)","v":0},{"$f":"H37*(1+'Inc & Exp'!H199)","v":0},{"$f":"I37*(1+'Inc & Exp'!I199)","v":0}]
[null,null,null,"Replacement Reserve",null,{"$f":"'Inc & Exp'!G187","v":0},{"$f":"F38*(1+'Inc & Exp'!F201)","v":0},{"$f":"G38*(1+'Inc & Exp'!G201)","v":0},{"$f":"H38*(1+'Inc & Exp'!H201)","v":0},{"$f":"I38*(1+'Inc & Exp'!I201)","v":0}]
[null,null,null,"Real Estate Taxes",null,{"$f":"'Inc & Exp'!G189","v":0},{"$f":"F39*(1+'Inc & Exp'!F200)","v":0},{"$f":"G39*(1+'Inc & Exp'!G200)","v":0},{"$f":"H39*(1+'Inc & Exp'!H200)","v":0},{"$f":"I39*(1+'Inc & Exp'!I200)","v":0}]
[null,null,null,"Other Taxes",null,{"$f":"'Inc & Exp'!G190","v":0},{"$f":"F40*(1+'Inc & Exp'!F$201)","v":0},{"$f":"G40*(1+'Inc & Exp'!G$201)","v":0},{"$f":"H40*(1+'Inc & Exp'!H$201)","v":0},{"$f":"I40*(1+'Inc & Exp'!I$201)","v":0}]
[null,null,null,"Insurance",null,{"$f":"'Inc & Exp'!G191","v":0},{"$f":"F41*(1+'Inc & Exp'!F$201)","v":0},{"$f":"G41*(1+'Inc & Exp'!G$201)","v":0},{"$f":"H41*(1+'Inc & Exp'!H$201)","v":0},{"$f":"I41*(1+'Inc & Exp'!I$201)","v":0}]
[null,null,null,"Other:",{"$f":"IF(+'Inc & Exp'!D192=\"\",\" \",'Inc & Exp'!D192)","v":" "},{"$f":"'Inc & Exp'!G192","v":0},{"$f":"F42*(1+'Inc & Exp'!F$201)","v":0},{"$f":"G42*(1+'Inc & Exp'!G$201)","v":0},{"$f":"H42*(1+'Inc & Exp'!H$201)","v":0},{"$f":"I42*(1+'Inc & Exp'!I$201)","v":0}]
[null,null,"Total Operating Expenses",null,null,{"$f":"SUM(F30:F42)","v":0},{"$f":"SUM(G30:G42)","v":0},{"$f":"SUM(H30:H42)","v":0},{"$f":"SUM(I30:I42)","v":0},{"$f":"SUM(J30:J42)","v":0}]
[]
[null,null,"NET OPERATING INCOME",null,null,{"$f":"F27-F43","v":0},{"$f":"G27-G43","v":0},{"$f":"H27-H43","v":0},{"$f":"I27-I43","v":0},{"$f":"J27-J43","v":0}]
[]
[null,null,null,"Debt Service",null,{"$f":"'Inc & Exp'!$G$217","v":0},{"$f":"'Inc & Exp'!$G$217","v":0},{"$f":"'Inc & Exp'!$G$217","v":0},{"$f":"'Inc & Exp'!$G$217","v":0},{"$f":"'Inc & Exp'!$G$217","v":0}]
[null,null,null,"Debt Service Coverage",null,{"$f":"IF(F47>0,F45/F47,\"\")","v":""},{"$f":"IF(G47>0,G45/G47,\"               \")","v":"               "},{"$f":"IF(H47>0,H45/H47,\"               \")","v":"               "},{"$f":"IF(I47>0,I45/I47,\"               \")","v":"               "},{"$f":"IF(J47>0,J45/J47,\"               \")","v":"               "}]
[null,null,null,"Project Cash Flow",null,{"$f":"F45-F47","v":0},{"$f":"G45-G47","v":0},{"$f":"H45-H47","v":0},{"$f":"I45-I47","v":0},{"$f":"J45-J47","v":0}]
[]
[]
[]
[]
[null,{"$f":"B2","v":"NH Housing Financing Application"},null,null,null,null,null,null,null,"Page 2 of 4"]
[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,null,null,"Calendar Year:",{"$f":"IF(J8>0,J8+1,\"             N/A\")","v":"             N/A"},{"$f":"IF(F59>0,F59+1,\"             N/A\")","v":"             N/A"},{"$f":"IF(G59>0,G59+1,\"             N/A\")","v":"             N/A"},{"$f":"IF(H59>0,H59+1,\"             N/A\")","v":"             N/A"},{"$f":"IF(I59>0,I59+1,\"             N/A\")","v":"             N/A"}]
[null,null,"INCOME:"]
[null,null,null,"Market Rate Units",null,{"$f":"J10*(1+'Inc & Exp'!$I111)","v":0},{"$f":"F61*(1+'Inc & Exp'!$I$111)","v":0},{"$f":"G61*(1+'Inc & Exp'!$I111)","v":0},{"$f":"H61*(1+'Inc & Exp'!$I111)","v":0},{"$f":"I61*(1+'Inc & Exp'!$I111)","v":0}]
[null,null,null,"Tax Credit Units",null,{"$f":"J11*(1+'Inc & Exp'!$I112)","v":0},{"$f":"F62*(1+'Inc & Exp'!$I112)","v":0},{"$f":"G62*(1+'Inc & Exp'!$I112)","v":0},{"$f":"H62*(1+'Inc & Exp'!$I112)","v":0},{"$f":"I62*(1+'Inc & Exp'!$I112)","v":0}]
[null,null,null,"HOME Units",null,{"$f":"J12*(1+'Inc & Exp'!$I113)","v":0},{"$f":"F63*(1+'Inc & Exp'!$I113)","v":0},{"$f":"G63*(1+'Inc & Exp'!$I113)","v":0},{"$f":"H63*(1+'Inc & Exp'!$I113)","v":0},{"$f":"I63*(1+'Inc & Exp'!$I113)","v":0}]
[null,null,null,"HTF Units",null,{"$f":"J13*(1+'Inc & Exp'!$I114)","v":0},{"$f":"F64*(1+'Inc & Exp'!$I114)","v":0},{"$f":"G64*(1+'Inc & Exp'!$I114)","v":0},{"$f":"H64*(1+'Inc & Exp'!$I114)","v":0},{"$f":"I64*(1+'Inc & Exp'!$I114)","v":0}]
[null,null,null,"811 Units",null,{"$f":"J14*(1+'Inc & Exp'!$I115)","v":0},{"$f":"F65*(1+'Inc & Exp'!$I115)","v":0},{"$f":"G65*(1+'Inc & Exp'!$I115)","v":0},{"$f":"H65*(1+'Inc & Exp'!$I115)","v":0},{"$f":"I65*(1+'Inc & Exp'!$I115)","v":0}]
[null,null,null,"Rental Assisted Units",null,{"$f":"J15*(1+'Inc & Exp'!$I116)","v":0},{"$f":"F66*(1+'Inc & Exp'!$I116)","v":0},{"$f":"G66*(1+'Inc & Exp'!$I116)","v":0},{"$f":"H66*(1+'Inc & Exp'!$I116)","v":0},{"$f":"I66*(1+'Inc & Exp'!$I116)","v":0}]
[null,null,"Gross Potential Income",null,null,{"$f":"SUM(F61:F66)","v":0},{"$f":"SUM(G61:G66)","v":0},{"$f":"SUM(H61:H66)","v":0},{"$f":"SUM(I61:I66)","v":0},{"$f":"SUM(J61:J66)","v":0}]
[null,null,null,"   Less vacancy",null,{"$f":"(F61*'Inc & Exp'!$I$98)+(F62*'Inc & Exp'!$I$99)+(F63*'Inc & Exp'!$I$100)+(F64*'Inc & Exp'!$I$101)+(F65*'Inc & Exp'!$I$102)+(F66*'Inc & Exp'!$I$103)","v":0},{"$f":"(G61*'Inc & Exp'!$I$98)+(G62*'Inc & Exp'!$I$99)+(G63*'Inc & Exp'!$I$100)+(G64*'Inc & Exp'!$I$101)+(G65*'Inc & Exp'!$I$102)+(G66*'Inc & Exp'!$I$103)","v":0},{"$f":"(H61*'Inc & Exp'!$I$98)+(H62*'Inc & Exp'!$I$99)+(H63*'Inc & Exp'!$I$100)+(H64*'Inc & Exp'!$I$101)+(H65*'Inc & Exp'!$I$102)+(H66*'Inc & Exp'!$I$103)","v":0},{"$f":"(I61*'Inc & Exp'!$I$98)+(I62*'Inc & Exp'!$I$99)+(I63*'Inc & Exp'!$I$100)+(I64*'Inc & Exp'!$I$101)+(I65*'Inc & Exp'!$I$102)+(I66*'Inc & Exp'!$I$103)","v":0},{"$f":"(J61*'Inc & Exp'!$I$98)+(J62*'Inc & Exp'!$I$99)+(J63*'Inc & Exp'!$I$100)+(J64*'Inc & Exp'!$I$101)+(J65*'Inc & Exp'!$I$102)+(J66*'Inc & Exp'!$I$103)","v":0}]
[null,null,"Effective Gross Residential Income",null,null,{"$f":"F67-F68","v":0},{"$f":"G67-G68","v":0},{"$f":"H67-H68","v":0},{"$f":"I67-I68","v":0},{"$f":"J67-J68","v":0}]
[null,null,null,"Commercial Income",null,{"$f":"J19*(1+'Inc & Exp'!H117)","v":0},{"$f":"F70*(1+'Inc & Exp'!$H$117)","v":0},{"$f":"G70*(1+'Inc & Exp'!$H$117)","v":0},{"$f":"H70*(1+'Inc & Exp'!$H$117)","v":0},{"$f":"I70*(1+'Inc & Exp'!$H$117)","v":0}]
[null,null,null,"   Less vacancy",null,{"$f":"F70*'Inc & Exp'!$I$104","v":0},{"$f":"G70*'Inc & Exp'!$I$104","v":0},{"$f":"H70*'Inc & Exp'!$I$104","v":0},{"$f":"I70*'Inc & Exp'!$I$104","v":0},{"$f":"J70*'Inc & Exp'!$I$104","v":0}]
[null,null,null,"Net Commercial Income",null,{"$f":"F70-F71","v":0},{"$f":"G70-G71","v":0},{"$f":"H70-H71","v":0},{"$f":"I70-I71","v":0},{"$f":"J70-J71","v":0}]
[null,null,"Effective Rental Income",null,null,{"$f":"F69+F72","v":0},{"$f":"G69+G72","v":0},{"$f":"H69+H72","v":0},{"$f":"I69+I72","v":0},{"$f":"J69+J72","v":0}]
[null,null,null,"Other Income",null,{"$f":"J23*(1+'Inc & Exp'!H118)","v":0},{"$f":"F74*(1+'Inc & Exp'!$H$118)","v":0},{"$f":"G74*(1+'Inc & Exp'!$H$118)","v":0},{"$f":"H74*(1+'Inc & Exp'!$H$118)","v":0},{"$f":"I74*(1+'Inc & Exp'!$H$118)","v":0}]
[null,null,"Total Gross Income",null,null,{"$f":"F73+F74","v":0},{"$f":"G73+G74","v":0},{"$f":"H73+H74","v":0},{"$f":"I73+I74","v":0},{"$f":"J73+J74","v":0}]
[null,null,null,"Operating Subsidies",null,{"$f":"'Inc & Exp'!C133+'Inc & Exp'!D133","v":0},{"$f":"'Inc & Exp'!C134+'Inc & Exp'!D134","v":0},{"$f":"'Inc & Exp'!C135+'Inc & Exp'!D135","v":0},{"$f":"'Inc & Exp'!C136+'Inc & Exp'!D136","v":0},{"$f":"'Inc & Exp'!C137+'Inc & Exp'!D137","v":0}]
[null,null,null,"Draw on Operating Reserves",null,{"$f":"'Inc & Exp'!E133","v":0},{"$f":"'Inc & Exp'!E134","v":0},{"$f":"'Inc & Exp'!E135","v":0},{"$f":"'Inc & Exp'!E136","v":0},{"$f":"'Inc & Exp'!E137","v":0}]
[null,null,"Total Effective Income",null,null,{"$f":"F75+F76+F77","v":0},{"$f":"G75+G76+G77","v":0},{"$f":"H75+H76+H77","v":0},{"$f":"I75+I76+I77","v":0},{"$f":"J75+J76+J77","v":0}]
[]
[null,null,"EXPENSES:"]
[null,null,null,"Administrative",null,{"$f":"J30*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F81*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G81*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H81*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I81*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Maintenance & Repair",null,{"$f":"J31*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F82*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G82*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H82*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I82*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Resident Services",null,{"$f":"J32*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F83*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G83*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H83*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I83*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Security",null,{"$f":"J33*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F84*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G84*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H84*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I84*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Electricity",null,{"$f":"J34*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F85*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G85*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H85*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I85*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Gas ",null,{"$f":"J35*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F86*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G86*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H86*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I86*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Oil",null,{"$f":"J36*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F87*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G87*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H87*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I87*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Water & Sewer",null,{"$f":"J37*(1+'Inc & Exp'!$I$199)","v":0},{"$f":"F88*(1+'Inc & Exp'!$I$199)","v":0},{"$f":"G88*(1+'Inc & Exp'!$I$199)","v":0},{"$f":"H88*(1+'Inc & Exp'!$I$199)","v":0},{"$f":"I88*(1+'Inc & Exp'!$I$199)","v":0}]
[null,null,null,"Replacement Reserve",null,{"$f":"J38*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F89*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G89*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H89*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I89*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Real Estate Taxes",null,{"$f":"J39*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"F90*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"G90*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"H90*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"I90*(1+'Inc & Exp'!$I$200)","v":0}]
[null,null,null,"Other Taxes",null,{"$f":"J40*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"F91*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"G91*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"H91*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"I91*(1+'Inc & Exp'!$I$200)","v":0}]
[null,null,null,"Insurance",null,{"$f":"J41*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F92*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G92*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H92*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I92*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Other:",null,{"$f":"J42*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F93*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G93*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H93*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I93*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,"Total Operating Expenses",null,null,{"$f":"SUM(F81:F93)","v":0},{"$f":"SUM(G81:G93)","v":0},{"$f":"SUM(H81:H93)","v":0},{"$f":"SUM(I81:I93)","v":0},{"$f":"SUM(J81:J93)","v":0}]
[]
[null,null,"NET OPERATING INCOME",null,null,{"$f":"F78-F94","v":0},{"$f":"G78-G94","v":0},{"$f":"H78-H94","v":0},{"$f":"I78-I94","v":0},{"$f":"J78-J94","v":0}]
[]
[null,null,null,"Debt Service",null,{"$f":"'Inc & Exp'!$G$217","v":0},{"$f":"'Inc & Exp'!$G$217","v":0},{"$f":"'Inc & Exp'!$G$217","v":0},{"$f":"'Inc & Exp'!$G$217","v":0},{"$f":"'Inc & Exp'!$G$217","v":0}]
[null,null,null,"Debt Service Coverage",null,{"$f":"IF(F98>0,F96/F98,\"               \")","v":"               "},{"$f":"IF(G98>0,G96/G98,\"               \")","v":"               "},{"$f":"IF(H98>0,H96/H98,\"               \")","v":"               "},{"$f":"IF(I98>0,I96/I98,\"               \")","v":"               "},{"$f":"IF(J98>0,J96/J98,\"               \")","v":"               "}]
[null,null,null,"Project Cash Flow",null,{"$f":"F96-F98","v":0},{"$f":"G96-G98","v":0},{"$f":"H96-H98","v":0},{"$f":"I96-I98","v":0},{"$f":"J96-J98","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,"Ten-year projected cash flow",{"$f":"SUM(F100:J100,F49:J49)","v":0}]
[]
[]
[]
[null,{"$f":"B54","v":"NH Housing Financing Application"},null,null,null,null,null,null,null,"Page 3 of 4"]
[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,null,null,"Calendar Year:",{"$f":"IF(J59>0,J59+1,\"             N/A\")","v":"             N/A"},{"$f":"IF(F112>0,F112+1,\"             N/A\")","v":"             N/A"},{"$f":"IF(G112>0,G112+1,\"             N/A\")","v":"             N/A"},{"$f":"IF(H112>0,H112+1,\"             N/A\")","v":"             N/A"},{"$f":"IF(I112>0,I112+1,\"             N/A\")","v":"             N/A"}]
[null,null,"INCOME:"]
[null,null,null,"Market Rate Units",null,{"$f":"J61*(1+'Inc & Exp'!$I111)","v":0},{"$f":"F114*(1+'Inc & Exp'!$I111)","v":0},{"$f":"G114*(1+'Inc & Exp'!$I111)","v":0},{"$f":"H114*(1+'Inc & Exp'!$I111)","v":0},{"$f":"I114*(1+'Inc & Exp'!$I111)","v":0}]
[null,null,null,"Tax Credit Units",null,{"$f":"J62*(1+'Inc & Exp'!$I112)","v":0},{"$f":"F115*(1+'Inc & Exp'!$I112)","v":0},{"$f":"G115*(1+'Inc & Exp'!$I112)","v":0},{"$f":"H115*(1+'Inc & Exp'!$I112)","v":0},{"$f":"I115*(1+'Inc & Exp'!$I112)","v":0}]
[null,null,null,"HOME Units",null,{"$f":"J63*(1+'Inc & Exp'!$I113)","v":0},{"$f":"F116*(1+'Inc & Exp'!$I113)","v":0},{"$f":"G116*(1+'Inc & Exp'!$I113)","v":0},{"$f":"H116*(1+'Inc & Exp'!$I113)","v":0},{"$f":"I116*(1+'Inc & Exp'!$I113)","v":0}]
[null,null,null,"HTF Units",null,{"$f":"J64*(1+'Inc & Exp'!$I114)","v":0},{"$f":"F117*(1+'Inc & Exp'!$I114)","v":0},{"$f":"G117*(1+'Inc & Exp'!$I114)","v":0},{"$f":"H117*(1+'Inc & Exp'!$I114)","v":0},{"$f":"I117*(1+'Inc & Exp'!$I114)","v":0}]
[null,null,null,"811 Units",null,{"$f":"J65*(1+'Inc & Exp'!$I115)","v":0},{"$f":"F118*(1+'Inc & Exp'!$I115)","v":0},{"$f":"G118*(1+'Inc & Exp'!$I115)","v":0},{"$f":"H118*(1+'Inc & Exp'!$I115)","v":0},{"$f":"I118*(1+'Inc & Exp'!$I115)","v":0}]
[null,null,null,"Rental Assisted Units",null,{"$f":"J66*(1+'Inc & Exp'!$I116)","v":0},{"$f":"F119*(1+'Inc & Exp'!$I116)","v":0},{"$f":"G119*(1+'Inc & Exp'!$I116)","v":0},{"$f":"H119*(1+'Inc & Exp'!$I116)","v":0},{"$f":"I119*(1+'Inc & Exp'!$I116)","v":0}]
[null,null,"Gross Potential Income",null,null,{"$f":"SUM(F114:F119)","v":0},{"$f":"SUM(G114:G119)","v":0},{"$f":"SUM(H114:H119)","v":0},{"$f":"SUM(I114:I119)","v":0},{"$f":"SUM(J114:J119)","v":0}]
[null,null,null,"   Less vacancy",null,{"$f":"(F114*'Inc & Exp'!$I$98)+(F115*'Inc & Exp'!$I$99)+(F116*'Inc & Exp'!$I$100)+(F117*'Inc & Exp'!$I$101)+(F118*'Inc & Exp'!$I$102)+(F119*'Inc & Exp'!$I$103)","v":0},{"$f":"(G114*'Inc & Exp'!$I$98)+(G115*'Inc & Exp'!$I$99)+(G116*'Inc & Exp'!$I$100)+(G117*'Inc & Exp'!$I$101)+(G118*'Inc & Exp'!$I$102)+(G119*'Inc & Exp'!$I$103)","v":0},{"$f":"(H114*'Inc & Exp'!$I$98)+(H115*'Inc & Exp'!$I$99)+(H116*'Inc & Exp'!$I$100)+(H117*'Inc & Exp'!$I$101)+(H118*'Inc & Exp'!$I$102)+(H119*'Inc & Exp'!$I$103)","v":0},{"$f":"(I114*'Inc & Exp'!$I$98)+(I115*'Inc & Exp'!$I$99)+(I116*'Inc & Exp'!$I$100)+(I117*'Inc & Exp'!$I$101)+(I118*'Inc & Exp'!$I$102)+(I119*'Inc & Exp'!$I$103)","v":0},{"$f":"(J114*'Inc & Exp'!$I$98)+(J115*'Inc & Exp'!$I$99)+(J116*'Inc & Exp'!$I$100)+(J117*'Inc & Exp'!$I$101)+(J118*'Inc & Exp'!$I$102)+(J119*'Inc & Exp'!$I$103)","v":0}]
[null,null,"Effective Gross Residential Income",null,null,{"$f":"F120-F121","v":0},{"$f":"G120-G121","v":0},{"$f":"H120-H121","v":0},{"$f":"I120-I121","v":0},{"$f":"J120-J121","v":0}]
[null,null,null,"Commercial Income",null,{"$f":"J70*(1+'Inc & Exp'!$H$117)","v":0},{"$f":"F123*(1+'Inc & Exp'!$H$117)","v":0},{"$f":"G123*(1+'Inc & Exp'!$H$117)","v":0},{"$f":"H123*(1+'Inc & Exp'!$H$117)","v":0},{"$f":"I123*(1+'Inc & Exp'!$H$117)","v":0}]
[null,null,null,"   Less vacancy",null,{"$f":"F123*'Inc & Exp'!$I$104","v":0},{"$f":"G123*'Inc & Exp'!$I$104","v":0},{"$f":"H123*'Inc & Exp'!$I$104","v":0},{"$f":"I123*'Inc & Exp'!$I$104","v":0},{"$f":"J123*'Inc & Exp'!$I$104","v":0}]
[null,null,null,"Net Commercial Income",null,{"$f":"F123-F124","v":0},{"$f":"G123-G124","v":0},{"$f":"H123-H124","v":0},{"$f":"I123-I124","v":0},{"$f":"J123-J124","v":0}]
[null,null,"Effective Rental Income",null,null,{"$f":"F122+F125","v":0},{"$f":"G122+G125","v":0},{"$f":"H122+H125","v":0},{"$f":"I122+I125","v":0},{"$f":"J122+J125","v":0}]
[null,null,null,"Other Income",null,{"$f":"J74*(1+'Inc & Exp'!$H$118)","v":0},{"$f":"F127*(1+'Inc & Exp'!$H$118)","v":0},{"$f":"G127*(1+'Inc & Exp'!$H$118)","v":0},{"$f":"H127*(1+'Inc & Exp'!$H$118)","v":0},{"$f":"I127*(1+'Inc & Exp'!$H$118)","v":0}]
[null,null,"Total Gross Income",null,null,{"$f":"F126+F127","v":0},{"$f":"G126+G127","v":0},{"$f":"H126+H127","v":0},{"$f":"I126+I127","v":0},{"$f":"J126+J127","v":0}]
[null,null,null,"Operating Subsidies",null,{"$f":"'Inc & Exp'!G128+'Inc & Exp'!H128","v":0},{"$f":"'Inc & Exp'!G129+'Inc & Exp'!H129","v":0},{"$f":"'Inc & Exp'!G130+'Inc & Exp'!H130","v":0},{"$f":"'Inc & Exp'!G131+'Inc & Exp'!H131","v":0},{"$f":"'Inc & Exp'!G132+'Inc & Exp'!H132","v":0}]
[null,null,null,"Draw on Operating Reserves",null,{"$f":"'Inc & Exp'!I128","v":0},{"$f":"'Inc & Exp'!I129","v":0},{"$f":"'Inc & Exp'!I130","v":0},{"$f":"'Inc & Exp'!I131","v":0},{"$f":"'Inc & Exp'!I132","v":0}]
[null,null,"Total Effective Income",null,null,{"$f":"F128+F129+F130","v":0},{"$f":"G128+G129+G130","v":0},{"$f":"H128+H129+H130","v":0},{"$f":"I128+I129+I130","v":0},{"$f":"J128+J129+J130","v":0}]
[]
[null,null,"EXPENSES:"]
[null,null,null,"Administrative",null,{"$f":"J81*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F134*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G134*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H134*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I134*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Maintenance & Repair",null,{"$f":"J82*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F135*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G135*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H135*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I135*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Resident Services",null,{"$f":"J83*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F136*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G136*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H136*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I136*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Security",null,{"$f":"J84*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F137*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G137*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H137*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I137*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Electricity",null,{"$f":"J85*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F138*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G138*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H138*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I138*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Gas ",null,{"$f":"J86*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F139*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G139*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H139*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I139*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Oil",null,{"$f":"J87*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F140*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G140*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H140*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I140*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Water & Sewer",null,{"$f":"J88*(1+'Inc & Exp'!$I$199)","v":0},{"$f":"F141*(1+'Inc & Exp'!$I$199)","v":0},{"$f":"G141*(1+'Inc & Exp'!$I$199)","v":0},{"$f":"H141*(1+'Inc & Exp'!$I$199)","v":0},{"$f":"I141*(1+'Inc & Exp'!$I$199)","v":0}]
[null,null,null,"Replacement Reserve",null,{"$f":"J89*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F142*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G142*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H142*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I142*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Real Estate Taxes",null,{"$f":"J90*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"F143*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"G143*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"H143*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"I143*(1+'Inc & Exp'!$I$200)","v":0}]
[null,null,null,"Other Taxes",null,{"$f":"J91*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"F144*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"G144*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"H144*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"I144*(1+'Inc & Exp'!$I$200)","v":0}]
[null,null,null,"Insurance",null,{"$f":"J92*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F145*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G145*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H145*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I145*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Other:",{"$f":"IF(+'LIHTC Info'!D48=\"\",\" \",'LIHTC Info'!D48)","v":" "},{"$f":"J93*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F146*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G146*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H146*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I146*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,"Total Operating Expenses",null,null,{"$f":"SUM(F134:F146)","v":0},{"$f":"SUM(G134:G146)","v":0},{"$f":"SUM(H134:H146)","v":0},{"$f":"SUM(I134:I146)","v":0},{"$f":"SUM(J134:J146)","v":0}]
[]
[null,null,"NET OPERATING INCOME",null,null,{"$f":"F131-F147","v":0},{"$f":"G131-G147","v":0},{"$f":"H131-H147","v":0},{"$f":"I131-I147","v":0},{"$f":"J131-J147","v":0}]
[]
[null,null,null,"Debt Service",null,{"$f":"'Inc & Exp'!$G$217","v":0},{"$f":"'Inc & Exp'!$G$217","v":0},{"$f":"'Inc & Exp'!$G$217","v":0},{"$f":"'Inc & Exp'!$G$217","v":0},{"$f":"'Inc & Exp'!$G$217","v":0}]
[null,null,null,"Debt Service Coverage",null,{"$f":"IF(F151>0,F149/F151,\"               \")","v":"               "},{"$f":"IF(G151>0,G149/G151,\"               \")","v":"               "},{"$f":"IF(H151>0,H149/H151,\"               \")","v":"               "},{"$f":"IF(I151>0,I149/I151,\"               \")","v":"               "},{"$f":"IF(J151>0,J149/J151,\"               \")","v":"               "}]
[null,null,null,"Project Cash Flow",null,{"$f":"F149-F151","v":0},{"$f":"G149-G151","v":0},{"$f":"H149-H151","v":0},{"$f":"I149-I151","v":0},{"$f":"J149-J151","v":0}]
[null,null,null,"Operating Deficit",null,{"$f":"IF(F153>0,0,F153)","v":0},{"$f":"IF(G153>0,0,G153)","v":0},{"$f":"IF(H153>0,0,H153)","v":0},0,0]
[]
[]
[]
[]
[]
[null,{"$f":"B107","v":"NH Housing Financing Application"},null,null,null,null,null,null,null,"Page 4 of 4"]
[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,null,null,"Calendar Year:",{"$f":"IF(J112>0,J112+1,\"             N/A\")","v":"             N/A"},{"$f":"IF(F165>0,F165+1,\"             N/A\")","v":"             N/A"},{"$f":"IF(G165>0,G165+1,\"             N/A\")","v":"             N/A"},{"$f":"IF(H165>0,H165+1,\"             N/A\")","v":"             N/A"},{"$f":"IF(I165>0,I165+1,\"             N/A\")","v":"             N/A"}]
[null,null,"INCOME:"]
[null,null,null,"Market Rate Units",null,{"$f":"J114*(1+'Inc & Exp'!$I111)","v":0},{"$f":"F167*(1+'Inc & Exp'!$I111)","v":0},{"$f":"G167*(1+'Inc & Exp'!$I111)","v":0},{"$f":"H167*(1+'Inc & Exp'!$I111)","v":0},{"$f":"I167*(1+'Inc & Exp'!$I111)","v":0}]
[null,null,null,"Tax Credit Units",null,{"$f":"J115*(1+'Inc & Exp'!$I112)","v":0},{"$f":"F168*(1+'Inc & Exp'!$I112)","v":0},{"$f":"G168*(1+'Inc & Exp'!$I112)","v":0},{"$f":"H168*(1+'Inc & Exp'!$I112)","v":0},{"$f":"I168*(1+'Inc & Exp'!$I112)","v":0}]
[null,null,null,"HOME Units",null,{"$f":"J116*(1+'Inc & Exp'!$I113)","v":0},{"$f":"F169*(1+'Inc & Exp'!$I113)","v":0},{"$f":"G169*(1+'Inc & Exp'!$I113)","v":0},{"$f":"H169*(1+'Inc & Exp'!$I113)","v":0},{"$f":"I169*(1+'Inc & Exp'!$I113)","v":0}]
[null,null,null,"HTF Units",null,{"$f":"J117*(1+'Inc & Exp'!$I114)","v":0},{"$f":"F170*(1+'Inc & Exp'!$I114)","v":0},{"$f":"G170*(1+'Inc & Exp'!$I114)","v":0},{"$f":"H170*(1+'Inc & Exp'!$I114)","v":0},{"$f":"I170*(1+'Inc & Exp'!$I114)","v":0}]
[null,null,null,"811 Units",null,{"$f":"J118*(1+'Inc & Exp'!$I115)","v":0},{"$f":"F171*(1+'Inc & Exp'!$I115)","v":0},{"$f":"G171*(1+'Inc & Exp'!$I115)","v":0},{"$f":"H171*(1+'Inc & Exp'!$I115)","v":0},{"$f":"I171*(1+'Inc & Exp'!$I115)","v":0}]
[null,null,null,"Rental Assisted Units",null,{"$f":"J119*(1+'Inc & Exp'!$I116)","v":0},{"$f":"F172*(1+'Inc & Exp'!$I116)","v":0},{"$f":"G172*(1+'Inc & Exp'!$I116)","v":0},{"$f":"H172*(1+'Inc & Exp'!$I116)","v":0},{"$f":"I172*(1+'Inc & Exp'!$I116)","v":0}]
[null,null,"Gross Potential Income",null,null,{"$f":"SUM(F167:F172)","v":0},{"$f":"SUM(G167:G172)","v":0},{"$f":"SUM(H167:H172)","v":0},{"$f":"SUM(I167:I172)","v":0},{"$f":"SUM(J167:J172)","v":0}]
[null,null,null,"   Less vacancy",null,{"$f":"(F167*'Inc & Exp'!$I$98)+(F168*'Inc & Exp'!$I$99)+(F169*'Inc & Exp'!$I$100)+(F170*'Inc & Exp'!$I$101)+(F171*'Inc & Exp'!$I$102)+(F172*'Inc & Exp'!$I$103)","v":0},{"$f":"(G167*'Inc & Exp'!$I$98)+(G168*'Inc & Exp'!$I$99)+(G169*'Inc & Exp'!$I$100)+(G170*'Inc & Exp'!$I$101)+(G171*'Inc & Exp'!$I$102)+(G172*'Inc & Exp'!$I$103)","v":0},{"$f":"(H167*'Inc & Exp'!$I$98)+(H168*'Inc & Exp'!$I$99)+(H169*'Inc & Exp'!$I$100)+(H170*'Inc & Exp'!$I$101)+(H171*'Inc & Exp'!$I$102)+(H172*'Inc & Exp'!$I$103)","v":0},{"$f":"(I167*'Inc & Exp'!$I$98)+(I168*'Inc & Exp'!$I$99)+(I169*'Inc & Exp'!$I$100)+(I170*'Inc & Exp'!$I$101)+(I171*'Inc & Exp'!$I$102)+(I172*'Inc & Exp'!$I$103)","v":0},{"$f":"(J167*'Inc & Exp'!$I$98)+(J168*'Inc & Exp'!$I$99)+(J169*'Inc & Exp'!$I$100)+(J170*'Inc & Exp'!$I$101)+(J171*'Inc & Exp'!$I$102)+(J172*'Inc & Exp'!$I$103)","v":0}]
[null,null,"Effective Gross Residential Income",null,null,{"$f":"F173-F174","v":0},{"$f":"G173-G174","v":0},{"$f":"H173-H174","v":0},{"$f":"I173-I174","v":0},{"$f":"J173-J174","v":0}]
[null,null,null,"Commercial Income",null,{"$f":"J123*(1+'Inc & Exp'!$H$117)","v":0},{"$f":"F176*(1+'Inc & Exp'!$H$117)","v":0},{"$f":"G176*(1+'Inc & Exp'!$H$117)","v":0},{"$f":"H176*(1+'Inc & Exp'!$H$117)","v":0},{"$f":"I176*(1+'Inc & Exp'!$H$117)","v":0}]
[null,null,null,"   Less vacancy",null,{"$f":"F176*'Inc & Exp'!$I$104","v":0},{"$f":"G176*'Inc & Exp'!$I$104","v":0},{"$f":"H176*'Inc & Exp'!$I$104","v":0},{"$f":"I176*'Inc & Exp'!$I$104","v":0},{"$f":"J176*'Inc & Exp'!$I$104","v":0}]
[null,null,null,"Net Commercial Income",null,{"$f":"F176-F177","v":0},{"$f":"G176-G177","v":0},{"$f":"H176-H177","v":0},{"$f":"I176-I177","v":0},{"$f":"J176-J177","v":0}]
[null,null,"Effective Rental Income",null,null,{"$f":"F175+F178","v":0},{"$f":"G175+G178","v":0},{"$f":"H175+H178","v":0},{"$f":"I175+I178","v":0},{"$f":"J175+J178","v":0}]
[null,null,null,"Other Income",null,{"$f":"J127*(1+'Inc & Exp'!$H$118)","v":0},{"$f":"F180*(1+'Inc & Exp'!$H$118)","v":0},{"$f":"G180*(1+'Inc & Exp'!$H$118)","v":0},{"$f":"H180*(1+'Inc & Exp'!$H$118)","v":0},{"$f":"I180*(1+'Inc & Exp'!$H$118)","v":0}]
[null,null,"Total Gross Income",null,null,{"$f":"F179+F180","v":0},{"$f":"G179+G180","v":0},{"$f":"H179+H180","v":0},{"$f":"I179+I180","v":0},{"$f":"J179+J180","v":0}]
[null,null,null,"Operating Subsidies",null,{"$f":"'Inc & Exp'!G133+'Inc & Exp'!H133","v":0},{"$f":"'Inc & Exp'!G134+'Inc & Exp'!H134","v":0},{"$f":"'Inc & Exp'!G135+'Inc & Exp'!H135","v":0},{"$f":"'Inc & Exp'!G136+'Inc & Exp'!H136","v":0},{"$f":"'Inc & Exp'!G137+'Inc & Exp'!H137","v":0}]
[null,null,null,"Draw on Operating Reserves",null,{"$f":"'Inc & Exp'!I133","v":0},{"$f":"'Inc & Exp'!I134","v":0},{"$f":"'Inc & Exp'!I135","v":0},{"$f":"'Inc & Exp'!I136","v":0},{"$f":"'Inc & Exp'!I137","v":0}]
[null,null,"Total Effective Income",null,null,{"$f":"F181+F182+F183","v":0},{"$f":"G181+G182+G183","v":0},{"$f":"H181+H182+H183","v":0},{"$f":"I181+I182+I183","v":0},{"$f":"J181+J182+J183","v":0}]
[]
[null,null,"EXPENSES:"]
[null,null,null,"Administrative",null,{"$f":"J134*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F187*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G187*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H187*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I187*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Maintenance & Repair",null,{"$f":"J135*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F188*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G188*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H188*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I188*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Resident Services",null,{"$f":"J136*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F189*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G189*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H189*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I189*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Security",null,{"$f":"J137*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F190*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G190*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H190*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I190*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Electricity",null,{"$f":"J138*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F191*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G191*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H191*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I191*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Gas ",null,{"$f":"J139*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F192*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G192*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H192*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I192*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Oil",null,{"$f":"J140*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F193*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G193*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H193*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I193*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Water & Sewer",null,{"$f":"J141*(1+'Inc & Exp'!$I$199)","v":0},{"$f":"F194*(1+'Inc & Exp'!$I$199)","v":0},{"$f":"G194*(1+'Inc & Exp'!$I$199)","v":0},{"$f":"H194*(1+'Inc & Exp'!$I$199)","v":0},{"$f":"I194*(1+'Inc & Exp'!$I$199)","v":0}]
[null,null,null,"Replacement Reserve",null,{"$f":"J142*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F195*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G195*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H195*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I195*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Real Estate Taxes",null,{"$f":"J143*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"F196*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"G196*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"H196*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"I196*(1+'Inc & Exp'!$I$200)","v":0}]
[null,null,null,"Other Taxes",null,{"$f":"J144*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"F197*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"G197*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"H197*(1+'Inc & Exp'!$I$200)","v":0},{"$f":"I197*(1+'Inc & Exp'!$I$200)","v":0}]
[null,null,null,"Insurance",null,{"$f":"J145*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F198*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G198*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H198*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I198*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,null,"Other:",{"$f":"IF(+'LIHTC Info'!D115=\"\",\" \",'LIHTC Info'!D115)","v":" "},{"$f":"J146*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"F199*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"G199*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"H199*(1+'Inc & Exp'!$I$201)","v":0},{"$f":"I199*(1+'Inc & Exp'!$I$201)","v":0}]
[null,null,"Total Operating Expenses",null,null,{"$f":"SUM(F187:F199)","v":0},{"$f":"SUM(G187:G199)","v":0},{"$f":"SUM(H187:H199)","v":0},{"$f":"SUM(I187:I199)","v":0},{"$f":"SUM(J187:J199)","v":0}]
[]
[null,null,"NET OPERATING INCOME",null,null,{"$f":"F184-F200","v":0},{"$f":"G184-G200","v":0},{"$f":"H184-H200","v":0},{"$f":"I184-I200","v":0},{"$f":"J184-J200","v":0}]
[]
[null,null,null,"Debt Service",null,{"$f":"'Inc & Exp'!$G$217","v":0},{"$f":"'Inc & Exp'!$G$217","v":0},{"$f":"'Inc & Exp'!$G$217","v":0},{"$f":"'Inc & Exp'!$G$217","v":0},{"$f":"'Inc & Exp'!$G$217","v":0}]
[null,null,null,"Debt Service Coverage",null,{"$f":"IF(F204>0,F202/F204,\"               \")","v":"               "},{"$f":"IF(G204>0,G202/G204,\"               \")","v":"               "},{"$f":"IF(H204>0,H202/H204,\"               \")","v":"               "},{"$f":"IF(I204>0,I202/I204,\"               \")","v":"               "},{"$f":"IF(J204>0,J202/J204,\"               \")","v":"               "}]
[null,null,null,"Project Cash Flow",null,{"$f":"F202-F204","v":0},{"$f":"G202-G204","v":0},{"$f":"H202-H204","v":0},{"$f":"I202-I204","v":0},{"$f":"J202-J204","v":0}]
[null,null,null,"Operating Deficit",null,{"$f":"IF(F206>0,0,F206)","v":0},{"$f":"IF(G206>0,0,G206)","v":0},{"$f":"IF(H206>0,0,H206)","v":0},{"$f":"IF(I206>0,0,I206)","v":0},{"$f":"IF(J206>0,0,J206)","v":0}]
[]
[null,null,null,null,null,null,null,null,"Operating Deficit",{"$f":"SUM(F207:J207,F154:J154)","v":0}]
[null,null,null,null,null,null,null,null,"Operating Reserve",{"$f":"'Closing S&U'!$E$186","v":0}]

{"sheet":"LIHTC Info","index":6,"n_rows":164,"n_cols":9,"rows_kept":164,"cut":false,"hidden":false,"merged":[[18,2,18,8]]}
["LOW INCOME HOUSING TAX CREDITS"]
[{"$f":"'Closing S&U'!A2","v":"Un-named Project"}]
[null,null," "]
[null,null,"Percent of Project Which Qualifies for Tax Credit:"]
[]
[1,".","Low-Income Units*",null,{"$f":"'Project Info'!N69-'Project Info'!D69","v":0},null,"Total Units ",{"$f":"'Project Info'!N69","v":0}]
[{"$f":"A6+1","v":2},".","Percent of Units ",null,{"$f":"IF(H6>0,E6/H6,0)","v":0}]
[]
[{"$f":"A7+1","v":3},".","Low-Income Square Feet*",null,null,"(net rentable)","Total Area",{"$f":"'Project Info'!F126","v":0},"(net rentable)"]
[{"$f":"A9+1","v":4},".","Percent of Area ",null,{"$f":"IF(H9>0,E9/H9,0)","v":0}]
[null,null,null,"*  Applies to only housing units that qualify for tax credits"]
[{"$f":"A10+1","v":5},".","Applicable fraction",null,{"$f":"IF(E10>E7,E7,E10)","v":0},"   (This is the lower of 2 or 4 above.)"]
[{"$f":"A12+1","v":6},".","Is the project utilizing tax-exempt financing?",null,null,null,null,null," (\"yes\" or \"no\")"]
[7,".","Enter applicable percentage for acquisition credit if project qualifies**",null,null,null,null,0," (.04 or actual)"]
[8,".","Enter applicable percentage for rehabilitation credit or new construction**",null,null,null,null,0.09," (.04,.09 or actual)"]
[9,".","How much financing is non-qualified (federally subsidized?)",null,null,null,null,0," (Enter  $s)"]
[10,".","What grant funds must be subtracted from acquisition basis?",null,null,null,null,0," (Enter  $s)"]
[11,".","What grant funds must be subtracted from rehabilitation basis?",null,null,null,null,0," (Enter  $s)"]
[null,null,"** If you have or intend to lock into an applicable percentage enter the actual percentages for the month in which you locked in."]
[null,null,"Historic Tax Credit:"]
[{"$f":"A18+1","v":12},".","Does the project qualify for historic rehabilitation tax credits?",null,null,null,null,"no"," (\"yes\" or \"no\")"]
[{"$f":"A21+1","v":13},".","If yes, what are the rehabilitation costs which are not qualified for"]
[null,null,"historic credits?",null,null,null,null,0," (Enter  $s)"]
[]
[null,null,"Project Qualification for 130%:"]
[{"$f":"A22+1","v":14},".","Is the project located in a qualified census tract (QCT) or",null,null,null,null,null," (\"yes\" or \"no\")"]
[null,null,"difficult to develop area (DDA)? OR does the project require the basis boost",null,null,null,null,{"$f":"IF(H26=\"\",\"\",IF(OR(CODE(H26)=121,CODE(H26)=89),0,1))","v":""}]
[null,null,"to be financially feasible (25% of units MUST be 50% AMI)?",null,null,null,null,null,"Rehabilitation/"]
[null,null,null,null,null,null,"Acquisition",null,"Construction"]
[null,null,"Calculation of Maximum Tax Credit Amount",null,null,null,"Credit",null,"Credit"]
[{"$f":"A26+1","v":15},".","Total Eligible Development Costs",null,null,null,{"$f":"G159","v":0},null,{"$f":"H159","v":0}]
[{"$f":"A31+1","v":16},".","Less:  Portion of Grants Allocated to Basis",null,null,null,{"$f":"H17","v":0},null,{"$f":"H18","v":0}]
[17,".","Less:  20% Historic Rehab Credit Basis Reduction",null,null,null,0,null,{"$f":"IF(H159=\"\",\"\",IF(CODE(H21)=121,(H159-H23)*0.2,\"0\"))","v":"0"}]
[18,".","Less:  Non-qualified source of financing",null,null,null,0,null,0]
[19,".","Subtotal:  Eligible Basis",null,null,null,{"$f":"G31-G32-G33-G34","v":0},null,{"$f":"I31-I32-I33-I34","v":0}]
[20,".","Adjustment for Basis Boost",null,null,null,null,null,{"$f":"IF(H26<>\" \",IF(H27=0,1.3,1),1)","v":1}]
[21,".","Percent Low-Income",null,null,null,{"$f":"ROUND(+E12,3)","v":0},null,{"$f":"ROUND(+E12,3)","v":0}]
[22,".","Qualified Basis",null,null,null,{"$f":"G35*G37","v":0},null,{"$f":"I35*I36*I37","v":0}]
[23,".","Applicable Percentage",null,null,null,{"$f":"IF(H14=\"\",\"\",H14)","v":0},null,{"$f":"IF(H15=\"\",\"\",H15)","v":0.09}]
[24,".","Maximum Annual Tax Credit Amount",null,null,null,{"$f":"G38*G39","v":0},null,{"$f":"I38*I39","v":0}]
[25,".","Total Annual Tax Credit Amount",null,null,null,null,467844]
[26,".","Estimated Net*** LIHTC Equity Yield$",null,null,null," per dollar",{"$f":"H41*F42*10*0.9999","v":0}]
[27,".","Est. Net Historic Tax Credit Syn. Yield $ ",null,null,null," per dollar",{"$f":"I33*F43","v":0}]
[28,".","Total Equity Generated from Tax Credits",null,null,null,null,{"$f":"H43+H42","v":0}]
[29,".","Applicant's Estimate of Net Tax Credit Equity",null,null,null,null,{"$f":"'Closing S&U'!G7","v":0}," (Closing S&U Tab, Line 2)"]
[null,null,"***  Equity yield should be net of all syndication and bridge loan related costs."]
[]
[]
[]
[]
[]
[{"$f":"A45+1","v":30},".","Does the owner agree to extend the project's rent restrictions 30 or 60 years, per the QAP?",null,null,null,null,null," (\"yes\" or \"no\")"]
[null,null,"(See QAP for extended discussion of extended use restrictions)."]
[]
[{"$f":"A52+1","v":31},null,"All projects must be smoke free within the building(s); do you agree to meet this",null,null,null,null,null," (\"yes\" or \"no\")"]
[null,null,"requirement for the term of the LIHTC LURA?"]
[]
[{"$f":"A55+1","v":32},null,"All project sponsors must provide written notice to the local Public Housing Authority",null,null,null,null,null," (\"yes\" or \"no\")"]
[null,null,"with jurisdiction over the project location (or, where there is no local PHA, the Section 8"]
[null,null,"Administrator for the State of NH) that the project will accept tenant-based vouchers. "]
[null,null,"Do you agree to meet this requirement for the term of the LIHTC LURA?"]
[]
[{"$f":"A58+1","v":33},".","Minimum Set Aside Election: (Check one)",null,null,"20% at 50%"]
[null,null,null,null,null,"40% at 60%"," "]
[null,null,null,null,null,"Average Income Test"," "]
[]
[null,null,"DEVELOPMENT BUDGET AND CALCULATION OF TAX CREDIT BASIS:",null,null,null,{"$f":"IF(E159=(G159+H159+I159),\"\",\"Warning: TDC does not match basis/non basis column totals!\")","v":""}]
[null,null,"Note: Some items automatically placed in the appropriate basis column for convenience - please confirm each item"]
[null,null,null,null,null,"$"]
[null,null,null,null,null,"Percentage of"]
[null,null,null,{"$f":"E159-(G159+H159+I159)","v":0},"$"," Costs Not ","            $                          $                         $"]
[null,null,null,null,"Total","in Depreciable","Acquisition","New Cons/Rehab","Not In"]
[null,null,null,null,"Residential","Basis","Credit Basis","Credit Basis","Basis"]
[null,null,"ACQUISITION & CONSTRUCTION"]
[{"$f":"A63+1","v":34},".",{"$f":"'Closing S&U'!C115","v":"Land"},null,{"$f":"'Closing S&U'!E115","v":0},0,0,0,0]
[{"$f":"A75+1","v":35},".",{"$f":"'Closing S&U'!C116","v":"Existing  Building"},null,{"$f":"'Closing S&U'!E116","v":0},0,0,0,0]
[{"$f":"A76+1","v":36},".",{"$f":"'Closing S&U'!C117","v":"Construction Budget"},null,{"$f":"'Closing S&U'!E117","v":0},0,0,0,0]
[{"$f":"A77+1","v":37},".",{"$f":"'Closing S&U'!C118","v":"Construction Contingency"},null,{"$f":"'Closing S&U'!E118","v":0},0,0,0,0]
[{"$f":"A78+1","v":38},".",{"$f":"'Closing S&U'!C119","v":0},null,{"$f":"'Closing S&U'!E119","v":0},0,0,0,0]
[null,null,"        Subtotal",null,{"$f":"SUM(E75:E79)","v":0},null,{"$f":"SUM(G75:G79)","v":0},{"$f":"SUM(H75:H79)","v":0},{"$f":"SUM(I75:I79)","v":0}]
[null,null,"ARCHITECTURAL AND ENGINEERING"]
[{"$f":"A79+1","v":39},".",{"$f":"'Closing S&U'!C122","v":"Architect Fee-Design"},null,{"$f":"'Closing S&U'!E122","v":0},0,0,0,0]
[{"$f":"A82+1","v":40},".",{"$f":"'Closing S&U'!C123","v":"Architect Fee-Inspection"},null,{"$f":"'Closing S&U'!E123","v":0},0,0,0,0]
[41,".",{"$f":"'Closing S&U'!C124","v":"Engineering Fees"},null,{"$f":"'Closing S&U'!E124","v":0},0,0,0,0]
[42,null,{"$f":"'Closing S&U'!C125","v":"Historic Consultant Fees"},null,{"$f":"'Closing S&U'!E125","v":0},0,0,0,0]
[43,null,{"$f":"'Closing S&U'!C126","v":"Solar Consultant Fees"},null,{"$f":"'Closing S&U'!E126","v":0},0,0,0,0]
[44,null,{"$f":"'Closing S&U'!C127","v":0},null,{"$f":"'Closing S&U'!E127","v":0},0,0,0,0]
[45,".",{"$f":"'Closing S&U'!C128","v":0},null,{"$f":"'Closing S&U'!E128","v":0},0,0,0,0]
[null,null,"        Subtotal",null,{"$f":"SUM(E82:E88)","v":0},null,{"$f":"SUM(G82:G88)","v":0},{"$f":"SUM(H82:H88)","v":0},{"$f":"SUM(I82:I88)","v":0}]
[null,null,"INTERIM CONSTRUCTION EXPENSE"]
[{"$f":"A88+1","v":46},".",{"$f":"'Closing S&U'!C131","v":"Const. Loan Origination Fee"},null,{"$f":"'Closing S&U'!E131","v":0},0,0,0,0]
[{"$f":"A91+1","v":47},".",{"$f":"'Closing S&U'!C132","v":"Const. Interest"},null,{"$f":"'Closing S&U'!E132","v":0},0,0,0,0]
[48,".",{"$f":"'Closing S&U'!C133","v":"Const. Insurance"},null,{"$f":"'Closing S&U'!E133","v":0},0,0,0,0]
[49,".",{"$f":"'Closing S&U'!C134","v":"Const. Bond Fee"},null,{"$f":"'Closing S&U'!E134","v":0},0,0,0,0]
[50,".",{"$f":"'Closing S&U'!C135","v":"Lender's Counsel"},null,{"$f":"'Closing S&U'!E135","v":0},0,0,0,0]
[51,".",{"$f":"'Closing S&U'!C136","v":"Taxes During Construction"},null,{"$f":"'Closing S&U'!E136","v":0},0,0,0,0]
[52,".",{"$f":"'Closing S&U'!C137","v":"Permits"},null,{"$f":"'Closing S&U'!E137","v":0},0,0,0,0]
[53,".",{"$f":"'Closing S&U'!C138","v":0},null,{"$f":"'Closing S&U'!E138","v":0},0,0,0,0]
[54,".",{"$f":"'Closing S&U'!C139","v":0},null,{"$f":"'Closing S&U'!E139","v":0},0,0,0,0]
[null,null,"        Subtotal",null,{"$f":"SUM(E91:E99)","v":0},null,{"$f":"SUM(G91:G99)","v":0},{"$f":"SUM(H91:H99)","v":0},{"$f":"SUM(I91:I99)","v":0}]
[null,null,"FINANCING FEES AND EXPENSE"]
[{"$f":"A99+1","v":55},".",{"$f":"'Closing S&U'!C142","v":"Perm. Loan Origination Fee"},null,{"$f":"'Closing S&U'!E142","v":0},0,0,0,0]
[{"$f":"A102+1","v":56},".",{"$f":"'Closing S&U'!C143","v":"Perm. Loan Credit Enhance"},null,{"$f":"'Closing S&U'!E143","v":0},0,0,0,0]
[57,".",{"$f":"'Closing S&U'!C144","v":"Tax Credit Fee"},null,{"$f":"'Closing S&U'!E144","v":0},0,0,0,0]
[58,".",{"$f":"'Closing S&U'!C145","v":"Title Insurance and Record"},null,{"$f":"'Closing S&U'!E145","v":0},0,0,0,0]
[59,null,{"$f":"'Closing S&U'!C146","v":"Transfer Tax"},null,{"$f":"'Closing S&U'!E146","v":0},0,0,0,0]
[60,null,{"$f":"'Closing S&U'!C147","v":"Lender's Counsel"},null,{"$f":"'Closing S&U'!E147","v":0},0,0,0,0]
[61,null,{"$f":"'Closing S&U'!C148","v":"Bond Premium"},null,{"$f":"'Closing S&U'!E148","v":0},0,0,0,0]
[62,null,{"$f":"'Closing S&U'!C149","v":"Financing Application Fee"},null,{"$f":"'Closing S&U'!E149","v":0},0,0,0,0]
[63,".",{"$f":"'Closing S&U'!C150","v":"Upfront MIP Fee"},null,{"$f":"'Closing S&U'!E150","v":0},0,0,0,0]
[64,".",{"$f":"'Closing S&U'!C151","v":"FFB Trustee Fee"},null,{"$f":"'Closing S&U'!E151","v":0},0,0,0,0]
[65,".",{"$f":"'Closing S&U'!C152","v":"Soft Cost Contingency"},null,{"$f":"'Closing S&U'!E152","v":0},0,0,0,0]
[66,".",{"$f":"'Closing S&U'!C153","v":0},null,{"$f":"'Closing S&U'!E153","v":0},0,0,0,0]
[null,null,"        Subtotal",null,{"$f":"SUM(E102:E113)","v":0},null,{"$f":"SUM(G102:G113)","v":0},{"$f":"SUM(H102:H113)","v":0},{"$f":"SUM(I102:I113)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,"$"]
[null,null,null,null,null,"Percentage of"]
[null,null,null,null,"$"," Costs Not ","            $                          $                         $"]
[null,null,null,null,"Total","in Depreciable","Acquisition","Rehabilitation","Not In"]
[null,null,null,null,"Residential","Basis","Credit Basis","Credit Basis","Basis"]
[null,null,"OTHER SOFT COSTS",null," "]
[{"$f":"A113+1","v":67},".",{"$f":"'Closing S&U'!C156","v":"Appraisal"},null,{"$f":"'Closing S&U'!E156","v":0},0,0,0,0]
[{"$f":"A125+1","v":68},".",{"$f":"'Closing S&U'!C157","v":"Market Study"},null,{"$f":"'Closing S&U'!E157","v":0},0,0,0,0]
[69,".",{"$f":"'Closing S&U'!C158","v":"Environmental Report"},null,{"$f":"'Closing S&U'!E158","v":0},0,0,0,0]
[70,".",{"$f":"'Closing S&U'!C159","v":"Site Survey"},null,{"$f":"'Closing S&U'!E159","v":0},0,0,0,0]
[71,".",{"$f":"'Closing S&U'!C160","v":"Relocation Costs"},null,{"$f":"'Closing S&U'!E160","v":0},0,0,0,0]
[72,".",{"$f":"'Closing S&U'!C161","v":"Legal Fees"},null,{"$f":"'Closing S&U'!E161","v":0},0,0,0,0]
[73,".",{"$f":"'Closing S&U'!C162","v":"Accounting Fees"},null,{"$f":"'Closing S&U'!E162","v":0},0,0,0,0]
[74,".",{"$f":"'Closing S&U'!C163","v":"NHHFA Const. Admin. Svcs. Fee"},null,{"$f":"'Closing S&U'!E163","v":0},0,0,0,0]
[75,".",{"$f":"'Closing S&U'!C164","v":0},null,{"$f":"'Closing S&U'!E164","v":0},0,0,0,0]
[null,null,"        Subtotal",null,{"$f":"SUM(E125:E133)","v":0},null,{"$f":"SUM(G125:G133)","v":0},{"$f":"SUM(H125:H133)","v":0},{"$f":"SUM(I125:I133)","v":0}]
[null,null,"DEVELOPER FEE"]
[{"$f":"A133+1","v":76},".",{"$f":"'Closing S&U'!C172","v":"Devel. Overhead and Profit"},null,{"$f":"'Closing S&U'!E172","v":0},0,0,0,0]
[{"$f":"A136+1","v":77},".",{"$f":"'Closing S&U'!C173","v":"Development Consultant Fee"},null,{"$f":"'Closing S&U'!E173","v":0},0,0,0,0]
[null,null,"        Subtotal",null,{"$f":"SUM(E136:E137)","v":0},null,{"$f":"SUM(G136:G137)","v":0},{"$f":"SUM(H136:H137)","v":0},{"$f":"SUM(I136:I137)","v":0}]
[null,null,"SYNDICATION EXPENSES",null," "]
[{"$f":"A137+1","v":78},".",{"$f":"'Closing S&U'!C176","v":"Syndication Legal"},null,{"$f":"'Closing S&U'!E176","v":0},0,0,0,0]
[{"$f":"A140+1","v":79},".",{"$f":"'Closing S&U'!C177","v":"Syndication Accounting"},null,{"$f":"'Closing S&U'!E177","v":0},0,0,0,0]
[80,".",{"$f":"'Closing S&U'!C178","v":"Syndication Fees"},null,{"$f":"'Closing S&U'!E178","v":0},0,0,0,0]
[81,".",{"$f":"'Closing S&U'!C179","v":"Syndication Consultant"},null,{"$f":"'Closing S&U'!E179","v":0},0,0,0,0]
[82,".",{"$f":"'Closing S&U'!C180","v":"Bridge Loan Origination Fee"},null,{"$f":"'Closing S&U'!E180","v":0},0,0,0,0]
[83,".",{"$f":"'Closing S&U'!C181","v":"Bridge Loan Interest"},null,{"$f":"'Closing S&U'!E181","v":0},0,0,0,0]
[84,".",{"$f":"'Closing S&U'!C182","v":"Investor Servicing (capital)"},null,{"$f":"'Closing S&U'!E182","v":0},0,0,0,0]
[85,".",{"$f":"'Closing S&U'!C183","v":0},null,{"$f":"'Closing S&U'!E183","v":0},0,0,0,0]
[null,null,"        Subtotal",null,{"$f":"SUM(E140:E147)","v":0},null,{"$f":"SUM(G140:G147)","v":0},{"$f":"SUM(H140:H147)","v":0},{"$f":"SUM(I140:I147)","v":0}]
[null,null,"RESERVES- (reserves cannot exceed maximum under NHHFA underwriting standards)"]
[{"$f":"A147+1","v":86},".",{"$f":"'Closing S&U'!C186","v":"Operating Reserve"},null,{"$f":"'Closing S&U'!E186","v":0},0,0,0,0]
[{"$f":"A150+1","v":87},".",{"$f":"'Closing S&U'!C187","v":"FFB Operating Reserve"},null,{"$f":"'Closing S&U'!E187","v":0},0,0,0,0]
[88,".",{"$f":"'Closing S&U'!C188","v":"Replacement Reserve"},null,{"$f":"'Closing S&U'!E188","v":0},0,0,0,0]
[{"$f":"A150+1","v":87},".",{"$f":"'Closing S&U'!C189","v":"Insurance Escrow"},null,{"$f":"'Closing S&U'!E189","v":0},0,0,0,0]
[88,".",{"$f":"'Closing S&U'!C190","v":"Real Estate Tax Escrow"},null,{"$f":"'Closing S&U'!E190","v":0},0,0,0,0]
[89,null,{"$f":"'Closing S&U'!C191","v":"Tax Credit Monitor Fee"},null,{"$f":"'Closing S&U'!E191","v":0}]
[{"$f":"A153+1","v":88},".",{"$f":"'Closing S&U'!C192","v":0},null,{"$f":"'Closing S&U'!E192","v":0},0,0,0,0]
[null,null,"        Subtotal",null,{"$f":"SUM(E150:E156)","v":0},null,{"$f":"SUM(G150:G156)","v":0},{"$f":"SUM(H150:H156)","v":0},{"$f":"SUM(I150:I156)","v":0}]
[]
[{"$f":"A156+1","v":89},".","Total Development Cost",null,{"$f":"E$80+E$89+E$100+E$114+E$134+E$138+E$148+E$157","v":0},null,{"$f":"G$80+G$89+G$100+G$114+G$134+G$138+G$148+G$157","v":0},{"$f":"H$80+H$89+H$100+H$114+H$134+H$138+H$148+H$157","v":0},{"$f":"I$80+I$89+I$100+I$114+I$134+I$138+I$148+I$157","v":0}]
[{"$f":"A159+1","v":90},null,"TDC Net of Syndication Costs",null,{"$f":"'Closing S&U'!E197","v":0}]
[{"$f":"A160+1","v":91},".","Eligible Basis",null,null,null,{"$f":"G67","v":""}]
[null,null,null,null," ",null,null,{"$f":"IF(G161=\"\",\"\",\"Variance TDC/Basis:\")","v":""},{"$f":"IF(H162=\"\",\"\",E159-(G159+H159+I159))","v":""}]
[null,null,"Note: To determine the credit amount the project qualifies for, a gap analysis will be used.  The gap will be calculated using"]
[null,null,"Total Development Cost less syndication costs, and total equity from tax credits also net of syndication costs."]

{"sheet":"Mgt Agt Quest","index":7,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[[12,1,12,2],[5,0,5,5],[7,0,7,4],[8,0,8,2],[9,1,9,2],[11,3,11,5],[6,1,6,2],[32,3,32,5],[14,3,14,5],[15,1,15,2],[16,3,16,5],[17,1,17,2],[19,1,19,2],[19,3,19,5],[22,1,22,2],[29,1,29,2],[30,3,30,5],[31,1,31,2],[33,2,33,4],[35,0,35,2],[36,1,36,2],[36,5,37,5],[38,1,38,2],[38,5,39,5],[42,0,43,0],[42,1,43,2],[42,3,43,3],[42,4,43,4],[42,5,43,5],[40,0,41,0],[40,1,41,2],[40,3,41,3],[40,4,41,4],[40,5,41,5],[44,1,44,2],[45,1,45,2],[46,0,47,0],[46,1,47,2],[46,3,47,3],[51,5,52,5],[46,5,47,5],[48,0,49,0],[48,1,49,2],[48,3,49,3],[48,4,49,4],[48,5,49,5],[46,4,47,4],[50,1,50,2],[51,0,52,0],[51,1,52,2],[51,3,52,3],[51,4,52,4],[53,5,54,5],[55,0,56,0],[55,1,56,2],[55,3,56,3],[55,4,56,4],[55,5,56,5],[59,1,59,2],[53,0,54,0],[53,1,54,2],[53,3,54,3],[53,4,54,4]]}
[null,null,"MANAGEMENT AGENT QUESTIONNAIRE"]
[]
["Please use an \"x\" to fill in check boxes - form will automatically tally score."]
["Note: This form used for LIHTC Application Scoring and for Threshold Determination"]
["Additional explanation/notes can be added below"]
["Management Company Profiled: "]
[]
[null,null,null,null,null," Scoring"]
["Questions 1 – 7 are used in LIHTC scoring.",null,null,"Yes","No"]
[1,"Does the Agent have experience managing and/or own properties receiving subsidies or rental assistance other than Low Income Housing Tax Credit (LIHTC)?",null,null,"⁭",{"$f":"IF(D10=\"x\",1,0)","v":0}]
[null,"    ","If yes, more than five years of experience?",null,"⁭",{"$f":"IF(D11=\"x\",1,0)","v":0}]
[null,"     ","If yes, identify the Contract Administrator and/or Compliance Agency and the number of properties, number of units, location and years of experience."]
[2,"Does the Agent have experience managing LIHTC properties?",null,"⁭","⁭",{"$f":"IF(D13=\"x\",1,0)","v":0}]
[null,"    ","If yes, more than five years experience?",null,"⁭",{"$f":"IF(D14=\"x\",1,0)","v":0}]
[null,null,"If yes, identify the compliance agency and the number of properties, number of units, location and years of experience."]
[3,"In the past 3 years has the Agent undergone a LIHTC Compliance Monitoring Review?",null,null,null,{"$f":"IF(D16=\"x\",1,0)","v":0}]
[null,null,"If yes, identify the compliance agency."]
[4,"In the past 6 years, has the Agent received an unsatisfactory Monitoring Review of any property by a Compliance Agency or Contract Administrator? (Please skip to question 5 if not applicable.)",null,null,null,{"$f":"IF(D18=\"x\",-1,1)","v":1}]
[null,null,"If yes, explain circumstances and resolutions."]
[5,"In the past 3 years has the Agent managed/owned a property that has experienced any of the following? (Please skip to question 6 if not applicable.)"]
[null,null,"Persistent (2 consecutive years) and/or numerous (a finding with more than 50% of areas inspected) poor physical condition issues within the control of management.",null,null,{"$f":"IF(D21=\"x\",-1,1)","v":1}]
[null,null,"Persistent (2 consecutive years) late/incomplete submission of required documents (audits, budgets, certifications or other administrative or regulatory documents) to the contract administrator or compliance agency.","⁭","⁭",{"$f":"IF(D22=\"x\",-1,1)","v":1}]
[null,"Check all that apply:"]
[null,"⁭","Mortgage delinquent over 30 days"]
[null,"⁭","Low Debt to Coverage Ratio (DCR below 1.00)"]
[null,"⁭","Rental delinquency, greater than 7% of gross rent"]
[null,"⁭","High vacancy, greater than 8% for more than 60 days"]
[null,"⁭","Negative operating budget"]
[null,"⁭","In litigation"]
[6,"Does at least one person of the Agent’s staff possess a designation of training and proficiency from one of the Authority’s nationally recognized Tax Credit trainers?  See LIHTC Compliance on website for trainers www.nhhfa.org.",null,"⁭","⁭",{"$f":"IF(D30=\"x\",1,0)","v":0}]
[null,null,"If yes, list the specific designation by staff and date or attach documentation."]
[7,"Does at least one person of the Agent’s staff attend annual LIHTC training?",null,"⁭","⁭",{"$f":"IF(D32=\"x\",1,0)","v":0}]
[null,null,"If yes, list the specific training attended by staff and date or attach certificate of training."]
[null,null,"Total Self Scoring",null,null,{"$f":"SUM(D9:F32)","v":3}]
[null,"Page 2 Non-Scoring Section"]
[null,null,null,"Yes","No"]
[8,"In the past 6 years have any non-compliance 8823’s been issued to properties managed/owned by Agent?",null,"⁭","⁭","If yes, please explain:"]
[null," ","If yes, are there any 8823’s not corrected?","⁭","⁭"]
[9,"In the past 6 years of the properties managed/owned, have any issues of non-compliance of the special conditions of the LURA been discovered?",null,"⁭","⁭","Explain:"]
[null," ","If yes, are there any issues not corrected?","⁭","⁭"]
[10,"In the past 6 years, has the Agent been found in violation of any state or local codes?",null,null,null,"If yes, please explain:"]
[]
[11,"In the past 6 years, has the Agent been found in violation of any Fair Housing Law?",null,"⁭","⁭","If yes, please explain:"]
[]
[12,"Is the Management Agent aware of the specific requirements, restrictions and compliance of this property and/or program?",null,"⁭","⁭"]
[13,"Can the Agent demonstrate their ability to provide management and maintenance services required for this type of property?  (consider funding restrictions and compliance, documents and forms, distance from management, tenant demographics, neighborhood).",null,"⁭","⁭"]
[14,"Does the Agent intend to contract out any portion of the management functions?",null,"⁭","⁭","If yes, please explain:"]
[]
[15,"Are the Agent and all staff (including maintenance) who participate directly in the management of the property aware of the Fair Housing and Equal Opportunity (FHEO), Americans with Disabilities (ADA) and Section 504?",null,"⁭","⁭","If yes, list the specific training attended by staff and date or attach certificates of training:"]
[]
[16,"Is the Management Agent eligible for or have a surety bond?",null,"⁭","⁭"]
[17,"Is there an identity of interest between the ownership and management entities?",null,"⁭","⁭","If yes, please explain:"]
[]
[18,"Have any properties that the Agent (or any of its executive professional or supervisory personnel) managed or currently manage ever experienced a default?",null,"⁭","⁭","If yes, please explain:"]
[]
[19,"In the past 10 years has the Agent or any Principal or Officer of the Agent filed bankruptcy or had judgments levied against a firm that they were a Principal of?",null,null,null,"If yes, please explain:"]
[]
["Note that further information may be requested."]
[]
["I, "]
["hereby certify that the information set forth herein, and in any attachments in support thereof, is true, correct and complete to the best of my knowledge and belief."]
[]
["Name of Firm:"]
["Title:"]
["Date:"]
[]
["Additional Notes:"]

{"sheet":"Const S&U","index":8,"n_rows":100,"n_cols":40,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["Disbursement Schedule",null,null,"Project:",{"$f":"+'Project Info'!E4","v":0}]
[null,null,"Budget","Expended Prior to Closing","Paid at Closing","Total expended  thru closing ","Month 1 Draw","Month 2 Draw","Month 3 Draw","Month 4 Draw","Month 5 Draw","Month 6 Draw","Month 7 Draw","Month 8 Draw","Month 9 Draw","Month 10 Draw","Month 11 Draw","Month 12 Draw","Month 13 Draw","Month 14 Draw","Month 15 Draw","Month 16 Draw","Month 17 Draw","Month 18 Draw","Month 19 Draw","Month 20 Draw","Month 21 Draw","Month 22 Draw","Month 23 Draw","Month 24 Draw","Month 25 Draw","Month 26 Draw","Month 27 Draw","Month 28 Draw","Month 29 Draw","Month 30 Draw",null,"Total to Date",null,"Balance to  Complete"]
["Sources of Funds:"]
[{"$f":"'Closing S&U'!C6","v":"Developer's Cash Equity"},null,{"$f":"'Closing S&U'!G6","v":0},null,null,{"$f":"D4+E4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F4:AJ4)","v":0},null,{"$f":"C4-AL4","v":0}]
["LIHTC Equity",null,{"$f":"'LIHTC Info'!H44","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F5:AJ5)","v":0},null,0]
[{"$f":"'Closing S&U'!C8","v":"HTC Equity"},null,{"$f":"'Closing S&U'!G8","v":0},null,null,0]
[{"$f":"'Closing S&U'!C9","v":"Other Equity:"},{"$f":"'Closing S&U'!D9","v":0},{"$f":"'Closing S&U'!G9","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C10","v":"Developer Fee Loan"},null,{"$f":"'Closing S&U'!G10","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C11","v":"Other Source:"},{"$f":"'Closing S&U'!D11","v":0},{"$f":"'Closing S&U'!G11","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C15","v":"Grant:"},{"$f":"'Closing S&U'!D15","v":0},{"$f":"'Closing S&U'!F15","v":0},null,null,{"$f":"D10+E10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C16","v":"Grant:"},{"$f":"'Closing S&U'!D16","v":0},{"$f":"'Closing S&U'!F16","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C20","v":"NH Housing Capital Subsidy Funds"},null,{"$f":"'Closing S&U'!F20","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C22","v":"Subordinate Debt"},{"$f":"'Closing S&U'!D23","v":0},{"$f":"'Closing S&U'!F22","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C24","v":"Subordinate Debt"},{"$f":"'Closing S&U'!D25","v":0},{"$f":"'Closing S&U'!F24","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C26","v":"Subordinate Debt"},{"$f":"'Closing S&U'!D27","v":0},{"$f":"'Closing S&U'!F26","v":0},null,null,{"$f":"D15+E15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C28","v":"Subordinate Debt"},{"$f":"'Closing S&U'!D29","v":0},{"$f":"'Closing S&U'!F28","v":0},null,null,{"$f":"D16+E16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C33","v":"NH Housing Long-Term Loan"},null,{"$f":"'Closing S&U'!F33","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Closing S&U'!C35","v":"Other Long-Term Mortgage"},{"$f":"'Closing S&U'!D36","v":0},{"$f":"'Closing S&U'!F35","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'Closing S&U'!C37","v":"Other Long-Term Mortgage"},{"$f":"'Closing S&U'!D38","v":0},{"$f":"'Closing S&U'!F37","v":" "}]
[{"$f":"'Closing S&U'!C44","v":"Construction Loan"},{"$f":"'Closing S&U'!D45","v":0},{"$f":"'Closing S&U'!F44","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C47","v":"Other Interim Loan"},{"$f":"'Closing S&U'!D48","v":0},{"$f":"'Closing S&U'!F47","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C50","v":"Tax Credit Bridge Loan"},{"$f":"'Closing S&U'!D51","v":0},{"$f":"'Closing S&U'!F50","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Total Sources of Funds",null,{"$f":"SUM(C4:C22)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R4:R22)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AL4:AL22)","v":0},null,{"$f":"SUM(AN4:AN22)","v":0}]
[]
["Uses of Funds:"]
["Acquisition & Construction"]
["Land",null,{"$f":"'Closing S&U'!G115","v":0},null,null,{"$f":"D27+E27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F27:AJ27)","v":0},null,{"$f":"+C27-AL27","v":0}]
["Existing Building",null,{"$f":"'Closing S&U'!G116","v":0},null,null,{"$f":"D28+E28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F28:AJ28)","v":0},null,{"$f":"+C28-AL28","v":0}]
["Construction Budget",null,{"$f":"'Closing S&U'!G117","v":0},null,null,{"$f":"D29+E29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"+C29-AL29","v":0}]
["Construction Contingency",null,{"$f":"'Closing S&U'!G118","v":0},null,null,{"$f":"D30+E30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"+C30-AL30","v":0}]
["Other Acquisition & Construction",null,{"$f":"'Closing S&U'!G119","v":0},null,null,{"$f":"D31+E31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"+C31-AL31","v":0}]
["Architectural & Engineering"]
["Architect Fee-Design",null,{"$f":"'Closing S&U'!G122","v":0},null,null,{"$f":"+D33+E33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F33:AJ33)","v":0},null,{"$f":"+C33-AL33","v":0}]
["Architect Fee-Inspection",null,{"$f":"'Closing S&U'!G123","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F34:AJ34)","v":0},null,0]
["Engineering Fees",null,{"$f":"'Closing S&U'!G124","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C125","v":"Historic Consultant Fees"},null,{"$f":"'Closing S&U'!G125","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C126","v":"Solar Consultant Fees"},null,{"$f":"'Closing S&U'!G126","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C127","v":0},null,{"$f":"'Closing S&U'!G127","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C128","v":0},null,{"$f":"'Closing S&U'!G128","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Interim Construction Expense"]
[{"$f":"'Closing S&U'!C131","v":"Const. Loan Origination Fee"},null,{"$f":"'Closing S&U'!G131","v":0},null,null,{"$f":"+D41+E41","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F41:AJ41)","v":0},null,{"$f":"+C41-AL41","v":0}]
[{"$f":"'Closing S&U'!C132","v":"Const. Interest"},null,{"$f":"'Closing S&U'!G132","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F42:AJ42)","v":0},null,0]
[{"$f":"'Closing S&U'!C133","v":"Const. Insurance"},null,{"$f":"'Closing S&U'!G133","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C134","v":"Const. Bond Fee"},null,{"$f":"'Closing S&U'!G134","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C135","v":"Lender's Counsel"},null,{"$f":"'Closing S&U'!G135","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C136","v":"Taxes During Construction"},null,{"$f":"'Closing S&U'!G136","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C137","v":"Permits"},null,{"$f":"'Closing S&U'!G137","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C138","v":0},null,{"$f":"'Closing S&U'!G138","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C139","v":0},null,{"$f":"'Closing S&U'!G139","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Financing Fees and Expenses"]
[{"$f":"'Closing S&U'!C142","v":"Perm. Loan Origination Fee"},null,{"$f":"'Closing S&U'!G142","v":0},null,null,{"$f":"+D51+E51","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F51:AJ51)","v":0},null,{"$f":"+C51-AL51","v":0}]
[{"$f":"'Closing S&U'!C143","v":"Perm. Loan Credit Enhance"},null,{"$f":"'Closing S&U'!G143","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F52:AJ52)","v":0},null,0]
[{"$f":"'Closing S&U'!C144","v":"Tax Credit Fee"},null,{"$f":"'Closing S&U'!G144","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C145","v":"Title Insurance and Record"},null,{"$f":"'Closing S&U'!G145","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C146","v":"Transfer Tax"},null,{"$f":"'Closing S&U'!G146","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C147","v":"Lender's Counsel"},null,{"$f":"'Closing S&U'!G147","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C148","v":"Bond Premium"},null,{"$f":"'Closing S&U'!G148","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C149","v":"Financing Application Fee"},null,{"$f":"'Closing S&U'!G149","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C150","v":"Upfront MIP Fee"},null,{"$f":"'Closing S&U'!G150","v":0},null,null,{"$f":"+D59+E59","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"+C59-AL59","v":0}]
[{"$f":"'Closing S&U'!C151","v":"FFB Trustee Fee"},null,{"$f":"'Closing S&U'!G151","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C152","v":"Soft Cost Contingency"},null,{"$f":"'Closing S&U'!G152","v":0},null,null,{"$f":"+D61+E61","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"+C61-AL61","v":0}]
[{"$f":"'Closing S&U'!C153","v":0},null,{"$f":"'Closing S&U'!G153","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Other Soft Costs"]
["Appraisal",null,{"$f":"'Closing S&U'!G156","v":0},null,null,{"$f":"+D64+E64","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F64:AJ64)","v":0},null,{"$f":"+C64-AL64","v":0}]
["Market Study",null,{"$f":"'Closing S&U'!G157","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F65:AJ65)","v":0},null,0]
["Environmental Report",null,{"$f":"'Closing S&U'!G158","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Site Survey",null,{"$f":"'Closing S&U'!G159","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Relocation Expenses",null,{"$f":"'Closing S&U'!G160","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Legal Fees",null,{"$f":"'Closing S&U'!G161","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Accounting Fees",null,{"$f":"'Closing S&U'!G162","v":0},null,null,{"$f":"+D70+E70","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["NHHFA Const. Admin Svcs. Fee",null,{"$f":"'Closing S&U'!G163","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C164","v":0},null,{"$f":"'Closing S&U'!G164","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Development Fees"]
["Devel Overhead and Profit",null,{"$f":"'Closing S&U'!G172","v":0},null,null,{"$f":"+D74+E74","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F74:AK74)","v":0},null,{"$f":"+C74-AL74","v":0}]
["Consultant Fee",null,{"$f":"'Closing S&U'!G173","v":0},null,null,{"$f":"+D75+E75","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F75:AJ75)","v":0},null,{"$f":"+C75-AL75","v":0}]
[]
["Syndication Expenses"]
["Syndication Legal",null,{"$f":"'Closing S&U'!G176","v":0},null,null,{"$f":"+D78+E78","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F78:AJ78)","v":0},null,{"$f":"+C78-AL78","v":0}]
["Syndication Accounting",null,{"$f":"'Closing S&U'!G177","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F79:AJ79)","v":0},null,0]
["Syndication Fees",null,{"$f":"'Closing S&U'!G178","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Syndication Consultant",null,{"$f":"'Closing S&U'!G179","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Bridge Loan Origination Fee",null,{"$f":"'Closing S&U'!G180","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Bridge Loan Interest",null,{"$f":"'Closing S&U'!G181","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Investor Servicing (capital)",null,{"$f":"'Closing S&U'!G182","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C183","v":0},null,{"$f":"'Closing S&U'!G183","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Reserves (See NHHFA Policies)"]
[{"$f":"'Closing S&U'!C186","v":"Operating Reserve"},null,{"$f":"'Closing S&U'!G186","v":0},null,null,{"$f":"D87+E87","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F87:AJ87)","v":0},null,{"$f":"+C87-AL87","v":0}]
[{"$f":"'Closing S&U'!C187","v":"FFB Operating Reserve"},null,{"$f":"'Closing S&U'!G187","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F88:AJ88)","v":0},null,0]
[{"$f":"'Closing S&U'!C188","v":"Replacement Reserve"},null,{"$f":"'Closing S&U'!G188","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C189","v":"Insurance Escrow"},null,{"$f":"'Closing S&U'!G189","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C190","v":"Real Estate Tax Escrow"},null,{"$f":"'Closing S&U'!G190","v":0},null,null,{"$f":"D91+E91","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"+C91-AL91","v":0}]
[{"$f":"'Closing S&U'!C191","v":"Tax Credit Monitor Fee"},null,{"$f":"'Closing S&U'!G191","v":0},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C192","v":0},null,{"$f":"'Closing S&U'!G192","v":0},null,null,{"$f":"D93+E93","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Other"]
["TA Loan Payoff",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F95:AJ95)","v":0},null,{"$f":"+C95-AL95","v":0}]
["Construction Loan Payoff",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F96:AJ96)","v":0},null,{"$f":"+C96-AL96","v":0}]
["  Total Uses of Funds",null,{"$f":"SUM(C27:C96)","v":0},{"$f":"SUM(D27:D96)","v":0},{"$f":"SUM(E27:E96)","v":0},{"$f":"SUM(F27:F96)","v":0},{"$f":"SUM(G27:G96)","v":0},{"$f":"SUM(H27:H96)","v":0},{"$f":"SUM(I27:I96)","v":0},{"$f":"SUM(J27:J96)","v":0},{"$f":"SUM(K27:K96)","v":0},{"$f":"SUM(L27:L96)","v":0},{"$f":"SUM(M27:M96)","v":0},{"$f":"SUM(N27:N96)","v":0},{"$f":"SUM(O27:O96)","v":0},{"$f":"SUM(P27:P96)","v":0},{"$f":"SUM(Q27:Q96)","v":0},{"$f":"SUM(R27:R96)","v":0},{"$f":"SUM(S27:S96)","v":0},{"$f":"SUM(T27:T96)","v":0},{"$f":"SUM(U27:U96)","v":0},{"$f":"SUM(V27:V96)","v":0},{"$f":"SUM(W27:W96)","v":0},{"$f":"SUM(X27:X96)","v":0},{"$f":"SUM(Y27:Y96)","v":0},{"$f":"SUM(Z27:Z96)","v":0},{"$f":"SUM(AA27:AA96)","v":0},{"$f":"SUM(AB27:AB96)","v":0},{"$f":"SUM(AC27:AC96)","v":0},{"$f":"SUM(AD27:AD96)","v":0},{"$f":"SUM(AE27:AE96)","v":0},{"$f":"SUM(AF27:AF96)","v":0},{"$f":"SUM(AG27:AG96)","v":0},{"$f":"SUM(AH27:AH96)","v":0},{"$f":"SUM(AI27:AI96)","v":0},{"$f":"SUM(AJ27:AJ96)","v":0},null,{"$f":"SUM(AL27:AL96)","v":0},null,{"$f":"SUM(AN27:AN96)","v":0}]
[]
["Total Checks:"]
["Source and Use Check",null,{"$f":"C23-C97","v":0},{"$f":"D23-D97","v":0},{"$f":"E23-E97","v":0},{"$f":"F23-F97","v":0},{"$f":"G23-G97","v":0},{"$f":"H23-H97","v":0},{"$f":"I23-I97","v":0},{"$f":"J23-J97","v":0},{"$f":"K23-K97","v":0},{"$f":"L23-L97","v":0},{"$f":"M23-M97","v":0},{"$f":"N23-N97","v":0},{"$f":"O23-O97","v":0},{"$f":"P23-P97","v":0},{"$f":"Q23-Q97","v":0},{"$f":"R23-R97","v":0},{"$f":"S23-S97","v":0},{"$f":"T23-T97","v":0},{"$f":"U23-U97","v":0},{"$f":"V23-V97","v":0},{"$f":"W23-W97","v":0},{"$f":"X23-X97","v":0},{"$f":"Y23-Y97","v":0},{"$f":"Z23-Z97","v":0},{"$f":"AA23-AA97","v":0},{"$f":"AB23-AB97","v":0},{"$f":"AC23-AC97","v":0},{"$f":"AD23-AD97","v":0},{"$f":"AE23-AE97","v":0},{"$f":"AF23-AF97","v":0},{"$f":"AG23-AG97","v":0},{"$f":"AH23-AH97","v":0},{"$f":"AI23-AI97","v":0},{"$f":"AJ23-AJ97","v":0},{"$f":"AK23-AK97","v":0},{"$f":"AL23-AL97","v":0},{"$f":"AM23-AM97","v":0},{"$f":"AN23-AN97","v":0}]

{"sheet":"Dev Fee","index":9,"n_rows":45,"n_cols":23,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,0,3],[41,0,41,1]]}
["Developer Fee Schedule"]
[]
["Project Name",{"$f":"'Project Info'!E4","v":0}]
[]
[null,"Developer Fees"]
[]
["The developer fee is not a guaranteed or automatic budgetary figure, and must be approved by the Authority"]
["within the context of each project.  The fee will be strictly limited, with any violations of the developer"]
["certification of development cost forwarded to the IRS using IRS form 8823.  For purposes of calculating the"]
["maximum developer fee allowed, the Authority does not distinguish between the developer fee and fees for"]
["consultants doing those tasks typically done by a developer, regardless of whether the applicant is a for-"]
["profit or non-profit entity.  \"Consultant fees\" counted as developer fee do not include professional fees such"]
["as architectural, engineering, or appraisal fees."]
[]
["Maximum Developer Fee Calculation"]
[]
["1.  The maximum fee in any case shall not exceed 15% of total development costs:",null,{"$f":"'Closing S&U'!G174/'Closing S&U'!G195","v":{"$error":"#DIV/0!"}}]
[]
["2.    Projects primarily relating to acquisition, with renovation/new construction (including contingency) equaling"]
["less than 50% of total development costs, not including land.  Can be general occupancy or age-restricted."]
[]
[6300,"per unit",{"$f":"A22*'Project Info'!N69","v":0}]
[null,null,null,null,null,null,"Remove when published!"]
["3.      General occupancy projects (at least 25% 2BR units, and no age-restricted or >62 age designation)"]
[null,null,null,"# of units",null,null,"Old",0.12,null,null,null,null,null,null,null,null,null,"\"# units over 100","# units over 40","# units over 10","# units under 11",null,"check"]
[22000,"per unit for first 10 units",{"$f":"IF(U27>0,U27*A26,0)","v":0},{"$f":"'Project Info'!N69","v":0},null,null,21000,{"$f":"G26*1.12","v":23520.000000000004},null,null,null,null,null,null,null,null,null,{"$f":"IF($D$26>100,($D$26-100),0)","v":0},{"$f":"IF($D$26>40,($D$26-40),0)","v":0},{"$f":"IF($D$26>10,($D$26-10),0)","v":0},{"$f":"IF(D26>10,10,D26)","v":0},null,{"$f":"10*A26","v":220000}]
[18000,"per unit for next 30 units",{"$f":"IF(T27>0,T27*A27,0)","v":0},null,null,null,17000,{"$f":"G27*1.12","v":19040},null,null,null,null,null,null,null,null,null,{"$f":"IF(R26>100,100,D26-100)","v":-100},{"$f":"IF(S26>60,60,D26-40)","v":-40},{"$f":"IF(T26>30,30,D26-10)","v":-10},{"$f":"U26","v":0},null,{"$f":"30*A27","v":540000}]
[15000,"per unit for next 60 units",{"$f":"IF(S27>0,S27*A28,0)","v":0},"Total Fee",null,null,14000,{"$f":"G28*1.12","v":15680.000000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"10*A28","v":150000}]
[6500,"per unit for any unit above 100",{"$f":"IF(R26>0,R26*A29,0)","v":0},{"$f":"SUM(C26:C29)","v":0},null,null,6000,{"$f":"G29*1.12","v":6720.0000000000009},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0*A29","v":0}]
[null,null,null,"% of TDC"]
[null,null,null,{"$f":"D29/'Closing S&U'!G195","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W26:W30)","v":910000}]
[]
["4.      Age-restricted or other  projects  (with senior >62 age designation or otherwise not meeting #3 above)"]
[null,null,null,"# of units",null,null,null,0.12,null,null,null,null,null,null,null,null,null,"\"# units over 100","# units over 40","# units over 10","# units under 11"]
[20000,"per unit for first 10 units",{"$f":"IF(U36>0,U36*A35,0)","v":0},{"$f":"D26","v":0},null,null,19000,{"$f":"G35*1.12","v":21280.000000000004},null,null,null,null,null,null,null,null,null,{"$f":"IF($D$26>100,($D$26-100),0)","v":0},{"$f":"IF($D$26>40,($D$26-40),0)","v":0},{"$f":"IF($D$26>10,($D$26-10),0)","v":0},{"$f":"IF(D35>10,10,D35)","v":0},null,{"$f":"10*A35","v":200000}]
[16000,"per unit for next 30 units",{"$f":"IF(T36>0,T36*A36,0)","v":0},null,null,null,15000,{"$f":"G36*1.12","v":16800},null,null,null,null,null,null,null,null,null,{"$f":"IF(R35>100,100,D35-100)","v":-100},{"$f":"IF(S35>60,60,D35-40)","v":-40},{"$f":"IF(T35>30,30,D35-10)","v":-10},{"$f":"U35","v":0},null,{"$f":"30*A36","v":480000}]
[13500,"per unit for next 60 units",{"$f":"IF(S36>0,S36*A37,0)","v":0},"Total Fee",null,null,13000,{"$f":"G37*1.12","v":14560.000000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"10*A37","v":135000}]
[6500,"per unit for any unit above 100",{"$f":"IF(R36>0,R36*A38,0)","v":0},{"$f":"SUM(C35:C38)","v":0},null,null,6000,{"$f":"G38*1.12","v":6720.0000000000009},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0*A38","v":0}]
[null,null,null,"% of TDC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W35:W38)","v":815000}]
[null,null,null,{"$f":"D38/'Closing S&U'!G195","v":{"$error":"#DIV/0!"}}]
[]
["5.    Projects financed through the issuance of Tax Exempt Bonds are eligible for  a developer fee ",null,null,{"$f":"('Closing S&U'!G195-'Closing S&U'!G174)*0.15","v":0}]
["up to 15% of the total development cost (not including developer fee). "]
[null,{"$f":"IFERROR(IF((((G7+F20)/'Project Info'!N69)>230000),\"EQUITY & SUBSIDY EXCEEDS QAP MAXIMUM\",\"\"),\"\")","v":""}]
["Tax Exempt Bonds ONLY","REQUIRED DEFERRED DEVELOPER FEE",null,{"$f":"IF(ISBLANK('Project Info'!G29),D42-D38,D42-D29)","v":0}]

{"sheet":"Gap Analysis","index":10,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[{"$f":"'Project Info'!E4","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'!F20+'Closing S&U'!F22+'Closing S&U'!F24+'Closing S&U'!F26+'Closing S&U'!F28+'Closing S&U'!F33+'Closing S&U'!F35+'Closing S&U'!F37","v":0}]
["Developer fee loan",null,null,{"$f":"'Closing S&U'!G10","v":0}]
["Grants",null,null,{"$f":"'Closing S&U'!F15+'Closing S&U'!F16","v":0}]
["Other ",null,null,{"$f":"'Closing S&U'!G11","v":0}]
["     Total Non-Credit Sources of Funds",null,null,{"$f":"SUM(D9:D12)","v":0}]
[]
["Total Equity Needed",null,null,{"$f":"'LIHTC Info'!E159","v":0}]
[]
["Historic Tax Credits (20% of elig historic basis)",null,{"$f":"'LIHTC Info'!I33","v":"0"}]
["     Historic Tax Credit purchase rate:",null,{"$f":"'LIHTC Info'!F43","v":0}]
["   Calculated Equity from Historic Tax Credits",null,null,{"$f":"C18*C17","v":0}]
[]
["Equity Needed from LIHTC",null,null,{"$f":"D15-D19","v":0}]
[]
["30 Percent PV Credit Rate","Total Acquis Credit Allowable",null,{"$f":"'LIHTC Info'!G159","v":0}]
["   Assumed Credit Rate:",{"$f":"'LIHTC Info'!H14","v":0}]
[]
["QCT/DDA Credit Rate Allowed","Yes=1.3, No=0",null,{"$f":"IF('LIHTC Info'!H26=\"yes\",1.3,0)","v":1.3}]
["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,+('LIHTC Info'!H159*B30*D26),('LIHTC Info'!H159*B30))","v":0}]
["   Assumed Credit Rate:",{"$f":"'LIHTC Info'!H15","v":0.09}]
[]
["Total Low Income Tax Credit  - \"Basis Eligible\"",null,null,{"$f":"D29+D23","v":0}]
[]
["Low Income Equity Purchase Rate",null,{"$f":"'LIHTC Info'!F42","v":0}]
["Annual Credit Allocation-Maximum Needed",null,null,{"$f":"IF(C34=0,\"\",(D21/C34)/10)","v":""}]
[]
["Recommened Credit Allocation:",null,{"$f":"IF(D32>D35,D35,D32)","v":0}]
["TOTAL EQUITY FROM LIHTC",null,null,{"$f":"(C37*10)*C34","v":0}]
["FINANCING GAP",null,null,{"$f":"'Closing S&U'!E190-D38-D19-D13","v":0}]

{"sheet":"Exh A","index":11,"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":"'LIHTC Info'!H159","v":0}]
["Credit Rate Assumptions:",null,"4% credit",null,{"$f":"'LIHTC Info'!H14","v":0},null,"Total 4% Basis",{"$f":"'LIHTC Info'!G159","v":0}]
[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'!I114","v":0}]
[]
["Carryover Allocation Agreement - Exhibit A",null,null,null,null,"Table Page 1 of  1"]
[]
["Project Name:",{"$f":"'Project Info'!E4:I4","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":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Eligible for DDA/QCT?",{"$f":"IF('LIHTC Info'!H26=\"\",\"\",'LIHTC Info'!H26)","v":""},{"$f":"B22","v":""},{"$f":"C22","v":""},{"$f":"D22","v":""},{"$f":"E22","v":""},{"$f":"F22","v":""}]
["Adjusted Eligible Basis",{"$f":"IF(B22=\"yes\",($A$24*B20),B20)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[1.3]
["Estimated Applicable"]
["Fraction**",{"$f":"'LIHTC Info'!$I$37","v":0},{"$f":"B26","v":0},{"$f":"B26","v":0},{"$f":"B26","v":0},{"$f":"B26","v":0},{"$f":"B26","v":0}]
[]
["Estimated Qualified Basis",{"$f":"B23*B26","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["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":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(B32:G32)","v":{"$error":"#DIV/0!"}}]
[]
["Maximum Credit Calculated",{"$f":"B30*B28","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(B34:G34)","v":{"$error":"#DIV/0!"}}]
["* 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":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Eligible for DDA/QCT?",{"$f":"B22","v":""},{"$f":"B66","v":""},{"$f":"C66","v":""},{"$f":"D66","v":""},{"$f":"E66","v":""},{"$f":"F66","v":""}]
["Adjusted Eligible Basis",{"$f":"IF(B66=\"yes\",($A$24*B64),B64)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[1.3]
["Estimated Applicable"]
["Fraction**",{"$f":"'LIHTC Info'!I37","v":0},{"$f":"B70","v":0},{"$f":"B70","v":0},{"$f":"B70","v":0},{"$f":"B70","v":0},{"$f":"B70","v":0}]
[]
["Estimated Qualified Basis",{"$f":"B67*B70","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["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":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(B76:G76)","v":{"$error":"#DIV/0!"}}]
[]
["Maximum Credit Calculated",{"$f":"B74*B72","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(B78:G78)","v":{"$error":"#DIV/0!"}}]
["* 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":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Eligible for DDA/QCT?",{"$f":"B66","v":""},{"$f":"B112","v":""},{"$f":"C112","v":""},{"$f":"D112","v":""},{"$f":"E112","v":""},{"$f":"F112","v":""}]
["Adjusted Eligible Basis",{"$f":"IF(B112=\"yes\",($A$24*B110),B110)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[1.3]
["Estimated Applicable"]
["Fraction**",{"$f":"'LIHTC Info'!$I$37","v":0},{"$f":"'LIHTC Info'!$I$37","v":0},{"$f":"'LIHTC Info'!$I$37","v":0},{"$f":"'LIHTC Info'!$I$37","v":0},{"$f":"'LIHTC Info'!$I$37","v":0},{"$f":"'LIHTC Info'!$I$37","v":0}]
[]
["Estimated Qualified Basis",{"$f":"B113*B116","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["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":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(B122:G122)","v":{"$error":"#DIV/0!"}}]
[]
["Maximum Credit Calculated",{"$f":"B120*B118","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(B124:G124)","v":{"$error":"#DIV/0!"}}]
["* 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":12,"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'!E4","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":13,"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":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

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