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

Oxford West Properties I, LLLP

13 Month Trend Report
Managed by RISE Residential
As of December 31, 2021

Prior Year Rolling 12
12/31/2020 12/31/2021 11/30/2021 10/31/2021 09/30/2021 08/31/2021 07/31/2021 06/30/2021 05/31/2021 04/30/2021 03/31/2021 02/28/2021 01/31/2021 Month Total
REVENUE

GROSS RENTAL INCOME 359,272 349,979 351,872 349,565 351,439 357,284 357,035 356,995 360,887 359,271 359,083 358,608 373,094 4,285,112
COST OF LEASING (68,288) (85,915) (93,842) (87,544) (95,610) (104,322) (128,383) (108,276) (66,130) (70,637) (82,401) (66,578) (65,143) (1,054,782)
NET RENTAL INCOME 290,984 264,064 258,030 262,021 255,829 252,962 228,652 248,719 294,757 288,634 276,682 292,030 307,951 3,230,330
OTHER INCOME 32,576 39,771 17,984 29,637 34,335 20,401 22,824 24,413 7,424 14,224 55,014 39,200 41,437 346,665

TOTAL INCOME 323,560 303,835 276,014 291,658 290,164 273,363 251,476 273,132 302,181 302,858 331,696 331,230 349,388 3,576,995
CONTROLLABLE EXPENSES

PAYROLL OFFICE 16,568 13,151 13,880 16,768 15,125 21,284 24,746 17,247 17,831 21,566 12,968 15,440 22,015 212,019
PAYROLL MAINTENANCE 8,808 9,013 8,970 8,500 9,022 10,782 7,034 7,027 7,231 6,753 4,201 4,307 7,705 90,547
PAYROLL RELATED EXPENSES 4,592 3,866 4,888 4,223 4,731 5,443 6,149 4,646 4,149 5,951 4,442 6,252 6,438 61,175
TOTAL PAYROLL 29,968 26,030 27,738 29,491 28,878 37,509 37,929 28,920 29,211 34,270 21,611 25,999 36,158 363,741

GENERAL & ADMINISTRATIVE 5,004 5,125 6,688 4,966 6,356 16,252 9,157 6,759 5,846 6,616 6,840 6,038 7,226 87,872
PROFESSIONAL FEES 0 0 0 31 0 0 122 0 152 30 30 61 29 456
CONTRACT SERVICES 8,162 6,571 6,981 5,378 14,202 12,174 6,401 4,372 6,240 7,898 8,383 16,814 10,600 106,012
TURNOVER EXPENSE 128 590 0 391 172 110,704 639 2,353 0 176 0 603 735 116,364
REPAIRS & MAINTENANCE 1,874 1,144 2,786 1,562 4,891 3,805 3,246 3,999 2,800 2,556 1,018 2,095 1,570 31,472
MARKETING & LEASING 4,801 (4,059) 960 3,415 5,621 31,402 (17,693) 5,446 5,523 10,196 4,322 15,298 1,901 62,329
UTILITIES 61,573 66,690 45,041 44,912 49,734 50,866 34,065 39,133 51,331 48,561 60,567 88,455 63,938 643,296
MANAGEMENT FEES 13,156 11,270 11,263 11,100 11,266 13,597 11,449 11,511 11,238 12,581 13,341 12,109 12,690 143,414
TOTAL CONTROLLABLE EXPENSES 124,666 113,361 101,457 101,246 121,120 276,309 85,315 102,493 112,341 122,884 116,112 167,472 134,847 1,554,956

CONTROLLABLE CASH FLOW 198,894 190,474 174,557 190,412 169,044 (2,946) 166,161 170,639 189,840 179,974 215,584 163,758 214,541 2,022,038
TAXES & INSURANCE 39,741 48,186 48,185 50,303 48,185 48,893 49,842 48,348 48,348 51,206 53,186 44,986 45,840 585,507

NET OPERATING INCOME 159,153 142,288 126,372 140,109 120,859 (51,839) 116,319 122,291 141,492 128,768 162,398 118,772 168,701 1,436,531

OTHER FINANCE RELATED 0 5 0 5 0 0 168 10 10 5 0 0 0 203

CASH FLOW BEFORE DEBT SERVICE 159,153 142,283 126,372 140,104 120,859 (51,839) 116,151 122,281 141,482 128,763 162,398 118,772 168,701 1,436,327
DEBT SERVICE 116,666 116,666 120,555 116,667 120,556 120,556 116,667 120,556 116,667 120,555 108,888 120,555 120,556 1,419,445

CASH FLOW AFTER DEBT SERVICE 42,487 25,617 5,817 23,437 303 (172,395) (516) 1,725 24,815 8,208 53,510 (1,783) 48,145 16,883
RESERVES 9,084 9,084 9,084 (18,464) 9,083 9,083 (85,852) 9,083 9,083 9,083 9,084 9,084 9,083 (13,483)

Page 35