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

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
   17   18   19   20   21   22   23   24   25   26   27