Page 48 - Oxford West Investor Quarterly Report Academic Year 2021-2022 Quarter 2

Oxford West Properties I, LLLP

Financial Analysis Report
Managed by RISE Residential
As of December 31, 2021

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 Budget Budget Budget Budget Budget Budget Budget Act/Bud Budget Variance
REVENUE

GROSS RENTAL INCOME 357,284 351,439 349,565 351,872 349,979 356,881 356,881 356,881 356,881 356,881 356,881 356,881 4,258,306 4,273,673 (15,367)
COST OF LEASING (104,322) (95,610) (87,544) (93,842) (85,915) (88,865) (83,506) (84,706) (84,706) (83,506) (83,506) (98,421) (1,074,449) (1,070,465) (3,983)
NET RENTAL INCOME 252,962 255,829 262,021 258,030 264,064 268,016 273,375 272,175 272,175 273,375 273,375 258,461 3,183,857 3,203,208 (19,350)

OTHER INCOME 20,401 34,335 29,637 17,984 39,771 42,350 41,075 55,775 7,900 9,625 16,050 22,125 337,029 317,221 19,807
TOTAL INCOME 273,363 290,164 291,658 276,014 303,835 310,366 314,450 327,950 280,075 283,000 289,425 280,586 3,520,886 3,520,429 457

CONTROLLABLE EXPENSES
PAYROLL OFFICE 21,284 15,125 16,768 13,880 13,151 20,825 17,940 14,592 20,825 17,940 14,592 20,825 207,745 217,188 (9,443)
PAYROLL MAINTENANCE 10,782 9,022 8,500 8,970 9,013 7,975 8,225 8,225 7,725 7,725 7,725 7,725 101,611 98,150 3,462
PAYROLL RELATED EXPENSES 5,443 4,731 4,223 4,888 3,866 5,616 5,235 4,751 5,571 5,152 4,669 5,488 59,634 65,531 (5,898)
TOTAL PAYROLL 37,509 28,878 29,491 27,738 26,030 34,416 31,400 27,568 34,121 30,817 26,986 34,038 368,990 380,869 (11,879)

GENERAL & ADMINISTRATIVE 16,252 6,356 4,966 6,688 5,125 6,575 7,640 5,300 5,525 5,840 4,675 4,675 79,620 81,846 (2,225)
PROFESSIONAL FEES 0 0 31 0 0 0 0 0 0 0 0 0 30 0 30
CONTRACT SERVICES 12,174 14,202 5,378 6,981 6,571 6,419 7,419 5,619 5,619 5,919 7,419 5,619 89,339 91,478 (2,139)
TURNOVER EXPENSE 110,704 172 391 0 590 50 50 50 50 50 50 50 112,207 111,445 762
REPAIRS & MAINTENANCE 3,805 4,891 1,562 2,786 1,144 1,740 1,890 1,690 1,940 2,190 2,040 1,890 27,568 27,260 308
MARKETING & LEASING 31,402 5,621 3,415 960 (4,059) 1,637 4,687 8,687 4,837 3,887 1,487 1,637 64,196 66,044 (1,849)
UTILITIES 50,866 49,734 44,912 45,041 66,690 60,174 57,571 62,629 50,384 50,276 45,113 50,759 634,152 632,076 2,077
MANAGEMENT FEES 13,597 11,266 11,100 11,263 11,270 12,415 12,578 13,118 11,203 11,320 11,577 11,223 141,929 140,817 1,112

TOTAL CONTROLLABLE EXPENSES 276,309 121,120 101,246 101,457 113,361 123,426 123,235 124,661 113,679 110,299 99,347 109,891 1,518,031 1,531,835 (13,803)

CONTROLLABLE CASH FLOW (2,946) 169,044 190,412 174,557 190,474 186,940 191,215 203,289 166,396 172,701 190,078 170,695 2,002,855 1,988,594 14,261
TAXES & INSURANCE 48,893 48,185 50,303 48,185 48,186 50,809 48,617 48,466 51,684 48,467 48,467 50,810 591,071 588,103 2,967

NET OPERATING INCOME (51,839) 120,859 140,109 126,372 142,288 136,131 142,598 154,823 114,712 124,234 141,611 119,885 1,411,784 1,400,491 11,293

OTHER FINANCE RELATED 0 0 5 0 5 0 0 0 0 0 0 0 10 0 10

CASH FLOW BEFORE DEBT SERVICE (51,839) 120,859 140,104 126,372 142,283 136,131 142,598 154,823 114,712 124,234 141,611 119,885 1,411,774 1,400,491 11,283
DEBT SERVICE 120,556 120,556 116,667 120,555 116,666 116,666 116,666 116,666 116,666 116,666 116,666 116,666 1,411,662 1,399,992 11,670

CASH FLOW AFTER DEBT SERVICE (172,395) 303 23,437 5,817 25,617 19,465 25,932 38,157 (1,954) 7,568 24,945 3,219 112 499 (387)
RESERVES 9,083 9,083 (18,464) 9,084 9,084 9,084 9,083 9,084 9,083 9,083 9,083 9,083 81,452 109,000 (27,547)

Page 24