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

Oxford West Properties I, LLLP

                                                                                      13 Month Trend Report
                                                                                        Managed by RISE Residential
                                                                                        As of December 31, 2021

                                          Prior Year                                                                                                                                     Rolling 12
                                          12/31/2020  12/31/2021  11/30/2021  10/31/2021  09/30/2021  08/31/2021  07/31/2021  06/30/2021  05/31/2021  04/30/2021  03/31/2021  02/28/2021  01/31/2021 Month Total
    REVENUE

      RENTAL INCOME
       5120 - Gross Potential Rent (GPR)    377,285    385,800    385,800    385,390    385,800    385,800    385,800    385,800    385,800    377,285    377,285    377,285    377,285  4,595,130
       5125 - Gain/Loss to Lease            (18,013)   (35,821)   (33,928)   (35,825)   (34,361)   (28,516)   (28,765)   (30,345)   (24,913)   (18,014)   (18,202)   (18,677)   (18,591)  (325,958)
       5127 - Accelerated Rent                   0          0          0          0          0          0          0       1,540         0          0          0          0      14,400     15,940
       GROSS RENTAL INCOME                  359,272    349,979    351,872    349,565    351,439    357,284    357,035    356,995    360,887    359,271    359,083    358,608    373,094  4,285,112

       COST OF LEASING
         5220 - Rent Loss-Vacancy           (59,349)   (79,944)   (80,272)   (81,249)   (81,503)   (99,690)   (83,376)   (93,960)   (58,649)   (63,193)   (62,807)   (57,769)   (59,084)  (901,495)
         5221 - Rent Loss-Model              (1,545)    (1,415)    (1,415)    (1,415)    (1,415)    (1,415)    (1,545)    (1,545)    (1,545)    (1,545)    (1,545)    (1,545)    (1,545)   (17,890)
         5222 - Rent Loss-Security           (1,480)    (1,480)    (1,480)    (1,480)    (1,480)    (1,480)    (1,480)    (1,480)    (1,480)    (1,480)    (1,480)    (1,480)    (1,480)   (17,760)
         5223 - Employee Units               (5,914)    (3,076)    (2,601)    (3,582)    (3,107)    (2,835)    (4,643)    (4,456)    (4,456)    (4,456)    (5,914)    (5,914)    (5,914)   (50,954)
         5250 - Concessions                      0          0          0        265      (2,180)    (4,221)        0          0          0          0          0          0          0      (6,137)
         5255 - Bad Debt Expense                 0          0      (8,074)       (83)    (5,925)     5,319    (37,339)    (6,835)        0         37     (10,655)      130       2,880    (60,546)
       TOTAL COST OF LEASING                (68,288)   (85,915)   (93,842)   (87,544)   (95,610)  (104,322)  (128,383)  (108,276)   (66,130)   (70,637)   (82,401)   (66,578)   (65,143) (1,054,782)
      NET RENTAL INCOME                     290,984    264,064    258,030    262,021    255,829    252,962    228,652    248,719    294,757    288,634    276,682    292,030    307,951  3,230,330

      OTHER INCOME
       5914 - Vending Income                     0          0        116          0          0          0          0          0          0          0          0          0          0        116
       5920 - Late Charge Income              1,965      2,284      1,020      1,932      3,696        11       4,194        13         65        272          0         (40)       11      13,460
       5924 - NSF Check Fee Income               0         50        100        150         50         50          0        100         50        250        100          0        250       1,150
       5926 - Administrative Fee                 0          0          0          0      (1,200)      480        720          2          0          0          0          0          0          2
       5927 - Resident Insurance Program       140          0          0         (36)        0          0          0          0          0          0          0          0        (130)      (166)
       5929 - Hold Over Fee                      0        150          0          0        300       2,550         0          0          0          0          0          0          0       3,000
       5930 - Resident Damages                 568        390        390        540       1,460      4,061       390        525        440        390        312        390       1,280     10,568
       5932 - Cleaning Fee                     123        150          0         80        383      (1,083)     2,310       225        338          0          0          0          0       2,402
       5940 - Security Deposit Forfeitures       0          0          0          0          0          0          0       9,195         0       8,419         0          0          0      17,614
       5950 - Lease Termination Fees             0       5,000      2,500      2,500      2,500         0       2,470         0          0          0          0          0          0      14,970
       5951 - Application Fees                   0          0         45          0          0         45          0          0        (180)      180          0          0          0         90
       5952 - Onetime Pet Fee Income           250         90        900        900        300       6,930        30       1,780       300        600          0        550          0      12,380
       5953 - Fines                              0         50         25        675        375        100          0          0         50        100         50         50        100       1,576
       5954 - Replmnt Keys/Cards/Lock Outs       0         25          0          0         50        120         25          0         15         50         50         50         50        435
       5955 - Cable Income                       0          0          0          0          0          0          0         35          0          0          0          0          0         35
       5956 - Utility Income                 27,252     29,314     11,058     21,336     25,073      4,921     11,100     10,556      3,991      1,677     52,707     35,815     37,066    244,612
       5957 - Transfer Fees                      0          0          0          0        (150)      300        150        300          0        150        150        250        250       1,400
       5964 - Monthly Pet Rent Income         1,528      1,438      1,500      1,480      1,400      1,092      1,435      1,432      1,605      1,886      1,395      1,635      1,560     17,858
       5146 - Relet Fee                        750        750        250          0         58        650          0        250        750        250        250        500       1,000      4,709
       5142 - Furniture Income                   0         80         80         80         40        174          0          0          0          0          0          0          0        454
      TOTAL OTHER INCOME                     32,576     39,771     17,984     29,637     34,335     20,401     22,824     24,413      7,424     14,224     55,014     39,200     41,437    346,665



                                                                                                                                                                                                  Page 27
   49   50   51   52   53   54   55   56   57   58   59