{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"n_rows":34,"n_cols":19,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Net Operating Income 2802 Whitis Ave"]
["As of October 22, 2025"]
[]
[null,null,null,"Montly Actuals*",null,"Projected",{"$nulls":10},"Actual Annual Total","Pro Forma Calculations"]
[null,null,null,"2025-09-01","2025-10-01","2025-11-01","2025-12-01","2026-01-01","2026-02-01","2026-03-01","2026-04-01","2026-05-01","2026-06-01","2026-07-01","2026-08-01"]
["Income"]
[null,"Rental Income",null,14703,{"$f":"D7","v":14703},{"$f":"E7","v":14703},14703,14703,14703,14703,14703,14703,14703,14703,14703,null,{"$f":"SUM(D7:O7)","v":176436},{"$f":"Q7","v":176436}]
[null,"Utility Payments from Tenants",null,{"$f":"D23*0.8","v":982.48},{"$f":"D8","v":982.48},982.48,982.48,982.48,982.48,982.48,982.48,982.48,982.48,982.48,982.48,null,{"$f":"SUM(D8:O8)","v":11789.759999999997},{"$f":"Q8","v":11789.759999999997}]
[]
[null,"Total Income",null,{"$f":"SUM(D7:D8)","v":15685.48},{"$f":"SUM(E7:E8)","v":15685.48},15685.48,15685.48,15685.48,15685.48,15685.48,15685.48,15685.48,15685.48,15685.48,15685.48,null,{"$f":"SUM(D10:O10)","v":188225.76},{"$f":"SUM(R7:R8)","v":188225.76}]
[]
[null,"Potential Gross Income (PGI)",{"$nulls":14},{"$f":"Q10","v":188225.76},{"$f":"R10","v":188225.76}]
[null,"Less Vacancy and Credit Loss 5%",{"$nulls":14},{"$f":"Q12*0.05","v":9411.2880000000005},{"$f":"R12*0.05","v":9411.2880000000005}]
[]
[null,"Effective Gross Income (EGI)",{"$nulls":14},{"$f":"Q12-Q13","v":178814.47200000001},{"$f":"R12-R13","v":178814.47200000001}]
[]
["Operating Costs"]
[null,"Repairs",null,null,275,0,200,200,200,200,200,200,200,200,200,null,{"$f":"SUM(D18:O18)","v":2075},4530,"* Using Reserve Study Figure in Pro Forma since it is higher"]
[null,"Property Tax",{"$nulls":5},21202,{"$nulls":8},21202,21202]
[null,"Insurance",{"$nulls":4},10575,{"$nulls":9},10575,10575]
[null,"Advertising",null,400,{"$nulls":5},400,{"$nulls":6},800,800]
[null,"Property Management",null,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0]
[null,"Electric, Water, & Trash",null,{"$f":"122.81*10","v":1228.0999999999999},{"$f":"D23","v":1228.0999999999999},{"$f":"E23","v":1228.0999999999999},1228.0999999999999,1228.0999999999999,1228.0999999999999,1228.0999999999999,1228.0999999999999,1228.0999999999999,1228.0999999999999,1228.0999999999999,1228.0999999999999,null,14737.200000000003,{"$f":"Q23","v":14737.200000000003}]
[null,"Internet",null,65,65,65,65,65,65,65,65,65,65,65,65,null,780,{"$f":"Q24","v":780}]
[]
[null,"Total Operating Costs",null,{"$f":"SUM(D18:D24)","v":1693.1},{"$f":"SUM(E18:E24)","v":1568.1},1293.0999999999999,12068.1,22695.1,1493.1,1893.1,1493.1,1493.1,1493.1,1493.1,1493.1,null,{"$f":"SUM(D26:O26)","v":50169.19999999999},{"$f":"SUM(R18:R24)","v":52624.200000000004}]
[null,"Expense Ratio",{"$nulls":14},{"$f":"R26/R15","v":0.29429497182979686},{"$f":"R26/R15","v":0.29429497182979686}]
[]
["Net Operating Income",null,null,{"$f":"D10-D26","v":13992.38},{"$f":"E10-E26","v":14117.38},{"$f":"F10-F26","v":14392.38},{"$f":"G10-G26","v":3617.3799999999992},{"$f":"H10-H26","v":-7009.619999999999},{"$f":"I10-I26","v":14192.38},{"$f":"J10-J26","v":13792.38},{"$f":"K10-K26","v":14192.38},{"$f":"L10-L26","v":14192.38},{"$f":"M10-M26","v":14192.38},{"$f":"N10-N26","v":14192.38},{"$f":"O10-O26","v":14192.38},null,{"$f":"SUM(D29:O29)","v":138056.56},{"$f":"Q15-R26","v":126190.272}]
[]
["Capitalization Rate",{"$nulls":15},{"$f":"Q29/1900000","v":7.2661347368421045E-2},{"$f":"R29/1900000","v":6.6415932631578953E-2}]
[]
["* Major capital improvements were completed in August 2025 where all units were vacated. Project included gut renovation on each unit including bathrooms, kitchens, floor, and walls. "]
[null,"Starting Sept 1, 2025, property is fully stabilized with full occupancy."]