{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Summary Financials","Rent Roll","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"Summary Financials","index":0,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Income",null,"Market Rate\nProforma","Proforma Assumptions"]
["Rental Income",null,"Most Likely"]
["  Apartment Rental Income",null,{"$f":"'Rent Roll'!H21","v":163200},"Proforma Rent Roll (next tab)"]
["  Vacancy & Collections"]
["Total Rental Income",null,{"$f":"C3+C4","v":163200}]
["Laundry",null,2400,"$200/ month"]
["Other Income",null,0]
["Application Fees"]
["Total Other Income",null,{"$f":"SUM(C6:C8)","v":2400}]
["Total Income",null,{"$f":"(C5+C9)","v":165600}]
[]
["Expenses"]
["  Advertising & Promotion"]
["  Cleaning Expense"]
["  Insurance",null,4000]
["  Landscaping",null,600,"100x6 months"]
["  Pest Control",null,0]
["  Repairs & Maintenance",null,2550,"$150/unit/year"]
["  Real Estate Tax",null,12000]
["  Trash Removal",null,2400,"$200x12"]
["  Utilities"]
["    Electric",null,1200,"$100x12"]
["    Gas",null,2400,"$200x12"]
["    Telephone& Cable",null,1800,"Internet for Security Camera System"]
["    Water / Sewer",null,10200,"600 per unit"]
["  Total Utilities",null,{"$f":"SUM(C22:C25)","v":15600}]
["  General & Admin."]
["Rental Registration",null,1190,"$70/unit"]
["    Professional Fees / Legal"]
["  Total General & Admin.",null,{"$f":"SUM(C28:C29)","v":1190}]
["  Property Management Fee",null,{"$f":"0.05*C5","v":8160},"5% of Effective Gross Rent"]
["Total Expense",null,{"$f":"(SUM(C13:C20))+C26+C30+C31","v":46500}]
["  Expense per suite",null,{"$f":"C32/10","v":4650}]
[]
["Net Operating Income",null,{"$f":"C10-C32","v":119100}]

{"sheet":"Rent Roll","index":1,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Unit","Occupants","Size (sf)","Location","Bedrooms","Tenant","Proforma  Rent ","Total Projected Annual Rent ",null,"Se 8 rent"]
[101,1,null,"1849 Cliffview",1,"Occupied",800,{"$f":"G2*12","v":9600},null,1005]
[102,1,null,"1849 Cliffview",1,"Occupied",800,{"$f":"G3*12","v":9600},null,1005]
[104,1,null,"1849 Cliffview",1,"Occupied",800,9600,null,1005]
[105,1,null,"1849 Cliffview",1,"Occupied",800,9600,null,1005]
[106,1,null,"1849 Cliffview",1,"Occupied",800,9600,null,1005]
[201,1,null,"1849 Cliffview",1,"Occupied",800,9600,null,1005]
[202,1,null,"1849 Cliffview",1,"Occupied",800,{"$f":"G8*12","v":9600},null,1005]
[203,1,null,"1849 Cliffview",1,"Occupied",800,9600,null,1005]
[204,1,null,"1849 Cliffview",1,"Occupied",800,9600,null,1005]
[205,1,null,"1849 Cliffview",1,"Occupied",800,9600,null,1005]
[206,1,null,"1849 Cliffview",1,"Occupied",800,9600,null,1005]
[301,1,null,"1849 Cliffview",1,"Occupied",800,9600,null,1005]
[301,1,null,"1849 Cliffview",1,"Occupied",800,9600,null,1005]
[303,1,null,"1849 Cliffview",1,"Occupied",800,9600,null,1005]
[304,1,null,"1849 Cliffview",1,"Occupied",800,9600,null,1005]
[305,1,null,"1849 Cliffview",1,"Occupied",800,9600,null,1005]
[306,1,null,"1849 Cliffview",1,"Occupied",800,9600,null,1005]
[]
[{"$nulls":5},"Monthly Rent Total",null,{"$f":"SUM(G2:G18)","v":13600}]
[{"$nulls":5},"Annual Rent Total",null,{"$f":"SUM(H20*12)","v":163200}]
[]
[{"$nulls":5},"Monthly Gross Revenue Total",null,{"$f":"H20","v":13600}]
[{"$nulls":5},"Annual Gross Revenue Total",null,{"$f":"(H21)","v":163200}]

{"sheet":"Sheet1","index":2,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[null,"Paid before","Pending","Estimated"]
[null,"July 1, 2017"]
["Purchase",78600,null,null,null,4500,"check"]
["Roof",25000,null,null,null,2110,"2016-06-01","visa"]
["Architect",47250,null,23750,null,10000,"2016-06-01","wire"]
["Civil Engineering",2800,5284.69,null,null,20000,"2016-09-01","visa"]
["Clean Up of yard, gutting building and ",11500,null,null,null,10640,"2016-12-01","wire"]
["Land Bank ",1586,null,null,null,{"$f":"SUM(F3:F7)","v":47250}]
["Fees",400]
["Construction",null,null,970000]
["Insurances to Date and est for build",10136,null,15000]
["Property Taxes",2795,null,2795]
[null,{"$f":"SUM(B3:B12)","v":180067},5284.69,{"$f":"SUM(D5:D11)","v":1008750},null,{"$f":"SUM(B13:E13)","v":1194101.69}]