{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Rent Roll","TTM P&L through Apr 25","Pro Forma P&L"],"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":"Rent Roll","index":0,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Unit","Tenant","Rent","Pro-Forma Rent","Notes","Lease From","Lease To"]
[null,"Main Road (333)-N - 333 Main Road Tiverton, RI 02878","",null,null,null,"",""]
[null,"Unit 1",null,null,2100,"Unit under renovation - will be finished in ~2 months"]
[null,"Unit 2","Joshua M. Cokk",1545,1545,null,"2024-07-01","2025-06-30"]
[null,"Unit 3","Samantha M. Moreira",1545,1545,null,"2025-05-01","2026-04-30"]
[null,"Unit 4","Paula A. Sando",1495,1495,null,"2025-01-01","2025-12-31"]
[null,"Unit 5",null,null,1545,"Units will be listed in ~1 week"]
[null,"Unit 6",null,null,1545,"Units will be listed in ~1 week"]
[null,"Unit 7","Samantha T. Santos",1495,1495,null,"2025-02-15","2026-01-31"]
[null,"Unit 8","Matthew M. Stellingwerf",1585,1585,null,"2024-07-01","2025-06-30"]
[null,"Unit 9",null,null,1300,"Zoned as an 8 unit but there are 10 units"]
[null,"Unit 10",null,null,1300,"Zoned as an 8 unit but there are 10 units"]
[null,"8 Units",null,{"$f":"+SUM(D4:D13)","v":7665},{"$f":"+SUM(E4:E13)","v":15455}]
[null,"Smith Street (1960)-N - 1960 Smith Street North Providence, RI 02911","",null,null,null,"",""]
[null,"Unit 1","Maleah Irene Euresti",2050,2050,null,"2023-11-01","2024-10-31"]
[null,"Unit 2","Ileam Monterroso",1675,1675,null,"2023-04-01","2026-03-31"]
[null,"Unit 3","Alexus Del  Core",1350,1350,null,"2023-12-01","2024-11-30"]
[null,"Unit 4","Kaitlyn Pitts",1500,1500,null,"2023-04-01","2024-03-31"]
[null,"Unit 5","Cheyenne A. Ervin",1525,1525,null,"2024-09-01","2025-08-31"]
[null,"5 Units",null,{"$f":"+SUM(D16:D20)","v":8100},{"$f":"+SUM(E16:E20)","v":8100}]
[null,"Victor Street (95)-N - 95 Victor Street Woonsocket, RI 02895","",null,null,null,"",""]
[null,"Unit 1","Jennifer Locke",1350,1350,null,"2023-09-01","2024-08-31"]
[null,"Unit 2","Felix Gonzalez",1350,1350,null,"2024-05-26"]
[null,"Unit 3","Hannah E. Prairie",1725,1725,null,"2024-06-01","2025-05-31"]
[null,"Unit 4","Siobhan Harrington",1875,1875,null,"2023-07-01"]
[null,"Unit 5","Josh Beatty",1550,1550,null,"2023-09-01"]
[null,"Unit 6","Luke Thomas Holden",1735,1735,null,"2023-04-01"]
[null,"Unit 7","Zaida Hernandez",1560,1560,null,"2023-10-09"]
[null,"7 Units",null,{"$f":"+SUM(D23:D29)","v":11145},{"$f":"+SUM(E23:E29)","v":11145}]
[null,"Winsor Street (106-108)-N - 106-108 Winsor Street New Bedford, MA 02744","",null,null,null,"",""]
[null,"106 Winsor Unit 1","Kiana Eileen Fernandez",1410,1410,null,"2023-03-09"]
[null,"106 Winsor unit 2","Nathan C. Oliveira",1195,1195,null,"2024-04-01","2025-03-31"]
[null,"106 Winsor Unit 3","Nellyanne Medina Santiago",1445,1445,null,"2025-02-15","2026-01-31"]
[null,"108 Winsor Unit 1","Jamaal  Smith",1475,1475,null,"2023-06-16"]
[null,"108 Winsor Unit 2","Brian Acevedo",1500,1500,null,"2023-08-15","2024-08-14"]
[null,"108 Winsor Unit 3",null,1495,1495,null,"2025-05-16","2026-04-20"]
[null,"6 Units",null,{"$f":"+SUM(D32:D37)","v":8520},{"$f":"+SUM(E32:E37)","v":8520}]
[]
[null,"Total",null,{"$f":"+D38+D30+D21+D14","v":35430},{"$f":"+E38+E30+E21+E14","v":43220}]

{"sheet":"TTM P&L through Apr 25","index":1,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["TTM - 5/24 through 4/25"]
["Account Name","Main Road (333)-N","Smith Street (1960)-N","Victor Street (95)-N","Winsor Street (106-108)-N","Total"]
["Operating Income & Expense"]
["    Income"]
["        RENTS"]
["            Rent Income",64437.5,65431,126825.94,95437.5,{"$f":"+SUM(B6:E6)","v":352131.94}]
["            Section 8 Rent",0,30386,0,0,{"$f":"+SUM(B7:E7)","v":30386}]
["        Total RENTS",{"$f":"+SUM(B6:B7)","v":64437.5},95817,126825.94,95437.5,382517.94]
["        FEES"]
["            Resident Benefit Package",0,120,80,0,{"$f":"+SUM(B10:E10)","v":200}]
["            Screening Fee",0,0,0,60,{"$f":"+SUM(B11:E11)","v":60}]
["            Late Fee",0,0,-100,0,{"$f":"+SUM(B12:E12)","v":-100}]
["        Total FEES",0,120,-20,60,180]
["        Laundry Income",34.5,372.75,657.75,0,{"$f":"+SUM(B14:E14)","v":1065}]
["    Total Operating Income",{"$f":"+B8+B13+B14","v":64472},96309.75,127463.69,95497.5,383762.94]
["    Expense"]
["        INSURANCE"]
["            Property Insurance",6676.39,5291.23,6721.63,5794.11,{"$f":"+SUM(B18:E18)","v":24483.360000000001}]
["        Total INSURANCE",{"$f":"+B18","v":6676.39},5291.23,6721.63,5794.11,24483.360000000001]
["        LEGAL AND OTHER PROFESSIONAL FEES"]
["            Legal & Other Professional Services",449.46,449.37,3474.46,449.46,{"$f":"+SUM(B21:E21)","v":4822.75}]
["        Total LEGAL AND OTHER PROFESSIONAL FEES",{"$f":"+B21","v":449.46},449.37,3474.46,449.46,4822.75]
["        MANAGEMENT FEES"]
["            Management fees",4188.5,6228.2000000000007,8243.7000000000007,6203.5,{"$f":"+SUM(B24:E24)","v":24863.9}]
["        Total MANAGEMENT FEES",{"$f":"+B24","v":4188.5},6228.2000000000007,8243.7000000000007,6203.5,24863.9]
["        Maintenance"]
["            Snow Removal ",800,1365,555,600,{"$f":"+SUM(B27:E27)","v":3320}]
["            Vendor Maintenance",1907.14,4326.22,3262.5,2733.81,{"$f":"+SUM(B28:E28)","v":12229.67}]
["            Lyon Team - Repair",3073.57,1810.1,2107,1644.98,{"$f":"+SUM(B29:E29)","v":8635.65}]
["            Appliance Repair/Replace",0,825.89,2066.35,109,{"$f":"+SUM(B30:E30)","v":3001.24}]
["            Lyon Team - Cleaning",750,250,625,300,{"$f":"+SUM(B31:E31)","v":1925}]
["            Lyon Team - Vendor Assist",383.5,118,286,383.5,{"$f":"+SUM(B32:E32)","v":1171}]
["        Total Maintenance",{"$f":"+SUM(B27:B32)","v":6914.2100000000009},8695.2099999999991,8901.85,5771.29,30282.559999999998]
["        TAXES"]
["            Property Tax",8735,8971.0400000000009,12780.4,5861.23,{"$f":"+SUM(B35:E35)","v":36347.67}]
["        Total TAXES",{"$f":"+B35","v":8735},8971.0400000000009,12780.4,5861.23,36347.67]
["        UTILITIES"]
["            Gas",4792.6000000000004,0,0,0,{"$f":"+SUM(B38:E38)","v":4792.6000000000004}]
["            Water",939.48,3327,1597.18,2437.25,{"$f":"+SUM(B39:E39)","v":8300.91}]
["            Sewer",0,2602,2211.9299999999998,0,{"$f":"+SUM(B40:E40)","v":4813.93}]
["            Waste Removal",3019.92,0,2020.77,3343.23,{"$f":"+SUM(B41:E41)","v":8383.92}]
["            Electricity",475.74,0,926.34,0,{"$f":"+SUM(B42:E42)","v":1402.08}]
["        Total UTILITIES",{"$f":"+SUM(B38:B42)","v":9227.74},5929,6756.2199999999993,5780.48,27693.440000000002]
["        Fire Alarm Inspections",1792.83,414.09,343,1946.1,{"$f":"+SUM(B44:E44)","v":4496.0200000000004}]
["        Operating - Inspection/Fire Alarm",0,0,0,0,{"$f":"+SUM(B45:E45)","v":0}]
["    Total Operating Expense",{"$f":"+B19+B22+B25+B33+B36+SUM(B43:B45)","v":37984.130000000005},35978.14,47221.26,31806.17,152989.70000000001]
[]
["    NOI - Net Operating Income",{"$f":"+B8-B46","v":26453.369999999995},59838.86,79604.679999999993,63631.33,229528.24]
["   % of revenue",{"$f":"+B48/B8","v":0.41052756547041702},0.62451193420791717,0.62766875609201078,0.66673299279633269,0.60004568674609093]

{"sheet":"Pro Forma P&L","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Pro Forma Annual P&L"]
[]
[]
[null,null,"95 Victor","106 Winsor","333 Main","1960 Smith"]
[null,"Pro Forma Rent",{"$f":"+'Rent Roll'!E30*12","v":133740},{"$f":"+'Rent Roll'!E38*12","v":102240},{"$f":"+'Rent Roll'!E14*12","v":185460},{"$f":"+'Rent Roll'!E21*12","v":97200}]
[null,"Repairs & Maintenance",{"$f":"-0.075*C6","v":-10030.5},{"$f":"-0.075*D6","v":-7668},{"$f":"-0.075*E6","v":-13909.5},{"$f":"-0.075*F6","v":-7290}]
[null,"Management Fees",{"$f":"-0.065*C6","v":-8693.1},{"$f":"-0.065*D6","v":-6645.6},{"$f":"-0.065*E6","v":-12054.9},{"$f":"-0.065*F6","v":-6318}]
[null,"Insurance",-6721.63,-5794.11,-6676.39,-5291.23]
[null,"Utilities",-6756.2199999999993,-5780.48,-9227.74,-5929]
[null,"Taxes",-12780.4,-5861.23,-8735,-8971.0400000000009]
[null,"NOI",{"$f":"+SUM(C6:C11)","v":88758.15},{"$f":"+SUM(D6:D11)","v":70490.58},{"$f":"+SUM(E6:E11)","v":134856.47},{"$f":"+SUM(F6:F11)","v":63400.73}]
[null,"% of Revenue",{"$f":"+C12/C6","v":0.66366195603409595},0.68946185446009389,0.72714585355332684,0.65227088477366257]