{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["4989 Rent Roll current"],"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":"4989 Rent Roll current","index":0,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9]]}
["Rent Roll and P&L"]
["4989 Ridgewood Ave., Port Orange FL 32127"]
["Tenant Name","Unit","BR","BA","leased","lease origination date","Lease exp date","Security Deposit ","Monthly Rent ","Annual Base Rent"]
["###############",1,1,1,"Y",null,null,1200,1400,{"$f":"I4*12","v":16800}]
["###############",2,1,2,"y",null,null,1500,1650,{"$f":"I5*12","v":19800}]
["###############",3,"STUDIO",null,"y",null,null,950,950,11400]
["###############",4,"Studio",null,"Y",null,null,1150,1250,15000]
["###############",5,"Studio",null,"Y",null,null,900,1000,12000]
["###############",6,1,1,"Y",null,null,1250,1000,12000]
["El Sabor ","Restaurant ",null,null,"Y",null,null,5000,3250,39000]
["Total Rent Income ",{"$nulls":8},{"$f":"SUM(J4:J10)","v":126000}]
["Vac & Collections (3%)",{"$nulls":8},{"$f":"J11*0.03","v":3780}]
["Effective Rental Income",{"$nulls":8},{"$f":"J11-J12","v":122220}]
["Total expenses ",{"$nulls":8},{"$f":"B23","v":30116}]
["Net Operating Income ",{"$nulls":8},{"$f":"J13-J14","v":92104}]
[]
[]
["Expenses: "]
["Property Tax",8832,null,null,null,0.06,{"$f":"J15/F19","v":1535066.6666666667}]
["Property Insurance ",3984,null,null,null,7.0000000000000007E-2,{"$f":"J15/F20","v":1315771.4285714284},null,1100000,{"$f":"J15/I20","v":8.3730909090909092E-2}]
["Repair and Maintenance (5%)",{"$f":"J11*0.05","v":6300},null,null,null,0.08,{"$f":"J15/F21","v":1151300}]
["Utilities ",11000,null,null,null,0.09,{"$f":"J15/F22","v":1023377.7777777779}]
["Total Expenses",{"$f":"SUM(B19:B22)","v":30116},null,null,null,{"$f":"J15/G23","v":8.7718095238095234E-2},1050000]
[]
["Year 2 Expenses "]
["Expenses: "]
["Property Tax",15000,null,null,null,0.06,{"$f":"$B$32/F27","v":1430520}]
["Property Insurance ",5500,null,null,null,7.0000000000000007E-2,{"$f":"$B$32/F28","v":1226159.9999999998}]
["Repair and Maintenance (4%)",{"$f":"J13*0.04","v":4888.8},null,null,null,0.08,1072890]
["Utilities ",11000,null,null,null,0.09,953680]
["Total Expenses",{"$f":"SUM(B27:B30)","v":36388.800000000003},null,null,null,{"$f":"J23/G31","v":{"$error":"#DIV/0!"}}]
["Year 2 NOI",{"$f":"J13-B31","v":85831.2}]