Page 34 - 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

RENTAL INCOME
5120 - Gross Potential Rent (GPR) 385,800 385,800 385,390 385,800 385,800 385,390 385,390 385,390 385,390 385,390 385,390 385,390 4,626,320 4,624,680 1,640
5125 - Gain/Loss to Lease (28,516) (34,361) (35,825) (33,928) (35,821) (28,509) (28,509) (28,509) (28,509) (28,509) (28,509) (28,509) (368,014) (351,007) (17,007)
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
5220 - Rent Loss-Vacancy (99,690) (81,503) (81,249) (80,272) (79,944) (79,740) (77,340) (78,540) (78,540) (77,340) (77,340) (77,340) (968,838) (966,550) (2,288)
5221 - Rent Loss-Model (1,415) (1,415) (1,415) (1,415) (1,415) (1,500) (1,500) (1,500) (1,500) (1,500) (1,500) (1,500) (17,575) (18,000) 425
5222 - Rent Loss-Security (1,480) (1,480) (1,480) (1,480) (1,480) (1,480) (1,480) (1,480) (1,480) (1,480) (1,480) (1,480) (17,760) (17,760) 0
5223 - Employee Units (2,835) (3,107) (3,582) (2,601) (3,076) (3,186) (3,186) (3,186) (3,186) (3,186) (3,186) (3,186) (37,503) (37,932) 429
5250 - Concessions (4,221) (2,180) 265 0 0 0 0 0 0 0 0 0 (6,136) (6,480) 344
5255 - Bad Debt Expense 5,319 (5,925) (83) (8,074) 0 (2,959) 0 0 0 0 0 (14,915) (26,637) (23,743) (2,893)
TOTAL 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
5914 - Vending Income 0 0 0 116 0 0 0 0 0 0 0 0 116 0 115
5920 - Late Charge Income 11 3,696 1,932 1,020 2,284 2,000 1,500 1,500 1,500 1,500 1,500 1,500 19,944 19,500 444
5924 - NSF Check Fee Income 50 50 150 100 50 100 100 100 100 100 100 100 1,100 1,200 (100)
5926 - Administrative Fee 480 (1,200) 0 0 0 0 0 0 0 0 0 0 (720) 0 (720)
5927 - Resident Insurance Program 0 0 (36) 0 0 0 0 0 0 0 0 0 (36) 0 (36)
5929 - Hold Over Fee 2,550 300 0 0 150 0 0 0 0 0 0 0 3,000 0 3,000
5930 - Resident Damages 4,061 1,460 540 390 390 0 0 0 1,500 0 0 0 8,341 5,500 2,841
5932 - Cleaning Fee (1,083) 383 80 0 150 0 0 0 0 0 0 0 (471) 2,000 (2,471)
5950 - Lease Termination Fees 0 2,500 2,500 2,500 5,000 0 0 0 0 0 0 0 12,500 0 12,500
5951 - Application Fees 45 0 0 45 0 225 1,350 1,350 675 450 1,125 2,700 7,965 9,000 (1,035)
5952 - Onetime Pet Fee Income 6,930 300 900 900 90 900 300 300 600 300 300 300 12,120 12,300 (180)
5953 - Fines 100 375 675 25 50 250 250 250 250 250 250 250 2,976 2,850 126
5954 - Replmnt Keys/Cards/Lock Outs 120 50 0 0 25 75 75 75 75 75 75 75 720 950 (230)
5956 - Utility Income 4,921 25,073 21,336 11,058 29,314 37,100 35,800 51,000 2,000 4,000 11,000 15,000 247,602 241,771 5,831
5957 - Transfer Fees 300 (150) 0 0 0 250 500 0 0 500 0 750 2,150 3,000 (850)
5964 - Monthly Pet Rent Income 1,092 1,400 1,480 1,500 1,438 1,200 1,200 1,200 1,200 1,200 1,200 1,200 15,310 14,250 1,060
5146 - Relet Fee 650 58 0 250 750 250 0 0 0 1,250 500 250 3,958 4,900 (942)
5142 - Furniture Income 174 40 80 80 80 0 0 0 0 0 0 0 454 0 454
TOTAL 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

Page 17