The URL can be used to link to this page

Home My WebLink About1982 CAFR I I I 01 I -I ]1 I _I ~I -I 11 .1 I 1 I I j I ~ I ~ I CITY OF ANDOVER, MINNESOTA FINANCIAL STATEMENTS DECEMBER 31, 1982 ~I i ~i ! I 1l'I. I llijl i i ml I ;1 I 01 ml I ~1 c ~ E ~ ~ ~ ~ ~ I ~ ~I --------:;;;::-::;. . 1 I 'I : -I 1 1 Elected Mayor Gerald Windschitl Council Donald Jacobson Robert Peach Theodore M. Lachinski Kenneth Orttel 1 I -I I I -I I I I I I I I Effective January 1983 Mayor Gerald Windschitl Council Theodore M. Lachinski Kenneth Ortte1 James Elling Michael Knight Appointed Clerk-Treasurer patricia K. Lindquist CITY OF ANDOVER, MINNESOTA ELECTED AND APPOINTED OFFICIALS Term of office expires first business day of January 1983 1983 1983 1985 1985 1985 1985 1985 1987 1987 m m ml i I!I\I lijl ~! ~i m m m ! m m e m m ! m e ~ ~ - p-' r ,-- - ' .----- -.--- I I - I 1 I , 1 , 1 j 1 1 1 - - 1 ~ ~ 1 - ~ I - j I , ~ - - 1 ~ j I ~ - , 1 , . ~ 1 1 J I I J ~ I , J . - - 1 . . CITY OF ANDOVER, MINNESOTA TABLE OF CONTENTS SECTION I INTRODUCTORY SECTION Page Comments 1 SECTION II FINANCIAL SECTION Auditors' opinion 1 II-A. Combined Financial Statements (General Purpose Financial Statements) Combined balance sheet - all fund types and account groups Combined statement of revenue, expenditures and changes in fund balances ~ all governmental fund types Combined statement of revenue, expenditures and changes in fund balance - budget and actual - General and special revenue fund types Statement of revenue, expense and fund equity - all proprietary fund types - Enterprise funds Statement of changes in financial position - all proprietary fund types - Enterprise funds Notes to financial statements 2 4 6 8 9 10 II-B. Combining and Individual Fund Statements and Account Groups General Fund Comparative balance sheet Statement of revenue, expenditures and changes in fund balances Statement of revenue, compared to budget Statement of expenditures, compared to budget 20 21 22 23 Special revenue funds Comparative balance sheet Statement of revenue, expenditures and changes in fund balances 27 27 Debt service funds Combining balance sheet Combining statement of revenue, expenditures and changes in fund balances 28 29 Capital projects funds Combining balance sheet Combining statement of revenue, expenditures and changes in fund balances 30 31 CITY OF ANDOVER, MINNESOTA TABLE OF CONTENTS (CONTINUED) Special assessment funds Combining balance sheet Combining statement of revenue, expenditures and changes in fund balances Proprietary funds - Enterprise funds Combining balance sheet Combining statement of changes in fund equity Combining statement of revenue and expense Combining statement of changes in financial position Water Fund Comparative balance sheet Comparative statement of changes in fund equity Comparative statement of revenue and expense Comparative statement of changes in financial position Sewer Fund Comparative balance sheet Comparative statement of changes in fund equity Comparative statement of revenue and expense Comparative statement of changes in financial position Comparative statement of general, fixed asset.s Comparative statement of general long-term debt SECTION II I STATISTICAL SECTION Schedule of cash, temporary investments and security for deposits Combined schedule of indebtedness Schedule of bonds payable Debt service requirements Tax levies and collections Special assessment levies and collections Assessed valuations, tax levies and mill rates ~ . -r -- ~-~- m m c 32 ~I 01 Cl I Ci l , i I C~ oj ! ~ 36 41 42 44 45 46 47 48 49 50 51 52 53 54 55 c ~, 57 58 60 64 65 65 67 ~ c D ~ ~ ~ I I 1 -I I -I -I 1 'I i 1 I I ~I . ~I SECTION r INTRODUCTORY SECTION ~ 1 ~ 1 1 I ~ I -I t. t'- ~ m m m II I ;i I ~ I" ill ml Cl I C~ ~I C ~ C C C ~ C ~ -=-- ~ - - ------;_. 'I I ~ 1 I I I I - 1 - 1 I - I - - 1 c 1 - , I ~ 1 ~ - - ! 1 ~ " ~ 1 ~ . I ~ - - - I - c; ~ 01 ANDOVER COMMENTS The City of Andover, Minnesota operates under "Optional Plan A" as defined in the State of Minnesota Statutes. Under this plan, the council is elected by popular vote and consists of the mayor and four councilmembers. Administrative personnel, including the clerk-treasurer are appointed by the council. General Fund The General Fund is used to account for all revenue and the activities financed by them which are not accounted for in a special fund. The principal sources of revenue are property taxes and intergovernmental revenue. Expenditures are for general government, public safety, public works, recreation and other functions. The fund balance increased $34,974 during the year to $216,148. A condensed summary of revenue and expenditures for the years ended December 31, 1982 and 1981 is shown below: 1982 1981 Budget Actual Budget Actual Revenue and other sources Taxes $261,360 $270,555 $244,465 $235,785 Licenses and permits 48,210 57,806 35,475 50 , 190 Intergovernmental revenue 349,571 295,615 319,371 338,986 Charges for services 9,450 8,520 7,150 7,559 Fines and forfeits 10,000 9,883 8,000 10,885 Other revenue 141,288 100,193 66,657 173,670 Transfers from other funds 46,388 48,575 38,000 39 , 146 $866,267 $791,147 $719,118 $856,221 Expenditures and other uses General government Public safety Public works Sanitation Park and recreation Other unallocated Transfers to other funds $250,322 271 ,494 131,973 13,161 100,417 64,379 31,521 $866,267 $ Net increase in fund balance -0- Special Revenue Funds $242,329 $217,998 $201,149 267,410 226,559 275,700 122,616 134,305 117,478 8,307 7,192 5,960 68,279 84,745 95,777 17,212 14,800 24,451 30,020 31,580 30,767 $756,173 $717 ,179 $751,282 $ 34.974 $ 1.939 $104.939 Special revenue funds are established to account for taxes and other revenue set aside for a particular purpose. I Special Revenue Funds (Continued) Revenue Sharing Fund - This fund was established to account for revenue received from the Federal Government in accordance with the "State and Local Fiscal Assistance Act of 1972." Expenditures can only be made from this fund as outlined in the Act. The City's share of revenue for 1982 was $46,688. During 1982, $48,575 was transferred to the General Fund. The fund balance was $46 as of December 31, 1982. ~ ~ Debt Service Funds I Debt service funds are used to account for the accumulation of resources for payment of general obligation bonds or other general indebtedness and interest thereon. General property taxes and transfers from the General Fund provide the primary financing for debt retirement. The long-term liability (outstanding bond principal) from the issuance of general obligation bonds and other forms of long-term debt is recorded as a liability in the General Long-term Debt Account Group. E E The. funds included with the debt service funds are: I 1978 General Obligation Bonds Fund 1979 Certificate of Indebtedness Fund 1980 Equipment Certificate Fund 1982 Certificates of Tndebtedness I Capital Projects Funds \ ;, I i II EI ~! I E Capital projects funds are established to account for proceeds from the sale of bonds and other revenue to be used for the acquisition of capital improvements by the City. Following is a brief description of each. 1979 Equipment Fund - This fund was established to account for the proceeds from the sale of $85,000 of certificates of indebtedness to be used for equipment acquisition. The fund balance was $8,682 at December 31, 1982. Park Fund - The Park Fund was established to account for revenue, primarily park dedication fees, to be used for the acquisition and improvement of parks. The fund balance was $41,868 at December 31, 1982. $2,159 of the balance has been reserved for construc.tion leaving an unreserved - undesignated fund balance of $39,709 at December 31, 1982. State Aid Fund - This fund was established to account for aid received from the State ~ of Minnesota for construction of certain designated streets. The reserved fund balance at December 31, 1982 of $66,284 will be expended during 1983 for additional construction! costs. .. 1982 Equipment Fund - This fund is used to account for the proceeds from the sale of $150.000 of certificates of indebtedness which were issued during 1982 for a fire truck and fire equipment. The December 31, 1982 reserved fund balance of $149,758 will be expended during 1983 for these items. ~ Special Assessment Funds ~ Special assessment funds were established to account for assessments levied to finance improvements or services deemed to benefit the properties against which the assessments II are levied. Primarily, the transactions accounted for in the funds are the receipt of bond proceeds or other sources of financing and disbursement of such proceeds for construction work done and the collection of assessments against benefited property II owners and disbursements of assessment collections for the payment of bonds and .. interest. II ~ v - ----:::~------=-=:;:::--- I I I I I I I I - I , I J I 1 I ~ j I 1 I . ~ . j I . ~ J I . , I ! J ~ 1 I i . .. I 1 I Enterprise Funds Enterprise funds are established to account for the financing of self-supporting activities of governmental units which render services to the general public on a user charge basis. In Andover the water and sewer utilities are operated as enterprise activities. The financial statements of enterprise funds are similar to comparable private enterprise and are self contained. The Water Fund was established during 1981, a condensed summary of operations for 1982 and 1981 is as follows: Revenue Expense (excluding depreciation) Depreciation Net income (loss) 1982 $ 43,201 37,611 $ 5,590 (16,125) $00.535) 1981 $ 36,324 25,234 $ 11 ,090 ( 8,064) $ 3 . 026 A condensed summary of Sewer Fund operations for the last three years is as follows: Revenue Expense (excluding deprecia t ion) Depreciation Net loss General Fixed Assets 1982 1981 1980 $ 82,574 $ 68,194 $ 55,872 105,212 57,768 52,192 $' (22,638) $ 10,426 $ 3,680 (83,611) (67,792) (51,982) $ (1 06.249) .$..ill. 366) $(48.302) This account group is used to show the general fixed assets of the City. These assets are used in the performance of the general governmental functions. As of December 31. 1982, the general fixed assets of the City amounted to $935,706. General Long-term Debt General obligation bonds and other-forms of long-term debt that are obligations of the City as a whole and not its individual funds are accounted for in this se1f- balancing account group. Long-term debt included in the account at December 31, 1982 were as follows: 1978 G.O. Bonds 1979 Certificates of Indebtedness 1980 Equipment Certificates 1982 Certificates of Indebtedness Long-term payable - Metropolitan Waste Control Commission Assessments on City property Equipment purchase Vacation payable - Governmental funds Original -amount Outstanding December 31, 1982 $325,000 34,000 24,000 150,000 $430,000 85,000 40,000 150,000 43,018 102,741 10,115 29,175 93,076 8,887 3,804 $667.942 III ~ ~ ~! ;1 I ~I Ill! I el 11/1 ~I 1/1 I ml ~I C :i ~ C ~ c! ~ C ~ ~ ~I --'--- --- ~-;- -I I I I I I ~I - I JI SECTION II FINANCIAL SECTION 1 I , 11 i I 1 I II ~ j I ]1 ! j I ~ ) I J I ~' ,! , ' , I i ~. I , I i i ~I ill I ml ml , ~I ml C I Ci I C I' C C C C C ~ ~ ~ ~I r - I I - I I I I - I I - I = I - 1 I = = j I - = , I ~ - . I . . -~ - . I i . ~ ) I I .. I I ~ 1 I j 1 I - .. GMHCo GEORGE M. HANSEN COMPANY, P.A. A Professional Corporation of Certified Puh/ic At'COWlfontJ AUDITORS' OPINION The City Council Andover, Minnesota We have examined the combined financial statements of the City of Andover, Minnesota as of and for the year ended December 31, 1982, 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 combined financial statements referred to above present fairly the financial position of the City of Andover, Minnesota at December 31, 1982, and the results of its operations and the changes in financial position of its proprietary fund types 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 combined financial statements taken as a whole. The combining, individual fund, and account group financial statements and schedules listed in the table of contents are presented for purposes of additional analysis and are not a required part of the combined financial statements of the City of Andover, Minnesota. The information has been subjected to the auditing procedures applied in the examination of the combined financial statements and, in our opinion, is fairly stated in all material respects in relation to the combined financial statements taken as a whole. Our examination did not include the statistical information listed in the table of contents. ~ 711. ~ ~ 1.11. April 12, 1983 175 SOUTH PLAZA BUILDING WAYZATA BOULEVARD AT HIGHWAY 100 MINNEAPOLIS, MINNESOTA 55416 612/546-2566 2 CIry OF ANDOVER, MINNESOTA ~ COMBINED BALANCE SHEET ALL FUND TYPES AND ACCOUNT GROUPS DECEMBER 31, 1982 ~ ~ Governmental Fund Special General revenue Types Debt service !- ASSETS 1,272 m 46 $ 86,038 441 I 4,295 ( 3,975) m ; 2,777 ~ C Petty cash Cash and temporary investments Accrued interest receivable Taxes receivable Allowance for uncollectible taxes Accounts receivable Special assessments receivable Unremitted Delinquent Deferred Other Due from other funds Due from other governmental units Inventory Property and equipment - Net Amount available in debt service funds for payment of bond principal and interest Amount to be provided by future revenues Total assets $ 150 348,477 $ 1.174 28,778 (26,606) 88 9,157 2.387 $364.877 $ 46 $ 89,57q ~ LIABILITIES AND FUND EQUITY Liabilities Accounts payable Contracts payable Due to other funds Due to other governmental units Deposits payable Deferred revenue Bonds payable Total liabilities $ 18,617 c 6,311 48,215 75,586 ~ $148,729 ~ Fund equity Contributed Investment in General Fixed Assets Retained earnings - Unreserved Fund balance Reserved Unreserved Designated Undesignated Total fund equity Total liabilities and fund equity c $ 5,800 $ 89,576 210,348 $ 46 $216,148 $ 46 $ 89,576 $364.877 $ 46 $ 89.576 c ~ ~ See accompanying notes to financial statements. ~ 3 Account Groups Proprietary General General Total Capital Special Fund Types Fixed Long -term (memorandum only) projects assessmen Enterprise Assets Debt 1982 1981 t $ 150 $ 150 $279,748 $ 4,108,037 $ 11,046 4,833,392 3,824,820 631 23,458 508 26,212 23,244 56 33,129 12,870 ( 56) ( 30,637) ( 12,870) 23,588 23,676 26,530 6,368 6,368 126,336 126,336 62,210 5,577,926 5,579,198 6,067,020. 99,560 99,560 99,386 59,147 71,081 e 2,387 126,087 2,250 2,250 5,885 4,287,410 $935,706 5,223,116 5,247,644 $ 89,576 89,576 84,513 578,366 578,366 494,615 280 379 $10,000,832 $4,324,802 1215 706 $667,942 $16,664,160 $16,062,104 ' $ 1,890 $ 1 $ 1,587 $ 96,880 $ 120,322 $ 116,673 - 10,814 6,101 8,887 25,802 5,144 1,083 61,924 8,074 71,081 ' 6,366 29,175 41,852 31,770 150,725 198,940 200,272 75,586 104,808 8,920,700 533,000 9,453,700 9,541,000 $ 13,787 $ 9,140,798 $ 16,027 $667,942 $ 9,987,283 $ 9,999,667 ' $4,283,295 $ 4,283,295 $ 4,382,572 $935,706. 935,706 860,723 25,480 25,480 42,987 $218,201 $ 846,533 1,160,110 515,331 3,648 48,391 13,501 272,286 257,17 - $266,592 $ 860,034 $4,308,775 $935,706 $ 6,676,877 $ 6,062,437 $280,379 $10,000,832 $4,324,802 5935,706 $667,942 $16,664,160 $16,062,104 4 CITY OF ANDOVER. NINNESOTA COMBINED STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCES ALL GOVERNMENTAL FUND TYPES YEAR ENDED DECEMBER 31, 1982 General Special revenue Revenue Taxes Licenses and permits Intergovernmental revenue Special assessments levied Charges for services Fines and forfeits Interest Other Park dedication fees Total revenue $ 270,555 57,806 295,615 46,688 $ 8,520 9,883 17,486 82,707 1,933 $ 742,572 $ 48,621 Other sources Transfers from other funds Bond proceeds Total revenue and other sources 48,575 $ 791,147 $ 48,621 $ 242,329 267,410 122,616 8,307 68,279 17,212 $ 726,153 Expenditures General government Public safety Public works Sanitation Recreation Other una110cated C.pital projects Debt service Total expenditures Other uses Trans.fers to other funds Total expenditures and other uses 30,020 756;173 34,974 181,174 216.148 $ $ $ 48,575 48,575 46 $ $ Net increase in fund balance Fund balance (deficit) January 1 -0- Fund balance December 31 $ $ See accompanying notes to financial statements. " ~ ~ ~I ! ; ml I mi ; ; ; II I ~ "I ! ;1 ~ ~ I E c 46 ~ ~ ~ ~ ------=--:::-- 1 5 Total Debt Capital Special (memorandum only) service projects assessment 1982 1981 $ 38,444 $ 266 $ 309,265 $ 273,133 57,806 50,190 20,206 $ 287,482 81 650,072 434,642 186,955 186,955 3,716,135 8,520 7,559 9,883 10,885 A 5,787 9,523 1,072,690 1,107,419 756,671 210 165 26,569 109,651 225,495 13,610 13,610 6,763 $ 64,647 $ 310,780 $ 1,286,561 $ 2,453,181 $ 5,481,473 30,020 78,595 69,913 150,000 150,000 $ 94,667 $ 460,780 $ 1,286,561 $ 2,681,776 $ 5,551,386 1 $ 242,329 $ 201,149 267,410 275,700 122,616 117,478 8,307 5,960 68,279 95,777 $ 10,909 28,121 43,560 $ 263,291 186,972 450,263 1,556,932 $ 89,604 670,011 759,615 675,481 $ 89,604 $ 263,291 $ 867,892 $ 1,946,940 $ 2,972,037 78,595 69,913 $ 89,604 $ 263,291 $ 867,892 $ 2,025,535 $ 3,041,950 $ 5,063 $ 197,489 $ 418,669 $ 656,241 $ 2,509,436 84,513 69,103 441,365 776,155 (1,733,281 $ 89,576 S 266,592 S 860,034 S 1,432,396 $ 776,155 3 1 6 CITY OF ANDOVER, MINNESOTA COMBINED STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL - GENERAL AND SPECIAL REVENUE FUND TYPES YEAR ENDED DECEMBER 31, 1982 Revenue Taxes Licenses and permits Intergovernmental revenue Charges for services Fines and forfeits Other General Budget Actual $261,360 $270,555 48,210 57,806 349,521 295,615 9,450 8,520 10,000 9,883 141,288 100,193 $819,879 $742,572 46,388 48,575 $866,267 $791,147 $253,322 $242,329 271,494 267,410 131,973 122,616 13,161 8,307 100,417 68,279 64,379 17 ,212 $834,746 $ 726,153 31,521 30,020 $866,267 $756,173 $ -0- $ 34,974 181,174 $216.148 Total revenue Other sources Transfers from other funds Total revenue and other sources Expenditures General government Public safety Public works Sanitation Recreation Other una110cated Total expenditures Other uses Transfers to other funds Total expenditures and other uses Net increase in fund balance Fund balance January 1 Fund balance December 31 See accompanying notes to financial statements. .- ~ c ~ ~ ~ ~ ~I I I ~I III I i !i I I-I Ii I I Cl ~ ~ ~ C C ~ ~ ------- -,~ I -I I 'I "I -I ,1 ~ 1 ]1 , I . 1 I ~ I J I il 1 ~ II -i 1 I I I I I i I .. 7 Special revenue Budget Actual Total (memorandum only) Budget Actual $261,360 $270,555 48,210 57,806 395,959 342,303 9,450 8,520 10,000 9,883 141,288 102,126 $866,267 $791,193 46,388 48,575 $912,655 $839,768 $253,322 $242,329 271 ,494 267,410 131,973 122,616 13,161 8,307 100,417 68,279 64,379 17,212 $834,746 $726,153 77 , 909 78,595 $912,655 $804 , 748 $ -0- $ 35,020 181,174 $216.194 $ 46,388 $ 46,688 1,933 $ 48,621 $ 46,388 $ 46,388 $ 48,621 $ 46,388 $ 48,575 $ 46,388 $ 48,575 $ -0- $ 46 -0- $ 46 8 CITY OF ANDOVER, MINNESOTA STATEMENT OF REVENUE. EXPENSE AND FUND EQUITY ALL PROPRIETARY FUND TYPES - ENTERPRISE FUNDS YEAR ENDED DECEMBER 31, 1982 Revenue User charges Connection charges Meters Penalties Interest Other Expense Personal services Supplies Other services and charges Disposal charges Depreciation Net income (loss) Fund equity January 1 Additions to property and equipment from customers' contributions Fund equity December 31 See accompanying notes to financial statements. 1:'-" .. Totals c m m m m c m c c C ~i I Ci C ~ C C ~. ~ ~ 1982 1981 $ 75,318 42,899 3,795 1,726 2,037 $ 125,775 $ 33,213 8,318 2.4.899 76,393 99,736 $ 242,559 $( 116,784) 4,425,559 $4.308.775 $ 59,794 39,020 3,250 1,460 795 199 $ 104,518 $ 19,315 9,677 4,697 49,313 75,856 $ 158,858 $( 54,340) 2,400,353 2,079,546 $4.425.559 - --------::--:i-- I I I I I I I I I I I I I I I I I I I CITY OF ANDOVER, MINNESOTA 9 STATEMENT OF CHANGES IN FINANCIAL POSITION ALL PROPRIETARY FUND TYPES - ENTERPRISE FUNDS YEAR ENDED DECEMBER 31, 1982 Sources of working capital Operations Net income (loss) Item not requiring working capital Depreciation Customers' contributions of property and equipment Increase in other assets Decrease in deferred income Uses of working capital Operations Net loss Depreciation Acquisition of property and equipment Increase in deferred revenue Decrease in other assets Increase (decrease) in working capital Elements of net change in working capital Cash and temporary investments Accrued interest receivable Accounts. receivable Due from other funds Inventory Accounts payable Due to other governmental units Increase (decrease) in working capital See accompanying notes to financial statements. Totals 1982 1981 $( 54,340) 75,856 $ 21,516 2,079,546 30,460 $ $ 30,460 30,460 $2,131,522 $ 116,784 ( 99,736) $ 17,048 225 $2,083,956 30,460 30,460 $ 47,733 $2,114,416 $( 17.273) $ 17.106 $( 2,369) $ 9,381 508 4,004 2,155 ( 8,074) ( 356) ( 3,635) 5,885 ( 1,341) 41 ( 6,366) $( 17 .273) $ 17,.106 10 ~ CIT~ OF ANDOVER, MINNESOTA NOTES TO FINANCIAL STATEMENTS DECEMBER 31, 1982 ~ ~ Note 1 - Summary of Significant Accounting Pol ides the City operates under "Optional Plan A" form of City government according applicable State of Minnesota Statutes and provides the following services: safety, public works, sanitation, recreation, public improvements, planning zoning and general administrative services. to pub1 ic and E E The accounting policies of the City of Andover conform to generally accepted accounting principles. The following is a summary of the more significant policies: ~ A. FundAccounting The accounts of the City are organized on the basis of funds and account groups, each of which is considered a separate accounting entity. The operations of each fund are accounted for with a separate set of se1f- balancing accounts that comprise its assets, liabilities, fund equity, revenues and exp~nditures, or expenses, as appropriate. Government resources are allocated to and accounted for in individual funds based upon the purposes for which they are to be spent and the means by which spending activities are controlled. The various funds are grouped, in the financial statements in this report, into six generic fund types and two broad fund categories as follows: m ~ ~ ~ GOVERNMENTAL FUNDS General Fund - The General Fund is the primary operating fund of the City. It is used to account for all financial resources except those required to be accounted for in another fund. E Special revenue funds - Special revenue funds are used to account for the proceeds of specific revenue source.s that are restricted to expenditures for specified purposes. ; ; Debt service funds - Debt service funds are used to account for the accumulation of resources for, and the payment of, general long-term debt .principa1, interest and related costs. E Capital projects funds - Capital projects funds are used to account for financial resources to be used for the acquisition or construction of major capital facilities. E 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, m E I ! e I 11 CITY OF ANDOVER, MINNESOTA I NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1982 I I Note 1 - Summary of Significant Accounting Policies (Continued) A. Fund Accounting (Continued) I PROPRIETARY FUNDS I Enterprise funds - Enterprise funds are used to account for operations (a) that are financed and operated in a manner similar to private business enterprises--where the intent of the governing body is that the costs (expenses, including depreciation) of providing goods or services primarily through user charges; or (b) where the governing body has decided that periodic determination of revenues earned, expenses incurred, and/or net income is appropriate for capital maintenance, public policy, management control, accountability, or other purposes. I I B. Measurement Focus I The accounting and reporting treatment applied to the fixed assets and long-term liabilities associated with a fund are determined by its measurement focus. All governmental 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 is considered a measure of "available spendable resources." Governmental fund operating statements present increases and decreases in net current assets. Accordingly, they are said to present a summary of sources and uses of "available spendable resources" during a period. I I I I Fixed assets used in governmental fund types operations (general fixed assets) are accounted for in the General Fixed Assets Account Group, rather than in governmental funds. Public domain general fixed assets consisting' of certain improvements other than buildings, including roads, bridges, curbs and gutters, streets and sidewalks, drainage systems and lighting systems. are not capitalized along with other general fixed assets. No depreciation has been provided on general fixed assets. I Long-term liabilities expected to be financed from 'governmental funds are accounted for in the General Long-term Debt Account Group, not in the governmental funds. The single exception to this general rule is for special assessment bonds, which are accounted for in special assessment funds. I I The two account groups are not "funds." measurement of financial position. They of results of operations. They are concerned only with the are not involved with measurement I Because of their spending measurement focus, expenditure recognition for governmental fund types is limited to exclude amounts represented by noncurrent liabilities, except special assessment bonds I I 12 c CITY OF ANDOVER, MINNESOTA D NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 3~, 1982 ~ Note 1 - Summary of Significant Accounting Policies (Continued) B. Measurement Focus (Continued) ~ All proprietary funds are accounted for on a cost of services or "capital maintenance" measurement focus. This means that all assets and all liabilities associated with their activity are included on their balance sheets. Their reported fund equity is segregated into contributed capital and retained earnings components. Proprietary fund type operating statements present increases (revenues) and decreases (expenses) in net total assets. ~ ~ C. Basis of Accounting c Basis OI accounting refers to when revenues 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. ~ All governmental funds are accounted for using the modified accrual basis of accounting. Their revenues are recognized when they become measurable and available. Substantially all sources of revenue are accrued except interest on special assessments receivable, which is recognized when due. ~ ~ Expenditures are generally recognized under the modified accrual basis of accounting when the related fund liability is incurred. Exceptions to this general rule include: (1) accumulated unpaid vacation, sick pay, and other employee amounts which are not accrued; and (2) principal and interest on general long-term debt which is recognized when due. ~ All proprietary funds are accounted for using the accrual basis of accounting. Revenues are recognized when they are earned, and expenses are recognized when they are incurred. Unbi11ed utility service receivables are recorded at year end. ; I D. Budgets and Budgetary Accounting E The City follows these procedures in establishing the budgetary data reflected in the financial statements: 1. Prior to January 1, the budget is adopted by the City Council. ~ 2. Formal budgetary integration is employed as a management control device during the year for the General and Special Revenue funds. Formal budgetary integration is not employed for other funds. m 3. Budgets for the General and Special Revenue funds are adopted on a basis consistent with generally accepted accounting principles (GAAP). E 4. Budgeted amounts are as originally adopted, or as amended. I 5. Budget appropriations lapse at year end. I ------ -"'~ I 13 CITY OF ANDOVER, MINNESOTA I NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1982 I Note 1 - Summary of Significant Accounting Policies (Continued) I E. Assets and Liabilities I Cash and temporary investments - Cash available, in excess of immediate needs, is invested temporarily in savings accounts, savings certificates and short-term government obligations. Interest income is recognized as earned and allocated to the respective funds on the basis of applicable participation of each fund. Investments are stated at cost, which approximates market. I I Taxes receivable - Allowances are provided for the full amount of delinquent taxes receivable. This has the effect of recognizing property tax revenues at the time property taxes are paid. I Inventories held by the proprietary funds are stated at cost, which is lower than market, on a first-in, first-out basis. The only other items of inventory would be a small quantity of supplies which are expensed when purchased. I I Fixed assets/property and equipment - 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. I Depreciation of contributed fixed assets used by proprietary funds is charged as an expense against their operations, but then is redistributed to reduce contributions in aid of construction. Accumulated depreciation is reported on proprietary fund balance sheets. Depreciation has been provided over the estimated useful lives using the straight-line method. The estimated useful lives are as follows: I I Collection and. distribution systems Machinery Furniture and equipment 50 years 20 years 3-15 years I F. Revenues and Expenditures I Special Assessments - Special assessment revenue is recognized when it becomes both measurable and available to finance bonded debt. In practice special assessment principal is recognized as revenue in the year when assessment rolls are adopted by the City Council, and when it is available to finance the bond issue principal. Special assessment interest is recognized as revenue in the year due. I I The expenditures for interest on special assessment bonds and the general long-term debt is recognized when paid. Interest expense is not accrued on these items. The expenditure for vacation pay and compensatory time off of the governmental funds is recorded when paid. The liability is recorded in the General Long-term Debt Account Group. I ~I , The expense for vacation pay and funds is recorded when accrued. proprietary fund. compensatory time off of the proprietary The liability is recorded in the respective 14 CITY OF ANDOVER, MINNESOTA ~ NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1982 ~ ; Note 1 - Summary of Significant Accounting Policies (Continued) G. Total Columns on Combined Statements - Overview E Total columns on the combined statements - overview are captioned memorandum only to indicate that they are presented only to facilitate financi<ll analysis. D~ta in these columns do not present financial position, results of operations or changes in financial position in conformity with generally accepted account- ing principles. Neither is such data comparable to a consolidation. Interfund eliminations have not been made in the aggregation of these data. E I Note 2 - Expenditures in Excess, of Appropriations ~ Expenditures of the Special Revenue Fund-Revenue Sharing Fund exceeded the budget by $2,187. Revenues were in excess of the budget estimate by $2.233. ~ Note 3 - Fund Deficits The Special Assessment Fund - 75-1 Improvement Project Fund had a deficit fund balance of $61,138 at December 31, 1982. This fund deficit was reduced $47.157 during 1982. ~ Note 4 - Proprietary Fund Types Property and Equipment I A summary of proprietary fund types property and equipment at December 31, 1982 follows: Water Sewer Total Furniture and equipment $ 1;564 $ 3.278 $ 4,842 Machinery 190,832 190,832 Collection and distribution systems 321 ,112 4,165,666 4,486,778 $ 513,508 $4,168,944 $4,682,452 Less accumulated depreciation 24,189 370,853 395,042 $ 489.319 $3.798.091 $4.287.410 I E E Note 5 - Changes in General Fixed Assets I A summary of changes in general fixed assets during the year follows: I Balance Balance January 1 Additions Disposals December 31 Land and improvements $ 66,397 $ 29,484 $ 95,881 Buildings and improvements 386,831 21,601 408,432 Furniture and equipment 38,594 23,898 62,492 Machinery and automotive equipment 368,901 368,901 Total $860.723 $ 74.983 $ -0- $935.706 E I I ~ ! . I I I I I I I I I I I I I I I I I I I 15 CITY OF ANDOVER, MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1982 Note 6 - Changes in Long-term Debt The following is a summary of bond transactions of the City for the year ended' December 31.1982: General Special obligation assessment Total - Bonds payable at January 1 $ 448.000 $9,093,000 $9,541,000 New bonds issued 150,000 150,000 Bonds retired ( 65,000) ( 172 ,300) ( 237,300) Bonds payable at December 31 $ 533.000 $8.920.700 $9.453.700. Bonds payable at December 31, 1982 are comprised of the following individual issues: General obligation bonds: $430,000 Bonds of 1978 due in varying annual installments through February 1, 1989; interest at 5.55% to 5.70% $ 325,000 $85,000 1979 Certificate of Indebtedness due in annual install- ments of $17,000 through August 1, 1984; interest at 6.00% 34,000 $40,000 1980 Street Equipment Certificates due in annual install- ments of $8,000 through April 1, 1985; interest at 7.00% 24,000 $150,000 Certificates of Indebtedness due in annual install- ments of $30,000 through December 31, 1987; interest at 8.00% 150,000 $ 533.000 Special assessment bonds: $46,000 Improvement Bonds of 1975 due in annual installments of $4,600 through September 1, 1986; interest at 6.50% $ 18,400 $1,635,000 General Obligation Improvement Bonds of 1976 due in varying annual installments through February 1, 1997; interest at 6.20 to 6.80% 1,385,000 $56,000 Improvement Bonds of 1976 due in annual installments of $2,800 through November 1, 1996; interest at 5.50% to 6.75% 39,200 $1,215,000 General Obligation Improvement Bonds of 1977 due in varying annual installments through January 1, 2006, interest at 5.00% 1 , 11 0 , 000 16 CITY OF ANDOVER, MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1982 Note 6 - Changes in Long-term Debt (Continu~d) Special assessment bonds (continued): $780,000 General Obligation Improvement Bonds of 1977 due in varying annual installments through February 1, 1998; interest at 5.25% to 5.50% $ 695,000 $270,000 General Obligation Improvement Bonds of 1978 due in varying annual installments through February 1, 1999; interest at 5.25% to 6.00% 245,000 $270,000 General Obligation Improvement Bonds of 197,9 due in varying annual installments through February 1, 1995; interest at 6,50% 255,000 $430,000 General Obligation Improvement Bonds of 1980 due in varying annual installments through February 1, 1991; interest at 6.10% to 6.90% 405,000 $98,000 General Obligation Bonds of 1980 due in annual install- ments of $4,900 through February 1, 2001; interest at 7.00% 93,100 $4,365,000 General Obligation Improvement Bonds of 1980 due in varying annual installments through February 1, 2002; interest at 8.50% to 9.10% 4,365,000 $150,000 General Obligation Improvement Bonds of 1981 due in annual installments of $15,000 per year through August 1, 1991, interest at 9.75% to 10.00% 135,000 $175,000 General Obligation Improvement Bonds of 1981 due in annual installments of $17,500 per year through February 1, 1992 interest at 10.25% to 11.50% 175,000 $8.920.700 The annual requirements to amortize all debt outstanding as of December 31, 1982, including interest payments of $7,149,415 are as follows: Year ending December 31 Special assessment General obligation Total $ 1,102,176 1,077,661 1,059,858 1.050,339 1,042,225 4,799,304 4,115,923 2,124,629 231,000 $16.603.115 1983 1984 1985 1986 1987 1988-1992 1993-1997 1998,. 2002 2003-2005 $ 974,483 956,229 956,828 960.554 952,547 4,688.578 4,115,923 2,124,629 231,000 $15.960.771 $ 127,693 121,432 103,030 89,785 89,678 110,726 s 642.344 ~ C ~ ~ m m ~ ~ m m m m I m m m, I I D --=:--- """"'~~ I I I I I I I I I I I I I I I I I I I 17 CITY OF ANDOVER, MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1982 Note 6 - Changes in Long-term Debt (Continued) $89,576 is available in the debt service funds to service the general obligation bonds. There are a number of limitations and restrictions contained in the various bond indentures. The City is in compliance with all significant limitations and restrictions. Note 7 - Long-term Payab1es Included in the General Long-term Debt Account Group are the following long-term payab1es: 1. Payable of $29,175 to the Metropolitan Waste Control Commission, with interest at 5.369% per annum. Year Principal Interest Total - 1983 $ 2,733 $ 1,567 $ 4,300 1984 2,880 1,420 4,300 1985 3,035 1,265 4,300 1986 3,198 1,102 4,300 1987 3,370 930 4,300 1988-1991 13,959 1,213 15,172 $ 29 . 175 $ 7.497 $ 36.672 2. Installment contract of $8,887. for equipment purchase with interest 18.57% per annum. Year Principal Interest Total 1983 $ '1,598 $ 1,522. $ 3,120 1984 1,923 1,197 3,120 1985 2,313 807 3,120 1986 2,797 323 3,120 1987 256 4 260 $ 8.887 $ 3.853 $ 12.740 3. Special assessments on city property of $93,076 payable in varying amounts at annual interest rates of 6.25% to 10.7% through 2001. Note 8 - Retirement Plan The City participates in a State-wide contributory pension plan under the Public Employees' Retirement Association, Minnesota Statutes Chapter 353, which covers all employees except certain temporary or seasonal employees. The City's contribution for pension costs, under the State-wide plan, was $10,672 for the year ended December 31, 1982. Under existing Minnesota law, the City has no future contingent obligations or commitments to the plan or its participants except to make continuing contributions as determined from time to time by the State Legislature. 18 CITY OF ANDOVER, MI~~ESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1982 Note 9 - Segment Inform~tion for Enterprise Funds Segment information for the City's two enterprise funds for the year ended December 31, 1982 was as follows: Water Sewer Total Revenue $ 43,201 $ 82,574 $ 125,775 Depreciation 16,125 83,611 99,736 Net income (loss) ( 10,535) ( 106,249) ( 116,784) Property and equipment additions 225 225 Net working capital 15,116 6,249 21,365 Total assets 505,656 3,819,146 4,324,802 Total equity contributed 487,998 3.795.297 4,283,295 Retained earnings 16,437 9.043 25,480 Note 10 - Reserved Fund Ba lances The following reservations have been made of various fund balances at December 31, 1982: The collection of certain special assessments has been postponed in accordance with applicable State Statutes or City Council action. These assessments in the amount of $99,560 as of December 31, 1982 are identified as other assessments receivable in the financial statements. The assessments will be collectible when the conditions set forth in the State Statutes or City resolutions occur. It is impossible to determine when these conditions will occur. General Fund - For various City purposes Debt service funds - For debt service Capital projects funds For equipment For construction Special assessment funds For construction For debt service Note 11 - Postpones Special Assessments .... $ 5 , 800 89,576 149,758 68,443 387,994 458,539 $1.160.110 ~ ~ ~ ~ c m ~ m ~ m ; ~ ~ c m ~ I ; m ~ -~;~-- I 19 I CITY OF ANDOVER, MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1982 I I Note 12 - Deficiency in P1edged~Co11atera1 I Minnesota Statutes require depositories for City funds to pledge collateral to secure balances in excess of F.D.LC. insurance coverage. The amount of deposits at a depository cannot exceed the F.D.I.C. insurance plus ninety percent of the market value of securities pledged as collateral by the depository. At December 31, 1982 the collateral pledged by First National Bank of Anoka was approximately $1,000,000 below the statutory requirement. I I I I I I I I I I I I I I 20 CITY OF ANDOVER. MINNESOTA GENERAL FUND COMPARATIVE BALANCE SHEET DECEMBER 31, 1982 AND 1981 ASSETS Petty cash Cash and temporary investments Accrued interest receivable Taxes receivable Unremitted. Delinquent Allowance for uncollectible taxes Accounts receivable Special assessments receivable - Deferred Due from other funds Due from other governmental units Total assets LIABILITIES AND FUND BALANCE Liabilities Accounts payable Due to other governmental units Deposits Deferred revenue Fund balance Reserved Unreserved - Undesignated Total liabilities and fund balance ~ ~ m 1982 m 1981 m $ 150 348,477 1.174 $ 150 194,802 m 2,172 26,606 (26.606) 88 1,272 9,157 2,387 $364.877 m 10,992 (10,992) 6,946 1,718 ~ m 117,180 $320.796 $ 18,617 $ 15,727 6,311 48,215 49,547 75,586 74,348 $148,729 $139,622 $ 5,800 $ 3,648 210,438 177,526 $216,148 $181,l74 $364.877 $320.796 ~ m m I m E m ~ E m - .'~ I I I I I I I I I I I I I I I I I I I 21 CITY OF ANDOVER, MINNESOTA GENERAL FUND STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCES YEAR ENDED DECEMBER 31, 1982 (with comparative actual amounts for year ended December 31, 1981) 1982 1981 Budget Actual Actual Revenue Taxes $261,360 $270,555 $235,785 Licenses and permits 48,210 57,806 50,190 Intergovernmental 349,571 295,615 338,986 Charges for services 9,450 8,520 7,559 Fines and forfeits 10,000 9,883 10,885 Other 141,288 100,193 173,670 Total revenue $819,879 $742,572 $817,075 Other sources Transfers from other funds 46 ,388 48,575 39,146 Total revenue and other sources $866,267 $791,147 $856,221 Expenditures General government $253,322 $242,329 $201,149 Public safety 271,494 267,410 275,700 Public works 131,973 122,616 117,478 Sanitation 13,161 8,307 5,960 Park and recreation 100,417 68,279 95,777 Other una110cated 64,379 17,212 24,451 Total expenditures $834,746 $726,153 $720,515 Other uses Transfers to other funds 31,521 30,020 30,767 Total expenditures and other uses $866,267 $756,173 $751,282 Net increase (decrea se) in fund balance $ -0- $ 34,974 $104,939 Fund balance January 1 181,174 76,235 Fund balance December 31 $216.148 $181.174 22 CITY OF ANDOVER, MINNESOTA ~ ~ ~ GENERAL FUND STATEMENT OF REVENUE, COMPARED TO BUDGET YEAR ENDED DECEMBER 31,.1982 (with comparative actual amounts for year ended December 31, 1981) 1982 Budget Taxes General property taxes Penalties and interest $259,360 2,000 $261,360 Licenses and perm"i ts Business Non-business $ 10.820 37,390 $ 48,210 Intergovernmental Local governmental aid State credits State highway aid Park grants Department of Transportation Insurance premium tax Miscellaneous grants $125,669 176,152 17,750 30,000 $349,571 Charges for services General government Public safety Sanitation $ 6,450 1,500 1,500 $ 9,450 $ 10,000 Fines and forfeits Other Assessments Interest on investments Reimbursement from improvement projects Administrative charges Other Miscellaneous Refunds and reimbursements Revenue collected for other agencies Escrow $ 4,500 4,488 65,000 3,000 1,500 56,300 6,500 $141,288 $819,879 Total revenue Other sources Transfers from other funds Revenue Sharing Fund 46,388 $866.267 Total revenue and other sources -r Actual $268,914 1,641 $270,555 $ 8,996 48,810 $ 57,806 $109,007 143,488 17,445 12,900 12,775 $295,615 $ 4,528 1,392 2,600 $ 8,520 $ 9,883 $ 843 17,486 4,488 6,776 1,617 19,463 46,832 2,688 $100,193 $742,572 48,575 $791.147 1981 Actual ~ E ~ $234,309 1,476 $235,785 $ 8,454 41,736 $ 50,190 ~ ~ m m ~ m m m m c m E m $116,007 156,822 18,364 32,698 11,769 3,326 $338,986 $ 3 , 62 3 1,386 2,550 $ 7,559 $ 10,885 $ 654 15,476 4,232 63,952 1,854 11,209 73,923 2,370 $173,670 $817,075 39,146 $856.221 -~-:- 23 CITY OF ANDOVER, MINNESOTA GENERAL FUND STATEMENT OF EXPENDITURES, COMPARED TO BUDGET ' YEAR ENDED DECEMBER 31, 1982 (with comparative actual amounts for year ended December 31, 1981) 1982 1981 Budget Actual Actual General government Council ' Personal services $ 13,380 $ 11,639 $ 12,571 Other services and charges 8,030 6,114 4,869 $ 21,410 $ 17,753 $ 17,440 Mayor Personal services $ 2,550 $ 2,561 $ 2,559 Other services and charges 100 ' $ 2,650 $ 2,561 $ 2,559 Elections Personal services $ 4,000 $ 5,943 Supplies 1 532 Other services and charges 50 496 Capital outlay 1,300 1,953 $ 1,294 $ 6,350 $ 8,924 $ 1,294 Administrative ' Personal services $ 49.,740 $ 49,738 $ 47,469 Supplies 1,200 1,387 1,332 Other services and charges 3,280 2,203 3,432 Capital outlay 150 885 92 $ 54,370 $ 54,213 $ 52,325 Assessing Other services and charges $ 14,850 $ 15,715 $ 13,580 Consulting staff Auditing $ 6,100 $ 10 $ 5,500. Legal 19,550 16,189 18,362 $ 25,650 $ 26,789 $ 23,862 Personnel administration Personal services $ 9,000 $ 5,882 $ 5,462 Supplies 2,963 ' $ 9,000 $ 8,845 $ 5,462 Planning and zoning ' Personal services $ 10,662 $ 9,532 $ 8,497 Supplies 1,400 1 .1,188 Other services and charges 7,200 3,699 4,149 ' Capital outlay 150 1,180 366 Other 1,500 490 $ 20,912 $ 16,559 $ 14,20` 24 CITY OF ANDOVER, MINNESOTA 1981 Actual c c m ~ ~ ~ ~ GENERAL FUND STATEMENT OF EXPENDITURES, COMPARED TO BUDGEt (CONTINUED) YEAR ENDED DECEMBER 31, 1982 (with comparative actual amounts for year ended December 31; 1981) 1982 Budget Actual General government (Continued) Buildings Administration building Personal services Supplies Other services and charges Capital outlay $ 2,700 3,000 9,000 800 $ 15 ,500 Fire Depa rtment building Supplies Other services and charges Capital outlay $ 3,250 3,550 13,425 $ 20,225 Public Works building Personal services Supplies Other services and charges Capital outlay $ 5,150 3,225 3,000 $ 11,375 $ 47,100 Total buildings Engineering - Staff Personal services Supplies Other services and charges Capital outlay $ 40,780 2,400 2,050 500 $ 45,730 Engineering - Consultant Other services and charges $ 5,300 $253,322 Total general government Public safety Police protection - Other services and charges $112,725 Fire protection Personal services Supplies Other services and charges Relief Association Capital outlay $ 29,135 10,133 16,112 5,000 6,710 $ 67,090 -~~ $ 714 2,996 8,506 496 $ 12,712 $ 2.226 4,013 5,235 $ 11,474 $ 1,861 2,251 4,154 4,960 $ 13,226 $ 37 ,412 $ 38,603 2,200 1.122 379 $ 42,304 $ 11,254 $242,329 $109,785 $ 22,645 8,865 15,142 18,025 7,408 $ 72 ,085 $ 1,388 2,321 8,189 450 $ 12,348 $ 2,267 2,351 2,214 $ 6,832 ~ ~ ~ m m m E $ 1,215 3,062 2,612 2,432 $ 9,321 $ 28,501 $ 29,007 294 499 2,447 $ 32,247 $ 9,679 $201,149 m E m E E $ 99,667 $ 18,543 8,772 7,554 17,021 7,403 $ 59,293 ' CITY OF ANDOVER, MINNESOTA 25 GENERAL FUND ' STATEMENT OF EXPENDITURES, COMPARED TO BUDGET (CONTINUED YEAR ENDED DECEMBER 31, 1982 (with comparative actual amounts for year ended December 31, 1981) 1982 1981 Budget Actual Actual Public safety (Continued) Protective inspection Personal services $ 25,729 $ 29,965 $ 28,659 Supplies 2,200 2,135 2 Other services and charges 2,000 1,035 2,003 Capital outlay 200 295 366 ' Other 56,300 47,177 77,689 $ 86 $ 80,607 $110,881 Animal control Personal services $ 100 $ 49 Supplies 150 209 Other services and charges 5,000 $ 4,933 5,601 ' $ 5,250 $ 4,93.3 $ 5,859 Total public safety $271 494 $267,410 $275,700 Public works Streets and highways Personal services $ 23,484 $ 25,269 $ 25,812 Supplies 27,000 29,160 32,093 Other services and charges 16,500 10,304 9,402 ' Capital outlay 25,200 22,751 21,229 $ 92,184 $ 87,484 $ 88,536 Snow and ice removal ' Personal services $ 16,223 $ 14,878 $ 8,734 Supplies 10,400 7,723 8,176 Other services and charges 4,100 7,230 3,104 ' Capital outlay 341 $ 30,723 $ 29,831 $ 20,355 ' Street signs Personal services $ 1,366 $ 2,500 $ 1,580 Supplies 1,000 273 957 .Capital outlay 6,000 2,210 5,352 $ 8,366 $ 4,983 $ 7,889 Street lighting ' Other services and charges $ 700 $ 318 $ 698 Total public works $131,973 $122,616 $117,478 ' Sanitation Storm sewers Personal services $ 3,060 $ 2,559 $ 697 Supplies 2,300 1,186 211 Other services and charges 4,270 3,447 Capital outlay 4,199 ' $ 9,630 $ 7,192 $ 5,107 26 CITY OF ANDOVER, MINNESOTA GENERAL FUND STATEMENT OF EXPENDITURES, COMPARED TO BUDGET (CONTINUED) YEAR ENDED DECEMBER' 31, 1982 (with comparative actual amounts for year ended December 31, 1981) Sanitation (Continued) Diseased trees Personal services Supplies Other services and charges Capital outlay Total sanitation Parks and recreation Personal services Supplies Other services and charges Capital outlay Other una110cated Metropolitan Waste Control Commission Insurance Improvement projects Miscellaneous Contingency Total expenditures Other uses Transfers to other funds 1979 Certificate of Indebtedness Fund 1980 Equipment Certificate Fund Total expenditures and other uses r-' 1982 1981 Actual Budget Actual $ 2,531 $ 939 $ 833 500 19 10 250 29 10 250 128 $ 3,531 $ i,115 $ 853 $ 13,161 $ 8,307 $ -5,960 $ 18,370 $ 17,356 $ 19,407 6,045 7,700 6,497 45,802 42,928 33,701 30,200 295 36 ,172 $100,417 $ 68,279 $ 95,777 $ 4,300 $ 4,300 $ 4,300 1.722 10,000 11,921 17,423 1,000 991 1,006 49,079 (:. 64,379 $ 17,212 $ 24,451 y $834,,746 $726,153 $720,515 $ 19,972 $ 20,060 $ 21,080 11 ,549 9,960 9,687 $ 31,521 $ 30,020 $ 30,767 .$866.267 $756.173 $751.282 - ~ ~ I ~ m ~ ~ ~ ~ E E m ~ ~ E m m E I I I I I I I I I I ,I I I I I I I I I I CITY OF ANDOVER, MINNESOTA SPECIAL REVENUE FUND - REVENUE SHARING FUND COMPARATIVE BALANCE SHEET DECEMBER 31, 1982 AND 1981 1982 ASSET - $ 46 Cash and temporary investments FUND BALANCE Fund balance Unreserved - Undesignated $ 46 STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCES YEAR ENDED DECEMBER 31, 1982 (with comparative actual amounts for year ended December 31, 1981) $ $ 27 1981 -0- -0- 28 $ 119 $ 89.576 $ 84.513 ~ ~ ~ ~ ~ ~ ; m E E m m ; m ~ m I I I CITY OF ANDOVER, MINNESOTA DEBT SERVICE FUNDS COMBINING BALANCE SHEET DECEMBER 31, 1982 comparative totals for December (with 31, 1981) 1979 Certificate 1980 1978 G.O. of Equipment Totals Bonds Indebtedness Certificate 1982 1981 ASSETS Cash and temporary investments $ 85, 919 $ 119 $ 86,038 $ 75.742 Accrued interest receivable 441 441 329 Taxes receivable Unremitted 320 320 Delinquent 3,975 3,975 1,780 Allowance for delinquent taxes ( 3,975) ( 3,975) ( 1,780) Due from other funds 2,777 2,777 Due from other governmental units 8,442 Total assets $ 89.457 $ -O- S 119 $ 89.5.76 $ 84 . 513 FUND BALANCE Fund balance - Reserved for debt service $ 89.457 $ -0- t :- I I I I I I I I I I I I I I I I I I I 29 CITY OF ANDOVER, MINNESOTA DEBT SERVICE FUNDS COMBINING STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCES YEAR ENDED DECEMBER 31, 1982 (with comparative totals for year ended December 31, 1981) 1979 Certificate 1980 1978 G.O. of Equipment Totals Bonds Indebtedness Certificate 1982 1981 Revenue General property taxes $ 38,444 $ 38,444 $ 35,441 State credits 20,206 20,206 25,362 Interest on investments 5,668 $ 119 5,787 5,932 Other 210 210 191 $ 64,528 $ 119 $ 64,647 $ 66,926 Other sources Transfer from General Fund $ 20,060 9,960 30,020 30,767 Total revenue and other sources $ 64,528 $ 20,060 $ 10,079 $ 94,667 $ 97,693 Expenditures Redemption of bonds $ 40,000 $ 17,000 $ 8,000 $ 65,000 $ 60,000 Interest and service charges 19,584 3,060 1,960 24,604 28,321 Total expenditures $ 59,584 $ 20,060 $ 9,960 $ 89,604 $ 88,321 Net increase in fund balance $ 4,944 $ -0- $ 119 $ 5,063 $ 9,372 Fund balance January 1 84 , 513 -0- -0- 84 , 513 75,141 Fund balance December 31 $ 89.457 $ -0- $ 119 $ 89.576 $ 84 . 513 30 (with LIABILITIES AND FUND BALANCE Liabilities Accounts payable Contracts payable Due to other funds Total liabilities Fund balance Reserved for equipment Reserved for construction Unreserved - Undesignated $ Total fund balance $ Total liabilities and fund balance $ v- CITY OF ANDOVER, MINNESOTA ~ E E ~ ~ ~ ~ E E E ; m I I m ! ; E E CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET DECEMBER 31, 1982 comparative totals for December 8,682 8,682 8.682 31, 1981) $ 1,250 $ 1,710 9,564 1,083 $ 12,357 $ 180 $ 1,890 10,814 1,083 180 $ 13,787 $ 1,250 $ $149,758 $149,758 $ 2,15.9 $ 66,284 68,443 39,709 48,39l $ 69,103 $ 41,868 $ 66,284 $149,758 $266,592 $ 69 ,103 $ 43.118 $ 78.641 $149.938 $280.379 $ 69.103 --=::- I I I I I I I I I I I I I I I I I I I 31 CITY OF ANDOVER, MINNESOTA CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCES YEAR ENDED DECEMBER 31, 1982 (with comparative totals for year ended December 31, 1981) 32 CITY OF ANDOVER, MINNESOTA SPECIAL ASSESSMENT FUNDS COMBINING BALANCE SHEET DECEMBER 31, 1982 (with comparative totals for December 31, 1981) ASSETS Cash and temporary investments Accrued interest receivable Taxes receivable - Delinquent Allowance for delinquent taxes Special assessments receivable Unremitted Delinquent Deferred Other Due from other funds Due from other governmental units Total assets LIABILITIES AND FUND BALANCE Liabilities Accounts payable Contracts payable Due to other funds Deposits payable Bonds payable Total 1 iabil i ti es Fund balance (deficit) Reserved for construction Reserved for debt service Unreserved - Undesignated Total fund balance Total liabilities and fund balance 76-1 c ~ C C. ~ 75-1 75-2 $ 545,983 3,833 401 4,103 489,997 4,545 $ 1.048.862 $ 1, 11 0 , 000 $ 1,110,000 $( 61,138) $( 61,138) $ 1.048.862 $ 20,878 94 16 16) ( 2,794 13 , 902 $ 37.668 $ 2,777 $ 18,400 21,177 $ $ 2,990 13,501 16,491 $ 37.668 $ 1,022,389 6,297 40 ( 40) c 842 28,569 690,094 ~ $ 1. 748.191 ~ ~ m m m ~ E ; ~ ; ; E $ 1,424,200 $ 1,424,200 $ 323,991 $ 323,991 $ 1.748.191 - --::.=--- ' 33 ' Improvement Projects 77 -1 78 -1 79 -1 79 -2 80 -1 ' $ 443,864 $ 79,604 $ 72,979 $ 30,661 $ 23,488 2,705 432 399 42 120 ' 716 509 998 10,448 1,172 4,478 3,640 2,812 ' 352,344 177,451 191,649 243,909 98,932 8,765 ' S 810,077 $ 259,168 S 270,503 $ 287,017 S 125,352 t $ 695,000 $ 245,000 $ 255,000 $ 283,500 $ 121,500 $ 695,000 $ 245,000 $ 255,000 $ 283,500 $ 121,500 ' $ 115,077 $ 14,168 $ 15,503 $ 3,517 $ 3,852 $ 115,077 $ 14,168 $ 15,503 $ 3,517 $ 3,852 ' $ 810,077 $ 259,168 S 270,503 S 287,017 S 125,352 34 CITY OF ANDOVER, MINNESOTA SPECIAL ASSESSMENT FUNDS COMBINING BALANCE SHEET (CONTINUED) DECEMBER 31, 1982 (with comparative totals for December 31, 1981) ASSETS Cash and temporary investments Accrued interest receivable Taxes receivable - Delinquent Allowance for delinquent taxes Special assessments receivable Unremitted Delinquent Deferred Other Due from other funds Due from other governmental units Total assets LIABILITIES AND FUND BALANCE Liabilities Accounts payable Contracts payable Due to other funds Deposits payable Bonds payable Total liabilities Fund balance (deficit) Reserved for construction Reserved for debt service Unreserved - Undesignated Total fund balance Total liabilities and fund balance t' ~ m ~ ~ 80-2 $ 56,633 380 1,411 49,363 $ 101. 787 $ $ 93,100 93,100 $ $ 14,687 14,687 $ 107.787 80-3 $ 1,622,235 8,429 1,184 61,198 2,587,744 86,250 $ 4.367.040 $ 520 59,147 150,725 3,819,375 $ 4,029,767 $ 347,450 ( 10,177) $ 337,273 $ 4.367.040 80-4 $ 34,264 141 493 2,132 290,756 59,147 $ 386.933 $ $ 371 ,025 371,025 $ $ 15,908 15,908 $ 386.933 ~ ~ ~ ~ ~ I ~ I ! I m I E I I -------=-= - - ' 35 ' Improvement Projects Totals 81 -1 81 -2 82 -7 1982 1981 1 $ 36,241 $ 50,632 $ 68,186 $ 4,108,037 $ 3,472,191 317 81 188 23,458 22,482 56 98 ( 56) ( 98) 611 614 6,368 906 2,673 126,336 62,210 ' 101,985 149,234 140,566 5,577,926 6,034,842 99,560 99,386 59,147 ' 465 S 140,060 $ 203,234 S 208,940 $10,000,832 $ 9,691,576 ' $ 828 $ 1,348 $ 1,342 $ 532 5,569 6,101 5,144 ' 61,924 150,725 150,725 $ 135 175,000 174,600 8,920,700 9,093,000 ' $ 135,000 $ 175,532 $ 180,997 $ 9,140,798 $ 9,250,211 $ 12,701 $ 27,843 $ 387,994 $ 495,724 ' $ 5,060 15,001 100 458,539 ( 64,906) 13,501 10,547 $ 5,060 $ 27,702 $ 27,943 $ 860,034 $ 441,365 $ 140,060 S 203,234 $ 208,940 $10,000,832 $ 9,691,576 36 CITY OF ANDOVER, MINNESOTA ~ ~ SPECIAL ASSESSMENT FUNDS COMBINING STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCES YEAR ENDED DECEMBER 31, 1982 (with comparative totals for year ended December 31, 1981) ~ ~ 75..;1 Revenue General property taxes State credits Forfeited tax sale Special assessments levied Unit connection charges Interest on investments Interest on assessments State aid Reimbursements from other funds Miscellaneous Total revenue $ 35 4,102 67,148 31,110 $ 1,262 103,657 Expenditures Assessment adjustments Construction costs Reimbursements to other funds Interest and fiscal charges Total expenditures $ $ 56,500 56,500 Net increase (decrease) in fund balance $ 47,157 ( 108,295) Fund balance (deficit) January 1 Fund balance (deficit) December 31 $( 61.138) r. 75-2 $ 193 81 2,264 1,308 $ 33 3,879 $ 926 $ 1 ,483 2,409 $ 1,470 15,021 $ 16.491 76-1 $ 38 4,636 116,976 54,963 241 $ 176,854 $ 4,683 95,179 $ 99,862 ~ ~ ~ ~ ; ! E I $ 76,992 $ 246,999 323.991 I E m I E I I 37 ' Improvement Projects 77 -1 78 -1 79 -1 79 -2 80 -1 $ 681 ' $ 49,378 $ 7,258 $ 6,941 688 $ 1,140 23 13,492 15,109 21,890 9,209 ' 462 104 97 78 35 $ 73,463 $ 20,854 $ 22,147 $ 23,337 $ 10,384 $ 2,472 $ 225 $ 696 $ 429 $ 356 ' 37,661 14 16 19,173 8,217 $ 40,133 $ 14,625 $ 17,646 $ 19,602 $ 8,573 = 1 $ 33,330 $ 6,229 $ 4,501 $ 3,735 $ 1,811 ' 81,747 7,939 11,002 ( 218 2,041 S 115.,07.7 $ 14,168 $ 15,503 S 3.517 $ 3,852 38 c ~ ~ ~_.. m m CITY OF ANDOVER, MINNESOTA SPECIAL ASSESSMENT FUNDS COMBINING STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCES (CONTINUED) YEAR ENDED DECEMBER 31, 1982 (with comparative totals for year ended December 31, 1981) m m m, I Ii , , i ! mi I ;1 C C C C C ~ ~ - 39 ' Improvement Projects Totals 81 -1 81 -2 82-7 1982 1981 $ 266 $ 1,907 ' 81 1,393 5,317 $ 169,949 186,955 3,716,135 6,666 11,300 ' $ 4,148 $ 4,181 318 420,719 498,953 14,366 23,829 651,971 226,929 28,984 ' 8,266 54,083 6,320 1,577 $ 18,514 $ 28,010 $ 170,267 $ 1,286,561 $ 4,541,261 $ 193 $ 416 $ 10,909 $ 19,109 42,651 $ 118,235 162,768 1,391,258 ' 115 24,089 24,204 165,169 16,047 15,860 670,011 587,160 $ 16,240 $ 59,042 $ 142,324 $ 867,892 $.2,162,696 ' $ 2,274 $( 31,032) $ 27,943 $ 418,669 $ 2,378,565 ' 2,786 58,734 -0- 441,365 (1,937,200 S 5,060 $ 27,702 $ 27,943 S 860,034 $ 441,365 1 THIS PAGE LEFT BLANK INTENTIONALLY ~ ~ ~ ~ m m m m m m I I C I C C C ~ ~ 40 j.-; I .--~~ I I I I I 1 I I 1 c, 1 1 -I -I I CI - I ~ I - I _I CITY OF ANDOVER, MINNESOTA ALL PROPRIETARY FUND TYPES - ENTERPRISE FUNDS COMBINING BALANCE SHEET DECEMBER 31, 1982 (with comparative totals for December 31, 1981) ASSETS Water - Current assets Cash and temporary investments $ Accrued interest receivable Accounts receivable Inven tory Property and equipment Furniture and equipment Machinery Collection and distribution systems Less accumulated depreciation Other asset Future connection charges Total assets LIABILITIES AND FUND EQUITY Current liabilities Accounts payable Due to other funds Due to other governementa1 units Other lia bil ity Deferred revenue - Connection charges Fund equity Contributed Retained earnings - Unreserved Total liabilities and fund equity 12,375 372 1,340 2,250 16,337 $ $ 1,564 190,832 321,112 $ 513,508 24,189 $ 489,319 $ 505.656 $ 1,221 $ 1,221 $ 487,998 16,437 $ 504,435 $ 505.656 Sewer $ ( 1,329) $ 136 22,248 $ 21,055 $ $ 3,278 4,165,666 $4,168,944 370,853 $3,798,091 $3.819.146 $ 366 8,074 $ 6,366 14,806 $3,795,297 9,043 $3,804,340 $3.819.146 1982 11 ,046 $ 508 23,588 2 ,250 37,392 $ $ 4,842 190,832 4,486,778 $4,682,452 395,042 $4,287 ,410 $4.324.802 $ 1,587 8,074 $ 6,366 16,027 $4,283,295 25,480 $4,308,775 $4.324.802 41 Totals 1981 13,415 19 , 584 5,885 38,884 $ 4,617 190,832 4,486,778 $4,682,227 295,306 $4,386,921 $ 30,460 $4.456.265 $ 246 $ 246 $ 30,460 $4,382,572 42,987 $4,425,559 $4.456.265 42 CITY OF ANDOVER, MINNESOTA c ~ ALL PROPRIETARY FUND TYPES - ENTERPRISE FUNDS COMBINING " STATEMENT. OF CHANGES IN FUND EQUITY YEAR ENDED DECEMBER 31, 1982 (with comparative totals for year ended December 31, 1981) Water Fllnd Sewer Fund Retained Retained Contributed earnings Total Contributed Fund equity January 1 $503,962 $ 11 ,008 $514,970 $3,878;610 $ 31,979 Net income (1 os s) (10,535) (10,535) (106,249) Additions to property and equipment from customers' contributions Depreciation on contributed property and equipment transferred to contributions (15,964) 15,964 ( 83,313) 83,313 Fund equity December 31 $487.998 $ 16.437 $504.435 $3.795.297 $ 9.043 ~ ~ m m ~ ~ ; m I I C' C C C ~: cl ci c r -----~ - I I 1 __1_.. I I 1 I 1 I 1 1 -I 1 -I ~ I ~ I 1 I 43 Total 1982 Total 1981 Retained Retained Total Contributed earnings Total Contributed earnings Total - $3,910.589 $4,382,572 $ 42,987 $4,425,559 $2,378,645 $ 21,708 $2,400.353 ( 106,249) (116,784) ( 116,784) (54,340) ( 54,340) ( 99,277) $4.283.295 $3.804.340 2,079,546 99,277 $ 25,480 ( 75,619) $4.382.572 75,619 $ 42.987 $4.308...l12 2,079,546 $4.425.559 44 CITY OF ANDOVER, MINNESOTA ALL PROPRIETARY FUND TYPES - ENTERPRISE FUNDS COMBINING STATEMENT OF REVENUE AND EXPENSE YEAR ENDED DECEMBER 31, 1982 (with comparative totals for year ended December 31, 1981) Revenue User charges Connection charges Meters Penalties Interest Other Totals Water Sewer 1982 1981 $ 6,836 $ 68,482 $ 75,318 $ 59,794 31,559 11 , 340 42,899 39,020 3,795 3,795 3,250 92 1,634 1,726 1,460 919 1,118 2,037 795 199 $ 43,201 $ 82,574 $ 125,775 $ 104,518 $ 23,582 $ 9,631 $ 33,213 $ 19,315 6,025 2,293 8,318 9,677 8,004 16,895 24,899 4,697 76,393 76,393 49,313 $ 37,611 $ 105,212 $ 142,823 $ 83,002 $ 5,590 $( 22,638) $( 17 ,048) $ 21,516 Expense (excluding depreciation) Personal services Supplies Other services and charges Disposal charges Income (loss) before depreciation Less depreciation On assets acquired with own funds On assets acquired from contributions Net income (loss) f-' $ 161 $ 298 $ 459 $ 237 15,964 $ 16,125 83,313 $ 83,611 99,277 $ 99,736 75,619 $ 75,856 $ ( 54.340) $( 10.535) $006.249) $(116.784) - ~ ~ ~ C ; m ~ m ~ ;' , . I ~! i Ci c C ~: ~I ~ E ~ "_0- .:;;-:--- I CITY OF ANDOVER, MINNESOTA 1 I 1 I I ALL PROPRIETARY FUND TYPES - ENTERPRIS.E FUNDS COMBINING STATEMENT OF CHANGES IN FINANCIAL POSITION YEAR ENDED DECEMBER 31, 1982 (with comparative totals for year ended December 31, 1981) I I I I 1 I 1 -I -I - I I - I ~ I 45 46 CITY OF ANDOVER, MINNESOTA WATER FUND COMPARATIVE BALANCE SHEET DECEMBER 31, 1982 AND 1981 ASSETS Current. assets Cash and temporary investments Accrued interest receivable Accounts receivable Inventory Property and equipment Furniture and equipment Machinery Distribution system Less accumulated depreciation Total assets LIABILITY AND FUND EQUITY Current liability Accounts payable Fund equity Contributed Retained earnings - Unreserved Total liability and fund equity - t 1982 ~ ~ c ~ ~ c ~ ~ m I c C c c ~ c c ~ ~ 1981 $ 12,375 $ 3,397 372 1,340 480 2,250 5,885 $ 16,337 $ 9,762 $ 1,564 $ 1,564 190,832 190,832 321,112 321,112 $513 ,508 $513,508 24,189 8,064 $489,319 $505,444 $505.656 $515.206 $ 1,221 $ 236 $487,998 16,437 $504,435 $505.656 $503,962 11 ,008 $514,970 $515.206 I 1 1 1 1 I I 1 1 I I 1 1 -I -I - I I - I - - I CITY OF ANDOVER, MINNESOTA WATER FUND COMPARATIVE STATEMENT OF CHANGES IN FUND EQUITY YEARS ENDED DECEMBER 31, 1982 AND 1981 Contributed Retained earnings Year ended December 31, 1982 Fund equity January 1 $503,962 $ 11,008 Net income (loss) (10,535) Additions to property and equipment from customers' contributions Depreciation on contributed property and equipment transferred to contributions (15,964) $487.998 15,964 $ 16.437 Fund equity December 31 47 Total - $514,970 (10,535) $504.435 Year ended December 31, 1981 Fund equity January 1 $ -0- $ -0- $ -0- Net income 3,026 3,026 Additions to property and equipment from customers' contributions 511,944 511,944 Depreciation on contributed property and equipment transferred to contributions ( 7,982) 7,982 Fund equity December 31 $503.962 $ 11.008 $514.970 48 CITY OF ANDOVER, MINNESOTA WATER FUND COMPARATIVE STATEMENT OF REVENUE AND EXPENSE YEARS ENDED DECEMBER 31, 1982 AND 1981 Revenue User charges Connection charges Penalties Meters Interest Other Expense (excluding depreciation) Personal services Supplies Other services and charges Income before depreciation Less depreciation On assets acquired with own funds On assets acquired from contributions Net income (loss) f. 1982 $ 6,836 31,559 92 3,795 919 $ 43,201 $ 23,582 6,025 8,004 $ 37,611 $ 5,590 $ 161 15,964 $ 16,125 $00.535) ~ ~ ~ 1981 ~ $ 1,804 ~ 30,480 3,250 m 593 197 $ 36,324 ~ $ 14,434 7,517 m 3,283 $ 25,234 $ 11 ,090 I $ 82 I 7,982 $ 8,064 $ 3.026 & C ~ ~ i , C t f ~ I ~ I I ~ i I ~ ! -- -,;- I 1 I 1 I I I 1 1 1 I 1 I cl I -I I = I ~ I 49 CITY OF ANDOVER, MINNESOTA WATER FUND COMPARATIVE STATEMENT OF CHfu~GES IN FINANCIAL POSITION YEARS ENDED DECEMBER 31, 1982 AND 1981 1982 1981 Sources of working capital Operations Net income (loss) Item not requiring working capital Depreciation $ (10,535) $ 3,026 16,125 8,064 $ 5,590 $ 11,090 511,944 $ 5,590 $523,034 $ -0- $513,508 $ 5.590 $ 9.526 Customers' contributions of property and equipment Uses of working capital Acquisition of property and equipment Increase in working capital Elements of net change in working capital Cash and temporary investments $ 8,978 $ 3,397 Accrued interest receivable 372 Accounts receivable 860 480 Inventory ( 3,635) 5,885 Accounts payable ( 985) ( 236) Increase in working capital $ 5.590 $ 9.526 50 CITY OF ANDOVER, MINNESOTA. SEWER FUND COMPARATIVE BALANCE SHEET DECEMBER 31, 1982 AND 1981 ASSETS Current assets Cash and temporary investments (deficit) Accrued interest receivable Accounts receivable Property and equipment Furniture and equipment Collection system Less accumulated depreciation Other asset Future connection charges Total assets LIABILITIES AND FUND EQUITY Current liabilities Accounts payable Due to other funds Due to other governmental units Other lia b i1 ity Deferred revenue - Connection charges Fund equity Contributed Retained earnings - Unreserved Total liabilities and fund equity - ~ ~ 1982 $ ( 1 , 329) 136 22,248 $ 21,055 $ 3,278 4,165,666 $4,168,944 370,853 $3,798,091 $3.819.146 ~ C 1981 ~ ~ ~ m $ 10,018 19,104 $ 29,122 $ 3,053 4,165,666 $4,168,719 287,242 $3,881,477 ~ ~ m ! C $ 30,460 $3.941.059 c c c c c c c c I 1 I 1 I I I I I I I I I I I I I I I ~ 51 CITY OF ANDOVER, MINNESOTA SEWER FUND COMPARATIVE STATEMENT OF CHANGES IN FUND EQUITY YEARS ENDED DECEMBER 31, 1982 AND 1981 Retained Contributed earnings Total - Year ended December 31, 1982 Fund equity January 1 $3,878,610 $ 31.979 $3,910,589 Net income (loss) ( 106,249) ( 106,249) Depreciation on contributed property and equipment transferred to contributions ( 83,313) 83,313 Fund equity December 31 $3.795.297 $ 9.043 $3.804.340 Year ended December 31, 1981 Fund equity January 1 $2,378,645 $ 21,708 ( 57,366) $2,400,353 Net income (loss) ( 57,366) Additions to property and equipment from customers' contributions 1,567,602 1,567,602 Depreciation on contributed property and equipment transferred to contribtions (67,637) 67,637 $ 31. 979 Fund equity December 31 $3.878.610 $3.910.589 52 CITY OF ANDOVER, MINNESOTA SEWER FUND COMPARATIVE STATEMENT OF REVENUE AND EXPENSE YEARS ENDED DECEMBER 31, 1982 AND 1981 Revenue User charges Connection charges Penalties Interest Other Expense (excluding depreciation) Personal services Supplies Other services and charges Disposal charges Income (loss) before depreciation Less depreciation On assets acquired with own funds On assets acquired from contributions Net income (loss) t' 1982 $ 68,482 11 , 340 1,634 1,118 $ .82,574 $ 9,631 2,293 16,895 76,393 $ 105,212 $( 22,638) $ 298 83,313 $ 83,611 $006.249) 1981 ~ ~ ~ ; ~ ~ ~ ~ I E I m E I m E m I &, I $ 57,990 8,540 1,460 202 2 $ 68,194 $ 4,881 2,160 1,414 49,313 $ 57,768 $ 10,426 $ 155 67,637 $ 67,792 $ ( 57.366) I I 1 1 I I I 1 I I I I I I I I I I I 53 CITY OF ANDOVER, MINNESOTA SEWER FUND COMPARATIVE STATEMENT OF CHANGES IN FINANCIAL POSITION YEARS ENDED DECEMBER 31, 1982 AND 1981 1982 1981 Sources of working capital Operations Net income (loss) Item not requiring working capital Depreciation $( 57,366) 67,792 $ 10,426 Customers' contributions of property and equipment Increase in other assets Decrease in deferred revenue 1,567,602 30,460 $ $ 30,460 30,460 $1,608,488 Uses of working capital Ope,ations Net loss Depreciation $ 106,249 ( 83,611) $ 22,638 225 $1,570,448 30,460 30,460 $ 53,323 $1,600,908 $( 22.863) $ 7.580 Acquisition of property and equipment Increase in deferred revenue Decrease in other assets Increase (decrease) in working capital Elements of net change in working capital Cash and temporary investments Accrued interest receivable Accounts receivable Accounts payable Due from other funds Due to other governmental units $( 11 ,347) $ 5,984 136 3,144 1,675 ( 356) 277 ( 8,074) ( 356) ( 6,366) $( 22.863) $ 7.580 Increase (decrease) in working capital 54 CITY OF ANDOVER, MINNESOTA COMPARATIVE STATEMENT OF GENERAL FIXED ASSETS DECEMBER 31, 1982 AND 1981 General Fixed Assets Land and improvements Buildings and improvements Furniture and equipment Machinery and automotive equipment 1982 1981 $ 95,881 $ 66,397 408,432 386,831 62,492 38,594 368,901 368,901 $935.706 $860.723 Total General Fixed Assets Investment in General Fixed Assets $935..706 $860.723 .. ~ ~ ~ ~ ~ I ~ ~ ; I ; m I I m E I I I --=-- -:=-- 1 I I I I 1 I 1 I I I I 1 I 1 I I I I CITY OF ANDOVER, MINNESOTA COMPARATIVE STATEMENT OF GENERAL LONG-TERM DEBT DECEMBER 31, 1982 AND 1981 Amount available and to be provided for payment of general long-term debt Amount available in debt service funds Amount to be provided by future revenues Total General long-term debt payable Accounts payable Assessments on City property Vacation pay - Governmental funds Contracts payable Equipment purchase Due to other governmental units Metropolitan Waste Control Commission Bonds and Certificates of Indebtedness G.O. Improvement (Building and Equipment) Bonds of 1978 1979 Certificates of indebtedness 1980 Certificates of indebtedness 1982 Certificates of indebtedness Total 1982 $ 89,576 578,366 $667.942 $ 93,076 3,804 8,887 29,175 325,000 34,000 24,000 150,000 $667.942 55 1981 $ 84,513 494,615 $579.128 $ 95,858 3,500 31,770 365,000 51,000 32,000 $579.128 56 THIS PAGE LEFT c ~ ~ ~ ~ ~ ~ ~ ~ ~. E ~ ~ ~ ~ E E I E BLANK I~TE~TIO~ALLY ~ i ~--------:~ 1 I 1 I 1 I I I 1 1 1 1 1 I 1 1 I 1 1 SECTION III STATISTICAL SECTION c c C E ~ ~ ~ c m ~ ~ ~ m ~ ~ m ; E m r t I 57 1 CITY OF ANDOVER, MINNESOTA SCHEDULE OF CASH, TEMPORARY INVESTMENTS AND SECURITY FOR DEPOSITS DECEMBER 31, 1982 1 I Cash Face amount of securities pledged as collateral by depository 1 1 First National Bank of Anoka Checking accounts Savings accounts Certificates of deposit $ 47 961,445 3,871,900 $4.833.392 $4,270.000 1 1 Additona1 security of $100,000 each for demand deposits and time deposits is provided by the Federal Deposit Insurance Corporation. 1 Minnesota Law stipulates that the amount of deposits cannot exceed the F.D.I.C. insurance plus ninety percent of the market value of securities pledged as collateral by the bank. On December 31, 1982, the bank deposits at First National Bank of Anoka were in excess of this requirement. I 1 I 1 I 1 I 1 I -I 58 CITY OF ANDOVER, MINNESOTA COMBINED SCHEDULE OF INDEBTEDNESS DECEMBER 31, 1982 Final Interest Issue maturity rates date date Bonded indebtedness Special assessment bonds Improvement Bonds of 1975 6.25- 6.50% 9/1/75 9/1/86 General Obligation Improvement Bonds of 1976 6.20-6.80 8/1/76 2/1/97 Improvement Bonds of 1976 5.00-6.75 11/1/76 11/1/96 General Obligation Improvement Bonds of 1977 5.00 3/1/77 1/1/96 General Obligation Improvement Bonds of 1977 5.25-5.50 10/1/77 2/1/98 General Obligation Improvement Bonds of 1978 5.25- 6.00 11/1/78 2/1/99 General Obligation Improvement Bonds of 1979 6.50 11/1/79 2/1/95 General Obligation Improvement Bonds of 1980 6.10-6.90 6/1/80 2/1/91 General Obligation Improvement Bonds of 1980 7.00 8/1/80 2/1/01 General Obligation Improvement Bonds of 1980 8.50- 9.10 10/1/80 2/1/02 General Obligation Improvement Bonds of 1981 9.75-10.00 7/1/81 8/1/91 General Obligation Improvement Bonds of 1981 10.25-11.50 10/1/81 2/1/92 General obligation bonds General Obligation Improvement Bonda of 1978 (Building & Equipment) 1979 Certificates of Indebtedness 1980 Certificates of Indebtedness 1981 Certificates of Indebtedness 11/1/78 8/1/79 10/1/80 12/31/81 5.55-5.70 6.00 7.00 8.00 2/1/89 8/1/84 4/1/85 12/31/87 Total Bonded Indebtedness Long-term payable Metropolitan Waste Control Commission Special assessments on City owned property Equipment purchase 1971 1991 Various 1982 2001 1987 Total Indebtedness ~ ~ ; E I ! ; I E I I I I I I I I I E ------::i. - 59 Indebtedness Authorized and issued Redeemed Outstanding Due in 1983 Principal Interest $ 46,000 $ 27,600. $ 18,400 $ 4,600 $ 1,196 1,635,000 250,000 1,385,000 60,000 88,918 56,000 16,800 39,200 2,800 2,436 1,215,000 105,000 1,110,000 25,000 55,500 780,000 85,000 695.000 30,000 36.168 270,000 25,000 245,000 10 , 000 13,850 270,000 15,000 255,000 15,000 16.088 430,000 25,000 405,000 30,000 25,680 98,000 4,900 93,100 4,900 6,345 4,365,000 4,365,000 105,000 377,127 150,000 15,000 135,000 15,000 13,350 175,000 175,000 17,500 18,025 $ 9,490,000 $ 569,300 $ 8,920,700 $ 319,800 $ 654,683 $ 430,000 $ 105,000 $ 325,000 $ 40,000 $ 17,253 85,000 51 , 000 34,000 17,000 2,040 40,000 16,000 24,000 8,000 1,400 150,000 150,000 30,000 12,000 $ 705,000 $ 172,000 $ 533,000 $ 95,000 $ 32,693 $10,195,000 $ 741,300 $ 9,453,700 $ 414,800 $ 687,376 $ 43,018 $ 13 , 843 $ 29,175 $ 2,733 $ 1,567 102,741 9,665 93,076 3,016 9,319 10,115 1,228 8,887 1,598 1,522 $ 155,874 $ 24,736 $ 131,138 $ 7,347 $ 12,408 $10.350.874 $ 766.036 $ 9.584.838 L-422.147 $ 699.784 I I ~ I 60 CITY OF ANDOVER, MINNESOTA SCHEDULE OF BONDS PAYABLE DECEMBER 31, 1982 ~- - r- 1 61 ' CITY OF ANDOVER, MINNESOTA SCHEDULE OF BONDS PAYABLE (CONTINUED DECEMBER 31, 1982 1 ' Annual Issue Maturity Interest serial date date rate payments ' Special assessment bonds (continued) General Obligation Improvement Bonds of 1977 10/1/77 $30,000 per year 2/1/83 -85 5.25% $ 90,000 $35,000 per year 2/1/86 -88 5.25 105,000 $40,000 per year 2/1/89 -90 5.25 80,000 ' February 1, 1991 2/1/91 5.25 45,000 February 1, 1992 2/1/92 5.20 45,000 February 1, 1993 2/1/93 5.25 50,000 ' February 1, 1994 2/1/94 5.30 50,000 $55,000 per year 2/1/95 -96 5.40 110,000 $60,000 per year 2/1/97 -98 5.50 120,000 $ 695,000 ' General Obligation Improvement Bonds of 1978 1/1/78 ' February 1, 1983 2/1/83 5.25 $ 10,000 $10,000 per year 2/1/84 -88 5.50 50,000 February 1, 1989 2/1/89 5.50 15,000 February 1, 1990 2/1/90 5.60 15,000 ' February 1, 1991 2/1/91 5.70 15,000 February 1, 1992 2/1/92 5.75 15,000 February.l, 1993 2/1/93 5.80 15,000 February 1, 1994 2/1/94 5.90 15,000 February 1, 1995 2/1/95 6.00 15,000 $20,000 per year 2/1/96 -99 6.00 80,000 ' $ 245,000 General Obligation Improvement Bonds of 1979 11/1/79 $15,000 per year 2/1/83 -87 6.50 $ 75,000 $20,000 per year 2/1/88 -91 6.50 80,000 $25,000 per year 2/1/92 -95 6.50 100,000 $ 255,000 1 62 CITY OF ANDOVER, MINNESOTA SCHEDULE OF BONDS PAYABLE (CONTINUED DECEMBER 31, 1982 Annual Issue Maturity Interest serial date date rate payments i Special assessment bonds (continued) General Obligation Improvenent Bonds of 1980 6/1/80 j February 1, 1983 6.10% $ 30,000 February 1, 1984 6.20 30,000 a February 1, 1985 6.30 35,000 February 1, 1986 6.40 40,000 February 1, 1987 6.50 45000 February 1, 1988 6.60 50,,000 O February 1, 1989 6.70 50,000 February 1, 1990 6.80 60,000 February 1, 1991 6.90 65,000 ' $ 405,000 i General Obligation Bonds of 1980 8/1/80 $4,900 per year 2/1/83 -2001 7.00 $ 93,100 General Obligation Improvement Bonds of 1980 10/1/80 February 1, 1983 8.50 $ 105,000 February 1, 1984 8.50 105,000 February 1, 1985 8.50 120,000 February 1, 1986 8.50 130,000 February 1, 1987 8.50 145,000 ?_ February 1, 1988 8.50 160,000 February 1, 1989 8.50 170,000 February 1, 1990 8.50 190,000 February 1, 1991 8.50 210,000 February 1, 1992 8.50 230,000 February 1, 1993 8.50 250,000 February 1, 1994 8.50 275,000 February 1, 1995 8.60 305,000 February 1, 1996 8.80 330,000 February 1, 1997 9.00 370,000 February 1, 1998 9.00 200,000 February 1, 1999 9.10 230,000 February 1, 2000 9.10 255,000 February 1, 2001 9.10 — 280,000 a February 1, 2002 9.10 305,000 $4,365,000 i I ' i I I I I I I I I 1 I 1 -I -I I ~I -I I -I - I 63 CITY OF ANDOVER, MINNESOTA SCHEDULE OF BONDS PAYABLE (CONTINUED) DECEMBER 31, 1982 Note - January 1, 1983 maturities are considered matured December 31, 1982. 64 E I m E m E m m m I I E ~ ~ ~ E E ~ E CITY OF ANDOVER, MINNESOTA DEBT SERVICE REQUIREMENTS DECEMBER 31, 1982 Special assessment bonds Year Principal Interest Total - 1983 $ 319,800 $ 654,683 $ 974,483 1984 324,800 631,429 956,229 1985 349,800 607,028 956,828 1986 379,800 580,754 960,554 1987 400,200 552,347 952,547 1988 435,200 522,149 957,349 1989 460,200 489,723 949,923 1990 500,200 454,946 955,146 1991 535,200 417,086 952,286 1992 495,200 378,674 873,874 1993 487,700 342,706 830,406 1994 527,700 305,672 833,372 1995 567,700 265,200 832,900 1996 587,700 221,881 809,581 1997 634,900 174,764 .809,664 1998 344,900 137,520 482,420 1999 314,900 111,612 426,512 2000 324,900 85,602 410,502 2001 349,900 57,667 407,567 2,002 370,000 27,628 397,628 2003 70,000 10 ,500 80,500 2004 70,000 7,000 77 , 000 2005 70,000 3,500 73,500 $8.920,700 $7,040,071 $15,960.771 General obligation bonds Principal Interest Total $ 95,000 95,000 83,000 75,000 80,000 55,000 50,000 $ 32,693 26,432 20,030 14,785 9,678 4,326 1,400 $127,693 121,432 103,030 89,785 89,678 59,326 51,400 $533.000 $109.344 $642,344 Note - January 1 maturities are considered matured December 31, of the preceding year. ~ - ,:---- 1 I 1 I 1 1 I - I I -I -I - I -I I -I I cl I ; I 65 CITY OF ANDOVER, MINNESOTA TAX I,EVIES AND COLLECTIONS Percentage Collection Percentage Collection of total Current of current of levy of prior Total collections Year levy year's levy collected years' levy collections to levy 1980 $356,000 $344,318 96.72% $ 8,922 $353,240 99.22% 1981 460,600 . 443,597 96.31 12,030 455,627 98.92 1982 496,388 450,271 90.71 21,859 472,130 95.11 SPECIAL ASSESSMENT LEVIES AND COLLECTIONS Percentage Collection Percentage Collection of total Current of current of levy of prior Total collections Year levy year's levy collected year s' levy collections to levy 1980 $225,305 $194,693 86.41% $16,982 $211,675 93.95% 1981 339,487 310,834 91.56 8,577 319,411 94.09 1982 793,693 666,979 84.03 60,010 726,989 91.60 ~ c ~ m m m ~ m m m c c C ~! I C, I C' C ~ E, I r:-- --.l:.~- ~,~ I I I I I I I 1 1 1 I I I 1 1 1 I -I I 67 CITY OF ANDOVER, MINNESOTA ASSESSED VALUATIONS, TAX LEVIES AND MILL RATES (shown by year of tax co11ectibi1ity) 1980 1981 1982 1983 Assessed valuations $30,853,844 $34,565,632 $39,541,477 $44,071,159 Contribution to fiscal disparities pool ( 965,109) (1,360,707) (1,475,372) (1,543,109) Distribution from fiscal disparities pool 1,691 ,464 2,483,123 3,956,148 5,480,041 Taxable valuation $31.580.199 $35.686.048 $42.022.253 $48.008.091 Tax levies Revenue $ 295,119 $ 393,410 $ 433,380 $ 476,955 General obligation debt 60,551 63,707 61.313 93,056 Special assessment debt 330 3,483 258 $ 356.000 $ 460.600 $ 494.951 $ 570.011 Mill rates Revenue 9.423 11 .122 10.200 9.959 General obligation debt 1. 933 1. 801 1.444 1.943 Special assessment debt .011 .099 .006 11. 36 7 13.022 11.650 11. 902 ~ ~ c m ~ m ; m E m I I C I C ~ C E E --;