Page 32 - Anthem House Academic Year 2021-22 Quarter 2
P. 32
Gainesville Properties III, LLC
Anthem House
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
6093 - Leasing Manager Payroll 2,814 2,883 2,841 2,627 2,949 1,339 2,666 2,666 2,666 2,666 2,666 2,666 31,447 31,991 (543)
6330 - General Manager 5,041 5,041 5,041 5,042 1,789 4,231 5,000 5,000 5,000 5,000 5,000 5,000 56,186 60,000 (3,815)
6332 - Assistant General Manager 0 0 0 0 0 951 0 0 0 0 0 0 950 0 951
6335 - Leasing Salaries 948 660 396 576 72 0 1,800 1,800 1,800 1,800 1,800 1,800 13,452 21,600 (8,148)
6338 - Property Bonuses 0 0 0 0 0 0 5,063 0 0 5,063 0 0 10,126 20,252 (10,126)
6339 - Leasing Bonuses 1,900 600 (2,500) 0 850 0 1,000 1,000 1,000 1,000 1,000 1,000 6,850 8,000 (1,150)
TOTAL PAYROLL OFFICE 10,703 9,184 5,778 8,245 5,660 6,521 15,529 10,466 10,466 15,529 10,466 10,466 119,011 141,843 (22,831)
PAYROLL MAINTENANCE
6511 - Maintenance Supervisor 4,876 4,542 4,307 3,141 204 0 4,583 4,583 4,583 4,583 4,583 4,583 44,571 54,999 (10,429)
6512 - Housekeeping/Porter Salaries 2,184 1,631 1,258 1,469 1,268 1,602 1,417 1,417 1,417 1,417 1,417 1,417 17,914 17,004 910
TOTAL PAYROLL MAINTENANCE 7,060 6,173 5,565 4,610 1,472 1,602 6,000 6,000 6,000 6,000 6,000 6,000 62,485 72,003 (9,519)
PAYROLL RELATED EXPENSES
6711 - State Unemployment Tax 9 5 4 4 0 18 137 23 23 137 23 23 404 1,430 (1,026)
6712 - Federal Unemployment 23 14 10 10 0 48 37 6 6 37 6 6 202 379 (177)
6713 - Employer Portion of FICA 1,322 1,138 3,087 946 531 617 1,647 1,259 1,259 1,647 1,259 1,259 15,974 16,359 (386)
6722 - Workers Compensation 362 326 301 264 104 118 376 322 322 376 322 322 3,514 4,037 (522)
6723 - Health Insurance Expense 811 810 811 811 407 (284) 1,839 1,840 1,840 1,839 1,840 1,840 14,406 22,078 (7,672)
6724 - Dental & Vision Insurance 120 120 119 120 275 (3) 90 90 90 90 90 90 1,290 1,080 210
6725 - Long/Short Term Disability 19 20 20 19 77 (8) 175 134 134 175 134 134 1,029 1,732 (703)
6726 - Life Insurance 48 48 48 48 48 (34) 48 48 48 48 48 48 494 576 (82)
6730 - 401k Contributions Expense 0 0 0 0 0 (23) 92 91 91 92 91 91 528 1,102 (574)
6108 - Payroll Fees 85 85 81 83 88 69 85 85 85 85 85 85 1,001 1,020 (19)
TOTAL PAYROLL RELATED EXP. 2,799 2,566 4,481 2,305 1,530 518 4,526 3,898 3,898 4,526 3,898 3,898 38,842 49,793 (10,951)
TOTAL PAYROLL 20,562 17,923 15,824 15,160 8,662 8,641 26,055 20,364 20,364 26,055 20,364 20,364 220,338 263,639 (43,301)
GENERAL & ADMINISTRATIVE
6116 - Recruiting & Hiring 0 0 0 0 0 638 0 0 0 0 0 0 638 240 398
6228 - General Cleaning 0 210 0 0 0 0 0 0 0 0 0 0 210 0 210
6231 - Background Check Employee 78 0 0 0 0 82 0 0 125 0 0 125 410 500 (90)
6232 - Office Expense 1,080 97 103 0 601 208 200 200 200 200 200 200 3,289 2,400 888
6233 - Dues & Subscriptions 0 0 696 0 0 0 0 0 0 0 0 0 695 1,300 (604)
6234 - Office Equipment 0 0 84 0 0 0 0 0 0 0 0 0 85 0 85
6235 - Postage 187 47 10 20 14 20 25 25 25 25 25 25 449 550 (102)
6237 - Computer & Software 239 424 887 1,581 283 2,054 857 858 858 857 858 858 10,612 12,316 (1,702)
6239 - Parking Permits 0 0 0 0 0 0 0 0 0 0 0 0 0 150 (150)
6240 - Bank Charges 142 228 235 273 184 294 450 450 450 450 450 450 4,055 5,400 (1,346)
Page 15