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

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


    OTHER FINANCE RELATED
      6899 - Other Financial Expense             0          5          0          5          0          0        168         10         10          5          0          0          0        203
    TOTAL OTHER FINANCE RELATED                  0          5          0          5          0          0        168         10         10          5          0          0          0        203

    TOTAL NON-CONTROLLABLE EX-                   0          5          0          5          0          0        168         10         10          5          0          0          0        203
    PENSES

    CASH FLOW BEFORE DEBT SERVICE           159,153    142,283    126,372    140,104    120,859    (51,839)   116,151    122,281    141,482    128,763    162,398    118,772    168,701  1,436,327
    DEBT SERVICE
      6820 - Interest Expense               116,666    116,666    120,555    116,667    120,556    120,556    116,667    120,556    116,667    120,555    108,888    120,555    120,556  1,419,445
    TOTAL DEBT SERVICE                      116,666    116,666    120,555    116,667    120,556    120,556    116,667    120,556    116,667    120,555    108,888    120,555    120,556  1,419,445
    CASH FLOW AFTER DEBT SERVICE             42,487     25,617      5,817     23,437       303    (172,395)      (516)     1,725     24,815      8,208     53,510     (1,783)    48,145     16,883

    RESERVES
      1320 - Replacement Reserve Fund         9,084      9,084      9,084    (18,464)     9,083      9,083    (85,852)     9,083      9,083      9,083      9,084      9,084      9,083    (13,483)
    TOTAL RESERVES                            9,084      9,084      9,084    (18,464)     9,083      9,083    (85,852)     9,083      9,083      9,083      9,084      9,084      9,083    (13,483)
    CAPITAL EXPENDITURES
      1523 - Capital HVAC                        0          0          0          0          0        771        772          0          0          0          0          0          0       1,544
      1526 - Carpet/Vinyl Replacement            0          0          0          0          0      37,990         0          0          0          0          0          0       5,032     43,021
      1533 - Appliances                          0       1,858       716          0       1,522      1,048         0       1,175         0       2,651       998          0       1,726     11,694
      1551 - Grounds & Landscaping               0          0          0          0          0          0          0          0          0          0          0          0       1,172      1,171
      1575 - Plumbing                            0          0          0          0          0       4,152         0          0          0          0       2,515         0          0       6,668
      1585 - Roof & Gutters                      0          0          0       1,300         0          0          0          0          0          0          0          0        725       2,025
    TOTAL CAPITAL EXPENDITURES                   0       1,858       716       1,300      1,522     43,961       772       1,175         0       2,651      3,513         0       8,655     66,123

    CASH FLOW BEFORE DEPREC/AMORT            33,403     14,675     (3,983)    40,601    (10,302)  (225,439)    84,564     (8,533)    15,732     (3,526)    40,913    (10,867)    30,408    (35,757)
    DEPRECIATION/AMORTIZATION
      8000 - Depreciation - FF&E              8,144      9,396      9,341      9,342      9,316      8,583      8,570      8,551      8,551      9,261      8,323      8,322      8,282    105,839
      8005 - Deprec Expense-Building         68,382     68,383     68,383     68,382     68,383     68,383     68,383     68,382     68,383     68,382     68,382     68,383     68,382    820,590
      8006 - Amortization-Loan Fees          10,416     10,416     10,416     10,416     10,416     10,416     10,416     10,417     10,416     10,417     10,416     10,416     10,416    124,995
    TOTAL DEPREC/AMORT                       86,942     88,195     88,140     88,140     88,115     87,382     87,369     87,350     87,350     88,060     87,121     87,121     87,080  1,051,424

    OTHER EXPENSES
      8515 - Other Professional Fees             0          0          0          0          0          0          0          0          0          0          0          0       2,000      2,000
      8516 - Legal and Professional Fee          0          0          0          0          0          0          0          0          0          0          0       4,020         0       4,019
      8517 - Audit/Tax Return Fees               0       7,645         0          0          0          0          0          0      10,410         0          0          0          0      18,055
    TOTAL OTHER EXPENSES                         0       7,645         0          0          0          0          0          0      10,410         0          0       4,020      2,000     24,074

                                                                                                                                                                                                  Page 33
   61   62   63   64   65   66   67   68   69   70   71