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

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
   8   9   10   11   12   13   14   15   16   17   18