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

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
   26   27   28   29   30   31   32   33   34   35   36