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

Baltimore Properties I, LLC
    Prosper on Fayette
                                                                                    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             0         0      1,167      1,896     1,626       861      2,080     2,080      2,080     2,080     2,080      2,081    18,030     24,960    (6,930)
        6093 - Leasing Manager Payroll      3,893      3,893     3,894      3,893     3,894     3,894      3,863     3,862      3,863     3,863     3,863      3,862    46,536     46,350      186
        6330 - General Manager              6,284      7,036     6,534      6,535     6,534     6,534      6,470     6,471      6,470     6,470     6,470      6,471    78,283     77,650      633
        6335 - Leasing Salaries             5,316      5,653     6,297      5,370     5,164     5,715      5,200     5,200      5,200     5,200     5,200      5,200    64,715     62,400     2,315
        6338 - Property Bonuses             2,849     (2,849)        0      4,820        0          0      5,965         0         0      5,965         0         0     16,750     17,895    (1,145)
        6339 - Leasing Bonuses              3,300         0          0         0       450      1,150       625        625       500       500      1,000      1,000     9,150      7,500     1,650
       TOTAL PAYROLL OFFICE                21,642     13,733    17,892     22,514    17,668    18,154     24,203    18,238     18,113    24,078    18,613     18,614   233,464    236,755    (3,291)
       PAYROLL MAINTENANCE
        6510 - Maintenance Salaries             0         0          0      2,390     3,530     3,745      3,814     3,813      3,814     3,814     3,814      3,813    32,545     45,760   (13,215)
        6511 - Maintenance Supervisor       5,000      5,000     5,041      5,042     5,042     5,041      5,000     5,000      5,000     5,000     5,000      5,000    60,166     60,000      166
       TOTAL PAYROLL MAINTENANCE            5,000      5,000     5,041      7,432     8,572     8,786      8,814     8,813      8,814     8,814     8,814      8,813    92,711    105,760   (13,049)

       PAYROLL RELATED EXPENSES
        6711 - State Unemployment Tax         261        39         31       111       134        806       171         17        13       168         26        26      1,801      1,935      (133)
        6712 - Federal Unemployment            45         0          7        26        30        178        40          3         3        39          6         6        384       446        (63)
        6713 - Employer Portion of FICA     2,482      1,624     1,715      2,252     1,969     2,428      2,525     2,070      2,060     2,516     2,098      2,098    25,839     26,202      (363)
        6722 - Workers Compensation           216       208        216       266       287        289       354        289       288       352        293       294      3,350      3,665      (315)
        6723 - Health Insurance Expense       811       811      1,215      1,215     1,215     1,160      1,621     1,622      1,621     1,621     1,622      1,621    16,155     19,457    (3,302)
        6724 - Dental & Vision Insurance       60        60         90        90        90         18        60         60        60        60         60        60        769       721        49
        6725 - Long/Short Term Disability       0         0          0         0         0         22       267        219       218       267        222       222      1,437      2,774    (1,337)
        6726 - Life Insurance                  51        51         60        60        60         60         0          0         0         0          0         0        342         0       342
        6730 - 401k Contributions Expense     554       113        147       189       139        197       119        118       119       118        118       119      2,048      1,420      627
        6108 - Payroll Fees                   113       113        102        99       106        121        90         90        90        90         91        90      1,198      1,085      113
       TOTAL PAYROLL RELATED EXP.           4,593      3,019     3,583      4,308     4,030     5,279      5,247     4,488      4,472     5,231     4,536      4,536    53,323     57,705    (4,382)
       TOTAL PAYROLL                       31,235     21,752    26,516     34,254    30,270    32,219     38,264    31,539     31,399    38,123    31,963     31,963   379,498    400,220   (20,722)

       GENERAL & ADMINISTRATIVE
        6116 - Recruiting & Hiring              0        71        515         0         0         23         0          0         0         0          0         0        608       240       369
        6228 - General Cleaning             1,550      2,069     3,671      4,686     4,787     4,686      4,700     4,700      4,700     4,700     4,700      4,700    49,649     56,400    (6,752)
        6231 - Background Check Employee        0        81         74       240         0          0         0          0         0         0          0         0        396         0       396
        6232 - Office Expense                 795        36        135       369        49        151       400          0         0       400          0         0      2,335      2,000      336
        6233 - Dues & Subscriptions             0       867          0         0         0      1,101         0          0         0         0          0         0      1,967      1,662      304
        6235 - Postage                        273        71         58        21         0        252        50         50        50        50         50        50        977       600       377
        6237 - Computer & Software          1,305      1,174     1,187      2,621     1,525     1,898      1,438     1,438      1,437     1,438     1,437      1,437    18,333     18,697      (365)
        6239 - Parking Permits                  0         0          0         0         0          0         0          0         0         0        465         0        465       465         0
        6240 - Bank Charges                   103       888      1,405      1,809     2,692     2,561       350        350       350       350        350       350     11,558      4,200     7,359
        6241 - License & Permits            7,850         0         27     (1,338)      27         27         0          0         0         0          0         0      6,593      8,450    (1,857)

                                                                                                                                                                                                  Page 15
   25   26   27   28   29   30   31   32   33   34   35