Loading...
HomeMy WebLinkAbout931003.tiff COMPREHENSIVE ANNUAL * FINANCIAL Elk r� � REPORT COLORADO Year Ended December 31 , 1992 - COUNTY of WELD Aocoli STATE of COLORADO nA°21 931CO3 C�/,9093 COMPREHENSIVE ANNUAL FINANCIAL REPORT COUNTY OF WELD STATE OF COLORADO YEAR ENDED DECEMBER 31, 1992 Issued by: Department of Finance & Administration Donald D. Warden, Director Finance and Administration othr Wilk COLORADO. INTRODUCTORY SECTION 00(t . COLORADO TABLE OF CONTENTS Page INTRODUCTORY SECTION Table of Contents 1 Letter of Transmittal 7 Government Finance Officers Association Certificate of Achievement for Excellence in Financial Reporting 23 Organization Chart 24 Principal County Officials 25 FINANCIAL SECTION INDEPENDENT AUDITORS' REPORT 27 GENERAL PURPOSE FINANCIAL STATEMENTS COMBINED BALANCE SHEET - ALL FUND TYPES AND ACCOUNT GROUPS . . . . 30 COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - ALL GOVERNMENTAL FUND TYPES AND EXPENDABLE TRUST FUNDS 32 COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL - ALL GOVERNMENTAL FUND TYPES 34 COMBINED STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS/FUND BALANCES - ALL PROPRIETARY FUND TYPES, PENSION TRUST AND NONEXPENDABLE TRUST FUNDS 36 COMBINED STATEMENT OF CASH FLOWS- ALL PROPRIETARY FUND TYPES AND NONEXPENDABLE TRUST FUNDS 37 NOTES TO FINANCIAL STATEMENTS 38 COMBINING, INDIVIDUAL FUND AND INDIVIDUAL ACCOUNT GROUP FINANCIAL STATEMENTS AND SCHEDULES GENERAL FUND BALANCE SHEET 63 STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE, BUDGET AND ACTUAL 64 SPECIAL REVENUE FUNDS EXPLANATIONS OF INDIVIDUAL FUNDS 69 COMBINING BALANCE SHEET 70 COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES 72 (1) TABLE OF CONTENTS - (CONTINUED) Page SPECIAL REVENUE FUNDS (Continued) : Road and Bridge Fund - Statement of Revenues and Expenditures and Changes in Fund Balance, Budget and Actual 74 Social Services Fund - Statement of Revenues and Expenditures and Changes in Fund Balance, Budget and Actual 76 Conservation Trust Fund - Statement of Revenues and Expenditures and Changes in Fund Balance, Budget and Actual 78 Contingent Fund - Statement of Revenues and Expenditures and Changes in Fund Balance, Budget and Actual 79 Emergency Fund - Statement of Revenues and Expenditures and Changes in Fund Balance, Budget and Actual 80 Public Health Fund - Statement of Revenues and Expenditures and Changes in Fund Balance, Budget and Actual 81 Human Resources Fund - Statement of Revenues and Expenditures and Changes in Fund Balance, Budget and Actual 82 Solid Waste Fund - Statement of Revenues and Expenditures and Changes in Fund Balance, Budget and Actual 84 Housing Authority Fund - Statement of Revenues and Expenditures and Changes in Fund Balance, Budget and Actual 85 CAPITAL PROJECTS FUND EXPLANATION OF INDIVIDUAL FUND 87 BALANCE SHEET 88 CAPITAL EXPENDITURES FUND - STATEMENT OF REVENUES EXPENDITURES, AND CHANGES IN FUND BALANCE, • BUDGET AND ACTUAL 89 ENTERPRISE FUND EXPLANATION OF INDIVIDUAL FUND 91 (2) TABLE OF CONTENTS - (CONTINUED) Page ENTERPRISE FUND (Continued) : BALANCE SHEET 92 AMBULANCE FUND - STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS, COMPARED WITH BUDGET 93 INTERNAL SERVICE FUNDS EXPLANATIONS OF INDIVIDUAL FUNDS 95 COMBINING BALANCE SHEET 96 COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS 98 COMBINING STATEMENT OF CASH FLOWS 100 Motor Vehicle Fund - Statement of Revenues, Expenses and Changes in Retained Earnings, Compared with Budget . . 102 Health Insurance Fund - Statement of Revenues, Expenses and Changes in Retained Earnings, Compared with Budget . . 103 Printing and Supply Fund - Statement of Revenues, Expenses, and Changes in Retained Earnings, Compared with Budget 104 Computer Services Fund - Statement of Revenues, Expenses, and Changes in Retained Earnings, Compared with Budget 105 Insurance Fund - Statement of Revenues, Expenses and Changes in Retained Earnings, Compared with Budget 106 PBX Fund - Statement of Revenues, Expenses and Changes in Retained Earnings, Compared with Budget . 107 TRUST AND AGENCY FUNDS EXPLANATIONS OF INDIVIDUAL FUNDS 109 COMBINING BALANCE SHEET 110 STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND BALANCES - PENSION TRUST FUND 112 COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - ALL EXPENDABLE TRUST FUNDS 113 COMBINING STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN FUND BALANCE - ALL NONEXPENDABLE TRUST FUNDS 114 (3) TABLE OF CONTENTS - (CONTINUED) Page TRUST AND AGENCY FUNDS (Continued) : COMBINING STATEMENT OF CASH FLOWS - ALL NONEXPENDABLE TRUST FUNDS 115 COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES -- ALL AGENCY FUNDS 116 GENERAL FIXED ASSETS ACCOUNT GROUP SCHEDULE OF GENERAL FIXED ASSETS - BY SOURCE 117 SCHEDULE OF GENERAL FIXED ASSETS - BY FUNCTION AND ACTIVITY . . 118 SCHEDULE OF CHANGES IN GENERAL FIXED ASSETS - BY FUNCTION AND ACTIVITY 119 GENERAL LONG-TERM DEBT ACCOUNT GROUP SCHEDULE OF GENERAL LONG-TERM DEBT 121 STATISTICAL SECTION Tables Relating to Bonded Debt 123 General Governmental Expenditures by Function 124 General Revenue by Source 124 Property Value, Construction, Bank Deposits and Other Economic Indicators 126 Property Tax Levies and Collections 127 Assessed and Estimated Actual Value of Taxable Property 127 Property Tax Rates and Tax Levies - Direct and Overlapping Governments 128 Special Assessment Collections 129 Computation of Legal Debt Margin 130 Demographic Statistics 131 Principal Taxpayers 132 Miscellaneous Statistics 133 Insurance In Force 135 Salaries of Principal Officials 136 Surety Bond Coverage for Principal Officials 136 (4) TABLE OF CONTENTS - (CONTINUED) Page STATISTICAL SECTION (Continued) : Private Purpose Revenue Bonds 137 Retirement Plan Required Supplementary Information 138 Computation of Overlapping Bonded Debt - General Obligation Bonds 139 COMPLIANCE SECTION INDEPENDENT AUDITORS' REPORT ON SCHEDULE OF FEDERAL FINANCIAL ASSISTANCE 141 SCHEDULE OF FEDERAL FINANCIAL ASSISTANCE 142 SCHEDULE OF FINDINGS AND QUESTIONED COSTS 151 INDEPENDENT AUDITORS' REPORT ON COMPLIANCE WITH SPECIFIC REQUIREMENTS APPLICABLE TO MAJOR AND NONMAJOR FEDERAL FINANCIAL ASSISTANCE PROGRAMS 152 INDEPENDENT AUDITORS' REPORT ON COMPLIANCE WITH THE GENERAL REQUIREMENTS APPLICABLE TO FEDERAL FINANCIAL ASSISTANCE PROGRAMS 154 INDEPENDENT AUDITORS' REPORT ON COMPLIANCE 155 INDEPENDENT AUDITORS' COMBINED REPORT ON THE INTERNAL CONTROL STRUCTURE 156 (5) Wilk COLORADO (6) DEPARTMENT OF FINANCE AND ADMINISTRATION PHONE(303)358J000 4218 BOX 758 hiDe. -- COLORADO May 22, 1993 Honorable Board of Commissioners County of Weld 915 10th Street Greeley, CO 80631 Dear Board Members: The comprehensive annual financial report of the County of Weld, State of Colorado for the fiscal year ended December 31, 1992, 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 are accurate in all material respects and are 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. All disclosures necessary to enable the reader to gain an understanding of the County's financial activities have been included. The comprehensive annual financial report is presented in four sections: introductory, financial, statistical and compliance. The introductory section includes this transmittal letter, the government's organizational chart and a list of principal officials. The financial section includes the general purpose financial statements and the combining and individual fund and account group financial statements and schedules, as well as the independent auditors' report on the financial statements and schedules. The statistical section includes selected financial and demographic information, generally presented on a multi-year basis. The County is required to undergo an annual single audit in conformity with the provisions of the Single Audit Act of 1984 and U.S. Office of Management and Budget Circular A-128, Audits of State and Local Governments. Information related to this single audit, including the schedule of federal financial assistance, findings and recommendations, and auditors' reports on the internal control structure and compliance with applicable laws and regulations, are included in the compliance section of this report. The funds and entities related to the County of Weld that are in our Comprehensive Annual Financial Report include those of separately administered organizations that are controlled by or dependent on the County. (7) Honorable Board of Commissioners - Continued: Control or dependence is determined on the basis of budget adoption, taxing authority, funding, scope of public service, ability to influence operations, designation of management, and appointment of the respective governing board. Based upon the foregoing criteria, the financial statements of the following organizations are included in the accompanying financial statements: • Weld County Housing Authority • Weld County Public Health Board • Weld County Retirement Board • Weld County Finance Corporation • Weld County E-911 Board • Crime Victim Compensation Board The following are not part of Weld County and are excluded from the accompanying financial statements: • North Colorado Medical Center • Greeley-Weld Airport Authority • Weld Library District Details of the criteria applied and the specific reasons for inclusion or exclusion are contained in the Notes to Financial Statements. 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. ECONOMIC CONDITION AND OUTLOOK We are very fortunate to have a strong, diversified base of companies to build upon in Weld County. Firms such as ConAgra, Eastman Kodak, Hewlett Packard, Norwest Publishing, Greeley Trading/Pronto Foods, Adolph Coors, Western Sugar, Harsh Hydraulics, State Farm Insurance Regional offices, Plastic Art Products, Metal Container, Electronic Fab Technology Company, Longmont Foods, R & R Custom Woodworking, Universal Forest Products, and Noffsinger Manufacturing, to mention a few. Employers such as these have invested over $375 million in Weld County since 1988, and have created in excess of 1,400 new jobs. In the last year, the impact of our existing base of employers was once again evident. Of the 445 new jobs tracked from the first of the year, 70% were created by existing employers. In addition, approximately 98% of the estimated $74 million in new investment was a result of existing industry expansion activities. While retention activities typically do not make front-page headlines, these activities are easily the most cost- effective form of economic development, and the backbone of a strong business climate. (8) Honorable Board of Commissioners - Continued: Some of the existing Weld County companies announcing expansion in the last year are listed below: Current Year New Existing Company Expansion Investment Employees Golden Aluminum, Ft. Lupton $5 million -- Kodak of Colorado, Windsor $50 million + 100 Jefferson Tile, Weld County $250,000 20 Kendall Printing, Greeley $2 million 15 Norwest Publishing, Greeley $10 million 20 Mid-America Engineering and Fabrication, Frederick $300,000 8 Plastic Art Products, Greeley $200,000 30 Greeley Trading, Greeley $750,000 10 Monfort Portion Foods, Greeley $400,000 50 Metal Container Corp. , Windsor $1 million -- Over the past several years, we have found that our existing employment base -- industrial as well as agricultural -- is an excellent tool for attracting new industry to the area. A tool that will be further defined and utilized in our stepped-up efforts to attract quality companies. Successful, targeted prospecting is vital to the continued health and prosperity of Weld County. "New blood" is needed in order to further diversify our economy and provide additional employment opportunities. However, the process of developing a new project can be very lengthy and involved -- sometimes taking months to bring to a close. The economic development efforts of Weld County and Greeley, through the Economic Development Action Partnership, spent a great deal of time in the last year positioning the organization to carry out an expanded, aggressive marketing program. A program that will include one-on-one contact with potential companies looking for a new location. At the current time there are several companies considering a Weld location. In addition, staff is in contact with over a dozen firms who have expressed interest in the area. Weld County is located in northeastern Colorado. Weld County has maintained its rank as the fourth most productive agricultural county in the nation based upon a U.S. Department of Commerce Census of Agriculture report. The ranking came even before National Hog Farms expanded into Weld County, before ConAgra opened its lamb processing plant, and before Longmont Foods made several additions in Weld County. National Hog Farms will sell 300,000 hogs and pigs annually. (9) Honorable Board of Commissioners - Continued: Although Weld is number four in overall agricultural production it is ranked number one in the nation in several other categories: value of livestock, poultry and their products; sheep and lambs inventory; sheep and lambs sold; the number of cattle and calves sold; and the number of cattle fattened on grain. Weld was second in value of cattle and calves sold. Despite its high ranking in many categories, Weld was ranked 72nd in the nation in government payments. About the only crops grown in the County which are eligible for direct payments to farmers are wheat and corn. Many other crops popular in Weld -- such as onions, corn silage, dry beans and other vegetables -- do not receive government payments. Weld County is the third most productive oil and gas county in the Rocky Mountain Region. Drilling activity and production are up substantially in 1991-92 due to tax law changes effective January 1, 1993. The prospects for the energy industry look good for 1993. Over 1,000 drilling permits have been taken out in Weld County in 1992. Weld's unemployment rate has consistently been decreasing over the past couple of years, with more and more employers reporting some difficulty in finding employees. This trend, no doubt, will eventually force the pay scale up. However, companies consistently reported that Weld County remains an excellent place to do business, primarily due to the exceptional quality of the labor force. The Northern Colorado economy should remain more active and healthy than the national economy during the next decade. As long as the agricultural sector in Weld County does well and economic diversification continues making the advances it made in the past, Weld County's economy will also do better than the national economy as a whole. Skilled, highly educated labor moves to areas where the quality of life is high. Businesses that are footloose follow the highly skilled, educated workers. Less educated, lower skilled workers follow the footloose industries. Since the Northern Colorado economy has a high quality of life, it will continue to be an attractive place to live. This quality of life becomes part of the foundation for future economic growth and development. Once the process of growth has begun, it is possible to use industrial targeting to increase the amount of development that occurs. (10) Honorable Board of Commissioners - Continued: Weld County is fortunate to have a diverse group of employers that support continued growth through expansion of existing companies, or new company locations. We are confident that Weld County will continue to be successful in retaining and attracting business to keep our local economy growing. The success Weld County has experienced is due to a variety of factors, including: • A stable and diversified economy. Weld County ranks among the top counties nationally in the value of its agricultural products, is the second highest producing Colorado county in oil/natural gas production, and consistently ranks as one of the top Colorado counties in the value of its manufactured products. • Weld County has experienced a continued, steady population growth rate. • County and city governments are aggressively pro-business, offering planned industrial properties and attractive incentives programs. Greeley and Weld County have been designated a state Enterprise Zone, allowing qualified businesses to take credit against their state income taxes for equipment investment and jobs. • Weld County's labor force represents the best of all possible worlds. Entry wage rates generally fall in the $4.50-$6.00/hour range, and our employees represent a solid Midwestern work ethic. Organized labor represents approximately 3% of our manufacturing workforce. • An excellent transportation system provides easy access to national and growing regional markets. Two interstate highways (I-25 and I-76) and two U.S. highways (U.S. 34 and U.S. 85) serve the county, and two additional interstate highways border Weld County (I-70 and 1-80) . Fourteen motor freight firms and three railroads provide freight service. Commercial air service is provided by 18 carriers operating from Denver's Stapleton Airport to 186 cities and nine countries; the airport is an hour's drive from the County's population centers. The new Denver International Airport under construction will be located at the southern edge of Weld County (completion - 1994) , about 45 minutes from Greeley. (11) Honorable Board of Commissioners - Continued: • Weld County offers an outstanding quality of life. Within a 50- mile radius are located four major universities with the attendant cultural and athletic events, the Denver metropolitan area forms the County's southern boundary, and six major ski areas are located within a two-hour drive. Weld County is home to the oldest philharmonic orchestra west of the Mississippi River, and is the site of the largest civic auditorium in Northern Colorado. Rocky Mountain National park, 50 miles to the west, offers outstanding outdoor activities. Twelve school districts offer quality education to over 22,000 students. Small town atmosphere with access to all of the recreational and cultural amenities of larger metropolitan areas, make this an ideal area to work and raise a family. MAJOR INITIATIVES For the Year: In the 1992 budget process, 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 1992: • Conducted the Presidential Preference Primary for the first time in Colorado. • Constructed a new 30,000 square foot office building to house the Assessor, Treasurer, Planning/Building Inspection, and Clerk and Recorder. • Begin the design to remodel the Centennial Complex to provide 94 minimum security beds for County jail. • Construct a juvenile holding facility. • Developed a second year program of a Drug Task Force in conjunction with the municipalities in Weld County (Sheriff) . • Identified and implemented jail alternatives to prolong the life of present correctional facility (Sheriff) . • Implemented Colorado Weed Management Act enacted in 1990 county-wide. (12) Honorable Board of Commissioners - Continued: • Expanded support of two additional senior centers (Mead and Hill 'N Park) . • Reconstructed the following major bridges: Bridge Cost 60/29 $288,800 19/68 304,000 8 (Erie) 348,000 • Worked with Kellogg Foundation to develop a model of community-based public health programs. • Implemented a program with School District #6 and Head Start by co-locating Head Start facilities on District 6 school sites to better integrate Head Start and elementary schools (HRD) . • Convert Youth Shelter Home to 16-bed residential child care facility for troubled youth under contract with a non-profit provider. For the Future: As Weld County looks to 1993, a number of significant changes will be in focus for the Board and staff to meet the needs of the County. The passage of State Constitutional Amendment One (TABOR) will have a significant impact on the future of Weld County government. The tax, revenue, and spending limitation will constrain many of the fiscal options historically available to Weld County. The provision allowing the return of unfunded state mandates to the state over a three year period will significantly change the face of county programs in Colorado over time. The 1993 budget has been developed within the limitations of Amendment One with the Social Services mandate turnback. In the event the State resists the turnback of Social Services programs, a contingency fund has been provided. Future projections indicate a continued demand and expansion of programs in the criminal justice sector of the County. To cope with the growing drug problem a Drug Task Force has been developed in conjunction with the municipal law enforcement agencies, Sheriff and District Attorney. The capacity of the Community Corrections program is being expanded to help relieve the State's prison overcrowding problem. Jail alternative programs are being implemented to prolong the life of the County jail. Even with these programs the County will be remodelling a portion of the Centennial Complex in 1993 to add 94 minimum security beds. (13) Honorable Board of Commissioners - Continued: In the area of human services Weld County is continuing to modify job and public assistance programs to implement the JOBS program and AFDC-U program in accordance with state and federal guidelines. Concurrent with this implementation Weld County is seeking special state legislation and federal waivers from HHS to re-enact a Welfare Diversion program similar to the one operated successfully for ten years prior to the federal JOBS legislation. This effort could be moot if the state takes back Social Services programs under the mandate turnback provision of Amendment One (TABOR) . To meet the needs of juveniles, a new juvenile detention facility will be constructed in 1993. The facility will only be a six-hour holding facility to screen youth and hold them pending transportation to the state facility or court appearance. The Sheriff's Office made a significant reorganization change for 1993 by eliminating the traditional paramilitary organizational structure to streamline the management hierarchy. The change provides only for a vertical communication channel with a maximum of two intermediate levels of hierarchy levels between the Sheriff and line workers. The structure allowed, within the same salary budget, for more staff to get into the field and jail for improved safety and service by eliminating several management positions. Construction of the new Denver International Airport, which is scheduled for completion in 1994, continues. The site of the new airport is less than 15 miles from the southern border of Weld County. The spin-off growth from the airport is expected to positively impact Weld County from Greeley south. The County is positioning itself to deal with this growth as it impacts land use, transportation, human service requirements, and economic development. Program changes for 1993 involve the following: • Remodel the Centennial Complex to provide 94 minimum security beds for County jail. • Develop third year program of a Drug Task Force in conjunction with the municipalities in Weld County (Sheriff) . • Expand Work Release Program in Jail to at least double the current capacity of 24 inmates. • Identify and implement jail alternatives to prolong the life of present correctional facility (Sheriff) . • Implement the requirements of Clinical Laboratory Improvement Act. (14) Honorable Board of Commissioners - Continued: • Consolidate Weld County Communications with the City of Greeley's communication center under the direction of the Greeley Police Department. • Reconstruct the following major bridges: Bridge Cost 60/29 $ 99,000 35/78A 266,000 14.5/25A 1,205,593 • Explore the implementation of a new automated criminal justice system • Remodel Centennial Complex and Courthouse to accommodate expanded jail and court space needs. • Turnback one-third of Social Services costs to the State of Colorado in accordance with Amendment One (Tabor) . • Develop a long term strategy to deal with the fiscal constraints of Amendment One (TABOR) . • Re-evaluate all insurance programs in light of TABOR. • Initial "Reinventing Weld County Government" Project to examine priorities, what services to provide, best way to deliver services, and most cost effective way to provide services with the constraints of TABOR. Department Focus: In 1992, the purchasing system was redesigned and rewritten to enhance its capabilities and make it easier to use at the user level in the various County departments. Minor enhancements were done to the fully integrated financial system. The financial system now integrates the accounting, purchasing, outstanding warrant, budget, payroll, fixed asset, and accounts receivable systems into one overall system for financial management. The entire system, as implemented, has on-line inquiry capabilities for all departments and on-line input for accounting, purchasing, and payroll staff. A new automated system was used for the preparation of schedules used in the annual audit and in the preparation of the financial statements. The cost accounting system for the road and bridge system was revamped and updated to comply with new statutory requirements. (15) Honorable Board of Commissioners - Continued: FINANCIAL INFORMATION Management of the County is responsible for establishing and maintaining an internal control structure designed to ensure that the assets of the County are protected from loss, theft or misuse and to ensure that adequate accounting data are compiled to allow for the preparation of financial statements in conformity with generally accepted accounting principles. The internal control structure is designed to provide reasonable, but not absolute, assurance that these objectives are met. The concept of reasonable assurance recognizes that: (1) the cost of a control should not exceed the benefits likely to be derived; and (2) the evaluation of costs and benefits requires estimates and judgments by management. Single Audit. As a recipient of federal and state financial assistance, the County also is responsible for ensuring that an adequate internal control structure is in place to ensure compliance with applicable laws and regulations related to those programs. This internal control structure is subject to periodic evaluation by management and external auditors. As a part of the County's single audit, described earlier, tests are made to determine the adequacy of the internal control structure, including that portion related to federal financial assistance programs, as well as to determine that the County has complied with applicable laws and regulations. The results of the County's single audit for the fiscal year ended December 31, 1992 indicated no instances of material weaknesses in the internal control structure or significant violations of applicable laws and regulations. Budgeting Controls. In addition, the County maintains budgetary controls. The objective of these budgetary controls is to ensure compliance with legal provisions embodied in the annual appropriated budget approved by the government's governing body. Activities of the general fund, special revenue funds, capital project fund, enterprise fund and internal service funds are included in the annual appropriated budget. The level of budgetary control (that is, the level at which expenditures cannot legally exceed the appropriated amount) is established at the fund level, except for the General fund which is at the department level. The government also maintains an encumbrance accounting system as one technique of accomplishing budgetary control. Purchase orders which result in an overrun of department balances are not released until additional appropriations are made available. Encumbered amounts lapse at year end. However, encumbrances generally are reappropriated as part of the following year's budget. As demonstrated by the statements and schedules included in the financial section of this report, the government continues to meet its responsibility for sound financial management. All dollar amounts presented in tables in the remainder of this letter are expressed in thousands. (16) Honorable Board of Commissioners - Continued: GENERAL GOVERNMENT FUNCTIONS Revenue for general government functions including General, Special Revenue, Capital Projects and Expendable Trust Funds totalled $74,368,306 in 1992, an increase of 4.8% over 1991. General property taxes and specific ownership taxes produced 33.6% of total revenue, the same as in 1991. The amount of revenue from various sources and the changes from 1991 are shown in the following tabulation: Increase Amount Percent (Decrease) Revenue Sources (In Thousands) of Total from 1991 Taxes $ 24,962.0 33.6 $ 1,094.3 Licenses and Permits 840.9 1. 1 193.3 Intergovernmental Revenue 40, 185. 7 54.0 2,380.5 Charges for Services 2, 410.9 3.2 435.9 Fines and Forfeitures 34.3 . 1 (22.4) Miscellaneous Revenue 3,443.6 4.6 (678.0) Fees 2,490.9 3.4 17.5 Total $ 74,368.3 100.0% $ 3,421.1 The mill levy is 22.457, up .248 mills. The assessed value for the 1992 budget is $1, 055,190,650, which is up $46,531,430 or 4.6% from last year. The increase is primarily attributed to oil and gas property of $31.6 million, and industrial and commercial property of $29.0 million. Increases were offset by decreases in residential property of $8.2 million, state assessed property of $1.8 million, and agricultural properties of $5.1 million. Current tax collections were 99.4% of the tax levy, up .4% from 1991. Delinquent tax collections were $104, 726, compared with $311,671 in 1991. Allocations of property tax by purpose for 1991 and 1992 are shown as follows: 1991 1992 Purpose Mills Mills General Fund 13.273 13.593 Special Revenue Funds 7.408 7.469 Capital Project Fund .942 .835 Intergovernmental Service Funds .586 .560 Total Tax Rate 22.209 22.457 (17) Honorable Board of Commissioners - Continued: Intergovernmental Revenue represented 54.0% of total general governmental revenue, compared with 53.3% for 1991. Social Service program increases account for 78% ($1,861,077) of the intergovernmental revenue increase, which is caused by the increased caseload of the welfare system in the areas of AFDC, Foster Care, and Day Care. Expenditures for general governmental purposes including General, Special Revenue, Capital Projects, and Expendable Trust Funds totalled $74,849,928, an increase of 6.7% over 1991. Changes in levels of expenditures for major functions of the County over 1991 are shown in the following tabulation: Increase Amount Percent (Decrease) Expenditure Purpose (In Thousands) of Total from 1991 Current Operating: General Government $ 8,848.7 11.8 $ 68.0 Public Safety 11,321.9 15. 1 517.0 Public Works 11,949.5 15.9 537.5 Public Health & Welfare 28,990.4 38. 7 2, 171.3 Culture & Recreation 311.5 .4 50.2 Economic Assistance 8,679.5 11.6 1, 179. 1 Capital Outlay 2,433.6 3.3 269. 1 Debt Service 199.9 .4 (261.3) Intergovernmental 809.9 1.1 .2 Miscellaneous 1,305.0 1.7 176.0 Total $ 74,849.9 100.0% $ 4, 707. 1 Major factors impacting 1992 are public safety being up over last year with jail costs for food and medical expenses and the new drug task force accounting for nearly all of the increase. In general, government building rentals are down $100,650 due to paying off the Frederick library and Head Start facility. The election budget is impacted by approximately $90,000 due to Colorado's first Presidential Preference Election. The District Attorney's budget is up with the mid-year addition of a juvenile prosecutor. Salary increases were set at 4.5% for a gross cost of $850,752. General fund revenues are down due to loss of revenue from housing state inmates. Intergovernmental revenues are up due to Drug Task Force Grant. IV-D incentive payments are over $70,000, but budgeted in the Social Services Fund this year. (18) Honorable Board of Commissioners - Continued: Road and Bridge funding was stable for 1992 with overall budget and revenues down due to the completion of large state and federal bridge projects in the current year. Social Services experienced a substantial increase in 1992 with primary impacts in AFDC caseload growth, which is up 15%, AFDC Medicaid cases, and day care. The loss of the Welfare Diversion Program has adversely impacted these programs as predicted. FUND BALANCE Total fund balance and fund equity in the major operating funds were maintained at adequate levels. The General Fund balance of $1,535,078 was up $48,010 from last year. The $10,409,833 balance in the Special Revenue Funds was up from the previous year by 51%. Enterprise Operations: The County's enterprise operation is comprised of the Ambulance Service Fund. The Ambulance Service is a countywide advanced life support emergency medical service. The program is primarily supported by fees with a subsidy from the County of indirect support costs only. The operation did over 6,000 calls in 1992 and generated revenue of $2,080,426. Pension Trust Fund Operations: The operations of the Weld County Retirement Plan remained stable in 1992. The annual actuarial valuation continues to reflect a positive trend in the funding of the retirement plan, resulting in an excess funding capacity in the amount of $131,409. Internal Service Funds: The Internal Service Funds consists of six funds. The Motor Vehicle Fund provides maintenance to all vehicles owned by the county, as well as renting equipment to Road and Bridge and other various departments. The Health Insurance Fund provides dental and vision health coverage for all employees of the county. The Printing and Supply Fund provides the printing service and supply store for the county's use. The Computer Services Fund provides all data processing services to the county and other entities. The Insurance Fund provides workers' compensation, property and casualty insurance needs for the county. The PBX Fund provides all phone service to the county. Capital Project Funds: The Capital Expenditures Fund was established to account for all capital projects for general County use. At the end of each fiscal year, the completed project items are transferred to the General Fixed Asset account group. The County has developed a five year Capital Improvements Program outlining projected costs and probable sources of funding for various capital improvement projects. No major projects in that plan were pending at the end of 1992. Funds in 1992 were being accumulated for the remodel of the jail to be under construction in 1993. (19) Honorable Board of Commissioners - Continued: General Fixed Assets: The General Fixed Assets of the County are the fixed assets used in the performance of general governmental functions and exclude the fixed assets of the Proprietary Funds. As of December 31, 1992, the General Fixed Assets of the County amounted to $29,413,234. This amount represents the original cost of the assets and is considerably more than their present value. Depreciation of General Fixed Assets is not recognized in the County's financial statements. Debt Administration: In 1992 the County continued to have no bonded indebtedness. With the passage of HB 1579 in 1981, Section 30-35-201, C.R.S. , 1973 now allows the debt ceiling to be 3% of the assessed valuation of the County. Thus, Weld County maintains over a thirty million dollar allowable debt capacity in accordance with Colorado Revised Statutes. There are lease/purchase agreements which involve Certificate of Participation Bond Issues totalling $3,455,000 for the construction of the Human Resources Building and north administrative buildings. Cash Management: Cash temporarily idle during the year was invested in time deposits ranging up to 180 days to maturity. Interest earned on investments of cash held by the County Treasurer was recorded as revenue in the General Fund, with the exception of interest attributed to the Insurance Fund, Health Insurance Fund, Capital Expenditure Fund, Conservation Trust Fund, Housing Authority Fund, Ambulance Enterprise Fund, and the interest earned on certain deposits held for other taxing authorities. The amount of interest earned was $759,580 in 1992. The County's investment policy is to minimize credit and market risks while maintaining a competitive yield on its portfolio. Accordingly, deposits are either insured by federal depository insurance or collateralized. All collateral on deposits was held either by the government, its agent or a financial institution's trust department in the government's name. All of investments held by the government during the year and at December 31, 1992, are classified in the category of lowest credit risk as defined by the Governmental Accounting Standards Board. Risk Management: During 1992 Weld County continued to be a member of Colorado Counties Casualty and Property Pool. The pool offers full safety and risk management programs to minimize losses, together with 57 other Colorado counties. Effective January 1, 1992 Weld County became self- insured under a State permit for workers' compensation. (20) Honorable Board of Commissioners - Continued: OTHER INFORMATION Independent Audit: The Weld County Home Rule Charter requires an annual audit of the books of accounts, financial records, and transactions of all administrative departments of the County by independent certified public accountants selected by the Board of County Commissioners, and engaged for a period not to exceed five years. The accounting firm of Anderson & Whitney, P.C. was selected by the County. In addition to meeting the requirements set forth in the Charter, the audit also was designed to meet the requirements of the federal Single Audit Act of 1984 and related OMB Circular A-128. The auditors' report on the general purpose financial statements and combining and individual fund statements and schedules is included in the Financial Section of this report. The auditors' reports related specifically to the single audit are included in the Compliance Section. Awards: 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, 1991. This was the eleventh 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. 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 1992 annual appropriated budget dated December 11, 1991, for the ninth consecutive year. 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. (21) Honorable Board of Commissioners - Continued: ACKNOWLEDGEMENTS 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 1992 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, 1992. 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 should 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. Res ctfully su mitteeddai Donald D. Warden, Director Finance and Administration DDW/ch (22) 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, 1991 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. 4 IBM ETA w a: caneA President '� SErL ow �00acuo e er.„ Executive Director (23) >. iu CC Z W W u C: ON ¢ o L C ± el 0 W u LW W Y' O 14 M el C~ in h C t = O O VI C V i o Q W ° 6 u C H W W L L u W H mF. a a O. Q V C o 0 o C c E U o.a. 1— w W c C z i r o uN • O • N u C fi T y 7 ° .O Q O y U q m u z U • V V u u a ~ 0 ,...a Cr JeuC L V y .0 w c a • • m W n o c e e 0 U J O E % 6 V Cl• u U La W i IX CC!) •.- in cu O• O.^ .E ^u O mW v- b. o• ° O - ^ ° u 1 1 Z ; , o G m m W Vf - �• . = W H. 0.11 _ CI� O a VI • p CC ° U O V L 00 ea us ODL m O o m , s W ; L. A L _ I ° N _ in n C C mm I U O U Z u CI = —1 _ _ OIII G N I �.z C. O .. ., \ UI L• V — O J a. - ° ^I C Co I � _ _ _ _ „—,— _ c > II C tn� v V _ I U I_ u > • a r Z fig— a O No F Gw o In '-'lu — `- L e �on.s V m u °I • _ L• C la P o 7, o v u _ .i in>N El ta G 10:L' u WI 0 7 0 .,c c , u 01 %I f— u a p e N �= .. =� d C o e al.—, °.r w ? e = aN r < mn CO W i " w ° �+- 0 V '< aces j i.• c" r V a ° c c L Si L -J =Ill NO �I l' .. V a _ u p III C t L a-. Oct.... U aC7 u ra p uC o vu E Q V a Way.. U N' L6>a. ° I •U r (24) COUNTY OF WELD STATE OF COLORADO PRINCIPAL COUNTY OFFICIALS December 31, 1992 Board of County Commissioners W. H. Webster George Kennedy Constance Harbert C. W. Kirby Gordon E. Lacy County Treasurer Francis M. Loustalet County Clerk and Recorder Mary Ann Feuerstein County Assessor Warren LaSalle County Sheriff Ed Jordan County Coroner Wesley Hall Director of Finance & Administration Donald D. Warden Comptroller Claud Hanes Independent Auditors Anderson & Whitney, P.C. Certified Public Accountants (25) arpos 1 COLORADO (26) FINANCIAL SECTION Afir{t COLORADO ANDERSON &WHITNEY, P.C. ANCIERSON CERTIFIED PUBLIC ACCOUNTANTS 1001 Ninth Avenue ©WI--IITNEy — Greeley,Colorado 80631-4046 . ■ . ■ ■ (303)352-7990 FAX(303)352-1855 Independent Auditors' Report Board of County Commissioners County of Weld, Colorado Greeley, Colorado We have audited the accompanying general purpose financial statements of the County of Weld, Colorado as of and for the year ended December 31, 1992, as listed in the table of contents. These general purpose financial statements are the responsibility of the County's management. Our responsibility is to express an opinion on these general purpose financial statements based on our audit. We did not audit the financial statements of the Weld County Retirement Plan, which represent 77 percent and 89 percent, respectively, of the assets and revenue of the fiduciary fund type. Those statements were audited by other auditors whose report has been furnished to us, and our opinion, insofar as it relates to the amounts included for the Weld County Retirement Plan, is based solely on the report of the other auditors. We conducted our audit in accordance with generally accepted auditing standards. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the general purpose financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the general purpose financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall general purpose financial statement presentation. We believe that our audit and the report of other auditors provides a reasonable basis for our opinion. In our opinion, based on our audit and the report of other auditors, the general purpose financial statements referred to above present fairly, in all material respects, the financial position of the County of Weld, Colorado as of December 31, 1992, and the results of its operations and cash flows of its proprietary fund types and nonexpendable trust funds for the year then ended in conformity with generally accepted accounting principles. Our audit was conducted for the purpose of forming an opinion on the general purpose financial statements taken as a whole. The combining, individual fund and account group financial statements and schedules listed in the table of contents are presented for purposes of additional analysis and are not a required part of the general purpose financial statements of the County. Such information has been subjected to the auditing procedures applied in the audit of the general purpose financial statements and, in our opinion, which insofar as it relates to the Weld County Retirement Plan is based on the report of other auditors, is fairly stated in all material respects in relation to the general purpose financial statements taken as a whole. May 21, 1993 (27) MEMBERS OF AMERICAN INSTITUTE OF CERTIFIED PUBLIC ACCOUNTANTS SEC AND PRIVATE COMPANIES PRACTICE SECTIONS-AICPA DIVISION FOR CPA FIRMS ACCOUNTING FIRMS ASSOCIATED,INC. Wilk• COLORADO (28) GENERAL PURPOSE FINANCIAL STATEMENTS WliD o . COLORADO COLORADO COUNTY OF WELD STATE OF COLORADO COMBINED BALANCE SHEET - ALL FUND TYPES AND ACCOUNT GROUPS December 31, 1992 With Comparative Amounts as of December 31, 1991 Governmental Fund Types Special Capital General Revenue Projects ASSETS ASSETS: Cash and short-term investments $ 3,198,120 $ 11,959,445 $ 1,234,303 Investments 0 0 0 Receivables (net of allowance for uncollectibles): Current property tax 14,719,449 7,728,829 560,486 Delinquent property tax 189,114 104,206 12,027 Accounts 113,478 633,831 8,768 Special assessment 379,014 249,590 0 Due from other County funds 84,138 1,160,433 0 Due from other governmental units 232,408 1,084,548 0 Advances to other funds 200,000 75,000 0 Inventories 37,517 1,050,728 0 Other assets 43,650 100,766 0 Land 0 0 0 Buildings 0 0 0 Improvements other than buildings 0 0 0 Machinery and equipment 0 0 0 Construction in progress 0 0 0 Accumulated depreciation 0 0 0 Amount to be provided for retirement of general long-term debt 0 0 0 TOTAL ASSETS $ 19,196,888 $ 24,147,376 $ 1,815,584 LIABILITIES, FUND EQUITY AND OTHER CREDITS LIABILITIES: Accounts payable $ 481,914 $ 1,001,934 $ 51,727 Accrued liabilities 572,007 528,183 0 Due to other governments 0 57,837 0 Due to other County funds 1,192,311 370,390 0 Deferred revenue 15,173,908 8,174,907 581,167 Unexpended grant revenue 166,670 3,530,251 0 Other liabilities 0 58,532 0 Advances from other funds 75,000 0 340,856 Retainage payable 0 15,509 0 Long term debt 0 0 0 Deferred compensation payable 0 0 0 Total Liabilities 17,661,810 13,737,543 973,750 OTHER CREDITS: Investments in general fixed assets 0 0 0 FUND EQUITY: Contributed capital 0 0 0 Unreserved retained earnings 0 0 0 Reserved retained earnings 0 0 0 FUND BALANCES: Reserved 414,983 6,659,463 33,820 Unreserved: Designated for future years' expenditures 175,000 1,220,759 50,000 Undesignated 945,095 2,529,611 758,014 Total Fund Equity 1,535,078 10,409,833 841,834 TOTAL LIABILITIES, FUND EQUITY AND OTHER CREDITS $ 19,196,888 $ 24,147,376 $ 1,815,584 (Sae Notes to Financial Statements) (30) Proprietary Fiduciary Fund Type Fund Type Account Groups Memorandum Totals Enterprise Internal Trust and General General Long December 31 December 31 Fund Service Agency Fixed Assets Term Debt 1992 1991 $ 12,117 $ 1,542,367 $ 5,037,222 $ 0 $ 0 $ 22,983,574 $ 20,917,856 0 0 33,434,044 0 0 33,434,044 30,409,971 0 613,863 0 0 0 23,622,627 23,537,351 O 8,175 0 0 0 313,522 567,640 1,311 31,818 431,925 0 0 1,221,131 1,428,467 O 0 0 0 0 628,604 742,081 7,440 342,764 19,287 0 0 1,614,062 1,052,454 100,000 0 0 0 0 1,416,956 880,201 0 0 140,856 0 0 415,856 415,856 O 127,619 0 0 0 1,215,864 1,086,753 0 102,253 0 0 0 246,669 213,822 0 1,353,934 498,542 3,040,338 0 4,892,814 4,941,310 637,099 2,643,959 2,941,908 20,483,259 0 26,706,225 23,892,402 48,496 215,999 0 410,154 0 674,649 609,289 550,008 15,800,615 0 5,317,893 0 21,668,516 19,838,472 O 0 0 161,590 0 161,590 778,899 (215,123) (9,825,514) (360,000) 0 0 (10,400,637) (9,404,188) O 0 0 0 1,288,645 1,288,645 1,383,899 $ 1,141,348 $ 12,957,852 $ 42,143,784 $ 29,413,234 $ 1,288,645 $132,104,711 $123,292,535 $ 32,952 $ 195,007 $ 460,311 $ 0 $ 0 $ 2,223,845 $ 1,911,931 121,020 469,568 8,258 0 0 1,699,036 1,621,978 O 0 3,417,347 0 0 3,475,184 2,630,010 6,105 2,458 42,798 0 0 1,614,062 1,052,454 O 624,640 0 0 0 24,554,622 24,896,035 0 0 0 0 0 3,696,921 3,108,547 O 0 0 0 0 58,532 62,074 0 0 0 0 0 415,856 415,856 -- 0 0 0 0 0 15,509 27,334 0 0 3,404,756 0 1,288,645 4,693,401 2,728,511 O 0 1,490,536 0 0 1,490,536 1,383,236 160,077 1,291,673 8,824,006 0 1,288,645 43,937,504 39,837,966 O 0 0 29,413,234 0 29,413,234 28,998,355 146,373 8,583,891 0 0 0 8,730,264 8,684,552 834,898 3,082,288 0 0 0 3,917,186 3,150,045 0 0 0 0 0 0 1,174,003 0 0 29,636,684 0 0 36,744,950 30,563,152 0 0 0 0 0 1,445,759 3,565,146 0 0 3,683,094 0 0 7,915,814 7,319,316 981,271 11,666,179 33,319,778 0 0 58,753,973 54,456,214 $ 1,141,348 $ 12,957,852 $ 42,143,784 $ 29,413,234 $ 1,288,645 $132,104,711 $123,292,535 (31) COUNTY OF WELD STATE OF COLORADO COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES ALL GOVERNMENTAL FUND TYPES AND EXPENDABLE TRUST FUNDS For The Year Ended December 31, 1992 With Comparative Amounts for 1991 Governmental Fund Types Special Capital General Revenue Projects REVENUES: Taxes $ 14,420,135 $ 9,592,556 $ 949,332 Licenses and permits 551,402 289,454 0 Intergovernmental 2,972,187 37,213,496 0 Fines and forfeitures 34,275 0 0 Miscellaneous 2,437,968 633,690 67,476 Fees 2,490,909 0 0 Charges for services 964,623 1,446,365 0 Total Revenues 23,871,499 49,175,561 1,016,808 EXPENDITURES: Current: General government 8,848,738 0 0 Public safety 11,321,924 0 0 Public works 662,913 11,286,599 0 Public health and welfare 279,479 28,677,534 0 Culture and recreation 102,365 209,105 0 Economic assistance 934,678 7,744,849 0 Miscellaneous 520,007 139,942 0 Capital outlay 121,059 173,821 2,138,636 Debt service 199,944 0 0 Intergovernmental 0 809,896 0 Total Expenditures 22,991,107 49,041,746 2,138,636 EXCESS OF REVENUES OVER (UNDER) EXPENDITURES 880,392 133,815 (1,121,828) OTHER FINANCING SOURCES (USES): Proceeds of long-term debt 0 0 1,978,946 Operating transfers - in 1,498,665 6,644,521 0 Operating transfers - out (2,351,147) (3,244,534) (2,073,502) Total Other Financing Sources (Uses) (852,482) 3,399,987 (94,556) EXCESS OF REVENUE AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES 27,910 3,533,802 (1,216,384) FUND BALANCES AT BEGINNING OF YEAR 1,487,068 6,876,031 2,058,218 Residual Equity Transfer 20,100 0 0 FUND BALANCES AT END OF YEAR $ 1,535,078 $ 10,409,833 $ 841,834 (See Notes to Financial Statements) (32) Fiduciary Fund Types Memorandum Totals Expendable Total Total Trust 1992 1991 $ 8 $ 24,962,031 $ 23,867,746 O 840,856 647,634 O 40,185,683 37,805,169 O 34,275 56,652 304,430 3,443,564 4,121,565 0 2,490,909 2,473,394 0 2,410,988 1,975,095 304,438 74,368,306 70,947,255 O 8,648,738 8,780,727 O 11,321,924 10,804,861 O 11,949,512 11,412,048 33,379 28,990,392 26,818,985 O 311,470 261,071 O 8,679,527 7,500,399 645,060 1,305,009 1,129,079 0 2,433,516 2,164,396 0 199,944 461,193 O 809,896 810,111 678,439 74,849,928 70,142,870 (374,001) (481,622) 804,385 0 1,978,946 0 O 8,143,186 2,694,829 O (7,669,183) (3,154,829) O 2,452,949 (460,000) (374,001) 1,971,327 344,385 1,041,766 11,463,083 11,197,226 0 20,100 (78,528) $ 667,765 $ 13,454,510 $ 11,463,083 (33) COUNTY OF WELD STATE OF COLORADO COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL - ALL GOVERNMENTAL FUND TYPES For The Year Ended December 31, 1992 General Special Revenue Variance Variance Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) REVENUES: Taxes $ 14,301,445 $ 14,420,135 $ 118,690 $ 9,499,898 $ 9,592,556 $ 92,658 Licenses and permits 545,675 551,402 5,727 268,500 289,454 20,954 Intergovernmental 2,732,751 2,972,187 239,436 29,522,763 37,213,496 7,690,733 Fines and forfeitures 122,000 34,275 (87,725) 0 0 0 Miscellaneous 2,452,915 2,437,968 (14,947) 694,947 633,690 (61,257) Fees 2,375,229 2,490,909 115,680 0 0 0 Charges for services 950,481 964,623 14,142 1,778,093 1,446,365 (331,728) Total Revenues 23,480,496 23,871,499 391,003 41,764,201 49,175,561 7,411,360 EXPENDITURES: Current: General government 9,133,555 8,848,738 284,817 0 0 0 Public safety 11,402,907 11,321,924 80,983 0 0 0 Public works 721,354 662,913 58,441 12,664,978 11,286,599 1,378,379 Public health and welfare 287,996 279,479 8,517 29,737,588 28,677,534 1,060,054 Culture and recreation 48,959 102,365 (53,406) 246,048 209,105 36,943 Economic assistance 977,254 934,678 42,576 7,794,595 7,744,849 49,746 Miscellaneous 586,101 520,007 66,094 350,000 139,942 210,058 Capital outlay 248,268 121,059 127,209 578,428 173,821 404,607 Debt service 91,015 199,944 (108,929) 0 0 0 Intergovernmental 0 0 0 818,172 809,896 8,276 Total Expenditures 23,497,409 22,991,107 506,302 52,189,809 49,041,746 3,148,063 EXCESS OF REVENUES OVER (UNDER) EXPENDITURES (16,913) 880,392 897,305 (10,425,608) 133,815 10,559,423 OTHER FINANCING SOURCES (USES): Proceeds of long-term debt 0 0 0 0 0 0 Operating transfers - in 1,539,916 1,498,665 (41,251) 1,107,092 6,644,521 5,537,429 Operating transfers - out (2,351,147) (2,351,147) 0 (3,259,037) (3,244,534) 14,503 Total Other Financing Sources (Uses) (811,231) (852,482) (41,251) (2,151,945) 3,399,987 5,551,932 EXCESS OF REVENUE AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES (828,144) 27,910 856,054 (12,577,553) 3,533,802 16,111,355 FUND BALANCES AT BEGINNING OF YEAR 1,487,068 1,487,068 0 6,876,031 6,876,031 0 Residual Equity Transfer 0 20,100 20,100 0 0 0 FUND BALANCES AT END OF YEAR $ 658,924 $ 1,535,078 $ 876,154 $ (5,701,522) $ 10,409,833 $ 16,111,355 (See Notes to Financial Statements) (34) Capital Projects Memorandum Totals Variance Variance Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) $ 943,000 $ 949,332 $ 6,332 $ 24,744,343 $ 24,962,023 $ 217,680 O 0 0 814,175 840,856 26,681 O 0 0 32,255,514 40,185,683 7,930,169 O 0 0 122,000 34,275 (87,725) 40,000 67,476 27,476 3,187,862 3,139,134 (48,728) O 0 0 2,375,229 2,490,909 115,680 0 0 0 2,728,574 2,410,988 (317,586) 983,000 1,016,808 33,808 66,227,697 74,063,868 7,836,171 O 0 0 9,133,555 8,848,738 284,817 O 0 0 11,402,907 11,321,924 80,983 O 0 0 13,386,332 11,949,512 1,436,820 O 0 0 30,025,584 28,957,013 1,068,571 O 0 0 295,007 311,470 (16,463) O 0 0 8,771,849 8,679,527 92,322 O 0 0 936,101 659,949 276,152 2,741,381 2,138,636 602,745 3,568,077 2,433,516 1,134,561 O 0 0 91,015 199,944 (108,929) O 0 0 818,172 809,896 8,276 2,741,381 2,138,636 602,745 78,428,599 74,171,489 4,257,110 1,758,381 (1,121,828) 636,553 (12,200,902) (107,621) 12,093,281 2,000,000 1,978,946 (21,054) 2,000,000 1,978,946 (21,054) 0 0 0 2,647,008 8,143,186 5,496,178 (2,073,502) (2,073,502) 0 (7,683,686) (7,669,183) 14,503 (73,502) (94,556) (21,054) (3,036,678) 2,452,949 5,489,627 (1,831,883) (1,216,384) 615,499 (15,237,580) 2,345,328 17,582,908 2,058,218 2,058,218 0 10,421,317 10,421,317 0 O 0 0 0 20,100 20,100 - $ 226,335 $ 841,834 $ 615,499 $ (4,816,263) $ 12,786,745 $ 17,603,008 (35) COUNTY OF WELD STATE OF COLORADO COMBINED STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS/ FUND BALANCES, ALL PROPRIETARY FUND TYPES, PENSION TRUST AND NONEXPENDABLE TRUST FUNDS For The Year Ended December 31, 1992 With Comparative Amounts for 1991 Proprietary Fiduciary Fund Type Fund Type Memorandum Totals Enterprise Internal Pension Nonexpendable Total Total Fund Service Trust Trust Fund 1992 1991 OPERATING REVENUES: Earnings on investments $ 0 $ 0 $ 2,081,605 $ 0 $ 2,081,605 $ 1,313,859 Contributions 0 126,947 2,367,690 0 2,494,637 2,198,219 Charges for services 2,080,426 6,350,936 0 236,012 8,667,374 8,777,284 Total Operating Revenues 2,080,426 6,477,883 4,449,295 236,012 13,243,616 12,289,362 OPERATING EXPENSES: Personnel services 914,040 1,580,410 0 0 2,494,450 2,373,401 Contractual services 78,947 2,408,389 0 24,374 2,511,710 2,532,836 Supplies 76,238 641,851 0 0 718,089 701,213 Repair and maintenance 48,894 444,134 0 0 493,028 440,612 Insurance and bonds 0 301,202 0 0 301,202 340,579 Claims 0 520,051 0 0 520,051 356,233 Benefit payments 0 0 1,263,671 0 1,263,671 1,108,835 Refunds 0 0 373,280 0 373,280 290,815 Other 840,329 204,160 0 0 1,044,489 1,136,363 Depreciation 97,035 1,652,108 0 90,000 1,839,143 1,836,935 Administrative 0 0 195,374 0 195,374 190,231 Total Operating Expenses 2,055,483 7,752,305 1,832,325 114,374 11,754,487 11,308,053 OPERATING INCOME (LOSS) 24,943 (1,274,422) 2,616,970 121,638 1,489,129 981,309 NONOPERATING REVENUES (EXPENSES): Taxes 0 602,736 0 0 602,736 640,893 Intergovernmental 100,000 0 0 0 100,000 47,913 Miscellaneous 205,650 242,417 0 26,980 475,047 102,363 Fees 0 1,020 0 0 1,020 683 Farm income 0 0 0 0 0 653 Gain on sale of assets 0 149,196 0 0 149,196 277,819 Interest expense 0 (25,842) 0 (98,107) (123,949) (137,279) Judgements and damages 0 41,443 0 0 41,443 86,400 Total Non-Operating Revenues (Expenses) 305,650 1,010,970 0 (71,127) 1,245,493 1,019,445 INCOME (LOSS) BEFORE OPERATING TRANSFERS 330,593 (263,452) 2,616,970 50,511 2,734,622 2,000,754 OPERATING TRANSFERS: Operating transfers - in 100,000 600,000 0 0 700,000 460,000 Operating transfers - out (156,609) (1,017,394) 0 0 (1,174,003) 0 Total Operating Transfers (56,609) (417,394) 0 0 (474,003) 460,000 NET INCOME (LOSS) 273,984 (680,846) 2,616,970 50,511 2,260,619 2,460,754 RETAINED EARNINGS/FUND BAT4NCES AT BEGINNING OF YEAR 560,914 3,763,134 29,768,094 216,438 34,308,580 32,107,060 Residual Equity Transfer 0 0 0 0 0 (259,235) RETAINED EARNINGS/FUND 'AiANCES AT END OF YEAR $ 834,898 $ 3,082,288 $ 32,385,064 $ 266,949 $ 36,569,199 $ 34,308,579 (See Notes to Financial Statements) (36) COUNTY OF WELD STATE OF COLORADO COMBINED STATEMENT OF CASH FLOWS ALL PROPRIETARY FUND TYPES AND NONEXPENDABLE TRUST FUND For the Year Ended December 31, 1992 Proprietary Fund Type Nonexpendable Memorandum Enterprise Internal Trust Total Fund Service Fund 1992 CASH FLOWS FROM OPERATING ACTIVITIES: Operating income (loss) $ 24,943 $ (1,274,422) $ 121,638 $ (1,127,841) Adjustments to reconcile operating income (loss) to net cash provided by operating activities, Depreciation 97,035 1,652,158 90,000 1,839,193 Change in assets and liabilities: (Increase) decrease in accounts receivable 39,704 27,976 (1,300) 66,380 (Increase) decrease in inventory 0 (14,401) 0 (14,401) (Increase) decrease in other assets (101,370) (85,853) 0 (187,223) Increase (decrease) in accounts payable 21,126 (151,109) 5,080 (124,903) Increase (decrease) in accrued Liabilities 39,814 523 8,258 48,595 Increase (decrease) in other liabilities 0 (286,143) 0 (286,143) Total adjustments 96,309 1,143,151 102,038 1,341,498 Net cash provided by (used for) operating activities: 121,252 (131,271) 223,676 213,657 CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES: Interest paid on borrowings 0 (25,842) (117,963) (143,805) Principal paid on long-term debt 0 0 (160,000) (160,000) Property tax collections 0 602,736 0 602,736 Refunds 0 192,894 0 192,894 Grants and donations 291,878 60,391 0 352,269 Proceeds from issuance of long-term debt 0 0 2,240,000 2,240,000 Operating transfers-net (56,609) (417,394) 0 (474,003) Net cash provided by noncapital financing activities 235,269 412,785 1,962,037 2,610,091 CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES: Proceeds from sale of capital assets 3,449 153,259 0 156,708 Acquisition of capital assets (775,850) (1,696,219) (1,978,946) (4,451,015) Net cash used for capital and related financing activities (772,401) (1,542,960) (1,978,946) (4,294,307) CASH FLOWS FROM INVESTING ACTIVITIES: Interest on investments 13,772 49,523 26,980 90,275 NET INCREASE (DECREASE) IN CASH AND CASH EQUIVALENTS (402,108) (1,211,923) 233,747 (1,380,284) CASH AND CASH EQUIVALENTS AT BEGINNING OF YEAR 414,225 2,754,290 228,690 3,397,205 CASH AND CASH EQUIVALENTS AT END OF YEAR $ 12,117 $ 1,542,367 $ 462,437 $ 2,016,921 Noncash investing, capital, and financing activities: The Enterprise Fund received property of $65,812 from the General Fixed Assets Account Group. (Sea Notes to Financial Statements) (37) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 Note 1 - Summary of Significant Accounting Policies: The County of Weld, Colorado ("County") was established in 1861, and on January 1, 1976 became a home rule county under the provisions of Section 30-35-501, CRS, 1973. The County operates under an elected commissioner form of government. The County provides the full range of 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. The financial statements of the County have been prepared in conformity with generally accepted accounting principles (GAAP) as applied to governmental units. The following summary of significant accounting policies is presented to assist the reader in evaluating the County's financial statements. A. Reporting Entity: The financial statements of the County include those of separately administered organizations that are controlled by or dependent on the County. Control or dependence is determined on the basis of budget adoption, taxing authority, funding, scope of public service, ability to influence operations, designation of management, and appointment of the respective governing board. Based upon the foregoing criteria, the financial statements of the following organizations are included in the accompanying financial statements: Weld County Housing Authority -- The Board of County Commissioners appoints the five-member board. The majority of funding provided is from state and federal housing grants of which the County is the primary recipient and sponsor. The operation is reported in the Housing Authority Fund, a Special Revenue Fund. Weld County Public Health Board -- The Board of County Commissioners appoints the seven-member board and the Director of Public Health. Substantial funding is provided by the County for the operation of the Public Health Department. The Public Health Department's operations are reported in the Public Health Fund, a Special Revenue Fund. (38) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 Weld County Retirement Board -- The Retirement Board consists of five members, two selected by participating employees, two appointed by the Board of County Commissioners, and the fifth being the elected County Treasurer. The County funds half of the retirement plan, which covers substantially all permanent, full-time employees of Weld County. The operation of the plan is accounted for in the Weld County Retirement Fund, as a Pension Trust Fund. Weld County Finance Corporation -- The Weld County Finance 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 lease to the County and others. The Board of County Commissioners appoints the three-member Board of Directors of the Corporation, and approves all projects undertaken by the Corporation. The members of the Board of Directors are employees of the County. The operations of the Corporation are reported as a Nonexpendable Trust Fund. Weld County E-911 Board -- The Board of County Commissioners appoints four members of the seven member board. Funds are generated through surcharges on telephone bills and are reported in the Emergency Service Agency Fund. Crime Victim Compensation Board -- The Weld County District Attorney appoints the three member crime victim compensation board. Funds are generated by fines to defendants in Federal, County, and District courts. The board reviews and approves all requests for assistance to qualified victims of crime. The District Attorney's office is reported in the financial statements in the General Fund. Contraband seized by the Weld County Sheriffs' office is sold and funds are deposited to the general fund and utilized by sheriffs' office using the normal expenditure process. The following organizations are not part of Weld County and are excluded from the accompanying financial statements: (39) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 North Colorado Medical Center -- The Board of County Commissioners appoints a seven-member Hospital Board of Trustees. The Hospital Board of Trustees leases land only to Normedco. Normedco is a holding company of which the North Colorado Medical Center (NCMC) is a non-profit subsidiary operating the hospital. Effective in 1991 the Hospital Board of Trustees no longer appoints any members to the Normedco Board of Directors. The NCMC has the ability to incur its own debt and its operations are financed totally by patient revenues. Greeley-Weld Airport Authority -- The County Commissioners appoint two of the five Airport Authority Board members. The County has contributed approximately 5% of the funds for capital construction. The Authority has full autonomy under Colorado State law, can incur debt, and funds its operations totally from user fees. Weld Library District -- The County Commissioners, together with the concurrence of the city councils of seven participating municipalities, appoint the seven-member Library District Board. The Library District Board has total autonomy under the State Library Act to incur debt, establish budgets, and levy property taxes to support the District's library system. B. Basis of Presentation: Each fund is an independent fiscal and accounting entity with a self-balancing set of accounts recording cash and other financial resources together with all related liabilities, residual equities and balances which are segregated for the purpose of carrying on specific activities or attaining certain objectives in accordance with special regulations, restrictions, or limitations. The various funds are grouped into six generic fund types under three broad fund categories, as follows: Governmental Fund Types: All governmental funds and expendable trust funds are accounted for using a current financial resources measurement focus. Under this measurement focus, only current assets and current liabilities are generally included in the balance sheets. (40) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 The reported fund balance (net current assets) is considered a measure of "available spendable resources". Governmental fund operating statements present increases (revenue and other financing sources) and decreases (expenditures and other financing uses) in net current assets. Accordingly, these funds are said to present a summary of sources and uses of "available spendable resources" during a period. General Fund: The General Fund accounts for all financial transactions of the County that are not properly accounted for in other funds. Ordinary operations of the County such as public safety, County administration and other activities financed from taxes and general revenue are reflected in this fund. Special Revenue Funds: Special Revenue Funds are established to account for taxes or other earmarked revenue of the County which finance specified activities as required by law or administrative action. Capital Projects Funds: Capital Projects Funds are established to account for financial resources used for the acquisition or improvement of the capital facilities of the County. Proprietary Fund Types: All proprietary funds are accounted for on a flow of economic resources measurement focus. This means that all assets and all liabilities (whether current or non-current) associated with the fund's activity are included on the balance sheet. Fund equity (net total assets) is segregated into contributed capital and retained earnings components. Proprietary fund type operating statements present increases (revenue) and decreases (expenses) in net total assets. Enterprise Fund: Enterprise Funds are used to account for operations where the intent of the County is that the costs or services to the general public on a continuing basis be financed or recovered primarily through user charges. (41) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 Internal Service Funds: Internal Service Funds are established to account for goods and services provided to other departments of the County on a cost-reimbursement basis. Fiduciary Fund Types (Trust and Agency Funds) : Trust and Agency Funds are established to record transactions relating to assets held by the County in the capacity of trustee, custodian or agent for individuals, governmental entities and non-public organizations. These include expendable trust, nonexpendable trust, pension trust and agency funds. Expendable trust funds are accounted for in essentially the same manner as governmental funds. Nonexpendable trust funds and pension trust funds are accounted for in essentially the same manner as proprietary funds. Agency funds are purely custodial (assets equal liabilities) and thus do not involve measurement of results of operations. In addition to the funds, self-balancing account groups are established to account for the general fixed assets and general long-term debt of the County, as follows: General Fixed Assets Account Group: Fixed assets used in governmental fund type operations are accounted for in the General Fixed Assets Account Group. General Long-Term Debt Account Group: The General Long-Term Debt Account Group is used to account for all long term indebtedness not accounted for in the proprietary fund types. C. Basis of Accounting: The governmental funds, expendable trust funds, and agency funds utilize the modified accrual basis of accounting. Under this method revenues are recognized when measurable and available. "Measurable" means the amount of the transaction can be determined and "available" means collectible within the current period or soon enough thereafter to pay liabilities of the current period. (42) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 Primary revenues susceptible to accrual are taxes, grant revenues and investment earnings. Property tax is reported as deferred revenue (less estimated uncollectible amounts) in the year the levy is certified and as a revenue when available to finance the County's current operations. Other taxes are also reported as revenue when available. Grant revenue is recognized as qualifying expenditures are incurred, and investment earnings are accrued over the life of the investment. Expenditures are generally recognized when the related fund liability is incurred except for long-term liabilities, such as accrued vacation and sick leave, which are recorded when payable from current available financial resources. Proprietary funds and pension trust funds follow the accrual basis of accounting whereby revenue is recognized when earned and expenses are recorded when liabilities are incurred. Encumbrances: Weld County utilizes the encumbrance method of recording commitments related to unperformed contracts for goods and services or portions thereof not yet received. Under this method, encumbrances for purchase orders, contracts, and other commitments outstanding at year end are recorded as a reservation of fund balance and do not constitute expenditures or liabilities. Because the commitments will be honored during the subsequent year a reappropriation is made in the subsequent year to provide authority to complete the transaction. Budget: An annual budget and appropriation ordinance is adopted by the Board of County Commissioners in accordance with the Colorado State Budget Act and Weld County Home Rule Charter. The budget is prepared on a basis consistent with generally accepted accounting principles. Budgets are established for all Governmental, Internal Service fund types, and the Enterprise Fund. The accounting system is employed as a budgetary management control device during the year to monitor the individual departments. The fund level is the level of classification at which expenditures may not legally exceed appropriations, except for the General Fund where the department level of expenditures cannot legally exceed appropriations. During the year, several supplemental appropriations were necessary. All annual appropriations lapse at year end. (43) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 The Director of Finance and Administration is authorized to transfer budgeted amounts within departments of each fund. Any revisions that alter the total appropriation for a fund or for any General Fund department must be approved by the County Commissioners through a supplemental appropriation ordinance. During 1992, three supplemental appropriation ordinances were enacted, which brought the total budget from the original appropriation of $68, 140,662 to $70,294,955. Budget amounts reported in the accompanying financial statements reflect these supplemental appropriations. Property Taxes: Property taxes attach as an enforceable lien on property as of January 1. Taxes were levied on December 11, 1991 and are collected in 1992 in either two installments or one full payment as follows: The first billing is mailed January 15 and is due by February 28, (half installment) or a full payment by April 30. The second billing is mailed May 15, and is due by June 15, (second installment) . The bill becomes delinquent on March 1, May 1, and June 16 and penalties and interest may be assessed by the County. The County, through the Weld County Treasurer, bills and collects its own property taxes as well as property taxes for all school districts, cities and towns and special districts located within the County. In accordance with Section 14-7 of the Weld County Home Rule Charter, all ad valorem tax levies for County purposes, when applied to the total valuation for assessment of the County, shall be reduced so as to prohibit the levying of a greater amount of tax revenue than was levied from ad valorem taxation in the preceding year plus five per cent (5%) , except to provide for the payment of bonds and interest. The Board of County Commissioners may submit the question of an increased levy to the County Council and, if in the opinion of a majority of the County Council the County is in need of additional funds, the Council may grant an increased levy for the County in such amount as it deems appropriate, and the County is authorized to make such increased levy. (44) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 Any one capital project requiring a capital expenditure out of funds procured by ad valorem taxation equal to a three mill levy for three years, shall be prohibited unless approved by a majority vote of the qualified electors at a general or special election per Section 14-8 of the Weld County Home Rule Charter. The original January 1, 1992 levies for the applicable funds of the County are as follows: Mills Amount General Fund 13.593 $ 14,342,660 Road and Bridge Fund 3.615 3,814,516 Social Services Fund 2.971 3, 135,382 Contingent Fund .883 932,000 Capital Expenditures Fund .835 881,300 Insurance Fund .560 591, 165 TOTAL 22.457 $ 23, 697,023 Investments: Investments are stated at cost or amortized cost subject to adjustment for market declines judged to be other than temporary, except investments of the Deferred Compensation Fund which are stated at market value. For purposes of the statement of cash flows, the County considers all highly liquid investments with a maturity of three months or less to be cash equivalents. Inventories: Inventories of governmental funds, which consist of expendable materials held for consumption, are stated at cost utilizing the weighted average cost method. These funds follow the consumption method of accounting whereby expenditures are recorded at the time the inventory items are used. Inventories of proprietary funds are recorded at the lower of average cost or market. Short-term Interfund Receivables/Payables: Interfund transactions resulting from reimbursements, operating transfers, and charges for services rendered, are recorded as due to or due from other County funds. (45) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 Advance to Other Funds: Noncurrent portions of long-term interfund loans receivable (reported in "Advance" asset accounts) are equally offset by a fund balance reserve account which indicates that they do not constitute "available spendable resources" since they are not a component of net current assets. Interfund Transactions: Quasi-external transactions are accounted for as revenues, expenditures or expenses. Transactions that constitute reimbursements to a fund for expenditures/expenses initially made from it that are properly applicable to another fund, are recorded as expenditures/expenses in the reimbursing fund and as reductions of expenditures/expenses in the fund that is reimbursed. All other interfund transactions, except quasi-external transactions and reimbursements, are reported as transfers. Nonrecurring or nonroutine permanent transfers of equity are reported as residual equity transfers. All other interfund transfers are reported as operating transfers. Fixed Assets: Acquisitions of general fixed assets are recorded as capital outlay expenditures within the governmental funds. Public domain ("infrastructure") general fixed assets consisting of roads, bridges and rights-of-way are not capitalized. No depreciation is provided on general fixed assets. All fixed assets are valued at historical cost or estimated historical cost if actual historical cost is not available. Donated fixed assets are valued at their estimated fair market value on the date donated. Depreciation of all exhaustible fixed assets used by Internal Service Funds, Enterprise Funds and the Nonexpendable Trust Fund is charged as an expense against the operations. Accumulated depreciation is reported on the related balance sheets. Depreciation is provided using the straight-line method over the estimated useful lives, as follows: Buildings 20-30 years Improvements Other Than Buildings 20 years Machinery and Equipment 3-10 years (46) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 Risk Management and Insurance: The County manages risks of loss through a combination of commercial insurance, participation in a public entity risk pool, and self-insurance. These activities are accounted for in the Insurance Fund, an internal service fund. The County provides dental and vision insurance benefits to employees, which are funded by employee contributions. These activities are accounted for in the Health Insurance Fund, an internal service fund. Estimated liabilities for claims incurred but not reported are included in accrued liabilities. Sick leave and Vacation Pay: Accrued vacation and sick leave for the governmental funds are accounted for in the General Long-Term Debt Account Group. Sick-leave is earned when vested, and it is recorded as an expenditure in the applicable fund when paid. In the event of retirement or termination, an employee whose date of hire is prior to January 1, 1985 is paid for 50% of accumulated sick- leave hours up to the equivalent of one month. At December 31, 1992, the liability for accumulated sick-leave approximated $502,460. Unused vacation time is forfeited after 24 months from date earned. Upon termination or retirement, employees are paid for their accrued vacation. At December 31, 1992, the liability for accumulated vacation approximated $586, 185. Vacation is recorded as an expenditure in the applicable governmental-type fund when paid. Vacation and sick-leave are accrued in the proprietary fund types when earned. Long-term Obligations: Long-term debt is recognized as a liability of a governmental fund when due. For other long-term obligations, only that portion expected to be financed from expendable available financial resources is reported as a fund liability of a governmental fund. The remaining portion of such obligations is reported in the general long-term debt account group. Long-term liabilities expected to be financed from proprietary fund operations are accounted for in those funds. (47) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 Fund Equity: Contributed capital is recorded in proprietary funds that have received capital grants or contributions from developers, customers or other funds. Reserves represent those portions of fund equity not appropriable for expenditure or legally segregated for a specific future use. Designated fund balances represent tentative plans for future use of financial resources. Reserves for the County of Weld are recorded at the maximum equity available in fund balance and consist of: Reserve for Encumbrances: These reserves are established to record purchase orders and commitments outstanding for which the related goods/services have not been received at year end. The reserves recorded at December 31, 1992 include $133,816, $521,739 and $33,820 for the General Fund and Special Revenue Funds and Capital Projects Fund, respectively, for a total of $689,375. Reserve for Other Assets: These reserves are established to record all prepaid items. Recorded reserves at December 31, 1992 are $43,650 and $100, 766 for the General Fund and Special Revenue Funds, respectively, for a total of $144,416. Reserve for Inventories: These reserves are established to record the total level of inventories. The General Fund and Special Revenue Funds have respective amounts at December 31, 1992 of $37,517 and $570,206, respectively, for a total of $607, 723. Reserve for Employee Benefits: These reserves are established to record the pension benefit obligation of the Weld County Retirement Plan. The amount of this reserve is $29,636,684 at December 31, 1992. Reserve for Advances: These reserves are established to record a temporary loan of cash flow. The amounts recorded in the General Fund and Special Revenue Funds at December 31, 1992 are $200,000 and $75,000, respectively, for a total of $275,000. (48) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 Reserve for Emergencies: This reserve was established as the "emergency reserve" required by "Amendment One" to the Colorado constitution. Reserve for Claims: Reserves have been recorded for investments in which the Securities and Exchange Commission froze all assets in 1991 pending outcome of criminal investigations of the securities dealers and which the County is in litigation to recover. Reserves recorded represent total potential loss to the County. The amounts are $4,591,752 in the Contingent Fund. Designated Fund Balance: Fund balance designated for subsequent years' expenditures represents fund balance commitments for appropriated expenditures in excess of anticipated revenue for the year ended December 31, 1993. Non-federal In-kind Contributions: Volunteers assist the various programs of the Human Resources Fund (a Special Revenue Fund) in providing transportation and various other program functions. The volunteer labor is recognized as a contributed revenue at $4.00 per hour. Certain volunteer labor is recorded at higher rates based upon the individual's professional experience. Volunteer mileage is recorded at 204 per mile. Donated food, clothing, and other goods are recognized as contributed revenue at fair market value. An offsetting in-kind expenditure is also recorded for the value of the donated goods and services. Memorandum Only - Total Columns: Total columns on the General Purpose Financial Statements are captioned Memorandum Total to indicate that they are presented only to facilitate financial analysis. Data in these columns do not present financial position, results of operations, or cash flows in conformity with generally accepted accounting principles. Neither is such data comparable to a consolidation. Interfund eliminations have not been made in the aggregation of this data. Comparative Data: Comparative total data for the prior year have been presented in the accompanying financial statements in order to provide an understanding of changes in the County's financial position and operations. However, comparative data have not been presented in all statements because their inclusion would make certain statements unduly complex and difficult to understand. (49) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 Note 2 - Equity in Pooled Cash and Investments: The County maintains a cash and investment pool that is available for use by all funds. Each fund's share is displayed on the balance sheets as "Cash and short-term investments". Several of the County's funds also hold investments on their own account. Substantially all cash and investments of the Pension Trust Fund are held separately from those of the other County funds. Cash and Short-Term Investments: Cash and short-term investments consists of the following at December 31, 1992: Deposits with Financial Institutions $ 7, 619, 754 Short-term investments 12,934, 134 Food Stamps 2,093,279 Other 336,407 Total $22,983,574 At year end the County's carrying amount of bank deposits in financial institutions was $7,619, 754 and the bank balance was $9,410,431. Of the bank balance, $910,257 was covered by Federal deposit insurance and the remainder was collateralized with securities held by the pledging financial institutions' trust departments or agents in the County's name under the Public Deposit Protection Act. Throughout 1992, the County had short-term investments in local government investment pools established by State statute. These pools operate similarly to a money market fund and each share is equal in value to $1.00. At December 31, 1992, the County had $1,247,597 invested in COLOTRUST, $4,099, 160 in CSAFE, $991,857 in Colorado Statewide Asset Trust, $1,099,077 in Colorado Diversified Trust, and $836,828 with Norwest Investment Services, Inc. At December 31, 1992, the County had $4,591, 752 plus $67,863 interest invested in a government securities fund, initially as a short-term investment. As discussed in Note 1, this fund was frozen in 1991 by the Securities and Exchange Commission pending outcome of criminal investigations of the securities dealers and the County has initiated litigation to recover damages. The market value of this investment is not available. There is a reasonable possibility that an investment loss may ultimately be realized. An estimate of the loss or range of loss cannot be made due to the preliminary status of the litigation. (50) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 Investments: Statutes authorize the County to invest in obligations of the U.S. Treasury, agencies, and instrumentalities, commercial paper, repurchase agreements, money market funds, and local government investment pools. The Pension Trust Fund is also authorized to invest in common stock, corporate bonds and mortgages. The County's investments are categorized to give an indication of the level of risk assumed at year-end. Category 1 includes the investments that are insured or registered or for which the securities are held by the County or its agent in the County's name. Category 2 includes uninsured and unregistered investments for which the securities are held by the counter party's agent in the County's name. Category 3 includes uninsured and unregistered investments, with securities held by a counterparty and not in the County's name. At December 31, 1992, all of the County's categorized investments were held in the Pension Trust Fund. Investments of the Pension Trust Fund were as follows: Category Category Category Carrying Market 1 2 3 Amount Value Corporate Bonds $13,014,852 $13,014,852 $13,715,933 Money Market Fund $3,012,048 3,012,048 3,012,048 U.S. Treasury Obligations 3,372,834 3,372,834 3,713,169 Common Stock 12,543,774 12,543,774 18,072,219 Total $28,931,460 $3,012,048 $ -0- $31,943,508 $38,513,369 Investments of the Deferred Compensation Fund at December 31, 1992 totaled $1,490,536 at market value. Investments of this fund consist of mutual funds which are not subject to risk categorization because they are not evidenced by securities in physical form. Note 3 - Allowance for Uncollectible Accounts Receivable: The allowance for uncollectible receivables consists of the following at December 31, 1992: Allowance for Fund Type Uncollectibles General $ 243,489 Special Revenue 134, 737 Capital Projects 3,007 Enterprise 666,912 Internal Service 10,501 Trust and Agency 0 TOTAL $ 1,058,646 (51) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 Note 4 - Individual Fund Interfund Receivable and Payable Balances and Advances: Interfund receivable and payable balances at December 31, 1992 are as follows: Interfund Interfund Receivables Payables General Fund $ 84, 138 $1, 192,311 Special Revenue Funds: Road and Bridge Fund 1,094,333 261,562 Social Services Fund 20,047 66,276 Conservation Trust Fund -0- -0- Public Health Fund 140 11, 121 Human Resources Fund 44,913 30, 176 Solid Waste Fund -0- 234 Housing Authority Fund 1,000 1, 021 Capital Projects Fund -0- -0- Enterprise Fund: Ambulance 7,440 6, 105 Internal Service Funds: Motor Vehicle Fund 294,359 507 Health Insurance Fund -0- -0- Printing and Supply Fund -0- 54 Computer Services Fund 136 1,891 Insurance Fund 7, 170 -0- PBX Fund 41,099 6 Trust and Agency Funds: Employee Flexible Spending -0- 33,379 Payroll Agency Fund 9,828 91 Emergency Telephone Service 9,328 9,328 Pension Trust 131 -0- TOTAL $1, 614,062 $1,614,062 (52) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 Advances from and to other funds at December 31, 1992 are as follows: Advance Advance From To General Fund $ 75,000 $ 200,000 Special Revenue Funds - Solid Waste Fund -0- 75,000 Capital Projects Fund 340,856 -0- Nonexpendable Trust -0- 140,856 Total $ 415 856 $ 415,856 Note 5 - General Fixed Assets: A summary of changes in general fixed assets follows: Balance Balance 1/1/92 Additions Deletions 12/31/92 Land $ 3,088,834 $ 0 $ 48,496 $ 3,040,338 Improvements other than buildings 393,290 16,864 -0- 410,154 Buildings 20,285,481 197,778 -0- 20,483,259 Machinery and equipment 4,451,851 1,183,184 317,142 5,317,893 Construction-in- Progress 778,899 141,215 758,524 161,590 Total $28,998,355 $1,539,041 $1,124,162 $29,413,234 At year-end 1992 construction in progress consists of Library's mainframe computer which is estimated to cost $180,000 and be complete in 1993. (53) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1993 Note 6 - Long-Term Debt: Long-term debt consists of the following at December 31, 1992: Nonexpendable Trust Fund: Certificates of participation $3, 455,000 Less unaccreted discount 50,244 Certificates of participation - net 3, 404, 756 General Long-Term Debt Account Group: Special assessment bonds payable 200,000 Sick-leave and vacation accruals 1,088,645 Total 1,288,645 MEMORANDUM TOTAL $4,693,401 Certificates of participation represent debt of the Weld County Finance Corporation and are not general obligations of the County. The certificates were issued in 1988 and 1992 to finance the construction of buildings leased to the County and other local governmental units. The lease payments are sufficient to cover the indebtedness of the Finance Corporation, and include a purchase option at the end of the lease. The certificates bear interest at rates ranging from 4.25% to 7.3% per annum and mature during 1993 to 2002. Of the certificates issued in 1992, those maturing in 2001 or after are callable for redemption prior to maturity in whole or in part at the option of the County in 2000. Special assessment bonds payable were issued to finance road construction and are to be repaid from special assessments of property owners. The bonds bear interest at rates ranging from 10.25% to 10.5% per annum and mature in annual installments of $100,000 during 1993 and 1994. The County pays bond principal and interest installments one year in advance of reimbursement of such amounts by property owners. These bonds are not general obligations of the County. Future debt service requirements for the certificates of participation and special assessment bonds payable are detailed as follows: (54) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 Principal Requirement Interest Requirement Certificates Certificates Total Annual of Par- Special Total of Par- Special Total Debt Service Year ticipation Assessment Principal ticipation Assessment Interest Requirement 1993 $ 300,000 $ 100,000 $ 400,000 $ 243,449 $ 15,625 $ 259,074 $ 659,074 1994 345,000 100,000 445,000 203,930 5,250 209,180 654,180 1995 365,000 365,000 182,930 182,930 547,930 1996 390,000 390,000 159,930 159,930 549,930 1997 410,000 410,000 134,895 134,895 544,895 1998 445,000 445,000 107,845 107,845 552,845 1999 220,000 220,000 77,820 77,820 297,820 2000 235,000 235,000 63,960 63,960 298,960 2001 250,000 250,000 48,920 48,920 298,920 2002 495,000 495,000 32,670 32,670 527,670 TOTAL $3,455,000 $ 200,000 $3,655,000 $1,256,349 $ 20,875 $1,277,224 $4,932,224 Long-term debt transactions during 1992 are summarized as follows: Certificates Special Capital Vacation of Assessment Lease & Sick Participation Bonds Obligation Leave Total Balance, January 1, 1992 $1,344,612 $ 300,000 $ 25,941 $1,057,958 $2,728,511 Retired in 1992 (160,000) (100,000) (25,941) (285,941) Discount accretion 6,632 6,632 Additions in 1992 2,240,000 30,687 2,270,687 Discount addition (26,488) (26,488) Balance, December 31, 1992 $3,404,756 $ 200,000 $ 0 $1,088,645 $4,693,401 Weld County has no general bonded indebtedness. In accordance with Section 30-35-201, CRS, 1973, the County's general bonded indebtedness is limited to 3% of the assessed valuation, or $31, 759,000 at December 31, 1992. (55) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 Note 7 - Other Required Individual Fund Disclosures: Excesses of expenditures over appropriations in individual funds are as follows: Revised Over- Appropriation Expenditures Expenditure Special Revenue Funds: Public Health $ 2, 125,554 $ 2, 137,923 $ 12,369 Human Resources 6,402,647 6,420, 714 18,067 Enterprise Fund: Ambulance 2,045,559 2,055,483 9,924 Internal Service Fund: Motor Vehicle 3,369,319 3,438, 740 69,421 Excesses of expenditures over appropriations in General Fund departments can be seen by unfavorable variances in the expenditures section of the Statement of Revenues, Expenditures and Changes in Fund Balance, Budget and Actual. Note 8 - Weld County Retirement Plan: The County maintains the Weld County Retirement Plan ("Plan") a single-employer, defined benefit pension plan which covers all full- time employees, except officers and employees of the Health Department. Plan description and provisions: All eligible full-time employees participate in the Weld County Retirement Plan. The payroll for employees covered by the plan for the year ended December 31, 1992 was $19,714,540; the County's total payroll was $23,260,542. Current membership is comprised of the following: Retirees and beneficiaries currently receiving benefits and terminated employees entitled to benefits but not yet receiving them 246 Current Employees: Vested 349 Nonvested 417 TOTAL 1,012 (56) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 Employees retiring under the normal retirement rule, at age 65 with at least five years of credited service or whose age plus years of credited service equals 80 or more, are entitled to monthly benefits of 2.25 percent of their average monthly compensation (during the 12 highest-paid consecutive calendar months of credited service within the last 120 months of credited service) times years of credited service. The maximum benefit paid is 75 percent of final compensation and the minimum is $25 a month per year of credited service. The Plan permits special early retirement with full benefits to employees age 62 with 8 years of credited service and regular early retirement with reduced benefits to employees age 55 with five years of credited service. Active employees who become disabled receive benefits beginning on the first of the month on or after age 65 or, if later, when payments stop under the County's Long-Term Disability Plan. Retirement benefits are based on the disabled employee's final average monthly compensation at the time of disability and credited service (including the period of disability) , payable for the disabled employee's life. Effective January 1, 1991, upon the death of an active employee, the spouse is entitled to two times the employee's accumulated contributions plus interest or a monthly benefit equal to 70 percent of the employees accrued benefit as of his or her date of death, commencing on the later of the first day of the month following the employees's death or the first day of the month coinciding with or following the employee's 55th birthday. (Monthly benefit was available prior to January 1, 1991) . If an employee terminates employment with the County and is not vested, (has five years or more of credited service) , the employee is entitled to a refund of all employee contributions plus 6 percent annual interest, compounded monthly. If the employee is vested, the employee has the option of receiving a refund of accumulated contributions plus interest or receive a monthly benefit commencing upon his or her normal retirement date. All employees participating in the Plan are required by the authority of the Board of Commissioners to contribute 6 percent of their annual salaries to the Plan. The County is required to contribute a matching amount to fund the Weld County Retirement Plan, using the aggregate actuarial cost method. Earnings on investments are also used to fund the Plan. (57) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 Funding Status and Progress: The amount shown below as the "Pension Benefit Obligation " is a standardized disclosure measure of the present value of pension benefits, adjusted for the effects of projected salary increases, estimated to be payable in the future as a result of employee service to date. This measure is the actuarial present value of credited projected benefits and is intended to, (i) help users assess the Plan's funding status on a going-concern basis, (ii) assess progress being made in accumulating sufficient assets to pay benefits when due and (iii) allow for comparisons among public employee retirement plans. The measure is independent of the actuarial funding method used to determine contributions to the Plan. The pension benefit obligation was determined as part of an actuarial valuation of the plan as of January 1, 1992. Significant actuarial assumptions used in determining the pension benefit obligation include: (a) a rate of return on the investments of present and future assets of 7.5 percent per year compounded annually, (b) projected salary increases at various rates depending on attained age ranging from 7.5% for age 25 to 5.0% for age 64. The projected salary increases are due to a 5% inflation rate and various rate for merit raises ranging from 2.5% at age 25, to 0.0% at age 64. No assumption is made regarding post retirement benefit increases as these are reviewed and approved by the Weld County Retirement Board based on availability. Pension Benefit Obligation At January 1, 1992: Retirees and beneficiaries Currently receiving benefits $11,555, 005 Terminated vested employees not yet receiving benefits 528,999 Current Employees: Accumulated employee contributions, including allocated investment income 7,365,639 Employer-financed vested 3,992, 780 Employer-financed nonvested 6, 194,261 Total pension benefit obligation 29,636,684 Net Assets Available for Benefits (at cost, market value of $35,628, 367) 29, 768,093 Net Assets in Excess of Pension Benefit Obligation $ 131,409 (58) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 As of January 1, 1992, the Plan experienced an increase of $281,830 in the pension benefit obligation, due to changes in plan provisions which increased benefits for retirees and beneficiaries 2.5%, and a decrease of $782,946 due to actuarial assumptions for the disability rates which changed from 1965 Railroad Board Select and Ultimate to 1983 Railroad Board. There was no change in contribution requirements An additional 95 employees joined the Retirement Plan effective January 1, 1992. These employees are Federally funded employees and previously were not eligible for the plan. Contributions Required and Contributions Made: The government's funding policy is to provide for periodic employer contributions at actuarially determined rates that, expressed as percentages of annual covered payroll, are designed to accumulate sufficient assets to pay benefits when due. The required contributions are determined using an aggregate cost actuarial method. The plan does not have an unfunded actuarial accrued liability for 1992. Significant actuarial assumptions used to compute contribution requirements were the same as those used to compute the standardized measure of the pension benefit obligation. Contributions made during 1992 for both the County and the participating employees were $1, 183,865 (6% of covered payroll) . Total covered payroll for year ended December 31, 1992 was $19,714,540. Trend Information: Trend information for the years ended December 31, 1990, 1991, and 1992, respectively, is as follows: Net assets in excess of the pension benefit obligation (as of the beginning of the year) were 117.2%, 109.7%, and 100.4%, respectively. The County's contributions to the Plan, made in accordance with actuarially determined requirements, were 6 percent of annual covered payroll, for each of the years ended December 31, 1990, 1991, and 1992. Assets in excess of the pension benefit obligation were 23.9%, 14.4% and .7% of covered payroll for the years ended December 31, 1990, 1991 and 1992, respectively. Ten-year trend information, giving an indication of the progress made in accumulating sufficient assets to pay benefits when due, may be found in the statistical section of this report. (59) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 Note 9 - Deferred Compensation: Effective January 1, 1984, as allowed by the provisions of Section 24-52-101, et. seq. , CRS, 1973, and by Section 457 of the Internal Revenue Code of 1954, as amended, the County established the Deferred Compensation Plan of the County of Weld. The Deferred Compensation Plan is a special voluntary benefit plan for public employees, in which a portion of the employee's salary can be deferred until future years. Up to 25% of the employee's gross income can be deferred, not to exceed $7,500 annually. Compensation deferred by a participant under the plan and earnings on deferred amounts must remain solely the property of the County until paid to the participant or the participant's beneficiary, subject only to the claims of the County's general creditors. The County holds these funds in custody for the participants and exercises no discretion over the investment of the funds. Investments are recorded at market value. Note 10 - Contingent Liabilities: The County is currently the defendant in several lawsuits. Based upon the opinion of legal counsel, these claims would be covered by insurance and/or there does not appear to be a threat of significant liability to the County. Effective July 1, 1986, the County joined Colorado Counties, Incorporated's Casualty and Property Pool which covers all casualty and property claims with a $125,000 self-insurance retention. Worker's compensation remains self-insured with a $300, 000 per occurrence. Private insurers cover claims above the stop loss limit for all types of insurance. The County participates in a number of federal and state grant programs. Principal funding agencies include Department of Labor, Community Services Administration, Department of Health and Human Services, Department of Housing and Urban Development, Economic Development Agency, and Area Agency on Aging. These programs are subject to program compliance audits by the grantors or their representatives. The amount, if any, of expenditures which may be disallowed by the granting agencies cannot be determined at this time, although the County expects such amounts, if any, to be immaterial. (60) COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31, 1992 Note 11 - Public Trustee: Pursuant to an act of the Colorado General Assembly, the Weld County Public Trustee is to be deemed an agency of the County for the purpose of financial reporting. Related activity has been reported in the General Agency Fund, with the following activity identified strictly for the office of the Public Trustee. Balance Balance 1/1/92 Additions Deletions 12/31/92 Assets $ 44,403 $2,616, 125 $2, 614, 788 $ 45, 740 Liabilities 44,403 2,616, 125 2,614, 788 45, 740 Note 12 - Residual Equity Transfers: A reconciliation of residual equity transfers is as follows: Additions (Deletions) Residual To/from General Equity Fixed Assets Transfers or Cont. Year Ended December 31, 1992 In (Out) Capital General Fund $ 20, 100 $ 0 Ambulance Fund 0 57,352 Computer Services Fund 0 3,144 Motor Vehicle Fund 0 (14,784) General Fixed Assets 0 (16,812) TOTALS $ 20, 100 $ (20, 100) (61) yolk COLORADO (62) COMBINING STATEMENTS , INDIVIDUAL FUND AND ACCOUNT GROUP STATEMENTS , AND SCHEDULES ‘e ‘ ' WilDe. COLORADO GENERAL FUND . The General Fund accounts for all financial transactions of the County that are not properly accounted for in other funds. Ordinary operations of the County such as public safety, county administration and other activities financed from taxes and general revenues are reflected in this fund. In compliance with , GASB statement #6 Special Assessment Districts for Elmore Road, Road #5, Antelope Hills 1 and Indian Hills are reported in General Fund. WUDc. COLORADO COUNTY OF WELD STATE OF COLORADO GENERAL FUND BALANCE SHEET December 31, 1992 With Comparative Amounts as of December 31, 1991 1992 1991 ASSETS ASSETS: Cash and short-term investments $ 3,198,120 $ 2,260,263 Receivables (net of allowance for uncollectibles): Current property tax 14,719,449 14,246,012 Delinquent property tax 189,114 347,901 Accounts 113,478 370,131 Special assessment 379,014 481,242 Due from other County funds 84,138 390,185 Due from other governmental units 232,408 89,316 Advances to other funds 200,000 200,000 Inventories 37,517 37,517 Other assets 43,650 15,570 TOTAL ASSETS $ 19,196,888 $ 18,438,137 LIABILITIES AND FUND BATANCE LIABILITIES: Accounts payable $ 481,914 $ 472,093 Accrued liabilities 572,007 555,157 Due to other County funds 1,192,311 354,557 Deferred revenue 15,173,908 15,022,364 Unexpended grant revenue 166,670 471,898 Advance from other funds 75,000 75,000 Total Liabilities 17,661,810 16,951,069 FUND BALANCE: Reserve for encumbrances 133,816 123,591 Reserve for advances to other funds 200,000 200,000 Reserve for other assets 43,650 15,570 Reserve for claims 0 817,112 Reserve for inventories 37,517 37,517 Unreserved: Designated for future years' expenditures 175,000 238,958 Undesignated 945,095 54,320 Total Fund Balance 1,535,078 1,487,068 TOTAL LIABILITIES AND FUND 'ATANCE $ 19,196,888 $ 18,438,137 (63) COUNTY OF WELD STATE OF COLORADO GENERAL FUND Statement of Revenues, Expenditures and Changes in Fund Balance, Budget and Actual For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 Budget Actual Variance Actual REVENUES: TARES: General property tax $ 14,342,660 $ 14,259,354 $ (83,306) $ 13,498,842 Severance tax 28,400 28,486 86 35,419 Tobacco products 75,000 70,524 (4,476) 92,196 Penalties & interest 0 48,007 48,007 55,998 Payment in lieu of taxes 30,000 29,891 (109) 29,891 Property tax adjustment (174,615) (16,127) 158,488 0 Total Taxes 14,301,445 14,420,135 118,690 13,712,346 LICENSES AND PERMITS Liquor licenses 5,000 4,206 (794) 3,475 Plow permits 500 508 8 339 Planning permits 171,175 176,094 4,919 95,087 Building permits 315,000 318,499 3,499 247,783 Electrical permits 54,000 52,095 (1,905) 58,209 Total Licenses and Permits 545,675 551,402 5,727 404,893 INTERGOVERNMENTAL: Federal grants 167,660 214,959 47,299 283,779 State grants 2,333,241 2,487,398 154,157 2,277,030 District Attorney 38,000 38,000 0 38,000 Veterans office 600 400 (200) 0 Other governmental units 0 50,475 50,475 56,629 Cities & towns 193,250 180,955 (12,295) 170,708 Total Intergovernmental 2,732,751 2,972,187 239,436 2,826,146 CHARGES FOR SERVICES: Plan checking fees 26,000 28,627 2,627 18,695 Books 17,500 20,679 3,179 13,748 Charges for service 799,511 798,798 (713) 823,030 Sale of supplies 11,470 13,190 1,720 7,767 City contracts 73,700 79,340 5,640 81,108 Parking 12,000 12,400 400 12,044 Refuse disposal 600 1,135 535 731 Weed spraying 9,700 10,454 754 11,616 Sale of assets 0 0 0 350 Total Charges for Services 950,481 964,623 14,142 969,089 FINES AND FORFEITURES: Victim witness surcharge 2.5E 25,600 0 (25,600) 0 Property forfeitures/evidence 70,400 12,393 (58,007) 31,899 Fines (drunk drivers) 26,000 21,882 (4,118) 24,753 Total Fines and Forfeitures 122,000 34,275 (87,725) 56,652 (64) COUNTY OF WELD STATE OF COLORADO GENERAL FUND Statement of Revenues, Expenditures and Changes in Fund Balance, Budget and Actual For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 Budget Actual Variance Actual -._ REVENUES (CONTINUED): MISCELLANEOUS: Miscellaneous revenue $ 23,100 $ 16,166 $ (6,934) $ 4,374 Interest 748,298 630,930 (117,368) 1,621,177 Rents from land 24,000 29,972 5,972 0 Rents from buildings 295,594 293,824 (1,770) 244,787 Royalties 220,000 192,854 (27,146) 307,972 Special assessments 901,392 995,854 94,462 929,575 Other 142,031 191,616 49,585 122,926 Contributions 0 4,616 4,616 4,228 In kind 94,500 77,793 (16,707) 88,281 Sale of assets 4,000 4,343 343 5,154 Compensation for loss 0 0 0 2,585 Total Miscellaneous 2,452,915 2,437,968 (14,947) 3,331,059 FEES: Federal shared revenue 4,300 467 (3,833) 0 Sheriff's fees 99,795 98,157 (1,638) 101,926 Inmate bond fee 40,800 36,911 (3,889) 12,721 Fee account 5,000 0 (5,000) 0 DUI fees 130,884 148,592 17,708 157,360 Bond application fee 0 0 0 10,500 _ Clerk 4 Recorder fees 1,325,000 1,427,019 102,019 1,266,370 Treasurer's fees 570,000 576,301 6,301 525,650 Advertising 45,000 45,739 739 50,273 Assessor's fees 124,000 127,499 3,499 335,311 Bad check fees 25,000 25,053 53 5,725 _. Investigation fees 5,450 5,171 (279) 7,558 Total Fees 2,375,229 2,490,909 115,680 2,473,394 TOTAL REVENUES 23,480,496 23,871,499 391,003 23,773,579 EXPENDITURES: GENERAL GOVERNMENT: Office of the Board 319,137 310,115 9,022 297,785 County Attorney 460,989 454,393 6,596 419,310 Public Trustee 4,000 3,331 669 2,591 Planning and zoning 256,549 244,689 11,860 262,957 Clerk to the Board 85,798 78,760 7,038 61,637 County Clerk 1,051,577 983,204 68,373 1,029,079 Elections and registration 471,689 494,395 (22,706) 212,708 County Treasurer 545,281 509,144 36,137 510,102 County Assessor 1,679,929 1,535,837 144,092 1,671,832 Maintenance of buildings/grounds 1,546,030 1,447,119 98,911 1,584,956 County Council 20,838 10,654 10,184 10,586 District Attorney 1,491,226 1,436,974 54,252 1,400,148 Juvenile Diversion Grant 150,996 142,375 8,621 114,204 Victim Assistance 104,001 309,372 (205,371) 342,385 Pao - Diversion 63,660 28,613 35,047 54,286 Financial administration 165,160 158,298 6,862 152,089 General accounting 407,523 397,331 10,192 379,591 Purchasing 134,921 130,285 4,636 112,734 Personnel 174,251 172,614 1,637 161,634 Missle site park 0 0 0 113 County Fair 0 1,235 (1,235) 0 Total General Government 9,133,555 8,848,738 284,817 8,780,727 (Continued on next page) (65) COUNTY OF WELD STATE OF COLORADO GENERAL FUND Statement of Revenues, Expenditures and Changes in Fund Balance, Budget and Actual For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 Budget Actual Variance Actual EXPENDITURES (CONTINUED): PUBLIC SAFETY: Maintenance of buildings/grounds $ 0 $ 0 $ 0 $ (88) Sheriff administration 1,287,305 1,218,092 68,313 1,555,844 Crime control and investigations 2,798,512 2,788,092 10,420 2,357,925 Posse/special deputies 2,000 4,209 (2,209) 0 Task force 212,552 214,237 (1,685) 136,626 Regional forensic laboratory 74,320 69,738 4,582 67,291 Communications services 1,047,189 1,040,771 6,418 975,117 Communication system development 2,000 0 2,000 0 E-911 administration 1,700 1,044 656 197 County Coroner 102,238 107,119 (4,881) 87,586 Correctional administration 3,247,501 3,277,382 (29,881) 3,097,905 Community correction 1,601,000 1,652,344 (51,344) 1,561,968 Delinquents & other institutions 211,910 188,318 23,592 186,511 Public service DUI 149,607 149,347 260 152,367 Building inspection 307,324 285,279 22,045 300,250 Office of emergency management 50,261 48,895 1,366 41,977 Waste water management 5,648 5,648 0 6,001 Animal control 83,236 78,219 5,017 80,666 Pest/weed control 218,604 192,290 26,314 196,718 Total Public Safety 11,402,907 11,321,924 80,983 10,804,861 PUBLIC WORKS: General engineering 392,288 389,763 2,525 385,209 Extension service 236,889 234,371 2,518 219,528 Veterans office 42,177 38,691 3,486 35,994 Airport 50,000 0 50,000 50,000 Missle site park 0 88 (88) 91 Total Public Works 721,354 662,913 58,441 690,822 PUBLIC HEALTH AND WELFARE: Mental health 128,931 120,414 8,517 110,612 Developmentally disabled 97,365 97,365 0 101,365 Seniors programs 11,700 11,700 0 10,500 Economic Development 50,000 50,000 0 0 Total Public Health and Welfare 287,996 279,479 8,517 222,477 CULTURE AND RECREATION: Missle site park 600 1,606 (1,006) 4,650 County fair 48,359 100,759 (52,400) 119,695 Total Culture and Recreation 48,959 102,365 (53,406) 124,345 (66) COUNTY OF WELD STATE OF COLORADO GENERAL FUND Statement of Revenues, Expenditures and Changes in Fund Balance, Budget and Actual For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 Budget Actual Variance Actual EXPENDITURES (CONTINUED): ECONOMIC ASSISTANCE: Community development $ 977,254 $ 934,678 $ 42,576 $ 246,928 -- MISCELLANEOUS: Tax anticipation notes 0 0 0 11,069 Other 356,101 290,007 66,094 357,430 IRB building rents 230,000 230,000 0 240,000 Total Miscellaneous 586,101 520,007 66,094 608,499 CAPITAL OUTLAY: Equipment 130,201 81,939 48,262 149,590 Sheriff administration 17,850 0 17,850 1,195 Crime control and investigation 19,766 15,950 3,816 16,680 Task force 6,113 3,274 2,839 9,717 Regional forensic laboratory 4,825 5,583 (758) 6,506 Communication system development 48,000 0 48,000 119,958 Correctional administration 21,513 14,313 7,200 6,891 Total Capital Outlay 248,268 121,059 127,209 310,537 DEBT SERVICE: Tax anticipation notes 0 0 0 241,751 Other 0 125,750 (125,750) 0 IRB building rents 91,015 74,194 16,821 219,442 Total Debt Service 91,015 199,944 (108,929) 461,193 TOTAL EXPENDITURES 23,497,409 22,991,107 506,302 22,250,389 OTHER FINANCING SOURCES (USES): OPERATING TRANSFERS - IN: Non-Departmental 1,470,000 1,470,000 0 0 Pac - Diversion 69,916 28,665 (41,251) 69,192 Total Operating Transfers - In 1,539,916 1,498,665 (41,251) 69,192 OPERATING TRANSFERS - OUT: Appropriation Grants-In-Aid (2,351,147) (2,351,147) 0 (2,355,947) TOTAL OTHER FINANCING SOURCES (USES) (811,231) (852,482) (41,251) (2,286,755) EXCESS OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES (828,144) 27,910 856,054 (763,565) FUND BALANCE AT BEGINNING OF YEAR 1,487,068 1,487,068 0 2,268,836 Residual Equity Transfer 0 20,100 20,100 (18,203) FUND BALANCE AT END OF YEAR $ 658,924 $ 1,535,078 $ 876,154 $ 1,487,068 (67) g) • COLORADO (58) SPECIAL REVENUE FUNDS Special Revenue Funds are established to account for taxes or other earmarked revenues of the County which finance specified activities as required by law or administrative action. 4 COLORADO COUNTY OF WELD STATE OF COLORADO SPECIAL REVENUE FUNDS EXPLANATIONS OF INDIVIDUAL FUNDS December 31, 1992 Road and Bridge Fund: The Road and Bridge Fund records all costs related to Weld County road and bridge construction and maintenance. This fund is also utilized for allocation of monies to cities and towns for use in their road and street activities. In compliance with GASB statement #6 Special Assessment Districts Antelope Hills 2, Northmoore Acres, Casa Grande, Knaus, 71st Avenue, Basswood Avenue, and 83rd Avenue are reported in the Road & Bridge Fund. Social Services Fund: The Social Services Fund accounts for the various public welfare programs administered by the County. 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. Contingent Fund: The Contingent Fund records any property tax revenue levied by the Board of County Commissioners to cover reasonably unforeseen expenditures. 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. Human Resources Fund: The Human Resources Fund accounts for various federal and state human service grants. Primary funding agencies are DOL, HHS, and CSA. 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 further improvement and development of landfill sites within the County. Housing Authority Fund: The Housing Authority Fund accounts for various federal housing grants -the primary funding agency is HUD. (69) COUNTY OF WELD STATE OF COLORADO SPECIAL REVENUE FUNDS COMBINING BALANCE SHEET December 31, 1992 With Comparative Amounts as of December 31, 1991 Road and Social Conservation Bridge Services Trust Contingent Emergency Fund Fund Fund Fund Fund ASSETS ASSETS: Cash and short-term investments $ 1,219,614 $ 3,826,487 $ 177,399 $ 4,733,539 $ 800,000 Receivables (net of allowance for uncollectibles): Current property tax 3,110,572 2,577,135 0 2,041,122 0 Delinquent property tax 50,818 39,533 0 13,855 0 Accounts 133,843 2,476 266 0 0 Special assessment 249,590 0 0 0 0 Due from other County funds 1,094,333 20,047 0 0 0 Due from other governmental units 7,689 297,191 0 0 0 Advances to other funds 0 0 0 0 0 Inventories 568,189 0 0 0 0 Other assets 0 7,404 0 0 0 TOTAL ASSETS $ 6,434,648 $ 6,770,273 $ 177,665 $ 6,788,516 $ 800,000 LIABILITIES AND FUND BALANCES LIABILITIES: Accounts payable $ 155,687 $ 474,425 $ 3,057 $ 0 $ 0 Accrued liabilities 124,809 147,906 0 0 0 Due to other governments 0 50,145 0 0 0 Due to other County funds 261,562 66,276 0 0 0 Deferred revenue 3,372,364 2,619,070 0 2,065,859 0 Unexpended grant revenue 0 2,961,825 0 0 0 Other liabilities 0 3,843 0 0 0 Retainage payable 0 15,509 0 0 0 Total Liabilities 3,914,422 6,338,999 3,057 2,065,859 0 FUND BALANCES: Reserve for encumbrances 460,471 0 0 0 0 Reserve for advances to other funds 0 0 0 0 0 Reserve for other assets 0 7,404 0 0 0 Reserve for inventories 568,189 0 0 0 0 Reserve for emergencies 0 0 0 0 800,000 Reserve for claims 0 0 0 4,591,752 0 Unreserved: Designated for future years' expenditures 770,000 0 0 130,905 0 Undesignated 721,566 423,870 174,608 0 0 Total Fund Balances 2,520,226 431,274 174,608 4,722,657 800,000 TOTAL LIABILITIES AND FUND BALANCE $ 6,434,648 $ 6,770,273 $ 177,665 $ 6,788,516 $ 800,000 (70) Public Human Solid Housing TOTALS Health Resources Waste Authority December 31 December 31 Fund Fund Fund Fund 1992 1991 $ 444,825 $ 263,202 $ 292,849 $ 201,530 $ 11,959,445 $ 8,766,806 O 0 0 0 7,728,829 7,828,793 O 0 0 0 104,206 192,472 100,601 341,292 54,104 1,249 633,831 503,231 O 0 0 0 249,590 260,839 140 44,913 0 1,000 1,160,433 245,903 (6,951) 720,644 0 65,975 1,084,548 790,885 O 0 75,000 0 75,000 75,000 2,017 480,522 0 0 1,050,728 936,018 1,099 1,085 0 91,178 100,766 92,399 $ 541,731 $ 1,851,658 $ 421,953 $ 360,932 $ 24,147,376 $ 19,692,346 $ 132,527 $ 223,536 $ 889 $ 11,813 $ 1,001,934 $ 630,003 64,363 185,210 976 4,919 528,183 514,895 0 0 0 7,692 57,837 237,996 11,121 30,176 234 1,021 370,390 361,047 42,614 0 75,000 0 8,174,907 8,373,939 22,082 486,565 0 59,779 3,530,251 2,636,649 0 54,689 0 0 58,532 62,074 0 0 0 0 15,509 (288) 272,707 980,176 77,099 85,224 13,737,543 12,816,315 52,316 8,952 0 0 521,739 446,718 O 0 75,000 0 75,000 75,000 1,099 1,085 0 91,178 100,766 92,399 2,017 0 0 0 570,206 579,318 O 0 0 0 800,000 0 0 0 0 0 4,591,752 1,747,135 50,000 0 269,854 0 1,220,759 2,189,852 163,592 861,445 0 184,530 2,529,611 1,745,609 269,024 871,482 344,854 275,708 10,409,833 6,876,031 $ 541,731 $ 1,851,658 $ 421,953 $ 360,932 $ 24,147,376 $ 19,692,346 (71) COUNTY OF WELD STATE OF COLORADO SPECIAL REVENUE FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES For The Year Ended December 31, 1992 With Comparative Amounts for 1991 Road and Social Conservation Bridge Services Trust Contingent Emergency Fund Fund Fund Fund Fund REVENUES: Taxes $ 5,207,743 $ 3,379,595 $ 0 $ 1,005,218 $ 0 Licenses and permits 282,472 0 0 0 0 Intergovernmental 5,745,293 23,323,125 220,219 0 0 Charges for services 177,115 0 0 0 0 Miscellaneous 470,035 2,137 3,379 0 0 Total Revenues 11,882,658 26,704,857 223,598 1,005,218 0 EXPENDITURES: Current: Public works 11,286,599 0 0 0 0 Public health and welfare 0 26,539,611 0 0 0 Culture and recreation 0 0 209,105 0 0 Economic assistance 0 1,983 0 0 0 Other professional services 0 0 0 0 0 Capital outlay 0 24,611 0 0 0 Intergovernmental 809,896 0 0 0 0 Total Expenditures 12,096,495 26,566,205 209,105 0 0 EXCESS OF REVENUES OVER (UNDER) EXPENDITURES (213,837) 138,652 14,493 1,005,218 0 OTHER FINANCING SOURCES (USES): Operating transfers - in 356,837 0 0 4,253,649 800,000 Operating transfers - out (973,966) (28,665) (93,820) (1,450,000) 0 Total Other Financing Sources (Uses) (617,129) (28,665) (93,820) 2,803,649 800,000 EXCESS OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES (830,966) 109,987 (79,327) 3,808,867 800,000 FUND 'ATANCES AT BEGINNING OF YEAR 3,351,192 321,287 253,935 913,790 0 Residual Equity Transfer 0 0 0 0 0 FUND BALANCES AT END OF YEAR $ 2,520,226 $ 431,274 $ 174,608 $ 4,722,657 $ 800,000 (72) Public Human Solid Housing Health Resources Waste Authority Total Total - Fund Fund Fund Fund 1992 1991 $ 0 $ 0 $ 0 $ 0 $ 9,592,556 $ 9,127,926 6,982 0 0 0 289,454 242,741 622,125 5,805,395 0 1,497,339 37,213,496 34,684,023 506,775 316,944 445,531 0 1,446,365 1,006,006 24,094 129,067 0 4,978 633,690 349,373 1,159,976 6,251,406 445,531 1,502,317 49,175,561 45,410,069 O 0 0 0 11,286,599 10,721,226 2,137,923 0 0 0 28,677,534 26,574,813 O 0 0 0 209,105 136,726 O 6,271,504 0 1,471,362 7,744,849 7,253,471 0 0 139,942 0 139,942 43,970 O 149,210 0 0 173,821 21,252 0 0 0 0 809,896 810,111 2,137,923 6,420,714 139,942 1,471,362 49,041,746 45,561,569 (977,947) (169,308) 305,589 30,955 133,815 (151,500) 1,116,939 117,096 0 0 6,644,521 1,245,947 (127,483) 0 (570,600) 0 (3,244,534) (798,882) 989,456 117,096 (570,600) 0 3,399,987 447,065 11,509 (52,212) (265,011) 30,955 3,533,802 295,565 257,515 923,694 609,865 244,753 6,876,031 6,640,791 O 0 0 0 0 (60,325) $ 269,024 $ 871,482 $ 344,854 $ 275,708 $ 10,409,833 $ 6,876,031 (73) COUNTY OF WELD STATE OF COLORADO SPECIAL REVENUE FUNDS ROAD AND BRIDGE FUND Statement of Revenues, Expenditures and Changes in Fund Balance, Budget and Actual For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 Budget Actual Variance Actual REVENUES: TARES: General property tax $ 3,814,516 $ 3,809,758 $ (4,758) $ 3,645,163 Specific ownership taxes 1,310,000 1,385,218 75,218 1,304,665 Penalties & interest 0 12,767 12,767 15,192 Total Taxes 5,124,516 5,207,743 83,227 4,965,020 LICENSES AND PERMITS: Moving permits 265,000 282,472 17,472 237,945 INTERGOVERNMENTAL: Matching funds snow/gravel 1,000 0 (1,000) 0 Mineral leasing 37,300 43,703 6,403 32,326 Grazing act 138,900 138,932 32 63,255 Payment in lieu of taxes 10,000 10,027 27 10,027 Grant 9,000 9,000 0 0 Motor vehicle registration fee 220,000 235,233 15,233 209,669 Highway user tax fund 5,644,800 5,295,505 (349,295) 5,256,940 State maintenance agreement 9,000 12,893 3,893 5,157 Cities & towns 0 0 0 59,888 Total Intergovernmental 6,070,000 5,745,293 (324,707) 5,637,262 CHARGES FOR SERVICES: Charges for services 842,000 177,115 (664,885) 126,088 MISCELLANEOUS: Earnings on deposits 20,000 26,683 6,683 21,944 Special assessments 0 419,239 419,239 92,903 Miscellaneous 0 6,643 6,643 0 Other 13,000 13,548 548 22,495 Sale of assets 0 0 0 500 Recovery of losses 4,000 3,922 (78) 0 Total Miscellaneous 37,000 470,035 433,035 137,842 TOTAL REVENUES 12,338,516 11,882,658 (455,858) 11,104,157 EXPENDITURES: PUBLIC WORKS: Bridge construction 1,309,832 1,091,169 218,663 1,062,736 Maintenance of condition 2,124,426 2,137,315 (12,889) 1,947,539 Maintenance support 1,148,338 970,359 177,979 920,757 Trucking division 1,316,399 1,323,598 (7,199) 1,115,535 Mining division 1,020,730 997,325 23,405 917,436 Administration 261,644 264,538 (2,894) 246,235 Other public works 5,483,609 4,502,295 981,314 4,510,988 Total Public Works 12,664,978 11,286,599 1,378,379 10,721,226 (74) COUNTY OF WELD STATE OF COLORADO SPECIAL REVENUE FUNDS ROAD AND BRIDGE FUND Statement of Revenues, Expenditures and Changes in Fund Balance, Budget and Actual For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 Budget Actual Variance Actual EXPENDITURES (CONTINUED): CAPITAL OUTLAY: Other public works $ 26,000 $ 0 $ 26,000 $ 0 INTERGOVERNMENTAL: Grants-in-aid to cities/towns 818,172 809,896 8,276 810,111 TOTAL EXPENDITURES 13,509,150 12,096,495 1,412,655 11,531,337 OTHER FINANCING SOURCES (USES): OPERATING TRANSFERS - IN: Non-Departmental 0 356,837 356,837 0 -- OPERATING TRANSFERS - OUT: Other public works (973,966) (973,966) 0 (50,000) TOTAL OTHER FINANCING SOURCES (USES) (973,966) (617,129) 356,837 (50,000) EXCESS OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES (2,144,600) (830,966) 1,313,634 (477,180) FUND BALANCE AT BEGINNING OF YEAR 3,351,192 3,351,192 0 3,855,372 Residual Equity Transfer 0 0 0 (27,000) FUND BALANCE AT END OF YEAR $ 1,206,592 $ 2,520,226 $ 1,313,634 $ 3,351,192 (75) COUNTY OF WELD STATE OF COLORADO SPECIAL REVENUE FUNDS SOCIAL SERVICES FUND Statement of Revenues, Expenditures and Changes in Fund Balance, Budget and Actual For the Year Ended December 31, 1992 With Comparative Actual. Amounts Por the Year Ended December 31, 1991 1992 1992 1992 1991 Budget Actual Variance Actual — REVENUES, TAXES: General property tax $ 3,135,382 $ 3,129,935 $ (5,447) $ 2,908,502 Specific ownership taxes 240,000 239,167 (833) 222,287 Penalties 6 interest 0 10,493 10,493 12,129 — Total Taxes 3,375,382 3,379,595 4,213 3,142,918 INTERGOVERNMENTAL: Federal grants 85,000 84,813 (187) 48,774 "— Direct assistance 89,000 0 (89,000) 0 Welfare (SS) 15,095,945 23,238,312 8,142,367 21,413,274 Total Intergovernmental 15,269,945 23,323,125 8,053,180 21,462,048 MISCELLANEOUS: Earnings on deposits 0 2,137 2,137 881 TOTAL REVENUES 18,645,327 26,704,857 8,059,530 24,605,847 — EXPENDITURES: PUBLIC HEALTH MD WELFARE: Non-Departmental 0 (4,999) 4,999 0 Administrative - regular 3,576,534 3,348,937 227,597 3,122,813 — Administrative - IV-D 682,177 703,885 (21,708) 572,166 Institutional care 178,900 140,468 38,432 103,665 Food stamps 8,984,000 8,901,600 82,400 8,294,617 Jobs - IV-F 284,941 290,554 (5,613) 187,792 Employment first 100,000 114,241 (14,241) 66,652 - General assistance 112,000 108,964 3,036 107,861 AB 6,825 3,760 3,065 5,304 AFDC 6,630,000 6,212,627 417,373 5,963,237 AND - State 513,500 461,378 52,122 546,423 CW - FC 1,009,600 991,545 18,055 1,091,665 AFDC - FC 1,122,693 1,046,513 76,180 842,285 Day care 1,494,500 1,477,425 17,075 1,071,869 Medicaid transportation 4,000 8,761 (4,761) 5,399 Non-contractural case services 10,000 11,002 (1,002) 10,563 - OAP - A 1,448,500 1,435,520 12,980 1,473,173 Placement alternative care 415,000 369,826 45,174 306,029 AFDC - U 0 0 0 (47) Staff development 7,250 3,418 3,832 2,423 Medical examinations 10,000 7,805 2,195 8,771 ` IV-D 0 680 (680) 0 Administrative - LEAP 62,425 54,930 7,495 37,154 Administrative - LEAP outreach 31,482 30,788 694 26,112 LEAP - regular 785,000 719,896 65,104 589,797 LEAP - emergency 35,000 14,747 20,253 13,425 — FEMA 120,000 85,340 34,660 50,982 Total Public Health and Welfare 27,624,327 26,539,611 1,084,716 24,500,130 (76) COUNTY OF WELD STATE OF COLORADO SPECIAL REVENUE FUNDS SOCIAL SERVICES FUND Statement of Revenues, Expenditures and Changes in Fund Balance, Budget and Actual For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 — Budget Actual Variance Actual EXPENDITURES (CONTINUED): ECONOMIC ASSISTANCE: Jobs - IV-F $ 0 $ (251) $ 251 $ 0 Placement alternative care 0 2,181 (2,181) 1,781 LEAP - regular 0 53 (53) 0 Total Economic Assostance 0 1,983 (1,983) 1,781 CAPITAL OUTLAY: Administrative - regular 5,000 23,133 (18,133) 0 Fema 0 1,478 (1,478) 846 Total Capital Outlay 5,000 24,611 (19,611) 846 TOTAL EXPENDITURES 27,629,327 26,566,205 1,063,122 24,502,757 OTHER FINANCING SOURCES (USES): OPERATING TRANSFERS - OUT: Placement alternative care 0 (28,665) (28,665) (69,192) EXCESS OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES (8,984,000) 109,987 9,093,987 33,898 FUND BATANCE AT BEGINNING OF YEAR 321,287 321,287 0 287,389 FUND BALANCE AT END OF YEAR $ (8,662,713) $ 431,274 $ 9,0931987 $ 321,287 (77) COUNTY OF WELD STATE OF COLORADO SPECIAL REVENUE FUNDS CONSERVATION TRUST FUND Statement of Revenues, Expenditures and Changes in Fund Balance, Budget and Actual For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 Budget Actual Variance Actual REVENUES: INTERGOVERNMENTAL: State lottery $ 212,000 $ 220,219 $ 8,219 $ 200,103 MISCELLANEOUS: Earnings on deposits 6,000 3,379 (2,621) 4,914 TOTAL REVENUES 218,000 223,598 5,598 205,017 EXPENDITURES: CULTURE AND RECREATION: Land improvements 246,048 209,105 36,943 136,726 CAPITAL OUTLAY: Land improvements 90,000 0 90,000 0 TOTAL EXPENDITURES 336,048 209,105 126,943 136,726 OTHER FINANCING SOURCES (USES): OPERATING TRANSFERS - OUT: Land improvements (93,825) (93,820) 5 0 EXCESS OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES (211,873) (79,327) 132,546 68,291 FUND BALANCE AT BEGINNING OF YEAR 253,935 253,935 0 185,644 FUND BALANCE AT END OF YEAR $ 42,062 $ 174,608 $ 132,546 $ 253,935 (78) COUNTY OF WELD STATE OF COLORADO SPECIAL REVENUE FUNDS CONTINGENT FUND Statement of Revenues and Expenditures and Changes in Fund Balance, Budget and Actual For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 Budget Actual Variance Actual REVENUES: TAXES: General property tax $ 932,000 $ 931,018 $ (982) $ 944,004 Specific ownership taxes 68,000 71,081 3,081 72,052 Penalties & interest 0 3,119 3,119 3,932 TOTAL REVENUES 1,000,000 1,005,218 5,218 1,019,988 EXPENDITURES: MISCELLANEOUS: Other 50,000 0 50,000 0 TOTAL EXPENDITURES 50,000 0 50,000 0 OTHER FINANCING SOURCES (USES): OPERATING TRANSFERS - IN: Other 0 4,253,649 4,253,649 0 OPERATING TRANSFERS - OUT: Other (1,450,000) (1,450,000) 0 (679,690) TOTAL OTHER FINANCING SOURCES (USES) (1,450,000) 2,803,649 4,253,649 (679,690) EXCESS OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES (500,000) 3,808,867 4,308,867 340,298 FUND BALANCE AT BEGINNING OF YEAR 913,790 913,790 0 573,492 FUND I)ATANCE AT END OF YEAR $ 413,790 $ 4,722,657 $ 4,308,867 $ 913,790 (79) COUNTY OF WELD STATE OF COLORADO SPECIAL REVENUE FUNDS EMERGENCY FUND Statement of Revenues and Expenditures and Changes in Fund Balance, Budget and Actual For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 Budget Actual Variance Actual REVENUE $ 0 $ 0 $ 0 $ 0 EXPENDITURES 0 0 0 0 OTHER FINANCING SOURCES (USES): OPERATING TRANSFERS - INS: Non-Departmental 0 800,000 800,000 0 EXCESS OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES 0 800,000 800,000 0 FUND BALANCE AT BEGINNING OF YEAR 0 0 0 0 FUND BALANCE AT END OF YEAR $ 0 $ 800,000 $ 800,000 $ 0 (80) COUNTY OF WELD STATE OF COLORADO SPECIAL REVENUE FUNDS PUBLIC HEALTH FUND Statement of Revenues and Expenditures and Changes in Fund Balance, Budget and Actual For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 __ Budget Actual Variance Actual REVENUES: LICENSES AND PERMITS: Health license $ 3,500 $ 6,982 $ 3,482 $ 4,796 INTERGOVERNMENTAL: State grants 457,491 583,700 126,209 551,385 Health 25,279 29,682 4,403 22,012 Counties 12,000 8,743 (3,257) 8,632 Total Intergovernmental 494,770 622,125 127,355 582,029 CHARGES FOR SERVICES: Charges for services 62,500 87,346 24,846 26,147 Protective inspection fees 84,743 41,513 (43,230) 32,461 Vital statistics 49,800 60,243 10,443 56,467 Clinic fees 143,050 140,676 (2,374) 119,059 Septic 60,000 86,637 26,637 67,084 Water 35,000 90,360 55,360 48,207 Total Charges for Services 435,093 506,775 71,682 349,425 MISCELLANEOUS: Rental income 0 (40) (40) (191) Miscellaneous 46,447 23,948 (22,499) 46,447 Other 0 86 86 62 Recovery of losses 0 100 100 0 --- Total Miscellaneous 46,447 24,094 (22,353) 46,318 TOTAL REVENUES 979,810 1,159,976 180,166 982,568 EXPENDITURES: PUBLIC HEALTH AND WELFARE: Public health administration 98,147 84,163 13,984 83,724 Health education 242 0 242 64,692 Nursing 1,271,399 1,333,078 (61,679) 1,182,279 Environmental health 743,473 720,682 22,791 743,988 Total Public Health and Welfare 2,113,261 2,137,923 (24,662) 2,074,683 CAPITAL OUTLAY: Public health administration 1,793 0 1,793 14,795 Nursing 10,500 0 10,500 0 Environmental health 0 0 0 6,188 Total Capital Outlay 12,293 0 12,293 20,983 TOTAL EXPENDITURES 2,125,554 2,137,923 (12,369) 2,095,666 OTHER FINANCING SOURCES (USES): OPERATING TRANSFERS - IN: Non-Departmental 1,116,939 1,116,939 0 1,166,430 OPERATING TRANSFERS - OUT: Public health administration (127,483) (127,483) 0 0 TOTAL OTHER FINANCING SOURCES 989,456 989,456 0 1,166,430 EXCESS OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES _ AND OTHER FINANCING USES (156,288) 11,509 167,797 53,332 FUND BALANCE AT BEGINNING OF YEAR 257,515 257,515 0 204,183 FUND BALANCE AT END OF YEAR $ 101,227 $ 269,024 $ 167,797 $ 257,515 (81) COUNTY OF WELD STATE OF COLORADO SPECIAL REVENUE FUNDS HUMAN RESOURCES FUND Statement of Revenues and Expenditures and Changes in Fund Balance, Budget and Actual For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 Budget Actual Variance Actual REVENUES: INTERGOVERNMENTAL: Federal grants $ 5,241,378 $ 4,948,629 $ (292,749) $ 4,213,901 Other 0 189,488 189,488 14,483 State grants 543,087 667,278 124,191 1,017,815 Total Intergovernmental 5,784,465 5,805,395 20,930 5,246,199 CHARGES FOR SERVICES: State grants 55,000 43,925 (11,075) 2,167 Charges for services 96,000 273,019 177,019 264,335 Total Charges for Services 151,000 316,944 165,944 266,502 MISCELLANEOUS: Other 0 4,500 4,500 0 Donations from private sources 140,000 67,138 (72,862) 86,720 Welfare diversion 320,000 57,429 (262,571) 64,111 Total Miscellaneous 460,000 129,067 (330,933) 150,831 TOTAL REVENUES 6,395,465 6,251,406 (144,059) 5,663,532 EXPENDITURES: ECONOMIC ASSISTANCE: JTPA technical assistance 17,000 4,462 12,538 3,188 JTPA performance incentive 96,608 8,483 88,125 23,125 Dislocated farmers 0 6,605 (6,605) 0 JTPA 8% education coordination 0 4,433 (4,433) 9,430 JTPA 6% T.A.T. SDA to SDA 0 9,588 (9,588) 445 JTPA older workers 35,000 33,115 1,885 26,453 6% TAT C.O. 0 (3,878) 3,878 0 JTPA EDWAA 502 137,130 107,782 29,348 124,467 EDWAA 105 displaced homemaker 22,856 21,943 913 27,295 Transportation contract 20,000 5,093 14,907 0 Summer youth 582,069 388,818 193,251 417,445 JTPA basic 900,116 758,915 141,201 608,828 Job service 192,552 194,843 (2,291) 195,813 Summer job hunt 5,000 5,000 0 5,000 Employment first 106,000 106,229 (229) 60,970 UI training program 0 0 0 632 WCCN 0 0 0 142 New directions 135,624 125,102 10,522 101,427 State pre-school 171,463 235,237 (63,774) 125,865 Head start 722,178 994,230 (272,052) 895,827 Head start handicap 21,615 21,615 0 21,615 Head start T & TA 10,552 15,177 (4,625) 10,522 Migrant hdst/day care basic 748,822 992,771 (243,949) 733,460 CSBG 156,574 162,347 (5,773) 134,616 Migrant head start-handicap 27,650 6,698 20,952 27,650 Head start - high scope 0 125 (125) 1,140 Migrant headstart T E T A 7,670 8,446 (776) 7,670 Migrant headstart playground project 0 0 0 36 Supplemental foods 941,903 1,001,701 (59,798) 1,115,684 Urban mass-transportation adm. 20,666 10,300 10,366 20,666 DOE weatherization 10,440 19,305 (8,865) 5,776 CDBG ESCH 0 0 0 7,104 CDBG ESG 0 0 0 22,704 AAA elder abuse 1,700 225 1,475 0 HCBS 55,000 59,213 (4,213) 39,947 OAA area agency 49,403 47,678 1,725 46,364 OAA title III-B 230,000 92,661 137,339 92,441 (Continued on next page) (82) COUNTY OF WELD STATE OF COLORADO SPECIAL REVENUE FUNDS HUMAN RESOURCES FUND Statement of Revenues and Expenditures and Changes in Fund Balance, Budget and Actual For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 Budget Actual Variance Actual EXPENDITURES (CONTINUED): AAA case management $ 0 $ 4,364 $ (4,364) $ 14,942 AAA legal aide 118 0 25,720 (25,720) 30,856 AAA ombudsman II-B 0 33,124 (33,124) 17,858 OAA title III C-I congregate 360,840 242,072 118,768 247,693 OAA title III-C 90,000 58,633 31,367 56,546 OAA in home support 6,000 3,420 2,580 2,000 Title IV training 0 991 (991) 0 Human resources general fund (22,198) 294,158 (316,356) 306,315 Client wage pool 0 11,454 (11,454) 0 Welfare diversion/county reimbursement 0 76,665 (76,665) 72,632 General administration allocation 3,246 0 3,246 0 EODS allocation 0 0 0 0 Non-EODS allocation 0 0 0 0 Transportation allocation 113 0 113 0 Human resources lab pool 96,000 76,641 19,359 29,469 Total Economic Assistance 5,959,592 6,271,504 (311,912) 5,692,058 MISCELLANEOUS: Supplemental foods 0 0 0 269 OAA area agency 0 0 0 23 _ Total Miscellaneous 0 0 0 292 CAPITAL OUTLAY: JTPA EDWAA 50% 0 0 0 9 EDWAA 10% displaced homemaker 0 0 0 5 State pre-school 0 0 0 14 Head start 61,605 0 61,605 178 Migrant hdst/day care basic 60,000 4,389 55,611 0 CSBG 0 0 0 63 Supplemental foods 1,450 0 1,450 0 Transportation 320,000 144,821 175,179 0 Total Capital Outlay 443,055 149,210 293,845 269 TOTAL EXPENDITURES 6,402,647 6,420,714 (18,067) 5,692,619 OTHER FINANCING SOURCES (USES): OPERATING TRANSFERS - IN: OAA area agency 12,351 12,351 0 11,190 Human resources general fund (22,198) 104,745 126,943 68,327 TOTAL OTHER FINANCING SOURCES (USES) (9,847) 117,096 126,943 79,517 EXCESS OF REVENUES AND OTHER FINANCING -- SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES (17,029) (52,212) (35,183) 50,430 FUND BATANCE AT BEGINNING OF YEAR 923,694 923,694 0 906,589 Residual Equity Transfer 0 0 0 (33,325) FUND BA ONCE AT END OF YEAR $ 906,665 $ 871,482 $ (35,183) $ 923,694 (83) COUNTY OF WELD STATE OF COLORADO SPECIAL REVENUE FUNDS SOLID WASTE FUND Statement of Revenues and Expenditures and Changes in Fund Balance, Budget and Actual For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 Budget Actual Variance Actual REVENUES: CHARGES FOR SERVICES: Landfill surcharge $ 350,000 $ 445,531 $ 95,531 $ 263,991 TOTAL REVENUES 350,000 445,531 95,531 263,991 EXPENDITURES: MISCELLANEOUS: Other 150,000 21,216 128,784 0 Solid waste 0 374 (374) 456 Code enforcement 150,000 118,352 31,648 42,376 TOTAL EXPENDITURES 300,000 139,942 160,058 42,832 OTHER FINANCING SOURCES (USES): OPERATING TRANSFERS - OUT: Code enforcement (613,763) (570,600) 43,163 0 EXCESS OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES (563,763) (265,011) 298,752 221,159 FUND BALANCE AT BEGINNING OF YEAR 609,865 609,865 0 388,706 FUND BALANCE AT END OF YEAR $ 46,102 $ 344,854 $ 298,752 $ 609,865 (84) COUNTY OF WELD STATE OF COLORADO SPECIAL REVENUE FUNDS HOUSING AUTHORITY FUND Statement of Revenues and Expenditures and Changes in Fund Balance, Budget and Actual For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 _, 1992 1992 1992 1991 Budget Actual Variance Actual REVENUES: INTERGOVERNMENTAL: Federal grants $ 1,626,583 $ 1,421,434 $ (205,149) $ 1,544,711 CDBG loan proceeds 65,000 50,730 (14,270) 7,955 Other 0 25,175 25,175 3,716 Total Intergovernmental 1,691,583 1,497,339 (194,244) 1,556,382 MISCELLANEOUS: Earnings on deposits 145,500 4,978 (140,522) 8,587 TOTAL REVENUES 1,837,083 1,502,317 (334,766) 1,564,969 EXPENDITURES: ECONOMIC ASSISTANCE: Other 145,500 0 145,500 36 Administrative 80,131 78,524 1,607 82,333 Housing assistance 612,894 539,917 72,977 531,581 Housing vouchers preliminary 3,415 3,300 115 2,960 Housing voucher administrative 79,647 79,981 (334) 63,533 Housing voucher payments 632,436 650,088 (17,652) 549,715 Contract payments 0 0 0 59,996 Administrative-008 0 0 0 7,554 Housing preservation grant-administration 7,400 3,306 4,094 0 Housing preservation grant 32,000 6,690 25,310 0 Rental rehabilitation 10,000 3,382 6,618 29,417 Rental rehabilitation administration 0 0 0 1,625 General administration 44,580 34,003 10,577 28,000 CDBG contract payments 67,000 33,671 33,329 202,882 1992 CDBG project-SW Weld 80,000 18,500 61,500 0 CDBG RCCF project 40,000 20,000 20,000 0 Total Economic Assistance 1,835,003 1,471,362 363,641 1,559,632 CAPITAL OUTLAY: Administrative 710 0 710 0 Housing voucher administrative 950 0 950 0 General administration 420 0 420 0 Total Capital Outlay 2,080 0 2,080 0 TOTAL EXPENDITURES 1,837,083 1,471,362 365,721 1,559,632 EXCESS OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES 0 30,955 30,955 5,337 FUND BALANCE AT BEGINNING OF YEAR 244,753 244,753 0 239,416 FUND BALANCE AT END OF YEAR $ 244,753 $ 275,708 $ 30,955 $ 244,753 (85) %Mk COLORADO (86) CAPITAL PROJECTS FUNDS Capital Projects Funds are established to account for financial resources used for the acquisition or improvement of the capital facilities of the County. P 4;to ct WI`'p COLORADO COUNTY OF WELD STATE OF COLORADO CAPITAL PROJECTS FUND EXPLANATION OF INDIVIDUAL FUND December 31, 1992 Capital Expenditures Fund: This fund accounts for various capital improvement projects on County property. (87) COUNTY OF WELD STATE OF COLORADO CAPITAL PROJECTS FUND CAPITAL EXPENDITURES FUND BALANCE SHEET December 31, 1992 With Comparative Amounts as of December 31, 1991 1992 1991 ASSETS ASSETS: Cash and short-term investments $ 1,234,303 $ 2,317,672 Receivables (net of allowance for uncollectibles): Current property tax 560,486 875,363 Delinquent property tax 12,027 12,117 Accounts 8,768 63,304 Due from other County funds 0 124,233 TOTAL ASSETS $ 1,815,584 $ 3,392,689 LIABILITIES AND FUND 'ALANCE LIABILITIES: Accounts payable $ 51,727 $ 70,901 Accrued liabilities 0 1,675 Deferred revenue 581,167 893,417 Advances from other funds 340,856 340,856 Retainage payable 0 27,622 Total Liabilities 973,750 1,334,471 FUND BALANCE: Reserve for encumbrances 33,820 68,380 Reserve for claims 0 853,502 Unreserved: Designated for future years' expenditures 50,000 1,136,336 Undesignated 758,014 0 Total Fund Balance 841,834 2,058,218 TOTAL LIABILITIES AND FUND BALANCE $ 1,815,584 $ 3,392,689 (88) COUNTY OF WELD STATE OF COLORADO CAPITAL PROJECTS FUNDS CAPITAL EXPENDITURES FUND Statement of Revenue, and Expenditures and Changes in Fund Balance, Budget and Actual For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 Budget Actual Variance Actual REVENUES: TAXES: General property tax $ 943,000 $ 879,170 $ (63,830) $ 950,511 Specific ownership taxes 0 67,213 67,213 72,842 Penalties i interest 0 2,949 2,949 3,975 Total Taxes 943,000 949,332 6,332 1,027,328 INTERGOVERNMENTAL: Federal grants 0 0 0 236,349 State grants 0 0 0 58,651 _. Total Intergovernmental 0 0 0 295,000 MISCELLANEOUS: Earnings on deposits 40,000 56,998 16,998 75,706 Miscellaneous 0 8,803 8,803 65,551 Other 0 1,675 1,675 0 Gain on sale of assets 0 0 0 2,529 Total Miscellaneous 40,000 67,476 27,476 143,786 TOTAL REVENUES 983,000 1,016,808 33,808 1,466,114 EXPENDITURES: CAPITAL OUTLAY: Buildings 2,741,381 2,138,636 602,745 1,832,607 TOTAL EXPENDITURES 2,741,381 2,138,636 602,745 1,832,607 OTHER FINANCING SOURCES (USES): C.O.P. PROCEEDS FROM WELD FINANCE CORPORATION 2,000,000 1,978,946 (21,054) 0 OPERATING TRANSFERS - IN: Non-departmental 0 0 0 1,379,690 OPERATING TRANSFERS - OUT: Buildings (2,073,502) (2,073,502) 0 0 TOTAL OTHER FINANCING SOURCES (73,502) (94,556) (21,054) 1,379,690 EXCESS OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES (1,831,883) (1,216,384) 615,499 1,013,197 FUND BALANCE AT BEGINNING OF YEAR 2,058,218 2,058,218 0 1,045,021 FUND BALANCE AT END OF YEAR $ 226,335 $ 841,834 $ 615,499 $ 2.058,218 (89) Wine COLORADO (90) ENTERPRISE FUNDS Enterprise Funds are used to 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 of providing goods or services to the general public on a continuing basis be financed or recovered primarily through user charges. lURe COLORADO COUNTY OF WELD STATE OF COLORADO ENTERPRISE FUND EXPLANATION OF INDIVIDUAL FUND December 31, 1992 Ambulance Fund: This fund accounts for the ambulance services provided to Weld County. (91) COUNTY OF WELD STATE OF COLORADO ENTERPRISE FUND AMBULANCE FUND BALANCE SHEET December 31, 1992 With Comparative Amounts as of December 31, 1991 1992 1991 ASSETS CURRENT ASSETS: Cash and short-term investments $ 12,117 $ 414,225 Receivables (net of allowance for uncollectibles): Accounts - ambulance services 0 39,777 Accounts - other 1,311 1,238 Due from other County funds 7,440 6,070 Due from other governmental units 100,000 0 Total Current Assets 120,868 461,310 FIXED ASSETS: Buildings 637,099 0 Improvements other than buildings 48,496 0 Machinery and equipment 550,008 463,932 Accumulated depreciation (215,123) (176,170) Total Fixed Assets - Net 1,020,480 287,762 TOTAL ASSETS $ 1,141,348 $ 749,072 LIABILITIES AND FUND EQUITY CURRENT LIABILITIES: Accounts payable $ 32,952 $ 10,789 Accrued liabilities 121,020 81,206 Due to other County funds 6,105 7,142 Total Current Liabilities 160,077 99,137 FUND EQUITY: Contributed capital 146,373 89,021 Unreserved retained earnings 834,898 404,305 Reserved retained earnings 0 156,609 Total Fund Equity 981,271 649,935 TOTAL LIABILITIES AND FUND EQUITY $ 1,141,348 $ 749,072 (92) COUNTY OF WELD STATE OF COLORADO ENTERPRISE FUND AMBULANCE FUND Statement of Revenues, Expenses and Changes in Retained Earnings Compared with Budget For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 '- Budget Actual Variance Actual OPERATING REVENUE: Charges for services $ 0 7,440 7,440 0 Rescue unit fees 2,067,258 2,072,986 5,728 1,980,303 TOTAL OPERATING EXPENSES 2,067,258 2,080,426 13,168 1,980,303 OPERATING EXPENSES: Personnel services 901,347 914,040 (12,693) 869,135 Contractual services 74,101 78,947 (4,846) 74,441 Supplies 90,671 76,238 14,433 80,196 Repair and maintenance 81,455 48,894 32,561 51,985 Bad debt expense 639,272 688,338 (49,066) 727,303 . Other 163,713 151,991 11,722 159,946 Depreciation 95,000 97,035 (2,035) 65,994 TOTAL OPERATING EXPENSES 2,045,559 2,055,483 (9,924) 2,029,000 -- OPERATING INCOME (LOSS) 21,699 24,943 3,244 (48,697) NONOPERATING REVENUE State grants 125,000 100,000 (25,000) 47,913 Earnings on deposits 0 13,772 13,772 14,401 Other 0 5,514 5,514 7,845 Donations 180,000 186,364 6,364 4,947 Gain/(loss) on sale of assets 0 0 0 1,200 TOTAL NONOPERATING REVENUES 305,000 305,650 650 76,306 INCOME BEFORE OPERATING TRANSFERS 326,699 330,593 3,894 27,609 OPERATING TRANSFERS - IN: Non-Departmental 100,000 100,000 0 0 OPERATING TRANSFERS - OUT: Ambulance services (156,609) (156,609) 0 0 — TOTAL OPERATING TRANSFERS (56,609) (56,609) 0 0 NET INCOME 270,090 273,984 3,894 27,609 RETAINED EARNINGS AT BEGINNING OF YEAR 560,914 560,914 0 533,305 RETAINED EARNINGS AT END OF YEAR $ 831,004 $ 834,898 $ 3,894 $ 560,914 (93) wm €. COLORADO (94) INTERNAL SERVICE FUNDS Internal Service Funds are established to account for goods and services provided to other departments of the County on a cost-reimbursement basis. AiW i‘ COLORADO COUNTY OF WELD STATE OF COLORADO INTERNAL SERVICE FUNDS EXPLANATIONS OF INDIVIDUAL FUNDS December 31, 1992 Motor Vehicle Fund: This fund accounts for the revenue and costs generated by equipment and vehicles rented to the Road and Bridge Fund and to various departments of other County funds. 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. Printing and Supply Fund: This fund accounts for revenue and costs associated with providing printing services and the supply and stores function of the County. Computer Services Fund: This fund accounts for all data processing services provided to the County and other agencies on a cost-reimbursement basis. Insurance Fund: This fund accounts for all insurance costs for the County, except health insurance. The program is a combination of insured risks and protected self- insurance risks. PBX Fund: This fund accounts for all phone costs provided to the County and other outside agencies on a cost-reimbursement basis. (95) COUNTY OF WELD STATE OF COLORADO INTERNAL SERVICE FUNDS COMBINING BALANCE SHEET December 31, 1992 With Comparative Actual Amounts as of December 31, 1991 Health Motor Vehicle Insurance Printing and Fund Fund Supply Fund ASSETS CURRENT ASSETS: Cash and short-term investments $ 274,609 $ 106,327 $ 26,508 Receivables (net of allowance for uncollectibles): Current property tax 0 0 0 Delinquent property tax 0 0 0 Accounts 14,142 32 (15) Due from other County funds 294,359 0 0 Inventories 13,021 0 114,598 Other assets 0 0 0 Total Current Assets 596,131 106,359 141,091 FIXED ASSETS: Land 1,353,934 0 0 Buildings 2,643,959 0 0 Improvements other than buildings 215,999 0 0 Machinery and equipment 12,295,351 0 9,800 Accumulated depreciation (7,700,505) 0 (8,593) Total Fixed Assets - Net 8,808,738 0 1,207 TOTAL ASSETS $ 9,404,869 $ 106,359 $ 142,298 LIABILITIES AND FUND EQUITY CURRENT LIABILITIES: Accounts payable $ 168,714 $ 6,153 $ 3,173 Accrued liabilities 0 0 2,583 Due to other County funds 507 0 54 Deferred revenue 0 0 0 Total Current Liabilities 169,221 6,153 5,810 FUND EQUITY: Contributed capital 7,604,887 0 120,946 Unreserved retained earnings 1,630,761 100,206 15,542 Reserved retained earnings 0 0 0 Total Fund Equity 9,235,648 100,206 136,488 TOTAL LIABILITIES AND FUND EQUITY $ 9,404,869 $ 106,359 $ 142,298 (96) TOTALS Computer _ Services Insurance PBX December 31 December 31 Fund Fund Fund 1992 1991 $ 140,763 $ 1,022,821 $ (28,661) $ 1,542,367 $ 2,754,290 0 613,863 0 613,863 587,183 0 8,175 0 8,175 15,150 4,652 7,592 5,415 31,818 69,562 136 7,170 41,099 342,764 263,248 0 0 0 127,619 113,218 O 102,253 0 102,253 105,853 145,551 1,761,874 17,853 2,768,859 3,908,504 0 0 0 1,353,934 1,353,934 0 0 0 2,643,959 2,643,959 O 0 0 215,999 215,999 _ 2,920,515 0 574,949 15,800,615 14,922,689 (1,938,929) 0 (177,487) (9,825,514) (8,958,018) 981,586 0 397,462 10,188,993 10,178,563 $ 1,127,137 $ 1,761,874 $ 415,315 $ 12,957,852 $ 14,087,067 $ 3,422 $ 1,247 $ 12,298 $ 195,007 $ 346,138 178,380 281,559 7,046 469,568 469,045 1,891 0 6 2,458 306,904 O 624,640 0 624,640 606,315 183,693 907,446 19,350 1,291,673 1,728,402 677,697 0 180,361 8,583,891 8,595,531 265,747 854,428 215,604 3,082,288 2,745,740 _ 0 0 0 0 1,017,394 943,444 854,428 395,965 11,666,179 12,358,665 $ 1,127,137 $ 1,761,874 $ 415,315 $ 12,957,852 $ 14,087,067 (97) COUNTY OF WELD STATE OF COLORADO INTERNAL SERVICE FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS For The Year Ended December 31, 1992 With Comparative Actual Amounts For The Year Ended December 31, 1991 Health Motor Vehicle Insurance Printing and Fund Fund Supply Fund OPERATING REVENUES: Contributions $ 0 $ 126,947 $ 0 Charges for services 3,438,982 0 166,131 Total Operating Revenues 3,438,982 126,947 166,131 OPERATING EXPENSES: Personnel services 0 0 41,217 Contractual services 1,506,116 663 18,714 Supplies 436,667 0 88,438 Repair and maintenance 233,820 0 31,592 ' Insurance and bonds 0 0 0 Claims 0 116,932 0 Other 27,712 0 0 Depreciation 1,234,425 0 175 Total Operating Expenses 3,438,740 117,595 180,136 OPERATING INCA (LOSS) 242 9,352 (14,005) NONOPERATING REVENUES (EXPENSES): Taxes 0 0 0 Miscellaneous 0 0 0 Fees 0 1,020 0 Farm income 0 0 0 Gain on disposition of assets 149,110 0 0 Interest expense 0 0 0 Judgements and damages 0 1,053 0 Total Non-Operating Revenues (Expenses) 149,110 2,073 0 INCOME (LOSS) BEFORE OPERATING TRANSFERS 149,352 11,425 (14,005) OPERATING TRANSFERS: Operating transfers - in 0 0 0 Operating transfers - out (133,210) (68,520) (24,869) Total Operating Transfers (133,210) (68,520) (24,869) NET INCA (LOSS) 16,142 (57,095) (38,874) RETAINED EARNINGS AT BEGINNING OF YEAR 1,614,619 157,301 54,416 RETAINED EARNINGS AT END OF YEAR $ 1,630,761 $ 100,206 $ 15,542 (98) Computes Total Services Insurance PBX Total PBXd 1ta 21ta Fund Fund $ 0 $ 0 $ 0 $ 126,947 $ 131,637 2,115,613 71,323 558,887 6,350,936 6,471,032 2,115,613 71,323 558,887 6,477,883 6,602,669 0 101,031 1,580,410 1,504,266 1,438,1625 328,182 2,408,389 2,456,355 15,812 34,694 934 641,851 621,017 115,812 0 444,134 388,627 123,670 0 55,052 340 579 0 301,20211 0 0 520,051 403,119 520,051 356,233 0 24,279 204,160 249,114 152,169 0 37,785 1,652,108 1,665,091 379,723 0 2,729,556 739,015 547,263 7,752,305 7,581,282 (613,943) (667,692) 11,624 (1,274,422) (978,613) 602,736 640,893 O 602,736 0 56,034 O 242,41101 0 242,417 O 0 0 1,020 683 653 0 0 0 0 86 0 0 149,196 277,819 O 0 (25,842) (25,842) 30,614 0 40,390 0 41,443 86,400 86 885,543 (25,842) 1,010,970 1,031,868 (613,857) 217,851 (14,218) (263,452) 53,255 400,000 0 200,000 600,000 460,000 (261,495) (478,324) (50,976) (1,017,394) 0 138,505 (478,324) 149,024 (417,394) 460,000 (475,352) (260,473) 134,806 (680,846) 513,255 741,099 1,114,901 80,798 3,763,134 3,249,879 $ 265,747 $ 854,428 $ 215,604 $ 3,082,288 $ 3,763,134 (99) COUNTY OF WELD STATE OF COLORADO INTERNAL SERVICE FUNDS COIBINING STATEMENT OF CASH FLOWS For the Year Ended December 31, 1992 With Comparative Amounts For The Year Ended December 31, 1991 Motor Health Printing Computer Vehicle Insurance and Supply Services Fund Fund Fund Fund CASH FLOWS FROM OPERATING ACTIVITIES: Operating income (loss) $ 242 $ 9,352 $ (14,005) $ (613,943) Adjustments to reconcile operating income (loss) to net cash provided by operating activities: Depreciation 1,234,425 0 175 379,773 Change in assets and liabilities: (Increase) decrease in accounts receivable 35,433 250 17,542 (412) (Increase) decrease in inventory 1,852 0 (16,253) 0 (Increase) decrease in other assets (90,730) 0 0 6,909 Increase (decrease) in accounts payable (138,122) 1,110 (2,391) (11,264) Increase (decrease) in accrued liabilities 0 0 218 4,316 Increase (decrease) in other liabilities 90 (23,125) 0 (281,214) Total adjustments 1,042,948 (21,765) (709) 98,108 Net cash provided by (used for) operating activities 1,043,190 (12,413) (14,714) (515,835) CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES: Interest paid on borrowings 0 0 0 0 Property tax collections 0 0 0 0 Refunds 0 0 0 0 Grants and donations 14,784 2,073 0 3,144 Operating transfers-net (133,210) (68,520) (24,869) 138,505 Net cash provided by (used for) noncapital financing activities (118,426) (66,447) (24,869) 141,649 CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES: Proceeds from sale of assets 153,173 0 0 86 Acquisition of capital assets (1,158,954) 0 (1,123) (191,880) Net cash used for capital and related financing activities (1,005,781) 0 (1,123) (191,794) CASH FLOWS FROM INVESTING ACTIVITIES: Interest on investments 0 0 0 0 NET DECREASE IN CASH AND CASH EQUIVALENTS (81,017) (78,860) (40,706) (565,980) CASH AND CASH EQUIVALENTS AT BEGINNING OF YEAR 355,626 185,187 67,214 706,743 CASH AND CASH EQUIVALENTS AT END OF YEAR $ 274,609 $ 106,327 $ 26,508 $ 140,763 (100) Insurance TOTALS Fund PBX Fund 1992 1991 $ (667,692) $ 11,624 $ (1,274,422) $ (978,613) O 37,785 1,652,158 1,665,091 (26,223) 1,386 27,976 46,707 0 0 (14,401) (19,891) O (2,032) (85,853) (57,645) (5,980) 5,538 (151,109) 16,865 (4,354) 343 523 (107,556) _ 18,103 3 (286,143) 169,842 (18,454) 43,023 1,143,151 1,713,413 (686,146) 54,647 (131,271) 734,800 O (25,842) (25,842) (30,614) 602,736 0 602,736 640,892 192,894 0 192,894 0 40,390 0 60,391 90,405 (478,324) 149,024 (417,394) 460,000 357,696 123,182 412,785 1,160,683 0 0 153,259 118,041 0 (344,262) (1,696,219) (2,332,271) 0 (344,262) (1,542,960) (2,214,230) 49,523 0 49,523 53,365 (278,927) (166,433) (1,211,923) (265,382) 1,301,748 137,772 2,754,290 3,019,672 $ 1,022,821 $ (28,661) $ 1,542,367 $ 2,754,290 (101) COUNTY OF WELD STATE OF COLORADO INTERNAL SERVICE FUNDS MOTOR VEHICLE FUND Statement of Revenues, Expenses, and Changes in Retained Earnings Compared with Budget For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 Budget Actual Variance Actual OPERATING REVENUES: Charges for service $ 2,343,030 $ 2,203,914 $ (139,116) $ 2,162,279 Reimbursement for depreciation 1,226,013 1,234,425 8,412 1,236,608 Miscellaneous 0 643 643 370 TOTAL OPERATING REVENUES 3,569,043 3,438,982 (130,061) 3,399,257 OPERATING EXPENSES: Contractual services 1,407,050 1,506,116 (99,066) 1,447,314 Supplies 500,000 436,667 63,333 427,294 Repair and maintenance 208,544 233,820 (25,276) 231,312 Other 27,712 27,712 0 39,322 Depreciation 1,226,013 1,234,425 (8,412) 1,236,608 TOTAL OPERATING EXPENSES 3,369,319 3,438,740 (69,421) 3,381,850 OPERATING INCOME (LOSS) 199,724 242 (199,482) 17,407 NONOPERATING REVENUES: Rents from land 0 0 0 653 Gain on disposition of assets 225,000 149,110 (75,890) 323,532 Compensation for loss 0 0 0 13,353 TOTAL NONOPERATING REVENUES 225,000 149,110 (75,890) 337,538 INCOME (LOSS) BEFORE OPERATING TRANSFERS 424,724 149,352 (275,372) 354,945 OPERATING TRANSFERS - IN: Non-departmental 0 0 0 200,000 OPERATING TRANSFERS - OUT: Other (133,210) (133,210) 0 0 TOTAL OPERATING TRANSFERS (133,210) (133,210) 0 200,000 NET INCOME (LOSS) 291,514 16,142 (275,372) 554,945 RETAINED EARNINGS AT BEGINNING OF YEAR 1,614,619 1,614,619 0 1,059,674 RETAINED EARNINGS AT END OF YEAR $ 1,906,133 $ 1,630,761 $ (275,372) $ 1,614,619 (102) COUNTY OF WELD STATE OF COLORADO INTERNAL SERVICE FUNDS HEALTH INSURANCE FUND Statement of Revenues, Expenses, and Changes in Retained Earnings Compared with Budget For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 Budget Actual Variance Actual OPERATING REVENUES: Contributions $ 143,472 $ 126,947 $ (16,525) $ 131,637 OPERATING EXPENSES: Contractual services 17,000 663 16,337 24,475 Claims 126,472 116,932 9,540 200,227 Other 0 0 0 5,176 TOTAL OPERATING EXPENSES 143,472 117,595 25,877 229,878 OPERATING INCOME (LOSS) 0 9,352 9,352 (98,241) NONOPERATING REVENUES: Earnings on deposits 0 0 0 2,346 Cobra revenue 0 1,020 1,020 683 Recovery of losses 0 1,053 1,053 16,978 TOTAL NONOPERATING REVENUES 0 2,073 2,073 20,007 INCOME (LOSS) BEFORE OPERATING TRANSFERS 0 11,425 11,425 (78,234) OPERATING TRANSFERS - OUT: Other (68,520) (68,520) 0 0 NET INCOME (LOSS) (68,520) (57,095) 11,425 (78,234) RETAINED EARNINGS AT BEGINNING OF YEAR 157,301 157,301 0 235,535 RETAINED EARNINGS AT END OF YEAR $ 88,781 $ 100,206 $ 11,425 $ 157,301 (103) COUNTY OF WELD STATE OF COLORADO INTERNAL SERVICE FUNDS PRINTING AND SUPPLY FUND Statement of Revenues, Expenses, and Changes in Retained Earnings Compared with Budget For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 Budget Actual Variance Actual OPERATING REVENUES: Charges for service $ 162,214 $ 82,069 $ (80,145)$ 831 Sale of supplies 50,000 84,062 34,062 162,542 Other 0 0 0 12,100 TOTAL OPERATING REVENUES 212,214 166,131 (46,083) 175,473 OPERATING EXPENSES: Personnel services 43,706 41,217 2,489 37,846 Contractual services 12,775 18,714 (5,939) 16,214 Supplies 119,330 88,438 30,892 93,658 Repair and maintenance 32,127 31,592 535 27,483 Depreciation 4,300 175 4,125 144 TOTAL OPERATING EXPENSES 212,238 180,136 32,102 175,345 OPERATING INCOME (LOSS) (24) (14,005) (13,981) 128 OPERATING TRANSFERS - OUT: Printing/Supplies (24,869) (24,869) 0 0 NET INCOME (24,893) (38,874) (13,981) 128 RETAINED EARNINGS AT BEGINNING OF YEAR 54,416 54,416 0 54,288 RETAINED EARNINGS AT END OF YEAR $ 29,523 $ 15,542 $ (13,981)$ 54,416 (104) COUNTY OF WELD STATE OF COLORADO INTERNAL SERVICE FUNDS COMPUTER SERVICES FUND Statement of Revenues, Expenses, and Changes in Retained Earnings Compared with Budget For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 Budget Actual Variance Actual OPERATING REVENUES: Charges for services $ 2,380,094 $ 2,115,613 $ (264,481)$ 2,270,746 OPERATING EXPENSES: Personnel services 1,437,995 1,438,162 (167) 1,371,214 Contractual services 529,092 520,020 9,072 697,604 Supplies 118,711 115,812 2,899 96,602 Repair and maintenance 120,757 123,670 (2,913) 84,666 Other 152,169 152,169 0 180,007 Depreciation 386,203 379,723 6,480 382,421 TOTAL OPERATING EXPENSES 2,744,927 2,729,556 15,371 2,812,514 OPERATING LOSS (364,833) (613,943) (249,110) (541,768) NONOPERATING REVENUE: Miscellaneous 0 0 0 2,669 Gain/loss on sale of assets 0 86 86 (45,713) TOTAL NONOPERATING REVENUES 0 86 86 (43,044) INCOME (LOSS) BEFORE OPERATING TRANSFERS (364,833) (613,857) (249,024) (584,812) OPERATING TRANSFERS - IN: Non-departmental 400,000 400,000 0 260,000 OPERATING TRANSFERS - OUT: Data Processing (261,495) (261,495) 0 0 TOTAL OPERATING TRANSFERS 138,505 138,505 0 260,000 NET INCOME (LOSS) (226,328) (475,352) (249,024) (324,812) RETAINED EARNINGS AT BEGINNING OF YEAR 741,099 741,099 0 1,065,911 RETAINED EARNINGS AT END OF YEAR $ 514,771 $ 265,747 $ (249,024)$ 741,099 (105) COUNTY OF WELD STATE OF COLORADO INTERNAL SERVICE FUNDS INSURANCE FUND Statement of Revenues, Expenses, and Changes in Retained Earnings Compared with Budget For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 Budget Actual Variance Actual OPERATING REVENUES: Charges for services $ 76,660 $ 71,323 $ (5,337)$ 76,998 OPERATING EXPENSES: Contractual services 33,400 34,694 (1,294) 4,510 Supplies 1,500 0 1,500 0 Insurance and bonds 343,505 301,202 42,303 340,579 Claims 692,394 403,119 289,275 156,006 TOTAL OPERATING EXPENSES 1,070,799 739,015 331,784 501,095 OPERATING LOSS (994,139) (667,692) 326,447 (424,097) NONOPERATING REVENUE: General property tax 591,165 555,672 (35,493) 593,104 Specific ownership taxes 41,000 45,086 4,086 45,316 Penalties 6 interest 0 1,978 1,978 2,473 Earnings on deposits 40,000 49,523 9,523 51,019 Other 192,894 192,894 0 0 Compensation for loss 20,000 40,390 20,390 56,069 TOTAL NONOPERATING REVENUES 885,059 885,543 484 747,981 INCOME (LOSS) BEFORE OPERATING TRANSFERS (109,080) 217,851 326,931 323,884 OPERATING TRANSFERS - OUT: Other (478,324) (478,324) 0 0 NET INCOME (LOSS) (587,404) (260,473) 326,931 323,884 RETAINED EARNINGS AT BEGINNING OF YEAR 1,114,901 1,114,901 0 791,017 RETAINED EARNINGS AT END OF YEAR $ 527,497 $ 854,428 $ 326,931 $ 1,114,901 (106) COUNTY OF WELD STATE OF COLORADO INTERNAL SERVICE FUNDS PBX FUND Statement of Revenues, Expenses, and Changes in Retained Earnings Compared with Budget For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 1992 1992 1992 1991 Budget Actual Variance Actual OPERATING REVENUES: Charges for services $ 741,060 $ 558,887 $ (182,173)$ 548,558 OPERATING EXPENSES: Personnel services 102,180 101,031 1,149 95,206 Contractual services 317,000 328,182 (11,182) 266,238 Supplies 2,575 934 1,641 3,463 Repair and maintenance 59,504 55,052 4,452 45,166 Other 23,982 24,279 (297) 24,609 Depreciation 48,559 37,785 10,774 45,918 TOTAL OPERATING EXPENSES 553,800 547,263 6,537 480,600 OPERATING INCOME (LOSS) 187,260 11,624 (175,636) 67,958 NONOPERATING EXPENSES: - Interest (27,260) (25,842) 1,418 (30,614) INCOME (LOSS) BEFORE OPERATING TRANSFERS 160,000 (14,218) (174,218) 37,344 OPERATING TRANSFERS - IN: Non-Departmental 200,000 200,000 0 0 OPERATING TRANSFERS - OUT: PBX phone service (50,976) (50,976) 0 0 TOTAL OPERATING TRANSFERS 149,024 149,024 0 0 NET INCOME (LOSS) 309,024 134,806 (174,218) 37,344 RETAINED EARNINGS AT BEGINNING OF YEAR 80,798 80,798 0 43,454 RETAINED EARNINGS AT END OF YEAR $ 389,822 $ 215,604 $ (174,218)$ 80,798 (107) at, COLORADO (108) TRUST AND AGENCY FUNDS Trust and Agency Funds are established to record transactions relating to assets held by the County in the capacity of trustee, custodian or agent for individuals, governmental entities and non-public organizations. WI COLORADO COUNTY OF WELD STATE OF COLORADO TRUST AND AGENCY FUNDS EXPLANATIONS OF INDIVIDUAL FUNDS December 31, 1992 Pension Trust Fund: Weld County Retirement Fund: The Weld County Retirement Fund accounts for the defined benefit retirement pension plan which covers substantially all permanent, full- time employees of Weld County. Expendable Trust Funds: North Colorado Medical Center Trust Fund: This fund accounts for the revenue and related capital expenditures as required by the North Colorado Medical Center Board of Trustees, an autonomous board responsible for administering the operations of the hospital. Employee Flexible Spending Fund: 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 unreimbursed claims. Nonexpendable Trust Fund: Weld County Finance Corporation: This component unit functions solely to acquire real estate and construct buildings to lease to the County and others. Waste Services Trust Fund: This fund accounts for the interception and disposal of household hazardous waste to include encouraging recycling and proper handling of hazardous waste. Agency Funds: General Agency Fund: This fund accounts 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. Deferred Compensation Fund: This fund accounts for, and invests, the accumulation of voluntary employee contributions. Pursuant to Internal Revenue Code Section 457, the funds are the property of Weld County until such time as the employee terminates or otherwise qualifies for payment through the plan guidelines. Emergency Telephone Service: This fund accounts for the E-911 function in the County which serves all emergency agencies of the County. (109) COUNTY OF WELD STATE OF COLORADO TRUST AND AGENCY FUNDS COMBINING BALANCE SHEET December 31, 1992 With Comparative Amounts as of December 31, 1991 Pension Trust Expendable Trust Non-Expendable Trust Weld County North Colorado Employee Weld Retirement Medical Flexible Finance Waste Plan Trust Fund Spending Corporation Services ASSETS ASSETS: Cash and short-term investments $ 197,535 $ 665,358 $ 40,640 $ 458,615 $ 3,822 Investments 31,943,508 0 0 0 0 Accounts Receivables (net of allowance for uncollectibles) 370,835 2,407 77 0 1,300 Due from other County funds 131 0 0 0 0 Advances to other funds 0 0 0 140,856 0 Land 0 0 0 498,542 0 Buildings 0 0 0 2,941,908 0 Accumulated depreciation 0 0 0 (360,000) 0 TOTAL ASSETS $ 32,512,009 $ 667,765 $ 40,717 $ 3,679,921 . $ 5,122 LIABILITIES AND FUND BALANCES LIABILITIES: Accounts payable $ 126,945 $ 0 $ 7,338 $ 0 $ 5,080 Accrued liabilities 0 0 0 8,258 0 Due to other governments 0 0 0 0 0 Due to other County funds 0 0 33,379 0 0 Long term debt 0 0 0 3,404,756 0 Deferred compensation payable 0 0 0 0 0 Total Liabilities 126,945 0 40,717 3,413,014 5,080 FUND •ALANCES: Reserve for employee benefits 29,636,684 0 0 0 0 Unreserved 2,748,380 667,765 0 266,907 42 Total Fund Balances 32,385,064 667,765 0 266,907 42 TOTAL LIABILITIES AND FUND BALANCE $ 32,512,009 $ 667,765 $ 40,717 $ 3,679,921 $ 5,122 (110) Agency TOTALS General Payroll Deferred Emergency Agency Agency Compensation Telephone December 31 December 31 Fund Fund Fund Service 1992 1991 $ 3,063,628 $ 266,758 $ 0 $ 340,866 $ 5,037,222 $ 4,404,600 0 0 1,490,536 0 33,434,044 30,409,971 0 146 0 57,160 431,925 381,224 0 9,828 0 9,328 19,287 22,815 O 0 0 0 140,856 140,856 O 0 0 0 498,542 498,542 O 0 0 0 2,941,908 962,962 O 0 0 0 (360,000) (270,000) $ 3,063,628 $ 276,732 $ 1,490,536 $ 407,354 $ 42,143,784 $ 36,550,970 -- $ 25,912 $ 276,641 $ 0 $ 18,395 $ 460,311 $ 382,007 O 0 0 0 8,258 0 3,037,716 0 0 379,631 3,417,347 2,392,014 0 91 0 9,328 42,798 22,804 0 0 0 0 3,404,756 1,344,612 0 0 1,490,536 0 1,490,536 1,383,236 3,063,628 276,732 1,490,536 407,354 8,824,006 5,524,673 O 0 0 0 29,636,684 25,506,910 0 0 0 0 3,683,094 5,519,387 0 0 0 0 33,319,778 31,026,297 $ 3,063,628 $ 276,732 $ 1,490,536 $ 407,354 $ 42,143,784 $ 36,550,970 (111) COUNTY OF WELD STATE OF COLORADO TRUST AND AGENCY FUNDS PENSION TRUST FUND STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND BALANCES For The Year Ended December 31, 1992 With Comparative Actual Amounts For The Year Ended December 31, 1991 Weld County Retirement Plan 1992 1991 OPERATING REVENUES: Earnings on investments $ 2,081,605 $ 1,313,859 Contributions 2,367,690 2,066,582 Total Operating Revenues 4,449,295 3,380,441 OPERATING EXPENSES: Benefit payments 1,263,671 1,108,835 Refunds 373,280 290,815 Audit fees 2,000 2,000 Actuarial fees 62,581 68,047 Trustee fees 130,784 115,652 Other 9 4,532 Total Operating Expenses 1,832,325 1,589,881 NET INCOME 2,616,970 1,790,560 FUND BALANCE AT BEGINNING OF YEAR 29,768,094 27,977,534 FUND BALANCE AT END OF YEAR $ 32,385,064 $ 29,768,094 (112) COUNTY OF WELD STATE OF COLORADO TRUST AND AGENCY FUNDS ALL EXPENDABLE TRUST FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES For The Year Ended December 31, 1992 With Comparative Actual Amounts For The Year Ended December 31, 1991 North Colorado Employee Medical Center Flexible TOTALS Trust Fund Spending 1992 1991 REVENUES: Taxes $ 8 $ 0 $ 8 $ 146 Contributions 0 270,163 270,163 233,590 Earnings on investments 34,267 0 34,267 63,757 Total Revenues 34,275 270,163 304,438 297,493 EXPENDITURES: Claims 0 33,379 33,379 21,695 Reimbursements 408,276 236,784 645,060 476,610 Total Expenditures 408,276 270,163 678,439 498,305 EXCESS OF REVENUES OVER (UNDER) EXPENDITURES (374,001) 0 (374,001) (200,812) FUND BAT4NCES AT BEGINNING OF YEAR 1,041,766 0 1,041,766 1,242,578 FUND BALANCES AT END OF YEAR $ 667,765 $ 0 $ 667,765 $ 1,041,766 (113) COUNTY OF WELD STATE OF COLORADO TRUST AND AGENCY FUNDS ALL NON-EXPENDABLE TRUST FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND BALANCES ALL NON-EXPENDABLE TRUST FUNDS For the Year Ended December 31, 1992 With Comparative Actual Amounts For the Year Ended December 31, 1991 Weld Finance Waste TOTALS Corporation Services 1992 1991 REVENUES: CHARGES FOR SERVICES: Rents from buildings $ 233,876 $ 0 $ 233,876 $ 323,927 Other 2,136 0 2,136 2,022 Total Charges for Services 236,012 0 236,012 325,949 MISCELLANEOUS: Earnings on deposits 26,938 42 26,980 17,936 TOTAL REVENUES 262,950 42 262,992 343,885 EXPENSES: CONTRACTUAL SERVICES: Other 24,374 0 24,374 2,040 DEPRECIATION: Other 90,000 0 90,000 105,850 DEBT SERVICE: Other 98,107 0 98,107 106,665 TOTAL EXPENSES 212,481 0 212,481 214,555 NET INCOME 50,469 42 50,511 129,330 FUND '4IANCE AT BEGINNING OF YEAR 216,438 0 216,438 346,343 Residual Equity Transfer 0 0 0 (259,235) FUND BALANCE AT END OF YEAR $ 266,907 $ 42 $ 266,949 $ 216,438 (114) COUNTY OF WELD STATE OF COLORADO NON-EXPENDABLE TRUST FUNDS COMBINING STATEMENT OP CASH FLOWS For the Year Ended December 31, 1992 -- With Comparative Amounts For The Year Ended December 31, 1991 Weld Finance Waste Totals Corporation Services 1992 1991 CASH FLAWS FROM OPERATING ACTIVITIES: Operating income $ 121,638 $ 0 $ 121,638 $ 218,059 Adjustments to reconcile operating income __, to net cash provided by operating activities: Depreciation 90,000 0 90,000 105,850 Change in assets and liabilities: (Increase) decrease in accounts receivable 0 (1,300) (1,300) 0 Increase (decrease) in accounts payable 0 5,080 5,080 0 Increase (decrease) in accrued liabilities 8,258 0 8,258 0 Total adjustments 98,258 3,780 102,038 105,850 Net cash provided by operating activities: 219,896 3,780 223,676 323,909 CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES: Interest paid on borrowings (117,963) 0 (117,963) (106,924) Principal paid on long-term debt (160,000) 0 (160,000) (240,000) Proceeds from issuance of long-term debt (C.O.P.'s) 2,240,000 0 2,240,000 0 Net cash provided by (used for) noncapital financing activities 1,962,037 0 1,962,037 (346,924) CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES: Acquisition of capital assets/C.O.P proceeds - to Capital Expenditures fund (1,978,946) 0 (1,978,946) 0 Net cash used for capital and related financing activities (1,978,946) 0 (1,978,946) 0 CASH FLOWS FROM INVESTING ACTIVITIES: Interest on investments 26,938 42 26,980 17,936 NET INCREASE (DECREASE) IN CASH AND CASH EQUIVALENTS 229,925 3,822 233,747 (5,079) CASH AND CASH EQUIVALENTS AT BEGINNING OF YEAR 228,690 0 228,690 233,769 CASH AND CASH EQUIVALENTS AT END OF YEAR $ 458,615 $ 3,822 $ 462,437 $ 228,690 (115) COUNTY OF WELD STATE OF COLORADO COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES ALL AGENCY FUNDS For the Year Ended Decmember 31, 1992 Balance Balance GENERAL AGENCY FUND 1/01/92 Additions Deductions 12/31/92 ASSETS: Cash $ 2,208,737 $243,952,684 $243,097,793 $ 3,063,628 LIABILITIES: Accounts payable $ 23,372 $ 24,178 $ 21,638 $ 25,912 Due to other governments 2,185,365 243,928,506 243,076,155 3,037,716 TOTAL LIABILITIES $ 2,208,737 $243,952,684 $243,097,793 $ 3,063,628 PAYROLL AGENCY FUND ASSETS: Cash $ 243,157 $ 25,206,681 $ 25,183,080 $ 266,758 Due from other County funds 22,815 32,648 45,635 9,828 Accounts receivable 0 146 0 146 TOTAL ASSETS $ 265,972 $ 25,239,475 $ 25,228,715 $ 276,732 LIABILITIES: Accounts payable $ 265,640 $ 25,238,765 $ 25,227,764 $ 276,641 Due to other County funds 332 710 951 91 TOTAL LIABILITIES $ 265,972 $ 25,239,475 $ 25,228,715 $ 276,732 DEFERRED COMPENSATION FUND ASSETS: Investments $ 1,383,236 $ 172,515 $ 65,215 $ 1,490,536 LIABILITIES: Deferred compensation payable $ 1,383,236 $ 172,515 $ 65,215 $ 1,490,536 EMERGENCY TELEPHONE SERVICE ASSETS: Cash $ 178,896 $ 367,251 $ 205,281 $ 340,866 Due from other County funds 0 16,895 7,567 9,328 Accounts Receivable 28,443 84,200 55,483 57,160 TOTAL ASSETS $ 207,339 $ 468,346 $ 268,331 $ 407,354 LIABILITIES: Accounts payable $ 0 $ 18,395 $ 0 $ 18,395 Due to other governments 206,649 266,947 93,965 379,631 Due to other County funds 690 183,004 174,366 9,328 TOTAL LIABLITIES $ 207,339 $ 468,346 $ 268,331 $ 407,354 TOTAL - ALL AGENCY FUNDS ASSETS - Cash $ 2,630,790 $269,526,616 $268,486,154 $ 3,671,252 Investments 1,383,236 172,515 65,215 1,490,536 Accounts receivable 28,443 84,346 55,483 57,306 Due from other County funds 22,815 49,543 53,202 19,156 TOTAL ASSETS $ 4,065,284 $269,833,020 $268,660,054 $ 5,238,250 LIABILITIES Accounts payable $ 289,012 $ 25,281,338 $ 25,249,402 $ 320,948 Due to other governments 2,392,014 244,195,453 243,170,120 3,417,347 Due to other County funds 1,022 183,714 175,317 9,419 Deferred compensation payable 1,383,236 172,515 65,215 1,490,536 TOTAL LIABILITIES $ 4,065,284 $269,833,020 $268,660,054 $ 5,238,250 (116) GENERAL FIXED ASSETS ACCOUNT GROUP Investments in property and equipment, except for those of the Internal Service Funds, are recorded in this account group. cir .4,1147 WI`'D COLORADO COUNTY OF WELD STATE OF COLORADO GENERAL FIXED ASSETS ACCOUNT GROUP SCHEDULE OF GENERAL FIXED ASSETS - BY SOURCE December 31, 1992 With Comparative Totals as of December 31, 1991 1992 1991 GENERAL FIXED ASSETS: Land $ 3,040,338 $ 3,088,834 Buildings 20,483,259 20,285,481 Improvements other than buildings 410,154 393,290 Machinery and equipment 5,317,893 4,451,851 Construction in progress 161,590 778,899 TOTAL ASSETS $ 29,413,234 $ 28,998,355 INVESTMENTS IN GENERAL FIXED ASSETS FROM: $ 19,632,287 $ 19,149,154 Current revenue Gifts and grants 1,831,832 1,900,086 Federal revenue sharing 7,949,115 7,949,115 TOTAL INVESTMENT IN GENERAL FIXED ASSETS $ 29,413,234 $ 28,998,355 (117) COUNTY OF WELD STATE OF COLORADO GENERAL FIXED ASSETS SCHEDULE OF GENERAL FIXED ASSETS - BY FUNCTION AND ACTIVITY December 31, 1992 With Comparative Totals by Function at December 31, 1991 Land Equipment & Construction TOTALS Land Improvements Buildings Furniture In Progress 1992 1991 GENERAL GOVERNMENT: County Commissioners $ 0$ 0$ 0$ 17,099$ 0$ 17,099$ 18,011 Clerk to the Board 0 0 0 25,861 0 25,861 28,874 County Attorney 0 0 0 6,287 0 6,287 6,287 Planning and zoning 0 0 0 6,808 0 6,808 9,905 General accounting 0 0 0 2,122 0 2,122 2,932 Financial administration 0 0 0 3,727 0 3,727 3,727 County Clerk 0 0 0 339,835 0 339,835 347,145 Elections and registration 0 0 0 17,755 0 17,755 19,983 County Treasurer 0 0 0 32,001 0 32,001 21,391 County Assessor 0 0 0 43,386 0 43,386 40,065 County Council 0 0 0 1,207 0 1,207 1,207 Personnel 0 0 0 5,408 0 5,408 5,408 Maintenance of buildings/grounds 0 0 0 48,203 0 48,203 50,205 Communications services 0 0 0 1,950,233 0 1,950,233 1,885,631 Purchasing 0 0 0 172,299 0 172,299 155,299 Other 0 0 0 85,291 0 85,291 86,890 Buildings 2,648,030 144,115 16,466,045 91,703 0 19,349,893 19,208,930 Total General Government 2,648,030 144,115 16,466,045 2,849,225 0 22,107,415 21,891,890 JUDICIAL: District Attorney 0 0 0 36,767 0 36,767 34,448 PUBLIC SAFETY: Sheriff administration 0 0 0 285,827 0 285,827 270,714 Task force 0 0 0 13,796 0 13,796 9,717 County Coroner 0 0 0 5,060 0 5,060 3,344 Building inspection 0 0 0 621 0 621 621 Office of emergency management 0 0 0 44,018 0 44,018 44,018 Total Public Safety 0 0 0 349,322 0 349,322 328,414 HEALTH AND HOSPITALS: Health 162,369 15,068 135,232 165,651 0 478,320 469,602 Ambulance services 0 7,513 118,599 6,037 0 132,149 197,334 Total Health and Hospitals 162,369 22,581 253,831 171,688 0 610,469 666,936 COUNTY ROADS AND HIGHWAYS: Highways and streets 0 11,668 0 71,138 0 82,806 78,612 PUBLIC WELFARE: Public welfare (social services) 170,318 12,630 780,137 219,377 0 1,182,462 1,156,817 AUXILIARY SERVICES: Extension service 200 0 770,575 11,929 0 782,704 782,704 Exhibition building 0 91,071 225,897 22,014 0 338,982 338,982 Veterans office 0 0 0 747 0 747 747 Missile site park 0 91,310 0 60,384 0 151,694 120,432 Delinquents & other institutions 0 0 74,502 626 0 75,128 59,198 Crime control and investigation 0 0 1,440 0 0 1,440 1,440 Libraries 19,207 8,395 1,177,219 589,329 161,590 1,955,740 1,731,894 JTPA technical assistance 40,214 28,384 733,613 925,007 0 1,727,218 1,795,501 General administration 0 0 0 10,340 0 10,340 10,340 Total Auxiliary Services 59,621 219,160 2,983,246 1,620,376 161,590 5,043,993 4,841,238 TOTAL GENERAL FIXED ASSETS ALLOCATED TO FUNCTIONS $ 3,040,338 $ 410,154 $20,483,259 $ 5,317,893 $ 161,590 $29,413,234 $28,998,355 (118) COUNTY OF WELD STATE OF COLORADO GENERAL FIXED ASSETS SCHEDULE OF CHANGES IN GENERAL FIXED ASSETS - BY FUNCTION AND ACTIVITY — For the Year Ended December 31, 1992 General General Fixed Assets Fixed Assets 12/31/91 Additions Deletions 12/31/92 GENERAL GOVERNMENT: County Commissioners $ 18,011 $ 1,950$ 2,862E 17,099 Clerk to the Board 28,874 0 3,013 25,861 County Attorney 6,287 0 0 6,287 Planning and zoning 9,905 990 4,087 6,808 General accounting 2,932 0 810 2,122 Financial administration 3,727 0 0 3,727 County Clerk 347,145 3,574 10,884 339,835 Elections and registration 19,983 0 2,228 17,755 Caunty Treasurer 21,391 22,779 12,169 32,001 County Assessor 40,065 3,321 0 43,386 County Council 1,207 604 604 1,207 Personnel 5,408 0 0 5,408 Maintenance of buildings/grounds 50,205 1,808 3,810 48,203 Communications services 1,885,631 819,621 755,019 1,950,233 Purchasing 155,299 17,000 0 172,299 Other 86,890 11,951 13,550 85,291 Buildings 19,208,930 195,915 54,952 19,349,893 Total General Government 21,891,890 1,079,513 863,988 22,107,415 JUDICIAL: District Attorney 34,448 2,823 504 36,767 PUBLIC SAFETY: Sheriff administration 270,714 30,894 15,781 285,827 Task force 9,717 4,079 0 13,796 County Coroner 3,344 1,716 0 5,060 Building inspection 621 0 0 621 Office of emergency management 44,018 0 0 44,018 Total Public Safety 328,414 36,689 15,781 349,322 HEALTH AND HOSPITALS; Health 469,602 8,718 0 478,320 Ambulance services 197,334 627 65,812 132,149 Total Health and Hospitals 666,936 9,345 65,812 610,469 COUNTY ROADS AND HIGHWAYS: Highways and streets 78,612 5,401 1,207 82,806 PUBLIC WELFARE: Public welfare (social services) 1,156,817 26,520 875 1,182,462 AUXILIARY SERVICES: Extension service 782,704 0 0 782,704 Exhibition building 338,982 0 0 338,982 Veterans office 747 0 0 747 Missile site park 120,432 31,262 0 151,694 Delinquents 6 other institutions 59,198 15,930 0 75,128 Crime control and investigation 1,440 0 0 1,440 Libraries 1,731,894 229,696 5,850 1,955,740 JTPA technical assistance 1,795,501 156,814 225,097 1,727,218 General administration 10,340 0 0 10,340 Total Auxiliary Services 4,841,238 433,702 230,947 5,043,993 TOTAL GENERAL FIXED ASSETS Aii.00ATED TO FUNCTIONS $ 28,998,355 $ 1,593,993 $ 1,179,114 $29,413,234 (119) if a ape COLORADO (120) GENERAL LONG-TERM DEBT ACCOUNT GROUP Sick and vacation accrual for Governmental Fund types are recorded in this fund. } � C COLORADO COUNTY OF WELD STATE OF COLORADO GENERAL LONG-TERM DEBT ACCOUNT GROUP SCHEDULE OF GENERAL LANG-TERM DEBT December 31, 1992 With Comparative Amounts as of December 31, 1991 1992 1991 AMOUNTS TO BE PROVIDED FOR RETIREMENT OF GENERAL LANG-TERM DEBT $ 1,288,645 $ 1,383,899 LIABILITIES: Special assessment bonds payable $ 200,000 $ 300,000 Vacation and sick-leave accrual 1,088,645 1,057,958 Phone system capital lease 0 25,941 TOTAL GENERAL LONG-TERM DEBT $ 1,288,645 $ 1,383,899 (121) 1119 €. COLORADO (122) STATISTICAL SECTION WI`'p OLORADO COUNTY OF WELD STATE OF COLORADO Tables Relating to Bonded Debt (Unaudited) December 31, 1992 NOTE: Weld County is without bonded debt and, accordingly, the following statistical tables are not presented: A. Ratio of Net General Bonded Debt to Assessed Value and Net Bonded Debt Per Capita - Last Ten Years B. Ratio of Annual Debt Service for General Bonded Debt to Total General Expenditures - Last Ten Years C. Revenue Bond Coverage - Last Ten Years (123) COUNTY OF WELD STATE OF COLORADO General Governmental Expenditures by Function (Unaudited) Last Ten Years County Public General Public Roads & Health & Year Government Safety Highways Welfare 1983 $ 5,725,137 $ 5,575,881 $ 7,716,877 $13,961,545 1984 $ 6,082,536 $ 6,294,660 $ 8,136,114 $13,799,706 1985 $ 6,120,744 $ 7,283,096 $ 8,547,979 $13,748,609 1986 $ 6,516,851 $ 7,272,935 $ 8,505,739 $14,660,502 1987 $ 6,819,165 $ 6,924,599 $ 9,876,346 $14,789,034 1988 $ 7,251,985 $ 7,869,950 $ 8,292,283 $20,156,719 1989 $ 7,244,820 $ 8,607,683 $10,371,933 $20,693,130 1990 $ 8,112,753 $ 9,749,362 $11,147,191 $23,641,401 1991 $ 8,780,727 $10,804,861 $11,412,048 $26,818,985 1992 $ 8,848,738 $11,321,924 $11,949,512 $28,990,392 General Revenue by Source (Unaudited) Last Ten Years Licenses Intergovernmental Year Taxes and Permits Revenue 1983 $ 14,467,200 $ 635,645 $ 18,679,901 1984 $ 15,932,964 $ 669,934 $ 19,284,616 1985 $ 16,308,828 $ 716,130 $ 19,890,173 1986 $ 17,888,662 $ 581,360 $ 20,720,989 1987 $ 18,846,835 $ 613,026 $ 20,789,309 1988 $ 19,614,179 $ 575,744 $ 27,359,869 1989 $ 21,192,869 $ 608,224 $ 29,296,166 1990 $ 22,300,072 $ 597,294 $ 34,488,199 1991 $ 23,867,746 $ 647,634 $ 37,805,169 1992 $ 24,962,031 $ 840,856 $ 40,185,683 (124) Auxiliary Debt Intragovernmental Total Services* Capital Outlay Service Expenditures Miscellaneous Expenditures $ 3,856,846 $ 379,684 $ 2,274 $ 431,789 $ 685,246 $ 3,954 896 $ 38,335,279 � $ 1,347,365 $1,018,741 $ 415,102 $ 1,074,232 $ 42,123,352 $ 4,596,197 $ 1,515,560 $ 88,500 $ 465,517 $ 1,647,115 $ 44,013,317 $ 4,234,193 $ 1,397,988 $ 252,753 $ 488,119 $ 1,401,846 $ 44,730,926 $ 4,735,582 $ 1,637,272 $ 200,263 $ 594,982 $ 3,550,550 $ 49,127,728 $ 6,261,841 $ 3,740,305 $ 242,953 $ 720,201 $ 7,194,666 $ 2,126,620 $ 467,344 2,251,269 56,787,506 $ 788,412 $$ 1,987,768 $$ 59,482,376 $ 8,528,763 $ 679,565 $ 485,929 $ 741,208 $ 1,713,701 $ 64,799,873 $ 7,761,470 $ 2,164,396 $ 461,193 $ 810,111 $ 1,129,079 $ 70,142,870 $ 8,990,997 $ 2,433,516 $ 199,944 $ 809,896 $ 1,305,009 $ 74,849,928 *Auxiliary Services includes culture and recreation, conservation of natural resources, and economic assistance. General governmental expenditures include expenditures of General, Special Revenue, Capital Projects, and Expendable Trust Funds. Charges for Fines and Miscellaneous Services Forfeitures Revenue Fees Total Revenue $ 1,406,359 $ 26,667 $ 2,543,940 $ 1,305,116 $ 39,064,828 $ 1,541,520 $ 37,592 $ 3,948,342 $ 1,533,455 $ 42,948,423 $ 1,673,283 $ 78,261 $ 3,756,703 $ 1,631,937 $ 44,055,315 $ 1,742,650 $ 67,198 $ 3,775,144 $ 1,680,356 $ 46,456,359 _. $ 1,149,717 $ 76,465 $ 5,915,868 $ 1,711,894 $ 49,103,114 $ 1,632,229 $ 35,469 $ 5,552,233 $ 1,693,026 $ 56,462,749 $ 1,952,168 $ 66,635 $ 4,977,219 $ 1,896,373 $ 59,989,654 $ 2,102,201 $ 66,941 $ 4,502,642 $ 2,221,264 $ 66,278,613 $ 1,975,095 $ 56,652 $ 4,121,565 $ 2,473,394 $ 70,947,255 $ 2,410,988 $ 34,275 $ 3,443,564 $ 2,490,909 $ 74,368,306 General revenue includes revenue of General, Special Revenue, Capital Projects and Expendable Trust Funds. (125) COUNTY of WELD STATE OF COLORADO Property Value, Construction. Bank Deposits and Other Economic Indicators (Unaudited) Last Eight Years 1985 1986 1987 1988 1989 1990 1991 1992 Property Value - estimated actual value (millions)$ 4,133.7 $ 4,225.0 $ 5,281.1 $ 5,777.3 $ 5,771.6 $5,572.7 $ 6,273.9 $ 6,291.6 (3) Building Permits 2,519 2,113 2,131 1,836 1,999 1,670 1,923 2,020 (2) Estimated Construction (millions) $ 37.7 $ 34.9 $ 36.7 $ 30.2 $ 33.0 $ 32.5 $ 42.0 $ 42.0 (2) Bank Deposits (millions) $ 985.4 * $ 676.3 $ 693.3 $ 753.7 $ 756.9 $ 905.1 $ * (1) Retail Sales (millions) $ 1.118.0 $ 1,044.1 $ 1,503.8 $ 1,649.8 $ 1,711.1 $1,744.9 $ 2,282.0 $ * (1) Value of Crop Production (millions) $ 191.0 * $ 864.6 * * * * $ * (1) * Information not available. Data Sources: (1) EDAP - Greeley/Weld Econimic Development Action Partnership. (2) Weld County Planning and Building Inspection Departments. (3) Weld County Comprehensive Annual Financial Report (126) COUNTY OF WELD STATE OF COLORADO Property Tax Levies and Collections (Unaudited) Last Ten Years Total Total Current Percent Delinquent Total Outstanding Levy Collection Original Tax Tax of Levy Tax Tax Delinquent Year Year Levy Collections Collected Collections Collections Taxes 1982 1983 $ 14,399,734 $ 14,307,719 99.36 $ 97,625 $ 14,405,344 $154,546 1983 1984 $ 15,119,720 $ 14,985,503 99.11 $131,428 $ 15,116,931 $212,504 1984 1985 $ 15,875,706 $ 15,469,833 97.44 $ 28,931 $ 15,498,764 $307,203 1985 1986 $ 17,147,925 $ 17,013,025 99.20 $ 84,065 $ 17,097,090 $404,559 1986 1987 $ 18,005,273 $ 17,756,037 98.60 $296,802 $ 18,052,839 $439,749 1987 1988 $ 18,931,528 $ 18,506,143 97.75 $ 66,022 $ 18,572,165 $376,500 1988 1989 $ 20,534,080 $ 20,153,920 98.15 $ 61,419 $ 20,215,339 $420,669 1989 1990 $ 21,336,977 $ 21,037,446 98.60 $ 87,901 $ 21,125,347 $862,040 (3) 1990 1991 $ 22,459,831 $ 22,228,600 98.97 $311,671 $ 22,540,271 $886,342 (3) 1991 1992 $ 23,752,395 $ 23,608,438 99.39 $104,726 $ 23,713,164 $968,201 (3) Assessed and Estimated Actual Value of Taxable Property (Unaudited) Last Ten Years Real Property (1) Personal Property (2) Total Levy Assessed Estimated Assessed Estimated Assessed Estimated Year Value Actual Value Value Actual Value Value(4) Actual Value 1983 $ 778,637,950 $3,707,799,761 $ 91,815,550 $ 316,605,345 $ 870,453,500 $4,024,405,106 1984 $ 764,916,130 $3,642,457,761 $ 55,831,700 $ 192,523,103 $ 820,747,830 $3,834,980,864 1985 $ 819,535,750 $3,902,551,190 $ 67,028,500 $ 231,132,759 $ 886,564,250 $4,133,683,949 1986 $ 836,455,500 $3,983,121,428 $ 70,154,400 $ 241,911,724 $ 906,609,900 $4,225,033,152 1987 $ 899,649,790 $4,998,054,388 $ 82,078,810 $ 283,030,379 $ 981,728,600 $5,281,084,767 1988 $ 876,322,790 $5,477,017,437 $ 87,082,300 $ 300,283,793 $ 963,405,090 $5,777,301,230 1989 $ 815,536,790 $5,436,911,933 $ 97,066,530 $ 334,712,172 $ 912,603,320 $5,771,624,105 1990 $ 807,052,260 $5,627,979,497 $ 99,979,210 $ 344,755,897 $ 907,031,470 $5,972,735,394 — 1991 $ 845,519,470 $5,896,230,613 $ 109,525,160 $ 377,672,966 $ 955,044,630 $6,273,903,579 1992 $ 820,834,330 $5,920,106,973 $ 135,566,770 $ 370,544,000 $ 956,401,100 $6,291,650,973 (1) Residential improved land and improvements at 14.34% of 1989 to June 30, 1990 replacement costs, as determined by State law. (2) Commercial improved land, improvements, and personal property at 29% of 1989 to June 30, 1990 replacement costs, as determined by State law. (3) Total includes audit of oil and gas values understated by producers in 1990. (4) State assessed value is deducted from total assessed value as state property is not taxable. (127) COUNTY OF WELD STATE OF COLORADO Property Tax Rates and Tax Levies - Direct and Overlapping Governments (Unaudited) Last Ten Years Levy Collection School Junior Year Year Cities Districts County College Other Tax Levies 1982 1983 461.220 866.16 17.172 4.292 151.450 1983 1984 490.320 880.14 17.369 4.581 161.059 1984 1985 542.320 918.63 19.342 5.037 171.923 1985 1986 537.259 977.76 19.342 4.981 164.277 1986 1987 571.268 953.48 19.968 5.198 203.204 1987 1988 391.248 722.89 17.208 4.542 204.292 1988 1989 445.334 739.67 19.268 5.150 224.839 1989 1990 543.439 770.24 20.892 5.325 198.943 1990 1991 531.572 741.70 22.209 5.918 242.827 1991 1992 587.791 762.50 22.457 5.993 252.237 Tax Revenues 1982 1983 $4,016,593 $37,913,573 $14,399,734 $3,686,486 $3,769,629 1983 1984 $4,125,777 $41,076,321 $15,118,907 $3,458,802 $3,960,714 1984 1985 $4,210,650 $42,366,353 $15,874,905 $3,631,540 $3,942,837 1985 1986 $4,551,381 $48,835,173 $17,147,925 $3,918,961 $5,736,561 1986 1987 $4,744,921 $52,125,601 $18,103,186 $4,232,066 $6,196,320 1987 1988 $4,895,718 $46,369,646 $18,931,528 $4,507,157 $6,626,435 1988 1989 $5,273,090 $46,746,481 $20,534,080 $4,905,770 $6,884,119 1989 1990 $5,644,875 $46,894,420 $21,336,977 $4,939,571 $6,929,833 1990 1991 $5,838,481 $45,723,479 $22,459,831 $5,449,422 $7,356,376 1991 1992 $6,107,177 $48,665,910 $23,752,395 $5,760,833 $7,747,251 The basis for the property tax rates is per $1,000 assessed valuation. (128) COUNTY OF WELD STATE OF COLORADO Special Assessment Collections (Unaudited) -- Last Ten Years Current Current Ratio of Total Assessments Assessments Collections Outstanding Year Due Collected To Amount Due Assessments 1983 $ 4,098 $ 4,098 100% $ 10,256 1984 $ 1,282 $ 1,282 100% $ 8,974 1985 (1) $ 2,236 $ 2,236 100% $1,006,738 1986 (2) $ 102,009 $102,009 100% $ 931,759 1987 (3) $ 111,543 $111,543 100% $ 827,272 1968 (4) $ 132,170 $132,170 100% $ 864,373 1989 (5) $ 143,626 $143,626 100% $ 914,708 1990 (6) $ 194,773 $194,773 100% $ 794,535 1991 (7) $ 188,602 $188,602 100% $ 742,081 1992 (8) $ 521,076 $521,076 100% $ 628,605 NOTES: (1) Road 5 Special Assessment of $1,000,000. (2) Antelope Hills Special Assessment of $27,030. (3) Indianhead Special Assessment of $7,056. (4) Northmoor Special Assessment of $94,272. -- (5) Antelope Hills Special Assessment 2 of $16,000. Casa Grande/Enchanted Hills Special Assessment of $150,473. Knaus Special Assessment of $27,488. (6) 71st Avenue Special Assessment of $74,600. (7) Basswood Special Assessment of $11,508. Eighty-third Avenue Special Assessment of $124,640. (8) Roads 15 6 84 Special Assessment of $357,600. Weld County Road 34 Special Assessment $25,000. Weld County Road 32 Special Assessment $25,000. (129) COUNTY OF WELD STATE OF COLORADO Computation of Legal Debt Margin (Unaudited) December 31, 1992 Assessed Value, 1991 $1,058,635,600 Debt Limit 3 Percent of Assessed Value 31,759,068 Amount of Debt Applicable to Limit: Total Bonded Debt $ 0 Installment Purchase Agreements 0 Total Amount of Debt Applicable to Debt Limit 0 Legal Debt Margin $ 31,759,068 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 assessed valuation of all taxable property. (130) COUNTY OF WELD STATE OF COLORADO DEMOGRAPHIC STATISTICS (Unaudited) December 31, 1992 1. Population: 1970 - 89,297 1975 - 111,901 1980 - 123,438 1983 - 132,513 1984 - 131,746 1985 - 133,922 1986 - 139,947 1988 - 145,312 1990 - 131,821 1992 - 138,496 2. Estimated Median Age: 26.7 (1980 Census) 28.5 (1983) 26.7 (1984) 27.8 (1985) 30.5 (1990 Census) 3. Total Personal Income For Years Available: 1972 - $ 380,534,000 1973 - $ 481,301,000 1974 - $ 539,833,000 1975 - $ 597,099,000 1980 - $1,059,311,000 1982 - $1,317,000,000 1984 - $1,317,329,000 1988 - $1,810,807,000 1989 - $1,943,331,000 4. Per Capita Income For Years Available: 1973 - $ 4,666 1974 - $ 5,054 1975 - $ 5,543 1977 - $ 5,081 1980 - $ 6,505 1982 - $10,411 1984 - $11,501 1988 - $13,296 1989 - $14,230 1990 - $15,874 5. Median Family Income $15,805 (1980 Census) $22,921 (1983) $21,286 (1984) $30,800 (1990 Census) 6. Population Per Household 1970 - 3.09 1980 - 2.79 1983 - 2.75 1984 - 2.79 1990 - 2.697 7. Housing Units 1970 - 28,896 1980 - 46,475 1983 - 46,059 1984 - 49,538 1990 - 47,566 Source: Greeley/Weld Economic Development Office (EDAP) (131) COUNTY OF WELD STATE OF COLORADO Principal Taxpayers (Unaudited) December 31, 1992 Per Cent 1992 Of Total Assessed Assessed Valuation Valuation Eastman Kodak Company $ 69,691,650 6.58% Public Service of Colorado 28,994,800 2.73% National Hog Farms Inc 9,270,880 .88% Metal Container Corp 7,495,730 .77% AT&T 6,499,200 .61% Panhandle Eastern Pipeline 6,159,200 .58% Hewlett Packard 6,039,460 .57% Golden Aluminum Co 4,032,320 .38% Mc Lane Western Inc 4,009,540 .38% Macerick Greeley Associates 3,691,920 .35% 145,884,700 13.83% (132) COUNTY OF WELD STATE OF COLORADO Miscellaneous Statistics (Unaudited) December 31, 1992 1. Date of Incorporation: 1861 2. Form of Government: Home Rule Charter 3. Date Present Charter Adopted January 1, 1976 4. Area - Square Miles: 4,004 square miles -- 5. County Seat: City of Greeley 6. Employees as of December 31, 1991 Elected Officials - 16 Division Heads - 5 Department Heads - 15 Employees with Benefits - 831 Employees without Benefits - 176 7. Miles of Roads: Paved - 614.42 Unpaved - 2,650.22 Unmaintained - 353.10 8. Building Permits: No. of Year Permits Valuation 1983 2,699 $ 51,480,002 1984 2,450 $ 44,854,598 1985 2,519 $ 37,423,180 1986 2,113 $ 34,964,831 1987 2,131 $ 36,787,917 1988 1,836 $ 30,195,777 1989 1,999 $ 33,060,864 1990 1,670 $ 32,463,224 1991 1,923 $ 32,565,265 1992 2,020 $ 42,051,597 9. Motor Vehicle Registration: 1983 - 132,458 1984 - 139,521 1985 - 136,444 1986 - 142,204 1987 - 140,445 1988 - 139,743 1989 - 166,937 1990 - 168,921 1991 - 173,967 1992 - 177,298 10. Special Districts within County: 30 - Cities and Towns 17 - Schools 23 - Fire 19 - Water A Other 2 - Colleges 13 - Sanitation 11. Cities and Towns: Ault Garden City Longmont Brighton Gilcrest Mead Broomfield Greeley Milliken Dacono Grover Northglenn Eaton Hudson Nunn Erie Johnstown Pierce Evans Keenesburg Platteville Firestone Kersey Raymer Frederick LaSalle Severance Ft. Lupton Lochbuie Windsor 12. Recreation: Golf Courses - 6 City and Regional Parks Island Grove Recreational Complex Greeley Recreation Center (133) COUNTY OF WELD STATE OF COLORADO Miscellaneous Statistics - Continued (Unaudited) December 31, 1992 13. Libraries: Ault Town Library 9,000 Volumes Eaton Library 10.000 Volumes Glenn A. Jonas Library 12,000 Volumes Greeley Library 102,064 Volumes Platteville Library 13,000 Volumes University of No. Colo. 901,000 Volumes Weld Library District 188,120 Volumes Windsor Public Library 25,072 Volumes 14. Elections: Number of Number Percent of Registered of Votes Registered Voters Cast Voters Voting 1974 General Election 45,175 30,002 66.4 1976 General Election 49,785 41,184 82.7 1978 General Election 47,832 29,818 62.3 1980 General Election 51,107 44,134 86.3 1982 General Election 51,476 36,301 70.5 1984 General Election 56,311 47,632 84.6 1986 General Election 62,725 38,488 61.1 1988 General Election 70,325 50,209 71.4 1990 General Election 68,148 37,927 55.6 1992 General Election 68,079 55,041 80.8 15. Media Newspapers: The Greeley Tribune Town & Country News Aims College World The Mirror (UNC) North Weld Herald Farmer & Miner Keene Valley Sun Johnstown Breeze Ft. Lupton Press Platteville Herald Windsor Beacon Erie Echo Ft. Morgan Times LaSalle Leader Platte Valley Voice The Centennial News Radio Stations: KFKA/K-SKY KATE KGRE KVVS KUAD AM & FM KMNC KUNC FM Television: Receives commercial and public television originating from both Denver and Cheyenne stations; also cable television. 16. Sales Tax as of December 31, 1992: State - 3% Source: Weld County offices. Individual Libraries (134) COUNTY OF WELD STATE OF COLORADO Insurance In Force (Unaudited) December 31, 1992 Policy Period Details of Annual Name of Company Policy Number Begins Expires Coverage Liability Limits Premiums National Union Fire Insurance Co 4153175 01/01/92 12/13/92 Excess Worker's Employer's Liability Compensation $1,000,000/Accident Workers Compensation -- Statutory Limits with County Retaining First $300,000 each claim $ 34,000 Travelers Ins. 07/01/92 06/30/93 $50,000,000/Accident Company M5J660920J5992TIL92 $5,000 Retained by Pool National Union Fire 4265193 07/01/92 06/30/93 Property Damage, Property: $50,000,000/ (Colorado Automobile Occurrence/$500 Deductible Counties Liability, All Liability: $250,000/ Casualty & General Liability, Person: $600,000/Claim Property Pool) Public Officials Excess Liability: (Federal Liability, Crime and Out-of-State Only) St. Paul Fire $750,000/Person Excess Insurance Co. 102EA0661 (Property Only) $250,000; $600,000/Claim (Colorado Excess $400,000 Counties Crime: $150,000/Loss Casualty & $500 Deductible/ Property Pool) Property Claim County retaining first $125,000 each claim $ 206,095 (135) COUNTY OF WELD STATE OF COLORADO Salaries of Principal Officials (Unaudited) December 31, 1992 ELECTED OFFICIALS: Commissioners $ 32,000 Clerk F. Recorder $ 36,000 Treasurer $ 36,000 Assessor $ 36,000 Sheriff $ 39,000 District Attorney $ 76,000 APPOINTED: County Attorney $ 85,629 Director of Planning $ 52,304 Director of Finance end Administration $ 94,524 Director of General Services/Purchasing $ 60,636 Director of Ambulance Services $ 54,237 County Engineer $ 60,636 Director of Social Services $ 56,327 Director of Health Department $ 83,583 Director of Human Resources $ 62,160 Director of Communication Services $ 48,567 Director of Personnel $ 47,857 Comptroller $ 57,733 Director of Emergency Management $ 32,554 Director of Road and Bridge $ 60,636 Director of Computer Services $ 72,099 Surety Bond Coverage for Principal Officials (Unaudited) December 31, 1992 District Attorney $ 5,000 Commissioner $ 25,000 Treasurer $ 250,000 Sheriff $ 20,000 Assessor $ 6,000 Coroner $ 25,000 County Clerk $ 25,000 County Clerk (Titles F. Deeds) $ 5,000 Director of Finance and Administration $ 100,000 Note: All bonds are issued by the St. Paul Insurance Company and are on file with the Weld County Clerk and Recorder. (136) COUNTY OF WELD STATE OF COLORADO PRIVATE PURPOSE REVENUE BONDS (Unaudited) As of December 31, 1992 INDUSTRIAL REVENUE BONDS: DEBT REVENUE BONDS TYPE OF ISSUE OUTSTANDING OUTSTANDING ISSUER FACILITY AMOUNT DATE BEGINNING YEAR ISSUED RETIRED END OF YEAR Evangelical Lutheran Good Samaritan Soc. Nursing Home $1,400,000 11/79 $ 715,000.00 $ -0- $ 85,000.00 $ 630,000.00 Monfort Inc. 4,100,000 1/92 -0- 4,100,000 0.00 4,100,000.00 Waste Service Corp. Landfill 860,000 2/91 840,000.00 -0- 20,000.00 820,000.00 Waste Service Corp. Landfill 2,500,000 2/91 2,460,000.00 -0- 45,000.00 2,415,000.00 Nor-Colo Distributors Warehouse 925,000 8/80 385,000.00 -0- 385,000.00 0.00 Dr. Hesse Clinic 90,000 2/81 35,898.71 -0- 7,728.19 28,170.22 Dos Gringos Land Warehouse 380,000 12/82 188,114.43 -0- 30,560.40 157,554.03 Eisenman Chemical Office 2,500,000 11/82 2,500,000.00 -0- 0.00 2,500,000.00 Platte River Steel Co. Manufacturing 2,000,000 5/82 1,695,000.00 -0- 65,000.00 1,630,000.00 10th Street Investment Office 2,500,000 8/82 2,085,000.00 -0- 90,000.00 1,995,000.00 Gateway Partnership Office 2,800,000 9/83 2,225,000.00 -0- 110,000.00 2,115,000.00 Dayton-Hudson Target Retail 2,000,000 4/83 400,000.00 -0- 200,000.00 200,000.00 Colorado Counties, Inc. Office 625,000 7/84 550,000.00 -0- 30,000.00 520,000.00 Weld Mental Health Office 650,000 6/84 470,000.00 -0- 35,000.00 435,000.00 TOTAL INDUSTRIAL REVENUE BONDS 14,549,013.14 4,100,000 1,103,288.89 17,545,724.25 MORTGAGE REVENUE BONDS: Single-Family Revenue Bonds 1981-Series A $ 7,500,000 12/81 5,045,000.00 -0- 720,000.00 4,325,000.00 GRAND TOTAL PRIVATE PURPOSE REVENUE BONDS $19,594,013.14 $4,100,000 $1,823,288.89 $21,870,724.25 (137) COUNTY OF WELD STATE OF COLORADO RETIREMENT PLAN REQUIRED SUPPLEMENTARY INFORMATION (Unaudited) ANALYSIS OF FUNDING PROGRESS BEGINNING NET ASSETS ASSETS IN EXCESS OF NET ASSETS PENSION IN EXCESS OF PBO AS A FISCAL AVAILABLE BENEFIT PERCENT OF PENSION ANNUAL COVERED PERCENTAGE of YEAR FOR BENEFITS OBLIGATION FUNDED OBLIGATION PAYROLL COVERED PAYROLL 1983 $ 9,248,144 $ 7,730,870 119.6% $ 1,517,274 $ NOT AVAIL. - 1984 11,244,338 7,424,910 151.4% 3,819,428 12,116,236 31.5 1985 12,970,501 9,267,695 140.0% 3,702,806 12,888,781 28.7 1986 16,858,875 10,070,431 167.4% 6,788,445 13,526 009 50.2 1987 20,121,008 15,836,511 127.1% 4,284,497 13,962,091 30.7 1988 20,329,032 18,163,945 111.9% 2,165,087 14,490,067 14.9 1989 22,477,627 20,213,686 111.2% 2,263,941 14,901,100 15.2 1990 26,072,114 22,253,521 117.2% 3,818,593 15,996,924 23.9 1991 27,977,533 25,506,910 109.7% 2,470,623 17,142,831 14.4 1992* 29,768,093 29,636,684 100.4% 131,409 19,714,540 .7 * As of January 1, 1992, plan benefit provisions and actuarial assumptions were amended. The changes had the effect of decreasing the pension benefit obligation by $501,116. REVENUES BY SOURCE FOR THE EMPLOYER CONTRIBUTIONS FISCAL AS A PERCENTAGE EMPLOYEE EMPLOYER INVESTMENT YEAR OF PAYROLL CONTRIBUTIONS CONTRIBUTIONS INCOME TOTAL 1983 4.00% + 2.00% over $400/mo.$ 632,054 $ 632,054 $1,261,004 $2,266,242 1984 5.50% 666,393 666,393 1,043,786 2,376,572 1985 5.50% 708,883 708,883 3,162,758 4,580,524 1986 5.50% 743,931 743,931 2,598,746 4,086,608 1987 6.00% 837,729 837,627 1,844,038 3,519,394 1988 6.00% 869,404 869,404 1,697,180 3,435,988 1989 6.00% 894,015 894,117 3,235,513 5,023,645 1990 6.00% 960,439 960,439 1,424,273 3,345,151 1991 6.00% 1,034,264 1,032,318 1,313,859 3,380,441 1992 6.00% 1,183,845 1,183,845 2,081,605 4,449,295 EXPENSES BY TYPE FOR TEE FISCAL ADMINISTRATIVE YEAR BENEFITS EXPENSES REFUNDS TOTAL 1983 $ 263,080 $ 84,059 $ 267,431 $ 614,570 1984 316,266 45,162 382,735 744,163 1985 438,398 91,491 192,416 722,305 1986 464,517 116,852 246,809 828,178 1987 602,568 108,459 230,810 941,837 1988 756,332 174,261 356,800 1,287,393 1989 864,493 138,057 426,608 1,429,158 1990 965,072 163,166 311,494 1,439,732 1991 1,108,835 190,230 290,815 1,589,880 1992 1,263,671 195,374 373,280 1,832,325 (138) COUNTY OF WELD STATE OF COLORADO Computation of Overlapping Bonded Debt General Obligation Bonds December 31, 1992 Net General Obligation Percentage Amount Bonded Debt Applicable to Applicable to Jurisdiction Outstanding Government Government Cities & Towns $ 99,242,406 92.90% $ 92,196,195 Schools 147,597,646 81.60% 120,439,679 Special Districts 29,140,446 80.76% 23,533,824 Total Overlapping $ 275,980,498 $ 236,169,698 (139) wille COLORADO (140) COMPLIANCE SECTION Cii*i pg. COLORADO ANDERSON &WHITNEY, P.C. ANdERSON CERTIFIED PUBLIC ACCOUNTANTS WI�y. ,TM1 V1 V 1001 Ninth Avenue © 1 ♦ ■ II . 1 .E 7 Greeley,Colorado 80631-4046 ■ ■ . ■ . (303)352-7990 FAX(303)3 3 52-1655 Independent Auditors' Report on Schedule of Federal Financial Assistance Board of County Commissioners County of Weld, Colorado Greeley, Colorado We have audited the general purpose financial statements of the County of Weld, Colorado as of and for the year ended December 31, 1992, and have issued our report thereon dated May 21, 1993. These general purpose financial statements are the responsibility of the County's management. Our responsibility is to express an opinion on these general purpose fmancial statements based on our audit. We did not audit the financial statements of the Weld County Retirement Plan, which represent 77 percent and 89 percent, respectively, of the assets and revenue of the fiduciary fund type. Those statements were audited by other auditors whose report has been furnished to us, and our opinion, insofar as it relates to the amounts included for the Weld County Retirement Plan, is based solely on the report of the other auditors. We conducted our audit in accordance with generally accepted auditing standards and 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 general purpose financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the general purpose 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 and the report of other auditors provides a reasonable basis for our opinion. Our audit was conducted for the purpose of forming an opinion on the general purpose financial statements of the County of Weld, Colorado taken as a whole. The accompanying Schedule of Federal Financial Assistance for the year ended December 31, 1992 is presented for purposes of additional analysis and is not a required part of the general purpose financial statements. The information in that schedule has been subjected to the auditing procedures applied in the audit of the general purpose financial statements and, in our opinion, which insofar as it relates to the Weld County Retirement Plan is based on the report of other auditors, is fairly stated in all material respects in relation to the general purpose financial statements taken as a whole. at,el? � � C . May 21, 1993 (141) MEMBERS OF AMERICAN INSTITUTE OF CERTIFIED PUBLIC ACCOUNTANTS SEC AND PRNATE COMPANIES PRACTICE SECTIONS-AICPA DIVISION FOR CPA FIRMS ACCOUNTING FIRMS ASSOCIATED,INC. •®Q{1 •ORG-[• N 0 .-I '1 N 0 0 0 0 0 rl YI m 0 0 0 in J R W .1 p 0 0 in 0 N m O N - 4 {V I N Nel W et N Lp N 0 m m o m in o r a N m m 0 0 0 SL C a co WO N H P N P a ti 0 in a b P LID N co d a b H N 0 N N d N in• el n1 b CO r1 r O € M VI CO N N N m r1 Nto a CO N r P 0 N N O r Nm 0 O r N d r1 el 0 0 0 I.� 0 N r 0 P 0 N r 0 N N P 0 0 m H m CO d N P b N ON 0 N P P CO m„ 'I 0 0 a N • Y1 ry b 1f1 0 N r 0 4m1 a d m N N N P P N m b C N b 0 b N N d a 0 0 00 EM 8 I N N V1 VI G N N yMS u.�ry N O 0 0 O O m •d o a "�.I {f!v�� N 0 P H H E T H• N N 44 U 0 0 a o n rl N r1 N r N a r1 N 0 0 0 CO N N d in O N r 0N0 0 0 0 E d 0 mN P m N P N CO N P Cl 0 1l1 O 0 H N• N V) in co N Pr o ry {rO{.�� M N n Nel P 01 m m rl ID W W 0 el 'I ^ O 0 0 a 0 0 0 m 0 N O O O N 0 N N P d a — m a a m v n m m m a N N N U ti CU ef 4 ❑ H O a o o I(1 N N m N 0 0 N N m H in N N in m m b H r r m in▪ ill el 4 N N CO N O TY CO b N N w co n n a N O 0.y 4 O in 2 b u b m 2 Cll 41 CC 6 $ tJ i i M "Ei 0. a 2 0 w 5 w a 2 6 0 N u f:;.3 pE P H H Y S H 0 0 H m W U U U m U U E E C m H 8a k V ✓ V 4 yu 0 pO0 .Wi •mi +m1 O co Z N y61 a' a Z 4 a to a ya W ❑ U N fi B 0.41 N HN 4 qC C BO 0 co N Hp� WM (Ny.I uC +UUi el i q N N W 14 14 U P.o UU N m N leg !:14 Y AEI Ilfp��C4 �Sl W 4 W E TI N . F N N 4 E E W m m E 9 mg tG P. 'f4NN+111 a 0U. vmi ti ff IOL N N 04 10 W 9m N N P. N m fO� (pa�� O D A N Wa 41 W 04 A C co 0.m' 04 04 C C V (11 N F [U) 7.1 p d [4� C U U +Ui C .44 Y U U H C 6 m ❑ a Z W H `,1 14 pZ� m m W C g q C C C q C q N 4 [+ IKC .41 4 4 ZZ q PI tO T F E 01 0m m m F N O •�(WY-jI PI U 0 ~ Oa 0m E F N a, 0 0 0 0 0 0 0 0 0 0 0 .C ri el Z b b b INO N lap b b b o0 al {E m 'OW b b b m m b b 0 O 0 Q rp� a d [[[[[[QQQyyyyyy M0 P P H H H H H H N H el N N H 0 NNNNN N N 0 P P 00 et el 0. 010, P P P P Cl el P P P P P CACTI 01010101 0) N el el et el el N N N (142) O QW N ^ mp y I-- 0 b N o N o b o 0 0 o N a 0 G O m Cl Cl y fl N N .bi P ff55 m �n r o m o m r N q' WW n « N S N 0 V W N or 010 e o o N N N P v v P 01 m b N b Pot 0 0 O N N to N ID N a b 1'1 d Cl 0 N en ts O N to N a N N N r1 b Si d d r b S r N e r m r m m en m N P d to N to 0 m O N 0 O N Si .0i ti) m or Cl 0 O m N 0 N 01 0 0 0 0 �i1 M . . . . . 0 el .bi O HHII b N CO b 0 .Ni FI Ifl a r r YI N N 01 ti r1 N N CO r kl; �` N en b 0- N a m N m m r IN-I en N Cl n m :1 o a MFirz m 1 « 0 6 0 N co 0 0 0 to KNI an W E. N 0 CO 0 W co 0 to en 0 N el O v N O v1 0 01 0 N 0 0 EM 1]- 0 O P N O VI d HI N P CO CO 0 O I-N I '0.y a HI O tO N b O W O m• r m• Si • m N 01 .� en r el m r '1 r1 U �0 LO N a r 01 N N N CO N N ti 0. W 0 « N N m Cl r P ti ,y 0 0 N' Cl o N o a 0 O p m o p o 0 N to m dN in rl 0 v1 Cl p m N n r o In cH b r m N mHi a N 10 • N N CO c rn -, at. el NV r d 0 v n r o r r o a Si m• N r IO LO « t ID N O G N o co oo In N N b0 N O W N Z Si n b Si 01 0 .di -, .ai d N O O O g I 14 filWIZ O 0 � C) U ot P4 m 0 Eo4 4 [U W P 2 E 0 H ." o 04 IW� o 2 :1 P 0. 0 > 0 0 0 W g 14 0 5 S 4 14 �0 HI 0 0 mil0 U G 0 04. p O (ryy6 G 0_ 0 ty�In O 8G ti .ri.pi .0i O Y H O Nq pW al 0 m M (y Y pW Y Y Y Ny •J V 6 IOd I5 S O m % Q 4Q�1 .G1 W -'1 U N 0 V Y V ✓ M M .-I k01 , Wpl o W o W G .0 M 'C 8 8 n. w z' z z m Q $' W W O N C M yH W p 10 8 ,0 >O 0 B 0 p0� a Op�1 o T 0 ti .4 .-I .O4 aI P. U' �O U O U 0 Cl W WI 1, W F C M M 9 m m m .~i .Yi b W�+ Cppy ICi H W M w 4 [O� A ygygH0 U F O. 0. Si W Si Si 'Q Si9g[ p RI W y m m W Y Si O. M g ro VOi to Si 0 6�0 00 O U C ; 0 0 0 ❑ 0 0 ❑ 0 0 a W 0 CO0 0 d in or 0 9-1 6 a a b oo.. 0 F[� 0 0 0 000O p to ID 00 N N N al n HI el o 0 0 o W 0 t p r r Si Si CO m v v d pa P1 0 0 0 P 0 0 41 F�Ij b m m 0 m 0 CO a a a O O In N Ip y3 N en or 4 O 0 0 0 PEl N N 0 N Si N •-• -4 .N N N N N .+ N 01 N N N N N N N N Si 0 N N b N N N N NHNHNHNNNN 0 P Cl P 0 0 0 P 0 P 0 0 P 0 P P Cl P M P ON 0 0 01 M N N m 01 01 N N N N Hi N (143) Q 0 0 0 0' 0 0 0 0 H O O 411 0 N m �1 6] m N O '1 In 01 ^ O m m N Uy�" ML'' P is 1: N to m m 0 6 IN 0 H of an 0 d 0 in ..-1N 141 • b 0 NtO b N N en d d ry N m• d b F N d C.1. P N• O d H 0 d m in w N d on m d N N N m b 0 d P an N IC 1.� IC m N d N d d 0' N N N d01 a d .i P In N P VI 0 O N H N to M b r H 1� 0 • h• m 0% m N IRUUAI N m r N d b m rn CO 0 0 ry In N to In El • H sm w 0 r 1.1 to HT P01 g N 0 H W U 0 0 m b OL d d In N m 0 0 0 OI an .1 N N N N CO 10 N d P 0 O V. n V. N to r N m 0 N V) N 0 P CO m Inc 0 in 14 - N P Yl ` O ` O N N to N N r m m 0 N O 0 H - b in 1� N I--- P ` vl .� •.i d O N b P al P 0 .1 N d • M1l (4 M N N M m et N tO P H b O • 0 b 0 N 0 m ID N H Q^ N 0 in 0 n 0 0 O O O 0 N CO p y ti 0 (J0 �(4 P V• P N to d U W m on Cro N N to R r- r N N r H •-i CO i toN CO H d N co CO fl P N 0 0 H N O P m•N 1� P W O m d .i N N 4 m m In O CO 10 an d v m N N H H N H m m m H H In 0 r CO 0 H m an CO 1^ v In v in b N b b to N b W 4 an to to to to to b r 1n in an Q1E'1 m m m m o n l n n n n 1 n U P P m P P p1 P P Omi P P q 01 0 Ial CA o e ti I 1 ! i E El w o " O a U N N H O. P HH 0 ` H H H 4 CO U U La 0 N • ..4i 4+ 44 4-, y 0 101p !Iq�! Ig 7414 zp • a 04 a a a I91 C O El H 01 IT G cps C e y 9.4 en y4� O 0 r 4 1C pi 4 4 4 d y Y 0 10 C p a ✓ 9 0 4 of L .0 0 7 O +pP1 I4 i 4.3 O Ipdp S �Q�.4I 11+ O N 4 m H 14 y 0 14 C 11-1 0 T1 14 3 0 1M Z 04 44 0 11144 E 14 £ 0 C 0 4+ CC m 04 14 iI N it > ?1 Y TI V TI 0 g11 P H y 40 0. s1 0 O C 0 C 0 H C b1 C 14 C m C W 4 8 1.94 CC 8 -a OP ii0 m & U o0 a w o S of H m'8m1 CO CO E R E• 0 0 0 o v o 0 0 o 0 0 0 0 0 N 0 n In 10 10 r 0 0 N O o O O a O O O O (1 000 b 0 0 0 CO co r 0 d d HI a v d 01 I-4 V 44 01 d d d 44 d WW 0 b CO M 10 b 10 b to b 10 d d d d d d d d d d 0 o 0 m CO p 0 b Z H H '1 H .1 H H H H H NNNNNNNH NN N 'kJ1 N CS N N N N N N N N N H H H H H H H H H H H N H N H N H N N N N N N N N N N N NN P 01 O1 P P P P0 P P0 P P P P P P P P P m P P P 01 P O1 H a H P P P O .0'4 P .0'4 .PI .0'_I P 01 H H H H N N H N (144) m a m 0 b r Ne ONEm .vo e m el b o m m m a Cr n O N N N in N N M ` CO ..44 in ti 0- N• n 0 N N �{FJ[ 0N el SD a vai b I-I n1 N b r ` o 0 ti a m 0 r 0 a a a m w to N .I B a N a b N to to b r 0 m m m r N a m .4 mm co 0 CO G 2ry .: o o n n m [FO4 fC 0 m a n b ftEU r N 0 .. N N S. H to in N to N 0 .4 N 1.0 N a n 0 r-- Li.'" a n n r a U S 0 0 9-N 7N n elCO r en in en CO N a n ti Yf b m '1 a a • • • • • mN H to b inN en in NI K M a N N NI b O N a a N N r to a m 0 el a N in 'I N m a N N O n CO to N a It1 CO r a a r a a O t0 n n „ n CO Cu a n a m n N N W o - a .4 a N , r 1D w4" m N 0 0 a ` ` • O b 0 N O in 0 m inN N co N .-I a '1 m N N n a CO II ❑ a n N N a b N NI N 5 m n .4 CO '1 n N 0 .4 CO m a a n n a n ii- ia .4 .4 a R n - N n ren b U ry M V 6 ❑ H i 4 l�. s n 0 m CO r o r o n In CO r o In CO n o .yw N N N a m m N b 10 i N a in b N a YI b to 0.' b b 0 m b b b b b Cr 0 41 w n Io n n n n m n n n n n n n n n n m 0 a a a a m a a a a a mama a a a a CO m W O 00 I0 M " In 0 M 0 11 I w M 4t 0 4t 4 4 El CO 9 9 N m M H H H N 0 0 4 4 4 n W w z 43 m 4-3 m U u Li gC li 0 F N d N 0 4 4 N H m m u d ga U of 0 " 6 0 ❑Itf R I W 44 4-1 -- U 0 -t 3 14 3 0 el w tl Wa el m $ W W W W 1 H E 41 PWW 0el ' 1 " yW C N 4-1W W 9 C 1 V U Ti el el w w Wa 0 3 U 1 a pm� p P: 5 s W H 0 H4 9 H 4 R3 0 0 0 9 9 W W ?I �+ ti 4 W 9 cl F U . .�1 �+ 0 El 0 �. Pi .4 N n CO to 0 10 r 0 in in in H 0 n n n mm n m m n a m a a 44 a 0 a a a v a a a a - a a a a v a a a 0 a a a a a a v v a a a a a a a a ❑ a a v a n n a a a a a Q a a a N N N M N N N N N N N N N N NNNN N N H 0 H NH H H H H H H H N N N N N N N N N N N N N N NNNN a a a a a a a a a a a a a a a a a a a a a a a a m a a a a CO a a a a a a H N N N N N N N N H H H H (145) y' {0 ®Wad N m 0 0 0 0 0 0 0 0d O 0 0 0 m N W P 0 a en WW4� , ° P n n m to N m U4 N0 N.i N 0 m v 0 V d WON P H N 0 b d m b d 0 m N b N 0 m d m ^ O 0 m O 0 N d d P d b P CO Y1 b 0 001 M O O d I(1 0 en ` • b .4 b • 0 N N .4 m M O In N • NI III ZW N N m • id rX N N WONITHN 0 0 d O in d 0 CO CO to 04041171141N411 b m N d 0 m 0 0 a d in N El 0 d 0 d b P 0 m d 0 0 m 0 N CO 0,M 114 re? N N en m to m 0 a toN m • ti 0 0 0 N N m N 0 N N 0 0 M NI N d W 0 N ti N ot 0 N in in a co o 0 411 47 M CO in OW N N m m mrn 0 0 o ko m am 1n rn 0 { Ill En m 1 0 P on 0 in W CO to b m in m O N P -I N 0 CO d O an d P N H �E 31 a a a 0 a cis 0 0 in m n N .4 0 �i 'yW �tW] a .1• o e u, v• i m n n e ri r ri n m 4m1 N 4 0 r'1 N N m 'i O N M N b R M m N. V) r m P In 0 0 0 0 0 0 0 N O N 0 0 en in O P en m 0 0 N d N In CO a mI • N c. N N N d U 0. m 0 m a 0 - ei . 0 0 o 0 b o m m o 4 0 pi N en In 0 N N N S CO ti 0 0 0 d '1 dei b N b b b b to m N rn in W O m 0 1� m N O O ca OO W n 0 n ri n n n a n .�1 CO U P .+ N 0 P 0 0 01 CO a 0 U 01 M> MVDI Q \ 'V U K N W i 9 U v O y M @ M N In M gi 11 to d . 2 0 a a H a 0 m a 0 g 0DI 0 0 U W NI 0 V N8 in ~i .~1 nel 01 MU aqW p2 to U W N .i 0 CO P4 01 N Pi COIN U .4 vel DI fK S a 11 W to .1 M +~1 M R 0 3 [V CO M O 0 ..1i CO 0 V m M W 0 W• ~N M 0 UPLI PI M. ti R 0 U 0 E.N1 a c c c C `0 0 a •-• • a H g' 01 m a c, *4fil R 43 I0 14 14 V to 6 m 0 U h 41 H W W W en 0 0 a P 0 0 N 0 0 0 P W 0 H d d d d d d W W IM d d d d d 0 N a 0 4 d M QL d N N .. .N4 N IN .1 . .. .Ni .Ni .Ni .N. .N4 CO a yyYY 0.' a P P 0 P a a 0 0 0 0 P pN (146) a o • a N o o b P o a a o • o N N N N m o 0 in N m m p N [Q m 0 0 r m N CD N m n _ a 40l wN 'ZM n P• P m .ai .n-1 b n n NIT M 0 O. N r en CO O N CO CO CO '0 d N 0 0 m N 0 0 a N 0 N P a n 0 IN 0 b P N a 0 d 0 0 P P 0 0• 0 b N 0 0 0 N O N N m CO 0 r d CO e1 N• N a N 0 O „ N 1n 0 M NN 0 • co 0 tn O P O P N CO 60 N .1 a 0 r N in 0 0 0 el 0 a 0 a 0 d m N N d n a 0 n CO N 0 el 0el E O m 0 • 10 •a 0 • .1 m m 0 0 0 pHp�� r o r m N m a' o m - r r.4 In NN U r .a4 en a 0 0 ..44 0 N N N ra m 0 �a 4. 0 0 0 0 0 W of la-1• 8 a 2 O 0 0 0 0 DI a VI 0o u 0 m 2 a n N N 0 ON b N 0 • 0 .d4 0 • m N N • n • b n CO .Ny 0 N O Ea a �.] . . 0 a d O d P m 0 0 CO M 6w' �ww]'' r O r m• CO 0 a d - m P r N N [.] O µ M r a n 0 .'I d b 0 „ 0 v1 ry U CaI N n a 0 O N M M m 4 .— 4. O Ni 0 b 0 0 0 0 tO P 0 0 0 0 0 .4 a N r N r IP 0% co oo a4 CO N N m m P n n m 0 OL n m m o in , n uri in a a r Ni V 4 0 ry.. m a 0 N 0 0 p 0 N O R N 0 O a• CO V N en ti .4 N N N of v N CO N 0 m 6 o ry N ❑ p ri V r g U P CO oil Ea N a m ❑ t/� LC ppq� P 9 w 00 N 0 4 0 0 4 to 0 " a _to u u 0 o .0 .4 ®w o {(24y 0 0t, 14 m m 8 � �i n up H G Off' M a AL ii o N W I g wEa {^�� Y m0 " g E. ' 0 0 0 R. OOO mU O �-�I H Y 0 .�.4 7 h ti 0 U W p uN RI , m 0 C 0 O 9 0 a, m 0 N 0 Npp PI �o+ 4 > wm nn3 L 3cc ell y P. 0 U>l w mm0 Y .0.� Or y 0 0 O 44 M0 o M00 V N ; 0 o N m m 0 H 2H .Yi r4 0 0 2 (0 m 00 0o 0 0 C w ry 0 F 0 E m E O2 O 0 N 'I .4 O N o m 0 0 0 o 0 b b o 0 N (0 o N N M b b 0 0 0 0 0 �o �n 0 CO p w a q 001 T P 4 yN .4 In N N .4 m N .-t .4 �1 N N N N N O a N N N gN N w g 0 N N N N N CO N P m \ m P P O P 0 m m .P4 0 N .P4 el .P1 .l .P' P1 m P (147) 0 p b N Ill 0 'I O P O O Yl O m O N in 0 0 0 0 d 0 0 0 'I W P N in P n V r 0 V 0 P O Hi en 01 s V 0 0 rl w6 b 'i O P 'I b P a in d m d m in in P N P a N O N » m (a� d I1 in P P N 0 N rl P On O in in co a N m b b I'1 d eH,w d Yl O O m 0 m O n O a O P b 0 I N O N In d b b N d ul d d b nl d P O O 0 d a P I'I Yl N b M in• N O On 0 d P d CO m CO m Na, b • N N • in In N m N 4O N s a m b N 0 in N N N w » a N r n O b 0 a 0 Yl O P r O n d m N b en CO P N ^ b I'1 N N m N toN m N b b 0b CO N a n taI 0 in NO a in m o m a a in In I-- a Io 0 M 0 _I P P O N 0 m nl 0 0 0 d d d▪ N N P 0 b 0 a !n-I w In 0 m a P N in ril N CO N N r - N In rn b n C on O in m in » CO r a id m M .9 m m ID O P in to » P r l In M E W P in yU CO to m n n 0 0 CO n d 0 in in P In N r d en d N In to P N •d b m N In m a r U m n inin CO CO P CO d „ Ij 0 N O d in N N in P O 0 d a P m r 0 OS O▪ ` m 0 O N 0 m m O O O PP • N a 0 b hl w❑ b d inin in N N N d N Ct t m » N Wiii- iV 0 N O n O in in m na 0 0 0 In 0 0 n 0 O O b 0 0 0 U ❑ U N in N b - CO a N 10 P in 0 `. 0 in inN d 0 0 0 0 in d d N 0 I m co N m N a o n in in in uI » I`t N r r in u - 0 N N N CO N P b 0 N 0 PI a 0 P ❑ 0 m n1 m O I'I N Yl N VI O n 0 o N O b a o N N o n in H 0 a in 0 n In 1'1 in m o a ID ry N N o a o m in H 0 b in 3 b m 0 n d• a a in ry 0 m a r c w to 4 r 0 r co N a b m a rn a s in n m b m in N N N » I�. x 0 to CO n a a in a in N P P 4 N N N P P 0 to0 N N N N N G1 CO P Li U O P. o w m co w 0 ` 0 z ' a 0w U N U W ?� O P m u Q 4 wp v 0 in o m z U ]7I�]-- a N O i O 4 0. o w N B g 1 of 14 H 66G O H in 01 COy O y �pQ❑ pI� p N� N in rp]� C fG [ ciel fa 01 8 9 0 ; 8H F O O pK H N 114 114 I a 3 ❑ w Z w N C U g0 CI 0 U OC '8O C el S N f� Wq0 wO C +t, H N 1y R 0R R �wG eS O R. \m4 U U IC to to O PC E nit 0 H Oil C W U "I 0 it) - gV t'I 9 9 a H cc H 91 O RI o wo wm F 4 to w E. a 3 p p$ U to a v .> q4 4 W ip O H H m b IRO ® W W t'I el el 0 L L 4) co iiii W m E b U U w L 61 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 G m F a v a c CO n in n e-i et m d . . On d, W U 0 0 0 0 0 oa 01 N 0 0 0 0 0 0 0 0 0 0 10 0 b b 0 0 tow , , , . , . 0 CO filaa fil to 'py Vf P P ON P P P C N N N N N N N N N N N N N N N O N N N N N N 'I N in N in NM a F a SONO . H 0 P 0 N N N N N co N N P P P P P P P P P P Cr, P P CO P P P P P P P P P ry l P Cr P P P P P P a, P P P P P P P N et et et N N N N N N P P P P P P P P P P P a, (148) N N 'I N N N N 9.Q N N N 0 a ONO in In en H r4 r1 O 0 H O in in O O O r i 14. 0 VI P H r N N N m a 0 0 0 Co MIN . N in 4] P .mi N a '1 '1 en a in a O F�y4 O in m en t'1 m 0 a N .q O O 01en r a b b N r, ,y T 2 ,. ai ^ ^ .-i 0 ,4 w el o 0 00 in NO m M N b m b a N 0 01 a o P r) .i m m m m P .90 N 0 00 1m0 top P WI N m b a rl o a COm in CO M M ry n .� N a N a n a t. r n mr H N N ei 0 r tv in a CO n o 0 cn b N 0 in CO �s 01 "pto m H CA m E N 0 0 m 6 en n C.1 En U in in N gN m N N m 0 O b C a o m 0 m 0 r) N el r 0 r CO Cl to y a,In 0 0 LO P m N b o m o 0 a a 0 1M1 0n in m H in w m •� n H n n al r r a o r N• N N.{N 2 a b O^ p O in O e" O m 0 0 a O a 0 a 0 0 CO P Cl N 0 r o a co m b r r0 0 0 I o N N in a rl Cl Cl r r- 8 O H 4 OO H 0 a ii ma .0 m r°1 b inn ", T O a O b O CO a - b O N 00 N 0 O in O 0 b b el 0 4 el en a a N N H r4 b a P 0 N H O O N N M b H 0 0 >-. 4 v 01 H Cl H Z N en m in 0 2 ^ �.1 U .. .^. .^. .r"1 00 0 N H N 0 F a x ° m 6 $ >4 H CO 4.BP 0 a 6 a c 2 a 2S [� o 8 E ti 6.� 4 N H 0 in I p 44 � a tap E 81 I041 8 in 0 aqa po 41 u .yam q0am d y�i� m 0 N g 2 0 4 V O O 4 �a�a0 D so 2 0 W 3 0 W C4 N is a C 4 F I 01 N H H M 0 0 U a p0pm�� O Nj 0 0 H H uO H UO 0 0 N C H E p m U O u 10 0 CO4 4 CO8 E O ft F (a� ft E $ $ o a O H a 8 �i b'yi 7a H u m0o ii o O o 0 0 0 0 0 0 0 ti W 8a0'1 N In W 0 N N G a a C a a a a a a a f0 H 0 tp en y.� 0 0 CO O emt O 0.0." FT. aC1 e[rya�1' �q44 .i .-1 .i of .i H H el m cn - O 4 N N O a N N Ie. N Nen FF FF 0 P P P H N H NH H H N N el 01 P P P H 0 ti P P m 0 P P P a m cn P P P H el H H (149) fig] N WI 0 0 0 0 - ry0 H. p YC m rya 0 0 ,vi m 0 a v I P m 01 •ai I U MI a in v N O N I NN V0 ... N N v it % .' r O d N P 0 CO F� O COm nl 1• en 010 N 0 N 01 N N O v a 0 H ID P N N b g a in O N N I �f 01 I RpY m m I w N 0 00 N n T N N Or a 0 •, rn 0 1. CO in N 0 N U • .P4 N N N N. N v O a a en M 0 V1 0 10 v P 0 N N in 1 E o vNi c m a CO .Ni 0 P Cr. I pi • 0 CO I sto a 4 a n N N 0 a H a .. M 0 a 0 in N N 0 N O O RI N N N up Cl 0 m N ..4 N „ 0 0 0 0 N in 0 N P O N 10 CO h F r� YI nl v01 vat P 0 CO a H • m a fi o 0 Nel 1-1 N m N w n a 0 m N I-- 0 N 0 I N N I N I 0 01�'.pyJ N I U O a a 0 0 0 0 n m N m m m m ma. N N • 0o m 4 O N a uI H 1 Cl v 0 OD 0 N n 0 v o 0 O N 0 Ti m N N N el N 0 In N d U N N M = Cr, 0 in 0 Lin N a H. O N v 0 0 0 40 0 N N N - oN 9 m $ Z i U fil MP May'' (O H 0 H LO 04 U' a O > 0 b 0 a 0 F T 0 H ;A• l a w ma m u yyH0 U £ N H O 0 4U1 N 0 ZO 4 N H U CD H O 4. O U 0 U 40A Fil CO RI a X0 3H f.0. 0 0 pp0�� 0 01 3 Cl W Z H W a mF N E 5p0 00 N E m $ Cm F 15 B (9 pC�] 01 Y. N N G m F6 U O P] aE C 0 m gg8 pP�. O' �y' 00 0 CC U H N ON O a 2 o U 9 0 U 4 M _ m yE 3 Iii J 3 O 'yU �i Y �j6' .Ni n of WI 0 1 0 q N O N N .Ni el N ® Erl (0 bJ {4L1 {EP N N N N N 00 H O a 00 U) Q M ON 00 N H M 0 0 0 0 0 0 0 N n N P P P Cl P 01N ry c4c P N N H P P P P P P 0 a P P 0 P N H (150) COUNTY OF WELD STATE OF COLORADO SCHEDULE OF FINDINGS AND QUESTIONED COSTS Year Ended December 31, 1992 Program Finding/Noncompliance Day Care Required contracts between the County and three day care providers could not be located and one contract was not updated for the rates paid. Payments made to these providers in 1992 under the unlocated or unrevised contracts totaled $1,820. Management Response: Changes have been made in two areas to prevent this from occurring in the future. Contracts are now kept in a central binder vs. individual case files. The computer system now has a tickler and will prevent payment if the system does not show the current contract. (151) ANDERSON & WHITNEY, P.C. d ANERSON CERTIFIED PUBLIC ACCOUNTANTS , `I ,v Jvl 1001 Ninth Avenue ©WHITNEY Greeley, -799Colorado 80631-4046 ■ ■ ■ • • (303)352-7990 FAX(303)352-1855 Independent Auditors' Report on Compliance with Specific Requirements Applicable to Major and Nonmajor Federal Financial Assistance Programs Board of County Commissioners County of Weld, Colorado Greeley, Colorado We have audited the general purpose financial statements of the County of Weld, Colorado as of and for the year ended December 31, 1992, and have issued our report thereon dated May 21, 1993. We have also audited the County's compliance with the requirements governing types of services allowed or not allowed; eligibility; matching, level of effort or earmarking; reporting; cost allocation; monitoring subrecipients; special tests and provisions; claims for advances and reimbursements; and amounts claimed or used for matching that are applicable to each of its major federal financial assistance programs, which are identified in the accompanying Schedule of Federal Financial Assistance, for the year ended December 31, 1992. The management of the County is responsible for the County's compliance with those requirements. Our responsibility is to express an opinion on compliance with those requirements based on our audit. We conducted our audit of compliance with those requirements in accordance with generally accepted auditing standards; Government Auditing Standards, issued by the Comptroller General of the United States; and Office of Management and Budget(OMB) Circular A-128,Audits of State and Local Governments. Those standards and OMB Circular A-128 require that we plan and perform the audit to obtain reasonable assurance about whether material noncompliance with the requirements referred to above occurred. An audit includes examining, on a test basis, evidence about the County's compliance with those requirements. We believe that our audit provides a reasonable basis for our opinion. The results of our audit procedures disclosed immaterial instances of noncompliance with the requirements referred to above, which are described in the accompanying Schedule of Findings and Questioned Costs. We considered these instances of noncompliance in forming our opinion on compliance, which is expressed in the following paragraph. In our opinion, the County of Weld, Colorado complied, in all material respects, with the requirements governing types of services allowed or not allowed; eligibility; matching, level of effort or earmarking; reporting; cost allocation; monitoring subrecipients; special tests and provisions; claims for advances and reimbursements; and amounts claimed or used for matching that are applicable to each of its major federal financial assistance programs for the year ended December 31, 1992. (152) MEMBERS OF AMERICAN INSTITUTE OF CERTIFIED PUBLIC ACCOUNTANTS SEC AND PRIVATE COMPANIES PRACTICE SECTIONS-AICPA DIVISION FOR CPA FIRMS ACCOUNTING FIRMS ASSOCIATED,INC. Board of County Commissioners County of Weld, Colorado Page 2 In connection with our audit of the general purpose fmancial statements of the County and with our consideration of the County's control structure used to administer federal financial assistance programs, as required by OMB Circular A-128,Audits of State and Local Governments, we selected certain transactions applicable to certain nonmajor federal financial assistance programs for the year ended December 31, 1992. As required by OMB Circular A-128, we have performed auditing procedures to test compliance with the requirements governing types of services allowed or not allowed and eligibility that are applicable to those transactions. Our procedures were substantially less in scope than an audit, the objective of which is the expression of an opinion on the County's compliance with these requirements. Accordingly, we do not express such an opinion. With respect to the items tested, the results of those procedures disclosed no material instances of noncompliance with the requirements listed in the preceding paragraph. With respect to items not tested, nothing came to our attention that caused us to believe that the County had not complied, in all material respects, with those requirements. This report is intended for the information of the Board of County Commissioners and others within the County and officials of applicable federal and state agencies. However, this report is a matter of public record and its distribution is not limited. a/LW-14407%i et 44:17 e• May 21, 1993 (153) ANDERSON &WHITNEY, P.C. ANdERSON CERTIFIED PUBLIC ACCOUNTANTS 1001 Ninth Avenue ©WI-IITNEy Greeley, -799Colorado 80631-40463 ■ • • • ■ (303)352-7990 FAX(303)352-1855 Independent Auditors' Report on Compliance with the General Reqpirements Applicable to Federal Financial Assistance Programs Board of County Commissioners County of Weld, Colorado Greeley, Colorado We have audited the general purpose financial statements of the County of Weld, Colorado as of and for the year ended December 31, 1992, and have issued our report thereon dated May 21, 1993. We have applied procedures to test the County's compliance with the following requirements applicable to its federal financial assistance programs,which are identified in the Schedule of Federal Financial Assistance, for the year ended December 31, 1992. • Political activity • Davis-Bacon Act • Civil rights • Cash management • Relocation assistance and real property acquisition • Federal financial reports • Allowable costs/cost principles • Drug-free workplace • Administrative requirements Our procedures were limited to the applicable procedures described in the Office of Management and Budget's Compliance Supplement for Single Audits of State and Local Governments. Our procedures were substantially less in scope than an audit, the objective of which is the expression of an opinion on the County's compliance with the requirements listed in the preceding paragraph. Accordingly, we do not express such an opinion. With respect to the items tested, the results of those procedures disclosed no material instances of noncompliance with the requirements listed in the second paragraph of this report. With respect to items not tested, nothing came to our attention that caused us to believe that the County had not complied, in all material respects, with those requirements. This report is intended for the information of the Board of County Commissioners and others within the County and officials of applicable federal and state agencies. However, this report is a matter of public record and its distribution is not limited. accietcoax/ d' 9/4.4.47- c May 21, 1993 (154) MEMBERS OF AMERICAN INSTITUTE OF CERTIFIED PUBLIC ACCOUNTANTS SEC AND PRIVATE COMPANIES PRACTICE SECTIONS AICPA DIVISION FOR CPA FIRMS ACCOUNTING FIRMS A<W IATED,INC. ANDERSON &WHITNEY, P.C. ANdERSON CERTIFIED PUBLIC ACCOUNTANTS 1001 Ninth Avenue ©WHITNE)/ ( 03) 5 -7990do 80631-404603)3 ■ ■ . ■ ■ (303)352-7990 FAX(3031352-1&55 Independent Auditors' Report on Compliance eased on an Audit of Financial Statements Performed in Accordance with Government Auditing Standards Board of County Commissioners County of Weld, Colorado Greeley, Colorado We have audited the general purpose financial statements of the County of Weld, Colorado as of and for the year ended December 31, 1992, and have issued our report thereon dated May 21, 1993. We conducted our audit in accordance with generally accepted auditing standards and 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. Compliance with laws, regulations, contracts, and grants applicable to the County is the responsibility of the County's management. As part of obtaining reasonable assurance about whether the financial statements are free of material misstatement, we performed tests of the County's compliance with certain provisions of laws, regulations, contracts, and grants. However, the objective of our audit of the general purpose fmancial statements was not to provide an opinion on overall compliance with such provisions. Accordingly, we do not express such an opinion. The results of our tests indicate that, with respect to the items tested, the County complied, in all material respects, with the provisions referred to in the preceding paragraph. With respect to items not tested, nothing came to our attention that caused us to believe that the County had not complied, in all material respects with those provisions. This report is intended for the information of the Board of County Commissioners and others within the County and officials of applicable federal and state agencies. However, this report is a matter of public record and its distribution is not limited. ateettztGryti 414147. )°c. May 21, 1993 (155) MEMBERS OF AMERICAN INSTITUTE OF CERTIFIED PUBLIC ACCOUNTANTS SEC AND PRIVATE COMPANIES PRACTICE SECTIONS-AICPA DIVISION FOR CPA FIRMS ACCOUNTING FIRMS ASSOCIATED.NC, ANDERSON & WHITNEY, P.C. /` Ai/-'ERSON CERTIFIED PUBLIC ACCOUNTANTS /""�� �V 1lJlJl �I 1001 Ninth Avenue ©WI-IITNEy Greeley,Coloratlo 80831-4046 X(30 )3 ■ ■ ■ . ■ (303)352-7990 FAX(303)352-1855 Independent Auditors' Combined Report on Internal Control Structure Board of County Commissioners County of Weld, Colorado Greeley, Colorado We have audited the general purpose financial statements of the County of Weld, Colorado as of and for the year ended December 31, 1992, and have issued our report thereon dated May 21, 1993. We have also audited the County's compliance with requirements applicable to major federal financial assistance programs and have issued our report thereon dated May 21, 1993. We conducted our audits in accordance with generally accepted auditing standards;Government Auditing Standards, issued by the Comptroller General of the United States; and Office of Management and Budget (OMB) Circular A-128, Audits of State and Local Governments. Those standards and OMB Circular A-128 require that we plan and perform the audit to obtain reasonable assurance about whether the general purpose financial statements are free of material misstatement and about whether the County complied with laws and regulations, noncompliance with which would be material to a major federal financial assistance program. In planning and performing our audits for the year ended December 31, 1992, we considered the County's internal control structure in order to determine our auditing procedures for the purpose of expressing our opinions on the County's general purpose financial statements and on the County's compliance with requirements applicable to major programs, and to report on the internal control structure in accordance with OMB Circular A-128, and not to provide assurance on the internal control structure. The management of the County is responsible for establishing and maintaining an internal control structure. In fulfilling this responsibility, estimates and judgments by management are required to assess the expected benefits and related costs of internal control structure policies and procedures. The objectives of an internal control structure are to provide management with reasonable, but not absolute, assurance that assets are safeguarded against loss from unauthorized use or disposition, that transactions are executed in accordance with management's authorization and recorded properly to permit the preparation of general purpose financial statements in accordance with generally accepted accounting principles, and that federal financial assistance programs are managed in compliance with applicable laws and regulations. Because of inherent limitations in any internal control structure, errors, irregularities, or instances of noncompliance may nevertheless occur and not be detected. Also, projection of any evaluation of the structure to future periods is subject to the risk that procedures may become inadequate because of changes in conditions or that the effectiveness of the design and operation of policies and procedures may deteriorate. (156) MEMBERS OF AMERICAN INSTITUTE OF CERTIFIED PUBLIC ACCOUNTANTS SEC AND PRIVATE COMPANIES PRACTICE SECTIONS-AICPA DIVISION FOR CPA FIRMS ACCOUNTING FIRMS A¢e!Y'IATED.INC. Board of County Commissioners County of Weld, Colorado Page 2 For the purpose of this report, we have classified the significant internal control structure policies and procedures used in administering federal financial assistance programs in the following categories: Accounting Control& Cash receipts/revenue Property taxes Purchasing/expenditures Payroll Property and equipment General ledger Administrative Controls General Requirements: Specific Requirements: • Political activity • Types of services allowed or not • Davis Bacon Act allowed • Civil rights • Eligibility • Cash management • Matching, level of effort, or • Relocation assistance and real earmarking property acquisition • Reporting • Federal financial reports • Cost allocation • Allowable costs/cost principles • Special requirements • Drug-free workplace • Monitoring subrecipients • Administrative requirements Claims for advances and reimbursements Amounts claimed or used for matching For all of the internal control structure categories listed above, we obtained an understanding of the design of relevant policies and procedures and determined whether they have been placed in operation, and we assessed control risk. Because of the large number of nonmajor programs and the decentralized administration of these programs, we performed procedures to obtain an understanding of the internal control structure policies and procedures relevant to nonmajor programs on a cyclical basis. Our procedures during the current year covered 23% of the nonmajor programs administered by the County as a whole. The nonmajor programs not covered during the current year are expected to be subject to such procedures at least once during a three-year cycle. During the year ended December 31, 1992, the County expended 86% of its total federal financial assistance under major federal assistance programs. (157) Board of County Commissioners County of Weld, Colorado Page 3 We performed tests of controls, as required by OMB Circular A-128, to evaluate the effectiveness of the design and operation of internal control structure policies and procedures that we considered relevant to preventing or detecting material noncompliance with specific requirements, general requirements, and requirements governing claims for advances and reimbursements and amounts claimed or used for matching that are applicable to each of the County's major federal financial assistance programs, which are identified in the accompanying Schedule of Federal Financial Assistance. Our procedures were less in scope than would be necessary to render an opinion on these internal control structure policies and procedures. Accordingly, we do not express such an opinion. Our consideration of the internal control structure policies and procedures used in administering federal financial assistance would not necessarily disclose all matters in the internal control structure that might constitute material weaknesses under standards established by the American Institute of Certified Public Accountants. A material weakness is a condition in which the design or operation of one or more of the internal control structure elements does not reduce to a relatively low level the risk that errors or irregularities in amounts that would be material in relation to the general purpose financial statements being audited or that noncompliance with laws and regulations that would be material to a federal financial assistance program may occur and not be detected within a timely period by employees in the normal course of performing their assigned functions. We noted no matters involving the internal control structure and its operations that we consider to be material weaknesses as defined above. However, we noted certain matters involving the internal control structure and its operation that we have reported to the management of the County in a separate letter dated May 21, 1993. This report is intended for the information of the Board of County Commissioners and others within the County and officials of applicable federal and state agencies. However, this report is a matter of public record and its distribution is not limited. aHaan/ d' aittit014 May 21, 1993 (158) Hello