Page 1
Page 2
Page 3
Page 4
Page 5
Page 6
Page 7
Page 8
Page 9
Page 10
Page 11
Page 12
Page 13
Page 14
Page 15
Page 16
Page 17
Page 18
Page 19
Page 20
Page 21
Page 22
Page 23
Page 24
Page 25
Page 26
Page 27
Page 28
Page 29
Page 30
Page 31
Page 32
Page 33
Page 34
Page 35
Page 36
Page 37
Page 38
Page 39
Page 40
Page 41
Page 42
Page 43
Page 44
Page 45
Page 46
Page 47
Page 48
Page 49
Page 50
Page 51
Page 52
Page 53
Page 54
Page 55
Page 56
Page 57
Page 58
Page 59
Page 60
Page 61
Page 62
Page 63
Page 64
Page 65
Page 66
Page 67
Page 68
Page 69
Page 70
Page 71
Page 72
Page 73
Page 74
Page 75
Page 76
Page 77
Page 78
Page 79
Page 80
Page 81
Page 82
Page 83
Page 84
Page 85
Page 86
Page 87
Page 88
Page 89
Page 90
Page 91
Page 92
Page 93
Page 94
Page 95
Page 96
Page 97
Page 98
Page 99
Page 100
Page 101
Page 102
Page 103
Page 104
Page 105
Page 106
Page 107
Page 108
Page 109
Page 110
Page 111
Page 112
Page 113
Page 114
Page 115
Page 116
Page 117
Page 118
Page 119
Page 120
Page 121
Page 122
Page 123
Page 124
Page 125
Page 126
Page 127
Page 128
Page 129
Page 130
Page 131
Page 132
Page 133
Page 134
Page 135
Page 136
Page 137
Page 138
Page 139
Page 140
Page 141
Page 142
Page 143
Page 144
Page 145
Page 146
Page 147
Page 148
Page 149
Page 150
Page 151
Page 152
Page 153
Page 154
Page 155
Page 156
Page 157
Page 158
Page 159
Page 160
Page 161
Page 162
Page 163
Page 164
Page 165
Page 166
Page 167
Page 168
Page 169
Page 170
Page 171
Page 172
Page 173
Page 174
Page 175
Page 176
Page 177
Page 178
Page 179
Village of Grafton Wisconsin Prepared by the Department of Administrative Services 2014 Comprehensive Annual Financial Report COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE FISCAL YEAR ENDED DECEMBER 31 2014 ELECTED OFFICIALS TITLE NAME Village President James Brunnquell Village Trustee David Antoine Village Trustee James Grant Village Trustee Lisa Harbeck Village Trustee David Liss Village Trustee Susan Meinecke Village Trustee Dean Proefrock APPOINTED OFFICIALS TITLE NAME Village Administrator Darrell Hofland Director of Public WorksVillage Engineer David Murphy Chief of Police Charles Wenten Director of Planning and Development Jessica Wolff Director of Administrative Services Paul Styduhar Building Inspector Thomas Johnson Village Clerk Kelly Meyer Library Director John Hanson Parks and Recreation Director John Safstrom Fire Chief William Rice Published April 24 2015 i VILLAGE OF GRAFTON Comprehensive Annual Financial Report For the Fiscal Year Ended December 31 2014 TABLE OF CONTENTS INTRODUCTORY SECTION Letter of Transmittal................................................................................................................... 1 Table of Organization................................................................................................................. 8 Certificate of Achievement for Excellence in Financial Reporting............................................. .9 FINANCIAL SECTION INDEPENDENT AUDITORS REPORT ............................................................................................ 10 MANAGEMENTS DISCUSSION AND ANALYSIS.............................................................................. 14 BASIC FINANCIAL STATEMENTS Government-wide Financial Statements Statement of Net Position ......................................................................................... 29 Statement of Activities............................................................................................... 30 Fund Financial Statements Balance Sheet - Governmental Funds ..................................................................... 32 Reconciliation of the Balance Sheet Governmental Funds to The Statement of Net Position ................................................................................. 34 Statement of Revenues Expenditures and Changes in Fund Balances of Governmental Funds................................................................ 36 Reconciliation of the Statement of Revenues Expenditures and Changes In Fund Balances of Governmental Funds to the Statement of Activities ............ 38 Statement of Net Position - Proprietary Funds......................................................... 39 Statement of Revenues Expenses and Changes in Fund Net Position - Proprietary Funds................................................................. 40 Statement of Cash Flows - Proprietary Funds ......................................................... 41 Statement of Assets and Liabilities - Agency Funds ................................................ 43 Index to Notes to the Financial Statements .................................................................. 44 Notes to Financial Statements ...................................................................................... 45 ii VILLAGE OF GRAFTON Comprehensive Annual Financial Report For the Fiscal Year Ended December 31 2014 TABLE OF CONTENTS REQUIRED SUPPLEMENTARY INFORMATION Schedule of Revenues Expenditures and Changes in Fund Balances Budget and Actual - General Fund............................................................................. 84 Notes to Required Supplementary Information ............................................................. 85 COMBINING AND INDIVIDUAL FINANCIAL STATEMENTS AND SCHEDULES Combining Balance Sheet - Nonmajor Governmental Funds ....................................... 88 Combining Statement of Revenues Expenditures and Changes in Fund Balances - Nonmajor Governmental Funds...................................................... 90 Budgetary Comparison Schedule - General Fund ........................................................ 92 Schedule of Revenues Expenditures and Changes in Fund Balances - Budget and Actual Debt Service....................................................................................................... 96 Capital Projects .................................................................................................. 97 Tax Incremental Financing District No. 3............................................................ 98 Schedule of Operating Revenues and Expenses - Water Utility................................... 99 Schedule of Operating Revenues and Expenses - Wastewater Utility........................ 100 Schedule of Revenues Expenditures and Changes in Fund Balances - Budget and Actual Park and Open Space ..................................................................................... 103 Revolving Loan................................................................................................. 104 Woodlawn Cemetery Capital............................................................................ 105 Park and Recreational Facilities ...................................................................... 106 Recreation ........................................................................................................ 107 Library .............................................................................................................. 108 Environmental .................................................................................................. 109 Aquatics............................................................................................................ 110 Fire Department ............................................................................................... 111 Room Tax......................................................................................................... 112 Impact Fees...................................................................................................... 113 Tax Incremental Financing District No. 2.......................................................... 114 Tax Incremental Financing District No. 4.......................................................... 115 Tax Incremental Financing District No. 5.......................................................... 116 Equipment ........................................................................................................ 117 Fire and Rescue Equipment............................................................................. 118 Woodlawn Cemetery Perpetual Care............................................................... 119 iii VILLAGE OF GRAFTON Comprehensive Annual Financial Report For the Fiscal Year Ended December 31 2014 TABLE OF CONTENTS Fiduciary Funds Statement of Changes in Assets and Liabilities Agency Fund ...................... 120 Capital Assets Governmental Operations Schedule of Changes in Capital Assets Used in the Operation of Governmental Fund by Function and Activity............................................ 121 Schedule of Capital Assets Used in the Operation of Governmental Funds by Function and Activity...................................................................... 122 STATISTICAL SECTION Statistical Section Summary .................................................................................... 123 Table 1 - Net Position by Component....................................................................... 124 Table 2 - Change in Net Position.............................................................................. 126 Table 3 - Fund Balances Governmental Funds ....................................................... 128 Table 4 - Change in Fund Balances Governmental Funds...................................... 130 Table 5 - General Governmental Expenditures by Function ..................................... 132 Table 6 - General Governmental Revenues by Source ............................................ 133 Table 7 - Comparative Tax Levies for All Direct and Overlapping Governments and Total Collections............................................................................................... 134 Table 8 - Property Tax Levies and Collections ......................................................... 135 Table 9 - Property Valuations Assessed Valuations .............................................. 136 Table 10 - Assessed and Equalized Value of Taxable Property............................... 137 Table 11 - Comparative Tax Rates for All Direct and Overlapping Governments per 1000 of Assessed Value.......................................... 138 Table 12 - Comparative Tax Rates for All Direct and Overlapping Governments per 1000 of Equalized Value ......................................... 140 Table 13 - Ratio of Net General Obligation Debt to Equalized Value ...................... 142 iv VILLAGE OF GRAFTON Comprehensive Annual Financial Report For the Fiscal Year Ended December 31 2014 TABLE OF CONTENTS Table 14 - Ratio of Outstanding Debt by Type.......................................................... 143 Table 15 - Computation of Overlapping Debt ........................................................... 144 Table 16 - Revenue Bond Coverage Water and Wastewater Utility ......................... 145 Table 17 - Demographic Employment Information ................................................... 146 Table 18 - Principal Taxpayers Current Year and Nine Years Ago........................... 147 Table 19 - Principal Employers Current Year and Nine Years Ago........................... 148 Table 20 - Demographics.......................................................................................... 149 Table 21 - Operating Indicators by Function............................................................. 152 Table 22 - Personnel Schedule................................................................................. 154 Table 23 - Utility Plant............................................................................................... 158 Table 24 - Balance Sheet ......................................................................................... 160 Table 25 - Income and Retained Earnings Statement .............................................. 162 Table 26 - Operating Revenues and Expenses ........................................................ 164 Table 27 - Water Sales............................................................................................. 166 Table 28 - Wastewater Revenues ............................................................................ 168 Table 29 - Water Sold Water Pumped and Annual Inflow at Wastewater Treatment Plant170 Table 30 - Capital Asset Statistics by Function......................................................... 172 Village of Grafton Office of the Village Administrator 860 Badger Circle Grafton WI 53024 p 262 375-5300 f 262 375-5312 dhoflandvillage.grafton.wi.us May 6 2015 To the Citizens of the Village of Grafton Wisconsin The Comprehensive Annual Financial Report for the Village of Grafton Wisconsin for the fiscal year ended December 31 2014 is hereby submitted. This report consists of managements representations concerning the finances of the Village of Grafton. Consequently management assumes full responsibility for the completeness and reliability of all of the information presented in this report. To provide a reasonable basis for making these representations management of the Village of Grafton has established a comprehensive internal control framework that is designed both to protect the governments assets from loss theft or misuse and to compile sufficiently reliable information for the preparation of the Village of Graftons financial statements in conformity with generally accepted accounting principles GAAP. Because the cost of internal controls should not outweigh their benefits the Village of Graftons comprehensive framework of internal controls has been designed to provide reasonable rather than absolute assurance that the financial statements will be free from material misstatement. As management we assert that to the best of our knowledge and belief this financial report is complete and reliable in all material respects. Baker Tilly Virchow Krause LLP a firm of certified public accountants and consultants have audited the Village of Graftons financial statements. The goal of the independent audit was to provide reasonable assurance that the financial statements of the Village of Grafton for the fiscal year ended December 31 2014 are free of material misstatement. 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 unmodified opinion that the Village of Graftons financial statements for the fiscal year ended December 31 2014 are fairly presented in conformity with GAAP. The independent auditors report is presented as the first component of the financial section of this report. Generally accepted accounting principles require that management provide a narrative introduction overview and analysis to accompany the basic financial statements in the form of Managements Discussion and Analysis MDA. This letter of transmittal is designed to complement MDA and should be read in conjunction with it. The Village of Graftons MDA can be found immediately following the report of the independent auditors. 1 This report includes all funds of the Village. It includes all governmental organizations and activities for which the Village Board of Trustees is financially accountable. The Village provides the full range of municipal services normally associated with a municipality including general administration police and fire protection sanitation services the construction and maintenance of highways streets and related infrastructure recreational activities cultural events and economic development. In addition to general activities the Village Board exercises authority over the Grafton Water and Wastewater Utility therefore these activities are included in the financial statements. The Grafton Volunteer Fire Department became a Village department on January 1 2013 however the Grafton and Cedarburg School Districts are autonomous entities and have not met the established criteria for inclusion in the reporting entity and accordingly are excluded from this report. COMMUNITY PROFILE The Village is located in Ozaukee County in the southeastern part of Wisconsin approximately 20 miles north of downtown Milwaukee. The Village is 4.53 square miles in size and has a population of 11467. The Village of Grafton was incorporated in 1896. The Village Board of Trustees which consists of the Village President and six Trustees is elected at large and on a non-partisan basis. Annual elections are held in April. The terms of office are 2 years but are overlapping so that the Village is provided with a continuity of knowledge in the Village business and legislative matters The Board is responsible for enacting ordinances resolutions and regulations governing the Village as well as the appointment of members of various statutory and advisory boards and the Village Administrator. As Chief Administrative Officer the Village Administrator has the responsibility of administering programs in accordance with policies established by the Village Board and within the guidelines of the annual budget adopted by the Village Board. The annual budget serves as the foundation for the Village of Graftons financial planning and control. The development of the budget is completed as two separate projects the development of the governmental activities program budget and the development of the forecast budget for the Grafton Water and Wastewater Utility. All departments of the Village of Grafton are required to submit requests for appropriation for all governmental activities to the Village Administrator on or before the last Monday in August of each year. The Village Administrator uses these requests as the starting point for developing a proposed budget for the governmental activities. The Village Administrator presents the proposed budget for all governmental activities to the Village Board approximately the middle of October for review. The Village Board meets with the Village Administrator and all department heads at a budget workshop shortly after receiving the proposed budget. The Village Board is required to hold a public hearing on the proposed budget which is generally held the last Wednesday in October. The governmental activities budget is generally adopted at the first Village Board meeting in November at which time the required property tax levy is established. 2 ECONOMIC CONDITION AND OUTLOOK Recent unemployment rates have increased in the Milwaukee metropolitan area as throughout the nation. However Ozaukee Countys 2014 unemployment rate decreased to 3.5 percent compared to the 2013 unemployment rate of 4.5 percent. The Ozaukee County rate remains lower than the Wisconsin and Federal unemployment rates of 5.2 and 6.2 percent respectively. The Villages tax base increased in valuation from 2013 to 2014 by approximately 53 million or an overall increase of 4.8 percent. Of the 4.8 percent increase approximately 0.8 percent represented an offsetting increase in values due to new construction with an increase in value representing 4.0 percent. In 2014 the Village had 32.6 million of valuation in building permits 13.4 million more than the building permit valuation in 2013. New residential construction totaled 4.8 million in 2014 an increase of 0.1 million in comparison to 2013. Permits for commercial construction accounted for 52 percent of 2014 construction valued at 16.8 million. Residential construction including single and multi-family buildings accounted for 41 percent or 13.5 million of construction valuation. Industrial and tax-exempt construction made up the remaining 7 percent or 2.3 million. The Tax Incremental District TID No. 2 Grafton Business Park was created on June 3 1996 to provide for the installation of public improvements to promote industrial and related office development in the Grafton Business Park. Wisconsin Statutes allow the Village to receive tax increments until the net project costs are fully recovered or until a date 27 years after the formation of the District whichever occurs first. The public improvements were substantially completed in 1997 and eight industrial or office projects have been constructed within the district. As of January 1 2014 the tax incremental district equalized value increase between the tax incremental base value of 1996 and the current equalized value of all taxable property within TID No. 2 is 17.7 million. The Village approved an amendment to the original plan in 2009 to include the ability of the district to donate funds to TID No. 3 Downtown Redevelopment. In 2011 the Village approved an additional amendment to include the property where Regal Beloit office building was constructed in 2012. This property was integral in solidifying the economic development of the Village. TID No. 3 Downtown Redevelopment was created on May 3 1999 to provide for the infrastructure improvements traffic circulation public parking streetscape improvements pedestrian amenities and way-finding improvements necessary to stimulate private reinvestment and redevelopment within the downtown area. As part of this effort a Community Development Authority CDA was created in 1999. The CDA has been a volunteer organization involved in the planning and development process. In 2000 five properties were acquired at the intersection of 12th Avenue and Washington Street and the structures razed. Two of these properties were sold in 2001 for the development of a full service bank BMO Harris Bank with additional non-bank offices. The property at the northwest corner was sold in 2004 for the construction of a 5000 square foot office building. The remaining properties were sold in 2005 for the construction of two mixed use buildings 22000 and 12400 square feet respectively. In 2004 the Village acquired one property on 11th Avenue which was sold for the construction of a 44 unit condominium The Heritage of Grafton completed in 2005. 3 The Village acquired three parcels on 11th Avenue and two additional properties one on Bridge Street and one on 13th Avenue which were sold in 2004 for the construction of a 9 unit condominium The Bridgewater. Street reconstruction projects completed in 2006 in TID No. 3 included extension of Beech Street from 12th Avenue to Wisconsin Avenue reconstruction of 13th Avenue and streetscape of Wisconsin Avenue. The Paramount Plaza - a public plaza and a river walk along the Milwaukee River were completed in 2006. A retailoffice building was constructed in 2007 with a brew pub and restaurant that opened in 2008. In 2008 recognizing the need for additional parking due to the success of the downtown businesses the Village purchased land and constructed additional parking lots. An additional two lots were added in 2009. One was constructed and the other lot was an existing private lot purchased by the Village. In 2012 the Grafton Hotel property located at 1312 Wisconsin Avenue was completed consisting of 20 residential apartments. This development included the renovation of a historical property and is the centerpiece of the redevelopment in the district. As of January 1 2014 the tax incremental district equalized value increase between the tax incremental base value of 1999 and the current equalized value of all taxable property within TID No. 3 is 25.4 million. The Village approved an amendment to the original plan in 2009 enabling the district to receive donated funds from TID No. 2 Grafton Business Park. TID No. 4 South Commercial District was created on September 21 2004 to provide for the infrastructure improvements traffic circulation public parking streetscape improvements pedestrian amenities and way-finding improvements necessary to stimulate private reinvestment and redevelopment within the South Commercial District. In April 2005 the Village approved an amendment to the previous plan that included additional properties identified as integral in solidifying the development of the Village. In 2008 an older mall was demolished and construction began on a mixed commercial and residential development. The commercial component was completed in 2009. As of January 1 2014 the tax incremental district equalized value increase between the tax incremental base value of 2004 and the current equalized value of all taxable property within TID No. 4 is 8.3 million. The Village approved an amendment to the original plan in 2010 enabling the district to receive donated funds from TID No. 2 Grafton Business Park and TID No. 5 Grafton Commons. TID No. 5 Grafton Commons was created on April 20 2006 to provide infrastructure improvements traffic circulation and streetscape improvements necessary to stimulate private investment and commercial development of the area. The location of Grafton Commons is the northwest quadrant of Interstate 43 and WIS 60. The retail stores located in the district include Costco Best Buy Kohls Department Store Petsmart Pet Store Dicks Sporting Goods and Michaels Arts and Crafts. In 2009 an Aldi Food Store and Steinhafels Mattress store opened. As of January 1 2014 the tax incremental district equalized value increase between the tax incremental base value of 2006 and the current equalized value of all taxable property within TID No. 5 is 36.3 million. The Village approved an amendment to the original plan in 2009 enabling the district to donate funds to TID No. 3 - Downtown Redevelopment and in 2010 approved an amendment enabling the district to donate funds to TID No. 4 South Commercial District. The Water Utility currently has six deep wells with a capacity of 5225760 gallons per day. The 2014 average daily water pumped was 996805 gallons per day or approximately 19 percent 4 of the total supply capacity. A Water System Master Plan study was last updated in 2001. Therein projected water demands predict a need for a future well on the Villages east side at some time between 2010 and 2020. Additional water storage of 330000 gallons will also be required by 2020. An amendment to the Master Plan was completed in 2002 that included an evaluation of Lake Michigan water supply alternatives. The study indicated that the Utilitys current groundwater supply is quite adequate through the year 2020 planning period. A further conclusion identified that the most cost-effective lake water supply option in the future would be construction of a new water treatment plant with some level of regional cooperation. This conclusion was further reinforced in 2012 with a regional water system investigation study that was completed jointly with the cities of Cedarburg and Mequon. The Utilitys wastewater treatment plant currently discharges directly to the Milwaukee River. The facilitys most recent discharge permit expired December 31 2013 a new discharge permit has yet to be issued A construction upgrade to the treatment plant was completed in 2005 and effectively increased the treatment capacity from 1600000 gallons per day to 2500000 gallons per day. The project was completed at a cost of 684000 and should extend the plants service life until 2024. In 2014 the average daily flow to the treatment plant was 1420000 gallons per day or 57 percent of the design flow capacity. Construction projects occurred in 2012 consisting of a new garage and septic receiving station. The septic receiving station construction began operation in April 2014. Administratively water and sewer rate studies were completed in 2013. A water rate increase request was approved by the Village Board of Trustees and submitted to the Public Service Commission in January 2014. The water rate increases was approved effective March 19 2014. The water and sewer rates increased 7.2 and 9.0 percent respectively. The Public Service Commission of Wisconsin classifies the Village utility as an AB utility. An AB classification is for utilities with a customer base in excess of 4000. Grafton had an average customer base of 4973 in 2014. MAJOR INITIATIVES FOR THE YEAR The development trend in 2014 was an increase in growth and development. Patriot Commons was developed in 2014 totaling 25000 square feet and opened in January 2015. This development is located on Port Washington Road near the Interstate 43 corridor and consists of a Mens Wearhouse ULTA Beauty and Pier 1 Imports. Construction activity in TID No. 2 Grafton Business Park consisted of a 24200 square foot expansion of Kapco for additional manufacturing space. Construction began in 2014 and is scheduled for completion and occupancy in early 2015. Grafton Preschool and Just for Fun received approval for a new 16000 square foot facility and construction started in October 2014. On the Villages east side Meijer construction began in 2014 for a super center totaling 191352 square feet located south of Home Depot on Port Washington Road which was 5 approved in 2013. The approval includes three outlots for development. In conjunction with this development the Village upgraded in 2013 1320 lineal feet of Port Washington Road to a four lane highway at a cost of 1581564. In the Villages South Commercial District Cornerstone Community Bank purchased property located next to their existing building renovated one building and razed another building. Burlo Pet Services purchased an empty industrial building renovated the building and opened for business during 2014. NAPA purchased existing commercial space renovated and relocated their business during 2014. Residential development increased in 2014 with the issuance of 23 building permits for new single family units. There were 13 building permits issued in 2013 for new single family units. FOR THE FUTURE The Lumberyard Site Master Plan which was completed in 2010 has provided a blueprint for redevelopment opportunities. The Community Development Authority purchased three lots in 2013 and two lots in 2014 in anticipation of this redevelopment. A developer submitted plans in 2015 for the construction of a 16.6 million mixed use project which will be developed over the next three years. Development projects in the South Commercial District include the approval of Village Pointe Commons a 22 million proposal for the 2015 construction of senior housing and care camps south of the new Pick n Save Store. FINANCIAL MANAGEMENT Budgetary controls. The objective of budgetary controls is to ensure compliance with legal provisions embodied in the annual budget approved by the Village Board. Activities of the general fund special revenue funds debt service fund capital improvement funds Enterprise funds and a permanent fund are included in the annual appropriated budget. The budget is adopted at the functional level of expenditure however it is monitored by department heads at the departmental level within an individual fund. As demonstrated by the statements and schedules included in the financial section of this report the Village continues to meet its responsibility for sound financial management. AWARDS AND ACKNOWLEDGEMENTS Over the past year the Village received two awards. The Village received the Certificate of Achievement for Excellence in Financial Reporting for the 2013 Comprehensive Annual Financial Report CAFR and the Distinguished Budget Presentation Award for the 2014 Program Budget from the Government Finance Officers Association. We wish to thank the Village President and the Village Board whose leadership and continued support made the preparation of this report possible. Preparation of this report was also made possible with the assistance of Baker Tilly Virchow Krause LLP. Special appreciation is also 6 given to Accountant Monica Stern whose contributions made the preparation and completion of this CAFR possible. Respectfully submitted Darrell Hofland Paul Styduhar Darrell Hofland Paul Styduhar Village Administrator Director of Administrative Services 7 Name Title Darrell Hofland Village Administrator William Rice Fire Chief Charles Wenten Police Chief Tom Johnson Building Inspector Dave Murphy Director of Public Works Village Engineer Paul Styduhar Administrative Services Director Jessica Wolff Planning and Development Director John Safstrom Parks and Recreation Director John Hanson Library Director Functional Authority Appointment Authority Citizens of Grafton Village Board Administrator Darrell Hofland Library Board Police Fire Commission Library John Hanson Public Works Dave Murphy Administrative Services Paul Styduhar Inspection TomJohnson Parks and Recreation John Safstrom Planning Development Jessica Wolff Fire William Rice Police Charles Wenten Citizen Boards Commissions 8 The Government Finance Officers Association of the United States and Canada GFOA awarded a Certificate of Achievement for Excellence in Financial Reporting to the Village of Grafton for its comprehensive annual financial report for the fiscal year ended December 31 2013. This was the eleventh consecutive year that the Village of Grafton has achieved this prestigious award. In order to be awarded a Certificate of Achievement a government must publish an easily readable and efficiently organized comprehensive annual financial report. 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 the Certificate of Achievement Programs requirements and we are submitting it to GFOA to determine its eligibility for another certificate. 9 INDEPENDENT AUDITORS REPORT 10 11 12 13 MANAGEMENTS DISCUSSION AND ANALYSIS 14 Managements Discussion and Analysis Unaudited As management of the Village of Grafton we offer readers of the Village of Graftons financial statements this narrative overview and analysis of the financial activities of the Village of Grafton for the fiscal year ended December 31 2014. We encourage readers to consider the information presented here in conjunction with additional information that we have furnished in our letter of transmittal which can be found on pages 1 - 7 of this report. Financial Highlights The assets of the Village of Grafton exceeded its liabilities as of December 31 2014 by 66893756 net position. Of this amount 9687083 may be used to meet the governments ongoing obligations to citizens and creditors unrestricted net position. The total net position includes all infrastructure installed from 1980 to present. The Village of Graftons total net position increased by a net amount of 2166396 with a 410338 decrease in unrestricted net position. As of December 31 2014 the Village of Graftons governmental funds reported combined ending fund balances of 7922587 a decrease of 204239 in comparison with the prior year. Approximately 54 percent of this total or 4263461 is available for spending at the governments discretion committed assigned and unassigned fund balance. As of December 31 2014 the assigned and unassigned fund balance for the general fund was 3258286 approximately 37 percent of total anticipated general fund expenditures for 2015. The Village of Graftons total general obligation debt decreased by 2881452 7.1 during 2014. No new debt was issued in 2014. Overview of the Financial Statements This discussion and analysis is intended to serve as an introduction to the Village of Graftons basic financial statements. These basic financial statements are comprised of three components 1 government-wide financial statements 2 fund financial statements and 3 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 Village of Graftons finances in a manner similar to a private-sector business. The statement of net position presents information on all of the Village of Graftons assets and liabilities with the difference between the two 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 Village of Grafton is improving or deteriorating. 15 The statement of activities presents information showing how the governments net position changed during the most recent fiscal 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 fiscal periods e.g. uncollected taxes and earned but unused compensated absences. Both of the government-wide financial statements distinguish functions of the Village of Grafton 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 Village of Grafton include general government public safety public works community enrichment services and conservation and development. The business-type activities of the Village of Grafton include the Grafton Water and Wastewater Utility. The government-wide financial statements include only the activities of the Village of Grafton. A Community Development Authority CDA has been established and is considered to be a component unit. However there was no financial activity for the CDA in 2014. The government-wide financial statements can be found on pages 29 31. of this report. 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 Village of Grafton 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 Village of Grafton 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 fiscal year. Such information may be useful in evaluating a governments 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 governments 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. 16 The Village of Grafton maintains twenty one individual governmental funds. Information is presented separately in the governmental fund balance sheet and in the governmental fund statement of revenues expenditures and changes in fund balances for the General Fund the Debt Service Fund the Capital Projects Fund and the Capital Projects Tax Increment District No. 3 TID No. 3 which are considered to be major funds. Data from the remaining seventeen governmental funds are combined into a single aggregated presentation. Individual fund data for each of these nonmajor governmental funds is provided in the form of combining statements later in this report. The basic governmental fund financial statements can be found on pages 32 - 38 of this report. Proprietary funds. Proprietary funds are used to report the same functions presented as business-type activities in the government-wide financial statements. Proprietary funds provide the same type of information as the government-wide financial statements only in more detail. The proprietary fund financial statements provide separate information for the Grafton Water Fund and Grafton Wastewater Fund which are considered to be major funds of the Village of Grafton. The basic proprietary fund financial statements can be found on pages 39 - 42 of this report. 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 Village of Graftons programs. The fiduciary fund maintained by the Village of Grafton is the Tax Collection Fund which records the tax roll and tax collections for the taxing jurisdictions within the Village of Grafton. The basic fiduciary fund financial statements can be found on page 43 of this report. 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. The notes to the financial statements can be found on pages 44 - 82 of this report. Other information The combining statements referred to earlier in connection with non-major governmental funds and other information related to the individual funds can be found on pages 88 91 of this report. 17 Government-wide Financial Analysis As noted earlier net position may serve over time as a useful indicator of a governments financial position. For the Village of Grafton total net position was 66893756 at the close of 2014. The largest portion of the Village of Graftons December 31 2014 net position approximately 82 percent reflects its net investment in capital assets e.g. land buildings machinery and equipment. The Village of Grafton uses these capital assets to provide services to citizens consequently these assets are not available for future spending. Although the Village of Graftons net investment in its capital assets is reported net of 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 the Village of Graftons net position approximately 4 percent represents resources that are subject to external restrictions on how they may be used. The remaining balance of unrestricted net position 9687083 may be used to meet the Villages ongoing obligations to citizens creditors and employees. Total capital assets increased by 748492 net of depreciation or 1.0 percent in 2014. In 2014 1834200 in governmental assets were added. However additions were offset by net disposals of 229511 and depreciation of 1709195. Business type capital assets of 2086566 were added in 2014 but offset by 1233388 in depreciation. Governmental activities. In 2014 governmental activities increased the Village of Graftons net position by 1994317. The key element in the increase in the Villages net VILLAGE OF GRAFTONS NET POSITION Governmental Business-type Activities Activities 2014 2013 2014 2013 2014 2013 Current and other assets 18666565 18807695 5160720 6659977 23827285 25467672 Capital assets 59451685 59556371 34278052 33424874 93729737 92981245 Total Assets 78118250 78364066 39438772 40084851 117557022 118448917 Deferred outflows of resources 384728 528214 90231 100165 474959 628379 Long-term liabilities outstanding 32314915 34989558 4480955 4968718 36795870 39958276 Other liabilities 3791516 3595186 1017463 1357792 4808979 4952978 Total Liabilities 36106431 38584744 5498418 6326510 41604849 44911254 Deferred Inflow of resources 9533376 9438682 - - 9533376 9438682 Net position Net Investment in capital assets 25406680 23046407 29495218 28162812 54901898 51209219 Restricted 1811405 2209985 658601 1210735 2470006 3420720 Unrestricted 5645086 5612462 3876766 4484959 9521852 10097421 Total net position 32863171 30868854 34030585 33858506 66893756 64727360 Totals As of December 31 18 position was an increase of approximately 2.4 million related to net investment in capital assets largely attributable to the Bridge Street dam approximately 1.6 million. Public Safety activities accounted for approximately 36 percent of the total 2014 governmental funds expenses within the Village of Grafton. Total Governmental Activity expenses decreased by 2255014 or 14 percent from 2013. This decrease is due to a the 2013 construction project for Port Washington Road 1581564 and a decrease in debt service payments of 701605. VILLAGE OF GRAFTONS STATEMENT OF ACTIVITIES Governmental Business-type Activities Activities Totals 2014 2013 2014 2013 2014 2013 Revenues Program revenues Charges for services 1879248 1674004 3862198 3752742 5741446 5426746 Operating grants and contributions 1331958 1369560 3000 4000 1334958 1373560 Capital grants and contributions 887114 1913310 112504 274982 999618 2188292 General Revenues Property taxes 9312273 9242618 - - 9312273 9242618 Other taxes 246653 240373 - - 246653 240373 Grants contributions not restricted to specific programs 1299482 934392 - - 1299482 934392 Investment income 41250 32240 14184 720 55434 32960 Other 48221 21641 - - 48221 21641 Total revenues 15046199 15428138 3991886 4032444 19038085 19460582 Expenses General government 1113773 1106731 - - 1113773 1106731 Public safety 4840222 4682409 - - 4840222 4682409 Public w orks 4205192 6027858 - - 4205192 6027858 Community enrichment services 1441183 1505768 - - 1441183 1505768 Conservation and development 365718 196761 - - 365718 196761 Interest and fiscal charges 1356035 2057640 - - 1356035 2057640 Water - - 1460774 1339615 1460774 1339615 Wastew ater - - 2088792 1919537 2088792 1919537 Total expenses 13322123 15577167 3549566 3259152 16871689 18836319 Change in net position before transfers 1724076 149029 442320 773292 2166396 624263 Special Item - Contribution of fire department assets - 2521204 - - - 2521204 Transfers 270241 270213 270241 270213 - - Increase in net position 1994317 2642388 172079 503079 2166396 3145467 Net position - beginning of year 30868854 28226466 33858506 33355427 64727360 61581893 Net position - end of year 32863171 30868854 34030585 33858506 66893756 64727360 For the year ended December 31 19 As depicted in the chart below taxes provided 63 percent of total revenue in 2014. Payments in lieu of taxes account for approximately 2.1 percent of the revenue classified as taxes. Property taxes have historically been the largest revenue source for governmental activities. Business-type activities. Business-type activities increased the Village of Graftons business-type activities net position increased by 172079 or 0.5 percent from the previous year. The increase in net position for the Grafton Water and Wastewater Utility is due to water and wastewater improvements. The following graph compares the operating revenues to the operating expenses of each utility. The rate of return of the water utility for 2014 was 2.72 percent. The operating income of the water utility was 298942 while the wastewater utility produced an operating income of 184291 a rate of return of 1.03 percent. Adjusting for Non-capital financing activities purchases of capital assets debt payments and investing activities the water and wastewater utilities had a net cash outflow of 1626928. Property and Other Taxes 63 Charges for Services 13 Operating Grants and Contributions 9Capital Grants and Contributions 6 Investment Earnings 0 Grants Contributions Not Restricted to Specific Programs 9 Other 0 2014 Revenues by Source - Governmental Activities 20 2014 Operating Revenues and Expenditures Business-type Activities As shown on the following chart the revenues of the Grafton Water and Wastewater Utility included capital grants and contributions investment income and miscellaneous income in addition to charges for services operating revenues. Investment income and miscellaneous revenues are not identified specifically to an individual program but to the fund as a whole. 0 500000 1000000 1500000 2000000 2500000 Water Wastewater Revenues Expenditures Charges for Services 97 Capital Grants and Contributions 3 Investment Income Misc Revenue 0 Revenues by Source - Business-type Activities 21 Financial Analysis of the Governments Funds As noted earlier the Village of Grafton uses fund accounting to ensure and demonstrate compliance with finance-related legal requirements. Governmental funds. The focus of the Village of Graftons governmental funds is to provide information on near-term inflows outflows and balances of spendable resources. Such information is useful in assessing the Village of Graftons financing requirements. In particular committed assigned and unassigned fund balances may serve as a useful measure of a governments net resources available for spending at the end of the fiscal year. As of December 31 2014 the Village of Graftons governmental funds reported combined ending fund balances of 7922587 a decrease of 204239 over the prior year. Approximately 54 percent or 4263461 is available for spending at the governments discretion committed assigned and unassigned fund balance. The remainder of the fund balance is restricted or non-spendable to indicate that it is not available for new spending because it has already been committed 1 to pay debt service 177646 2 to pay for capital equipment and projects 2664166 3 for long term receivables from participants of the Village of Graftons economic development revolving loan fund 627670 4 to generate income to pay for the perpetual care of the municipal cemetery 89790 and 5 for prepaid insurance premiums delinquent taxes and non-current receivables 99854. Of the 4263461 fund balance available for spending in the governmental funds committed assigned and unassigned fund balance the use of 3258286 or approximately 76 percent was in the general funds fund balance. The General Fund is the chief operating fund of the Village of Grafton. As of December 31 2014 the total fund balance of the general fund was 3350270 of which 2613552 was unassigned. This unassigned fund balance represents approximately 32 percent of 2014 total general fund expenditures while total general fund balance represents approximately 42 percent of that same amount. The fund balance of the general fund increased 262744 during fiscal year 2014. The 2014 annual program budget for the Village of Graftons general fund identified the appropriation of 631549 in fund balance to reduce the impact of taxes levied and to balance the budget. However actual expenditures were less than budgeted expenditures by approximately 6 percent or 533435 and actual revenues were more than budgeted revenues in the general fund by 362038 or approximately 5 percent. The Debt Service Fund has a total fund balance of 177646 all of which is restricted for the payment of debt service. The fund balance decreased by 39151. The Impact Fee Debt Service Fund was created to account for the accumulation of impact fees designated for the retirement of debt incurred to construct and improve the fire station library police station and public works facility. The collection of impact fees in 22 2015 will be applied to the debt service requirement and any additional funds received will be applied to the fund balance to pay for future debt service requirements. The Debt Service Fund advanced the Impact Fee Debt Service Fund 42976 in 2014 to meet the debt service requirements of the fund. The Capital Projects Funds provide funding for capital projects of the Village of Grafton or other unique expenditures which are not normal operating or maintenance type expenditures reportable within the general fund or other governmental funds. The total fund balance as of December 31 2014 is 2868936 of which 1413430 is related to capital equipment funds to be used for future capital purchases of the Fire Department. TID No. 3 Downtown Redevelopment has a deficit fund balance of 1221632 due to purchases of land anticipated to be sold and a decrease in increment revenue from a decline in property value. Proprietary fund. The Village of Graftons proprietary funds provide the same type of information found in the government-wide financial statements but in more detail. Unrestricted net positions of the Water and Wastewater Utilities at the end of the year amounted to 4041997 a decrease of 442962 from December 31 2013. The total growth in total net position was 172079. The financial statements and a statement of cash flows for the proprietary funds can be found on pages 39 - 42 of this report. General Fund Budgetary Highlights Differences between the original budget and the final amended budget were relatively minor. Total actual revenues were more than budgeted revenues by 362038. Licenses and Permits Intergovernmental Charges for Services Public Charges for Services Intergovernmental Revenue and tax related revenue exceeded budget by 223009 45342 44920 28346 and 7366 respectively. Fines and Forfeitures and Investment Earnings were less than budgeted by 16317 and 10898 respectively. Actual expenditures were less than budgeted expenditures by 533435. The Public Safety General Government Public Works and Conservation and Development program areas had favorable variances of 110742 27521 26698 and 15470 respectively. The Contingency account also had a favorable variance of 353474. Because expenditures were less than budgetary estimates the need to draw upon the fund balance of 631549 was not required. The favorable variance in revenues and expenditures aided in the increase of the General Funds fund balance by 262744. 23 Capital Asset and Debt Administration Capital assets. The Village of Graftons investment in capital assets for its governmental and business type activities as of December 31 2014 equals 93729737 net of accumulated depreciation. This investment in capital assets includes land buildings Improvements other than buildings machinery and equipment infrastructure and construction in progress. The total increase in the Village of Graftons investment in capital assets for the current fiscal year totaled 748492 net of depreciation or a 0.8 percent increase. Capital assets for Governmental Activities increased due to the Bridge Street dam project 1237723 and street and stormwater improvements 593265. Business-type activities capital assets increased due to 392910 of water and sewer asset additions and 1693656 of wastewater additions and construction in progress related to the wastewater septic receiving station project and utility garage. For further details on capital asset activity refer to Note III D of the Notes to Financial Statements. Long-term debt. At the end of the current fiscal year the Village of Grafton has total General Obligation debt outstanding of 37815841 entirely backed by the full faith and credit of the government. The Water and Wastewater Utility has 1160000 of outstanding revenue bonds to be paid through the collection of user fees. No new debt was issued in 2014. Village of Graftons Capital Assets Governmental Business-type Activities Activities Total 2014 2013 2014 2013 2014 2013 Land including easements 14782433 14360061 538255 538255 15320688 14898316 Buildings improvements and equipment 28956132 29064149 51020487 48416733 79976619 77480882 Infrastructure 36299704 34373775 - - 36299704 34373775 Construction in progress 55613 929416 890 810090 56503 1739506 Total Capital Assets 80093882 78727401 51559632 49765078 131653514 128492479 Less Accumulated Depreciation 20642197 19171030 17281580 16340204 37923777 35511234 Capital Assets net of Depreciation 59451685 59556371 34278052 33424874 93729737 92981245.0 24 The Village of Grafton received an Aa2 rating from Moodys for debt issued on May 24 2013 the most recent debt issued by the Village. State statutes limit the amount of general obligation debt a governmental entity may issue up to five percent of its total equalized valuation. The current debt limitation for the Village of Grafton is 57422250 which exceeds the Village of Graftons current outstanding general obligation debt. The Village Board has established a policy whereby the Village will not issue debt in excess of 85 percent of the state authorized debt limit. As of December 31 2014 the Village of Graftons outstanding debt equaled 66.0 percent of the state authorized debt limit. The Grafton Water and Wastewater Utility generally will avoid debt by maintaining and building cash and investments for improvements through its rate structure. Since 1996 the utility has been allocating monies to reserved fund accounts established for a variety of future infrastructure improvements including water main replacement sewer collection system replacement and new wastewater treatment facilities and equipment. Additional information of the Village of Graftons long-term debt can be found in note IIIF on pages 70 - 74 and also in the statistical section on pages 142 145. Economic Factors and Next Years Budgets and Rates The unemployment rate as of December 31 2014 for Ozaukee County which includes the Village of Grafton was 3.5 percent. This compares with an unemployment rate of 5.2 percent for the State of Wisconsin and a national unemployment rate of 6.2 percent. The rate of inflation for the Milwaukee Wisconsin metro area was 1.3 percent for 2014 while the 2013 equalized tax rate for taxes collected for 2014 operations increased 4.8 percent from 2013. However the tax levy increased by 64217 or 0.9 percent. Of the fund balance in the general fund 644734 is assigned and is available for spending in the 2015 budget. It is intended that the use of available fund balance will lessen the required tax levy yet meet Village of Grafton guidelines to maintain a minimum unassigned fund balance of 25 percent of General Fund expenses. Village of Graftons Outstanding Debt Governmental Business-type Activities Activities Total 2014 2013 2014 2013 2014 2013 General obligation 34138056 36714603 3677785 3982690 37815841 40697293 bonds and notes Revenue bonds - - 1160000 1235000 1160000 1235000 Total 34138056 36714603 4837785 5217690 38975841 41932293 25 Requests for Information This financial report is designed to provide a general overview of the Village of Graftons finances for all those with an interest in the governments finances. Questions concerning any of the information provided in this report or requests for additional financial information should be addressed to the Administrative Services Department or the Office of the Village Administrator 860 Badger Circle Grafton WI 53024. General information relating to the Village of Grafton Wisconsin can be found at the Villages website httpwww.QualityLifeGrafton.com. 26 THIS PAGE LEFT BLANK INTENTIONALLY 27 28 29 30 31 32 33 34 THIS PAGE LEFT BLANK INTENTIONALLY 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 THIS PAGE LEFT BLANK INTENTIONALLY 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 STATISTICAL SECTION This part of the Village of Graftons 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 Villages overall financial health. Category Table Numbers Financial Trends 1 2 3 4 5 These schedules contain trend information to help the reader understand how the Villages financial performance and well-being have changed over time. Revenue Capacity 6 7 8 9 10 11 12 These schedules contain information to help the reader assess the Villages most significant local revenue source the income tax. Debt Capacity 13 14 15 16 These schedules present information to help the reader assess the affordability of the Villages current levels of outstanding debt and the Villages ability to issue additional debt in the future. Economic and Demographic Information 17 18 19 20 21 22 These schedules offer economic and demographic indicators to help the reader understand the environment within which the Villages financial activities take place. Water and Wastewater Operating Information 23 24 25 26 27 28 29 30 These schedules contain service and infrastructure data to help the reader understand how the information in the Villages financial report relates to the water and wastewater services the Village provides. Sources Unless otherwise noted the information in these schedules is derived from the comprehensive annual financial reports for the relevant year. 123 Table 1 2005 2006 2007 2008 Governmental Activities Net investment in capital assets 17751646 14115078 15390005 13468385 Restricted 1432829 8765594 6278068 5392128 Unrestricted 5155772 1037751 3475017 5455613 Total Governmental Activities Net Position 24340247 23918423 25143090 24316126 Business-type Activities Net investment in capital assets 20726712 24058607 25297847 25328156 Restricted 818772 939334 968736 1202401 Unrestricted 4257949 2645946 3658025 3969611 Total Business-Type Activities Net Position 25803433 27643887 29924608 30500168 Primary Government Net investment in capital assets 38478358 38173685 40687852 38796541 Restricted 2251601 9704928 7246804 6594529 Unrestricted 9413721 3683697 7133042 9425224 Total Primary Government Net Position 50143680 51562310 55067698 54816294 Data Source Village of Grafton Annual Financial Reports VILLAGE OF GRAFTON WISCONSIN NET POSITION BY COMPONENT LAST TEN FISCAL YEARS 124 Table 1 2009 2010 2011 2012 2013 2014 15429261 20742649 21828625 22945260 23046407 25406680 2007639 1765487 1590269 848447 2209985 1811405 8697902 5159161 4500444 4432759 5612462 5645086 26134802 27667297 27919338 28226466 30868854 32863171 27045649 27754384 27677745 28162963 28162812 29495218 1291412 907585 1150616 1251824 1210735 658601 3170894 3095526 4039689 3940640 4484959 3876766 31507955 31757495 32868050 33355427 33858506 34030585 42474910 48497033 49506370 51108223 51209219 54901898 3299051 2673072 2740885 2100271 3420720 2470006 11868796 8254687 8540133 8373399 10097421 9521852 57642757 59424792 60787388 61581893 64727360 66893756 VILLAGE OF GRAFTON WISCONSIN NET POSITION BY COMPONENT LAST TEN FISCAL YEARS 125 Table 2 2005 2006 2007 Expenses Governmental Activities General Government 849959 832485 870316 Public Safety 3545072 3434909 3761114 Public Works 2990123 4941488 6077640 Community Enrichment Services 1491828 1331925 1469851 Conservation and Development 2730714 1253725 1656348 Interest and Fiscal Charges 797016 1297907 1592848 Loss on Retirement of Capital Assets - 421400 97751 Total Governmental Activities 12404712 13513839 15525868 Business Type Activities Water 1178433 1185261 1442713 Wastewater 1415798 1554477 1673389 Total Business Type Activities 2594231 2739738 3116102 Total Primary Government Expenses 14998943 16253577 18641970 Program Revenues Governmental Activities General Government 175375 143734 144191 Public Safety 642847 596713 789001 Public Works 713138 2494846 5976546 Community Enrichment Services 343898 422744 603133 Conservation and Development 80390 155591 173404 Total Governmental Activities Program Revenues 1955648 3813628 7686275 Business Type Activities Water 1342803 2127542 2516785 Wastewater 1476549 2367231 2796150 Total Business Type Activities Program Revenues 2819352 4494773 5312935 Total Primary Government Revenues 4775000 8308401 12999210 Net Expense Revenue Governmental Activities 10449064 9700211 7754593 Business Type Activities 225121 1755035 2196833 Total Primary Government Net Expense 10223943 7945176 5642760 General Revenues and Other Changes in Net Position Governmental Activities Taxes 6481156 6824960 7267342 Grants an Contributions not restricted to specific progams 655435 749523 775844 Investment Income 400206 1168128 1015814 Miscellaneous 297869 89452 219814 Gain on disposalsale of capital asset - - - Impact Fees 114332 - - Special Item - Contribution of fire department assets - - - Transfers - - - Total Governmental Activities General Revenues 7948998 8832063 9278814 Business Type Activities Investment Income 45004 87969 147261 Gains on disposalsale of capital assets - - 756 Miscellaneous - - - Transfers - - - Total Business Type Activities General Revenues 45004 87969 148017 Total Primary Government General Revenues 7994002 8920032 9426831 Change in Net Position Governmental Activities 2500066 868148 1503350 Business Type Activities 270125 1843004 2280721 Total Primary Government 2229941 974856 3784071 Data Source Village of Grafton Annual Financial Reports VILLAGE OF GRAFTON WISCONSIN LAST TEN FISCAL YEARS CHANGE IN NET POSITION 126 Table 2 2008 2009 2010 2011 2012 2013 2014 975718 1047936 1287202 1060715 1206024 1106731 1113773 3799337 3933738 4028675 4145259 4069235 4682409 4840222 3866639 4175123 3905416 4052703 4143976 6027858 4205192 1489936 1476475 1526436 1593125 1557193 1505768 1441183 5109841 393441 492458 701307 452034 196761 365718 1694032 1873040 1816320 1688388 1647863 2057640 1356035 - - - - - - - 16935503 12899753 13056507 13241497 13076325 15577167 13322123 1326489 1268301 1402617 1191427 1248987 1339615 1460774 1618759 1717067 1841661 1856418 1864949 1919537 2088792 2945248 2985368 3244278 3047845 3113936 3259152 3549566 19880751 15885121 16300785 16289342 16190261 18836319 16871689 2206868 347399 374557 404276 457109 460136 490324 1399826 834532 480325 472908 443517 857013 1195854 1282137 1040115 2589404 1499981 1356082 2857680 1263993 833956 377387 387463 371564 375098 372235 422101 157837 2170643 495835 474393 372047 409810 726048 5880624 4770076 4327584 3223122 3003853 4956874 4098320 1468698 2143321 1664582 1954540 1831098 1859023 1738987 1670120 2050932 2025332 2426190 2000670 2168701 2238715 3138818 4194253 3689914 4380730 3831768 4027724 3977702 9019442 8964329 8017498 7603852 6835621 8984598 8076022 10804879 8129677 8728923 10018375 10072472 10620293 9223803 193570 1208885 445636 1332885 717832 768572 428136 10861309 6920792 8283287 8685490 9354640 9851721 8795667 7743849 8386808 8997860 9107069 9302767 9482991 9558926 744923 808688 634850 673909 650295 934392 1299482 579175 206895 157353 160025 116622 32240 41250 399755 46417 186969 35584 25755 21641 48221 - 223032 14173 23626 13958 - - - - - - - - - - - - - - 2521209 - - 276513 270213 270203 270203 270213 270241 9467702 9948353 10261418 10270416 10379600 13262686 11218120 162196 41454 47808 31627 19624 720 14184 970 22500 17037 - 20124 - - - 11461 9272 16246 - - - - 276513 270213 270203 270203 270213 270241 163166 201098 196096 222330 230455 269493 256057 9630868 9747255 10065322 10048086 10149145 12993193 10962063 1526964 1818676 1532495 252041 307128 2642388 1994317 575560 1007787 249540 1110555 487377 503079 172079 951404 2826463 1782035 1362596 794505 3145467 2166396 VILLAGE OF GRAFTON WISCONSIN CHANGE IN NET POSITION LAST TEN FISCAL YEARS 127 Table 3 2005 2006 2007 2008 General Fund Reserved 76596 67325 122014 75991 Unreserved 1496946 1698772 2014242 2773149 Nonspendable - - - - Restricted - - - - Conmmitted - - - - Assigned - - - - Unassigned - - - - Total General Fund 1573542 1766097 2136256 2849140 Other Governmental Funds Reserved 9937452 9145997 6683471 5822531 Unreserved Special Revenue Funds 1390296 361196 389766 391086 Capital Project Funds 1648507 4101981 2323863 3017024 Nonspendable - - - - Restricted - - - - Committed - - - - Assigned - - - - Unassigned - - - - Total Other Funds 12976255 13609174 9397100 9230641 Total Governmental Funds Reserved 10014048 9213322 6805485 5898522 Unreserved 4535749 6161949 4727871 6181259 Non-spendable - - - - Restricted - - - - Committed - - - - Assigned - - - - Unassigned - - - - Total Governmental Funds 14549797 15375271 11533356 12079781 Data Source Village of Grafton Annual Financial Reports Note In 2011 the Village implemented GASB Statement No. 54 which changed the classifications of fund balances. Prior periods have not been reclassified to this new standard. VILLAGE OF GRAFTON FUND BALANCES GOVERNMENTAL FUNDS LAST TEN FISCAL YEARS 128 Table 3 2009 2010 2011 2012 2013 2014 84298 88717 - - - - 2893787 2822248 - - - - - - 91726 90824 85069 91984 - - - - - - - - - - - - - - 226924 412748 631549 644734 - - 2373908 2537741 2370908 2613552 2978085 2910965 2692558 3041313 3087526 3350270 3608095 2150117 - - - - 337351 657950 - - - - 5287776 1824312 - - - - - - 10799 8760 1471408 1653365 - - 1801489 971520 2320216 1913777 - - 570681 503469 790475 1195169 - - 1753864 1305064 1369897 1031643 - - 400145 400150 912696 1221637 9233222 4632379 3736688 2388663 5039300 4572317 3692393 2238834 - - - - 8518914 5304510 - - - - - - 668392 316207 1556477 1745349 - - 1801489 971520 2320216 1913777 - - 570681 503469 790475 1195169 - - 1414471 1501189 2001446 1676377 - - 1973763 2137591 1458212 1391915 12211307 7543344 6428796 5429976 8126826 7922587 VILLAGE OF GRAFTON FUND BALANCES LAST TEN FISCAL YEARS LAST TEN FISCAL YEARS 129 Table 4 2005 2006 2007 2008 Revenues Taxes 6550849 6885401 7329910 7811887 Intergovernmental 1528927 1586761 1602176 1994694 Licenses and Permits 346166 378364 537137 837933 Fines Forfeitures and Penalties 123888 126065 126490 132084 Public Charges for Services 436988 662589 455702 605924 Intergovernmental Charges for Serivces 186852 43076 52214 53412 Special Assessments 114332 216164 34303 125988 Investment Income 400206 1168128 1015814 579175 Miscellaneous Revenues 216438 431482 673517 3300103 Total Revenues 9904646 11498030 11827263 15441200 Expenditures by Function General Government 823032 819649 845376 932041 Public Safety 3261589 3286619 3562378 3568300 Public Works 1906633 4172379 5190572 2827722 Community Enrichment Services 1046545 1178477 1303740 1288536 Conservation and Development 2462302 1361693 1485639 5165763 Capital Outlays 2003905 8956734 4006478 2465738 Debt Service Principal Retirement 1309479 1168162 1665865 1880896 Interest 685221 1099423 1681307 1719210 Fiscal Charges 84781 190528 92429 42369 Total Expenditures by Function 13583487 22233664 19833784 19890575 Excess of Revenues Over under Expenditures 3678841 10735634 8006521 4449375 Other Financing Sources Uses Bond proceeds and Debt Premiums 9671575 11593128 4052480 4855000 Payment to Refund Debt - - - - Proceeds from Sale of Capital Assets - - 47997 80588 Transfers in 1347917 1901814 2668869 2889852 Transfers out 1347917 1901814 2604740 2829639 Total Other Financing Sources 9671575 11593128 4164606 4995801 Special Item - Contribution of Fire Department Assets - - - - Net Change in Fund Balances 5992734 857494 3841915 546426 Debt Service as a percentage of non-capital outlay expenditures 35.28 23.52 21.89 22.72 Data Source Audited Financial Statements VILLAGE OF GRAFTON WISCONSIN CHANGE IN FUND BALANCES GOVERNMENTAL FUNDS LAST TEN FISCAL YEARS 130 Table 4 2009 2010 2011 2012 2013 2014 10374018 9116020 9255400 9498246 9683361 9760244 1850392 1817076 1849051 1738932 2068890 2216493 560550 349367 420851 418053 415286 581886 128043 128648 108201 123709 107511 115783 435799 436416 428847 704078 1029055 1022269 52388 53513 70851 114883 250341 373238 114176 151664 145251 37236 1394717 161517 207009 153383 156055 116625 31311 41249 562525 618819 543734 212657 678460 864917 14284900 12824906 12978241 12964419 15658932 15137596 999338 991421 1003024 1123036 1031254 1069549 3742891 3804990 3932886 3836716 4179267 4276223 2428848 2484252 2680755 2674337 2693155 2720333 1271073 1331802 1393687 1361473 1320027 1306988 409349 501198 701976 506971 291538 374598 6818501 4776479 854960 1071184 3747885 2161164 2629287 2807678 2266498 2072758 2280753 2576547 1827165 1896685 1624166 1895802 1415956 1252309 137968 17750 50000 - - - 20264420 18612255 14507952 14542277 16959835 15737711 5979520 5787349 1529711 1577858 1300903 600115 10739126 835000 6359977 3284606 7834552 - 6190000 - 6260000 2989729 5350680 - 1285408 14173 45163 13958 25750 125635 3980176 5142685 3790792 4624392 4474150 4403998 3703664 4872472 3520769 4354189 4203937 4133757 6111046 1119386 415163 579038 2779835 395876 - - - - 1217918 - 131526 4667963 1114548 998820 2696850 204239 20.90 34.17 28.50 29.46 27.98 28.20 VILLAGE OF GRAFTON WISCONSIN CHANGE IN FUND BALANCES GOVERNMENTAL FUNDS LAST TEN FISCAL YEARS 131 Table 5 Fiscal General Public Public Community Enrichment Year Government Safety Works Services 2005 823032 6.1 3261589 24.0 1906633 14.0 1046545 7.7 2006 819649 3.7 3286619 14.8 4172379 18.8 1178477 5.3 2007 845376 4.3 3562378 18.0 5190572 26.2 1303740 6.6 2008 932041 4.7 3568300 17.9 2827722 14.2 1288536 6.5 2009 999338 4.9 3742891 18.5 2428848 12.0 1271073 6.3 2010 991421 5.3 3804990 20.4 2484252 13.3 1331802 7.2 2011 1003024 4.8 3932886 18.9 2680755 12.9 1393687 6.7 2012 1123036 6.4 3836716 21.9 2674337 15.3 1361473 7.8 2013 1031254 6.1 4179267 24.6 2693155 15.9 1320027 7.8 2014 1069549 6.8 4276223 27.2 2720333 17.3 1306988 8.3 Conservation Fiscal and Capital Debt Total Year Development Outlays Service Expenditures 2005 2462302 18.1 2003905 14.8 2079481 15.3 13583487 2006 1361693 6.1 8956734 40.3 2458113 11.1 22233664 2007 1485639 7.5 4006478 20.2 3439601 17.3 19833784 2008 5165763 26.0 2465738 12.4 3642475 18.3 19890575 2009 409349 2.0 6818501 33.6 4594420 22.7 20264420 2010 501198 2.7 4776479 25.7 4722113 25.4 18612255 2011 701976 3.4 854960 4.1 10200664 49.1 20767952 2012 506971 2.9 1071184 6.1 6958289 39.7 17532006 2013 291538 1.7 3747885 22.1 3696709 21.8 16959835 2014 374598 2.4 2161164 13.7 3828856 24.3 15737711 Source Village of Grafton Annual Financial Reports VILLAGE OF GRAFTON WISCONSIN GENERAL GOVERNMENTAL EXPENDITURES BY FUNCTION LAST TEN FISCAL YEARS 132 Table 6 Fiscal Inter- Licenses Fines Forfeitures Public Charges Year Taxes Governmental and Permits and Penalties for Services 2005 6550849 66.1 1528927 15.4 346166 3.5 123888 1.3 436988 4.4 2006 6885401 59.9 1586761 13.8 378364 3.3 126065 1.1 662589 5.8 2007 7329910 62.0 1602176 13.5 537137 4.5 126490 1.1 455702 3.9 2008 7811887 50.6 1994694 12.9 837933 5.4 132084 0.9 605924 3.9 2009 10374018 72.6 1850392 13.0 560550 3.9 128043 0.9 435799 3.1 2010 9116020 71.1 1817076 14.2 349367 2.7 128648 1.0 436416 3.4 2011 9255400 71.3 1849051 14.2 420851 3.2 108201 0.8 428847 3.3 2012 9498246 73.3 1738932 13.4 418053 3.2 123709 1.0 704078 5.4 2013 9683361 61.8 2068890 13.2 415286 2.7 107511 0.7 1029055 6.6 2014 9760244 64.5 2216493 14.6 581886 3.8 115783 0.8 1022269 6.8 Fiscal Inter-Governmental Special Investment Miscellaneous Total Year Charges for Services Assessments Income Revenues Revenues 2005 186852 1.9 114332 1.2 400206 4.0 216438 2.2 9904646 2006 43076 0.4 216164 1.9 1168128 10.2 431482 3.8 11498030 2007 52214 0.4 34303 0.3 1015814 8.6 673517 5.7 11827263 2008 53412 0.3 125988 0.8 579175 3.8 3300103 21.4 15441200 2009 52388 0.4 114175 0.8 206894 1.4 562525 3.9 14284784 2010 53513 0.4 151664 1.2 153383 1.2 618819 4.8 12824906 2011 70851 0.5 145251 1.1 156055 1.2 543734 4.2 12978241 2012 114883 0.9 37236 0.3 116625 0.9 212660 1.6 12964422 2013 250341 1.6 1394717 8.9 31310 0.2 678460 4.3 15658931 2014 373238 2.5 161517 1.1 41249 0.3 864917 5.7 15137596 Source Village of Grafton Annual Financial Reports VILLAGE OF GRAFTON WISCONSIN GENERAL GOVERNMENTAL REVENUES BY SOURCE LAST TEN FISCAL YEARS 133 Table 7 Levy Collection State of Ozaukee Village of Grafton Cedarburg Year Year Wisconsin County Grafton Schools Schools 2005 2006 186468 1715926 6046590 7996329 1132754 2006 2007 190015 1760675 6259191 8491999 1145638 2007 2008 190277 1723895 6451304 9021156 1185346 2008 2009 203830 1819182 6689113 9016171 1264674 2009 2010 205575 1872661 6849282 10215840 1347715 2010 2011 198841 1878211 6941344 10186049 1360195 2011 2012 202699 1947112 7128335 10196550 1237426 2012 2013 189803 1912175 7378783 10140502 1161989 2013 2014 185903 1970586 7443000 10800627 1197869 2014 2015 194898 1990499 7499567 10749940 1210796 Tax Levy Collection Incremental Total Percent Year Year MATC Districts Gross Tax Levy Collections Collected 2005 2006 1817212 555518 19450797 19447680 99.98 2006 2007 1844288 756344 20448150 20438056 99.95 2007 2008 1894692 991231 21457901 21455087 99.99 2008 2009 2047377 1597508 22637855 22632584 99.98 2009 2010 2130200 1946065 24567338 24564864 99.99 2010 2011 2068717 1952126 24585483 24579083 99.97 2011 2012 2140920 1949643 24802685 24796237 99.97 2012 2013 2192240 1852879 24828371 24825728 99.99 2013 2014 2161298 1861907 25621190 25618384 99.99 2014 2015 1347466 1899548 24892714 Collections to date are in process Source Statement of taxes and Tax District Treasurers Settlements VILLAGE OF GRAFTON WISCONSIN COMPARATIVE TAX LEVIES FOR ALL DIRECT LAST TEN FISCAL YEARS AND OVERLAPPING GOVERNMENTS AND TOTAL COLLECTIONS 134 Table 8 Taxes Levied Subsequent Levy for the Years Year Fiscal Year Amount of Levy Collections Amount of Levy 2005 6046590 3422591 56.60 2623999 6046590 100.00 2006 6259191 3549412 56.71 2709779 6259191 100.00 2007 6451304 3115486 48.29 3335818 6451304 100.00 2008 6689113 3095297 46.27 3593129 6688426 99.99 2009 6849282 3824303 55.84 3024121 6848424 99.99 2010 6941344 3602806 51.90 3334439 6937245 99.94 2011 7128335 3916860 54.95 3205028 7121888 99.91 2012 7378783 4051826 54.91 3324314 7376140 99.96 2013 7443000 4266797 57.33 3176203 7442001 99.99 2014 7499567 4300533 57.34 Collections to date or in process Source Statement of Taxes and Tax District Treasurers Settlements VILLAGE OF GRAFTON WISCONSIN PROPERTY TAX LEVIES AND COLLECTIONS LAST TEN FISCAL YEARS Collected within the Fiscal Year of the Levy Total Collections to Date 135 Table 9 VILLAGE OF GRAFTON WISCONSIN PROPERTY VALUATIONS ASSESSED VALUATIONS Agricultural Year Residential Commercial Manufacturing Swamp Forest 2005 640209100 178151000 56317900 719100 2006 788428500 207142900 62778600 790300 2007 803383400 225505800 50867900 510400 2008 804214300 268867500 51184400 775300 2009 827619300 268418900 43445100 1177600 2010 795444700 302841000 42519900 1404700 2011 833475600 294333400 42637900 987000 2012 836284800 288739600 44854200 988800 2013 837346700 291530400 46906600 988800 2014 773122300 293306300 46898000 1158700 Total Personal Total Year Other Real Estate Property Assessed 2005 132300 1059272600 15954800 1075227400 2006 175000 1080442500 18842100 1099284600 2007 175000 1125216500 19561800 1144778300 2008 303800 1140964700 22644100 1163608800 2009 175000 1142385300 26461600 1168846900 2010 168600 1171602500 28846200 1200448700 2011 126100 1170993500 29842200 1200835700 2012 126100 1170993500 27458800 1198452300 2013 126100 1176898600 29173400 1206072000 2014 112500 1114597800 28530100 1143127900 Source Statistical Report of Property Valuations Published by Bureau of Property Tax Wisconsin Department of Revenue LAST TEN FISCAL YEARS 136 Table 10 REAL PROPERTY PERSONAL PROPERTY Levy Fiscal Assessed Equalized Assessed Equalized Year Year Value Value Value Value 2005 2006 875529400 976310800 15954800 17759600 2006 2007 1059315308 1063150700 18842100 18869200 2007 2008 1080442500 1100767800 19561800 20448300 2008 2009 1125345300 1177385800 22644100 23691300 2009 2010 1140835900 1183809800 26461600 27549900 2010 2011 1142378900 1142819500 28846200 28857300 2011 2012 1171560000 1164576600 29842200 29834400 2012 2013 1170993500 1092794500 27458800 25629000 2013 2014 1176898600 1069370600 29173400 26073800 2014 2015 1114597800 1119971400 28530100 28473600 TOTAL Ratio of Computer Levy Fiscal Assessed Equalized Assessed to Exemption Year Year Value Value Equalized Value Equalized Value 2005 2006 1078157408 1082019900 0.8968 4753200 2006 2007 1100004300 1121216100 0.9964 5998400 2007 2008 1147989400 1201077100 0.9811 5614400 2008 2009 1167297500 1211359700 0.9558 9353300 2009 2010 1171225100 1171676800 0.9636 10825500 2010 2011 1171225100 1171676800 0.9996 11063800 2011 2012 1198452300 1118423500 1.0059 15998400 2012 2013 1198452300 1118423500 1.0713 13319700 2013 2014 1206072000 1095444400 1.1010 6232400 2014 2015 1143127900 1148445000 0.9951 6232400 Effective January 1 1999 business computers are exempt from property taxes. Source Statistical Report of Property Valuations Published by Bureau of Property Tax Wisconsin Department of Revenue VILLAGE OF GRAFTON WISCONSIN ASSESSED AND EQUALIZED VALUE OF TAXABLE PROPERTY LAST TEN FISCAL YEARS 137 Table 11 Levy Collection State of Ozaukee Village Grafton Year Year Wisconsin County of Grafton Schools 2005 2006 0.2092 1.9819 6.9839 10.5586 2006 2007 0.1762 1.6962 6.0298 9.3501 2007 2008 0.1730 1.6434 6.1501 9.8234 2008 2009 0.1776 1.7061 6.2734 9.6366 2009 2010 0.1761 1.7431 6.3754 10.8310 2010 2011 0.1698 1.7429 6.4413 10.7546 2011 2012 0.1687 1.7595 6.4414 10.4436 2012 2013 0.1584 1.7242 6.6535 10.3609 2013 2014 0.1541 1.7617 6.6541 10.9274 2014 2015 0.1705 1.8852 7.1028 11.5027 Levy Collection State of Ozaukee Village Cedarburg Year Year Wisconsin County of Grafton Schools 2005 2006 0.2092 1.9819 6.9839 10.4439 2006 2007 0.1762 1.6962 6.0298 8.8256 2007 2008 0.1730 1.6434 6.1501 9.0736 2008 2009 0.1776 1.7061 6.2734 9.6796 2009 2010 0.1761 1.7431 6.3754 10.2781 2010 2011 0.1698 1.7429 6.4413 10.4225 2011 2012 0.1687 1.7595 6.4414 9.4974 2012 2013 0.1584 1.7242 6.6535 8.9191 2013 2014 0.1541 1.7617 6.6541 9.2032 2014 2015 0.1705 1.8852 7.1028 9.9815 Source Tax Levy from Direct and Overlapping Governments Tax Increment Calculation Worksheet and Tax Rate Calculations certified to tax roll COMPARATIVE TAX RATES FOR ALL DIRECT AND OVERLAPPING GOVERNMENTS PER 1000 OF ASSESSED VALUE LAST TEN FISCAL YEARS PROPERTIES WITHIN THE CEDARBURG SCHOOL DISTRICT COMPA VILLAGE OF GRAFTON WISCONSIN COMPARATIVE TAX RATES FOR ALL DIRECT AND OVERLAPPING GOVERNMENTS PER 1000 OF ASSESSED VALUE LAST TEN FISCAL YEARS PROPERTIES WITHIN THE GRAFTON SCHOOL DISTRICT COMPA 138 Table 11 PER 1000 OF ASSESSED VALUE LAST TEN FISCAL YEARS PROPERTIES WITHIN THE GRAFTON SCHOOL DISTRICT School State Net Tax Assessed MATC Total Credit Rate Valuation 2.0989 21.8325 1.4752 20.3573 783023100 1.7767 19.0290 1.4786 17.5504 948348400 1.8062 19.5961 1.5809 18.0152 969367000 1.9201 19.7138 1.6423 18.0715 1017388200 1.9828 21.1084 1.5851 19.5234 1036173100 1.9197 21.0283 1.5832 19.4451 1040720000 1.9346 20.7478 1.5337 19.2141 1071086100 1.9768 20.8738 1.5486 19.3252 1068171100 1.9322 21.4295 1.5143 19.9152 1075914600 1.2762 21.9374 1.6188 20.3186 1021824000 School State Net Tax Assessed MATC Total Credit Rate Valuation 2.0989 21.7178 1.4752 20.2426 108461100 1.7767 18.5045 1.4786 17.0259 129809000 1.8062 18.8463 1.5809 17.2654 130637300 1.9201 19.7568 1.6423 18.1145 130654100 1.9828 20.5556 1.5851 18.9705 131124400 1.9197 20.6962 1.5832 19.1130 130505100 1.9346 19.8016 1.5337 18.2679 130291600 1.9768 19.4320 1.5486 17.8834 130281200 1.9322 19.7053 1.5413 18.1640 130157400 1.2762 20.4162 1.6188 18.7974 121303900 COMPARATIVE TAX RATES FOR ALL DIRECT AND OVERLAPPING GOVERNMENTS PER 1000 OF ASSESSED VALUE LAST TEN FISCAL YEARS PROPERTIES WITHIN THE CEDARBURG SCHOOL DISTRICT VILLAGE OF GRAFTON WISCONSIN COMPARATIVE TAX RATES FOR ALL DIRECT AND OVERLAPPING GOVERNMENTS 139 Table 12 Levy Collection State of Ozaukee Village Grafton Year Year Wisconsin County of Grafton Schools 2005 2006 0.1876 1.7774 6.2632 9.4689 2006 2007 0.1756 1.6901 6.0083 9.3167 2007 2008 0.1697 1.6124 6.0338 9.6376 2008 2009 0.1697 1.6308 5.9964 9.2111 2009 2010 0.1697 1.6797 6.1435 10.4370 2010 2011 0.1697 1.7422 6.4388 10.7505 2011 2012 0.1697 1.7698 6.4790 10.5044 2012 2013 0.1697 1.8472 7.1281 11.1000 2013 2014 0.1697 1.9396 7.3261 12.0311 2014 2015 0.1697 1.8765 7.0700 11.4490 Levy Collection State of Ozaukee Village Cedarburg Year Year Wisconsin County of Grafton Schools 2005 2006 0.1876 1.7774 6.2632 9.3660 2006 2007 0.1756 1.6901 6.0083 8.7941 2007 2008 0.1697 1.6124 6.0338 8.9019 2008 2009 0.1697 1.6308 5.9964 9.2521 2009 2010 0.1697 1.6797 6.1435 9.9043 2010 2011 0.1697 1.7422 6.4388 10.4185 2011 2012 0.1697 1.7698 6.4790 9.5531 2012 2013 0.1697 1.8472 7.1281 9.5553 2013 2014 0.1697 1.9396 7.3261 10.1313 2014 2015 0.1697 1.8765 7.0700 9.9380 Source Tax Levy from Direct and Overlapping Governments Tax Increment Calculation Worksheet and Tax Rate Calculations certified to tax roll COMPARATIVE TAX RATES FOR ALL DIRECT AND OVERLAPPING GOVERNMENTS PER 1000 OF EQUALIZED VALUE LAST TEN FISCAL YEARS PROPERTIES WITHIN THE CEDARBURG SCHOOL DISTRICT VILLAGE OF GRAFTON WISCONSIN COMPARATIVE TAX RATES FOR ALL DIRECT AND OVERLAPPING GOVERNMENTS PER 1000 OF EQUALIZED VALUE LAST TEN FISCAL YEARS PROPERTIES WITHIN THE GRAFTON SCHOOL DISTRICT 140 Table 12 School State Net Tax Equalized MATC Total Credit Rate Valuation 1.8823 19.5794 1.3229 18.2565 815833523 1.7704 18.9611 1.4734 17.4877 951745783 1.7721 19.2256 1.5510 17.6746 988059669 1.8353 18.8433 1.5699 17.2734 1064387255 1.9107 20.3407 1.5274 18.8132 1075285660 1.9189 21.0201 1.5826 19.4375 1041121268 1.9459 20.8688 1.5426 19.3262 1064880115 2.1178 22.3628 1.6591 20.7037 997053500 2.1274 23.5939 1.6672 21.9267 977210254 1.2700 21.8352 1.6110 20.2242 1026615514 School State Net Tax Equalized MATC Total Credit Rate Valuation 1.8823 19.4765 1.3229 18.1536 120942677 1.7704 18.4385 1.4734 16.9651 130274117 1.7721 18.4899 1.5510 16.9389 133156431 1.8353 18.8843 1.5699 17.3144 136689845 1.9107 19.8079 1.5274 18.2805 136074040 1.9189 20.6881 1.5826 19.1055 130555432 1.9459 19.9175 1.5426 18.3749 129530885 2.1178 20.8181 1.6591 19.1590 121607200 2.1274 21.6941 1.6672 20.0269 118234146 1.2700 20.3242 1.6113 18.7129 121829486 COMPARATIVE TAX RATES FOR ALL DIRECT AND OVERLAPPING GOVERNMENTS PER 1000 OF EQUALIZED VALUE LAST TEN FISCAL YEARS PROPERTIES WITHIN THE CEDARBURG SCHOOL DISTRICT VILLAGE OF GRAFTON WISCONSIN COMPARATIVE TAX RATES FOR ALL DIRECT AND OVERLAPPING GOVERNMENTS PER 1000 OF EQUALIZED VALUE LAST TEN FISCAL YEARS PROPERTIES WITHIN THE GRAFTON SCHOOL DISTRICT 141 Table 13 Statutory Debt Total G.O. Less Funds Capacity 5 As of Debt Available for Net Debt Equalized of Equalized December 31 Outstanding Debt Service Outstanding Value Value 2005 27340421 397080 26943341 994070400 49703520 2006 37051300 1168198 35883102 1082019900 54100995 2007 39142612 755543 38387069 1121216100 56060805 2008 42930903 451144 42479759 1201077100 60053855 2009 44429599 274202 44155397 1211359700 60567985 2010 42125011 179045 41945966 1171676800 58583840 2011 40242735 311598 39931137 1253337400 62666870 2012 38147460 129424 38018036 1118660700 55933035 2013 40697293 216797 40480496 1095444400 54772220 2014 37815841 177646 37638195 1148445000 57422250 Net Debt Ratio of Net Net Debt Per 1000 As of Debt to Debt Per of Equalized December 31 Capacity Population Capita Value 2005 54.21 11310 2382 27.10 2006 66.33 11380 3153 33.16 2007 68.47 11420 3361 34.24 2008 70.74 11450 3710 35.37 2009 72.90 11470 3850 36.45 2010 71.60 11480 3654 35.80 2011 63.72 11465 3483 31.86 2012 67.97 11464 3316 33.99 2013 73.91 11467 3530 36.95 2014 65.55 11467 3282 32.77 Source Village of Grafton Annual Financial Reports State of Wisconsin Department of Administration Demographic Services Center and State of Wisconsin Department of Revenue Bureau of Property Tax. Note Equalized value is used instead of assessed value due to the fact that the statutory debt capacity in Wisconsin is based on equalized value. Note Personal income information is not available. VILLAGE OF GRAFTON WISCONSIN RATIO OF NET GENERAL OBLIGATION DEBT TO EQUALIZED VALUE LAST TEN FISCAL YEARS 142 Table 14 Business-Type Activities Total Fiscal General Revenue General Business-Type Year Obligation Debt Bonds Obligation Debt Activities 2005 24559058 - 2781363 2781363 2006 34925895 - 2125405 2125405 2007 37310030 1550000 1832582 3382582 2008 40284134 1550000 2646769 4196769 2009 43594848 1495000 2329752 3824752 2010 40127169 1435000 1997842 3432842 2011 37940671 1370000 2302064 3672064 2012 36158184 1305000 1989276 3294276 2013 36714603 1235000 3982680 5217680 2014 34138056 1160000 3677785 4837785 Total Total Net Debt Fiscal General Revenue Per Year Obligation Debt Bond Debt Total Population Capita 2005 27340421 - 27340421 11310 2417 2006 37051300 - 37051300 11380 3256 2007 39142612 1550000 40692612 11420 3428 2008 42930903 1550000 44480903 11450 3749 2009 44429600 1495000 45924600 11470 3874 2010 42125011 1435000 43560011 11480 3669 2011 40242735 1370000 41612735 11465 3510 2012 38147460 1305000 39452460 11464 3328 2013 40697293 1235000 41932293 11467 3549 2014 37815841 1160000 38975841 11467 3298 Source Village of Grafton Annual Financial Reports State of Wisconsin Department of Administration Demographic Services Center and State of Wisconsin Department of Revenue Bureau of Property Tax. Governmental Activities VILLAGE OF GRAFTON WISCONSIN RATIO OF OUTSTANDING DEBT BY TYPE LAST TEN FISCAL YEARS 143 Table 15 Net General Percentage Amount Net General Percentage Amount End of Obligation Debt Applicable to Applicable to Obligation Debt Applicable to Applicable to Fiscal Year Outstanding Government Government Outstanding Government Government 2014 37815841 100.00 37815841 33910000 10.19 3455429 2013 40697293 100.00 40697293 20369530 10.09 2055286 2012 38147460 100.00 38147460 19820458 10.81 2142592 2011 40242735 100.00 40242735 21220000 10.45 2217490 2010 42125011 100.00 42125011 17635000 10.15 1789953 2009 44429599 100.00 44429599 17509129 10.12 1771924 2008 42930903 100.00 42930903 19761586 9.95 1966278 2007 39142612 100.00 39142612 8538833 9.60 819728 2006 37051300 100.00 37051300 9697000 9.95 964852 2005 28730930 100.00 28730930 6187000 9.95 615607 Net General Percentage Amount Net General Percentage Amount End of Obligation Debt Applicable to Applicable to Obligation Debt Applicable to Applicable to Fiscal Year Outstanding Government Government Outstanding Government Government 2014 14040000 63.37 8897148 13505000 5.64 761682 2013 15085000 62.52 9431142 15210000 5.64 857844 2012 14310000 65.03 9305793 17010000 5.82 989982 2011 11385000 63.35 7212398 17250000 6.11 1053975 2010 12300000 62.79 7723170 19755000 6.21 1226786 2009 13220000 63.57 8403954 22165000 6.14 1360931 2008 18620000 61.71 11490402 22165000 6.08 1347632 2007 20075000 62.10 12466575 26707000 5.94 1586396 2006 14745000 62.25 9178763 28887000 6.05 1747664 2005 15630000 62.77 9810951 30962000 6.08 1882490 Net General Percentage Amount Net General Percentage Amount End of Obligation Debt Applicable to Applicable to Obligation Debt Applicable to Applicable to Fiscal Year Outstanding Government Government Outstanding Government Government 2014 133620000 1.54 2057748 232890841 22.75 52987848 2013 137170000 1.51 2071267 228531823 24.12 55112832 2012 100835000 1.53 1542776 190122918 27.42 52128602 2011 98340000 1.45 1425930 187627918 27.72 52011757 2010 128075000 1.43 1831473 218172735 24.09 52558070 2009 94630000 1.40 1324820 186445011 29.06 54189739 2008 101815000 1.36 1384684 199138728 28.80 57351092 2007 74850000 1.39 1040415 178327489 32.96 58775630 2006 78405000 1.39 1089830 172868445 31.88 55105141 2005 75165000 1.43 1074860 165545300 30.21 50017439 Total Overlapping DebtOverlapping Milwaukee Area Technical College VILLAGE OF GRAFTON WISCONSIN COMPUTATION OF OVERLAPPING DEBT LAST TEN FISCAL YEARS Overlapping Ozaukee CountyDirect Village of Grafton Overlapping Grafton School District Overlapping Cedarburg School District 144 Table 16 Net Revenue Fiscal Gross Operating Available for Year Revenues 1 Expenses 2 Debt Service Principal Interest Total Coverage 2014 3876382 2145577 1730805 75000 47471 122471 14.13 2013 3753462 1903987 1849475 70000 53971 123971 14.92 2012 3703764 1873431 1830333 65000 57221 122221 14.98 2011 3791410 1839773 1951637 65000 60471 125471 15.55 2010 3616399 1875412 1740987 60000 63471 123471 14.10 2009 3265933 1883535 1382398 55000 66221 121221 11.40 2008 3301014 1906675 1394339 - 99332 99332 14.04 Notes 1 Total operating revenues plus interest on investments 2 Total operating expenses less depreciation 3 Includes interest and principal on revenue bonds issued for water and sewer main replacement Does not include general obligation debt Debt Service Requirements 3 VILLAGE OF GRAFTON WISCONSIN REVENUE BOND COVERAGE WATER AND WASTEWATER UTILITY 145 Table 17 Labor Average Average Year Force Employed Unemployed 2005 47761 46019 1742 2006 48212 46467 1745 2007 48667 47050 1617 2008 48407 46117 2290 2009 47334 43817 3517 2010 46700 43703 2997 2011 46863 44426 2437 2012 46917 44249 2668 2013 46858 44726 2132 2014 47712 46028 1684 Source Wisconsin Department of Workforce Development Source Wisconsin Department of Workforce Development VILLAGE OF GRAFTON WISCONSIN DEMOGRAPHIC INFORMATION Employment Information Ozaukee County 0.0 1.0 2.0 3.0 4.0 5.0 6.0 7.0 8.0 9.0 10.0 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 3.83.6 3.3 4.7 7.4 5.4 5.2 5.7 4.5 3.5 4.9 4.7 4.6 5.8 8.3 8.3 7.5 6.9 6.3 5.2 P e r c e n t Year Unemployment Rates County Unemployment Rate State Unemployment Rate 146 Table 18 Percent of Equalized Net Taxes Total Taxes Name of Taxpayer Nature of Business Value Paid Levied Inland Amercian Grafton Port Washington LLC Retail 16182200 328576 1.32 Costco Retail 13579700 275846 1.11 Retail 10951600 222447 0.89 Tillmann Corporation Residential Developer 9809100 199425 0.80 AMC Holdings LLC Retail 9125200 185337 0.74 Apartment Buildings 8761800 177730 0.71 Home Depot Retail 8370100 169994 0.68 Arrowhead Associates LLC Apartment Buildings 7980700 161933 0.65 Dayton Hudson Corp Target Retail 7946600 161389 0.65 Meijer Stores Limited Partnership Retail 7445000 151272 0.61 Total for Ten Largest Taxpayers 83969800 1705373 6.85 Percent of Equalized Net Taxes Total Taxes Name of Taxpayer Nature of Business Value Paid Levied Cary Rentals Apartment Building Owner 12859000 234669 1.29 Tillmann Corporation Residential Developer 9656600 176274 0.97 Arrowhead Apartments LLC Apartment Building Owner 9337700 170467 0.94 Home Depot U.S.A. Inc. Retail 9076110 165698 0.91 Arrowhead Association LLC Apartment Building Owner 8485300 154910 0.85 Oak Street Manchester Plaza Commercial Property Owner 8436700 154025 0.85 Dayton Hudson Target Retail 7548690 137812 0.76 Leeson Electric Mfg. Electric Motors 5885700 107452 0.59 Leggett Partners LP Mfg. Aluminum Die Casts 5730160 104610 0.58 Tecumseh Products Co Mfg. Internal Combustion Engines 5085400 92841 0.51 Total for Ten Largest Taxpayers 82101360 1498758 8.25 TEN LARGEST TAXPAYERS - 2005 VILLAGE OF GRAFTON WISCONSIN Arrowhead Apartments LLC Grafton LLC TEN LARGEST TAXPAYERS - 2014 PRINCIPAL TAXPAYERS CURRENT YEAR AND NINE YEARS AGO 147 Table 19 VILLAGE OF GRAFTON WISCONSIN PRINCIPAL EMPLOYERS CURRENT YEAR AND NINE YEARS AGO TEN LARGEST EMPLOYERS - 2014 Approximate Number of Name of Employer Nature of Business Employees Aurora Medical Center Medical Facility 1067 Pace Industries Mfg. - Aluminum Die Castings 500 Grafton School District Education 338 Kapco Mfg. - Stamping 300 Rexnord Corporation - Plastics Div. Mfg. - Plastic Injection Molding 258 Calibre Mfg - Springs 250 Costco Retail 175 Target Retail 170 Sendiks Grocer 155 Kohls Retail 150 TEN LARGEST EMPLOYERS - 2005 Approximate Number of Name of Employer Nature of Business Employees EST Company Leggett Platt Mfg. - Aluminum Die Castings 798 Grafton School District Education 320 Rexnord Corporation - Plastics Div. Mfg. - Plastic Injection Molding 240 Calibre Mfg. - Specialty Paint Design 165 Kapco Mfg. - Metal Stampings 165 Exacto Spring Corporation Mfg. - Springs 160 Target Retail 150 Home Depot Retail 141 Golds Pick n Save Grocer 140 Kohls Department Store Retail 135 Information regarding total employment for the Village is not available. The State of Wisconsin only reports by County and does not allow us to calculate the percentage of employees for the largest employers in the Village. 148 Table 20 DEMOGRAPHICS Area - Square Miles Population 5.12 2014 11490 5.12 2013 11467 5.11 2012 11464 5.11 2011 11465 5.11 2010 11459 5.11 2009 11470 5.04 2008 11450 4.47 2007 11420 4.47 2006 11380 Age 2010 Education Attainment 2010 Under 5 years 5.60 Population 25 years and over 5 to 19 years 19.30 Less than 9th grade 1.7 20 to 29 years 11.70 9th to 12 grade no diploma 2.4 30 to 39 years 12.40 High school graduate includes equivalency 26.4 40 to 49 years 15.00 Some college no degree 22.5 50 to 59 years 15.10 Associates degree 11.9 60 to 69 years 10.60 Bachelors degree 25.8 70 to 79 years 6.20 Graduate or professional degree 9.3 80 years and over 4.20 Race 2010 Housing Units 2010 White 95.50 Total Dwelling Units 5232 Asian 1.80 Single Family 53.0 Two or More Races 1.00 Duplex 10.1 Black or African American 0.80 Multi-Family Apartments 23.9 Some Other Race 0.60 Multi-Family Condominiums 13.0 American Indian and Alaska Native 0.30 Including Hispanic 2.30 Major Employers 2015 Equalized Value of Largest Property Taxpayers 2014 Aurora Medical Center 1067 Inland Amercian Grafton Port Washington LLC 16182200 Pace Industries 500 Costco 13579700 Grafton School District 338 10951600 Kapco 300 Tillmann Corporation 9809100 Rexnord Corporation - Plastics Div. 258 AMC Holdings LLC 9125200 Calibre 250 8761800 Costco 175 Home Depot 8370100 Target 170 Arrowhead Associates LLC 7980700 Sendiks 155 Dayton Hudson Corp Target 7946600 Kohls 150 Meijer Stores Limited Partnership 7445000 Source U.S. Census Village of Grafton Note Personal income data not available. Grafton LLC 2013 2012 2007 2011 2010 Arrowhead Apartments LLC 2014 2006 2009 2008 149 Table 20 DEMOGRAPHICS Building Permits Occupational Composition 2010 Number Value millions Managerial and Professional 48.30 932 32.6 Technical Sales and Administrative 18.90 880 19.2 Production and Transportation 10.50 836 11.6 Service Occupations 7.70 767 28.1 801 14.1 747 227.7 1024 53.8 1016 45.0 937 20.1 730 16.5 Employment Trends Ozaukee County Water Wastewater Employment Unemployment Active Accounts Serviced 4899 Rate Water Treated and Distributed 3.90 millions of gallons 364 44726 4.5 Sanitary Sewers miles 54.66 44249 5.7 Water Main miles 69.78 2011 44425 5.2 2010 43703 5.4 Elections 2015 2009 43817 7.4 Registered Voters Turn-out Percent 2008 46117 4.7 2007 47050 3.3 Spring General 7901 1874 23.7 2006 46467 3.5 Parks Infrastructure Developed Parks Acres Maintained Miles of State Highway System 2.54 17 120 Miles of County Highway System 3.28 17 120 Miles of Local Roads and Streets 53.02 17 120 Miles of Sidewalks 82.64 17 120 Number of Street Lights 1659 17 120 17 120 School Registration 2013-2014 17 120 Elementary Schools Grades K-5 947 17 120 John Long Middle School Grades 6-8 489 17 120 Grafton High School Grades 9-12 746 Public Safety Number of Sworn Police Officers Number of Police Stations 1 2014 22 Number of Fire Stations 1 2013 22 ISO Rating 3 2012 22 2011 22 2010 22 2009 22 2008 22 2007 21 2006 21 Source Wisconsin Department of Revenue Wisconsin Department of Administration Village of Grafton Annual Financial Reports and Village of Grafton Comprehensive Master Plan 2012 2013 2014 2014 Year 2008 2007 2006 2006 2010 2009 2008 2007 2013 2012 2012 2011 2014 2013 2011 2005 2010 2009 150 THIS PAGE LEFT BLANK INTENTIONALLY 151 Table 21 VILLAGE OF GRAFTON WISCONSIN OPERATING INDICATORS BY FUNCTION LAST TEN FISCAL YEARS FUNCTION 2005 2006 2007 Police Citations Issued 3471 4148 3155 Calls for Service 22364 26937 30829 Inspection Total Permits Issued 1024 1059 1149 Public Works Asphalt Placed by Village Staff 218 351 339 Tons of Salt Used 1382 578 1867 Communtity Activities Average Daily Attendance at Senior Center 56 58 60 Family Aquatic Center Total Attendance 27702 25391 25213 Recreation Program Participants 2322 2470 2451 Library Annual Circulation 192293 196380 205599 Water and Wastewater Water and Wastewater Bills Processed 18294 18343 18795 152 Table 21 VILLAGE OF GRAFTON WISCONSIN OPERATING INDICATORS BY FUNCTION LAST TEN FISCAL YEARS 2008 2009 2010 2011 2012 2013 2014 2922 3807 4005 4015 3908 3596 3415 29613 31533 31509 26705 21158 21726 21208 1179 739 924 880 836 880 929 644 517 245 406 339 353 451 1945 1386 983 1155 1059 2127 1827 55 57 53 57 59 56 57 29885 25117 30157 22836 28127 19069 17759 2148 2050 2127 2215 2390 1983 2569 223593 247746 254486 246278 234253 215767 215767 18910 19025 18900 18948 19630 19846 19846 153 Table 22PERSONNEL SCHEDULE AUTHORIZED PERMANENT POSITIONS 2005-2014 GENERAL FUND General Government 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 Office of the Village Administrator Administrator 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Administrative Assistant I 0.67 0.67 0.67 0.67 0.67 0.75 0.75 0.75 0.75 0.75 Total Village Administrators Office 1.67 1.67 1.67 1.67 1.67 1.75 1.75 1.75 1.75 1.75 Department of Administrative Services Finance Director 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Accountant 0.00 0.00 0.00 0.50 0.50 0.50 0.50 0.63 0.63 0.63 Administrative Assistant I 0.33 0.33 0.33 0.33 0.33 0.25 0.25 0.25 0.25 0.25 Accounting Clerk II 0.50 0.50 0.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Administrative Secretary 0.00 0.00 0.00 0.25 0.25 0.25 0.25 0.25 0.25 0.25 Deputy Clerk 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 Utility Clerk 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 1.00 1.00 Office Assistant 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.50 0.35 0.35 Office of the Village Clerk Village Clerk 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Deputy Village Clerk 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 Total Dept. of Administrative Services 3.83 3.83 3.83 4.08 4.08 4.00 4.00 5.63 5.48 5.48 Assessing Division Assessment Clerk 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 Office Assistant 0.25 0.25 0.25 0.50 0.50 0.00 0.00 0.00 0.00 0.00 Total Assessing Division 0.75 0.75 0.75 1.00 1.00 0.50 0.50 0.50 0.50 0.50 Public Safety Police Department Administration Police Chief 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Captain 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 Administrative Assistant II 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Administrative Assistant I 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 Court ClerkTelecommunicator 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.00 Operations Sergeant 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 Sergeant-School Liaison 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Patrol Officer 13.00 13.00 14.00 14.00 14.00 14.00 14.00 14.00 14.00 14.00 Communications Telecommunicators 5.50 5.50 5.50 5.50 5.50 5.50 5.50 5.50 5.50 6.50 Court ClerkTelecommunicator 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.00 Total Police Department 28.50 28.50 28.50 28.50 28.50 29.50 29.50 29.50 29.50 30.50 Inspection Department Building Inspector 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Electrical Inspector 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 Assessment Clerk 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 Office Assistant 0.25 0.25 0.25 0.50 0.50 0.25 0.00 0.00 0.00 0.00 Total Inspection Department 2.00 2.00 2.00 2.25 2.25 2.00 1.75 1.75 1.75 1.75 154 Table 22PERSONNEL SCHEDULE AUTHORIZED PERMANENT POSITIONS 2005-2014 Public Works 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 Public Works Department AdministrationEngineering Director 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Superintendent 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Engineering Technician II 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Administrative Secretary 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Operations Foreman 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Crewperson 10.00 11.00 11.00 11.00 9.00 9.00 9.00 9.00 9.00 10.00 Total Public Works Department 15.00 16.00 16.00 16.00 14.00 14.00 14.00 14.00 14.00 15.00 Community Enrichment Services Parks and Recreation Department Director 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Administrative Secretary II 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Senior CoordinatorRecreation Supervisor 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Crewperson 0.00 0.00 0.00 0.00 2.00 2.00 2.00 2.00 2.00 1.00 Office Assistant 0.00 0.00 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 Senior Center Assistant 0.00 0.00 0.00 0.00 0.00 0.00 0.29 0.29 0.29 0.29 Total Parks and Recreation Department 3.00 3.00 3.46 3.46 5.46 5.46 5.75 5.75 5.75 4.75 Conservation and Development Planning and Development Department Director 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Planner I 0.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 Administrative Secretary II 1.00 0.00 0.00 0.50 0.50 0.50 0.50 0.50 0.50 0.50 Total Planning and Development Department 2.00 2.00 2.00 2.50 2.50 1.50 1.50 1.50 1.50 1.50 TOTAL GENERAL FUND 56.75 57.75 58.21 59.46 59.46 58.71 58.75 60.38 60.23 61.23 SPECIAL REVENUE FUND Library Director 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Head of Youth Services 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Head of Technical Services 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Reference Librarian 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.80 0.83 0.83 Library Assistant II 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 0.90 Library Assistant I 4.69 4.69 4.69 4.69 4.73 4.73 4.73 4.73 3.56 3.56 Library Page 0.28 0.28 0.27 0.27 0.32 0.32 0.32 0.32 0.30 0.30 ShelverCleaner 0.23 0.23 0.23 0.23 0.23 0.23 0.23 0.23 0.19 0.19 Total Library 9.20 9.20 9.19 9.19 9.28 9.28 9.28 9.08 8.88 8.78 Fire Protection and Rescue Fire Chief 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 1.00 Office Assistant 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.50 0.50 Total Fire Protection and Rescue 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.50 1.50 Cable Television Division Programming Coordinator 0.22 0.22 0.22 0.22 0.22 0.22 0.00 0.00 0.00 0.00 Total Cable Television Division 0.22 0.22 0.22 0.22 0.22 0.22 0.00 0.00 0.00 0.00 TOTAL SPECIAL REVENUE FUND 9.42 9.42 9.41 9.41 9.50 9.50 9.28 9.08 10.38 10.28 155 Table 22PERSONNEL SCHEDULE AUTHORIZED PERMANENT POSITIONS 2004-2013 ENTERPRISE FUND 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 Water and Wastewater Utility Administration Department of Public Works 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.25 0.25 0.25 Utility Director 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.60 0.60 0.00 Utility Superintendent 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Program Coordinator 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 1.00 Administrative Secretary II 0.00 0.00 0.00 0.25 0.25 0.25 0.25 0.00 0.00 0.00 Accounting Clerk II 0.50 0.50 0.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Utility Clerk I 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.25 0.25 0.25 Office Assistant 0.00 0.00 0.00 0.50 0.50 0.60 0.60 0.25 0.25 0.25 Operations Operations Foreman 0.00 1.00 1.00 0.00 1.00 1.00 1.00 1.00 0.00 0.00 Lead Field Operator 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 1.00 1.00 Lead Operator - WWTP 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Utility Operator 5.00 5.00 5.00 7.00 6.00 6.00 6.00 6.00 5.00 6.00 Total Water and Wastewater Utility 10.50 11.50 11.50 10.75 10.75 10.85 10.85 9.35 9.35 9.75 TOTAL ENTERPRISE FUND 10.50 11.50 11.50 10.75 10.75 10.85 10.85 9.35 9.35 9.75 TOTAL PERSONAL BY DEPARTMENT AUTHORIZED PERMANENT POSITIONS 2005-2014 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 Office of the Village Administrator 1.67 1.67 1.67 1.67 1.67 1.67 1.75 1.75 1.75 1.75 Department of Administrative Services 2.33 1.84 2.33 2.33 2.58 2.58 4.00 5.63 5.48 5.48 Office of the Village Clerk 1.50 1.50 1.50 1.50 1.50 1.50 4.00 5.63 5.48 5.48 Assessing Division 0.75 0.50 0.75 0.75 1.00 1.00 0.50 0.50 0.50 0.50 Police Department 28.50 28.50 28.50 29.50 29.50 29.50 29.50 29.50 29.50 30.50 Inspection Department 2.00 1.75 2.00 2.00 2.00 2.25 1.75 1.75 1.75 1.75 Public Works Department 15.00 15.00 16.00 16.00 16.00 16.00 14.00 14.00 14.00 15.00 Parks and Recreation Department 3.00 3.00 3.00 3.00 3.40 5.46 5.75 5.75 5.75 4.75 Planning and Development Department 2.00 2.00 2.00 2.00 2.50 2.50 1.50 1.50 1.50 1.50 Library 10.18 10.05 9.20 9.20 9.20 9.28 9.28 9.08 8.88 8.78 Fire Protection and Rescue Services 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.50 2.50 Cable Television Division 0.25 0.35 0.22 0.22 0.22 0.22 0.00 0.00 0.00 0.00 Water and Wastewater Utility 12.00 10.50 11.50 11.50 11.75 10.85 10.85 9.35 9.35 9.75 TOTAL VILLAGE PERSONNEL 79.18 76.66 78.67 79.67 81.32 82.81 82.88 84.43 85.44 87.74 156 THIS PAGE LEFT BLANK INTENTIONALLY 157 Table 23 VILLAGE OF GRAFTON WISCONSIN ENTERPRISE FUNDS UTILITY PLANT LAST TEN FISCAL YEARS Combined Water Wastewater Wat Gross Utility Accumulated Net Utility Year Plant Depreciation Plant 2005 33396330 9954037 23442293 2006 36786186 10669552 26116634 2007 40104733 11424304 28680429 2008 40260304 12057889 28205081 2009 43275851 12917219 30358632 2010 44429750 13392646 31037104 2011 45606666 14405134 31201532 2012 46702549 15391744 31310805 2013 49765078 16340204 33424874 2014 51559632 17281580 34278052 Utility plant includes construction in progress. Source Municipal Utility Annual Report of the Grafton Water Wastewater Utility to the Public Service Commission of Wisconsin 158 Table 23 VILLAGE OF GRAFTON WISCONSIN ENTERPRISE FUNDS UTILITY PLANT LAST TEN FISCAL YEARS Water Utility Wastewater Utility Gross Utility Accumulated Net Utility Gross Utility Accumulated Net Utility Year Plant Depreciation Plant Plant Depreciation Plant 2005 14092435 3173522 10918913 19303895 6780515 12523380 2006 15967690 3441021 12526669 20818496 7228531 13589965 2007 17396772 3720972 13675800 22707961 7703332 15004629 2008 17956790 3956117 14003339 22303514 8101772 14201742 2009 19176817 4240257 14936560 24099034 8676962 15422072 2010 19533210 4569702 14963508 24896540 8822944 16073596 2011 20028700 4966450 15062250 25577966 9438684 16139282 2012 20533610 5341450 15192160 26168939 10050294 16118645 2013 21730214 5659456 16070758 28034864 10680748 17354116 2014 22047281 6060120 15987161 29512351 11221460 18290891 159 Table 24 COMBINED WATER AND WASTEWATER UTILITY LAST TEN FISCAL YEARS Total Assets Other Current and Deferred and Deferred Net Utility Property and Accrued Deferred Outflows Outflows of Year Plant Investments Assets Debits of Resources Resources 2005 23442293 818772 4695478 6011 - 28962555 2006 26116634 939334 3391654 5457 - 30453080 2007 28680429 1134436 4186199 47181 - 34050245 2008 29474387 1212502 4260665 44449 - 34992003 2009 30718548 1301701 3589743 41605 - 35651597 2010 31037104 912624 3527795 38929 - 35516452 2011 31201532 1155384 4461746 36140 - 36854802 2012 31310805 1256322 4464660 33352 - 37065139 2013 33424874 1214941 5445036 - 100165 40135016 2014 34278052 662557 4498163 - 90231 39529003 Source Annual Financial Reports of the Village of Grafton and the Municipal Utility Annual Report of the Grafton Water Wastewater Utility to the Public Service Commission of Wisconsin VILLAGE OF GRAFTON WISCONSIN ENTERPRISE FUNDS BALANCE SHEET 160 Table 24 BALANCE SHEET COMBINED WATER AND WASTEWATER UTILITY LAST TEN FISCAL YEARS Current and Total Total Long Term Accrued Deferred Liabilities Net Year Debt Liabilities Credits and Credits Position 2005 2362319 755724 41079 3159122 25803433 2006 1832581 705986 270625 2809192 27643887 2007 2952798 723170 284969 3236767 29924608 2008 3824752 449183 217900 4491835 30500168 2009 3432841 628689 82112 4143642 31507955 2010 3100754 637286 20917 3758957 31757495 2011 3338509 648243 - 3986752 32868050 2012 3105602 604110 - 3709712 33355427 2013 4905455 1357792 - 6263247 33858506 2014 4480955 1017463 - 5498418 34030585 VILLAGE OF GRAFTON WISCONSIN ENTERPRISE FUNDS 161 Table 25 Income Before Operating Interest and Capital Operating Operating Income Other Amortization Contributions Year Revenues Expenses Loss Income Charges and Transfers 2005 2743564 2517275 226289 45004 76956 194337 2006 3033516 2633440 400076 87969 106298 381747 2007 3219542 2980788 238754 148017 135314 251457 2008 3138818 2782492 356326 163166 162756 356731 2009 3224479 2811600 412879 64973 174787 303065 2010 3568594 2881703 686891 57080 162675 581296 2011 3759783 2904647 855136 47873 143198 759811 2012 3684140 2974499 709641 39748 139437 609952 2013 3752742 3058370 694372 4720 200782 498310 2014 3862198 3378965 483233 17184 170601 329816 Source Annual Financial Reports of the Village of Grafton and the Municipal Utility Annual Report of the Grafton Water Wastewater Utility to the Public Service Commission of Wisconsin VILLAGE OF GRAFTON WISCONSIN ENTERPRISE FUNDS INCOME AND RETAINED EARNINGS STATEMENT COMBINED WATER AND WASTEWATER UTILITY LAST TEN FISCAL YEARS 162 Table 25 Capital Changes in Total Year Contributions Transfers Net Position Net Position 2005 75788 - 270125 25803433 2006 1461257 - 1831054 27634487 2007 2093393 64129.00 2280721 29924608 2008 279307 60213 575560 30500168 2009 981234 276512 1007787 31507955 2010 138357 470113 249540 31757495 2011 620947 270203 1110555 32868050 2012 147628 270203 487377 33355427 2013 274982 270213 503079 33858506 2014 112504 270241 172079 34030585 VILLAGE OF GRAFTON WISCONSIN ENTERPRISE FUNDS INCOME AND RETAINED EARNINGS STATEMENT COMBINED WATER AND WASTEWATER UTILITY LAST TEN FISCAL YEARS 163 Table 26 W Operating Operating Operating Income Year Revenues Expenses Loss 2005 2736717 2442268 294449 2006 3033516 2633440 400076 2007 3219542 2980788 238754 2008 3138818 2782492 356326 2009 3224479 2811600 412879 2010 3568594 2881703 686891 2011 3759783 2904647 855136 2012 3684140 2974499 709641 2013 3752742 3058370 694372 2014 3862198 3378965 483233 Source Annual Financial Reports of the Village of Grafton and the Combined Water Wastewater VILLAGE OF GRAFTON WISCONSIN ENTERPRISE FUNDS OPERATING REVENUES AND EXPENSES LAST TEN FISCAL YEARS 164 Table 26 Water Utility Wastewater Utility Operating Operating Operating Operating Income Operating Operating Income Year Revenues Expenses Loss Revenues Expenses Loss 2005 1314684 1068431 246253 1422033 1373837 48196 2006 1448817 1131371 317446 1584699 1502069 82630 2007 1573057 1378721 194336 1646485 1602067 44418 2008 1468698 1258350 210348 1670120 1524142 145978 2009 1513428 1201856 311572 1711051 1609744 101307 2010 1617355 1218300 399055 1951239 1663403 287836 2011 1667735 1146083 521652 2092048 1758564 333484 2012 1727198 1207668 519530 1956942 1766831 190111 2013 1663860 1272062 391798 2088882 1786308 302574 2014 1711885 1412943 298942 2150313 1966022 184291 VILLAGE OF GRAFTON WISCONSIN ENTERPRISE FUNDS OPERATING REVENUES AND EXPENSES LAST TEN FISCAL YEARS 165 Table 27 Residential Commercial Industrial Average Average Average Number of Gallons Number of Gallons Number of Gallons Year Customers Sold Revenue Customers Sold Revenue Customers Sold Revenue 2005 4217 251925 700629 228 67690 139390 69 55312 102374 2006 4254 239290 765286 229 66985 156336 69 52991 110290 2007 4283 239833 757802 237 69288 170591 68 48403 91410 2008 4324 224873 751721 253 77025 171744 67 39615 89810 2009 4352 234130 778993 263 70640 175042 66 30991 68298 2010 4364 221219 843582 271 52101 192864 65 49420 74683 2011 4378 243120 855625 275 87361 230475 65 27557 71400 2012 4380 240242 894529 280 92978 252153 66 29605 75096 2013 4393 214889 835839 289 101151 244835 66 23622 67370 2014 4501 199794 857115 305 88494 256301 68 27720 80027 000 Omitted Category includes multi-family classification Does not include unmetered bulk water sales Source Municipal Utility Annual Report of the Grafton Water Wastewater Utility to the Public Service Commission of Wisconsin VILLAGE OF GRAFTON WISCONSIN ENTERPRISE FUNDS WATER SALES LAST TEN FISCAL YEARS 166 Table 27 Public Authorities Average Private Fire Public Fire Total Total Revenue Number of Gallons Protection Protection Gallons From Sale Year Customers Sold Revenue Revenues Revenues Sold of Water 2005 25 6135 16658 27945 238961 381062 1225957 2006 26 5652 17395 28565 275642 364918 1353514 2007 28 6375 19228 30335 276440 363899 1345806 2008 27 5490 18161 35425 278795 347003 1345656 2009 24 9396 25385 34032 284036 346522 1373364 2010 25 5390 20558 34866 328367 328130 1494920 2011 23 4665 19999 36460 328488 362703 1542447 2012 24 5986 19180 37278 329681 368811 1607917 2013 24 5644 18510 37354 330468 345306 1534376 2014 25 5161 18064 37385 331807 321169 1580699 VILLAGE OF GRAFTON WISCONSIN ENTERPRISE FUNDS WATER SALES cont. LAST TEN FISCAL YEARS 167 Table 28 Residential Commercial Industrial Average Average Average Number of Gallons Number of Gallons Number of Gallons Year Customers Metered Revenue Customers Metered Revenue Customers Metered Revenue 2005 4040 208357 921893 219 64697 239286 63 25835 117867 2006 4080 205749 1030228 224 67076 274100 63 38715 126907 2007 4107 211625 1092271 223 63808 291709 63 28078 127012 2008 4147 220844 1110688 242 73154 269666 64 22229 143117 2009 4063 205869 1114150 242 65634 297949 59 22229 136576 2010 4094 208349 1296716 248 62947 350521 60 24313 154532 2011 4122 200673 1300347 249 66851 549657 59 19444 101079 2012 4128 185342 1234705 252 84931 467389 59 18225 107363 2013 4153 208523 1347900 256 96315 462547 59 13202 97802 2014 4141 195551 1369629 264 82787 481588 59 16759 123503 000 Omitted Source Municipal Utility Annual Report of the Grafton Water Wastewater Utility VILLAGE OF GRAFTON WISCONSIN ENTERPRISE FUNDS WASTEWATER REVENUES LAST TEN FISCAL YEARS 168 Table 28 Public Authorities Average Other Total Total Number of Gallons Sewerage Gallons Sewerage Year Customers Metered Revenue Revenues Metered Revenues 2005 20 4791 19507 123480 303680 1422033 2006 21 5447 21806 98434 316987 1551475 2007 21 5229 26013 92954 308740 1629959 2008 22 3977 20503 94171 320204 1638145 2009 17 6467 20715 82540 300199 1651930 2010 17 3218 23924 88358 298827 1914051 2011 17 3071 24131 82632 290039 2057846 2012 18 4135 25015 85910 292633 1920382 2013 19 4156 25671 98872 322196 2032792 2013 17 4335 28096 107932 299432 2110748 VILLAGE OF GRAFTON WISCONSIN ENTERPRISE FUNDS WASTEWATER REVENUES cont. LAST TEN FISCAL YEARS 169 Table 29 Table 29 Annual Inflow Total at Wastewater Water Sold Water Pumped Treatment Plant Year 000 Omitted 000 Omitted 000 Omitted 2005 383302 504060 433170 2006 366954 465848 513890 2007 366176 448274 562707 2008 347003 467280 641409 2009 346522 474611 573791 2010 329120 417700 547159 2011 363811 426221 577811 2012 372331 416212 514457 2013 376023 403051 592596 2014 321506 363834 518200 Includes bulk water sales Source Municipal Utility Annual Report of the Grafton Water Wastewater Utility to the Public Service Commission of Wisconsin and Annual Financial Report of the Grafton Water Wastewater Commission VILLAGE OF GRAFTON WISCONSIN ENTERPRISE FUNDS WATER SOLD WATER PUMPED AND ANNUAL INFLOW AT WASTEWATER TREATMENT PLANT LAST TEN FISCAL YEARS 0 100000 200000 300000 400000 500000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 G a l l o n s 0 0 0 o m i t t e d Year Gallons of Water Sold Residental Commercial Industrial Public Authority 170 THIS PAGE LEFT BLANK INTENTIONALLY 171 Table 30 FUNCTION 2005 2006 2007 Police Stations 1 1 1 Public Works Streets Miles 50.74 50.74 50.74 Sidewalks Miles 82.00 82.00 82.00 Number of Streetlights 1653 1653 1653 Community Enrichment Services Number of Parks 17 17 17 VILLAGE OF GRAFTON WISCONSIN CAPITAL ASSETS STATISTICS BY FUNCTION LAST TEN FISCAL YEARS 172 Table 30 2008 2009 2010 2011 2012 2013 2014 1 1 1 1 1 1 1 50.74 50.74 50.74 50.74 52.95 53.02 53.02 82.00 82.00 82.00 82.00 82.64 82.64 82.64 1653 1653 1653 1653 1659 1659 1659 17 17 17 17 17 17 17 VILLAGE OF GRAFTON WISCONSIN CAPITAL ASSETS STATISTICS BY FUNCTION LAST TEN FISCAL YEARS 173