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

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

     CONTROLLABLE EXPENSES

       PAYROLL OFFICE
        6093 - Leasing Manager Payroll      2,814      2,883     2,841      2,627     2,949     1,339      2,666     2,666      2,666     2,666     2,666      2,666    31,447     31,991      (543)
        6330 - General Manager              5,041      5,041     5,041      5,042     1,789     4,231      5,000     5,000      5,000     5,000     5,000      5,000    56,186     60,000    (3,815)
        6332 - Assistant General Manager        0         0          0         0         0        951         0          0         0         0          0         0        950         0       951
        6335 - Leasing Salaries               948       660        396       576        72          0      1,800     1,800      1,800     1,800     1,800      1,800    13,452     21,600    (8,148)
        6338 - Property Bonuses                 0         0          0         0         0          0      5,063         0         0      5,063         0         0     10,126     20,252   (10,126)
        6339 - Leasing Bonuses              1,900       600     (2,500)        0       850          0      1,000     1,000      1,000     1,000     1,000      1,000     6,850      8,000    (1,150)
       TOTAL PAYROLL OFFICE                10,703      9,184     5,778      8,245     5,660     6,521     15,529    10,466     10,466    15,529    10,466     10,466   119,011    141,843   (22,831)
       PAYROLL MAINTENANCE
        6511 - Maintenance Supervisor       4,876      4,542     4,307      3,141      204          0      4,583     4,583      4,583     4,583     4,583      4,583    44,571     54,999   (10,429)
        6512 - Housekeeping/Porter Salaries  2,184     1,631     1,258      1,469     1,268     1,602      1,417     1,417      1,417     1,417     1,417      1,417    17,914     17,004      910
       TOTAL PAYROLL MAINTENANCE            7,060      6,173     5,565      4,610     1,472     1,602      6,000     6,000      6,000     6,000     6,000      6,000    62,485     72,003    (9,519)

       PAYROLL RELATED EXPENSES
        6711 - State Unemployment Tax           9         5          4         4         0         18       137         23        23       137         23        23        404      1,430    (1,026)
        6712 - Federal Unemployment            23        14         10        10         0         48        37          6         6        37          6         6        202       379       (177)
        6713 - Employer Portion of FICA     1,322      1,138     3,087       946       531        617      1,647     1,259      1,259     1,647     1,259      1,259    15,974     16,359      (386)
        6722 - Workers Compensation           362       326        301       264       104        118       376        322       322       376        322       322      3,514      4,037      (522)
        6723 - Health Insurance Expense       811       810        811       811       407       (284)     1,839     1,840      1,840     1,839     1,840      1,840    14,406     22,078    (7,672)
        6724 - Dental & Vision Insurance      120       120        119       120       275         (3)       90         90        90        90         90        90      1,290      1,080      210
        6725 - Long/Short Term Disability      19        20         20        19        77         (8)      175        134       134       175        134       134      1,029      1,732      (703)
        6726 - Life Insurance                  48        48         48        48        48        (34)       48         48        48        48         48        48        494       576        (82)
        6730 - 401k Contributions Expense       0         0          0         0         0        (23)       92         91        91        92         91        91        528      1,102      (574)
        6108 - Payroll Fees                    85        85         81        83        88         69        85         85        85        85         85        85      1,001      1,020       (19)
       TOTAL PAYROLL RELATED EXP.           2,799      2,566     4,481      2,305     1,530       518      4,526     3,898      3,898     4,526     3,898      3,898    38,842     49,793   (10,951)
       TOTAL PAYROLL                       20,562     17,923    15,824     15,160     8,662     8,641     26,055    20,364     20,364    26,055    20,364     20,364   220,338    263,639   (43,301)

       GENERAL & ADMINISTRATIVE
        6116 - Recruiting & Hiring              0         0          0         0         0        638         0          0         0         0          0         0        638       240       398
        6228 - General Cleaning                 0       210          0         0         0          0         0          0         0         0          0         0        210         0       210
        6231 - Background Check Employee       78         0          0         0         0         82         0          0       125         0          0       125        410       500        (90)
        6232 - Office Expense               1,080        97        103         0       601        208       200        200       200       200        200       200      3,289      2,400      888
        6233 - Dues & Subscriptions             0         0        696         0         0          0         0          0         0         0          0         0        695      1,300      (604)
        6234 - Office Equipment                 0         0         84         0         0          0         0          0         0         0          0         0         85         0        85
        6235 - Postage                        187        47         10        20        14         20        25         25        25        25         25        25        449       550       (102)
        6237 - Computer & Software            239       424        887      1,581      283      2,054       857        858       858       857        858       858     10,612     12,316    (1,702)
        6239 - Parking Permits                  0         0          0         0         0          0         0          0         0         0          0         0          0       150       (150)
        6240 - Bank Charges                   142       228        235       273       184        294       450        450       450       450        450       450      4,055      5,400    (1,346)

                                                                                                                                                                                                  Page 15
   27   28   29   30   31   32   33   34   35   36   37