Castle Rock Banner
File #: ID 2018-033    Version: 1 Name:
Type: Update/Presentation Item Status: Filed
File created: 1/2/2018 In control: Town Council
On agenda: 4/3/2018 Final action: 4/3/2018
Title: Update: Preliminary 2017 Unaudited Year-End Financial Review
Attachments: 1. Attachment A: 2017 Preliminary Year-end Financial Reports, 2. Attachment B: Sales Tax Collections by Category and Area

To:                     Honorable Mayor and Members of Town Council

 

From:                     Trish Muller, Finance Director

 

Title

Update: Preliminary 2017 Unaudited Year-End Financial Review

Body

________________________________________________________________________________

 

Executive Summary

 

Significant progress toward Town priorities was accomplished throughout 2017. The following discussion and financial information reflects the overall positive financial condition of the Town and highlights the continued focus on strategic priorities established by Council. These priorities include:

 

                     Ensuring outstanding public safety:  Construction of the new Fire Station 152 continues to be underway, along with the fabrication of new apparatus that will be housed at the Crystal Valley station. The town also purchased a Public Safety Training facility in 2017.

                     Securing our water future:  Castle Rock Water is working to provide high quality water service to customers, with a focus on the goal of bringing additional renewable water to the Town. Multiple projects are underway, including construction of additional groundwater wells, ongoing WISE partnership work, and the acquisition of additional water rights and storage capacity as part of the Alternative Source of Supply project. In addition, Castle Rock Water completed the purchase of significant surface water and ground water infrastructure and water rights in Douglas County. This purchase was split between Water and Water Resources funds. Stormwater continued work on numerous tributary and stream stabilization projects.

                     Enhancing our transportation:  Completion of the roundabout at Third and Perry and Annual Pavement Maintenance program for 2017 was complete. Design is underway on multiple growth related transportation projects for 2018, including the widening of Ridge Road, improvements at Crowfoot Valley Road, and Founders Parkway and improvements at Allen Way and Founders Parkway.

                     Maintaining strong parks and recreation:  The reimagined Festival Park is open for use and hosted the Town’s Starlighting event, on 2017. Design is underway for a new neighborhood park in 2018.

 

The Town’s 2017 overall financial condition continues to be strong. Preliminary year-end information indicates that the total Town revenues, in total for all funds, are over the 2017 budget by about $2.4 million. Town-wide expenditures are under budget approximately $58 million. The difference in budget and actual expenditures is primarily due to the capital projects that are being carried forward to 2018, which are identified in this report. The Town routinely accumulates funds in order to accommodate significant capital projects; planning, design, and construction often spans multiple years.  Unspent capital funding related to continuing projects will be carried forward into 2017 as part of the first budget amendment of 2018, also before council this evening.

 

While several factors contribute to the overall financial picture of the Town, below are other items of note throughout 2017:

                     Net sales tax collections are 10.9% higher than 2016

                     General Fund operational expenditures are about 4% lower than the amended budget for 2018

                     Overall development activity ended the year strong with more building permits issued than anticipated. However, some variation may be found in some funds due to the type and square footage of actual development activity through the end of 2018

 

Also of note, 2017 included expenditures of the 2015 TABOR surplus funds that voters permitted the Town to retain for the purpose of Public Safety and Transportation improvements.  In total, voters allowed the Town to retain $714,580, of which, $623,947 was expended in 2017.  The remaining balance of $90,633 will be carried forward into 2018 to complete payments for the Town Council approved use of these funds.  Below is a summary of how these funds have been used to benefit Public Safety and Transportation for the Town of Castle Rock:

                     The Police Department was able to purchase active shooter body armor/shields, rifle lights, K-9 ballistic/stab resistant vest, electronic speed signs, speed enforcement tools (LIDAR), a crash data reader, and mobile finger print units.

                     The Fire & Rescue Department purchased Automatic External Defibrillators (AEDs) to replace outdated models in Town facilities, add additional AEDs to downtown businesses, and in all marked police vehicles.  Other purchases included Stop the Bleed kits for multi-casualty events, buy-back of a reserve brush truck, a telescopic forklift, and battery powered vehicle extrication equipment.

                     Public Works utilized this funding for installation of numerous flashing yellow arrows at intersections around Town as well as enhancing numerous crosswalks by installing rapid flashing beacons to improve pedestrian safety.

 

The financial information in this report also includes:

                     Discussion and financial summaries by major category for each fund included in the Town’s financial information

                     Incorporation of all 2017 Council approved budget amendments

                     Preliminary 2017 year-end actual information for revenues and expenditures. Final numbers may change due to year-end processing and any audit adjustments.

 

Discussion

 

Financial reporting for the Town is a team effort between Finance, Department Managers, and staff. This reporting process assists with the ongoing financial monitoring efforts for revenues and expenditures. This Preliminary 2017 Unaudited Year-End Financial Review is a summary of the year’s financial activity in comparison to the 2017 Amended Budget. As demonstrated by the following information, departments continue effective and responsible management of the Town’s finances.

 

The funds most affected by growth revenues associated with increased development are transportation, capital funds, Castle Rock Water, the Economic Development Fund and the Development Services Enterprise Fund. There were 862 single-family permits in 2017 along with multi-family development that totaled 402 units. In addition, 129 new commercial permits were issued through the end of the year.

 

Preliminary year-end financial information indicates that the Town will likely not have a Taxpayer Bill of Rights (TABOR) surplus for 2017. The current financial information may change as a result of final year-end accounting entries and may be affected by the annual audit.  Any revenue changes resulting from these items may change the TABOR position for 2017. The final 2017 TABOR calculation is expected to be available in spring 2018 and will be reported to Council with an update on future TABOR projections. Staff is also monitoring future TABOR projections for 2018 which can vary based on timing of state contributions for planned transportation projects.

 

Financial Impact

 

Sales Tax:                     

Net sales tax revenue, collected at the 4% rate, ended 2017 up by 10.9% over the prior year.  Total sales tax revenues collected in 2017 amounted to $46,285,255.  The chart below illustrates a comparison of activity for the past five years of total sales tax collections. Please refer to Attachment B for Sales Tax collection information by categories and geographical areas.

 

 

 

There are 4,173 active businesses licensed with Castle Rock at the close of 2017 with   49% of this total is located within Castle Rock.  Delinquency collections for 2017 was over $584k and there are 39 active audits.

 

Town of Castle Rock Investments:

 

The following provides information about the Town's cash and investment balances broken out by Town fund.  Successful management of the Town’s cash balances and investments is important because this supports long range planning, as shown in the recently adopted 2018 Budget and the 2018 - 2022 Five Year Capital Improvement Plan.  Please note that the following information may vary from the fund balance information in the attached schedules based on timing differences between budget and cash investment reporting.

 

As demonstrated in the recently adopted 2018-2022 Five Year Capital Improvement Program, future capital project needs are significant and infrastructure construction is costly. Over the next five years, currently planned capital projects are projected to cost more than $268 million. The largest fund balance identified is within the Water Resources Fund, for which the Town's Five Year CIP includes significant future planning for the Plum Creek Diversion, Well Fields and Water Purification Facility. Roughly 61% of the total investment balance for the town is from Castle Rock Water funds.  These amounts have been accumulated over many years in order to plan and accommodate necessary infrastructure for the Town. The General Fund balance represents about 11% of the total balance and includes funding for future planning and current year expenses as well.

 

It is helpful to connect recent financial planning information with the existing balances in the Town's investment portfolio to understand why the amounts are necessary. Some of the amounts will be required sooner and others later, as Town growth necessitates infrastructure improvements.

 

As of 12/31/2017, the Town's Cash and Investment Balances by Fund are:

 

Governmental Activities

 

 

General Fund

 $      19,435,564

 

 Economic Development Fund

           5,766,099

 

Transportation Fund

         10,114,834

 

Capital Funds:

 

 

 Transportation Capital Fund

           7,019,183

 

 Parks Capital Fund

           2,482,004

 

 Fire Capital Fund

           4,922,956

 

 Facilities Capital Fund

           3,853,860

 

 Police Capital Fund

              281,210

 

Other Governmental Funds:

 

 

 General Long Term Planning Fund

              912,942

 

 DDA TIF Fund

           1,752,492

 

 Conservation Trust Fund

              527,375

 

 P.S. Miller Trust Fund

              238,687

 

 Public Art Fund

              105,127

 

 Special Events Fund

                  3,427

 

 Police Forfeiture Fund

                21,601

 

Internal Service Funds:

 

 

 Employee Benefit Fund

           3,534,948

 

 Fleet Fund

           2,853,847

 

Total Governmental Funds

 $      63,826,156

 

 

 

 

Business-type Activities

 

 

 Water Fund

 $      19,909,334

 

 Water Resources Fund

         54,648,052

 

 Stormwater Fund

           7,891,578

 

 Wastewater Fund

         26,271,657

 

 Golf Fund

           1,702,394

 

 Community Center Fund

           1,430,401

 

 Development Services Fund

           3,477,256

 

Total Enterprise Funds

 $    115,330,672

 

 

 

 

Total All Funds

 $    179,156,828

 

 

 

 

 

A portion of Town funds are currently invested in a Local Government Investment Pool known as CSAFE, Colorado Surplus Asset Fund Trust, and through the Town's Investment Advisor, Insight Investments.

 

The chart below identifies how Town funds are invested at the end of 2017.  As shown here, a significant portion of Town funds is managed within a Local Government Investment Pool or LGIP. The Local Government Investment Pool is a commonly used tool for municipalities, school districts, counties, special districts and other government agencies to conservatively invest public funds.

 

The Town's current investment advisor, Insight Investments, has been retained by the Town for the past four years and has demonstrated valued counsel during that time. Town staff proposed revisions to the investment policy and Town Council approved in February 2018. Changes to the current policy include the language to current practices and incorporate changes to align the Town’s policy with statutory guidelines while continuing with the Town’s conservative fiscal approach.

The Town's investment earnings by quarter as well as the cost associated with Insight Investments are reflected in the following table. The fees associated with investments in CSAFE are not included in the professional services cost as these fees are netted against the earnings and not billed separately.

Impact Fees, System Development Fees, and Building Use Tax:

 

Budget amounts for growth related revenues, such as impact fees, building use tax, and tap fees, are based upon the expected number of single family, multi-family, commercial, and other development permits issued. The 2017 budget was based on growth related revenues associated with 700 single-family permits and 100 multi-family units. The table to the right shows new permit issuance by year and quarter for the past five years.

Total of growth related revenues for Town impact fees, system development fees, and use tax collections are about 2% over revenue budget for 2017. Development revenue varies based on type and timing of permits.  Below is a summary of permitting activity through the same period, as compared to 2016:

 

                     Single Family: 862 Units (Compared to 752 for 2016)

                     Multi-Family: 402 Units (Compared to 380 for 2016)

                     Commercial: 129 Permits (Compared to 79 for 2016)

 

The chart that follows reflects activity for impact fee, system development fees, and building use tax revenues for the past five years.

 

 

 

 

 

Metered Water Charges:

 

Metered water collections for 2017 were 1% less than 2016.  Metered water sales are highly variable and based on precipitation in a given year.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Franchise Fees:

 

Franchise fees are revenues generated by utility companies providing services within the Town limits. This fee gives utility companies access to public streets and right-of-ways enabling them to supply and maintain services to citizens.  Although franchise fees are up as compared to 2016 by about $98 thousand, preliminary 2017 information indicates that those fees are 4% under budget for 2017. Franchise Fee revenue is driven by the number of subscribers for the respective utility, including cable, electricity and natural gas.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Motor Vehicle and Specific Ownership Tax:

 

Motor Vehicle Taxes are sales tax paid on the purchase price of a vehicle by Town residents. Douglas County collects the tax through the licensing process and remits the Town’s share on a monthly basis.  For 2017, the Motor Vehicle Taxes came in about 3% higher than in 2016. The following chart shows Motor Vehicle Tax revenue received over the past five years.

 

 

Specific Ownership Tax is levied on all motor vehicles, wheeled trailers, semi-trailers, trailer coaches, mobile homes and self-propelled construction equipment. Tax schedules are established by the State based on age and type of vehicle. Revenues are allocated to each city based on actual pro rata share of dollar value of registration.  Taxes are collected by the Douglas County Treasurer (1 month lag) (42-3-104, C.R.S.) Specific ownership tax collections are about 10% higher when compared to 2016 and about 2% over the 2017 budget. The chart that follows demonstrates annual Specific Ownership Tax revenues over the past five years.

 

 

General Fund:

 

Preliminary 2017 year-end actual information shows the total General Fund revenues were 3% greater than budget. Expenditures in the General Fund are about 8% under budget, mainly due to position vacancies and other cost savings throughout the fund. Timing of various capital projects and other expenditures, such as Festival Park design, the Town’s Mobile App, Park Trails Maintenance, have also contributed to the savings within the fund. The following graph identifies the budget amounts expended by category for 2016 and 2017. Please refer to Schedule A for additional information.

 

A summary of the General Fund Departments is provided below (Please refer to Schedule A for more information):

 

Town Council

The Town Council Division is 5% under the amended 2017 budget. Savings are related to the Services and Other category which includes service contract payments.  Actual service contract amounts were less than budgeted, contributing to savings for the Town Council Division.

 

Town Manager

The Town Manager Division is under budget for 2017 by 9% related to savings in the personnel and supplies categories.

 

Deputy Town Manager

The Deputy Town Manager Division is under budget for 2017 about 7% related to the services and other category.

 

Human Resources

The Human Resources Division ended 2017 over budget 2%, primarily due to increased employee recognition costs related to the completion of a number of significant town projects.

 

Community Relations

The Community Relations Division finished the year 13% under budget related to the services and other category and will be carrying forward funds for the town’s mobile app as part of the first 2018 Budget Amendment.

Innovation and Technology

The Division of Innovation and Technology is under budget 17% for 2017, primarily due to software and hardware maintenance and personnel vacancy savings.

 

Facilities

The Facilities Division ended 2017 about 8% under budget, primarily due to savings in building repair and maintenance costs.

 

Town Attorney

The Town Attorney’s Office ended the year nearly 15% under budget, with savings primarily in personnel and legal services.

 

Town Clerk

The Town Clerk’s Office ended 2017 approximately 27% under budget. Savings in this area are primarily attributable to a personnel vacancy and election cost savings.

 

Municipal Court

The Municipal Court Division ended 2017 about 15% under budget, primarily due to part-time personnel savings and lower than anticipated legal prosecution services expenses.

 

Finance

The Finance Department is under the 2017 budget by about 8%, primarily due to the timing of implementing of new Sales Tax software. This project was approved in 2017 and is included in the first Budget Amendment of 2018 to finalize the project.

 

Police

The Police Department completed 2017 about 2% under budget. Savings in this area are primarily attributable to personnel vacancies throughout the year and savings in gasoline, computer software, and other operating supplies.

 

The Police Department has completed purchasing items as approved by Town Council related to the expenditure of 2015 TABOR surplus funds.  Approved expenditures include the purchase of active shooter body armor/shields, rifle lights, K-9 ballistic vest, electronic speed signs, LIDAR speed enforcement system, a crash data reader, and mobile finger print units.

 

Fire and Rescue

The Fire and Rescue Department ended 2017 approximately 2% under budget. Savings in this area are primarily due to personnel vacancies throughout the year and various services accounts including training and software maintenance being under budget.

 

The Fire and Rescue Department has completed the purchase of the majority of items as approved by Town Council related to the expenditure of 2015 TABOR surplus funds.  Expenditures that have been completed in 2017 include the purchase of AED’s to replace existing units plus adding units to marked police vehicles, “stop the bleed” kits, a telescopic forklift, and a reserve brush unit. The department plans to carry funds forward to 2018 for final expenditures related to vehicle extrication equipment.

Development Services

The Development Services General Fund Division ended 2017 about 17% under budget. Savings in this division are primarily attributable to lower than anticipated historic preservation expenditures and personnel savings from position vacancies. 

 

Parks and Recreation

The Parks and Recreation Division is under the 2017 budget by about 3% related primarily to savings in the Services & Other category including savings in annual water costs.  Unspent capital funding for annual trail improvements will be carried forward into 2018 for ongoing projects in this area.

 

Non-Departmental

The Non-Departmental budget, under the responsibility of the Finance Department, is about 24% under budget for 2017. The Non-Departmental budget includes amounts for professional services, equipment purchases and transfers out to other funds that have yet to occur. 

 

This division also includes $3M related to the purchase and associated improvements of a Public Safety Training Facility; $1.2M of the total budget will be carried forward.

 

Public Works is in process of purchasing items as approved by Town Council related to the expenditure of 2015 TABOR surplus funds.  These transportation related improvements were budgeted to be spent out of this General Fund division in 2017.  Approved expenditures include the purchase and installation of additional flashing yellow turn lights and rapid flashing beacons for crosswalk enhancements.  These improvements have taken longer than anticipated and will continue into 2018. As such, remaining budget within the Finance Non-Departmental Division will be carried forward to accommodate project completion.

 

Downtown Projects

The Downtown Projects division, which accounts for the remaining funds from the 2012-2014 DDA TIF collections, is about 19% under budget through 2017.  Costs in this area include initial and ongoing design costs related to the Festival Park renovation project, which will be carried over to 2018 to finalize that project.

 

Transportation Fund:

 

Transportation Fund revenues were about 1% over budget for the year. Significant tax revenues ended 2017 over the revenue budget, resulting in the fund being over the overall revenue budget. However, Intergovernmental revenue is under budget due to the re-budgeting of the Meadows Parkway Reconstruction project to 2018, which resulted in the delay of corresponding federal grant revenue. Significant revenue sources in this fund include Sales Tax, Motor Vehicle Tax, which is sales tax paid on the purchase price of a vehicle by Town residents, and Building Use Tax.

 

Overall expenditures in the Transportation Fund were approximately 14% under the 2017 budget. Savings in this fund are primarily due to personnel vacancies throughout the year, lower than anticipated costs on the annual pavement maintenance program, and the rebudgeting of the Meadows Parkway Reconstruction project to 2018. Other amounts, primarily related to the Traffic Signal Upgrade project are planned to be carried forward to 2018 as part of the first budget amendment. Please refer to Schedule B for more information.

 

Capital Funds:

 

Capital funds are generally financed with impact fees and interest earnings.  As discussed previously, new single-family home permits were budgeted at a total of 700 single family and 100 multi-family units for 2017. The total 2017 permit issuance for single family is 862 and 402 for multi-family units. Actual revenue received may vary, depending on the type and timing of the permits issued.

 

Parks and Recreation Capital Fund

The Parks and Recreation Capital Fund exceeded the annual revenue budget by 31% for the year related to impact fee revenue.  This fund does not receive impact fees related to commercial development.  This fund is 5% under the expense budget for 2017 due to timing of capital projects.  In order to complete the Festival Park project and the design of the new neighborhood park, remaining budgeted funds will be carried forward into 2018.   Please refer to Schedule C for more information.

 

Municipal Facilities Capital Fund

Overall revenues in this fund exceeded budget by about 4% due to impact fee revenue collections for 2017.  Expenditures are about 82% under budget for the year. This is due to costs for the Central Service Center not yet occurring, which will be carried into 2018. Please refer to Schedule D for more information.

 

Fire Capital Fund

Revenue in this fund exceeded budget by about 5% due to strong impact fee revenue and investment earnings.  Expenditures in 2017 include costs related to the design and construction of the Crystal Valley Fire Station, which is underway, as well as the purchase of fire apparatus for the new fire station.   Expenditures in this fund were about 63% under budget due to timing of expenses related to the construction of the new fire station.  Since the construction of the new fire station will continue into 2018, funds will be carried forward into 2018 as part of the first budget amendment to accommodate finalization of the project. Please refer to Schedule E for more information.

 

Police Capital Fund

Revenue in the Police Capital Fund was about 15% over the revenue budget for 2017, primarily due to higher than anticipated impact fee collections. Expenditures were slightly under budget for the year.  Please refer to Schedule F for more information.

 

Transportation Capital Projects Fund

The Transportation Capital Projects Fund is intended to fund significant growth related capital projects. Revenues in this fund, which include Impact Fees and Building Use Tax, ended 2017 slightly under budget.

 

Expenditures were about 46% under the 2017 budget. Savings are primarily related to the North Meadows Extension/Castle Rock Parkway project. While minor work will continue to fully close this project, total savings of about $2 million have been realized. Other significant capital projects in this fund include design of improvements at Crowfoot Valley Road and Founders Parkway, design of improvements at Founders Parkway and Allen Way and design of widening of Ridge Road. 2017 Budgeted amounts for these projects will be carried forward to 2018 as part of the first budget amendment. Please refer to Schedule G for more information.

 

General Long Term Planning Fund

Revenue for this fund is received primarily from residential Building Use Tax, which is trending higher than budget, by about 20%. Budgeted expenditures in 2017 include general facility improvements, information system projects and transfers to other funds. The fund is about 14% under budget for the Services and Other category for the Town Hall Remodel and is being requested to continue into 2018 as part of the first Budget Amendment. Please refer to Schedule H for more information.

 

Castle Rock Water Funds:

 

Both revenues and expenditures are highly seasonal for the Castle Rock Water funds as a large amount of the revenue in the Water fund is related to water demand, which is greater in warmer months, and the majority of the budgeted expenditures in these funds are associated with capital construction projects and asset purchases that are dependent upon weather, regional partnerships, and permitting.

 

Combined revenue in all four funds in 2017 is about 4% over budget. This is primarily attributable to the Dominion Water Agreement that was approved by council for aquifer storage, recovery, and well infrastructure.

 

The total expenditures for all four Castle Rock Water funds were approximately 24% under budget for 2017. This is due to the somewhat seasonal nature of construction projects, schedule changes and delays. Capital expenditures for all four funds are about 29% under the 2017 budget. Significant projects within the Water Resources Fund include an ongoing focus on renewable water through continued focus on the WISE project, purchase of water rights and infrastructure through the Alternative Source of Supply project and the acquisition of existing groundwater and surface water infrastructure and water rights in Douglas County. Noteworthy projects under Water Fund waterline rehabilitation projects, construction of new groundwater wells, and upgrades to water storage tanks. Stormwater continued work on multiple tributary and stream stabilization work. Wastewater completed various repair and maintenance on existing infrastructure and began planning for an expansion of the Plum Creek Water Reclamation Authority Facility. Significant projects that will be carried forward into 2018 including renewable water projects, multiple drainage and stabilization projects, Plum Creek Water Purification Facility project, and new water supply well construction. Combined operating expenditures are about 7% under budget. Please refer to Schedules I through L for more information.

 

Golf Course Fund:

 

The Golf Course Fund revenue is 2% over the amended budget for 2017.  An approved rate increase of $3 for 18-hole green fees and $1 increase for 9-hole green fees was implemented in 2017.  This contributed to the, more than 3% increase, in per player revenue, from $80.06 in 2016 to $82.77 for 2017.  Play remains consistent with a total of 40,002 rounds played, an increase of 76 rounds over 2016 at Red Hawk Ridge Golf Course.  This year proved to be a record setting year for Red Hawk Ridge with the highest average revenue per player, highest total Food & Beverage revenue, and highest driving range revenue since the facility opened.  Additionally, a total of 10,248 tournament and league rounds were played in 2017, the most since 2005.

 

Expenditures are under budget by about 5% primarily due to timing of capital improvements that include bunker renovations and cart path improvements.  Improvements at Red Hawk Ridge in 2017 included the addition of concrete cart paths on three more holes plus replacing sand, and improving drainage, of a number of bunkers around the course.  A total of $91,827 will be carried forward from 2017 to 2018 in order to complete capital improvement projects including bunker renovations, practice area improvements, and reestablishing native areas of the course affected by the cart path improvements in the past year.

 

The following chart demonstrates a five-year comparison of green fee revenue for the Golf Course Fund.  For more information related to the Golf Course Fund, please refer to Schedule M.

 

 

Community Center Fund:

 

The Community Center Fund includes operations of both the Community Center and the Miller Activity Complex (MAC).  Schedule N in the attached financial statements contains more detailed information related to the Community Center Fund.

 

Charges for services provided by the Community Center are under the annual budget by about 8%, and are down about 1% as compared to 2016.  This decrease is primarily related to lower than budgeted admissions revenue at the Community Center and youth program revenue.  Total revenues for the year are 2% under the amended budget for 2017.  Preliminary expenditure totals for the Community Center Fund are under budget by 5% for the year.

 

Total daily visits at the Community Center for 2017 were 288,585; representing a decrease of 4% compared with 2016.  Although there was an overall decrease in daily visits, youth admissions increased by 6% and senior admissions increased by 2% as compared to 2016.  The MAC experienced total daily visits of 107,010 in 2017, compared with 107,252 for the same period in 2016.  While overall visits remained steady, youth admissions increased by 6% and senior admissions increased by 11% at the MAC as compared to 2016. 

 

Improvements to these facilities in 2017 have included automation of the Community Center HVAC system, new free weight equipment at the Community Center, installation of a new boiler for the leisure pool at the MAC, and numerous other enhancements such as painting, parking lot striping, and deep cleaning of interior and exterior spaces.  The planned budget amendment in 2018 includes the re-appropriation of funding for the purchase of a van that was planned in 2017 and will be finalized in 2018 as well as an increase in funding for boiler replacement at the Community Center pool.

 

The following charts illustrate the programs and punch card revenue for both facilities for the past five years.

 

 

Development Services Fund:

 

Overall revenues received in the Development Services Enterprise Fund at the end of 2017 are about 13% under budget. The Development Services Fund revenue budget in 2017 was based on an annual projection of 700 single-family permits. A total of 862 single family permits and 402 multi-family permits were issued throughout the year. Despite increased residential construction, permitting revenue ended the year lower than budget due to the type and quantity of commercial development in Castle Rock.

 

Expenditures for the fund are under the amended budget by about 10%, primarily due to the timing of construction and furnishing of the Town Hall addition project, in addition to personnel vacancies. Remaining costs related to the addition of Town Hall will be carried forward into 2018 to accommodate project completion.  Please refer to Schedule O for more information.

 

Employee Benefits Fund:

 

Revenue is about 11% under budget for the year. Revenue for 2017 was projected based on an estimated 8% increase in healthcare; however, actual plan changes resulted in no increase for the year.  Expenditures in the Employee Benefits Fund are about 9% lower than the 2017 budget amount primarily due to lower actual costs in the supplies category, medical services, employee wellness program, and employee assistance program. Please refer to Schedule P for more information.

 

 

 

 

Fleet Services Fund:

 

Revenues in the Fleet Services Fund are about 12% lower than the revenue budget primarily due to the carryforward of transfers from other funds for vehicle additions that will not be complete until 2018. Expenditures for the Fleet Services Fund ended the year about 27% under budget, primarily due to the timing of vehicle purchases which have not been completed, which will be carried forward to 2018 as part of the first budget amendment. Please refer to Schedule Q for more information.

 

Conservation Trust Fund:

 

The Conservation Trust Fund is about 2% over the budgeted revenue for the year related to lottery funds received in 2017. Expenditures are under the budget for the year by 35% due to timing of projects related to park improvements.  The remaining capital funds will be carried forward for use in 2018 as part of the first budget amendment.  Please refer to Schedule R for more information.

 

Philip S. Miller Trust Fund:

 

Revenue is under budget by about 1% for the year due to a lower than budgeted distribution received from the Philip S. Miller Trust.  Total expenditures in the Philip S. Miller Trust Fund are 4% under budget for the year.  Please note that for 2018, the Special Events Fund will be dissolved and budgeting for this initiative will reside within the Philip S. Miller Trust Fund.  Please see Schedule S for more information.

 

Public Art Fund:

 

Revenue in the Public Art Fund was about 2% over the 2017 budget based on preliminary information related to investment earnings.  Expenditures are about 13% under budget for the year.  Please see Schedule T for more information.

 

Economic Development Fund:

 

The Economic Development Fund focuses on the priorities of creating primary employment jobs, expanding the tax base, and creating an outstanding business climate. Revenue for the year is under budget by roughly 1% based on preliminary information.  For 2017, a total of 129 new commercial permits were issued, as compared to 79 in 2016.  Although the number of permits has increased compared to the prior year, actual revenue for Commercial Building Use Tax is lower than 2016 due to the type and square footage of commercial development that was permitted.  Appropriated expenditures in 2017 were allocated to meet current obligations and to fund potential future economic development assistance agreements. At the end of December, expenditures were about 53% under budget and included a loan to the Move, LLC plus other existing incentive agreement payments. Please refer to Schedule U for more information.

 

Police Forfeiture Fund:

 

The Police Forfeiture Fund includes funds received from cooperative efforts using the Town of Castle Rock’s Police resources assisting state or federal authorities in seizing illegal items. At the end of 2017 this fund exceeded the revenue budget significantly, due to the receipt of unplanned forfeiture revenue.  There were no actual or budgeted expenditures in this fund. Please refer to Schedule V for more information.

 

Downtown Development TIF Fund:

 

Revenue in this fund includes a quarterly disbursement of Sales Tax TIF revenue that is necessary to manage cash flow needs within the fund.  Year end revenue for the DDA TIF Fund is 17% lower than budgeted, due to lower than expected sales tax collection in the downtown area.  Expenses are about 17% under the 2017 budget primarily due to the timing of downtown projects that have not yet occurred; which includes a carry forward for projects that started 2017 and will continue in 2018. Please refer to Schedule W for more information.

 

Special Events Fund:

 

Revenue in the Special Events Fund reflects about 51% of budgeted revenue for the year.  The 2017 revenue budget was based on the original strategic plan for Special Events since historical revenue information was not available during the preparation of the 2017 Budget.  Revenue estimates for future years have been adjusted based on actual history of event performance.  Expenditures are about 10% under the budget for the year.  Note that all revenues and expenditures for Special Events are incorporated into the Philip S. Miller Trust Fund in 2018, which will result in dissolving this Special Events Fund.  Please see Schedule X for more information.

 

The inaugural season of events held in 2016 included a total of five concerts, with the highest number of tickets sold for one event being 912.  In 2017, six concerts were held at the amphitheater at Philip S. Miller Park, with the highest number of tickets sold for one event being a total of 1,628 for the Little River Band.  The following chart identifies total tickets sold per event for the 2017 season. 

 

 

 

 

Proposed Motion

 

This memo is intended to be for discussion purposes only.

 

Attachments

 

Attachment A:  2017 Preliminary Year-end Financial Reports

Schedule A - General Fund

Schedule B - Transportation Fund

Schedule C - Parks and Recreation Capital Fund

Schedule D - Municipal Facilities Capital Fund

Schedule E - Fire Capital Fund

Schedule F - Police Capital Fund

Schedule G - Transportation Capital Projects Fund

Schedule H - General Long Term Planning Fund

Schedule I - Water Fund

Schedule J - Water Resources Fund

Schedule K - Stormwater Fund

Schedule L - Wastewater Fund

Schedule M - Golf Course Fund

Schedule N - Community Center Fund

Schedule O - Development Services Fund

Schedule P - Employee Benefits Fund

Schedule Q - Fleet Services Fund

Schedule R - Conservation Trust Fund

Schedule S - Philip S. Miller Trust Fund

Schedule T - Public Art Fund

Schedule U - Economic Development Fund

Schedule V - Police Forfeiture Fund

Schedule W - Downtown Development TIF Fund

Schedule X - Special Events Fund

Schedule Y - Townwide Summary

 

Attachment B:  Sales Tax Collections by Category and Geographical Area