Page 48 - Eagle Landing Academic Year 2021-22 Quarter 2
P. 48

Eagle Landing

                                                                                    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        202,316    337,739   404,362    407,278   339,285   371,773    347,384   343,096    367,899   361,240   348,561    300,921  4,131,854  3,890,264  241,590
     DEBT SERVICE
       6820 - Interest Expense            192,014    192,014   185,820    192,014   185,820   192,014    192,014   173,432    192,014   185,820   192,013    185,820  2,260,808  2,260,808       1
     TOTAL DEBT SERVICE                   192,014    192,014   185,820    192,014   185,820   192,014    192,014   173,432    192,014   185,820   192,013    185,820  2,260,808  2,260,808       1

     CASH FLOW AFTER DEBT SERVICE          10,302    145,725   218,542    215,264   153,465   179,759    155,370   169,664    175,885   175,420   156,548    115,101  1,871,046  1,629,456  241,590

     RESERVES
       1320 - Replacement Reserve Fund      9,728      9,728     9,728      9,728     9,728     9,728      9,728     9,728      9,728     9,728     9,728      9,728   116,736    116,736        0
     TOTAL RESERVES                         9,728      9,728     9,728      9,728     9,728     9,728      9,728     9,728      9,728     9,728     9,728      9,728   116,736    116,736        0

     CAPITAL EXPENDITURES
       1465 - Equipment                         0         0      1,482         0         0          0         0          0         0         0          0         0      1,482         0      1,482
       1466 - Computer Equip/Software       4,856       976          0         0         0          0         0          0         0         0          0         0      5,832         0      5,832
       1504 - Furniture-Units                   0         0          0         0         0          0         0     25,000         0         0          0         0     25,000     25,000        0
       1513 - Landscaping                       0         0      4,995      4,995    (4,995)        0         0          0         0         0          0         0      4,995         0      4,995
       1520 - Amenities - Exterior              0         0      6,660      1,584        0          0         0          0         0         0          0         0      8,244      7,720      524
       1521 - Amenities - Interior              0         0          0         0         0          0         0          0         0         0          0         0          0     16,000   (16,000)
       1526 - Carpet/Vinyl Replacement      3,723         0          0         0         0          0         0          0         0         0          0         0      3,724     23,000   (19,276)
       1533 - Appliances                        0         0          0      1,116      (593)        0         0          0         0         0          0         0        523      9,000    (8,477)
       1544 - Computers                         0         0          0         0         0          0         0          0         0         0          0         0          0      7,000    (7,000)
       1546 - Fitness Center - Equipment        0         0          0         0         0          0         0          0         0         0          0         0          0     19,900   (19,900)
       1555 - Lighting - Exterior               0      7,889         0         0         0          0         0          0         0         0          0         0      7,889         0      7,889
       1560 - Maintenance Equipment             0         0          0         0         0          0         0          0         0         0          0         0          0      2,775    (2,775)
       1565 - Painting - Exterior               0         0          0         0         0          0         0          0         0         0          0         0          0     14,925   (14,925)
       1570 - Playgrounds & Picinic Areas       0         0          0         0         0          0         0          0         0         0          0         0          0      2,400    (2,400)
       1581 - Pool Furniture                    0         0          0         0         0          0         0          0         0         0          0         0          0     19,200   (19,200)
       1585 - Roof & Gutters                    0         0          0         0      6,650         0         0          0         0         0          0         0      6,650         0      6,650
       1590 - Safety Systems                  567         0      2,910         0         0          0         0          0         0         0          0         0      3,477      8,034    (4,557)
     TOTAL CAPITAL EXPENDITURES             9,146      8,865    16,047      7,695     1,062         0         0     25,000         0         0          0         0     67,816    154,954   (87,138)
     CASH FLOW BEFORE DEPREC/               (8,572)  127,132   192,767    197,841   142,675   170,031    145,642   134,936    166,157   165,692   146,820    105,373  1,686,494  1,357,766  328,728
     AMORT
     DEPRECIATION/AMORTIZATION
       8006 - Amortization-Loan Fees        4,084      4,084     4,084      4,083     4,084     4,083      4,083     4,084      4,084     4,084     4,084      4,084    49,004     49,004        0
       8010 - Depreciation Expense        113,318    113,568   113,566    113,703   113,821   113,836    113,804   113,804    113,804   113,804   113,804    113,804  1,364,635  1,364,722      (87)
     TOTAL DEPREC/AMORT                   117,402    117,652   117,650    117,786   117,905   117,919    117,887   117,888    117,888   117,888   117,888    117,888  1,413,639  1,413,726      (87)
     OTHER EXPENSES
       8517 - Audit/Tax Return Fees             0         0      7,776         0         0          0         0     13,950         0         0          0         0     21,726     13,950     7,776
                                                                                                                                                                                                  Page 24
   43   44   45   46   47   48   49   50   51   52   53