{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Req Cover","Budget Template","Initial Sched A - RE"," Initial Sched A - Bond","Req 2 Sched A","Req 3 Schedule A","Settlement Statement","Davis Bacon","Const S&U"],"not_rendered":{"external_links":4,"defined_names":136,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Req Cover","index":0,"n_rows":10,"n_cols":2,"rows_kept":10,"merged":[[1,0,1,1],[2,0,2,1]]}
[]
["Project Name"]
["NHHFA Requisition for Funding"]
[]
["Requisition #"]
["Date Submitted: "]
[]
[]
["Submitted to:","NHHFA"]
["Submitted by:"]

{"sheet":"Budget Template","index":1,"n_rows":120,"n_cols":21,"rows_kept":120,"merged":[[141,3,141,4],[142,3,142,4]]}
[null,"BUDGET DRAW TEMPLATE"]
[null,"BORROWER:",{"$f":"'Req Cover'!B10","v":0}]
[null,"PROJECT DESCRIPTION:"]
[null,"Req #",{"$f":"'Req Cover'!B5","v":0}]
[null,"Uses"]
["Category","Description","Original \nBudget","Total Adjustments","Revised Budget","Initial (RE)","Initial (Bond)","Req #1","Req #2","Req #3","Req #4","Req #5","Req #6","Req #7","Req #8","Req #9","Req #10","Total Draws to Date\n","Undisbursed  \nAfter This Draw","% Funded","Deferred\n(Unavailable)"]
[null,"ACQUISITION & CONSTRUCTION"]
["LD","LAND",null,null,{"$f":"C8+D8","v":{"v":0,"d":"0.00"}},{"$nulls":12},{"$f":"SUM(F8:Q8)","v":{"v":0,"d":"0.00"}},{"$f":"E8-R8","v":{"v":0,"d":"0.00"}},{"$f":"IF(R8=0,0,R8/E8)","v":{"v":0,"d":"0%"}}]
["LD","CONSTRUCTION BUDGET",null,null,{"$f":"C9+D9","v":{"v":0,"d":"0.00"}},{"$nulls":12},{"$f":"SUM(F9:Q9)","v":{"v":0,"d":"0.00"}},{"$f":"E9-R9","v":{"v":0,"d":"0.00"}},{"$f":"IF(R9=0,0,R9/E9)","v":{"v":0,"d":"0%"}}]
["LD","CONSTRUCTION CONTINGENCY",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"$f":"SUM(F10:Q10)","v":{"v":0,"d":"0.00"}},{"$f":"E10-R10","v":{"v":0,"d":"0.00"}},{"$f":"IF(R10=0,0,R10/E10)","v":{"v":0,"d":"0%"}}]
["LD","OTHER ACQUISITION & CONSTRUCTION",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"$f":"SUM(F11:Q11)","v":{"v":0,"d":"0.00"}},{"$f":"E11-R11","v":{"v":0,"d":"0.00"}},{"$f":"IF(R11=0,0,R11/E11)","v":{"v":0,"d":"0%"}}]
[null,"TOTAL ACQUISITION & CONSTRUCTION",{"$f":"SUBTOTAL(9,C8:C11)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(R12=0,0,R12/E12)","v":{"v":0,"d":"0%"}}]
[null,"ARCHITECTURAL & ENGINEERING",null,56000]
[null,"ARCHITECT FEE - DESIGN",null,null,{"$f":"C14+D14","v":{"v":0,"d":"0.00"}},{"$nulls":12},{"$f":"SUM(F14:Q14)","v":{"v":0,"d":"0.00"}},{"$f":"E14-R14","v":{"v":0,"d":"0.00"}},{"$f":"IF(R14=0,0,R14/E14)","v":{"v":0,"d":"0%"}}]
["HC","ARCHITECT FEE - INSPECTION",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"$f":"SUM(F15:Q15)","v":{"v":0,"d":"0.00"}},{"$f":"E15-R15","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0%"}]
["HC","ENGINEERING FEES",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"$f":"SUM(F16:Q16)","v":{"v":0,"d":"0.00"}},{"$f":"E16-R16","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0%"}]
[null,"CIVIL ENGINEER",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"$f":"SUM(F17:Q17)","v":{"v":0,"d":"0.00"}},{"$f":"E17-R17","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0%"}]
["HC","ENERGY CONSULTANT",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"$f":"SUM(F18:Q18)","v":{"v":0,"d":"0.00"}},{"$f":"E18-R18","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0%"}]
[null,"TOTAL ARCHITECTURAL & ENGINEERING",{"$f":"SUBTOTAL(9,C14:C18)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUBTOTAL(9,F14:F18)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,G14:G18)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,H14:H18)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,I14:I18)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,J14:J18)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,K14:K18)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
[null,"INTERIM CONSTRUCTION EXPENSE"]
["SC","CONSTRUCTION LOAN ORIGINATION FEE",null,null,{"$f":"C21+D21","v":{"v":0,"d":"0.00"}},{"$nulls":12},{"$f":"SUM(F21:Q21)","v":{"v":0,"d":"0.00"}},{"$f":"E21-R21","v":{"v":0,"d":"0.00"}},{"$f":"IF(R21=0,0,R21/E21)","v":{"v":0,"d":"0%"}}]
["SC","CONSTRUCTION INTEREST",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
["SC","CONSTRUCTION INSURANCE",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
[null,"CONSTRUCTION BOND FEE",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
["SC","LENDER'S COUNCIL",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
["SC","TAXES DURING CONSTRUCTION",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
[null,"PERMITS",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
["SC","LETTER OF CREDIT FEE",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
["SC","CLERK OF THE WORKS",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
[null,"TOTAL INTERIM CONSTRUCTION EXPENSE",{"$f":"SUBTOTAL(9,C21:C29)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,D21:D29)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUBTOTAL(9,F21:F29)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,G21:G29)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,H21:H29)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,I21:I29)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,J21:J29)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,K21:K29)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUBTOTAL(9,S21:S29)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0%"}]
[null,"FINANCING FEES & EXPENSES"]
["SC","PERM LOAN ORIGINATION FEE",null,null,{"$f":"C32+D32","v":{"v":0,"d":"0.00"}},{"$nulls":12},{"$f":"SUM(F32:Q32)","v":{"v":0,"d":"0.00"}},{"$f":"E32-R32","v":{"v":0,"d":"0.00"}},{"$f":"IF(R32=0,0,R32/E32)","v":{"v":0,"d":"0%"}}]
["SC","TAX CREDIT FEES",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
["SC","TITLE INSURANCE & RECORD",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
["SC","LENDERS COUNSEL",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
["SC","FINANCING APPLICATION FEE",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
[null,"UPFRONT MIP FEE",null,null,{"v":0,"d":"0.00"}]
["SC","SOFT COST CONTINGENCY",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
["SC","TRANSFER TAX",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
[null,"TOTAL FINANCING FEES & EXPENSES",{"$f":"SUBTOTAL(9,C32:C39)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,D32:D39)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUBTOTAL(9,F32:F39)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,G32:G39)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,H32:H39)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,I32:I39)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,J32:J39)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,K32:K39)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUBTOTAL(9,S32:S39)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0%"}]
[null,"OTHER SOFT COSTS"]
["SC","APPRAISAL",null,null,{"$f":"C42+D42","v":{"v":0,"d":"0.00"}},{"$nulls":12},{"$f":"SUM(F42:Q42)","v":{"v":0,"d":"0.00"}},{"$f":"E42-R42","v":{"v":0,"d":"0.00"}},{"$f":"IF(R42=0,0,R42/E42)","v":{"v":0,"d":"0%"}}]
["SC","MARKET STUDY",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
["SC","ENVIRONMENTAL REPORT",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
["SC","RELOCATION COSTS",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
["SC","LEGAL FEES",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
["SC","ACCOUNTING FEES",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
["SC","FF&E, SECURITY, OP LOSS AND MARKETING",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
["SC","SITE SURVEY",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
[null,"TOTAL OTHER SOFT COSTS",{"$f":"SUBTOTAL(9,C42:C49)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,D42:D49)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUBTOTAL(9,F42:F49)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,G42:G49)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,H42:H49)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,I42:I49)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,J42:J49)","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"SUBTOTAL(9,R42:R49)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
[null,"DEVELOPER FEES"]
["SC","DEVELOPMENT OVERHEAD & PROFIT (Inc G&A EXPS)",null,null,{"$f":"C52+D52","v":{"v":0,"d":"0.00"}},{"$f":"SUMIF(' Initial Sched A - Bond'!$A$9:$A$9,'Budget Template'!B52,' Initial Sched A - Bond'!$F$9:$F$9)","v":{"v":0,"d":"0.00"}},{"$nulls":11},{"$f":"SUM(F52:Q52)","v":{"v":0,"d":"0.00"}},{"$f":"E52-R52","v":{"v":0,"d":"0.00"}},{"$f":"IF(R52=0,0,R52/E52)","v":{"v":0,"d":"0%"}}]
[null,"TOTAL DEVELOPER FEES",{"$f":"SUBTOTAL(9,C52:C52)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUBTOTAL(9,E52:E52)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,F52:F52)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,G52:G52)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,H52:H52)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,I52:I52)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,J52:J52)","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"SUBTOTAL(9,R52:R52)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"IF(R53=0,0,R53/E53)","v":{"v":0,"d":"0%"}}]
[null,"SYNDICATION EXPENSES"]
["SC","SYNDICATION LEGAL",null,null,{"$f":"C55+D55","v":{"v":0,"d":"0.00"}},{"$f":"SUMIF(' Initial Sched A - Bond'!$A$9:$A$9,'Budget Template'!B55,' Initial Sched A - Bond'!$F$9:$F$9)","v":{"v":0,"d":"0.00"}},{"$nulls":11},{"$f":"SUM(F55:Q55)","v":{"v":0,"d":"0.00"}},{"$f":"E55-R55","v":{"v":0,"d":"0.00"}},{"$f":"IF(R55=0,0,R55/E55)","v":{"v":0,"d":"0%"}}]
[null,"TOTAL SYNDICATION EXPENSES",{"$f":"SUBTOTAL(9,C55:C55)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,D55:D55)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUBTOTAL(9,F55:F55)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,G55:G55)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,H55:H55)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,I55:I55)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,J55:J55)","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"SUBTOTAL(9,R55:R55)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,S55:S55)","v":{"v":0,"d":"0.00"}},{"$f":"IF(R56=0,0,R56/E56)","v":{"v":0,"d":"0%"}}]
[null,"RESERVES [SEE NHHFA POLICIES]"]
["SC","OPERATING RESERVE",null,null,{"$f":"C58+D58","v":{"v":0,"d":"0.00"}},{"$f":"SUMIF(' Initial Sched A - Bond'!$A$9:$A$9,'Budget Template'!B58,' Initial Sched A - Bond'!$F$9:$F$9)","v":{"v":0,"d":"0.00"}},{"$nulls":11},{"$f":"SUM(F58:Q58)","v":{"v":0,"d":"0.00"}},{"$f":"E58-R58","v":{"v":0,"d":"0.00"}},{"$f":"IF(R58=0,0,R58/E58)","v":{"v":0,"d":"0%"}}]
["SC","REPLACEMENT RESERVE",null,null,{"$f":"C59+D59","v":{"v":0,"d":"0.00"}},{"$f":"SUMIF(' Initial Sched A - Bond'!$A$9:$A$9,'Budget Template'!B59,' Initial Sched A - Bond'!$F$9:$F$9)","v":{"v":0,"d":"0.00"}},{"$nulls":11},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
["SC","RENT - UP RESERVE",null,null,{"v":0,"d":"0.00"},{"$f":"SUMIF(' Initial Sched A - Bond'!$A$9:$A$9,'Budget Template'!B60,' Initial Sched A - Bond'!$F$9:$F$9)","v":{"v":0,"d":"0.00"}},{"$nulls":11},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
["SC","INSURANCE ESCROW",null,null,{"v":0,"d":"0.00"},{"$f":"SUMIF(' Initial Sched A - Bond'!$A$9:$A$9,'Budget Template'!B61,' Initial Sched A - Bond'!$F$9:$F$9)","v":{"v":0,"d":"0.00"}},{"$nulls":11},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
["SC","REAL ESTATE TAX ESCROW",null,null,{"v":0,"d":"0.00"},{"$f":"SUMIF(' Initial Sched A - Bond'!$A$9:$A$9,'Budget Template'!B62,' Initial Sched A - Bond'!$F$9:$F$9)","v":{"v":0,"d":"0.00"}},{"$nulls":11},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
["SC","TAX CREDIT MONITOR FEE",null,null,{"v":0,"d":"0.00"},{"$f":"SUMIF(' Initial Sched A - Bond'!$A$9:$A$9,'Budget Template'!B63,' Initial Sched A - Bond'!$F$9:$F$9)","v":{"v":0,"d":"0.00"}},{"$nulls":11},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0%"}]
[null,"DEBT SERVICE RESERVE",null,null,{"v":0,"d":"0.00"},{"$f":"SUMIF(' Initial Sched A - Bond'!$A$9:$A$9,'Budget Template'!B64,' Initial Sched A - Bond'!$F$9:$F$9)","v":{"v":0,"d":"0.00"}}]
[null,"TOTAL RESERVES [SEE NHHFA POLICIES]",{"$f":"SUBTOTAL(9,C58:C64)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,D58:D63)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,E58:E64)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":7},{"$f":"SUBTOTAL(9,R58:R63)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,S58:S63)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0%"}]
[null,"TOTAL SOFT COSTS",{"$f":"SUBTOTAL(9,C21:C65)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":7},{"$f":"SUBTOTAL(9,R21:R65)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,S21:S65)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0%"}]
[null,"TOTAL USES",{"$f":"+C12+C19+C30+C40+C50+C53+C56+C65","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":7},{"$f":"+R12+R19+R30+R40+R50+R53+R56+R65","v":{"v":0,"d":"0.00"}},{"$f":"+S12+S19+S30+S40+S50+S53+S56+S65","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0%"},{"$f":"SUMIF($U$8:$U$66,CONCATENATE(\"*\",\"YES\",\"*\"),$S$8:$S$66)","v":0}]
[null,"blank"]
[null,"Sources"]
[null,"Description","Original \nBudget","Total Prior Adjustments","Revised Budget",{"$f":"F6","v":"Initial (RE)"},{"$f":"G6","v":"Initial (Bond)"},"Req #1","Req #2","Req #3","Req #4","Req #5","Req #6","Req #7","Req #8","Req #9","Req #10","Total Draws to Date\n","Undisbursed  \nAfter This Draw","% Funded","Deferred/Unavail?"]
[null,"CONSTRUCTION LOAN",null,null,{"$f":"C71+D71","v":{"v":0,"d":"0.00"}},{"$nulls":12},{"$f":"SUM(F71:Q71)","v":{"v":0,"d":"0.00"}},{"$f":"E71-R71","v":{"v":0,"d":"0.00"}},{"$f":"IF(R71=0,0,R71/E71)","v":{"v":0,"d":"0%"}}]
[null,"NHHFA BRIDGE LOAN",null,null,{"v":0,"d":"0.00"}]
[null,"SUB-TOTAL CONSTRUCTION LOAN PROCEEDS",{"$f":"SUBTOTAL(9,C71:C72)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,D71:D71)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,E71:E72)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F71)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G71)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUBTOTAL(9,S71:S71)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0%"}]
[null,"PERMANENT LOAN",null,null,{"$f":"C74+D74","v":{"v":0,"d":"0.00"}},{"$nulls":12},{"v":0,"d":"0.00"},{"$f":"E74-R74","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0%"}]
[null,"WINDOW ENERGY REBATES",null,null,{"$f":"C75+D75","v":{"v":0,"d":"0.00"}}]
[null,"NOI DURING CONSTRUCTION",null,null,{"v":0,"d":"0.00"}]
[null,"WINN SELLER NOTE",null,null,{"v":0,"d":"0.00"}]
[null,"NHHFA DEFERRED 2nd",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"$f":"E78-R78","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0%"}]
[null,"FEDERAL LIHTC EQUITY",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"$f":"E79-R79","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0%"}]
[null,"OTHER EQUITY",null,null,{"v":0,"d":"0.00"}]
[null,"DEFERRED DEVELOPER FEE",null,null,{"v":0,"d":"0.00"},{"$nulls":12},{"v":0,"d":"0.00"},{"$f":"E81-R81","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0%"}]
[null,"SUB-TOTAL EQUITY/OTHER",{"$f":"SUBTOTAL(9,C74:C81)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":7},{"$f":"SUBTOTAL(9,R74:R81)","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(9,S74:S81)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0%"}]
[null,"TOTAL PROJECT SOURCES ",{"$f":"+C73+C82","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":7},{"$f":"+R73+R82","v":{"v":0,"d":"0.00"}},{"$f":"+S73+S82","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0%"},{"$f":"SUMIF($U$71:$U$81,CONCATENATE(\"*\",\"YES\",\"*\"),$S$71:$S$81)","v":0}]
[null,"SOURCE/USE VERIFICATIONS:",{"$f":"IF(C83=C67,\"OK\",\"WRONG-SOURCES MUST MATCH USES!\")","v":"OK"},{"$f":"IF(D83=D67,\"OK\",\"WRONG-SOURCES MUST MATCH USES!\")","v":"OK"},"OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK"]
[]
[]
[]
[]
[]
[]
[{"$nulls":11},"USES","USES","USES","USES","USES","USES"]
[{"$nulls":10},"DEPOSITS/EQUITY/OTHER","LAND","LAND","LAND","LAND","LAND","LAND","HARD","INTEREST","OPERATING"]
[]
[{"$nulls":10},"Affordable Housing Prog.","Building Purchase","Building Purchase","Building Purchase","Building Purchase","Building Purchase","Building Purchase","Construction Contract","Loan Interest Reserve","Operating Deficit"]
[{"$nulls":10},"Bank Controlled Account","Existing Structure","Existing Structure","Existing Structure","Existing Structure","Existing Structure","Existing Structure","Building Contract","Borrower Interest","TYPE DESCRIPTION"]
[{"$nulls":10},"Borrower Equity","Land Acquisition (Cost)","Land Acquisition (Cost)","Land Acquisition (Cost)","Land Acquisition (Cost)","Land Acquisition (Cost)","Land Acquisition (Cost)","Site Development Contract","Other Interest Reserve"]
[{"$nulls":10},"Co-Lenders","Leasehold","Leasehold","Leasehold","Leasehold","Leasehold","Leasehold","Other GC Contract","TYPE DESCRIPTION"]
[{"$nulls":10},"Condo Unit Deposits","Market Value","Market Value","Market Value","Market Value","Market Value","Market Value","TYPE DESCRIPTION"]
[{"$nulls":10},"Developer Equity","Out Parcel","Out Parcel","Out Parcel","Out Parcel","Out Parcel","Out Parcel","HARD MISC"]
[{"$nulls":10},"GIC Income","TYPE DESCRIPTION","TYPE DESCRIPTION","TYPE DESCRIPTION","TYPE DESCRIPTION","TYPE DESCRIPTION","TYPE DESCRIPTION","Hard Costs Contingency"]
[{"$nulls":10},"Grant",{"$nulls":6},"Curb/Sidewalk"]
[{"$nulls":10},"ILP Funds",{"$nulls":6},"Demolition"]
[{"$nulls":10},"Interest Funds",{"$nulls":6},"Environmental Remediation"]
[{"$nulls":10},"Member Banks",{"$nulls":6},"Furniture / Fixtures"]
[{"$nulls":10},"Mezzanine Debt",{"$nulls":6},"Infrastructure"]
[{"$nulls":10},"NOI",{"$nulls":6},"Landscaping/Irrigation"]
[{"$nulls":10},"Tax Credits",{"$nulls":6},"Offsite Costs"]
[{"$nulls":10},"Trust Funds",{"$nulls":6},"Misc Hard Costs"]
[{"$nulls":10},"TYPE DESCRIPTION",{"$nulls":6},"Owner's Contingency"]
[{"$nulls":17},"Parking"]
[{"$nulls":17},"Pre-Development"]
[{"$nulls":17},"Sales Tax Credit"]
[{"$nulls":17},"Security System"]
[{"$nulls":17},"Signage"]
[{"$nulls":17},"Site Work NON-Contract Costs"]
[{"$nulls":17},"Soil Removal"]
[{"$nulls":17},"Special Finishes"]
[{"$nulls":17},"Tenant Improvements"]
[{"$nulls":17},"Utility/Water/Sewer Costs"]
[{"$nulls":17},"TYPE DESCRIPTION"]

{"sheet":"Initial Sched A - RE","index":2,"n_rows":34,"n_cols":16,"rows_kept":34,"merged":[[5,0,5,4],[6,7,6,10]]}
[]
[{"$f":"'Req Cover'!A2","v":"Project Name"}]
["SCHEDULE A to the Owner's Affidavit"]
["Requisition Number",1]
["Date of Requisition ",{"$f":"'Req Cover'!B6","v":"00:00:00"}]
["List of Invoices & Disbursement Schedule by Payee"]
[{"$nulls":7},"Source of Funds"]
["Budget Category/Name","Name of Payee","Invoice Payee","Invoice Number","Invoice Date","Invoice Amount","Amount Paid","Perm Loan","Window Energy Rebates","NOI During Construction","Winn Seller Note","NHHFA Deferred 2nd","LIHTC Equity","Other Equity","Deferred Developer Fee","Detail"]
{"$rows_empty":19}
["TOTAL",{"$nulls":4},{"$f":"SUM(F9:F27)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
["Non-NHHFA Disbursement Adjustment"]
["Const. Interest","NHHFA","NHHFA","Loan # ",{"$nulls":3},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[]
["Total NHHFA Disbursements",{"$nulls":6},{"$f":"SUM(H28:H32)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(I28:I32)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]

{"sheet":" Initial Sched A - Bond","index":3,"n_rows":20,"n_cols":16,"rows_kept":20,"merged":[[5,0,5,4],[6,7,6,11]]}
[]
["Project Name"]
["SCHEDULE A to the Owner's Affidavit"]
["Requisition Number"]
["Date of Requisition "]
["List of Invoices & Disbursement Schedule by Payee"]
[{"$nulls":7},"Source of Funds"]
["Budget Category/Name","Name of Payee","Invoice Payee","Invoice Number","Invoice Date","Invoice Amount","Amount Paid","Perm Loan","Window Energy Rebates","NOI During Construction","Winn Seller Note","NHHFA Deferred 2nd","LIHTC Equity","Other Equity","Deferred Developer Fee","Detail"]
[]
[]
[]
[]
[]
["TOTAL",{"$nulls":4},{"$f":"SUM(F9:F10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G9:G10)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H9:H13)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(I9:I13)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
["Non-NHHFA Disbursement Adjustment"]
[]
[]
[]
["Total NHHFA Disbursements",{"$nulls":6},{"$f":"SUM(H14:H18)","v":{"v":0,"d":"$0.00"}},null,{"$f":"SUM(J14:J18)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(K14:K18)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(L14:L18)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(M14:M18)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]

{"sheet":"Req 2 Sched A","index":4,"n_rows":28,"n_cols":12,"rows_kept":28,"merged":[[5,0,5,4],[6,7,6,10]]}
[]
[{"$f":"'Req Cover'!A2","v":"Project Name"}]
["SCHEDULE A to the Owner's Affidavit"]
["Requisition Number",2]
["Date of Requisition ",{"$f":"'Req Cover'!B6","v":"00:00:00"}]
["List of Invoices & Disbursement Schedule by Payee"]
[{"$nulls":7},"Source of Funds"]
["Budget Category/Name","Name of Payee","Invoice Payee","Invoice Number","Invoice Date","Invoice Amount","Amount Paid","Source #1","Source #2","Source #3","Source #4","Detail"]
{"$rows_empty":13}
["TOTAL",{"$nulls":4},{"$f":"SUM(F21:F21)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
["Non-NHHFA Disbursement Adjustment"]
["Const. Interest","NHHFA","NHHFA","Loan # ",{"$nulls":3},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[]
["Total NHHFA Disbursements",{"$nulls":6},{"$f":"SUM(H22:H26)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(I22:I26)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(J22:J26)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(K22:K26)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Req 3 Schedule A","index":5,"n_rows":28,"n_cols":12,"rows_kept":28,"merged":[[5,0,5,4],[6,7,6,10]]}
[]
["Project Name",{"$f":"'Const S&U'!E1","v":"Lloyd's Hills "}]
["SCHEDULE A to the Owner's Affidavit"]
["Requisition Number",{"$f":"'Req Cover'!B5","v":0}]
["Date of Requisition ",{"$f":"'Req Cover'!B6","v":"00:00:00"}]
["List of Invoices & Disbursement Schedule by Payee"]
[{"$nulls":7},"Source of Funds"]
["Budget Category/Name","Name of Payee","Invoice Payee","Invoice Number","Invoice Date","Invoice Amount","Amount Paid","Source #1","Source #2","Source #3","Source #4","Detail"]
{"$rows_empty":13}
["TOTAL",{"$nulls":4},{"$f":"SUM(F21:F21)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
["Non-NHHFA Disbursement Adjustment"]
["Const. Interest","NHHFA","NHHFA","Loan # ",{"$nulls":3},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[]
["Total NHHFA Disbursements",{"$nulls":6},{"$f":"SUM(H22:H26)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(I22:I26)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(J22:J26)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(K22:K26)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Settlement Statement","index":6,"n_rows":88,"n_cols":10,"rows_kept":88,"merged":[[0,1,0,9],[1,1,1,9]]}
[null,"Settlement Statement"]
[]
[]
[null,"Project:"]
[]
[null,"Borrower:"]
[null,"Closing Date:"]
[null,"Settlement Agent:"]
[]
[]
[null,"All Cash Funding Sources",{"$nulls":3},"Funding at CLC",null,null,"Funding Sources at Bond Funding "]
[null,null,"LIHTC Equity"]
[null,null,"NHHFA Perm Loan"]
[null,null,"Window Energy Rebates"]
[null,null,"NOI During Construction"]
[null,null,"Winn Seller Note"]
[null,null,"NHHFA Deferred 2nd"]
[null,null,"Other Equity"]
[null,null,"Deferred Developer Fee"]
[null,null,"Total Funding",{"$f":"SUM(D12:D19)","v":0},null,"Total Funding",{"$f":"SUM(G12:G19)","v":0},null,"Total",{"$f":"SUM(J12:J19)","v":0}]
[]
[null,"Uses",{"$nulls":3},"Uses",null,null,"Payee","Amount"]
[]
[null,null,"Purchase Price"]
[]
[]
[]
[0]
[]
[]
[null,null,"NHHFA Loan Fee"]
[]
[null,null,"Architect Fee"]
[]
[null,null,"Permits"]
[]
[null,null,"Accounting Fees"]
[]
[null,null,"Payoff"]
[]
[null,null,"Legal Fees"]
[]
[null,null,"Developer Reimbursables"]
[]
[null,null,"Recording Fees"]
[]
[null,null,"Legal Fees"]
[]
[null,null,"Legal Fees"]
[null,null,"Title Policy"]
[]
[null,null,"Legal Fees"]
[]
[]
[]
[]
[]
[]
[null,null,"Subtotal",{"$f":"SUM(D22:D58)","v":0},null,"Subtotal",{"$f":"SUM(G22:G58)","v":0},null,"Total Checks/Wires",{"$f":"SUM(J24:J57)","v":0}]
[null,null,"Balance of Loan and Equity",{"$f":"D20-D59","v":0}]
[null,null,"Total Uses",{"$f":"D59+D60","v":0},null,"Total Uses",{"$f":"G59","v":0}]
[]
[null,null,"Balance",{"$f":"SUM(D20-D61)","v":0},null,"Balance",{"$f":"SUM(G20-G61)","v":0},null,"Balance",{"$f":"SUM(J20-J59)","v":0}]
[]
[]
[null,null,"Borrower:"]
[null,null,"Closing Date:"]
[null,null,"Settlement Agent:"]
{"$rows_empty":7}
[null,null,"Signature","By:"]
[]
[{"$nulls":3},"Name"]
[{"$nulls":3},"Title"]
[]
[]
[{"$nulls":3},"New Hampshire Housing Finance Authority"]
[]
[]
[null,null,"Signature","By: "]
[]
[{"$nulls":3},"Ignatius MacLellan"]
[{"$nulls":3},"Managing Director, Multifamily Housing Division"]

{"sheet":"Davis Bacon","index":7,"n_rows":23,"n_cols":9,"rows_kept":23}
[null,"Certified Payroll Tracking"]
[]
[null,"Week Ending","Sub A","Sub B","Sub C","Sub D","Sub E","Sub F","Sub G"]
[null,"2020-03-10"]
[null,"2020-03-17"]
[null,{"$f":"B5+7","v":"2020-03-24"}]
[null,"2020-03-31"]
[null,"2020-04-07"]
[null,"2020-04-14"]
[null,"2020-04-21"]
[null,"2020-04-28"]
[null,"2020-05-05"]
[null,"2020-05-12"]
[null,"2020-05-19"]
[null,"2020-05-26"]
[null,"2020-06-02"]
[null,"2020-06-09"]
[null,"2020-06-16"]
[null,"2020-06-23"]
[null,"2020-06-30"]
[null,"2020-07-07"]
[null,"2020-07-14"]
[null,"2020-07-21"]

{"sheet":"Const S&U","index":8,"n_rows":104,"n_cols":61,"rows_kept":104,"merged":[[2,6,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13],[2,14,2,15],[2,16,2,17],[2,18,2,19],[2,20,2,21],[2,22,2,23],[2,24,2,25],[2,26,2,27],[2,28,2,29],[2,30,2,31],[2,32,2,33],[2,34,2,35],[2,36,2,37],[2,38,2,39],[2,40,2,41],[2,42,2,43],[2,44,2,45],[2,46,2,47],[2,48,2,49],[2,50,2,51],[2,52,2,53]]}
["Disbursement Schedule",null,null,"Project:","Lloyd's Hills "]
[]
[null,null,"Original Budget","Expended Prior to Closing","Paid at Closing","Total expended  thru closing ","Month 1 Draw",null,"Month 2 Draw",null,"Month 3 Draw",null,"Month 4 Draw",null,"Month 5 Draw",null,"Month 6 Draw",null,"Month 7 Draw",null,"Month 8 Draw",null,"Month 9 Draw",null,"Month 10 Draw",null,"Month 11 Draw",null,"Month 12 Draw",null,"Month 13 Draw",null,"Month 14 Draw",null,"Month 15 Draw",null,"Month 16 Draw",null,"Month 17 Draw",null,"Month 18 Draw",null,"Month 19 Draw",null,"Month 20 Draw",null,"Month 21 Draw",null,"Month 22 Draw",null,"Month 23 Draw",null,"Month 24 Draw",null,null,"Total Original Budget","Budged Adjustments","Adjusted Budget Total","Total Actual to Date","% of Budget Expended","Balance to  Complete"]
["Sources of Funds:",{"$nulls":5},"Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual","Budget","Actual"]
["Developer's Cash Equity",null,{"v":0,"d":"0 "},null,null,{"$f":"D5+E5","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"$f":"F5+G5+I5+K5+M5+O5+Q5+S5+U5+W5+Y5+AA5+AC5+AE5+AG5+AI5","v":{"v":0,"d":"0 "}},null,{"$f":"BD5+BE5","v":{"v":0,"d":"0 "}},{"$f":"H5+J5+L5+N5+P5+R5+T5+V5+X5+Z5+AB5+AD5+AF5+AH5+AJ5+AL5+AN5+AP5+AR5+AT5+AV5+AX5+AZ5+BB5","v":{"v":0,"d":"0 "}},{"$f":"IF(BF5=0,\"-\",BG5/BF5)","v":"-"},{"$f":"BF5-BG5","v":{"v":0,"d":"0 "}}]
["LIHTC Equity ",{"$nulls":4},{"$f":"D6+E6","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"$f":"E6+G6+I6+K6+M6+O6+Q6+S6+U6+W6+Y6+AA6+AC6+AE6+AG6+AI6","v":{"v":0,"d":"0 "}},null,{"$f":"BD6+BE6","v":{"v":0,"d":"0 "}},{"$f":"H6+J6+L6+N6+P6+R6+T6+V6+X6+Z6+AB6+AD6+AF6+AH6+AJ6+AL6+AN6+AP6+AR6+AT6+AV6+AX6+AZ6+BB6","v":{"v":0,"d":"0 "}},{"$f":"IF(BF6=0,\"-\",BG6/BF6)","v":"-"},{"$f":"BF6-BG6","v":{"v":0,"d":"0 "}}]
["HTC Equity",{"$nulls":4},{"$f":"D7+E7","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"v":0,"d":"0 "},null,{"$f":"BD7+BE7","v":{"v":0,"d":"0 "}},{"$f":"H7+J7+L7+N7+P7+R7+T7+V7+X7+Z7+AB7+AD7+AF7+AH7+AJ7+AL7+AN7+AP7+AR7+AT7+AV7+AX7+AZ7+BB7","v":{"v":0,"d":"0 "}},"-",{"v":0,"d":"0 "}]
["Other Equity",{"$nulls":4},{"$f":"D8+E8","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Developer Fee Loan","",{"$nulls":3},{"$f":"D9+E9","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Other Source:",0,{"$nulls":3},{"$f":"D10+E10","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Grant:",0,{"$nulls":3},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Grant:",0,{"$nulls":3},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["NHHFA Capital Subsidy Funds",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Subordinate Debt",0,{"$nulls":3},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Subordinate Debt",0,{"$nulls":3},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Subordinate Debt",0,{"$nulls":3},{"$f":"D16+E16","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Subordinate Debt",0,{"$nulls":3},{"$f":"D17+E17","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["NHHFA Permanent Loan",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Other Permanent Mortgage",{"$error":"#VALUE!"},{"$nulls":3},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Other Permanent Mortgage",{"$error":"#VALUE!"},{"$nulls":3},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Construction Loan",{"v":0,"d":"0 "},{"$nulls":3},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Other Interim Loan","NHHFA Bridge",{"$nulls":3},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Tax Credit Bridge Loan",{"v":0,"d":"0 "},{"$nulls":3},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Total Sources of Funds",null,{"v":18373478,"d":"18,373,478 "},{"$f":"SUM(D5:D23)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(G5:G23)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H5:H23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(J5:J23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(L5:L23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(N5:N23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(P5:P23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(R5:R23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(T5:T23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(V5:V23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(X5:X23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(Z5:Z23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(AB5:AB23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(AD5:AD23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(AF5:AF23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(AH5:AH23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"SUM(AJ5:AJ23)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,null,{"$f":"SUM(BD5:BD23)","v":{"v":0,"d":"0 "}},{"$f":"SUM(BE5:BE23)","v":{"v":0,"d":"0 "}},{"$f":"SUM(BF5:BF23)","v":{"v":0,"d":"0 "}},{"$f":"SUM(BG5:BG23)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(BI5:BI23)","v":{"v":0,"d":"0 "}}]
[]
["Uses of Funds:"]
["Acquisition & Construction"]
["Land",{"$nulls":4},{"$f":"D28+E28","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"$f":"SUM(F28:O28)","v":{"v":0,"d":"0 "}},null,{"$f":"BD28+BE28","v":{"v":0,"d":"0 "}},{"$f":"H28+J28+L28+N28+P28+R28+T28+V28+X28+Z28+AB28+AD28+AF28+AH28+AJ28+AL28+AN28+AP28+AR28+AT28+AV28+AX28+AZ28+BB28","v":{"v":0,"d":"0 "}},{"$f":"IF(BF28=0,\"-\",BG28/BF28)","v":"-"},{"$f":"BF28-BG28","v":{"v":0,"d":"0 "}}]
["Existing Building",{"$nulls":4},{"$f":"D29+E29","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"$f":"SUM(F29:O29)","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Construction Budget",{"$nulls":4},{"$f":"D30+E30","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"$f":"SUM(F30:AG30)","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Construction Contingency",{"$nulls":4},{"$f":"D31+E31","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"$f":"SUM(F31:AG31)","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Other Acquisition & Construction",{"$nulls":4},{"$f":"D32+E32","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"$f":"SUM(F32:O32)","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Architectural & Engineering"]
["Architect Fee-Design",{"$nulls":4},{"$f":"+D34+E34","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"$f":"SUM(F34:O34)","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Architect Fee-Inspection",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Engineering Fees",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Historic Consultant Fees",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Solar Consultant Fees",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Other",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Other",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Interim Construction Expense"]
["Const. Loan Origination Fee",{"$nulls":4},{"$f":"+D42+E42","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"$f":"SUM(F42:O42)","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Const. Interest",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"$f":"SUM(F43:AG43)","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Const. Insurance",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Const. Bond Fee",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Lender's Counsel",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Taxes During Construction",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Permits",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Const. Bridge Loan",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"$f":"SUM(F49:AG49)","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Bond Issuance",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Financing Fees and Expenses"]
["Perm. Loan Origination Fee",{"$nulls":4},{"$f":"+D52+E52","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"$f":"SUM(F52:O52)","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Perm. Loan Credit Enhance",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Tax Credit Fee",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Title Insurance and Record",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Transfer Tax",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Lender's Counsel",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Bond Premium",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Financing Application Fee",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Upfront MIP Fee",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["FFB Trustee Fee",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Soft Cost Contingency",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Other",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Other Soft Costs"]
["Appraisal",{"$nulls":4},{"$f":"+D65+E65","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"$f":"SUM(F65:O65)","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Market Study",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Environmental Report",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"$f":"BF67-BG67","v":{"v":0,"d":"0 "}}]
["Site Survey",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Relocation Expenses",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Legal Fees",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Accounting Fees",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Accounting Fees",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Soft Cost Contingency",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Development Fees"]
["Devel Overhead and Profit",{"$nulls":4},{"$f":"+D75+E75","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"$f":"SUM(F75:AI75)","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Consultant Fee",{"$nulls":4},{"$f":"+D76+E76","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"$f":"SUM(F76:O76)","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
[]
["Syndication Expenses"]
["Syndication Legal",{"$nulls":4},{"$f":"+D79+E79","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"$f":"SUM(F79:O79)","v":{"v":0,"d":"0 "}},null,{"$f":"BD79+BE79","v":{"v":0,"d":"0 "}},{"$f":"H79+J79+L79+N79+P79+R79+T79+V79+X79+Z79+AB79+AD79+AF79+AH79+AJ79+AL79+AN79+AP79+AR79+AT79+AV79+AX79+AZ79+BB79","v":{"v":0,"d":"0 "}},{"$f":"IF(BF79=0,\"-\",BG79/BF79)","v":"-"},{"$f":"BF79-BG79","v":{"v":0,"d":"0 "}}]
["Syndication Accounting",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Syndication Fees",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Syndication Consultant",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Bridge Loan Origination Fee",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Bridge Loan Interest",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Investor Servicing (capital)",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Other",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"$f":"BF86-BG86","v":{"v":0,"d":"0 "}}]
["Reserves (See NHHFA Policies)"]
["Operating Reserve",{"$nulls":4},{"$f":"D88+E88","v":{"v":0,"d":"0.00"}},{"$nulls":49},{"$f":"SUM(F88:AI88)","v":{"v":0,"d":"0 "}},null,{"$f":"BD88+BE88","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},"-",{"$f":"BF88-BG88","v":{"v":0,"d":"0 "}}]
["FFB Operating Reserve",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"$f":"SUM(F89:O89)","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"$f":"BF89-BG89","v":{"v":0,"d":"0 "}}]
["Replacement Reserve",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"$f":"SUM(F90:AI90)","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Rent - Up Reserve",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Insurance Escrow",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Real Estate Tax Escrow",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Tax Credit Monitor Fee",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Other",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"v":0,"d":"0 "},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},"-",{"v":0,"d":"0 "}]
["Other"]
["TA Loan Payoff",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"$f":"SUM(F97:O97)","v":{"v":0,"d":"0 "}},null,{"$f":"BD97+BE97","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},"-",{"$f":"+C97-BD97","v":{"v":0,"d":"0 "}}]
["Construction Loan Payoff",{"$nulls":4},{"v":0,"d":"0.00"},{"$nulls":49},{"$f":"SUM(F98:AK98)","v":{"v":0,"d":"0 "}},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"IF(BF98=0,\"-\",BG98/BF98)","v":"-"},{"$f":"BF98-BG98","v":{"v":0,"d":"0 "}}]
["  Total Uses of Funds",null,{"v":18373478,"d":"18,373,478 "},{"$f":"SUM(D28:D98)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,null,{"$f":"SUM(BD28:BD98)","v":{"v":0,"d":"0 "}},{"$f":"SUM(BE28:BE98)","v":{"v":0,"d":"0 "}},{"$f":"SUM(BF28:BF98)","v":{"v":0,"d":"0 "}},{"$f":"SUM(BG28:BG98)","v":{"v":0,"d":"0 "}},null,{"$f":"SUM(BI28:BI98)","v":{"v":0,"d":"0 "}}]
[]
["Source and Use Check",null,{"v":0,"d":"0 "},{"$f":"D24-D99","v":{"v":0,"d":"0 "}},0,{"v":0,"d":"0.00"},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":"AH24-AH99","v":{"v":0,"d":"0.00"}},0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,{"v":0,"d":"0 "},{"$nulls":4},{"v":0,"d":"0 "}]
[]
[]
[null,null,{"$f":"IF(SUM(C101:BI101)<>0,\"Sources do not match uses!,\"\"\")","v":false}]