{"text_format":"2","workbook":"xlsx","n_sheets":21,"sheets":["Trailing 12","Rental Income Breakdown","Pro-Forma","Rent Roll - May 2026","worksheet","Mar 26","Feb 26","January 26","December 25","November","October","September","August","July","June","May","Apr","March","Feb","Jan","December"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"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":"Trailing 12","index":0,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Rolling 12-Kalispell Lofts"]
[null,"2025-05-01","2025-06-01","2025-07-01","2025-08-25","2025-09-25","2025-10-25","2025-11-25","2025-12-25","2026-01-25","2026-02-25","2026-03-25","2026-04-25","Average/month"]
["Total Rental Income",{"$f":"[1]May!E3","v":72102.84},{"$f":"[1]June!E3","v":69292.26999999999},{"$f":"[1]July!E3","v":79980.36},{"$f":"[1]August!E3","v":77286.170000000013},{"$f":"[1]September!E3","v":82034.37},{"$f":"[1]October!E3","v":74667.460000000006},{"$f":"[1]November!E3","v":68710.77},{"$f":"'[1]December 25'!W5","v":75790.61},{"$f":"'[1]January 26'!E3","v":69972.95},{"$f":"'[1]Feb 26'!E3","v":79912.14},{"$f":"'[1]Mar 26'!E3","v":82483},{"$f":"'[1]Apr 26'!E3","v":79237.560000000012},{"$f":"AVERAGE(B3:M3)","v":75955.875000000015}]
[]
["Expenses"]
["Debt Service",35301.79,35301.79,35301.79,35301.79,35301.79,35301.79,35301.79,35301.79,35301.79,35301.79,35301.79,35301.79,{"$f":"AVERAGE(B6:M6)","v":35301.789999999994}]
["Internet",950,980,950,920,1324,980,1010,1010,1010,1040,1010,1050,1019.5]
["Electricity",2727,1869,1991,2105,2227,2085,2495,3653,4486,5095,4630,3421,3065.3333333333335]
["Garbage",628.85,628.85,628.85,628.85,628.85,628.85,790.88,599.45000000000005,628.85,681,681,681,652.93999999999994]
["Water",972.1,1130.3399999999999,1400.53,1393.2,1346.15,1409.48,1723.8,1502.34,1710.11,1667.93,1456.5,1511.24,1435.3100000000002]
["Prop Management",6250,5600,6250,6250,6250,4727.2700000000004,4076.09,5833.33,6741.94,6250,6250,6250,5894.0525000000007]
["Insurance",1151.9116666666669,1151.9116666666669,1151.9116666666669,1151.9116666666669,1151.9116666666669,1151.9116666666669,1151.9116666666669,1151.9100000000001,1271.83,1271.83,1271.83,1271.83,1191.8843055555556]
["Marketing (normalized)",{"$f":"[1]worksheet!$C$45","v":94.74666666666667},{"$f":"[1]worksheet!$C$45","v":94.74666666666667},{"$f":"[1]worksheet!$C$45","v":94.74666666666667},{"$f":"[1]worksheet!$C$45","v":94.74666666666667},{"$f":"[1]worksheet!$C$45","v":94.74666666666667},{"$f":"[1]worksheet!$C$45","v":94.74666666666667},{"$f":"[1]worksheet!$C$45","v":94.74666666666667},{"$f":"[1]worksheet!$C$45","v":94.74666666666667},{"$f":"[1]worksheet!$C$45","v":94.74666666666667},{"$f":"[1]worksheet!$C$45","v":94.74666666666667},{"$f":"[1]worksheet!$C$45","v":94.74666666666667},{"$f":"[1]worksheet!$C$45","v":94.74666666666667},94.74666666666667]
["Property Tax (normalized)",234.66833333333301,234.66833333333301,234.66833333333301,234.66833333333301,234.66833333333301,234.66833333333301,234.66833333333301,4526.1400000000003,4526.1400000000003,4526.1400000000003,4526.1400000000003,4526.1400000000003,2022.7815277777775]
["Snow Plow",0,0,0,0,0,0,0,0,230,0,0,0,19.166666666666668]
["Annual Fire Inspections (normalized)",{"$f":"[1]worksheet!$D$45","v":315},{"$f":"[1]worksheet!$D$45","v":315},{"$f":"[1]worksheet!$D$45","v":315},{"$f":"[1]worksheet!$D$45","v":315},{"$f":"[1]worksheet!$D$45","v":315},{"$f":"[1]worksheet!$D$45","v":315},{"$f":"[1]worksheet!$D$45","v":315},{"$f":"[1]worksheet!$D$45","v":315},{"$f":"[1]worksheet!$D$45","v":315},{"$f":"[1]worksheet!$D$45","v":315},{"$f":"[1]worksheet!$D$45","v":315},{"$f":"[1]worksheet!$D$45","v":315},315]
["Misc Expenses/supplies (normalized)",{"$f":"[1]worksheet!$E$46","v":404.05166666666662},{"$f":"[1]worksheet!$E$46","v":404.05166666666662},{"$f":"[1]worksheet!$E$46","v":404.05166666666662},{"$f":"[1]worksheet!$E$46","v":404.05166666666662},{"$f":"[1]worksheet!$E$46","v":404.05166666666662},{"$f":"[1]worksheet!$E$46","v":404.05166666666662},{"$f":"[1]worksheet!$E$46","v":404.05166666666662},{"$f":"[1]worksheet!$E$46","v":404.05166666666662},{"$f":"[1]worksheet!$E$46","v":404.05166666666662},{"$f":"[1]worksheet!$E$46","v":404.05166666666662},{"$f":"[1]worksheet!$E$46","v":404.05166666666662},{"$f":"[1]worksheet!$E$46","v":404.05166666666662},404.05166666666668]
["Total Expenses",{"$f":"SUM(B6:B17)","v":49030.118333333332},47710.35833333333,48722.548333333332,48799.218333333331,49278.168333333335,47332.768333333333,47597.938333333332,54391.758333333331,56720.458333333336,{"$f":"SUM(K6:K17)","v":56647.488333333335},{"$f":"SUM(L6:L17)","v":55941.058333333334},{"$f":"SUM(M6:M17)","v":54826.798333333332},51416.556666666671]
[]
["Expenses Less Debt",{"$f":"B18-B6","v":13728.328333333331},12408.568333333329,13420.758333333331,{"$f":"E18-E6","v":13497.42833333333},{"$f":"F18-F6","v":13976.378333333334},12030.978333333333,12296.148333333331,19089.968333333331,21418.668333333335,21345.698333333334,20639.268333333333,19525.008333333331,{"$f":"AVERAGE(B20:M20)","v":16114.766666666665}]
[]
["Expense Ratio",{"$f":"B20/B3","v":0.19039927322326461},0.17907579493835793,0.16780067423219064,0.17464222037828148,0.17037222731561583,0.16112746212785772,0.17895518174710209,0.2518777502032683,0.30609926169088675,0.26711458776267705,0.25022451090931869,0.24641102443504481,{"$f":"AVERAGE(B22:M22)","v":0.2120083307469888}]
[]
["Monthly Profit",{"$f":"B3-B18","v":23072.721666666665},21581.91166666666,31257.811666666668,{"$f":"E3-E18","v":28486.951666666682},{"$f":"F3-F18","v":32756.20166666666},27334.691666666673,21112.831666666672,21398.851666666669,13252.491666666661,23264.651666666665,26541.941666666666,24410.76166666668,{"$f":"AVERAGE(B24:M24)","v":24539.318333333333}]
[]
[]
[]
["Rolling 12 ","Totals","Monthly Ave"]
["Total Income (May '25 - Apr'26)",{"$f":"SUM(B3:M3)","v":911470.50000000012},{"$f":"B29/12","v":75955.875000000015}]
["Total Exp",{"$f":"SUM(B18:M18)","v":616998.68000000005},{"$f":"B30/12","v":51416.556666666671}]
["Total Exp-Debt",{"$f":"SUM(B20:M20)","v":193377.19999999998},{"$f":"B31/12","v":16114.766666666665}]
["Average Exp Ratio",{"$f":"AVERAGE(B22:M22)","v":0.2120083307469888},{"$f":"B32","v":0.2120083307469888}]
["Total Profit",{"$f":"SUM(B24:M24)","v":294471.82},{"$f":"B33/12","v":24539.318333333333}]
[]
[]
["Rolling 6","Totals","Monthly Ave","Annualized"]
["Total Income (Nov '25 - Apr '26)",{"$f":"SUM(H3:M3)","v":456107.03},{"$f":"B37/6","v":76017.838333333333},{"$f":"C37*12","v":912214.06}]
["Total Exp",{"$f":"SUM(H18:M18)","v":326125.5},{"$f":"B38/6","v":54354.25},{"$f":"C38*12","v":652251}]
["Total Exp-Debt",{"$f":"SUM(H20:M20)","v":114314.76000000001},{"$f":"B39/6","v":19052.460000000003},{"$f":"C39*12","v":228629.52000000002}]
["Average Exp Ratio",{"$f":"AVERAGE(H22:M22)","v":0.25011371945804961},{"$f":"B40","v":0.25011371945804961},{"$f":"C40","v":0.25011371945804961}]
["Total Profit",{"$f":"SUM(H24:M24)","v":129981.53},{"$f":"B41/6","v":21663.588333333333},{"$f":"C41*12","v":259963.06}]
[]
[]
["Rolling 3","Totals","Monthly Ave"]
["Total Income (Feb '26 - Apr '26)",{"$f":"SUM(K3:M3)","v":241632.7},{"$f":"B45/3","v":80544.233333333337}]
["Total Exp",{"$f":"SUM(K18:M18)","v":167415.345},{"$f":"B46/3","v":55805.114999999998}]
["Total Exp-Debt",{"$f":"SUM(K20:M20)","v":61509.974999999999},{"$f":"B47/3","v":20503.325000000001}]
["Average Exp Ratio",{"$f":"AVERAGE(K22:M22)","v":0.25458337436901352},{"$f":"B48","v":0.25458337436901352}]
["Total Profit",{"$f":"SUM(K24:M24)","v":74217.35500000001},{"$f":"B49/3","v":24739.118333333336}]

{"sheet":"Rental Income Breakdown","index":1,"n_rows":19,"n_cols":16,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"2025-05-01","2025-06-01","2025-07-01","2025-08-25","2025-09-25","2025-10-25","2025-11-25","2025-12-25","2026-01-25","2026-02-25","2026-03-25","2026-04-25","Average",{"$f":"N4/45","v":0.97777777777777775}]
[null,"Total Rental Income",{"$f":"[1]Summary!B3","v":72102.84},{"$f":"[1]Summary!C3","v":69292.26999999999},{"$f":"[1]Summary!D3","v":79980.36},{"$f":"[1]Summary!E3","v":77286.170000000013},{"$f":"[1]Summary!F3","v":82034.37},{"$f":"[1]Summary!G3","v":74667.460000000006},{"$f":"[1]Summary!H3","v":68710.77},{"$f":"[1]Summary!I3","v":75790.61},{"$f":"[1]Summary!J3","v":69972.95},{"$f":"[1]Summary!K3","v":79912.14},{"$f":"[1]Summary!L3","v":82483},{"$f":"[1]Summary!M3","v":79237.560000000012},{"$f":"AVERAGE(C3:N3)","v":75955.875000000015}]
[null,"Occupied Units",42,43,44,45,45,43,43,43,42,45,45,44,{"$f":"AVERAGE(C4:N4)","v":43.666666666666664}]
[]
["rs","Rental Income (simple)",{"$f":"C3-(SUM(C7:C11))","v":64485.34},61961.26999999999,72173.36,69723.670000000013,74274.459999999992,66895.08,61135.640000000007,66971.240000000005,{"$f":"K3-(SUM(K7:K11))","v":60196.95},{"$f":"L3-(SUM(L7:L11))","v":68358.080000000002},{"$f":"M3-(SUM(M7:M11))","v":71946.06},{"$f":"N3-(SUM(N7:N11))","v":70865.570000000007},{"$f":"AVERAGE(C6:N6)","v":67415.56}]
[null,"Electricity (cost reclaimation)",{"$f":"[1]Summary!B8","v":2727},{"$f":"[1]Summary!C8","v":1869},{"$f":"[1]Summary!D8","v":1991},{"$f":"[1]Summary!E8","v":2105},{"$f":"[1]Summary!F8","v":2227},{"$f":"[1]Summary!G8","v":2085},{"$f":"[1]Summary!H8","v":2495},{"$f":"[1]Summary!I8","v":3653},{"$f":"[1]Summary!J8","v":4486},{"$f":"[1]Summary!K8","v":5095},{"$f":"[1]Summary!L8","v":4630},{"$f":"[1]Summary!M8","v":3421},3065.3333333333335]
[null,"Water",{"$f":"C4*25","v":1050},1075,1100,1125,1125,1075,1075,1075,{"$f":"K4*25","v":1050},1160,1160,1177,1103.9166666666667]
[null,"Internet",{"$f":"[1]worksheet!D16","v":1849},{"$f":"[1]worksheet!E16","v":1908},{"$f":"[1]worksheet!F16","v":1849},{"$f":"[1]worksheet!G16","v":1790},{"$f":"[1]worksheet!H16","v":1849},{"$f":"[1]worksheet!I16","v":1908},{"$f":"[1]worksheet!J16","v":1967},1849,1790,1790,1908,1849,1858.8333333333333]
[null,"Monthly Pet Fee",1370,1300,1250,1250,1300,1300,1300,1300,1250,1200,1555,965,1278.3333333333333]
[null,"Misc (App/Late /Cleaning Fees)",{"$f":"[1]worksheet!H24","v":621.5},{"$f":"[1]worksheet!I24","v":1179},{"$f":"[1]worksheet!J24","v":1617},{"$f":"[1]worksheet!K24","v":1292.5},{"$f":"[1]worksheet!L24","v":1258.9099999999999},{"$f":"[1]worksheet!M24","v":1404.38},{"$f":"[1]worksheet!N24","v":738.13},{"$f":"[1]worksheet!O24","v":942.37},{"$f":"[1]worksheet!P24","v":1200},{"$f":"[1]worksheet!Q24","v":2309.06},{"$f":"[1]worksheet!R24","v":1283.94},{"$f":"[1]worksheet!S24","v":959.99},1233.8983333333333]
[]
[]
[]
[]
[]
[null,"*Electricity is a pass through"]
[null,"*Water Billed at $25/Unit (updating to $32 with new leases)"]
[null,"*Internet cost is $30 for 100 mbps and $50 for 500mbps - billed at $59 for 100 mbps and $79 for 500 mbps (revenue generator)"]

{"sheet":"Pro-Forma","index":2,"n_rows":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,1,1,4],[32,1,32,4],[36,1,36,4],[53,1,53,4]]}
[]
[null,"Income & Expense Summary"]
[null,"Operating Income","Current T-12","Proforma","Notes"]
[null,"Market Rent",{"$f":"'Rental Income Breakdown'!O6*12","v":808986.72},{"$f":"'Rent Roll - May 2026'!F49","v":833400}]
[null,"Vacancy Loss",0,{"$f":"D4*0.04","v":33336},"Proforma Set to 4%",null,{"$f":"43/45","v":0.9555555555555556}]
[null,"Rent Concessions",0,0,"Currently no rent concessions"]
[null,"Bad Debt",0,{"$f":"D4*0.005","v":4167},"Proforma set to .5%"]
[null,"Total Rental Income",{"$f":"C4-C5-C7","v":808986.72},{"$f":"D4-D5-D7","v":795897}]
[null,"Admin Fee Income",{"$f":"'Rental Income Breakdown'!O11*12","v":14806.779999999999},{"$f":"45*360","v":16200},"Average $360/annually per unit"]
[null,"Pet Rent Income",{"$f":"'Rental Income Breakdown'!O10*12","v":15340},{"$f":"((95*45)*0.3)*12","v":15390},"Average $95/unit 30% usage"]
[null,"Internet Income",{"$f":"'Rental Income Breakdown'!O9*12","v":22306},{"$f":"((59*45)*0.75)*12","v":23895},"Average $59/unit 75% usage"]
[null,"Utility Reimbursement",{"$f":"('Rental Income Breakdown'!O7+'Rental Income Breakdown'!O8)*12","v":50031},{"$f":"C12","v":50031},"Pass through, similar usage"]
[null,"Effective Gross Income",{"$f":"C8+C9+C10+C12+C11","v":911470.5},{"$f":"D8+D9+D10+D12+D11","v":901413}]
[null,"Operating Expenses","T6 Financials","Proforma"]
[null,"Prop Management",{"$f":"'Trailing 12'!N11*12","v":70728.63},{"$f":"D13*0.08","v":72113.040000000008},"8% Mangement Fee"]
[null,"Marketing",{"$f":"'Trailing 12'!N13*12","v":1136.96},2500]
[null,"Snow Plow",3885,4000]
[null,"Annual Fire Inspections ",{"$f":"'Trailing 12'!N16*12","v":3780},3800]
[null,"Misc Expenses/Supplies ",{"$f":"'Trailing 12'!N17*12","v":4848.62},4900]
[null,"Turnover/Maintenance",0,{"$f":"275*45","v":12375},"Increased to $275/unit annually"]
[null,"Total Controllables",{"$f":"SUM(C15:C20)","v":84379.21},{"$f":"SUM(D15:D20)","v":99688.040000000008}]
[null,"Internet",{"$f":"'Trailing 12'!N7*12","v":12234},{"$f":"C22","v":12234},"Similar Utility Expenses Expected"]
[null,"Electricity",{"$f":"'Trailing 12'!N8*12","v":36784},{"$f":"C23","v":36784},"\""]
[null,"Garbage",{"$f":"'Trailing 12'!N9*12","v":7835.2799999999988},7835.2799999999988,"\""]
[null,"Water",{"$f":"'Trailing 12'!N10*12","v":17223.72},17223.72,"\""]
[null,"Insurance",{"$f":"'Trailing 12'!N12*12","v":14302.611666666668},{"$f":"360*45","v":16200},"$360/unit annually"]
[null,"Property Tax ",{"$f":"'Trailing 12'!N14*12","v":24273.37833333333},54313.66,"Proforma shows updated taxes for 2026"]
[null,"Capital Reserves",null,{"$f":"D13*0.02","v":18028.260000000002},"2% Capital Reserve - Lender Required"]
[null,"Total Fixed",{"$f":"SUM(C22:C28)","v":112652.98999999999},{"$f":"SUM(D22:D28)","v":162618.92000000001}]
[null,"Total Operating Expenses",{"$f":"C21+C29","v":197032.2},{"$f":"D21+D29","v":262306.96000000002}]
[null,"Expenses % of Gross",{"$f":"C30/C13","v":0.21616958530199279},{"$f":"D30/D13","v":0.29099531513301896},"Proforma trends with similar properties"]
[null,"Net Operting Income",{"$f":"C13-C30","v":714438.3},{"$f":"D13-D30","v":639106.04}]
[null,"Asking Price - Cap Rate Summary"]
[null,10450000,{"$f":"C32/B34","v":6.8367301435406702E-2},{"$f":"D32/B34","v":6.1158472727272734E-2}]
[]
[]
[null,"Debt Quotes - Income Breakdown Proforma"]
[null,"Feature","Option 1","Option 2","Option 3"]
[null,"Purchase Price",10450000,{"$f":"C39","v":10450000},{"$f":"D39","v":10450000}]
[null,"Down Payment ",{"$f":"C39-C41","v":3658000},{"$f":"D39-D41","v":3725000},3912000]
[null,"Loan Amount",6792000,6725000,6538000]
[null,"Loan Term",5,7,10]
[null,"Interest Only Debt Service",{"$f":"27423*12","v":329076},{"$f":"28497*12","v":341964},{"$f":"29067*12","v":348804}]
[null,"Prepayment","4.5yr ","6.5yr ","9.5yr "]
[null,"Interest Only Years",2,3,5]
[null,"Interest Rate",4.8500000000000001E-2,5.0900000000000001E-2,5.3400000000000003E-2]
[null,"Recourse","Non-Recourse","Non-Recourse","Non-Recourse"]
[null,"Rate Buydown Cost",135840,134500,130760]
[null,"FNMA Fee",6792,6725,6538]
[null,"Third Party Report",6500,6500,6500]
[null,"Origination Fees",67920,67250,65380]
[null,"Closing/Legal Cost",8500,8500,8500]
[null,"Total Buyers Equity",{"$f":"C40+C48+C49+C50+C51+C52","v":3883552},{"$f":"D40+D48+D49+D50+D51+D52","v":3948475},4129678]
[]
[null,"Total Income",{"$f":"D13","v":901413},{"$f":"C55","v":901413},{"$f":"D55","v":901413}]
[null,"Operating Expenses ",{"$f":"D30","v":262306.96000000002},{"$f":"C56","v":262306.96000000002},{"$f":"D56","v":262306.96000000002}]
[null,"Debt Service",{"$f":"C43","v":329076},{"$f":"D43","v":341964},{"$f":"E43","v":348804}]
[null,"Net Owner Income",{"$f":"C55-C56-C57","v":310030.04000000004},{"$f":"D55-D56-D57","v":297142.04000000004},{"$f":"E55-E56-E57","v":290302.04000000004}]
[null,"ROE",{"$f":"C58/C53","v":7.9831566565865486E-2},{"$f":"D58/D53","v":7.5254887013340599E-2},7.0296531593988687E-2]

{"sheet":"Rent Roll - May 2026","index":3,"n_rows":69,"n_cols":19,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,11],[49,0,49,1],[47,15,47,20]]}
["Kalispell Lofts — Rent Roll | May  2026"]
["Unit","Tenant(s)","Lease Start","Lease End","Beds/Baths","Market Rent","Base Rent","Internet","Water","Pet Fee","Total Rent","Deposit"]
["126-101","Lavetta & Robert Collier","2023-11-11","2026-11-30","1/1",1480,1480,59,25,null,{"$f":"G3+H3+I3+J3","v":1564},1630]
["126-102","Ryan Sandberg","2025-07-01","2026-06-30","1/1",1545,1545,59,25,50,{"$f":"G4+H4+I4+J4","v":1679},2045]
["126-103","Glenda Slaughter","2024-11-01","2026-11-30","1/1",1480,1480,59,25,50,{"$f":"G5+H5+I5+J5","v":1614},2230]
["126-104","Aleesha Bradeen","2025-05-01","2026-04-30","S/1",1250,1250,59,32,50,1391,1580]
["126-105","Joseph & Sheila Elsass","2024-10-25","2026-12-31","2/2",1875,1875,null,25,null,1900,1780]
["126-201","Travis Heitmann","2026-03-01","2027-02-28","1/1",1545,1545,59,32,50,1686,2045]
["126-202","Benjamin Cox","2025-07-01","2026-06-30","1/1",1545,1545,59,25,null,1629,1545]
["126-203","Kevin Barrow","2025-06-01","2026-05-31","1/1",1480,1480,null,25,null,1505,1480]
["126-204","Jim Goudy","2024-03-28","2026-03-31","-/1",1250,1250,59,25,null,1334,1250]
["126-205","Camille Finely & Cody Johnston","2024-05-01","2026-04-30","2/2",1780,1780,59,32,null,1871,1880]
["126-301","Elizabeth Petz, Ethan & Gannon Welder","2024-08-10","2026-08-31","1/1",1580,1580,59,25,null,1664,1580]
["126-302","Mitchell Sigman","2025-04-03","2027-03-31","1/1",1545,1545,null,32,null,1577,1545]
["126-303","Cassandra Grimm, Kristina Grimm & Wyatt Eckhart","2025-04-01","2026-03-31","1/1",1480,1480,59,25,50,1614,1480]
["126-304","Kristian Castillo","2024-01-01","2027-03-31","-/1",1250,1250,59,25,50,1384,1600]
["126-305","Dawson Lemay","2024-11-01","2026-10-31","2/2",1875,1875,59,25,100,2059,2375]
["128-101","Laurie Buccella","2024-02-26","2027-02-28","1/1",1580,1580,59,25,100,1764,1580]
["128-102","Rob Bowman","2025-05-01","2026-04-30","1/1",1545,1545,null,32,25,1602,1545]
["128-103","Samantha Varner & Vadim Khmelev","2025-08-01","2026-07-31","1/1",1480,1480,59,25,50,1614,1980]
["128-104","Amy Prangley","2023-11-01","2026-04-30","-/1",1250,1250,null,25,100,1375,1250]
["128-105","Amber & Eric Johnson","2024-11-08","2026-10-31","2/2",1875,1875,59,25,null,1959,1875]
["128-201","Shareka Harris","2025-09-01","2026-08-31","1/1",1545,1545,59,25,50,1679,1545]
["128-202","Jackman Robohm & Mary Hodges","2023-10-23","2026-04-30","1/1",1580,1580,59,32,null,1671,1580]
["128-203","Amanda Cardin & Thomas Burkhart","2025-05-17","2026-05-31","1/1",1480,1480,59,25,null,1564,1480]
["128-204","Seth Ragan","2025-10-01","2026-09-26","S/1",1250,1250,59,25,null,1334,1545]
["128-205","Alexander Piwojarski","2023-11-11","2026-11-30","2/2",1875,1875,59,25,null,1959,1930]
["128-301","Jeffery & Mackenzie Voigt","2025-05-01","2026-04-30","1/1",1545,1545,null,32,null,1577,1545]
["128-302","Jonathan Shoemate","2025-03-15","2027-03-31","1/1",1545,1545,null,25,null,1570,1545]
["128-303","David Kucharczyk, Macie Holm & Matthew Kucharczyk","2026-02-27","2027-02-28","1/1",1480,1480,59,32,null,1571,1480]
["128-304","Chris Horton","2024-05-01","2026-04-30","-/1",1250,1250,59,25,null,1334,1250]
["128-305","Jessalynn Holman & Kenneth Goldsberry","2023-12-14","2026-03-31","2/2",1875,1875,null,25,50,1950,2330]
["130-101","Michael Ince","2025-09-15","2026-04-30","1/1",1545,1545,59,25,null,1629,1545]
["130-102","Nicole Birk & Robert Miller","2024-05-06","2026-08-31","1/1",1580,1580,79,25,50,1734,2080]
["130-103","Jade Blanchard & Samuel Harris","2025-04-01","2026-03-31","1/1",1480,1480,59,25,null,1564,1250]
["130-104","Joel Arrieta","2025-10-10","2026-10-31","-/1",1300,1300,59,25,null,1384,1300]
["130-105","Almaz Yussupov","2025-05-08","2026-04-30","2/2",1875,1875,null,25,100,2000,1875]
["130-201","Alyssa Trevino & Jason Ahumada","2023-11-04","2026-11-30","1/1",1545,1545,null,25,100,1670,2030]
["130-202","—","2025-08-01","2026-07-31","1/1",1545,{"$nulls":4},0]
["130-203","Angela Curtis & Sara Johnston","2025-04-17","2026-04-30","1/1",1480,1480,null,32,null,1512,1480]
["130-204","Dita Babash","2025-10-20","2026-11-30","-/1",1380,1380,59,25,null,1464,1380]
["130-205","Almaz Yussupov, Anel Tucker & Anna Bartel","2024-05-08","2026-05-31","2/2",1780,1780,59,25,null,1864,1780]
["130-301","Katie Boyd","2025-04-11","2026-04-30","1/1",1545,1545,null,32,50,1627,1545]
["130-302","Anastasia & Yevdokiya Beaty","2025-05-01","2026-04-30","1/1",1545,1545,59,25,null,1629,1545]
["130-303","Jenifer Krause","2025-03-15","2027-03-31","1/1",1480,1480,59,25,null,1564,1480]
["130-304","Tyler Croy","2026-03-06","2026-08-31","S/1",1380,1380,59,32,null,1471,1380]
["130-305","Amber Scott & Emily Zangrilli","2024-07-15","2026-09-30","2/2",1875,1875,59,25,null,1959,1780]
["TOTALS",{"$nulls":4},{"$f":"SUM(F3:F47)","v":69450},{"$f":"SUM(G3:G47)","v":67905},1908,1177,1075,{"$f":"SUM(K3:K47)","v":72065},72955]
[{"$nulls":5},{"$f":"F48*12","v":833400}]
["Rent Roll Summary "]
["Total Units",45]
["Occupied Units",44]
["Occupancy %",{"$f":"B52/B51","v":0.97777777777777775}]
["Avg Base Rent (Occupied)",{"$f":"AVERAGE(G3:G47)","v":1543.2954545454545}]
["Monthly Base Rent",{"$f":"G48","v":67905}]
["Monthly Internet",{"$f":"H48","v":1908}]
["Monthly Pet Fees",{"$f":"J48","v":1075}]
["Monthly Water",{"$f":"I48","v":1177}]
["Avg Total Rent + RUBs (Occ)",{"$f":"AVERAGE(K10:K47)","v":1594.7894736842106}]
["Total Monthly Rent + RUBs",{"$f":"K48","v":72065}]
[]
[]
["Occupancy",0.04,0.08,0.12,0.16,"5/25","6/25","7/25","8/25","9/25","10/25","11/25","12/25","1/26","2/26","3/26","T-12  Average","T-6  Average","T-3  Average"]
["Total Units",45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,{"$f":"AVERAGE(E64:P64)","v":45},{"$f":"AVERAGE(K64:P64)","v":45},{"$f":"AVERAGE(N64:P64)","v":45}]
["Occupied Units",{"$f":"B67+B68+B69","v":37},35,33,37,40,44,45,45,44,{"$f":"K67+K68+K69","v":45},44,43,{"$f":"SUM(N67:N69)","v":42},{"$f":"SUM(O67:O69)","v":45},45,43.25,44,44]
["Percent",{"$f":"B65/B64","v":0.82222222222222219},0.77777777777777779,0.73333333333333328,0.82222222222222219,0.88888888888888884,0.97777777777777775,1,1,0.97777777777777775,1,0.97777777777777775,0.9555555555555556,0.93333333333333335,{"$f":"O65/O64","v":1},1,0.96111111111111114,0.97777777777777786,0.97777777777777786]
["2 Bedrooms",9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9]
["1 Bedroom",20,17,15,19,22,26,27,27,26,27,27,26,25,27,27,25.5,26.5,26.333333333333332]
["Studio",8,9,9,9,9,9,9,9,9,9,8,8,8,9,9,8.75,8.5,8.6666666666666661]

{"sheet":"worksheet","index":4,"n_rows":46,"n_cols":20,"rows_kept":46,"cut":false,"hidden":true,"merged":[[44,0,44,1],[45,4,45,5]]}
[]
[{"$nulls":6},"apr","may","jun","jul","aug","sep","oct","nov","dec","jan","feb","mar"]
[null,"Water Diff",{"$nulls":4},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,"Internet Diff",{"$nulls":4},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
["Internet",{"$nulls":5},"Apr","May","June","July","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar"]
["Cost",{"$nulls":5},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Cost less 500mbps",{"$nulls":5},{"$f":"(G10-50)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["# 100 mpbs users",{"$nulls":5},{"$f":"G11/30","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},30,31,32,32,32,32,{"$f":"R11/30","v":{"$error":"#REF!"}}]
["# 500 mbps users",{"$nulls":5},1,1,1,1,1,1,1,1,1,1,1,1]
["Income for 100mbps",{"$nulls":5},{"$f":"G12*59","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},1770,1829,1888,1888,1888,1888,{"$error":"#REF!"}]
["Income for 500 mbps",{"$nulls":5},79,79,79,79,79,79,79,79,79,79,79,79]
[null,"Total",{"$nulls":4},{"$f":"G14+G15","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},1849,1908,1967,1967,1967,1967,{"$error":"#REF!"}]
[]
[]
["Misc"]
["App",null,null,15.5,46.5,155,124,46.5,79,17,32.5,46.5,15.5,15.5,0,0,93.5,74.5]
["Late",null,365.8,150,375,225,225,575,600,300,660,596.12,488.88,722.63,642.37,700,670.56,709.44]
["Early Term",null,null,0,0,0,0,0,0,0,0,0,0,0,0,500,1545,0]
["Cleaning",null,0,900,297.38,0,75,0,500,1300,600,616.29,900,0,300,0,0,500]
["Total",null,{"$f":"SUM(C20:C23)","v":365.8},1065.5,718.88,380,424,621.5,1179,1617,1292.5,1258.9099999999999,1404.38,738.13,942.37,1200,2309.06,1283.94]
[]
[]
[]
[]
[{"$nulls":19},"12 month"]
[{"$nulls":18},"total",{"$f":"SUM(G24:R24)","v":14270.79}]
[null,null,"marketing","annual fire","supplies","lon exp",{"$nulls":12},"average",{"$f":"T30/12","v":1189.2325000000001}]
[null,"april"]
[null,"may"]
["lump pmt","june",1136.96,null,2201.9899999999998]
[null,"july"]
[null,"aug"]
[null,"sept"]
[null,"oct",null,2130]
[null,"nov",null,900,null,1938.08]
[null,"dec",null,null,null,56.18]
[null,"jan",null,750,null,162.5]
[null,"feb",null,null,null,269.88]
[null,"march"]
[null,"Total",{"$f":"SUM(C32:C43)","v":1136.96},3780,2201.9899999999998,2426.6400000000003]
["Normalized to Monthly",null,{"$f":"C44/12","v":94.74666666666667},315,183.49916666666664,202.22000000000003]
[{"$nulls":4},{"$f":"E45+F45","v":385.71916666666664}]

{"sheet":"Mar 26","index":5,"n_rows":53,"n_cols":22,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
["Beginning Balance",0,{"$nulls":7},"Rent"]
[{"$nulls":9},"Pet"]
["Income",null,null,"Total Inc",{"$f":"SUM(B4:B8)","v":82483},{"$nulls":4},"Late Fee"]
["Man Dep",3919,"from 3/3 dep"]
["Man Dep",180.66,{"$nulls":7},"Water"]
["Doorloop",78383.34,{"$nulls":7},"Electric"]
["Deposit Reconciliation",{"$nulls":8},"Internet"]
[{"$nulls":9},"Total"]
[]
["Expenses",null,null,"Total Exp",{"$f":"SUM(B11:B29)","v":-53151.79},{"$nulls":12},"Deposits","FHS","Man"]
["Admin",{"$nulls":16},902.5,null,null,null,53488.27]
["Debt",{"$nulls":17},1350,null,null,51048.19]
["Loan PMT",-35301.79,{"$nulls":15},1350]
[{"$nulls":11},"water",379.16,{"$nulls":5},1350]
["Utilities",{"$nulls":11},316.55,{"$nulls":4},5510]
["Internet",-1010,{"$nulls":10},301.97000000000003,{"$nulls":6},1740.09]
["Electricity",-4630,"21st",{"$nulls":9},{"$f":"SUM(M14:M16)","v":997.68000000000006},{"$nulls":5},1350]
["Waste Management",-681,{"$nulls":16},119.23]
["Water",-1456.5,"25th"]
[]
["Prop Management"]
["Lon Salary Feb",-6250,{"$nulls":9},"20,000 transferred to MWest on 10/17 for escrow deposit on Biggers Lane"]
["Lon Exp",{"$nulls":10},"To be paid back"]
[]
["MISC"]
["Insurance",-3821.5,"this expense hit in April (for ytd insurance)  do not count in april"]
["deposit return"]
["inspections"]
["Checkbook 1o/DL charge",-1]
[]
["Carry Over",{"$f":"SUM(B1:B29)","v":29331.21}]
[]
["Expenses less Loan PMT",{"$f":"E10-(B13)","v":-17850},null,"Profit",{"$f":"E3+E10","v":29331.21}]
["Expenses Ratio",{"$f":"ABS(B33)/E3","v":0.216408229574579}]
[]
["Disbursment"]
["Investor"]
["Jeff",{"$nulls":4},{"$f":"B31-B26","v":33152.71},"matches checking"]
["Josh",{"$nulls":4},"(without the insurance expense)"]
["Total"]
[]
["To be Reconciled Carryover",{"$f":"B31+B40","v":29331.21}]
[{"$nulls":6},"deposit from 3/3"]
[{"$nulls":6},6524.62]
[{"$nulls":6},2605.62,"applied to Feb as man dep"]
[{"$nulls":6},{"$f":"G44-G45","v":3919},"to hit in march as man dep"]
[]
[]
[]
[]
[null,75922.69]
[null,{"$f":"B51+G45","v":78528.31}]
[{"$nulls":4},{"$f":"B42-B52","v":-49197.1}]

{"sheet":"Feb 26","index":6,"n_rows":53,"n_cols":22,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
["Beginning Balance",0,{"$nulls":7},"Rent"]
[{"$nulls":9},"Pet"]
["Income",null,null,"Total Inc",{"$f":"SUM(B4:B8)","v":79912.14},{"$nulls":4},"Late Fee"]
["Man Dep",2605.62,"from 3/3 dep"]
["Man Dep",2499.67,{"$nulls":7},"Water"]
["Doorloop",74806.850000000006,{"$nulls":7},"Electric"]
["Deposit Reconciliation",{"$nulls":8},"Internet"]
[{"$nulls":9},"Total"]
[]
["Expenses",null,null,"Total Exp",{"$f":"SUM(B11:B29)","v":-50308.6},{"$nulls":12},"Deposits","FHS","Man"]
["Admin",{"$nulls":16},902.5,null,null,null,53488.27]
["Debt",{"$nulls":17},1350,null,null,51048.19]
["Loan PMT",-35301.79,{"$nulls":15},1350]
[{"$nulls":11},"water",379.16,{"$nulls":5},1350]
["Utilities",{"$nulls":11},316.55,{"$nulls":4},5510]
["Internet",-1040,{"$nulls":10},301.97000000000003,{"$nulls":6},1740.09]
["Electricity",-5095,"21st",{"$nulls":9},{"$f":"SUM(M14:M16)","v":997.68000000000006},{"$nulls":5},1350]
["Waste Management",-681,{"$nulls":16},119.23]
["Water",-1667.93,"25th"]
[]
["Prop Management"]
["Lon Salary Feb",-6250,{"$nulls":9},"20,000 transferred to MWest on 10/17 for escrow deposit on Biggers Lane"]
["Lon Exp",-269.88,{"$nulls":9},"To be paid back"]
[]
["MISC"]
["Insurance"]
["deposit return"]
["inspections"]
["Checkbook 1o/DL charge",-3]
[]
["Carry Over",{"$f":"SUM(B1:B29)","v":29603.539999999997}]
[]
["Expenses less Loan PMT",{"$f":"E10-(B13)","v":-15006.809999999998},null,"Profit",{"$f":"E3+E10","v":29603.54}]
["Expenses Ratio",{"$f":"ABS(B33)/E3","v":0.18779136686866349}]
[]
["Disbursment"]
["Investor"]
["Jeff"]
["Josh"]
["Total"]
[]
["To be Reconciled Carryover",{"$f":"B31+B40","v":29603.539999999997}]
[{"$nulls":6},"deposit from 3/3"]
[{"$nulls":6},6524.62]
[{"$nulls":6},2605.62,"applied to Feb as man dep"]
[{"$nulls":6},{"$f":"G44-G45","v":3919},"to hit in march as man dep"]
[]
[]
[]
[]
[null,75922.69]
[null,{"$f":"B51+G45","v":78528.31}]
[{"$nulls":4},{"$f":"B42-B52","v":-48924.770000000004}]

{"sheet":"January 26","index":7,"n_rows":43,"n_cols":22,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
["Beginning Balance",0,{"$nulls":7},"Rent"]
[{"$nulls":9},"Pet"]
["Income",null,null,"Total Inc",{"$f":"SUM(B4:B8)","v":69972.95},{"$nulls":4},"Late Fee"]
["Man Dep",1707.67]
["FHS",{"$nulls":8},"Water"]
["Doorloop",68265.279999999999,{"$nulls":7},"Electric"]
["Deposit Reconciliation",{"$nulls":8},"Internet"]
[{"$nulls":9},"Total"]
[]
["Expenses",null,null,"Total Exp",{"$f":"SUM(B11:B30)","v":-51048.19},{"$nulls":12},"Deposits","FHS","Man"]
["Admin",{"$nulls":16},902.5,null,null,null,53488.27]
["Debt",{"$nulls":17},1350,null,null,51048.19]
["Loan PMT",-35301.79,{"$nulls":15},1350]
[{"$nulls":11},"water",379.16,{"$nulls":5},1350]
["Utilities",{"$nulls":11},316.55,{"$nulls":4},5510]
["Internet",-1010,{"$nulls":10},301.97000000000003,{"$nulls":6},1740.09]
["Electricity",-4486,"21st",{"$nulls":9},{"$f":"SUM(M14:M16)","v":997.68000000000006},{"$nulls":5},1350]
["Waste Management",-628.85,{"$nulls":16},119.23]
["Water",-1710.11,"25th"]
[]
["Prop Management"]
["Lon Salary Feb",-5241.9399999999996,"Late PMT-hit in may",{"$nulls":8},"20,000 transferred to MWest on 10/17 for escrow deposit on Biggers Lane"]
["Lon Exp",-1662.5,"approved expenses + 1500 bonus",{"$nulls":8},"To be paid back"]
[]
["MISC"]
["Insurance"]
["Doorloop charge (investigating)",-25]
["deposit return"]
["inspections",-980]
["Checkbook 1o/DL charge",-2]
[]
["Carry Over",{"$f":"SUM(B1:B30)","v":18924.759999999998}]
[]
["Expenses less Loan PMT",{"$f":"E10-(B13)","v":-15746.400000000001},null,"Profit",{"$f":"E3+E10","v":18924.759999999995}]
["Expenses Ratio",{"$f":"ABS(B34)/E3","v":0.22503553158756351}]
[]
["Disbursment"]
["Investor",-35492.82]
["Jeff",-7542.22]
["Josh",-1330.98]
["Total",{"$f":"SUM(B38:B40)","v":-44366.020000000004}]
[]
["To be Reconciled Carryover",{"$f":"B32+B41","v":-25441.260000000006}]

{"sheet":"December 25","index":8,"n_rows":41,"n_cols":23,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
["Beginning Balance",0,{"$nulls":7},"Rent"]
[{"$nulls":9},"Pet"]
["Income",null,null,"Total Inc",{"$f":"SUM(B4:B8)","v":78230.69},{"$nulls":4},"Late Fee"]
["Man Dep",1687.21]
["FHS",{"$nulls":8},"Water",{"$nulls":12},{"$f":"E3+B27+B28","v":75790.61}]
["Doorloop",76543.48,{"$nulls":7},"Electric"]
["Deposit Reconciliation",{"$nulls":8},"Internet"]
[{"$nulls":9},"Total"]
[]
["Expenses",null,null,"Total Exp",{"$f":"SUM(B11:B30)","v":-79162.23},{"$nulls":12},"Deposits","FHS","Man"]
["Admin",{"$nulls":16},902.5]
["Debt",{"$nulls":17},1350]
["Loan PMT",-35301.79,{"$nulls":15},1350]
[{"$nulls":11},"water",379.16,{"$nulls":5},1350]
["Utilities",{"$nulls":11},316.55,{"$nulls":4},5510]
["Internet",-1010,{"$nulls":10},301.97000000000003,{"$nulls":6},1740.09]
["Electricity",-3653,"21st",{"$nulls":9},{"$f":"SUM(M14:M16)","v":997.68000000000006},{"$nulls":5},1350]
["Waste Management",-599.45000000000005,{"$nulls":16},119.23]
["Water",-1502.34,"25th"]
[]
["Prop Management"]
["Lon Salary Feb",-5833.33,"Late PMT-hit in may",{"$nulls":8},"20,000 transferred to MWest on 10/17 for escrow deposit on Biggers Lane"]
["Lon Exp",-56.18,"approved expenses",{"$nulls":8},"To be paid back"]
[]
["MISC"]
["Insurance"]
["Doorloop charge (investigating)",-1293.1400000000001,"returned check for double payment-swings with income"]
["deposit return",-1146.94,"accidental lon refund--should not have occurred.  Lon getting back, expect to swing."]
["Property Taxes (6 months)",-28764.06]
["Checkbook 1o/DL charge",-2]
[]
["Carry Over",{"$f":"SUM(B1:B30)","v":-931.5399999999936}]
[]
["Expenses less Loan PMT",{"$f":"E10-(B13)","v":-43860.439999999995},null,"Profit",{"$f":"E3+E10","v":-931.5399999999936}]
["Expenses Ratio",{"$f":"ABS(B34)/E3","v":0.560655159758913}]
[]
[]
["To be Reconciled Carryover",{"$f":"B32","v":-931.5399999999936}]
[]
[]
[null,"as of 12.18"]

{"sheet":"November","index":9,"n_rows":40,"n_cols":20,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["Beginning Balance",0]
[{"$nulls":9},"Income"]
["Income",null,null,"Total Inc",{"$f":"SUM(B4:B8)","v":68710.77},{"$nulls":4},"Rent"]
["Man Dep",1931.31,{"$nulls":7},"Pet"]
["FHS",340.58,{"$nulls":7},"Late Fee"]
["Doorloop",66438.880000000005]
["Deposit Reconciliation",{"$nulls":8},"Water"]
[{"$nulls":9},"Electric"]
[{"$nulls":9},"Internet"]
["Expenses",null,null,"Total Exp",{"$f":"SUM(B11:B30)","v":-48237.64},{"$nulls":4},"Total"]
["Admin"]
["Debt",{"$nulls":16},"Deposits","FHS","Man"]
["Loan PMT",-35301.79,{"$nulls":15},902.5]
[{"$nulls":18},1350]
["Utilities",{"$nulls":16},1350]
["Internet",-1010,{"$nulls":9},"water",446.99,{"$nulls":5},1350]
["Electricity",-2495,"21st",{"$nulls":9},405.83,{"$nulls":4},5510]
["Waste Management",-790.88,{"$nulls":10},525.45000000000005,{"$nulls":6},1740.09]
["Water",-1723.8,"25th",{"$nulls":15},1350]
[{"$nulls":18},119.23]
["Prop Management"]
["Lon Salary Feb",-4076.09,"unpaid time off--reviewed with Lon"]
["Lon Exp",-1938.08,"approved expenses"]
[{"$nulls":11},"20,000 transferred to MWest on 10/17 for escrow deposit on Biggers Lane"]
["MISC",{"$nulls":10},"To be paid back"]
["Insurance"]
["Fire inspection",-900]
["deposit return"]
["WestEntry Cleaning",0]
["Checkbook 1o/DL charge",-2]
[]
["Carry Over",{"$f":"SUM(B1:B30)","v":20473.130000000005}]
[]
["Expenses less Loan PMT",{"$f":"E10-(B13)","v":-12935.849999999999},null,"Profit",{"$f":"E3+E10","v":20473.130000000005}]
["Expenses Ratio",{"$f":"ABS(B34)/E3","v":0.18826524575404988}]
[]
["Add in"]
[]
[]
["To be Reconciled Carryover",{"$f":"B32+B38","v":20473.130000000005}]

{"sheet":"October","index":10,"n_rows":42,"n_cols":20,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["Beginning Balance",0]
[{"$nulls":9},"Income"]
["Income",null,null,"Total Inc",{"$f":"SUM(B4:B8)","v":74667.460000000006},{"$nulls":4},"Rent"]
["Man Dep",4868.17,{"$nulls":7},"Pet"]
["FHS",{"$nulls":8},"Late Fee"]
["Doorloop",69799.290000000008]
["Deposit Reconciliation"]
[{"$nulls":9},"Water"]
[{"$nulls":9},"Electric"]
["Expenses",null,null,"Total Exp",{"$f":"SUM(B11:B31)","v":-49843.03},{"$nulls":4},"Internet"]
["Admin",{"$nulls":8},"Total"]
["Debt"]
["Loan PMT",-35301.79,{"$nulls":15},"Deposits","FHS","Man"]
[{"$nulls":17},902.5]
["Utilities",{"$nulls":17},1350]
["Internet",-980,{"$nulls":15},1350]
["Electricity",-2085,"21st",{"$nulls":8},"water",446.99,{"$nulls":5},1350]
["Waste Management",-628.85,{"$nulls":10},405.83,{"$nulls":4},5510]
["Water",-1409.48,"25th",{"$nulls":9},525.45000000000005,{"$nulls":6},1740.09]
[{"$nulls":18},1350]
["Prop Management",{"$nulls":17},119.23]
["Lon Salary Feb",-4727.2700000000004,"Kenneth covered 9/11-13 and 9/27-30 (7 days)"]
["Lon Exp",null,"approved expenses"]
[]
["MISC"]
["Insurance",{"$nulls":10},"20,000 transferred to MWest on 10/17 for escrow deposit on Biggers Lane"]
["Fire inspection",-2205]
["deposit return",{"$nulls":10},"To be paid back"]
["WestEntry Cleaning",-2500]
["Banking charge",-2.64]
["Checkbook 1o/DL charge",-3]
[]
["Carry Over",{"$f":"SUM(B1:B31)","v":24824.430000000004}]
[]
["Expenses less Loan PMT",{"$f":"E10-(B13)","v":-14541.239999999998},null,"Profit",{"$f":"E3+E10","v":24824.430000000008}]
["Expenses Ratio",{"$f":"ABS(B35)/E3","v":0.19474668081651628}]
[]
["Add in"]
["Investor Distribution",-72847.87]
["MWest Distribution",-15480.17]
[null,-2731.8]
["To be Reconciled Carryover",{"$f":"B33+B39+B40+B41","v":-66235.409999999989}]

{"sheet":"September","index":11,"n_rows":42,"n_cols":30,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["Beginning Balance",0,{"$nulls":5},"last audit",{"$nulls":14},"9.11.25"]
[{"$nulls":9},"Income"]
["Income",null,null,"Total Inc",{"$f":"SUM(B4:B7)","v":82034.37},{"$nulls":4},"Rent"]
["Man Dep",5436.26,{"$nulls":7},"Pet",null,null,null,"Inc/Unit"]
["FHS",4142.88,{"$nulls":7},"Late Fee",null,null,null,{"$f":"K10/41","v":0}]
["Doorloop",72455.23,{"$nulls":27},1383.38]
[{"$nulls":9},"Water",null,null,null,"Exp/Unit",{"$nulls":15},1370.07]
[{"$nulls":9},"Electric",null,null,null,{"$f":"(35*41)+1600","v":3035},{"$nulls":15},1389.43]
[{"$nulls":9},"Internet",null,null,null,{"$f":"N8/41","v":74.024390243902445},{"$nulls":15},{"$f":"SUM(AD6:AD8)","v":4142.88}]
["Expenses",null,null,"Total Exp",{"$f":"SUM(B11:B30)","v":-52072.01},{"$nulls":4},"Total"]
["Admin",{"$nulls":12},{"$f":"N5-N9","v":-74.024390243902445}]
["Debt",{"$nulls":16},"Deposits","FHS","Man"]
["Loan PMT",-35301.79,{"$nulls":15},902.5]
[{"$nulls":18},1350]
["Utilities",{"$nulls":10},"Escrow",28000,{"$nulls":4},1350,{"$nulls":8},"West Entry cleaning of $2975 was reimbursed by FHS on 10/6"]
["Internet",-1324,{"$nulls":9},"Landscaping",25950,{"$nulls":5},1350,{"$nulls":7},"Still have June-Aug outstanding."]
["Electricity",-2227,"21st",{"$nulls":8},"Income",{"$f":"M15-M16","v":2050},{"$nulls":4},5510]
["Waste Management",-628.85,{"$nulls":17},1740.09]
["Water",-1346.15,"25th",{"$nulls":15},1350]
[{"$nulls":18},119.23]
["Prop Management"]
["Lon Salary Feb",-6250,"checkbook io"]
["Lon Exp"]
[{"$nulls":14},126.64]
["MISC"]
["Insurance",-3458.22,"Reconciled 9.11 with Mwest for July-Sept insurance"]
["deposit return",-1134,"Zoe Jacobson"]
["WestEntry Cleaning"]
["Camera Repair",-400]
["Checkbook 1o/DL charge",-2]
[]
["Carry Over",{"$f":"SUM(B1:B30)","v":29962.359999999993},{"$nulls":5},105671.32,null,{"$f":"B32-H32","v":-75708.960000000021}]
[]
["Expenses less Loan PMT",{"$f":"E10-(B13)","v":-16770.22},null,"Profit",{"$f":"E3+E10","v":29962.359999999993}]
["Expenses Ratio",{"$f":"ABS(B34)/E3","v":0.20442919230073933}]
[]
[]
[]
[{"$nulls":6},"Real Balance on 9/30 is",{"$nulls":15},118084.85]
[{"$nulls":6},"Difference of",{"$nulls":15},{"$f":"B32-W39","v":-88122.49000000002}]
[]
[{"$nulls":6},"This is a was from the charge on 9/3 with the deposit from FHS on 10/6.  Do not count 10/6s deposit as October income. (STR cleaning paid by FHS)"]

{"sheet":"August","index":12,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["Beginning Balance",0]
[]
["Income",null,null,"Total Inc",{"$f":"SUM(B4:B8)","v":77286.170000000013}]
["Man Dep",3242.73]
["FHS",4138.7]
["Doorloop",69904.740000000005]
["Vacasa Income"]
[]
[]
["Expenses",null,null,"Total Exp",{"$f":"SUM(B11:B29)","v":-50599.839999999997}]
["Admin"]
["Debt"]
["Loan PMT",-35301.79]
[]
["Utilities"]
["Internet",-920]
["Electricity",-2105,"21st"]
["Waste Management",-628.85]
["Water",-1393.2,"25th"]
[]
["Prop Management"]
["Lon Salary Feb",-6250,"checkbook io"]
["Lon Exp"]
[]
["MISC"]
["Insurance"]
["deposit return",-1499,"Norris"]
["WestEntry Cleaning",-2500,"to be reconciled in Sept-FHS"]
["Checkbook 1o/DL charge",-2]
[]
["Carry Over",{"$f":"SUM(B1:B29)","v":26686.330000000016}]
[]
["Expenses less Loan PMT",{"$f":"E10-(B13)","v":-15298.049999999996},null,"Profit",{"$f":"E3+E10","v":26686.330000000016}]
["Expenses Ratio",{"$f":"ABS(B33)/E3","v":0.19794033007457859}]
[]
["Reconciliation Dep Acct",-5973.21]
[]
["True Carryover",{"$f":"B31+B36","v":20713.120000000017}]

{"sheet":"July","index":13,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["Beginning Balance",{"$f":"June!#REF!","v":{"$error":"#REF!"}}]
[]
["Income",null,null,"Total Inc",{"$f":"SUM(B4:B8)","v":79980.36}]
["Man Dep",5016.99]
["FHS",4067.99,"PMT made 8.4"]
["Doorloop",70895.38]
["Deposit Reconciliation"]
[]
[]
["Expenses",null,null,"Total Exp",{"$f":"SUM(B11:B29)","v":-50326.74}]
["Admin"]
["Debt"]
["Loan PMT",-35301.79]
[]
["Utilities"]
["Internet",-950]
["Electricity",-1991]
["Waste Management",-628.85]
["Water",-1400.53]
[]
["Prop Management"]
["Lon Salary Feb",-6250]
["Lon Exp"]
[]
["MISC"]
["Property Tax",-1433.25]
["deposit return",-368.32]
["WestEntry Cleaning",-2000]
["Checkbook 1o/DL charge",-3]
[]
[]
["Expenses less Loan PMT",{"$f":"E10-(B13)","v":-15024.949999999997},null,"Profit",{"$f":"E3+E10","v":29653.620000000003}]
["Expenses Ratio",{"$f":"ABS(B32)/E3","v":0.18785799413756074}]

{"sheet":"June","index":14,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["Beginning Balance",{"$f":"May!B31","v":40497.260000000009}]
[]
["Income",null,null,"Total Inc",{"$f":"SUM(B4:B8)","v":69292.26999999999}]
["Man Dep",3868.87]
["FHS",4040.95]
["Doorloop",61382.45]
["Mwest Reconciliation"]
[]
[]
["Expenses",null,null,"Total Exp",{"$f":"SUM(B11:B29)","v":-49449.38}]
["Admin"]
["Debt"]
["Loan PMT",-35301.79]
[]
["Utilities"]
["Internet",-980]
["Electricity",-1869]
["Waste Management",-628.85]
["Water",-1130.3399999999999]
[]
["Prop Management"]
["Lon Salary Feb",-5600]
["Lon Exp"]
[]
["MISC"]
["Marketing (last 6 months)",-1136.96]
["deposit return",-2273.84]
["WestEntry Cleaning",-524.25]
["Checkbook 1o/DL charge",-4.3499999999999996]
[]
["Carry Over",{"$f":"SUM(B1:B29)","v":60340.149999999987}]
[]
["Expenses less Loan PMT",{"$f":"E10-(B13)","v":-14147.589999999997},null,"Profit",{"$f":"E3+E10","v":19842.889999999992}]
["Expenses Ratio",{"$f":"ABS(B33)/E3","v":0.20417270209216698}]

{"sheet":"May","index":15,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["Beginning Balance",{"$f":"Apr!B29","v":16543.259999999998}]
[]
["Income",null,null,"Total Inc",{"$f":"SUM(B4:B7)","v":72102.84}]
["Man Dep",5337.21]
["FHS",4092.01]
["Doorloop",62673.62]
["Deposit Reconciliation"]
["Reserve Balance PMT"]
[]
["Expenses",null,null,"Total Exp",{"$f":"SUM(B11:B29)","v":-48148.84}]
["Admin"]
["Debt"]
["Loan PMT",-35301.79]
[]
["Utilities"]
["Internet",-950,{"$nulls":7},"April","May"]
["Electricity",-2727,{"$nulls":7},1359.64,1356.72]
["Waste Management",-628.85,{"$nulls":7},1372.71,1364.39]
["Water",-972.1,{"$nulls":7},1379.66,1370.9]
[{"$nulls":9},{"$f":"SUM(J17:J19)","v":4112.01},4092.01]
["Prop Management"]
["Lon Salary Feb",-6250]
["Lon Exp"]
[]
["MISC"]
["Insurance"]
["deposit return",-1318.1]
["WestEntry Cleaning",0]
["Checkbook 1o/DL charge",-1]
[]
["Carry Over",{"$f":"SUM(B1:B29)","v":40497.260000000009}]
[]
["Expenses less Loan PMT",{"$f":"E10-(B13)","v":-12847.049999999996},null,"Profit",{"$f":"E3+E10","v":23954},{"$nulls":5},{"$f":"L33","v":0}]
["Expenses Ratio",{"$f":"ABS(B33)/E3","v":0.17817675420274703}]

{"sheet":"Apr","index":16,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Income",null,null,"Total Inc",{"$f":"SUM(B2:B6)","v":64789.909999999996}]
["Man Dep",4784.63]
["FHS",4112.01]
["Doorloop",55893.27]
["Deposit Reconciliation"]
[]
[]
["Expenses",null,null,"Total Exp",{"$f":"SUM(B9:B27)","v":-48246.65}]
["Admin"]
["Debt"]
["Loan PMT",-35301.79]
[]
["Utilities"]
["Internet",-890,{"$nulls":7},"April","May"]
["Electricity",-2829,{"$nulls":7},1359.64,1356.72]
["Waste Management",-628.85,{"$nulls":7},1372.71,1364.39]
["Water",-939.01,{"$nulls":7},1379.66,1370.9]
[{"$nulls":9},{"$f":"SUM(J15:J17)","v":4112.01},4092.01]
["Prop Management"]
["Lon Salary Feb",-6250]
["Lon Exp"]
[]
["MISC"]
["Insurance"]
["deposit return",-1405]
["WestEntry Cleaning",0]
["Checkbook 1o/DL charge",-3]
[]
["Carry Over",{"$f":"SUM(B1:B27)","v":16543.259999999998}]
[]
["Expenses less Loan PMT",{"$f":"E8-(B11)","v":-12944.86},null,"Profit",{"$f":"E1+E8","v":16543.259999999995}]
["Expenses Ratio",{"$f":"ABS(B31)/E1","v":0.19979746846383953}]

{"sheet":"March","index":17,"n_rows":33,"n_cols":25,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["Income",null,null,"Total Inc",{"$f":"SUM(B2:B6)","v":70203.58},{"$nulls":4},"Rent"]
["Man Dep",3961.34,{"$nulls":7},"Pet"]
["FHS",4179.54,{"$nulls":7},"Late Fee"]
["Doorloop",62062.7]
["Deposit Reconciliation"]
[{"$nulls":9},"Water"]
[{"$nulls":9},"Electric"]
["Expenses",null,null,"Total Exp",{"$f":"SUM(B9:B28)","v":-55965.85},{"$nulls":4},"Internet"]
["Admin",{"$nulls":8},"Total"]
["Debt"]
["Loan PMT",-35301.79,{"$nulls":15},"Deposits","FHS","Man"]
[{"$nulls":17},902.5]
["Utilities",{"$nulls":17},1350]
["Internet",-770,{"$nulls":15},1350]
["Electricity",-3832,"21st",{"$nulls":8},"water",379.16,{"$nulls":5},1350]
["Waste Management",-628.85,{"$nulls":10},316.55,{"$nulls":4},5510]
["Water",-948.88,"25th",{"$nulls":9},301.97000000000003,{"$nulls":6},1740.09]
[{"$nulls":12},{"$f":"SUM(M15:M17)","v":997.68000000000006},{"$nulls":5},1350]
["Prop Management",{"$nulls":17},119.23,{"$nulls":5},296.95]
["Lon Salary Feb",-6250,{"$nulls":22},309.13]
["Lon Exp",{"$nulls":23},342.8]
[]
["MISC"]
["Insurance",-5009.33]
["Reconciliation with MWest"]
["Snow Plow & Clearing",-3135]
["WestEntry Cleaning",-90]
["Checkbook 1o/DL charge"]
[]
["Carry Over",{"$f":"SUM(B1:B28)","v":14237.730000000003}]
[]
["Expenses less Loan PMT",{"$f":"E8-(B11)","v":-20664.059999999998},null,"Profit",{"$f":"E1+E8","v":14237.730000000003}]
["Expenses Ratio",{"$f":"ABS(B32)/E1","v":0.29434481831268428},{"$nulls":9},"20,000 transferred to MWest on 10/17 for escrow deposit on Biggers Lane"]

{"sheet":"Feb","index":18,"n_rows":30,"n_cols":20,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["Income",null,null,"Total Inc",{"$f":"SUM(B2:B5)","v":58105.35},{"$nulls":4},"Rent"]
["Man Dep",3913.18,{"$nulls":7},"Pet"]
["FHS",4180.8100000000004,{"$nulls":7},"Late Fee"]
["Doorloop",50011.360000000001]
[{"$nulls":9},"Water"]
[{"$nulls":9},"Electric"]
["Expenses",null,null,"Total Exp",{"$f":"SUM(B8:B26)","v":-48938.67},{"$nulls":4},"Internet"]
["Admin",{"$nulls":8},"Total"]
["Debt"]
["Loan PMT",-35301.79,{"$nulls":15},"Deposits","FHS","Man"]
[{"$nulls":17},902.5]
["Utilities",{"$nulls":17},1350]
["Internet",-830,{"$nulls":15},1350]
["Electricity",-4457,"21st",{"$nulls":8},"water",379.16,{"$nulls":5},1350]
["Waste Management",-628.85,{"$nulls":10},316.55,{"$nulls":4},5510]
["Water",-1094.03,"25th",{"$nulls":9},301.97000000000003,{"$nulls":6},1740.09]
[{"$nulls":12},{"$f":"SUM(M14:M16)","v":997.68000000000006},{"$nulls":5},1350]
["Prop Management",{"$nulls":17},119.23]
["Lon Salary (Sept)",-6250]
[]
["MISC"]
["Returned Deposits"]
["Reconciliation with MWest"]
["Snow Plow",-375]
["WestEntry Cleaning"]
["Checkbook 1o/DL charge",-2]
[]
[]
["Expenses less Loan PMT",{"$f":"E7-(B10)","v":-13636.879999999997},null,"Profit",{"$f":"E1+E7","v":9166.68}]
["Expenses Ratio",{"$f":"ABS(B29)/E1","v":0.23469233039642645},{"$nulls":9},"20,000 transferred to MWest on 10/17 for escrow deposit on Biggers Lane"]

{"sheet":"Jan","index":19,"n_rows":32,"n_cols":25,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Beginning Balance",167355.21]
[{"$nulls":9},"Income"]
["Income",null,null,"Total Inc",{"$f":"SUM(B4:B7)","v":67032.19},{"$nulls":4},"Rent"]
["Man Dep",3800.1,{"$nulls":7},"Pet"]
["FHS",4157.79,{"$nulls":7},"Late Fee"]
["Doorloop",59074.3]
[{"$nulls":9},"Water"]
[{"$nulls":9},"Electric"]
["Expenses",null,null,"Total Exp",{"$f":"SUM(B10:B28)","v":-49077.86},{"$nulls":4},"Internet"]
["Admin",{"$nulls":8},"Total"]
["Debt"]
["Loan PMT",-35301.79,{"$nulls":15},"Deposits","FHS","Man"]
[{"$nulls":17},902.5]
["Utilities",{"$nulls":17},1350]
["Internet",-860,{"$nulls":15},1350]
["Electricity",-3845,{"$nulls":9},"water",379.16,{"$nulls":5},1350,{"$nulls":5},{"$f":"SUM(B12:B28)+SUM(#REF!)","v":{"$error":"#REF!"}}]
["Waste Management",-580.95000000000005,{"$nulls":10},316.55,{"$nulls":4},5510]
["Water",-2187.59,{"$nulls":10},301.97000000000003,{"$nulls":6},1740.09]
[{"$nulls":12},{"$f":"SUM(M16:M18)","v":997.68000000000006},{"$nulls":5},1350]
["Prop Management",{"$nulls":17},119.23]
["Lon Salary (Sept)",-4687.5]
["Lon Exp",-155.03]
[]
["MISC"]
["Elite Fire Protection Inspection",-900]
["Snow Plow",-375]
["WestEntry Cleaning",-180]
["Checkbook 1o/DL charge",-5]
[]
[{"$nulls":20},-34440.129999999997]
["Expenses less Loan PMT",{"$f":"E9-(B12)","v":-13776.07},null,"Profit",{"$f":"E3+E9","v":17954.330000000002},{"$nulls":15},{"$f":"ABS(U30/#REF!)","v":{"$error":"#REF!"}}]
["Expenses Ratio",{"$f":"ABS(B31)/E3","v":0.20551424621513931},{"$nulls":9},"20,000 transferred to MWest on 10/17 for escrow deposit on Biggers Lane"]

{"sheet":"December","index":20,"n_rows":34,"n_cols":20,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["Income",null,null,"Total Inc",{"$f":"SUM(B2:B5)","v":64484.89},{"$nulls":4},"Rent"]
["Man Dep",3893.61,{"$nulls":7},"Pet"]
["FHS",4162.93,{"$nulls":7},"Late Fee"]
["Doorloop",56428.35]
[{"$nulls":9},"Water"]
[{"$nulls":9},"Electric"]
["Expenses",null,null,"Total Exp",{"$f":"SUM(B8:B28)","v":-46199.89},{"$nulls":4},"Internet"]
["Admin",{"$nulls":8},"Total"]
["Debt"]
["Loan PMT",-35301.79,{"$nulls":15},"Deposits","FHS","Man"]
[{"$nulls":17},902.5]
["Utilities",{"$nulls":17},1350]
["Internet",-890,{"$nulls":15},1350]
["Electricity",-3330,"21st",{"$nulls":8},"water",379.16,{"$nulls":5},1350]
["Waste Management",-580.95000000000005,{"$nulls":10},316.55,{"$nulls":4},5510]
["Water",0,"25th",{"$nulls":9},301.97000000000003,{"$nulls":6},1740.09]
[{"$nulls":12},{"$f":"SUM(M14:M16)","v":997.68000000000006},{"$nulls":5},1350]
["Prop Management",{"$nulls":17},119.23]
["Lon Salary (Sept)",-5600]
["Lon Exp",-345.15]
[]
["Cap Imp",{"$nulls":10},"20,000 transferred to MWest on 10/17 for escrow deposit on Biggers Lane"]
[{"$nulls":11},"To be paid back"]
["MISC"]
["Deposit Return",0]
["Snow Plow",-125]
["WestEntry Cleaning",0]
["Checkbook 1o/DL charge",-27]
[]
[null,null,null,"Profit",{"$f":"E1+E7","v":18285}]
[]
[]
["Expenses less Loan PMT",{"$f":"E7-(B10+B25)","v":-10898.099999999999}]
["Expenses Ratio",{"$f":"ABS(B33)/E1","v":0.16900238179827862}]