Page 41 - Eagle Landing Academic Year 2021-22 Quarter 2

Eagle Landing

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 3,728 889 894 1,077 752 932 2,678 2,678 2,678 2,678 2,678 2,678 24,339 32,058 (7,719)
6093 - Leasing Manager Payroll 4,315 4,446 4,446 4,446 4,446 4,446 4,423 4,423 4,423 4,423 4,423 4,423 53,083 54,077 (994)
6330 - General Manager 6,253 6,531 6,438 6,438 6,438 6,438 6,373 6,373 6,373 6,373 6,373 6,373 76,776 76,479 297
6332 - Assistant General Manager 4,093 4,153 4,153 4,153 3,963 3,209 4,120 4,120 4,120 4,120 4,120 4,120 48,444 49,440 (996)
6335 - Leasing Salaries 9,563 5,806 5,733 5,119 5,850 6,444 6,284 6,284 6,284 6,284 6,284 6,284 76,217 78,366 (2,150)
6338 - Property Bonuses 0 0 0 10,328 0 2,868 12,724 0 0 12,724 0 0 38,644 50,896 (12,252)
6339 - Leasing Bonuses 20,990 0 0 0 0 7,460 0 0 0 0 0 0 28,450 21,510 6,941
TOTAL PAYROLL OFFICE 48,942 21,825 21,664 31,561 21,449 31,797 36,602 23,878 23,878 36,602 23,878 23,878 345,953 362,826 (16,873)
PAYROLL MAINTENANCE
6510 - Maintenance Salaries 11,961 6,593 6,002 6,321 5,966 4,981 6,395 6,395 6,395 6,395 6,395 6,395 80,194 82,386 (2,192)
6511 - Maintenance Supervisor 4,802 5,053 5,053 5,052 5,052 5,052 5,000 5,000 5,000 5,000 5,000 5,000 60,063 59,999 64
6512 - Housekeeping/Porter Salaries 5,313 4,045 3,296 3,016 2,969 3,237 3,001 3,001 3,001 3,001 3,001 3,001 39,881 35,922 3,958
TOTAL PAYROLL MAINTENANCE 22,076 15,691 14,351 14,389 13,987 13,270 14,396 14,396 14,396 14,396 14,396 14,396 180,138 178,307 1,830
PAYROLL RELATED EXPENSES
6711 - State Unemployment Tax 17 8 3 3 2 92 391 66 61 316 61 57 1,077 5,153 (4,075)
6712 - Federal Unemployment 47 22 10 7 4 251 103 17 15 83 15 15 591 1,365 (774)
6713 - Employer Portion of FICA 4,275 4,433 2,704 3,465 2,659 3,381 3,901 2,928 2,928 3,901 2,928 2,928 40,431 41,396 (965)
6722 - Workers Compensation 1,035 807 760 785 762 741 908 771 771 908 771 771 9,791 10,119 (328)
6723 - Health Insurance Expense 1,213 1,213 1,213 1,213 1,214 1,191 2,432 2,432 2,432 2,432 2,432 2,431 21,849 29,183 (7,334)
6724 - Dental & Vision Insurance 228 228 235 235 227 189 271 271 271 271 271 271 2,963 3,248 (285)
6725 - Long/Short Term Disability 0 0 5 975 965 41 413 310 310 413 310 310 4,052 4,383 (331)
6726 - Life Insurance 107 107 136 138 116 107 0 0 0 0 0 0 712 0 713
6730 - 401k Contributions Expense 113 91 122 227 78 165 161 161 161 161 161 161 1,766 1,935 (171)
6108 - Payroll Fees 170 170 177 198 212 208 354 354 354 354 354 355 3,260 4,251 (990)
TOTAL PAYROLL RELATED EXP. 7,205 7,079 5,365 7,246 6,239 6,366 8,934 7,310 7,303 8,839 7,303 7,299 86,492 101,033 (14,540)

TOTAL PAYROLL 78,223 44,595 41,380 53,196 41,675 51,433 59,932 45,584 45,577 59,837 45,577 45,573 612,583 642,166 (29,583)
GENERAL & ADMINISTRATIVE
6116 - Recruiting & Hiring 0 0 0 0 0 273 0 0 384 0 0 384 1,040 2,116 (1,075)
6231 - Background Check Employee 0 71 0 0 0 0 0 0 180 0 0 180 431 720 (290)
6232 - Office Expense 1,031 845 100 1,305 767 694 575 575 575 575 1,375 575 8,991 7,700 1,291
6233 - Dues & Subscriptions 0 0 0 0 2,959 971 0 0 0 0 0 0 3,931 3,790 141
6234 - Office Equipment 1,080 276 275 455 276 303 695 695 695 695 695 695 6,834 8,340 (1,505)
6235 - Postage 693 260 15 63 9 35 140 140 140 140 140 140 1,916 2,150 (235)
6237 - Computer & Software 3,010 2,985 2,986 6,889 3,194 3,063 4,094 4,644 5,162 4,094 4,094 4,093 48,307 58,432 (10,125)
6238 - Legal-Eviction / Property 0 0 0 0 0 0 0 0 835 0 0 835 1,670 3,340 (1,670)

Page 20