{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":32,"n_cols":21,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,0,2,20],[3,1,3,4],[3,5,3,8],[3,9,3,12],[3,13,3,16],[3,17,3,20]]}
["4 story ALF ….75 ALF UNITS + 25 Memory care units ",{"$nulls":18},"Issued 7/18/2025 "]
["Total Building area of 106,000 Sq ft with a foot print of 29,000 Sq ft Ground floor with 11 ALF units , 11,000 Sq ft amenities and 9,000 Sq ft service area - Please check the conceptual building design "]
["Operating Proforma - Independent Living"]
[null,"Year 1 - As-Built",null,null,null,"Year 2 - As-Stabilized 3% increase / year",null,null,null,"Year 3",null,null,null,"Year 4",null,null,null,"Year 5"]
[null,"%","Total","Per Unit","Per SF","%","Total","Per Unit","Per SF","%","Total","Per Unit","Per SF","%","Total","Per Unit","Per SF","%","Total","Per Unit","Per SF"]
["REVENUE"]
["Gross Potential Revenue",null,8238000,{"$f":"C7/100","v":82380},{"$f":"C7/93668","v":87.948925993936029},null,9055489,{"$f":"G7/100","v":90554.89},{"$f":"G7/93668","v":96.676442328223089},null,9621695,{"$f":"K7/100","v":96216.95},{"$f":"K7/93668","v":102.72126019558441},null,{"$f":"K7*1.03","v":9910345.8499999996},{"$f":"O7/100","v":99103.458499999993},{"$f":"O7/93668","v":105.80289800145194},null,10207657,{"$f":"S7/100","v":102076.57},{"$f":"S7/93668","v":108.97699321006107}]
[" Utility Reimb $112K Other inc",null,238448,2384.48,2.5456719477302814,null,245601,2456.0100000000002,2.6220374087201606,null,252970,2529.6999999999998,2.7007088867062392,null,260559,2605.59,2.781729085706965,null,268375,2683.75,2.8651727377546226]
["Gross Rental Income",null,{"$f":"SUM(C7:C8)","v":8476448},84764.479999999996,90.494597941666314,null,{"$f":"SUM(G7:G8)","v":9301090},93010.9,99.29847973694325,null,{"$f":"SUM(K7:K8)","v":9874665},98746.65,105.42196908229064,null,10170905,101709.05,108.58462868855959,null,10476032,104760.32000000001,111.84216594781569]
[]
[]
["Effective Gross Rent",null,8476448,{"$f":"C12/100","v":84764.479999999996},{"$f":"C12/93668","v":90.494597941666314},null,9301090,{"$f":"G12/100","v":93010.9},{"$f":"G12/93668","v":99.29847973694325},null,9874665,{"$f":"K12/100","v":98746.65},{"$f":"K12/93668","v":105.42196908229064},null,10170905,{"$f":"O12/100","v":101709.05},{"$f":"O12/93668","v":108.58462868855959},null,10476032,{"$f":"S12/100","v":104760.32000000001},{"$f":"S12/93668","v":111.84216594781569}]
[]
["EXPENSES"]
[]
["Management Fee (% EGI)",0.03,{"$f":"B16*C12","v":254293.44},{"$f":"C16/100","v":2542.9344000000001},{"$f":"C16/93668","v":2.7148379382499894},0.03,{"$f":"F16*G12","v":279032.7},{"$f":"G16/100","v":2790.3270000000002},{"$f":"G16/93668","v":2.9789543921082977},0.03,{"$f":"J16*K12","v":296239.95},{"$f":"K16/100","v":2962.3995},{"$f":"K16/93668","v":3.1626590724687196},0.03,{"$f":"N16*O12","v":305127.14999999997},{"$f":"O16/100","v":3051.2714999999998},{"$f":"O16/93668","v":3.2575388606567874},0.03,{"$f":"R16*S12","v":314280.95999999996},{"$f":"S16/100","v":3142.8095999999996},{"$f":"S16/93668","v":3.3552649784344704}]
["Payroll",0.245,334968,3349.68,3.5761199128838022,0.25,363651,3636.51,3.8823397531707733,0.25,386077,3860.77,4.1217598326002474,0.25,397659,3976.59,4.2454093180168258,0.25,409589,4095.89,4.3727740530383912]
["Utilities",8.6999999999999994E-2,408000,4080,4.3558098817098685,8.6999999999999994E-2,414630,4146.3,4.4265917922876543,8.6999999999999994E-2,440199,4401.99,4.6995665542127512,8.6999999999999994E-2,453405,4534.05,4.8405538711192726,8.6999999999999994E-2,467007,4670.07,4.9857688858521589]
["Repairs & Maintenance",1.9E-2,336000,3360,3.5871375496434212,1.9124597659845009E-2,195724,1957.24,2.0895503266857411,1.9E-2,207794,2077.94,2.2184097023529916,1.8801049266646636E-2,214028,2140.2800000000002,2.2849639151044112,1.9271075498312799E-2,220448,2204.48,2.3535038647136695]
["Admin, Marketing & Activities",0.04,58725,587.25,0.62694837084169619,0.04,63754,637.54,0.6806379980356152,0.04,67685,676.85,0.72260537216552079,0.04,69716,697.16,0.74428833753256185,0.04,70807,708.07,0.75593585856429091]
["Food costs",null,199923,1999.23,2.1343788700516719,null,200000,2000,2.1352009224067983,null,200000,2000,2.1352009224067983,null,200000,2000,2.1352009224067983,null,200000,2000,2.1352009224067983]
["Insurance",4.2999999999999997E-2,140940,1409.4,1.5046760900200709,4.2999999999999997E-2,153009,1530.09,1.6335247896827092,4.2999999999999997E-2,162445,1624.45,1.734263569201862,4.2999999999999997E-2,167318,1673.18,1.7862877396763035,4.2999999999999997E-2,172338,1723.38,1.8398812828287141]
["Property Taxes *(c) (1/2 of 3%)",1.4999999999999999E-2,441620,4416.2,4.7147371567664518,1.4999999999999999E-2,305000,3050,3.2561814066703678,1.4999999999999999E-2,305000,3050,3.2561814066703678,1.4999999999999999E-2,305000,3050,3.2561814066703678,1.4999999999999999E-2,305000,3050,3.2561814066703678]
["Total Expenses",0.55800000000000005,{"$f":"SUM(C16:C23)","v":2174469.44},{"$f":"SUM(D16:D23)","v":21744.6944},{"$f":"SUM(E16:E23)","v":23.214645770166968},{"$f":"SUM(F16:F23)","v":0.484124597659845},{"$f":"SUM(G16:G23)","v":1974800.7},{"$f":"SUM(H16:H23)","v":19748.007000000001},{"$f":"SUM(I16:I23)","v":21.082981381047958},0.55800000000000005,{"$f":"SUM(K16:K23)","v":2065439.95},{"$f":"SUM(L16:L23)","v":20654.3995},{"$f":"SUM(M16:M23)","v":22.050646432079258},0.55800000000000005,{"$f":"SUM(O16:O23)","v":2112253.15},{"$f":"SUM(P16:P23)","v":21122.531500000001},{"$f":"SUM(Q16:Q23)","v":22.550424371183329},0.55800000000000005,{"$f":"SUM(S16:S23)","v":2159469.96},{"$f":"SUM(T16:T23)","v":21594.6996},{"$f":"SUM(U16:U23)","v":23.05451125250886}]
[null,null,null,{"$f":"C25/100","v":0},null,null,null,{"$f":"G25/100","v":0},null,null,null,{"$f":"K25/100","v":0},null,null,null,{"$f":"O25/100","v":0},null,null,null,{"$f":"S25/100","v":0}]
["NET OPERATING INCOME",{"$f":"C26/C12","v":0.74346926448436901},{"$f":"C12-C24","v":6301978.5600000005},63019.785600000003,{"$f":"C26/93668","v":67.279952171499346},{"$f":"G26/G12","v":0.78768072344209117},{"$f":"G12-G24","v":7326289.2999999998},73262.892999999996,{"$f":"G26/93668","v":78.215498355895292},{"$f":"K26/K12","v":0.79083442830718809},{"$f":"K12-K24","v":7809225.0499999998},78092.250499999995,{"$f":"K26/93668","v":83.371322650211383},0.81453227017381424,{"$f":"O12-O24","v":8058651.8499999996},80586.518499999991,{"$f":"O26/93668","v":86.034204317376265},0.8153457371652334,{"$f":"S12-S24","v":8316562.04},83165.6204,{"$f":"S26/93668","v":88.787654695306827}]
[null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Capital Reserve",null,25000,250,{"$f":"C28/93668","v":0.26690011530084978},null,25000,250,{"$f":"G28/93668","v":0.26690011530084978},null,25000,250,{"$f":"K28/93668","v":0.26690011530084978},null,25000,250,{"$f":"O28/93668","v":0.26690011530084978},null,25000,250,{"$f":"S28/93668","v":0.26690011530084978}]
["Total Leasing & Capital",null,{"$f":"+C28","v":25000},250,0.26690011530084978,null,{"$f":"+G28","v":25000},250,{"$f":"G29/93668","v":0.26690011530084978},null,{"$f":"+K28","v":25000},250,0.26690011530084978,null,{"$f":"+O28","v":25000},250,0.26690011530084978,null,{"$f":"+S28","v":25000},250,0.26690011530084978]
[null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["OPERATING NET CASH FLOW",{"$f":"C31/C12","v":0.74051991588929711},{"$f":"C26-C29","v":6276978.5600000005},62769.785600000003,{"$f":"C31/93668","v":67.013052056198489},{"$f":"G31/G12","v":0.78499286642748323},{"$f":"G26-G29","v":7301289.2999999998},73012.892999999996,{"$f":"G31/93668","v":77.948598240594436},{"$f":"K31/K12","v":0.78830269685098175},{"$f":"K26-K29","v":7784225.0499999998},77842.250499999995,{"$f":"K31/93668","v":83.104422534910526},{"$f":"O31/O12","v":0.78986598046093237},{"$f":"O26-O29","v":8033651.8499999996},80336.518499999991,{"$f":"O31/93668","v":85.767304202075408},{"$f":"S31/S12","v":0.79147925855896584},{"$f":"S26-S29","v":8291562.04},82915.6204,{"$f":"S31/93668","v":88.520754580005985}]
["Other Income"]