Page 40 - Anthem House Academic Year 2021-22 Quarter 2
P. 40

Gainesville Properties III, LLC
    Anthem House
                                                                                    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         44,705     68,352   164,780    194,100   156,660   119,343    108,068   127,202    126,352   119,606   127,674    127,529  1,484,372  1,437,407   46,965
     DEBT SERVICE
       6820 - Interest Expense                  0         0          0         0         0     98,508     31,419    31,419     31,419    31,419    31,419     31,419   287,022    282,771     4,251
     TOTAL DEBT SERVICE                         0         0          0         0         0     98,508     31,419    31,419     31,419    31,419    31,419     31,419   287,022    282,771     4,251

     CASH FLOW AFTER DEBT SERVICE          44,705     68,352   164,780    194,100   156,660    20,835     76,649    95,783     94,933    88,187    96,255     96,110  1,197,349  1,154,636   42,714

     CAPITAL EXPENDITURES
       1504 - Furniture-Units               (3,137)       0          0         0         0          0         0          0         0         0          0         0     (3,137)        0     (3,137)
       1525 - Asphalt & Concrete            (4,620)       0          0         0         0          0         0          0         0         0          0         0     (4,620)        0     (4,620)
     TOTAL CAPITAL EXPENDITURES             (7,757)       0          0         0         0          0         0          0         0         0          0         0     (7,757)        0     (7,757)
     CASH FLOW BEFORE DEPREC/              52,462     68,352   164,780    194,100   156,660    20,835     76,649    95,783     94,933    88,187    96,255     96,110  1,205,107  1,154,636   50,471
     AMORT

     DEPRECIATION/AMORTIZATION
       8000 - Depreciation - FF&E               0      7,301     9,450      9,221     9,221     9,222      9,221     9,221      9,221     9,221     9,221      9,221    99,742     99,741        1
       8003 - Amortization - Loan Fees/Transaction  0  5,968     5,968      5,968     5,968     5,968      5,968     5,968      5,968     5,968     5,968      5,968    65,647     65,648        0
       Cost
       8005 - Deprec Expense-Building           0     51,325    51,358     51,359    51,404    51,413     51,413    51,413     51,413    51,413    51,413     51,413   565,337    565,336        1
     TOTAL DEPREC/AMORT                         0     64,594    66,776     66,548    66,593    66,603     66,602    66,602     66,602    66,602    66,602     66,602   730,726    730,725        2

     CASH FLOW AFTER DEPREC/AMORT          52,462      3,758    98,004    127,552    90,067    (45,768)   10,047    29,181     28,331    21,585    29,653     29,508   474,381    423,911    50,470
     AND OTHER EXP.


     RECONCILIATION TO GAAP NET IN-
     COME (LOSS)
       CAPITAL EXPENDITURES
        1525 - Asphalt & Concrete           4,620         0          0         0         0          0         0          0         0         0          0         0      4,620         0      4,620
        1504 - Furniture-Units              3,137         0          0         0         0          0         0          0         0         0          0         0      3,137         0      3,137
       TOTAL CAPITAL EXPENDITURES           7,757         0          0         0         0          0         0          0         0         0          0         0      7,757         0      7,757
     GAAP NET INCOME (LOSS)                44,705      3,758    98,004    127,552    90,067    (45,768)   10,047    29,181     28,331    21,585    29,653     29,508   466,622    423,911    42,711










                                                                                                                                                                                                  Page 19
   35   36   37   38   39   40   41   42   43   44   45