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

Oxford West Properties I, LLLP

                                                                                  Budget Comparison Report
                                                                                        Managed by RISE Residential
                                                                                        As of December 31, 2021

                                                Prior MTD                                                                                                     Prior YTD                   Current
        Month to Date 12/31/2021               12/31/2020                                                             Year to Date 12/31/2021                12/31/2020               Fiscal Year
         Actual      Budget     Variance             Actual    Variance                                               Actual      Budget     Variance              Actual    Variance      Budget


                                                                         OTHER FINANCE RELATED
             5           0          (5)                  0          (5)   6899 - Other Financial Expense                10            0         (10)                  0          (10)          0
             5           0          (5)                  0          (5)  TOTAL OTHER FINANCE RELATED                    10            0         (10)                  0          (10)          0

             5           0          (5)                  0          (5)  TOTAL NON-CONTROLLABLE EX-                     10            0         (10)                  0          (10)          0
                                                                         PENSES

      142,283     139,436        2,847            159,153     (16,870)   CASH FLOW BEFORE DEBT SER-               477,779      466,496       11,283            537,977      (60,197)   1,400,491
                                                                         VICE
                                                                         DEBT SERVICE
      116,666     116,666            0            116,666            0    6820 - Interest Expense                 595,000      583,330      (11,670)           598,889        3,889    1,399,992
      116,666     116,666            0            116,666            0   TOTAL DEBT SERVICE                       595,000      583,330      (11,670)           598,889        3,889    1,399,992

       25,617      22,770        2,847             42,487     (16,870)   CASH FLOW AFTER DEBT SER-                (117,221)   (116,834)        (387)            (60,912)    (56,308)         499
                                                                         VICE
                                                                         RESERVES
        9,084        9,083           0              9,084            0    1320 - Replacement Reserve Fund           17,869      45,417       27,547              45,417      27,547      109,000
        9,084        9,083           0              9,084            0   TOTAL RESERVES                             17,869      45,417       27,547              45,417      27,547      109,000
                                                                         CAPITAL EXPENDITURES
             0           0           0                   0           0    1480 - Vehicles                                0            0           0               1,092       1,092            0
             0           0           0                   0           0    1504 - Furniture-Units                         0            0           0              34,449      34,449            0
             0           0           0                   0           0    1523 - Capital HVAC                          772       1,000          229                   0        (772)       1,000
             0           0           0                   0           0    1526 - Carpet/Vinyl Replacement           37,989      38,000           10              35,978       (2,011)     38,000
        1,858            0      (1,858)                  0     (1,858)    1533 - Appliances                          5,145       1,000       (4,144)             10,529       5,384        1,000
             0           0           0                   0           0    1555 - Lighting - Exterior                     0            0           0               9,410       9,410            0
             0           0           0                   0           0    1575 - Plumbing                            4,152       4,100          (52)                  0       (4,152)      4,100
             0           0           0                   0           0    1585 - Roof & Gutters                      1,300            0      (1,300)              5,550       4,250            0
        1,858            0      (1,858)                  0     (1,858)   TOTAL CAPITAL EXPENDITURES                 49,358      44,100       (5,257)             97,008      47,650       44,100

       14,675      13,687          989             33,403     (18,728)   CASH FLOW BEFORE DEPREC/                 (184,448)   (206,351)      21,903            (203,337)     18,889     (152,601)
                                                                         AMORT

                                                                                                                                                                                                  Page 12
   19   20   21   22   23   24   25   26   27   28   29