{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Instructions","Project Info","Closing S&U","Inc & Exp","LIHTC Info","Dev Team","Const S&U","Pro Forma","Dev Fee","Sheet1","Gap Analysis","Exh A","Risk Sharing","Change Log","Module1","Module2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":92,"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":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,2,5,5],[0,0,0,7],[1,0,1,7]]}
["New Hampshire Housing Financing Application 2025-2026 Qualified Allocation Plan"]
["Version 1, June 10, 2024"]
[]
[null,"This financing application has color coded tabs that must be completed based on the financing sought 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,"Dev Team","This tab captures the members of the project's development team."]
[]
[null,"Project Info","This tab is used to gather general information about the project, including unit details"]
[null,null,"and building features."]
[]
[null,"Closing S&U","This tab details the project financing sources and uses. "]
[]
[null,"Const S&U","This tab details sources and uses of funds during the construction period. "]
[]
[]
[null,"Inc & Exp","This tab captures rent and other income information, operating expenses, and debt service. "]
[]
[null,"Pro Forma","This tab automatically populated and is used to analyze  income/expense trending."]
[]
[null,"LIHTC Info","This tab is filled out when applying for 4% and/or 9% LIHTC's.  "]
[]
[null,"Dev Fee","This tab is used to calculate the maximum developer fee, based on occupancy type"]
[null,null,"and the type of project."]

{"sheet":"Project Info","index":1,"n_rows":289,"n_cols":15,"rows_kept":289,"cut":false,"hidden":false,"merged":[[192,3,194,8],[2,4,2,8],[3,4,3,8],[4,4,4,6],[47,2,54,8],[263,4,263,8],[265,4,265,8],[266,4,267,8],[196,3,198,8],[200,3,202,8],[205,3,206,8],[259,4,259,5],[226,2,227,8],[216,5,216,8]]}
["PROJECT INFORMATION"]
[]
[1,".","Project Name:"]
[{"$f":"A3+1","v":2},".","Project Address:"]
[{"$f":"A4+1","v":3},".","Project Community:",null,null,null,null,"                NH"]
[null,null,null,null,"                                    (city/town)",null,null,"(state)","(zip code)"]
[]
["Application Submission - Project Status"]
[4,null,"Please select the status of your project: "]
[null,null,"   Preapplication",null,null,null,null,"Mark with an \"X\""]
[null,null,"   Final Application",null,null,null,null,"Mark with an \"X\""]
[null,null,"   NH Housing Financing Commitment",null,null,null,null,"Mark with an \"X\""]
[null,null,"   Financial Closing ",null,null,null,null,"Mark with an \"X\""]
[null,null,"   9% LIHTC Carryover Allocation ",null,null,null,null,"Mark with an \"X\""]
[null,null,"   Final Allocation (8609)",null,null,null,null,"Mark with an \"X\""]
[]
["Development Plan"]
[]
[{"$f":"A9+1","v":5},".","Development Type (please check all that apply):"]
[null,{"$f":"IF(LEN(TRIM(G20))>0,1,0)","v":{"$error":"#VALUE!"}},"   New construction",null,null,null,null,"Mark with an \"X\""]
[null,{"$f":"IF(LEN(TRIM(G21))>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(G22))>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(G23))>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(G24))>0,1,0)","v":{"$error":"#VALUE!"}},"   Other",null,null,null,null,"Mark with an \"X\""]
[]
[{"$f":"A19+1","v":6},null,"Is this a \"twinned\" LIHTC project with a 4% and 9% "]
[null,null,"component being developed simultaneously? ",null,null,null,null,"Yes or No "]
[null,null,"   If yes, how many units are in the 4% project? "]
[null,null,"   If yes, how many units are in the 9% project? "]
[]
[null,null," ",null,null,null," "]
[{"$f":"A26+1","v":7},".","Proposed Housing Type (please check one box):",null,null,null," "]
[null,{"$f":"IF(LEN(TRIM(G33))>0,1,0)","v":{"$error":"#VALUE!"}},"   Rental (except SRO, 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!"},"   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":"A39+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":"A44+1","v":8},".","Development Schedule:",null,null,"Projected Dates"]
[null,null,null,null,null,"MM/YYYY"]
[null,null,"NH Housing Conditional Funding Award Date"]
[null,null,"NH Housing Financing Commitment Date"]
[null,{"$f":"IF(LEN(FIXED(G61,0,TRUE))<4,+G61+1900,+G61)","v":1900},"Construction Loan Closing"]
[null,1900,"Construction Start Date",null,null,null,null,{"$f":"IF(F62+G62=0,\"\",IF(F62>12,\"Use month number from 1 to 12\",IF(B62<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":"G64","v":0}]
[null,1900,"First Certificate of Occupancy",null,null,null,null,""]
[null,1900,"Final Certificate of Occupancy",null,null,null,null,""]
[null,null,"Construction Loan Payoff Date"]
[null,1900,"Permanent Loan Closing",null,null,null,null,""]
[null,1900,"Issuance of 8609",null,null,null,null,""]
[]
[]
[]
[{"$f":"A57+1","v":9},".","Unit Mix: "]
[]
[null,null,null,"Market Rate","LIHTC 20% AMI/HTF PBV","LIHTC 30% AMI/HTF PBV","LIHTC 60% AMI","LIHTC 70% AMI","LIHTC 80% AMI","Income Limit/Program ","Income Limit/Program ","Income Limit/Program ","Income Limit/Program ","Total"]
[null,null,"SRO",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D76:M76)","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(D79:M79)","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(D76:D81)","v":0},{"$f":"SUM(E76:E81)","v":0},{"$f":"SUM(F76:F81)","v":0},0,{"$f":"SUM(H76:H81)","v":0},0,0,{"$f":"SUM(K76:K81)","v":0},0,0,0]
[]
[null,null,"BR Count",{"$f":"(D76*1)+(D77*1)+(D78*1)+(D79*2)+(D80*3)+(D81*4)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(D84:M84)","v":0}]
[]
[{"$f":"A73+1","v":10},".","Unit Size (Indicate the average size of units, in square feet, by bedroom size and income):"]
[]
[null,null,null,{"$f":"D75","v":"Market Rate"},"LIHTC 20% AMI/HTF PBV","LIHTC 30% AMI/HTF PBV","LIHTC 60% AMI","LIHTC 70% AMI","LIHTC 80% AMI","Income Limit/Program ","Income Limit/Program ","Income Limit/Program ","Income Limit/Program "]
[null,null,"0 Bedrooms"]
[null,null,"1 Bedrooms"]
[null,null,"2 Bedrooms"]
[null,null,"3 Bedrooms"]
[null,null,"4+ Bedrooms"]
[]
[{"$f":"A86+1","v":11},".","Bathroom facilities (indicate the number of bathrooms in each of the units):"]
[]
[null,null,null,{"$f":"D88","v":"Market Rate"},{"$f":"E75","v":"LIHTC 20% AMI/HTF PBV"},"LIHTC 30% AMI/HTF PBV","LIHTC 60% AMI","LIHTC 70% AMI","LIHTC 80% AMI","Income Limit/Program ","Income Limit/Program ","Income Limit/Program ","Income Limit/Program "]
[null,null,"0 Bedrooms",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D98:M98)","v":0}]
[null,null,"1 Bedrooms",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D99:M99)","v":0}]
[null,null,"2 Bedrooms",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D100:M100)","v":0}]
[null,null,"3 Bedrooms",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D101:M101)","v":0}]
[null,null,"4+ Bedrooms",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D102:M102)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total BR",{"$f":"SUM(N98:N102)","v":0}]
[{"$f":"A95+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 Construction and Long-Term Financing"]
[]
[null,null,"9% LIHTC ",null,null,"Yes or No ",null,null,null,null,"NH Housing Tax-exempt Construction Loan",null,null,null,"Yes or No "]
[null,null,"4% LIHTC & Tax Exempt Bond",null,null,"Yes or No ",null,null,null,null,"NH Housing Tax-exempt Long-term Loan",null,null,null,"Yes or No "]
[null,null,"NH Housing Capital Subsidy",null,null,"Yes or No ",null,null,null,null,"NH Housing Construction Loan",null,null,null,"Yes or No "]
[null,null,"NH Housing Project Based Vouchers",null,null,"Yes or No ",null,null,null,null,"NH Housing Long-Term Loan",null,null,null,"Yes or No "]
[]
[13]
[]
[]
[null,null,null,null,"New"," ","Existing/"," "," "]
[{"$f":"A104+1","v":13},".","Number of buildings planned:",null,"Construction",null,"Rehabilitation",null,"Total"]
[null,null,"       a.  Single-family",null,null,null,null,null,{"$f":"E117+G117","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(E117:E122)","v":0},null,{"$f":"SUM(G117:G122)","v":0},null,0]
[]
[null,null,null,null,"Yes",null,"No"]
[14,".","Scattered Sites:"]
[]
[15,".","Number of units:",null,null,null,null,null,{"$f":"E128+G128","v":0}]
[]
[{"$f":"A128+1","v":16},".","Gross Square Footage"]
[null,null,"     a.  Residential",null,null,null,null,null,{"$f":"E131+G131","v":0}]
[null,null,"     b.  Commercial",null,null,null,null,null,{"$f":"E132+G132","v":0}]
[]
[{"$f":"A130+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(I131>0,F135/I131,\"                     \")","v":"                     "}]
[null,null,"     b.  Commercial",null,null,null," s.f.",{"$f":"IF(F136>0,IF(I132>0,F136/I132,\"                        \"),\"             \")","v":"             "}]
[]
[{"$f":"A134+1","v":18},null,"Number of units that will be fully accessible in "]
[null,null,"accordance with ICC/ANSI A117.1, Type A, Fully"]
[null,null,"Accessible guidelines. "]
[]
[{"$f":"A138+1","v":19},null,"Number of accessibe parking spaces for"]
[null,null,"Type A Fully Accessible units"]
[]
[{"$f":"A142+1","v":20},".","Fire Code Type (check):"]
[null,null,"       a.  Concrete frame",null,null," (Mark one box with an \"X\")",null,{"$f":"IF(E146<>\" \",1,0)","v":0}]
[null,null,"       b.  Wood frame",null,null," (Mark one box with an \"X\")",null,{"$f":"IF(E147<>\" \",1,0)","v":0}]
[null,null,"       c.  Protected steel",null,null," (Mark one box with an \"X\")",null,{"$f":"IF(E148<>\" \",1,0)","v":0}]
[null,null,"       d.  Masonry bearing wall",null,null," (Mark one box with an \"X\")",null,{"$f":"IF(E149<>\" \",1,0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(F151=\"yes\",F151=\"y\"),\"How Many?\",\"\")","v":"How Many?"}]
[{"$f":"A145+1","v":21},".","Will buildings include elevators?",null,null,null," (\"yes\" or \"no\")","If yes, number:"]
[]
[{"$f":"A151+1","v":22},".","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":"A153+1","v":23},".","Are the following included in the rent:"]
[null,null,"       a.  Heat?",null,null," (\"yes\" or \"no\")"]
[null,null,"       b.  Domestic Electricity?",null,null," (\"yes\" or \"no\")"]
[null,null,"       c.  Cooking Fuel?",null,null," (\"yes\" or \"no\")"]
[null,null,"       d.  Hot Water?",null,null," (\"yes\" or \"no\")"]
[null,null,"       e.  Central A/C (if any)?",null,null," (\"yes\" or \"no\")"]
[null,null,null,null,"Space Heating:",null,null,"Hot Water:"]
[{"$f":"A165+1","v":24},".","Type of heating fuel:",null,null,"Propane",{"$f":"IF(E172<>\" \",1,0)","v":0},null,"Propane"]
[null,null,"                   (Check one with \"X\")",null,null,"Natural Gas",{"$f":"IF(E173<>\" \",1,0)","v":0},null,"Natural Gas"]
[null,null,null,null,null,"Oil",{"$f":"IF(E174<>\" \",1,0)","v":0},null,"Oil"]
[null,null,null,null,null,"Electric",{"$f":"IF(E175<>\" \",1,0)","v":0},null,"Electric"]
[]
[{"$f":"A172+1","v":25},".","No. of parking spaces:",null,null,null,null,null,{"$f":"IF(E177+G177=0,0,(E177+G177))","v":0}]
[null,null,null,null,"Enclosed",null,"Outdoor",null,"Total"]
[]
[27,null,"Will project in include community space? ",null,null,null," (\"yes\" or \"no\")","if yes, sq. ft. "]
[]
[28,null,"Will free, password-protected WIFI be included in the community room? ",null,null,null,null,null," (\"yes\" or \"no\")"]
[]
[29,null,"Does applicant agree to participate in a NH Saves energy charette?",null,null,null,null,null," (\"yes\" or \"no\")"]
[]
[]
[]
[{"$f":"A182+1","v":29},".","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":"A188+1","v":30},".","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":"A191+1","v":31},".","Amount of demolition, if any:"]
[]
[]
[]
["Information on Site and Existing Buildings"]
[]
[null,null,null,null,"Square Feet","Square Feet","Acres","Acres"]
[{"$f":"A205+1","v":32},".","Size of Site:",null,null,{"$f":"IF(E212>0,\"\",IF(G212>0,G212*43560,\" \"))","v":" "},null,{"$f":"IF(G212>0,\"\",IF(E212>0,E212/43560,\" \"))","v":" "}]
[{"$f":"A212+1","v":33},".","Buildable area:",null,null,{"$f":"IF(E213>0,\"\",IF(G213>0,G213*43560,\" \"))","v":" "},null,{"$f":"IF(G213>0,\"\",IF(E213>0,E213/43560,\" \"))","v":" "}]
[null,null,null,null,null,null,null,{"$f":"IF(G214>0,G214*43560,\" \")","v":" "}]
[]
[null,null,"Existing Conditions: "]
[{"$f":"A213+1","v":34},".","What is the present use of the property?"]
[{"$f":"A217+1","v":35},".","Number of existing structures:"]
[{"$f":"A218+1","v":36},".","Gross s.f. of existing structures:"]
[{"$f":"A219+1","v":37},".","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":"A220+1","v":38},".","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":"A223+1","v":39},".","What are the surrounding land uses?"]
[]
[]
[]
[null,null,"Utilities:"]
[{"$f":"A226+1","v":40},".","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(D232=\"yes\",D232=\"no\"),1,0)","v":1}]
[null,null,"b. Storm sewer",null," If no, distance from site:",null,null,"  feet",{"$f":"IF(OR(D233=\"yes\",D233=\"no\"),1,0)","v":1}]
[null,null,"c. Public water",null," If no, distance from site:",null,null,"  feet",{"$f":"IF(OR(D234=\"yes\",D234=\"no\"),1,0)","v":1}]
[null,null,"d. Electricity",null," If no, distance from site:",null,null,"  feet",{"$f":"IF(OR(D235=\"yes\",D235=\"no\"),1,0)","v":1}]
[null,null,"e. Gas",null," If no, distance from site:",null,null,"  feet",{"$f":"IF(OR(D236=\"yes\",D236=\"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":"A231+1","v":41},".","Does the zoning permit the proposed development?",null,null,null,null,null," (\"yes\" or \"no\")",{"$f":"IF(OR(H244=\"yes\",H244=\"no\"),1,0)","v":1}]
[null,null,"    Please detail in permit status letter. "]
[]
[{"$f":"A244+1","v":42},".","If zoning does not allow for the proposed development, has the needed zoning"]
[null,null,"relief/variance/special permit/subdivision approval/site plan approval ",null,null,null,null,null," (\"yes\" or \"no\")"]
[null,null,"been obtained?"]
[null,null,"    Please detail in permit status letter. "]
[]
[{"$f":"A247+1","v":43},".","Are any other efforts for local approvals required?",null,null,null,null,null," (\"yes\" or \"no\")"]
[null,null,"    Please detail in permit status letter. "]
[]
[null,null,"Site Control:"]
[{"$f":"A252+1","v":44},".","What form of site control do you have?  ",null,null,null," (Mark one box)"]
[null,{"$f":"IF(LEN(TRIM(H257))>0,1,0)","v":1},null,null,"Ownership ",null,null," (Mark one box with an \"X\")"]
[null,{"$f":"IF(LEN(TRIM(H258))>0,1,0)","v":1},null,null,"Purchase and Sale Agreement(s) ",null," "," (Mark one box with an \"X\")"]
[null,{"$f":"IF(LEN(TRIM(H259))>0,1,0)","v":1},null,null,"Option ",null," "," (Mark one box with an \"X\")"]
[null,{"$f":"IF(LEN(TRIM(H260))>0,1,0)","v":1},null,"Other:  ",null,null," "," (Mark one box with an \"X\")"]
[null,null,null,null,null,null,"Evidence of site control must be submitted with application"]
[]
[{"$f":"A256+1","v":45},".","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":"A263+1","v":46},".","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(E273<>\" \",1,0)","v":0}]
[null,null,"    If yes, please attach description as part of Exhibit 10."]
[]
[{"$f":"A272+1","v":47},".","Are there any outstanding liens on the property?",null,null,null,null," (\"yes\" or \"no\")",null,{"$f":"IF(G276<>\" \",1,0)","v":0}]
[]
[null,null,"Amenities and Services:"]
[{"$f":"A276+1","v":48},".","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"]

{"sheet":"Closing S&U","index":2,"n_rows":248,"n_cols":13,"rows_kept":248,"cut":false,"hidden":false,"merged":[[167,7,167,8],[166,7,166,8],[151,7,151,8],[155,7,155,8],[156,7,156,8],[0,0,0,9],[188,7,188,8],[41,6,41,9],[16,6,16,7],[13,6,13,9],[14,6,15,7],[113,7,113,8],[52,3,52,4],[49,3,49,4],[46,3,46,4],[30,3,30,4],[20,3,20,4],[22,3,22,4],[24,3,24,4],[26,3,26,4],[114,7,114,8],[157,7,157,8],[158,7,158,8],[172,7,172,8],[173,7,173,8],[140,7,140,8],[154,7,154,8],[165,7,165,8],[137,7,137,8],[145,7,145,8],[159,7,159,8],[160,7,160,8],[161,7,161,8],[162,7,162,8],[34,11,37,11],[2,0,2,9],[1,0,1,9],[114,11,114,12],[115,11,115,12],[28,3,28,4],[59,4,59,8],[60,4,60,8],[127,7,127,8],[121,7,121,8],[205,7,205,8],[215,7,215,8],[115,7,115,8],[116,7,116,8],[117,7,117,8],[118,7,118,8],[122,7,122,8],[129,7,129,8],[130,7,130,8],[131,7,131,8],[132,7,132,8],[133,7,133,8],[134,7,134,8],[135,7,135,8],[136,7,136,8],[146,7,146,8],[147,7,147,8],[148,7,148,8],[149,7,149,8],[150,7,150,8],[141,7,141,8],[142,7,142,8],[143,7,143,8],[144,7,144,8],[168,7,168,8],[169,7,169,8],[170,7,170,8],[171,7,171,8],[201,7,201,8],[182,7,182,8],[183,7,183,8],[184,7,184,8],[195,7,195,8],[196,7,196,8],[177,7,177,8],[178,7,178,8],[179,7,179,8],[180,7,180,8],[181,7,181,8],[194,7,194,8],[189,7,189,8],[174,7,174,8],[175,7,175,8],[176,7,176,8],[8,3,8,5],[10,3,10,5],[14,3,14,4],[15,3,15,4],[36,3,36,4],[38,3,38,4],[45,3,45,4],[48,3,48,4],[51,3,51,4],[244,2,244,3],[234,2,234,3],[242,2,242,4],[127,2,127,3],[243,2,243,3],[233,2,233,3],[232,2,232,6],[220,7,220,8],[221,7,221,8],[222,7,222,8],[213,7,213,8],[216,7,216,8],[217,7,217,8],[218,7,218,8],[219,7,219,8],[202,7,202,8],[209,7,209,8],[210,7,210,8],[211,7,211,8],[212,7,212,8],[197,7,197,8],[198,7,198,8],[199,7,199,8],[200,7,200,8]]}
["CLOSING SOURCES AND USES OF FUNDS"]
[{"$f":"IF(+'Project Info'!E3=\"\",\"Un-named Project\",+'Project Info'!E3)","v":"Un-named Project"}]
["Sources of Funds"]
[]
[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":{"$error":"#VALUE!"}}]
[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}]
[]
[null,null,"Public Equity:","Source",null,"Amount  $",{"$f":"IFERROR(IF((((G7+F20)/'Project Info'!N82)>230000),\"EQUITY & SUBSIDY EXCEEDS QAP MAXIMUM\",\"\"),\"\")","v":""}]
[{"$f":"A12+1","v":8},".","Grant:"]
[{"$f":"A15+1","v":9},".","Grant:"]
[{"$f":"A16+1","v":10},".","Total Public Equity",null,null,{"$f":"SUM(F15:F16)","v":0}]
[]
[null,null,"Subordinate Loans:"]
[{"$f":"A17+1","v":11},".","NHH Subordinate Loan",null,null,"Amount $","Rate %","Amortize (years)","Term (years)","Lien Position"]
[null,null,"Source: "]
[{"$f":"A20+1","v":12},".","NHH Subordinate Loan"]
[null,null,"Source:",null,null,null," ",null," "]
[{"$f":"A22+1","v":13},".","NHH Subordinate Loan"]
[null,null,"       Source:",null,null,null," "," "," "]
[{"$f":"A24+1","v":14},".","Subordinate Loan"]
[null,null,"       Source:",null,null,null,null," "," "]
[{"$f":"A26+1","v":15},".","Subordinate Loan"]
[null,null,"       Source:",null,null,null,null," "," "]
[{"$f":"A28+1","v":16},null,"Subordinate Loan"]
[null,null,"       Source:"]
[{"$f":"A28+1","v":16},".","Total Subordinate Loans",null,null,{"$f":"SUM(F21,F23,F25,F27,F29,F31)","v":0}]
[]
[null,null,"Long Term Loan :",null,null,"Amount $","Rate %","Amortize  (years)","Term (years)","Lien Position"]
[{"$f":"A32+1","v":17},".","NH Housing Long-Term Loan"]
[{"$f":"A35+1","v":18},".","Other Long-Term Loan"]
[null,null,"       Source:"]
[{"$f":"A36+1","v":19},".","Other Long-Term Loan"]
[null,null,"       Source:"]
[{"$f":"A38+1","v":20},".","Total Long-Term Senior Loan",null,null,{"$f":"SUM(F35,F37,F39)","v":0}]
[]
[{"$f":"A40+1","v":21},".","Total Long-Term Sources",null,null,{"$f":"G12+F17+F32+F40","v":0},{"$f":"IFERROR(IF(I41>I17,\"WARNING - TDC EXCEEDS QAP LIMIT!!\",\"\"),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(F42<>G228,\"Sources and Uses do NOT Match!\",\"Ok, Sources and Uses Match!\")","v":"Ok, Sources and Uses Match!"},null,null,{"$f":"IF(F42<>G228,F42-G228,\"\")","v":""}]
[null,null,"Construction/Bridge Financing:"]
[{"$f":"A42+1","v":22},".","Construction Loan",null,null,"Amount  $","Rate  %","Term (months)","Lien Position"]
[null,null,"    Source:"]
[null,null,"    Repaid at:"]
[{"$f":"A45+1","v":23},".","Other Interim Loan"]
[null,null,"    Source:"]
[null,null,"    Repaid at:"]
[{"$f":"A48+1","v":24},".","Tax Credit Bridge Loan"]
[null,null,"    Source:"]
[null,null,"    Repaid at:"]
[]
[]
[null,null,"Uses of Funds"]
[null,null,"NOTE:  Construction cost breakout by trade is only required on the Final Application submitted during the application period"]
[]
[null,null,"Direct Construction:"]
[{"$f":"A51+1","v":25},".","Who prepared the estimates?"]
[{"$f":"A60+1","v":26},".","What is basis for estimates?"]
[]
[null,null,"Division","Trade Item",null,"Amount   $","Trade Description"]
[{"$f":"A61+1","v":27},".",3,"Concrete"]
[{"$f":"A64+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(F64:F95)","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(F97:F103)","v":0}]
[68,".",null,"Total Improvements",null,{"$f":"F104+F96","v":0}]
[69,".",null,"General Conditions",null,null,null,"As % of Total Improvements:",{"$f":"IF(F105=0,\"\",F106/F105)","v":""}]
[70,".",null,"Subtotal",null,{"$f":"F106+F105","v":0}]
[71,".",null,"Builders Overhead",null,null,null,"As % of Subtotal:",{"$f":"IF(F107=0,\"\",F108/F107)","v":""}]
[72,".",null,"Builders Profit",null,null,null,"As % of Subtotal:",{"$f":"IF(F107=0,\"\",F109/F107)","v":""}]
[73,".",null,"TOTAL","(computed for you)",{"$f":"SUM(F107:F109)","v":0},null,"Cost/Sq.Ft.: ",{"$f":"IF('Project Info'!I131+'Project Info'!I132>0,F110/('Project Info'!I131+'Project Info'!I132),0)","v":0}]
[]
[]
[null,null,"Development Budget:"]
[]
[null,null,"ACQUISITION ",null,"Residential","Non-Residential","Total","Comments/Explanation of Costs",null,null,null,"Construction Costs "]
[{"$f":"A110+1","v":74},".","Land",null,null,null,{"$f":"E116+F116","v":0},null,null,null,null,"Including Contingency"]
[{"$f":"A116+1","v":75},".","Existing Building",null,null,null,{"$f":"E117+F117","v":0},null,null,null,null,"Total Construction",{"$f":"G118+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"A117+1","v":76},".","Transfer Tax",null,null,null,{"$f":"E118+F118","v":0}]
[{"$f":"A118+1","v":77},".",null,null,null,null,{"$f":"E119+F119","v":0}]
[null,null,"Subtotal",null,{"$f":"SUM(E116:E119)","v":0},{"$f":"SUM(F116:F119)","v":0},{"$f":"SUM(G116:G119)","v":0},null,null,{"$f":"IF(G120=0,\"\",G120/$G$228)","v":""},null,"Construction Per unit",{"$f":"IFERROR(M117/'Project Info'!N82,\"\")","v":""}]
[]
[null,null,"CONSTRUCTION",null,"Residential","Non-Residential","Total","Comments/Explanation of Costs"]
[{"$f":"A119+1","v":78},null,"Construction Budget",null,null,null,{"$f":"SUM(E123:F123)","v":0}]
[{"$f":"A123+1","v":79},null,"Construction Contingency",null,null,null,{"$f":"SUM(E124:F124)","v":0},"% of construction",{"$f":"(E124/E123)","v":{"$error":"#DIV/0!"}}]
[{"$f":"A124+1","v":80},null,null,null,null,null,0]
[null,null,"Subtotal",null,{"$f":"SUM(E123:E125)","v":0},{"$f":"SUM(F123:F125)","v":0},0]
[]
[null,null,"ARCHITECTURAL/ ENGINEERING/PROFESSIONAL FEES",null,"Residential","Non-Residential","Total","Comments/Explanation of Costs"]
[{"$f":"A125+1","v":81},".","Architect Fee-Design",null,null,null,{"$f":"E129+F129","v":0},{"$f":"IF(AND(G129>0,G123>0),+G129/G123,0)","v":0},"% of construct."]
[{"$f":"A129+1","v":82},null,"Architect Fee-Inspection",null,null,null,0]
[83,".","Engineering Fees",null,null,null,0]
[84,".","Historic Consultant Fees",null,null,null,0]
[85,".","Solar Consultant Fees",null,null,null,0]
[86,".","Site Survey",null,null,null,0]
[87,null,null,null,null,null,0]
[88,null,null,null,null,null,0]
[89,null,null,null,null,null,0]
[90,".",null,null,null,null,0]
[null,null,"Subtotal",null,{"$f":"SUM(E129:E138)","v":0},{"$f":"SUM(F129:F138)","v":0},{"$f":"SUM(G129:G138)","v":0},null,null,{"$f":"IF(G139=0,\"\",G139/$G$228)","v":""}]
[]
[null,null,"INTERIM CONSTRUCTION EXPENSE",null,"Residential","Non-Residential","Total","Comments/Explanation of Costs"]
[{"$f":"A138+1","v":91},".","Construction  Loan Origination Fee",null,null,null,{"$f":"E142+F142","v":0}]
[{"$f":"A142+1","v":92},".","Construction Period Interest",null,null,null,0]
[93,".","Construction Period Insurance",null,null,null,0]
[94,".","P&P Bond/Letter of Credit",null,null,null,0]
[95,".","Construction Lender's Counsel",null,null,null,0]
[96,".","Taxes During Construction",null,null,null,0]
[97,null,"Bond - Cost of Issuance",null,null,null,0]
[{"$f":"A148+1","v":98},null,null,null,null,null,0]
[99,".",null,null,null,null,0]
[100,null,null,null,null,null,0]
[{"$f":"A151+1","v":101},".",null,null,null,null,0]
[null,null,"Subtotal",null,{"$f":"SUM(E142:E152)","v":0},{"$f":"SUM(F142:F152)","v":0},{"$f":"SUM(G142:G152)","v":0},null,null,{"$f":"IF(G153=0,\"\",G153/$G$228)","v":""}]
[]
[null,null,"FINANCING FEES AND EXPENSE",null,"Residential","Non-Residential","Total","Comments/Explanation of Costs"]
[{"$f":"A152+1","v":102},".","Long-Term Loan Origination Fee",null,null,null,{"$f":"E156+F156","v":0}]
[{"$f":"A156+1","v":103},".","Title Insurance and Record",null,null,null,0]
[{"$f":"A157+1","v":104},".","Long-Term Lender's Counsel",null,null,null,0]
[{"$f":"A158+1","v":105},".","Bond - Cost of Issuance",null,null,null,0]
[106,".","Upfront MIP Fee",null,null,null,0]
[107,".","FFB Trustee Fee",null,null,null,0]
[108,".",null,null,null,null,0]
[{"$f":"A162+1","v":109},".",null,null,null,null,0]
[null,null,"Subtotal",null,{"$f":"SUM(E156:E163)","v":0},{"$f":"SUM(F156:F163)","v":0},{"$f":"SUM(G156:G163)","v":0},null,null,{"$f":"IF(G164=0,\"\",G164/$G$228)","v":""}]
[]
[null,null,"OTHER SOFT COSTS",null,"Residential","Non-Residential","Total","Comments/Explanation of Costs"]
[{"$f":"A163+1","v":110},".","Appraisal",null,null,null,{"$f":"E167+F167","v":0}]
[{"$f":"A167+1","v":111},".","Market Study",null,null,null,0]
[112,".","Environmental Report",null,null,null,0]
[{"$f":"A169+1","v":113},".","Relocation Costs",null,null,null,0]
[114,".","Borrower Legal Fees",null,null,null,0]
[115,".","Accounting Fees",null,null,null,0]
[{"$f":"A172+1","v":116},".","NH Housing Lender Inspector",null,null,null,0]
[{"$f":"A173+1","v":117},null,"Furnishings, Fixtures and Equipment",null,null,null,0]
[118,null,"Clerk of the Works",null,null,null,0]
[119,null,"Marketing and Lease-up",null,null,null,0]
[{"$f":"A176+1","v":120},null,"Building Permits",null,null,null,0]
[121,null,"Other Permits",null,null,null,0]
[122,null,"Impact Fees",null,null,null,0]
[123,null,"Water and Sewer Fees ",null,null,null,0]
[124,null,"Soft Cost Contingency",null,null,null,0]
[125,null,null,null,null,null,0]
[126,null,null,null,null,null,0]
[127,null,null,null,null,null,0]
[128,".",null,null,null,null,0]
[null,null,"Subtotal",null,{"$f":"SUM(E167:E185)","v":0},{"$f":"SUM(F167:F185)","v":0},{"$f":"SUM(G167:G185)","v":0},null,null,{"$f":"IF(G186=0,\"\",G186/$G$228)","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"If construction > $2.5 Million = 18% MAX"]
[null,null,"DEVELOPER FEE",null,"Residential","Non-Residential","Total","Comments/Explanation of Costs",null,null,null,"If construction < $2.5 Million = 20% MAX"]
[{"$f":"A185+1","v":129},".","Developer Overhead and Profit",null,null,null,{"$f":"E191+F191","v":0},"Reference \"Dev Fee\" Tab",null,null,null,"Identity of Interest Check",{"$f":"SUM((F106+F108+F109+E193)/E228)","v":{"$error":"#DIV/0!"}}]
[{"$f":"A191+1","v":130},".","Development Consultant Fee",null,null,null,{"$f":"E192+F192","v":0},"Must be netted from Developer Fee"]
[null,null,"Subtotal",null,{"$f":"SUM(E191:E192)","v":0},{"$f":"SUM(F191:F192)","v":0},{"$f":"E193+F193","v":0},null,null,{"$f":"IF(G193=0,\"\",G193/$G$228)","v":""}]
[]
[null,null,"SYNDICATION EXPENSES",null,"Residential","Non-Residential","Total","Comments/Explanation of Costs"]
[{"$f":"A192+1","v":131},".","Syndication Legal",null,null,null,{"$f":"E196+F196","v":0}]
[{"$f":"A196+1","v":132},".","Syndication Accounting",null,null,null,0]
[133,".","Syndication Fees",null,null,null,0]
[134,".","Syndication Consultant",null,null,null,0]
[135,".","Bridge Loan Origination Fee",null,null,null,0]
[136,".","Bridge Loan Interest",null,null,null,0]
[137,".","Investor Servicing (capital)",null,null,null,0]
[138,".",null,null,null,null,0]
[null,null,"Subtotal",null,{"$f":"SUM(E196:E203)","v":0},{"$f":"SUM(F196:F203)","v":0},{"$f":"SUM(G196:G203)","v":0},null,null,{"$f":"IF(G204=0,\"\",G204/$G$228)","v":""}]
[]
[null,null,"RESERVES (see NH Housing Underwriting Standards)",null,"Residential","Non-Residential","Total","Comments/Explanation of Costs"]
[{"$f":"A203+1","v":139},".","Operating Reserve",null,null,null,{"$f":"E207+F207","v":0},"Calculated",{"$f":"('Pro Forma'!F46/12*4)+('Inc & Exp'!G234/12*4)","v":0}]
[{"$f":"A207+1","v":140},".","FFB Operating Reserve (FFB Transactions only)",null,null,null,{"$f":"E208+F208","v":0},"Calculated ",{"$f":"'Inc & Exp'!G228/12*2","v":0}]
[{"$f":"A208+1","v":141},".","Replacement Reserve",null,null,null,0,"Calculated ",{"$f":"'Inc & Exp'!F223*'Project Info'!N82","v":0}]
[{"$f":"A209+1","v":142},".","Insurance Escrow",null,null,null,0]
[143,".","Real Estate Tax Escrow",null,null,null,0]
[144,".",null,null,null,null,0]
[145,".",null,null,null,null,0]
[null,null,"Subtotal",null,{"$f":"SUM(E207:E213)","v":0},{"$f":"SUM(F207:F213)","v":0},{"$f":"SUM(G207:G213)","v":0},null,null,{"$f":"IF(G214=0,\"\",G214/$G$228)","v":""}]
[]
[null,null,"PROGRAM FEES",null,"Residential","Non-Residential","Total","Comments/Explanation of Costs"]
[{"$f":"(A213+1)","v":146},null,"LIHTC Allocation Fee",null,null,null,{"$f":"(E217+F217)","v":0},"7% of Annual Credit Allocation"]
[{"$f":"(A217+1)","v":147},null,"LIHTC Upfront Monitoring Fee",null,null,null,{"$f":"(E218+F218)","v":0},"See NHH Fee Schedule"]
[{"$f":"(A218+1)","v":148},null,"HOME Monitoring Fee",null,null,null,0,"See NHH Fee Schedule"]
[{"$f":"(A219+1)","v":149},null,"HOME-ARP Monitoring Fee",null,null,null,0,"See NHH Fee Schedule"]
[{"$f":"(A220+1)","v":150},null,"Housing Trust Fund Monitoring Fee",null,null,null,0,"See NHH Fee Schedule"]
[{"$f":"(A221+1)","v":151},null,"AHF Monitoring Fee",null,null,null,0,"See NHH Fee Schedule"]
[{"$f":"A222+1","v":152},null,"Loan Application Fee",null,null,null,0,"See NHH Fee Schedule"]
[{"$f":"A223+1","v":153},null,null,null,null,null,0]
[{"$f":"A224+1","v":154},null,null,null,null,null,0]
[null,null,"Subtotal",null,{"$f":"SUM(E217:E225)","v":0},{"$f":"SUM(F217:F225)","v":0},{"$f":"SUM(G217:G225)","v":0},null,null,{"$f":"IF(G226=0,\"\",G226/$G$228)","v":""}]
[]
[{"$f":"A225+1","v":155},".","Total Development Cost",null,{"$f":"E120+E126+E139+E153+E164+E186+E193+E204+E214+E226","v":0},{"$f":"F120+F126+F139+F153+F164+F186+F193+F204+F214+F226","v":0},{"$f":"G120+G126+G139+G153+G164+G186+G193+G204+G214+G226","v":0},{"$f":"IF(F42<>G228,\"Sources and Uses do NOT Match!\",\"Sources and Uses Match!\")","v":"Sources and Uses Match!"}]
[]
[{"$f":"A228+1","v":156},".","Total Net* Development Cost",null,{"$f":"E228-E204","v":0},{"$f":"F228-F204","v":0},{"$f":"SUM(E230:F230)","v":0}]
[null,null,"*TDC less any costs associated with syndicating tax credits"]
[]
[{"$f":"A230+1","v":157},null,"Total Development Cost Limits and TDC Weighted Average Limits (HFA 109.04C. Per Unit Cost Standards/Housing Investment Limits)"]
[{"$f":"A233+1","v":158},null,"Does project fall into a high-cost category per HFA:109.04.C? Yes/No",null,"No"]
[{"$f":"A234+1","v":159},null,"TDC Weighted Average applicable to project. ",null,{"$f":"IF(E234=\"No\",375000,IF(E234=\"Yes\",400000,IF(ISBLANK(I15),\"Blank\",)))","v":375000}]
[{"$f":"A235+1","v":160},null,"TDC Per unit Limit (non-weighted): ",null,437500]
[]
[null,null,null,"TDC Calculation","Does project meet QAP limit?"]
[{"$f":"A236+1","v":161},null,"TDC/bedroom:",{"$f":"IFERROR(E228/'Project Info'!N84,0)","v":0}]
[{"$f":"A239+1","v":162},null,"TDC/Unit:",{"$f":"IFERROR(E228/'Project Info'!N82,0)","v":0}]
[{"$f":"A240+1","v":163},null,"TDC Wtd Avg:",{"$f":"((2*D240)+D239)/3","v":0}]
[]
[{"$f":"A241+1","v":164},null,"Housing Investment Limits ((HFA 109.04C. Per Unit Cost Standards/Housing Investment Limits))",null,null,null,{"$f":"IF(F42>G228,\"Sources exceed Uses by:\",IF(F42<G228,\"Uses exceed Sources by:\",\"\"))","v":""},{"$f":"IF(F42<>G228,F42-G228,\"\")","v":""}]
[{"$f":"A243+1","v":165},null,"Housing Investment Limit: ",null,300000]
[{"$f":"A244+1","v":166},null,"Housing Investment Limit Calculated: ",null,{"$f":"IFERROR((G7+F21+F23+F25)/'Project Info'!N82,0)","v":0}]
[]
[null,null,"Debt Service Requirements:"]
[{"$f":"A245+1","v":167},null,"Minimum Debt Service Coverage",null,null,1.1499999999999999]

{"sheet":"Inc & Exp","index":3,"n_rows":261,"n_cols":10,"rows_kept":261,"cut":false,"hidden":false,"merged":[[118,3,118,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"}]
[]
["Operating Income"]
[null,null,"Rent Schedule:"]
[1,null,{"$f":"'Project Info'!D75","v":"Market Rate"},"Market Rent ","Contract Rent","Utility Allowance","% of Market Rent","Gross Rent","# of Units "]
[null,null,"SRO",null,null,null,{"$f":"IFERROR(H7/D7,\"\")","v":""},{"$f":"IF(I7>0,E7+F7,\"\")","v":""},{"$f":"'Project Info'!D76","v":0},{"$f":"(E7*I7)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,"","",{"$f":"'Project Info'!D77","v":0},0]
[null,null,"1 Bedroom",null,null,null,"","",{"$f":"'Project Info'!D78","v":0},0]
[null,null,"2 Bedroom",null,null,null,"","",{"$f":"'Project Info'!D79","v":0},0]
[null,null,"3 Bedroom",null,null,null,"","",{"$f":"'Project Info'!D80","v":0},0]
[null,null,"4 Bedroom",null,null,null,"","",{"$f":"'Project Info'!D81","v":0},0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I7:I12)","v":0}]
[]
[{"$f":"A6+1","v":2},null,{"$f":"'Project Info'!E75","v":"LIHTC 20% AMI/HTF PBV"},"Rent Limit ","Contract Rent","Utility Allowance","% of Rent Limit","Gross Rent","# of Units"]
[null,null,"SRO",null,null,null,{"$f":"IFERROR(H16/D16,\"\")","v":""},{"$f":"IF(I16>0,E16+F16,\"\")","v":""},{"$f":"'Project Info'!E76","v":0},{"$f":"(E16*I16)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,"","",{"$f":"'Project Info'!E77","v":0},0]
[null,null,"1 Bedroom",null,null,null,"","",{"$f":"'Project Info'!E78","v":0},0]
[null,null,"2 Bedroom",null,null,null,"","",{"$f":"'Project Info'!E79","v":0},0]
[null,null,"3 Bedroom",null,null,null,"","",{"$f":"'Project Info'!E80","v":0},0]
[null,null,"4 Bedroom",null,null,null,"","",{"$f":"'Project Info'!E81","v":0},0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I16:I21)","v":0}]
[]
[{"$f":"A15+1","v":3},null,{"$f":"'Project Info'!F75","v":"LIHTC 30% AMI/HTF PBV"},"Rent Limit ","Contract Rent","Utility Allowance","% of Rent Limit","Gross Rent","# of Units"]
[null,null,"SRO",null,null,null,{"$f":"IFERROR(H25/D25,\"\")","v":""},{"$f":"IF(I25>0,E25+F25,\"\")","v":""},{"$f":"'Project Info'!F76","v":0},{"$f":"(E25*I25)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,"","",{"$f":"'Project Info'!F77","v":0},0]
[null,null,"1 Bedroom",null,null,null,"","",{"$f":"'Project Info'!F78","v":0},0]
[null,null,"2 Bedroom",null,null,null,"","",{"$f":"'Project Info'!F79","v":0},0]
[null,null,"3 Bedroom",null,null,null,"","",{"$f":"'Project Info'!F80","v":0},0]
[null,null,"4 Bedroom",null,null,null,"","",{"$f":"'Project Info'!F81","v":0},0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I25:I30)","v":0}]
[]
[{"$f":"A24+1","v":4},null,{"$f":"'Project Info'!G75","v":"LIHTC 60% AMI"},"Rent Limit ","Contract Rent","Utility Allowance","% of Rent Limit","Gross Rent","# of Units"]
[null,null,"SRO",null,null,null,{"$f":"IFERROR(H34/D34,\"\")","v":""},{"$f":"IF(I34>0,E34+F34,\"\")","v":""},{"$f":"'Project Info'!G76","v":0},{"$f":"(E34*I34)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,"","",{"$f":"'Project Info'!G77","v":0},0]
[null,null,"1 Bedroom",null,null,null,"","",{"$f":"'Project Info'!G78","v":0},0]
[null,null,"2 Bedroom",null,null,null,"","",{"$f":"'Project Info'!G79","v":0},0]
[null,null,"3 Bedroom",null,null,null,"","",{"$f":"'Project Info'!G80","v":0},0]
[null,null,"4 Bedroom",null,null,null,"","",{"$f":"'Project Info'!G81","v":0},0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I34:I39)","v":0}]
[]
[{"$f":"A33+1","v":5},null,{"$f":"'Project Info'!H75","v":"LIHTC 70% AMI"},"Rent Limit ","Contract Rent","Utility Allowance","% of Rent Limit","Gross Rent","# of Units"]
[null,null,"SRO",null,null,null,{"$f":"IFERROR(H43/D43,\"\")","v":""},{"$f":"IF(I43>0,E43+F43,\"\")","v":""},{"$f":"'Project Info'!H76","v":0},{"$f":"(E43*I43)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,"","",{"$f":"'Project Info'!H77","v":0},0]
[null,null,"1 Bedroom",null,null,null,"","",{"$f":"'Project Info'!H78","v":0},0]
[null,null,"2 Bedroom",null,null,null,"","",{"$f":"'Project Info'!H79","v":0},0]
[null,null,"3 Bedroom",null,null,null,"","",{"$f":"'Project Info'!H80","v":0},0]
[null,null,"4 Bedroom",null,null,null,"","",{"$f":"'Project Info'!H81","v":0},0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I43:I48)","v":0}]
[]
[]
[]
[null,null,"Rent Schedule (Continued):"]
[]
[{"$f":"A42+1","v":6},null,{"$f":"'Project Info'!I75","v":"LIHTC 80% AMI"},"Rent Limit ","Contract Rent","Utility Allowance","% of Rent Limit","Gross Rent","# of Units"]
[null,null,"SRO",null,null,null,{"$f":"IFERROR(H56/D56,\"\")","v":""},{"$f":"IF(I56>0,E56+F56,\"\")","v":""},{"$f":"'Project Info'!I76","v":0},{"$f":"(E56*I56)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,"","",{"$f":"'Project Info'!I77","v":0},0]
[null,null,"1 Bedroom",null,null,null,"","",{"$f":"'Project Info'!I78","v":0},0]
[null,null,"2 Bedroom",null,null,null,"","",{"$f":"'Project Info'!I79","v":0},0]
[null,null,"3 Bedroom",null,null,null,"","",{"$f":"'Project Info'!I80","v":0},0]
[null,null,"4 Bedroom",null,null,null,"","",{"$f":"'Project Info'!I81","v":0},0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I56:I61)","v":0}]
[]
[{"$f":"A55+1","v":7},null,{"$f":"'Project Info'!J75","v":"Income Limit/Program "},"Rent Limit ","Contract Rent","Utility Allowance","% of Rent Limit","Gross Rent","# of Units"]
[null,null,"SRO",null,null,null,{"$f":"IFERROR(H65/D65,\"\")","v":""},{"$f":"IF(I65>0,E65+F65,\"\")","v":""},{"$f":"'Project Info'!J76","v":0},{"$f":"(E65*I65)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,"","",{"$f":"'Project Info'!J77","v":0},0]
[null,null,"1 Bedroom",null,null,null,"","",{"$f":"'Project Info'!J78","v":0},0]
[null,null,"2 Bedroom",null,null,null,"","",{"$f":"'Project Info'!J79","v":0},0]
[null,null,"3 Bedroom",null,null,null,"","",{"$f":"'Project Info'!J80","v":0},0]
[null,null,"4 Bedroom",null,null,null,"","",{"$f":"'Project Info'!J81","v":0},0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I65:I70)","v":0}]
[]
[{"$f":"A64+1","v":8},null,{"$f":"'Project Info'!K75","v":"Income Limit/Program "},"Rent Limit ","Contract Rent","Utility Allowance","% of Rent Limit","Gross Rent","# of Units"]
[null,null,"SRO",null,null,null,{"$f":"IFERROR(H74/D74,\"\")","v":""},{"$f":"IF(I74>0,E74+F74,\"\")","v":""},{"$f":"'Project Info'!K76","v":0},{"$f":"(E74*I74)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,"","",{"$f":"'Project Info'!K77","v":0},0]
[null,null,"1 Bedroom",null,null,null,"","",{"$f":"'Project Info'!K78","v":0},0]
[null,null,"2 Bedroom",null,null,null,"","",{"$f":"'Project Info'!K79","v":0},0]
[null,null,"3 Bedroom",null,null,null,"","",{"$f":"'Project Info'!K80","v":0},0]
[null,null,"4 Bedroom",null,null,null,"","",{"$f":"'Project Info'!K81","v":0},0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I74:I79)","v":0}]
[{"$f":"A73+1","v":9},null,{"$f":"'Project Info'!L75","v":"Income Limit/Program "},"Rent Limit ","Contract Rent","Utility Allowance","% of Rent Limit","Gross Rent","# of Units"]
[null,null,"SRO",null,null,null,{"$f":"IFERROR(H82/D82,\"\")","v":""},{"$f":"IF(I82>0,E82+F82,\"\")","v":""},{"$f":"'Project Info'!L76","v":0},{"$f":"(E82*I82)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,"","",{"$f":"'Project Info'!L77","v":0},0]
[null,null,"1 Bedroom",null,null,null,"","",{"$f":"'Project Info'!L78","v":0},0]
[null,null,"2 Bedroom",null,null,null,"","",{"$f":"'Project Info'!L79","v":0},0]
[null,null,"3 Bedroom",null,null,null,"","",{"$f":"'Project Info'!L80","v":0},0]
[null,null,"4 Bedroom",null,null,null,"","",{"$f":"'Project Info'!L81","v":0},0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I82:I87)","v":0}]
[]
[{"$f":"A81+1","v":10},null,{"$f":"'Project Info'!M75","v":"Income Limit/Program "},"Rent Limit ","Contract Rent","Utility Allowance","% of Rent Limit","Gross Rent","# of Units"]
[null,null,"SRO",null,null,null,{"$f":"IFERROR(H91/D91,\"\")","v":""},{"$f":"IF(I91>0,E91+F91,\"\")","v":""},{"$f":"'Project Info'!M76","v":0},{"$f":"(E91*I91)*12","v":0}]
[null,null,"0 Bedroom",null,null,null,"","",{"$f":"'Project Info'!M77","v":0},0]
[null,null,"1 Bedroom",null,null,null,"","",{"$f":"'Project Info'!M78","v":0},0]
[null,null,"2 Bedroom",null,null,null,"","",{"$f":"'Project Info'!M79","v":0},0]
[null,null,"3 Bedroom",null,null,null,"","",{"$f":"'Project Info'!M80","v":0},0]
[null,null,"4 Bedroom",null,null,null,"","",{"$f":"'Project Info'!M81","v":0},0]
[null,null,null,null,null,null,null,"Subtotal",{"$f":"SUM(I91:I96)","v":0}]
[]
[]
[]
[null,null,"Commercial Income:",null,null,"(average) $ / sq. ft."]
[{"$f":"A90+1","v":11},null,"Square Feet:",{"$f":"'Project Info'!F136","v":0},"@   ",null,"       = Comm. Income:",null,{"$f":"D102*F102","v":0}]
[]
[null,null,"Vacancy Rates:","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6 and up"]
[{"$f":"A102+1","v":12},null,{"$f":"'Project Info'!D75","v":"Market Rate"},0.05,0.05,0.05,0.05,0.05,0.05]
[{"$f":"(A105+1)","v":13},null,{"$f":"'Project Info'!E75","v":"LIHTC 20% AMI/HTF PBV"},0.05,0.05,0.05,0.05,0.05,0.05]
[{"$f":"(A106+1)","v":14},null,{"$f":"'Project Info'!F75","v":"LIHTC 30% AMI/HTF PBV"},0.05,0.05,0.05,0.05,0.05,0.05]
[15,null,{"$f":"'Project Info'!G75","v":"LIHTC 60% AMI"},0.05,0.05,0.05,0.05,0.05,0.05]
[16,null,{"$f":"'Project Info'!H75","v":"LIHTC 70% AMI"},0.05,0.05,0.05,0.05,0.05,0.05]
[17,null,{"$f":"'Project Info'!I75","v":"LIHTC 80% AMI"},0.05,0.05,0.05,0.05,0.05,0.05]
[{"$f":"A110+1","v":18},null,{"$f":"'Project Info'!J75","v":"Income Limit/Program "},0.05,0.05,0.05,0.05,0.05,0.05]
[19,null,{"$f":"'Project Info'!K75","v":"Income Limit/Program "},0.05,0.05,0.05,0.05,0.05,0.05]
[20,null,{"$f":"'Project Info'!L75","v":"Income Limit/Program "},0.05,0.05,0.05,0.05,0.05,0.05]
[21,null,{"$f":"'Project Info'!M75","v":"Income Limit/Program "},0.05,0.05,0.05,0.05,0.05,0.05]
[22,null,"Commercial Space",0.05,0.05,0.05,0.05,0.05,0.05]
[]
[{"$f":"A115+1","v":23},null,"Laundry Income (annual):",null,null,"$"]
[]
[{"$f":"A117+1","v":24},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":"A119+1","v":25},null,{"$f":"'Project Info'!D75","v":"Market Rate"},null,0.02,0.02,0.02,0.02,2.5000000000000001E-2,{"$f":"IF(AND(I13>0,SUM(E122:H122)<0.000001),1,0)","v":0}]
[{"$f":"A122+1","v":26},null,{"$f":"'Project Info'!E75","v":"LIHTC 20% AMI/HTF PBV"},null,0.02,0.02,0.02,0.02,2.5000000000000001E-2]
[{"$f":"A123+1","v":27},null,{"$f":"'Project Info'!F75","v":"LIHTC 30% AMI/HTF PBV"},null,0.02,0.02,0.02,0.02,2.5000000000000001E-2]
[28,null,{"$f":"'Project Info'!G75","v":"LIHTC 60% AMI"},null,0.02,0.02,0.02,0.02,2.5000000000000001E-2]
[29,null,{"$f":"'Project Info'!H75","v":"LIHTC 70% AMI"},null,0.02,0.02,0.02,0.02,2.5000000000000001E-2]
[30,null,{"$f":"'Project Info'!I75","v":"LIHTC 80% AMI"},null,0.02,0.02,0.02,0.02,2.5000000000000001E-2]
[{"$f":"A127+1","v":31},null,{"$f":"'Project Info'!J75","v":"Income Limit/Program "},null,0.02,0.02,0.02,0.02,2.5000000000000001E-2,{"$f":"IF(AND(I22>0,SUM(E128:H128)<0.000001),1,0)","v":0}]
[{"$f":"A128+1","v":32},null,{"$f":"'Project Info'!K75","v":"Income Limit/Program "},null,0.02,0.02,0.02,0.02,2.5000000000000001E-2,{"$f":"IF(AND(I31>0,SUM(E129:H129)<0.000001),1,0)","v":0}]
[33,null,{"$f":"'Project Info'!L75","v":"Income Limit/Program "},null,0.02,0.02,0.02,0.02,2.5000000000000001E-2,{"$f":"IF(AND(I40>0,SUM(E130:H130)<0.000001),1,0)","v":0}]
[{"$f":"A130+1","v":34},null,{"$f":"'Project Info'!M75","v":"Income Limit/Program "},null,0.02,0.02,0.02,0.02,2.5000000000000001E-2,{"$f":"IF(AND(I48>0,SUM(E131:H131)<0.000001),1,0)","v":0}]
[{"$f":"A131+1","v":35},null,"Commercial Space Rental",null,0.02,0.02,0.02,0.02,2.5000000000000001E-2,{"$f":"IF(AND(D102>0,SUM(E132:H132)<0.000001),1,0)","v":0}]
[36,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":"A133+1","v":37},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":"C142","v":0},{"$f":"D142","v":""},{"$f":"E142","v":"Operating Reserves"}]
[null,"Year 1  ",0,null,null,"Year 11  ",{"$f":"C152*1.0125","v":0}]
[null,"Year 2  ",{"$f":"C143*1.0125","v":0},null,null,"Year 12  ",{"$f":"G143*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":"A139+1","v":38},".","Annual Operating Income (year 1) :",null,null,{"$f":"(SUM(J7:J12)*(1-D105))+(SUM(J16:J21)*(1-D110))+(SUM(J25:J30)*(1-D110))+(SUM(J34:J39)*(1-D110))+(SUM(J43:J48)*(1-D110))+(SUM(J56:J61)*(1-D111))+(SUM(J65:J70)*(1-D111))+(SUM(J74:J79)*(1-D112))+(SUM(J82:J87)*(1-D113))+(SUM(J91:J96)*(1-D114)+(SUM(I102*(1-D115))+G117+G119+(C143+D143+E143)))","v":0}]
[]
[]
["Operating Expenses"]
[]
[null,"Annual Operating Exp.:",null,null,"Residential","Commercial","Total","Comments"]
[{"$f":"A154+1","v":39},null,"Management Fee",null,null,null,{"$f":"E160+F160","v":0},{"$f":"IF(F154=0,\"\",G160/F154)","v":""},"of total op. Inc."]
[{"$f":"A160+1","v":40},null,"Payroll, Administrative",null,null,null,0]
[41,null,"Payroll Taxes & Benefits, Admin",null,null,null,0]
[42,null,"Legal",null,null,null,0]
[43,null,"Audit",null,null,null,0]
[44,null,"Marketing",null,null,null,0]
[45,null,"Telephone",null,null,null,0]
[46,null,"Office Supplies",null,null,null,0]
[47,null,"Accounting & Data Processing",null,null,null,0]
[48,null,"Investor Servicing Fees",null,null,null,0,"Paid  \"below the line\""]
[49,null,"Other Fees:",null,null,null,0]
[50,null,"Other:",null,null,null,0]
[51,null,"Other:"," ",null,null,0]
[52,null,"Subtotal: Administrative",null,{"$f":"SUM(E160:E172)","v":0},{"$f":"SUM(F160:F172)","v":0},{"$f":"SUM(G160:G172)","v":0}]
[null,null,null,null,""]
[{"$f":"A173+1","v":53},null,"Payroll, Maintenance",null,null,null,{"$f":"E175+F175","v":0}]
[{"$f":"A175+1","v":54},null,"Payroll Taxes & Benefits, Maint",null,null,null,0]
[55,null,"Janitorial Materials",null,null,null,0]
[56,null,"Landscaping",null,null,null,0]
[57,null,"Decorating (inter. only)",null,null,null,0]
[58,null,"Repairs (inter. & ext.)",null,null,null,0]
[59,null,"Elevator Maintenance",null,null,null,0]
[60,null,"Trash Removal",null,null,null,0]
[61,null,"Snow Removal",null,null,null,0]
[62,null,"Extermination",null,null,null,0]
[63,null,"Recreation",null,null,null,0]
[64,null,"Other:",null,null,null,0]
[65,null,"Subtotal: Maintenance",null,{"$f":"SUM(E175:E186)","v":0},{"$f":"SUM(F175:F186)","v":0},{"$f":"SUM(G175:G186)","v":0}]
[null,null,null,null," "]
[{"$f":"A187+1","v":66},null,"Direct Service Staff / Contract staff",null,null,null,{"$f":"E189+F189","v":0}]
[null,null,"Food Supplies",null,null,null,{"$f":"E190+F190","v":0}]
[null,null,"Program Supplies",null,null,null,{"$f":"E191+F191","v":0}]
[null,null,"Subtotal: Resident Services",null,{"$f":"SUM(E189:E191)","v":0},{"$f":"SUM(F189:F191)","v":0},{"$f":"SUM(G189:G191)","v":0}]
[]
[{"$f":"A189+1","v":67},null,"Security",null,null,null,{"$f":"E194+F194","v":0}]
[]
[{"$f":"A194+1","v":68},null,"Electricity",null,null,null,{"$f":"E196+F196","v":0}]
[{"$f":"A196+1","v":69},null,"Natural Gas",null,null,null,{"$f":"E197+F197","v":0}]
[{"$f":"A197+1","v":70},null,"Oil",null,null,null,{"$f":"E198+F198","v":0}]
[{"$f":"A198+1","v":71},null,"Water & Sewer",null,null,null,{"$f":"E199+F199","v":0}]
[{"$f":"A199+1","v":72},null,"Subtotal: Utilities",null,{"$f":"SUM(E196:E199)","v":0},{"$f":"SUM(F196:F199)","v":0},{"$f":"SUM(G196:G199)","v":0}]
[null,null,null,null," "]
[{"$f":"A200+1","v":73},null,"Replacement Reserve",null,null,null,{"$f":"E202+F202","v":0},"Calculated",{"$f":"500*'Project Info'!N82","v":0}]
[null,null,null,null," "]
[{"$f":"A202+1","v":74},null,"Real Estate Taxes",null,null,null,{"$f":"E204+F204","v":0}]
[{"$f":"A204+1","v":75},null,"Other Taxes",null,null,null,{"$f":"E205+F205","v":0}]
[76,null,"Insurance",null,null,null,{"$f":"E206+F206","v":0}]
[77,null,"Mortgage Insurance Premium",null,null,null,{"$f":"E207+F207","v":0}]
[78,null,"Other",null,null,null,{"$f":"E208+F208","v":0}]
[79,null,"Other"]
[80,null,"Subtotal: Taxes, Insurance",null,{"$f":"SUM(E204:E208)","v":0},{"$f":"SUM(F204:F208)","v":0},{"$f":"E210+F210","v":0}]
[null,null,null,"Total Expenses (w/o Res. Serv)",{"$f":"E173+E187+E192+E194+E200+E210","v":0},{"$f":"F173+F187+F192+F194+F200+F210","v":0},{"$f":"G173+G187+G192+G194+G200+G210","v":0},"PUPM"]
[{"$f":"A210+1","v":81},null,"Total All Expenses",null,{"$f":"E173+E187+E192+E194+E200+E202+E210","v":0},{"$f":"F173+F187+F192+F194+F200+F202+F210","v":0},{"$f":"G173+G187+G192+G194+G200+G202+G210","v":0},{"$f":"IF('Project Info'!N82<=0,\"\",G212/'Project Info'!N82/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":"A212+1","v":82},null,"Sewer & Water",null,null,0.03,0.03,0.03,0.03]
[{"$f":"A216+1","v":83},null,"Real Estate Taxes",null,null,0.03,0.03,0.03,0.03]
[{"$f":"A217+1","v":84},null,"All Other Operating Expenses, incl repl reserve",null,null,0.03,0.03,0.03,0.03]
[]
[]
[]
[null,null,"Reserve Requirements:"]
[{"$f":"A218+1","v":85},null,"Replacement Reserve Requirement 1st Yr",null,null,500,"   per unit per year"]
[{"$f":"A223+1","v":86},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":"A224+1","v":87},null,"NHHFA Permanent Loan",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}]
[{"$f":"A228+1","v":88},null,"Other Permanent Mortgage"]
[null,null,"       Source:",{"$f":"IF('Closing S&U'!D37=\"\",\"\",IF(LEN(TRIM('Closing S&U'!D37))>1,+'Closing S&U'!D37,\"\"))","v":""},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}]
[{"$f":"A229+1","v":89},null,"Other Permanent Mortgage"]
[null,null,"       Source:",{"$f":"IF('Closing S&U'!D39=\"\",\"\",IF(LEN(TRIM('Closing S&U'!D39))>1,+'Closing S&U'!D39,\"\"))","v":""},null,null,{"$f":"IF('Closing S&U'!H39<>0,(PMT(('Closing S&U'!G39/12),('Closing S&U'!H39*12),-'Closing S&U'!F39)*12),0)","v":0}]
[]
[{"$f":"A231+1","v":90},null,"Total Debt Service (Annual)",null,null,null,{"$f":"SUM(G228:G229)+G231","v":0}]
[]
[{"$f":"A234+1","v":91},null,"Net Operating Income",null,null,null,{"$f":"F154-G212","v":0}," (in year one)"]
[]
[{"$f":"A236+1","v":92},null,"Debt Service Coverage Ratio",null,null,null,{"$f":"IF(G234>0,G236/G234,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":"A238+1","v":93},null,"Median Income For Site:",null,null,"Median Area Income    $"]
[]
[{"$f":"A243+1","v":94},null,"As of (date): ",null,null,"Area used is"]
[]
[{"$f":"A245+1","v":95},null,"Income, Adjusted by Household Size:",null,null,null,0.8,0.6,0.5]
[null,null,null,null,{"$f":"0.7*$H$243","v":0},"1 person",null,{"$f":"E248*0.6","v":0},{"$f":"E248*0.5","v":0}]
[null,null,null,null,{"$f":"0.8*$H$243","v":0},"2 person",null,0,0]
[null,null,null,null,{"$f":"0.9*$H$243","v":0},"3 person",null,0,0]
[null,null,null,null,{"$f":"$H$243","v":0},"4 person",null,0,0]
[null,null,null,null,{"$f":"1.1*$H$243","v":0},"5 person",null,0,0]
[null,null,null,null,{"$f":"1.2*$H$243","v":0},"6 person",null,0,0]
[]
[{"$f":"A247+1","v":96},null,"HOME Designated Units"]
[null,null,null,"High Home"]
[null,null,null,"Low Home"]
[null,null,null,"Total"]
[]
[]
[null,null,null,null,""]

{"sheet":"LIHTC Info","index":4,"n_rows":202,"n_cols":9,"rows_kept":202,"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'!N82-'Project Info'!D82","v":0},null,"Total Units ",{"$f":"'Project Info'!N82","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'!F135","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,"No"," (\"yes\" or \"no\")"]
[7,".","Enter applicable percentage for acquisition credit if project qualifies**",null,null,null,null,0.04," (.04 or actual)"]
[8,".","Enter applicable percentage for rehabilitation credit or new construction**",null,null,null,null,null," (.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,"Yes"," (\"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":0}]
[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":"G197","v":0},null,{"$f":"H197","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(H197=\"\",\"\",IF(CODE(H21)=121,(H197-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.3}]
[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.04},null,{"$f":"IF(H15=\"\",\"\",H15)","v":""}]
[24,".","Maximum Annual Tax Credit Amount",null,null,null,{"$f":"G38*G39","v":0},null,{"$f":"I38*I39","v":{"$error":"#VALUE!"}}]
[25,".","Total Annual Tax Credit Amount",null,null,null,null,{"$f":"SUM(G40,I40)","v":{"$error":"#VALUE!"}}]
[26,".","Estimated Net*** LIHTC Equity Yield$",null,null,0.87," per dollar",{"$f":"H41*F42*10*1","v":{"$error":"#VALUE!"}}]
[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":{"$error":"#VALUE!"}}]
[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},".","For 9% LIHTC projects, does the applicant agree to a 60-year Land Use Restriction",null,null,null,null,null," (\"yes\" or \"no\")"]
[null,null,"Agreement, per the QAP?"]
[]
[{"$f":"A52+1","v":31},null,"For 9% LIHTC projects, does the applicant agree to a 75-year Land Use Restriction",null,null,null,null,null," (\"yes\" or \"no\")"]
[null,null,"Agreement? "]
[]
[{"$f":"A55+1","v":32},null,"For 4% LIHTC projects with no NH Housing capital subsidy, does the applicant agree ",null,null,null,null,null," (\"yes\" or \"no\")"]
[null,null," to a 30-year Land Use Restriction Agreement?"]
[]
[{"$f":"A58+1","v":33},null,"For 4% LIHTC projects with NH Housing capital subsidy, does the applicant agree ",null,null,null,null,null," (\"yes\" or \"no\")"]
[null,null," to a 45-year Land Use Restriction Agreement?"]
[]
[34,null,"For 4% LIHTC projects, does the applicant commit to a Land Use Restriction Agreement ",null,null,null,null,null," (\"yes\" or \"no\")"]
[null,null,"that exceeds the minimum required in Qualified Allocation Plan? "]
[]
[{"$f":"A64+1","v":35},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":"A67+1","v":36},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":"A70+1","v":37},".","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(E197=(G197+H197+I197),\"\",\"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":"E197-(G197+H197+I197)","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,{"$f":"'Closing S&U'!C115","v":"ACQUISITION "}]
[{"$f":"A75+1","v":38},".",{"$f":"'Closing S&U'!C116","v":"Land"},null,{"$f":"'Closing S&U'!E116","v":0},0,0,0,0]
[{"$f":"A87+1","v":39},".",{"$f":"'Closing S&U'!C117","v":"Existing Building"},null,{"$f":"'Closing S&U'!E117","v":0},0,0,0,0]
[{"$f":"A88+1","v":40},".",{"$f":"'Closing S&U'!C118","v":"Transfer Tax"},null,{"$f":"'Closing S&U'!E118","v":0},0,0,0,0]
[{"$f":"A89+1","v":41},".",{"$f":"'Closing S&U'!C119","v":0},null,{"$f":"'Closing S&U'!E119","v":0},0,0,0,0]
[null,null,{"$f":"'Closing S&U'!C120","v":"Subtotal"},null,{"$f":"SUM(E87:E90)","v":0},null,{"$f":"SUM(G87:G90)","v":0},{"$f":"SUM(H87:H90)","v":0},{"$f":"SUM(I87:I90)","v":0}]
[null,null,{"$f":"'Closing S&U'!C122","v":"CONSTRUCTION"}]
[{"$f":"A90+1","v":42},null,{"$f":"'Closing S&U'!C123","v":"Construction Budget"},null,{"$f":"'Closing S&U'!E123","v":0},0,0,0,0]
[{"$f":"A93+1","v":43},null,{"$f":"'Closing S&U'!C124","v":"Construction Contingency"},null,{"$f":"'Closing S&U'!E124","v":0},0,0,0,0]
[{"$f":"A94+1","v":44},null,{"$f":"'Closing S&U'!C125","v":0},null,{"$f":"'Closing S&U'!E125","v":0},0,0,0,0]
[null,null,{"$f":"'Closing S&U'!C126","v":"Subtotal"},null,{"$f":"SUM(E93:E95)","v":0},null,{"$f":"SUM(G93:G95)","v":0},0,{"$f":"SUM(I93:I95)","v":0}]
[null,null,{"$f":"'Closing S&U'!C128","v":"ARCHITECTURAL/ ENGINEERING/PROFESSIONAL FEES"}]
[{"$f":"A95+1","v":45},".",{"$f":"'Closing S&U'!C129","v":"Architect Fee-Design"},null,{"$f":"'Closing S&U'!E129","v":0},0,0,0,0]
[{"$f":"A98+1","v":46},".",{"$f":"'Closing S&U'!C130","v":"Architect Fee-Inspection"},null,{"$f":"'Closing S&U'!E130","v":0},0,0,0,0]
[47,".",{"$f":"'Closing S&U'!C131","v":"Engineering Fees"},null,{"$f":"'Closing S&U'!E131","v":0},0,0,0,0]
[48,null,{"$f":"'Closing S&U'!C132","v":"Historic Consultant Fees"},null,{"$f":"'Closing S&U'!E132","v":0},0,0,0,0]
[49,null,{"$f":"'Closing S&U'!C133","v":"Solar Consultant Fees"},null,{"$f":"'Closing S&U'!E133","v":0},0,0,0,0]
[50,null,{"$f":"'Closing S&U'!C134","v":"Site Survey"},null,{"$f":"'Closing S&U'!E134","v":0},0,0,0,0]
[51,null,{"$f":"'Closing S&U'!C135","v":0},null,{"$f":"'Closing S&U'!E135","v":0},0,0,0,0]
[52,null,{"$f":"'Closing S&U'!C136","v":0},null,{"$f":"'Closing S&U'!E136","v":0},0,0,0,0]
[53,null,{"$f":"'Closing S&U'!C137","v":0},null,{"$f":"'Closing S&U'!E137","v":0},0,0,0,0]
[54,".",{"$f":"'Closing S&U'!C138","v":0},null,{"$f":"'Closing S&U'!E138","v":0},0,0,0,0]
[null,null,{"$f":"'Closing S&U'!C139","v":"Subtotal"},null,{"$f":"SUM(E98:E107)","v":0},null,{"$f":"SUM(G98:G107)","v":0},{"$f":"SUM(H98:H107)","v":0},{"$f":"SUM(I98:I107)","v":0}]
[null,null,"INTERIM CONSTRUCTION EXPENSE"]
[{"$f":"A107+1","v":55},".",{"$f":"'Closing S&U'!C142","v":"Construction  Loan Origination Fee"},null,{"$f":"'Closing S&U'!E142","v":0},0,0,0,0]
[{"$f":"A110+1","v":56},".",{"$f":"'Closing S&U'!C143","v":"Construction Period Interest"},null,{"$f":"'Closing S&U'!E143","v":0},0,0,0,0]
[57,".",{"$f":"'Closing S&U'!C144","v":"Construction Period Insurance"},null,{"$f":"'Closing S&U'!E144","v":0},0,0,0,0]
[58,".",{"$f":"'Closing S&U'!C145","v":"P&P Bond/Letter of Credit"},null,{"$f":"'Closing S&U'!E145","v":0},0,0,0,0]
[59,".",{"$f":"'Closing S&U'!C146","v":"Construction Lender's Counsel"},null,{"$f":"'Closing S&U'!E146","v":0},0,0,0,0]
[60,".",{"$f":"'Closing S&U'!C147","v":"Taxes During Construction"},null,{"$f":"'Closing S&U'!E147","v":0},0,0,0,0]
[61,".",{"$f":"'Closing S&U'!C148","v":"Bond - Cost of Issuance"},null,{"$f":"'Closing S&U'!E148","v":0},0,0,0,0]
[62,".",{"$f":"'Closing S&U'!C149","v":0},null,{"$f":"'Closing S&U'!E149","v":0},0,0,0,0]
[63,null,{"$f":"'Closing S&U'!C150","v":0},null,{"$f":"'Closing S&U'!E150","v":0},0,0,0,0]
[64,null,{"$f":"'Closing S&U'!C151","v":0},null,{"$f":"'Closing S&U'!E151","v":0},0,0,0,0]
[{"$f":"A119+1","v":65},".",{"$f":"'Closing S&U'!C152","v":0},null,{"$f":"'Closing S&U'!E152","v":0},0,0,0,0]
[null,null,{"$f":"'Closing S&U'!C153","v":"Subtotal"},null,{"$f":"SUM(E110:E120)","v":0},null,{"$f":"SUM(G110:G120)","v":0},{"$f":"SUM(H110:H120)","v":0},{"$f":"SUM(I110:I120)","v":0}]
[null,null,{"$f":"'Closing S&U'!C155","v":"FINANCING FEES AND EXPENSE"}]
[{"$f":"A120+1","v":66},".",{"$f":"'Closing S&U'!C156","v":"Long-Term Loan Origination Fee"},null,{"$f":"'Closing S&U'!E156","v":0},0,0,0,0]
[{"$f":"A123+1","v":67},".",{"$f":"'Closing S&U'!C157","v":"Title Insurance and Record"},null,{"$f":"'Closing S&U'!E157","v":0},0,0,0,0]
[{"$f":"A124+1","v":68},null,{"$f":"'Closing S&U'!C158","v":"Long-Term Lender's Counsel"},null,{"$f":"'Closing S&U'!E158","v":0},0,0,0,0]
[{"$f":"A125+1","v":69},null,{"$f":"'Closing S&U'!C159","v":"Bond - Cost of Issuance"},null,{"$f":"'Closing S&U'!E159","v":0},0,0,0,0]
[{"$f":"A126+1","v":70},".",{"$f":"'Closing S&U'!C160","v":"Upfront MIP Fee"},null,{"$f":"'Closing S&U'!E160","v":0},0,0,0,0]
[71,".",{"$f":"'Closing S&U'!C161","v":"FFB Trustee Fee"},null,{"$f":"'Closing S&U'!E161","v":0},0,0,0,0]
[72,".",{"$f":"'Closing S&U'!C162","v":0},null,{"$f":"'Closing S&U'!E162","v":0},0,0,0,0]
[73,".",{"$f":"'Closing S&U'!C163","v":0},null,{"$f":"'Closing S&U'!E163","v":0},0,0,0,0]
[null,null,{"$f":"'Closing S&U'!C164","v":"Subtotal"},null,{"$f":"SUM(E123:E130)","v":0},null,{"$f":"SUM(G123:G130)","v":0},{"$f":"SUM(H123:H130)","v":0},{"$f":"SUM(I123:I130)","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,{"$f":"'Closing S&U'!C166","v":"OTHER SOFT COSTS"},null," "]
[{"$f":"A130+1","v":74},".",{"$f":"'Closing S&U'!C167","v":"Appraisal"},null,{"$f":"'Closing S&U'!E167","v":0},0,0,0,0]
[{"$f":"A142+1","v":75},".",{"$f":"'Closing S&U'!C168","v":"Market Study"},null,{"$f":"'Closing S&U'!E168","v":0},0,0,0,0]
[76,".",{"$f":"'Closing S&U'!C169","v":"Environmental Report"},null,{"$f":"'Closing S&U'!E169","v":0},0,0,0,0]
[{"$f":"A144+1","v":77},".",{"$f":"'Closing S&U'!C170","v":"Relocation Costs"},null,{"$f":"'Closing S&U'!E170","v":0},0,0,0,0]
[78,".",{"$f":"'Closing S&U'!C171","v":"Borrower Legal Fees"},null,{"$f":"'Closing S&U'!E171","v":0},0,0,0,0]
[79,".",{"$f":"'Closing S&U'!C172","v":"Accounting Fees"},null,{"$f":"'Closing S&U'!E172","v":0},0,0,0,0]
[80,".",{"$f":"'Closing S&U'!C173","v":"NH Housing Lender Inspector"},null,{"$f":"'Closing S&U'!E173","v":0},0,0,0,0]
[81,null,{"$f":"'Closing S&U'!C174","v":"Furnishings, Fixtures and Equipment"},null,{"$f":"'Closing S&U'!E174","v":0},0,0,0,0]
[82,null,{"$f":"'Closing S&U'!C175","v":"Clerk of the Works"},null,{"$f":"'Closing S&U'!E175","v":0},0,0,0,0]
[83,null,{"$f":"'Closing S&U'!C176","v":"Marketing and Lease-up"},null,{"$f":"'Closing S&U'!E176","v":0},0,0,0,0]
[84,null,{"$f":"'Closing S&U'!C177","v":"Building Permits"},null,{"$f":"'Closing S&U'!E177","v":0},0,0,0,0]
[85,null,{"$f":"'Closing S&U'!C178","v":"Other Permits"},null,{"$f":"'Closing S&U'!E178","v":0},0,0,0,0]
[86,null,{"$f":"'Closing S&U'!C179","v":"Impact Fees"},null,{"$f":"'Closing S&U'!E179","v":0},0,0,0,0]
[87,null,{"$f":"'Closing S&U'!C180","v":"Water and Sewer Fees "},null,{"$f":"'Closing S&U'!E180","v":0},0,0,0,0]
[88,null,{"$f":"'Closing S&U'!C181","v":"Soft Cost Contingency"},null,{"$f":"'Closing S&U'!E181","v":0},0,0,0,0]
[89,null,{"$f":"'Closing S&U'!C182","v":0},null,{"$f":"'Closing S&U'!E182","v":0},0,0,0,0]
[90,null,{"$f":"'Closing S&U'!C183","v":0},null,{"$f":"'Closing S&U'!E183","v":0},0,0,0,0]
[91,null,{"$f":"'Closing S&U'!C184","v":0},null,{"$f":"'Closing S&U'!E184","v":0},0,0,0,0]
[92,null,{"$f":"'Closing S&U'!C185","v":0},null,{"$f":"'Closing S&U'!E185","v":0},0,0,0,0]
[null,null,{"$f":"'Closing S&U'!C186","v":"Subtotal"},null,{"$f":"SUM(E142:E160)","v":0},null,{"$f":"SUM(G142:G160)","v":0},{"$f":"SUM(H142:H160)","v":0},0]
[null,null,{"$f":"'Closing S&U'!C190","v":"DEVELOPER FEE"}]
[{"$f":"A160+1","v":93},".",{"$f":"'Closing S&U'!C191","v":"Developer Overhead and Profit"},null,{"$f":"'Closing S&U'!E191","v":0},0,0,0,0]
[{"$f":"A163+1","v":94},".",{"$f":"'Closing S&U'!C192","v":"Development Consultant Fee"},null,{"$f":"'Closing S&U'!E192","v":0},0,0,0,0]
[null,null,{"$f":"'Closing S&U'!C193","v":"Subtotal"},null,{"$f":"SUM(E163:E164)","v":0},null,{"$f":"SUM(G163:G164)","v":0},{"$f":"SUM(H163:H164)","v":0},{"$f":"SUM(I163:I164)","v":0}]
[null,null,{"$f":"'Closing S&U'!C195","v":"SYNDICATION EXPENSES"},null," "]
[{"$f":"A164+1","v":95},".",{"$f":"'Closing S&U'!C196","v":"Syndication Legal"},null,{"$f":"'Closing S&U'!E196","v":0},0,0,0,0]
[{"$f":"A167+1","v":96},".",{"$f":"'Closing S&U'!C197","v":"Syndication Accounting"},null,{"$f":"'Closing S&U'!E197","v":0},0,0,0,0]
[97,".",{"$f":"'Closing S&U'!C198","v":"Syndication Fees"},null,{"$f":"'Closing S&U'!E198","v":0},0,0,0,0]
[98,".",{"$f":"'Closing S&U'!C199","v":"Syndication Consultant"},null,{"$f":"'Closing S&U'!E199","v":0},0,0,0,0]
[99,".",{"$f":"'Closing S&U'!C200","v":"Bridge Loan Origination Fee"},null,{"$f":"'Closing S&U'!E200","v":0},0,0,0,0]
[100,".",{"$f":"'Closing S&U'!C201","v":"Bridge Loan Interest"},null,{"$f":"'Closing S&U'!E201","v":0},0,0,0,0]
[101,".",{"$f":"'Closing S&U'!C202","v":"Investor Servicing (capital)"},null,{"$f":"'Closing S&U'!E202","v":0},0,0,0,0]
[102,".",{"$f":"'Closing S&U'!C203","v":0},null,{"$f":"'Closing S&U'!E203","v":0},0,0,0,0]
[null,null,{"$f":"'Closing S&U'!C204","v":"Subtotal"},null,{"$f":"SUM(E167:E174)","v":0},null,{"$f":"SUM(G167:G174)","v":0},{"$f":"SUM(H167:H174)","v":0},{"$f":"SUM(I167:I174)","v":0}]
[null,null,{"$f":"'Closing S&U'!C206","v":"RESERVES (see NH Housing Underwriting Standards)"}]
[{"$f":"A174+1","v":103},".",{"$f":"'Closing S&U'!C207","v":"Operating Reserve"},null,{"$f":"'Closing S&U'!E207","v":0},0,0,0,0]
[{"$f":"A177+1","v":104},".",{"$f":"'Closing S&U'!C208","v":"FFB Operating Reserve (FFB Transactions only)"},null,{"$f":"'Closing S&U'!E208","v":0},0,0,0,0]
[105,".",{"$f":"'Closing S&U'!C209","v":"Replacement Reserve"},null,{"$f":"'Closing S&U'!E209","v":0},0,0,0,0]
[{"$f":"A177+1","v":104},".",{"$f":"'Closing S&U'!C210","v":"Insurance Escrow"},null,{"$f":"'Closing S&U'!E210","v":0},0,0,0,0]
[105,".",{"$f":"'Closing S&U'!C211","v":"Real Estate Tax Escrow"},null,{"$f":"'Closing S&U'!E211","v":0},0,0,0,0]
[106,null,{"$f":"'Closing S&U'!C212","v":0},null,{"$f":"'Closing S&U'!E212","v":0},0,0,0,0]
[{"$f":"A180+1","v":105},".",{"$f":"'Closing S&U'!C213","v":0},null,{"$f":"'Closing S&U'!E213","v":0},0,0,0,0]
[null,null,{"$f":"'Closing S&U'!C214","v":"Subtotal"},null,{"$f":"SUM(E177:E183)","v":0},null,{"$f":"SUM(G177:G183)","v":0},{"$f":"SUM(H177:H183)","v":0},{"$f":"SUM(I177:I183)","v":0}]
[null,null,{"$f":"'Closing S&U'!C216","v":"PROGRAM FEES"}]
[{"$f":"A183+1","v":106},null,{"$f":"'Closing S&U'!C217","v":"LIHTC Allocation Fee"},null,{"$f":"'Closing S&U'!E217","v":0},0,0,0,0]
[{"$f":"A186+1","v":107},null,{"$f":"'Closing S&U'!C218","v":"LIHTC Upfront Monitoring Fee"},null,{"$f":"'Closing S&U'!E218","v":0},0,0,0,0]
[{"$f":"A187+1","v":108},null,{"$f":"'Closing S&U'!C219","v":"HOME Monitoring Fee"},null,{"$f":"'Closing S&U'!E219","v":0},0,0,0,0]
[109,null,{"$f":"'Closing S&U'!C220","v":"HOME-ARP Monitoring Fee"},null,{"$f":"'Closing S&U'!E220","v":0},0,0,0,0]
[110,null,{"$f":"'Closing S&U'!C221","v":"Housing Trust Fund Monitoring Fee"},null,{"$f":"'Closing S&U'!E221","v":0},0,0,0,0]
[111,null,{"$f":"'Closing S&U'!C222","v":"AHF Monitoring Fee"},null,{"$f":"'Closing S&U'!E222","v":0},0,0,0,0]
[112,null,{"$f":"'Closing S&U'!C223","v":"Loan Application Fee"},null,{"$f":"'Closing S&U'!E223","v":0},0,0,0,0]
[113,null,{"$f":"'Closing S&U'!C224","v":0},null,{"$f":"'Closing S&U'!E224","v":0},0,0,0,0]
[114,null,{"$f":"'Closing S&U'!C225","v":0},null,{"$f":"'Closing S&U'!E225","v":0},0,0,0,0]
[null,null,{"$f":"'Closing S&U'!C226","v":"Subtotal"},null,{"$f":"SUM(E186:E194)","v":0},null,{"$f":"SUM(G186:G194)","v":0},{"$f":"SUM(H186:H194)","v":0},0]
[]
[{"$f":"A183+1","v":106},".","Total Development Cost",null,{"$f":"E$91+E$96+E$108+E$121+E$131+E$161+E$165+E$175+E$184+E$195","v":0},null,{"$f":"G$91+G$96+G$108+G$121+G$131+G$161+G$165+G$175+G$184+G$195","v":0},{"$f":"H$91+H$96+H$108+H$121+H$131+H$161+H$165+H$175+H$184+H$195","v":0},{"$f":"I$91+I$96+I$108+I$121+I$131+I$161+I$165+I$175+I$184+I$195","v":0}]
[{"$f":"A197+1","v":107},null,"TDC Net of Syndication Costs",null,{"$f":"'Closing S&U'!E230","v":0}]
[{"$f":"A198+1","v":108},".","Eligible Basis",null,null,null,{"$f":"G79","v":""}]
[null,null,null,null," ",null,null,{"$f":"IF(G199=\"\",\"\",\"Variance TDC/Basis:\")","v":""},{"$f":"IF(H200=\"\",\"\",E197-(G197+H197+I197))","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":"Dev Team","index":5,"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"}]
[]
[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'!E3=\"\",\"Un-named Project\",+'Project Info'!E3)","v":"Un-named Project"}]
[]
[null,null,"Date:"]
[null,null,null,"(month)","(day)","(year)"]
[]
[null,null,"The applicant hereby certifies that this application is complete and accurate to the best of"]
[null,null,"their knowledge, and that no material misrepresentation is made herein by the applicant.  "]
[null,null,"The  applicant  agrees that this application may be relied upon by  New Hampshire Housing "]
[null,null,"Finance Authority and other funding sources. "]
[]
[null,null,"In the event of any extraordinary circumstances, the applicant  agrees to pay for any reasonable"]
[null,null," legal and third party costs incurred by the Authority which are associated with processing this "]
[null,null,"application."]
[]
[null,null,"By submitting this application, applicant gives permission to New Hampshire Housing Finance Authority "]
[null,null,"and its agents to investigate all representations made and attachments included. This includes permission"]
[null,null,"to access personal and business credit reports. "]
[]
[]
[]
[]
[]
[null,null,null,"Applicant Signature",null,null,"Date"]

{"sheet":"Const S&U","index":6,"n_rows":123,"n_cols":54,"rows_kept":123,"cut":false,"hidden":false,"merged":[]}
["Disbursement Schedule"]
[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","Month 31 Draw","Month 30 Draw","Month 31 Draw","Month 32 Draw","Month 33 Draw","Month 34 Draw","Month 35 Draw","Month 36 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":"D5+E5","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F5:AX5)","v":0},null,{"$f":"C5-AZ5","v":0}]
[{"$f":"'Closing S&U'!C7","v":"LIHTC Equity "},null,{"$f":"'Closing S&U'!G7","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F6:AX6)","v":0},null,0]
[{"$f":"'Closing S&U'!C8","v":"HTC Equity"},null,{"$f":"'Closing S&U'!G8","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,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,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,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,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":"D11+E11","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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C20","v":"NHH Subordinate Loan"},{"$f":"'Closing S&U'!D21","v":0},{"$f":"'Closing S&U'!F21","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C22","v":"NHH Subordinate Loan"},{"$f":"'Closing S&U'!D23","v":0},{"$f":"'Closing S&U'!F23","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C24","v":"NHH Subordinate Loan"},{"$f":"'Closing S&U'!D25","v":0},{"$f":"'Closing S&U'!F25","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C26","v":"Subordinate Loan"},{"$f":"'Closing S&U'!D27","v":0},{"$f":"'Closing S&U'!F27","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C28","v":"Subordinate Loan"},{"$f":"'Closing S&U'!D29","v":0},{"$f":"'Closing S&U'!F29","v":0},null,null,{"$f":"D17+E17","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C30","v":"Subordinate Loan"},{"$f":"'Closing S&U'!D31","v":0},{"$f":"'Closing S&U'!F31","v":0}]
[{"$f":"'Closing S&U'!C35","v":"NH Housing Long-Term Loan"},null,{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C36","v":"Other Long-Term Loan"},{"$f":"'Closing S&U'!D37","v":0},{"$f":"'Closing S&U'!F37","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C38","v":"Other Long-Term Loan"},{"$f":"'Closing S&U'!D39","v":0},{"$f":"'Closing S&U'!F39","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C45","v":"Construction Loan"},{"$f":"'Closing S&U'!D46","v":0},{"$f":"'Closing S&U'!F46","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C48","v":"Other Interim Loan"},{"$f":"'Closing S&U'!D49","v":0},{"$f":"'Closing S&U'!F49","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C51","v":"Tax Credit Bridge Loan"},{"$f":"'Closing S&U'!D52","v":0},{"$f":"'Closing S&U'!F52","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Total Sources of Funds",null,{"$f":"SUM(C5:C24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R5:R24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,{"$f":"SUM(BB5:BB24)","v":0}]
[]
["Uses of Funds:"]
[{"$f":"'Closing S&U'!C115","v":"ACQUISITION "}]
[{"$f":"'Closing S&U'!C116","v":"Land"},null,{"$f":"'Closing S&U'!G116","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F29:AX29)","v":0},null,{"$f":"+C29-AZ29","v":0}]
[{"$f":"'Closing S&U'!C117","v":"Existing Building"},null,{"$f":"'Closing S&U'!G117","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F30:AX30)","v":0},null,{"$f":"+C30-AZ30","v":0}]
[{"$f":"'Closing S&U'!C118","v":"Transfer Tax"},null,{"$f":"'Closing S&U'!G118","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C119","v":0},null,{"$f":"'Closing S&U'!G119","v":0},null,null,{"$f":"D32+E32","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C122","v":"CONSTRUCTION"}]
[{"$f":"'Closing S&U'!C123","v":"Construction Budget"},null,{"$f":"'Closing S&U'!G123","v":0},null,null,{"$f":"+D34+E34","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F34:AX34)","v":0},null,{"$f":"+C34-AZ34","v":0}]
[{"$f":"'Closing S&U'!C124","v":"Construction Contingency"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F35:AX35)","v":0},null,0]
[{"$f":"'Closing S&U'!C125","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C128","v":"ARCHITECTURAL/ ENGINEERING/PROFESSIONAL FEES"}]
[{"$f":"'Closing S&U'!C129","v":"Architect Fee-Design"},null,{"$f":"'Closing S&U'!G129","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F38:AX38)","v":0},null,0]
[{"$f":"'Closing S&U'!C130","v":"Architect Fee-Inspection"},null,{"$f":"'Closing S&U'!G130","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C131","v":"Engineering Fees"},null,{"$f":"'Closing S&U'!G131","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C132","v":"Historic Consultant Fees"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C133","v":"Solar Consultant Fees"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C134","v":"Site Survey"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C135","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C136","v":0},null,{"$f":"'Closing S&U'!G136","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,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":0},null,{"$f":"'Closing S&U'!G137","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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C141","v":"INTERIM CONSTRUCTION EXPENSE"}]
[{"$f":"'Closing S&U'!C142","v":"Construction  Loan Origination Fee"},null,{"$f":"'Closing S&U'!G142","v":0},null,null,{"$f":"+D49+E49","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F49:AX49)","v":0},null,{"$f":"+C49-AZ49","v":0}]
[{"$f":"'Closing S&U'!C143","v":"Construction Period Interest"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F50:AX50)","v":0},null,0]
[{"$f":"'Closing S&U'!C144","v":"Construction Period Insurance"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C145","v":"P&P Bond/Letter of Credit"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C146","v":"Construction Lender's Counsel"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C147","v":"Taxes During Construction"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C148","v":"Bond - Cost of Issuance"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C149","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C150","v":0},null,{"$f":"'Closing S&U'!G150","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C151","v":0},null,{"$f":"'Closing S&U'!G151","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,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":0},null,{"$f":"'Closing S&U'!G152","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C155","v":"FINANCING FEES AND EXPENSE"}]
[{"$f":"'Closing S&U'!C156","v":"Long-Term Loan Origination Fee"},null,{"$f":"'Closing S&U'!G156","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F61:AX61)","v":0},null,{"$f":"+C61-AZ61","v":0}]
[{"$f":"'Closing S&U'!C157","v":"Title Insurance and Record"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F62:AX62)","v":0},null,0]
[{"$f":"'Closing S&U'!C158","v":"Long-Term Lender's Counsel"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C159","v":"Bond - Cost of Issuance"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C160","v":"Upfront MIP Fee"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C161","v":"FFB Trustee Fee"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C162","v":0},null,{"$f":"'Closing S&U'!G162","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C163","v":0},null,{"$f":"'Closing S&U'!G163","v":0},null,null,{"$f":"+D68+E68","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"+C68-AZ68","v":0}]
[{"$f":"'Closing S&U'!C166","v":"OTHER SOFT COSTS"}]
[{"$f":"'Closing S&U'!C167","v":"Appraisal"},null,{"$f":"'Closing S&U'!G167","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F70:AX70)","v":0},null,{"$f":"+C70-AZ70","v":0}]
[{"$f":"'Closing S&U'!C168","v":"Market Study"},null,{"$f":"'Closing S&U'!G168","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F71:AX71)","v":0},null,0]
[{"$f":"'Closing S&U'!C169","v":"Environmental Report"},null,{"$f":"'Closing S&U'!G169","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C170","v":"Relocation Costs"},null,{"$f":"'Closing S&U'!G170","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C171","v":"Borrower Legal Fees"},null,{"$f":"'Closing S&U'!G171","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C172","v":"Accounting Fees"},null,{"$f":"'Closing S&U'!G172","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C173","v":"NH Housing Lender Inspector"},null,{"$f":"'Closing S&U'!G173","v":0},null,null,{"$f":"+D76+E76","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C174","v":"Furnishings, Fixtures and Equipment"},null,{"$f":"'Closing S&U'!G174","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C175","v":"Clerk of the Works"},null,{"$f":"'Closing S&U'!G175","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C176","v":"Marketing and Lease-up"},null,{"$f":"'Closing S&U'!G176","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C177","v":"Building Permits"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F80:AX80)","v":0},null,{"$f":"+C80-AZ80","v":0}]
[{"$f":"'Closing S&U'!C178","v":"Other Permits"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F81:AX81)","v":0},null,{"$f":"+C81-AZ81","v":0}]
[{"$f":"'Closing S&U'!C179","v":"Impact Fees"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F82:AX82)","v":0},null,{"$f":"+C82-AZ82","v":0}]
[{"$f":"'Closing S&U'!C180","v":"Water and Sewer Fees "},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C181","v":"Soft Cost Contingency"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F84:AX84)","v":0},null,{"$f":"+C84-AZ84","v":0}]
[{"$f":"'Closing S&U'!C182","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F85:AX85)","v":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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C184","v":0},null,{"$f":"'Closing S&U'!G184","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C185","v":0},null,{"$f":"'Closing S&U'!G185","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C190","v":"DEVELOPER FEE"}]
[{"$f":"'Closing S&U'!C191","v":"Developer Overhead and Profit"},null,{"$f":"'Closing S&U'!G191","v":0},null,null,{"$f":"D90+E90","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F90:AX90)","v":0},null,{"$f":"+C90-AZ90","v":0}]
[{"$f":"'Closing S&U'!C192","v":"Development Consultant Fee"},null,{"$f":"'Closing S&U'!G192","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F91:AX91)","v":0},null,0]
[{"$f":"'Closing S&U'!C195","v":"SYNDICATION EXPENSES"}]
[{"$f":"'Closing S&U'!C196","v":"Syndication Legal"},null,{"$f":"'Closing S&U'!G196","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C197","v":"Syndication Accounting"},null,{"$f":"'Closing S&U'!G197","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C198","v":"Syndication Fees"},null,{"$f":"'Closing S&U'!G198","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C199","v":"Syndication Consultant"},null,{"$f":"'Closing S&U'!G199","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C200","v":"Bridge Loan Origination Fee"},null,{"$f":"'Closing S&U'!G200","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C201","v":"Bridge Loan Interest"},null,{"$f":"'Closing S&U'!G201","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C202","v":"Investor Servicing (capital)"},null,{"$f":"'Closing S&U'!G202","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C203","v":0},null,{"$f":"'Closing S&U'!G203","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C206","v":"RESERVES (see NH Housing Underwriting Standards)"}]
[{"$f":"'Closing S&U'!C207","v":"Operating Reserve"},null,{"$f":"'Closing S&U'!G207","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F102:AX102)","v":0},null,{"$f":"+C102-AZ102","v":0}]
[{"$f":"'Closing S&U'!C208","v":"FFB Operating Reserve (FFB Transactions only)"},null,{"$f":"'Closing S&U'!G208","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F103:AX103)","v":0},null,{"$f":"+C103-AZ103","v":0}]
[{"$f":"'Closing S&U'!C209","v":"Replacement Reserve"},null,{"$f":"'Closing S&U'!G209","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C210","v":"Insurance Escrow"},null,{"$f":"'Closing S&U'!G210","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C211","v":"Real Estate Tax Escrow"},null,{"$f":"'Closing S&U'!G211","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C212","v":0},null,{"$f":"'Closing S&U'!G212","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C213","v":0},null,{"$f":"'Closing S&U'!G213","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C216","v":"PROGRAM FEES"}]
[{"$f":"'Closing S&U'!C217","v":"LIHTC Allocation Fee"},null,{"$f":"'Closing S&U'!G217","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C218","v":"LIHTC Upfront Monitoring Fee"},null,{"$f":"'Closing S&U'!G218","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C219","v":"HOME Monitoring Fee"},null,{"$f":"'Closing S&U'!G219","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C220","v":"HOME-ARP Monitoring Fee"},null,{"$f":"'Closing S&U'!G220","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C221","v":"Housing Trust Fund Monitoring Fee"},null,{"$f":"'Closing S&U'!G221","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C222","v":"AHF Monitoring Fee"},null,{"$f":"'Closing S&U'!G222","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C223","v":"Loan Application Fee"},null,{"$f":"'Closing S&U'!G223","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C224","v":0},null,{"$f":"'Closing S&U'!G224","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[{"$f":"'Closing S&U'!C225","v":0},null,{"$f":"'Closing S&U'!G225","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Construction Loan Payoff",null,{"$f":"'Closing S&U'!F46","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Bridge Loan Payoff",null,{"$f":"'Closing S&U'!F49","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Total Uses of Funds",null,{"$f":"SUM(C29:C120)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AS29:AS117)","v":0},0,0,0,0,0,null,{"$f":"SUM(AZ29:AZ120)","v":0},null,{"$f":"SUM(BB29:BB120)","v":0}]
[]
["Sources and Uses Check",null,{"$f":"C25-C121","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI25-AI121","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Pro Forma","index":7,"n_rows":222,"n_cols":10,"rows_kept":222,"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,"INCOME:"]
[null,null,null,{"$f":"'Project Info'!D75","v":"Market Rate"},null,{"$f":"SUM('Inc & Exp'!J7:J12)","v":0},{"$f":"F9*(1+'Inc & Exp'!E122)","v":0},{"$f":"G9*(1+'Inc & Exp'!F122)","v":0},{"$f":"H9*(1+'Inc & Exp'!G122)","v":0},{"$f":"I9*(1+'Inc & Exp'!H122)","v":0}]
[null,null,null,{"$f":"'Project Info'!E75","v":"LIHTC 20% AMI/HTF PBV"},null,{"$f":"SUM('Inc & Exp'!J16:J21)","v":0},{"$f":"F10*(1+'Inc & Exp'!E123)","v":0},{"$f":"G10*(1+'Inc & Exp'!F123)","v":0},{"$f":"H10*(1+'Inc & Exp'!G123)","v":0},{"$f":"I10*(1+'Inc & Exp'!H123)","v":0}]
[null,null,null,{"$f":"'Project Info'!F75","v":"LIHTC 30% AMI/HTF PBV"},null,{"$f":"SUM('Inc & Exp'!J25:J30)","v":0},{"$f":"F11*(1+'Inc & Exp'!E124)","v":0},{"$f":"G11*(1+'Inc & Exp'!F124)","v":0},{"$f":"H11*(1+'Inc & Exp'!G124)","v":0},{"$f":"I11*(1+'Inc & Exp'!H124)","v":0}]
[null,null,null,{"$f":"'Project Info'!G75","v":"LIHTC 60% AMI"},null,{"$f":"SUM('Inc & Exp'!J34:J39)","v":0},{"$f":"F12*(1+'Inc & Exp'!E125)","v":0},{"$f":"G12*(1+'Inc & Exp'!F125)","v":0},{"$f":"H12*(1+'Inc & Exp'!G125)","v":0},{"$f":"I12*(1+'Inc & Exp'!H125)","v":0}]
[null,null,null,{"$f":"'Project Info'!H75","v":"LIHTC 70% AMI"},null,{"$f":"SUM('Inc & Exp'!J43:J48)","v":0},{"$f":"F13*(1+'Inc & Exp'!E126)","v":0},{"$f":"G13*(1+'Inc & Exp'!F126)","v":0},{"$f":"H13*(1+'Inc & Exp'!G126)","v":0},{"$f":"I13*(1+'Inc & Exp'!H126)","v":0}]
[null,null,null,{"$f":"'Project Info'!I75","v":"LIHTC 80% AMI"},null,{"$f":"SUM('Inc & Exp'!J56:J61)","v":0},{"$f":"F14*(1+'Inc & Exp'!E127)","v":0},{"$f":"G14*(1+'Inc & Exp'!F127)","v":0},{"$f":"H14*(1+'Inc & Exp'!G127)","v":0},{"$f":"I14*(1+'Inc & Exp'!H127)","v":0}]
[null,null,null,{"$f":"'Project Info'!J75","v":"Income Limit/Program "},null,{"$f":"SUM('Inc & Exp'!J65:J70)","v":0},{"$f":"F15*(1+'Inc & Exp'!E128)","v":0},{"$f":"G15*(1+'Inc & Exp'!F128)","v":0},{"$f":"H15*(1+'Inc & Exp'!G128)","v":0},{"$f":"I15*(1+'Inc & Exp'!H128)","v":0}]
[null,null,null,{"$f":"'Project Info'!K75","v":"Income Limit/Program "},null,{"$f":"SUM('Inc & Exp'!J74:J79)","v":0},{"$f":"F16*(1+'Inc & Exp'!E129)","v":0},{"$f":"G16*(1+'Inc & Exp'!F129)","v":0},{"$f":"H16*(1+'Inc & Exp'!G129)","v":0},{"$f":"I16*(1+'Inc & Exp'!H129)","v":0}]
[null,null,null,{"$f":"'Project Info'!L75","v":"Income Limit/Program "},null,{"$f":"SUM('Inc & Exp'!J82:J87)","v":0},{"$f":"F17*(1+'Inc & Exp'!E130)","v":0},{"$f":"G17*(1+'Inc & Exp'!F130)","v":0},{"$f":"H17*(1+'Inc & Exp'!G130)","v":0},{"$f":"I17*(1+'Inc & Exp'!H130)","v":0}]
[null,null,null,{"$f":"'Project Info'!M75","v":"Income Limit/Program "},null,{"$f":"SUM('Inc & Exp'!J91:J96)","v":0},{"$f":"F18*(1+'Inc & Exp'!E131)","v":0},{"$f":"G18*(1+'Inc & Exp'!F131)","v":0},{"$f":"H18*(1+'Inc & Exp'!G131)","v":0},{"$f":"I18*(1+'Inc & Exp'!H131)","v":0}]
[null,null,"Gross Potential Residential Income",null,null,{"$f":"SUM(F9:F18)","v":0},{"$f":"SUM(G9:G18)","v":0},0,0,0]
[null,null,null,"   Less vacancy",null,{"$f":"(F9*'Inc & Exp'!$D$105)+(F10*'Inc & Exp'!$D$106)+(F11*'Inc & Exp'!$D$107)+(F12*'Inc & Exp'!$D$108)+(F13*'Inc & Exp'!D$109)+(F14*'Inc & Exp'!D$110)+(F15*'Inc & Exp'!D$111)+(F16*'Inc & Exp'!D$112)+(F17*'Inc & Exp'!D$113)+(F18*'Inc & Exp'!D$114)","v":0},{"$f":"(G9*'Inc & Exp'!$E$105)+(G10*'Inc & Exp'!$E$106)+(G11*'Inc & Exp'!$E$107)+(G12*'Inc & Exp'!$E$108)+(G13*'Inc & Exp'!E$109)+(G14*'Inc & Exp'!E$110)+(G15*'Inc & Exp'!E$111)+(G16*'Inc & Exp'!E$112)+(G17*'Inc & Exp'!E$113)+(G18*'Inc & Exp'!E$114)","v":0},{"$f":"(H9*'Inc & Exp'!$F$105)+(H10*'Inc & Exp'!$F$106)+(H11*'Inc & Exp'!$F$107)+(H12*'Inc & Exp'!$F$108)+(H13*'Inc & Exp'!F$109)+(H14*'Inc & Exp'!F$110)+(H15*'Inc & Exp'!F$111)+(H16*'Inc & Exp'!F$112)+(H17*'Inc & Exp'!F$113)+(H18*'Inc & Exp'!F$114)","v":0},{"$f":"(I9*'Inc & Exp'!$G$105)+(I10*'Inc & Exp'!$G$106)+(I11*'Inc & Exp'!$G$107)+(I12*'Inc & Exp'!$G$108)+(I13*'Inc & Exp'!G$109)+(I14*'Inc & Exp'!G$110)+(I15*'Inc & Exp'!G$111)+(I16*'Inc & Exp'!G$112)+(I17*'Inc & Exp'!G$113)+(I18*'Inc & Exp'!G$114)","v":0},{"$f":"(J9*'Inc & Exp'!$H$105)+(J10*'Inc & Exp'!$H$106)+(J11*'Inc & Exp'!$H$107)+(J12*'Inc & Exp'!$H$108)+(J13*'Inc & Exp'!H$109)+(J14*'Inc & Exp'!H$110)+(J15*'Inc & Exp'!H$111)+(J16*'Inc & Exp'!H$112)+(J17*'Inc & Exp'!H$113)+(J18*'Inc & Exp'!H$114)","v":0}]
[null,null,"Effective Gross Residential Income",null,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,null,"Commercial Income",null,{"$f":"'Inc & Exp'!I102","v":0},{"$f":"F22*(1+'Inc & Exp'!E132)","v":0},{"$f":"G22*(1+'Inc & Exp'!F132)","v":0},{"$f":"H22*(1+'Inc & Exp'!G132)","v":0},{"$f":"I22*(1+'Inc & Exp'!H132)","v":0}]
[null,null,null,"   Less vacancy",null,{"$f":"F22*'Inc & Exp'!$D115","v":0},{"$f":"G22*'Inc & Exp'!$E115","v":0},{"$f":"H22*'Inc & Exp'!$F115","v":0},{"$f":"I22*'Inc & Exp'!$G115","v":0},{"$f":"J22*'Inc & Exp'!$H115","v":0}]
[null,null,null,"Net Commercial Income",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,"Effective Rental Income",null,null,{"$f":"F21+F24","v":0},{"$f":"G21+G24","v":0},{"$f":"H21+H24","v":0},{"$f":"I21+I24","v":0},{"$f":"J21+J24","v":0}]
[null,null,null,"Other Income",null,{"$f":"'Inc & Exp'!G117+'Inc & Exp'!G119","v":0},{"$f":"F26*(1+'Inc & Exp'!E133)","v":0},{"$f":"G26*(1+'Inc & Exp'!F133)","v":0},{"$f":"H26*(1+'Inc & Exp'!G133)","v":0},{"$f":"I26*(1+'Inc & Exp'!H133)","v":0}]
[null,null,"Total Gross Income",null,null,{"$f":"F25+F26","v":0},{"$f":"G25+G26","v":0},{"$f":"H25+H26","v":0},{"$f":"I25+I26","v":0},{"$f":"J25+J26","v":0}]
[null,null,null,"Operating Subsidies",null,{"$f":"'Inc & Exp'!C143+'Inc & Exp'!D143","v":0},{"$f":"'Inc & Exp'!C144+'Inc & Exp'!D144","v":0},{"$f":"'Inc & Exp'!C145+'Inc & Exp'!D145","v":0},{"$f":"'Inc & Exp'!C146+'Inc & Exp'!D146","v":0},{"$f":"'Inc & Exp'!C147+'Inc & Exp'!D147","v":0}]
[null,null,null,"Draw on Operating Reserves",null,{"$f":"'Inc & Exp'!E143","v":0},{"$f":"'Inc & Exp'!E144","v":0},{"$f":"'Inc & Exp'!E145","v":0},{"$f":"'Inc & Exp'!E146","v":0},{"$f":"'Inc & Exp'!E147","v":0}]
[null,null,"Total Effective Income",null,null,{"$f":"F27+F28+F29","v":0},{"$f":"G27+G28+G29","v":0},{"$f":"H27+H28+H29","v":0},{"$f":"I27+I28+I29","v":0},{"$f":"J27+J28+J29","v":0}]
[]
[null,null,"EXPENSES:"]
[null,null,null,"Administrative",null,{"$f":"'Inc & Exp'!G173","v":0},{"$f":"F33*(1+'Inc & Exp'!F$218)","v":0},{"$f":"G33*(1+'Inc & Exp'!G217)","v":0},{"$f":"H33*(1+'Inc & Exp'!H217)","v":0},{"$f":"I33*(1+'Inc & Exp'!I217)","v":0}]
[null,null,null,"Maintenance & Repair",null,{"$f":"'Inc & Exp'!G187","v":0},{"$f":"F34*(1+'Inc & Exp'!F$218)","v":0},{"$f":"G34*(1+'Inc & Exp'!G218)","v":0},{"$f":"H34*(1+'Inc & Exp'!H218)","v":0},{"$f":"I34*(1+'Inc & Exp'!I218)","v":0}]
[null,null,null,"Resident Services",null,{"$f":"'Inc & Exp'!G192","v":0},{"$f":"F35*(1+'Inc & Exp'!F$218)","v":0},{"$f":"G35*(1+'Inc & Exp'!G$218)","v":0},{"$f":"H35*(1+'Inc & Exp'!H$218)","v":0},{"$f":"I35*(1+'Inc & Exp'!I$218)","v":0}]
[null,null,null,"Security",null,{"$f":"'Inc & Exp'!G194","v":0},{"$f":"F36*(1+'Inc & Exp'!F$218)","v":0},{"$f":"G36*(1+'Inc & Exp'!G$218)","v":0},{"$f":"H36*(1+'Inc & Exp'!H$218)","v":0},{"$f":"I36*(1+'Inc & Exp'!I$218)","v":0}]
[null,null,null,"Electricity",null,{"$f":"'Inc & Exp'!G196","v":0},{"$f":"F37*(1+'Inc & Exp'!F$218)","v":0},{"$f":"G37*(1+'Inc & Exp'!G$218)","v":0},{"$f":"H37*(1+'Inc & Exp'!H$218)","v":0},{"$f":"I37*(1+'Inc & Exp'!I$218)","v":0}]
[null,null,null,"Gas ",null,{"$f":"'Inc & Exp'!G197","v":0},{"$f":"F38*(1+'Inc & Exp'!F$218)","v":0},{"$f":"G38*(1+'Inc & Exp'!G$218)","v":0},{"$f":"H38*(1+'Inc & Exp'!H$218)","v":0},{"$f":"I38*(1+'Inc & Exp'!I$218)","v":0}]
[null,null,null,"Oil",null,{"$f":"'Inc & Exp'!G198","v":0},{"$f":"F39*(1+'Inc & Exp'!F$218)","v":0},{"$f":"G39*(1+'Inc & Exp'!G$218)","v":0},{"$f":"H39*(1+'Inc & Exp'!H$218)","v":0},{"$f":"I39*(1+'Inc & Exp'!I$218)","v":0}]
[null,null,null,"Water & Sewer",null,{"$f":"'Inc & Exp'!G199","v":0},{"$f":"F40*(1+'Inc & Exp'!F216)","v":0},{"$f":"G40*(1+'Inc & Exp'!G216)","v":0},{"$f":"H40*(1+'Inc & Exp'!H216)","v":0},{"$f":"I40*(1+'Inc & Exp'!I216)","v":0}]
[null,null,null,"Replacement Reserve",null,{"$f":"'Inc & Exp'!G202","v":0},{"$f":"F41*(1+'Inc & Exp'!F218)","v":0},{"$f":"G41*(1+'Inc & Exp'!G218)","v":0},{"$f":"H41*(1+'Inc & Exp'!H218)","v":0},{"$f":"I41*(1+'Inc & Exp'!I218)","v":0}]
[null,null,null,"Real Estate Taxes",null,{"$f":"'Inc & Exp'!G204","v":0},{"$f":"F42*(1+'Inc & Exp'!F217)","v":0},{"$f":"G42*(1+'Inc & Exp'!G217)","v":0},{"$f":"H42*(1+'Inc & Exp'!H217)","v":0},{"$f":"I42*(1+'Inc & Exp'!I217)","v":0}]
[null,null,null,"Other Taxes",null,{"$f":"'Inc & Exp'!G205","v":0},{"$f":"F43*(1+'Inc & Exp'!F$218)","v":0},{"$f":"G43*(1+'Inc & Exp'!G$218)","v":0},{"$f":"H43*(1+'Inc & Exp'!H$218)","v":0},{"$f":"I43*(1+'Inc & Exp'!I$218)","v":0}]
[null,null,null,"Insurance",null,{"$f":"'Inc & Exp'!G206","v":0},{"$f":"F44*(1+'Inc & Exp'!F$218)","v":0},{"$f":"G44*(1+'Inc & Exp'!G$218)","v":0},{"$f":"H44*(1+'Inc & Exp'!H$218)","v":0},{"$f":"I44*(1+'Inc & Exp'!I$218)","v":0}]
[null,null,null,"Other:",{"$f":"IF(+'Inc & Exp'!D208=\"\",\" \",'Inc & Exp'!D208)","v":" "},{"$f":"'Inc & Exp'!G208","v":0},{"$f":"F45*(1+'Inc & Exp'!F$218)","v":0},{"$f":"G45*(1+'Inc & Exp'!G$218)","v":0},{"$f":"H45*(1+'Inc & Exp'!H$218)","v":0},{"$f":"I45*(1+'Inc & Exp'!I$218)","v":0}]
[null,null,"Total Operating Expenses",null,null,{"$f":"SUM(F33:F45)","v":0},{"$f":"SUM(G33:G45)","v":0},{"$f":"SUM(H33:H45)","v":0},{"$f":"SUM(I33:I45)","v":0},{"$f":"SUM(J33:J45)","v":0}]
[]
[null,null,"NET OPERATING INCOME",null,null,{"$f":"F30-F46","v":0},{"$f":"G30-G46","v":0},{"$f":"H30-H46","v":0},{"$f":"I30-I46","v":0},{"$f":"J30-J46","v":0}]
[]
[null,null,null,"Debt Service",null,{"$f":"'Inc & Exp'!$G$234","v":0},{"$f":"'Inc & Exp'!$G$234","v":0},{"$f":"'Inc & Exp'!$G$234","v":0},{"$f":"'Inc & Exp'!$G$234","v":0},{"$f":"'Inc & Exp'!$G$234","v":0}]
[null,null,null,"Debt Service Coverage",null,{"$f":"IF(F50>0,F48/F50,\"\")","v":""},{"$f":"IF(G50>0,G48/G50,\"               \")","v":"               "},{"$f":"IF(H50>0,H48/H50,\"               \")","v":"               "},{"$f":"IF(I50>0,I48/I50,\"               \")","v":"               "},{"$f":"IF(J50>0,J48/J50,\"               \")","v":"               "}]
[null,null,null,"Project Cash Flow",null,{"$f":"F48-F50","v":0},{"$f":"G48-G50","v":0},{"$f":"H48-H50","v":0},{"$f":"I48-I50","v":0},{"$f":"J48-J50","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,"INCOME:"]
[null,null,null,{"$f":"D9","v":"Market Rate"},null,{"$f":"J9*(1+'Inc & Exp'!$I122)","v":0},{"$f":"F63*(1+'Inc & Exp'!$I$122)","v":0},{"$f":"G63*(1+'Inc & Exp'!$I122)","v":0},{"$f":"H63*(1+'Inc & Exp'!$I122)","v":0},{"$f":"I63*(1+'Inc & Exp'!$I122)","v":0}]
[null,null,null,"LIHTC 20% AMI/HTF PBV",null,{"$f":"J10*(1+'Inc & Exp'!$I123)","v":0},{"$f":"F64*(1+'Inc & Exp'!$I123)","v":0},{"$f":"G64*(1+'Inc & Exp'!$I123)","v":0},{"$f":"H64*(1+'Inc & Exp'!$I123)","v":0},{"$f":"I64*(1+'Inc & Exp'!$I123)","v":0}]
[null,null,null,"LIHTC 30% AMI/HTF PBV",null,{"$f":"J11*(1+'Inc & Exp'!$I124)","v":0},{"$f":"F65*(1+'Inc & Exp'!$I124)","v":0},{"$f":"G65*(1+'Inc & Exp'!$I124)","v":0},{"$f":"H65*(1+'Inc & Exp'!$I124)","v":0},{"$f":"I65*(1+'Inc & Exp'!$I124)","v":0}]
[null,null,null,"LIHTC 60% AMI",null,{"$f":"J12*(1+'Inc & Exp'!$I125)","v":0},{"$f":"F66*(1+'Inc & Exp'!$I125)","v":0},{"$f":"G66*(1+'Inc & Exp'!$I125)","v":0},{"$f":"H66*(1+'Inc & Exp'!$I125)","v":0},{"$f":"I66*(1+'Inc & Exp'!$I125)","v":0}]
[null,null,null,"LIHTC 70% AMI",null,{"$f":"J13*(1+'Inc & Exp'!$I126)","v":0},{"$f":"F67*(1+'Inc & Exp'!$I126)","v":0},{"$f":"G67*(1+'Inc & Exp'!$I126)","v":0},{"$f":"H67*(1+'Inc & Exp'!$I126)","v":0},{"$f":"I67*(1+'Inc & Exp'!$I126)","v":0}]
[null,null,null,"LIHTC 80% AMI",null,{"$f":"J14*(1+'Inc & Exp'!$I127)","v":0},{"$f":"F68*(1+'Inc & Exp'!$I127)","v":0},{"$f":"G68*(1+'Inc & Exp'!$I127)","v":0},{"$f":"H68*(1+'Inc & Exp'!$I127)","v":0},{"$f":"I68*(1+'Inc & Exp'!$I127)","v":0}]
[null,null,null,"Income Limit/Program ",null,{"$f":"J15*(1+'Inc & Exp'!$I128)","v":0},{"$f":"F69*(1+'Inc & Exp'!$I128)","v":0},{"$f":"G69*(1+'Inc & Exp'!$I128)","v":0},{"$f":"H69*(1+'Inc & Exp'!$I128)","v":0},{"$f":"I69*(1+'Inc & Exp'!$I128)","v":0}]
[null,null,null,"Income Limit/Program ",null,{"$f":"J16*(1+'Inc & Exp'!$I129)","v":0},{"$f":"F70*(1+'Inc & Exp'!$I129)","v":0},{"$f":"G70*(1+'Inc & Exp'!$I129)","v":0},{"$f":"H70*(1+'Inc & Exp'!$I129)","v":0},{"$f":"I70*(1+'Inc & Exp'!$I129)","v":0}]
[null,null,null,"Income Limit/Program ",null,{"$f":"J17*(1+'Inc & Exp'!$I130)","v":0},{"$f":"F71*(1+'Inc & Exp'!$I130)","v":0},{"$f":"G71*(1+'Inc & Exp'!$I130)","v":0},{"$f":"H71*(1+'Inc & Exp'!$I130)","v":0},{"$f":"I71*(1+'Inc & Exp'!$I130)","v":0}]
[null,null,null,"Income Limit/Program ",null,{"$f":"J18*(1+'Inc & Exp'!$I131)","v":0},{"$f":"F72*(1+'Inc & Exp'!$I131)","v":0},{"$f":"G72*(1+'Inc & Exp'!$I131)","v":0},{"$f":"H72*(1+'Inc & Exp'!$I131)","v":0},{"$f":"I72*(1+'Inc & Exp'!$I131)","v":0}]
[null,null,"Gross Potential Income",null,null,{"$f":"SUM(F63:F72)","v":0},{"$f":"SUM(G63:G72)","v":0},0,0,0]
[null,null,null,"   Less vacancy",null,{"$f":"(F63*'Inc & Exp'!$I$105)+(F64*'Inc & Exp'!$I$106)+(F65*'Inc & Exp'!$I$107)+(F66*'Inc & Exp'!$I$108)+(F67*'Inc & Exp'!$I$109)+(F68*'Inc & Exp'!$I$110)+(F69*'Inc & Exp'!$I$111)+(F70*'Inc & Exp'!$I$112)+(F71*'Inc & Exp'!$I$113)+(F72*'Inc & Exp'!$I$114)","v":0},{"$f":"(G63*'Inc & Exp'!$I$105)+(G64*'Inc & Exp'!$I$106)+(G65*'Inc & Exp'!$I$107)+(G66*'Inc & Exp'!$I$108)+(G67*'Inc & Exp'!$I$109)+(G68*'Inc & Exp'!$I$110)+(G69*'Inc & Exp'!$I$111)+(G70*'Inc & Exp'!$I$112)+(G71*'Inc & Exp'!$I$113)+(G72*'Inc & Exp'!$I$114)","v":0},{"$f":"(H63*'Inc & Exp'!$I$105)+(H64*'Inc & Exp'!$I$106)+(H65*'Inc & Exp'!$I$107)+(H66*'Inc & Exp'!$I$108)+(H67*'Inc & Exp'!$I$109)+(H68*'Inc & Exp'!$I$110)+(H69*'Inc & Exp'!$I$111)+(H70*'Inc & Exp'!$I$112)+(H71*'Inc & Exp'!$I$113)+(H72*'Inc & Exp'!$I$114)","v":0},{"$f":"(I63*'Inc & Exp'!$I$105)+(I64*'Inc & Exp'!$I$106)+(I65*'Inc & Exp'!$I$107)+(I66*'Inc & Exp'!$I$108)+(I67*'Inc & Exp'!$I$109)+(I68*'Inc & Exp'!$I$110)+(I69*'Inc & Exp'!$I$111)+(I70*'Inc & Exp'!$I$112)+(I71*'Inc & Exp'!$I$113)+(I72*'Inc & Exp'!$I$114)","v":0},{"$f":"(J63*'Inc & Exp'!$I$105)+(J64*'Inc & Exp'!$I$106)+(J65*'Inc & Exp'!$I$107)+(J66*'Inc & Exp'!$I$108)+(J67*'Inc & Exp'!$I$109)+(J68*'Inc & Exp'!$I$110)+(J69*'Inc & Exp'!$I$111)+(J70*'Inc & Exp'!$I$112)+(J71*'Inc & Exp'!$I$113)+(J72*'Inc & Exp'!$I$114)","v":0}]
[null,null,"Effective Gross Residential Income",null,null,{"$f":"F73-F74","v":0},{"$f":"G73-G74","v":0},{"$f":"H73-H74","v":0},0,0]
[null,null,null,"Commercial Income",null,{"$f":"J22*(1+'Inc & Exp'!I132)","v":0},{"$f":"F76*(1+'Inc & Exp'!$I$132)","v":0},{"$f":"G76*(1+'Inc & Exp'!$I$132)","v":0},{"$f":"H76*(1+'Inc & Exp'!$I$132)","v":0},{"$f":"I76*(1+'Inc & Exp'!$I$132)","v":0}]
[null,null,null,"   Less vacancy",null,{"$f":"F76*'Inc & Exp'!$I$115","v":0},{"$f":"G76*'Inc & Exp'!$I$115","v":0},{"$f":"H76*'Inc & Exp'!$I$115","v":0},{"$f":"I76*'Inc & Exp'!$I$115","v":0},{"$f":"J76*'Inc & Exp'!$I$115","v":0}]
[null,null,null,"Net Commercial Income",null,{"$f":"F76-F77","v":0},{"$f":"G76-G77","v":0},{"$f":"H76-H77","v":0},{"$f":"I76-I77","v":0},{"$f":"J76-J77","v":0}]
[null,null,"Effective Rental Income",null,null,{"$f":"F75+F78","v":0},{"$f":"G75+G78","v":0},{"$f":"H75+H78","v":0},{"$f":"I75+I78","v":0},{"$f":"J75+J78","v":0}]
[null,null,null,"Other Income",null,{"$f":"J26*(1+'Inc & Exp'!I133)","v":0},{"$f":"F80*(1+'Inc & Exp'!$I$133)","v":0},{"$f":"G80*(1+'Inc & Exp'!$I$133)","v":0},{"$f":"H80*(1+'Inc & Exp'!$I$133)","v":0},{"$f":"I80*(1+'Inc & Exp'!$I$133)","v":0}]
[null,null,"Total Gross Income",null,null,{"$f":"F79+F80","v":0},{"$f":"G79+G80","v":0},{"$f":"H79+H80","v":0},{"$f":"I79+I80","v":0},{"$f":"J79+J80","v":0}]
[null,null,null,"Operating Subsidies",null,{"$f":"'Inc & Exp'!C148+'Inc & Exp'!D148","v":0},{"$f":"'Inc & Exp'!C149+'Inc & Exp'!D149","v":0},{"$f":"'Inc & Exp'!C150+'Inc & Exp'!D150","v":0},{"$f":"'Inc & Exp'!C151+'Inc & Exp'!D151","v":0},{"$f":"'Inc & Exp'!C152+'Inc & Exp'!D152","v":0}]
[null,null,null,"Draw on Operating Reserves",null,{"$f":"'Inc & Exp'!E148","v":0},{"$f":"'Inc & Exp'!E149","v":0},{"$f":"'Inc & Exp'!E150","v":0},{"$f":"'Inc & Exp'!E151","v":0},{"$f":"'Inc & Exp'!E152","v":0}]
[null,null,"Total Effective Income",null,null,{"$f":"F81+F82+F83","v":0},{"$f":"G81+G82+G83","v":0},{"$f":"H81+H82+H83","v":0},{"$f":"I81+I82+I83","v":0},{"$f":"J81+J82+J83","v":0}]
[]
[null,null,"EXPENSES:"]
[null,null,null,"Administrative",null,{"$f":"J33*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F87*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G87*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H87*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I87*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Maintenance & Repair",null,{"$f":"J34*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F88*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G88*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H88*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I88*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Resident Services",null,{"$f":"J35*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F89*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G89*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H89*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I89*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Security",null,{"$f":"J36*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F90*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G90*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H90*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I90*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Electricity",null,{"$f":"J37*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F91*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G91*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H91*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I91*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Gas ",null,{"$f":"J38*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F92*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G92*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H92*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I92*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Oil",null,{"$f":"J39*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F93*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G93*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H93*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I93*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Water & Sewer",null,{"$f":"J40*(1+'Inc & Exp'!$I$216)","v":0},{"$f":"F94*(1+'Inc & Exp'!$I$216)","v":0},{"$f":"G94*(1+'Inc & Exp'!$I$216)","v":0},{"$f":"H94*(1+'Inc & Exp'!$I$216)","v":0},{"$f":"I94*(1+'Inc & Exp'!$I$216)","v":0}]
[null,null,null,"Replacement Reserve",null,{"$f":"J41*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F95*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G95*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H95*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I95*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Real Estate Taxes",null,{"$f":"J42*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"F96*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"G96*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"H96*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"I96*(1+'Inc & Exp'!$I$217)","v":0}]
[null,null,null,"Other Taxes",null,{"$f":"J43*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"F97*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"G97*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"H97*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"I97*(1+'Inc & Exp'!$I$217)","v":0}]
[null,null,null,"Insurance",null,{"$f":"J44*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F98*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G98*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H98*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I98*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Other:",null,{"$f":"J45*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F99*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G99*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H99*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I99*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,"Total Operating Expenses",null,null,{"$f":"SUM(F87:F99)","v":0},{"$f":"SUM(G87:G99)","v":0},{"$f":"SUM(H87:H99)","v":0},{"$f":"SUM(I87:I99)","v":0},{"$f":"SUM(J87:J99)","v":0}]
[]
[null,null,"NET OPERATING INCOME",null,null,{"$f":"F84-F100","v":0},{"$f":"G84-G100","v":0},{"$f":"H84-H100","v":0},{"$f":"I84-I100","v":0},{"$f":"J84-J100","v":0}]
[]
[null,null,null,"Debt Service",null,{"$f":"'Inc & Exp'!$G$234","v":0},{"$f":"'Inc & Exp'!$G$234","v":0},{"$f":"'Inc & Exp'!$G$234","v":0},{"$f":"'Inc & Exp'!$G$234","v":0},{"$f":"'Inc & Exp'!$G$234","v":0}]
[null,null,null,"Debt Service Coverage",null,{"$f":"IF(F104>0,F102/F104,\"               \")","v":"               "},{"$f":"IF(G104>0,G102/G104,\"               \")","v":"               "},{"$f":"IF(H104>0,H102/H104,\"               \")","v":"               "},{"$f":"IF(I104>0,I102/I104,\"               \")","v":"               "},{"$f":"IF(J104>0,J102/J104,\"               \")","v":"               "}]
[null,null,null,"Project Cash Flow",null,{"$f":"F102-F104","v":0},{"$f":"G102-G104","v":0},{"$f":"H102-H104","v":0},{"$f":"I102-I104","v":0},{"$f":"J102-J104","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,"Ten-year projected cash flow",{"$f":"SUM(F106:J106,F52:J52)","v":0}]
[]
[]
[]
[null,{"$f":"B57","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,"INCOME:"]
[null,null,null,{"$f":"D9","v":"Market Rate"},null,{"$f":"J63*(1+'Inc & Exp'!$I122)","v":0},{"$f":"F119*(1+'Inc & Exp'!$I122)","v":0},{"$f":"G119*(1+'Inc & Exp'!$I122)","v":0},{"$f":"H119*(1+'Inc & Exp'!$I122)","v":0},{"$f":"I119*(1+'Inc & Exp'!$I122)","v":0}]
[null,null,null,"LIHTC 20% AMI/HTF PBV",null,{"$f":"J64*(1+'Inc & Exp'!$I123)","v":0},{"$f":"F120*(1+'Inc & Exp'!$I123)","v":0},{"$f":"G120*(1+'Inc & Exp'!$I123)","v":0},{"$f":"H120*(1+'Inc & Exp'!$I123)","v":0},{"$f":"I120*(1+'Inc & Exp'!$I123)","v":0}]
[null,null,null,"LIHTC 30% AMI/HTF PBV",null,{"$f":"J65*(1+'Inc & Exp'!$I124)","v":0},{"$f":"F121*(1+'Inc & Exp'!$I124)","v":0},{"$f":"G121*(1+'Inc & Exp'!$I124)","v":0},{"$f":"H121*(1+'Inc & Exp'!$I124)","v":0},{"$f":"I121*(1+'Inc & Exp'!$I124)","v":0}]
[null,null,null,"LIHTC 60% AMI",null,{"$f":"J66*(1+'Inc & Exp'!$I125)","v":0},{"$f":"F122*(1+'Inc & Exp'!$I125)","v":0},{"$f":"G122*(1+'Inc & Exp'!$I125)","v":0},{"$f":"H122*(1+'Inc & Exp'!$I125)","v":0},{"$f":"I122*(1+'Inc & Exp'!$I125)","v":0}]
[null,null,null,"LIHTC 70% AMI",null,{"$f":"J67*(1+'Inc & Exp'!$I126)","v":0},{"$f":"F123*(1+'Inc & Exp'!$I126)","v":0},{"$f":"G123*(1+'Inc & Exp'!$I126)","v":0},{"$f":"H123*(1+'Inc & Exp'!$I126)","v":0},{"$f":"I123*(1+'Inc & Exp'!$I126)","v":0}]
[null,null,null,"LIHTC 80% AMI",null,{"$f":"J68*(1+'Inc & Exp'!$I127)","v":0},{"$f":"F124*(1+'Inc & Exp'!$I127)","v":0},{"$f":"G124*(1+'Inc & Exp'!$I127)","v":0},{"$f":"H124*(1+'Inc & Exp'!$I127)","v":0},{"$f":"I124*(1+'Inc & Exp'!$I127)","v":0}]
[null,null,null,"Income Limit/Program ",null,{"$f":"J69*(1+'Inc & Exp'!$I128)","v":0},{"$f":"F125*(1+'Inc & Exp'!$I128)","v":0},{"$f":"G125*(1+'Inc & Exp'!$I128)","v":0},{"$f":"H125*(1+'Inc & Exp'!$I128)","v":0},{"$f":"I125*(1+'Inc & Exp'!$I128)","v":0}]
[null,null,null,"Income Limit/Program ",null,{"$f":"J70*(1+'Inc & Exp'!$I129)","v":0},{"$f":"F126*(1+'Inc & Exp'!$I129)","v":0},{"$f":"G126*(1+'Inc & Exp'!$I129)","v":0},{"$f":"H126*(1+'Inc & Exp'!$I129)","v":0},{"$f":"I126*(1+'Inc & Exp'!$I129)","v":0}]
[null,null,null,"Income Limit/Program ",null,{"$f":"J71*(1+'Inc & Exp'!$I130)","v":0},{"$f":"F127*(1+'Inc & Exp'!$I130)","v":0},{"$f":"G127*(1+'Inc & Exp'!$I130)","v":0},{"$f":"H127*(1+'Inc & Exp'!$I130)","v":0},{"$f":"I127*(1+'Inc & Exp'!$I130)","v":0}]
[null,null,null,"Income Limit/Program ",null,{"$f":"J72*(1+'Inc & Exp'!$I131)","v":0},{"$f":"F128*(1+'Inc & Exp'!$I131)","v":0},{"$f":"G128*(1+'Inc & Exp'!$I131)","v":0},{"$f":"H128*(1+'Inc & Exp'!$I131)","v":0},{"$f":"I128*(1+'Inc & Exp'!$I131)","v":0}]
[null,null,"Gross Potential Income",null,null,{"$f":"SUM(F119:F128)","v":0},{"$f":"SUM(G119:G128)","v":0},{"$f":"SUM(H119:H128)","v":0},{"$f":"SUM(I119:I128)","v":0},{"$f":"SUM(J119:J128)","v":0}]
[null,null,null,"   Less vacancy",null,{"$f":"(F119*'Inc & Exp'!$I$105)+(F120*'Inc & Exp'!$I$106)+(F121*'Inc & Exp'!$I$107)+(F122*'Inc & Exp'!$I$108)+(F123*'Inc & Exp'!$I$109)+(F124*'Inc & Exp'!$I$110)+(F125*'Inc & Exp'!$I$111)+(F126*'Inc & Exp'!$I$112)+(F127*'Inc & Exp'!$I$113)+(F128*'Inc & Exp'!$I$114)","v":0},{"$f":"(G119*'Inc & Exp'!$I$105)+(G120*'Inc & Exp'!$I$106)+(G121*'Inc & Exp'!$I$107)+(G122*'Inc & Exp'!$I$108)+(G123*'Inc & Exp'!$I$109)+(G124*'Inc & Exp'!$I$110)+(G125*'Inc & Exp'!$I$111)+(G126*'Inc & Exp'!$I$112)+(G127*'Inc & Exp'!$I$113)+(G128*'Inc & Exp'!$I$114)","v":0},{"$f":"(H119*'Inc & Exp'!$I$105)+(H120*'Inc & Exp'!$I$106)+(H121*'Inc & Exp'!$I$107)+(H122*'Inc & Exp'!$I$108)+(H123*'Inc & Exp'!$I$109)+(H124*'Inc & Exp'!$I$110)+(H125*'Inc & Exp'!$I$111)+(H126*'Inc & Exp'!$I$112)+(H127*'Inc & Exp'!$I$113)+(H128*'Inc & Exp'!$I$114)","v":0},{"$f":"(I119*'Inc & Exp'!$I$105)+(I120*'Inc & Exp'!$I$106)+(I121*'Inc & Exp'!$I$107)+(I122*'Inc & Exp'!$I$108)+(I123*'Inc & Exp'!$I$109)+(I124*'Inc & Exp'!$I$110)+(I125*'Inc & Exp'!$I$111)+(I126*'Inc & Exp'!$I$112)+(I127*'Inc & Exp'!$I$113)+(I128*'Inc & Exp'!$I$114)","v":0},{"$f":"(J119*'Inc & Exp'!$I$105)+(J120*'Inc & Exp'!$I$106)+(J121*'Inc & Exp'!$I$107)+(J122*'Inc & Exp'!$I$108)+(J123*'Inc & Exp'!$I$109)+(J124*'Inc & Exp'!$I$110)+(J125*'Inc & Exp'!$I$111)+(J126*'Inc & Exp'!$I$112)+(J127*'Inc & Exp'!$I$113)+(J128*'Inc & Exp'!$I$114)","v":0}]
[null,null,"Effective Gross Residential Income",null,null,{"$f":"F129-F130","v":0},{"$f":"G129-G130","v":0},{"$f":"H129-H130","v":0},{"$f":"I129-I130","v":0},{"$f":"J129-J130","v":0}]
[null,null,null,"Commercial Income",null,{"$f":"J76*(1+'Inc & Exp'!$I$132)","v":0},{"$f":"F132*(1+'Inc & Exp'!$I$132)","v":0},{"$f":"G132*(1+'Inc & Exp'!$I$132)","v":0},{"$f":"H132*(1+'Inc & Exp'!$I$132)","v":0},{"$f":"I132*(1+'Inc & Exp'!$I$132)","v":0}]
[null,null,null,"   Less vacancy",null,{"$f":"F132*'Inc & Exp'!$I$115","v":0},{"$f":"G132*'Inc & Exp'!$I$115","v":0},{"$f":"H132*'Inc & Exp'!$I$115","v":0},{"$f":"I132*'Inc & Exp'!$I$115","v":0},{"$f":"J132*'Inc & Exp'!$I$115","v":0}]
[null,null,null,"Net Commercial Income",null,{"$f":"F132-F133","v":0},{"$f":"G132-G133","v":0},{"$f":"H132-H133","v":0},{"$f":"I132-I133","v":0},{"$f":"J132-J133","v":0}]
[null,null,"Effective Rental Income",null,null,{"$f":"F131+F134","v":0},{"$f":"G131+G134","v":0},{"$f":"H131+H134","v":0},{"$f":"I131+I134","v":0},{"$f":"J131+J134","v":0}]
[null,null,null,"Other Income",null,{"$f":"J80*(1+'Inc & Exp'!$I$133)","v":0},{"$f":"F136*(1+'Inc & Exp'!$I$133)","v":0},{"$f":"G136*(1+'Inc & Exp'!$I$133)","v":0},{"$f":"H136*(1+'Inc & Exp'!$I$133)","v":0},{"$f":"I136*(1+'Inc & Exp'!$I$133)","v":0}]
[null,null,"Total Gross Income",null,null,{"$f":"F135+F136","v":0},{"$f":"G135+G136","v":0},{"$f":"H135+H136","v":0},{"$f":"I135+I136","v":0},{"$f":"J135+J136","v":0}]
[null,null,null,"Operating Subsidies",null,{"$f":"'Inc & Exp'!G143+'Inc & Exp'!H143","v":0},{"$f":"'Inc & Exp'!G144+'Inc & Exp'!H144","v":0},{"$f":"'Inc & Exp'!G145+'Inc & Exp'!H145","v":0},{"$f":"'Inc & Exp'!G146+'Inc & Exp'!H146","v":0},{"$f":"'Inc & Exp'!G147+'Inc & Exp'!H147","v":0}]
[null,null,null,"Draw on Operating Reserves",null,{"$f":"'Inc & Exp'!I143","v":0},{"$f":"'Inc & Exp'!I144","v":0},{"$f":"'Inc & Exp'!I145","v":0},{"$f":"'Inc & Exp'!I146","v":0},{"$f":"'Inc & Exp'!I147","v":0}]
[null,null,"Total Effective Income",null,null,{"$f":"F137+F138+F139","v":0},{"$f":"G137+G138+G139","v":0},{"$f":"H137+H138+H139","v":0},{"$f":"I137+I138+I139","v":0},{"$f":"J137+J138+J139","v":0}]
[]
[null,null,"EXPENSES:"]
[null,null,null,"Administrative",null,{"$f":"J87*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F143*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G143*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H143*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I143*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Maintenance & Repair",null,{"$f":"J88*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F144*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G144*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H144*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I144*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Resident Services",null,{"$f":"J89*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F145*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G145*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H145*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I145*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Security",null,{"$f":"J90*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F146*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G146*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H146*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I146*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Electricity",null,{"$f":"J91*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F147*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G147*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H147*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I147*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Gas ",null,{"$f":"J92*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F148*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G148*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H148*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I148*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Oil",null,{"$f":"J93*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F149*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G149*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H149*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I149*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Water & Sewer",null,{"$f":"J94*(1+'Inc & Exp'!$I$216)","v":0},{"$f":"F150*(1+'Inc & Exp'!$I$216)","v":0},{"$f":"G150*(1+'Inc & Exp'!$I$216)","v":0},{"$f":"H150*(1+'Inc & Exp'!$I$216)","v":0},{"$f":"I150*(1+'Inc & Exp'!$I$216)","v":0}]
[null,null,null,"Replacement Reserve",null,{"$f":"J95*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F151*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G151*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H151*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I151*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Real Estate Taxes",null,{"$f":"J96*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"F152*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"G152*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"H152*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"I152*(1+'Inc & Exp'!$I$217)","v":0}]
[null,null,null,"Other Taxes",null,{"$f":"J97*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"F153*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"G153*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"H153*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"I153*(1+'Inc & Exp'!$I$217)","v":0}]
[null,null,null,"Insurance",null,{"$f":"J98*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F154*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G154*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H154*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I154*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Other:",{"$f":"IF(+'LIHTC Info'!D48=\"\",\" \",'LIHTC Info'!D48)","v":" "},{"$f":"J99*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F155*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G155*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H155*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I155*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,"Total Operating Expenses",null,null,{"$f":"SUM(F143:F155)","v":0},{"$f":"SUM(G143:G155)","v":0},{"$f":"SUM(H143:H155)","v":0},{"$f":"SUM(I143:I155)","v":0},{"$f":"SUM(J143:J155)","v":0}]
[]
[null,null,"NET OPERATING INCOME",null,null,{"$f":"F140-F156","v":0},{"$f":"G140-G156","v":0},{"$f":"H140-H156","v":0},{"$f":"I140-I156","v":0},{"$f":"J140-J156","v":0}]
[]
[null,null,null,"Debt Service",null,{"$f":"'Inc & Exp'!$G$234","v":0},{"$f":"'Inc & Exp'!$G$234","v":0},{"$f":"'Inc & Exp'!$G$234","v":0},{"$f":"'Inc & Exp'!$G$234","v":0},{"$f":"'Inc & Exp'!$G$234","v":0}]
[null,null,null,"Debt Service Coverage",null,{"$f":"IF(F160>0,F158/F160,\"               \")","v":"               "},{"$f":"IF(G160>0,G158/G160,\"               \")","v":"               "},{"$f":"IF(H160>0,H158/H160,\"               \")","v":"               "},{"$f":"IF(I160>0,I158/I160,\"               \")","v":"               "},{"$f":"IF(J160>0,J158/J160,\"               \")","v":"               "}]
[null,null,null,"Project Cash Flow",null,{"$f":"F158-F160","v":0},{"$f":"G158-G160","v":0},{"$f":"H158-H160","v":0},{"$f":"I158-I160","v":0},{"$f":"J158-J160","v":0}]
[null,null,null,"Operating Deficit",null,{"$f":"IF(F162>0,0,F162)","v":0},{"$f":"IF(G162>0,0,G162)","v":0},{"$f":"IF(H162>0,0,H162)","v":0},0,0]
[]
[]
[]
[]
[]
[null,{"$f":"B113","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,"INCOME:"]
[null,null,null,{"$f":"D119","v":"Market Rate"},null,{"$f":"J119*(1+'Inc & Exp'!$I122)","v":0},{"$f":"F175*(1+'Inc & Exp'!$I122)","v":0},{"$f":"G175*(1+'Inc & Exp'!$I122)","v":0},{"$f":"H175*(1+'Inc & Exp'!$I122)","v":0},{"$f":"I175*(1+'Inc & Exp'!$I122)","v":0}]
[null,null,null,"LIHTC 20% AMI/HTF PBV",null,{"$f":"J120*(1+'Inc & Exp'!$I123)","v":0},{"$f":"F176*(1+'Inc & Exp'!$I123)","v":0},{"$f":"G176*(1+'Inc & Exp'!$I123)","v":0},{"$f":"H176*(1+'Inc & Exp'!$I123)","v":0},{"$f":"I176*(1+'Inc & Exp'!$I123)","v":0}]
[null,null,null,"LIHTC 30% AMI/HTF PBV",null,{"$f":"J121*(1+'Inc & Exp'!$I124)","v":0},{"$f":"F177*(1+'Inc & Exp'!$I124)","v":0},{"$f":"G177*(1+'Inc & Exp'!$I124)","v":0},{"$f":"H177*(1+'Inc & Exp'!$I124)","v":0},{"$f":"I177*(1+'Inc & Exp'!$I124)","v":0}]
[null,null,null,"LIHTC 60% AMI",null,{"$f":"J122*(1+'Inc & Exp'!$I125)","v":0},{"$f":"F178*(1+'Inc & Exp'!$I125)","v":0},{"$f":"G178*(1+'Inc & Exp'!$I125)","v":0},{"$f":"H178*(1+'Inc & Exp'!$I125)","v":0},{"$f":"I178*(1+'Inc & Exp'!$I125)","v":0}]
[null,null,null,"LIHTC 70% AMI",null,{"$f":"J123*(1+'Inc & Exp'!$I126)","v":0},{"$f":"F179*(1+'Inc & Exp'!$I126)","v":0},{"$f":"G179*(1+'Inc & Exp'!$I126)","v":0},{"$f":"H179*(1+'Inc & Exp'!$I126)","v":0},{"$f":"I179*(1+'Inc & Exp'!$I126)","v":0}]
[null,null,null,"LIHTC 80% AMI",null,{"$f":"J124*(1+'Inc & Exp'!$I127)","v":0},{"$f":"F180*(1+'Inc & Exp'!$I127)","v":0},{"$f":"G180*(1+'Inc & Exp'!$I127)","v":0},{"$f":"H180*(1+'Inc & Exp'!$I127)","v":0},{"$f":"I180*(1+'Inc & Exp'!$I127)","v":0}]
[null,null,null,"Income Limit/Program ",null,{"$f":"J125*(1+'Inc & Exp'!$I128)","v":0},{"$f":"F181*(1+'Inc & Exp'!$I128)","v":0},{"$f":"G181*(1+'Inc & Exp'!$I128)","v":0},{"$f":"H181*(1+'Inc & Exp'!$I128)","v":0},{"$f":"I181*(1+'Inc & Exp'!$I128)","v":0}]
[null,null,null,"Income Limit/Program ",null,{"$f":"J126*(1+'Inc & Exp'!$I129)","v":0},{"$f":"F182*(1+'Inc & Exp'!$I129)","v":0},{"$f":"G182*(1+'Inc & Exp'!$I129)","v":0},{"$f":"H182*(1+'Inc & Exp'!$I129)","v":0},{"$f":"I182*(1+'Inc & Exp'!$I129)","v":0}]
[null,null,null,"Income Limit/Program ",null,{"$f":"J127*(1+'Inc & Exp'!$I130)","v":0},{"$f":"F183*(1+'Inc & Exp'!$I130)","v":0},{"$f":"G183*(1+'Inc & Exp'!$I130)","v":0},{"$f":"H183*(1+'Inc & Exp'!$I130)","v":0},{"$f":"I183*(1+'Inc & Exp'!$I130)","v":0}]
[null,null,null,"Income Limit/Program ",null,{"$f":"J128*(1+'Inc & Exp'!$I131)","v":0},{"$f":"F184*(1+'Inc & Exp'!$I131)","v":0},{"$f":"G184*(1+'Inc & Exp'!$I131)","v":0},{"$f":"H184*(1+'Inc & Exp'!$I131)","v":0},{"$f":"I184*(1+'Inc & Exp'!$I131)","v":0}]
[null,null,"Gross Potential Income",null,null,{"$f":"SUM(F175:F184)","v":0},{"$f":"SUM(G175:G184)","v":0},{"$f":"SUM(H175:H184)","v":0},{"$f":"SUM(I175:I184)","v":0},{"$f":"SUM(J175:J184)","v":0}]
[null,null,null,"   Less vacancy",null,{"$f":"(F175*'Inc & Exp'!$I$105)+(F176*'Inc & Exp'!$I$106)+(F177*'Inc & Exp'!$I$107)+(F178*'Inc & Exp'!$I$108)+(F179*'Inc & Exp'!$I$109)+(F180*'Inc & Exp'!$I$110)+(F181*'Inc & Exp'!$I$111)+(F182*'Inc & Exp'!$I$112)+(F183*'Inc & Exp'!$I$113)+(F184*'Inc & Exp'!$I$114)","v":0},{"$f":"(G175*'Inc & Exp'!$I$105)+(G176*'Inc & Exp'!$I$106)+(G177*'Inc & Exp'!$I$107)+(G178*'Inc & Exp'!$I$108)+(G179*'Inc & Exp'!$I$109)+(G180*'Inc & Exp'!$I$110)+(G181*'Inc & Exp'!$I$111)+(G182*'Inc & Exp'!$I$112)+(G183*'Inc & Exp'!$I$113)+(G184*'Inc & Exp'!$I$114)","v":0},{"$f":"(H175*'Inc & Exp'!$I$105)+(H176*'Inc & Exp'!$I$106)+(H177*'Inc & Exp'!$I$107)+(H178*'Inc & Exp'!$I$108)+(H179*'Inc & Exp'!$I$109)+(H180*'Inc & Exp'!$I$110)+(H181*'Inc & Exp'!$I$111)+(H182*'Inc & Exp'!$I$112)+(H183*'Inc & Exp'!$I$113)+(H184*'Inc & Exp'!$I$114)","v":0},{"$f":"(I175*'Inc & Exp'!$I$105)+(I176*'Inc & Exp'!$I$106)+(I177*'Inc & Exp'!$I$107)+(I178*'Inc & Exp'!$I$108)+(I179*'Inc & Exp'!$I$109)+(I180*'Inc & Exp'!$I$110)+(I181*'Inc & Exp'!$I$111)+(I182*'Inc & Exp'!$I$112)+(I183*'Inc & Exp'!$I$113)+(I184*'Inc & Exp'!$I$114)","v":0},{"$f":"(J175*'Inc & Exp'!$I$105)+(J176*'Inc & Exp'!$I$106)+(J177*'Inc & Exp'!$I$107)+(J178*'Inc & Exp'!$I$108)+(J179*'Inc & Exp'!$I$109)+(J180*'Inc & Exp'!$I$110)+(J181*'Inc & Exp'!$I$111)+(J182*'Inc & Exp'!$I$112)+(J183*'Inc & Exp'!$I$113)+(J184*'Inc & Exp'!$I$114)","v":0}]
[null,null,"Effective Gross Residential Income",null,null,{"$f":"F185-F186","v":0},{"$f":"G185-G186","v":0},{"$f":"H185-H186","v":0},{"$f":"I185-I186","v":0},{"$f":"J185-J186","v":0}]
[null,null,null,"Commercial Income",null,{"$f":"J132*(1+'Inc & Exp'!$I$132)","v":0},{"$f":"F188*(1+'Inc & Exp'!$I$132)","v":0},{"$f":"G188*(1+'Inc & Exp'!$I$132)","v":0},{"$f":"H188*(1+'Inc & Exp'!$H$132)","v":0},{"$f":"I188*(1+'Inc & Exp'!$H$132)","v":0}]
[null,null,null,"   Less vacancy",null,{"$f":"F188*'Inc & Exp'!$I$115","v":0},{"$f":"G188*'Inc & Exp'!$I$115","v":0},{"$f":"H188*'Inc & Exp'!$I$115","v":0},{"$f":"I188*'Inc & Exp'!$I$115","v":0},{"$f":"J188*'Inc & Exp'!$I$115","v":0}]
[null,null,null,"Net Commercial Income",null,{"$f":"F188-F189","v":0},{"$f":"G188-G189","v":0},{"$f":"H188-H189","v":0},{"$f":"I188-I189","v":0},{"$f":"J188-J189","v":0}]
[null,null,"Effective Rental Income",null,null,{"$f":"F187+F190","v":0},{"$f":"G187+G190","v":0},{"$f":"H187+H190","v":0},{"$f":"I187+I190","v":0},{"$f":"J187+J190","v":0}]
[null,null,null,"Other Income",null,{"$f":"J136*(1+'Inc & Exp'!$H$133)","v":0},{"$f":"F192*(1+'Inc & Exp'!$H$133)","v":0},{"$f":"G192*(1+'Inc & Exp'!$H$133)","v":0},{"$f":"H192*(1+'Inc & Exp'!$H$133)","v":0},{"$f":"I192*(1+'Inc & Exp'!$H$133)","v":0}]
[null,null,"Total Gross Income",null,null,{"$f":"F191+F192","v":0},{"$f":"G191+G192","v":0},{"$f":"H191+H192","v":0},{"$f":"I191+I192","v":0},{"$f":"J191+J192","v":0}]
[null,null,null,"Operating Subsidies",null,{"$f":"'Inc & Exp'!G148+'Inc & Exp'!H148","v":0},{"$f":"'Inc & Exp'!G149+'Inc & Exp'!H149","v":0},{"$f":"'Inc & Exp'!G150+'Inc & Exp'!H150","v":0},{"$f":"'Inc & Exp'!G151+'Inc & Exp'!H151","v":0},{"$f":"'Inc & Exp'!G152+'Inc & Exp'!H152","v":0}]
[null,null,null,"Draw on Operating Reserves",null,{"$f":"'Inc & Exp'!I148","v":0},{"$f":"'Inc & Exp'!I149","v":0},{"$f":"'Inc & Exp'!I150","v":0},{"$f":"'Inc & Exp'!I151","v":0},{"$f":"'Inc & Exp'!I152","v":0}]
[null,null,"Total Effective Income",null,null,{"$f":"F193+F194+F195","v":0},{"$f":"G193+G194+G195","v":0},{"$f":"H193+H194+H195","v":0},{"$f":"I193+I194+I195","v":0},{"$f":"J193+J194+J195","v":0}]
[]
[null,null,"EXPENSES:"]
[null,null,null,"Administrative",null,{"$f":"J143*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F199*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G199*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H199*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I199*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Maintenance & Repair",null,{"$f":"J144*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F200*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G200*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H200*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I200*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Resident Services",null,{"$f":"J145*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F201*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G201*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H201*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I201*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Security",null,{"$f":"J146*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F202*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G202*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H202*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I202*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Electricity",null,{"$f":"J147*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F203*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G203*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H203*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I203*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Gas ",null,{"$f":"J148*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F204*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G204*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H204*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I204*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Oil",null,{"$f":"J149*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F205*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G205*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H205*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I205*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Water & Sewer",null,{"$f":"J150*(1+'Inc & Exp'!$I$216)","v":0},{"$f":"F206*(1+'Inc & Exp'!$I$216)","v":0},{"$f":"G206*(1+'Inc & Exp'!$I$216)","v":0},{"$f":"H206*(1+'Inc & Exp'!$I$216)","v":0},{"$f":"I206*(1+'Inc & Exp'!$I$216)","v":0}]
[null,null,null,"Replacement Reserve",null,{"$f":"J151*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F207*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G207*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H207*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I207*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Real Estate Taxes",null,{"$f":"J152*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"F208*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"G208*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"H208*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"I208*(1+'Inc & Exp'!$I$217)","v":0}]
[null,null,null,"Other Taxes",null,{"$f":"J153*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"F209*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"G209*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"H209*(1+'Inc & Exp'!$I$217)","v":0},{"$f":"I209*(1+'Inc & Exp'!$I$217)","v":0}]
[null,null,null,"Insurance",null,{"$f":"J154*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F210*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G210*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H210*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I210*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,null,"Other:",{"$f":"IF(+'LIHTC Info'!D132=\"\",\" \",'LIHTC Info'!D132)","v":" "},{"$f":"J155*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"F211*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"G211*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"H211*(1+'Inc & Exp'!$I$218)","v":0},{"$f":"I211*(1+'Inc & Exp'!$I$218)","v":0}]
[null,null,"Total Operating Expenses",null,null,{"$f":"SUM(F199:F211)","v":0},{"$f":"SUM(G199:G211)","v":0},{"$f":"SUM(H199:H211)","v":0},{"$f":"SUM(I199:I211)","v":0},{"$f":"SUM(J199:J211)","v":0}]
[]
[null,null,"NET OPERATING INCOME",null,null,{"$f":"F196-F212","v":0},{"$f":"G196-G212","v":0},{"$f":"H196-H212","v":0},{"$f":"I196-I212","v":0},{"$f":"J196-J212","v":0}]
[]
[null,null,null,"Debt Service",null,{"$f":"'Inc & Exp'!$G$234","v":0},{"$f":"'Inc & Exp'!$G$234","v":0},{"$f":"'Inc & Exp'!$G$234","v":0},{"$f":"'Inc & Exp'!$G$234","v":0},{"$f":"'Inc & Exp'!$G$234","v":0}]
[null,null,null,"Debt Service Coverage",null,{"$f":"IF(F216>0,F214/F216,\"               \")","v":"               "},{"$f":"IF(G216>0,G214/G216,\"               \")","v":"               "},{"$f":"IF(H216>0,H214/H216,\"               \")","v":"               "},{"$f":"IF(I216>0,I214/I216,\"               \")","v":"               "},{"$f":"IF(J216>0,J214/J216,\"               \")","v":"               "}]
[null,null,null,"Project Cash Flow",null,{"$f":"F214-F216","v":0},{"$f":"G214-G216","v":0},{"$f":"H214-H216","v":0},{"$f":"I214-I216","v":0},{"$f":"J214-J216","v":0}]
[null,null,null,"Operating Deficit",null,{"$f":"IF(F218>0,0,F218)","v":0},{"$f":"IF(G218>0,0,G218)","v":0},{"$f":"IF(H218>0,0,H218)","v":0},{"$f":"IF(I218>0,0,I218)","v":0},{"$f":"IF(J218>0,0,J218)","v":0}]
[]
[null,null,null,null,null,null,null,null,"Operating Deficit",{"$f":"SUM(F219:J219,F163:J163)","v":0}]
[null,null,null,null,null,null,null,null,"Operating Reserve",{"$f":"'Closing S&U'!$E$207","v":0}]

{"sheet":"Dev Fee","index":8,"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'!E3","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'!G193/'Closing S&U'!G228","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'!N82","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"]
[23760,"per unit for first 10 units",{"$f":"IF(U27>0,U27*A26,0)","v":0},{"$f":"'Project Info'!N82","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":237600}]
[19440,"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":583200}]
[16200,"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":162000}]
[7020,"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'!G228","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":982800}]
[]
["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"]
[21600,"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":216000}]
[17280,"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":518400}]
[14580,"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":145800}]
[7020,"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":880200}]
[null,null,null,{"$f":"D38/'Closing S&U'!G228","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'!G228-'Closing S&U'!G193)*0.15","v":0}]
["up to 15% of the total development cost (not including developer fee). "]
[null,{"$f":"IFERROR(IF((((G7+F20)/'Project Info'!N82)>230000),\"EQUITY & SUBSIDY EXCEEDS QAP MAXIMUM\",\"\"),\"\")","v":""}]
["Tax Exempt Bonds ONLY","REQUIRED DEFERRED DEVELOPER FEE",null,{"$f":"IF(ISBLANK('Project Info'!G40),D42-D38,D42-D29)","v":0}]

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

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

{"sheet":"Change Log","index":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":[]}