Imagine three married couples went out to eat and split the check the following way: The husbands split half the bill in proportion to the assessment on their respective houses. The wives split half the bill in proportion to the number of school children they have. Then the state gives each couple a different amount of help depending on how poor they are and how many kids they have. Whatever's left is what each couple has to pay.

It's obviously a crazy way to split the check. But if you substitute "town" for "couple" and "equalized valuation for the town" for "assessment on a house" and "number of students enrolled from the town" for "number of children" that's how we pay for schools. That's apportionment in the Oyster River Cooperative School District. The basic agreement that makes the cooperative work is this apportionment formula to divide up the bill. It's half by town valuation, half by number of students per town, with the state aid then subtracted by town.

The reason to bring this up now is that Business Administrator Caswell calculated that Madbury's local school tax millage will increase 6% if the current budget goes forward (3% operating increase). The school board is all in a tizzy now about poor Madbury.

I'm going to descend into math soon, but before I do let me summarize the main conclusion. The upshot of it is that at least part of Madbury's big increase is that they had some sort of audit and lowered their total valuation. Considered in isolation, this will have the effect of

*lowering*Madbury's local school tax, as half the bill is allocated in proportion to their valuation.

Nonetheless Madbury's millage will increase, since their decreasing amount of taxes is divided by an even faster decreasing total valuation. But even though their millage is going up, their taxes are going down and the taxes of Lee and Durham have to go up to compensate. So don't feel sorry for Madbury. But don't feel that smug either -- I believe since 2010 Lee and Durham have both lowered their assessments as well, though I thought I saw Lee had gone back up again. Madbury's perhaps just a bit late to the party.

OK, the nice stories about dining out are over and we're going to look at the formulas. You might want to skip to the actual results at the end.

**Apportionment Formulas**

There's going to be a fair amount of definition and math, but it pays off in the end. I'm going to try to minimize notation, so it's going to be a bit terse. You may have to refer back to the definitions to know what the variables are. In general I'll use small letters for variables for individual towns (so there are three instances of each small variable, one for each town) and caps for variables that refer to the district as a whole.

The apportionment formula is

*t = (s+a) B/2 - w*

where

*t*is the tax, the local property tax in dollars to be divided among property owners in a given town

*s*is the share of students enrolled from the town

*s*= <number of students from the town> / <total number of students in the district>

*s_Lee + s_Durham + s_Madbury = 1*

*I think*

*s*is calculated from the October 1 attendance numbers, so you can help your town's taxpayers out by keeping your kids home that day. That's probably a bad idea. I think previously I recommended you send your sick kid to school that day as state aid is partly determined by the number of students that do show up.

*a*is the share of (equalized) assessed valuations from the town

*a*= <equalized valuation of town> / <total valuation of district>

*a_Lee + a_Durham + a_Madbury = 1*

Let's define

*v*and

*V*for convenience

*v*= <equalized valuation of town>

*V*= <total valuation of district> =

*v_Lee + v_Durham + v_Madbury*

So

*a = v/V*

*B*is the budget,

*B*= <total appropriations> - <non-state revenue>

*B*is the gross amount to apportion among the towns. The local school property tax collected from owners and the state aid to towns all add up to

*B*.

*B*is essentially the tax impact in the budget goal.

*w*is the state aid to the town in dollars (

*w*for to

**w**n).

The formula

*t = (s+a) B/2 - w*is pretty simple. Each town's share of

*B*is the percentage

*p*

*p = (s+a)/2*

That says that each town's share of the total bill is the average of its share of the students and its share of the property value. The bill is divided before each town's state aid

*w*is subtracted, and the net is the tax

*t*to be divided among town property owners. Since the total tax

*t*is divided among the total town valuation

*v*, the millage

*m*is

*m = t/v*

There may be a detail about equalizing the valuations across towns that I'm leaving out here. Other things I'm not sure about include how the state aid is calculated and why the state tax rate differs between towns.

After apportionment, you can look at the pie two ways, with and without the state.

Let's call

*f*the fraction of the budget

*B*each town's local school property tax really pays. Then

*f = t/B*

*f_Lee + f_Durham + f_Madbury*won't add up to one because the state aid has been subtracted out. If you set

*f_state = sum(w)/B,*then the four of them would add up to one. It's a pretty good approximation to think of

*f*as a nine slice pizza pie, with Madbury getting one slice, Lee and the state two slices each, and four for Durham.

Without the state it's a seven slice pie, the geometric sequence 1, 2, 4.

*Putting our equations together, we can write*

*t*, a town's total local school property tax to be collected, a few different ways:

*t = mv = fB = (s+a) B/2 - w = (s +v/V) B/2 - w = pB - w*

**Sensitivity Analysis**

*The apportionment formulas take as inputs:*

*B*, the budget to be apportioned

*s,*the share of students per town

*v,*the total valuation of each town

*w,*the state aid to each town

The formulas output:

*t*, the local school property tax collected and paid by each town

*m*, the millage rate for dividing

*t*among property owners in the town

What we're interested in here is how the outputs tax and millage change with each of the inputs. Let's focus on the percentage change in the output for each percentage change in the input. The share of students

*s*is already a percentage, so for that one we'll be interested in how a given difference of percentages maps to each output.

At this point most sane people would make a spreadsheet and play with the inputs to see how the outputs change. That's what I did.

*Scroll to the end to see the spreadsheet.*

But I also did the somewhat less sane step of treating the whole thing as a physics problem. What we want to know is how each output changes when you change one input a little bit and hold all the other ones constant. Let's determine the functions

*%t(%B)*that give factors which when multiplied by a given percentage change in

*B*tells you the a percentage change in

*t.*

*Let's write*

*Dx*for Δ

*x,*a small raw change in

*x.*Then the percentage change

*%x = Dx/x*. We then can calculate change in the dependent

*Dy = (y/x) Dx*. From now on I'll write the partial derivative as

*dy/dx*form for ease in typing.

Start with how the percentage tax increases with each percent increase in the budget

*B*

*t =*

*pB - w*

*dt/dB = p*

%t(%B) = Dt/t = (dt/dB) DB/t = B/t dt/dB DB/B = p/f %B

This says a one percent change in the budget leads to a

*p/f*percent change in the town tax.

*f*is going to smaller than

*p*because of the state aid, so

*p/f*is in the 1.2 to 1.4 range. I suppose I should pause here and emphasize that this is significantly larger than one. The more state aid the town gets, the bigger the magnification. It's not so bad because it's offset by the state aid. It's exactly offset by increases in

*w*as far as they go, but only that far. Once the budget percentage increases beyond the that of state aid, the taxpayers feel the brunt of the full

*p/f*ratio.

The millage rate changes by the same

*p/f*factor. To see this, write

*m = t/v = (p/v)B - w/v*

*dm/dB = p/v*

*%m(%B) = Dm/m = B/m (dm/dB) DB/B = Bp/mv %B = p/f %B*

The last part comes from

*t=mv=fB.*

There's no difference between the sensitivity factors (sometimes called "loads") on total tax and millage for all of the input except

*v.*Since changing

*v*changes the tax base, the millage and tax factors change differently.

Let's do %t(%v) and %m(%v) (the hard case).

*t = (s + v/V) B/2 - w*

Useful math facts:

*d(v/(v+k))/dv = k/(v+k)^2 d(1/(v+k))/dv = -1/(v+k)^2*

*The big*

*V*is the sum of the

*v*we're interested in and the other two towns

*v*'s. Let

*k = V-v*the sum of the total valuation of the other two towns.

*dt/dv = B/2 (V-v) /V^2*

*%t(%v) = Dt/t = 1/t dt/dv Dv = v/t B/2 (V-v)/V^2 Dv/v = vB/2tV (1-v/V) %v = a(1-a)/2f %v*

*The load*

*a(1-a)/2f*gives the percentage tax increase for each percent change in

*v.*It ranges from .3 in Durham to almost .6 in Madbury

*.*It's positive, which means by lowering

*v*a town reduces its taxes

*t.*

*Now let's look at the most difficult case, how the millage changes with valuation.*

*m = t/v = [(s + v/V) B/2 - w]/v = (sB/2 - w)/v + B/2V*

*dm/dv =*

*(w - sB/2)/v^2 - B/2V^2*

*Here we're looking at a percentage change in a millage which is already a kind of percentage, but that seems to be how people look at it. It usually makes sense as the millage is proportional to your property tax when the assessments stay constant.*

*%m(%v) = Dm/m = 1/m dm/dv Dv = v/m [*

*(w - sB/2)/v^2 - B/2V^2 ] Dv/v*

*%m(%v) = ( w/mv - sB/2mv - vB/2mV^2 ) %v = (w/t - sB/2t - vB/2mV^2) %v*

*Each one percent change in a town's valuation changes the millage by the complicated factor above. Let's meditate on the terms a bit.*

The first term

*w/t*is the relative contribution of the state compared to the local taxpayers for a town's portion of the local school tax. It's around .4 for Madbury and Lee and .2 for Durham. The more the state kicks in, relatively speaking, the more a town benefits by lowering its valuation.

*The next term,*

*-sB/2t*is

*the ratio of*

*sB/2,*the amount the town pays because of its student share, and

*t*, the town tax after state aid. You'd expect the student share to be more than half of t but less than all of t, and indeed this part comes in at -.5 for Durham, -.7 for Madbury and -.8 for Lee. The negative sign means that the more students the more the millage decreases when assessments go up.

The last term -

*vB/2mV^2*is pretty wacky.

*v/V*is

*a*so we have

*aB/2mV. aB/2*is the money the town owes due to its share of property value. That's oddly compared to mV, which is the given town's millage applied to all the property in the district, so is approximately

*sum(mv)=sum(t)=B-sum(w)*, the total local property tax collected in the district (the budget less the state aid). That's adjusted up or down depending on whether the given town's millage is above or below average. The term comes in with a negative sign, coming in at -.6 for Lee, -.7 for Durham and -.4 for Madbury.

Adding it all up, we get the factor of percentage change in millage for each percent change in town valuation as -.6 for Lee, -.7 for Durham and -.4 for Madbury. The negative sign means for 10 percent off their valuation, Madbury increases its millage by 4% even while (as we learned above) decreasing its local school property tax by 6%. It appears

*%m(%v) = 1 - %t(%v)*though I haven't proved this.

Finishing up, let's look at

*%t(%s)*. Since

*s*is already a percentage, %s=Ds/s is a percentage change in percentage. This is confusing but you can think of

*%s=.01*as meaning the town (approximately) increases its student enrollment by 1%. In Madbury this means it's share of students

*s*would change from 15.51% to 15.67%.

*t = (s+a) B/2 - w*

*dt/ds = B/2*

*%t(%s) = Dt/t = s/t dt/ds Ds/s = sB/2t %s = s/2f %s*

*This says for a one percent change in the town's enrollment you increase local tax by*

*sB/2t = s/2f*percent. That term already appeared above with a negative sign in

*%m(%v).*It's the town's share of the enrollment tab, and that gets compared to

*t*, the local tax from the town. It's also

*s/2,*the percentage of the budget the town pays for students, divided by

*f*, the fraction of the budget the town pays in local property tax. The factor works out to .8 Lee, .6 Durham, .7 Madbury.

Last one:

*%t(%w)*

*t = pB - w*

*dt/dw = -1*

*%t(%w) = Dt/t = 1/t dt/dw Dw = -w/t Dw/w = -w/t %w*

Here we get the factor

*w/t*we've seen before, this time with a negative sign. Recall w/t is the relative size of the state's contribution to the local taxpayer's contribution to the town's share of the budget. Here it's -.2 for Durham and about -.4 for Madbury and Lee. It means if the state raises its support 10% to Madbury or Lee that would cut taxes 4% in the happy town, but a 10% raise to Durham only cuts taxes 2% there. (It's symmetrical -- state cuts are felt more deeply in Lee and Madbury than in Durham as well.)

**Results**

Here's a spreadsheet with the actual FY15 numbers. I haven't yet added the proposed FY16 numbers since I couldn't find them. Maybe after Thanksgiving.

Here's the sensitivity table shows how for each one percent change in an input parameter (if all else stays constant) what percent change to expect in the output parameter. The first three parameters when altered one percent change both the local tax and millage by the same factor as given in the table. The fourth parameter, percent change in town valuation (%v) has a different effect and opposite effect on the local tax and the millage. In particular a 10% decrease in Madbury's valuation, all else being equal, lowers Madbury's local school tax 5.7% but raises their millage 4.3%.