{"text_format":"2","workbook":"xlsx","n_sheets":15,"sheets":["Summary","Rental Income Breakdown","worksheet","November","October","September","August","July","June","May","Apr","March","Feb","Jan","December"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"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":"Summary","index":0,"n_rows":58,"n_cols":21,"rows_kept":58,"cut":false,"hidden":false,"merged":[[26,17,26,20],[40,17,40,20],[1,17,1,20],[17,17,17,20]]}
["Rolling 12-Kalispell Lofts"]
[null,"2024-12-01","2025-01-01","2025-02-01","2025-03-01","2025-04-01","2025-05-01","2025-06-01","2025-07-01","2025-08-25","2025-09-25","2025-10-25","2025-11-25","2025-12-25","Average/month",null,null,"Buyer Pro-Forma"]
["Total Rental Income",{"$f":"December!E1","v":64484.89},{"$f":"Jan!E3","v":67032.19},{"$f":"Feb!E1","v":58105.35},{"$f":"March!E1","v":70203.58},{"$f":"Apr!E1","v":64789.909999999996},{"$f":"May!E3","v":72102.84},{"$f":"June!E3","v":69292.26999999999},{"$f":"July!E3","v":79980.36},{"$f":"August!E3","v":77286.170000000013},{"$f":"September!E3","v":82034.37},{"$f":"October!E3","v":74667.460000000006},{"$f":"November!E3","v":68710.77},75790.61,{"$f":"AVERAGE(C3:N4)","v":71666.323333333334},null,null,"Income","T3","T6","T12"]
[{"$nulls":17},"Rents + Other Income",{"$f":"C45*12","v":876675.3600000001},{"$f":"C37*12","v":916939.48},{"$f":"C29*12","v":859995.88}]
["Expenses"]
["Internet",890,860,830,770,890,950,980,950,920,1324,980,1010,1010,{"$f":"AVERAGE(C6:N6)","v":956.16666666666663},null,null,"Total Income",{"$f":"SUM(S4:S6)","v":876675.3600000001},{"$f":"SUM(T4:T6)","v":916939.48},{"$f":"SUM(U4:U6)","v":859995.88}]
["Electricity",3330,3845,4457,3832,2829,2727,1869,1991,2105,2227,2085,2495,3653,{"$f":"AVERAGE(C7:N7)","v":2842.9166666666665},null,null,"Occupancy",{"$f":"T55","v":0.97777777777777786},{"$f":"S55","v":0.98518518518518527},{"$f":"R55","v":0.91111111111111109}]
["Garbage",628.85,628.85,628.85,628.85,628.85,628.85,628.85,628.85,628.85,628.85,628.85,790.88,599.45000000000005,639.90250000000003,null,null,"Gross Income",{"$f":"S6","v":876675.3600000001},{"$f":"T6","v":916939.48},{"$f":"U6","v":859995.88}]
["Water",1093.7950000000001,1093.7950000000001,1094.03,948.88,939.01,972.1,1130.3399999999999,1400.53,1393.2,1346.15,1409.48,1723.8,1502.34,1246.1379166666666,null,null,"Expenses"]
["Prop Management",5945.15,4842.53,6250,6250,6250,6250,5600,6250,6250,6250,4727.2700000000004,4076.09,5833.33,5735.7683333333334,null,null,"Operating Expenses",{"$f":"C46*12","v":155697.79999999999},{"$f":"C38*12","v":159158.84499999997},{"$f":"C30*12","v":166420.29250000001}]
["Insurance",1151.9116666666669,1151.9116666666669,1151.9116666666669,1151.9116666666669,1151.9116666666669,1151.9116666666669,1151.9116666666669,1151.9116666666669,1151.9116666666669,1151.9116666666669,1151.9116666666669,1151.9116666666669,1151.9100000000001,1151.911527777778,null,null,"Property Tax Adjustment",{"$f":"S25*12","v":51497.64},{"$f":"S11","v":51497.64},{"$f":"T11","v":51497.64}]
["Marketing (normalized)",{"$f":"worksheet!$C$44","v":94.74666666666667},{"$f":"worksheet!$C$44","v":94.74666666666667},{"$f":"worksheet!$C$44","v":94.74666666666667},{"$f":"worksheet!$C$44","v":94.74666666666667},{"$f":"worksheet!$C$44","v":94.74666666666667},{"$f":"worksheet!$C$44","v":94.74666666666667},{"$f":"worksheet!$C$44","v":94.74666666666667},{"$f":"worksheet!$C$44","v":94.74666666666667},{"$f":"worksheet!$C$44","v":94.74666666666667},{"$f":"worksheet!$C$44","v":94.74666666666667},{"$f":"worksheet!$C$44","v":94.74666666666667},{"$f":"worksheet!$C$44","v":94.74666666666667},94.74666666666667,94.74666666666667,null,null,"Cap Ex Adjustment @ 2%",{"$f":"S8*0.02","v":17533.507200000004},{"$f":"T8*0.02","v":18338.7896},{"$f":"U8*0.02","v":17199.917600000001}]
["Property Tax (normalized)",234.66833333333301,234.66833333333301,234.66833333333301,234.66833333333301,234.66833333333301,234.66833333333301,234.66833333333301,234.66833333333301,234.66833333333301,234.66833333333301,234.66833333333301,234.66833333333301,234.66833333333301,234.66833333333304,null,null,"Management Adjustment @ 3%",{"$f":"S8*0.03","v":26300.260800000004},{"$f":"T8*0.03","v":27508.184399999998},{"$f":"U8*0.03","v":25799.876399999997}]
["Snow Plow",125,375,375,3135,0,0,0,0,0,0,0,0,0,323.75,null,null,"Total Expenses Adjusted",{"$f":"S10+S11+S12+S13","v":251029.20799999998},{"$f":"T10+T11+T12+T13","v":256503.45899999997},{"$f":"U10+U11+U12+U13","v":260917.72649999999}]
["Annual Fire Inspections (normalized)",{"$f":"worksheet!$D$44","v":252.5},{"$f":"worksheet!$D$44","v":252.5},{"$f":"worksheet!$D$44","v":252.5},{"$f":"worksheet!$D$44","v":252.5},{"$f":"worksheet!$D$44","v":252.5},{"$f":"worksheet!$D$44","v":252.5},{"$f":"worksheet!$D$44","v":252.5},{"$f":"worksheet!$D$44","v":252.5},{"$f":"worksheet!$D$44","v":252.5},{"$f":"worksheet!$D$44","v":252.5},{"$f":"worksheet!$D$44","v":252.5},{"$f":"worksheet!$D$44","v":252.5},315,257.70833333333331,null,null,"% of Gross",{"$f":"S14/S8","v":0.28634226471244723},{"$f":"T14/T8","v":0.27973870096639308},{"$f":"U14/U8","v":0.30339415870224867}]
["Misc Expenses/supplies (normalized)",{"$f":"worksheet!$E$45","v":386.68749999999994},{"$f":"worksheet!$E$45","v":386.68749999999994},{"$f":"worksheet!$E$45","v":386.68749999999994},{"$f":"worksheet!$E$45","v":386.68749999999994},{"$f":"worksheet!$E$45","v":386.68749999999994},{"$f":"worksheet!$E$45","v":386.68749999999994},{"$f":"worksheet!$E$45","v":386.68749999999994},{"$f":"worksheet!$E$45","v":386.68749999999994},{"$f":"worksheet!$E$45","v":386.68749999999994},{"$f":"worksheet!$E$45","v":386.68749999999994},{"$f":"worksheet!$E$45","v":386.68749999999994},{"$f":"worksheet!$E$45","v":386.68749999999994},362.60666666666663,384.68076388888881,null,null,"Net Income",{"$f":"S8-S14","v":625646.15200000012},{"$f":"T8-T14","v":660436.02099999995},{"$f":"U8-U14","v":599078.15350000001}]
["Total Expenses",{"$f":"SUM(B6:B16)","v":14133.309166666666},13765.689166666665,15755.394166666667,17685.244166666664,13657.374166666666,13648.464166666667,12328.704166666665,13340.894166666667,13417.564166666665,13896.514166666666,{"$f":"SUM(L6:L16)","v":11951.114166666666},{"$f":"SUM(M6:M16)","v":12216.284166666666},{"$f":"SUM(N6:N16)","v":14757.051666666664},13868.357708333335,null,null,"Cash Flow Before Taxes",{"$f":"S16","v":625646.15200000012},{"$f":"T16","v":660436.02099999995},599078.15350000001]
[{"$nulls":17},"Asking Price - Cap Rate Summary"]
["Expenses W Tax Adjustment",{"$f":"S25+B17","v":18424.779166666667},{"$f":"C17+$S$25","v":18057.159166666665},20046.864166666666,21976.714166666665,17948.844166666666,17939.934166666666,16620.174166666664,17632.364166666666,17709.034166666665,18187.984166666665,16242.584166666667,16507.754166666666,19048.521666666664,{"$f":"AVERAGE(B19:M19)","v":18107.849166666667},null,null,10450000,{"$f":"S17/R19","v":5.9870445167464127E-2},{"$f":"T17/R19","v":6.319961923444975E-2},{"$f":"U17/R19","v":5.7328052966507177E-2}]
[]
["Expense Ratio",{"$f":"B19/B3","v":0.28572242531028069},{"$f":"C19/C3","v":0.2693804150911176},0.34500892201263167,0.3130426420798863,0.27703147244172227,0.24881036817227542,0.23985610756678438,0.22045867468796923,0.22913587471945707,0.22171175528826109,0.21753229809433275,0.24024987882782661,0.25133091465200413,{"$f":"AVERAGE(C21:N21)","v":0.25612911030285573},null,null,"Tax Adjustments","Totals"]
[{"$nulls":17},"2025 Tax",{"$f":"SUM(B13:M13)","v":2816.0199999999963}]
["Monthly Profit",{"$f":"B3-B17","v":50351.580833333333},53266.500833333339,42349.955833333333,52518.335833333338,51132.535833333328,58454.375833333332,56963.565833333327,66639.465833333335,63868.605833333349,68137.855833333335,62716.34583333334,56494.48583333334,21440.296666666669,{"$f":"AVERAGE(B23:M23)","v":56907.800833333335},null,null,"2026 Tax",{"$f":"27156.83*2","v":54313.66}]
[{"$nulls":17},"Difference",{"$f":"S23-S22","v":51497.640000000007}]
[{"$nulls":17},"Normalized",{"$f":"S24/12","v":4291.47}]
[]
[{"$nulls":17},"Debt Quotes - Income Breakdown T6"]
["Rolling 12 ","Totals","Monthly Ave","Annualized",{"$nulls":13},"Feature","Option 1","Option 2","Option 3"]
["Total Income (Dec '24 - Nov '25)",{"$f":"SUM(C3:N3)","v":859995.88},{"$f":"B29/12","v":71666.323333333334},{"$f":"C29*12","v":859995.88},{"$nulls":13},"Purchase Price",10450000,{"$f":"S29","v":10450000},{"$f":"T29","v":10450000}]
["Total Exp",{"$f":"SUM(C17:N17)","v":166420.29250000001},{"$f":"B30/12","v":13868.357708333335},{"$f":"C30*12","v":166420.29250000001},{"$nulls":13},"Down Payment - 35%",{"$f":"S29*0.35","v":3657500},{"$f":"T29*0.35","v":3657500},3657500]
["Total Exp + Tax Adjustment",{"$f":"B30+S24","v":217917.93250000002},{"$f":"B31/12","v":18159.827708333334},217917.9325,{"$nulls":13},"Loan Amount",{"$f":"S29-S30","v":6792500},{"$f":"T29-T30","v":6792500},6792500]
["Adjusted Exp Ratio",{"$f":"B31/B29","v":0.25339415870224868},{"$f":"B32","v":0.25339415870224868},{"$f":"D31/D29","v":0.25339415870224868},{"$nulls":13},"Loan Term",5,7,10]
["Total Profit",{"$f":"B29-B31","v":642077.94750000001},{"$f":"B33/12","v":53506.495625000003},{"$f":"D29-D31","v":642077.94750000001},{"$nulls":13},"Annual Debt Service",{"$f":"27423*12","v":329076},{"$f":"28497*12","v":341964},{"$f":"29067*12","v":348804}]
[{"$nulls":17},"Prepayment","4.5yr ","6.5yr ","9.5yr "]
[{"$nulls":17},"Interest Only",2,3,5]
["Rolling 6","Totals","Monthly Ave","Annualized",{"$nulls":13},"Interest Rate",4.8500000000000001E-2,5.0900000000000001E-2,5.3400000000000003E-2]
["Total Income (Dec '24 - Nov '25)",{"$f":"SUM(I3:N3)","v":458469.74000000005},{"$f":"B37/6","v":76411.623333333337},{"$f":"C37*12","v":916939.48},{"$f":"D37*0.11","v":100863.3428},{"$nulls":12},"Recourse","Non-Recourse","Non-Recourse","Non-Recourse"]
["Total Exp",{"$f":"SUM(I17:N17)","v":79579.422499999986},{"$f":"B38/6","v":13263.237083333332},{"$f":"C38*12","v":159158.84499999997},{"$nulls":13},"Application Fee",15292,15225,15038]
["Total Exp + Tax Adjustment",{"$f":"B38+(S25*6)","v":105328.24249999999},{"$f":"B39/6","v":17554.707083333331},210656.48499999999,{"$nulls":13},"Lender Origination",0.01,0.01,0.01]
["Average Exp Ratio",{"$f":"B39/B37","v":0.22973870096639307},{"$f":"B40","v":0.22973870096639307},{"$f":"D39/D37","v":0.22973870096639309},{"$nulls":13},"Debt Placement Fee",0.01,0.01,0.01]
["Total Profit",{"$f":"B37-B39","v":353141.49750000006},{"$f":"B41/6","v":58856.916250000009},{"$f":"D37-D39","v":706282.995}]
[{"$nulls":17},"Total Income",{"$f":"D37","v":916939.48},{"$f":"S42","v":916939.48},{"$f":"T42","v":916939.48}]
[{"$nulls":17},"Operating Expenses ",{"$f":"D39","v":210656.48499999999},{"$f":"S43","v":210656.48499999999},{"$f":"T43","v":210656.48499999999}]
["Rolling 3","Totals","Monthly Ave","Annualized",{"$nulls":13},"Debt Service",{"$f":"S33","v":329076},{"$f":"T33","v":341964},348804]
["Total Income (Dec '24 - Nov '25)",{"$f":"SUM(L3:N3)","v":219168.84000000003},{"$f":"B45/3","v":73056.280000000013},{"$f":"C45*12","v":876675.3600000001},{"$nulls":13},"Net Owner Income",{"$f":"S42-S43-S44","v":377206.995},{"$f":"T42-T43-T44","v":364318.995},{"$f":"U42-U43-U44","v":357478.995}]
["Total Exp",{"$f":"SUM(L17:N17)","v":38924.449999999997},{"$f":"B46/3","v":12974.816666666666},{"$f":"C46*12","v":155697.79999999999},{"$nulls":13},"ROE",{"$f":"S45/S30","v":0.10313246616541354},{"$f":"T45/T30","v":9.9608747778537246E-2},{"$f":"U45/U30","v":9.7738617908407377E-2}]
["Total Exp + Tax Adjustment",{"$f":"B46+(S25*3)","v":51798.86},{"$f":"B47/3","v":17266.286666666667},{"$f":"C47*12","v":207195.44}]
["Average Exp Ratio",{"$f":"B47/B45","v":0.23634226471244724},{"$f":"B48","v":0.23634226471244724},{"$f":"D47/D45","v":0.23634226471244724}]
["Total Profit",{"$f":"B45-B47","v":167369.98000000004},{"$f":"B49/3","v":55789.993333333347},{"$f":"D45-D47","v":669479.92000000016}]
[]
[]
["Occupancy","9/24","10/24",0.45833333333333331,"2025-12-24",0.04,0.08,0.12,0.16,"5/25","6/25","7/25","8/25","9/25","10/25","11/25","12/25","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,45,{"$f":"AVERAGE(B53:M53)","v":45},{"$f":"AVERAGE(C53:N53)","v":45},{"$f":"AVERAGE(K53:M53)","v":45}]
["Occupied Units",{"$f":"B56+B57+B58","v":44},{"$f":"C56+C57+C58","v":40},37,39,37,35,33,37,40,44,{"$f":"L56+L57+L58","v":45},{"$f":"M56+M57+M58","v":45},44,{"$f":"O56+O57+O58","v":45},44,43,{"$f":"AVERAGE(F54:Q54)","v":41},{"$f":"AVERAGE(L54:Q54)","v":44.333333333333336},{"$f":"AVERAGE(O54:Q54)","v":44}]
["Percent",{"$f":"B54/B53","v":0.97777777777777775},0.88888888888888884,0.82222222222222219,0.8666666666666667,0.82222222222222219,0.77777777777777779,0.73333333333333328,0.82222222222222219,0.88888888888888884,0.97777777777777775,{"$f":"L54/L53","v":1},{"$f":"M54/M53","v":1},{"$f":"N54/N53","v":0.97777777777777775},1,0.97777777777777775,0.9555555555555556,{"$f":"AVERAGE(F55:Q55)","v":0.91111111111111109},{"$f":"AVERAGE(L55:Q55)","v":0.98518518518518527},{"$f":"AVERAGE(O55:Q55)","v":0.97777777777777786}]
["2 Bedrooms",9,8,8,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,{"$f":"AVERAGE(K56:M56)","v":9}]
["1 Bedroom",26,23,21,22,20,17,15,19,22,26,27,27,27,27,27,27,27,27,{"$f":"AVERAGE(K57:M57)","v":26.666666666666668}]
["Studio",9,9,8,8,8,9,9,9,9,9,9,9,9,9,9,9,9,9,{"$f":"AVERAGE(K58:M58)","v":9}]

{"sheet":"Rental Income Breakdown","index":1,"n_rows":19,"n_cols":17,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"2024-12-01","2025-01-01","2025-02-01","2025-03-01","2025-04-01","2025-05-01","2025-06-01","2025-07-01","2025-08-25","2025-09-25","2025-10-25","2025-11-25",null,"Current Occupancy",{"$f":"N4/45","v":0.9555555555555556}]
[null,"Total Rental Income",{"$f":"Summary!B3","v":64484.89},{"$f":"Summary!C3","v":67032.19},{"$f":"Summary!D3","v":58105.35},{"$f":"Summary!E3","v":70203.58},{"$f":"Summary!F3","v":64789.909999999996},{"$f":"Summary!G3","v":72102.84},{"$f":"Summary!H3","v":69292.26999999999},{"$f":"Summary!I3","v":79980.36},{"$f":"Summary!J3","v":77286.170000000013},{"$f":"Summary!K3","v":82034.37},{"$f":"Summary!L3","v":74667.460000000006},{"$f":"Summary!M3","v":68710.77}]
[null,"Occupied Units",39,36,35,36,38,42,43,44,45,45,43,43]
[{"$nulls":15},{"$f":"P6+P7","v":848690.15999999992}]
[null,"Rental Income (R&T)",{"$f":"C3-(SUM(C7:C11))","v":56337.09},58053.69,49045.47,62450.58,57569.909999999996,64489.34,61965.26999999999,72177.36,69727.670000000013,{"$f":"L3-(SUM(L7:L11))","v":74278.459999999992},{"$f":"M3-(SUM(M7:M11))","v":66899.08},{"$f":"N3-(SUM(N7:N11))","v":61189.640000000007},null,{"$f":"SUM(C6:N6)","v":754183.55999999994}]
[null,"Electricity (cost reclaimation)",{"$f":"Summary!B7","v":3330},{"$f":"Summary!C7","v":3845},{"$f":"Summary!D7","v":4457},{"$f":"Summary!E7","v":3832},{"$f":"Summary!F7","v":2829},{"$f":"Summary!G7","v":2727},{"$f":"Summary!H7","v":1869},{"$f":"Summary!I7","v":1991},{"$f":"Summary!J7","v":2105},{"$f":"Summary!K7","v":2227},{"$f":"Summary!L7","v":2085},{"$f":"Summary!M7","v":2495},{"$f":"SUM(C7:N7)","v":33792},{"$f":"SUM(O7:O11)","v":94506.6},{"$f":"P7/P5","v":0.11135583332320009}]
[null,"Water",{"$f":"C4*25","v":975},900,875,900,950,1050,1075,1100,1125,{"$f":"L4*25","v":1125},{"$f":"M4*25","v":1075},1075,12225]
[null,"Internet",{"$f":"worksheet!C16","v":1727},{"$f":"worksheet!D16","v":1668},{"$f":"worksheet!E16","v":1609},{"$f":"worksheet!F16","v":1491},{"$f":"worksheet!G16","v":1727},{"$f":"worksheet!H16","v":1845},{"$f":"worksheet!I16","v":1904},{"$f":"worksheet!J16","v":1845},{"$f":"worksheet!K16","v":1786},{"$f":"worksheet!L16","v":1845},{"$f":"worksheet!M16","v":1904},{"$f":"worksheet!N16","v":1963},21314]
[null,"Monthly Pet Fee",1750,1500,1400,1150,1290,1370,1300,1250,1250,1300,1300,1250,16110]
[null,"Misc (App/Late & Cleaning Fees)",{"$f":"worksheet!C23","v":365.8},{"$f":"worksheet!D23","v":1065.5},{"$f":"worksheet!E23","v":718.88},{"$f":"worksheet!F23","v":380},{"$f":"worksheet!G23","v":424},{"$f":"worksheet!H23","v":621.5},{"$f":"worksheet!I23","v":1179},{"$f":"worksheet!J23","v":1617},{"$f":"worksheet!K23","v":1292.5},{"$f":"worksheet!L23","v":1258.9099999999999},{"$f":"worksheet!M23","v":1404.38},{"$f":"worksheet!N23","v":738.13},11065.6]
[]
[]
[]
[]
[]
[null,"*Electricity is a pass through"]
[null,"*Water Billed at $25/Unit (recommended to be increased to $35 to become revenue generator)"]
[null,"*Internet cost is $30 for 100 mbps and $50 for 500mbps - billed at $59 for 100 mbps and $75 for 500 mbps (revenue genterator)"]

{"sheet":"worksheet","index":2,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":true,"merged":[[43,0,43,1],[44,4,44,5]]}
[]
[]
[null,"Water Diff",{"$f":"'Rental Income Breakdown'!C8-Summary!B9","v":-118.79500000000007},{"$f":"'Rental Income Breakdown'!D8-Summary!C9","v":-193.79500000000007},{"$f":"'Rental Income Breakdown'!E8-Summary!D9","v":-219.02999999999997},{"$f":"'Rental Income Breakdown'!F8-Summary!E9","v":-48.879999999999995},{"$f":"'Rental Income Breakdown'!G8-Summary!F9","v":10.990000000000009},{"$f":"'Rental Income Breakdown'!H8-Summary!G9","v":77.899999999999977},{"$f":"'Rental Income Breakdown'!I8-Summary!H9","v":-55.339999999999918},{"$f":"'Rental Income Breakdown'!J8-Summary!I9","v":-300.52999999999997},{"$f":"'Rental Income Breakdown'!K8-Summary!J9","v":-268.20000000000005},{"$f":"'Rental Income Breakdown'!L8-Summary!K9","v":-221.15000000000009},{"$f":"'Rental Income Breakdown'!M8-Summary!L9","v":-334.48},{"$f":"'Rental Income Breakdown'!N8-Summary!M9","v":-648.79999999999995}]
[null,"Internet Diff",{"$f":"'Rental Income Breakdown'!C9-Summary!B6","v":837},{"$f":"'Rental Income Breakdown'!D9-Summary!C6","v":808},{"$f":"'Rental Income Breakdown'!E9-Summary!D6","v":779},{"$f":"'Rental Income Breakdown'!F9-Summary!E6","v":721},{"$f":"'Rental Income Breakdown'!G9-Summary!F6","v":837},{"$f":"'Rental Income Breakdown'!H9-Summary!G6","v":895},{"$f":"'Rental Income Breakdown'!I9-Summary!H6","v":924},{"$f":"'Rental Income Breakdown'!J9-Summary!I6","v":895},{"$f":"'Rental Income Breakdown'!K9-Summary!J6","v":866},{"$f":"'Rental Income Breakdown'!L9-Summary!K6","v":521},{"$f":"'Rental Income Breakdown'!M9-Summary!L6","v":924},{"$f":"'Rental Income Breakdown'!N9-Summary!M6","v":953}]
[]
[]
[]
[]
["Internet",null,"Dec","Jan","Feb","Mar","Apr","May","June","July","Aug","Sep","Oct","Nov"]
["Cost",null,{"$f":"Summary!B6","v":890},{"$f":"Summary!C6","v":860},{"$f":"Summary!D6","v":830},{"$f":"Summary!E6","v":770},{"$f":"Summary!F6","v":890},{"$f":"Summary!G6","v":950},{"$f":"Summary!H6","v":980},{"$f":"Summary!I6","v":950},{"$f":"Summary!J6","v":920},{"$f":"Summary!K6","v":1324},{"$f":"Summary!L6","v":980},{"$f":"Summary!M6","v":1010}]
["Cost less 500mbps",null,{"$f":"(C10-50)","v":840},810,780,720,840,900,930,900,870,1274,930,{"$f":"(N10-50)","v":960}]
["# 100 mpbs users",null,{"$f":"C11/30","v":28},27,26,24,28,30,31,30,29,30,31,32]
["# 500 mbps users",null,1,1,1,1,1,1,1,1,1,1,1,1]
["Income for 100mbps",null,{"$f":"C12*59","v":1652},1593,1534,1416,1652,1770,1829,1770,1711,1770,{"$f":"M12*59","v":1829},1888]
["Income for 500 mbps",null,{"$f":"75*C13","v":75},75,75,75,75,75,75,75,75,75,{"$f":"75*M13","v":75},75]
[null,"Total",{"$f":"C14+C15","v":1727},1668,1609,1491,1727,1845,1904,1845,1786,1845,{"$f":"M14+M15","v":1904},1963]
[]
[]
["Misc"]
["App",null,null,15.5,46.5,155,124,46.5,79,17,32.5,46.5,15.5,15.5]
["Late",null,365.8,150,375,225,225,575,600,300,660,596.12,488.88,722.63]
["Cleaning",null,0,900,297.38,0,75,0,500,1300,600,616.29,900,0]
["Total",null,{"$f":"SUM(C20:C22)","v":365.8},1065.5,718.88,380,424,621.5,1179,1617,1292.5,1258.9099999999999,1404.38,738.13]
[]
[]
[]
[]
[]
[]
[null,null,"marketing","annual fire","supplies","lon exp"]
[null,"dec",null,null,null,345.15]
[null,"jan",null,null,null,155.03]
[null,"feb"]
[null,"march"]
[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,"Total",{"$f":"SUM(C31:C42)","v":1136.96},{"$f":"SUM(D31:D42)","v":3030},{"$f":"SUM(E31:E42)","v":2201.9899999999998},{"$f":"SUM(F31:F42)","v":2438.2599999999998}]
["Normalized to Monthly",null,{"$f":"C43/12","v":94.74666666666667},{"$f":"D43/12","v":252.5},{"$f":"E43/12","v":183.49916666666664},{"$f":"F43/12","v":203.1883333333333}]
[{"$nulls":4},{"$f":"E44+F44","v":386.68749999999994}]

{"sheet":"November","index":3,"n_rows":40,"n_cols":20,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["Beginning Balance",{"$f":"[1]October!B42","v":54824.439999999799}]
[{"$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":75297.569999999803}]
[]
["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":75297.569999999803}]

{"sheet":"October","index":4,"n_rows":42,"n_cols":20,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["Beginning Balance",{"$f":"[1]September!B32","v":121059.84999999983}]
[{"$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":145884.2799999998}]
[]
["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":54824.439999999799}]

{"sheet":"September","index":5,"n_rows":42,"n_cols":30,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["Beginning Balance",{"$f":"[1]August!B38","v":91097.489999999845},{"$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":121059.84999999983},{"$nulls":5},105671.32,null,{"$f":"B32-H32","v":15388.529999999824}]
[]
["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":2974.9999999998254}]
[]
[{"$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":6,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["Beginning Balance",{"$f":"[1]July!B31","v":70384.369999999879}]
[]
["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":97070.699999999852}]
[]
["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":91097.489999999845}]

{"sheet":"July","index":7,"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":8,"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":9,"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},{"$f":"SUM(K17:K19)","v":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":10,"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},{"$f":"SUM(K15:K17)","v":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":11,"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":12,"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":13,"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},{"$f":"B31+'[2]Feb 25'!B33+March!B32","v":-48077.009999999995}]
["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":14,"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}]