{"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'!I14","v":120000},"Proforma Rent Roll (next tab)"]
["  Vacancy & Collections"]
["Total Rental Income",null,{"$f":"C3+C4","v":120000}]
[]
["Other Income"]
["Application Fees"]
["Total Other Income"]
["Total Income",null,{"$f":"(C5+C9)","v":120000}]
[]
["Expenses"]
["  Advertising & Promotion"]
["  Cleaning Expense"]
["  Insurance",null,3000]
["  Landscaping",null,600,"$50/month"]
["  Pest Control"]
["  Repairs & Maintenance",null,2000,"$200/unit/year"]
["  Real Estate Tax",null,6000]
["  Trash Removal"]
["  Utilities"]
["    Electric",null,600,"$50x12"]
["    Gas"]
["    Telephone",null,0,"NA"]
["    Water / Sewer",null,6000,"$500/month"]
["  Total Utilities",null,{"$f":"SUM(C22:C25)","v":6600}]
["  General & Admin."]
["Rental Registration",null,350]
["    Professional Fees / Legal"]
["  Total General & Admin."]
["  Property Management Fee",null,{"$f":"0.06*C5","v":7200},"6% of Effective Gross Rent"]
["Total Expense",null,{"$f":"(SUM(C13:C31))-C26-C30","v":25750}]
["  Expense per suite",null,{"$f":"C32/14","v":1839.2857142857142}]
[]
["Net Operating Income",null,{"$f":"C10-(C15+C16+C18+C19+C26+C28+C31)","v":94250}]

{"sheet":"Rent Roll","index":1,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Unit","Occupants","Size (sf)","Location","Bedrooms","Tenant","Actual Rent ","prororma rent","Total Projected Annual Rent "]
[1,1,null,"3421 e 128th",1,"Vacant",0,1000,{"$f":"H2*12","v":12000}]
[2,1,null,"3421 e 128th",1,"Vacant",0,1000,12000]
[3,1,null,"3425 e 128th",1,"Vacant",0,1000,12000]
[4,1,null,"3425 e 128th",1,"Vacant",0,1000,12000]
[5,1,null,"3425 e 128th",1,"Vacant",0,1000,12000]
[6,1,null,"3425 e 128th",1,"Vacant",0,1000,12000]
[7,1,null,"3429 e 128",1,"Vacant",0,1000,12000]
[8,1,null,"3429 e 128th",1,"Vacant",0,1000,12000]
[9,1,null,"3429 e 128th",1,"Vacant",0,1000,12000]
[10,1,null,"3429 e 128th",1,"Vacant",0,1000,12000]
[]
[{"$nulls":5},"Monthly Rent Total",null,null,{"$f":"SUM(H2:H11)","v":10000}]
[{"$nulls":5},"Annual Rent Total",null,null,{"$f":"SUM(I13*12)","v":120000}]
[]
[{"$nulls":5},"Monthly Gross Revenue Total",0,null,{"$f":"I13","v":10000}]
[{"$nulls":5},"Annual Gross Revenue Total",null,null,{"$f":"SUM(I16*12)","v":120000}]

{"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}]