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

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
       DEBT SERVICE                                   116,666      116,666          0       116,666           0            595,000     583,330      (11,670)     598,889       3,889    1,399,992

       CASH FLOW AFTER DEBT SERVICE                    25,617       22,770       2,847       42,487       16,870          (117,221)    (116,834)      (387)      (60,912)     56,308         499
       RESERVES                                         9,084        9,083          0         9,084           0             17,869      45,417       27,547      45,417       27,547      109,000
       CAPITAL EXPENDITURES                             1,858           0        (1,858)         0        (1,858)           49,358      44,100       (5,257)     97,008       47,650       44,100
       CASH FLOW BEFORE DEPREC/AMORT                   14,675       13,687         989       33,403       18,728          (184,448)    (206,351)     21,903     (203,337)    (18,889)    (152,601)

       DEPRECIATION/AMORTIZATION                       88,195       86,735       (1,461)     86,942       (1,253)          439,973     433,671       (6,302)     428,649     (11,324)   1,040,812
       OTHER EXPENSES                                   7,645        7,645          0            0        (7,645)            7,645       7,645           0           0        (7,645)       7,645
       CASH FLOW AFTER DEPREC/AMORT AND OTHER          (81,165)    (80,693)       (472)     (53,539)      27,626          (632,066)    (647,667)     15,601     (631,986)        80     (1,201,058)
       EXP.

       RECONCILIATION TO GAAP NET INCOME (LOSS)
         CAPITAL EXPENDITURES                           (1,858)         0        (1,858)         0         1,858           (49,358)     (44,100)     (5,258)     (97,008)    (47,650)     (44,100)
         RESERVES                                       (9,083)     (9,083)         0        (9,083)          0            (17,869)     (45,417)     27,548      (45,417)    (27,548)    (109,000)

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


       DEBT COVERAGE RATIO                               1.22         1.20        0.02         1.36        0.14              0.80         0.80         0.00        0.90         0.10        1.00
   27   28   29   30   31   32   33   34   35   36   37