{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,4,1,5]]}
["(PROFORMA AS MULTIFAMILY ) Estimated Financial Impact of Kitchenette Addition "]
["1) Building Data",null,null,null,"3) Investment Data"]
["Unit Type (br/ba)","# of Units","Market Rent /Mo ","Total Annual Rent","Purchase Price",850000.0]
["Studio 1 bed 1 bath (Fair Market Rent $848 a month)",17.0,14416.0,{"$f":"C4*12","v":172992},"Cap Rate",{"$f":"C23/F3","v":0.1734313412}]
["House 1 bed 1 bath",1.0,853.0,10236,"Rehab",60000.0]
["House 3 bed 1 bath",1.0,1327.0,15924,"ARV",{"$f":"C23/0.08","v":1842708}]
[{"$nulls":4},"Total all in",{"$f":"F3+F5","v":910000}]
["Totals:",19.0,{"$f":"sum(C4:C7)","v":16596},{"$f":"C8*12","v":199152}]
[]
["2) Operating Statement"]
[]
["Potential Gross Income",null,{"$f":"D8","v":199152}]
["Laundry Income",null,0.0]
["Effective Gross Income",null,{"$f":"SUM(C12:C13)","v":199152}]
[]
["Property Taxes",null,4905.0]
["Property Insurance",null,8244.0]
["Utilities: Electric, Gas ",null,17400.0]
["Water",null,10140.0]
["Waste Removal ",null,3080.28]
["Property Management Expense",0.04,{"$f":"D8*B21","v":7966.08}]
["Total Expenses",null,{"$f":"SUM(C16:C21)","v":51735.36}]
["Net Operating Income",null,{"$f":"C14-C22","v":147416.64}]
["Monthly Net Cash Flow",null,{"$f":"C23/12","v":12284.72}]
["Operating Margin",null,{"$f":"C23/C14","v":0.7402217402}]