{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["BUD","CAT","CPL","VAR","Exec Summary"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"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":"BUD","index":0,"n_rows":75,"n_cols":68,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["08/01/2025",null,"Sonida Senior Living, Inc",{"$nulls":36},"Run Date/Time:",{"$nulls":12},"2025-09-15T13:33:58.407","|",{"$nulls":5},"|",{"$nulls":4},"|"]
[null,null,"P&L Category Budget Variance Analysis",{"$nulls":36},"ReportId:",{"$nulls":13},"|",{"$nulls":5},"|",{"$nulls":4},"|"]
[null,null,"KDC Properties (m1618)",{"$nulls":50},"|",{"$nulls":5},"|",{"$nulls":4},"|"]
[null,null,{"$f":"\"As of \"&TEXT(EOMONTH(BN4,0),\"MMMM DD,  YYYY\")","v":"As of August 31,  2025"},{"$nulls":50},"|",{"$nulls":5},"|",{"$nulls":4},"|","08/01/2025"]
[null,null,null,"Actual","Budget",null,null,"Actual","Budget",{"$nulls":14},"Actual",{"$nulls":12},"Budget",{"$nulls":15},"Budget","|",{"$f":"\"Q\"&ROUNDUP(MONTH(BC7)/3,0)","v":"Q3"},"Q2","Q1","Q4","Q3","|",{"$f":"BC5&\" o \"&BD5","v":"Q3 o Q2"},"Q2 o Q1","Q1 o Q4","Q4 o Q3","|"]
[null,null,null,"Month","Month","Incr(Decr)","% Incr(Decr)","Rolling QTD","Rolling QTD","Incr(Decr)","% Incr(Decr)",{"$f":"YEAR(BN4)&\"-1\"","v":"2025-1"},{"$f":"YEAR(BN4)&\"-2\"","v":"2025-2"},{"$f":"YEAR(BN4)&\"-3\"","v":"2025-3"},{"$f":"YEAR(BN4)&\"-4\"","v":"2025-4"},{"$f":"YEAR(BN4)&\"-5\"","v":"2025-5"},{"$f":"YEAR(BN4)&\"-6\"","v":"2025-6"},{"$f":"YEAR(BN4)&\"-7\"","v":"2025-7"},{"$f":"YEAR(BN4)&\"-8\"","v":"2025-8"},{"$f":"YEAR(BN4)&\"-9\"","v":"2025-9"},{"$f":"YEAR(BN4)&\"-10\"","v":"2025-10"},{"$f":"YEAR(BN4)&\"-11\"","v":"2025-11"},{"$f":"YEAR(BN4)&\"-12\"","v":"2025-12"},"YTD",{"$f":"YEAR(BN4)&\"-1\"","v":"2025-1"},{"$f":"YEAR(BN4)&\"-2\"","v":"2025-2"},{"$f":"YEAR(BN4)&\"-3\"","v":"2025-3"},{"$f":"YEAR(BN4)&\"-4\"","v":"2025-4"},{"$f":"YEAR(BN4)&\"-5\"","v":"2025-5"},{"$f":"YEAR(BN4)&\"-6\"","v":"2025-6"},{"$f":"YEAR(BN4)&\"-7\"","v":"2025-7"},{"$f":"YEAR(BN4)&\"-8\"","v":"2025-8"},{"$f":"YEAR(BN4)&\"-9\"","v":"2025-9"},{"$f":"YEAR(BN4)&\"-10\"","v":"2025-10"},{"$f":"YEAR(BN4)&\"-11\"","v":"2025-11"},{"$f":"YEAR(BN4)&\"-12\"","v":"2025-12"},"YTD","Incr(Decr)","% Incr(Decr)",null,{"$f":"YEAR(BN4)&\"-1\"","v":"2025-1"},{"$f":"YEAR(BN4)&\"-2\"","v":"2025-2"},{"$f":"YEAR(BN4)&\"-3\"","v":"2025-3"},{"$f":"YEAR(BN4)&\"-4\"","v":"2025-4"},{"$f":"YEAR(BN4)&\"-5\"","v":"2025-5"},{"$f":"YEAR(BN4)&\"-6\"","v":"2025-6"},{"$f":"YEAR(BN4)&\"-7\"","v":"2025-7"},{"$f":"YEAR(BN4)&\"-8\"","v":"2025-8"},{"$f":"YEAR(BN4)&\"-9\"","v":"2025-9"},{"$f":"YEAR(BN4)&\"-10\"","v":"2025-10"},{"$f":"YEAR(BN4)&\"-11\"","v":"2025-11"},{"$f":"YEAR(BN4)&\"-12\"","v":"2025-12"},"Annual","|","Rolling QTD","Rolling QTD","Rolling QTD","Rolling QTD","Rolling QTD","|","% Incr(Decr)","% Incr(Decr)","% Incr(Decr)","% Incr(Decr)","|"]
[null,null,"Month-Year","Aug-25","Aug-25",null,null,"Aug-25","Aug-25",null,null,1.0,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,null,1.0,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,"Aug-25",null,null,null,1.0,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,{"$f":"YEAR(BN4)&\"-12\"","v":"2025-12"},"|","Aug-25","May-25","Feb-25","Nov-24","Aug-24","|",{"$nulls":4},"|"]
[null,null,"Units Occupied",null,null,{"$f":"D8-E8","v":0},{"$f":"IFERROR(F8/E8,0)","v":0},null,null,{"$f":"H8-I8","v":0},{"$f":"IFERROR(J8/I8,0)","v":0},{"$f":"IF(L7>MONTH($BN$4),\"\",HLOOKUP($L$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(M7>MONTH($BN$4),\"\",HLOOKUP($M$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(N7>MONTH($BN$4),\"\",HLOOKUP($N$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(O7>MONTH($BN$4),\"\",HLOOKUP($O$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(P7>MONTH($BN$4),\"\",HLOOKUP($P$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(Q7>MONTH($BN$4),\"\",HLOOKUP($Q$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(R7>MONTH($BN$4),\"\",HLOOKUP($R$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(S7>MONTH($BN$4),\"\",HLOOKUP($S$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(T7>MONTH($BN$4),\"\",HLOOKUP($T$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(U7>MONTH($BN$4),\"\",HLOOKUP($U$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(V7>MONTH($BN$4),\"\",HLOOKUP($V$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(W7>MONTH($BN$4),\"\",HLOOKUP($W$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},null,{"$f":"IF(Y7>MONTH($BN$4),\"\",AO8)","v":""},"","","","","","","","","","","",null,{"$f":"X8-AK8","v":0},{"$f":"IFERROR(AL8/AK8,0)","v":0},{"$nulls":14},{"$f":"\"|\"","v":"|"},{"$nulls":5},{"$f":"\"|\"","v":"|"},{"$f":"IFERROR(IF(BG8<=0,-(BG8-BD8)/BD8,(BG8-BD8)/BD8),0)","v":0},{"$f":"IFERROR(IF(BD8<=0,-(BD8-BE8)/BE8,(BD8-BE8)/BE8),0)","v":0},0,0,{"$f":"\"|\"","v":"|"},"H"]
[null,null,"   Independent Living Occupied",11.9032,11.0,0.9032,0.08210909091,11.688166,11.0,0.688166,0.06256054545,{"$f":"IF(L7>MONTH($BN$4),\"\",HLOOKUP($L$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12.0323},{"$f":"IF(M7>MONTH($BN$4),\"\",HLOOKUP($M$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(N7>MONTH($BN$4),\"\",HLOOKUP($N$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(O7>MONTH($BN$4),\"\",HLOOKUP($O$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(P7>MONTH($BN$4),\"\",HLOOKUP($P$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(Q7>MONTH($BN$4),\"\",HLOOKUP($Q$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(R7>MONTH($BN$4),\"\",HLOOKUP($R$7,CPL!$E$5:$P$50,ROW()-4,0))","v":11.1613},{"$f":"IF(S7>MONTH($BN$4),\"\",HLOOKUP($S$7,CPL!$E$5:$P$50,ROW()-4,0))","v":11.9032},{"$f":"IF(T7>MONTH($BN$4),\"\",HLOOKUP($T$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(U7>MONTH($BN$4),\"\",HLOOKUP($U$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(V7>MONTH($BN$4),\"\",HLOOKUP($V$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(W7>MONTH($BN$4),\"\",HLOOKUP($W$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},11.8871,{"$f":"IF(Y7>MONTH($BN$4),\"\",AO9)","v":11},11,11,11,11,11,11,11,"","","","",11.0,0.8871,0.08064545455,null,11.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,"|",11.688166,12.0,12.010766,11.505366,10.268833,"|",-0.1442639167,{"$f":"IFERROR(IF(BD9<=0,-(BD9-BE9)/BE9,(BD9-BE9)/BE9),0)","v":-0.0008963624801},0.04392732921,0.1204161174,"|","R"]
[null,null,"   Assisted Living Occupied",0.0,0.0,0,0,0.0,0.0,0,0,{"$f":"IF(L7>MONTH($BN$4),\"\",HLOOKUP($L$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(M7>MONTH($BN$4),\"\",HLOOKUP($M$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(N7>MONTH($BN$4),\"\",HLOOKUP($N$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(O7>MONTH($BN$4),\"\",HLOOKUP($O$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(P7>MONTH($BN$4),\"\",HLOOKUP($P$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(Q7>MONTH($BN$4),\"\",HLOOKUP($Q$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(R7>MONTH($BN$4),\"\",HLOOKUP($R$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(S7>MONTH($BN$4),\"\",HLOOKUP($S$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(T7>MONTH($BN$4),\"\",HLOOKUP($T$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(U7>MONTH($BN$4),\"\",HLOOKUP($U$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(V7>MONTH($BN$4),\"\",HLOOKUP($V$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(W7>MONTH($BN$4),\"\",HLOOKUP($W$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},0.0,{"$f":"IF(Y7>MONTH($BN$4),\"\",AO10)","v":0},0,0,0,0,0,0,0,"","","","",0.0,0,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",0.0,0.0,0.0,0.0,0.0,"|",0,{"$f":"IFERROR(IF(BD10<=0,-(BD10-BE10)/BE10,(BD10-BE10)/BE10),0)","v":0},0,0,"|","R"]
[null,null,"   Memory Care Occupied",0.0,0.0,0,0,0.0,0.0,0,0,{"$f":"IF(L7>MONTH($BN$4),\"\",HLOOKUP($L$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(M7>MONTH($BN$4),\"\",HLOOKUP($M$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(N7>MONTH($BN$4),\"\",HLOOKUP($N$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(O7>MONTH($BN$4),\"\",HLOOKUP($O$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(P7>MONTH($BN$4),\"\",HLOOKUP($P$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(Q7>MONTH($BN$4),\"\",HLOOKUP($Q$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(R7>MONTH($BN$4),\"\",HLOOKUP($R$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(S7>MONTH($BN$4),\"\",HLOOKUP($S$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(T7>MONTH($BN$4),\"\",HLOOKUP($T$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(U7>MONTH($BN$4),\"\",HLOOKUP($U$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(V7>MONTH($BN$4),\"\",HLOOKUP($V$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(W7>MONTH($BN$4),\"\",HLOOKUP($W$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},0.0,{"$f":"IF(Y7>MONTH($BN$4),\"\",AO11)","v":0},0,0,0,0,0,0,0,"","","","",0.0,0,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",0.0,0.0,0.0,0.0,0.0,"|",0,{"$f":"IFERROR(IF(BD11<=0,-(BD11-BE11)/BE11,(BD11-BE11)/BE11),0)","v":0},0,0,"|","R"]
[null,null,"      Total Units Occupied",11.9032,11.0,0.9032,0.08210909091,11.688166,11.0,0.688166,0.06256054545,{"$f":"IF(L7>MONTH($BN$4),\"\",HLOOKUP($L$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12.0323},{"$f":"IF(M7>MONTH($BN$4),\"\",HLOOKUP($M$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(N7>MONTH($BN$4),\"\",HLOOKUP($N$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(O7>MONTH($BN$4),\"\",HLOOKUP($O$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(P7>MONTH($BN$4),\"\",HLOOKUP($P$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(Q7>MONTH($BN$4),\"\",HLOOKUP($Q$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(R7>MONTH($BN$4),\"\",HLOOKUP($R$7,CPL!$E$5:$P$50,ROW()-4,0))","v":11.1613},{"$f":"IF(S7>MONTH($BN$4),\"\",HLOOKUP($S$7,CPL!$E$5:$P$50,ROW()-4,0))","v":11.9032},{"$f":"IF(T7>MONTH($BN$4),\"\",HLOOKUP($T$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(U7>MONTH($BN$4),\"\",HLOOKUP($U$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(V7>MONTH($BN$4),\"\",HLOOKUP($V$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(W7>MONTH($BN$4),\"\",HLOOKUP($W$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},11.8871,{"$f":"IF(Y7>MONTH($BN$4),\"\",AO12)","v":11},11,11,11,11,11,11,11,"","","","",11.0,0.8871,0.08064545455,null,11.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,11.0,"|",11.688166,12.0,12.010766,11.505366,10.268833,"|",-0.1442639167,{"$f":"IFERROR(IF(BD12<=0,-(BD12-BE12)/BE12,(BD12-BE12)/BE12),0)","v":-0.0008963624801},0.04392732921,0.1204161174,"|","T"]
[null,null,"Units Available",null,null,0,0,null,null,0,0,{"$f":"IF(L7>MONTH($BN$4),\"\",HLOOKUP($L$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(M7>MONTH($BN$4),\"\",HLOOKUP($M$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(N7>MONTH($BN$4),\"\",HLOOKUP($N$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(O7>MONTH($BN$4),\"\",HLOOKUP($O$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(P7>MONTH($BN$4),\"\",HLOOKUP($P$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(Q7>MONTH($BN$4),\"\",HLOOKUP($Q$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(R7>MONTH($BN$4),\"\",HLOOKUP($R$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(S7>MONTH($BN$4),\"\",HLOOKUP($S$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(T7>MONTH($BN$4),\"\",HLOOKUP($T$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(U7>MONTH($BN$4),\"\",HLOOKUP($U$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(V7>MONTH($BN$4),\"\",HLOOKUP($V$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(W7>MONTH($BN$4),\"\",HLOOKUP($W$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},null,{"$f":"IF(Y7>MONTH($BN$4),\"\",AO13)","v":""},"","","","","","","","","","","",null,0,0,{"$nulls":14},"|",{"$nulls":5},"|",0,{"$f":"IFERROR(IF(BD13<=0,-(BD13-BE13)/BE13,(BD13-BE13)/BE13),0)","v":0},0,0,"|","H"]
[null,null,"   Independent Living Available",12.0,12.0,0,0,12.0,12.0,0,0,{"$f":"IF(L7>MONTH($BN$4),\"\",HLOOKUP($L$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(M7>MONTH($BN$4),\"\",HLOOKUP($M$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(N7>MONTH($BN$4),\"\",HLOOKUP($N$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(O7>MONTH($BN$4),\"\",HLOOKUP($O$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(P7>MONTH($BN$4),\"\",HLOOKUP($P$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(Q7>MONTH($BN$4),\"\",HLOOKUP($Q$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(R7>MONTH($BN$4),\"\",HLOOKUP($R$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(S7>MONTH($BN$4),\"\",HLOOKUP($S$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(T7>MONTH($BN$4),\"\",HLOOKUP($T$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(U7>MONTH($BN$4),\"\",HLOOKUP($U$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(V7>MONTH($BN$4),\"\",HLOOKUP($V$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(W7>MONTH($BN$4),\"\",HLOOKUP($W$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},12.0,{"$f":"IF(Y7>MONTH($BN$4),\"\",AO14)","v":12},12,12,12,12,12,12,12,"","","","",12.0,0,0,null,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,"|",12.0,12.0,12.0,12.0,12.0,"|",0,{"$f":"IFERROR(IF(BD14<=0,-(BD14-BE14)/BE14,(BD14-BE14)/BE14),0)","v":0},0,0,"|","R"]
[null,null,"   Assisted Living Available",0.0,0.0,0,0,0.0,0.0,0,0,{"$f":"IF(L7>MONTH($BN$4),\"\",HLOOKUP($L$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(M7>MONTH($BN$4),\"\",HLOOKUP($M$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(N7>MONTH($BN$4),\"\",HLOOKUP($N$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(O7>MONTH($BN$4),\"\",HLOOKUP($O$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(P7>MONTH($BN$4),\"\",HLOOKUP($P$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(Q7>MONTH($BN$4),\"\",HLOOKUP($Q$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(R7>MONTH($BN$4),\"\",HLOOKUP($R$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(S7>MONTH($BN$4),\"\",HLOOKUP($S$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(T7>MONTH($BN$4),\"\",HLOOKUP($T$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(U7>MONTH($BN$4),\"\",HLOOKUP($U$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(V7>MONTH($BN$4),\"\",HLOOKUP($V$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(W7>MONTH($BN$4),\"\",HLOOKUP($W$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},0.0,{"$f":"IF(Y7>MONTH($BN$4),\"\",AO15)","v":0},0,0,0,0,0,0,0,"","","","",0.0,0,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",0.0,0.0,0.0,0.0,0.0,"|",0,{"$f":"IFERROR(IF(BD15<=0,-(BD15-BE15)/BE15,(BD15-BE15)/BE15),0)","v":0},0,0,"|","R"]
[null,null,"   Memory Care Available",0.0,0.0,0,0,0.0,0.0,0,0,{"$f":"IF(L7>MONTH($BN$4),\"\",HLOOKUP($L$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(M7>MONTH($BN$4),\"\",HLOOKUP($M$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(N7>MONTH($BN$4),\"\",HLOOKUP($N$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(O7>MONTH($BN$4),\"\",HLOOKUP($O$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(P7>MONTH($BN$4),\"\",HLOOKUP($P$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(Q7>MONTH($BN$4),\"\",HLOOKUP($Q$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(R7>MONTH($BN$4),\"\",HLOOKUP($R$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(S7>MONTH($BN$4),\"\",HLOOKUP($S$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(T7>MONTH($BN$4),\"\",HLOOKUP($T$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(U7>MONTH($BN$4),\"\",HLOOKUP($U$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(V7>MONTH($BN$4),\"\",HLOOKUP($V$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(W7>MONTH($BN$4),\"\",HLOOKUP($W$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},0.0,{"$f":"IF(Y7>MONTH($BN$4),\"\",AO16)","v":0},0,0,0,0,0,0,0,"","","","",0.0,0,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",0.0,0.0,0.0,0.0,0.0,"|",0,{"$f":"IFERROR(IF(BD16<=0,-(BD16-BE16)/BE16,(BD16-BE16)/BE16),0)","v":0},0,0,"|","R"]
[null,null,"      Total Units Available",12.0,12.0,0,0,12.0,12.0,0,0,{"$f":"IF(L7>MONTH($BN$4),\"\",HLOOKUP($L$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(M7>MONTH($BN$4),\"\",HLOOKUP($M$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(N7>MONTH($BN$4),\"\",HLOOKUP($N$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(O7>MONTH($BN$4),\"\",HLOOKUP($O$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(P7>MONTH($BN$4),\"\",HLOOKUP($P$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(Q7>MONTH($BN$4),\"\",HLOOKUP($Q$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(R7>MONTH($BN$4),\"\",HLOOKUP($R$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(S7>MONTH($BN$4),\"\",HLOOKUP($S$7,CPL!$E$5:$P$50,ROW()-4,0))","v":12},{"$f":"IF(T7>MONTH($BN$4),\"\",HLOOKUP($T$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(U7>MONTH($BN$4),\"\",HLOOKUP($U$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(V7>MONTH($BN$4),\"\",HLOOKUP($V$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(W7>MONTH($BN$4),\"\",HLOOKUP($W$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},12.0,{"$f":"IF(Y7>MONTH($BN$4),\"\",AO17)","v":12},12,12,12,12,12,12,12,"","","","",12.0,0,0,null,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,"|",12.0,12.0,12.0,12.0,12.0,"|",0,{"$f":"IFERROR(IF(BD17<=0,-(BD17-BE17)/BE17,(BD17-BE17)/BE17),0)","v":0},0,0,"|","T"]
[null,null,"% Occupied",null,null,0,0,null,null,0,0,{"$f":"IF(L7>MONTH($BN$4),\"\",HLOOKUP($L$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(M7>MONTH($BN$4),\"\",HLOOKUP($M$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(N7>MONTH($BN$4),\"\",HLOOKUP($N$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(O7>MONTH($BN$4),\"\",HLOOKUP($O$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(P7>MONTH($BN$4),\"\",HLOOKUP($P$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(Q7>MONTH($BN$4),\"\",HLOOKUP($Q$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(R7>MONTH($BN$4),\"\",HLOOKUP($R$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(S7>MONTH($BN$4),\"\",HLOOKUP($S$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(T7>MONTH($BN$4),\"\",HLOOKUP($T$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(U7>MONTH($BN$4),\"\",HLOOKUP($U$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(V7>MONTH($BN$4),\"\",HLOOKUP($V$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(W7>MONTH($BN$4),\"\",HLOOKUP($W$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},null,{"$f":"IF(Y7>MONTH($BN$4),\"\",AO18)","v":""},"","","","","","","","","","","",null,0,0,{"$nulls":14},"|",{"$nulls":5},"|",0,{"$f":"IFERROR(IF(BD18<=0,-(BD18-BE18)/BE18,(BD18-BE18)/BE18),0)","v":0},0,0,"|","H","%"]
[null,null,"   Independent Living % Occupied",0.991933,0.916666,0.075267,0.08210951426,0.974013,0.916666,0.057347,0.06256040913,{"$f":"IF(L7>MONTH($BN$4),\"\",HLOOKUP($L$7,CPL!$E$5:$P$50,ROW()-4,0))","v":1.002691},{"$f":"IF(M7>MONTH($BN$4),\"\",HLOOKUP($M$7,CPL!$E$5:$P$50,ROW()-4,0))","v":1},{"$f":"IF(N7>MONTH($BN$4),\"\",HLOOKUP($N$7,CPL!$E$5:$P$50,ROW()-4,0))","v":1},{"$f":"IF(O7>MONTH($BN$4),\"\",HLOOKUP($O$7,CPL!$E$5:$P$50,ROW()-4,0))","v":1},{"$f":"IF(P7>MONTH($BN$4),\"\",HLOOKUP($P$7,CPL!$E$5:$P$50,ROW()-4,0))","v":1},{"$f":"IF(Q7>MONTH($BN$4),\"\",HLOOKUP($Q$7,CPL!$E$5:$P$50,ROW()-4,0))","v":1},{"$f":"IF(R7>MONTH($BN$4),\"\",HLOOKUP($R$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0.930108},{"$f":"IF(S7>MONTH($BN$4),\"\",HLOOKUP($S$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0.991933},{"$f":"IF(T7>MONTH($BN$4),\"\",HLOOKUP($T$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(U7>MONTH($BN$4),\"\",HLOOKUP($U$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(V7>MONTH($BN$4),\"\",HLOOKUP($V$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(W7>MONTH($BN$4),\"\",HLOOKUP($W$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},0.990591,{"$f":"IF(Y7>MONTH($BN$4),\"\",AO19)","v":0.916666},0.916666,0.916666,0.916666,0.916666,0.916666,0.916666,0.916666,"","","","",0.916666,0.073925,0.0806455132,null,0.916666,0.916666,0.916666,0.916666,0.916666,0.916666,0.916666,0.916666,0.916666,0.916666,0.916666,0.916666,0.916666,"|",0.974013,1.0,1.000897,0.95878,0.855736,"|",-0.144264,{"$f":"IFERROR(IF(BD19<=0,-(BD19-BE19)/BE19,(BD19-BE19)/BE19),0)","v":-0.0008961961121},0.04392769979,0.1204156422,"|","R","%"]
[null,null,"   Assisted Living % Occupied",0.0,0.0,0,0,0.0,0.0,0,0,{"$f":"IF(L7>MONTH($BN$4),\"\",HLOOKUP($L$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(M7>MONTH($BN$4),\"\",HLOOKUP($M$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(N7>MONTH($BN$4),\"\",HLOOKUP($N$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(O7>MONTH($BN$4),\"\",HLOOKUP($O$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(P7>MONTH($BN$4),\"\",HLOOKUP($P$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(Q7>MONTH($BN$4),\"\",HLOOKUP($Q$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(R7>MONTH($BN$4),\"\",HLOOKUP($R$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(S7>MONTH($BN$4),\"\",HLOOKUP($S$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(T7>MONTH($BN$4),\"\",HLOOKUP($T$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(U7>MONTH($BN$4),\"\",HLOOKUP($U$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(V7>MONTH($BN$4),\"\",HLOOKUP($V$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(W7>MONTH($BN$4),\"\",HLOOKUP($W$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},0.0,{"$f":"IF(Y7>MONTH($BN$4),\"\",AO20)","v":0},0,0,0,0,0,0,0,"","","","",0.0,0,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",0.0,0.0,0.0,0.0,0.0,"|",0,{"$f":"IFERROR(IF(BD20<=0,-(BD20-BE20)/BE20,(BD20-BE20)/BE20),0)","v":0},0,0,"|","R","%"]
[null,null,"   Memory Care % Occupied",0.0,0.0,0,0,0.0,0.0,0,0,{"$f":"IF(L7>MONTH($BN$4),\"\",HLOOKUP($L$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(M7>MONTH($BN$4),\"\",HLOOKUP($M$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(N7>MONTH($BN$4),\"\",HLOOKUP($N$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(O7>MONTH($BN$4),\"\",HLOOKUP($O$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(P7>MONTH($BN$4),\"\",HLOOKUP($P$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(Q7>MONTH($BN$4),\"\",HLOOKUP($Q$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(R7>MONTH($BN$4),\"\",HLOOKUP($R$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(S7>MONTH($BN$4),\"\",HLOOKUP($S$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0},{"$f":"IF(T7>MONTH($BN$4),\"\",HLOOKUP($T$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(U7>MONTH($BN$4),\"\",HLOOKUP($U$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(V7>MONTH($BN$4),\"\",HLOOKUP($V$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(W7>MONTH($BN$4),\"\",HLOOKUP($W$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},0.0,{"$f":"IF(Y7>MONTH($BN$4),\"\",AO21)","v":0},0,0,0,0,0,0,0,"","","","",0.0,0,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",0.0,0.0,0.0,0.0,0.0,"|",0,{"$f":"IFERROR(IF(BD21<=0,-(BD21-BE21)/BE21,(BD21-BE21)/BE21),0)","v":0},0,0,"|","R","%"]
[null,null,"      Total % Occupied",0.991933,0.916666,0.075267,0.08210951426,0.974013,0.916666,0.057347,0.06256040913,{"$f":"IF(L7>MONTH($BN$4),\"\",HLOOKUP($L$7,CPL!$E$5:$P$50,ROW()-4,0))","v":1.002691},{"$f":"IF(M7>MONTH($BN$4),\"\",HLOOKUP($M$7,CPL!$E$5:$P$50,ROW()-4,0))","v":1},{"$f":"IF(N7>MONTH($BN$4),\"\",HLOOKUP($N$7,CPL!$E$5:$P$50,ROW()-4,0))","v":1},{"$f":"IF(O7>MONTH($BN$4),\"\",HLOOKUP($O$7,CPL!$E$5:$P$50,ROW()-4,0))","v":1},{"$f":"IF(P7>MONTH($BN$4),\"\",HLOOKUP($P$7,CPL!$E$5:$P$50,ROW()-4,0))","v":1},{"$f":"IF(Q7>MONTH($BN$4),\"\",HLOOKUP($Q$7,CPL!$E$5:$P$50,ROW()-4,0))","v":1},{"$f":"IF(R7>MONTH($BN$4),\"\",HLOOKUP($R$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0.930108},{"$f":"IF(S7>MONTH($BN$4),\"\",HLOOKUP($S$7,CPL!$E$5:$P$50,ROW()-4,0))","v":0.991933},{"$f":"IF(T7>MONTH($BN$4),\"\",HLOOKUP($T$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(U7>MONTH($BN$4),\"\",HLOOKUP($U$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(V7>MONTH($BN$4),\"\",HLOOKUP($V$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(W7>MONTH($BN$4),\"\",HLOOKUP($W$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},0.990591,{"$f":"IF(Y7>MONTH($BN$4),\"\",AO22)","v":0.916666},0.916666,0.916666,0.916666,0.916666,0.916666,0.916666,0.916666,"","","","",0.916666,0.073925,0.0806455132,null,0.916666,0.916666,0.916666,0.916666,0.916666,0.916666,0.916666,0.916666,0.916666,0.916666,0.916666,0.916666,0.916666,"|",0.974013,1.0,1.000897,0.95878,0.855736,"|",-0.144264,{"$f":"IFERROR(IF(BD22<=0,-(BD22-BE22)/BE22,(BD22-BE22)/BE22),0)","v":-0.0008961961121},0.04392769979,0.1204156422,"|","T","%"]
[null,null,"Monthly Rent per Unit (AVG.)",null,null,0,0,null,null,0,0,{"$f":"IF(L7>MONTH($BN$4),\"\",HLOOKUP($L$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(M7>MONTH($BN$4),\"\",HLOOKUP($M$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(N7>MONTH($BN$4),\"\",HLOOKUP($N$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(O7>MONTH($BN$4),\"\",HLOOKUP($O$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(P7>MONTH($BN$4),\"\",HLOOKUP($P$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(Q7>MONTH($BN$4),\"\",HLOOKUP($Q$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(R7>MONTH($BN$4),\"\",HLOOKUP($R$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(S7>MONTH($BN$4),\"\",HLOOKUP($S$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(T7>MONTH($BN$4),\"\",HLOOKUP($T$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(U7>MONTH($BN$4),\"\",HLOOKUP($U$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(V7>MONTH($BN$4),\"\",HLOOKUP($V$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(W7>MONTH($BN$4),\"\",HLOOKUP($W$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},null,{"$f":"IF(Y7>MONTH($BN$4),\"\",AO23)","v":""},"","","","","","","","","","","",null,0,0,{"$nulls":14},"|",{"$nulls":5},"|",0,{"$f":"IFERROR(IF(BD23<=0,-(BD23-BE23)/BE23,(BD23-BE23)/BE23),0)","v":0},0,0,"|","H","$"]
[null,null,"   Independent Living Rent per Unit",3195.752402,0.0,3195.752402,0,3236.109925,0.0,3236.109925,0,{"$f":"IF(L7>MONTH($BN$4),\"\",HLOOKUP($L$7,CPL!$E$5:$P$50,ROW()-4,0))","v":2903.422454},{"$f":"IF(M7>MONTH($BN$4),\"\",HLOOKUP($M$7,CPL!$E$5:$P$50,ROW()-4,0))","v":3210.583333},{"$f":"IF(N7>MONTH($BN$4),\"\",HLOOKUP($N$7,CPL!$E$5:$P$50,ROW()-4,0))","v":3358.275},{"$f":"IF(O7>MONTH($BN$4),\"\",HLOOKUP($O$7,CPL!$E$5:$P$50,ROW()-4,0))","v":3290.833333},{"$f":"IF(P7>MONTH($BN$4),\"\",HLOOKUP($P$7,CPL!$E$5:$P$50,ROW()-4,0))","v":3290.833333},{"$f":"IF(Q7>MONTH($BN$4),\"\",HLOOKUP($Q$7,CPL!$E$5:$P$50,ROW()-4,0))","v":3290.833333},{"$f":"IF(R7>MONTH($BN$4),\"\",HLOOKUP($R$7,CPL!$E$5:$P$50,ROW()-4,0))","v":3220.313941},{"$f":"IF(S7>MONTH($BN$4),\"\",HLOOKUP($S$7,CPL!$E$5:$P$50,ROW()-4,0))","v":3195.752402},{"$f":"IF(T7>MONTH($BN$4),\"\",HLOOKUP($T$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(U7>MONTH($BN$4),\"\",HLOOKUP($U$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(V7>MONTH($BN$4),\"\",HLOOKUP($V$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(W7>MONTH($BN$4),\"\",HLOOKUP($W$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},3220.021283,{"$f":"IF(Y7>MONTH($BN$4),\"\",AO24)","v":0},0,0,0,0,0,0,0,"","","","",0.0,3220.021283,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",3236.109925,3313.313888,3077.484816,3267.957171,3152.390344,"|",-0.04856875909,{"$f":"IFERROR(IF(BD24<=0,-(BD24-BE24)/BE24,(BD24-BE24)/BE24),0)","v":0.07663045835},-0.05828483821,0.03666006249,"|","R","$"]
[null,null,"   Assisted Living Rent per Unit",null,null,0,0,null,null,0,0,{"$f":"IF(L7>MONTH($BN$4),\"\",HLOOKUP($L$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(M7>MONTH($BN$4),\"\",HLOOKUP($M$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(N7>MONTH($BN$4),\"\",HLOOKUP($N$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(O7>MONTH($BN$4),\"\",HLOOKUP($O$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(P7>MONTH($BN$4),\"\",HLOOKUP($P$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(Q7>MONTH($BN$4),\"\",HLOOKUP($Q$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(R7>MONTH($BN$4),\"\",HLOOKUP($R$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(S7>MONTH($BN$4),\"\",HLOOKUP($S$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(T7>MONTH($BN$4),\"\",HLOOKUP($T$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(U7>MONTH($BN$4),\"\",HLOOKUP($U$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(V7>MONTH($BN$4),\"\",HLOOKUP($V$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(W7>MONTH($BN$4),\"\",HLOOKUP($W$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},null,{"$f":"IF(Y7>MONTH($BN$4),\"\",AO25)","v":""},"","","","","","","","","","","",null,0,0,{"$nulls":14},"|",{"$nulls":5},"|",0,{"$f":"IFERROR(IF(BD25<=0,-(BD25-BE25)/BE25,(BD25-BE25)/BE25),0)","v":0},0,0,"|","R","$"]
[null,null,"   Memory Care Rent per Unit",null,null,0,0,null,null,0,0,{"$f":"IF(L7>MONTH($BN$4),\"\",HLOOKUP($L$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(M7>MONTH($BN$4),\"\",HLOOKUP($M$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(N7>MONTH($BN$4),\"\",HLOOKUP($N$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(O7>MONTH($BN$4),\"\",HLOOKUP($O$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(P7>MONTH($BN$4),\"\",HLOOKUP($P$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(Q7>MONTH($BN$4),\"\",HLOOKUP($Q$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(R7>MONTH($BN$4),\"\",HLOOKUP($R$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(S7>MONTH($BN$4),\"\",HLOOKUP($S$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(T7>MONTH($BN$4),\"\",HLOOKUP($T$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(U7>MONTH($BN$4),\"\",HLOOKUP($U$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(V7>MONTH($BN$4),\"\",HLOOKUP($V$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(W7>MONTH($BN$4),\"\",HLOOKUP($W$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},null,{"$f":"IF(Y7>MONTH($BN$4),\"\",AO26)","v":""},"","","","","","","","","","","",null,0,0,{"$nulls":14},"|",{"$nulls":5},"|",0,{"$f":"IFERROR(IF(BD26<=0,-(BD26-BE26)/BE26,(BD26-BE26)/BE26),0)","v":0},0,0,"|","R","$"]
[null,null,"      Total Monthly Rent per Unit (AVG.)",3164.18106,0.0,3164.18106,0,3210.029414,0.0,3210.029414,0,{"$f":"IF(L7>MONTH($BN$4),\"\",HLOOKUP($L$7,CPL!$E$5:$P$50,ROW()-4,0))","v":2907.577936},{"$f":"IF(M7>MONTH($BN$4),\"\",HLOOKUP($M$7,CPL!$E$5:$P$50,ROW()-4,0))","v":3214.75},{"$f":"IF(N7>MONTH($BN$4),\"\",HLOOKUP($N$7,CPL!$E$5:$P$50,ROW()-4,0))","v":3362.441666},{"$f":"IF(O7>MONTH($BN$4),\"\",HLOOKUP($O$7,CPL!$E$5:$P$50,ROW()-4,0))","v":3295},{"$f":"IF(P7>MONTH($BN$4),\"\",HLOOKUP($P$7,CPL!$E$5:$P$50,ROW()-4,0))","v":3045},{"$f":"IF(Q7>MONTH($BN$4),\"\",HLOOKUP($Q$7,CPL!$E$5:$P$50,ROW()-4,0))","v":3245},{"$f":"IF(R7>MONTH($BN$4),\"\",HLOOKUP($R$7,CPL!$E$5:$P$50,ROW()-4,0))","v":3221.326368},{"$f":"IF(S7>MONTH($BN$4),\"\",HLOOKUP($S$7,CPL!$E$5:$P$50,ROW()-4,0))","v":3164.18106},{"$f":"IF(T7>MONTH($BN$4),\"\",HLOOKUP($T$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(U7>MONTH($BN$4),\"\",HLOOKUP($U$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(V7>MONTH($BN$4),\"\",HLOOKUP($V$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},{"$f":"IF(W7>MONTH($BN$4),\"\",HLOOKUP($W$7,CPL!$E$5:$P$50,ROW()-4,0))","v":""},3181.486863,{"$f":"IF(Y7>MONTH($BN$4),\"\",AO27)","v":0},0,0,0,0,0,0,0,"","","","",0.0,3181.486863,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",3210.029414,3234.147222,3088.585968,3259.265575,3152.390344,"|",-0.02527926912,{"$f":"IFERROR(IF(BD27<=0,-(BD27-BE27)/BE27,(BD27-BE27)/BE27),0)","v":0.0471287688},-0.05236750522,0.03390291789,"|","T","$"]
[{"$nulls":53},"|",{"$nulls":5},"|",{"$nulls":4},"|"]
["H","","Revenue",0.0,0.0,{"$f":"IF(C29=\"\",\"\",D29-E29)","v":0},{"$f":"IF(C29=\"\",\"\",IFERROR(F29/E29,0))","v":0},0.0,0.0,{"$f":"IF(C29=\"\",\"\",H29-I29)","v":0},{"$f":"IF(C29=\"\",\"\",IFERROR(J29/I29,0))","v":0},0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,{"$f":"IF(MONTH(BN4)>=1,AO29,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP29,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ29,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR29,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS29,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT29,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU29,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV29,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW29,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX29,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY29,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ29,0)","v":0},0.0,{"$f":"IF(C29=\"\",\"\",X29-AK29)","v":0},{"$f":"IF(C29=\"\",\"\",IFERROR(AL29/AK29,0))","v":0},null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,{"$f":"\"|\"","v":"|"},0.0,0.0,0.0,0.0,0.0,{"$f":"\"|\"","v":"|"},{"$f":"IF(C29=\"\",\"\",IFERROR(IF(BG29<=0,-(BG29-BD29)/BD29,(BG29-BD29)/BD29),0))","v":0},{"$f":"IF(C29=\"\",\"\",IFERROR(IF(BD29<=0,-(BD29-BE29)/BE29,(BD29-BE29)/BE29),0))","v":0},{"$f":"IF(C29=\"\",\"\",IFERROR(IF(BE29<=0,-(BE29-BF29)/BF29,(BE29-BF29)/BF29),0))","v":0},{"$f":"IF(C29=\"\",\"\",IFERROR(IF(BF29<=0,-(BF29-BG29)/BG29,(BF29-BG29)/BG29),0))","v":0},{"$f":"\"|\"","v":"|"},-1.0,0.0,"H"]
["R","401000","IL Rent",35839.68,null,35839.68,0,105653.23,null,105653.23,0,35227.0,35227.0,33190.0,36190.0,36190.0,36190.0,33623.55,35839.68,{"$nulls":4},281677.23,{"$f":"IF(MONTH(BN4)>=1,AO30,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP30,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ30,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR30,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS30,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT30,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU30,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV30,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW30,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX30,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY30,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ30,0)","v":0},null,281677.23,0,{"$nulls":14},"|",105653.23,105570.0,105681.0,101229.39,90100.35,"|",-0.1465345269,-0.001050330712,0.04397546997,0.1235182771,"|",0.0,0.0,"R"]
["T","","     IL Rent",35839.68,0.0,35839.68,0,105653.23,0.0,105653.23,0,35227.0,35227.0,33190.0,36190.0,36190.0,36190.0,33623.55,35839.68,0.0,0.0,0.0,0.0,281677.23,{"$f":"IF(MONTH(BN4)>=1,AO31,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP31,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ31,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR31,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS31,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT31,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU31,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV31,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW31,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX31,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY31,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ31,0)","v":0},0.0,281677.23,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",105653.23,105570.0,105681.0,101229.39,90100.35,"|",-0.1465345269,-0.001050330712,0.04397546997,0.1235182771,"|",-1.0,0.0,"T"]
["R","401400","IL Rent - Second Resident",2200.0,null,2200,0,7877.42,null,7877.42,0,-292.15,3300.0,7109.3,3300.0,3300.0,3300.0,2377.42,2200.0,{"$nulls":4},24594.57,{"$f":"IF(MONTH(BN4)>=1,AO32,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP32,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ32,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR32,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS32,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT32,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU32,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV32,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW32,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX32,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY32,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ32,0)","v":0},null,24594.57,0,{"$nulls":14},"|",7877.42,13709.3,6307.85,11567.74,8513.76,"|",-0.3789792331,1.173371275,-0.4547033388,0.3587110748,"|",0.0,0.0,"R"]
["T","","     IL Rent 2nd Resident",2200.0,0.0,2200,0,7877.42,0.0,7877.42,0,-292.15,3300.0,7109.3,3300.0,3300.0,3300.0,2377.42,2200.0,0.0,0.0,0.0,0.0,24594.57,{"$f":"IF(MONTH(BN4)>=1,AO33,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP33,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ33,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR33,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS33,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT33,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU33,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV33,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW33,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX33,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY33,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ33,0)","v":0},0.0,24594.57,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",7877.42,13709.3,6307.85,11567.74,8513.76,"|",-0.3789792331,1.173371275,-0.4547033388,0.3587110748,"|",-1.0,0.0,"T"]
["R","401200","IL Rent Concessions",null,null,0,0,-58.08,null,-58.08,0,{"$nulls":6},-58.08,{"$nulls":5},-58.08,{"$f":"IF(MONTH(BN4)>=1,AO34,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP34,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ34,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR34,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS34,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT34,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU34,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV34,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW34,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX34,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY34,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ34,0)","v":0},null,-58.08,0,{"$nulls":14},"|",-58.08,null,-1100.0,null,-1500.0,"|",0,1,0,1,"|",0.0,0.0,"R"]
["T","","     IL Rent Concessions",0.0,0.0,0,0,-58.08,0.0,-58.08,0,0.0,0.0,0.0,0.0,0.0,0.0,-58.08,0.0,0.0,0.0,0.0,0.0,-58.08,{"$f":"IF(MONTH(BN4)>=1,AO35,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP35,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ35,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR35,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS35,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT35,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU35,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV35,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW35,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX35,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY35,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ35,0)","v":0},0.0,-58.08,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",-58.08,0.0,-1100.0,0.0,-1500.0,"|",0,1,0,1,"|",-1.0,0.0,"T"]
["R","440340","Community Fee",null,null,0,0,null,null,0,0,{"$nulls":13},{"$f":"IF(MONTH(BN4)>=1,AO36,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP36,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ36,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR36,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS36,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT36,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU36,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV36,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW36,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX36,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY36,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ36,0)","v":0},null,0,0,{"$nulls":14},"|",{"$nulls":5},"|",0,0,0,0,"|",0.0,0.0,"R"]
["T","","     Community Fees",0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,{"$f":"IF(MONTH(BN4)>=1,AO37,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP37,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ37,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR37,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS37,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT37,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU37,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV37,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW37,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX37,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY37,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ37,0)","v":0},0.0,0,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",0.0,0.0,0.0,0.0,0.0,"|",0,0,0,0,"|",-1.0,0.0,"T"]
["R","441340","Meals - Refunds",-425.8,null,-425.8,0,-1064.5,null,-1064.5,0,{"$nulls":4},-3000.0,-600.0,-38.7,-425.8,{"$nulls":4},-4064.5,{"$f":"IF(MONTH(BN4)>=1,AO38,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP38,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ38,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR38,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS38,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT38,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU38,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV38,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW38,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX38,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY38,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ38,0)","v":0},null,-4064.5,0,{"$nulls":14},"|",-1064.5,-3000.0,300.0,-300.0,null,"|",1,11,-2,0,"|",0.0,0.0,"R"]
["R","441500","Other Income",50.0,null,50,0,150.0,null,150,0,50.0,50.0,50.0,50.0,50.0,50.0,50.0,50.0,{"$nulls":4},400.0,{"$f":"IF(MONTH(BN4)>=1,AO39,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP39,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ39,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR39,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS39,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT39,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU39,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV39,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW39,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX39,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY39,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ39,0)","v":0},null,400,0,{"$nulls":14},"|",150.0,150.0,100.0,null,null,"|",1,0.5,0,0,"|",0.0,0.0,"R"]
["R","441650","Pet Fees",null,null,0,0,null,null,0,0,{"$nulls":13},{"$f":"IF(MONTH(BN4)>=1,AO40,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP40,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ40,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR40,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS40,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT40,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU40,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV40,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW40,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX40,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY40,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ40,0)","v":0},null,0,0,{"$nulls":14},"|",{"$nulls":5},"|",0,0,0,0,"|",0.0,0.0,"R"]
["T","","     Other Income",-375.8,0.0,-375.8,0,-914.5,0.0,-914.5,0,50.0,50.0,50.0,50.0,-2950.0,-550.0,11.3,-375.8,0.0,0.0,0.0,0.0,-3664.5,{"$f":"IF(MONTH(BN4)>=1,AO41,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP41,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ41,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR41,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS41,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT41,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU41,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV41,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW41,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX41,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY41,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ41,0)","v":0},0.0,-3664.5,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",-914.5,-2850.0,400.0,-300.0,0.0,"|",1,8.125,-2.333333333,0,"|",-1.0,0.0,"T"]
[{"$nulls":5},"","",null,null,"","",{"$nulls":13},{"$f":"IF(MONTH(BN4)>=1,AO42,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP42,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ42,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR42,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS42,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT42,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU42,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV42,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW42,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX42,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY42,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ42,0)","v":0},null,"","",{"$nulls":14},"|",{"$nulls":5},"|","","","","","|",null,0.0]
["T","","Total Revenue",37663.88,0.0,37663.88,0,112558.07,0.0,112558.07,0,34984.85,38577.0,40349.3,39540.0,36540.0,38940.0,35954.19,37663.88,0.0,0.0,0.0,0.0,302549.22,{"$f":"IF(MONTH(BN4)>=1,AO43,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP43,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ43,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR43,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS43,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT43,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU43,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV43,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW43,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX43,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY43,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ43,0)","v":0},0.0,302549.22,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",112558.07,116429.3,111288.85,112497.13,97114.11,"|",-0.1658962993,0.04619016191,-0.01074054067,0.1584014928,"|",-1.0,1.0,"T"]
["H","","Operating Expenses",0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,{"$f":"IF(MONTH(BN4)>=1,AO44,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP44,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ44,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR44,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS44,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT44,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU44,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV44,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW44,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX44,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY44,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ44,0)","v":0},0.0,0,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",0.0,0.0,0.0,0.0,0.0,"|",0,0,0,0,"|",-1.0,0.0,"H"]
["R","500570","Labor - Other",450.0,null,450,0,1350.0,null,1350,0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,{"$nulls":4},3600.0,{"$f":"IF(MONTH(BN4)>=1,AO45,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP45,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ45,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR45,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS45,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT45,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU45,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV45,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW45,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX45,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY45,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ45,0)","v":0},null,3600,0,{"$nulls":14},"|",1350.0,1350.0,1350.0,1350.0,1350.0,"|",0,0,0,0,"|",0.0,0.0,"R"]
["T","","     Direct Labor",450.0,0.0,450,0,1350.0,0.0,1350,0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,0.0,0.0,0.0,0.0,3600.0,{"$f":"IF(MONTH(BN4)>=1,AO46,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP46,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ46,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR46,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS46,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT46,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU46,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV46,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW46,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX46,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY46,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ46,0)","v":0},0.0,3600,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",1350.0,1350.0,1350.0,1350.0,1350.0,"|",0,0,0,0,"|",-1.0,0.0,"T"]
["T","","   Labor Categories Combined",450.0,0.0,450,0,1350.0,0.0,1350,0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,0.0,0.0,0.0,0.0,3600.0,{"$f":"IF(MONTH(BN4)>=1,AO47,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP47,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ47,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR47,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS47,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT47,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU47,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV47,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW47,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX47,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY47,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ47,0)","v":0},0.0,3600,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",1350.0,1350.0,1350.0,1350.0,1350.0,"|",0,0,0,0,"|",-1.0,1.0,"T"]
["R","676000","Food",5015.77,null,5015.77,0,15263.77,null,15263.77,0,5208.0,4704.0,5208.0,5040.0,5208.0,5040.0,5208.0,5015.77,{"$nulls":4},40631.77,{"$f":"IF(MONTH(BN4)>=1,AO48,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP48,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ48,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR48,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS48,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT48,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU48,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV48,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW48,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX48,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY48,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ48,0)","v":0},null,40631.77,0,{"$nulls":14},"|",15263.77,15456.0,14977.16,17086.84,17868.0,"|",0.1560559006,0.03197134837,-0.1234681193,-0.04371837923,"|",0.0,0.0,"R"]
["T","","     Food",5015.77,0.0,5015.77,0,15263.77,0.0,15263.77,0,5208.0,4704.0,5208.0,5040.0,5208.0,5040.0,5208.0,5015.77,0.0,0.0,0.0,0.0,40631.77,{"$f":"IF(MONTH(BN4)>=1,AO49,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP49,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ49,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR49,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS49,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT49,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU49,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV49,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW49,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX49,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY49,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ49,0)","v":0},0.0,40631.77,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",15263.77,15456.0,14977.16,17086.84,17868.0,"|",0.1560559006,0.03197134837,-0.1234681193,-0.04371837923,"|",-1.0,0.0,"T"]
["R","790300","Promotion - Marketing",null,null,0,0,null,null,0,0,{"$nulls":13},{"$f":"IF(MONTH(BN4)>=1,AO50,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP50,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ50,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR50,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS50,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT50,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU50,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV50,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW50,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX50,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY50,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ50,0)","v":0},null,0,0,{"$nulls":14},"|",{"$nulls":5},"|",0,0,0,0,"|",0.0,0.0,"R"]
["T","","     Advertising & Promotions",0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,{"$f":"IF(MONTH(BN4)>=1,AO51,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP51,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ51,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR51,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS51,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT51,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU51,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV51,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW51,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX51,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY51,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ51,0)","v":0},0.0,0,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",0.0,0.0,0.0,0.0,0.0,"|",0,0,0,0,"|",-1.0,0.0,"T"]
["R","760000","R & M - Apartments",null,null,0,0,null,null,0,0,null,null,null,2150.0,2150.0,{"$nulls":7},4300.0,{"$f":"IF(MONTH(BN4)>=1,AO52,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP52,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ52,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR52,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS52,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT52,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU52,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV52,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW52,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX52,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY52,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ52,0)","v":0},null,4300,0,{"$nulls":14},"|",null,4300.0,null,4111.88,null,"|",1,0,1,0,"|",0.0,0.0,"R"]
["T","","     Repair & Maintenance",0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0.0,2150.0,2150.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,4300.0,{"$f":"IF(MONTH(BN4)>=1,AO53,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP53,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ53,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR53,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS53,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT53,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU53,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV53,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW53,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX53,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY53,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ53,0)","v":0},0.0,4300,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",0.0,4300.0,0.0,4111.88,0.0,"|",1,0,1,0,"|",-1.0,0.0,"T"]
["R","638200","Computer - Maintenance Agreeme",null,null,0,0,-12.15,null,-12.15,0,{"$nulls":4},12.15,-12.15,{"$nulls":7},{"$f":"IF(MONTH(BN4)>=1,AO54,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP54,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ54,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR54,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS54,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT54,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU54,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV54,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW54,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX54,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY54,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ54,0)","v":0},null,0,0,{"$nulls":14},"|",-12.15,12.15,null,null,null,"|",1,0,0,0,"|",0.0,0.0,"R"]
["T","","     Computer Software/Hosting",0.0,0.0,0,0,-12.15,0.0,-12.15,0,0.0,0.0,0.0,0.0,12.15,-12.15,0.0,0.0,0.0,0.0,0.0,0.0,0.0,{"$f":"IF(MONTH(BN4)>=1,AO55,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP55,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ55,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR55,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS55,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT55,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU55,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV55,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW55,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX55,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY55,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ55,0)","v":0},0.0,0,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",-12.15,12.15,0.0,0.0,0.0,"|",1,0,0,0,"|",-1.0,0.0,"T"]
["R","880060","Utilities - Trash",162.0,null,162,0,486.0,null,486,0,162.0,162.0,162.0,162.0,162.0,162.0,162.0,162.0,{"$nulls":4},1296.0,{"$f":"IF(MONTH(BN4)>=1,AO56,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP56,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ56,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR56,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS56,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT56,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU56,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV56,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW56,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX56,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY56,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ56,0)","v":0},null,1296,0,{"$nulls":14},"|",486.0,486.0,486.0,472.5,415.0,"|",-0.146090535,0,0.02857142857,0.1385542169,"|",0.0,0.0,"R"]
["T","","     Utilities",162.0,0.0,162,0,486.0,0.0,486,0,162.0,162.0,162.0,162.0,162.0,162.0,162.0,162.0,0.0,0.0,0.0,0.0,1296.0,{"$f":"IF(MONTH(BN4)>=1,AO57,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP57,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ57,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR57,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS57,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT57,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU57,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV57,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW57,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX57,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY57,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ57,0)","v":0},0.0,1296,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",486.0,486.0,486.0,472.5,415.0,"|",-0.146090535,0,0.02857142857,0.1385542169,"|",-1.0,0.0,"T"]
["R","890010","Bank Charges",null,null,0,0,null,null,0,0,{"$nulls":13},{"$f":"IF(MONTH(BN4)>=1,AO58,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP58,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ58,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR58,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS58,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT58,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU58,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV58,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW58,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX58,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY58,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ58,0)","v":0},null,0,0,{"$nulls":14},"|",null,null,null,-20.0,null,"|",0,0,1,0,"|",0.0,0.0,"R"]
["T","","     Other Expenses",0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,{"$f":"IF(MONTH(BN4)>=1,AO59,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP59,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ59,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR59,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS59,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT59,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU59,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV59,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW59,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX59,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY59,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ59,0)","v":0},0.0,0,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",0.0,0.0,0.0,-20.0,0.0,"|",0,0,1,0,"|",-1.0,0.0,"T"]
[{"$nulls":5},"","",null,null,"","",{"$nulls":13},{"$f":"IF(MONTH(BN4)>=1,AO60,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP60,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ60,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR60,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS60,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT60,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU60,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV60,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW60,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX60,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY60,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ60,0)","v":0},null,"","",{"$nulls":14},"|",{"$nulls":5},"|","","","","","|",null,0.0]
["T","","Total Operating Expenses",5627.77,0.0,5627.77,0,17087.62,0.0,17087.62,0,5820.0,5316.0,5820.0,7802.0,7982.15,5639.85,5820.0,5627.77,0.0,0.0,0.0,0.0,49827.77,{"$f":"IF(MONTH(BN4)>=1,AO61,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP61,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ61,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR61,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS61,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT61,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU61,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV61,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW61,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX61,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY61,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ61,0)","v":0},0.0,49827.77,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",17087.62,21604.15,16813.16,23001.22,19633.0,"|",-0.09123941465,0.2849547616,-0.2690318166,0.1715591097,"|",-1.0,1.0,"T"]
[{"$nulls":5},"","",null,null,"","",{"$nulls":13},{"$f":"IF(MONTH(BN4)>=1,AO62,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP62,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ62,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR62,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS62,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT62,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU62,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV62,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW62,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX62,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY62,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ62,0)","v":0},null,"","",{"$nulls":14},"|",{"$nulls":5},"|","","","","","|",null,0.0]
["T","","Net Operating Income(Loss)",32036.11,0.0,32036.11,0,95470.45,0.0,95470.45,0,29164.85,33261.0,34529.3,31738.0,28557.85,33300.15,30134.19,32036.11,0.0,0.0,0.0,0.0,252721.45,{"$f":"IF(MONTH(BN4)>=1,AO63,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP63,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ63,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR63,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS63,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT63,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU63,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV63,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW63,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX63,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY63,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ63,0)","v":0},0.0,252721.45,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",95470.45,94825.15,94475.69,89495.91,77481.11,"|",-0.1829054845,0.003698940966,0.05564254277,0.1550674739,"|",-1.0,2.0,"T"]
["T",null,"NOI Margin",0.850579,null,0.850579,0,0.848188,null,0.848188,0,0.833642,0.862197,0.855759,0.80268,0.78155,0.855165,0.838127,0.850579,{"$nulls":4},0.835306,{"$f":"IF(MONTH(BN4)>=1,AO64,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP64,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ64,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR64,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS64,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT64,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU64,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV64,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW64,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX64,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY64,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ64,0)","v":0},null,0.835306,0,{"$nulls":14},"|",0.848188,0.814444,0.848923,0.795539,0.797835,"|",-0.02039305342,-0.04061499099,0.06710418974,-0.002877788014,"|",-1.0,null,"T"]
["H","","Non-Operating Expenses",0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,{"$f":"IF(MONTH(BN4)>=1,AO65,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP65,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ65,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR65,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS65,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT65,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU65,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV65,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW65,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX65,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY65,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ65,0)","v":0},0.0,0,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",0.0,0.0,0.0,0.0,0.0,"|",0,0,0,0,"|",-1.0,0.0,"H"]
["R","672600","Fees - Management",2259.83,null,2259.83,0,6753.48,null,6753.48,0,2099.09,2314.62,2420.96,2372.4,2189.4,2336.4,2157.25,2259.83,{"$nulls":4},18149.95,{"$f":"IF(MONTH(BN4)>=1,AO66,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP66,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ66,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR66,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS66,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT66,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU66,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV66,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW66,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX66,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY66,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ66,0)","v":0},null,18149.95,0,{"$nulls":14},"|",6753.48,6982.76,6641.33,6740.54,5826.85,"|",-0.1655376957,0.05140988326,-0.01471840535,0.156806851,"|",0.0,0.0,"R"]
["T","","     Management Fees",2259.83,0.0,2259.83,0,6753.48,0.0,6753.48,0,2099.09,2314.62,2420.96,2372.4,2189.4,2336.4,2157.25,2259.83,0.0,0.0,0.0,0.0,18149.95,{"$f":"IF(MONTH(BN4)>=1,AO67,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP67,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ67,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR67,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS67,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT67,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU67,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV67,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW67,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX67,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY67,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ67,0)","v":0},0.0,18149.95,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",6753.48,6982.76,6641.33,6740.54,5826.85,"|",-0.1655376957,0.05140988326,-0.01471840535,0.156806851,"|",-1.0,0.0,"T"]
[{"$nulls":5},"","",null,null,"","",{"$nulls":13},{"$f":"IF(MONTH(BN4)>=1,AO68,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP68,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ68,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR68,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS68,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT68,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU68,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV68,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW68,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX68,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY68,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ68,0)","v":0},null,"","",{"$nulls":14},"|",{"$nulls":5},"|","","","","","|",null,0.0]
["T","","          Total Other (Income)Expenses",2259.83,0.0,2259.83,0,6753.48,0.0,6753.48,0,2099.09,2314.62,2420.96,2372.4,2189.4,2336.4,2157.25,2259.83,0.0,0.0,0.0,0.0,18149.95,{"$f":"IF(MONTH(BN4)>=1,AO69,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP69,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ69,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR69,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS69,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT69,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU69,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV69,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW69,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX69,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY69,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ69,0)","v":0},0.0,18149.95,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",6753.48,6982.76,6641.33,6740.54,5826.85,"|",-0.1655376957,0.05140988326,-0.01471840535,0.156806851,"|",-1.0,1.0,"T"]
[{"$nulls":5},"","",null,null,"","",{"$nulls":13},{"$f":"IF(MONTH(BN4)>=1,AO70,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP70,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ70,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR70,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS70,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT70,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU70,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV70,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW70,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX70,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY70,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ70,0)","v":0},null,"","",{"$nulls":14},"|",{"$nulls":5},"|","","","","","|",null,0.0]
["T","","          Net Income(Loss) B4 Depr/Amort.",29776.28,0.0,29776.28,0,88716.97,0.0,88716.97,0,27065.76,30946.38,32108.34,29365.6,26368.45,30963.75,27976.94,29776.28,0.0,0.0,0.0,0.0,234571.5,{"$f":"IF(MONTH(BN4)>=1,AO71,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP71,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ71,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR71,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS71,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT71,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU71,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV71,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW71,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX71,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY71,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ71,0)","v":0},0.0,234571.5,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",88716.97,87842.39,87834.36,82755.37,71654.26,"|",-0.1842860833,0.00009142208129,0.06137353987,0.1549260295,"|",-1.0,0.0,"T"]
[{"$nulls":5},"","",null,null,"","",{"$nulls":13},{"$f":"IF(MONTH(BN4)>=1,AO72,0)","v":""},{"$f":"IF(MONTH(BN4)>=2,AP72,0)","v":""},{"$f":"IF(MONTH(BN4)>=3,AQ72,0)","v":""},{"$f":"IF(MONTH(BN4)>=4,AR72,0)","v":""},{"$f":"IF(MONTH(BN4)>=5,AS72,0)","v":""},{"$f":"IF(MONTH(BN4)>=6,AT72,0)","v":""},{"$f":"IF(MONTH(BN4)>=7,AU72,0)","v":""},{"$f":"IF(MONTH(BN4)>=8,AV72,0)","v":""},{"$f":"IF(MONTH(BN4)>=9,AW72,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX72,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY72,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ72,0)","v":0},null,"","",{"$nulls":14},"|",{"$nulls":5},"|","","","","","|",null,0.0]
["T","","Net Income (Loss)",29776.28,0.0,29776.28,0,88716.97,0.0,88716.97,0,27065.76,30946.38,32108.34,29365.6,26368.45,30963.75,27976.94,29776.28,0.0,0.0,0.0,0.0,234571.5,{"$f":"IF(MONTH(BN4)>=1,AO73,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP73,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ73,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR73,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS73,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT73,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU73,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV73,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW73,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX73,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY73,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ73,0)","v":0},0.0,234571.5,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",88716.97,87842.39,87834.36,82755.37,71654.26,"|",-0.1842860833,0.00009142208129,0.06137353987,0.1549260295,"|",-1.0,2.0,"T"]
["T",null,"Net Operating Income(Loss)",32036.11,0.0,32036.11,0,95470.45,0.0,95470.45,0,29164.85,33261.0,34529.3,31738.0,28557.85,33300.15,30134.19,32036.11,0.0,0.0,0.0,0.0,252721.45,{"$f":"IF(MONTH(BN4)>=1,AO74,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP74,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ74,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR74,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS74,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT74,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU74,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV74,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW74,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX74,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY74,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ74,0)","v":0},0.0,252721.45,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",95470.45,94825.15,94475.69,89495.91,77481.11,"|",-0.1829054845,0.003698940966,0.05564254277,0.1550674739,"|",-1.0,null,"T"]
["T",null,"Adjusted Net Operating Income (Loss)",32036.11,0.0,32036.11,0,95470.45,0.0,95470.45,0,29164.85,33261.0,34529.3,31738.0,28557.85,33300.15,30134.19,32036.11,0.0,0.0,0.0,0.0,252721.45,{"$f":"IF(MONTH(BN4)>=1,AO75,0)","v":0},{"$f":"IF(MONTH(BN4)>=2,AP75,0)","v":0},{"$f":"IF(MONTH(BN4)>=3,AQ75,0)","v":0},{"$f":"IF(MONTH(BN4)>=4,AR75,0)","v":0},{"$f":"IF(MONTH(BN4)>=5,AS75,0)","v":0},{"$f":"IF(MONTH(BN4)>=6,AT75,0)","v":0},{"$f":"IF(MONTH(BN4)>=7,AU75,0)","v":0},{"$f":"IF(MONTH(BN4)>=8,AV75,0)","v":0},{"$f":"IF(MONTH(BN4)>=9,AW75,0)","v":0},{"$f":"IF(MONTH(BN4)>=10,AX75,0)","v":0},{"$f":"IF(MONTH(BN4)>=11,AY75,0)","v":0},{"$f":"IF(MONTH(BN4)>=12,AZ75,0)","v":0},0.0,252721.45,0,null,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"|",95470.45,94825.15,94475.69,89495.91,77481.11,"|",-0.1829054845,0.003698940966,0.05564254277,0.1550674739,"|",-1.0,null,"T"]

{"sheet":"CAT","index":1,"n_rows":76,"n_cols":39,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[null,null,"Sonida Senior Living, Inc",{"$nulls":18},"Run Date/Time","2025-09-15T13:33:58.407",null,"|",{"$nulls":5},"|",{"$nulls":4},"|",null,"08/01/2025"]
[null,null,"Property P&L Category Variance Analysis",{"$nulls":21},"|",{"$nulls":5},"|",{"$nulls":4},"|"]
[null,null,"KDC Properties (m1618)",{"$nulls":21},"|",{"$nulls":5},"|",{"$nulls":4},"|"]
[null,null,{"$f":"\"As of \"&TEXT(EOMONTH(AL1,0),\"MMMM DD,  YYYY\")","v":"As of August 31,  2025"},{"$nulls":21},"|",{"$nulls":5},"|",{"$nulls":4},"|"]
[null,null,null,"Current","Prior",null,null,"Current","Prior Year",null,null,"Current","Prior ",null,null,"Current","Prior Year",null,null,"Current","Prior Year",null,null,null,"|",{"$f":"\"Q\"&ROUNDUP(MONTH(Z7)/3,0)","v":"Q3"},"Q2","Q1","Q4","Q3","|",{"$f":"Z5&\" o \"&AA5","v":"Q3 o Q2"},"Q2 o Q1","Q1 o Q4","Q4 o Q3","|"]
[null,null,null,"Month","Month","Incr(Decr)","% Incr(Decr)","Month","Month","Incr(Decr)","% Incr(Decr)","Rolling QTD","Rolling QTD","Incr(Decr)","% Incr(Decr)","Rolling QTD","Rolling QTD","Incr(Decr)","% Incr(Decr)","YTD","YTD","Incr(Decr)","% Incr(Decr)",null,"|","Rolling QTD","Rolling QTD","Rolling QTD","Rolling QTD","Rolling QTD","|","% Incr(Decr)","% Incr(Decr)","% Incr(Decr)","% Incr(Decr)","|"]
[null,null,"Month-Year","Aug-25","Jul-25",null,null,"Aug-25","Aug-24",null,null,"Aug-25","May-25",null,null,"Aug-25","Aug-24",null,null,"Aug-25","Aug-24",null,null,null,"|",{"$f":"TEXT(AL1,\"MMM-YY\")","v":"Aug-25"},"May-25","Feb-25","Nov-24","Aug-24","|",{"$nulls":4},"|"]
[null,null,"Units Occupied",null,null,{"$f":"D8-E8","v":0},{"$f":"IFERROR(F8/E8,0)","v":0},null,null,{"$f":"H8-I8","v":0},{"$f":"IFERROR(J8/I8,0)","v":0},null,null,{"$f":"L8-M8","v":0},{"$f":"IFERROR(N8/M8,0)","v":0},null,null,{"$f":"P8-Q8","v":0},{"$f":"IFERROR(R8/Q8,0)","v":0},null,null,{"$f":"T8-U8","v":0},{"$f":"IFERROR(V8/U8,0)","v":0},null,{"$f":"\"|\"","v":"|"},{"$nulls":5},{"$f":"\"|\"","v":"|"},{"$f":"IFERROR(IF(Z8<=0,-(Z8-AA8)/AA8,(Z8-AA8)/AA8),0)","v":0},0,0,0,{"$f":"\"|\"","v":"|"},"H"]
[null,null,"   Independent Living Occupied",11.9032,11.1613,0.7419,0.06647075161,11.9032,10.8065,1.0967,0.1014852172,11.688166,12.0,-0.311834,-0.02598616667,11.688166,10.268833,1.419333,0.138217556,11.8871,8.248925,3.638175,0.441048379,null,"|",11.688166,12.0,12.010766,11.505366,10.268833,"|",{"$f":"IFERROR(IF(Z9<=0,-(Z9-AA9)/AA9,(Z9-AA9)/AA9),0)","v":-0.02598616667},-0.0008963624801,0.04392732921,0.1204161174,"|","R"]
[null,null,"   Assisted Living Occupied",0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,null,"|",0.0,0.0,0.0,0.0,0.0,"|",{"$f":"IFERROR(IF(Z10<=0,-(Z10-AA10)/AA10,(Z10-AA10)/AA10),0)","v":0},0,0,0,"|","R"]
[null,null,"   Memory Care Occupied",0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,null,"|",0.0,0.0,0.0,0.0,0.0,"|",{"$f":"IFERROR(IF(Z11<=0,-(Z11-AA11)/AA11,(Z11-AA11)/AA11),0)","v":0},0,0,0,"|","R"]
[null,null,"      Total Units Occupied",11.9032,11.1613,0.7419,0.06647075161,11.9032,10.8065,1.0967,0.1014852172,11.688166,12.0,-0.311834,-0.02598616667,11.688166,10.268833,1.419333,0.138217556,11.8871,8.248925,3.638175,0.441048379,null,"|",11.688166,12.0,12.010766,11.505366,10.268833,"|",{"$f":"IFERROR(IF(Z12<=0,-(Z12-AA12)/AA12,(Z12-AA12)/AA12),0)","v":-0.02598616667},-0.0008963624801,0.04392732921,0.1204161174,"|","T"]
[null,null,"Units Available",null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,"|",{"$nulls":5},"|",{"$f":"IFERROR(IF(Z13<=0,-(Z13-AA13)/AA13,(Z13-AA13)/AA13),0)","v":0},0,0,0,"|","H"]
[null,null,"   Independent Living Available",12.0,12.0,0,0,12.0,12.0,0,0,12.0,12.0,0,0,12.0,12.0,0,0,12.0,11.629037,0.370963,0.03189971792,null,"|",12.0,12.0,12.0,12.0,12.0,"|",{"$f":"IFERROR(IF(Z14<=0,-(Z14-AA14)/AA14,(Z14-AA14)/AA14),0)","v":0},0,0,0,"|","R"]
[null,null,"   Assisted Living Available",0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,null,"|",0.0,0.0,0.0,0.0,0.0,"|",{"$f":"IFERROR(IF(Z15<=0,-(Z15-AA15)/AA15,(Z15-AA15)/AA15),0)","v":0},0,0,0,"|","R"]
[null,null,"   Memory Care Available",0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,null,"|",0.0,0.0,0.0,0.0,0.0,"|",{"$f":"IFERROR(IF(Z16<=0,-(Z16-AA16)/AA16,(Z16-AA16)/AA16),0)","v":0},0,0,0,"|","R"]
[null,null,"      Total Units Available",12.0,12.0,0,0,12.0,12.0,0,0,12.0,12.0,0,0,12.0,12.0,0,0,12.0,11.629037,0.370963,0.03189971792,null,"|",12.0,12.0,12.0,12.0,12.0,"|",{"$f":"IFERROR(IF(Z17<=0,-(Z17-AA17)/AA17,(Z17-AA17)/AA17),0)","v":0},0,0,0,"|","T"]
[null,null,"% Occupied",null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,"|",{"$nulls":5},"|",{"$f":"IFERROR(IF(Z18<=0,-(Z18-AA18)/AA18,(Z18-AA18)/AA18),0)","v":0},0,0,0,"|","H","%"]
[null,null,"   Independent Living % Occupied",0.991933,0.930108,0.061825,0.06647077544,0.991933,0.900541,0.091392,0.1014856625,0.974013,1.0,-0.025987,-0.025987,0.974013,0.855736,0.118277,0.138216693,0.990591,0.709338,0.281253,0.3965006809,null,"|",0.974013,1.0,1.000897,0.95878,0.855736,"|",{"$f":"IFERROR(IF(Z19<=0,-(Z19-AA19)/AA19,(Z19-AA19)/AA19),0)","v":-0.025987},-0.0008961961121,0.04392769979,0.1204156422,"|","R","%"]
[null,null,"   Assisted Living % Occupied",0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,null,"|",0.0,0.0,0.0,0.0,0.0,"|",{"$f":"IFERROR(IF(Z20<=0,-(Z20-AA20)/AA20,(Z20-AA20)/AA20),0)","v":0},0,0,0,"|","R","%"]
[null,null,"   Memory Care % Occupied",0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,null,"|",0.0,0.0,0.0,0.0,0.0,"|",{"$f":"IFERROR(IF(Z21<=0,-(Z21-AA21)/AA21,(Z21-AA21)/AA21),0)","v":0},0,0,0,"|","R","%"]
[null,null,"      Total % Occupied",0.991933,0.930108,0.061825,0.06647077544,0.991933,0.900541,0.091392,0.1014856625,0.974013,1.0,-0.025987,-0.025987,0.974013,0.855736,0.118277,0.138216693,0.990591,0.709338,0.281253,0.3965006809,null,"|",0.974013,1.0,1.000897,0.95878,0.855736,"|",{"$f":"IFERROR(IF(Z22<=0,-(Z22-AA22)/AA22,(Z22-AA22)/AA22),0)","v":-0.025987},-0.0008961961121,0.04392769979,0.1204156422,"|","T","%"]
[null,null,"Monthly Rent per Unit (AVG.)",null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,"|",{"$nulls":5},"|",{"$f":"IFERROR(IF(Z23<=0,-(Z23-AA23)/AA23,(Z23-AA23)/AA23),0)","v":0},0,0,0,"|","H","$"]
[null,null,"   Independent Living Rent per Unit",3195.752402,3220.313941,-24.561539,-0.007627063525,3195.752402,3042.315273,153.437129,0.05043432887,3236.109925,3313.313888,-77.203963,-0.02330113162,3236.109925,3152.390344,83.719581,0.02655749189,3220.021283,3344.990256,-124.968973,-0.03736004097,null,"|",3236.109925,3313.313888,3077.484816,3267.957171,3152.390344,"|",{"$f":"IFERROR(IF(Z24<=0,-(Z24-AA24)/AA24,(Z24-AA24)/AA24),0)","v":-0.02330113162},0.07663045835,-0.05828483821,0.03666006249,"|","R","$"]
[null,null,"   Assisted Living Rent per Unit",null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,"|",{"$nulls":5},"|",{"$f":"IFERROR(IF(Z25<=0,-(Z25-AA25)/AA25,(Z25-AA25)/AA25),0)","v":0},0,0,0,"|","R","$"]
[null,null,"   Memory Care Rent per Unit",null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,"|",{"$nulls":5},"|",{"$f":"IFERROR(IF(Z26<=0,-(Z26-AA26)/AA26,(Z26-AA26)/AA26),0)","v":0},0,0,0,"|","R","$"]
[null,null,"      Total Monthly Rent per Unit (AVG.)",3164.18106,3221.326368,-57.145308,-0.01773968281,3164.18106,3042.315273,121.865787,0.04005692246,3210.029414,3234.147222,-24.117808,-0.007457238754,3210.029414,3152.390344,57.63907,0.01828424266,3181.486863,3363.932118,-182.445255,-0.05423571243,null,"|",3210.029414,3234.147222,3088.585968,3259.265575,3152.390344,"|",{"$f":"IFERROR(IF(Z27<=0,-(Z27-AA27)/AA27,(Z27-AA27)/AA27),0)","v":-0.007457238754},0.0471287688,-0.05236750522,0.03390291789,"|","T","$"]
[{"$nulls":24},"|",{"$nulls":5},"|",{"$nulls":4},"|"]
["H","","Revenue",0.0,0.0,{"$f":"IF(C29=\"\",\"\",D29-E29)","v":0},{"$f":"IF(C29=\"\",\"\",IFERROR(IF(E29<=0,-F29/E29,F29/E29),0))","v":0},0.0,0.0,{"$f":"IF(C29=\"\",\"\",H29-I29)","v":0},{"$f":"IF(C29=\"\",\"\",IFERROR(IF(I29<=0,-J29/I29,J29/I29),0))","v":0},0.0,0.0,{"$f":"IF(C29=\"\",\"\",L29-M29)","v":0},{"$f":"IF(C29=\"\",\"\",IFERROR(IF(M29<=0,-N29/M29,N29/M29),0))","v":0},0.0,0.0,{"$f":"IF(C29=\"\",\"\",P29-Q29)","v":0},{"$f":"IF(C29=\"\",\"\",IFERROR(IF(Q29<=0,-R29/Q29,R29/Q29),0))","v":0},0.0,0.0,{"$f":"IF(C29=\"\",\"\",T29-U29)","v":0},{"$f":"IF(C29=\"\",\"\",IFERROR(IF(U29<=0,-V29/U29,V29/U29),0))","v":0},null,{"$f":"\"|\"","v":"|"},0.0,0.0,0.0,0.0,0.0,{"$f":"\"|\"","v":"|"},{"$f":"IF(C29=\"\",\"\",IFERROR(IF(Z29<=0,-(Z29-AA29)/AA29,(Z29-AA29)/AA29),0))","v":0},{"$f":"IF(C29=\"\",\"\",IFERROR(IF(AA29<=0,-(AA29-AB29)/AB29,(AA29-AB29)/AB29),0))","v":0},{"$f":"IF(C29=\"\",\"\",IFERROR(IF(AB29<=0,-(AB29-AC29)/AC29,(AB29-AC29)/AC29),0))","v":0},{"$f":"IF(C29=\"\",\"\",IFERROR(IF(AC29<=0,-(AC29-AD29)/AD29,(AC29-AD29)/AD29),0))","v":0},{"$f":"\"|\"","v":"|"},-1.0,0.0,"H"]
["R","401000","IL Rent",35839.68,33623.55,2216.13,0.06591005411,35839.68,31646.35,4193.33,0.1325059604,105653.23,105570.0,83.23,0.0007883868523,105653.23,90100.35,15552.88,0.1726173095,281677.23,202413.93,79263.3,0.391590144,null,"|",105653.23,105570.0,105681.0,101229.39,90100.35,"|",0.0007883868523,-0.001050330712,0.04397546997,0.1235182771,"|",0.0,0.0,"R"]
["T","","     IL Rent",35839.68,33623.55,2216.13,0.06591005411,35839.68,31646.35,4193.33,0.1325059604,105653.23,105570.0,83.23,0.0007883868523,105653.23,90100.35,15552.88,0.1726173095,281677.23,202413.93,79263.3,0.391590144,null,"|",105653.23,105570.0,105681.0,101229.39,90100.35,"|",0.0007883868523,-0.001050330712,0.04397546997,0.1235182771,"|",-1.0,0.0,"T"]
["R","401400","IL Rent - Second Resident",2200.0,2377.42,-177.42,-0.07462711679,2200.0,1730.43,469.57,0.2713602977,7877.42,13709.3,-5831.88,-0.4253958991,7877.42,8513.76,-636.34,-0.07474253444,24594.57,20826.66,3767.91,0.1809176315,null,"|",7877.42,13709.3,6307.85,11567.74,8513.76,"|",-0.4253958991,1.173371275,-0.4547033388,0.3587110748,"|",0.0,0.0,"R"]
["T","","     IL Rent 2nd Resident",2200.0,2377.42,-177.42,-0.07462711679,2200.0,1730.43,469.57,0.2713602977,7877.42,13709.3,-5831.88,-0.4253958991,7877.42,8513.76,-636.34,-0.07474253444,24594.57,20826.66,3767.91,0.1809176315,null,"|",7877.42,13709.3,6307.85,11567.74,8513.76,"|",-0.4253958991,1.173371275,-0.4547033388,0.3587110748,"|",-1.0,0.0,"T"]
["R","401200","IL Rent Concessions",null,-58.08,58.08,1,null,-500.0,500,1,-58.08,null,-58.08,0,-58.08,-1500.0,1441.92,0.96128,-58.08,-2500.0,2441.92,0.976768,null,"|",-58.08,null,-1100.0,null,-1500.0,"|",0,1,0,1,"|",0.0,0.0,"R"]
["T","","     IL Rent Concessions",0.0,-58.08,58.08,1,0.0,-500.0,500,1,-58.08,0.0,-58.08,0,-58.08,-1500.0,1441.92,0.96128,-58.08,-2500.0,2441.92,0.976768,null,"|",-58.08,0.0,-1100.0,0.0,-1500.0,"|",0,1,0,1,"|",-1.0,0.0,"T"]
["R","440340","Community Fee",null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,-250.0,250,1,null,"|",{"$nulls":5},"|",0,0,0,0,"|",0.0,0.0,"R"]
["T","","     Community Fees",0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,-250.0,250,1,null,"|",0.0,0.0,0.0,0.0,0.0,"|",0,0,0,0,"|",-1.0,0.0,"T"]
["R","441340","Meals - Refunds",-425.8,-38.7,-387.1,-10.00258398,-425.8,null,-425.8,0,-1064.5,-3000.0,1935.5,0.6451666667,-1064.5,null,-1064.5,0,-4064.5,null,-4064.5,0,null,"|",-1064.5,-3000.0,300.0,-300.0,null,"|",0.6451666667,11,-2,0,"|",0.0,0.0,"R"]
["R","441500","Other Income",50.0,50.0,0,0,50.0,null,50,0,150.0,150.0,0,0,150.0,null,150,0,400.0,null,400,0,null,"|",150.0,150.0,100.0,null,null,"|",0,0.5,0,0,"|",0.0,0.0,"R"]
["R","441650","Pet Fees",null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,1500.0,-1500,-1,null,"|",{"$nulls":5},"|",0,0,0,0,"|",0.0,0.0,"R"]
["T","","     Other Income",-375.8,11.3,-387.1,-34.25663717,-375.8,0.0,-375.8,0,-914.5,-2850.0,1935.5,0.679122807,-914.5,0.0,-914.5,0,-3664.5,1500.0,-5164.5,-3.443,null,"|",-914.5,-2850.0,400.0,-300.0,0.0,"|",0.679122807,8.125,-2.333333333,0,"|",-1.0,0.0,"T"]
[{"$nulls":5},"","",null,null,"","",null,null,"","",null,null,"","",null,null,"","",null,"|",{"$nulls":5},"|","","","","","|",null,0.0]
["T","","Total Revenue",37663.88,35954.19,1709.69,0.04755189868,37663.88,32876.78,4787.1,0.1456073253,112558.07,116429.3,-3871.23,-0.03324962016,112558.07,97114.11,15443.96,0.1590290021,302549.22,221990.59,80558.63,0.3628920938,null,"|",112558.07,116429.3,111288.85,112497.13,97114.11,"|",-0.03324962016,0.04619016191,-0.01074054067,0.1584014928,"|",-1.0,1.0,"T"]
["H","","Operating Expenses",0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,null,"|",0.0,0.0,0.0,0.0,0.0,"|",0,0,0,0,"|",-1.0,0.0,"H"]
["R","500570","Labor - Other",450.0,450.0,0,0,450.0,450.0,0,0,1350.0,1350.0,0,0,1350.0,1350.0,0,0,3600.0,3600.0,0,0,null,"|",1350.0,1350.0,1350.0,1350.0,1350.0,"|",0,0,0,0,"|",0.0,0.0,"R"]
["T","","     Direct Labor",450.0,450.0,0,0,450.0,450.0,0,0,1350.0,1350.0,0,0,1350.0,1350.0,0,0,3600.0,3600.0,0,0,null,"|",1350.0,1350.0,1350.0,1350.0,1350.0,"|",0,0,0,0,"|",-1.0,0.0,"T"]
["T","","   Labor Categories Combined",450.0,450.0,0,0,450.0,450.0,0,0,1350.0,1350.0,0,0,1350.0,1350.0,0,0,3600.0,3600.0,0,0,null,"|",1350.0,1350.0,1350.0,1350.0,1350.0,"|",0,0,0,0,"|",-1.0,1.0,"T"]
["R","676000","Food",5015.77,5208.0,-192.23,-0.03691052227,5015.77,8664.0,-3648.23,-0.4210791782,15263.77,15456.0,-192.23,-0.0124372412,15263.77,17868.0,-2604.23,-0.1457482651,40631.77,30132.0,10499.77,0.3484591132,null,"|",15263.77,15456.0,14977.16,17086.84,17868.0,"|",-0.0124372412,0.03197134837,-0.1234681193,-0.04371837923,"|",0.0,0.0,"R"]
["T","","     Food",5015.77,5208.0,-192.23,-0.03691052227,5015.77,8664.0,-3648.23,-0.4210791782,15263.77,15456.0,-192.23,-0.0124372412,15263.77,17868.0,-2604.23,-0.1457482651,40631.77,30132.0,10499.77,0.3484591132,null,"|",15263.77,15456.0,14977.16,17086.84,17868.0,"|",-0.0124372412,0.03197134837,-0.1234681193,-0.04371837923,"|",-1.0,0.0,"T"]
["R","790300","Promotion - Marketing",null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,1500.0,-1500,-1,null,"|",{"$nulls":5},"|",0,0,0,0,"|",0.0,0.0,"R"]
["T","","     Advertising & Promotions",0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,1500.0,-1500,-1,null,"|",0.0,0.0,0.0,0.0,0.0,"|",0,0,0,0,"|",-1.0,0.0,"T"]
["R","760000","R & M - Apartments",null,null,0,0,null,null,0,0,null,4300.0,-4300,-1,null,null,0,0,4300.0,null,4300,0,null,"|",null,4300.0,null,4111.88,null,"|",1,0,1,0,"|",0.0,0.0,"R"]
["T","","     Repair & Maintenance",0.0,0.0,0,0,0.0,0.0,0,0,0.0,4300.0,-4300,-1,0.0,0.0,0,0,4300.0,0.0,4300,0,null,"|",0.0,4300.0,0.0,4111.88,0.0,"|",1,0,1,0,"|",-1.0,0.0,"T"]
["R","638200","Computer - Maintenance Agreeme",null,null,0,0,null,null,0,0,-12.15,12.15,-24.3,-2,-12.15,null,-12.15,0,null,null,0,0,null,"|",-12.15,12.15,null,null,null,"|",2,0,0,0,"|",0.0,0.0,"R"]
["T","","     Computer Software/Hosting",0.0,0.0,0,0,0.0,0.0,0,0,-12.15,12.15,-24.3,-2,-12.15,0.0,-12.15,0,0.0,0.0,0,0,null,"|",-12.15,12.15,0.0,0.0,0.0,"|",2,0,0,0,"|",-1.0,0.0,"T"]
["R","880060","Utilities - Trash",162.0,162.0,0,0,162.0,148.5,13.5,0.09090909091,486.0,486.0,0,0,486.0,415.0,71,0.1710843373,1296.0,914.5,381.5,0.4171678513,null,"|",486.0,486.0,486.0,472.5,415.0,"|",0,0,0.02857142857,0.1385542169,"|",0.0,0.0,"R"]
["T","","     Utilities",162.0,162.0,0,0,162.0,148.5,13.5,0.09090909091,486.0,486.0,0,0,486.0,415.0,71,0.1710843373,1296.0,914.5,381.5,0.4171678513,null,"|",486.0,486.0,486.0,472.5,415.0,"|",0,0,0.02857142857,0.1385542169,"|",-1.0,0.0,"T"]
["R","890010","Bank Charges",null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,"|",null,null,null,-20.0,null,"|",0,0,1,0,"|",0.0,0.0,"R"]
["T","","     Other Expenses",0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,null,"|",0.0,0.0,0.0,-20.0,0.0,"|",0,0,1,0,"|",-1.0,0.0,"T"]
[{"$nulls":5},"","",null,null,"","",null,null,"","",null,null,"","",null,null,"","",null,"|",{"$nulls":5},"|","","","","","|",null,0.0]
["T","","Total Operating Expenses",5627.77,5820.0,-192.23,-0.03302920962,5627.77,9262.5,-3634.73,-0.3924134953,17087.62,21604.15,-4516.53,-0.2090584448,17087.62,19633.0,-2545.38,-0.1296480416,49827.77,36146.5,13681.27,0.3784950133,null,"|",17087.62,21604.15,16813.16,23001.22,19633.0,"|",-0.2090584448,0.2849547616,-0.2690318166,0.1715591097,"|",-1.0,1.0,"T"]
[{"$nulls":5},"","",null,null,"","",null,null,"","",null,null,"","",null,null,"","",null,"|",{"$nulls":5},"|","","","","","|",null,0.0]
["T","","Net Operating Income(Loss)",32036.11,30134.19,1901.92,0.06311501985,32036.11,23614.28,8421.83,0.3566414051,95470.45,94825.15,645.3,0.006805156649,95470.45,77481.11,17989.34,0.2321771074,252721.45,185844.09,66877.36,0.3598573406,null,"|",95470.45,94825.15,94475.69,89495.91,77481.11,"|",0.006805156649,0.003698940966,0.05564254277,0.1550674739,"|",-1.0,2.0,"T"]
["T",null,"NOI Margin",0.850579,0.838127,0.012452,0.01485693696,0.850579,0.718266,0.132313,0.1842116987,0.848188,0.814444,0.033744,0.04143194621,0.848188,0.797835,0.050353,0.06311204698,0.835306,0.837171,-0.001865,-0.002227740808,null,"|",0.848188,0.814444,0.848923,0.795539,0.797835,"|",0.04143194621,-0.04061499099,0.06710418974,-0.002877788014,"|",-1.0,null,"T"]
["H","","Non-Operating Expenses",0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,0.0,0.0,0,0,null,"|",0.0,0.0,0.0,0.0,0.0,"|",0,0,0,0,"|",-1.0,0.0,"H"]
["R","672600","Fees - Management",2259.83,2157.25,102.58,0.04755128057,2259.83,1972.61,287.22,0.1456040474,6753.48,6982.76,-229.28,-0.03283515401,6753.48,5826.85,926.63,0.159027605,18149.95,12111.23,6038.72,0.4986050137,null,"|",6753.48,6982.76,6641.33,6740.54,5826.85,"|",-0.03283515401,0.05140988326,-0.01471840535,0.156806851,"|",0.0,0.0,"R"]
["T","","     Management Fees",2259.83,2157.25,102.58,0.04755128057,2259.83,1972.61,287.22,0.1456040474,6753.48,6982.76,-229.28,-0.03283515401,6753.48,5826.85,926.63,0.159027605,18149.95,12111.23,6038.72,0.4986050137,null,"|",6753.48,6982.76,6641.33,6740.54,5826.85,"|",-0.03283515401,0.05140988326,-0.01471840535,0.156806851,"|",-1.0,0.0,"T"]
[{"$nulls":5},"","",null,null,"","",null,null,"","",null,null,"","",null,null,"","",null,"|",{"$nulls":5},"|","","","","","|",null,0.0]
["T","","          Total Other (Income)Expenses",2259.83,2157.25,102.58,0.04755128057,2259.83,1972.61,287.22,0.1456040474,6753.48,6982.76,-229.28,-0.03283515401,6753.48,5826.85,926.63,0.159027605,18149.95,12111.23,6038.72,0.4986050137,null,"|",6753.48,6982.76,6641.33,6740.54,5826.85,"|",-0.03283515401,0.05140988326,-0.01471840535,0.156806851,"|",-1.0,1.0,"T"]
[{"$nulls":5},"","",null,null,"","",null,null,"","",null,null,"","",null,null,"","",null,"|",{"$nulls":5},"|","","","","","|",null,0.0]
["T","","          Net Income(Loss) B4 Depr/Amort.",29776.28,27976.94,1799.34,0.06431511094,29776.28,21641.67,8134.61,0.3758771851,88716.97,87842.39,874.58,0.009956240945,88716.97,71654.26,17062.71,0.238125549,234571.5,173732.86,60838.64,0.3501849909,null,"|",88716.97,87842.39,87834.36,82755.37,71654.26,"|",0.009956240945,0.00009142208129,0.06137353987,0.1549260295,"|",-1.0,0.0,"T"]
[{"$nulls":5},"","",null,null,"","",null,null,"","",null,null,"","",null,null,"","",null,"|",{"$nulls":5},"|","","","","","|",null,0.0]
["T","","Net Income (Loss)",29776.28,27976.94,1799.34,0.06431511094,29776.28,21641.67,8134.61,0.3758771851,88716.97,87842.39,874.58,0.009956240945,88716.97,71654.26,17062.71,0.238125549,234571.5,173732.86,60838.64,0.3501849909,null,"|",88716.97,87842.39,87834.36,82755.37,71654.26,"|",0.009956240945,0.00009142208129,0.06137353987,0.1549260295,"|",-1.0,2.0,"T"]
["T",null,"Net Operating Income(Loss)",32036.11,30134.19,1901.92,0.06311501985,32036.11,23614.28,8421.83,0.3566414051,95470.45,94825.15,645.3,0.006805156649,95470.45,77481.11,17989.34,0.2321771074,252721.45,185844.09,66877.36,0.3598573406,null,"|",95470.45,94825.15,94475.69,89495.91,77481.11,"|",0.006805156649,0.003698940966,0.05564254277,0.1550674739,"|",-1.0,null,"T"]
["T",null,"Adjusted Net Operating Income (Loss)",32036.11,30134.19,1901.92,0.06311501985,32036.11,23614.28,8421.83,0.3566414051,95470.45,94825.15,645.3,0.006805156649,95470.45,77481.11,17989.34,0.2321771074,252721.45,185844.09,66877.36,0.3598573406,null,"|",95470.45,94825.15,94475.69,89495.91,77481.11,"|",0.006805156649,0.003698940966,0.05564254277,0.1550674739,"|",-1.0,null,"T"]
[{"$nulls":24},"|",{"$nulls":5},"|",{"$nulls":4},"|"]

{"sheet":"CPL","index":2,"n_rows":75,"n_cols":19,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["08/01/2025",null,"Sonida Senior Living, Inc",{"$nulls":11},"Run Date/Time:","2025-09-15T13:33:58.407"]
[null,null,"Category P&L 13 Month Report"]
[null,null,"KDC Properties (m1618)",{"$nulls":11}," "," "]
[{"$nulls":14}," "]
[null,null,{"$f":"\"Cur Per Ending \"&TEXT(EOMONTH(A1,0),\"MMMM DD,  YYYY\")","v":"Cur Per Ending August 31,  2025"},{"$f":"MONTH(D6)","v":8},9,10,11,12,1,2,3,4,5,6,7,8]
[null,null,"Month - Year","Aug-24","Sep-24","Oct-24","Nov-24","Dec-24","Jan-25","Feb-25","Mar-25","Apr-25","May-25","Jun-25","Jul-25","Aug-25"]
[]
[null,null,"Units Occupied",{"$nulls":13},"H"]
[null,null,"   Independent Living Occupied",10.8065,11.0,11.5161,12.0,12.0,12.0323,12.0,12.0,12.0,12.0,12.0,11.1613,11.9032,"R"]
[null,null,"   Assisted Living Occupied",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"R"]
[null,null,"   Memory Care Occupied",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"R"]
[null,null,"      Total Units Occupied",10.8065,11.0,11.5161,12.0,12.0,12.0323,12.0,12.0,12.0,12.0,12.0,11.1613,11.9032,"T"]
[null,null,"Units Available",{"$nulls":13},"H"]
[null,null,"   Independent Living Available",12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,"R"]
[null,null,"   Assisted Living Available",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"R"]
[null,null,"   Memory Care Available",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"R"]
[null,null,"      Total Units Available",12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,"T"]
[null,null,"% Occupied",{"$nulls":13},"H","%"]
[null,null,"   Independent Living % Occupied",0.900541,0.916666,0.959675,1.0,1.0,1.002691,1.0,1.0,1.0,1.0,1.0,0.930108,0.991933,"R","%"]
[null,null,"   Assisted Living % Occupied",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"R","%"]
[null,null,"   Memory Care % Occupied",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"R","%"]
[null,null,"      Total % Occupied",0.900541,0.916666,0.959675,1.0,1.0,1.002691,1.0,1.0,1.0,1.0,1.0,0.930108,0.991933,"T","%"]
[null,null,"Monthly Rent per Unit (AVG.)",{"$nulls":13},"H","$"]
[null,null,"   Independent Living Rent per Unit",3042.315273,3229.727272,3268.739416,3302.25,3118.916666,2903.422454,3210.583333,3358.275,3290.833333,3290.833333,3290.833333,3220.313941,3195.752402,"R","$"]
[null,null,"   Assisted Living Rent per Unit",{"$nulls":13},"R","$"]
[null,null,"   Memory Care Rent per Unit",{"$nulls":13},"R","$"]
[null,null,"      Total Monthly Rent per Unit (AVG.)",3042.315273,3229.727272,3268.739416,3277.25,3143.916666,2907.577936,3214.75,3362.441666,3295.0,3045.0,3245.0,3221.326368,3164.18106,"T","$"]
[]
["H","","Revenue",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,-1.0,0.0,"H"]
["R","401000","IL Rent",31646.35,32227.0,33775.39,35227.0,35227.0,35227.0,35227.0,33190.0,36190.0,36190.0,36190.0,33623.55,35839.68,0.0,0.0,"R"]
["T","","     IL Rent",31646.35,32227.0,33775.39,35227.0,35227.0,35227.0,35227.0,33190.0,36190.0,36190.0,36190.0,33623.55,35839.68,-1.0,0.0,"T"]
["R","401400","IL Rent - Second Resident",1730.43,3300.0,3867.74,4400.0,3300.0,-292.15,3300.0,7109.3,3300.0,3300.0,3300.0,2377.42,2200.0,0.0,0.0,"R"]
["T","","     IL Rent 2nd Resident",1730.43,3300.0,3867.74,4400.0,3300.0,-292.15,3300.0,7109.3,3300.0,3300.0,3300.0,2377.42,2200.0,-1.0,0.0,"T"]
["R","401200","IL Rent Concessions",-500.0,null,null,null,-1100.0,{"$nulls":6},-58.08,null,0.0,0.0,"R"]
["T","","     IL Rent Concessions",-500.0,0.0,0.0,0.0,-1100.0,0.0,0.0,0.0,0.0,0.0,0.0,-58.08,0.0,-1.0,0.0,"T"]
["R","440340","Community Fee",{"$nulls":13},0.0,0.0,"R"]
["T","","     Community Fees",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,-1.0,0.0,"T"]
["R","441340","Meals - Refunds",null,null,null,-300.0,300.0,{"$nulls":4},-3000.0,-600.0,-38.7,-425.8,0.0,0.0,"R"]
["R","441500","Other Income",{"$nulls":5},50.0,50.0,50.0,50.0,50.0,50.0,50.0,50.0,0.0,0.0,"R"]
["R","441650","Pet Fees",{"$nulls":13},0.0,0.0,"R"]
["T","","     Other Income",0.0,0.0,0.0,-300.0,300.0,50.0,50.0,50.0,50.0,-2950.0,-550.0,11.3,-375.8,-1.0,0.0,"T"]
[{"$nulls":17},0.0]
["T","","Total Revenue",32876.78,35527.0,37643.13,39327.0,37727.0,34984.85,38577.0,40349.3,39540.0,36540.0,38940.0,35954.19,37663.88,-1.0,1.0,"T"]
["H","","Operating Expenses",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,-1.0,0.0,"H"]
["R","500570","Labor - Other",450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,0.0,0.0,"R"]
["T","","     Direct Labor",450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,-1.0,0.0,"T"]
["T","","   Labor Categories Combined",450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,450.0,-1.0,1.0,"T"]
["R","676000","Food",8664.0,5400.0,5926.84,5760.0,5065.16,5208.0,4704.0,5208.0,5040.0,5208.0,5040.0,5208.0,5015.77,0.0,0.0,"R"]
["T","","     Food",8664.0,5400.0,5926.84,5760.0,5065.16,5208.0,4704.0,5208.0,5040.0,5208.0,5040.0,5208.0,5015.77,-1.0,0.0,"T"]
["R","790300","Promotion - Marketing",{"$nulls":13},0.0,0.0,"R"]
["T","","     Advertising & Promotions",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,-1.0,0.0,"T"]
["R","760000","R & M - Apartments",null,null,4111.88,{"$nulls":5},2150.0,2150.0,null,null,null,0.0,0.0,"R"]
["T","","     Repair & Maintenance",0.0,0.0,4111.88,0.0,0.0,0.0,0.0,0.0,2150.0,2150.0,0.0,0.0,0.0,-1.0,0.0,"T"]
["R","638200","Computer - Maintenance Agreeme",{"$nulls":9},12.15,-12.15,null,null,0.0,0.0,"R"]
["T","","     Computer Software/Hosting",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,12.15,-12.15,0.0,0.0,-1.0,0.0,"T"]
["R","880060","Utilities - Trash",148.5,148.5,162.0,162.0,162.0,162.0,162.0,162.0,162.0,162.0,162.0,162.0,162.0,0.0,0.0,"R"]
["T","","     Utilities",148.5,148.5,162.0,162.0,162.0,162.0,162.0,162.0,162.0,162.0,162.0,162.0,162.0,-1.0,0.0,"T"]
["R","890010","Bank Charges",null,null,-20.0,{"$nulls":10},0.0,0.0,"R"]
["T","","     Other Expenses",0.0,0.0,-20.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,-1.0,0.0,"T"]
[{"$nulls":17},0.0]
["T","","Total Operating Expenses",9262.5,5998.5,10630.72,6372.0,5677.16,5820.0,5316.0,5820.0,7802.0,7982.15,5639.85,5820.0,5627.77,-1.0,1.0,"T"]
[{"$nulls":17},0.0]
["T","","Net Operating Income(Loss)",23614.28,29528.5,27012.41,32955.0,32049.84,29164.85,33261.0,34529.3,31738.0,28557.85,33300.15,30134.19,32036.11,-1.0,2.0,"T"]
["T",null,"NOI Margin",0.718266,0.831156,0.717592,0.837973,0.849519,0.833642,0.862197,0.855759,0.80268,0.78155,0.855165,0.838127,0.850579,-1.0,null,"T"]
["H","","Non-Operating Expenses",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,-1.0,0.0,"H"]
["R","672600","Fees - Management",1972.61,2131.62,2249.3,2359.62,2227.62,2099.09,2314.62,2420.96,2372.4,2189.4,2336.4,2157.25,2259.83,0.0,0.0,"R"]
["T","","     Management Fees",1972.61,2131.62,2249.3,2359.62,2227.62,2099.09,2314.62,2420.96,2372.4,2189.4,2336.4,2157.25,2259.83,-1.0,0.0,"T"]
[{"$nulls":17},0.0]
["T","","          Total Other (Income)Expenses",1972.61,2131.62,2249.3,2359.62,2227.62,2099.09,2314.62,2420.96,2372.4,2189.4,2336.4,2157.25,2259.83,-1.0,1.0,"T"]
[{"$nulls":17},0.0]
["T","","          Net Income(Loss) B4 Depr/Amort.",21641.67,27396.88,24763.11,30595.38,29822.22,27065.76,30946.38,32108.34,29365.6,26368.45,30963.75,27976.94,29776.28,-1.0,0.0,"T"]
[{"$nulls":17},0.0]
["T","","Net Income (Loss)",21641.67,27396.88,24763.11,30595.38,29822.22,27065.76,30946.38,32108.34,29365.6,26368.45,30963.75,27976.94,29776.28,-1.0,2.0,"T"]
["T",null,"Net Operating Income(Loss)",23614.28,29528.5,27012.41,32955.0,32049.84,29164.85,33261.0,34529.3,31738.0,28557.85,33300.15,30134.19,32036.11,-1.0,null,"T"]
["T",null,"Adjusted Net Operating Income (Loss)",23614.28,29528.5,27012.41,32955.0,32049.84,29164.85,33261.0,34529.3,31738.0,28557.85,33300.15,30134.19,32036.11,-1.0,null,"T"]

{"sheet":"VAR","index":3,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,2,3,9]]}
[]
[null,null,"MONTHLY OPERATING REVIEW - EXPENSE VARIANCES"]
[]
[]
[null,null,"Community Name: ","KDC Properties (m1618)",null,null,null,"Month:  ",{"$f":"TEXT(EOMONTH(K5,0),\"MMMM YYYY\")","v":"August 2025"},null,"08/01/2025"]
[]
[null,null,"Operating Expense Categories","Actuals","Budget","Variance","Variance %","Explanation","Action Plan"]
[null,null,"     Direct Labor",450.0,0.0,-450.0,{"$f":"IFERROR(F8/E8,0)","v":0}]
[null,null,"     Labor - Salary & Wages - Allocated",0.0,0.0,0.0,0]
[null,null,"     Other Labor",0.0,0.0,0.0,0]
[null,null,"     Contract/Consulting",0.0,0.0,0.0,0]
[null,null,"     Vacation",0.0,0.0,0.0,0]
[null,null,"     Bonuses",0.0,0.0,0.0,0]
[null,null,"     Payroll Taxes",0.0,0.0,0.0,0]
[null,null,"     Benefits",0.0,0.0,0.0,0]
[null,null,"     Employee Benefits - Allocated",0.0,0.0,0.0,0]
[null,null,"     Other Employee Costs",0.0,0.0,0.0,0]
[null,null,"     Food",5015.77,0.0,-5015.77,0]
[null,null,"     Legal & Professional Fees",0.0,0.0,0.0,0]
[null,null,"     Advertising & Promotions",0.0,0.0,0.0,0]
[null,null,"     Repair & Maintenance",0.0,0.0,0.0,0]
[null,null,"     R & M - Furniture",0.0,0.0,0.0,0]
[null,null,"     Service Contracts",0.0,0.0,0.0,0]
[null,null,"     Computer Software/Hosting",0.0,0.0,0.0,0]
[null,null,"     Computer - Leads",0.0,0.0,0.0,0]
[null,null,"     Printing",0.0,0.0,0.0,0]
[null,null,"     Postage",0.0,0.0,0.0,0]
[null,null,"     Supplies",0.0,0.0,0.0,0]
[null,null,"     Utilities",162.0,0.0,-162.0,0]
[null,null,"     Telephone",0.0,0.0,0.0,0]
[null,null,"     Telephone - Fax",0.0,0.0,0.0,0]
[null,null,"     Bad Debt",0.0,0.0,0.0,0]
[null,null,"     Insurance",0.0,0.0,0.0,0]
[null,null,"     Real Estate/CAT Taxes",0.0,0.0,0.0,0]
[null,null,"     Other Expenses",0.0,0.0,0.0,0]
[null,null,"     Collection Fees",0.0,0.0,0.0,0]
[null,null,"     Pursuit Costs",0.0,0.0,0.0,0]
[null,null,"     Lease – REIT",0.0,0.0,0.0,0]
[null,null,"Total Operating Expenses",5627.77,0.0,-5627.77,0]

{"sheet":"Exec Summary","index":4,"n_rows":62,"n_cols":13,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,2,3,9],[4,3,4,6],[27,2,27,9],[28,2,28,9],[29,2,33,9],[34,2,34,9],[35,2,35,9],[45,2,45,4],[46,2,46,4],[36,2,41,9],[42,2,42,9],[43,2,43,4],[43,5,43,9],[44,2,44,4],[44,5,44,9],[45,5,45,9],[53,2,53,4],[54,2,54,4],[55,2,55,4],[54,5,54,9],[55,5,55,9],[56,2,56,9],[57,2,59,9],[60,2,60,9],[61,2,61,9],[62,2,65,9],[46,5,46,9],[47,2,47,9],[48,2,50,9],[51,2,51,9],[52,2,52,4],[52,5,52,9],[53,5,53,9]]}
[]
[null,null,"MONTHLY OPERATING REVIEW - EXECUTIVE SUMMARY"]
[]
[]
[null,null,"Community Name: ","KDC Properties (m1618)",{"$nulls":4},"Month:  ",{"$f":"TEXT(L5,\"MMMM YYYY\")","v":"August 2025"},null,"08/01/2025"]
[]
[null,null,null,"Current Month","Budget","Difference","Prior Month","Difference","Prior Year Month","Difference"]
[null,null,"Occupancy %",0.991933,0.916666,{"$f":"+D8-E8","v":0.075267},0.930108,{"$f":"+D8-G8","v":0.061825},0.900541,{"$f":"+D8-I8","v":0.091392}]
[null,null,"Avg Rent",3164.18106,0.0,3164.18106,3221.326368,-57.145308,3042.315273,121.865787]
[null,null,"Revenue",{"$f":"VLOOKUP(\"Total Revenue\",BUD!$C$1:$D$999,2,0)","v":37663.88},{"$f":"VLOOKUP(\"Total Revenue\",BUD!$C$1:$E$999,3,0)","v":0},37663.88,{"$f":"VLOOKUP(\"Total Revenue\",CAT!$C$1:$E$999,3,0)","v":35954.19},1709.69,{"$f":"VLOOKUP(\"Total Revenue\",CAT!$C$1:$I$999,7,0)","v":32876.78},4787.1]
[null,null,"Operating Expense",{"$f":"VLOOKUP(\"Total Operating Expenses\",BUD!$C$1:$D$999,2,0)","v":5627.77},{"$f":"VLOOKUP(\"Total Operating Expenses\",BUD!$C$1:$E$999,3,0)","v":0},5627.77,{"$f":"VLOOKUP(\"Total Operating Expenses\",CAT!$C$1:$E$999,3,0)","v":5820},-192.23,{"$f":"VLOOKUP(\"Total Operating Expenses\",CAT!$C$1:$I$999,7,0)","v":9262.5},-3634.73,null,null,"`"]
[null,null,"NOI",{"$f":"VLOOKUP(\"Net Operating Income(Loss)\",BUD!$C$1:$D$999,2,0)","v":32036.11},{"$f":"VLOOKUP(\"Net Operating Income(Loss)\",BUD!$C$1:$E$999,3,0)","v":0},32036.11,{"$f":"VLOOKUP(\"Net Operating Income(Loss)\",CAT!$C$1:$E$999,3,0)","v":30134.19},1901.92,{"$f":"VLOOKUP(\"Net Operating Income(Loss)\",CAT!$C$1:$I$999,7,0)","v":23614.28},8421.83]
[null,null,"NOI %",{"$f":"IFERROR(D12/D10,0)","v":0.8505791225},0,0.8505791225,{"$f":"IFERROR(G12/G10,0)","v":0.8381273504},0.0124517721,{"$f":"IFERROR(I12/I10,0)","v":0.7182662049},0.1323129176]
[]
[null,null,null,"YTD","Budget","Difference","Prior YTD","Difference"]
[null,null,"Occupancy %",0.990591,0.916666,{"$f":"+D16-E16","v":0.073925},0.709338,{"$f":"+D16-G16","v":0.281253}]
[null,null,"Avg Rent",3581.395167,0.0,3581.395167,3308.354849,273.040318]
[null,null,"Revenue",{"$f":"VLOOKUP(\"Total Revenue\",CAT!$C$1:$T$999,18,0)","v":302549.22},{"$f":"VLOOKUP(\"Total Revenue\",BUD!$C$1:$AK$999,35,0)","v":0},302549.22,{"$f":"VLOOKUP(\"Total Revenue\",CAT!$C$1:$U$999,19,0)","v":221990.59},80558.63]
[null,null,"Operating Expense",{"$f":"VLOOKUP(\"Total Operating Expenses\",CAT!$C$1:$T$999,18,0)","v":49827.77},{"$f":"VLOOKUP(\"Total Operating Expenses\",BUD!$C$1:$AK$999,35,0)","v":0},49827.77,{"$f":"VLOOKUP(\"Total Operating Expenses\",CAT!$C$1:$U$999,19,0)","v":36146.5},13681.27]
[null,null,"NOI",{"$f":"VLOOKUP(\"Net Operating Income(Loss)\",CAT!$C$1:$T$999,18,0)","v":252721.45},{"$f":"VLOOKUP(\"Net Operating Income(Loss)\",BUD!$C$1:$AK$999,35,0)","v":0},252721.45,{"$f":"VLOOKUP(\"Net Operating Income(Loss)\",CAT!$C$1:$U$999,19,0)","v":185844.09},66877.36]
[null,null,"NOI %",{"$f":"IFERROR(D20/D18,0)","v":0.8353068965},0,0.8353068965,{"$f":"IFERROR(G20/G18,0)","v":0.837171026},-0.001864129522]
[]
[null,null,null,"IL","AL","MC","Total"]
[null,null,"Move-Ins",1.0,0.0,0.0,{"$f":"+D24+E24+F24","v":1}]
[null,null,"Move-Outs",null,null,null,0]
[null,null,"Net",{"$f":"+D24-D25","v":1},0,0,1]
[]
[null,null,"People"]
[null,null,"Describe action steps with retention, new hires and recruitment efforts, key open positions, and Relias compliance"]
[]
[]
[]
[]
[]
[null,null,"Quality & Service, Regulatory, Clinical Care Management"]
[null,null,"High-level report on regulatory activity, clinical outcomes (falls, wounds, rehospitalizations), incident reporting, actions to improve outcomes and resident satisfaction"]
[]
[]
[]
[]
[]
[]
[null,null,"Growth"]
[null,null,"Top 3 growth activities",null,null,"Outcome"]
[null,null,"1) ",null,null,"1) "]
[null,null,"2) ",null,null,"2) "]
[null,null,"3) ",null,null,"3) "]
[null,null,"Additional Comments and Short-Term Outlook:"]
[]
[]
[]
[null,null,"Expense Management"]
[null,null,"Top 3 areas of focus ",null,null,"Outcome"]
[null,null,"1) ",null,null,"1) "]
[null,null,"2) ",null,null,"2) "]
[null,null,"3) ",null,null,"3) "]
[null,null,"Additional Comments:"]
[]
[]
[]
[null,null,"Capital Expenditures"]
[null,null,"List any outstanding needs:"]