Page 12 - Prosper Investor Quarterly Report Academic Year 2021-2022 Quarter 2
P. 12

Baltimore Properties I, LLC
  Prosper on Fayette
                                                                                  Budget Comparison Report
                                                                                        Managed by RISE Residential
                                                                                         As of January 31, 2022

                                                Prior MTD                                                                                                     Prior YTD                   Current
        Month to Date 01/31/2022               01/31/2021                                                             Year to Date 01/31/2022                01/31/2021               Fiscal Year
         Actual      Budget     Variance             Actual    Variance                                               Actual      Budget     Variance              Actual    Variance      Budget


                                                                         CONTROLLABLE EXPENSES
                                                                          PAYROLL OFFICE
          861        2,080       1,219                   0       (861)      6091 - Community Assistants              5,550      12,480        6,930                   0       (5,550)     24,960
        3,894        3,863         (31)                  0     (3,894)      6093 - Leasing Manager Payroll          23,362      23,175         (187)                  0     (23,362)      46,350
        6,534        6,470         (64)                  0     (6,534)      6330 - General Manager                  39,458      38,825         (633)                  0     (39,458)      77,650
        5,715        5,200        (515)                  0     (5,715)      6335 - Leasing Salaries                 33,514      31,200       (2,314)                  0     (33,515)      62,400
             0           0           0                   0           0      6338 - Property Bonuses                  4,820       5,965        1,145                   0       (4,820)     17,895
        1,150        1,000        (150)                  0     (1,150)      6339 - Leasing Bonuses                   4,901       3,250       (1,651)                  0       (4,901)      7,500
       18,154      18,613          459                   0    (18,154)    TOTAL PAYROLL OFFICE                    111,605      114,895        3,290                   0    (111,605)     236,755

                                                                          PAYROLL MAINTENANCE
        3,745        3,814          69                   0     (3,744)      6510 - Maintenance Salaries              9,664      22,880       13,216                   0       (9,664)     45,760
        5,041        5,000         (42)                  0     (5,042)      6511 - Maintenance Supervisor           30,166      30,000         (166)                  0     (30,166)      60,000
        8,786        8,814          27                   0     (8,786)    TOTAL PAYROLL MAINTENANCE                 39,830      52,880       13,050                   0     (39,830)     105,760
                                                                          PAYROLL RELATED EXPENSES
          806           26        (780)                  0       (806)      6711 - State Unemployment Tax            1,381       1,514          132                   0       (1,381)      1,935
          178            6        (171)                  0       (177)      6712 - Federal Unemployment                287         349           63                   0        (286)         446
        2,428        2,098        (330)                  0     (2,429)      6713 - Employer Portion of FICA         12,471      12,835          363                   0     (12,472)      26,202
          289          293           4                   0       (289)      6722 - Workers Compensation              1,481       1,795          315                   0       (1,480)      3,665
        1,160        1,622         462                   0     (1,159)      6723 - Health Insurance Expense          6,426       9,728        3,302                   0       (6,427)     19,457
           18           60          42                   0        (18)      6724 - Dental & Vision Insurance           409         361          (48)                  0        (409)         721
           22          222         200                   0        (22)      6725 - Long/Short Term Disability           22       1,359        1,337                   0          (22)      2,774
           60            0         (60)                  0        (60)      6726 - Life Insurance                      342            0        (342)                  0        (342)           0
          197          118         (78)                  0       (197)      6730 - 401k Contributions Expense        1,338         710         (628)                  0       (1,338)      1,420
          121           91         (31)                  0       (121)      6108 - Payroll Fees                        655         542         (113)                  0        (656)       1,085
        5,279        4,536        (742)                  0     (5,279)    TOTAL PAYROLL RELATED EXP.                24,812      29,193        4,381                   0     (24,812)      57,705

       32,219      31,963         (256)                  0    (32,219)    TOTAL PAYROLL                           176,247      196,968       20,721                   0    (176,247)     400,220

                                                                          GENERAL & ADMINISTRATIVE
           23          240         217                   0        (23)      6116 - Recruiting & Hiring                 609         240         (368)                  0        (608)         240
        4,686        4,700          14                   0     (4,686)      6228 - General Cleaning                 21,448      28,200        6,751                   0     (21,448)      56,400

                                                                                                                                                                                                   Page 6
   7   8   9   10   11   12   13   14   15   16   17