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

Oxford West Properties I, LLLP

Budget Comparison Report
Managed by RISE Residential
As of December 31, 2021

Prior MTD Prior YTD Current
Month to Date 12/31/2021 12/31/2020 Year to Date 12/31/2021 12/31/2020 Fiscal Year
Actual Budget Variance Actual Variance Actual Budget Variance Actual Variance Budget
REVENUE

RENTAL INCOME
385,800 385,390 410 377,285 8,515 5120 - Gross Potential Rent (GPR) 1,928,590 1,926,950 1,640 1,885,981 42,609 4,624,680
(35,821) (28,509) (7,312) (18,013) (17,808) 5125 - Gain/Loss to Lease (168,451) (151,444) (17,007) (76,299) (92,151) (351,007)
349,979 356,881 (6,902) 359,272 (9,293) GROSS RENTAL INCOME 1,760,139 1,775,506 (15,367) 1,809,682 (49,542) 4,273,673
COST OF LEASING
(79,944) (79,740) (204) (59,349) (20,595) 5220 - Rent Loss-Vacancy (422,658) (420,370) (2,288) (318,363) (104,295) (966,550)
(1,415) (1,500) 85 (1,545) 130 5221 - Rent Loss-Model (7,075) (7,500) 425 (7,725) 650 (18,000)
(1,480) (1,480) 0 (1,480) 0 5222 - Rent Loss-Security (7,400) (7,400) 0 (6,480) (920) (17,760)
(3,076) (3,186) 110 (5,914) 2,838 5223 - Employee Units (15,201) (15,630) 429 (29,770) 14,569 (37,932)
0 0 0 0 0 5250 - Concessions (6,136) (6,480) 344 0 (6,137) (6,480)
0 0 0 0 0 5255 - Bad Debt Expense (8,763) (5,870) (2,893) (30,843) 22,080 (23,743)
(85,915) (85,906) (9) (68,288) (17,627) TOTAL COST OF LEASING (467,233) (463,250) (3,983) (393,181) (74,053) (1,070,465)
264,064 270,975 (6,911) 290,984 (26,920) NET RENTAL INCOME 1,292,906 1,312,256 (19,350) 1,416,501 (123,595) 3,203,208

OTHER INCOME
0 0 0 0 0 5175 - Storage Space Rental 0 0 0 168 (168) 0
0 0 0 0 0 5914 - Vending Income 115 0 115 0 116 0
2,284 2,000 284 1,965 319 5920 - Late Charge Income 8,944 8,500 444 6,930 2,014 19,500
50 100 (50) 0 50 5924 - NSF Check Fee Income 400 500 (100) 250 150 1,200
0 0 0 0 0 5926 - Administrative Fee (720) 0 (720) 0 (720) 0
0 0 0 140 (140) 5927 - Resident Insurance Program (36) 0 (36) 40 (76) 0
150 0 150 0 150 5929 - Hold Over Fee 3,000 0 3,000 760 2,240 0
390 1,000 (610) 568 (178) 5930 - Resident Damages 6,841 4,000 2,841 5,269 1,572 5,500
150 0 150 123 27 5932 - Cleaning Fee (471) 2,000 (2,471) 625 (1,096) 2,000
5,000 0 5,000 0 5,000 5950 - Lease Termination Fees 12,500 0 12,500 0 12,500 0
0 225 (225) 0 0 5951 - Application Fees 90 1,125 (1,035) (135) 225 9,000
90 300 (210) 250 (160) 5952 - Onetime Pet Fee Income 9,120 9,300 (180) 5,700 3,420 12,300
50 250 (200) 0 50 5953 - Fines 1,226 1,100 126 350 876 2,850
25 75 (50) 0 25 5954 - Replmnt Keys/Cards/Lock Outs 195 425 (230) 60 135 950
29,314 27,300 2,014 27,252 2,061 5956 - Utility Income 91,702 85,871 5,831 89,901 1,802 241,771

Page 5