The URL can be used to link to this page

Browse Search

Home My WebLink About20123695.tiffTABLE OF CONTENTS INTRODUCTORY SECTION Table of Contents Letter of Transmittal 1 Government Finance Officers Association Certificate of Achievement for Excellence in Financial Reporting 12 Organization Chart 13 Principal County Officials 14 FINANCIAL SECTION Independent Auditors' Report 15 Management's Discussion and Analysis 17 Basic Financial Statements Government -Wide Financial Statements: Statement of Net Assets 77 Statement of Activities 28 Governmental Fund Financial Statements: Balance Sheet 30 Reconciliation of Total Governmental Fund Balances to the Statement of Net Assets 32 Statement of Revenues, Expenditures and Changes in Fund Balance 34 Reconciliation of the Statement of Revenues, Expenditures and Changes in Fund Balances of Governmental Funds to the Statement of Activities 36 Proprietary Fund Financial Statements: Statement of Net Assets - Proprietary Funds 37 Statement of Revenues, Expenses and Changes in Net Assets - Proprietary Funds 38 Statement of Cash Flows - Proprietary Funds 39 Fiduciary Fund Financial Statements: Statement of Fiduciary Net Assets 40 Statement of Changes in Fiduciary Net Assets 41 Notes to the Financial Statements 42 Required Supplementary Information Pension Trust 79 Other Post Employment Benefits 80 Modified Approach for Infrastructure Assets 81 1 Required Supplementary Information Other Than MD&A: Schedules of Revenues, Expenditures and Changes in Fund Balances -Actual and Budget Major Funds: General Fund 83 Public Works Fund 88 Social Services Fund 90 Human Services Fund 92 Contingent Fund 94 Supplemental Information: Combining Statement of Non -major Governmental Funds: Explanation of Funds 95 Combining Balance Sheet 100 Combining Statement of Revenues, Expenditures and Changes in Fund Balance 102 Schedules of Revenues, Expenditures and Changes in Fund Balances -Actual and Budget Capital Expenditures Fund 104 Non -major Governmental Funds: Special Revenue Funds: Conservation Trust Fund 105 Emergency Fund 106 Public Health Fund 107 Solid Waste Fund 108 Bebee Draw Fund 109 South West Law Enforcement Fund 110 Pioneer Community Law Enforcement Fund 111 Component Units: Housing Authority 112 E-911 Authority Fund 113 Local Highway Finance Report 114 Combining Statements of Internal Service Funds: Combining Statement of Net Assets - Internal Service Funds 116 Combining Statement of Revenues, Expenses and Changes in Net Assets - Internal Service Funds 118 Combining Statement of Cash Flows - Internal Service Funds 120 Combining Statement of Fiduciary Funds: Combining Statement of Changes in Assets and Liabilities - Fiduciary Funds 122 11 Schedule of Revenues, Expenses and Changes in Net Assets -Actual and Budget Enterprise Fund and Internal Service Funds: Enterprise Fund: Paramedic Services 123 Internal Service Funds: Motor Vehicle Fund 124 Health Insurance Fund 125 Insurance Fund 126 Phone Service Fund 127 STATISTICAL SECTION Net Assets by Component 130 Changes in Net Assets 132 Fund Balances of Governmental Funds 134 Changes in Fund Balances, Governmental Funds 136 Assessed and Estimated Actual Value of Property 138 Property Tax Levies - Direct and Overlapping Governments 140 Principal Taxpayers 141 Property Tax Levies and Collections 142 Direct and Overlapping Governmental Activities Debt 143 Legal Debt Margin Information 144 Private Purpose Revenue Bonds 146 Demographic and Economic Statistics 147 Principal Employers 148 Full-time Equivalent Employees by Function/Program 150 Operating Indicators by Function/Program 152 Capital Asset by Function/Program 154 Insurance in Force 156 SINGLE AUDIT Schedule of Expenditures of Federal Awards 157 Notes to Schedule of Expenditures of Federal Awards 162 Report on Compliance and on Internal Control Over Financial Reporting Based on an Audit of Financial Statements Performed in Accordance with Governmental Auditing Standards 163 Report on Compliance with Requirements That Could Have a Direct and Material Effect on Each Major Program and Internal Control over Compliance in Accordance with OMB Circular A-133 165 Schedule of Findings and Questioned Costs 167 Summary Schedule of Prior Federal Audit Findings 172 iii iv In GOUN�V� June 15, 2012 Honorable Board of Commissioners County of Weld 915 10th Street Greeley, CO 80631 Dear Board Members: DEPARTMENT OF FINANCE AND ADMINISTRATION PHONE (970) 356-4000, EXT.4218 FAX: (970) 352-0242 P.O. BOX 758 GREELEY, COLORADO 80632 The Comprehensive Annual Financial Report of the County of Weld, State of Colorado for the fiscal year ended December 31, 2011, is hereby submitted. Responsibility for both the accuracy of the data, and the completeness and fairness of the presentation, including all disclosures, rests with the County. To the best of our knowledge and belief, the enclosed data is accurate in all material respects and is reported in a manner designed to present fairly the financial position and results of operations of the various funds and account groups of the County. The assurance of the accuracy in the County financial report is a result of the County's internal controls. The controls have been developed to provide accurate information on an efficient and cost-effective basis. All disclosures necessary to enable the reader to gain an understanding of the County's financial activities have been included. With the December 31, 2011 financial statements, Weld County has elected to continue a significant change in government financial reporting. The purpose of these changes, which were developed by the Governmental Accounting Standards Board (GASB), is to provide better and more complete information to the users of governmental financial statements. In addition to changes to the basic financial statements, the statements are now accompanied by an introduction, overview, and analysis, referred to as "Management's Discussion and Analysis" (MD&A). This letter of transmittal is designed to complement the MD&A and should be read in conjunction with it. The MD&A can be found in the Financial Section immediately following the independent auditor's report. The County provides the full range of county services contemplated by statute or charter. These include general government functions, public protection and safety, health, social services, human resource services, public improvements, road and bridge operations, planning and zoning, and general administrative services. Honorable Board of Commissioners This report includes all activities for which the Board of County Commissioners is accountable to the citizens of Weld County, financially, or by State Statute or the Weld County Home Rule Charter. All applicable funds, departments, and offices are included in these financial statements as part of the "primary government" of Weld County. In addition, there are several legally separate entities that have significant operational or financial relationships with the County. These include the Weld County Housing Authority, Weld County Retirement Plan, Beebe Draw Law Enforcement Authority, Pioneer Community Law Enforcement Authority, Southwest Weld Law Enforcement authority, Weld County Finance Corporation, Weld County Federal Mineral Lease Act District, and E-911 Authority. These entities are also included in the County's financial statements. INDEPENDENT AUDIT Colorado law requires that the County's financial statements be audited by an independent certified public accountant or firm of certified public accountants licensed to practice in the State of Colorado. The county's financial statements have been audited by McGee, Hearne & Paiz, LLP a Colorado licensed Certified Public Accounting firm. The goal of the independent audit was to provide reasonable assurance that the financial statements 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 issuing an unqualified opinion that the County's financial statements for the year ended December 31, 2011, are fairly presented in conformity with GAAP. The independent auditor's report is presented in the front of the financial section of this report. The independent audit of the County's financial statements was part of a broader, federally mandated "Single Audit" in accordance with provisions of the Single Audit Act of 1984, Federal Single Audit Amendment of 1996, and U.S. Office of Management and Budget Circular A-133, Audits of States, Local Governments, and Non -Profit Organizations. The "Single Audit" is designed to meet the special needs of federal grantor agencies. The standards governing Single Audit engagements require the independent auditor to report not only on the fair presentation of the financial statements, but also on the audited government's internal controls and compliance with legal requirements, especially as they relate to the administration of federal awards. Single audit schedules and the auditor's reports are available in the "Single Audit" section of the document. Honorable Board of Commissioners PROFILE OF WELD COUNTY Location and demographics. Weld County is located along Colorado's Front Range in the northern part of the state. Weld County covers an area of 3,999 square miles in north central Colorado. It is bordered on the north by Wyoming and Nebraska and on the south by the Denver metropolitan area. The third largest county in Colorado, Weld County has an area greater than that of Rhode Island, Delaware and the District of Columbia combined. The climate is dry and generally mild with warm summers, mild winters and a growing season of approximately 138 days. The land surface is fairly level in the east, with rolling prairies and low hills near the western border. Elevations in the county range from 4,400 to 5,000 feet. The South Platte River and its tributaries, the Cache la Poudre, Big Thompson, Little Thompson, Boulder, St. Vrain, and other smaller streams, flow into Weld County from the south and west, leaving the county on the east. There are 31 incorporated towns in Weld County. The county seat and principal city, Greeley, is located in the west central part of the county and contains almost half the county's population. Generally, most of the remaining population resides within a 20 to 30 mile radius of Greeley; the northeastern part of the county is sparsely populated. Southwest Weld County is one of the fastest growing areas in the state due to its proximity to the north Denver metro area. The county's population in 2011 was approximately 254,800. COUNTY GOVERNMENT County Services. Weld County provides the full range of services contemplated by State Statute and the Weld County Home Rule Charter. Services include: 4 Judicial and public safety - consisting of the Sheriff, District Attorney, operation and maintenance of the detention center, and building inspection. 4 Health, employment, and social services. 4 Planning and zoning. 4 Construction, reconstruction and maintenance of streets, highways, and bridges. 4 Parks and recreation. 4 Property valuation, tax collection and distribution, and vehicle licensing. General administrative services. 3 Honorable Board of Commissioners County Operating Structure. Weld County became Colorado's first Home Rule County in 1976. The County is governed by a five -member Board of County Commissioners. Three Commissioners are elected by districts of relatively equal population and two Commissioners are elected at large. They serve staggered four-year terms and function as the County's policymaking body. Each Commissioner coordinates one of five functions of the County. The County is also served by four other elected officials: assessor, clerk and recorder, district attorney, and sheriff. Weld County also has a five -member, non-partisan, elected body that is charged to review all aspects of County government and to make periodic written reports to the public. The Commissioners appoint department heads to be responsible for the various day-to- day operations. Budgeting. The County Commissioners annually adopt budgets by department for all governmental and proprietary funds. Budgets are controlled by the major object categories of Personnel, Operating Costs, and Capital Outlay. Control is maintained by the three categories at the division/department level in the General Fund and at the fund level in all other funds. Supplemental appropriations are approved by the Board of County Commissioners as needed during the year to provide for those items that were unknown or unforeseen at the time the budget was originally adopted. County Employment. Weld County government employs 1235 regular staff (those receiving standard benefits) and 120 temporary and seasonal employees. Employees receive a comprehensive compensation package, typical of municipal and county governments along the Colorado Front Range. Benefits include paid leave, medical and dental insurance plans, a defined benefit retirement plan, and a variety of other insurance and non -insurance benefits. MAJOR INITIATIVES For the Year. In 2011, the Board identified a number of significant program changes to enhance service delivery to the citizens of Weld County. The following is a summary of significant program changes and initiatives for 2011: Continue Implementation of Human Capital Management Strategy. Implement second year of the new Strategic Plan approach. Open a new Administration facility. Implement Criminal Justice Planner strategy t©oordinate the Criminal Justice System in the county. Implement new criminal justice computer system. Identify technology uses to improve services and cost-effectiveness of services. Continue implementation of e -government strategy. 4 Honorable Board of Commissioners Operate Weld County Regional Communications Center under new IGA. Upgrade the towers and county -wide communications system. Continue to explore revenue and operational options to keep the Paramedic Services a viable and affordable service to the citizens. Continue to develop plans for the County for bioterrorism and emergency preparedness. Implement the fifth year of the five-year Support Healthy Marriages Grant. Implement cost containment and revenue strategies to mitigate growing cost of Human Services programs. FACTORS AFFECTING FINANCIAL CONDITION Economic Conditions and Outlook. As we deal with 2012 we find ourselves facing somewhat mixed economic indicators and possibly new challenges that are different than past economic growing and recovery cycles following a recession. The economy continues to struggle with burdensome forces related to the recent recession, such as high levels of private and public debt, high unemployment, the loss of wealth, tight credit markets, the real estate market decline, higher energy costs, European debt crisis, and heightened uncertainty. However, there are economic conditions that continue to be favorable, such as strong manufacturing activity, sustained export growth, and the solid financial condition of many businesses, especially large corporations. Due to these positive indicators and because of the economy's resiliency, the economy is expected to continue to grow despite the headwinds. Growth for both Colorado and the nation will be constrained over the next few years as the negative factors are likely to persist and weigh on the economy. Colorado and Weld County are well positioned for the future due to our diverse economic base and skilled workforce. Entrepreneurship and innovative activity are strengths of the Colorado economy. These strengths will eventually lead the state to stronger sustained growth. However, in the meantime, the economy will have to navigate its headwinds, as well as heightened risks. These risks include the threat of sustained price increases, increased financial instability, and a rise in interest rates, all of which pose forecast risks to the downside. The new historic drive for political change across parts of North Africa and the Middle East has created unrest. As this unrest spreads, concerns about future oil supplies have driven the price of oil from under $90 per barrel to over $110. We are assuming that the price of oil will remain high, but fairly steady, over the next few months and then gradually settle back under $90 as conditions in that part of the world stabilize. Many economists believe there is enough momentum in the economy that recent oil increases, by themselves, should not derail the recovery. 5 Honorable Board of Commissioners Congress continue to focus on deficit reduction through spending cuts. As efforts to pass continuing resolutions and a budget package have shown, agreement in this area will be hard to attain. Some deficit reductions are occurring automatically as the 2009 stimulus provisions expire, and lower troop commitments abroad should lead to slower growth in defense spending. We can anticipate moderation in non -defense discretionary spending as well, but spending cuts in entitlements may be difficult politically. Spending and revenue imbalances at the state and local levels nationally will likely be an impediment to economic growth over the forecast horizon. At the national and state level jobs are being added and recent economic projections indicate that job growth will continue into 2012. Weld County led the state of Colorado in new job growth by percentage in 2011. There was a 1.8% increase in employment in Weld County in 2011. Weld's increase was followed by Denver at 1.1%, Fort Collins at 0.7%, and Boulder at 0.4%. Weld County's qualified workforce, low property taxes, natural resources, and strategic location make Weld County an area that is positioned for sustained opportunity going forward. Agriculture is Weld County's heritage, and food processing is a logical adjunct. In addition, Weld County leads all of Colorado in the number of active oil and gas wells. With the recent locations of wind and solar equipment manufacturers, Weld County is a regional center for the new energy sector. Other sectors like business services and logistics continue to grow. Excitement related to exploration of the Niobrara shale formation in northern Weld County remains high, driving several significant job -creating projects in Weld County. Halliburton broke ground on a 150,000 sq. ft. facility in Fort Lupton on March 18. Although the company has not yet disclosed how many new jobs will be created with the project, initial indications are that it will be in the hundreds. The City of Fort Lupton is in the process of extending water and sewer to the Halliburton site - a project that will open development opportunities for hundreds of acres along the utilities' path. Chesapeake Oil, the nation's second-largest natural gas company, announced that it closed on 800,000 net oil and natural gas leasehold acres in the Denver- Julesburg (DJ) and Powder River Basins in northeast Colorado and southeast Wyoming. The company expects to have as many as 10 drilling rigs operating in the area by the end of 2011, 20 by the end of 2012, and perhaps 40 at full operation. Each rig represents as many as 100 direct jobs. Noble Energy will construct a 66,000 sq. ft. field operations office in Greeley. The new facility will house up to 300 field and management jobs. Anadarko will construct a new 42,000 sq. ft. building in Evans to accommodate new growth. The company expects to double its existing local workforce of 200. Anadarko is also planning to drill 160 new wells over the next two years. Honorable Board of Commissioners The housing market impacts the economy substantially and is closely linked with the business cycle. Home construction remains at historically low levels. Home values affect personal saving rates and can influence national saving and investment. Home values can also affect consumer spending considerably. A strong recovery in the housing sector is necessary in order for a more robust recovery in the broader economy. Unfortunately, this is unlikely in the near future. Nationally and locally, the number of foreclosed properties continues to depress prices and will likely hamper the housing recovery. Nationally, 13 percent of all living units are vacant. According to a recent CoreLogic negative equity report, 19.8 percent of all Colorado residential properties with a mortgage were in negative equity at the end of 2011. Meanwhile, the projected rise in interest rates poses a risk because it would make homes less affordable, which would negatively affect the housing recovery. Building permits for all types of property remain low statewide and in Weld County. The state economist is forecasting that building activity will drop another 3.3 percent in 2011, before increasing a slight 1.3 percent in 2012. The state's rising food, fuel, and clothing prices continued to increase in the Denver -Boulder - Greeley CPI in 2011 to 3.69 percent. Also, a lower rental vacancy rate may push rents higher, which will also contribute to growth in the CPI. Due to expectations for continued expansionary monetary policy, the weaker dollar, and continued worldwide demand for commodities, the CPI should be in the 2.8 to 3.3 range through 2013. The outlook for the economy is particularly murky at this time given the risks to certain fundamental aspects of the economy. Overall price levels have turned upward recently, and further increases will weaken the economy. Consumers, businesses, and government will have to spend more on goods they need, leaving less for investments needed to help the economy grow. Further, rising prices create uncertainty, which would further dampen economic activity. The unrest in the large oil -producing region of North Africa and the Middle East and the heightened worries about the debt crisis in Europe are adding to the uncertainty. The challenge will be limited growth in the foreseeable future. This may hinder Weld County's ability to invest in the community or invest in County employees for the next few years. Our challenge will be to leverage any savings to meet inflationary costs, mandated increases and employee investments. For the Future. As the 2012 budget was developed we are told that the "Great Recession" was over and better times are right around the corner. While we all hope this is the case, unfortunately this not yet true for either Weld County government or for the citizens that we serve. We all continue to struggle with diminished resources and greater needs. Many people in Weld County remain unemployed, real estate values remain somewhat soft, and rates of individual bankruptcies and home foreclosures remain high. For our county government we have seen demand for services grow in the areas of human services caseloads and health services. At the same time our resources have dropped in areas, such as state and federal revenues. Property tax revenues have grown only in the last three years due to oil and gas production and energy price increases. 7 Honorable Board of Commissioners As with any budget, we are very dependent upon state and federal support. Since the start of this recession we have sustained a decline in state revenues. The state support for many programs has reached new lows. This partnership with the state was once one of the pillars of our financial foundation. Economists at the University of Denver's Center for Colorado's Economic Future are projecting that Colorado's economy is expected to come back in 2012, but even with several years of robust growth that may follow, the state budget will not grow fast enough to keep up with the demands of schools, prisons, and health care for the poor. The same economists have concluded that the state budget faces a persistent structural imbalance. Based upon their forecasts, all the growth in state revenues will be consumed by schools, Medicaid and corrections for the foreseeable future and beyond this decade. The state has a structural problem where spending expectations exceed revenue expectations. We must now face the new reality that county governments in Colorado will have far less state funding in the future. At the federal level, stimulus money has come to an end. In Washington both political parties are calling for action to get the nation's fiscal house in order. Although there is disagreement on the specifics of how to reduce federal spending, there is agreement that federal spending must be reduced to control the federal deficit. The federal government cannot continue to be financed with borrowed money at the level it has been. A predictable result is that federal spending for social programs and aid to state and local governments will shrink. Impending budget cuts at the state and federal level mean that local government will need to change the way it works. We all must recognize that in this challenging economy, citizens and businesses are strapped to meet their obligations and there is little or no appetite on the part of voters to raise taxes at any level of government. Weld County government must continue to prepare a budget that reflects the new fiscal reality with reduced resources and rising demands. There is no quick or dramatic or imminent recovery on the horizon. This new fiscal reality is not temporary, but a permanent change. Weld County elected officials, managers, and employees must continue to make every effort to maintain service levels, but to do so with declining resources will demand resourcefulness. We will need to rethink and realign many of our services in order to continue to address public safety, health needs, humarviccs demands, job creation, community aesthetics, growth, and infrastructure requirements without asking for additional tax dollars. Because of this recession, we have leveraged our county workforce talents and examined every county program to make it through the recessionary period. During this recessionary period it has been all about sustainability and leveraging resources for continuation of excellence. As we look to the next phase of this economic cycle, the current recession has taught us that sustainability is a necessary but insufficient condition to ensure the ongoing health of a local government. A sustainable system is balanced, but an external shock (like a severe economic downturn) can unbalance the system and perhaps even collapse it. Local governments will continue to face serious challenges fromsidet including, but not limited to, economic adjustments, natural disasters, and important polio, changes by other levels of government, i.e. state and federal budget reductions. As such we must strive to help Weld County, as an organization, go beyond sustainability to a system that is adaptable and regenerative - in a word - resilient. 8 Honorable Board of Commissioners The Government Finance Officers Associati6GFOA) is calling for local governments to become "financially resilient". A financially resilient organization is adaptable to changing conditions, regenerative in the face of setbacks, and produces superior value for constituents. Long-term financial planning is a closely related concept to financial resiliency, but also involves a strategic intent that is shared by all the organization's leaders of how the organization's capabilities should develop so as to remain effective in the future. Strategic intent is not a plan or set of authoritative decisions. Rather, it represents an institutional argument about how the organization seeks to create value for the public over the long run. As one examines the characteristics of a resilient local government, Weld County, as an organization, possesses many of those characteristics. Weld County has developed solid mission, vision, and value statements. Strong financial policies have been adopted and have been followed for a number of years. Strong Board of County Commissioner's polices are in place and understood with respect to how the organization will be run. This gives the governing board the confidence that allows for the empowerment of managers and employees in their respective departments. This empowerment dhe departmental level allows departments to identify issues, analyze them, and develop strategic solutions. It also fosters departmental managers taking on more responsibility for their budgets, and most importantly, fostering a strategic framework for creating value for the public through the government programs Weld County delivers. Financially resilient local governments are distinguished by the adoption of a policy supporting a financial planning process that assesses the long-term financial implications of current and proposed operating and capital budgets, financial policies, and service policies. In resilient local governments, long-term financial planning is institutionalized in the governance of the organization; this leads to consistent decisions. Financial policies are the cornerstone to the financial well-being of the organization because they help preserve good practices through changes in elected officials and top management personnel. Weld County has long had these financial policies in place. Another characteristic of a resilient local government is having healthy fund balances and reserves in place, with strong policies that create those reserves for specific purposes. This preserves the credibility of the reserve system. The reserves are there for a widely understood and agreed upon reason, not as a slush fund to be raided without a good reason. Weld County has fund balances and reserves that approach over one-third (33%) of our operating budget. The ratio of Weld County's fund balance and reserve level to annual expenditures is one of the highest of any local government in the nation. Most local governments have reserves in the 5 to 15 percent range. Weld County's fund balance and reserve levels give the County a great deal of security and flexibility to deal with changing environments, downturn in economic conditions, or any serious fiscal challenge. 9 Honorable Board of Commissioners Weld County has demonstrated our financial resilience the last three years by dealing with the volatility of our property tax revenues, declining state revenues and the severity of the current economic downturn at the same time. As a resilient government, when we were caught in a financial and economic decline, we quickly recognized it and reacted by updating our strategic plan, continually monitored the environment for change, and maintained open communication with departments and the governing board so corrective actions could be taken. This is an ongoing process and part of the Weld County corporate culture. As a resilient organization, Weld County has been good at using forecasts to identify the parameters within which to develop and execute strategies, rather than trying to "predict" the future. All departments are involved in regularly reviewing the environment they operate in and helping diagnose strategic issues. The involvement of the elected officials and departmental managers in strategic diagnosis promotes inforrred and realistic decision making in the county. All Weld County departments put a great deal of effort into their long term plans. Resilient governments connect their long term financial planning with all the long term plans to increase the quality of their forecasting and strategic diagnosis. For example, in Weld County the Comprehensive Land Use Plan suggests long-range transportation and facility requirements that must be coordinated and taken into account when developing long range financial capital funding plans. This process has allowed Weld County to accommodate the capital and transportation needs of the County without incurring any long term debt. Financial resiliency is essential to continuing a consistent program of public service despite the current volatile economic environment. As many local governments across the country struggle to develop the characteristic of being a resilient government, Weld County can be proud that as a county government we have achieved financial resiliency and have realized the benefits of no long term debt, good strategic planning, and a soft landing in the current recession. Most importantly, though, Weld County has been able to maintain the trust and confidence of our constituents and continue to create value for the public through government action and programs. Weld County government has survived the most severe economic downturn in the last 70 years, and we have done so in a fashion of teamwork, collaboration, and a focus on sustaining our core services while planning for the future. Will the future be easy? No, but we are confident it will improve and we are committed to continuing our mission so all Weld County citizens are proud of their county government and pleased with the county services provided to them. AWARDS AND ACKNOWLEDGEMENTS The Government Finance Officers Association (GFOA) awarded a Certificate of Achievement for Excellence in Financial Reporting to the County for its Comprehensive Annual Financial Report for the fiscal year ended December 31, 2010. This was the twenty-ninth year that the County has received this prestigious award. In order to be awarded a Certificate of Achievement, the County published an easily readable and efficiently organized Comprehensive Annual Financial Report. This report satisfied both generally accepted accounting principles and applicable legal requirements. 10 Honorable Board of Commissioners 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 Program's requirements and we are submitting it to the GFOA to determine its eligibility for another certificate. In addition, the County also received the GFOA's Award for Distinguished Budget Presentation for its 2011 annual appropriated budget for nearly thirty consecutive years. In order to qualify for the Distinguished Budget Presentation Award, the County's budget document was judged to be proficient in several categories including policy documentation, financial planning, and organization. Financial reports are valuable in that they provide a permanent historical record of a governmental agency's operation to the management and the general public. It is our belief that this is a comprehensive report of the 2011 financial transactions under our control and that the following statements present an accurate, informative record of the financial activities of the County of Weld and its financial condition at December 31, 2011. The preparation of this report could not be accomplished without the efficient and dedicated services of the entire staff of the Accounting/Finance Department. I should like to express my appreciation to all members of the department who assisted and contributed to its preparation. I would also like to thank the members of the Board of County Commissioners for their interest and support in planning and conducting financial operations of the County in a responsible and progressive manner. Respectfully submitted, • OML-11.0` Monica`Daniels-Mika, Director Finance and Administration 11 Certificate of Achievement for Excellence in Financial Reporting Presented to County of Weld Colorado For its Comprehensive Annual Financial Report for the Fiscal Year Ended December 31, 2010 A Certificate of Achievement for Excellence in Financial Reporting is presented by the Government Finance Officers Association of the United States and Canada to government units and public employee retirement systems whose comprehensive annual financial reports (CAFRs) achieve the highest standards in government accounting and financial reporting. otia- e President 1,0467tra' Executive Director 12 z w z w ce 0 C9 ce w J W 0 x z 0 U D J W z LJJ N H U H Z O UJ O WM ft Cu" VJ Corrections, Law Enforcement Animal Control, Forensic Lab Task Force, Code Enforcement Office of Emergency Management J C O Q C 0 (5 Elected Members) tJ (5 Elected Members) K I Ct a a) 0 a) U .a) J 7- 95 Commissioner Coordinator i _ K O 03 -C a) E N t _ co Q U 0-� 0 Environment L O O E 0 O U J O_ ro co C E o U U ( co L 0 a U a) 0 U L O p > U 0L0 O W 2 J Social Services I O O L.. U 10 Q 0 O)'D O O 'cm`s a-o- .5)� ct tea- wo ft LI- r Human Services 95o L C Q) O c .V Q) Ct a) Q w 'Cow E N Q C �—C <13 0)Ca C—ea ca 0mm a) -o U c fm O m D 0 •C I 0 U co a) 0 J r U N U O C• U (t i N CO 0 Paramedic Services Extension Service C O O 4— • C O U U N (2 0 U) C O U O O .U 5OOCO O O CO 02 C C (�6 O (O CIO F< co LL O C L O a)IL d C I - -a L V) e6 C o E O m � (1) O O) ` U -CID O) (6 O . +J O C �- • m O Q N O U E U a O }, -0 t 0 N = :(-73E an CD a)° c a C .c0)2 O O U C0C Q O O) (p C C a C C a was ,c3 LL O CO U U U a)•a ocn d To c O s- o_ u) a) 13 COUNTY OF WELD STATE OF COLORADO PRINCIPAL COUNTY OFFICIALS December 31, 2011 Board of County Commissioners Sean Conway Barb Kirkmeyer Douglas Rademacher David Long Bill Garcia County Clerk and Recorder Steve Moreno County Assessor Christopher M. Woodruff County Sheriff John Cooke Director of Finance & Administration Monica Daniels -Mika Controller Barbara Connolly Treasurer John R. Lefebvre, Jr. 14 FINANCIAL SECTION WpMcGee, Hearne & Paiz, LLP Certified Public Accountants and Consultants 314 West 18th Street, Cheyenne, Wyoming 82001-4404 INDEPENDENT AUDITOR'S REPORT Board of County Commissioners Weld County, Colorado Greeley, Colorado We have audited the accompanying financial statements of the governmental activities, the business -type activities, each major fund, and the aggregate discretely presented component units and remaining fund information of Weld County, Colorado (the "County"), as of and for the year ended December 31, 2011, which collectively comprise the County's basic financial statements as listed in the table of contents. These financial statements are the responsibility of the County's management. Our responsibility is to express opinions on these financial statements based on our audit. We did not audit the financial statements of Weld County Housing Authority (the "Authority"), a discretely presented component unit. The Authority's financial statements were audited by other auditors whose report thereon has been furnished to us, and our opinion, insofar as it relates to the amounts included for the Authority, is based on the report of the other auditors. We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the financial statements are free of material misstatement. An audit includes consideration of internal control over financial reporting as a basis for designing audit procedures that are appropriate in the circumstances, but not for the purpose of expressing an opinion on the effectiveness of the County's internal control over financial reporting. Accordingly, we express no such opinion. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall financial statement presentation. We believe that our audit provides a reasonable basis for our opinions. In our opinion, based on our audit and the report of other auditors, the financial statements referred to above present fairly, in all material respects, the respective financial position of the governmental activities, the business -type activities, each major fund, and the aggregate discretely presented component units and remaining fund information of the County as of December 31, 2011, and the respective changes in financial position and cash flows, where applicable, thereof for the year then ended in conformity with accounting principles generally accepted in the United States of America. In accordance with Government Auditing Standards, we have also issued our report dated June 15, 2012 on our consideration of the County's internal control over financial reporting and our tests of its compliance with certain provisions of laws, regulations, contracts and grant agreements and other matters. The purpose of that report is to describe the scope of our testing of internal control over financial reporting and compliance and the results of that testing, and not to provide an opinion on the internal control over financial reporting or on compliance. That report is an integral part of an audit performed in accordance with Government Auditing Standards and should be considered in assessing the results of our audit. 15 Accounting principles generally accepted in the United States of America require that the management's discussion and analysis on pages 17 through 26, the schedules of funding progress and employer contributions, the condition assessments of infrastructure, and the budgetary comparison schedules on pages 79 through 94 be presented to supplement the basic financial statements. Such information, although not a part of the basic financial statements, is required by the Governmental Accounting Standards Board who considers it to be an essential part of financial reporting for placing the basic financial statements in an appropriate operational, economic, or historical context. We and the other auditors have applied certain limited procedures to the required supplementary information in accordance with auditing standards generally accepted in the United States of America, which consisted of inquiries of management about the methods of preparing the information and comparing the information for consistency with management's responses to our inquiries, the basic financial statements, and other knowledge we obtained during our audit of the basic fmancial statements. We do not express an opinion or provide any assurance on the information because the limited procedures do not provide us with sufficient evidence to express an opinion or provide any assurance. Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the County's basic financial statements. The combining and individual nonmajor fund financial statements; nonmajor fund budgetary comparison information; Local Highway Finance Report; and schedule of expenditures of Federal awards, as required by the U.S. Office of Management and Budget Circular A-133, Audits of States, Local Governments, and Nonprofit Organizations, are presented for purposes of additional analysis and are not a required part of the basic fmancial statements. Such information is the responsibility of management and was derived from and relates directly to the underlying accounting and other records used to prepare the financial statements. The combining and individual nonmajor fund financial statements, Local Highway Finance Report, budgetary comparison information, and the schedule of expenditures of Federal awards have been subjected to the auditing procedures applied by us and the other auditors in the audit of the basic fmancial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the financial statements or to the financial statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America. In our opinion, based on our audit and the report of other auditors, this information is fairly stated in all material respects in relation to the basic financial statements as a whole. Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the County's basic financial statements. The introductory section and statistical tables are presented for purposes of additional analysis and are not a required part of the basic financial statements. Such information has not been subjected to the auditing procedures applied in the audit of the basic financial statements by us and, accordingly, we do not express an opinion or provide any assurance on it. 1)7c Cheyenne, Wyoming June 15, 2012 2 16 MANAGEMENT'S DISCUSSION AND ANALYSIS This section of the report provides readers with a narrative overview and analysis of the financial activities of Weld County for the fiscal year ended December 31, 2011. We encourage readers to consider the information presented here in conjunction with the letter of transmittal and basic financial statements to enhance their understanding of the County's financial performance. FINANCIAL HIGHLIGHTS Weld County's assets exceeded liabilities by $347.6 million at the end of 2011. Of this amount, $77.7 million may be used to meet the government's ongoing obligations to citizens and creditors. The remaining $269.9 million is invested in capital assets or restricted by law. The County's General Fund balance was $21.1 million as of December 31, 2011. Of this amount, $.7 million for non -spendable assets, $6 million is restricted for emergencies; $1.9 million committed for economic development; $1.3 million is assigned for property tax credits and $.5 million for encumbrances. The remaining $10.7 is available to meet the ongoing obligation to citizens and creditors The 2011 General Fund balance is $3.3 million higher than in the previous year. The total fund balance is 25.2% of 2011 General Fund operating expenditures plus net operating transfers. The County Commissioners' goal is to keep fund balance at no less than 5%. The Board has not budgeted any expenditures from the fund balance in 2012. OVERVIEW OF THE FINANCIAL STATEMENTS This discussion and analysis is intended to serve as an introduction to the County's basic financial statements. The basic financial statements contain three components: 1) government - wide financial statements, 2) fund financial statements, and 3) notes to the financial statements. In addition to the basic statements, this report also contains other supplementary information including combining statements for non -major funds, a statistical section, and information regarding federal grant programs. Government -wide Financial Statements Thegovernment-wide financial statementare designed to provide readers with a broad overview of the County's finances in a manner similar to a private sector business. The statement of net assets presents information on all oflte County's assets and liabilities, with the difference between the two reported as net assets. Over time, increases or decreases in net assets may serve as a useful indicator of whether the County's financial position is improving or deteriorating. The statement of activities presents information showing how the government's net assets changed during the fiscal year. All changes in net assets are reported as soon as the underlying event giving rise to the change occurs, regardless of the timing of related cash flowThus, revenues and expenses are reported in the statement for some items that will only result in cash flows in future fiscal periods (e.g., uncollected taxes). 17 Both of the government -wide financial statements slfinguish functions of the County 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 charge%business-type activities). Weld County's governmental activities include general government, public safety, roads andiai'a'es, auxiliary, culture and recreation, and health and human services. The County has one business type activity — operation of the paramedic services. The government -wide financial statements include nobnly Weld County itself (known as the primary government), but also legally separate entities which have a significant operational or financial relationship with the County. These entities, known as blended component units, include local improvement districts, Finance Corporation, Weld County Retirement Plan, Pioneer Law Enforcement Authority, Southwest Weld Law Enforcement Authority and Beebe Draw Law Enforcement Authority. Discretely presented component units are Housing Authority and E-911 Emergency. More information on the functions of these entities can be found in Note 1 to the financial statements. 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. Weld County, like other state and local governments, uses fund accounting to ensure and demonstrate compliance with finance -related legal requirements. All of the funds of Weld County 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 activitiesin 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 government's near -term financing requirements. Because the focus of governmental funds is narrower than that of the government -wide financial statements, it is useful to compare the information presented for governmental funds with similar information presented for governmental activities in the government -wide financial statements. By doing so, readers may better understand the long-term impact of the government's near -term financing decisions. Both the governmental fund balance sheet and the governmental fund statement of revenues, expenditures, and changes in fund balances provide a reconciliation to facilitate this comparison between governmental funds and governmental activities. Weld County maintains eleven individual governmental funds. Information is presented separately in the governmental funds balance sheet and in the governmental funds statement of revenues, expenditures, and changes in fund balances for the General Fund, Public Works Fund, Social Services Fund, Human Services Fund, Capital Expenditures, and Contingent Fund, all of which are considered to be major funds. Data from the other five funds are combined into a single, aggregated presentation. Individual fund data for each of these non - major funds is provided in the form of combining statements elsewhere in this report. The basic governmental fund financial statements can be found on pages 30 through 36 of this report. 18 Proprietary funds. Weld County maintains two different types of proprietary funds. Enterprise funds are used to report the same functions presented as business -type activities in the government -wide financial statements. Weld County has one enterprise fund, the Paramedic Services Fund. Internal service funds are an accounting device used to accumulate and allocate costs internally among the County's various functions. Weld County uses internal service funds to account for its fleet maintenance, phone services, Weld Finance Corporation, and self- insurance activities. Because these services predominantly benefit governmental rather than business -type functions, they have been mostly included within governmental activities in the government -wide financial statements. Proprietary funds provide the same typdnftfrmation as the government -wide financial statements, only in more detail. The proprietary fund financial statements provide separate information for the Paramedic Services Fund, which is considered to be a major fund of the County. The remaining proprietary funds, all of which are internal service funds, are combined into a single, aggregated presentation in the proprietary fund financial statements. Individual fund data for each of these non -major funds is provided in the form of combining statements elsewhere in this report. The basic proprietary fund financial statements can be found on pages 37 through 39 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 included in the government -wide financial statements because the resources of these funds are not available to support Weld County's own operations. The accounting used for fiduciary funds is much like that used for proprietary funds. The basic fiduciary fund financial statements can be found on page 40 through 41 Budgetary Comparisons. Weld County adopts an annual appropriated budget for all of its funds. A budgetary comparison statement has been provided for all major funds on pages 83 to 94 of this report. Budget to actual comparisons for each of the non -major funds are provided in other schedules elsewhere in 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 43 through 78 of this report. Other information. The combining statements referred to earlier in connection with non -major governmental funds and internal service funds are presented following the notes to the financial statements and can be found on pages 100 through 111 and 116 through 127 respectively. COUNTY -WIDE FINANCIAL ANALYSIS Net Assets. As noted earlier, net assets may serve over time as a useful indicator of a government's financial position. As of December 31, 2011, assets exceeded liabilities by $347.6 million. The following table provides a summary of the County's governmental and business -type net assets for 2010 and 2011. 19 Table 1 Net Assets (in Millions) Assets Current and other assets Capital assets Total assets Liabilities Current and other liabilities Long-term liabilities Total liabilities Net Assets Invested in capital assets Restricted Unrestricted Total net assets Governmental Activities Business -type Activities Total 2010 2011 2010 2011 2010 2011 $186.67 $204.18 $3.60 $3.87 $190.27 $208.05 254.89 252.36 1.31 1.52 256.20 253.88 $441.56 $456.54 $4.91 $5.39 $446.47 $461.93 $96.74 $105.81 $.41 $.34 $97.15 $106.15 8.20 8.14 .00 .00 8.20 8.14 $104.94 $113.95 $.41 $.34 $105.35 $114.29 $254.89 $252.36 $1.31 $1.52 $256.2 $253.88 15.65 16.10 .00 .00 15.65 16.10 66.08 74.13 3.19 3.53 69.27 77.66 $336.62 $342.59 $4.50 $5.05 $341.12 $347.64 A significant portion of Weld County's net assets (22.3%) represents unrestricted net assets of $77.66 million, which may be used to meet the County's ongoing obligations to citizens and creditors. Another significant portion of the County's net assets (73.0%) reflects its investment in capital assets. These assets include land, buildings, machinery, equipment and infrastructure. These capital assets are used to provide services to citizens; consequently, they are not available for future spending. Although the investment in capital assets is reported net of related debt, it should be noted that the resources needed to repay this debt must be provided from other sources since the capital assets themselves cannot be used to liquidate these liabilities. An additional $16.10 million of the County's net assets (4.6%) represents resources that are subject to external restrictions on how they may be used. Included in this category are the TABOR emergency reserve of $6.0 million, $5.4 for programs and $4.7 million in reserves for insurance claims. At the end of 2011 Weld County had positive balances in all three categories of net assets, both for the government as a whole, as well as for its separate governmental and business -type activities. Changes in Net Assets. Governmental and Business -type activities increased the County's net assets by $6.52 million in 2011. The following table indicates the changes in net assets for governmental and business -type activities in 2010 and 2011. 20 Changes in Net Assets (in Millions) Revenues Program revenues: Charges for services Operating grants and contributions Capital grants and contributions General revenues: Property taxes Other taxes Other revenues Total revenues Expenses General government Public safety Streets and highways Culture and recreation Health & Welfare Economic Assist Paramedic services Total expenses Increase (decrease) in net assets before Transfers Transfers Increase (decrease) in net assets Net Assets Beginning Net Assets Ending Governmental Business -type Total Activities Activities 2010 2011 2010 2011 2010 2011 $41.77 $41.49 $5.81 $6.29 $47.58 $47.78 27.86 24.03 0.05 .22 27.91 24.25 0.00 0.00 0.00 0.00 0.00 0.00 95.25 6.86 11.08 76.81 7.54 13.28 0.00 0.00 0.00 0.00 0.00 0.00 95.25 6.86 11.08 76.81 7.54 13.28 $182.82 $163.15 $5.86 $6.51 $188.68 $169.66 $31.50 $31.93 $0.00 $0.00 $31.50 $31.93 40.55 42.61 0.00 0.00 40.55 42.61 34.67 37.52 0.00 0.00 34.67 37.52 1.21 1.12 0.00 0.00 1.21 1.12 37.95 35.88 0.00 0.00 37.95 35.88 9.26 8.12 0.00 0.00 9.26 8.12 0 0.00 6.35 5.96 6.35 5.96 $155.14 $157.18 $6.35 $5.96 $161.49 $163.14 27.68 5.97 (.49) .55 27.19 6.52 (1.50) 0.00 1.50 0.00 0.00 0.00 26.18 5.97 1.01 .55 27.19 6.52 310.44 336.62 3.49 4.50 313.93 341.12 $336.62 $342.59 $4.50 $5.05 $341.12 $347.64 Governmental Activities. Governmental activities increased Weld County's net assets by $5.97 million in 2011. Key elements of this increase are as follows: Total revenues were down $19.67 million, 10.76% from the prior year, primarily due to decreases in property taxes ($18.44 million) and operating grants revenue ($3.83 million) and increases in other taxes (.68 million) and other revenue (2.2 million) Expenses totaled $157.18 million. This represents a 1.31% increase, with increases in streets and highways ($2.85 million) and public safety ($2.06 million) while expenditures decreased in health and welfare ($2.07 million) and economic assistance ($1.14 million). Business -Type Activities. The County's only business -type activity, Paramedic Services, increased net assets in 2011 by $.55 million. 21 FINANCIAL ANALYSIS OF THE COUNTY'S FUNDS As noted earlier, Weld County uses fund accounting to ensure and demonstrate compliance with finance -related legal requirements. Governmental Funds Overview. The focus of County governmental funds is to provide information on near -term inflows, outflows, and balances of spendable resources. Such information is useful in assessing the County's financing requirements. In particular, unassigned fund balance may serve as a useful measure of a government's net resources available for spending at the end of the fiscal year. As of the end of 2011, the combined ending fund balance of County governmental funds was $90.87 million. Of this amount the approximately $1.65 million represents an investment in non - spendable items ($1.13 million inventory and $.52 million in prepaid expenses). Another $42.49 million of fund balance is restricted use for emergencies ($6 million) public works ($29.23 million) health, welfare and economic assistance ($7.26 million). Fund balance committed to Economic Development ($1.93 million) Capital injects ($11.57 million) contingencies ($20.04 million) and environmental conservation ($.68) is $34.22 million and another $10.69 million is unassigned to continue providing services to the general public. The County has six major governmental funds. These are 1) General Fund; 2) Public Works Fund; 3) Social Services Fund; 4) Human Services Fund; 5) the Contingent Fund; 6) Capital Expenditures Fund. 1. General Fund. This is the primary operating fund of the Weld County Government. It accounts for many of the County's core services, such as law enforcement, planning, and elections. The general fund balance was $21.11 million as of December 31, 2011. The 2011 fund balance went up $9.26 million. $6.0 million is from a prior period adjustment to move the TABOR emergency reserve from the Emergency Reserve Fund to the General Fund due to changes in accounting to comply with GASB 54. The other increases are due to the added revenues from oil and gas mineral leasing revenues, jail revenues, building inspection fees from oil and gas wells, Clerk and Recorder fees due to the economic recovery of car sales, and various departments under spending. As a measure of the general fund's liquidity, it may be useful to compare both unassigned fund balance and total fund balance to total fund expenditures. Unassigned fund balance represents 14.16% of total 2011 expenditures, while total fund balance is 27.96% of the same amount. 2. Public Works Fund. The Public Works Fund is also state mandated. The fund records costs related to County road and bridge construction and maintenance. The Public Works Fund had $30.19 million in fund balance at the end of 2011. This amount was $5.12 million more than the previous year. 2011 expenditures for road projects were less than budgeted as some projects were delayed, and revenues from highway user taxes due to the new FASTER legislation was higher than anticipated. In addition $7.1 million was transferred from the Contingency Fund in 2011 to fund the 2012 oil and gas haul route program (HARP). 3. Social Services Fund. The Social Services Fund is mandated by State Statute. This fund accounts for the local share of many Federal and State public welfare programs. The fund carried a $3.82 million balance at the end of 2011 up $1.14 from its balance in 2010, due to the receipt of additional child welfare and administration allocations from the state for 2011. 72 4. Human Services Fund. The Human Services Fund accounts for various Federal and State human services grants. Primary funding agencies are DOL, HHS, and CSA. 6. Contingent Fund. The Contingent Fund records any property tax revenue levied by the Board of County Commissioners to cover reasonable unforeseen expenditures. The fund balance decreased by $6.91 million due to transfers to cover unforeseen expenditures in other funds and fluctuation in oil and gas assessed valuation. 5. Capital Expenditure Fund. The Capital Expenditure Fund accounts for the construction of major capital facilities. These are the remodel of the new administration building in the Weld business park, office building, upgrade of the jail video conferencing system, and the lining of the Geisert Gravel Pit for water storage. Proprietary Funds Overview The County's proprietary fund statements provide the same of information found in the government -wide statements, but in more detail. The County has one enterprise -type fund, The Paramedic Services Fund. Net assets of the fund at the end of the year amounted to ($4.75 million). The total increase in net assets for the fund was $.55 million. Other factors concerning the finances of this fund were discussed under business -type activities. Weld County has five internal service funds. Information on these funds is aggregated in the Proprietary Fund financial statements. GENERAL FUND BUDGETARY HIGHLIGHTS Comparison of Total Fund Balacne as of December 31, 2010 and 2011 $35 $30 $25 c $20 O $- 1 I k ■ General Fund Public Works Social Human Contingent Capital Other Govt. Services Services Fund Projects Funds 2010 2011 23 The County's budget is prepared according to Colorado statutes. The most significant budgeted fund is the General Fund. In December of 2010, the Board of County Commissioners appropriated $74.85 million for general fund expenditures and other financing uses for 2011. Table 3 Revenue and other financing sources Expenditures and other financing uses 2011 General Fund Budget (in Millions) Original Budget Amendments $ 75.30 $ 8.90 Final Budget Actual $ 84.20 $ 87.07 $ 74.85 $ 9.76 $ 84.61 $ 83.81 During 2011 mid -year budget amendments included: $0.20 million in transfers to OPEB Trust Fund to increase the reserve amount C $1.8 million transferred to Retirement Fund to reimburse for past administrative expenses $0.25 million transferred to Phone Services for a phone system upgrade $5.5million transferred to Capital Expenditure Fund for remodel of the administration building in the Weld Business Park, lining of the Giesert Gravel Pit, and special projects C Supplemental appropriations were made to various departments for salary and benefit reallocations. The increase was possible because °tees fund balance, various departments under spending their budgets, and additional unanticipated revenues. Those revenues include oil and gas mineral leasing ($6.05 million), building inspection fees from oil and gas wells ($0.57 million), Clerk and Recorder fees from vehicle registration ($0.75 million), and jail revenue ($0.35 million). 24 CAPITAL ASSET AND DEBT ADMINISTRATION Capital Assets. Weld County's investment in capital assets for its governmental and business type activities as of December 31, 2011 totals $253.89 million (net of accumulated depreciation). This investment includes all land, buildings, machinery, equipment, intangible assets and infrastructure. The total decrease in investment in capital assets for the current fiscal year was 1.02%. Major capital asset events during the current fiscal year include the following: 4 Road construction or major improvements totaling $8.59 million. C Began the lining of the Giesert Gravel Pit for water storage $1.66 million C Completed the upgrade of jail video conferencing system $0.24 million Completed the remodel of the new administration building in the Weld Business Park of $2.6 million The County implemented the "depreciation method" under GASB 34 for its road and bridge infrastructure assets, except for the gravel roads, where the "modified approach" was used. The County's policy is to maintain gravel roads at a condition of fair or better. This level of condition is being maintained consistently on over 97% of miles of road. Additional information on the County's capital assets can be found in Note 6 of this report. Construction commitments are discussed in Note 11. Long-term Debt. At December 31, 2011, Weld County had no outstanding long-term debt or debt from Certificates of Participation (COP). The last COP was paid off early on August 1, 2007. The Weld County Home Rule Charter provides for a general obligation debt limit of 3% of assessed valuation. The county had a general obligation debt capacity of $162.6 million in 2011 The county currently has no debt subject to the limitation. No new debt was issued in 2011. Additional information on Weld County's debt can be found in Note 8. Other Matters. The following factors are expected to have a significant effect on the County's financial position or results of operations and were taken into account in developing the 2012 budget. 4 Implement a new criminal justice computer system. 4 Sheriff's Office will implement a major reorganization to realign work groups and activities to improve span of control. Implement the third year of new strategic planning process. 4 End the five year grant for Support Healthy Marriages program. 25 Complete the upgrade of the towers and county -wide communication system. Add an additional Zoning Compliance Officer to better respond to zoning violations. • Execute the restructuring of the Coroner's Office. Implement a number of cost containment and strategies to mitigate growing cost of Human Services programs. 4, Continue to operate the new employee health clinic as a means to improve employees' health and contain health care costs. Implement an Adult Diversion Services program for adult offenders in Justice Services in coordination with the District Attorney's Office. Fund a Haul Route Program (HARP) to improve county roads impacted by the energy industry due to new oil and gas drilling exploration. Study in conjunction with City of Greeley the delivery of emergency medical services in the City of Greeley and the county. • Have Weld Food Bank contract directly with the state for the Supplemental Foods program, thus removing the county as the middle -man in the process. Offer both a Preferred Provider Organization (PPO) option and a High Deductible Health Plan/Health Reimbursement Account (HDHP/HRA) option to employees and dependent for health insurance coverage. Retirement costs will increase 3.5 percent overall based upon the Board's policy to fully fund the Annual Retirement Contribution (ARC) calculated by the Weld County Retirement Plan's actuary each year. The County will fund the total 3.5 percent. • Office of Emergency Management will be reorganized and moved from the Sheriff's supervision to be under the direct supervision of the Board of County Commissioners effective January 1, 2012. REQUESTS FOR INFORMATION This financial report is designed to provide a general overview of Weld County's finances for all those with an interest in the government's finances. Questions concerning any of the information provided in this or for additional financial information should be addressed to the Director of Finance and Administration, 1150 O Street, Greeley, CO 80631. Request for additional information regarding the Housing Authority should be addressed to Tom Teixeira, Executive Director, Weld Housing Authority, 903 6th Street, Greeley, CO 80631. 26 BASIC FINANCIAL hatio STATEMENTS COUNTY OF WELD STATE OF COLORADO Statement of Net Assets December 31, 2011 ASSETS Cash and cash equivalents Property taxes receivable Receivables (net of allowance for uncollectibles) Due from other governments Internal balance Inventories Other assets Net other post employment benefits asset Restricted assets: Cash and cash equivalents Capital Assets not depreciated Capital Assets - net of accumulated depreciation Total assets LIABILITIES Accounts payable and other current liabilities Accrued liabilities Due to other governments Unearned revenue Other liabilities Long-term liabilities: Due within one year: Compensated absences Due in more than one year: Compensated absences Net Pension Obligation Total liabilities NET ASSETS Invested in capital assets Restricted for: Programs Emergencies Claims (Note 7) Unrestricted Total net assets Primary Government Governmental Activities Business -type Activities $ 104,086,177 $ 91,268,968 2,894,243 1,820,601 (300,085) 1,214,906 1,151,795 1,685,635 354,369 30,325,638 222,039,550 456,541,797 4,425,979 7,477,124 51,390 93,609,350 7,054 238,329 3,032,031 5,108,709 113,949,966 Total Component Units Housing E-911 Authority Authority 1,913,104 $ 105,999,281 $ 1,591,696 $ 1,785,939 1,648,503 300,085 5,953 48,496 1,475,652 5,391,793 33,531 307,971 341,502 252,365,188 1,524,148 5,360,845 6,000,000 4,734,409 74,131,389 3,526,143 $ 342,591,831 $ 5,050,291 See accompanying notes to the basic financial statements 91,268,968 4,542,746 1,820,601 1,214,906 1,157,748 1,685,635 354,369 30,374,134 223,515,202 682,194 6,691 370,468 11,856 318,243 2,455 2,979,211 461,933,590 2,662,905 5,085,848 4,459,510 7,785,095 51,390 93,609,350 7,054 238,329 3,032,031 5,108,709 114,291,468 253,889,336 5,360,845 6,000,000 4,734,409 77,657,532 29,914 1,794 9,069 10,038 29,997 80,812 3,323 11,856 2,979,211 341,306 2,228,931 2,103,314 $ 347,642,122 $ 2,582,093 $ 5,082,525 27 COUNTY OF WELD STATE OF COLORADO Statement of Activities Year Ended December 31, 2011 Program Revenues Primary government: Governmental activities: General government Public safety Streets and highways Health and welfare Culture and recreation Economic assistance Total governmental activities Business -type activities: Paramedic service Total primary government Component units: Housing Authority E-911 Authority Total component units Expenses Operating Capital Charges for Grants and Grants and Services Contributions Contributions $ 31,930,407 $ 12,644,748 $ 961,952 $ 42,613,038 6,023,109 3,022,775 37,519,293 2,022,037 9,745,238 35,881,864 19,360,887 2,871,603 1,123,268 619,316 376,030 8,115,722 822,309 7,056,613 157,183,592 41,492,406 24,034,211 5,964,112 6,291,585 222,937 $ 163,147,704 $ 47,783,991 $ 24,257,148 $ $ 2,739,769 $ 87,429 $ 2,760,855 $ 2,541,888 2,351,667 $ 5,281,657 $ 2,439,096 $ 2,760,855 $ GENERAL REVENUES Taxes: Property taxes Specific Ownership Severance/Tabacco Royalties Miscellaneous Unrestricted investment earnings Total General Revenues and Transfers Change in net assets Net assets - beginning Net assets - ending See accompanying notes to the basic financial statements 28 Net (Expenses) Revenues and Changes in Net Assets Primary Government Governmental Activities Business -type Activities $ (18,323,707) $ (33,567,154) (25,752,018) (13,649,374) (127,922) (236,800) (91,656,975) 550,410 $ (91,656,975) $ 76,808,723 5,743,784 1,794,415 7,169,988 4,305,446 1,804,728 97,627,084 550,410 alb dle dle Total $ (18,323,707) (33,567,154) (25,752,018) (13,649,374) (127,922) (236,800) (91,656,975) 550,410 Component Units Housing E-911 Authority Authority dim $ (91,106,565) $ 76,808,723 5,743,784 1,794,415 7,169,988 4,305,446 1,804,728 97,627,084 IND $ $ 108,515 $ (190,221) 108,515 $ (190,221) 9,258 9,258 5,970,109 336,621,722 550,410 4,499,881 6,520,519 341,121,603 117,773 2,464,320 31,397 31,397 (158,824) 5,241,349 $ 342,591,831 $ 5,050,291 $ 347,642,122 $ 2,582,093 $ 5,082,525 COUNTY OF WELD STATE OF COLORADO Governmental Funds Balance Sheet December 31, 2011 ASSETS Cash and cash equivalents Receivables (net of allowance for uncollectibles): Current property taxes Delinquent property taxes Accounts Special assessment Due from other County funds Due from other governments Inventories Other assets Total Assets LIABILITIES AND FUND BALANCES Liabilities: Accounts payable Accrued liabilities Other liabilities Due to other County funds Due to other governments Deferred revenue Unexpended grant revenue Total Liabilities Fund Balances: Nonspendable Restricted Committed Assigned Unassigned Total Fund Balances Total Liabilities and Fund Balances General Fund Public Works Fund Social Services Fund $ 24,374,374 $ 29,241,762 $ 3,566,428 56, 814, 505 104,445 646,091 2,065,858 86,903 177,037 510,202 7,064,539 14,014 1,006,459 43,333 957,688 2,303 $ 84,779,415 $ 38,330,098 2,168,790 1,662,281 2,057,343 57,084,349 691,812 63,664,575 687,239 6,000,000 1,927,404 1,808,529 10,691,668 665,050 334,238 22 7,138,262 10,100,718 14,725 339,558 13,251 1,076,175 2,181 $ 15,113,036 168,225 685,885 7,054 206,509 51,390 10,177,445 8,137,572 11,296,508 959,991 29,232,535 2,181 3,814,347 21,114,840 30,192,526 3,816,528 $ 84,779,415 $ 38,330,098 $ 15,113,036 See accompanying notes to the basic financial statements 30 Human Services Fund Contingent Fund Capital Expenditures Fund Other Governmental Funds Total Governmental Funds $ 887,102 $ 20,064,625 $ 12,085,439 $ 2,439,881 $ 92,659,611 Imo low 5,194 205,205 657,523 Imo Imo 8,083,827 10,176 mia mia mia aa aa 7,275,987 13,688 Mao Mao Ma 815,368 dml dml dml 1,394 89,339,576 157,048 2,812,670 43,333 2,284,314 1,820,601 1,134, 725 516,080 $ 1,755,024 $ 28,158,628 $ 19,375,114 $ 3,256,643 $ 190,767,958 93,740 147,741 13,251 159,092 413,824 1,341,200 low low 1,341,200 8,117,510 8,117,510 495,343 7,310,832 7,806,175 20,041,118 11,568,939 20,041,118 11,568,939 117,903 216,008 dmip 131,160 3,709,051 3,046,153 7,054 2,277,125 51,390 89, 959, 558 850,904 465,071 99,901,235 1,394 2,104,961 685,217 1,650,805 42,493,043 34, 222, 678 1,808,529 10,691,668 2,791,572 90,866,723 $ 1,755,024 $ 28,158,628 $ 19,375,114 $ 3,256,643 $ 190,767,958 COUNTY OF WELD STATE OF COLORADO Reconciliation of Total Governmental Fund Balances To Statement of Net Assets December 31, 2011 Total governmental fund balances $ 90,866,723 Amounts reported for governmental activities in the statement of activities are different because: Capital assets used in governmental activities are not financial resources and therefore are not reported in the funds 238,117,043 Long-term liabilities, including bonds payable and compensated absences, are not due and payable in the current period and therefore are not reported in the funds Compensated Absences Net Pension Obligation Net Other Post Employment Benefits Asset Internal service funds are used by mangement to charge the costs of insurance and other services to individual funds. The assets and liabilities of the internal service funds are included in governmental activities in the statement of net assets (3,270,360) (5,108,709) 1,685,635 20,601,584 Internal services used by Enterprise Fund (300,085) Net assets of governmental activities $342,591,831 See accompanying notes to the basic financial statements 33 COUNTY OF WELD STATE OF COLORADO Statement of Revenues, Expenditures and Changes in Fund Balance Governmental Funds Year Ended December 31, 2011 REVENUES: Taxes Licenses and permits Intergovernmental Fines and forfeitures Charges for services Miscellaneous Fees Total Revenues EXPENDITURES: Current: General government Public Safety Public Works Public health and welfare Culture and recreation Economic assistance Capital outlay Total Expenditures Excess of Revenues Over (Under) Expenditures Other Financing Sources (Uses): Transfers - in Transfers - out Total Other Financing Sources (Uses) Net Changes in Fund Balance Fund Balances at Beginning of Year Prior Period Adjustment (Footnote 1(D)) Beginning Balance Restated Fund Balance at End of Year General Fund $ 53,098,631 1,562,406 5,156,871 433,656 3,619,635 14,277,270 8,924,123 87,072,592 30,628,421 40,530,807 2,306,722 393,598 765,166 903,208 75,527,922 11,544,670 85,000 8,364,419 (8,279,419) 3,265,251 11, 849, 589 6,000,000 17, 849, 589 $ 21,114,840 Public Works Social Services Fund Fund $ 14,447,069 $ 9,154,904 530,910 - 10,157,306 19,084,866 586,636 410,258 16 460,062 26,592,241 28,239,786 28,527,426 47,158 27,102,288 28,574,584 27,102,288 (1,982,343) 1,137,498 7,100,000 7,100,000 5,117,657 25,074,869 25,074,869 1,137,498 2,679,030 2,679,030 $ 30,192,526 $ 3,816,528 See accompanying notes to the basic financial statements Human Services Fund $ 7,056,613 503,389 318,920 7,878,922 7,880,482 7,880,482 (1,560) 12,351 12,351 Contingent Fund $ 994,188 994,188 994,188 7,900,000 Capital Expenditures Fund $ 6,589,212 146,231 61,103 6,796,546 335,638 6,772,988 7,108,626 Other Governmental Funds $ 26,613 3,214,595 7,799 2,189,722 244,657 Total Governmental Funds $ 84, 310, 617 2,093,316 44,670,251 441,455 6,899,382 15,397,352 9,445,288 5,683,386 163,257,661 126,321 7,692,073 362,707 72,131 30, 964, 059 40,657,128 30,834,148 35,187,959 1,127,873 7,880,482 7,795,485 8,253,232 154,447,134 (312,080) (2,569,846) 5,500,000 (7,900,000) 5,500,000 10,791 (6,905,812) 1,330,409 26,946,930 5,187,920 6,381,019 1,330,409 26,946,930 6,381,019 3,109,977 592,909 8,810,527 15,807,328 16,857,328 2,517,068 (1,050,000) (52,778) 7,760,527 8,844,350 83,106,196 (6,000,000) 2,844,350 83,106,196 $ 1,341,200 $ 20,041,118 $ 11,568,939 $ 2,791,572 $ 90,866,723 COUNTY OF WELD STATE OF COLORADO Reconciliation of the Statement of Revenues, Expenditures, and Changes in Fund Balances of Governmental Funds to the Statement of Activities Year Ended December 31, 2011 Net changes in fund balances - total governmental funds $ 7,760,527 Amounts reported for governmental activities in the statement of activities are different because: Governmental funds report capital outlays as expenditures. However, in the statement of activities the cost of those assets is allocated over their estimated useful lives and reported as depreciation expense. This is the amount by which depreciation exceeded capital outlay in the current period. Capital asset additions Depreciation expense Excess of depreciation over capital outlay 16,516,856 (18,690,674) (2,173,818) Net effect of various transactions involving capital assets (i.e. sales, disposals) is a decrease to net assets (617,783) Some expenses reported in the Statement of Activities do not require the use of current financial resources and therefore are not reported as expenditures in governmental funds. Compensated absences Net Pension Obligation Net Other Post Employment Benefits Obligation Internal service funds are used by mangement to charge the costs of certain activities, such as insurance, telecommunications and fleet services, to individual funds. The net revenue (expense) of certain internal service funds is reported with governmental activities. Internal services used by Enterprise Funds (217,596) 263,188 528,326 412,747 14,518 Change in assets of governmental activities $ 5,970,109 See accompanying notes to the basic financial statements 36 COUNTY OF WELD STATE OF COLORADO Statement of Net Assets Proprietary Funds December 31, 2011 ASSETS Cash and short-term investments Property taxes receivable Receivables (net of allowance for uncollectibles): Accounts Due from other County funds Inventory Other assets Total Current Assets Capital Assets: Land Improvements other than buildings Construction in Progresss Buildings Machinery and equipment Accumulated depreciation Total Capital Assets Total Assets LIABILITIES AND FUND EQUITY Current Liabilities: Accounts payable Accrued liabilities Due to other County funds Deferred revenue Total Current Liabilities Total liabilities Net Assets Invested in capital assets Restricted for: Insurance Claims Unrestricted Total net assets Some amounts reported for business -type activities in the statement of net assets are different because certain internal service fund assets and liabilites are included with business -type activities. Net assets of business -type activities See accompanying notes to the basic financial statements Business -type Activity Paramedic Enterprise Fund $ 1,913,104 1,648,503 5,953 3,567,560 48,496 55,728 710,305 2,058,417 (1,348,798) 1,524,148 5,091,708 33,531 307,971 341,502 341,502 1,524,148 3,226,058 $ 4,750,206 300,085 $ 5,050,291 Governmental Activities Internal Service Funds $ 11, 780, 935 1,772,344 38,240 129,939 80,181 635,715 14,437,354 580,500 65,021 1,800,977 33,404,576 (21,602,929) 14,248,145 28,685,499 716,928 4,430,971 137,128 2,798,888 8,083,915 8,083,915 14,248,145 2,072,947 4,280,492 $ 20,601,584 37 COUNTY OF WELD STATE OF COLORADO Statement of Revenue, Expenses and Changes in Net Assets Proprietary Funds For the fiscal year ended December 31, 2011 Operating revenues: Employer & Employee Premiums Charges for services Total operating revenues Operating expenses: Personnel services Supplies Purchased services Insurance and bonds Depreciation Other Claims Total operating expenses Operating income (loss) Nonoperating revenues (expenses): Taxes Miscellaneous Interest income Fees State Grant Gain (loss) on disposition of assets Judgements and damages Total nonoperating revenues (expenses) Income (loss) before contributions or transfers Transfers - in Changes in net assets Total net assets beginning of year Total net assets at end of year Some amounts reported for business -type activities in the statement of activities are different because the net revenue (expense) of certain internal service funds is reported with business -type activities. Change in net assets of business -type activities 6,273,982 6,273,982 4,270,591 325,459 892,611 424,708 22,426 5,935,795 338,187 4,800 12,803 222,937 (13,799) 226,741 564,928 564,928 4,185,278 $4,750,206 (14,518) $ 550,410 See accompanying notes to the basic financial statements Business -type Activity Paramedic Enterprise Fund Governmental Activities Internal Service Funds - $ 13,119,007 9,473,678 22,592,685 161,492 2,779,262 4,354,868 563,806 3,006,173 105,724 14,658,202 25,629,527 (3,036,842) 1,499,661 113,961 49,766 665,157 71,044 2,399,589 (637,253) 1,050,000 412,747 20,188,837 $ 20,601,584 38 COUNTY OF WELD STATE OF COLORADO Statement of Cash Flows Proprietary Funds For the fiscal year ended December 31, 2011 CASH FLOWS FROM OPERATING ACTIVITIES Cash flows from external customers Cash flows from internal customers Cash payments to external suppliers for goods and services Cash payments to internal suppliers for goods and services Cash payments to employees for services Judgements/damages/losses Miscellaneous revenues Net cash provided by operating activities CASHFLOWS FROM NONCAPITAL FINANCING ACTIVITIES Taxes Transfers/Advances Grants Other Net cash provided by noncapital financing activities CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES Acquisition of capital assets Proceeds from sale of capital assets Net cash provided (used) for capital and related Financing activities CASH FLOWS FROM INVESTING ACTIVITIES Interest on investments Net Increase in Cash and Cash Equivalents Cash and Cash Equivalents at Beginning of Year Cash and Cash Equivalents at End of Year Reconciliation of operating income to net cash provided by operating activities: Operating income (loss) Adjustments to reconcile operating income to net cash provided by operating activities: Depreciation expense Judgements/damages/losses Miscellaneous revenue Change in assets and liabilities (Increase) decrease in accounts receivable (Increase) decrease in due from other funds (Increase) decrease in inventories (Increase) decrease in other assets Increase in accounts payable Increase in accrued liabilities Increase in other liabilities Increase in deferred revenue Total adjustments Net cash provided by operating activities Noncash investing, capital, and financing activities: Loss on Disposal of Asset See Accompanying notes to the basic financial statements Business -type Activity Enterprise Fund Paramedic Services Governmental Activites Internal Service Funds 6,204,534 (990,805) (580,254) (4,166,906) 466,569 222,937 17,603 240,540 (686,124) 29,083 (657,041) 379,862 22,158,852 (22,061,422) (216,068) (158,669) 71,044 113,961 287,560 1,497,791 1,050,000 2,547,791 (3,201,758) 597,737 (2,604,021) 51,636 50,068 282,966 1,863,036 11,497,969 1.913.104 338,187 424,708 (221,808) (255) (58,925) (13,635) (1,703) 128,382 466,569 30,881 (3,036,842) 3,006,173 71,044 113,961 (231,062) (105,890) 2,843 (314,624) (3,304) 407,596 137,077 240,588 3,324,402 287,560 19,126 COUNTY OF WELD STATE OF COLORADO Statement of Fiduciary Net Assets Fiduciary Funds December 31, 2011 Weld County Other Post Agency Weld County Employment Funds Retirement Plan Benefits ASSETS Cash and cash equivalents $ 6,984,028 $ Accounts Receivables (net of allowances for uncollectables): 12,341 Restricted assets Cash Common Stock US Property Fund Total assets LIABILITIES AND NET ASSETS Accounts payable Due to other governments Total Liabilities NET ASSETS Held in trust for pension benefits and other purposes 3,352 2,095,190 71,332,322 50,307,049 2,784,877 $ 6,996,369 $ 123,737,913 $ 2,784,877 $ 195,709 $ 31,201 $ 6,800,660 $ 6,996,369 $ 31,201 $ See accompanying notes to the basic financial statements $ 123,706,712 $ 2,784,877 COUNTY OF WELD STATE OF COLORADO Statement of Changes in Fiduciary Net Assets Fiduciary Funds For the fiscal year ended December 31, 2011 Weld County Other Post Retirement Employment Plan Benefits Additions: Employer contributions Employee contributions Earnings on investments Net depreciation in fair market value of investments Reimbursment of Prior Years Expeditures Total Additions Deductions: Actuarial/Trustee fees Benefit payments Supplies Total Deductions Change in net assets Net assets - beginning $ 4,906,758 4,906,758 4,127,865 (3,062,444) 1,801,221 12,680,158 321,933 10,940,001 37,096 11,299,030 $ 200,000 34,023 234,023 1,381,128 234,023 122,325,584 2,550,854 Net assets - ending $ 123,706,712 $ 2,784,877 See accompanying notes to the basic financial statements NOTES TO THE FINANCIAL STATEMENTS 42 COUNTY OF W1 d Count y STATE OF COLORADO Year Ended Decenber 31, 2011 Note 1 - Sunirury of Significant Accounting Policies: The County of Weld, Colorado ("County") was established in 1861, and on January 1, 1976, became a hone rule county under the pr ovi s i ons of Section 30- 35- 501, CRS, 1973. The County oper at es under an elected c ornri s s i oner form of government. The County provi des the ful 1 range of services cont empl at ed by statute or charter . These include general government funct i ons, public protection and safety, health, social services, human resource services, public improvements, road and bridge oper at i ons, pl anni ng and zoni ng, and general admi ni s t r at i ve s er vi ces. The financial stat ement s of the County have been prepared in conformity with generally accepted accounting principles ( GAAP) as applied t o government al units. The fol l owi ng suimliry of si gni fi cant accounting policies is presented to assist the reader in evaluating the Count y' s f i nanci al statements. A. Reporting Entity: W1 d County is a pol i t i cal subdivision of the State of Col or ado, governed by an elected five -neither Board of County Comii s s i oner s . There are also four of her elected officials of W1 d County (Assessor, Clerk and Recorder, District Attorney, and Sheriff). The acconpanyi ng fi nanci al s t at errant s present the government and i t s component units, entities for which the government is considered to be f i nanci ally accountable. Bl ended component units, alt hough 1 egal l y separate entities, are, i n substance, part of the government ' s operat i ons. Each discretely presented component unit is reported in a separate column in the gover nnent - wi de financial st at ement s ( see not e below for description) to emphasize that it is legally separate from the government . Discretely presented component units: The Wld County Housing Authority is responsible for assisting Wld County residents with housing assistance. The Board of County Commissioners appoints all of the five -member Housing Authority Board. The County has the ability to remove any of the appointed board namber s, they can modify deci sions ons made by the board and can hire or fire persons responsible for the day t o day operations. The W1 d County Housing Authority is governed by state regulations, but was designated as part of the County for budgetary and audit purposes by an act of the Colorado General Assembly in 1989. A complete set of financial st at ement s can be obtained at the entity's administrative offices: W1 d County Housing Authority 903 6t" Street Greeley, CO 80631 43 COUNTY OF W1 d Count y STATE OF COLORADO Year Ended December 31, 2011 The E911 Emergency Telephone Service Aut hor i t y Board was cr eat ed by intergovernmental agreements pursuant to Article 11 of Title 29, C.R.S., as amended, that authorizes the county, municipalities within the county, and special districts within the county to enter into an agreement for the purpose of providing 911 emergency telephone services. Per the state statute cited above, the agreement creates a separate legal entity which i s responsible for admi ni s t er i ng the oper at i ons of the 911 emergency t el ephone service program in Val d County. The authority board cons i s t s of seven members with four selected by the W1 d County Comm ssi oners, one member each is selected by the City of Greeley, City of Fort Lupton and W1 d County Sheriff . Under the by -1 aws of E911 Aut hor i t y, VC d County i s required to pay all operating costs. They are to maintain all accounts and have accounts audited. St ate statute requires t hat all funds be maintained by the W1d County Treasurer. The operation of the E911 authority is done contractual 1 y by the Wl d County Com rani cation Regi onal Cent er. There are no separate financial st at event s prepared for the E911 component uni t Because t hey pr ovi de s ervi ces t o or otherwise benefit d Count y, the f i nanci al s t at eimnt s of the f of 1 owi ng or gani zat i ons are bl ended into the County financial statements: W1 d County Retirement Plan - The Retirement Board consists of five members, two selected by participating enpl oyees, two appointed by t he Board of County Commissioners, and the fifth being the Count y Treasurer. The County funds half of the retirement pl an, whi ch covers subs ant i ally all permanent, ful 1 - tine enpl oyees of W1 d County. The operation of the plan is accounted for in the W1d County Retirement Fund, as a Pension Trust Fund. Complete Fi nanci al statements can be obtained at the Veld County Treasurer's Office: Veld County Treasurer's Office 1400 North 17th Avenue Greeley, CO 80631 V�1 d County Fi nance Corporation - The Mel d County Fi nance Corporation ("Corporation") was formed in 1987 as a not -for-profit corporation under section 501(c)( 4) of the Internal Revenue Code, and exists solely to acquire real estate and construct buildings for 1 ease to the County. The Board of County Comm s s i oners appoints the t hr ee- member Board of Directors of the Corporation, and approves all proj ects undertaken by the Corporation. The members of the Board of Direct ors are errpl oyees of the Count y. There are no s epar at e f i nanci al statements prepared for the Val d County Finance Corporation. 44 COUNTY OF W1 d Count y STATE OF COLORADO Year Ended December 31, 2011 The Law Enf or cement Authorities ( LEA) were i n accor dance wit h Section 30- 11- 401, CRS. The 1 aw enf or cement authorities are taxi ng units cr eat ed by the county t o pr ovi de additional law enf or cement services by the county sheriff to residents in developed unincorporated areas of the county. The governing board of the law enforcement authorities is the five Wld County Comrissioners. Law enforcement services to the authority are provided contractually by the county sheri ff. There are no separate financial statements prepared for the Law Enforcement Authorities. The Local I mpr overlent Districts (LID) have not been included in the County's financial statements individually, as they are iniraterial, but are included as a blended corrponent unit of Public Vorks, a special revenue fund. The Board of County Comni s si oner s can create these assessment districts to construct or rehabilitate and finance public streets, storm drainage, water systems, sanitary sewer, or street lighting. The Primary purpose of an LID is to assess the costs of public improvements to those who are specially benefited by t he improvement . The LID exists only as geographic area wi t hi n which i rrproverlent s are constructed and as an admi ni strati ve subdivision of the county. Having no board of directors, they do not operate i n any capacity as an independent government al entity. The county governing board, Board of County Commissioners, makes all decisions on behalf of this admi ni s t rat i ve entity. There are no separate financial s t at event s prepared for the Local I mpr ovenent Districts. The f of 1 owi ng r el at ed or gani zat i ons are excluded from the acconpanyi ng financial statements because the Count y' s account ability for these or gani zat i ons does not extend beyond various appointments. North Color ado 1Vtdi cal Cent er - The Board of County Commissioner s owns land underlying the main facility of the 1Vhdi cal Center, which land is currently leased to the Colorado Hospital Finance Authority as part of the security for financing the bonded indebtedness of the 1Vhdi cal Center. The indebtedness is not an obligation of the Board of County Comni s s i oner s and no taxpayer funds or Board of County Conmi s s i oner s funds are obl i gated to pay any portion of the principal, pr eni um or interest on the Bonds. The land i s leased back from the Authority to the Board of Trustees, a seven nenber Hospital Board of Trustees appointed by the Board of Count y Commissioners. The Hospital Board of Trustees has entered into an operating sublease of the ground and facilities with NClC, Inc., a 501(c) (3) ent i t y, with three of its members also serving on the Board of Trustees, whi ch, i n t urn, has cont r acted with Banner Heal t h Systems to operate the Adi cal Center . NCNC has the ability to i ncur its own debt and its oper at i ons are financed totally by patient revenues . COUNTY OF W1 d Count y STATE OF COLORADO Year Ended Decenber 31, 2011 Greeley-Wld Airport Authority - The County Comrissioners appoint two of the five Airport Authority Board nenbers. . The County has contributed appr oxi nat el y 5% of the funds for capital construction. The Authority has full aut onony under Color ado State 1 aw, can incur debt , and funds its operations tot ally from user fees. Veld Library District - The County Conmi s s i oner s, t oget her with the concurrence of the city counci 1 s of seven part i ci pat i ng mini ci pal i ties, appoint the s even- member Li brary y District Board. The Library District Board has total aut onony under the St at e Library Act t o incur debt , establish budgets, and 1 evy pr oper t y taxes to support the District's library system Col or ado Counties Casualty and Property Pool ( her ei naf t er referred to as "CAPP") CAPP was formed July 1, 1986, by an i nt er gover nimnt al agreement by rnenber counties as a separate and independent government al and 1 egal entity pursuant t o the provisions of Art i cl e XI V, Section 18(2) of the Colorado Constitution and Section 29-1-201 et seq, 24- 10- 115. 5, and 29-13-102, CRS, as amended. Each member county in this i nt er government al agr eement has the power under Col or ado 1 aw t o make provision for the pr oper t y and casual t y coverage which constitute the functions and services joint 1 y provided by means of the CAPP. The Insurance Conmi s s i oner of the State of Colorado has such authority with respect to the CAPP as is provided by applicable Colorado statutes . The purposes of the CAPP are to provide a risk management fund for defined property and casualty coverage and to assist members in control 1 i ng costs by provi di ng speci al i zed governmental risk management services and syst t ems. It is the intent of the 'withers to use nenber contributions to defend and i ndermi fy, in accordance with the byl aws, any member against states liability or loss to the limit of the financial resources of the risk management fund. It is also the intent of the member s to have CAPP provide needed cover age at r eas onabl e costs. All income and assets of CAPP shall be at all tines dedicated to the exclusive benefit of its members. Vhld County, through its I nsur ance Internal Service Fund, recognizes an expense for the amount paid t o CAPP annual 1 y for these coverages. Val d County is a charter neither of CAPP and has been a continuous neither since July 1, 1986. COUNTY OF \M 1 d Count y STATE OF COLORADO Year Ended Decenber 31, 2011 B. Government -wide Financial Statements: The Count y' s basic financial s t at errent s consist of gover fluent - wi de statements, i ncl udi ng a statement of net assets and a s at event of activities, and fund financial statements which pr ovi de a nmr a detailed level of financial i of or mat ion. The government - wide focus is more on the sus ai nabi l i t y of the County as an entity and the change in aggregate financial position resulting from activities of the fiscal period. The statement of net assets and the statement of activities display i of or mat ion about the county as a whole. In the gover nment - wi de st at event of net assets, both the government al and business - type activities columns are presented on a consolidated basis by col urm. These statements include the financial activities of the pr i nary government , except for fiduciary activities. For the rmst part, the e ffect of i nt er fund activity has been renoved from these st at event s. Governmental activities, whi ch normally are supported by taxes and i nt er gover nment al revenues , are reported s epar at el y from business -type activities, which rely to a significant extent on fees and charges for support . The government -wi de st at event of activities reflects both the direct e xpenses and net cost of each function of the County's government al activities and bus i nes s-1 i ke activity. Direct expenses are those that are clearly identifiable with a specific function. Program revenues include charges paid by the recipient for the goods or services offered by the program Direct expenses and program revenues resulting from interfund activity are treated as such in the participating funds and are not el i rni nat ed as part of the consol i dat i on process . Gant s and cont r i but i ons t hat are r es t r i ct ed t o meet i ng the operational or capital ✓ equi r enEnt s of a part i cular program and interest earned on grants that is required to be used to support a particular program are included in operating gr ants and cont r i but i ons , or capital grants and cont r i but i ons . Revenues which are not classified as program revenues are presented as general revenues of the County, with certain limited exceptions. The compar i son of direct expenses with program revenues i dent i f i es the ext ent to whi ch each government function or busi ness segment is sel f -financing or draws from the general revenues of the County. Fund Financial Statements The financial trans act i ons of the County are recorded i n i ndi vi dual funds. A fund is defined as a fiscal and accounting entity with a sel f- bal anc i ng set of accounts that comprise its assets, liabilities, fund e quity, revenues, and expenditures or expenses, as appropriate. Separate statements for each fund cat egor y - governmental, proprietary, and fiduciary - are presented. The enphasi s of fund financial stat at ement s is on naj or government al and enterprise funds, each displayed in a separate col urm. All remaining governmental and enterprise funds are aggregated and presented as non- rraj or funds. COUNTY OF W1 d Count y STATE OF COLORADO Year Ended December 31, 2011 Proprietary funds distinguish operating revenues and expenses from nonoperating i t errs. Operating revenues and expenses generally resul t from providing services and producing and delivering goods in connection with a proprietary fund's principal ongoing operations. The pr i nci pal operating revenues of the Par arredi c enterprise fund and of the government's internal service funds are charges t o customers for sales and services. Operat i ng expenses for enterprise funds and internal service funds include the cost of sales and services, administrative e xpenses, and depreciation on capital assets. All revenues and expenses not meeting this definition are reported as nonoperating revenues and e xpenses. C. Measurement Focus Government -wide, Proprietary and Fiduciary Fund Financial Statements The government - wide financial statements are reported using the economic resources measurement focus and the accrual basis of account i ng, as are t he proprietary fund and fiduciary fund statements. Revenues are ✓ ecorded when earned and expenses are recorded at the time l i abi l i t i es are incurred, regardless of when the related cash flows take place. Nonexchange transactions, in which the County gives (or receives) value without direct 1 y receiving ( or gi vi ng) equal value i n exchange, include property t axes, grants, and donations . Revenues from property t axes ar e ✓ ecognized in the fiscal year for which the taxes are levied. Revenue from grants and donations is recognized in the fiscal year in which all e ligibility r equi r enrnt s have been satisfied. Under the terms of grant agreements, the County funds certain program by a combi nation of specific cost -rei mbursement grants, cat egori cal block grants, and general revenues. Thus, when program expenses are incurred, t here are both restricted and unrestricted net assets available t o finance the program It is the County's policy to first apply cost - reimbursernent grant resources to such program, followed by categorical block grants, and then by general revenues. Government al fund financial st at errent s are reported using the current financial resources measurement focus and the rmdi fi ed accrual basis of account i ng. Revenues are recognized as soon as they are both measur able and avai 1 abl e. Revenues are cons i der ed to be available when they are collectible within the current period or soon enough t hereafter t o pay liabilities of the current period. For this purpose, the government considers revenues to be available if they are collected within 60 days of the end of the current fiscal per i od. Expenditures generally ar e recorded when a liability is incurred, as under accrual accounting. However expenditures related t o corrpens at ed absences and claim and j udgnent s, are recorded only when payment i s due. COUNTY OF W1 d Count y STATE OF COLORADO Year Ended December 31, 2011 Property taxes, licenses, and interest associated with the current fiscal period are all considered to be susceptible to accrual and so have been recognized as revenues of the current fiscal period. Only the portion of special assessments receivable due within the current fiscal period is considered to be susceptible to accrual as revenue of the current period. All other revenue i t erns are considered t o be measurable and avai l abl e only when cash i s received by the government. All governmental and business -type activities and enterprise funds of the County f of 1 ow only FASB Statements and I nt erpr et at i ons issued on or before, not after , November 30, 1989, Accounting Pr i nci pl es Board Opi ni ons, and Accounting Res ear ch Bulletins, unless t hose pronouncement s conflict with GASB pronouncements . The County reports the f of 1 owi ng rraj or governmental funds : The General Fund is the general operating fund of the County which accounts for all financial resources that are not accounted for in of her funds. Oper at i ons of the County such as public safety, pl anni ng and zoni ng, property valuation, tax collect i on and distribution, vehicle licensing, County admi ni s t rat i on, and of her activities financed from taxes and general revenues are reflected i n t his fund. The Public Works Fund records costs related to County road and bridge construction and maintenance except for engineering, which is recorded in the General Fund. By State law, Colorado counties are required to maintain a Road and Bridge Fund and a portion of road and bridge taxes is allocated to cities and towns for use in their road and street activities. The Social Services Fund admi ni st ers human services programs under state and federal r egul at i ons . Pr ogr arras include, but are not limited to, 1Vbdi cai d, Food St amps, Foster Care programs, and Temporary Assistance to Needy Fanilies (TANF). Colorado counties are required by state law to maintain a Social Servi ces Fund. The Human Services Fund primary pr ogr arcs are associated with the V�br kf or ce Investment Act (WA) funded under the Depar t rent of Labor, Employment and Training Administration. The Contingent Fund records any property tax revenue levied by the Board of County Commissioners to cover reasonably unforeseen expendi t ur es. The Capital Expenditures Fund accounts for all the Count y' s construction projects. The County chooses to use the pay as you go plan instead of debt . Property t axes are used t o fund the Law Enforcement Center and the expansi on of the Detention Center. COUNTY OF \M 1 d Count y STATE OF COLORADO Year Ended December 31, 2011 The County reports the f of 1 owi ng enterprise fund: The Paramedic Fund operates the par antdi c services for the County, which is primarily funded by revenues for services rendered. The County also reports the following fund types: The Internal Service Funds account for the financing of goods or services provided by one department or agency to other department s or agencies of the County on a cost r ei mbur sement basis . The County's internal service funds report on self - i nsur ance programs for errpl oyee health, dent al and vision benefits, risk nanagerrent , unemployment, fleet services, teleconminications and acquisitions of ✓ eal estate and construction of buildings used by Count y depart rnent s. Services pr ovi ded and used by internal services funds are not e ntirely el i mi nat ed from the gover nment - wi de st at errent of activities . The primary government program expenses and expenses for the business -type activities on the government -wi de statement of activities are decreased t o el i mi nat a revenue over expenditures i n service funds where revenues exceed expenditures and increased to e liminate internal service funds that have expenditures in excess of ✓ evenues. The Agency Funds account for assets held by the County as an agent for indivi vi duals, private or gani zations ons and other governments. These funds are cust odi al in nature (assets equal liabilities) and do not i nvol ve neasur ement of results of operations. The County has funds hel d for of her 1 ocal gover nnant al units, empl oyee/ empl oyer payr of taxes, a Section 125 plan, and the Wl d County Federal M ner al Lease District. The Fiduciary Trust Funds account for the activities of the W1 d County Retirement PI an and the Weld County Ot her Post Empl oyment Benefit P1 ans. These funds accumul ate resources for pension benefit , and of her post empl oyrnent benefit payments t o qualified county empl oyees. The Plans use the accrual basis of accounting. Enpl oyee and empl oyer cont r i but i ons are r ecogni zed as revenues i n the period in which the cont r i but i ons are due. Benefits and refunds are recognized when due and payable in accordance with terns of the Plan. 50 COUNTY OF \M 1 d Count y STATE OF COLORADO Year Ended December 31, 2011 D. Assets, liabilities, and net assets or equity 1. Deposits and investments The W1 d County Treasurer maintains a cash and investment pool t hat i s available for use by all County funds except for some agency funds. Each fund's portion of this pool is displayed as "cash and cash equivalents". Accrued interest recei vabl e is displayed s epar at el y. The armunt of interest gained through secured investments is credited to the County's General Fund per Col or ado St ate St at ut es, with the exception of the Cons er vat i on Trust , Capital Expenditures Fund, Li ability Insurance Fund and E- 911 Authority. "Cash and cash equivalents" for the General Fund Cons er vat i on Trust , Capital Expenditures Fund, Liability Insurance Fund and E- 911 Authority are stated at fair value. Any bank accounts not maintained by the Treasurer are displayed as "Restricted Assets" within the appropri i ate fund and are stated at cost. The County consi der s cash and cash equivalents in proprietary funds to be cash on hand and demand deposits. In addition, because the treasury pool is sufficiently liquid to permit withdrawal of cash at any tine without prior notice or penalty, equity in the pool is also deemed to be a cash equivalent. For the purpose of cash flows, cash and cash equivalents are determined by original maturity of three rmnt hs . Investments are reported at fair values using quoted market prices . 2. Property Taxes: Property t axes attach as an enforceable lien on property as of January 1. Taxes were levied on Decenber 21, 2011, and are payable either in two i ns t al 1 Went s due on February 29 and June 15 or in full on April 30. The bill becomes delinquent on Mir ch 1, My 1, and June 16 and penalties and interest nay be assessed by the County. The County, through the Wld County Treasurer, bills and collects its own property taxes, as well as property taxes of al 1 other taxing authorities within the County. In accordance with Section 14-7 of the Weld County Hone Rule Charter, all ad val or em tax 1 evi es for County purposes, when applied t o the tot al valuation for assessment of the County, shal 1 be reduced so as t o prohibit the levying of a greater armunt of tax revenue than was levied from ad val or em taxation i n the preceding year plus five percent (5°4, except to provide for the payment of bonds and interest. The Board of County Conti s s i oner s nay submit the question of an increased levy to the County Council and, if in the opinion of a maj or i t y of the County Counci 1 nay grant an increased levy for the County in such armunt as it deems appropriate, and the County is aut hor i zed t o rake such increased l evy. Any one capital project requiring a capital expendi t ur e out of funds procured by ad valorem taxation equal to a three Ili I I levy for three years, s hal 1 be prohibited unless approved by a maj or i t y vote of the qualified electors at a general or special election per Section 14-8 of t he W1 d County Hone Rule Charter . 51 COUNTY OF W1 d Count y STATE OF COLORADO Year Ended Decenber 31, 2011 3. Interfund Transactions Transact i ons between funds t hat woul d be treated as revenues, expenditures, or expenses if they involved organizations ext er nal to the County are accounted for as revenues, expenditures, or expenses in the funds involved. Transactions whi ch constitute reimbursement s of a fund for expenditures or expenses initially made from t hat fund milli ch ar e proper 1 y applicable t o anot her fund are recorded as expenditures or e xpenses in the reimbursing fund and as reductions of the expenditure or e xpense in the fund that is r ei nbur s ed. At year end, out s t andi ng bal ances bet wen funds are reported as "due t o/ from other funds". Interfund balances are generally expected to be repaid within one year of t he fi nanci al statement date. Any r esi dual bal ances out st andi ng between the gover nnent al activities and business- type activities are reported in t he government - wi de f i nanci al statements as "internal bal ances" . 4. Inventories and Prepaid Items Invent ones of government al funds, whi ch consist of expendable nat er i al s held for consumption, are stated at cost ut i 1 i zi ng the wei ght ed aver age cost net hod. These funds fol 1 ow the consumption net hod of accounting whereby expenditures are recorded at the t i ne the inventory item ar e used. Inventories of proprietary funds are recorded at average cost. Certain payments t o vendors reflect cost applicable t o fut ure accounting per i ods and are recorded as prepai d i tens i n both government - wi de and fund financial statements. 5. Capital Assets Capital assets, whi ch include property, pl ant , equi pment , i nt angi bl e assets (computer software and right of ways for land use), and infrastructure assets (e.g., roads, bridges and similar items), are reported i n the applicable government al or business - type activities col urns i n the government -wi de fi nanci al s at ement s. Capital assets are defined by the County as assets with an initial, individual cost of more than $5, 000 and a useful life of Imr a than one year. Al 1 capital assets are valued at hi st on cal cost or est i oat ed hi st on cal cost i f actual hist on cal cost is not available. Donat ed capital assets are recorded at e s t i mated fair market value at the date of donation. The costs of normal mai ntenance and repairs that do not add to the value of the asset or materially ext end assets' 1 i ves are not capi t al i zed. 52 COUNTY OF W1 d Count y STATE OF COLORADO Year Ended December 31, 2011 Al 1 reported capital assets, except for gravel roads and i nt angi bl e assets are depreci at ed. Improvements are depreciated over the remaining useful lives of the related capital assets . Depreciation on all asset s i s provided on the st r ai ght -1 i ne basis over the f of 1 owi ng es t i mat ed useful lives: Bui 1 di ngs I rrpr ovement s Infrastructure Infrastructure Equi prnent Heavy Equi pment - Bridges - Roads 20- 50 year s 20 years 50 years 20 years 3-5 years 10- 20 year s St at ement 34 allows an alternative approach whi ch would reflect a reasonable value of the asset and the cost incurred t o rrai nt ai n the service pot ent i al to locally established mini mum standards in lieu of depreciation. To elect this option, the County mist devel op and i irpl ernent an asset management syst em whi ch measures, at least every third year by class of asset , i f the ni ni rnim standards are being mai nt ai ned. Related disclosures are additionally required as part of the Required Supplement ar y I of or mat i on. The County has elected t o use the alternative approach only for gravel roads. 6. Compensated Absences County errpl oyees accunul ate sick leave and vacation benefits at rates of 8 hours per rmnt h and 8 to 16 hours per 'milt h, respectively, depending on 1 engt h of service. In the event of retirement or t er ni nation, an e npl oyee is paid 100% of accunul at ed vacat i on pay. An errpl oyee whose date of hire is prior to January 1, 1985, is paid for 50% of accunul at ed sick 1 eave hours up t o the equi val ent of one rmnt h; i f the enpl oyees date of hire is after January 1, 1985, no sick leave is paid upon ✓ etirement or t er mi nation. Up to 320 hours of annual vacation nay be carried over from one year to the next. Compensatory tine is gr anted (except for official, professional, and administrative positions) at the ✓ ate of one and one- half hours for each over t i me hour worked, not to be accunul at ed i n excess of forty hours. The unpaid sick leave, vacation pay and related benefits at the end of t he period wi l l generally not be paid with expendable and avai 1 abl e resources. Proprietary funds accrue sick leave, vacation pay and related benefits in the period they are earned by the employees. The entire compensated absence liability is reported on the gover nnent - wi de financial st at events. Expenditures and liabilities for compensated absences are reported on the gover nnent fund st at events only when the liability for the conpens at ed absences becomes due. 7. Long-term obligations I n the government - wi de financial statement s and pr opr i et ary fund types i n t he fund f i nanci al st at ement s, 1 ong- term debt and of her 1 ong- ter m obligations are reported as liabilities in the applicable gover nnent al activities, business - type activities, or proprietary fund type statement of net assets. COUNTY OF W1 d Count y STATE OF COLORADO Year Ended December 31, 2011 8. Fund Equity The Cover nrrient al Accounting Standards Board ( GASB) has issued Statement No. 54, Fund Balance Reporting and Governmental Fund Type Definitions (GASB 54) . As prescribed by GASB Statement 54 governmental funds report fund balance in classifications based primarily on the extent to which the County is bound to honor constraints on the specific purposes for which amounts in the funds can be spent. As of December 31, 2011, fund balances for governmental funds are c ompr i sed of the f of 1 owing: 1.Nonspendable fund balance includes armunts that are (a) not in spendable form or (b) 1 egal 1 y or cont r actual 1 y required t o be nai nt ai ned i nt act . The "not in spendable forth' criteria include items that are not expected to be converted to cash, for example such as fund balance associated with i nvent on es, prepai d armunt s, 1 ong-term 1 oans and notes recei vabl e, and property held for resale (unless the proceeds are restricted, committed, or assigned) . 2.Restricted fund balance category includes armunts that can be spent only for the specific purposes stipulated by constitution, external resource providers, or through enabling legislation. Restrictions may effectively be changed or lifted only with consent of resource providers. 3.Committed tied fund balance includes armunt s that can be used only for the specific purposes determined by a formal action of the Board of County Commissioners , the Count y' s highest level of decision- nuki ng authority. Commitments may be changed or lifted only by the County taking the sane for nal action that imposed the constraint or i gi nal 1 y. 4.Assigned fund bal ance comprises armunts i nt ended t o be used by the County for specific purposes that are neither restricted or committed. Intent is expressed by (1) the Board of County Commissioners or (2) an official (Director of Finance and Administration) to which the Board of County Conti s s i oner s has delegated the authority to assign armunts to be used by the County for specific purposes but do not meet the criteria to be classified as restricted or comritted, and 5. Unassigned fund bal ance i s the r esi dual classification for the government's General Fund and includes all spendabl e armunt s not cont ai ned i n the of her classifications. Unassigned armunt s are t echni cal l y avai l abl e for any purpose. Order of Fund Balance Spending Policy The County's policy is to utilize funds in the following order: restricted fund bal ance, committed fund bal ance, assigned fund bal ance, and unassigned fund bal ance. 54 COUNTY OF W1 d Count y STATE OF COLORADO Year Ended Decenber 31, 2011 The Board of County Comri s s i oner s adopted the County Fund Bal ance Policy on Decenber 14, 2011, nunc pro t unc January 1, 2011. The policy was created to help reduce the negative impact on the County in times of economic uncertainty, rraj or fluctuations in oil and gas assessed val uat i ons, and potential losses of funding from of her government al agencies. The policy est abl i shed mi ni num requirements for reserves and guidelines for the use of certain funds. The reserves and restrictions are also consistent with the requirements under Col or ado statute or st at e tcons t i tut i onal r equi r errent s. The County Fund Bal ance Policy requires the f of 1 owi ng: Any rennining fund balance following all restrictions and comrit rent s in the Health Fund shall be assigned for the purpose of future health programs for the benefit of the citizens of Weld Count y. 4 My r emai ni ng fund bal ance f of l owi ng all r es t r i ct i ons and commitments in the Social Services Fund shall be assigned for the purpose of fut ur a welfare pr ogr ams for the benefit of the citizens of Weld County. 4 Any rennining fund balance following all restrictions and comrit rnent s in the Hunan Services Fund shall be assigned for the purpose of future welfare, s eni or, and errpl oyment pr ogr offs for t he benefit of the citizens of Wl d County. 4 The Contingency Fund shall nai nt ai n a mini mum fund bal ance t o cover a ni ni rim ten ( 10) per cent of the annual expenditures and maximum of twenty (20) percent of the annual total expenditures as determined by the Director of Finance and Administration to provide: (1) a reasonable level of assurance that Meld County's oper at i ons wi l l continue even i f circumstances occur wher e revenues are insufficient in an ammunt that is equal to at least one- per cent of annual expenditures t o cover necessary expenses for public safety, public welfare and public works; (2) there is a naj or reduction i n of 1 and gas assessed val uat i ons; or (3) there are other unexpected needs or errer gency situations costing an ammunt that is equal to at least one -per cent of annual total expenditures t hat do not r out i nel y occur . The Contingency Fund shall be funded by property tax with a half - n i 11 applied to the county's assessed value annually, unless the Board of Wl d County Commissioners adj us t s the amount i n the annual budget process. The three- percent TABOR emergency reserve required by Article X, Section 20(5) of the Colorado Constitution shall be a restricted fund bal ance in the General Fund in an aimunt equal to s i x- mi 1 1 i on dollars or three- per cent of the TABOR revenue l i mi t , whichever i s greater. 55 COUNTY OF WELD STATE OF COLORADO Year Ended December 31, 2011 Fund bal ances for all ma or and non- maj or government al funds as of December 31, 2011, are distributed as follows: Nonspendabl e Invent or y Prepaid Expenses Total Nonspendabl e Restricted for Public Works Health Social Servi ces Human Servi ces TABOR Reserve Ot her Purposes Tot al Restricted Committed to Capital Pr of ect s Solid VMst a Disposal General Cont i ngenci es Econoni c Devel opment Total Co mrit me nt s Ass gned Appr opr i at ions in budget General Government Tot al Assigned Unassi gned Tot al Fund Balance Gener al 177, 037 510, 202 687, 239 6, 000, 000 6, 000, 000 1, 927, 404 1, 927, 404 474, 715 1, 333, 814 1, 808, 529 10, 691, 668 21, 114, 840 Publ i c V•ir ks 957, 688 2, 303 959, 991 29, 232, 535 Soci al Servi ces 2, 181 2, 181 3, 814, 347 29, 232, 535 3, 814, 347 30, 192, 526 3, 816, 528 COUNTY OF WELD STATE OF COLORADO Year Ended December 31, 2011 Human Servi ces 1, 341, 200 Cont i ngent Capital Expenditures Non lye j or Tot al 1, 394 1, 134, 725 516, 080 1, 394 1, 650, 805 - 29, 232, 535 1, 815, 592 1, 815, 592 3, 814, 347 1, 341, 200 6, 000, 000 289, 369 289, 369 1, 341, 200 2, 104, 961 42, 493, 043 20, 041, 118 11, 568, 939 685, 217 11, 568, 939 685, 217 20, 041, 118 1, 927, 404 20, 041, 118 11, 568, 939 685, 217 34, 222, 678 474, 715 1, 333, 814 1, 808, 529 10, 691, 668 1, 341, 200 20, 041, 1 18 1 1, 568, 939 2, 791, 572 90, 866, 723 COUNTY OF W1 d Count y STATE OF COLORADO Year Ended Decerrber 31, 2011 Encumbrances The county uses encunbr ances t o control expenditure comri t rents and e nhance cash management. Encumbrances reflect the outstanding contractual obl i gat ions for whi ch goods and services have not been received. They are set up t o reserve portions of applicable appropriations . Encumbrances still open at year end are not accounted for as expenditures or l i abi l i t i es, but as a constraint imposed on fund balance. As of December 31, 2011, the count y' s General Fund has a tot al of $474, 715 i n e ncumbrances, which were reported as part of the assigned fund balance on the government al fund balance sheet. Encumbrance balances by maj or funds and non -major funds as of December 31, 2011 are: General Fund $ Public Wrks Capital Restricted Connitted - $ 319, 865 Total 319, 865 1, 925, 965 1, 925, 965 Assigned Total $ 474, 715 $ 474, 715 319, 865 1, 925, 965 474, 715 2, 720, 545 Prior Period Adjustment The prior period adjustment to reclassify the $6, 000, 000 fund balance in the Emergency Reserve fund to General fund was a necessary adjustment t o comply with the requirements of GASB 54. 9. Net Assets Net assets represent the difference between assets and liabilities. Net assets invested i n capital assets, net of related debt consists of capital assets, net of accumulated depr eci at i on, reduced by the out st andi ng bal ances of any borrowing used for the acquisition construction of improvements of those assets. Net assets are reported as ✓ estricted when there are limitations imposed on their use either through t he enabling 1 egi s 1 at i on adopted by the County or through external ✓ estrictions imposed by creditors, grantors, laws or regulations of other government s. The County first applies restricted resources when an expense is incurred for purposes for which both restricted and unrestricted net assets are available. 10. Estimates The pr epar at i on of financial s t at erent s in conformity with gener ally accepted accounting principles requires management t o make est i mat es and assumptions that affect the armunt s reported i n the financial statement s and accompanying notes. Actual results may differ from those esti mates. 58 COUNTY OF \M 1 d Count y STATE OF COLORADO Year Ended December 31, 2011 Note 2 - Stewards hip, Compliance, and Accountability A. Budgetary information An annual budget and appropriation ordinance is adopted by the Board of County Corrmi s s i oner s in accordance with the Colorado State Budget Act and W1 d County Home Rule Charter . The budget i s prepared on a bas i s consistent with generally accepted accounting principles. Budgets ar e e st abl i shed for all Cover nnent al funds, Internal Service funds and the Enterprise Fund. The accounting syst em i s enpl oyed as a budget ary management cont r of device during the year t o rmni t or the i ndi vi dual departments. The fund level is the level of classification at which e xpenditures nay not 1 egal 1 y exceed appr opr i at i ons, except for the General Fund where the depar t trent 1 evel of expenditures cannot 1 egal 1 y e xceed appr opr i at i ons. During the year, several supplement al appr opr i at i ons were necessary. Al l annual appr opr i at i ons 1 apse at year e nd. The Director of Finance and Administration is authorized to transfer budgeted armunts within departments of each fund. Any r evi si ons t hat alter the total appr opr i at i on for a fund or for any General Fund department mist be approved by the County Commissioners through a supplement al appropriation or di nance. During 2011, two suppl ernent al appr opr i at i on ordinances were enact ed. Budget armunt s reported i n the acconpanyi ng financial st at errent s reflect these suppl ement al appr opr i at i ons. B. Excess of expenditures over appropriations Excesses of expenditures over appropriations in General Fund departments can be seen i n the expenditures section of the Schedule of Revenues, Expenditures and Changes in Fund Bal ance - Budget and Actual . Solid Vas t e Fund (Special Revenue Fund) had excess of expenditures over appropriations. These can be seen on the Schedule of Revenue, Expenditure and Changes in Fund Balance - Budget and Actual. Expenditures exceeded appr opr i at i ons i n the Law Enforcement Authority funds (Special Revenue) . The excess expenditures in the law enfor cement funds were a result of excess funds being available at the end of the year. The purpose of the law enfor cement authorities is to collect taxes to fund law enforcement services in unincorporated parts of Meld County and any excess funds can be used to offset the cost of law enforcement. Expenditures exceeded appropriations in the Nbt or Vehicle Fund (Internal Service Fund) . The excess expenditures can be attributed to increases in depreciation as well as increases in the cost of services and supplies, speci fi cal 1 y fuel . 59 COUNTY OF W1 d Count y STATE OF COLORADO Year Ended December 31, 2011 Expenditures exceeded appropriations i n the Insurance Fund ( I nt ernal Service). Insurance claims for 2011 were higher than expected causing expenditures t o exceed appropriations . Note 3 - Equity in Pooled Cash and Investments: A. Cash and Investments Cash and investments held by the Treasurer's office at December 31, 2011 as reported by the financial institutions, consisted of the f of 1 owi ng: Deposits $ 37, 464, 117 Investments: FILM 35, 000, 000 FNtVIk 51, 000, 000 86, 000, 000 Tot al $123, 464, 117 Cash and investments held by the Treasurer's office at December 31, 2011, excl udi ng out st andi ng war ant s, reported i n government -wi de and agency funds consisted of the following: Government - wi de Agency funds Total B. Deposits $107, 820, 056 13, 320, 358 $121, 140, 414 The Colorado Public Deposit Protection Act (PDPA) requires that all 1 ocal governments deposit cash in eligible public depositories. Eligibility is det ermi ned by state regul at i ons. The State regul at or comii ssi oners regulate the eligible public depositories. Amnunt s on deposit in excess of federal insurance levels must be col 1 at er al i zed by eligible col 1 at er al as det ermi ned by the PDPA PDPA allows the financial institutions t o create a single collateral pool for all public funds held. The pool is to be maintained by anot her institution, or held in trust for all the uni nsured public deposits as a group. The market value of the col l at eral must be at least equal to 102% of the uninsured deposits. At December 31, 2011, the County had deposits of $37, 464, 117 col 1 at er al i zed wit h securities held by the f i nanci al institutions' agents but not i n the County name. 60 COUNTY OF W1 d Count y STATE OF COLORADO Year Ended December 31, 2011 C. Investments The County is required to comply with State statutes whi ch specify investment instruntnts meeting defined rating, maturity, custodial and concentration risk criteria in which local governwents nay invest i ncl udi ng: Cbl i gat i ons of the United States and certain U. S. Agency securities Certain international agency securities General obl i gat i on and revenue bonds of U S. 1 ocal government entities Banker's acceptance of certain banks Conner ci al paper Witten repurchase agreewent s collateralized by certain authorized securities Certain money market funds Guar ant eed investment contract s Nbney Nkr ket Funds i n Bank Account The County has no provisions in its investment policy that would further limit invest rnent choices . At December 31, 2011, the County had the following invest rants: Investment Nhturities (in Years) 1 or less $ 0 1 - 3 yrs. 0 3 — 5 yrs. 86,000,000 $ 86, 000, 000 Nbney Wkr ket $ 37, 464, 117 Total $123, 464, 117 D. Credit Risk State statutes limit investments in U S. Agency securities to the highest rating issued by nationally recognized statistical rating organizations ( NRSRc) . At December 31, 2011, the County investments in the Federal Hone Loan Nbr t gage and Federal National Nbr t gage Association were rated AAA by Standard & Poor' s . Nbney Mr ket Funds were managed by VM1 1 s Fargo Bank i n accor dance with state regul at i ons pl edged at 102% Government Guar ant eed Bonds and are AAA rated. E. Concentration of Credit Risk State statute does not 1 i ni t the amount the County may invest in one issuer . At December 31, 2011, the County's invest went s i n Federal National Nbr t gage Association and Federal Hone Loan Nbr t gage represented 59% and 41°/9 respectively of the County's total investments. 61 COUNTY OF W1 d Count y STATE OF COLORADO Year Ended December 31, 2011 F. Interest Rate Risk State St at ut es unit the maxi mum maturity date unl es s an exception is made by the county commissioners, which does not exist at the present tine, to five years. The average duration in the portfolio on Dec ember 31, 2011 was 4. 6 years. This factor combined with the hi gh quality credit risk of the portfolio limit interest rate risk to a very small percentage of the portfolio. In fact , at year end the average mar k- t o -the -market was within one percent of the county's basis . G. Money Market Funds in Bank Account The County had $20, 380, 414 invested in overnight pooled rmney with W11 s Fargo on thcenber 31, 2011. The County's investment at W1 1 s Fargo is a direct obligation of the bank and the funds are maintained in a rmney market account earning a negotiated rate of r et urn. The collateral for t his account is in an undi vi ded i nt er est agai nst a pool of U S. Government securities neet i ng the PDPA r equi r event s of the State of Col or ado, which is adni ni s t er ed under the State's Banki ng Di vision. The Fair value of all of the funds shares are the sane and are priced at one dollar and are 1 i qui d dai 1 y. A des i gnat ed custodial bank pr ovi des safekeepi ng and depository services in connection with the direct i nvest ment and withdrawal functions. Subs ant i ally all securities owned are held by the Federal Reserve Bank in the account nui nt ai ned for the cust odi al bank. The cust odi an' s internal records identify the invest rnent s owned by the par t i ci pat i ng governments. H. Restricted Cash The Decenber 31, 2011 restricted cash balance of $354, 369 is nude up of $65, 000 advanced to cover insurance claims and $289, 369 that mist be used in accor dance with the Conservation r egul at i ons set by the lottery authority. I. Component Units The carrying balance of the Housing Authority's cash deposits was $1, 962, 164 at December 31, 2011. Bank and invest vent balances before reconciling i t ems were $1, 962, 164 at that date, the total armunt of which was collateralized or insured with securities held by and unaffiliated banki ng institutional the Authority's name. Deposits consist of the following: Checking, imney Market and savings account $1, 962, 164 Restricted cash consists of tenant section 8 HAP reserves and escrow. The available cash balance of $1, 78.5, 939 for the E911 authority is included in the Agency Cash balance of $13, 320, 358 held at the W1 d County Treasurers Office listed above. 62 COUNTY OF W1 d Count y STATE OF COLORADO Year Ended Decenber 31, 2011 Note 4 - Inter - fund Trans actions Due to/from other funds: The county reports inter- fund balances bet wuen many of its funds. Some of the balances are consi der ed i matt eri al and are aggregated into a single col unn or row. The sum of all balances presented in the table agrees with the sum of i nt er fund balances presented in the balance sheet for governmental and proprietary funds. The balances resulted from the tine lag bet vwen the dates that (1) inter fund goods and services are pr ovi ded or reimbursable expenditures occur, (2) trans actions ar e recorded in the accounting syst em and (3) payment s bet wen funds are made. Inter fund balances are generally expected to be repaid within one year of the financial st at ement date. Receivable Fund General Social Services Human Services Internal Service Payable Fund Public Ver ks Social Services I nt ernal Service General Fund Hunan Services Social Services General $ 22 1, 304 137, 128 1, 927, 404 13, 251 205, 205 129, 939 $ 2, 414, 253 63 COUNTY OF W1 d Count y STATE OF COLORADO Year Ended Decenber 31, 2011 Transfers in/out: Transfers are indicative of funding for capital projects or subsidies of various County operations and r e- al 1 ocat i on of special revenues . The following schedule briefly sunmirizes the County's transfer activity: Transfer To: General Fund Public Vor ks Human Services Capital Non- Mj or Government Internal Service General Fund 12, 351 5, 500, 000 2, 602, 068 250, 000 8,364,419 Transfer From Contingent Non- MO or Fund Gover nrrient 7, 100, 000 800, 000 7, 900, 000 Total $ 85, 000 $ 85, 000 7, 100, 000 12, 351 5, 500, 000 507, 909 3, 109, 977 1, 050, 000 592, 909 16, 857, 328 Note 5 - Allowance for Uncol 1 ect i bl e Accounts Recei vabl e: The allowance for uncol 1 ect i bl e receivables consists of the following at Decenber 31, 2011: Fund Type General Public %r ks Social Services Cont i ngent Capital Expenditures Enterprise Internal Service Tot al Allowance for Uncollectible $ 34, 356 4, 701 4,638 2, 988 4, 426 2,081,318 1, 427 2, 133, 854 64 65 COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 2011 Note 6 - Capital Assets: Capital asset activity for the year ended December 31, 2011, was as follows: Governmental activites Capital Assets not being depredated Land and water rights Intangible Assets Gravel Roads Construction in progress Total capital assets not being depreciated Capital assets being depreciated: Buildings Improvements Equipment Infrastructure Total capital assets being depreciated Less accumulated depreciation Buildings Improvements Equipment Infrastructure Total accumulated depreciation Total capital assets being depreciated, net Governmental activities capital assets, net Business -type activities: Capital Assets not being depreciated Land Capital assets being depreciated: Buildings Improvements Equipment Total capital assets being depreciated Less accumulated depreciation Buildings Improvements Equipment Total accumulated depreciation Total capital assets being depreciated, net Business -type activities capital assets, net Beginning Balance $ 8,451,695 $ 11,318,958 3,776,715 23,547,368 124,111,625 7,596,419 45,228,676 310,367,499 487,304,219 30,171,268 2,585,552 28,997,763 194,203,221 255,957,804 Ending Increases Decreases Transfers In (Out) Balance 223,619 153,197 6,653,593 7,030,409 286,524 3,987,856 8,579,923 88,865 88,865 4,519,455 1,443,304 12,854,303 5,962,759 2,841,749 278,684 3,874,982 14,701,432 4,424,702 910,462 21,696,847 5,335,164 231,346,415 18,842,544) $ 254,893,783 $ (1,812,135) $ 48,496 $ 710,305 55,728 1,703,431_ 2,469,464 407,189 54,489 750,670 1,212,348 1,257,116 $ 1,305,612 686,217 686,217 24,266 1,240 399,293 424,799 261,418 $ 261,418 627,595 $ 716,460 331,229 331,229 288,347 288,347 42,882 $ 42,882 1163,274) (163,274) 163,274 $ 8,451,695 223,619 11,383,290 10,267,034 30,325,638 124,561,423 7,596,419 44,697,077 317,504,118 163,274 494,359,037 33,013,017 2,864,236 28,448,043 207,994,191 272,319,487 163,274 222,039,550 $ 252,365,188 $ 48,496 710,305 55,728 2,058,419 2,824,452 431,455 55,729 861,616 1,348,800 1,475,652 $____u24,148 66 COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 2011 Beginning Ending Balance Increases Decreases Transfers In (Out) Balance Housing Authority Capital assets being depreciated: Equipment Total capital assets being depreciated Less accumulated depreciation Buildings Improvements Equipment Total accumulated depreciation Total capital assets being depreciated, net 42,039 $ $ 42,039 42,039 42,039 29,050 29,050 12,989 Housing Authority capital assets, net $ 12,989 E-911 Assets: Capital Assets not being depreciated Construction in progress Capital assets being depreciated: Equipment Total capital assets being depreciated Less accumulated depreciation Equipment Total accumulated depreciation Total capital assets being depreciated, net E-911 capital assets, net 1,133 - 30,183 1,133 - - 30,183 (1,133) 11,856 1__111N) $ - $ $ 11,856 $ 436,854 $ 2,755,128 1,310,563 2,755,128 1,310,563 1,170,163 1,170,163 $ (436,854) $ - 436,854 4,502,545 436,854 4,502,545 353,171 - 1,523,334 353,171 1,523,334 1,584,965 957,392 $ 2,021,819 $ 957,392 436,854 2,979,211 $ $ 2,979,211. 67 COUNTY OF \M 1 d Count y STATE OF COLORADO Year Ended December 31, 2011 Depreciation expense was charged t o functions/programs government as follows: Governnent al activities: General government Public safety Streets and hi ghways Economic assistance Culture and recreation Health and welfare Capital Assets held by government's internal service funds are charged to the van i ous functions based on their usage of the assets Total depreciation expense- government al activities Bus i nes s - type activities Par anedi c Service of the pri mary $ 1, 569, 316 1, 756, 769 14, 923, 317 23, 471 11, 712 406, 089 3, 006, 173 $ 21, 696, 847 $ 424, 799 Component Unit s Housing Authority 1, 133 E- 911 Authority 353, 171 Total depreciation expense component units $ 354, 304 Note 7 - Risk management and insurance: The County is exposed to various risks of loss related to torts; theft of, damage to, or destruction of assets; and errors or omissions. These activities are accounted for i n the Insurance Fund, an internal service fund. A liability for a claim is established if information indicates that it is probable that a liability has been incurred at the date of the financial statements and the armunt of the loss is reasonably est i mmabl e. Insurance coverages have not been significant 1 y reduced from prior years and settlements have not exceeded insurance coverage in the past three years . The County manages risks of 1 oss through a combination of conirer ci al insurance, participation in a public entity risk pool, (See Note 1) and self-insurance. These activities are accounted for in the Insurance Fund, an internal service fund. The County pr ovi des health, dental and vision i nsur ance benefits to enpl oyees, whi ch are funded by enpl oyee and employer cont ri but i ons. These activities are accounted for i n the Health Insurance Fund, an i nt ernal service fund. 68 COUNTY OF W1 d Count y STATE OF COLORADO Year Ended Decenber 31, 2011 Wrkers' Compensation coverage is partially self -insured, with insurance coverage of a $600, 000 self -insured retention. Est i rmt ed 1 i abilities for cl ai rrs nude and claim incurred but not reported (IBNR) at year - end are shown as accrued liabilities in the fund. These est i mat es are based upon a third -party admi ni st r at or s review of claims and actuarial proj ections ons from hi st or i cal cl ai ns dat a. Changes i n the bal ances of claims liabilities during the current and prior years are as follows : Unpaid Cl ai ns - Begi nni ng Incurred Claims (Includes I BNR' S) Claims Paid Unpaid Cl ai rrs - Endi ng 2010 $ 1, 393, 958 1, 383, 576 (1,014,481) 2011 $ 1, 763, 053 1, 295, 334 (1, 077, 507) $ 1, 763, 053 $ 1, 980, 880 The Insurance Internal Service Fund provides protection against losses i nvol vi ng County property, equi pment , and 1 i abi 1 i t y. Reserves within the fund support hi gher deductible or self -insured retention 1 evel against loss. Payment s to CAPP for coverage under the insurance pool are shown as expenses i n the Insurance Int ernal Service Fund. Est i nut ed liabilities under the $125,000 self -insured retention for claim, made and claims incurred but not reported (IBNR) at year-end are shown as accrued liabilities in the fund. These es t i mat es are based upon CAPP' s cl ai m administrator's review of claims and actuarial projection from historical claims data. Changes in the balances of claim, liabilities under the $125, 000 self- insured retention during current and prior years are as follows: Unpaid Cl ai trs - Begi nni ng Incurred Cl aims (Includes IBM! s) Cl aims Pai d Unpaid Cl ai rrs - Endi ng 2010 $ 324, 498 324, 974 (385, 312) 2011 $ 264, 160 273, 925 (337, 142) $ 264, 160 $ 200, 943 The Health Insurance I nt er nal Service Fund covers the county' s dental and vi s i on reimbursement pl an. The plan is not an insurance program but rat her an employee r ei nbur sement plan t hat closes out each year on December 31, for services received on or before t hat date. It out s t andi ng claims or incurred but not reported liabilities exist for year-end. COUNTY OF W1 d Count y STATE OF COLORADO Year Ended December 31, 2011 In addition the Health Insurance Internal Service Fund as of January 1, 2006, covers the county's health insurance program The plan is a sel f - f unded errpl oyee health benefit plan with a specific deductible armunt of $100, 000 per individual, and an aggregate excess loss insurance policy t hat has both a rmnt hl y at t achment point and an annual cumil at i ve at t achrnent limit with a terra nal attachment point . Attachment points ar e calculated based upon enrollment. Changes i n the balance of the claims liability during the current year are as follows : 2010 2011 Lnpai d CI ai nF - Begi nni ng Incurred Claim Cl a i ifs Paid Unpaid Cl ai rrs - Endi ng Note 8 - Long- Term Debt : 13, 178, 226 (11, 197, 273) $ 1, 980, 953 12, 948, 583 ( 12, 698, 200) 1, 980, 953 $ 2, 231, 336 V1/461 d County has no general bonded indebtedness . I n accordance wit h Section 30- 35- 201 CRS, 1973, the County's general bonded indebtedness is limited to 3% of the assessed valuation, or $162, 655, 885 at Lecenber 31, 2011. The County has i s sued industrial revenue bonds for the purpose of financing capital projects of several private enterprises. Under terns of a financing agreement , the bonds are sold to a bank, the pr i vat e enterprise assumes full responsibility for repayment of the debt, and the County is released from any liability for repayment . Industrial revenue bonds outstanding as of December 31, 2011 totaled $5, 382, 400. Changes in long-term liabilities Long-term liability activity for the year ended December 31, 2011, was as follows, the balances, additions and reductions are listed by the funds where the liability is accrued and 1 i qui dated: Compensated absences General Fund Public VSb r k s Social Services Public Health Hunan Services Total governmental Begi nni ng Bal ance $ 1, 585, 499 471, 467 773, 913 221, 885 $ 3, 052, 764 Additions Reductions $ 138, 165 6,068 118,661 11,048 164, 154 $ 438, O96 $ 97,914 21, 001 85, 205 16, 380 $ 220, 500 Endi ng Bal ance $1, 625, 750 456, 534 807, 369 216, 553 164, 154 $3, 270, 360 Due Wt hi n One Year $ 90, 964 15, 536 82, 922 16, 076 32, 831 $ 238,329 70 COUNTY OF W1 d Count y STATE OF COLORADO Year Ended December 31, 2011 Note 9 - d County Retirement PI an: Plan Description: The Wl d County Ret i rement PI an (Plan) i s a si ngl a-empl oyer, defi ned benefit pension plan administered by a five -member retirement board. The plan provides r et i r event , disability and death benefits to plan members and beneficiaries at the discretion of the Retirement Board. The Retirement Board and the Board of Conmi s s i oner s maintain the authority to establish and amend benefit provisions of the Plan. The Retirement Board issues a publicly avai 1 able financial report t hat includes financial s t at ement s and r equi r ed suppl ement ary i of or mat ion. That report nay be obt ai ned by cont acting the County of Val d, State of Col or ado. Funding Policy: The cont r i but i on r equi r event s of pl an nenber s and the County ar e est abl i shed and nai nt ai ned by the Board of Comri ssi oners. PI an members are requi red t o cont r i but a 9% of their annual covered payroll. The County is required to contribute at an actuarially determined rate; the current rate is 9% of annual covered payroll. Annual Pension Cost and Net Pension Obligation: The County's annual pension cost and net pension obligation to the Plan the current year were: Annual Requi red Cont r but i ons Interest on net pension obligation Annual Pension Cost Cont r i but i ons nude Increase (decrease) in net pension obligation Net pension obl i gat i on (asset) begi nni ng of year Net pension obligation (asset) end of year 6, 013, 818 429, 752 6, 443, 570 6, 706, 758 (263, 188) 5, 371, 897 5, 108, 709 The annual required contribution for the current year was determined as part of the January 1, 2011 act uar i al valuation using the entry age act uar i al cost net hod. The actuarial as s umpt i ons included ( a) 8% investment rate of return (net of administrative expenses) and (b) proj ect ed salary i ncr eases rangi ng from 3. 3% t o 6. 5% per year. Both ( a) and (b) included an inflation component of 2. 8% The act uar i al value of assets was determined using techniques that smooth the effects of short - t er m volatility in the market value of investments over a five- year period. The unfunded actuarial liability is being amortized as a level per cent age of projected payr of 1 on a closed basis . The r enai ni ng anort i zat i on period at January 1, 2011, was 30 years. All related pension obligation (assets) are recorded i n the County's General fund. 71 COUNTY OF W1 d Count y STATE OF COLORADO Year Ended Decenber 31, 2011 Three -Year Trend Information: Fiscal Year Ended December 31, 2009 December 31, 2010 December 31, 2011 Funding Status: Actuarial Valuation Date 1/ 1/ 1 1 Actuarial Value of Assets (a) Annual Pension Cost (APC) 7, 261, 594 5, 775, 895 6, 443, 570 $134,917,364 Actuarial Accrued Liability ( AAL) Entry Age (b) $193, 269, 672 Percentage of APC Cont r i but ed 68. 3% 84. 6% 104. 1% Unfunded AAL ( UAAL) (b- a) $58, 352, 308 Net Pension Obl i gat i on (Asset ) 4, 481, 662 5, 371, 897 5, 108, 709 Funded Ratio (a/ b) Covered UAAL as a Payroll ( c) Percent age of Covered Payr of [b-a)/c] 69. 8% 53, 415, 982 109.2% A schedule of funding progress can be found in the RSI section following the notes to the financial stat at ement s. The schedule of funding progress presents information on the funding process and its increases and decreases over tine. Based on several rmnt hs of study and review of available plan design opt i ons, the Ret i r errmnt Board r evi s ed the pr ovi s i ons of the V1/461 d Count y Retirement Plan in order to reduce the future volatility of the plan's funded status and help to secure the financial future of the Plan. The maj or i t y of the revi si ons only impact new rnenber s hi red on or after January 1, 2010. The provi si ons of the revised plan provide a variable annuity with members accruing 1. 9% of their pay each year toward their age 65 annuity. The benefit is adjusted each March based on the Plan's asset return under or over 5% for the prior year. Early retirement opt i ons continue t o be available under the revised pl an. The i nt er es t rate credited to contributions after January 1, 2010 i s 3% per year. 72 COUNTY OF W1 d Count y STATE OF COLORADO Year Ended December 31, 2011 Note 10 - Ot her Post Errpl oynent Benefits : Plan Description: Weld County Ot her Post Empl oyment Benefits PI an ( OPEB PI an) is a s i ngl e- e npl oyer defined benefit healthcare pl an administered by VM1 d County that pr ovi des nedi cal , dental , and vision insurance benefits to el i gi bl e e etirees and their spouses. The OPEB Plan was created by a Board of W1 d County Comri s s i oner s resolution on November 30, 1998, and an -ended Decenber 16, 2002 and Sept ember 21, 2005. The OPEB Plan provides the sane health, dental, and vision plan as offered Val d County employees and at the sane cost. The program i s not part of the Veld County Retirement Plan and is not a vested benefit or right, but it is a plan that can be an -ended or stopped at any tine by the Board of V1/46l d County Corrrri s s i oner s for any reason, and no separate financial stat at ement s are prepared. The program i s only avai 1 abl e to W1 d County employees hired prior to October 1, 2005. From December 16, 1998, to December 31, 2008, a retiree who retires from employment with Val d County after ten years of servi ce, or was an elected official of Vel d County for at least one full four year term who has attained the age of 55 years and is drawing benefits from t he Wl d County Retirement PI an i s el i gi bl e t o continue health, dent al , and vision coverage until age 65. After January 1, 2009, an employee mist have attained age 57 and have 15 years of service to be eligible. From 2009 until 2014 the required age attainment and years of service are each increased by one year annually, so effective January 2014 an employee mist have attained age 62 and have 20 years of service to be el i gible, e, unless the employee attains age 55 and has 30 years experience or has attained age 55 and has served as a W1 d County elected offi ci al for two f ul 1 terns . Coverage ends in all cases at age 65. The Board of Val d County Conmi s s i oner s on Sept enber 15, 2008, decided by r es of ut i on t hat the current program will be stopped January 1, 2009, except for those e nrpl oyees born pri or to January 1, 1957, or any enpl oyee born on or pri or to December 31, 1958, who will have 30 years of service prior to reaching age 62. Employees meeting these criteria will be gr andf at her ed into the current plan and wi 1 1 r enai n el i gi bl a for continued benefits under the retiree health insurance program adopted December 16, 2002. An empl oyee meeting the above criteria to be eligible for the gr andf at her ed plan the e npl oyee and/ or dependents, i f applicable, mist have been enrol 1 ed as of January 1, 2008, in the 'Veld County health insurance plan. Enpl oyees and/ or dependents enrol 1 ed i n the VC d County health insurance pl an after January 1, 2008, are not eligible for the gr andf at her ed plan. On July 19, 2010, the Board of W1 d County Commi s s i oner s terminated the program e ffective June 30, 2012, for all eligible employees that had not retired or signed an agreement for continuation of health insurance coverage as of October 1, 2010. 73 COUNTY OF W1 d Count y STATE OF COLORADO Year Ended Decenher 31, 2011 Funding Policy: The cont r i but i on requirements of plan members and Wl d County ar e est abl i shed and nay be amended by the Board of W1 d County Comm s s i oner s annually. The required cont r i but i on i s based on proj ect ed pay-as-you-go financing requirements, with an additional armunt t o prefund benefits as det ermi ned by an actuarial report last done on January 1, 2009. For fiscal year 2011, the county contributed $960, 700 to the plan, including $760, 700 for current pr emi uns ( appr oxi mat el y 80 percent of tot al premi um) and $200, 000 additional fundi ng t o prefund benefits . Plan members r ecei vi ng benefits cont r i but ed $185, 112, or appr oxi mat el y 20 per cent of the tot al pr eni uns, through their required cont r i but i on ranging from $111 to $152 per rmnt h for retiree- only coverage and bet wuen $219 to $251 for retiree and spouse coverage. The OPEB Plan assets are deposited i n the W1 d County OPEB PI an Trust Fund. The enpl Oyers contributions to the trust fund are irrevocable, the assets of the trust are dedicated to providing benefits to retirees and their beneficiaries, and the assets are legally protected from the employer's creditors. Annual OPEB Cost and OPEB Obligation: Prior to January 1, 2007, the OPEB Plan was funded on a pay as you go basis. Begi nni ng January 1, 2007, the county's annual of her post enpl oynent benefit (OPEB) cost (expense) i s calculated based on the annual required contribution of the employer (ARC) , an armunt actuarial 1 y determined in accordance with the parameters of GASB St at ernent 45. The ARC represents a level of funding that, if paid on an ongoing basis, is proj ect ed t o cover nor nal cost each year and anvrt i ze any unfunded actuarial liabilities (or fundi ng excess) over a period not to exceed t hi r t y years. The primary assumption for the ARC calculation is the 7. 5% di s count rate. The actuarial assumptions included an annual healthcare cost trend rate of 11% initially, reduced by decrements to an ultimate rate of 5% after 6 years. Liabilities are cornput ed using the proj ected unit credit fret hod. The unfunded actuarial accrued liability was anort i zed over a cl osed 25 year period. GASB' s standard requires an actuarial valuation bi enni ally for empl oyer s with menber s hi p of 200 or more employees, terminated enpl oyees who Nth 1 1 be eligible for benefits, and retired employees and beneficiaries receiving benefits. If there are less than 200 plan members the actuarial valuation can be triennial. Therefore, the January 1, 2009, actuarial valuation date has been used for the plan for December 31, 2011 reporting. The f of 1 owi ng shows the components of the county's annual OPEB cost for the year, the armunt actual 1 y cont r i but ed t o the pl an, and changes i n the county's net OPEB obl i gat i on t o Wl d County: COUNTY OF Ve 1 d County STATE OF COLORADO Year Ended December 31, 2011 Benefit Obligation and Normal Cost on December 31, 2011 Actuarial Accrued Liability Ret i red Errpl oyees Active Errpl oyees Total Unfunded actuarial accrued l i ability (UAAL) Noma cost beginning of year Aimrt i zed factor based on 25 years $ 5,411,716 2,934,307 $ 8, 346, 023 $ 5,561,146 $ 99, 753 11.6172 Level Dollar Amortization Calculation on ARC under Projected Unit Credit Method on December 31, 2011 Aimrtization of UAAL over 25 years Norrral cost at begi nni ng of year Interest Gross Annual Requi red Contribution Interest Earned on Net OPEB Asset 2011 Cross Annual Required Contribution Errpl oyee Cont r i but i ons 2011 Net County ARC Decrease i n net OPEB obl i gat i on Begi nni ng OPEB obl i gat i on Ending OPEB Obl i gat i on (ARC) County Contribution Unfunded actuarial accrued liability $ 560, 778 99, 753 49, 540 710,071 (92, 585) 617,486 ( 185, 112) 432, 374 ( 960, 700) (528, 326) (1, 157, 309) $ (1,685,635) (UAAL) end of the year $5, 561, 146. Covered Participants as of January 1, 2012 Retired Enpl oyees Spouses of Ret i red Errpl oyees Three -Year Trend Fiscal Year End Ikcenber 31, 2009 December 31, 2010 Decenber 31, 2011 Information: Annual Required Contribution (ARC) $ 710,071 $ 710,071 $ 710,071 75 14 Percent age of ARC Contributed 119% 218% 161% 89 Net OPEB Asset $ (291,210) $( 1, 157, 309) $( 1, 685, 635) 75 COUNTY OF Ve 1 d Count y STATE OF COLORADO Year Ended December 31, 2011 Prior to January 1, 2007, the OPEB Plan was on a pay as you go funding basis. January 1, 2007, was the first time an actuarial accrued liability was cal cul at ed t o det erni ne the net OPEB obl i gat i on. The OPEB obl i gat i on as of Decenber 31, 2011 was $8, 346, 023 there were $2, 784, 877 in assets on Decenber 31, 2011 for unfunded actuarial accrued l i ability (UAAL) . Al l related pension obli gat i on (assets) are recorded in the Count y' s General fund. Funded Status and Funding Progress. The funded status of the plan as of December 31, 2011, was as follows: Actuarial Accrued Liability (AAL) Actuarial value of plan assets Unfunded actuarial accrued l i ability ( UAAL) Funded ratio ( actuarial value of pl an ass et s/ AAL) $ 8, 346, 023 $ 2, 784, 877 $ 5, 561, 146 33. 4% Actuarial val uat i ons involve es t i mat es of the value of reported annunt s and as s umpt i ons about the probability of events far into the fut ur e, and actuarially det er ni ned anmunt s are subject t o continual revision as actual results are compared to past expect at i ons and new esti mat es are nude about the future. The required schedule of fundi ng progress presents nul t i ye ar t r end information about whether the actuarial value of assets is increasing or decreasing over time r el at i ve to the actuarial accrued liability for benefits. The actuarial calculations are based on the types of benefits provided under the terms of the substantive plan at the time of each valuation and on the pat t ern of sharing of costs bet ween the employer and menber s to that point and reflect a long-term perspective. The Veld County OPEB Plan Assets are accounted for in the Veld County OPEB Plan Trust Fund. An IRC Section 115 Trust has been est abl i shed for the Ve1d County OPEB P1 an Trust. Note 11 - Connitntnts and Contingencies: Commitments As of December 31, 2011 there were encumbrances carried forward to 2012 of $474, 715 i n the General fund, $115, 462 for general purchases and $359, 253 for fuel site upgrades. The Public Works fund carried forward $319, 865 for road construction projects. In the capital expenditures fund year - end projects under construction included $18,773 for the Southwest Service center, $275, 755 for the jail video visitation system and 1, 618, 936 for gravel pit construction. 76 401(K) . Funding level s 2009 2010 2011 COUNTY OF W1 d Count y STATE OF COLORADO Year Ended Deceiver 31, 2011 Note 12 - Subsequent Events: On April 23, 2012 the Val d County Board of County Cornmi s s i oner s entered into an agreement with NCls Inc., a 501 (c) 3 entity subleased by the Col or ado Hospital Finance Authority t o operate the Nor t her n Col or ado 1Vhdi cal Cent er, t o purchase all of the equipment of the W1 d Count y Paramedic Services for appr oxi mat el y $802, 000. Under the agr eenent , the County will retain ownership of the cash, account receivable and bui 1 di ngs held in the Paramedic fund on the transfer date. The transfer of paramedic services in Weld County from the County to NC1Vc, Inc. , which occurred on Why 7, 2012, i s expected t o have no effect on normal government operations as the d County Pararnedi c Services was the County's lone enterprise operating on a fee for service basis. Note 13 - Public Trustee: Pursuant t o an act of the Color ado General Assembly, the Weld Count y Public Trustee is to be deenrd an agency of the County for the purpose of financial reporting. Related activity has been reported in the General Agency following activity identified strictly for the office Trustee as of and for the year ended December 31, 2011 Assets Liabilities Fund Balance Additions Deduct i ons $ 875, 167 334, 074 541, 093 1, 153, 087 1, 211, 374 Fund, with t he of the Public The Public Trustee started a retirement plan in Decenber 2003. The i s a defined contribution pl an under I nt er nal Revenue Code section are set at 9% 9% 9% t he f of l owi ng: Enpl oyer/ Enpl oyee Enpl oyer/ Enpl oyee Errpl oyer/ Enpl oyee plan 77 COUNTY OF W 1 d Count y STATE OF COLORADO Year Ended Decenber 31, 2011 Note 14 - Non -Cash Activity in Social Services Fund Schedule of EBT Authorizations, Warrant Expenditures and Total Expenditures For the Year Ended December 31, 2011 A B C D E Program County EBT Authorizations County Share of Authorizations Total Refunds and Expenditures by County Warrant or Accrual County EBT Authorizations plus Expenditures by County Warrant (Col. A + Col. C) Total Expenditures (Col. B + Col. C) Old Age Pension 4,836,349 10,927 99,336 4,935,685 110,263 Low -Income Energy Assistance Program 1,712,814 - 365,961 2,078.775 365,961 Temporary Assistance for Needy Families 3,427,416 848,446 1,747,627 5,175,043 2,596,073 Administration 7,809 1,562 6,989,027 6,996,836 6,990,589 Trails/Child Welfare 9,600,319 1,908,252 9,873,526 19,473,845 11,781,778 Core Services 1,787,273 244,632 159,713 1,946,986 404,345 Aid to the Needy Disabled 934,086 146,793 (75,621) 858,465 71,172 IV -D Administration - - 2,907,325 2,907,325 2,907,325 CHATS/Child Care 3,337,543 567,008 643,923 3,981,466 1,210,931 General Assistance - - 674,578 674,578 674,578 Subtotal 25,643,609 3,727,620 23,385,395 49,029,004 27,113,015 Food Assistance 38,029,362 - (10,727) 38,018,635 (10,727) Grand Total 63,672,971 3,727,620 23,374,668 87,047,639 27,102,288 A. Welfare payment authorized by the Weld County Department of Social Services. These County authorizations are paid by the Colorado Department of Human Services by Quest debit cards or by electronic benefits transfer (EBT) B. County share of EBT authorizations. These amounts are settled monthly by a reduction of State cash advances to the County. C. Expenditures made by county warrants or other county payment methods. D. This represents the total cost of the welfare programs that are administered by Weld County. E. This total matches the expenditures on the Social Services Fund - Statement of Revenues, Expenditures and Changes in Fund Balances. 78 Required Supplementary Information COUNTY OF W1 d Count y STATE OF COLORADO Year Ended December 31, 2011 Schedule of Funding Progress - Retirement Plan Actuarial Val uat ion Uat e 1/1/05 1/1/06 1/1/07 1/1/08 1/1/09 1/1/2010 1 / 1/ 201 1 Actuarial Value of Assets (a) $ 98, 604, 182 $103, 979, 296 $112, 874, 087 $125, 879, 138 $112, 079,550 $131, 288, 037 $134, 917, 364 Schedul e Year Ended Decerrber 31 Actuarial Accrued Liability ( AAL) Entry Age (b) $120, 956, 120 $136, 792, 785 $150, 145, 842 $167,011,647 $176, 927, 890 $186, 015, 431 $193, 269, 672 Unfunded AAL ( UAAL) (b -a) $22, 351, 938 $32, 813, 489 $37, 271, 755 $41, 132, 509 $64, 848, 340 $54, 727, 394 $58, 352, 308 of Employer Cont r i but i Annual Requi red Cont r i but i on'') ons Funded Ratio ( a/ b) 81. 5% 76. 0% 75. 2% 75. 4% 63. 3% 70. 6% 69. 8% Covered Payroll (c) $38, 496, 866 $41, 529, 717 $44, 210, 410 $49, 967, 777 $53, 988, 779 $53, 484, 492 $53, 415, 982 - Retirement PI an Actual Cont r i but i on Percent age Cont r i but ed UAAL as a Percent age of Covered Payroll [b-a)/c] 2004 2005 2006 2007 2008 2009 2010 2011 $3, 125, 337 $4, 236, 858 $4, 236, 858 $4, 408, 097 $4, 928, 519 $7, 087, 011 $5, 417, 362 $6, 013, 818 (1)Requi red contribution at beginni $2, 234, 518 $2, 779, 636 $3, 205, 422 $3, 804, 640 $4, 184, 885 $4, 962, 224 $4, 885, 660 $6, 706, 758 ng of year. 71.5% 65. 6% 75. 7% 83. 6% 84. 9% 70. 0% 90. 2% 111. 5% 58. 1% 79. 0% 84.3% 82.3% 120. 1% 102. 3% 109.2%0 79 COUNTY OF W1 d Count y STATE OF COLORADO Year Ended December 31, 2011 Schedule of Funding Progress - Other Post Employment Benefit s Actuarial Valuation Dat e Actuarial Value of Assets (a) $ 1, 831, 353 $ 1, 856, 115 $ 2,550,854 $ 2, 784, 877 Actuarial Unfunded Accrued AAL ( UAAL) Liability (b -a) ( AAL) Entry Age (b) $ 8, 346, 023 $ 6, 514, 670 $ 8, 346, 023 $ 6, 489, 908 $ 8, 346, 023 $ 5, 795, 169 $ 8, 346, 023 $ 5, 561, 146 Funde d Ratio ( a/ b) 21. 9% 22. 2% 30. 1% 33. 4% Schedule of Enpl oyer Cont r i but ions - Ot her Post Employment Benefits Year Ended December 31 Annual Requi red Cont r i but i on' 1) Actual Cont r i but i on Per cent age Cont r i but ed 2009 2010 2011 $710, 071 $710, 071 $710, 071 $648, 864 $1, 364, 055 $960, 700 MRequi red cont r i but i on at begi nni ng of year. 91. 4 °/Wo 192. 1% 135. 3% 80 COUNTY OF WELD STATE OF COLORADO Required Supplementary Information Modified Approach for Infrastructure Assets Weld County prepares an annual gravel road plan. In doing this each of the sections of gravel roads has been evaluated by supervisors. They use the State guidelines as out lined in Section 43 -2 -120(5)(a -b), C.R.S. 1973, which is stated below. Since gravel roads condition can change quickly based on weather conditions the road plan may have to be modified to take care of such problems. Therefore, an official road maintenance system is difficult to put in place. It is the County's policy to maintain the roads in fair or better condition. The County's gravel plan details the replacement and maintenance schedule required for the gravel roads, by segment, under ideal weather conditions based on traffic and location. The day to day conditions of the gravel roads is continually monitored by the County's Motor Grader division whose sole responsibility is to maintain the condition of the gravel roads, the following table details the condition assessment in total miles and percentage reported at the end of the last three fiscal periods. Condition Good Fair Poor Miles 1574 658 56 2011 % of Total 68.8% 28.7% 2.5% Miles 1827 456 47 Comparison of Estimated -to -Actual Maintenance/Preservation 2010 % of Total 78.4% 19.6% 2.0% Miles 1747 534 49 2009 % of Total 74.9% 22.9% 2.2% 2007 2008 2009 2010 2011 Estimated $ 3,328,512 $ 2,666,172 $ 2,947,356 $ 2,915,000 $ 3,160,000 Actual $ 1,892,000 $ 2,169,920 $ 1,572,615 $ 3,046,576 $ 2,683,326 Gravel Roads - Surface Condition Rating Criteria 2012 $ 3,132,000 Section 43-2-120 (5)(a -b), C.R.S. 1973, gives the following guidelines pertaining to the condition criteria on gravel roads. Good Surface Condition $ There is adequate width for safe passage of large vehicles. $ Graded to a uniform cross-section, having a crown and ditches to provide good drainage. $ The surface is smooth with no washboards, rutting or soft areas; vehicles can safely travel at the posted speed limit. $ There is adequate gravel uniformly spread across the surface. $ During periods of wet weather, roads will support traffic. Fair Surface Conditions $ Adequate width for safe passage of cars and pickup trucks. $ Cross-section may vary; the crown is not consistent; ditches and drainage are not adequate. $ The surface has occasional washboards and ruts but irregularities do not interfere with safe vehicle operation at the speed limit. $ Gravel is present, but lacking in the wheel paths or in short stretches. $ During periods of wet weather, puddles develop; the road is slippery but will support normal traffic. Poor Surface Condition $ Two cars cannot safely pass. $ Cross-section varies. There is no crown or ditches, and water does not drain from the road. $ The surface has washboards, ruts, soft areas; vehicles must slow to less than the speed limit. $ Gravel is sparse or does not exist. $ During periods of wet weather, cars cannot safely travel. 81 82 Required Supplementary Information Other Than MD&A COUNTY OF WELD STATE OF COLORADO General Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budget - GAAP Basis Original Final Actual Variance REVENUES Taxes: General property taxes Tobacco products Penalties & interest Total Taxes Licenses and Permits Liquor licenses Planning permits Building permits Electrical permits Total Licenses and Permits Intergovernmental: Federal grants Payment in lieu of taxes State grants Other governmental units Cities and towns Total Intergovernmental Charges for Service: Plan checking fees Charges for services Sale of supplies Parking Total Charges for Services Fines and Forfeitures: Property forfeitures/evidence Fines (drunk drivers) Total Fines and Forfeitures Miscellaneous: Miscellaneous Interest Rents from buildings Royalties Sales of assets Total Miscellaneous $ 53,118,155 $ 53,118,155 $ 52,966,045 $ (152,110) 86,000 86,000 66,543 (19,457) - - 66,043 66,043 53,204,155 53,204,155 53,098,631 (105,524) 5,000 225,000 575,000 100,000 5,000 325,000 935,000 210,000 905,000 1,475,000 6,034 326,459 1,024,727 205,186 1,034 1,459 89,727 (4,814) 1,562,406 87,406 - 549,000 536,073 (12,927) 3,000 3,000 2,574 (426) 2,935,438 3,058,438 3,767,281 708,843 492,962 492,962 632,960 139,998 294,240 294,240 217,983 (76,257) 3,725,640 4,397,640 175,000 3,867,012 117,500 27,000 275,000 3,721,012 117,500 27,000 4,186,512 4,140,512 5,156,871 759,231 273,787 3,197,385 124,868 23,595 (1,213) (523,627) 7,368 (3,405) 3,619,635 (520,877) - 36,216 36,216 478,110 478,110 397,440 (80,670) 478,110 478,110 1,442,820 2,450,000 535,238 750,000 5,178,058 433,656 (44,454) 1,935,820 4,928,739 2,992,919 2,450,000 1,643,122 (806,878) 535,238 534,531 (707) 6,800,000 7,169,988 369,988 - 890 890 11,721,058 14,277,270 2,556,212 COUNTY OF WELD STATE OF COLORADO General Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budget - GAAP Basis Original Final Actual Variance REVENUES (CONTINUED) Fees: Fee account Treasurer's fees Cable fees Total Fees Total Revenues EXPENDITURES General Government: Office of the Board County Attorney Planning and zoning Clerk to the Board County Clerk Elections and registration Motor vehicle County Treasurer County Assessor Maintenance of buildings/grounds County Council District Attorney Juvenile Diversion Grant Victim Assistance MYAT - Probation Financial administration General accounting Purchasing Personnel Geographical Information Systems Computer Services Printing and Supply Transportation Smart Energy Project Total General Government 7,522,000 50,000 50,000 8,667,000 68,000 50,000 7,622,000 8,785,000 75,299,475 84,201,475 8,807,065 72,745 44,313 140,065 4,745 (5,687) 8,924,123 139,123 87,072,592 2,871,117 737,349 811,349 795,407 15,942 700,036 723,036 709,491 13,545 1,324,576 1,470,576 1,355,341 115,235 286,367 276,367 298,932 (22,565) 866,383 1,366,383 978,373 388,010 1,441,530 1,091,530 573,512 518,018 1,847,810 1,882,810 1,880,603 2,207 848,250 848,250 745,972 102,278 2,401,076 2,501,076 2,383,406 117,670 5,159,281 5,479,281 5,963,204 (483,923) 46,567 46,567 11,385 35,182 4,660,134 4,660,134 4,564,100 96,034 78,420 85,420 84,902 518 639,670 667,670 1,393,931 (726,261) - - 36,350 (36,350) 543,065 543,065 482,941 60,124 633,870 642,870 608,071 34,799 151,876 156,876 156,100 776 709,478 852,478 618,698 233,780 113,581 113,581 75,290 38,291 1,872,565 1,872,565 2,709,234 (836,669) 392,727 392,727 324,503 68,224 761,002 837,302 856,290 (18,988) - - 9,818 (9,818) 26,215,613 27,321,913 27,615,854 (293,941) (CONTINUED) COUNTY OF WELD STATE OF COLORADO General Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budget - GAAP Basis Original Final Actual Variance EXPENDITURES (CONTINUED) Public Safety Sheriff administration Crime control and investigations Traffic control Municipal Service Contracts Task force Regional forensic laboratory Communications services Criminal justice Justice Services County Coroner Correctional administration Community correction Building inspection Office of emergency management Waste water management Animal control Pest/weed control Victim Advocates Total Public Safety Public Works: General engineering Extension services Veteran office Airport Total Public Works Public Health and Welfare: Mental health Developmentally disabled Seniors program Economic development A Kid's Place Total Public Health and Welfare Culture and Recreation: Missile site park Parks and Trails County fair Total Culture and Recreation 1,627,069 1,607,069 1,558,229 48,840 6,939,573 7,104,573 7,262,202 (157,629) 1,108,385 1,214,385 1,191,642 22,743 739,343 739,343 771,720 (32,377) 171,422 185,422 103,873 81,549 280,933 280,933 207,321 73,612 2,048,813 2,065,813 2,102,367 (36,554) 1,374,524 1,374,524 1,392,605 (18,081) 453,412 453,412 435,176 18,236 648,757 648,757 686,866 (38,109) 19,952,673 20,372,673 20,376,709 (4,036) 2,336,155 2,336,155 2,492,457 (156,302) 932,085 984,085 954,235 29,850 166,737 166,737 159,957 6,780 10,000 10,000 9,216 784 318,414 318,414 288,246 30,168 502,994 502,994 405,475 97,519 149,397 149,397 132,511 16,886 39,760,686 40,514,686 40,530,807 (16,121) 1,920,723 342,144 69,129 7,895 2,325,723 342,144 83,129 7,895 2,339,891 2,758,891 168,225 38,225 10,360 87,000 6,780 168,225 38,225 10,360 230,100 6,780 310,590 453,690 72,079 29,000 308,945 72,079 29,000 308,945 410,024 410,024 1,915,335 303,416 80,411 7,895 410,388 38,728 2,718 2,307,057 451,834 108,225 38,225 10,360 230,277 6,780 60,000 (177) 393,867 59,823 64,838 29,000 670,724 7,241 (361,779) 764,562 (354,538) COUNTY OF WELD STATE OF COLORADO General Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budget - GAAP Basis EXPENDITURES (CONTINUED) Miscellaneous: Other Refund of Prior Years Retierment Benefits Building rents Total Miscellaneous Capital Outlay: Capital purchases Total Expenditures Other Financing Source (Use) Non -Departmental Transfers - Out: Appropriation Grants -In -Aid Total Other Financing Sources (Uses) Net Change in Fund Balance Fund Balance at Beginning of Year Prior Period Adjustment (Footnote 1(D)) Beginning Fund Balance Restated Fund Balance at End of Year Original Final 577,228 78,975 1,242,228 1,800,000 79,975 656,203 3,122,203 2,023,118 1,750,118 71,716,125 76,331,525 85,000 3,214,419 85,000 8,364,419 (3,129,419) (8,279,419) 453,931 (409,469) 11,849,589 11,849,589 11,849,589 11,849,589 $ 12,303,520 $ 11,440,120 Actual 1,132,880 1,800,000 79,687 3,012,567 903,208 75,527,922 85,000 8,364,419 (8,279,419) Variance 109,348 288 109,636 846,910 803,603 3,265,251 3,674,720 11,849,589 6,000,000 6,000,000 17,849,589 6,000,000 $ 21,114,840 $ 9,674,720 87 COUNTY OF WELD STATE OF COLORADO Public Works Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budget - GAAP Basis REVENUES: Taxes: General property taxes Severance Tax Specific ownership taxes Penalties & Interest Total Taxes Licenses and Permits Moving permits Intergovernmental: Mineral leasing Grazing act Payment in lieu of taxes Grants Motor vehicle registration fees Highway user tax fund Total Intergovernmental Charges for Services: Charges for services Miscellaneous: Earnings on deposits Special assessments Miscellaneous Total Miscellaneous Fees: Other fees Total Revenues Original Final $ 6,987,191 $ 6,987,191 1,600,000 1,727,000 6,330,000 6,330,000 14,917,191 400,000 150,000 80,000 20,000 140,000 340,000 9,530,000 10,260,000 835,000 835,000 26,412,191 15, 044,191 530,000 80,000 20,000 140,000 340,000 9,530,000 10,110,000 835,000 835,000 26,519,191 Actual $ 6,967,813 1,727,872 5,742,776 8,608 14,447,069 530,910 49,666 33,731 36,173 328,671 9,709,065 10,157,306 586,636 48,274 3,910 358,074 410,258 460,062 Variance $ (19, 378) 872 (587,224) 8,608 (597,122) 910 (30,334) 13,731 (103,827) (11,329) 179,065 47,306 586,636 48,274 3,910 (476,926) (424,742) 460,062 26,592,241 73,050 88 COUNTY OF WELD STATE OF COLORADO Public Works Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budget - GAAP Basis EXPENDITURES Public Works Bridge construction Maintenance of condition Maintenance support Trucking division Mining division Administration Pavement Management Other public works Total Public Works Intergovernmental: Grants-in-aid to cities/towns Capital outlay Total Expenditures Other Financing Sources (Uses): Transfers - In: Contingent Net Change in Fund Balance Fund Balances at Beginning of Year Fund Balances at End of Year Original Final 3,887,635 6,187,801 1,397,957 3,535,262 1,397,136 686,793 5,519,092 2,842,879 25,454,555 1,676,452 27,131,007 (718,816) 4,167,635 6,367,801 1,427,957 3,863,262 2,247,136 726,793 6,139,092 6,628,879 31,568,555 1,676,452 33,245,007 7,100,000 374,184 Actual 3,927,507 6,475,211 1,310,653 3,746,274 2,016,048 1,023,429 5,682,924 2,717,332 26,899,378 1,628,048 47,158 28, 574, 584 7,100,000 5,117,657 25,074,869 25,074,869 25,074,869 $ 24,356,053 $ 25,449,053 $ 30,192,526 Variance 240,128 (107,410) 117,304 116,988 231,088 (296,636) 456,168 3,911,547 4,669,177 48,404 (47,158) 4,670,423 4,743,473 $ 4,743,473 89 COUNTY OF WELD STATE OF COLORADO Social Services Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budget - GAAP Basis REVENUES Taxes: General property taxes Penalties & Interest Total Taxes Intergovernmental: Welfare Miscellaneous: Miscellaneous Total Miscellaneous Total Revenues EXPENDITURES Public Health and Welfare: Administrative - regular Administrative - IV -D Food stamps Other Programs General assistance TANF AND - State Child welfare Day care Original Final $ 9,166,333 $ 9,166, 333 9,166,333 9,166,333 19,398,167 28,564,500 5,574,500 2,825,000 2,575,000 20,000 2,740,000 110,000 12,485,000 1,090,000 20,768,167 29,934,500 6,444,500 2,825,000 2,575,000 20,000 2,740,000 110,000 12,785,000 1,290,000 Actual $ 9,142,333 12,571 9,154, 904 19, 084, 866 16 16 28,239,786 5,907,772 2,907,325 (10,727) 1,082,817 674,578 2,596,073 71,172 11,781,778 1,210,931 Variance $ (24,000) 12,571 (11,429) (1,683,301) 16 16 (1,694,714) 536,728 (82,325) 10,727 1,492,183 (654,578) 143,927 38,828 1,003,222 79,069 90 COUNTY OF WELD STATE OF COLORADO Social Services Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budget - GAAP Basis Original Final Actual Variance EXPENDITURES (CONTINUED): OAP - A Core services Administrative - LEAP Total Public Health and Welfare Capital Outlay Total Expenditures Net Change in Fund Balance Fund Balances at Beginning of Year Fund Balances at End of Year 135,000 500,000 440,000 135,000 500,000 440,000 28,494,500 29,864,500 70,000 110,263 404,345 365,961 24,737 95,655 74,039 27,102,288 2,762,212 70,000 - 70,000 28,564,500 29,934,500 27,102,288 2,832,212 1,137,498 2,679,030 2,679,030 2,679,030 1,137,498 $ 2,679,030 $ 2,679,030 $ 3,816,528 $ 1,137,498 91 COUNTY OF WELD STATE OF COLORADO Human Services Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budget - GAAP Basis Original Final Actual Variance REVENUES Intergovernmental: Federal grants State grants Total Intergovernmental Charges for Services: Charges for services Total Charges for Services Miscellaneous: Donations from private sources Other revenue Total Miscellaneous Total Revenues EXPENDITURES Economic Assistance: Head start Preschool program Job service Summer job hunt Employment first TANF WIA administration WIA adult programs WIA youth programs 10% Discretionary Grant National emergency WIA planning WIA dislocated worker Human resources lab pool UI training program $ 6,326,276 $ 6,842,120 $ 5,366,789 $ (1,475,331) 2,286,215 2,293,715 1,689,824 (603,891) 8,612,491 9,135,835 7,056,613 (2,079,222) 395,000 395,000 395,000 395,000 503,389 108,389 503,389 108,389 145,100 145,100 154,446 9,346 - 164,474 164,474 145,100 145,100 9,152,591 9,675,935 1,112,122 34,500 350,000 785,656 196,000 468,254 554,209 50,000 25,000 404,940 325,000 345,421 1,234,122 40,000 350,000 785,656 196,000 513,254 734,209 55,000 31,000 477,940 325,000 345,421 318,920 173,820 7,878,922 (1,797,013) 21,048 (21,048) 235,885 (235,885) 1,251,678 (17,556) 40,046 (46) 240,742 109,258 614,754 170,902 130,493 65,507 557,231 (43,977) 705,282 28,927 59,339 (4,339) 524 (524) 27,839 3,161 474,487 3,453 246,496 78,504 339,961 5,460 92 COUNTY OF WELD STATE OF COLORADO Human Services Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budget - GAAP Basis EXPENDITURES (CONTINUED): One stop AAA administration OAA title III -B OAA title III -C1 congregate OAA title III -C2 OAA in home support Health services AAA elder abuse AAA ombudsman Single entry point Wellspring/Health fund NCMC Grant Vale Grant AAA case management AAA state funds Supplemental foods Part E family caregiver support CSBG Hire Colorado Total Economic Assistance Total Expenditures Other Financing Sources (Uses): Transfers - In: OAA area agency Total Other Financing Sources Net Change in Fund Balance Fund Balances at Beginning of Year Fund Balances at End of Year Original Final 244,900 79,615 271,880 422,312 38,027 12,701 2,039 7,107 1,307,081 12,000 422,238 1,428,630 85,310 180,000 244,900 79,615 271,880 442,312 38,027 25,701 29,344 2,039 17,107 1,307,081 7,500 12,000 422,238 1,428,630 92,310 180,000 9,164,942 9,688,286 9,164,942 9,688,286 12,351 12,351 12,351 12,351 1,330,409 1,330,409 $ 1,330,409 $ 1,330,409 Actual 191,925 50,028 266,662 425,880 30,999 18,630 33,352 3,249 13,684 1,079,376 22,301 4,298 12,666 9,975 442,316 135,602 85,308 108,471 (45) 7,880,482 7,880,482 12,351 12,351 10,791 1,330,409 $ 1,341,200 Variance 52,975 29,587 5,218 16,432 7,028 7,071 (4,008) (1,210) 3,423 227,705 (22,301) 3,202 (666) (9,975) (20,078) 1,293,028 7,002 71,529 45 1,807,804 1,807,804 10,791 $ 10,791 93 COUNTY OF WELD STATE OF COLORADO Contingent Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budgeted REVENUES Taxes: General property taxes Total Taxes Total Revenues EXPENDITURES Miscellaneous Total Expenditures Transfers - Out: Other Total Other Financing (Uses) Net Change in Fund Balance Fund Balances at Beginning of Year Fund Balances at End of Year Original Final Actual Variance $ 1,000,000 $ 1,000,000 $ 994,188 $ (5,812) 1,000,000 1,000,000 1,000,000 6,800,000 6,800,000 (5,800,000) 26,946,930 $ 21,146,930 1,000,000 7,900,000 994,188 994,188 7,900,000 (7,900,000) (7,900,000) (6,900,000) (6,905,812) 26,946,930 26,946,930 (5,812) (5,812) (5,812) $ 20,046,930 $ 20,041,118 $ (5,812) 94 Supplemental Information COUNTY OF WELD STATE OF COLORADO EXPLANATIONS OF FUNDS December 31, 2011 NON -MAJOR GOVERNMENTAL FUNDS Special Revenue Funds Special revenue funds account for taxes or other earmarked revenue of the County that finances specified activities as required by law or administrative action. Conservation Trust Fund: The Conservation Trust Fund accounts for revenue received from the State of Colorado to be used for the acquisition, development and maintenance of new and existing conservation sites within Weld County. The funds are derived from the Colorado State Lottery. Emergency Fund: The Emergency Fund accounts for the "Emergency Reserve" required by "Amendment One" to the Colorado Constitution. Public Health Fund: The Weld County Public Health Department provides health services to County residents. The fund reflects revenue and expenditures for health care, health education, health monitoring and other related activities. Solid Waste Fund: This fund accounts for revenue received from a surcharge on dumping fees at solid waste disposal sites for the purpose of combating environmental problems and for the further improvement and development of landfill sites within the County. Law Enforcement Authority Funds These funds accounts for the revenue of the law enforcement authority. The authority is a taxing unit created by the County to provide additional law enforcement services by the County Sheriff to residents in a developed unincorporated area of the County 95 COUNTY OF WELD STATE OF COLORADO EXPLANATIONS OF FUNDS December 31, 2011 PROPRIETARY FUNDS Enterprise Funds Enterprise funds account for operations that are financed and operated in a manner similar to private business enterprises where the intent of the governing body is that the costs (expenses including depreciation) of providing goods or services to the general public on a continuing basis be financed or recovered primarily through user charges; or where the governing body has d ecided that periodic determination or revenue earned, expenses incurred, and/or net income is appropriated for capital maintenance, public policy, management control, accountability or other purposes. Paramedic Services Fund: This fund accounts for the ambulance services provided to Weld County. Internal Service Funds Motor Vehicle Fund: This fund accounts for the revenue and costs generated by equipment and vehicles rented to various departments of the County. Health Insurance Fund: This fund accounts for the County's self -insured dental and vision coverage. Revenue is generated from contributions from the employees of the County. Disbursements are made after insured claims have been verified and approved. Insurance Fund: This fund accounts for all insurance costs for the County, except health insurance. This program is a combination of insured risks and protected self-insurance risks. Phone Services Fund: This fund accounts for all phone costs provided to the County and other outside agencies on a cost - reimbursement basis. 96 COUNTY OF WELD STATE OF COLORADO EXPLANATIONS OF FUNDS December 31, 2011 FIDUCIARY FUNDS Agency Funds Agency funds account for assets held by the County as an agent for individuals, private organizations and/or other governments. General Agency Fund: This fund account for all monies collected (principally tax collections) by the Weld County Treasurer for various other local governmental units within the County. Payroll Agency Fund: This fund accounts for the accumulation of County payrolls and related withholdings. Disbursements are made to the appropriate financial institutions through the payroll direct deposit system and the various vendors for the withholdings. Employee Flexible Spending: This fund accounts for Weld County's Section 125, voluntary tax-sheltered plan, which the County administers directly. Employee contributions to the plan are refunded upon submission of documentation for un-reimbursed claims. 97 COUNTY OF WELD STATE OF COLORADO EXPLANATIONS OF FUNDS December 31, 2011 COMPONENT UNITS Component units are tied to the County with some board control. They operate as a separate fund but the information is discretely presented. Housing Authority Fund: This fund works with all the low income citizens of Weld County to help with rent assistance or housing repair. E-911 Authority Fund: This fund operates under state statute, Article 11 of Title 29, C.R.S.. They are responsible for administering the operations of the 911 emergency telephone service program in Weld County 98 99 COUNTY OF WELD STATE OF COLORADO Combining Balance Sheet Non -Major Governmental Funds December 31, 2011 Conservation Emergency Public Health Trust Fund Fund Fund ASSETS Cash and cash equivalents Receivables (net of allowance for uncollectibles): Current property taxes Delinquent property taxes Accounts Inventories Other assets Total Assets LIABILITIES AND FUND BALANCES Liabilities: Accounts payable Accrued liabilities Other liabilities Unearned revenue Unexpended grant revenue Total Liabilities Fund Balances: Nonspendable Restricted Committed Total Fund Balances Total Liabilities and Fund Balances $ 289,369 $ - $ 1,581,684 698,610 1,394 $ 289,369 $ - $ 2,281,688 - - 117,534 - - 216,008 - - 131,160 - 464,702 1,394 289,369 - 1,815,592 289,369 - 1,816,986 $ 289,369 $ - $ 2,281,688 100 Total Law Nonmajor Solid Waste Enforcement Governmental Fund Authority Fund Funds $ 568,828 $ 116,758 $ 685,586 $ $ 2,439,881 815,368 1,394 $ 3,256,643 369 - 117,903 216,008 - 131,160 369 - 465,071 1,394 - - 2,104,961 685,217 - 685,217 685,217 - 2,791,572 $ 685,586 $ $ 3,256,643 101 COUNTY OF WELD STATE OF COLORADO Combining Statement of Revenues, Expenditures and Changes in Fund Balances Non -Major Governmental Funds For the fiscal year ended December 31, 2011 Conservation Emergency Public Health Trust Fund Fund Fund REVENUES: Taxes: Taxes Intergovernmental Charges for services Miscellaneous Total Revenues EXPENDITURES: Current: Public Safety Public health and welfare Culture and recreation Capital outlay Total Expenditures Excess of Revenues Over (Under) Expenditures Other Financing Sources (Uses): Transfers - In Transfers - Out Total Other Financing Sources (Uses) Net Change in Fund Balances Fund Balances at Beginning of Year Prior Period Adjustment (Footnote 1(D)) Beginning Fund Balance Restated Fund Balances at End of Year $ $ - $ 376,030 - 2,838,565 1,353,155 3,513 - 248,943 379,543 - 4,440,663 7,692,073 362,707 - - 72,131 362,707 - 7,764,204 16,836 - (3,323,541) 16,836 272,533 6,000,000 (6,000,000) 3,109,977 3,109,977 (213,564) 2,030,550 272,533 - 2,030,550 $ 289,369 $ $ 1,816,986 102 Solid Waste Fund $ 836,567 836,567 99,708 99,708 736,859 592,909 (592,909) 143,950 541,267 541,267 Law Enforcement Authority Funds $ 26,613 26,613 26,613 26,613 $ 685,217 $ Total Nonmajor Governmental Funds $ 26,613 3,214,595 2,189,722 252,456 5,683,386 126,321 7,692,073 362,707 72,131 8,253,232 (2,569,846) 3,109,977 592,909 2,517,068 (52,778) 8,844,350 (6,000,000) 2,844,350 $ 2,791,572 103 COUNTY OF WELD STATE OF COLORADO Capital Expenditures Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budgeted REVENUES General property taxes Penalties & interest Total Taxes Fees Earnings on deposits Miscellaneous Total Revenues EXPENDITURES Capital Outlay: Buildings Total Expenditures Other Financing Sources (Uses): Transfers - In: General Fund Total Other Financing Sources Net Change in Fund Balance Fund Balance at Beginning of Year Fund balance at End of Year Original Final Actual Variance $ 6,600,000 $ 6,600,000 $ 6,581,277 $ (18,723) - 7,935 7,935 6,600,000 100,000 100,000 6,800,000 6,818,142 6,818,142 (18,142) 6,381,019 $ 6,362,877 6,600,000 100,000 100,000 6,800,000 12, 318,142 12,318,142 5,500,000 5,500,000 6,589,212 61,103 109,819 36,412 6,796,546 7,108,626 7,108,626 5,500,000 5,500,000 (18,142) 5,187,920 6,381,019 6,381,019 (10,788) (38,897) 9,819 36,412 (3,454) 5,209,516 5,209,516 5,206,062 $ 6,362,877 $ 11,568,939 $ 5,206,062 104 COUNTY OF WELD STATE OF COLORADO Conservation Trust Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budgeted Original Final Actual Variance REVENUES Intergovernmental: State lottery Miscellaneous: Earnings on deposits Total Revenues EXPENDITURES Culture and Recreation: Land improvements Capital Expenditures Total Expenditures Net Change in Fund Balance Fund Balances at Beginning of Year Fund balances at End of Year $ 410,000 $ 410,000 $ 376,030 $ (33,970) 5,000 5,000 3,513 (1,487) 415,000 415,000 379,543 (35,457) 362,707 52,293 362,707 52,293 415,000 415,000 362,707 52,293 362,707 52,293 16,836 272,533 272,533 272,533 16,836 $ 272,533 $ 272,533 $ 289,369 $ 16,836 105 COUNTY OF WELD STATE OF COLORADO Emergency Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budgeted REVENUES Taxes: Total Revenues EXPENDITURES Net Change in Fund Balance Fund Balances at Beginning of Year Prior Period Adjustment (Footnote 1(D)) Beginning Fund Balance Restated Fund Balances at End of Year Original Final $ - $ 6,000,000 (6,000,000) 6,000,000 6,000,000 (6,000,000) 6,000,000 6,000,000 $ - $ 6,000,000 Actual 6,000,000 (6,000,000) Variance 6,000,000 6,000,000 (6,000,000) (6,000,000) - $ 106 COUNTY OF WELD STATE OF COLORADO Public Health Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budgeted REVENUES Intergovernmental: State grants Federal grants Counties Total Intergovernmental Charges for Services: Charges for services Total Charges for Services Miscellaneous: Fees and fines Other Donations Total Miscellaneous Total Revenues EXPENDITURES Public Health and Welfare: Public health administration Health education Nursing Environmental health Public Health Preparedness Total Public Health and Welfare Capital Outlay: Nursing Environmental health Public Health Preparedness Total Capital Outlay Total Expenditures Other Financing Sources (Uses): Transfers - In: Non Departmental Total Other Financing Sources Net Change in Fund Balance Fund Balances at Beginning of Year Fund Balance at End of Year Original Final Actual Variance $ 3,059,487 $ 3,059,487 $ 2,836,065 $ (223,422) 3,202,068 3,202,068 6,261,555 6,261,555 1,287,442 1,287,442 1,287,442 1,287,442 2,500 42,000 44,500 2,500 13,000 29,000 44,500 7,593,497 7,593,497 172,000 586,490 4,867,863 2,331,655 143,398 172,000 1,001,741 4,108,485 2,432,039 387,141 8,101,406 8,101,406 8,101,406 8,101,406 507,909 507,909 2,500 2,500 - (3,202,068) 2,838,565 (3,422,990) 1,353,155 1,353,155 7,799 209,247 31,897 248,943 65,713 65,713 5,299 196,247 2,897 204,443 4,440,663 (3,152,834) 210,319 907,295 3,953,578 2,428,824 192,057 7,692,073 5,595 18,304 48,232 72,131 7,764,204 (92,091) 3,109,977 (92,091) 3,109,977 (600,000) (213,564) 2,030,550 2,030,550 2,030,550 (38,319) 94,446 154,907 3,215 195,084 409,333 (5,595) (18, 304) (48,232) (72,131) 337,202 3,202,068 3,202,068 386,436 $ 2,030,550 $ 1,430,550 $ 1,816,986 $ 386,436 107 COUNTY OF WELD STATE OF COLORADO Solid Waste Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budgeted Original Final Actual Variance REVENUES Landfill surcharge Total Revenues EXPENDITURES Miscellaneous: Solid waste Total Expenditures Other Financing Sources (Uses): Transfers - Out: General Fund Health department Total Other Financing Sources (Uses) Net Change in Fund Balance Fund Balances at Beginning of Year $ 685,000 $ 685,000 $ 836,567 $ 151,567 685,000 685,000 92,091 92,091 92,091 92,091 85,000 507,909 (592,909) 85,000 507,909 836,567 151,567 99,708 (7,617) 99,708 (7,617) 85,000 507,909 (592,909) (592,909) 143,950 143,950 541,267 541,267 541,267 Fund Balances at End of Year $ 541,267 $ 541,267 $ 685,217 $ 143,950 108 COUNTY OF WELD STATE OF COLORADO Bebee Draw Law Enforcement Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budgeted Original Final Actual Variance REVENUES Taxes: General property taxes Specific ownership taxes Total Revenues EXPENDITURES Miscellaneous Total Expenditures Net Change in Fund Balance Fund Balances at Beginning of Year Fund Balances at End of Year $ 12,866 $ 12,866 $ 12,867 $ 1 1,000 1,000 926 (74) 13,866 13,866 13,866 13,866 13,866 13,866 $ - $ 13,793 (73) 13,793 73 13,793 73 $ - $ 109 COUNTY OF WELD STATE OF COLORADO South West Law Enforcement Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budgeted Original Final Actual Variance REVENUES Taxes: General property taxes Total Revenues EXPENDITURES Miscellaneous Total Expenditures Net Change in Fund Balance Fund Balances at Beginning of Year Fund Balances at End of Year $ 10,956 $ 10,956 $ 11,386 $ 430 10,956 10,956 10,956 10,956 10,956 10,956 $ - $ 11,386 430 11,386 (430) 11,386 (430) $ - $ 110 COUNTY OF WELD STATE OF COLORADO Pioneer Community Law Enforcement Fund Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budgeted Original Final Actual Variance REVENUES Taxes: General property taxes Specific ownership taxes Penalties & Interest Total Revenues EXPENDITURES Miscellaneous Total Expenditures Net Change in Fund Balance Fund Balances at Beginning of Year Fund Balances at End of Year $ 1,144 $ 1,144 $ 1,315 $ 171 - 82 82 - 37 37 1,144 1,144 1,144 1,144 1,144 1,144 $ - $ 1,434 290 1,434 (290) 1,434 (290) $ - $ III COUNTY OF WELD STATE OF COLORADO Housing Authority Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budgeted Original Final Actual Variance REVENUES Intergovernmental: Federal Grants State Grants Total Intergovernmental Miscellaneous: Earnings on deposits Miscellaneous Total Miscellaneous Total Revenues EXPENDITURES Rent assistance Supplies Depreciation Total Expenditures Net Change in Fund Balance Fund Balances at Beginning of Year $ - $ 2,688,904 2,688,904 2,688,904 2,688,904 2,688,904 2,688,904 $ - $ 2,760,855 71,951 2,760,855 71,951 9,258 9,258 87,429 87,429 96,687 96,687 2,857,542 168,638 2,391,168 2,391,168 2,392,007 (839) 272,220 272,220 324,908 (52,688) 22,854 (22,854) 2,663,388 2,663,388 2,739,769 (76,381) 25,516 25,516 117,773 2,464,320 2,464,320 2,464,320 92,257 Fund Balances at End of Year $ 2,489,836 $ 2,489,836 $ 2,582,093 $ 92,257 1ll COUNTY OF WELD STATE OF COLORADO E-911 Authority Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual For the fiscal year ended December 31, 2011 Budgeted REVENUES Miscellaneous: Earnings on deposits Charge for service Total Revenue EXPENDITURES Depreciation Purchased services Supplies Total Expenditures Net Change in Fund Balance Fund Balances at Beginning of Year Fund Balances at End of Year Original Final $ 40,000 $ 40,000 2,165,000 2,165,000 2,205,000 2,205,000 121,000 1,867,176 502,657 2,490,833 (285,833) 5,241,349 121,000 1,867,176 502,657 2,490,833 (285,833) 5,241,349 $ 4,955,516 $ 4,955,516 Actual $ 31,397 2,351,667 2,383,064 353,231 2,112,131 76,526 2,541,888 (158,824) 5,241,349 Variance $ (8,603) 186,667 178,064 (232,231) (244,955) 426,131 (51,055) 127,009 $ 5,082,525 $ 127,009 113 The public report burden for this information collection is estimated to average 380 hours annually. Financial Planning 02/01 Form # 350-050-36 LOCAL HIGHWAY FINANCE REPORT City or County: Weld YEAR ENDING : December 2011 This Information From The Records Of County of Weld: Prepared By: Barbara Connolly Phone: (970) 356-4000 X 4445 I. DISPOSITION OF HIGHWAY -USER REVENUES AVAILABLE FOR LOCAL GOVERNMENT EXPENDITURE ITEM 1. Total receipts available A. Local Motor -Fuel Taxes PURPOSES B. Local Motor -Vehicle Taxes III. DISBURSEMENTS AND C. Receipts from State Highway- User Taxes FOR STREET PURPOSES D. Receipts from Federal Highway Administration ROAD 2. Minus amount used for collection expenses 3. Minus amount used for nonhighway purposes 4. Minus amount used for mass transit 5. Remainder used for hi:hwa . Doses II. RECEIPTS FOR ROAD AND STREET ITEM AMOUNT ITEM AMOUNT A. Receipts from local sources: A. Local highway disbursements: 1. Local highway -user taxes 1. Capital outlay (from page 2) 7,105,923 a. Motor Fuel (from Item I.A.5.) 2. Maintenance: 18,008,173 b. Motor Vehicle (from Item I.B.5.) 3. Road and street services: c. Total (a.+b.) a. Traffic control operations 2. General fund appropriations 7,100,000 b. Snow and ice removal 609,707 3. Other local imposts (from page 2) 12,723,107 c. Other 199,304 4. Miscellaneous local receipts (from page 2) 1,983,956 d. Total (a. through c.) 809,011 5. Transfers from toll facilities 4. General administration & miscellaneous 2,651,476 6. Proceeds of sale of bonds and notes: 5. Highway law enforcement and safety a. Bonds - Original Issues 6. Total (1 through 5) 28 574 583 b. Bonds - Refunding Issues B. Debt service on local obligations: c. Notes 1. Bonds: d. Total (a. + b. + c.) 0 a. Interest 7. Total (1 through 6) 21,807,063 b. Redemption B. Private Contributions c. Total a. + b. 0 C. Receipts from State government (from page 2) 2. Notes: 11,801,781 a. Interest D. Receipts from Federal Government (from page 2) b. Redemption 83,397 c. Total (a. + b.) 0 Total 3. Total (1.c + 2.c) 0 E. recei its (A.7 + B + C + D) 33,692,241 C. Payments to State for highways D. Payments to toll facilities E. Total disbursements (A.6 + B.3 + C + D) 28,574,583 IV. LOCAL HIGHWAY (Show all entries DEBT STATUS at par) Opening Debt Amount Issued Redemptions Closing Debt A. Bonds Total 0 1. Bonds efundin Portion B. otes ota ) ) V. LOCAL ROAD AND STREET FUND BALANCE A. Beginning Balance B. Total Receipts IC. Total Disbursement4 D. Ending Balance E. Reconciliation 25,074,868 33,692,241 I 28,574,583 1 30,192,526 0 Notes and Comments: FORM FHWA-536 (Rev. 1-05) PREVIOUS EDITIONS OBSOLETE 1 (Next Page) 114 2011 Local Highway Finance Report.xlsx LOCAL HIGHWAY FINANCE REPORT STATE: Colorado YEAR ENDING (mm/yy): December 2011 II. RECEIPTS FOR ROAD AND STREET PURPOSES - DETAIL ITEM AMOUNT ITEM AMOUNT A.3. Other local im I osts: A.4. Miscellaneous local recei its: a. Property Taxes and Assessments 6 980,331 a. Interest on investments 48,274 b. Other local imposts: b. Traffic Fines & Penalities 1. Sales Taxes c. Parking Garage Fees 2. Infrastructure & Impact Fees d. Parking Meter Fees 3. Liens e. Sale of Surplus Property 4. Licenses f. Charges for Services 586,636 5. Specific Ownership &/or Other 5,742,776 g. Other Misc. Receipts 990,972 6. Total (1. through 5.) 5,742,776 h. Other 358,074 c. Total a. + b. 12,723,107 (Ca forward to .a_e 1) i. Total a. through h. 1,983,956 (Ca forward to .a_e I) ITEM AMOUNT ITEM AMOUNT C. Recei i ts from State Government D. Recei i ts from Federal Government 1. Hi:hwa -user taxes 9,709,065 1. FHWA from Item I.D.5. 2. State general funds 2. Other Federal agencies: 3. Other State funds: a. Forest Service 49,666 a. State bond proceeds b. FEMA b. Project Match c. HUD c. Motor Vehicle Registrations 328,671 d. Federal Transit Admin d. Other (Specify) 36,173 e. U.S. Corps of Engineers e. Other (Specify) 1,727,872 f. Other Federal 33,731 f. Total (a. through e.) 2,092,716 g. Total (a. through f.) 83,397 4. Total 1. + 2. + 3. III. DISBURSEMENTS 11,801,781 FOR ROAD AND STREET 3. Total 1. + 2.: PURPOSES - DETAIL (Carry forward to page 1) A.1. Ca i ital outla : a. Right -Of -Way Costs ON NATIONAL HIGHWAY SYSTEM a OFF NATIONAL HIGHWAY SYSTEM b 80,416 TOTAL (c) 80,416 b. En:ineerin: Costs c. Construction: 912,068 912,068 0 (1). New Facilities (2). Capacity Improvements 2,868,842 2,868,842 (3). System Preservation 3,244,597 3,244,597 (4). System Enhancement & Operation 0 (5). Total Construction (1) + (2) + (3) + (4) 0 6,113,439 6,113,439 d. Total Ca , ital Outla Lines 1.a. + l .b. + 1.c.5 0 7,105,923 7,105,923 (Carry forward to page I) Notes and Comments: FORI'sl FHWA-536 (Rev.1-05) PREVIOUS EDITIONS OBSOLETE 2 115 COUNTY OF WELD STATE OF COLORADO Combining Statement of Net Assets Internal Service Funds December 31, 2011 Motor Vehicle Health Fund Insurance Fund Insurance Fund ASSETS Current Assets: Cash and cash equivalents Receivables (net of allowances for uncollectables): Current property taxes Delinquent property taxes Accounts Due from other county funds Inventories Other assets Total current assets Fixed assets: Improvements other than buildings Construction in Progress Buildings Machinery and equipment Accumulated depreciation Total Fixed Assets Total assets LIABILITIES AND NET ASSETS Current Liabilities: Accounts payable Accrued liabilities Due to other county funds Deferred revenue Total Current Liabilities Total Liabilities Net Assets Invested in capital assets Restricted for: Insurance Claims Unrestricted Total net assets $ 3,271,750 $ 4,229,294 $ 3,255,868 22,293 80,181 283,755 3,657,979 580,500 1,800,977 31,277,160 (20,068,480) 13,590,157 129,939 1,767,490 4,854 284,185 4,359,233 5,312,397 $ 17,248,136 $ 4,359,233 $ 5,312,397 $ 463,633 $ 9,816 $ 241,706 - 2,231,336 2,181,823 1,769 135,114 1,021,405 1,777,483 465,402 3,397,671 4,201,012 465,402 3,397,671 4,201,012 13,590,157 3,192,577 961,562 1,111,385 $ 16,782,734 $ 961,562 $ 1,111,385 116 Phone Services Total Internal Fund Service Funds $ 1,024,023 $ 11,780,935 - 1,767,490 - 4,854 15,947 38,240 - 129,939 - 80,181 67,775 635,715 1,107,745 14,437,354 65,021 2,127,416 (1,534,449) 657,988 $ 1,765,733 580,500 65,021 1,800,977 33,404,576 (21,602,929) 14,248,145 $ 28,685,499 $ 1,773 $ 716,928 17,812 4,430,971 245 137,128 - 2,798,888 19,830 8,083,915 19,830 8,083,915 657,988 14,248,145 1,087,915 2,072,947 4,280,492 $ 1,745,903 $ 20,601,584 117 COUNTY OF WELD STATE OF COLORADO Combining Statement of Revenues, Expenses and Changes in Net Assets Internal Service Funds For the fiscal year ended December 31, 2011 Operating revenues: Employer & Employee Premiums Charges for services Total operating revenues Operating expenses: Personnel services Supplies Purchased services Insurance and bonds Depreciation Other Claims Total operating expenses Operating income (loss) Nonoperating revenues (expenses): Taxes Miscellaneous Interest income Gain (loss) on disposition of assets Judgements and damages Total nonoperating revenues (expenses) Income (loss) before contributions and transfers Transfers in Changes in net assets Total net assets - beginning Total net assets - ending Motor Vehicle Fund 8,179,382 8,179, 382 2,655,068 3,027,744 2,803,647 50,005 8,536,464 (357,082) 100 667,659 667,759 310,677 800,000 1,110,677 15,672,057 $ 16, 782, 734 Health Insurance Fund Insurance Fund $ 13,119,007 $ 13,119,007 90,648 591,769 213 13,182,101 13,864,731 (745,724) 113,861 113,861 (631,863) (631,863) 1,593,425 $ 961,562 148,047 148,047 1,304 34,010 563,806 1,476,101 2,075,221 (1,927,174) 1,499,661 49,766 71,044 1,620,471 (306,703) (306,703) 1,418,088 $ 1,111,385 118 Phone Services Fund $ 1,146,249 1,146,249 161,492 32,242 701,345 202,526 55,506 1,153,111 (6,862) (2,502) (2,502) (9,364) 250,000 240,636 1,505,267 $ 1,745,903 Total Internal Set -vice Funds $ 13,119,007 9,473,678 22,592,685 161,492 2,779,262 4,354,868 563,806 3,006,173 105,724 14,658,202 25,629,527 (3,036,842) 1,499,661 113,961 49,766 665,157 71,044 2,399,589 (637,253) 1,050,000 412,747 20,188,837 $ 20,601,584 119 COUNTY OF WELD STATE OF COLORADO Combining Statement of Cash Flows Internal Service Funds For the fiscal year ended December 31, 2011 Motor Vehicle Health Insurance Insurance Fund Fund Fund CASH FLOWS FROM OPERATING ACTIVITIES Cash flows from external customers Cash flows from internal customers Cash payments to external suppliers for goods and services Cash payments to internal suppliers for goods and services Cash payments to employees for services Judgements/damages/losses Miscellaneous revenues Net cash provided (used) by operating activities CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES Taxes Transfers/Advances Net cash provided by noncapital financing activities CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES Acquisition of capital assets Proceeds from sale of capital assets financing activities 143,014 - 100,930 7,840,638 13,139,534 164,047 (5,814,296) (13,617,425) (1,876,322) (95,766) (5,137) (16,055) - - 71,044 100 113,861 2,073,690 800,000 (369,167) (1,556,356) - 1,497,791 800,000 - 1,497,791 (2,865,844) 597,737 (2,268,107) CASH FLOWS FROM INVESTING ACTIVITIES Interest on investments - - 51,636 Net Increase (decrease) in Cash and Cash Equivalents Cash and Cash Equivalents at Beginning of Year Cash and Cash Equivalents at End of Year Reconciliation of operating income to net cash provided (used) by operating activities: Operating income (loss) Adjustments to reconcile operating income to net cash provided (used ) by operating activities: Depreciation expense Judgements/damages/losses Miscellaneous revenue Change in assets and liabilities (Increase) decrease in accounts receivable (Increase) decrease in due from other funds (Increase) decrease in inventories (Increase) decrease in other assets Increase (decrease) in accounts payable Increase (decrease) in accrued liabilities Increase (decrease) in other liabilities Increase (decrease) in deferred revenue Total adjustments Net cash provided (used) by operating activities 605,583 (369,167) (6,929) 2,666,167 4,598,461 3,262,797 3,271,750 4,229,294 3,255,868 (357,082) (745,724) (1,927,174) 2,803,647 - - 71,044 100 113,861 (1,520) - (233,827) 8,049 (129,939) 16,000 2,843 - - (283,755) 38,762 (8,697) (100,361) (35,978) 135,505 - 250,383 154,610 1,769 135,063 - - 4,405 236,183 2,430,772 2,073,690 Noncash investing, capital, and financing activities: Loss on Disposal of Asset 19,126 376,557 370,818 (369,167) (1,556,356) 120 Phone Service Total Internal Fund Service Funds 135,918 379,862 1,014,633 22,158,852 (753,379) (22,061,422) (99,110) (216,068) (158,669) (158,669) - 71,044 - 113,961 139,393 287,560 250,000 1,497,791 1,050,000 250,000 2,547,791 (335,914) (3,201,758) 597,737 (335,914) (2,604,021) - 51,636 53,479 282,966 970,544 11,497,969 1,024,023 11,780,935 (6,862) (3,036,842) 202,526 3,006,173 - 71,044 - 113,961 4,285 (231,062) - (105,890) - 2,843 (60,934) (314,624) (2,470) (3,304) 2,603 407,596 245 137,077 - 240,588 146,255 3,324,402 139,393 287,560 - 19,126 121 COUNTY OF WELD STATE OF COLORADO Combining Statement of Changes in Assets and Liabilities Fiduciary Funds For the fiscal year ended December 31, 2011 GENERAL AGENCY FUND Assets: Cash and short-term investments Total Assets Liabilities: Accounts payable Due to other governments Total Liabilities PAYROLL AGENCY FUND Assets: Cash and short-term investments Accounts receivable Total Assets Liabilities: Accounts payable Total Liabilities EMPLOYEE FLEXIBLE SPENDING Assets: Cash and short-term investments Total Assets Liabilities: Accounts payable Total Liabilities TOTAL - ALL AGENCY FUNDS Assets: Cash and short-term investments Accounts receivable Total Assets Liabilities: Accounts payable Due to other governments Total Liabilities Balance 1/1/2011 Additions Deductions Balance 12/31/2011 $ 4,718,063 $ 264,646,977 $ 262,483,292 $ 6,881,748 $ 4,718,063 $ 264,646,977 $ 262,483,292 $ 6,881,748 $ - $ 88,088 $ 7,000 4,718,063 268,347,405 266,264,808 $ 81,088 6,800,660 $ 4,718,063 $ 268,435,493 $ 266,271,808 $ 6,881,748 $ 53,175 $ 19,280,975 $ 19,303,832 $ 30,318 0 13,663 1,322 12,341 $ 53,175 $ 19,294,638 $ 19,305,154 $ 42,659 $ 53,175 $ 19,802,314 $ 19,812,830 42,659 $ 53,175 $ 19,802,314 $ 19,812,830 $ 42,659 $ 74,239 $ 684,596 $ 686,873 $ 71,962 $ 74,239 $ 684,596 $ 686,873 $ 71,962 $ 74,239 $ 71,962 $ 74,239 $ 71,962 $ 74,239 $ 74,239 $ 4,845,477 $ 284,612,548 $ 282,473,997 0 13,663 1,322 $ 4,845,477 $ 284,626,211 $ 282,475,319 $ 6,996,369 71,962 $ 71,962 $ 6,984,028 12,341 $ 127,414 $ 19,962,364 $ 19,894,069 $ 195,709 4,718,063 268,347,405 $ 266,264,808 6,800,660 $ 4,845,477 $ 288,309,769 $ 286,158,877 $ 6,996,369 122 COUNTY OF WELD STATE OF COLORADO Paramedic Services Fund Schedule of Revenues, Expenses and Changes in Net Assets - Budget and Actual For the fiscal year ended December 31, 2011 Budgeted Original Final Actual Variance Operating Revenues: Rescue unit fees Total Operating Revenues Operating Expenses: Personnel services Supplies Purchased services Depreciation Other Total Operating Expenses Operating Income (Loss) Nonoperating Revenues: State grants Fees Other Gain (loss) on disposition of assets Total Nonoperating Revenues Income(loss) before contributions and transfers Net Income (Loss) Net Assets at Beginning of Year $ 5,646,856 $ 6,092,507 $ 6,273,982 $ 181,475 5,646,856 6,092,507 6,273,982 181,475 4,276,712 4,366,712 4,270,591 96,121 275,100 345,100 325,459 19,641 732,950 832,950 892,611 (59,661) 308,919 423,919 424,708 (789) 33,175 33,175 22,426 10,749 5,626,856 6,001,856 20,000 90,651 5,935,795 66,061 338,187 247,536 217,936 222,937 5,001 12,803 12,803 4,800 4,800 (32,000) (13,799) 18,201 185,936 226,741 40,805 20,000 276,587 20,000 276,587 564,928 288,341 564,928 288,341 4,185,278 4,185,278 4,185,278 Net Assets at end of Year $ 4,205,278 $ 4,461,865 $ 4,750,206 $ 288,341 123 COUNTY OF WELD STATE OF COLORADO Motor Vehicle Fund Schedule of Revenues, Expenses and Changes in Net Assets - Budget and Actual For the fiscal year ended December 31, 2011 Budgeted Operating Revenues: Charges for services Miscellaneous Total Operating Revenues Operating Expenses: Supplies Purchased services Depreciation Other Total Operating Expenses Operating income (loss) Nonoperating Revenues (Expenses): Miscellaneous Gain (loss) on disposition of assets Total Nonoperating Revenues(Expenses) Income(Loss) before contributions and transfers Transfers in Net Income (Loss) Net Assets at Beginning of Year Net Assets at End of Year Original Final Actual Variance $ 4,500,000 $ 4,943,000 $ 5,368,977 $ 425,977 2,800,000 2,800,000 2,810,405 10,405 7,300,000 7,743,000 2,021,000 2,838,500 2,800,000 50,005 7,709,505 (409,505) 419,505 419,505 10,000 10,000 15,672,057 $ 15,682,057 2,021,000 2,838,500 2,800,000 50,005 7,709,505 33,495 476,505 476,505 510,000 800,000 1,310,000 15,672,057 $ 16,982,057 8,179,382 2,655,068 3,027,744 2,803,647 50,005 8,536,464 436,382 (634,068) (189,244) (3,647) (826,959) (357,082) (390,577) 100 667,659 667,759 310,677 800,000 1,110,677 15,672,057 100 191,154 191,254 (199,323) (199,323) $ 16,782,734 $ (199,323) 124 COUNTY OF WELD STATE OF COLORADO Health Insurance Fund Schedule of Revenues, Expenses and Changes in Net Assets - Budget and Actual For the fiscal year ended December 31, 2011 Budgeted Operating Revenues: Employer & Employee Premiums Operating Expenses: Supplies Purchased services Other Claims Total Operating Expenses Operating Income (Loss) Nonoperating Revenues (Expenses): Miscellaneous Net Income (Loss) Net Assets at Beginning of Year Net Assets at End of Year Original Final Actual Variance $ 13,344,968 $ 14,270,968 $ 13,119,007 $ (1,151,961) 634,330 1,425,627 11,285,011 13, 344, 968 634,330 1,425,627 12,211,011 14,270,968 90,648 591,769 213 13,182,101 13, 864, 731 (745,724) 113,861 (631,863) 1,593,425 1,593,425 1,593,425 $ 1,593,425 $ 1,593,425 $ 961,562 (90,648) 42,561 1,425,414 (971,090) 406,237 (745,724) 113,861 (631,863) $ (631,863) 125 COUNTY OF WELD STATE OF COLORADO Insurance Fund Schedule of Revenues, Expenses and Changes in Net Assets - Budget and Actual For the fiscal year ended December 31, 2011 Budgeted Operating Revenues: Charges for services Operating Expenses: Supplies Purchased services Insurance and bonds Other Claims Total Operating Expenses Operating Income (Loss) Nonoperating Revenues (Expenses): Taxes Penalties & interest Interest income Judgments and damages Total Nonoperating Revenues (Expenses) Net Income (Loss) Net Assets at Beginning of Year Net Assets at End of Year Original Final $ 250,000 $ 250,000 3,500 46,700 700,000 500 1,099,300 1,850,000 (1,600,000) 1,500,000 60,000 40,000 1,600,000 1,418,088 3,500 46,700 700,000 500 1,099,300 1,850,000 (1,600,000) 1,500,000 60,000 40,000 1,600,000 1,418,088 Actual Variance $ 148,047 $ (101,953) 1,304 34,010 563,806 1,476,101 2,075,221 2,196 12,690 136,194 500 (376,801) (225,221) (1,927,174) (327,174) 1,497, 791 1,870 49,766 71,044 1,620,471 (306,703) 1,418,088 (2,209) 1,870 (10,234) 31,044 20,471 (306,703) $ 1,418,088 $ 1,418,088 $ 1,111,385 $ (306,703) 126 COUNTY OF WELD STATE OF COLORADO Phone Service Fund Schedule of Revenues, Expenses and Changes in Net Assets - Budget and Actual For the fiscal year ended December 31, 2011 Budgeted Operating Revenues: Charges for services Operating Expenses: Personnel services Supplies Purchased services Depreciation Other Total Operating Expenses Operating Income (Loss) Nonoperating revenues (expenses): Gain (loss) on disposition of assets Total nonoperating revenues (expenses) Transfers: Transfers - in Net Income (Loss) Net Assets at Beginning of Year Net Assets at End of Year Original Final Actual Variance $ 1,441,750 $ 1,441,750 $ 1,146,249 $ (295,501) 156,913 14,100 759,122 206,109 55,506 1,191,750 250,000 250,000 1,505,267 156,913 14,100 759,122 206,109 55,506 161,492 32,242 701,345 202,526 55,506 1,191,750 1,153,111 250,000 250,000 500,000 (4,579) (18,142) 57,777 3,583 38,639 (6,862) (256,862) (2,502) (2,502) 250,000 240,636 1,505,267 1,505,267 (2,502) (2,502) (259,364) $ 1,755,267 $ 2,005,267 $ 1,745,903 $ (259,364) 127 128 Single Audit co O Q Jq N LC M W C[ O W W 03 U_ g o Z O W D W O 0 on O H O Z W O W LU w >- >- U_ W O I W H J O O L_ W 2 0 U) a) O — j - 6 C L D Q1 O C O a) LUL Q W O o W W D OWZFs; O : > Q 0 CC U) W F- H O Z W a x W U) J H a w F -w 0 U) W w OCC Q 0 O W J co OC U) d H et Q Q W U) U) C EXPENDITURES W0_ o W W W < W OW U) CC LL O O W O W W o O Z CC W Cr; Q0W �r Q W p O U_ W U W GRANT DESCRIPTION PASSED THROUGH THE STATE OF COLORADO DEPARTMENT OF HUMAN SERVICES U) 0) 0) COO UD N N M01 r 0) 0) U) U) O CD Ul O CO M N O (D r r M Ul 00 0 0 Ul O) (0 U) 00 U) co O M OD V r r CO CD O 01 CCD CO O 0) N O 0) ) 0 O U tO M O r M O' - M to M M CO M CO C)) 0) N M U) CO (0 CO O CI CO CO IS U) U) M 0) O 0) O r 0-1 CD O N (oUl ' QD 10 r W U) U) U) co O O r r t U a) O 0) CO o 8 IL — CU C C O) «� C O CO U) d aa))aQQ LL CI U o CO L (0 O O O O CO y - N N N r r r r r r CD N N N O N_ M CO SUBTOTAL DEPARTMENT OF AGRICULTURE VI Y- 00) (00 0 c`n0 (NO 00)) ( OD 0`UD ? U) MN co U) (0 N N 0000 O O O O O O O O O O O O O co O O O O O r r r r r O N M 00 f� r r 0) 000000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O co co O co ..... 0 0 O U) N. ' OD ODr 0) CO CO r 00 00 N r � r r r r O ‘art. O M N. V U) (0 CO CO r (0 O M (0 U) 00 r f- U) N W 00 01 N M N U) O 00 h M M U) U) r M U) O 10 V N. O r r r r r O U) (O r r r r r M co r r N N W CD O N 0) 0) N r U) M M r LO CD CI 1c2: g r 0) CO v0' CO (0 0) CO M U) V r lC6 r M (0 10 N r r N M 00) (0 (0 10 ) U) CO U) N N CO V N U) 0) 0) ' N 0) 00 O U) 00 O CO 01 r M CCr 0 0) r CO N OQD NO r V C) r V N CO OD N (h r fl r r r N CO V U) CO V O N (N N II II I III I N U) 0) 0) (0 M U) U) Y.- V M (O (0 N N N_ 0) CO N I O r 0) 00 O U) 00 ' U) U) V (O N r CO O CO O N M r M r r N OD ' 00 U) 00 (0 (O N-- N. 'CD N. O OOO M O 000 N OM) (00 U) O 00 r r V N r V V V V 10 N. 0 0 0 0 O O O O O O h 0/ M M M M M M M M M M 0) O) 0) 0) CO 0) 0) 0) 0) 0) 0) a) i= d) Q O 0 co O C d � To Q U U)ZO CO (0 N N ca) U) CO N CO CO N M CO O r N. N. O 0) N- U) N. 00 N U) N. N U) N. U) 0) U) U) V 10 M U) N r 0) (0 O CO M O) N. ‘3 - co CO U) U) N 0) 0) OD N V OD 'Cr co V CD 00)r MO N ON. 0) LO O N. N U) (O CO V N r 0000000 r N. r M M M O r V CO CO r r 0 r M M N N N O N. CO V M N N 'Cr U U1 Ca 01 CO 01 N co U) M M (O O U1 CD 1"--- ,r op r 0) N N N O r r N h r U) N O O U) (O N O 01 01C00 CO CO N. N- 0") O N r o5 co 0 r N O O cci N tn 00 0) O V N (0 U) N 00 V 0) N 0 N. CO Up 0) U) M CO V V-• O a. 0 m co co = O a o_ d c CD os Q N 5) 5) O a N≥ o2Q 2Q Q co C) ac°)i L 0 U) 0 0 1 0) 7 C o S C w > m mw(n m co OU I. tE L L L a) J E U) Q C o 0) N- ) O D w O) N_ N 0.0>.75>,c, 0 7.5 0 a Q Qco V2O2i'6�a0 m C9 O cm ,9 OO ' W O, W U Q � O (6 � § f6 O O< O Q O O O Q O 2 H N M V U) N. OD CO M U) Ul Ul U1 U1 Ul U1 CO N N N N N N N N U) CO N r r r r r ...... r r r r r r r r r r r O O O O O 0 0 0 0 0 0 N N N N N N N N N N N O N N (O V M O CO U) M V OMO V N A a00 111 V A N (0 O r O V N. r N V N. V N QD N r CD CO r M CD00) 0M) U O M O (3) N 0) r N. V 01 LO CO W r OD 0 U)) 0) N. (O U) U) U) (0 co co M 0) N 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) O 2100 Colorado Works 2100 Child Care 92 2 CO 0 0 77 77 0 0 O O O_ O_ N N r r r r r r r r O O O O N N N N 0000000) w COw w g g g x 77 77 a D V .C .C .C .C .C .C .C 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 r ci r (0 N_ N CO N- 0) N O) N. N Ul CO00) 10 M N. N U) V O M 0 U1 (M 10 O M V N r U) V ' Ca Y— (00 M R (O M N 000000 U) O O 0) r O 0) O O 00 r co O O O N O M N. U) Ul LO U1 U) M O V N 00 01 O N. N h O U) O N 0) V N ONO 000 0) M (0 N. (0 r O M N. N d) N r V r M ) V 0(fl N 0) r CO U) U) 0) N M 1.6 M N N. N. r LO CO Cr CO v N CO ' ' N M IC) r M C(00 000 U) ai u5 N (0 U) CO h U) M c N. V' 0 V O (0 CO N U) 0) ' ' CO N ' U) V- (45 M g r r 00 U) OD 0) h 00 iX r M OD h 00 x U) V U) U) (O N. x CO (0 U) (0 N. x U) CO (O c0 CO h X U) U) (O (0 N x 0 0/ 0/ M 0/ r 0) 0) 0) 0) O 0 0 0 0 0 0 a a a a a a CD 03 03 CD 03 03 0 EEEEEE : a 77 13 -O 77 Q Q Q Q Q Q >. T T >. T T CCCCCC 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N N N N N N N N N N N N N r r r r r r r 0 0 0 0 0 0 0 N N N N N N N r r r r r r 0 0 0 0 0 0 0 N N N N N 0) N. O N O N U) (0 O (0 M 157 op c) cc r Q J CV M W O W 03 LL F- LL W Z O W D W OU j O H O W O W w� w >- } W W O I W H GC O O LL 2 0 Nn 0) L 0) 70 C 700) 0) a X W w is 5 — 03 C O a)0) C W O o W r W W O WZ N O> (c0 w W F- H O Z W a x W 00 J H LTD Ow - GC 00 E- J W d Q W' U O W J co cc U) l— < Q W 00 V) CC EXPENDITURES WO- ce cc W W W OW U) cc LL O O W O W W D 0 O Z N � W M Q0W Ca GRANT DESCRIPTION O Z L LL } 00 N- co 41 r CO O 0) O r O) N- N O O O) 0 W N. co r r I I 0 0 0 0 0 0 0 0 O N- O O O O O O u2 C) to r 000 M a- O W V' O O ( O O N ' to M N- N co V N- NJ- M to 00 O r O) N CO N O) M M V• N r M CO N- O O N ao O OO V N r O M N V• co 0) O) V CO N 00 v CO 00 r N� 00 00 N— co r O) r O) N N ' ' ' M r O) r to O N N.- co O O W 00 to 00 M r r 00 r M 00 O) M 00 N- N- O O t() to r to O N- 42 to (fl (O N- to (O M O C) M 00 0) M C) O) r O) O) O) O) 0) O) CC g Q Q 2 c oc m Q -0Ca Q Q g m < O U o r c c a 0 L LL 1- U- Q D — W W C N O U≥≥Ni Zm (n 0 rn m 0 c o cn 0 (6 (6 0) M (6 E 0 U a)ca caa)a c OOOOOO—a) a a aaa 0•0U -O -0 •O 7D D O) Cn (0 m m a) m m O Q 'v 22292 0 O O O O (0 2 X' Q Q Q Q Q a C C C C C— E 4) O o 0 O o.C 0) !� Z Z Z Z Z O H H 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N N N N N N N N 0 0 0 0 0 0 0 0 N N N N N N N N O O 60) M M N N LO r -- CO r 0000 M O O O N- O V 0 0 0 r 0 0 0 N_ N. N r O O) O CO to V O) O V' CV 01 OO) U) to O N V 0co 00 r to to co O O UP CO to t() O N M N- O) 00 r M O M M0 41- V O N 00 0 N 0 0 r 0 O N 00 W O 6 00 CV V-• CO CO N CO T- r r r r O N 00 N r N- M O) T- N O O O) O O r to O 0 O N M to 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 .- CD O O O O O O O V' N M M O r M V' N- M 00 to O O O O O O O N M M to (O O 00 r W N.: r 0 OO 0 O O O O O 0 W O) O) co co co O M V' r O M 0 0 r 41 0 N OD CO h O) O r r N 0 M 0 0 O N LO 0) 0 M O) O 0O V• r r M to VN N N M O O) NW U) N. O CO M VV O to to CO N Off) O V• V' O N V in r r c0 r to 0co r 0V0•• 000 M N. CO O) O to to N N O) O O O O V• V' CO r CO N N V' N` N V• CO N 00 r V N N. N. M N. r 00 to r r O r 0) r h ' ' t` U ) N O) V N co N V r O N O (CI N V O) CO O) O) 00 r N M to O N. (0 N N V• r r 4 U) I 1 N N N NV CO Ca N I I I I N. N. V• (c cO co. O r V- .14' CO V V N O 0 0 N N N W CO O N V U) r 4°4)U)(ON.01 �(0(0 N 14 LOx N N N N N N CO 00 Core Services U U U 0 0 0 0 0 0 00 Core Services NNNNN N N N 2100 Child Support Enforcement CL CL (O M J J O O O O r r N N r r r r r r O O O O O O O O N N N N N N N N O CO N CO NZ r t• N N N. LO CO00 N 00 CO r O O to co O) V O) CO COCCO O O N r 2100 Aid to Needy Disabled 00 Home Care Allowance 00 Old Age Pension N W 00 o) co to W N r N M ON -M NE) N N OO CM CV N V O) W R N to N O O N- N O M r V V M N 00 to M V' 00 N.- 00 M O V to M •U 00 O M (O N - M N 0) O U) M h N. V' r N. N N N r I I I I I Nt 00 N r N tN O V CV OV•• O O) N- N N.- V• O O to co. U) CO V• V M O) O O O O N r M M N 00 r r r r UP O V-• 1 6 co N COCOU°iNx CO O) r r to N N O W N CO N 0) QD O) M O N- O) N O r r V' V' O N- to CD CD U)Or(ul 00 41 0 O M M N M N r V• N� r 0 r r r N O V t!) O O CO LC) N r Nn 0 O) W LO N 01 O O r O N. T- to N M to I I I I I I CD CV 00 O) tM O c6 6 O 41 N N to r N. 0) N O '0 (0 M to r M 00 O) 00 OO to to N. to (fl (fl to u)(fl(fl N`x LP LO (OCO. N x CO CO CO 0 CO CO 0) CO O CO M co (M O) O) 0) r O) O) O) O) r 0) 0) O) O) N 00 Colorado Refugee Services 00 Title XX Caseworker Training 00 IV -E Independent Living 0 0 0 0 0 0 m (o m (0 (0 m 0 0 0 0 0 0 DDDDDD L L L L L � ca Cl) Ca N y (6 (6 (6 (6 (6 (6 d d d d d d a 0) 0) 0) 0) 0) C C CCC c 00 00 0O 00 0 0 <<<<<C aaaaaO- W 00000 f°(°( (0(0(0 U U U U U U 0 0 0 0 0 0 06 0) O) O) O) 0) O) J. T T J. T M (6 (6 M (0 (0 CCCCCC 0 0 0 0 0 0 U U U U U U 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 EEEEEE 0 0 0 0 0 DDDDDD < < < < < Q 0 0 0 0 0 0 NNNNN NNNNNN NNNNNN 0 0 0 N N N N N O 0 0 0 0 0 0 0 0 0 0 0 0 N N N N N N N N N N N N N O N 0) O O r r CO N 0) O O O N- O U) W to co 0 Q J N W W W pp LL g LL Z O co D W W O OU jLL O H W O w Lu >- >- U- W O= W J � O O LL 2 U U a) O — j Cu - L D C d Q W EXPENDITURES U) J H • a w O w et 07 Lu • Q Q W • U) U) LO W0- W W W < W • OW (1) • LL O O W o W W - o O Z N • W r M Q oWW a Q W • p O LL W U LL GRANT DESCRIPTION CO CO to o) to to N O) r I I I N O r W M 60) N V CD v v 0 0 0 0 0 0 N CO 0 0 0 0 0 N- O O O O O N N- u O 0 0 0 O Lb (0 O N (O r N (O W to O) N r 0) r (3) r N - to O O 6 '—LOU) m LT) M W N O r N to co M O r r r v v Lb to N co r t(7 Cr) CO N- CI). 6 Co Co r r 0) O) CO LO to v O MM vN N CO CO LO to N N CO N C C Q a) 0) O O UO LL LL co co O_ N N ✓ r ✓ r N N CO v M 0) 0 2100 State Incentives I O N I Lb�CO Lb co to co O N N W co V 0) 00 W d 1 r 0 0 0 3 LC) M O ) 0 0 0 0 O O Ng CO CO M co W N L42.01 N O Oro 'Cr V COO r N- v CO LO v d' v r 0 M N LO co Lc) O O to to co a N- r M 'S M N co sr N CCJ- CO N CD CO N- 03 O N • 01 06 0) 0) 0) 0 0 0 0 0 0 0 0 0 0 r r r N N N N N ✓ r r r ✓ r r r- 0 0 0 0 N NNN N 00 Colorado Partnership for Success 00 Use of Excess Parental Fees SB-94 N M N 0) CO 00 Integrated Care Management Incentive N N N 0 0 0 0 0 NNNNN M O) (o n O_ N a O O O M F- M rn w 0 In 'Q N M (o M O) 0) F- (O F- CO (O 0 CO O M N SUBTOTAL DEPARTMENT OF HEALTH AND HUMAN SERVICES PASSED THROUGH COLO DEPT OF HEALTH CARE POLICY AND FINANCE r • O M 00 ✓ (O O 0 O r O (O LO LO to N M (� to N N CO 0) ✓ 6 M (NJ CO N O N N CO N N LO O r r r r O t.() to CO to to T - 0)r 0) r I O r r O CO Lb CO N 0 N CO LO N o (O CO C.6 v W M h h O W CO r- Cn 6 r- 00 00 N 06 06 0)) O) E C W 8) 0 • d a)0 �U) CO W torn 0) 171. LO N (O N r r r r N N TOTAL PASSED THROUGH THE DEPT OF HEALTH CARE POLICY AND FINANCE PASSED THROUGH THE DEPARTMENT OF LOCAL AFFAIRS CO 00 0 0 0 CO CO CO 0 (O CO O CO CO CO O) O) (O M d) v N CO O 0 0 ID-- 0 O O O O O O O O O O O O O O O O co O O co CO L CO CO 6 v M N CO 00 0 0 0 CO CO CO 0 (O CO O CO M CO O) d) (O M M O) Cr CO CO N CO 00 O) 0 N CO N O O) O v CO h M M v vtnm r N I III I III 00 00 O) O N O N O O) 0 v R O M M ✓ vtoco r N ✓ N ' ' 0 0) 0 r O) O) O) 00 N- CO CO (O N CO LO to to N M M M v O O) O) r O) C C a) a) 0 U Q C m (6 c C C 0 O 0 0) a Y Y Y a L U O U E O OU C m m m ° W a) a) a 0) rn U U O (6 C 0) (6 t U N C C C C O J 7 J a) 00 E E E `m U U U w EEE°000E2 tnLC) 000 0) 0) 0 0 0 CO eorOO (� N- N r r CO CO N N ✓ r r r T- O 0 0 0 0 NNNNN N N N O co 0 tf ) N N Co N C` M In TOTAL PASSED THROUGH THE DEPARTMENT OF LOCAL AFFAIRS co O cC r Q J _ W O W W pp LL g LL Z U W D W 0 j O O H O W O W LU >- >- U_ W O I W H J CC O O LL W 2 U U) 0) To.; w 12 L 12 -O) 0) 0Q X W It — 5 — m C C 0 LL W O o W r W W O WZ O> co Q O CC w W F- H O Z W a x W 00 J E- < a w F -w CC 00 H J W w O Q U 0 W J (/) CC 00 CI- H 2' O H I W 00 V) CC EXPENDITURES I— O W W W < W OW U) cC LL O O W O W W D o O Z N CC CC W Cy; W M Qo�a Q W p O LL W U LL GRANT DESCRIPTION PASSED THROUGH THE STATE OF COLORADO DEPARTMENT OF HEALTH N CO ' (O V O N- r r O O CO 0O r O O O N 0000 N OM) O(O CD O M O Or cr M O O O N CO N O co vr C) OO) N r N N N co r r r r N 0 0 0 0 0 0 L O o 0 0 0 0 .2`:-:3 0 0 V N O O O O N UP W O O D O O O O O O N O O O O r N ct O O O O to O O O N N 0 0 0 0 OO) N O O O O O 0 O 0 0 O) O UP V Ca to N N d' O V N.- CC OO) N N r r r r r r r r r r r M Lo (O N- V I Lo r Lo r O r O1 tor- W V N N (fl Ca M V N O N Cr) W r to r M r V' N r 0iA O N N V CD CD U) O O V CO O COOO N CA (O N O r (M to r ct C- (O O O CC N CO d' r Cr) N r N N 6- niN M r r r r N M A M N 1 t` O) r M (O M V r N- V to t` to W O U) O N M r t` (O r to M r CT O W O CO r O ct O O (O O W N- O 4) C- N- O r N ct M O0 V O)) O (O C- W N N- d' M M O C- N O co M N W to 4 W N r O d' d' N CA N N N- t() r ct N r r r N N r N C- Ul N) tQ O I O (O CA N CO LC) r r Ca I I N N CO O) U) N r CO (O CO N to W V u) C- U) M O U) O (O to (- (O r to r CA O Ln O (O O) O O O N W N- O to to W V r N V CO O) V N O r O) N V M O) V O) N O (O M N co U) N CO r O V N CA N N N to r r r r N (O N r 00 up r- (0rO NN Oto N- O W O r - O1 r CO (A Nr co O (O O C� Ni co - V CV N CO O (O N M CA O N - LO L() O) r N (O M 0O r r N N(` N a N W W N M M O) N— co CO r r r CD (O ?sago) W (O Ca r to O) O) O N CA (` O CA N N O) N N O O) r UP O) O) CO M M CO 0) M M M M M M O) O) M O) M M (O CA CA CA CA CA CA CA CA CA CA CT CA CA CT CA CA (`o m CO O 2- o sd cc a oo 0 0 Y Y a O O Ea m C N N O U_ U_ 2 o N (1) CO CO O N .L.. «'C. a) . a) a) c m o aim ri U a CC a -O Q s r 0 0 CC 0 I U U ' 'C C 'O "O c CO Ca 03 M u)dd,y m m m ,>-. > o EE E E E «O+ w CO M m m (n(i(i 222 7 N N V' (O h O (O O) M O M N C) tO (n (o to U) (n U) N N N N N N N co (o Immunization Grants N 2550 Immunization Grants - ARRA C m U o O O O CO 0) Ch CD U_ d a -O 41 C m .C O O O = U D m g3) U 0) c o m � o CD °) co m 2 M O CI QD O O N N or Disease Control and Prevention 2530 Center O O C aa)) 0)) N a) d 0- -CD - (O Ca O O C C U U U o U m a) a) 7 7 co co 0 0 co co cow aac °) o'omm-8 O `O`Oo ° LL C C >. y `m O O m m m m m O O H H r O CA O) W W (O M CO N VP to to to to N N N N N O C m a) 2 U a O d co tN N r r O r r O O O (O O O O O O O O O O O O O O O N N N N N N N N N N N N N N N N N CO LO N O M TOTAL PASSED THROUGH THE STATE DEPARTMENT OF HEALTH PASSED THROUGH COLORADO DEPARTMENT OF TRANSPORTATION cf OD W N (O O N r 0 0 t!) O co co aO co r M F- N (0 V r W r r r Op CD O N CO N (O Wr CD co fT N r Sr t` to N CV O CD (O O (O r r N r r '-Ul CD N CO to O) v a IriC O r r M (A r O ON- In In N O N co co 0 0 N to O O N N C �s C0 O U a. C o o O co O co N r r r r r N N TOTAL PASSED THROUGH COLORADO DEPT OF TRANSPORTATION 160 co O a Jq (V LU LC M O W W 03 u_ W Z O W D W OU j O H O W O W LU w >- >- U_ W O I W H J 0 O L_ W 2 U U) EXPENDITURES U) J E- < O U H W CC U) E- J W w O C U 0 W J CO W0_ o W W W < W OW U) � LL O O W O W W CD O Z CC W W r Q�W M oa GRANT DESCRIPTION PASSED THROUGH THE STATE OF COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT UPCOCOCOCOCO r r O O O O CO M U) U) O V00 00 M to N --CO M c' M M M O N r U) ON-- N- N- M r V O N (O M M 00 N h 00 (O O N N 4 M O O N 00 00 4 O U) r r O M V N (O O) C CO N f- O M N (O U) tO O U) U) N O N. r M N- N v O 00 00 0 (O N- (O a 00 O r M N 01 O N U) O r U) U) (O r r d' U) N N r O r U) t` N l O• 0 0 O• 0 0 O• 0 0 O• 0 0 O• 0 e 0 O• 0 0 O• 0 0 O• 0 0 O• 0 e 0 O• 0 0 O• 0 0 0 O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O CV 01 00 U) 4 N CO , 00 N -- v- N to N to r O LU d N N O to C C C C (O IN- h 00 C C N C C r C C O) C r d' C O C C N- O O O U) N O (O O d' (O O O M d' O O f: N 00 N (O CO d' M N- r O of O r (O r N CO r 1 M O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O r O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O N a r r m (O Ma (O N6 O V' O R O a O MR (O (O N r MR O V' N O O (O (O O O r r O CM O O O (O V' M U) U) O d' 00 CO M U) N. --(O M d' M CO O N r U) ON-- N- N.-- CO r ct O N (O M M 00 M 00 (O O N N V M N� V O O N 00 00 mt O to r r O CI d' N CO O O (O N R O M N CO a a 00 a a N O R r CJ R of v O 00 00 O (O R (O 0 N O O r CM N M O N to O r to to co r r d' U) N N r CO M U) M O N� O CO CO O O N- O U) O 00 U) r V CO N O N O O CO r U) O (O CO O O_ N 000 t O co O M C N- co Lb N- 00 N- O 000 mt CO UP N( r CO N O 0 0 N U) 00 M O co cN- t N N.- 4" M R N (O M r V (O U) O 00 M O O co O r Ci U) N U) O U) 00 O U) NI- (O 00 r M r M N 't 00 N CO O N- r U) 00 r r U7 O N r- r O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O to a O h O 0 V CO O O R O to O 0 to COV CO N N O r O O U) O (O (O O O N- t` O C') O O CO O M to V' O O U) O O N r 01 `d' r N U) O O U) U) O M N- N- r N 00' O M O 01 N N- n 00 N- O 00 4 O to N (O O N O O O N U) CO Ch O r d' N N- V CM N- N (O M r V (O to O) W CM O O CO 0 r M a N U) O U) (O 0 U) R (O a r M r M N ct CO N CO O N� r U) CO r r U) O N r r r- 0 0 0 O O O O O O 0 0 0 0 0 0 O O O O O O O O O 646 ' Ch O "R N- � � M ' V (O '4 co N- O U) O CO O CON-. U) CO to N (O V N- N V U) O CO N N.- to r N N V co V V V UP N N OO O O ' co M ' i W (O O O CA r N� N. h N� U) 00 00 00 00 00 00 00 O O O O O O O O O O O O O O r 00 00 00 00 00 00 r O O O O V' U) U) U) U) U) U) U) U) to U) U) to CO CO (O CO CO (O CO CO (O (O N- N- N- N- N- N- O N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N 00 h h h h h N- N- h h h h h h r-: 262695 WAGNER PEYSER 262695 WAGNER PEYSER - ARRA CC W Y 0 2 ft Ll. J a C Z = re _ o d 4 = n W N J J J "') O O E c 0 0 O < ? O m a a a W } E Z_ Z_ Z Z_ I-- (n J J Y (n N - a o° c0 2' o cc o U¢¢ Q Q Q g r Q 0 0 a a a a a a a a a a a U) r-. U) U) U) U) CO CO M O N- U) N� O) N O) C) CO CO C) CO V V N CO CO CO CO CO CO CO CO CO CO CD CO CO CO CI 0 N N N N N N N N O4O1 N N CO N N 2643 Sectors 6/12 263907 10% INCENTIVE CC a Y W CC a a 0 CC CC 01 O 5 Q Z W w a w w w W oU p o o o Y WO C W WO W W W c W w I- W H I- H p o U U U U U U O <000 o'-'00 (OZ W WU) �F(n in O W a o O m a O ZZZZZ E Vp w W J 00000rowz a o o a a a a a a - a= z w U) U) U) U) U) M CI CO CI CO CO CI CO CC Cr (O CO CO CO CO CO CD CO CO O4O4O4O4O4O4O4O4 2643 DISLOCATED WORKER UI LU W CC 0 O U O J to O a QLA CO CO N 2636 WIAADULTUI LU W O W N a O U J truj o u CO CO Cr W CO (O N 2643 WIA DISLOCATED WORKER - ARRA 2643 ENHANCED DISLOCATED WORKER 262695 DVOP TOTAL PASSED THROUGH CDLE PASSED THROUGH THE STATE DIVISION OF CRIMINAL JUSTICE 00 N N- O) CD U N- M r r U) CO 0 0 0 CD O O O N- O O r r O O O C) O O 00 N h A O U) O U) N� N. M 00 00 r N N 00 N h CD U) N 00 M M (O r- 0 O co V- r F- CD CO CO O 0 N 00 N h h O U) r CD U) r N C) r M M f` U) r CD O O V st Women Formula Grants C c C9 U O 0) C Cc a C6 C 7 CO O 0) Q SD J L o 0) > '>223 O O O CD CD — O O r r v- TOTAL PASSED THROUGH THE STATE DIVISION OF CRIMINAL JUSTICE PASSED THROUGH GOVERNOR'S COMMISSION ON COMMUNITY SERVICE CO t• co co mr N M up t - r O O) N O O O O r 00 CO O (O 01 CO N N CO CD Ci Ul in r r OD 0) N N oi N- n r .- CO CO at CO C) M N co co C) co ti N a M N co to No CO CO 0 a) O 0 co (n 0 N N cc CD N M O C) cc CO N n M O O a 00 00 l� r 2646 AMERICORP TOTAL PASSED THROUGH GOVENOR'S COMMISION ON COMMUNITY SERVICE N Grand Total O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N v- r v- v- r r CP N CP N N r O N WELD COUNTY, COLORADO NOTES TO SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS December 31, 2011 NOTE 1: BASIS OF PRESENTATION The accompanying schedule of expenditures of Federal awards, which includes the Federal grant activity of Weld County, Colorado, is presented on the accrual basis of accounting. The information in this schedule is presented in accordance with the requirements of the U.S. Office of Management and Budget Circular A-133, Audits of States, Local Governments, and Non -Profit Organizations. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in, the preparation of Weld County, Colorado's financial statements for the year ended December 31, 2011. NOTE 2: SUB -RECIPIENT Weld County, Colorado does not have any significant sub -recipients. 162 McGee, Hearne & Paiz, LLP Certified Public Accountants and Consultants 314 West 18th Street, Cheyenne, Wyoming 82001-4404 INDEPENDENT AUDITOR'S REPORT ON INTERNAL CONTROL OVER FINANCIAL REPORTING AND ON COMPLIANCE AND OTHER MATTERS BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS Board of County Commissioners Weld County, Colorado Greeley, Colorado We have audited the financial statements of the governmental activities, the business -type activities, each major fund, and the aggregate discretely presented component unit and remaining fund information of Weld County, Colorado (the "County") as of and for the year ended December 31, 2011, which collectively comprise the County's basic financial statements, and have issued our report thereon dated June 15, 2012. Our report includes a reference to other auditors. We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Other auditors audited the financial statements of the Weld County Housing Authority, as described in our report on the County's financial statements. This report does not include the results of the other auditors' testing of internal control over financial reporting or compliance and other matters that are reported on separately by those auditors. Internal Control over Financial Reporting Management of the County is responsible for establishing and maintaining effective internal control over financial reporting. In planning and performing our audit, we considered the County's internal control over financial reporting as a basis for designing our auditing procedures for the purpose of expressing our opinion on the financial statements, but not for the purpose of expressing an opinion on the effectiveness of the County's internal control over fmancial reporting. Accordingly, we do not express an opinion on the effectiveness of the County's internal control over financial reporting. A deficiency in internal control exists when the design or operation of a control does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct misstatements on a timely basis. A material weakness is a deficiency, or a combination of deficiencies, in internal control such that there is a reasonable possibility that a material misstatement of the County's financial statements will not be prevented, or detected and corrected on a timely basis. Our consideration of internal control over fmancial reporting was for the limited purpose described in the first paragraph of this section and was not designed to identify all deficiencies in the internal control over financial reporting that might be deficiencies, significant deficiencies, or material weaknesses. We did not identify any deficiencies in internal control over financial reporting that we consider to be material weaknesses, as defined above. However, we identified a certain deficiency in internal control over financial reporting, described in the accompanying schedule of findings and questioned costs as item 2011-01, that we consider to be a significant deficiency in internal control over financial reporting. A significant deficiency is a deficiency, or a combination of deficiencies, in internal control that is less severe than a material weakness, yet important enough to merit attention by those charged with governance. 163 Compliance and Other Matters As part of obtaining reasonable assurance about whether the County's financial statements are free of material misstatement, we performed tests of its compliance with certain provisions of laws, regulations, contracts and grant agreements, noncompliance with which could have a direct and material effect on the determination of financial statement amounts. However, providing an opinion on compliance with those provisions was not an objective of our audit and, accordingly, we do not express such an opinion. The results of our tests disclosed no instances of noncompliance or other matter that are required to be reported under Government Auditing Standards. The County's response to the finding identified in our audit is described in the accompanying schedule of findings and questioned costs. We did not audit the County's response and, accordingly, we express no opinion on it. This report is intended solely for the information and use of management, the Board of County Commissioners, others within the County, Federal awarding agencies, and pass -through entities, and is not intended to be and should not be used by anyone other than these specified parties. Cheyenne, Wyoming June 15, 2012 164 MEpMcGee, Hearne & Paiz, LLP Certified Public Accountants and Consultants 314 West 18th Street, Cheyenne, Wyoming 82001-4404 INDEPENDENT AUDITOR'S REPORT ON COMPLIANCE WITH REQUIREMENTS THAT COULD HAVE A DIRECT AND MATERIAL EFFECT ON EACH MAJOR PROGRAM AND INTERNAL CONTROL OVER COMPLIANCE IN ACCORDANCE WITH OMB CIRCULAR A-133 Board of County Commissioners Weld County, Colorado Greeley, Colorado Compliance We have audited the compliance of Weld County, Colorado (the "County") with the types of compliance requirements described in the U.S. Office of Management and Budget (OMB) Circular A-133, Compliance Supplement that could have a direct and material effect on each of its major Federal programs for the year ended December 31, 2011. The County's major Federal programs are identified in the summary of auditor's results section of the accompanying schedule of findings and questioned costs. Compliance with the requirements of laws, regulations, contracts and grants applicable to each of its major Federal programs is the responsibility of the County's management. Our responsibility is to express an opinion on the County's compliance based on our audit. We conducted our audit of compliance in accordance with auditing standards generally accepted in the United States of America; the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States; and OMB Circular A-133, Audits of States, Local Governments, and Non -Profit Organizations. Those standards and OMB Circular A-133 require that we plan and perform the audit to obtain reasonable assurance about whether noncompliance with the types of compliance requirements referred to above that could have a direct and material effect on a major Federal program occurred. An audit includes examining, on a test basis, evidence about the County's compliance with those requirements and performing such other procedures as we considered necessary in the circumstances. We believe that our audit provides a reasonable basis for our opinion. Our audit does not provide a legal determination on the County's compliance with those requirements. In our opinion, the County complied, in all material respects, with the compliance requirements referred to above that could have a direct and material effect on each of its major Federal programs for the year ended December 31, 2011. However, the results of our auditing procedures disclosed instances of noncompliance with those requirements that are required to be reported in accordance with OMB Circular A-133 and which are described in the accompanying schedule of findings and questioned costs as items 2011-02 through 2011-05. 165 Internal Control over Compliance Management of the County is responsible for establishing and maintaining effective internal control over compliance with requirements of laws, regulations, contracts and grants applicable to Federal programs. In planning and performing our audit, we considered the County's internal control over compliance with requirements that could have a direct and material effect on a major Federal program in order to determine our auditing procedures for the purpose of expressing our opinion on compliance and to test and report on internal control over compliance in accordance with OMB Circular A-133, but not for the purpose of expressing an opinion on the effectiveness of internal control over compliance. Accordingly, we do not express an opinion on the effectiveness of the County's internal control over compliance. A deficiency in internal control over compliance exists when the design or operation of a control over compliance does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct noncompliance with a type of compliance requirement of a Federal program on a timely basis. A material weakness in internal control over compliance is a deficiency, or combination of deficiencies, in internal control over compliance, such that there is a reasonable possibility that material noncompliance with a type of compliance requirement of a Federal program will not be prevented, or detected and corrected on a timely basis. Our consideration of internal control over compliance was for the limited purpose described in the first paragraph of this section and was not designed to identify all deficiencies in internal control over compliance that might be deficiencies, significant deficiencies, or material weaknesses. We did not identify any deficiencies in internal control over compliance that we consider to be material weaknesses, as defined above. The County's responses to the findings identified in our audit are described in the accompanying schedule of findings and questioned costs. We did not audit the County's responses and, accordingly, we express no opinion on them. This report is intended solely for the information and use of management, the Board of County Commissioners, others within the County, Federal awarding agencies, and pass -through entities, and is not intended to be and should not be used by anyone other than those specified parties. 127a)-7-4, //a- Ap Cheyenne, Wyoming June 15, 2012 166 WELD COUNTY, COLORADO SCHEDULE OF FINDINGS AND QUESTIONED COSTS Year Ended December 31, 2011 I. SUMMARY OF INDEPENDENT AUDITOR'S RESULTS A. Financial Statements Type of auditor's report issued: Unqualified Internal control over financial reporting: Material weaknesses identified? Yes X No Significant deficiencies identified that are not considered to be material weaknesses? X Yes None reported Noncompliance material to financial statements noted? B. Federal Awards Internal control over major programs: Yes X No Material weaknesses identified? Yes X No Significant deficiencies identified that are not considered to be material weaknesses? Yes X None reported Type of auditor's report issued on compliance for major programs: Unqualified Any audit findings disclosed that are required to be reported in accordance with Section 510(a) of Circular A-133? X Yes No Identification of major programs: CFDA Numbers 93.659 Cluster Cluster Cluster Name of Federal Program or Cluster Adoption Assistance* Immunization Cluster* Temporary Assistance for Needy Families (TANF) Cluster Medicaid Cluster *This program/cluster contains a portion of Recovery Funds. Dollar threshold used to distinguish between Type A and Type B programs: $872,204 Auditee qualified as low -risk auditee? X Yes No 167 WELD COUNTY, COLORADO SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Year Ended December 31, 2011 IL FINANCIAL STATEMENT FINDINGS 2011-01: Audit Adjustments Condition: Adjustments to the County's financial records were proposed and recorded during the audit to properly report the government -wide and fund -level financial statements in accordance with generally accepted accounting principles (GAAP). Criteria: Under professional standards, significant adjustments to the financial statements, including footnote disclosures, is considered a control deficiency. Cause: The misstatements resulting in the adjustments were caused by a number of factors including communication between departments and human error. Effect: Financial statements that are not correctly stated in accordance with GAAP can be misleading to users. Recommendation: We recommend the Finance Department continue to strive to correct specific issues resulting in the misstatements. Auditee Response: We will continue to work with all the departments to make sure that they are recording payments in the appropriate periods. We are also going to extend the time that the accounting staff is taking more care in the year in which expenditures are recorded to ensure that we are reporting appropriately. III. FINDINGS AND QUESTIONED COSTS FOR FEDERAL AWARDS 2011-02: Adoption Assistance — Activities Allowed or Unallowed/Allowable Costs/Cost Principles Catalog of Federal Assistance (CFDA) Number and Title: #93.659, Adoption Assistance Federal Agency Name: U.S. Department of Health and Human Services Pass -Through Entity Name (if applicable): Colorado Department of Health and Human Services Award Number/Name: Not Applicable Condition: Of the 40 adoption assistance payments selected for testing, one of the payments was made twice to a client in error. Criteria: Funds may be expended for adoption assistance agreement subsidy payments in accordance with the State's foster care maintenance payment rate schedule. Subsidy payments are made to adoptive parents based on the need(s) of the child (i.e. developmental, cognitive, emotional behavioral) and the circumstances of the adopting parents (42 USC 673(a)(2)). Subsidy payment amounts cannot be based on any income eligibility requirements of the prospective adoptive parents (45 CFR section 1356.41(c)). Adoption assistance subsidy payments cannot exceed the foster care maintenance payment the child would have received in a foster family home; however, the amount of the subsidy payments may be up to 100% of the foster care maintenance payment rate (42 USC 673(a)(3)). 168 WELD COUNTY, COLORADO SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Year Ended December 31, 2011 Cause: The cause of the error was presumed by the County to be due to a glitch in the Trails system. However, the County did not have mitigating controls in place to identify the double payment. Effect: If mechanisms are not in place to identify and correct double payments, the County may be paying participants more than the agreed amount. Recommendation: We recommend that the County implement an internal control that would allow the County to detect double payments or any other potential payments made without authorization. Questioned costs: $445 - Known; $34,862 - Projected Auditee Response: We concur with this fmding. There was a double -payment that occurred on the December 2012 Trails provider payroll. We, however, do not agree with the Projected Questioned Costs estimate of $34,862. The Colorado Department of Human Services ("CDHS") and we have each reviewed the situation and have confirmed that the double -payment was recovered from the recipient and that there were no other instances of this occurring during 2011. CDHS is examining the Trails system to increase the safeguards preventing a double -payment. They were unable to identify, specifically, what caused this payment to be issued twice. Because the payments for out -of -home and adoptive placements is made based solely on the records within the Trails system, and not based on pre -numbered invoices, the only effective way to prevent a double -payment is by correcting the programming of the Trails system, which is beyond the control of the County. We will, therefore, address this issue by conducting periodic reviews of year-to-date payments from the Trails system, in order to identify any such duplicative payments. 2011-03: Temporary Assistance for Needy Families (TANF) Cluster — Special Tests and Provisions Catalog of Federal Assistance (CFDA) Number and Title: #93.558, #93.714 and #93.716, Temporary Assistance for Needy Families (TANF) Cluster Federal Agency Name: U.S. Department of Health and Human Services Pass -Through Entity Name (if applicable): Colorado Department of Health and Human Services Award Number/Name: Not Applicable Condition: We selected 19 case files for testing to ensure proper review was performed by the County in compliance with the State's Work Verification Plan. Of the 19 case files selected for testing, we noted one instance in which the County did not complete a case file review. Criteria: The County is required to review a minimum of 5% of the prior month's disbursements to ensure accuracy in accordance with the State's Work Verification Plan. Cause: The case file review was not completed as the file could not be located by the County. The County did not properly scan the file into scanned documents or maintain the paper file. 169 WELD COUNTY, COLORADO SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Year Ended December 31, 2011 Effect: If controls are not in place to ensure adequate documentation is maintained and proper records are kept on file at the County, the accuracy of the data used in calculating the work participation rates cannot be verified. As a result, compliance with the State's Work Verification Plan may not be achieved. The U.S. Department of Health and Human Services may penalize the State by an amount not less than 1% and not more than 5% of the grant for violation of this provision. Recommendation: We recommend that the County ensure records are included within scanned documents under the proper client number at the time of original eligibility determination to ensure client records are available for verification and other purposes. Questioned costs: Unknown. Auditee Response: We concur with this finding. We are currently in the process of identifying a new vendor and revising the procedures for scanning and indexing our records. We've had several issues with the current vendor losing or incorrectly indexing files. The RFP that was released to identify a new vendor includes several requirements that will enhance the accuracy of the process, as well as enabling more documents to be imaged and made available earlier in the processing of the case. 2011-04: Temporary Assistance for Needy Families (TANF) Cluster — Special Tests and Provisions Catalog of Federal Assistance (CFDA) Number and Tide: #93.558, #93.714 and #93.716, Temporary Assistance for Needy Families (TANF) Cluster Federal Agency Name: U.S. Department of Health and Human Services Pass -Through Entity Name Of applicable): Colorado Department of Health and Human Services Award Number/Name: Not Applicable Condition: Of the 40 participants selected for testing, we noted six instances of participant files that contained Income Eligibility and Verification System (IEVS) discrepancy reports that were not cleared by the County within the required timeframe. Criteria: The County is required to initiate a notice of case action or an entry in the case record that no case action is necessary within 45 days of its receipt of an IEVS discrepancy report. Under certain circumstances, action may be delayed beyond 45 days for no more than 20% of the information items targeted for follow-up. Cause: The County did not review open IEVS discrepancy reports contained in participant files in a timely manner. Effect: If the County does not ensure IEVS discrepancy reports are cleared in a timely manner, the County may pay or over compensate a participant who should not be receiving benefits. Recommendation: We recommend that the County ensure IEVS discrepancy reports are cleared within 45 days. 170 WELD COUNTY, COLORADO SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Year Ended December 31, 2011 Questioned costs: Unknown. Auditee Response: We concur with this finding. As caseloads have grown, due to the downturn in the economy and legislative mandates, the County has placed a greater priority on the timely determination of eligibility for services and on determination of the appropriate level of services, and a lesser priority on the timely processing of IEVS hits. The same is true of most counties within the State. Due to a successful reorganization of the workflow of cases and due to extraordinary efforts on the part of the County staff, we have reduced the backlog of cases to a much more manageable and acceptable level. We are, therefore, now able to reestablish the task of processing IEVS hits to its previous priority level. Timely processing of IEVS hits will be examined as part of the case review process. 2011-05: Medicaid Cluster — Eligibility Catalog of Federal Assistance (CFDA) Number and Title: #93.720, #93.775, #93.776, #93.777 and #93.778, Medicaid Cluster Federal Agency Name: U.S. Department of Health and Human Services Pass -Through Entity Name Of applicable): Colorado Department of Health and Human Services Award Number/Name: Not Applicable Condition: Of the 60 participant files selected for testing, we noted one file that did not contain adequate documentation supporting the eligibility determination. Criteria: The County is required to determine client eligibility in accordance with eligibility requirements defined in the approved State plan. Cause: The County did not properly scan the birth certificate into scanned documents or maintain the paper copy to be able to verify the accuracy of citizenship proof. Effect: If controls are not in place to ensure adequate documentation is maintained and proper records are kept on file at the County to support eligibility, the State may be paying claims for ineligible participants. Recommendation: We recommend that the County ensure records are included within scanned documents under the proper client number at the time of original eligibility determination to ensure client records are available for verification and other purposes. Questioned costs: Unknown Auditee Response: We concur with this finding. We are currently in the process of identifying a new vendor and revising the procedures for scanning and indexing our records. We've had several issues with the current vendor losing or incorrectly indexing files. The RFP that was released to identify a new vendor includes several requirements that will enhance the accuracy of the process, as well as enabling more documents to be imaged and made available earlier in the processing of the case. We will also work with Medical Assistance sites to convey the importance of providing a full copy of identification documents that they certify. In this case, the certified copy of the birth certificate that was provided to us by the Medical Assistance site at which the client was served was incomplete. 171 WELD COUNTY, COLORADO SUMMARY SCHEDULE OF PRIOR FEDERAL AUDIT FINDINGS For the Year Ended December 31, 2011 Findings Status 2010-02: Schedule of Expenditures of Federal Awards A portion of the schedule of expenditures of Federal awards did not cross foot correctly and was therefore misstated. Additionally, the schedule was not complete as it did not include Federal expenditures associated with CFDA #93.667, Social Services Block Grant Disaster Recovery. A process to identify all Federal grants approved by the Board of County Commissioners in the Minutes System insured all Federal grants were included on the 2011 schedule. The footing and cross footing errors were eliminated by working with departments to explain the schedule and checking that all formulas were set up properly. 2010-03: Adoption Assistance — Eligibility Catalog of Federal Assistance (CFDA) Number and Title: #93.659, Adoption Assistance Federal Agency Name: U.S. Department of Health and Human Services Pass -Through Entity Name (if applicable): Colorado Department of Health and Human Services Award Number/Name: Not Applicable Award Year(s): July 1, 2009 - June 30, 2010 Of the 40 children selected for testing eligibility, we noted two children who were not eligible for adoption assistance. Per review of the files, the Court Orders were not appropriate for the subsidy as they had dual language including reasonable efforts that had been made to keep the child in the home and that this was an emergency situation. We concur that this did occur. However, we would like to note that the error actually occurred at the time of the adoption, in 2002. As a result of errors like this one, the County, in 2010, assigned a staff position to devote half of its time to the tasks associated with properly documenting and finalizing adoptions. The Adoption Assistance Negotiator prepares all adoption assistance contracts, rather than decentralizing those tasks to the caseworkers. No case initiated after the implementation of this procedure has been identified as violating this provision. 172 STATISTICAL SECTION STATISTICAL SECTION (unaudited) This part of the Weld County Government's comprehensive 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 government's overall financial health. Contents Page Financial Trends These schedules contain trend information to help the reader understand how the government's financial performance and well-being have changed over time. Revenue Capacity These schedules contain information to help the reader assess the government's most significant local revenue source, the property tax. Debt Capacity Weld County is without bonded debt and, accordingly, the following statistical tables are not presented: Ratios of Outstanding Debt by Type and Ratios of General Bonded Debt Oustanding. Demographic and Economic Information These schedules offer demographic and economic indicators to help the reader understand the environment within which the government's financial activities take place. Operating Information These schedules contain service and infrastructure data to help the reader understand how the information in the government's financial report relates to the services the government provides and the acitivities it performs. 130 138 143 147 152 Sources: Unless otherwise noted, the information in these schedules is derived from the comprehensive annual financial reports for the relevant year. 129 COUNTY OF WELD STATE OF COLORADO Net Assets by Component Last Ten Years (accrual basis of accounting) Governmental activities Invested in capital assets, net of related debt Restricted for Programs Emergencies Claims Unrestricted Total governmental activities net assets Business -type activities Invested in capital assets, net of related debt Unrestricted Total business -type activities net assets Primary government Invested in capital assets, net of related debt Restricted Unrestricted Total primary government net assets Fiscal Year 2002 2003 2004 2005 2006 $ 253,141,316 $ 247,764,877 $ 238,640,911 $ 231,271,356 $ 233,626,280 3,307,949 3,025,505 1,663,948 27,713,273 $ 288,851,991. 3,169,309 3,025,505 1,748,948 26,511,213 4,199,374 3,500,000 1,748,949 30,759,296 $ 282.219,852 $ 278,848,530 4,695,690 4,000,000 1,748,950 39,782,093 3,953,450 4,000,000 1,748,951 48,545,826 $ 281.498.089 $ 291,874,507, $ 941,049 $ 834,285 $ 864,425 $ 809,643 $ 852,705 (86,086) (266,736) (4,761) 1,508,322 2,118,077 $ 854,953,, $ 567.5.49 $ 85a 664 $ 2.317.965 $ 2.970.782 $ 254,082,365 7,997,402 27,627,187 $ 289.706.954 $ 248,599,162 $ 239,505,336 $ 232,080,999 $ 234,478,985 7,943,762 9,448,323 10,444,640 9,702,401 26,244,477 30,754,535 41,290,415 50,663,903 $_2$2,2B1,40. 279,708 194 $ 283.816.054 $_294,$45.,2$9. 2007 $ 249,237,323 3,988,022 5,000,000 1,748,951 40,122,962 $ 300,097,258 2008 2009 $ 253,009,697 $ 256,826,307 4,033,041 5,000,000 1,270,613 37,397,773 $ 300,711,124 4,524,110 6,000,000 2,270,613 40,819,002 $ 310,440,032 2010 $ 254,893,784 4,912,503 6,000,000 4,734,410 66,081,025 $ 336,621,722 2011 $ 252,365,188 5,360,845 6,000,000 4,734,409 74,131,389 $ 342,591,831 $ 987,445 $ 1,076,125 $ 1,011,224 $ 1,305,614 $ 1,524,148 2,191,453 2,776,179 2,478,408 3,194,266 3,526,143 $ 3.178.89$ $ 3.852.304 $ 3.489,632 $ 4.490 $$Q $ 5.050.291, $ 250,224,768 $ 254,085,822 $ 257,837,531 $ 256,199,398 $ 253,889,336 10,736,973 10,303,654 12,794,723 15,646,913 16,095,254 42,314,415 40,173,952 43,297,410 69,275,291 77,657,532 LiOanaana $304,O563.42B, $ 313 929 664 L34.121..6_02, $ 347.642.122 COUNTY OF WELD STATE OF COLORADO Changes in Net Assets Last Ten Years (accrual basis of accounting) Expenses Governmental activities: General government Public safety Streets and highways Health and welfare Culture and recreation Economic assistance Interest on long-term debt Total governmental activities expenses Business -type activities: Paramedic service Total primary government expenses Program Revenues Governmental activities: Charges for services: General government Public Safety Streets and highways Health and welfare Culture and recreation Economic assistance Operating grants and contributions Capital grants and contributions Total governmental activities program revenues Business -type activities: Paramedic service Total primary government revenues Net (Expenses)/Revenue Governmental activities Business -type activities Total primary government net General Revenues and Other Changes in Net Assets Governmental activities: Taxes: Property taxes Specific Ownership Other Royalties Miscellaneous Unrestricted investment earnings Donated capital assets Gain on sale of capital assets Transfers Total governmental activities Business -type activities: Paramedic service Total primary government Change in Net Assets Governmental activities Business -type activities Total primary government 2002 2003 $ 19,978,184 24,079,553 34,283,421 21,721,740 1,036,099 11,079,949 406,155 112,585,101 $ 23,618,753 27,827,685 33,353,129 21,404,255 776,322 11,411,322 377,233 118,768,699 2004 $ 21,174,906 28,425,957 32,688,807 23,538,421 1,005,697 12,646,785 358,054 119,838,627 2005 $ 23,047,725 30,449,441 36,919,372 24,843,147 771,295 13,736,745 340,411 130,108,136 2006 $ 26,641,373 32,562,998 37,068,628 26,179,807 1,549,379 11,747,943 322,293 136,072,421 6,743,936 8,800,646 9,738,148 6,371,413 7,156,700 $ 119.329.037 $ 127.569.345 $ 129,576.775 $ 136,479.549 $ 143.229.121 $ 9,425,679 3,894,565 2,021,319 13,664,895 266,900 922,549 26,156,456 56,352,363 6,815,683 63,168,046 $ 8,677,015 5,085,767 2,279,939 11,486,561 1,375 1,576,106 25,963,243 55,070,006 8,518,289 63,588,295 $ 8,086,983 7,609,527 1,157,634 12,699,858 309,948 862,223 27,124,685 57,850,858 10,035,874 67,886,732 $ 9,792,423 5,430,422 3,433,713 13,664,206 333,293 1,156,012 27,885,047 61,695,116 7,829,714 69,524,830 $ 12,265,623 6,378,749 4,023,310 14,949,936 345,990 1,186,129 30,045,943 69,195,680 7,809,516 77,005,196 (56,232,738) (63,698,693) (61,987,769) (68,413,020) (66,876,741) 71,747 (282,357) 297,726 1,458,301 652.816 $ (56.160.991) $ (63.981.050) $ (61.690.043) $ (66.954.719) $ (66.223.925) $ 45,233,546 $ 47,532,602 $ 50,785,919 $ 56,382,533 $ 62,124,792 5,467,148 5,540,872 6,795,897 6,627,991 6,614,819 2,376,581 2,492,418 3,333,336 3,733,025 5,266,786 2,052,594 0 10,030 55,139,899 1,563,120 0 (94,544) 57,034,468 1,644,979 0 (2,358,185) 60,201,946 2,679,442 355,784 69,778,775 (5,057) 15,611) 4,539,172 7,602 (1.300,000) 77,253,171 $ 55.139.899 $ 57.029.411 $ 60.196.335 $ 69.778.775 s 77.253.171 $ (1,092,839) $ (6,664,225) $ (1,785,823) $ 1,365,755 $ 10,376,430 71,747 f287,414) 292,115 1,458,301 652,816 $ (1..021.0921 $ 16,95.1.6.3,91 $ j .43108) $ 2.824.456 $ 11.029.246 132 2007 2008 2009 2010 2011 $ 35,301,327 $ 31,019,065 $ 31,738,352 $ 31,497,117 $ 31,930,407 36,717,165 40,496,490 40,649,718 40,551,255 42,613,038 34,637,731 40,795,016 31,123,536 34,662,990 37,519,293 31,026,419 35,117,225 39,882,326 37,946,589 35,881,864 1,008,703 1,077,743 1,013,683 1,215,481 1,123,268 14,403,662 14,601,330 15,546,027 9,262,302 8,115,722 335,771 153,430,778 163,106,869 159,953,642 155,135,734 157,183,592 8,444,840 9,289,761 9,310,991 6,349,218 5,964,112 $ 161,875,618 $ 172,396.630 $ 169,264.633 $ 161,484,952 $ 163,147.704 $ 10,043,033 $ 11,681,170 $ 8,728,521 $ 10,117,110 $ 12,644,748 4,998,285 5,814,979 5,658,339 7,021,139 6,023,109 3,566,774 3,518,926 3,262,996 1,932,790 2,022,037 17,504,660 19,870,091 21,091,150 21,311,474 19,360,887 453,352 468,488 448,990 549,483 619,316 838,871 756,698 1,041,768 834,429 822,309 36,500,297 33,134,702 36,580,590 27,858,758 24,034,211 4,738,627 25,454 78,643,899 75,270,508 76,812,354 69,625,183 65,526,617 8,652,955 9,113,166 7,563,318 5,859,468 6,514,522 87,296,854 84,383,674 84,375,672 75,484,651 72,041,139 (74,786,879) (87,836,361) (83,141,288) (85,510,551) (91,656,975) 208,115 (176,595) (1,747.673) (489.750) 550,410 $ (74.578.764) $ (88.012,956) $ (84.888,961) $ (86.000.301) $ (91.106.565) $ 67,215,993 $ 72,735,158 $ 75,047,892 $ 95,251,609 $ 76,808,723 7,056,071 7,035,189 6,167,691 6,018,849 5,743,784 3,546,134 5,454,324 3,472,065 845,578 1,794,415 1,707,235 2,556,866 7,169,988 5,468,676 6,415,403 4,305,446 5,191,430 4,075,554 2,391,636 2,103,942 1,804,728 (850,000) (1,385,000) (1,500,000) 83,009,628 88,450,225 92,870,195 111,692,247 97,627,084 850,000 1,385,000 1,500,000 $ 83.009.628 $ 89.300.225 $ 94.255.195 $ 113.192.247 $ 97.627.084 $ 8,222,749 $ 613,864 $ 9,728,907 $ 26,181,696 $ 5,970,109 208,115 673,405 (362,673) 1,010,250 550,410 $ 8.430.864 $ 1-28726_9 $ 9.366.234 $ 27.191.946 $__15.225.19 133 COUNTY OF WELD STATE OF COLORADO Fund Balances of Governmental Funds Last Ten Years (modified accrual basis of accounting) General Fund Reserved Unreserved Nonspendable * Restricted * Committed * Assigned * Unassigned * Total general fund All other Governmental Funds Reserved Unreserved Unreserved, reported in: Special revenue funds Capital projects funds Debt service funds Nonspendable * Restricted * Committed * Assigned * Unassigned * 2002 2003 2004 2005 $ 3,249,297 $ 1,342,369 $ 1,516,298 $ 1,486,188 $ 2,921,157 $ 3,727,307 $ 6,699,941 $ 7,648,920 2006 $ 946,073 $ 10,630,592 $ 6.170.454 $ 5,069,676 $__1121q219 $ 9,135,108 $ 11,576,665 $ 6,984,908 $ 2,666,118 $ 4,139,435 $ 8,834,511 $ 19,019,004 19,512,384 294,482 22,023,076 2,830,614 25,360,820 697,779 26,155,751 3,511,495 25,281,236 0 Total for all governmental funds $ 32.962.228 $ 32,589,484 $ 38,414,273 $ 47.636.865 $ 55,876,905 * Difference in fund balance presentation is due to implementation of GASB 54 in 2011 2007 2008 2009 2010 2011 $ 1,081,217 $ 1,161,271 $ 846,808 $ 1,882,253 $ 7,007,528 $ 10,645,617 $ 9,960,565 $ 9,967,335 $ 687,239 6,000,000 1,927,404 1,808,529 - - - - 10,691,668 $ 8,088,745 $ 11.806.888 $ 102807,373 $ 11,849,588 $ 21,114,840 $ 12,074,704 $ 12,631,501 $ 9,861,718 $ 7,138,513 27,791,990 272,790 25,032,274 (2,064,635) 32,475,341 1,617,052 57,755,218 6,362, 877 $ 963,566 36,493,043 32,295,274 $ 48,228,229 $ 47,406,028 $ 54,761,484 $ 83,106,196 $ 90,866,723. COUNTY OF WELD STATE OF COLORADO Changes in Fund Balances, Governmental Funds Last Ten Years (modified accrual basis of accounting) Fiscal Year Revenues Taxes Licenses and permits Intergovernmental Fines and forfeitures Charges for Services Miscellaneous Fees Total Revenues Expenditures Current: General government Public Safety Public Works Public health and welfare Culture and recreation Economic assistance Capital outlay Debt service Interest Principal Total Expenditures Excess of revenues over (under) expenditures Other Financing Sources (Uses) Transfers -in Transfers -out Total Other Financing Sources (Uses) Net changes in Fund Balance Debt Service as a percentage of noncapital expenditures 2002 2003 $ 50,771,861 2,205,420 40,511,590 159,246 5,746,678 5,536,066 6,638,831 $ 53,080,974 1,760,546 38,299,161 75,488 6,887,469 4,739,386 7,387,204 111,569,692 112,230,228 19,100,208 23,435,572 23,465,325 21,327,335 1,046,374 10,892,932 9,590,948 406,155 21,910,296 27,212,371 21,407,821 20,896,282 764,449 11,365,585 8,668,934 377,233 109,264,849 11Z602,971 2,304,843 (372,743) 5,144,682 5,144,682 2,482,745 2,482,745 2004 $ 57,698,294 1,834,849 40,652,682 69,538 7,345,819 5,329,931 7,454,831 2005 $ 63,261,095 2,119,419 41,110,202 204,530 8,618,819 7,582,510 8,175,907 120,385,944 131,072,482 20,566,315 27,475,345 22,734,695 23,046,109 1,007,208 12,450,198 6,923,230 358,054 22,384,671 29,834,629 25,490,667 24,284,817 775,903 13,572,861 5,165,931 340,411 114,561,154 121,849,890 5,824,790 9,222,592 4,299,153 4,299,153 7,436,144 7,436,144 2006 $ 69,178,181 3,188,354 44,982,577 135,908 8,232,213 13,377,598 8,602,079 147,696,910 25,366,204 31,881,427 26,315,156 25,993,962 1,550,929 11,746,242 14,980,649 322,293 138,156,862 9,540,048 $ 2304,83 $__1222,24.11) $ 5.824.790 $ 9,222_592 $ 0.41% 0.36% 0.33% 0.29% 11,309,847 12,609,847 (1,300,000) 8,. 42 0.048 0.26% 136 2007 2008 2009 $ 74,627,631 $ 80,182,212 2,129,731 2,089,925 53,886,023 52,887,281 416,668 295,246 7,800,131 8,898,865 9,567,707 12,523,751 8,061,587 7,845,617 $ 84,642,477 1,467,282 61,100,082 323,411 8,939,683 7,132,908 7,546,475 156,489,478 164,722,897 171,152,318 32,605,930 35,945,956 31,798,757 30,940,641 1,011,311 14,449,197 17,050,592 335,771 29,061,657 38,564,419 36,643,514 34,585,229 1,077,592 14,459,482 9,883,207 28,311,209 38,668,759 29,595,637 39,287,986 1,014,422 14,622,541 9,911,307 16411381155 164,275,100 161,411,861 (7,648,677) 4,340,010 4,340,010 447,797 9,740,457 4,914,085 6,184,085 7,583,632 9,968,632 (1,270,000) (2,385,000) $ 17.648.677) $__111222.43.) 0.23% 0.00% 7,355457 0.00% 2010 $ 102,079,791 2,512,999 53,021,343 587,330 7,771,230 8,133,573 8,827,457 182,933,723 29,608,752 38,176,653 28,524,940 36,850,368 1,214,300 9,086,301 8,627,695 152,089,909 30,844,714 7,157,161 9,657,161 (2,500,000) 2011 $ 84,310,617 2,093,316 44,670,251 441,455 6,899,382 15,397,352 9,445,288 163,257,661 30,964,059 40,657,128 30,834,148 35,187,959 1,127,873 7,880,482 7,795,485 $ 28-3144.714 $ 0.00% 154,447,134 8,810,527 15,807,328 16,857,328 (1,050,000) Z1611527 0.00% COUNTY OF WELD STATE OF COLORADO Assessed Value and Estimated Actual Value of Taxable Property Last Ten Years Levy Year 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 Vacant Land 84, 924, 310 118, 539, 590 105,868,950 115, 005, 330 110,566,010 132,402,840 125,609,000 114,462,060 107,499,350 82,601,960 Residential Property 736,752,250 790,760,590 851,446, 760 972,251,070 1,051,061,180 1,218,082,640 1, 258, 374, 790 1,147,417,980 1,161,670,030 1,110,455,180 Commercial Industrial Property Property Agricultural 376,484,940 159,190,800 159,479,010 425, 380, 570 151, 942, 640 153,478, 310 448, 526, 350 153, 747, 260 158, 581, 990 507,867,420 155,227,960 172,592,990 538, 352, 810 194, 235, 560 175, 708, 230 631,036,750 214,051,130 96,371,890 654,957,800 216,214,910 97,874,960 703,405,460 281,991,090 100,747,790 713,727,230 338,066,670 100,999,290 700,148,970 343,525,350 117,189,830 Source: Office of the Weld County Assessor Note: Natural Resources 7,292,220 8,673,760 10,115,440 9,310,740 10,876,640 14,538,010 14,996,920 15,959,790 12,388,270 12,839,310 The assessment ratio for Residential Property was 10.36 in 1995, changed to 9.74 in 1997, 9.15 in 2001 and 7.96 in 2003 as determined by State Law. Commercial Property and non-residential Personal Property has been assessed at 29% of actual value throughout the ten-year time frame. 138 State Oil & Gas Assessed 649,951,220 253,719,200 554,434,380 284,213,800 969,984,640 295,147,000 1,279,782,160 403,287,500 1,736,735,240 386,413,500 1,749,119,710 412,859,500 1,709,997,160 487,797,900 2,868,304,890 538,504,800 1,673,838,130 593,020,000 2,439,298,540 615,803,700 Total Taxable Assessed Value 2,427,793,950 2,487,423,640 2,993,418,390 3,615, 325,170 4,203,949,170 4,468,462,470 4,565,823,440 5,770,793,860 4,701,208,970 5,421,862,840 Estimated Actual Taxable Value 12, 964, 532, 977 15,225,468,379 16,596,579,600 19,255,338,644 21,011,080,893 22,698,462,039 23,564,608,165 24,007,360,964 23,154,987,218 22,248,958,038 Assessed Value as a Total Direct Percentage of Tax Rate Actual Value 20.559 18.726% 20.056 16.337% 21.474 18.036% 19.957 18.776% 17.900 20.008% 16.804 19.686% 16.804 19.376% 16.804 24.038% 16.804 20.303% 16.804 24.369% COUNTY OF WELD STATE OF COLORADO Property Tax Rates Direct and Overlapping Governments Last Ten Years General Levy Year Government Road & Bridge Public Welfare Contingent Capital Insurance Tota Direct County 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 13.164 14.044 15.791 13.909 12.321 11.487 11.736 11.842 11.389 10.479 2.259 2.133 2.010 2.002 1.847 1.668 1.647 1.613 1.498 1.303 1.280 1.512 2.013 1.772 1.551 1.333 1.293 1.266 1.965 1.863 0.701 0.523 0.535 0.360 0.619 0.448 0.215 1.491 3.608 1.439 0.916 1.488 1.544 1.399 1.344 1.754 1.415 1.342 0.248 0.227 0.221 0.251 0.277 0.298 0.336 0.329 0.322 0.326 20.559 20.056 21.474 19.957 17.900 16.804 16.804 16.804 16.804 16.804 Overlapping Rates Levy Direct City of School Year County Greeley District 6 2002 20.559 11.274 50.320 2003 20.056 11.274 47.981 2004 21.474 11.274 46.453 2005 19.957 11.274 44.711 2006 17.900 11.274 41.129 2007 16.804 11.274 40.760 2008 16.804 11.274 36.922 2009 16.804 11.274 36.600 2010 16.804 11.274 36.633 2011 16.804 11.274 37.104 The basis for the property tax rates is per $1,000 assessed valuation. Source: Office of the Weld County Assessor. Aims College 6.620 6.316 6.322 6.328 6.357 6.330 6.308 6.323 6.312 6.360 Weld Library 3.249 3.249 3.249 3.249 3.281 3.261 3.253 3.260 3.255 3.281 140 COUNTY OF WELD STATE OF COLORADO Principal Property Taxpayers Current Year and Nine Years Ago Noble Energy Inc Kerr-McGee Oil & Gas Onshore LP Public Service Company of Colorado (XCEL) Encana Oil & Gas (USA) Inc Petroleum Development Corp DCP Midstream LP Kerr-McGee Gathering LLC Colorado Interstate Gas Co Vestas Blades America Inc Merit Energy Kerr-McGee Rocky Mountain Corp Patina Oil & Gas Corporation Pancanadian Energy Resources Inc Eastman Kodak Company Prima Oil & Gas Company Kerr-McGee Gathering LLC Qwest Corp KFA US West Merit Energy Thermo Cogeneration Source: Weld County Assessor 2011 Taxable Assessed Value Rank $ 1,015,783,680 1 769,162,260 2 191,943,300 3 185,720,630 4 170,408,730 5 76,224,380 6 63,672,300 7 49,314,800 8 47,472,500 9 36, 399, 800 10 $ 2,606,102,380 Percent Of Total County Taxable Assessed Value 21.61% 16.36% 4.08% 3.95% 3.62% 1.62% 1.35% 1.05% 1.01% 0.77% 55.43% 2002 Taxable Assessed Value Rank $ 90,262,700 3 269,453,080 174,150,230 38,478,820 37,755,650 32,896,650 31,418,800 29,835,600 26,943,680 18,640,300 $ 749,835,510 1 2 4 5 6 7 8 9 10 Percent Of Total County Taxable Assessed Value 3.72% 11.10% 7.17% 1.58% 1.56% 1.36% 1.29% 1.23% 1.11% 0.77% 30.89% COUNTY OF WELD STATE OF COLORADO Property Tax Levies and Collections Last Ten Years Levy Collect Year Year 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 Taxes Levied for the Fiscal Year (1) 45,683,851 48,691,835 53,414,937 59,739,651 64,714,321 70,643,162 75,088,043 76,724,097 96,972,420 78,999,116 Collected within the Ficsal Year of the Levy Tax Percent Amount (2) of Levy 45,566,346 48,410,396 53,094,454 59,395,927 64,580,198 70,575,408 74,877,199 75,903,359 96,736,465 78,833,201 Source: 1) Office of the Weld County Assessor 2) YTD Treasurer's Tax Distribution 3) YTD Treasurer's Tax Distribution 2001 forward 99.743% 99.422% 99.400% 99.425% 99.793% 99.904% 99.719% 98.930% 99.757% 99.790% Collections Total Collections to Date in Subsequent Tax Percent Years (3) Amount (3) of Levy 53,244 100,074 (230,263) 210,799 58,767 327,098 167,705 126,664 235,955 45,619,590 48,510,470 52, 864,191 59,606,726 64,638,965 70,643,162 75, 044, 904 76, 030, 023 96,972,420 78,833,201 Negative values reflect subsequent rebates and adjustments. 99.859% 99.628% 98.969% 99.777% 99.884% 100.000% 99.943% 99.095% 100.000% 99.790% 142 COUNTY OF WELD STATE OF COLORADO Direct and Overlapping Governmental Activities Debt December 31, 2011 Jurisdiction Cities & Towns Schools Special Districts Total Overlapping Net General Obligation Bonded Debt Outstanding $ 81,719,029 933,312,833 131,919,520 1,146,9_54,_382 Percentage Applicable to Government (1) 91.15% 49.89% 63.73% Source: Debt outstanding provided by each governmental unit. Amount Applicable to Government $ 74,489,479 465,658,398 84,074,041 $ 624,221}918 Note: (1) Overlapping governments are those that coincide, at least in part, with the geographic boundaries of the county. This schedule estimates the portion of the outstanding debt of those overlapping governments that is borne by residents and businesses of Weld County. This process recognizes that, when considering the county's ability to issue and repay long-term debt, the entire debt burden borne by the residents and businesses should be taken into account. However, this does not imply that every taxpayer is a resident, and therefore responsible for repaying the debt, of each overlapping government. 143 COUNTY OF WELD STATE OF COLORADO Legal Debt Margin Information Last Ten Years Legal Debt Margin Calculation for Fiscal Year 2011 Assesed Value, 2011 Debt Limit 3 percent of Assesed Value Total Bond Debt Installment Purchase Agreements $0 0 Total Amount of debt applicable to limit Legal Debt Margin Legal Debt Margin Information Last Ten Fiscal Years $ 5,421,862,840 162,655,885 0 $ 162,655,885 Debt limit Total net debt applicable to limit Legal debt margin Total net debt applicable to the limit as a percentage of debt limit 2002 $72,833,818 $72,833,818 0.00% 2003 $74,622,712 $74,622,712 0.00% 2004 $89,802,552 2005 $108,459,755 $89,802,552 $108,459,755 0.00% Note: Debt Limitation: Under Section 30-35-201, Colorado Revised Statutes, 1973, the County may incur indebtedness for general County purposes in an amount not to exceed 3% of assess valuation of all taxable property. 0.00% 144 2006 2007 $126,118,475 $134,053,874 $126,118,475 0.00% $134,053,874 0.00% 2008 $136,974,703 $136,974,703 0.00% 2009 2010 2011 $173,123,816 $141,036,269 $162,655,885 $173,123,816 $141,036,269 0.00% $162,655,885 0.00% 0.00% COUNTY OF WELD STATE OF COLORADO Private Purpose Revenue Bonds December 31, 2011 INDUSTRIAL REVENUE BONDS: ISSUER Centennial Area Health Education Central GSSLB Association Nursing Home Greeley Center for Independence, Inc TYPE OF FACILITY Office Nursing Home DEBT ISSUE OUTSTANDING AMOUNT DATE BEGINNING OF YEAR ISSUED RETIRED 388,000 5/99 228,738 0 20,578 2,020,000 10/98 1,090,000 0 55,000 Therapeutic 1,650,000 9/03 Center North Range Behavioral Health Office TOTAL PRIVATE PURPOSE REVENUE BONDS 1,201,597 4,500,000 5/07 3,131,960 $5.652.295 0 73,537 0 120,780 $4 $2669 895 REVENUE BOND OUSTANDING END OF YEAR $208,160 $1,035,000 $1,128,060 $3,011,180 $5.382.400 146 COUNTY OF WELD STATE OF COLORADO Demographic and Economic Statistics Last Ten Years Year 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 Population 202,329 207,120 217,652 221,957 229,377 236,908 244,515 251,220 252,825 254,759 Total Personal Income Per ($ billion) Capita Income 5.02 5.14 5.38 5.79 5.84 6.23 6.66 7.38 7.07 6.93 24,571 24,279 25,274 25,968 25,495 26,280 27,238 27,788 28,503 27,186 Unemployment Rate 6.10% 6.70% 5.40% 5.00% 3.80% 4.63% 6.30% 8.16% 9.80% 9.10% Source: Upstate Colorado in cooperation with University of Northern Colorado and the State of Colorado demographer. 147 COUNTY OF WELD STATE OF COLORADO Principal Employers Current Year and Nine Years Ago 2011 2002 JBS Swift Beef Company Banner Health (NCMC) School District 6 State of Colorado (includes UNC ) Vestas Weld County Government State Farm Insurance Companies Aims Community College City of Greeley Carestream Health Inc StarTek Inc Eastman Kodak Company Total Principal Employers Other Employers Total County Employment Source: Upstate Colorado Percent Of Total County Employees Rank Employment 4500 1 4.04% 3000 2 2.69% 2300 3 2.06% 1658 4 1.49% 1600 5 1.44% 1372 6 1.23% 1350 7 1.21% 900 8 0.81% 874 9 0.78% 521 10 0.47% Percent Of Total County Employees Rank Employment 3370 1 3.77% 1857 4 2.08% 1994 3 2.23% 2052 2 2.30% 1200 9 1.34% 1350 7 1.51% 1596 6 1.78% 1078 10 1.21% 1257 8 1.41% 1800 5 2.01% 18,075 16.22% 17,554 19.64% 93,359 83.78% 71,844 80.36% 111,434 100.00% 89,398 100.00% 149 COUNTY OF WELD STATE OF COLORADO Full -Time Equivalent County Government Employees by Function/Program Last Ten Years 2002 2003 2004 2005 2006 2007 Function/Program General government Public safety (1) Public works Health and welfare(2) Culture and recreation Economic assistance (3) Total General Government Business -type activities: Paramedic service Total primary government 252 241 241 247 256 258 260 267 267 275 279 308 140 155 155 139 167 167 253 258 258 286 305 337 122111 164 162 161 181 166 173 1,070 1,085 1,084 1,129 1,174 1,244 57 57 57 62 63 67 1,127 1,142 1,141 1,191 1,237 1,311 Source: Weld County Human Resources Notes (1) A traffic unit was added in 2001 funded by the CDOT Office of Highway Safety Grant and initially requiring 5 positions The North Jail Complex was built in 1997 with 160 beds and a staffing level of 75. Phase II added 226 beds in 2004 and increased projected 2005 staffing to 132. Phase 111 construction in 2006-07 added 374 beds and increased staffing of 42 in 2007. Twelve additional management and support positions were added in 2008. The deferred opening of 122 secure confinement beds contained prevented further hiring. (2) The demand for welfare and public health care has increased more rapidly with the economic downturn. (3) As of 12/31/2009 Headstart responsibilites were relinquished back to the Federal Agency for operational purposes. 150 2008 2009 2010 2011 269 247 244 251 352 365 345 351 165 163 161 161 357 372 378 368 1122 148 144 78 73 1,292 1,292 1,208 1,206 74 72 69 69 1,366 1,364 1,277 1,275 151 COUNTY OF WELD STATE OF COLORADO Operating Indicators by Function/Program Last Ten Years Function/Program General government: Motor vehicle registration Registered voters (1) Number of votes cast (2) Percent of registered voters voting Public safety: Adult arrests Juvenile arrests Average secure jail population E911 calls Building Permits Valuation (thousands) Public works: Miles of road graveled Snow removal lane miles Grading lane miles Miles of Upgrade -Aggregate Surfaced Roads Culverts (new and repaired) 15" and larger Tons of asphalt laid Tons of gravel crushed Health and welfare: Social Services Caseload Patient contacts Immunizations Culture and recreation: Visitors -Missile Park County Fair Exhibitors Economic assistance: (3) Headstart clients Migrant Headstart clients Business -type activities: Paramedic Services Patients transported 2002 305,879 85,161 56,730 66.6% 2003 2004 2005 2006 433,188 76,245 32,476 42.6% 439,146 98,692 89,099 90.3% 462,877 99,711 46,327 46.5% 466,777 100,924 68,871 68.2% 1,435 2,738 1,387 1,543 1,574 337 491 218 206 215 330 371 402 455 579 84,420 72,396 75,276 79,425 92,045 2,082 1,941 2,012 2,082 1,972 $125,336 $201,442 $132,178 $104,225 $399,473 440 440 401 401 160 1390 1,406 33,710 78,435 125,225 131,171 126,000 175,910 165,681 164,906 5 8 10 0 10 240 240 217 217 242 80,055 101,243 95,634 95,634 70,421 500,000 510,000 487,477 487,477 408,409 9,900 16,207 5,848 9,900 14,601 4,600 12,000 15,000 7,500 14,000 11,000 6,900 14,500 30,440 6,360 695 558 575 575 586 2,370 2,410 2,410 2,220 2,422 577 641 622 562 562 200 146 175 266 266 7,027 7,060 7,331 7,284 8,375 Source: Various Weld County Department records. Note: (1) Beginning in 1999 the number of registered voters reflects active voters. (2) Even years represent general elections, odd years coordinated elections. (3) As of 12/31/2009 Headstart responsibilites were relinquished back to the Federal Agency for opearational purposes. 152 2007 2008 2009 2010 2011 484,412 493,544 478,202 482,841 541,678 88,601 116,269 112,276 145,692 101,085 30,203 106,518 34,027 80,893 42,937 34.1% 91.6% 30.3% 55.5% 42.5% 1,606 1,122 1,059 1,084 1,795 224 110 98 96 73 628 610 538 570 557 95,524 99,951 95,383 95,866 93,900 2,000 2,571 1,976 2,143 2,316 $100,609 $120,118 $86,794 $392,380 $126,194 359 312 205 416 419 222,703 94,685 176,786 77,889 89,503 135,779 148,324 152,568 154,602 133,297 34 52 33 36 41 250 252 233 264 254 67,389 67,548 90,664 101,431 86,805 411,582 231,359 282,315 372,709 436,880 15,000 11,880 7,165 15,500 11,500 7,000 16,000 15,000 7,000 20,500 11,769 8,159 23,017 8,778 7,333 595 600 600 500 650 2,326 2,335 2,425 2,383 2,436 562 562 562 266 275 180 0 0 0 0 8,210 8,866 9,214 9,214 9,470 153 COUNTY OF WELD STATE OF COLORADO Capital Asset Statistics by Function/Program Last Ten Years 2002 2003 2004 2005 2006 Function/Program General government: Building Square Footage 604,100 620,310 684,551 684,551 719,723 Court rooms 9 9 10 12 16 Information Systems Connections 959 997 1,240 1,292 1,292 Public safety: Jail capacity (beds) Patrol cars Radios and cell phones Public works: Miles of Roads Paved Unpaved Un-maintained Grader sheds Motor graders 454 454 386 386 386 44 43 42 46 55 857 947 939 1,140 1,229 670 679 671 681 675 2,457 2,438 2,425 2,394 2,387 253 250 252 512 327 18 18 18 18 18 30 29 30 30 30 Health and welfare: Alternative fuel vehicles 4 5 6 4 4 Economic assistance: Headstart sites Business -type activities: Paramedic Services Ambulances 12 11 11 11 11 10 10 10 10 10 Source: Weld County Department records and Fixed Asset Inventory 2007 2008 2009 2010 2011 725,723 854,081 860,399 984,052 984,052 16 17 22 22 21 1,292 1,320 1,320 1,320 1,320 386 760 760 760 779 55 55 62 60 60 1,270 1,359 1,179 1,220 1,064 670 684 674 689 696 2,370 2,352 2,331 2,307 2,289 492 490 493 351 354 18 18 18 18 18 30 30 30 30 30 4 4 5 5 5 11 11 0 0 0 11 11 11 12 12 155 COUNTY OF WELD STATE OF COLORADO Insurance in Force December 31, 2011 Name of Company Safety National Casualty Company Lexington One Beacon Policy Number SP4041255 Policy Period Begins Expires Details of Coverage 12/31/10 12/31/12 Excess Worker's Compensation 20412751 01/01/10 01/01/12 Property damage, automobile liabilities, 7910003550000 1/1/2011 1/1/2012 Excess Liability Liability Limits Employer's Liability $1,000,000/Accident. Worker's Compensation Statutory Limits with County retaining first $600,000 each claim. Property: $100,000,000/ occupancy/$500 deductible. Crime: $150,000/Loss All Liability: $250,000/person; $600,000/claim. Excess Liability: (Federal and Out -of -State Only) $6,000,000/liability. Excess $250,000: $600,000/Claim. County retaining first $125,000 each claim. Excess $250,000 $10,000,000 liability coverage per occurrence $0 Deductible for liability claims with the exception of: Employment Termination - $10,000 Inverse Condemnation Regulatory Taking - $ 125,000 Herbicide and Pesticide - $2,500 Lawyer's Professional Liabilty - $500 Annual Premium $95,493 $275,488 156 Hello