Page 48 - Eagle Landing Academic Year 2021-22 Quarter 2
P. 48
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
CASH FLOW BEFORE DEBT SERVICE 202,316 337,739 404,362 407,278 339,285 371,773 347,384 343,096 367,899 361,240 348,561 300,921 4,131,854 3,890,264 241,590
DEBT SERVICE
6820 - Interest Expense 192,014 192,014 185,820 192,014 185,820 192,014 192,014 173,432 192,014 185,820 192,013 185,820 2,260,808 2,260,808 1
TOTAL DEBT SERVICE 192,014 192,014 185,820 192,014 185,820 192,014 192,014 173,432 192,014 185,820 192,013 185,820 2,260,808 2,260,808 1
CASH FLOW AFTER DEBT SERVICE 10,302 145,725 218,542 215,264 153,465 179,759 155,370 169,664 175,885 175,420 156,548 115,101 1,871,046 1,629,456 241,590
RESERVES
1320 - Replacement Reserve Fund 9,728 9,728 9,728 9,728 9,728 9,728 9,728 9,728 9,728 9,728 9,728 9,728 116,736 116,736 0
TOTAL RESERVES 9,728 9,728 9,728 9,728 9,728 9,728 9,728 9,728 9,728 9,728 9,728 9,728 116,736 116,736 0
CAPITAL EXPENDITURES
1465 - Equipment 0 0 1,482 0 0 0 0 0 0 0 0 0 1,482 0 1,482
1466 - Computer Equip/Software 4,856 976 0 0 0 0 0 0 0 0 0 0 5,832 0 5,832
1504 - Furniture-Units 0 0 0 0 0 0 0 25,000 0 0 0 0 25,000 25,000 0
1513 - Landscaping 0 0 4,995 4,995 (4,995) 0 0 0 0 0 0 0 4,995 0 4,995
1520 - Amenities - Exterior 0 0 6,660 1,584 0 0 0 0 0 0 0 0 8,244 7,720 524
1521 - Amenities - Interior 0 0 0 0 0 0 0 0 0 0 0 0 0 16,000 (16,000)
1526 - Carpet/Vinyl Replacement 3,723 0 0 0 0 0 0 0 0 0 0 0 3,724 23,000 (19,276)
1533 - Appliances 0 0 0 1,116 (593) 0 0 0 0 0 0 0 523 9,000 (8,477)
1544 - Computers 0 0 0 0 0 0 0 0 0 0 0 0 0 7,000 (7,000)
1546 - Fitness Center - Equipment 0 0 0 0 0 0 0 0 0 0 0 0 0 19,900 (19,900)
1555 - Lighting - Exterior 0 7,889 0 0 0 0 0 0 0 0 0 0 7,889 0 7,889
1560 - Maintenance Equipment 0 0 0 0 0 0 0 0 0 0 0 0 0 2,775 (2,775)
1565 - Painting - Exterior 0 0 0 0 0 0 0 0 0 0 0 0 0 14,925 (14,925)
1570 - Playgrounds & Picinic Areas 0 0 0 0 0 0 0 0 0 0 0 0 0 2,400 (2,400)
1581 - Pool Furniture 0 0 0 0 0 0 0 0 0 0 0 0 0 19,200 (19,200)
1585 - Roof & Gutters 0 0 0 0 6,650 0 0 0 0 0 0 0 6,650 0 6,650
1590 - Safety Systems 567 0 2,910 0 0 0 0 0 0 0 0 0 3,477 8,034 (4,557)
TOTAL CAPITAL EXPENDITURES 9,146 8,865 16,047 7,695 1,062 0 0 25,000 0 0 0 0 67,816 154,954 (87,138)
CASH FLOW BEFORE DEPREC/ (8,572) 127,132 192,767 197,841 142,675 170,031 145,642 134,936 166,157 165,692 146,820 105,373 1,686,494 1,357,766 328,728
AMORT
DEPRECIATION/AMORTIZATION
8006 - Amortization-Loan Fees 4,084 4,084 4,084 4,083 4,084 4,083 4,083 4,084 4,084 4,084 4,084 4,084 49,004 49,004 0
8010 - Depreciation Expense 113,318 113,568 113,566 113,703 113,821 113,836 113,804 113,804 113,804 113,804 113,804 113,804 1,364,635 1,364,722 (87)
TOTAL DEPREC/AMORT 117,402 117,652 117,650 117,786 117,905 117,919 117,887 117,888 117,888 117,888 117,888 117,888 1,413,639 1,413,726 (87)
OTHER EXPENSES
8517 - Audit/Tax Return Fees 0 0 7,776 0 0 0 0 13,950 0 0 0 0 21,726 13,950 7,776
Page 24