{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Property Summary","2024 Monthly Detail","2025 Monthly Detail","Unit Details"],"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":"Property Summary","index":0,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[[65,0,65,6],[66,0,66,6],[67,0,67,6],[60,0,60,6],[61,0,61,6],[62,0,62,6],[63,0,63,6],[64,0,64,6],[0,0,0,6],[1,0,1,6],[15,0,15,6],[30,0,30,6],[39,0,39,6]]}
["1305 Hampden Blvd. – Investment Property Analysis"]
["Summer Valley Realty LLC"]
[]
["Unit","Bedrooms","Baths","Sq Ft","Notes","Current Rent/Mo","Annual Rent"]
["Unit A",2,1,800,"Outdoor patio",1350,{"$f":"F5*12","v":16200}]
["Unit B",2,1,720,null,1300,15600]
["Unit C",1,1,700,"Dining room & outdoor deck",1100,13200]
["Unit D",1,1,600,"Outdoor deck",875,10500]
["Unit E",1,1,720,null,815,9780]
["Unit F",2,2,1305,"Large under-roof patio & court yard",1095,13140]
["Unit G",1,1,700,null,705,8460]
["Unit H",1,1,345,null,800,9600]
["Unit J",1,1,800,null,950,11400]
["TOTAL",{"$nulls":4},{"$f":"SUM(F5:F13)","v":8990},{"$f":"SUM(G5:G13)","v":107880}]
[]
["2025 Annual Expenses (Actual – Partial Year Jan–Aug)"]
["Expense Category",null,"2024 Annual","2025 Annual"]
["Met-Ed (Electric)",null,1178.18,1132.0999999999999]
["UGI (Gas)",null,4576.37,5594.26]
["RAWA (Water/Sewer)",null,4199.93,4538.16]
["Lawn & Snow",null,2320,2325.1]
["Trash",null,1320,1320]
["Taxes",null,8698.85,8829.7099999999991]
["Insurance",null,9630.0499999999993,9949.4500000000007]
["Rental Permits",null,0,0]
["City Housing Bill",null,90,155.25]
["Business License",null,55,55]
["Mortgage / Loan Payment",null,28801.200000000001,28800.12,"(Excluded from NOI)"]
["TOTAL OPERATING EXPENSES",null,{"$f":"SUM(C18:C27)","v":32068.38},{"$f":"SUM(D18:D27)","v":33899.03}]
[]
["Cap Rate Analysis – Current Rents"]
["Gross Annual Rental Income",null,{"$f":"G14","v":107880}]
["Vacancy / Credit Loss (5%)",null,{"$f":"-C32*0.05","v":-5394}]
["Effective Gross Income (EGI)",null,{"$f":"C32+C33","v":102486}]
["Total Operating Expenses (excl. mortgage)",null,{"$f":"D29","v":33899.03}]
["Net Operating Income (NOI)",null,{"$f":"C34-C35","v":68586.97}]
["Est. Property Value (for cap rate)",null,975000]
["CAP RATE (Current)",null,{"$f":"C36/C37","v":7.0345610256410257E-2}]
[]
["PRO FORMA – Units D, E, G, H, J Raised to $1,100/mo"]
["Unit","Current Rent/Mo","Pro Forma Rent/Mo","Annual Increase"]
["Unit A",{"$f":"F5","v":1350},1450,{"$f":"(C42-B42)*12","v":1200}]
["Unit B",{"$f":"F6","v":1300},1350,600]
["Unit C",1100,1250,1800]
["Unit D",875,1250,4500]
["Unit E",815,1100,3420]
["Unit F",1095,1600,6060]
["Unit G",705,1100,4740]
["Unit H",800,1000,2400]
["Unit J",950,1250,3600]
["TOTAL",{"$f":"SUM(B42:B50)","v":8990},{"$f":"SUM(C42:C50)","v":11350},{"$f":"SUM(D42:D50)","v":28320}]
[]
["Pro Forma Gross Annual Income",null,{"$f":"C51*12","v":136200}]
["Pro Forma Vacancy / Credit Loss (5%)",null,{"$f":"-C53*0.05","v":-6810}]
["Pro Forma EGI",null,{"$f":"C53+C54","v":129390}]
["Operating Expenses (annualized)",null,{"$f":"C35","v":33899.03}]
["Pro Forma NOI",null,{"$f":"C55-C56","v":95490.97}]
["PRO FORMA CAP RATE",null,{"$f":"C57/C37","v":9.7939456410256406E-2}]

{"sheet":"2024 Monthly Detail","index":1,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,11],[17,0,17,11]]}
["1305 Hampden Blvd. – 2024 Monthly Income"]
["Month","A","B","C","D","E","F","G","H","J",null,"Total"]
["Jan",0,1250,840,855,795,1045,685,680,1050]
["Feb",0,1250,840,855,795,1045,685,680,1050]
["March",0,1250,840,855,795,1045,685,680,1050]
["April",720,1250,840,855,795,1045,685,680,1050]
["May",1200,1250,840,855,795,1045,685,0,1050]
["June",1200,1250,840,855,795,1045,685,453,1050]
["July",1200,1250,840,855,795,1045,685,800,1050]
["Aug",1200,1250,840,855,795,1045,685,800,1050]
["Sept",1200,1250,840,855,795,1045,685,800,1050]
["Oct",1200,1250,840,855,795,1045,685,800,1050]
["Nov",1200,1250,840,855,795,1045,685,800,950]
["Dec",1200,1250,840,855,795,1045,685,800,950]
["Total",{"$f":"SUM(B3:B14)","v":10320},15000,10080,10260,9540,12540,8220,7973,12400,null,{"$f":"SUM(L3:L14)","v":0}]
[]
[]
["1305 Hampden Blvd. – 2024 Monthly Expenses"]
["Month","Met-Ed","UGI","RAWA","Lawn/Snow","Trash","Taxes","Insurance","Rent Permits","Total Exp","Loan","Net"]
["Jan",154.52000000000001,760.39,439.79,575,110,0,0,0,{"$f":"SUM(B20:I20)","v":2039.7},2400.1]
["Feb",133.25,945.39,280.73,370,110,0,0,0,1839.37,2400.1]
["March",100.61,794.28,252.66,0,110,5186.32,1304.5999999999999,0,7748.4699999999993,2400.1]
["April",98.77,584.83000000000004,266.61,165,110,0,0,0,1225.21,2400.1]
["May",81.45,329.28,432.97,220,110,0,0,0,1173.7,2400.1]
["June",99.7,74,430.54,165,110,0,3426.95,0,4306.1899999999996,2400.1]
["July",102.39,58.93,273.27,220,110,0,0,0,764.58999999999992,2400.1]
["Aug",88.38,61.68,423.88,220,110,3512.53,0,0,4416.47,2400.1]
["Sept",90.46,66.28,390.45,165,110,0,2449.25,0,3271.44,2400.1]
["Oct",99.92,66.28,465.75,220,110,0,0,0,961.95,2400.1]
["Nov",80.989999999999995,224.14,244.41,0,110,0,0,0,659.54,2400.1]
["Dec",47.74,610.89,318.87,0,110,2449.25,0,0,3536.75,2400.1]
["Total",{"$f":"SUM(B20:B31)","v":1178.18},4576.37,4219.93,2320,1320,11148.1,7180.7999999999993,0,31943.38,28801.199999999993]

{"sheet":"2025 Monthly Detail","index":2,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,11],[13,0,13,11],[16,0,16,11]]}
["1305 Hampden Blvd. – 2025 Monthly Income (Jan–Aug Actual)"]
["Month","A","B","C","D","E","F","G","H","J",null,"Total"]
["Jan",1200,1250,840,855,795,1045,685,800,950]
["Feb",1200,1250,840,855,795,1045,685,800,950]
["March",1200,1250,870,875,815,1095,705,800,950]
["April",0,1250,870,875,815,1095,705,800,950]
["May",1350,1250,870,875,815,1095,705,800,950]
["June",1350,1250,870,875,815,1095,705,800,950]
["July",1350,927,870,875,815,1095,705,800,950]
["Aug",1350,0,870,875,815,1095,705,800,950]
["Sept",1350,0,870,875,815,1095,705,800,950]
["Total",{"$f":"SUM(B3:B11)","v":10350},8427,7770,7835,7295,9755,6305,7200,8550,null,{"$f":"SUM(L3:L11)","v":0}]
[]
["Note: Unit B rent going to $1,300 (per owner update). Data shows Aug at $0 – likely vacancy month."]
[]
[]
["1305 Hampden Blvd. – 2025 Monthly Expenses (Jan–Aug Actual)"]
["Month","Met-Ed","UGI","RAWA","Lawn/Snow","Trash","Taxes","Insurance","Rent Permits","Total Exp","Loan","Net"]
["Jan",62.67,1000.6,414.67,0,110,0,0,0,{"$f":"SUM(B19:I19)","v":1587.94},2400.0100000000002]
["Feb",62.18,1129.44,420.91,750,110,0,1471.55,0,3944.08,2400.0100000000002]
["March",77.84,1029.03,392.16,170,110,0,0,0,1779.03,2400.0100000000002]
["April",71.510000000000005,591.15,341.55,0,110,5317.18,0,0,6431.39,2400.0100000000002]
["May",86.08,374.99,413.52,318,110,0,0,0,1302.5899999999999,2400.0100000000002]
["June",107.88,100.02,362.09,0,110,0,3550.9,0,4230.8900000000003,2400.0100000000002]
["July",114.77,84.05,395.28,414,110,0,0,0,1118.0999999999999,2400.0100000000002]
["Aug",128.16,66.930000000000007,0,0,110,0,0,0,305.09000000000003,2400.0100000000002]
["Total",{"$f":"SUM(B19:B26)","v":711.08999999999992},4376.2100000000009,2740.1800000000003,1652,880,5317.18,5022.45,0,20699.11,19200.080000000002]

{"sheet":"Unit Details","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,4],[12,0,12,4],[13,0,13,4],[14,0,14,4],[15,0,15,4]]}
["1305 Hampden Blvd. – Unit Details"]
["Unit","Bedrooms","Baths","Sq Ft","Notes/Amenities"]
["Unit A",2,1,800,"Outdoor patio"]
["Unit B",2,1,720]
["Unit C",1,1,700,"Dining room & outdoor deck"]
["Unit D",1,1,600,"Outdoor deck"]
["Unit E",1,1,720]
["Unit F",2,2,1305,"Large under-roof patio & court yard (largest unit)"]
["Unit G",1,1,700]
["Unit H",1,1,345,"Smallest unit"]
["Unit J",1,1,800]
[]
["Building Amenities:"]
["  • Basement: 2 washers, 2 dryers (coin-op)"]
["  • Driveway and 3 off-street parking spots"]
["  • Gas boiler and hot water heater"]