{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sources & Uses","Income"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sources & Uses","index":0,"n_rows":65,"n_cols":18,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,13,3,13],[7,0,7,1],[20,0,20,1],[22,0,22,1],[44,0,44,1],[38,0,38,1],[32,0,32,1],[29,0,29,1],[23,0,23,1]]}
["DEVELOPMENT PROFORMA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unit Breakdown:"]
["Project:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Units:",null,"Per Unit SAP Cost"]
["Date:",null,null,null,null,null,null,null,null,null,null,null,null,"% of Affordable Units",null,null,"At or below 80% AMI",{"$f":"C9/C5","v":{"$error":"#DIV/0!"}}]
[{"$f":"+Income!E18","v":0},"Total Units",{"$f":"SUM(P3:P5)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"81% AM to 120%","Per Unit Cost"]
[{"$f":"+Income!E17","v":0},"Affordable Units",{"$f":"P3","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P3,C5/C4,\"\")","v":""},null,null,"Market Rate",{"$f":"(O21+C9)/C4","v":{"$error":"#DIV/0!"}}]
[{"$f":"+Income!E35","v":0},"Market Units",{"$f":"P5","v":0}]
[]
["SOURCES OF FUNDS\n*Provide name of Source (if applicable)",null,{"$f":"+B9","v":"Site Acquisition Grant"},{"$f":"+$B10","v":0},{"$f":"+B11","v":0},{"$f":"+$B12","v":0},{"$f":"+B13","v":0},{"$f":"+B14","v":0},{"$f":"+B15","v":0},{"$f":"+B16","v":0},{"$f":"+B17","v":0},{"$f":"+B18","v":0},{"$f":"+B19","v":"Sale Proceeds (Homeownership Only)"},{"$f":"+B20","v":"Construction Loan"},"AMOUNT","Status of\nFunding Source","COMMENTS"]
["Grant","Site Acquisition Grant",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C9:N9)","v":0}]
["Source 1*",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Source 2*",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Source 3*",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Source 4*",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Source 5*",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Source 6*",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Source 7*",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Source 8*",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Source 9*",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Source 10","Sale Proceeds (Homeownership Only)",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Source 11","Construction Loan",null,null,null,null,null,null,null,null,null,null,null,null,0]
["TOTAL SOURCES OF FUNDS",null,{"$f":"SUM(C9:C20)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(O10:O20)","v":0},null," "]
[]
["USES OF FUNDS",null,{"$f":"C8","v":"Site Acquisition Grant"},0,0,0,0,0,0,0,0,0,"Sale Proceeds (Homeownership Only)","Construction Loan","AMOUNT",null,"COMMENTS"]
["Acquisition",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O25:O29)","v":0}]
[null,"Land Costs [Outside of  Grant(s)]",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C25:N25)","v":0}]
[null,"Existing Structure",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C26:N26)","v":0}]
[null,"Carrying Costs",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Acquisition Hard Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O31:O32)","v":0}]
[null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C31:N31)","v":0}]
[null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C32:N32)","v":0}]
["Acquisition Soft Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O34:O38)","v":0}]
[null,"Environmental",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C34:N34)","v":0}]
[null,"Appraisal",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Legal Fees",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Acquisition Other Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O40:O44)","v":0}]
[null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C40:N40)","v":0}]
[null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,0]
["TOTAL ACQUISITION USES",null,{"$f":"SUM(C25:C44)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"O24+O30+O33+O39","v":0},null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Committed"]
[null,"In Progress"]
[null,"Planning to Apply"]

{"sheet":"Income","index":1,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[34,6,34,7],[35,6,35,7],[3,1,3,8],[21,1,21,8],[22,1,23,2],[22,3,23,3],[22,5,23,5],[22,6,23,6],[22,7,23,7],[22,8,23,8],[18,6,18,7],[4,6,5,6],[4,5,5,5],[4,7,5,7],[40,1,40,6],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[36,6,36,7],[31,1,31,2],[32,1,32,2],[33,1,33,2],[4,8,5,8],[17,6,17,7],[4,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[4,3,5,3],[16,5,16,7]]}
[]
[]
[]
[null," Affordable Unit Summary"]
[null,"Unit Type",null,"Unit sqft","No. of","Unit AMI","Proposed            Gross Rent","Utility Allowance","Proposed               Net Rent"]
[null,null,null,null,"Units",null,"Tenant Paid Utilities (U/A)","Tenant Paid Utilities (U/A)","Tenant Paid Utilities (U/A)"]
[null,null,null,null,null,null,null,null,{"$f":"(G7-H7)*E7","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"(G8-H8)*E8","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,"Affordable Units",{"$f":"SUM(E7:E16)","v":0},"Gross Potential Monthly Income:",null,null,{"$f":"SUM(I7:I16)","v":0}]
[null,null,null,"Total Units",{"$f":"E17+E35","v":0}," "," Affordable Vacancy:"]
[null,null,null,null,null," ","Effective Gross Income:",null,{"$f":"I17*(1-I18)","v":0}]
[]
[]
[null,"Market Unit Summary"]
[null,"Unit Type",null,"Unit sqft","No. of","Unit AMI","Proposed            Gross Rent","Utility Allowance","Proposed               Net Rent"]
[null,null,null,null,"Units",null,"Tenant Paid Utilities (U/A)","Tenant Paid Utilities (U/A)","Tenant Paid Utilities (U/A)"]
[null,null,null,null,null,null,null,null,{"$f":"(G25-H25)*E25","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"(G26-H26)*E26","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null," "]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,"Market Units",{"$f":"SUM(E25:E34)","v":0}," ","Gross Potential Income",null,{"$f":"SUM(I25:I34)","v":0}]
[null,null,null,"Affordable Units",{"$f":"E17","v":0}," ","Markert Vacancy:"]
[null,null,null,"Total Units",{"$f":"E35+E36","v":0}," ","Effective Gross Income",null,{"$f":"I35*(1-I36)","v":0}]
[]
[]
[]
[null," Commercial Summary"]
[null,"Commercial Income Type",null,"Number of Units","NRSF Per Unit","Rent per Units","Yearly Rent"]
[null,null,null,null,null,null,{"$f":"E43*F43*12","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,"TOTALS",null,{"$f":"SUM(D43:D47)","v":0},{"$f":"SUM(E43:E47)","v":0},"N/A",{"$f":"SUM(G43:G47)","v":0}]
[null,"Vacancy"]
[null,"Effective Gross Income",null,null,null,null,{"$f":"G48*(1-G49)","v":0}]