{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["TOTALS","6730","7100","411","7103","4034"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"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":"TOTALS","index":0,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Grand Totals - All Properties"]
[]
[]
[null,"Month","Year"]
["Rents"]
["Commercial Store Front",{"$f":"SUM('6730'!B11+'7100'!B11+'411'!B11+'7103'!B11+'4034'!B11)","v":31410.68},{"$f":"SUM(B6*12)","v":376928.16000000003}]
["Apartments",0,0]
["Owner Occupied Store",{"$f":"SUM('[1]ST 1'!B21+'[1]St 2'!B21+'[1]St 3'!B21+'[1]St 4'!B21+'[1]St 6'!B21+'[1]St 7'!B21+'[1]St 8'!B21+'[1]St 10'!B21+'[1]St 15'!B21+'[1]St 18'!B21+'[1]St 19'!B21+'[1]St 21'!B21+'[1]St 16'!B21)","v":0},{"$f":"SUM(B8*12)","v":0}]
[]
["Total Rents",{"$f":"SUM(B6:B9)","v":31410.68},{"$f":"SUM(C6:C9)","v":376928.16000000003}]
[]
[]
["Expenses"]
["RE Tax",null,{"$f":"SUM('6730'!C27+'7100'!C27+'411'!C27+'7103'!C27+'4034'!C27)","v":60388.4}]
["Insurance",null,{"$f":"SUM('6730'!C28+'7100'!C28+'411'!C28+'7103'!C28+'4034'!C28)","v":19755.259999999998}]
[" ",null," "]
[" ",null," "]
[]
[]
[]
["Total Expenses",null,{"$f":"SUM(C14:C20)","v":80143.66}]
[]
["Net Income before Reim",null,{"$f":"SUM(C10-C21)","v":296784.5}]
[]
["Tenant Paid Expense",null,{"$f":"SUM('6730'!C27+'7100'!C34+'411'!C34+'7103'!C34+'4034'!C34)","v":76272.58}]
[]
["Net Income Actual",null,{"$f":"SUM(C23:C26)","v":373057.08}]

{"sheet":"6730","index":1,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["6730 New Falls Rd"]
["Levittown PA 19055"]
["Gross Building Are - 1,790 sq ft Land - 23,070 sq ft"]
[null,"Month","Year","Sq Ft / Notes"]
["Rents"]
["Commercial Store Front"]
["Tobacco Shop NNN",{"$f":"SUM(3477+650)","v":4127},{"$f":"SUM(B7*12)","v":49524},"1,790 sq ft"," "]
[{"$nulls":4}," "]
[]
[]
["Total Commercial",{"$f":"SUM(B7:B10)","v":4127},{"$f":"SUM(C7:C10)","v":49524}]
[]
["Apartment(s)"]
["Apartment"]
[]
[]
[]
[]
["Total Apartments",{"$f":"SUM(B14:B18)","v":0},{"$f":"SUM(C14:C18)","v":0}]
[]
["Owner Occupied Store",null,{"$f":"SUM(B21*12)","v":0}]
[]
["Total Rents",null,{"$f":"SUM(C11+C19+C21)","v":49524}]
[]
[]
["Expenses",null," "," ",null," "]
["RE Tax",null,{"$f":"SUM(1477.97+6303.84)","v":7781.81},"100% paid by Commercial Tenant",null," "]
["Insurance",null,3871.08]
[]
[]
[]
[]
[]
["Total Expenses",null,{"$f":"SUM(C27:C33)","v":11652.89}]
[]
["Net Income before Reim",null,{"$f":"SUM(C23-C34)","v":37871.11}]
[]
["Tenant Paid Expense",null,7800]
[]
["Net Income Actual",null,{"$f":"SUM(C36:C39)","v":45671.11}]

{"sheet":"7100","index":2,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["7100 New Falls Rd"]
["Levittown, PA 19055"]
["Gross Building Area - 1,853 sq ft Land - 32,500 sq ft"]
[null,"Month","Year","Sq Ft / Notes"]
["Rents"]
["Commercial Store Front"]
["Metro PCS NNN",{"$f":"SUM(2290+810)","v":3100},{"$f":"SUM(B7*12)","v":37200},"926.50 sq ft"]
["HEGEMONY, INC",{"$f":"SUM(2500+944.14)","v":3444.14},{"$f":"SUM(B8*12)","v":41329.68},"926.50 sq ft"]
[{"$nulls":4}," "]
[]
["Total Commercial",{"$f":"SUM(B7:B10)","v":6544.1399999999994},{"$f":"SUM(C7:C10)","v":78529.679999999993}]
[]
["Apartment(s)"]
["Apartment"]
[{"$nulls":5}," "]
[]
[]
[]
["Total Apartments",{"$f":"SUM(B14:B18)","v":0},{"$f":"SUM(C14:C18)","v":0}]
[]
["Owner Occupied Store",0,{"$f":"SUM(B21*12)","v":0}]
[]
["Total Rents",null,{"$f":"SUM(C11+C19+C21)","v":78529.679999999993}]
[]
[]
["Expenses",null," ","810.44 X 12"," "]
["RE Tax",null,{"$f":"SUM(3617.61+15832.95)","v":19450.560000000001},"100% paid by Commercial Tenant"," "]
["Insurance",null,3871,"50% paid by Commercial Tenant"]
[]
[]
[null,null,null,810.44]
[null,null," ",133.68]
[null,null,null,945]
["Total Expenses",null,{"$f":"SUM(C27:C33)","v":23321.56},{"$f":"SUM(23321.56/12/2)","v":971.73166666666668}]
[]
["Net Income before Reim",null,{"$f":"SUM(C23-C34)","v":55208.119999999995}]
[]
["Tenant Paid Expense",null,21055.19]
[]
["Net Income Actual",null,{"$f":"SUM(C36:C39)","v":76263.31}]

{"sheet":"411","index":3,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["411 W Trenton Ave"]
["Morrisville, PA 19067"]
["Gross Building Area - 1,738 sq ftLand - 12,000 sq ft"]
[null,"Month","Year","Sq Ft / Notes"]
["Rents"]
["Commercial Store Front"]
["Smok City",{"$f":"SUM(3090+817)","v":3907},{"$f":"SUM(B7*12)","v":46884},"1,238 sq ft"]
[null," "]
[]
[]
["Total Commercial",{"$f":"SUM(B7:B10)","v":3907},{"$f":"SUM(C7:C10)","v":46884}]
[]
["Apartment(s)"]
["Apartment"]
[]
[]
[]
[]
["Total Apartments",{"$f":"SUM(B14:B18)","v":0},{"$f":"SUM(C14:C18)","v":0}]
[]
["Owner Occupied Store",0,{"$f":"SUM(B21*12)","v":0}," "]
[]
["Total Rents",null,{"$f":"SUM(C11+C19+C21)","v":46884}]
[]
[{"$nulls":5},1075.76]
["Expenses",null," "," ",null,5892.37]
["RE Tax",null,{"$f":"SUM(1075.76+5892.37)","v":6968.13},"100% paid by Commercial Tenant"]
["Insurance",null,3455.97,"100% paid by Commercial Tenant"]
[]
[]
[]
[]
[]
["Total Expenses",null,{"$f":"SUM(C27:C33)","v":10424.1},{"$f":"SUM(10424.1/12)","v":868.67500000000007}]
[]
["Net Income before Reim",null,{"$f":"SUM(C23-C34)","v":36459.9}]
[]
["Tenant Paid Expense",null,9801.4699999999993,"816.78 X 12"]
[]
["Net Income Actual",null,{"$f":"SUM(C36:C39)","v":46261.37}]

{"sheet":"7103","index":4,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["7103 New Falls Rd"]
["Levittown, PA 19055"]
["Gross Building Area - 1,250 Land - "]
[null,"Month","Year","Sq Ft / Notes"]
["Rents"]
["Commercial Store Front"," "," "," "," "]
["Boost Mobile",2060,{"$f":"SUM(B7*12)","v":24720},"400 sq ft"]
["Jeweler",500,{"$f":"SUM(B8*12)","v":6000},"100 sq ft"]
["HEGEMONY, INC",{"$f":"SUM(5000+1037.61)","v":6037.61},{"$f":"SUM(B9*12)","v":72451.319999999992},"1050 sq ft"]
[]
["Total Commercial",{"$f":"SUM(B6:B9)","v":8597.61},{"$f":"SUM(C6:C9)","v":103171.31999999999}]
[]
["Apartment(s)"]
["Apartment"]
[]
[]
[{"$nulls":8}," "]
[]
["Total Apartments",{"$f":"SUM(B14:B18)","v":0},{"$f":"SUM(C14:C18)","v":0}]
[]
["Owner Occupied Store",0,{"$f":"SUM(B21*12)","v":0}," "]
[]
["Total Rents",null,{"$f":"SUM(C11+C19+C21)","v":103171.31999999999}]
[]
[]
["Expenses"]
["RE Tax",null,9535,"100% paid by Commercial Tenant",null,null,5710.57]
["Insurance",null,3473.06,"100% paid by Commercial Tenant"]
[]
[]
[]
[]
[]
["Total Expenses",null,{"$f":"SUM(C27:C33)","v":13008.06},{"$f":"SUM(C34/12)","v":1084.0049999999999}]
[]
["Net Income before Reim",null,{"$f":"SUM(C23-C34)","v":90163.26}]
[]
["Tenant Paid Expense",null,12451.39]
[]
["Net Income Actual",null,{"$f":"SUM(C36:C39)","v":102614.65}]

{"sheet":"4034","index":5,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["4034 Veterans Highway"]
["Levittown, PA 19056"]
["Gross Building Area - 8,392 sq ft Land - 17,032 sq ft"]
[null,"Month","Year","Sq Ft / Notes"]
["Rents"]
["Commercial Store Front"]
["Lesun LLC",{"$f":"SUM(2000+572.52)","v":2572.52},{"$f":"SUM(B7*12)","v":30870.239999999998},"1,446 sq ft"]
["HEGEMONY, INC",{"$f":"SUM(4500+1162.41)","v":5662.41},{"$f":"SUM(B8*12)","v":67948.92},"6,946 sq ft"]
[]
[]
["Total Commercial",{"$f":"SUM(B7:B10)","v":8234.93},{"$f":"SUM(C7:C10)","v":98819.16}]
[]
["Apartment(s)",{"$nulls":6}," "]
["Apartment",{"$nulls":6}," "]
[]
[]
[]
[]
["Total Apartments",{"$f":"SUM(B14:B18)","v":0},{"$f":"SUM(C14:C18)","v":0},null,null,null,2000]
[{"$nulls":6},527]
["Owner Occupied Store",0,{"$f":"SUM(B21*12)","v":0}," "," "]
[]
["Total Rents",null,{"$f":"SUM(C11+C19+C21)","v":98819.16}]
[]
[]
["Expenses",null," ",null,null," "]
["RE Tax",null,{"$f":"SUM(3104.61+13548.29)","v":16652.900000000001},"100% paid by Commercial Tenant",null," "]
["Insurance",null,5084.1499999999996,"100% paid by Commercial Tenant"]
[]
[]
[]
[]
[]
["Total Expenses",null,{"$f":"SUM(C27:C33)","v":21737.050000000003},{"$f":"SUM(21737.05/12)","v":1811.4208333333333},{"$f":"SUM(D34*67%)","v":1213.6519583333334}]
[null,null,null,{"$f":"SUM(21737.05/12)","v":1811.4208333333333},{"$f":"SUM(D35*33%)","v":597.76887499999998}]
["Net Income before Reim",null,{"$f":"SUM(C23-C34)","v":77082.11}]
[null,null,null,"67% 13949.1",1162.42]
["Tenant Paid Expense",null,20819.45,{"$f":"SUM(21710.32/12*0.67)","v":1212.1595333333335},572.52]
[null,null,null,{"$f":"SUM(21710.32/12*0.33)","v":597.03380000000004}]
["Net Income Actual",null,{"$f":"SUM(C36:C39)","v":97901.56}]