{"text_format":"2","workbook":"xlsx","n_sheets":10,"sheets":["Properties for sale ","N. Lake Dr.","Belleview","Stowell","Kenmore","Bartlett","Marshall ","930 E Knapp","3402 Oakland ","3438 Oakland "],"not_rendered":{"charts":0,"images":15,"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":"Properties for sale ","index":0,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Address","Name ","Studio ","1 bed","2 bed","3 bed ","4 bed","Units","Year ","Sq' ","NOI","Price "]
["930 E Knapp","Montgomery House",{"$nulls":5},20,1893,7817,72907,1000000]
[null,"Mixed Use Building"]
["1030 N Marshall St","Marshall Building",null,3,2,4,7,16,1906,25180,174307,2750000]
[null,"Red Brick Building"]
["2519-2533- 2549 N Lake ","Lake Dr Apts",null,12,3,11,null,26,"1911/1943",29213,222028,4250000]
[null,"6 buildings, 4,4,4,3,2,9"]
["1800-1806 E. Kenmore ","Shorewood Apts",null,6,10,null,null,16,1926,13040,94567,1600000]
[null,"2 buildings 8 & 8 units"]
["3220 N Bartlett","Townhouses",null,null,6,null,null,6,1967,6320,56986,975000]
[]
["2511 E. Belleview","Downer Area ",null,null,6,19,null,25,"1900's",43688,219266,3750000]
[]
["2575 N Stowell ","Downer Area ",null,null,null,6,null,7,1915,8590,60531,950000]
[]
["3438 N. Oakland","Underground Parking ",null,21,5,null,null,36,"1960's",26880,196568,3850000]
[]
["3402 N. Oakland","Underground Parking",null,24,null,null,null,24,"1960's",17568,109046,2500000]
[]
["Totals ",{"$nulls":6},{"$f":"SUM(H2:H18)","v":176},null,null,{"$f":"SUM(K2:K18)","v":1206206},{"$f":"SUM(L2:L18)","v":21625000}]
{"$rows_empty":13}
["Presented By:","The Realty Company LLC ",null,"262-786-7690"]
[null,"Lorna Mueller ",null,"lorna@therealtycompanyllc.com"]
[null,"Josh Manchester",null,"josh@therealtycompanyllc.com"]

{"sheet":"N. Lake Dr.","index":1,"n_rows":48,"n_cols":24,"rows_kept":48,"cut":false,"hidden":false,"merged":[[9,0,9,1],[0,0,0,4],[3,0,3,1],[6,1,6,3],[7,0,7,1],[8,0,8,1],[8,2,8,3]]}
[]
[null,null,"                Purchase Price: "]
[]
["Property Location"]
["2519-2549 N. Lake Dr "]
["Milwaukee WI "]
[]
["Type of Property:",null,"Multifamily ",null,"Prurchase Price ",4100000,{"$nulls":5},"# of Units ",null,4,null,4,null,4,null,3,null,2,null,9]
["Size of property",null,"5 Buildings ",{"$nulls":8},"Address","bed",2519,"bed",2523,"bed",2527,"bed",2533,"bed",2541,"bed",2549]
["Date:2/15/18",null,"Units :",4,4,4,3,2,9,{"$f":"SUM(D10:I10)","v":26},null,"Units #1",1,850,1,860,1,895,"2+",1325,3,1670,3,1395]
[null,null,null,2519,2523,2527,2533,2541,2549,"Total",null,2,1,850,1,895,1,950,2,950,3,1875,3,1395]
["Rental Income",null,null,40920,42660,44940,48600,42540,150120,{"$f":"SUM(D12:I12)","v":369780},null,3,1,850,1,925,1,950,3,1775,null,null,3,1495]
["Parking ",null,"17 spaces",{"$nulls":6},15300,null,4,1,860,1,875,1,950,{"$nulls":4},3,1495]
["Other Income",null,null,1800,1800,1800,null,null,3600,{"$f":"SUM(D14:I14)","v":9000},null,5,{"$nulls":10},3,1395]
["Vacancy",{"$nulls":10},6,{"$nulls":10},3,1450]
["Gross operating Income",null,null,{"$f":"SUM(D12:D14)-D15","v":42720},44460,46740,48600,42540,153720,{"$f":"SUM(J12:J15)","v":394080},null,7,{"$nulls":10},3,1495]
[null,null,null,"1 set w/d","1 set w/d","1 set w/d","in unit w/d",null,"2 set w/d",null,null,8,{"$nulls":10},3,1495]
["OPERATING EXPENSES",{"$nulls":10},9,{"$nulls":10},2,895]
["Taxes",null,null,9002,9004,9002,11858,8071,23163,null,null,"month ",null,{"$f":"SUM(N10:N18)","v":3410},null,{"$f":"SUM(P10:P18)","v":3555},null,{"$f":"SUM(R10:R18)","v":3745},null,{"$f":"SUM(T10:T18)","v":4050},null,{"$f":"SUM(V10:V18)","v":3545},null,{"$f":"SUM(X10:X18)","v":12510}]
["Insurance ",null,null,1053,1053,1053,1273,800,2531,null,null,"Annual",null,40920,null,42660,null,44940,null,48600,null,42540,null,150120]
["Management ",null,0.05,2046,2050,2247,2430,null,7506]
["Trash",null,null,1073,1194,953,1073,6600,475]
["Utilities ",null,null,1642,967,438,3069,2783,10224]
["Repairs and Maintenance",null,null,1761,3010,919,566,1998,2242]
["Pest Control",null,null,108,114,102,106,41,118]
["Advertising and promotions ",null,null,52,60,44,77,null,82]
["Landscaping",null,null,900,752,660,775,650,1067]
["Supplies and Paint ",null,null,2260,1233,1534,515,null,8356]
["Total Expense ",null,null,{"$f":"SUM(D19:D28)","v":19897},19437,16952,21742,20943,55764,{"$f":"SUM(D29:I29)","v":154735}]
["Net Operating Income",null,null,{"$f":"D16-D29","v":22823},25023,29788,26858,21597,97956,239345]
[]
[]
[]
[]
[]
["Rent Rolls ",null,null,2519,2523,2527,2533,2541,2549]
[null,null,1,850,860,895,1325,null,1395]
[null,null,2,850,895,950,950,null,1395]
[null,null,3,850,925,950,1775,null,1495]
[null,null,4,860,875,950,null,null,1495]
[null,null,5,{"$nulls":5},1395]
[null,null,6,{"$nulls":5},1450]
[null,null,7,{"$nulls":5},1495]
[null,null,8,{"$nulls":5},1495]
[null,null,9,{"$nulls":5},895]
[null,null,null,"Centeral A/C","Centeral A/C","Centeral A/C","boiler ","boiler ","boiler "]
[null,null,null,"furnaces ","furnaces ","furnaces ","3 water heaters","2 water heaters","2 water heaters"]
[null,null,null,"waterheater","waterheater","waterheater","in unit washer/ dry","in unit washer/dry","Washer/dryer coin"]

{"sheet":"Belleview","index":2,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[8,1,8,2],[8,3,8,5],[9,1,9,2],[0,0,0,8],[1,3,1,4],[3,1,3,2],[7,1,7,2],[7,3,7,4]]}
["Annual Property Operating Data"]
[null,null,null,"Purchase Price: ",null,3750000]
[]
[null,"Property Location"]
[null,null,"2511 E Belleview "]
[null,null,"(2576-2594 N Stowell) "]
[null,null,"Milwaukee WI 53202"]
[null,"Type of Property:",null,"Multifamily "]
[null,"Size of property",null,"25 Units "]
[null,"Date:",null,"2017-02-01"]
["Annual Figures",{"$nulls":4},2017]
[null,"Rental Income",null,null,null,370800]
[null,"Other Income",null,null,null,6150]
[null,"Vacancy",null,0.03,null,18540]
[null,"Gross operating Income",null,null,null,{"$f":"SUM(F12:F13)-F14","v":358410}]
[null,"OPERATING EXPENSES"]
[null,"Taxes",2015,null,null,66028]
[null,"Insurance ",null,null,null,8832]
[null,"Management ",null,0.05,null,18540]
[null,"Trash",null,null,null,4277.6499999999996]
[null,"Utilities ",null,null,null,26960.25]
[null,"Repairs and Maintenance",null,null,null,12250.66]
[null,"Pest Control",null,null,null,597.42999999999995]
[null,"Landscaping",null,null,null,1658.17]
[null,"Total Expense ",null,0.4,null,{"$f":"SUM(F17:F24)","v":139144.16}]
[null,"Net Operating Income",null,null,null,{"$f":"F15-F25","v":219265.84}]

{"sheet":"Stowell","index":3,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[7,1,7,2],[7,3,7,5],[8,1,8,2],[0,0,0,8],[1,3,1,4],[3,1,3,2],[6,1,6,2],[6,3,6,4]]}
["Annual Property Operating Data"]
[null,null,null,"Purchase Price: ",null,950000]
[]
[null,"Property Location"]
[null,null,"2575 N. Stowell "]
[null,null,"Milwaukee WI 53202"]
[null,"Type of Property:",null,"Multifamily "]
[null,"Size of property",null,"7 units "]
[null,"Date:",null,"2017-02-01"]
["Annual Figures",{"$nulls":4},2017]
[null,"Rental Income",null,null,null,100680]
[null,"Other Income",null,null,null,5410]
[null,"Vacancy",null,0.03,null,3000]
[null,"Gross operating Income",null,null,null,{"$f":"SUM(F11:F12)-F13","v":103090}]
[null,"OPERATING EXPENSES"]
[null,"Taxes",2015,null,null,20165.419999999998]
[null,"Insurance ",null,null,null,1998]
[null,"Management ",null,0.05,null,5034]
[null,"Trash",null,null,null,2721.78]
[null,"Utilities ",null,null,null,6866.95]
[null,"Repairs and Maintenance",null,null,null,5055.57]
[null,"Pest Control",null,null,null,64.25]
[null,"Landscaping",null,null,null,652.48]
[null,"Reserves"]
[null,"Total Expense ",null,0.4,null,{"$f":"SUM(F16:F24)","v":42558.45}]
[null,"Net Operating Income",null,null,null,{"$f":"F14-F25","v":60531.55}]

{"sheet":"Kenmore","index":4,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[7,1,7,2],[7,3,7,5],[8,1,8,2],[0,0,0,8],[1,3,1,4],[3,1,3,2],[6,1,6,2],[6,3,6,4]]}
["Annual Property Operating Data"]
[null,null,null,"Purchase Price: ",null,1600000]
[]
[null,"Property Location:"]
[null,null,"1800 E Kenmore "]
[null,null,"Shorewood WI 53211 "]
[null,"Type of Property:",null,"Multifamily "]
[null,"Size of property",null,"16 units, 2 Buildings "]
[null,"Date:",null,"2017-02-01"]
[null,"Annual Figures",null,null,null,2017]
[null,"Rental Income",null,null,null,158700]
[null,"Other Income",null,null,null,1500]
[null,"Vacancy",null,0.03,null,4761]
[null,"Gross operating Income",null,null,null,{"$f":"SUM(F11:F12)-F13","v":155439}]
[null,"OPERATING EXPENSES"]
[null,"Taxes",2015,null,null,31045]
[null,"Insurance ",null,null,null,3164]
[null,"Management ",null,0.05,null,7935]
[null,"Trash",null,null,null,3303]
[null,"Utilities ",null,null,null,10899]
[null,"Repairs and Maintenance",null,null,null,6226]
[null,"Pest Control",null,null,null,106]
[null,"Landscaping",null,null,null,1368]
[null,"Total Expense ",null,0.4,null,{"$f":"SUM(F16:F23)","v":64046}]
[null,"Net Operating Income",null,null,null,{"$f":"F14-F24","v":91393}]

{"sheet":"Bartlett","index":5,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[7,1,7,2],[7,3,7,5],[8,1,8,2],[0,0,0,8],[1,3,1,4],[3,1,3,2],[6,1,6,2],[6,3,6,4]]}
["Annual Property Operating Data"]
[null,null,null,"Purchase Price: ",null,975000]
[]
[null,"Property Location"]
[null,null,"3220 N. Bartlett"]
[null,null,"Milwaukee WI 53202"]
[null,"Type of Property:",null,"Multifamily "]
[null,"Size of property",null,"6 Units , townhomes "]
[null,"Date:",null,"2017-02-01"]
["Annual Figures",{"$nulls":4},2017]
[null,"Rental Income",null,null,null,86580]
[null,"Other Income"]
[null,"Vacancy",null,0.03,null,2594]
[null,"Gross operating Income",null,null,null,{"$f":"SUM(F11:F12)-F13","v":83986}]
[null,"OPERATING EXPENSES"]
[null,"Taxes",2015,null,null,18098]
[null,"Insurance ",null,null,null,1443]
[null,"Management ",null,0.05,null,4329]
[null,"Trash",null,null,null,1555.85]
[null,"Utilities ",null,null,null,433.85]
[null,"Repairs and Maintenance",null,null,null,237.93]
[null,"Pest Control",null,null,null,59.6]
[null,"Landscaping",null,null,null,842.4]
[null,"Reserves"]
[null,"Total Expense ",null,0.4,null,{"$f":"SUM(F16:F24)","v":26999.629999999997}]
[null,"Net Operating Income",null,null,null,{"$f":"F14-F25","v":56986.37}]

{"sheet":"Marshall ","index":6,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[7,1,7,2],[7,3,7,5],[8,1,8,2],[0,0,0,8],[1,3,1,4],[3,1,3,2],[6,1,6,2],[6,3,6,4]]}
["Annual Property Operating Data"]
[null,null,null,"Purchase Price: ",null,2750000]
[]
[null,"Property Location"]
[null,null,"1030 N Marshall "]
[null,null,"Milwaukee WI 53202"]
[null,"Type of Property:",null,"Multifamily "]
[null,"Size of property",null,"16 units, 1 Buildings "]
[null,"Date:",null,"2017-02-01"]
[null,"Annual ",null,null,null,2017]
[null,"Rental Income",null,null,null,271620]
[null,"Other Income",null,null,null,675]
[null,"Vacancy",null,0.03,null,8148]
[null,"Gross operating Income",null,null,null,{"$f":"SUM(F11:F12)-F13","v":264147}]
[null,"OPERATING EXPENSES"]
[null,"Taxes",2015,null,null,37580]
[null,"Insurance ",null,null,null,5146]
[null,"Management ",null,0.05,null,13581]
[null,"Trash",null,null,null,2835]
[null,"Utilities ",null,null,null,12591]
[null,"Repairs and Maintenance",null,null,null,22666]
[null,"Pest Control",null,null,null,106]
[null,"Landscaping",null,null,null,768]
[null,"Reserves"]
[null,"Total Expense ",null,0.4,null,{"$f":"SUM(F16:F24)","v":95273}]
[null,"Net Operating Income",null,null,null,{"$f":"F14-F25","v":168874}]

{"sheet":"930 E Knapp","index":7,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[7,1,7,2],[7,3,7,5],[8,1,8,2],[0,0,0,8],[1,3,1,4],[3,1,3,2],[6,1,6,2],[6,3,6,4]]}
["Annual Property Operating Data"]
[null,null,null,"Purchase Price: ",null,1000000]
[]
[null,"Property Location"]
[null,"920 E Knapp"]
[null,"Milwaukee WI 53202"]
[null,"Type of Property:",null,"Mix Use"]
[null,"Size of property",null,"20 units/ 19 commercial 1 residential "]
[null,"Date:",null,"2017-02-01"]
["Annual Figures",{"$nulls":4},2017]
[null,"Rental Income",null,null,null,131520]
[null,"Other Income"]
[null,"Vacancy",null,0.1,null,13520]
[null,"Gross operating Income",null,null,null,{"$f":"SUM(F11:F12)-F13","v":118000}]
[null,"OPERATING EXPENSES"]
[null,"Taxes",2015,null,null,18629]
[null,"Insurance ",null,null,null,951]
[null,"Management ",null,0.05,null,6576]
[null,"Trash",null,null,null,388.61]
[null,"Utilities ",null,null,null,11873.39]
[null,"Repairs and Maintenance",null,null,null,6330.82]
[null,"Pest Control",null,null,null,124.34]
[null,"Landscaping",null,null,null,219.53]
[null,"Reserves"]
[null,"Total Expense ",null,0.4,null,{"$f":"SUM(F16:F24)","v":45092.689999999995}]
[null,"Net Operating Income",null,null,null,{"$f":"F14-F25","v":72907.31}]

{"sheet":"3402 Oakland ","index":8,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[8,1,8,2],[8,3,8,5],[9,1,9,2],[1,0,1,9],[2,3,2,4],[4,1,4,2],[7,1,7,2],[7,3,7,4]]}
[]
["Annual Property Operating Data"]
[null,null,null,"Purchase Price: ",null,2400000]
[{"$nulls":5},"17,568 sq' building"]
[null,"Property Location"]
[null,null,"3402 N Oakland "]
[null,null,"Milwaukee WI 53211"]
[null,"Type of Property:",null,"Multifamily "]
[null,"Size of property",null,"24 units, 15 underground parking "]
[null,"Date:",null,"2016-12-27"]
["Annual Figures",{"$nulls":4},"Actual 2016","2017 Proforma"]
[null,"Rental Income",null,null,null,221580,223200]
[null,"Other Income",null,"laundry ",null,3600,22680]
[null,"Vacancy",null,null,null,18597,11448]
[null,"Gross operating Income",null,null,null,{"$f":"SUM(F12:F13)-F14","v":206583},240192]
[null,"OPERATING EXPENSES"]
[null,"Taxes",2016,null,null,39240,39473]
[null,"Insurance ",null,null,null,4503,5000]
[null,"Management ",null,null,0.05,9172,10300]
[null,"Sewer",null,null,null,3143,3143]
[null,"We Energies",null,null,null,10940,11000]
[null,"Repairs and Maintenance",null,null,null,26314,17000]
[null,"Trash ",null,null,null,2228,2300]
[null,"On Site",null,"in rent roll",null,null,1200]
[null,"Lawn and Snow",null,null,null,1043,1100]
[null,"Elevator ",null,null,null,954,1000]
[null,"Reserves",{"$nulls":4},4882]
[null,"Total Expense ",null,null,null,{"$f":"SUM(F17:F27)","v":97537},{"$f":"SUM(G17:G27)","v":96398}]
[null,"Net Operating Income",null,null,null,{"$f":"F15-F28","v":109046},{"$f":"G15-G28","v":143794}]

{"sheet":"3438 Oakland ","index":9,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[7,1,7,2],[7,3,7,5],[8,1,8,2],[0,0,0,9],[1,3,1,4],[3,1,3,2],[6,1,6,2],[6,3,6,4]]}
["Annual Property Operating Data"]
[null,null,null,"Purchase Price: ",null,3400000]
[{"$nulls":5},"26,880 sq' building"]
[null,"Property Location"]
[null,null,"3438 N Oakland "]
[null,null,"Milwaukee WI 53211"]
[null,"Type of Property:",null,"Multifamily "]
[null,"Size of property",null,"36 units, 15 underground parking "]
[null,"Date:",null,"2016-12-27"]
["Annual Figures",{"$nulls":4},"Actual 2016",2017]
[null,"Rental Income",null,null,null,324467,345240]
[null,"Other Income",null,null,null,7839,19980]
[null,"Vacancy",null,0.05,null,null,17262]
[null,"Gross operating Income",null,null,null,{"$f":"SUM(F11:F12)-F13","v":332306},347958]
[]
[null,"OPERATING EXPENSES"]
[null,"Taxes",2015,null,null,68430,68430]
[null,"Insurance ",null,null,null,8834,8834]
[null,"Management ",null,0.05,null,13684,17262]
[null,"Sewer",null,null,null,1662,1662]
[null,"We Energies",null,null,null,15059,15059]
[null,"Repairs and Maintenance",null,null,null,21568,21568]
[null,"Pest Control",null,null,null,640,640]
[null,"Trash ",null,null,null,2874,2874]
[null,"On Site",{"$nulls":4},4800]
[null,"Lawn and Snow",null,null,null,1402,1402]
[null,"Elevator ",null,null,null,1900,1900]
[null,"Reserves",null,0.02,null,null,6959]
[null,"Total Expense ",null,null,null,{"$f":"SUM(F17:F28)","v":136053},{"$f":"SUM(G17:G28)","v":151390}]
[null,"Net Operating Income",null,null,null,{"$f":"F14-F29","v":196253},{"$f":"G14-G29","v":196568}]