{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Summary","Dev Exp Cost Comparison","ProForma Comparision","MFI&FMR","LIHTC Calculator","Instructions","Project Overview","Unit Mix, Income, Timeline","Sources & Uses","Development Costs","ProForma"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":39,"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":[[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],[40,5,40,6],[41,5,41,6],[42,5,42,6],[38,5,38,6],[39,5,39,6],[61,6,61,8],[46,1,46,4],[60,1,60,4],[54,6,54,7],[46,6,46,7],[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]]}
[]
[null,"PROJECT SUMMARY INFORMATION"]
[null,"Property (Project) Name:",{"$f":"'Project Overview'!C6","v":0},null,null,"Borrower (Legal Entity) Name:",{"$f":"'Project Overview'!G8","v":0}]
[null,"Street Address:",{"$f":"'Project Overview'!C8","v":0}]
[null,"Developer (Sponsor):",{"$f":"'Project Overview'!G6","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'!K15","v":0}]
[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, Income, Timeline'!#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, Income, Timeline'!#REF!","v":{"$error":"#REF!"}}]
[null,"HDA Subsidy per HDA Program Unit",{"$f":"H9/'Unit Mix, Income, Timeline'!C30","v":{"$error":"#DIV/0!"}},{"$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":"#DIV/0!"}},null,"Total Units",{"$f":"Total_Units","v":0}]
[null,"HDA Subsidy per HDA Program Sq Ft",{"$f":"H9/'Unit Mix, Income, Timeline'!G30","v":{"$error":"#DIV/0!"}},{"$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":"#DIV/0!"}},null,"Total HDA Program Units",{"$f":"'Unit Mix, Income, Timeline'!C30","v":0}]
[null,"HDA Subsidy per Affordable Unit",{"$f":"H9/'Unit Mix, Income, Timeline'!C29","v":{"$error":"#DIV/0!"}},{"$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":"#DIV/0!"}},null,"% Program Units",{"$f":"H13/Total_Units","v":{"$error":"#DIV/0!"}}]
[null,"HDA Subsidy per Affordable Sq Ft",{"$f":"H9/'Unit Mix, Income, Timeline'!G29","v":{"$error":"#DIV/0!"}},{"$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":"#DIV/0!"}},null,"Total Affordable Units",{"$f":"'Unit Mix, Income, Timeline'!C29","v":0}]
[null,"TDC per Unit (MKT + Aff.)",{"$f":"'Development Costs'!C63/Total_Units","v":{"$error":"#DIV/0!"}},{"$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":"#DIV/0!"}},null,"% Affordable Units",{"$f":"'Unit Mix, Income, Timeline'!C29/Total_Units","v":{"$error":"#DIV/0!"}}]
[null,"TDC per Sq Ft (MKT + Aff.)",{"$f":"'Development Costs'!C63/'Unit Mix, Income, Timeline'!G28","v":{"$error":"#DIV/0!"}},{"$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":"#DIV/0!"}},null,"Project Type",{"$f":"'Unit Mix, Income, Timeline'!#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, Income, Timeline'!D4=\"\",\"\",'Unit Mix, Income, Timeline'!D4&\" Bed / \"&'Unit Mix, Income, Timeline'!E4&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B4=\"\",\"\",'Unit Mix, Income, Timeline'!B4)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C4=\"\",\"\",'Unit Mix, Income, Timeline'!C4)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L4=\"\", \"\", 'Unit Mix, Income, Timeline'!L4)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F4=\"\", \"\", 'Unit Mix, Income, Timeline'!F4&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D5=\"\",\"\",'Unit Mix, Income, Timeline'!D5&\" Bed / \"&'Unit Mix, Income, Timeline'!E5&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B5=\"\",\"\",'Unit Mix, Income, Timeline'!B5)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C5=\"\",\"\",'Unit Mix, Income, Timeline'!C5)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L5=\"\", \"\", 'Unit Mix, Income, Timeline'!L5)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F5=\"\", \"\", 'Unit Mix, Income, Timeline'!F5&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D6=\"\",\"\",'Unit Mix, Income, Timeline'!D6&\" Bed / \"&'Unit Mix, Income, Timeline'!E6&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B6=\"\",\"\",'Unit Mix, Income, Timeline'!B6)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C6=\"\",\"\",'Unit Mix, Income, Timeline'!C6)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L6=\"\", \"\", 'Unit Mix, Income, Timeline'!L6)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F6=\"\", \"\", 'Unit Mix, Income, Timeline'!F6&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D7=\"\",\"\",'Unit Mix, Income, Timeline'!D7&\" Bed / \"&'Unit Mix, Income, Timeline'!E7&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B7=\"\",\"\",'Unit Mix, Income, Timeline'!B7)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C7=\"\",\"\",'Unit Mix, Income, Timeline'!C7)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L7=\"\", \"\", 'Unit Mix, Income, Timeline'!L7)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F7=\"\", \"\", 'Unit Mix, Income, Timeline'!F7&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D8=\"\",\"\",'Unit Mix, Income, Timeline'!D8&\" Bed / \"&'Unit Mix, Income, Timeline'!E8&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B8=\"\",\"\",'Unit Mix, Income, Timeline'!B8)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C8=\"\",\"\",'Unit Mix, Income, Timeline'!C8)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L8=\"\", \"\", 'Unit Mix, Income, Timeline'!L8)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F8=\"\", \"\", 'Unit Mix, Income, Timeline'!F8&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D9=\"\",\"\",'Unit Mix, Income, Timeline'!D9&\" Bed / \"&'Unit Mix, Income, Timeline'!E9&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B9=\"\",\"\",'Unit Mix, Income, Timeline'!B9)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C9=\"\",\"\",'Unit Mix, Income, Timeline'!C9)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L9=\"\", \"\", 'Unit Mix, Income, Timeline'!L9)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F9=\"\", \"\", 'Unit Mix, Income, Timeline'!F9&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D10=\"\",\"\",'Unit Mix, Income, Timeline'!D10&\" Bed / \"&'Unit Mix, Income, Timeline'!E10&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B10=\"\",\"\",'Unit Mix, Income, Timeline'!B10)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C10=\"\",\"\",'Unit Mix, Income, Timeline'!C10)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L10=\"\", \"\", 'Unit Mix, Income, Timeline'!L10)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F10=\"\", \"\", 'Unit Mix, Income, Timeline'!F10&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D11=\"\",\"\",'Unit Mix, Income, Timeline'!D11&\" Bed / \"&'Unit Mix, Income, Timeline'!E11&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B11=\"\",\"\",'Unit Mix, Income, Timeline'!B11)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C11=\"\",\"\",'Unit Mix, Income, Timeline'!C11)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L11=\"\", \"\", 'Unit Mix, Income, Timeline'!L11)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F11=\"\", \"\", 'Unit Mix, Income, Timeline'!F11&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D12=\"\",\"\",'Unit Mix, Income, Timeline'!D12&\" Bed / \"&'Unit Mix, Income, Timeline'!E12&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B12=\"\",\"\",'Unit Mix, Income, Timeline'!B12)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C12=\"\",\"\",'Unit Mix, Income, Timeline'!C12)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L12=\"\", \"\", 'Unit Mix, Income, Timeline'!L12)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F12=\"\", \"\", 'Unit Mix, Income, Timeline'!F12&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D13=\"\",\"\",'Unit Mix, Income, Timeline'!D13&\" Bed / \"&'Unit Mix, Income, Timeline'!E13&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B13=\"\",\"\",'Unit Mix, Income, Timeline'!B13)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C13=\"\",\"\",'Unit Mix, Income, Timeline'!C13)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L13=\"\", \"\", 'Unit Mix, Income, Timeline'!L13)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F13=\"\", \"\", 'Unit Mix, Income, Timeline'!F13&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D14=\"\",\"\",'Unit Mix, Income, Timeline'!D14&\" Bed / \"&'Unit Mix, Income, Timeline'!E14&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B14=\"\",\"\",'Unit Mix, Income, Timeline'!B14)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C14=\"\",\"\",'Unit Mix, Income, Timeline'!C14)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L14=\"\", \"\", 'Unit Mix, Income, Timeline'!L14)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F14=\"\", \"\", 'Unit Mix, Income, Timeline'!F14&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D15=\"\",\"\",'Unit Mix, Income, Timeline'!D15&\" Bed / \"&'Unit Mix, Income, Timeline'!E15&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B15=\"\",\"\",'Unit Mix, Income, Timeline'!B15)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C15=\"\",\"\",'Unit Mix, Income, Timeline'!C15)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L15=\"\", \"\", 'Unit Mix, Income, Timeline'!L15)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F15=\"\", \"\", 'Unit Mix, Income, Timeline'!F15&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D16=\"\",\"\",'Unit Mix, Income, Timeline'!D16&\" Bed / \"&'Unit Mix, Income, Timeline'!E16&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B16=\"\",\"\",'Unit Mix, Income, Timeline'!B16)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C16=\"\",\"\",'Unit Mix, Income, Timeline'!C16)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L16=\"\", \"\", 'Unit Mix, Income, Timeline'!L16)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F16=\"\", \"\", 'Unit Mix, Income, Timeline'!F16&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D17=\"\",\"\",'Unit Mix, Income, Timeline'!D17&\" Bed / \"&'Unit Mix, Income, Timeline'!E17&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B17=\"\",\"\",'Unit Mix, Income, Timeline'!B17)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C17=\"\",\"\",'Unit Mix, Income, Timeline'!C17)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L17=\"\", \"\", 'Unit Mix, Income, Timeline'!L17)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F17=\"\", \"\", 'Unit Mix, Income, Timeline'!F17&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D18=\"\",\"\",'Unit Mix, Income, Timeline'!D18&\" Bed / \"&'Unit Mix, Income, Timeline'!E18&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B18=\"\",\"\",'Unit Mix, Income, Timeline'!B18)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C18=\"\",\"\",'Unit Mix, Income, Timeline'!C18)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L18=\"\", \"\", 'Unit Mix, Income, Timeline'!L18)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F18=\"\", \"\", 'Unit Mix, Income, Timeline'!F18&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D19=\"\",\"\",'Unit Mix, Income, Timeline'!D19&\" Bed / \"&'Unit Mix, Income, Timeline'!E19&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B19=\"\",\"\",'Unit Mix, Income, Timeline'!B19)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C19=\"\",\"\",'Unit Mix, Income, Timeline'!C19)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L19=\"\", \"\", 'Unit Mix, Income, Timeline'!L19)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F19=\"\", \"\", 'Unit Mix, Income, Timeline'!F19&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D20=\"\",\"\",'Unit Mix, Income, Timeline'!D20&\" Bed / \"&'Unit Mix, Income, Timeline'!E20&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B20=\"\",\"\",'Unit Mix, Income, Timeline'!B20)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C20=\"\",\"\",'Unit Mix, Income, Timeline'!C20)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L20=\"\", \"\", 'Unit Mix, Income, Timeline'!L20)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F20=\"\", \"\", 'Unit Mix, Income, Timeline'!F20&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D21=\"\",\"\",'Unit Mix, Income, Timeline'!D21&\" Bed / \"&'Unit Mix, Income, Timeline'!E21&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B21=\"\",\"\",'Unit Mix, Income, Timeline'!B21)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C21=\"\",\"\",'Unit Mix, Income, Timeline'!C21)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L21=\"\", \"\", 'Unit Mix, Income, Timeline'!L21)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F21=\"\", \"\", 'Unit Mix, Income, Timeline'!F21&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D22=\"\",\"\",'Unit Mix, Income, Timeline'!D22&\" Bed / \"&'Unit Mix, Income, Timeline'!E22&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B22=\"\",\"\",'Unit Mix, Income, Timeline'!B22)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C22=\"\",\"\",'Unit Mix, Income, Timeline'!C22)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L22=\"\", \"\", 'Unit Mix, Income, Timeline'!L22)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F22=\"\", \"\", 'Unit Mix, Income, Timeline'!F22&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D23=\"\",\"\",'Unit Mix, Income, Timeline'!D23&\" Bed / \"&'Unit Mix, Income, Timeline'!E23&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B23=\"\",\"\",'Unit Mix, Income, Timeline'!B23)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C23=\"\",\"\",'Unit Mix, Income, Timeline'!C23)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L23=\"\", \"\", 'Unit Mix, Income, Timeline'!L23)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F23=\"\", \"\", 'Unit Mix, Income, Timeline'!F23&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D24=\"\",\"\",'Unit Mix, Income, Timeline'!D24&\" Bed / \"&'Unit Mix, Income, Timeline'!E24&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B24=\"\",\"\",'Unit Mix, Income, Timeline'!B24)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C24=\"\",\"\",'Unit Mix, Income, Timeline'!C24)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L24=\"\", \"\", 'Unit Mix, Income, Timeline'!L24)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F24=\"\", \"\", 'Unit Mix, Income, Timeline'!F24&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D25=\"\",\"\",'Unit Mix, Income, Timeline'!D25&\" Bed / \"&'Unit Mix, Income, Timeline'!E25&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B25=\"\",\"\",'Unit Mix, Income, Timeline'!B25)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C25=\"\",\"\",'Unit Mix, Income, Timeline'!C25)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L25=\"\", \"\", 'Unit Mix, Income, Timeline'!L25)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F25=\"\", \"\", 'Unit Mix, Income, Timeline'!F25&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D26=\"\",\"\",'Unit Mix, Income, Timeline'!D26&\" Bed / \"&'Unit Mix, Income, Timeline'!E26&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B26=\"\",\"\",'Unit Mix, Income, Timeline'!B26)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C26=\"\",\"\",'Unit Mix, Income, Timeline'!C26)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L26=\"\", \"\", 'Unit Mix, Income, Timeline'!L26)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F26=\"\", \"\", 'Unit Mix, Income, Timeline'!F26&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D27=\"\",\"\",'Unit Mix, Income, Timeline'!D27&\" Bed / \"&'Unit Mix, Income, Timeline'!E27&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B27=\"\",\"\",'Unit Mix, Income, Timeline'!B27)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C27=\"\",\"\",'Unit Mix, Income, Timeline'!C27)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L27=\"\", \"\", 'Unit Mix, Income, Timeline'!L27)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F27=\"\", \"\", 'Unit Mix, Income, Timeline'!F27&\" 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, Income, Timeline'!G28&\" 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'!P5","v":"Pre-Development Costs"},{"$f":"'Sources & Uses'!Q4","v":0},{"$f":"C49/Total_Units","v":{"$error":"#DIV/0!"}},{"$f":"C49/$C$59","v":{"$error":"#DIV/0!"}},null,"Total Rental Income",{"$f":"'Unit Mix, Income, Timeline'!M32","v":0}]
[null,{"$f":"'Sources & Uses'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sources & Uses'!Q5","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"\"Residential Vacancy (\"&TEXT(Residential_Vacancy,\"0%\")&\")\"","v":{"$error":"#REF!"}},{"$f":"-(H49*Residential_Vacancy)","v":{"$error":"#REF!"}}]
[null,{"$f":"'Sources & Uses'!P6","v":"Construction / Rehabilitation Costs"},{"$f":"'Sources & Uses'!Q6","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Total Other Income",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"'Sources & Uses'!P7","v":"General Contractor Overhead & Profit"},{"$f":"'Sources & Uses'!Q7","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"\"Commercial Vacancy (\"&TEXT(Commercial_Vacancy,\"0%\")&\")\"","v":{"$error":"#REF!"}},{"$f":"-(H51*Commercial_Vacancy)","v":{"$error":"#REF!"}}]
[null,{"$f":"'Sources & Uses'!P8","v":"Construction Interest"},{"$f":"'Sources & Uses'!Q8","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Effective Income:",{"$f":"SUM(H49:H52)","v":{"$error":"#REF!"}}]
[null,"Total Construction Costs:",{"$f":"SUM(C49:C53)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Sources & Uses'!P9","v":"Permanent Financing Costs"},{"$f":"'Sources & Uses'!Q9","v":0},{"$f":"C55/$H$12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"KEY METRICS"]
[null,{"$f":"'Sources & Uses'!P10","v":"Developer's Fee"},{"$f":"'Sources & Uses'!Q10","v":0},{"$f":"C56/$H$12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"DDF % of LIHTC Basis",{"$f":"DDF/'Development Costs'!F63","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Sources & Uses'!P11","v":"Operating/Rent-Up Reserves"},{"$f":"'Sources & Uses'!Q11","v":0},{"$f":"C57/$H$12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"DDF % Total Developer Fee",{"$f":"DDF/'Development Costs'!C46","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Sources & Uses'!P12","v":"Other Soft/Carrying Costs"},{"$f":"'Sources & Uses'!Q12","v":0},{"$f":"C58/$H$12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"Construction Contingency %",{"$f":"'Development Costs'!C43","v":{"$error":"#DIV/0!"}}]
[null,"Total Uses of Funds:",{"$f":"C54+SUM(C55:C58)","v":0},{"$f":"C59/$H$12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},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'!B6&\" (Hard Debt)\"","v":"First Mortgage (Hard Debt)"},{"$f":"'Sources & Uses'!K6","v":0},{"$f":"C63/$H$12","v":{"$error":"#DIV/0!"}},{"$f":"C63/$C$79","v":{"$error":"#DIV/0!"}},null,"Metric","Lower Bound","Upper Bound"]
[null,{"$f":"'Sources & Uses'!B7&\" (Hard Debt)\"","v":"Second Mortgage (Hard Debt)"},{"$f":"'Sources & Uses'!K7","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Debt Service Ratio",1.1000000000000001,1.25]
[null,{"$f":"'Sources & Uses'!B9&\" (Hard Debt)\"","v":"Etc… Please Label (Hard Debt)"},{"$f":"'Sources & Uses'!K9","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"HDA Subsidy per HDA Program Unit",40000,100000]
[null,{"$f":"'Sources & Uses'!B14&\" (Soft Debt)\"","v":"Deferred Developer Fee (Soft Debt)"},{"$f":"'Sources & Uses'!K14","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"HDA Subsidy per HDA Program Sq Ft",90,150]
[null,{"$f":"'Sources & Uses'!B15&\" (Soft Debt)\"","v":"HDA Loan (Soft Debt)"},{"$f":"'Sources & Uses'!K15","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"HDA Subsidy per Affordable Unit",40000,70000]
[null,{"$f":"'Sources & Uses'!B17&\" (Soft Debt)\"","v":"Etc… Please Label (Soft Debt)"},{"$f":"'Sources & Uses'!K17","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"HDA Subsidy per Affordable Sq Ft",90,150]
[null,{"$f":"'Sources & Uses'!B23:B23&\" (Equity)\"","v":"Federal LIHTC (Equity)"},{"$f":"'Sources & Uses'!K23","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"TDC per Unit (MKT + Aff.)",150000,300000]
[null,{"$f":"'Sources & Uses'!B24:B24&\" (Equity)\"","v":"Other Tax Credit (Equity)"},{"$f":"'Sources & Uses'!K24","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"TDC per Sq Ft (MKT + Aff.)",400,550]
[null,{"$f":"'Sources & Uses'!B25:B25&\" (Equity)\"","v":"Grant 1 (Equity)"},{"$f":"'Sources & Uses'!K25","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Sources & Uses'!B26:B26&\" (Equity)\"","v":"Grant 2 (Equity)"},{"$f":"'Sources & Uses'!K26","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Sources & Uses'!B27:B27&\" (Equity)\"","v":"Grant 3 (Equity)"},{"$f":"'Sources & Uses'!K27","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Sources & Uses'!B28:B28&\" (Equity)\"","v":"Developer Equity (Not DDF) (Equity)"},{"$f":"'Sources & Uses'!K28","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Sources & Uses'!B29:B29&\" (Equity)\"","v":"Interim Income (Occ Rehabs) (Equity)"},{"$f":"'Sources & Uses'!K29","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'Sources & Uses'!B30:B30&\" (Equity)\"","v":"Other (Equity)"},{"$f":"'Sources & Uses'!K30","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Total Debt:",{"$f":"SUM(C63:C68)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Total Equity:",{"$f":"SUM(C69:C76)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Total Sources of Funds:",{"$f":"SUM(C77:C78)","v":0},{"$f":"SUM(D77:D78)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]

{"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":"'Development Costs'!C5/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$f":"C5-B5","v":{"$error":"#DIV/0!"}},{"$f":"'Development Costs'!C5/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$f":"F5-E5","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Development Costs'!C6/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C6/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C7/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C7/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C8/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C8/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C9/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C9/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C10/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C10/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C11/Total_Units","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C5:C10)","v":0},{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C11/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F5:F10)","v":0},{"$error":"#DIV/0!"}]
[]
[null,{"$f":"'Development Costs'!C13/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$f":"C13-B13","v":{"$error":"#DIV/0!"}},{"$f":"'Development Costs'!C13/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$f":"F13-E13","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Development Costs'!C14/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$f":"C14-B14","v":{"$error":"#DIV/0!"}},{"$f":"'Development Costs'!C14/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$f":"F14-E14","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Development Costs'!C15/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$f":"C15-B15","v":{"$error":"#DIV/0!"}},{"$f":"'Development Costs'!C15/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$f":"F15-E15","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Development Costs'!C16/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$f":"C16-B16","v":{"$error":"#DIV/0!"}},{"$f":"'Development Costs'!C16/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$f":"F16-E16","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Development Costs'!C17/Total_Units","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C13:C16)","v":0},{"$f":"C17-B17","v":{"$error":"#DIV/0!"}},{"$f":"'Development Costs'!C17/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F13:F16)","v":0},{"$f":"F17-E17","v":{"$error":"#DIV/0!"}}]
[]
[null,{"$f":"'Development Costs'!C19/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$f":"C19-B19","v":{"$error":"#DIV/0!"}},{"$f":"'Development Costs'!C19/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$f":"F19-E19","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Development Costs'!C20/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C20/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C21/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C21/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C22/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C22/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C23/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C23/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C24/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C24/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C25/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C25/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C26/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C26/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C27/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C27/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C28/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C28/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C29/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C29/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C30/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C30/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C31/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C31/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C32/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C32/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C33/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C33/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C34/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C34/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C35/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C35/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C36/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C36/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C37/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C37/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C38/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C38/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C39/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C39/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C40/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C40/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C41/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C41/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C42/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C42/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[]
[null,{"$f":"'Development Costs'!C44/Total_Units","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C19:C43)","v":0},{"$f":"C44-B44","v":{"$error":"#DIV/0!"}},{"$f":"'Development Costs'!C44/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F19:F43)","v":0},{"$f":"F44-E44","v":{"$error":"#DIV/0!"}}]
[]
[null,{"$f":"'Development Costs'!C46/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$f":"C46-B46","v":{"$error":"#DIV/0!"}},{"$f":"'Development Costs'!C46/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$f":"F46-E46","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'Development Costs'!C47/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C47/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C48/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C48/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C49/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C49/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C50/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C50/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C51/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C51/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C52/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C52/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C53/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C53/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C54/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C54/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C55/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C55/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C56/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C56/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C57/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C57/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C58/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C58/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C59/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C59/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C60/Total_Units","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C60/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,{"$f":"'Development Costs'!C61/Total_Units","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C46:C60)","v":0},{"$error":"#DIV/0!"},{"$f":"'Development Costs'!C61/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F46:F60)","v":0},{"$error":"#DIV/0!"}]
[]
[null,{"$f":"'Development Costs'!C63/Total_Units","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C11,C17,C44,C61)","v":0},{"$f":"C63-B63","v":{"$error":"#DIV/0!"}},{"$f":"'Development Costs'!C63/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F11,F17,F44,F61)","v":0},{"$f":"F63-E63","v":{"$error":"#DIV/0!"}}]

{"sheet":"ProForma Comparision","index":2,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":true,"merged":[[2,1,2,9]]}
[]
[]
[null,"Year 1 Annual Operating Expense Assumptions"]
[null,"Expense Item","Annual Amount","Exp. Per Unit",null,"Industry Exp. Per Unit","Exp. Per Unit Comparison","Exp. Per Sq Ft","Industry Exp Per Sq ft","Exp. Per Sq Ft Comparison"]
[null,"General & Administrative",{"$f":"ProForma!C4","v":0},{"$error":"#DIV/0!"},null,null,{"$f":"D5-F5","v":{"$error":"#DIV/0!"}},{"$f":"C5/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$f":"H5-I5","v":{"$error":"#DIV/0!"}}]
[null,"Management Fee",{"$f":"ProForma!C5","v":0},{"$error":"#DIV/0!"},null,null,{"$f":"D6-F6","v":{"$error":"#DIV/0!"}},{"$f":"C6/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$f":"H6-I6","v":{"$error":"#DIV/0!"}}]
[null,"Management Fee % of Total Rent",{"$f":"C6/(SUM('ProForma Comparision'!#REF!))","v":{"$error":"#REF!"}}]
[null,"Employee Payroll",{"$f":"ProForma!C7","v":0},{"$f":"C8/Total_Units","v":{"$error":"#REF!"}},null,null,{"$f":"D8-F8","v":{"$error":"#REF!"}},{"$f":"C8/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$f":"H8-I8","v":{"$error":"#DIV/0!"}}]
[null,"Repairs & Maintenance",{"$f":"ProForma!C8","v":0},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$f":"C9/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,"Contracted Services",{"$f":"ProForma!C9","v":0},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$f":"C10/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,"Electric & Gas Utilities ",{"$f":"ProForma!C10","v":0},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$f":"C11/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,"Water, Sewer & Trash Utilities",{"$f":"ProForma!C11","v":0},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$f":"C12/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,"Leasing & Marketing",{"$f":"ProForma!C12","v":0},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$f":"C13/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,"Property Insurance Premiums",{"$f":"ProForma!C13","v":0},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$f":"C14/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,"Property Tax",{"$f":"ProForma!C14","v":0},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$f":"C15/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,"Compliance Fees",{"$f":"ProForma!C15","v":0},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$f":"C16/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,"Other Expenses (Describe)",{"$f":"ProForma!C16","v":0},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$f":"C17/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,"Other Expenses (Describe)",{"$f":"ProForma!C17","v":0},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$f":"C18/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,"Required Replacement Reserves",{"$f":"ProForma!C18","v":0},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$f":"C19/'Unit Mix, Income, Timeline'!$G$28","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,"Required RR Per Unit",{"$error":"#DIV/0!"}]

{"sheet":"MFI&FMR","index":3,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":true,"merged":[[2,11,2,16],[3,12,3,16],[44,5,44,6],[35,8,35,9],[36,8,36,9],[37,8,37,9],[38,8,38,9],[39,8,39,9],[40,8,40,9],[41,8,41,9],[42,8,42,9],[43,8,43,9],[38,5,38,6],[39,5,39,6],[42,5,42,6],[43,5,43,6],[44,8,44,9],[32,2,32,9],[35,5,35,6],[36,5,36,6],[37,5,37,6],[40,5,40,6],[41,5,41,6],[2,1,2,9],[31,1,31,9],[18,2,18,9],[34,5,34,6],[3,2,3,9],[17,1,17,9],[34,8,34,9],[33,8,33,9],[33,5,33,6]]}
[]
[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,null,null,null,null,null,null,null," MSA Fair Market Rents (FMRs) By Unit Bedrooms"]
[null,null,"Persons in Family",null,null,null,null,null,null,null,null,null,"Bedrooms"]
[null,"MFI Level",1,2,3,4,5,6,7,8,null,"Year",0,1,2,3,4]
[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,"FY 2025",1549,1650,1949,2484,2882]
[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, Income, Timeline'!#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,{"$f":"E8/0.5","v":113400},126000,136100,{"$f":"H8/0.5","v":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]
[]
[null,"Max Monthly Rent by MFI and Number of Persons in Family (based on 12 Months and 30% of Annual Income)"]
[null,null,"Persons in Family"]
[null,"MFI Level",1,2,3,4,5,6,7,8]
[null,0.3,{"$f":"(C6*30%)/12","v":661.25},{"$f":"(D6*30%)/12","v":756.25},850,945,1020,1096.25,1171.25,1247.5]
[null,0.4,{"$f":"(C7*30%)/12","v":882.5},1007.5,1133.75,1260,1361.25,1461.25,1562.5,1663.75]
[null,0.5,1102.5,1260,1417.5,1575,1701.25,1827.5,1952.5,2078.75]
[null,0.6,1322.5,1512.5,1701.25,1890,2041.25,2192.5,2343.75,2495]
[null,0.7,1543.75,1763.75,1985,2205,2381.25,2557.5,2733.75,2910]
[null,0.8,1763.75,2016.25,2267.5,2520,2721.25,2923.75,3125,3326.25]
[null,0.9,1985,2267.5,2551.25,2835,3061.25,3288.75,3515,3742.5]
[null,1,2205,2520,2835,3150,3402.5,3655,3905,4157.5]
[null,1.1000000000000001,2425,2772.5,3118.75,3465,3742.5,4020,4296.25,4573.75]
[null,1.2,2646.25,3023.75,3402.5,3780,4082.5,4385,4687.5,4990]
[]
[null,"Max Monthly Rent by MFI and Number of Bedrooms (based on 1.5 People per Bedroom)"]
[null,null,"Calculated People (1.5*Bedrooms)"]
[null,"MFI Level",1,1.5,3,4.5,null,6,7.5]
[null,"Bedrooms:",0,1,2,3,null,4,5]
[null,0.3,{"$f":"C21","v":661.25},{"$f":"((C21+D21)/2)","v":708.75},{"$f":"E21","v":850},{"$f":"((F21+G21)/2)","v":982.5},null,{"$f":"H21","v":1096.25},{"$f":"((I21+J21)/2)","v":1209.375}]
[null,0.4,{"$f":"C22","v":882.5},945,{"$f":"E22","v":1133.75},1310.625,null,{"$f":"H22","v":1461.25},1613.125]
[null,0.5,1102.5,1181.25,1417.5,1638.125,null,1827.5,2015.625]
[null,0.6,1322.5,{"$f":"((C24+D24)/2)","v":1417.5},1701.25,{"$f":"((F24+G24)/2)","v":1965.625},null,2192.5,{"$f":"((I24+J24)/2)","v":2419.375}]
[null,0.7,1543.75,{"$f":"((C25+D25)/2)","v":1653.75},1985,{"$f":"((F25+G25)/2)","v":2293.125},null,2557.5,{"$f":"((I25+J25)/2)","v":2821.875}]
[null,0.8,1763.75,1890,2267.5,2620.625,null,2923.75,3225.625]
[null,0.9,1985,2126.25,2551.25,2948.125,null,3288.75,3628.75]
[null,1,2205,2362.5,2835,3276.25,null,3655,4031.25]
[null,1.1000000000000001,2425,2598.75,3118.75,3603.75,null,4020,4435]
[null,1.2,2646.25,2835,3402.5,3931.25,null,4385,4838.75]

{"sheet":"LIHTC Calculator","index":4,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":true,"merged":[[1,1,1,2],[3,1,3,2],[8,1,8,2],[18,1,18,2]]}
[]
[null,"LIHTC Estimate Calculation"]
[]
[null,"LIHTC Eligible Basis"]
[null,"Eligible Development Costs",{"$f":"'Development Costs'!F63","v":0}]
[null,"Additional Ineligible (Grants, Other)"]
[null,"Total LIHTC Eligible Basis:",{"$f":"SUM(C5:C6)","v":0}]
[]
[null,"Applicable Fraction Method"]
[null,"Total LIHTC Units",{"$f":"'Unit Mix, Income, Timeline'!C29","v":0}]
[null,"Total Units",{"$f":"Total_Units","v":0}]
[null,"LIHTC Unit %",{"$f":"IF(C11=0,0,C10/C11)","v":0}]
[]
[null,"Total LIHTC Square Feet",{"$f":"'Unit Mix, Income, Timeline'!G29","v":0}]
[null,"Total Square Feet",{"$f":"'Unit Mix, Income, Timeline'!G28","v":0}]
[null,"LIHTC Square Feet %",{"$f":"IF(C15=0,0,C14/C15)","v":0}]
[null,"Applicable Fraction:",{"$f":"MIN(C12,C16)","v":0}]
[]
[null,"LIHTC Calculation"]
[null,"Eligible Basis",{"$f":"C7","v":0}]
[null,"Applicable Fraction",{"$f":"C17","v":0}]
[null,"Basis Boost Factor"]
[null,"Credit Type (4% or 9%)",{"$f":"IF('Unit Mix, Income, Timeline'!#REF!=\"N/A\",0,'Unit Mix, Income, Timeline'!#REF!)","v":{"$error":"#REF!"}}]
[null,"Annual Credits",{"$f":"C20*C21*C22*C23","v":{"$error":"#REF!"}}]
[null,"LIHTC Equity Price ($/credit)"]
[null,"Total LIHTC Equity Estimate:",{"$f":"C24*C25*10","v":{"$error":"#REF!"}}]
[]
[null,"Developer LIHTC Assumption:",{"$f":"'Sources & Uses'!K23","v":0}]

{"sheet":"Instructions","index":5,"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 Assistiance 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 beige 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":6,"n_rows":307,"n_cols":23,"rows_kept":307,"cut":false,"hidden":false,"merged":[[23,5,23,6],[1,1,1,6],[49,18,49,19],[51,17,51,18],[3,1,3,2],[3,5,3,6],[15,5,15,6],[17,6,18,6],[17,5,18,5]]}
[]
[null,"RHDA 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,null,null,null,null,null,null,null,null,"40 years",null,"Burnet Rd",1.02]
[null,null,null,null,null,"Co-Developer (If applicable)"]
[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,"Developer Contact Name"]
[]
[null,"Project Type",null,null,null,"Service Provider Name (If applicable for CoC units)"]
[null,"Tenant Type",null,null,null,"Service Provider Contact Name"]
[null,"Federal LIHTC Type"]
[null,"Bond Mobility Corridor",null,null,null,"Continuum of Care (CoC) Units"]
[null,"Census Tract",null,null,null,"Please define which CoC populations are applicable","# Units",null,null,null,null,"100% Affordable",null,null,null,null,null,null,null,"50 years",null,"East MLK/FM 969",2.04]
[null,"Council District",null,null,null,"Undefined mix of either Rapid Re-Housing (RRH) or Permanent Supportive Housing (PSH) units",null,null,null,null,null,"Rehabilitation",null,null,null,"1/4 mile",null,null,null,"70 years",null,"William Cannon Dr",3.04]
[null,"Elementary School"]
[null,null,null,null,null,"Rapid Re-Housing (RRH) units",null,null,null,null,null,null,null,null,null,null,null,null,null,"45 years",null,"Airport Blvd",2.0299999999999998]
[null,"Affordability Period Requested (greater than or equal to 40 years)",null,null,null,"Permanent Supportive Housing (PSH) units"]
[null,null,null,null,null,"Total CoC units",{"$f":"IF(SUM(G18:G21)=0,\"\")","v":""},null,null,null,null,"Mixed-Income",null,null,null,null,null,null,null,"55 years",null,"South Lamar Blvd",2.0499999999999998]
[null,"Will SMART Housing fee waivers 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,"Will Affordability Unlocked be utilized?",null,null,null,"Accesible Units"]
[null,"Will Tenant Relocation be Required",null,null,null,"Accessible Units for Mobility Impairments (Minimum 10% of total units)"]
[null,"Is the property within 1/2 mile of an Imagine Austin Corridor?",null,null,null,"Accessible Units for Sensory Impairments (Minimum 2% of total units)"]
[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,"UNIT MIX",null,null,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,"Description","Type","AMI","# Units",null,"Size",null,null,null,null,null,null,null,null,"1 mile",null,null,null,"80 years",null,"N Lamar & Guadalupe St",3.06]
[null,{"$f":"IF(D34=\"\",\"\",IF(D34=\"MKT\",\"Market Rate Units\",IF(D34<=50%,\"HDA Program Units\",\"Affordable Housing Units\")))","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!D4=\"\",\"\",'Unit Mix, Income, Timeline'!D4&\" Bed / \"&'Unit Mix, Income, Timeline'!E4&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B4=\"\",\"\",'Unit Mix, Income, Timeline'!B4)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C4=\"\",\"\",'Unit Mix, Income, Timeline'!C4)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L4=\"\", \"\", 'Unit Mix, Income, Timeline'!L4)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!F4=\"\", \"\", 'Unit Mix, Income, Timeline'!F4&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,"> 1 mile",null,null,null,"85 years",null,"Rundberg",3.07]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D5=\"\",\"\",'Unit Mix, Income, Timeline'!D5&\" Bed / \"&'Unit Mix, Income, Timeline'!E5&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B5=\"\",\"\",'Unit Mix, Income, Timeline'!B5)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C5=\"\",\"\",'Unit Mix, Income, Timeline'!C5)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L5=\"\", \"\", 'Unit Mix, Income, Timeline'!L5)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!F5=\"\", \"\", 'Unit Mix, Income, Timeline'!F5&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"90 years",null,"Colony Loop Dr",4.01]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D6=\"\",\"\",'Unit Mix, Income, Timeline'!D6&\" Bed / \"&'Unit Mix, Income, Timeline'!E6&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B6=\"\",\"\",'Unit Mix, Income, Timeline'!B6)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C6=\"\",\"\",'Unit Mix, Income, Timeline'!C6)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L6=\"\", \"\", 'Unit Mix, Income, Timeline'!L6)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!F6=\"\", \"\", 'Unit Mix, Income, Timeline'!F6&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"99 Years",null,"MLK Blvd",4.0199999999999996]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D7=\"\",\"\",'Unit Mix, Income, Timeline'!D7&\" Bed / \"&'Unit Mix, Income, Timeline'!E7&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B7=\"\",\"\",'Unit Mix, Income, Timeline'!B7)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C7=\"\",\"\",'Unit Mix, Income, Timeline'!C7)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L7=\"\", \"\", 'Unit Mix, Income, Timeline'!L7)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!F7=\"\", \"\", 'Unit Mix, Income, Timeline'!F7&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,"Acquisition",null,null,null,null,null,"South Congress Ave",5]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D8=\"\",\"\",'Unit Mix, Income, Timeline'!D8&\" Bed / \"&'Unit Mix, Income, Timeline'!E8&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B8=\"\",\"\",'Unit Mix, Income, Timeline'!B8)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C8=\"\",\"\",'Unit Mix, Income, Timeline'!C8)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L8=\"\", \"\", 'Unit Mix, Income, Timeline'!L8)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!F8=\"\", \"\", 'Unit Mix, Income, Timeline'!F8&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,"Pre-development",null,null,null,null,null,"Manchaca Rd",6.01]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D9=\"\",\"\",'Unit Mix, Income, Timeline'!D9&\" Bed / \"&'Unit Mix, Income, Timeline'!E9&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B9=\"\",\"\",'Unit Mix, Income, Timeline'!B9)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C9=\"\",\"\",'Unit Mix, Income, Timeline'!C9)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L9=\"\", \"\", 'Unit Mix, Income, Timeline'!L9)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!F9=\"\", \"\", 'Unit Mix, Income, Timeline'!F9&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,"Construction",null,null,null,null,null,"S. Pleasant Valley Rd",6.03]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D10=\"\",\"\",'Unit Mix, Income, Timeline'!D10&\" Bed / \"&'Unit Mix, Income, Timeline'!E10&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B10=\"\",\"\",'Unit Mix, Income, Timeline'!B10)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C10=\"\",\"\",'Unit Mix, Income, Timeline'!C10)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L10=\"\", \"\", 'Unit Mix, Income, Timeline'!L10)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!F10=\"\", \"\", 'Unit Mix, Income, Timeline'!F10&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.04]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D11=\"\",\"\",'Unit Mix, Income, Timeline'!D11&\" Bed / \"&'Unit Mix, Income, Timeline'!E11&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B11=\"\",\"\",'Unit Mix, Income, Timeline'!B11)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C11=\"\",\"\",'Unit Mix, Income, Timeline'!C11)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L11=\"\", \"\", 'Unit Mix, Income, Timeline'!L11)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!F11=\"\", \"\", 'Unit Mix, Income, Timeline'!F11&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D12=\"\",\"\",'Unit Mix, Income, Timeline'!D12&\" Bed / \"&'Unit Mix, Income, Timeline'!E12&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B12=\"\",\"\",'Unit Mix, Income, Timeline'!B12)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C12=\"\",\"\",'Unit Mix, Income, Timeline'!C12)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L12=\"\", \"\", 'Unit Mix, Income, Timeline'!L12)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!F12=\"\", \"\", 'Unit Mix, Income, Timeline'!F12&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District 1",8.01]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D13=\"\",\"\",'Unit Mix, Income, Timeline'!D13&\" Bed / \"&'Unit Mix, Income, Timeline'!E13&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B13=\"\",\"\",'Unit Mix, Income, Timeline'!B13)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C13=\"\",\"\",'Unit Mix, Income, Timeline'!C13)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L13=\"\", \"\", 'Unit Mix, Income, Timeline'!L13)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!F13=\"\", \"\", 'Unit Mix, Income, Timeline'!F13&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District 2",8.02]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D14=\"\",\"\",'Unit Mix, Income, Timeline'!D14&\" Bed / \"&'Unit Mix, Income, Timeline'!E14&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B14=\"\",\"\",'Unit Mix, Income, Timeline'!B14)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C14=\"\",\"\",'Unit Mix, Income, Timeline'!C14)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L14=\"\", \"\", 'Unit Mix, Income, Timeline'!L14)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!F14=\"\", \"\", 'Unit Mix, Income, Timeline'!F14&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District 3",8.0299999999999994]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D15=\"\",\"\",'Unit Mix, Income, Timeline'!D15&\" Bed / \"&'Unit Mix, Income, Timeline'!E15&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B15=\"\",\"\",'Unit Mix, Income, Timeline'!B15)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C15=\"\",\"\",'Unit Mix, Income, Timeline'!C15)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L15=\"\", \"\", 'Unit Mix, Income, Timeline'!L15)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!F15=\"\", \"\", 'Unit Mix, Income, Timeline'!F15&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District 4"]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D16=\"\",\"\",'Unit Mix, Income, Timeline'!D16&\" Bed / \"&'Unit Mix, Income, Timeline'!E16&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B16=\"\",\"\",'Unit Mix, Income, Timeline'!B16)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C16=\"\",\"\",'Unit Mix, Income, Timeline'!C16)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L16=\"\", \"\", 'Unit Mix, Income, Timeline'!L16)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!F16=\"\", \"\", 'Unit Mix, Income, Timeline'!F16&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District 5"]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D17=\"\",\"\",'Unit Mix, Income, Timeline'!D17&\" Bed / \"&'Unit Mix, Income, Timeline'!E17&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B17=\"\",\"\",'Unit Mix, Income, Timeline'!B17)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C17=\"\",\"\",'Unit Mix, Income, Timeline'!C17)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L17=\"\", \"\", 'Unit Mix, Income, Timeline'!L17)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!F17=\"\", \"\", 'Unit Mix, Income, Timeline'!F17&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District 6"]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D18=\"\",\"\",'Unit Mix, Income, Timeline'!D18&\" Bed / \"&'Unit Mix, Income, Timeline'!E18&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B18=\"\",\"\",'Unit Mix, Income, Timeline'!B18)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C18=\"\",\"\",'Unit Mix, Income, Timeline'!C18)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L18=\"\", \"\", 'Unit Mix, Income, Timeline'!L18)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!F18=\"\", \"\", 'Unit Mix, Income, Timeline'!F18&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District 7"]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D19=\"\",\"\",'Unit Mix, Income, Timeline'!D19&\" Bed / \"&'Unit Mix, Income, Timeline'!E19&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B19=\"\",\"\",'Unit Mix, Income, Timeline'!B19)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C19=\"\",\"\",'Unit Mix, Income, Timeline'!C19)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L19=\"\", \"\", 'Unit Mix, Income, Timeline'!L19)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!F19=\"\", \"\", 'Unit Mix, Income, Timeline'!F19&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District 8"]
[null,"Total / Wtd. Avg.",null,null,{"$f":"SUM(E34:E49)","v":0},null,{"$f":"'Unit Mix, Income, Timeline'!G17&\" ft\"&CHAR(178)","v":" ft²"},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,null,null,null,null,"No"]
[]
[null,null,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"]

{"sheet":"Unit Mix, Income, Timeline","index":7,"n_rows":63,"n_cols":28,"rows_kept":63,"cut":false,"hidden":false,"merged":[[36,8,36,12],[63,5,63,6],[1,14,1,16],[29,4,29,5],[28,4,28,5],[29,10,29,11],[28,10,28,11],[27,4,27,5],[27,10,27,11],[1,1,1,12],[62,5,62,6],[49,5,49,6],[50,5,50,6],[51,5,51,6],[52,5,52,6],[53,5,53,6],[54,5,54,6],[45,5,45,6],[46,5,46,6],[47,5,47,6],[48,5,48,6],[60,5,60,6],[55,5,55,6],[56,5,56,6],[57,5,57,6],[58,5,58,6],[59,5,59,6],[34,10,34,11],[33,10,33,11],[32,10,32,11],[30,4,30,5],[31,10,31,11],[30,10,30,11],[44,5,44,6],[36,1,36,7],[37,5,37,6],[38,5,38,6],[43,5,43,6],[42,5,42,6],[41,5,41,6],[40,5,40,6],[39,5,39,6]]}
[]
[null,"Unit Mix",null,null,null,null,null,null,null,null,null,null,null,null,"Construction Timeline"]
[null,"Median Family Income (MFI)","Unit Count","Bedrooms","Bathrooms","Per Unit Sq Ft","Total Sq Ft Unit Type","Fair Market Rent (FMR)","Voucher Rents","Max Allowable LIHTC Rent","Utility Allowance","Rent Collected per Unit","Total Rent Collected per Unit Type",null,"Site Control","Start Date","End Date"]
[null,null,null,null,null,null,{"$f":"IF(F4=\"\",\"\",F4*C4)","v":""},{"$f":"IF(D4=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D4,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B4=\"\",B4=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B4,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D4,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,{"$f":"IF(L4=\"\",\"\",L4*C4)","v":""},null,"Acquisition",null,"N/A "]
[null,null,null,null,null,null,"",{"$f":"IF(D5=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D5,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B5=\"\",B5=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B5,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D5,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,"",null,"Zoning"]
[null,null,null,null,null,null,"",{"$f":"IF(D6=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D6,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B6=\"\",B6=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B6,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D6,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,"",null,"Environmental Review"]
[null,null,null,null,null,null,"",{"$f":"IF(D7=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D7,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B7=\"\",B7=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B7,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D7,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,"",null,"Pre-Development"]
[null,null,null,null,null,null,"",{"$f":"IF(D8=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D8,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B8=\"\",B8=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B8,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D8,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,"",null,"Contract Execution",null,"N/A "]
[null,null,null,null,null,null,"",{"$f":"IF(D9=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D9,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B9=\"\",B9=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B9,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D9,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,"",null,"Closing of Other Financing"]
[null,null,null,null,null,null,"",{"$f":"IF(D10=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D10,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B10=\"\",B10=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B10,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D10,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,"",null,"Development Services Review"]
[null,null,null,null,null,null,"",{"$f":"IF(D11=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D11,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B11=\"\",B11=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B11,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D11,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,"",null,"Construction"]
[null,null,null,null,null,null,"",{"$f":"IF(D12=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D12,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B12=\"\",B12=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B12,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D12,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,"",null,"Site Preparation"]
[null,null,null,null,null,null,"",{"$f":"IF(D13=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D13,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B13=\"\",B13=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B13,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D13,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,"",null,"25% Complete",null,"N/A "]
[null,null,null,null,null,null,"",{"$f":"IF(D14=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D14,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B14=\"\",B14=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B14,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D14,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,"",null,"50% Complete",null,"N/A "]
[null,null,null,null,null,null,"",{"$f":"IF(D15=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D15,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B15=\"\",B15=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B15,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D15,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,"",null,"75% Complete",null,"N/A "]
[null,null,null,null,null,null,"",{"$f":"IF(D16=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D16,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B16=\"\",B16=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B16,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D16,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,"",null,"100% Complete",null,"N/A "]
[null,null,null,null,null,null,"",{"$f":"IF(D17=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D17,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B17=\"\",B17=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B17,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D17,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,"",null,"Marketing"]
[null,null,null,null,null,null,"",{"$f":"IF(D18=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D18,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B18=\"\",B18=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B18,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D18,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,"",null,"Pre-Listing"]
[null,null,null,null,null,null,"",{"$f":"IF(D19=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D19,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B19=\"\",B19=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B19,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D19,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,"",null,"Marketing Plan"]
[null,null,null,null,null,null,"",{"$f":"IF(D20=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D20,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B20=\"\",B20=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B20,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D20,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,"",null,"Wait List Process"]
[null,null,null,null,null,null,"",{"$f":"IF(D21=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D21,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B21=\"\",B21=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B21,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D21,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,"",null,"Leasing"]
[null,null,null,null,null,null,"",{"$f":"IF(D22=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D22,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B22=\"\",B22=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B22,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D22,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,"",null,"Lease Up"]
[null,null,null,null,null,null,"",{"$f":"IF(D23=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D23,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B23=\"\",B23=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B23,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D23,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,"",null,"Close Out"]
[null,null,null,null,null,null,"",{"$f":"IF(D24=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D24,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B24=\"\",B24=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B24,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D24,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,""]
[null,null,null,null,null,null,"",{"$f":"IF(D25=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D25,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B25=\"\",B25=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B25,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D25,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,""]
[null,null,null,null,null,null,"",{"$f":"IF(D26=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D26,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B26=\"\",B26=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B26,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D26,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,""]
[null,null,null,null,null,null,"",{"$f":"IF(D27=\"\",\"\",INDEX('MFI&FMR'!$M$6:$Q$6,MATCH('Unit Mix, Income, Timeline'!$D27,'MFI&FMR'!$M$5:$Q$5,0)))","v":""},null,{"$f":"IF(OR(B27=\"\",B27=\"MKT\"),\"\",INDEX('MFI&FMR'!$B$35:$J$45,MATCH('Unit Mix, Income, Timeline'!$B27,'MFI&FMR'!$B$35:$B$45,0),MATCH('Unit Mix, Income, Timeline'!$D27,'MFI&FMR'!$B$35:$J$35,0)))","v":""},null,null,""]
[null,"Total Units:",{"$f":"SUM(C4:C27)","v":0},null,"Total Square Footage:",null,{"$f":"SUM(G4:G27)","v":0},null,null,null,"Total Potential Monthly Rent:",null,{"$f":"SUM(M4:M27)","v":0}]
[null," \" Affordable:",{"$f":"Total_Units-C31","v":0},null,"\" Affordable:",null,{"$f":"G28-G31","v":0},null,null,null,"\" Affordable:",null,{"$f":"M28-M31","v":0}]
[null,"\" HDA Program:",{"$f":"SUMIF(B4:B27, \"<= 50%\", C4:C27)","v":0},null,"\" HDA Program:",null,{"$f":"SUMIF(B4:B27, \"<= 50%\", G4:G27)","v":0},null,null,null,"\" HDA Program:",null,{"$f":"SUMIF(B4:B27, \"<= 50%\", M4:M27)","v":0}]
[null," \" Market Rate:",{"$f":"SUMIF(B4:B27, \"MKT\", C4:C27)","v":0},null,"\" Market Rate:",null,{"$f":"SUMIF(B4:B27, \"MKT\", G4:G27)","v":0},null,null,null,"\" Market Rate:",null,{"$f":"SUMIF(B4:B27,\"MKT\", M4:M27)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Total Potential Annual Rent:",null,{"$f":"M28*12","v":0}]
[null,null,null,null,null,null,null,null,null,null,"\" Affordable:",null,{"$f":"M29*12","v":0}]
[null,null,null,null,null,null,null,null,null,null,"\" HDA Program:",null,{"$f":"M30*12","v":0}]
[null,null,null,null,null,null,null,null,null,null,"\" Market Rate:",null,{"$f":"M31*12","v":0}]
[]
[null,"UNIT MIX",null,null,null,null,null,null,"Average Square Foot AHFC Units at or Below 50% MFI"]
[null,"Description","Type","AMI","# Units","Contract Rent",null,"Size","Sudio/Efficiency","1-bdrm","2-bdrm","3-bdrm","4-bdrm"]
[null,{"$f":"IF(D39=\"\",\"\",IF(D39=\"MKT\",\"Market Rate Units\",IF(D39<=50%,\"HDA Program Units\",\"Affordable Housing Units\")))","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!D4=\"\",\"\",'Unit Mix, Income, Timeline'!D4&\" Bed / \"&'Unit Mix, Income, Timeline'!E4&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B4=\"\",\"\",'Unit Mix, Income, Timeline'!B4)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C4=\"\",\"\",'Unit Mix, Income, Timeline'!C4)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L4=\"\", \"\", 'Unit Mix, Income, Timeline'!L4)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F4=\"\", \"\", 'Unit Mix, Income, Timeline'!F4&\" ft\"&CHAR(178))","v":""},{"$f":"IFERROR(SUM(SUMIFS($G$4:$G$27,$B$4:$B$27,$AA$41:$AA$49,$D$4:$D$27,$AB$41))/SUM(SUMIFS($C$4:$C$27,$B$4:$B$27,$AA$41:$AA$49,$D$4:$D$27,$AB$41)),\"\")","v":""},{"$f":"IFERROR(SUM(SUMIFS($G$4:$G$27,$B$4:$B$27,$AA$41:$AA$49,$D$4:$D$27,$AB$42))/SUM(SUMIFS($C$4:$C$27,$B$4:$B$27,$AA$41:$AA$49,$D$4:$D$27,$AB$42)),\"\")","v":""},{"$f":"IFERROR(SUM(SUMIFS($G$4:$G$27,$B$4:$B$27,$AA$41:$AA$49,$D$4:$D$27,$AB$43))/SUM(SUMIFS($C$4:$C$27,$B$4:$B$27,$AA$41:$AA$49,$D$4:$D$27,$AB$43)),\"\")","v":""},{"$f":"IFERROR(SUM(SUMIFS($G$4:$G$27,$B$4:$B$27,$AA$41:$AA$49,$D$4:$D$27,$AB$44))/SUM(SUMIFS($C$4:$C$27,$B$4:$B$27,$AA$41:$AA$49,$D$4:$D$27,$AB$44)),\"\")","v":""},{"$f":"IFERROR(SUM(SUMIFS($G$4:$G$27,$B$4:$B$27,$AA$41:$AA$49,$D$4:$D$27,$AB$45))/SUM(SUMIFS($C$4:$C$27,$B$4:$B$27,$AA$41:$AA$49,$D$4:$D$27,$AB$45)),\"\")","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D5=\"\",\"\",'Unit Mix, Income, Timeline'!D5&\" Bed / \"&'Unit Mix, Income, Timeline'!E5&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B5=\"\",\"\",'Unit Mix, Income, Timeline'!B5)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C5=\"\",\"\",'Unit Mix, Income, Timeline'!C5)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L5=\"\", \"\", 'Unit Mix, Income, Timeline'!L5)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F5=\"\", \"\", 'Unit Mix, Income, Timeline'!F5&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D6=\"\",\"\",'Unit Mix, Income, Timeline'!D6&\" Bed / \"&'Unit Mix, Income, Timeline'!E6&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B6=\"\",\"\",'Unit Mix, Income, Timeline'!B6)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C6=\"\",\"\",'Unit Mix, Income, Timeline'!C6)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L6=\"\", \"\", 'Unit Mix, Income, Timeline'!L6)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F6=\"\", \"\", 'Unit Mix, Income, Timeline'!F6&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,0]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D7=\"\",\"\",'Unit Mix, Income, Timeline'!D7&\" Bed / \"&'Unit Mix, Income, Timeline'!E7&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B7=\"\",\"\",'Unit Mix, Income, Timeline'!B7)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C7=\"\",\"\",'Unit Mix, Income, Timeline'!C7)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L7=\"\", \"\", 'Unit Mix, Income, Timeline'!L7)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F7=\"\", \"\", 'Unit Mix, Income, Timeline'!F7&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,1]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D8=\"\",\"\",'Unit Mix, Income, Timeline'!D8&\" Bed / \"&'Unit Mix, Income, Timeline'!E8&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B8=\"\",\"\",'Unit Mix, Income, Timeline'!B8)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C8=\"\",\"\",'Unit Mix, Income, Timeline'!C8)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L8=\"\", \"\", 'Unit Mix, Income, Timeline'!L8)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F8=\"\", \"\", 'Unit Mix, Income, Timeline'!F8&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,2]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D9=\"\",\"\",'Unit Mix, Income, Timeline'!D9&\" Bed / \"&'Unit Mix, Income, Timeline'!E9&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B9=\"\",\"\",'Unit Mix, Income, Timeline'!B9)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C9=\"\",\"\",'Unit Mix, Income, Timeline'!C9)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L9=\"\", \"\", 'Unit Mix, Income, Timeline'!L9)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F9=\"\", \"\", 'Unit Mix, Income, Timeline'!F9&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30% CoC",3]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D10=\"\",\"\",'Unit Mix, Income, Timeline'!D10&\" Bed / \"&'Unit Mix, Income, Timeline'!E10&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B10=\"\",\"\",'Unit Mix, Income, Timeline'!B10)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C10=\"\",\"\",'Unit Mix, Income, Timeline'!C10)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L10=\"\", \"\", 'Unit Mix, Income, Timeline'!L10)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F10=\"\", \"\", 'Unit Mix, Income, Timeline'!F10&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40% CoC",4]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D11=\"\",\"\",'Unit Mix, Income, Timeline'!D11&\" Bed / \"&'Unit Mix, Income, Timeline'!E11&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B11=\"\",\"\",'Unit Mix, Income, Timeline'!B11)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C11=\"\",\"\",'Unit Mix, Income, Timeline'!C11)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L11=\"\", \"\", 'Unit Mix, Income, Timeline'!L11)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F11=\"\", \"\", 'Unit Mix, Income, Timeline'!F11&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50% CoC"]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D12=\"\",\"\",'Unit Mix, Income, Timeline'!D12&\" Bed / \"&'Unit Mix, Income, Timeline'!E12&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B12=\"\",\"\",'Unit Mix, Income, Timeline'!B12)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C12=\"\",\"\",'Unit Mix, Income, Timeline'!C12)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L12=\"\", \"\", 'Unit Mix, Income, Timeline'!L12)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F12=\"\", \"\", 'Unit Mix, Income, Timeline'!F12&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30% PSH"]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D13=\"\",\"\",'Unit Mix, Income, Timeline'!D13&\" Bed / \"&'Unit Mix, Income, Timeline'!E13&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B13=\"\",\"\",'Unit Mix, Income, Timeline'!B13)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C13=\"\",\"\",'Unit Mix, Income, Timeline'!C13)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L13=\"\", \"\", 'Unit Mix, Income, Timeline'!L13)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F13=\"\", \"\", 'Unit Mix, Income, Timeline'!F13&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40% PSH"]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D14=\"\",\"\",'Unit Mix, Income, Timeline'!D14&\" Bed / \"&'Unit Mix, Income, Timeline'!E14&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B14=\"\",\"\",'Unit Mix, Income, Timeline'!B14)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C14=\"\",\"\",'Unit Mix, Income, Timeline'!C14)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L14=\"\", \"\", 'Unit Mix, Income, Timeline'!L14)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F14=\"\", \"\", 'Unit Mix, Income, Timeline'!F14&\" ft\"&CHAR(178))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50% PSH"]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D15=\"\",\"\",'Unit Mix, Income, Timeline'!D15&\" Bed / \"&'Unit Mix, Income, Timeline'!E15&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B15=\"\",\"\",'Unit Mix, Income, Timeline'!B15)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C15=\"\",\"\",'Unit Mix, Income, Timeline'!C15)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L15=\"\", \"\", 'Unit Mix, Income, Timeline'!L15)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F15=\"\", \"\", 'Unit Mix, Income, Timeline'!F15&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D16=\"\",\"\",'Unit Mix, Income, Timeline'!D16&\" Bed / \"&'Unit Mix, Income, Timeline'!E16&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B16=\"\",\"\",'Unit Mix, Income, Timeline'!B16)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C16=\"\",\"\",'Unit Mix, Income, Timeline'!C16)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L16=\"\", \"\", 'Unit Mix, Income, Timeline'!L16)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F16=\"\", \"\", 'Unit Mix, Income, Timeline'!F16&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D17=\"\",\"\",'Unit Mix, Income, Timeline'!D17&\" Bed / \"&'Unit Mix, Income, Timeline'!E17&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B17=\"\",\"\",'Unit Mix, Income, Timeline'!B17)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C17=\"\",\"\",'Unit Mix, Income, Timeline'!C17)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L17=\"\", \"\", 'Unit Mix, Income, Timeline'!L17)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F17=\"\", \"\", 'Unit Mix, Income, Timeline'!F17&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D18=\"\",\"\",'Unit Mix, Income, Timeline'!D18&\" Bed / \"&'Unit Mix, Income, Timeline'!E18&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B18=\"\",\"\",'Unit Mix, Income, Timeline'!B18)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C18=\"\",\"\",'Unit Mix, Income, Timeline'!C18)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L18=\"\", \"\", 'Unit Mix, Income, Timeline'!L18)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F18=\"\", \"\", 'Unit Mix, Income, Timeline'!F18&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D19=\"\",\"\",'Unit Mix, Income, Timeline'!D19&\" Bed / \"&'Unit Mix, Income, Timeline'!E19&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B19=\"\",\"\",'Unit Mix, Income, Timeline'!B19)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C19=\"\",\"\",'Unit Mix, Income, Timeline'!C19)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L19=\"\", \"\", 'Unit Mix, Income, Timeline'!L19)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F19=\"\", \"\", 'Unit Mix, Income, Timeline'!F19&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D20=\"\",\"\",'Unit Mix, Income, Timeline'!D20&\" Bed / \"&'Unit Mix, Income, Timeline'!E20&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B20=\"\",\"\",'Unit Mix, Income, Timeline'!B20)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C20=\"\",\"\",'Unit Mix, Income, Timeline'!C20)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L20=\"\", \"\", 'Unit Mix, Income, Timeline'!L20)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F20=\"\", \"\", 'Unit Mix, Income, Timeline'!F20&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D21=\"\",\"\",'Unit Mix, Income, Timeline'!D21&\" Bed / \"&'Unit Mix, Income, Timeline'!E21&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B21=\"\",\"\",'Unit Mix, Income, Timeline'!B21)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C21=\"\",\"\",'Unit Mix, Income, Timeline'!C21)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L21=\"\", \"\", 'Unit Mix, Income, Timeline'!L21)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F21=\"\", \"\", 'Unit Mix, Income, Timeline'!F21&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D22=\"\",\"\",'Unit Mix, Income, Timeline'!D22&\" Bed / \"&'Unit Mix, Income, Timeline'!E22&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B22=\"\",\"\",'Unit Mix, Income, Timeline'!B22)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C22=\"\",\"\",'Unit Mix, Income, Timeline'!C22)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L22=\"\", \"\", 'Unit Mix, Income, Timeline'!L22)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F22=\"\", \"\", 'Unit Mix, Income, Timeline'!F22&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D23=\"\",\"\",'Unit Mix, Income, Timeline'!D23&\" Bed / \"&'Unit Mix, Income, Timeline'!E23&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B23=\"\",\"\",'Unit Mix, Income, Timeline'!B23)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C23=\"\",\"\",'Unit Mix, Income, Timeline'!C23)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L23=\"\", \"\", 'Unit Mix, Income, Timeline'!L23)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F23=\"\", \"\", 'Unit Mix, Income, Timeline'!F23&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D24=\"\",\"\",'Unit Mix, Income, Timeline'!D24&\" Bed / \"&'Unit Mix, Income, Timeline'!E24&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B24=\"\",\"\",'Unit Mix, Income, Timeline'!B24)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C24=\"\",\"\",'Unit Mix, Income, Timeline'!C24)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L24=\"\", \"\", 'Unit Mix, Income, Timeline'!L24)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F24=\"\", \"\", 'Unit Mix, Income, Timeline'!F24&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D25=\"\",\"\",'Unit Mix, Income, Timeline'!D25&\" Bed / \"&'Unit Mix, Income, Timeline'!E25&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B25=\"\",\"\",'Unit Mix, Income, Timeline'!B25)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C25=\"\",\"\",'Unit Mix, Income, Timeline'!C25)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L25=\"\", \"\", 'Unit Mix, Income, Timeline'!L25)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F25=\"\", \"\", 'Unit Mix, Income, Timeline'!F25&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D26=\"\",\"\",'Unit Mix, Income, Timeline'!D26&\" Bed / \"&'Unit Mix, Income, Timeline'!E26&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B26=\"\",\"\",'Unit Mix, Income, Timeline'!B26)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C26=\"\",\"\",'Unit Mix, Income, Timeline'!C26)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L26=\"\", \"\", 'Unit Mix, Income, Timeline'!L26)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F26=\"\", \"\", 'Unit Mix, Income, Timeline'!F26&\" ft\"&CHAR(178))","v":""}]
[null,"",{"$f":"IF('Unit Mix, Income, Timeline'!D27=\"\",\"\",'Unit Mix, Income, Timeline'!D27&\" Bed / \"&'Unit Mix, Income, Timeline'!E27&\" Bath\")","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!B27=\"\",\"\",'Unit Mix, Income, Timeline'!B27)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!C27=\"\",\"\",'Unit Mix, Income, Timeline'!C27)","v":""},{"$f":"IF('Unit Mix, Income, Timeline'!L27=\"\", \"\", 'Unit Mix, Income, Timeline'!L27)","v":""},null,{"$f":"IF('Unit Mix, Income, Timeline'!F27=\"\", \"\", 'Unit Mix, Income, Timeline'!F27&\" ft\"&CHAR(178))","v":""}]
[null,"Total / Wtd. Avg.",null,null,{"$f":"SUM(E39:E62)","v":0},{"$f":"SUMPRODUCT(E39:E62,G39:G62)/E63","v":{"$error":"#DIV/0!"}},null,{"$f":"'Unit Mix, Income, Timeline'!G28&\" ft\"&CHAR(178)","v":"0 ft²"}]

{"sheet":"Sources & Uses","index":8,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[[19,12,19,13],[24,5,24,6],[25,5,25,6],[26,5,26,6],[24,7,24,9],[25,7,25,9],[26,7,26,9],[11,5,11,6],[20,7,20,10],[11,7,11,10],[22,5,22,6],[23,5,23,6],[21,7,21,9],[22,7,22,9],[23,7,23,9],[21,5,21,6],[20,5,20,6],[12,7,12,8],[13,7,13,8],[14,7,14,8],[16,7,16,8],[15,7,15,8],[27,5,27,6],[28,5,28,6],[29,5,29,6],[28,7,28,9],[29,7,29,9],[27,7,27,9],[1,1,1,10],[1,15,1,16],[2,15,2,16],[2,5,2,6],[2,7,2,10],[1,12,1,13],[2,12,2,13]]}
[]
[null,"Sources",null,null,null,null,null,null,null,null,null,null,"Sources (Permanent Phase)",null,null,"Uses"]
[null,"Hard Debt Service Financing",null,null,null,"Construction Period",null,"Permanent Period",null,null,null,null,"Financing Sources*",null,null,"Development Costs"]
[null,"Type of Funds","Source of Funds","Committed? (Yes, No, or App Pending)","If No, Additional Details","Interest Rate","Total Amount","Annual Payment","Interest Rate","Loan Term","Total Amount",null,"Debt",0,null,"Acquisition Costs",{"$f":"'Development Costs'!$C$11","v":0}]
[null,"Construction Loan","Construction Loan Bank 1",null,null,null,null,null,null,null,null,null,"Equity",0,null,"Pre-Development Costs",{"$f":"'Development Costs'!C17","v":0}]
[null,"First Mortgage","Mortgage Bank 1",null,null,null,null,null,null,null,null,null,"Grant",0,null,"Construction / Rehabilitation Costs",{"$f":"SUM('Development Costs'!$C$44-'Development Costs'!$C$39)","v":0}]
[null,"Second Mortgage","Mortgage Bank 2",null,null,null,null,null,null,null,null,null,"Other  ",0,null,"General Contractor Overhead & Profit",{"$f":"'Development Costs'!$C$39","v":0}]
[null,"Third Mortgage","Mortgage Bank 3",null,null,null,null,null,null,null,null,null,"AHFC Funding Request",0,null,"Construction Interest",{"$f":"'Development Costs'!$C$52","v":0}]
[null,"Etc… Please Label","Mortgage Bank 3",null,null,null,null,null,null,null,null,null,"Previous AHFC Funding Award",0,null,"Permanent Financing Costs",{"$f":"'Development Costs'!C55","v":0}]
[null,null,null,null,null,null,"Total Hard Debt Service:",{"$f":"SUM(H6:H9)","v":0},null,"Total Hard Debt:",{"$f":"SUM(K6:K9)","v":0},null,"Other",0,null,"Developer's Fee",{"$f":"'Development Costs'!$C$46","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Other",0,null,"Operating/Rent-Up Reserves",{"$f":"'Development Costs'!$C$59","v":0}]
[null,"Soft Debt Service (Cash Flow) Financing",null,null,null,"Construction Period",null,"Permanent Period",null,null,null,null,"Other",0,null,"Other Soft/Carrying Costs",{"$f":"'Development Costs'!C61-'Development Costs'!C46-'Development Costs'!C52-'Development Costs'!C55-'Development Costs'!C59","v":0}]
[null,"Type of Funds","Source of Funds","Committed? (Yes, No, or App Submitted)","If No, Additional Details","Interest Rate","Total Amount","% of Remaining Cash Flow",null,"Loan Term","Total Amount",null,"Total Uses of Funds:",{"$f":"SUM(N4:N12)","v":0},null,"Total Uses of Funds:",{"$f":"SUM(Q4:Q12)","v":0}]
[null,"Deferred Developer Fee","Developer",null,null,null,null,1,null,"N/A",null,null,null,null,null,null,{"$f":"IF((Q13-N13)=0,\"\",Q13-N13)","v":""}]
[null,"HDA Loan","AHFC",null,null,null,null,1,null,"N/A",null,null,"*Please separate separate all funding sources on different rows and label each",null,null,null,{"$f":"IF((Q13-K32)=0,\"\",Q13-K32)","v":""}]
[null,"Soft Loan 2",null,null,null,null,null,1,null,"N/A"]
[null,"Etc… Please Label",null,null,null,null,null,1,null,"N/A"]
[null,null,null,null,null,null,null,null,null,"Total Soft Debt:",{"$f":"SUM(K14:K17)","v":0}]
[null,null,null,null,null,null,null,null,null,"Total Debt (Hard + Soft):",{"$f":"SUM(K18,K10)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sources + Uses Comparison"]
[null,"Equity Financing",null,null,null,"Construction Period",null,"Permanent Period",null,null,null,null,"Total Uses of Funds:",{"$f":"Q13","v":0}]
[null,"Type of Funds",null,"Committed?","If No, Additional Details","Total Amount",null,"Description",null,null,"Total Amount",null,"Total Sources of Funds (Debt + Equity):",{"$f":"K32","v":0}]
[null,"Federal LIHTC",null,null,null,null,null,null,null,null,null,null,"Total Sources of Funds (Construction):",{"$f":"G31","v":0}]
[null,"Other Tax Credit"]
[null,"Grant 1"]
[null,"Grant 2"]
[null,"Grant 3"]
[null,"Developer Equity (Not DDF)"]
[null,"Interim Income (Occ Rehabs)"]
[null,"Other"]
[null,null,null,null,null,"Total Sources of Funds (Construction):",{"$f":"SUM(G5:G9,G14:G17,F23:G30)","v":0},null,null,"Total Equity:",{"$f":"SUM(K23:K30)","v":0}]
[null,null,null,null,null,null,null,null,null,"Total Sources of Funds (Debt + Equity):",{"$f":"K31+K19","v":0}]

{"sheet":"Development Costs","index":9,"n_rows":72,"n_cols":6,"rows_kept":72,"cut":false,"hidden":false,"merged":[[3,1,3,3],[44,1,44,3],[1,1,1,3],[69,2,69,3],[64,1,64,3],[65,1,65,3],[66,2,66,3],[67,2,67,3],[68,2,68,3],[64,5,64,7],[66,5,66,7],[68,5,68,7],[17,1,17,3],[71,5,75,7]]}
[]
[null,"Development Budget",null,null,null,"LIHTC Basis"]
[null,null,"Project Cost","Requested AHFC Funds",null,"Amount Included in LIHTC Basis"]
[null,"Pre-Development"]
[null,"Appraisal",null,null,null,{"$f":"C5","v":0}]
[null,"Environmental Review",null,null,null,0]
[null,"Engineering",null,null,null,0]
[null,"Survey",null,null,null,0]
[null,"Architectural",null,null,null,0]
[null,"Other Pre-Development Costs (Detailed Description*)",null,null,null,0]
[null,"Subtotal Pre-Development Cost:",{"$f":"SUM(C5:C10)","v":0},{"$f":"SUM(D5:D10)","v":0},null,{"$f":"SUM(F5:F10)","v":0}]
[null,"Acquisition"]
[null,"Site and/or Land"]
[null,"Structures*",null,null,null,{"$f":"C14","v":0}]
[null,"Closing Costs"]
[null,"Other Acquisition Costs (Detailed Description*)"]
[null,"Subtotal Acquisition Cost:",{"$f":"SUM(C13:C16)","v":0},{"$f":"SUM(D13:D16)","v":0},null,{"$f":"SUM(F13:F16)","v":0}]
[null,"Construction / Rehabilitation Costs"]
[null,"Infrastructure",null,null,null,{"$f":"C19","v":0}]
[null,"Site Work",null,null,null,{"$f":"C20","v":0}]
[null,"Demolition"]
[null,"Concrete",null,null,null,{"$f":"C22","v":0}]
[null,"Masonry",null,null,null,0]
[null,"Rough Carpentry",null,null,null,0]
[null,"Finish Carpentry",null,null,null,0]
[null,"Waterproofing and Insulation",null,null,null,0]
[null,"Roofing and Sheet Metal",null,null,null,0]
[null,"Plumbing/Hot Water",null,null,null,0]
[null,"HVAC/Mechanical",null,null,null,0]
[null,"Electrical",null,null,null,0]
[null,"Doors/Windows/Glass",null,null,null,0]
[null,"Lath and Plaster/Drywall and Acoustical",null,null,null,0]
[null,"Tile Work",null,null,null,0]
[null,"Soft and Hard Floor",null,null,null,0]
[null,"Paint/Decorating/Blinds/Shades",null,null,null,0]
[null,"Specialties/Special Equipment",null,null,null,0]
[null,"Cabinetry/Appliances",null,null,null,0]
[null,"Carpet",null,null,null,0]
[null,"General Contractor Overhead and Profit",null,null,null,0]
[null,"Commercial Space Costs"]
[null,"Other Construction Costs (Detailed Description*)",null,null,null,{"$f":"C41","v":0}]
[null,"Construction Contingency",null,null,null,{"$f":"C42","v":0}]
[null,"Contingency % of Total Construction Costs",{"$f":"C42/C44","v":{"$error":"#DIV/0!"}}]
[null,"Subtotal Construction Cost:",{"$f":"SUM(C19:C42)","v":0},{"$f":"SUM(D19:D43)","v":0},null,{"$f":"SUM(F19:F43)","v":0}]
[null,"Soft & Carrying Costs"]
[null,"Developer Fee",null,null,null,{"$f":"C46","v":0}]
[null,"Legal Fees"]
[null,"Tax Credit Fees"]
[null,"Audit/Accounting",null,null,null,{"$f":"C49","v":0}]
[null,"Title/Recording",null,null,null,0]
[null,"Architectural (Inspections)",null,null,null,0]
[null,"Construction Interest",null,null,null,0]
[null,"Construction Period Insurance",null,null,null,0]
[null,"Construction Period Taxes",null,null,null,0]
[null,"Permanent Financing Costs"]
[null,"Tenant Relocation"]
[null,"Marketing"]
[null,"Compliance Monitoring",null,null,null,{"$f":"C58","v":0}]
[null,"Operating/Rent-Up Reserves"]
[null,"Other Soft & Carrying Costs (Detailed Description*)",null,null,null,{"$f":"C60","v":0}]
[null,"Subtotal Soft & Carrying Cost:",{"$f":"SUM(C46:C60)","v":0},{"$f":"SUM(D46:D60)","v":0},null,{"$f":"SUM(F46:F60)","v":0}]
[]
[null,"Total Development Costs (TDC):",{"$f":"SUM(C11,C17,C44,C61)","v":0},{"$f":"SUM(D11,D17,D44,D61)","v":0},null,{"$f":"SUM(F11,F17,F44,F61)","v":0}]
[]
[null,"*Detailed Descriptions of \"Other\" Line Items",null,null,null,"Eligible Basis"]
[null,"**Must breakout each item included in \"Other\" and corresponding cost**",null,null,null,{"$f":"F63-F59-SUM(F55:F57)-SUM(F47:F48)-F40-F21-SUM(F15:F16)-F13","v":0}]
[null,{"$f":"IF(C10=\"\", \"\", TEXT(C10,\"$#,##\")&\" Other Pre-Development Costs\")","v":""},null,null,null,"Eligible Basis Minus Dev Fee"]
[null,{"$f":"IF(C16=\"\", \"\", TEXT(C16,\"$#,##\")&\" Other Acquisition Costs\")","v":""},null,null,null,{"$f":"F66-F46","v":0}]
[null,{"$f":"IF(C41=\"\",\"\",TEXT(C41,\"$#,##\")&\" Other Construction Costs\")","v":""},null,null,null,"Developer Fee % of Eligible Basis*"]
[null,{"$f":"IF(C60=\"\", \"\", TEXT(C60, \"$#,##\")&\" Other Pre-Development Costs\")","v":""},null,null,null,{"$f":"F46/F68","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":"ProForma","index":10,"n_rows":92,"n_cols":22,"rows_kept":92,"cut":false,"hidden":false,"merged":[[20,1,20,2],[26,1,26,2],[1,1,1,3]]}
[]
[null,"Year 1 Annual Operating Expense Assumptions"]
[null,"Expense Item","Annual Amount","Exp. Per Unit"]
[null,"General & Administrative",null,{"$f":"C4/'Unit Mix, Income, Timeline'!$C$28","v":{"$error":"#DIV/0!"}}]
[null,"Management Fee",null,{"$f":"C5/'Unit Mix, Income, Timeline'!$C$28","v":{"$error":"#DIV/0!"}}]
[null,"Management Fee % of Total Rent",{"$f":"C5/(SUM(ProForma!C37:C39))","v":{"$error":"#DIV/0!"}}]
[null,"Employee Payroll",null,{"$f":"C7/'Unit Mix, Income, Timeline'!$C$28","v":{"$error":"#DIV/0!"}}]
[null,"Repairs & Maintenance",null,{"$f":"C8/'Unit Mix, Income, Timeline'!$C$28","v":{"$error":"#DIV/0!"}}]
[null,"Contracted Services",null,{"$f":"C9/'Unit Mix, Income, Timeline'!$C$28","v":{"$error":"#DIV/0!"}}]
[null,"Electric & Gas Utilities ",null,{"$f":"C10/'Unit Mix, Income, Timeline'!$C$28","v":{"$error":"#DIV/0!"}}]
[null,"Water, Sewer & Trash Utilities",null,{"$f":"C11/'Unit Mix, Income, Timeline'!$C$28","v":{"$error":"#DIV/0!"}}]
[null,"Leasing & Marketing",null,{"$f":"C12/'Unit Mix, Income, Timeline'!$C$28","v":{"$error":"#DIV/0!"}}]
[null,"Property Insurance Premiums",null,{"$f":"C13/'Unit Mix, Income, Timeline'!$C$28","v":{"$error":"#DIV/0!"}}]
[null,"Property Tax",null,{"$f":"C14/'Unit Mix, Income, Timeline'!$C$28","v":{"$error":"#DIV/0!"}}]
[null,"Compliance Fees",null,{"$f":"C15/'Unit Mix, Income, Timeline'!$C$28","v":{"$error":"#DIV/0!"}}]
[null,"Other Expenses (Describe)",null,{"$f":"C16/'Unit Mix, Income, Timeline'!$C$28","v":{"$error":"#DIV/0!"}}]
[null,"Other Expenses (Describe)",null,{"$f":"C17/'Unit Mix, Income, Timeline'!$C$28","v":{"$error":"#DIV/0!"}}]
[null,"Required Replacement Reserves",null,{"$f":"C18/'Unit Mix, Income, Timeline'!$C$28","v":{"$error":"#DIV/0!"}}]
[null,"Required RR Per Unit",{"$f":"Required_Replacement_Reserve/'Unit Mix, Income, Timeline'!C28","v":{"$error":"#DIV/0!"}}]
[]
[null,"Growth/Escalator Assumptions (%'s)"]
[null,"Income Growth",0.02]
[null,"Expense Growth",0.03]
[null,"Residential Vacancy (Specify)",7.4999999999999997E-2]
[null,"Other Revenue Vacancy (Specify)",0.1]
[]
[null,"Commercial and Other Revenue"]
[null,"Description","Annual"]
[]
[]
[]
[null,"Annual Commercial/Other Revenue:",{"$f":"SUM(C29:C31)","v":0}]
[]
[null,null,"ProForma Assumes Year 1 is Stabilized"]
[null,"20-Year Operating ProForma","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20"]
[null,"Annual Income"]
[null,"Low Income Units",{"$f":"'Unit Mix, Income, Timeline'!M33","v":0},{"$f":"C37*(1+Income_Growth)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"S37*(1+Income_Growth)","v":0},0,0]
[null,"Market Rate Units",{"$f":"'Unit Mix, Income, Timeline'!M35","v":0},{"$f":"C38*(1+Income_Growth)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"S38*(1+Income_Growth)","v":0},0,0]
[null,"Residential Vacancy Allowance",{"$f":"-((C37+C38)*Residential_Vacancy)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Commercial Income",{"$f":"ProForma!C32","v":0},{"$f":"C40*(1+Income_Growth)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Commercial Vacancy Allowance",{"$f":"-(C40*Commercial_Vacancy)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Effective Gross Income",{"$f":"SUM(C37:C41)","v":0},{"$f":"SUM(D37:D41)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Annual Expenses"]
[null,"General & Administrative",{"$f":"ProForma!C4","v":0},{"$f":"C45*(1+Expense_Growth)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Management Fee",{"$f":"ProForma!C5","v":0},{"$f":"C46*(1+Expense_Growth)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Employee Payroll",{"$f":"ProForma!C7","v":0},{"$f":"C47*(1+Expense_Growth)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Repairs & Maintenance",{"$f":"ProForma!C8","v":0},{"$f":"C48*(1+Expense_Growth)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Contracted Services",{"$f":"ProForma!C9","v":0},{"$f":"C49*(1+Expense_Growth)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Electric & Gas Utilities ",{"$f":"ProForma!C10","v":0},{"$f":"C50*(1+Expense_Growth)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Water, Sewer & Trash Utilities",{"$f":"ProForma!C11","v":0},{"$f":"C51*(1+Expense_Growth)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Leasing & Marketing",{"$f":"ProForma!C12","v":0},{"$f":"C52*(1+Expense_Growth)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"S52*(1+Expense_Growth)","v":0},0,0]
[null,"Property Insurance Premiums",{"$f":"ProForma!C13","v":0},{"$f":"C53*(1+Expense_Growth)","v":0},{"$f":"D53*(1+Expense_Growth)","v":0},{"$f":"E53*(1+Expense_Growth)","v":0},{"$f":"F53*(1+Expense_Growth)","v":0},{"$f":"G53*(1+Expense_Growth)","v":0},{"$f":"H53*(1+Expense_Growth)","v":0},{"$f":"I53*(1+Expense_Growth)","v":0},{"$f":"J53*(1+Expense_Growth)","v":0},{"$f":"K53*(1+Expense_Growth)","v":0},{"$f":"L53*(1+Expense_Growth)","v":0},{"$f":"M53*(1+Expense_Growth)","v":0},{"$f":"N53*(1+Expense_Growth)","v":0},{"$f":"O53*(1+Expense_Growth)","v":0},{"$f":"P53*(1+Expense_Growth)","v":0},{"$f":"Q53*(1+Expense_Growth)","v":0},{"$f":"R53*(1+Expense_Growth)","v":0},{"$f":"S53*(1+Expense_Growth)","v":0},{"$f":"T53*(1+Expense_Growth)","v":0},{"$f":"U53*(1+Expense_Growth)","v":0}]
[null,"Property Tax",{"$f":"ProForma!C14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Compliance Fees",{"$f":"ProForma!C15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Other Expenses",{"$f":"ProForma!C16","v":0},{"$f":"C56*(1+Expense_Growth)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Operating Expenses",{"$f":"SUM(C45:C56)","v":0},{"$f":"SUM(D45:D56)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Net Operating Income (NOI)",{"$f":"C42-C57","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Required Replacement Reserve",{"$f":"Required_Replacement_Reserve","v":0},{"$f":"C61*(1+Expense_Growth)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"NOI after Required Replacement Reserve",{"$f":"C59-C61","v":0},{"$f":"D59-D61","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Annual Hard Debt Service Financing"]
[]
[null,{"$f":"'Sources & Uses'!B6&\" Payment\"","v":"First Mortgage Payment"},{"$f":"IF('Sources & Uses'!K6<\"0\",'Sources & Uses'!H6,0)","v":0},{"$f":"IF(C67>0,MIN('Sources & Uses'!$H$6,C67),0)","v":0},{"$f":"IF(D67>0,MIN('Sources & Uses'!$H$6,D67),0)","v":0},{"$f":"IF(E67>0,MIN('Sources & Uses'!$H$6,E67),0)","v":0},{"$f":"IF(F67>0,MIN('Sources & Uses'!$H$6,F67),0)","v":0},{"$f":"IF(G67>0,MIN('Sources & Uses'!$H$6,G67),0)","v":0},{"$f":"IF(H67>0,MIN('Sources & Uses'!$H$6,H67),0)","v":0},{"$f":"IF(I67>0,MIN('Sources & Uses'!$H$6,I67),0)","v":0},{"$f":"IF(J67>0,MIN('Sources & Uses'!$H$6,J67),0)","v":0},{"$f":"IF(K67>0,MIN('Sources & Uses'!$H$6,K67),0)","v":0},{"$f":"IF(L67>0,MIN('Sources & Uses'!$H$6,L67),0)","v":0},{"$f":"IF(M67>0,MIN('Sources & Uses'!$H$6,M67),0)","v":0},{"$f":"IF(N67>0,MIN('Sources & Uses'!$H$6,N67),0)","v":0},{"$f":"IF(O67>0,MIN('Sources & Uses'!$H$6,O67),0)","v":0},{"$f":"IF(P67>0,MIN('Sources & Uses'!$H$6,P67),0)","v":0},{"$f":"IF(Q67>0,MIN('Sources & Uses'!$H$6,Q67),0)","v":0},{"$f":"IF(R67>0,MIN('Sources & Uses'!$H$6,R67),0)","v":0},{"$f":"IF(S67>0,MIN('Sources & Uses'!$H$6,S67),0)","v":0},{"$f":"IF(T67>0,MIN('Sources & Uses'!$H$6,T67),0)","v":0},{"$f":"IF(U67>0,MIN('Sources & Uses'!$H$6,U67),0)","v":0}]
[null,{"$f":"\"Balance of \"&'Sources & Uses'!B6","v":"Balance of First Mortgage"},{"$f":"'Sources & Uses'!K6-ProForma!C66","v":0},{"$f":"C67-D66","v":0},{"$f":"D67-E66","v":0},0,0,0,{"$f":"H67-I66","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Sources & Uses'!B7&\" Payment\"","v":"Second Mortgage Payment"},{"$f":"IF('Sources & Uses'!K9<\"0\",'Sources & Uses'!H7,0)","v":0},{"$f":"IF(C69>0,MIN('Sources & Uses'!$H$7,C69),0)","v":0},{"$f":"IF(D69>0,MIN('Sources & Uses'!$H$7,D69),0)","v":0},{"$f":"IF(E69>0,MIN('Sources & Uses'!$H$7,E69),0)","v":0},{"$f":"IF(F69>0,MIN('Sources & Uses'!$H$7,F69),0)","v":0},{"$f":"IF(G69>0,MIN('Sources & Uses'!$H$7,G69),0)","v":0},{"$f":"IF(H69>0,MIN('Sources & Uses'!$H$7,H69),0)","v":0},{"$f":"IF(I69>0,MIN('Sources & Uses'!$H$7,I69),0)","v":0},{"$f":"IF(J69>0,MIN('Sources & Uses'!$H$7,J69),0)","v":0},{"$f":"IF(K69>0,MIN('Sources & Uses'!$H$7,K69),0)","v":0},{"$f":"IF(L69>0,MIN('Sources & Uses'!$H$7,L69),0)","v":0},{"$f":"IF(M69>0,MIN('Sources & Uses'!$H$7,M69),0)","v":0},{"$f":"IF(N69>0,MIN('Sources & Uses'!$H$7,N69),0)","v":0},{"$f":"IF(O69>0,MIN('Sources & Uses'!$H$7,O69),0)","v":0},{"$f":"IF(P69>0,MIN('Sources & Uses'!$H$7,P69),0)","v":0},{"$f":"IF(Q69>0,MIN('Sources & Uses'!$H$7,Q69),0)","v":0},{"$f":"IF(R69>0,MIN('Sources & Uses'!$H$7,R69),0)","v":0},{"$f":"IF(S69>0,MIN('Sources & Uses'!$H$7,S69),0)","v":0},{"$f":"IF(T69>0,MIN('Sources & Uses'!$H$7,T69),0)","v":0},{"$f":"IF(U69>0,MIN('Sources & Uses'!$H$7,U69),0)","v":0}]
[null,{"$f":"\"Balance of \"&'Sources & Uses'!B7","v":"Balance of Second Mortgage"},{"$f":"'Sources & Uses'!K7-ProForma!C68","v":0},{"$f":"C69-D68","v":0},{"$f":"D69-E68","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Sources & Uses'!B9&\" Payment\"","v":"Etc… Please Label Payment"},{"$f":"IF('Sources & Uses'!K11<\"0\",'Sources & Uses'!H9,0)","v":0},{"$f":"IF(C71>0,MIN('Sources & Uses'!$H$9,C71),0)","v":0},{"$f":"IF(D71>0,MIN('Sources & Uses'!$H$9,D71),0)","v":0},{"$f":"IF(E71>0,MIN('Sources & Uses'!$H$9,E71),0)","v":0},{"$f":"IF(F71>0,MIN('Sources & Uses'!$H$9,F71),0)","v":0},{"$f":"IF(G71>0,MIN('Sources & Uses'!$H$9,G71),0)","v":0},{"$f":"IF(H71>0,MIN('Sources & Uses'!$H$9,H71),0)","v":0},{"$f":"IF(I71>0,MIN('Sources & Uses'!$H$9,I71),0)","v":0},{"$f":"IF(J71>0,MIN('Sources & Uses'!$H$9,J71),0)","v":0},{"$f":"IF(K71>0,MIN('Sources & Uses'!$H$9,K71),0)","v":0},{"$f":"IF(L71>0,MIN('Sources & Uses'!$H$9,L71),0)","v":0},{"$f":"IF(M71>0,MIN('Sources & Uses'!$H$9,M71),0)","v":0},{"$f":"IF(N71>0,MIN('Sources & Uses'!$H$9,N71),0)","v":0},{"$f":"IF(O71>0,MIN('Sources & Uses'!$H$9,O71),0)","v":0},{"$f":"IF(P71>0,MIN('Sources & Uses'!$H$9,P71),0)","v":0},{"$f":"IF(Q71>0,MIN('Sources & Uses'!$H$9,Q71),0)","v":0},{"$f":"IF(R71>0,MIN('Sources & Uses'!$H$9,R71),0)","v":0},{"$f":"IF(S71>0,MIN('Sources & Uses'!$H$9,S71),0)","v":0},{"$f":"IF(T71>0,MIN('Sources & Uses'!$H$9,T71),0)","v":0},{"$f":"IF(U71>0,MIN('Sources & Uses'!$H$9,U71),0)","v":0}]
[null,{"$f":"\"Balance of \"&'Sources & Uses'!B9","v":"Balance of Etc… Please Label"},{"$f":"'Sources & Uses'!K9-ProForma!C70","v":0},{"$f":"C71-D70","v":0},{"$f":"D71-E70","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Hard Debt Service",{"$f":"SUM(C66,C68,C70)","v":0},{"$f":"SUM(D66,D68,D70)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Debt Service Coverage Ratio (DSCR)",{"$f":"IFERROR(C62/C72, \"NHD\")","v":"NHD"},{"$f":"IFERROR(D62/D72, \"NHD\")","v":"NHD"},"NHD","NHD","NHD","NHD","NHD","NHD","NHD","NHD","NHD","NHD","NHD","NHD","NHD","NHD","NHD","NHD","NHD","NHD"]
[null,"Total Cash Flow (Deficit) After Hard Debt Service ",{"$f":"C59-C72","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Cash Flow Waterfall"]
[null,"Deferred Developer Fee Repayment",{"$f":"IF(AND(C75>0,'Sources & Uses'!G14>0),MIN(('Sources & Uses'!H14*ProForma!C75),'Sources & Uses'!G14),0)","v":0},{"$f":"IF(D75>0,MIN(('Sources & Uses'!$H$14*D75),C79),0)","v":0},{"$f":"IF(E75>0,MIN(('Sources & Uses'!$H$14*E75),D79),0)","v":0},{"$f":"IF(F75>0,MIN(('Sources & Uses'!$H$14*F75),E79),0)","v":0},{"$f":"IF(G75>0,MIN(('Sources & Uses'!$H$14*G75),F79),0)","v":0},{"$f":"IF(H75>0,MIN(('Sources & Uses'!$H$14*H75),G79),0)","v":0},{"$f":"IF(I75>0,MIN(('Sources & Uses'!$H$14*I75),H79),0)","v":0},{"$f":"IF(J75>0,MIN(('Sources & Uses'!$H$14*J75),I79),0)","v":0},{"$f":"IF(K75>0,MIN(('Sources & Uses'!$H$14*K75),J79),0)","v":0},{"$f":"IF(L75>0,MIN(('Sources & Uses'!$H$14*L75),K79),0)","v":0},{"$f":"IF(M75>0,MIN(('Sources & Uses'!$H$14*M75),L79),0)","v":0},{"$f":"IF(N75>0,MIN(('Sources & Uses'!$H$14*N75),M79),0)","v":0},{"$f":"IF(O75>0,MIN(('Sources & Uses'!$H$14*O75),N79),0)","v":0},{"$f":"IF(P75>0,MIN(('Sources & Uses'!$H$14*P75),O79),0)","v":0},{"$f":"IF(Q75>0,MIN(('Sources & Uses'!$H$14*Q75),P79),0)","v":0},{"$f":"IF(R75>0,MIN(('Sources & Uses'!$H$14*R75),Q79),0)","v":0},{"$f":"IF(S75>0,MIN(('Sources & Uses'!$H$14*S75),R79),0)","v":0},{"$f":"IF(T75>0,MIN(('Sources & Uses'!$H$14*T75),S79),0)","v":0},{"$f":"IF(U75>0,MIN(('Sources & Uses'!$H$14*U75),T79),0)","v":0},{"$f":"IF(V75>0,MIN(('Sources & Uses'!$H$14*V75),U79),0)","v":0}]
[null,"Balance of Deferred Developer Fee",{"$f":"'Sources & Uses'!G14-C78","v":0},{"$f":"C79-D78","v":0},{"$f":"D79-E78","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Cash Flow After Deferred Developer Fee",{"$f":"C75-C78","v":0},{"$f":"D75-D78","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"HDA Loan Payment",{"$f":"IF(AND(C80>0,'Sources & Uses'!K15>0),('Sources & Uses'!H15*C80),0)","v":0},{"$f":"IF(D80>0,MIN(('Sources & Uses'!$H$15*D80),C83),0)","v":0},{"$f":"IF(E80>0,MIN(('Sources & Uses'!$H$15*E80),D83),0)","v":0},{"$f":"IF(F80>0,MIN(('Sources & Uses'!$H$15*F80),E83),0)","v":0},{"$f":"IF(G80>0,MIN(('Sources & Uses'!$H$15*G80),F83),0)","v":0},{"$f":"IF(H80>0,MIN(('Sources & Uses'!$H$15*H80),G83),0)","v":0},{"$f":"IF(I80>0,MIN(('Sources & Uses'!$H$15*I80),H83),0)","v":0},{"$f":"IF(J80>0,MIN(('Sources & Uses'!$H$15*J80),I83),0)","v":0},{"$f":"IF(K80>0,MIN(('Sources & Uses'!$H$15*K80),J83),0)","v":0},{"$f":"IF(L80>0,MIN(('Sources & Uses'!$H$15*L80),K83),0)","v":0},{"$f":"IF(M80>0,MIN(('Sources & Uses'!$H$15*M80),L83),0)","v":0},{"$f":"IF(N80>0,MIN(('Sources & Uses'!$H$15*N80),M83),0)","v":0},{"$f":"IF(O80>0,MIN(('Sources & Uses'!$H$15*O80),N83),0)","v":0},{"$f":"IF(P80>0,MIN(('Sources & Uses'!$H$15*P80),O83),0)","v":0},{"$f":"IF(Q80>0,MIN(('Sources & Uses'!$H$15*Q80),P83),0)","v":0},{"$f":"IF(R80>0,MIN(('Sources & Uses'!$H$15*R80),Q83),0)","v":0},{"$f":"IF(S80>0,MIN(('Sources & Uses'!$H$15*S80),R83),0)","v":0},{"$f":"IF(T80>0,MIN(('Sources & Uses'!$H$15*T80),S83),0)","v":0},{"$f":"IF(U80>0,MIN(('Sources & Uses'!$H$15*U80),T83),0)","v":0},{"$f":"IF(V80>0,MIN(('Sources & Uses'!$H$15*V80),U83),0)","v":0}]
[null,"Balance of HDA Loan",{"$f":"'Sources & Uses'!K15-C82","v":0},{"$f":"C83-D82","v":0},{"$f":"D83-E82","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Cash Flow After HDA Loan",{"$f":"C80-C82","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"'Sources & Uses'!B17&\" Payment\"","v":"Etc… Please Label Payment"},{"$f":"IF(AND(C84>0,'Sources & Uses'!$K$17>0),('Sources & Uses'!$H$17*C84),0)","v":0},{"$f":"IF(D84>0,MIN(('Sources & Uses'!$H$17*D84),C87),0)","v":0},{"$f":"IF(E84>0,MIN(('Sources & Uses'!$H$17*E84),D87),0)","v":0},{"$f":"IF(F84>0,MIN(('Sources & Uses'!$H$17*F84),E87),0)","v":0},{"$f":"IF(G84>0,MIN(('Sources & Uses'!$H$17*G84),F87),0)","v":0},{"$f":"IF(H84>0,MIN(('Sources & Uses'!$H$17*H84),G87),0)","v":0},{"$f":"IF(I84>0,MIN(('Sources & Uses'!$H$17*I84),H87),0)","v":0},{"$f":"IF(J84>0,MIN(('Sources & Uses'!$H$17*J84),I87),0)","v":0},{"$f":"IF(K84>0,MIN(('Sources & Uses'!$H$17*K84),J87),0)","v":0},{"$f":"IF(L84>0,MIN(('Sources & Uses'!$H$17*L84),K87),0)","v":0},{"$f":"IF(M84>0,MIN(('Sources & Uses'!$H$17*M84),L87),0)","v":0},{"$f":"IF(N84>0,MIN(('Sources & Uses'!$H$17*N84),M87),0)","v":0},{"$f":"IF(O84>0,MIN(('Sources & Uses'!$H$17*O84),N87),0)","v":0},{"$f":"IF(P84>0,MIN(('Sources & Uses'!$H$17*P84),O87),0)","v":0},{"$f":"IF(Q84>0,MIN(('Sources & Uses'!$H$17*Q84),P87),0)","v":0},{"$f":"IF(R84>0,MIN(('Sources & Uses'!$H$17*R84),Q87),0)","v":0},{"$f":"IF(S84>0,MIN(('Sources & Uses'!$H$17*S84),R87),0)","v":0},{"$f":"IF(T84>0,MIN(('Sources & Uses'!$H$17*T84),S87),0)","v":0},{"$f":"IF(U84>0,MIN(('Sources & Uses'!$H$17*U84),T87),0)","v":0},{"$f":"IF(V84>0,MIN(('Sources & Uses'!$H$17*V84),U87),0)","v":0}]
[null,{"$f":"\"Balance of \"&'Sources & Uses'!B17","v":"Balance of Etc… Please Label"},{"$f":"'Sources & Uses'!K17-C86","v":0},{"$f":"C87-D86","v":0},{"$f":"D87-E86","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"Cash Flow After \"&'Sources & Uses'!B17","v":"Cash Flow After Etc… Please Label"},{"$f":"C84-C86","v":0},{"$f":"D84-D86","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total Soft Debt Payment:",{"$f":"C82+C86","v":0},{"$f":"D82+D86","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Excess Cash Flow To Investors",{"$f":"C88","v":0},{"$f":"D88","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]