E-SPLOST Annual Report (6.30.2024)

AID 1722459 · View on Simbli

Agenda Item

a. E-SPLOST / Finance Reporting ~ Updated 11.21.2024

Summary: Presented by: Mr. Erick Hofstetter, Chief Operating Officer, Division of Operations and
Mr. Byron Schueneman, Chief Financial Officer, Division of Finance
Contact: Presented by Mr. Erick Hofstetter, Chief Operating Officer, Division of Operations and
Mr. Byron Schueneman, Chief Financial Officer, Division of Finance
                                                                        E-SPLOST Schedule FY24                                                                                     SCHEDULE "12"


                                                                                                                            AMOUNT            AMOUNT
                                                                                  ORIGINAL            CURRENT              EXPENDED          EXPENDED              TOTAL             ESTIMATED
                                                                                 ESTIMATED           ESTIMATED            IN CURRENT          IN PRIOR           COMPLETION         COMPLETION
PROJECT                                                                           COST (1)            COSTS (2)           YEAR (3) (4)      YEARS (3) (4)           COST               DATE

2012 Sales Tax - Authorized Projects


       1 Americans with Disabilities Act (ADA) Improvements               $       2,342,500.00   $    15,044,323.50   $        2,728.10 $    15,041,595.40 $      15,044,323.50         Completed
       2 Stadiums                                                                 9,557,400.00        10,628,646.65                          10,628,646.65        10,628,646.65         Completed
       3 Capital Renewal Program                                                 84,892,200.00        97,547,198.89           27,432.31      94,175,155.66        94,202,587.97         Completed
       4 Code Requirements                                                        2,342,500.00         2,677,726.34                           2,677,726.34         2,677,726.34         Completed
       5 Coralwood Diagnostic Center Addition                                     9,932,200.00         6,164,482.54                           6,164,482.54         6,164,482.54         Completed
       6 Early Learning Center                                                    2,717,300.00         2,188,329.76                           2,188,329.76         2,188,329.76         Completed
       7 Arts School at former Avondale MS                                        4,029,100.00        11,127,167.00                             310,896.41   -                            June-28
       8 Renovation of Southwest DeKalb HS & Stone Mountain HS                   11,056,600.00        34,163,839.27                          34,163,839.27        34,163,839.27         Completed
       9 Replacement of Austin ES, Fernbank ES, Gresham Park ES,
         Pleasantdale ES, Peachcrest ES, Rockbridge ES, Smoke Rise ES           135,021,700.00       172,480,185.67         121,106.71      169,675,372.86       169,796,479.57         Completed
      10 Henderson MS Renovation/Addition                                        14,992,000.00        19,245,872.25                          19,245,872.25        19,245,872.25         Completed
      11 Redan HS Renovation/Addition                                            20,988,800.00        22,065,648.16                          22,065,648.16        22,065,648.16         Completed
      12 Chamblee HS Replacement                                                 55,001,900.00        69,089,766.52       5,810,912.50       63,278,854.02        69,089,766.52         Completed
      13 McNair MS Replacement                                                   35,043,800.00        40,742,607.53           9,000.00       40,733,607.53        40,733,607.53         Completed
      14 Local School Priority Requests                                           5,153,500.00         2,902,294.25                           2,902,294.25         2,902,294.25         Completed
      15 Demolition                                                               2,342,500.00         4,221,328.66                           4,221,328.66         4,221,328.66         Completed
      16 Safety/Security Systems Upgrade                                          2,342,500.00         2,292,719.24                           2,292,719.24         2,292,719.24         Completed
      17 Technology Equipment & Infrastructure Refresh                           36,261,900.00        33,277,357.33                          33,277,357.33        33,277,357.33         Completed
      18 School Buses                                                             9,463,700.00        12,800,247.61                          12,800,247.61        12,800,247.61         Completed
      19 Service Vehicles                                                         1,592,900.00         2,252,530.33                           2,252,530.33         2,252,530.33         Completed
      20 Other capital improvements & supporting services (includes
         Bond Series 2012 Bond Issuance Costs, Principal Payments,
         and 2011 COPs Interest Payments)                                        29,925,000.00        82,132,562.14            1,819.89      80,269,196.14        80,271,016.03   Completed


                                                                          $     475,000,000.00   $   643,044,833.64   $   5,972,999.51 $    618,365,700.41 $     624,018,803.51




                                                                                                                                                                                                 1 of 4
                                                                                                                             AMOUNT            AMOUNT
                                                                                  ORIGINAL             CURRENT              EXPENDED          EXPENDED               TOTAL       ESTIMATED
                                                                                 ESTIMATED            ESTIMATED            IN CURRENT          IN PRIOR            COMPLETION   COMPLETION
PROJECT                                                                           COST (1)             COSTS (2)           YEAR (3) (4)      YEARS (3) (4)            COST         DATE

2017 Sales Tax - Authorized Projects


       1 Making of site, facility and technology improvements
         deemed necessary to improve safety and security, such as
         enhancing surveillance systems, fire alarm systems, fire
         sprinkler installation, perimeter fencing, etc. at some or all
         of the DeKalb County School District (DCSD) schools and
         facilities;                                                         $    12,872,000.00   $    41,245,876.00   $    1,481,120.05 $     9,071,921.48 $ -                      June-26
       2 Adding to, modifying, replacing, reconfiguring schools and/or
         creating new schools and/or facilities to accommodate
         current and future student enrollment, address major facility
         conditions, develop early childhood centers, enhance
         regional support of schools, and accomodate expanded new
         programmatic needs, and acquiring land for constructing and
         equipping new and/or replacement schools/facilities, or
         equivalent facility capactiy, including, but not limited to, site
         preparation and the demolition of all or portions of existing
         structures and/or acquiring leasehold purchasing of
         facilities/properties as needed based on DCSD's
         determination of need priorities;                                       298,180,000.00       260,642,220.00        6,414,172.84     128,188,034.58    -                     June-28
       3 Adding to, renovating, modifying, reconfiguring, equipping,
         upgrading, supplementing, acquiring, replacing, and
         installing capital improvements for various existing and new
         schools, buildings and facilities (including schools, buildings
         and facilities to be constructed pursuant to this resolution,
         once completed and including any site preparation and
         demolition of existing structures if necessary) e.g., roofing,
         plumbing, wiring, painting, water piping, HVAC, making
         athletic field and physical education facility upgrades and
         improvements, ADA renovations, infrastructure improvements,
         repaving, restroom facilities, systems for environmental and
         air quality control, physical education facilities, kitchens,
         improvements to comply with health, safety and applicable
         building codes, traffic control and optimization, parking and
         parking capacity, stormwater management facilities, and
         program-driven modifications, as needed based on the
         DCSD's determination of need priorities;                                 96,948,000.00       184,311,643.00       69,328,444.51      45,184,718.89    -                     June-28
       4 Making technology improvements, by acquiring, replacing,
         purchasing, installing, upgrading or supplementing
         technology including, but not limited to technology that
         supports and/or enhances instruction, digital communication
         technology, enhanced school security solutions, wireless
         technology, enterprise content management solutions,
         replacement and/or enhancement of technology/systems in
         support of an Enterprise Resource Planning (ERP) upgrade,
         data storage systems, telecommunication systems, digital
         records retention, technology hardware, software, and related




                                                                                                                                                                                             2 of 4
  infrastructure at some or all of the DCSD schools and
  facilities, as needed;                                               65,000,000.00        71,500,000.00         882,920.43       63,238,978.52     -          June-25
5 Replacing, purchasing, upgrading, refurbishing or
  supplementing school buses and support vehicles and other
  capital equipment as needed including, but not limited to
  items such as desks, chairs, tables, instructional equipment,
  band equipment, kitchen equipment, waste compactors,
  portable classroom/modular buildings, custodial equipment,
  grounds equipment, etc. at some or all DCSD schools and
  facilities;                                                          40,000,000.00        40,312,169.00        1,070,466.33      35,371,541.21     -          June-26
6 and the expenses incidental to accomplishing the DeKalb
  projects including, but not limited to, implementation
  expenses, management expenses, and legal expenses.                   48,000,000.00        32,288,092.00          99,474.10       30,458,719.03     -          June-28


                                                                  $   561,000,000.00   $   630,300,000.00   $   79,276,598.26 $   311,513,913.71 $       0.00




                                                                                                                                                                     3 of 4
                                                                                                                                                                         AMOUNT            AMOUNT
                                                                                                                   ORIGINAL                   CURRENT                   EXPENDED          EXPENDED             TOTAL              ESTIMATED
                                                                                                                  ESTIMATED                  ESTIMATED                 IN CURRENT          IN PRIOR          COMPLETION          COMPLETION
PROJECT                                                                                                            COST (1)                   COSTS (2)                YEAR (3) (4)      YEARS (3) (4)          COST                DATE

2021 Sales Tax - Authorized Projects


       1 Adding to, upgrading, reconfiguring, renovating, replacing, modifying and
         equipping existing and replacement schools, support facilities, athletic fields
         and physical education facilities;                                                             $        150,000,000.00      $        28,000,000.00       $     3,869,848.21 $    2,835,661.75   $                -           June-28

       2 Acquiring and developing land for, constructing and equipping, new and
         replacement schools and support facilities, as well as additions to existing
         facilities;                                                                                             352,000,000.00              516,150,000.00             2,731,003.80                -                     -         January-28

       3 Installing capital improvements for various existing and new schools,
         buildings and facilities;                                                                                69,000,000.00              128,750,000.00                        -                -                     -         January-28

       4 Providing hardware, software, and related infrastructure and making
         technology improvements;                                                                                129,000,000.00               95,000,000.00            2,173,429.08                 -                     -         January-28

       5 Replacing, purchasing, upgrading school buses, support vehicles, and other
         capital equipment                                                                                        40,000,000.00               35,500,000.00                        -                -                     -         January-28


                                                                                                            $    740,000,000.00      $       803,400,000.00       $     8,774,281.09 $     2,835,661.75 $                 0.00



                                                                                                            $   1,776,000,000.00     $     2,076,744,833.64       $    94,023,878.86 $   932,715,275.87 $    624,018,803.51



                                       (1) The School District's original cost estimate as specified in the resolution calling for the imposition of the Local Option Sales Tax.

                                       (2) The School District's current estimate of total cost for the projects. Includes all cost from project inception to completion.

                                       (3) The voters of DeKalb County approved the imposition of a 1% sales tax to fund the above projects and retire associated debt. Amounts expended for these projects may include
                                           sales tax proceeds, state, local property taxes and/or other funds over the life of the projects.




                                                                                                                                                                                                                                              4 of 4