{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Summary","Dev Exp Cost Comparison","MFI&FMR","Instructions","Project Overview","Development Costs","Sources & Uses","Unit Mix, Sales Data","Budget Draw Monitoring ","Prelim Profit & Loss","Working Profit & Loss"],"not_rendered":{"charts":1,"images":1,"macros":0,"external_links":0,"defined_names":25,"comments":2,"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":"Summary","index":0,"n_rows":79,"n_cols":9,"rows_kept":79,"cut":false,"hidden":true,"merged":[[37,5,37,6],[33,5,33,6],[35,5,35,6],[2,6,2,7],[1,1,1,7],[6,6,6,7],[6,1,6,4],[18,1,18,7],[27,5,27,6],[61,6,61,8],[46,1,46,4],[60,1,60,4],[54,6,54,7],[46,6,46,7],[40,5,40,6],[41,5,41,6],[42,5,42,6],[38,5,38,6],[39,5,39,6],[44,5,44,6],[30,5,30,6],[32,5,32,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[34,5,34,6],[28,5,28,6],[31,5,31,6],[29,5,29,6],[25,5,25,6],[26,5,26,6],[36,5,36,6]]}
[]
[null,"PROJECT SUMMARY INFORMATION"]
[null,"Property (Project) Name:",{"$f":"'Project Overview'!C5","v":0},null,null,"Borrower (Legal Entity) Name:",{"$f":"'Project Overview'!G7","v":0}]
[null,"Street Address:",{"$f":"'Project Overview'!C7","v":0}]
[null,"Developer (Sponsor):",{"$f":"'Project Overview'!G5","v":0}]
[]
[null,"PRELIMINARY PROJECT ANALYSIS",null,null,null,null,"ADDITIONAL DETAILS"]
[null,"Metrics","Proforma","Target Range","Comments",null,"Item","Detail"]
[null," Stabilized DCR (Year 1)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"TEXT(Summary!$H$64,\"0.00\")&\" - \"&TEXT(Summary!$I$64, \"0.00\")","v":"1.10 - 1.25"},{"$f":"IF(OR(C9=\"0.00\",C9=\"NHD\"),\"N/A\",IF(AND(Summary!$H$64<=C9,C9<=Summary!$I$64),\"OK\",\"Needs Review\"))","v":{"$error":"#REF!"}},null,"HDA Subsidy Requested",{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}}]
[null,"Lowest DCR (Years 1-20)",{"$f":"IF(MIN(#REF!)=0,\"NHD\",MIN(#REF!))","v":{"$error":"#REF!"}},{"$f":"TEXT(Summary!$H$64,\"0.00\")&\" - \"&TEXT(Summary!$I$64, \"0.00\")","v":"1.10 - 1.25"},{"$f":"IF(OR(C10=\"0.00\",C10=\"NHD\"),\"N/A\",IF(AND(Summary!$H$64<=C10,C10<=Summary!$I$64),\"OK\",\"Needs Review\"))","v":{"$error":"#REF!"}},null,"Original Application Date",{"$f":"'Unit Mix, Sales Data'!#REF!","v":{"$error":"#REF!"}}]
[null,"Average DCR (Years 1-20)",{"$f":"IFERROR(AVERAGE(#REF!),\"NHD\")","v":"NHD"},{"$f":"TEXT(Summary!$H$64,\"0.00\")&\" - \"&TEXT(Summary!$I$64, \"0.00\")","v":"1.10 - 1.25"},{"$f":"IF(OR(C11=\"0.00\",C11=\"NHD\"),\"N/A\",IF(AND(Summary!$H$64<=C11,C11<=Summary!$I$64),\"OK\",\"Needs Review\"))","v":"N/A"},null,"Current Model Iteration Date",{"$f":"'Unit Mix, Sales Data'!#REF!","v":{"$error":"#REF!"}}]
[null,"HDA Subsidy per HDA Program Unit",{"$f":"H9/'Unit Mix, Sales Data'!#REF!","v":{"$error":"#REF!"}},{"$f":"TEXT(Summary!H65,\"$0,0\")&\" - \"&TEXT(Summary!I65, \"$0,0\")","v":"$40,000 - $100,000"},{"$f":"IF(AND(Summary!H65<=C12,C12<=Summary!I65),\"OK\",\"Needs Review\")","v":{"$error":"#REF!"}},null,"Total Units",{"$f":"Total_Units","v":0}]
[null,"HDA Subsidy per HDA Program Sq Ft",{"$f":"H9/'Unit Mix, Sales Data'!#REF!","v":{"$error":"#REF!"}},{"$f":"TEXT(Summary!H66,\"$0,0\")&\" - \"&TEXT(Summary!I66, \"$0,0\")","v":"$90 - $150"},{"$f":"IF(AND(Summary!H66<=C13,C13<=Summary!I66),\"OK\",\"Needs Review\")","v":{"$error":"#REF!"}},null,"Total HDA Program Units",{"$f":"'Unit Mix, Sales Data'!#REF!","v":{"$error":"#REF!"}}]
[null,"HDA Subsidy per Affordable Unit",{"$f":"H9/'Unit Mix, Sales Data'!E29","v":{"$error":"#REF!"}},{"$f":"TEXT(Summary!H67,\"$0,0\")&\" - \"&TEXT(Summary!I67, \"$0,0\")","v":"$40,000 - $70,000"},{"$f":"IF(AND(Summary!H67<=C14,C14<=Summary!I67),\"OK\",\"Needs Review\")","v":{"$error":"#REF!"}},null,"% Program Units",{"$f":"H13/Total_Units","v":{"$error":"#REF!"}}]
[null,"HDA Subsidy per Affordable Sq Ft",{"$f":"H9/'Unit Mix, Sales Data'!H29","v":{"$error":"#REF!"}},{"$f":"TEXT(Summary!H68,\"$0.00\")&\" - \"&TEXT(Summary!I68, \"$0.00\")","v":"$90.00 - $150.00"},{"$f":"IF(AND(Summary!H68<=C15,C15<=Summary!I68),\"OK\",\"Needs Review\")","v":{"$error":"#REF!"}},null,"Total Affordable Units",{"$f":"'Unit Mix, Sales Data'!E29","v":0}]
[null,"TDC per Unit (MKT + Aff.)",{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},{"$f":"TEXT(Summary!H69,\"$0,0\")&\" - \"&TEXT(Summary!I69, \"$0,0\")","v":"$150,000 - $300,000"},{"$f":"IF(AND(Summary!H69<=C16,C16<=Summary!I69),\"OK\",\"Needs Review\")","v":{"$error":"#REF!"}},null,"% Affordable Units",{"$f":"'Unit Mix, Sales Data'!E29/Total_Units","v":{"$error":"#DIV/0!"}}]
[null,"TDC per Sq Ft (MKT + Aff.)",{"$f":"#REF!/'Unit Mix, Sales Data'!H28","v":{"$error":"#REF!"}},{"$f":"TEXT(Summary!H70,\"$0.00\")&\" - \"&TEXT(Summary!I70, \"$0.00\")","v":"$400.00 - $550.00"},{"$f":"IF(AND(Summary!H70<=C17,C17<=Summary!I70),\"OK\",\"Needs Review\")","v":{"$error":"#REF!"}},null,"Project Type",{"$f":"'Unit Mix, Sales Data'!#REF!","v":{"$error":"#REF!"}}]
[]
[null,"UNIT MIX"]
[null,"Description","Type","AMI","# Units","Contract Rent",null,"Size"]
[null,{"$f":"IF(D21=\"\",\"\",IF(D21=\"MKT\",\"Market Rate Units\",IF(D21<=50%,\"HDA Program Units\",\"Affordable Housing Units\")))","v":""},{"$f":"IF('Unit Mix, Sales Data'!F4=\"\",\"\",'Unit Mix, Sales Data'!F4&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D4=\"\",\"\",'Unit Mix, Sales Data'!D4)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E4=\"\",\"\",'Unit Mix, Sales Data'!E4)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P4=\"\", \"\", 'Unit Mix, Sales Data'!P4)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G4=\"\", \"\", 'Unit Mix, Sales Data'!G4&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F5=\"\",\"\",'Unit Mix, Sales Data'!F5&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D5=\"\",\"\",'Unit Mix, Sales Data'!D5)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E5=\"\",\"\",'Unit Mix, Sales Data'!E5)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P5=\"\", \"\", 'Unit Mix, Sales Data'!P5)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G5=\"\", \"\", 'Unit Mix, Sales Data'!G5&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F6=\"\",\"\",'Unit Mix, Sales Data'!F6&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D6=\"\",\"\",'Unit Mix, Sales Data'!D6)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E6=\"\",\"\",'Unit Mix, Sales Data'!E6)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P6=\"\", \"\", 'Unit Mix, Sales Data'!P6)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G6=\"\", \"\", 'Unit Mix, Sales Data'!G6&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F7=\"\",\"\",'Unit Mix, Sales Data'!F7&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D7=\"\",\"\",'Unit Mix, Sales Data'!D7)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E7=\"\",\"\",'Unit Mix, Sales Data'!E7)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P7=\"\", \"\", 'Unit Mix, Sales Data'!P7)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G7=\"\", \"\", 'Unit Mix, Sales Data'!G7&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F8=\"\",\"\",'Unit Mix, Sales Data'!F8&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D8=\"\",\"\",'Unit Mix, Sales Data'!D8)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E8=\"\",\"\",'Unit Mix, Sales Data'!E8)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P8=\"\", \"\", 'Unit Mix, Sales Data'!P8)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G8=\"\", \"\", 'Unit Mix, Sales Data'!G8&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F9=\"\",\"\",'Unit Mix, Sales Data'!F9&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D9=\"\",\"\",'Unit Mix, Sales Data'!D9)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E9=\"\",\"\",'Unit Mix, Sales Data'!E9)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P9=\"\", \"\", 'Unit Mix, Sales Data'!P9)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G9=\"\", \"\", 'Unit Mix, Sales Data'!G9&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F10=\"\",\"\",'Unit Mix, Sales Data'!F10&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D10=\"\",\"\",'Unit Mix, Sales Data'!D10)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E10=\"\",\"\",'Unit Mix, Sales Data'!E10)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P10=\"\", \"\", 'Unit Mix, Sales Data'!P10)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G10=\"\", \"\", 'Unit Mix, Sales Data'!G10&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F11=\"\",\"\",'Unit Mix, Sales Data'!F11&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D11=\"\",\"\",'Unit Mix, Sales Data'!D11)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E11=\"\",\"\",'Unit Mix, Sales Data'!E11)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P11=\"\", \"\", 'Unit Mix, Sales Data'!P11)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G11=\"\", \"\", 'Unit Mix, Sales Data'!G11&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F12=\"\",\"\",'Unit Mix, Sales Data'!F12&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D12=\"\",\"\",'Unit Mix, Sales Data'!D12)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E12=\"\",\"\",'Unit Mix, Sales Data'!E12)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P12=\"\", \"\", 'Unit Mix, Sales Data'!P12)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G12=\"\", \"\", 'Unit Mix, Sales Data'!G12&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F13=\"\",\"\",'Unit Mix, Sales Data'!F13&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D13=\"\",\"\",'Unit Mix, Sales Data'!D13)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E13=\"\",\"\",'Unit Mix, Sales Data'!E13)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P13=\"\", \"\", 'Unit Mix, Sales Data'!P13)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G13=\"\", \"\", 'Unit Mix, Sales Data'!G13&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F14=\"\",\"\",'Unit Mix, Sales Data'!F14&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D14=\"\",\"\",'Unit Mix, Sales Data'!D14)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E14=\"\",\"\",'Unit Mix, Sales Data'!E14)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P14=\"\", \"\", 'Unit Mix, Sales Data'!P14)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G14=\"\", \"\", 'Unit Mix, Sales Data'!G14&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F15=\"\",\"\",'Unit Mix, Sales Data'!F15&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D15=\"\",\"\",'Unit Mix, Sales Data'!D15)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E15=\"\",\"\",'Unit Mix, Sales Data'!E15)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P15=\"\", \"\", 'Unit Mix, Sales Data'!P15)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G15=\"\", \"\", 'Unit Mix, Sales Data'!G15&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F16=\"\",\"\",'Unit Mix, Sales Data'!F16&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D16=\"\",\"\",'Unit Mix, Sales Data'!D16)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E16=\"\",\"\",'Unit Mix, Sales Data'!E16)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P16=\"\", \"\", 'Unit Mix, Sales Data'!P16)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G16=\"\", \"\", 'Unit Mix, Sales Data'!G16&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F17=\"\",\"\",'Unit Mix, Sales Data'!F17&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D17=\"\",\"\",'Unit Mix, Sales Data'!D17)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E17=\"\",\"\",'Unit Mix, Sales Data'!E17)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P17=\"\", \"\", 'Unit Mix, Sales Data'!P17)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G17=\"\", \"\", 'Unit Mix, Sales Data'!G17&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F18=\"\",\"\",'Unit Mix, Sales Data'!F18&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D18=\"\",\"\",'Unit Mix, Sales Data'!D18)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E18=\"\",\"\",'Unit Mix, Sales Data'!E18)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P18=\"\", \"\", 'Unit Mix, Sales Data'!P18)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G18=\"\", \"\", 'Unit Mix, Sales Data'!G18&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F19=\"\",\"\",'Unit Mix, Sales Data'!F19&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D19=\"\",\"\",'Unit Mix, Sales Data'!D19)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E19=\"\",\"\",'Unit Mix, Sales Data'!E19)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P19=\"\", \"\", 'Unit Mix, Sales Data'!P19)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G19=\"\", \"\", 'Unit Mix, Sales Data'!G19&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F20=\"\",\"\",'Unit Mix, Sales Data'!F20&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D20=\"\",\"\",'Unit Mix, Sales Data'!D20)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E20=\"\",\"\",'Unit Mix, Sales Data'!E20)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P20=\"\", \"\", 'Unit Mix, Sales Data'!P20)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G20=\"\", \"\", 'Unit Mix, Sales Data'!G20&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F21=\"\",\"\",'Unit Mix, Sales Data'!F21&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D21=\"\",\"\",'Unit Mix, Sales Data'!D21)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E21=\"\",\"\",'Unit Mix, Sales Data'!E21)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P21=\"\", \"\", 'Unit Mix, Sales Data'!P21)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G21=\"\", \"\", 'Unit Mix, Sales Data'!G21&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F22=\"\",\"\",'Unit Mix, Sales Data'!F22&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D22=\"\",\"\",'Unit Mix, Sales Data'!D22)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E22=\"\",\"\",'Unit Mix, Sales Data'!E22)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P22=\"\", \"\", 'Unit Mix, Sales Data'!P22)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G22=\"\", \"\", 'Unit Mix, Sales Data'!G22&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F23=\"\",\"\",'Unit Mix, Sales Data'!F23&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D23=\"\",\"\",'Unit Mix, Sales Data'!D23)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E23=\"\",\"\",'Unit Mix, Sales Data'!E23)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P23=\"\", \"\", 'Unit Mix, Sales Data'!P23)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G23=\"\", \"\", 'Unit Mix, Sales Data'!G23&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F24=\"\",\"\",'Unit Mix, Sales Data'!F24&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D24=\"\",\"\",'Unit Mix, Sales Data'!D24)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E24=\"\",\"\",'Unit Mix, Sales Data'!E24)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P24=\"\", \"\", 'Unit Mix, Sales Data'!P24)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G24=\"\", \"\", 'Unit Mix, Sales Data'!G24&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F25=\"\",\"\",'Unit Mix, Sales Data'!F25&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D25=\"\",\"\",'Unit Mix, Sales Data'!D25)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E25=\"\",\"\",'Unit Mix, Sales Data'!E25)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P25=\"\", \"\", 'Unit Mix, Sales Data'!P25)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G25=\"\", \"\", 'Unit Mix, Sales Data'!G25&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F26=\"\",\"\",'Unit Mix, Sales Data'!F26&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D26=\"\",\"\",'Unit Mix, Sales Data'!D26)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E26=\"\",\"\",'Unit Mix, Sales Data'!E26)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P26=\"\", \"\", 'Unit Mix, Sales Data'!P26)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G26=\"\", \"\", 'Unit Mix, Sales Data'!G26&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Sales Data'!F27=\"\",\"\",'Unit Mix, Sales Data'!F27&\" Bed / \"&'Unit Mix, Sales Data'!#REF!&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Sales Data'!D27=\"\",\"\",'Unit Mix, Sales Data'!D27)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E27=\"\",\"\",'Unit Mix, Sales Data'!E27)","v":""},{"$f":"IF('Unit Mix, Sales Data'!P27=\"\", \"\", 'Unit Mix, Sales Data'!P27)","v":""},null,{"$f":"IF('Unit Mix, Sales Data'!G27=\"\", \"\", 'Unit Mix, Sales Data'!G27&\" ft\"&CHAR(178))","v":""}]
[null,"Total / Wtd. Avg.",null,null,{"$f":"SUM(E21:E44)","v":0},{"$f":"SUMPRODUCT(E21:E44,G21:G44)/E45","v":{"$error":"#DIV/0!"}},null,{"$f":"'Unit Mix, Sales Data'!H28&\" ft\"&CHAR(178)","v":"0 ft²"}]
[]
[null,"DEVELOPMENT BUDGET",null,null,null,null,"YEAR ONE INCOME"]
[null,"Type","Amount","Per Unit","% of TDC",null,"Metric","Annual"]
[null,{"$f":"'Sources & Uses'!L19","v":"Hard Costs-Off Site"},{"$f":"'Sources & Uses'!M18","v":0},{"$f":"C49/Total_Units","v":{"$error":"#DIV/0!"}},{"$f":"C49/$C$59","v":{"$error":"#REF!"}},null,"Total Rental Income",{"$f":"'Unit Mix, Sales Data'!#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sources & Uses'!M19","v":0},{"$error":"#DIV/0!"},{"$error":"#REF!"},null,{"$f":"\"Residential Vacancy (\"&TEXT(Residential_Vacancy,\"0%\")&\")\"","v":{"$error":"#REF!"}},{"$f":"-(H49*Residential_Vacancy)","v":{"$error":"#REF!"}}]
[null,{"$f":"'Sources & Uses'!L20","v":"Hard Costs-Site Work"},{"$f":"'Sources & Uses'!M20","v":0},{"$error":"#DIV/0!"},{"$error":"#REF!"},null,"Total Other Income",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"'Sources & Uses'!L21","v":"Hard Costs-Site Amenities"},{"$f":"'Sources & Uses'!M21","v":0},{"$error":"#DIV/0!"},{"$error":"#REF!"},null,{"$f":"\"Commercial Vacancy (\"&TEXT(Commercial_Vacancy,\"0%\")&\")\"","v":{"$error":"#REF!"}},{"$f":"-(H51*Commercial_Vacancy)","v":{"$error":"#REF!"}}]
[null,{"$f":"'Sources & Uses'!L22","v":"Hard Costs-Building Costs"},{"$f":"'Sources & Uses'!M22","v":0},{"$error":"#DIV/0!"},{"$error":"#REF!"},null,"Effective Income:",{"$f":"SUM(H49:H52)","v":{"$error":"#REF!"}}]
[null,"Total Construction Costs:",{"$f":"SUM(C49:C53)","v":0},{"$error":"#DIV/0!"},{"$error":"#REF!"}]
[null,{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}},{"$f":"C55/$H$12","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,"KEY METRICS"]
[null,{"$f":"'Sources & Uses'!L23","v":"Hard Costs-Contingency"},{"$f":"'Sources & Uses'!M23","v":0},{"$f":"C56/$H$12","v":{"$error":"#DIV/0!"}},{"$error":"#REF!"},null,"DDF % of LIHTC Basis",{"$f":"DDF/#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}},{"$f":"C57/$H$12","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,"DDF % Total Developer Fee",{"$f":"DDF/#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"'Sources & Uses'!L25","v":"Soft Costs"},{"$f":"'Sources & Uses'!M25","v":0},{"$f":"C58/$H$12","v":{"$error":"#DIV/0!"}},{"$error":"#REF!"},null,"Construction Contingency %",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Total Uses of Funds:",{"$f":"C54+SUM(C55:C58)","v":{"$error":"#REF!"}},{"$f":"C59/$H$12","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,"Manage Fee % of Total Rent",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"Repl. Reserves per Unit",{"$f":"TEXT(#REF!, \"$#\")","v":{"$error":"#REF!"}}]
[null,"PERMANENT CAPITAL STRUCTURE"]
[null,"Source (Type)","Amount","Per Unit","% Funding",null,"Underwriting Target Ranges"]
[null,{"$f":"'Sources & Uses'!B8&\" (Hard Debt)\"","v":" (Hard Debt)"},{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}},{"$f":"C63/$H$12","v":{"$error":"#REF!"}},{"$f":"C63/$C$79","v":{"$error":"#REF!"}},null,"Metric","Lower Bound","Upper Bound"]
[null,{"$f":"'Sources & Uses'!B9&\" (Hard Debt)\"","v":" (Hard Debt)"},{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,"Debt Service Ratio",1.1000000000000001,1.25]
[null,{"$f":"'Sources & Uses'!B15&\" (Hard Debt)\"","v":" (Hard Debt)"},{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,"HDA Subsidy per HDA Program Unit",40000,100000]
[null,{"$f":"'Sources & Uses'!#REF!&\" (Soft Debt)\"","v":{"$error":"#REF!"}},{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,"HDA Subsidy per HDA Program Sq Ft",90,150]
[null,{"$f":"'Sources & Uses'!#REF!&\" (Soft Debt)\"","v":{"$error":"#REF!"}},{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,"HDA Subsidy per Affordable Unit",40000,70000]
[null,{"$f":"'Sources & Uses'!#REF!&\" (Soft Debt)\"","v":{"$error":"#REF!"}},{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,"HDA Subsidy per Affordable Sq Ft",90,150]
[null,{"$f":"'Sources & Uses'!#REF!&\" (Equity)\"","v":{"$error":"#REF!"}},{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,"TDC per Unit (MKT + Aff.)",150000,300000]
[null,{"$f":"'Sources & Uses'!#REF!&\" (Equity)\"","v":{"$error":"#REF!"}},{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,"TDC per Sq Ft (MKT + Aff.)",400,550]
[null,{"$f":"'Sources & Uses'!#REF!&\" (Equity)\"","v":{"$error":"#REF!"}},{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"'Sources & Uses'!#REF!&\" (Equity)\"","v":{"$error":"#REF!"}},{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"'Sources & Uses'!#REF!&\" (Equity)\"","v":{"$error":"#REF!"}},{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"'Sources & Uses'!#REF!&\" (Equity)\"","v":{"$error":"#REF!"}},{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"'Sources & Uses'!#REF!&\" (Equity)\"","v":{"$error":"#REF!"}},{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"'Sources & Uses'!#REF!&\" (Equity)\"","v":{"$error":"#REF!"}},{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Total Debt:",{"$f":"SUM(C63:C68)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Total Equity:",{"$f":"SUM(C69:C76)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Total Sources of Funds:",{"$f":"SUM(C77:C78)","v":{"$error":"#REF!"}},{"$f":"SUM(D77:D78)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]

{"sheet":"Dev Exp Cost Comparison","index":1,"n_rows":63,"n_cols":7,"rows_kept":63,"cut":false,"hidden":true,"merged":[[1,1,1,6]]}
[]
[null,"Development Expense Comparison"]
[null,"Cost Per Unit","Industry Cost Per Unit","Cost Per Unit Comparison","Cost Per Sq Ft","Industry Cost Per Sq ft","Cost Per Sq Ft Comparison"]
[]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$f":"C5-B5","v":{"$error":"#REF!"}},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$f":"F5-E5","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},{"$f":"SUM(C5:C10)","v":0},{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},{"$f":"SUM(F5:F10)","v":0},{"$error":"#REF!"}]
[]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$f":"C13-B13","v":{"$error":"#REF!"}},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$f":"F13-E13","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$f":"C14-B14","v":{"$error":"#REF!"}},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$f":"F14-E14","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$f":"C15-B15","v":{"$error":"#REF!"}},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$f":"F15-E15","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$f":"C16-B16","v":{"$error":"#REF!"}},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$f":"F16-E16","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},{"$f":"SUM(C13:C16)","v":0},{"$f":"C17-B17","v":{"$error":"#REF!"}},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},{"$f":"SUM(F13:F16)","v":0},{"$f":"F17-E17","v":{"$error":"#REF!"}}]
[]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$f":"C19-B19","v":{"$error":"#REF!"}},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$f":"F19-E19","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},{"$f":"SUM(C19:C43)","v":0},{"$f":"C44-B44","v":{"$error":"#REF!"}},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},{"$f":"SUM(F19:F43)","v":0},{"$f":"F44-E44","v":{"$error":"#REF!"}}]
[]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$f":"C46-B46","v":{"$error":"#REF!"}},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$f":"F46-E46","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},{"$f":"SUM(C46:C60)","v":0},{"$error":"#REF!"},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},{"$f":"SUM(F46:F60)","v":0},{"$error":"#REF!"}]
[]
[null,{"$f":"#REF!/Total_Units","v":{"$error":"#REF!"}},{"$f":"SUM(C11,C17,C44,C61)","v":0},{"$f":"C63-B63","v":{"$error":"#REF!"}},{"$f":"#REF!/'Unit Mix, Sales Data'!$H$28","v":{"$error":"#REF!"}},{"$f":"SUM(F11,F17,F44,F61)","v":0},{"$f":"F63-E63","v":{"$error":"#REF!"}}]

{"sheet":"MFI&FMR","index":2,"n_rows":16,"n_cols":17,"rows_kept":16,"cut":false,"hidden":true,"merged":[[2,1,2,9],[3,2,3,9]]}
[]
[null,"Source:","HUD User FY24 Income Limits",null,null,"Area:"," Austin-Round Rock, TX MSA",null,null,null,null,"Source:","HUD User FY25 Fair Market Rent (FMR)",null,null,"Area:","Austin-Round Rock, TX MSA"]
[null,"Income by % of Median Family Income (MFI) and Number of Persons in Family"]
[null,null,"Persons in Family"]
[null,"MFI Level",1,2,3,4,5,6,7,8]
[null,0.3,{"$f":"ROUND(($F6*C$16)/50, 0)*50","v":26450},30250,34000,{"$f":"ROUND((F$13*$B6)/50, 0)*50","v":37800},{"$f":"ROUND(($F6*G$16)/50, 0)*50","v":40800},43850,46850,49900]
[null,0.4,35300,40300,45350,{"$f":"ROUND((F$13*$B7)/50, 0)*50","v":50400},54450,58450,62500,66550]
[null,0.5,44100,50400,56700,63000,68050,73100,78100,83150,null,null,null,null,null,"Small Area FMRs by Zip Code can be found here:","HUD User FY25 Small Area Fair Market Rent (FMR)"]
[null,0.6,52900,60500,68050,{"$f":"ROUND((F$13*$B9)/50, 0)*50","v":75600},81650,87700,93750,99800,null,null,null,null,null,"Current Project Zip Code:",{"$f":"'Unit Mix, Sales Data'!#REF!","v":{"$error":"#REF!"}}]
[null,0.7,61750,70550,79400,{"$f":"ROUND((F$13*$B10)/50, 0)*50","v":88200},95250,102300,109350,116400]
[null,0.8,70550,80650,90700,100800,108850,116950,125000,133050]
[null,0.9,79400,90700,102050,113400,122450,131550,140600,149700,null,"Link to all HUD Datasets"]
[null,1,{"$f":"C8/0.5","v":88200},100800,113400,126000,136100,146200,156200,166300,null,"HUD Datasets"]
[null,1.1000000000000001,{"$f":"ROUND(($F14*C$16)/50, 0)*50","v":97000},110900,124750,138600,{"$f":"ROUND(($F14*G$16)/50, 0)*50","v":149700},160800,171850,182950]
[null,1.2,105850,120950,136100,151200,163300,175400,187500,199600]
[null,null,0.7,0.8,0.9,1,1.08,1.1599999999999999,1.24,1.32]

{"sheet":"Instructions","index":3,"n_rows":293,"n_cols":19,"rows_kept":293,"cut":false,"hidden":false,"merged":[[35,14,35,15],[37,13,37,14]]}
[]
[null,null,"Housing Development Assistance Excel Document Instructions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"North Lamar Blvd",1.01]
[null,null,"1) Fill in each light orange box, if applicable. ",null,null,null,null,null,null,null,null,null,null,null,null,"40 years",null,"Burnet Rd",1.02]
[null,null,"2) Breakout each funding source, pro-forma and development expense with a description.",null,null,null,null,null,null,null,null,null,null,null,null,"45 years",null,"Airport Blvd",2.0299999999999998]
[null,null,"3) Let staff know if you have formula errors or other issues with this spreadsheet.",null,null,null,null,"100% Affordable",null,null,null,null,null,null,null,"50 years",null,"East MLK/FM 969",2.04]
[null,null,"4) Once completed, attach it to the portal below",null,null,null,null,"Mixed-Income",null,null,null,null,null,null,null,"55 years",null,"South Lamar Blvd",2.0499999999999998]
[null,null," Housing Development Assistance Application Submittal Portal ",null,null,null,null,null,null,null,null,null,null,null,null,"60 years",null,"East Riverside Dr",2.06]
[null,null,null,null,null,null,null,"New Construction ",null,null,null,null,null,null,null,"65 years",null,"Guadalupe St",3.02]
[null,null,null,null,null,null,null,"Rehabilitation",null,null,null,"1/4 mile",null,null,null,"70 years",null,"William Cannon Dr",3.04]
[null,null,null,null,null,null,null,null,null,null,null,"1/2 mile",null,null,null,"75 years",null,"Slaughter Ln",3.05]
[null,null,null,null,null,null,null,null,null,null,null,"1 mile",null,null,null,"80 years",null,"N Lamar & Guadalupe St",3.06]
[null,null,null,null,null,null,null,null,null,null,null,"> 1 mile",null,null,null,"85 years",null,"Rundberg",3.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90 years",null,"Colony Loop Dr",4.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"99 Years",null,"MLK Blvd",4.0199999999999996]
[null,null,null,null,null,null,null,null,null,null,null,"Acquisition",null,null,null,null,null,"South Congress Ave",5]
[null,null,null,null,null,null,null,null,null,null,null,"Pre-development",null,null,null,null,null,"Manchaca Rd",6.01]
[null,null,null,null,null,null,null,null,null,null,null,"Construction",null,null,null,null,null,"S. Pleasant Valley Rd",6.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District 1",8.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District 2",8.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District 3",8.0299999999999994]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District 4",8.0399999999999991]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[null,null,null,null,null,null,null,"Yes",0.04,null,null,null,null,null,null,null,null,"District 8",11]
[null,null,null,null,null,null,null,"No",0.09,null,null,null,null,null,null,null,null,"District 9",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District 10",13.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ADA MAE FAUBION EL",13.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ALLISON EL",13.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ALTAMIRA ACADEMY",14.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANDERSON MILL EL",14.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANDREWS EL",14.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNIE PURL EL",15.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUSTIN DISCOVERY SCH",15.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUSTIN ISD CHILD DEVELOPMENT CENTE",15.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BAGDAD EL",15.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BALDWIN EL",16.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BARANOFF EL",16.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BARRINGTON EL",16.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BARTON CREEK EL",16.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BARTON HILLS EL",16.059999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BATY EL",17.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BECKER EL",17.059999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BEE CAVE EL",17.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BILL BURDEN EL",17.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLACKLAND PRAIRIE EL",17.13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLACKSHEAR EL",17.14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLAKE MANOR EL",17.16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLANTON EL",17.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLAZIER EL",17.190000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLOCK HOUSE CREEK EL",17.22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLUEBONNET EL",17.28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLUEBONNET TRAIL EL",17.29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BOONE EL",17.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRENTWOOD EL",17.38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRIDGE POINT EL",17.399999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BROOKE EL",17.420000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BROOKHOLLOW EL",17.45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BROWN EL",17.46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRUSHY CREEK EL",17.47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRYKER WOODS EL",17.48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C C MASON EL",17.489999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CACTUS RANCH EL",17.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALDWELL EL",17.510000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALDWELL HEIGHTS EL",17.52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAMPBELL EL",17.53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CANYON CREEK EL",17.54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CARVER EL",17.55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CASEY EL",17.559999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CASIS EL",17.57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEDAR CREEK EL",17.600000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEDARS INTERNATIONAL ACADEMY",17.61]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHANDLER OAKS EL",17.649999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHARLOTTE COX EL",17.690000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHRISTINE CAMACHO EL",17.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CLAUDE BERKMAN EL",17.72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CLAYTON EL",17.739999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COOK EL",17.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COPPERFIELD EL",17.760000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COTTONWOOD CREEK EL",17.77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COUPLAND EL",17.809999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COWAN EL",17.82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CREEDMOOR EL",17.829999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CUNNINGHAM EL",17.84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CYPRESS EL",17.850000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DAEP- EL",17.86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DAVIS EL",18.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DAWSON EL",18.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEARING EL",18.059999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DECKER EL",18.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEEPWOOD EL",18.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEER CREEK EL",18.13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEL VALLE EL",18.170000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DELCO PRI",18.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DELL PICKETT EL",18.190000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEPELCHIN-RICHMOND",18.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DESSAU EL",18.21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DOBIE PK CENTER",18.22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DOSS EL",18.23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DOUBLE FILE TRAIL EL",18.239999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EANES EL",18.260000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EDEN PARK ACADEMY",18.28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EL DAEP",18.29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELSA ENGLAND EL",18.32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FERN BLUFF EL",18.329999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FLORENCE EL",18.34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOREST CREEK EL",18.350000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOREST NORTH EL",18.39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOREST TRAIL EL",18.399999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FROST EL",18.41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GALINDO EL",18.420000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GATTIS EL",18.43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GEORGE M KOZMETSKY SCHOOL",18.440000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GOODWATER MONTESSORI SCHOOL",18.45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GOVALLE EL",18.46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRAHAM EL",18.47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRANDVIEW HILLS EL",18.48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GREAT OAKS EL",18.489999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GUERRERO THOMPSON",18.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GULLETT EL",18.510000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HARMONY SCHOOL OF INNOVATION - AUS",18.559999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HARMONY SCHOOL OF SCIENCE - AUSTIN",18.57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HARMONY SCIENCE ACADEMY - AUSTIN",18.63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HARMONY SCIENCE ACADEMY - CEDAR PA",18.64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HARRIS EL",19.010000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HART EL",19.079999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HELPING HAND",19.100000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIGHLAND PARK EL",19.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIGHLAND PARK EL",19.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HILL EL",19.13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HILLCREST EL",19.14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HORNSBY-DUNLAP EL",19.149999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOUSTON EL",19.170000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOWARD NORMAN EL",19.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUTTO EL",19.190000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JAMES E MITCHELL EL",20.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JARRELL EL",20.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JARRELL INT",20.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JIM PLAIN EL",20.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JO ANN FORD EL",21.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JOE LEE JOHNSON EL",21.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JOLLYVILLE EL",21.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JORDAN EL",21.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JOSEPH GILBERT EL",21.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JOSLIN EL",21.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KATHY CARAWAY EL",21.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KIKER EL",21.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KIPP AUSTIN COMUNIDAD",21.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KIPP AUSTIN CONNECTIONS EL",21.13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KIPP AUSTIN LEADERSHIP EL",22.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KIPP AUSTIN OBRAS",22.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KOCUREK EL",22.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAGO VISTA EL",22.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAGO VISTA INT",22.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAGOS EL",22.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAKE POINTE EL",22.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAKE TRAVIS EL",22.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAKEWAY EL",23.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LANGFORD EL",23.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAURA WELCH BUSH EL",23.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAUREL MOUNTAIN EL",23.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEE EL",23.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIBERTY HILL EL",23.13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINDA HERRINGTON EL",23.14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINDER EL",23.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIVE OAK EL",23.16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOIS F GIDDENS EL",23.17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAGNOLIA MONTESSORI FOR ALL",23.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAIN STREET INT",23.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MANOR EL",24.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAPLEWOOD EL",24.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MATHEWS EL",24.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MCBEE EL",24.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MENCHACA EL",24.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"METZ EL",24.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MILLS EL",24.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONTA JANE AKIN EL",24.13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOTT EL",24.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MURCHISON EL",24.21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NADINE JOHNSON EL",24.22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NAOMI PASEMANN EL",24.23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEW PRE-K CENTER",24.24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEYSA CALLISON EL",24.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORMAN EL",24.26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTHWEST EL",24.27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NYOS - MAGNOLIA MCCULLOUGH CAMPUS",24.28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OAK HILL EL",24.29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OAK MEADOWS EL",24.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OAK SPRINGS EL",24.31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ODOM EL",24.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OFFICER LEONARD A REED EL",24.34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OLD TOWN EL",24.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OLYMPIA HILLS",25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ORTEGA EL",203.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OVERTON EL",203.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PADRON EL",204.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PALM EL",204.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PARKSIDE EL",204.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PARMER LANE EL",204.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAT COOPER EL",204.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PATRICIA KNOWLES EL",204.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PATSY SOMMER EL",204.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PATTON EL",204.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAULINE NAUMANN EL",205.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PEASE EL",205.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PECAN SPRINGS EL",205.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PEREZ EL",205.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PFLUGERVILLE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PICKLE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PILLOW EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PIONEER CROSSING EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLEASANT HILL EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLEASANT HILL EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POND SPRINGS EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POPHAM EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRESIDENTIAL MEADOWS EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PURPLE SAGE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RANCHO SIENNA EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAY EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAYE MCCOY EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"READ PRE-K CENTER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REAL LEARNING ACADEMY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REILLY EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIDGETOP EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIOJAS EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIVER OAKS EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIVER PLACE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIVER RIDGE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RODRIGUEZ EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RONALD REAGAN EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROWE LANE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RUTH BARRON EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RUTLEDGE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SANCHEZ EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SERENE HILLS EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHADOWGLEN EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SIMS EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SMITH EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPICEWOOD EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPRINGHILL EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST ELMO EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STEINER RANCH EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUMMITT EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUNSET VALLEY EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TERAVISTA EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEXAS EMPOWERMENT ACADEMY EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TH JOHNSON EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THE EAST AUSTIN COLLEGE PREP AT SO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THRALL EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TIMMERMAN EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRAVIS HTS EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UNION HILL EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UNIVERSITY OF TEXAS EL CHARTER SCH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UPHAUS EARLY CHILDHOOD CENTER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VALLEY VIEW EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VETERANS HILL EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VIC ROBERTSON EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VILLAGE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WALNUT CREEK EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WEBB PRI CENTER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WELLS BRANCH EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WEST CYPRESS HILLS EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTSIDE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WHITESTONE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WIDEN EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WIELAND EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WILLIAM J WINKLEY EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WILLIAMS EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WINDERMERE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WINDERMERE PRI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WINN EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WOOLDRIDGE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WOOTEN EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XENIA VOIGT EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZAVALA EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZILKER EL"]

{"sheet":"Project Overview","index":4,"n_rows":515,"n_cols":23,"rows_kept":515,"cut":false,"hidden":false,"merged":[[499,1,499,3],[19,1,19,2],[1,1,1,6],[44,18,44,19],[46,17,46,18],[3,1,3,2],[3,5,3,6],[9,5,9,6],[20,5,20,6],[21,5,26,6],[5,1,5,2],[10,1,10,2],[17,1,17,2],[30,1,30,3]]}
[]
[null,"OHDA Application for Gap Financing"]
[]
[null,"Project Information",null,null,null,"Developer Information"]
[null,"Project Name",null,null,null,"Developer Name"]
[null,null,null,null,null,"Co-Developer (If applicable)",null,null,null,null,null,null,null,null,null,null,null,null,null,"40 years",null,"Burnet Rd",1.02]
[null,"Development Street Address",null,null,null,"Borrower (Legal Entity) Name"]
[null,"City, State","Austin, TX",null,null,"Developer Type (For or Non-Profit)"]
[null,"Development Zip Code"]
[null,"County",null,null,null,"Transaction Contact Information"]
[null,null,null,null,null,"Developer Contact Name"]
[null,"Project Type",null,null,null,"Realtor Contact Name"]
[null,"Building Type",null,null,null,"Developer Attorney Contact Name"]
[null,"Bond Mobility Corridor",null,null,null,"Title Company Contact Name (if known)"]
[null,"Census Tract",null,null,null,"Construction Lender Contact Name (if known)"]
[null,"Council District",null,null,null,"Long Term Monitoring Contact Name"]
[null,"Elementary School",null,null,null,"Other Contact Related to Transaction (Describe)",null,null,null,null,null,"100% Affordable",null,null,null,null,null,null,null,"50 years",null,"East MLK/FM 969",2.04]
[null,null,null,null,null,"Other Contact Related to Transaction (Describe)",null,null,null,null,null,"Rehabilitation",null,null,null,"1/4 mile",null,null,null,"70 years",null,"William Cannon Dr",3.04]
[null,"Affordability Period Requested (>= 99 years)",null,null,null,"Other Contact Related to Transaction (Describe)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"45 years",null,"Airport Blvd",2.0299999999999998]
[null,"Will SMART Housing fee waivers be utilized?*",null,null,null,"Project Description"]
[null,"Will Affordability Unlocked be utilized?",null,null,null,null,null,null,null,null,null,"Mixed-Income",null,null,null,null,null,null,null,"55 years",null,"South Lamar Blvd",2.0499999999999998]
[null,"Will Other City Programs be utilized?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60 years",null,"East Riverside Dr",2.06]
[null,"Is the property within 1/2 mile of an Imagine Austin Corridor?"]
[null,"Is the property within 1/4 mile of a High-Frequency Transit Stop?"]
[null,"Is the property within 3/4 mile of Transit Service?"]
[null,"Is the property within 1 mile of Healthy Food?"]
[null,"     *All new construction developments must submit a SMART Housing application."]
[]
[]
[null,"Project Timeline",null,null,null,null,null,null,null,null,null,"No"]
[null,"Phase","Start Date","End Date",null,null,null,null,null,null,null,"Vertical Mixed Use (VMU)",null,null,null,"1/2 mile",null,null,null,"75 years",null,"Slaughter Ln",3.05]
[null,"Acquisition & Pre Development",null,null,null,null,null,null,null,null,null,"University Neighborhood Overlay",null,null,null,"1 mile",null,null,null,"80 years",null,"N Lamar & Guadalupe St",3.06]
[null,"Acquisition",null,{"$f":"C34","v":"00:00:00"},null,null,null,null,null,null,null,"Downtown Density Bonus",null,null,null,"> 1 mile",null,null,null,"85 years",null,"Rundberg",3.07]
[null,"Zoning",null,null,null,null,null,null,null,null,null,"Micro-Unit Density Bonus",null,null,null,null,null,null,null,"90 years",null,"Colony Loop Dr",4.01]
[null,"Environmental Review",null,null,null,null,null,null,null,null,null,"North Burnet/Gateway",null,null,null,"Acquisition",null,null,null,"99+ Years",null,"South Congress Ave",5]
[null,"Closing of All Financing",null,null,null,null,null,null,null,null,null,"East Riverside Corridor",null,null,null,"Pre-development",null,null,null,null,null,"Manchaca Rd",6.01]
[null,"Development Services Review",null,null,null,null,null,null,null,null,null,"Density Bonus 90 (DB90)",null,null,null,null,null,null,null,null,null,null,6.04]
[null,"Construction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Travis",null,null,7]
[null,"Site Preparation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Williamson",null,"District 1",8.01]
[null,"25% Complete",{"$f":"D40+1","v":"1900-01-01"},null,null,null,null,null,null,null,null,"Single Family",null,null,null,null,null,null,null,"Hays",null,"District 2",8.02]
[null,"50% Complete",{"$f":"D41+1","v":"1900-01-01"},null,null,null,null,null,null,null,null,"Attached Condos",null,null,null,null,null,null,null,"Bastrop",null,"District 3",8.0299999999999994]
[null,"75% Complete",{"$f":"D42+1","v":"1900-01-01"},null,null,null,null,null,null,null,null,"Townhomes",null,null,null,null,null,null,null,null,null,"District 6"]
[null,"100% Complete",{"$f":"D43+1","v":"1900-01-01"},null,null,null,null,null,null,null,null,"Duplex",null,null,null,null,null,null,null,null,null,"District 7"]
[null,"Sales & Project Closeout",null,null,null,null,null,null,null,null,null,"TriPlex",null,null,null,null,null,null,"No"]
[null,"Marketing",null,null,null,null,null,null,null,null,null,"MultiFamily"]
[null,"Pre-Approvals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,"Sales"]
[null,"Close Out",null,null,null,null,null,null,null,null,null,"Yes",0.04,null,null,null,null,null,null,null,null,"District 9",11]
[null,null,null,null,null,null,null,null,null,null,null,"No",0.09,null,null,null,null,null,null,null,null,"District 10",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ADA MAE FAUBION EL",13.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ALLISON EL",13.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ALTAMIRA ACADEMY",14.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANDERSON MILL EL",14.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANDREWS EL",14.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNIE PURL EL",15.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUSTIN DISCOVERY SCH",15.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUSTIN ISD CHILD DEVELOPMENT CENTE",15.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BAGDAD EL",15.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BALDWIN EL",16.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BARANOFF EL",16.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BARRINGTON EL",16.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BARTON CREEK EL",16.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BARTON HILLS EL",16.059999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BATY EL",17.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BECKER EL",17.059999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BEE CAVE EL",17.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BILL BURDEN EL",17.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLACKLAND PRAIRIE EL",17.13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLACKSHEAR EL",17.14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLAKE MANOR EL",17.16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLANTON EL",17.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLAZIER EL",17.190000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLOCK HOUSE CREEK EL",17.22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLUEBONNET EL",17.28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLUEBONNET TRAIL EL",17.29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BOONE EL",17.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRENTWOOD EL",17.38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRIDGE POINT EL",17.399999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BROOKE EL",17.420000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BROOKHOLLOW EL",17.45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BROWN EL",17.46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRUSHY CREEK EL",17.47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRYKER WOODS EL",17.48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C C MASON EL",17.489999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CACTUS RANCH EL",17.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALDWELL EL",17.510000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALDWELL HEIGHTS EL",17.52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAMPBELL EL",17.53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CANYON CREEK EL",17.54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CARVER EL",17.55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CASEY EL",17.559999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CASIS EL",17.57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEDAR CREEK EL",17.600000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEDARS INTERNATIONAL ACADEMY",17.61]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHANDLER OAKS EL",17.649999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHARLOTTE COX EL",17.690000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHRISTINE CAMACHO EL",17.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CLAUDE BERKMAN EL",17.72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CLAYTON EL",17.739999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COOK EL",17.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COPPERFIELD EL",17.760000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COTTONWOOD CREEK EL",17.77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COUPLAND EL",17.809999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COWAN EL",17.82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CREEDMOOR EL",17.829999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CUNNINGHAM EL",17.84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CYPRESS EL",17.850000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DAEP- EL",17.86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DAVIS EL",18.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DAWSON EL",18.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEARING EL",18.059999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DECKER EL",18.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEEPWOOD EL",18.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEER CREEK EL",18.13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEL VALLE EL",18.170000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DELCO PRI",18.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DELL PICKETT EL",18.190000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEPELCHIN-RICHMOND",18.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DESSAU EL",18.21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DOBIE PK CENTER",18.22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DOSS EL",18.23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DOUBLE FILE TRAIL EL",18.239999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EANES EL",18.260000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EDEN PARK ACADEMY",18.28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EL DAEP",18.29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELSA ENGLAND EL",18.32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FERN BLUFF EL",18.329999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FLORENCE EL",18.34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOREST CREEK EL",18.350000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOREST NORTH EL",18.39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOREST TRAIL EL",18.399999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FROST EL",18.41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GALINDO EL",18.420000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GATTIS EL",18.43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GEORGE M KOZMETSKY SCHOOL",18.440000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GOODWATER MONTESSORI SCHOOL",18.45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GOVALLE EL",18.46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRAHAM EL",18.47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRANDVIEW HILLS EL",18.48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GREAT OAKS EL",18.489999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GUERRERO THOMPSON",18.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GULLETT EL",18.510000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HARMONY SCHOOL OF INNOVATION - AUS",18.559999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HARMONY SCHOOL OF SCIENCE - AUSTIN",18.57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HARMONY SCIENCE ACADEMY - AUSTIN",18.63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HARMONY SCIENCE ACADEMY - CEDAR PA",18.64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HARRIS EL",19.010000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HART EL",19.079999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HELPING HAND",19.100000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIGHLAND PARK EL",19.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIGHLAND PARK EL",19.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HILL EL",19.13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HILLCREST EL",19.14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HORNSBY-DUNLAP EL",19.149999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOUSTON EL",19.170000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOWARD NORMAN EL",19.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUTTO EL",19.190000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JAMES E MITCHELL EL",20.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JARRELL EL",20.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JARRELL INT",20.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JIM PLAIN EL",20.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JO ANN FORD EL",21.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JOE LEE JOHNSON EL",21.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JOLLYVILLE EL",21.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JORDAN EL",21.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JOSEPH GILBERT EL",21.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JOSLIN EL",21.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KATHY CARAWAY EL",21.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KIKER EL",21.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KIPP AUSTIN COMUNIDAD",21.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KIPP AUSTIN CONNECTIONS EL",21.13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KIPP AUSTIN LEADERSHIP EL",22.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KIPP AUSTIN OBRAS",22.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KOCUREK EL",22.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAGO VISTA EL",22.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAGO VISTA INT",22.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAGOS EL",22.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAKE POINTE EL",22.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAKE TRAVIS EL",22.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAKEWAY EL",23.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LANGFORD EL",23.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAURA WELCH BUSH EL",23.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LAUREL MOUNTAIN EL",23.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEE EL",23.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIBERTY HILL EL",23.13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINDA HERRINGTON EL",23.14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINDER EL",23.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIVE OAK EL",23.16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOIS F GIDDENS EL",23.17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAGNOLIA MONTESSORI FOR ALL",23.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAIN STREET INT",23.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MANOR EL",24.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAPLEWOOD EL",24.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MATHEWS EL",24.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MCBEE EL",24.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MENCHACA EL",24.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"METZ EL",24.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MILLS EL",24.12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONTA JANE AKIN EL",24.13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOTT EL",24.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MURCHISON EL",24.21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NADINE JOHNSON EL",24.22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NAOMI PASEMANN EL",24.23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEW PRE-K CENTER",24.24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEYSA CALLISON EL",24.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORMAN EL",24.26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTHWEST EL",24.27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NYOS - MAGNOLIA MCCULLOUGH CAMPUS",24.28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OAK HILL EL",24.29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OAK MEADOWS EL",24.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OAK SPRINGS EL",24.31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ODOM EL",24.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OFFICER LEONARD A REED EL",24.34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OLD TOWN EL",24.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OLYMPIA HILLS",25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ORTEGA EL",203.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OVERTON EL",203.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PADRON EL",204.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PALM EL",204.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PARKSIDE EL",204.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PARMER LANE EL",204.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAT COOPER EL",204.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PATRICIA KNOWLES EL",204.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PATSY SOMMER EL",204.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PATTON EL",204.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAULINE NAUMANN EL",205.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PEASE EL",205.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PECAN SPRINGS EL",205.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PEREZ EL",205.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PFLUGERVILLE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PICKLE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PILLOW EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PIONEER CROSSING EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLEASANT HILL EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLEASANT HILL EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POND SPRINGS EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POPHAM EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRESIDENTIAL MEADOWS EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PURPLE SAGE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RANCHO SIENNA EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAY EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAYE MCCOY EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"READ PRE-K CENTER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REAL LEARNING ACADEMY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REILLY EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIDGETOP EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIOJAS EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIVER OAKS EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIVER PLACE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIVER RIDGE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RODRIGUEZ EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RONALD REAGAN EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROWE LANE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RUTH BARRON EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RUTLEDGE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SANCHEZ EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SERENE HILLS EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHADOWGLEN EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SIMS EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SMITH EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPICEWOOD EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPRINGHILL EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST ELMO EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STEINER RANCH EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUMMITT EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUNSET VALLEY EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TERAVISTA EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEXAS EMPOWERMENT ACADEMY EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TH JOHNSON EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THE EAST AUSTIN COLLEGE PREP AT SO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"THRALL EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TIMMERMAN EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRAVIS HTS EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UNION HILL EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UNIVERSITY OF TEXAS EL CHARTER SCH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UPHAUS EARLY CHILDHOOD CENTER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VALLEY VIEW EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VETERANS HILL EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VIC ROBERTSON EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VILLAGE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WALNUT CREEK EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WEBB PRI CENTER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WELLS BRANCH EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WEST CYPRESS HILLS EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTSIDE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WHITESTONE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WIDEN EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WIELAND EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WILLIAM J WINKLEY EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WILLIAMS EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WINDERMERE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WINDERMERE PRI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WINN EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WOOLDRIDGE EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WOOTEN EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XENIA VOIGT EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZAVALA EL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZILKER EL"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Project Timeline"]
[null,null,"Start Date","Duration"]
[null,"Acquisition",{"$f":"C34","v":"00:00:00"},{"$f":"D34-C34","v":0}]
[null,"Zoning",{"$f":"C35","v":"00:00:00"},{"$f":"D35-C35","v":0}]
[null,"Environmental Review",{"$f":"C36","v":"00:00:00"},{"$f":"D36-C36","v":0}]
[null,"Closing of All Financing",{"$f":"C37","v":"00:00:00"},{"$f":"D37-C37","v":0}]
[null,"Development Services Review",{"$f":"C38","v":"00:00:00"},{"$f":"D38-C38","v":0}]
[null,"Site Preparation",{"$f":"C40","v":"00:00:00"},{"$f":"D40-C40","v":0}]
[null,"25% Complete",{"$f":"C41","v":"1900-01-01"},{"$f":"D41-C41","v":-1}]
[null,"50% Complete",{"$f":"C42","v":"1900-01-01"},{"$f":"D42-C42","v":-1}]
[null,"75% Complete",{"$f":"C43","v":"1900-01-01"},{"$f":"D43-C43","v":-1}]
[null,"100% Complete",{"$f":"C44","v":"1900-01-01"},{"$f":"D44-C44","v":-1}]
[null,"Marketing",{"$f":"C46","v":"00:00:00"},{"$f":"D46-C46","v":0}]
[null,"Pre-Approvals",{"$f":"C47","v":"00:00:00"},{"$f":"D47-C47","v":0}]
[null,"Sales",{"$f":"C48","v":"00:00:00"},{"$f":"D48-C48","v":0}]
[null,"Close Out",{"$f":"C49","v":"00:00:00"},{"$f":"D49-C49","v":0}]

{"sheet":"Development Costs","index":5,"n_rows":150,"n_cols":17,"rows_kept":150,"cut":false,"hidden":false,"merged":[[153,1,153,3],[150,1,150,3],[145,2,145,3],[146,2,146,3],[147,2,147,3],[5,1,5,3],[5,5,5,6],[72,1,72,3],[72,5,72,6],[7,5,7,6],[8,5,8,6],[15,5,15,6],[16,5,16,6],[48,5,48,6],[48,1,48,3],[16,1,16,3],[15,1,15,3],[27,5,27,6],[27,1,27,3],[42,5,42,6],[42,1,42,3],[105,5,105,6],[130,1,130,3],[130,5,130,6],[107,5,107,6],[107,1,107,3],[118,5,118,6],[118,1,118,3],[106,5,106,6],[106,1,106,3],[73,1,73,3],[73,5,73,6],[77,1,77,3],[85,1,85,3],[85,5,85,6],[82,5,82,6],[84,1,84,3],[84,5,84,6],[75,5,75,6],[76,1,76,3],[77,5,77,6],[82,1,82,3],[141,1,141,3],[126,5,126,6],[126,1,126,3],[133,5,133,6],[133,1,133,3],[141,5,141,6],[142,1,142,3],[143,2,143,3],[144,2,144,3],[151,1,151,3],[149,5,152,6],[152,1,152,3]]}
[null,"Is Project Existing Building Acquisition or New Construction/Rehabilitation?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acquisition"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New/Rehab"]
[null,"Note: Please provide notes detailing explanations for descrepancies."]
[]
[]
[null,"Development Budget",null,null,null,"Eligible Basis"]
[null,null,"Project Cost","Requested AHFC Funds",null,"Acquisition","New/Rehab"]
[]
[null,"ACQUISITION"]
[null,"Site Acquisition Cost"]
[null,"Existing Building Acqusition Cost",0,null,null,{"$f":"IF(C1=\"Acquisition\",C11,\"-\")","v":"-"}]
[null,"Closing Costs & Acquisition Legal Fees",0]
[null,"Other Acquisition Costs (Provide Detailed Description)",null,null,null,{"$f":"IF(C1=\"Acquisition\",C13,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C13,\"-\")","v":"-"}]
[null,"Subtotal Acquisition Cost:",{"$f":"SUM(C10:C13)","v":0},{"$f":"SUM(D10:D13)","v":0},null,{"$f":"SUM(F10:F13)","v":0},{"$f":"SUM(G10:G13)","v":0}]
[]
[null,"HARD COSTS"]
[null,"HARD COSTS-Off-Site"]
[null,"Off-Site Concrete",null,null,null,null,{"$f":"IF(C1=\"New/Rehab\",C18,\"-\")","v":"-"}]
[null,"Storm Drains & Devices",null,null,null,null,{"$f":"IF(C1=\"New/Rehab\",C19,\"-\")","v":"-"}]
[null,"Water & Fire Hydrants",null,null,null,null,{"$f":"IF(C1=\"New/Rehab\",C20,\"-\")","v":"-"}]
[null,"Off-Site Utilities",null,null,null,null,{"$f":"IF(C1=\"New/Rehab\",C21,\"-\")","v":"-"}]
[null,"Sewer Lateral(s)",null,null,null,null,{"$f":"IF(C1=\"New/Rehab\",C22,\"-\")","v":"-"}]
[null,"Off-Site Paving",null,null,null,null,{"$f":"IF(C1=\"New/Rehab\",C23,\"-\")","v":"-"}]
[null,"Off-Site Electrical",null,null,null,null,{"$f":"IF(C1=\"New/Rehab\",C24,\"-\")","v":"-"}]
[null,"Other Off-Site Costs (Provide Detailed Description)",null,null,null,null,{"$f":"IF(C1=\"New/Rehab\",C25,\"-\")","v":"-"}]
[null,"Subtotal Off-Site Cost",{"$f":"SUM(C18:C25)","v":0},{"$f":"SUM(D18:D25)","v":0},null,{"$f":"SUM(F18:F25)","v":0},{"$f":"SUM(G18:G25)","v":0}]
[]
[null,"HARD COSTS-Site Work"]
[null,"Demolition"]
[null,"Asbestos Abatement (Demolition Only)"]
[null,"Detention",null,null,null,{"$f":"IF(C1=\"Acquisition\",C31,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C31,\"-\")","v":"-"}]
[null,"Rough Grading",null,null,null,{"$f":"IF(C1=\"Acquisition\",C32,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C32,\"-\")","v":"-"}]
[null,"Fine Grading",null,null,null,{"$f":"IF(C1=\"Acquisition\",C33,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C33,\"-\")","v":"-"}]
[null,"On-Site Concrete",null,null,null,{"$f":"IF(C1=\"Acquisition\",C34,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C34,\"-\")","v":"-"}]
[null,"On-Site Electrical",null,null,null,{"$f":"IF(C1=\"Acquisition\",C35,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C35,\"-\")","v":"-"}]
[null,"On-Site Paving",null,null,null,{"$f":"IF(C1=\"Acquisition\",C36,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C36,\"-\")","v":"-"}]
[null,"On-Site Utilities",null,null,null,{"$f":"IF(C1=\"Acquisition\",C37,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C37,\"-\")","v":"-"}]
[null,"Decorative Masonry",null,null,null,{"$f":"IF(C1=\"Acquisition\",C38,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C38,\"-\")","v":"-"}]
[null,"Bumper Stops, Striping & Signs",null,null,null,{"$f":"IF(C1=\"Acquisition\",C39,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C39,\"-\")","v":"-"}]
[null,"Other Site Work Costs (Provide Detailed Description)",null,null,null,{"$f":"IF(C1=\"Acquisition\",C40,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C40,\"-\")","v":"-"}]
[null,"Subtotal Site Work Cost",{"$f":"SUM(C29:C40)","v":0},{"$f":"SUM(D29:D40)","v":0},null,{"$f":"SUM(F29:F40)","v":0},{"$f":"SUM(G29:G40)","v":0}]
[]
[null,"HARD COSTS-Site Amenities"]
[null,"Landscaping",null,null,null,{"$f":"IF(C1=\"Acquisition\",C44,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C44,\"-\")","v":"-"}]
[null,"Fencing",null,null,null,{"$f":"IF(C1=\"Acquisition\",C45,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C45,\"-\")","v":"-"}]
[null,"Other Site Amenities (Provide Detailed Description)",null,null,null,{"$f":"IF(C1=\"Acquisition\",C46,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C46,\"-\")","v":"-"}]
[null,"Subtotal Site Amenities Costs",{"$f":"SUM(C44:C46)","v":0},{"$f":"SUM(D44:D46)","v":0},null,{"$f":"SUM(F44:F46)","v":0},{"$f":"SUM(G44:G46)","v":0}]
[]
[null,"HARD COSTS-Building Costs"]
[null,"Concrete",null,null,null,{"$f":"IF(C1=\"Acquisition\",C50,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C50,\"-\")","v":"-"}]
[null,"Masonry",null,null,null,{"$f":"IF(C1=\"Acquisition\",C51,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C51,\"-\")","v":"-"}]
[null,"Metals",null,null,null,{"$f":"IF(C1=\"Acquisition\",C52,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C52,\"-\")","v":"-"}]
[null,"Woods & Plastics",null,null,null,{"$f":"IF(C1=\"Acquisition\",C53,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C53,\"-\")","v":"-"}]
[null,"Thermal & Moisture Prevention",null,null,null,{"$f":"IF(C1=\"Acquisition\",C54,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C54,\"-\")","v":"-"}]
[null,"Roof Covering",null,null,null,{"$f":"IF(C1=\"Acquisition\",C55,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C55,\"-\")","v":"-"}]
[null,"Doors & Windows",null,null,null,{"$f":"IF(C1=\"Acquisition\",C56,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C56,\"-\")","v":"-"}]
[null,"Finishes",null,null,null,{"$f":"IF(C1=\"Acquisition\",C57,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C57,\"-\")","v":"-"}]
[null,"Specialties",null,null,null,{"$f":"IF(C1=\"Acquisition\",C58,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C58,\"-\")","v":"-"}]
[null,"Equipment",null,null,null,{"$f":"IF(C1=\"Acquisition\",C59,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C59,\"-\")","v":"-"}]
[null,"Furnishings",null,null,null,{"$f":"IF(C1=\"Acquisition\",C60,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C60,\"-\")","v":"-"}]
[null,"Special Construction",null,null,null,{"$f":"IF(C1=\"Acquisition\",C61,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C61,\"-\")","v":"-"}]
[null,"Conveying Systems (Elevators)",null,null,null,{"$f":"IF(C1=\"Acquisition\",C62,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C62,\"-\")","v":"-"}]
[null,"Mechanical (HVAC; Plumbing)",null,null,null,{"$f":"IF(C1=\"Acquisition\",C63,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C63,\"-\")","v":"-"}]
[null,"Electrical",null,null,null,{"$f":"IF(C1=\"Acquisition\",C64,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C64,\"-\")","v":"-"}]
[null,"Detached Community Facilities/Building",null,null,null,{"$f":"IF(C1=\"Acquisition\",C65,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C65,\"-\")","v":"-"}]
[null,"Carports and/or Garages",null,null,null,{"$f":"IF(C1=\"Acquisition\",C66,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C66,\"-\")","v":"-"}]
[null,"Lead-Based Paint Abatement",null,null,null,{"$f":"IF(C1=\"Acquisition\",C67,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C67,\"-\")","v":"-"}]
[null,"Asbestos Abatement (Rehabilitation Only)",null,null,null,{"$f":"IF(C1=\"Acquisition\",C68,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C68,\"-\")","v":"-"}]
[null,"Structured Parking",null,null,null,{"$f":"IF(C1=\"Acquisition\",C69,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C69,\"-\")","v":"-"}]
[null,"Commercial Space Costs"]
[null,"Other (Provide Detailed Description)",null,null,null,{"$f":"IF(C1=\"Acquisition\",C71,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C71,\"-\")","v":"-"}]
[null,"Subtotal Building Costs",{"$f":"SUM(C50:C71)","v":0},{"$f":"SUM(D50:D71)","v":0},null,{"$f":"SUM(F50:F71)","v":0},{"$f":"SUM(G50:G71)","v":0}]
[]
[null,"HARD COSTS-Contingency"]
[null,"Contingency",null,null,null,{"$f":"IF(C1=\"Acquisition\",C75,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C75,\"-\")","v":"-"}]
[null,"Contingency Percentage of Construction Costs(Min 5.0%; Max 7.0%)",{"$f":"C75/(SUM(C26+C41+C47+C72))","v":{"$error":"#DIV/0!"}},{"$f":"C75/(SUM(C26+C41+C47+C72))","v":{"$error":"#DIV/0!"}}]
[]
[null,"HARD COSTS-Contractor Fees"]
[null,"General Requirements",null,null,null,{"$f":"IF(C1=\"Acquisition\",C79,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C79,\"-\")","v":"-"}]
[null,"Contractor Overhead",null,null,null,{"$f":"IF(C1=\"Acquisition\",C80,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C80,\"-\")","v":"-"}]
[null,"Contractor Profit",null,null,null,{"$f":"IF(C1=\"Acquisition\",C81,\"-\")","v":"-"},{"$f":"IF(C1=\"New/Rehab\",C81,\"-\")","v":"-"}]
[null,"Total Contractor Fees",{"$f":"SUM(C79:C81)","v":0},{"$f":"SUM(D79:D81)","v":0},null,{"$f":"SUM(F79:F81)","v":0},{"$f":"SUM(G79:G81)","v":0}]
[]
[null,"Total Construction Costs with Contingency",{"$f":"C26+C41+C47+C72+C75+C82","v":0},{"$f":"D26+D41+D47+D72+D75+D82","v":0},null,{"$f":"IF(C1=\"New/Rehab\",\"\",SUM(F26+F41+F47+F72+F75+F82))","v":{"$error":"#VALUE!"}},{"$f":"IF(C1=\"New/Rehab\",SUM(G26+G41+G47+G72+G75+G82),0)","v":0}]
[]
[null,"SOFT COSTS"]
[null,"Architectural - Design Fees",null,null,null,{"$f":"IF(C1=\"Acquisition\",C87,\"-\")","v":"-"},{"$f":"IF($C$1=\"New/Rehab\",C87,\"-\")","v":"-"}]
[null,"Architectural - Supervision fees",null,null,null,{"$f":"IF(C1=\"Acquisition\",C88,\"-\")","v":"-"},{"$f":"IF($C$1=\"New/Rehab\",C88,\"-\")","v":"-"}]
[null,"Engineering Fees",null,null,null,{"$f":"IF(C1=\"Acquisition\",C89,\"-\")","v":"-"},"-"]
[null,"Real Estate Attorney/Other Legal Fees",null,null,null,{"$f":"IF(C1=\"Acquisition\",C90,\"-\")","v":"-"},"-"]
[null,"Accounting Fees",null,null,null,{"$f":"IF(C1=\"Acquisition\",C91,\"-\")","v":"-"},"-"]
[null,"Impact Fees",null,null,null,{"$f":"IF(C1=\"Acquisition\",C92,\"-\")","v":"-"},"-"]
[null,"Building Permits & Related Costs",null,null,null,{"$f":"IF(C1=\"Acquisition\",C93,\"-\")","v":"-"},"-"]
[null,"Appraisal",null,null,null,{"$f":"IF(C1=\"Acquisition\",C94,\"-\")","v":"-"},"-"]
[null,"Market Analysis",null,null,null,{"$f":"IF(C1=\"Acquisition\",C95,\"-\")","v":"-"},"-"]
[null,"Environmental Assesssment",null,null,null,{"$f":"IF(C1=\"Acquisition\",C96,\"-\")","v":"-"},"-"]
[null,"Soils Report",null,null,null,{"$f":"IF(C1=\"Acquisition\",C97,\"-\")","v":"-"},"-"]
[null,"Survey",null,null,null,{"$f":"IF(C1=\"Acquisition\",C98,\"-\")","v":"-"},{"$f":"IF($C$1=\"New/Rehab\",C98,\"-\")","v":"-"}]
[null,"Marketing"]
[null,"Hazard & Liability Insurance",null,null,null,{"$f":"IF(C1=\"Acquisition\",C100,\"-\")","v":"-"},{"$f":"IF($C$1=\"New/Rehab\",C100,\"-\")","v":"-"}]
[null,"Real Property Taxes",null,null,null,{"$f":"IF(C1=\"Acquisition\",C101,\"-\")","v":"-"},{"$f":"IF($C$1=\"New/Rehab\",C101,\"-\")","v":"-"}]
[null,"Personal Property Taxes",null,null,null,{"$f":"IF(C1=\"Acquisition\",C102,\"-\")","v":"-"},{"$f":"IF($C$1=\"New/Rehab\",C102,\"-\")","v":"-"}]
[null,"Tenant Relocation"]
[null,"Other (Provide Detailed Description)",null,null,null,{"$f":"IF(C1=\"Acquisition\",C104,\"-\")","v":"-"},{"$f":"IF($C$1=\"New/Rehab\",C104,\"-\")","v":"-"}]
[null,"Subtotal Soft Costs",{"$f":"SUM(C87:C104)","v":0},{"$f":"SUM(D87:D104)","v":0},null,{"$f":"SUM(F87:F104)","v":0},{"$f":"SUM(G87:G104)","v":0}]
[]
[null,"FINANCING"]
[null,"FINANCING-Construction Loan(s)"]
[null,"Interest (From Sources)",null,null,null,{"$f":"IF($C$1=\"Acquisition\",C109,\"-\")","v":"-"},{"$f":"IF($C$1=\"New/Rehab\",C109,\"-\")","v":"-"}]
[null,"Loan Origination Fees",null,null,null,{"$f":"IF($C$1=\"Acquisition\",C110,\"-\")","v":"-"},{"$f":"IF($C$1=\"New/Rehab\",C110,\"-\")","v":"-"}]
[null,"Title & Recording Fees",null,null,null,"-","-"]
[null,"Closing Costs & Legal Fees",null,null,null,"-","-"]
[null,"Inspection Fees",null,null,null,"-","-"]
[null,"Credit Report",null,null,null,"-","-"]
[null,"Discount Points",null,null,null,"-","-"]
[null,"Other (Provide Detailed Description)",null,null,null,{"$f":"IF($C$1=\"Acquisition\",C116,\"-\")","v":"-"},"-"]
[null,"Subtotal Construction Loan(s)",{"$f":"SUM(C109:C116)","v":0},{"$f":"SUM(D109:D116)","v":0},null,{"$f":"SUM(F109:F116)","v":0},{"$f":"SUM(G109:G116)","v":0}]
[]
[null,"FINANCING-Other Loan(s)"]
[null,"Interest",null,null,null,{"$f":"IF($C$1=\"Acquisition\",C120,\"-\")","v":"-"},{"$f":"IF($C$1=\"New/Rehab\",C120,\"-\")","v":"-"}]
[null,"Loan Origination Fees",null,null,null,{"$f":"IF($C$1=\"Acquisition\",C121,\"-\")","v":"-"},{"$f":"IF($C$1=\"New/Rehab\",C121,\"-\")","v":"-"}]
[null,"Title & Recording Fees",null,null,null,{"$f":"IF($C$1=\"Acquisition\",C122,\"-\")","v":"-"},{"$f":"IF($C$1=\"New/Rehab\",C122,\"-\")","v":"-"}]
[null,"Closing Costs & Legal Fees",null,null,null,{"$f":"IF($C$1=\"Acquisition\",C123,\"-\")","v":"-"},{"$f":"IF($C$1=\"New/Rehab\",C123,\"-\")","v":"-"}]
[null,"Other (Provide Detailed Description)",null,null,null,{"$f":"IF($C$1=\"Acquisition\",C124,\"-\")","v":"-"},{"$f":"IF($C$1=\"New/Rehab\",C124,\"-\")","v":"-"}]
[null,"Subtotal Sponsor Loan(s)",{"$f":"SUM(C120:C124)","v":0},{"$f":"SUM(D120:D124)","v":0},null,{"$f":"SUM(F120:F124)","v":0},{"$f":"SUM(G120:G124)","v":0}]
[]
[null,"Other Financing Costs"]
[null,"Payment & Performance Bonds",null,null,null,{"$f":"IF($C$1=\"Acquisition\",C128,\"-\")","v":"-"},{"$f":"IF($C$1=\"New/Rehab\",C128,\"-\")","v":"-"}]
[null,"Other (Provide Detailed Description)",null,null,null,{"$f":"IF($C$1=\"Acquisition\",C129,\"-\")","v":"-"},{"$f":"IF($C$1=\"New/Rehab\",C129,\"-\")","v":"-"}]
[null,"Subtotal Financing Cost",{"$f":"SUM(C128:C129)","v":0},{"$f":"SUM(D128:D129)","v":0},null,{"$f":"SUM(F128:F129)","v":0},{"$f":"SUM(G128:G129)","v":0}]
[]
[null,"Total Financing Costs",{"$f":"SUM(C117+C125+C130)","v":0},{"$f":"SUM(D117+D125+D130)","v":0},null,{"$f":"SUM(F117+F125+F130)","v":0},{"$f":"SUM(G117+G125+G130)","v":0}]
[]
[null,"DEVELOPER FEE"]
[null,"Housing Consultant Fees",null,null,null,{"$f":"IF($C$1=\"Acquisition\",C135,\"-\")","v":"-"},{"$f":"IF($C$1=\"New/Rehab\",C135,\"-\")","v":"-"}]
[null,"General & Administrative",null,null,null,{"$f":"IF($C$1=\"Acquisition\",C136,\"-\")","v":"-"},{"$f":"IF($C$1=\"New/Rehab\",C136,\"-\")","v":"-"}]
[null,"Profit & Fee",null,null,null,{"$f":"IF($C$1=\"Acquisition\",C137,\"-\")","v":"-"},{"$f":"IF($C$1=\"New/Rehab\",C137,\"-\")","v":"-"}]
[null,"Subtotal Developer Fees",{"$f":"SUM(C135:C137)","v":0},{"$f":"SUM(D135:D137)","v":0},null,{"$f":"SUM(F135:F137)","v":0},{"$f":"SUM(G135:G137)","v":0}]
[]
[null,"Total Development Costs",{"$f":"SUM(C14+C84+C105+C132+C138)","v":0},{"$f":"SUM(D14+D84+D105+D130+D138)","v":0},null,{"$f":"IF(C1=\"Acquisition\",SUM(F14+F84+F105+F132+F138),0)","v":0},{"$f":"IF(C1=\"New/Rehab\",SUM(G14+G84+G105+G132+G138),0)","v":0}]
[]
[null,"*Detailed Descriptions of \"Other\" Line Items",null,null,null,"Eligible Basis Calculation"]
[null,"**Must breakout each item included in \"Other\" and corresponding cost**",null,null,null,"Total Development Cost",{"$f":"C14+C84+C105+C132+C138","v":0}]
[null,null,null,null,null,"Total Eligible Basis",{"$f":"IF(C1=\"Acquisition\",SUM(F14+F84+F105+F130+F138),IF(C1=\"New/Rehab\",SUM(G14+G84+G105+G130+G138),0))","v":0}]
[null,{"$f":"IF(C119=\"\", \"\", TEXT(C119, \"$#,##\")&\" Other Pre-Development Costs\")","v":""},null,null,null,"Developer Fee % of Eligible Basis*(Max 15.0%)",{"$f":"C138/(G144-C138)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[null,"*Structures in a rehabilitation development are not included in eligible basis.",null,null,null,"* Developer fee at application must be maintained throughout the development process. A final accounting will occur at conversion, where excess proceeds will pay down the loan principle."]

{"sheet":"Sources & Uses","index":6,"n_rows":31,"n_cols":18,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,11,30,13],[15,11,15,16],[17,8,17,9],[18,8,18,9],[0,0,1,16],[2,0,2,16],[15,1,15,6],[4,1,4,9],[16,11,16,12],[5,11,5,12],[4,11,4,13]]}
[{"$f":"'Project Overview'!C5","v":0}]
[]
[{"$f":"'Project Overview'!G5","v":0}]
[]
[null,"Sources Breakdown",null,null,null,null,null,null,null,null,null,"Sources",null,null,null,"Developer Fee Percentage "]
[null,"Type of Funds","Source of Funds","Committed?","If No, Additional Details","Interest Rate","Loan Amount","Loan Term (months)","Interest","Total Amount w/ Interest",null,"Financing Sources*",null,"% of Total",null,"Eligible Basis",{"$f":"'Development Costs'!G144","v":0}]
[null,"AHFC Funding Request","AHFC","No","Not Yet Awarded",0,null,60,{"$f":"SUM((50%*G7*F7)/12*H7)","v":0},{"$f":"G7+I7","v":0},null,"Hard Debt",{"$f":"SUMIF($B$7:$B$15, $L7, $J$7:$J$15)","v":0},{"$f":"IF(M7=0,\"\",M7/$M$14)","v":""},null,"Developer Fee",{"$f":"'Development Costs'!C138","v":0}]
[null,null,null,null,null,null,null,null,0,0,null,"Soft Debt",0,{"$f":"IF(M8=0,0,M8/$M$14)","v":0},null,"Eligible Basis Minus Developer Fee",{"$f":"Q6-Q7","v":0}]
[null,null,null,null,null,null,null,null,0,0,null,"Other Loan(s)",0,0,null,"Developer Fee % of Eligible Basis",{"$f":"'Development Costs'!G145","v":{"$error":"#DIV/0!"}},"*cannot be over 15%"]
[null,null,null,null,null,null,null,null,0,0,null,"Grant",0,0,null,"* Developer fee at application must be maintained throughout the development process. A final accounting will occur at project closeout where excess proceeds will be required to pay down AHFC's loan principle."]
[null,null,null,null,null,null,null,null,0,0,null,"Federal Grant",{"$f":"SUMIF($B$7:$B$15, $L11, $J$7:$J$15)","v":0},0]
[null,null,null,null,null,null,null,null,0,0,null,"Other",0,0]
[null,null,null,null,null,null,null,null,0,0,null,"AHFC Funding Request",0,0]
[null,null,null,null,null,null,null,null,0,0,null,"Total Sources of Funds:",{"$f":"SUM(M7:M13)","v":0},{"$f":"SUM(N7:N13)","v":0}]
[null,null,null,null,null,null,null,null,0,0]
[null,"Total Sources of Financed Funds:",null,null,null,null,null,null,{"$f":"SUM(I7:I15)","v":0},{"$f":"SUM(J7:J15)","v":0},null,"Uses"]
[null,"*Interest rate calculation takes into consideration a 24 month borrowing period",null,null,null,null,null,null,null,null,null,"Total Project Development Costs",null,"% Total",null,"AHFC Use of Funds Requested","% Total"]
[null,"**Calculation to find loan amount based on final total with interest. Total amount with interest/(1+interest rate)",null,null,null,null,null,null,"Gap Between Sources and Uses",null,null,"Acquisition Costs",{"$f":"'Development Costs'!C14","v":0},{"$f":"IF(M18=0,0,M18/$M$30)","v":0},null,{"$f":"'Development Costs'!D14","v":0},{"$f":"IF(P18=0,0,P18/$N$30)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"M30-M14","v":0},null,null,"Hard Costs-Off Site",{"$f":"'Development Costs'!C26","v":0},0,null,{"$f":"'Development Costs'!D26","v":0},{"$f":"IF(P19=0,0,P19/$N$30)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Hard Costs-Site Work",{"$f":"'Development Costs'!C41","v":0},0,null,{"$f":"'Development Costs'!D41","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,"Hard Costs-Site Amenities",{"$f":"'Development Costs'!C47","v":0},0,null,{"$f":"'Development Costs'!D47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,"Hard Costs-Building Costs",{"$f":"'Development Costs'!C72","v":0},0,null,{"$f":"'Development Costs'!D72","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,"Hard Costs-Contingency",{"$f":"'Development Costs'!C75","v":0},0,null,{"$f":"'Development Costs'!D75","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,"Hard Costs-Contractor Fees",{"$f":"'Development Costs'!C82","v":0},0,null,{"$f":"'Development Costs'!D82","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,"Soft Costs",{"$f":"'Development Costs'!C105","v":0},0,null,{"$f":"'Development Costs'!D105","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,"Financing Costs-Construction Loan(s)",{"$f":"'Development Costs'!C117","v":0},0,null,{"$f":"'Development Costs'!D117","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,"Financing Costs-Other Loan(s)",{"$f":"'Development Costs'!C125","v":0},0,null,{"$f":"'Development Costs'!D125","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,"Financing Cost-Other Financing",{"$f":"'Development Costs'!C130","v":0},0,null,{"$f":"'Development Costs'!D130","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,"Developer Fees",{"$f":"'Development Costs'!C138","v":0},0,null,{"$f":"'Development Costs'!D138","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,"Total Uses of Funds:",{"$f":"SUM(M18:M29)","v":0},{"$f":"SUM(N18:N29)","v":0},null,{"$f":"SUM(P18:P29)","v":0},{"$f":"SUM(Q18:Q29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"*Total Sources should equal total Uses of funds",null,null,null,"*If P29 is red, the use amount does not match the requested amount "]

{"sheet":"Unit Mix, Sales Data","index":7,"n_rows":98,"n_cols":32,"rows_kept":98,"cut":false,"hidden":false,"merged":[[58,7,58,8],[60,7,60,8],[42,19,42,22],[28,5,28,6],[27,5,27,6],[29,5,29,6],[30,14,30,15],[57,7,57,8],[52,7,52,8],[59,7,59,8],[46,7,46,8],[47,7,47,8],[48,7,48,8],[49,7,49,8],[32,11,32,16],[33,11,33,16],[55,7,55,8],[56,7,56,8],[51,7,51,8],[8,17,8,23],[43,4,43,8],[39,11,39,16],[40,4,40,8],[32,3,32,9],[1,17,1,23],[2,17,2,23],[50,7,50,8],[53,7,53,8],[54,7,54,8],[1,3,1,15]]}
[]
[null,null,null,"Unit Mix"]
[null,null,"Model Name","Median Family Income (MFI)","Unit Count","Bedrooms","Per Unit Sq Ft","Total Sq Ft Per Unit Type","Cost Per Sq Ft","Total Cost/Unit","Total Cost All Units","Sales Price","Estimated Gross Sales",null,"Sales Price (per current AHFC Pricing)","Estimated Gross Sales"]
[null,{"$f":"IF(D4=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L43,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E4<>\"\", \"Model 1\", \"\")","v":""},null,null,null,null,{"$f":"IF(G4=\"\",\"\",G4*E4)","v":""},{"$f":"IF(D4=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},{"$f":"IF(D4=\"\",\"\",G4*I4)","v":""},{"$f":"IF(D4=\"\",\"\",J4*E4)","v":""},null,{"$f":"IF(D4=\"\",\"\",(L4*E4))","v":""},null,{"$f":"IF(OR(D4=\"MKT\", D4=\"Commercial\"), L4, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B4)*($U$45:$U$98=D4)*($V$45:$V$98=F4), $W$45:$W$98), 0))","v":0},{"$f":"IF(D4=\"\",\"\",(O4*E4))","v":""}]
[null,{"$f":"IF(D5=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L44,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E5<>\"\", \"Model 2\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D5=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,{"$f":"IF(D5=\"\",\"\",(L5*E5))","v":""},null,{"$f":"IF(OR(D5=\"MKT\", D5=\"Commercial\"), L5, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B5)*($U$45:$U$98=D5)*($V$45:$V$98=F5), $W$45:$W$98), 0))","v":0},""]
[null,{"$f":"IF(D6=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L45,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E6<>\"\", \"Model 3\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D6=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D6=\"MKT\", D6=\"Commercial\"), L6, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B6)*($U$45:$U$98=D6)*($V$45:$V$98=F6), $W$45:$W$98), 0))","v":0},""]
[null,{"$f":"IF(D7=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L46,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E7<>\"\", \"Model 4\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D7=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D7=\"MKT\", D7=\"Commercial\"), L7, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B7)*($U$45:$U$98=D7)*($V$45:$V$98=F7), $W$45:$W$98), 0))","v":0},""]
[null,{"$f":"IF(D8=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L47,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E8<>\"\", \"Model 5\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D8=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D8=\"MKT\", D8=\"Commercial\"), L8, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B8)*($U$45:$U$98=D8)*($V$45:$V$98=F8), $W$45:$W$98), 0))","v":0},""]
[null,{"$f":"IF(D9=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L48,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E9<>\"\", \"Model 6\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D9=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D9=\"MKT\", D9=\"Commercial\"), L9, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B9)*($U$45:$U$98=D9)*($V$45:$V$98=F9), $W$45:$W$98), 0))","v":0},""]
[null,{"$f":"IF(D10=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L49,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E10<>\"\", \"Model 7\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D10=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D10=\"MKT\", D10=\"Commercial\"), L10, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B10)*($U$45:$U$98=D10)*($V$45:$V$98=F10), $W$45:$W$98), 0))","v":0},""]
[null,{"$f":"IF(D11=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L50,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E11<>\"\", \"Model 8\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D11=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D11=\"MKT\", D11=\"Commercial\"), L11, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B11)*($U$45:$U$98=D11)*($V$45:$V$98=F11), $W$45:$W$98), 0))","v":0},""]
[null,{"$f":"IF(D12=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L51,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E12<>\"\", \"Model 9\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D12=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D12=\"MKT\", D12=\"Commercial\"), L12, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B12)*($U$45:$U$98=D12)*($V$45:$V$98=F12), $W$45:$W$98), 0))","v":0},""]
[null,{"$f":"IF(D13=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L52,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E13<>\"\", \"Model 10\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D13=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D13=\"MKT\", D13=\"Commercial\"), L13, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B13)*($U$45:$U$98=D13)*($V$45:$V$98=F13), $W$45:$W$98), 0))","v":0},""]
[null,{"$f":"IF(D14=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L53,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E14<>\"\", \"Model 11\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D14=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D14=\"MKT\", D14=\"Commercial\"), L14, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B14)*($U$45:$U$98=D14)*($V$45:$V$98=F14), $W$45:$W$98), 0))","v":0},""]
[null,{"$f":"IF(D15=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L54,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E15<>\"\", \"Model 12\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D15=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D15=\"MKT\", D15=\"Commercial\"), L15, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B15)*($U$45:$U$98=D15)*($V$45:$V$98=F15), $W$45:$W$98), 0))","v":0},""]
[null,{"$f":"IF(D16=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L55,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E16<>\"\", \"Model 13\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D16=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D16=\"MKT\", D16=\"Commercial\"), L16, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B16)*($U$45:$U$98=D16)*($V$45:$V$98=F16), $W$45:$W$98), 0))","v":0},""]
[null,{"$f":"IF(D17=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L56,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E17<>\"\", \"Model 14\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D17=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D17=\"MKT\", D17=\"Commercial\"), L17, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B17)*($U$45:$U$98=D17)*($V$45:$V$98=F17), $W$45:$W$98), 0))","v":0},""]
[null,{"$f":"IF(D18=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L57,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E18<>\"\", \"Model 15\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D18=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D18=\"MKT\", D18=\"Commercial\"), L18, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B18)*($U$45:$U$98=D18)*($V$45:$V$98=F18), $W$45:$W$98), 0))","v":0},""]
[null,{"$f":"IF(D19=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L58,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E19<>\"\", \"Model 16\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D19=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D19=\"MKT\", D19=\"Commercial\"), L19, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B19)*($U$45:$U$98=D19)*($V$45:$V$98=F19), $W$45:$W$98), 0))","v":0},""]
[null,{"$f":"IF(D20=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L59,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E20<>\"\", \"Model 17\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D20=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D20=\"MKT\", D20=\"Commercial\"), L20, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B20)*($U$45:$U$98=D20)*($V$45:$V$98=F20), $W$45:$W$98), 0))","v":0},""]
[null,{"$f":"IF(D21=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L60,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E21<>\"\", \"Model 18\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D21=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D21=\"MKT\", D21=\"Commercial\"), L21, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B21)*($U$45:$U$98=D21)*($V$45:$V$98=F21), $W$45:$W$98), 0))","v":0},""]
[null,{"$f":"IF(D22=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L61,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E22<>\"\", \"Model 19\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D22=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D22=\"MKT\", D22=\"Commercial\"), L22, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B22)*($U$45:$U$98=D22)*($V$45:$V$98=F22), $W$45:$W$98), 0))","v":0},"",null,null,null,null,{"$f":"IF(D22=\"\",\"\",IF(D22=\"MKT\",\"Market Rate Units\",\"HDA Program Units\"))","v":""},{"$f":"IF(U22=\"HDA Program Units\",F22,\"\")","v":""},{"$f":"IF(U22=\"HDA Program Units\",G22,\"\")","v":""}]
[null,{"$f":"IF(D23=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L62,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E23<>\"\", \"Model 20\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D23=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D23=\"MKT\", D23=\"Commercial\"), L23, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B23)*($U$45:$U$98=D23)*($V$45:$V$98=F23), $W$45:$W$98), 0))","v":0},"",null,null,null,null,"","",""]
[null,{"$f":"IF(D24=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L63,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E24<>\"\", \"Model 21\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D24=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D24=\"MKT\", D24=\"Commercial\"), L24, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B24)*($U$45:$U$98=D24)*($V$45:$V$98=F24), $W$45:$W$98), 0))","v":0},"",null,null,null,null,"","",""]
[null,{"$f":"IF(D25=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L64,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E25<>\"\", \"Model 22\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D25=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D25=\"MKT\", D25=\"Commercial\"), L25, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B25)*($U$45:$U$98=D25)*($V$45:$V$98=F25), $W$45:$W$98), 0))","v":0},"",null,null,null,null,"","",""]
[null,{"$f":"IF(D26=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L65,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E26<>\"\", \"Model 23\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D26=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D26=\"MKT\", D26=\"Commercial\"), L26, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B26)*($U$45:$U$98=D26)*($V$45:$V$98=F26), $W$45:$W$98), 0))","v":0},"",null,null,null,null,"","",""]
[null,{"$f":"IF(D27=\"\",\"\",IF(OR('Project Overview'!$C$13='Project Overview'!$L$41,'Project Overview'!$C$13='Project Overview'!$L$42,'Project Overview'!$C$13='Project Overview'!$L66,'Project Overview'!$L$44,'Project Overview'!$C$13='Project Overview'!$L$45),\"Single Family\",\"Condos\"))","v":""},{"$f":"IF(E27<>\"\", \"Model 24\", \"\")","v":""},null,null,null,null,"",{"$f":"IF(D27=\"\",\"\",'Development Costs'!$C$140/'Unit Mix, Sales Data'!$H$28)","v":""},"","",null,"",null,{"$f":"IF(OR(D27=\"MKT\", D27=\"Commercial\"), L27, IFERROR(_xlfn.XLOOKUP(1, ($T$45:$T$98=B27)*($U$45:$U$98=D27)*($V$45:$V$98=F27), $W$45:$W$98), 0))","v":0},null,null,null,null,null,"","",""]
[null,null,null,"Total Units:",{"$f":"SUM(E4:E27)","v":0},"Total Square Footage:",null,{"$f":"SUM(H4:H27)","v":0},null,null,null,"Total Potential Gross Revenue:",{"$f":"SUM(M4:M27)","v":0},null,"Total Potential Gross Revenue:",{"$f":"SUM(P4:P27)","v":0}]
[null,null,null," \" HDA Program Units\":",{"$f":"Total_Units-E30","v":0}," \" HDA Program Units\":",null,{"$f":"H28-H30","v":0},null,null,null," \" HDA Program Units\":",{"$f":"M28-M30","v":0},null," \" HDA Program Units\":",{"$f":"P28-P30","v":0}]
[null,null,null," \" Market Rate\":",{"$f":"SUMIF(D4:D27, \"MKT\", E4:E27)","v":0},"\" Market Rate\":",null,{"$f":"SUMIF(D4:D27, \"MKT\", H4:H27)","v":0},null,null,null,"\" Market Rate\":",{"$f":"SUMIF(D4:D27,\"MKT\", M4:M27)","v":0},null,"\" Market Rate\":",{"$f":"SUMIF(D4:D27,\"MKT\", P4:P27)","v":0}]
[null,null,null,"% Market Units/Commercial Units",{"$f":"(SUMIFS(E4:E27, D4:D27, \"MKT\") + SUMIFS(E4:E27, D4:D27, \"Commercial\"))/Total_Units","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"UNIT MIX",null,null,null,null,null,null,null,"AHFC Max Affordable Pricing 2025-2026"]
[null,null,null,"Income Level","Studio","1 Bedroom","2 Bedroom","3 Bedroom","4 Bedroom","Total",null,"SFR/ Towhnome/ Condo (not stacked, 2+ units same parcel, condo regime)"]
[null,null,null,0.6,{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 0.6, $F$4:$F$27, 0)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 0.6, $F$4:$F$27, 1)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 0.6, $F$4:$F$27, 2)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 0.6, $F$4:$F$27, 3)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 0.6, $F$4:$F$27, 4)","v":0},{"$f":"SUM(E35:I35)","v":0},null,null,"60% MFI","65% MFI","70% MFI","80% MFI","100% MFI"]
[null,null,null,0.65,{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 0.65, $F$4:$F$27, 0)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 0.65, $F$4:$F$27, 1)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 0.65, $F$4:$F$27, 2)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 0.65, $F$4:$F$27, 3)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 0.65, $F$4:$F$27, 4)","v":0},0,null,"1BR",184900,184900,207000,228900,252500]
[null,null,null,0.7,{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 0.7, $F$4:$F$27, 0)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 0.7, $F$4:$F$27, 1)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 0.7, $F$4:$F$27, 2)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 0.7, $F$4:$F$27, 3)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 0.7, $F$4:$F$27, 4)","v":0},0,null,"2BR",215600,215600,240700,265900,292800]
[null,null,null,0.8,{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 0.8, $F$4:$F$27, 0)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 0.8, $F$4:$F$27, 1)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 0.8, $F$4:$F$27, 2)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 0.8, $F$4:$F$27, 3)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 0.8, $F$4:$F$27, 4)","v":0},0,null,"3BR",246200,189400,274200,302700,333000]
[null,null,null,1,{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 1, $F$4:$F$27, 0)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 1, $F$4:$F$27, 1)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 1, $F$4:$F$27, 2)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 1, $F$4:$F$27,3 )","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, 1, $F$4:$F$27, 4)","v":0},0,null,"4BR",276500,276500,307900,339500,373100]
[null,null,null,"Market Rate Units",{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, \"MKT\", $F$4:$F$27, 0)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, \"MKT\", $F$4:$F$27, 1)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, \"MKT\", $F$4:$F$27, 2)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, \"MKT\", $F$4:$F$27, 3)","v":0},{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, \"MKT\", $F$4:$F$27, 4)","v":0},0,null,"Stacked Flat Multi-Family Condo Pricing "]
[null,null,null,"Commercial Units",null,null,null,null,null,{"$f":"SUMIFS($E$4:$E$27, $D$4:$D$27, \"Commercial\", $F$4:$F$27, \"\")","v":0},null,null,"60% MFI","65% MFI","70% MFI","80% MFI","100% MFI",null,null,null,null,null,null,null,null,null,null,0.3,null,null,0]
[null,null,null,"Totals",{"$f":"SUM(E35:E40)","v":0},{"$f":"SUM(F35:F40)","v":0},{"$f":"SUM(G35:G40)","v":0},{"$f":"SUM(H35:H40)","v":0},{"$f":"SUM(I35:I40)","v":0},{"$f":"SUM(J35:J41)","v":0},null,"Studio/ 1BR",172700,172700,194700,216600,240200,null,null,null,null,null,null,null,null,null,null,null,0.4,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,"2BR",204100,204100,229300,254500,282200,null,null,"Pricing Lookup Table",null,null,null,null,null,null,null,null,0.5,null,null,2]
[null,null,null,null,"Average Square Foot AHFC Units",null,null,null,null,null,null,"3BR",237100,237100,265200,293700,323900,null,null,"Building Type","MFI","Bedrooms","AHFC Price",null,null,null,null,null,0.6,null,null,3]
[null,null,null,null,"Studio","1 Bedroom","2 Bedroom","3 Bedroom","4 Bedroom",null,null,"4BR",269900,269900,301300,332900,368100,null,null,"Single Family",0.6,1,{"$f":"M36","v":184900},null,null,null,null,null,0.7,null,null,4]
[null,null,null,null,{"$f":"IFERROR(SUM(SUMIFS($H$4:$H$27,$D$4:$D$27,$AC$41:$AC$49,$F$4:$F$27,$AE$41))/SUM(SUMIFS($E$4:$E$27,$D$4:$D$27,$AC$41:$AC$49,$F$4:$F$27,$AE$41)),\"\")","v":""},{"$f":"IFERROR(SUM(SUMIFS($H$4:$H$27,$D$4:$D$27,$AC$41:$AC$49,$F$4:$F$27,$AF$42))/SUM(SUMIFS($E$4:$E$27,$D$4:$D$27,$AC$41:$AC$49,$F$4:$F$27,$AF$42)),\"\")","v":""},{"$f":"IFERROR(SUM(SUMIFS($H$4:$H$27,$D$4:$D$27,$AC$41:$AC$49,$F$4:$F$27,$AF$43))/SUM(SUMIFS($E$4:$E$27,$D$4:$D$27,$AC$41:$AC$49,$F$4:$F$27,$AF$43)),\"\")","v":""},{"$f":"IFERROR(SUM(SUMIFS($H$4:$H$27,$D$4:$D$27,$AC$41:$AC$49,$F$4:$F$27,$AF$44))/SUM(SUMIFS($E$4:$E$27,$D$4:$D$27,$AC$41:$AC$49,$F$4:$F$27,$AF$44)),\"\")","v":""},{"$f":"IFERROR(SUM(SUMIFS($H$4:$H$27,$D$4:$D$27,$AC$41:$AC$49,$F$4:$F$27,$AF$45))/SUM(SUMIFS($E$4:$E$27,$D$4:$D$27,$AC$41:$AC$49,$F$4:$F$27,$AF$45)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Single Family",0.6,2,{"$f":"M37","v":215600},null,null,null,null,null,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",0.6,3,{"$f":"M38","v":246200},null,null,null,null,null,0.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",0.6,4,{"$f":"M39","v":276500},null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",0.65,1,{"$f":"N36","v":184900},null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",0.65,2,{"$f":"N37","v":215600},null,null,null,null,null,"MKT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",0.65,3,{"$f":"N38","v":189400},null,null,null,null,null,"Commercial"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",0.65,4,{"$f":"N39","v":276500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",0.7,1,{"$f":"O36","v":207000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",0.7,2,{"$f":"O37","v":240700}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",0.7,3,{"$f":"O38","v":274200}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",0.7,4,{"$f":"O39","v":307900}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",0.8,1,{"$f":"P36","v":228900}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",0.8,2,{"$f":"P37","v":265900}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",0.8,3,{"$f":"P38","v":302700}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",0.8,4,{"$f":"P39","v":339500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",1,1,{"$f":"Q36","v":252500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",1,2,{"$f":"Q37","v":292800}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",1,3,{"$f":"Q38","v":333000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",1,4,{"$f":"Q39","v":373100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",1.2,1,{"$f":"R36","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",1.2,2,{"$f":"R37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",1.2,3,{"$f":"R38","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family",1.2,4,{"$f":"R39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",0.6,0,{"$f":"M42","v":172700}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",0.6,1,{"$f":"M42","v":172700}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",0.6,2,{"$f":"M43","v":204100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",0.6,3,{"$f":"M44","v":237100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",0.6,4,{"$f":"M45","v":269900}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",0.65,0,{"$f":"N42","v":172700}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",0.65,1,{"$f":"N42","v":172700}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",0.65,2,{"$f":"N43","v":204100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",0.65,3,{"$f":"N44","v":237100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",0.65,4,{"$f":"N45","v":269900}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",0.7,0,{"$f":"O42","v":194700}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",0.7,1,{"$f":"O42","v":194700}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",0.7,2,{"$f":"O43","v":229300}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",0.7,3,{"$f":"O44","v":265200}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",0.7,4,{"$f":"O45","v":301300}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",0.8,0,{"$f":"P42","v":216600}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",0.8,1,{"$f":"P42","v":216600}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",0.8,2,{"$f":"P43","v":254500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",0.8,3,{"$f":"P44","v":293700}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",0.8,4,{"$f":"P45","v":332900}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",1,0,{"$f":"Q42","v":240200}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",1,1,{"$f":"Q42","v":240200}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",1,2,{"$f":"Q43","v":282200}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",1,3,{"$f":"Q44","v":323900}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",1,4,{"$f":"Q45","v":368100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",1.2,0,{"$f":"R42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",1.2,1,{"$f":"R42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",1.2,2,{"$f":"R43","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",1.2,3,{"$f":"R44","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condo",1.2,4,{"$f":"R45","v":0}]

{"sheet":"Budget Draw Monitoring ","index":8,"n_rows":134,"n_cols":37,"rows_kept":134,"cut":false,"hidden":false,"merged":[[117,9,117,36],[6,1,6,7],[74,9,74,36],[94,9,94,36],[95,9,95,36],[105,9,105,36],[112,9,112,36],[5,35,5,36],[23,1,23,7],[37,1,37,7],[42,1,42,7],[68,1,68,7],[13,9,13,36],[12,1,12,7],[13,1,13,7],[6,9,6,36],[12,9,12,36],[23,9,23,36],[37,9,37,36],[42,9,42,36],[68,9,68,36],[0,1,3,1],[0,2,0,3],[5,6,5,7],[1,2,1,31],[2,2,2,31],[3,2,3,31],[5,3,5,4],[4,8,131,8],[112,1,112,7],[74,1,74,7],[94,1,94,7],[95,1,95,7],[105,1,105,7],[123,9,123,36],[123,1,123,7],[117,1,117,7]]}
[null,{"$error":"#VALUE!"}]
[null,null,"SOURCES AND USES"]
[null,null,{"$f":"'Project Overview'!C5","v":0}]
[null,null,{"$f":"'Project Overview'!G5","v":0}]
[null,"Project Uses","Budget","Budget %","Previous Adjustments","Adjustments From Current Draw","Revised Budget","Revised Budget %",null,"Spent to Date / Closing"," Draw 1","Draw 2","Draw 3","Draw 4","Draw 5","Draw 6","Draw 7","Draw 8","Draw 9","Draw 10","Draw 11","Draw 12","Draw 13","Draw 14","Draw 15","Draw 16","Draw 17","Draw 18","Draw 19","Draw 20","Draw 21","Draw 22","Draw 23","Draw 24","Funded To-Date","Percentage Complete","Balance to Fund"]
[null,"Dates",null,null,null,null,null,null,null,null,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":"TODAY()","v":"2025-09-09"}]
[null,"Acquisition"]
[null,"Site Acquisition Cost",{"$f":"'Development Costs'!C10","v":0},{"$f":"IFERROR($C8/$C$123,0)","v":0},null,null,{"$f":"$C8+$E8+$F8","v":0},{"$f":"IFERROR($G8/$G$123,0)","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,{"$f":"SUM($J8:$AH8)","v":0},{"$f":"IFERROR($AI8/$G8,0)","v":0},{"$f":"$G8-$AI8","v":0}]
[null,"Existing Building Acquisition Costs",{"$f":"'Development Costs'!C11","v":0},{"$f":"IFERROR($C9/$C$123,0)","v":0},null,null,{"$f":"$C9+$E9+$F9","v":0},{"$f":"IFERROR($G9/$G$123,0)","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,{"$f":"SUM($J9:$AH9)","v":0},{"$f":"IFERROR($AI9/$G9,0)","v":0},{"$f":"$G9-$AI9","v":0}]
[null,"Closing Costs & Acquisition Legal Fees",{"$f":"'Development Costs'!C12","v":0},{"$f":"IFERROR($C10/$C$123,0)","v":0},null,null,{"$f":"$C10+$E10+$F10","v":0},{"$f":"IFERROR($G10/$G$123,0)","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,{"$f":"SUM($J10:$AH10)","v":0},{"$f":"IFERROR($AI10/$G10,0)","v":0},{"$f":"$G10-$AI10","v":0}]
[null,"Other Pre-Development Costs (Detailed Description*)",{"$f":"'Development Costs'!C13","v":0},{"$f":"IFERROR($C11/$C$123,0)","v":0},null,null,{"$f":"$C11+$E11+$F11","v":0},{"$f":"IFERROR($G11/$G$123,0)","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,{"$f":"SUM($J11:$AH11)","v":0},{"$f":"IFERROR($AI11/$G11,0)","v":0},{"$f":"$G11-$AI11","v":0}]
[null,"Subtotal Acquisition Costs:",{"$f":"'Development Costs'!C14","v":0},{"$f":"IFERROR($C12/$C$123,0)","v":0},{"$f":"SUM(E8:E11)","v":0},{"$f":"SUM(F8:F11)","v":0},{"$f":"$C12+$E12+$F12","v":0},{"$f":"IFERROR($G12/$G$123,0)","v":0},null,{"$f":"SUM(J8:J11)","v":0},{"$f":"SUM(K8:K11)","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,{"$f":"SUM(AI8:AI11)","v":0},{"$f":"IFERROR($AI12/$G12,0)","v":0},{"$f":"G12-AI12","v":0}]
[null,"Hard Costs"]
[null,"Off-Site"]
[null,"Off-Site Concrete",{"$f":"'Development Costs'!C18","v":0},{"$f":"IFERROR($C15/$C$123,0)","v":0},null,null,{"$f":"$C15+$E15+$F15","v":0},{"$f":"IFERROR($G15/$G$123,0)","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,{"$f":"SUM($J15:$AH15)","v":0},{"$f":"IFERROR($AI15/$G15,0)","v":0},{"$f":"$G15-$AI15","v":0}]
[null,"Storm Drains & Devices",{"$f":"'Development Costs'!C19","v":0},0,null,null,0,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,0,0,0]
[null,"Water & Fire Hydrands",{"$f":"'Development Costs'!C20","v":0},0,null,null,0,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,0,0,0]
[null,"Off-Site Utilities",{"$f":"'Development Costs'!C21","v":0},0,null,null,0,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,0,0,0]
[null,"Sewer Lateral(s)",{"$f":"'Development Costs'!C22","v":0},0,null,null,0,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,0,0,0]
[null,"Off-Site Paving",{"$f":"'Development Costs'!C23","v":0},0,null,null,0,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,0,0,0]
[null,"Off-Site Electrical",{"$f":"'Development Costs'!C24","v":0},0,null,null,0,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,0,0,0]
[null,"Other Off-Site Costs (Provide Detailed Description)",{"$f":"'Development Costs'!C25","v":0},{"$f":"'Development Costs'!D25","v":0},null,null,0,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,0,0,0]
[null,"Subtotal Off-Site Costs:",{"$f":"'Development Costs'!C26","v":0},{"$f":"IFERROR($C23/$C$123,0)","v":0},{"$f":"SUM(E15:E22)","v":0},{"$f":"SUM(F15:F22)","v":0},0,0,null,{"$f":"SUM(J15:J22)","v":0},{"$f":"SUM(K15:K22)","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,{"$f":"SUM(AI15:AI22)","v":0},0,0]
[null,"Site Work"]
[null,"Demolition",{"$f":"'Development Costs'!C29","v":0},{"$f":"IFERROR($C25/$C$123,0)","v":0},null,null,{"$f":"$C25+$E25+$F25","v":0},{"$f":"IFERROR($G25/$G$123,0)","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,{"$f":"SUM($J25:$AH25)","v":0},{"$f":"IFERROR($AI25/$G25,0)","v":0},{"$f":"$G25-$AI25","v":0}]
[null,"Asbestos Abatement (Demolition Only)",{"$f":"'Development Costs'!C30","v":0},0,null,null,0,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,0,0,0]
[null,"Detention",{"$f":"'Development Costs'!C31","v":0},0,null,null,0,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,0,0,0]
[null,"Rough Grading",{"$f":"'Development Costs'!C32","v":0},0,null,null,0,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,0,0,0]
[null,"Fine Grading",{"$f":"'Development Costs'!C33","v":0},0,null,null,0,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,0,0,0]
[null,"On-Site Concrete",{"$f":"'Development Costs'!C34","v":0},0,null,null,0,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,0,0,0]
[null,"On-Site Electrical",{"$f":"'Development Costs'!C35","v":0},0,null,null,0,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,0,0,0]
[null,"On-Site Paving",{"$f":"'Development Costs'!C36","v":0},0,null,null,0,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,0,0,0]
[null,"On-Site Utilities",{"$f":"'Development Costs'!C37","v":0},0,null,null,0,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,0,0,0]
[null,"Decorative Masonry",{"$f":"'Development Costs'!C38","v":0},0,null,null,0,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,0,0,0]
[null,"Bumper Stops, Striping & Signs",{"$f":"'Development Costs'!C39","v":0},0,null,null,0,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,0,0,0]
[null,"Other Site Work Costs (Provide Detailed Description)",{"$f":"'Development Costs'!C40","v":0},0,null,null,0,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,0,0,0]
[null,"Subtotal Site Work Cost",{"$f":"'Development Costs'!C41","v":0},0,{"$f":"SUM(E25:E36)","v":0},{"$f":"SUM(F25:F36)","v":0},0,0,null,{"$f":"SUM(J25:J36)","v":0},{"$f":"SUM(K25:K36)","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,{"$f":"SUM(AI25:AI36)","v":0},0,{"$f":"G37-AI37","v":0}]
[null,"Site Amenities"]
[null,"Landscaping",{"$f":"'Development Costs'!C44","v":0},{"$f":"IFERROR($C39/$C$123,0)","v":0},null,null,{"$f":"$C39+$E39+$F39","v":0},{"$f":"IFERROR($G39/$G$123,0)","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,{"$f":"SUM($J39:$AH39)","v":0},{"$f":"IFERROR($AI39/$G39,0)","v":0},{"$f":"$G39-$AI39","v":0}]
[null,"Fencing",{"$f":"'Development Costs'!C45","v":0},{"$f":"IFERROR($C40/$C$123,0)","v":0},null,null,{"$f":"$C40+$E40+$F40","v":0},{"$f":"IFERROR($G40/$G$123,0)","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,{"$f":"SUM($J40:$AH40)","v":0},{"$f":"IFERROR($AI40/$G40,0)","v":0},{"$f":"$G40-$AI40","v":0}]
[null,"Other Site Amenities (Provide Detailed Description)",{"$f":"'Development Costs'!C46","v":0},{"$f":"IFERROR($C41/$C$123,0)","v":0},null,null,{"$f":"$C41+$E41+$F41","v":0},{"$f":"IFERROR($G41/$G$123,0)","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,{"$f":"SUM($J41:$AH41)","v":0},{"$f":"IFERROR($AI41/$G41,0)","v":0},{"$f":"$G41-$AI41","v":0}]
[null,"Total Site Amenities Costs",{"$f":"'Development Costs'!C47","v":0},{"$f":"IFERROR($C42/$C$123,0)","v":0},{"$f":"SUM(E39:E41)","v":0},{"$f":"SUM(F39:F41)","v":0},{"$f":"$C42+$E42+$F42","v":0},{"$f":"IFERROR($G42/$G$123,0)","v":0},null,{"$f":"SUM(J39:J41)","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,{"$f":"IFERROR($AI42/$G42,0)","v":0},{"$f":"G42-AI42","v":0}]
[null,"Building Costs"]
[null,"Concrete",{"$f":"'Development Costs'!C50","v":0},{"$f":"IFERROR($C44/$C$123,0)","v":0},null,null,{"$f":"$C44+$E44+$F44","v":0},{"$f":"IFERROR($G44/$G$123,0)","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,{"$f":"SUM($J44:$AH44)","v":0},{"$f":"IFERROR($AI44/$G44,0)","v":0},{"$f":"$G44-$AI44","v":0}]
[null,"Masonry",{"$f":"'Development Costs'!C51","v":0},0,null,null,0,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,0,0,0]
[null,"Metals",{"$f":"'Development Costs'!C52","v":0},0,null,null,0,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,0,0,0]
[null,"Woods & Plastics",{"$f":"'Development Costs'!C53","v":0},0,null,null,0,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,0,0,0]
[null,"Thermal & Moisture Prevention",{"$f":"'Development Costs'!C54","v":0},0,null,null,0,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,0,0,0]
[null,"Roof Covering",{"$f":"'Development Costs'!C55","v":0},0,null,null,0,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,0,0,0]
[null,"Doors & Windows",{"$f":"'Development Costs'!C56","v":0},0,null,null,0,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,0,0,0]
[null,"Finishes",{"$f":"'Development Costs'!C57","v":0},0,null,null,0,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,0,0,0]
[null,"Specialties",{"$f":"'Development Costs'!C58","v":0},0,null,null,0,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,0,0,0]
[null,"Equipment",{"$f":"'Development Costs'!C59","v":0},0,null,null,0,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,0,0,0]
[null,"Furnishings",{"$f":"'Development Costs'!C60","v":0},0,null,null,0,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,0,0,0]
[null,"Special Construction",{"$f":"'Development Costs'!C61","v":0},0,null,null,0,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,0,0,0]
[null,"Conveying Systems (Elevators)",{"$f":"'Development Costs'!C62","v":0},0,null,null,0,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,0,0,0]
[null,"Mechanical (HVAC; Plumbing)",{"$f":"'Development Costs'!C63","v":0},0,null,null,0,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,0,0,0]
[null,"Electrical",{"$f":"'Development Costs'!C64","v":0},0,null,null,0,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,0,0,0]
[null,"Detached Community Facilities/Building",{"$f":"'Development Costs'!C65","v":0},0,null,null,0,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,0,0,0]
[null,"Carports and/or Garages",{"$f":"'Development Costs'!C66","v":0},0,null,null,0,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,0,0,0]
[null,"Lead-Based Paint Abatement",{"$f":"'Development Costs'!C67","v":0},0,null,null,0,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,0,0,0]
[null,"Asbestos Abatement (Rehabilitation Only)",{"$f":"'Development Costs'!C68","v":0},0,null,null,0,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,0,0,0]
[null,"Structured Parking",{"$f":"'Development Costs'!C69","v":0},0,null,null,0,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,0,0,0]
[null,"Commercial Space Costs",{"$f":"'Development Costs'!C70","v":0},0,null,null,0,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,0,0,0]
[null,"Other (Provide Detailed Description)",{"$f":"'Development Costs'!C71","v":0},0,null,null,0,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,0,0,0]
[null,"Sub Total Building Costs",{"$f":"'Development Costs'!C72","v":0},0,{"$f":"SUM(E44:E65)","v":0},{"$f":"SUM(F44:F65)","v":0},0,0,null,{"$f":"SUM(J44:J65)","v":0},{"$f":"SUM(K44:K65)","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,{"$f":"IFERROR($AI66/$G66,0)","v":0},0]
[null,"Contingency",{"$f":"'Development Costs'!C75","v":0},0,null,null,{"$f":"$C67+$E67+$F67","v":0},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,{"$f":"SUM($J67:$AH67)","v":0},{"$f":"IFERROR($AI67/$G67,0)","v":0},{"$f":"$G67-$AI67","v":0}]
[null,"Contingency Percentage of Construction Costs(Min 5.0%; Max 7.0%)",{"$f":"C67/(SUM(C23+C37+C42+C66))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"G67/(SUM(G23+G37+G42+G66))","v":{"$error":"#DIV/0!"}}]
[null,"Other Consturction Costs"]
[null,"General Requirements",{"$f":"'Development Costs'!C79","v":0},{"$f":"IFERROR($C70/$C$123,0)","v":0},null,null,{"$f":"$C70+$E70+$F70","v":0},{"$f":"IFERROR($G70/$G$123,0)","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,{"$f":"SUM($J70:$AH70)","v":0},{"$f":"IFERROR($AI70/$G70,0)","v":0},{"$f":"$G70-$AI70","v":0}]
[null,"Contractor Overhead",{"$f":"'Development Costs'!C80","v":0},{"$f":"IFERROR($C71/$C$123,0)","v":0},null,null,{"$f":"$C71+$E71+$F71","v":0},{"$f":"IFERROR($G71/$G$123,0)","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,{"$f":"SUM($J71:$AH71)","v":0},{"$f":"IFERROR($AI71/$G71,0)","v":0},{"$f":"$G71-$AI71","v":0}]
[null,"Contractor Profit",{"$f":"'Development Costs'!C81","v":0},{"$f":"IFERROR($C72/$C$123,0)","v":0},null,null,{"$f":"$C72+$E72+$F72","v":0},{"$f":"IFERROR($G72/$G$123,0)","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,{"$f":"SUM($J72:$AH72)","v":0},{"$f":"IFERROR($AI72/$G72,0)","v":0},{"$f":"$G72-$AI72","v":0}]
[null,"Subtotal Contractor Fees",{"$f":"'Development Costs'!C82","v":0},{"$f":"IFERROR($C73/$C$123,0)","v":0},{"$f":"SUM(E70:E72)","v":0},{"$f":"SUM(F70:F72)","v":0},{"$f":"$C73+$E73+$F73","v":0},{"$f":"IFERROR($G73/$G$123,0)","v":0},null,{"$f":"SUM(J70:J72)","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,{"$f":"IFERROR($AI73/$G73,0)","v":0},{"$f":"SUM(AK70:AK72)","v":0}]
[null,"Total Construction Costs with Contingency",{"$f":"'Development Costs'!C84","v":0},{"$f":"IFERROR($C74/$C$123,0)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(F23+F37+F42+F66+F73)","v":0},{"$f":"SUM(G23+G37+G42+G66+G73)","v":0},{"$f":"IFERROR($G74/$G$123,0)","v":0},null,{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"SUM(E23+E37+E42+E66+E73)","v":0},{"$f":"IFERROR($AI74/$G74,0)","v":0},{"$f":"$G74-$AI74","v":0}]
[null,"Soft Costs"]
[null,"Architectural - Design Fees",{"$f":"'Development Costs'!C87","v":0},{"$f":"IFERROR($C76/$C$123,0)","v":0},null,null,{"$f":"$C76+$E76+$F76","v":0},{"$f":"IFERROR($G76/$G$123,0)","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,{"$f":"SUM($J76:$AH76)","v":0},{"$f":"IFERROR($AI76/$G76,0)","v":0},{"$f":"$G76-$AI76","v":0}]
[null,"Architectural - Supervision fees",{"$f":"'Development Costs'!C88","v":0},0,null,null,{"$f":"$C77+$E77+$F77","v":0},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,0,0,0]
[null,"Engineering Fees",{"$f":"'Development Costs'!C89","v":0},0,null,null,0,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,0,0,0]
[null,"Real Estate Attorney/Other Legal Fees",{"$f":"'Development Costs'!C90","v":0},0,null,null,0,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,0,0,0]
[null,"Accounting Fees",{"$f":"'Development Costs'!C91","v":0},0,null,null,0,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,0,0,0]
[null,"Impact Fees",{"$f":"'Development Costs'!C92","v":0},0,null,null,0,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,0,0,0]
[null,"Building Permits & Related Costs",{"$f":"'Development Costs'!C93","v":0},0,null,null,0,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,0,0,0]
[null,"Appraisal",{"$f":"'Development Costs'!C94","v":0},0,null,null,0,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,0,0,0]
[null,"Market Analysis",{"$f":"'Development Costs'!C95","v":0},0,null,null,0,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,0,0,0]
[null,"Environmental Assesssment",{"$f":"'Development Costs'!C96","v":0},0,null,null,0,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,0,0,0]
[null,"Soils Report",{"$f":"'Development Costs'!C97","v":0},0,null,null,0,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,0,0,0]
[null,"Survey",{"$f":"'Development Costs'!C98","v":0},0,null,null,0,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,0,0,0]
[null,"Marketing",{"$f":"'Development Costs'!C99","v":0},0,null,null,0,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,0,0,0]
[null,"Hazard & Liability Insurance",{"$f":"'Development Costs'!C100","v":0},0,null,null,0,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,0,0,0]
[null,"Real Property Taxes",{"$f":"'Development Costs'!C101","v":0},0,null,null,0,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,0,0,0]
[null,"Personal Property Taxes",{"$f":"'Development Costs'!C102","v":0},0,null,null,0,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,0,0,0]
[null,"Tenant Relocation",{"$f":"'Development Costs'!C103","v":0},0,null,null,0,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,0,0,0]
[null,"Other (Provide Detailed Description)",{"$f":"'Development Costs'!C104","v":0},0,null,null,0,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,0,0,0]
[null,"Total Soft Costs",{"$f":"'Development Costs'!C105","v":0},0,{"$f":"SUM(E76:E93)","v":0},{"$f":"SUM(F76:F93)","v":0},0,0,null,{"$f":"SUM(J76:J93)","v":0},{"$f":"SUM(K76:K93)","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]
[null,"Financing"]
[null,"Construction Loan(s)"]
[null,"Interest",{"$f":"'Development Costs'!C109","v":0},{"$f":"IFERROR($C97/$C$123,0)","v":0},null,null,{"$f":"$C97+$E97+$F97","v":0},{"$f":"IFERROR($G97/$G$123,0)","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,{"$f":"SUM($J97:$AH97)","v":0},{"$f":"IFERROR($AI97/$G97,0)","v":0},{"$f":"$G97-$AI97","v":0}]
[null,"Loan Origination Fees",{"$f":"'Development Costs'!C110","v":0},0,null,null,0,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,0,0,0]
[null,"Title & Recording Fees",{"$f":"'Development Costs'!C111","v":0},0,null,null,0,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,0,0,0]
[null,"Closing Costs & Legal Fees",{"$f":"'Development Costs'!C112","v":0},0,null,null,0,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,0,0,0]
[null,"Inspection Fees",{"$f":"'Development Costs'!C113","v":0},0,null,null,0,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,0,0,0]
[null,"Credit Report",{"$f":"'Development Costs'!C114","v":0},0,null,null,0,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,0,0,0]
[null,"Discount Points",{"$f":"'Development Costs'!C115","v":0},0,null,null,0,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,0,0,0]
[null,"Other (Provide Detailed Description)",{"$f":"'Development Costs'!C116","v":0},0,null,null,0,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,0,0,0]
[null,"Subtotal Contruction Loan(s)",{"$f":"SUM(C97:C104)","v":0},0,null,null,0,0,null,{"$f":"SUM(J97:J104)","v":0},{"$f":"SUM(K97:K104)","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,{"$f":"SUM(AI97:AI104)","v":0},0,{"$f":"SUM(AK97:AK104)","v":0}]
[null,"Other Loan(s)"]
[null,"Interest",{"$f":"'Development Costs'!C120","v":0},{"$f":"IFERROR($C107/$C$123,0)","v":0},null,null,{"$f":"$C107+$E107+$F107","v":0},{"$f":"IFERROR($G107/$G$123,0)","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,{"$f":"SUM($J107:$AH107)","v":0},{"$f":"IFERROR($AI107/$G107,0)","v":0},{"$f":"$G107-$AI107","v":0}]
[null,"Loan Origination Fees",{"$f":"'Development Costs'!C121","v":0},0,null,null,0,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,{"$f":"SUM($J108:$AH108)","v":0},0,{"$f":"$G108-$AI108","v":0}]
[null,"Title & Recording Fees",{"$f":"'Development Costs'!C122","v":0},0,null,null,0,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,{"$f":"SUM($J109:$AH109)","v":0},0,{"$f":"$G109-$AI109","v":0}]
[null,"Closing Costs & Legal Fees",{"$f":"'Development Costs'!C123","v":0},0,null,null,0,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,{"$f":"SUM($J110:$AH110)","v":0},0,{"$f":"$G110-$AI110","v":0}]
[null,"Other (Provide Detailed Description)",{"$f":"'Development Costs'!C124","v":0},0,null,null,0,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,{"$f":"SUM($J111:$AH111)","v":0},0,{"$f":"$G111-$AI111","v":0}]
[null,"Subtotal Other Loan(s)",{"$f":"SUM(C107:C111)","v":0},0,null,null,0,0,null,{"$f":"SUM(J107:J111)","v":0},{"$f":"SUM(K107:K111)","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,{"$f":"SUM(AI107:AI111)","v":0},0,{"$f":"SUM(AK107:AK111)","v":0}]
[null,"Other Financing Costs"]
[null,"Payment & Performance Bonds",{"$f":"'Development Costs'!C128","v":0},{"$f":"IFERROR($C114/$C$123,0)","v":0},null,null,{"$f":"$C114+$E114+$F114","v":0},{"$f":"IFERROR($G114/$G$123,0)","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,{"$f":"SUM($J114:$AH114)","v":0},{"$f":"IFERROR($AI114/$G114,0)","v":0},{"$f":"$G114-$AI114","v":0}]
[null,"Other (Provide Detailed Description)",{"$f":"'Development Costs'!C129","v":0},{"$f":"IFERROR($C115/$C$123,0)","v":0},null,null,{"$f":"$C115+$E115+$F115","v":0},{"$f":"IFERROR($G115/$G$123,0)","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,{"$f":"SUM($J115:$AH115)","v":0},{"$f":"IFERROR($AI115/$G115,0)","v":0},{"$f":"$G115-$AI115","v":0}]
[null,"Subtotal Other Financing Cost",{"$f":"'Development Costs'!C130","v":0},{"$f":"IFERROR($C116/$C$123,0)","v":0},{"$f":"SUM(E114:E115)","v":0},{"$f":"SUM(F114:F115)","v":0},{"$f":"$C116+$E116+$F116","v":0},{"$f":"IFERROR($G116/$G$123,0)","v":0},null,{"$f":"SUM(J114:J115)","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,{"$f":"IFERROR($AI116/$G116,0)","v":0},{"$f":"SUM(AK114:AK115)","v":0}]
[null,"Total Financing Costs",{"$f":"'Development Costs'!C132","v":0},{"$f":"IFERROR($C117/$C$123,0)","v":0},{"$f":"SUM(E105+E112+E116)","v":0},{"$f":"SUM(F105+F112+F116)","v":0},{"$f":"SUM(G105+G112+G116)","v":0},{"$f":"IFERROR($G117/$G$123,0)","v":0},null,{"$f":"SUM(J105+J112+J116)","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,{"$f":"IFERROR($AI117/$G117,0)","v":0},{"$f":"SUM(AK105+AK112+AK116)","v":0}]
[null,"Developer Fees"]
[null,"Housing Consultant Fees",{"$f":"'Development Costs'!C135","v":0},{"$f":"IFERROR($C119/$C$123,0)","v":0},null,null,0,{"$f":"IFERROR($G119/$G$123,0)","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,{"$f":"SUM($J119:$AH119)","v":0},{"$f":"IFERROR($AI119/$G119,0)","v":0},{"$f":"$G119-$AI119","v":0}]
[null,"General & Administrative",{"$f":"'Development Costs'!C136","v":0},{"$f":"IFERROR($C120/$C$123,0)","v":0},null,null,0,{"$f":"IFERROR($G120/$G$123,0)","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,{"$f":"SUM($J120:$AH120)","v":0},{"$f":"IFERROR($AI120/$G120,0)","v":0},{"$f":"$G120-$AI120","v":0}]
[null,"Profit & Fee",{"$f":"'Development Costs'!C137","v":0},{"$f":"IFERROR($C121/$C$123,0)","v":0},null,null,0,{"$f":"IFERROR($G121/$G$123,0)","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,{"$f":"SUM($J121:$AH121)","v":0},{"$f":"IFERROR($AI121/$G121,0)","v":0},{"$f":"$G121-$AI121","v":0}]
[null,"Subtotal Developer Fees",{"$f":"'Development Costs'!C138","v":0},{"$f":"IFERROR($C122/$C$123,0)","v":0},{"$f":"SUM(E119:E121)","v":0},{"$f":"SUM(F119:F121)","v":0},0,{"$f":"IFERROR($G122/$G$123,0)","v":0},null,{"$f":"SUM(J119:J121)","v":0},{"$f":"SUM(K119:K121)","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,{"$f":"IFERROR($AI122/$G122,0)","v":0},0]
[null,"Total Development Costs (TDC):",{"$f":"'Development Costs'!C140","v":0},{"$f":"IFERROR($C123/$C$123,0)","v":0},{"$f":"SUM(E12+E74+E94+E117+E122)","v":0},{"$f":"SUM(F12+F74+F94+F117+F122)","v":0},{"$f":"SUM(G12+G74+G94+G117+G122)","v":0},{"$f":"IFERROR($G123/$G$123,0)","v":0},null,{"$f":"SUM(J12+J74+J94+J117+J122)","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,{"$f":"IFERROR($AI123/$G123,0)","v":0},{"$f":"SUM(AK12+AK74+AK94+AK117+AK122)","v":0}]
[null,"Project Sources"]
[null,"Hard Debt",{"$f":"'Sources & Uses'!M7","v":0},{"$f":"IFERROR($C125/$C$132,0)","v":0},null,null,{"$f":"C125+E125+F125","v":0},{"$f":"IFERROR($G125/$G$132,0)","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,{"$f":"SUM($J125:$AH125)","v":0},{"$f":"IFERROR($AI125/$G125,0)","v":0},{"$f":"$G125-$AI125","v":0}]
[null,"Soft Debt",{"$f":"'Sources & Uses'!M8","v":0},0,null,null,0,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,0,0,0]
[null,"Other Loan(s)",{"$f":"'Sources & Uses'!M9","v":0},0,null,null,0,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,0,0,0]
[null,"Grant",{"$f":"'Sources & Uses'!M10","v":0},0,null,null,0,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,0,0,0]
[null,"Federal Grant",{"$f":"'Sources & Uses'!M11","v":0},0,null,null,0,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,0,0,0]
[null,"Other",{"$f":"'Sources & Uses'!M12","v":0},0,null,null,0,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,0,0,0]
[null,"AHFC Funding Request",{"$f":"'Sources & Uses'!M13","v":0},0,null,null,0,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,0,0,0]
[null,"Total Sources",{"$f":"'Sources & Uses'!M14","v":0},{"$f":"SUM(D125:D131)","v":0},{"$f":"SUM(E$125:E$131)","v":0},{"$f":"SUM(F$125:F$131)","v":0},{"$f":"SUM(G125:G131)","v":0},{"$f":"SUM(H125:H131)","v":0},null,{"$f":"SUM(J$125:J$131)","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,{"$f":"SUM(AK$125:AK$131)","v":0}]
[]
[null,null,{"$f":"C123-C132","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]

{"sheet":"Prelim Profit & Loss","index":9,"n_rows":59,"n_cols":6,"rows_kept":59,"cut":false,"hidden":false,"merged":[[56,1,56,4],[57,1,57,4],[58,1,58,4],[48,1,48,4],[50,1,50,4],[51,1,51,4],[53,1,53,4],[55,1,55,5],[54,2,54,4],[49,1,49,4],[52,1,52,4],[42,1,42,4],[43,1,43,4],[44,1,44,4],[45,1,45,4],[47,1,47,5],[37,1,37,4],[38,1,38,4],[39,1,39,4],[40,1,40,4],[41,1,41,4],[32,1,32,5],[33,1,33,4],[34,1,34,4],[35,1,35,4],[36,1,36,4],[0,1,0,5],[1,1,1,5],[2,1,2,5],[4,1,4,5],[30,1,30,4]]}
[null,{"$f":"IFERROR(IF('Project Overview'!C5=0,\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Project Overview'!G5=0,\"\"),\"\")","v":""}]
[null,"Estimated Profit & Loss"]
[]
[null,"REVENUE FROM SALES"]
[null,"Model","Unit Type","Number of Units","Sales Price/Unit","Totals"]
[null,{"$f":"IF('Unit Mix, Sales Data'!D4=\"\",\"\",'Unit Mix, Sales Data'!C4)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D4=\"\",\"\",'Unit Mix, Sales Data'!D4)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E4=\"\",\"\",'Unit Mix, Sales Data'!E4)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L4,0)","v":0},{"$f":"IF(C7=\"\",\"\",SUM(D7*E7))","v":""}]
[null,{"$f":"IF('Unit Mix, Sales Data'!D5=\"\",\"\",'Unit Mix, Sales Data'!C5)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D5=\"\",\"\",'Unit Mix, Sales Data'!D5)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E5=\"\",\"\",'Unit Mix, Sales Data'!E5)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L5,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D6=\"\",\"\",'Unit Mix, Sales Data'!C6)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D6=\"\",\"\",'Unit Mix, Sales Data'!D6)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E6=\"\",\"\",'Unit Mix, Sales Data'!E6)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L6,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D7=\"\",\"\",'Unit Mix, Sales Data'!C7)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D7=\"\",\"\",'Unit Mix, Sales Data'!D7)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E7=\"\",\"\",'Unit Mix, Sales Data'!E7)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L7,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D8=\"\",\"\",'Unit Mix, Sales Data'!C8)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D8=\"\",\"\",'Unit Mix, Sales Data'!D8)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E8=\"\",\"\",'Unit Mix, Sales Data'!E8)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L8,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D9=\"\",\"\",'Unit Mix, Sales Data'!C9)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D9=\"\",\"\",'Unit Mix, Sales Data'!D9)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E9=\"\",\"\",'Unit Mix, Sales Data'!E9)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L9,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D10=\"\",\"\",'Unit Mix, Sales Data'!C10)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D10=\"\",\"\",'Unit Mix, Sales Data'!D10)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E10=\"\",\"\",'Unit Mix, Sales Data'!E10)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L10,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D11=\"\",\"\",'Unit Mix, Sales Data'!C11)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D11=\"\",\"\",'Unit Mix, Sales Data'!D11)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E11=\"\",\"\",'Unit Mix, Sales Data'!E11)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L11,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D12=\"\",\"\",'Unit Mix, Sales Data'!C12)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D12=\"\",\"\",'Unit Mix, Sales Data'!D12)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E12=\"\",\"\",'Unit Mix, Sales Data'!E12)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L12,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D13=\"\",\"\",'Unit Mix, Sales Data'!C13)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D13=\"\",\"\",'Unit Mix, Sales Data'!D13)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E13=\"\",\"\",'Unit Mix, Sales Data'!E13)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L13,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D14=\"\",\"\",'Unit Mix, Sales Data'!C14)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D14=\"\",\"\",'Unit Mix, Sales Data'!D14)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E14=\"\",\"\",'Unit Mix, Sales Data'!E14)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L14,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D15=\"\",\"\",'Unit Mix, Sales Data'!C15)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D15=\"\",\"\",'Unit Mix, Sales Data'!D15)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E15=\"\",\"\",'Unit Mix, Sales Data'!E15)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L15,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D16=\"\",\"\",'Unit Mix, Sales Data'!C16)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D16=\"\",\"\",'Unit Mix, Sales Data'!D16)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E16=\"\",\"\",'Unit Mix, Sales Data'!E16)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L16,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D17=\"\",\"\",'Unit Mix, Sales Data'!C17)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D17=\"\",\"\",'Unit Mix, Sales Data'!D17)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E17=\"\",\"\",'Unit Mix, Sales Data'!E17)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L17,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D18=\"\",\"\",'Unit Mix, Sales Data'!C18)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D18=\"\",\"\",'Unit Mix, Sales Data'!D18)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E18=\"\",\"\",'Unit Mix, Sales Data'!E18)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L18,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D19=\"\",\"\",'Unit Mix, Sales Data'!C19)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D19=\"\",\"\",'Unit Mix, Sales Data'!D19)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E19=\"\",\"\",'Unit Mix, Sales Data'!E19)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L19,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D20=\"\",\"\",'Unit Mix, Sales Data'!C20)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D20=\"\",\"\",'Unit Mix, Sales Data'!D20)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E20=\"\",\"\",'Unit Mix, Sales Data'!E20)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L20,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D21=\"\",\"\",'Unit Mix, Sales Data'!C21)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D21=\"\",\"\",'Unit Mix, Sales Data'!D21)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E21=\"\",\"\",'Unit Mix, Sales Data'!E21)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L21,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D22=\"\",\"\",'Unit Mix, Sales Data'!C22)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D22=\"\",\"\",'Unit Mix, Sales Data'!D22)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E22=\"\",\"\",'Unit Mix, Sales Data'!E22)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L22,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D23=\"\",\"\",'Unit Mix, Sales Data'!C23)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D23=\"\",\"\",'Unit Mix, Sales Data'!D23)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E23=\"\",\"\",'Unit Mix, Sales Data'!E23)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L23,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D24=\"\",\"\",'Unit Mix, Sales Data'!C24)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D24=\"\",\"\",'Unit Mix, Sales Data'!D24)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E24=\"\",\"\",'Unit Mix, Sales Data'!E24)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L24,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D25=\"\",\"\",'Unit Mix, Sales Data'!C25)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D25=\"\",\"\",'Unit Mix, Sales Data'!D25)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E25=\"\",\"\",'Unit Mix, Sales Data'!E25)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L25,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D26=\"\",\"\",'Unit Mix, Sales Data'!C26)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D26=\"\",\"\",'Unit Mix, Sales Data'!D26)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E26=\"\",\"\",'Unit Mix, Sales Data'!E26)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L26,0)","v":0},""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D27=\"\",\"\",'Unit Mix, Sales Data'!C27)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D27=\"\",\"\",'Unit Mix, Sales Data'!D27)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E27=\"\",\"\",'Unit Mix, Sales Data'!E27)","v":""},{"$f":"IFERROR('Unit Mix, Sales Data'!L27,0)","v":0},""]
[null,"Total Sales Revenue",null,null,null,{"$f":"SUM(F7:F30)","v":0}]
[]
[null,"COSTS"]
[null,"Acquisition Costs",null,null,null,{"$f":"'Development Costs'!C14","v":0}]
[null,"Hard Costs-Off Site",null,null,null,{"$f":"'Development Costs'!C26","v":0}]
[null,"Hard Costs-Site Work",null,null,null,{"$f":"'Development Costs'!C41","v":0}]
[null,"Hard Costs-Site Amenities",null,null,null,{"$f":"'Development Costs'!C47","v":0}]
[null,"Hard Costs-Building Costs",null,null,null,{"$f":"'Development Costs'!C72","v":0}]
[null,"Hard Costs-Contingency",null,null,null,{"$f":"'Development Costs'!C75","v":0}]
[null,"Hard Costs-Contractor Fees",null,null,null,{"$f":"'Development Costs'!C82","v":0}]
[null,"Soft Costs",null,null,null,{"$f":"'Development Costs'!C105","v":0}]
[null,"Financing-Construction Loan(s)",null,null,null,{"$f":"'Development Costs'!C117","v":0}]
[null,"Financing-Sponsor Loan(s)",null,null,null,{"$f":"'Development Costs'!C125","v":0}]
[null,"Financing-Other Financing",null,null,null,{"$f":"'Development Costs'!C130","v":0}]
[null,"Developer Fee",null,null,null,{"$f":"'Development Costs'!C138","v":0}]
[null,"Total Project Costs",null,null,null,{"$f":"SUM(F34:F45)","v":0}]
[]
[null,"PROFIT (LOSS)"]
[null,"Gross Sales Revenue",null,null,null,{"$f":"F31","v":0}]
[null,"Gross Project Costs",null,null,null,{"$f":"F46","v":0}]
[null,"Less Hard Debt",null,null,null,{"$f":"'Sources & Uses'!M7","v":0}]
[null,"Less Other Loan(s)",null,null,null,{"$f":"'Sources & Uses'!M9","v":0}]
[null,"Plus AHFC Award, Grants, Etc.",null,null,null,{"$f":"'Sources & Uses'!M8+'Sources & Uses'!M10+'Sources & Uses'!M11+'Sources & Uses'!M12+'Sources & Uses'!M13","v":0}]
[null,"Equals Profit (Loss)",null,null,null,{"$f":"F49-F50-F51-F52+F53","v":0}]
[]
[null,"Excees Proceeds"]
[null,"Actual Profit",null,null,null,{"$f":"F54","v":0}]
[null,"Minus Developer Fee",null,null,null,{"$f":"F45","v":0}]
[null,"Exceeds Proceeds Up to Total of AHFC Loan",null,null,null,{"$f":"MIN('Sources & Uses'!M13,IF(F57>0,SUM(F57-F58),(SUM(F57+F58))))","v":0}]

{"sheet":"Working Profit & Loss","index":10,"n_rows":68,"n_cols":8,"rows_kept":68,"cut":false,"hidden":false,"merged":[[57,1,57,4],[58,1,58,4],[0,1,0,5],[1,1,1,5],[2,1,2,5],[4,1,4,5],[32,1,32,5],[67,1,69,5],[51,1,51,4],[52,1,52,4],[49,1,49,4],[33,1,33,4],[34,1,34,4],[35,1,35,4],[36,1,36,4],[37,1,37,4],[38,1,38,4],[39,1,39,4],[40,1,40,4],[61,1,61,5],[60,1,60,4],[65,1,65,4],[42,1,42,4],[62,1,62,4],[63,1,63,4],[41,1,41,4],[30,1,30,4],[64,1,64,4],[43,1,43,4],[47,1,47,5],[48,1,48,4],[44,1,44,4],[45,1,45,4],[55,1,55,5],[59,1,59,4],[50,1,50,4],[53,1,53,4],[54,1,54,4],[56,1,56,4]]}
[null,{"$f":"IFERROR(IF('Project Overview'!C5=0,\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF('Project Overview'!G5=0,\"\"),\"\")","v":""}]
[null,"Estimated Profit & Loss"]
[]
[null,"REVENUE FROM SALES"]
[null,"Owner Name","MFI","Unit Number","Sales Price/Unit","Totals"]
[null,null,null,null,null,{"$f":"IF(C7=\"\",\"\",SUM(D7*E7))","v":""}]
[]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,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":"IF('Unit Mix, Sales Data'!D13=\"\",\"\",'Unit Mix, Sales Data'!C13)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D13=\"\",\"\",'Unit Mix, Sales Data'!D13)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E13=\"\",\"\",'Unit Mix, Sales Data'!E13)","v":""},null,""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D14=\"\",\"\",'Unit Mix, Sales Data'!C14)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D14=\"\",\"\",'Unit Mix, Sales Data'!D14)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E14=\"\",\"\",'Unit Mix, Sales Data'!E14)","v":""},null,""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D15=\"\",\"\",'Unit Mix, Sales Data'!C15)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D15=\"\",\"\",'Unit Mix, Sales Data'!D15)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E15=\"\",\"\",'Unit Mix, Sales Data'!E15)","v":""},null,""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D16=\"\",\"\",'Unit Mix, Sales Data'!C16)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D16=\"\",\"\",'Unit Mix, Sales Data'!D16)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E16=\"\",\"\",'Unit Mix, Sales Data'!E16)","v":""},null,""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D17=\"\",\"\",'Unit Mix, Sales Data'!C17)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D17=\"\",\"\",'Unit Mix, Sales Data'!D17)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E17=\"\",\"\",'Unit Mix, Sales Data'!E17)","v":""},null,""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D18=\"\",\"\",'Unit Mix, Sales Data'!C18)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D18=\"\",\"\",'Unit Mix, Sales Data'!D18)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E18=\"\",\"\",'Unit Mix, Sales Data'!E18)","v":""},null,""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D19=\"\",\"\",'Unit Mix, Sales Data'!C19)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D19=\"\",\"\",'Unit Mix, Sales Data'!D19)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E19=\"\",\"\",'Unit Mix, Sales Data'!E19)","v":""},null,""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D20=\"\",\"\",'Unit Mix, Sales Data'!C20)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D20=\"\",\"\",'Unit Mix, Sales Data'!D20)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E20=\"\",\"\",'Unit Mix, Sales Data'!E20)","v":""},null,""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D21=\"\",\"\",'Unit Mix, Sales Data'!C21)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D21=\"\",\"\",'Unit Mix, Sales Data'!D21)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E21=\"\",\"\",'Unit Mix, Sales Data'!E21)","v":""},null,""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D22=\"\",\"\",'Unit Mix, Sales Data'!C22)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D22=\"\",\"\",'Unit Mix, Sales Data'!D22)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E22=\"\",\"\",'Unit Mix, Sales Data'!E22)","v":""},null,""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D23=\"\",\"\",'Unit Mix, Sales Data'!C23)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D23=\"\",\"\",'Unit Mix, Sales Data'!D23)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E23=\"\",\"\",'Unit Mix, Sales Data'!E23)","v":""},null,""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D24=\"\",\"\",'Unit Mix, Sales Data'!C24)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D24=\"\",\"\",'Unit Mix, Sales Data'!D24)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E24=\"\",\"\",'Unit Mix, Sales Data'!E24)","v":""},null,""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D25=\"\",\"\",'Unit Mix, Sales Data'!C25)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D25=\"\",\"\",'Unit Mix, Sales Data'!D25)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E25=\"\",\"\",'Unit Mix, Sales Data'!E25)","v":""},null,""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D26=\"\",\"\",'Unit Mix, Sales Data'!C26)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D26=\"\",\"\",'Unit Mix, Sales Data'!D26)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E26=\"\",\"\",'Unit Mix, Sales Data'!E26)","v":""},null,""]
[null,{"$f":"IF('Unit Mix, Sales Data'!D27=\"\",\"\",'Unit Mix, Sales Data'!C27)","v":""},{"$f":"IF('Unit Mix, Sales Data'!D27=\"\",\"\",'Unit Mix, Sales Data'!D27)","v":""},{"$f":"IF('Unit Mix, Sales Data'!E27=\"\",\"\",'Unit Mix, Sales Data'!E27)","v":""},null,""]
[null,"Total Sales Revenue",null,null,null,{"$f":"SUM(F7:F30)","v":0}]
[]
[null,"COSTS",null,null,null,null,"Eligble Basis Acquisition","Eligible Basis New/Rehab"]
[null,"Acquisition Costs",null,null,null,{"$f":"'Budget Draw Monitoring '!G12","v":0},{"$f":"'Budget Draw Monitoring '!G12-'Budget Draw Monitoring '!G8-'Budget Draw Monitoring '!G10","v":0},{"$f":"'Budget Draw Monitoring '!G12-'Budget Draw Monitoring '!G8-'Budget Draw Monitoring '!G9-'Budget Draw Monitoring '!G10","v":0}]
[null,"Hard Costs-Off Site",null,null,null,{"$f":"'Budget Draw Monitoring '!G23","v":0},{"$f":"'Budget Draw Monitoring '!G23-'Budget Draw Monitoring '!G15-'Budget Draw Monitoring '!G16-'Budget Draw Monitoring '!G17-'Budget Draw Monitoring '!G18-'Budget Draw Monitoring '!G19-'Budget Draw Monitoring '!G20-'Budget Draw Monitoring '!G21-'Budget Draw Monitoring '!G22","v":0},{"$f":"'Budget Draw Monitoring '!G23","v":0}]
[null,"Hard Costs-Site Work",null,null,null,{"$f":"'Budget Draw Monitoring '!G37","v":0},{"$f":"'Budget Draw Monitoring '!G37-'Budget Draw Monitoring '!G25-'Budget Draw Monitoring '!G26","v":0},{"$f":"'Budget Draw Monitoring '!G37-'Budget Draw Monitoring '!G25-'Budget Draw Monitoring '!G26","v":0}]
[null,"Hard Costs-Site Amenities",null,null,null,{"$f":"'Budget Draw Monitoring '!G42","v":0},{"$f":"'Budget Draw Monitoring '!G42","v":0},{"$f":"'Budget Draw Monitoring '!G42","v":0}]
[null,"Hard Costs-Building Costs",null,null,null,{"$f":"'Budget Draw Monitoring '!G66","v":0},{"$f":"'Budget Draw Monitoring '!G66-'Budget Draw Monitoring '!G64","v":0},{"$f":"'Budget Draw Monitoring '!G66-'Budget Draw Monitoring '!G64","v":0}]
[null,"Hard Costs-Contingency",null,null,null,{"$f":"'Budget Draw Monitoring '!G67","v":0},{"$f":"'Budget Draw Monitoring '!G67","v":0},{"$f":"'Budget Draw Monitoring '!G67","v":0}]
[null,"Hard Costs-Contractor Fees",null,null,null,{"$f":"'Budget Draw Monitoring '!G73","v":0},{"$f":"'Budget Draw Monitoring '!G73","v":0},{"$f":"'Budget Draw Monitoring '!G73","v":0}]
[null,"Soft Costs",null,null,null,{"$f":"'Budget Draw Monitoring '!G94","v":0},{"$f":"'Budget Draw Monitoring '!G94-'Budget Draw Monitoring '!G88-'Budget Draw Monitoring '!G92","v":0},{"$f":"'Budget Draw Monitoring '!G94-'Budget Draw Monitoring '!G88-'Budget Draw Monitoring '!G92","v":0}]
[null,"Financing-Construction Loan(s)",null,null,null,{"$f":"'Budget Draw Monitoring '!G105","v":0},{"$f":"'Budget Draw Monitoring '!G105","v":0},{"$f":"'Budget Draw Monitoring '!G105","v":0}]
[null,"Financing-Other Loan(s)",null,null,null,{"$f":"'Budget Draw Monitoring '!G112","v":0},{"$f":"'Budget Draw Monitoring '!G112","v":0},{"$f":"'Budget Draw Monitoring '!G112","v":0}]
[null,"Financing-Other Financing",null,null,null,{"$f":"'Budget Draw Monitoring '!G116","v":0},{"$f":"'Budget Draw Monitoring '!G116","v":0},{"$f":"'Budget Draw Monitoring '!G116","v":0}]
[null,"Developer Fee",null,null,null,{"$f":"'Budget Draw Monitoring '!G122","v":0},{"$f":"'Budget Draw Monitoring '!G122","v":0},{"$f":"'Budget Draw Monitoring '!G122","v":0}]
[null,"Total Project Costs",null,null,null,{"$f":"SUM(F34:F45)","v":0},{"$f":"SUM(G34:G45)","v":0},{"$f":"SUM(H34:H45)","v":0}]
[]
[null,"PROFIT (LOSS)"]
[null,"Gross Revenue",null,null,null,{"$f":"F31","v":0}]
[null,"Gross Project Costs",null,null,null,{"$f":"F46","v":0}]
[null,"Less Hard Debt",null,null,null,{"$f":"'Budget Draw Monitoring '!G125","v":0}]
[null,"Less Other Loan(s)",null,null,null,{"$f":"'Budget Draw Monitoring '!G127","v":0}]
[null,"Plus AHFC Award, Grants, Etc.",null,null,null,{"$f":"'Budget Draw Monitoring '!G126+'Budget Draw Monitoring '!G128+'Budget Draw Monitoring '!G129+'Budget Draw Monitoring '!G130+'Budget Draw Monitoring '!G131","v":0}]
[null,"Equals Profit (Loss)",null,null,null,{"$f":"SUM(F49-F50-F51)","v":0}]
[]
[null,"Excess Proceeds"]
[null,"Actual Profit",null,null,null,{"$f":"F54","v":0}]
[null,"Developer Fee",null,null,null,{"$f":"F45","v":0}]
[null,"Amount needed to Maintain Developer Fee Percentage",null,null,null,{"$f":"F66*#REF!/(1+F66)","v":{"$error":"#DIV/0!"}}]
[null,"Exceeds Proceeds up to total of AHFC Loan",null,null,null,{"$f":"MAX(0, MIN('Budget Draw Monitoring '!G131, IF(F57 > 0, F57 - F58 - F59, F57 + F58 + F59)))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Eligible Basis"]
[null,"Total Development Cost",null,null,null,{"$f":"F46","v":0}]
[null,"Total Eligible Basis",null,null,null,{"$f":"IF('Development Costs'!C1=\"Acquisition\",'Working Profit & Loss'!G46,IF('Development Costs'!C1=\"New/Rehab\",'Working Profit & Loss'!H46,\"\"))","v":""}]
[null,"Developer Fee % of Eligible Basis*(Max 15.0%)",null,null,null,{"$f":"F45/(F64-F45)","v":{"$error":"#VALUE!"}}]
[null,"Target Developer Fee From Development Costs",null,null,null,{"$f":"'Development Costs'!G145","v":{"$error":"#DIV/0!"}}]
[]
[null,"* Developer fee at application must be maintained throughout the development process. A final accounting will occur at conversion, where excess proceeds will pay down the loan principle."]