High School Budget Table.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI
1	School Name	School Type	Ward	FY21 FTEs	FY22 FTEs	FY23 FTEs	FY24 FTEs	FY25 FTEs	FTE Change FY24-25	FTE Change FY21-FY25	FTE-Student Ratio FY21	FTE-Student Ratio FY25	FTE-Student Ratio Change (FY21-25)	SFIB FTEs Budgeted	ESSER III FTEs Budgeted - FY22	ESSER III Amount - FY22 ($20.6M)	FY23 Hold Harmless FTEs	FY23 Hold Harmless ($23M)	FY24 Mayors Step Down Funds ($10.4M)	Total One-time funds since FY22	FY21 Submitted Budget	FY24 Amended Budget (Includes SFIB and Enrollment Reserve/Over-Enrollment Assistance)	FY25 Proposed Budget	Budget Change YOY (FY25 Proposed - FY24 Amended)	Budget Change FY21-FY25	FY21 Projected Enrollment	FY25 Projected Enrollment	Enrollment Change (FY21 Projected - FY25 Projected)	Buying Power Change FY24-FY25	Budget Assistance	FY21 At-Risk %	FY22 At-Risk %	FY23 At-Risk %	FY24 At-Risk %	FY25 At-Risk %
2	Anacostia HS	HS	8	85	88	84	86	75	-10.9	-10	4.4	3.7	-0.6	5	0	$ 50,234	4	$ 491,405	$ 396,265	$ 937,904	$ 8,862,227	$ 9,157,527	$ 9,146,078	$ (11,450)	$ 283,851	372	281	-91	$ (1,604,452)	$ 262,756	66%	83%	84%	85%	82%
3	Ballou HS	HS	8	116	121	137	138	127	-11.0	11	5.2	4.8	-0.4	1	4	$ 274,157	0	$ -	$ -	$ 274,157	$ 12,426,145	$ 15,045,752	$ 15,970,326	$ 924,574	$ 3,544,181	599	610	11	$ (549,103)	$ -	83%	85%	85%	87%	86%
4	Ballou STAY	HS	8	49	52	60	67	64	-3.0	15	10.5	7.2	-3.2	0	1	$ 106,652	0	$ -	$ -	$ 106,652	$ 5,554,175	$ 7,561,945	$ 8,362,303	$ 800,358	$ 2,808,128	514	462	-52	$ (209,080)	$ -	--	--	--	--	--
5	Bard Early College HS	HS	7	38	45	61	62	57	-4.6	20	8.8	7.0	-1.8	3	1	$ 100,591	0	$ -	$ -	$ 100,591	$ 4,455,001	$ 7,393,511	$ 7,738,622	$ 345,111	$ 3,283,622	330	400	70	$ (738,994)	$ -	48%	55%	55%	58%	60%
6	Benjamin Banneker HS	HS	2	53	56	59	65	69	4	16	10.9	10.2	-0.7	0	3	$ 238,271	0	$ 181,663	$ -	$ 419,934	$ 6,113,381	$ 7,193,282	$ 9,231,737	$ 2,038,456	$ 3,118,356	577	703	126	$ 181,125	$ -	47%	41%	39%	38%	38%
7	Cardozo EC	HS	1	147	148	151	160	165	5	18	5.0	4.3	-0.7	2	5	$ 404,041	0	$ -	$ -	$ 404,041	$ 15,881,837	$ 17,208,640	$ 20,656,875	$ 3,448,235	$ 4,775,038	736	705	-31	$ 244,111	$ -	83%	79%	79%	80%	80%
8	Columbia Heights EC (CHEC)	HS	1	190	191	231	251	239	-12.0	49	8.0	6.3	-1.7	0	2	$ 204,024	0	$ -	$ -	$ 204,024	$ 21,463,638	$ 28,633,329	$ 31,285,090	$ 2,651,761	$ 9,821,452	1520	1515	-5	$ (591,979)	$ -	57%	56%	55%	55%	56%
9	Coolidge HS	HS	4	105	107	142	187	181	-6.0	77	5.3	5.6	0.3	0	0	$ -	0	$ -	$ -	$ -	$ 11,002,534	$ 21,359,582	$ 23,549,570	$ 2,189,988	$ 12,547,036	557	1018	461	$ (10,589)	$ -	59%	56%	61%	65%	64%
10	Dunbar HS	HS	5	97	107	139	156	175	19	79	6.7	6.1	-0.6	0	1	$ 112,646	0	$ -	$ -	$ 112,646	$ 10,596,907	$ 17,673,008	$ 22,181,485	$ 4,508,477	$ 11,584,578	646	1066	420	$ 950,236	$ -	85%	68%	71%	74%	72%
11	Eastern HS	HS	7	121	118	146	165	167	2	46	6.7	5.3	-1.3	0	1	$ 113,520	0	$ -	$ -	$ 113,520	$ 12,722,397	$ 17,595,719	$ 20,090,859	$ 2,495,140	$ 7,368,462	802	884	82	$ 129,486	$ -	67%	72%	74%	75%	73%
12	Ellington School of the Arts	HS	2	24	30	37	38	46	8	22	23.3	12.5	-10.9	2	1	$ 244,610	0	$ -	$ -	$ 244,610	$ 8,941,206	$ 12,842,204	$ 13,886,415	$ 1,044,211	$ 4,945,209	558	577	19	$ 125,822	$ -	44%	44%	41%	43%	42%
13	Jackson Reed HS	HS	3	205	208	237	263	231	-32.5	26	9.9	8.4	-1.5	0	2	$ 204,137	0	$ -	$ -	$ 204,137	$ 21,793,809	$ 28,857,823	$ 29,596,489	$ 738,666	$ 7,802,680	2015	1932	-83	$ (1,407,267)	$ -	32%	23%	25%	29%	29%
14	Luke Moore Alternative HS	HS	5	45	44	44	50	50	0.3	5	6.6	5.0	-1.6	0	0	$ -	0	$ -	$ -	$ -	$ 4,810,073	$ 5,299,927	$ 6,284,713	$ 984,786	$ 1,474,640	294	250	-44	$ (147,618)	$ -	--	--	--	--	--
15	MacArthur HS	HS	3	0	0	0	42	67	25	67	#DIV/0!	6.7	#DIV/0!	0	0	$ -	0	$ -	$ -	$ -	$ -	$ 4,677,494	$ 8,593,852	$ 3,916,358	$ 8,593,852	0	447	447	$ 824,809	$ 133,722	--	--	--	38%	40%
16	McKinley Technology HS	HS	5	80	81	85	91	93	2	13	8.6	7.8	-0.9	0	1	$ 152,962	0	$ -	$ -	$ 152,962	$ 9,246,338	$ 10,811,263	$ 12,307,031	$ 1,495,769	$ 3,060,693	686	719	33	$ (107,420)	$ -	38%	39%	36%	37%	35%
17	Phelps ACE HS	HS	5	47	50	57	60	58	-2.0	11	5.8	5.6	-0.2	1	1	$ 78,812	0	$ -	$ -	$ 78,812	$ 5,420,470	$ 6,835,326	$ 7,764,848	$ 929,522	$ 2,344,379	272	322	50	$ (113,851)	$ -	66%	64%	63%	62%	62%
18	Ron Brown College Preparatory High School	HS	7	59	57	57	59	48	-11.0	-11	4.7	3.7	-1.0	4	1	$ 129,392	3	$ 404,216	$ 384,005	$ 917,612	$ 6,805,977	$ 6,850,303	$ 6,563,905	$ (286,397)	$ (242,071)	276	176	-100	$ (1,485,873)	$ -	95%	88%	80%	77%	73%
19	Roosevelt HS	HS	4	130	134	154	169	163	-6.0	33	6.3	5.8	-0.5	0	1	$ 100,736	0	$ -	$ -	$ 100,736	$ 14,093,566	$ 19,447,326	$ 22,177,152	$ 2,729,826	$ 8,083,586	820	943	123	$ (132,219)	$ -	69%	73%	72%	73%	72%
20	Roosevelt STAY	HS	4	69	69	88	99	94	-5.0	26	9.9	7.6	-2.2	0	3	$ 348,478	0	$ -	$ -	$ 348,478	$ 7,909,053	$ 11,543,984	$ 12,525,367	$ 981,382	$ 4,616,313	675	715	40	$ (326,916)	$ -	--	--	--	--	--
21	School Without Walls HS	HS	2	55	57	57	57	55	-2.0	0	10.9	11.0	0.2	0	2	$ 213,305	0	$ 297,984	$ -	$ 511,289	$ 6,564,556	$ 6,577,564	$ 7,406,126	$ 828,562	$ 841,570	600	609	9	$ (206,672)	$ -	41%	42%	42%	42%	42%
22	Woodson, H.D. HS	HS	7	102	100	111	125	124	-1.0	22	5.0	4.6	-0.4	0	0	$ 56,286	0	$ -	$ -	$ 56,286	$ 11,221,490	$ 13,554,542	$ 15,308,742	$ 1,754,200	$ 4,087,252	505	571	66	$ (59,814)	$ -	62%	70%	73%	77%	75%
23				1813	1861	2135	2389	2346	-43	533	#DIV/0!	139	#DIV/0!	18	29	3132851	7	1375268	780270	5288389	205884780	276120051	310627587	34507536	104742807	13354	14905	1551	-5236258	396478	10	10	10	11	11
24
25
26
27
28
29
30
31
32
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