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

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

     CONTROLLABLE EXPENSES

       PAYROLL OFFICE
        6091 - Community Assistants         3,728       889        894      1,077      752        932      2,678     2,678      2,678     2,678     2,678      2,678    24,339     32,058    (7,719)
        6093 - Leasing Manager Payroll      4,315      4,446     4,446      4,446     4,446     4,446      4,423     4,423      4,423     4,423     4,423      4,423    53,083     54,077      (994)
        6330 - General Manager              6,253      6,531     6,438      6,438     6,438     6,438      6,373     6,373      6,373     6,373     6,373      6,373    76,776     76,479      297
        6332 - Assistant General Manager    4,093      4,153     4,153      4,153     3,963     3,209      4,120     4,120      4,120     4,120     4,120      4,120    48,444     49,440      (996)
        6335 - Leasing Salaries             9,563      5,806     5,733      5,119     5,850     6,444      6,284     6,284      6,284     6,284     6,284      6,284    76,217     78,366    (2,150)
        6338 - Property Bonuses                 0         0          0     10,328        0      2,868     12,724         0         0     12,724         0         0     38,644     50,896   (12,252)
        6339 - Leasing Bonuses             20,990         0          0         0         0      7,460         0          0         0         0          0         0     28,450     21,510     6,941
       TOTAL 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
        6510 - Maintenance Salaries        11,961      6,593     6,002      6,321     5,966     4,981      6,395     6,395      6,395     6,395     6,395      6,395    80,194     82,386    (2,192)
        6511 - Maintenance Supervisor       4,802      5,053     5,053      5,052     5,052     5,052      5,000     5,000      5,000     5,000     5,000      5,000    60,063     59,999       64
        6512 - Housekeeping/Porter Salaries  5,313     4,045     3,296      3,016     2,969     3,237      3,001     3,001      3,001     3,001     3,001      3,001    39,881     35,922     3,958
       TOTAL 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
        6711 - State Unemployment Tax          17         8          3         3         2         92       391         66        61       316         61        57      1,077      5,153    (4,075)
        6712 - Federal Unemployment            47        22         10         7         4        251       103         17        15        83         15        15        591      1,365      (774)
        6713 - Employer Portion of FICA     4,275      4,433     2,704      3,465     2,659     3,381      3,901     2,928      2,928     3,901     2,928      2,928    40,431     41,396      (965)
        6722 - Workers Compensation         1,035       807        760       785       762        741       908        771       771       908        771       771      9,791     10,119      (328)
        6723 - Health Insurance Expense     1,213      1,213     1,213      1,213     1,214     1,191      2,432     2,432      2,432     2,432     2,432      2,431    21,849     29,183    (7,334)
        6724 - Dental & Vision Insurance      228       228        235       235       227        189       271        271       271       271        271       271      2,963      3,248      (285)
        6725 - Long/Short Term Disability       0         0          5       975       965         41       413        310       310       413        310       310      4,052      4,383      (331)
        6726 - Life Insurance                 107       107        136       138       116        107         0          0         0         0          0         0        712         0       713
        6730 - 401k Contributions Expense     113        91        122       227        78        165       161        161       161       161        161       161      1,766      1,935      (171)
        6108 - Payroll Fees                   170       170        177       198       212        208       354        354       354       354        354       355      3,260      4,251      (990)
       TOTAL PAYROLL RELATED EXP.           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
        6116 - Recruiting & Hiring              0         0          0         0         0        273         0          0       384         0          0       384      1,040      2,116    (1,075)
        6231 - Background Check Employee        0        71          0         0         0          0         0          0       180         0          0       180        431       720       (290)
        6232 - Office Expense               1,031       845        100      1,305      767        694       575        575       575       575      1,375       575      8,991      7,700     1,291
        6233 - Dues & Subscriptions             0         0          0         0      2,959       971         0          0         0         0          0         0      3,931      3,790      141
        6234 - Office Equipment             1,080       276        275       455       276        303       695        695       695       695        695       695      6,834      8,340    (1,505)
        6235 - Postage                        693       260         15        63         9         35       140        140       140       140        140       140      1,916      2,150      (235)
        6237 - Computer & Software          3,010      2,985     2,986      6,889     3,194     3,063      4,094     4,644      5,162     4,094     4,094      4,093    48,307     58,432   (10,125)
        6238 - Legal-Eviction / Property        0         0          0         0         0          0         0          0       835         0          0       835      1,670      3,340    (1,670)

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