October 2022 PY to CY Comparison Report (1)

AID 1452435 · View on Simbli

Agenda Item

i. F.3.a. Approval of the October 2022 Monthly Financial Reports

Summary: Presented by: Mrs. Masana Mailliard, Interim Chief Financial Officer, Division of Finance
Request: It is requested that the Board of Education accept the October 2022 Monthly Financial Report.
Contact: Mrs. Masana Mailliard, Interim Chief Financial Officer, Division of Finance, 678.676.0446
Status: General Counsel approval not required
                                                 DEKALB COUNTY BOARD OF EDUCATION
                                             GENERAL FUND - PRIOR YEAR COMPARISON CHARTS
                                                         October - 10/31/2022


                                                               Revenues Comparison


                    400,000,000

                    350,000,000

                    300,000,000

                    250,000,000

                    200,000,000

                    150,000,000

                    100,000,000

                     50,000,000

                                   0
                                       Local Revenue                  State Revenue                   Other Revenue                  Total Revenue
        FY22 - Prior Fiscal Year        316,229,105                     47,967,720                        5,485                       364,202,310
        FY23 - Current Fiscal Year      175,157,418                    48,732,788                         614,427                    224,504,633

                                                       FY22 - Prior Fiscal Year       FY23 - Current Fiscal Year


Local revenue recognition attributable to October decreased due to known timing differences in local property tax remittance.
Compression experienced in the revenue recognition cycle does not substantially change the total annual collection expected. Total
fiscal year-to-date Local Revenues of $431,128,887.54 are 11.7% higher than the previous year. Investment earnings, as reflected in
the Other Revenue category, are substantially higher than previous averages due to rising interest rates earned on cash reserves.




                                                            Expenditures Comparison

                    140,000,000

                    120,000,000

                    100,000,000

                     80,000,000

                     60,000,000

                     40,000,000

                     20,000,000

                                   0
                                       Instruction           Pupil Services           Maintenance and              Other Functions    Total Expenditures
                                                                                         Operation
        FY22 - Prior Fiscal Year       75,267,290              6,284,744                 7,638,733                   39,775,708          128,966,475
        FY23 - Current Fiscal Year     71,835,021              6,551,632                 9,963,185                   41,204,955          129,554,793

                                                       FY22 - Prior Fiscal Year       FY23 - Current Fiscal Year


Amounts attributable to the General Fund were comparable to the previous reporting period. Total monthly expenditures are higher
than previous month averages due to the scheduled payment in settlement of the Gold case for $22,500,000.00. Of the original
$117,500,000.00 settlement, $90,000,000.00 has been paid life-to-date.