Impact of reduced commercial assessments on residential taxes.xlsx

	A	B	C	D	E	F	G	H
1	Prepared by Patrick Mehr (9/15/25)			Enter assumptions for next year change:	--10%	in commercial valuation	4.94%	in residential valuation
2
3	Note: each value is calculated, unless a Source for it is given next to it, or unless it's a user-entered assumption (in the 2 green cells above)
4
5	Item	"CIP factor"	FY2025	Source		Next FY	Source
6	Maximum Allowable Levy		$256,398,958	https://www.lexingtonma.gov/DocumentCenter/View/13147/FY2025-Classification-Packet_1182024, page 6 of 12		$262,808,932	Per Prop 2 1/2, +2.5% (assumes no operating override)
7	Actual Property Tax Levy		$256,398,958			$262,808,932
8	Residential Valuation		$15,977,353,073	https://www.lexingtonma.gov/DocumentCenter/View/13147/FY2025-Classification-Packet_1182024, page 6 of 12		$16,766,634,315
9	CIP Valuation		$2,510,409,460	https://www.lexingtonma.gov/DocumentCenter/View/13147/FY2025-Classification-Packet_1182024, page 6 of 12		#VALUE!
10	Total Valuation		$18,487,762,533			#VALUE!
11
12	Tax levy from commercial properties	1.00	$34,815,807			#VALUE!
13	Tax levy from residential (at 1.0 CIP factor)	1.00	$221,583,151			#VALUE!
14
15
16	Tax levy from commercial properties	1.75	$60,927,662			#VALUE!
17	Tax levy from residential	1.75	$195,471,296			#VALUE!
18
19
20	Commercial Tax Rate	1.75	24.27			#VALUE!
21	Residential Tax Rate	1.75	12.23			#VALUE!
22
23	Note: these two FY25 calculated tax rates (from above total assessments, tax levy limit and CIP factor of 1.75),
24	match the actual tax rates listed for FY25 on https://www.lexingtonma.gov/526/Tax-Rates
25
26	Single Family Dwelling (SFD) valuation		$14,309,924,000	https://www.lexingtonma.gov/DocumentCenter/View/13147/FY2025-Classification-Packet_1182024, page 7 of 12		$15,016,834,246
27	Number of SFDs		9,065	https://www.lexingtonma.gov/DocumentCenter/View/13147/FY2025-Classification-Packet_1182024, page 7 of 12		9,065
28	Average SFD valuation		$1,578,591			$1,656,573
29
30	Annual tax on average Single Family Dwelling (SFD)		$19,313			#VALUE!
31
32					SFD annual tax increase:	#VALUE!
33					or:	#VALUE!
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