Committee Updates

More Detailed Cost Comparisons - Jeff Raab

posted Jul 17, 2015, 4:42 AM by Chris Cooney

From: Jeff Raab
Date: Thu, May 7, 2015 at 1:31 PM
Subject: More detailed cost comparisons

Dear School Board Members,

At your last meeting Mr. Zink mentioned that residents may be interested in Dover tuitioning if it is the lowest cost option.  People may think this is true because the Findings section of the JAC Executive Summary says the Dover option averages $280/year tax increase for a $250,000 home, add/reno is $303/year, and a new facility is $494/year.  It's important for residents to know these represent just one possible outcome based on very specific assumptions.  When you consider other numbers from the JAC report you get a range for each option, and things change.

First, the JAC report includes a higher add/reno cost estimate of $18.1 million on page 34, and a lower new facility estimate of $20.8 million on page 36.  If you plug those into the spreadsheet, the add/reno goes up to $368/year and the new facility goes down to $423/year.  Here is a link to a Google spreadsheet with these numbers:

The report uses the 2014-15 NESDEC enrollment projections but does not apply those projections equally to the three options.  The $280/year tuition cost is based on the projected peak of 516 students in grades 6-12, with a peak of 274 High School students that would attend Dover.  On the other hand the cost of a new facility is based on 550 students in a 103,529 square foot building. The add/reno cost is based on a similar 104,000 square feet.

If you use 516 students instead of 550 that leads to a smaller 97,129 square foot new facility that would cost $22.8M.  If you subtract 6,800 square feet of classroom addition from the JAC example budget spreadsheet, the add/reno bond amount drops to $13.3M.  Then add/reno is only $270/year, and the new facility is $463/year.  Here is another spreadsheet with those numbers:

The NESDEC projections have a margin of error.  In the Reliability of Enrollment Projections section of their report they say in 90% of the cases the variance is within 1% per year up to 10% over 10 years.  If you add 1% more students in 2015-16, 2% more in 2016-17, and so on, that leads to a peak of 547 students in grades 6-12, with a peak of 298 High School students that would attend Dover.  Then Dover tuitioning would cost $430/year.  The ranges from above for the other options to support 550 students are $303-368/year for add/reno and $463-494/year for a new facility.  Here is a sheet with this:

I don't recommend reducing the NESDEC projection by their margin of error for a few reasons: 

1. Randy Bell has said NESDEC was the most conservative projection.
2. The actual 2013-14 enrollment was higher than the 2013-14 NESDEC projections at all grade levels.
3. The Projection Methodology section of the NESDEC report says they use historical grade-to-grade "survival" ratios, but we can expect higher future ratios once we implement facility solutions.
4. The sample tuition contracts provided by the JAC have minimums that apply even if the actual number of attendees is lower.

Last meeting the Board also discussed the 120 students in alternative settings. These are students already living in Newmarket that can push us beyond the margin of error in the NESDEC projections once facility issues are solved.  It works out to 8 or 9 students per grade K-12, not counting the 8 students in special education outside placements.  If you add these students to the NESDEC projected enrollment you get a peak of 576 students in grades 6-12, with a peak of 308 High School students that would attend Dover.  Then Dover tuitioning would cost $487/year.  The range for a proportionally larger add/reno for that number of students is $318-386/year.  A proportionally larger new facility is $473-517/year.  Here is a sheet with those numbers:

Overall the range of the above possibilities is $280-$487 for the Dover tuition option, $270-386 for add/reno, and $423-517 for a new facility.

The JAC report and cost model spreadsheet use the Barrington contract with Dover to estimate the Dover tuition option cost.  After applying the 8% administrative fee, and adding transportation and special education paraprofessionals, the above spreadsheets estimate it to cost $24 to 41.7 million more than current operating costs over 30 years. In contrast, the principal + interest totals on the example bonds in the JAC report come to about $26 million for add/reno and $42.2 million for a new facility.

It's important for residents to understand that for the tuitioning option, the cost really only covers students in grades 9-12.  The JAC spreadsheet compares this to add/reno and new facility options that include the cost of facilities for grades 6-12, not just 9-12.  Since Dover can't take all of our students from grades 6-12 you have to adjust the bond totals if you want to compare apples to apples.

Depending on if you go by projected enrollment in the next 10 years (2597/4950 or 52.5%), number of grades (4/7 or 57%), or the 60/40 allocation Newmarket uses to determine the High School portion of shared costs, the part of the JAC example bonds principal + interest just for grades 9-12 is only $13.6-15.6 million for add/reno and $22.1-25.3 million for a new facility.

Remember, the JAC example bonds are to support 550 students.  If you use the $39.6 million new facility principal + interest for only 516 students, the grades 9-12 part is just $20.8-23.8 million.  The grades 9-12 part of the smaller add/reno for 516 students is $12.1-13.8 million.

To be clear, this means the best case cost to tuition grades 9-12 to Dover over 30 years is expected to be higher than the cost of a new facility for the same number of students in grades 9-12, and much higher than the cost of add/reno for those students.  In the worst case, the cost to tuition grades 9-12 to Dover over 30 years would be higher than the entire cost of a new facility for all of the students in grades 6-12.

Since the add/reno and new facility options involve bonds, their tax rate impact is predictable over the 30 year period, while the tax rate impact of the Dover tuition option will vary year to year.  If we negotiated a tuition contract we may know its minimum tax impact, but the above examples show the maximum impact can be much more.  It is important that residents, especially those on fixed incomes, understand that tuitioning students out of Newmarket has inherent risk and variability not applicable to the other options.

Without saying so, it seemed like the Board was discussing eliminating tuition as an option in your last meeting.  Please don't make decisions just because of statements made at public comment, in focus groups, or the Newmarket Common Ground community conversation.  Whatever decisions you do make, you have to demonstrate to parents, residents, and taxpayers the solid financial reasons for those decisions.  The JAC report represents many months of due diligence.  It has plenty of information to justify a course of action expected to maximize value and provide cost certainty for Newmarket in the long term.

As always, please reach out if there is anything I can do to help.  I understand this is a very long message with a lot of numbers to digest.  I don't expect a reply, and I don't expect you to address these numbers at your meeting tonight.  I just wanted to let you know some things I realized having worked on the spreadsheet for Randy Bell.

Jeff Raab
Hilton Drive

Questions From the School Board

posted Jul 15, 2015, 12:05 PM by Chris Cooney

Randy Bell's responses.

New cost model including Elementary School

posted Apr 20, 2015, 5:32 AM by SAU31 Webmaster

See attached

Final Report & Executive Summary

posted Apr 20, 2015, 5:27 AM by SAU31 Webmaster

See attached for the Final Report and Executive Summary of the Joint Advisory Committee.

New documents uploaded - per pupil costs

posted Apr 6, 2015, 1:02 PM by SAU31 Webmaster   [ updated Apr 6, 2015, 1:03 PM ]

The following spreadsheets have been added to the "Other Documents" section:

Revised Cost Model posted

posted Apr 6, 2015, 6:19 AM by SAU31 Webmaster   [ updated Apr 6, 2015, 6:25 AM ]

A revised Cost Model has been uploaded and will be demonstrated at the next JAC meeting on April 7th.
You can download the spreadsheet here and also find it in the Other Documents section.

An explanation of the sheets follows:
  • The first tab is the model itself. The model is currently set to reflect the projections and assumptions that are in the Data Report. It is a 30-year view, which is the view we will continue to use in our report. As you will see, different assumptions and projections can easily be entered in the model, and the costs, charts and graphs will be changed to reflect those different entries. It is this feature that will allow future users to develop planning models, if they wish.
  • The second tab, "cost analysis" provides the financial data used for the model, year by year. If changes are made in the "Model" then the data in this section changes to reflect the new entry.
  • The third tab is the "enrollment" button. This button provides enrollment projections based upon the NESDEC report. At the end of the time projected by NESDEC, enrollments are simply continued in a straight line.
  • The fourth tab is "Epping tuition". This provides the ability to project various Epping Tuition scenarios.
  • The fifth tab is "Bond payment -- "Add/Reno" - This provides the information for bond payments by either the "Level Payment"method or or the "Level Principal" method.
  • The sixth tab, "Bond payment -- New facility" provides the same information on bond payments for the new facility option.
  • The last tab, "Charts" provides the information needed to generate the charts contained in the model.

Next meeting 4/7/15

posted Apr 2, 2015, 2:33 PM by SAU31 Webmaster   [ updated Apr 3, 2015, 6:42 AM ]

The next meeting of the Joint Advisory Committee will be held Tuesday, April 7, 2015, 6:30 PM in the Town Council Chambers

Information Sheet for Focus Groups

posted Mar 15, 2015, 11:20 AM by SAU31 Webmaster

Attached is an information sheet for the upcoming focus groups.

Public Forum Invitation 3/26/15

posted Mar 15, 2015, 11:13 AM by SAU31 Webmaster   [ updated Mar 15, 2015, 11:14 AM ]

Invitation to Participate in Public Forum Regarding the Junior/Senior High School Facility Options

The Newmarket Joint Advisory Committee is committed to gathering feedback from a wide range of stakeholder groups regarding a long term solution to the Junior/Senior high school challenges and is looking forward to having Newmarket community members participate in a public forum. The public will be offered the opportunity to respond to questions related to the educational needs and potential solutions of the Newmarket School District.

Junior/Senior High School Facility Options
  • Tuition Option
  • Addition/Renovation Option
  • New Facility Option
When:  Thursday, March 26th
Time:  7:00 – 9:00 pm
Where:  Town Hall Auditorium

Data Report posted

posted Mar 15, 2015, 11:04 AM by SAU31 Webmaster   [ updated Mar 15, 2015, 11:07 AM ]

A draft of the Data Report revised February 13, 2015 has been uploaded to the Other Documents section and is attached below.

1-10 of 38