{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Financials"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Financials","index":0,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[18,2,18,3],[19,2,19,3],[20,2,20,3],[1,1,1,4],[1,7,1,9],[6,8,6,9],[7,8,7,9],[8,8,8,9]]}
[]
[null,"T12",{"$nulls":5},"Pro Forma"]
[null,null,"Monthly","Annually","$/Unit",null,null,null,"Monthly","Annually"]
[null,"Property Taxes",3281,{"$f":"C4*12","v":39372},{"$f":"D4/43","v":915.62790697674416},null,null,"Gross Potential Rent",57747,{"$f":"I4*12","v":692964}]
[null,"Payroll",2800,33600,{"$f":"D5/43","v":781.39534883720933},null,null,"Gain (Loss) to Lease",-2900,{"$f":"I5*12","v":-34800}]
[null,"Utilities",5600,67200,1562.7906976744187,null,null,"Total Net Potential",{"$f":"I4+I5","v":54847},{"$f":"I6*12","v":658164}]
[null,"Legal & Professional ",68,816,18.976744186046513,null,null,"Vacancy",0.05]
[null,"Management",500,6000,139.53488372093022,null,null,"Total # of units occupied",41]
[null,"Fire & Safety",180,2160,50.232558139534881,null,null,"Total # of units",43]
[null,"R&M",1560,18720,435.3488372093023,null,null,"Utilities & R&M- Total cost for occupied units only",{"$f":"(SUM(C6+C10)/C20)*I8","v":7527.1794871794873},{"$f":"I10*12","v":90326.153846153844}]
[null,"Insurance",3200,38400,893.02325581395348,null,null,"Remaining Expenses (Mostly Fixed Expenses)",{"$f":"SUM(C4:C5,C7,C8,C9,C11:C12)","v":10549},{"$f":"I11*12","v":126588}]
[null,"Miscellaneous",520,{"$f":"C12*12","v":6240},145.11627906976744,null,null,"Total Expenses",{"$f":"SUM(I10:I11)","v":18076.179487179488},{"$f":"SUM(J10:J11)","v":216914.15384615384}]
[null,"Total Expenses",{"$f":"SUM(C4:C12)","v":17709},{"$f":"SUM(D4:D12)","v":212508},{"$f":"SUM(E4:E12)","v":4942.0465116279065},null,null,"NOI",{"$f":"SUM(I6-I12)","v":36770.820512820515},{"$f":"SUM(J6-J12)","v":441249.84615384613}]
[]
[]
[null,"Gross Potential Rent",57747,{"$f":"C16*12","v":692964}]
[null,"Gain (Loss) to Lease",-5800,{"$f":"C17*12","v":-69600},null,null,null,"Property Value at 6 cap",7300000]
[null,"Net Rental Income",{"$f":"C16+C17","v":51947},{"$f":"D16+D17","v":623364}]
[null,"Vacancy",0.91,{"$nulls":4},"Property Value at 7 cap",6250000]
[null,"Total # of units occupied",39]
[null,"Total # of units ",43,{"$nulls":4},"Property Value at 8 cap",5500000]
[null,"Total Expenses",{"$f":"C13","v":17709},{"$f":"D13","v":212508}]
[null,"NOI",{"$f":"C18-C22","v":34238},{"$f":"D18-D22","v":410856}]
[]
[]
[null,"Property Value at 6 cap",6800000]
[]
[null,"Property Value at 7 cap",5850000]
[]
[null,"Property Value at 8 cap",5150000]