{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Rocky Hill Budget","Base Rents","Operating Expenses","CAMandRE Tax"],"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":"Rocky Hill Budget","index":0,"n_rows":41,"n_cols":15,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["PROPERTY:  38 Town Line Road Rocky Hill CT"]
["NOI Analysis"]
["YEAR ENDING DECEMBER 31, 2026"]
[]
[{"$nulls":14},"2026"]
[null,null,"JAN","FEB","MARCH","APRIL","MAY","JUNE","JULY","AUGUST","SEPT","OCT","NOV","DEC","TOTAL"]
[null,"INCOME:"]
[]
[null," Base Rent",{"$f":"'Base Rents'!B15","v":53017.34},{"$f":"'Base Rents'!C15","v":53017.34},{"$f":"'Base Rents'!D15","v":53864.34},{"$f":"'Base Rents'!E15","v":53864.34},{"$f":"'Base Rents'!F15","v":53864.34},{"$f":"'Base Rents'!G15","v":53864.34},{"$f":"'Base Rents'!H15","v":53864.34},{"$f":"'Base Rents'!I15","v":53864.34},{"$f":"'Base Rents'!J15","v":53864.34},{"$f":"'Base Rents'!K15","v":54162.67},{"$f":"'Base Rents'!L15","v":54162.67},{"$f":"'Base Rents'!M15","v":54162.67},{"$f":"SUM(C9:N9)","v":645573.06999999995}]
[null," CAM and Insurance Recovery",{"$f":"217905/12","v":18158.75},{"$f":"217905/12","v":18158.75},18158.75,18158.75,18158.75,18158.75,18158.75,18158.75,18158.75,18158.75,18158.75,18158.75,{"$f":"SUM(C10:N10)","v":217905}]
[null," Real Estate Tax Recovery",{"$f":"136227/12","v":11352.25},{"$f":"136227/12","v":11352.25},11352.25,11352.25,11352.25,11352.25,11352.25,11352.25,11352.25,11352.25,11352.25,11352.25,{"$f":"SUM(C11:N11)","v":136227}]
[null,"TOTAL INCOME",{"$f":"SUM(C9:C11)","v":82528.34},82528.34,83375.34,83375.34,83375.34,83375.34,83375.34,83375.34,83375.34,83673.67,{"$f":"SUM(M9:M11)","v":83673.67},83673.67,{"$f":"SUM(C12:N12)","v":999705.07}]
[]
[null,"OPERATING EXPENSES:"]
[null,"UTILTY EXPENSES:"]
[null," Electric Costs",200,200,200,200,200,200,200,200,200,200,200,200,{"$f":"SUM(C16:N16)","v":2400}]
[null," Water & Sewer Expense",2400,2400,2400,2400,2400,2400,2400,2400,2400,2400,2400,2400,{"$f":"SUM(C17:N17)","v":28800}]
[null,"Vacant Electric and Gas",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C18:N18)","v":0}]
[null,"TOTAL UTILITY EXPENSES",{"$f":"SUM(C16:C17)","v":2600},2600,2600,2600,2600,2600,2600,2600,2600,2600,2600,2600,{"$f":"SUM(O16:O18)","v":31200}]
[]
[null,"BUILDING SERVICES:"]
[null," General Building Repairs",1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,{"$f":"SUM(C22:N22)","v":12000}]
[null," Roof - R & M",0,0,0,2000,0,0,0,0,0,2000,0,0,4000]
[null,"Fire Alarm and Maint.",200,0,0,200,0,0,200,0,0,200,0,0,800]
[null,"Sweeping/Lot Clean Up",300,300,300,300,300,300,300,300,300,300,300,300,3600]
[null,"Landscaping",0,0,0,3616,3616,7500,3616,3616,3616,3616,3616,0,{"$f":"SUM(C26:N26)","v":32812}]
[null,"Snow Removal",8538,8538,8538,0,0,0,0,0,0,0,8538,8538,42690]
[null,"TOTAL BUILDING SERVICES",{"$f":"SUM(C22:C27)","v":10038},9838,9838,7116,4916,8800,5116,4916,4916,7116,13454,9838,{"$f":"SUM(O22:O27)","v":95902}]
[]
[null,"ADMINISTRATIVE COSTS:"]
[null," Management Fees",{"$f":"C12*0.04*1.0635","v":3510.7555835999997},3510.7555835999997,3546.7869635999996,3546.7869635999996,3546.7869635999996,3546.7869635999996,3546.7869635999996,3546.7869635999996,3546.7869635999996,3559.4779217999999,3559.4779217999999,3559.4779217999999,{"$f":"SUM(C31:N31)","v":42527.453677799989}]
[null,"TOTAL ADMINISTRATIVE COSTS",{"$f":"SUM(C31:C31)","v":3510.7555835999997},3510.7555835999997,3546.7869635999996,3546.7869635999996,3546.7869635999996,3546.7869635999996,3546.7869635999996,3546.7869635999996,3546.7869635999996,3559.4779217999999,3559.4779217999999,3559.4779217999999,42527.453677799989]
[]
[null,"TAXES/INSURANCE:"]
[null," Insurance Expense",2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,{"$f":"SUM(C35:N35)","v":24000}]
[null,"Real Estate Taxes",66452,{"$nulls":5},{"$f":"C36*1.05","v":69774.600000000006},{"$nulls":5},{"$f":"SUM(C36:N36)","v":136226.6}]
[null,"TOTAL TAXES / INSURANCE",{"$f":"SUM(C35:C36)","v":68452},2000,2000,2000,2000,2000,71774.600000000006,2000,2000,2000,2000,2000,160226.6]
[]
[null,"TOTAL OPERATING EXPENSES",{"$f":"+C19+C28+C32+C37","v":84600.755583599996},17948.755583599999,17984.7869636,15262.7869636,13062.7869636,16946.7869636,83037.386963600002,13062.7869636,13062.7869636,15275.4779218,21613.4779218,17997.4779218,329856.0536778]
[]
[null,"NET OPERATING INCOME(LOSS)",{"$f":"+C12-C39","v":-2072.4155835999991},64579.584416400001,65390.553036400001,68112.553036400001,70312.553036400001,66428.553036400001,337.95303639999474,70312.553036400001,70312.553036400001,68398.192078199994,62060.192078199994,65676.192078199994,669849.01632219995]

{"sheet":"Base Rents","index":1,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Base Rents DaBurr Rocky Hill LLC"]
[]
[null,"January","February","March","April","May","June","July","August","September","October","November","December","Annual Total"]
["Tenant"]
["Noah Nails",2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,{"$f":"SUM(B5:M5)","v":24000}]
["Swan Vision",1760,1760,1760,1760,1760,1760,1760,1760,1760,1760,1760,1760,{"$f":"SUM(B6:M6)","v":21120}]
["Sola Salon",7466,7466,7466,7466,7466,7466,7466,7466,7466,7466,7466,7466,89592]
["VK Spirits",5848,5848,5848,5848,5848,5848,5848,5848,5848,5848,5848,5848,70176]
["Edible Arngmnts",2275,2275,2275,2275,2275,2275,2275,2275,2275,2275,2275,2275,27300]
["WNT",16940,16940,17787,17787,17787,17787,17787,17787,17787,17787,17787,17787,211750]
["Town Line Laundry",3325,3325,3325,3325,3325,3325,3325,3325,3325,3325,3325,3325,39900]
["Town Fair Tire",10416.67,10416.67,10416.67,10416.67,10416.67,10416.67,10416.67,10416.67,10416.67,10416.67,10416.67,10416.67,125000.04]
["Jersey Mikes",2986.67,2986.67,2986.67,2986.67,2986.67,2986.67,2986.67,2986.67,2986.67,3285,3285,3285,{"$f":"SUM(B13:M13)","v":36735.03}]
[]
["TOTALS:",{"$f":"SUM(B5:B13)","v":53017.34},{"$f":"SUM(C5:C13)","v":53017.34},53864.34,53864.34,53864.34,53864.34,53864.34,53864.34,53864.34,54162.67,54162.67,54162.67,{"$f":"SUM(N5:N13)","v":645573.07000000007}]

{"sheet":"Operating Expenses","index":2,"n_rows":27,"n_cols":16,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[{"$nulls":13},2026]
[null,"JAN","FEB","MARCH","APRIL","MAY","JUNE","JULY","AUGUST","SEPT","OCT","NOV","DEC","TOTAL"]
["OPERATING EXPENSES:"]
["UTILTY EXPENSES:"]
[" Electric Costs",{"$f":"'Rocky Hill Budget'!C16","v":200},{"$f":"'Rocky Hill Budget'!D16","v":200},{"$f":"'Rocky Hill Budget'!E16","v":200},{"$f":"'Rocky Hill Budget'!F16","v":200},{"$f":"'Rocky Hill Budget'!G16","v":200},{"$f":"'Rocky Hill Budget'!H16","v":200},{"$f":"'Rocky Hill Budget'!I16","v":200},{"$f":"'Rocky Hill Budget'!J16","v":200},{"$f":"'Rocky Hill Budget'!K16","v":200},{"$f":"'Rocky Hill Budget'!L16","v":200},{"$f":"'Rocky Hill Budget'!M16","v":200},{"$f":"'Rocky Hill Budget'!N16","v":200},{"$f":"SUM(B9:M9)","v":2400}]
[" Water & Sewer Expense",2600,2600,2600,2600,2600,2600,2600,2600,2600,2600,2600,2600,{"$f":"SUM(B10:M10)","v":31200}]
["TOTAL UTILITY EXPENSES",{"$f":"SUM(B9:B10)","v":2800},{"$f":"SUM(C9:C10)","v":2800},{"$f":"SUM(D9:D10)","v":2800},2800,2800,2800,2800,2800,2800,2800,2800,2800,{"$f":"SUM(N9:N10)","v":33600}]
[]
["BUILDING SERVICES:"]
[" General Building Repairs",{"$f":"'Rocky Hill Budget'!C22","v":1000},{"$f":"'Rocky Hill Budget'!D22","v":1000},{"$f":"'Rocky Hill Budget'!E22","v":1000},{"$f":"'Rocky Hill Budget'!F22","v":1000},{"$f":"'Rocky Hill Budget'!G22","v":1000},{"$f":"'Rocky Hill Budget'!H22","v":1000},{"$f":"'Rocky Hill Budget'!I22","v":1000},{"$f":"'Rocky Hill Budget'!J22","v":1000},{"$f":"'Rocky Hill Budget'!K22","v":1000},{"$f":"'Rocky Hill Budget'!L22","v":1000},{"$f":"'Rocky Hill Budget'!M22","v":1000},{"$f":"'Rocky Hill Budget'!N22","v":1000},{"$f":"SUM(B14:M14)","v":12000}]
[" Roof - R & M",0,{"$f":"'Rocky Hill Budget'!D23","v":0},{"$f":"'Rocky Hill Budget'!E23","v":0},3000,{"$f":"'Rocky Hill Budget'!G23","v":0},{"$f":"'Rocky Hill Budget'!H23","v":0},0,{"$f":"'Rocky Hill Budget'!J23","v":0},{"$f":"'Rocky Hill Budget'!K23","v":0},3000,{"$f":"'Rocky Hill Budget'!M23","v":0},{"$f":"'Rocky Hill Budget'!N23","v":0},{"$f":"SUM(B15:M15)","v":6000}]
["Fire Alarm and Maint.",{"$f":"'Rocky Hill Budget'!C24","v":200},{"$f":"'Rocky Hill Budget'!D24","v":0},{"$f":"'Rocky Hill Budget'!E24","v":0},{"$f":"'Rocky Hill Budget'!F24","v":200},{"$f":"'Rocky Hill Budget'!G24","v":0},{"$f":"'Rocky Hill Budget'!H24","v":0},{"$f":"'Rocky Hill Budget'!I24","v":200},{"$f":"'Rocky Hill Budget'!J24","v":0},{"$f":"'Rocky Hill Budget'!K24","v":0},{"$f":"'Rocky Hill Budget'!L24","v":200},{"$f":"'Rocky Hill Budget'!M24","v":0},{"$f":"'Rocky Hill Budget'!N24","v":0},800]
["Sweeping/Lot Clean Up",300,300,300,300,300,300,300,300,300,300,300,300,3600]
["Landscaping",{"$f":"'Rocky Hill Budget'!C26","v":0},{"$f":"'Rocky Hill Budget'!D26","v":0},{"$f":"'Rocky Hill Budget'!E26","v":0},3616,3616,3616,7500,3616,3616,3616,3616,{"$f":"'Rocky Hill Budget'!N26","v":0},32812]
["Snow Removal",8538,8538,8538,{"$f":"'Rocky Hill Budget'!F27","v":0},{"$f":"'Rocky Hill Budget'!G27","v":0},{"$f":"'Rocky Hill Budget'!H27","v":0},{"$f":"'Rocky Hill Budget'!I27","v":0},{"$f":"'Rocky Hill Budget'!J27","v":0},{"$f":"'Rocky Hill Budget'!K27","v":0},{"$f":"'Rocky Hill Budget'!L27","v":0},8538,8538,42690]
["TOTAL BUILDING SERVICES",{"$f":"SUM(B14:B19)","v":10038},{"$f":"SUM(C14:C19)","v":9838},9838,8116,4916,4916,9000,4916,4916,8116,13454,9838,{"$f":"SUM(N14:N19)","v":97902}]
[]
[" Management Fees",{"$f":"'Rocky Hill Budget'!C31","v":3510.7555835999997},{"$f":"'Rocky Hill Budget'!D31","v":3510.7555835999997},{"$f":"'Rocky Hill Budget'!E31","v":3546.7869635999996},{"$f":"'Rocky Hill Budget'!F31","v":3546.7869635999996},{"$f":"'Rocky Hill Budget'!G31","v":3546.7869635999996},{"$f":"'Rocky Hill Budget'!H31","v":3546.7869635999996},{"$f":"'Rocky Hill Budget'!I31","v":3546.7869635999996},{"$f":"'Rocky Hill Budget'!J31","v":3546.7869635999996},{"$f":"'Rocky Hill Budget'!K31","v":3546.7869635999996},{"$f":"'Rocky Hill Budget'!L31","v":3559.4779217999999},{"$f":"'Rocky Hill Budget'!M31","v":3559.4779217999999},{"$f":"'Rocky Hill Budget'!N31","v":3559.4779217999999},{"$f":"SUM(B22:M22)","v":42527.453677799989}]
[{"$nulls":15},"Utility, Services, Mngmnt Fees"]
["TAXES/INSURANCE:",{"$nulls":14},{"$f":"N22+N20+N11","v":174029.45367779999}]
[" Insurance Expense",2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,{"$f":"SUM(B25:M25)","v":24000}]
["Real Estate Taxes",66452,{"$nulls":5},{"$f":"B26*1.05","v":69774.600000000006},{"$nulls":5},{"$f":"SUM(B26:M26)","v":136226.6}]
["TOTAL TAXES / INSURANCE",{"$f":"SUM(B25:B26)","v":68452},2000,2000,2000,2000,2000,71774.600000000006,2000,2000,2000,2000,2000,160226.6]

{"sheet":"CAMandRE Tax","index":3,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["CAM, Insurance and RE Tax Reimbursements",{"$nulls":8},"CAM ",{"$f":"'Operating Expenses'!N11+'Operating Expenses'!N20","v":131502},null,"WNT Pays 50% of Base CAM"]
[{"$nulls":9},"Management",{"$f":"'Rocky Hill Budget'!O31","v":42527.453677799989},null,"WNT Pays 14.35% Management and Admin"]
[{"$nulls":9},"CAM and Mang",{"$f":"K1+K2","v":174029.45367779999}]
[{"$nulls":9},"15% Admin",{"$f":"K3*0.15","v":26104.418051669996},null,"WNT Shares"]
[{"$nulls":9},"TOTAL CAM",{"$f":"K3+K4","v":200133.87172946997},null,"Insurance(less prop cov)",{"$f":"N18","v":6992}]
[{"$nulls":9},"Insurance",{"$f":"N17","v":20875},null,"CAM",{"$f":"K1*0.5","v":65751}]
[{"$nulls":9},"RE Tax",{"$f":"'Rocky Hill Budget'!O36","v":136226.6},null,"Admin and Mang.",{"$f":"(K4+K2)*0.1435","v":9848.6735931789426}]
[{"$nulls":12},"TOTAL :",{"$f":"N5+N6+N7","v":82591.673593178944}]
["Tenant","SF Occupied","% Share CAM","% Share RE Tax","Yearly Insurance","Yearly CAM","Yearly RE Tax"]
["Noah Nails",1500,{"$f":"B10/J27","v":4.7117951939689019E-2},{"$f":"C10","v":4.7117951939689019E-2},{"$f":"C10*L13","v":654.13852677870261},{"$f":"C10*L14","v":5867.7963626334704},{"$f":"D10*J23","v":4652.2870903094081}]
["Swan Vision",1200,{"$f":"B11/J27","v":3.7694361551751217E-2},{"$f":"C11","v":3.7694361551751217E-2},{"$f":"D11*$L$13","v":523.31082142296214},{"$f":"D11*$L$14","v":4694.237090106777},{"$f":"D11*J23","v":3721.8296722475261},{"$nulls":5},"Insurance"]
["Vk Spirits",6380,{"$f":"B12/J27","v":0.2004083555834773},0.2004083555834773,{"$f":"D12*$L$13","v":2782.2692005654153},24957.693862401029,{"$f":"D12*J23","v":19787.727757449349},null,null,null,"Rest Of Tenants"]
["Edible Arngmnts",1820,{"$f":"B13/J27","v":5.7169781686822678E-2},5.7169781686822678E-2,{"$f":"D13*$L$13","v":793.68807915815921},7119.592919995278,{"$f":"D13*J23","v":5644.7750029087483},null,null,"Insurance Less WNT share",null,{"$f":"K6-N5","v":13883},"Property",6891]
["Town Line Laundry",2100,{"$f":"B14/J27","v":6.5965132715564631E-2},6.5965132715564631E-2,915.79393749018379,8214.9149076868598,{"$f":"D14*J23","v":6513.2019264331711},null,null,"CAM/Admin less WNT ",null,{"$f":"K5-N6-N7","v":124534.19813629103},"Liability",11002]
["Town Fair Tire",10010,{"$f":"B15/J27","v":0.31443379927752474},0.31443379927752474,{"$f":"D15*$L$13","v":4365.2844353698756},39157.761059974029,{"$f":"D15*J23","v":31046.262515998114},{"$nulls":5},"Umbrella",1285]
["Sola Salon",6265,{"$f":"B16/J27","v":0.19679597926810113},0.19679597926810113,{"$f":"D16*$L$13","v":2732.118580179048},24507.82947459913,{"$f":"D16*J23","v":19431.052413858961},{"$nulls":5},"Flood",1697]
["Jersey Mikes",2560,{"$f":"B17/J27","v":8.041463797706927E-2},8.041463797706927E-2,{"$f":"D17*$L$13","v":1116.3964190356526},{"$f":"D17*$L$14","v":10014.372458894457},{"$f":"D17*J23","v":7939.9033007947237},{"$nulls":5},"TOTAL",{"$f":"SUM(N13:N16)","v":20875}]
[{"$nulls":12},"WNT Share",{"$f":"(N17-N13)/2","v":6992}]
["WNT",5362,0.5,0.2752,{"$f":"N5","v":6992},{"$f":"N6+N7","v":75599.673593178944},{"$f":"D19*K7","v":37489.560320000004},{"$nulls":5},"Other Tenants",{"$f":"N17-N18","v":13883}]
[]
["Totals",null,null,null,{"$f":"SUM(E10:E19)","v":20875},{"$f":"SUM(F10:F19)","v":200133.87172946997},{"$f":"SUM(G10:G19)","v":136226.6},null,null,null,0.2752]
[{"$nulls":9},"Other Tenants","WNT"]
[null,null,null,"Total CAM+Ins.",{"$f":"E21+F21","v":221008.87172946997},null,null,null,"RE Tax",{"$f":"K7-K23","v":98737.039680000002},{"$f":"K7*K21","v":37489.560320000004}]
[null,{"$f":"SUM(B10:B19)","v":37197}]
[]
[{"$nulls":4},{"$f":"E17/12","v":93.033034919637714},{"$f":"F17/12","v":834.53103824120478},{"$f":"G17/12","v":661.65860839956031},null,"Total SF in Center",37197]
[{"$nulls":8},"Less WNT",{"$f":"J26-B19","v":31835}]