ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
K-12 Education Budget by Funding Source in nominal dollarshttps://www.schools.utah.gov/superintendentannualreport"Statewide Total Revenue and Expenditures by Fund" is found at the bottomof the page, once opened in top three rows.
2
FY08FY09FY10FY11FY12FY13FY14FY15FY16FY17FY18FY19FY20FY21FY22
3
Local $ 1,571,406,644 $ 1,591,966,885 $ 1,622,162,008 $ 1,681,381,448 $ 1,741,441,669 $ 1,844,670,355 $ 1,791,717,672 $ 1,964,308,484 $ 2,177,673,030 $ 2,478,161,704 $ 2,359,764,329 $ 2,614,552,413 $ 2,723,046,244 $ 2,769,169,515.00 $ 3,007,814,460.00
4
State $ 2,467,855,612 $ 2,362,857,638 $ 2,283,682,858 $ 2,317,892,975 $ 2,395,418,730 $ 2,486,901,926 $ 2,632,843,394 $ 2,768,567,548 $ 2,942,797,939 $ 3,136,696,361 $ 3,366,289,991 $ 3,580,493,798 $ 3,751,705,448 $ 3,980,895,229.00 $ 4,107,261,827.00
5
Local + State $ 4,039,262,256 $ 3,954,824,523 $ 3,905,844,866 $ 3,999,274,423 $ 4,136,860,399 $ 4,331,572,281 $ 4,424,561,066 $ 4,732,876,032 $ 5,120,470,969 $ 5,614,858,065 $ 5,726,054,320 $ 6,195,046,211 $ 6,474,751,692 $ 6,750,064,744 $ 7,115,076,287
6
Federal $ 342,042,352 $ 564,988,141 $ 560,192,404 $ 577,814,390 $ 461,246,072 $ 446,827,597 $ 430,478,272 $ 449,573,886 $ 455,008,718 $ 457,710,605 $ 453,615,194 $ 455,779,679 $ 472,180,575 $ 705,580,489.00 $ 1,015,379,011.00
7
Total $ 4,381,304,608 $ 4,519,812,664 $ 4,466,037,270 $ 4,577,088,813 $ 4,598,106,471 $ 4,778,399,878 $ 4,855,039,338 $ 5,182,449,918 $ 5,575,479,687 $ 6,072,568,670 $ 6,179,669,514 $ 6,650,825,890 $ 6,946,932,267 $ 7,455,645,233 $ 8,130,455,298
8
9
Consumer Price Index for All Urban Consumers (CPI-U) 1982-84=100 (Unadjusted) - CUUR0000SA0 https://data.bls.gov/cgi-bin/surveymost?blsMake sure you include/use annual averages
10
200820092010201120122013201420152016201720182019202020212022
11
Annual215.303214.537218.056224.939229.594232.957236.736237.017240.007245.12251.107255.657258.811270.97292.655
12
Multiplier 135.93%136.41%134.21%130.10%127.47%125.63%123.62%123.47%121.94%119.39%116.55%114.47%113.08%108.00%100.00%
13
14
K-12 Education Budget by Funding Source in constant dollars, inflation-adjusted to 2022 dollars using the CPI-U mulitplier
15
FY08FY09FY10FY11FY12FY13FY14FY15FY16FY17FY18FY19FY20FY21FY22
16
Local $ 2,135,966,575 $ 2,171,639,711 $ 2,177,118,825 $ 2,187,547,236 $ 2,219,751,438 $ 2,317,389,058 $ 2,214,936,196 $ 2,425,415,474 $ 2,655,367,971 $ 2,958,740,264 $ 2,750,209,392 $ 2,992,923,473 $ 3,079,131,484 $ 2,990,778,700 $ 3,007,814,460
17
State $ 3,354,483,143 $ 3,223,230,035 $ 3,064,952,154 $ 3,015,675,221 $ 3,053,351,866 $ 3,124,200,102 $ 3,254,742,766 $ 3,418,468,446 $ 3,588,330,886 $ 3,744,981,534 $ 3,923,274,131 $ 4,098,653,322 $ 4,242,305,613 $ 4,299,475,563 $ 4,107,261,827
18
Local + State $ 5,490,449,718 $ 5,394,869,746 $ 5,242,070,978 $ 5,203,222,457 $ 5,273,103,304 $ 5,441,589,160 $ 5,469,678,962 $ 5,843,883,920 $ 6,243,698,856 $ 6,703,721,798 $ 6,673,483,523 $ 7,091,576,796 $ 7,321,437,097 $ 7,290,254,263 $ 7,115,076,287
19
Federal $ 464,928,053 $ 770,713,697 $ 751,839,472 $ 751,760,568 $ 587,933,348 $ 561,332,479 $ 532,160,798 $ 555,108,054 $ 554,819,553 $ 546,472,328 $ 528,670,067 $ 521,738,900 $ 533,926,325 $ 762,046,197 $ 1,015,379,011
20
Total $ 5,955,377,770 $ 6,165,583,443 $ 5,993,910,451 $ 5,954,983,025 $ 5,861,036,653 $ 6,002,921,639 $ 6,001,839,760 $ 6,398,991,974 $ 6,798,518,409 $ 7,250,194,126 $ 7,202,153,590 $ 7,613,315,696 $ 7,855,363,422 $ 8,052,300,460 $ 8,130,455,298
21
22
Fall Enrollment by School Year reported by the Utah State Board of Education, collected in October https://www.schools.utah.gov/data/reports?mid=1424&tid=4 under Fall Enrollment by Grade Levels and Demographics on the last tab of the workbook under sum of LEA totals for consistency over the time period.
https://www.schools.utah.gov/file/61e03724-1e49-4abd-ab14-bae91b4dd689
23
SY2007-08SY2008-09SY2009-10SY2010-11SY2011-12SY2012-13SY2013-14SY2014-15SY2015-16SY2016-17SY2017-18SY2018-19SY2019-20SY2020-21SY2021-22
24
Number of students 537,653 551,013 563,273 576,324 587,745 600,985 612,551 622,813 633,896 644,476 652,347 659,438 667,403 666,609675,247
25
26
K-12 Education Budget by Funding Source per student in constant dollars, calculatedby dividing the budget by the number of students
27
FY08FY09FY10FY11FY12FY13FY14FY15FY16FY17FY18FY19FY20FY21FY22
28
Local $ 3,973 $ 3,941 $ 3,865 $ 3,796 $ 3,777 $ 3,856 $ 3,616 $ 3,894 $ 4,189 $ 4,591 $ 4,216 $ 4,539 $ 4,614 $ 4,487 $ 4,454
29
State $ 6,239 $ 5,850 $ 5,441 $ 5,233 $ 5,195 $ 5,198 $ 5,313 $ 5,489 $ 5,661 $ 5,811 $ 6,014 $ 6,215 $ 6,356 $ 6,450 $ 6,083
30
State + Local $ 10,212 $ 9,791 $ 9,306 $ 9,028 $ 8,972 $ 9,054 $ 8,929 $ 9,383 $ 9,850 $ 10,402 $ 10,230 $ 10,754 $ 10,970 $ 10,936 $ 10,537
31
Federal $ 865 $ 1,399 $ 1,335 $ 1,304 $ 1,000 $ 934 $ 869 $ 891 $ 875 $ 848 $ 810 $ 791 $ 800 $ 1,143 $ 1,504
32
Total $ 11,077 $ 11,190 $ 10,641 $ 10,333 $ 9,972 $ 9,988 $ 9,798 $ 10,274 $ 10,725 $ 11,250 $ 11,040 $ 11,545 $ 11,770 $ 12,079 $ 12,041
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100