Page 38 - Oxford West Investor Quarterly Report Academic Year 2021-2022 Quarter 2
P. 38

Oxford West Properties I, LLLP

                                                                                    Financial Analysis Report
                                                                                         Managed by RISE Residential
                                                                                         As of December 31, 2021

                                        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    Budget    Budget     Budget    Budget     Budget    Budget    Budget    Act/Bud    Budget   Variance
        6241 - License & Permits            9,090         0         27        27        27          0         0        325       450         0          0         0      9,947      9,875       71
        6242 - Telephone/Answering Service    450       453        451       462       441        425       425        425       425       425        425       425      5,233      5,100      134
        6244 - Mobile Phones                   50        50         49        49       121         70        70         70        70        70         70        70        808       840        (32)
        6245 - Professional Development       101       103        104       104       212        220      2,220       220       220       220        220       220      4,163      4,640      (477)
        6257 - Credit Reports                 624      1,013       199       159       512        100       100        600       700       300        300       300      4,909      5,050      (142)
        6258 - Uniforms                         0         0          0         0         0          0         0          0         0         0          0         0          0      1,000    (1,000)
        6532 - Fire and Safety Monitoring Contract  487  105       332       100        56         56       771         56        56       771         56        56      2,903      3,532      (628)
       TOTAL GENERAL & ADMINISTRA-         16,252      6,356     4,966      6,688     5,125     6,575      7,640     5,300      5,525     5,840     4,675      4,675    79,620     81,846    (2,225)
       TIVE

       PROFESSIONAL FEES
        6340 - Legal Fees                       0         0         31         0         0          0         0          0         0         0          0         0         30         0        30
       TOTAL PROFESSIONAL FEES                  0         0         31         0         0          0         0          0         0         0          0         0         30         0        30
       CONTRACT SERVICES
        6537 - Landscaping Contract         7,500      7,500     2,760      2,761     2,760     2,760      2,760     2,760      2,760     2,760     2,760      2,760    42,600     43,970    (1,371)
        6540 - Electrical Contract            120         0          0         0         0          0         0          0         0         0          0         0        120         0       120
        6544 - Plumbing Contract              605       475          0         0       415          0       300          0         0       300          0         0      2,095      1,400      695
        6548 - Snow Removal                     0         0          0         0         0        800      1,500         0         0         0          0         0      2,300      4,100    (1,800)
        6522 - Exterminating Contract       1,483      1,506       547       568       569        459       459        459       459       459        459       459      7,886      7,008      879
        6525 - Garbage                      2,466      4,721     2,071      3,652     2,827     2,400      2,400     2,400      2,400     2,400     4,200      2,400    34,338     35,000      (662)
       TOTAL CONTRACT SERVICES             12,174     14,202     5,378      6,981     6,571     6,419      7,419     5,619      5,619     5,919     7,419      5,619    89,339     91,478    (2,139)
       TURNOVER EXPENSE
        6581 - Interior Paint - Contract Labor  50,750    0          0         0         0          0         0          0         0         0          0         0     50,750     50,925      (175)
        6582 - Interior Paint - Supplies    8,022        82         81         0         0          0         0          0         0         0          0         0      8,185      8,000      185
        6583 - Floor-Cleaning Contract      6,130        64          0         0         0          0         0          0         0         0          0         0      6,193      6,120       73
        6585 - Blinds/Drapes                  252        26        310         0         0         50        50         50        50        50         50        50        939       800       139
        6586 - Turn Cleaning               35,470         0          0         0       590          0         0          0         0         0          0         0     36,060     35,520      540
        6588 - Turn Labor                  10,080         0          0         0         0          0         0          0         0         0          0         0     10,080     10,080        0
       TOTAL TURNOVER EXPENSE             110,704       172        391         0       590         50        50         50        50        50         50        50    112,207    111,445      762

       REPAIRS & MAINTENANCE
        6304 - Vehicle Maintenance            115       167          0         0        38         90        40         40        90        40         40        90        748       760        (12)
        6515 - Cleaning Supplies              393       156          0       277         0         50        50         50        50        50         50        50      1,177      1,000      177
        6516 - Keys & Locks                    83       162          0        89         0          0         0          0         0         0          0         0        333       100       233
        6519 - Interior Floor Repair/Cleaning   0         0          0       650         0          0         0          0         0         0          0         0        650         0       649
        (Non-Turn)
        6556 - Other Maint Repairs & Supplies  510      354        365       159       244        300       300        300       300       300        300       300      3,733      3,800       (66)
        6557 - Appliance Parts & Supplies       0       228          0         0       213        250       250        250       250       250        250       250      2,192      3,000      (809)
        6558 - Electrical Parts & Supplies    127       255         64       136        26          0       200          0       200         0        200         0      1,208      1,200        8
        6559 - Plumbing Parts & Supplies    1,248       727        708       825       269        500       500        500       500       500        500       500      7,276      7,300       (23)
        6560 - HVAC Parts & Supplies          187         0        152       143       136        200       200        200       200       200        200       200      2,019      2,400      (382)

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