Matters ▸ Attachment
Somerville FY2017 CAFR — File 205316
CITY OF SOMERVILLE
MASSACHUSETTS
COMPREHENSIVE ANNUAL FINANCIAL REPORT
For the Year Ended June 30, 2017
Joseph A. Curtatone, Mayor
Edward Bean, Finance Director
Prepared by the City of Somerville Finance Department
On the Cover – Prospect Hill Monument
The Old Powder House as it stood in 1935 atop the hill at Nathan Tufts Park, overlooking Powder House
Square. Photo by Rie Lowenstein
CITY OF SOMERVILLE, MASSACHUSETTS
COMPREHENSIVE ANNUAL FINANCIAL REPORT
For the Year Ended
June 30, 2017
Prepared by the City of Somerville Finance Department
CITY OF SOMERVILLE, MASSACHUSETTS
COMPREHENSIVE ANNUAL FINANCIAL REPORT
JUNE 30, 2017
TABLE OF CONTENTS
Introductory Section ......................................................................................................................................................... 1
Letter of Transmittal ..................................................................................................................................................... 2
Certificate of Achievement for Excellence in Financial Reporting .............................................................................. 14
Organizational Chart .................................................................................................................................................. 15
Principal Officials ........................................................................................................................................................ 16
Financial Section ........................................................................................................................................................... 17
Independent Auditor’s Report ..................................................................................................................................... 19
Management’s Discussion and Analysis .................................................................................................................... 21
Basic Financial Statements ........................................................................................................................................ 32
Statement of Net Position ....................................................................................................................................... 33
Statement of Activities ............................................................................................................................................ 34
Governmental Funds – Balance Sheet .................................................................................................................. 36
Reconciliation of the Governmental Funds Balance Sheet Total Fund Balances to the
Statement of Net Position .................................................................................................................................. 37
Governmental Funds – Statement of Revenues, Expenditures and Changes in Fund Balances ......................... 38
Reconciliation of the Statement of Revenues, Expenditures, and Changes in Fund Balances of the
Governmental Funds to the Statement of Activities .......................................................................................... 39
Proprietary Funds – Statement of Net Position ...................................................................................................... 40
Proprietary Funds – Statement of Revenues, Expenses and Changes in Net Position ........................................ 41
Proprietary Funds – Statement of Cash Flows ...................................................................................................... 42
Fiduciary Funds – Statement of Fiduciary Net Position ......................................................................................... 43
Fiduciary Funds – Statement of Changes in Fiduciary Net Position ...................................................................... 44
Notes to Basic Financial Statements ..................................................................................................................... 45
Required Supplementary Information ........................................................................................................................ 84
Schedule of Revenues, Expenditures and Changes in Fund Balance – General Fund – Budget and Actual ...... 85
Pension Plan Schedules – Retirement System .......................................................................................................... 89
Schedule of Changes in the Net Pension Liability and Related Ratios ................................................................. 90
Schedule of Contributions ...................................................................................................................................... 91
Schedule of Investment Return .............................................................................................................................. 92
Pension Plan Schedules - City ................................................................................................................................... 93
Schedule of the City’s Proportionate Share of the Net Pension Liability ............................................................... 94
Schedule of City Contributions ............................................................................................................................... 95
Schedule of the Special Funding Amounts of the Net Pension Liability ................................................................ 96
Other Postemployment Benefits Plan Schedules ...................................................................................................... 97
Schedule of Changes in the City’s Net Other Postemployment Benefit Liability and Related Ratios ................... 98
Other Postemployment Benefit Plan Schedule of City Contributions .................................................................... 99
Other Postemployment Benefit Plan Schedule of Investment Returns ............................................................... 100
Other Postemployment Benefits Plan Schedule of Funding Progress and Employer Contributions ................... 101
Other Postemployment Benefit Plan Actuarial Methods and Assumptions ......................................................... 102
Notes to Required Supplementary Information ........................................................................................................ 103
Combining and Individual Fund Statements ........................................................................................................ 107
Nonmajor Governmental Funds ....................................................................................................................... 108
Nonmajor Governmental Funds – Combining Balance Sheet ...................................................................... 110
Nonmajor Governmental Funds – Combining Statement of Revenues, Expenditures, and Changes in
Fund Balances ......................................................................................................................................... 114
Agency Fund ..................................................................................................................................................... 117
Agency Fund – Statement of Changes in Assets and Liabilities .................................................................. 118
Statistical Section ..................................................................................................................................................... 119
Net Position by Component – Last Ten Years ..................................................................................................... 120
Changes in Net Position – Last Ten Years .......................................................................................................... 121
Fund Balances, Governmental Funds – Last Ten Years ..................................................................................... 122
Changes in Fund Balances, Governmental Funds – Last Ten Years .................................................................. 123
Assessed Value and Actual Value of Taxable Property by Classification and Tax Rates –
Last Ten Years ................................................................................................................................................ 124
Principal Taxpayers – Current Year and Nine Years Ago .................................................................................... 125
Property Tax Levies and Collections – Last Ten Years ....................................................................................... 126
Ratios of Outstanding Debt and General Bonded Debt – Last Ten Years .......................................................... 127
Computation of Legal Debt Margin – Last Ten Years .......................................................................................... 128
Direct and Overlapping Governmental Activities Debt ......................................................................................... 129
Demographic and Economic Statistics – Last Ten Years .................................................................................... 130
Principal Employers (Excluding City) – Current Year and Nine Years Ago ......................................................... 131
Full-Time Equivalent City Employees – Last Ten Years ...................................................................................... 132
Operating Indicators by Function/Program – Last Ten Years .............................................................................. 133
Capital Asset Statistics by Function/Program – Last Ten Years .......................................................................... 134
Introductory Section
Assembly Square Marketplace is a power center and mixed-use development located in Assembly Square. It
includes premium retail outlets, restaurants, residential space, state-of-the-art office and research space, and
development space. Photo by Rie Lowenstein
City of Somerville, Massachusetts 1 Comprehensive Annual Financial Report
Introductory Section
City of Somerville, Massachusetts 2 Comprehensive Annual Financial Report
City of Somerville, Massachusetts
Joseph A. Curtatone
MAYOR
Letter of Transmittal
December 20, 2017
We are pleased to submit to you the Comprehensive Annual Financial Report (CAFR) of the City of
Somerville (City) for the year ended June 30, 2017. The CAFR is prepared by the City's Finance
Department, and is intended to provide information regarding the financial position of the City. This report
is prepared in accordance with U.S. generally accepted accounting principles (GAAP) and meets all
requirements of state finance law of the Commonwealth of Massachusetts.
The responsibility for the accuracy, completeness, and fairness of the data presented, including
disclosures, rests with the City. City management believes this report is accurate in all material respects
and is presented in a manner which impartially sets forth the financial position and results of operations of
the City. Management is also responsible for establishing and maintaining internal accounting controls
designed to provide reasonable, but not absolute, assurance that these financial statements are complete
and accurate in their presentation.
The Commonwealth of Massachusetts, through Chapter 190 of the Acts of 1982, requires that the City
undergo an annual audit performed by a firm of independent public accountants. The City has selected
Powers & Sullivan, LLC, to perform the June 30, 2017, audit. The goal of the independent audit was to
provide reasonable assurance that the financial statements of the City of Somerville for the year ended
June 30, 2017, are free of material misstatements.
The independent audit involved examining, on a test basis, evidence supporting the amounts and
disclosures in the financial statements; assessing the accounting principles used and significant
estimates made by management; and evaluating the overall financial statement presentation. The
independent auditor concluded, based upon the audit, that there was a reasonable basis for rendering an
unqualified opinion that the City of Somerville’s financial statements for the year ended June 30, 2017,
are fairly presented in conformity with GAAP. The independent auditor’s report is presented as the first
component of the financial section of this report.
The independent audit of the financial statements of the City of Somerville was part of a broader, federally
mandated “Single Audit” designed to meet the special needs of federal grantor agencies. The standards
governing Single Audit engagements require the independent auditor to report not only on the fair
presentation of the financial statements, but also on the audited government’s internal controls and
compliance with legal requirements, with special emphasis on internal controls and legal requirements
involving the administration of federal awards. These reports are available in the City of Somerville’s
separately issued Single Audit Report.
The City’s Single Audit report for the year ended June 30, 2017, included no instances of significant
violations of the applicable laws and regulations reported. Generally accepted accounting principles
require that management provide a narrative introduction, overview and analysis to accompany the basic
City of Somerville, Massachusetts 3 Comprehensive Annual Financial Report
financial statements in the form of an MD&A. This letter of transmittal is designed to complement the
MD&A where the financial analysis is now presented. The City’s MD&A can be found immediately
following the independent auditor’s report from Powers & Sullivan, LLC.
GENERAL PROFILE
Somerville is a city located in Middlesex
County, Massachusetts, just two miles
north of Boston. Occupying slightly more
than
four
square
miles
and
with
a population of 80,318, including thriving
immigrant communities from all over the
world, Somerville is the most densely
populated community in New England
and one of the most ethnically diverse
cities in the nation. Rich in both history
and culture, the City boasts numerous
intriguing historical sites, community
spaces, businesses, and restaurants.
Somerville was first settled in 1630 as a
part
of
Charlestown,
and
was
established as a town in 1842, when it was separated from the urbanizing Charlestown because it was
still largely rural. Somerville was officially incorporated as a City in 1872 due to its growing population and
increasing industrialization. By the early 1900s, Somerville itself had become a densely packed urban
area.
As a part of Charlestown, areas existing in modern-day Somerville were critical military positions in the
American Revolution. The historic Powder House - now considered one of the most distinct pre-
Revolutionary structures in Massachusetts - housed gunpowder for Revolutionary soldiers during the war.
During British invasion, Somerville (then Charlestown) was part of the route ridden by Paul Revere on his
famous "Midnight Ride." Finally, and most notably, Prospect Hill was the site of the raising of the first
Grand Union Flag, under the orders of General George Washington, on January 1, 1776.
Today, Somerville is an eclectic mix of blue-collar families, young professionals, growing and established
families, college students, and recent immigrants from countries as varied as Brazil, Haiti, and
Nepal. There are more than 50 spoken languages in Somerville schools. With a large immigrant
population, Somerville celebrates its diversity through numerous events celebrating cultural traditions and
holidays. Somerville is a diverse, dense, walkable, community. Given the City’s convenient location near
numerous educational institutions, including three of the nation’s leading institutions of higher learning,
Tufts, Harvard, and MIT, it comes as no surprise that college and graduate students make up almost one-
fifth of the population.
Somerville is defined by its city squares. Its large number of squares help mark neighborhood boundaries
while also featuring bustling businesses and entertainment centers. The primary business districts of the
city are Assembly Square, Davis Square, and Union Square. Additionally, Ball Square, Teele Square, and
Magoun Square are popular destinations with their own history and unique storefronts. Each offers a mix
of ethnic restaurants, bars, shops and small businesses to fit every taste and occasion. The City shares
its southern border with Cambridge and the MBTA Red Line connects Davis Square to Cambridge and
Boston.
City of Somerville, Massachusetts 4 Comprehensive Annual Financial Report
Somerville has a mayor-city council form of municipal government. The Board of Aldermen consists of 4
at-large (city-wide) positions and 7 ward representatives. Somerville has received national recognition as
a model of innovation and efficiency for their 311 customer service helpline and SomerStat, a data-driven
style of managing government services. Somerville was also the first community in Massachusetts to
employ both a 311 customer service help line and a Connect-CTY mass outreach (reverse 911)
program.
QUALITY OF LIFE
Somerville is home to a thriving arts community. Regular arts-related events, such as the annual
"ArtBeat" festival, occur throughout the year. In addition, numerous galleries and music clubs showcase
the talents of residents and others. Two major art studios, the Brickbottom Artists Building and the Joy
Street Studios, are located in former industrial buildings in the Brickbottom District of the city. The
Somerville Theatre, located in Davis Square, houses the Somerville branch of the Museum of Bad Art
and plays host to the Independent Film Festival of Boston each spring. The Somerville Arts Council and
Somerville Open Studios both host annual events involving the community in homegrown arts.
The Somerville Public Schools (SPS) is a richly diverse school district that ranks as one of the top-
performing urban districts in the Commonwealth. MCAS scores have continued to rise in the past several
years and the district has maintained extraordinary overall growth, exceeding most other Massachusetts
school districts. Somerville High School, a fully comprehensive high school that offers a rigorous core
curriculum and one of the best Career and Technical Education (CTE) programs in the state, is the only
MA urban high school to earn a Level I state accountability rating for five straight years. The district 4-
year graduation rate has steadily improved while the drop-out rate has continued to decline to a current
all-time low of 1.9%. SPS emphasizes supporting the “whole child” through a data-informed, collaborative
system of support, and programs that ensure that every student has the opportunity to grow and succeed.
A strong core curriculum is supplemented with equally strong visual and performing arts, world language,
health and wellness, and technology programs, as well as a plethora of extra-curricular activities. Recent
investments in pre-K and afterschool programming help lay a solid educational foundation for students,
and partnerships play a critical role in providing SPS students with the support they need to succeed in a
global economy. Partners such as Biogen, Teen Empowerment, Groundwork Somerville, Breakthrough
Greater Boston, Enroot, Citizen Schools, and others provide Somerville students with continuous hands-
on support and opportunities for real-world connections and learning. The City has also overhauled its
youth programs by hiring new directors, and reinstating lost programs and services. Programs include the
SomerTime Day Camp, the Mayor's Summer Jobs Program, and a partnership with Teen Empowerment,
the nationally known non-profit organization, to establish a broad-based teen leadership program. In
2008, the City of Somerville was selected by the America's Promise Alliance as one of the top 100
communities in the U.S. for youth programming and learning opportunities.
Alternative transportation is also important to Somerville residents. The City was acknowledged by the
National Association of City Transportation Officials as an affiliate member for its commitment to
sustainable transportation initiatives. Additionally, the League of American Bicyclists ranked Somerville
the number one city on the East coast and seventh in the nation in terms of bike commuting share in their
2016 annual report. The 2015 report showed an incredible 53.2% of all commuting trips made by bicycle,
transit or walking – a metric which is only expected to increase with the extension of the MBTA’s Green
Line through Somerville in the coming years.
With its bright development future featuring new, mixed-use development projects, and innovative local
government management, Somerville has been recognized as "the best run City in the Commonwealth"
by the Boston Globe magazine. The National Civic League recognized Somerville as an All-America City
in 2009 for outstanding civic accomplishments in innovation, inclusiveness, civic engagement, and cross
City of Somerville, Massachusetts 5 Comprehensive Annual Financial Report
sector collaboration to address pressing local challenges. In 2015, Somerville again received this award
for engaging and supporting vulnerable boys and young men.
ECONOMIC DEVELOPMENT
Through the Mayor’s Office of Strategic Planning and Community Development (OSPCD), the City of
Somerville has taken the lead role in planning and implementing major economic projects designed to
increase the City’s tax base and create new jobs. Several major economic development activities are
described below.
Assembly Square
Assembly Square is Somerville’s largest commercial and industrial district and is among a short list of
sites with the greatest potential for development in the Metro Boston Area. Assembly Square is a 145-
acre district located at the northeast corner of the City on the Boston border.
Source: u/vanhoosear on Flickr
Its location, less than 2.5 miles from downtown Boston and just two miles from Kendall Square in
Cambridge, and existing transportation infrastructure make it one of the premier development sites in
New England. Assembly Square is directly accessible from Interstate 93 and State Route 28. In
December 2011, the MBTA commenced construction of the MBTA’s Orange Line in Assembly Square
station and opened the station to riders in September of 2014. Assembly Square contains more than five
acres of waterfront open space located along the banks of the Mystic River. To capitalize on these
strengths, the City has undertaken an aggressive planning and redevelopment effort designed to convert
this former industrial district to a transit-oriented, mixed-use “urban village”, using smart growth principles
to maximize development potential.
In May 2011, the developer Federal Realty Investment Trust (FRIT), the State, and the City entered into a
Tri-Party Agreement that acts as the document binding each party to certain requirements which includes
District Increment Financing (DIF) and the State’s commitment to fund the Orange Line T Station. To
date, the DIF captured increment has significantly exceeded debt service payment amounts with an
anticipated fund balance of $9 million by the end FY2020 to be used for infrastructure improvements.
In 2013, FRIT completed the acquisition of the twelve-acre parcel that was to have been developed and
occupied by IKEA in the original plans for Assembly Row. In December of 2013, Partners Healthcare
announced its intention to consolidate its operations scattered across more than a dozen offices in and
around Boston together under one roof at Assembly Square on the former IKEA property. Partners, the
state’s largest health system and biggest private employer, started moving employees into the new
750,000 square feet office building. A subsequent phase of Partners’ development is expected to result
another 400,000 square feet of retail and commercial space within the building.
A new network of roadways, storm water conduit, Blocks 1, 2, 3, and 4, the Orange Line Transit Station,
and the 5+-acre waterfront park have been completed along with the administrative building for Partners
Healthcare with adjoining garage. The following projects are currently under construction: FRIT
development block 5 (a multistory, mixed-use building consisting of 155 hotel rooms, 104 residential
City of Somerville, Massachusetts 6 Comprehensive Annual Financial Report
units, 22,000 square-feet of retail/commercial use) and block 6 (a mixed-use structure with 471 residential
units, 40,000 square feet of retail/commercial use and structured parking for 671 vehicles).
Union Square
Union Square is the City’s second largest business district, known throughout the region as a multi-ethnic
arts and dining destination. In 2004, the City worked with neighborhood residents, businesses, and
property owners to create “Union Square Main Streets,” a non-profit community organization based on
the National Main Street Center’s successful downtown revitalization model.
In the past few years, the City has received a $415,000 grant from ArtPlace America as well as a
$460,000 grant to fund the creation of “ArtFarm for Social Innovation” on the site of a former waste
transfer station; a $42,000 grant for strategic planning for the development of city-owned properties in
Union Square; over $1,000,000 in new state and federal Brownfields funding for parcels in the area; the
initiation of a Saturday farmers market partially funded by a Robert Wood Johnson Grant, and the
construction of two small urban parks.
The City has completed both a $24 million new elementary school at the edge of Union Square and a $21
million reconstruction of Somerville Avenue between Union and Porter Squares. In January 2015, a Full
Funding Grant Agreement between the MBTA and the US Department of Transportation Federal
Transportation Administration was signed. Under this FFGA, federal dollars have been committed to fund
approximately one half of the Green Line Extension Project. In April 2009, the Board of Aldermen
approved rezoning of the Union Square and Boynton Yards areas.
The City has been working with the community on the development of a new transportation plan for Union
Square. Conceptual plans were developed in 2012 and seek to balance traffic flow in the context of
quality of life, future development, greater design goals, and the introduction of MBTA light rail. The
project will see the reconstruction of two major arterials through the square, continuation of the newly
separated Somerville Avenue storm and sanitary sewer lines, and significant expansion of the public
plaza. A new Neighborhood plan was also adopted by the City’s Planning Board in May of 2016 as an
amendment and implementation appendix to SomerVision.
In 2012, the City initiated a multi-year comprehensive planning process with goal of transforming Union
Square back to its historic prominence as a major employment center. The centerpiece of this effort
entails concentrate new, mixed-used development around the new Union Square transit stop that will
come along with the expansion of the MBTA Green Line. In 2012, the City and the Somerville
Redevelopment Authority (SRA) approved the Union Square Urban Revitalization Plan that identified
seven distinct parcels for major redevelopment. In 2014, the SRA selected Union Square Station
Associates (US2) as the master developer for Union Square. A robust community planning process
resulted in the Union Square Neighborhood Plan in 2016. Union Square was rezoned in 2017 to reflect
the goals of the plan. The Somerville Planning Board approved US2’s Coordinated Development Special
Permit in December of 2017, which entitles US2’s 2.3 million square foot development program that
includes housing, retail, office and lab space.
Concurrently, the City has been working with the community on the development of a new transportation
plan for Union Square. Conceptual plans were developed in 2012 and seek to balance traffic flow in the
context of quality of life, future development, greater design goals, and the introduction of MBTA light rail.
The project will see the reconstruction of two major arterials through the square, continuation of the newly
separated Somerville Avenue storm and sanitary sewer lines, and significant expansion of the public
plaza. A new Neighborhood plan was also adopted by the City’s Planning Board in May of 2016 as an
amendment and implementation appendix to SomerVision.
City of Somerville, Massachusetts 7 Comprehensive Annual Financial Report
In the fall of 2017, the administration submitted to the Board of Aldermen for their approval a DIF
financing plan for $141 million in infrastructure and streetscape projects that will both help alleviate
existing flooding issues for two-thirds of the city as well as unlock development potential in the district. In
December of 2017, the Board of Alderman approved the DIF financing plan as well as the first phase of
projects, which includes a $63 million authorization for Somerville Ave water, sewer and streetscape
work.
Boynton Yards & Inner Belt/Brickbottom
The extension of the Green Line into Union Square has generated new interest in Boynton Yards; the
transit stop lies in the northwest corner of the 35-acre district. In April 2009, the Board of Aldermen
approved a rezoning of this important development area and much of Boynton Yards is now located in a
Transit Oriented District (TOD), which allows for maximum density and building heights.
The City contracted with Parsons Brinckerhoff to conduct a transportation and utility study of Boynton
Yards as the first step in creating a new road network and utility infrastructure to support more intense
commercial development. The study envisions significant long-term public and private investments in
infrastructure allowing for transformational change in Boynton Yards. Through the focal point of the
proposed MBTA Green Line Union Square Station, Boynton Yards and Union Square will develop a
cohesive identity and become a regional destination for art, shopping and dining.
The Inner Belt is a 160-acre manufacturing and warehouse district that is anticipated to transition to
higher-end office and biotechnology uses. An off-ramp which was constructed as part of the Central
Artery Project (the “Big Dig”) has improved regional automobile access to Inner Belt. To facilitate Inner
Belt’s transition to higher-end uses, the City approved a significant privately-financed infrastructure
investment to connect Inner Belt to the fiber optic loop around Boston and Cambridge. The location of this
major communications node makes Inner Belt a very competitive location for technology-oriented
businesses along with proximity to nearby Kendall Square in Cambridge.
This district will benefit dramatically from the planned McGrath Highway Boulevard Project. The City has
completed a formal study and is looking to undertake design work and environmental review associated
with the long-term conversion of the elevated McCarthy overpass into an at-grade boulevard with
“complete streets” style bicycle and pedestrian accommodations.
Established employers, including ABM Industries, the Angelica Corporation, and the Cambridge Health
Alliance continue to provide employment opportunities in Somerville. In addition, the City has seen the
installation of two sizeable internet data centers and associated investment in the physical facility and
equipment at 50 and 70 Inner Belt Road. The City, working through OSPCD, has completed various
studies, including a planning study that identified public actions necessary to facilitate transformation of
this district to office and biotechnology uses. Access studies were completed in 2005 to predict the impact
of economic development on traffic patterns in the Inner Belt. The City has been taking preliminary steps,
with the assistance of Greenberg/CBT consultants to develop a comprehensive plan for the area. The
Greenberg/CBT scoping study identified a build out potential of 2.5 million square feet of Lab/R&D, 3
million square feet of office, 200,000 square feet of retail space, 200-450 hotel rooms, and 3,000
residential units.
Davis Square
Davis Square is one of the City’s most vibrant central business districts. This commercial center is located
in close proximity to nearby Tufts University and has an MBTA Red Line subway station. The combination
of this district’s location and public transit access has resulted in strong demand for office, retail,
restaurant and entertainment uses. Consequently, Davis Square has limited vacancy in the retail and
City of Somerville, Massachusetts 8 Comprehensive Annual Financial Report
office market segments. Davis Square has become a regional dining and entertainment destination with
some of the Boston area’s finest restaurants, nightclubs, and live entertainment venues. The residential
neighborhood surrounding Davis Square has seen dramatic increases in property values and rents, which
has resulted in considerable new investment and condominium conversion.
Future plans in Davis Square will focus on strategic infill development, streetscape updates or
rehabilitation projects to enhance the already vibrant community. In May of 2014, the Mayors of
Somerville, Cambridge, Boston, Quincy & Braintree launched the Life Sciences Corridor Initiative to
promote the robust life sciences sector which has developed along the Red Line, including Davis Square.
Together, the five cities represent over 460 companies within the life sciences industry, all connected
through the MBTA Red Line.
City-Wide Economic Evolution
Somerville has seen strong developments in the local innovation economy including one of the first on-
speculation office buildings in the region in many years in Assembly Square. Partners Healthcare has
finished construction on a $280 million, 1.1 million square-foot administrative space which will house
4,500 employees and provide employment and career-development opportunities for Somerville
residents. Office space in the Assembly Square Neighborhood has garnered interest from software,
technology, and healthcare companies and has filled over 60,000 square feet of space to date.
Across the City, cleantech incubator Greentown Labs
relocated in 2012 to a 33,000 square-foot location near
Union Square, growing from hosting four companies in
2007 to more than forty today. The location offers a
prototyping lab, co-located office space, machine and
electronics shops, and a developing community of
startups looking to rapidly grow and progress new
products in the clean energy industry. 2016 saw the
breaking ground on an expansion projects that will more
than double the incubator’s space to 93,000 square feet
– enabling Greentown to serve as a global player for
cleantech innovation.
Transportation Improvements
As mentioned, the City secured funding for a new Assembly Square Orange Line station using a
combination of federal, state and private funding. The station was opened for use in September of 2014,
the first new MBTA station since 1987.
While the Assembly Square station promises to support critical smart-growth economic development, the
MBTA’s light rail Green Line Extension (GLX) through Somerville will, along with existing Red Line
service, bring rapid transit to 85% of residents – thereby significantly improving the city’s air quality,
connectivity, and economic opportunity. Opening of the first three stations (Updated Lechemere,
Washington St, and Union Square) is up first in the schedule and the remaining four stations (Gilman,
Lowell St, Ball Square, and College Ave) will follow.
Source: u/Pi.1415926535 on Wikipedia
City of Somerville, Massachusetts 9 Comprehensive Annual Financial Report
Major Infrastructure Projects
The City is currently planning or undertaking multiple streetscape and roadway improvement projects
which will increase multimodal mobility and continue to bring an infrastructure network built in the early
1900s into the 21st century. These projects include a full-depth reconstruction of Beacon St (One of the
most heavily-trafficked stretches of road in the region by bicycle commuters), a streetscape and utility
update in Davis Square, Central Broadway Streetscape upgrades, major Union Square utility work, and
roadway improvements in Ball and Gilman Squares to prepare for the Green Line Extension. Altogether,
these projects will continue to make Somerville one of the most bike and pedestrian-friendly communities
in the Northeast while updating an underground infrastructure network built primarily in the 1800’s.
Financial Summary
The City continues to be in sound financial condition as demonstrated by the financial statements and
schedules included in this report. Throughout the year, the City maintained a strong cash and investment
position and once again did not issue any tax anticipation notes.
General Fund Balances and Cash Position
Under Massachusetts law an amount known as "free cash" is certified as of the beginning of each fiscal
year by the State Bureau of Accounts. “Free cash” together with certain subsequent tax receipts are used
as the basis for subsequent appropriations from available funds. These funds are not required to be
included in the annual tax levy. The City’s certified “free cash” for fiscal year 2017 is $11,621,352. The
following table sets forth the recent trend in Free Cash for the City.
Free Cash (July 1)
2017
$11,621,352
2016
10,833,988
2015
11,512,278
2014
10,651,386
2013
10,637,719
2012
7,846,054
2011
7,646,537
City of Somerville, Massachusetts 10 Comprehensive Annual Financial Report
Stabilization Funds
The City maintains several stabilization funds. Funded by an appropriation, the Stabilization Funds plus
interest income may be appropriated at any Board of Aldermen meeting for any municipal purpose.
The following table lists the Stabilization Funds balances for the following years.
Stabilization Fund
Balance
2017
$34,162,355
2016
28,852,284
2015
23,682,116
2014
15,495,452
2013
11,922,271
2012
12,476,965
2011
11,662,056
Capital Financing and Debt Management
In conjunction with the operating budget, the City annually prepares a capital budget for the upcoming
fiscal year and a ten–year Capital Investment Table that is used as a guide for capital expenditures in
future years. The Capital Investment Plan for FY18 through FY27 has an estimated cost of $490 million.
Financing for the current-year portion of the capital plan is appropriated on a project-by-project basis.
The City issues its debt in accordance with the life of the asset. In addition, the City has funded a portion
of its Capital Improvement Program on a “pay-as-you-go” basis out of current revenues. The City’s
General Obligation (GO) outstanding bonded debt as of June 30, 2017, totaled $106.7 million. The
following table sets forth debt as a percentage of assessed valuation and per capita debt at the end of the
last five fiscal years. The table considers the principal amount of GO bonds of the City only and does not
deduct anticipated state grant payments applicable to the principal amount of outstanding bonds or debt
that may be supported in wh ole, or part, by non-tax revenues.
Year End
General Obligation
Bonds
Outstanding
Local
Assessed
Valuation
Per
Capita
Debt
Bonds as a %
of Assessed
Valuation
2017
$106,688,839
$12,660,529,500
$1,312
0.84
2016
104,244,459
11,198,774,270
1,298
0.93
2015
95,151,544
10,492,225,280
1,206
0.91
2014
96,283,023
9,445,672,400
1,222
1.02
2013
97,615,491
8,595,335,050
1,275
1.14
2012
90,422,762
8,390,572,190
1,186
1.08
2011
81,971,701
8,297,876,320
1,079
0.99
City of Somerville, Massachusetts 11 Comprehensive Annual Financial Report
Property Valuations
Based on valuations of all real and personal property as of January 1, 2016, the total value of all property
in the City is $12.7 billion. Professional reevaluations of all property in the City to full and fair cash value
in compliance with Massachusetts law were mostly recently completed for use in 2014. The next
reevaluation will be completed in 2016. The City conducts an interim year adjustment on values annually.
The table below sets forth the trend in the City's assessed valuations, tax rates, tax levies, and tax levies
per capita for the following years.
Fisc
al
Year
Real Estate
Valuation
Personal
Property
Valuation
Assessed
Valuation
Tax Rate Per
$1,000
Valuation
Tax Levy
Tax
Levy
Per
Capita
Resid.
All
other
2017
$12,409,326,300 $251,203,200
$12,660,529,500
$11.67
$18.81 $136,071,683
1,675
2016
10,974,792,900
223,981,370
11,198,774,270
12.53
20.18
129,147,863
1,608
2015
10,276,528,400
215,696,880
10,492,225,280
12.61
20.38
122,165,461
1,548
2014
9,246,622,500
199,049,900
9,445,672,400
12.66
21.51
116,126,060
1,473
2013
8,409,496,900
185,838,150
8,595,335,050
13.42
22.38
109,923,036
1,446
2012
8,212,040,400
178,531,790
8,390,572,190
13.09
21.85
104,829,090
1,383
2011
8,132,444,500
165,431,820
8,297,876,320
12.71
21.21
100,548,992
1,327
Pension Liability
Generally accepted accounting principles (GAAP) require the City to perform an actuarial valuation to
determine the pension benefit obligation at least biennially, with an actuarial update to the date twelve
months after that biennial valuation. The most recent actuarial valuation of the City was completed as of
January 1, 2017.
The total unfunded pension benefit obligation applicable to the City's employees was $140,166,391 at
December 31, 2016.
Total pension benefit obligation
$392,656,092
Net Position available for benefits, at market value
(242,801,289)
Unfunded pension benefit obligation
$149,854,803
The City is currently on a funding schedule that will amortize its unfunded pension liability by June 30,
2033. Current law allows funding out as far as 2040.
In addition to the contributory systems, cities and towns provide non-contributory pensions to a limited
number of employees, primarily persons who entered service prior to July 1, 1937, and their dependents.
City of Somerville, Massachusetts 12 Comprehensive Annual Financial Report
The annual required contributions of the City to the retirement system for the 2011 through 2017 fiscal
years are as follows:
Year
Contributory
Non-
Contributory
2017
$13,711,675
$121,197
2016
13,304,274
119,000
2015
12,324,940
255,023
2014
11,457,093
234,769
2013
11,084,135
231,999
2012
10,985,945
283,996
2011
10,830,988
333,431
Other Post-Employment Benefits (OPEB) Liability
In addition to pension benefits, cities and towns may provide retired employees with health care and life
insurance benefits. The portion of the cost of such benefits paid by cities and towns is generally provided on
a pay-as-you-go basis. The pay-as-you-go costs to the City for such benefits in recent years have been as
follows:
Year
Amount
2017
$9,258,566
2016
8,533,496
2015
9,645,790
2014
9,044,970
2013
10,402,192
2012
10,036,871
2011
10,200,914
The City obtained a new actuarial valuation for the City’s OPEB liability as of June 30, 2016. The City
had an unfunded actuarial liability (UAL) that totaled $301,834,818 on a pay-as-you-go 4.0% basis and
$178,480,760 on a full prefunding 7.5% basis. The City's annual required contribution (ARC) totaled
$21,086,425 on a pay-as-you-go basis and $13,138,247 on a full prefunding basis.
INDEPENDENT AUDIT
The City’s financial records, books of accounts, and financial transactions are audited each year by an
independent firm of certified public accountants. The City’s annual audit was performed by the
independent public accounting firm of Powers & Sullivan, LLC. The independent auditors’ report on the
basic financial statements for the year ended June 30, 2017 is included herein.
City of Somerville, Massachusetts 13 Comprehensive Annual Financial Report
AWARDS AND ACKNOWLEDGEMENTS
The Government Finance Officers Association of the United States and Canada (GFOA) awarded a
Certificate of Achievement for Excellence in Financial Reporting to the City of Somerville for its
comprehensive annual financial report since fiscal year 2012, five years in a row that the City has
achieved this prestigious award. Additionally, the City’s FY14, FY15, and FY16 annual operating budgets
received the Distinguished Budget Presentation Award. And In order to be awarded a Certificate of
Achievement, a government must publish an easily readable and efficiently organized comprehensive
annual financial report or budget. This report must satisfy both generally accepted accounting principles
and applicable legal requirements.
A Certificate of Achievement is valid for a period of one year only. We believe that our current
Comprehensive Annual Financial Report continues to meet Certificate of Achievement Program’s
requirements and will be submitting it to the GFOA to determine its eligibility for another certificate.
MOVING FORWARD
The City will continue the necessary work of growing our commercial tax base.
The long-term outlook for Somerville remains very strong as long as we
continue to manage our resources wisely. Both our bond rating and our
development prospects have been buttressed by the City’s effort to develop
comprehensive and coordinated plans to make the most of coming transit
improvements and new investments in retail, commercial and residential growth.
While no community can be fully insulated from continued turbulence in the
national and regional economies, Somerville is well positioned to preserve its
high level of municipal services while preparing for future economic
development. We are governing in the present with an eye on our future.
Sincerely,
Mayor Joseph A. Curtatone
City of Somerville, Massachusetts 14 Comprehensive Annual Financial Report
Certificate of Achievement for Excellence in Financial Reporting
City of Somerville, Massachusetts 15 Comprehensive Annual Financial Report
Organizational Chart
Organizational Chart
City of Somerville, Massachusetts
16
Comprehensive Annual Financial Report
City Government
Joseph A. Curtatone, Mayor
Edward Bean, Finance Director
Ida Cody, Deputy City Auditor
Michael Mastrobuoni, Budget Manager
Board of Aldermen
William A White Jr, President, At-large
Katjana Ballantyne, Vice President, Ward 7
John M Connolly, At-large
Mary Jo Rossetti, At-large
Dennis M Sullivan, At-large
Matthew McLaughlin, Ward 1
Maryann M Heuston, Ward 2
Robert J McWatters, Ward 3
Tony G Lafuente, Ward 4
Mark Niedergang, Ward 5
Lance L Davis, Ward 6
Principal Officials
Financial Section
The Somerville City Hall (which formerly served as Somerville High School) is a historic municipal building at
93 Highland Avenue in Somerville, Massachusetts. Built in 1852 and enlarged several times, it has served as
the City's first high school, first public library, and only city hall.
Photo taken by Rie Lowenstein
City of Somerville, Massachusetts
17
Comprehensive Annual Financial Report
Financial Section
City of Somerville, Massachusetts
18
Comprehensive Annual Financial Report
This page intentionally left blank.
City of Somerville, Massachusetts
19
Comprehensive Annual Financial Report
Independent Auditor’s Report
To the Honorable Mayor and Board of Alderman
City of Somerville, Massachusetts
Report on the Financial Statements
We have audited the accompanying financial statements of the governmental activities, the business-type
activities, each major fund, and the aggregate remaining fund information of the City of Somerville,
Massachusetts, as of and for the year ended June 30, 2017, (except for the Somerville Contributory Retirement
System which is as of and for the year ended December 31, 2016), and the related notes to the financial
statements, which collectively comprise the City’s basic financial statements as listed in the table of contents.
Management’s Responsibility for the Financial Statements
Management is responsible for the preparation and fair presentation of these financial statements in accordance
with accounting principles generally accepted in the United States of America; this includes the design,
implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial
statements that are free from material misstatement, whether due to fraud or error.
Auditor’s Responsibility
Our responsibility is to express opinions on these financial statements based on our audit. We conducted our
audit in accordance with auditing standards generally accepted in the United States of America and the standards
applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of
the United States. Those standards require that we plan and perform the audit to obtain reasonable assurance
about whether the financial statements are free of material misstatement.
An audit involves performing procedures to obtain audit evidence about the amounts and disclosures in the
financial statements. The procedures selected depend on the auditor’s judgment, including the assessment of the
risks of material misstatement of the financial statements, whether due to fraud or error. In making those risk
assessments, the auditor considers internal control relevant to the entity’s preparation and fair presentation of the
financial statements in order to design audit procedures that are appropriate in the circumstances, but not for the
purpose of expressing an opinion on the effectiveness of the entity’s internal control. Accordingly, we express no
such opinion. An audit also includes evaluating the appropriateness of accounting policies used and the
reasonableness of significant accounting estimates made by management, as well as the evaluating the overall
presentation of the financial statements.
We believe that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our audit
opinions.
Opinions
In our opinion, the financial statements referred to above present fairly, in all material respects, the respective
financial position of the governmental activities, the business-type activities, each major fund, and the aggregate
remaining fund information of the City of Somerville, Massachusetts, as of June 30, 2017 (except for the
Somerville Contributory Retirement System which is as of December 31, 2016), and the respective changes in
financial position and, where applicable, cash flows thereof for the year then ended in accordance with accounting
principles generally accepted in the United States of America.
City of Somerville, Massachusetts
20
Comprehensive Annual Financial Report
Other Matters
Required Supplementary Information
Accounting principles generally accepted in the United States of America require that the management’s
discussion and analysis and required supplementary information, as listed in the table of contents, be presented
to supplement the basic financial statements. Such information, although not a part of the basic financial
statements, is required by the Governmental Accounting Standards Board who considers it to be an essential part
of financial reporting for placing the basic financial statements in an appropriate operational, economic, or
historical context. We have applied certain limited procedures to the required supplementary information in
accordance with auditing standards generally accepted in the United States of America, which consisted of
inquiries of management about the methods of preparing the information and comparing the information for
consistency with management’s responses to our inquiries, the basic financial statements, and other knowledge
we obtained during our audit of the basic financial statements. We do not express an opinion or provide any
assurance on the information because the limited procedures do not provide us with sufficient evidence to
express an opinion or provide any assurance.
Other Information
Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise
the City of Somerville’s basic financial statements. The introductory section, combining and individual fund
statements, and statistical sections are presented for purposes of additional analysis and are not a required part
of the basic financial statements.
The combining and individual fund statements, as listed in the table of contents, are the responsibility of
management and were derived from and relates directly to the underlining accounting and other records used to
prepare the basic financial statements. Such information has been subjected to the auditing procedures applied
in the audit of the basic financial statements and certain additional procedures, including comparing and
reconciling such information directly to the underlying accounting and other records used to prepare the basic
financial statements or to the basic financial statements themselves, and other additional procedures in
accordance with auditing standards generally accepted in the United States of America. In our opinion, the
combining and individual fund statements are fairly stated, in all material respects, in relation to the basic financial
statements as a whole.
The introductory and statistical sections have not been subjected to the auditing procedures applied in the audit of
the basic financial statements, and accordingly, we do not express an opinion or provide any assurance on them.
Other Reporting Required by Government Auditing Standards
In accordance with Government Auditing Standards, we have also issued our report dated December 20, 2017,
on our consideration of the City of Somerville, Massachusetts’ internal control over financial reporting and on our
tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements and other
matters. The purpose of that report is to describe the scope of our testing of internal control over financial
reporting and compliance and the results of that testing, and not to provide an opinion on internal control over
financial reporting or on compliance. That report is an integral part of an audit performed in accordance with
Government Auditing Standards in considering the City of Somerville’s internal control over financial reporting and
compliance.
December 20, 2017
City of Somerville, Massachusetts
21
Comprehensive Annual Financial Report
Management’s Discussion and Analysis
Management’s Discussion and Analysis
City of Somerville, Massachusetts
22
Comprehensive Annual Financial Report
Management’s Discussion and Analysis
As management of the City of Somerville, we offer readers of these financial statements this narrative overview
and analysis of the financial activities for the year ended June 30, 2017. We encourage readers to consider the
information presented in this report in conjunction with additional information that we have furnished in our letter
of transmittal.
The Governmental Accounting Standards Board (GASB) is the authoritative standard setting body that provides
guidance on how to prepare financial statements in conformity with generally accepted accounting principles
(GAAP). Users of these financial statements (such as investors and rating agencies) rely on the GASB to
establish consistent reporting standards for all governments in the United States. This consistent application is
the only way users (including citizens, the media, legislators and others) can assess the financial condition of one
government compared to others.
Overview of the Financial Statements
This discussion and analysis is intended to serve as an introduction to the City of Somerville’s basic financial
statements. The City of Somerville’s basic financial statements comprise three components: 1) government-wide
financial statements, 2) fund financial statements, and 3) notes to the financial statements. The approach focuses
on both the City as a whole (government-wide) and the fund financial statements. The government-wide financial
statements provide both long-term and short-term information about the City as a whole. The fund financial
statements focus on the individual parts of the City government, reporting the City’s operations in more detail than
the government-wide statements. Both presentations (government-wide and fund) allow the user to address
relevant questions, broaden the basis of comparison and enhance the City’s accountability. An additional part of
the basic financial statements are the notes to the financial statements. This report also contains other
supplementary information in addition to the basic financial statements themselves.
Government-wide financial statements. The government-wide financial statements are designed to provide
readers with a broad overview of the City of Somerville’s finances, in a manner similar to a private-sector
business. The statements provide both short-term and long-term information about the City’s financial position,
which assists in assessing the City’s economic position at the end of the year. The statements are prepared
using the full accrual basis of accounting. All revenues and expenses connected with the year are considered
even if the cash involved has not been received or disbursed. The government-wide financial statements include
two statements:
The statement of net position presents information on all of the City of Somerville’s assets and deferred outflows
and liabilities and deferred inflows, with the difference between them reported as net position. Over time,
increases or decreases in net position may serve as a useful indicator of whether the financial position of the City
of Somerville is improving or deteriorating.
The statement of activities presents information showing how the government’s net position changed during the
most recent year. All changes in net position are reported as soon as the underlying event giving rise to the
change occurs, regardless of the timing of related cash flows. Thus, revenues and expenses are reported in this
statement for some items that will only result in cash flows in future periods (e.g., uncollected taxes and earned
but unused vacation leave).
Both of the government-wide financial statements distinguish functions of the City of Somerville that are
principally supported by taxes and intergovernmental revenues (governmental activities) from other functions that
are intended to recover all or a significant portion of their costs through user fees and charges (business-type
activities). The governmental activities of the City of Somerville include general government, public safety,
education, public works, community development, human services, community preservation, culture and
City of Somerville, Massachusetts
23
Comprehensive Annual Financial Report
recreation, and interest. The business-type activities include water, sewer, the Veteran’s Memorial Ice Rink and
Dilboy Stadium.
Fund financial statements - A fund is a grouping of related accounts that is used to maintain control over
resources that have been segregated for specific activities or objectives. The City of Somerville, like other state
and local governments, uses fund accounting to ensure and demonstrate compliance with finance-related legal
requirements. All of the funds of the City of Somerville can be divided into three categories: governmental funds,
proprietary funds and fiduciary funds.
Governmental funds - Governmental funds are used to account for essentially the same functions reported as
governmental activities in the government-wide financial statements. However, unlike the government-wide
financial statements, governmental fund financial statements focus on near-term inflows and outflows of
spendable resources, as well as on balances of spendable resources available at the end of the year. Such
information may be useful in evaluating a government’s near-term financing requirements.
Because the focus of governmental funds is narrower than that of the government-wide financial statements, it is
useful to compare the information presented for governmental funds with similar information presented for
governmental activities in the government-wide financial statements. By doing so, readers may better understand
the long-term impact of the government’s near-term financing decisions. Both the governmental fund balance
sheet and the governmental fund statement of revenues, expenditures, and changes in fund balances provide a
reconciliation to facilitate this comparison between governmental funds and governmental activities.
The City of Somerville maintains seventeen individual governmental funds. Information is presented separately
for the general fund, the strategic planning and community development fund and the capital projects fund in the
governmental fund balance sheet and the governmental fund statement of revenues, expenditures, and changes
in fund balances. Data for certain governmental funds are combined into a single aggregated presentation under
the caption nonmajor governmental funds.
The City of Somerville adopts an annual appropriated budget for its general fund. A budget to actual schedule
has been provided as required supplementary information for the general fund to demonstrate compliance with
this budget.
Proprietary funds. Proprietary funds provide the same information shown as business-type activities in the
government wide financial statements, only in more detail. The City uses proprietary funds to account for its
water, sewer, Veteran’s Memorial Ice Rink and Dilboy Stadium operations.
Fiduciary funds. Fiduciary funds are used to account for resources held for the benefit of parties outside the
government. Fiduciary funds are not reflected in the government-wide financial statement because the resources
of those funds are not available to support the City of Somerville’s own programs. The accounting used for
fiduciary funds records transactions using the flow of economic resources measurement focus and the accrual
basis of accounting.
The fiduciary fund financial statements provide information for the pension and Other Postemployment Benefits
trust funds and the private purpose trust funds. All other fiduciary funds are combined into a single, aggregate
presentation in the fiduciary fund financial statements under the caption agency funds.
GASB Statement No. 74, Financial Reporting for Postemployment Benefit Plans Other Than Pensions Plans, was
implemented this year. This standard added Note disclosures and Required Supplemental Information for the
City’s OPEB Trust fund. Its sister standard, GASB Statement No. 75, Accounting and Financial Reporting for
Postemployment benefits Other Than Pensions, is required to be implemented in 2018. This standard will affect
City of Somerville, Massachusetts
24
Comprehensive Annual Financial Report
the financial statements themselves by requiring the City to record its OPEB assets, liabilities, and deferred
financial statement elements for the first time.
The City established an Other Postemployment Benefits Trust Fund (OPEB) to account for funds set aside to help
offset future post-retirement benefits for retirees. These activities are excluded from the City’s government-wide
financial statements because the City cannot use these assets to finance its operations. At year end, the balance
in the OPEB trust fund was $1.8 million.
Notes to the financial statements. The notes provide additional information that is essential to a full
understanding of the data provided in the government-wide and fund financial statements.
Other information. In addition to the basic financial statements and accompanying notes, this report also
presents certain required supplementary information concerning the City of Somerville’s budgetary basis of
accounting and information regarding other postemployment benefits paid by the City. Required supplementary
information can be found after the notes to the financial statements.
Government-wide Financial Analysis
As noted earlier, net position may serve over time as a useful indicator of a government’s financial position. The
City of Somerville’s assets and deferred outflows of resources exceeded liabilities and deferred inflows of
resources by $57.2 million at the close of 2017, which was a decrease of $4.6 million from the prior year.
Net position of $174.4 million reflects its investment in capital assets (e.g., land, buildings, infrastructure,
machinery, and equipment); less any related debt used to acquire those assets that are still outstanding. The City
uses these capital assets to provide services to citizens; consequently, these assets are not available for future
spending. Although the investment in its capital assets is reported net of its related debt, it should be noted that
the resources needed to repay this debt must be provided from other sources, since the capital assets
themselves cannot be used to liquidate these liabilities.
An additional portion of net position, $26.8 million, represents resources that are subject to external restrictions on
how they may be used. The remaining balance of unrestricted net position has a year-end deficit of $144.0
million. The primary reason for this deficit balance is the recognition of the Pension and OPEB liabilities.
At year-end, the City is able to report positive balances in two of three categories of net position, for the City as a
whole and for its governmental activities. Its business-type activities report positive balances in both applicable
categories.
The governmental activity and business-type activity components are presented on the following pages.
As noted earlier, net position may serve over time as a useful indicator of a government’s financial position. In the
case of the City of Somerville, governmental liabilities and deferred inflows of resources exceeded assets and
deferred outflows of resources by $11.1 million and the business-type assets and deferred outflows of resources
exceeded liabilities and deferred inflows of resources by $68.3 million at the close of the most recent year.
Governmental Activities
The City of Somerville’s liabilities and deferred inflows of resources exceeded assets and deferred outflows of
resources by $11.1 million at the close of 2017.
City of Somerville, Massachusetts
25
Comprehensive Annual Financial Report
2017
2016
Assets
Current assets…………………………………………
$
152,104,713
$
130,004,820
Noncurrent assets (excluding capital)………………
3,517,440
6,015,394
Capital assets…………………………………………
232,316,828
227,538,281
Total assets…………………………………………
387,938,981
363,558,495
Deferred Outflows of Resources
Deferred outflows related to pensions………………
22,591,390
17,851,554
Deferred charges on refunding………………………
338,362
459,437
Total deferred outflows…………………………
22,929,752
18,310,991
Liabilities
Current liabilities (excluding debt)……………………
9,443,777
10,119,384
Noncurrent liabilities (excluding debt)………………
269,713,756
251,672,579
Current debt……………………………………………
46,653,925
33,661,197
Noncurrent debt………………………………………
93,812,752
86,118,168
Total liabilities……………………………………
419,624,210
381,571,328
Deferred Inflows of Resources
Deferred inflows related to pensions…………………
2,357,303
48,336
Net Position
Net investment in capital assets………………………
128,346,108
130,183,221
Restricted………………………………………………
26,765,236
26,765,034
Unrestricted……………………………………………
(166,224,124)
(156,698,433)
Total net position…………………………………
$
(11,112,780)
$
249,822
The largest portion of the City of Somerville’s net position, $128.3 million, reflects its investment in capital assets
(e.g., land, buildings, machinery, and equipment) less any related debt used to acquire those assets that is still
outstanding. The City uses these capital assets to provide services to its citizens; consequently, these assets are
not available for future spending. Although the City of Somerville’s investment in its capital assets is reported net
of related debt, it should be noted that resources needed to repay this debt must be provided from other sources,
since the capital assets themselves cannot be used to liquidate these liabilities.
An additional portion of the City of Somerville’s net position, $26.8 million, represents resources that are subject
to external restrictions on how they may be used. These include funds for street improvement (Chapter 90),
community development projects to be funded by future federal reimbursements, outstanding loan balance
authorized under various housing and urban development federal grants, expendable and nonexpendable funds
and grants and gifts.
The City has $98.9 million of positive unrestricted net position excluding the recorded liabilities for the other
postemployment benefits obligation and the net pension liability which is in a deficit balance. Those liabilities
($126.6 million for OPEB and $138.5 million net pension liability) are long-term in nature, and will not be funded
from the $166.2 million deficit of unrestricted net position at June 30, 2017. The City began the process of pre-
funding a portion of the OPEB liability in 2013 by establishing an irrevocable trust which, as of June 30, 2017, has
a balance of $1.8 million and is reported within the Fiduciary Funds in the City’s financial statements.
Included within the noncurrent assets (excluding capital) is $3.5 million in future school construction
reimbursement grants.
City of Somerville, Massachusetts
26
Comprehensive Annual Financial Report
Long-term liabilities include $93.8 million in general obligation bonds; $3.6 million in compensated absence
liabilities for unused vacation, special leave, and enhanced longevity benefits payable; $1.0 million in future year
workers’ compensation benefits payable; $138.5 million in future pension benefits; and $126.6 million in future
other postemployment benefits.
Governmental activities net position decreased by $11.4 million in 2017.
2017
2016
Program Revenues
Charges for services…………………………………
$
26,958,884
$
23,373,674
Operating grants and contributions…………………
59,892,628
52,059,008
Capital grants and contributions………………………
2,039,456
4,302,653
General Revenues
Real estate and personal property taxes……………
135,251,425
127,658,573
Tax liens……………………………………………….
201,283
297,772
Motor vehicle and other excise taxes………………
9,316,095
9,288,744
Penalties and interest on taxes………………………
729,944
801,173
Payments in lieu of taxes………………………….
1,248,682
829,780
Community preservation taxes………………………
1,664,815
1,546,198
Nonrestricted grants and contributions………………
25,455,469
24,429,136
Unrestricted investment income………………………
496,273
303,517
Gain on sale of capital assets………………………
2,031,564
-
Miscellaneous revenues………………………………
184,008
308,206
Total revenues……………………………………
265,470,526
245,198,434
Expenses
General government…………………………………
34,076,945
32,270,976
Public safety……………………………………………
58,162,944
54,345,466
Education………………………………………………
132,958,254
124,740,381
Public works……………………………………………
31,017,581
28,957,827
Community development……………………………
9,696,020
5,177,605
Human services………………………………………
244,417
178,570
Community Preservation……………………………
1,522,282
347,016
Culture and recreation………………………………
5,245,975
4,787,187
Interest…………………………………………………
3,563,654
2,956,192
Total expenses……………………………………
276,488,072
253,761,220
Excess (Deficiency) before transfers…………………
(11,017,546)
(8,562,786)
Transfers…………………………………………………
(345,056)
948,090
Change in net position…………………………………
(11,362,602)
(7,614,696)
Net position at beginning of year……………………
249,822
7,864,518
Net position at end of year……………………………
$
(11,112,780)
$
249,822
The primary reasons for the $11.4 million decrease relate to the $12.5 million and $5.6 million increases in the
City’s OPEB liability and net pension liability, offset by a net increase of $2.6 million in deferred outflows and
deferred inflows of resources related to pensions, and the recognition of $2.0 million of capital grants.
City of Somerville, Massachusetts
27
Comprehensive Annual Financial Report
Real estate tax revenue increased $7.6 million due to new tax base growth and the proposition 2 ½ budgetary
increase.
General government expenses increased by $1.8 million which was primarily the result of increases in overall
budgeted operational and payroll costs. Education expenses increased by $8.2 million, this increase is due to an
increase in on-behalf payments associated with the Massachusetts Teachers’ Retirement System, as well as an
increase in the School’s operating budget. Public works expenses increased by $2.1 million, this increase relates
directly to an increase in snow and ice removal costs and other operational costs of the Department. Community
Development expenses increased $4.5 million as a result of increased activity in the various loan programs and
other program related costs.
Business-type Activities
The following summarizes the key financial components of the City’s Business-type Activities:
2017
2016
Assets
Current assets…………………………………………
$
32,705,597
$
23,164,206
Capital assets……………………………………………
56,750,067
53,069,746
Total assets…………………………………………
89,455,664
76,233,952
Deferred Outflows of Resources
Deferred outflows related to pensions………………
278,430
185,229
Liabilities
Current liabilities (excluding debt)……………………
271,664
1,940,807
Noncurrent liabilities (excluding debt)…………………
2,151,817
2,457,645
Current debt……………………………………………
10,802,790
2,203,383
Noncurrent debt…………………………………………
8,147,921
8,290,711
Total liabilities………………………………………
21,374,192
14,892,546
Deferred Inflows of Resources
Deferred inflows related to pensions…………………
29,053
501
Net Position
Net investment in capital assets………………………
46,081,442
43,810,782
Unrestricted………………………………………………
22,249,407
17,715,352
Total net position…………………………………
$
68,330,849
$
61,526,134
Business-type net position of $46.1 million represents investments in capital assets net of related debt. The
remaining $22.2 million is available to be used for the ongoing operation of the City’s water, Veteran’s Memorial
Ice Rink, Dilboy Stadium, and sewer activities. There was an overall increase of $6.8 million in net position
reported in connection with the enterprise funds.
City of Somerville, Massachusetts
28
Comprehensive Annual Financial Report
2017
2016
Program Revenues
Charges for services……………………………………
$
36,406,067
$
33,413,924
General Revenues
Unrestricted investment income………………………
160,353
142,354
Total revenues………………………………………
36,566,420
33,556,278
Expenses
Water……………………………………………………
11,166,299
10,211,295
Sewer……………………………………………………
18,106,483
17,099,159
Veteran's Memorial Ice Rink…………………………
679,098
721,990
Dilboy Stadium………………………………………..
154,881
136,199
Total expenses……………………………………
30,106,761
28,168,643
Excess (Deficiency) before transfers…………………
6,459,659
5,387,635
Transfers……………………………………………………
345,056
(948,090)
Change in net position……………………………………
6,804,715
4,439,545
Net position at beginning of year………………………
61,526,134
57,086,589
Net position at end of year………………………………
$
68,330,849
$
61,526,134
The water enterprise fund net position increased $2.6 million. This is primarily due to an increase in water rates
coupled with an increase in consumption which led to an increase in related revenue, the fact that principal
payments on debt exceed depreciation on capital assets and the funds ability to maintain a minimal increase in
overall operating costs.
The sewer enterprise fund net position increased by $4.0 million. This is primarily due to an increase in sewer
rates, the fact that principal payments on debt exceeded depreciation on capital assets and the funds ability to
maintain a minimal increase in overall operating costs.
The Veterans Memorial Ice Rink enterprise fund net position increased by $107 thousand. This is the result of an
operational subsidy from the general fund and the fact that user fee revenues decreased.
The Dilboy Stadium enterprise fund net position increased by $45 thousand. This is primarily the way this fund is
designed to operate. User fees are designed to cover operational and capital related costs of operations.
Financial Analysis of the Government’s Funds
As noted earlier, the City of Somerville uses fund accounting to ensure and demonstrate compliance with finance-
related legal requirements.
Governmental funds. The focus of the City of Somerville’s governmental funds is to provide information on
near-term inflows, outflows, and balances of spendable resources. Such information is useful in assessing the
City of Somerville’s financing requirements. In particular, unassigned fund balance may serve as a useful
measure of a government’s net resources available for spending at the end of the year.
At the end of the current year, the City of Somerville’s governmental funds combined ending balances totaled
$90.0 million, of which positive balances of $60.6 million was reported in the general fund, $14.3 million in the
Strategic Planning and Community Development fund, and $26.5 million in the nonmajor governmental funds.
City of Somerville, Massachusetts
29
Comprehensive Annual Financial Report
The capital projects fund reported a deficit of $11.4 million. Cumulatively, there was an increase in the
governmental funds of $13.3 million in fund balance from prior year. This is due to $39.0 million of BAN’s
outstanding at year end.
The general fund is the chief operating fund of the City of Somerville. At the end of the current year unassigned
fund balance of the general fund totaled $20.2 million and was comprised of two components: an unreserved fund
balance of $16.1 million and a rainy day stabilization fund of $4.1 million. Assigned fund balance, which
represents amounts, designated for the 2018 budget, and amounts that have been reserved for the use of
liquidating prior purchase orders, contracts, and ongoing capital articles, totaled $5.9 million. Committed fund
balance, which represents the City’s various use-specific stabilization funds and the health claims trust, totaled
$34.5 million. As a measure of the general fund’s liquidity, it may be useful to compare both unassigned fund
balance and total fund balance to total expenditures. At year-end unassigned fund balance equaled 8.8% of total
general fund expenditures, while total fund balance equaled 26.1% of the same amount. Please see Note 9 for
further details.
The City’s general fund increased $6 million in the current year. The change was primarily due to positive
budgetary results, and increase in the accrual for 60 day receipts, a decrease in the accrual for Appellate Tax
Board cases due to the various tele-com cases being settled, and the receipt of a $952 thousand bond premium.
The City’s Strategic Planning and Community Development fund balance increased by $451 thousand. The fund
operates on a grant drawdown basis and the results of operations are primarily the result of the timing of the
expenditure of grant allotments.
The City’s capital projects funds increased by $3.5 million. The increase is due to the net effect of $11.8 million of
capital expenditures on current and prior year’s projects offset by the issuance of $12.3 million in bonds and the
receipt of a $1.4 million bond premium.
General Fund Budgetary Highlights
There was an $8 million increase between the original budget and the final amended budget. The increase was
primarily attributable to transfers to various stabilization funds and the net of other increases/decreases in various
departmental budgets.
Capital Asset and Debt Administration
Capital assets. The City of Somerville’s investment in capital assets for its governmental activities as of June 30,
2017, amounts to $232.3 million (net of accumulated depreciation) and its business-type activities amounted to
$56.5 million (net of accumulated depreciation). This investment in capital assets includes land, construction in
progress, land improvements, books and periodicals, buildings and improvements, machinery and equipment,
vehicles, and infrastructure. The net increase in the City’s investment in capital assets for the current year
governmental assets was $4.8 million and business-type assets was $3.4 million.
Major capital asset events during the year included the following:
•
Investments made to improve and expand the buildings of the School department;
•
Land improvements to various City parks;
•
A variety of infrastructure investments in the street, sidewalk, water and sewer systems and;
•
Various departmental vehicle and equipment acquisitions.
City of Somerville, Massachusetts
30
Comprehensive Annual Financial Report
In conjunction with the operating budget, the City annually prepares a capital budget for the upcoming year and a
five-year Capital Improvement Plan (CIP) that is used as a guide for future capital expenditures.
Additional information on the City’s capital assets may be found in Note 4 to the financial statements.
Long-term debt. At the end of the current year, the City of Somerville had total governmental bonded debt
outstanding of $96.7 million. Additionally, the City reported governmental short-term borrowing of $39.0 million
related to the High School Construction, the Union Square Revitalization Plan, road reconstruction and
improvement projects, various school projects, and various other projects around the City.
During 2017, the City’s governmental long-term debt increased $4.9 million. This change is due to the net effect
of the current year issuance of Municipal Purpose bonds for various governmental projects offset by principal
payments during the year.
The sewer, water and rink enterprise funds have outstanding long-term debt totaling $1.5 million, $6.4 million, and
$2.1 million, respectfully, at year end. Other than the Rink, all enterprise fund debt is fully supported by the rates
and does not rely on a general fund subsidy.
Standard & Poor’s have assigned a rating of AA+ and Moody’s have assigned a rating of Aa1 to the City’s bonds.
The Commonwealth of Massachusetts is obligated to provide school construction grants for approved school
projects. The grants are paid annually to support future interest expense on school construction related long-term
debt and the construction costs funded by that debt. At June 30, 2017, the City is scheduled to receive $1.7
million of future interest grants and $6.7 million of capital grants. The payment schedule for the Commonwealth is
structured to match the debt service expenditures.
Beginning in 2005, the Commonwealth changed the method for funding the school building assistance program.
Under the new program, the assistance is paid to support construction costs and reduce the total debt service of
the City. Through the end of 2017, the City has recorded capital grant proceeds totaling $3.6 million, from the
MSBA, related to the Somerville High School project, which is equal to 75.29% of approved construction costs
submitted for reimbursement. The City anticipates receiving an additional $1.5 million of grant proceeds in 2018.
See Notes 7 & 8 for further debt information.
Economic Factors and Next Year’s Budgets and Rates
•
According to the U.S. Census Bureau, the median household income of the City for the period 2012 –
2016, was $78,673 compared with $70,954 for the Commonwealth and $55,322 for the nation. The per
capita income was $36,229, compared with $36,441 for the Commonwealth and $28,555 for the nation.
•
The unemployment rate for the City of Somerville as of October 2017 is approximately 2.2%, which is a
.3% year-over-year increase from a rate of 1.9% in August 2016. This compares favorably to the state’s
average seasonally-adjusted unemployment rate of 3.3% and the national average of 4.1%.
•
According to the City’s Board of Assessors, for 2017, the average single family parcel in the City is valued
at $633,000; the average two-family home is valued at $683,000; the average 2017 commercial and
industrial property is valued at $1,672,000. All compared favorably with state and national property
values.
City of Somerville, Massachusetts
31
Comprehensive Annual Financial Report
Requests for Information
This financial report is designed to provide a general overview of the City of Somerville’s finances for all those
with an interest in the government’s finances. Questions concerning any of the information provided in this report
or requests for additional financial information should be addressed to the Director of Finance, City Hall, 93
Highland Ave, Somerville, Massachusetts 02143.
City of Somerville, Massachusetts
32
Comprehensive Annual Financial Report
Basic Financial Statements
Basic Financial Statements
STATEMENT OF NET POSITION
JUNE 30, 2017
Governmental
Business-type
Activities
Activities
Total
ASSETS
CURRENT:
Cash and cash equivalents…………………………………
$
117,847,627
$
21,288,396
$
139,136,023
Receivables, net of allowance for uncollectibles:
Real estate and personal property taxes………………
1,795,183
-
1,795,183
Tax liens……………………………………………………
851,508
-
851,508
Motor vehicle excise tax…………………………………
176,902
-
176,902
User fees……………………………………………………
-
11,417,201
11,417,201
Departmental and other……………………………………
3,087,757
-
3,087,757
Intergovernmental…………………………………………
10,020,323
-
10,020,323
Loans………………………………………………………
18,325,413
-
18,325,413
Total current assets………………………………………
152,104,713
32,705,597
184,810,310
NONCURRENT:
Receivables, net of allowance for uncollectibles:
Intergovernmental…………………………………………
3,517,440
-
3,517,440
Other postemployment benefits asset………………………
-
297,281
297,281
Capital assets, net of accumulated depreciation:
Nondepreciable……………………………………………
53,391,868
22,244
53,414,112
Depreciable…………………………………………………
178,924,960
56,430,542
235,355,502
Total noncurrent assets……………………………………
235,834,268
56,750,067
292,584,335
TOTAL ASSETS…………………………………………………
387,938,981
89,455,664
477,394,645
DEFERRED OUTFLOWS OF RESOURCES
Deferred outflows related to pensions………………………
22,591,390
278,430
22,869,820
Deferred charges on refunding………………………………
338,362
-
338,362
Total deferred outflows of resources……………………
22,929,752
278,430
23,208,182
LIABILITIES
CURRENT:
Warrants payable………………………………………………
3,953,868
157,366
4,111,234
Accrued payroll…………………………………………………
1,857,337
46,968
1,904,305
Tax refunds payable…………………………………………
862,000
-
862,000
Accrued interest………………………………………………
863,400
65,630
929,030
Payroll withholdings……………………………………………
1,033,916
-
1,033,916
Abandoned property…………………………………………
374,997
-
374,997
Compensated absences………………………………………
159,509
1,700
161,209
Workers' compensation………………………………………
338,750
-
338,750
Notes payable…………………………………………………
39,043,332
9,000,000
48,043,332
Bonds payable…………………………………………………
7,610,593
1,802,790
9,413,383
Total current liabilities…………………………..…………
56,097,702
11,074,454
67,172,156
NONCURRENT:
Compensated absences………………………………………
3,604,691
61,800
3,666,491
Workers' compensation………………………………………
1,016,250
-
1,016,250
Other postemployment benefits………………………………
126,632,887
383,554
127,016,441
Net pension liability……………………………………………
138,459,928
1,706,463
140,166,391
Bonds payable…………………………………………………
93,812,752
8,147,921
101,960,673
Total noncurrent liabilities…………………………...……
363,526,508
10,299,738
373,826,246
TOTAL LIABILITIES………………………………………………
419,624,210
21,374,192
440,998,402
DEFERRED INFLOWS OF RESOURCES
Deferred inflows related to pensions…………………………
2,357,303
29,053
2,386,356
NET POSITION
Net investment in capital assets…………………………………
128,346,108
46,081,442
174,427,550
Restricted for:
Streets………..…………………………………………………
3,205,981
-
3,205,981
Community Development……………………………………
1,148,368
-
1,148,368
Loans……………………………………………………………
18,325,413
-
18,325,413
Permanent funds:
Expendable……….…………………………………………
159,213
-
159,213
Nonexpendable……………………………………………
433,126
-
433,126
Other specific purposes………………………………………
3,493,135
-
3,493,135
Unrestricted…………………………………………………………
(166,224,124)
22,249,407
(143,974,717)
TOTAL NET POSITION…………………………………………
$
(11,112,780)
$
68,330,849
$
57,218,069
See notes to basic financial statements.
Government
Primary
City of Somerville, Massachusetts
33
Comprehensive Annual Financial Report
STATEMENT OF ACTIVITIES
YEAR ENDED JUNE 30, 2017
Operating
Capital
Charges for
Grants and
Grants and
Net (Expense)
Functions/Programs
Expenses
Services
Contributions
Contributions
Revenue
Primary Government:
Governmental Activities:
General government…………………… $
34,076,945
$
10,828,065
$
3,611,794
$
-
$
(19,637,086)
Public safety………………………………
58,162,944
11,648,005
567,768
-
(45,947,171)
Education…………………………………
132,958,254
3,251,770
46,466,462
1,598,709
(81,641,313)
Public works..........................................
31,017,581
496,483
2,059,979
70,282
(28,390,837)
Community development………………
9,696,020
-
6,297,670
-
(3,398,350)
Human services…………………………
244,417
330,971
224,806
-
311,360
Community Preservation………………
1,522,282
-
4,630
370,465
(1,147,187)
Culture and recreation……………………
5,245,975
403,590
107,536
-
(4,734,849)
Interest……………………………………
3,563,654
-
551,983
-
(3,011,671)
Total Governmental Activities………
276,488,072
26,958,884
59,892,628
2,039,456
(187,597,104)
Business-Type Activities:
Water ……………………………………
11,166,299
13,945,725
-
-
2,779,426
Sewer………………………………………
18,106,483
21,673,233
-
-
3,566,750
Veteran's Memorial Ice Rink……………
679,098
587,035
-
-
(92,063)
Dilboy Stadium……………………………
154,881
200,074
-
-
45,193
Total Business-Type Activities………
30,106,761
36,406,067
-
-
6,299,306
Total Primary Government……………$
306,594,833
$
63,364,951
$
59,892,628
$
2,039,456
$
(181,297,798)
See notes to basic financial statements.
(Continued)
Program Revenues
City of Somerville, Massachusetts
34
Comprehensive Annual Financial Report
STATEMENT OF ACTIVITIES (Continued)
YEAR ENDED JUNE 30, 2017
Governmental
Business-Type
Activities
Activities
Total
Changes in net position:
Net (expense) revenue from previous page…………………………$
(187,597,104)
$
6,299,306
$
(181,297,798)
General revenues:
Real estate and personal property taxes,
net of tax refunds payable………………………………………
135,251,425
-
135,251,425
Tax and utility liens…………………………………………………
201,283
-
201,283
Motor vehicle and other excise taxes……………………………
9,316,095
-
9,316,095
Penalties and interest on taxes……………………………………
729,944
-
729,944
Payments in lieu of taxes…………………………………………
1,248,682
-
1,248,682
Community preservation taxes……………………………………
1,664,815
-
1,664,815
Grants and contributions not restricted to
specific programs…………………………………………………
25,455,469
-
25,455,469
Unrestricted investment income…………………………………
496,273
160,353
656,626
Gain (Loss) on disposal of capital assets…………………………
2,031,564
-
2,031,564
Miscellaneous………………………………………………………
184,008
-
184,008
Transfers, net ……………………………………………………………
(345,056)
345,056
-
Total general revenues and transfers…………………………………
176,234,502
505,409
176,739,911
Change in net position……………………………………………
(11,362,602)
6,804,715
(4,557,887)
Net Position
Beginning of year…………………………………………………
249,822
61,526,134
61,775,956
End of year……………………………………………………………$
(11,112,780)
$
68,330,849
$
57,218,069
See notes to basic financial statements.
(Concluded)
Government
Primary
City of Somerville, Massachusetts
35
Comprehensive Annual Financial Report
GOVERNMENTAL FUNDS
BALANCE SHEET
JUNE 30, 2017
Strategic
Planning &
Capital
Nonmajor
Total
Community
Projects
Governmental
Governmental
General
Development
Fund
Funds
Funds
ASSETS
Cash and cash equivalents…………………………………… $
67,674,601
$
-
$
27,658,970
$
22,514,056
$
117,847,627
Receivables, net of uncollectibles:
Real estate and personal property taxes…………………
1,795,183
-
-
-
1,795,183
Tax liens………………………………………………………
851,508
-
-
-
851,508
Motor vehicle excise taxes…………………………………
176,902
-
-
-
176,902
Departmental and other……………………………………
3,061,585
-
-
26,172
3,087,757
Intergovernmental……………………………………………
8,498,625
1,148,368
-
3,890,770
13,537,763
Loans…………………………………………………………
-
15,335,829
-
2,989,584
18,325,413
Due from other funds……………………………………………
-
-
-
1,371,806
1,371,806
TOTAL ASSETS…………………………………………………$
82,058,404
$
16,484,197
$
27,658,970
$
30,792,388
$
156,993,959
LIABILITIES
Warrants payable…………………………………………… $
3,832,741
$
-
$
-
$
121,127
$
3,953,868
Accrued payroll………………………………………………
1,585,313
13,343
652
258,029
1,857,337
Tax refunds payable…………………………………………
862,000
-
-
-
862,000
Payroll withholdings…………………………………………
1,033,916
-
-
-
1,033,916
Abandoned property…………………………………………
374,997
-
-
-
374,997
Due to other funds……………………………………………
-
1,057,482
-
314,324
1,371,806
Notes payable………………………………………………
-
-
39,043,332
-
39,043,332
TOTAL LIABILITIES……………………………………………
7,688,967
1,070,825
39,043,984
693,480
48,497,256
DEFERRED INFLOWS OF RESOURCES
Unavailable revenue…………………………………………
13,733,570
1,148,368
-
3,602,618
18,484,556
FUND BALANCES
Nonspendable………………………………………………
-
-
-
433,126
433,126
Restricted……………………………………………………
-
14,265,004
-
26,063,164
40,328,168
Committed……………………………………………………
34,533,997
-
-
-
34,533,997
Assigned………………………………………………………
5,907,817
-
-
-
5,907,817
Unassigned……………………………………………………
20,194,053
-
(11,385,014)
-
8,809,039
TOTAL FUND BALANCES……………………………………
60,635,867
14,265,004
(11,385,014)
26,496,290
90,012,147
TOTAL LIABILITIES, DEFERRED INFLOWS OF
RESOURCES, AND FUND BALANCES………………… $
82,058,404
$
16,484,197
$
27,658,970
$
30,792,388
$
156,993,959
See notes to basic financial statements.
City of Somerville, Massachusetts
36
Comprehensive Annual Financial Report
RECONCILIATION OF THE GOVERNMENTAL FUNDS BALANCE SHEET
TOTAL FUND BALANCES TO THE STATEMENT OF NET POSITION
YEAR ENDED JUNE 30, 2017
Total governmental fund balances………………………………………………………………………………
$
90,012,147
Capital assets (net) used in governmental activities are not financial resources
and, therefore, are not reported in the funds………………………………………………………………
232,316,828
Accounts receivable are not available to pay for current-period
expenditures and, therefore, are unavailable in the funds………………………………………………
18,484,556
Certain changes in the net pension liability are required to be included in pension
expense over future periods. These changes are reported as deferred outflows of
resources or (deferred inflows of resources) related to pensions…………………………………..
20,234,087
In the statement of activities, interest is accrued on outstanding long-term debt,
whereas in governmental funds interest is not reported until due………………………………………
(863,400)
Long-term liabilities are not due and payable in the current period and, therefore,
are not reported in the governmental funds:
Bonds payable………………………………………………………………………………………………
(101,423,345)
Workers compensation……………………………………………………………………………………
(1,355,000)
Compensated absences……………………………………………………………………………………
(3,764,200)
Other postemployment benefits……………………………………………………………………………
(126,632,887)
Net pension liability…………………………………………………………………………………………
(138,459,928)
Net effect of reporting long-term liabilities…………………………………………………………
(371,635,360)
In the statement of activities, deferred charges on refunding are reported
as a deferred outflow of resources and are amortized over the shorter of the remaining
life of the refunding bonds or refunded bonds. In governmental funds, these changes
are expensed when the refunding bonds are issued………………………………………………………
338,362
Net position of governmental activities……………………………………………………………………………
$
(11,112,780)
See notes to basic financial statements.
City of Somerville, Massachusetts
37
Comprehensive Annual Financial Report
GOVERNMENTAL FUNDS
STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES
YEAR ENDED JUNE 30, 2017
Strategic
Planning &
Capital
Nonmajor
Total
Community
Projects
Governmental
Governmental
General
Development
Fund
Funds
Funds
REVENUES:
Real estate and personal property taxes,
net of tax refunds…………………………………………………………… $
134,759,721
$
-
$
-
$
-
$
134,759,721
Tax liens……….…………………………………………………………………
392,962
-
-
-
392,962
Motor vehicle and other excise taxes…………………………………………
9,297,090
-
-
-
9,297,090
Payments in lieu of taxes………………………………………………………
1,248,682
-
-
-
1,248,682
Intergovernmental………………………………………………………………
65,262,079
10,138,587
803,627
15,057,356
91,261,649
Departmental and other…………………………………………………………
20,835,081
-
404,376
7,999,205
29,238,662
Community preservation taxes…………………………………………………
-
-
-
2,085,496
2,085,496
Contributions………………………………………………………………………
380,501
-
-
240,887
621,388
Investment income………………………………………………………………
457,948
8,383
-
34,579
500,910
Miscellaneous……………………………………………………………………
134,582
-
-
-
134,582
TOTAL REVENUES………………………………………………………
232,768,646
10,146,970
1,208,003
25,417,523
269,541,142
EXPENDITURES:
Current:
General government…………………………………………………………
19,167,204
-
2,265,584
2,423,943
23,856,731
Public safety…………………………………………………………………
40,492,885
-
-
757,248
41,250,133
Education………………………………………………………………………
65,062,143
-
3,313,819
14,070,437
82,446,399
Public works……………………………………………………………………
24,698,789
-
1,937,858
1,849,197
28,485,844
Community development……………………………………………………
-
9,696,020
-
-
9,696,020
Human services………………………………………………………………
-
-
-
244,417
244,417
Culture and recreation………………………………………………………
3,057,850
-
4,331,985
207,596
7,597,431
Pension benefits………………………………………………………………
28,429,418
-
-
-
28,429,418
Employee benefits……………………………………………………………
24,274,992
-
-
-
24,274,992
Claims and judgments………………………………………………………
53,800
-
-
-
53,800
Community preservation……………………………………………………
-
-
-
2,314,179
2,314,179
State and county charges………………………………………………………
13,532,201
-
-
-
13,532,201
Debt service:
Principal………………………………………………………………………
7,455,123
-
-
-
7,455,123
Interest…………………………………………………………………………
3,639,566
-
-
-
3,639,566
TOTAL EXPENDITURES…………………………………………………
229,863,971
9,696,020
11,849,246
21,867,017
273,276,254
EXCESS (DEFICIENCY) OF REVENUES
OVER (UNDER) EXPENDITURES……………………………………………
2,904,675
450,950
(10,641,243)
3,550,506
(3,735,112)
OTHER FINANCING SOURCES (USES):
Issuance of debt…………………………………………………………………
-
-
12,335,000
-
12,335,000
Premium from issuance of bonds………………………………………………
952,000
-
1,419,349
598,829
2,970,178
Sale of capital assets……………………………………………………………
-
-
-
2,120,152
2,120,152
Transfers in………………………………………………………………………
4,631,838
-
397,551
507,531
5,536,920
Transfers out………………………………………………………………………
(2,537,535)
-
-
(3,344,441)
(5,881,976)
TOTAL OTHER FINANCING SOURCES (USES)……………………
3,046,303
-
14,151,900
(117,929)
17,080,274
NET CHANGE IN FUND BALANCES……………………………………………
5,950,978
450,950
3,510,657
3,432,577
13,345,162
FUND BALANCES AT BEGINNING OF YEAR…………………………………
54,684,889
13,814,054
(14,895,671)
23,063,713
76,666,985
FUND BALANCES AT END OF YEAR……………………………………………$
60,635,867
$
14,265,004
$
(11,385,014)
$
26,496,290
$
90,012,147
See notes to basic financial statements.
City of Somerville, Massachusetts
38
Comprehensive Annual Financial Report
RECONCILIATION OF THE STATEMENT OF REVENUES, EXPENDITURES,
AND CHANGES IN FUND BALANCES OF GOVERNMENTAL FUNDS
TO THE STATEMENT OF ACTIVITIES
YEAR ENDED JUNE 30, 2017
Net change in fund balances - total governmental funds……………………………………………………
$
13,345,162
Governmental funds report capital outlays as expenditures. However, in the
Statement of Activities the cost of those assets is allocated over their
estimated useful lives and reported as depreciation expense.
Capital outlay……………………………………………………………………………………………
13,805,058
Depreciation expense…………………………………………………………………………………
(8,937,922)
Net effect of reporting capital assets…………………………………………………………
4,867,136
In the Statement of Activities, only the gain on the sale of capital assets is reported,
whereas in the governmental funds the entire proceeds of the sale are reported
as financial resources. As a result, the change in net position differs from the
change in fund balance by the book value of the capital assets sold…………………………………
(88,589)
Revenues in the Statement of Activities that do not provide current financial
resources are unavailable in the Statement of Revenues, Expenditures and
Changes in Fund Balances. Therefore, the recognition of revenue for various
types of accounts receivable (i.e., real estate and personal property, motor
vehicle excise, etc.) differ between the two statements. This amount represents
the net change in unavailable revenue…………………………………………………………………
(6,102,179)
The issuance of long-term debt (e.g., bonds and leases) provides current financial
resources to governmental funds, while the repayment of the principal of long-
term debt consumes the financial resources of governmental funds. Neither
transaction, however, has any effect on net position. Also, governmental funds
report the effect of premiums, discounts, and similar items when debt is
first issued, whereas these amounts are deferred and amortized in the
Statement of Activities.
Issuance of debt…………………………………………………………………………………………
(12,335,000)
Premium from issuance of bonds……………………………………………………………………
(2,970,178)
Debt service principal payments………………………………………………………………………
7,455,123
Amortization of bond premiums………………………………………………………………………
177,075
Amortization of deferred charge on refunding………………………………………………………
(121,075)
Net effect of reporting long-term debt…………………………………………………………
(7,794,055)
Some expenses reported in the Statement of Activities do not require the use of
current financial resources and, therefore, are not reported as expenditures
in the governmental funds.
Net change in compensated absences accrual……………………………………………………
128,500
Net change in accrued interest on long-term debt…………………………………………………
19,911
Net change in workers' compensation accrual………………………………………………………
(91,000)
Net change in postemployment benefits liability……………………………………………………
(12,515,275)
Net change in deferred (inflow) of resources related to pensions…………………………………
(2,308,967)
Net change in deferred outflow of resources related to pensions…………………………………
4,739,836
Net change in net pension liability……………………………………………………………………
(5,563,082)
Net effect of recording long-term liabilities…………………………….……………………
(15,590,077)
Change in net position of governmental activities………………………………………………………………
$
(11,362,602)
See notes to basic financial statements.
City of Somerville, Massachusetts
39
Comprehensive Annual Financial Report
PROPRIETARY FUNDS
STATEMENT OF NET POSITION
JUNE 30, 2017
Business-Type Activities - Enterprise Funds
Veterans
Memorial
Dilboy
Water
Sewer
Ice Rink
Stadium
Total
ASSETS
CURRENT:
Cash and cash equivalents…………………………………$
9,853,049
$
11,150,440
$
96,554
$
188,353
$
21,288,396
Receivables, net of allowance for uncollectibles:
User fees…………………………………………………
4,252,054
7,165,147
-
-
11,417,201
Total current assets…………………………………
14,105,103
18,315,587
96,554
188,353
32,705,597
NONCURRENT:
Other postemployment benefits asset……………………
-
297,281
-
-
297,281
Capital assets, non depreciable……………………………
-
22,244
-
-
22,244
Capital assets, net of accumulated depreciation…………
31,394,277
21,986,873
3,049,392
-
56,430,542
Total noncurrent assets………………………………
31,394,277
22,306,398
3,049,392
-
56,750,067
TOTAL ASSETS…………………………………………………
45,499,380
40,621,985
3,145,946
188,353
89,455,664
DEFERRED OUTFLOWS OF RESOURCES
Deferred outflows related to pensions……………………
198,764
79,666
-
-
278,430
LIABILITIES
CURRENT:
Warrants payable……………………………………………
20,230
137,107
29
-
157,366
Accrued payroll………………………………………………
27,326
12,991
3,475
3,176
46,968
Accrued interest……………………………………………
26,338
17,504
21,788
-
65,630
Compensated absences……………………………………
1,600
100
-
-
1,700
Notes payable………………………………………………
3,800,000
5,200,000
-
-
9,000,000
Bonds payable………………………………………………
1,302,739
305,051
195,000
-
1,802,790
Total current liabilities………………………………
5,178,233
5,672,753
220,292
3,176
11,074,454
NONCURRENT:
Compensated absences……………………………………
47,100
14,700
-
-
61,800
Other postemployment benefits……………………………
383,554
-
-
-
383,554
Net pension liability…………………………………………
1,218,198
488,265
-
-
1,706,463
Bonds payable………………………………………………
5,062,870
1,175,051
1,910,000
-
8,147,921
Total noncurrent liabilities……………………………
6,711,722
1,678,016
1,910,000
-
10,299,738
TOTAL LIABILITIES……………………………………………
11,889,955
7,350,769
2,130,292
3,176
21,374,192
DEFERRED INFLOWS OF RESOURCES
Deferred inflows related to pensions………………………
20,740
8,313
-
-
29,053
NET POSITION
Net investment in capital assets………………………………
25,192,328
19,944,722
944,392
-
46,081,442
Unrestricted………………………………………………………
8,595,121
13,397,847
71,262
185,177
22,249,407
TOTAL NET POSITION…………………………………………$
33,787,449
$
33,342,569
$
1,015,654
$
185,177
$
68,330,849
See notes to basic financial statements.
City of Somerville, Massachusetts
40
Comprehensive Annual Financial Report
PROPRIETARY FUNDS
STATEMENT OF REVENUES, EXPENSES AND CHANGES IN NET POSITION
YEAR ENDED JUNE 30, 2017
Business-Type Activities - Enterprise Funds
Veterans
Memorial
Dilboy
Water
Sewer
Ice Rink
Stadium
Total
OPERATING REVENUES:
Charges for services …………………………………………… $
13,945,725
$
21,673,233
$
587,035
$
200,074
$
36,406,067
OPERATING EXPENSES:
Cost of services and administration ……………………………
9,832,433
17,564,492
504,662
154,881
28,056,468
Depreciation………………………………………………………
1,233,674
487,002
85,898
-
1,806,574
TOTAL OPERATING EXPENSES …………………………
11,066,107
18,051,494
590,560
154,881
29,863,042
OPERATING INCOME (LOSS)……………………………
2,879,618
3,621,739
(3,525)
45,193
6,543,025
NONOPERATING REVENUES (EXPENSES):
Investment income………………………………………………
19,915
140,182
128
128
160,353
Interest expense…………………………………………………
(100,192)
(54,989)
(88,538)
-
(243,719)
TOTAL NONOPERATING
REVENUES (EXPENSES), NET…………………………
(80,277)
85,193
(88,410)
128
(83,366)
INCOME (LOSS) BEFORE
TRANSFERS………………………………………………
2,799,341
3,706,932
(91,935)
45,321
6,459,659
TRANSFERS:
Transfers in………………………………………………………
458,705
974,748
199,000
-
1,632,453
Transfers out………………………………………………………
(631,696)
(655,701)
-
-
(1,287,397)
TOTAL OPERATING TRANSFERS………………………
(172,991)
319,047
199,000
-
345,056
CHANGE IN NET POSITION………………………………
2,626,350
4,025,979
107,065
45,321
6,804,715
NET POSITION AT BEGINNING OF YEAR………………………
31,161,099
29,316,590
908,589
139,856
61,526,134
NET POSITION AT END OF YEAR……………………………… $
33,787,449
$
33,342,569
$
1,015,654
$
185,177
$
68,330,849
See notes to basic financial statements.
City of Somerville, Massachusetts
41
Comprehensive Annual Financial Report
PROPRIETARY FUNDS
STATEMENT OF CASH FLOWS
YEAR ENDED JUNE 30, 2017
Veterans
Memorial
Dilboy
Water
Sewer
Ice Rink
Stadium
Total
CASH FLOWS FROM OPERATING ACTIVITIES:
Receipts from customers and users……………………………………………
$
13,921,258
$
21,161,818
$
587,035
$
200,074
$
35,870,185
Payments to vendors………………………………………………………………
(9,068,239)
(17,526,541)
(321,728)
(61,843)
(26,978,351)
Payments to employees…………………………………………………………
(1,097,540)
(430,983)
(189,313)
(95,699)
(1,813,535)
NET CASH FROM OPERATING ACTIVITIES……………………………………
3,755,479
3,204,294
75,994
42,532
7,078,299
CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES:
Transfers in…………………………………………………………………………
458,705
974,748
199,000
-
1,632,453
Transfers out………………………………………………………………………
(631,696)
(655,701)
-
-
(1,287,397)
NET CASH FROM NONCAPITAL FINANCING ACTIVITIES……………………
(172,991)
319,047
199,000
-
345,056
CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES:
Issuance of debt……………………………………………………………………
5,460,000
5,200,000
-
-
10,660,000
Acquisition and construction of capital assets…………………………………
(1,929,751)
(3,651,632)
-
-
(5,581,383)
Principal payments on bonds and notes…………………………………………
(1,888,042)
(1,330,341)
(185,000)
-
(3,403,383)
Interest expense……………………………………………………………………
(106,472)
(57,036)
(89,925)
-
(253,433)
NET CASH FROM CAPITAL AND RELATED FINANCING ACTIVITIES………
1,535,735
160,991
(274,925)
-
1,421,801
CASH FLOWS FROM INVESTING ACTIVITIES:
Investment income…………………………………………………………………
19,915
140,182
128
128
160,353
NET CHANGE IN CASH AND CASH EQUIVALENTS……………………..……
5,138,138
3,824,514
197
42,660
9,005,509
CASH AND CASH EQUIVALENTS AT BEGINNING OF YEAR…………………
4,714,911
7,325,926
96,357
145,693
12,282,887
CASH AND CASH EQUIVALENTS AT END OF YEAR…………………………
$
9,853,049
$
11,150,440
$
96,554
$
188,353
$
21,288,396
RECONCILIATION OF OPERATING INCOME (LOSS) TO NET CASH
FROM OPERATING ACTIVITIES:
Operating income (loss)…………………………………………………………
$
2,879,618
$
3,621,739
$
(3,525)
$
45,193
$
6,543,025
Adjustments to reconcile operating income (loss) to net
cash from operating activities:
Depreciation……………………………………………………………………
1,233,674
487,002
85,898
-
1,806,574
Deferred outflows (inflows) related to pensions:……………………………
(41,730)
(22,919)
-
-
(64,649)
Changes in assets and liabilities:
User fees……………………………………………………………………
(24,467)
(511,415)
-
-
(535,882)
Warrants payable……………………………………………………………
(41,517)
(7,266)
(4,048)
(1,599)
(54,430)
Accrued payroll………………………………………………………………
(9,543)
1,106
(2,331)
(1,062)
(11,830)
Accrued compensated absences…………………………………………
(2,400)
(9,700)
-
-
(12,100)
Other postemployment benefits……………………………………………
(438,953)
(480,971)
-
-
(919,924)
Net pension liability…………………………………………………………
200,797
126,718
-
-
327,515
Total adjustments………………………………………………………
875,861
(417,445)
79,519
(2,661)
535,274
NET CASH FROM OPERATING ACTIVITIES……………………………………
$
3,755,479
$
3,204,294
$
75,994
$
42,532
$
7,078,299
See notes to basic financial statements.
Business-Type Activities - Enterprise Funds
City of Somerville, Massachusetts
42
Comprehensive Annual Financial Report
FIDUCIARY FUNDS
STATEMENT OF FIDUCIARY NET POSITION
JUNE 30, 2017
Other
Postemployment
Private
Pension
Benefits Trust
Purpose
Agency
Trust Funds (1)
Fund
Trust Funds
Funds
ASSETS
CURRENT:
Cash and cash equivalents……………………………………… $
5,423,121
$
1,821,275
$
95,116
$
637,342
Investments:
Bond mutual funds……………………………………………
65,233,177
-
-
-
Real estate and alternative investment mutual funds……
22,144,293
-
-
-
Equity mutual funds……………………………………………
22,745,873
-
-
-
Equity securities………………………………………………
127,362,526
-
-
-
Interest and dividends……………………………………………
2,838
-
-
-
Receivables, net of allowance for uncollectibles:
Intergovernmental……………………………………………
23,003
-
-
-
TOTAL ASSETS………………………………………………………
242,934,831
1,821,275
95,116
637,342
LIABILITIES
Warrants payable…………………………………………………
133,542
-
-
-
Accrued liabilities…………………………………………………
-
-
-
72,686
Liabilities due depositors…………………………………………
-
-
-
564,656
TOTAL LIABILITIES…………………………………………………
133,542
-
-
637,342
NET POSITION
Restricted for pensions……………………………………………
242,801,289
-
-
-
Restricted for OPEB benefits……………………………………
-
1,821,275
-
-
Held in trust for other purposes…………………………………
-
-
95,116
-
TOTAL NET POSITION……………………………………… $
242,801,289
$
1,821,275
$
95,116
$
-
(1) As of December 31, 2016
See notes to basic financial statements.
City of Somerville, Massachusetts
43
Comprehensive Annual Financial Report
FIDUCIARY FUNDS
STATEMENT OF CHANGES IN FIDUCIARY NET POSITION
YEAR ENDED JUNE 30, 2017
Other
Postemployment
Private
Pension
Benefits Trust
Purpose
Trust Funds (1)
Fund
Trust Funds
ADDITIONS:
Contributions:
Employer contributions to trust………………………………….. $
14,659,434
$
1,000,000
$
-
Employee……………………………………………………………
6,719,692
-
-
Employer contributions to fund OPEB benefits…………………
-
9,258,566
-
Private donations……………………………………………………
-
-
5,954
Total contributions………………………………………………
21,379,126
10,258,566
5,954
Net investment income (loss):
Net change in fair value of investments…………………………
4,988,117
-
-
Interest………………………………………………………………
4,999,258
7,507
329
Total investment income (loss)………………………………
9,987,375
7,507
329
Less: investment expense…………………………………………
(1,189,888)
-
-
Net investment income (loss)……………………………………
8,797,487
7,507
329
Intergovernmental…………………………………………………
422,632
-
-
Transfers from other systems……………………………………
1,321,861
-
-
TOTAL ADDITIONS……………………………………………
31,921,106
10,266,073
6,283
DEDUCTIONS:
Administration………………………………………………………
434,364
-
-
Transfers to other systems…………………………………………
1,894,472
-
-
Payment of benefits and refunds…………………………………
26,285,115
-
-
OPEB benefits………………………………………………………
-
9,258,566
-
Educational scholarships…………………………………………
-
-
1,000
TOTAL DEDUCTIONS…………………………………………
28,613,951
9,258,566
1,000
NET INCREASE (DECREASE) IN NET POSITION…………
3,307,155
1,007,507
5,283
NET POSITION AT BEGINNING OF YEAR…………………………
239,494,134
813,768
89,833
NET POSITION AT END OF YEAR………………………………… $
242,801,289
$
1,821,275
$
95,116
(1) For the year ended December 31, 2016
See notes to basic financial statements.
City of Somerville, Massachusetts
44
Comprehensive Annual Financial Report
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
45
Comprehensive Annual Financial Report
NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
Notes to Basic Financial Statements
The accompanying basic financial statements of the City of Somerville, Massachusetts (City) have been prepared
in accordance with accounting principles generally accepted in the United States of America (GAAP). The
Governmental Accounting Standards Board (GASB) is the recognized standard-setting body for establishing
governmental accounting and financial reporting principles. The significant City accounting policies are described
herein.
A. Reporting Entity
The City is a municipal corporation that is governed by an elected Mayor and an eleven member Board of
Alderman (Board).
For financial reporting purposes, the City has included all funds, organizations, agencies, boards, commissions
and institutions. The City has also considered all potential component units for which it is financially accountable
as well as other organizations for which the nature and significance of their relationship with the City are such that
exclusion would cause the basic financial statements to be misleading or incomplete. As required by GAAP,
these basic financial statements present the City (primary government) and its component units. One entity has
been included as a component unit in the reporting entity, because of the significance of its operational and/or
financial relationship.
Component Unit Presented as a Fiduciary Fund – The following component unit is presented as a Fiduciary Fund
of the primary government due to the nature and significance of relationship between the City and the component
unit:
The Somerville Contributory Retirement System (System) was established to provide retirement benefits
to City employees, the City Housing Authority employees, and their beneficiaries. The System is
governed by a five-member board comprised of the City Auditor (ex-officio), two members elected by the
System’s participants, one member appointed by the Mayor and one member appointed by the Board
members. The System is presented using the accrual basis of accounting and is reported as a pension
trust fund in the fiduciary fund financial statements.
Availability of Financial Information for Component Units
The System did not issue a separate audited financial statement. The System issues a publicly available
unaudited financial report in accordance with guidelines established by the Commonwealth of Massachusetts’
(Commonwealth) Public Employee Retirement Administration Commission (PERAC). That report may be
obtained by contacting the System located at 50 Evergreen Avenue, Somerville, Massachusetts 02145.
B. Government-Wide and Fund Financial Statements
Government-Wide Financial Statements
The government-wide financial statements (i.e., statement of net position and the statement of changes in net
position) report information on all of the non-fiduciary activities of the primary government and its component
units. Governmental activities are primarily supported by taxes and intergovernmental revenues.
Fund Financial Statements
Separate financial statements are provided for governmental funds, proprietary funds, and fiduciary funds, even
though fiduciary funds are excluded from the government-wide financial statements. Major individual
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
46
Comprehensive Annual Financial Report
governmental funds are reported as separate columns in the fund financial statements. Non-major funds are
aggregated and displayed in a single column.
Major Fund Criteria
Major funds must be reported if the following criteria are met:
•
If the total assets and deferred outflows, liabilities and deferred inflows, revenues, or
expenditures/expenses of an individual governmental fund are at least 10 percent of the
corresponding element (assets and deferred outflows, liabilities and deferred inflows, etc.) for all
funds of that category or type (total governmental funds), and
•
If the total assets and deferred outflows, liabilities and deferred inflows, revenues, or
expenditures/expenses of the individual governmental funds are at least 5 percent of the
corresponding element for all governmental funds combined.
Additionally, any other governmental fund that management believes is particularly significant to the basic
financial statements may be reported as a major fund.
Internal service funds and fiduciary funds are reported by fund type.
C. Measurement Focus, Basis of Accounting and Financial Statement Presentation
Government-Wide Financial Statements
The government-wide financial statements are reported using the economic resources measurement focus and
the accrual basis of accounting. Under this method, revenues are recorded when earned and expenses are
recorded when the liabilities are incurred. Real estate and personal property taxes are recognized as revenues in
the year for which they are levied. Grants and similar items are recognized as revenue as soon as all eligibility
requirements imposed by the provider have been met.
The statement of activities demonstrates the degree to which the direct expenses of a particular function or
segment are offset by program revenues. Direct expenses are those that are clearly identifiable with a specific
function or segment. Program revenues include the following:
•
Charges to customers or applicants who purchase, use, or directly benefit from goods, services, or
privileges provided by a given function or segment.
•
Grants and contributions that are restricted to meeting the operational requirements of a particular
function or segment.
•
Grants and contributions that are restricted to meeting the capital requirements of a particular function or
segment.
Taxes and other items not identifiable as program revenues are reported as general revenues.
For the most part, the effect of interfund activity has been removed from the government-wide financial
statements. However, the net effect of interfund services provided and used between functions is not eliminated,
as the elimination of these charges would distort the direct costs and program revenues reported for the functions
affected.
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
47
Comprehensive Annual Financial Report
Fund Financial Statements
Governmental fund financial statements are reported using the flow of current financial resources measurement
focus and the modified accrual basis of accounting. Under the modified accrual basis of accounting, revenues
are recognized when susceptible to accrual (i.e., measurable and available). Measurable means the amount of
the transaction can be determined and available means collectible within the current period or soon enough
thereafter to pay liabilities of the current period. Expenditures generally are recorded when a liability is incurred,
as under accrual accounting. However, debt service expenditures, as well as expenditures related to
compensated absences, and claims and judgments, are recorded only when payment is due. General capital
asset acquisitions are reported as expenditures in governmental funds. Issuance of long-term debt and
acquisitions under capital leases are reported as other financing sources.
Real estate and personal property tax revenues are considered available if they are collected within 60 days after
year-end. Investment income is susceptible to accrual. Other receipts and tax revenues become measurable
and available when the cash is received and are recognized as revenue at that time.
Entitlements and shared revenues are recorded at the time of receipt or earlier if the susceptible to accrual criteria
is met. Expenditure driven grants recognize revenue when the qualifying expenditures are incurred and all other
grant requirements are met.
The following major governmental funds are reported:
The general fund is the primary operating fund. It is used to account for all financial resources, except those that
are required to be accounted for in another fund.
The strategic planning and community development fund is used to account for grant activities of the Office of
Strategic Planning and Community Development.
The capital projects fund is used to account for activities associated with constructing and acquiring assets for
both general city-wide and school construction projects.
The nonmajor governmental funds consist of other special revenue, capital projects and permanent funds that are
aggregated and presented in the nonmajor governmental funds column on the governmental funds financial
statements. The following describes the general use of these fund types:
The special revenue fund is used to account for and report the proceeds of specific revenue sources that are
restricted or committed to expenditure for specified purposes other than permanent funds or capital projects.
The capital projects fund is used to account for and report financial resources that are restricted, committed, or
assigned to expenditure for capital outlays, including the acquisition or construction of capital facilities and other
capital assets of the governmental funds.
The permanent fund is used to account for and report financial resources that are legally restricted to the extent
that only earnings, not principal, may be used for purposes that support the governmental programs.
Proprietary fund financial statements are reported using the flow of economic resources measurement focus and
use the accrual basis of accounting. Under this method, revenues are recorded when earned and expenses are
recorded when the liabilities are incurred.
Proprietary funds distinguish operating revenues and expenses from nonoperating items. Operating revenues
and expenses generally result from providing services and producing and delivering goods in connection with the
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
48
Comprehensive Annual Financial Report
proprietary funds principal ongoing operations. All revenues and expenses not meeting this definition are
reported as nonoperating revenues and expenses.
The following major proprietary funds are reported:
The water enterprise fund is used to account for financial activity that occurs as a result of the ongoing operations
within the water department.
The sewer enterprise fund is used to account for the financial activity that occurs as a result of the ongoing
operations within the sewer department.
The Veterans Memorial Ice Rink enterprise fund is used to account for financial activity that occurs as a result of
the ongoing operation of the Veteran’s Memorial Ice Rink and the second auxiliary rink.
The Dilboy Field enterprise fund is used to account for financial activity that occurs as a result of the ongoing
operations of the Dilboy Stadium.
Fiduciary fund financial statements are reported using the flow of economic resources measurement focus and
use the accrual basis of accounting. Fiduciary funds are used to account for assets held in a trustee capacity for
others that cannot be used to support the governmental programs.
The following fiduciary fund types are reported:
The pension trust fund is used to account for the activities of the System, which accumulates resources to provide
pension benefits to eligible retirees and their beneficiaries.
The other postemployment benefits trust fund is a fund being used to accumulate resources to provide funding for
future other postemployment benefits (OPEB) liabilities.
The private-purpose trust fund is used to account for trust arrangements that exclusively benefit individuals,
private organizations, or other governments. Some of these trusts have donor restrictions and trustee policies
that do not allow the endowment portion and any unrealized appreciation to be spent. The donor restrictions and
trustee policies only allows the trustees to authorize spending of the realized investment earnings. The City’s
educational scholarship trusts are accounted for in this fund.
The agency fund is used to account for assets held in a purely custodial capacity.
D. Cash and Investments
Government-Wide and Fund Financial Statements
Cash and cash equivalents are considered to be cash on hand, demand deposits and short-term investments with
an original maturity of three months or less from the date of acquisition. Investments are carried at fair value.
E. Fair Value Measurements
The City reports required types of financial instruments in accordance with the fair value standards. These
standards require an entity to maximize the use of observable inputs (such as quoted prices in active markets)
and minimize the use of unobservable inputs (such as appraisals or valuation techniques) to determine fair value.
Fair value standards also require the government to classify these financial instruments into a three-level
hierarchy, based on the priority of inputs to the valuation technique or in accordance with net asset value practical
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
49
Comprehensive Annual Financial Report
expedient rules, which allow for either Level 2 or Level 3 depending on lock up and notice periods associated with
the underlying funds.
Instruments measured and reported at fair value are classified and disclosed in one of the following categories:
Level 1 – Quoted prices are available in active markets for identical instruments as of the reporting date.
Instruments, which are generally included in this category, include actively traded equity and debt securities, U.S.
government obligations, and mutual funds with quoted market prices in active markets.
Level 2 – Pricing inputs are other than quoted in active markets, which are either directly or indirectly observable
as of the reporting date, and fair value is determined through the use of models or other valuation methodologies.
Certain fixed income securities, primarily corporate bonds, are classified as Level 2 because fair values are
estimated using pricing models, matrix pricing, or discounted cash flows.
Level 3 – Pricing inputs are unobservable for the instrument and include situations where there is little, if any,
market activity for the instrument. The inputs into the determination of fair value require significant management
judgment or estimation.
In some instances the inputs used to measure fair value may fall into different levels of the fair value hierarchy
and is based on the lowest level of input that is significant to the fair value measurement.
Market price is affected by a number of factors, including the type of instrument and the characteristics specific to
the instrument. Instruments with readily available active quoted prices generally will have a higher degree of
market price observability and a lesser degree of judgment used in measuring fair value. It is reasonably possible
that change in values of these instruments will occur in the near term and that such changes could materially
affect amounts reported in these financial statements. For more information on the fair value of the City’s
financial instruments, see Note 2 – Cash and Investments.
F. Accounts Receivable
Government-Wide and Fund Financial Statements
The recognition of revenue related to accounts receivable reported in the government-wide financial statements
and the fiduciary funds financial statements are reported under the accrual basis of accounting.
The recognition of revenue related to accounts receivable reported in the governmental funds financial statements
are reported under the modified accrual basis of accounting.
Real Estate, Personal Property Taxes and Tax Liens
Real estate and personal property taxes are levied and based on values assessed on January 1st of every year.
Assessed values are established by the Board of Assessors for 100% of the estimated fair market value. Taxes
are due on August 1st, November 1st, February 1st and May 1st and are subject to penalties and interest if they are
not paid by the respective due date. Real estate and personal property taxes levied are recorded as receivables
in the year of the levy.
Real estate tax liens are processed six months after the close of the valuation year on delinquent properties and
are recorded as receivables in the year they are processed.
Real estate receivables are secured via the tax lien process and are considered 100% collectible. Accordingly,
an allowance for uncollectibles is not reported.
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
50
Comprehensive Annual Financial Report
Personal property taxes cannot be secured through the lien process. The allowance of uncollectibles is estimated
based on historical trends and specific account analysis.
Motor Vehicle Excise
Motor vehicle excise taxes are assessed annually for each vehicle registered in the City and are recorded as
receivables in the year of the levy. The Commonwealth is responsible for reporting the number of vehicles
registered and the fair values of those vehicles. The tax calculation is the fair value of the vehicle multiplied by
$25 per $1,000 of value. The allowance for uncollectibles is estimated based on historical trends and specific
account analysis.
Water and Sewer
User fees are levied monthly based on individual meter readings and are subject to penalties and interest if they
are not paid by the respective due date. Water and Sewer liens are processed in December of every year and
included as a lien on the property owner’s tax bill. Water and Sewer charges and liens are recorded as
receivables in the year of the levy.
Since the receivables are secured via the lien process, these accounts are considered 100% collectible and
therefore do not report an allowance for uncollectibles.
Departmental and Other
Departmental and other receivables consist primarily of parking fines and are recorded as receivables in the year
accrued. The allowance of uncollectibles is estimated based on historical trends and specific account analysis.
Intergovernmental
Various federal and state grants for operating and capital purposes are applied for and received annually. For
non-expenditure driven grants, receivables are recorded as soon as all eligibility requirements imposed by the
provider have been met. For expenditure driven grants, receivables are recorded when the qualifying
expenditures are incurred and all other grant requirements are met.
These receivables are considered 100% collectible and therefore do not report an allowance for uncollectibles.
Loans
The Office of Strategic Planning and Community Development administers loan programs that provide housing
assistance to residents and capital needs assistance for small businesses. Upon issuance, a receivable is
recorded for the principal amount of the loan.
Loan receivables are secured via the lien process and are considered 100% collectible. Accordingly, an
allowance for uncollectibles is not reported.
G. Inventories
Government-Wide and Fund Financial Statements
Inventories are recorded as expenditures at the time of purchase. Such inventories are not material in total to the
government-wide and fund financial statements, and therefore are not reported.
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
51
Comprehensive Annual Financial Report
H. Capital Assets
Government-Wide Fund Financial Statements
Capital assets, which include land, construction in progress, land improvements, books and periodicals, buildings
and improvements, machinery and equipment, vehicles, and infrastructure (e.g., roads, water mains, sewer
mains, and similar items), are reported in the applicable governmental activity column of the government-wide
financial statements. Capital assets are recorded at historical cost, or at estimated historical cost, if actual
historical cost is not available. Donated capital assets, donated works of art, historical treasurers and similar
assets, and capital assets received in service concession arrangements are recorded at acquisition value.
Construction period interest is capitalized on constructed capital assets except for the capital assets of the
governmental activities column in the government-wide financial statements.
All purchases and construction costs in excess of $50,000 are capitalized at the date of acquisition or
construction, respectively, with expected useful lives of greater than one year.
Capital assets (excluding land) are depreciated on a straight-line basis. The estimated useful lives of capital
assets are as follows:
Estimated
Useful
Life
(in years)
Land improvements……………………………
20-40
Books and periodicals…………………………
10
Buildings and improvements…………………
20-40
Machinery and equipment……………………
5-10
Vehicles…………………………………………
5-15
Infrastructure……………………………………
10-50
Capital Asset Type
The cost of normal maintenance and repairs that do not add to the value of the assets or materially extend asset
lives are not capitalized and are treated as expenses when incurred. Improvements are capitalized.
Governmental Fund Financial Statements
Capital asset costs are recorded as expenditures in the acquiring fund in the year of the purchase.
I. Deferred Outflows/Inflows of Resources
Government-Wide Financial Statements (Net Position)
In addition to assets, the statement of financial position will sometimes report a separate section for deferred
outflows of resources. This separate financial statement element, deferred outflows of resources, represents a
consumption of net position that applies to a future period(s) and so will not be recognized as an outflow of
resources (expense/ expenditure) until then. The City reported deferred charges on refunding and deferred
outflows related to pensions in this category.
In addition to liabilities, the statement of financial position will sometimes report a separate section for deferred
inflows of resources. This separate financial statement element, deferred inflows of resources, represents an
acquisition of net position that applies to a future period(s) and so will not be recognized as an inflow of resources
(revenue) until that time. The City reported deferred inflows related to pensions in this category.
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
52
Comprehensive Annual Financial Report
Governmental Fund Financial Statements
In addition to liabilities, the governmental funds balance sheet will sometimes report a separate section for
deferred inflows of resources. This separate financial statement element, deferred inflows of resources,
represents assets that have been recorded in the governmental fund financial statements but the revenue is not
available and so will not be recognized as an inflow of resources (revenue) until it becomes available. The City
has recorded unavailable revenue as deferred inflows of resources in the governmental funds balance sheet.
J. Unavailable Revenue
Unavailable revenue at the governmental fund financial statement level represents billed receivables that do not
meet the availability criterion in accordance with the current financial resources measurement focus and the
modified accrual basis of accounting. Unavailable revenue is recognized as revenue in the conversion to the
entity-wide (full accrual) financial statements.
K. Interfund Receivables and Payables
During the course of its operations, transactions occur between and within individual funds that may result in
amounts owed between funds.
Government-Wide Financial Statements
Transactions of a buyer/seller nature between and within governmental funds and internal service funds are
eliminated from the governmental activities in the statement of Net Position. Any residual balances outstanding
between the governmental activities and business-type activities are reported in the statement of Net Position as
“internal balances”.
Fund Financial Statements
Transactions of a buyer/seller nature between and within funds are not eliminated from the individual fund
statements. Receivables and payables resulting from these transactions are classified as “Due from other funds”
or “Due to other funds” on the balance sheet.
L. Interfund Transfers
During the course of its operations, resources are permanently reallocated between and within funds. These
transactions are reported as operating transfers in and operating transfers out.
Government-Wide Financial Statements
Operating transfers between and within governmental funds are eliminated from the governmental activities in the
statement of activities. Any residual balances outstanding between the governmental activities and business-type
activities are reported in the statement of activities as “Transfers, net”.
Fund Financial Statements
Operating transfers between and within funds are not eliminated from the individual fund statements and are
reported as operating transfers in and operating transfers out.
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
53
Comprehensive Annual Financial Report
M. Net Position and Fund Equity
Government-Wide Financial Statements (Net Position)
Net position reported as “net investment in capital assets” includes capital assets, net of accumulated
depreciation, less the principal balance of outstanding debt used to acquire capital assets. Unspent proceeds of
capital related debt are not considered to be capital assets. Outstanding debt related to future reimbursements
from the state’s school building program is not considered to be capital related debt.
Net position is reported as restricted when amounts that are not available for appropriation or are legally restricted
by outside parties for a specific future use.
Net position has been “restricted for” the following:
“Streets” represents amounts committed by the Commonwealth for the repair and/or construction of streets.
“Community Development” represents amounts committed by the Federal Department of Housing and Urban
Development (HUD) for various community development projects.
“Loans” represents community development outstanding loans receivable balances.
“Permanent funds – nonexpendable” represents the endowment portion of donor restricted trusts that support
governmental programs.
“Permanent funds – expendable” represents the amount of realized and unrealized investment earnings of donor
restricted trusts. The donor restrictions and trustee policies only allows the trustees to approve spending of the
realized investment earnings that support governmental programs.
“Other specific purposes” represents restrictions placed on assets from outside parties, such as federal and state
grants.
Sometimes the City will fund outlays for a particular purpose from both restricted (e.g., restricted bond or grant
proceeds) and unrestricted resources. In order to calculate the amounts to report as restricted – net position and
unrestricted – net position in the government-wide and proprietary fund financial statements, a flow assumption
must be made about the order in which the resources are considered to be applied. It is the City’s policy to
consider restricted – net position to have been depleted before unrestricted – net position is applied.
Fund Financial Statements (Fund Balances)
Governmental fund balances are classified as nonspendable, restricted, committed, assigned, or unassigned
based on the extent to which the government is bound to honor constraints on the specific purposes for which
amounts in those funds can be spent.
The governmental fund balance classifications are as follows:
“Nonspendable” fund balance includes amounts that cannot be spent because they are either not in spendable
form or they are legally or contractually required to be maintained intact.
“Restricted” fund balance includes amounts subject to constraints placed on the use of resources that is either
externally imposed by creditors, grantors, contributors, or laws or regulations of other governments; or that are
imposed by law through constitutional provisions or enabling legislation.
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
54
Comprehensive Annual Financial Report
“Committed” fund balance includes amounts that can only be used for specific purposes pursuant to constraints
imposed by formal action of the government’s highest level of decision-making authority. Approval by the Board
of Alderman is the highest level of decision-making authority for the government that can, by approval of a council
order prior to the end of the year, commit fund balance. Once adopted, the limitation imposed by the order
remains in place until a similar action is taken to remove or revise the limitation.
“Assigned” fund balance includes amounts that are constrained by the City’s intent to be used for specific
purposes, but are neither restricted nor committed. The City Finance Director has the authority to assign fund
balance. Funds are assigned when the City has an obligation to purchase goods or services from the current
years’ appropriation. Assignments generally only exist temporarily. Additional action does not have to be taken
for the removal of an assignment.
“Unassigned” fund balance includes the residual classification for the general fund. This classification represents
fund balance that has not been assigned to other funds and that has not been restricted, committed, or assigned
to specific purposes within the general fund. The general fund is the only fund that that can report a positive
unassigned fund balance amount.
The City’s spending policy is to spend restricted fund balance first, followed by committed, assigned and
unassigned fund balance. Most governmental funds are designated for one purpose at the time of their creation.
Therefore, any expenditure from the fund will be allocated to the applicable fund balance classifications in the
order of the aforementioned spending policy. The general fund and certain other funds may have more than one
purpose.
N. Pensions
For purposes of measuring the net pension liability, deferred outflows of resources and deferred inflows of
resources related to pensions, and pension expense, information about the fiduciary net position of the Somerville
Contributory Retirement System and the Massachusetts Teachers Retirement System and additions
to/deductions from the Systems fiduciary net position have been determined on the same basis as they are
reported by the Systems. For this purpose, benefit payments (including refunds of employee contributions) are
recognized when due and payable in accordance with the benefit terms. Investments are reported at fair value.
O. Long-term debt
Government-Wide and Proprietary Fund Financial Statements
Long-term debt is reported as a liability in the government-wide statement of Net Position. Material bond
premiums and discounts are deferred and amortized over the life of the bonds using the effective interest method.
Bonds payable are reported net of the applicable bond premium or discount.
Governmental Fund Financial Statements
The face amount of governmental funds long-term debt is reported as other financing sources. Bond premiums
and discounts, as well as issuance costs, are recognized in the current period. Bond premiums are reported as
other financing sources and bond discounts are reported as other financing uses. Issuance costs, whether or not
withheld from the actual bond proceeds received, are reported as general government expenditures.
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
55
Comprehensive Annual Financial Report
P. Investment Income
Excluding the permanent funds, investment income derived from major and nonmajor governmental funds is
legally assigned to the general fund unless otherwise directed by Massachusetts General Law (MGL).
Investment income of the proprietary funds is retained in the respective enterprise fund.
Q. Compensated Absences
Employees are granted vacation and sick leave in varying amounts based on collective bargaining agreements,
state laws and executive policies.
Government-Wide Financial Statements
Vested or accumulated vacation and sick leave are reported as liabilities and expensed as incurred.
Governmental Fund Financial Statements
Vested or accumulated vacation and sick leave, which will be liquidated with expendable available financial
resources, are reported as expenditures and fund liabilities.
R. Use of Estimates
Government-Wide and Fund Financial Statements
The preparation of basic financial statements in conformity with GAAP requires management to make estimates
and assumptions that affect the reported amounts of assets and liabilities and disclosure for contingent assets
and liabilities at the date of the basic financial statements and the reported amounts of the revenues and
expenditures/expenses during the year. Actual results could vary from estimates that were used.
S. Individual Fund Deficits
At June 30, 2017, the Capital Projects Fund reports a fund deficit of $11.4 million. This deficit will be funded with
available funds and future bond proceeds.
T. Total Column
Government-Wide Financial Statements
The total column presented on the government-wide financial statements represents consolidated financial
information.
Fund Financial Statements
The total column on the fund financial statements is presented only to facilitate financial analysis. Data in this
column is not the equivalent of consolidated financial information.
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
56
Comprehensive Annual Financial Report
NOTE 2 - CASH AND INVESTMENTS
A cash and investment pool is maintained that is available for use by all funds. Each fund type's portion of this
pool is displayed on the balance sheet as "Cash and Cash Equivalents". The deposits and investments of the
trust funds are held separately from those of other funds.
Statutes authorize the investment in obligations of the U.S. Treasury, agencies, and instrumentalities, certificates
of deposit, repurchase agreements, money market accounts, bank deposits and the State Treasurer's Investment
Pool (Pool). In addition, there are various restrictions limiting the amount and length of deposits and investments.
The Pool meets the criteria of an external investment pool. The Pool is administered by the Massachusetts
Municipal Depository Trust (MMDT), which was established by the Treasurer of the Commonwealth who serves
as Trustee. The fair value of the position in the Pool is the same as the value of the Pool shares. The MMDT
maintains a cash portfolio and a short-term bond fund with combined average maturities of approximately 3
months.
The City Treasurer is the custodian of funds held in the Other Postemployment Benefit (OPEB) Trust Fund. As of
June 30, 2017, $1.8 million of the OPEB Trust Fund is included within the City’s cash and investments.
Custodial Credit Risk – Deposits
In the case of deposits, this is the risk that in the event of a bank failure, the City of Somerville’s deposits may not
be returned to it. The City’s investment policy states that safety, liquidity and yield are the most important
attributes when deciding on which financial institutions to deposit funds with. These guidelines are intended to
further the objective of securing the highest return that is consistent with the safety principal while meeting the
daily cash requirements of the City. The Treasurer also subscribes to a bank rating service to assist in the
determination of which banks to place deposits with. At year-end, the carrying amount of deposits totaled
$135,680,472 and the bank balance totaled $140,567,097. Of the bank balance, $2,585,564 was covered by
Federal Depository Insurance, $15,712,548 was covered by the Depositors Insurance Fund, $7,844,068 was
covered by Share Insurance Fund, $113,778,354 was collateralized, and $646,563 was exposed to custodial
credit risk because it was uninsured and uncollateralized.
At December 31, 2016, carrying amount of deposits for the System totaled $4,983,824, and the bank balance
totaled $5,429,576. The entire bank balance of the System was covered by Federal Depository Insurance and is
collateralized.
Investments
As of June 30, 2017, the City of Somerville had the following investments:
Other Investments
MMDT………………………………………………$
6,009,284
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
57
Comprehensive Annual Financial Report
As of December 31, 2016, the System had the following investments:
Fair Value
Under 1 Year
1-5 Years
6-10 Years
Over 10 Years
Rating
Investment Type
Debt Securities
(1) Loomis Sayles Fixed Income Fund …………$
65,233,177
$
13,307,568
$
24,984,307
$
14,873,164
$
12,068,138
Aaa / NR
Other Investments
Equity Mutual Funds (Domestic).......................
10,774,696
Equity Mutual Funds (International)..................
11,971,177
Equities……………………………………………
127,362,526
Real Estate and Alternative Mutual Funds……
22,144,293
Money Market Mutual Funds……………………
439,297
Total Investments...........................................$
237,925,166
Maturity
(1) The maturities and ratings of the fixed income mutual funds are representative of the average maturities
of the underlying investments of each fund.
Custodial Credit Risk – Investments
For an investment, this is the risk that, in the event of a failure by the counterparty, the City will not be able to
recover the value of its investments or collateral security that are in the possession of an outside party. The City
does not have investments that are subject to custodial credit risk. The City’s investment policy states that no
more than 20% of the City’s investments should be invested in a single financial institution with the exception of
U.S. Treasuries or Agencies and the State Treasurer’s Investment Pool (MMDT).
Of the System’s $127,362,526, in equity securities, the System has custodial credit risk exposure of
$127,362,526, because the related securities are uninsured, unregistered and held by the counterparty. The
System has not adopted a formal investment policy to manage custodial credit risk.
Interest Rate Risk
The City’s investment policy limits the maturities of investments in the following ways; up to one year from date of
purchase for U.S. Treasuries or Agencies, Certificates of Deposit limited to one year terms, Repurchase
Agreements not to exceed 90 days. These limits do not apply to fully insured deposits.
The System does not have a formal investment policy that limits investment maturities as a means of managing
its exposure to fair value losses arising from increasing interest rates.
Credit Risk
The City has not adopted a formal policy related to credit risk. The City does not have any debt securities as of
June 30, 2017. The City’s investment in MMDT is unrated.
The System has not adopted a formal policy related to credit risk. The System’s investment in Fixed Income
Mutual Funds have ratings that range from Aaa to not rated and their Money Market Mutual Funds are not rated.
Concentration of Credit Risk
The City places no limit on the amount the government may invest in any one issuer.
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
58
Comprehensive Annual Financial Report
The System is not invested more than 5% in any one issuer. The System has not adopted a formal policy related
to the amount that may be invested in any one issuer.
Fair Market Value of Investments
The City holds investments that are measured at fair value on a recurring basis. Because investing is not a core
part of the City’s mission, the City determines that the disclosures related to these investments only need to be
disaggregated by major type. The City chooses a narrative format for the fair value disclosures
The City categorizes its fair value measurements within the fair value hierarchy established by generally accepted
accounting principles. The hierarchy is based on the valuation inputs used to measure the fair value of the asset.
Level 1 inputs are quoted prices in active markets for identical assets; Level 2 inputs are significant other
observable inputs; Level 3 inputs are significant unobservable inputs.
The City has the following recurring fair value measurements as of June 30, 2017:
MMDT investments of $6.0 million are valued at amortized cost. Under the amortized cost method, an investment
is valued initially at its cost and adjusted for the amount of interest income accrued each day over the term of the
investment to account for any difference between the initial cost and the amount payable at its maturity. If
amortized cost is determined not to approximate fair value, the value of the portfolio securities will be determined
under procedures established by the Advisor.
Retirement System
The retiree pension defined benefit plan holds significant amounts of investments that are measured at fair value
on a recurring basis. Because investing is a key part of the plan’s activities, the plan shows greater
disaggregation in its disclosures. The plan chooses a tabular format for disclosing the levels within the fair value
hierarchy.
The System categorizes its fair value measurements within the fair value hierarchy established by generally
accepted accounting principles. The System has the following recurring fair value measurements as of December
31, 2016:
Quoted Prices
in Active
Significant
Markets for
Other
Significant
Identical
Observable
Unobservable
Assets
Inputs
Inputs
(Level 1)
(Level 2)
(Level 3)
Investments by fair value level
Debt securities
Fixed Income Mutual Funds…………………$
65,233,177
$
65,233,177
$
-
$
-
Other investments
Equity securities………………………………
127,362,526
127,362,526
-
-
Real Estate investment trusts………………
22,144,293
-
-
22,144,293
Money market mutual funds…………………
439,297
439,297
-
-
Equity mutual funds…………………………
22,745,873
22,745,873
-
-
Total other invesments………………………
172,691,989
150,547,696
-
22,144,293
Total investments by fair value level………$
237,925,166
$
215,780,873
$
-
$
22,144,293
Fair Value Measurements Using
Investment Type
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
59
Comprehensive Annual Financial Report
Fixed income mutual funds, equity securities, money market mutual funds, and equity mutual funds classified in
Level 1 of the fair value hierarchy are valued using prices quoted in active markets for those securities. Real
estate investment trusts are classified in Level 3 are valued using either a discounted cash flow or market
comparable companies technique.
NOTE 3 – RECEIVABLES
At June 30, 2017, receivables for the individual major governmental funds and non-major funds in the aggregate,
including the applicable allowances for uncollectible accounts, are as follows:
Allowance
Gross
for
Net
Amount
Uncollectibles
Amount
Receivables:
Real estate and personal property taxes…… $
1,950,239
$
(155,056)
$
1,795,183
Tax liens…………………………………………
851,508
-
851,508
Motor vehicle excise taxes……………………
1,631,041
(1,454,139)
176,902
Departmental and other…………………………
13,978,988
(10,891,231)
3,087,757
Intergovernmental………………………………
13,537,763
-
13,537,763
Loans……………………………………………
18,325,413
-
18,325,413
Total…………………………. $
50,274,952
$
(12,500,426) $
37,774,526
At June 30, 2017, receivables for the enterprise funds, including the applicable allowances for uncollectible
accounts, are as follows:
Allowance
Gross
for
Net
Amount
Uncollectibles
Amount
Receivables:
Sewer.............................................................. $
7,165,147
$
-
$
7,165,147
Water..............................................................
4,252,054
-
4,252,054
Total…………………………. $
11,417,201
$
-
$
11,417,201
Governmental funds report unavailable revenue in connection with receivables for revenues that are not
considered to be available to liquidate liabilities of the current period. At the end of the current year, the various
components of unavailable revenue reported in the governmental funds were as follows:
Non-Major
General
Community
Governmental
Fund
Development
Funds
Total
Receivable type:
Real estate and personal property taxes…… $
1,144,950
$
-
$
-
$
1,144,950
Tax liens…………………………………………
851,508
-
-
851,508
Motor vehicle excise……………………………
176,902
-
-
176,902
Departmental and other…………………………
3,061,585
-
396,637
3,458,222
Intergovernmental……………………...………
8,498,625
1,148,368
3,205,981
12,852,974
Total………………………… $
13,733,570
$
1,148,368
$
3,602,618
$
18,484,556
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
60
Comprehensive Annual Financial Report
NOTE 4 – CAPITAL ASSETS
Capital asset activity for the year ended June 30, 2017 was as follows:
Beginning
Ending
Balance
Increases
Decreases
Balance
Governmental Activities:
Capital assets not being depreciated:
Land……………………………………………………$
37,082,399
$
-
$
-
$
37,082,399
Construction in progress……………………………
5,977,097
11,238,305
(905,933)
16,309,469
Total capital assets not being depreciated……
43,059,496
11,238,305
(905,933)
53,391,868
Capital assets being depreciated:
Land improvements…………………………………
41,138,786
697,945
-
41,836,731
Books and periodicals………………………………
2,626,489
-
-
2,626,489
Buildings and improvements………………………
206,411,317
996,271
(5,097,435)
202,310,153
Machinery and equipment…………………………
10,275,330
191,857
-
10,467,187
Vehicles………………………………………………
15,383,860
484,636
(167,612)
15,700,884
Infrastructure…………………………………………
46,885,083
1,101,977
-
47,987,060
Total capital assets being depreciated…………
322,720,865
3,472,686
(5,265,047)
320,928,504
Less accumulated depreciation for:
Land improvements…………………………………
(14,452,628)
(1,586,914)
-
(16,039,542)
Books and periodicals………………………………
(2,519,872)
(42,982)
-
(2,562,854)
Buildings and improvements………………………
(76,358,080)
(5,079,527)
5,008,846
(76,428,761)
Machinery and equipment…………………………
(7,876,565)
(508,676)
-
(8,385,241)
Vehicles………………………………………………
(9,192,083)
(819,002)
167,612
(9,843,473)
Infrastructure…………………………………………
(27,842,852)
(900,821)
-
(28,743,673)
Total accumulated depreciation………………
(138,242,080)
(8,937,922)
5,176,458
(142,003,544)
Total capital assets being depreciated, net……………
184,478,785
(5,465,236)
(88,589)
178,924,960
Total governmental activities capital assets, net……
$
227,538,281
$
5,773,069
$
(994,522)
$
232,316,828
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
61
Comprehensive Annual Financial Report
Beginning
Ending
Balance
Increases
Decreases
Balance
Business-Type Activities: Water
Capital assets not being depreciated:
Construction in progress…………………………… $
116,945
$
-
$
(116,945)
$
-
Capital assets being depreciated:
Buildings………………………………………………
16,087
-
-
16,087
Machinery and equipment…………………………
5,267,964
-
-
5,267,964
Vehicles………………………………………………
462,918
-
-
462,918
Infrastructure…………………………………………
36,857,248
1,929,751
-
38,786,999
Total capital assets being depreciated…………
42,604,217
1,929,751
-
44,533,968
Less accumulated depreciation for:
Buildings………………………………………………
(9,248)
(804)
-
(10,052)
Machinery and equipment…………………………
(2,392,292)
(360,665)
-
(2,752,957)
Vehicles………………………………………………
(410,968)
(35,400)
-
(446,368)
Infrastructure…………………………………………
(9,093,509)
(836,805)
-
(9,930,314)
Total accumulated depreciation………………
(11,906,017)
(1,233,674)
-
(13,139,691)
Total water capital assets being depreciated, net……
30,698,200
696,077
-
31,394,277
Total water activities capital assets, net……………… $
30,815,145
$
696,077
$
(116,945)
$
31,394,277
Beginning
Ending
Balance
Increases
Decreases
Balance
Business-Type Activities: Sewer
Capital assets not being depreciated:
Construction in progress…………………………… $
274,824
$
22,244
$
(274,824)
$
22,244
Capital assets being depreciated:
Vehicles………………………………………………
434,092
-
-
434,092
Infrastructure…………………………………………
32,367,660
3,629,388
-
35,997,048
Total capital assets being depreciated…………
32,801,752
3,629,388
-
36,431,140
Less accumulated depreciation for:
Vehicles………………………………………………
(223,565)
(34,924)
-
(258,489)
Infrastructure…………………………………………
(13,733,700)
(452,078)
-
(14,185,778)
Total accumulated depreciation………………
(13,957,265)
(487,002)
-
(14,444,267)
Total sewer capital assets being depreciated, net……
18,844,487
3,142,386
-
21,986,873
Total sewer activities capital assets, net……………… $
19,119,311
$
3,164,630
$
(274,824)
$
22,009,117
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
62
Comprehensive Annual Financial Report
Beginning
Ending
Balance
Increases
Decreases
Balance
Business-Type Activities: Rink
Capital assets being depreciated:
Buildings Improvements…………………………… $
3,435,934
$
-
$
-
$
3,435,934
Less accumulated depreciation for:
Buildings Improvements……………………………
(300,644)
(85,898)
-
(386,542)
Total rink activities capital assets, net………………… $
3,135,290
$
(85,898)
$
-
$
3,049,392
Depreciation expense was charged to functions/programs of the primary government as follows:
Governmental Activities:
General government……………………………………………………
$
781,181
Public safety………………………………………………………………
585,500
Education…………………………………………………………………
4,783,030
Public works………………………………………………………………
1,581,138
Culture and recreation……………………………………………………
1,207,073
Total depreciation expense - governmental activities……………………
$
8,937,922
Business-Type Activities:
Water……………………………………………………………………… $
1,233,674
Sewer………………………………………………………………………
487,002
Rink…………………………………………………………………………
85,898
Total depreciation expense - business-type activities…………………… $
1,806,574
NOTE 5 – INTERFUND RECEIVABLES, PAYABLES AND TRANSFERS
The City’s interfund balances at June 30, 2017, consisted of $1,371,806 in balances within the non-major
governmental funds which represent interfund borrowings for short-term cash flow needs.
Interfund transfers for the year ended June 30, 2017, are summarized as follows:
Capital
Nonmajor
Veteran's
General
Projects
Governmental
Memorial
Operating Transfers Out:
Fund
Fund
Funds
Sewer
Ice Rink
Water
Total
General Fund………………………$
-
$
397,551
$
507,531
$
974,748
$
199,000
$
458,705
$
2,537,535
(1)
Nonmajor Governmental Funds…
3,344,441
-
-
-
-
3,344,441
(2)
Sewer Enterprise Fund……………
655,701
-
-
-
-
-
655,701
(3)
Water Enterprise Fund……………
631,696
-
-
-
-
-
631,696
(3)
Total……………………………… $
4,631,838
$
397,551
$
507,531
$
974,748
$
199,000
$
458,705
$
7,169,373
Transfers In:
(1) Represents budgeted transfers out of the general fund various capital projects, a subsidy transfer to the
Veteran’s Memorial Ice Rink, and contributions to the water and sewer stabilization funds.
(2) Represents a transfer from the parking receipts reserve fund and the bond issuance expense fund to the
general fund, along with various other non-major projects.
(3) Represents the transfer of indirect costs to the general fund.
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
63
Comprehensive Annual Financial Report
NOTE 6 – OPERATING LEASES
Operating Leases
The City leases two police sub-stations under several non-cancelable operating leases. The total cost of these
leases for the year ended June 30, 2017, was approximately $43,800 and is reported as public safety
expenditures in the basic financial statements. The Police sub-station leases were renewed through February of
2018.
NOTE 7 – SHORT-TERM FINANCING
Short-term debt may be authorized and issued to fund the following:
•
Current operating costs prior to the collection of revenues through issuance of revenue or tax anticipation
notes (RANS or TANS).
•
Capital project costs and other approved expenditures incurred prior to obtaining permanent financing through
issuance of bond anticipation notes (BANS) or grant anticipation notes (GANS).
Short-term loans are general obligations and carry maturity dates that are limited by statute. Interest
expenditures and expenses for short-term borrowings are accounted for in the general fund and capital projects
fund, respectively.
Details related to the short-term debt activity for the year ended June 30, 2017, is as follows:
Governmental Activities
Balance at
Balance at
Rate
June 30,
Renewed/
Retired/
June 30,
Type
Purpose
(%)
Due Date
2016
Issued
Redeemed
2017
BAN
Municipal Purpose………………………
1.25
10/14/16
$
18,168,551
$
-
18,168,551
$
-
BAN
Municipal Purpose………………………
2.00
06/09/17
25,631,449
-
25,631,449
-
BAN
Municipal Purpose………………………
2.00
06/08/18
-
39,043,332
-
39,043,332
Total Short-Term Debt……………………………………………… $
43,800,000
$
39,043,332
$
43,800,000
$
39,043,332
Enterprise Activities
Balance at
Balance at
Rate
June 30,
Renewed/
Retired/
June 30,
Type
Purpose
(%)
Due Date
2016
Issued
Redeemed
2017
BAN
Water Repairs……………………………
2.00
06/09/17
$
500,000
$
-
$
500,000
$
-
BAN
Sewer Repairs……………………………
2.00
06/09/17
500,000
-
500,000
-
BAN
Nunziato Field Stormwater Project……
2.00
06/09/17
200,000
-
200,000
-
BAN
Sewer Main Repairs………………………
2.00
06/08/18
-
1,500,000
-
1,500,000
BAN
Water Main Repairs………………………
2.00
06/08/18
-
2,500,000
-
2,500,000
BAN
Cedar Street Water Repairs……………
2.00
06/08/18
-
1,300,000
-
1,300,000
BAN
Cedar Street Sewer Repairs……………
2.00
06/08/18
-
3,000,000
-
3,000,000
BAN
Nunziato Field Stormwater Project……
2.00
06/08/18
-
700,000
-
700,000
Total……………………………………………………$
1,200,000
$
9,000,000
$
1,200,000
$
9,000,000
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
64
Comprehensive Annual Financial Report
NOTE 8 - LONG-TERM DEBT
Under the provisions of Chapter 44, Section 10, Municipal Law authorizes indebtedness up to a limit of 5% of the
equalized valuation. Debt issued in accordance with this section of the law is designated as being "inside the
debt limit". In addition, however, debt may be authorized in excess of that limit for specific purposes. Such debt,
when issued, is designated as being "outside the debt limit".
On June 1, 2017, the City issued $12,335,000 of general obligation bonds for various governmental projects. The
full $12.3 million of bond proceeds was recognized in the governmental funds.
Details related to the general obligation bonds outstanding at June 30, 2017, and the debt service requirements
are as follows:
Bonds Payable Schedule – Governmental Funds
Interest
Outstanding
Outstanding
Original
Maturities
Rate
at June 30,
at June 30,
Project
Borrowing
Through
(%)
2016
Issued
Redeemed
2017
Municipal Purpose - August 16, 2006 (Refunding)…$
11,230,000
2018
3.5% - 5.0%
$
3,850,000
$
-
$
2,610,000
$
1,240,000
Municipal Purpose - August 15, 2006………………..
3,795,000
2027
4.0% - 4.1%
2,730,000
-
345,000
2,385,000
MSBA - February 12, 2008……………………………
7,282,102
2033
7.1% - 8.0%
6,189,787
-
364,105
5,825,682
Municipal Purpose - February 1, 2009………………
3,030,000
2028
3.6% - 4.0%
2,015,000
-
330,000
1,685,000
Municipal Purpose - February 15, 2010………………
2,272,000
2028
2.0% - 5.0%
1,789,000
-
161,000
1,628,000
Municipal Purpose - April 1, 2010 (Refunding)………
13,407,000
2022
2.0% - 5.0%
9,051,500
-
1,511,500
7,540,000
Municipal Purpose - June 15, 2010………………..…
6,705,000
2029
2.0% - 5.0%
5,450,000
-
450,000
5,000,000
Municipal Purpose - February 23, 2011………………
5,020,000
2025
2.0% - 5.0%
3,320,000
-
330,000
2,990,000
Municipal Purpose - May 17, 2013………………..…
15,750,000
2042
2.0% - 5.0%
15,045,000
-
365,000
14,680,000
Municipal Purpose - October 9, 2013………………..
13,940,000
2033
2.0% - 5.0%
10,225,000
-
570,000
9,655,000
MSBA - September 25, 2013…………………………
6,250,000
2043
2.00%
5,818,964
-
215,518
5,603,446
Municipal Purpose - October 15, 2015………………
8,603,000
2038
2.125% - 5.0%
8,603,000
-
203,000
8,400,000
Municipal Purpose - October 5, 2016………………..
17,771,000
2039
2.0 - 4.0%
17,771,000
-
-
17,771,000
Municipal Purpose - June 1, 2017………………..……
1,235,000
2042
3.0 - 5.0%
-
12,335,000
-
12,335,000
Total bonds payable………………………………………………………………………………………………
91,858,251
12,335,000
7,455,123
96,738,128
Add: unamortized premium………………………………………………………………………………………
1,892,114
2,970,178
177,075
4,685,217
Total…………………………………………………………………………………………………………………$
93,750,365
$
15,305,178
$
7,632,198
$
101,423,345
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
65
Comprehensive Annual Financial Report
Debt service requirements for principal and interest for Governmental and Enterprise bonds payable in future
years are as follows:
Governmental Funds
Year
Principal
Interest
Total
2018……………… $
7,101,623
$
2,905,536
$
10,007,159
2019………………
6,015,623
2,662,706
8,678,329
2020………………
5,925,623
2,448,797
8,374,420
2021………………
6,285,622
2,248,909
8,534,531
2022………………
6,446,622
2,020,867
8,467,489
2023………………
4,921,622
1,778,127
6,699,749
2024………………
4,759,622
1,615,162
6,374,784
2025………………
4,644,622
1,456,726
6,101,348
2026………………
4,384,622
1,305,872
5,690,494
2027………………
4,499,622
1,175,811
5,675,433
2028………………
4,409,622
1,055,821
5,465,443
2029………………
3,779,622
944,412
4,724,034
2030………………
3,694,622
865,782
4,560,404
2031………………
3,144,622
788,163
3,932,785
2032………………
3,214,622
704,362
3,918,984
2033………………
3,314,624
614,586
3,929,210
2034………………
3,050,517
523,201
3,573,718
2035………………
2,365,517
450,975
2,816,492
2036………………
2,140,517
392,971
2,533,488
2037………………
2,200,517
332,528
2,533,045
2038………………
2,270,517
269,968
2,540,485
2039………………
1,905,517
212,352
2,117,869
2040………………
1,960,517
159,916
2,120,433
2041………………
2,015,517
105,756
2,121,273
2042………………
2,070,517
50,045
2,120,562
2043………………
215,518
4,310
219,828
Total……………… $
96,738,128
$ 27,093,656
$
123,831,784
Bonds Payable Schedule – Enterprise Funds
Interest
Outstanding
Outstanding
Original
Maturities
Rate
at June 30,
at June 30,
Project
Borrowing
Through
(%)
2016
Issued
Redeemed
2017
MWRA Notes……………………………………………$
7,584,424
2018
0.0%
$
284,413
$
-
$
189,608
$
94,805
Municipal Purpose August 15, 2006………………..…
1,500,000
2017
4.0%
150,000
-
150,000
-
Municipal Purpose - December 15, 2009……………
4,400,000
2019
2.0%
1,460,000
-
490,000
970,000
Municipal Purpose - February 15, 2010………………
1,910,000
2030
2.0% - 5.0%
1,241,000
-
109,000
1,132,000
Municipal Purpose - April 1, 2010 (Refunding)………
262,000
2022
2.0% - 5.0%
151,500
-
26,500
125,000
Municipal Purpose - February 23, 2013………………
424,000
2020
2.0% - 5.0%
210,000
-
50,000
160,000
MWRA Notes……………………………………………
1,336,000
2022
0.0%
801,600
-
133,600
668,000
MWRA Notes……………………………………………
1,242,340
2016
0.0%
869,638
-
124,234
745,404
MWRA Notes……………………………………………
875,000
2025
0.0%
787,500
-
87,500
700,000
MWRA Notes……………………………………………
138,000
2021
0.0%
138,000
-
27,600
110,400
MWRA Notes……………………………………………
1,660,000
2027
0.0%
-
1,660,000
-
1,660,000
Total Water Enterprise……………………………………………………………………...……………………
6,093,651
1,660,000
1,388,042
6,365,609
Municipal Purpose - March 15,2004…………………
1,229,551
2016
4.0%
-
-
-
-
Municipal Purpose - August 15, 2006………………..
2,070,000
2027
4.0%
1,065,000
-
105,000
960,000
Municipal Purpose - April 1, 2010 (Refunding)………
419,000
2022
2.0% - 5.0%
242,000
-
42,000
200,000
MWRA Notes……………………………………………
1,616,450
2017
0.0%
323,290
-
323,290
-
MWRA Notes……………………………………………
800,256
2019
0.0%
480,153
-
160,051
320,102
Total Sewer Enterprise………………………………………………………...…………………………………
2,110,443
-
630,341
1,480,102
Rink Enterprise Debt - October 9, 2013………………
13,940,000
2027
2.0% - 5.0%
2,290,000
-
185,000
2,105,000
Total…………………………………………………………………………………………………………………$
10,494,094
$
1,660,000
$
2,203,383
$
9,950,711
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
66
Comprehensive Annual Financial Report
Water Enterprise Fund
Year
Principal
Interest
Total
2018……………… $
1,302,739
$
50,640
$
1,353,379
2019………………
1,187,934
44,315
1,232,249
2020………………
702,934
39,115
742,049
2021………………
647,934
34,165
682,099
2022………………
624,334
30,435
654,769
2023………………
460,734
26,105
486,839
2024………………
333,500
23,200
356,700
2025………………
333,500
20,400
353,900
2026………………
246,000
17,400
263,400
2027………………
246,000
14,400
260,400
2028………………
80,000
11,200
91,200
2029………………
100,000
8,000
108,000
2030………………
100,000
4,000
104,000
Total……………… $
6,365,609
$
323,375
$
6,688,984
Sewer Enterprise Fund
Year
Principal
Interest
Total
2018……………… $
305,051
$
44,576
$
349,627
2019………………
305,051
38,976
344,027
2020………………
145,000
33,176
178,176
2021………………
145,000
27,776
172,776
2022………………
140,000
22,076
162,076
2023………………
95,000
16,129
111,129
2024………………
95,000
12,234
107,234
2025………………
105,000
8,134
113,134
2026………………
75,000
4,435
79,435
2027………………
70,000
1,444
71,444
Total……………… $
1,480,102
$
208,956
$
1,689,058
Rink Enterprise Fund
Year
Principal
Interest
Total
2018……………… $
195,000
$
83,250
$
278,250
2019………………
200,000
75,350
275,350
2020………………
205,000
69,044
274,044
2021………………
215,000
61,363
276,363
2022………………
190,000
51,238
241,238
2023………………
200,000
41,488
241,488
2024………………
210,000
31,238
241,238
2025………………
220,000
20,488
240,488
2026………………
230,000
11,394
241,394
2027………………
240,000
3,900
243,900
Total……………… $
2,105,000
$
448,750
$
2,553,750
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
67
Comprehensive Annual Financial Report
The Massachusetts Water Resource Authority (MWRA) operates an Infiltration/Inflow Financial Assistance
Program for community owned collection systems. For each community approved for the project, financial
assistance received from the MWRA consists of a non-interest bearing loan. At June 30, 2017, the outstanding
principal amount of these loans totaled $4.3 million. The imputed interest on these loans is immaterial and has
not been recognized by the City.
The Commonwealth has approved school construction assistance. The assistance program, which is
administered by the Massachusetts School Building Authority (MSBA), provides resources for future debt service
of general obligation school bonds outstanding. During 2017, $3,548,000 of such assistance was received.
Approximately $6,919,000 will be received in future years. Of this amount, approximately $1,651,000 represents
reimbursement of long-term interest costs, and approximately $5,268,000 represents reimbursement of approved
construction costs. Accordingly, a $5,268,000 intergovernmental receivable and corresponding unavailable
revenue have been reported in governmental fund financial statements. The unavailable revenue has been
recognized as revenue in the conversion to the government-wide financial statements.
Beginning in 2005, the Commonwealth changed the method for funding the school building assistance program.
Under the new program, the assistance is paid to support construction costs and reduce the total debt service of
the City. Through the end of 2017, the City has recorded capital grant proceeds totaling $13.8 million related to
the East Somerville Community School and $3.6 million related to the Somerville High School project, from the
MSBA, which is equal to 80% and 75.29%, respectively, of approved construction costs submitted for
reimbursement. The City anticipates receiving an additional $1.4 million related to the East Somerville
Community School project and $120.4 million related to the Somerville High School project. Accordingly, a $3.0
million intergovernmental receivable and corresponding deferred inflow of resources - unavailable revenue has
been reported in the governmental fund financial statements. This receivable relates to expenditures incurred
during 2017 and submitted for reimbursement from the MSBA. The unavailable revenue has been recognized as
revenue in the conversion to the government-wide financial statements.
The City is subject to various debt limits by statute and may issue additional general obligation debt under the
normal debt limit.
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
68
Comprehensive Annual Financial Report
At June 30, 2017, the City had the following authorized and unissued debt:
Purpose
Amount
Central Hill Memorial Park………………………………………………$
450,000
Veterans Memorial Ice Rink……………………………………………
950
Street Resurfacing………………………………………………………
15,979
Public Safety Building Repairs…..……………………………………
56,200
East Somerville Community School Remodeling……………………
10,422,563
Morse-Kelley Park Renovations………………………………………
2,445
Departmental Equipment (Radio)………………………………………
23,000
ISD Office Renovations…………………………………………………
15,000
Park Constructions………………………………………………………
500,000
Various School and City Building Improvements……………………
1,000,000
Departmental Equipment (Ladder Truck)……………………………
1,000
Recreation Dept. Vehicle………………………………………………
15,000
Network Infrastructure Replacement…………………………………
1,000
MWRA Infiltration & Inflow………………………………………………
90
DPW Equipment Replacement/ Street Sweeper……………………
876
DPW Salt Shed.…………………………………………………………
29,000
High School Feasibility Study & Schematic Design…………………
1,053,417
Computer Hardware & Software………………………………………
455,000
Citywide Bicycle & Pedestrian Upgrades……………………………
30,000
Street & Sidewalk Repairs………………………………………………
1,400,000
ADA Accessibility - Curb Ramp Installation and Improvements.……
578,465
ADA Accessibility Building Improvements.……………………………
300,000
West Branch Library Design & Engineering…………………………
275,000
DPW Snow Removal Equipment.………………………………………
9,425
Powderhouse Square Rotary Traffic Signal Improvements…………
250,000
Engine 7 Roof Replacement……………………………………………
120,000
IT Server Upgrade………………………………………………………
603,998
LED Light Conversion.…………………………………………………
2,475,000
Union Square Streetscape & Utility Early Action Project.……………
2,200,000
Fire Station Engine 3……………………………………………………
835,000
Hybrid DPW Refuse Tracks……………………………………………
250,000
Building Assessment/ Preventative Maintenance……………………
262,000
Cedar Street Water Repairs……………………………………………
2,227,500
Cedar Street Sewer Repairs……………………………………………
5,197,500
Nunziato Field Stormwater Project……………………………………
700,000
Lincoln Park Renovation………………………………………………
9,425,000
Sidewalk Improvements…………………………………………………
3,350,000
Beacon Street Reconstruction…………………………………………
1,500,000
East Broadway Streetscape……………………………………………
175,000
West Branch Library Rehabilitation……………………………………
3,385,000
Winter Hill Schoolyard & Nunziato Fields……………………………
275,000
Sewer Main Rehabilitation & Replacement……………………………
2,500,000
Water Main Rehabilitation & Replacement……………………………
4,200,000
Fire Pumper………………………………………………………………
544,182
DPW Capital Equipment & Vehicles……………………………………
1,245,340
MBTA Green Line Extenstion…………………………………………
50,000,000
High School Feasibility Study…………………………………………
192,000
U8 Winter Hill Community School Soccer Field………………………
375,000
Building Assessment/ Preventative Maintenance Plan………………
410,000
ADA Accessibility Building Improvements.……………………………
500,000
High School Construction………………………………………………
255,982,705
Winter Hill Community Innovation School Repairs……………………
3,968,259
Streets, Sidewalks, and ADA Ramp Improvements…………………
2,700,000
Total………………………………………………………………………$
372,482,894
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
69
Comprehensive Annual Financial Report
Calculation of Net Investment in Capital Assets
Governmental
Business-Type
Activities
Activities
Capital assets, net of accumulated depreciation…………………… $
232,316,828
$
56,452,786
Outstanding principal of related debt:
Long-term debt……………………………………………………
(101,423,345)
(9,950,711)
Short-term debt……………………………………………………
(39,043,332)
(9,000,000)
Add:
Deferred charges on refunding…………………………………
338,362
-
Unspent proceeds of capital debt………………………………
27,658,970
8,579,367
Noncapital-related debt (1)………………………………………
8,498,625
-
Net investment in capital assets……………………………………… $
128,346,108
$
46,081,442
(1)
School construction grant financing.
Changes in Long-term Liabilities
During the year ended June 30, 2017, the following changes occurred in long-term liabilities:
Balance
Balance
June 30,
June 30,
Current
2016
Additions
Reductions
2017
Portion
Governmental Activities:
Long-Term Bonds……..……………………… $
91,858,251
$
12,335,000
$
(7,455,123)
$
96,738,128
$
7,101,623
Add: Unamortized Premium…………………
1,892,114
2,970,178
(177,075)
4,685,217
508,970
Total Bonds Payable……………………………
93,750,365
15,305,178
(7,632,198)
101,423,345
7,610,593
Workers' Compensation………………………
1,264,000
505,910
(414,910)
1,355,000
338,750
Other Postemployment Benefits………………
114,117,612
21,702,998
(9,187,723)
126,632,887
-
Net Pension Liability……………………………
132,896,846
19,107,824
(13,544,742)
138,459,928
-
Compensated Absences………………………
3,892,700
54,079
(182,579)
3,764,200
159,509
Total………………………………………………$
345,921,523
$
56,675,989
$
(30,962,152) $
371,635,360
$
8,108,852
Balance
Balance
June 30,
June 30,
Current
2016
Additions
Reductions
2017
Portion
Business-Type Activities:
Long-Term Bonds……………………………… $
10,494,094
$
1,660,000
$
(2,203,383)
$
9,950,711
$
1,802,790
Other Postemployment Benefits…………...…
1,006,197
448,200
(1,070,843)
383,554
-
Net Pension Liability……………………………
1,378,948
494,448
(166,933)
1,706,463
-
Compensated Absences………………………
75,600
3,100
(15,200)
63,500
1,700
Total………………………………………………$
12,954,839
$
2,605,748
$
(3,456,359)
$
12,104,228
$
1,804,490
The long-term liabilities will be liquidated in the future by the general fund and enterprise funds.
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
70
Comprehensive Annual Financial Report
NOTE 9 – GOVERNMENTAL FUND BALANCE CLASSIFICATIONS
Massachusetts General Law Ch.40 §5B allows for the establishment of Stabilization funds for one or more
different purposes. The creation of a fund requires a two-thirds vote of the legislative body and must clearly
define the purpose of the fund. Any change to the purpose of the fund along with any additions to or
appropriations from the fund requires a two-thirds vote of the legislative body.
At year end the balance of the Rainy Day Stabilization fund if $4.1 million and reported as unassigned fund
balance within the general fund. The City’s remaining stabilization funds are for specific purposes and have been
reported as committed within the general fund.
GASB 54 provides for two major types of fund balances, which are Nonspendable and Spendable.
Nonspendable fund balances are balances that cannot be spent because they are not expected to be converted
to cash or they are legally or contractually required to remain intact. Examples of this classification are prepaid
items, inventories, and principal (corpus) of an endowment fund. The City has reported principal portions of
endowment funds as Nonspendable.
In addition to the Nonspendable fund balance, GASB 54 has provided a hierarchy of Spendable fund balances,
based on a hierarchy of spending constraints.
•
Restricted: fund balances that are constrained by external parties, constitutional provisions, or enabling
legislation.
•
Committed: fund balances that contain self-imposed constraints of the government from its highest level
of decision making authority.
•
Assigned: fund balances that contain self-imposed constraints of the government to be used for a
particular purpose.
•
Unassigned: fund balance of the general fund that is not constrained for any particular purpose
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
71
Comprehensive Annual Financial Report
As of June 30, 2017, the fund balances consisted of the following:
Strategic
Planning &
Capital
Nonmajor
Total
Community
Projects
Governmental
Governmental
General
Development
Funds
Funds
Funds
FUND BALANCES
Nonspendable:
Permanent fund principal……………………………………………$
-
$
-
$
-
$
433,126
$
433,126
Restricted for:
Strategic planning & community development……………………
-
14,265,004
-
-
14,265,004
School special revenue funds………………………………………
-
-
-
726,236
726,236
School federal grants…………………………………………………
-
-
-
106,539
106,539
School state & private grants ……………………………………..…
-
-
-
2,836,603
2,836,603
City federal grant funds……………………………………..………
-
-
-
6,107
6,107
City state grant funds……………………………………..…………
-
-
-
410,934
410,934
City revolving funds………………………………………….………
-
-
-
115,017
115,017
City receipts reserved……………………………………..…………
-
-
-
4,936,375
4,936,375
City Private grants……………………………………..……………
-
-
-
297,029
297,029
School lunch………………………………………….………………
-
-
-
871,194
871,194
Community preservation………………………………………….…
-
-
-
9,701,333
9,701,333
Other special revenue funds…………………………………………
-
-
-
5,896,584
5,896,584
Other permanent funds……………………………….………………
-
-
-
159,213
159,213
Committed to:
Health claims…………………………………………………………
16,289,127
-
-
-
16,289,127
Max-Pak stabilization fund…………………………………………
20,222
-
-
-
20,222
East Somerville stabilization fund…………………………………
103,239
-
-
-
103,239
Street Tree stabilization fund………………………………………
12,820
-
-
-
12,820
Alpine Restaurant stabilization fund………………………………
2,526
-
-
-
2,526
Rockwell Restaurant stabilization fund……………………………
9,105
-
-
-
9,105
Capital Projects stabilization fund…………………………………
4,499,444
-
-
-
4,499,444
Construction stabilization fund………………………………………
2,115,326
-
-
-
2,115,326
Traffic Safety stabilization fund………………………………………
398,423
-
-
-
398,423
Mitigation stabilization fund…………………………………………
232,809
-
-
-
232,809
270 Cedar Street LLC stabilization fund……………………………
1,009
-
-
-
1,009
Workforce Training stabilization fund………………………………
414
-
-
-
414
Bicycle stabilization fund…………………………………..…………
2,197
-
-
-
2,197
Linwood Street sidewalk improvement stabilization fund…………
11,823
-
-
-
11,823
Davis Square traffic and Sign stabilization fund…………………
286
-
-
-
286
Trash transfer station stabilization fund……………………………
148,988
-
-
-
148,988
Salary and wage stabilization fund…………………………………
5,648,388
-
-
-
5,648,388
Open space improvement stabilization fund………………………
95,277
-
-
-
95,277
Union square revitalization stabilization fund………………………
172,075
-
-
-
172,075
Facility construction & renovation stabilization fund………………
3,011,598
-
-
-
3,011,598
Street reconstruction & resurfacing stabilization fund……………
1,508,663
-
-
-
1,508,663
Millbrook stabilization…………………………………………………
47,945
-
-
-
47,945
Elmwood stabilization…………………………………………………
12,564
-
-
-
12,564
377 Broadway stabilization…………………………………………
4,316
-
-
-
4,316
Infiltration/Inflow stabilization………………………………………
185,413
-
-
-
185,413
Assigned to:
General government…………………………………………………
970,720
-
-
-
970,720
Public safety…………………………………………………………
276,808
-
-
-
276,808
Education………………………………………………………………
674,470
-
-
-
674,470
Public works………………………………………..…………………
1,877,285
-
-
-
1,877,285
Culture and recreation………………………………………………
107,701
-
-
-
107,701
Employee benefits……………………………………………………
833
-
-
-
833
Free cash used for the 2018 budget………………….……………
2,000,000
-
-
-
2,000,000
Unassigned………………………………………………………………
20,194,053
-
(11,385,014)
-
8,809,039
TOTAL FUND BALANCES (DEFICIT)……………………………………$
60,635,867
$
14,265,004
$
(11,385,014)
$
26,496,290
$
90,012,147
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
72
Comprehensive Annual Financial Report
NOTE 10 – RISK FINANCING
The City is exposed to various risks of loss related to torts; theft of, damage to and destruction of assets; errors
and omissions; and natural disasters for which the City carries commercial insurance.
The City participates in premium-based health care plans for its active employees and retirees through the Group
Insurance Commission. Claims have not exceeded insurance coverage for the last three years.
The City is self-insured for its workers’ compensation activities. These activities are accounted for in the General
Fund. Workers’ compensation claims are administered in house and are funded on a pay-as-you-go basis from
annual appropriations. The estimated future workers’ compensation liability is based on history and injury type.
At June 30, 2017, the amount of the liability for workers’ compensation claims totaled $1,355,000.
Changes in the reported liability since July 1, 2015, are as follows:
Current Year
Balance at
Claims and
Beginning of
Changes in
Claims
Balance at
Year
Estimate
Payments
End of Year
2016………………………$
1,255,000
$
385,995
$
(376,995)
$
1,264,000
2017………………………
1,264,000
505,910
(414,910)
1,355,000
NOTE 11 - PENSION PLAN
Plan Descriptions
The City is a member of the Somerville Contributory Retirement System (System), a cost-sharing multiple-
employer defined benefit pension plan covering eligible employees of the 2 member units. The System is
administered by five board members (Board) on behalf of all current employees and retirees except for current
teachers and retired teachers. Chapter 32 of the MGL assigns authority to establish and amend benefit
provisions of the plan. The System is a component unit and is reported as a pension trust fund in the fiduciary
fund financial statements. See Note 1 for more information.
The City is a member of the Massachusetts Teachers’ Retirement System (MTRS), a cost-sharing multi-employer
defined benefit plan. MTRS is managed by the Commonwealth of Massachusetts (Commonwealth) on behalf of
municipal teachers and municipal teacher retirees. The Commonwealth is a nonemployer contributor and is
responsible for 100% of the contributions and future benefit requirements of the MTRS. The MTRS covers
certified teachers in cities (except Boston), towns, regional school districts, charter schools, educational
collaboratives and Quincy College. The MTRS is part of the Commonwealth’s reporting entity and the audited
financial report may be obtained by visiting http://www.mass.gov/osc/publications-and-reports/financial-reports/.
Special Funding Situation
The Commonwealth is a nonemployer contributor and is required by statute to make 100% of all actuarially
determined employer contributions on behalf of the City to the MTRS. Therefore, the City is considered to be in a
special funding situation as defined by GASB Statement No. 68, Accounting and Financial Reporting for Pensions
and the Commonwealth is a nonemployer contributor in MTRS. Since the City does not contribute directly to
MTRS, there is no net pension liability to recognize. The total of the Commonwealth provided contributions have
been allocated based on each employer’s covered payroll to the total covered payroll of employers in MTRS as of
the measurement date of June 30, 2016. The City’s portion of the collective pension expense, contributed by the
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
73
Comprehensive Annual Financial Report
Commonwealth, of $14,596,546 is reported in the general fund as intergovernmental revenue and pension
benefits in the current fiscal year. The portion of the Commonwealth’s collective net pension liability associated
with the City is $143,094,195 as of the measurement date.
Benefits Provided
Both Systems provide retirement, disability, survivor and death benefits to plan members and beneficiaries.
Massachusetts Contributory Retirement System benefits are, with certain minor exceptions, uniform from system
to system. The Systems provide retirement allowance benefits up to a maximum of 80% of a member's highest
three-year average annual rate of regular compensation. For persons who became members on or after April 2,
2012, average salary is the average annual rate of regular compensation received during the five consecutive
years that produce the highest average, or, if greater, during the last five years (whether or not consecutive)
preceding retirement. Benefit payments are based upon a member's age, length of creditable service, level of
compensation, and group classification. Members become vested after ten years of creditable service. There
were no reported changes in pension benefit terms that effect measurement of the total pension liability as of
December 31, 2016.
Employees who resign from service and who are not eligible to receive a retirement allowance or are under the
age of 55 are entitled to request a refund of their accumulated total deductions. Survivor benefits are extended to
eligible beneficiaries of members whose death occurs prior to or following retirement.
Cost-of-living adjustments granted between 1981 and 1997 and any increase in other benefits imposed by the
Commonwealth’s state law during those years are borne by the Commonwealth and are deposited into the
pension fund. Cost-of-living adjustments granted after 1997 must be approved by the Board and are borne by the
System.
At December 31, 2016, the SCRS membership consists of the following:
Active members……………………………………………………
1,190
Inactive members…………………………………………………
446
Retirees and beneficiaries currently receiving benefits………
879
Total………………………………………………………………
2,515
Contributions
Chapter 32 of the MGL governs the contributions of plan members and member units. Active plan members are
required to contribute at rates ranging from 5% to 9% of gross regular compensation with an additional 2%
contribution required for compensation exceeding $30,000. The percentage rate is keyed to the date upon which
an employee's membership commences. The member units are required to pay into the SCRS a legislatively
mandated actuarial determined contribution that is apportioned among the employers based on active current
payroll. The total member units’ contribution for the year ended December 31, 2016 was $14,659,434, 20.52% of
covered payroll, actuarially determined as an amount that, when combined with plan member contributions, is
expected to finance the costs of benefits earned by plan members during the year, with an additional amount to
finance any unfunded accrued liability. The City’s proportionate share of the required contribution was
$13,711,675 which equaled its actual contribution.
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
74
Comprehensive Annual Financial Report
Pension Liabilities
The components of the net pension liability of the participating member units at June 30, 2017, were as follows:
Total pension liability…………………………… $
392,656,092
The pension plan's fiduciary net position……
(242,801,289)
The net pension liability………………………… $
149,854,803
The pension plan's fiduciary net postion as
a percentage of the total pension liability……
61.84%
At June 30, 2017, the City reported a liability of $140,166,391 for its proportionate share of the net pension
liability. The net pension liability was measured as of December 31, 2016, and the total pension liability used to
calculate the net pension liability was determined by an actuarial valuation as of January 1, 2016. The City’s
proportion of the net pension liability was based on a projection of the City’s long-term share of contributions to
the pension plan relative to the projected contributions of all participating members. At December 31, 2016, the
City’s proportion was 93.53%, which changed from its proportion measured at December 31, 2015, of 93.70%.
Pension Expense
For the year ended June 30, 2017, the City recognized a pension expense of $17,106,753. At June 30, 2017, the
City reported deferred outflows of resources related to pensions of $22,869,820, and deferred inflows of
resources related to pensions of $2,386,355.
The balances of deferred outflows and inflows at June 30, 2017 consist of the following:
Deferred
Deferred
Outflows
Inflows
Deferred Category
of Resources
of Resources
Total
Differences between expected and actual experience………… $
-
$
(2,190,396)
$
(2,190,396)
Changes of assumptions……………………………………………
2,088,412
-
2,088,412
Difference between projected and actual earnings………………
20,781,408
-
20,781,408
Changes in proportionate share of contributions…………………
-
(195,960)
(195,960)
Total Deferred Outflows/(Inflows) of Resources…………………$
22,869,820
$
(2,386,356)
$
20,483,464
The deferred outflows of resources related to pensions will be recognized in pension expense as follows:
Year ended June 30:
2018………………………………………………$
6,603,667
2019………………………………………………
6,603,666
2020………………………………………………
5,448,365
2021………………………………………………
1,827,766
Total………………………………………………$
20,483,464
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
75
Comprehensive Annual Financial Report
Actuarial Assumptions
The total pension liability in the January 1, 2017, actuarial valuation was determined using the following actuarial
assumptions:
Valuation date……………………………………January 1, 2017
Actuarial cost method……………………………Individual Entry Age Normal Cost Method.
Amortization method……………………………Payments increasing at 3.5%
Remaining amortization period…………………Increasing amortization at 3.5% of unfunded actuarial accrued liability
over 16 years completed by June 30, 2033,
2 years by June 30, 2019 for the 2002 Early
Retirement Incentive, and 3 years by
June 30, 2020 for 2003 Early Retirement Incentive.
Asset valuation method…………………………The actuarial value of assets is determined using a five-year
smoothing of asset returns greater than or less than the
assumed rate of return, with a 20% corridor.
Inflation rate………………………………………4.00%
Projected salary increases………………………It is assumed that salaries including longevity will increase at a
rate of 3.00% per year.
Cost of living adjustments………………………2.5% of the first $13,000 of retirement income.
Rates of retirement………………………………Varies based upon age for general employees, police
and fire employees.
Rates of disability…………………………………For general employees, it was assumed that 40% of all
disabilities are ordinary (60% are service connected).
For police and fire employees, 10% of all disabilities are
assumed to be ordinary (90% are service connected).
Mortality Rates:
Pre-Retirement………………………The RP-2014 Blue Collar Mortality Table projected generationally
with a Scale MP-2015.
Healthy Retiree………………………Groups 1 & 2, the RP-2014 Blue Collar Mortality Table set forward five
years for males and three years for females. Group 4, the RP-2014
Blue Collar Mortality Table set forward three years fro males and
six years fro females, fully generational.
Disabled Retiree……………………The RP-2000 Mortality Table set forward two years
for all disabled members only projected generationally
with Scale MP-2015.
Investment rate of return/Discount rate……… 8.00%, compounded annual rate
Investment policy
The pension plan’s policy in regard to the allocation of invested assets is established and may be amended by the
Board. Plan assets are managed on a total return basis with a long-term objective of achieving and maintaining a
fully funded status for the benefits provided through the pension plan.
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
76
Comprehensive Annual Financial Report
The long-term expected rate of return on pension plan investments was determined using a building-block method
in which best-estimate ranges of expected future real rates of return (expected returns, net of pension plan
investment expense and inflation) are developed for each major asset class. These ranges are combined to
produce the long-term expected rate of return by weighting the expected future real rates of return by the target
asset allocation percentage and by adding expected inflation. Best estimates of arithmetic real rates of return for
each major asset class included in the pension plan’s target asset allocation as of January 1, 2016, are
summarized in the following table:
Target
Long-Term Expected
Asset Class
Allocation
Real Rate of Return
Cash………………………………………………
0%-10%
2.75%
Equities - Large Cap………………………………
45%-65%
9.00%
Equities - Small Cap………………………………
0%-10%
9.00%
Equities - Multi Cap………………………………
0%-5%
9.00%
Fixed Income - Investment Grade………………
35%-45%
5.50%
Fixed Income - Below Investment Grade………
3%-7%
6.00%
Real Estate…………………………………………
0%-15%
7.50%
Venture Capital……………………………………
0%-5%
9.00%
International………………………………………
0%-15%
8.00%
Emerging Markets…………………………………
0%-3%
9.00%
Foreign Bonds……………………………………
0%-1%
5.00%
Rate of return
For the year ended December 31, 2016, the annual money-weighted rate of return on pension plan investments,
net of pension plan investment expense, was 3.73%. The money-weighted rate of return expresses investment
performance, net of investment expense, adjusted for the changing amounts actually invested.
Discount rate
The discount rate used to measure the total pension liability at June 30, 2017, was 8.00%, which changed from
8.25% at June 30, 2016. The projection of cash flows used to determine the discount rate assumed plan member
contributions will be made at the current contribution rate and that contributions will be made at rates equal to the
actuarially determined contribution rate. Based on those assumptions, the pension plan’s fiduciary net position
was projected to be available to make all projected future benefit payments of current plan members. Therefore,
the long-term expected rate of return on pension plan investments was applied to all periods of projected benefit
payments to determine the total pension liability.
Sensitivity of the net pension liability to changes in the discount rate
The following presents the net pension liability, calculated using the discount rate of 8.00%, as well as what the
net pension liability would be if it were calculated using a discount rate that is 1-percentage-point lower (7.00%) or
1-percentage-point higher (9.00%) than the current rate:
Current
1% Decrease
Discount
1% Increase
(7.00%)
(8.00%)
(9.00%)
The City's proportionate
share of the net pension liability…………………… $
176,500,252
$
140,166,391
$
109,081,244
System total net pension liability………………………$
188,700,109
$
149,854,804
$
116,621,039
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
77
Comprehensive Annual Financial Report
Noncontributory Retirement Allowance – The City pays the entire retirement allowance for certain retirees who
are eligible for noncontributory benefits and are not members of the System. The general fund expenditure for
2017 totaled $121,000.
Changes in Assumptions
The discount rate has changed from 8.25% to 8.00%.
Annual rates of withdrawal prior to retirement have been adjusted based on experience, for both general
employees and police and fire employees.
Annual rate of mortality tables used have been updated.
The assumed annual retirement rates for those hired prior to April 2, 2012, have been updated.
The assumed annual retirement rates for those hired on or after April 2, 2012, have been updated.
The assumed annual rates of disability for both general employees and police and fire employees have been
updated.
The annual amount of administrative expenses has been increased to $450,000, and is expected to increase at
4% per year.
Changes in Plan Provisions
The maximum amount of pension benefits subject to a cost of living increase has been raised from $12,000 to
$13,000.
NOTE 12 – POSTEMPLOYMENT BENEFITS OTHER THAN PENSIONS
Plan Description – The City of Somerville administers a single-employer defined benefit healthcare plan (“Plan”).
The Plan provides health, dental and life insurance for eligible retirees and their spouses through a single-
employer defined Other Postemployment Benefit (OPEB) plan. The Plan is administered through the Group
Insurance Commission (GIC) as of January 1, 2012. The Plan provides lifetime healthcare and life insurance for
eligible retirees and their spouses through the City’s group health, life and GIC health plans which covers both
active and retired members. Chapter 32b, Section 19, of the MGL, and an agreement between the City and the
Public Employee Committee (PEC) which is subject to renegotiation at the end of each contract period provides
the authority to establish and amend benefit provisions of the Plan. The Plan does not issue a publicly available
financial report. The employers share is based on the type of plan the employee/retiree is enrolled in. For all
HMO and PPO plans, the employer contributes 80% of the premium and for all indemnity plans, the employer
contributes 75% of the premium. The City’s assessment of the employer’s share by the GIC, for retired teachers,
for 2017 totaled $2,819,000.
Funding Policy – Contribution requirements are also negotiated between the City and the PEC. The required
contribution is based on a pay-as-you-go financing requirement. The City contributes 80% of the premium for all
HMO and PPO plans and 75% of the premium for all indemnity plans per the Chapter 32b, Section 19 PEC
Agreement and the retiree’s will contribute the remaining 20% for all HMO and PPO plans and 25% for all
indemnity plans. For 2017, the City’s benefit payments totaled $9,258,566, and the City contributed another $1.0
million to the OPEB Trust fund. For the year ended June 30, 2017, the City’s average contribution rate was
12.63% of covered-employee payroll. Plan members are not required to contribute to the Plan.
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
78
Comprehensive Annual Financial Report
The Commonwealth of Massachusetts passed special legislation that has allowed the City to establish a
postemployment benefit trust fund and to enable the City to raise taxes necessary to begin pre-funding its OPEB
liabilities.
During 2017, the City pre-funded future OPEB liabilities by contributing $1,000,000 of funds to the Other
Postemployment Benefit Fund in excess of the pay-as-you-go required contribution. These funds are reported
within the Fiduciary Funds financial statements. As of June 30, 2017, the balance of this fund totaled $1.8 million.
The annual money-weighted rate of return on OPEB plan investments was 0.92%. The money-weighted rate of
return expresses investment performance, net of OPEB plan investment expense, adjusted for the changing
amounts actually invested.
Plan Membership – The following table represents the Plan’s membership at June 30, 2017:
Active members………………………………………………
1,719
Inactive employees or beneficiaries currently
receiving benefits…………………………………………
1,676
Total……………………………………………………………
3,395
Components of OPEB Liability – The following table represents the components of the Plan’s OPEB liability as of
June 30, 2017:
Total OPEB liability……………………………………………$
304,074,941
Less: OPEB plan's fiduciary net position……………………
(1,821,275)
Net OPEB liability………………………………………………$
302,253,666
The OPEB plan's fiduciary net position
as a percentage of the total OPEB liability………………
0.60%
Significant Actuarial Methods and Assumptions – The total OPEB liability in the June 30, 2016 actuarial valuation
was determined by using the following actuarial assumptions, applied to all periods including the measurement
date that was updated to June 30, 2017, to be in accordance with GASB #74.
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
79
Comprehensive Annual Financial Report
Valuation date……………………………………… June 30, 2017
Actuarial cost method…………………………… Individual Entry Age Normal
Asset valuation method…………………………… Market Value
Single equivalent discount rate…………………… 3.75% per year, net of investment expenses
Healthcare cost trend rate………………………… 6.0% decreasing by 0.5% each year to 4.5% for periods starting in 2017
Participation………………………………………… 95% of future retiree teachers are assumed to participate in the retiree
medical plan, 95% of future non-teacher retires are expected to
participate in the retiree medical plan and 100% of future retirees are
expected to elect life insurance.
Marital Status……………………………………… 60% of male employees and 50% of female employees are assumed to
have a covered spouse at retirement. Wives are assumed to be three
years younger than their husbands.
Pre-Retirement mortality………………………… RP-2014 Blue Collar Mortality with Scale MP-2015, fully generational.
Post-Retirement mortality…………………………
Group 1 and 2 is represented by the RP-2014 Blue Collar Mortality Table set
forward 5 years for males and 3 years for females, fully generational. Group 4 is
represented by the RP-2014 Blue Collar Mortality Table set forward 3 years for
males and 6 years for females, fully generational.
Disabled mortality…………………………………
Group 1 and 2 is represented by the RP-2000 Mortality Table set forward 6
years. Group 4 is represented by the RP-2000 Mortality Table set forward 2
years.
Investment policy
The City’s policy in regard to the allocation of invested assets is established and may be amended by the Board
of Aldermen by a majority vote of its members. The OPEB plan’s assets are managed on a total return basis with
a long-term objective of achieving and maintaining a fully funded status for the benefits provided through the
OPEB plan. The long-term real rate of return on OPEB investments was determined using the City’s investment
policy.
The long-term expected rate of return on OPEB plan investments was determined using a building-block method
in which best-estimate ranges of expected future real of returns (expected returns, net of pension plan investment
expense and inflation) are developed for each major asset class. These ranges are combined to produce the
long-term expected rate of return of by weighting the expected future real rates of return by the target asset
allocation percentage and by adding expected inflation. Currently, the Plan is holding 100% of its trust fund
assets in cash, which has an expected return of 0.0%. The City is expected to develop a long-term investment
policy in the future.
Discount Rate – The discount rate was selected based on a projection of employer and employee contributions,
benefit payments (with and without subsidy), expenses and the long term expected rate of return on trust assets.
Based on these assumptions, the OPEB’s plan’s Fiduciary Net Position was projected to be available to make all
projected future benefit payments of current plan members. Therefore, the long-term expected rate of return on
OPEB plan investments was applied to all periods of projected benefit payments to determine the total OPEB
liability.
Sensitivity of the net position liability to changes in the discount rate – The following table presents the net other
postemployment benefit liability and service cost, calculated using the discount rate of 3.75%, as well as what the
net other postemployment benefit liability and service cost would be if it were calculated using a discount rate that
is 1-percentage-point lower 2.75% or 1-percentage-point higher 4.75% than the current rate.
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
80
Comprehensive Annual Financial Report
Current
1% Decrease
Discount Rate
1% Increase
(2.75%)
(3.75%)
(4.75%)
Net OPEB liability…………………………… $
356,104,376
$
302,253,666
$
259,824,708
Sensitivity of the net position liability to changes in the healthcare trend – The following table presents the net
other postemployment benefit liability and service cost, calculated using the current healthcare trend rate of
6.00%, as well as what the net other postemployment benefit liability and service cost would be if it were
calculated using a healthcare trend rate that is 1-percentage-point lower (5.00%) or 1-percentage-point higher
(7.00%).
1% Decrease
Current Trend
1% Increase
(5.00%)
(6.00%)
(7.00%)
Net OPEB liability…………………………… $
253,770,398
$
302,253,666
$
365,627,543
Annual OPEB Cost and Net OPEB Obligation – The City’s annual OPEB cost (expense) is calculated based on
the annual required contribution of the employer (ARC), an amount actuarially determined in accordance with the
parameters of GASB Statement #45. The ARC represents a level of funding that, if paid on an ongoing basis, is
projected to cover the normal cost each year and amortize any unfunded actuarial liabilities (or funding excess)
over a period not to exceed thirty years.
The components of the City’s annual OPEB cost for the year, the amount actually contributed to the plan, and
changes in the City’s net OPEB obligation are summarized in the table that follows:
Annual Required Contribution………………………………… $
21,086,425
Interest on existing net OPEB obligation………………………
4,604,952
Adjustments to annual required contribution…………………
(3,837,460)
Annual OPEB cost (expense)………………………………
21,853,917
Contributions made………………………………………………
(10,258,566)
Increase in net OPEB obligation………………………………
11,595,351
Net OPEB obligation-beginning of year………………………
115,123,809
Net OPEB obligation-end of year………………………………$
126,719,160
The sewer fund is reporting an other postemployment benefits asset in the amount of $297,281 as the result of a
$500,000 contribution to the OPEB Trust in 2017.
The City’s annual OPEB cost, the percentage of annual OPEB cost contributed to the plan, and the net OPEB
obligation for 2017 and the previous two years was as follows:
Year
Annual
Annual OPEB
Net OPEB
Ended
OPEB Cost
Cost Contributed
Obligation
6/30/2017
$
21,853,917
47%
$
126,719,160
6/30/2016
20,854,172
41%
115,123,809
6/30/2015
20,365,492
47%
102,803,133
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
81
Comprehensive Annual Financial Report
Funded Status and Funding Progress
As of June 30, 2016, the most recent actuarial valuation date, the actuarial value of assets totaled $813,768, the
actuarial accrued liability for benefits was $302.6 million and $301.8 million of which was unfunded. The covered
payroll (annual payroll of active employees covered by the plan) was $149.2 million, and the ratio of the UAAL to
the covered payroll was 202.3 percent.
Actuarial valuations of an ongoing plan involve estimates of the value of reported amounts and assumptions
about the probability of occurrence of events far into the future. Examples include assumptions about future
employment, mortality, and the healthcare cost trend. Amounts determined regarding the funded status of the
plan and the annual required contributions of the employer are subject to continual revision as actual results are
compared with past expectations and new estimates are made about the future. The schedule of funding
progress, presented as required supplementary information following the notes to the financial statements,
presents multiyear trend information about whether the actuarial value of plan assets is increasing or decreasing
over time relative to the actuarial accrued liabilities for benefits.
Actuarial Methods and Assumptions - Projections of benefits for financial reporting purposes are based on the
substantive plan (the plan as understood by the employer and the plan members) and include the types of
benefits provided at the time of each valuation and the historical pattern of sharing of benefit costs between the
employer and plan members to that point. The actuarial methods and assumptions used include techniques that
are designed to reduce the effects of short-term volatility in actuarial accrued liabilities and the actuarial value of
assets, consistent with the long-term perspective of the calculations.
In the June 30, 2016, actuarial valuation, actuarial liabilities were determined using the projected unit credit cost
method. The actuarial assumptions included a 4.0% investment return assumption, which is based on the
expected yield on the assets of the City, calculated based on the funded level of the plan at the valuation date,
projected salary increases of 4.0% per year, and an annual medical/drug cost trend rate of 6% initially, graded to
4.5% over 4 years, and an inflation rate of 6% initially, graded to 4.5% over 4 years. The UAAL is being
amortized over a 30 year open period, with amortization payments increasing at 4% per year. The remaining
amortization period at June 30, 2017, is 30 years.
NOTE 13 - COMMITMENTS
The City has entered into an agreement with Wheelabrator Saugus, Inc. to direct the acceptable waste it collects
to a transfer station. The City is charged a flat rate per ton that is subject to increase annually equal to but not to
exceed any average net increase in the Consumer Price Index for Urban Wage Earners. There are no minimum
tonnage requirements that the City must comply with.
The School Department has entered into an agreement with S. P. & R. Transportation, Inc. to provide for the
transportation of its students. The contract bears an annual cost of approximately $2.3 million and expires on
June 30, 2019.
The City has entered into, or is planning to enter into, contracts totaling approximately $513.9 million. The Union
Square streetscape and utility improvements, Somerville High School reconstruction, new fire and police stations,
and various street and sidewalk projects throughout the City are some of the major projects that the City will be
completing.
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
82
Comprehensive Annual Financial Report
NOTE 14 - CONTINGENCIES
The City participates in a number of federal award programs. Although the grant programs have been audited in
accordance with the provisions of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative
Requirements, Cost Principles, and Audit Requirements for Federal Awards through June 30, 2017, these
programs are still subject to financial and compliance audits. The amount, if any, of expenditures which may be
disallowed by the granting agencies cannot be determined at this time, although it is expected such amounts, if
any, to be immaterial.
Various legal actions and claims are pending. Litigation is subject to many uncertainties, and the outcome of
individual litigated matters is not always predictable. Although the amount of liability, if any, at June 30, 2017,
cannot be ascertained, management believes any resulting liability should not materially affect the financial
position at June 30, 2017.
NOTE 15 – SUBSEQUENT EVENTS
Management has evaluated subsequent events through December 20, 2017, which is the date the financial
statements were available to be issued.
NOTE 16 – IMPLEMENTATION OF NEW GASB PRONOUNCEMENTS
During 2017, the following GASB pronouncements were implemented:
•
GASB Statement #74, Financial Reporting for Postemployment Benefit Plans Other Than Pension Plans.
The basic financial statements, related notes and required supplementary information were updated to be
in compliance with this pronouncement.
•
GASB Statement #77, Tax Abatement Disclosures. This pronouncement did not impact the basic
financial statements.
•
GASB Statement #78, Pensions Provided through Certain Multiple-Employer Defined Benefit Pension
Plans. This pronouncement did not impact the basic financial statements.
•
GASB Statement #80, Blending Requirements for Certain Component Units – an amendment of GASB
Statement #14. This pronouncement did not impact the basic financial statements.
•
GASB Statement #82, Pension Issues – an amendment of GASB Statements #67, #68, and #73. The
basic financial statements and related notes were updated to be in compliance with this pronouncement.
The following GASB pronouncements will be implemented in the future:
•
The GASB issued Statement #75, Accounting and Financial Reporting for Postemployment Benefits
Other Than Pensions, which is required to be implemented in 2018.
•
The GASB issued Statement #81, Irrevocable Split-Interest Agreements, which is required to be
implemented in 2018.
•
The GASB issued Statement #83, Certain Asset Retirement Obligations, which is required to be
implemented in 2019.
Notes to Basic Financial Statements Year Ended June 30, 2017
City of Somerville, Massachusetts
83
Comprehensive Annual Financial Report
•
The GASB issued Statement #84, Fiduciary Activities, which is required to be implemented in 2020.
•
The GASB issued Statement #85, Omnibus 2017, which is required to be implemented in 2018.
•
The GASB issued Statement #86, Certain Debt Extinguishment Issues, which is required to be
implemented in 2018.
•
The GASB issued Statement #87, Leases, which is required to be implemented in 2021.
Management is currently assessing the impact the implementation of these pronouncements will have on the
basic financial statements.
City of Somerville, Massachusetts
84
Comprehensive Annual Financial Report
Required Supplementary Information
Required Supplementary Information
Amounts
Current Year
Actual
Amounts
Variance
Carried forward
Initial
Original
Final
Budgetary
Carried Forward
To Final
From Prior Year
Budget
Budget
Budget
Amounts
To Next Year
Budget
REVENUES:
Real estate and personal property taxes,
net of tax refunds…………………………………………… $
-
$
134,362,677
$
134,362,677
$
134,362,677
$
134,169,221
$
-
$
(193,456)
Tax liens………………………………………………………
-
-
-
-
392,962
-
392,962
Motor vehicle and other excise taxes………………………
-
9,590,848
9,590,848
9,590,848
9,297,090
-
(293,758)
Payments in lieu of taxes……………………………………
-
808,000
808,000
808,075
1,248,682
-
440,607
Intergovernmental……………………………………………
-
49,976,226
49,976,226
49,976,226
50,665,533
-
689,307
Departmental and other………………………………………
-
20,471,199
20,471,199
20,471,124
20,835,081
-
363,957
Investment income……………………………………………
-
210,000
210,000
210,000
325,743
-
115,743
Miscellaneous…………………………………………………
-
-
-
-
37,404
-
37,404
TOTAL REVENUES………………………………………
-
215,418,950
215,418,950
215,418,950
216,971,716
-
1,552,766
EXPENDITURES:
GENERAL GOVERNMENT
Board of Alderman
Salaries………………………………………………………
-
455,923
455,923
455,923
456,473
-
(550)
Expenses……………………………………………………
251
40,660
40,911
40,865
38,866
-
1,999
TOTAL………………………………………………………
251
496,583
496,834
496,788
495,339
-
1,449
Clerk of Committees
Salaries………………………………………………………
-
74,244
74,244
74,244
73,134
-
1,110
Expenses……………………………………………………
-
1,000
1,000
1,000
-
-
1,000
TOTAL………………………………………………………
-
75,244
75,244
75,244
73,134
-
2,110
Executive Office
Salaries………………………………………………………
-
3,086,820
3,086,820
3,086,820
2,908,521
-
178,299
Expenses……………………………………………………
135,215
657,667
792,882
792,839
644,727
118,946
29,166
Special Items…………………………………………………
-
216,500
216,500
216,500
183,166
1,098
32,236
Capital………………………………………………………
54,010
225,000
279,010
276,644
157,112
85,615
33,917
TOTAL………………………………………………………
189,225
4,185,987
4,375,212
4,372,803
3,893,526
205,659
273,618
Auditor's Office
Salaries………………………………………………………
-
790,935
790,935
790,935
751,685
-
39,250
Expenses……………………………………………………
125,555
112,325
237,880
237,101
124,211
110,829
2,061
TOTAL………………………………………………………
125,555
903,260
1,028,815
1,028,036
875,896
110,829
41,311
Grants Management
Salaries………………………………………………………
-
149,299
149,299
149,299
148,779
-
520
Expenses……………………………………………………
10,000
5,776
15,776
5,776
3,489
-
2,287
TOTAL………………………………………………………
10,000
155,075
165,075
155,075
152,268
-
2,807
Purchasing
Salaries………………………………………………………
-
395,044
395,044
395,044
325,033
-
70,011
Expenses……………………………………………………
285
38,050
38,335
38,050
26,346
-
11,704
TOTAL………………………………………………………
285
433,094
433,379
433,094
351,379
-
81,715
Assessing
Salaries………………………………………………………
-
538,953
538,953
527,780
521,653
-
6,127
Expenses……………………………………………………
-
121,890
121,890
133,063
114,708
-
18,355
TOTAL………………………………………………………
-
660,843
660,843
660,843
636,361
-
24,482
Treasurer's/Collector's Office
Salaries………………………………………………………
-
662,214
662,214
662,214
607,001
-
55,213
Expenses……………………………………………………
30,632
264,990
295,622
274,962
241,827
2,768
30,367
TOTAL………………………………………………………
30,632
927,204
957,836
937,176
848,828
2,768
85,580
Law Department
Salaries………………………………………………………
-
696,862
696,862
671,862
667,774
-
4,088
Expenses……………………………………………………
75,745
175,275
251,020
686,020
639,321
43,023
3,676
TOTAL………………………………………………………
75,745
872,137
947,882
1,357,882
1,307,095
43,023
7,764
Personnel Department
Salaries………………………………………………………
-
796,646
796,646
796,646
785,940
-
10,706
Expenses……………………………………………………
20,858
318,700
339,558
327,813
174,679
23,280
129,854
Special Items…………………………………………………
-
60,000
60,000
60,000
30,854
-
29,146
TOTAL………………………………………………………
20,858
1,175,346
1,196,204
1,184,459
991,473
23,280
169,706
(Continued)
GENERAL FUND
SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE -
BUDGET AND ACTUAL
YEAR ENDED JUNE 30, 2017
Budgeted Amounts
City of Somerville, Massachusetts
85
Comprehensive Annual Financial Report
Amounts
Current Year
Actual
Amounts
Variance
Carried forward
Initial
Original
Final
Budgetary
Carried Forward
To Final
From Prior Year
Budget
Budget
Budget
Amounts
To Next Year
Budget
GENERAL FUND
SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE -
BUDGET AND ACTUAL
YEAR ENDED JUNE 30, 2017
Budgeted Amounts
Information Technology
Salaries………………………………………………………
-
733,595
733,595
710,300
626,580
-
83,720
Expenses……………………………………………………
75,977
1,593,934
1,669,911
1,659,143
1,342,262
268,435
48,446
TOTAL………………………………………………………
75,977
2,327,529
2,403,506
2,369,443
1,968,842
268,435
132,166
Communications
Salaries………………………………………………………
-
335,596
335,596
335,596
330,749
-
4,847
Expenses……………………………………………………
-
23,125
23,125
23,125
19,237
2,079
1,809
TOTAL………………………………………………………
-
358,721
358,721
358,721
349,986
2,079
6,656
City Clerk
Salaries………………………………………………………
-
431,782
431,782
431,782
427,585
-
4,197
Expenditures…………………………………………………
6,097
153,737
159,834
158,558
130,253
13,522
14,783
TOTAL………………………………………………………
6,097
585,519
591,616
590,340
557,838
13,522
18,980
Elections
Salaries………………………………………………………
-
506,774
506,774
475,197
409,946
-
65,251
Expenditures…………………………………………………
-
120,145
120,145
120,145
97,201
-
22,944
Capital………………………………………………………
-
-
31,577
-
24,077
7,500
TOTAL………………………………………………………
-
626,919
626,919
626,919
507,147
24,077
95,695
Licensing Committee
Salaries………………………………………………………
-
10,800
10,800
10,800
9,000
-
1,800
Community Development
Salaries………………………………………………………
-
4,367,226
4,367,226
4,367,226
4,087,598
-
279,628
Expenses……………………………………………………
75,745
960,718
1,036,463
1,100,735
755,846
276,958
67,931
Capital………………………………………………………
-
-
-
-
-
-
-
TOTAL………………………………………………………
75,745
5,327,944
5,403,689
5,467,961
4,843,444
276,958
347,559
Veterans Benefits
Salaries………………………………………………………
-
121,294
121,294
121,294
120,795
-
499
Expenses……………………………………………………
-
634,035
634,035
634,035
562,224
90
71,721
TOTAL………………………………………………………
-
755,329
755,329
755,329
683,019
90
72,220
Building Insurance
Expenses……………………………………………………
-
460,058
460,058
460,058
398,067
-
61,991
Person and Property Insurance
Expenditures…………………………………………………
-
175,000
175,000
65,000
53,800
-
11,200
Contingency Account
Expenses……………………………………………………
-
1,302,835
1,302,835
190,132
132,209
-
57,923
Total General Government……………………………………
610,370
21,815,427
22,425,797
21,596,103
19,128,651
970,720
1,496,732
PUBLIC SAFETY
Police Department
Salaries………………………………………………………
-
15,221,614
15,221,614
17,443,056
16,916,919
-
526,137
Expenses……………………………………………………
22,530
667,616
690,146
646,399
490,519
67,952
87,928
Special Items…………………………………………………
-
51,314
51,314
51,314
43,200
-
8,114
TOTAL………………………………………………………
22,530
15,940,544
15,963,074
18,140,769
17,450,638
67,952
622,179
Fire Department
Salaries………………………………………………………
-
16,645,304
16,645,304
16,645,304
15,820,464
2,350
822,490
Expenses……………………………………………………
7,776
458,600
466,376
465,027
363,036
41,819
60,172
Special Items…………………………………………………
-
2,500
2,500
2,500
924
-
1,576
TOTAL………………………………………………………
7,776
17,106,404
17,114,180
17,112,831
16,184,424
44,169
884,238
Emergency Management
Salaries………………………………………………………
-
20,747
20,747
20,747
20,747
-
-
Expenses……………………………………………………
-
5,700
5,700
5,700
5,491
-
209
TOTAL………………………………………………………
-
26,447
26,447
26,447
26,238
-
209
Animal Control
Salaries………………………………………………………
-
104,581
104,581
104,581
103,594
-
987
Expenses……………………………………………………
1,149
19,050
20,199
20,169
10,661
3,186
6,322
TOTAL………………………………………………………
1,149
123,631
124,780
124,750
114,255
3,186
7,309
Traffic and Parking
Salaries………………………………………………………
-
2,561,292
2,561,292
2,561,292
2,503,714
-
57,578
Expenses……………………………………………………
229,734
1,543,701
1,773,435
1,764,775
1,624,005
92,618
48,152
Capital………………………………………………………
-
-
-
50,629
-
50,629
-
TOTAL………………………………………………………
229,734
4,104,993
4,334,727
4,376,696
4,127,719
143,247
105,730
(Continued)
City of Somerville, Massachusetts
86
Comprehensive Annual Financial Report
Amounts
Current Year
Actual
Amounts
Variance
Carried forward
Initial
Original
Final
Budgetary
Carried Forward
To Final
From Prior Year
Budget
Budget
Budget
Amounts
To Next Year
Budget
GENERAL FUND
SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE -
BUDGET AND ACTUAL
YEAR ENDED JUNE 30, 2017
Budgeted Amounts
Board of Health
Salaries………………………………………………………
-
2,062,712
2,062,712
2,062,712
1,855,958
-
206,754
Expenses……………………………………………………
125,935
471,942
597,877
715,027
636,340
18,254
60,433
TOTAL………………………………………………………
125,935
2,534,654
2,660,589
2,777,739
2,492,298
18,254
267,187
Total Public Safety………………………………………………
387,124
39,836,673
40,223,797
42,559,232
40,395,572
276,808
1,886,852
EDUCATION
Operational…………………………………………………
569,554
65,420,081
65,989,635
65,891,347
65,062,143
674,470
154,734
PUBLIC WORKS
Administration
Salaries………………………………………………………
-
621,347
621,347
621,347
547,378
-
73,969
Expenses……………………………………………………
76,460
921,600
998,060
846,752
648,151
102,399
96,202
TOTAL………………………………………………………
76,460
1,542,947
1,619,407
1,468,099
1,195,529
102,399
170,171
Electrical
Salaries………………………………………………………
-
344,924
344,924
344,924
312,680
-
32,244
Expenses……………………………………………………
61,669
233,500
295,169
286,036
223,611
28,576
33,849
TOTAL………………………………………………………
61,669
578,424
640,093
630,960
536,291
28,576
66,093
Engineering
Salaries………………………………………………………
-
178,757
178,757
178,757
160,928
-
17,829
Expenses……………………………………………………
63,046
255,588
318,634
299,812
201,324
86,585
11,903
TOTAL………………………………………………………
63,046
434,345
497,391
478,569
362,252
86,585
29,732
Snow Removal
Expenses……………………………………………………
-
1,286,000
1,286,000
2,379,140
2,199,792
-
179,348
Highway
Salaries………………………………………………………
-
2,320,697
2,320,697
2,559,997
2,399,320
-
160,677
Expenses……………………………………………………
239,167
1,353,095
1,592,262
1,480,473
1,141,208
113,526
225,739
TOTAL………………………………………………………
239,167
3,673,792
3,912,959
4,040,470
3,540,528
113,526
386,416
Sanitation
Expenditures…………………………………………………
370,005
5,675,208
6,045,213
5,474,435
5,050,258
10,902
413,275
Building and Grounds
Salaries………………………………………………………
-
2,161,895
2,161,895
2,161,895
2,137,550
-
24,345
Expenditures…………………………………………………
930,988
8,989,531
9,920,519
9,287,212
6,781,153
1,535,297
970,762
TOTAL………………………………………………………
930,988
11,151,426
12,082,414
11,449,107
8,918,703
1,535,297
995,107
School Custodians
Salaries………………………………………………………
-
1,865,892
1,865,892
1,865,892
1,772,276
-
93,616
Expenses……………………………………………………
-
888,502
888,502
888,502
887,904
-
598
TOTAL………………………………………………………
-
2,754,394
2,754,394
2,754,394
2,660,180
-
94,214
Total Public Works………………………………………………
1,741,335
27,096,536
28,837,871
28,675,174
24,463,533
1,877,285
2,334,356
CULTURE AND RECREATION
Library
Salaries………………………………………………………
-
1,781,994
1,781,994
1,781,994
1,778,861
-
3,133
Expenses……………………………………………………
-
339,911
339,911
339,911
332,466
-
7,445
Capital………………………………………………………
-
-
-
-
-
-
-
TOTAL………………………………………………………
-
2,121,905
2,121,905
2,121,905
2,111,327
-
10,578
Recreation and Youth Programs
Salaries………………………………………………………
-
698,571
698,571
698,571
652,104
-
46,467
Expenses……………………………………………………
13,670
461,550
475,220
469,745
294,419
107,701
67,625
TOTAL………………………………………………………
13,670
1,160,121
1,173,791
1,168,316
946,523
107,701
114,092
Total Culture and Recreation…………………………………
13,670
3,282,026
3,295,696
3,290,221
3,057,850
107,701
124,670
(Continued)
City of Somerville, Massachusetts
87
Comprehensive Annual Financial Report
Amounts
Current Year
Actual
Amounts
Variance
Carried forward
Initial
Original
Final
Budgetary
Carried Forward
To Final
From Prior Year
Budget
Budget
Budget
Amounts
To Next Year
Budget
GENERAL FUND
SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE -
BUDGET AND ACTUAL
YEAR ENDED JUNE 30, 2017
Budgeted Amounts
OTHER
Pension Benefits
Pension Benefits……………………………………………
-
13,711,675
13,711,675
13,711,675
13,711,675
-
-
Non-Contributory Pension………...………………………
-
121,265
121,265
121,265
121,197
-
68
Total Pension Benefits…………………………………………
-
13,832,940
13,832,940
13,832,940
13,832,872
-
68
Employee Benefits
Health and Life Insurance…………………………………
1,212
23,689,393
23,690,605
23,690,226
23,230,601
833
458,792
Worker's Compensation……………………………………
-
818,743
818,743
818,743
803,539
-
15,204
Unemployment Compensation……………………………
-
125,000
125,000
125,000
114,205
-
10,795
Total Employee Benefits………………………………………
1,212
24,633,136
24,634,348
24,633,969
24,148,345
833
484,791
Debt and Interest
Debt Principal…………..……………………………………
-
7,107,292
7,107,292
7,465,915
7,455,123
-
10,792
Debt Interest…………………………………………..……
-
3,640,774
3,640,774
3,640,774
3,639,566
-
1,208
TOTAL………………………………………………………
-
10,748,066
10,748,066
11,106,689
11,094,689
-
12,000
State and County Charges
State & County………………………………………………
-
14,035,001
14,035,001
14,035,001
13,532,201
-
502,800
Total Other………………………………………………………
1,212
63,249,143
63,250,355
63,608,599
62,608,107
833
999,659
TOTAL EXPENDITURES…………………………………
3,323,265
220,699,886
224,023,151
225,620,676
214,715,856
3,907,817
6,997,003
EXCESS (DEFICIENCY) OF
REVENUES OVER (UNDER) EXPENDITURES……………
(3,323,265)
(5,280,936)
(8,604,201)
(10,201,726)
2,255,860
(3,907,817)
8,549,769
OTHER FINANCING SOURCES (USES):
Premium from issuance of bonds……………………………
-
-
-
-
952,000
-
952,000
Transfers in……………………………………………………
-
2,579,936
2,579,936
4,492,347
4,564,316
-
71,969
Transfers out……………………………………………………
-
(199,000)
(199,000)
(6,587,535)
(6,587,535)
-
-
TOTAL OTHER FINANCING SOURCES (USES)……
-
2,380,936
2,380,936
(2,095,188)
(1,071,219)
-
1,023,969
NET CHANGE IN FUND BALANCE……………………………
(3,323,265)
(2,900,000)
(6,223,265)
(12,296,914)
1,184,641
(3,907,817)
9,573,738
BUDGETARY FUND BALANCE, Beginning of year…………
-
18,321,554
18,321,554
18,321,554
18,321,554
-
-
BUDGETARY FUND BALANCE, End of year………………… $
(3,323,265)
$
15,421,554
$
12,098,289
$
6,024,640
$
19,506,195
$
(3,907,817)
$
9,573,738
See notes to required supplementary information.
(Concluded)
City of Somerville, Massachusetts
88
Comprehensive Annual Financial Report
City of Somerville, Massachusetts
89
Comprehensive Annual Financial Report
Pension Plan Schedules –
Retirement System
Pension Plan Schedules – Retirement System
The Pension Plan’s Schedule of Changes in the Net Pension Liability presents multi-year trend information on the
net pension liability and related ratios.
The Pension Plan’s Schedule of Contributions presents multi-year trend information on the required and actual
contributions to the pension plan and related ratios.
The Pension Plan’s Schedule of Investment Return presents multi-year trend information on the money-weighted
investment return on retirement assets, net of investment expense.
These schedules are intended to present information for ten years. Until a ten year trend is compiled, information
is presented for those years for which information is available.
December 31,
December 31,
December 31,
2016
2015
2014
Total pension liability:
Service cost…………………………………………………………… $
8,007,754
$
8,007,754
$
7,699,763
Interest…………………………………………………………………
30,159,556
31,265,848
29,232,338
Changes in benefit terms………………………………………………
-
-
-
Differences between expected and actual experience……………
(2,943,803)
-
-
Changes in assumptions………………………………………………
2,806,740
-
-
Benefit payments, including refunds of employee contributions…
(28,179,587)
(26,374,021)
(24,693,645)
Interest on benefit payments…………………………………………
-
(1,066,370)
-
Net change in total pension liability……………………………………
9,850,660
11,833,211
12,238,456
Total pension liability, beginning…………………………………………
382,805,432
370,972,221
358,733,765
Total pension liability, ending (a)……………………………………… $
392,656,092
$
382,805,432
$
370,972,221
Plan fiduciary net position:
Member contributions………………………………………………… $
7,560,253
$
7,044,521
$
6,233,959
Employer contributions…………………………………………………
14,659,434
14,199,527
13,812,101
Net investment income (loss)…………………………………………
8,831,845
454,830
12,996,452
Retirement benefits and refunds………………………………………
(27,275,655)
(24,855,194)
(24,693,645)
Administrative expenses………………………………………………
(468,722)
(397,417)
(380,845)
Net increase (decrease) in fiduciary net position………………………
3,307,155
(3,553,733)
7,968,022
Fiduciary net position at beginning of year……………………………
239,494,134
243,047,867
235,079,845
Fiduciary net position at end of year (b)……………………………… $
242,801,289
$
239,494,134
$
243,047,867
Net pension liability - ending (a) - (b)…………………………………$
149,854,803
$
143,311,298
$
127,924,354
Plan fiduciary net position as a percentage of the total
pension liability…………………………………………………………
61.84%
62.56%
65.52%
Covered-employee payroll……………………………………………… $
71,454,475
$
69,167,008
$
66,506,738
Net pension liability as a percentage of covered-employee
payroll……………………………………………………………………
209.72%
207.20%
192.35%
Note: this schedule is intended to present information for 10 years.
Until a 10-year trend is compiled, information is presented for those years for
which information is available.
See notes to required supplementary information.
SOMERVILLE CONTRIBUTORY RETIREMENT SYSTEM
AND RELATED RATIOS
SCHEDULE OF CHANGES IN THE NET PENSION LIABILITY
City of Somerville, Massachusetts
90
Comprehensive Annual Financial Report
December 31,
December 31,
December 31,
2016
2015
2014
Actuarially determined contribution…………………… $
14,659,434
$
14,199,527
$
13,147,710
Contributions in relation to the actuarially
determined contribution………………………………
14,659,434
14,199,527
13,147,710
Contribution deficiency (excess)……………………$
-
$
-
$
-
Covered-employee payroll………………………………$
71,454,475
$
69,167,008
$
66,506,738
Contributions as a percentage of covered-
employee payroll………………………………………
20.52%
20.53%
19.77%
Note: this schedule is intended to present information for 10 years.
Until a 10-year trend is compiled, information is presented for those
years for which information is available.
See notes to required supplementary information.
SOMERVILLE CONTRIBUTORY RETIREMENT SYSTEM
SCHEDULE OF CONTRIBUTIONS
City of Somerville, Massachusetts
91
Comprehensive Annual Financial Report
December 31,
December 31,
December 31,
2016
2015
2014
Annual money-weighted rate of return,
net of investment expense……………………………
3.73%
1.04%
5.63%
Note: this schedule is intended to present information for 10 years.
Until a 10-year trend is compiled, information is presented for those
years for which information is available.
See notes to required supplementary information.
SOMERVILLE CONTRIBUTORY RETIREMENT SYSTEM
SCHEDULE OF INVESTMENT RETURN
City of Somerville, Massachusetts
92
Comprehensive Annual Financial Report
City of Somerville, Massachusetts
93
Comprehensive Annual Financial Report
Pension Plan Schedules – City
Pension Plan Schedules - City
The Schedule of the City’s Proportionate Share of the Net Pension Liability presents multi-year trend information
on the City’s net pension liability and related ratios.
The Schedule of City Contributions presents multi-year trend information on the City’s required and actual
contributions to the pension plan and related ratios.
The Schedule of the Special Funding Amounts of the Net Pension Liability for the Massachusetts Teachers
Contributory Retirement System presents multi-year trend information on the liability and expense assumed by
the Commonwealth of Massachusetts on behalf of the City along with related ratios.
These schedules are intended to present information for ten years. Until a ten year trend is compiled, information
is presented for those years for which information is available.
December 31,
December 31,
December 31,
2016
2015
2014
City's proportion of the net pension liability (asset)……………………
93.53%
93.70%
93.74%
City's proportionate share of the net pension liability (asset)…………$
140,166,391
$
134,275,794
$
119,918,981
City's covered employee payroll…………………………………………$
71,454,475
$
69,167,008
$
66,506,738
Net pension liability as a percentage of the City's covered
employee payroll…………………………………………………………
196.16%
194.13%
180.31%
Plan fiduciary net position as a percentage of the
total pension liability………………………………………………………
61.84%
62.56%
65.52%
Note: this schedule is intended to present information for 10 years.
Until a 10-year trend is compiled, information is presented for those years for
which information is available.
See notes to required supplementary information.
SOMERVILLE CONTRIBUTORY RETIREMENT SYSTEM
OF THE NET PENSION LIABILITY
SCHEDULE OF THE CITY'S PROPORTIONATE SHARE
City of Somerville, Massachusetts
94
Comprehensive Annual Financial Report
June 30,
June 30,
June 30,
2016
2015
2014
Actuarially determined contribution…………………… $
13,711,675
$
13,304,274
$
12,324,940
Contributions in relation to the actuarially
determined contribution………………………………
13,711,675
13,304,274
12,324,940
Contribution deficiency (excess)……………………$
-
$
-
$
-
Covered-employee payroll………………………………$
71,454,475
$
69,167,008
$
66,506,738
Contributions as a percentage of covered-
employee payroll………………………………………
19.19%
19.24%
18.53%
Note: this schedule is intended to present information for 10 years.
Until a 10-year trend is compiled, information is presented for those
years for which information is available.
See notes to required supplementary information.
SOMERVILLE CONTRIBUTORY RETIREMENT SYSTEM
SCHEDULE OF CITY CONTRIBUTIONS
City of Somerville, Massachusetts
95
Comprehensive Annual Financial Report
Fiscal Year
Commonwealth's
100% Share of the
Net Pension
Liability
Associated with
the City
City's Expense
and Revenue
Recognized for
the
Commonwealth's
Support
Plan Fiduciary Net
Position as a
Percentage of the
Total Liability
2017
$
143,094,195
$
14,596,546
52.73%
2016
129,500,617
10,503,653
55.38%
2015
102,638,916
7,130,818
61.64%
Note: this schedule is intended to present information for 10 years.
Until a 10-year trend is compiled, information is presented for those years for
which information is available.
See notes to required supplementary information.
SCHEDULE OF THE SPECIAL FUNDING AMOUNTS
OF THE NET PENSION LIABILITY
MASSACHUSETTS TEACHERS' RETIREMENT SYSTEM
The Commonwealth of Massachusetts is a nonemployer contributor and is required by statute to
make all actuarially determined employer contributions on behalf of the member employers which
creates a special funding situation. Since the City does not contribute directly to MTRS, there is no
net pension liability to recognize. This schedule discloses the Commonwealth's 100% share of the
collective net pension liability that is associated with the City; the portion of the collective pension
expense as both a revenue and pension expense recognized by the City; and the Plan's fiduciary net
position as a percentage of the total liability.
City of Somerville, Massachusetts
96
Comprehensive Annual Financial Report
City of Somerville, Massachusetts
97
Comprehensive Annual Financial Report
Other Postemployment Benefit
Plan Schedules
Other Postemployment Benefits Plan Schedules
The Schedule of Changes in the City’s Net Other Postemployment Benefit Liability and Related Ratios presents
multi-year trend information on changes in the Plan’s total OPEB liability, changes in the Plan’s net position, and
ending net OPEB liability. It also demonstrates the Plan’s net position as a percentage of the total liability and the
Plan’s net other postemployment benefit liability as a percentage of covered employee payroll.
The Schedule of the City’s Contributions presents multi-year trend information on the City’s actual contributions to
the other postemployment benefit plan and related ratios.
The Schedule of Investment Return presents multi-year trend information on the money-weighted investment
return on the Plan’s other postemployment assets, net of investment expense.
The Schedule of Funding progress compares, over time, the actuarial accrued liability for benefits with the
actuarial value of accumulated plan assets.
The Schedule of Employer Contributions presents multiyear trend information for required and actual
contributions relating to the plan.
The Schedule of Actuarial Methods and Assumptions presents factors that significantly affect the identification of
trends in the amounts reported.
June 30, 2017
Total OPEB Liability
Service Cost…………………………………………………………$
11,768,411
Interest………………………………………………………………
11,159,515
Changes of benefit terms……………………………………..……
-
Differences between expected and actual experience…………
-
Changes of assumptions…………………………………………
-
Benefit payments……………………………………………...……
(9,258,566)
Net change in total OPEB liability…………………………………
13,669,360
Total OPEB liability- beginning……………………………..……
290,405,580
Total OPEB liability- ending (a)……………………………………$
304,074,940
Plan fiduciary net position
Contributions- employer ……………………………..…………… $
10,258,566
Net investment income………………………...…………………
7,507
Benefit payments……………………………...……………………
(9,258,566)
Net change in plan fiduciary net position…………………………
1,007,507
Plan fiduciary net position- beginning…………………………..…
813,767
Plan fiduciary net position- ending (b)…………………………… $
1,821,274
City's net OPEB liability- ending (a)-(b)……………………… $
302,253,666
Plan fiduciary net position as a percentage of the
total OPEB liability………………………..………………………
0.60%
Covered-employee payroll………………………………..………
166,971,893
City's net OPEB liability as a percentage of
covered-employee payroll…………………………..…………
181.0%
Note: this schedule is intended to present information for 10 years.
Until a 10-year trend is compiled, information is presented for those years
for which information is available.
See notes to required supplementary information.
SCHEDULE OF CHANGES IN THE
CITY'S NET OPEB LIABILITY AND RELATED RATIOS
OTHER POSTEMPLOYMENT BENEFIT PLAN
City of Somerville, Massachusetts
98
Comprehensive Annual Financial Report
June 30, 2017
Actuarially determined contribution…………………………………$
21,086,425
Contributions in relation to the actuarially
determined contribution……………………………………………
(10,258,566)
Contribution deficiency (excess)…………………………………… $
10,827,859
Covered-employee payroll……………………………………………$
166,971,893
Contributions as a percentage of covered-
employee payroll……………………………………………………
12.63%
Note: this schedule is intended to present information for 10 years.
Until a 10-year trend is compiled, information is presented for those years for
which information is available.
See notes to required supplementary information.
SCHEDULE OF CITY CONTRIBUTIONS
OTHER POSTEMPLOYMENT BENEFIT PLAN
City of Somerville, Massachusetts
99
Comprehensive Annual Financial Report
June 30, 2017
Annual money-weighted rate of return,
net of investment expense………………………………………
0.92%
Note: This schedule is intended to present information for 10 years.
Until a 10-year trend is compiled, information is presented for those
years for which information is available.
See notes to required supplementary information.
SCHEDULE OF INVESTMENT RETURNS
OTHER POSTEMPLOYMENT BENEFIT PLAN
City of Somerville, Massachusetts
100
Comprehensive Annual Financial Report
Actuarial
UAAL as a
Actuarial
Accrued
Unfunded
Percentage
Actuarial
Value of
Liability (AAL)
AAL
Funded
Covered
of Covered
Valuation
Assets
Projected Unit Credit
(UAAL)
Ratio
Payroll
Payroll
Date
(A)
(B)
(B-A)
(A/B)
(C)
((B-A)/C)
6/30/2016
$
813,768
$
302,648,586
$
301,834,818
0.27%
$
149,233,169
202.3%
6/30/2014
-
285,255,653
285,255,653
0.00%
112,256,322
254.1%
6/30/2012
-
300,478,458
300,478,458
0.00%
84,899,992
353.9%
Annual
Actual
Year
Required
Contributions
Percentage
Ended
Contribution
Made
Contributed
6/30/2017
$
21,086,425
10,258,566
49%
6/30/2016
20,168,818
8,533,496
42%
6/30/2015
19,751,604
9,645,790
49%
See notes to required supplementary information.
OTHER POSTEMPLOYMENT BENEFIT PLAN
SCHEDULE OF FUNDING PROGRESS AND EMPLOYER CONTRIBUTIONS
Schedule of Employer Contributions
Schedule of Funding Progress
City of Somerville, Massachusetts
101
Comprehensive Annual Financial Report
Actuarial Methods:
Valuation date………………………………………… June 30, 2016
Actuarial cost method………………………………… Projected Unit Credit
Amortization method………………………………… Amortization payments increasing at 4%, open
Remaining amortization period……………………… 30 years as of June 30, 2016
Actuarial Assumptions:
Investment rate of return……………………………
4%, pay-as-you-go scenario
Medical/drug cost trend rate…………………………
6% graded to 4.5% over 4 years
Inflation rate……………………………………………
6% graded to 4.5% over 4 years
Projected salary increases …………………………
4%
Plan Membership:
Current retirees and beneficiaries…………………
1,676
Current active members……………………………
1,719
Total……………………………………………………
3,395
See notes to required supplementary information.
OTHER POSTEMPLOYMENT BENEFIT PLAN
ACTUARIAL METHODS AND ASSUMPTIONS
City of Somerville, Massachusetts
102
Comprehensive Annual Financial Report
Notes to Required Supplementary Information
Year Ended June 30, 2017
City of Somerville, Massachusetts
103
Comprehensive Annual Financial Report
NOTE A - STEWARDSHIP, COMPLIANCE AND ACCOUNTABILITY
Notes to Required Supplementary Information
A. Budgetary Information
Municipal Law requires the adoption of a balanced budget that is approved by the Mayor and the Board. The
Mayor presents an annual budget to the Board, which includes estimates of revenues and other financing sources
and recommendations of expenditures and other financing uses. The Board, which has full authority to amend
and/or reject the budget or any line item, adopts the expenditure budget by majority vote.
Increases or transfers between and within departments subsequent to the approval of the annual budget, requires
majority Board approval via a supplemental appropriation or Board order.
The majority of appropriations are non-continuing which lapse at the end of each year. Others are continuing
appropriations for which the governing body has authorized that an unspent balance from a prior year be carried
forward and made available for spending in the current year. These carry forwards are included as part of the
subsequent year’s original budget.
Generally, expenditures may not exceed the legal level of spending (salaries, expenses and capital) authorized
for an appropriation account. However, the payment of debt service is statutorily required, regardless of whether
such amounts are appropriated. Additionally, expenditures for disasters, natural or otherwise, and final judgments
may exceed the level of spending authorized by two-thirds majority vote of the Board.
An annual budget is adopted for the general fund in conformity with the guidelines described above. The original
2017 approved budget authorized $224.2 million in appropriations and other amounts to be raised. During 2017,
the Board also increased appropriations by approximately $8 million. The City Auditor’s Office has the
responsibility to ensure that budgetary control is maintained. Budgetary control is exercised through the
accounting system.
B. Budgetary - GAAP Reconciliation
For budgetary financial reporting purposes, the Uniform Municipal Accounting System basis of accounting
(established by the Commonwealth) is followed, which differs from the GAAP basis of accounting. A
reconciliation of budgetary-basis to GAAP-basis results for the general fund for the year ended June 30, 2017, is
depicted below:
Excess (deficiency) of revenues and other financing
sources (uses) over expenditures - budgetary basis………………………$
1,184,641
Perspective difference:
Unemployment insurance trust recorded in
the general fund for GAAP…………………………………………………
57,866
Stabilization funds recorded in the general fund for GAAP………………
4,117,971
Basis of accounting differences:
Net change in recording 60-day receipts accrual…………………………
174,500
Net change in recording tax refunds payable………………………………
416,000
Recognition of revenue for on-behalf payments........……………………
(14,596,546)
Recognition of expenditures for on-behalf payments........………………
14,596,546
Excess (deficiency) of revenues and other financing
sources (uses) over expenditures - GAAP basis………………………… $
5,950,978
Notes to Required Supplementary Information
Year Ended June 30, 2017
City of Somerville, Massachusetts
104
Comprehensive Annual Financial Report
NOTE B – PENSION PLAN
Pension Plan Schedules – Retirement System
A. Schedule of Changes in the Net Pension Liability and Related Ratios
The Schedule of Changes in the Net Pension Liability and Related Ratios includes the detailed changes in the
systems total pension liability, changes in the systems net position, and the ending net pension liability. It also
demonstrates the plan’s net position as a percentage of the total pension liability and the net pension liability as a
percentage of covered payroll.
B. Schedule of Contributions
Governmental employers are required to pay an annual appropriation as established by PERAC. The total
appropriation includes the amounts to pay the pension portion of each member’s retirement allowance, an amount
to amortize the actuarially determined unfunded liability to zero in accordance with the system’s funding schedule,
and additional appropriations in accordance with adopted early retirement incentive programs. The total
appropriations are payable on July 1 and January 1. Employers may choose to pay the entire appropriation in
July at a discounted rate. Accordingly, actual employer contributions may be less than the “total appropriation”.
The pension fund appropriations are allocated amongst employers based on covered payroll.
C. Schedule of Investment Return
The money weighted rate of return is calculated as the internal rate of return on pension plan investments, net of
pension plan investment expense. A money weighted rate of return expresses investment performance, net of
pension plan investment expense, adjusted for the changing amounts actually invested. Inputs to the money
weighted rate of return calculation are determined monthly.
Pension Plan Schedules - City
A. Schedule of the City’s Proportionate Share of the Net Pension Liability
The Schedule of the City’s Proportionate Share of the Net Pension Liability details the allocated percentage of the
net pension liability (asset), the proportionate share of the net pension liability, and the covered employee payroll.
It also demonstrates the net position as a percentage of the pension liability and the net pension liability as a
percentage of covered payroll.
B. Schedule of City Contributions
Governmental employers are required to pay an annual appropriation as established by PERAC. The
appropriation includes the amounts to pay the pension portion of each member’s retirement allowance, an amount
to amortize the actuarially determined unfunded liability to zero in accordance with the system’s funding schedule,
and additional appropriations in accordance with adopted early retirement incentive programs. The
appropriations are payable on July 1 and January 1. The City may choose to pay the entire appropriation in July
at a discounted rate. Accordingly, actual contributions may be less than the “total appropriation”. The pension
fund appropriation is allocated to the City based on covered payroll.
C. Schedule of the Special Funding Amounts of the Net Pension Liability
The Commonwealth of Massachusetts is a nonemployer contributor and is required by statute to make all
actuarially determined employer contributions on behalf of the member employers which creates a special funding
Notes to Required Supplementary Information
Year Ended June 30, 2017
City of Somerville, Massachusetts
105
Comprehensive Annual Financial Report
situation. Since the City does not contribute directly to MTRS, there is no net pension liability to recognize. This
schedule discloses the Commonwealth's 100% share of the collective net pension liability that is associated with
the City; the portion of the collective pension expense as both revenue and pension expense recognized by the
City; and the Plan's fiduciary net position as a percentage of the total liability.
D. Changes in Assumptions
The discount rate has changed from 8.25% to 8.00%.
Annual rates of withdrawal prior to retirement have been adjusted based on experience, for both general
employees and police and fire employees.
Annual rate of mortality tables used have been updated.
The assumed annual retirement rates for those hired prior to April 2, 2012, have been updated.
The assumed annual retirement rates for those hired on or after April 2, 2012, have been updated.
The assumed annual rates of disability for both general employees and police and fire employees have been
updated.
The annual amount of administrative expenses has been increased to $450,000, and is expected to increase at
4% per year.
E. Changes in Plan Provisions
The maximum amount of pension benefits subject to a cost of living increase has been raised from $12,000 to
$13,000.
NOTE C - OTHER POSTEMPLOYMENT BENEFITS
The City administers a single-employer defined benefit healthcare plan (“the Plan”). The plan provides lifetime
healthcare and life insurance for eligible retirees and their spouses through the City’s health and life insurance
plans, which covers both active and retired members, including teachers.
The Other Postemployment Benefit Plan
Schedule of Changes in the City’s Net Other Postemployment Benefit Liability and Related Ratios
The Schedule of Changes in the City’s Net Other Postemployment Benefit Liability and Related Ratios presents
multi-year trend information on changes in the Plan’s total OPEB liability, changes in the Plan’s net position, and
ending net OPEB liability. It also demonstrates the Plan’s net position as a percentage of the total liability and the
Plan’s net other postemployment benefit liability as a percentage of covered employee payroll.
Schedule of the City’s Contributions
The Schedule of the City’s Contributions includes the City’s annual required contribution to the Plan, along with
the contribution made in relation to the actuarially determined contribution and the covered employee payroll. The
City is not required to fully fund this contribution. It also demonstrates the contributions as a percentage of
covered payroll.
Notes to Required Supplementary Information
Year Ended June 30, 2017
City of Somerville, Massachusetts
106
Comprehensive Annual Financial Report
Schedule of Investment Return
The Schedule of Investment Return includes the money-weighted investment return on the Plan’s other
postemployment assets, net of investment expense.
The City
The Town currently finances its other postemployment benefits (OPEB) on a hybrid of pay-as-you-go and setting
aside monies in an OPEB Trust. As a result, the funded ratio (actuarial value of assets expressed as a
percentage of the actuarial accrued liability) is .27%. In accordance with Governmental Accounting Standards,
the Town has recorded its OPEB cost equal to the actuarial determined annual required contribution (ARC) which
includes the normal cost of providing benefits for the year and a component for the amortization of the total
unfunded actuarial accrued liability of the plan.
Projections of benefits for financial reporting purposes are based on the substantive plan and include the types of
benefits provided at the time of each valuation and the historical pattern of sharing of benefit costs between the
employer and plan members to that point. The actuarial methods and assumptions used include techniques that
are designed to reduce the effects of short-term volatility in actuarial accrued liabilities and the actuarial value of
assets, consistent with the long-term perspective of the calculations.
Schedule of Funding Progress
The Schedule of Funding Progress presents multiyear trend information which compares, over time, the City’s
actuarial accrued liability for benefits with the actuarial value of accumulated plan assets.
Schedule of Employer Contributions
The Schedule of Employer Contributions presents multiyear trend information for the City’s required and actual
contributions relating to the plan.
Schedule of Actuarial Methods and Assumptions
The Schedule of Actuarial Methods and Assumptions presents factors that significantly affect the identification of
trends in the amounts reported.
City of Somerville, Massachusetts
107
Comprehensive Annual Financial Report
Combining and Individual Fund Statements
Combining and Individual Fund Statements
City of Somerville, Massachusetts
108
Comprehensive Annual Financial Report
Nonmajor Governmental Funds
Nonmajor Governmental Funds
Special Revenue Funds
Special revenue funds are used to account for specific revenues that are legally restricted to expenditure for
particular purposes.
School Special Revenue Funds – accounts for the activity of the school department’s revolving funds established
in accordance with MGL Chapter 44, Section 53E ½.
School Federal Grants – accounts for grant funds received from the federal government that are designated for
specific education programs.
School State & Private Grants – This fund is used to account for receipts from a specific revenue source that by
law is accounted for separately from the general fund and must be spent by appropriation.
City Federal Grants – accounts for grant funds received from the federal government that are designated for
specific programs, excluding school education grants which are accounted for in the School Federal Grants
Special Revenue Fund.
City State Grants – accounts for grant funds received from the Commonwealth that are designated for specific
programs, excluding school education grants which are accounted for in the School State Grants Special
Revenue Fund.
Highway Improvement Funds – accounts for construction, reconstruction and improvements to roadways, streets,
and sidewalks. Funding is provided primarily by grants.
City Revolving Funds – excluding the school department, accounts for the activity of revolving funds established
in accordance with MGL Chapter 44, Section 53E ½.
Receipts Reserved – accounts for receipts that are designated to fund and supplement specific operating budgets
of departments.
City Private Grants – accounts for non-school related activity financed by private grants designated for specific
programs.
School Lunch – accounts for the activity of the school lunch program. Revenues include State and Federal
reimbursements for meals served.
Other Special Revenue Funds – accounts for the activity of gifts received and miscellaneous departmental special
revenue funds.
Community Preservation Fund – accounts for funds held for uses restricted by law for community preservation
purposes. These funds are attributable to the City’s acceptance of the Community Preservation Act, which allows
the City to impose up to a 3% surcharge on property taxes and to receive matching state grant funds for specified
uses related to the acquisition, creation, preservation and support of open space, historic resources, land for
recreational use and community housing.
City of Somerville, Massachusetts
109
Comprehensive Annual Financial Report
Permanent Funds
Permanent funds are used to report resources that are legally restricted to the extent that only earnings, not
principal, may be used for purposes that support governmental programs.
Permanent Funds Principal – This fund is used to account for the non-expendable portion of gifts, bequests and
contributions for which only earnings may be expended to benefit the City.
Expendable Permanent Funds – This fund is used to account for the spendable portion of gifts, bequests and
contributions held for which only earnings may be expended for purposes specified by the donor.
School
School
School
City
City
Special Revenue
Federal
State & Private
Federal Grant
State Grant
Funds
Grants
Grant
Funds
Funds
ASSETS
Cash and cash equivalents………………..…………$
849,569
$
151,139
$
1,516,892
$
7,108
$
415,310
Departmental and other……………………………
-
-
-
-
-
Intergovernmental…………………………………
-
-
-
-
-
Loans………………………………………………
-
-
-
-
-
Due from other funds…………………………………
-
-
1,371,806
-
-
TOTAL ASSETS……………………………………… $
849,569
$
151,139
$
2,888,698
$
7,108
$
415,310
LIABILITIES
Warrants payable………………………………… $
591
$
1,803
$
416
$
-
$
-
Accrued payroll……………………………………
122,742
42,797
51,679
1,001
4,376
Due to other funds…………………………………
-
-
-
-
-
TOTAL LIABILITIES……………………………………
123,333
44,600
52,095
1,001
4,376
DEFERRED INFLOWS OF RESOURCES
Unavailable revenue………………………………
-
-
-
-
-
FUND BALANCES
Nonspendable………………………………………
-
-
-
-
-
Restricted……………………………………………
726,236
106,539
2,836,603
6,107
410,934
TOTAL FUND BALANCES……………………………
726,236
106,539
2,836,603
6,107
410,934
TOTAL LIABILITIES, DEFERRED INFLOWS OF
RESOURCES, AND FUND BALANCES…………$
849,569
$
151,139
$
2,888,698
$
7,108
$
415,310
NONMAJOR GOVERNMENTAL FUNDS
COMBINING BALANCE SHEET
JUNE 30, 2017
Special Revenue Funds
City of Somerville, Massachusetts
110
Comprehensive Annual Financial Report
Highway
City
City
School
Other
Improvement
Revolving
Receipts
Private
Lunch
Special Revenue
Community
Funds
Funds
Reserved
Grants
Funds
Funds
Preservation
Subtotal
$
-
$
152,985
$
4,936,375
$
297,029
$
888,295
$
4,114,303
$
8,592,712
$
21,921,717
-
-
-
-
-
-
26,172
26,172
3,520,305
-
-
-
-
-
370,465
3,890,770
-
-
-
-
-
1,788,926
1,200,658
2,989,584
-
-
-
-
-
-
-
1,371,806
$
3,520,305
$
152,985
$
4,936,375
$
297,029
$
888,295
$
5,903,229
$
10,190,007
$
30,200,049
$
-
$
27,529
$
-
$
-
$
-
$
78
$
90,710
$
121,127
-
10,439
-
-
17,101
6,567
1,327
258,029
314,324
-
-
-
-
-
-
314,324
314,324
37,968
-
-
17,101
6,645
92,037
693,480
3,205,981
-
-
-
-
-
396,637
3,602,618
-
-
-
-
-
-
-
-
-
115,017
4,936,375
297,029
871,194
5,896,584
9,701,333
25,903,951
-
115,017
4,936,375
297,029
871,194
5,896,584
9,701,333
25,903,951
$
3,520,305
$
152,985
$
4,936,375
$
297,029
$
888,295
$
5,903,229
$
10,190,007
$
30,200,049
(Continued)
Special Revenue Funds
City of Somerville, Massachusetts
111
Comprehensive Annual Financial Report
Total
Permanent
Expendable
Nonmajor
Funds
Permanent
Governmental
Principal
Funds
Subtotal
Funds
ASSETS
Cash and cash equivalents………………..…………… $
433,126
$
159,213
$
592,339
$
22,514,056
Departmental and other………………………………
-
-
-
26,172
Intergovernmental……………………………………
-
-
-
3,890,770
Loans……………………………………………………
-
-
-
2,989,584
Due from other funds……………………………………
-
-
-
1,371,806
TOTAL ASSETS………………………………………… $
433,126
$
159,213
$
592,339
$
30,792,388
LIABILITIES
Warrants payable………………………………………$
-
$
-
$
-
$
121,127
Accrued payroll………………………………………
-
-
-
258,029
Due to other funds……………………………………
-
-
-
314,324
TOTAL LIABILITIES………………………………………
-
-
-
693,480
DEFERRED INFLOWS OF RESOURCES
Unavailable revenue…………………………………
-
-
-
3,602,618
FUND BALANCES
Nonspendable…………………………………………
433,126
-
433,126
433,126
Restricted………………………………………………
-
159,213
159,213
26,063,164
TOTAL FUND BALANCES………………………………
433,126
159,213
592,339
26,496,290
TOTAL LIABILITIES, DEFERRED INFLOWS OF
RESOURCES, AND FUND BALANCES……………$
433,126
$
159,213
$
592,339
$
30,792,388
(Concluded)
NONMAJOR GOVERNMENTAL FUNDS
COMBINING BALANCE SHEET
JUNE 30, 2017
Permanent Funds
City of Somerville, Massachusetts
112
Comprehensive Annual Financial Report
City of Somerville, Massachusetts
113
Comprehensive Annual Financial Report
This page intentionally left blank.
School
School
School
City
City
Special Revenue
Federal
State & Private
Federal Grant
State Grant
Funds
Grants
Grant
Funds
Funds
REVENUES:
Intergovernmental……………………………………………………$
-
$
4,062,574
$
3,882,982
$
559,549
$
737,982
Departmental and other……………………………………………
2,620,547
-
-
-
97,852
Community Preservation……………………………………………
-
-
-
-
-
Contributions…………………………………………………………
8,947
-
-
-
-
Investment income…………………………………………………
-
-
-
-
-
TOTAL REVENUES…………………………………………
2,629,494
4,062,574
3,882,982
559,549
835,834
EXPENDITURES:
Current:
General government……………………………………………
-
-
-
13,788
420,021
Public safety………………………………………………………
-
-
-
71,538
400,060
Education…………………………………………………………
3,003,197
4,104,911
3,755,709
-
-
Public works………………………………………………………
-
-
-
247,606
-
Human services…………………………………………………
-
-
-
225,558
5,817
Culture and recreation……………………………………………
-
-
-
89
49,259
Community Preservation…………………………………………
-
-
-
-
-
TOTAL EXPENDITURES……………………………………
3,003,197
4,104,911
3,755,709
558,579
875,157
EXCESS (DEFICIENCY) OF REVENUES
OVER (UNDER) EXPENDITURES………………………………
(373,703)
(42,337)
127,273
970
(39,323)
OTHER FINANCING SOURCES (USES):
Premium from issuance of bonds…………………………………
-
-
-
-
-
Sale of capital assets………………………………………………
-
-
-
-
-
Transfers in……………………………………………………………
-
-
-
109
7,422
Transfers out…………………………………………………………
-
(48)
(1)
(11,229)
(23,541)
TOTAL OTHER FINANCING SOURCES (USES)…………
-
(48)
(1)
(11,120)
(16,119)
NET CHANGE IN FUND BALANCES…………………………………
(373,703)
(42,385)
127,272
(10,150)
(55,442)
FUND BALANCES AT BEGINNING OF YEAR………………………
1,099,939
148,924
2,709,331
16,257
466,376
FUND BALANCES AT END OF YEAR……………………………… $
726,236
$
106,539
$
2,836,603
$
6,107
$
410,934
Special Revenue Funds
NONMAJOR GOVERNMENTAL FUNDS
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES
YEAR ENDED JUNE 30, 2017
City of Somerville, Massachusetts
114
Comprehensive Annual Financial Report
Highway
City
City
School
Other
Improvement
Revolving
Receipts
Private
Lunch
Special Revenue
Community
Funds
Funds
Reserved
Grants
Funds
Funds
Preservation
Sub-total
$
1,399,284
$
-
$
-
$
92,555
$
2,303,130
$
818,642
$
1,200,658
$
15,057,356
-
1,127,074
2,096,387
-
631,223
1,426,122
-
7,999,205
-
-
-
-
-
-
2,085,496
2,085,496
-
-
740
-
-
231,200
-
240,887
-
-
-
-
-
20,390
12,292
32,682
1,399,284
1,127,074
2,097,127
92,555
2,934,353
2,496,354
3,298,446
25,415,626
-
969,098
-
53,802
-
967,234
-
2,423,943
-
2,871
-
-
-
282,779
-
757,248
-
-
-
-
3,155,456
51,164
-
14,070,437
1,399,284
21,390
-
-
-
180,917
-
1,849,197
-
-
-
4,916
-
8,126
-
244,417
-
92,482
-
13
-
65,753
-
207,596
-
-
-
-
-
-
2,314,179
2,314,179
1,399,284
1,085,841
-
58,731
3,155,456
1,555,973
2,314,179
21,867,017
-
41,233
2,097,127
33,824
(221,103)
940,381
984,267
3,548,609
-
-
-
-
-
598,829
-
598,829
-
-
2,120,152
-
-
-
-
2,120,152
-
(1,719)
-
-
-
1,719
500,000
507,531
-
(34,330)
(3,272,520)
(148)
-
(2,624)
-
(3,344,441)
-
(36,049)
(1,152,368)
(148)
-
597,924
500,000
(117,929)
-
5,184
944,759
33,676
(221,103)
1,538,305
1,484,267
3,430,680
-
109,833
3,991,616
263,353
1,092,297
4,358,279
8,217,066
22,473,271
$
-
$
115,017
$
4,936,375
$
297,029
$
871,194
$
5,896,584
$
9,701,333
$
25,903,951
(Continued)
Special Revenue Funds
City of Somerville, Massachusetts
115
Comprehensive Annual Financial Report
Total
Permanent
Expendable
Nonmajor
Funds
Permanent
Governmental
Principal
Funds
Sub-total
Funds
REVENUES:
Intergovernmental……………………………………………… $
-
$
-
$
-
$
15,057,356
Departmental and other…………………………………………
-
-
-
7,999,205
Community Preservation………………………………………
-
-
-
2,085,496
Contributions……………………………………………………
-
-
-
240,887
Investment income………………………………………………
-
1,897
1,897
34,579
TOTAL REVENUES………………………………………
-
1,897
1,897
25,417,523
EXPENDITURES:
Current:
General government…………………………………………
-
-
-
2,423,943
Public safety…………………………………………………
-
-
-
757,248
Education………………………………………………………
-
-
-
14,070,437
Public works…………………………………………………
-
-
-
1,849,197
Human services………………………………………………
-
-
-
244,417
Culture and recreation………………………………………
-
-
-
207,596
Community Preservation……………………………………
-
-
-
2,314,179
TOTAL EXPENDITURES…………………………………
-
-
-
21,867,017
EXCESS (DEFICIENCY) OF REVENUES
OVER (UNDER) EXPENDITURES……………………………
-
1,897
1,897
3,550,506
OTHER FINANCING SOURCES (USES):
Premium from issuance of bonds………………………………
-
-
-
598,829
Sale of capital assets……………………………………………
-
-
-
2,120,152
Transfers in………………………………………………………
-
-
-
507,531
Transfers out……………………………………………………
-
-
-
(3,344,441)
TOTAL OTHER FINANCING SOURCES (USES)……
-
-
-
(117,929)
NET CHANGE IN FUND BALANCES……………………………
-
1,897
1,897
3,432,577
FUND BALANCES AT BEGINNING OF YEAR…………………
433,126
157,316
590,442
23,063,713
FUND BALANCES AT END OF YEAR……………………………$
433,126
$
159,213
$
592,339
$
26,496,290
(Concluded)
Permanent Funds
NONMAJOR GOVERNMENTAL FUNDS
COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES
YEAR ENDED JUNE 30, 2017
City of Somerville, Massachusetts
116
Comprehensive Annual Financial Report
City of Somerville, Massachusetts
117
Comprehensive Annual Financial Report
Agency Fund
Agency Fund
This fund is segregated from the general fund to account for assets held by the City in a trustee capacity or as an
agent for individuals, private organizations, other governmental units, etc.
Beginning
End
of Year
Additions
Deletions
of Year
ASSETS
CURRENT:
Cash and cash equivalents………………………….…$
1,052,254
$
5,685,745
$
(6,100,657)
$
637,342
LIABILITIES
Accrued liabilities……………………………………… $
116,723
$
122,283
$
(166,320)
$
72,686
Liabilities due depositors………………………………
935,531
5,563,462
(5,934,337)
564,656
TOTAL LIABILITIES……………………………………… $
1,052,254
$
5,685,745
$
(6,100,657)
$
637,342
AGENCY FUND
STATEMENT OF CHANGES IN ASSETS AND LIABILITIES
YEAR ENDED JUNE 30, 2017
City of Somerville, Massachusetts
118
Comprehensive Annual Financial Report
Statistical Section
The Somerville District Courthouse, a division of the Massachusetts Court System, holds trials in its three
courtrooms. Photo taken by Rie Lowenstein
City of Somerville, Massachusetts
119
Comprehensive Annual Financial Report
Statistical Section
Statistical Section
This part of the comprehensive annual financial report presents detailed information as a context for
understanding what the information in the financial statements, note disclosures, and required supplementary
information says about the City’s overall financial health.
Financial Trends
•
These schedules contain trend information to help the reader understand how the City’s financial
performance and well-being have changed over time.
Revenue Capacity
•
These schedules contain information to help the reader assess the City’s most significant local revenue
source, the property tax.
Debt Capacity
•
These schedules present information to help the reader assess the affordability of the City’s current levels
of outstanding debt and the City’s ability to issue additional debt in the future.
Demographic and Economic Information
•
These schedules offer demographic and economic indicators to help the reader understand the
environment within which the City’s financial activities take place.
Operating Information
•
These schedules contain service and infrastructure data to help the reader understand how the
information in the City’s financial report relates to the City provided services and the activities it performs.
SOURCES: Unless otherwise noted, the information in these schedules is derived from the comprehensive
annual financial reports for the relevant year.
2008
2009
2010
2011
2012
2013
2014 (1)
2015
2016
2017
Governmental activities
Net investment in capital assets………………$
112,716,973
$
114,071,426
$
114,146,078
$
117,701,275
$
126,834,901
$
136,813,615
$
135,597,852
$
132,766,621
$
130,183,221
$
128,346,108
Restricted………………………………………
23,920,569
19,464,156
24,114,249
25,126,498
22,775,093
24,157,523
23,001,973
25,063,900
26,765,034
26,765,236
Unrestricted……………………………………
32,910,522
22,052,332
3,369,141
(1,130,225)
(18,721,004)
(23,786,300)
(145,351,160)
(149,966,003)
(156,698,433)
(166,224,124)
Total governmental activities net assets…………… $
169,548,064
$
155,587,914
$
141,629,468
$
141,697,548
$
130,888,990
$
137,184,838
$
13,248,665
$
7,864,518
$
249,822
$
(11,112,780)
Business-type activities
Net investment in capital assets………………$
4,762,242
$
7,539,882
$
16,039,555
$
20,025,113
$
24,078,204
$
29,794,495
$
35,084,760
$
39,855,221
$
43,810,782
$
46,081,442
Unrestricted……………………………………
17,892,482
20,821,058
19,409,168
21,059,957
23,647,858
21,220,544
19,069,553
17,231,368
17,715,352
22,249,407
Total business-type activities net assets……………$
22,654,724
$
28,360,940
$
35,448,723
$
41,085,070
$
47,726,062
$
51,015,039
$
54,154,313
$
57,086,589
$
61,526,134
$
68,330,849
Primary government
Net investment in capital assets………………$
117,479,215
$
121,611,308
$
130,185,633
$
137,726,388
$
150,913,105
$
166,608,110
$
170,682,612
$
172,621,842
$
173,994,003
$
174,427,550
Restricted………………………………………
23,920,569
19,464,156
24,114,249
25,126,498
22,775,093
24,157,523
23,001,973
25,063,900
26,765,034
26,765,236
Unrestricted……………………………………
50,803,004
42,873,390
22,778,309
19,929,732
4,926,854
(2,565,756)
(126,281,607)
(132,734,635)
(138,983,081)
(143,974,717)
Total primary government net position………………$
192,202,788
$
183,948,854
$
177,078,191
$
182,782,618
$
178,615,052
$
188,199,877
$
67,402,978
$
64,951,107
$
61,775,956
$
57,218,069
Note: In 2008, the City reclassified capital assets related to the water and sewer enterprise funds from the governmental capital assets.
(1) = Unrestricted net position has been revised to reflect the implementation of GASB Statements #67, #68, and #71.
Net Position By Component
Last Ten Years
City of Somerville, Massachusetts
120
Comprehensive Annual Financial Report
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
Expenses
Governmental activities:
General government…………………………………………………… $
22,192,789
$
23,220,232
$
21,779,285
$
21,655,742
$
22,124,384
$
25,892,120
$
27,028,141
$
30,201,124
$
32,270,976
$
34,076,945
Public safety……………………………………………………………
54,178,926
53,444,548
52,328,325
45,903,858
52,391,661
51,377,022
52,091,080
52,579,803
54,345,466
58,162,944
Education………………………………………………………………
102,347,605
110,053,080
108,803,922
108,813,913
113,396,259
113,753,374
121,176,505
114,802,360
124,740,381
132,958,254
Public works……………………………………………………………
30,054,802
27,101,081
24,973,616
23,346,672
23,631,860
25,203,877
26,974,196
33,520,992
28,957,827
31,017,581
Commmunity development……………………………………………
8,021,636
9,504,292
6,014,349
7,491,176
5,225,117
5,092,521
5,399,251
5,730,544
5,177,605
9,696,020
Human services…………………………………………………………
22,475
122,641
18,802
9,560
316,137
288,766
227,030
229,633
178,570
244,417
Community preservation………………………………………………
-
-
-
-
-
-
56,770
77,672
347,016
1,522,282
Culture and recreation…………………………………………………
969,173
4,159,278
4,566,066
3,880,264
4,160,530
4,695,015
3,868,022
4,948,901
4,787,187
5,245,975
Interest……………………………………………………………………
3,003,452
2,865,682
2,713,563
2,282,434
2,306,520
2,858,173
3,178,533
2,913,723
2,956,192
3,563,654
Total government activities expenses…………………………………………
220,790,858
230,470,834
221,197,928
213,383,619
223,552,468
229,160,868
239,999,528
245,004,752
253,761,220
276,488,072
Business-type activities:
Water…………………………………...………………………………
7,111,413
7,920,756
6,863,013
9,034,024
8,366,003
9,222,940
9,120,695
9,779,632
10,211,295
11,166,299
Sewer……………………………………………………………………
11,554,303
12,979,914
13,245,282
14,185,999
14,803,664
15,303,668
15,811,901
16,312,337
17,099,159
18,106,483
Veteran's memorial ice rink……………………………………………
-
-
-
-
337,456
522,392
584,995
750,644
721,990
679,098
Dilboy stadium…………………………………………………………
-
-
-
-
132,312
147,794
217,761
160,855
136,199
154,881
Total business-type activities expenses………………………………………
18,665,716
20,900,670
20,108,295
23,220,023
23,639,435
25,196,794
25,735,352
27,003,468
28,168,643
30,106,761
Total primary government expenses…………………………………………… $
239,456,574
$
251,371,504
$
241,306,223
$
236,603,642
$
247,191,903
$
254,357,662
$
265,734,880
$
272,008,220
$
281,929,863
$
306,594,833
Program Revenues
Governmental activities:
General government charges for services…………………………… $
2,683,805
$
2,613,510
$
3,929,772
$
5,111,948
$
5,645,000
$
4,716,640
$
6,078,676
$
14,874,314
$
9,341,536
$
10,828,065
Public safety charges for services……………………………………
13,782,939
11,279,366
11,653,283
11,168,627
10,402,613
10,743,269
9,504,549
9,701,430
9,726,266
11,648,005
Education charges for services………………………………………
1,287,818
1,289,836
1,523,386
2,773,301
2,888,195
2,620,430
2,744,125
2,854,004
3,025,441
3,251,770
Other charges for services……………………………………………
1,163,619
1,638,308
1,511,902
2,464,581
2,318,541
2,009,294
1,234,865
1,200,251
1,280,431
1,231,044
General government operating grants and contributions……………
1,112,730
1,065,242
1,142,773
2,190,637
2,241,945
2,208,949
2,275,935
3,306,728
2,318,143
3,611,794
Public safety operating grants and contributions……………………
1,979,862
2,073,664
1,582,812
984,665
583,597
733,021
1,035,751
787,168
734,344
567,768
Education operating grants and contributions………………………
46,931,033
48,503,731
47,963,393
46,517,454
46,478,286
47,121,192
49,332,811
38,046,566
41,967,740
46,466,462
Public works operating grants and contributions……………………
867,986
865,255
816,657
20,000
149,243
1,201,182
1,030,318
1,151,440
932,462
2,059,979
Community development operating grants and contributions………
14,267,545
7,104,189
9,596,234
6,754,407
5,677,368
6,544,448
5,331,152
7,445,467
5,244,967
6,297,670
Other operating grants and contributions……………………………
566,590
1,173,232
1,101,023
1,375,021
1,012,441
991,642
1,028,356
957,692
861,352
888,955
Education capital grants and contributions……………………………
-
1,021,427
-
-
-
12,653,757
1,686,711
9,685
2,212,282
1,598,709
Other capital grants and contributions…………………………………
-
-
-
1,300,151
1,014,340
951,439
365,429
991,751
2,090,371
440,747
Total government activities program revenues...………………………………
84,643,927
78,627,760
80,821,235
80,660,792
78,411,569
92,495,263
81,648,678
81,326,496
79,735,335
88,890,968
Business-type activities:
Water charges for services……………………………………………
9,198,012
9,826,242
9,968,139
11,499,958
11,972,625
11,878,296
11,952,312
11,923,024
13,249,816
13,945,725
Sewer charges for services……………………………………………
15,191,936
14,849,185
15,654,243
15,631,262
17,139,421
17,012,055
17,055,541
17,304,880
19,298,052
21,673,233
Veteran's memorial ice rink charges for services……………………
-
-
-
-
270,626
377,422
530,583
579,538
638,822
587,035
Dilboy stadium charges for services…………………………………
-
-
-
-
90,527
147,000
110,200
181,942
227,234
200,074
Other capital grant and contributions…………………………………
-
-
-
-
1,322,550
-
654,755
-
-
-
Total business-type activities program revenues...……………………………
24,389,948
24,675,427
25,622,382
27,131,220
30,795,749
29,414,773
30,303,391
29,989,384
33,413,924
36,406,067
Total primary government program revenues………………………………… $
109,033,875
$
103,303,187
$
106,443,617
$
107,792,012
$
109,207,318
$
121,910,036
$
111,952,069
$
111,315,880
$
113,149,259
$
125,297,035
Net (Expense)/Program Revenue
Governmental activities………………………………………………………… $
(136,146,931)
$
(151,843,074)
$
(140,376,693)
$
(132,722,827)
$
(145,140,899)
$
(136,665,605)
$
(158,350,850)
$
(163,678,256)
$
(174,025,885)
$
(187,597,104)
Business-type activities…………………………………………………………
5,724,232
3,774,757
5,514,087
3,911,197
7,156,314
4,217,979
4,568,039
2,985,916
5,245,281
6,299,306
Total primary government net (expense)/program revenue…………………
$
(130,422,699)
$
(148,068,317)
$
(134,862,606)
$
(128,811,630)
$
(137,984,585)
$
(132,447,626)
$
(153,782,811)
$
(160,692,340)
$
(168,780,604)
$
(181,297,798)
General Revenues and other Changes in Net Position
Governmental activities:
Real estate and personal property taxes……………………………… $
86,835,733
$
91,192,133
$
96,029,743
$
100,266,040
$
102,516,625
$
109,373,661
$
113,520,645
$
120,408,453
$
127,658,573
$
135,251,425
Tax and utility liens………………………………………………………
-
-
-
-
-
465,853
968,105
416,809
297,772
201,283
Motor vehicle and other excise taxes…………………………………
4,976,795
4,190,680
4,414,024
5,067,456
6,773,737
7,299,012
7,639,442
8,609,432
9,288,744
9,316,095
Penalties and interest on taxes…………………………………………
821,535
695,914
982,668
1,266,600
860,457
1,070,330
1,121,504
858,956
801,173
729,944
Payments in lieu of taxes………………………………………………
314,262
158,827
163,644
398,281
192,334
182,347
285,596
304,688
829,780
1,248,682
Community Preservation surtax………………………………………
-
-
-
-
-
-
1,323,320
1,430,721
1,545,198
1,664,815
Grants and contributions not restricted………………………………
32,519,533
38,521,736
23,777,003
24,479,415
22,936,689
23,120,989
23,374,357
25,642,432
24,429,136
25,455,469
Unrestricted investment income………………………………………
1,605,434
1,096,779
584,028
419,721
320,878
258,370
238,031
292,212
303,517
496,273
Gain on disposal of assets……………………………………………
1,780
7,838
8,635
9,355
-
-
-
2,031,564
2,031,564
2,031,564
Miscellaneous……………………………………………………………
2,010,382
2,019,017
458,502
884,039
61,023
115,049
278,074
113,230
308,206
184,008
Transfers, net……………………………………………………………
-
-
-
-
670,598
1,075,842
526,840
217,176
949,090
(345,056)
Total governmental activities……………………………………………………
129,085,454
137,882,924
126,418,247
132,790,907
134,332,341
142,961,453
149,275,914
160,325,673
168,442,753
176,234,502
Business-type activities:
Tax and utility liens………………………………………………………
1,589,910
1,609,372
1,413,910
1,562,666
-
-
-
-
-
-
Unrestricted investment income……………………………..…………
695,919
322,087
159,786
162,484
155,276
146,840
152,624
163,536
142,354
160,353
Transfers…………………………………………………………………
-
-
-
-
(670,598)
(1,075,842)
(526,840)
(217,176)
(948,090)
345,056
Total business-type activities……………………………………………………
2,285,829
1,931,459
1,573,696
1,725,150
(515,322)
(929,002)
(374,216)
(53,640)
(805,736)
505,409
Total primary government general revenues and other
changes in net position………………………………………………… $
131,371,283
$
139,814,383
$
127,991,943
$
134,516,057
$
133,817,019
$
142,032,451
$
148,901,698
$
160,272,033
$
167,637,017
$
176,739,911
Changes in Net Position
Governmental activities………………………………………………………… $
(7,061,477)
$
(13,960,150)
$
(13,958,446)
$
68,080
$
(10,808,558)
$
6,295,848
$
(9,074,936)
$
(3,352,583)
$
(5,583,132)
$
(11,362,602)
Business-type activities…………………………………………………………
8,010,061
5,706,216
7,087,783
5,636,347
6,640,992
3,288,977
4,193,823
2,932,276
4,439,545
6,804,715
Total primary government changes in net position…………………………… $
948,584
$
(8,253,934)
$
(6,870,663)
$
5,704,427
$
(4,167,566)
$
9,584,825
$
(4,881,113)
$
(420,307)
$
(1,143,587)
$
(4,557,887)
Note:
Prior to 2012, Veteran's Memorial Ice Rink and Dilboy Stadium activity was accounted for in a special revenue fund.
Last Ten Years
Changes in Net Position
City of Somerville, Massachusetts
121
Comprehensive Annual Financial Report
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
General Fund
Reserved……………………………$
12,484,743
$
14,740,399
$
15,210,735
$
-
$
-
$
-
$
-
$
-
$
-
$
-
Unreserved………………..………
17,701,780
11,952,907
12,687,703
-
-
-
-
-
-
-
Committed…………………………
-
-
-
18,712,499
21,929,103
24,171,167
25,038,098
30,065,350
33,354,136
34,533,997
Assigned……………………………
-
-
-
10,242,471
5,948,451
5,890,549
5,976,724
6,460,233
5,823,265
5,907,817
Unassigned…………………………
-
-
-
11,745,190
13,735,197
17,005,198
15,520,425
13,692,118
15,507,488
20,194,053
Total general fund…………………… $
30,186,523
$
26,693,306
$
27,898,438
$
40,700,160
$
41,612,751
$
47,066,914
$
46,535,247
$
50,217,701
$
54,684,889
$
60,635,867
All Other Governmental Funds
Reserved……………………………$
13,552,469
$
12,276,896
$
13,423,104
$
-
$
-
$
-
$
-
$
-
$
-
$
-
Unreserved, reported in:
Special revenue funds………
9,163,103
17,964,768
20,226,857
-
-
-
-
-
-
-
Capital projects funds………
119,927
(59,498)
6,678,591
-
-
-
-
-
-
-
Permanent funds……………
216,731
217,881
163,066
-
-
-
-
-
-
-
Nonspendable……………………
-
-
-
433,126
433,126
433,126
433,126
433,126
433,126
433,126
Restricted…………………………
-
-
-
32,172,936
23,955,913
24,039,762
29,105,031
32,953,447
36,444,641
40,328,168
Unassigned…………………………
-
-
-
(42,349)
(7,897,251)
(8,830,687)
(11,138,192)
(15,052,796)
(14,895,671)
(11,385,014)
Total all other governmental funds… $
23,052,230
$
30,400,047
$
40,491,618
$
32,563,713
$
16,491,788
$
15,642,201
$
18,399,965
$
18,333,777
$
21,982,096
$
29,376,280
Note: The City implemented GASB 54 in 2011, fund balances prior to 2011 have been reported in the pre-GASB 54 format.
Last Ten Years
Fund Balances, Governmental Funds
City of Somerville, Massachusetts
122
Comprehensive Annual Financial Report
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
Revenues:
Real estate and personal property taxes………………… $
85,100,033
$
89,398,919
$
95,031,409
$
98,921,096
$
102,575,530
$
109,391,564
$
113,427,599
$
120,742,247
$
127,359,478
$
134,759,721
Tax liens………………………………………………………
870,517
1,165,496
1,078,578
1,161,723
1,297,050
1,118,479
847,582
654,405
606,130
392,962
Motor vehicle and other excise taxes………………………
5,007,547
4,531,602
4,563,267
4,894,601
6,762,048
7,206,904
7,759,040
8,596,756
9,345,084
9,297,090
Payments in lieu of taxes……………………………………
314,262
158,827
163,644
398,281
192,334
182,347
285,596
304,688
829,780
1,248,682
Intergovernmental……………………………………………
95,212,975
89,793,239
83,710,418
85,293,814
83,228,489
95,364,763
88,757,484
75,012,124
77,436,920
91,261,649
Departmental and other………………………………………
21,760,536
22,282,936
23,300,994
23,946,046
23,732,924
22,579,819
22,368,780
31,314,092
26,795,775
29,238,662
Community preservation taxes………………………………
-
-
-
-
-
-
1,323,320
2,335,638
2,375,654
2,085,496
Contributions…………………………………………………
1,273,574
160,049
1,162,345
1,354,249
1,361,020
1,126,151
256,094
3,044,440
757,874
621,388
Investment income……………………………………………
1,605,434
1,096,779
584,028
419,721
320,878
238,620
238,031
292,212
308,289
500,910
Miscellaneous…………………………………………………
1,700,000
12,270,901
312,803
229,144
71,679
102,500
268,687
113,209
205,935
134,582
Total Revenue…………………………………………
212,844,878
220,858,748
209,907,486
216,618,675
219,541,952
237,311,147
235,532,213
242,409,811
246,020,919
269,541,142
Expenditures:
General government…………………………………………
11,832,794
12,284,477
11,345,329
12,623,157
12,679,343
16,705,382
17,643,136
19,760,973
21,121,725
22,099,097
Public safety…………………………………………………
33,422,270
31,952,078
31,850,195
30,938,872
36,463,494
37,408,954
37,020,112
38,187,360
38,861,329
41,113,649
Education………………………………………………………
58,150,030
61,298,672
60,033,670
63,007,532
63,303,388
65,203,861
68,950,650
71,696,093
76,278,689
78,217,082
Public works…………………………………………………
24,166,057
20,701,397
19,162,374
19,461,296
19,831,102
21,203,002
23,213,680
30,173,419
24,285,794
26,189,372
Community development……………………………………
4,807,530
9,503,292
6,015,349
5,142,819
5,225,117
5,092,521
5,399,251
6,731,292
4,752,888
8,904,122
Human services………………………………………………
3,682
108,906
2,681
7,095
312,548
288,766
224,330
229,633
178,570
244,417
Culture and recreation………………………………………
1,994,251
1,841,688
2,596,786
2,397,542
2,413,694
2,853,452
1,792,055
716,322
2,624,181
3,004,178
Pension benefits………………………………………………
24,027,834
25,601,417
25,028,473
25,986,011
27,154,941
28,472,130
29,482,862
19,710,963
23,927,384
28,429,418
Employee benefits……………………………………………
25,804,216
29,525,454
28,046,345
28,783,865
27,555,222
20,642,529
23,240,442
23,167,986
23,240,346
24,274,992
Claims and judgments………………………………………
-
-
-
-
124,666
87,190
149,138
237,987
99,590
53,800
Community preservation……………………………………
-
-
-
-
-
-
56,770
77,672
771,733
2,314,179
State and county charges……………………………………
9,083,059
9,628,426
9,815,484
10,990,847
10,922,689
11,189,172
11,854,949
12,569,633
12,740,178
13,532,201
Capital outlay…………………………………………………
19,917,387
6,947,220
6,576,020
9,937,843
35,537,453
28,892,038
12,164,916
14,038,651
18,695,120
13,805,058
Debt service:
Principal……………………………………………………
5,503,616
5,003,735
6,048,976
6,799,951
7,473,552
6,921,187
6,971,599
7,968,384
7,110,623
7,455,123
Interest……………………………………………………
2,836,481
2,615,224
2,802,736
2,404,731
2,494,542
2,871,080
2,890,706
3,016,183
2,866,743
3,639,566
Total Expenditures……………………………………
221,549,207
217,011,986
209,324,418
218,481,561
251,491,751
247,831,264
241,054,596
248,282,551
257,554,893
273,276,254
Excess of revenues over (under) expenditures……………
(8,704,329)
3,846,762
583,068
(1,862,886)
(31,949,799)
(10,520,117)
(5,522,383)
(5,872,740)
(11,533,974)
(3,735,112)
Other Financing Sources (Uses)
Issuance of bonds and notes………………………..………
13,713,522
-
10,695,000
6,305,000
15,750,000
13,940,000
6,250,000
8,603,000
17,771,000
12,335,000
Issuance of refunding bonds………………………………
-
-
15,129,000
-
-
-
-
-
-
-
Premium from issuance of bonds…………………..………
62,957
-
10,000
422,348
353,483
96,302
962,253
-
930,391
2,970,178
Premium from issuance of refunding bonds.………………
-
-
682,609
-
-
-
-
-
-
-
Payments to refunded bond escrow agent…………….
-
-
(15,811,609)
-
-
-
-
-
-
-
Sale of capital assets……………………………………………
1,780
7,838
8,635
9,355
16,384
12,549
9,387
-
-
2,120,152
Transfers in……………………………………………………
6,091,842
2,211,567
3,295,179
5,278,835
12,298,802
4,599,007
5,578,902
4,828,239
3,753,592
5,536,920
Transfers out…………………………………………………
(6,091,842)
(2,211,567)
(3,295,179)
(5,278,835)
(11,628,204)
(3,523,165)
(5,052,062)
(3,942,233)
(2,805,502)
(5,881,976)
Total other financing sources (uses)…………………
13,778,259
7,838
10,713,635
6,736,703
16,790,465
15,124,693
7,748,480
9,489,006
19,649,481
17,080,274
Net change in fund balance…………………………………… $
5,073,930
$
3,854,600
$
11,296,703
$
4,873,817
$
(15,159,334)
$
4,604,576
$
2,226,097
$
3,616,266
$
8,115,507
$
13,345,162
Debt service as a percentage of noncapital expenditures………
4.14%
3.63%
4.37%
4.41%
4.62%
4.47%
4.31%
4.69%
4.18%
4.28%
Last Ten Years
Changes in Fund Balances, Governmental Funds
City of Somerville, Massachusetts
123
Comprehensive Annual Financial Report
Assessed and Actual Values and Tax Rates
Total
Total
Total
Residential
Residential
Commercial
Industrial
Personal
Commercial
Commercial
Direct
City
Year
Value
Tax Rate
Value
Value
Property
Value
Tax Rate
Rate (2)
Value
2008
7,343,629,210
$
10.95
$
851,069,790
$
259,298,300
$
138,332,790
$
1,248,700,880
$
17.97
$
11.97
$
8,592,330,090
$
2009
(1)
7,178,108,247
$
11.71
$
826,175,153
$
260,306,700
$
144,604,120
$
1,231,085,973
$
19.25
$
12.81
$
8,409,194,220
$
2010
7,017,857,230
$
12.30
$
820,005,970
$
274,302,300
$
149,114,320
$
1,243,422,590
$
20.44
$
13.53
$
8,261,279,820
$
2011
7,027,712,955
$
12.71
$
831,013,262
$
273,718,283
$
165,431,820
$
1,270,163,365
$
21.21
$
14.01
$
8,297,876,320
$
2012
7,099,067,112
$
13.09
$
836,954,788
$
276,018,500
$
178,531,790
$
1,291,505,078
$
21.85
$
14.44
$
8,390,572,190
$
2013
7,293,246,502
$
13.42
$
843,242,898
$
273,007,500
$
185,838,150
$
1,302,088,548
$
22.38
$
14.78
$
8,595,335,050
$
2014
(1)
7,894,327,349
$
12.66
$
1,020,307,151
$
331,988,000
$
199,049,900
$
1,551,345,051
$
21.51
$
14.11
$
9,445,672,400
$
2015
8,909,186,864
$
12.61
$
1,055,713,836
$
311,627,700
$
215,696,880
$
1,583,038,416
$
20.38
$
13.78
$
10,492,225,280
$
2016
9,546,993,086
$
12.53
$
1,108,832,814
$
318,967,000
$
223,981,370
$
1,651,781,184
$
20.18
$
13.66
$
11,198,774,270
$
2017
10,814,213,402
$
11.67
$
1,255,256,698
$
339,856,200
$
251,203,200
$
1,846,316,098
$
18.81
$
12.71
$
12,660,529,500
$
(1) Revaluation year.
(2) The direct rate is the weighted average of the residential and commercial tax rates.
Source: Assessor's Department, City of Somerville
All property in the Commonwealth of Massachusetts is assessed at 100% of fair cash value.
Note: Chapter 59, Section 21C of the Massachusetts General Laws, known as "Proposition 2 1/2", imposes 2 separate limits on the
annual tax levy of the City. The primary limitation is that the tax levy cannot exceed 2 1/2 percent of the full and fair cash value.
The secondary limitation is that the tax levy cannot exceed the maximum levy limit for the preceding year as determined by
the State Commissioner of Revenue by more than 2 1/2 percent, subject to an exception for property added to the tax rolls and
for certain substantial valuation increases other than as part of a general revaluation. The secondary limit may be exceeded in any
year by a majority vote of the voters, however it cannot exceed the primary limitation.
Assessed Value and Actual Value of Taxable Property by Classification and Tax Rates
Last Ten Years
85%
10%
3% 2%
Total Assessed Value by Classification
Year Ended June 30, 2017
Residential
Commercial
Industrial
Personal Property
85%
10%
3%
2%
Total Assessed Value by Classification
Year Ended June 30, 2016
Residential
Commercial
Industrial
Personal Property
0.0%
2.0%
4.0%
6.0%
8.0%
10.0%
12.0%
14.0%
16.0%
18.0%
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
Commercial Value as % of Total Value
City of Somerville, Massachusetts
124
Comprehensive Annual Financial Report
Percentage of
Percentage of
Total Taxable
Total Taxable
Nature of
Assessed
Assessed
Assessed
Assessed
Name
Business
Valuation
Rank
Value
Valuation
Rank
Value
Street Retail Inc
Commercial
243,428,900
$
1
2.58%
-
$
-
-
NSTAR Electric Co
Electric Company
79,025,760
$
2
0.84%
54,794,010
$
3
0.64%
FR Assembly Square LLC
Shopping Mall
75,341,000
$
3
0.80%
62,391,000
$
1
0.73%
Twin City Plaza LLC
Retail Mall
51,025,000
$
4
0.54%
55,126,300
$
2
0.64%
SRI Assembly Row B6 LLC
Retail
56,333,900
$
5
0.60%
-
$
-
0.00%
NSTAR Gas Co
Electric Company
38,882,490
$
6
0.41%
-
$
-
-
I-93 Somerville LLC
Retail
38,156,100
$
7
0.40%
37,000,000
$
4
-
CRP 70 Inner Belt LLC
Telecom
35,568,300
$
8
0.38%
30,684,700
$
6
-
GAHC3 Somerville MOB LLC
Professional Building
35,181,900
$
9
0.37%
-
$
-
-
National Tax Search LLC Trustee
Office Building
34,553,600
$
10
0.37%
23,658,800
$
8
-
Kadima Medical Properties LLC
Professional Building
-
$
-
-
32,698,600
$
5
0.38%
IKEA Property Inc
Commercial Land
-
$
-
-
23,934,000
$
7
0.28%
FR Sturtevant Street LLC
Retail
-
$
-
-
19,668,400
$
9
0.23%
Clarendon Hills Towers Association
Apartments
-
$
-
-
31,787,100
$
10
0.37%
Totals
$687,496,950
7.28%
$371,742,910
3.26%
Source: Official Statement for Sale of Bonds
Principal Taxpayers
Current Year and Nine Years Ago
2017
2008
City of Somerville, Massachusetts
125
Comprehensive Annual Financial Report
(3)
Percent of
(2)
Less
(2)
First Year
Percent of
Delinquent
Total
Total Tax
Total
Abatements &
Net
Current
Net Levy
Tax
Tax
Collections to
Year
Tax Levy
Exemptions
Tax Levy
Tax Collections
Collected
Collections
Collections
Net Tax Levy
2008
88,230,603
$
740,520
$
87,490,083
$
86,635,835
$
99.02%
932,119
$
87,567,954
$
100.09%
2009
(1)
92,502,692
$
1,235,728
$
91,266,964
$
91,213,775
$
99.94%
56,154
$
91,269,929
$
100.00%
2010
96,493,032
$
1,372,905
$
95,120,127
$
94,988,009
$
99.86%
128,204
$
95,116,213
$
100.00%
2011
100,548,992
$
463,464
$
100,085,528
$
98,703,495
$
98.62%
1,377,979
$
100,081,474
$
100.00%
2012
104,765,287
$
1,088,607
$
103,676,680
$
102,975,339
$
99.32%
696,871
$
103,672,210
$
100.00%
2013
109,923,036
$
799,886
$
109,123,150
$
108,407,664
$
99.34%
711,174
$
109,118,838
$
100.00%
2014
(1)
116,112,597
$
1,416,537
$
114,696,060
$
113,841,400
$
99.25%
860,377
$
114,701,777
$
100.00%
2015
122,165,461
$
1,697,496
$
120,467,965
$
120,376,618
$
99.92%
814,136
$
121,190,754
$
100.60%
2016
129,147,863
$
1,680,095
$
127,467,768
$
126,428,749
$
99.18%
558,205
$
126,986,954
$
99.62%
2017
136,071,683
$
1,709,004
$
134,362,679
$
133,730,789
$
99.53%
-
$
133,730,789
$
99.53%
(1) Revaluation year.
(2) Includes tax liens.
(3) If the actual abatements and exemptions are lower than the estimate the actual collections can exceed the net levy.
Source: Assessor's Department, City of Somerville
Property Tax Levies and Collections
Last Ten Years
0
10,000,000
20,000,000
30,000,000
40,000,000
50,000,000
60,000,000
70,000,000
80,000,000
90,000,000
100,000,000
110,000,000
120,000,000
130,000,000
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
Millions
Real Estate Tax Levies vs. First Year Collections
Last Ten Years
Real Estate Tax Levy
First Year Current Tax Collections
City of Somerville, Massachusetts
126
Comprehensive Annual Financial Report
General
Percentage
Percentage
U. S. Census
Personal
Assessed
Obligation
Capital
Per
of Personal
of Assessed
Year
Population
Income
Value
Bonds
Leases
Capita
Income
Value
2008
75,620
2,093,461,649
$
8,592,330,090
$
68,811,515
$
-
$
910
$
3.56%
0.87%
2009
75,656
2,136,347,437
$
8,409,194,220
$
63,807,780
$
-
$
843
$
2.99%
0.76%
2010
75,754
2,463,292,818
$
8,261,279,820
$
69,122,803
$
-
$
912
$
2.81%
0.84%
2011
75,965
2,519,556,983
$
8,297,876,320
$
68,627,852
$
-
$
903
$
2.72%
0.83%
2012
76,267
2,580,164,990
$
8,390,572,190
$
76,177,493
$
-
$
999
$
2.95%
0.91%
2013
76,589
2,642,879,641
$
8,595,335,050
$
84,360,426
$
-
$
1,101
$
3.19%
0.98%
2014
78,804
2,773,699,578
$
9,445,672,400
$
84,481,455
$
-
$
1,072
$
3.05%
0.89%
2015
78,901
2,832,656,005
$
10,492,225,280
$
82,313,356
$
-
$
1,043
$
2.91%
0.78%
2016
80,318
2,941,198,848
$
11,198,774,270
$
93,750,365
$
-
$
1,167
$
3.19%
0.84%
2017
81,322
3,037,524,044
$
12,660,529,500
$
101,423,345
$
-
$
1,247
$
3.34%
0.80%
General
Total
Percentage
Percentage
Obligation
Capital
Debt
Per
of Personal
of Assessed
Year
Bonds
Leases
Outstanding
Capita
Income
Value
2008
12,926,533
$
-
$
81,738,048
$
1,081
$
3.90%
0.95%
2009
15,380,835
$
-
$
79,188,615
$
1,047
$
3.71%
0.94%
2010
15,377,277
$
-
$
84,500,080
$
1,115
$
3.43%
1.02%
2011
13,343,849
$
-
$
81,971,701
$
1,079
$
3.25%
0.99%
2012
14,245,269
$
-
$
90,422,762
$
1,186
$
3.50%
1.08%
2013
13,258,968
$
-
$
97,619,394
$
1,275
$
3.69%
1.14%
2014
11,801,568
$
-
$
96,283,023
$
1,222
$
3.47%
1.02%
2015
12,838,188
$
-
$
95,151,544
$
1,206
$
3.36%
0.91%
2016
10,494,094
$
-
$
104,244,459
$
1,298
$
3.54%
0.93%
2017
9,950,711
$
-
$
111,374,056
$
1,370
$
3.67%
0.88%
(1) Prior to 2008, water and sewer enterprise long-term debt activity was accounted for in the general fund.
Source: Audited Financial Statements, U. S. Census, Division of Local Services
Ratios of Outstanding Debt and General Bonded Debt
Last Ten Years
Governmental Activities
Business-type Activities (1)
Total Primary Government
City of Somerville, Massachusetts
127
Comprehensive Annual Financial Report
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
Equalized Valuation………………………
9,612,275,100
$
9,139,060,000
$
9,139,060,000
$
9,226,665,200
$
9,226,665,200
$
9,237,328,000
$
9,237,328,000
$
10,446,575,400
$
12,444,120,100
$
12,444,120,100
$
Debt Limit -5% of Equalized Valuation…
480,613,755
$
456,953,000
$
456,953,000
$
461,333,260
$
461,333,260
$
461,866,400
$
461,866,400
$
522,328,770
$
622,206,005
$
622,206,005
$
Less:
Outstanding debt applicable to limit…
74,634,995
73,888,615
83,900,079
81,671,701
90,422,762
97,619,394
96,283,023
95,151,544
104,244,459
111,374,056
Authorized and unissued debt…………
30,514,133
30,868,133
24,070,363
79,179,716
62,907,004
50,103,233
27,875,515
23,156,766
46,509,649
372,482,894
Legal debt margin…………………………
375,464,627
$
352,196,252
$
348,982,558
$
300,481,843
$
308,003,494
$
314,143,773
$
337,707,862
$
404,020,460
$
471,451,897
$
138,349,055
$
Total debt applicable to the limit
as a percentage of debt limit…………
21.88%
22.93%
23.63%
34.87%
33.24%
31.98%
26.88%
22.65%
24.23%
77.76%
Source: Official Statement for Sale of Bonds
Computation of Legal Debt Margin
Last Ten Years
City of Somerville, Massachusetts
128
Comprehensive Annual Financial Report
Estimated
Estimated
Share of
Debt
Percentage
Overlapping
City of Somerville, Massachusetts
Outstanding
Applicable
Debt
Debt repaid with property taxes
MWRA Water………………………………………………………………$
2,084,311,000
3.28% $
68,365,401
MWRA Sewer……………………………………………………………
3,690,804,000
3.41%
125,856,416
Massachusetts Bay Transportation Authority…………………………
5,656,191,000
3.12%
176,473,159
Subtotal, overlapping debt………………………………………………………………………….……………………
370,694,976
City direct debt……………………………………………………………………………………………………………
101,423,345
Total direct and overlapping debt……………………………………………………………………………………… $
472,118,321
Source: City of Somerville, Auditing Department and related organizations.
Direct and Overlapping Governmental Activities Debt
As of June 30, 2017
Note: Overlapping governments are those that coincide, at least in part, with geographic boundaries of the
City. This schedule estimates the portion of the outstanding debt of those overlapping governments that is
borne by the taxpayers of City. This process recognizes that, when considering the government's ability to
issue and repay long-term debt, the entire debt burden borne by the property taxpayers should be taken
into account. However, this does not imply that every taxpayer is a resident, and therefore responsible for
repaying the debt, of each overlapping government.
City of Somerville, Massachusetts
129
Comprehensive Annual Financial Report
Per
Capita
Population
Personal
Personal
Median
Unemployment
Year
Estimates
Income
Income
Age
Rate
2008
75,620
2,093,461,649
$
27,684
$
31.1
3.8%
2009
75,656
2,136,347,437
$
28,238
$
31.1
6.3%
2010
75,754
2,463,292,818
$
32,517
$
31.4
6.4%
2011
75,965
2,519,556,983
$
33,167
$
31.4
5.2%
2012
76,267
2,580,164,990
$
33,831
$
31.4
4.9%
2013
76,589
2,642,879,641
$
34,507
$
31.4
5.2%
2014
78,804
2,773,699,578
$
35,197
$
31.3
3.7%
2015
78,901
2,832,656,005
$
35,901
$
31.3
3.3%
2016
80,318
2,941,198,848
$
36,619
$
31.3
2.4%
2017
81,322
3,037,524,044
$
37,352
$
31.3
3.3%
Source:
U. S. Census, Division of Local Services, Executive Office of Labor and Workforce Development
Median age is based on most recent census data.
Demographic and Economic Statistics
Last Ten Years
City of Somerville, Massachusetts
130
Comprehensive Annual Financial Report
Nature
Percentage of
Percentage of
of
Total City
Total City
Employer
Business
Employees
Rank
Employment
Employees Rank
Employment
Partners Healthcare
Health Care
3,900
1
14.1%
-
-
-
ABM Industries
Janitorial Services
2,000
2
7.2%
-
-
-
Cambridge Health Alliance
Health Care
1,014
3
3.7%
771
1
3.5%
Angelica Corporation
Laundry
412
4
1.5%
546
2
2.5%
J&S Electric Company
Building Equipment
525
5
1.9%
-
-
-
Market Basket
Grocery Store
372
6
1.3%
275
5
1.3%
Rogers Foam Corporation
Foam Products
400
7
1.4%
-
-
-
Super Stop & Shop
Grocery Store
300
8
1.1%
-
-
-
FormLabs
Scientific Research
300
9
1.1%
-
-
-
Royal Hospital Services Incorporated
Office Supplies
260
10
0.9%
-
-
-
Ames Safety Envelope
Envelopes & Printing
-
-
-
400
3
1.8%
Star Market / Shaw's Supermarkets
Grocery
-
-
-
400
4
1.8%
MBTA
Railroad Maintenance
-
-
-
275
6
1.3%
Gentle Giant
Local Trucking
-
-
-
250
7
1.1%
Target
Retail
-
-
-
200
8
0.9%
Share Group
Non-Profit Telemarketing
-
-
-
196
9
0.9%
United Parcel Service
Package Delivery Service
-
-
-
180
10
0.8%
Totals
9,483
34.2%
3,493
16.0%
Source: Massachusetts Department of Workforce Development
Principal Employers (Excluding City)
Current Year and Nine Years Ago
2017
2008
City of Somerville, Massachusetts
131
Comprehensive Annual Financial Report
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
Full-Time Equivalents
City……………………………………………
721
712
708
670
675
696
714
729
736
755
School…………………………………………
847
853
823
843
845
892
908
923
929
937
Total …………………………………………
1,568
1,564
1,531
1,513
1,520
1,587
1,622
1,652
1,665
1,692
Source: Finance Committee Report
Full-Time Equivalent City Employees
Last Ten Years
City of Somerville, Massachusetts
132
Comprehensive Annual Financial Report
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
General Government:
Registered Voters………………………………
44,483
42,759
42,937
43,633
45,987
47,484
47,454
45,655
51,319
51,362
Births……………………………………………
827
885
873
922
962
957
974
863
838
639**
Marriages…………………………………………
595
602
586
553
503
591
548
513
590
511**
Deaths……………………………………………
410
393
459
441
420
410
517
589
561
454**
Dogs licensed……………………………………
981
1,120
1,289
1,595
1,967
1,790
2,127
1,780
2,053
1,812**
Business Certificates……………………………
451
471
466
445
451
425
483
318
307
218**
Fire:
Total Fires………………………………………
239
134
98
156
279
476
377
431
429
412*
Structure Fires…………………………………
75
59
42
44
60
107
56
258
321
212*
Vehicle Fires…………………………………
19
17
16
16
15
24
14
24
14
17*
Other Fires……………………………………
145
58
40
96
204
345
307
149
94
183*
Civilian
Deaths…………………………………………
0
0
0
3
1
0
0
0
0
0*
Injuries…………………………………………
2
1
24
41
22
5
1
0
8
3*
Fire Service
Deaths…………………………………………
0
0
0
0
0
0
0
0
0
0*
Injuries…………………………………………
112
84
76
81
44
71
38
17
29
28*
Dollar Loss………………………………………
2,981,170
$
2,211,115
$
2,258,000
$
3,019,600
$
2,438,000
$
5,850,000
$
1,559,364
$
663,875
$
3,601,500
$
$1,941,579*
Police:
Violent crime total………………………………
283
282
226
259
258
178
206
183
198
137**
Murder and nonnegligent manslaughter……
2
3
0
1
0
0
1
0
0
2**
Forcible rape…………………………………
20
7
14
17
22
17
10
8
15
7**
Robbery………………………………………
112
104
77
90
84
51
58
40
48
35**
Aggravated assault……………………………
149
168
135
151
152
110
137
135
135
93**
Property crime total……………………………
2,336
1,970
2,028
1,760
1,752
1,552
1,253
1,695
1,239
817**
Burglary………………………………………
453
493
514
416
349
430
192
305
207
124**
Larceny-theft…………………………………
1,633
1,314
1,336
1,193
1,270
1,021
949
1,257
931
628**
Motor vehicle theft……………………………
250
163
178
151
133
101
112
133
101
65**
Traffic and Parking:
Tickets Issued……………………………………
207,915
189,878
158,995
152,381
149,844
144,919
128,449
140,974
137,973
94,057**
Inspectional:
Building Permit Count…………………………
1,718
1,507
1,736
1,627
1,682
1,775
1,775*
2,166
2,034
1,744**
Education:
Total enrollment…………………………………
4,890
4,877
4,842
4,855
4,877
4,922
4,940
4,987
4,931
4,950
Library:+
Total Circulation…………………………………
425,743
499,205
501,095
466,304
448,579
415,666
411,566
387,222
396,812
396,812*
Total Holdings……………………………………
185,847
185,611
183,791
185,930
192,229
194,451
200,522
205,045
211,941
211,941*
Registered users………………………………
27,447
27,939
27,663
27,826
27,934
28,017
29,611
29,351
33,500
34,395
NA - Information not available
+ Denotes fiscal year reporting schedule, * Denotes estimates based on prior year data, ** Denotes year-to-date
Source: Elections Dept, City Clerk, Fire Dept, Police Dept, T&P Dept, ISD, Mass DoE, MBoLC
Operating Indicators by Function/Program
Last Ten Years
City of Somerville, Massachusetts
133
Comprehensive Annual Financial Report
Function
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
Fire:
Fire stations…………………………
5
5
5
5
5
5
5
5
5
5
Emergency vehicles…………………
8
8
8
8
8
8
8
8
8
8
Police:
Stations………………………………
3
3
3
2
2
3
3
3
3
3
Public works:
Streets (miles)………………………
105.64
106.15
106.17
106.17
106.17
108.97
115.11
119.7
119.7
119.7
Electric:
Streetlights…………………………
3,986
4,006
4,006
4,006
4,032
4,032
4,032
4,056
4,056
4,056
Sewer:
Sanitary sewers (miles)……………
68
68
68
68
68
68
68
68
68
68
Storm sewers (miles)………………
35
35
35
35
35
35
35
35
35
35
Library:
Main library…………………………
1
1
1
1
1
1
1
1
1
1
Number of branches………………
2
2
2
2
2
2
2
2
2
2
Parks and recreation:
City Parks
Number of Parks……………………
40
41
41
41
43
43
43
43
69
69
Acreage………………………………
48.18
49.27
49.27
49.27
51.35
51.35
51.35
51.35
58.3
58.3
DCR Parks in Somerville
Number of Parks……………………
6
6
6
6
6
6
6
6
8
8
Acreage………………………………
77.5
77.5
77.5
77.5
77.5
77.5
77.5
77.5
81.3
81.3
Other Open and Public Space
Number of Spaces…………………
28
28
28
28
28
28
28
28
10
11
Acreage………………………………
50.34
50.34
50.34
50.34
50.34
50.34
50.34
50.34
19.3
25
Water:
Water mains (miles)…………………
125
125
125
125
125
125
125
125
125
125
Fire hydrants…………………………
1,508
1,508
1,523
1,523
1,523
1,523
1,550
1,555
1,555
1,555
Education:
Elementary schools…………………
10
9
9
9
9
10
10
10
10
10
High school…………………………
1
1
1
1
1
1
1
1
1
1
NA - Information not available
Source: Various City Departments
Last Ten Years
Capital Asset Statistics by Function/Program
City of Somerville, Massachusetts
134
Comprehensive Annual Financial Report