Exhibit D. 2027 Initial Revenue Projection

AID 1949903 · View on Simbli

Agenda Item

4. Budget Development Process ~ Updated 1.21.2026

Summary: Presented by: Mr. Byron Schueneman, Chief Financial Officer, Division of Finance
Revenue Group             Description                                ACCOUNT                                         2024 Actual               2025 Actual             2026 Actual           FY27 Initial Budget
Property Taxes            Local Property Taxes                       100.0000.411100.00011.9999.9990.8010.115.0000    $ (848,704,425.11) $ (908,374,674.27) $ (800,320,203.02) $ 996,908,864.87
Sales Taxes               Intangible and Transfer Taxes              100.0000.411210.00011.9999.9990.8010.115.0000    $       (8,791,707.00) $        (8,465,777.45) $       (3,018,057.80) $       7,500,000.00
Property Taxes            Beverage and Excise Taxes                  100.0000.411900.00011.9999.9990.8010.115.0000    $       (4,145,223.42) $        (2,484,405.03) $         (910,772.02) $       3,250,000.00
Property Taxes            TAVT                                       100.0000.411910.00011.9999.9990.8010.115.0000    $     (36,406,172.22) $       (36,028,369.28) $ (12,179,207.13) $            35,500,000.00
Charges for Services      Reimbusement for Transportation Invoices   100.0000.414000.00011.9999.9990.8010.115.0000    $       (1,149,597.44) $        (1,271,658.09) $         (148,389.47) $       1,000,000.00
Investement Earnings      Investment Earnings                        100.0000.415000.00011.9999.9990.8010.115.0000    $     (23,475,343.82) $       (25,443,796.67) $        (7,440,179.88) $      20,000,000.00
Miscellaneous                                                        100.0000.419500.00011.9999.9990.8010.115.0000    $             (3,966.83)
Miscellaneous                                                        100.0000.419950.00011.7520.9990.8010.040.0000    $         (467,534.57) $          (376,402.80) $           (66,250.22)
Miscellaneous             Other Local Miscellaneous Income           100.0000.419950.00011.9999.9990.8010.115.0000    $         (886,238.29) $             20,731.03 $         (281,448.29) $         500,000.00
Miscellaneous                                                        100.0000.419955.00011.9999.9990.8010.115.0000    $           (52,899.22) $             (1,006.63)
State Funds               QBE S&B KINDERGARTEN                       100.0000.431200.00011.9999.1011.8010.115.0000    $     (43,170,087.00) $       (44,576,882.00) $ (13,931,839.00) $            53,848,803.05
State Funds               QBE S&B GRADES 1-3                         100.0000.431200.00011.9999.1021.8010.115.0000    $     (99,147,419.00) $ (103,144,915.00) $ (32,427,208.00) $ 109,900,055.89
State Funds               QBE S&B GRADES 9-12                        100.0000.431200.00011.9999.1041.8010.115.0000    $     (77,399,079.00) $       (82,041,348.00) $ (25,748,637.00) $            87,170,046.92
State Funds               QBE S&B GRADES 4-5                         100.0000.431200.00011.9999.1051.8010.115.0000    $     (47,528,643.00) $       (48,677,517.00) $ (15,328,239.00) $            52,517,800.95
State Funds               QBE S&B EI KINDERGARTEN                    100.0000.431200.00011.9999.1061.8010.115.0000    $       (2,223,058.00) $        (2,603,103.00) $         (805,973.00) $       3,131,797.98
State Funds               QBE S&B EI GRADES 1-3                      100.0000.431200.00011.9999.1071.8010.115.0000    $       (7,721,790.00) $        (9,235,192.00) $       (2,878,242.00) $       9,534,724.32
State Funds               QBE S&B MIDDLE SCHOOLS                     100.0000.431200.00011.9999.1081.8010.115.0000    $     (80,671,243.00) $       (83,616,272.00) $ (26,300,263.00) $            89,642,464.83
State Funds               QBE S&B EI GRADES 4-5                      100.0000.431200.00011.9999.1091.8010.115.0000    $       (4,428,080.00) $        (5,862,606.00) $       (1,812,539.00) $       6,350,941.07
State Funds               TOTAL QBE FORMULA EARNINGS                 100.0000.431200.00011.9999.1100.8010.115.0000    $       (4,479,292.00) $        (4,691,813.00) $       (1,473,943.00) $       5,000,760.68
State Funds               QBE PRINCIPAL STAFF & PROF DEV             100.0000.431200.00011.9999.1211.8010.115.0000    $           (47,688.00) $           (50,127.00) $          (22,396.00) $      5,254,165.83
State Funds               QBE S&B MEDIA CENTERS                      100.0000.431200.00011.9999.1310.8010.115.0000    $     (13,873,342.00) $       (14,557,803.00) $        (4,570,778.00) $      15,732,053.61
State Funds                                                          100.0000.431200.00011.9999.1351.8010.115.0000    $         (749,799.00) $          (534,152.00) $        6,820,918.00 $                  -
State Funds               QBE/S&B-INDIRECT-CENTRAL                   100.0000.431200.00011.9999.1450.8010.115.0000    $     (12,605,325.00) $       (13,321,886.00) $        (4,302,591.00) $      15,415,460.14
State Funds               QBE S&B INDIRECT ADMIN                     100.0000.431200.00011.9999.1455.8010.115.0000    $     (29,947,443.00) $       (31,035,545.00) $ (12,197,788.00) $            36,057,546.40
State Funds               QBE S&B SPECIAL ED                         100.0000.431200.00011.9999.2011.8010.115.0000    $ (101,067,581.00) $ (111,250,169.00) $ (34,465,980.00) $ 127,923,807.88
State Funds               QBE S&B GIFTED                             100.0000.431200.00011.9999.2111.8010.115.0000    $     (39,944,268.00) $       (41,920,896.00) $ (13,158,943.00) $            55,074,935.51
State Funds               QBE S&B REMEDIAL EDUCATION                 100.0000.431200.00011.9999.2211.8010.115.0000    $       (3,946,944.00) $        (5,106,590.00) $       (1,580,925.00) $       4,575,044.13
State Funds               QBE S&B LAB VOCATIONAL                     100.0000.431200.00011.9999.3011.8010.115.0000    $     (18,626,912.00) $       (19,307,489.00) $        (6,071,308.00) $      20,760,960.94
State Funds               QBE S&B ALT EDUCATION                      100.0000.431200.00011.9999.5071.8010.115.0000    $       (6,007,292.00) $        (6,313,870.00) $       (1,983,712.00) $         318,524.00
State Funds               QBE OPNS KINDERGARTEN                      100.0000.431220.00011.9999.1011.8010.115.0000    $         (478,212.00) $          (472,014.00) $         (196,614.00) $         463,546.73
State Funds               QBE OPNS GRADES 1-3                        100.0000.431220.00011.9999.1021.8010.115.0000    $       (1,489,359.00) $        (1,489,267.00) $         (620,326.00) $       1,416,133.08
State Funds               QBE OPNS GRADES 9-12                       100.0000.431220.00011.9999.1041.8010.115.0000    $       (2,136,452.00) $        (2,175,234.00) $         (906,326.00) $       2,066,989.87
State Funds               QBE OPNS GRADES 4-5                        100.0000.431220.00011.9999.1051.8010.115.0000    $         (765,251.00) $          (755,901.00) $         (314,901.00) $         726,757.87
State Funds               QBE OPNS EI KINDERGARTEN                   100.0000.431220.00011.9999.1061.8010.115.0000    $           (19,147.00) $           (20,944.00) $           (8,729.00) $         21,152.60
State Funds               QBE OPNS EI GRADES 1-3                     100.0000.431220.00011.9999.1071.8010.115.0000    $           (81,521.00) $           (88,390.00) $          (36,836.00) $         82,191.98
State Funds               QBE OPNS MIDDLE SCHOOLS                    100.0000.431220.00011.9999.1081.8010.115.0000    $       (1,152,209.00) $        (1,146,326.00) $         (477,439.00) $       1,096,087.30
State Funds               QBE OPNS EI GRADES 4-5                     100.0000.431220.00011.9999.1091.8010.115.0000    $           (38,941.00) $           (45,631.00) $          (19,018.00) $         44,880.97
State Funds               QBE OPNS MEDIA CENTERS                     100.0000.431220.00011.9999.1310.8010.115.0000    $       (1,290,602.00) $        (1,300,756.00) $         (541,488.00) $       1,254,504.52
State Funds               QBE OPNS INDIRECT ADMIN                    100.0000.431220.00011.9999.1455.8010.115.0000    $         (643,440.00) $          (648,437.00) $         (270,017.00) $       5,475,473.45
State Funds               QBE OPNS INDIRECT M&O                      100.0000.431220.00011.9999.1457.8010.115.0000    $     (27,634,744.00) $       (27,866,815.00) $ (11,603,259.00) $            26,886,571.30
State Funds               QBE OPNS SPECIAL ED                        100.0000.431220.00011.9999.2011.8010.115.0000    $       (1,955,761.00) $        (1,977,366.00) $         (883,761.00) $       1,613,503.19
State Funds               QBE OPNS GIFTED                            100.0000.431220.00011.9999.2111.8010.115.0000    $         (526,700.00) $          (532,551.00) $         (221,795.00) $         625,226.85
State Funds               QBE OPNS REMEDIAL EDUCATION                100.0000.431220.00011.9999.2211.8010.115.0000    $           (39,002.00) $           (45,089.00) $          (18,791.00) $         36,627.57
State Funds               QBE OPNS LAB VOCATIONAL                    100.0000.431220.00011.9999.3011.8010.115.0000    $       (1,299,013.00) $        (1,300,002.00) $         (541,739.00) $       1,247,652.30
State Funds               QBE OPNS ALT EDUCATION                     100.0000.431220.00011.9999.5071.8010.115.0000    $           (68,729.00) $           (69,365.00) $          (28,904.00) $           3,126.34
State Funds               QBE TRANSPORTATION                         100.0000.431250.00011.9999.1320.8010.115.0000    $       (5,457,894.00) $      (11,062,567.00) $        (4,718,548.00) $      11,324,504.00
State Funds                                                          100.0000.431250.00011.9999.1517.8010.115.0000                                                      $      (296,000.00) $                 -
State Funds               TOTAL STATE CATEGORICAL GRANTS             100.0000.431250.00011.9999.1648.8010.115.0000    $         (517,773.00) $          (555,943.00) $         (232,574.00) $         558,172.00
State Funds               QBE CONTRA ACCOUNT (DEBIT)                 100.0000.431400.00011.9999.9990.8010.115.0000    $    175,540,704.00 $        183,115,595.00 $ 78,149,982.00 $ (197,880,386.78)
State Funds                                                          100.0000.438000.00011.9999.1462.8010.115.0000    $       (9,930,774.00)
State Funds               On Behalf TRS                              100.0000.439120.00011.9999.1445.8010.050.0000    $         (236,710.93) $          (262,189.20)                          $       262,189.00
State Funds               On Behalf PSERS                            100.0000.439130.00011.9999.1445.8010.050.0000    $       (1,963,334.00) $        (1,677,199.00)                          $     1,677,199.00
Transfer                                                             100.0000.452000.00011.9999.0000.8010.115.0000                              $         (12,728.01)
Transfer                                                             100.0000.452000.00011.9999.9990.8010.115.0000    $       (2,048,023.55) $      (31,465,700.41)
Other Financing Sources   SALE/COMP - FIXED ASSETS LOSS              100.0000.453000.00011.9999.9990.8010.115.0000    $         (214,735.20) $          (139,370.06) $           (17,805.94) $        100,000.00
Miscellaneous                                                        100.0000.459950.00011.9999.9990.8010.115.0000                              $       (186,407.01) $            (1,483.94)
Miscellaneous                                                        100.0000.459951.00011.9999.9990.8010.115.0000    $              2,728.04 $             (2,554.35)
Other Financing Sources                                              100.0000.453000.00725.9999.9990.8010.115.0000                                                      $        (61,011.95)
State Funds               ESOL                                       100.0000.431200.14011.9999.1351.8010.115.0000    $     (50,816,694.00) $       (54,696,830.00) $ (24,126,069.00) $            30,748,495.75
State Funds               ESOL                                       100.0000.431220.14011.9999.1351.8010.115.0000    $         (228,315.00) $          (235,946.00) $           (98,323.00) $        223,623.44
Miscellaneous                                                        100.0000.419950.30211.7510.9990.8010.010.0000    $         (181,140.50) $            (78,071.50) $          (25,278.00)
State Funds               QBE - Nurses                               100.0000.431250.45611.9999.1500.8010.115.0000    $       (2,168,189.00) $        (2,242,395.00) $         (948,465.00) $       2,276,309.00
Miscellaneous             FED INDIRECT COST REIMBURSEMNT             100.0000.419900.66511.9999.9990.8010.050.0000    $       (5,566,815.99) $        (2,803,505.76)                          $     2,800,000.00
                                                                                                                      $ (1,461,074,443.05) $ (1,572,513,433.49) $ (985,670,413.66) $ 1,658,019,290.32
                                                                                                                                                                       FY26 Budget            $ 1,619,511,295.00
                                                                                                                                                                       Difference             $    38,507,995.32
                                                                                                                                                                       Gain                           0.02377754