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

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


                                                                         DEPRECIATION/AMORTIZATION
        9,396        7,936      (1,461)             8,144      (1,253)    8000 - Depreciation - FF&E                45,979      39,678       (6,302)             34,656     (11,324)      95,228
       68,383      68,382            0             68,382            0    8005 - Deprec Expense-Building          341,912      341,912            0            341,912             0     820,589
       10,416      10,417            0             10,416            0    8006 - Amortization-Loan Fees             52,082      52,081            0              52,081            0     124,995
       88,195      86,735       (1,461)            86,942      (1,253)   TOTAL DEPREC/AMORT                       439,973      433,671       (6,302)           428,649      (11,324)   1,040,812
                                                                         OTHER EXPENSES
        7,645        7,645           0                   0     (7,645)    8517 - Audit/Tax Return Fees               7,645       7,645            0                   0       (7,645)      7,645
        7,645        7,645           0                   0     (7,645)   TOTAL OTHER EXPENSES                        7,645       7,645            0                   0       (7,645)      7,645

      (81,165)     (80,693)       (472)           (53,539)    (27,626)   CASH FLOW AFTER DEPREC/                  (632,066)   (647,667)      15,601            (631,986)         (80) (1,201,058)
                                                                         AMORT AND OTHER EXP.


                                                                         RECONCILIATION TO GAAP NET
                                                                         INCOME (LOSS)
                                                                          CAPITAL EXPENDITURES
             0           0           0                   0           0      1480 - Vehicles                              0            0           0              (1,092)      1,092            0
             0           0           0                   0           0      1523 - Capital HVAC                       (772)      (1,000)        228                   0        (772)      (1,000)
             0           0           0                   0           0      1526 - Carpet/Vinyl Replacement        (37,989)    (38,000)          11             (35,978)      (2,011)    (38,000)
       (1,858)           0      (1,858)                  0     (1,858)      1533 - Appliances                       (5,144)      (1,000)     (4,144)            (10,528)      5,384       (1,000)
             0           0           0                   0           0      1555 - Lighting - Exterior                   0            0           0              (9,411)      9,410            0
             0           0           0                   0           0      1575 - Plumbing                         (4,153)      (4,100)        (53)                  0       (4,152)     (4,100)
             0           0           0                   0           0      1585 - Roof & Gutters                   (1,300)           0      (1,300)             (5,550)      4,250            0
             0           0           0                   0           0      1504 - Furniture-Units                       0            0           0             (34,449)     34,449            0
       (1,858)           0      (1,858)                  0     (1,858)    TOTAL CAPITAL EXPENDITURES               (49,358)    (44,100)      (5,258)            (97,008)     47,650      (44,100)

                                                                          RESERVES
       (9,083)      (9,083)          0             (9,083)           0      1320 - Replacement Reserve Fund        (17,869)    (45,417)      27,548             (45,417)     27,547     (109,000)
       (9,083)      (9,083)          0             (9,083)           0    TOTAL RESERVES                           (17,869)    (45,417)      27,548             (45,417)     27,547     (109,000)

      (70,224)     (71,609)      1,385            (44,456)    (25,768)   GAAP NET INCOME (LOSS)                   (564,839)   (558,151)      (6,688)           (489,562)    (75,277) (1,047,958)




                                                                                                                                                                                                  Page 13
   21   22   23   24   25   26   27   28   29   30   31