Page 23 - Oxford West Investor Quarterly Report 1.25.22
P. 23

Forecasted Income Statement                                                Property:Oxford West


 Aug 2021  Sep 2021  Oct 2021  Nov 2021  Dec 2021  Jan 2022  Feb 2022  Mar 2022  Apr 2022  May 2022  Jun 2022  Jul 2022  Total  Annual
 Account  Account Name  Actual  Actual  Actual  Actual  Actual  Actual  Budget  Budget  Budget  Budget  Budget  Budget  Forecast  Budget  $ Variance  % Variance
 6544  Plumbing Contract  605.00  475.00  0.00  0.00  415.00  0.00  300.00  0.00  0.00  300.00  0.00  0.00  2,095.00  1,400.00  (695.00)  -49.64%
 6548  Snow Removal  0.00  0.00  0.00  0.00  0.00  3,452.74  1,500.00  0.00  0.00  0.00  0.00  0.00  4,952.74  4,100.00  (852.74)  -20.80%
 Contract Services  12,173.58  14,201.91  5,378.58  6,980.96  6,570.73  9,332.59  7,419.00  5,619.00  5,619.00  5,919.00  7,419.00  5,619.00  92,252.35  91,478.00  (774.35)  -0.85%

 Turnover Expense
 6581  Interior Paint - Contract Labor  50,750.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  50,750.00  50,925.00  175.00  0.34%
 6582  Interior Paint - Supplies  8,022.61  81.27  80.85  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  8,184.73  8,000.00  (184.73)  -2.31%
 6583  Floor-Cleaning Contract  6,129.08  63.90  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  6,192.98  6,120.00  (72.98)  -1.19%
 6585  Blinds/Drapes  252.91  26.86  309.51  0.00  0.00  0.00  50.00  50.00  50.00  50.00  50.00  50.00  889.28  800.00  (89.28)  -11.16%
 6586  Turn Cleaning  35,470.00  0.00  0.00  0.00  590.00  2,090.00  0.00  0.00  0.00  0.00  0.00  0.00  38,150.00  35,520.00  (2,630.00)  -7.40%
 6588  Turn Labor  10,080.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  10,080.00  10,080.00  0.00  0.00%
 Total Turnover Expense  110,704.60  172.03  390.36  0.00  590.00  2,090.00  50.00  50.00  50.00  50.00  50.00  50.00  114,246.99  111,445.00  (2,801.99)  -2.51%

 Repairs & Maintenance
 6304  Vehicle Maintenance  114.15  166.15  0.00  0.00  37.96  0.00  40.00  40.00  90.00  40.00  40.00  90.00  658.26  760.00  101.74  13.39%
 6515  Cleaning Supplies  393.51  156.93  0.00  276.32  0.00  0.00  50.00  50.00  50.00  50.00  50.00  50.00  1,126.76  1,000.00  (126.76)  -12.68%
 6516  Keys & Locks  82.48  161.23  0.00  89.20  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  332.91  100.00  (232.91)  -232.91%
 Interior Floor Repair/Cleaning (Non-
 6519  0.00  0.00  0.00  649.66  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  649.66  0.00  (649.66)  -100.00%
 Turn)
 6556  Other Maint Repairs & Supplies  510.86  354.42  365.18  159.50  243.79  114.04  300.00  300.00  300.00  300.00  300.00  300.00  3,547.79  3,800.00  252.21  6.64%
 6557  Appliance Parts & Supplies  0.00  228.14  0.00  0.00  213.01  0.00  250.00  250.00  250.00  250.00  250.00  250.00  1,941.15  3,000.00  1,058.85  35.30%
 6558  Electrical Parts & Supplies  126.46  255.09  64.27  135.46  26.61  36.16  200.00  0.00  200.00  0.00  200.00  0.00  1,244.05  1,200.00  (44.05)  -3.67%
 6559  Plumbing Parts & Supplies  1,248.27  726.87  707.56  825.31  268.30  695.76  500.00  500.00  500.00  500.00  500.00  500.00  7,472.07  7,300.00  (172.07)  -2.36%
 6560  HVAC Parts & Supplies  186.93  0.00  152.68  143.39  135.82  0.00  200.00  200.00  200.00  200.00  200.00  200.00  1,818.82  2,400.00  581.18  24.22%
 6561  Pool Parts & Supplies  186.05  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  500.00  150.00  150.00  986.05  950.00  (36.05)  -3.79%
 6570  Equipment and Tools  27.99  253.31  54.29  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  335.59  0.00  (335.59)  -100.00%
 6571  Fitness Equipment Repair  0.00  0.00  0.00  372.75  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  372.75  0.00  (372.75)  -100.00%
 6574  Light Bulbs  423.28  467.06  0.00  0.00  0.00  60.65  100.00  100.00  100.00  100.00  100.00  100.00  1,550.99  1,850.00  299.01  16.16%
 6576  Life Safety System R&M  286.18  1,903.42  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  2,189.60  1,900.00  (289.60)  -15.24%
 6578  Maintenance Uniforms  218.36  218.36  218.36  134.31  218.79  54.59  250.00  250.00  250.00  250.00  250.00  250.00  2,562.77  3,000.00  437.23  14.57%
 Total Repairs & Maintenance  3,804.52  4,890.98  1,562.34  2,785.90  1,144.28  961.20  1,890.00  1,690.00  1,940.00  2,190.00  2,040.00  1,890.00  26,789.22  27,260.00  470.78  1.73%

 Marketing & Leasing
 6205  Advertising/Marketing  5,176.29  376.30  100.00  0.00  (805.05)  0.00  37.00  5,037.00  37.00  37.00  37.00  37.00  10,069.54  10,444.00  374.46  3.59%
 6212  Internet Advertising  5,588.15  4,772.45  837.95  582.55  1,098.51  1,137.39  2,250.00  3,250.00  4,250.00  3,250.00  1,250.00  1,250.00  29,517.00  30,900.00  1,383.00  4.48%
 6214  Brochures  0.00  0.00  (0.65)  0.00  176.14  0.00  0.00  0.00  0.00  0.00  0.00  0.00  175.49  0.00  (175.49)  -100.00%
 6215  Signage / Flags/ Banners  0.00  0.00  160.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  160.00  300.00  140.00  46.67%
 6218  Leasing Promotional Activities  1,150.32  471.40  2,317.60  377.03  470.65  527.18  400.00  400.00  400.00  600.00  200.00  200.00  7,514.18  6,800.00  (714.18)  -10.50%
 6222  Model Expense  0.00  0.00  0.00  0.00  0.00  0.00  0.00  0.00  150.00  0.00  0.00  150.00  300.00  600.00  300.00  50.00%
 6261  Promotional Items  4,487.00  0.00  0.00  0.00  0.00  0.00  2,000.00  0.00  0.00  0.00  0.00  0.00  6,487.00  7,000.00  513.00  7.33%
 6283  Gift Cards and Leasing Incentives  15,000.00  0.00  0.00  0.00  (5,000.00)  0.00  0.00  0.00  0.00  0.00  0.00  0.00  10,000.00  10,000.00  0.00  0.00%
 Total Marketing & Leasing  31,401.76  5,620.15  3,414.90  959.58  (4,059.75)  1,664.57  4,687.00  8,687.00  4,837.00  3,887.00  1,487.00  1,637.00  64,223.21  66,044.00  1,820.79  2.76%


 Common Area Utilities
 6450  C/A Electricity  1,855.60  1,775.64  1,473.82  1,536.21  1,834.82  1,840.02  2,015.85  2,005.90  2,003.91  2,005.90  2,005.90  2,003.91  22,357.48  20,175.36  (2,182.12)  -10.82%
 6452  C/A Natural Gas  0.00  0.00  0.00  12.22  0.00  971.57  0.00  0.00  0.00  0.00  0.00  0.00  983.79  0.00  (983.79)  -100.00%
 Total Common Area Utilities  1,855.60  1,775.64  1,473.82  1,548.43  1,834.82  2,811.59  2,015.85  2,005.90  2,003.91  2,005.90  2,005.90  2,003.91  23,341.27  20,175.36  (3,165.91)  -15.69%

 Unit Utilities
 6460  Electricity Vacant Units  3,180.21  2,644.99  5,377.03  1,888.75  2,628.55  6,218.59  2,677.50  2,601.00  1,530.00  2,754.00  1,530.00  1,530.00  34,560.62  30,504.80  (4,055.82)  -13.30%
 6461  Electricity Occupied Units  15,530.73  15,609.72  10,568.71  10,619.88  26,759.93  34,004.98  20,640.00  22,308.00  14,157.00  13,330.00  12,040.00  18,060.00  213,628.95  198,041.00  (15,587.95)  -7.87%
 6462  Cable  4,817.92  4,817.92  4,818.00  4,817.97  3,693.57  4,817.97  4,818.00  4,818.00  4,818.00  4,818.00  4,818.00  4,818.00  56,691.35  57,816.00  1,124.65  1.95%
 6463  Water/Sewer Units  11,888.52  10,973.01  15,767.23  12,500.00  13,771.45  8,485.00  9,120.00  14,196.00  12,675.00  12,168.00  11,520.00  10,647.00  143,711.21  138,589.00  (5,122.21)  -3.70%
 6464  Natural Gas  1,382.23  1,702.34  530.59  1,874.57  7,822.35  6,760.78  6,100.00  4,500.00  3,000.00  3,000.00  1,000.00  1,500.00  39,172.86  40,550.00  1,377.14  3.40%






 Forecasted Income Statement 1.6 generated 02/18/2022 03:23 PM EST and data as of 02/18/2022 03:23 PM EST  Page 3 of 5
   18   19   20   21   22   23   24   25   26   27   28