{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["PnL2025 fully Occupied"],"not_rendered":{"charts":0,"images":0,"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":"PnL2025 fully Occupied","index":0,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["509 Branford LLC"]
["PROJECTION 2026"]
[]
[null,"2025-01-01","2025-02-01","2025-03-01","2025-04-01","2025-05-01","2025-06-01","2025-07-01","2025-08-01","2025-09-01","2025-10-01","2025-11-01","2025-12-01","Total"]
["Income"]
["Income"]
["4105 - RENTAL INCOME",{"$f":"677*79+(1500*2)","v":56483},56483,56483,56483,56483,56483,56483,56483,56483,56483,56483,56483,{"$f":"SUM(B7:M7)","v":677796},"Based on 81 unit - 79@ 677/mo + rental TWO apartments $1500/mo each"]
["Total Income",{"$f":"SUM(B7:B7)","v":56483},56483,56483,56483,56483,56483,56483,56483,56483,56483,56483,56483,677796]
[]
["Total Income",{"$f":"+B8","v":56483},56483,56483,56483,56483,56483,56483,56483,56483,56483,56483,56483,677796]
[]
[]
["Expense"]
["Expense"]
["5000 - RE TAXES",13997.94,0,0,0,0,0,13997.94,0,0,0,0,0,27995.88,"Actual 2 tax bills - 2024/2025"]
["5120 - ELECTRIC",{"$f":"123.09+159.38","v":282.47000000000003},{"$f":"123.09+159.38","v":282.47000000000003},282.47000000000003,282.47000000000003,282.47000000000003,282.47000000000003,282.47000000000003,282.47000000000003,282.47000000000003,282.47000000000003,282.47000000000003,282.47000000000003,3389.6400000000012,"These are the actual two meter bills. Acct #7088 is for the street light. Carl will verify which account meter #029527022 corresponds to."]
["5130 - WATER",2198.15,2198.15,2198.15,2198.15,2198.15,2198.15,2198.15,2198.15,2198.15,2198.15,2198.15,2198.15,26377.800000000007,"Applied the actual April 2025 monthly bill throughout the year."]
["5131 - SEWER USAGE FEE",0,0,0,0,0,0,0,null,0,0,0,0,null,"BILLED BACK TO TENANTS"]
["5330 - SNOW REMOVAL",2000,2000,2000,{"$nulls":8},2000,8000,"Actual 1 year invoices"]
["5339 - LANDSCAPE",null,null,null,4500,3000,null,675,1800,{"$f":"1800+2650","v":4450},2650,null,null,17075,"Actual 1 year invoices"]
["5340 - REFUSE",{"$nulls":13},"TO BE BILLED BACK TO TENANTS STARTING IN 2026"]
["5400 - INSURANCE",{"$f":"256.666666666667+175.55","v":432.21666666666704},{"$f":"256.666666666667+175.55","v":432.21666666666704},432.21666666666704,432.21666666666704,432.21666666666704,432.21666666666704,432.21666666666704,432.21666666666704,432.21666666666704,432.21666666666704,432.21666666666704,432.21666666666704,5186.6000000000049,"Oil tank insurance $3080 and monthly hanover Insurance 175.22/mo (allocated invoice)"]
["5900 - MANAGEMENT FEE",3409.37,3409.37,3409.37,3409.37,3409.37,3409.37,3409.37,3409.37,3409.37,3409.37,3409.37,3409.37,{"$f":"SUM(B23:M23)","v":40912.44},"Actual new monthly rate 5/2025"]
["Total Expense",{"$f":"SUM(B15:B23)","v":22320.146666666667},{"$f":"SUM(C15:C23)","v":8322.2066666666669},{"$f":"SUM(D15:D23)","v":8322.2066666666669},10822.206666666667,9322.2066666666669,6322.2066666666669,20995.146666666667,8122.2066666666669,10772.206666666667,8972.2066666666669,6322.2066666666669,8322.2066666666669,{"$f":"SUM(N15:N23)","v":128937.36000000002}]
[]
["Total Expense",{"$f":"+B24","v":22320.146666666667},8322.2066666666669,8322.2066666666669,10822.206666666667,9322.2066666666669,6322.2066666666669,20995.146666666667,8122.2066666666669,10772.206666666667,8972.2066666666669,6322.2066666666669,8322.2066666666669,128937.35999999999]
[]
[]
["Operating Net Income",{"$f":"+B10-B26","v":34162.853333333333},48160.793333333335,48160.793333333335,45660.793333333335,47160.793333333335,50160.793333333335,35487.853333333333,48360.793333333335,45710.793333333335,47510.793333333335,50160.793333333335,48160.793333333335,548858.64]
[]
["VALUE AT A 7 CAP = $7.8MM"]