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

Oxford West Properties I, LLLP
                                                                                          Managed by RISE Residential
                                                                                    Budget Comparison Report

                                                                                                                                                                                          Current
                                                          Current Month 12/31/2021      Prior Yr Current Mo. 12/31/2020     Year to Date 12/31/2021           Prior Year YTD 12/31/2020  Fiscal Yr.
                                                         Actual      Budget      Variance      Actual     Variance            Actual      Budget     Variance      Actual      Variance     Budget
       REVENUE
         GROSS RENTAL INCOME                          349,979      356,881       (6,902)    359,272        9,293         1,760,139    1,775,506     (15,367)   1,809,682      49,542    4,273,673
         COST OF LEASING                               (85,915)    (85,906)         (9)     (68,288)      17,627          (467,233)    (463,250)     (3,983)    (393,181)     74,053    (1,070,465)
         NET RENTAL INCOME                            264,064      270,975       (6,911)    290,984       26,920         1,292,906    1,312,256     (19,350)   1,416,501     123,595    3,203,208
         OTHER INCOME                                  39,771       34,450       5,321       32,576       (7,194)          142,128     122,321       19,807      118,544     (23,585)     317,221

       TOTAL INCOME                                   303,835      305,425       (1,590)    323,560       19,726         1,435,034    1,434,577        457     1,535,045     100,010    3,520,429
       CONTROLLABLE EXPENSES
         PAYROLL OFFICE                                13,151       14,592       1,441       16,568        3,418            80,208      89,651        9,443      93,521       13,312      217,188
         PAYROLL MAINTENANCE                            9,013        7,725       (1,288)      8,808        (205)            46,287      42,825       (3,462)     47,757        1,471       98,150
         PAYROLL RELATED EXPENSES                       3,866        4,679         813        4,592         726             23,150      29,047        5,898      25,317        2,167       65,531
         TOTAL PAYROLL                                 26,030       26,996         966       29,968        3,939           149,645     161,523       11,879      166,595      16,950      380,869
         GENERAL & ADMINISTRATIVE                       5,125        5,335         209        5,004        (121)            39,390      41,616        2,226      50,064       10,673       81,846
         PROFESSIONAL FEES                                 0            0           0            0            0                30           0          (31)          29          (1)           0
         CONTRACT SERVICES                              6,571        7,069         499        8,162        1,591            45,306      47,445        2,139      49,099        3,793       91,478
         TURNOVER EXPENSE                                590           50         (540)        128         (462)           111,857     111,095        (762)      123,756      11,899      111,445
         REPAIRS & MAINTENANCE                          1,144        1,890         745        1,874         730             14,188      13,880        (308)      17,097        2,908       27,260
         MARKETING & LEASING                            (4,059)      1,487       5,547        4,801        8,861            37,337      39,185        1,849      69,551       32,215       66,044
         COMMON AREA UTILITIES                          1,834        1,486        (349)       1,895          60              8,488       6,127       (2,362)      8,561          73        20,175
         UNIT UTILITIES                                64,856       61,771       (3,085)     59,678       (5,178)          248,757     249,042         286       248,740         (17)     611,901
         TOTAL UTILITIES                               66,690       63,257       (3,434)     61,573       (5,118)          257,245     255,169       (2,076)     257,301         56       632,076

         MANAGEMENT FEES                               11,270       12,217         948       13,156        1,886            58,495      57,383       (1,112)     62,563        4,068      140,817
       TOTAL CONTROLLABLE EXPENSES                    113,361      118,301       4,940      124,666       11,306           713,493     727,296       13,804      796,055      82,561    1,531,835

       CONTROLLABLE CASH FLOW                         190,474      187,124       3,350      198,894        8,420           721,541     707,281       14,261      738,990      17,449    1,988,594
       TAXES & INSURANCE                               48,186       47,688        (498)      39,741       (8,445)          243,752     240,785       (2,968)     201,013     (42,738)     588,103
       NET OPERATING INCOME                           142,288      139,436       2,852      159,153       16,865           477,789     466,496       11,293      537,977      60,187    1,400,491


       OTHER FINANCE RELATED                               5            0           (5)          0           (5)               10           0          (10)          0           (10)          0
       CASH FLOW BEFORE DEBT SERVICE                  142,283      139,436       2,847      159,153       16,870           477,779     466,496       11,283      537,977      60,197    1,400,491
   25   26   27   28   29   30   31   32   33   34   35