Potential Impacts
from the
2018 Full Statistical Revaluation
Assessed Value
(in billions)
Current Preliminary Future
Assessed Value Assessed Value
Tax Year 2017 Tax Year 2018
$6.6
$5.3
$3.2 93.4
Residential C&I Residential C&I
ER =.80 ER = .93 ER = 1.00 ER = 1.00
3/23/2018 Page 2
Property Taxes
(in millions)
Assumed Property Assumed Property
Taxes - $200 Million Taxes - $200 Million
Tax Year 2017 Tax Year 2018
$132
$124.8
$75.2
$68
Residential C&I Residential C&I
Review of
Capital Equipment Reserve Fund
(CERF}
3/21/18
Savings Account
CERF Reorganized in FY 2010 & FY 2015
Fully fund capital equipment (vehicles)
Majority purchased with Cash & Bonds
— Limited purchases through grants & trust funds
Phase 1 — included all DPW, Fire, & Police
2010
— 245 line items (DPW 121, Police 77, Fire 47)
Phase 2 — included School & General City
Departments (Cemeteries, Purchasing, IT,
Building Maintenance., Communications, Library
and Community Services)
2013
— 60 line items (School 41, Admin/Engineering 5,
Other General City Departments 14)
CERF Overview
Ten year look at needs and budget
Reviewed annually with each division in
detail
Dollars are not meant to be exact
_- Some purchases are over, some are under
The CERF schedule is a living document
It is used as an estimator to aid in
determining budget needs and
replacements with inflation factor
AS value does not mean spend that
amount exactly...desire is to spend less
City of Nashua
Capital Equipment Reserve Fund
“CERF” Balance Analysis
Description
Available Balance
FY2018 Budgeted Expenditures - Deferred
Projected FY2018 Ending Fund Balance
Proposed FY2019 Appropriation
Proposed FY2019 Expenditures
Proposed Funding for Revaluation Project - 2018
Projected FY19 Ending Fund Balance
Amount
$ 2,998,497
(1,280,766)
§ 1,717,731
$ 1,000,000
(2,053,070)
(500,000)
S$ 164,661
Deferred CERF Items from FY2018
Approved Budget
Current
Purchase Replacement Funded by
Dept ID# Current Equipment Purpose Year/Make/Model Year Life Cost Cash
Police MP64637 1FDAF57P83ED00858 2003 FORD/BEARCAT 2003 15 303,940 303,940
Fire T25 Fire Alarm International 7400 Bucket Truck, Red 2003 15 159,875 159,875
Solid Waste 41 Packer Refuse Trucks 2012 Freightliner M2112V CNG 2012 7 299,166 299,166
Street 48 Sterling Vacuum Sweeper 2007 Sterling SC8000 2007 10 264,600 264,600
Street 33 6 WhI Dump W/Plow & Wing 2007 Chevrolet C5500 2007 10 181,333 181,333
Street 157 = 2WD Pick Up 2001 Chevy C1500 2WD 2001 10 38,500 38,500
School N/A — Technology Ford Freestar MiniVan 2006 10 33,352 33,352
$1,280,766 $1,280,766
Fiscal Year 2019
Planned CERF Replacement Schedule
Purchase Current
Dept Current Equipment Purpose Year/Make/Model Year Life Replacement Cost Funded by Cash Funded by Bond
Fire Engine 6 Pierce Arrow XT, Pumper, Red 2008 12 655,988 - 655,988
S$ 655,988 - S$ 655,988
Police Uniform K-9 2014 Ford/Explorer 2014 5 35,000 35,000 -
Police School 2007 Chevy/Impala 2007 12 33,168 33,168 -
Police Uniform Patrol 2010 Ford/Crown Victoria 2010 9 46,978 46,978 -
Police Uniform Patrol 2010 Ford/Crown Victoria 2010 9 46,978 46,978 -
$ 162,123 $162,123 -
ParkRec 3/4 Ton 2008 Ford F350 3/4 Ton Pickup 2008 10 46,903 46,903
ParkRec Dump truck w/ Plow Wing & Sander 2009 International 7400 Dump Truck 2009 10 190,400 190,400
ParkRec 3/4 Ton 4x4 PU w/ Plow 2012 Ford F350 PU w/plow CNG 2013 7 65,071 65,071
Solid Waste Excavator 2008 John Deere 270DLC 2007 10 321,315 321,315
Solid Waste JCB Loader 2011 JCB 527-55 2011 7 99,697 99,697
Solid Waste Front Load Packer Refuse Truck 2012 Mack MRU633 CNG 2012 7 326,369 - 326,369
Solid Waste Semi-Automated Refuse Trucks 2013 Mack LEU633 CNG 2012 7 366,258 - 366,258
Streets Sidewalk tractor 2010 Maclean MV1121 2010 5 130,734 130,734
Streets Ford F250 w/plow 2011 Ford F350 w/plow 2011 7 42,940 42,940
Streets 6 WhI Dump W/Plow & Wing 2006 International 7400 2005 10 190,400 190,400
Streets 6 WhI Dump W/Plow & Wing 2006 International 7400 2005 10 198,085 198,085
Streets 6 WhI Dump W/Plow & Wing 2006 International 7400 SFA 2006 10 198,085 198,085
Streets 6 WhI Dump W/Plow & Wing 2009 International 7400 SFA 2009 10 198,085 198,085
Traffic Bucket Truck 2009 Chevy C4500 Bucket Truck 2009 10 174,212 174,212
$ 2,548,555 $ 1,855,927 S$ 692,628
School Plumber Ford Cargo Van 2008 10 35,020 35,020
$35,020 $35,020
Total Costs
$ 3,401,686
$ 2,053,070 $ 1,348,616
7:00 PM
FINANCE COMMITTEE
MARCH 21, 2018
Aldermanic Chamber
ROLL CALL
PUBLIC COMMENT
PRESENTATION
Capital Equipment Reserve Fund Presentation
COMMUNICATIONS
From:
Re:
From:
Re:
From:
Re:
From:
Re:
From:
Re:
From:
Re:
From:
Re:
From:
Re:
Mayor Jim Donchess
Emergency PO Request — Emergency Contract with TDD Earth Tech, Inc. for $12,380 to
Perform Sewer Repairs
Dan Kooken, Purchasing Manager
Purchase of Used Undercover Vehicles (Value: $17,559.95); Department: 150 Police
Fund: Department of Justice Forfeiture - Vehicles
Dan Kooken, Purchasing Manager
Ambulance Contract Extension (Value: $0); Department: 152 Fire
Dan Kooken, Purchasing Manager
Division of Public Health & Community Service Site Participation Agreement with Mary Hitchcock
Memorial Hospital and Dartmouth-Hitchcock Clinic (Value: $0)
Dan Kooken, Purchasing Manager
Broad Street Parkway Property Appraisals (Value: $10,000)
Dan Kooken, Purchasing Manager
Change Order #4 to Contact with Northeast Earth Mechanics to Expand Construction of the
Residential Setback Barrier Wall in the Phase I! Landfill (Value: $199,763)
Dan Kooken, Purchasing Manager
Nashua Transit System — Token Transit (Value $0)
Department: 186 Transportation; Fund: Grants
Dan Kooken, Purchasing Manager
KRT Appraisal Professional Property Revaluation (Value: $500,000)
Department: Financial Services; Fund: Cerf
UNFINISHED BUSINESS — None
Components
Part Number Description
304W SALE - TEN SPIN
4424 WEBSCAPES PEGASUS 4M ACTIVITY NET
4482 CAMEL BACK CLIMBER, DOUBLE
4504 CONCERTO SPIN CABASAS MEDIUM
4508 CONCERTO 5-CONGAS
9259202 TOUCH UP PAINT KIT - FREESTANDING (NO
PRICE)
943 MULTI-BOUNCER
MRTP2023M MUSHROOM PATH STEPPER
Swings
Product line: Freestanding
Age group:
Components
Part Number Description
2740 SWG PART THERAPEUTIC SWG SEAT W/CHAIN
(8' TR)
2840 SWG PART SLASH PROOF SEAT WI/CHAIN (8' TR)
2990 SWG PART TOT SEAT 360 DEG W/CHAIN (8' TR)
7147352 5" OD SINGLE POST SWG FRAME ONLY 2 SEATS
REQ
7147352X BAY EXTENSION FOR 5” OD SGL POST SWG
FRAME
RiskSign_Included
Product line: Freestanding
Age group:
Components
Part Number Description
787Z RISK MANAGEMENT SIGN - ENGLISH (NO PRICE)
Additional Items
Part Number Description
925961 THUMB DRIVE 2GB - MREC
926021 MREC CARD F/THUMB DRIVE
INSTALL INSTALL BOOK FOR PP ORDERS
BOOK
7/18/2022
QUOTE: R0071223423
Qty
1
a a pee Cee tee
|= -)
Qty
rere ©)
<
Weight
1,000.00
470.00
275.00
70.00
80.00
2.00
300.00
250.00
Weight
135.00
10.00
15.00
165.00
145.00
Weight
0.00
Weight
0.00
0.00
0.00
Unit Price
3,399.00
18,849.00
2,532.00
1,160.00
3,870.00
0.00
3,664.00
8,645.00
Unit Price
1,342.00
137.00
202.00
1,456.00
1,035.00
Unit Price
0.00
Unit Price
0.00
0.00
0.00
Page 3 of 5
Total
3,399.00
18,849.00
2,532.00
1,160.00
3,870.00
0.00
3,664.00
8,645.00
Total
1,342.00
274.00
202.00
1,456.00
1,035.00
Total
0.00
Total
0.00
0.00
0.00
