{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["167-169 Smith St"],"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":"167-169 Smith St","index":0,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
[]
[]
[null,"Income & Expenses"]
[null,"Units","Bedroom Count","Monthly Projected Rent","Pet Fees","Total Monthly Income","Yearly Projected Rent"]
[null,"1L",2,1870,35,{"$f":"D5+E5","v":1905},{"$f":"F5*12","v":22860}]
[null,"1R",2,2050,null,{"$f":"D6+E6","v":2050},{"$f":"F6*12","v":24600}]
[null,"2L",2,2055,35,{"$f":"D7+E7","v":2090},25080]
[null,"2R",2,2115,null,{"$f":"D8+E8","v":2115},25380]
[null,"3L",2,2175,null,{"$f":"D9+E9","v":2175},26100]
[null,"3R",2,2150,null,{"$f":"D10+E10","v":2150},25800]
[null,"NSF Fee Income",{"$nulls":4},250]
[null,"Security Deposit Reductions",{"$nulls":4},2200]
[null,"Application Fee Income",{"$nulls":4},913.75]
[null,"Late Fee Income",{"$nulls":4},520]
[]
[null,"Gross Potential Income",null,{"$f":"SUM(D5:D15)","v":12415},null,null,{"$f":"SUM(G5:G15)","v":153703.75}]
[null,"Vacancy ",0.03,null,null,null,{"$f":"C17*G16","v":4611.1125000000002}]
[null,"Gross Income Post Vacancy",{"$nulls":4},{"$f":"G16-G17","v":149092.63750000001}]
[]
[null,"Expenses",null,null,null,"% ","Actual $ Amount (2025/2026)"]
[null,"Taxes",null,null,null,{"$f":"G21/$G$16","v":9.8734806405178788E-2},15175.91]
[null,"Water & Sewer",null,null,null,{"$f":"G22/$G$16","v":1.8298317380024885E-2},2812.52]
[null,"Electric",null,null,null,{"$f":"G23/$G$16","v":2.7579678439855894E-3},423.91]
[null,"Property Insurance",null,null,null,{"$f":"G24/$G$16","v":2.588830786496751E-2},3979.13]
[null,"Garbage & Cleaning ",null,null,null,{"$f":"G25/$G$16","v":9.1084309914364475E-3},1400]
[null,"Landscaping ",null,null,null,{"$f":"G26/$G$16","v":4.6192757170856278E-3},710]
[null,"Snow Removal - Est",null,null,null,{"$f":"G27/$G$16","v":1.3012044273480641E-3},200]
[null,"Accounting",null,null,null,{"$f":"G28/$G$16","v":5.5301188162292722E-3},850]
[null,"Admin",null,null,null,{"$f":"G29/$G$16","v":4.8795166025552405E-3},750]
[null,"Repairs & Maintenance ",null,null,null,{"$f":"G30/$G$16","v":1.9518066410220962E-2},3000]
[null,"Reserves",null,null,null,{"$f":"G31/$G$16","v":7.8072265640883841E-3},1200]
[null,"Management",null,null,null,0.03,{"$f":"F32*G18","v":4472.779125}]
[null,"Total Expenses ",null,null,null,{"$f":"G33/$G$16","v":0.22754323902312079},{"$f":"SUM(G21:G32)","v":34974.249125000002}]
[null,"Expenses Per Unit",{"$nulls":4},{"$f":"G33/6","v":5829.0415208333334}]
[]
[null,"NOI",{"$nulls":4},{"$f":"G18-G33","v":114118.38837500001}]
[]
[null,"Sale Price",{"$nulls":4},1800000]
[null,"Cap Rate ",{"$nulls":4},{"$f":"G36/G38","v":6.3399104652777788E-2}]