Spreadsheet: 80360d1280520030-pivot-table-rolling-averages-averages
Sheet: Actuals

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rolling Averages
 |  | 0 | 0 | 0 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  | 12 | 9 | 6 | 3
 |  | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00
Scheduled Rental Income |  | 0 | 0 | 0 | 338613 | 338840 | 338330 | 339065 | 338415 | 339150 | 338415 | 338340 | 338340 | 338440 | 338518 | 338440 | 338440 | 338440 | 338440 | 338374 | 338440 | 340960 | 340960 | 340960 | 340960 | 342290 | 342290 | 342290 | 342290 | 342290 | 0 | 0 | 0 | 0 | 0 | 0 |  | 4090544 | 4100386.666666667 | 4104820 | 4107480
Loss To Lease |  | 0 | 0 | 0 | -410 | -124 | -21 | -198 | -2366 | -1263 | -337 | -998 | -1799 | -585 | -960 | 162 | -738 | -2655 | -2815 | -282 | -304 | -2480 | -2958 | -1259 | -2146 | -3617 | -3813 | -3003 | -2705 | -2379 | 0 | 0 | 0 | 0 | 0 | 0 |  | -27761 | -32480 | -35326 | -32348
POTENTIAL RENTAL INCOME |  | 0 | 0 | 0 | 338203 | 338716 | 338309 | 338867 | 336049 | 337887 | 338078 | 337342 | 336541 | 337855 | 337558 | 338602 | 337702 | 335785 | 335625 | 338092 | 338136 | 338480 | 338002 | 339701 | 338814 | 338673 | 338477 | 339287 | 339585 | 339911 | 0 | 0 | 0 | 0 | 0 | 0 |  | 4062783 | 4067906.666666667 | 4069494 | 4075132
Rent Premiums |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
Garage Income |  | 0 | 0 | 0 | 44 | 210 | 535 | 730 | 1180 | 1293 | 1562 | 1820 | 1881 | 2165 | 1869 | 2050 | 2226 | 2158 | 2557 | 2247 | 2468 | 2109 | 2315 | 2392 | 2272 | 2458 | 2505 | 2323 | 2482 | 2369 | 0 | 0 | 0 | 0 | 0 | 0 |  | 28497 | 28300 | 28818 | 28696
Carport Unit Income |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
Storage Income |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
Other Income |  | 0 | 0 | 0 | 4161 | 4318 | 4110 | 11329 | 12962 | 9432 | 9966 | 2455 | 7502 | 16904 | 11584 | 11124 | 14402 | 9418 | 40785 | 19872 | 20117 | 23364 | 16599 | 11493 | 9442 | 12261 | 21017 | 14801 | 13460 | 16533 | 0 | 0 | 0 | 0 | 0 | 0 |  | 219744 | 185293.3333333333 | 175028 | 179176
Retail Income |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
GROSS POTENTIAL INCOME |  | 0 | 0 | 0 | 342408 | 343244 | 342954 | 350926 | 350191 | 348612 | 349606 | 341617 | 345924 | 356924 | 351011 | 351776 | 354330 | 347361 | 378967 | 360211 | 360721 | 363953 | 356916 | 353586 | 350528 | 353392 | 361999 | 356411 | 355527 | 358813 | 0 | 0 | 0 | 0 | 0 | 0 |  | 4311024 | 4281500 | 4273340 | 4283004
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
Concession Loss |  | 0 | 0 | 0 | 0 | -6066 | -20847 | -25631 | -30172 | -30768 | -24679 | -18165 | -19985 | -18823 | -20912 | -18151 | -26080 | -22244 | -29409 | -34013 | -49000 | -53289 | -44214 | -45370 | -45093 | -41788 | -39696 | -39636 | -47882 | -37858 | 0 | 0 | 0 | 0 | 0 | 0 |  | -507248 | -526434.6666666666 | -503906 | -501504
Vacancy / Collection Loss |  | 0 | 0 | 0 | -336009 | -323454 | -299210 | -272078 | -208736 | -168074 | -141633 | -127251 | -116389 | -98679 | -83459 | -75469 | -54339 | -33949 | -33349 | -49641 | -26624 | -23717 | -24095 | -25953 | -19659 | -17862 | -19908 | -25453 | -25721 | -21083 | 0 | 0 | 0 | 0 | 0 | 0 |  | -313065 | -271268 | -259372 | -289028
EFFECTIVE GROSS INCOME |  | 0 | 0 | 0 | 6399 | 13724 | 22897 | 53217 | 111283 | 149770 | 183294 | 196201 | 209550 | 239422 | 246640 | 258156 | 273911 | 291168 | 316209 | 276557 | 285097 | 286947 | 288607 | 282263 | 285776 | 293742 | 302395 | 291322 | 281924 | 299872 | 0 | 0 | 0 | 0 | 0 | 0 |  | 3490711 | 3483797.333333333 | 3510062 | 3492472
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
Ad-Valorem Taxes |  | 0 | 0 | 0 | 28421 | 28421 | 28421 | 28421 | 28421 | 28421 | 28421 | 31124 | 35427 | 40073 | 40073 | 40073 | 45543 | 40073 | 40073 | 40073 | 106136 | 48331 | 48331 | 48331 | 35037 | 48649 | 48649 | 48649 | 48649 | 48649 | 0 | 0 | 0 | 0 | 0 | 0 |  | 609557 | 564366.6666666666 | 556564 | 583788
Administration |  | 0 | 0 | 0 | 1277 | 8080 | 5967 | 5266 | 6282 | 11539 | 3501 | 4387 | 6986 | 6110 | 4838 | 12356 | 6619 | 5670 | 6328 | 5066 | 6225 | 7625 | 7692 | 6597 | 9733 | 4576 | 7252 | 5006 | 6360 | 4951 | 0 | 0 | 0 | 0 | 0 | 0 |  | 77411 | 79722.66666666667 | 75756 | 65268
Advertising and Promotion |  | 0 | 0 | 0 | 79 | 1424 | 6789 | 12880 | 11413 | 40354 | 17582 | 12972 | 17580 | 5480 | 14885 | 13509 | 13386 | 7441 | 14993 | 16736 | 14838 | 19168 | 22447 | 17530 | 10105 | 9980 | 7133 | 10630 | 8045 | 11440 | 0 | 0 | 0 | 0 | 0 | 0 |  | 163045 | 155304 | 114666 | 120460
Insurance |  | 0 | 0 | 0 | 6875 | 6875 | 6875 | 6875 | 8141 | 6956 | 6875 | 12633 | 7185 | -36466 | 2772 | 3635 | 4567 | 2856 | 14154 | 5845 | 6158 | 5370 | 5370 | 5370 | 5806 | 4773 | 4773 | 4773 | 5083 | 5020 | 0 | 0 | 0 | 0 | 0 | 0 |  | 72495 | 61784 | 60456 | 59504
Management Fee |  | 0 | 0 | 0 | 3500 | 3500 | 3500 | 3500 | 3540 | 5376 | 6556 | 7138 | 7724 | 8356 | 8666 | 9089 | 9806 | 10282 | 11231 | 9562 | 9969 | 9965 | 10190 | 9828 | 10654 | 10107 | 10986 | 10073 | 10458 | 9974 | 0 | 0 | 0 | 0 | 0 | 0 |  | 122997 | 122980 | 124504 | 122020
Repairs and Maintenance |  | 0 | 0 | 0 | 0 | 0 | 608 | 8960 | 2830 | 6620 | 7537 | 10729 | 16268 | 7204 | 9458 | 10577 | 9468 | 13675 | 11079 | 18044 | 16934 | 17944 | 15150 | 12644 | 16423 | 11039 | 14714 | 15699 | 19538 | 22898 | 0 | 0 | 0 | 0 | 0 | 0 |  | 192106 | 194732 | 200622 | 232540
Replacement Reserve |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7998 | 2188 | 11359 | 3265 | 8901 | 1573 | 2630 | 605 | 13609 | -4150 | 7973 | 5044 | 10929 | 8312 | 0 | 0 | 0 | 0 | 0 | 0 |  | 70050 | 62033.33333333333 | 83434 | 97140
Salaries |  | 0 | 0 | 0 | 19182 | 23255 | 42174 | 20232 | 16127 | 12318 | 28192 | 38849 | 35022 | 22363 | 32877 | 26926 | 26688 | 45895 | 26820 | 23805 | 28962 | 29266 | 27001 | 35282 | 30425 | 22148 | 25056 | 27834 | 28832 | 38389 | 0 | 0 | 0 | 0 | 0 | 0 |  | 343820 | 352310.6666666667 | 345368 | 380220
Utilities |  | 0 | 0 | 0 | 0 | 58 | 3207 | 7144 | 11320 | 41355 | 32175 | 19187 | 26110 | 21985 | 19076 | 13889 | 16696 | 11441 | 10420 | 8337 | 7099 | 19291 | 12465 | 13836 | 16519 | 14689 | 15385 | 14368 | 9334 | 13276 | 0 | 0 | 0 | 0 | 0 | 0 |  | 155019 | 172217.3333333333 | 167142 | 147912
TOTAL OPERATING EXPENSES |  | 0 | 0 | 0 | 59334 | 71613 | 97541 | 93278 | 88074 | 152939 | 130839 | 137019 | 152302 | 75105 | 132645 | 130054 | 140771 | 139521 | 146457 | 130733 | 205222 | 158533 | 151276 | 150023 | 148311 | 121811 | 141921 | 142076 | 147228 | 162909 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1806500 | 1765450.666666667 | 1728512 | 1808852
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
NET OPERATING INCOME |  | 0 | 0 | 0 | -52935 | -57889 | -74644 | -40061 | 23209 | -3169 | 52455 | 59182 | 57248 | 164317 | 113995 | 128102 | 133140 | 151647 | 169752 | 145824 | 79875 | 128414 | 137331 | 132240 | 137465 | 171931 | 160474 | 149246 | 134696 | 136963 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1684211 | 1718346.666666667 | 1781550 | 1683620
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
Debt Service: |  | 0 | 0 | 0 | 0 | 0 | 8708 | 23249 | 37246 | 52706 | 63126 | 96643 | 149277 | 36568 | 32397 | 37688 | 36574 | 35846 | 35846 | 65298 | 33738 | 31427 | 32152 | 30702 | 32828 | 34259 | 30337 | 35403 | 33522 | 35079 | 0 | 0 | 0 | 0 | 0 | 0 |  | 430591 | 394278.6666666666 | 402856 | 416016
Asset Management Fee: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
CapEx: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
Other: |  | 0 | 0 | 0 | -52935 | -57891 | -83352 | -63311 | -14038 | -55875 | -10669 | -37461 | -92031 | 127749 | -126972 | 0 | 0 | 250 | 6332 | 1251 | 0 | 0 | 0 | 0 | 339 | 404 | 3133 | 3924 | 2040 | 283 | 0 | 0 | 0 | 0 | 0 | 0 |  | 17706 | 13497.33333333333 | 20246 | 24988
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
NET CASH FLOW |  | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 1 | 0 | -2 | 0 | 2 | 0 | 208570 | 90414 | 96566 | 115551 | 127574 | 79275 | 46137 | 96987 | 105179 | 101538 | 104298 | 137268 | 127004 | 109919 | 99134 | 101601 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1235914 | 1310570.666666667 | 1358448 | 1242616