Page 42 - Preserve at Tech Investor Quarterly Report Academic Year 2021-2022 Quarter 2
P. 42

Ruston Properties I, LLC
    The Preserve at Tech
                                                                                    Financial Analysis Report
                                                                                         Managed by RISE Residential
                                                                                          As of January 31, 2022

                                        08/31/2021 09/30/2021 10/31/2021 11/30/2021 12/31/2021 01/31/2022 02/28/2022 03/31/2022 04/30/2022 05/31/2022 06/30/2022 07/31/2022  Total  Original
                                              Actual    Actual    Actual     Actual    Actual     Actual   Budget     Budget    Budget     Budget    Budget    Budget    Act/Bud    Budget   Variance


     CASH FLOW BEFORE DEBT SERVICE         20,793    131,835   160,439    144,897   235,034   168,761    123,288   123,240    121,341   117,938   126,050    119,593  1,593,208  1,314,389  278,819
     DEBT SERVICE
       6820 - Interest Expense                  0         0     61,439     64,294    61,764    63,824     69,613    69,614     69,614    69,613    69,613     69,613   669,001    696,136   (27,135)
     TOTAL DEBT SERVICE                         0         0     61,439     64,294    61,764    63,824     69,613    69,614     69,614    69,613    69,613     69,613   669,001    696,136   (27,135)

     CASH FLOW AFTER DEBT SERVICE          20,793    131,835    99,000     80,603   173,270   104,937     53,675    53,626     51,727    48,325    56,437     49,980   924,206    618,253   305,953
     EXTRAORDINARY EXPENSE
       7200 - Extraordinary Expense             0         0          0       949         0          0         0          0         0         0          0         0        949         0       949
     TOTAL EXTRAORDINARY EXPENSE                0         0          0       949         0          0         0          0         0         0          0         0        949         0       949

     CAPITAL EXPENDITURES
       1504 - Furniture-Units                   0         0          0         0         0          0         0      5,000         0         0          0         0      5,000      5,000        0
       1530 - Building - Exterior               0      4,995         0         0         0          0         0          0         0         0          0         0      4,995      5,100      (105)
       1531 - Building - Interior               0     (1,032)        0         0         0          0         0          0         0         0          0         0     (1,032)        0     (1,032)
     TOTAL CAPITAL EXPENDITURES                 0      3,963         0         0         0          0         0      5,000         0         0          0         0      8,963     10,100    (1,137)
     CASH FLOW BEFORE DEPREC/              20,793    127,872    99,000     79,654   173,270   104,937     53,675    48,626     51,727    48,325    56,437     49,980   914,294    608,153   306,141
     AMORT
     DEPRECIATION/AMORTIZATION
       8000 - Depreciation - FF&E               0         0     23,006     23,085    23,541    23,540     23,541    23,541     23,541    23,541    23,541     23,541   234,419    234,340       79
       8003 - Amortization - Loan Fees/Transaction  0     0      8,946      8,947     8,946     8,947      8,947     8,947      8,947     8,947     8,947      8,947    89,468     89,470        (3)
       Cost
       8005 - Deprec Expense-Building           0         0     83,853     85,074    85,089    85,092     85,092    85,092     85,092    85,092    85,092     85,092   849,659    847,897     1,763
     TOTAL DEPREC/AMORT                         0         0    115,805    117,106   117,576   117,579    117,580   117,580    117,580   117,580   117,580    117,580  1,173,546  1,171,707    1,839

     OTHER EXPENSES
       8515 - Other Professional Fees           0         0          0         0      3,000         0         0          0         0         0          0         0      3,000         0      3,000
     TOTAL OTHER EXPENSES                       0         0          0         0      3,000         0         0          0         0         0          0         0      3,000         0      3,000

     CASH FLOW AFTER DEPREC/AMORT          20,793    127,872   (16,805)   (37,452)   52,694    (12,642)  (63,905)  (68,954)   (65,853)  (69,255)   (61,143)  (67,600)  (262,251)  (563,554)  301,302
     AND OTHER EXP.


     RECONCILIATION TO GAAP NET IN-
     COME (LOSS)
       CAPITAL EXPENDITURES
        1530 - Building - Exterior              0     (4,995)        0         0         0          0         0          0         0         0          0         0     (4,995)    (5,100)     105
        1531 - Building - Interior              0      1,032         0         0         0          0         0          0         0         0          0         0      1,032         0      1,032
        1504 - Furniture-Units                  0         0          0         0         0          0         0     (5,000)        0         0          0         0     (5,000)    (5,000)       0
       TOTAL CAPITAL EXPENDITURES               0     (3,963)        0         0         0          0         0     (5,000)        0         0          0         0     (8,963)   (10,100)    1,137

                                                                                                                                                                                                  Page 20
   37   38   39   40   41   42   43   44   45   46   47