Spreadsheet: 80866d1281031520-combining-match-and-index-functions-test
Sheet: L

 | OPERATING EXPENSE INTERNAL WORKSHEET/COMPARISON, YOU NEED TO MANUALLY LINK THE PROPERTY NAME W/ EACH COMP # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 2 | 1
 | MANAGEMENT FEE IS [NAME], BUT IS BASED ON 5% OF EGI.  CHANGE AS NEEDED. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Operating Expense Year |  |  | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2007 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2009 | 2009 | 2008 | 2009 | 2009 | 2009 | 2009 | 2009 | 2008 | 2009 | 2009 | 2009 | 2009
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comp | s | l | i | g | 1 | Community |  |  | a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z | aa | bb | cc | dd | ee
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Address |  |  |  |  | 2 | Address
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | City | 0 | 0 | 0 | 0 | 3 | City/Township
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Units | 0 | 0 | 0 | 0 | 4 | County
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GPI | 2009 | 2009 | 2009 | 0 | 5 | Comparable ID
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EGI | -70.8507718696398 | -34 | -3914.861111111111 | 0 | 6 | Owner
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Garden |  |  |  |  | Other Inc. | 0 | 0 | 0 | 0 | 7 | 0-bed Units |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | This Data is Linked to Income App. |  |  |  | Subject Data |  |  |  |  |  | IREM |  | Comp | Comp | Comp |  | Comp | Comp | Comp | Comp | 8 | 0-bed [NAME]. Unit [NAME] |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Administrative |  |  |  | Conclusion, Trended (HUD) | Trended/Unit | Conclusion, before Trend |  | 2009 Actual | 2008 Actual | 2006-2009 Avg | [NAME] | Min |  | Median/Unit |  | Average | [NAME] | Min |  | 1 | 2 | 3 | 4 | 9 | 1-bed Units |  |  | 0 | 58 | 0 | 80 | 192 | 148 | 36 | 104 | 54 | 0 | 32 | 0 | 40 | 8 | 40 | 12 | 0 | 16 | 80 | 0 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 64 | 0 | 0 | 0
 |  | 1 | Advertising |  | 25889 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | n/a |  | 0.001094125591333365 | 0.004376502365333459 | 0 |  | 0 | 0 | 0.004376502365333459 | 0 | 10 | 1-bed Avg. Unit [NAME] |  |  | 0 | 588.0689655172414 | 0 | 921 | 1066.666666666667 | 945.1351351351351 | 915 | 956.9230769230769 | 1186 | 0 | 961 | 0 | 812 | 800 | 681 | 661 | 0 | 760 | 921 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900 | 0 | 0 | 0
 |  | 2 | Management Fees |  | #N/A | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 11 | 2-bed Units |  |  | 90 | 37 | 32 | 172 | 392 | 476 | 124 | 268 | 164 | 17 | 52 | 12 | 152 | 48 | 32 | 8 | 0 | 61 | 172 | 0 | 80 | 0 | 0 | 0 | 0 | 0 | 0 | 144 | 0 | 112 | 42
 |  | 3 | Other |  | 34519 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | 79.0415702495481 | 223.1666666666667 | 0 |  | 66.7598627787307 | 26.23975155279503 | 223.1666666666667 | 0 | 12 | 2-bed Avg. Unit [NAME] |  |  | 1548.577777777778 | 956.3243243243244 | 768 | 1188 | 1204.479591836735 | 1365.079831932773 | 1108.790322580645 | 1343.731343283582 | 1280 | 2227 | 1319.923076923077 | 867 | 1049 | 925 | 750 | 750 | 0 | 1060.393442622951 | 1188 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1100 | 0 | 1197 | 1464
 |  | 4 | Total Admnistrative |  | #N/A | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | 246.6552816560661 | 456.2916666666667 | 0 |  | 264.9897084048027 | 265.339751552795 | 456.2916666666667 | 0 | 13 | 3-bed Units |  |  | 58 | 5 | 92 | 0 | 0 | 0 | 80 | 48 | 42 | 104 | 46 | 204 | 64 | 8 | 0 | 4 | 0 | 15 | 0 | 72 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 55 | 0
 | Operating |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 3-bed [NAME]. Unit [NAME] |  |  | 1765.344827586207 | 1145 | 1120 | 0 | 0 | 0 | 1267.6 | 2404.166666666667 | 1554 | 2160 | 1448.260869565217 | 1078 | 1187 | 1050 | 0 | 921 | 0 | 1172 | 0 | 1392 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1370 | 0
 |  | 5 | Elevator |  | 0 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | n/a |  | 391.3441813319531 | 786.0972222222222 | 0 |  | 435 | 344.27950310559 | 786.0972222222222 | 0 | 15 | 4-bed Units |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 6 | Fuel |  | 0 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | n/a |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 16 | 4-bed [NAME]. Unit [NAME] |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 7 | Lighting & Misc. Power |  | 19848 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 17 | Market/Restricted/Subsidized |  |  | Market | Section 8 Subsidized | Market | Market | Market | Market | Market | Market | Market | Market | Market | Market | LIHTC, 60% | Restricted/Market | Restricted/Market | Restricted | Market | Market | Market | Market | Market | Market | Market | Market | Market | Market | Market | Market | Section 8 | Market | Market
 |  | 8 | Water |  | 19848 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 18 | Age Restricted |  |  | Not Age Restricted | 54 Senior, 36 Unrestricted | Not Age Restricted | Not Age Restricted | Not Age Restricted | Not Age Restricted | Not Age Restricted | Not Age Restricted | Not Age Restricted | Not Age Restricted | Not Age Restricted | Not Age Restricted | Not Age Restricted | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | Partially | No | No
 |  | 9 | Gas |  | 12945 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | 51.53098549659255 | 90.83333333333333 | 0 |  | 64.1303602058319 | 51.16024844720497 | 90.83333333333333 | 0 | 19 | Year Built |  |  | 1997 | 1980 | 1960's | 1980's | 2000 | 1988-1998 | 2000 | 1989 | 2001 | 2002 | 2003 | 1985/2002 | 2000 | 1994 | n/a | n/a | 2004 | 2003 | 1985 | 2002 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1979 | 0 | 2001 | 2000
 |  | 10 | Trash Removal |  | 11219 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | n/a |  | 126.8456880787839 | 204.8902229845626 | 0 |  | 204.8902229845626 | 189.339751552795 | 113.1527777777778 | 0 | 20 | Design |  |  | Garden/Townhome | Garden/Townhome | Garden | Garden | Garden/Townhome | Garden/Townhome | Garden/Townhome | Garden/Townhome | Garden/Townhome | Garden/Townhome | Garden/Townhome | Garden/Townhome | Garden | Flats | Flats | Flats | Flats/Loft | Flats | Flats | Flats | Flats | Flats | Flats | Flats | Flats | Flats | Hi-Rise | Flats | Flats | Flats, Thome | Flats
 |  | 11 | Payroll |  | 127719 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | 203.6820984514073 | 491.6298136645963 | 0 |  | 238.4596912521441 | 491.6298136645963 | 84.63888888888889 | 0 | 21 | [NAME] |  |  | None | Varies, Some W/S, T, & Heat | W/S, T | None | W/S, T | T | T | None | None | None | None | W/S, T | W/S, T | W/S, T | W/S, T | W/S, T | None | None | Trash | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Heat, W, T | W/S, T | 0 | 0 | Trash
 |  | 12 | Other |  | 1726 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | n/a |  | 14.37242177428806 | 33.31987577639752 | 0 |  | 24.16981132075472 | 33.31987577639752 | 0 | 0 | 22 | Total Units |  |  | 148 | 100 | 124 | 252 | 584 | 624 | 240 | 420 | 260 | 121 | 130 | 216 | 256 | 64 | 72 | 24 | 88 | 92 | 252 | 72 | 104 | 1610 | 583 | 222 | 252 | 216 | 108 | 208 | 125 | 167 | 42
 |  | 13 | Total Operating |  | 193305 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | n/a |  | 415.7130162000291 | 705.1097770154374 | 0 |  | 705.1097770154374 | 658.7006211180125 | 299.0416666666667 | 0 | 23 | Expense Year |  |  | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2007 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2009 | 2009 | 2008 | 2009 | 2009 | 2009 | 2009 | 2009 | 2008 | 2009 | 2009 | 2009 | 2009 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Maintenance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | Income |  |  | Total $ | Total $ | Total $ | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit | $/Unit
 |  | 14 | Decorating |  | 38834 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | 816.7483766677675 | 1424.150310559006 | 0 |  | 1236.759862778731 | 1424.150310559006 | 606.0833333333334 | 0 | 25 | Rental Income |  |  | 24121.91891891892 | 7546.56 | 10240.56451612903 | 11607.59920634921 | 12273.97773972603 | 9632.166666666666 | 12750.36666666667 | n/a | 17057.30769230769 | 24660.50413223141 | 16323.5 | 8581.902777777777 | 10101.6875 | 8549.671875 | 5525.509305555556 | 5225.243333333333 | 9236.022727272728 | 8317.825 | 11618.59126984127 | 20620.33333333333 | 8699.185961538462 | 5642.719875776397 | 6417.739279588336 | 8536.17117117117 | 6081.789682539683 | 6688.449074074074 | 5875.777777777777 | 6782.54326923077 | 8121.16 | 22517.76 | 18501.59523809524
 |  | 15 | Repairs |  | 34519 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 26 | Other Income |  |  | 267.3513513513514 | 83.38 | 444.3951612903226 | 475.5198412698413 | 561.2619863013699 | 235.724358974359 | 339.2833333333334 | n/a | 281.9846153846154 | 776.0743801652893 | 569.223076923077 | 295.7777777777778 | 764.63671875 | 103.75 | 94.92430555555556 | 210.65 | 312.1477272727273 | 435.6979347826086 | 423.718253968254 | 414.75 | 694.6214423076924 | 263.1900621118012 | 250.4202401372213 | 153.2117117117117 | 264.7103174603175 | 33.18509316770187 | 229.9351851851852 | 232.1490384615385 | 95.248 | 463.592 | 205.3333333333333
 |  | 16 | Exterminating |  | 1726 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | n/a |  | 104.9826614542827 | 243.7916666666667 | 0 |  | 88.778730703259 | 87.36024844720497 | 243.7916666666667 | 0 | 27 | Total Income |  |  | 24389.27027027027 | 7629.94 | 10684.95967741935 | 12083.11904761905 | 12835.2397260274 | 9867.891025641025 | 13089.65 | 12000.42819047619 | 17339.29230769231 | 25436.57851239669 | 16892.72307692308 | 8877.680555555555 | 10866.32421875 | 8653.421875 | 5620.433611111112 | 5435.893333333333 | 9548.170454545454 | 8753.522934782608 | 12042.30952380952 | 21035.08333333333 | 9393.807403846153 | 5905.909937888198 | 6668.159519725557 | 8689.382882882883 | 6346.5 | 930.5173913043478 | 6105.712962962963 | 7014.692307692308 | 8216.408 | 22981.352 | 18706.92857142857
 |  | 17 | Insurance |  | 28478 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | 304.1761196874404 | 729.0600343053173 | 0 |  | 729.0600343053173 | 349.7 | 137.9444444444445 | 0 | 28 | Vacancy |  |  | -2580.871621621622 | -393.8 | -1328.225806451613 | -2658.698412698413 | -1322.436643835616 | 0 | -1798.5875 | n/a | -2011.419230769231 | -3517.98347107438 | -2375.438461538462 | n/a | -143.99609375 | -1205.078125 | -937.4568055555555 | -519.2483333333333 | -418.4659090909091 | -1050.473152173913 | -2407.321428571428 | -2693.847222222222 | -974.2214423076923 | -1024.229813664596 | -1045.929674099486 | -835.0495495495495 | -934.218253968254 | -141.7683229813665 | 0 | 0 | -42.832 | -2186.656 | -1446.238095238095
 |  | 18 | Ground Expenses |  | 61271 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 29 | Concessions |  |  | -3185.506756756757 | 0 | -574.9354838709677 | -1042.892857142857 | -1328.607876712329 | 0 | -1646.091666666667 | n/a | -2933.384615384615 | -3788.454545454545 | -2958.592307692308 | n/a | -362.0546875 | -1276.8125 | -242.0459722222222 | 0 | -473.3295454545454 | -108.2294565217391 | -807.5873015873016 | -3914.861111111111 | -238.4605769230769 | -34 | -70.8507718696398 | -124.9504504504504 | -24.51984126984127 | -7.828571428571428 | 0 | 0 | 0 | -3163.744 | -2671.452380952381
 |  | 19 | Other |  | 3452 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | 113.7850015817971 | 250.3194444444445 | 0 |  | 107.2006861063465 | 97.61987577639752 | 250.3194444444445 | 0 | 30 | Other Income Adjustments |  |  | 0 | -4.81 | -364.0725806451613 | -161.2777777777778 | -309.1849315068493 | 0 | -73.17083333333333 | n/a | 0 | 0 | 0 | n/a | -215.828125 | -145.125 | -42.71166666666667 | 12.29541666666667 | 0 | 0 | -59.87698412698413 | -98.40277777777777 | -81.92307692307692 | -133.960248447205 | -126.7392795883362 | -49.16216216216216 | -69.92857142857143 | -14.81552795031056 | 0 | 0 | -0.456 | -1097.24 | 0
 |  | 20 | Total Maintenance |  | 168280 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | n/a |  | 80.5151907567412 | 226.9005145797599 | 0 |  | 226.9005145797599 | 95.16024844720496 | 0 | 0 | 31 | EGI |  |  | 18622.89189189189 | 7231.33 | 8417.725806451614 | 8220.25 | 9875.010273972603 | 9867.891025641025 | 9571.8 | 12000.42819047619 | 12394.48846153846 | 18130.14049586777 | 11558.69230769231 | 8877.680555555555 | 10144.4453125 | 6026.40625 | 4398.219166666667 | 4928.940416666667 | 8656.375 | 7594.820326086956 | 8767.52380952381 | 14327.97222222222 | 8099.202307692307 | 4713.719875776397 | 5424.639794168096 | 7680.220720720721 | 5317.833333333333 | 766.1049689440994 | 6105.712962962963 | 7014.692307692308 | 8173.12 | 16533.712 | 14589.2380952381
 |  | 21 | Replacement Allowance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | Total Operating Expenses |  |  | 5201.236486486487 | 5155.37 | 5735.919354838709 | 5393.075396825397 | 4935.248287671233 | 5282.04967948718 | 5343.179166666667 | 5562.342333333333 | 5383.569230769231 | 8152.330578512397 | 5981.507692307692 | 4462.699074074074 | 6606.87890625 | 3907.5625 | 3617.976805555556 | 3732.369583333333 | 4474.693181818182 | 4533.578369565217 | 5160.436428571428 | 4514.861111111111 | 4465.075009615384 | 3002.8 | 3538.020583190395 | 3828.423423423424 | 3488.845238095238 | 477.6360248447205 | 4628.87962962963 | 3979.836538461539 | 3755.832 | 6339.096 | 6560.619047619048
 | Taxes |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  | 33 | Expenses as % of GPI |  |  | 0 | 0 | 0.004329208115748101 | 0.001771156334734802 | 0.0006584035667630631 | 0.0008578148240906922 | 0.001700828251922532 | 0.001103599972602036 | 0.001194168431763081 | 0.002648730168148686 | 0.002723752554494422 | 0.002327256959986563 | 0.002375055281620143 | 0 | 0 | 0 | 0.005325500460961919 | 0.005629507813401013 | 0.001700497923185985 | 0.002981039025484614 | 0.004570395336870079 | 0.0003158011529665779 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.002206692104102491 | 0.008350126255256898
 |  | 23 | Real Estate Taxes |  | #N/A | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | 1812.666114813315 | 2823.699828473413 | 0 |  | 2823.699828473413 | 2398.270186335404 | 2028.694444444444 | 0 | 34 | Expenses as % of EGI |  |  | 0 | 0 | 0.00549523888227292 | 0.002603460094832301 | 0.0008557730454366153 | 0.0008578148240906922 | 0.002325920571656092 | 0.001103599972602036 | 0.001670584112221478 | 0.003716167169009187 | 0.003980692314347306 | 0.002327256959986563 | 0.002544064257090357 | 0 | 0 | 0 | 0.005874143178527361 | 0.006488372817310998 | 0.002335656313058034 | 0.004376502365333459 | 0.005300943466150685 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.003067234266570024 | 0.01070687957793261
 |  | 24 | Personal Prop. Taxes |  | #N/A | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | n/a |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 35 | Administrative |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 25 | Payroll Tax |  | 13807 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | n/a |  | 925.3293087620609 | 2486.166666666667 | 0 |  | 714.3207547169811 | 500.8298136645963 | 2486.166666666667 | 0 | 36 |  | 1 | Advertising | 173.5135135135135 | 0 | 184.5322580645161 | 213.7738095238095 | 53.41438356164384 | 103.7179487179487 | 184.8083333333333 | 125.0855 | 135.7961538461539 | 223.0082644628099 | 360.4538461538461 | 10.36574074074074 | 161.4296875 | 80.328125 | 129.3168055555556 | 30.23625 | 178.1818181818182 | 180.1327173913043 | 204.781746031746 | 223.1666666666667 | 150.1176923076923 | 26.23975155279503 | 66.7598627787307 | 147.6891891891892 | 84.26190476190476 | 80.51851851851852 | 101.2222222222222 | 29.36538461538462 | 33.336 | 203.904 | 196.0952380952381
 |  | 26 | Employee Benefits |  | 6904 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | n/a |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 37 |  | 2 | Management | 931.1418918918919 | 453.5 | 420.8870967741935 | 328.8095238095238 | 261.611301369863 | 361.2740384615385 | 317.4583333333333 | 603.2499285714285 | 429.5269230769231 | 877.9834710743802 | 577.9307692307692 | 443.8842592592592 | 1098.90234375 | 481 | 413.9861111111111 | 452.7083333333333 | 392.1931818181818 | 371.7139130434783 | 0 | 456.2916666666667 | 389.6092307692307 | 265.339751552795 | 264.9897084048027 | 265.5495495495496 | 265.2896825396825 | 265.1388888888889 | 21.06481481481481 | 418.0528846153846 | 473.424 | 616.904 | 699
 |  | 27 | Other |  | 0 | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | n/a |  | 25.925 | 103.7 | 0 |  | 0 | 103.7 | 0 | 0 | 38 |  | 3 | Other Administrative | 148.9527027027027 | 384.99 | 13.83870967741935 | 249.5992063492064 | 643.5376712328767 | 224.9823717948718 | 274.3041666666667 | 134.7700476190476 | 342.0076923076923 | 333.6611570247934 | 216.9384615384615 | 222.6898148148148 | 411.30859375 | 340.984375 | 331.5295833333333 | 253.2354166666667 | 447.8636363636364 | 438.708695652174 | 205.3147222222222 | 106.6388888888889 | 350.8617307692307 | 52.7 | 103.2504288164666 | 73.47297297297297 | 89.82142857142857 | 74.63888888888889 | 193.9351851851852 | 137.8173076923077 | 298.44 | 151.376 | 253.7380952380952
 |  | 28 | Total Taxes |  | #N/A | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | n/a |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 39 |  | 4 | Total Administrative | 1253.608108108108 | 838.49 | 619.258064516129 | 792.1825396825396 | 958.5633561643835 | 689.974358974359 | 776.5708333333333 | 863.1054761904761 | 907.3307692307692 | 1434.652892561983 | 1155.323076923077 | 676.9398148148148 | 1671.640625 | 902.3125 | 874.8325 | 736.18 | 1018.238636363636 | 990.5553260869565 | 410.0964682539682 | 786.0972222222222 | 890.5886538461539 | 344.27950310559 | 435 | 486.7117117117117 | 439.3730158730158 | 420.2962962962963 | 316.2222222222222 | 585.2355769230769 | 805.2 | 972.184 | 1148.833333333333
 |  | 29 | Total Operating Expenses |  | #N/A | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 40 | Operating |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 |  | 5 | Elevator | 0 | 0 | 0 | 0 | 1.220890410958904 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 70.47222222222223 | 0 | 60.936 | 0 | 0
 |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 |  | 6 | Fuel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43 |  | 7 | Lighting & Power | -32.56081081081081 | 214.2 | 202.8951612903226 | 82.69047619047619 | 144.9263698630137 | 65.09935897435898 | 125.8583333333333 | 276.356380952381 | 81.15 | 129.5867768595041 | 221.3615384615385 | 65.75 | 73.85546875 | 85.515625 | 114.6140277777778 | 256.855 | 140.4772727272727 | 85.78684782608696 | 108.6720634920635 | 90.83333333333333 | 124.5185576923077 | 51.16024844720497 | 64.1303602058319 | 56.04054054054054 | 49.40873015873016 | 88.19907407407408 | 184.7592592592593 | 511.2932692307692 | 153.112 | 182.48 | 75.85714285714286
 |  |  |  |  | 275460 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 |  | 8 | Water | 37.87162162162162 | 392.44 | 289.1048387096774 | 201.0634920634921 | 188.541095890411 | 226.7451923076923 | 380.1958333333333 | 224.0873333333333 | 49.49230769230769 | 349.8264462809917 | 46.43076923076923 | 393.6435185185185 | 660.34375 | 196.140625 | 348.9368055555555 | 245.6258333333334 | 3.784090909090909 | 747.9965217391303 | 242.896746031746 | 113.1527777777778 | 308.93625 | 189.339751552795 | 204.8902229845626 | 181.7612612612613 | 181.2698412698413 | 192.7222222222222 | 388.5277777777778 | 0 | 186.776 | 150.312 | 447.952380952381
 |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 |  | 9 | Gas | -54.77027027027027 | 534.31 | 245.0967741935484 | 76.22619047619048 | 76.48801369863014 | 49.12019230769231 | 28.62083333333333 | 220.0837380952381 | 67.6576923076923 | 39.29752066115702 | 87.33846153846154 | 23.64814814814815 | 10.53515625 | 78.71875 | 103.9601388888889 | 561.92 | 57.27272727272727 | 47.97543478260869 | 53.66869047619048 | 84.63888888888889 | 44.96288461538462 | 491.6298136645963 | 238.4596912521441 | 423.9504504504504 | 210.5515873015873 | 233.8101851851852 | 873.2962962962963 | 0 | 290.96 | 105.168 | 73.5952380952381
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46 |  | 10 | Garbage & Trash Removal | 23.32432432432432 | 0 | 95.93548387096774 | 40.45634920634921 | 36.75513698630137 | 0 | 36.30833333333333 | 18.08128571428572 | 59.61153846153846 | 39.51239669421488 | 37.17692307692307 | 45.17592592592592 | 55.171875 | 46.71875 | 74.31722222222223 | 155.2058333333333 | 36.71590909090909 | 39.07358695652174 | 49.20964285714286 | 0 | 0 | 33.31987577639752 | 24.16981132075472 | 28.14864864864865 | 27.01984126984127 | 27.51851851851852 | 43.46296296296296 | 32.875 | 58.472 | 89.808 | 67.83333333333333
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47 |  | 11 | Payroll | 807.4594594594595 | 1273.76 | 792.0322580645161 | 546.7301587301587 | 1051.635273972603 | 642.2403846153846 | 921.4833333333333 | 1105.776785714286 | 892.8307692307692 | 866.1404958677685 | 1053.476923076923 | 730.4953703703703 | 1328.171875 | 389.875 | 641.7579166666668 | 673.2366666666667 | 612.8977272727273 | 634.9361956521738 | 832.6549603174602 | 299.0416666666667 | 819.8695192307691 | 658.7006211180125 | 705.1097770154374 | 706.7027027027027 | 728.531746031746 | 668.5324074074074 | 1027.166666666667 | 797.6201923076923 | 929.84 | 987.272 | 785.6904761904761
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 |  | 12 | Other Operating | 231.6081081081081 | 0 | 134.5725806451613 | 32.52380952380953 | 4.585616438356165 | 43.1875 | 149.6 | 33.05978571428572 | 39.77692307692308 | 104.6528925619835 | 0 | 16.93518518518519 | 0 | 16.78125 | 3.06 | 0 | 0 | 0 | 0 | 18.41666666666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 31.528 | 22.59523809523809
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49 |  | 13 | Total Operating | 1012.932432432432 | 2414.71 | 1759.637096774194 | 979.6904761904761 | 1504.152397260274 | 1026.392628205128 | 1642.066666666667 | 1877.445309523809 | 1190.519230769231 | 1529.01652892562 | 1445.784615384615 | 1275.648148148148 | 2128.078125 | 813.75 | 1286.646111111111 | 1892.843333333333 | 851.1477272727273 | 1555.768586956522 | 1287.102103174603 | 606.0833333333334 | 1298.287211538461 | 1424.150310559006 | 1236.759862778731 | 1396.603603603604 | 1196.781746031746 | 1210.782407407407 | 2587.685185185185 | 1341.788461538461 | 1680.096 | 1546.568 | 1473.52380952381
 |  |  |  |  |  |  |  |  |  |  |  |  | 231.16 |  |  |  |  |  |  |  |  |  |  |  | 50 | Maintenance
 |  |  |  |  |  |  |  |  |  |  |  |  | 57.79 |  |  |  |  |  |  |  |  |  |  |  | 51 |  | 14 | Decorating | 211.9864864864865 | 0 | 644.7822580645161 | 743.1230158730159 | 294.4452054794521 | 239.7804487179487 | 309.3125 | 190.0452380952381 | 243.5461538461539 | 315.0082644628099 | 253.2307692307692 | 284.8472222222222 | 249.07421875 | 104.140625 | 65.50458333333331 | 5.625833333333333 | 204.1136363636364 | 226.9292391304348 | 586.0445634920635 | 243.7916666666667 | 156.3173076923077 | 87.36024844720497 | 88.778730703259 | 89.25675675675676 | 70.34920634920636 | 87.61111111111111 | 45.47222222222222 | 130.1971153846154 | 70.04 | 249.344 | 292.6666666666667
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52 |  | 15 | Repairs | 125.5608108108108 | 0 | 613.4596774193549 | 631.3055555555555 | 236.6883561643835 | 928.4871794871794 | 156.6166666666667 | 394.2600238095239 | 218.5769230769231 | 150.9669421487603 | 122.0461538461538 | 416.1527777777778 | 197.1640625 | 761.421875 | 217.8465277777778 | 26.99583333333333 | 406.0340909090909 | 206.6991304347826 | 677.8690873015872 | 137.9444444444445 | 115.5261538461538 | 349.7 | 729.0600343053173 | 349.8918918918919 | 609.9285714285714 | 623.8703703703703 | 673.7592592592592 | 668.7451923076923 | 266.096 | 200.376 | 188.8095238095238
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53 |  | 16 | Exterminating | 7.013513513513513 | 0 | 20.35483870967742 | 13.88095238095238 | 8.159246575342467 | 0 | 9.416666666666666 | 6.061333333333334 | 6.219230769230769 | 16.19834710743802 | 15.10769230769231 | 0 | 5.68359375 | 13.015625 | 9.569444444444445 | 27.91666666666667 | 9.238636363636363 | 8.834673913043478 | 8.854166666666666 | 0 | 7.454038461538461 | 0 | 0 | 0 | 0 | 0 | 22.17592592592593 | 6.913461538461538 | 14.68 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54 |  | 17 | Insurance | 253.5135135135135 | 369.76 | 184.9516129032258 | 213.4801587301587 | 163.4486301369863 | 182.4583333333333 | 291.6875 | 279.9846428571429 | 165.2884615384615 | 281.8181818181818 | 324.3615384615385 | 219.1898148148148 | 287.56640625 | 0 | 167.6383333333333 | 162.5041666666667 | 203.2613636363636 | 124.2090217391304 | 224.2065873015873 | 250.3194444444445 | 106.0127884615385 | 97.61987577639752 | 107.2006861063465 | 113.4684684684685 | 118.7301587301587 | 109.4583333333333 | 177.6018518518518 | 169.2067307692308 | 163.904 | 214.76 | 194.2619047619048
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55 |  | 18 | Ground Expense | 277.7027027027027 | 0 | 235.3709677419355 | 308.0952380952381 | 244.5530821917808 | 586.8189102564103 | 204.7041666666667 | 135.1118571428571 | 328.9076923076923 | 433.9586776859504 | 460.7384615384615 | 268.2037037037037 | 293.16015625 | 276.609375 | 126.7402777777778 | 241.1891666666667 | 229.8409090909091 | 234.2259782608696 | 255.4613095238095 | 0 | 230.1627884615385 | 95.16024844720496 | 226.9005145797599 | 211.9684684684685 | 326.1428571428572 | 257.3657407407408 | 78.85185185185185 | 21.97596153846154 | 81.376 | 479.632 | 687.8809523809524
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56 |  | 19 | Other | 0 | 0 | 85.86290322580645 | 0 | 0 | 375.2259615384615 | 33.25833333333333 | 74.13635714285715 | 1.576923076923077 | 0 | 0 | 0 | 1.47265625 | 0 | 0 | 0 | 0 | 0 | 0 | 4.458333333333333 | 3.248173076923077 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10.6 | 23.256 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57 |  | 20 | Total Maintenance | 875.777027027027 | 1511.4 | 1784.782258064516 | 1909.884920634921 | 947.2945205479452 | 2312.770833333333 | 1004.995833333333 | 1079.599452380952 | 964.1153846153846 | 1197.95041322314 | 1175.484615384615 | 1188.393518518518 | 1034.12109375 | 1155.1875 | 587.2991666666666 | 464.2316666666667 | 1052.488636363636 | 800.8980434782608 | 1752.435714285714 | 636.5138888888889 | 618.72125 | 629.8403726708075 | 1151.939965694683 | 764.5855855855856 | 1125.150793650794 | 1078.305555555556 | 997.8611111111111 | 997.0384615384615 | 606.696 | 1167.368 | 1363.619047619048
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58 | Replacement Reserve |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59 |  | 21 | Replacement Reserve
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 | TotalOperating Expenses Incl. Reserve |  |  | 3142.317567567567 | 4764.6 | 4163.677419354839 | 3681.757936507936 | 3410.010273972603 | 4029.13782051282 | 3423.633333333333 | 3820.150238095238 | 3061.965384615385 | 4161.619834710744 | 3776.592307692308 | 3140.981481481481 | 4833.83984375 | 2871.25 | 2748.777777777778 | 3093.255 | 2921.875 | 3347.221956521739 | 3449.634285714286 | 2028.694444444444 | 2807.597115384615 | 2398.270186335404 | 2823.699828473413 | 2647.900900900901 | 2761.305555555556 | 2709.384259259259 | 3901.768518518519 | 2924.0625 | 3091.992 | 3686.12 | 3985.97619047619
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 61 | Taxes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62 |  | 23 | Real Estate Taxes | 1949.695945945946 | 243.88 | 1572.241935483871 | 1652.464285714286 | 1432.388698630137 | 1100.690705128205 | 1615.241666666667 | 1634.589547619048 | 2139.803846153846 | 3838.082644628099 | 2038.561538461538 | 1321.717592592593 | 1511.2421875 | 894.1875 | 703.4401388888889 | 541.10125 | 1260.625 | 961.1109782608696 | 1664.372222222222 | 2486.166666666667 | 1466.339817307692 | 500.8298136645963 | 714.3207547169811 | 1074.171171171171 | 626.8690476190476 | 750.1018518518518 | 611.5 | 1036.168269230769 | 487.664 | 2523.56 | 2435.761904761905
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63 |  | 24 | Personal Property Tax | 0 | 0 | 0 | 0 | 1.38013698630137 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 110.2045454545455 | 0.9977173913043479 | 0 | 0 | 0.3796153846153846 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64 |  | 25 | Emp. Payroll Tax | 86.58783783783784 | 122.22 | 0 | 0 | 20.24486301369863 | 36.48717948717949 | 192.4458333333333 | 0 | 100.6961538461538 | 111.8429752066116 | 100.1846153846154 | 0 | 109.44921875 | 80.765625 | 91.4538888888889 | 98.01333333333334 | 77.76136363636364 | 62.02010869565218 | 0 | 0 | 105.7905769230769 | 103.7 | 0 | 106.3513513513514 | 100.6706349206349 | 100.6712962962963 | 113.8981481481482 | 0 | 68.928 | 107.552 | 98.28571428571429
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65 |  | 26 | Employee Benefits | 22.63513513513514 | 0 | 0 | 58.8531746031746 | 62.65753424657535 | 115.7339743589744 | 111.8583333333333 | 87.07214285714286 | 81.10384615384615 | 40.78512396694215 | 66.16923076923077 | 0 | 67.73828125 | 61.359375 | 74.305 | 0 | 104.2272727272727 | 142.0210869565217 | 46.42992063492063 | 0 | 84.96788461538462 | 0 | 0 | 0 | 0 | 0 | 1.712962962962963 | 0 | 107.248 | 21.864 | 40.59523809523809
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66 |  | 27 | Other | 0 | 24.67 | 0 | 0 | 8.566780821917808 | 0 | 0 | 20.53040476190476 | 0 | 0 | 0 | 0 | 84.609375 | 0 | 0 | 0 | 0 | 20.20652173913043 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19.60576923076923 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67 |  | 28 | Total Taxes | 2058.918918918919 | 390.77 | 1572.241935483871 | 1711.31746031746 | 1525.23801369863 | 1252.911858974359 | 1919.545833333333 | 1742.192095238095 | 2321.603846153846 | 3990.710743801653 | 2204.915384615384 | 1321.717592592593 | 1773.0390625 | 1036.3125 | 869.1990277777778 | 639.1145833333334 | 1552.818181818182 | 1186.356413043478 | 1710.802142857143 | 2486.166666666667 | 1657.477894230769 | 604.5298136645963 | 714.3207547169811 | 1180.522522522522 | 727.5396825396825 | 850.7731481481482 | 727.1111111111111 | 1055.774038461539 | 663.84 | 2652.976 | 2574.642857142857
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68 | Total Expenses |  |  | 5201.236486486487 | 5155.37 | 5735.919354838709 | 5393.075396825397 | 4935.248287671233 | 5282.04967948718 | 5343.179166666667 | 5562.342333333333 | 5383.569230769231 | 8152.330578512397 | 5981.507692307692 | 4462.699074074074 | 6606.87890625 | 3907.5625 | 3617.976805555556 | 3732.369583333333 | 4474.693181818182 | 4533.578369565217 | 5160.436428571428 | 4514.861111111111 | 4465.075009615384 | 3002.8 | 3538.020583190395 | 3828.423423423424 | 3488.845238095238 | 3560.157407407407 | 4628.87962962963 | 3979.836538461539 | 3755.832 | 6339.096 | 6560.619047619048