Loading...
HomeMy WebLinkAbout880507.tiff RESOLUTION RE: ACCEPT COMPREHENSIVE ANNUAL FINANCIAL REPORT OF YEAR ENDED DECEMBER 31 , 1987 WHEREAS, the Board of County Commissioners of Weld County, Colorado, pursuant to Colorado statute and the Weld County Home Rule Charter, is vested with the authority of administering the affairs of Weld County, Colorado, and WHEREAS, the Department of Finance and Administration of Weld County, Colorado, has prepared the Comprehensive Annual Financial Report of the County of Weld, State of Colorado, for the year ended December 31 , 1987, and WHEREAS, after review, the Baord deems it adivsable and in the best interest of Weld County to accept said Financial Report, a copy of which is attached hereto and incorporated herein by reference. NOW, THEREFORE, BE IT RESOLVED by the Board of County Commissioners of Weld County, Colorado, that the Comprehensive Annual Financial Report for the year ended December 31 , 1987, be, and hereby is accepted. The above and foregoing Resolution was, on motion duly made and seconded, adopted by the following vote on the 29th day of June, A.D. , 1988 . ATTEST: (::leczeitet.J BOARD OF COUNTY COMMISSIONERS WELD COUNTY, COLORADO Weld County Clerk and Recorder EXCUSED and Clerk to the /B/ooa/�/rd Gene R..�yLBrantner, Chairman BY ( C.W. irby, P -Tem Deputy County Clerk EXCUSED APPROVED AS TO FORM: Jacquek'n oh r on { G -• ��.�- I ' -, -_ , leAca , County Attorney Frank amaguchi x , o* 880507 4(inni COMPREHENSIVE ;11 ANNUAL � !r, FINANCIAL REPORT COLORADO Year Ended December 31, 1987 COUNTY of WELD STATE of COLORADO COMPREHENSIVE ANNUAL FINANCIAL REPORT COUNTY OF WELD STATE OF COLORADO YEAR ENDED DECEMBER 31 , 1987 Issued by: Department of Finance & Administration Donald D. Warden, Director Finance and Administration 8805' 7 COLORADO INTRODUCTORY SECTION t WI`Dc. COLORADO TABLE OF CONTENTS Page INTRODUCTORY SECTION Table of Contents 1 Letter of Transmittal 7 Government Finance Officers' Association Certificate of Conformance 17 Organization Chart 18 Principal County Officials 19 FINANCIAL SECTION Auditors Report 21 GENERAL PURPOSE FINANCIAL STATEMENTS COMBINED BALANCE SHEET - ALL FUND TYPES AND ACCOUNT GROUPS 24 COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - ALL GOVERNMENTAL FUND TYPES AND EXPENDABLE TRUST FUNDS 26 COMBINED STATEMENT OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL - ALL GOVERNMENTAL FUND TYPES 28 COMBINED STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS/FUND BALANCES - ALL PROPRIETARY FUND TYPES AND PENSION TRUST FUNDS 30 COMBINED STATEMENT OF CHANGES IN CONTRIBUTED CAPITAL 31 COMBINED' STATEMENT OF CHANGES IN FINANCIAL POSITION - ALL PROPRIETARY FUND TYPES AND PENSION TRUST FUNDS 32 NOTES TO FINANCIAL STATEMENTS 33 COMBINING INDIVIDUAL FUND AND INDIVIDUAL ACCOUNT GROUP FINANCIAL STATEMENTS AND SCHEDULES GENERAL FUND BALANCE SHEET 55 Schedule of Revenues and Expenditures, Budget and Actual 56 SPECIAL REVENUE FUNDS EXPLANATIONS OF INDIVIDUAL FUNDS 61 COMBINING BALANCE SHEET 62 COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES 64 1 ('`�j� ,y l I S EA'^.• TABLE OF CONTENTS - (CONTINUED) Page SPECIAL REVENUE FUNDS (Continued) : Road and Bridge Fund - Schedule of Revenues and Expenditures, Budget and Actual 66 Social Services Fund - Schedule of Revenues and Expenditures, Budget and Actual 68 Federal Revenue Sharing Fund - Schedule of Revenues and Expenditures, Budget and Actual 70 Conservation Trust Fund - Schedule of Revenues and Expenditures, Budget and Actual 71 Contingent Fund - Schedule of Revenues and Expenditures, Budget and Actual 72 Public Health Fund - Schedule of Revenues and Expenditures, Budget and Actual 73 Human Resources Fund - Schedule of Revenues and Expenditures, Budget and Actual 74 Solid Waste Fund - Schedule of Revenues and Expenditures, Budget and Actual 76 Housing Authority Fund - Schedule of Revenues and Expenditures, Budget and Actual 77 CAPITAL PROJECTS FUND EXPLANATIONS OF INDIVIDUAL FUNDS 79 BALANCE SHEET 80 Capital Expenditures Fund - Schedule of Revenues and Expenditures, Budget and Actual 81 SPECIAL ASSESSMENT FUNDS EXPLANATIONS OF INDIVIDUAL FUNDS 83 COMBINING BALANCE SHEET 84 COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES 86 Improvement District — Road 5 — Schedule of Revenues and Expenditures, Budget and Actual 88 Improvement District Number 1981-2 Elmore Road Schedule of Revenues and Expenditures, Budget and Actual 89 2 880577 TABLE OF CONTENTS - (CONTINUED) Page SPECIAL ASSESSMENT FUNDS (Continued) : Antelope Hills - Schedule of Revenues and Expenditures, Budget and Actual 90 Indian Head - Schedule of Revenues and Expenditures, Budget and Actual 91 ENTERPRISE FUNDS EXPLANATION OF INDIVIDUAL FUNDS 93 BALANCE SHEET 94 Schedule of Operating Revenue Compared with Estimate 95 Schedule of Non—Operating Revenue Compared with Estimate 95 Schedule of Expenditures Compared with Budget 95 Schedule of Fixed Asset Acquisition Compared with Budget 95 Schedule of Operating Transfers—In Compared with Estimate 96 INTERNAL SERVICE FUNDS EXPLANATIONS OF INDIVIDUAL FUNDS 97 COMBINING BALANCE SHEET 98 COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS 100 COMBINING STATEMENT OF CHANGES IN CONTRIBUTED CAPITAL 102 COMBINING STATEMENT OF CHANGES IN FINANCIAL POSITION 103 Motor Vehicle Fund - Schedule of Operating Revenues Compared with Estimate 104 Motor Vehicle Fund - Schedule of Non-operating Revenues Compared with Estimate 014 Motor Vehicle Fund - Schedule of Operating Expenses Compared with Budget 104 Motor Vehicle Fund - Schedule of Fixed Asset Acquisitions Compared with Budget 104 Printing and Supply Fund - Schedule of Operating Revenues Compared with Estimate 105 Printing and Supply Fund - Schedule of Operating Expenses Compared with Budget 105 Printing and Supply Fund - Schedule of Fixed Asset Acquisitions Compared with Budget 105 3 TABLE OF CONTENTS - (CONTINUED) Page INTERNAL SERVICE FUNDS (Continued) : Computer Services Fund — Schedule of Operating Revenues Compared with Estimate 106 Computer Services Fund — Schedule of Non—Operating Revenues Compared with Estimate 106 Computer Services Fund — Schedule of Operating Expenses Compared with Budget 106 Computer Services Fund — Schedule of Fixed Asset Acquisition Compared with Budget 106 Computer Services Fund - Schedule of Operating Transfers-In Compared with Estimate 106 Insurance Fund — Schedule of Operating Revenues Compared with Estimate 107 Insurance Fund - Schedule of Non-operating Revenues Compared with Estimate 107 Insurance Fund - Schedule of Operating Expenses Compared with Budget 107 PBX Fund - Schedule of Operating Revenues Compared with Estimate 108 PBX Fund - Schedule of Non-operating Revenues Compared with Estimate 108 PBX Fund - Schedule of Operating Expenses Compared with Budget 108 TRUST AND AGENCY FUNDS EXPLANATIONS OF INDIVIDUAL FUNDS 109 COMBINING BALANCE SHEET 110 STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND BALANCES - ALL PENSION TRUST FUNDS 112 STATEMENT OF CHANGES IN FINANCIAL POSITION - ALL PENSION TRUST FUNDS 113 COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - ALL EXPENDABLE TRUST FUNDS 114 North Colorado Medical Center Trust Fund - Schedule of Revenues Compared with Estimate 115 North Colorado Medical Center Trust Fund - Schedule of Expenditures Compared with Budget 115 Health Insurance Fund - Schedule of Revenues Compared with Estimate 116 Health Insurance Fund - Schedule of Expenditures Compared with Budget 116 4 TABLE OF CONTENTS - (CONTINUED) Page TRUST AND AGENCY FUNDS (Continued) : Employee Flexible Spending Fund - Schedule of Revenue 117 Employee Flexible Spending Fund - Schedule of Expenditures 117 COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES -- ALL AGENCY FUNDS 118 GENERAL FIXED ASSETS ACCOUNT GROUP SCHEDULE OF GENERAL FIXED ASSETS - BY SOURCES 119 SCHEDULE OF GENERAL FIXED ASSETS - BY FUNCTION AND ACTIVITY 120 SCHEDULE OF CHANGES IN GENERAL FIXED ASSETS - BY FUNCTION AND ACTIVITY 121 GENERAL LONG-TERM DEBT ACCOUNT GROUP SCHEDULE OF GENERAL LONG-TERM DEBT - BY SOURCES 123 STATISTICAL SECTION General Governmental Expenditures by Function 126 General Revenue by Source 126 Property Tax Levies and Collections 129 Assessed and Estimated Actual Value of Taxable Property 129 Property Tax Rates and Tax Levies - All Overlapping Governments 130 Special Assessment Collections 131 Computation of Legal Debt Margin 132 Tables Relating to Bonded Debt 132 Demographic Statistics 133 Property Value, Construction, Bank Deposits and Other Economic Indicators 134 Principal Taxpayers 135 Miscellaneous Statistics 136 Insurance In Force 138 Salaries of Principal Officials 139 Surety Bond Coverage for Principal Officials 139 Private Purpose Revenue Bonds 140 Retirement Plan Required Information 141 Computation of Overlapping Debt 142 5 loup C. COLORADO 6 ,Serif" `Ointil I DEPARTMENT OF FINANCE AND ADMINISTRATION PHONE(303)356-4000 EXT_4218 P.O. BOX 758 WIIDe. GREELEY,COLORADO 80632 COLORADO April 30, 1988 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 year ended December 31, 1987 is presented on behalf of the Board and published as a public document. This report was prepared by the County's Finance Department. Responsibility for both the accuracy of the presented data and the completeness and fairness of the presentation, including all disclosures, rests with the County. It is believed the data, as presented, is accurate in all material aspects; that it is presented in a manner designed to fairly set forth the financial position and results of operations of the County as measured by the financial activity of the various funds; and that all disclosures necessary to enable the reader to gain the maximum understanding of the County's financial activity have been included. ACCOUNTING SYSTEM AND BUDGETARY CONTROL The County's accounting records for general governmental operations are maintained on a modified accrual basis, with revenue being recorded when available and measurable and expenditures being recorded when the services or goods are received and the liabilities are incurred. Accounting records for the proprietary funds and fiduciary pension trust funds are maintained on the accrual basis. In developing and modifying the County's accounting system, consideration is given to the adequacy of internal accounting controls. Internal accounting controls are designed to provide reasonable, but not absolute, assurance regarding: the safeguarding of assets against loss from unauthorized use or disposition, and the integrity of financial records for preparing financial statements and maintaining accountability for assets. 7 Honorable Board of Commissioners - Continued: The concept of reasonable assurance recognizes: the cost of a control should not exceed the benefits likely to be derived, and the evaluation of costs and benefits requires estimates and judgements by management. All internal control evaluations occur within the above framework. It is believed that the County's internal accounting controls adequately safeguard assets and provide reasonable assurance of proper recording of financial transactions. Budgetary control is maintained at the department level by the encumbrance of estimated purchase amounts prior to the release of purchase orders to vendors. Purchase orders which result in an overrun of department balances are not released until additional appropriations are made available. Open encumbrances are reported as a reservation of fund balance at December 31, 1987. Development of the new accounts receivable system was initiated in 1987 and will be completed in 1988. 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 auditing system was used for the preparation of schedules used in the annual audit and in the preparation of the financial statements. THE REPORTING ENTITY AND ITS SERVICES 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. Control or dependence is determined on the basis of budget adoption, taxing authority, funding, scope of public service, ability to influence operation, 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. ffCf "'? 8ta.,. Honorable Board of Commissioners - Continued: 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 Health Fund, a Special Revenue Fund. Weld County Retirement Board -- The Retirement Board consists of five members, four appointed by the Board of County Commissioners and the fifth being the elected County Treasurer. The county funds half of the retirement program 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. The following organizations are not part of Weld County and are excluded from the accompanying financial statements: North Colorado Medical Center -- The Board of County Commissioners appoints a seven member Hospital Board of Trustees that in turn appoints five of the eleven Normedco Board of Directors. Normedco is a holding company of which the North Colorado Medical Center (NCMC) is a non-profit subsidiary operating the operating the hospital. The county commits minimal capital funds annually (less than 1% of the total NCMC revenues for 1986) . 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. 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. GENERAL GOVERNMENT FUNCTIONS Revenue for general government functions including General, Special Revenue, Capital Projects, Special Assessment, and Expendable Trust Funds totaled $49, 103, 114 in 1987, an increase of 5.7% over 1986. 9 Honorable Board of Commissioners - Continued: General property taxes and specific ownership taxes produced 38.4% of general revenue compared to 38.5% in 1986. The amount of revenue from various sources and the increases over 1986 are shown in the following tabulation: Increase (Decrease) Revenue Sources Amount Per Cent of Total for 1987 Taxes $18,846,835 38.4% $ 958,173 Licenses and Permits 613,026 1.2% 31 ,666 Intergovernmental Revenue 20,789,309 42.3% 68,320 Charges for Services 1 , 149,717 2.3% (592,933) Fines and Forfeits 76,465 0.2% 9,267 Miscellaneous Revenue 5,915,868 12.0% 2,140,724 Fee Accounts 1,711,894 3.6% 31 ,538 Total $49,103,114 100.0% $ 2,646,755 The mill levy for property taxes collected in 1987 is 19.860, up .518 from 1986. The assessed valuation of $906,609,900 shows an increase of $20,045,650 or 2.26%. The increase in assessed value is principally attributable to reappraisal of property. Only $7,129,680 of the increase in assessed valuations is attributable to new construction. As described in the Prospects for the Future Section of this letter, oil and gas valuations are expected to stabilize without growth in future years. Current tax collections were 98.6% of the tax levy, down 0.6% from 1986. Delinquent tax collections were $296,802 compared with $84,065 in 1986. Allocations of property tax by purpose for 1987 and the preceding year are shown as follows: 6rberval 10 Honorable Board of Commissioners - Continued: 1987 1986 Purpose Mills Mills General Fund 11.714 11.466 Special Revenue Funds 7.296 6.342 Capital Project Funds . 286 .629 Expendable Trust Funds 0.000 .329 Intergovernmental Service Funds .564 .576 Total Tax Rate 19.860 19.342 Intergovernmental Revenue represented 42.3% of total general governmental revenue, compared with 44.6% for 1986. Expenditures for general governmental purposes including General, Special Revenue, Capital Projects, Special Assessment, and Expendable Trust Funds total $49, 127,728, an increase of 9.8% over 1986. Increases in levels of expenditures for major functions of the County over 1986 are shown in the following tabulation: Per Cent Increase ( Decrease) Expenditure Purpose Amount of Total for 1986 Current Operating: General Government $ 6,819,165 13. 9% $ 293,572 Public Safety 6,924,599 14.1% (571,533) Public Works 9,876,346 20. 1% 1,370,607 Public Health & Welfare 14,789,034 30.2% 128,532 Culture & Recreation 244,171 0.5% (21, 181) Conservation of Natural Resources -0- 0.0% (6,025) Economic Assistance 4,491 ,411 9. 1% 437,928 Capital Outlay 1,637,272 3.3% 561 ,892 Debt Service 200,263 0.4% (52,490) Inteagovernmental Expenditures 594,982 1.2% 106,863 Miscellaneous 3,550,550 7.2% 2,148,704 Total $49,127,728 100.0% $4,396,804 ! C.r3n,^-y 11 Honorable Board of Commissioners - Continued: In 1987 Weld County, like many local governments across the nation, has found it more difficult to make financial ends meet. Balancing the annual budget continued to be an arduous task, as resources fail to keep pace witthe public's increasing expectations. In 1987 Weld County had to cope with: . The reduction and termination of several federal and state grant programs . State service mandates without adequate new funding . Rapid demographic, economic, and technological change . Intrusive and paralyzing legislative prescriptionsin respect to organization, administration, procedures and finance . Deteriorating physical infrastructure . The increasing number of persons unable to "make it" on their own without benefit of human services . The complex initiatives required to foster area economic development and to improve quality of life . The relentless demand of citizens for services without higher taxes. . A weak local economy The local economy in 1987 continued to be plagued by the poor agricultural economy and the economy was adversely impacted by the drop in oil and gas prices. As a result, unemployment locally was higher than the state and national averages. Factors positively impacting Weld County in 1987 were low infation rates, eclining petroleum ilding related lrevenu s, and increased fees from el t ectedofficials'u activity offices. Unreserved fund balance and retained earnings in the major operating funds were maintained at adequate levels. The General Fund fund balance of Spe0cia0l9Rewas dwn venueoFundslwas9 from up from last year. The the previous year3by41 balance in the 6.8%. DEBT ADMINISTRATION In 1987 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 twenty-seven million dollar allowable debt capacity in accordance with Colorado State Statutes. There is a lease/purchase agreement which involves two phone systems totalling $190,481 and a Certificate of Participation Bond Issue for the construction of a library and classrooms in Southern Weld County totalling $317,000. qnp T "^J 12 Honorable Board of Commissioners - Continued: 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 Federal Revenue Sharing Fund, Insurance Fund, Health Insurance Fund, Antelope Hills Trust Fund, and the interest earned on certain deposits held for other taxing authorities. The amount of interest earned was $1 ,409,175 in 1987. CAPITAL PROJECT FUNDS The Capital Expenditure 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. Major projects in that plan pending at the end of 1987 include the construction of a new Human Resources building and other North site development. 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 Internal Service Funds. As of December 31, 1987, the General Fixed Assets of the County amounted to $24,294,708. This amount represents the original cost of the assets and is considerably less than their present value. Depreciation of General Fixed Assets is not recognized in the County's accounting system. PROSPECTS FOR THE FUTURE The slow Weld County economy will limit new revenue growth in 1988. The slow economy will affect interest revenues and the collection of the many user fees that the County relies on to fund programs. The local economic conditions with unemployment in the 7% range causes higher utilization of the County's human service agencies. While we applaud efforts to reduce the national deficit, it is important to realize that reducing the deficit will affect Weld County. Federal grant reductions and spending caps for County programs impact in social services, health, and criminal justice. The County must make sure it carefully evaluates which federally sponsored programs it wishes to continue if federal assistance to these programs is reduced or eliminated. If we continue to fund these programs, we must operate them as efficiently as possible. 13 C r^,- J Honorable Board of Commissioners - Continued: During the 1987 legislative session, the State Legislature passed legislation that will reduce the amount of revenue the County will receive in future years in a number of areas. The loss of $617,000 from the Highway Users' Tax Fund was by far the most significant. It is important to take note of the fact that while the State continues to place demands on the County, the legislature continues to limit the funds the County receives to operate. This dilemma must be corrected. High on the list of County priorities should be to insure that the State of Colorado meets its financial obligations to the County. While one must realize that the State has revenue limitations of its own, the legislature's priority must be to pay the State's bills as mandated by law or allow the County to reduce the services it provides in the name of the State. Examples are housing of state prisoners in the County jail without payment, foster care program expansion, dust abatement requirements, and unfortunately the list could go on longer. Although Weld County experienced the beginning of these negative changes in the economic pattern during the 1985-86 period, the economic trend took a positive upturn in 1987 in other areas of the economy that continues today. Developments in 1987 set the stage for a strong industrial/commercial growth market in 1988. Over 1 ,500 new jobs and $155 million in industrial and commercial developments were announced during the year. Among the larger developments announced were: 1) Construction of a $75-$100 million combined carbon dioxide, high temperature water distribution, and co-generation facility in Ft. Lupton by Thermo Carbonics, Inc. They will employ 250-300 during the 2-year construction phase, and 50-75 permanent employees thereafter; 2) The $1.6 million, 20,000 sq. ft. office building Monfort of Colorado (ConAgra) constructed to house Swift personnel recently merged with Monfort. This merger added 60-75 local jobs; 3) The new StarPak, Inc. packaging/distribution and software manufacturing operation which is projected to employ 450 over the next two years; 4) A new $1.6 million manufacturing facility for Electronic Fab Technology Corp. which could add 80-100 jobs; 5) The aluminum can manufacturing operation by Metal Container Co. in Windsor, adding approximately 100 jobs; and 6) A new $5.0 million lamb packing plant to bebuilt by ConAgra that will employee 150-200 people. The success Weld County has experienced in part, is due to a variety of factors, a few of which include: - A stable and diversified economy. In 1986, Weld County ranked 4th nationally in the value of its agricultural products, 1st in the seven Rocky Mountain states in oil and gas exploration activity, and 3rd in Colorado in the value of its manufactured products (slightly over $1 billion) . - Weld County has experienced continued, steady population growth realizing a real compounded annual growth rate of approximately 2.3%. 14 Honorable Board of Commissioners - Continued: - County and city governments are aggressively pro-business, offering planned industrial properties and attractive incentive programs. - Weld County's labor force is well trained and our employees represent a solid Midwestern work ethic. - 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 I-80) . Fourteen motor freight firms and three railroads provide freight service. Commercial air service is provided by 18 carriers operating from Stapleton Airport to 186 cities and 9 countries; the airport is an hour's drive from the county's population centers. - Weld County will be only 15 miles from the site of the new Denver airport, and can expect some positive economic spin-off from it. The above good news is important because the oil and gas industry is a significant part of our economy. The performance of the oil and gas industry is a major concern for Weld County and demonstrates the need for economic diversification. Lower oil and gas prices are a mixed blessing for Weld County. Fuel and petroleum product costs are anticipated to be down in 1988 providing savings to our road program and heavy vehicle user departments. However, revenue sources from royalties and tax assessments will also be down. substantially. Current Niobrara-Codell formation oil production amounts to approximately 54% of the County's production. The production from these zones has peaked and is beginning to decline due to the slowdown in drilling activity. The County decline is currently being affected by the Sooner and Lilly Field discoveries. Current Niobrara-Codell gas overproduction has resulted in higher line pressure resulting in older wells being shut-in. The degree of impact is presently not known but will most likely result in a drilling slowdown. Future production projections from the State Oil and Gas Commission for Weld County are as follows: 1988 1989 1990 1991 1992 OIL (BBLS) 6,125,000 6,880,000 6,682,000 6,623,000 6,570,000 GAS (MCF) 65,900,000 69,350,000 71,540,000 71 ,900,000 72,000,000 15 Honorable Board of Commissioners - Continued: 1987 is a new base year with property tax assessments moving from 1977 values to 1983 values. The new base year, coupled with the decline in oil and gas assessed values caused dramatic property tax shifts among classes of property. With the public's sensitivity to property taxes already, the result has been an adverse taxpayers' reaction locally and statewide. The possibility of four constitutional ballot issues dealing with property taxes on the November, 1988 election exists. Such a taxpayers revolt could further aggravate state and local governments' budgets. 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. This requirement has been complied with and the auditors report has been included in this report. 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 1987 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, 1987. 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. ReCectfully submitted, dill4 ititilk—' Donald D. Warden, Director Finance and Administration DDW/ch 16 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, 1986 A Certificate of Achievement for Excellence in Financial Reporting is presented by the Government Finance Officers Association of the United States and Canada to governmental units and public employee retirement systems whose comprehensive annual financial reports (CAFR's) are judged to substantially conform to program standards. we ATo74R5�N President tileftleA coRrottnos ///� 'O�\lea UJr//{ /V/ 'ridge twat Executive Director perr;r_^, Ci�.'4_i :'. : .. 17 v sg 00 8 ZW 9 W Y W E u ' N .o m - " c i W ka Y w Y u G N is J i a. N IA � V ., ,+ W .. ,: C 4 J a o Yi. u .+ u. f v u a s m u. F V z• U• 0.1 "l O•— —'�' • T T T Z I — WCO m a o a m a G C .-4 J., (CO oG v a U Y J CO 0 9 N C U E f>i i. r 0 O Q • Y CO > O coY RE V 4 U r w 6 U V O N O A' O Z d . • y co co Y TI TI u� c m Q.+ to I. CU II 3 N¢ n CC 0 N C u 11 J u c . U.44 u 6e Wa v or • 0 0% Ew .. u 0 O +.m 0 ++ .+= r O U ; :JU ULUO I O — O IX o 0 p0 G G a F. TCI O C O a I- F N my Y C /VR 'r. C C +I U E N G 6 'O 'O .8.... TI C a co +. ' '. Cl)cc A. o r 0 C. J a w 0 W (A N V W N c o 0u b 6 U J O CO 1.i O m m O gig W c cc o c E 0 'Y. m NJ W O eta u G• Y C w C a L O N • Y N F -4 0 0 u Ca II N Q U J 0 O f. C O CO jp Ta .. wmmw = c» C CC O IA W5 >- 3 0 — i� ii- Z - C a m N c C • w a 6 00 0 a w v • r a CO .-a • Y O C °0 C • m b m 2 V 6. "• o U " 1f1 c W co 0 0 ` a Y 01 N 6 0 °+ 0 ti • 0 u a E 00 `- Ill' E 0 Z D GU 9 H N N N Y y 'O O mau Y a R 44r a U Ca o m T. N N O UP 9 Y 0+ Y v OO 0 O Ca 9 J 0 U O u_ CO u ei m v v J Y V z s n a s 0 J c r 5 u u m a 4.45N .,I o N .-I .�I CO Ca 'O .'4 0 6 CO u. Q Z v N d a s E E ¢ O O 7 U . U J C . . O J 6 E - - v ° O U J . W > Y > I 11 01 CO z u 'a Tat M Y ula O d O CO `�. CO C C III u C 00 0 N C G O +. G '00 0 'O W 70 8 V U ♦-I N 9 q •0 G u CO .i .. W J W 0 Lc Q C E L u 1. .C a 11 u +1. > 0 C u L ac Ca E ( 0 0 V U u 1. N 0 O U u C C co O u co J 1. O IC 0 U 0 . U C D _ O C L C .Ca �.A n� 0. -1 U — u W , u 14 Y C Y N 6 L. .-I a `. & O i. M .+ Y C 0 00 > C C C OE U C 0 I. .Gi 6 m E 0 W 01 4. 011) .Cy W O C U 6 u m ow .M U 2 N d r 6 u C U '+. C. 7 J Ca C 6 1/� E • ; C N m = 18 oOc� d . — — — — -8805'27 COUNTY OF WELD STATE OF COLORADO PRINCIPAL COUNTY OFFICIALS December 31, 1987 Board of County Commissioners Gordon E. Lacy Gene Brantner Jacqueline Johnson C. W. Kirby Frank Yamaguchi County Treasurer Francis M. Loustalet County Clerk and Recorder Mary Ann Feuerstein County Assessor Dick Kiernes County Sheriff Ed Jordan County Coroner Paul Stoddard Director of Finance and Administration Donald D. Warden Comptroller Claud Hanes Independent Auditor Deloitte Haskins and Sells Certified Public Accountants 19 88C 5 re7 tana Wilk COLORADO 20 FINANCIAL SECTION 4tiff :r WII'Dc. COLORADO Deloi tte Haskins+Sells 1560 Broadway, Suite 1800 One Civic Center Plaza Denver, Colorado 80202-5151 (303) 837-3000 ITT Telex: 4995604 Board of County Commissioners County of Weld, Colorado Greeley, Colorado We have examined the general purpose financial statements of the County of Weld, Colorado as of and for the year ended December 31 , 1987 as listed in the table of contents. Our examination was made in accordance with generally accepted auditing standards and, accordingly, included such tests of the accounting records and such other auditing procedures as we considered necessary in the circumstances. In our opinion, the general purpose financial statements referred to above present fairly the financial position of the County of Weld, Colorado at December 31 , 1987, and the results of its operations and the changes in financial position of its proprietary fund types and pension trust fund for the year then ended, in conformity with generally accepted accounting principles applied on a basis consistent with that of the preceding year. Our examination was made for the purpose of forming an opinion on the general purpose financial statements taken as a whole. The combining individual fund and individual 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 of Weld, Colorado. Such information has been subjected to the auditing procedures applied in the examination of the general purpose financial statements and, in our opinion, is fairly stated in all material respects when considered in relation to the general purpose financial statements taken as a whole. Our examination did not include the information presented in the Statistical section and, accordingly, we express no opinion on it. DELOITTE HASKINS AND SELLS Denver, Colorado May 20, 1988 21 ,,CFAC " A ;T COLORADO 22 GENERAL PURPOSE FINANCIAL STATEMENTS COLORADO COUNTY OF WELD STATE OF COLORADO COMBINED BALANCE SHEET - ALL FUND TYPES AND ACCOUNT GROUPS December 31, 1987 Governmental Fund Types Special Capital Special General Revenue Projects Assessment ASSETS ASSETS: Cash and short term investments $ 3,373,743 $ 5,013,514 $ 1,514,833 $ 53,754 Cash - other 28,125 940,152 3,925 0 Investments 0 0 0 0 Receivables (net of allowance for uncollectibles): Current property tax 11,247,635 6,614,857 532,000 0 Delinquent property tax 182,377 107,662 5,255 0 Accounts 171,904 284,075 1,030 0 Special assessments 0 0 0 902,271 Due from other county funds 142,229 188,170 80 8,749 Due from other governmental units 220,519 1,990,944 0 0 Advances to other funds 107,271 75,000 0 0 Inventories 31,339 740,778 0 0 Amount to be provided for retirement of general long-term debt 0 0 0 0 Prepaid and other assets 46,232 59,787 0 0 Land 0 0 0 0 Buildings 0 0 0 0 Improvements other than buildings 0 0 0 0 Machinery and equipment 0 0 0 0 Accumulated depreciation 0 0 0 0 TOTAL ASSETS $ 15,551,374 $ 16,014,939 $ 2,057,123 $ 964,774 LIABILITIES AND FUND BALANCE LIABILITIES: Voucher and warrants payable $ 153,084 $ 427,704 $ 60,397 $ 0 Accrued liabilities 580,658 439,681 1,675 0 Due to other governments 15,075 1,474,278 0 0 Due to other county funds 376,480 579,697 80 8,749 Deferred revenue 11,407,008 6,809,591 537,255 823,850 Unexpended grant revenue 100,391 1,261,659 0 0 Other liabilities 0 69,936 0 0 Advance from other funds 0 0 0 102,271 Retainage payable 0 0 72,014 0 Bonds payable 1,905,000 0 0 700,000 General long term debt 0 0 0 0 Deferred compensation payable 0 0 0 0 Total Liabilities $ 14,537,696 $ 11a6 $ 671,421 $ 1,634,870 FUND EQUITY: Contributed capital $ 0 $ 0 $ 0 $ 0 Retained earnings 0 0 0 0 Investment in fixed assets 0 0 0 0 Fund Balances: Reserved 213,169 1,406,862 144,351 0 Unreserved: Designated for subsequent year's expenditures 190,108 1,115,348 1,241,351 0 Undesignated 610,401 2,430,183 0 (670,096) Total Fund Equity (deficit) S 1,013,678 $ 4,952,393 $ 1,385,702 $ (670,096) TOTAL LIABILITIES AND FUND EQUITY $ 15,551,374 $ 16,014,939 $ 2,057,123 $ 964,774 See Notes to Financial Statements COLORADO Proprietary Fiduciary Fund Type Fund Type Account Groups Memorandum Total Enterprise Internal Trust and General General December 31 December 31 Fund Service Agency Fixed Assets Long Term Debt 1987 1986 $ 67,904 $ 1,457,062 $ 7,399,752 $ 0 $ 0 $ 18,880,562 $ 18,774,571 O 7,500 127,395 0 0 1,107,097 65,131 0 0 20,532,162 0 0 20,532,162 20,314,295 O 511,095 0 0 0 18,905,587 18,005,321 O 8,954 1,965 0 0 306,213 404,559 208,713 55,239 264,448 0 0 985,409 856,411 O 0 0 0 0 902,271 1,006,758 90,415 595,562 4,898 0 0 1,030,103 676,621 O 0 0 0 0 2,211,463 2,269,202 O 0 0 0 0 182,271 186,758 O 147,591 0 0 0 919,708 1,044,913 0 0 0 0 1,532,630 1,532,630 1,254,028 0 203,305 58,770 0 0 368,094 298,405 0 712,970 0 2,095,212 0 2,808,182 2,283,332 0 750,220 0 18,428,653 0 19,178,873 19,435,227 0 19,345 0 230,920 0 250,265 237,356 31,717 11,750,493 0 3,539,923 0 15,322,133 14,197,521 (6,476) (7,001,654) 0 0 0 (7,008,130) (6,307,340) $ 392,273 1.21,22_,___.7682 $ 28,389,390 $ 24,294,708 $ 1,532,630 $ 98,414,893 $ 95,003,069 $ 6,999 S 778,024 $ 738,156 $ 0 S 0 $ 2,164,364 $ 1,560,181 66,856 160,294 0 0 0 1,249,164 1,111,335 O 0 3,143,978 0 0 4,633,331 4,792,509 39,904 16,491 8,702 0 0 1,030,103 676,619 O 550,030 1,965 0 0 20,129,699 19,440,361 0 0 -0 0 0 1,362,050 1,283,881 0 0 0 0 0 69,936 70,536 0 80,000 0 0 0 182,271 186,758 O 0 0 0 0 72,014 25,440 O 0 0 0 317,000 2,922,000 2,250,000 0 0 0 0 1,215,630 1,215,630 1,254,028 O 0 663,105 0 0 663,105 509,526 $ 113,759 $ 1,584,839 $ 4,555,906 $ 0 $ 1,532,630 $ 35,693,667 $ 33,161,174 $ 19,762 $ 5,784,501 $ 0 $ 0 $ 0 $ 5,804,263 $ 5,712,895 258,752 1,848,342 0 0 0 2,107,094 1,865,122 O 0 0 24,294,708 0 24,294,708 23,593,310 O 0 20,121,067 0 0 21,885,449 22,967,874 0 0 0 0 0 2,547,292 1,421,987 0 0 3,712,417 0 0 6,082,420 6,280,707 1-171221i. $ 7,632,843 $ 23,833,484 $ 21S-1. 70$ $ 0 $ 62,721,226 $ 61,841,895 $ 392,273 $ 9,217,682 $ 28,389,340 $ 24,294,708 $ 1,532,630 $ 98,414,893 $ 95,003,069 25 esos y COUNTY OF WELD STATE OF COLORADO COMBINED STATEMENT OF REVENUES EXPENDITURES AND CHANGES IN FUND BALANCES - ALL GOVERNMENTAL FUND TYPES AND EXPENDABLE TRUST FUNDS December 31, 1987 Governmental Fund Types Special Capital Special General Revenue Projects Assessment REVENUES: Taxes $ 10,793,324 $ 7,770,984 $ 280,150 $ 0 Licenses and permits 382,707 230,319 0 Intergovernmental revenue 879,166 19,910,143 0 0 Charges for services 451,484 692,078 6,155 0 Fines and forfeitures 76,465 0 0 0 Miscellaneous revenue 1,056,616 173,156 2,027,000 199,907 Fee accounts 1,711,894 0 0 0 Earnings on investments 1,052,991 0 1,030 0 Total Revenues 16,404,647 28,776,680 2,314,335 199,907 EXPENDITURES: Current Operating: 0 $ 0 General government $ 6,819,165 $ 0 $ Public safety 6,924,599 0 0 0 Public works 522,724 9,353,622 0 0 Public health and welfare 124,536 14,664,498 0 0 Miscellaneous 273,702 138,837 17,298 0 Culture and recreation 95,710 148,461 0 0 Conservation of natural resources 0 0 0 0 Economic assistance 0 4,491,346 0 0 Capital outlay 348,145 246,166 1,034,212 8,749 Debt service 126,088 0 1,675 72,500 Intragovernmental 0 594,982 0 0 Total Expenditures 15,234,669 29,637,912 1,053,185 81,249 EXCESS OF REVENUES OVER (UNDER) EXPENDITURES 1,169,978 (861,232) 1,261,150 118,658 OTHER FINANCING SOURCES (USES): Operating transfers - in $ 108,393 $ 2,129,550 $ 0 $ 1,693 Operating transfers - out (1,285,193) (1,164,481) 0 0 Total Other Financing Sources (Uses) (1,176:800) 965,069 0 1,693 EXCESS OF REVENUES AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES (6,822) 103,837 1,261,150 120,351 FUND BALANCE (DEFICIT) AT BEGINNING OF YEAR 1,149,280 4,848,556 124,552 (790,447) Equity Transfers to Other Funds (128,780) 0 0 0 FUND BALANCE (DEFICIT) AT END OF YEAR $ 1,013,678 $ 4,952,393 $ 1,385,702 $ (670,096) See Notes to Financial Statements SSCEW7 26 Fiduciary Fund Types Memorandum Total Expendable December 31 December 31 Trust 1987 1986 $ 2,377 $ 18,846,835 $ 17,888,662 O 613,026 581,360 O 20,789,309 20,720,989 O 1,149,717 1,742,650 O 76,465 67,198 1,050,014 4,506,693 2,231,622 O 1,711,894 1,680,356 355,154 1,409,175 1,543,522 1,407,545 49,103,114 46,456,359 $ 0 $ 6,819,165 $ 6,516,851 0 6,924,599 7,272,935 O 9,876,346 8,505,739 O 14,789,034 14,660,502 3,120,713 3,550,550 1,401,846 O 244,171 265,352 O 0 6,025 0 4,491,346 3,962,816 0 1,637,272 1,397,988 O 200,263 252,753 O 594,982 488,119 3,120,713 49,127,728 44,730,926 (1,713,168) (24,614) 1,725,433 $ 0 $ 2,239,636 $ 3,347,991 0 (2,449,674) (3,351,695) 0 (210,038) (3,704) (1,713,168) (234,652) 1,721,729 5,217,620 10,549,561 8,827,832 O (128,780) 0 $ 3,504,452 $ 10,186,129 $ 10,549,561 27 e8Ov^,7 COUNTY OF WELD SPATE OF COLORADO COMBINED STATEMENT OF REVENUES AND EXPENDITURES BUDGET AND ACTUAL - ALL GOVERNMENTAL FUND TYPES December 31, 1987 General Special Revenue Variance Variance Estimate/ Favorable Estimate/ Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) REVENUES: Taxes $ 10,710,080 $ 10,793,324 $ 83,244 $ 7,994,029 $ 7,770,984 S (223,045) Licenses and permits 395,005 382,707 (12,298) 100,750 230,319 129,569 Intergovernmental 814,325 879,166 64,841 21,631,736 19,910,143 (1,721,593) Charges for services 454,764 451,484 (3,280) 233,725 692,078 458,353 Fines and forfeitures 28,645 76,465 47,820 0 0 0 Miscellaneous 928,306 1,056,616 128,310 1,600 173,156 171,556 Fee accounts 1,731,843 1,711,894 (19,949) 0 0 0 Earnings on investments 1,202,270 1,052,991 (149,279) 0 0 0 Total Revenues 16,265,238 16,404,647 139,409 29,961,840 28,776,680 (1,185,160) EXPENDITURES: Current Operating: General government S 7,023,669 $ 6,819,165 $ 204,504 $ 0 $ 0 $ 0 Public safety 7,158,485 6,924,599 233,886 0 0 0 Public works 546,138 522,724 23,414 10,735,112 9,353,622 1,381,490 Public health and welfare 124,536 124,536 0 15,368,729 14,664,498 704,231 Miscellaneous 373,173 273,702 99,471 242,911 138,837 104,074 Culture and recreation 32,005 95,710 (63,705) 182,301 148,461 33,840 Economic assistance 0 0 0 4,972,196 4,491,346 480,850 Capital outlay 389,449 348,145 41,304 17,250 246,166 (228,916) Debt service 126,089 126,088 1 0 0 0 Intragovernmental 0 0 0 607,525 594,982 12,543 Total Expenditures 15,773,544 15,234,669 538,875 32,126,024 29,637,912 2,488,112 EXCESS OF REVENUES OVER (UNDER) EXPENDITURES 491,694 1,169,978 678,284 (2,164,184) (861,232) 1,302,952 OTHER FINANCING SOURCES (USES): Operating transfers - in $ 108,192 $ 108,393 $ 201 $ 717,240 $ 2,129,550 $ 1,412,310 Operating transfers - out (1,196,127) (1,285,193) (89,066) (1,036,113) (1,164,481) (128,368) Total Other Financing Sources (Uses) (1,087,935) (1,176,800) (88,865) (318,873) 965,069 1,283,942 EXCESS OF REVENUE AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES $ (596,241) $ (6,822) $ 589,419 $ (2,483,057) $ 103,837 $ 2,586,894 See Notes to Financial Statements 28 58051.1 Capital Projects Special Assessments Memorandum Totals Variance Variance Variance Estimate/ Favorable Estimate/ Favorable Estimate/ Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) Budget Actual (Unfavorable) $ 277,491 $ 280,150 $ 2,659 $ 0 $ 0 $ 0 $18,981,600 $18,844,458 $ (137,142) 0 0 0 0 0 0 495,755 613,026 117,271 O 0 0 0 0 0 22,446,061 20,789,309 (1,656,752) 0 6,155 6,155 0 0 0 688,489 1,149,717 461,228 0 0 0 0 0 0 28,645 76,465 47,820 2,009,500 2,027,000 17,500 206,369 199,907 (6,462) 3,145,775 3,456,679 310,904 O 0 0 0 0 0 1,731,843 1,711,894 (19,949) O 1,030 1,030 0 0 0 1,202,270 1,054,021 (148,249) 2,286,991 2,314,335 27,344 206,369 199,907 (6,462) 48,720,438 47,695,569 (1,024,869) $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 7,023,669 $ 6,819,165 $ 204,504 0 0 0 0 0 0 7,158,485 6,924,599 233,886 O 0 0 0 0 0 11,281,250 9,876,346 1,404,904 0 0 0 0 0 0 15,493,265 14,789,034 704,231 O 17,298 (17,298) 0 0 0 616,084 429,837 186,247 O 0 0 0 0 0 214,306 244,171 (29,865) O 0 0 0 0 0 4,972,196 4,491,346 480,850 1,294,879 1,034,212 260,667 8,750 8,749 1 1,710,328 1,637,272 73,056 O 1,675 (1,675) 184,750 72,500 112,250 310,839 200,263 110,576 O 0 0 0 0 0 607,525 594,982 12,543 1,294,879 _12.2...2A2.11 -21..W.212 193,500 81,249 112,251 49,387,947 46,007,015 3,380,932 992,112 1,261,150 269,038 12,869 118,658 105,789 (667,509) 1,688,554 2,356,063 $ 0 $ 0 $ 0 $ 1,694 $ 1,693 $ (1) $ 827,126 $ 2,239,636 $ 1,412,510 0 0 0 0 0 0 (2,232,240) (2,449,674) (217,434) 0 0 0 1,694 1,693 (1) (1,405,114) 03(210, 8) 1,195,076$ 992,112 u,261,150 $ 269,038 $ 14,563 $ 120,351 $ 105,788 $(2,072,623) $ 1,478,516 L1,211.2111 29 S h r,ra•7 COUNTY OF WELD STATE 011 COLORADO COMBINED STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS/ FUND BALANCES - ALL PROPRIETARY FUND TYPES AND PENSION TRUST FUNDS December 31, 1987 Proprietary Fiduciary Fund Type Fund Type Memorandum Total Enterprise Internal Pension December 31 December 31 Fund Service Trust 1987 1986 OPERATING REVENUE: Change in unrealized appreciation(depreciation) in fair market value of investments $ 0 $ 0 S (2,369,532) $ (2,369,532) $ (507,173) Contributions 0 0 1,675,355 1,675,355 1,487,861 Charges for services 1,192,479 5,087,987 0 6,280,466 4,588,229 Total Operating Revenue 1,192,479 5,087,987 (694,177) 5,586,289 5,568,917 OPERATING EXPENSES: Personnel services $ 675,916 $ 1,349,791 $ 0 $ 2,025,707 $ 1,319,135 Contractual services 36,592 1,629,259 0 1,665,851 1,451,478 Supplies 31,830 409,080 0 440,910 340,802 Heat, light, and power 6,885 229,945 0 236,830 238,610 Repair and maintenance 88,629 243,474 0 332,103 224,723 Insurance and bonds 15,000 478,669 0 493,669 372,345 Claims 0 285,647 0 285,647 132,136 Other expenses 313,477 10,708 0 324,185 35,391 Benefit Payments 0 0 602,568 602,568 464,517 Refunds 0 0 230,810 230,810 246,809 Administrative 0 0 108,459 108,459 116,852 Depreciation 6,928 1,273,850 0 1,280,778 1,245,277 Total Operating Expenses 1,175,257 5,910,423 941,837 8,027,517 6,188,075 OPERATING INCOME (LOSS) 17,222 (822,436) (1,636,014) (2,441,228) (619,158) NON-OPERATING REVENUE (EXPENSE): Taxes $ 0 $ 548,693 $ 0 $ 548,693 $ 546,921 Miscellaneous revenue 2,712 108 0 2,820 0 Farm income 0 1,803 0 1,803 2,807 Gaini (loss) on sale of assets 0 89,807 0 89,807 11,329 Earnings on investments 0 22,320 1,844,039 1,866,359 3,143,580 Interest expense 0 (17,303) 0 (17,303) (20,094) Judgements and damages 0 60,228 0 60,228 30,492 Total Non-Operating Revenue (Expense) 2,712 705,656 1,844,039 2,552,407 3,715,035 OTHER FINANCING SOURCES: Operating transfers - in $ 110,038 $ 100,000 $ 0 L___219.2221 .1_1222_4 NET INCOME (LOSS) 129,972 (16,780) 208,025 321,217 3,099,581 RETAINED EARNINGS/FUND BALANCE AT BEGINNING OF YEAR 0 1,865,122 20,121,007 21,986,129 18,886,548 Equity Transfer From Other Funds 128,780 0 0 128,780 0 RETAINED EARNINGS/FUND BALANCE AT END OF YEAR $ 258,752 $ 1,848,342 $ 20,329,0l% $ 22,436,126 $ 21,986,129 See Notes to Financial Statements 8O5 Y 30 COUNTY OF WELD STATE OF COLORADO PROPRIETARY FUNDS COMBINED STATEMENT OF CHANGES IN CONTRIBUTED CAPITAL December 31, 1987 Internal Service Enterprise Funds Fund Total CONTRIBUTED CAPITAL 0 $ 5,712,895 January 1, 1987 $ 5,712,895 $ Add: 1987 contributions from other funds 71,606 19,762 91,368 CONTRIBUTED CAPITAL, December 31, 1987 §-5-11.81s--. 501 $ 19,762 $ 5,804,263 31 r^n.-7 COUNTY OF WELD sTATE OF COLORADO COMBINED STATEMENT OF CHANGES IN FINANCIAL POSITION - An Pff0 k1ERAV FUND 'TYPES AND PER§IaR TRVf5 Fink December 31, 1987 Fiduciary Memorandum Proprietary Fund Type Fund Type Total Internal Enterprise Pension December 31 December 31 Service Fund Trust 1987 1986 WORKING CAPITAL PROVIDED: Net Income (loss) $ (16,780) $ 129,972 $ 208,025 S 321,217 $ 3,099,581 Items which did not require outlay of working capital: Depreciation 1,273,850 6,928 0 1,280,326 1,245,277 (Gain) on sale of fixed assets (89,807) (452) 0 27,027 (11,329) Working capital provided by operations 1,167,263 136,448 208,025 1,628,570 4,333,529 Contributions from Other Funds 71,606 19,762 0 91,368 102,634 Residual equity transfers 0 128,780 0 128,780 0 Proceeds from sale of assets 174,275 0 0 57,441 236,238 Total Working Capital Provided 1,413,144 284,990 208,025 1,906,159 4,672,401 WORKING CAPITAL APPLIED: Acquisition of fixed assets 1,336,904 31,717 0 1,368,621 1,110,907 Total Working Capital Applied 1,336,904 31,717 0 1,368,621 1,110,907 INCREASE IN WORKING CAPITAL $ 76,240 L._22.11.71 $ 208,025 $ 537,538 Law. CHANGES IN COMPONENTS OF WORKING CAPITAL: Increase (decrease) in current assets: Cash and short term investments $ 10,331 $ 67,904 $ 17,189 $ 95,424 $ 533,180 Cash - Other 0 0 120,399 120,399 (26,737) Investments 0 0 64,288 64,288 3,230,880 Receivables: Accounts (1,317) 208,713 (7,003) 200,393 88,923 Property taxes (delinquent) (3,451) 0 0 (3,451) 3,234 Due from other county funds 202,233 90,415 0 292,648 (438,034) Inventories (27,318) 0 0 (28,318) (60,957) Prepaid and other assets 3,708 0 17,863 21,571 202,702 Net Increase in Current Assets 184,186 367,032 212,736 763,954 3,533,191 (Increase) decrease in current liabilities: Accounts payable (132,704) (6,999) (3,571) (143,274) 72,375 Accrued liabilities 9,497 (66,856) 0 (57,359) (15,889) Due to other county funds 21,791 (39,904) (1,140) (19,253) (4,949) Deferred revenue (6,530) 0 0 (6,530) (23,234) Net (Increase) Decrease in Current liabilities (107,946) (113,759) (4,711) (226,416) 28,303 INCREASE IN WORKING CAPITAL ..Q___112.2.L:0 $ 253,273 $ 208,025 $ 537,538 $ 3,561,494 32 88051\7 COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS Year Ended December 31 , 1987 Note 1 - Summary of Significant Accounting Policies: The County of Weld 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 Weld 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 operation, 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 Health Fund, a Special Revenue Fund. Weld County Retirement Board -- The Retirement Board consists of five members , four appointed by the Board of County Commissioners and the fifth being the elected County Treasurer. The County funds half of the retirement program 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. 33 EFICE, '7 COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS (Continued) Year Ended December 31, 1987 The following organizations are not part of Weld County and are excluded from the accompanying financial statements: North Colorado Medical Center -- The Board of County Commissioners appoints a seven member Hospital Board of Trustees that in turn appoints five of the eleven Normedco Board of Directors. Normedco being a holding company of which the North Colorado Medical Center (NCMC) is a non-profit subsidiary operating the hospital. The county commits minimal capital funds annually (less than 1% of the total NCMC revenues for 1987) . 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, appoints 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. The accounting and reporting policies of Weld County, Colorado conform to generally accepted accounting principles as set forth by the Governmental Accounting Standards Board. The following summary of significant accounting policies is presented to assist the reader in evaluating the County's financial statements. 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. 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. The various funds are grouped into six generic fund types under three broad fund categories as follows: e;8C r77 34 COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS (Continued) Year Ended December 31, 1987 Governmental Fund Types: All governmental funds and expendable trust funds are accounted for on a spending or "financial flow" measurement focus. This means that only current assets and current liabilities are generally included on their balance sheets. Their 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, they 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. Special Assessment Funds: Special assessment funds are used to account for the financing of public improvements or services deemed to benefit the properties against which special assessments are levied. 35 8805o, COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS (Continued) Year Ended December 31, 1987 Proprietary Fund Types: All proprietary funds and pension trust funds are accounted for on a cost of services or "capital maintenance" measurement focus. This means that all assets and all liabilities (whether current or non-current) associated with their activity are included on their balance sheets. Their reported 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. 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. Enterprise Funds: 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. 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, pension trust and agency funds. Fixed Assets, Long-term Liabilities and Long-term Receivables: The accounting and reporting treatment applied to the fixed assets and long-term liabilities associated with a fund are determined by its measurement focus as discussed above. 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 value on the date donated. 880.5n7 36 COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS (Continued) Year Ended December 31, 1987 Fixed assets used in governmental fund type operations are accounted for in the General Fixed Assets Account Group, rather than in governmental funds. 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 has been provided on general fixed assets. Depreciation of all exhaustible fixed assets used by Internal Service Funds and Enterprise Funds is charged as an expense against their operations. Accumulated depreciation is reported on their related balance sheets. Depreciation has been provided using the straight line method over the estimated useful lives, as follows: Buildings 30 years Land Improvements 20 years Equipment and furniture 3-10 years Recognition of governmental fund type revenue represented by non-current receivables not expected to be collected in the current period is deferred until they become current receivables. Fund balance is reserved for other long-term receivables which will not be collected in the current period. Basis of Accounting: Basis of Accounting refers to when revenue and expenditures or expenses are recognized in the accounts and reported in the financial statements. Basis of accounting relates to the timing of the measurements made, regardless of the measurement focus applied. 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. Primary revenues susceptible to accrual are taxes, grant revenues and investment earnings. Property tax is reported as a receivable ( less estimated uncollectible amounts) when the levy is certified and as a revenue when collected. Other taxes are also reported as revenue when collected. 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 is recorded when payable from current available financial resources. 37 COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS (Continued) Year Ended December 31 , 1987 Proprietary funds and pension trust funds follow the accrual basis of accounting whereby revenue is recognized in the year in which it is earned and becomes measurable. Expenses are recorded when liabilities are incurred. Agency funds are custodial in nature ( assets equal liabilities) and do not involve measurement of results of operations. Encumbrances: Weld County utilizes the encumbrance method of recording commitments related to unperformed contracts for goods and services. Under this method, outstanding encumbrances at year end are recorded as a reservation of fund balance since they do not constitute expenditures or liabilities. An appropriation 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 for all governmental, proprietary and expendable trust funds. The accounting system is employed as a budgetary management control device during the year to monitor the individual departments (level of classification at which expenditures may not legally exceed appropriations) . All annual appropriations lapse at year end. 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 each department must be approved by the County Commissioners through a supplemental appropriation ordinance. During 1987, two supplemental appropriation ordinances were enacted. Budget amounts reported in the accompanying financial statements include these supplemental appropriations. 38 88C 5r.7' COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS (Continued) Year Ended December 31, 1987 Property Taxes: Property taxes attach as an enforceable lien on property as of January 1. Taxes are levied no later than November 15 and are payable in the following year in two installments on March 1 and August 1, or in full on April 30. 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. 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, 1987 levies for the applicable funds of the County are as follows: Levy Mills Amount General Fund 11.714 $ 10,620,028 Road & Bridge 3.742 3,392,534 • Social Services Fund 2.506 2,271,965 Contingent Fund 1 .048 950,127 Capital Expenditures Fund .286 259,291 IGS - Insurance .564 511,328 TOTAL 19.860 $ 18,005,273 39 COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS (Continued) Year Ended December 31, 1987 Investments: Investments of the pension trust funds are stated at fair market value. Inventories: Inventories of governmental funds, which consist of expendable materials held for consumption, are stated at the lower of cost, determined by the first-in, first-out method or market. 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. Interfund Transactions: Interfund transactions resulting from reimbursements, operating transfers, and charges for services rendered, are recorded as due to or due from other county funds. Advance to Other Funds: Non-current portions of long-term interfund loans receivable (reported in "Advance to" 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. Current portions of long-term interfund loans receivable (reported in "Due From" asset accounts) are considered "available spendable resources". Sick-leave, Vacation Pay and Comp time: Accrued vacation, sick pay and comp time for the governmental funds are accounted for in the General Long-Term Debt Account Group. Sick-leave is earned when vested and 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 , 1987, the liability for accumulated sick-leave approximated $557,925. 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 , 1987, the liability for accumulated vacation approximated $440,968. Vacation is recorded as an expenditure in the applicable fund when paid. 40 COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS (Continued) Year Ended December 31 , 1987 Vacation and sick-leave are accrued in the Proprietary Fund Types when earned. Comp time is recorded as an expenditure when paid. At December 31 , 1987 , the liability for accumulated comp time was $56,404. Grant Revenue: A receivable is generally recorded at the time a grant is awarded. Grant revenue is deferred and recognized when qualifying expenditures are incurred. Grant revenue is recognized to the extent of qualified expenditures incurred. 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 $3.35 per hour. Certain volunteer labor is recorded at higher rates based upon the individual's professional experience. Volunteer mileage is recorded at 20c per mile. Donated food, clothing, and other goods are recognized as contributed revenue at their fair market value. An offsetting in-kind expenditure is also recorded for the value of the donated goods and services. Total Columns on General Purpose Financial Statements: 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 changes in financial position in conformity with generally accepted accounting principles. Neither is such data comparable to a consolidation. Interfurd eliminations have not been made in the aggregation of this data. 41 COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS (Continued) Year Ended December 31 , 1987 Note 2 - Ambulance Enterprise Fund: The Ambulance Enterprise Fund was created in 1987 by Resolution of the Board of County Commissioners. The operations of the ambulance department were moved from Governmental (General Fund) to the newly created Enterprise Fund as it more clearly reflects the nature and purpose of its operations. Prior years amounts have not been reclassified as such amounts are not material. Fixed assets with an approximate fair value of $19,762 were transferred to the Ambulance Fund from the General Fixed Asset Account Group and recorded as a contribution of capital. The net assets transferred to the Ambulance Fund from the General Fund of $128,780 are recorded as a residual equity transfer. Additionally the General Fund made an operating transfer of $110,038 to subsidize the Ambulance Fund's operations during 1987. Note 3 - Equity in Pooled Cash and Investments, Cash, and Investments: The County maintains a cash and investment pool that is available for use by all funds except the Pension Trust Fund. Each fund's share is displayed on the balance sheets as "Cash and Investments". Several of the County's funds also hold investments on their own account. The cash and investments of the Pension Trust Fund are held separately from those of the other County funds. Deposits: At year—end, the carrying amount of the County's deposits was $16,847,403. Of this amount, $3,782, 139 was covered by Federal deposit insurance and the remainder was collateralized with securities held by the pledging financial institution's trust departments or agents in the County's name. An amount representing food stamps held at December 31 , I987 of $915,258 is not included in the above amount. Investments: Statutes authorize the County to invest in obligations of the U.S. Treasury, agencies, and instrumentalities, commercial paper, and repurchase agreements. The Pension Trust Fund is also authorized to invest in corporate bonds and mortgages. 42 EC�id cr-, Qca� '.' c COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS (Continued) Year Ended December 31 , 1987 The County's investments are categorized to give an indication of the level of risk assumed by the entity 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 in the County's name. As of December 31 , 1987, the County's investments were held by the County or its agents in the County's name and were insured or registered, where applicable. Investments as of December 31 , 1987 were as follows: Carry Market Category 1 Category 2 Amount Value Mutual Funds $ 1,832,676 $ -0- $ 1,832,676 $ 1,832,676 Corporate Bonds 5,835,857 -0- 5,835,857 5,835,857 Trust Fund 520,403 -0- 520,403 520,403 Mortgages -0- 326,764 326,764 326,764 Treasury Obligations 2,841,746 -0- 2,841,746 2,841,746 Common Stock 9,174,716 -0- 9, 174,716 9,174,716 Federal Funds 2,224,998 -0- 2,224,998 2,224,998 $22,430,396 $ 326,764 $22,757,160 $22,757,160 The Pension Trust Fund owns approximately 53% of the investments in Category 1 and 100% of the investments in Category 2. The County incurred approximately $131,754 of losses on sales of investments during the year. Note 4 - Receivables: The allowance for uncollectible receivables consists of the following at December 31 , 1987: Allowance For Fund Uncollectibles General $ 80,641 Special Revenue 5,471,899 Capital Projects 1,983 Internal Service 4,073 Trust & Agency 3,110 Enterprise 181,734 TOTAL $ 5,743,440 43 st- , '7 COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS (Continued) Year Ended December 31, 1987 Note 5 - Individual Fund Interfund Receivable and Payable Balances: Interfund receivable and payable balances at December 3i , 1987 are as follows: Interfund Interfund Receivables Payables General Fund $ 142,229 $ 376,480 Special Revenue Fur.ds: 65,503 427,582 Road and Bridge Fund Social Services Fund 5,160 34,864 Conservation Fund -0- 8,833 Contingency Fund 29,692 29,692 Public Health Fund 12,000 7,037 Human Resources Fund 72,636 42,460 Solid Waste Fund -0- 23,687 Housing Authority Fund 3,179 5,542 Capital Expenditures Fund 80 80 Special Assessment Funds: 8,749 8,749 Indianhead Enterprise Fund: Ambulance 90,415 39,904 Internal Service Funds: Motor Vehicle Fund 323,996 11 ,012 Printing and Supply Fund 25,778 26 Computer Services Fund 175,978 2,251 Insurance Fund 39,983 -0- PBX Fund 29,827 3,202 Trust and Agency Funds: 1 ,413 Employee Flexible Spending -0- Payroll Agency Fund 4,898 70 Retirement Fund -0- 1 ,140 Health Insurance Fund -0- 6,079 TOTAL $1,030,103 $1,030,103 Note 6 - Special Assessments: Weld County has four Special Assessment funds which are on the Treasurer's Role for improvements to be paid for by the property owners. ES 44 COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS (Continued) Year Ended December 31, 1987 The following schedule shows the assessment amount due for each fund: Year Ended Elmore Antelope Indian December 31, Road Road 5 Hills Head Total 1988 $ 843 $100,000 $ 1,871 $ 706 $103,420 1989 843 100,000 1 ,871 706 103,420 1990 843 100,000 1,871 706 103,420 1991 844 100,000 1 ,871 706 103,421 1992 -0- 100,000 1,871 706 102,577 Thereafter -0- 375 ,000 7,487 3,526 386,013 Total Assessment Receivable $ 3,373 $875,000 $16,842 $ 7,056 $902,271 Note 7 - Bonds Payable Bonds outstanding and related interest requirements as of December 31 , 1987 are detailed as follows: Principal Requirement Interest Requirement Certifi- Certifi- cate of Special cate of Special Total Partici- Asses- Total Partici- Asses- Total Annual Year pation ment Principal pation ment Interest Requirement 1988 $ 72,000 $100,000 $ 172,000 $20,103 $ 63,750 $ 83,853 $ 255,853 1989 75,000 100,000 175,000 15,963 54,625 70,588 245,588 1990 80,000 100,000 180,000 11,275 45,250 56,525 236,525 1991 90,000 100,000 190,000 6,075 35,625 41,700 231 ,700 1992 -0- 100,000 100,000 -0- 25,750 25,750 125,750 there- after -0- 200,000 200,000 -0- 20,875 20,875 220,875 $317,000 $700,000 $1 ,017,000 $53,415 $245,875 $299,290 $1 ,316,290 The following is a summary of the bond transactions of the County for the year ended December 31 , 1987: Certificate of Special Participation Assessment Total Bonds Payable January 1, 1987 $ -0- $ 800,000 $ 800,000 Bonds Issued 1987 317,000 -0- 317,000 Bonds Retired 1987 -0- (100,000) (100,000) Bonds Payable December 31, 1987 $317,000 $ 700,000 $1 ,017 ,000 45 PSF?irrtr 1 COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS (Continued) Year Ended December 31 , 1987 On December 1 , 1987, the County legally issued Certificates of Participation in the amount of $317,000. The issue was the result of construction of two classrooms and library in southern Weld County. Principal is paid annually on December 1, with interest rates varying from 5.75% to 6.75%. The net effective interest rate is 7.6165457. At December 31 , 1987, there are $700,000 of special assessment bonds payable. The bonds were issued to pay for road construction and are to be repaid through collection of an assessment of the property owners (see Note 5) . The bonds which bear interest between 8.5% - 10.5% mature as follows: $100,000 each year from 1988 through 1991 and $300,000 thereafter. Note 8 - Transfers: Cash is transferred from one fund to support expenditures of other funds in accordance with authority established for the individual fund. Transfers within fund types have been eliminated. A summary of interfund transfers by fund type is as follows: TRANSFER TO TRANSFER FROM Special General Revenue Total General $ -0- $ 108,393 $ 108,393 Special Revenue 1,075,155 -0- 1,075,155 Special Assessment -0- 1 ,693 1 ,693 Proprietary 210,038 -0- 210,038 Total $1,285,193 $ 110,086 $1,395,279 Note 9 - Food Stamps Food Stamp activity for 1987 is not shown as revenue and expenditures in the financial statement as it is not a budgeted item. The food stamps issued amounted to $5, 198,220 for the year 1987. 8805'n7 46 COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS (Continued) Year Ended December 31 , 1987 Note 10 - Changes in General Fixed Assets: A summary of changes in general fixed assets follows: Balance Balance 1/1/87 Additions Deletions 12/31/87 Land $ 1,588,952 $ 506,260 $ -0- $ 2,095 ,212 Improvements other than buildings 218,011 12,909 -0- 230,920 Buildings 18,738,024 463,394 772,765 18,428,653 Machinery and equipment 3,048,322 806,905 315,304 3,539,923 Total $23,593,309 $1,789,468 $1,088,069 $24,294,708 Note 11 - Capital Lease Obligation: The County leases two phone systems under agreements accounted for as capital leases. The following is a schedule of the future minimum lease payments under the capitalized leases together with the present value of the net minimum lease payments as of December 31 , 1987. Human Social Year Ending December 31 , Resources Services Total 1988 $ 17,802 $ 29,645 $ 47,447 1989 17,802 29,645 47,447 1990 16,318 29,645 45,963 1991 0 29,648 29,648 1992 0 27,262 27,262 Thereafter 0 0 0 Total minimum lease payments 51 ,922 145,845 197,767 Less: Amount representing interest (6,817) (30,617) (37,434) Present value of net minimum lease payments $ 45,105 $115,228 $160,333 47 COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS (Continued) Year Ended December 31, 1987 Note 12 - Tax Anticipation Notes: In 1987 Weld County issued tax anticipation notes, Series 1987, in the amount of $2,990,000. Weld County was authorized in accordance with Section 29-15-1, CRS, 1986, to issue by resolution tax anticipation notes in an amount not to exceed fifty percent of all taxes estimated by the County in the current fiscal year. At December 31, 1987 all bonds were due and payable. $1 ,905,000 of the bonds were not redeemed by bondholders until 1988. Interest ceased to accrue on the redemption date of December 31, 1987. Note 13 - Changes in Long-Term Debt: The following is a summary of long-term debt transactions of the County of Weld for the year ended December 31, 1987: Balance Balance 1/1/87 Additions Reductions 12/31/87 Certificate of Participation (Note 7) $ -0- $317,000 $ -0- $ 317,000 Phone Lease Obligation (Note 11) 190,481 -0- 30, 148 160,333 Vacation & Sick Leave 1,063,546 -0- $ 8,253 $1,055,293 TOTAL $1,254,027 $317,000 $ 38,401 $1,532,626 Sick leave and vacation accruals for Governmental Fund types are recorded in this fund together with the capital lease obligations and certificate of participation for government funds. Weld County has no general bonded indebtedness. In accordance with Section 30-35-201, CRS, 1973, the limit of Weld County's general bonded indebtedness is 3% of the assessed valuation or $27,198,297 as of December 31, 1987. Note 14 - Fund Balance Reserves: Reserves for the County of Weld consist of: Reserve for Advances - to Special Assessment Funds: These reserves were established in conjunction with an assessment of a designated group of taxpayers. As the assessments are collected, the advance is repaid. ccf SC 48 COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS (Continued) Year Ended December 31, 1987 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. Reserve for Prepaid Items: These reserves are established to record all prepaid items. Reserve for Inventories: These reserves are established to record the total level of inventories. Reserve for Employee Benefits: These reserves are established to record the Pension Benefit obligation of the Weld County Retirement Plan. Reserve for Advances - to Internal Service Funds: These reserves were established to record a temporary loan of cash flow for a supply inventory. Designated Fund Balance: Fund balance designated for subsequent year's expenditures represents fund balance commitments for appropriated expenditures in excess of anticipated revenue for the year ending December 31, 1988. The following is a summary of all reported reserves by fund type: Special Capital Trust and Reserves General Revenue Projects Agency Total Encumbrances $ 45,297 $ 537,293 $144,351 S 60 $ 727,001 Prepaid Items 29,244 53,791 -0- -0- 83,035 Inventories 31,339 740,778 -0- -0- 772, 117 Advances to Special Assess- ment Funds 27,289 75,000 -0- -0- 102,289 Advances to Internal Service Funds 80,000 -0- -0- -0- 80,000 Employee Benefits -0- -0- -0- 20,121,007 20,121 ,007 TOTAL $213,169 $1,406,862 $144,351 $20, 121,067 $21,885,449 49 COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS (Continued) Year Ended December 31 , 1987 Note 15 - Other Required Individual Fund Disclosures: The deficit fund balance of the Special Assessment Funds (Improvement District Road 5 - $652,771 , Indianhead Special Assessment - $6,350 and Antelope Hills Special Assessment - $11 ,748) arose because of the application of generally accepted accounting principles to the financial reporting for such funds. Special assessments are recognized as revenue only to the extent that individual installments are considered to be available, spendable resources. The deficit will be reduced and eliminated as deferred special assessment installments become available, spendable resources. The deficit fund balance of Social Services (Special Revenue) of $122,195 was caused by program cost increases in areas over state reimbursement. This shifted the burden for these expenses to the local tax source which was not sufficient to cover the overage. Additional dollars will be added to the 1988 allocation to support the burden created by these disallowed reimbursable costs. Excesses of expenditures over appropriations in individual funds are as follows: Revised Over- Appropriation Expenditures expenditure Special Revenue Funds: Human Resources $ 3,845,920 $ 3,856,574 $ (10,654) Enterprise Funds: Ambulance $ 956,500 $ 1,175,257 $ (218,757) The overage for the Human Resources fund was caused due to an increase in the Headstart expenditure. The overage in the Ambulance Fund is attributed to first year start-up cost. In-kind contributions and expenditures are not included as budgetable items. Co80a5n 50 COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS (Continued) Year Ended December 31, 1987 The District Court, County of Weld, State of Colorado in a Court Order dated January 28, 1983 in Case Number 80CV1091 decreed that in accordance with Section 29-1-111.5, CRS, 1973, Weld County can designate specific ownership tax directly to the Road and Bridge Fund. In accordance with Section 8-44-110, CRS, 1973, a property tax mill levy may be used to fund the self-insurance program for local county activities. Note 16 - Weld County Retirement Plan: The Weld County Retirement Plan is a trusteed defined benefit pension plan. All full time employees (except officers and employees of any Federally-funded program which excludes them) are required to participate in the plan. At December 31 , 1987 the number of participating employees was 835, and the membership consisted of: Retirees and beneficiaries currently receiving benefits and terminated employees entitled to benefits but not yet receiving them: 185 Current Employees: Vested: 291 Nonvested: 359 TOTAL 835 The Weld County Retirement Plan, established in 1969 provides for pension, death, and disability benefits. All benefits are fully vested after 8 years of service, except elected officials, who are fully vested regardless of years of service. Employees are required to contribute 6.0%, by directive of the retirement board, to the Retirement Plan which is equally matched by the County. Contributions during 1987 for both the County and the employees totalled $1,675,355. Total covered payroll for year ended December 31, 1987 was $13,962,091. The Weld County Retirement Plan is accounted for using the accrual basis of accounting. Employee and employer contributions are recognized as revenues in the period in which employee services are performed. Investments are reported at market. Investment income is recognized over the life of the investments. 51 COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS (Continued) Year Ended December 31, 1986 The amount shown below as "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. The measure is the actuarial present value of credited projected benefits and is independent of the funding method used to determine contributions to the Plan. The "Pension Benefit Obligation" was determined as part of an actuarial valuation at January 1, 1987. The actuarial assumptions used include: A) Rate of return on the investment of present and future assets of 7 .5% per year compounded annually, and B) Earnings progression at various rates depending on attained age from 8.5% for age 25 to 6.3% for age 64. At January 1 , 1987 there are assets in excess of the pension benefit obligation of $4,284,496 as follows: Pension Benefit Obligation: Retirees and Beneficiaries Currently Receiving Benefits $ 3,988,439 Terminated Vested Employees Not Yet Receiving Benefits 66,301 Current Employees: Accumulated Employee Contributions Including Allocated Investment Income 4,507,102 Employer Financed Vested 5,287,047 Employer Financed Nonvested 1 ,987,622 Total Pension Benefit Obligation: 15,836,511 Net Assets Available for Benefits(Market Value) : 20,121,008 Assets in Excess of Pension g 4,284,496 Benefit Obligation: Information on the effects of current year changes in actuarial assumptions and benefit provisions on the pension benefit obligation is not presented as it is not available. 52 COUNTY OF WELD STATE OF COLORADO NOTES TO FINANCIAL STATEMENTS (Continued) Year Ended December 31, 1987 Note 17 - 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 of Weld established the Deferred Compensation Plan of the County of Weld. The plan is a special voluntary benefit plan for public employees, in which a portion of the employee's earnings can be set aside and invested, free of current income taxes. 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 Weld County until paid to the participant or the participant' s beneficiary. The County holds these funds in custody for the participants and exercises no discretion over the investment of the funds. The participants election of investments determines the risk factor he is willing to absorb. Investments are recorded at market value. Note 18 - 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. Self-insurance for liability exposure is maintained by the Insurance Fund in the Internal Service Fund group. Self-insurance is in effect for incidents up to June 30, 1986 for property, casualty, and liability losses up to $100,000 per occurrence. Losses greater than $100,000 per occurrence, and those in excess of the aggregate stop loss, were insured by private insurance companies. County-wide annual aggregate stop loss limit was $340,000. Effective July 1 , 1986, Weld County joined Colorado Counties, incorporated's Casualty and Property Pool (CAPP) which covers all casualty and property claims with a $500 deductible for first party property claims. Worker's Compensation remains self-insured with a $200,000 per occurrence and $200,000 aggregate annual stop loss limit. Private insurors 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 the Office of Revenue Sharing, Department of Labor, Community Services Administration, Department of Health and Human Services, Department of Housing and Urban Development, 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. 53 #0stri WIDe. COLORADO 54 COMBINING STATEMENTS , INDIVIDUAL FUND AND ACCOUNT GROUP STATEMENTS , AND SCHEDULES WII'Dc. COLORADO GENERAL FUND The General Fund accounts for ell 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. tf VI COLORADO COUNTY OF WELD STATE OF COLORADO GENERAL FUND BALANCE SHEET December 31, 1987 and 1986 ASSETS 1987 1986 ASSETS: Cash and short term investments $ 3,373,743 S 2,874,745 Cash - other 28,125 23,500 Receivables (net of allowance for uncollectibles): Current property tax 11,247,635 10,620,045 Delinquent property tax 182,377 244,400 Accounts - Ambulance service 0 223,355 Accounts - Other 171,904 132,485 Due from other county funds 142,229 61,759 Due from other governmental units 220,519 235,553 Advances to other funds 107,271 111,758 Inventories 31,339 30,734 Prepaid expenses 46,232 24,362 TOTAL ASSETS $ 15,551,374 $ 14,582,696 LIABILITIES AND FUND BALANCE LIABILITIES: Accounts payable $ 153,084 $ 118,346 Accrued liabilities 580,658 585,408 Due to other governments 15,075 9,199 Due to other county funds 376,480 303,381 Deferred revenue 11,407,008 10,864,445 Unexpended grant revenue 100,391 102,037 Other liabilities 0 600 Bonds payable 1,905,000 1,450,000 Total Liabilities $ 14,537,696 $ 23S—I16 FUND BALANCE: Reserve for encumbrances $ 45,297 $ 121,524 Reserve for advances to other funds 107,289 111,758 Reserve for prepaid expenses 29,244 24,362 Reserve for inventories 31,339 30,734 Unreserved: 190 108 141,987 Designated for subsequent year's expenditures , Undesignated 610,401 718,915 Total Fund Balance 1,013,678 1,149,280 TOTAL LIABILITIES AND FUND BALANCE $ 15,551,374 $ 14,582,696 55 8805Y' i COUNTY OF WELD SI'AIE Of COLORADO GENERAL FUND Schedule Of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Estimate Actual Variance Actual TAXES: General property tax $ 10,620,045 $ 10,652,851 $ 32,806 S 10,141,869 Severance tax 16,000 0 (16,000) 3,348 Tobacco products 61,000 67,539 6,539 59,615 Penalties & interest 0 59,899 59,899 53,954 Payment in lieu of taxes 13,035 13,035 0 0 Total Taxes 10,710,080 10,793,324 83,244 10,258,786 LICENSES AND PERMITS: Liquor licenses 5,400 7,054 1,654 3,465 Plow permits 0 280 280 0 Planning permits 67,605 68,951 1,346 64,821 Building permits 267,000 260,406 (6,594) 249,658 Electrical permits 55,000 46,016 (8,984) 45,159 Total Licenses and Permits 395,005 382,707 (12,298) 363,103 INTERGOVERNMENTAL REVENUE: Contract payments 115,000 129,631 14,631 141,255 Grant 578,653 629,572 50,919 860,379 District Attorney 38,000 38,000 0 38,000 Veterans Office 600 600 0 550 Cities & towns 82,072 81,363 (709) 104228 , Total Intergovernmental Revenue 814,325 879,166 64,841 1,144,412 CHARGES FOR SERVICES: Plan checking fees 6,750 6,091 (659) 5,387 Books 7,500 10,443 2,943 8,425 Charge for service 320,939 313,166 (7,773) 225,528 Sale of supplies 4,800 7,356 2,556 4,715 City contracts 83,100 85,332 2,232 82,012 Rescue unit fees 0 0 0 879,868 Parking 15,675 15,556 (119) 15,888 Refuse disposal 1,000 644 (356) 588 Weed spraying 15,000 12,896 (2,104) 15,299 Total Charges for Services 454,764 451,484 (3,280) 1,237,710 FINES AND FORFEITURES: Victim witness surcharge 2.5% 3,895 0 (3,895) 0 Property forfeitures/evidence 1,750 1,750 0 2,905 Fines (drunk drivers) 23,000 74,715 51,715 64,293 Total Fines and Forfeitures 28,645 76,465 47,820 67,198 MISCELLANEOUS REVENUE: Miscellaneous 0 982 982 1,252 Oil & gas leases 0 2,190 2,190 2,180 Rents from buildings 132,900 154,084 21,184 156,101 Royalties 150,000 169,765 19,765 251,249 Car seat rentals 71,430 69,030 (2,400) 69,030 Special assessments 425,535 481,803 56,268 328,549 Miscellaneous revenue 0 20,630 20,630 6,280 Other revenue 4,200 69,974 65,774 56,937 Car seat donations 0 4,039 4,039 3,872 In kind 65,000 67,830 2,830 . 60,908 DUI fees 66,696 5,852 (60,844) 5,011 Bond application fee 600 225 (375) 333 Public Trustee deeds 11,000 8,752 (2,248) 9,689 Sale of assets 945 1,460 515 11,540 Total Miscellaneous Revenue 928,306 1,056,616 128,310 962,931 (Continued on next page) [1"27 5 6 a.?�Y' COUNTY OF WELD STATE ON COLORADO GENERAL FUND Schedule Of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Estimate Actual— Variance Ac— ttuu— FEEheriUfTs: 117,248 $ 106,347 $ (10,901) S 114,795 Sheriff s cora $ Clerk & Recorder fees 1,058,000 1,041,222 (16,778) 1,039,068 Treasurer's fees 480,000 486,226 6,226 461,171 Advertising 37,595 37,923 328 37,570 Assessor's fees 36,000 39,211 3,211 27,752 Surveyor fees 3,000 950 (2,050) 0 Bad check fees 0 15 15 0 Total Fee Accounts 1,731,843 1,711,894 (19,949) 1,680,356 EARNINGS ON INVESTMENTS: Earnings on deposit 1,202,270 1,052,991 (149,279) 1,213,651 Total Earnings on Investments 1,202,270 1,052,991 (149,279) 1,213,651 TOTAL REVENUE 16,265,238 16,404,647 _alit 16,928,147 GENERAL GOVERNMENT: Office of the Board 248,695 239,017 9,678 234,885 County Attorney 322,955 294,982 27,973 306,852 Public Trustee 4,500 3,497 1,003 3,790 Planning and zoning 231,030 222,694 8,336 218,542 County Clerk 1,100,910 1,090,110 10,800 1,082,883 Elections and registration 127,721 119,882 7,839 292,541 County Treasurer 510,488 469,255 41,233 477,176 County Assessor 1,128,222 1,119,75287 5 465 934,441 County Surveyor 3,000 2,715 0 Maintenance of buildings/grounds 1,102,428 1,118,416 (15,988) 1,027,203 County Council 20,522 6,937 13,585 10,839 District Attorney 1,115,807 1,058,311 57,496 977,800 Juvenile Diversion Grant 132,204 116,868 15,336 112,489 Victim Assistance 71,171 71,344 (173) 44,484 Pac - Diversion 59,373 52,274 7,099 38,975 Financial administration 125,964 125,869 95 122,225 General accounting 395,037 391,020 4,017 296,793 Purchasing 139,098 136,944 2,154 131,762 Personnel 184,544 181,703 2,841 203,171 Total General Government 7,023,669 6,819,165 204,504 6,516,851 PUBLIC SAFETY: Sheriff administration 1,133,753 1,129,755 3,998 1,062,512 Crime control and investigation 1,945,337 1,931,129 14,208 1,810,012 Posse/special deputies 1,600 823 777 5,355 Regional Forensic Laboratory 53,012 49,970 3,042 50,277 Communications Services 679,525 696,135 (16,610) 624,040 Communication system development 0 6,140 (6,140) 544 Ambulance services 238,818 0 238,818 818,803 County Coroner 58,925 57,807 1,118 62,394 Correctional administration 2,160,420 2,182,494 (22,074) 1,965,984 Community correction 130,000 138,982 (8,982) 170,242 Delinquents and other institutions 165,918 164,052 1,866 155,628 Public service DUI 67,635 59,051 8,584 55,383 Building inspection 284,715 269,675 15,040 241,653 Office of Emergency Management 41,044 40,265 779 39,045 Energy impact - Hasmat 0 0 0 15,084 Predatory animal control 9,500 9,143 357 8,000 Animal control 67,146 67,146 0 67,146 Pest/weed control 121,137 122,032 (895) 120,833 Total Public Safety 7,158,485 6,924,599 233,886 7,272,935 (Continued on next page) 57 COUNTY OF WELD STATE OF COLORADO GENERAL FUND Schedule Of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 , . 1987 1987 1987 1986 Estimate Actual Variance Actual PUBLIC WORKS: General engineering $ 291,163 $ 283,789 $ 7,374 $ 271,468 Extension service 184,148 172,758 11,390 169,737 Veterans office 45,827 45,022 805 41,622 Airport 25,000 21,155 3,845 0 Total Public Works 546,138 522,724 23,414 482,827 PUBLIC HEALTH AND WELFARE: Mental health 72,931 72,931 0 69,458 Developmentally disabled 41,105 41,105 0 39,148 Seniors programs 10,500 10,500 0 10,500 Patient advocacy 0 0 0 50,000 Total Public Health and Welfare 124,536 124,536 0 169,106 MISCELLANEOUS EXPENDITURES: Tax anticipation notes 15,000 15,000 0 17,700 Other 289,143 189,672 99,471 200,248 IRB building rents 69,030 69,030 0 69,030 Total Miscellaneous Expenditures 373,173 273,702 99,471 286,978 CULTURE AND RECREATION: Missle site park 1,100 717 383 2,537 County fair 30,905 94,993 (64,088) 84,025 Total Culture and Recreation 32,005 95,710 (63,705) 86,562 CONSERVATION OF NATURAL RESOURCES: Northern Colorado Research Center 0 0 0 3,000 Greeley West Soil Conservation 0 0 0 3,025 Total Conservation of Natural Resources CAPITAL OUTLAY: County Assessor 370 370 0 0 District Attorney 1,800 0 10,800 1,800 0 Victim Assistance 10,028 8,742 Equipment 77,237 63,796 13,441 69,650 Sheriff administration 3,905 3,700 205 6,650 Crime control and investigation 24,360 23,838 522 0 Regional Forensic Laboratory 11,795 8,475 3,320 36,849 Communication system development 244,624 225,610 19,014 155,648 Ambulance services 0 0 0 15,467 Correctional administration 14,558 12,328 2,230 108 Energy impact - Hasmat 0 0 0 8,476 Total Capital Outlay 389,449 348,145 41,304 301,590 DEBT SERVICE: Tax anticipation notes 126,089 126,088 1 170,977 Total Debt Service 126,089 126,088 1 170,977 TOTAL EXPENDITURES 15,773,544 15,234,669 538,875 15,293,851 (Continued on next page) @8,C`r? 58 4 COUNTY OF WELD STATE OF COLORADO Schedule Of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 19871 1986 Estimate Actual Variance Actual— OPERATING TRANSFERS - IN:Non-Departmental $ 36,059 $ 36,059 $ 0 $ 0 Pac - Diversion 72,133 72,334 201 59,140 TOTAL OPERATING TRANSFERS-IN 108,192 108,393 201 59,140 OPERATING TRANSFERS - OUT: Appropriation grants-in-aid 1,196,127 1,285,193 (89,066) (1,282,370) TOTAL OPERATING TRANSFERS-OUT 1,196,127 1,285,193 (89,066) (1,282,370) EXCESS OF REVENUE AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES L- 26-121--.1(5 ) $ (6,822) $ 589,419 $ 411,066 4 59 COLORADO 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. wiIEDc. COLORADO S8O5O7 COUNTY OF WELD STATE OF COLORADO SPECIAL REVENUE FUNDS EXPLANATIONS OF INDIVIDUAL FUNDS December 31, 1987 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. Social Services Fund: The Social Services Fund accounts for the various public welfare programs administered by the County. Federal Revenue Sharing Fund: Federal Revenue Sharing entitlements and expenditures are recorded in this fund in accordance with the regulations of the Office of Revenue Sharing. 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. 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 - primary funding agent is HUD. 61 COUNTY OF WELD STATE OF COLORADO SPECIAL RL,vaNUE AUNDS COMBINING BALANCE SHEET December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 Federal Road and Social Revenue Conservation Bridge Services Sharing Trust Contingent Fund Fund Fund Fund Fund ASSETS ASSETS: Cash and short term investments $ 2,908,388 $ 666,352 $ 0 $ 147,939 $ 36,953 Cash - other 3,500 919,408 0 0 0 Receivables (net where applicable of allowance for uncollectibles): Current property tax 3,309,743 2,370,535 0 0 934,579 Delinquent property tax 54,843 38,712 0 0 14,107 Accounts 26,450 (2,543) 0 2,802 0 Due from other county funds 65,503 5,160 0 0 29,692 Due from other governmental units 215,502 0 0 0 0 Advances to other funds 0 0 0 0 0 Inventories 716,907 0 0 0 0 Prepaid expenses 174 2,834 0 0 0 TOTAL ASSETS $ 7,301,010 $ 4,000,458 $ 0 $ 150,741 $ 1,015,331 LIABILITIES AND FUND BALANCE LIABILITIES: Voucher and warrants payable $ 57,438 $ 67,347 S 0 $ 0 $ 0 Accrued liabilities 124,644 116,867 0 0 0 Due to other governments 0 1,474,278 0 0 0 Due to other county funds 427,582 34,864 0 8,833 29,692 Deferred revenue 3,364,586 2,409,247 0 0 948,686 Unexpended grant revenue 0 0 0 0 0 Other liabilities 0 20,050 0 0 0 Total Liabilities S 3,974,250 $ 4,122,653 $ 0 $ 8,833 $ 978,378 FUND BALANCE: Reserved: Reserve for encumbrances $ 528,490 $ 0 $ 0 S 0 S 0 Reserve for advances other funds 0 0 0 0 0 Reserve for prepaid expenses 174 0 0 0 0 Reserved for inventories 716,907 0 0 0 0 Unreserved: Designated for subsequent year's expenditures 965,000 0 0 0 0 Undesignated 1,116,189 (122,195) 0 141,908 36,953 Total Fund Balance $ 3,326,760 $ (122,195) $ 0 $ 141,908 L____36,953 TOTAL LIABILITIES AND FUND BALANCE L-.7.222.112)--0 $ 4,000,458 $ 0 Sal $ 1,015,331 • 5:. 62. . aN.^'fit. .,; Public Human Solid Housing Health Resources Waste ase Authority December 31 December ber 31 Fund Fund Fund 1987 847,475 $ 211,750 $ (7,958) $ 5,013,514 $ 4,899,344 $ 202,615 $ 0 16,969 940,152 24,635 200 75 0 0 0 0 6,614,857 6,615,135 0 0 0 0 107,662 130,999 21,991 211,252 18,871 5,252 284,075 211,047 72 636 0 3,179 188,170 173,231 12,000 > 0 209,130 1,990,944 1,981,849 170,532 1,395,780 0 75,000 0 75,000 75,000 0 0 740,778 839,270 23,871 0 0 1,840 650 0 54,289 59,787 33,432 $ 433,049 $ 2,527,868 $ 305,621 1..._213-92±1 $ 16,014,939 $ 14,983,942 $ 71,625 $ 210,303 $ 122 $ 20,869 $ 427,704 $ 143,201 48,297 147,654 0 2,219 439,681 356,134 0 0 0 0 1,474,278 1,286,261 42 460 23,687 5,542 579,697 269,505 7,037 1,071 75,000 0 6,809,591 6,828,505 11,001 0 200,864 1,261,659 1,181,844 119,769 941,026 0 0 69 69,936 ,936 0 49,886 1-222-221 $ 1,392,400 $ 98,809 $ 229,494 $ 11,062,546 $ 10,135,386 $ 6,739 $ 2,064 $ 0 $ 0 $ 537,293 $ 1,493,900 0 0 75,000 0 75,000 75,000 0 51,367 53,791 33,432 1,840 410 23,871 18,536 0 131,812 0 1,115,348 1,280,000 124,334 1,132,994 0 0 2,430,183 1,126,954 $ 175,320 S1 $ 206,812 $ 51,367 $ 4,952,393 $ 4,848,556 $ 433,049 $ 2,527,868 $ 305,621 $ 280,861 a6.222-1.••-•4 939 $ 14,983,942 1'\ . t+,d: 63 COUNTY OF WELD STATE OF COLORADO SPI.CiAL REVENUt. ruts COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 Federal Road and Social Revenue Conservation Bridge Services Sharing Trust Contingent Fund Fund Fund Fund Fund REVENUES: Taxes $ 4,317,842 $ 2,437,396 $ 0 S 0 S 1,015,746 Licenses and permits 230,194 0 0 0 0 Intergovernmental revenue 4,308,748 10,950,908 11,113 162,736 0 Charges for services 39,004 0 0 0 0 Miscellaneous 61,753 0 0 4,754 0 Total Revenues 8,957,541 13,388,304 11,113 167,490 1,015,746 EXPENDITURES: Current Operating: Public works $ 9,353,622 $ 0 $ 0 S 0 S 0 Public health and welfare 0 13,400,819 0 0 0 Miscellaneous 0 44,884 0 0 0 Culture and recreation 0 0 0 148,461 0 Economic assistance 0 0 0 0 0 Capital outlay 3,274 6,458 0 0 0 Intragovernmental 594,982 0 0 0 0 Total Expenditures 9,951,878 13,452,161 0 148,461 0 EXCESS OF REVENUES OVER (UNDER) EXPENDITURES (994,337) (63,857) 11,113 19,029 1,015,746 OTHER FINANCING SOURCES: Operating transfers - in $ 1,054,395 $ 0 $ 0 $ 0 $ 0 Operating transfers - out (1,693) (72,334) (11,113) 0 (1,024,841) Total Other Financing Sources (Uses) L.1.02-22-92. $ (72,334) . $ (11,113) $ 0 $ (1,024,841) EXCESS OF REVENUES AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES 58,365 (136,191) 0 19,029 (9,095) FUND BALANCE AT BEGINNING OF YEAR 3,268,395 13,996 0 122,879 46,048 FUND BALANCE AT END OF YEAR $ 3,326,760 $ (122,195) $ 0 $ 141,908 $ 36,953 • • , 64 *05°7 4 17.:, Yom r Public Human Solid Housing Health Resources Waste Authority December 31 December 31 Fund Fund Fund Fund 1987 1986 $ 0 $ 0 $ 0 $ 0 $ 7,770,984 $ 6,722,049 125 0 0 0 230,319 218,257 336,548 3,194,428 0 945,662 19,910,143 19,514,492 183,527 304,367 165,180 0 692,078 494,900 1,621 102,056 0 2,972 173,156 173,038 P... .23.12-. 821 La: 1.... ..-L-2" 5180 $ 948,634 $ 28,776,680 $ 27,122,736 $ 0 $ 0 $ 0 $ 0 $ 9,353,622 $ 8,022,912 1,263,679 0 0 0 14,664,498 14,491,396 O 0 25,922 68,031 138,837 134,502 O 0 0 0 148,461 178,790 O 3,629,604 0 861,742 4,491,346 3,962,816 9,307 226,970 0 157 246,166 116,433 O 0 0 0 594,982 488,119 $ 1,272,986 1,-222E611 574 $ 25,922 $ 929,930 $ 29,637,912 $ 27,394,968 (751,165) (255,723) 139,258 18,704 (861,232) (272,232) $ 689,371 $ 385,784 $ 0 $ 0 $ 2,129,550 $ 2,878,377 O 0 (54,500) 0 (1,164,481) (2,053,851) 1-212221 1-181122L. L---S54,5.21) $ 0 1-a$-L3.62. IS (61,794) 130,061 84,758 18,704 103,837 552,294 237,114 1,005,407 122,054 32,663 4,848,556 4,296,262 $ 175,320 $ 1,135,468 $ 206,812 $ 51,367 $ 4,952,393 $ 4,848,556 1,Y 1 %1:,. 65 880507 COUNTY OF WELD STATE OA' COLORAb0 SPECIAL KhvENUE FUNDS ROAD AND BRIDGE FUND Schedule of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Estimate ActualVariance —Ac tual TARES: General property tax $ 3,392,578 $ 3,396,765 $ 4,187 $ 2,776,492 1 131 000 901,942 (229,058) 894,665 Specific ownership taxes ,131,000 ' 0 19,135 19,135 14,790 Penalties & interest Total Taxes 4,523,578 4,317,842 (205,736) 3,685,947 LICENSES AND PERMITS: Moving permits 100,000 230,194 130,194 217,457 Total Licenses and Permits 100,000 230,194 130,194 217,457 INTERGOVERNMENTAL REVENUE: 1 000 0 (1,000) 0 Matching funds snow/gravel 31,,000 41,185 11,185 23,350 Mineral leasing 38,000 56,250 18,250 48,266 Grazing act 0 10,140 10,140 12,192 Payment in lieu of taxes 0 0 0 28,913 Grant - 190,666 189,569 (431) 187,970 Motor vehicle registration fee 4,090,666 4,011,604 (79,062) 3,199,244 Highway user tax fund Total Intergovernmental Revenue 4,349,666 4,308,748 (40,918) 3,499,935 CHARGES FOR SERVICES: 2,000 39,004 37,004 15,582 Charge for service Total Charges for Services 2,000 39,004 37,004 15,582 MISCELLANEOUS REVENUE: 0 Miscellaneous revenue 0 5,912 5,912 Other revenue 1,000 55,841 54,841 72,388 Total Miscellaneous Revenue 1,000 61,753 60,753 72,388 TOTAL REVENUE 8,976,244 8,957,541 (18,703) 7,491,309 PUBLIC WORKS: 5 228 0 5,228 0 Roadway construction , 802 790 68 228 571,390 Bridge construction 871,675 ' 8,882) 1,632,520 Maintenance of condition 1,658,500 1,660,187 Maintenance support 874,574 686,124 188,450 759,361 Trucking division 1,082,225 951,323 130,902 866,106 Mining division 796,784 790,516 6,268 6170,782 43,153 Administration 176,106 192,134 (16,028) Other public works 5,270,020 4,270,545 —2-2--99475 3,379,600 Total Public Works 10,735,112 9,353,622 1,381,490 8,022,912 (Continued on next page) • 66 tie— COUNTY OF WELD STATE OF COLORADO SPBCiAL RhvENU6 FUNDS ROAD AND BRIDGE FUND Schedule of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 -MTh= Actual Variance Actual CAPITAL OUTLAY: Maintenance of condition $ 3,300 $ 3,274 S 26 $ 0 Total Capital Outlay 3,300 3,274 26 0 INTRAGOVERNtIENTAL EXPENDITURES: Grants-in-aid to cities/towns 607,525 594,982 12,543 488,119 Total Intragovernmental Expenditures 607,525 594,982 12,543 488,119 TOTAL EXPENDITURES 11,345,937 9,951,878 1,394,059 8,511,031 OPERATING TRANSFERS - IN: Non-Departmental 11,113 1,054,395 1,043,282 1,799,711 TOTAL OPERATING TRANSFERS-IN 11,113 1,054,395 1,043,282 1,799,711 OPERATING TRANSFERS - OUT: 0 (1,693) (1,693) (15,000) Other public works TOTAL OPERATING TRANSFERS-OUT 0 (1,693) (1,693) (15,000) EXCESS OF REVENUE AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES U.2-11510-8.2) $ 58,365 $ 2,416,945 $ 764,989 COUNTY OF WELD STATE OF COLORADO SPECIAL REVENUE IQNYS SOCIAL SERVICES FUND Schedule of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Est mate c� Variance Actual TAXES: General property tax $ 2,271,834 $ 2,278,346 $ 6,512 $ 2,130,996 Specific ownership taxes 173,617 146,236 (27,381) 147,709 Penalties & interest 0 12,814 12,814 11,350 Total Taxes 2,445,451 2,437,396 (8,055) 2,290,055 INTERGOVERNMENTAL REVENUE: Contract payments revenue 0 66,136 66,136 54,692 Federal shared revenue 78,400 0 (78,400) 0 Direct assistance 3,920,000 0 (3,920,000) 0 Welfare (SS) 7,709,799 10,884,772 3,174,973 10,963,682 Total Intergovernmental Revenue 11,708,199 10,950,908 (757,291) 11,018,374 MISCELLANEOUS REVENUE: Sale of assets 0 0 0 545 TOTAL REVENUE 14,153,650 13,388,304 (765,346) 13,308,974 PUBLIC HEALTH AND WELFARE: Administrative - regular 2,940,800 2,945,957 (5,157) 2,835,638 Administrative - IV-D 465,700 462,897 2,803 382,411 Institutional care 0 52,482 (52,482) 0 General assistance 104,000 96,890 7,110 91,098 AB 8,000 5,820 2,180 5,791 AFDC 4,812,000 4,657,418 154,582 5,086,246 AND - State 489,000 528,790 (39,790) 252,374 CW - FC 1,070,000 1,065,052 4,948 952,043 AFDC - FC 405,000 403,294 1,706 365,248 Day care 450,000 444,990 5,010 373,182 Medicaid transportation 30,000 19,797 10,203 22,677 Non-contractural case services 16,000 11,312 4,688 14,281 OAP - A - 1,534,000 1,663,358 (129,358) 1,102,970 Placement alternative care 225,000 171,275 53,725 228,365 AFDC - U 0 (271) 271 (45) AND - other 100,000 0 100,000 222,695 OAP - B 256,000 0 256,000 625,810 Medical examinations 13,000 11,680 1,320 11,323 IV-D 0 (204,021) 204,021 (534,707) AB - treatment 8,000 10,243 (2,243) 1,260 Administrative - LEAP 78,400 56,700 21,700 53,299 Administrative - LEAP outreach 15,000 18,820 (3,820) 20,418 LEAP - regular 1,055,000 886,908 168,092 1,117,418 LEAP - emergency 30,000 25,237 4,763 29,233 LEAP - special 0 0 0 (95) FEMA 0 66,191 (66,191) 54,693 Total Public Health and Welfare 14,104,900 13,400,819 704,081 13,313,626 (Continued on next page) 68 13805C7 . COUNTY OF WELD STATE OF COLORADO SPECIAL REVENUE: t1` S SOCIAL SERVICES FUND Schedule of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Estimate Actual arriance AcAcctub MISCELLANEOUS EXPENDITURES: Staff development $ 3,000 $ 2,441 $ 559 $ 4,788 Staff Travel 45,000 42,443 2,557 35,392 Total Miscellaneous Expenditures 48,000 44,884 3,116 40,180 CAPITAL OUTLAY: Administrative - regular 750 6,458 (5,708) 15,407 Administrative - IV-D 0 0 0 886 Administrative - LEAP 0 0 0 329 Total Capital Outlay 750 6,458 (5,708) 16,622 TOTAL EXPENDITURES 14,153,650 13,452,161 s 13,370,428 OPERATING TRANSFERS - OUT: Placement alternative care 0 72,334 (72,334) (59,140) TOTAL OPERATING TRANSFERS-OUT 0 72,334 (72,334) (59,140) EXCESS OF REVENUE AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES $ 0 $ (136,191) $ (136,191) $ (120,594) 69 880507 COUNTY OF WELD STATE OF COLORADO SPLCIAL RhVMNut FUNDS FEDERAL REVENUE SHARING FUND Schedule of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Est mate Actual Variance Actual INTERGOVERNMENTAL REVENUE: 1,113 $ 11,113 $ 0 $ 868,748 Federal revenue sharing $ 1 TOTAL REVENUE 11,113 11,113 0 868,748 OPERATING TRANSFERS - OUT: 0 (1,219,711) Other operating transfers (11, 11,113 113) ( ) TOTAL OPERATING TRANSFERS-OUT (11,113) (11,113) 0 (1,219,711) EXCESS OF REVENUE AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND $ 0 $ 0 $ 0 $ (350,963) OTHER USES 8995G1 70 COUNTY OF WELD SPATE OF COLORADO SPECIAL REVENUE HJNOS CUNSEHVAIIUN 1RUST FOND Schedule of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Estimate Actual Variance Actual INTERGOVERNMENTAL REVENUE: State lottery $ 162,736 $ 162,736 $ 0 S 138,069 Total Intergovernmental Revenue 162,736 162,736 0 138,069 MISCELLANEOUS REVENUE: Earnings on deposit 0 4,754 4,754 4,983 Total Miscellaneous Revenue 0 4,754 4,754 4,983 TOTAL REVENUE 162,736 167,490 4,754 143,052 CULTURE AND RECREATION: Land improvements 182,301 148,461 33,840 178,790 Total Culture and Recreation 182,301 148,461 33,840 178,790 TOTAL EXPENDITURES 182,301 148,461 33,840 178,790 EXCESS OF REVENUE AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES 1----11122622. 1--1-1---9029 $ 38,594 $ (35,738) ,;: p 71 ��y 55050 COUNTY OF WELD STATE OF COLORADO SPECIAL REVENUE kUNDS CONTINGENT FUND Schedule of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Estimate Actual— Variance Actual TAXES: $ 950,723 $ 949,229 $ (1,494) $ 694,146 General property tax 61 158 (13,119) 48,198 Specific ownership taxes 74,277 0 5,359 5,359 3,703 Penalties & interest Total Taxes 1,025,000 1,015,746 (9,254) 746,047 TOTAL REVENUE 1,025,000 1,015,746 (9,254) 746,047 OPERATING TRANSFERS - OUT: (1,025,000) (1,02 700,000)4,841) 159 ( Other TOTAL OPERATING TRANSFERS-OUT (1,025,000) (1,024,841) 159 (700,000) EXCESS OF REVENUE AND OT ER SOURCES OVER (UNDER) EXPENDITURES AND $ 0 S (9,095) 1---i2-1-921)(9, 5) L---1-1--.6 047 OTHER USES 72 COUNTY OF WELD STATE OF COLORADO SP)CIAL RhVbNUE I' S PUBLIC HEALTH FUND Schedule of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Ac— tual Variance Actual LICENSES AND PERMITS: Health license $ 750 $ 125 $ (625) $ 750 Animal licenses 0 0 0 50 Total Licenses and Permits 750 125 (625) 800 INTERGOVERNMENTAL REVENUE: Grant 306,176 309,680 3,504 307,051 Health 27,095 26,868 (227) 27,476 Total Intergovernmental Revenue 333,271 336,548 3,277 334,527 CHARGES FOR SERVICES: Charge for service 14,000 12,958 (1,042) 12,317 Protective inspection fees 10,850 7,621 (3,229) 12,295 Vital statistics 30,000 30,543 543 27,924 CC cultures 0 453 453 711 Clinic fees 29,875 51,173 21,298 30,282 Septic 40,000 43,931 3,931 53,628 Water 17,000 36,848 19,848 36,222 Total Charges for Services 141,725 183,527 41,802 173,379 MISCELLANEOUS REVENUE: Car seat rentals 600 757 157 555 Other revenue 0 9 9 158 Car seat donations 0 855 855 0 Total Miscellaneous Revenue 600 1,621 1,021 713 TOTAL REVENUE 476,346 521,821 45,475 509,419 PUBLIC HEALTH AND WELFARE: Public health administration 20,234 75,458 (55,224) 23,367 Nursing 808,916 800,999 7,917 747,316 Environmental Health 434,679 387,222 47,457 407,087 Total Public Health and Welfare 1,263,829 1,263,679 150 1,177,770 CAPITAL OUTLAY: Public health administration 10,000 8,668 1,332 4,557 Nursing 2,600 639 1,961 600 Total Capital Outlay 12,600 9,307 3,293 5,157 TOTAL EXPENDITURES 1,276,429 1,272,986 3,443 1,182,927 OPERATING TRANSFERS - IN: Non-Departmental 689,371 689,371 0 644,829 Environmental Health 6,000 0 (6,000) 0 TOTAL OPERATING TRANSFERS-IN 695,371 689,371 (6,000) 644,829 EXCESS OF REVENUE AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES $ (104,712) $ (61,794) $ 42,918 $ (28,679) as7OJo 7 COUNTY OF WELD STATE OA' COLORADO SPECIAL REVENUE FUNDS ADMAN RESOURCES FUND Schedule of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Est mate Actual —Mr Actual INTERGOVERNMENTAL REVENUE: Contract payments revenue S 983,649 $ 940,801 $ (42,848) $ 717,102 Other revenue 114,500 15,823 (98,677) 13,611 Grant 2,737,015 2,227,980 (509,035) 2,297,159 Other governmental units 0 9,824 9,824 87 Total Intergovernmental Revenue 3,835,164 3,194,428 (640,736) 3,027,959 CHARGES FOR SERVICES: Charge for service 0 304,367 304,367 181,090 Total Charges for Services 0 304,367 304,367 181,090 MISCELLANEOUS REVENUE: Other revenue 0 1,638 1,638 0 Other revenue 0 15 15 0 Donations from private sources 0 100,350 100,350 92,402 Loan repayments 0 53 53 224 Welfare diversion 0 0 0 0 Total Miscellaneous Revenue 0 102,056 102,056 92,626 TOTAL REVENUE 3,835,164 3,600,851 (234,313) 3,301,675 ECONOMIC ASSISTANCE: Human Resources 11,458 8,587 2,871 0 JTPA performance incentive 36,850 17,746 19,104 0 Dislocated farmers 99,902 49,850 50,052 98 JTPA 8% local distribution 16,838 13,331 3,507 11,367 JTPA 8% education coordination 10,484 10,484 0 33,139 JTPA 6% T.A.T. SDA to SDA 0 0 0 630 JTPA 6% training & tech assist 16,632 18,462 (1,830) 368 JTPA IIA 6% incentive 10,714 10,714 0 24,100 JTPA dislocated workers 22,681 25,313 (2,632) 41,647 JTPA older workers 59,913 34,903 25,010 34,894 6% TAT C.O. 50,000 44,639 5,361 0 JTPA discretionary School Dist. #6 0 0 0 7,268 MIS - tape 33,798 19,184 14,614 0 JTPA 8% youth 0 0 0 1,940 JTPA incentive 35,000 1,561 33,439 38,468 Wagner-Peyser 10% PY85 0 0 0 20,000 Summer youth 344,735 295,841 48,894 286,685 JTPA basic 804,564 724,315 80,249 743,173 Job service 224,908 269,221 (44,313) 176,200 Job service incentive funds 0 10,889 (10,889) 6,111 UI Training program 0 1,638 (1,638) 0 Head Start 511,843 563,542 (51,699) 533,357 Head Start handicap 20,271 20,271 0 19,228 Head Start T & TA 10,724 10,724 0 15,015 Headstart bilingual/multicltrl 25,300 16,141 9,159 15,000 Migrant Hdst/day care basic 406,390 385,594 20,796 306,194 CSA/CAP 152,207 147,859 4,348 148,767 Migrant Head Start-handicap 0 20 (20) 3,549 Head Start - high scope 9,121 3,377 5,744 6,904 Supplemental foods 107,582 94,140 13,442 140,854 Supplemental foods - elderly 18,865 18,865 0 0 DOE weatherization 14,500 14,683 (183) 15,930 OAA Area Agency 39,184 37,784 1,400 32,097 OAA Title III-B 161,927 121,797 40,130 135,946 AAA case management 22,500 21,509 991 0 AAA legal aide IIB 0 (204) 204 0 AAA Ombudsman II-B 0 (359) 359 0 (Continued on next page) 88051'7 74 COUNTY OF WELD SPATE OF COLORADO SPECIAL REVENUE 1UNDS Schedule of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Estimate ActualVariance Actual ECONOMIC ASSISTANCE (CONTINUED): OAA Title III C-I congregate $ 136,620 $ 185,605 $ (48,985) $ 262,557 OAA Title III-C 34,409 64,319 (29,910) 58,534 NCBC training 0 108 (108) 381 Human resources general fund 0 172,810 (172,810) 200 Transportation 100,000 0 100,000 0 Welfare diversion 296,000 194,740 101,260 284,761 General administration allocation 0 0 0 0 EODS allocation 0 (399) 399 0 Non-EODS allocation 0 0 0 0 Transportation allocation 0 0 0 0 Total Economic assistance 3,845.920 3,629,604 216,316 3,405,362 CAPITAL OUTLAY: JTPA 8% local distribution 0 3,506 (3,506) 0 JTPA older workers 0 4 (4) 130 6% TAT C.O. 0 5,360 (5,360) 0 MIS - tape 0 14,614 (14,614) 0 JTPA 8% youth 0 0 0 184 Summer youth 0 66 (66) 1,842 JTPA basic 0 223 (223) 1,603 Job service 0 729 (729) 4,706 Head Start 0 5,005 (5,005) 16,429 Migrant Hdst/day care basic 0 32 (32) 590 CSA/CAP 0 37 (37) 28 Supplemental foods 0 21 (21) 1,5966 DOE weatherization 0 2 (2) OAA Area Agency 0 26 (26) 0 AAA case management 0 254 (254) 0 AAA legal aide IIB 0 204 (204) 0 AAA Ombudsman II-B 0 359 (359) 0 OAA Title III C-I congregate 0 11 (11) 162 OAA Title III-C 0 554 (554) 0 Transportation 0 195,564 (195,564) 63,382 EODS allocation 0 399 (399) 0 Total Capital outlay 0 226,970 (226,970) 90,668 TOTAL EXPENDITURES 3,845,920 3,856,574 (10,654) 3.496,030 OPERATING TRANSFERS - IN: OAA Area Agency 10,756 10,756 0 10,756 Welfare diversion 0 375,028 375,028 423,081 TOTAL OPERATING TRANSFERS-IN 10,756 385,784 375,028 433,837 EXCESS OF REVENUE AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND 0 1----12222a-130,0 $ 130,061 $ 239,482 OTHER USES $ 880507 COUNTY OF WELD STA'. LORiIO SPECIAL REVENUE FUNDS SOLID WASTE FUND Schedule of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Estimate =bur .1[r ance Actual CHARGES FOR SERVICES: 90,000 $ 16 5,180 .S.--21.11-10. 1--2-1-1--849 Landfill surcharge $ Total Charges for services 90,000 165,180 75,180 124,849 TOTAL REVENUE 90,000 165,180 75,180 124,849 MISCELLANEOUS: 90,000 25,922 64,078 24,871 Other operating transfers Total Miscellaneous 90,000 25,922 64,078 24,871 TOTAL EXPENDITURES 90,000 25,922 64,078 24,871 OPERATING TRANSFERS - OUT: 0 (54,500) (54,500) (60.000) Other operating transfers TOTAL OPERATING TRANSFERS-OUT 0 (54,500) (54,500) (60,0(10) EXCESS OF REVENUE AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND $ 0 $ 84,758 $ 84,758 1--222-221. OTHER USES . 88®507 76 COUNTY OF WELD STATE OF COLORADO SPECIAL RhVLNUE FUNDS HODS iNG AUTHORITY FUND Schedule of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Este ActualVariance Actual INTERGOVERNMENTAL REVENUE: Contract payments revenue $ 1,216,387 $ 926,251 $ (290,136) $ 626,880 CDBG loan proceeds 15,200 19,411 4,211 0 Total Intergovernmental revenue 1,231,587 945,662 (285,925) 626,880 MISCELLANEOUS REVENUE: 0 1,472 1,472 1,783 Earnings on deposit Sale of assets 0 1,500 1,500 0 Total Miscellaneous revenue 0 2,972 2,972 1,783 TOTAL REVENUE 1,231,587 948,634 (282,953) 628,663 MISCELLANEOUS: 0 5,990 (5,990) 4,795 Other General administration Post-administrative expenses 6,250 8,177 (1,927) 6,250 Administrative expenses 54,979 21,798 33,181 34,344 General administration 43,682 32,066 11,616 21,777 Total Miscellaneous 104,911 68,031 36,880 69,451 ECONOMIC ASSISTANCE: 0 0 0 12,577 Program admin/rehab. Housing assistance 471,936 365,582 106,354 249,734 Rehabilitation program 0 0 0 167,866 Housing vouchers preliminary 15,050 15,050 0 2,795 Housing voucher administrative 17,880 7,860 10,020 3,488 Housing voucher payments 186,634 172,921 13,713 29,947 947 Division of housing 11,316 23,158 (11,842) Rental rehabilitation 21,336 14,298 7,038 31,667 CDBG contract payments 402,124 262,873 139,251 52,538 Total Economic assistance 1,126,276 861,742 264,534 557,454 CAPITAL OUTLAY: 0 3,986 General administration 0 0 General administration 600 157 443 0 Total Capital outlay 600 157 443 3,986 TOTAL EXPENDITURES 1,231,787 929.930 301,857 630,891 EXCESS OF REVENUE AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES $ (200) $ 18,704 $ 18,904 L.--112-31) 88050/! 77 wupe COLORADO 88054."7 78 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. r14(4 '5 'lilt use COLORADO 8S05?"7 COUNTY OF WELD STATE OF COLORADO CAPITAL PROJECTS FUNDS EXPLANATIONS OF INDIVIDUAL FUNDS December 31 , 1987 Capital Expenditures Fund: This fund accounts for various capital improvement projects on County property. 79 880507 COUNTY OF WELD STATE OF COLORADO CAPITAL PROJECTS BOND cATTIMMTPEADITIMErTIND BALANCE SHEET December 31, 1987 and 1986 1987 1986 ASSETS ASSETS: Cash and short term investments $ 1,514,833 S 136,830 Cash - other 3,925 0 Receivables (net of allowance for uncollectibles): Current property tax 532,000 259,046 Delinquent property tax 5,255 8,968 Accounts 1,030 0 Due from other county funds 80 23 Due from other governmental units 0 51,800 TOTAL ASSETS $ 2,057,123 $ 456,667 LIABILITIES AND FUND BALANCE LIABILITIES: Accounts payable $ 60,397 $ 38,638 Accrued liabilities 1,675 0 Due to other county funds 80 23 Deferred revenue 537,255 268,014 Retainage payable 72,014 25,440 Total Liabilities $ 671,421 $ 332,115 FUND BALANCE: Reserve for encumbrances $ 144,351 $ 116,887 Designated to future yrs expense 1,241,351 0 Fund balance - undesignated 0 7,665 Total Fund Balance $ 1,385,702 $ 124,552 TOTAL LIABILITIES AND FUND BALANCE P.-24:-)52.22--23 $ 456,667 880507 80 COUNTY OF WELD STATE OF COLORADO CAPITAL PROJECTS FONDS ariTrEIPENITITOrNo Schedule of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Est mate Actual Variance Actual TAXES: General property tax $ 259,046 $ 261,987 $ 2,941 $ 553,409 Specific ownership taxes 18,445 16,700 (1,745) 38,520 Penalties & interest 0 1,463 1,463 2,960 Total Taxes 277,491 280,150 2,659 594,889 INTERGOVERNMENTAL REVENUE: Grant 0 0 0 62,085 CHARGES FOR SERVICES: Charge for service 0 6,155 6,155 10,040 Total Charges for Services 0 6,155 6,155 10,040 MISCELLANEOUS REVENUE: Bond proceeds 299,500 317,000 17,500 0 Sale of assets 1,710,000 1,710,000 0 0 Total Miscellaneous Revenue 2,009,500 2,027,000 17,500 0 EARNINGS ON INVESTMENTS: Earnings on deposit 0 1,030 1,030 0 Total Earnings on Investments 0 1,030 1,030 0 TOTAL REVENUE 2,286,991 2,314,335 27,344 667,014 MISCELLANEOUS: Buildings 0 17,298 (17,298) 0 Total Miscellaneous 0 17,298 (17,298) 0 CAPITAL OUTLAY: Buildings 1,294,879 1,034,212 260,667 922,462 Total Capital Outlay 1,294,879 1,034,212 260,667 922,462 DEBT SERVICE: Buildings 0 1,675 (1,675) 0 Total Debt Service 0 1,675 (1,675) 0 TOTAL EXPENDITURES 1,294,879 1,053,185 241,694 922,462 OPERATING TRANSFERS - IN: Non-Departmental 0 0 0 380,000 TOTAL OPERATING TRANSFERS-IN 0 0 0 380,000 EXCESS OF REVENUE AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES P---19111--12. $ 1,261,150 1---2±112M. $ 124,552 81 580507 COLORADO 82 SPECIAL ASSESSMENT FUNDS Special assessment funds are used to account for the financing of public improvements or services deemed to benefit the properties against which special assessments are levied. Off Elk COLORADO COUNTY OF WELD STATE OF COLORADO SPECIAL ASSESSMENT FUNDS EXPLANATIONS OF INDIVIDUAL FUNDS December 31 , 1987 Improvement District Number 1981-2 Elmore Road: This special assessment fund accounts for the Elmore Road paving project, including subsequent collection of the special assessment from affected property owners. Financing was provided through an advance from the General Fund since the size of the improvement district project made bond financing impractical. Improvement District - Road 5: This special assessment fund accounts for the Road 5 paving project. Financing was made available through a bond issue. Antelope Hills District: This special assessment fund accounts for the Antelope Hills paving project, including subsequent collection of the special assessment from affected property owners. Financing was provided through an advance from the General Fund and monies accumulated into the Antelope Hills Trust Fund. The size of the improvement district made bond financing impractical. Indianhead District: This special assessment fund accounts for the Indianhead Subdivision paving project, including subsequent collection of the special assessment from affected property owners. Financing was provided through an advance from the General Fund since the size of the improvement district project made bond financing impractical. 83 880507 COUNTY OF WELD STATE OF COLORADO SPECIAL ASSESSMCN2 kONDS COMBINING BALANCE SHEET December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 Improvement District Improvement Antelope Number 1981-2 District Hills Special Elmore Road Road - 5 Assessment ASSETS ASSETS: Cash and short term investments $ 3,303 $ 47,229 $ 3,222 Special assessment 3,373 875,000 16,842 0 0 Due from other county funds0 TOTAL ASSETS L.----t,676 1--912-1222. $ 20,064 LIABILITIES AND FUND BALANCE LIABILITIES: Due to other county funds $ 0 $ 0 S 0 Deferred revenue 2,530 800,000 14,970 Advance from other funds 3,373 75,000 16,842 Bonds payable 0 700,000 0 Total Liabilities $ 5,903 $ 1,575,000 $ 31,812 FUND BALANCE(DEFICIT): Fund balance - undesignated $ 773 Lain) 1--W-2-- 7L-'8) Total Fund Balance (Deficit) $ 773 $ (652,771) 1-2-2-3.-:22±) TOTAL LIABILITIES AND FUND BALANCE $ 6,676 $ 922,229 $ 20,064 • 880501 84 Indian Memorandum Total Head Special December 31 December 31 Assessment 1987 1986 $ 0 S 53,754 $ 56,171 7,056 902,271 1,006,758 8,749 8,749 42,030 $ 15,805 $ 964,774 $ 1,104,959 $ 8,749 $ 8,749 $ 60,538 6,350 823,850 928,110 7,056 102,271 106,758 0 700,000 800,000 I-21,155 $ 1,634,870 L1,895,406. $ (6,350) $ (670,096) $ (790,447) $ (6,350) $ (670,096) $ (790,447) $ 15,805 .%-.1612-1. 774 La-' 59 880507 85 COUNTY OF WELD STATE OF COLORADO SPECIAL ASSES-SMENi-r ONDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 Improvement District Improvement Antelope Number 1981-2 District Hills Special Elmore Road Road - 5 Assessment REVENUES: 1,872 $S750 $ 12,579 Miscellaneous $ EXPENDITURES: 0 0 0 Capital outlay 0 72,500 0 Debt service Total Expenditures 0 72,500 0 EXCESS OF REVENUES OVER (UNDER) EXPENDITURES 1,872 112,250 12,579 OTHER FINANCING SOURCES: 0 0 0 Operating transfers - in TOTAL OTHER FINANCING SOURCES 0 0 0 EXCESS OF REVENUES AND OTHER SOURCES 12 Sig OVER (UNDER) EXPENDITURES 1,872 112,250 > FUND BALANCE AT BEGINNING OF YEAR (1,099) (765,021) (24,327) FUND BALANCE AT END OF YEAR $ 773 $ (652,771) $ (11,748) 13805C1 86 Indian Memorandum Total Head Special December 31 December 31 Assessment 1987 1986 $ 706 $ 199,907 S 205,499 8,749 8,749 57,503 0 72,500 81,776 8,749 81,249 139,279 (8,043) 118,658 66,220 1,693 1,693 30,474 1,693 1,693 30,474 (6,350) 120,351 96,694 0 (790,447) (887,141) $ (6,350) S211) S (790,447) 88050"7 87 COUNTY OF WELD STATE OF COLORADO SPECIAL ASSESSMENT FUNDS I 5 Schedule of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Estimate ActualVarianceActual MISCELLANEOUS REVENUE: Earnings on deposit $ 84,750 $ 84,750 $ 0 $ 99,938 Special assessments 100,000 100,000 0 100,000 Total Miscellaneous Revenue 184,750 184,750 0 199,938 TOTAL REVENUE 184,750 184,750 0 199,938 DEBT SERVICE: Improvement districts 184,750 72,500 112,250 80,750 Total Debt Service 184,750 72,500 112,250 80,750 TOTAL EXPENDITURES 184,750 72,500 112,250 80,750 EXCESS OF REVENUE AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES $ 0 $ 112,250 $ 112,250 $ 119,188 880507 88 COUNTY OF WELD SliarartrannaDO SPECIAL ASSE:SSMENt FINDS IMPROVEMENT DISTRICT NOMBhR 1981-2 ELMORE ROAD Schedule of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Est mate Actual Variance Actual MISCELLANEOUS REVENUE: Earnings on deposit $ 650 $ 620 $ (30) $ 1,026 Special assessments 1,253 1,252 (1) 1,832 Total Miscellaneous Revenue 1,903 1,872 (31) 2,858 TOTAL REVENUE 1,903 1,872 (31) 2,858 DEBT SERVICE: Improvement districts 0 0 0 1,026 TOTAL EXPENDITURES 0 0 0 1,026 EXCESS OF REVENUE AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES $ 1,903 $ 1,872 $ (31) $ 1,832 89 880507 COUNTY OF WELD STATE OF COLORADO SPECIAL ASSESSMENT ANDS ANTELOPE HILLS SPECIAL ASSESSMENT Schedule of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 -Warr Actual ar ance Actuate MISCELLANEOUS REVENUE: 3300 $ 3,223 $ (77) $ 0 Earnings on deposit $ 9,360 3,226 (4) 2.700 Special assessments Total Miscellaneous Revenue 12,660 12,579 (81) 2,703 TOTAL REVENUE 12,660 12,579 (81) 2,703 CAPITAL OUTLAY: 57,503 Improvement districts 0 0 0 TOTAL EXPENDITURES 0 0 0 57,503 OPERATING TRANSFERS - IN: 0 30,474 Non-Departmental 0 0 TOTAL OPERATING TRANSFERS-IN 0 0 0 30,474 EXCESS OF REVENUE AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES $ 12,660 S 1 , 2579 $ (81) $ (24,326) 90 880507 COUNTY OF WELD STATE OF COLORADO SPECIAL ASSESSMENT FUNDS INDIAN HEAD SPECIAL ASSESSMENT Schedule of Revenues and Expenditures, Budget and Actual December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Estimate Actual Variance Actual MISCELLANEOUS REVENUE: Special assessments $ 7,056 $ 706 $ (6,350) $ 0 Total Miscellaneous Revenue 7,056 706 (6,350) 0 TOTAL REVENUE 7,056 706 (6,350) 0 CAPITAL OUTLAY: 0 Improvement districts 8,750 8,749 1 Total Capital Outlay 8,750 8,749 . 1 0 TOTAL EXPENDITURES 8,750 8,749 1 0 OPERATING TRANSFERS - IN: 0 Non-Departmental 1,694 1,693 (1) TOTAL OPERATING TRANSFERS-IN 1,694 1,693 (1) 0 EXCESS OF REVENUE AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES $ 0 $ (6,350) $ 350 (6, ) $ 0 91 880507 ottig‘tr COLORADO 92 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. COLORADO 880507 COUNTY OF WELD STATE OF COLORADO ENTERPRISE FUNDS EXPLANATIONS OF INDIVIDUAL FUNDS December 31 , 1987 Ambulance Fund: This fund accounts for the ambulance services provided to Weld County. 93 880507 COUNTY OF WELD STATE-OF COLORADO ENTERPRISE FUND BALANCE SHEET December 31, 1987 1987 ASSETS ASSETS: Cash and short term investments $ 67,904 Accounts - Ambulance service 204,661 Accounts 4,052 Due from other county funds 90,415 Total Current Assets 367,032 FIXED ASSETS: Machinery and equipment 31,717 Accumulated depreciation (6,476) Total Fixed Assets 25,241 TOTAL ASSETS $ 392,273 LIABILITIES AND FUND EQUITY LIABILITIES: Accounts payable $ 6,999 Accrued liabilities 66,856 Due to other county funds 39,904 Total Liabilities $ 113,759 FUND EQUITY: Contributed capital $ 19,762 Retained earnings 258,752 Total Fund Equity $ 278,514 TOTAL LIABILITIES AND FUND EQUITY $ 392,273 94 880507 COUNTY OF WELD STATE OF COLORADO ENTERPRISE }UND AMBULANCE FUND Schedule of Operating Revenues Compared with Estimate December 31, 1987 1987 1987 1987 Estimate ctuaVariance OPERATING REVENUE: $ 876,462 $ 1,192,479 $ 316,017 Rescue unit fees TOTAL OPERATING REVENUE P----8214--142. $S79 S 316,017 Schedule of Non-Operating Revenues Compared with Estimate December 31, 1987 1987 1987 1987 Estimate Actual Variance NONOPERATING REVENUE: $ 0 $ 1,262 $ 1,262 Other revenue 0 1,450 1,450 Donations 110,038 0 (110,038) In kind TOTAL NONOPERATING REVENUE 1.-122421t $ 2,712 $ (107,326) Schedule of Expenditures Compared with Budget December 31, 1987 1987 1987 1987 Budget ActualVariance OPERATING EXPENSES:Personnel services $ 666,128 $ 675,916 $ (9,788) 35,173 36,592 (1,419) Contractual services 42,480 31,830 10,650 Supplies 8,120 6,885 1,235 Heat, light, and power 70,044 88,629 (18 585) Repair and maintenance 21,689 15,000 6,689 Insurance and bonds Other expenses 112,866 313,477 (200,611) Depreciation expense 0 6,928 (6,928) TOTAL EXPENDITURES $ 956,500 $ 1,175,257 $ (218,757) Schedule of Fixed Asset Acquisitions Compared with Budget December 31, 1987 1987 1987 1987 Budget Actual Variance FIXED ASSET ACQUISTIONS: Capital outlay L----La 1---212--- 73.2 $ (1,717) TOTAL FIXED ASSET ACQUISITION 2----311222. $ 31,717 $ (1,717) 880507 95 COUNTY OF WELD STATE OF COLORADO ENTERPRISE AOND Schedule of Operating Transfers-in Compared with Estimate December 31, 1987 1987 1987 1987 Estimate Actual Variance OPERATING TRANSFERS-IN: $ 0 $ 110,038 $ 110,038 General Fund Total Operating Transfers-in $ 0 $ 110,038 $ 110,038 96 880507 INTERNAL SERVICE FUNDS Internal Service Funds are established to account for goods and services provided to other departments of the County on a cost-reimbursemeut basis. iii, wilpe COLORADO apt.' COUNTY OF WELD STATE OF COLORADO INTERNAL SERVICE FUNDS EXPLANATIONS OF INDIVIDUAL FUNDS December 31 , 1987 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. Printing and Supply Fund: This fund accounts for revenue and costsassociated w the ooiin th providing tion oprinting services and the supply and stores funComputer 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. 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. 97 880507 COUNTY OF WELD STATE OF COLORADO INT)RNAL StRV10E iUNDS COMBINING BALANCE SHEET December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 Computer Motor Vehicle Printing and Services Fund Supply Fund Fund ASSETS CURRENT ASSETS: Cash and short term investments $ 526,654 $ 60,802 S 333,754 Cash - other 0 0 0 Receivables (net of allowance for uncollectibles): Current property tax 0 0 0 Delinquent property tax 0 0 0 Accounts 871 1,214 39,323 Due from other county funds 323,996 25,778 175,978 Inventories 25,353 122,238 0 Prepaid expenses 0 8,244 3,010 Total Current Assets 876,874 218,276 552,065 FIXED ASSETS: Land 712,970 0 0 Buildings 750,220 0 0 Improvements other than buildings 19,345 0 0 Machinery and equipment 9,565,416 81,837 2,018,134 Accumulated depreciation (5,619,549) (53,278) (1,301,168) Total Fixed Assets 5,428,402 28,559 716,966 Total Assets $ 6,305,276 $ 246,835 $ 1,269,031 LIABILITIES AND FUND EQUITY LIABILITIES Accounts payable $ 167,879 $ 6,787 $ 8,119 Accrued liabilities 0 4,661 149,109 Due to other county funds 11,012 26 2,251 Deferred revenue 0 0 29,981 Advance from other funds 0 80,000 0 Total Liabilities I-22,891 L-112--- 474- $ 189,460 FUND EQUITY: Contributed capital $ 5,023,933 $ 120,946 $ 565,155 Retained earnings 1,102,452 34,415 514,416 Total Fund Equity $ 6,126,385 $ 155,361 $ 1,079,571 TOTAL LIABILITIES AND FUND EQUITY 1-±22.2122 _$_-26.-.2--' 835. $ 1,269,031 98 880501 Memorandum Total Insurance PBX December 31 December 31 Fund Fund 1987 1986 $ 548,843 $ (12,991) $ 1,457,062 $ 1,446,733 7,500 0 7,500 7,500 511,095 0 511,095 5954 11,095 095 8,954 0 55,239 56,556 4,030 29,827 595,562 393,329 39,983 0 0 147,591 174,909 192,051 0 203,305 199,597 1,312,456 26,637 2,986,308 2,802,124 O 0 712,970 694,381 O 0 750,220 697,203 0 0 19,345 11,149,19719 345 O 85,106 11,750,493 0 (27,659) (7,001,654) (6,307,340) 0 57,447 6,231,374 6,252,786 L1,312,456 $ 84,084 $ 9,217,682 $ 9,054,910 $ 587,182 $ 8,057 $ 778,024 $ 645,320 O 6,524 160,294 169,793 0 38,280 520,049 3,202 0 550,030 543,500 O 0 80,000 43 500 $ 1,107,231 1--- 3-2122 $ 1,584,839 $ 1,476,893 $ 0 $ 74,467 $ 5,784,501 $ 5,712,895 205,225 (8,166) 1,848,342 1,865,122 $ 205,225 $ 66,301 $ 7,632,843 L2-0222212 $S2456 $ 84,084 $ 9,217,682 1.....225 • 99 880507 COUNTY OF WELD S'T'ATE OF COLORADO INTERNAL SERVICE FUNDS STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 Computer Motor Vehicle Printing and Services Fund Supply Fund Fund OPERATING REVENUE: Charges for services $ 2,406,645 $ 156,167 L-2.4.222-2--- 180 Total Operating Revenue 2,406,645 156,167 2,071,180 OPERATING EXPENSES: Personnel services $ 0 $ 55,637 $ 1,215,638 Contractural services 1,181,202 2,103 371,981 Supplies 285,522 73,739 46,437 Heat, light, and power 40,878 281 13,558 Repair and maintenance 68,618 15,274 119,641 Insurance and bonds 0 0 0 Claims 0 0 0 Other expenses 5,639 0 0 Depreciation expense 939,389 6,590 319,360 Total Operating Expenses 2,521,248 153,624 2,086,615 OPERATING INCOME (LOSS) (114,603) 2,543 (15,435) NON-OPERATING INCOME (LOSS): 0 $ 0 $ 0 Taxes $ 0 Miscellaneous revenue 0 0 Farm income 1,803 0 0 Gain (loss) on sale of assets 90,672 0 (865) Earnings on investments 0 0 0 Interest expense 0 0 0 Judgements and damages 0 0 Total Non-Operating Income (Loss) 92,475 0 (865) OTHER FINANCING SOURCES: 0 $ 100,000 Operating transfers - in $ 0 $ NET INCOME (LOSS) (22,128) 2,543 83,700 RETAINED EARNINGS AT BEGINNING OF YEAR 1,124,580 31,872 430,716 RETAINED EARNINGS AT END OF YEAR $S.52. $ 34,415 $ 514,416 880507 100 Memorandum Total Insurance PBX December 31 December 31 Fund Fund 1987 1986 $ 73,533 S 380,462 $ 5,087,987 $ 4,588,229 73,533 380,462 L-5- (1311211 $ 4,588,229 $ 0 $ 78,516 $ 1,349,791 $ 1,319,135 19,415 54,558 1,629,259 1,451,478 2,279 1,103 409,080 340,802 0 175,228 229,945 238,610 O 39,941 243,474 224,723 478,669 0 478,669 372,345 285,647 0 285,647 132,136 O 5,069 10,708 35,391 0 8,511 1,273,850 1,245,277 786,010 362,926 $ 5,910,423 L112.512222. (712,477) 17,536 (822,436) (771,668) $ 548,693 $ 0 $ 548,693 $ 546,921 0 108 108 0 O 0 1,803 2,807 O 0 89,807 11,329 22,320 0 22,320 37,661 0 (17,303) (17,303) (20,094) 60,228 0 60,228 30,492 631,241 (17,195) 705,656 609,116 $ 0 , $ 0 $ 100,000 $ 0 (81,236) 341 (16,780) (162,552) 286,461 (8,507) 1,865,122 2,027,674 $ 205,225 $ (8,166) .2-23f-L---1.8 342 $ 1,865,122 p101 88050wry COUNTY OF WELD STATE OF COLORADO INTrETATE7117DS COMBINING STATEMENT OF CHANGES IN CONTRIBUTED CAPITAL December 31, 1987 Computer Motor Vehicle Printing & Services Fund Supply Fund Fund PBX Fund Total CONTRIBUTED CAPITAL January 1, 1987 S 4,952,327 $ 120,946 $ 565,155 $ 74,467 $ 5,712,895 Add: 1987 contributions from 0 71,606 Capital Expenditures Fund 71,606 0 0 CONTRIBUTED CAPITAL, December 31, 1987 $ 5,023,933 $ 120,946 $ 565,155 $ 74,467 S 52784,501 8805C1 102 COUNTY OF WELD STATE OF COLORADO INTERNAL SERVICE I S COMBINING STATEMENT OF CHANGES IN FINANCIAL POSITION December 31, 1987 Computer Motor Vehicle Printing & Services Insurance PBX Fund Total Fund Supply Fund Fund Fund WORKING CAPITAL PROVIDED: S 2,543 $ 83,700 $ (81,236) $ 341 $ (16,780) Net Income(loss) $ (22128) Items which did not require outlay of working capital: 939,389 6,590 319,360 0 8,852 1,273,850 Depreciation (Gain) on sale of 88,942) 0 (865) 0 0 (69,807) fixed assets Working capital pro- vided by operations 828,319 9,133 , Contribuitons from Capital 71,606 0 0 0 0 71,606 Expenditures Fund Proceeds from sale 172,045 0 2,230 0 0 174,275 of assets Total Working 0 0 1,413,144 Capital Provided 1,071,970 9,133 404,425 WORKING CAPITAL APPLIED: Acquisition of 1 171 313 8,656 156,935 0 0 1,336,904 fixed assets Total Working 0 0 1,336,904 Capital Applied 1,171,31 56 3 8,6 16,5935 INCREASE (DECREASE) 477 $ 247,490 $ (81,236) $ 8,852 $ 76,240 IN WORKING CAPITAL $ (99,343) $ CHANGES IN COMPONENTS OF WORKING CAPITAL: Increase (decrease) in current assets: Cash & short term investments $ (187,440) $ 41,979 $ 77,381 $ 29,620 $ 48,791 $ 10,331 Receivables: 384 410 13,730 (9,683) (6,158) (1,317) Accounts Property taxes 0 0 0 (3,451) 0 (3,451) (delinquent) Due from other 0 0 0 (27,318) 0 county funds 153,672 (9,081) 56,256 35,195 (33,809) 202,233 Inventories 7,745 (35,063) Prepaid and other 0 0 3,010 698 0 3,708 assets Net increase (decrease) in current assets (25,639) (1,755 150,377 52,379 8,824 184,1 6 (Increase) decrease in current liabilities:Accounts payable (63,760)63 760 (3,622) 69,688 (137,066) 2,056 (132,704) ' 0 (746) 9,075 0 1,168 9,497 Accrued liabilties Due to other county (9,944) 6,600 28,331 0 (3,196) 1,791) funds 1,791 0 0 (9.981) 3,451 0 Deferred revenue Net (increase) decrease in current 2, 97,113 (133,615) 28 (107,946) liabilities (73,704) 232 INCREASE (DECREASE) 477 $ 247,490 $ (81,236) S____12122_ $ 76,240 IN WORKING CAPITAL $ (99,343) $ 103 880507 COUNTY OF WELD STATE OF COLORADO INThRNAL SERVICE PONDS MOTOR VEHICLE FUND Schedule of Operating Revenues Compared with Estimate December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Estimate ActualVariance Actual OPERATING REVENUE: $ 1,568,189 $ 1,467,256 $ (100,933) S 1,255,390 Charge for service 926 792 939,389 12,597 891,324 Depreciation > 0 0 0 0 r Miscellaneous revenue 0 0 0 62,835 Other revenue TOTAL OPERATING REVENUE $ 2,494,981 $ 2,406,645 $ (88,336) L.2..2212122!—.9 Schedule of Non-Operating Revenues Compared with Estimate December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Estimate Actual Variance Actual NONOPERATING REVENUE: $ 0 $ 1,803 $ 1,803 $ 2,807 Rents from land 98,465 8,277 (90,188) 15,367 Sale of assets 0 0 0 6,206 Compensation for loss 0 82,395 82,395 (4,038) Gain on sale of assets TOTAL NONOPERATING REVENUE $ 98,465 $ 92,475 $ (5,990) 1---222--.2 Schedule of Operating Expenses Compared with Budget December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Budget Actual Variance Actual OPERATING EXPENSES:Contractural services $ 1,124,043 $ 1,181,202 $ (57,159) $ 996,815 Supplies300000 285,522 14,478 221,942 45,000 40,878 4,122 35,012 Heat, and maintenance light, and power 99,146 68,618 30,528 74,406 Repair > 0 5,639 (5,639) 26,228 Other expenses 926,792 939,389 (12,597) 891,324 Depreciation expense TOTAL OPERATING EXPENSES 1-22S94,981 1-.2a—' 211.5. $ (26,267) $ 2,245,727 Schedule of Fixed Asset Acquisitions Compared with Budget December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 . 1986 BudgetActual Variance Actual FIXED ASSET ACQUISTIONS: $ 1,0 25,257 $ 1,171,313 1-2-i-2--1.61356 $ 905,716 Capital outlay TOTAL FIXED ASSET ACQUISITION $ 1,025,257 $ 1,171,313 $ 146,056 $ 905,716 880507 104 COUNTY OF WELD STATE OF COLORADO INTERNAL SERVICE IUNbS PRINTING AND SUPPLY FUND Schedule of Operating Revenues Compared with Estimate December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Estimate Actual Variance Actual OPERATING REVENUE: Charge for service $ 96,000 $ 111,996 $ 15,996 $ 108,344 Sale of supplies 46,000 44,149 (1,851) 48,828 Other revenue 0 22 22 4,455 TOTAL OPERATING REVENUE $S2 $ 156,167 $ 14,167 $ 161,627 Schedule of Operating Expenses Compared with Budget December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Budget Actual Variance Actual OPERATING EXPENSES: Personnel services $ 55,750 S 55,637 $ 113 $ 51,392 Contractural services 290 2,103 (1,813) 70 Supplies 58,229 73,739 (15,510) 79,076 Heat, light, and power 0 281 (281) 209 Repair and maintenance 12,400 15,274 (2,874) 16,809 Other expenses 1,500 0 1,500 1,215 Depreciation expense 9,831 6,590 3,241 8,232 TOTAL EXPENSES $ 138,000 $S.- $ (15,624) 1---2-1-37022 Schedule of Fixed Asset Acquisitions Compared with Budget December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Budget Act— arm iance Actual FIXED ASSET ACQUISTIONS: Capital outlay 1.----b--. 000 $ 8,656 1..-.. ..2--' 65€1) 1-.-....12--. 242 TOTAL FIXED ASSET ACQUISITION $ 4,000 $ 8,656 ..$---E-2-' 656) $ 1,242 105 . 880507 COUNTY OF WELD STATE OF COLORADO INTERNAL SERVICE FONDS COMPUTER SERVICES FUND Schedule of Operating Revenues Compared with Estimate December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Estimate =Err Variance Actual-- OPERATING REVENUE: $ 1,851,857 $ 1,972,013 $ 120,156 $ 1,782,371 Charge for service 13 103,291 99,167 (4,124) ,898 Charge for service TOTAL OPERATING REVENUE $ 1,955,148 $ 2,071,180 $ 116,032 $ 1,796,269 Schedule of Non-Operating Revenues Compared with Estimate December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Estimate Actual Variance Actual NONOPERATING REVENUE: 0 $ 500 $ 500 $ 0 Gain on sale of assets $ 0 (1,500) (1,500) 0 Loss on sale of assets TOTAL NONOPERATING REVENUE $ 0 $ (865) $ (865) $ 0 Schedule of Operating Expenses Compared with Budget December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Budget ActualVariance Actual OPERATING EXPENSES: Personnel services $ 1,223,016 $ 1,215,638 $ 7,378 $ 1,170,092 Contractural services 404,916 371,981 32,935 357,358 45 350 46,437 (1,087) 39,084 Supplies 12,828 13,558 (730) 12,270 Heat, light, and pane 123,431 119,641 3,790 109,696 Repair and maintenance 300,000 —32.9-219- (1 9,360) 337,210 Depreciation expense TOTAL EXPENSES $ 2,109,541 $ 2,086,615 $ 22,926 $ 2,025,710. Schedule of Fixed Asset Acquisitions Compared with Budget December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Budget Actual Variance Actual FIXED ASSET ACOUISTIONS: $ 133,056,935 $ (23,928) S 129.482 Capital outlay 07 $ 1 129,482 TOTAL FIXED ASSET ACQUISITION $ 133,007 §--2a12-31 $ (23,928) $ Schedule of Operating Transfers-in Compared with Estimate December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 EstimateActual Var ance Actual OPERATING TRANSFERS - IN: 1-102:2-91 1 ,000 $ 100,000 $ 0 $ • 0 Non-Departmental TOTAL OPERATING TRANSFERS-IN S 100,000 §-n100,00 $ 0 $ 0 880507 106 COUNTY OF WELD STATE OF COLORADO I S INSURANCE FLND Schedule of Operating Revenues Compared with Estimate December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Estimate ra Variance Actual OPERATING REVENUE: Charge for service L-5,250. $ 73,533 $ 68,283 $ 50,000 TOTAL OPERATING REVENUE L.---5-12j2. $ 73,533 $ 68,283 $ 50,000 Schedule of Non-Operating Revenues Compared with Estimate December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Estimate Actual Variance Actual NONOPERATING REVENUE: General property tax $ 511,095 $ 512,895 S 1,800 $ 508,936 Specific ownership taxes 38,500 32,914 (5,586) 35,275 Penalties & interest 0 2,884 2,884 2,710 Earnings on deposit 29,000 22,320 (6,680) 37,661 Compensation for loss 20,000 60,228 40,228 24,286 TOTAL NONOPERATING REVENUE $ 598,595 $ 631,241 $ 32,646 8 608,868 Schedule of Operating Expenses Compared with Budget December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Budget Actual Variance Actual OPERATING EXPENSES: Contractural services $ 20,500 $ 19,415 $ 1,085 $ 67,713 Supplies 1,100 2,279 (1,179) 65 Insurance and bonds 464,884 478,669 (13,785) 372,345 Claims 450,250 285,647 164,603 132,136 TOTAL EXPENSES $ 936,734 L-786,210 $ 150,724 $ 572,259 88b07 COUNTY OF WELD STATE OF COLORADO I S PBX FUND Schedule of Operating Revenues Compared with Estimate December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Estimate Actual Variance Actual OPERATING REVENUE:Charge for service $ 376 720 S 324,250 $ (52,470) $ 318,944 51,534 56,212 4,678 51,840 Charge for service TOTAL OPERATING REVENUE $ 428,254 1-28-221—'62 $ (47,792) $ 370,784 Schedule of Non-Operating Revenues Compared with Estimate December 31, 1987 With Comparative Actual' mounts For Year Ended December 31, 1986 1987 1987 1987 1986 EstimateActual Var ance Actual NONOPERATING REVENUE: $ 0 $ 108 $ 108 $ 0 Otherrevenue (29,592) 0 29,592 (731) Principal (17,855) (17,303) 552 (19,363) Interest TOTAL NONOPERATING REVENUE §-2--2--1741.7)7447) 1-12-7--"73t5)7195) 1-2222-52. $ (20,094) Schedule of Operating Expenses Compared with Budget December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 - 1986 Budget Actual Variance Actual OPERATING EXPENSES:Personnel services $ 78,450 $ 78,516 $ (66) $ 97,651 , Contractural services 56,502 54,558 1,944 29,522 Supplies 891 1,103 (212) Heat, light, and power 184,430 175,228 9,202 191,119 Repair and maintenance 42,876 39,941 2,935 23,812 Other expenses 7,658 5,069 2,589 7,948 Depreciation expense 10,000 8,511 1,489 8,511 TOTAL EXPENSES $ 380,807 $ 362,926 $ 17,881 $ 359,198 108 880507 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 fur individuals, governmental entities and non—public organizations. p if WI`oc. COLORADO 886,57? COUNTY OF WELD STATE OF COLORADO TRUST AND AGENCY FUNDS EXPLANATIONS OF INDIVIDUAL FUNDS December 31 , 1987 Pension Trust Funds: 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. Health Insurance Trust Fund: This fund accounts for cash held in trust for employees and the County for the self-insured health insurance coverage. Revenue is generated from contributions from both employees and the County as the employer, and disbursements are made after insuring claims have been approved by our independent insurance adjuster. Employee Flexible Spending Fund: This fund accounts for the voluntary tax deferred payment of unreimbursed insurance claims. Requet for payment must be incurred and paid for the current calendar year. 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. Through 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. 880507 109 COUNTY OF WELD STATE OF COLORADO TRUST AND AGENCY FUNDS COMBINING BALANCE SHEET December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 Weld County North Colorado Health Employee Retirement Medical Insurance Flexible Fund Trust Fund Fund Spending ASSETS ASSETS: Cash and short term investments $ 140,962 $ 2,829,106 $ 859,323 $ 4,964 Cash - other 127,395 0 0 0 Investments 19,869,057 0 0 0 Delinquent property tax 0 1,965 0 0 Accounts 225,408 31,063 7,670 0 Due from other county funds 0 0 0 0 Prepaid expenses 58,770 0 0 0 Prepaid and Other Assets 0 0 0 0 TOTAL ASSETS $ 201--121L03. $ 2,862,134 $ 866,993 1.---1-1--4964 LIABILITIES AND FUND BALANCE LIABILITIES: Voucher and warrants payable $ 91,420 $ 0 $ 0 $ 0 Accounts payable 0 0 216,631 3,551 Due to other governments 0 0 0 0 Due to other county funds 1,140 0 6,079 1,413 Deferred revenue 0 1,965 0 0 Deferred compensation payable 0 0 0 0 Total Liabilities $ —'22,12t-D 1,965 L_...232.1112 $ 4,964 FUND BALANCE: Reserve for encumbrances $ 0 $ 0 $ 60 S 0 Reserve for employee benefits 20,121,007 0 0 0 Fund balance - undesignated 208,025 2,860,169 644,223 0 Total Fund Balance $ 20,329,032 1-20±2.2341 $ 644,283 $ 0 TOTAL LIABILITIES AND FUND BALANCE $ 20,421,592 $ 2,862,134 1-222222. $ 4,964 110 880507 General Payroll Deferred Agency Agency Compensation December 31 December 31 Fund Fund Fund 1987 1986 $ 3,143,978 $ 421,419 $ 0 $ 7,399,752 $ 9,360,748 O 0 0 127,395 9,496 O 0 663,105 20,532,162 20,314,295 O 0 0 1,965 7,787 O 307 0 264,448 232,968 0 4,898 0 4,898 6,249 O 0 0 58,770 40,907 O 0 0 0 107 $ 3,143,978 $ 426,624 1—..f:§222-21 $ 28,389,390 $ 29,972,557 $ 0 $ 426,554 $ 0 $ 517,974 $ 507,285 O 0 0 220,182 107,391 3,143,978 0 0 3,143,978 3,497,049 O 70 0 8,702 4,892 O 0 0 1,965 7,787 O 0 663,105 663,105 509,526 $ 3,143,978 $ 426,624 1.---M3,105 $ 4,555,906 $ 4,633,930 $ 0 $ 0 $ 0 $ 60 $ 0 O 0 - 0 20,121,007 20,121,007 0 0 0 3,712,417 5,217,620 $ 0 $ 0 $ 0 $ 23,833,484 $ 25,338,627 $ 3,143,978 $ 426,624 - $ 663,105 $ 28,389,390 $ 29,972,557 880507 111 COUNTY OF WELD STATE Ok COLORADO TRUST AND AGENCY FORDS STATEMENT OF REVENUES EXPENSES AND CHANGES IN FUND BALANCES - ALL PENSION TRUST FUNDS December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 Weld County Retirement Fund 1987 1986 OPERATING REVENUE: Earnings on investments $ 1,844,039 $ 3,105,919 Appreciation (depreciation) in fair market value of investments (2,369,532) (507,173) Contributions 1,675,355 1,487,861 Total Operating Revenue 1,149,862 4,086,607 OPERATING EXPENSES: Benefit payments $ 602,568 $ 464,517 Refunds 230,810 246,809 Audit fees 1,140 3,704 Actuarial fees 24,789 23,236 Trustee fees 70,896 72,554 Other expenses 11,634 17,358 Total Operating Expenses 941,837 828,178 INCOME BEFORE OPERATING TRANSFERS 208,025 3,258,429 OTHER FINANCING SOURCES: Operating transfers - in $ 0 $ 3,704 NET INCOME 208,025 3,262,133 FUND BALANCE AT BEGINNING OF YEAR 20,121,007 16,858,874 FUND BALANCE AT END OF YEAR $ 20,329,032 $ 20,121,007 880507 112 COUNTY OF WELD STATE OF COLORADO TRUST AND AGENCY FUNDS STATEMENT OF CHANGES IN FINANCIAL POSITION - ALL PENSION TRUST AONDS December 31, 1986 Weld County Retirement Fund WORKING CAPITAL PROVIDED: Net Income $ 208,025 Working capital provided by operations 208,025 INCREASE (DECREASE) IN WORKING CAPITAL $ 208,025 CHANGES IN COMPONENTS OF WORKING CAPITAL: Increase (decrease) in current assets: Cash and short term investments $ 17,189 Cash - other 120,399 Investments 64,288 Receivables (7,003) Prepaid and other assets 17,863 Net increase (decrease) in current assets 212,736 (Increase) decrease in current liabilities: Accounts payable (3,571) Due to other county funds (1,140) Net (increase) decrease in current liabilities (4,711) INCREASE (DECREASE) IN WORKING CAPITAL $ 208,025 113 880507 COUNTY OF WELD STATE OF COLORADO TRUST AND AGENCY FUNDS COMBINING STATEMENT OF REVENUES EXPENDITURES AND CHANGES IN FUND BALANCES - ALL EXPENDABLE TRUST FUNDS December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 North Colorado Health Employee Medical Center Insurance Flexible December 31 December 31 Trust Fund Fund Spending 1987 1986 REVENUES: Taxes $ 2,377 $ 0 $ 0 $ 2,377 $ 312,938 Miscellaneous 0 924,209 125,805 1,050,014 890,154 Earnings on investments 290,355 64,799 0 355,154 329,871 Total Revenues $ 292,732 1-9-§122-C. $ 3—a. $ 1,407,545 S 1,532,963 EXPENDITURES: Contractual services $ 0 $ 120,767 $ 0 $ 120,767 $ 114,112 Supplies 0 11,371 0 11,371 22,810 Insurance and bonds 0 0 0 0 31,293 Claims 0 1,152,770 0 1,152,770 742,447 Other expenses 1,710,000 0 125,805 1,835,805 69,704 Total Expenditures $ 1,710,000 $ 1,284,908 $ 125,805 $ 3,120,713 S 980,366 EXCESS OF REVENUES OVER (UNDER) EXPENDITURES (1,417,268) (295,900) 0 (1,713,168) 552,597 OTHER FINANCING SOURCES: 0 $ (15,474) Operating transfers - out $ 0 $ 0 $ 0 $ Total Other Financing Sources $ 0 $ 0 $ 0 S 0 a) EXCESS OF REVENUES AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES (1,417,268) (295,900) 0 (1,713,168) 537,123 FUND BALANCE AT BEGINNING OF YEAR 4,277,437 940,183 0 5,217,620 4,680,497 FUND BALANCE ATEND OF YEAR $ 2,860,169 $ 644,283 $ 0 $ 3,504,452 $ 5,217,620 880507 114 COUNTY OF WELD STATE OF COLORADO TRUST AND AGENCY tUNDS NORTH CO UST FUND Schedule of Revenues Compared with Estimate December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Estimate Actual— Variance Ac— t—ual TAXES: General property tax $ 0 $ 767 $ 767 $ 291,241 Specific ownership taxes 0 0 0 20,149 Penalties & interest 0 1,610 1,610 1,548 Total Taxes 0 2,377 2,377 312,938 EARNINGS ON INVESTMENTS: Earnings on deposit 0 290,355 290,355 271,148 Total Earnings on Investments 0 290,355 290,355 271,148 TOTAL REVENUE $ 0 $ 292,732 $ 292,732 $ 584,086 Schedule of Expenditures Compared with Budget December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Budget Actual— Variance Actual— OTHER EXPENSES: Buildings $ 0 -Ina P-113.--- 71.9.22(19) 1--a704± TOTAL EXPENDITURES $ 0 $ 1,710,000 $ (1,710,000) $ 69,704 115 880507 COUNTY OF WELD SYATh Oh' COLORADO TRUST AND AGENCY hU S HEALTH INSURANCE FUND Schedule of Revenues Compared with Estimate December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Estimate Actual Variance Ac—tu�al MISCELLANEOUS REVENUE: Car seat donations $ 800,440 $ 883,848 $ 83,408 $ 890,029 Cobra revenue 0 15,060 15,060 0 Recovery of losses 0 25,301 25,301 125 Total Miscellaneous Revenue 800,440 924,209 123,769 890,154 EARNINGS ON INVESTMENTS: Interest 0 455 455 518 Earnings on deposit 60,000 64,344 4,344 58,205 Total Earnings on Investments 60,000 64,799 4,799 58,723 TOTAL REVENUE .8-42-6.211-140. $ 989,008 $ 128,568 $ 948,877 Schedule of Expenditures Compared with Budget December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1987 1987 1986 Budget Actual Variance Actual CONTRACTUAL SERVICES: Other 1---2-2-1'8600 $ 1—n. $ (72,167) $ 114,112 Total Contractual Services 48,600 120,767 (72,167) 114,112 SUPPLIES: Other 4,000 11,371 (7,371) 22,810 Total Supplies 4,000 11,371 (7,371) 22,910 INSURANCE AND BONDS: Other 46,947 0 46,947 31,293 Total Insurance and Bonds 46,947 0 46,947 31,293 CLAIMS: Other 1,279,673 1,152,770 126,903 742,447 Total Claims 1,279,673 1,152,770 126,903 742,447 TOTAL EXPENDITURES $ 1,379,220 $ 1,284,908 $ 94,312 $ 910,662 880507 116 COUNTY OF WELD STATE OF COLORADO TRUST AND AGENCY PONDS EMPLOYEE. HLLXiSLE SPEND1Nh FUND Schedule of Revenues December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1986 c Actual— MISCELLANEOUS REVENUE: Loan repayments $ 125,805 $ 0 TOTAL REVENUE $ 125,805 $ 0 Schedule of Expenditures December 31, 1987 With Comparative Actual Amounts For Year Ended December 31, 1986 1987 1986 Actual Ac— tual OTHER EXPENSES: Office of the Board $ 2,700 $ 0 County Attorney 2,580 0 Planning and zoning 8,398 0 County Clerk 1,100 0 County Treasurer 3,000 0 County Assessor 991 0 Maintenance of buildings/grounds 2,520 0 District Attorney 3,700 0 Juvenile Diversion Grant 4,380 0 Financial administration 3,120 0 General accounting 2,580 0 Purchasing 900 0 Personnel 3,390 0 12,873 0 Data Processing 2,886 0 Sheriff administration 4,401 0 Crime control and invest 965 0 Communications Services 2,956 0 Ambulance services 8,120 0 Correctional administration Delinquents & other instil - 875 0 Pest/weed control 780 0 Maintenance of condition 134 0 Maintenance support 1,080 0 General engineering 624 0 Public health administration 1,200 0 Nursing 11,790 0 Environmental Health 300 0 Administrative - regular 25,093 0 Administrative - IV-D 220 0 Administrative - LEAP 480 0 Library administration 800 0 Gen admin allocation 5,040 0 EODS allocation 2,400 0 Non-EODS allocation 1,596 0 Other 1,833 0 TOTAL EXPENDITURES $ 125,805 $ 0 1380t147 COUNTY OF WELD STATE OF COLORADO TRUSS COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES - ALL AGENCY FUNDS December 31, 1987 Balance Balance 1/1/87 Additions Deductions 12/31/87 GENERAL AGENCY FUND ASSETS: Cash $ 3,497,049 $ 66,593,492 $ 66.946,563 $ 3,143,978 LIABILITIES: Due to other governmental units 3,497,049 66,593,492 66,946,563 3,143,978 PAYROLL AGENCY FUND ASSETS: , Cash and receivables 91S9-1 $ 17,302,828 $ 1-2-222111-91. S 426 624 LIABILITIES: Vouchers and accounts payable $ 419,487 $ 17,302,828 $ 17,295,691 $ 426,624 DEFERRED COMPENSATION FUND ASSETS: Investments .2_5S526 S 1,811,747 .1.1.". 658,168 $ 663,105 LIABILITIES: Deferred Compensation payable $ 509,526 $ 1,811,747 $ 1,658,168 $ 663,105 TOTAL - ALL AGENCY FUNDS TOTAL ASSETS $ 4,426,062 $ 85,708,067 $ 85,900,422 SSE TOTAL LIABILITIES $ 4,426,062 12.a67 $ 85,900,422 $ 4,233,707 118 880507 GENERAL FIXED ASSETS ACCOUNT GROUP Investments it property and equipment, except for those of the Internal Service rurds, are recorded in this account group. f Cif Avg COLORADO 8�3C 5J7 COUNTY OF WELD STATE OF COLORADO GENERAL ?LAED ASSETS SCHEDULE OF GENERAL FIXED ASSETS - BY SOURCE December 31, 1987 and 1986 1987 1986 GENERAL FIXED ASSETS: Land $ 2,095,212 $ 1,588,951 Buildings 18,428,653 18,738,024 Improvements other than buildings 230,920 218,011 Machinery and equipment 3,539,923 3.048,323 TOTAL GENERAL FIXED ASSETS $ 24,294,708 $ 23,593,309 INVESTMENTS IN GENERAL FIXED ASSETS FROM: $ 15,228,1OJ $ 14,653,466 Current Revenue Gifts and Grants 1,117,486 990,728 Federal Revenue Sharing 7,949,115 7,949,115 TOTAL INVESTMENTS IN GENERAL FIXED ASSETS "—±a2.92-1-1. 708 $ 23,593,309 119 880507 COUNTY OF WELD STATE OF COLORADO GENERAL HIRED ASSTS SCHEDULE OF GENERAL FIXED ASSETS - BY PUN(SON AND ACTIVITY December 31, 198/ and 19&6 Land Equipment & Memorandum Totals Land Improvements Buildings Furniture 1987 1986 General Government: County 0 $ O $ 18,785 $ 18,785 S 18,785 Commissioners $ 0 $ County Attorney 0 0 0 13,259 13,259 12,176 Planning & Zoning 0 0 0 20,788 20,788 21,956 General Accounting 0 0 0 14,643 14,643 14,730 Finance and 0 0 13,160 13,160 10,517 Administration 0 County Clerk 0 0 0 366,105 366,105 364,317 Elections 0 0 0 32,254 32,254 29,155 County Treasurer 0 0 0 42,630 42,630 42,472 County Assessor 0 0 0 71,805 71,805 72,509 County Council 0 0 0 3,022 3,022 3,228 Personnel 0 0 0 9,719 9,719 9,539 Buildings & 0 0 0 54,743 54,743 53,100 Grounds 0 0 0 536,657 536,657 355,059 Communications 0 0 0 12,592 12,592 10,157 Purchasing 0 0 84,318 84,318 57,432 Other 0 Buildings 1,703,272 953 15,025,764 187,376 16,925,915 16,293,382 Total General Government 1,703,272 9,503 15,025,764 1,481,856 18,220,395 17,368,514 Judicial: 0 77,goy 77,809 82,810 District Attorney 0 0 Public Safety: Sheriff 0 0 0 302,971 302,971 232,414 County Coroner 0 0 0 618 618 618 Building Inspection 0 0 0 3,812 3,812 4,217 Office of Emergency 0 43,155 43,155 48,382 Management 0 0 Total Public 0 350,556 350,556 285,631 Safety 0 0 Health and Hospitals: Health 162,369 15,068 134,344 200,290 512,071 1,275,197 Ambulance 0 5,465 118,599 6,508 130,572 202,104 Total Health and Hospitals 162,369 -MAIL 252,943 206,798 642,643 1,477,301 County Roads and Highways: Engineering and Administration 0 11,668 0 82,890 94,558 86,270 Public Welfare: Administration 170,318 9,088 S 251,194 1,171,533 1,130,943 Auxiliary Services: Extension 200 0 787,375 27,370 814,945 816,638 Exhibition Building 0 80,132 204,517 16,590 301,239 278,551 Veterans Office 0 0 0 10,402 10,402 10,402 Missle Site Park 0 91,310 0 72,314 163,624 192,130 Youth Shelter 0 0 48,812 6,977 55,789 58,224 Crime Control and Investigation 0 0 1,440 0 1,440 1,440 Libraries 19,085 7,020 1,013,952 196,416 1,236,473 1,095,893 Human Resources 39,968 1,666 352,917 750,512 1,145,063 700,649 Housing Authority 0 0 0 8,239 8,239 7,913 Total Auxiliary Services 59,253 180,128 2,409,013 1,088,820 3,737,214 3,161,840 TOTAL GENERAL FIXED ASSETS ALLOCATED TO FUNCTIONS L.2,222222 $ 230,920 $ 18,428,653 $ 3,539,923 $ 24,294,708 $ 23,593,309 120 8805e7 COUNTY OF WELD STATE OR COLORADO GERPII1-177O-1111"fS SCHEDULE OF CHANGES IN GENERAL FIXED ASSETS - BY AONCTION AND ACTIVITY December 31, 198/ and 1986 General General Fixed Assets Fixed Assets 12/31/86 Additions Deletions 12/31/87 General Government: County Commissioners $ 18,785 $ 165 $ 165 S 18,785 County Attorney 12,176 1,083 0 13,259 Planning & Zoning 21,956 482 1,650 20,788 General Accounting 14,730 535 622 14,643 Finance and Administration 10,517 2,937 294 13,160 County Clerk 364,317 11,807 10,019 366,105 Elections 29,155 3,099 0 32,254 County Treasurer 42,472 158 0 42,630 County Assessor 72,509 5,034 5,738 71,805 County Council 3,228 106 312 3,022 Personnel 9,539 180 0 9,719 Buildings and Grounds 53,100 4,113 2,470 54,743 Communications Services 355,059 181,598 0 536,657 Purchasing 10,157 5,502 3,067 12,592 Other 57,432 27,808 922 84,318 Buildings 16,293,382 632,533 0 16,925,915 Total General Government 17,368,514 877,140 25,259 18,220,395 Judicial: District Attorney 82,810 11,977 16,978 77,809 Public Safety: Sheriff 232,414 136,629 66,072 302,971 County Coroner 618 0 0 618 Building Inspection 4,217 0 405 3,812 Office of Emergency Management 48,382 822 6,049 43,155 Total Public Safety 285,631 137,451 72,526 350,556 Health and Hospitals: Health 1,275,197 12,905 776,031 512,071 Ambulance 202,104 2,428 73,960 130,572 Total Health and Hospitals 1,477,301 15,333 849,991 642,643 County Roads and Highways: Engineering and Administration 86,270 8,288 0 94,558 Public Welfare: Administration 1,130,943 55,148 14,558 1,171,533 Auxiliary Services: Extension 816,638 2,840 4,533 814,945 Exhibition Building 278,551 22,688 0 301,239 Veterans Office 10,402 0 0 10,402 Missle Site Park 192,130 34,602 63,108 163,624 Youth Shelter 58,224 0 2,435 55,789 Crime Control and Investigation 1,440 0 0 1,440 Libraries 1,095,893 153,081 12,501 1,236,473 Human Resources 700,649 470,593 26,179 1,145,063 Housing Authority 7,913 326 0 8,239 Total Auxiliary Services 3,161,840 684,130 108,756 3,737,214 TOTAL GENERAL FIXED ASSETS ALLOCATED TO FUNCTIONS $ 23,593,309 $S67 1-122.82122. $ 24,294,708 121 860507 ' strut' Wine COLORADO 122 GENERAL LONG-TERM DEBT ACCOUNT GROUP Sick and vacation accrual for Governmental Fund types are recorded in this fund. Wipe. COLORADO bbst,4, 7 COUNTY OF WELD SLATE OF COLORADO GENERAL LONG-TERM DEBT - BY SOURCES December 31, 1987 and 1986 1987 1986 GENERAL LONG-TERM DEBT: Amount to be provided for retirement of $ 1,532,630 $ 1,254,028 general long-term debt TOTAL GENERAL LONG-TERM DEBT L-1-0-2-1±19- GENERAL LONG-TERM DEBT FROM: $ 0 Bonds payable 1,$ 317,000317, 00 1,063,422 General long term debt 055,293 063,422 General long term debt/phone system TOTAL GENERAL LONG-TERM DEBT $ 1,532,630 $ 1,254,028 123 880507 WIOc LODO STATISTICAL SECTION 1,11 WIIDc COLORADO '3`z 5 7 A Anot VIIlic COLORADO 125 COUNTY OF WELD SITIMMIXDO General Governmental Expenditures by Function (Unaudited) Last Ten Years County Public General Public Roads & Health & Year Government Safety Highways Welfare 1978 $ 4,777,054 $ 2,551,449 $ 5,493,292 $ 9,691,198 1979 $ 4,709,301 $ 2,808,358 $ 6,157,485 $10,775,974 1980 $ 5,203,105 $ 3,150,728 $ 7,436,150 $12,436,419 1981 $ 5,403,963 $ 3,525,539 $ 6,811,742 $13,783,902 1982 $ 5,400,021 $ 5,229,851 $ 6,997,923 $12,875,917 1983 $ 5,725,137 $ 5,575,881 $ 7,716,877 $13,961,545 1984 $ 6,082,536 S 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 General Revenue by Source (Unaudited) Last Ten Years Licenses Intergovernmental Year Taxes and Permits Revenue 1978 $ 10,273,210 $ 187,067 $ 13,517,280 1979 $ 11,288,778 $ 196,545 $ 14,280,094 1980 $ 12,025,910 $ 383,881 $ 18,664,253 1981 $ 12,947,563 $ 400,670 $ 20,283,181 1982 S 13,166,821 $ 463,542 $ 17,204,249 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 126 880507 Auxiliary Debt Intragovernmental Total Services** Capital Outlay Service Expenditures Miscellaneous Expenditures S 3,984,390 $ 1,091,611 $ * $ 121,761 $ 111,134 $ 27,821,889 * $ 169,316 $ -0- $ 29,118,409 $ 3,692,883 S 344,889 $ * $ 118,498 $ -0- $ 34,616,250 $ 5,926,461 $ 594,188 $ * $ 83,594 $ -0- $ 36,487,535 $ 6,287,607 $ 591,188 $ * $ 375,305 $ 338,637 $ 35,412,407 $ 3,709,018 $ 485,735 $ 2,274 $ 431,789 $ 685,246 $ 38,335,279 $ 3,856,846 $ 379,684 $ 42,123,352 $ 3,954,896 $ 1,347,365 $1,018,741 $ 415,102 $ 1,074,232 $S 4,596,197 $ 1,515,560 $ 88,500 $ 465,517 $ 144,013,317 647 115 $ 488,119 $ 1,401,846 $ 44,730,926 $ 4,234,193 $ 1,397,988 $ 252,753 $ 594,982 $ 3,550,550 $ 49,127,728 $ 4,735,582 $ 1,637,272 $ 200,263 $ * Information not available. **Auxiliary Services includes culture and recreation, conservation of natural resources, and economic assistance. General governmental expenditures include expenditures of General, Special Revenue, Capital Projects Funds, and Special Assessment Funds. Fines and Miscellaneous Fee Charges for Revenue Accounts Total Revenue Services Forfeits 2,171 $ 2,417,306 $ -0- S 27,675,271 $ 1,278,237 $ 3,018 $ 2,277,170 $ -0- $ 29,205,454 $ 1,159,849 $ , $ 2,089,689 $ -0- $ 35,141,398 $ 1,974,601 $ 3,064 _0_ $ 38,518,062 $ 1,931,937 $ 3,108 $ 2,951,603 $ 1,160,740 $ 36,149,337 $ 1,406,453 39,064,828 $ 1,406,359 $ 26,667 S 2,543,940 $ 1,5333,455 $ 42,948,423 r $ 1,541,520 $ 37,592 $ 3,948,342 6 44,055,315 ' 3,756,703 703 $ 1,631,937 $ $ 1,673,283 $ 78,261 $ 3,775,144 $ 1,680,356 $ 46,456,359 $ 1,742,650 $ 77 465 $ 5,915,868 $ 1,711,894 $ 49,103,114 e $ 1,149,717 $ 76,465 $ > . General revenue includes revenue of General, Special Revenue, Capital Projects and Special Assessment Funds. 127 880507 . COUNTY OF WELD STATE Oi COLORADO Property Value, Construction, Bank Deposits and Other Economic Indicators (Unaudited) Last Ten Years 1980 1983 1984 1985 1986 1987 Property Value - estimated actual value (millions) $ 2,948.7 $ 2,963.7 $ 3,158.7 $ 3,393.9 $ 3,150.7 $ 4,228.5 1 241 2,699 2,450 2,519 2,113 2,131 Building Permits , Estimated Construction (millions) $ 23.8 $ 13.0 Bank Deposits (millions) $ 524.5 $ 664.5 * $ 9,854.2 * * Retail Sales (millions) $ 781.3 $ 1,023.0 $ 1,022.9 $ 1,118.0 $ 1,044.1 * Value of Crop Production (millions) $ 185.0 $ 184.6 $ 284.5 $ 191.0 Other years' data not available * Information not available. Source: Greeley Area Chamber of Commerce Survey 880507 128 COUNTY OF WELD STATE OF COLORADO Property Tax Levies and Collections (Unaudited) Last Ten Years Total Total Current Percent Delinquent Total Outstanding Original Tax Tax of Levy Tax Tax Delinquent Year Levy Collections Collected Collections Collections Taxes 1978 $ 10,618,807 $ 10,558,800 99.43 $ 25,507 $ 10,584,307 $ 80,380 1979 $ 11,144,614 $ 11,101,916 99.62 $ 27,699 $ 11,129,615 $ 66,715 1980 $ 11,708,099 $ 11,660,552 99.59 $ 42,189 $ 11,702,741 $ 70,795 1981 $ 12,622,216 $ 12,596,620 99.68 $ 39,303 $ 12,635,923 $ 52,053 1982 $ 13,252,865 $ 13,169,249 99.37 $ 81,490 $ 13,250,739 $ 69,656 1983 S 14,399,734 $ 14,307,719 99.36 $ 97,625 $ 14,405,344 $154,546 1984 $ 15,119,720 $ 14,985,503 99.11 $131,428 $ 15,116,931 $212,504 1985 $ 15,875,706 S 15,469,833 97.44 $ 28,931 $ 15,498,764 $307,203 1986 $ 17,147,925 $ 17,013,025 99.20 $ 84,065 $ 17,097,090 $404,559 1987 $ 18,005,273 $ 17,756,037 98.60 $296,802 $ 18,052,839 $439,749 Assessed and Estimated Actual Value of Taxable Property (Unaudited) Last Ten Years Real Property (1) Personal Property (2) Total Assessed Estimated Assessed Estimated Assessed Estimated Year Value Actual Value Value Actual Value Value Actual Value 1978 $ 477,056,630 $1,590,188,766 $ 104,237,180 $ 694,914,533 $ 581,293,810 $2,285,103,299 1979 $ 497,514,340 $1,658,381,133 $ 165,480,900 $ 1,103,206,000 $ 662,995,240 $2,761,587,133 1980 $ 507,497,890 $1,691,659,633 $ 169,787,590 $ 1,131,917,266 $ 677,285,480 $2,823,576,899 1981 $ 555,820,990 $1,852,736,633 $ 176,028,980 $ 1,173,526,533 $ 731,849,970 $3,026,263,166 1982 $ 685,414,640 $2,284,715,466 $ 86,357,130 $ 713,785,433 $ 771,771,770 52,998,500,899 1983 $ 778,637,950 $2,647,089,025 $ 91,815,550 $ 316,605,345 $ 870,453,500 $2,963,694,370 1984 $ 764,916,130 $2,966,160,645 $ 55,831,700 $ 192,523,103 $ 820,747,830 $3,158,683,748 1985 $ 819,535,750 $3,162,758,743 $ 67,028,500 $ 231,132,759 $ 886,564,250 $3,393,891,502 1986 $ 836,455,500 $2,908,836,701 $ 70,154,400 $ 241,911,724 $ 906,609,900 $3,150,748,425 1987 $ 899,649,790 $3,945,488,938 $ 82,078,810 $ 283,030,379 $ 981,728,600 $4,228,519,317 (1) Residential improved land and improvements at 18% of 1983 replacement cost, as determined by State law. (2) Commercial improved land and improvements at 29% of 1983 replacement cost, as determined by State law. 129 880507 COUNTY OF WELD STATE OF COLORADO Property Tax Rates and TaxAll Overlapping Governments (Unaudited) Last Ten Years Levy Collection School Junior Total Year Year Cities Districts County College Other Tax Rates 1977 1978 413.800 1,380.32 18.260 3.46 134.660 1,950.500 1978 1979 413.800 920.32 16.780 3.46 134.660 1,489.020 1979 1980 423.990 978.12 17.247 3.93 144.769 1,568.056 1980 1981 439.790 908.51 17.247 4.11 147.517 1,517.174 1981 1982 460.900 883.48 17.172 4.11 154.620 520.282 66.16 17.172 4.292 151.450 1,500.294 1982 1983 461.220 '880.14 17.369 4.581 161.059 1,553.469 1983 1984 490.320 1984 1985 542.320 918.63 19.342 5.037 171.923 1,657.252 11985 198 537.259 977.76 19.342 4.981 164.277 986 1987 571.268 953.48 19.968 5.198 203.204 1,753.118 Tax Levies 1977 1978 $2,121,568 $25,429,499 $10,597,815 $1,797,717 $2,352,751 $42,299,350 1978 1979 $2,481,327 $27,770,414 $11,125,060 $1,988,606 $2,596,647 $45,962,054 1979 1980 $3,285,870 $32,572,132 $1239 ,622,216 $2142 ,622,812 $2,867,436 $53126 ,970,466 967 1980 1981 $3,285,870 $32,572,132 1981 1982 $3,839,640 $35,181,714 $13,252,865 $2,737,134 $3,249,326 $58,260,679 1982 1983 $4,016,593 $37,913,573 $14,399,734 $3,686,486 $3,769,629 $63,786,015 1983 1984 $4,125,777 $41,076,321 $15,118,907 $3,458,802 $3,960,714 $67,740,521 1984 1985 $4,210,650 $42,366,353 $15,874,905 $3,631,540 $3,942,837 $70,026,285 1985 1986 $4,551,381 $48,835,173 $17,147,925 $3,918,961 $5,736,561 $80,190,001 1986 1987 $4,744,921 $52,125,601 $18,103,186 $4,232,066 $6,196,320 $85,402,094 The basis for the property tax rates is per $1,000 assessed valuation. 880507 130 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 1981* -0- -0- 100% $ 27,885 1982 $ 13,531 $ 13,531 100% $ 14,354 1983 $ 4,098 $ 4,098 100% $ 10,256 1984 $ 1,282 $ 1,282 100% S 8,974 1985** $ 2,236 $ 2,236 100% $1,081,738 1986*** $ 102,009 $102,009 100% $1,006,759 1987**** $ 111,543 $111,543 100% $ 902,272 NOTES: * Weld County had no special assessments from 1973 - 1980, in 1981 Road 5 Special Assessment of $27,885. ** Elmore Road Special Assessment of $1,075,000. *** Antelope Hills Special Assessment of $27,030. **** Indianhead Special Assessment of $7,056. 880507 131 COUNTY OF WELD STATE OF COLORADO Computation of Legal Debt Margin (Unaudited) December 31, 1987 Assessed Value, 1986 $ 906,609,900 Debt Limit 3 Percent of Assessed Value 27,198,297 Amount of Debt Applicable to Limit: Total Bonded Debt $ - Installment Purchase Agreements - Total Amount of Debt Applicable to Debt Limit Legal Debt Margin $ 27,198,297 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. Tables Relating to Bonded Debt (Unaudited) December 31, 1987 Weld County is without bonded debt and 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 132 880507 COUNTY OF WELD STATE OF COLORADO Demographic Statistics (Unaudited) December 31, 1987 1. Population: 1960 - 72,344 1970 - 89,297 1975 - 111,901 1980 - 123,438 1983 - 132,513 1984 - 131,746 1985 - 133,922 1986 - 139,947 2. Estimated Median Age: 26.7 (1980 Census) 28.5 (1983) 26.7 (1984) 27.8 (1985) 3. Total Personal Income For Years Available: 1970 - $ 279,766,000 1971 - $ 327,463,000 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 4. Per Capita Income For Years Available: 1971 - $ 3,527 1972 - $ 3,891 1973 - $ 4,666 1974 - $ 5,054 1975 - $ 5,543 1977 - $ 5,081 1980 - $ 6,505 1982 - $10,411 1984 - $11,501 5. Median Family Income $15,805 (1980 Census) $22,921 (1983) $21,286 (1984) 6. Population Per Household 1970 - 3.09 1980 - 2.79 1983 - 2.75 1984 - 2.79 7. Housing Units 1970 - 28,896 1980 - 46,475 1983 - 46,059 1984 - 49,538 Source: Greeley Area Chamber of Commerce Survey and U.S. Census data. 133 8805C-7 COUNTY OF WELD STATE oY COLORADO Property Value, Construction Bank Deposits and Other Economic Indicators (Unaudited) Last Ten Years 1980 1983 1984 1985 1986 1987 Property Value - estimated actual value (millions) $ 2,948.7 $ 2,963.7 $ 3,158.7 S 3,393.9 $ 3,150.7 $ 4,228.5 Building Permits 1,241 2,699 2,450 2,519 2,113 2,131 Estimated Construction (millions) $ 23.8 $ 13.0 * * * * Bank Deposits (millions) $ 524.5 $ 664.5 * 9,854.2 * * Retail Sales (millions) $ 781.3 $ 1,023.0 $ 1,022.9 $ 1,118.0 $ 1,044.1 * Value of Crop Production (millions) $ 185.0 $ 184.6 $ 284.5 $ 191.0 * * Other years' data not available * Information not available. Source: Greeley Area Chamber of Commerce Survey 8805&7 134 COUNTY OF WELD STATE OF COLORADO Principal Taxpayers (Unaudited) December 31, 1987 Per Cent 1987 Of Total Assessed Assessed Valuation Valuation $ 61,613,510 6.79% Amoco Production Company 70,755,800 7.80 Eastman Kodak 31,704,300 3.49 Public Service Company of Colorado 14,954,010 1.64 Snyder Oil ao. 13,140,900 1.44 Mountain States Telephone & Telegraph 13,031,500 1.43 Panhandle Eastern Pipeline Company 7,137,580 .78 Vessels Oil & Gas Co. 6,913,120 .76 C Sunshine Valley Oil Co. 6,276,600 .69 Energy Minerals Corporation 4,687,960 .62 Coors Energy 135 880507 COUNTY OF WELD STATE OF COLORADO Miscellaneous Statistics (Unaudited) December 31, 1987 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, 1986 Elected ElectednOfficials5- 10 Department Heads - 10 Other Full Time Employees - 780 Part Time Employees - 174 7. Miles of Roads: Paved - 549.6 Unpaved - 2,787.5 8. Building Permits: No. of Year Permits Valuation 1978 1,546 $ 58,749,363 1979 1,592 $ 34,782,283 1980 1,348 $ 54,775,497 1981 1,241 $ 32,851,694 1982 1,865 $ 35,207,497 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 9. Motor Vehicle Registration: 1978 - 143,888 1979 - 133,437 1980 - 125,970 1981 - 129,159 1982 - 130,952 1983 - 132,458 1984 - 139,521 1985 - 136,444 1986 - 142,204 1987 - 140,445 10. Special Districts 28 - Cities and Towns within County: 17 - Schools 23 - Fire 18 - Water & Other 1 - Colleges 13 - Sanitation Ault Gilcrest Lochbuie 11. Cities and Towns: Eaton Greeley Mead Erie Grover Milliken Evans Hudson New Raymer Dacono Johnstown Nunn Firestone Keenesburg Pierce Frederick Keota Platteville Ft. Lupton Kersey Rosedale Garden City LaSalle Severance Brighton JT Windsor 12. Recreation: Golf Courses - 5 City and Regional Parks Island Grove Recreational Complex Greeley Recreation Center 136 880507 COUNTY OF WELD STATE OF COLORADO Miscellaneous Statistics - Continued (Unaudited) December 31, 1987 Ault Town Library 7,000 Volumes 13. Libraries: Glenn A. Jones Library 9,639 Volumes Greeley Library 126,142 Volumes Platteville Library 8,253 Volumes University of No. Colo. 755,519 Volumes Weld Library District 153,000 Windsor Public Library 27,791 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 61.1 1986 General Election 62,725 38,488 15. Media Newspapers: The Greeley Tribune The Banner 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 Brighton Blade and Market Place Erie Echo Ft. Morgan Times LaSalle Leader Longmont Times Call Platte Valley Voice Evans Star Press The Centennial News Radio Stations: KFKA/KGBS KYOU/KGRE KUAD AM & FM 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, 1987: State - 3% Source: County offices. 137 880507 COUNTY OF WELD STATE OF COLORADO Insurance In Force (Unaudited) December 31, 1987 Policy Period Details of Annual Name of Company Policy Number Begins Expires Coverage Liability Limits Premiums Safety Mutual SP-1486-CO 1/15/87 12/31/87 ore $200,000 Excess Worker's $10,000,000/Occurrence Compensation Casualty Corp. on Each Occurrence $ 26,730 Zurich Insurance BM31-93-524-02 1/1/87 1/1/88 Boiler and $10,000,000/Accident g 933 Company - Machinery $1,000 Deductible Lloyds of London ISL 3798 7/1/87 6/30/88 Property Damage, Property: $50,000,000/ (Colorado ICO 5498 Automobile Occurrence Counties Liability, All Liability: $150,000/ Casualty & General Liability, Person: $500,000/Claim Property Pool) Public Officials Excess and Out-of-State Only) Crime (Federal p Liability, $850,000/Person Excess $150,000; $600,000/Claim Excess $40,000 Crime: $150,000/Loss $500 Deductible/ Property Claim 384,101 138 8805& COUNTY OF WELD STATT7T751272cDO Salaries of Principal Officials (Unaudited) December 31, 1986 ELELPED OFFICIALS: Commissioners $ 28,000 Clerk & Recorder $ 28,000 $ 28,000 Treasurer $ 28,000 Assessor $ 32,517 Sheriff $ 67,524 District Attorney APPOINTED: County Attorney $ 68,198 Director of Planning $ 38,648 Director of Finance and $ 75,259 Administration Director of Building and $ 41,602 Grounds 27,024 Director of Ambulance Services $ 27,024 County Engineer Director of Social Services S 55,956 Director of Health Department $ 81,014 Director of Human Resources $ 49,458 Director of Information Services $ 73$ 34,995 ,379 Director of Purchasing Director of Personnel $ 43,$ 43,712 72 Comptroller 926 Director of Emergency Management $ 27,039 Director of Road and Bridge $ 48,246 Surety Bond Coverage for Officials (Unaudited) December 31., 1987 District Attorney $ 5,000 Commissioner $ 25,000 Treasurer $ 250,000 Sheriff $ 20,000 Assessor $ 6,000 Coroner $ 5,000 County Clerk $ 25,000 County Clerk '(Titles & Deeds) $ 5,000 Director of Finance and $ 100,000 Administration Note: All bonds are issued by the St. Paul Insurance Company and are on file with the Weld issued Clerk and RPauldIn 139. 8805C7 COUNTY OF WELD STATE OF COLORADO PRIVATE PURPOSE REVENUE BONDS (Unaudited) As of December 31, 1987 DEBT REVENUE BONDS TYPE OF ISSUE OUTSTANDING OUTSTANDING ISSUER FACILITY AMOUNT DATE BEGINNING YEAR ISSUED RETIRED END OF YEAR INDUSTRIAL REVENUE BONDS: Evangelical Lutheran Good Samaritan Soc. Nursing Home $1,400,000 11/79 $ 1,060,000.00 $ -0- S 60,000.00 $ 1,000,000.00 Colorado Landfill, Inc. Landfill 1,300,000 1/80 1,075,000.00 -0- 50,000.00 1,025,000.00 Nor-Colo Distributors Warehouse 925,000 8/80 740,000.00 -0- 45,000.00 695,000.00 Dr. Hesse Clinic 90,000 2/81 66,513.86 -0- 5,187.43 61,326.43 Dos Gringos Land Warehouse 380,000 12/81 305,818.89 -0- 19,518.89 286,300.00 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,935,000.00 -0- 40,000.00 1,895,000.00 10th Street Investment Office 2,500,000 8/82 2,385,000.00 -0- 40,000.00 2,345,000.00 Gateway Partnership Office 2,800,000 9/83 2,645,000.00 -0- 65,000.00 2,580,000.00 Dayton-Hudson Target Retail 2,000,000 4/83 1,400,000.00 -0- 200,000.00 1,200,000.00 Economy Lumber Retail 705,000 12/83 642,849.76 -0- 36,037.04 606,812.72 Colorado Counties, Inc. Office 625,000 7/84 625,000.00 -0- 5,000.00 620,000.00 Weld Mental Health Office 650,000 6/84 610,000.00 -0- 25,000.00 585.000.00 TOTAL INDUSTRIAL REVENUE BONDS 15,990,182.51 -0- 590,743.36 15 399 439.15 MORTGAGE REVENUE BONDS: Single-Family Revenue Bonds 1981-Series A $7,500,000 12/81 4,565,000.00 -0- 240,000.00 4,325,000.00 GRAND TOTAL PRIVATE PURPOSE REVENUE BONDS $20,555,182.51 $ -0- $830,743.36 $19,724,439.15 8805C7 140 COUNTY OF WELD STATE OF COLORADO RETIREMENT PLAN REQUIRED SUPPLEMENTARY IISFORMATION (Unaudited) ANALYSIS OF FUNDING PROGRESS ASSETS IN NET ASSETS PENSION EXCESS OF FISCAL AVAILABLE BENEFIT PERCENT PENSION YEAR FOR BENEFITS OBLIGATION FUNDED OBLIGATION 1978 $ 3,509,862 $ 3,509,862 100.0% $ -0- 1979 4,234,774 4,234,664 100.0% (110) 1980 4,679,932 4,679,779 100.0% (153) 1981 6,364,130 6,364,130 100.0% -0- 1982 6,747,934 6,747,934 100.0% -0- 1983 9,248,144 7,730,870 119.6% (1,517,274) 1984 11,244,338 7,424,910 151.4% (3,819,428) 1985 12,970,501 9,267,695 140.0% (3,702,806) 1986 16,858,875 10,070,430 167.4% (6,788,445) 1987 20,121,008 15,836,511 127.1% (4,284,497) The percentage of annual payroll to unfunded obligation is not shown as Weld County Retirement Plan had no unfunded obligation. REVENUES BY SOURCE FISCAL EMPLOYEE EMPLOYER INVESTMENT YEAR CONTRIBUTIONS CONTRIBUTIONS INCOME TOTAL 1978 $ 393,531 $ 393,531 $ 179,412 $ 966,474 1979 426,861 426,861 250,710 1,104,432 1980 485,484 485,484 578,013 1,548,981 1981 526,569 526,569 468,727 1,521,865 1982 595,893 595,893 1,074,456 2,266,242 1983 632,054 632,054 1,261,004 2,525,112 1984 666,393 666,393 1,043,786 2,376,572 1985 708,883 708,883 3,162,758 4,580,524 1986 743,931 743,931 2,598,746 4,086,608 1987 837,729 837,627 - 1,844,038 3,519,394 EXPENSES BY TYPE FISCAL ADMINISTRATIVE YEAR BENEFITS EXPENSES REFUNDS TOTAL 1978 $ 102,158 $ 34,770 $ 127,413 $ 264,341 1979 128,853 39,100 201,365 369,318 1980 147,539 41,710 189,421 378,670 1981 178,922 53,405 235,113 467,440 1982 217,167 66,498 220,477 - 504,142 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 141 8805 ''7 COUNTY OF WELD STATE ON COLORADO Computation of Overlapping Debt (Unaudited) Percentage Amount Net Debt Applicable Applicable Jurisdiction Outstanding to County to County Cities and Towns $26,266,915 100.00$ 526,266,915 School Districts 78,683,287 66.11% 52,018,987 Special Districts 11,492,941 93.27% 10,719,391 Total Overlapping Debt $89,005,293 County (Special Assessment 700,000 100.00% 700,000 County (Certificates of Participation) 317,000 100.00% 317,000 $90,022,293 142 8805C Hello