Page 38 - Preserve at Tech Investor Quarterly Report Academic Year 2021-2022 Quarter 2
P. 38

Ruston Properties I, LLC
    The Preserve at Tech
                                                                                    Financial Analysis Report
                                                                                         Managed by RISE Residential
                                                                                          As of January 31, 2022

                                        08/31/2021 09/30/2021 10/31/2021 11/30/2021 12/31/2021 01/31/2022 02/28/2022 03/31/2022 04/30/2022 05/31/2022 06/30/2022 07/31/2022  Total  Original
                                              Actual    Actual    Actual     Actual    Actual     Actual   Budget     Budget    Budget     Budget    Budget    Budget    Act/Bud    Budget   Variance
        6516 - Keys & Locks                   480       188        974        75        75        149       141         75       641        75        141        75      3,090      2,134      956
        6556 - Other Maint Repairs & Supplies  49       155        848       558       428          0        35          0        35         0         35         0      2,142       210      1,933
        6557 - Appliance Parts & Supplies       0         0        856        79       144          0         0          0         0         0          0         0      1,078         0      1,078
        6558 - Electrical Parts & Supplies      0         0          0         0       375         26         0          0       200         0          0         0        602       200       401
        6559 - Plumbing Parts & Supplies       75         0          0       125         0          0        50          0       550         0         50         0        850       800        50
        6560 - HVAC Parts & Supplies            0         0        237      1,075        0          0       492          0         0       492          0         0      2,297      1,970      327
        6561 - Pool Parts & Supplies        1,781         0        948         0         0        222       250        250       250       250        250       250      4,450      4,700      (249)
        6564 - Building -Exterior Cleaning      0         0          0         0         0          0        50          0        50         0         50         0        150       300       (150)
        6566 - Windows/Door Repairs/Glass       0         0        171         5       550          0        60          0        60         0         60         0        907       360       547
        6568 - Fire Prevention Equipment        0         0        170      (169)        0          0         0          0         0         0          0         0          0         0         0
        6569 - Recreation Equipment           203         0          0         0         0          0      1,200         0         0         0          0         0      1,403      1,403        0
        6570 - Equipment and Tools         10,114         0      1,093       744       (132)      263         0          0         0         0          0         0     12,082     10,295     1,787
        6573 - Gates/Fence/Wall Repairs         0         0          0         0         0          0         0          0         0       100          0         0        100       200       (100)
        6574 - Light Bulbs                      0         0        155         0         0          0        50          0      1,550        0         50         0      1,805      1,800        5
        6576 - Life Safety System R&M           0         0          0       169         0          0         0          0         0         0          0      7,500     7,670      7,500      169
        6578 - Maintenance Uniforms           415         0          0         0        (11)        0       415          0         0         0          0         0        819      1,495      (676)
        6592 - COVID-19 Supplies                0         0          0         0         0        365         0          0         0         0          0         0        365         0       365
       TOTAL REPAIRS & MAINTENANCE         13,178       343      5,725      2,696     1,417     1,113      2,793       375      3,386      967        686      7,875    40,556     33,967     6,589
       MARKETING & LEASING
        6205 - Advertising/Marketing        6,358       108        874       281       505        301       368      3,568      3,568     3,568       368       868     20,735     20,641       95
        6212 - Internet Advertising         7,960      5,785     5,784      1,328     8,828     3,828      2,607     2,607      4,607     4,607     4,607      4,607    57,152     50,775     6,376
        6214 - Brochures                        0       142          0         0       136        132       127          0       127       127          0       127        918      1,016       (98)
        6215 - Signage / Flags/ Banners     4,628     (1,850)      605         0       184          0         0      1,500         0         0      1,000         0      6,066      7,128    (1,061)
        6218 - Leasing Promotional Activities  4,580    360      1,148       828       641        316       650        650      3,650     1,000       650      1,400    15,874     23,063    (7,190)
        6261 - Promotional Items            1,624       508          0      1,750       (17)        0      1,750         0         0      1,750         0         0      7,365      9,500    (2,135)
        6283 - Gift Cards and Leasing Incentives  27,000  0      5,000      1,250     2,000     1,500      1,000     2,500      2,000     3,500     4,500      3,500    53,750     57,000    (3,250)
       TOTAL MARKETING & LEASING           52,150      5,053    13,411      5,437    12,277     6,077      6,502    10,825     13,952    14,552    11,125     10,502   161,860    169,123    (7,263)

       COMMON AREA UTILITIES
        6450 - C/A Electricity              6,145       904        620       670       715      4,353      2,464     2,463      2,463     2,464     2,464      2,464    28,190     29,565    (1,375)
        6451 - C/A Water & Sewer                0        27        387       213       184      5,733         0          0         0         0          0         0      6,544         0      6,544
       TOTAL C/A UTILITIES EXPENSE          6,145       931      1,007       883       899     10,086      2,464     2,463      2,463     2,464     2,464      2,464    34,734     29,565     5,169
       UNIT UTILITIES
        6460 - Electricity Vacant Units    18,228         0          0         0         0     (18,228)    4,576     4,576      4,576     4,576     4,576      4,576    27,456     65,624   (38,169)
        6461 - Electricity Occupied Units       0     20,293    12,193     11,199    10,285    17,752     12,656    12,657     12,657    12,656    12,656     12,656   147,662    131,099    16,564
        6463 - Water/Sewer Units            1,056      2,404     1,650      1,680     1,680     2,308      8,544     8,544      8,544     8,544     8,544      8,544    62,042    102,528   (40,486)
        6465 - Internet Service             4,950      5,400     4,900      4,900     5,000     4,900      4,950     4,950      4,950     4,950     4,950      4,950    59,750     59,400      350
       TOTAL UNIT UTILITIES EXPENSE        24,234     28,097    18,743     17,779    16,965     6,732     30,726    30,727     30,727    30,726    30,726     30,726   296,910    358,651   (61,741)
       TOTAL UTILITIES                     30,379     29,028    19,750     18,662    17,864    16,818     33,190    33,190     33,190    33,190    33,190     33,190   331,644    388,216   (56,572)


                                                                                                                                                                                                  Page 18
   33   34   35   36   37   38   39   40   41   42   43