Loading...
HomeMy WebLinkAbout1997-1998.AuditReportBegley, Janssen, Young & Birk, LC CERTIFIED PUBLICACCOUNTANTS 2103THEMIS ST -CAPE GIRARDEAU, MISSOURI 63701 -TELEPHONE (573) 3342845 FAX (5]3) 3344338 PARTNERS JOHN I JANSSLN. CPA JENNIFER WES-RiCH. CPA IF RIRY Il. 3FGI FY. CPA JEFF UNTERREINER. CPA I A'AHrNCF F.YOUNG. CPA CATHERINE A. WIIITF. CPA KELVIN W. NIHK CPA Honorable Mayor, Members oft lie City Council, and Senior Management City of Cape Girardeau, Missouri In planning and performing our audit of the general purpose financial statements of the City of Cape Girardeau, Missouri (tile "City"), for the year ended June 30, 1998, we considered its internal control structure in order to detelnine our auditing procedures for the purpose of expressing our opinion on the general purpose financial statements and not to provide assurance on the internal control structure. However, we noted a certain matter involving the internal control structure and its operation that we consider to be a reportable condition under standards established by the American Institute of Certified Public Accountants. Reportable conditions involve matters coming to nun attention relating to significant deficiencies in the design or operalion of the internal control structure that, in our judgment, could adversely affect the City's ability to record, process, SUllllnarl)e, and report financial data consistent with the assertions of management in the general purpose financial statements, The purpose of this letter is to communicate the reportable condition and other matters that weleel will help to improve t he design and operation ofthe internal control structure of the CJfy, but That we do not feel meet the definition Ufa reportable condition. Remrlable Condition Our audit revealed that the cashier and bookkeeping functions are not properly segregated in the Municipal Court Department The newly installed computer software allows the individual responsible for collecting cash the ability to access and change the amount of the fine. Proper segregation of duties does not allow the person collecting funds to change the recorded amount of the fine We recommend that the City utilize the computer system controls to limit the cashier's access to change the amount of offender fines recorded in the computer system. Other Comments and Recommendations Having audited the City for seven years, we have hecome increasingly aware of the unequal distribution of work in the finance department. An excess workload on some personnel is a deterrent Ili controlling the quality and timeliness of the work produced. Each year our audit field work begins and is therefore completed at a later date due to an overabundance of demands fur the attention of sonic personnel. We suggest that the council and/or finance director review the allocation of job duties and responsibilities and determine if any of the duties and I esponsibili lies can be redistributed among the finance department employees. Another solution is adding additional personnel to the finance department to absorb some of the duties of employees with an excess workload. hn our opinion, this redistribution of work will result in higher quality output and more timely information. I lonorable Mayor, Members of the City Council, and Senior Management City of Cape Girardeau, Missouri Page 2 A material weakness is a reportable condition in which the design or operation of one or more of the internal control structure elements does not reduce to a relatively low level the risk that errors or in egularities in amounts that would be material in relation to the general purpose financial statements being audited may occur and not be detected within a timely period by employees in the normal course of performing their assigned functions_ Our consideration of the internal control structure would not necessarily disclose all matters in the internal control structure that might be reportable conditions, and, accordingly would not necessarily disclose all reportable conditions that are also considered to be material weaknesses as defined above_ However, the reportable condition described above is not believed to be a material weakness. This report is intended solely for the information and use of lire Honorable Mayor, Members of the City Council, management, and others within the administration. However, this report is a matter of public record, and its distribution is not limited. ay-e�(, /J - ' Begley, Janssen, Young, and Birk, LC December 3, 1998 FINANCIAL STATEMENTS AND INDEPENDENT AUDITORS` REPORT June 30, 9998 C CONTENTS FINANCIAL SECTION Page Independent Auditors' Report 7 GENERAL PURPOSE FINANCIAL STATEMENTS Combined Balance Sheet - All Fund Types and Account Groups 10 r Combined Statement of Revenues, Expenditures and Changes in Fund Balance - All Governmental Fund Types 12 .. Combined Statement of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual (Budget Basis) - All Governmental Fund Types 13 Combined Statement of Revenues, Expenses and Changes in Retained Earnings - A1.1 Proprietary Fund Types 1.5 Combined Statement of Cash Flows - All Proprietary Fund Types 16 Notes to Financial Statements 1.7 COMBINING AND INDIVIDUAL, FUND FINANCIAL STATEMENTS GENERAL FUND _ Comparative Balance Sheet 60 Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 61 SPECIAL REVENUE FUNDS combining Balance Sheet 62 combined Statement of Revenues, Expenditures and Changes in Fund Balance 63 .. Convention/visitors Special Revenue Fund Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 64 CONTENTS - CONTINUED SPECIAL REVENUE FUNDS - Continued Airport Special Revenue Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 65 Downtown Business Special Revenue Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 66 Parks and Recreation Special Revenue Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 67 Health Special Revenue Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 68 Motor Fuel Tax Special Revenue Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) Fig Capital Improvement Sales Tax Special Revenue Fund - Flood Control Projects Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 70 Capital Improvement Sales Tax Special Revenue Fund - Water Projects Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 71 Transportation Sales Tax Trust Special Revenue Fund - Schedule of Revenues and Expenditures - Budget. and Actual (Budget Basis) 72 Flood Protection Special Revenue Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 73 Vision 2000 Special Revenue Fund - r Schedule of Revenues and Expenditures - Budget and. Actual (Budget Basis) 74 ^ DEBT SERVICE FUND Debt Service Fund - Comparative Balance Sheet 75 0 CONTENTS - CONTINUED CAPITAL PROJECTS FUND Combining Balance Sheet 76 Combining Statement of Revenues, Expenditures and Changes in Fund Balance 77 General Capital Improvement Fund - Schedule of Revenues and Expenditures - ,� Budget and Actual (Budget Basis) 78 Corp Flood Control Capital Project Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 79 .. Street Improvements Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 84 FAU Street Grants Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 81 W Community Development Block Grant Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 82 Park Improvements Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 83 water Improvement Projects - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 84 ENTERPRISE FUNDS Combining Balance Sheet 85 Combining Statement of Revenues, Expenses and Changes in Retained Earnings 86 Combining Statement of Cash Flows 87 Sewer Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 88 CONTENTS - CONTINUED W Water Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 89 Solid Waste Fund .. Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 90 Golf Course Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 91 y Softball Complex Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 92 r INTERNAL SERVICE FUNDS Combining Balance Sheet 93 Combining Statement of Revenues, Expenses and Changes in Retained Earnings 94 Combining Statement of Cash Flows 95 Data Processing Fund W Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 96 " Fleet Management Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 97 Employees' Fringe Benefit Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 98 Risk Management Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 99 Equipment Replacement Fund Schedule of Revenues and Expenses - Y Budget and Actual (Budget Basis) 100 AGENCY FUNDS .. Combining Balance Sheet 101 Combining Statement of Changes in Assets and Liabilities - All Agency Funds 102 M ,. CONTENTS - CONTINUED FIXED ASSETS W Schedule of General Fixed Assets by Source 103 ., Schedule of General Fixed Assets - By Function and Activity 104 Schedule of Changes in General Fixed Assets - W By Function and Activity 105 LONG-TERM DEBT r Schedule of Chanaes in Long -Term Debt 106 Statement of General Long -Term Debt 107 SINGLE AUDIT SECTION Independent Auditors' Report on Compliance With Requirements Applicable to Each Major Program And Internal Control Over Compliance ++. In Accordance With OMB Circular A-133 109 Independent Auditors' Report on Compliance And On internal Control Over Financial Reporting Based _ On An Audit of Financial Statements Performed In Accordance With Government Auditing Standards 111 ^� Schedule of Expenditures of Federal Awards 11.3 Schedule of Findings and Questioned Costs 115 Begley, Janssen, Young & Birk, LC CERTIFIED PUBLICACCOUNTANTS 2103 TnEMIS ST -CAPE GIRARDEAU. MISSOURI 63701 -TELEPHONE ($73) 334-2885 - FAX 1573} 1:44338 PART{JERS JOHN R. JANSSEN. CPA JENNIFER 'NF.STRICH, CPA TERRY R_BEGLEY. LPA JEFF UNTERREINER CPA LAWRENCE E. YOUNG. CPA CATHERINE A. '�JHTE ,;P4 KELVIN W. BIRK, CPA INDEPENDENT AUDITORS' REPORT ON THE GENERAL PURPOSE FINANCIAL STATEMENTS AND SUPPLEMENTARY INFORMATION ,. Honorable Mayor and Members of the City Council City of Cape Girardeau, Missouri. o We have audited the accompanying general purpose financial statements of the City of Cape Girardeau, Missouri as of June 30, 1998, and for the year then ended as listed in the table of .. contents. These general purpose financial statements are the responsibility of the City of Cape Girardeau, Missouri's management. Our responsibility is to express an opinion on these Y general purpose financial statements based on our audit. we conducted our audit in accordance with generally accepted auditing standards and the standards applicable to financial audits r. contained in Gove nment kuditing_ Standai", issued by the Comptroller General of the United States. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the general purpose financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the general purpose financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall general purpose financial statement presentation. We believe that our .. audit provides a reasonable basis for our opinion. In our opinion, the general purpose financial statements referred to above present fairly, in all material respects, the financial ++� position of the City of Cape Girardeau, Missouri as of June 30, 1998, and the results of its operations and cash flows of its proprietary fund types for the year then ended in conformity with generally accepted accounting principles. In accordance with Government A --d'tina St ndards, we have also issued our report dated December 3, 1998 on our consideration of ++ the City of Cape Girardeau, Missouri's internal control over financial reporting and our tests of its compliance with certain provisions of laws, regulations, contracts and grants. d Honorable Mayor and Members of the City Council City of Cape Girardeau, Missouri Page 2 Our audit was made for the purpose of forming an opinion on the general purpose financial statements taken as a whole, The combining, individual fund and account group financial statements and schedules listed in the table of contents are presented for purposes of additional analysis and are not a required part of the general purpose financial statements of the City of Cape Girardeau, Missouri, Such information has been subjected to the auditing procedures applied in the audit of the general purpose financial statements and, in cur opinion, is fairly presented in all material respects in relation to the general purpose financial statements taken as a whole, BEGLEY, JANSSEN, YOUNG & BIEK, LC .. Cape Girardeau, Missouri December 3, 1998 8 �` GENERAL PURPOSE FINANCIAL STATEMENTS I 1 1 1 i 1 1 1 1 1 1 1 1 1 1 ( 1 1 f Cl,, of Cape Standard, .1 .... I COMBINED BALANCE SHEET ALL FANO TYPES AND ACCOUNT GROUPS lure Id. 19BE THE NOTES 10111E FINANCIAL STATEMENTS AHE AN INTEGRAL PART OF THIS STATEMENT. Todd ary Gove nlal FunO Tv� pro prleUry FunE Typu_ Fund TY� _ Account Groupe Ganem Genual SP.mal ..In Caplral mlem.l Fled LonPTerm IGUIS fMemor� Onfy) General Revenue S.,... Pn .ma EnbrQi_ S.rvlce Ayency A6yeM1 Oe bl 476/]ORS OU]OR] ASSETS ANO OTHER DEBITS Ass Poole, cash endmveelmenla $2 a, SaO2 $5820034 $],093,152 $1,165.]30 $1 B>3961 52952.229 160]92] $- $- $208]8351 $16.1.Aide Nonyooled I ... means _ 1002263 a. da 301,063 1266468 _ _ 3051.628 6.891622 Re masse; nelofel—irseabr ,olmnulierad-lase Had ..'are personal prop env. an, M."'Mois l are s airs 16a 1],102 13795 - - - 21 973 - 92 s. BI. Sales tae 6401476 635 Al - - _ - 1.275,753 1/S9. F ... ..... laves 1093662 1,NOW2 1019658 Halal bei lex receivable 35,740 - - - - _ 35, 740 . 951 Restaurant tea recalvable 50 A3 - - - - Si . Brea Hoff, onargas recelvNMe - 1 OB]}I6 - - 1093 516 1,025 656 Sti l asseesmenls Aoel.ade 21230 - 581,71 12 a TO ISO - - 901.09 952250 Interest receivable 2a6 613 23225 16501 1]63 PoA02 127 - - 418,713 629669 Otllerreceivables 36.622 3517 162 T19 .1,802 102 - 279,057 325 552 Nolen re¢Ivable - - _ _ _ _ _ .032 � Inlergovemmenlal receivables Motor fuel lax - 84.226 - - - _ - & 12. 6fi 082 Motor veMde license lees 1S 2M I.,a,, 12,169 Mott/ veplGe sales lax - 26,063 - - - - _ 26 85] 18895 GnmIx rec.I.Ma 195229 133940 132849 - - - 462066 1 211)47 Doelmm.1111, lanes 1759,545 694666 - - 20N 211 1025520 Advances L. Amm Unds 1,861500 - - - - _ - 1.61503 I.7 503 Invenlooes 123 19,220 115029 ) 228 - - - 144 050 139 61] Reslntled a55eb Nom p.oletl ca sN and rain d,,Nr,xrU - - - - 11226801 12012 - - 1124660 N310221 Nory pooled invenments - ]02,195 - .2165 WI W4 Pooled been and sm,son ma _ 1741254 _ 1.42N 14045YJ Prepaid items 64 221 11 060 816 M6 41 NS - - 946 fra2 1 029 295 Fixed assets_net of and—Haled depreciation - - - 49,6'22059 1]26.17 - 16205516 - WASS,.82 58031041 Orae„loan: Amount as. MNe for debt samno. - _ _ 31.632 3 593 632 3.521253 Am..nl to be proNded for retirement of general long-term 1161 _ _ _ - 10612223 10612. II3 1379410 Am.m 10 ba p—prol Us lumb. ...mem of eompematad absencae MO 051 563051 144 W 3 Tote l asset, and other debits 10122, 278 _SlG65.196- =L4 �192354 STN50Q A4024 ns NB383W $029 g96 116205,516 sl4769,A. _!I. .2 99 $115916956 THE NOTES 10111E FINANCIAL STATEMENTS AHE AN INTEGRAL PART OF THIS STATEMENT. I 1 i i 1 1 1 1 1 1 1 1 1 1 1 1 f 1 f City of Gen. GbeNeau, Mbeourl COMBINED BALANCE SHEET ALL FUND TYPES AND ACCOUNT GROUPS June So. 1093 TH£ NOTEST. THt FINANCIAL STATEMENTS ARE AN INTEGRAL PAH, OS TFlIS STFTEMENT. iif.d lary Governmental 1.uJ T ypes I �-'-Uq Fua Typo_ _Fun, TYE_ __ Account Groups General General Sp¢aal Oebr Capital nal Fre, Long Term Tabs., monn,wnO y) General R... on. Service "I Enlei ye—Agen[y Assets Done— p6/IONB 06/309] LIABILITIES, EQUITY AND OTHER CREDITS uebemes: AcmuNs".Ale $651,1)) $1261,202 IS 31]2,050 SI I..I Sell us, S68U $ 1- HO27 cin 3: 221 ue Aacal facilities Salerles.peymll l -Ad n, bemNs 322 797 67,611 157,610 21 1 1. B5a - 56],051 1,151,455 1 Lao. Nolen payable - - 28402 - 20 apt 14 baa. Inlelesl payabl. - 205 - ED 101 12 71,6 _ 555 ]til ti79 Bi OIIler liebJiBes 165,089 1,901 - - 248,919 59 610,]01 - - 1,@1 213 00] . Due to oNer pov¢ntmenls - - 2,20) 69.)50 ,g. 99,125 11]1tl 169 tlY Due to cans funds 695211, 1358,995 2051211 1.11. AdaancehomflAn dNnds _ - 108)500 1SET 3661 Sn. of la Lngder _ _ Ii4B9]8 I1pCW - 25p]Jla IuRud 106)292 ]bo]IM debt of cun¢nl potion Lon. of nue sebinel Reaenue bond. bole - at 272 407 - - 41 P24L7723 7IS11. 4).119 verad Lluffis br.1 pal payable - 1 419 916 5]9],]2] cone - - 7% WO 2]05050 fi59.125 - a 515,006 0291.125 91 p10]5v Geneva obligation reloading GenevaSplpaNdy,nds b Bonds payable _ _ 2]95005 3]95 CW 2 74 M, Ar dfie E.tolast landau tlosw¢ and vosFaoeare [OauiedbN _ _ _ - eCBm6 _ _ _ SEE 078 122 Dererre, wmpena¢1mn a11e amplov.s � - _ _ _ G,a 2.105 ms Leisured rev¢nues 125 227 61 am DIC 417 51,053 ey w] zBa. 1n_ Total a tingulire 1264290 1 392 214 591,]22 567056 12Ile i, 7967500 62b Set - 14)69 405 1ting.25 )60)6 Sr. Equity and other redits: lovelfil,cat in general fixed assets - - _ _ _ 16]05,516 - I6)05516 17129)1, COONbul.d outs, - _ - 20605,665- - - 3UB]5 tiGB 1b WO W. Rel.ined earnings; Reserved - - 2166] - - n$] ww, Unreserved _ _ - ap9np upp.]n1 _ _ _ ]ape 1pl Sam ]n Fund Petersen: rved 2,]05,116 1670001 159],6]2 1,030,120 - - - - 6955882 ]]92tlW VnRs¢rved 1605,0]2 6674056 12715401 _ _ _ _ 1 S _ 1p ti]S tl2G TOM a Rudy and U.r[ I.Lis 6,912981 10092984 ]59]632 ]8]580 21346//5 32C0Ill _ 16).5516 6261511 51p115e Total liabilities, partial.1fin-ledll5 301p,Z]8 111,105]98 5419235/ $1,615.012 5]1.64,)]5 $a 1,]0 ]99 302999tl $75)05510 111]61,106 3136but 95] 51959Zn 4Gr. TH£ NOTEST. THt FINANCIAL STATEMENTS ARE AN INTEGRAL PAH, OS TFlIS STFTEMENT. r THE NOTES TO TI IF FINANCIAL STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT. i:? Ed, at C". Girazeaaa, Missouo r COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES ALL GOVERNMENTAL FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 30, 1998 r GOVERNMENTAL FUND TYPES -- TOTALS r SPECIAL DEBT CAPITAL (MEMORANDUM GENERAL REVENUE SGRVIC PROJECTS ONLY} r REVENUES 'asc5 512041015 S8,271334 5342532 S- $20.654.984 Licenses ane permits 997,758 - 997,758 Intergavemmental 975,017 1,360,728 8,050 324,604 2665.419 r Charges for se'.e 316896 431.183 - - 748.079 ntertlepenmentai services 506.373 - - 506.373 Frrres and'ortatures 611339 - - 611339 Miscellaneous 109,789 135,247 - - 245036 r Invesunent maenoe 276,857 657.670 286,743 94.355 1 315.825 S,Oai assessmeme 9.145 118884 29,545 155,574 TOTAL REVENUES 15644.212 10.856.362 754.309 445.504 7900,387 EXPENDITURES m r AdminiylratnC servicP9 1,394411 941.569 2,335,980 Oevalupment servmes 1,388,420 21,908 - - 1,410,328 Pads and recreation 1,057,122 1,068,382 - 2,125,504 Fume salely 7,204,407 192,003 - - 7,396,410 r Publm.,Xs 1735.040 2.673,961 - - 4.409001 Contingenq 654789 - - - 654.789 CopHat Outlay - - 3,339.577 3339,57) Debt service +' Prinapal - 12,544 2.391.764 - 2404308 6nteresl IIId fiscal MarBes w2 IS4 971 7749. 8 ;16.314 809,347 TOTAL EXPENDITURES 13456,383 4011,338 3141,632 3,375,891 2488.4244 r EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 2387,829 5,945,024 (2,387,323) (2.930357) 3,015,143 r OTHER FINANCING SOURCES (USES) Operatinq iran5fersm 916,650 1,350,000 2473,020 2,103,174 6,84:843 Operating V,I,Mers out (1,846.116) (5.043402) - (73.906) (6,963,424) r TOTAL OTHER FINANCING SOURCES (USES) (929466) (3,693402) 2473,020 2,029,268 (120,580) EXCESS (DEFICIENCY) OF REVENUES r AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES 1458363 2,251622 85,697 (901,119) 2894,563 r FUND BALANCES, JULY 1-(RESTAT'ED) 5,406,533 7,8358141 3,507,935 1,664,705 18415,014 PRIOR PERIOD ADJUSTMENT 48.092 5,521, ___533 �61 3 r FUND BALANCES, JUNE 30 $6,912,988 $10092.984 53.593632 $763586 _$21363190 r THE NOTES TO TI IF FINANCIAL STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT. i:? i� 0 REVENUES r Taxes Lenses and lnm+s INeryovemmental Cnargeeku,er<ves i lntemevanmental velrres Fines and heledutes MisaeltarreTue Investment revenue r S'.al asssessmenls TOTAL REVENUES r EXPENDITURES Cur ent Adeeln. dtrve sellles Devebpment e'rAne, Parlve and ruoeakcn PVblk salaty p.bk vort, Comer,", Gave eeru. r Pnnopat OteR3t and 15.1 era"9 TOTAL EXPENORURES r "CM (DEFICIENCY) OF REVENUES OVER(UNDER) EXPENDITURES OTHER FINANCING. SOURCES (USES) Openatng T.Peele P Operating trenslere out TOTAL OTHER FINANCING SOURCES r (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES r OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES FUND BALANCES, JULY 3 - (RESTATED) PRIOR PERIOD ADJUSTMENT r FUND BALANCES, JUNE 30 r,,N Al even Xt,—..r. CONFINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL (BUDGET BASIS) � ALL GOVERNMENTAL FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 30, 1998 (1051.121) GENERAL FUND 5,356.622 - SPECIAL REVENUE FUNDS 48092 34353593 5$856.267 $2E02674 VARIANCE VARIANCE FAVORABLE FAVORABLE BUDGET ACTUALNl(,/_FAVORARLEf BUDGET ACTUAL (UNFAVORABLE, 510564.360 512.041,018 St,a7O658 $7359]91 55271.J34 5411513 913.300 997,755 84,458 370,875 975,037 604,162 1318.5OG 1360.728 42,225 287635 316.896 29261 356.100 ail 183 35083 547,000 506,373 (36,627) 580. Goa 611.339 31.339 - - 66200 1015.789 43599 112220 135-247 23077 259500 275767 16,287 165.95) 650-106 J84, 156 2601 9.145 7145 13,556.870 15,8a3,la2 2.256/272 9852561 10.845.596 996037 1,=37335 1391,863 45,472 1999127 951910 145.:79 1432,481 1,396.122 35.359 20,325 21,908 (1.$82) 1.074490 1062,677 11.813 1.098,95E 1.062,966 35970 7253520 7,211,529 41691 206,627 192,608 14,624 1$78,550 3,722,949 (4a 399} 5112100 3286786 1825.312 625000 654,789 170,211 - - 13.`_00 12.5'4 956 22.194 (22.154) 911 (971) 19,301776 13.162.123 2389`33 7.550(35 5.531145 2019,487 (11x206) 2,381019 2.495,225 2.301926 5,317,450 3,015524 916,650 916,650 - 1,341000 1, 3500W 9,WG 1, 833, 565) (1.846,116) 7,449 (4289,0!10) 15,043.4021 (754 A02) �836915j (929.466) _ ],1119 12.948.000) 13,693 Z) (745 402) (1051.121) 1451,553 2,502.674 5056,622 5,356.622 - 46,092 48092 34353593 5$856.267 $2E02674 THE NOTES TO THE FINANCIAL STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT 13 (646,074) 1,624049 2.270.122 3.540.210 3,5402/6 (5.521) 15.62.1) $').868681 551158,503 $2270-122 w EXPENDITURES Capital outlay Da01 MR,,M P',PM', w Intnrestem Oscal d'IflrOes TOTAL EXPENDITURES EXCESS $DEFICIENCY) OP REVENUES w OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Opm.1" I..fan 10 w OWMieg trensfera out TOTAL OTHER FINANCING SOURCES (USES) w EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES w City of cane Glra.aoau, Mlssourl COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL (BUDGET BASIS) - ALL GOVERNMENTAL FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 30. 1998 ANNUALLY BUDGETED DEBT SERVICE FUND w REVENUES (RESTATED) inxns 2959.493 InlalgovalMlanlal VARIANCE IpValifitant [CYee08 BALANCES, JUNE 30 $gJpal aSNssme019 w $3032.145 FAVORABLE TOTAL REVENUES w EXPENDITURES Capital outlay Da01 MR,,M P',PM', w Intnrestem Oscal d'IflrOes TOTAL EXPENDITURES EXCESS $DEFICIENCY) OP REVENUES w OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Opm.1" I..fan 10 w OWMieg trensfera out TOTAL OTHER FINANCING SOURCES (USES) w EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES w City of cane Glra.aoau, Mlssourl COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL (BUDGET BASIS) - ALL GOVERNMENTAL FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 30. 1998 (38,270) 72652 110,922 ANNUALLY BUDGETED DEBT SERVICE FUND FUND CAPITAL PROJECTS FUNDS (RESTATED) 2959.493 2959.493 VARIANCE FUND BALANCES, JUNE 30 VARIANCE 52921223 $3032.145 FAVORABLE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) BUDGET 1f CTUAL,UjU FAVORADLEI $120,230 $642632 $22402 $- $ S 8.500 8,050 {450) 651,80U 321,604 (330.496) 264,500 273698 9,198 13.500 92,249 79.249 __8S 000 116,884 31,884 15,000 29,545 14,545 618230 241254 63.034 660,304 M3,894 )23640'2) - 2,613,400 2,190.236 423.164 2391.764 2391,)64 190,061 749,868, _.40,993 6,65ti (8,655) 3,182625 3,141,602 _ 40.993 2,611400, 2,198,891 414,509 (2,504,395) (2400,368) 1M, 01) (1,933,100) (1.754993) 178,107 2466.125 2.473,020 6,895 1,392,350 1,328,272 (63,578) (66,650) (73,906) 72561 2,466125 2,173,020 _ 6,895 _1,025,700 1,254862_ (70.633) (38,270) 72652 110,922 THE NOTES TO THE FINANCIALS IATEME NTS ARE AN INTEGRAL. PART OF THIS STATEMENT. w )6 (602,400) (500,126) 107,224 1,184,)25 1,184,725 $677325 41;84.599 $107274 FUND BALANCES, JULY I - (RESTATED) 2959.493 2959.493 w FUND BALANCES, JUNE 30 52921223 $3032.145 SIR,922 THE NOTES TO THE FINANCIALS IATEME NTS ARE AN INTEGRAL. PART OF THIS STATEMENT. w )6 (602,400) (500,126) 107,224 1,184,)25 1,184,725 $677325 41;84.599 $107274 .r CA, of Cape Gtruotap.++nssoml COMBINED STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS ALL PROPRIETARY Pt1NO TYPES nn FOR THE FISCAL YEAR ENDED JUNE 30, 1996 wr+ THE NOTES TO THE FINANCIAL STATEMENTS ARE AN INTEGRAL PART OF TH,9 STATEMENT. 1 TOTALS PROPRIETARY FUND TYPES IMEMORANOUM ONLY1 i INTERNAL ENTERPRISE SFIZV fy9T-1999, OPERATING REVENUES Residential Oranges 45,363,26] S- 55,363 263 Cpmmemial charges 2.526 260 - 2.526.260 T,aagfer sixes onmgee 484 856 43x 158 E.ienenl sales 10424 - 10,42a Concession revenues 113.556 - 113.554 Gott.1ne, fats 399,959 - 34=.959 S.ftl Tplex'ees 5300,1 53.884 Olnel fees and cn."es 2x2031 - :742031 Iateroepaetmentaturvxts - 3 n'356 3926356' Otner mrsceuanes- 65.917 1x1 66.058 TOTAL OPERATING REVENUES 9260 15, 30.649' 12266647 OPERATING EXPENSES P'.'Ys'..'v ' 2081,184 613675 2,69)460 MalenNs and s,PPliea 261,910 246.850 508760 al CFIIN ual servin¢s ]W9820 2040.x21 5.550,2al Gen. a,dealinq expenses 252,234 23,229 225.463 Special projects excense 54.4`9 - Sa.aa9 Intemal a.,e expenses 3VI652 208` 3C8 736 De,"Enne" expenu 1568.44] _295094 1.8835al TOTAL OPERATING EXPENSES 8.057-296 3.112135a 11279550 r OPERATING INCOME (LOSS} 120285a {194,8511 1J0iy97 NON4)PERATING REVENUES (EXPENSES) lnresimeM ssVAF a 1,464.2$0 262615 I'Si 95 r Federal galls 6545 - 6.5,15 Sale oI Gry FAl 11,210 27,8x9 39,059 Cen,errsal L, damages 4,765 4,755 Sala 0l fixed assets 5,667 5,66) Gain on sale of fixed assets 18034 - 18 034 Ili And gennIss"i ;99306} (5,951) (105,267) Interest and handling FeUs (2,506,899) (45,135) (2554,034) �s TOTAL NON OPERATING REVENUES (EXPENSES) (1,099.704) __L79 368 918 336 INCOME (LOSS) BEFORE OPERATING ,ye TRANSFERS 105,150 (15489) 89,661 Operating UamsNa In 206,000 08918 2g4A98 Operating tarsiers out (173500) (171500) NET INCOME iLOSS) 311.150 (100.911) 210239 r. RETAINED EARNINGS (DEFICIT), JULY 140.139 3301.692 3,4a2.191 PRIOR PERIOD ADJUSTMENT (10,822) L10.8>2) RETAINED EARNINGS (01 E, JUNE30 S440 U7 53,200.781 53641558 wr+ THE NOTES TO THE FINANCIAL STATEMENTS ARE AN INTEGRAL PART OF TH,9 STATEMENT. 1 City of Cape Girardeau, Missouri COMBINED STATEMENT OF CASH FLOWS. ALL PROPRIETARY FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 30, 1990 PROPRIETARY FUND TYPES TOTALS INTERNAL (MEMORANDUM ONLY) ENTERPRISE SERVICE 1997-1998 _ CASH FLOWS FROM OPERATING ACTIVITIES: Operating income (loss) $1,202,854 (3194,851) $1,007,997 Adjustments to reconcile operating income to net cash provided by operating activities: Depreciation 1.588 041 295,094 1,883.541 Cash operating grants received 6,545 - 6.545 Change m assets and Ill (Increase) dearest, in accounts receivable 269.590 (20,667) 248,923 (Increase) decrease in inventory (5.106) 786 (4,920) (Increase) decrease in prepaid items 290 41,645 41,935 Increase (decrease) in accounts payable 157,021 351 541 508,562 Increase (decrease) in accrued liabilities 895.716 (4.086) 891,630 Increase (decrease) in landfill POSeldapre rare costs (16.882) (16,882) NET CASH PROVIDED BY (USED IN) OPERATING ACTIVITIES 4.091.875 469456 4.561.331 CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES: Operating transfers in from other funds 206.000 88.078 294.078 Operating transfers out to other funds (111500) (173.500) NET CASH PROVIDED BY (USED IN) NONCAPITAL r FINANCING ACTIVITIES 206,000 (85,422) 120578 CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES: Proceeds from developers 133.311 - 133,311 Pdnapal paid on revenue bonds (390,000) - (390,000) Principal paid on lease purchase bontls (613,235) - (613,235) Principal paid on COP bonds (240,000) (110,000) (350.000) r Principal paid on SRF bonds (122,000) - (122.000) Principal paid on energy loan 8 note payable on land (51,244) (415) (51,659) Interest paid on bonds and obligations (1811,103) (35,648) (11846,151) Proceeds from capital grants received ham other governments 106,102 - 106,102 Purchase of fixed assets (9,553306) (1,111,353) (10.664 659) Proceeds from sale of assets 60,383 27,849 88,232 Compensation for damages 4.765 4,765 NET CASH PROVIDED BY (USED IN) CAPITAL AND RELATED FINANCING ACTIVITIES (12,476 327) (1.229.561) (13,705,894) CASH FLOWS FROM INVESTING ACTIVITIES: Proceeds from sale of investments 290,000 181,000 471,000 Interest on Investments 1,576,743 42,652 1,619.395 Overnight interest 172,463 154,834 327,297 Interest on assessments 6,809 - 6809 Interest on interfurd advances - 1,855 1,855 FMV adjustments to cash 3,044 2,732 5,776 NET CASH PROVIDED BY (USED IN) INVESTING ACTIVITIES 2,049,059 383,073 2432,132 INCREASE (DECREASE) IN CASH AND CASH EQUIVALENTS (6,123,393) (462060) (6,585,853) CASH AND CASH EQUIVALENTS, JULY 1 26,370.429 3,433,001 29,803,430 CASH AND CASH EQUIVALENTS, JUNE 30 $20.241.036 $2,970.541 523,211,577 THE NOTES TO THE FINANCIAL STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT. 16 CitiofCape (iirtrdaw. M1,),, ur NOTES TO FINANCIAL STATEMENTS June 30, 1998 NOTE A - SUNIXkRY OF SIGNIFICANT ACCOUNTING POLICIES The City of Cape Girardeau, Missouri operates under a charter which went into effect April 12, 1982. The City operates under a Council -Manager form of government and provides the following services as authorized by its charter: public safety (police and fire), highways and streets, water, sanitation, health and social services, culture -recreation, public improvement, planning and zoning and general administrative services-. .. The financial statements of the City have been prepared in conformity with generally accepted accounting principles (GAAP), as applied to government units. The Governmental Accounting Standards Board (GASB) is the accepted standard-setting body for establishing governmental accounting and financial reporting principles- The more significant accounting policies of the City +uc described below. 1, RellEr ng Entity In evaluatim: how to define the City, for financial reporting purposes, management has considered all potential component units. Generally, component units are legally separate organizations for which the elected officials of the City are financially accountable. The Cape Girardeau (Missouri) Public Facilities Authority (CGPFA) is a blended component unit which is part of the City's operations and so the financial statements of the CGPFA are included in the accompanying financial statements of the City of Cape Girardeau. Cape Girardeau (Missouri) Public Facilities Authority - As described in Note E, the City- of Cape ur ,+ Girardeau, Missouri has entered into folease agreements with the Cape Girardeau (Missouri) Public Facilities Authority (CGPFA). The CGPFA is a not -far -profit corporation organized and existing under Chapter 355 of the Revised Statues of Missouri. The CGPFA board of directors consist of city officials and city council members. Due to the significant city influence and financial accountability, the activities of tire CGPFA are blended with the financial presentation of the City. The corporation was used to execute the bond indentures for the purpose of issuing and securing the Series 1993 Bonds, Series 1994A Bonds, and Series 1997A and 1997B Bonds. 'These bonds were used to finance construction and improvements to sewer, solid waste, -street, airport, flood control and other capital ^ improvement projects. The bond payments are obligations of the CGPFA. The CGPFA has entered into a Lease Purchase Agreement with the City from which the lease payments will be used solely to retire the debt. ^ Although they are riot a component unit of the; City, the City handles the funds of and provides accountin_ and other services for several entities. Since these funds are held in the City's name, these +. entities mro shown as Agency Funds in the financial statements. 0 17 M NOTES TO FINANCIAL STATEMENTS June 30, 1948 NOTE A -SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES- Continued L Reporting Enti� - Continued Beginning January 1, 1446 the Transportation Sales Tae Trust Fund was established as a special revenue fund. The fund was established to collect and expend a sales tae that was approved by a public vote in August 1445 and became effective January 1, 1996. The tae is restricted to being expended on street and sidewalk improvements and will expire in fico yv.us. 2. 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 self -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 purpose for which they are to be spent and the means by which spending activities are controlled, The various funds ire grouped, in the financial statements in this report, into fund categories. GOVERNMENTAL FUND TYPES General Fund - The General Fund is the general operating fund of the City. All financial resources, except those required to be accounted for in another fund. are accounted for in the General Fund. Special Revenue Funds - Special Revenue Funds are used to account for the proceeds of specific revenue sources (other than expendable trust or major capital projects) are legally restricted to expenditures for specified purposes. Debt Service Fund - The Debt Service fund is used to account for the accumulation of resources for, and the payment of, general long-term debt principal, interest, and related costs. Capital Protects Funds - Capital Projects Funds account for financial resources to be used .� for the acquisition or construction of major capital facilities, which are not financed by Proprietary Funds and Trust Funds. 18 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1998 NOTE A - SUMMARY OF SIGN FICANT ACCOUNTING POLICIES- Continued 2. Fund Acenunting-Continued PROPRIETARY FUND TYPES I he City has implemented GASB 20 (Accounting and Financial Reporting for Proprietary Funds and y Other Governmental Entities that use Proprietary Fund Accounting) by choosing to apply the accounting principles in (1) all GASB pronouncements and (2) FASB (I''inaneial Accounting Standards Board) Statements and Interinetations, APB (Accounting Principles Board) Opinions, and ARBs (Accounting Research Bulletins) issued on or before November 30, 1989, except those that conflict with a GASB pronouncement. .. Enterprise lends - Enterprise Funds are used to account for operations that are financed and operated in a manner similar to private business enterprises - where the intent of the governing body is that the costs (expenses including depreciation) of providing goods or services to the general public on a continuing basis be financed or recovered primarily through user charges; or where the governing body has decided that periodic determination of revenues collected, expenses paid, and/or net income is appropriate for capital maintenance, public policy, managennent control, accountability, or other purposes. Internal Service Funds - Internal Service Funds are used to account for the financing of goods or services provided by one department to other departments of the City, on a cost - reimbursement basis. FIDUCIARY FUNDS .. 'frust and Agency Funds - Trust and Agency Funds are used to account for assets held by the City in a trustee capacity or as an agent for individuals, private organizations, other governments, and /or other funds. Agency Funds are custodial in nature and do not involve �+ measurement of results of operations. GENERAL FIXED ASSETS AND GENERAL LONG -PERM DEBT ACCOUNT GROUPS General Pixcd Assets (GPA) -] lie General Fixed Assets Account Group is used to account for Fixed assets used in governmental fund type operations for control purposes_ All fixed assets are valued at historical cost or estimated historical cost if actual historical cost is not available. Donated fixed assets are valued at their estimated fair value on the date of donation. Depreciation is recorded on general fixed assets. ('ieneral LonK "form Debt Account Group - The General Long- I erns Debt Account Group is used to account for lung -term liabilities to be financed from governmental funds. 19 uw of L.rpa vmuucau, 4ltssuun ` NOTES TO FINANCIAL STATEMENTS June 30, 1448 NOTE. A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued .. 3. Fixed .Assets General Fixed Assets Account Group - Fixed assets used in governmental fund type operations are accounted for in the General Fixed Assets Account Group, rather than in governmental funds. Public domain (infrastructure) general fixed assets, including roads, bridges, curbs and gutters, streets and sidewalks. drainage systems and lighting systems, are not capitalized along with other general fixed ` assets. Depreciation has been provided on all capitalized assets, except for land. All fixed assets are valued at historical cost or estimated historical cost if actual historical cost is not ,. available. Donated assets are valued at their estimated fair value on the date donated. Repairs and maintenance we recorded as expenditures; renewals and betterments are capitalized. r Proprietor Funds - Additions to the Proprietary Funds are recorded at cost or, if contributed property. at their estimated fair value at time of contribution. Repairs and maintenance are recorded as expenses; +. renewals and betterments are capitalized. The sale or disposal of fixed assets is recorded by removing cost and accumulated depreciation from the accounts and charging the resulting gain or loss to income. Depreciation of all exhaustible fixed assets used by Proprietary Funds is charged as an expense against their operations. 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. Buildings 2550 yews M Improvements 10-40 years Equipment 3-10 years .. When applicable, interest costs are capitalized on self -constructed fixed assets. 4. Basis of Accounting Ibe accounting and financial reporting treatment applied to a fund is determined by its measurement focus. All governmental funds we accounted for using a current financial resources measurement focus. With this measurement focus, only current assets and current liabilities generally are included on the balance sheet. Operating statements of these funds present increases (i.e., revenues and other financing sources) and decreases (i a., expenditures and other financing uses) in net current assets. All proprietary funds are accounted for on a flow of economic resources measurement focus. With this measurement focus, all assets and liabilities associated with the operation of these funds are included on the balance sheet. Fund equity (i.e., net total assets) is segregated into contributed capital and retained earnings components_ Proprietary fund type operating statements present increases (e.g.. revenues) and decreases (e.g_ expenses) in net total assets. 0 20 ■ City of Cape Girardeau. Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1998 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 4. Basis of Accounting - Continued The modified accrual basis of accounting is used by all governmental fund types and agency funds. Under the modified accrual basis of accounting, revenues are recognized when susceptible to accrual (i.e., when they become both measurable and available.) "Measurable' means the amount of the transaction can be determined and "available" means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. The City considers revenue to be available if it is collected within 30 days after vear-end. Expenditures are recorded when the related fund liability is incurred. Principal and interest on long- term ongterm debt are recorded as fund liabilities when due or when amounts have been accumulated in the debt sen ice fund for payments to be made early in the following year. Those revenues susceptible to accrual are property tares, franchise taxes, special assessments, licenses, interest revenue and charges for services. Sales taxes collected and held by the state at year-end on behalf of the City also are recognized as revenue. Fines and permit revenues are not susceptible to accrual because generally they are not measurable until received in cash. The accrual basis of accounting is utilized by proprietary funds. Under this method, revenues are recorded when earned and expenses are recorded at the time liabilities are incurred. The City reports deferred revenue on its combined balance sheet. Deferred revenues arise when a potential revenue does not meet both the "measurable" and "available' criteria for recognition in the current period. Deferred revenues also arise when resources are received by the City before it has a legal claim to them, as when grant monies are received prior to the incurrence of qualifying expenditures. In subsequent periods, when both revenue recognition criteria we met, or when the City has a legal claim to the resources, the liability for deferred revenue is removed from the combined balance sheet and revenue is recognized. 5. Encumbrances Encumbrances represent commitments related to unperformed contracts for goods or services. Encumbrance accounting is utilized in all funds. Encumbrances outstanding at the end of the year in the governmental funds are reported as reservations of fund balances and do not constitute expenditures or liabilities because the commitments will be carried forward and honored during the subsequent year. Encumbrances outstanding in the proprietary funds do not constitute expenses but will be honored in the subsequent year. 6. Budgets and Budgetary Accounting The City adopts annual operating budgets for all funds. 21 c C ity of Cape (iirardeau, Nlissouri VOTES TO FINANCIAL STATEMENTS June 30, 1998 NOTE. A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 6. Budgets and Budgetary Accounting Continued The City follows these procedures in establishing the budgetary, data reflected in the financial statements. E The City Manager submits to the City Council a proposed operating budget for the fiscal ,year commencing the following July L The operating budget includes proposed expenditures and the means of financing them. Public hearings are conducted to obtain taxpayer comments. 3. Prior to July 1. the budget Is legally enacted through passage of an ordinance, 4. The City Manager is authorized to transfer budgeted amounts between programs within any department, however, any revisions that alter the total appropriations of any department must be approved by the City Council. Departments may not legally exceed their appropriations without approval from the City Council. Appropriations expire at the end of the year, however. outstanding encumbrances at the end of the year are honored by the City. 5_ Formal budgetary integration is employed as a management control device during the year for all funds. 6. Budgets for all funds are adopted on a budgetary basis. ,.r Additional budget appropriations by department made throughout the year are as follows: General Fund Operaing Transfer Out S 43.5011 Fleet Mana¢rnxnt l®emal Service Fund 5.000 EgmpmeM R,plazemem intemai Service Fund 380,969 nota Processing lnremal Service Fund 50,000 General Capirat impravcnaut fund 25.000 Public $.to" 116,32) .W Contingency 775,000 Parks and ReR onbu6 16,86, Public works 925.000 52 387 615 Of the above appropriations, $43,500 was, allocated for a general fund operating transfer to the Fleet management fund, $55,000 for upgrade and repair of the fleet department's fuel storage and dispensing ++t system, $380,969 for purchase of a fire truck and street sweeper, $50,000 for the purchase of various computer equipment, $25,000 for the completion of Osage and Shawnee Park projects, $96.321 for purchase of land and public safety equipment, $20,000 for demolition of dangerous buildings, $775,000 for grant funded Hood buyout and relocation costs, $6,065 for grant funded park expenses, $10,800 for replacement of an irrigation pipe at the golf course and $925,000 for completion of the Twin Lakes water system, Notre Dame high school water main extension, and completion of grant funded water plant #1 supply development. 22 _ Cit} of i -ape Girardeau, 4tissoun NOTES TO FINANCIAL STATEb1ENTs June 30, 1998 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 6. Budgets and Budgetary Accounting - Continued For the ,year ended lune 30, 1998 general fund expenditures for public works and debt service exceeded their approved budgets by $44,399 and $22,194 respectively. Additionally, the Vision 2000, General Capital Improvement, Corp Flood Control, Street Improvement Park Improvements, Golf Course, Softball Complex, Data Processing, Employee Fringe Benefit, and Equipment Replacement funds exceeded their approved budgets by $1,608, $2,745, $148.623, $28,649, $151.483. $15,407. $16,784, 57,783. $490,871, and $3,543 respectively. .. The Combined Statement of Revcnues, Expenditures, and Changes in Fund Balance -Ali C;iosennlental Fund Tvpes reports revenues and expenditures on the modified accrual basis of .uccutmting in accordance with GAAP. The Combined Statement of Revenues. Expenditures. and Chances in Fund Balance -Budget and Actual (Budget Basis) for all governmental fund types is prepared on a bud_eetary basis which includes encumbrances as expenditures. The following reconciliation adjusts GAAP basis to budget basis: .� Excess (Dcfrcicnq) of Revenue, -11 Other financing Sources over (under) Eapendimms and Other Fe ancinn t:1,1 Special Dart Capital Genual R"'nue S""ac Projeco GAAPFi 51458.363 52251,622 5 85,697 5 (90L119) increase due to Prior year encumbrances ,Adminismtive Services 24,853 3,562 - - Developmect services 3.848 - - - r Parks and recreation 5,874 6,933 - - Public Safer 21,998 - - - Public works 12,740 355,642 - - Capital outlay - - - 1-813;157 Contract uppntpnutcd from next year's bi dact 511.000 - - 69313 781.137 1813.17 r Decrease due to: Year-end encumbrances Administrati•'a services 22,305 15,941 - - Deeclopurentsvvsicet 11,550 - - - Parks and recreation 11,429 1,538 - - Public safety 29,120 - - - Public works 659 1383.469 - - Capital outlay - - - 941,729 water rmp""cer nrsFund not budgeted annuall) - - - 469,305 .Adjust investments to market 1,070 7-763 _ _ 13,045 1,130 =6.123 1.408,711 8.045 ]Al2.464 Rmieet Diors )1.451.553 51,624048 S 72.652 S ISOo_126) 23 W Citv of Cape Girardeau, Missouri ,a5l c� tt7 eLti--1�IAL JI AILVIL.\I� June 30, 1998 NOTE A - SUMMARY OF SIGNIFICANT .ACCOUNTING POLICIES - Continued 6. Budgets and Budgetary Accounting - Continued The individual proprietary schedules of comparing budget to actual is reported on a budgetary basis that uses the modified accrual basis of accounting with the exception of encumbrances. Encumbrances are repotted as expenses in the year of encumbrance. 24 Solid Gair Sonball Saver Water Wale Course Complex GAAPBaoS S (71-162) 5229.965 5185346 SP_=.068) 5;7-9321 Incramc due to Prior year encumbrances t x'riala mid suppli" 1,915 228 3v 320 740 Conlracmal sc,ccs 46 - - - - G'rCT'l opsin cg C'Na'ei 47C+ - Capitni omla)s 11496,68.', '-'_9.704 100036 100 - Dcprecimlon 804,985 389,834 231,892 63,230 U06 Capuat emnts 59.723 46.379 - - - Impactfsea 133,311 - - - - Spcclala3cismcnts 16.396 - - - - Adjultment to hatubt, for rutnre lundfll paarclostnl maincea'mce costs - - 10.078 - - Interesrcostamortized 761,915 879 188 - - CuSt of bond miuudin¢ amorti,allaa 25.588 42.318 - - - I:uuancccost amonimticn 65.88128.398 5,027 - - __ 3356.342 _. 737740 3.48.0>1 61.120 9.236 --.... Decrease due to Year-end encumbrances Materials and supplies 1,421 345 87 - 800 Contractual set, ices - 367 - - - GeneraloperatSrgczpense - - - 246 - Capitaloutloys 3,120,291 528,633 5,173 - - Special projects :2?96 - 7,500 - - LandGll closure and maintenance costs - - 26,960 - - kuen-st paid mors than accrual 125,390 6,237 2157 - - ocndprincipalpaid 820,435 420,000 169,800 - - Capitolootiuys 8,922,040 449,326 137,070 43,545 - Amount deferred for future debt service for capital appreciation bonds, Construction fund 329,395 - - - - Interestsubsidv received 143,774 - - - - Adjust inveAments to mnrket 13.538 1,717 —7306.625 11034 65 8 1-,398.600 349.881 43,856 808 Budget boss $(IU.I 133201 .S 4( 38.920? —Ti83.519 SAL8 507 24 25 City of Cape Girardeau. Missouri NG-rEs TO PINA%CIAL S l'A I L%ILN I'S June 30, 1993 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 6. Budgets and Budgetary Accounting-Continued a Net Income ( Loss) � Dalo Plea Er,,Flloyee Risk Equipmom �i�e MI --1 em Elm—" binnoe<ment Re> GAAP Basis S(20387) 539,688 S(21;.303) S14373 S 78.718 Increase due to: Prior year encumbrances .. Material and supplies 443 L371 - - - Contractual services - 1990 General operating expense 4,495 Depreciation 143.237 39986 - - 11-271 Interest paid less than accrued 5,184 - - - 4,302 lssuarice cost amortization 3,60' - 1959 156,361 43.956 119"532 Decrease due to: Year-end encumbrances Materials and supplies 115 45 - - - Contractual services 17 " Capital outlays 227,457 3,835 - - - r Principal paid - 415 - - - Capital outlays 569,187 77,654 - - 464,512 r Adjust investment to market _161 48 988 2181, 194 796.937 81,987 983 2,181 _ 464.706 Budget Basis S{660,96=) S 1.657 5{_K291} st3.19- 5266,456) W 7. Inventories Inventories consist primarily of supplies, valued at cost, which approximates market. Cost is determined using a weighted average method. The cost of inventories is recorded as expenditures or expenses when consumed rather than when purchased. 25 /... " C1, C C:'.r:::!C Wil:_ V. ,`i::: ` NOTES TO FINANCIAL STATEMENTS June 30. 1998 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 8. Compensated Absences Vested or accumulated vacation pay for proprietary funds is recorded as an expense and liability of those funds as the benefits accrue to employees. Amounts of vested or accumulated vacation leave of governmental funds that are not expected to be liquidated within the current year are reported in the general long-term debt account group. Employees may accumulate up to 30 days vacation, for which they are compensated upon termination or retirement. Employees are not compensated for accumulated sick leave upon termination or retirement. ` 9. Bond Discounts/Issuance Costs In governmental fund types, bond discounts and issuance costs are recognized in the current period. Bond discounts and issuance costs for proprietary fund types are deferred and amortized over the term of the bonds. Bond discounts are presented as a reduction of the face amount of bonds payable whereas issuance costs are recorded as deferred charges. 10. Total Columns - Memorandum Onlv Total Columns are captioned "Memorandum Only" to indicate that they are presented only to facilitate financial analysis. Data in these columns do not present results of operations in conformity with generally accepted accounting principles. Neither is such data comparable to a consolidation. Interfand eliminations have not been made in the aggregation of this data. 11. Cash and Investments The city maintains an internal investment pool for the majority of its non -restricted cash and investments and a small portion of its restricted cash and investments. Investment revenue is allocated to each fund based on its average equity balance in the pool. Cash includes amounts in repurchase agreements and other short-term investments with a maturity date within three months of the date of purchase. 26 City of Cape Girardeau- Missouri NOTES TO FINANCIAL STATEMENT'S June 30. 1998 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 11. Cash and Investments Continued The City's investment policy authorizes it to invest its available operating and reserve funds in (1) obligations of the United States or its agencies and insttumcntahties; (2) repurchase agreements collateralized by securities listed in (1) above, documented by a written agreement, fully collateralized by delivery to an independent third party custodian, and are marked -to -market; (3) Insured or collateralized deposits or certificates of deposit of banks, savings and loan associations, and other regulated financial institutions; (4) money market mutual funds whose portfolio consists of the foregoing instruments: and (5) other prudent investment instruments approved prior to purchase by a two-thirds majority of the City Council. Bond proceeds may be invested as allowed in the bond indenture. ^ Investments, excluding certificates of deposit. with a maturity date of one year or more at the time of purchase are valued at market value as determined by averaging market quotes received by n,,o different securities dealers. All other cash and investments are valued at cost or amortized cost. 12. Comparative Data Comparative totals for the prior year have been presented in the accompanying finemcial statements in order to provide an understanding of changes in the City's financial position and operations. However. ^ presentation of prior year totals by fund type have not been presented in each of the statements since their inclusion would make the statements unduly complex and difficult to read. 13. Prepaid_Items .. Payments made to vendors for services that will benefit periods beyond June 30, 1998 are recorded as prepaid items. 14. Restricted Assets Certain proceeds of enterprise fund revenue bonds, as well as certain resources set aside for the ^ repayment of such bonds, are classified as restricted assets on the balance sheet because their use is limited by applicable bond covenants. The "revenue bond construction" account is used to report those proceeds of revenue bond issuances that are restricted for use in construction. The "revenue bond current debt service` account is used to report resources set aside to make up potential future deficiencies in the revenue bond current debt service account. 27 t i; .n �..pe uir,a�eau. .Aiunorn NOTES TO FINANCIAL STATEMENTS June 30. 1998 r NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 15. Long-term Obligations Long-term debt is recognized as a liability of a governmental fund when due, or when resources have been accumulated in the debt service fund for payment early in the following year. For other long-term obligations, only that portion expected to be financed from expendable available financial resources is reported as a fund liability of a governmental fund. The remaining portion of such obligations is reported in the general long-term debt account group. Long-temt liabilities expected to be financed from proprietary fund operations are accounted for in the appropriate proprietary fund. 16. Interfund Transactions Quasi -external transactions are accotmted for as revenues, expenditures or expenses. Transactions that constitute reimbursements to a fund for expenditures/expenses initially made from it that are properly applicable to another fund, are recorded as expenditures/expenses in the reimbursing fund and as reductions of expenditures/expenses in the fund that is reimbursed. All other interfund transactions, except quasi -external transactions and reimbursements, are reported as transfers. Nonrecurring or nonroutine permanent transfers of equity are reported as residual equity transfers. All other interfund transfers are reported as operating transfers. 17. Short-term Interfund Receivables/Pavables During the course of operations, numerous transactions occur between individual funds for goods provided or services rendered. These receivables and payables are classified as "due from other funds" or "due to other funds" on the balance sheet. Short-term interfund loans are classified as "interfund receivables/payables". 18. Advances to Other Noncurrent portions of long-term interfund loan receivables are reported as advances and are offset equally by a fund balance reserve account which indicates that they do not constitute expendable available financial resources and therefore are not available for appropriation. 28 0 0 Cite of Cape Ginudeau. Missouri VOTES TO FINANCIAL STATEMENTS June 30.1998 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 19. Post -Employment Health Care Benefits In addition to the pension benefits described in Note H. it is the City's policy to provide postretirement health care benefits to employees who retire from the City with five or more years of service and who are eligible for LAGERS retirement (Note H). Currently, sixteen employees meet those eligibility requirements. The City provides health care coverage for them until age 65. The cost of retirees' health care benefits is recognized as an expenditure as premiums are paid. For the year ending June 30, 1998. those costs totaled $39,494. COBRA Benefits - Under the Consolidated Omnibus Budget Reconciliation .Act (COBRA), the City provides health care benefits to eligible former employees and eligible dependents. Certain requirements are outlined by the federal government for this coverage. The premium is paid in full by the insured on or before the tenth (10th) day of the month for the actual month covered. This program is offered for a duration of 18 months after the termination date. There is no associated cost to the City under this program, and there were two participants in the program as of June 30, 1998. NOTE B - DEPOSITS AND INVESTMENTS 1. Deposits At June 30, 1998, the carving amount of the City's deposits was 56,388,557 and the bank balance was $6,382,812 which excludes $5,745 of petty cash funds held at various City locations. The deposits are categorized in accordance with risk factors created by governmental reporting standards. Category 41 includes deposits covered by deposit insurance or collateral held by the City in the City's name. Category #2 includes deposits covered by collateral held by the financial institution's trust department in the City's time. Category 93 includes deposits which are uncollateralized or the collateral is held by the financial institution's trust department but not in the City's name. 29 Carrying Bank Amount Balance Category 91 $6,382,255 $6,382,255 . Category t12 5,745 - Category 93 - _ $6,388.000 $6.382,255 Category 41 includes deposits covered by deposit insurance or collateral held by the City in the City's name. Category #2 includes deposits covered by collateral held by the financial institution's trust department in the City's time. Category 93 includes deposits which are uncollateralized or the collateral is held by the financial institution's trust department but not in the City's name. 29 ChC.rlis ', of pc Girurdeau. Nmnrri NOTES -TO FINANCIAL STATEMENTS June 30,1998 NOTE B - DEPOSITS AND INVESTMENTS - Continued 2, Investments Investments made by the City are summarized below. The investments that are represented be specific identifiable investment securities are classified as to credit risk by the three categories described below' Category n I Insured or registered, or securities held by the City or its agent in the City's- name. Category 4-2 Uninsured and unregistered, with securities held by the counter -party's trust department or agent in the City's name. Category 43 Uninsured and unregistered, with sccuraies held by the counter -party, or by its department or anent but not in the City's name. Cateeory Carrying Market e'1 "2 N.3 Value Value Repurchase Agreements $ 2,681,806 $- $- $ 2.681,806 $ 3.681,806 U.S. Government Securities 14.188.805 14,188,805 14.188.80.5 $16.870.611 S- _S- 16,870,611 16,870,611 Money Market Account U.S. Government Securities State Revolving Fund Program 30 4,947,946 4,947,946 14, 636.485 13,636,485 $36,455 042 $36,455.042 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1998 NOTEC- PROPERTY TAXES Property tares attach as an enforceable lien on property as of January 1. Taxes were levied on .August 18, 1997, for collection during this fiscal year and were due on or before December 31. Most of the tares are collected in November and December. The tax rates assessed at the time were as follows: City Revenue $,32/100.00 assessed valuation Depreciation Library Tae .17/100.00 assessed valuation Balance Public Health Tax .06/100.00 assessed valuation 250,715 Debt Service Tax .10/100.00 assessed valuation Deductions Special Business District .79/100.00 assessed valuation 42 (Ad Valorem) Land $ 2,073,938 Propertc tar receivable balances as of June 30, 1998 are as follows: Buildings 8,867,406 Downtown - Improvements other Business Debt General District Health Service Library Total Current property tar $31,620 $ 1,861 S 5,985 $I0702 8 $16.036 $65530 Delinquent property tax 34,006 3,521 5,013 10,867 16,357 69,764 Reserve for doubtful 5,208 17,136 Property taxes- 22.158) (85) (3.192) (7,100)1( 0.421) (42.956) Net property tax receivable $43,468 S 5,297 S 7,806 $13,795 $21,972 $92.338 NOTE D - CHANGES IN FIXED ASSETS A summary of the general fixed assets account group for the year ended June 30, 1998 is as follows: 31 Accumulated Balance Depreciation June 30, 1998 S- Balance 390,990 8,795,256 250,715 Jul, L 1997 Additions Deductions Land $ 2,073,938 $ 12,655 $- Buildings 8,867,406 318,840 - Improvements other Than buildings 4527,283 52,283 - Equipment 1,555,874 261,848 139,447 Construction in progress 5,208 17,136 Total general fixed assets $17029,709 -S662 762 T139 31 Accumulated Balance Depreciation June 30, 1998 S- S2,086,593 390,990 8,795,256 250,715 4,328,851 205,803 1,472,472 2.344 $847,508 S 16,705,516 Cir. 11 %lisouri NOTES TO FINANCIAL STATEMENTS June 30, 1998 NOTE D - CHANGES IN FIXED ASSETS - Continued Additions and deletions to the Enterprise Funds for the fiscal year 1998 were $11,274,442 and $250,649 respectively. Additions and deletions to the Internal Service Funds were $1,111,353 and $0 respectively. ,A summary of the proprietary fund type fixed assets for the year ended June 30, 1998 is as follows: Enterprise Internal Fund Service Fund Land S 248,109 S 37,500 Buildings 2089,787 421,821 Improvements other than building 36_11,152 113,749 " Fquipment 4,886,793 2,630,644 Construction in progress 14264.025 - $64,799,876 S 3.201714 Less: accumulated depreciation 1:1.122,817 1,427,607 $49.677.059 S 1.776,107 ,. NOTE E - LONG-TERNI OBLIGATIONS The following is a summary of transactions in the General Lone -term Debt Account Group of the City for the year ended June 30, 1998. General Leasehold CcrtiLcmcs ,., Obligation Revenue Of Unused Paid Due to Other Bonds Brands Participation Leave Gotcmmen_t_s Toted General lone -term debt payable at +r July 1, 1997 $3.070,000 S7,783.994 Si.705.000 5544.063 551,669 S17,154726 Retirements (330.000) (1,651,764) (410.000) (12,544) (2,404,308) Amount Added _ 18.488 _ 19,988 General long-term debt payable at 1..30.1998 52740-000 56.132,230 55,295900 5563951 539.125 Si4.769.406 32 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1998 NOTE E - LONG-TERM OBLIGATIONS - Continued The following is a summary of bond transactions in the Proprietary Funds of the City for the year ended June 30, 1998. Bonds payable at July 1,1997 Discount Amortization x Issue Cost Bonds Issued Accumulated Interest Bonds Retired Bonds payable at .lune .30. 1998 Leasehold Revenue Revenue Bonds Bonds $41.542.609 $2.200,343 52.818 17,677 Certificates of Participation Total 94,158.914 547,901,866 210 70,705 760,207 - - 760,207 (51022(1) X3,235 (350.000) (1,473.461) $4L845AH $1_604,785 $3.809.,1_4 547259,317 Bonds payable at June 30, 1998 are comprised of the following individual issues $ 2.740,000 1993 General Obligation Refunding Bonds due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total 1999 4,25% $ 345,000 $ 123,806 $ 468,806 2000 4.50 355,000 108,488 463,488 2001 4.70 370,000 91,805 461,805 2002 4.90 390,000 71555 463,555 2003 5.00 405.000 53,875 458,875 2004 5.00 425,000 33,125 458,125 2006 5.00 450.000 11,250 .461,250 $2,740.000 5 495.904 $3.235,904 Principal payments are made annually on November 1, and interest payments are made semi-annually on May I and November 1 33 Cit} ul Capc t.iirurdeuu. 4lissuun NOTES TO FINANCIAL STATEMENTS June 30. 1998 NOTE E - LONG TERNI OBLIGATIONS - Continued On April 20, 1993, the City of Cape Girardeau issued $3,690,000 of General Obligation Refunding Bonds Series 1993 with interest rates varying from 3.75% to 5.50%. The refunding bonds constitute general obligations of the City and we payable as to both principal and interest from ad valorem taxes which may be levied without limitation as to rate or amount upon all the taxable tangible property, real and personal, within the territorial limits of the City. The refunding bonds were issued to provide the City with funds which together with other legally available funds of the City, were used to refund $3,580,000 principal amount of General Obligation Refunding Bonds, Series 1987, of the City and pay the costs of issuance of the bonds - 5 970,000 Series 1993 Sewerage System Revenue Bonds due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total 1999 4.600% $ 95,000 $ 49,801 $ 144,801 2000 4,800 100,000 45,431 145,431 2001 5.000 110,000 46,631 150,631 2002 5.125 115,000 35,131 150,131 2003 5.250 120,000 29,238 149,238 2004 5.300 135,000 22,938 157,938 2005 5350 140,000 15,783 155,783 2006 5.350 155,000 8,293 163,293 $ 970.000 $ 247,246 $ 1,217,246 These bonds are dated September 1, 1993. The proceeds of the bond issue were used to defease (in - substance) the $1,170,000 1986 Sewerage System Revenue Bonds_ Principal payments are made annually on March 1, and interest payments are made semi-annually on March 1, and September 1. 34 City of Cape Girardeau, Missouri NO'T'ES TO HNANCIAL STA'EMEN'1S June 30, 1998 NO E - IANC- FERMI OBLIGATIONS - Continued r $ 3,055,000 Waterworks System Revenue Bonds Series 1992 due as follows: Year Ending Interest principal Interest _ June 30 Rate Due Due "Iota] 1999 5.70% $ 275,000 $ 206,722 $ 481,722 r 2000 5.90 320.000 191,048 511,048 2001 6.00 370,000 172,167 542,167 r 2002 6.10 425,000 149,968 574,968 2003 7.45 485,000 124,042 609,042 2004 7.45 555,000 87,9t0 642,910 2005 745 625.000 46,563 671,563 $3 055,000 $ 978,420 $4,033,420 These bonds are dated April 15, 1992. Be"proceeds of the bond issue were used to purchase, r extend and improve the water system serving the City. The purchase of the water system occurred on June 3, 1992_ Principal payments are made annually on March 1, and interest payments are made semi-annually on March I and September I. Additional principal of $8,090.000 originally payable through the fiscal years ending June 30, 2006 to 2012, was defeased via an iwsubstance defeasance during the fiscal year ended June 30, 1996. 35 Cit, nWnpc Gi mn!c:tu. Alit_; cri NO FES TO FINANCIAL STATEMENTS June 30, 1998 NOTE E - LONG-TEWN1 OBLIGATIONS - Continued $ 8,790,OOOWaterworks Svstem Refunding Revenue Bonds Series 1995 due as follows: Year Ending Interest Principal Interest hme 30 Rate Due Due Total 1999 4,200% S K000 $ 437,268 $ 517,268 2000 4.300 80,000 4.33,907 513,907 2001 4.400 85,000 430,468 515,468 2002 4.500 90,000 426,727 516,727 2003 4.500 90,000 422,678 512,678 2004 4.600 95,000 418,627 513.627 2005 4.750 100,000 +14,.258 514.258 2006 4.875 810,000 409,507 1219,507 2007 5.000 890900 370.020 1,260.020 2008 5.000 980,000 325,520 1,305,520 2009 5,200 1,010,000 276,51-0 1,286.520 2010 5.000 1,065.000 224,000 1,289,000 2011 5.000 1,120,000 170,750 1390,750 2012 5,000 2,295.000 114.750 2,409,750 $8,790.000 $4,875,000 513.665.000 Principal payments we made annually on March 1, and interest payments are made semi-annually on March 1 and September 1. On December 1, 1995 the City of Cape Girardeau issued $9,095,000 of Waterworks System Refunding Revenue Bonds Series 1995 with interest rates varying from 3.9% to 5.2%. The bonds are special limited obligations of the City payable solely from the net income and revenues derived by the City from the operation of the Waterworks System after payment of costs of operation and maintenance. The bonds were issued to provide the City with funds to defease $8,090,000 principal amount of Waterworks System Revenue Bonds, Series 1992. The City transferred net proceeds of $8,711,864 to Mercantile Bank of St. Louis National Association, St. Louis, Missouri (the "Escrow Agent"), for deposit into an Escrow Fund established under an Escrow Trust Agreement dated December i, 1995 (the "Escrow Trust Agreement") between the City and the Escrow Agent. The proceeds were used to purchase direct obligations of, or obligations the principal of and interest on which are unconditionally guaranteed by, the United States of America. The refunded bonds shall be payable from the maturing principal of the Escrowed Securities, together with the earnings thereon for the period beginning March I. 1996, and continuing through March 1, 2002, the date on which the Refunded Bonds will be redeemed. W 36 W City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30. 1998 NOTE E - LONG-TERNI OBLIGATIONS - Continued Y„ S 2.210,000 Sewerage Svstem Revenue Bonds (State Revolving Fund Program) Series 1991 due as follows: $2,210,000 $1,492.935 $3.702,935 These bonds are dated December 1, 1991. The proceeds of the bond issue will be used to extend and improve the existing sewerage facilities serving the City. .. Principal payments are made annually on June 1, and interest payments are made semi-annually on June 1 and December I. The interest due on the 1991 Sewer System Revenue Bonds will be subsidized by interest earnings on a reserve fund held by the bond issue's trustee. As the City is reimbursed for sewer project expenditures from the construction funds held by the trustee, the Department of Natural Resources deposits an amount equal to approximately 51-907% of the reimbursement into the reserve fund. The maximum amount of funds that will be advanced to the reserve fund will be $1250,000. As bonds are paid off 50% of the amount of bonds paid off will be repaid to the Department of Natural Resources out of the reserve fund. The balance of the reserve fund at June 30, 1998 was $712,798. The reserve fund yields 6.71%. 0 37 M Year Ending Interest Principal Interest June 30 Rate Due Due Total 1999 6.200% $ 80,000 $ 49,794 $229,794 2000 6.300 85.000 144,834 229,834 2001 6.400 95,000 139,479 234.479 2002 6.500 100,000 133,399 233.399 2003 6.600 105,000 126.899 231,899 2004 6.875 110,000 119,969 229,969 _ 2005 6.875 120.000 112,406 232,406 2006 6.875 130.000 104.156 234,156 2007 6.875 135,000 95,219 230,219 2008 6.875 145.000 85,937 230,937 2009 6.875 155,000 75,969 230,969 ,. 2010 6.875 165.000 65,312 230,312 2011 6.875 175,000 53,969 228,969 2012 6.875 190.000 41,937 231,937 2013 6.875 205,000 28,875 233,875 2014 6.875 215,000 14.781 229,781 $2,210,000 $1,492.935 $3.702,935 These bonds are dated December 1, 1991. The proceeds of the bond issue will be used to extend and improve the existing sewerage facilities serving the City. .. Principal payments are made annually on June 1, and interest payments are made semi-annually on June 1 and December I. The interest due on the 1991 Sewer System Revenue Bonds will be subsidized by interest earnings on a reserve fund held by the bond issue's trustee. As the City is reimbursed for sewer project expenditures from the construction funds held by the trustee, the Department of Natural Resources deposits an amount equal to approximately 51-907% of the reimbursement into the reserve fund. The maximum amount of funds that will be advanced to the reserve fund will be $1250,000. As bonds are paid off 50% of the amount of bonds paid off will be repaid to the Department of Natural Resources out of the reserve fund. The balance of the reserve fund at June 30, 1998 was $712,798. The reserve fund yields 6.71%. 0 37 M , ": ,,, � 11:c u,rar,:cau, Yll".w I NOTES TO FINANCIAL STATEMENTS .lune 30, 1998 VOTE E - LONG-TERM OBLIGATIONS - Continued $ 451 A00 Sewerage Svstem Revenue $ands (State Revolving Fund Program) Series 1943 due as follows: .� Year Ending Interest Principal Interest June 30 Rate Due Due Total 1999 4.100% S 18,000 $ 22,511 S 40.511 2000 4.250 19,000 21,739 40-739 2001 4.400 19,000 20,917 39,917 2002 4.550 20,000 20J044 40-044 2003 4.700 21,000 19,096 40.096 2004 4.800 22.000 18,074 40-074 2005 4.900 23.000 16,983 39.933 2006 5,000 24X0 15.819 39,819 2007 5.100 25,000 14,582 39,582 2008 5.200 27,000 13,242 40'41_ 2009 5.250 28,000 11,805 39.805 .. 2010 5A00 30,000 10,260 40,260 2011 5.400 31.000 8.613 39.68 2012 5 400 33900 6.885 39.885 2013 5.400 35,000 5,049 40.049 2014 5.400 37,000 3,106 40,106 2015 5.400 39-000 1,053 40.053 S 451.000 $ 229-778 S 680.778 These bonds are dated August 1, 1993. The proceeds of the bond issue were used to extend and irnproce the existing sewerage facilities serving the City. Principal payments are made annually on March 1, and interest payments are made semi-annually on .w March I and September 1. The interest due on the 1993 Sewer System Revenue Bonds will be subsidized by interest earnings on + a reserve fund held by the bond issue -'s trustee. Els the City is reimbursed for sewer project expenditures from the construction funds held by the trustee, the Department of Natural Resources will deposit an amount equal to approximately 70.00% of the reimbursement into the reserve fund. The maximum " amount of funds that will be advanced to the reserve fund will be $350,000. As bonds are paid off, 70% of the amount of bonds paid off will be repaid to the Department of Natural Resources out of the reserve fund. The balance of the reserve find at June 30. 1998 was $315,700. The reserve fund yields 5.15°/x. 0 38 W Cit} ul Cape dirardeau. Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1998 NOTE E - LONG-TERM OBLIGATIONS - Continued S 11,440,436 Water Pollution Control Revenue Bonds (State Revolvine Fund Proeram) Series 1995D due as follows: These bonds are dated June 1, 1995. The proceeds of the bond issue will be used for the extension and improvement of the existing sewerage system serving the City. Principal and interest payments will be made annually on January 1 beginning in the year 1998 The interest due on the 1995D Water Pollution Control Revenue Bonds will be subsidized by interest earnings on a reserve fund held by the bond issue's trustee. As the City is reimbursed for sewer project expenditures from the construction funds, the Department of Natural Resources will deposit an amount equal to 70% of the disbursement into the reserve fund. The maximum amount of funds that will be advanced to the reserve fund will be 70% of the principal amount less the original issue discount. As bonds are paid off 70% of the amount of bonds will be repaid to the Department of Natural Resources out of the reserve fund. The balance of the reserve fund at June 30, 1998 was $6,634,672. 39 Year Ending Interest Principal Interest June 30 Rate Due Due Total 1999 4.850% S 21,134 S 3,866 S 25,000 2000 4.950 20,057 4,943 25.000 2001 5.100 913 209 291,791 1,205,000 .. 2002 5,250 913,677 366.323 1280,000 "_'003 5.300 918.381 441.619 1360.000 2004 5.400 924.769 530,231 L455.000 2005 5.500 928,413 626,587 1,555,000 2006 5.650 932.824 742,176 1.675.000 2007 5.750 937,566 862,434 1,800,000 2008 5.850 943.267 996,733 1,940,000 2009 5.950 946,770 1.143 230 1090,000 2010 6.050 722.409 992,591 1,715,000 2011 6.100 413.574 636.426 1.050.000 2012 6.150 380,828 654,172 1,035.000 2013 6.150 354,978 670,022 1,025,000 2014 6.200 326,281 683,719 1,010,000 2015 6.200 303,920 696,080 1,000,000 2016 6.250 278,844 706,156 985,000 2017 6.250 259,535 715.465 975,000 511,440,436 511.764.564 $23.205,000 These bonds are dated June 1, 1995. The proceeds of the bond issue will be used for the extension and improvement of the existing sewerage system serving the City. Principal and interest payments will be made annually on January 1 beginning in the year 1998 The interest due on the 1995D Water Pollution Control Revenue Bonds will be subsidized by interest earnings on a reserve fund held by the bond issue's trustee. As the City is reimbursed for sewer project expenditures from the construction funds, the Department of Natural Resources will deposit an amount equal to 70% of the disbursement into the reserve fund. The maximum amount of funds that will be advanced to the reserve fund will be 70% of the principal amount less the original issue discount. As bonds are paid off 70% of the amount of bonds will be repaid to the Department of Natural Resources out of the reserve fund. The balance of the reserve fund at June 30, 1998 was $6,634,672. 39 k- a% , -ape urardeau, Missuun NOTES TO FINANCIAL STATEMENTS June 30, 1998 NOTE E - LONG-TERM O LIGATION - Continued $ 13,5 35 000 Sewerage System Revenue Bonds (State Revolving Fund Program} Series 1996 due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total t999 $ 760,761 S 760.761 2000 4500% $ 25,000 760,761 785.761 2001 4.650 25,000 759,636 784.636 2002 =1.800 575,000 758,473 1333.474 2003 4.900 585,000 730,874 1.315.874 2004 5.000 590,000 702.209 1292209 2005 5.150 600,000 672,709 1,272.709 2006 5.2_50 610,000 641,809 1251.809 2007 5.350 690,000 609,784 1,299,784 2008 5.500 700,000 572,869 1272.869 2009 5.600 715,000 534,369 1,249.369 2010 5.700 730,000 494329 1224,329 2011 5.875 745,000 452,71 t) 1,197,719 2012 5.875 765,000 408,950 1,173,950 2013 5.875 780,000 364,006 1,144,006 2014 5.875 800,000 318,181 1,118,181 2015 5.875 875,000 271,181 1,146,181 2016 5.900 895,000 219,775 1,114,775 2017 5.900 920,000 166,970 1,086,970 2018 5.900 945,000 112,690 1,057,690 2019 5.900 965-000 56,935 1,021335 $13,535,000 $10,369,991 $23,904,991 These bonds are dated June 1, 1996. The proceeds of the bond issue will be used for the extension and improvement of the existing sewerage system serving the City. Principal payments will be made annually on January I beginning in the year 2000. Interest is paid semi-annually on January 1 and July 1 beginning in the year 1997. 40 0 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1998 NOTE E - LONG-TERM OBLIGATION - Continued The interest due on the 1996 Sewerage System Revenue Bonds will be subsidized by interest earnings on a reserve fund held by the bond issues trustee. As the Citv is reimbursed for sewer project expenditures from the construction funds, the Department of Natural Resources wili deposit an amount equal to 70% of the disbursement into the reserve fund. The maximum amount of funds that will be advanced to the reserve will be $9,474,500. As bonds are paid off 70% of the amount of bonds will be repaid to the Department of Natural Resources out of the reserve fund. The balance of the reserve fund at June 30. 1998 was $3,050230. $ 7.765,000 Building and Equipment Leasehold Refunding & Improvement Revenue Bonds (Capital Improvements Project). Series 1993 due as follows: The bonds are obligations of the Cape Girardeau (Missouri) Public Facilities Authority (CGPFA). The CGPFA has entered into a Lease Purchase Agreement with the City of Cape Girardeau. Missouri. Principal and interest will be paid by CGPFA from rental and other receipts from the City. The purpose of the bonds was to (1) pay the costs of various street improvements for the City, (2) defease $10,410,000 outstanding principal amount of Building and Equipment Leasehold Revenue Bonds of the Authority and (3) pay the costs of issuance of the Series 1993 Bonds. The bond principal is allocated as follows: $1,488,361 - Sewer Fund; $144,409 - Solid Waste Fund; and $6,132,230 - General Lona term Debt Account Group. Principal payments are made annually on March 1 and interest payments are made semi-annually on March 1 and September 1. 41 Year Ending Interest Principal Interest June 30 Rate Due Due Total 1999 4250% $ 2,340,000 $ 345.935 S 2,685,935 2000 4.400 2,915,000 246,485 3,161,485 2001 4.500 705,000 118,225 823,225 2002 4.625 720,000 86.500 806500 2003 4.750 420,000 53,200 473,200 2004 5.000 185,000 33,250 218,250 2005 5.000 480,000 24,000 504.000 $ 7,765,000 $ 907,595 $ 8.672,595 The bonds are obligations of the Cape Girardeau (Missouri) Public Facilities Authority (CGPFA). The CGPFA has entered into a Lease Purchase Agreement with the City of Cape Girardeau. Missouri. Principal and interest will be paid by CGPFA from rental and other receipts from the City. The purpose of the bonds was to (1) pay the costs of various street improvements for the City, (2) defease $10,410,000 outstanding principal amount of Building and Equipment Leasehold Revenue Bonds of the Authority and (3) pay the costs of issuance of the Series 1993 Bonds. The bond principal is allocated as follows: $1,488,361 - Sewer Fund; $144,409 - Solid Waste Fund; and $6,132,230 - General Lona term Debt Account Group. Principal payments are made annually on March 1 and interest payments are made semi-annually on March 1 and September 1. 41 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1998 NOTE E - LONG-TE14UM OBLIGATIONS - Continued $ 2.940.000 Certificates of Participation (Convention and Visitors Recreation Facilities Project), Series 1993. r Year Ending Interest Principal Interest June 30 Rate Due Due Total r 1999 4.500% S 235,000 $ 146,188 $ 40(,488 2000 4.700 295,000 135.013 430,013 2001 4.800 345,000 121.148 466,148 2002 5.000 400,000 104,588 504.588 2003 5-000 455,000 84,588 539.598 r 2004 5.125 510,000 61,838 571.838 2005 5250 680,000 35.700 715,700 r S 2.940.000 S 689,363 S 3.629.363 r The certificates are obligations of the City of Cape Girardeau, Missouri. Under a Lease Purchase Agreement between the City and the Cape Girardeau (Missouri) Public Facility Authority (the "Corporation"). the Corporation will assign the right to receive rentaland other receipts from the City to Union Planters Bank of Cape Girardeau County ( the trustee")- The purpose of the 1993 Series certificates is for the acquisition, construction, furnishing, and equipping of a convention and recreational center, softball and soccer fields, and improvements to the City Hall. The bond liability for the Series 1993 certificates is recorded in the General Long -lean Debt Account Group, Principal payments are made annually on April I, and interest payments are made semi-annually on April 1, and October 1. 42 Cit} olCapc Girardeau. lliowuri NOTES TO FINANCIAL STATEMENTS June 30, 1998 NOTE E - LONG-TERM OBLIGATIONS - Continued The certificates are obligations of the City of Cape Girardeau, Missouri. Under a Lease Purchase Agreement between the City and the Cape Girardeau (Missouri) Public Facilities Authority (the "Corporation"). the Corporation will assign the right to receive rental and other receipts from the City to Union Planters Bank of Cape Girardeau County (the "Trustee"). The purpose of the 1994A Series certificates is to (I) pay the costs of certain improvements to the City's waterworks and sewerage systems and costs associated with the closing of a City waste disposal site, (2) establish a debt service reserve fund for the Series 1994A Certificates, and (3) pay the costs of issuance of the Series 1994A Certificates. Ilse band liability for the Series 1994A Certificates is recorded in the Sewer, Water, and Solid Waste Funds. Principal payments are made annually on October 1, and interest payments are made semi-annually on .. April t and October 1. 43 S 3,040,000 Certificates of Participation (Twin Lakes Project), Series 1994A. Year Ending Interest Principal Interest lune 30 Rate Due Due Total 1999 4.800% $ 250,000 $ 158,635 $ 408.635 .. 2000 5.000 255,000 146,260 401,260 2001 5.100 260,000 133,255 393,255 2003 .5.200 275,000 119,475 394,475 2003 5350 280,000 104.835 384.835 2004 5.450 290,000 89,443 379.443 2005 5,550 300.000 73..^-15 373."_15 2006 5.650 310.000 56,132 366,132 2007 5.750 600,000 30,125 630,125 2008 5.800 70,000 10,845 80,845 2009 5.850 70,000 6,768 76,768 2010 5.900 80,000 2.360 82.360 $ 3,040.000 $ 931348 53,971348 The certificates are obligations of the City of Cape Girardeau, Missouri. Under a Lease Purchase Agreement between the City and the Cape Girardeau (Missouri) Public Facilities Authority (the "Corporation"). the Corporation will assign the right to receive rental and other receipts from the City to Union Planters Bank of Cape Girardeau County (the "Trustee"). The purpose of the 1994A Series certificates is to (I) pay the costs of certain improvements to the City's waterworks and sewerage systems and costs associated with the closing of a City waste disposal site, (2) establish a debt service reserve fund for the Series 1994A Certificates, and (3) pay the costs of issuance of the Series 1994A Certificates. Ilse band liability for the Series 1994A Certificates is recorded in the Sewer, Water, and Solid Waste Funds. Principal payments are made annually on October 1, and interest payments are made semi-annually on .. April t and October 1. 43 City of Cape Girardeau. Missouri NO 1 LS TO FINANCIAL S 1'A I LLIENI'S June 30. 1998 .. NOTE E - LONG-TERM OBLIGATIONS - Continued $ 2.435,000 Certificates of Participation (Capital Improvements Proiectsl. Series 1997A. r Year Ending Interest Principal Interest June 30 Rate Due Due Total 1999 4.625% $ 230,000 $ 118,231 $ 348,231 2000 4.625 245,000 107,594 352,594 W 2001 4.750 255,000 96,262 351,262 2002 4.800 270,000 84,150 354,150 2003 4.900 275,000 71,190 346,190 ,r 2604 4900 285,000 57,715 342,715 2005 5.000 490,000 43.750 533.750 .. 2006 5.000 50,000 19,250 69.250 2007 5.000 335,000 16,750 351,750 ^� $ '2.435.000 $ 614,892 $3.049.892 The certificates are obligations of the City of Cape Girardeau, Missouri under a Lease Purchase Agreement between the City and the Cape 0irardeau (Missouri) Public Facilities Authority (the "Corporation'), the Corporation will assign the right to receive rental and other receipts from the City to Union Planters National Bank (the "Trustee"). The purpose of the 1997A Series certificates is to ( 1) pay the costs of completing the construction, furnishing and equipping of a convention and recreational facility that constituted part of the 1993 project, (2) pay the costs of acquiring, constructing, furnishing and equipping various equipment and capital improvement projects, (3) fund the debt service requirements for the Series 1997A Certificates, and (4) pay the costs of issuance of the Series 1997A .. Certificates. The bond liability for the Series 1997A Certificates is recorded in the General Long -Term Debt +• Account Group, Data Processing and the Equipment Replacement Fund. Principal payments are made annually on April 1, and interest payments are made semi-annually on April 1 and October t. 44 Cih of Cape Ginrdcau_ Missoc:i .. NOTES TO FINANCIAL STATEMENTS June 30. 1998 NOTE E - LONG-TERM] OBLIGATIONS - Continued $ 690.000 Certificates of Participation (Capital Improvements Projects), Series 1997B. Year Ending Interest Principal Interest June 30 Rare Due Due Total 1999 4.700% $ 75,000 $ 33,795 $ 108.795 2000 4.700 80,000 30,270 110.1_70 2001 4.800 80.000 26,510 106.510 2002 5.900 80.000 22,670 102,670 2003 5.000 85.000 18.750 103.750 2003 5.000 85.000 14,500 99.100 "_'005 5 000 1_05.000 10,250 215.250 $ 690.000 $ 156.745 5 846.7+5 The certificates are obligations of the City of Cape Girardeau, Missouri under a Lease Purchase .. Agreement between the City and the Cape Girardeau (Missouri) Public Facilities Authority (the "Corporation'), the Corporation will assign the right to receive rental and other receipts from the City to limen Planters National Bank (the "Trustee"). The purpose of the 1997B Series certificates is to (1) defease $755.000 outstanding principal amount of Cape Girardeau (Missouri) Public Facilities Authority, Building and Equipment Leasehold Revenue Bonds (Airport Improvement Project) Series 1990B, and (2) pay the costs of issuance of the Series 1997B Certificates. The bond liability for the Series 1997B Certificates is recorded in the General Long -Term Debt Account Group. Principal payments are made annually on April 1, and interest payments are made semi-annually on April 1 and October 1. 4n Citv of Canc Girardeau, Misnnri NO LS 1O F1tiANC1Al STArEmLNk 1rS June 30, 1998 NOTE E - LONG-TERM OBLIGATIONS - Continued The annual requirements to amortize all debt outstanding as of June 30, 1998 including total interest payments of $33,753,781 are as follows: Year Ending June 30 1999 2600 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 General Obligation Bonds $ 468,806 463.488 461.805 463,555 458.875 458.22' 461.250 $ 3.235,904 Certificates Leasehold Revenue Revenue Bonds Bonds $ 2,199,857 $ 2,685,935 2.251.720 3,161,485 3,471298 821225 4,128.743 8064,500 4,218.827 473,200 4.331.727 21U50 4,441,702 504,000 4,583.584 - 4,629,605 - 4.789,568 - 4,896,663 - 4,498,901 - 3,807,051 - 4,890,522 - 2,442,930 - 2,398,068 - 2,186,234 - 2,099,775 - 2,061,970 - 1,057,690 - 1.421,935 1,021.935 $ 7Q409.370 $ 8.672,595 Certificates of Participation Total $ 1,267,149 $ 6,621.747 1,294,137 7.170.830 1,317,175 6.074.503 1,355,883 6.754.681 1,374,363 6.525 265 1.393,496 6.401598 1.837,915 7,244.867 435,382 5,018.966 981,875 5,611,480 80,845 4,870.413 76,768 4,973,431 82,360 4.581261 - 3.807.051 4.890522 - 2,442,930 - 2,398,068 - 2,186,234 2099.775 - 2,061,970 - 1,057-690 1,021.935 $ 11,497.348 $ 93,815,217 The cash available to service Revenue Bonds are $2,146,534 and $1,173,099 for the Sewer Fund and Water Fund respectively. 46 City of Cape Girardeau. Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1998 NOTE E - LONG-TERM OBLIGATIONS - Continued The cash available to service the Leasehold Revenue Bonds in the Enterprise Funds and the General Long-term Debt Account Group are $303,364 and $2,250,715 respectively. The cash available to service the Certificates of Participation in the Proprietary Funds and the General Long-term Debt Account Group are $452,488 and $492,415 respectively. Included in restricted cash on the balance sheet of the Proprietary Funds is $14,877,578 which is the balance in the various project accounts which represent incomplete projects at Jane 30. 1998. If the project funds are not used, the remaining balance can be applied against debt. The Citv is in compliance with all significant limitations and restrictions contained in the various bond indentures. During the fiscal year ended June 30, 1996, the City defeased (in -substance) $8,090,000 of Water Revenue Bonds. New debt was issued and the proceeds were used to purchase U.S. government securities that were placed in trust funds. The investments and fixed earnings from the investments are sufficient to fully service the defeased debt until the debt is called at par on March 1, 2002. For financial reporting purposes, the debt has been considered defeased and therefore removed as a liabilitv on the face of the balance sheets In June 1997 the City of Cape Girardeau issued Certificates of Participation to defease (in -substance) $755,000 of Building & Equipment Leasehold Bonds, Series 1990B. On September 1. 1997 the refunded bonds were called for redemption at a price of 1005%. As a result of the in -substance defeasance, the City reduced its total debt service requirements by $77,270, which resulted in an economic gain (difference between the present value of the debt service payments on the old and new debt) of $32,708. NOTE F - CAPITAL LEASE OBLIGATIONS In prior years, the City acquired certain equipment under capital leases. The assets and liabilities under capital leases were recorded at the lower of the present value of the minimum lease payments or the fair value of the asset. The assets are amortized over their estimated productive lives. Current amortization expense is included in depreciation expense. No capital lease obligation existed as of lune 30, 1998. 47 0 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATENIEN"CS June 30.1998 NOTE G - DEFICIT FUND BALANCESIRETAINED EAILNINGS The following individual funds have deficit fund balances/retained earnings at June 30, 1998. Enterprise Funds Solid Waste Fund $ 819,127 Golf Course Fund 20,852 ., Softball Complex Fund 155.072 Capital Projects Funds Water Projects 749.596 Special Revenue Funds Vision 2000 3.721 0 NOTE H - PENSION PLAN 1, Plan Description .. The City of Cape Girardeau participates to the Missouri Local Government Employees Retirement System (LAGERS), an agent multiple -employer public employee retirement system that acts as a common investment and administrative agent for local govemment entities in Missouri. LAGERS is a defined benefit pension plan which provides retirement, disability, and death benefits to plan members and beneficiaries. LAGERS was created and is governed by statute, Section RSMo. 70.600 - 70.755. As such, it is the system's responsibility to administer the law in accordance with the expressed intent of the General Assembly. The plan is qualified under the Internal Revenue Code Section 401 A and it is tar exempt - The Missouri Local Government Employees Retirement System issues a publicly available Financial report that includes financial statements trod required supplementary information. That report may be obtained by writing to LAGERS, PO Box 1665, Jefferson City, MO 65102 or by calling 1-800-447- 4334. 2. Funding Policy The City of Cape Girardeau's full-time employees do not contribute to the pension platy. The political subdivision is required by state statute to contribute at an actuarially determined rate; the current rate is 8.7% (general), 7.9% (police) and 149% (fire) of annual covered payroll. The contribution requirements of plan members are determined by the governing body of the political subdivision. The contribution provisions of the political subdivision are established by state statute. cg 0 Cin ofCape Girardeau. %lissoun NOTES TO FINANCIAL STATEMENTS June 30, 1998 NOTE H - PENSION PLAN - Continued 3. Annual Pension Cost For 1998, the political subdivision's annual pension cast of $887,717 was equal to the required and actual contributions. The required contribution was determined as part of the February 29, 1996 and/or 1997 annual actuarial valuation using the entry age actuarial cost method. The actuarial assumptions included (a) a rate of return on the investment of present and future assets of 7.0% per year, compounded annually, before retirement and 4.0% per year, compounded annually, after retirement, (b) projected salary increases of 4.0% per year, compounded annually, attributable to inflation, (c) additional projected salary increases ranging from 0.04'.to 4,0% per year, depending on apse, attributable to seniority/merit, and (d) pre -and post-retirement mortality based on the 1984 Group Annuity Mortality table set back no years for men and 6 years for women. The actuarial value of assets was determined using techniques that smooth the effects of short-term volatility in the market value of investments over a five-year period. The unfunded actuarial accrued liability is being amortized as a level percentage of projected payroll on an open basis. The amortization period at February 28, 1998 was 15 pears. Three -Year Trend Information Fiscal Annual Percentage Net Year Pension Of APC Pension Ending Cost (APQ Contributed Oblieation 06/30/96 779,824 100% 0 ,. 06/30197 753.807 100% 0 06/30/98 887,717 100% 0 49 Note: The above assets and actuarial seemed liability do not include the assets and present value of benefits associated with the Benefit Reserve Fund and the Casualty Reserve Fund. The actuarial assumptions were changed in conjunction with the February 29, 1996 annual actuarial valuations. NOTE I - INTEREST EXPENSE Interest cost, including handling charges, totaling $3,099,891. excluding $241,296 of interfund interest, was incurred during the year ended .lune 30, 1998. No interest cost was capitalized as part of the cost of assets constructed during the period. 50 City uCCupc Girardeau, �lissuuri NOTES TO FINANCIAL STATEMENTS June 30, 1998 NOTE H - PENSION PLAN - Continued 3. Annual Pension Cost — Continued Required Supplementary Information Schedule of Funding Progress (a) (b) (b -a) (a/b) (c) (b-a)/c) Entry Age Unfunded UAL as a Actuarial Actuarial Actuarial Accrued Annual Percentage of Valuation Value Accrued Liability Funded Covered Covered Date of Assets Liabilitv (UAL) Ratio Payroll Pavroll 02/29/96 11,745,277 13,096.931 1,351,654 90% 8,010.696 17% 02128197 13,511,019 14,466.970 955.951 93% 8,75,334 11% 02/28/98 15,866,088 15,663.640 (202,448) 101% 9,166,334 ( 2%) �. Note: The above assets and actuarial seemed liability do not include the assets and present value of benefits associated with the Benefit Reserve Fund and the Casualty Reserve Fund. The actuarial assumptions were changed in conjunction with the February 29, 1996 annual actuarial valuations. NOTE I - INTEREST EXPENSE Interest cost, including handling charges, totaling $3,099,891. excluding $241,296 of interfund interest, was incurred during the year ended .lune 30, 1998. No interest cost was capitalized as part of the cost of assets constructed during the period. 50 City of Cape Girardeau, Missouri N01TES TO FINANCIAL STATEMENTS June 30, 1998 NOTE.i - INTERFUND RECEIVABLES AND PAYABLES T he following is a summary of interfund balances as of June 30,1998: Due to/from other funds. Dau to Dac from r Gencrnt Pond S 1.359.545 $ Capital Impnnen,ant Sales Tan {Water t§qed) 694.666 CDBG I and 550 Water Prnjacis fund 694,666 seer, Fund 1 3588 995 _S_2,05d.2t7 S 2054211 51 Advance to/from other funds; Advanae5 fmm Ad,ilm , W General Prmd 1,867,500 $ - .� 5c,v, Fund 337,500 Solid Waste Pond 950,000 GonCcuse l=and 390,000 sonbnll Cmnplcc I'nnd _ 190,000 r $ 1 867,500 $ 1867 500 NOTE K - SEGMENT INFORMATION FOR IdNTERPRISE FUNDS The City maintains five enterprise finds which sewer, water, solid waste, golf, and softball .. provide complex services. Segment information for the year ended June 30, 1998 was as follows: softball so", Wamr Solid Wvsta (loll Course Complex Tatal (;and Pond Fund land Fund en(crp-i Upcmtiagmvcnues $2;150.141 $4(189,903 $2.138,313 $482,844 S 98.949 5 9,260,150 Depreciation 8)4.985 389.834 231,892 63,230 8,506 1,588,447 Operating lncome(l.oss) 381,522 823.853 217,657 (15,993) (203,185) 1.202,854 operating natters in 2.06,000 206,01d) No lncotna (Loss} (71,162) 229,965 185,746 (25,068) (7,931) 311,150 Current Canal Comrihatlma 273931 1.660.915 - 1934,866 Prnperty, Clantand Fyolpmcnt .rr Additions 9.0011156 2.088.001 139,840 43,545 - 11,274,442 Dcictioos (72,1(,8) (36,395) (101,456) (40,630) - (250.b49) Net Workpng Capital 15.481,187 2.641,314 (72,412) (352,345) (188,066) 17,509,678 Total Ascots 54.518.388 17,054,861 2.002.880 412.,337 76,309 74,064,775 Bonds and tlther L.ng Term Liao i lilies Payable Irmo ( 1pcmting kccunw 33,040,612. 11=39,602 46(W00 - - 45,040,214 Inal E4uin $17.734.755 $ 4.314,385 S(530..542) $ (2(,207) $ (151.946) $21,346,445 51 Cite of Cape Girardeau. Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1998 NOTE L - RESERVATION OF FUND EQUITY At lune 30, 1998, the City had reserved its fund equity as follows: General Fund Reserved for prepaid items $ 64,271 Reserved for advance 2,057,500 Reserved for mausoleum maintenance 63,834 Reserved for police projects 15,438 Reserved for encumbrances 75.053 $ 2.906-116 M �2 0 Special Revenue Funds ConventionNisitors Fund Reserved for encumbrances $ 15_'78 Airport Reserved for prepaid items 16.557 Reserved for encumbrances 663 ++ Parks and Recreation Fund Reserved for prepaid items 503 Reserved for encumbrances 1,537 +. Transportation Sales Tar Trust Fund Reserved for encumbrances _ 1.383.470 $ 1.418.1108 .. Debt Service Fund Reserved for debt service $ 3.593.632 .. Capital Projects Funds General Capital Improvement Fund Reserved for debt service $ 977 W Reserved for bond capital expenditures 6,414 Reserved for encumbrances 16,450 Corp Flood Control Fund .. Reserved for encumbrances 110,28$ Street Improvements Reserved for encumbrances 38,856 FAU Street Grants Fund Reserved for encumbrances 11,984 Community Development Block Grant Fund Reserved for economic development loan repayments 89,004 Reserved for encumbrances 13,600 Water Projects Fund Reserved for encumbrances 750.556 $ 1,038.126 M �2 0 NOTES TO FINANCIAL STATEMENTS June 30, 1998 NOTENI - RESERVED RETAINED EARNINGS AND RESTRICTED ASSET ACCOUNTS As of Jure 30, 1998, the reserved portion of retained earnings for the Sewer Fund is as follows: Reserved for debt service $ 31.667 Total reserved retained earnings $ 31.667 .At June 30. 1998, the City has restricted' assets in its Proprietary Funds as follows: NOTE, N - LANDFILL CLOSURE AND POSTCLOSURE CARE COST State and federal taws and regulations require the City to place a final cover on its landfill when closed and perform certain maintenance and monitoring functions at the landfill site for thirty years after closure. The City closed its landfill in the fiscal year ending June 30, 1994, and an expense provision and related liability were recognized at that time based on the future closure and postclosure care costs that were estimated to he incurred near or after the date the landfill no longer accepted waste. The entire amount of the estimated total costs for landfill closure and postclosure care costs was recognized in prior years since the recognition is based on landfill capacity used to date and the landfill was filled to capacity in prior years. The estimated total future liability for landfill postclosure care costs is $806,078 as of June 30, 1998, which is based on the amount that would be paid if all equipment, facilities, and services required to close, monitor, and maintain the landfill were acquired as of June 30, 1998. However, the actual cost of closure and postclosure care may be higher due to inflation, changes in technology, or changes in landfill laws and regulations. The City of Cape Girardeau has used the option of a Contract of Obligation as the financial assurance instrument for the landfill. The City issued bonds in October 1994 from which the proceeds have been used to pay the closure costs. 53 Revenue Bond Bond Sinkin_ and Construction Reserve Fund Total Scwer Fund $14.036,437 3 2,734.9-14 $16.761.381 Water Fund 829.903 1,337,118 2.067.021 Solid Waste Fund 3,670 103.178 106.848 Data Processing Fund 15.982 121 16.103 Equipment Replacement Fund ISBs 124 1.709 $14.877577 $ 4.075,485 $18,953,062 NOTE, N - LANDFILL CLOSURE AND POSTCLOSURE CARE COST State and federal taws and regulations require the City to place a final cover on its landfill when closed and perform certain maintenance and monitoring functions at the landfill site for thirty years after closure. The City closed its landfill in the fiscal year ending June 30, 1994, and an expense provision and related liability were recognized at that time based on the future closure and postclosure care costs that were estimated to he incurred near or after the date the landfill no longer accepted waste. The entire amount of the estimated total costs for landfill closure and postclosure care costs was recognized in prior years since the recognition is based on landfill capacity used to date and the landfill was filled to capacity in prior years. The estimated total future liability for landfill postclosure care costs is $806,078 as of June 30, 1998, which is based on the amount that would be paid if all equipment, facilities, and services required to close, monitor, and maintain the landfill were acquired as of June 30, 1998. However, the actual cost of closure and postclosure care may be higher due to inflation, changes in technology, or changes in landfill laws and regulations. The City of Cape Girardeau has used the option of a Contract of Obligation as the financial assurance instrument for the landfill. The City issued bonds in October 1994 from which the proceeds have been used to pay the closure costs. 53 City of Cape unrardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30,1998 NOTE O - RISK NIANAGEMENT ,. The government is exposed to various risks of loss related to torts; theft of, damage to and destruction of assets; errors and omissions; natural disasters and employee health benefits. These risks, with the exception of those discussed in the following paragraphs, are covered by commercial insurance. Settled claims have not exceeded this commercial coverage in any of the past three fiscal years The City is a member of the Missouri Public Entity Risk Management Fund, a not-for-profit public entity insurance pool established by the state legislature. Through this pool the City receives coverage for general liability, law enforcement liability, vehicle loss and accident liability. errors and omissions, and employee benefit liability. Risks for these coverages are spread across members of the fund. Currently the fund is comprised of 580 Missouri counties, municipalities and, special districts_ Premiums for these coverages are actuarially determined based on actual claims of the pool and individual claims of the City. Each year, portions of premiums not required because of below expected claims are returned to the members. The City has received refunds of premiums in each of the last five veers and has used them to offset the cost of the succeeding year's premiums. i'hc Citv has established self-insurance plans for employees` health insurance and workers' compensation. Both of these are accounted for using internal service funds. Under each plan the City is substantially self-insured and uses an administrator to handle claims management. The City's health insurance plan is a minimum premium plan administered by Continental Assurance Company which has a "A" rating by A. M. Best. Under this plan the City pays the administrator a monthly premium for claims administration, claims pooling, and final claims coverage. The City reimburses the administrator for claims paid up to $50,000 annually per employee and approximately $800,000 annually for all employees. Rates are charged by the internal service fund to the other city funds to cover this maximum liability. Ten per cent of all claims paid by the administrator in excess of the maximum annual liability in any given policy year may be carried over into the following policy Year. The City's workmen's compensation plan is administered by Galligher Bassett Inc. Under this plan the City pays the administrator a per claim fee to administer it's claims. All claims are paid directly by the City. The City has purchased insurance coverage from Safety National Casualty Corp. that limits the .. maximum claims to $225,000 and $275,000 per regular employee and police employee respectively. Additionally, $1,000,000 in coverage is provided for annual claims in excess of $535,000. Rates are charged by the internal service fund to the other city funds based on rates and experience factors established by the National Council on Compensation Insurance, Safety National is rated "A- 8" by A. M. Best. 54 w Cat of Cape Uirardeau, Nlissoun NOTES TO FINANCIAL STATEMENTS June 30, 1998 NOTE O - RISK MANAGEMENT - Continued i The City has uncollateralized utility accounts receivable generated within a limited geographical region primarily consisting of its city limits 1'he City also has taxes, special assessments, and user fees .. receivable which are concentrated among its citizens. Some of these items attach as liens against real and personal property The maximum accounting loss is the amount shown as utility charges receivable on the Combined Balance Sheet. At June 30, 1998, utility receivables totaled $1,766,930. On the financial statements, the utility receivables are shown net of the allowance for doubtful accounts of $683,414. This results in net utility receivable of $1,083,516. 55 Claims liability is estimated using data supplied by the administrator. The claims activity during the last three years is summarized as follows: CLAINIS LIABILITIES RECONCILIATION Health Workers' Insurance Compensation Total Batancc, July 1, 1995 $ -188,7 11 $ 155,525 $ 344,244 Proaision for Incurred Claim's' 761,641 176,055 937,696 PavmentsofClaimsX42,234 (140.160) (882.394) .. Balance, July 1, 1996 $ 208,126 $ 191,420 S 399,546 Provision for Incurred Claims 647,134 173.081 820,215 Payment of Claims (7:'.0,066) (207.562) _ (92Z6i8) Balance. July 1. 1997 135,194 $ 156,939 $ 292,133 Provision for Incurred Claims 989,135 403,511 1,392,646 Payment of Claims(904329) _. (171A54) .075.783) Balance June 30. 1998 $ 220,000 S 388996 $ 608.996 NOTE P - CONCENTRATION OF CREDIT RISK/BAD DEBT ALLOWANCE i The City has uncollateralized utility accounts receivable generated within a limited geographical region primarily consisting of its city limits 1'he City also has taxes, special assessments, and user fees .. receivable which are concentrated among its citizens. Some of these items attach as liens against real and personal property The maximum accounting loss is the amount shown as utility charges receivable on the Combined Balance Sheet. At June 30, 1998, utility receivables totaled $1,766,930. On the financial statements, the utility receivables are shown net of the allowance for doubtful accounts of $683,414. This results in net utility receivable of $1,083,516. 55 City of Cape (iirardcaii. Vissuuri NOTES TO FINANCIAL STATEMENTS June 30.1998 NOTE. Q - COMMITMENTS AND 1. Litt atg tion Various claims and lawsuits are pending against the City. In the opinion of City management, die potential loss on all claims and lawsuits will not be significant to the City's financial statements. 2. Grant Audit The City receives Federal and State Grams for specific purposes that are suhject to review and audit by various Federal and State a,2encies- Such audits could result in a request for reimbursement by any of .. the Federal and State agencies for expenditures disallowed under the terms and conditions of the appropriate agency. in the opinion of City management. such disallowances. if any, will not be significant. 3. Construction Commitments As of June 30. 1998, the City had construction commitments outstanding of S4,04151 5. 4. Encumbrances y M As of June 30, 1998. the City had encumbrances outstanding of $6,335,348. 5. Environmental Remediation City management is aware of one instance of environmental contamination and another instance of noncompliance with environmental regulations, but not involving contamination, of City owned property. City management is actively resolving these concerns. A Plan Of Action has been approved by the Missouri Department of Natural Resources ("DNR") for the contamined site. Also, the City is upgrading the noncontaminated site to current DNR standards. In the opinion of City management, the expenses associated with environmental remediation of these and other potential sites will not be significant to the City's financial statements. 56 t.;n of cape Wrardcau. .Mlusoun NOTES TO FINANCIAL STATEMENTS June 30, 1998 NOTE R - CONTRIBUTED CAPITAL NOTE T - PRIOR PERIOD ADJUSTMENTS Beginning fund balances and pooled cash and investments were increased $48,092 and $5,521 in the general and transportation sales tax funds respectively. Beginning pooled cash and investments were decreased and beginning construction in process was increased by $53,613 in the sewer fund. Beginning accumulated depreciation was increased and beginning retained earnings was decreased by $10,872 in the water fund. A portion of the general fund change and all the sewer fund changes resulted from fiscal year ending June 30, 1997 general fund internal engineering charges of $53,613 not being appropriately charged to capital projects in the sewer fund. The remainder of the general fund change and all the transportation sales tax fund change resulted from general fund expenses being charged to the transportation sales tax fund in error in fiscal years ending June 30, 1996 and 1997. General fund expenses were understated and transportation sates tax fund expenses were overstated $1,860 and $3661 for these two years respectively. The water fund changes resulted from depreciation expense that was not recognized in error in each of the two preceding years. Depreciation expense for fiscal years ending June 30, t996 and 1997 were understated by $5,436 in each year. 57 The changes in the contributed capital accounts for the enterprise funds were as follows: Solid Golf Softball sources Sewer Water Waste Course Complex Total Beginning Balance July L 1997 $16,739.900 S L938.546 S 288,585 S 645 S 3,126 SI8.970.80'- Contributing Sources: i Donated asset by developers 60,896 147,466 - - - 208,362 Conneetioa fees 153.311 - - - - 153,311 State & Federal Grants 59.724 1,513,469 1.573,193 Ending Balance. une 30, 1998 517.013.831 S 3592481 S 288585 $ 645 S 3.136 $20,905.668 NOTE S - EXCESS OF EXPENDITURES/EXPENSES OVER APPROPRIATIONS For the year ended June 30, 1998 expendiumes/expenses exceeded appropriations in the individual funds as follows: Budget Actual Variance Vision 2000 $ 5,000 $ 6,608 $ 1,608 General Capital Improvement Fund 49,200 51,945 2,745 Corp Flood Control 1,488.000 1.636,623 148,623 Street Improvement Fund 30,000 58,649 28,649 Park Improvements Fund - 151,483 151,483 Golf Course Fund 463,101 478,508 15,407 Softball Complex Fund 276,904 293,688 16,784 Data Processing Fund 976,411 984,194 7,783 Employee Fringe Benefit Fund 980,000 1,470,871 490,871 Equipment Replacement Fund 460,969 464,512 3,543 NOTE T - PRIOR PERIOD ADJUSTMENTS Beginning fund balances and pooled cash and investments were increased $48,092 and $5,521 in the general and transportation sales tax funds respectively. Beginning pooled cash and investments were decreased and beginning construction in process was increased by $53,613 in the sewer fund. Beginning accumulated depreciation was increased and beginning retained earnings was decreased by $10,872 in the water fund. A portion of the general fund change and all the sewer fund changes resulted from fiscal year ending June 30, 1997 general fund internal engineering charges of $53,613 not being appropriately charged to capital projects in the sewer fund. The remainder of the general fund change and all the transportation sales tax fund change resulted from general fund expenses being charged to the transportation sales tax fund in error in fiscal years ending June 30, 1996 and 1997. General fund expenses were understated and transportation sates tax fund expenses were overstated $1,860 and $3661 for these two years respectively. The water fund changes resulted from depreciation expense that was not recognized in error in each of the two preceding years. Depreciation expense for fiscal years ending June 30, t996 and 1997 were understated by $5,436 in each year. 57 City of Cape Ghardeau, Missouri NOTI CS "10 FINAN('IAL S IATEMBN"I"S June 3n. 1998 NOTE U — CHANG E: IN ACCOUNTING PRINCIPLES 'I "he City changed its policy of accounting for cash and investments Iiom cost to fair market value in accordance with Statement No. 31 of the Govemmcntal Accounting Standards Board — Accounting and Financial Reporting for Certain Investments and fur External Investments Pools. The effect )]'the implementation of Statement No. 31 was to de<rcase beginning find balances by $748, $'.054, $13,099, and $1,373 fur the general fund, special revenue funds, debt service fund, and capital project funds, respectively. Additionally its implementation resulted in decreases to beginning retained earnings of $6,386 and $3,495 for the enterprise and internal service funds respectively. I lie City also changed its policy of accounting for its deterred compensation plan in aceordanu, with Statement No. 32 of the Governmental Accounting Standards Board — Accounting and Fiommial Reporting for Internal Revenue Code Section 457 Deferred Compensation Plans. During the current fiscal year both of the deferred compensation plans for City employees adopted changes that comply with the requirements of subsection (g) of Internal Revenue Code 457 which states that all assets and income of the plans arc held in trust for the exclusi c benefit of the participants and their beneficiaries. Additionally the plans fail to meet the criteria of NCGA Statement I that would require them to be reported in the City's financial statements. Previously the City had reported these plans under an Agency fund The implementation of Statement No. 32 resulted in the beginning investment and offsetting liability of this Agency fund being adjured lion $2,105,065 to aero. NOTE V —SUBSEQUENT EVENTS On December 2, 1998 the City issued $25,495,000 ht water revenue bonds through the State of Missouri Revolving Loan Fund. Proceeds of these honds w ill be used to expand the capacity of water plant #1 and make various other improvements to the distribution system. Previously voters of the City had . passed a/a% capital improvement sales tax that N� ill be used to pay the debt serviceof these bonds. 8 COMBINING AND INDIVIDUAL FUND FINANCIAL STATEMENTS City of Cape Girardeau, Missouri GENERALFUND COMPARATIVE BALANCE SHEET .. JUNE 30,1998 AND 1997 1998 1997 0 ASSETS Pooled cash and Investments $2,516,802 $2,323,371 Receivables, net of allowances for doubtful receivables Real estate, personal property and merchant taxes 43,468 38,982 Sales tax 640,708 737,308 Franchise tax 1,093,662 1,019,659 Special assessments receivable 71,230 52,450 Interest receivable 286,013 215,790 Other receivables 38,677 51,169 intergovernmental receivables ., Grants receivable 195,279 324,644 Oae from other funds 1,359,545 1,025,570 Advances to other funds 1,867,500 1,867,500 Inventories 123 627 r Prepaid items _64,271 55,210 Total assets $8,177,278 $7,712,340 LIABILITIES AND FUND BALANCES Accounts payable $651,177 $246,221 Accrued liabilities Salaries, payroll taxes and benefits 322,797 263,520 Other liabilities 165,089 129,281 Due to other governments 20 Deferred revenue 125,227 1,618,613 Total liabilities 1264,290 2,257,715 .. Fund Balances Reserved for prepaid items 64,271 55,270 Reserved for advances 2,057,500 1,867,500 r Reserved for mausoleum maintenance 63,834 60,022 Reserved for police projects 45,458 45,679 Reserved for encumbrances 75,053 69,313 Unreserved 4,606,872 3,356,841 Total fund balances 6,912,988 5,454,625 Total liabilities and fund balances $8.177,278 $7,712,340 Di"., E., G4..c," At-.- 6E11ERAl6Ut' SD [IF, DOLE OF REVENUES All! r EXPENDITURES NI IOGET AND A4: NAL (01 ^ 'GET UASIS) 1,11, 1 HE FCVAL IVAR ENUI', ]UNE 36,1998 VARIANCE FAVOFAOLE BUDGET ,ACNA4 NNFAVVOORA6LElr REVENUES Tavea Illgs9Ao60 S1?Dal018 $1916,655 L.1 -111v and pnmrls 91:900 991,988 84458 Intngov^tnmmtal DI - 11, 915.032 SOd.162 Gharyes lw sevlces 281635 316,856 29261 InHu"Inmenlal IF"", 6<p 900 5%.213 (36 1,27l £Ines --ANT fives Sx 1ID0 6i1,393 3113? Miacellananas f.6100 UK, SO 13599 Inveslmenl revenue 259500 275787 16,16) Spec%assesanleAls _ %tnl0 9145 _,.1145 TOTAL REVENUES 13,116WE 1843112 2,256,212 EXPENDITURES Cunene namnhlV,,d ervtt,Wi c. •r1B 21' 2,923 Human ea No u,i 164,111 A, 61iG 116,610 12 101 uttpor CAYmnlayer t9U 05 188_&92 125 ac ss 56960 40.997 5% )$598 5 "yompy 116956 169 7073COS44 6 351 Flc.F,omey f x1649 9%.849 2% PoR 441:60 436017 4,146 Total aaNmenlal Total amNlslrallv0 scrvlcert =,4]I:f.U_ 1 391,8&J ^45412 UOvabpmaut c'Rear25 Ptaming sercbes 215,409 215893 (]0,790) bapealla0ae1V1lc 306,69] 1.191 Pnalocunn9 471]IS 7.51Vu 149,428 26,010 Ccelicban mratiou dMvebpenn< aca 258110 65922 19,428 Public 3%,tl10 295,9111'1 development Tolalaevebpmenl aervicYa _ 1_1924N1_ _ 1,]96.181 M 359 36,3_ P.W. aMU.maatlar 915017 509 (6.559) cem"ESnlenen¢ 119.:(1] 11 111,730 1)95 F.Myac FT.W1m¢,iic s 1333% _ 1251[70 _ 13.514 IDlalpmks eoa lCelmnon _1,014 490. t O6z,eii_ 11,813 pNbbe aalery NAPPIN" cvplII 2128+9 193532 2,2W.M10] 4.116,275 WIDE 30,176 Fih. FII'a 2,8]],001 2,636,219 TOW Wb15 aa'elY 7,211 529 4I.T151 tl¢^t_ Pa%c —11 _t2sJ]a- Bbeel 19203M 1946, (26,99): Stotal 25I Ou6 2,22,619OFA �t8.dn� WNb Ta16I Y wa1M6 _ Ifi]6 u5U 1]22.9:9 _ H4 3991 CM6n9enq _ 651j89 110,211 Uebl Servme _925%0 JTHPNl anU Oacal mPr9% _ 22.194 (22 ,1911 -(22,194) Molal aonl arnlce _ _ 2212"^ TOTAL EXPERIMENTS 13101,012 13962123 23"13 EXCESS LDEiICENCY) OF REVENVE3 OVER (UNDER) EXPENDITURES =(MAS) 2,901019 222295225 OTHER FINANCING SOUR0E9(USES) O'loth,"Ponabrs i0 916 GS11 916,.60 O1Y1MN9 V,P,PI pR (f,65]•a_'.i _Ii.A46,t IA) 7bt4 TOTAL OTHER FINANCING SOURCES {USES) _ (9369171 _ (969650) 1.449 EXCESS (DEFICIENCY( OF REVENUES ANOOTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES (51 051,1211 $115155] $2,502614 !r f 1 1 l 1 i t 1 1 1 1 1 i 1 1 1 1 f 1 CRy of Cape Gba vr SPECIAL REVENUE FUN04 COMBINING OAIANCE SHEET Jona 30, 1999 With CompaMve Totals /or June 30,19971 CepBal Ita1 Cownmwn Impressment Impmeament Consent., 9uYneaf P. and Mobr III TZ Salad Taa Inaporthsn Rood Nalon Torala Vle� Altroa_jr OIs�Me _Re�c M_on XeaIM ua�To. No... Contro Resor Prof..'. Sales Tai ProfeOlon 2000 06/30/98 613017 ASSETS Pool ed dish and lnveslmems E]5R503 $So It. 53, 2IB $182212 $239, 19T 969588a 11,2]5,882 Ws,E63 $5501659 $311 911, ISE 30 56,508631 NorrlMolad lnvesimenll _ _ 1,002263 - - - 1002253 1,CW.5Ei ReceNaol es, net of allowances for .,.I renrvaolea Rea, I"Melav - - 5295 aWa _ _ _ _ _1 r2 _ _ _ _ _ _ 22 HoteLndtel as meervaoe 35 740 - - - _ - - 65 740 29,951 'Moo... W no—Whi9 50373 _ - 503]3 9,1% Motor fuel lad - v l -a, ea11M,es 4'3 1 ]49 - '2 - _ rG G{ �ni rest rese one 23,225 - 22225 33622 Gan1, rad. -N. - - _ - _ - Investor -19439 i31 _ _ _ _ _ - Ptoo Sf3 _ --• U:e _ ,r.s _ c94 OL6 _ . ti Total assets V650.55 $120245 $8®24 3192�TP $247 004 SB�Y4$24610]6 51338]PS i93�a JAB 'L179 AN0 FPG BALANCES nts payaole 11977$ $18,981 5 - 565,991 IISE56 $ - 5351,257 1 1]95 ]]4 9 $3952 51251,292 1200493 A4vued ado idles S alar) es peymll sexes and [meets a.__ 13202 X404 1 77�_ _ _ _ - _ Glnar 1460 421 DC erre0 revenue 34152 $296 7,093 1]79 _ Tdblrm nos 21 13 =6 2- .L.d eatan�a Reservmlpr drepaidneTla NE 157 mz - _ _ _ 17os9 lc lzs Raaened mr encumorances 'SZIa 654 - 1536 - - 1,393,4]0 - 1.100945 25'6.13] Unreserved 429_164 382'0 3278 63931. 231492 825 7C4 2110219 1338286 363].54 29� 372" 0 61, 7 _ _ Tolalfund Ealances 444442 55430 3278 65 9" 231492 825]04 2,110219 1,338,]88 5020994 297 11121) 1C ttH2 `84 7 941362 iotas) ropes a no land balances 5465455 $'R245 �V ZA Bt822'$] 124,004 $825704 $24614]6 51, -ESO $583463] sav 1131 511465 '.9B $9514,659 1 1 1 1 1 I 1 i 1 1 1 1 1 1 1 I 1 1 1 SPECIAL REVENUE FUNDS COMBINED STATEMENT OF RENENUES.0FEENORURES AND CNA AGES IN FUND BALANCE FOR TILE FISCAL YEAR ENDED JUNE ]e, 1990 CAPITAL CAPITAL DOWNTOWN .PF.BJ ENTPROVEMFNT MSALESTAY TRANSPORTA70N CONVENTIOW BUSINESS PARRS ANC MOTOR SALES TAX SALES 8000 VISION TOTALS 119 TO R5 A RPOpi DISTRICT RECREATION HEALTH FL EL TAS F LOQQ CONYI fVAER Pp OJECTE] TAX PROTECTION 2_000 I., REVENUES '�'e9over'nemel 25954048 S- 25'80.±] 5- 52052'2 5- 251 iS5C59 31.585591 94.4](1 5- IS27133< 4,801 115509 - C.wgmla eemye I BE 7351 [0795[ _ _ _ 1550 T5 NuuM,—, 'v- ll5 ss2 5 554 431 183 .ru m. venva +02550 ]Sb 5617 '1295 P]SE9 1:8 ±1P7zl 135 24' 111 _ _ TOTAL REVENUES 453_ 25017030 42 0±5 223 139 =±9455 1 F -,e 2, FL, j ZLi- - EIPENDITURE3 C—, 42S CIS BnLu- Ornlmrrlurvme 15]04 •.. .<'Sn9 un 1059 282 _ - - - - - 5 509 2[,908 _ - 192 W] - 1DERE .1 w] CAM AR, Slit 79t LES ELN 125u - IINNU. Ivf9ei 971 TOTAL EXPENDITURES 426045 524520 t5 ]0] 195E 582 '9200] .]t T ] ]01 -s'3 P49 - 28 EXCESS DEFICIENCY) OF REVENUES OVER UNDERI EXPENDITURES 585408I]94_2T01 ]1 935 14M 1 S174%IS_�137 �1.717171 �_ X851 35521 59ASO OTHER FINANCING SOURCES IUSESI O—S,V"N—, - 411. - P... 21C. - - 1]250 CW OKntln9-Y.— RA s21 FEE, I I CJ_ P 2'E C.]]1 17�4 1 15 0:54121 TOTAL OTIER FINANCING SOURCES (USES) 1524 0]01 JIG. 2CB C0]� 141 10,0451 122'25 .11 I]Tv 401 2:].04 155q±4121 EXCESS )DEFICIENCY( OF REVENUES ANO OTHER FINANCING SOURCES OVER (UNDO) EXPENDITURES ANO OTILER FINANCING USES )]B 592) ]], 2]0 1]]C 6059 Ti ]]5 25!]5 125)5441 1.085]]5 1]]4255 1<, 1551 i399, 115 602 FUND SAILANCES, JULY I� IRESTATEDI 4P], 0]d 177W 1518 5]Is 200.159 1. SIR 2]e], S.5] Z15 CS] ] 5BD852 4FE1 1]1 ] 9]5 941 PRIOR PERIOD ADJUSTMENT — 5521 5521 FUND BALANCES, JUNE 30 $4444440 $55430 53228 US 971 5231AW $825204 $2110319 $1 J]B 208 55 C20 084 539 13.72 1 S'9 192984 City of Cape Girardeau, Missouri CONVENTIONNISITORS SPECIAL REVENUE FUNIC SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGIE BASIS) FOR THE FISCAL YEAR ENDED JI INE 30, 1998 BUDGET ACTUAL REVENUES Taxes $880,000, $974,638 Charges for servlc, 5,500 5,468 Mlscellanfous - 787 Investment revenue 19,500 30,028 TOTAL REVENUES 905,000 1,010,921 EXPENDII URES Current Adminishnllve services 568,253 439,351 TOTAL EXPENDITURES 568,253 439,351 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 336,747 571,570 OTHER FINANCING SOURCES (USES) Operating transfers out (624,0 (624,000) TOTAL 0I I IER FINANCING SOURCES (USES) (624,000) (624,000) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($287,253) ($52,430) 6 VARIANCE FAVORABLE (UNFAVORABLE) $94.638 (32) 787 10.528 105,921 128,902 128,902 234,823 $234,823 r City of Cape Glrardean. Missouri AIRPORT SPECIAL REVENUE FUND SCHEDULE OF REVENUES AN') EXPENDITURES r. BUDGET AND ACI UAL (Bl IDGET BASIS) FOR THE FISCAL YEAR END' 0 JUNE 30, 1998 r BUDGET ACTUAL r REVENUI"S (.Ilarge9 for services $`4606 M14acellan^aus 101,820 Investmi ulrevenue r TOTAL REVENUES 1ttr,420 EXPENDITURES r Cunenl Adminlsh. Live services 520,124 Dabt Servun r Principal 13,500 Intere5l nrui fiscal charges TOTAL r=XPENDITURES 539,624 EXCMS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (432204) 0 [ HER FINANCING SOURCES (USES) ,. opcvs6ng nenstereln 432.260 ,. TO TAL 0 1 IER FINANCING SOURCES (USES) 432,250 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES r OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES $46 r 6 ', $17,861 108,852 3,457 130A70 '110,086 12,544 971 523,601 (393,431) 432,006 432,000 VARIANCE FAVORABLE !UNFAVORABLE) $12 261 032 3,457 22 iso 16,1138 956 (971) 16n23- 38,773 112338,773 (2w) (250) $38,569 $38,5:13 Clfy u1 C,,, Girardeau, Missouri DOWNTOWN BUSINESS DISTRICT SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGE I AND ACTUAL (BUDGET BASIS( FOR THE FISCAL YEAR ENDED JUNE 30, 1998 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) r 66 REVENUES Taxes $1],052 516,433 ($619) lmRznnwtl%venue 600 589 {11). r TOTALREVENUES „--._1!652 _ 17,022 (63,1) EXPENDITURES Cua"t Development services 15,325 .,,_. _ 15_300. 25 TOTAL EXPENDITURES _15325 _ 15,300 25 r EXCESS (DEFICIENCY) OF REVENUES OVER(UNDER) EXPENDITURES $2.327 $1.722 ($605) 66 City o1 Cape Girardeau, Missouri PARKS AND RECREATION SPECIAL REVENUE FUND �. SCHEDUL.E OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL tBUOGFT BASIS} FOR THE FISCAL YEAR ENDED JUNE 30. 1998 VARIANCE FAVORABLE BUDGET _ACTUAL JUNFAVORABLE) w REVENUES Cha+e..; Iorsrt toes $38'., 000 $407,854 $22„1154 Mls:ellaonous '.400 6,564 1,164 nt revenue _ 6,502 6.502 TOTAL REVENUES 390,400 _420,920 _ 30,520 w EXPENUIT TIRES Clurreut Parks and recreation 1,098.956 1 052,986 35,970 r TOTAL EXPENDITURES I,09R tV; 1,062,986 35,970 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (706556) (142,066) 66,490 r OTHER FINANCING SOURCES (USES) Operation transfers in _ 708,750 =708,000 (750) .+ TOTAL OTHER FINANCING SOURCES (USES) 708,750 708,000 _ 750) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES 3194 $65,934 $65,140 ww 68 City of Cape Girarde-m, Missouri HEALTH SPECIAL REVENUE FUND _ SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL p3UDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1998 VARIANCE FAVORABLE BUDGET ACTUAL JUNFAVORABLE) r REVENUES saxes S191,339 $205,212 $13,81) Intergovernmental 3,500 4,831 1.331 nveslment revenue 7,750 13,078 5,328 TOTAL REVENUES 202,589 223,121 20,532 EXPENDITURES oirrent Public safety _ 206,627 192,003 14,624_ TOTAL EXPENDITURES 206,627 192,003 _14,624 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (4,038) 31,118 35,156 TOTAL OTHER FINANCING SOURCES (USES) -_ ._ EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($4038) $31,118 $35,155 68 "q City of Cape Girardeau. MISsourl MOTOR FUEL. TAX SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) _ FOR THE FISCAL YEAR ENDED JUNE 30, 1998 r VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) r REVENUES nfp,i Wvernmv.nlal $1.:115.000 $1,355,697 $40,897 Investment revenue 40,000 82,055 42,055 .w TOTAL REVENUES 1.355,000 1,437,952 61„952 EXPENDITURES Cnnernt P01,c, orks 10,000 3,331 6669 TOTAL EXPENDITURES 10,060 3,331 (3,669 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 1345.000 1,434,621 69,621 OTHER FINANCING SOURCES (USES) Operaling transfers cot (1,4306( (1,410,000) 20,000 TOTAL OTHER FINANCING SOURCES (USES) (1,418000) (1,410,000) 217,000 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES �. OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES {$isS,tNHi) _ $24,521 $109,621 r "q City of Cape Girardeau, Missouri CAPI IAL IMPROVEMENT SALES TAX SPECIAL REVENUE FUND FLOOD CONTROL PROJECTS r SCHEDULE OF REVENUES ANI) EXPENDITURES - BUDGET AND ACTUAL (BI IDGET BASIS) FOR THE 1=1SCAL YEAR ENDI=.D JUNE 30, 1998 70 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) REVENUES I axes $1,707,500 $1,795,089 $87.589 Invnstnneut revenue 98,000 183,033 8'v.033 TOTAL REVENUES 1,805,500 1,978,122 172r622 EXPENDITURES Gumnt Pobliaworks 14,200 781 13,419 r TOTAL EXPENDITURES 14,200 781 13,419 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 1,791,300 1,977,341 186,041 OTHER FINANCING SOURCES (USES) Operating transfers out (2,235,0 (2,235,000) TOTAL OTHER FINANCING SOURCES (USES) (2,235,000) (2,235,000) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($443,700) ($257,659) $186.041 70 City of Cape Girardeau, Missouri CAPITAL IMPROVEMENT SALES TAX SPECIAL REVENUE FUND WATER PROJECTS SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1998 71 VARIANCE FAVORABLE BUDGET ACTUAL UNFAVORABLE) REVENUES Taxes $1,648,900 $1,785,591 $136,691 Investment revenue 52,144 52,144 TOTAL REVENUES 1,648,900 1,837,735 188,835 r TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 1,648,900 1,837,735 188,835 r OTHER FINANCING SOURCES (USES) Operating transfers out - (774402) (774402) TOTAL OTHER FINANCING SOURCES (USES) (774,402) (774,402) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES $1,648,900 $1,063,333 ($585,567) 71 72 City ofCape Gini au, Missmir, I RANSPORTA TION SALES TAX TFUST SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES - r BUDGET AND ACTH iBUDGET BASIS) FOR THE FISCAL YEAR I IJDED JUNE 30, 1938 VARIANCE FAVORABI.1'. BUDGET ACTUAL (UNFAVORABLE) REVENUES Faxes $3415 sJCO S3,494,371 $79,371 Miscellaneous - 16,318 16,318 Investment revenue 276.968 278.960 TOTAL REVENUES 3_415,000 ,13.789,657 _:374,657 EXPENDITURES Current Public wo,*s 5,087,900 _ 3,282,676 1.605,224 i TOTAL EXPENDI TURES 5.087,900 3.2282,676 1,805,224 EXCESS(DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (1,672,9001 506,981 2,179,881 OTHER IINANCING SOURCES (USES) O ratio rensfeTs (n pe gt 00,000 ...-?._... 210,000 _....._._ _ 10,000 TOTAL OTHER FINANCING SOURCES (USES) 200,000 210,000 _10,000,,, EXCESS (DEFICIENCY) OF REVENUES r AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND 0 FHER FINANCING USES ($1472,9 _ $716,981 $2,189,881 72 CO, of C:apc G➢ 11dvvu, Mixsom I FLOOD PROTECTION SPECEdL REVENUE FUND 73 SCHEDULE OF REVENUES ACR) EXPENDITURES - BUDGETANDACTUAL(I, DGE,T DA,I5) FOR THE FISCAL YEAR ENI I D JUNE 311,1998 n VARIANCE FAVORABLE DUUGET ACTUAL. IUNFAVORADLE) REVENUES _ Irrvestment revenue $100 $222. $122 TOTAL REVENUES 100 222 '122 EXPENDITURES Cnnont Alllninmt,ltive"MCCS 4,:30 4,511 TOTAL EXPENDITURES 4,750 4,511 239 EXCESS(DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (S4, 050) 1S4289). $361 73 7/, City of Cape Girarde,1o, Missouri VISION 2000 SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (L UDGET BASIS) FOR THE FISCAL YEAR ENI IED JUNE 30, 1998 VARIANCE o FAVORABLE BUDGET ACTUAL UNFAVORABLE) REVENUES Miscellaneous $5,000 $2,726 ($2,274) bweslmof revenue 29 29 TOTAL REVENUES 5,000 2,755 (2,245) EXPENDITURES Cwreot Development services 5,000 6,608 (1,608) I OTAL EXPENDITURES 5,000 6,608 (1,608) EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES $- ($3,853) ($3,853) 7/, w City of Cape Gm deau, Missouri DEBT SER" CE FUND COMPARATIVE F GLANCE SHEET JUNE 30, 191,8 AND 1997 1998 1997 - ASSETS Pooled cash and investments $3,093,152 $1,424 728 Non -pooled investments 400,935 2,046.433 Receivables, net of allowances for doubtful receivables Real estate, personal property and merchant taxes 13,795 12,071 Special assessments receivable 587,971 712,644 Interest receivable 16,501 28.827 r Total assets $4,192,354 $4,226, iO3 r LIABILITIES AND FUND BALANCES Accounts payable $ - $2.167 Interest payable 285 285 Deferred revenue 598,437 716,316 Total liabilities 598,722 718.768 Fund Balances Reserved for debt service 3,593,632 3,507.935 Total fund balances 3,593,632 3,507,935 Total liabilities and fund balances $4,192,354 $4226.. U3 1 I 1 1 ! 1 1 1 1 f 1 1 1 I 1 1 1 1 1 City of Cape Glra oes u, MIS snarl CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET Jon. 30, 1998 (With C.mparative T.W. for Juno 30, 1997) General Corp Capital Flood Street FAU Street CDBG Park Water Totals Improvement C.ntrol Improvem.nb Grant, Grant Improvemonb Projects 06130/98 06/30197 ASSETS Pooled cash and love Slmenll Han pooled Inveslmenls Grants receivable Special assessments receivable interest receivable Nolen receivable $94442 - - 35 $248426 301.963 82,337 1,165 - $244,093 42.046 - - - $244625 35,820 - - - $196,534 15733 - $137416 _ - 163 - $ - - 51.165,730 301,963 133,940 n204fi 1.363 $1.526,765 343.165 585,450 71 1 4 4 522 368 032 Total assets $94r477 $633.891 - $280,139 $280.695 $212,267 $137,573 $ .-.,645 042 $2,532 302 LIABILITIES AND FUND BALANCES Accounts payable Due to other pp,ernment, One to other funds D«Jerred revenue Total liabilities $1.274 - _ - $57013 11489 $ 40484- 40484 - $2.861 2,861 - - $15,982 2,207 18_739 550 S - - $54930 694,666 749_596 - 5132060 2,207 695,216 ___b_1973 _881,456 $291]76 1,C00 496.324 _78,A95 _67.507 1,276 68,502 rand balances PS,glad for debt service c-lerved for bond capdal c,andJurex fi Reserved for econemlc devloan repymnls. Reserved for encumbrances 16450 Unreservad 69,362 977 414 - 110,285 455.104 - - 36.856 206799 - 11,984 266,850 - 89,004 13,600 90,924 - 137,573 - - 750,556 (1,500,152) - - - 977 5.414 89,004 941,731 (274,540) 6 77,266 1,813,457 (233.015) 219 776 Total fund balances 93.203 565,389 245655 277,834 193,528 137,573 (749,596) 763,586 1,614 705 Total llabliffles and fund balances $94477 $633.891 $286,139 $280695 $212267 $137,573 $ $1,645,042 $2,532,302 C"iry of Cape Glrarae, Missouri CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVEo--- E—E.:1„RES ANO CHANGES IN FUND BALANCES FOR THE FISCAL YEAR ENDED JUNE 30,1990 GENERAL CORP FAU CAPITAL FLOOD STREET STREET CABG PARK WATER TOTALS IMPROVEMENT CONTROL IMPROVEMENTS GRANTS GRANT IMPROVEMENTS PROJECTS 19971998 REVENUES -•.-r- - - _- -a =.392 -_ c $3 __ Investment revenue 6'842 37650 24,411 566 11,794 12,914 176 94 355 Special a ... men15 24 461 5 064 TOTALREVENUES 1'998' -- 58= 70 EXPENDITURES C3PRal outlay 55257 1,5]8,561 i.]._ 116,013 200.858 164.252 1,223.835 3339571 Debt service Interest antl fral charges 4,146 2. C69 2.438 2].659 36.314 TOTAL EXPENDITURES 56,257 1,582,709 19 733 118.082 203.3C6 164.255 1 221 494 3375.891 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 149 4-5) (1,462]221 29C79 '?3D551 4380 1151331 (113'3181 293038?1 OTHER FINANCING SOURCES (USES) Oberon., vansfersln 16500 900.000 350.000 19,122 43.150 774402 2.1C3.174 Operating transfers out (5) (30.]50) - (43.151) - (73.906) TOTAL OTHER FINANCING SOURCES (USES) 16.495 900.cCC (36]50) 352,LCO 19,122 (11 574402 2.029.268 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES (32.920) (562.722) (1,6711 276.945 27902 (151.337) (455.916) (93'.119) FUND BALANCES. JULY (RESTATED) 126.122 '_'20,1"` 247_26 35 766,C25 288,910 (2S2300) 1.E54705 FUND BALANCES, JUNE 30 $93.203 $565,389 $245655 5277.834 $193.528 $137.573 ($7a9, 596) 3763,586 City of Cape Girarde: u, Missouri GENERAL CAPITAL IMPROVEMENT FUND r SCHEDULE OF REVENUES ACD EXPENDITURES - BUDGFTAND ACTUAL (HUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1998 BUDGET ACTUAL T $ 6.736 6,736 51,945 51,945 (45,269) 16,500 (5) 16 495 ($28,714) VARIANCE FAVORABLE (UNFAVORABLE) $ 6.736 6,730 (2,745) (2,74.';) 3,991 (7,700) (5)- (7,705)_ ($3,714) REVENUES nveslment revenue $ TOTAL REVENUES EXPENDI FURES Cnpilal outlay 49,200 IOTAI EXPENDITURES 49,200 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (49,200) + 01 HER FINANCING SOURCES (USES) Operating transfers In 24,200 Operating transfers out TOTAL OTHER FINANCING SOURCES (USES) 24,200 r EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND r 01 HER FINANCING USES ($25,000)- T $ 6.736 6,736 51,945 51,945 (45,269) 16,500 (5) 16 495 ($28,714) VARIANCE FAVORABLE (UNFAVORABLE) $ 6.736 6,730 (2,745) (2,74.';) 3,991 (7,700) (5)- (7,705)_ ($3,714) City of Cape Girard, av, Missouri CORP FLOOD CONTROL CAPITAL PROJECT FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 38, 1998 VARIANCE FAVORABLE _BUDGET ACTUAL .(UNFAVORABLE) r REVENUES Intergovernmental $- $82,337 $62.337 I,esbnent revenue 36,930 36,'.]30 TOTAL REVENUES 119,267 119,'67 EXPENDITURES _ Capital outlay 1,488,000 1,632,475 (144,475) Oeht service Interest and fiscal charges 4,148 (4,148) TOTAL EXPENDITURES _1,488,000 1,636,623 (148,623) EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (1488,000) (1,517,356) (29,356) OTHER FINANCING SOURCES (USES) i Operating transfers in 900,000 900,000 TOTAL OTHER FINANCING SOURCES rr (USES) 900,000 900,000 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($588,000) ($617,356) ($29,356) 70 30 ity of Cape Girardr, , Missouri STREET IMPROVEMENT FUND SCHEDW_E OF REVENUES AND EXPENDITURES - _ BUD -=ET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1998 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) REVENUES nvestmmtr,venue $11500 $24,116 $12,616 Special assessments 15000 24,461 9,461 TOTAL REVENUES 26.600 48,577 22,077 EXPENDITURES Capital outlav 30000 58,649 (28,649) TOTAL EXPENDITURES 30,000 58,649 (28,649) EXCESS (DEFICIENCY) OF REVENUES OVER(UNDER) EXPENDITURES (3,00) (10,072) (6572) OTHER FINANCING SOURCES (USES) Operating transfers in 30,000 - 30,000 Operating transfers out (23,500) (30,750) (7,250) TOTAL OTHER FINANCING SOURCES r (USES) 0,500 (30,750) (37,250) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES $3,000 ($40,822) ($43,822) 30 r City of Cape Girardeau, Missouri FAU STREET GRANTS FUND SCHEDULE OF REVENUES AND EXPENDITURES - r BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1998 BUDGET 525fi 800 256.800 606,200 606,200 (349,400) 350,000 350,000 --ACTUAL $39,375 566 5.084 45,025 103,332 2069, 105,401 (60,376) 350,000 350,000_ $600 $289,624 VARIANCE FAVORABLE _(UNFAVORABLE) ($217,425) 566 5,084 (211,775) 502,868 (2069), 500,199 289,024 $289,024 r REVENUES Intergovernmental Inveslment revenue r Special assessments TOTAL REVENUES r EXPENDITURES Capital outlay Interesl and Fiscal charges TOTAL EXPENDITURES r EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Operating transfers in TOTAL OTHER FINANCING SOURCES r (USES) r EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES BUDGET 525fi 800 256.800 606,200 606,200 (349,400) 350,000 350,000 --ACTUAL $39,375 566 5.084 45,025 103,332 2069, 105,401 (60,376) 350,000 350,000_ $600 $289,624 VARIANCE FAVORABLE _(UNFAVORABLE) ($217,425) 566 5,084 (211,775) 502,868 (2069), 500,199 289,024 $289,024 ' City of Cape Girvdeau, Missouri COMMUNITY DEVELOPMENT BLOCK GRANT FUND _ SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1998 8? VARIANCE FAVORABLE ACTUAL (UNFAVORABLE) $199,892 BUDGET 11,589 REVENUES 11,589 211,481 Intergovernmental $395,000 192,352 Investment revenue 24i, 648 2,438 (2,438) 194,790 TOTAL REVENUES 395,000 16,691 EXPENDITURES 61,691 19,122 Capital outlay 440,000 19,122 Debt service (25,878) Interest and fiscal charges r TOTAL EXPENDITURES 440,000 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES Jab,00(1) OTHER FINANCING SOURCES (USES) Operating transfers in 45,000 TOTAL OTHER FINANCING SOURCES (USES) 45,000 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES $- 8? VARIANCE FAVORABLE ACTUAL (UNFAVORABLE) $199,892 ($193,168) 11,589 11,589 211,481 (183.519) 192,352 24i, 648 2,438 (2,438) 194,790 _ 245,210 16,691 61,691 19,122 (25,578) 19,122 (25,878) $35,813 $3.5813 K3 City of Cape Gin..,, ,,, Missouri PARNIMPROVEMINTSFUND SCHEDULI° OF REVENUES ADD EXPENDITURES - BUDGET AND ACTUAL IOUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 38, 1998 r VARIANCE r FAVORABLE BUDGET ACTUAL (UNFAVORABLE) REVENUES investment revenue $2,000 $12,812 $10,819 TOTAL REVENUES 2,000 12,812 10,812 EXPENDITURES r Capital outlay 151,483 (151,483) TOTAL EXPEND( TURES - 151,483 (151,483) r EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 2,000 (138,671) (140,671) OI HER FINANCING SOURCES (USES) Operating transfers in 43,150 43.150 - r Operating transfers out (43,150) (43,151) (1) 10TAL OTHER FINANCING SOURCES (USES) r EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES r OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES $2,000 ($138,672) ($140,672) r K3 x �( City of Cape GlrarJean Missouri PARKIMPROVEMENISIUND SCHEDULE OF REVENUES ANI' EXPENDITURES - _ BUDGET AND ACTUAL (BUOGETBASIS) FOR 111E FISCAL YEAR ENUI U JUNE 30, 1998 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) REVENIITS Inve,ini it revenue V(Ion ;12,812 $10,812 r TOIAI_REVENUES 2000, 12,812 10,812 EXPENOIIURES Capitol nu 1, - 151,483 (151,483) _ TOTAI. EXPENDITURES 151.483 (151483) EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 2,000 (138,671) (140,671) OTHER IINANCING SOURCES (USES) Opeinlhiy liansrers in 43,150 43,150 - Opeiviniylransrersoul (43,150) (43,151) (1) -. _ TOTAL OTHER FINANCING SOURCES (USES) (1) (1) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHI'_R FINANCING USES $2,11110 ($1:18,672) ($140,672) x �( City of Cape Girardeau, Missouri WATER IMPROVEMEI IT PROJECTS SCHEDULE OF REVENUES AND EXPENDITURES - NUDGFT AND ACTUAL (BUDGET BASIS) FROM INCEPTION AND FOR THE FISCAL YEAR ENDED JUNE 30, 1998 84 PROJECT PRIOR CURRENT TOTAL BUDGET YEARS YEAR TO DATE REVENUES Interest $700,000 $- $176 $176 TOTAL REVENUES 700,000 176 176 EXPENDITURES Capital outlay 26,500,000 1,968956 277,614 2,246,570 Oebt service r Interest and fatal charges 502 27,659 28,161 TOTAL EXPENDITURES 26,500,000 1,969,458 305,273 2,274731 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (25,800,000) (1,969,458) (305,097) (2,274,555) OTHER FINANCING SOURCES (USES) Operating transfers in 1,000,000 - 774,402 774,402 Bond proceeds 24,800.000 TOTAL OTHER FINANCING SOURCES r (USES) 25,800,000, - 774,402 774,402 _ EXCESS (DEFICIENCY) OF REVENUES r AND O FHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES 9'-. ($1,969,458) $469,305 ($1,500,153) i A 84 City of Cane Glrani Missouri r ENTERPRISE FUNDS COMBINING BALANCE SHEET June 30, 1998 (With Comparative Totals for June 30, 199]) Solid Gelf Softball _Trials_ Sewer Water Waste Course Courtlier, 06130198 06130197 ASSETS parried bash and av¢slrnenis 5164422 S]0].975 $685625 S75949 $40010 $1673,981 $1,241,639 Nuu,saded investments 1,144024 121.844 1266468 1, 25291G U0lity cbarges receivabre (net of albnance for deubtlul recoivanl¢s) 326.020 535.372 221324 1083,516 1 025 656 Grdnb receivable 79)29 73,126 - - 132,848 366.173 Sprial essessneenls recutvdble 99,892 - - - 99,892 116114 t. Inleauboroi dbl¢ 79219 5,265 5,929 - 90407 398,523 OIIMnrhoor i les 1,962 124,155 33,497 762 162,376 240,260 Invenln"as - 113919 - 3010 - 116.929 111223 Reslricl¢d assets I forted cd all and cash pgu-]ren, 16352050 043.208 23 5,13 - - 12,228,801 23,722,584 Non purred inveslmems 2.`0,183 5D.707 83,305 - 362,195 652,408 Pwled r'asn and investments ti 1,148 1,1]3,106 - 1,344.254 1,406,006 Prepaid items 5n0.171 215,355 _ 19,065 478 179 026,040 92478_6_ r. 19.030208 3042,188 1,194,932 80,199 40,189 24,387,]16 31458,500 Property, plant and equlpmenl Land 105069 112.240 - - 240.109 240,109 Buildings 0,1 0627 202.051 726,761 3,549 9089,]88 9,064,673 Improvements other berldings 24417431 12413069 63,122 373,280 4657 37,291,759 32,892680 Equipment 1,116,18. 803740 1449,626 420523 56,110 3906,193 3.693,892 ConSlNGlion In progress 12.452,951 1611075 14.264,026 7,882,479 4631904 15230,743 2,371,749 797,352 60967 64 799875 53,801833 Less ameenrialed depreciation 11051,004 2.018,070 1.563.801 465214 24047 15,122,816 13759,549 35_269,100 13,212,673 _ 807.940 3329138 36120 49,677,059 40,042284 Total luela 554,511.388 $11,054861 $2.002880 $41.337 $76309 $74,064775 $71500]92 LIABILITIES AND FUND EQUITY AcIdures payable $793099 $26],589 $53,748 $17,577 $17,878 $1,150,691 $993670 Accrued hrulf ea Sal ane s.pllieff loxes and ben¢fib 63.503 1.990 47,610 24, 130 20,3]] 152.610 Notes Payable - 20402 - - 28.402 13],7]3 34646 Inler¢sl payable 30i.180 226,191 8,022 542,193 676077 Other lmi 4rr667 205,354 fit 637 246,919 201243 a Due Io oilier hands 135x995 - - - - 1358,995 529,246 Due 1. other gmromemes - 69750 - - - 69,750 114,295 Anemone from other funds 337.500 - 950000 390.000 190000 Current error of lcar,Inm debt 841.277 430000 170,701 1667,500 1449.978 1867,500 Long-term debt rel of burrenl perlmn 1365,235 Revenue users payable 30492605 10779602 - - 41272407 41,030,610 Leaselmid revenue bonds payable 977 807 - 977,007 1,50],107 CeNGeales of parro,ation 15711000 760000 460,000 - - 2,]90000 3,040000 E,frodled largfll closure and post rlosmu a� care cost Ldbiliry ___ 606,078 - 806,0]8 _ 822,960 Total liabilities 36783.33_ 1_740076 2533422 432. Sdd 228255 52,]18,330 Food" oily - __ 52400363 Contributed capeal 17013.931 3, 599.481 208,585 645 3,126 20,905668 16970802 Retained "arrant Reserved lw deb] service 31667 - - 31,66] - 30.000 Unreserved 669.257 714904 (819.127) 20052) (155,072) 409,110 99627 r Total fund equity 1))34755 (530,542) (20207) (151946) 21346,445 19,100429 _4314,385 Total liabilities and fund equity $54,518308 51],054661 $202080 11 $7_x,309 $74,04.775 $71,500]92 City of Cape GiPer or, r, Miss. ori ENTERPRISE FINDS COMWIJING STATEMENT OF BE VENUES, EXPENSES AND CHANGES IN RETAIIIFII EARNINGS FOR THE FISCAL YEAR ENUIIUJUNE 30, 1990 86 SOLID GOLF SOFTBALL T07ALS SFWFR WATER WASTE COURSE COMPLEX 199]-1990 OPERATING REVENUES lecoidentinl charges $I.12([,7I17 52343,525 $159201 8- $- $5.361263 Cummeraal charges '14),,04 1,572,952 20.404 - - 2.520260 lr.nsfer JMiorr charges 484.8511 - - 481858 "goipmenl sales 8279 2,145 10424 Con cession reveends - - - 70,954 42.600 11:,554 Goll tours, fees - - - JIM 9$9 - 394059 Sunbelt complex fees - - - - 53884 5:1.804 Other leer: and charges 10,1'1 IW/44 33,216 - - 242031 Other m¢mllaneoos 36,'.199 4b3" GP64 3,652 320 65.917 TOTAL OPERATING REVENUES :.450.141 4.089,903 2,138,813 482844 98,949 9,260.150 OPFRATING EXPENSES I'I Onnel services M8,379 77,606 809,11113 236,605 191,309 2,083784 Materlalsand supplies 911,20@ 52,179 47,660 54,657 17,212 261910 cr ts,doal..'was 197,316 2585.002 662,158 33,670 31,674 3,509.820 General operating expenses 25.617 118,606 30,783 47,699 31,479 252,134 Special pm)eds expense 13,114 - 26,780 5,484 9,062 54,449 InR:mel service expenses 79,956 44,821 111,571 57,492 12,812 306,652 D,,aei.linn expense 1114085 389.834 231,892 63,230 8,506 1,588447 T OTAL OPERATING EXPENSES 21,19,610 3266.050 1,920,656 498,837 302,191 8,057.296 OPERATING INCOME (LOSS) _'.190,527 _823,853 217,657 (15,993) _(203,185) 1202.854 NON-OPERATING REVENUE (EXPENSES) Investment novenae 1?42,W,1 163.103 54,871 3,796 457 1464,280 Federal gams - - 6,645 - - 6.546 Sala of city properly 1,701) - A 900 4,610 - 11 710 Compepsalion for damages 46.5 - - 4,360 - 4,i65 Salm of "0x04 assets '.,627 - 40 - 5,"(37 Gann oa sat, of fixed assets - 18,014 - - 181114 Iseuanm cool anamboaten x5891) (28.3911) (5,027) - - (99.3(16) Imp r est and handling costs 113. vif46) (i46,627) (93600) (21 821) (11,203) (2,508 II'19) TOTAL NON-OPERATING REVENUE (EXPENSES) ("d 661) (593,888) (32311) (9,075) (10,746) (1,097104) INCOME (LOSS) BEFORE OPERATING TRANSFERS (71.162) 229,965 185,346 (25.068) (213,931) 105150 Operating transfers in 206,000 206,000 NET INCOME (LOSS) V1,162) 229,965 185,346 (25,068) (7,931) 311,150 RETAINED EARNINGS (DEFICIT), JULY1 192 ,0811 495,811 (1004,473) 4,216 (147.141) 140 X119 PRIOR PERIOD ADJUSTMENT (10,872) - - - (10.1172) RETAINED EARNINGS (DEFICIT), JUNE 3O $16924 $714,904 ($819,127) $20,852) ($155,072) $440.777 86 87 City of Capc Girardeau, Mlssoutl ENTERPRISE FUNDS AM COMBINING STA FEMENT OF CASH FLOWS FOR THE FISCAL YEAR ENOEO JUNE 30,1998 SOLID GOLF SOFTBALL TOTALS SEWIR WATER WASTE COURSE COMPLEX 1997-1990 CASH FLOWS FROM OPERATING ACTIVITIES' (and"', nmme(ess) $380.522 $823,053 $21],657 ($15,999) (1203.1051 31,20205d xclurnenls Ire madded, 0inall pIncome IO net orm pr-mod by.peek)' WWilies'. Oepedallan Ad 985 389834 231,892 63230 6506 1500,4<2 Cash OOeraling p ., reamand 6,545 - 6,505 Cnange m essels del lla0lMies: (Increase) 0epeax In accounl5 eosivable 29. SP 220,916 0769 1.875 503 269,590 (Increase) Oeoeefe M inventory - (5,193) (516) (6,706) Thomas.) 0eoeeH he prepaM Same 191) 715 d3 4 59 290 leaease(OeRmdd In emmurs payable 219740 (11 863) (16,091) 6.252 (Lif 157,021 lnaease pmaeex) to maned nabiMles 855.142 306% 2,260 6,371 1207 895,716 Inaease(Mtl...) In landfill past... Cye c0515 -- - (16,002) NET CASH PROVIDED BY (USED IN) OPERATING ACTIVITIES 2 379.385 1416921 434190 61.223 (19y844) 409)015 - CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES: Opards, mares. In from cher fends 206,000 20,063 NET CASH PROVIDED BY (USED IN) BY NONCAPITAL FINANCING ACTIVITIES Van 000 206 DEC CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES'. Prpt lord deveni 131 111 131311 IredalpelE mnamore bonds 011 uW) (30'000) - - (390.000) PnnupalpaM- base... use Wed+ To"I'D - T39,ONE) - (60.2%) 4. Prineipnl paid-COP (Ie58061 (75 FOR LT. DEC) - - (240.060) ii paid on SRF (122'1061 (122,0001 principal pain on energy loan 6 notes payebb On bmd (45 WO) (6.241) - (51244) Inlert9 paid an sonde and abl,.I..ns 1972/431 ISM GET) (95.669) (21111) (11203) (1811,103) Pr02eds from all grants biomed from ONer mvemmenl5 59,123 46,379 - - 1. RD I� PUMase W fixed assets (6,896224) (474,467) O37W0) (43,545) - (9,553,306) Proceeds from sae M assets 9550 2gW0 18083 4,606 - 60183 C'ninged for damagee 165 43.06_ _ _ 4,765 NET CASH PROVIDED BY (USED IN) CAPITAL AND RELATED FINANCING ACTIVITIES (10,486'a (1,529,755) (3� .. ff411a (11,203) _LI2476.32TI CASH FLOWS FROM INVESTING ACTNITIES' Proceeds from ad* Dion-amenls 21 - _ 290,060 ` Inlensl o11-1.1mems 1513.111 49,377 0,955 - 1576,743 Ovem"A Mlemsl I6 Y30 112,191 39,6A 3,731 449 172,463 Inleresf on asseammis 6909 - - 6,009 FMV exjromenls to fresh 288 1900 _ 703 65 8 3,044 NET CASH PROVIDED BY (USED IN) INVESTING ACTIVITIES _1 ligit 46 1111 _54512 3.7% 457 2,049,059 INCREASE (DECREASE) IN CASH AND GASH EQUIVALENTS (6262,122) 50714 90 CO2 8,603 1,410 (6,123,393) CASH ANO CASH EQUIVALENTS, JULY 1 22979/42 2.673575 611.1% 67,346 36,606 26370429 CASH AND CASH EQUIVALENTS, JUNE 30 $16697 1 $3724209 §709,160 575,949 E40.010 E20,247,016 87 City of Capc (w,,reau, Missmni SEWER UNO 3CIIEDULE Of REVENIIPS AND EXPENSES BUDGET AND AC UJAi. (BUDGET BASIS) I OR THE FISCAL YEAR I LADED JUNE 30, 1998 BESOT T w Gx"e'l3 032,904 (5 4436) OPERATING REVENUES 3071 50,399 Rask e 4 e che", $1403/04 w Commcicial oherges 9387!10 89,708 Other Ices and charges 11,1700 42,200 T Rhe( misceiianeou. 27' LIQ w' TOTAL OPERATING REVENUES 2,4-96,, CIO 28,744 OPERATING EXPENSES 5625,951 11,742,039 Personnel s.aakxs 78* 215 5,735,778 Materials and supplies 101,445 - Canttactuel samses 234470 (140,277) Game.; egmrasi expenses 35,015 1,700 Special polled, ..'e"', 51,700 w beernal senieeexpens, 108,7,10 16,396 Capital outlet' 16,171 6100 25,000 TOTAL OPERATING EXPENSES w ,11,494,2:6 OPERATING INCOME(LOSS) (15,027,676} w NON-OPERATING REVENUE (EXPENSES) inaestox,e revenue 12l),We Slate gmn(s 125,000 Federal grants 200,000 w impactle'. IF5 oli Salo of city property - Compensation ma, dafYlygeS - Gam on, sale of fixed assets - y� Sower assessments 13,0010 PO"ei{W "mems 1845.434} Interest and handling Casts w TOTAL NON-OPERATING REVENUE(EXPI NSES) (792,647} NET INCOME (LOSS) (515,820,3217 }3 8 VARIANCE FAVORABLE ACTUAL (UNFAVORABLE) 51426,767 Gx"e'l3 032,904 (5 4436) 40.071 3071 50,399 22,809 2,450,141 (18,459) 968.379 47,897 89,708 11,737 197,270 42,200 25,667 9.418 35.410 16,290 79,956 28,744 10,545,649 5625,951 11,742,039 _5,752,237 (9,291,898) 5,735,778 899,100 779,10) - (125.000) 59,723 (140,277) 133,311 (31,689) 1,700 1.700 465 465 5.627 5,627 16,396 3,396 {820,435) 25,000 (5,717,309) (547,097) (821,422) (28,775 ($10,113,320) $5,]0],00.3 89 City of Cape Girardeau, Missouri WATER FUND SCHEDULE OF REVENUES AND EXPENSES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1998 r VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) W OPERATING REVENUES Residential charges 52,420,000 52,343,525 (576.475) Commerual charges 1.595,000 1,572,952 (22,048) Other fees and charges 171,000 168]44 (2,256) Other miscellaneous 5.000 4,682 (318) TOTAL OPERATING REVENUES 4.191,000 4089.903 (101097) OPERATING EXPENSES Personnel services 78,473 77608 865 Materials and supplies 73,700 52.296 21,404 Contractual services 2,644,997 2,585.369 59,628 General operating expenses 130,550 116806 13,944 Internal service expense 51,125 44,821 6.304 Capital outlay 1064.390 748,255 316,135 TOTAL OPERATING EXPENSES 4,043.235 3.62¢ 955 418,280 OPERATING INCOME (LOSS) 147,765 464.948 317,183 NON-OPERATING REVENUE (EXPENSES) r In vestment revenue 111,000 161,386 50,386 Federal grants - 46,379 46,379 Gain on sale of fixed assets - 18.034 18,034 Principal payments (419,125) (420,000) (875) Interest and handling costs (708,865) (709,667) (802) TOTAL NON-OPERATING REVENUE (EXPENSES) (1,016,990) (903.868) 113,122 NET INCOME (LOSS) ($869 225) ($438.920) $430,305 89 r City W Cape Girardeau, Missouri SOLID WASTE FUND SCHEDULE OF REVENUES AND EXPENSES. - BUDGET AND ACTUAL (BUDGET BASIS) r FOR THE FISCAL YEAR ENDED JUNE 38, 1998 VARIANCE FAVORABLE BUDGET ACTUAL LUNPAVORASLE) OPERATING REVENUES Residential charges $1,591,750 51.592971 $1,221 Commerual cu rges - 20,404 20,404 a+ Transfer station oharges 769,445 484.858 (284582) Other fees and cliatgos 35,000 33.216 (1184) Caul rruacettaneous _.... 2,500 _ 6854 4,364 TOTAL OPERATING REVENUES 2398695 2,13$313 (260,382) OPERATING EXPENSES Petadnnel services 920.056 823,262 96.794 Materials and supplies 68,463 49.516 18,947 Contractual services 871,115 669,303 201.812 General pperal m; expenses 34,950 32,313 2.63; Special projects expense 14,450 26.935 (12,485) Intemal service expense 190,320 111,571 78,749 Capital oomay 361,255 41707 319,548 TOTAL OPERATING EXPENSES 2,460,609 1,754607 706,002 - OPERATING INCOME(LOSS) (51.914) 383,706 445,620 NON-0PERATING REVENUE (EXPENSES) 'a Investment revenue 15,500 53,837 38,33, Fastened grants - 6,545 6,545 Sale of city property - 4,900 4,900 Pdrupal payments (169,800) (169,800) - Interest and handling costs _ (97_325) (95,669) 1,656 TOTAL NON-OPERATING REVENUE (EXPENSES) _ (251.625) (200,187) 51,438 NET INCOME (LOSS) (5313.539) 5183,514 _S!97 918 90 .. City o1 Ca" Girardeau, Miasood GOLF COURSE FUND SCREDULE OF REVENUES AND EXPENSES - BUDGET AND ACTUAL (BUDGET BASIS) + FOR THE FISCAL YEAR ENDED JUNE 30, 1998 VARIANCE + FAVORABLE BUDGET ACTUA (UNFAVORABLE) + OPERATING REVENUES Equipment sales $10,000 $8279 ($1,721) Concessionmuenues 70,000 70,954 954 Golf course fees 381,500 399.959 18,459 Other miscellaneous 3,652 3,652 TOTAL OPERATING, REVENUES 461900 482.844 21.344 OPERATING EXPENSES Personnel services 229,656 236,605 (6,949) Matertais and supplies 45.841 54.337 (8,446) + Contradual .services 33,605 33,670 (65) General operating expenses 52.600 47475 5.125 Spevai projects expense 6200, 5,484 '716 Intemai seMoe expense 48.150 57,492 (8.342) + Capital outtay 46.049 43.445 2,604 TOTAL OPERATING EXPENSES 463.101 476,508 (15407) OPERATING INCOME (LOSS) (1.601) 4,336 5,937 NON-OPERATING REVENUE (EXPENSES) nvestment revenue - 3.731 3,731 + Sale of oty property - 4.610 4,610 Compensation for damages - 4,300 4,300 Sale of fixed assets 40 40 interest and handling casts (19.500) _{2i 821) (Z.321) + TOTAL NONOPERATING REVENUE (EXPENSES) 09 500) _ (9.140) 10,360 INCOME (LOSS) BEFORE OPERATING _ TRANSFERS (21,101) (4,B -Si) 16.297 Operating transfers -m 10.500 - (10500) NET INCOME (LOSS) (Slomi) _ (&1804) $5,797 + + 91 M City of Cape Girardeau, Mlasourl SOFTBALL COMPLEX FUND SCHEDULE OF REVENUES AND EXPENSES- BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30.1998 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI OPERATING REVENUES Equipment sates $1,000 $2,'45 51.145 ' Concession revenues 56000 42,600 (7,400) Softball Complex fees 72,000 53.884 (18.116) Other 095Geft;uh,d a 320 320 ' TOTAL OPERATING REVENUES 123,000 98,949 _ (24.051) OPERATING EXPENSES Persaulel services 178,457 191389 (12,932) ' Materials and supplies 25.897 17,272 8,625 Contractual services 23.675 31,674 (7,999) General operabng expenses 36,475 31,479 4996 Specral protects expense 7500 9062 (1,562) Internal service expense 4_900 12.812 (7912] TOTAL OPERATING EXPENSES 276904 293.688 _ (16784) ' OPERATING INCOME (LOSS) 1194739) (40835) NO"PERATING REVENUE (EXPENSES) Interest Income - "9 449 ' Interest and handling costs .11p00j _ (11.203) (203) TOTAL NON,OPERATING REVENUE EXPENSES)[ (11,000) (10754) 246 ' INCOME (LOSS) BEFORE OPERATING TRANSFERS (164,904) (205,493) (40,589) Operating transfers to 165,000 206.OR0 41,000 ' NET INCOME (LOSS) 696 5507 5411 v2 93 City of Cape Girardeau, Mi..... as INTERNAL SERVICE FUNDS COMBINING BALANCE SHEET June 30,1998 [Ams Cominntive Taub for Jun. 30,199]) as Employees' Data plant FHnge Risk Equlpinni Totals Prvicea.lno Mam.emeM grown Management Resuscitates t 0613058 0611097 ass ASSETS Pooled cash and investments $241472 $148.495 $908.103 51,527,641 1 $2,952)29 11224 as Nonpddedinves3ments - _ 100,124 Interest Papeivable 67 - - 1,13) 12N 1,5]8 Other receitio iss 5.132 7,276 7,069 22,305 - 41602 14,183 venbries 7228 7229 8014 Restricted assets as Non (wolM cash and cash ¢qurval¢nb 16.102 - - 1 710 1] 812 786 ])7 Prepaid items 28747 2,258 969 9.534 41508 89114 291,520 165157 915,192 1,550.915 139199 3062283 3]25.974 ` PropeMplant and equipment Lana - 37500 37.500 27.800 Buildings 643 421 178 - - 421.821 424978 Imp,mont ms other omlemgs - 313575 - - 110;49 104903 as Egwpment 36fi5J50 30].5]5 - - 661,319 26306Cd 1.522 42,l Construction m progress 6 Nfi 1 686 393 876002 - - 661,319 3203714 2092361 as Less aUurmfdi deprecation 874004 390965 1566]8 1427.607 1,132513 '92.389 479037 50x.683 1776.107 959.840 Toll asset 51083909 S644l294 $915.192 $1.550915 56"1080 54838,390 54685822 LIABILITIES AND FUND EQUITY ` ACcrounls payable 567988 $111]31 5248.185 S405 763 S $821667 $472125 Accrved liabilities Salaries, payroll lues and bene(ns 5915 23627 - - - 29.542 25679 Interest Payable 680fi 12 - 5968 12.706 3,511 ass Other 1111 53 53 50 Due to CNet govemireopt 2,436 2436 2851 Currentmdebt of In,, -termt 55,000 55,000 1I0000 110,000 Longterm debt net of current pOrtiOn portion ass Cenibcales of Participation 324692 - 334433 659,125 768914 Toll liabilities 450401 137859 248.185 405763 395401 1637609 1384.130 Retained eamings Unreserved 633500 506435 667007 1,145.152 240.679 3200.781 3 301 692 Total fund equity 633506 506,435 667007 19145.152 248679 3200781 3,301692 as Total liabilities and fund equity $1083909 $6®294 5915.192 $1550.915 5644080 $4,038390 $4685822 93 Clry al CA" GInNOu, MluOuh INTERNAL SERVICE FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS FOR THE FISCAL VEAR ENDED JUNE Jq 1999 P4 EMPLOYEES DATA FLEET FRMWE RISK EQUIPMENT TOTALS PROCESSING MAN GEM HTE6 NEFIT MANAGEMENT REPLACEMENT 1997-1298 OPERATING REVENUES 1nleMepMbnen149wwe 5313.]3) 6810])/ $1.373,145 Sd05.241 9124404 $3026,356 ONer mlauYNaau 23 rt9--LAL TOTAL OPERATING REVENUES 313756 810895 1.372 145 405297 124,4SA 3026497 OPERATING EXPENSES P.-I—.i I 105228 410865 97.583 - 613,8'. Mv4rola..111.f 1027 23]E23 - 218.650 Cant/ H.—. 18.268 133838 1323288 I6 027 - 2040.121 G-.I.p ..g WAAA 9833 I Sig I1.61I - 23.229 Imemal servo e.Censm 2061 204 GeIXM+ati:m ezpmse 143237 39584, _2]' 295: L1 TOTAL OPERATING EXPENSES 315503 825.]]5 14]0.871 4]6644 1122]1 3221154 OPERATING INCOME (17-65) 121,891 (u 0801 !98]261 71,5421 8.133, 1194.65]1 NON-0PERATING REVENUES JSXPENI megmeN revMw 2].241 2.]53 58.929 85,920 IT 778 202,615 &oR N MYaGMY 8,90 - _ 14.19 27.M9 Ismame wR elwOZNCO 333.2) - 12954) MAI Imemal -dp AN M. (22789) (591 - (22291) (45 135) TOTAL NON-0PERATING REVENUES (EXPENSES)1450 _„ 11 C6X 58.923 85920 22.7 179368 WCOME tLO553 BEFORE OPERATING TRANSFERS (20.387) QE 12) (39,803) 14,373 3x.140 09189) opal81l1g 1rzM1atM /i - 'L, - - 14.57 68,07E Oge44gtrar,aten art ___.._ (1239X3) —_ Ln—nWt NET INCOME (LOSS) (20387) 39.688 (21J,3%) 14,373 78.718 OW.911) RETAINED EARNINGS (DEFICIT), JULY) 65J 695 4116747 880310 130 77q 169961 3301692 RETAINED EARNINGS (DEFICIT), JUNE 30 $833508 $506435 $66]007 Y1, 145152 3246671 53200)61 P4 F)5 Cary nr <aw 4bnauv. Mluaun FUNW 1xNG 3TATEMIEN OFDS FM. IM FOR 1NE FlSGL YEAR ENOEO JUxE M. tME ORM ME ENDED JUN EMPLOYEES' DATA FLEET FRINGE WSN EQUIPMENT TOTALS PR04 MAKI MANAGEMENT "All L MPNA EMMW RLU&rMM iPLT M CASH FLORINS FROM OPE WING ACTIN➢ES: CwnbNt Vvp0.) 621861) plum) (394.)26) 6715g1 312tm {319Ap5)1 +glMunxxamfNwxa PH.Q`, N.I.. nMNNR. b/gM01vq gMlwf. pMlwnpl 143.337 39.SP6 112.311 295 NF Cnaz uq tappma. IIMNealOgaaHn IRM.) `RNN 149fb1 Y,1BS fp]) yR5m1 - 10D,591 rw-'vrbCArvebb lnbaewlBgeafa n.w..lply - 7m 7m W O npepatl MOx !6531 541 - e"., ARFUsaaw imauia++4euin acwnn PV'eaie SGW W.WE d2.ID 52191 111Cm f92q }'3M1,At IrcrueelwGluNln MwuM lieb4nba _ <D]fi 1,2,01 L49521 KOP61 xAT CAST PROYThA 8T {USED INI oP£ W TM6 M ACTIVITIES 150.99] EB.W3 121877) 140320 121 460 MDI% CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES: cRIA." —W— n'.. oNrN,i' 0BAD 'H 570 NBC]B AN Oplrauy ltaMenan l9 outer fuM6 IIA YtlL _� n115W1 NET CASH PROVIDED BY (USED IN) NONCARTAL FINANCING ACTINSMa _ ---ii RAI f 4573 105422 CASH FLOWS FROM CAPITAL AND REI>TEO FINANCING ACTIVITES: "arm .-COP .0CCl - .1 .110.) PripGpb p.A m wrotry kvn 6 Mp payabb m brq - (415) - - (415) M Mxn pegm M'aa bq mlpalwm (1]505) ISS - "7 RES) (UFYB1 P.rtrcv>NM+asey t%356g Ill.)- HWA2Y Ytnt-35 11 PrCpMalrtm ubNmw4 _� 83 6]]0 � 19979 111 649 MET CAST PROVIOEO BY IUSRO IN)CAPITAL AND REUlEVMVAVL NGACTtVGES 164t )921 ifi$ly1 15160311 1�}]9%)1 s CASH PLANE FROM INVESTING ACTVINES: PtOC4065 hwn yak ofnreaMevS - - 161311 - i42a2 ImxaAmmMManV 1]810 9313 11529 42A. Ovemgm nares! 9ID] 2)05 75927 10919 1NBs Imwxn on mlNAv+uavarcee - INa L'35 - - tb55 FMY eSuM.Mla to �asit tbt X48 _ SHE lyi�_t32 NET CASH PROVIDED BY (USED Ip INVESMIG ACTIVITIES X211744 2753 E8�923 26)16! 25592 363.111 ANA INCREASE (DECREASE) IN CASH AND CASH EQUIVALENTS (x55,6251 45,131 (1'3649) 478QB (1]],]21) AG .1 CASH ANO CASH FQVNAL£NTS, 1.11 _ti3. 199 —n J" 10M557 I 119932 951049 34]SWf r CASH AND CASH EQUIVALENTS, JUNE 30 $257574 51'V495 SWAL03 $1341641 $128720 $29100.1 F)5 06 City of Caps Girardeau, Missouri DATA PROCESSING FUND SCHEDULE OF REVENUES AND EXPENSES. BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1998 VARIANCE FAVORABLE BUDGET ACTUAL LNFAVORABLEI OPERATING REVENUES r Interdepartmental services $330,000 $313,733 (816,2137) Other miscellaneous 23_ 23 TOTAL OPERATING REVENUES 330,000 313,756 (16,244) r OPERATING EXPENSES Personnel services 113,036 105,228 7,808 Matetiais and Supplies 6,363 8,699 (2.136) ConlmoWl services 80093 68,285 11,808 General operating asperses 1,919 5.338 (3,419) Capital ouiieY775000 `796,644 (21,684) r TOTAL OPERATING EXPENSES 976411 984-194 (7,783) OPERATING INCOME (LOSS) (646,411) (670,436) (24,027) NON-OPERATING REVENUE (EXPENSES) Mvesimentme eom, 27,080 27,080 Principal payments (20,000) - 20,000 Interest and handling Costs (55,000) (17,605) 37,395 r TOTAL NONAPERATING REVENUE (EXPENSES) (75,000) 9,475 64,475 NET INCOME (LOSS) __ELI 111 ($660,963) $60448 06 City of Cape Girardeau, Missouri FLEET MANAGEMENT FUND SCHEDULE OF REVENUES AND EXPENSES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1990 BUDGET ACTUAL 97 $810,777 118 010,895 410,865 236.497 130,839 1,5]9 2084 81 479 863,343 (52,448) 2.705 8,370 (415) (55) 10,605 (41.843) 43,500 $1,657 VARIANCE FAVORABLE (UNFAVORABLE) ($122,223) 118 (122,105) 45,486 47,278 10,848 1,271 116 18,021 123,020 915 2,705 8,370 (415) (55) 10 605 11,520 43,500 $55,020 OPERATING REVENUES Interrlepadmental services $911,000 Other miscellaneous TO FAT. OPERATING REVENUES 931,000 OPERATING EXPENSES Persniniel sruare. 456.351 Materials and supplies 283.775 Conhactuzl services 141687 General operating expenses ;.850 InteunI service expense t',200 Capital onllaY 99,500 TOW OPERATING EXPENSES 980,363 OPERATING INCOME (LOSS) (51,363) NON-OPERATING REVENUE (EXPENSES) In "turent reveoue Sale of illy property Por,spal Payments Interest and handling costs TOTAL NON-OPERATING REVENUE (EXPENSES) i INCOME (LOSS) BEFORE OPERATING TRANSFERS Pia 363) Operating transfers in NET INCOME (LOSS) ($5.t 363) 97 $810,777 118 010,895 410,865 236.497 130,839 1,5]9 2084 81 479 863,343 (52,448) 2.705 8,370 (415) (55) 10,605 (41.843) 43,500 $1,657 VARIANCE FAVORABLE (UNFAVORABLE) ($122,223) 118 (122,105) 45,486 47,278 10,848 1,271 116 18,021 123,020 915 2,705 8,370 (415) (55) 10 605 11,520 43,500 $55,020 City of Cape Girardeau, Missouri EMPLOYEES' FRINGE BENEFIT FUND SCHEDULE OF REVENUES AND EXPENSES - BUDGET AND ACTUAI (BUDGET BASIS) FOR THE FISCAL YEAR F NEED JUNE 30, 1990 BUDGET 9A VARIANCE FAVORABLE ACTUAL (UNFAVORABLEI $1,372.145 OPERATING REVENUES $372,145 Intri prnnerental services $1,000 000 r. 97,583 TOTAI OPERATING REVENUES 1,09(1000 1,373,288 OPERATING EXPENSES (393288) Personnel services (490,871) Conti, rj,il services 980000 TOTAL OPERATING EXPENSES 980. U00 57,935 11,935 OPERATING INCOME (LOSS) 20.000 11,935 NON-OPERATING REVENUE (EXPENSES) (40,791) Invesluin L revenue 40 000 (173,500) TOTAI. NON-OPERATING REVENUE (EXPENSES) 40000 INCOME (LOSS) BEFORE OPERATING ($100,791) TRANSFERS 60000 Opemfm9 transfers out (173.6 NET INCOME (LOSS) ($117.500) 9A VARIANCE FAVORABLE ACTUAL (UNFAVORABLEI $1,372.145 $372,145 1,372,145 372,145 97,583 (91,583( 1,373,288 (393288) 1,470,871 (490,871) (98,726) (118726) 57,935 11,935 57,935 11,935 (40,791) (108791) (173,500) ($214,29 ($100,791) City Of Capp Girardeau, MISSOUrl RISK MANAGEMENT FUND SCNEDUI.. E OF REVENUES AND EXPENSES -BUDGET AND AC NAL (BUDGET BASIS) FOR THE FISCAL. YEAR ENDED JUNE 30.1998 VARIANCE FAVORABLE BUDGET ACTUAL (_UNFAVORABLE) OPERA I ING REVENUES IeterdePme ugntalwakes S412,(00 $405.297 ($6,703) s TOTAL OPERATING REVENUES 412,0')0 405,297 (6,703) OPERA I ING EXPENSES 'r COnUaG)cil ocrvims 955,000 465,027 489.973 Ger�ui apaVtllu9 e,,OFsOs _ _ 11,817 _(11_817) TOTAI OPERATING EXPENSES 955,009 4MEM4 478,156 OPERATING INCOME (LOSS) (543.000) —(71 5471 471,453 NON-DPERA PING REVENUE (EXPENSES) Inveslrz�ent evo00e 55,000 83,739 28,739 TOTAI NON-OPERATING REVENUE(EXPENSES) 55.000 83,739 28,739 y NET INCOME (LOSS) ($488.000) $12,192 $50.192 100 City or Cane Girardoaq Missouri EQUIPMENT REPLACEMENT FUND SCHEDULE OF REVENUES AND EXPENSES - BUDGET AND ACTUAL (PUDGET BASIS) FOR THE FISCAL YEAR ENDEI JUNE 30, 1998 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI OPERATING REVENUES Interdepndmental services 5138,3011 $124,404 ($13,896) TOTAL OPERATING REVENUES 138,3011 124,404 (13,896) OPERATING EXPENSES Capitath,nlay 460,961 464.512 (3.543) TOTAI OPERATING EXPENSES _ 460,9V1 _ 464,512 _ (3,543) OPERATING INCOME (LOSS) (322,669) (340.108) (17,438) NON-OPI-RATING REVENUE (EXPENSES) Investmmrl revenue 14,301 27.584 13,284 Sale off Ely property - 19.479 19479 Pdruapal payments (55,000) - 55,000 Interest and handling costs (20,000) (17,980) 2,011 TOTAI. NON-OPERATING REVENUE (EXPENSES) (60,700) 29,074 89.774 INCOME PASS) BEFORE OPERATING r TRANSFERS (383.31") (311,034) 72,335 Operating transfers in 37,450 44,578 7.128 NET INCOME (LOSS) ($346,919) ($266,466) $79,463 100 + City of Cape Girardeau, Missouri AGENCYFUNDS COMBINING BALANCE SHEET Juno 30, 1998 + (With Comparative Totals for June 30, 1991) Park Arena Development Total. + Library Improvement Foundation 06130198 06130191 ASSETS + Pooled cast) and investments $492,136 $30,988 $84,199 $607,923 $415,303 Non -pooled lnveslments - - - - 2,105.65 Receivables, net of allowances for doubdul recelvables Real estate tax 11,229 - - 11,229 15,413 + Personal property tax 4.144 - - 4,144 3.962 Other iaceer les 102 102 102 + Total...eta $514.211 $30,988 $84,199 $629,998 $2.599,905 + LIABILITIES Accounls payable $8.352 $- $491 $8,843 $9,446 Accrued liabilities + Slurries ,payr011 u.se and benefits 10,854 - 10,854 9,323 Other liabilities 495005 30,988 84.308 610,301 416,011 Deferred compenr.ah.o doe employees 2,105.65 + Thiel llabllllle> $514,211 $30,988 $84.799 $629.998 $2,599.905 101 City of Cape ill, peal MissmM Cold DINING STATEMENT OF CH All( E9 IN ASSETS AND LIABILITIES ALL AGI NI. y FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1998 10' Park Artna Oee elopmenl _ Glm ry Improverna l F.—al lion Tullis ASSETS _ Balm¢oa at July 1, till Peol"al."t si lnvc1 1, 'd Pin ill 8:'µn11 S6ge8] Sni> O Rem-cley nal of allow nnras In aoublml ..,,.St., Roo, d.l. oa IS,Iel _ yai3 Lou soulBo'd lax 3,962 _ _ 6952 Olney leceNabka _ 102 _ _ 162 Tale,afeh al July 1, 1991 __$414L479 $20470 $59 .] $ail Syn A111111- poo,oacasn and lnvesenen1, $G/p6S4 $32356 $96175 S]96211 Syce—bled, rel of elloweeces lm doublml I.Elvames Real estate tad 100 JE6 - - aW 3. F.—ilplpedy lav 1-1 7F4 - 12N llyd omel —l.emea Told additions _ $lona 936 _ a2ue $99.175 11a23,3a1 lodul casn add all nna $"]Sala $1, SIJ $65,263 AND 597 Race InIRM el al ences lo, aaee Real ealet. tad 3"610 - - 398610 En—rual Wo,, m ve 952 - 0,9$2 01ne11w1yeTlea 4 Total deletions $1,ill JDa $21Sa4 565263 St156,29 6alanlesal Jon. 30,199, Pooled cern and inveslmants 5192136 $30988 $fid Hot 56019]] Recervables,. N allowances IF aoublml mcv-M- Bealestelelea 1'22- - I1 Persaialpmped 1144 _ 144vin+ ]aa One, remvables 1p2 _ _ 102 Total assets al j... Ill 1 M5 x$514.211 110 a SoaJ 99 $629995 LIABILITIES B}Iancq.l July 1, Ho' ACcmmis p.,.St. $q.la6 $- S $9446 Amuoa 5abllilies Salane£ payroll laaos dna bene66 9323 - 9 329 Only, tontine _ )10 20 4]4 59 55]_ 176 W1 Total liabilities at July 1, 1991 $111 19 $204]4 $598E] $494840 Addift—A A—lb pavabm $211399 $21969 $217.]11 $254 512 A¢maa dab ]ling Salane,. paym8lare£ nna c.li 111 In, - - 233 20 omernotion <16 231 12 111 85,006 52". Total aaaiCon. Seeo ll6 _$41 Lin $105.]50 $t 010,655 oelel _ ACU .al Il A93 ¢JI P69 $2053 E254615 ndIIp.Yale Aaaned Ill sA ea eymn tes 1111a cartel', Ill 752 - 231452 Onine, lnal lmbddies _ 4;939 11636 60555 _ 369.1W Total deletions _ $]171,104 533505 _ $60838_ "1' 127 Balances at lineally 1998 Aecooels payable 1134 S $191 SSy43 All—d Tudi e Sala £ payroll rases ,nn Talent: In m.n - _ l0 654 olnm unmmlea ne DaS 3a,9ee _ _ e4Ja9 61n�i 11.1Rabllllles al IS— 30, 1998 _ R"11211 3ia,to $SC J 92 gqg g3S 10' City of Cape Girardeau, Missouri SCHEDULE OF GENERAL FIXED ASSETS BY SOURCE .. June 30,1998 GENERAL FIXED ASSETS Land $2,086,593 Buildings 8,795,256 Improvements other than buildings 4,328,851 Machinery and equipment 1,472,472 Contraction in progress 22,344 TOTAL GENERAL FIXED ASSETS $16,105,516 INVESTMENT IN GENERAL FIXED ASSETS BY SOURCE .. General fund $3,745,818 Special revenue funds 10,857,749 Capital projects funds 2,057,736 Donated assets 44,213 TOTAL INVESTMENT IN GENERAL FIXED ASSETS $16,705,516 10 104 City of Cape Girardeau, Mhumml SCHEDULE OF GENERAL FIXED ASSETS - BY FUNCTION AND ACTIVITY Juno 311,1998 Improvements Machinery Construction Other Than and in Function and Activity Land Buildings RInIdin415 Equipment Progress Total ADMINISI RATIVE SERVICES Human resources $- $- $938 6- $938 City manager 200,000 11111915 - 1,482 - 303,39] Maintenance - 3249 -3249 CITY attorney - - � e90 - 890 890 Inlerdepadmental 67.340 28916 18.75] - 115,013 r Finance - 844 844 CVB - ll. .176 - 6,984 159.160 Airport 354.649 In lit l9 3673453 208,652 4,399,5]3 TOTAL ADMINISTRATIVE SERVICES 621.989 4 16 910 3,705618 238,547 4,983,064 _ DEVELOPMENT SERVICES Planning services - - 3336 - 3,336 Community infarmation program - - 16,905 - 16,905 Engineelmg services 42.764 42.764 TOTAL DEVELOPMENT SERVICES - - - _ 63,005 _ 63,005 PARKS AND RECREATION Pork maintenance 855.230 31.'/163 - 84,678 1,262,879 Arena m:Imtenance - 20,065 20.065 Recent trni - - 887 - 887 Cemetery 4,120 11115 - 22,050 36,385 Gectudi "ol - 5 V 80 4,219 3.302 - 604.801 Cetera enol - 6,644 - - 544 Osage Cummunily Gen9e - $6'6.189 - 71,524 - 2,]26.913 Softball t'.omplex _ 2,3'13 062 - _ 24,660 2,417,722 TOTAL PARKS AND RECREATION - 859,359 5,0]21109 9,763 227.156 _7,060,196 PUBLIC SAFETY Municipal court - - 305 - 305 Health - - 11,555 - 11,555 P01'me 23,400 212912 1512 178,555 13793 429.]]2 he 21],]05 7901113 ],532 _4]],497 1,493,647 TOTAL PUBLIC SAFETY 241.105 1,0113 425 9.044 687,912 13._793 1,935,279 PUBLIC WORKS Sheet - - - 213,395 - 213395 8tonevalcr - _- _ 62,447 62447 TOTAL PUBLIC WORKS 275.842 ` - _275,842 CAPITAL OUTLAY General capital improvementa 10.000 1355.+90 540,256 8,551 1,924,197 Park improvements 354.141'x.61322 64.170 454,936 _ _ _ - TOTAL CAPITAL OUTLAY 364,141 1,41'1112 604,426 8.551 2,3)9,130 TOTAL GENERAL FIXED ASSETS $2,086593. $8,]'15156 $4.328.851 $1472,472 $22.344 $16.705,516 _ 104 City o1 Cape Girard, mu, Missouri SCHEDULE OF CHANGES IN GENERAL FIXED ASSETS - BY FUNCTION ANO ACTIVITY FOR THE FISCAL YEAR ENDED JUNE 30, 1998 General Fixed General Fixed Assets Depreciation Assets Function and Activity 06130197 Additions Deductions Expense 06130198 ADMINISTRATIVE SERVICES Human resources $1,169 $- $- $231 $938 Clly numlagor 313,951 - 10554 30.1.391 Facility melnlenance 3481 - 282 ] 249 City nl19n.ey 1,180 - - 290 890 Interdeprrinlental 122,790 - 1,185 115.013 Flnamx TIM - 291 844 CVD 6,253 161.913 - 5,066 159.160 Airport 4,624,111 23.361 241,959 4,399,513 Tot AL ADMINISTRATIVE SERVICES 5.010,651 184.816 - 212,408 4,983,064 _ DEVELOPMENT SERVICES Planning services 5,232 - 1,896 3,336 Community lntortneUon crevice 1,3111 19.315 - 3.111 16,905 Engiuoering services 44,331 1,826 9,399 42,164 TOTAL DEVELOPMENT SERVICES _ .50,816 21,141 15.912_ 63,005 PARKS AND RECREATION Park maintenance 1,153128 163229 - 54,018 1,262.819 Arena maintenance 22,620 - - 2,555 20,065 ReeripMen 364 845 - 322 881 Grein, 31,231 - - 6816 30,305 Carnal pool 631,332 2,200 - 28.131 694,801 CaPahapool 6,118 - - 634 5,544 Osage Community Centre 2]89,646 38,512 - 101,245 2726913 So%ball Complex 2482,825 21,813 86.916_ 2,417 722 TOTAL PARKS AND RECREATION 1,123,924 226.659 _ 281,387_ 7069,196 PUBLIC SAFETY Munh:ipal court 441 - - 138 305 Health 15,2813 - - 3 73 11.555 Ponce 343,860 184,186 - 98,214 429212 Fire 1,611,586 12,191 _ 130.136_ 1493,641 TOTAL PUBLIC SAFETY 1911_113 196.383 _232,21.1 191;219 PUBLIC WORKS Short 218,964 1.119 - 66248 213.395 Stormwater 91,569 _ __ 29,122 62441 TOTAL PUBLIC WORKS 310.533 1119 95,810 215,842 _ CAPITAL OUTLAY General capital improvemrnls 1980.415 24.943 - 81,161 1,924,191 Park improvements 462,131 1,640 8,838 454,933 _ TOTAL CAPITAL OUTLAY 2442,546 26,583 89.999 2,319,130 TOTAL GENERAL FIXED ASSETS $11,029200 $662,160 $- $986,953 $16,105,516 - _ City of Cope Giprdeau, Missouri SCHEDULE OF CHANGES IN LONGTERM DEBT IOR THE FISCAL YEAR ENDED JUNE 30, 1998 1U6 General General Long-term Long-term Deht Debt July 1, 1997 Adorn... Retiremenler June 30.1998 GEIIL HAL LONG-TERM DEBT i rte 3ro1d rovenue bands payable $4, W,994 $ $1,651764 $6,132230 C,tifr,tes of partiplpabon payable 5 705,000 - 410,000 6,295,000 Gem'pral oblgatiou refunding bolls eayabte 3,010.004 330,000 2,740,000 Accrued benefits 644.053 18,988 - 563,051 Uoc to other governmenlsSlale energy loan 51,609 '12,544 39,125 10 IAL GENERAL LONGTERM DEBT $17, 154,726 $18,988 $2404,308 $14.769,06 1U6 City of Cape Git ardeau, Missouri STATEMENT OF GENERAL LONG-TERM DEBT JUNE 30, 1990 AMOUNT AVAILABLE AND TO BE PROVIDED FOR THE PAYMENT OF GENERAL LONG-TERM DEBT LEASEHOLD REVENUE BONDS Amount available in debt service fund Amount to be provided CERTIFICATES OF PARTICIPATION Amount available in debt service fund Amount to be provided GENERAL OBLIGATION REFUNDING BONDS Amount available in debt service fund Amount to be provided ACCRUED BENEFITS Amount available in debt service fund Amount to be provided DUE TO OTHER GOVERNMENTS -STATE ENERGY LOAN Aniount available m debt service fund Amount to be provided TOTAL AMOUNT AVAILABLE AND TO BE PROVIDED GENERAL LONG-TERM DEBT PAYABLE Leasehold revenue bonds payable Certificates of participation payable General obligation refunding bonds payable Accrued benefits Due to other governments -State energy loan TOTAL GENERAL LONG-TERM DEBT PAYABLE 107 $1,902,745 4,229,485 $6,132,230 855,768 4,439,232 5,295,000 835,119 1,904,881 2,740,000 563,051 563,051 39,125 39,125 $14,769,406 $6.132,230 5,295,000 2740,000 563,051 39,125 $14,769,406 SINGLE AUDIT SECTION Begley, Janssen, Young & Birk, LC CEBTIFICO PUBI_ICACCOUNTANTS 2103THEMISST CAPE GIRARDEAU MIcSOURl 5b701 - TELEPHONE (573)334 FAX(573)334-4338 r PARTNEHS ,ENSSEN.CPA JENNIFFRWESIRICH. CPA ll 101, Ii. HI GLEY, CPA JEFF UNrER111 INHn. CPA I AWHIN( 6 E. YOUNG, CPA CATHERINE A WHITE. CPA KELVIN W MIRK, CPA INDEPENDENT ALL I'I'ORS ' REPORT ON COMPLIANCE WITH RP01 I I. REMEIJI':: APPLICABLE. 'P0 EACH MAJOR PROGRAM ANI) INTERNAL I'ON'I'ROL OVER COMPLIANCE IN ACCORDANCE WITH OMB CIRCULAR A-1.33 Honorable Mayor and Menlberr. of the City Council Cape Girardeau, MiseOIlri Compliance We have audited the, conlpl lince of the City of Cape GirardeaU, Missouri with the types of cnnlplinnce requirements described ill the U.S. Office of Ma Uogenleul an,I Budget (OMB) Circular A-133 compliance Supplement that ..-n.-e ppl.i.cnhle to each of its major federal programs for the yc.n_ elided June 30, 1998. The City of Cape Girardeau, MisaoUri's ul.Ijor lederal programs are identified in the smnmary of the aUdil'or's results section of the accompanyillq schedule of findinil; and qil-!4L.1-IlCd coets. Comp] lance with Che requirements of laws, regulnlions, contracts and grants applicable to each of its major federal programs is the responsibility of the City of Cape Girardeau, Missouri's management. Our responsibility is to express an op'iuioil on 1.11e City of Cape Girardeau, Missouri's compliance based on our audit. We conducted our aur liI of cnmpl is ince iu accordance with generally accepted auditing standards; the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the Ili, iI-cF States; and OMB Circular A-133, "Audits of States, Local Gov,u umeuts, and Non -Profit Organizations". Those standards and ()MB Cil,vlar A-133 require that we plan and perforin the audit to obtain re,isonabie assurance about whether noncompliance with thn types of climpliance requirements referred Co above that could llnv,, F1 dllrct and mFlterial effect o11 a major federal program occurred. Au audit includes examining, on a test basis, evidence about the City of Cape Gii.-ardeal, Missouri's compliance with those requi Fennmts and performing such other procedures as we considered necessary in the circumstances. We believe that our audit provid,,,s a reasonable basis for our opinion. Our audit does not provide a le,@1 determination of the City of Cape Girardeau, Misr.,,Ilri's —ilipl lance w.11 -h those requirements. In our opinion, the City of Cape Girardeau, Missouri complied, in all material respects, with I.hc rlquiremeuts referred to above that are applicable to each of i t; nla'Ior federal programs for the year ended June 30, 1998. Honorable Mayor and Members of the ., City Council City of Cape Girardeau, Missouri Page 2 Internal Control Over Compliance The management of the City of Cape Girardeau, Missouri i:; responsible for establishing and maintaining effective internal control over compliance with requirements of laws, regulation:., contracts and grants applicable to federal programs. In planning and performing our audit, we considered the City of Cape Girardeau, Missouri's internal control over compliance with requirements that: could have a direct and material effect on a major federal program i_n order I:o determine our auditing procedures for the purpose of _ expressing our opinion on compliance and to test and report ou internal control over compliance in accordance with OMB Circular A-133. Our consideration ofthe infernal control over compliance would not necessarily disclose all matters in the internal control that might be material weaknesses. A material weakness is a condition in which the design or operation of one or more of the internaL control components does notreduce to a relatively low level the risk that noncompliance with applicable requirements of laws, regulations, contracts and grants that would be material iii relation to a major federal program being audited may occur and not be detected within a timely period by employees in the normal course of performing their assigned functions. We noted no matters involving the internal control over compliance and its operation that we consider to be matei:ial weaknesses. ti<$edule of Expenditures of Fedcral Awards We have audited the general purpose financial statements of the City of Cape Girardeau, Missouri as of and for the year ended Juue 30, 1998, and have issued our report thereon dated December 3, 1998..Our audit was performed for the purpose of forming au opinion on the general purpose financial statements taken as a whole. The accompanying schedule of expenditures of federal awards i.s, presented for purposes of additional analysis as required by OMB Circular A-133 and is not a required part of the general purpose financial statements. Such information has been subjected to the auditing procedures applied in the audit of the general purpose financial statements and, in our opinion, is fairly stated, in all. material respects, in relation to the general purpose financial statements taken as a whole. 'Phis report is intended for the information of the City Council, management of the City of Cape Girardeau, Missouri, and federal awarding agencies and pass-through entities. However, this report- is a matter of public record and its distribution is not limited. BEGLEY, JANSSEN, YOUNG & EiRK, LC Cape Girardeau, Missouri December 3, 1998 Ito Begley, Janssen, Young & Birk, LC CERTIFIED PUB[ CACCOUNTANTS 2103THEMIS ST CAPE GIRARDEAU, MISSOURI 6+I01 -TELEPHONE (573)334 2845- FAX (573) 3344338 PAIi I III RIS JOAN II JANSSEN-CPA JENNIFER WESTRICII CPA 11[TRY It BEGIIYCPA ,JEFF IINIERIJI IRI Ii. CPA LAWRENCE E YOUNG, CPA CATHERINE A. WI III I - CPA KELVIN W. BIRK- CPA INDEPENDENT AUDITORS' REPORT ON COMPLIANCE AND ON INTERNAL CON'J'ROL OVER FT NANCIAL REPORTING EASED ON AN AUDIT'(JF FINATICI.A) STATEMENTS PERFORMED IN ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS Honorable Mayor and Members of the City Council. city of Cape Girard(ait, M,i.suunr-i We. have audited the I riniicir,I sta Lenuxnts of the City of Cape (Illrardeau, Missourias of alai for the year ended June 30, 1998, .Ind have issued our report I.hleret,n dated December 3, 1998. We conducted our audit in auc,rd¢nce with generally accepted ,niditing standards and Goveiumeni Auditing landards, issued by the Compl.roller Genr,ral of Ilu, UUlted States. Compliance As part of obtaininq reasonable assurance about whether the City ,,f Cape Girardeau, Mi,^souri'ri financial statements are free of material missLatertlenl:, we pt�l forded tests of its coulpli.ance with I. rtaio provisions o1' laws, regulatiouS, COLLIapt5 and grants, noncompliance with which conid halve at direct and material effect on the determination of fin,,ncial statement amounts. Ilowever, providing an opinion on compliant -e with those provisions was not all objective of our audit arnt, accordingly, we do not express such an opinion. The resu7li, of our tests disclosed no instances of noncompliance tlr..il are jlf1(iirod to be reported under Government Auditing_ StandardT. Internal Control Over F=nancial I'eporting In planning and performing ,lir audit, we considered the City of Cape Girardeau, Misl;Gnri's iill emlal control over financial reportingreporting in order Co determine our auditing procedures for the purpose of expressing our opinion on the financial statements and not to provide assurance on Che internal control over financial reportinq. However, we noted a certain matter involving the internal control over financiol reporting and its operation that we consider to be a reportable ccndilion. Reportable conditions involve matters coming to our attention relating to significant deficiencies in the design or operation of the internal control over financial reporting thal I io our judgmenL, could adversely affect the City of Cale Gin n,leau, Missouri's ability to record, process, summarize and repoil_ financial data consistent with the assertions of management in the financial statements. The reportable condition is described iu the accompanying Schedule of findiuys and questi,ncd cosi,+. Honorable Mayor and Members of the City Council City of Cape Girardeau, Missouri Page 2 A material weakness is a condition in which the design or operation of one or more of the internal control components does not reduce to a relatively low :Level the risk that misstatements in amounts that would be materialin relation to the financial statements being audited may occur and not be detected within a timely period by employees in the normal course of performing their assigned functions. Our consideration of the internal control over financial reporting would not necessarily disclose all matters in the internal control that might be reportable conditions and, accordingly, would not necessarily disclose all reportable conditions that are also considered to be material weaknesses. However-, we believe that the reportable condition described above is not a material weakness. 'Phis report is intended for the information of the City Council, management of the City of Cape Girardeau, Missouri, and federal awarding agencies and pass-through entities. However, this report is a matter of public record and its distribution is not I. i. mit ed. BEGLEY, (J�AN�SS�E�N�., YOUNG &/BIRK, LC Cape Girardeau, Missouri December 3, 1998 112 III City of Cape Girardeau, Missouri + SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS June 30, 1998 + Federal Program Federal Grantor/Pass-through CFDA or Award Federal Grantor/Program Title Number Amount Expenditures + + Department of Commerce Economic Development Administration Sudden and Severe Economic Dislocation + Implementation Project Water Plant 141 11.307 $ 729,750 $ 46,379 Wastewater Treatment Plant Access & Power Supply 11.307 392,000 59,723 Sprigg Street Elevation 11.307 425,750 42,575 + Total Department of Commerce 148.677 Department of Education + Passed through Missouri State Library Basic Equipment Grant 84.034A 2,402 1,681 Show Me Steps to Professional Development 84.034A 731 713 + Total Department of Education _., _ 2 394 ,., Department of Housing and Urban Development Passed through Missouri Dept of Economic Development Community Development Block Grants + 95 -ND -02 Locust/Maple 14.219 400,000 195,934 95 -ED -27 D & K Wholesale Drug 14.219 70,229 1852 94 -DR -96 Flood Buyout Program 14.219 760,000 2Q6,635 + Subtotal 405.421 Passed through Missouri Dept of Social Services Emergency Shelter Grant 14.231 13,325 13.325 + 'notal Department of Housing and Urban Development _418.746 + Department of the Interior Environmental Protection Agency Passed through Missouri Dept of Natural Resources + SRF Loan Series 1991A ('295004-01 66.458 - 39,796 SRF Loan Series 1993A ('295004-02 66.458 - 13,504 SRF Loan Series 1995D ('295229-01 66.458 - 242,549 + SRF Loan Series 1996D ('295229-02 66.458 - 117,321 Subtotal 413,170 Federal Emergency Management Agency I lazard Mitigation Assistance 83.519 1,480,585 313.846 Total Department of the Interior 727,01 III City of Cape Girardeau, Missouri SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS June30,1998 Federal Program Federal Grantor/Pass-through CFDA or Award Grantor/Program Title Number Amount tIa $ 28,704 39,750 115,968 179,077 7,622 19,142 160,520 136,150 98,181 449,600 Federal Expenditures $ 28,704 21.544 50,248 33,160 12 949 3,885 14.081 17.966 1 14 323 71,008 49.950 120,958 96,522 93,826 2.676 '113.982 725 138 Department of Justice Office of.lustice Programs Local Law Enforcement Block Grant 96 -L[3 -VX -1209 16.592 Local law Enforcement Block Caant 97 -LB -VX -3234 16.592 Suhlolal COPS Grant 95 -DM -BX -0047 16.580 COPS Universal Hiring Grant 97-UM-WX-0055 16.710 Passed through Missouri Dept of Public Safely Victims of Crime Act (FY `96) 16.575 Victims of Crime Act (FY `97) 16.575 Subtotal Total Department of Justice Department of Transportation Safe Communities Grant -97 -SA -09-2 20.600 Safe Communities Grant -98 -SA -09-2 20.600 Subtotal Public Taxi Coupon Transportation - MO- 18-X017-4CG 20.509 National ISE TE Recreation Triils Funding Program 20.219 Community Team Spirit Cofflucnce 20.601 Total Department of Transportation TOTAL FEDERAL EXPENDI'T'URES tIa $ 28,704 39,750 115,968 179,077 7,622 19,142 160,520 136,150 98,181 449,600 Federal Expenditures $ 28,704 21.544 50,248 33,160 12 949 3,885 14.081 17.966 1 14 323 71,008 49.950 120,958 96,522 93,826 2.676 '113.982 725 138 THE CITY OF CAPE GIRARDEAU, MISSOURI SCHEDULE OF FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 1998 A. SUMMARY OF AUDIT RESULTS 1. The auditor's report, expresses an unqualified opinion on the statements of the City of Cape Girardeau, Missouri. 2. One reportable condition disclosed during the audit of the financial statements was reported in the Independent Auditors' Report ou Compliance and on Internal Control. over Financial Reporting Based on an Audit of Financial Statements Performed in Accordance with Government Auditing Standards. 3. No instances of noncompliance material to the financial. statements were disclosed during the audit. 4. No reportable conditions were disclosed during the audit of the major federal award programs. 5. The auditor's report OIL compliance for the major federal +. award programs for the City of Cape Girardeau, Missouri. expresses ail unqualified opinion. 6. The programs tested as major programs included: Department of Transportation Safe Communities Grants CFDA # 20.600 Department of the Interior .. SRF Loan Series CFDA # 66.458 Department of Commerce Economic Development Administration Grants CFDA # 1.1.307 7. The threshold for distinguishing Type A and B programs was $300,000 in federal expenditures. 8. The City of Cape Girardeau, Missouri was determined to be a low-risk auditee. SCHEDULE OF FINDINGS AND QUESTIONED COSTS CONTINUED PAGE 2 B. FINDINGS -FINANCIAL STATEMENTS AUDIT 1. Cash Receipts r Condition: In the Municipal Court Department, the cashier and bookkeeping functions are not properly segregated. The newly installed computer software allows the individual responsible for collecting cash the ability to access and change the amount of a fine. Criteria: Internal controls should be in place that provide reasonable assurance that receipts are properly deposited, and revenues and receivables completely and ^� accurately recorded. Effect: The lack of segregation of duties could result in undetected cash shortages. Recommendation: System software controls should be in place to limit the cashier's access to offender fines. Response: We concur with the recommendation. Such procedures have been implemented. C. FINDINGS AND QUESTIONED COSTS -MAJOR FEDERAL AWARD PROGRAMS None 116