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

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
     REVENUE

       GROSS RENTAL INCOME                583,930    581,288   582,245    581,389   586,598   578,138    579,176   579,176    579,176   579,176   579,176    579,176  6,968,644  6,950,112   18,532
       COST OF LEASING                      (4,899)   (6,340)   (6,326)    (6,342)   (7,140)    (7,696)  (20,077)  (20,077)   (20,077)  (20,077)   (20,077)  (21,950)  (161,078)  (255,883)  94,805
       NET RENTAL INCOME                  579,031    574,948   575,919    575,047   579,458   570,442    559,099   559,099    559,099   559,099   559,099    557,226  6,807,566  6,694,229  113,337

       OTHER INCOME                        31,296     34,910    86,347     80,833    52,537    60,308     50,435    48,685     62,585    62,585    46,060     43,435   660,015    591,298    68,717
     TOTAL INCOME                         610,327    609,858   662,266    655,880   631,995   630,750    609,534   607,784    621,684   621,684   605,159    600,661  7,467,581  7,285,527  182,054

     CONTROLLABLE EXPENSES
       PAYROLL OFFICE                      48,942     21,825    21,664     31,561    21,449    31,797     36,602    23,878     23,878    36,602    23,878     23,878   345,953    362,826   (16,873)
       PAYROLL MAINTENANCE                 22,076     15,691    14,351     14,389    13,987    13,270     14,396    14,396     14,396    14,396    14,396     14,396   180,138    178,307     1,830
       PAYROLL RELATED EXPENSES             7,205      7,079     5,365      7,246     6,239     6,366      8,934     7,310      7,303     8,839     7,303      7,299    86,492    101,033   (14,540)
       TOTAL PAYROLL                       78,223     44,595    41,380     53,196    41,675    51,433     59,932    45,584     45,577    59,837    45,577     45,573   612,583    642,166   (29,583)

       GENERAL & ADMINISTRATIVE            13,054     12,937     7,279     13,455    12,803    15,365     12,892    10,522     16,979    10,592    11,187     15,910   152,973    171,889   (18,917)
       PROFESSIONAL FEES                        0         0         30         0         0          0         0          0       625         0          0       625      1,280      2,500    (1,219)
       CONTRACT SERVICES                   22,973     16,890    18,758     18,740    16,770    16,848     20,041    34,821     19,121    21,156    18,781     21,911   246,810    255,407    (8,598)
       TURNOVER EXPENSE                   121,731       (420)       52        11      1,911     2,961       275          0         0       275          0     35,400   162,195    183,905   (21,709)
       REPAIRS & MAINTENANCE                4,503      6,188     9,788      4,036     5,234     8,161      5,046     4,076     11,151     5,046     6,961     13,426    83,617    107,557   (23,940)
       MARKETING & LEASING                  8,806     24,781     9,052      6,277     8,757     8,904     10,438     9,553      8,088     7,923    15,658      7,583   125,819    149,106   (23,287)
       UTILITIES                           63,224     71,556    70,693     61,955    87,668    56,802     61,863    68,530     60,005    63,376    65,523     67,959   799,156    786,693    12,463
       MANAGEMENT FEES                     22,490     14,679    26,468     16,528    28,989    19,793     21,333    21,272     21,759    21,759    21,181     21,023   257,275    254,994     2,281

     TOTAL CONTROLLABLE EXPENSES          335,004    191,206   183,500    174,198   203,807   180,267    191,820   194,358    183,305   189,964   184,868    229,410  2,441,708  2,554,217  (112,509)

     CONTROLLABLE CASH FLOW               275,323    418,652   478,766    481,682   428,188   450,483    417,714   413,426    438,379   431,720   420,291    371,251  5,025,873  4,731,310  294,563
     TAXES & INSURANCE                     73,007     80,913    74,404     74,404    88,903    78,710     70,330    70,330     70,480    70,480    71,730     70,330   894,018    841,046    52,972

     NET OPERATING INCOME                 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
     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                         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                               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                   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

                                                                                                                                                                                                  Page 26
   47   48   49   50   51   52   53   54   55   56   57