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