Page 54 - Oxford West Investor Quarterly Report Academic Year 2021-2022 Quarter 2
P. 54
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
RENTAL INCOME
5120 - Gross Potential Rent (GPR) 377,285 385,800 385,800 385,390 385,800 385,800 385,800 385,800 385,800 377,285 377,285 377,285 377,285 4,595,130
5125 - Gain/Loss to Lease (18,013) (35,821) (33,928) (35,825) (34,361) (28,516) (28,765) (30,345) (24,913) (18,014) (18,202) (18,677) (18,591) (325,958)
5127 - Accelerated Rent 0 0 0 0 0 0 0 1,540 0 0 0 0 14,400 15,940
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
5220 - Rent Loss-Vacancy (59,349) (79,944) (80,272) (81,249) (81,503) (99,690) (83,376) (93,960) (58,649) (63,193) (62,807) (57,769) (59,084) (901,495)
5221 - Rent Loss-Model (1,545) (1,415) (1,415) (1,415) (1,415) (1,415) (1,545) (1,545) (1,545) (1,545) (1,545) (1,545) (1,545) (17,890)
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) (1,480) (17,760)
5223 - Employee Units (5,914) (3,076) (2,601) (3,582) (3,107) (2,835) (4,643) (4,456) (4,456) (4,456) (5,914) (5,914) (5,914) (50,954)
5250 - Concessions 0 0 0 265 (2,180) (4,221) 0 0 0 0 0 0 0 (6,137)
5255 - Bad Debt Expense 0 0 (8,074) (83) (5,925) 5,319 (37,339) (6,835) 0 37 (10,655) 130 2,880 (60,546)
TOTAL 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
5914 - Vending Income 0 0 116 0 0 0 0 0 0 0 0 0 0 116
5920 - Late Charge Income 1,965 2,284 1,020 1,932 3,696 11 4,194 13 65 272 0 (40) 11 13,460
5924 - NSF Check Fee Income 0 50 100 150 50 50 0 100 50 250 100 0 250 1,150
5926 - Administrative Fee 0 0 0 0 (1,200) 480 720 2 0 0 0 0 0 2
5927 - Resident Insurance Program 140 0 0 (36) 0 0 0 0 0 0 0 0 (130) (166)
5929 - Hold Over Fee 0 150 0 0 300 2,550 0 0 0 0 0 0 0 3,000
5930 - Resident Damages 568 390 390 540 1,460 4,061 390 525 440 390 312 390 1,280 10,568
5932 - Cleaning Fee 123 150 0 80 383 (1,083) 2,310 225 338 0 0 0 0 2,402
5940 - Security Deposit Forfeitures 0 0 0 0 0 0 0 9,195 0 8,419 0 0 0 17,614
5950 - Lease Termination Fees 0 5,000 2,500 2,500 2,500 0 2,470 0 0 0 0 0 0 14,970
5951 - Application Fees 0 0 45 0 0 45 0 0 (180) 180 0 0 0 90
5952 - Onetime Pet Fee Income 250 90 900 900 300 6,930 30 1,780 300 600 0 550 0 12,380
5953 - Fines 0 50 25 675 375 100 0 0 50 100 50 50 100 1,576
5954 - Replmnt Keys/Cards/Lock Outs 0 25 0 0 50 120 25 0 15 50 50 50 50 435
5955 - Cable Income 0 0 0 0 0 0 0 35 0 0 0 0 0 35
5956 - Utility Income 27,252 29,314 11,058 21,336 25,073 4,921 11,100 10,556 3,991 1,677 52,707 35,815 37,066 244,612
5957 - Transfer Fees 0 0 0 0 (150) 300 150 300 0 150 150 250 250 1,400
5964 - Monthly Pet Rent Income 1,528 1,438 1,500 1,480 1,400 1,092 1,435 1,432 1,605 1,886 1,395 1,635 1,560 17,858
5146 - Relet Fee 750 750 250 0 58 650 0 250 750 250 250 500 1,000 4,709
5142 - Furniture Income 0 80 80 80 40 174 0 0 0 0 0 0 0 454
TOTAL 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
Page 27