Loading...
HomeMy WebLinkAbout1983 CAFR I I I I I I I I I I I I I I I I I I I CITY OF ANDOVER, MINNESOTA FINANCIAL STATEMENTS DECEMBER 31, 1983 ~ c c ~ I: C D ~ ilIi ~ m m c c c c ~ ~ ~ m . ~ . .-h-. . --_.~ I I I I I I I I I I I I I I I I I I I Elected Mayor Jerry Windschit1 Council Theodore M. Lachinski Kenneth Orttel 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 1985 1985 1985 1987 1987 m w c C D C C C C ~ m m m m c 01 I Cl Ii ~ ~, i ~~~. -p " I CITY OF ANDOVER, MINNESOTA I TABLE OF CONTENTS I SECTION I I INTRODUCTORY SECTION I Comments SECTION II I FINANCIAL SECTION I Auditors' opinion 1 II-A. Combined Financial Statements (General Purpose Financial Statements) I Combined balance sheet - all fund types and account groups 2 Combined statement of revenue, expenditures and changes in fund balances - all governmental fund types 4 Combined statement of revenue, expenditures and changes in fund balances - budget and actual - General and special revenue fund types 6 Statement of revenue, expense and fund equity - all proprietary fund types - Enterprise funds 8 Statement of changes in financial position - all proprietary fund types - Enterprise funds 9 Notes to financial statements 10 I I I II-B. Combining and Individual Fund Statements and Account Groups I General Fund Comparative Statement of Statement of Statement of in fund balances I balance sheet revenue, expenditures and changes revenue, compared to budget expenditures, compared to budget I Special revenue funds Comparative balance sheet Statement of revenue, expenditures and changes in fund balances I Debt service funds Combining balance sheet Combining statement of revenue, expenditures and changes in fund balances I Capital projects funds Combining balance sheet Combining statement of revenue, expenditures and changes in fund balances I I I Page I 23 24 25 26 31 31 32 33 34 36 CITY OF ANDOVER, MINNESOTA TABLE OF CONTENTS (CONTINUED) II-B. Combining and Individual Fund Statements and Account Groups (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 assets Comparative statement of general long-term debt SECTION III STATISTICAL SECTION Schedule of cash, temporary investments and security for deposits Combined schedue1 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 --I' D m m Page ~ 38 c 42 47 48 50 51 ~ c 52 53 54 55 c D 56 57 58 59 ~ ~, 60 61 ~ m 63 64 66 70 71 71 73 ~ m m m c c I I I I I I I I I ,I I I I I I I I I I SECTION I INTRODUCTORY SECTION I I I I I I I I I I I I I I I I I I I ~ 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 counci1members. 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 $76,544 during the year to $292,692. A condensed summary of revenue and expenditures for the years ended December.31, 1983 and 1982 is shown below: 1983 1982 Budget Actual Budget Actual Revenue and other sources Taxes $330,605 $ 345,053 $261:,360 $270,555 ~icenses and permits 48,237 95,397 48,210 57,806 Intergovernmental revenue 386,868 456,578 349,571 295,615 Charges for'services 14,556 11,672 9,450 8,520 Fines and forfeits 11,100 6,726 10,000 9,883 Other revenue 29,785 121,817 141,288 100,193 Transfers from other funds 38,612 39,109 46,388 48,575 $859,763 $1,076,352 $866,267 $791,147 Expenditures and other uses General government Public safety Public works Sanitation Park and recreation Other una110cated Transfers to other funds $250,588 254,101 164,466 12,441 84,675 25,686 67,806 $859,763 $ 250,863 $253,322 $242,329 268,928 271,494 267,410 137,172 131,973 122,616 21,805 13,161 8,307 88,621 100,417 68,279 161,979 64,379 17,212 70,440 31,521 30,020 999,808 $866,267 $756,173 76.544_ S -o- S 34.974 $ Net increase in fund balance S S -0- Special Revenue Funds 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 the the Act. The City's share of revenue for 1983 was $38,511. During 1983, $39,109 was transferred to the General Fund. There was no fund balance at December 31, 1983. ~ m Debt Service Funds m 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 Uebt Account Group. ! ~ The funds included with the debt service funds are: m 1978 General Obligation Bonds 1979 Certificates-of Indebtedness 1980 Certificates of Indebtedness 1982 Certificates of Indebtedness c Capital pro;ects Funds c 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 $9,860 at December 31, 1983. ~ Park Fund - The Park Fund was established to account for revenue, primarily park deducation fees, to be used for the acquisition and improvement of parks. The fund balance was $40,241 at December 31, 1983. ~ 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, 1983 of $745 will be expended during 1984 for additional construction costs. D ~ 1982 Equipment Fund - This fund was established to account for the proceeds from sale of ~ $150,000 of certificates of indebtedness which were issued during 1982 for a fire .. truck and fire equipment. The fund balance was $5,773 at December 31, 1983. 1983 Equipment Fund - This fund was established to account for the proceeds from the -;: sale of $30,000 of certificates of indebtedness which were issued during 1983 for a rescue van. $29,500 of the balance has been reserved for equipment leaving an unreserved-undesignated fund balance of $982 at December 31, 1983. I: m II m -=~~I- ----.,---=---..........-...- I I I I I I I I I I I I I I I I I I I 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 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 benefit property owners and disbursements of assessment collections for the payment of bonds and interest. The December 31, 1983 fund balance (deficits) of the various special assessment funds were as follows: Fund Reserved for construction Unreserved undesignated Total - $( 506,471) 5,629 ( 287,295) ( 199 , 948) ( 139,271) ( 148,903) ( 306,369) ( 24,099) (2,346,131) ( 79,843) ( 102,765) ( 786,952) ( 156,989) $(5.079.407) The deficits arise primarily due to the accounting treatment of assessments receivable. Generally accepted accounting principles require that assessments receivable not be reflected as revenue until collected. III If the assessments receivable were recorded as revenue wheuassessed the fund balances (deficits) would be as follows: Rese rved for Reserved for Unreserved Fund construction debt service undesignated Total 75-1 $( 37,825) $( 37,825) 75-2 $ 1,794 16,443 18,237 76-1 370,365 370,365 77-1 136,515 136,515 78-1 19,365 19,365 79-1 19,703 19,703 79-2/80-1 11,117 11,117 80-2 18,135 18,135 80-3, 4/82-7 430,395 430,395 81-1 12,009 12,009 81-2 31,014 31,014 83-2, 2A, 3 $ 41,391 ( 828,343) ( 786,952) 83- 5, 6, 8 23,803 21,082 44,885 $ 65.194 $1.071.494 $( 849.725) $ 286.963 Assessment rolls have not been adopted for the 83-2, 2A, 3 improvements. The assessment of these improvement costs should eliminate the above deficit. Reserved for debt service 75-1 75-2 76-1 77-1 78-1 79-1 79-2/80-1 80-2 80-3, 4/82-7 81-1 81-2 83-2, 2A, 3 83-5, 6, 8 $( 506,471) $ 5,629 (287,295) ( 199,948) ( 139,271) ( 148,903) ( 306,369) ( 24,099) (2,346,131) ( 79,843) ( 102,765) ( 828,343) ( 180,792) $(5.150.230) $ 41,391 23,803 65.194 $ $ 5.629 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. \ ~. I I I I I 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 furing 1981, a condensed summary of operations for 1983 and 1982 is as follows: Operating revenue Operating expense (excluding Depreciation Operating income Other income (expense) Net loss 1983 $ deprec ia t ion) $ 28,413 26,472 1,941 16,151 $(14,210) ( 6,420) $(20.630) 1982 $ 42,282 37,611 $ 4,671 16,125 $ (11 ,454) 919 $<10.535) A condensed summary of Sewer Fund operations for 1983 and 1982 is as follows: Operating revenue Operating expense (excluding Depreciation Operating loss Other income (expense) Net loss General Fixed Assets 1983 $ depreciation) $ 94,963 92,623 2,340 83,630 $(81,290). 13,598 $(67.692) 1982 $ 81,456 97,138 $(15,682) 83,611 $(99,293) 1,118 $(98.175) 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, 1983, the general fixed assets of the City amounted to $1,128,215. '~-I - , IV I I E I ! ~ E E E I E ~ E --------~~ I General Long-term Debt I I I I 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, 1983 were as follows: 1978 G.O. Bonds 1979 Certificates of Indebtedness 1980 Certificates of Indebtedness 1982 Certificates of Indebtedness 1983 Certificates of Indebtedness Land Acquisition Long-term payable - Metropolitan Waste Control Commission Assessments on City property Equipment purchase Vacation payable - Governmental funds I I I I I I I I I I I I I I V Original amount Outstanding December 31, 1983 $430,000 85,000 40,000 150,000 30,000 44,000 $285,000 17,000 16,000 120,000 30,000 44,000 43,018 111,653 10,115 26,442 98,972 7,289 6,268 $650.971 D' " f-' ,,," m c c c ~ c C E C ~ ~ ~ ~ ~ ~ m m e --~~-- !-- --+- -,--,,--- "'I 'I I I I I I I I I I I I I I I I I I SECTION II FlNANCIAL SECTION I I I I I I I I I I I I I I I I I I I GMHCo GEORGE M. HANSEN COMPANY, P.A. A Profe.u;onaJ Corporation o/Certified PuhJ;c An.oumanu 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, 1983, 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 statemenm referred to above present fairly the financial position of the City of Andover, Minnesota at December 31, 1983, 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 after restatement for the changes with which we concur, in the method of accounting for special assessments and correction of enterprise fund expenses (See Note 2). Our examination was made for the purpose of forming an op~n~on 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. ~ 7r/ 1~ ~/ //1. March 20, 1984 1 75 SOUTH PLAZA BUILDING WA YZA T A BOULEVARD AT HIGHWAY 100 MINNEAPOLIS. MINNESOTA 5541 6 612/546-2566 2 CITY OF ANDOVER, MINNESOTA COMBINED BALANCE SHEET ALL FUND TYPES AND ACCOUNT GROUPS DECEMBER 31, 1983 ASSETS Petty cash Cash and temporary investments Accrued interest receivable Taxes receivable Unremitted Delinquent Accounts receivable Prepaid expense Special assessments receivable Unremitted Delinquent Deferred Allowance for uncollected receivables 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 LIABILITIES AND FUND EQUITY Liabilities Cash deficit Accounts payable Accrued liabilities Contracts payable Due to other funds Due to other governmental units Deposits payable Deferred revenue Bonds payable Total liabilities Fund equity Contributed Invested in General Fixed Assets Retained earnings Reserved Unreserved Fund balance Reserved Unreserved - Undesignated Total fund equity Total liabilities and fund equity See accompanying notes to financial statements. t 1-'- Governmental Special General revenue $ 300 420,364 2,520 2,719 28,158 514 1,232 (28,158) 890 $428.539 $ $ 9.436 2,144 2,052 53,349 68,866 $135,847 m [D Fund Types Debt service ._0.. c $ 96.300 799 c 322 3,693 c ( 3.693) .~ C c c -0- $ 97.421 ~ D ~ W m m c $ 97,421 $292,692 $292,692 $ -0- $ 97,421 $428.539 $9 -0- $ 97,421 ~ c 3 Account Groups Total Proprietary General General (memorandum only) Capital Special Fund Types Fixed Long -term 1982 projects assessment Enterprise Assets Debt 1983 Restated $ 300 $ 150 $ 78,841 $ 4,768,520 $ 6,484 5,370,509 4,834,721 615 39,847 278 44,059 26,212 21 3,062 2,494 147 31,998 30,635 32,170 32,684 23,676 7,267 7,267 8 5,394 5,394 6,368 137,238 279 137,517 126 ' 5,229,132 25,074 5 5,678,758 ( 137,385) ( 169,236) ( 156,973) 200,000 200,000 71,081 ' 116,972 117,862 2 5,517 5,517 2,250 4,188,203 $1,128,215 5,316,418 5,223,116 ' $ 97,421 97,421 89,576 553,550 553,550 578,366 I $196,428 $10,242,914 $4,265,272 $1,128,215 650 971 $17,009.760 $16,547,227 ' $ 91,548 $ 4,590 $ 96,138 $ 1,329 1,860 $ 8,936 6,062 $ 98,972 125,266 115,799 ' 694 6,268 6,962 4,523 15,919 66,243 51,289 135,595 25,802 200,000 200,000 71,081 46 26,442 28,540 41,852 182,229 235,578 198,940 5,249,013 25,353 5,343,232 5,753,072 9,615,900 468 10,083,900 9,453,700 $109,327 $15,322,321 $ 36,745 $650,971 $16,255,211 $15,666,098 $4,184,018 $ 4,184,018 $ 4,283,295 1 $1,128,215 1,128,215 935,706 2,500 2,500 ' 42,009 42,009 33,554 $ 30,245 $ 70,823 198,489 335,569 56,856 (5,150,230 (4,800,682 (4,706,995 ' $ 87,101 $(5,079,407 $4,228,527 $1,128,215 $ 754,549 $ 881,129 $196,428 $10,242,914 $4,265,272 $1,128,215 650 971 $17,009,760 $16,547,227 4 CITY OF ANDOVER, MINNESarA COMBINED STATEMENT OF m REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCES ALL GOVERNMENTAL FUND TYPES YEAR ENDED DECEMBER 31, 1983 m Revenue Taxes Licenses and permits Intergovernmental revenue Special assessments levied Charges for services Fines and forfeits Interest Other Park dedication fees Total revenue Other sources Transfers from other funds Bond proceeds Total revenue and other sources Expenditures General government Publ ic safety Public works Sanitation Recreation Other una110cated Capital projects Debt service Total expenditures Other uses Transfers to other funds Total expenditures and other uses Net increase (decrease) in fund balance Fund balance January 1, before adjustment $ Adjustment to restate assessment revenue - See Note 2 Fund balance (deficit) January 1, as restated $ Fund balance (deficit) December 31 $ See accompanying notes to financial statements. -~- ~' -t-'- General $ 345,053 95,397 456,578 11,672 6,726 121,817 $ 1,037,243 39,109 $ 1,076,352 $ 250,863 268,928 137,172 21,805 88,621 161,979 $ 929,368 70,440 $ 999,808 $ 76,544 216,148 216,148 292.692 Special revenue m ~ c $ 38,511 ~ 563 ~ C $ 39,074 $ ~ C ~ ~ 39,074 $ 11 $ 11 ~ ~ $ 39,109 39,120 $( $ 46) 46 ~ C $ 46 $ -0- ~ E m A 5 ' Total (memorandum only) A Debt Capital Special 1982 service projects assessment 1983 Restated A $ 38,686 $ 2,746 $ 386,485 $ 309,265 95,397 57,806 20,323 $ 308,088 1 824,993 650,072 1,146,144 1 1,220,633 11,672 8,520 A 6,726 9,883 5,926 18,515 354,672 379,676 455,448 213 182 6,115 128. 109,651 11,170 11,170 13,610 A $ 65,148 $ 337,955 $ 1,511,170 $ 2,990,590 $ 2,834,888 A 70,440 7,500 - 117 2 049 78,595 30,000 30,000 150,000 $ 135,588 $ 367,955 $ 1,518,670 $ 3,137,639 $ 3,063,483 , 1 $ 250 $ 242,329 268,928 267,410 1 137,172 122,616 21,805 8,307 88,621 68,279 1 161,990 17,212 $ 547,446 $ 986,962 1,534,408 450,263 $ 127,743 655 783,090 759,615 $ 127,743 $ 547,446 $ 1,642,309 $ 3,246,877 $ 1,936,031 11,980 121 78,595 A $ 127,743 $ 547,446 $ 1,654,289 $ 3,368,406 $ 2,014,626 $ 7,845 $( 179,491 $( 135,619 $( 230,767 $ 1,048,857 A $ 89,576 $ 266,592 $ 860,034 $ 1,432,396 $ 776,155 (5,803,822) (5,803,822 (6,196,438 1 $ 89,576 $ 266,592 $(4,943,788 $(4,371,426 $(5,420,283 A $ 97,421 S 87.101 $(5,079,407 $ (4,602.193 $(4.371,426 A 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, 1983 Revenue Taxes Licenses and permits Intergovernmental revenue Charges for services Fines and forfeits Other General Budget Actual $' 330,605 $ 345,053 48,237 95,397 386,868 456,578 14,556 11,672 11 ,100 6,726 29,785 121,817 $ 821,151 $1,037,243 38,612 39,109 $ 859.763 $1,076,352 $ 250,588 $ 250,863 254,101 268,928 164,466 137,172 12,441 21,805 84,675 88,621 25,686 161,979 $ 791,957 $ 929,368 67,806 70,440 $ 859,763 $ 999,808 $ -0- $ 76,544 216,148 $ 292.692 Total revenue Other sources Transfers from other funds Total revenue and other sources Expenditures General government Public safety Public works Sanitation Recreation Other unall ocated Total expenditures Other uses Transfers to other funds Total expenditures and other uses Net increase (decrease) in fund balance Fund balance January 1 Fund balance December'3l See accompanying notes to financial statements. ~'--I-'~ '" m w m c ~ ~ ~ C D ~ ~ C ~ E m m m E m 7 Total Special revenue (memorandum only) Budget Actual Budget Actual $ 330,605 $ 345,053 ' 48,237 95,397 $ 38,612 $ 38,511 425,480 495,089 14,556 11,672 I 11,100 6,726 563 29,785 122 $ 36,612 $ 39 $ 859,763 $1,076,317 38,612 39,109 ' $ 38,612 $ 39,074 $ 898,375 $1,115,42 6 $ 250,588 $ 250,863 254,101 268,928 164,466 137,172 12,441 21,805 84,675 88,621 $ 11 25,686 161,990 $ 11 $ 791,957 $ 929,379 $ 38,612 39,109 106,418 109,549 $ 38,612 $ 39,120 $ 898,375 $1,038,928 $ -0- $( 46) $ -0- $ 76,498 ' 46 216,194 $ -0- $ 292,692 1 8 CITY OF ANDOVER, MINNESOTA STATEMENT OF REVENUE, EXPENSE AND FUND EQUITY ALL PROPRIETARY FUND TYPES - ENTERPRISE FUNDS YEAR ENDED DECEMBER 31, 1983 Operating revenue User charges Connection charges Meters Penalties Other Operating expense (excluding depreciation) Personal services Supplies Other services and charges Disposal charges Operating income (loss) before depreciation Less depreciation On assets acquired with own funds On assets acquired from contributions Operating income (loss) Other income (expense) Interest Transfer to special assessment funds Transfer from special assessment funds Net income (loss) Fund equity January 1, before adjustment Adjustment to restate 1982 expense - See Note 2 Fund equity January 1, as restated Fund equity December 31 See accompanying notes to financial statements. I" <~ Totals m m m ~ c ~ m ~ E C ~ ~ ~ ~ C ~ ~ E ~ 1983 1982 Restated $ 101,825 18,493 1,300 1,473 285 $ 123,376 $ 27,987 6,274 16,681 68,153 $ 119,095 $ 4,281 $ 504 99,277 $ 99,781 $( 95,500) $ 2,698 ( 7,500) 11 , 980 $ 7,178 $( 88,322) $4,308,775 8,074 $4,316,849 $4.228.527 $ 75,318 42,899 3,795 1,726 $ 123,738 $ 33,213 8,318 16,825 76,393 $ 134,749 $( 11,011) $ 459 99,277 $ 99,736 $( 110,747) $ 2,037 $ 2,037 $( 108,710) $4,425,559 $4,425,559 $4.316.849 I I I I I I I I I I I I I I I I I I I 9 CITY OF ANDOVER, MINNESOTA STATEMENT OF CHANGES IN FINANCIAL POSITION ALL PROPRIETARY FUND TYPES - ENTERPRISE FUNDS YEAR ENDED DECEMBER 31, 1983 Totals 1983 1982 Restated Sources of working capital Operations Net loss Item not requ~r~ng working capital Depreciation $( 88,322) $(108,710) 99,781 99,736 $ 11,459 $( 8,974) 25,353 30,460 $ 36,812 $ 21,486 $ 574 $ 225 24,828 30,460 $ 25,402 $ 30,685 $ 11.410 $( 9 .199) Increase in deferred revenue Decrease in other assets Uses of working capital Acquisition of property and equipment Increase in other assets Decrease in deferred revenue Increase (decrease) in working capital Elements of change in working capital Cash and temporary investments Accrued interest receivable Accounts receivable Special assessment receivable Prepaid expenses Due to other funds Inventory Accounts payable Due to other governmental units Accrued expenses $( 9,152) $( 2,369) ( 230) 508 8,582 4,004 525 ( 807) 8,074 8,074 ( 8,074) 3,267 ( 3,635) ( 5,194) ( 1,130) 6,320 ( 6,366) 25 ( 211) $ 11.410 $( 9 .199) Increase (decrease) in working capital See accompanying notes to financial statements. 10 m CITY OF ANDOVER, MINNESOTA NOTES TO FINANCIAL STATEMENTS DECEMBER 31, 1983 ~ ~ m Note 1 - Summary of Significant Accounting Policies 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 public and c E The financial statements included in the report cover all commissions, borads, authorities, and bodies that are dependent on or controlled by the City's executive and legislative branches. The criteria used to determine the financial reporting entity were in conformance with NCGA Statement 3, Defining the Governmental Reporting Entity. c 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. Fund Accounting ~ 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 expenditures, 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: ~ ~ E 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. ~ Special revenue funds - Special revenue funds are used to account for the proceeds of specific revenue sources that are restricted to expenditures for specified purposes. c Debt service funds - Debt service funds are used to account for the accumulation of resources for, and the payment of, general long-term debt principal, interest and related costs. ~ ~ 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. ~ 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. ~ ~ - I .,.- I 11 I CITY OF ANDOVER, MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1983 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 Fixed assets used in governmental fund types operations (general fixed assets) are accounted for in the General Fixed Assets Accounts 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 I 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 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 ~ CITY OF ANDOVER, MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1983 ~ ~ Note 1 - Summary of Significant Accounting Policies (Continued) B. Measurement Focus (Continued) ~ All proprietary funds are accounted for on a cos t of services or'. "capital ~ maintenanc~' 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 I increases(revenues) and decreases (expenses) in net total assets. C. Basis of Accounting I Basis of 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. I 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. E 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. E E The following transactions are accounted for as described below: 1. General property taxes - Revenue is recognized in the year of anticipated collection, with amounts due from the County and received early in the following year included as revenue. Allowances are provided for the full amount of delinquent taxes receivable. This has the full effect of recognizing general property taxes as revenue when cash is received because of the unavailability of the delinquent taxes. E E c 2. Special assessments - Revenue of the governmental funds is recognized in the year of anticipated collection, with amounts due from the County and received early in the following year included as revenue. Allowances are provided for the full amount of delinquent assessments receivable. This has the effect of recognizing assessment revenue when cash is received because of the unavailability of the delinquent assessments. ~ E E I 13 I CITY OF ANDOVER, MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1983 I I Note 1 - Summary of Significant Accounting Policies (Continued) C. Basis of Accounting (Continued) I 3. Interest expense on bonded indebtedness - Interest expense is recorded as an expenditure when paid in the governmental fund types and accrued as incurred in the proprietary fund types. I 4. Bond and interest payments due January 1 - Expenditures are recognized when amounts are remitted to the paying agent (usually in December) for payment of bonds and interest. I 5. Unbilled Sewer and Water Fund utility service receivables are recorded at year end. I 6. Unpaid vacation and severance pay are accrued as liabilities on the fund statements in accordance with NCGA Statement No.4. I D. Budgets and Budgetary Accounting I The City follows these procedures in establishing the budgetary data reflected in the financial statements: I 1. Prior to January 1, the budget is adopted by the City Council. I 2. Formal budgetary integration is employed as a management control device during the year for the General and Special Revenue funds. Formal budetaDY integration is not employed for other funds. I 3. Budgets for the Genera1and Special Revenue funds, are adopted on a basis consistent with generally accepted accounting principles. 4. Budgeted amounts are as originally adopted, or as amended. I 5. Budget appropriations lapse at year end. 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 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 expenses when purchased. I I 14 c CITY OF ANDOVER, MINNESOTA ~ NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1983 ~ Note 1 - Summary of Significant Accounting Policies (Continued) E. Assets and Liabilities (Continued) m 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. ~ 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: m ~ m Collection and distribution systems Machinery Furniture and equipment 50 years 20 years 3-15 years m Accrued liabilities - The accrued liabilities include unpaid vacation pay for all City employees. Expense is recognized when the liability is incurred in the proprietary fund types. The liability for the governmental funds is recorded in the General Long-term Account Group. ; F. Total Columns on Combined Statements - Overview ; Total columns on the combined statements - overview are captioned memorandum ~ only 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 account- ing principles. Neither is such data comparable to a consolidation. Interfund ~ eliminations have not been made in the aggregation of these data. .. G. Comparative Data ~ Comparative data for the prior year has been presented to provide an standing of changes in the City's financial position and operation. 1982 amounts have been restated to conform to the 1983 presentation. under- Certain I m m ~ ; '"~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, 1983 Note 2 - Accounting Changes Special Assessments In 1983, the City changes its method of accounting for special assessment revenues in order to comply with National Council on Governmental Accounting (NCGA) Statement No.1. Whereas previously the total principal amounts of the special assessments were recognized as revenue when the assessments were levied, revenue recognition for special assessments will now be identical to that of other governmental fund revenues which are recognized when they become measurable and available. Accordingly, special assessment principal and interest will be recognized as revenue in the year they become due for collection and allowances for doubtful receivables will be set up for all delinquent special assessments receivable at the balance sheet date. Principal amounts of special assessments not yet due for collection will be shown as deferred revenue in the balance sheet. Financial statements for 1982 have been restated to apply this change retroactively. The effect of the accounting change is to increase special assessment net revenue in 1983 by $626,898 and to increase previously reported special assessment net revenue for 1982 by $392,616. the special assessment fund balances at December 31, 1981 and 1982 have been adjusted for the effect of applying retroactively the new method of accounting. Enterprise Funds The 1982 financial statements for the enterprise funds have been restated to reflect the correction of a prior year's error. The effect of this adjustment is to reduce expense, increase net income, and increase the fund balance for 1982 by $8,074. Note 3 -Expenditures in Excess of Appropriations Expenditures of the General Fund exceeded the budget by $140,045. Revenues were in excess of the budget estimate by $216,589. Expenditures of the Special Revenue Fund-Revenue Sharing Fund exceeded the budget by $508. Revenues were in excess of the budget estimate by $462. 16 CITY OF ANDOVER, MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1983 Note 4 - Fund Deficits Special Assessmen t Funds Total - ~,. II.J' c m ~ ~ ~ ~ ~ ~ C I C m m c c ~ E '~ The December 31, 1983 fund balance (deficit) of the various special assessment funds were as follows: Fund 75-1 75-2 76-1 77-1 78-1 79-1 79-2/80-1 80-2 80-3, 4/82-7 81-1 81-2 83-2, 2A, 3 83- 5, 6, 8 Reserved for debt service Reserved for construction Unreserved undesignated $( 506,471) ( 287,295) ( 199,948) ( 139,271)' ( 148,903) ( 306,369) ( 24,099) (2,346,131) ( 79,843) ( 102,765) ( 828,343) ( 180,792) $(5.150.230) $ ( 506,471) 5,629 ( 287,295) ( 199,948) ( 139,271) ( 148,903) ( 306,369) ( 24,099) (2,346,131) ( 79,843) ( 102,765) ( 786,952) ( 156,989) $ (5.079 .407) The deficits arise primarily due to the accounting treatment of assessments receivable. Generally accepted accoujting principles require that the assessment receivable not be reflected as revenue until collected. $ 5,629 $ 41,391 23,803 65.194 $ $ 5.629 Note 5 - Due from Other Governmental Units The amounts due from other governmental units at December 31, 1983 is composed of the following: .~I-~ ..~ General Fund Anoka County Capital projects Park Fund - Park grant State Aid Fund - Construction aid $ 890 6,900 110,072 $117.862 .1 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, 1983 Note 6 - Proprietary Fund Types Property and Equipment A summary of proprietary fund types property and equipment at December 31, 1983 follows: Water Sewer - Total Furniture and equipment Machinery Collection and distribution systems $ 2,050 190,832 $ 3,366 $ 5,416 190,832 Less accumulated depreciation 321,112 $513,994 40,340 $473.654 4,165,666 $4,169,032 454,483 $3.714.549 4,486,778 $4,683,026 494,823 $4.188.203 Note 7 - Changes in General Fixed Assets A summary of changes in general fixed assets during the year follows: Balance Balance January 1 Additions Disposals December 31 Land and improvements $ 95,881 $ 2,222 $ 98,103 Buildings and improvements 408,432 155,714 564,146 Furniture and equipment 62,492 15,716 78,208 Machinery and automotive equipment 368,901 18,857 387,758 Total $935.706 $192.509 $ -0- $1.128.215 Note 8 - Long-term Debt The following is a summary of bond transactions of the City for the year ended December 31, 1983: General Special obligation assessment Total Bonds payable at January 1 $533,000 $8,920,700 $ 9,453,700 New bonds issued 30,000 1,015,000 1,045,000 Bonds retired (95,000) ( 319,800) ( 414,800) Bonds payable at December 31 $468.000 $9.615.900 $10.083.900 18 CITY OF ANDOVER, MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1983 Note 8 - Long-term Debt (Continued) Bonds payable at December 31, 1983 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% $ 285,000 $85,000 1979 Certificate of Indebtedness due in annual install- ments of $17,000 through August 1, 1984; interest at 6.00% $40,000 1980 Certificate of Indebtedness due in annual install- ments of $8,000 through April 1, 1985; interest at 7.00% $150,000 Certificates of Indebtedness due in annual install- ments of $30,000 through December 31, 1987; interest at 8.00% $30,000 Certificates of Indebtedness due in annual install- ments of $6,000 through October 1, 1988; interest at 7.50% Special assessment bonds: 17,000 16,000 120,000 30,000 $ 468.000 $46,000 Improvement Bonds of 1975 due in annual installments of $4,600 through September 1, 1986; interest at 6.50% $ 13,800 $1,635,000 General Obligation Improvement Bonds of 1976 due in varying annual installments through February 1, 1997; interest at 6.50% to 6.80% $56,000 Improvement Bonds of 1976 due in annual installments of $2,800 through November 1, 1996; interest at 5.50% to 6.75% $1,215,000 General Obligation Improvement Bonds of 1977 due in varying annual installments through January 1, 2006, interest at 5.00% $780,000 General Obligation Improvement Bonds of 1977 due in varying annual installments through February 1, 1998; interest at 5.25% to 5.50% $270,000 General Obligation Improvement Bonds of 1978 due in varying annual installments through February 1, 1999; interest at 5.50% to 6.00% $270,000 General Obligation Improvement Bonds of 1979 due in varying annual installments through February 1, 1995; interest at 6.50% ,~ t 1,325,000 36,400 1,085,000 665,000 235,000 240,000 ~ ~ c ~ ~ ~ ~ E ! C ~ ~ c ~ ~ C ~ ~ ~ I I I I I I I I 11 ~ 1 I I I I I I I I I I CITY OF ANDOVER, MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1983 Note 8 - Long-term Debt (Continued) Special assessment bonds (continued): 19 $430,000 General Obligation Improvement Bonds of 1980 due in varying annual installments through February 1, 1991; interest at 6.20% to 6.90% $ 375,000 $98,000 General Obligation Bonds of 1980 due in annual install- ments of $4,900 through February 1, 2001; interest at 7.00% 88,200 $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% $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% $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% $1,015,000 General Obligation Improvement Bonds of 1983 due October 1, 1986; interest at 7.00% 4,260,000 120,000 157,500 1,015,000 $9.615.900 The annual requirements to amortize all debt outstanding as of December 31, 1983, including interest payments of $6,681,939 are as follows: Year ending December 31 Special assessment General obligation 1984 1985 1986 1987 1988 1989-1993 1994-1998 1999-2003 2004-2005 $ 1,027,279 1,027,878 2,046,604 952,547 957,349 4,561,635 3,767,937 1,722,709 150,500 $16.214.438 $ 129,682 110,830 97,135 96,578 65,776 51,400 $ 551.401 Total $ 1,156,961 1,138, 708 2,143,739 1,049,125 1,023,125 4,613,035 3,767,937 1,722,709 150,500 $16.765.839 20 CITY OF ANDOVER, MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1983 Note 8 - Long-term Debt (Continued) $97,421 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 9 - Long-term Payab1es Included in the General Long-term Debt Account Group are the following long-term payables: 1. Payable of $26,442 to the Metropolitan Waste Control Commission, with interest at 5.369% per annum. Year Principal Interest Total 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 3,550 750 4,300 1989-1991 10,409. 1,063 11,472 $ 26.442 $ 6.530 $ 32 .972 2. Installment contract of $7,289 for equipment purchase with interest at 18.57% per annum. Year Principal Interest Total 1984 $ 1,923 $ 1,197 $ 3,120 1985 2,313 807 3,120 1986 2,797 323 3,120 1987 256 4 260 $ 7,289 $ 2.331 $ 9.620 3. Special assessments on City property of $98,972 is payable in varying amounts at annual interest rates of 6.25% to 10.7% through 2001. 4. Contract for land acquisition of $44,000 payable in equal installments of $22,000 in 1984 and 1985 with interest at 9.00% per annum. Note 10 - Interfund Receivables/Payab1es Interfund receivable/payable balances at December 31, 1983 were as follows: Receivable Payable Special assessment funds $200,000 $200,000 I' ~ ~ c ,~ ~ m ~ ~ C c ~ ~ ~ CI c ~' Ii C' c ~, I I I I I I I I I I I I I I I I I I I I 21 CITY OF ANDOVER, MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1983 Note 11 - Retirement Plan The City participates in a State-wide contributory pension plan under the Public Employees' Retirment 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 $11,844 for the year ended December 31, 1983. 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. Note 12 - Segment Information for Enterprise Funds Segment information for the City's two enterprise funds for the year ended December 31, 1983 is as follows: Water Sewer Total - Operating revenue $ 28,413 $ 94,963 $ 123,376 Depreciation and amoritization 16,151 83,630 99,781 Operating loss ( 14,210) ( 81,290) ( 95,500) Net loss ( 20,630) ( 67,692) ( 88,322) Property, plant and equipment Additions 486 88 574 Net working capital 10,151 30,698 40.849 Total assets 487,646 3,777.626 4,265,272 Equity Contributed 472,034 3,711.984 4,184,018 Retained earnings Rese rved 2,500 2,500 Unreserved 9,271 32,738 42,009 Note 13 - Reserved Fund Equity The following reservations have been made of various fund balances at December 31, 1983: Enterprise funds - For equipment replacement $ 2.500 Debt service funds - For debt service Capital projects funds For equipment For construction Special assessment funds For construction For debt service $ 97,421 29,500 745 65,194 5,629 $198.489 22 CITY OF ANDOVER, MINNESOTA NOTES TO FINANCIAL STATEMENTS (CONTINUED) DECEMBER 31, 1983 Note 14 - Deficiency in Pledged Collateral Minnesota Statutes require depositories for City funds to pledge collateral to secure balances in excess of F.D.I.C. 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, 1983 the collateral pledged by First National Bank of Anoka was approximately $275,000 below the statutory requirement. Note 15 - Contingent Liabilities The City participates in a number of federally assisted grant programs, principal ~f which are the General Revenue Sharing and Community Development Block Grant Programs. The programs are subject to program compliance audits by the grantors or their representatives. The program compliance audits for the year ended December 31, 1983 have not been conducted. Accordingly, the City's compliance with applicable grant requirements will be established at some future date, if there is a program compliance audit. The amount, if any, of expenditures which may be disallowed by the granting agencies cannot be determined at this time although the City expects such amounts, if any, to be immaterial. I --- m I c ~ ~ ~ ~ ; c c c ~ ~ ~ mi ~I ~ ; ~ I I I I I I I I I I I I I I I I I I I CITY OF ANDOVER, MINNESOTA GENERAL FUND COMPARATIVE BALANCE SHEET DECEMBER 31, 1983 AND 1982 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 Contracts payable Deposits Deferred revenue Fund balance Reserved Unreserved - Undesignated Total liabilities and fund balance 1983 23 1982 $ 300 $ 150 420,364 348,477 2,520 1,174 2,719 2,172 28,158 26,606 (28,158) (26,606) 514 88 1 ,232 1,272 9,157 890 2,387 $428.539 $364.877 $ 9,436 2,052 2,144 53,349 68,866 $135,847 $292,692 $292,692 $428.539 $ 18,617 6,311 48,215 75,586 $148,729 $ 5,800 210,348 $216,148 $364.877 24 ~ c c ~ c c ~ ~ ~ ~ E E m m c c ~ c c CITY OF ANDOVER, MINNESOTA GENERAL FUND STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCES YEAR ENDED DECEMBER 31, 1983 (with comparative actual amounts for year ended December 31, 1982) -. I -~- 25 ' CITY OF ANDOVER, MINNESOTA ' GENERAL FUND STATEMENT OF REVENUE COMPARED TO BUDGET YEAR ENDED DECEMBER 31 1983 ' (with comparative actual amounts for year ended December 31, 1982) ' 1983 1982 Budge Actual Actual I Taxes General property taxes $ 329,305 $ 331,490 $ 268 Penalties and interest 1,300 13,563 1,641 ' $ 330,605 $ 345,053 $ 270,555 Licenses and permits Business $ 6,685 $ 14,537 $ 8,996 Non - business 41,552 80,860 48,810 $ 48,237 $ 95,397 $ 57,806 Intergovernmental Local governmental aid $ 125,669 $ 125,669 $ 109,007 State credits 232,284 176,733 143,488 0 CDBG 122,128 State highway aid 18,500 19,200 17,445 Park grants 12,900 Insurance premium tax 10,415 12,848 12,775 $ 386,868 $ 456,578 $ 295,615 Charges for services General government $ 5,048 $ 8,997 $ 4,528 Public safety 2,000 900 1,392 Sanitation 3,000 1,775 2,600 ' $ 10,048 $ 11,672 $ 8,520 Fines and forfeits $ 11,100 $ 6,726 $ 9,883 Other Assessments $ 843 Interest on investments $ 8,000 $ 26,410 17,486 Reimbursement from improvement projects Administrative charges 4,508 4,508 4,488 Other 10,000 1,334 6,776 Miscellaneous 2,660 2 1,617 Insurance claim settlement 32,352 Refunds and reimbursements 13,789 19,463 ' Revenue collected for other agencies 3,000 25,455 46,832 Escrow 6,125 15,947 2,688 $ 34,293 $ 121,817 $ 100,193 Total revenue $ 821,151 $1,037,243 $ 742,572 Other sources ' Transfers from other funds Revenue Sharing Fund 38,612 39,109 48,575 Total revenue and other sources S 859,763 $1,076,352 $ 791,147 26 .~ CITY OF ANDOVER, MINNESOTA GENERAL FUND I STATEMENT OF EXPENDITURES. COMPARED TO BUDGET YEAR ENDED DECEMBER 31, 1983 (with comparative actual amounts for year ended December 31, 1982) E 1983 1982 E Budget Actual Actual General government C Council Personal services $ 11 ,402 $ 10,980 $ 11 ,639 Other services and charges 6,480 5,078 6,114 ~ $ 17,882 $ 16,058 $ 17,753 Mayor m Personal services $ 2,910. $ 2,881 $ 2,561 Other services and charges 100 126 $ 3,0.10 $ 3,00.7 $ 2,561 ~ Elections Personal services $ 5,943 Supplies $ 50 532 ~ Other services and charges 496 Capital outlay 1,953 $ 50 $ 8,924 I Administrative Personal services $ 36,999 $ 32,683 $ 49,738 Supplies 880 990 1,387 m Other services and charges 1,490 1,351 2,203 .Capita1 outlay 1,400 2,119 885 $ 40,769 $ 37,143 $ 54,213 C Financial administration Personal services $ 6,509 $ 6,508 C Supplies 18 Other services and charges 100 380 $ 6,609 $ 6,906 ~ I , Accounting I Personal services $ 17,595 $ 18,097 I Supplies 215 981 C Other services and charges 410 310 Capital outlay 200 245 $ 18,420 $ 19,633 ~ Assessing Other services and charges $ 17 ,000 $ 16,142 $ 15,715 ~ ~ ~ ,- --- --.- CITY OF ANDOVER, MINNESOTA 27 ' GENERAL FUND STATEMENT OF EXPENDITURES COMPARED TO BUDGET (CONTINUED YEAR ENDED DECEMBER 31, 1983 (with comparative actual amounts for year ended December 31, 1982) ' 1983 1982 Budget Actual Actual General government (continued) Consulting staff Auditing $ 6,600 $ 7 $ 10,600 Legal 18,550 19,844 16,189 $ 25,150 $ 27,294 $ 26,789 ' Planning and zoning Personal services $ 10,431 $ 10,500 $ 9,532 Supplies 1,540 1,280 1,658 ' Other services and charges 2,145 6,985 3,699 Capital outlay 1,450 1 1,180 Other 300 358 490 $ 15,866 $ 20,371 16,559 ' Buildings Administration building ' Personal services $ 1,500 $ 2,382 $ 714 Supplies 5,225 6,107 2,996 Other services and charges 7,900 9,882 8,506 Capital outlay 1,000 727 496 $ 15,625 $ 19,098 $ 12,712 Fire Department building ' Supplies $ 4,460 $ 2,933 $ 2,226 Other services and charges 4 3,935 4,013 Capital outlay 4,000 5,597 5,235 ' $ 13,360 $ 12,465 $ 11,474 Public Works building Personal services $ 2,248 $ 6,039 $ 1,861 Supplies 6,325 3,338 2,251 Other services and charges 3,600 4,174 4,154 Capital outlay 2,700 3,186 4,960 $ 14,873 $ 16,737 $ 13,226 Senior citizen center ' Personal services $ 158 Supplies $ 1,100 Other services and changes 1,700 902 Capital outlay 1,500 2,515 $ 4,300 $ 3,575 Total buildings $ 4$,158 $ 51,875 $ 37,412 28 CITY OF ANDOVER, MINNESOTA GENERAL FUND STATEMENT OF EXPENDITURES, COMPARED TO BUDGET (CONTINUED YEAR ENDED DECEMBER 31, 1983 (with comparative actual amounts for year ended December 31, 1982) 1983 1982 Budget Actual Actual General government (continued) Engineering - Staff Personal services $ 40,209 $ 39,678 $ 38,603 Supplies 2 1 2,200 Other services and charges 1,630 1,072 1,122 Capital outlay 8,600 8,486 379 53,174 $ 51,025 $ 42 Engineering - Consultant Other services and charges $ 4,500 $ 1,409 $ 11 Total general government $250,588 $250,863 $233,484 Public safety Police protection Other services and charges $122,437 $119,828 $109,785 Capital outlay 403 $122,437 $120,231 $109,785 Fire protection Personal services $ 31,810 $ 20 $ 22,645 Q Supplies 7,075 10,941 8,865 Other services and charges 15,323 15,273 15,142 Relief Association 15,415 16,598 18,025 Capital outlay 9,305 10,404 7,408 $ 78,928 $ 73,582 $ 72 Protective inspection Personal services $ 27,476 $ 28,773 $ 29,965 Supplies 2,110 2,866 2,135 Other services and charges 1,400 1,204 1,035 Capital outlay 300 934 295 SAC and surcharges 2,880 24 40,572 Other 300 182 6,605 $ 34,466 $ 58,773 $ 80,607 Rescue service a Personal services $ 6,120 $ 5,725 Supplies 1 1,640 Other services and charges 2,700 1 Capital outlay 2,000 12,420 $ 9,287 I I I I I I I I I I I I I I I I I I I 29 CITY OF ANDOVER, MINNESOTA GENERAL FUND STATEMENT OF EXPENDITURES, COMPARED TO BUDGET (CONTINUED) YEAR ENDED DECEMBER 31, 1983 (with comparative actual amounts for year ended December 31, 1982) 1983 1982 Actual Budget Actual Public safety (continued) Animal control Personal services Supplies Other services and charges $ 200 $ 43 150 249 5,500 6,763 $ 4,933 $ 5,850 $ 7,055 $ 4,933 $254,101 $268,928 $267,410 Total public safety Public works Streets and highways Personal services Supplies Other services and charges Capital outlay $ 24,393 $ 27,994 $ 25,269 26,050 18,299 29,160 10,600 7,963 10,304 36,500 21,842 22,751 $ 97,543 $ 76,098 $ 87,484 $ 31,974 $ 22,103 $ 14,878 11 , 500 18,213 7,723 5,400 8,998 7,230 500 239 $ 49,374 $ 49,553 $ 29,831 $ 4,349 $ 4,077 $ .2 ,500 900 1,543 273 50 11 ,500 5,459 2,210 $ 16,749 $ 11,129 $ 4,983 $ 800 $ 392 $ 318 $164,466 $137,172 $122,616 Snow and ice removal Personal services Supplies Other services and charges Capital outlay Street signs Personal services Suppl ies Other services and charges Capital outlay Street lighting Other services and charges Total public works Sanitation Storm sewers Personal services Supplies Other services and charges $ 1,626 1,551 1,308 $ 4,485 $ 2,559 1,186 3,447 $ 7,192 $ 4,476 2,100 3,380 $ 9,956 30 ~ ~ ~ E E E ~ ~ E E E m ~ ~ ~ C ~. I' ~ ~' I CITY OF ANDOVER, MINNESOTA GENERAL FUND STATEMENT OF EXPENDITURES. COMPARED TO BUDGET (CONTINUED) YEAR ENDED DECEMBER,31, 1983 (with comparative actual amounts for year ended December 31, 1982) 1983 1982 Actual Budget Actual Sanitation (continued) Diseased trees Personal services Supplies Other services and charges Capital outlay $ 1,365 620 300 200 $ 2,485 $ 12,441 $ 12,524 1,684 3,112 $ 17,320 $ 21,805 $ 939 19 29 128 $ 1,115 $ 8,307 Total sanitation Parks and recreation Personal services Supplies Other services and charges Community education programs Assessments Capital outlay $ 17,209 9,345 7,840 23,922 11,359 15,000 $ 84,675 $ 18,593 8,562 5,831 23,732 11,359 20,544 $ 88,621 $ 17,356 7,700 7,416 23,177 12,335 295 $ 68,279 Other una110cated Senior Citizen Center Metropolitan Waste Control Commission Workers compensation and unemployment Improvement projects Miscellaneous Contingency $149,586 4,300 $ 4,300 4,759 8,845 1,169 11,921 2,165 991 $161,979 $ 26,057 $929,368 $726,153 $ 4,300 4,800 1,000 1,000 14,586 $ 25,686 $791,957 Total expenditures Other uses Transfers to other funds 1979 Certificate of Indebtedness Fund 1980 Certificate of Indebtedness Fund 1982 Certificate of Indebtedness Fund $ 19,040 $ 19,040 $ 20,060 9,400 9,400 9,960 39,366 42,000 $ 67,806 $ 70,440 $ 30 ,020 $859.763 $999.808 $756.173 Total expenditures and other uses I I I I I I I I I I I I I I I I I I I 31 CITY OF ANDOVER, MINNESOTA SPECIAL REVENUE FUND - REVENUE SHARING FUND COMPARATIVE BALANCE SHEET DECEMBER 31, 1983 AND 1982 1983 1982 ASSET Cash and temporary investments $ $ 46 -0- F,UND BALANCE Fund balance Unreserved - Undesignated $ 46 $ -0- STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCES YEAR ENDED DECEMBER 31, 1983 (with comparative actual amounts for year ended December 31, 1982) 1983 1982 Budget Actual Actual Revenue Federal grant $ 38,612 $ 38,511 $ 46,688 Interest on investments 563 1,933 Total revenue $ 38,612 $ 39 ,074 $ 48,621 Expenditures Other charges and services $ 11 Other uses Transfer to General Fund $ 38,612 39,109 $ 48,575 Total expenditures and other uses $ 38,612 $ 39,120 $ 48,575 Net increase (decrease) in fund balance $ -0- $( 46) $ 46 Fund balance January 1 46 -0- Fund balance December 31 $ -0- $ 46 32 CITY OF ANDOVER. MINNESOTA DEBT SERVICE FUNDS COMBINING BALANCE SHEET DECEMBER 31, 1983 (with comparative totals for December 31, 1982) 1978 G.O. Bonds ASSETS Cash and temporary investments $ 96,089 Accrued interest receivable 799 Taxes receivable Unremitted 322 Delinquent 3,693 Allowance for delinquent taxes ( 3,693) Due from other funds Total assets $ 97.210 FUND BALANCE Fund balance - Reserved for debt service $ 97.210 I I 1980 Certificate of Indebtedness $ 211 $ 211 $ 211 Totals 1983 1982 $ 96,300 $ 86,038 799 441 322 320 3,693 3,975 ( 3,693) ( 3,975) 2,777 $ 97.421 $ 89.576 $ 97.421 $ 89.576 33 I I I I I I I I I I I I I I I I I I I CITY OF ANDOVER, MINNESOTA DEBT SERVICE FUNDS COMBINING STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCES YEAR ENDED DECEMBER 31, 1983 (with comparative totals for year ended December 31, 1982) 1978 G.O. Certificates of Indebtedness Totals Bonds 1979 1980 1982 1983 1982 Revenue General property taxes $ 38,686 $ 38,686 $ 38,444 State credits 20,323 20,323 20,206 Interest on investments 5,834 $ 92 5,926 5,787 Other 213 213 210 $ 65,056 $ 92 $ 65,148 $ 64,647 Other sources Transfer from General Fund $ 19,040 9,400 $ 42,000 70,440 30,020 Total revenue and other sources $ 65,056 $ 19,040 $ 9,494 $ 42,000 $135,588 $ 94,667 Expenditures Redemption of bonds $ 40,000 $ 17,000 $ 8,000 $ 30,000 $ 95,000 $ 65,000 Interest and service charges 17,303 2,040 1,400 12,000 32,743 24,604 Total expenditures $ 57,303 $ 19,040 $ 9,400 $ 42,000 $127,743 $ 89,604 Net increase in fund balance $ 7,753 $ -0- $ 92 $ -0- $ 7,845 $ 5,063 Fund balance January 1 89,457 -0- 119 -0- 89,576 84 , 513 Fund balance December 31 $ 97.210 $ -0- $ 211 $ -0- $ 97.421 $ 89.576 34 CITY OF ANDOVER. MINNESOTA CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET DECEMBER 31, 1983 (with comparative totals for December 31, 1982) 1979 Equipment ASSETS Cash and temporary investments Accrued interest receivable Due from other governmental units $ 9,730 130 Total assets $ 9.860 LIABILITIES AND FUND BALANCE Liabilities Cash deficit Accounts payable Contracts payable Due to other funds Total liabilities Fund balance Reserved for equipment Reserved for construction Unreserved - Undesignated Total fund balance $ 9,860 $ 9,860 $ 9.860 Total liabilities and fund balance -I ,~ ~ E E ; E m E m E ~ ~i ~I ~ ~ E ~ E ; I 35 I I I State 1982 1983 Totals Park Aid Equipment Equipment 1983 1982 I $ 33,107 $ 5,721 $ 30,283 $ 78,841 $279,748 I 234 52 199 615 631 6,900 $110,072 116,972 I $ 40.241 $110.072 $ 5.773 $ 30.482 $196.428 $280.379 I I $ 91,548 $ 91,548 1,860 1,860 $ 1,890 15,919 15,919 10,814 I 1,083 $109,327 $109,327 $ 13,787 I $ 29,500 $ 29,500 $149,758 $ 745 745 68,443 $ 40,241 $ 5,773 982 56,856 48,391 I $ 40,241 $ 745 $ 5,773 $ 30,482 $ 87,101 $266,592 $ 40.241 $110.072 $ 5.773 $ 30.482 S196.428 $280.379 I I I I I I I 36 CITY OF ANDOVER, MINNESOTA CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVENUE. EXPENDITURES AND CHANGES IN FUND BALANCES YEAR ENDED DECEMBER 31, 1983 (with comparative totals for year ended December 31, 1982) 1979 Equipment Revenue State aid and grants Park dedication fees Interes.t on investments Other $ $ 1,178 Total revenue 1,178 Other sources Bond proceeds Total revenue and other sources $ 1,178 Expenditures Capital outlay Net increase (decrease) in fund balance $ 1,178 Fund balance January 1 8,682 9.,860 Fund balance December 31 $ ---- ; m E ~ ~ ~ ~ C C E ~ ~ ~ ~ m m m c c I I I I I I I I I I I I 11 11 ~ I I I I I 1 37 State 1982 1983 Totals Park Aid Equipment Equipment 1983 1982 $ 50,450 $ 257,638 $ 308,088 $ 287,482 11 ,170 11 , 1 70 13,610 5,705 4,220 $ 6,430 $ 982 18,515 9,523 182 182 165 $ 67,507 $ 261,858 $ 6,430 $ 982 $ 337,955 $ 310,780 30,000 30,000 150,000 $ 67,507 $ 261,858 $ 6,430 $ 30,982 $ 367,955 $ 460,780 $ 69,134 $ 327,397 $ 150,415 $ 500 $ 547,446 $ 263,291 $( 1,627) $( 65,539) $ (143,985) $ 30,482 $(179,491) $ 197,489 41,868 66,284 149,758 -0- 266,592 69,103 $ 40.241 $ 745 $ 5.773 $ 30.482 $ 87.101 $ 266.592 38 CITY OF ANDOVER, MINNESOTA SPECIAL ASSESSMENT FUNDS COMBINING BALANCE SHEET DECEMBER 31, 1983 (with comparative totals for December 75-1 ASSETS Cash and temporary investments $ Accrued interest receivable Taxes receivable Unremitted Delinquent Special assessments receivable Unremitted Delinquent Deferred Allowance for uncollected receivables ( Due from other funds 573,242 5,287 4,000 464,646 4,000) Total assets $ 1.043.175 LIABILITIES AND FUND BALANCE Liabilities Accounts payable Contracts payable Due to other funds Deposits payable Deferred revenue Bonds payable Total liabilities $ 464,646 1,085,000 $ 1,549,646 Fund balance (deficit) Reserved for construction Reserved for debt service Unreserved - Undesignated Total fund balance $( 506,471) $( 506,471) Total liabilities and fund balance $ 1.043.175 -I"~-" 31, 1982) 75-2 $ 19,215 152 1 13 61 3,039 9,569 ( 3,052) $ 28.998 $ 9,569 13 , 800 $ 23,369 $ 5,629 $ 5,629 $ 28.998 76-1 I D ~ ~ C ~ ~ ~ ~ ~ m ; c ~ cl Ii C1 ~' ~ cl $ 1,064,883 8,827 395 22,004 635,656 ( 22,004) $ 1. 709.761 $ 635,656 1,361,400 $ 1,997,056 $( 287,295) $ ( 287,295) $ 1.709.761 40 CITY OF ANDOVER, MINNESOTA SPECIAL ASSESSMENT FUNDS COMBINING BALANCE SHEET (CONTINUED) DECEMBER 31, 1983 (with comparative totals for December 31, 1982) ASSETS Cash and temporary investments Accrued interest receivable Taxes receivable Unremitted Delinquent Special assessments receivable Unremitted Delinquent Deferred Allowance for uncollected receivables Due from other funds Total assets LIABILITIES AND FUND BALANCE Liabilities Accounts payable Contracts payable Due to other funds Deposits payable Deferred revenue Bonds payable Total liabilities Fund balance (deficit) Reserved for construction Reserved for debt service Unreserved - Undesignated Total fund balance Total liabilities and fund balance ~ ; C ; ~.- ~ ~ m m c c C ~i ~r ~ m c c C Ii I, 80-3,4/82-7 81-1 $ 1,737,029 $ 39,867 15,069 278 12 81 4,049 75,218 2,530 2.701,308 89,322 ( 75,218) ( 2,611) 200,000 $ 4.657.455 $ 129.479 $ 6,125 36,153 2,701,308, $ 89,322 4,260,000 120,000 ' $ 7,003,586 $ 209,322 $(2,346,131) $ (2,346,131) $( 79,843) $( 79,843) $ 4.657.455 $ 129.479 --- I 41 I I I Totals Improvement pro;ects 1982 I 81-2 83-2, 2A, 3 83-5, 6 , 8 1983 Restated I $ 54,351 $ 437,184 $ 65,208 $ 4,768,520 $ 4,108,037 382 3,622 56 39,847 23,458 I 2 21 9 147 56 I 5,394 6,368 3,360 137,238 126,336 130,419 201,874 5,229,132 5,677 ,486 I ( 3,369) ( 137,385) ( 126,392) 200,000 59,147 I $ 185.154 $ 440.806 $ 267.138 $10.242.914 $ 9.874.496 I $ 7,016 $ 1,920 $ 8,936 $ 1,348 I 39,785 20,333 66,243 6,101 200,000 200,000 61,924 146,076 182,229 150,725 I $ 130,419 19,881 201,874 5,249,013 5,677,486 157,500 1,015,000 9,615,900 8,920,700 $ 287,919 $ 1,227,758 $ 424,127 $15,322,321 $14,818,284 I $ 41,391 $ 23,803 $ 65,194 $ 21,992 5,629 I $( 102,765) ( 828,343) ( 180,792) (5,150,230) (4,965,780) $( 102,765) $( 786,952) $( 156,989) $(5,079,407) $(4,943,788) I $ 185.154 $ 440.806 $ 267.138 $10.242.914 $ 9.874.496 I I I 42 CITY OF ANDOVER, MINNESOTA SPECIAL ASSESSMENT FUNDS COMBINING STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCES YEAR ENDED DECEMBER 31, 1983 (with comparative totals for year ended December 31, 1982) I ~ ~ ~ ~ ~ ~ ~ m c c ~ ~, I ~I ~ m, cl ~ ~ ~I I 43 I I I Improvement pro;ects 77-1 78-1 79-1 79-2/80-1 80-2 I $ 798 I 444 $ 993 $ 48,449 $ 32,350 $ 41,883 66,158 12,486 I 35,237 6,674 5,909 2,821 4,605 298 27 67 60 I $ 83,984 $ 39,051 $ 47,859 $ 70,032 $ 18,333 I $ 83,984 $ 39,051 $ 47,859 $ 70,032 $ 18,333 I $ 36,217 $ 13,867 $ 16,138 $ 25,712 $ 6,345 $ 36,217 $ 13,867 $ 16,138 $ 25,712 $ 6,345 I $ 36,217 $ 13,867 $ 16,138 $ 25 , 712 $ 6,345 I $ 47,767 $ 25,184 $ 31 ,721 $ 44, 320 $ 11,988 I $ 115,077 $ 14,168 $ 15,503 $ 7,369 $ 14,687 I (362,792) (178,623) (196,127) (358,058) ( 50,774) I $ (247 , 715) $(164,455) $(180,624) $ (350,689) $( 36,087) $(199.948) $(139.271) $ (148.903) $(306.369) $( 24.099) I I I I 44 CITY OF ANDOVER, MINNESOTA c ~ SPECIAL ASSESSMENT FUNDS COMBINING STATEMENT OF REVENUE, EXPENDITURES AND CHANGES IN FUND BALANCES (CONTINUED) YEAR ENDED DECEMBER 31, 1983 (with comparative totals for year ended December 31, 1982) Revenue General property taxes State credits Forfeited tax sale Special assessments Unit conneGtion charges Interest Reimbursements from other funds Miscellaneous Total revenue Other sources Transfer from Water Fund Total revenue and other sources Expenditures Construction costs Reimbursements to other funds Interest and fiscal charges Total expenditures Other uses - Transfers to other funds Sewer Fund Total expenditures and other uses Net increase (decrease) in fund balance Fund balance (deficit) January 1, before adjustment Adjustment to restate assessment revenue - See Note 2 Fund balance (deficit) January 1, as restated Fund balance (deficit) December 31 80-3, 4/82-7 $ 695,732 141,214 44 $ 836,990 7,500 $ 844,490 $ 13,691 377 ,428 $ 391,119 11 , 980 $ 403,099 $ 441,391 $ 381,124 (3,168,646) $ (2,787,522) $(2.346.131) ~ 81-1 $ 1,509 840 26,466 2,523 $ 31,338 $ 31,338 D ~ ~ ~ ~ m $ 13 ,350 $ 13,350 $ 13,350 $ 17,988 $ 5,060 ( 102,891) $( 97,831) $( 79.843) m c c c c c c c ~ ~ 45 . f ' _ Improvement Projects Totals 1982 81 -2 83 -2, 2A, 3 83 -5, 6, 8 1983 Restated $ 208 $ 2,746 $ 266 ' 114 1,493 81 2,564 5,317 36,033 $ 8,912 1,146,144 1,220,633 ' 6, 3,488 $ 19,840 231 354,672 420,719 719 8,266 79 3,551 6,320 ' $ 39,922 $ 19,840 $ 9,143 $ 1,511,170 $ 1,668,268 7,500 $ 39,922 $ 19,840 $ 9,143 $ 1,518,670 $ 1,668,268 $ 347 $ 806 $ 166,132 $ 986,962 $ 162,768 24,204 18,135 655,347 670,011 $ 18,482 $ 806,792 $ 166,132 $ 1,642,309 $ 856,983 ' 11,980 $ 18,482 $ 806,792 $ 166 $ 1,654,289 $ 856,983 $ 21,440 $( 786,952 $( 156,989 $( 135,619 $ 811 $ 27,702 $ -0- $ -0- $ 860,034 $ 441,365 ( 151,907 -0- - 0- (5,803,822 (6,196,438 ' $( 124,205 $ -0- $ -0- $(4,943,788 $(5,755,073) 102,765 $( 786,952 S( 156,989 S(5,079,407 S(4,943,788 46 r-> THIS PAGE LEFT ; ~ ~ ~ c c c ~ c ~ ~ ~ ~ ~ ~ ~ E m ~ BLANK INTENTI ONALL Y ---=------ _ __ r ~-=-- I 47 CITY OF ANDOVER, MINNESOTA ALL PROPRIETARY FUND TYPES - ENTERPRISE FUNDS I COMBINING BALANCE SHEET DECENBER 31, 1983 (with comparative totals for December 31, 1982) I Totals 1982 I Water Sewer 1983 Restated - ASSETS I Current assets Cash and temporary investments $ 6,484 $ 6,484 $ 12,375 Accrued interest receivable 100 $ 178 278 508 I Accounts receivable 1,891 30,279 32,170 23,588 Special assessments receivable 525 525 Prepaid expense 7,267 7,267 8,074 I Inventory 5,517 5,517 2,250 $ 13,992 $ 38,249 $ 52,241 $ 46,795 I Property and equipment Furniture and equipment $ 2,050 $ 3,366 $ 5,416 $ 4,842 Machinery 190,832 190,832 190,832 Collection and distribution I systems 321,112 4,165,666 ' 4,486,778 4,486,778 $ 513,994 $4,169,032 $4,683,026 $4,682,452 Less accumulated depreciation 40,340 454,483 494,823 395,042 I $ 473,654 $3,714,549 $4,188,203 $4,287,410 Other assets I Special assessments receivable $ 24,828 $ 24,828 Total assets $ 487.646 $3.777.626 $4.265.272 $4.334.205 I LIABILITIES AND FUND EQUITY I Current liabilities Cash deficit $ 4,590 $ 4,590 $ 1,329 Accounts payable $ 3,655 2,407 6,062 868 I Accrued expenses 160 535 6949 719 Due to other funds 8,074 Due to other governmental units . 26 ' 20 46 6,366 $ 3,841 $ 7,551 $ 11 , 392 $ 17,356 I Other liability Deferred revenue - Connection I charges $ 25,353 $ 25,353 Fund equity I Retained earnings Reserved for equipment $ 2,500 $ 2,500 Unreserved - Undesignated 9,271 $ 32,738 42,009 $ 33,554 $ 11,771 $ 32,738 $ 44,509 $ 33,554 I Cor.tributed 472 ,034 3,711,984 4,184,018 4,283,295 $ 483,805 $3,744,722 $4,228,527 $4,316,849 I Total liabilities and fund equ ity $ 487.646 $3.777.626 $4.265.272 $4.334.20:;> 48 CITY OF ANDOVER, MINNESOTA ALL PROPRIETARY FUND TYPES - ENTERPRISE FUNDS COMBINING STATEMENT OF CHANGES IN FUND EQUITY YEAR ENDED DECEMBER 31, 1983 Water Fund Retained Contributed earnings Fund equity January 1, before adjustments Adjustment to restate sewer expense - See Note 2 Fund equity January 1, as restated Net loss Depreciation of contributed property and equipment transferred to contributions Fund equity December 31 $487,998 $487,998 (15,964) $472.034 $ 16,437 $ 16,437 (20,630) 15,964 $ 11.771 Total $504,435 $504,435 (20,630) $483.805 8,074 ,~ c c n ~ c c c c c c c c c C D C C ~ Sewer Fund ------Re't.iiil-e;d-- Contributed earnings - --------- - $3,795,297 $ 9,043 $ 17,117 (67,692) 83,313 $' 32.738 $3,795,297 ( 83,313) $3.711.984 I I I 0-.1 I I I I I I I I I I I I I I I 49 Total 1983 Total 1982 Restated Retained J.{etained Total Contributed earnings Total Contributed earnings Total $3,804,340 $4,283,295 $ 25,480 $4,308,775 $4,382,572 $ 42,987 $4,425,559 8,074 8,074 8,074 $3,812,414 $4,283,295 $ 33,554 $4,316,849 $4,382,572 $ 42,987 $4,425,559 ( 67,692) (88,322) ( 88,322) (l08,710) , ( 108,710) ( 99,277) $4.184.018 99,277 $ 44.509 $( 99,277) $4.283.295 $ 99,277 33.554 $3.744,722 $4.228.527 $4.316.849 50 a CITY OF ANDOVER, MINNESOTA ALL PROPRIETARY FUND TYPES - ENTERPRISE FUNDS COMBINING STATEMENT OF REVENUE AND EXPENSE YEAR ENDED DECEMBER 31, 1983 (with comparative totals for year ended December 31, 1982) Totals 8 1982 Hater Sewer 1983 Restated Operating revenue User charges $ 11,880 $ 89,945 $ 101,825 $ 75,318 Connection charges 15,020 3,473 18,493 42,899 Meters 1,300 1,300 3,795 Penalties 213 1,260 1 1,726 Other 285 285 $ 28,413 $ 94,963 $ 123,376 $ 123,738 Operating expense (excluding depreciation) Personal services $ 15,325 $ 12,662 $ 27,987 $ 33,213 Supplies 3,765 2,509 6,274 8,318 Other services and charges 7,382 9,299 16,681 16,825 Disposal charges 68,153 68,153 76 $ 26,472 $ 92,623 $ 119,095 $ 134,749 Operating income (loss) before depreciation $ 1,941 $ 2 $ 4,281 $( 11,011 Less depreciation On assets acquired with own funds $ 187 $ 317 $ 504 $ 459 On assets acquired from contributions 15,964 83,313 99,277 99,277 $ 16,151 $ 83,630 $ 99,781 $ 99,736 Operating loss $( 14,210 $( 81,290 $( 95,500) $(110,747 Other income (expense) Interest $ 1,080 $ 1,618 $ 2 $ 2 Transfer from special assessment funds 11,980 11,980 Transfer to special assessment funds ( 7,50C ( 7,500 $( 6,420 $ 13,598 $ 7,178 $ 2,037 Net loss $( 20,63 S( 67.692 $( 88,322 5(108.710 I I I I I I I I I I I I I I I I I I I CITY OF ANDOVER, MINNESOTA ALL PROPRIETARY FUND TYPES - ENTERPRISE FUNDS COMBINING STATEMENT OF CHANGES IN FINANCIAL POSITION YEAR ENDED DECEMBER 31, 1983 (with comparative totals for year ended December 31, 1982) 51 52 CITY OF ANDOVER, MINNESOTA WATER FUND COMPARATIVE BALANCE SHEET DECEMBER 31, 1983 AND 1982 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 LIABILITIES AND FUND EQUITY Current liabilities Accounts payable Due to other governmental units Accrued expenses Fund equity Retained earnings Reserved for equipment Unreserved - Undesignated Contributed Total liabilities and fund equity 1983 1982 $ 6,484 $ 12.375 100 372 1,891 1,340 5,517 2,250 $ 13 , 992 $ 16,337 $ 2,050 $ 1,564 190,832 190,832 321,112 321,112 $513,994 $513,508 40,340 24,189 $473,654 $489,319 $487.646 $505.656 $ 3,655 26 160 $ 3,841 $ 713 508 $ 1,221 $ 2,500 9,271 $ 11,771 472 ,034 $483,805 $487.646 $ 16,437 $ 16.437 4a7,998 $504,435 $505.656 -~- ;~.j.;-- ~-~---- m ~ E E E E E ~ E E E .1 ~ E E .~ E E ~ I I I I I I I I I I I I I I I I I I I CITY OF ANDOVER, MINNESOTA WATER FUND COMPARATIVE STATEMENT OF CHANGES IN FUND EQUITY YEARS ENDED DECEMBER 31, 1983 AND 1982 Year ended December 31, 1982 Fund equity January 1 Net loss $503,962 Depreciation on contributed property and equipment transferred to contributions Fund equity December 31 (15,964) $487.998 $ 11 ,008 (10,535) 15,964 $ 16.437 53 $514,970 (10,535) $504.435 54 CITY OF ANDOVER, MINNESOTA WATER FUND COMPARATIVE STATEMENT OF REVENUE AND EXPENSE YEARS ENDED DECEMBER 31, 1983 AND 1982 Operating revenue User charges Connection charges Penalties Meters Operating expense (excluding depreciation) Personal services Supplies Other services and charges Operating income before depreciation Less depreciation On assets acquired with own funds On assets acquired from contributions Operating loss Other income (expense) Interest Transfer to special assessment funds Net loss 1983 1982 $ 11~880 $ 6,836 15,020 31,559 213 92 1,300 3,795 $ 28 ,413 $ 42,282 $ 15,325 $ 23,582 3,765 6,025 7 ,382 8,004 $ 26 ,472 $ 37,611 $ 1,941 $ 4,671 $ 187 $ 161 15,964 15,964 $ 16,151 $ 16,125 $(14,210) $(11,454) $ 1,080 $ 919 ( 7,500) $( 6,420) $ 919 $(20,630) $(10,535) c C E I E E I ~ ~ E E ~ E E E I E E E ~ '~I :~~ I I I I 55 CITY OF ANDOVER. MINNESOTA WATER FUND COMPARATIVE STATEMENT OF CHANGES IN FINANCIAL POSITION YEARS ENDED DECEMBER 31, 1983 AND 1982 I I I I I I I I I I I I I I I Elements of change in working capital Cash and temporary investments $( 5,891) $ 8,978 Accrued interest receivable ( 272) 372 Accounts receivable 551 860 Inventory 3,267 ( 3,635) Accounts payable ( 2,942) ( 985 Due to other governmental units ( 26) Accrued expenses 348 Increase (decrease) in working capital $( 4.965) $ 5.590 56 CITY OF ANDOVER. MINNESOTA SEWER FUND COMPARATIVE BALANCE SHEET DECEMBER 31, 1983 AND 1982 ASSETS Current assets Accrued interest receivable Accounts receivable Special assessments receivable Prepaid expense Property and equipment Furniture and equipment Collection system Less accumulated depreciation Other asset Special assessments receivable Total assets LIABILITIES AND FUND EQUITY Current liabilities Cash deficit Accounts payable Accrued expenses Due to other funds Due to other governmental units Other liability Deferred revenue - Connection charges Fund equity Contributed Retained earnings - Unreserved - Undesignated Total liabilities and fund equity 1983 $ 178 30,279 525 7,267 $ 38,249 $ 3,366 4,165,666 $4.169,032 454,483 $3,714,549 $ 24,828 $3.777.626 $ 4,590 2,407 534 20 $ 7,551 $ 25,353 $3,711,984 32,738 $3,744,722 $3.777.626 1982 Restated e E ~ ! ; ~ $ 136 22,248 8,074 $ 30,458 ! $ 3,278 4,165,666 $4,168,944 370,853 $3,798,091 ~ I E ~ E E E I E E E ~ $3.828.549 $ 1,329 155 211 8,074 6,366 $ 16,135 $3.795,297 17,117 $3,812,414 $3.828.549 ~~f'~ ~, , I I I I I I I I I I I I I I I I I I I CITY OF ANDOVER, MINNESOTA SEWER FUND COMPARATIVE STATEMENT OF CHANGES IN FUND EQUITY YEARS ENDED DECEMBER 31, 1983 AND 1982 Year ended December 31, 1983 Fund equity January 1, before adjustment Adjustment to restate sewer expense _ See Note 2 Fund equity January 1, as restated Net loss Depreciation of contributed property and equipment transferred to contributions Fund equity December 31 Year ended December 31, 1982 Restated Fund equity January 1 Net loss Depreciation on contributed property and equipment transferred to contributions Fund equity December 31 Contributed $3,795,297 $3,795,297 ( 83,313) $3.711.984 $3,878,610 ( 83,313) $3.795.297 Retained earnings $ 9,043 8,074 $ 17,117 ( 67,692) $ 83,313 32.738 $ 31,979 ( 98,175) $ 83,313 17.117 57 Total - $3,804,340 8,074 $3,812,414 ( 67,692) $3.744.722 $3,910,589 ( 98,175) $3.812.414 I - E I i 58 CITY OF ANDOVER. MINNESOTA SEWER FUND COMPARATIVE STATEMENT OF REVENUE AND EXPENSE YEARS ENDED DECEMBER 31, 1983 AND 1982 Operating revenue User charges Connection charges Penalties Other Operating expense (excluding depreciation) Personal services Supplies Other services and charges Disposal charges Operating income (loss) before depreciation Less depreciation On assets acquired with own funds On assets acquired from contributions Operating loss Other income Interest Transfer from special assessment funds Net loss ------..- ,-.~ 1982 1983 Restated $ 89,945 $ 68,482 3,473 11 , 340 1,260 1,634 285 $ 94,963 $ 81,456 $ 12,662 $ 9,631 2,509 2,293 9,299 8,821 68,153 76,393 $ 92,623 $ 97,138 $ 2,340 $ (15 ,682) $ 317 $ 298 83,313 83,313 $ 83,630 $ 83,611 $(81,290) $(99,293) $ 1,618 $ 1,118 11,980 $ 13,598 $ 1,118 $(67.692) $(98.175) ~ C I ; E I E I ~ ~ E E E ~ E E I E E I I CITY OF ANDOVER, MINNESOTA SEHER FUND COMPARATIVE STATEMENT OF CHANGES IN FINANCIAL POSITION YEARS ENDED DECEMBER 31, 1983 AND 1982 I I I Sources of working capital Opera tions Net income (loss) Item not requiring working capital Depreciation I I Increase in deferred revenue Decrease in other assets I I Uses of working capital Operations Net loss Item not requ~r~ng working capital Depreciation I I Acquisition of property and equipment Increase in other assets Decrease in deferred revenue Increase (decrease) in working capital I Elements of change in working capital Cash and temporary investments Accrued interest receivable Accounts receivable Special assessment receivable Prepaid expenses Accounts payable Accrued expenses Due to other funds Due to other governmental units I I I I I I I Increase (decrease) in working capital 1983 , 59 1982 Restated $ 98,175 (83,611) $ 14,564 $ 88 225 24,828 30,460 $ 24,916 $ 45,249 $ 16.375 $<14.789) $( 3,261) 42 8,031 525 ( 807) ( 2,252) ( 323) 8,074 6,346 $ 16.375 $(11,347) 136 3,144 8,074 ( 145) ( 211) ( 8,074) ( 6,366) $ <14.789) i ! i , 60 CITY OF ANDOVER, MINNESOTA COMPARATIVE STATEMENT OF GENERAL FIXED ASSETS DECEMBER 31, 1983 AND 1982 General Fixed Assets Land and improvements Buildings and improvements Furniture and equipment Machinery and automotive equipment Total General Fixed Assets Investment in General Fixed Assets 1983 $ 98,103 564,146 78,208 387,758 $1.128.215 $1.128.215 1982 ~ ; m ; ! m ~ ~ '~ ~ ~ ~ ~ ~ ~ D ~ ~ C $ 95,881 408,432 62,492 368,901 $ 935.706 $ 935.706 I' -- I I CITY OF ANDOVER, MINNESOTA 61 COMPARATIVE STATEMENT OF GENERAL LONG-TERM DEBT DECEMBER 31, 1983 AND 1982 I II Amount available and to be provided for payment of general long-term debt I Amount available in debt service funds Resources to be provided by future revenues I Total I I I General long-term debt payable Accounts payable - Assessments on City property Accrued liability - Vacation pay - Governmental funds Contracts payable Equipment purchase Land acquisition 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 1983 Certificates of Indebtedness I I I I I Total I I I I I 1983 1982 $ 97,421 553,550 $650.971 $ 89,576 578,366 $667.942 $ 98,972 $ 93,076 6,268 3,804 7,289 8,887 44,000 26,442 29,175 285,000 325,000 17,000 34,000 16,000 24,000 120,000 150,000 30,000 $650.971 $667.942 - . - E . I I I I I I I I I I I I I I I I I I I SECTION III STATISTICAL SECTION I = I I I I I I I I I I I I I I I I I I I I 63 CITY OF ANDOVER, MINNESOTA SCHEDULE OF CASH, TEMPORARY INVESTMENTS AND SECURITY FOR DEPOSITS DECEMBER 31, 1983 Cash Face amount of securities pledged as collateral by depository First National Bank of Anoka Checking account Savings account Money market account Certificates of deposit $ 368 750,679 23,324 4,500,000 $5.274.371 ' $5.435.000 Additional security of $100,000 each for demand deposits and time deposits is provided by the Federal Deposit Insurance Corporation. 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, 1983, the bank deposits at First National Bank of Anoka were in excess of this requirement. - - i ! : ; - i I I 64 C CITY OF ANDOVER, MINNESOTA COMBINED SCHEDULE OF INDEBTEDNESS ~ DECEMBER 31, 1983 m Final Interest Issue maturity E 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 '/./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 E General Obligation Improvement Bonds of 1977 5.25-5.50 10/1/77 2/1/98 General Obligation Improvement I 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 E 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 E General Obligation Improvement Bonds of 1980 8.50-9.10 10/1/80 2/1/02 General Obligation Imp:rovemen t E 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 Improvement E Bonds of 1982 7.00 10/1/83 10/1/86 General obligation bonds m General Obligation Improvement Bonds of 1978 (Building & Equipment) 5.55-5.70 11/1/78 2/1/89 ~ 1979 Certificates of Indebtedness 6.00 8/1/79 8/1/84 1980 Certificates of Indebtedness 7.00 10/1/80 4/1/85 1981 Certificates of Indebtedness 8.00 12/31/81 12/31/87 D 1983 Certificates of Indebtedness 7.50 10/1/83 10/1/88 Total Bonded Indebtedness ~ Long-term payab1es Metropolitan Waste Control Commission 5.369 1971 1991 ~ Special assessments on City owned property 6.25-10.70 Various 2001 Land acquisition 9.00 1983 1985 Equipment purchase 18.57 1982 1987 ~ Total Indebtedness I '.~- t ,~,~.....- --. -----=--- 65 Indebtedness ' Authorized Due in 1984 and issued Redeemed Outstanding Principal Interest $ 46,000 $ 32,200 $ 13,800 $ 4,600 $ 897 ' 1 310,000 1,325,000 65,000 85,042 56,000 19,600 36 2,800 2,282 1,215,000 130,000 1,085,000 25,000 54,250 780,000 115,000 665,000 30,000 34,592 270,000 35,000 235,000 10,000 13,313 ' 270,000 30,000 240,000 15,000 15,112 430,000 55,000 375,000 30,000 23,835 ' 98,000 9,800 88,200 4,900 6 4,365,000 105,000 4,260,000 105,000 368,202 ' 150,000 30,000 120,000 15,000 11,888 175,000 17,500 157,500 17,500 16,013 1,015,000 1,015,000 71,050 ' $10,505,000 $ 889 $ 9,615,900 $ 324,800 $ 702,479 $ 430,000 $ 145,000 $ 285,000 $ 40,000 $ 14,972 85,000 68,000 17,000 17,000 1,020 40,000 24,000 16,000 8,000 840 - 1 150,000 30 120 30,000 9 30,000 30,000 6,000 2,250 $ 735,000 $ 267,000 $ 468,000 $ 101,000 $ 28,682 $11,240,000 $ 1,156,100 $10,083,900 $ 425,800 $ 731,161 $ 43,018 $ 16,576 $ 26,442 $ 2,880 $ 1 111,653 12,681 98,972 3,812 9,897 - 44,000 44,000 22,000 3,960 10,115 2,826 7,289 1,923 1,197 `- ' $ 208,786 $ 32,083 $ 176,703 $ 30,615 $ 16,474 ff E ff $11,448,786 $ 1,188,183 $10,260,603 $ 456,415 $ 747,635 66 a CITY OF ANDOVER, MINNESOTA SCHEDULE OF BONDS PAYABLE DECEMBER 31, 1983 O Annual Issue Maturity Interest serial date date rate payments Special assessment bonds a Improvement Bond of 1975 9/1/75 $4,600 per year 9/1/84 -86 6.50% $ 13,800 General Obligation Improvement Bonds of 1976 8/1/76 February 1, 1984 6.20 $ 65,000 February 1, 1985 6.20 70,000 February 1, 1986 6.25 75,000 February 1, 1987 6.25 80,000 February 1, 1988 6.30 85,000 February 1, 1989 6.40 90,000 February 1, 1990 6.50 95,000 February 1, 1991 6.60 100,000 February 1, 1992 6.70 110,000 February 1, 1993 6.80 95,000 February 1, 1994 6.80 105,000 February 1, 1995 6.80 110,000 February 1, 1996 6.80 120,000 February 1, 1997 6.80 125,000 $ 1,325 Improvement Bonds of 1976 11/1/76 $2,800 per year 11/1/84 -86 5.50 $ 8,400 $2,800 per year 11/1/87 -91 6.25 14,000 $2,800 per year 11/1/92 -96 6.75 14,000 $ 36,400 General Obligation Improvement Bonds of 1977 3/1/77 $25,000 per year 1/l/85 -86 5.00 $ 50,000 $30,000 per year 1/1/87 -88 5.00 60,000 $35,000 per year 1/1/89 -90 5.00 70,000 $40,000 per year 1/1/91 -92 5.00 80,000 $45,000 per year 1/1/93 -94 5.00 90 $50,000 per year 1/1/95 -96 5.00 100,000 $55,000 per year 1/1/97 -98 5.00 110,000 $60,000 per year 1/1/99 -2000 5.00 120,000 $65,000 per year 1/1/01 -03 5.00 195,000 $70,000 per year 1/1/04 -06 5.00 210,000 $ 1,085,000 CITY OF ANDOVER, MINNESOTA 67 ' SCHEDULE OF BONDS PAYABLE (CONTINUED DECEMBER 31, 1983 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/84 -85 5.25% $ 60,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 $ 665,000 General Obligation Improvement Bonds of 1978 1/1/78 $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 1, 1993 2/1/93 5.80 15,000 February 1, 1994 2/1/94 5.90 15,000 February 1, 1995 2/l/95 6.00 15,000 $20,000 per year 2/1/96 -99 6.00 80,000 $ 235,000 ' General Obligation Improvement Bonds of 1979 11/1/79 $15,000 per year 2/1/84 -87 6.50 $ 60,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 $ 240,000 ' General Obligation Improvement Bonds of 1980 6/1/80 February 1, 1984 6.20 $ 30,000 February 1, 1985 6.30 35,000 February 1, 1986 6.40 40,000 February 1, 1987 6.50 45,000 February 1, 1988 6.60 50,000 ' February 1, 1989 6.70 50,000 February 1, 1990 6.80 60,000 = February 1, 1991 6.90 65,000 ' $ 3751000 68 CITY OF ANDOVER, MINNESOTA SCHEDULE OF BONDS PAYABLE (CONTINUED O DECEMBER 31, 1983 O Annual Issue Maturity Interest serial date date rate payments Special assessment bonds (continued) General Obligation Bonds of 1980 8/1/80 $4,900 per year 2/1/84 -2001 7.00% $ 88,200 General Obligation Improvement Bonds of 1980 10/1/80 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 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 February 1, 2002 9.10 305,000 $ 4,260,000 General Obligation Improvement Bonds of 1981 7/1/81 $15,000 per year 8/1/84 -86 9.75 $ 45,000 $15,000 per year 8/1/87 -91 10.00 75,000 $ 120,000 General Obligation Improvement Bonds of 1981 10/1/81 $17,500 per year 2/1/84 -87 11.50 $ 70,000 $17,500 per year 2/1/88 -92 10.25 87,500 $ 157,500 General Obligation Improvement Bonds of 1983 10/1/83 October 1, 1986 10/1/86 7.00 $ 1,015,000 Total special assessment bonds $ 9 --T - - I I I I I I I I I I I I I I I I I I I 69 CITY OF ANDOVER, MINNESOTA SCHEDULE OF BONDS PAYABLE (CONTINUED) DECEMBER 31, 1983 Note - January 1, 1984 maturities are considered matured December 31, 1983. ~ ! II ~ i I I i I . I . 70 CITY OF ANDOVER, MINNESOTA DEBT SERVICE REQUIREMENTS DECEMBER 31, 1983 Special assessment bonds Year Principal Interest Total 1984 $ 324,800 $ 702,479 $ 1,027,279 1985 349,800 678,078 1,027,878 1986 1,394,800 651,804 2,046,604 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 2002 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 $9.615.900 $6.598.538 $16.214.438 General obligation bonds Principal Interest Total - $101,000 $ 28,682 $129,682 89,000 21,830 110,830 81,000 16,135 97,135 86,000 10,578 96,578 61,000 4,776 65,776 50,000 1,400 51,400 ~ ~ E ~ E I E I I I E ~ E E E E ~ E E Note - January 1 maturities are considered matured December 31, of the preceding year. -=--------r-- !_ '--- .i'-- $468.000 $ 83.401 $551.401 ~- ---'---~- CITY OF ANDOVER, MINNESOTA 71 ' TAX LEVIES AND COLLECTIONS ' Percentage Collection Percentage Collection of total Total of current of levy of prior Total collections ' Year le_ vy year's levy col_ lected 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 455,627 98.92. ' 1982 496,388 450,271 90.71 21,859 472,130 95.11 1983 570,009 548,667 96,26 18 566,953 99.46 ' SPECIAL ASSESSMENT LEVIES AND COLLECTIONS ' Percentage Collection Percentage Collection of total ' Total of current of levy of prior Total collections Year le_ vy year's levy collected years' 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 1983 724,655 634,003 87.49 77,505 711,508 98.19 I I I I I I I I I I I I I I I I I I I 73 CITY OF ANDOVER, MINNESOTA ASSESSED VALUATIONS, TAX LEVIES AND MILL RATES (shown by year of tax col1ectibi1ity) 1981 1982 1983 1984 Assessed valuations $34,565,632 $39,541,477 $44,071,159 $43,692,054 Contribution to fiscal disparities pool (1,360,707) (1,475,372) (1,543,109) (1,656,156) Distribution from fiscal disparities pool 2,483,123 3,956,148 5,480,041 6,767,570 Taxable valuation $35.686.048 ' $42.022.253 $48.008.091 $48.803.468 Tax levies Revenue $ 393,410 $ 433,380 $ 476,955 $ 530,144 General obligation debt 63,707 61,313 93,056 115,366 Special assessment debt 3,483 258 $ 460.600 $ 494.951 $ 570.011 $ 645.510 Mill rates Revenue 11.122 10.200 9.959 11 .038 General obligation debt 1. 801 1.444 1. 943 2.402 Special assessment debt .099 .006 13.022 11.650 11. 902 13 .440 = ~ .- I ,