Loading...
HomeMy WebLinkAboutAUDIT 06-30-1986 TOWN OF NORTH ~NDOVER, HASSACHUSETTS SCHEDULE OF FEDERAL FINANCIAL ASSISTANCE AND AUDITOR'S REPOKTS REQUIRED UNDER THE SINGLE AUDIT ACT OF 1984 FOR THE YEAR ENDED JUNE 30, 1986 APR 0 6 1988 TOWN OF NORTH ANDOVER, MASSACHUSETTS FINANCIAL REPORT PURSUANT TO OMB CIRCULAR A-128 FOR THE YEAR ENDED JUNE 30,1986 INDEX Auditor's Report on Schedule of Federal Financial Assistance Auditor's Report on Compliance with Laws and Regulations Related to Major and Nonmajor Federal Financial Assistance Programs Auditor's Report on Internal Controls Used in Administering Federal Financial Assistance Programs Schedule I - Schedule of Federal Financial Assistance Notes to Schedule of Federal Financial Assistance Schedule I - Schedule of Findings and Questioned Costs Pag~ 2 5 8 10 12 AUDITOR'S REPORT ON SCHEDULE OF FEDERAL FINANCIAL ASSISTANCE TO the Honorable Board of Selectmen, Town of North Andover, Massachusetts: We have examined the general purpose financial statements of the TOWN OF NORTH ANDOVER, MASSACHUSETTS as of June 30, 1986 and for the year then ended, and have issued our report thereon, which was qualified in several respects, dated February 27, 1987. Our examination was made in accordance with generally accepted governmental auditing standards and the standards for financial and compliance audits contained in the Standards for Audit of Governmental Organizations, Pro~rams, Activities and Functions, issued 'by the ~.S. General Accounting Office and, accordingly, included such tests of the accounting records and such other auditing procedures as we considered necessary in the circumstances. Our examination was made for the purpose of forming an opinion on the general purpose financial statements taken as a whole. The accompanying Schedule of Federal Financial Assistance is presented for purposes of additional analysis and is not a required part of the general purpose financial statements. The information in that Schedule has been subjected to the auditing procedures applied in the examination of the general purpose financial statements of the Town and, in our opinion, is fairly stated in all material respects in relation to the general purpose financial statements taken.as a whole. February 27, 1987 Very Truly Yours, Acting Director-~ureau/~f Accounts Department of Revenue ~/ 2 AUDITOR'S REPORT ON COMPLIANCE WITH LAWS AND REGULATIONS RELATED TO MAJOR AND NONMAJOR FEDERAL FINANCIAL ASSISTANCE PROGRAMS To the Honorable Board of Selectmen, Town of North Andover, Massachusetts: We have examined the general purpose financial statements of the TOWN OF NORTH ANDOVER, MASSACHUSETTS for the year ended June 30, 1986 and have issued our report thereon, which was qualified in several respects, dated February 27, 1987. Our examination was made in accordance with generally accepted governmental auditing standards; the standards for financial and compliance audits contained in the Standards for Audit of Governmental Organizations, Programs, Activities and Functions, issued by the U. S. General Accounting Office; the Single Audit Act of 1984; and the provisions of OMB Circular A -128, Audits of State and Local Governments and, accordingly, included such tests of the accounting records and such other auditing procedures as we considered necessary in the circumstances. The management of the Town of North Andover, Massachusetts is responsible for the Town's compliance with laws and regulations. In connection with the examination referred to above, we selected and tested transactions and records from each major federal financial assistance program, and additionally 2 non major federal financial assistance programs, a) P.L. 81-874- "Equipment Inventory", b)"The National School Lunch Program". The purpose of our testing of transactions and records from those federal financial assistance programs was to obtain reasonable assurance that the Town of North Andover, Massachusetts had, in all material respects administered major programs in compliance with laws and regulations including those to financial reports and claims for advances and reimbursements, noncompliance with which we believe could have a material effect on the allowability of program expenditures. Our testing of transactions and records selected from major federal financial assistance programs disclosed instances of noncompliance with those laws and regulations. All instances of noncompliance that we found and the programs to which they relate are identified in the accompanying Schedule of Findings and Questioned Costs. In our opinion, subject to the effect of the ultimate resolution of those instances of noncompliance referred to in the preceding paragraph, for the year ended June 30, 1986, the Town of North Andover, Massachusetts administered each of its major federal financial assistance programs in compliance, in all material respects, with laws and regulations, including those pertaining to financial reports and claims for advances and reimbursements, noncompliance with which we believe could have a material effect on the allowability of program expenditures. The results of our testing of transactions and records selected from nonmajor federal financial assistance programs indicate that for the transactions and records tested the Town of North Andover, Massachusetts complied with the laws and regulations referred to in the second paragraph of our report, except as noted in the accompanying Schedule of Findings and Questioned Costs. Our testing was more limited than would be necessary to express an opinion on whether the Town of North Andover, Massachusetts administered those programs in compliance in all material respects with those laws and regulations noncompliance with which we believe could have a m~terial effect on the allowability of program expenditures; however, with respect to the transactions and records that were not tested by us, nothing came to our attention to indicate that the Town of North Andover, Massachusetts had not complied with laws and regulations other than those laws and regulations for which we noted violations in our testing referred to above. February 27, 1987 Very. Truly Yours, Ma r'~e"~ let Mu r p~m2~']_~ /.~'~f~ Acting Direotor-~ur~u of Accounts Department of Revenue AUDITOR'S REPORT ON INTERNAL CONTROLS USED IN ADMINISTERING FEDERAL FINANCIAL ASSISTANCE PROGRAMS TO the Honorable Board of Selectmen, Town of North Andover, Massachusetts: We have examined the general purpose financial statements of the TOWN OF NORTH ANDOVER, F~SSACHUSETTS for the year ended June 30, 1986 and have issued our report thereon, which was qualified in several respects, dated February 27, 1987. As part of our examination, we made a study and evaluation of the internal control systems, including applicable internal administrative controls, used in administering federal financial assistance programs to the extent we considered necessary to evaluate the systems as required by generally accepted auditing standards, the standards for financial and compliance audits contained in the Standards for Audit of Governmental Organizations, Programs, Activities and Functions, issued by the U. S. General Accounting Office, the Single Audit Act of 1984 and the provisions of OMB Circular A -128, Audits of State and Local Governments. For the purpose of this report, we have classified the significant internal accounting and administrative controls used in administering federal financial assistance programs in the following categories: Accounting Controls Revenue/receipts Expenditure - purchasing and payroll External financial reporting Administrative Controls- General Political activity Davis-Bacon Act Civil rights Cash management Relocation assistance and real property acquisition Federal financial reports Administrative Controls-Specific Types of services Matching level of effort Eligibility Reporting Costs allocation Monitoring subrecipients The management of the Town of North Andover, Massachusetts is responsible for establishing and maintaining internal control systems used in administering federal financial assistance programs. In fulfilling that responsibility, estimates and judgments by management are required to assess the expected benefits and related costs of control procedures. The objectives of internal control systems used in administering federal financial assistance programs are to provide management with reasonable, but not absolute, assurance that, with respect to federal financial assistance programs, resource use is consistent with laws, regulations and policies; resources are safeguarded against waste, loss and misuse; and reliable data are obtained, maintained and fairly disclosed in reports. Because of inherent limitations in any system of internal accounting and administrative controls used in administering federal financial assistance programs, errors or irregularities may nevertheless occur and not be detected. Also, projection of any evaluation of the systems to future periods i~ subject to the risk that procedures may become inadequate because of changes in conditions or that the degree of compliance with the procedures may deteriorate. Our study included all of the applicable control categories listed above. During the year ended June 30, 1986, the Town of North Andover, Massachusetts expended 51% of its total federal financial assistance under major federal financial assistance programs. With respect to internal control systems used in administering major federal financial assistance programs, our study and evaluation included considering the types of errors and irregularities that could occur, determining the internal control procedures that should prevent or detect such errors and irregularities, determining whether the necessary procedures are prescribed and are being followed satisfactorily, and evaluating any weaknesses. With respect to the internal control system used solely in administering the nonmajor federal assistance programs of the Town of North Andover, Massachusetts, our study and evaluation was limited to a preliminary review of the systems to obtain an understanding of the control environment and the flow of transactions through the accounting systems. Our study and evaluation of the internal control systems used solely in administering the nonmajor federal financial assistance programs of the Town of North Andover, Massachusetts did not extend beyond this preliminary review phase. Our study and evaluation was more limited than would be necessary to express an opinion on the internal control systems used in administering the federal financial assistance programs of the Town of North Andover, Massachusetts. Accordingly, we do not express an opinion on the internal control systems used in administering the federal financial assistance programs of the Town of North Andover, Massachusetts. Further, we do not express an opinion on the internal control systems used in administering the major federal financial assistance programs of the Town of North Andover, Massachusetts. Also, our examination, made in accordance with the standards mentioned above, would not necessarily disclose material weaknesses in the internal control systems used solely in administering nonmajor federal financial assistance programs. However, our study and evaluation and our examination disclosed no condition that we believe to be a material weakness in relation to a fe6eral financial assistance program of the Town of North Andover, Massachusetts. THis report is intended solely for the use of management of the Town of North Andover, Massachusetts, the Department of Education and other associated federal organizations, and should not be used for any other purpose. This restriction is not intended to limit the distribution of this report, which, upon acceptance of the Town of North Andover, Massachusetts, is a matter of public record. February 27, 1987 Very Truly Yours, Acting Director-~Bur~u of Accounts Department of Revenue TOWN OF NORTH ANBOVER, ~ASSA('IiUSETTS SCHEDULE OF FEDERAL FINANCIAL ASSISTANCE For the year ended June 30, 1986 SCIIEDULE I Pass-Through Grantor Catalogue ~rogram Title Number UBS.Department of Education Public Law 81-874 84,041 Public Law 81-815 Passed Throuh_~g_~tate · Department of Education E.C.I.Ao-Chapter ! P.L. 97-35 84,010 B,CoI.A.-Chapte~ ! PuL, 97-35 E.C.10Ao-Chapter Il PuL. 97-35 84o]5i E,C°IoA,-Chapte£ Il PuL, 97-35 84,151 -Title VI BoP.L, 94-142 84,027 -Title VI B.PoL. 94-142 84.027 -Title VI B.P.L. 94-142 84.027 -Title I P.L. 89-313 84,009 E.E.S.A,-Titie II P°Lo 98-377 84,161 Voc. Ed. P.L. 98-524 84,048 ~.S? Department Bi Agriculture Passed Through St~at~e Department of Education Food Bistribution {1) National School Lunch Program Pass-Through Program Revenue Recognized Number Amount duly 7,]985 Federa~ ~at~ ~the~ Expenditures S N/A $ ]4,036 $ 9,386 N/A 141,14~ 155, ] 80 ,~038~ (] 41, ] 4---------~) 86-211-080 73,311 -0- 72,668 85-211-080 N/A 1,838 ¢71,643) Block grant {1,838) F.Y. 1986 14,241 -0- 14,241 Block grant (14,241) F.Yo 1985 N/A 38 138) 240-216-6-0211-2 96,530 -0- 96,530 {95,308) 262-079-6-0211-2 6,000 -0-' 6,000 N/A 95 (2,652) 200-237-6-0211-2 18,000 -0- 18,000 {}7,907} 2,476 -0- 2,476 (2,476) 400-071-0211-2 _3_7,575 -0- 7,575 · (7,481] ~,971 217,490 (213,6791 10,550 7053-2113 N/A -0- 47,007 (47,007) 10.555 7Q53-2113 N/A 24,845 ~2,03~ ~1,934 ~01,05~ 24,845 ~09,043 3],934 ~01,05~8_8 (413,83~) The Accompanying Notes to the Schedule of Federal Financial Assistance Are an Integra] Part of this Schedule, 8 Fund Palance Trsnsfe~ Jun~30, 23,422 23,422 1,025 1,222 3,348 -0- 53,046 53,046 TOWN OF NORTH ANDOVER, NASSACHUSETTS SCHEDULE OF FEDERAL FINANCIAL ASSISTANCE For the year ended June 30, ]986 SCNEDULE I, continued Federa! Grantor Federal Pass-Tbrougb Grantor Catalogue ~o~ram Title Number Department of The Treasur~ Federal Revenue Sharing 21o300 Department of Ilousin~ and Urban Development Community Development Block Grant 14.218 Me[~imac River Access Total IIousing and Urban Development Total Federal Financial Assistance Pass-Through Number Program Bevenue Necoqnize~ or Award Fund Balance Amount ~uly ],1985 Federal State Other 351,267 327,741 E_~x£endJtures Transfers (1) Represents the Harket Value of L~nated U.SoD.A. Co~oditles Lees Actual Costs Incurred Relative to delivery, (2) Includes $31,934 State Expenditures and $272,857 Local Expenditures for a Total of $304,791. The Actual Federal Expenditures Are $795~506~ ~hen the Non- Federal Items Are Factored Out. 24,722 (~30,000! 219 8,695 (100) (794l N/A -0- 44,450 ! 1,540) - 219 53,145 ,- (1,640)_ (794)_ ~2) The Accompanying Notes to the Schedule of Federal Financial Assistance Are an Integral Part of this Schedule. 373,730 P,O20 42,9}D 50,930 TOWN OF NORTH ANDOVER, MASSACHUSETTS NOTES TO SCHEDgLE OF FEDERAL FINANCIAL ASSISTANCE JUNE 30, 1986 (1) Scope of Audit The Town of North Andover, Massachusetts is a governmental agency established by the laws of the Commonwealth of Massachusetts. Ail operations related to the Town's federal grant programs (Community Development Block Grant, Federal Revenue Sharing and Federal Education Grants) are included in the scope of the OMB Circular A-128 Audit Requirements for audits of state and local governments (the Single Audit). The Department of Education has been designated as the Town's cognizant agency for the Single Audit. Compliance testing of all general requirements as described in the Compliance Supplement was performed. Compliance testing of specific requirements was performed for the following grant programs (Designated as "Major" Programs). These represent those with an excess of $300,000 of fiscal 1986 expenditures and cover over 51% of total expenditures and major grant amounts transferred to the general fund. Grant Description Fiscal 1986 Expenditures Federal Revenue Sharing 330,000 Total $ 330,000 (2) Period Audited Single audit testing procedures were performed for Town's federal grant transactions during the year ended June 30, 1986. (3) Summary of Significant Accounting Policies Accounting policies and financial reporting practices permitted for municipalities in Massachusetts are prescribed by the Uniform Municipal Accounting System (UMAS) promulgated by the Commonwealth of Massachusetts Department of Revenue. The significant accounting policies followed by the town are as follows: 10 TOWN OF NORTH ANDOVER, F~ASSACHUSETTS NOTES TO SCHEDULE OF FEDERAL FINANCIAL ASSISTANCE JUNE 30, 1986 (Continued) Basis of Presentation The accompanying schedule of federal financial assistance includes the federal grant transaction of the Town% The receipts and proceeds from federal grants are recorded on the modified accrual basis whereby revenue is recognized when it becomes available and measurable. Disbursements of federal grant funds are recorded on the accrual basis. (4) Findings of Noncomplianc~ The findings of noncompliance identified in connection with the 1986 single audit are disclosed in Schedule I. 11 TOWN OF NORTH ANDOVER, ~SSACHUSETTS SCHEDULE I PROGRAM Federal Revenue Sharing Grant No. 21.300 Federal Revenue Sharing Grant No. 21.300 Federal Revenue Sharing Grant No. 21.300 FINDINGS/NONCOMPLIANCE 1) The Town did not publish the use reports availability (currently Schedule A) in a newspaper of general circulation or approved alternative means within 30 days of filing the report. CFR section 51.13 (a) states that this is a mandatory requirement. The town did not conform to the provisions, as required by recipients of Federal Revenue Sharing funds. Failure of the town to properly monitor its Federal Revenue Sharing program resulted in a noncompliance situation. Assigning grant administrative responsibility to a specific town position would help ensure grant compliance. Therefore, we recommend that the Town designate a job position which would be responsible for federal grant compliance. 2) The town did not give proper notice of the availability of the enacted budget for Federal Revenue Sharing Funds, and its intended uses within 30 days of budget enactment. According to P.L. 92-512 Section 51.13(d) proper notice is required. The town did not conform to the provisions, as required by recipients of Federal Revenue Sharing funds. Failure of the Town to properly monitor its Federal Revenue Sharing program resulted in a noncompliance situation. Assigning grant administrative responsibility to a specific Town position would improve grant compliance. Therefore, we recommend that the town designate a job position which would be responsible for federal grant compliance. 3) The town did not publish an initial notice of nondiscrimination. According to P.L. 92-512, Section 55.15(e) publication of this notice is mandatory. The town did not conform to this provision, as required by recipients of Federal Revenue Sharing funds. Failure of the town to properly monitor its Federal Revenue Sharing program resulted in a noncompliance situation. Assigning grant administrative responsibility to a specific Town position would improve grant compliance. Therefore, we recommend that the Town designate a job position which would be responsible for federal grant compliance. 12 TOWN OF NORTH ANDOVER, MASSACHUSETTS SCHEDULE I (Continued) Federal Revenue Sharing Grant No. 21.300 4) The town did not publish a notice stating that the fiscal 1985 audit was available for public inspection, in a newspaper of general circul@tion or by approved alternative means within 30 days of its completion and receipt by the town. According to P.L. 92-512 Section 51.108(b) this publication is mandatory. The town did not conform to the provisions, as required by recipients of Federal Revenue Sharing funds. Failure of the town to properly monitor its Federal Revenue Sharing program resulted in a noncompliance situation. Assigning grant administrative responsibility to a specific Town position would improve grant compliance. Therefore, we recommend that the Town designate a job position which would be responsible for federal grant compliance. 13 TOWN OF NORTH ANDOVER, MASSACHUSETTS FINANCIAL STATEMENTS AND AUDITOR'S REPORT JUNE 30, 1986 APR O6 1988 TOWN OF NORTH ANDOVER, MASSACHUSETTS TABLE OF CONTENTS JUNE 30, 1986 AUDITOR'S REPORT FINANCIAL STATEMENTS Combined Balance Sheet - All Fund Types And Account Group as of June 30, 1986 Combined Statement of Revenues, Expenditures and Changes in Fund Balance - All Governmental Fund Types and Expendable Trust Funds Statement of Revenues and Expenditures Budget - (Non GAAP Budgetary Basis) and Actual Exhibit Pa_~ i 4 2 6 3 8 Statement of Revenues, Expenses and Changes in Fund Balance - Non- expendable Trust Funds 4 9 Statement of Changes In Financial Position - Non-expendable Trust Funds 5 10 NOTES TO FINANCIAL STATEMENTS SUPPLEMENTAL INFORMATION SCHEDULE OF RECONCILIATION OF TREASURER'S CASH SCHEDULE OF TAXES, LIENS, EXCISES, DEPARTMENTAL ACCOUNTS RECEIVABLE - ALL FUNDS STUDY AND EVALUATION OF INTERNAL CONTROL SYSTEM Schedule II 11 Page 22 23 STEPHEN W. KIDDER COMMISSIONER EDWARD J. COLLINS, JR. DEI=UTY COMMISSIONER Board of Selectmen Town of North Andover North Andover, Massachusetts 01845 Honorable Selectmen: We have examined the general purpose financial statements of the various funds of the Town of North Andover, Massachusetts as of and for the year ended June 30, 1986, as listed in the table of contents. We made o~r exam/nation in accordance with generally accepted government auditing standards for financial and compliance audits and included such tests of the accounting records and such other auditing procedures, including tests of compliance with applicable laws and regulations, as we considered necessary in the circumstances. Pension costs are provided on a "pay-as-you-go" basis, as discussed in Note 5 to the accompanying financial statements, instead of an actuarial basis as required by generally accepted accounting principles. The amount of such costs under generally accepted accounting principles is not determinable at this time. The town has not maintained historical cost records of its property, plant and equipment. Accordingly, the combined financial statements referred to above do not include a general fixed asset group which should be presented to conform with generally accepted accounting principles. In our opinion, except for the effect of not providing for pension costs on an actuarial basis, and except that the omission of the financial statements of the town's general fixed assets results in an incomplete presentation as explained previously, the general purpose financial statements referred to above present fairly the financial position of the Town of North Andover, Massachusetts at June 30, 1986 and the results of its operations and the changes in financial position of its non-expendable trust funds for the year then ended in conformity with generally accepted accounting principles applied on a basis consistent with that of the preceding year; for the reporting entity as described more fully in note 1 to the general purpose financial statements. Our examination was made for the purpose of forming an opinion on the general purpose financial statements taken as a whole. The accompanying financial information, listed as a schedule in the table of contents, is presented for purposes of additional analysis and is not a required part of the general purpose financial statements of the Town of North Andover, Massachusetts. The information has been subjected to the auditing procedures applied in the examination of the general purpose financial statements and, in our opinion, is stated fairly in all material respects in relation to the general purpose financial statements taken as a whole. February 27, 1987 Very Truly Yours, Acting Director, Bureau of Accounts Department of Revenue Assets Cash and cash equivalents Beceivables: Property taxes E~ises Water user charges Sewer user charges Departmental Special assessments Tax liens & foreclosures Eue from collector Due frcm other goverrm~nts Due frem other funds Amounts to be provided for: Payment of bonds Total assets Liabilities Warrants payable Witholdings payable Due to other f~nds Other liabilities Deferred revenues: Proper ty ta~s Other receivables Notes payable Bc~ds payable Total liabilities June 30, 1986 General Fiduciary Goverm~ntal Fun~ ~ Fund T~pes Special Capital Trust & B{-~ven~ Projects Agency Account G~oup Debt $4,947,108 $424,860 $ $507,621 $ 1,414,393 302,626 71,890 141,157 2,677 124,430 58,014 34,654 372,038 69,047 393,318 185,610 79,404 $7,468,987 $887,225 ~185,610 $587,025 4,675,000 $4,675,000 542,933 86,352 658,332 773,006 960,487 564,405 147,000 3,732,515 100 100 65,497 65,497 4,675,000 4,675,000 ~ogibit 1 Totals ~%m~randum Only) $5,879,589 1,414,393 302,626 71,890 141,157 2,677 124,430 58,014 34,654 441,085 658,332 4,675,000 f~13,803,847 $ 543,033 86,352 658,332 65,497 773,006 960,487 564,405 147,000 4,675,000 8,473,112 General f~ohibit 1, {x~ntinued Special Capital Trust & ~venue Projects Agency In.g-Term Totals 04~orandu~ Only) Reserved for encu~br~ Be. served for extraordinary or unforseen expenditures Unreserved fund balance: Designated Undesignated Total fund equity 1,292,787 12,065 1,866,084 565,536 3,736,472 330,000 185,610 (27,402) 557,125 548,930 887,125 185,610 521,528 1,292,787 12,065 2,354,292 1,671,591 5,330,735 Total liabilities and fund equity $7,468,987 $887,225 $185,610 $587,025 $4,675,000 $13,803,847 see accc~panying notes to financial statements 5 Emhibit 2 Property taxes E~ises ~ater charges for services Sewer charges for services Other charges for services Departmental Intergoverm~tai- £ederai Intergoverm~ental - state F/nes and forfeits Earnings on investments Total revenues Fiduciary Fund Types $12,845,867 1,276,660 829,475 356,162 657,093 268,779 49,254 3,652,275 16,102 113,815 128,352 Special Capital E~pemfable la=venue Projects ~usts $ $ $ 30,645 396,788 1,098,920 26,982 20,193,834 1,553,335 17,261 17,261 T~tals ~$~randu~ Only) $12,845,867 1,276,660 829,475 356,162 657,093 299,424 49,254 396,788 4,751,195 16,102 113,815 172,595 21,764,430 Expenditures: C~J~r al government Public safety Education Public ~rks Water and sewer ~ services Gulture and recreation Intergoverrm~ntal charges ~q:loyee benefits Betir~ment oc~tribution Capital outlay G~rt ju~mts Total expenditures 981,272 2,839,658 9,307,981 1,886,596 708,950 556,167 487,163 818,716 511,556 464,000 607,590 324,563 63,487 19,557,699 44,129 342,095 861,091 98,229 1,018 128,780 1,475,342 199,982 72,305 908,472 854,496 2,035,255 1,025,401 3,381,735 10,241,377 1,984,825 1,617,422 300 556,467 488,181 818,716 640,336 464,000 607,590 324,563 854,496 63,487 300 23,068,596 E~ess (deficiency) of revenues over expenditures 636,135 77,993 6 (2,035,255) 16,961 (1,304,166) Exhibit 2, continued. TU~N OF N0~I~ A~IXI~, M~S~&I~3SE~TS ~ ~ C~ ~, EXPI~D~ ~ ~ IN Ft~D ~ ALL ~ ~ T~T~S AND EXP~I~.~. T~3ST Fd~S For the year ended Jt~e 30, 1986 Other financing sources (uses): Proceeds of notes Operating transfers in Operating transfers out Total other financing sources (uses) Excess (deficiency) of revenues and other financing sources ~o~er ex~tures and other uses Ft~d balance July 1, 1985 Fund balance June 30, 1986 Fund TlTes Fiduciary Fund ~A~S Special Capital Ex~ ~ble Totals General I~venue Projects Trusts ~morandum Only) 1,418,500 1,418,500 10,859 109 200,000 210,968 (200,109) (10,859) ~10,968) (189,250) (10,750) 1,418,500 200,000 1,418,500 446,885 67,243 (616,755) 216,961 114,334 3,289,587 819,882 802,365 43,472 4,955,306 $3,736,472 $887,]25 $185,610 $260,433 $5,069,640 See acompanying notes to financial statements 7 Exhibit 3 For the year ended June 30, 1986 Bevenues and other sources: Original Final Budget Budget Actual Variance Favorable f~fa~rable) P:oper t¥ taxes Excises Water charges for services Se~r charges for services Disposal charges for services Departmental Intergovernmental- federal Intergovernmental - state Fines and forfeits ~rnings on investments Other available funds $12,171,187 $12,210,529 $12,204,480 $ (6,049) 889,176 889,176 1,276,660 387,484 802,580 802,580 829,475 26,895 366,738 366,738 356,162 (10,576) 596,424 596,424 657,093 60,669 286,917 286,917 299,424 12,507 50,090 50,090 49,254 (836) 330,000 330,000 396,.788 66,788 3,589,598 3,589,598 4,751,195 1,161,597 21,680 21,680 16,102 (5,578) 87, 4 79 87,4 79 1/3,815 26,336 150,362 150,362 155,334 4,972 372 372 0 (372) 1,016,129 1,193,866 1,193,866 0 Total revenues and other 20,358,732 20,575,811 22,299,648 1,723,837 E~penditures and other uses: General goverr~ent Public safety ~ucaticn Public works Water and sewer Baman services Culture and re(~eation Debt service Intergove~tal fmployee benefits O~rt j~ts 1,226,039 1,226,039 1,122,429 103,610 3,165,286 3,231,495 3,186,021 45,474 9,563,421 9,713,421 10,567,861 (854,440) 1,541,352 1,541,352 1,634,981 (93,629) 894,514 894,514 847,066 47,448 443,794 444,664 556,167 (11 ] ,503) 491,382 491,382 489,685 1,697 1,017,120 1,017,120 818,716 198,404 523,774 523,774 639,318 (115,544) 464,000 464,000 464,000 0 640,000 640,000 607,590 32,410 324,563 324,563 324,563 0 63,487 63,487 63,487 0 20,358,732 20,575,811 21,321,884 E~cess of revenues and other sources over ~g3enditures and other uses $ 0 $ 0 $977,764 See accompanying notes to financial statements 8 ~746,073) $977,764 Exhibit 4 TOWN OF NORTH ANDOVER, MASSACHUSETTS STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN FUND BALANCES NON-EXPENDABLE TRUST FUNDS For the year ended June 30, 1986 ~du~iar~ Fund Types Non-expendable Trust Funds Revenues: Earnings on investments Gifts Total revenues 28,678 10~000 38,678 Fund Balance July 1, 1985 Fund Balance June 30, 1986 222,417 See accompanying notes to financial statements. TOWN OF NORTH ANDOVER, MASSACHUSETTS STATEMENT OF CHANGES IN FINANCIAL POSITION NON-EXPENDABLE TRUST FUNDS For the year ended June 30, 1986 Exhibit 5 Sources of Working Capital: Net income Net increase in working capital Elements of net increase in working capital: Cash Net increase in working capital Fiduciary Fund Types Non-expendable Trust Fund 38,678 $ 38~678 See accompanying notes to financial statements. 10 TOWN OF NORTH ANDOVER, MASSACHUSETTS NOTES TO FINANCIAL STATEMENTS JUNE 30, 1986 1.Summary of Significant Accounting Policies A. Reporting Entity The accompanying financial statements present the financial position of the various funds and account group of the Town of North Andover as of June 30, 1986. Also included are the funds of the Community and Economic Development Agency over which the town exercises oversight responsibility. Criteria used for defining oversight responsibility and determining whether a component unit is included in the financial statements are: selection of governing authority, designation of management, ability to significantly influence operations, accountability for fiscal matters and scope of public service. The inclusion of component units in the town's financial statements does not affect their separate legal standing. B. Basis of Presentation-Fund Accounting The accounts of the town are presented 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 in a set of self-balancing accounts that comprise its assets, liabilities, fund equity, revenues, expenditures or expenses and other financing sources and uses. The various funds and account groups are grouped by fund categories and fund types as follows: Governmental Funds. Governmental funds are those through which most governmental functions are typically financed. The acquisition, use, and balances of the government's expendable financial resources and the related current liabilities- except activities accounted for in proprietary funds - are accounted for through governmental funds. The governmental funds maintained by the town are as follows: General Fund - is the general operating fund of the town. It is used to account for all financial resources except those required to be accounted for in another fund. Special Revenue Funds - are used to account for the proceeds of specific revenue sources (other than expendable trusts of major capital projects) that are legally restricted to expenditure for specified purposes. General funds of component units are also included with special revenue funds. Capital Projects Funds - are used to account for financial resources to be used for the acquisition or construction of major capital facilities (other than those financed by special assessment, proprietary or trust funds.) 11 TOWN OF NORTH ANDOVER, MASSACHUSETTS NOTES TO FINANCIAL STATEMENTS JUNE 30, 1986 SUMMARY OF SIGNIFICANT ACCOUNTING POLICIESt continued ~iduciar~ Funds. Fiduciary funds are used to account for assets held by the Town in a trustee capacity or as an agent for individuals, private organizations, other governmental units, and or other funds. Fiduciary funds maintained by the Town are as follows: Expendable Trust Funds - are used to account for trust fund principal and income that may be expended in accordance with conditions of the trust. Expendable trust funds are accounted for in'essentially the same manner as governmental funds. Nonexpendable Trust Funds - are used to account for trusts where the principal must remain intact. Generally income earned on non-expendable trust principal may be expended in accordance with the conditions of the trust. Non-expendable trust funds are accounted for in essentially the same manner as proprietary funds. Account Group. The Account Group is used to establish accounting control and accountability for the Town's unmatured principal of it's general long term-debt. C. Basis of Accountin~ Basis of accounting refers to when revenues, expenditures, expenses, and transfers are recognized in the accounts and reported in the financial statement. The modified accrual basis of accounting is followed in governmental funds and expendable trust funds. Revenues are recognized in the accounting period in which they become measurable and available to finance expenditures of the current period. "Available" is defined as collectible within the current period or soon enough thereafter to be used to pay current liabilities. Expenditures are recognized when the related liability is incurred, except for unmatured interest on general long term debt which is recognized when due. Liabilities are not considered current until they are normally expected to be liquidated with expendable available financial resources. Liabilities incurred in the current period not expected to be liquidated with expendable available financial resources are recorded in the General Long-Term Debt Account Group. The accrual basis of accounting is followed in non-expendable trust funds. Revenues are recognized when earned and expenses are recorded when incurred. 12 TOWN OF NORTH ANDOVER, MASSACHUSETTS NOTES TO FINANCIAL STATEMENTS JUNE 30, 1986 SUMMARY OF SIGNIFICANT ACCOUNTS~ continued D. Budgetary Data An annual budget is adopted for the Town's general operations. Although, legislative approval is required for acceptance of certain grants, capital project and borrowing authorization, no annual budget .is prepared for any other fund and therefore, comparison of budget to actual is only presented for the general operations. The Town's annual budget is adopted on a statutory basis that differs in some respects from Generally Accepted Accounting Principles (GAAP). The major differences are that Real and Personal Property Taxes are recognized as revenue when levied and that encumbrances are treated as budgetary expenditures in the year the commitment is made. Also, certain appropriations, known as special articles, do not lapse and for financial presentation are treated as budgetary expenditures in the year they are authorized. Budgets are prepared by the Board of Selectmen and approved by Town Meeting. The town must establish its property tax rate each year so that the property tax rate levy will comply with the limits established by Proposition 2 1/2, as amended, and also equal the sum of (a) the aggregate of all annual appropriations for expenditures, plus (b) provision for prior year deficits, if any, less (c) the aggregate of all non-property tax revenues estimated to be received, and authorized available funds. Supplemental appropriations may be made from available funds after the setting of the tax rate. Appropriations may be transferred between departments with town meeting approval. E. Assets~ Liabilities and Fund Equity Cash and Cash Equivalents. Cash balances are invested to the extent available and interest income is recognized in the General Fund. Certain special revenue funds and fiduciary funds cash are segregated and investment income becomes a part of those funds. Accounts Receivable. Accounts receivable are recorded when billed. Abatements and exemptions are estimated based on historical records in the Assessor's department. 13 TOWN OF NORTH ANDOVER, MASSACHUSETTS NOTES TO FINANCIAL STATEMENTS JUNE 30, 1986 SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES~ continued Interfund Receivables and Payables. Due from/Due to Other Funds arise during the course of operations from the pooling of cash and as funds provide services to each other. Due From Other Governments. Due from other governments include amounts due from grantor agencies for specific programs and capital projects. Intergovernmental receivables are recorded when approved contracts or agreements are received. Inventories. Inventories of governmental funds are recorded as expenditures at time of purchase. Accrued Sick and Vacation. Employees are granted sick and vacation leave in varying amounts based on tenure and in accordance with individual union contracts. Upon termination, retirement or death, certain employees are compensated for unused vacation and sick leave (subject to certain limitations) at their current rates of pay. The cost of sick and vacation pay is recorded when expended and future benefits payable are not determined. Deferred Revenue. In Governmental Funds amounts that are not considered available are deferred until collected. Under the modified accrual basis of accounting, such amounts are measurable but not available. Real and Personal Property Taxes. Real and Personal Property Taxes are based on assessed values as of the previous January 1 and are normally due on November 1 and May 1. By law, all taxable property must be assessed at 100% of fair cash value. Taxes due and unpaid after the due dates are subject to interest and penalties. The Town has an ultimate right to foreclose on property for unpaid taxes. Property taxes are recorded as revenue in the accounting period that they become measurable and available. Available for property taxes means expected to be collected within 60 days after the end of the fiscal year, except under unusual circumstances. Total Columns on Combined Statements. Total columns on the combined statements are captioned "Memorandum Only" to indicate that they are presented only for informational purposes. Adjustments to eliminate interfund transactions have not been made and data in these columns do not present financial position or represent consolidated information. 14 TOWN OF NORTH ANDOVER, MASSACHUSETTS NOTES TO FINANCIAL STATEMENTS June 30, 1986 SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES~ continued 2. BUDGETARY DATA Budgetary data is based upon accounting principles that differ from generally accepted accounting principles. Therefore, in addition to the GAAP basis financial statements, the results of the general fund is presented in accordance with budgetary accounting principles to provide a meaningful comparison with the budget. The following reconciliation summarizes the differences between GAAP and budgetary basis accounting principles for the General Fund for the year ended June 30, 1986: 15 TOWN OF NORTH ANDOVER, MASSACHUSETTS NOTES TO FINANCIAL STATEMENTS June 30, 1986 As reported on a GAAP basis, (Exhibit 2) Adjustment of Real and personal prop- erty taxes from a modified accrual to an accrual basis Transfer to expendable trust fund Reclassification of activities from special revenue Reclassification of other available funds previously reflected on a GAAP basis Adjustment for expenditures, accruals and encumbrances, net As reported on a budgetary basis, (Exhibit 3) Revenues 20,193,834 (641,387) Expenditures 19,557,699 Other Financing Sources (Uses) (189,250) 200,000 Excess (defici- ency) of Revenue and Other Sources Over Expenditures and Other Uses 446,885 (641,387) 200,000 1,553,335 1,475,342 (10,750) 67,243 288~843 1,193,866 22,299,648 ~ 21,321,884 ~ -0- 1,193,866 ,,(~88t843) 16 TOWN OF NORTH ANDOVER, MASSACHUSETTS NOTES TO FINANCIAL STATEMENTS JUNE 30, 1986 3. TEMPORARY BORROWINGS Under State law, and with the appropriate local authorization, the Town is authorized to borrow funds on a temporary basis as follows: * To fund current operations prior to the collection of revenues, by issuing revenue anticipation notes (RANS). * To fund grants prior to reimbursements, by issuing grant anticipation notes (GANS). * To fund capital project costs incurred prior to selling permanent debt by issuing bond anticipation notes (BANS). Temporary loans are general obligations of the town and maturity dates are governed by statute. Interest expenditures for temporary borrowings were %66,938 and are accounted for in the General Fund. Outstanding July 1, 1985 Issued Matured Outstanding June 30, 1986 Interest Rates RANS BANS GANS 4.24%-5.00% -o- 1,3o3,5oo 4.00%-5.69% 5,000,000 -O- 5~O00yO00 1~303y500 147,000 147,000 17 TOWN OF NORTH ANDOVER, MASSACHUSETTS NOTES TO FINANCIAL STATEMENTS JUNE 30, 1986 4. LONG TERM DEBT A summary of the changes in general long-term debt during the year is as follows: 18 TOWN OF NORTH ANDOVER, MASSACHUSETTS NOTES TO FINANCIAL STATEMENTS JUNE 30, 1986 Serial Matur- ities through Bonds: General Purpose Schools Public Works 1996 1991 1987 Interest Outstandtng Rates July 1. 1985 Additions 6.2558~ ~ -0- $ 2,575,000 4.50-5.25% 2,365,000 -0- 4.00-9.20~, 365~000 -0- $ 2_730 000 $ 2.575 000 Outstanding Reductions June 30~ 1986 -0- $ 2,575,000 445,000 1,920,000 185m000 180sO00 630000 $ 4_675 000 1SA TOWN OF NORTH ANDOVER, MASSACHUSETTS NOTES TO FINANCIAL STATEMENTS JUNE 30,1986 The annual requirements to amortize all outstanding bonds, including interest, as of June 30, 1986 are as follows: Year ended June 30, Principal Interest Total 1988 720,000 209,136 929,136 1989 660,000 168,374 828,374 1990 655,000 130,826 785,826 1991 590,000 93,589 683,589 1992-96 11110~000 2~.4~835 1~314e835 4,675,000 i 073_11 . The town is subject to debt limits by law. Such limits are equal to 5% and 10% of the equalized valuation of taxable property and are known as debt issued inside and outside the debt limit respectively. Authorizations for debt outside the debt limit must be approved by the State Emergency Finance Board. 19 TOWN OF NORTH ANDOVER, MASSACHUSETTS NOTES TO FINANCIAL STATEMENTS JUNE 30, 1986 4. LONG TERM DEBT~ continued Az of June 30, 1986 the town may issue $35,082,786 and $70,455,572 in additional debt inside the debt limit. The town has authorized and unissued debt of $2,550,000 inside the debt limit and $11,210,000 outside the debt limit as of June 30, 1986. The town pays assessments under formulas which include debt service payments to other governmental agencies providing services to the town, (commonly referred to as overlapping debt). The following summary sets forth the long term debt of such governmental agencies and the estimated share being financed by the town as of June 30, 1986. Agency Greater Lawrence Sanitary District Essex County Greater Lawrence Regional Vocational Technical High School District Total Long- Town's Town's Term Debt Estimated Indirect Outstandin~ Share Debt 3,014,925 9.7% $ 292,977 1,868,326 4.3% 80,338 600,000 5.0% 30,000 5. Pension Plan Substantially all employees of the town, except school teachers and certain other school department employees are members of the Essex County Contributory Retirement System. The pension plan provides retirement benefits for members who have obtained a certain age and for periods of service. Members contribute certain percentages of their salaries or wages to the plan. In addition, the Massachusetts Public Employees Retirement Administration determines an amount, each year, that the town must contribute to the system in order to meet that year's projected benefit payments. The town's contribution to the system for the year 1986 amounted to $607,590. 20 TOWN OF NORTH ANDOVER, MASSACHUSETTS NOTES TO FINANCIAL STATEMENTS JUNE 30, 1986 5. Pension Plan, continued This so called "pay-as-you-go" method does not provide for the funding of any unfunded liabilities that might exist as a result of an actuarial determination of the fiscal condition of the plan. The amount of the unfunded liability of the Essex County Contributory Retirement System is actuarially determined periodically and reported to the County by the Massachusetts Retirement Law Commission. However, the amount of such liability directly related to the members from the Town of North Andover has not heretofore been separately determined and remains unknown. The school teachers and other non-member school department employees participate in a plan administered by the Massachusetts Teachers' Retirement Board. The town does not directly contribute to this plan. 6. ~ontin~ent Liabilities- In the opinion of the Town's administration there are no contingent liabilities that will result in a material loss to the town. 21 TOWN OF NORTH ANDOVER, MASSACHUSETTS Schedule I SCHEDULE OF RECONCILIATION OF TREASURER'S CASH JUNE 30, 1986 General Fund $ Special Revenue Trust Funds in Custody of Treasurer Trust Funds in Custody of Lib- rary Trustees Checking Accounts: Balance July 1, 1985 %eceipts Disbursements 5,793,825 $ 41,755,063 ~ 42,601,780 297,129 466,158 338,427 Balance June 30~ 1986 ~4,947,108 424,860 82,881 229,863 1,060 311,684 168~ 802 37r 986 10r 851 Balance Classified by Depository: Arlington Trust Company Bank of New England Bay Bank - Merrimack Valley Century Bank and Trust Company Essex Bank Savings Accounts: Arlington Trust Company Bank of New England Bay State Bank Boston Safe Deposit Century Bank and Trust Community Savings Bank Essex Bank Massachusetts Municipal Depository Trust Merrimack Valley Patriot Bank State Street Bank and Trust United States Trust Cash on hand Trust Funds in custody of Treasurer -various banks Trust Funds in custody of Library Trustees -Merrill Lynch cash management account 22 Variance i95~937 1,217,521 323,040 52,418 1 17,915 200,000 233,762 200,000 44,591 132,758 18,170 200,000 1,100,440 378,270 240,816 26,833 948,978 35,508 311,684 195~937 5,878,642 947 Property Real l~state Taxes: Levy OE 1986 Levy of 1985 Levy of 1984 Levy of 1983 Levy of 1982 Levy of 1981 Levy of 1980 Levy of 1979 Levy of 1978 Perscnal Property Tax: Levy of 1986 Umollec~d July 1, 1985 $ 358.155 122,145 38,788 7,270 (1,215) 595 (171) 6 Levy of 1985 1,597 Le~y of 1984 943 Levy of 1983 758 Levy of 1982 431 Levy of 1981 679 Levy of 1980 862 Levy of 1979 1,336 Levy of 1978 1,]/3 Levy of 1977 644 Levy of 1975 33 TUNN OF NO~TH ANDO~ER, M%SSAC~USEITS ~ OF ~(ES, LI]~4S, EXCISES, ~, ~ ~~ ~~S ~r ~e ~r ~ J~e 30, 1986 ~sfers ~ ~j~t~ ~~ ~j~n~ ~ll~ible $12,354,704 $ Collect i~s Net of refunds 210,290 $ ~ $ 12.564.994 $ 126,125 11,992 7,735 6,740 361 (827) (1) 152,]25 23 $ 12,228,579 346,163 114,410 32,048 7,270 (1,215) 595 (171) 6 10,999,333 232,938 67,382 22,983 3,386 Uncollected June 30, 1986 $ 1,229,246 113,225 47,028 9,065 3,884 (1,215) 595 (171) 6 SC~EU3LE II ~hcollected per detail June 30, 1986 $1,234,236 120,260 54,739 24,626 4,754 209,929 205,228 4,701 2,424 995 1,429 1,404 943 943 1,034 758 758 1,120 431 431 504 679 679 678 862 862 897 1,336 200 1,136 1,010 1,113 1,113 1,096 644 644 655 $ 12 946-838 $ 31.532,445 M~tor Vehicle E~cise: Levy of 1986 Levy of 1985 Levy of 1984 ~ of 1983 Levy of 1982 Levy of 1981 Levy of 1980 Levy of 1979 Le~y of 1978 Levy of 1977 Levy of 1976 Levy of 1975 Levy of 1974 fsvy of 1973 Levy of 1972 Farm Animal E~ise: Levy of 1986 Levy of 1985 Levy of 1984 Levy of 1980 Levy of 1979 ~ of 1977 Forest Land: Levy of 1984 Levy of 1983 Levy of 1982 Levy of 1981 Unaollected July 1, 1985 $ 188,499 31,013 18,351 7,749 3,881 10,702 3,756 6,426 1,975 1,510 80O 597 170 165 (59) 96 69 313 2].3 3 $ 276,528 For the year ended June 30, 1986 $ 934,357 362,065 1,341 i~atements Transfers and ~djusted ~djus~ments Gollectible $ (47,223) 31,144 1,023 (59) 219 713 9,990 Gollectio~s Net of refunds $ 981,580 $ 800,156 519,420 459,021 31,331 12,202 18,410 918 7,530 313 3,168 439 712 706 3,756 917 6,426 703 1,975 436 1,510 47 8OO 597 170 165 803 8O3 (59) 154 96 69 41 8O3 $ 1~298,566 (4,193) 313 213 3 104 $ 1,579,287. $ 1,,276,661 SC~EI~3[E II, continued Unaollected June 30, 1986 Uncollected per detail J~ne 30, 1986 $ 181,424 $ 188,475 60,399 33,494 19,129 11,707 17,492 7,354 7,217 11,224 2,729 5,048 6 3,668 2,839 4,386 5,723 1,979 1,539 1,519 1,463 1,673 800 927 597 622 170 453 165 165 (59) 154 96 96 69 69 41 313 213 3 104 302t626 104 $ 272.963 24 ~ CF NORI~ A~I~;ER, M~SSA~ SC~fDULE II, c~ntinued For the year ended June 30, 1986 Tax Liens Tax Foreclosures Water Liens: Levy of 1986 Levy of 1985 Levy of 1984 Levy of 1983 Levy of 1982 Le~y of 1981 Levy of 1980 Levy of 1979 Sewer Liens: Levy of 1986 Levy of 1985 Levy of 1984 Levy of 1983 Levy of 1981 Levy of 1980 Levy of 1979 Unool lected July 1, 1985 ftm~itments $ 22,406 $ 8,494 22,860 2,8].0 1,346 2,328 35 68 (88) (~2) 18,560 1,534 754 2,436 (225) 136 $ 41,826 $ 41,420 Abatements Transfers and ~djusted Adjustments Gollectible (29,874) $ 52,280 8,494 201 22,659 47 2,763 1,346 2,328 35 68 (88) (132) 201 18, 359 47 1,487 754 2,436 (225) (76) 136 (29,378) $ 112,624 fbllections Net of refunds 16,270 16,886 1,132 405 1,923 14,573 1,058 344 2,019 54,610 t~collected June 30, 1986 Um~llected per detail June 30, 1986 36,010 $ 36,010 8,494 8,494 5,773 6,181 1,631 1,637 941 597 405 200 35 35 (88) (132) 3,786 4,093 429 569 410 164 417 127 (225) (76) 136 58,014 $ 58,107 User (barges.- Water Pates Water O~nstructicn $ 66,242 8O2 $ 67,044 983,493 7,744 991,237 Sewer Oc~structicn $ 3,844 $ 1,885 Sewer Pates 53,707 428,664 $ 1,256 $ 1,048,479 (23,041) 31,587 $ (_21,.785) $ 1,080,066 $ (39) $ 5,768 8,814 473,557 $ 994,246 13,930 $ 1,008,176 $ 4,883 333,285 54,233 $ 56,458 17,657 2,400 71,890 $ 58,858 885 $ 453 140,272 45,953 Departmental: Veterans Benefits $ $ 57,551 2,677 $ 430_!~m~549 $ 8,775 25 $ 4--79,325 $ 2,677 $ 338,168 $ !41t157 $ 4.6,406 Un~11~ July 1, 1985 TCH~ OF NC~I~ ANEO~E~, MASSA~ SC~EIXJLE OF TAXES, LI~qS, EXCISES, ~T[~, AND E~P~ ~CEIVABLES ~br the year ended June 30, 1986 Transfers and Adjusted Ck~mitments Adjustments Cbllectible Special Assessments: Sewer Assessment ~ded to Ta~es: Levy of 1986 Le~y of 1985 60 Levy of 1983 80 Levy of 1982 54 Paid in Advance (2,455) Unappor tioned Sewer: 17,539 Water Asses~nt Added to Taxes: Levy of 1986 Levy of 1985 423 Levy of 1984 180 Unapporti~ned Water: 39,840 Levy of 1986 Paid in advance (1,539) Interest: 1986 1985 240 1984 9 1983 473 1982 2 1981 79 Appor ticx~d Sewer as~t Not Due 54,081 Chapter 380 - Deferred Sewer Assessments 6,523 Suspended Water Wain ~ts 25,020 Chapter 80 - Deferred Drain Oollecticns Net of refunds $ 8,330 $ $ 8,330 $ 60 80 54 2,455 17,539 7,427 9O SCHI~ULE II, continued Uncollected June 30, 1986 thoollected per detail J~ 30, 1986 903 60 (10) 54 17,539 1,005 150 17,029 3,181 (105) 3,286 2,825 461 529 (252) 675 600 75 180 180 39,840 1,740 38,100 30,790 68 68 (1,539) 2,557 116 9 2,508 68 3,086 169 18,514 2,183 (1,283) $ 19,226 26 2,508 2,917 240 9 473 2 79 35,567 4,340 27,528 1,283 8 360 124 473 2 79 35,567 4,340 25,020 1,215 124,430 466 48 19,222 30,805 25,020 1,215 $ 126,279 $ 140,609 $~ $ 142,,550 $ ~8,120