MBTA developments, School budgets and future HS enrollments.xlsx

	A	B	C	D	E	F	G	H	I	J	K
1											Fill in 2 blue cells below
2	All $s are current $s as of 2024										and results appear
3											in the other cells
4	Scenario #	(1)	(2)	(3)	(4)	(5)	(6)	(7)	(8)	(9)	(10)
5	Scenario name	As of 11/13/24 (per Tab 3)	20% of 227 acres at current density	20% of 227 acres at 1.5 times the current density	50% of 227 acres at current density	50% of 227 acres at 1.5 times the current density	70% of 227 acres at current density	70% of 227 acres at 1.5 times the current density	50 acres at current density	50 acres at 1.5 times the current density	Your own scenario

6
7	% of 227 acres with MBTA developments eventually approved on	9.1%	20.0%	20.0%	50.0%	50.0%	70.0%	70.0%	22.0%	22.0%	40.0%
8
9	# acres eventually with MBTA developments	20.7	45.4	45.4	113.5	113.5	158.9	158.9	50.0	50.0	90.8
10
11	Density (# units/acre)	47.6	47.6	71.4	47.6	71.4	47.6	71.4	47.6	71.4	63
12
13	Total # units	985	2,161	3,242	5,403	8,104	7,564	11,345	2,380	3,570	5,720
14
15	Comment							almost doubles Lexington's population
16
17	Total # students from those units (at 0.55 per unit: Tab 2, rows 33 & 35)	542	1,189	1,783	2,971	4,457	4,160	6,240	1,309	1,964	3,146
18
19	Rounded additional cost to the School operating budget ($28,369 per student minus 22% of it paid by the MBTA developoments in RE taxes, per Tab 2)	$12,000,000	$26,000,000	$39,000,000	$66,000,000	$99,000,000	$92,000,000	$138,000,000	$29,000,000	$43,000,000	$69,000,000
20
21	Additional cost as a % of current School budget (Line 1000 + 2/3 of Line 2000 = $192,000,000)	6%	14%	20%	34%	52%	48%	72%	15%	22%	36%
22
23	# additional classrooms needed; costs NOT covered by MBTA developments' RE taxes (25 students per classroom)	22	48	71	119	178	166	250	52	79	126
24
25	Estimates of future HS enrollment (current 2,425 LHS enrollment + # additional HS students estimated per assumptions as described below)
26	ALL MBTA units are like LOWEST figures (50 Waltham St Tab 4 row 94)	2,458	2,497	2,533	2,605	2,695	2,677	2,803	2,504	2,544	2,616
27	ALL MBTA units are like the average of the 6 existing developments (28% of addl students are HS grades Tab 4 cell I70)	2,577	2,759	2,925	3,259	3,676	3,592	4,176	2,792	2,976	3,308
28	ALL MBTA units are like HIGHEST figures (April Ln "neighborhood" Tab 4 row 83)	2,951	3,580	4,157	5,312	6,756	6,467	8,488	3,697	4,333	5,482
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