Loading...
HomeMy WebLinkAbout1996-1997.AuditReportFINANCIAL STATEMENTS AND INDEPENDENT AUDITORS' REPORT CITY OF CAPE GIRARDEAU, MISSOURI June 30, 1997 M CONTENTS FINANCIAL SECTION Page Independent Auditors' Report 7 GENERAL PURPOSE FINANCIAL STATEMENTS Combined Balance Sheet - All Fund Types and Account Groups 10 Combined Statement of Revenues, Expenditures r 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 - All Proprietary Fund Types 15 Combined Statement of Cash Flows - All Proprietary Fund Types 16 Notes to Financial Statements 17 COMBINING AND INDIVIDUAL FUND FINANCIAL STATEMENTS r GENERAL FUND Comparative Balance Sheet 59 ` Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 60 r SPECIAL REVENUE FUNDS Combining Balance Sheet 61 Combined Statement of Revenues, Expenditures and Changes in Fund Balance 62 Convention/Visitors Special Revenue Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 63 CONTENTS - CONTINUED SPECIAL REVENUE FUNDS - Continued Airport Special Revenue Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 64 Downtown Business Special Revenue Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 65 Parks and Recreation Special Revenue Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 66 Health Special Revenue Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 67 Motor Fuel Tax Special Revenue Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 68 Capital Improvement Sales Tax Special Revenue Fund - Flood Control Projects Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 69 Capital Improvement Sales Tax Special Revenue Fund - Water Projects Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 70 Transportation Sales Tax Trust Special Revenue Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 71 Flood Protection Special Revenue Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 72 Vision 2000 Special Revenue Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 73 DEBT SERVICE FUND Debt Service Fund - Comparative Balance Sheet 74 CONTENTS - CONTINUED CAPITAL PROJECTS FUND Combining Balance Sheet 75 Combining Statement of Revenues, Expenditures and Changes in Fund Balance 76 General Capital Improvement Fund - + Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 77 + Corp Flood Control Capital Project Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 78 Street Improvements Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 79 FAU Street Grants Fund - Schedule of Revenues and Expenditures - + Budget and Actual (Budget Basis) 80 Community Development Block Grant Fund - Schedule of Revenues and Expenditures - + Budget and Actual (Budget Basis) 81 Park Improvements Fund - ., Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 82 Water Improvement Projects - + Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 83 + ENTERPRISE FUNDS Combining Balance Sheet 84 Combining Statement of Revenues, Expenses and Changes in Retained Earnings 85 + Combining Statement of Cash Plows 86 Sewer Fund + Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 87 CONTENTS - CONTINUED Water Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 88 Solid Waste Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 89 Golf Course Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 90 Softball Complex Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 91 INTERNAL SERVICE FUNDS Combining Balance Sheet 92 Combining Statement of Revenues, Expenses and Changes in Retained Earnings 93 Combining Statement of Cash Flows 94 Data Processing Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 95 Fleet Management Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 96 Employees' Fringe Benefit Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 97 Risk Management Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 98 Equipment Replacement Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 99 AGENCY FUNDS Combining Balance Sheet 100 Combining statement of Changes in Assets and Liabilities - Al] Agency Funds 101 CONTENTS - CONTINUED FIXED ASSETS Schedule of General Fixed Assets by Source 102 Schedule of General Fixed Assets - By Function and Activity 103 Schedule of Changes in General Fixed Assets - By Function and Activity 104 LONG-TERM DEBT Schedule of Changes in Long -Term Debt 105 Statement of General Long -Term Debt 106 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 108 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 110 Schedule of Expenditures of Federal Awards 112 Schedule of Findings and Questioned Costs 114 r Begley, Janssen, Young & Birk, LC r 2103 TMEMISST -CAPE GIRAROEAU.MISSOUH163701 -TELEPHONE (573)334.2845- FAX (573)3 4338 PARTNERS r JOHN R. JANSSEN, CPA JENNIFER WESTRICH, CPA TERRY R. BEGLEY, CPA JEFF UNTERREINER, CPA LAWRENCE E YOUNG. CPA CATHERINEA. WHITE KELVIN W. BIRK. CPA INDEPENDENT AUDITORS' REPORT ON THE GENERAL PURPOSE FINANCIAL STATEMENTS r AND SUPPLEMENTARY INFORMATION r Honorable Mayor and Members of the City Council City of Cape Girardeau, Missouri we have audited the accompanying general purpose financial statements of the City of Cape Girardeau, Missouri as of June 30, 1997, 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 general purpose financial statements based on our audit. We conducted our audit in accordance with generally accepted r auditing standards and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Those standards require r 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 r 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, 1997, 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 Auditine Standards, we have also r issued our report dated November 20, 1997 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. c 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 our opinion, is fairly presented in all material respects in relation to the general purpose financial statements taken as a whole. _ GL Y, J_ANS3EN, YOUNG &P S�R�K,�t LC f (O7ty`�'^�o"'��^"'k� fl/'h1,"�^',,�` +r.�'u!J �C✓ Cape Girardeau, Missouri November 20, 1997 [a GENERAL PURPOSE FINANCIAL STATEMENTS I 1 i i 1 I i 1 1 I 1 1 1 1 1 1 1 1 1 Cay a CepaG®4 . Saesorn COMBINED BAINICE MM ALL FUNDTWES AND ACCOUNT amms Juls 30, 1BW Gaenme4Nl Fnd Tvp® Pll,, ryFad Types F1d•r Fntl Type A¢anl Graq G SmtmL SpecYl �t14 OeW ieDa4G Cepidl Nlmml Cm®m_ 191smea_yardm. Fl Fiord lmM-Tam emu4aL daft �L Tmh Dlam.tllm 5-ao-9T OON1 B -3➢ -95. ASSETS ANDOTHEA DEBRS bas: CM aid mbeyvelm6 $;2]8,02) 58508,759 51,425.)3) $1,528,138 51,296,755 5261$880 505.181 E- 4- 51,16,OT) 513,684,714 Malmna - 1.O0.0m 2.060.43 313,165 1,28,989 1®,983 2.105.065 - - 6,968.)05 ),645.15) na oisllovenan for dwbUlm, meiNqabRs Peel abre, penolMl prmeny, end meMalts lexa )8982 10.675 12071 - - - 19435 - - 81,363 62424 Salm ))5.308 721.301 _ _ _ _ _ _ - 1,159.819 980,957 Frv0M1 tmtm Hotel-m�teltu recevable - 29,951 - - - _ _ _ - 29951 31,00 ileereuren[tex recevWNe - u,t66 d4.1% 45,12 UwM cber9a receirede _ _ _ _ 1,@5.166 - _ _ - 1,525.656 1,163,152 ape®laes�amen6 recavaae 52150 - 712.644 71522 - - - - 94,)50 9`.,0,952 Imrairecevede 215,]622 69 33 26627 3%.524 1,366 3%,43 6.4.968 64],319 0 Nota rweiysUe 51.169 19943 - - 21o.zm 14.163 4.IW 102 - - 32,55) 329,451 Nall _ _ _ 4522 _ _ _ _ _ 4.522 6065 mmwle Mergwueltax al recaizbles MONrluelrex - 86527 56087 85,525 Motorvebnle!base len - 12189 12159 15,319 Momrvebe seta Nx - 19645 - - - - _ _ _ 19,545 17,502 Gren6r 321,611 1348!1 - 565gW 352,1]) - - - - 1(!49]0) 1,043,540 D4eirpn b.re rI df 1,025,570 1,@5,5]0 1,743,249 A&- I. h., lundx I. h., 1,52],510 _ _ - _ _ _ _ _ 1.56),`•10 1. 4rva'Roria 6ZI 19]49 - - 111,22) 8.011 - - - 139,613 tu,W1 13!,965 flntricled ®ae6 C -h and.eh - - - 2$13,606 )66T/] 25916,)&1 25976,599 W -"a m 64,052 640.033 2.,6.%4 ?,p flans 55270 10,125 - - 924786 69110 159)9.295 1.167.20 FuedasM. net of wmmulalad dwC .tor 39999,544 959,646 - 1),029.)0 - 57,959.101 50.126,393 Nota neem: MnamlevailnNeladedeervice 3,41,51 J.41.'b3 2Y5,494 Amami to be provided iw mdranmt ol9...I 1.9-1.52!& 4A - _ _ _ _ _ _ - 18069,410 1&089.410 14,052217 Amcanttobeprw-forWWm FN) ort 01 canpar®teaebamcea _ _ _ _ _ _ _ 514063 544.%3 515,991 Tml oast and aa4a A4ia SJ661996 555311)1 34.239802 52533675 91.518019 589 317 SZ600= 31]029)0 55).154.)2 5135961619 $129.6925% THE NOTES TO THE FINANCIAL STATEMENTS ARE AN INTEGRAL PART OF TH6 STATEMENT. I 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 THE NOTES TO THE FINANCIAL STATEMENTS AREPN INTEGRAL PA OFTH6 STATEf4I , CRY of Crone Gmrdrr, INnaed COMBINED BAIANCE SHEET ALL FUNDI M AND ACCOUNT OHMS Ane 30. IW Team.,, O mmtelF dTyp PrWnstay Fnd Typm fund Type A tGra, Garval �1a� Spwel �6' Daft �pt♦m. Cepilel Yuanel F®d long-Tg-Tmm Tamh Nenoraidum OnNI I1A910T1ES, EOUDY ANDOTHEN CNESlfS 11 P Fll�L i�0. (gDflL �H9b. �L 9�$J-`Z 3ffi liebiE,: Ac nb,yeble 5246,221 5d16,G® 52167 591,178 E9M E672,1a E9H6 E- E- 52221,890 52509,679 Accual litiliti® Selaria,payml 6® and bone% 261,59 5868] - - 13],]]3 26679 9323 - 5N.003 1,040.015 1,ffi4.(59 Ntl®,yaele _ _ _ _ 34.646 _ _ _ _ 34.646 40.413 hareet,leble - - 265 - 6]6,On 3,511 - - - 6]9.0]3 3]4,]89 Oharl'ebilM,e 19261 449 - - 201243 9 4)6,549 - - 0W,572 73.290 Otetoohergwommmle 20 - - 1.000 114296 2651 - - 51,6&9 lffl. Vi 216,212 Die tO oher WndS 496.324 59,246 1,@5$]0 1.743,249 Advala from oher finds 1,86],93 1,B7.W0 1,]52,`.9( Cunt poN of long-teml debt - - - - 1.365,235 110,000 - - 2.91.765 3,B67A00 3322,000 Iag-Wee deb net of anmt portion Pavmua bmtls,pbla - - - - 41,001(610 - - - - 41,038610 40.769,810 F' tmsahold reoerue b,da,yNlle 1,59],10] 6,132,M) ],]19.336 10.]16,0]0 r' Catif Im of ,erhyetan - - - - 3.040.(5 766,914 - - 5,95.000 9103914 6,435,000 Gnere otAigetm mbndng bn%,y Wo _ - _ _ _ _ _ _ 2.740.000 2740,W0 3,0]9(10 Etmated Wei cbeure and peat-cbsure care4eatl¢alily _ _ _ _ 99,960 - _ _ _ 822960 815.258 OeieW wpe¢alim We anployeea 2,105.065 - - 2,105,065 1.506987 bknecl—a oe 1.616,6]3 42].8]8 716,316 76495 2.851,162 2692.958 To01 b Hoe 2.3].]15 6W.97 ]16,]66 661,597 5240O3W L38 jw 2.90303 - 1],154,]26 7BA76,979 TL038282 E,by and abec ceem: hveaMan in gmeml fend aeae6 _ _ _ _ _ _ _ 17,09,709 - 17,02s,7o9 14.172520 Cmtriouted tepWl 169]0,802 169]O,6U2 17,3W4 15 Rennad ee ., Reserved _ _ _ - XOOM - _ _ _ 30000 26333 Un�erve0 116,894 3.335.187 3,4 wl 288,37 fund 9amncm: lleeervad 2.097,784 2]6262 3.521,034 1,837,M0 _ _ _ _ _ ].]92800 12051,5117 Un,erved 3,3J967 7,81,633 - (211,642) - - - 16W9460 5,]b,532 T.W aqui, sld ena ae6H 5AW.91 ].10],095 3,M1.CP1 1,ee,ws 19.117,606 3x5,187 17,09.709 5].804.8]0 52058304 Toted Nb . eouiry and aher oedY 57,684996 56531,192 $4239,602 E2533b75 571,516049 $4,6831] 52693363 $17,(29]09 517,154.726 $135,95 FM $19.892 THE NOTES TO THE FINANCIAL STATEMENTS AREPN INTEGRAL PA OFTH6 STATEf4I , FUND BALANCES, JULY 1 5,469,129 4,083,090 City of Cape Girardeau, Missouri 5,260,412 1],]92,124 PRIOR PERIOD ADJUSTMENT (30.945) COMBINED STATEMENTOF REVENUES, EXPENDITURES AND FUND BALANCES, JUNE 30 $5,407,281 $7837895 $3 521 034 CHANGES IN FUND BALANCES r ALL GOVERNMENTAL FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 30, 1997 GOVERNMENTAL FUND TYPES r TOTALS SPECIAL DEBT CAPITAL (MEMORANDUM GENERAL REVENUE SERVICE PROJECTS ONLY) REVENUES Tares $10,203.793 56,221,316 $321,909 $- $16,753,018 Licenses and permits 884,687 - - - 884,6117 Intsr9owmmentd 1,722,813 1,332,081 ],6]0 1,114,243 4,1]6.60] _ Charges for .,A... 238,824 301,551 - - 540,375 Interdepedmental services 459,548 - - - 459,546 Rhes and fodalWres 556,759 - - - 55,759 Mlscalleneous 107,638 117.671 - - 225,309 as Interest 233,268 381,084 190,225 266,579 1,0]1,1]6 Speclaf a ...... nte 7,123 301,598 118,811 427,532 TOTAL REVENUES 14,414,473 8,359,703 821,402 1,499,633 25,095,211 EXPENDITURES Current r AdmhlslreW. se Mcee 1,241,129 015,736 - - 2,056,865 Development seMo.. 1,296,470 18,626 - - 1,315,096 Parke and rocre.Wo 993,625 695,266 - - 1,869,093 Pubic safety 6,681,531 144,622 - - 6,826,153 r Public works 1,658,398 1.042.938 - - 2,701,336 Contingency 1,633,630 - - - 1,633,830 Capital outlay - - - 6,511,692 6,511,692 Debt wMo. r Principe] - 12,297 2,165,876 - 2,178,173 Int ere st and fi.cat dnergee 1,218 821,]]1 84,]]2 907,761 TOTAL EXPENDITURES 13,505,163 2,93,705 2,98],64] 6,598,464 26,019.999 EXCESS (DEFICIENCY) OF REVENUES OVER(UNDEfa EXPENDITURES 909,290 5,428,998 (2,166.245) (5,(X,831) (924,788) �. OTHER FINANCING SOURCES (USES) Operating transfers in 818,735 1,098,000 2,45,996 73,232 4,448,963 Operating tnndare out (1,806,236) (2,]]2,193) - (75,735) (4,654,164) Bond proceeds - - 1,045,000 1,505,000 2,550,000 r Lose oa sate of securities - - (1,375) - (1,375) Payment t0 refunding escrow - - (774,035) - (774,835) Proceed. from fixed Beast. 27,308 27,308 r TOTAL OTHER FINANCING SOURCES (USES) (960,193) (1,674,193) 2,727,786 1,502,497 1,595,897 EXCESS (DEFICIENCY) OF REVENUES r AND OTHER FINANCING SOURCES OVER (UNDEBI EXPENDITURES AND OTHER FINANCING USES 150.903) 3,754,605 561 541 (3,594,334) 671,109 FUND BALANCES, JULY 1 5,469,129 4,083,090 2,959,493 5,260,412 1],]92,124 PRIOR PERIOD ADJUSTMENT (30.945) (30,945) FUND BALANCES, JUNE 30 $5,407,281 $7837895 $3 521 034 $1,666,078 $10,432,288 THE NOTES TO THE FINANCIAL STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT. 12 City of Cape Girardeau. Missouri 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, 1997 GENERAL FUND SPECIAL REVENUE FUNDS VARIANCE VARIANCE FAVORABLE FAVORABLE BUDGET SAL )UNFAVORABLE) BUDTGET ACTUAL (UNFAVORABLE) REVENUES THE NOTES TO THE FINANCIAL STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT. 13 Taxes 110,538925 $10,203,793 ($335,032) $6,352.375 $8227,318 ($125059) Ucerleee end permlle 911,850 004,637 (26,963) - - - htergo.nmantal 338375 1.722813 1,306.438 1,376,7W 1,332.081 (44.619) Chargee br servbee 312.035 238824 (73,811) 321OW 301551 (20249) Inladeperbnenlal cervices 495,067 459,548 (35.452) - - - Fbm and lodellures 540,000 558.759 16.759 - - - Mismllareoup 88000 107,038 47,036 104445 117.671 13226 Interest 241.625 233280 (83371 121050 381.084 259,234 Specel ameasrrlalts 1000 7,123 6.123 _ TOTAL REVENUES 13437.110 14.414.473 977,363 8.277,170 8,359,703 82533 EXPENDITURES CUoent Admnistal serricm 1,306,539 1.281.122 125.417 1080364 818,500 249,856 Dev bpment wOry 1328.075 1,367.058 26.017 20320 18,626 11694 Poks end recreak 1,014,158 964,667 29356 971.096 074937 98159 Public safety 6,912,405 6,695395 217,010 189,390 142277 27,113 Publi .kc 17W,62 1,5887" 133.478 4,456,000 768174 3,689,828 CDntngermy 1805,000 TeWSW (28.830) - - - Debleervice Rrlr 1pal - - - - 12.297 (12,297) IntaeN and nscal cbago 1W 1w 250 1,218 (9110) _ TOTAL EXPENDITURES 13944,538 13.441989 502.549 6.685.420 2.654,037 4,031,383 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (W7.428) 972.484 1.479.912 1.591.750 5705.666 4,113,918 OTHER FINANCING SOURCES (USES) Operating transfer. In 818,735 818,735 0 1,120000 1,098067 (38000) Operating lmnsfere out R.W9357) (1,606,236) 03.121 (3385,720) (2,772,193) 613,527 Rrmc de km fixed assets 10.000 27308 17,308 TOTAL OTH ER F INANC ING SOU RCES (I,W0,822) (968193) 1W,429 2,257,720 (1,674,193) 563.527 (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOU RCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES H,568,OW) 12,91 1!W,341 (665.970) 4031,473 4,697,443 r. FUN D BALANCES. JU LY 1 5358,822 5,358822 - 3,540,276 3,548276 - PRIORPERIODADJUSTMENT - (30945) 30945) FUND BALANCES, JUNE W $3,788,572 $8337.968 $1,549396 $2.8743W $7.571749 $4.897443 THE NOTES TO THE FINANCIAL STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT. 13 4, Cry of Cepo G4ardosu, Mlsaoud COMBINED STATEMENT OF REVENUES. EXPENDITURES AND CIMNGES IN FUND BALANCES BUDOETAND ACTUAL (BUDGET BASIS) - ALL GOVERNMENTAL FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 3q 1981 ANNUALLY BUDGETED DEBTSERVICEFUND CAPITAL PROJECTS FUNDS VARIANCE VARIANCE BUDGE[ ACTUAL FAVORABLE IUNFAVORABLEI BUDGET ACTUAL FAVORABLE 1UNFAVOiM91F REVENUES Tate. (305450 $321,008 $16,459f- wlow Homely! 7,900 7,670 (230) 1,416,683 1.2P3,613 (273.077) mNoNfareda Inlaer 214,500 190,225 (24275) 67,500 267.342 t90.s42 r swiala® ..tv 115,003 WIAW 169.506 29.000_ _ 20,4n (523) TOTAL REVENUES 642.350 821.402 173.552 _1.573.3% 1.499,832 3.750 r EXPENDITURES Capital Doth, - - - 4.316650 2280,503 2.038.147 DebteaMr:a Principal 2.277.931 2.165.878 112.055 Interest and 3snal char,, 322.842 821.771 871 - 64.270 (84,270) _ TOTAL EXPENDMJRES 3.1W.573 2.987.847 112.926 4.318850 _ 2.384.774 1.951876 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (2,457,723) (2100245) 291478 (2.1Q,2W) (866142) 1876,116 OTHER FINANCING SOURCES (USES) Operating trerefers In 2,463.800 2458.906 (9,3041 205.000 73.232 (131.786) Opaetir9laraferscut - - - 108,000 (75.735) (163.735] B7M Proceeds - 1045.000 100.5000 - 1.505.000 1.505.000 Loss on sale ale urffies - (1.375) (1375) - - - 1%ymenimreluntledlMneetaowepenl (]74,835) (774,635) TOTAL OTHER FINANCING SOURCES (USES) 2.468.800 2727]38 253.936 313.000 1.502,407 1169,491 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOU BCES OVER (U N DER) EXPENDITU RES AND OTHER FINANCING USES 11.077 581.541 550.494 (2,430,250) SSL355 3.07,815 FUND BALANCES, JULY 1 2,959,493 2,959,493 1.IG,17 5 1,1" 725 FUNOSALANCES, JUNE 30 $2.70570 $3.521034 5550.484 ($1245.535151.622.000 53081.915 THE NOTES TO THE FINANCIAL STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT. 14 City of Cape Girardeau, Missouri COMBINED STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS ALL PROPRIETARY FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 30, 1997 15 TOTALS PROPRIETARY FUND TYPES (MEMORANDUM ONLY) as INTERNAL ENTERPRISE SERVICE 1996-1997 as OPERATING REVENUES Residential chargee $5,260,430 $- $5,260,430 Commercial chargee 2,457,189 - 2,457,189 Transfer ddbn chargee 675,636 - 675,636 Equipment atlas 7,971 - 7,971 Concession revenues 87,369 - 87,369 Golf course fees 399,751 - 399,751 Softball complex fees 45,131 - 45,131 Ohertees and eherges 229,462 - 229,462 as Interdepartmental cervices - 2.756,569 2,756,569 Other miscellaneous 41,176 91551 50,727 TOTAL OPERATING REVENUES 9,204,115 2,766,120 11,970,235 r OPERATING EXPENSES Personnel services 2,016,827 586,360 2,603,187 Materiels and supplies 287,242 246,560 533,802 Contractual services 3,489,301 1,482,289 4,971,590 General operating expenses 270,742 7.475 278,217 Special projects expense 126,850 - 126,850 Internal service expeneea 314,037 2.044 316,081 Delp ... When expense 1,472,921 199,511 1,672,432 TOTAL OPERATING EXPENSES 7,977,920 2,524,239 10,502,159 as OPERATING INCOME (LOSS) 1,226,195 241,881 1,468,076 NON-OPERATING REVENUES (EXPENSES) se Interest Income 1,721,470 148,131 1,869,601 State grants (183) - (183) Federal grants 12,358 - 12,358 Sal a of fixed assets 4,026 - 4,026 Compensation for damages 4,449 6,560 11,009 Issuance cod amortization (104,242) (509) (104,751) Interest and handling costa (2687,607) (3,382) (2690989) TOTAL NON-OPERATING REVENUES (EXPENSES) (1,049,729) 150,800 (898,929) INCOME (LOSS) BEFORE OPERATING TRANSFERS 176,466 392,681 569,147 Operating transfers in 217,100 161,598 378,698 Operating transfer. out (173,500) (173,500) NET INCOME (LOSS) 393,566 380,779 774,345 w RETAINED EARNINGS (DEFICIT), JULY 1 (227,682) 2,924,408 2,696,726 PRIOR PERIOD ADJUSTMENT (19,000) (19,000) as RETAINED EARNINGS IDEFICIT), JUNE 30 $146.884 $3305187 $3.452071 THE NOTES TO THE FINANCIAL STATEMENTS ARE AN INTEG HAL PART OF THIS STATEMENT. 15 THE NOTES TO THE FINANCIAL STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT. 16 City of Cape Oirardeaq Mleeourl COMBINED STATEMENT OF CASH FLOWS - ALL PROPRIETARY FUND TYPES FOR THE FISC YEAR ENDED JUNG W. 1007 PROPRIETARY FUND IYPIS TOTALS INTERNAL (MEMORANDUM ONLY) ENTERPRISE SERVICE 1998-1997 CASA FLOWS FROM OPERATING ACTIVITIES: 0Pera6ng lnconts acu) 51,226,195 $241,681 $1,4 ,076 Adjustment to reconcile opening Income to net cash provided by operetirg edWo.: Depmolmbn 1,4)2,921 199,511 1,6]2,432 Cash operating Dams rwoWd 12,175 - 12,175 Charge In assets end IIsUgles: (Increase) dea rease In accounts receNeble (119,710) 91,137 (28,573) (Inmeaee) decrease In lNentory (2,012) 1,451 (561) (Increase) decrease In prepaid Mame 23,693 7,833 31,526 Increase Weaeese) II accounts Myeble (681522) (93,323) (161,845) Irlaeese (decrease) In aniseed lablldes (859,9]7) (4,015) (663,992) ` Increase (decreue) In landgl podciosure care costs 7,702 7.702 NET CASH PROVIDED BY (USED IN) OPERATING ACTIVITIES 1,692,465 444,475 2,136,940 GSH FLOWS FROM NONCAPRAL FINANCING ACTIVITIES: Operating bandere In from other Mde 217,100 161,598 378,698 .� Operating transfers out to 011ier finds - 173, (173500) TIT CASH PROVIDED BY (USED IN) NONCAPRAL FINANCING ACTIVITIES 21],100 (I1,9M 205,196 ` CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES: P=eeds tom TAvelOpas 138,520 - 138,520 Prfndmi paid on revenue hoods (340,000) - (340.000) Pnncipal pald on lease punhsse bonds (584,125) - (564,125) PM6,1 Paid on COP bonds (140,000) - (140,0001 Principal paid on SRF bond. (92,000) - (92,00(3) Princysl paid on energy loan 8 nota IhaYahle on land (49,881) (407) (50,288) Menest pad on bonds and obligations (1,616,021) 32 (1,615,989) Prcceeds Tom capital grams recehed tom other gwanmems 741(709 - 741,009 Purchase of f(ed assets (5,684,2901 (295,449) (5,979,739) Proceed. from COP laeumce - 853,847 853,847 Proceed. from .10 of assets 9,975 15,041 25,016 ` Compensation for damages 4,449 6,560 11.009 NET CASH PROVIDED BY ((SED IN) CAPITAL AND RELATED FINANCING ACTIVITIES (7,612,364) 579,624 (7,032]40) G9f FLOWS FROIA INVESTING ACTIVITIES: Purchase of tneslmm e - - - Proceedstomseledhvestmems 1,986,664 98,989 2,085,153 Imamst on w.slmenb 1,57],815 12,381 1,590,196 OvemlgN Mend 139,390 137,812 27],202 Imere.t on eseeeumenb 10,698 10,696 NET CASH PROVIDED BY (USED IN) INVESTING ACTIVITIES 3,714,767 249,182 3,963,949 INCREASE (DECREASE) IN CASH AND CASH EOUIVALENTS T.Shtt,032) 1,261,379 (726,653) CASH AND CASH EQUIVALENTS,.LLY 1 28,414,793 2,1]4,2]6 30,589,071 CASH AND CASH EQUIVALENTS, JUNE 30 $26,426,761 $3,435,65] $29.162,418 THE NOTES TO THE FINANCIAL STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT. 16 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE A - SUMMARY 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 govenunent 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 are described below. 1. Reporting Entity In evaluating 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. Cace Girardeau (Missouri) Public Facilities Authority - As described in Note E, the City of Cape Girardeau, Missouri has entered into five lease agreements with the Cape Girardeau (Missouri) Public Facilities Authority (CGPFA). The CGPFA is a not-for-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 the 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 1990B Bonds, Series 1993 Bonds, and limited additional 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 not a component unit of the City, the City handles the funds of and provides accounting and other services for several entities. Since these funds are held in the City's name, these entities are shown as Agency Funds in the financial statements. 17 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 1. Retorting Entity - Continued Beginning January 1, 1996 the Transportation Sales Tax Trust Fund was established as a special revenue fund. The fund was established to collect and expend a sales tax that was approved by a public vote in August 1995 and became effective January I, 1996. The tax is restricted to being expended on street and sidewalk improvements and will expire in five years. 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 are 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. Snecial Revenue Funds - Special Revenue Funds are used to account for the proceeds of specific revenue sources (other than expendable trust or major capital projects) that 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 Projects 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. M City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued .� 2. Fund Accountine - Continued PROPRIETARY FUND TYPES The City has implemented GASB 20 (Accounting and Financial Reporting for Proprietary Funds and Other Governmental Entities that use Proprietary Fund Accounting) by choosing to apply the accounting principles in (1) all GASB pronouncements and (2) FASB (Financial Accounting Standards Board) Statements acrd Interpretations, 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 Funds - Enterprise Funds are used to account for operations that are financed and operated in a mariner 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, management 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 Trust 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-TERM DEBT ACCOUNT GROUPS General Fixed Assets (GFA) - The General Fixed Assets Account Group is used to account for fixed assets used in goverrtmental 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. ,. General Lone -Term Debt Account Group - The General Long -Term Debt Account Group is used to account for long-term liabilities to be financed from governmental funds. 19 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 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 are recorded as expenditures; renewals and betterments are capitalized. Proprietary 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 25-50 years Improvements 10-40 years Equipment 3-10 years When applicable, interest costs are capitalized on self -constructed fixed assets. 4. Basis of Accounting The accounting and financial reporting treatment applied to a fund is determined by its measurement focus. All governmental funds are 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.e., expenditures and other financing uses) in net current assets. 20 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 4. Basis of Accountine - Continued All proprietary funds are accounted for on a Flow of economic resources measurement focus. Willi 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 eamings components. Proprietary fund type operating statements present increases (e.g., revenues) and decreases (e.g., expenses) in net total assets. 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 yearend. Expenditures are recorded when the related fund liability is incurred. Principal and interest on long- term debt are recorded as fund liabilities when due or when amounts have been accumulated in the debt service fund for payments to be made early in the following year. Those revenues susceptible to accrual are property taxes, 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 carried and expenses are recorded at the lime 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 gram monies are received prior to the incurrence of qualifying expenditures. In subsequent periods, when both revenue recognition criteria are met, or when the City has a legal claim to the resources, the liability for deferred revenue is removed from 0te 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. 21 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 .. NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 6. Budeets and BudEetary Accounting The City adopts annual operating budgets for all funds. The City follows these procedures in establishing the budgetary data reflected in the financial statements. r 1. The City Manager submits to the City Council a proposed operating budget for the fiscal year commencing the following July 1. The operating budget includes proposed expenditures and the means of financing them. 2. Public hearings are conducted to obtain taxpayer comments. 3. Prior to July 1, the budget is legally enacted through passage of arr 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. Additional budget appropriations by department made throughout the year are as follows: Community Development Block Grant Fund $ 72,000 Street Improvement Fund 109,000 General Capital Improvement Fund 335,000 Interdepartmental 14,000 Contingency 1,525,000 Parks and Recreation 13,000 Public works 895.000 L2.963 Of the above appropriations, $72,000 was allocated for grant funded economic development projects, $109,000 for completion of various street projects, $335,000 for completion of various airport and park capital projects, $14,000 for a privately funded Transamerica Corridor contract, $1,450,000 for grant funded flood buyout and relocation costs, $75,000 for forgiveness of debt due from Cape Girardeau Public Library, $13,000 for roof replacement of the arena, $845,000 for completion of an EDA grant funded water supply development at plant #1, and $50,000 for fencing of the city's closed landfill. 22 City of Cape Girardeau, Missouri NOTES TO FINANCIAL S'I'ATEMEN'I'S June 30, 1997 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 6. Budgets and Budgetary Accounting - Continued For the year ended lune 30, 1997 general fund expenditures for contingent expenditures exceeded the approved budget by $28,830. Additionally, the airport debt service, general capital improvement and employee fringe benefit funds exceeded their approved budgets by $5,664, $663,284, $7,491, and $285,810 respectively. The Combined Statement of Revenues, Expenditures, and Changes in Fund Balance -All Governmental Fund Types reports revenues and expenditures on the modified accrual basis of accounting in accordance with GAAP. The Combined Statement of Revenues, Expenditures, and Changes in Fund Balance -Budget and Actual (Budget Basis) for all governmental fund types is prepared on a budgetary basis which includes encumbrances as expenditures. 23 The following reconciliation adjusts GAAP basis to budget basis: Excess (Deficiency) of Revenues arid Other Financing Sources over (under) Expenditures and Other Financing Uses Special Debt Capital General Revenue Service Proieets GAAP Basis $ (50,903) $ 3,754,805 $ 561,541 $ (3,594,334) Increase due to: Prior year encumbrances Administrative services 4,860 790 - - Development services 260 - - - Parks and recreation 14,899 27,264 - - Public safety 8,134 2,345 - - Public works 104,354 512,406 - - Capital outlay - - - 4.075.688 132.507 542.805 4.075.688 y Decrease due to: Year-end encumbrances Administrative services 24,853 3,562 - - Development services 3,848 - - - Parks acrd recreation 5,874 6,933 - - �, Public safety 21,998 - - - Public works 12,740 255,642 - - Capital outlay - - - 1,813.457 �. 69y13 266.137 1.813.457 Budget Basis 12,291 $4,031,473 $ 561.541 $(1,332,103) 23 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 6. Budgets and Budeetary 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 reported as expenses in the year of encumbrance. Net Income (Loss) Solid Golf Softball Sewer Water Waste Course Complex GAAP Basis $ 78,824 $ 2.53,969 Increase due to: Prior year encumbrances Materials and supplies 25 1,933 Contractual services 185 3,921 Special projects expenses 28,751 - Capital outlays 2,365,572 99,135 Depreciation 795,561 391,306 Capital grants 255,536 447,830 Impact fees 138,.520 - Adjustment to liability for 229,704 100,536 future landfill postclosure - .. Landfill closure and maintenance costs - - Interest paid less than accrued307,838 - Interest cost amortized 720,622 1,146 Cost of bond refunding - Interest paid more than accrual amortization 30,636 40,856 Issuance cost amortization 66.882 30.239 4,710,128 1,016.366 $ 22,991 $ 18,827 $ 18,955 298 1,112 2,500 1,123 - 400 4,794 - 160,257 - - 221,726 57,328 7,000 80,979 297 7.121 476.595 .58.440 9,9W Decrease due to: Year-end encumbrances Materials and supplies 1,915 228 333 320 740 ,,. Contractual services 46 - - - - General operating expenses - - - 470 - Capital outlays 1,585,447 229,704 100,536 100 - .. Landfill closure and maintenance costs - - 74,834 - - Interest paid more than accrual - 4,368 2,181 - - Bond principal paid 730,542 299,114 170,583 - - Capital outlays 4,421,888 875.522 223.909 52.476 7,065 6.739,838 1,408.936 572,376 53,366 7,805 Budget Basis $ (1,950 886) 138 601 $ (72.790) 23,901L 050 24 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 6. Budgets and Budeeta" Accounting - Continued 25 Net Income (Loss) Data Fleet Equipment Processing Management ment Revlacement GAAP Basis $ 35,102 $ (1,168) $ 170,050 Increase due to: Prior year encumbrances Materials and supplies - 222 - Contractual services - 1,595 - Capital outlays 13,141 4,450 - Depreciation 118,283 34,712 46,516 Interest paid less than accrued 1,618 - 1,664 Bond proceeds (net of issuance costs) 422,277 - 431,570 Issuance costs amortization 256 253 .555.575 40,979 480.003 Decrease due to: Year-end encumbrances Materials and supplies 443 1,372 - Contractual services - 2,999 - General operating expenses 4,495 - - Capital outlays - - - ,� Bond proceeds - - - Interest paid more than accrued - - - ,� Principal paid - 407 - Capital Outlays 44,981 36,472 213.997 49,919 41,250 213.997 .. Budget Basis 540,758 1,439) 436 056 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 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued S. 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 Only Total Columns are captioned "Memorandum Only" to indicate that they are presented only to facilitate financial analysis. Data in these colunms do not present results of operations in conformity with generally accepted accounting principles. Neither is such data comparable to a consolidation. lnterfund elinwnations have not been made in the aggregation of this data. 11. Cash and Cash Equivalents For purposes of the statement of cash flows, the proprietary fund types consider all highly liquid investments with a maturity of three months or less when purchased to be cash equivalents. 12. Comparative Data Comparative totals for the prior year have been presented in the accompanying financial 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, 1997 are recorded as prepaid items. 26 City of Cape Girardeau, Missouri NOTES TO FWANCIAL STATEMENTS June 30, 1997 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 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 oil 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. 15. Lone -term Oblieations 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 -tern obligations, only that portion expected to be financed from expendable available financial resources is reported as a fund liability of a governmental food. The remaining portion of such obligations is reported in the general long-temr debt account group. Long-term liabilities expected to be financed from proprietary fund operations are accounted for in the appropriate proprietary fund. 16. Iuterfund Transactions Quasi-extemal transactions are accounted 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 fiord, are recorded as expenditures/expenses in the reimbursing fund and as reductions of expenditures/expenses is the food 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/Payables 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 Funds Noncurrent portions of long -tern 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. 27 0 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 19. Post -Employment Health Care Benefits r 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, seventeen 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 1997, those costs totaled $30,112. COBRA Benefits - Under the Consolidated Onmibus 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 no participants in the program as of lune 30, 1997. NOTE B - DEPOSITS AND INVESTMENTS 1. Deposits At lane 30, 1997, the carrying arnount of the City's deposits was $5,429,382 and the bards balance was $5,423,817 which excludes $5,565 of petty cash funds held at various City locations. The deposits are categorized in accordance with risk factors created by governmental reporting standards. Carrying Bank Amount Balance Category #1 $ 5,257,209 $ 5,257,209 Category #2 172,173 166,608 Category #3 - - k5,129 $5,423,817 Category #1 includes deposits covered by deposit insurance or collateral }meld 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 name. Category #3 includes deposits which are uncollateralized or the collateral is held by the financial institution's trust department but not in the City's name. W City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE B - DEPOSITS AND INVESTMENTS - Continued 2. Investments The City is allowed to invest its available operating and reserve funds in (1) obligations of the United States or its agencies and instrumentalities; (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. Investments are stated at cost or amortized cost, except for investments in the deferred compensation agency fund which are reported at market value. Proceeds of bond issues may be invested as allowed in the bond indenture. Investments made by the City are summarized below. The investments that are represented by specific identifiable investment securities are classified as to credit risk by the three categories described below: Category #1 Insured or registered, or securities held by the City or its agent in the City's name. Category #2 Uninsured and unregistered, with securities held by the counter -party's tmst department or agent in the City's name. r, Category #3 Uninsured and unregistered, with securities field by the counter -party, or by its trust department or agent but not in the City's name. Category Carrying Market #1 #2 #3 Value Value Repurchase Agreements $ 3,737,761 $ - $ - $ 3,737,761 $ 3,737,761 U.S. Government Securities 13.317.682 13,317.682 13290.770 $ 17.055,443 $_ $ - 17,055,443 17,028,531 Money Market Account U.S. Govermnent Securities 4,163,0.55 4,163,055 State Revolving Fund Program 20,922,620 20,922,620 Investments in Deferred Compensation Plan 2.105 065 2,105,065 � 44 246.183 44 219 271 29 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE C - PROPERTY TAXES Property taxes attach as an enforceable lien on property as of January I. Taxes were levied on August 19, 1996, for collection during this fiscal year and were due on or before December 31. Most of the taxes are collected in November and December. The tax rates assessed at the time were as follows: City Revenue $ .33/100.00 assessed valuation Library Tax .17/100.00 assessed valuation July 1, 1996 Public Health Tax .06/100.00 assessed valuation Depreciation June 30, 1997 Debt Service Tax .10/100.00 assessed valuation $ - $ - Special Business District .80/100.00 assessed valuation Buildings 3,853,591 #2 (Ad Valorem) 242,167 8,867,406 Property tax receivable balances as of June 30, 1997 are as follows: Downtown than building 2,061,078 2,632,968 Business Debt 166,763 4,527,283 _ General District Health Service Libra ry Total Current property tax $ 30,325 $ 1,974 $ 5,386 $ 9,236 $ 16,048 $ 62,969 Delinquent property tax 32,151 2,454 4,545 10,354 14,565 64,069 Reserve for doubtful property taxes (23,494) (86) (3.398) (7.519)1( 1.178)4( 5.675) Net property tax receivables 38 982 4 342 6,533 12,071 19 435 81,363 NOTE D - CHANGES IN FIXED ASSETS A summary of the general fixed assets account group for the year ended June 30, 1997 is as follows: 30 Balance Accumulated Balance July 1, 1996 Additions Deductions Depreciation June 30, 1997 Land $ 2,073,938 $ - $ - $ - $ 2,073,938 Buildings 3,853,591 5,255,982 242,167 8,867,406 Improvements other than building 2,061,078 2,632,968 - 166,763 4,527,283 Equipment 1,686,375 213,213 4,588 339,126 1,555,874 Construction in progress 4,497,538 3.349.795 7.842.125 - 5,208 Total general fixed assets 114 $ 1 I ,451.958 $7,846,713 748 056 $ 17.029.709 30 NOTE E - LONG-TERM OBLIGATIONS The following is a summary of transactions in the General Long -tern[ Debt Account Group of the City for the year ended June 30, 1997. City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 Leasehold a.niflu tes NOTE D - CHANGES IN FIXED ASSETS - Continued Revenue .. Additions and deletions to the Enterprise Funds for the fiscal year 1997 were $6,443,885 and $112,396 respectively. Additions and deletions to the Internal Service Funds were $295,450 and Gave $17,191 respectively. Total General long-term A summary of the proprietary fund type fixed assets for the year ended lune 30, 1997 is as follows: Enterprise Internal Fund Service Fund $ 10,214,870 Land $ 248,109 $ 37,500 $17,557,702 Buildings 9,084,673 421,178 (170,IX10) Improvements other (30,172) (2,999,269) ` than building 32,892,680 104,903 46,293 Equipment 3,693,892 1,522,434 Construction in progress 7,828.867 6,346 $ 53,748,221 $ 2,092,361 Less accumulated depreciation 13,748,677 1,132 513 ` 544 063 L12-999 444 959 848 NOTE E - LONG-TERM OBLIGATIONS The following is a summary of transactions in the General Long -tern[ Debt Account Group of the City for the year ended June 30, 1997. 31 General Leasehold a.niflu tes Obligation Revenue of Unused Paid Due to Other Bonds Bonds Pani6pation Gave Governments Total General long-term debt payable at July 1, 1996 $3,390,000 $ 10,214,870 $3,325,000 $ 545,991 $ 81,841 $17,557,702 Retirements (320,000) (2,430,876) (170,IX10) (48,221) (30,172) (2,999,269) Amount Added 2,550000 46,293 2,596,293 General long-term debt payable at Jane 30, 1997 3 070 000 $ 7JR3, 994 15 705 000 544 063 51 669 17 154 726 31 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 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, 1997. Year Ending Interest Principal Interest June 30 Rate Leasehold Certificates Total 1998 Revenue Revenue of $ 467,738 1999 Bonds Bonds Participation Total Bonds payable at 4.50 355,000 108,488 463,488 July 1, 1996 $ 41,201,811 $ 2,761,199 $ 3,420,000 $ 47,383,010 Discount Amortization 4.90 390,000 73,555 463,555 & Issue Cost 54,374 23,268 (1,086) 76,556 Bonds Issued - - 880,000 880,000 Accumulating Interest 718,424 - - 718,424 Bonds Retired (432,000) (584,124) (140,000) (1,156,124) Bonds payable at June 309 1997 $ 41,542,609 2.200,343 $4,155 8.914 $ 47,90L 666 Bonds payable at June 30, 1997 are comprised of the following individual issues. $ 3,070,000 1993 General Obligation Refunding Bonds due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total 1998 4.00% $ 330,000 $ 137,738 $ 467,738 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 73,555 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 3 070 000 633 642 L2293 Principal payments are made annually on November I, and interest payments are made semi- annually on May 1 mid November 1. 32 0 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE E - LONG TERM 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 are 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. $ 1.060.000 Series 1993 Sewemee System Revenue Bonds due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total 1998 4.400% $ 90,000 $ 53,761 $ 143,761 1999 4.600 95,000 49,801 144,801 2000 4.800 100,000 45,431 145,431 2001 5.000 110,000 40,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 5.350 140,000 15,783 155,783 2006 5.350 155.000 8.293 163.293 1060000 301007 $ 1361,007 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 Much 1, and September 1. 33 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE E - LONG-TERM OBLIGATIONS - Continued — $ 3.280.000 Waterworks System Revenue Bonds Series 1992 due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total 1998 5.50% $ 225,000 $ 219,098 $ 444,098 1999 5.70 27.5,000 206,722 481,722 2000 5.90 320,000 191,048 511,048 2001 6.00 370,000 172,167 542,167 2002 6.10 425,000 149,968 574,968 2003 7.45 485,000 124,042 609,042 2004 7.45 555,000 87,910 642,910 2005 7.45 625.000 46.563 671.563 3 280 WO 1 197 S l8 L4,477 These bonds me dated April 15, 1992. The proceeds of the bond issue were used to purchase, extend and improve the water system serving the City. The purchase of the water system occurred on lune 3, 1992. Principal payments are made amorally on March 1, and interest payments are made semi- annually on March I and September 1. Additional principal of $8,090,000 originally payable through the Fiscal years ending June 30, 2006 to 2012, was defeased via an in -substance defeasance during die fiscal year ended June 30, 1996. 34 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 8.865.000 Waterworks System Refunding Revenue Bonds Series 1995 due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total 1998 4.100% $ 75,000 $ 440,342 $ 515,342 1999 4.200 80,000 437,268 517,268 2000 4.300 80,000 433,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 414,258 514,258 2006 4.875 810,000 409,507 1,219,507 2007 5.000 890,000 370,020 1,260,020 2008 5.000 980,000 325,520 1,305,520 2009 5.200 1,010,000 276,520 1,286,520 2010 5.000 1,065,000 224,000 1,289,000 2011 5.000 1,120,000 170,750 1,290,750 2012 5.000 2.295.000 114.750 2.409.750 8 865 OW 5 315 342 14,180.342 Principal payments are 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 air Escrow Fuud established under an Escrow Trust Agreement dated December 1, 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 beghuung March 1, 1996, and continuing through March 1, 2002, the date on which the Refunded Bonds will be redeemed. 35 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 2.290.000 Sewerage System Revenue Bonds (Stale Revolving Fund Prograrn) Series 1991 due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total 1998 6.000% $ 80,000 $ 154,594 $ 234,594 1999 6.200 80,000 149,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,290.000 $ 1,647.529 $ 3,937.529 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 I, and interest payments are made semi -amorally on June 1 and December 1. .� 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 $1,250,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, 1997 was $712,798. The reserve fund yields 6.71%. 36 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 468.000 Sewerage System Revenue Bonds (State Revolving Fund Program) Series 1993 due as follows: c 37 Year Ending Interest Principal Interest June 30 Rate Due Due Total 1998 3.900% $ 17,000 $ 23,212 $ 40,212 1999 4.100 18,000 22,511 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 20,044 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,983 2006 5.000 24,000 15,819 39,819 ' 2007 5.100 25,000 14,582 39,582 2008 5.200 27,000 13,242 40,242 2009 5.250 28,000 11,805 39,805 ' 2010 5.400 30,000 10,260 40,260 2011 5.400 31,000 8,613 39,613 2012 5.400 33,000 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 468 000 252 990 720 990 These bonds are dated August 1, 1993. The proceeds of the bond issue were used to extend and improve the existing sewerage facilities serving the City. Principal payments are made annually on March 1, and interest payments are made semi- annually on March 1 and September 1. The interest due on the 1993 Sewer System Revenue Bonds will he 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 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 we 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 fund at June 30, 1997 was $327,600. The reserve fiord yields 5.15%. c 37 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMEN'T'S June 30, 1997 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 11,462,662 Water Pollution Control Revenue Bonds (State Revolving Fund Program) 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, 1997 was $3,520,958. 38 ■ Year Ending Interest Principal Interest June 30 Rate Due Due Total 1998 4.750% $ 22,226 $ 2,774 $ 25,000 1999 4.850 21,134 3,866 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 1,280,000 2003 5.300 918,381 441,619 1,360,000 _ 2004 5.400 924,769 530,231 1,455,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 2,090,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 $ 11,462,662 $ 11,767,338 $ 23,230.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, 1997 was $3,520,958. 38 ■ City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE E - LONG-TERM OBLIGATION - Continued $ 13.535.000 Sewemee System Revenue Bonds (State Revolvine Fund Program) Series 1996 due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total 1998 $ 760,761 $ 760,761 1999 760,761 760,761 2000 4.500% $ 25,000 760,761 785,761 2001 4.650 25,000 759,636 784,636 2002 4.800 575,000 758,474 1,333,474 2003 4.900 585,000 730,874 1,315,874 2004 5.000 590,000 702,209 1,292,209 2005 5.150 600,000 672,709 1,272,709 2006 5.250 610,000 641,809 1,251,809 2007 5.350 690,000 609,784 1,299,784 2008 5.500 700,000 572,869 1,272,869 2009 5.600 715,000 534,369 1,249,369 2010 5.700 730,000 494,329 1,224,329 2011 5.875 745,000 452,719 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.021.935 $ 13.535.000 $ 11.130,752 $ 24,665.752 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 1 beginning in the year 2000. Interest is paid semi -amorally on January 1 and July 1 beginning in the year 1997. 39 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 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 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 maximurn 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, 1997 was $1,165,765. $ 10.030,000 Building and Eouimnent Leasehold Refunding & Improvement Revenue Bonds (Capital Improvements Proiect), Series 1993 due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total 1998 4.100% $ 2,265,000 $ 438,800 $ 2,703,800 1999 4.250 2,340,000 345,935 2,685,935 2000 4.400 2,915,000 246,485 3,161,485 r 2001 4.500 705,000 118,225 823,225 2002 4.625 720,000 86,500 806,500 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 r $ 10.030,000 $ 1,346,395 $ 11.376,395 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,961,796 - Sewer Fund; $284,210 - Solid Waste Fund; and $7,783,994 - General Long-term Debt Account Group. Principal payments are made annually on March I and interest payments are made semi-annually on March I and September I. 40 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 3.155.000 Certificates of Participation (Convention and Visitors Recreation Facilities Project) Series 1993. Year Ending Interest Principal Interest June 30 Rate Due Due Total 1998 4.300% $ 215,000 $ 155,733 $ 370,733 1999 4.500 255,000 146,488 401,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,588 2004 5.125 510,000 61,838 571,838 2005 5.250 680.000 35.700 715.700 + 3 155 000 845 096 $ 4,000,096 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 rental and 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, famishing, and equipping of a convention and recreational center, softball mid soccer fields, and improvements to the City Hall. The bond liability for the Series 1993 certificates is recorded in the General Long -Term Debt Account Group. Principal payments are made amorally on April 1, and interest payments are made semi-annually on April 1, and October 1. 41 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 3.280.000 Certificates of Participation (Twit Lakes Proiect) Series 1994A Year Ending Interest Principal Interest June 30 Rate Due Due Total 1998 4.800%$ 240,000 $ 170,155 $ 410,155 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 2002 5.200 275,000 119,475 394,475 2003 5.350 280,000 104,835 384,835 2004 5.450 290,000 89,443 379,443 2005 5.550 300,000 73,215 373,215 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 280 000 1 101 503$4,381,503 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 (1) 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. The bond 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 sena- annually on April 1 and October 1. 42 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 2,665,000 Certificates of Participation (Capital Improvements Projects) Series 1997A Year Ending Interest Principal Interest June 30 Rate Due Due Total 1998 4.625% $ 230,000 $ 107,391 $ 337,391 1999 4.625 230,000 118,231 348,231 2000 4.625 245,000 107,594 352,594 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 2004 4.900 285,000 57,715 342,715 " 2005 5.000 490,000 43,750 533,750 2006 5.000 50,000 19,250 69,2.50 2007 5.000 335.000 16,750 351.750 2 665 000 722 283 $ 3,387,283 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 National Bank (the "Trustee`). The purpose of the 1997A Series certificates is to (1) pay the costs of completing the construction, famishing and equipping of a convention and recreational facility that constituted part of the 1993 project, (2) pay the costs of acquiring, constructing, famishing 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 1. 43 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 765.000 Certificates of Participation (Capital Improvements Projects), Series 19976 Year Ending Interest Principal Interest Jane 30 Rate Due Due Total 1998 4.700% $ 75,000 $ 31,100 $ 106,100 1999 4.700 75,000 33,795 108,795 200) 4.700 80,000 30,270 110,270 2001 4.800 80,000 26,510 106,510 2002 4.900 80,000 22,670 102,670 2003 5.000 85,000 18,750 103,750 204 5.000 85,000 14,500 99,500 2005 5.000 205.000 10,250 215.250 $765,000 L2L2 845 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 front the City to Union Planters National Bank (the "Trustee"). The purpose of the 19978 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 19908, 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 I and October 1. 44 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 -� NOTE E - LONG-TERM OBLIGATIONS - Continued The annual requirements to amortize all debt outstanding as of June 30, 1997 including total 45 interest payments of $36,449,240 are as follows: General Leasehold Certificates Year Ending Obligation Revenue Revenue of June 30 Bonds Bonds Bonds Participation Total 1998 $ 467,738 $ 2,163,768 $ 2,703,800 $ 1,224,379 $ 6,559,685 1999 468,806 2,199,857 2,685,935 1,267,149 6,621,747 2000 463,488 2,251,720 3,161,485 1,294,137 7,170,830 2001 461,805 3,472,298 823,225 1,317,175 6,074,503 2002 463,555 4,128,743 806,500 1,355,883 6,754,681 2003 458,875 4,218,827 473,200 1,374,363 6,525,265 2004 458,125 4,331,727 218,250 1,393,496 6,401,598 2005 461,250 4,441,702 504,000 1,837,915 7,244,867 2006 - 4,583,584 - 435,382 5,018,966 2007 - 4,629,605 - 981,875 5,611,480 2008 - 4,789,568 - 80,845 4,870,413 2009 - 4,896,663 - 76,768 4,973,431 2010 - 4,498,901 - 82,360 4,581,261 2011 - 3,807,051 - - 3,807,051 2012 - 4,890,522 - - 4,890,522 2013 - 2,442,930 - - 2,442,930 2014 - 2,398,068 - - 2,398,068 2015 - 2,186,234 - - 2,186,234 2016 - 2,099,775 - - 2,099,775 2017 - 2,061,970 - - 2,061,970 2018 - 1,057,690 - - 1,057,690 2019 L021,935 1.021,935 3,703,642 $ 72.573.138 $ 11.376.395 $ 12.721,727 $100,374.902 .. The cash available to service Revenue Bonds are $1,072,284 and $1,248,502 for the Sewer Fund and Water Fund respectively. 45 City of Cape Girardeau, Missouri NOTES TO FINANCIAL S'rATEMENTS June 30, 1997 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 $301,007 and $2,156,683 respectively. The cash available to service the Certificates of Participation in the Proprietary Funds and the General Long-term Debt Account Group are $419,627 and $469,896 respectively. Included in restricted cash on the balance sheet of the Proprietary Funds is $22,874,615 which is the balance in the various project accounts which represent incomplete projects at June 30, 1997. If the project funds are not used, the remaining balance can be applied against debt. The City is in compliance with all significant limitations and restrictions contained in the various bond indentures. During the fiscal year ended lune 30, 1996, the City defeased (in -substance) $8,090,000 of Water Revenue Bonds. New debt was issued and the proceeds have been used to purchase U.S. government securities that were placed ht trust funds. The investments and fixed eamings from the investments are sufficient to fully service the defeased debt moil the debt is called or matures. For financial reporting purposes, the debt has been considered defeased and therefore removed as a liability on the face of the balance sheets. As of June 30, 1997, defeased debt still outstanding consisted of $8,090,000 in the Enterprise Funds. 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. As of June 30, 1997, defeased debt still outstanding consisted of $755,000 in the General Long-term Debt Account Group (GLTDAG). Pursuant to GAAP, defeased debt is not shown on the face of the balance sheets. 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, 1997. 46 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE G - DEFICIT FUND BALANCES/RETAINED EARNINGS The following individual funds have deficit fund balances/retained earnings at June 30, 1997. Enterprise Funds Solid Waste Fund $ 717,753 Softball Complex Fund 143,976 Capital Projects Funds Water Projects 292,680 NOTE H - PENSION PLAN 1. Plan Description The City of Cape Girardeau participates to the Missouri Local Government Employees Retirement System (LAGERS), an agent multiplecmployer public employee retirement system that acts as a common investment and administrative agent for local government 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 401A and it is tax exempt. The Missouri Local Government Employees Retirement System issues a publicly available financial report that includes financial statements and 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. Fundine Policy The City of Cape Girardeau's full-time employees do not contribute to die pension plan. The political subdivision is required by state statute to contribute at an actuarially determined rate; the current rate is 7.9% (general), 7.0% (police) and 13.9% (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. 47 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 a NOTE H - PENSION PLAN - Continued 3. Annual Pension Cost For 1997, the political subdivision's annual pension cost of $753,807 was equal to the required and actual contributions. The required contribution was determined as part of the February 28, 1995 and/or 1996 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 martially, attributable to inflation, (c) additional projected salary increases ranging from 0.0% to 4.0% per year, depending on age, attributable to seniority/merit, and (d) pre -arid post-retirement mortality based on die 1984 Group Annuity Mortality table set back no years for men and 6 years for women. The actuarial value of assets was detemnined 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 a closed basis. The amortization period at February 28, 1997 was 16 years. Tluee-Year Trend Information Fiscal Animal Percentage Net Year Pension of APC Pension Ending Cost (APC) Contributed Obligation 06/30/95 693,627 100% 0 06/30/96 779,824 100% 0 06/30/97 753,807 100% 0 M City of Cape Girardeau, Missouri NOTES TO FINANCIAL. STATEMENTS June 30, 1997 NOTE H - PENSION PLAN - Continued 3. Annual Pension Cost - Continued Required Supplementary Information Schedule of Funding Proeress 49 (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 Liability (UAL) Ratio Payroll Payroll 02/28/95 11,437,061 12,415,102 978,041 92% 7,646,328 13% 02/29/96 11,745,277 13,096,931 1,351,654 90% 8,010,696 17% 02/28/97 13,511,019 14,466,970 955,951 93% 8,725,334 11% Note: The above assets and actuarial accrued liability do not include the assets and present value of benefits associated with tine Benefit Reserve Fund and the Casualty Reserve Fund. The actuarial assumptions were changed in conjunction with die February 29, 1996 annual actuarial a valuations. The City has chosen early implementation of GASB 27 (Accounting for Pensions by State and Local Governmental Employers.) The disclosures in this note are in accordance with that Statement. NOTEI- INTEREST EXPENSE r Interest cost, including handling charges, totaling $3,404,825, excluding $193,925 of interfund interest, was incurred during the year ended June 30, 1997. No interest cost was capitalized as part of the cost of assets constructed during the period. 49 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMEN,rS June 30, 1997 NOTE J - INTERFUND RECEIVABLES AND PAYABLES — The following is a summary of interfund balances as of June 30, 1997: Due to/from other funds: Due to Due from General Fund $ 1,025,570 $ - General Capital Improvement Fund - 170,297 — FAU Street Grants Fund - 138,986 CDBG Fund - 43,607 Water Projects Fund - 143,434 — Sewer Fund 529.246 1 025 570 1 025 570 — Advance to/from other funds: w Advances from Advances to General Fund $ 1,867,500 $ - — Sewer Fund - 337,500 Solid Waste Fund - 950,000 Golf Course Fund - 390,000 — Softball Complex Fund - 190.000 $ L807 000 NOTE K - DEFERRED COMPENSATION PLAN The City offers its employees a deferred compensation plan created in accordance with Internal Revenue Code Section 457. The plan, available to all City employees, permits them to defer a portion of their salary until future years. Participation in the plan is optional. The deferred compensation is not available to employees until termination, retirement, death, or unforeseeable emergency. All plan assets including all anounts of compensation deferred under the plan, all property and rights purchased with those amounts, and all income attributable to those amounts, property or rights are (mail paid or made available to the employee or other beneficiary) solely the property and rights of the City subject only to the claims of the City's general creditors. Participants rights under the plan are equal to those of general creditors of the City in arr amount equal to the fair market value of the deferred account for each participant. 50 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE K - DEFERRED COMPENSATION PLAN - Continued The City has no liability for losses under the plan but does have the duty of due care that would be required of an ordinary prudent investor. The City believes that it is unlikely that it will use the assets to Satisfy the claims of general creditors in the future - City of Cape Girardeau, Missouri 51 NOTE L - SEGMENT INFORMATION FOR ENTERPRISE FUNDS The City maintains five enterprise funds which provide sewer, water, solid waste, golf, and softball complex services. Segment infomlatioll for the year ended June 30, 1997 was as follows: Softball Sewer Water Solid Waste Golf Comse Complex Total Fwd Fund Fund Fund Fond Entemdse Operating Revenues $ 2,423,120 $ 4,011,943 $ 2,227,158 $ 483,446 $ 58,448 $ 9,204,115 Depreciation 795,561 391,306 221,726 57,328 7,000 1,472,921 r Operating Grans (183) - 12,358 - - 12,175 Operating Income (Loss) 437,298 882,210 59,337 24,897 (177,547) 1,226,195 Operating transfers in - - - 10,000 207,100 217,100 Net Income (toss) 78,824 253,969 22,991 18,827 18,955 393,566 Current Capital Contributions 826,066 746,020 - 645 3,126 1,575,857 Property, Plant and Equipment Additions 4,946,478 1,167,794 223,910 93,270 12,433 6,443,885 Deletions - - (59,516) (52,880) - (112,396) Net Working Capital 23,481,886 2,826,250 (173,820) (346,895) (188,602) 25,598,819 r Total Assets 53,407,329 15,578,954 2,022,910 424,850 84,006 71,518,049 Bonds and Other Long - Tenn Liabilities Payable from operating revenue 33,914,821 12,301,405 806,726 - - 47,022,952 Total Equity $ 17,540,256 $ 2,434,230 $ (717,753) $ 4,929 $ (143,976) $ 19,117,686 51 52 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 r NOTE M - RESERVATION OF FUND EQUITY At June 30, 1997, the City had reserved its fund equity as follows: General Fund Reserved for prepaid items $ 55,270 Reserved for advances 1,867,500 Reserved for mausoleum maintenance 60,022 Reserved for police projects 45,679 Reserved for encumbrances 69,313 12,0 97,784 Special Revenue Funds Convention/Visitom Fund Reserved for encumbrances $ 1,972 Airport Fund Reserved for prepaid items 9,589 ` Reserved for encumbrances 1,590 Parks and Recreation Fund Reserved for prepaid items 536 Reserved for encumbrances 6,933 Transportation Sales Tax Trust Fund Reserved for encumbrances 255 642 _ 276 262 Debt Service Fund Reserved for debt service 3 521 034 ` Capital Projects Funds General Capital Improvement Fund Reserved for debt service 219 Reserved for bond capital expenditures 6,776 Reserved for encumbrances 20,762 Corps Flood Control Fund Reserved for encumbrances 56,370 FAU Street Grants Fund Reserved for encumbrances 24,665 Community Development Block Gram Fund Reserved for economic development loan repayments 77,268 Reserved for encumbrances 22,116 Park Improvements Fund Reserved for encumbrance 12,767 Water Projects Fund Reserved for encumbrance 1,676,777 1 897 720 52 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE N - RESERVED RETAINED EARNINGS AND RESTRICTED ASSET ACCOUNTS As of lune 30, 1997, the reserved portion of retained earnings for the Sewer Fund is as follows: Reserved for debt service $30,000 Total reserved retained earnings 30 000 At June 30, 1997, the City has restricted assets in its Proprietary Funds as follows: Revenue Bond Bond Sinking mud Construction Reserve Fund Sewer Fund $ 21,235,956 Water Fund 832,964 Solid Waste Fund 819 Data Processing Fund 423,178 Equipment Replacement Fund 363.365 $ 2,296,715 1,307,885 95,667 115 Total $ 23,532,671 2,140,849 96,486 423,293 119 363.484 22.856.282 3 700 501 26 556 783 NOTE O - LANDFILL CLOSURE AND POSTCLOSURE CARE COST State and federal laws 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, mud an expense provision and related liability were recognized at that time based on the future closure and postclosure care costs that were estimated to be 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 $822,960 as of June 30, 1997, 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, 1997. 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 Girardeau, Missouri NOTES TO FINANCIAL S'T'ATEMENTS June 30, 1997 NOTE P - RISK MANAGEMENT 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. Tthese 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 years and has used them to offset the cost of the succeeding year's premiums. The City 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. W 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 armually 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 hie. Under thus 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 M City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE P - RISK MANAGEMENT - Continued Claims liability is estimated using data supplied by the administrator. The claims activity during the last three years is summarized as follows: NOTE Q - CONCENTRATION OF CREDIT RISK/BAD DEBT ALLOWANCE The City has uncollateralized utility accounts receivable generated within a limited geographical region primarily consisting of its city limits. The 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, 1997, utility receivables totaled $1,677,386. On the financial statements, the utility receivables are shown net of the allowance for doubtful accounts of $651,730. This results in net utility receivable of $1,025,656. 55 CLAIMS LIABILITIES RECONCILIATION Health Workers' Insurance Compensation Total Balance, July 1, 1994 $ 145,787 $ 78,222 $ 224,009 Provision for Incurred Claims 720,646 268,985 989,631 Payments of Claims671 7.714119( 1.682) (869,396) Balance, July 1, 1995 $ 188,719 $ 155,525 $ 344,244 Provision for Incurred Claims 761,641 176,055 937,696 Payments of Claims74( 2.234)14( 0"160)881 2.394) Balance, July 1, 1996 $ 208,126 $ 191,420 $ 399,546 Provision for Incurred Claims 647,134 173,081 820,215 Payment of Claims72( 0.066)201 7.562) 92( 7.628) Balance June 30, 1997 135,194 LN2 133 NOTE Q - CONCENTRATION OF CREDIT RISK/BAD DEBT ALLOWANCE The City has uncollateralized utility accounts receivable generated within a limited geographical region primarily consisting of its city limits. The 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, 1997, utility receivables totaled $1,677,386. On the financial statements, the utility receivables are shown net of the allowance for doubtful accounts of $651,730. This results in net utility receivable of $1,025,656. 55 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE R - COMMITMENTS AND CONTINGENCIES 1. Litieation Various claims and lawsuits are pending against the City. In the opinion of City management, the 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 Grants for specific purposes that are subject to review and audit by various Federal and State agencies. 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, 1997, the City had construction commitments outstanding of $1,292,666. 4. Encumbrances As of June 30, 1997, the City had encumbrances outstanding of $3,989,292. NOTE S - CONTRIBUTED CAPITAL 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 1, 1996 $ 15,913,834 S 1,192,526 $ 288,585 - - $ 17,394,945 Contributing Sources: Donated assets by developers 432,010 260,548 - - - 692,558 Connexion fees 138,520 - - - - 138,520 State grants 255,536 485,472 - - - 741,008 Transfer of assets from GFAAG - - - 645 3.126 3.771 Ending Balance, Jane 30, 1997 16739900 1938546 2RR SRS 645 3126 18,970,802 M. City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1997 NOTE T - EXCESS OF EXPENDITURES/EXPENSES OVER APPROPRIATIONS For the year ended June 30, 1997 expenditures/expenses exceeded appropriations in the individual funds as follows: NOTE U - PRIOR PERIOD ADJUSTMENTS Beginning fund balances were reduced $30,945 and $19,000 in the general and solid waste funds respectively. The general fund reduction resulted from an adjustment to other receivables for receipts that had been received in previous years and counted as revenue in error. This caused revenue to be overstated by $9,440, $3,145, and $18,360 respectively in fiscal years ending June 30, 1994, 1995, and 1996, respectively. The solid waste fund reduction resulted from accrued revenue recognized in the fiscal year ending June 30, 1995 being recognized as revenue again bi the fiscal year ending June 30, 1996 resulting in an overstatement of revenue for that period. The accrued revenue was removed from the solid waste fund's assets this year. 57 Budget Actual Variance Airport Special Revenue $ 509,363 $ 515,027 $ 5,664 _ General Capital Improvement Fund 397,000 404,491 7,491 Debt Service Fund 3,100,573 3,763,857 663,284 Employees' Fringe Benefit Fund 1,057,047 1,342,857 285,810 NOTE U - PRIOR PERIOD ADJUSTMENTS Beginning fund balances were reduced $30,945 and $19,000 in the general and solid waste funds respectively. The general fund reduction resulted from an adjustment to other receivables for receipts that had been received in previous years and counted as revenue in error. This caused revenue to be overstated by $9,440, $3,145, and $18,360 respectively in fiscal years ending June 30, 1994, 1995, and 1996, respectively. The solid waste fund reduction resulted from accrued revenue recognized in the fiscal year ending June 30, 1995 being recognized as revenue again bi the fiscal year ending June 30, 1996 resulting in an overstatement of revenue for that period. The accrued revenue was removed from the solid waste fund's assets this year. 57 COMBINING AND INDIVIDUAL FUND FINANCIAL STATEMENTS City of Cape Girardeau, Missouri GENERALFUND COMPARATIVE BALANCE SHEET JUNE 30, 1997 AND 1996 1997 59 1996 $2,276,027 $1,886,811 38,982 ASSETS 737,308 Cash and cash equivalents 1,019,659 Receivables, net of allowances for 52,450 doubtful receivables 215,790 Real estate, personal property 51,169 and merchant taxes 324,644 Sales tax 1,025,570 Franchise tax 1,867,500 Special assessments receivable 627 Interest receivable 55,270 Other receivables Intergovernmental receivables Grants receivable Due from otherfunds Advances to other funds Inventories Prepaid Items Total assets LIABILITIES AND FUND BALANCES Accounts payable Accrued liabilities Salaries, payroll taxes and benefits Other liabilities Due to other governments Deferred revenue Total liabili0es Fund Balances Reserved for prepaid items Reserved for advances Reserved for mausoleum maintenance Reserved for police projects Reserved for encumbrances .. Unreserved Total fund balances Total liabilities and fund balances 59 1996 $2,276,027 $1,886,811 38,982 40,978 737,308 565,962 1,019,659 1,073,061 52,450 45,840 215,790 153,002 51,169 148,571 324,644 261,733 1,025,570 1,743,249 1,867,500 1,752,500 627 90 55,270 57,043 $7,664,996 $7,728,840 $246,221 $293,456 263,520 286,112 129,281 140,672 20 — 1,618,673 1,519,471 2,257,715 2,239,711 55,270 57,043 1,867,500 1,752,500 60,022 56,441 45,679 42,407 69,313 132,507 3,309,497 3,448,231 5,407,281 5,489,129 $7,664,996 $7,728,840 60 at, d cape Ohrdmu, Mivaud GENERAL FUND I:CHEDUIE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30,1 UNIT VARIANCE FAVORADLE BUDGET ACTUAL (UNFAVORABLE) REVENUES T. $10,538¢25 $10203793 (§335.032) UcereeeandpamlN 911850 804,887 (28,983) Irta9p+eanan§I 338,375 1,M2,813 1,388,438 CFergee b amicae 312,835 238,824 (13,611) NtadeperV1a191 eaNcee 495,000 4W.54S (35.452) Fnee end rode¢aee 640.Om 558.759 18.758 Witee aaa 93.000 1W.93S 47.838 Interest 241¢25 2332118 (8,337) Special mmls 1000 ].121 8.121 TOTAL REVENUES 13.437.110 14.414.473 9D.=l EXPENDITURES Crrtad Aknlniratheeavkw Cllr ceamcS 28,121 19,825 9,498 Humenleeavicee 180,583 19,818 15,085 Chy m1a(Nr 181,499 175,419 8580 PW9aeWeneee S5,m7 47.133 ]9]4 C¢yaeavay 18].310 1 W.3]0 18.940 Finance 314,988 3S,S39 15,147 IMadepaMarYl 439,933 3 .Il8 54,815 ea TaW admlde¢a9ry eaK. Daebwatma 1?88539 1281.122 125.417 eavicea RanNnp eav 238295 222.7W 13.587 Inapectkn aavka 285.801 299.809 (3929) En91n®dn9 eervkm 49.(X9 433.582 (38,493) cammunryend econommeewlopmem 9109 48,41( 31, 9 WHk renep>tetlal 39.810 2W,549 21.201 Toteld.lapmenleavlcnt 1la� �[. IT Perkeandre ea5an Palk maintenance 767.791 ]45' l 22579 Cenetay 118.614 113,40.5 3.1W Fadldyrraiderance 10).]61 128152 3W3 Tdalpa.keandeeamtlon 1PI4.1W 884 Bm 29.358 PoNk®Idy NundpalcM 2m.J 190.518 12780 Police 3950,754 3942714 19,040 FLe 2.752.349 2.858.106 90.104 TaNlplblketlet, 8912.405 9895.33 217,010 PWlkwada 36ee1 1.448,9W 1228291 121,881 r Slamwaler 2W,3011 Zm,4W 11,815 TclalpWll, Bake 1700292 1,589.]81 133,478 Ccrldmmw l.Bm Om 1.833.830 (allm) Debt Service Idaatand fle®1 cl r,a 1W - lm Trial debt t avbe 19 lm TOTAL EXPENDITURES 13,W.538 13,41t,W9 502.548 + EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (m],4291 9R,4o4 1.479812 OTHER FINANCING SOURCES (U ES) Opaetn99alelae In 818,735 010,735 - Cbae4n9bandaeal (1889,35/) 11908236) 83.121 Pr dkk.Tuedeaaeta loom _ 2]39 1]3(0 TOTAL OTHER FINANCING SOURCES (USES) (1,0(-0,822) (9m.19) 103,429 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES (St,'AO,Om) $12,291 E15m xl 60 Cb/ d C . G"Weeu, M®vl 9£aALH Nl1E FMCS MO MNG S/JJi19CE SWU Jac W. 1987 (WN CorryartlNe Tp fQ Fanw iggm Cybi C'm Cmrlbnn Irrprpabarl IIIQ.numm CDmerNdJ Butrm Page arb Mpttt S Ta S T. TragsONrMI Fb YYbn j9yle WXwe M,,d otmtt Bac�n f ooM f19g1Q Fkvl mmn MW Pr .mel a Tm H>Qff.IWe_ LA 1-9-P! A=M--K ASSEI9 Caenamce quNebme 5310524 W= 51550 $114,788 E265.f@ $611,1P 91,539314 $lmml $3413.142 91867 $131 $.508,]59 52,181,91 Rowftlme McIbW9Rffilof OamJeetemmlea Nebeatp= - - 0.312 - 5.19] _ _ _ _ _ _ 9,820 1,036 P.Hob Dro=M _ _ _ _ 1,316 _ _ _ _ _ _ 1316 1056 - e Hobeuremt l.r 29951 - - - - - - - _ - - 29!351 3 I.le mta[rO=aNeEla 4417 4417 0.5146 M=1i Motor Nellax - - - - - 661187 - - - - - 66187 .I" 6575 MORrva6tl.Itemalem - - - - - 12,189 - - - - - 1219 1589 19815 1792 Dlfna..l Ies - 19810 - 222 1 - - - - - - 19813 17,110 Sal®Iv 161')11 174261 3$3826 - - 722311 422935 Im...vebee - - - - - 1096 23224 - - - - 39821 32915 Omms.e w 13680 - - - - - - - _ _ - 13480 12971 I.M.. 19749 - - - - - - - - - - 19]49 19219 PrepaM%e s - 9599 - 538 - - - - - - - 10125 11,161 Due h m abler lama P' T.massels 5097670 �.)ed69z >� 4� 11s56d 115 799 2�` � $2746749 ) 155 53.7696B Sage] 131 1192 )fi61 UMIUMES AND MNDSA WES M UmspaY.51e S1t P4 50.3998 $ - 566813 53113 $ - $ - 9 - $60125 S - S- 5296483 $153021 A« w uaoomee 6alan.apaymil=x am bents 2865 11221 - 42N9 t9i8 - - - _ - - 5871 49d W. na5nmw _ 9 _ We Oefened rererua - MM7 4_3x2 - 5,49 - 361,71 12535 427116 91514 T.billa0ll6lee 14063]89]6 0.342 110,111 11,191 - 361,511 91,Kq �3-Z 94 ®] F.M b.l. C. Reaer trpr®a0 nems - 9.599 - 536 - - - - - - 1045 11'61 Rear br ercvROmrces 1.912 1.90 - 893 - - - - 255612 - - 266,131 512,95 U6rasenm 061.155 8.� 1_30 (2.857 200.392 759,®8 2355.178 275,155 3.428,$7 4691 131 1,551633 349,115 Tobi Nrb b.l . 93427 17,7W 1_59 5x39 20o,3II 'm 2.35,118 2]5.155 3.664,306 4697 131 7,631895 4®3061 TmailbllMa aral NN bauuee• 916N 7" SSB92 sllw 11556 199696 V 716]49 $M,IW T78961 NW] 131 1192 SOM7881 I 1 I i 1 1 1 1 / i 1 1 1 I 1 1 1 1 1 BPEdK REVENUE RON. CONENI" VNEVMENT OF REVENUES, E)U`MDF URM AND C"AM"S IN FUND BALANCE FM THE F®CAE YEM ENDED NNE M IM CAPITAL GPRK DOWNTOWN YPRQVe.GNT YPROVEMENT TRANSPORTATION CIXNENTM/ BUSINESS PAWS AND MOTOR SALES TAX 6 mTNt SALES FLOOD V61ON TOTALS VETOES AIRPORT MSTRCT FEOREATION HEALTH FU& TAX (FLONCONERM) MATFRPROIE[TBI TAF PROTECTION 'dLV 1®6 -tee) REVENUES Taw Mo. e- e15JN F- lmmA s- el,Slp,tO] &VAMEjLRe'S i- 1- *E ]:IIS Inbecwnmentl 132.40 - - ASEE 1.113 'A 1=01 Caerpw beeMue 1.. 5A4 - 2W.Sa y11 xl MbCNhnewe 3211 t®.M6 e$ID - ].03 11],5)1 Inblwl y,32vol - Wit! 2.'.il 148]3 145Te tI1,M2 q1 1IJ% 2R1 Ip ]e1,0. TOTAL REVENUES AD1326 1t4,en t!]n 21,4'] 1A2M I.J$.5]I 191f,BY 2A.tn 3X4200 251 J.la eJ .M EXPENDITURES C.—I AaminbTMeewNcee ]10]11 ID,O'Q ""T1s CwNPomertt esrkee - _ 1!$15 p USE, PVM enJ leelmlw+ amRM Pualk eJM N.Da _ _ N,bt3 Pualk wolke y!,]n Py= Daaleem, PIIndPI - 12227 InMeN ena Mulcavp Ipl9 � � � � _ _ N TOTAL EXPENDTURE9 ]1R]11 !1�Sl] 1 1! l—'SE2 R]n - An _ ].Ilp 2SIo`Tp EXCESS(DEFICIENCY OF REVENUES C M IUNOEA) RPENDIT I0E,_115 (—w !O IWUH, 1 ]11 1111YN1 M1n 21416TA l�I.BJ CTHERFINANCINO SOURCES(USES) olN�ea�e r.11mNu - macro - em,000 _ _ _ - I.=- - tM"M Dpenene reneron wl (5.1�Y� _ _ _ OlwW ipn 11.448 TOTAL OTHER FINANCING SOURCES (USES) �I ., axI M),WI - SEE ("XRT] ISM= I=,155 EXCESS(OEFIDENCY) OF REVENUES ANDOTHERFINANCINO SOURCES W ER (UNDER) EXPENDITURES AND OTHERFINANDNO USES M311 b Sp 5,10 M7. ..]ll 1)5,110 MEE 2.ST.YA 2m (2SB 3,1%," FUMD BLLMCES,J4Y 1 sl).112 5]x25 1,CN (2,TJZI I]],M] IW,IM I.ME7! - 1,la.SY .,.w .fe .,maw PRIOR FERN Ao11sTNENT NNO RLLANCES. JUNE M X4TA27 $I�IM $I Ins.y f9J Np s�,BM aw'?l W5"w aM1`20 PONT 1131 5)�w)N! City of Cape Girardeau, Missouri CONVENTION/VISITORS SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES — BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1997 BUDGET 63 ACTUAL $870,488 13,480 4,892 311 34,658 923,829 316,996 316,996 606,833 (541,800) (541,800) $65,033 VARIANCE FAVORABLE (UNFAVORABLE) ($39,512) 13,480 (3,108) 311 29,658 829 242,005 242,005 242,834 $242,834 REVENUES T"es $910,000 Intergovernmental — Charges for services 8,000 Miscellaneous — Interest 5,000 r TOTAL REVENUES 923,000 EXPENDITURES Current Administrative services 559,001 TOTAL EXPENDITURES 559,001 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 363,999 OTHER FINANCING SOURCES (USES) Operating transfers out (541,800) TOTAL OTHER FINANCING SOURCES (USES) (541,800) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($177,801) 63 ACTUAL $870,488 13,480 4,892 311 34,658 923,829 316,996 316,996 606,833 (541,800) (541,800) $65,033 VARIANCE FAVORABLE (UNFAVORABLE) ($39,512) 13,480 (3,108) 311 29,658 829 242,005 242,005 242,834 $242,834 64 City of Cape Girardeau, Missouri AIRPORT SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES — "" BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1997 VARIANCE FAVORABLE r BUDGET ACTUAL (UNFAVORABLE) REVENUES Intergovernmental $77,000 $ — ($77,000) Charges for services 4,800 5,832 1,032 Miscellaneous 99,620 109,045 9,425 TOTAL REVENUES 181,420 114,877 (66,543) EXPENDITURES Current Administrative services 509,363 501,512 7,851 Debt Service o Principal — 12,297 (12,297) Interest and fiscal charges 1,218 (1,218) TOTAL EXPENDITURES 509,363 515,027 (5,664) EXCESS (DEFICIENCY) OF REVENUES �. OVER (UNDER) EXPENDITURES (327,943) (400,150) (72,207) OTHER FINANCING SOURCES (USES) Operating transfers In 328,000 353,000 25,000 TOTAL OTHER FINANCING SOURCES (USES) 328,000 353,000 25,000 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES $57 ($47150) ($472071 64 City of Cape Girardeau, Missouri DOWNTOWN BUSINESS DISTRICT SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES — r BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1997 VARIANCE FAVORABLE ACTUAL (UNFAVORABLE) $15,244 ($1,656) BUDGET (85) 15,759 REVENUES 15,216 104 Taxes $16,900 Interest 600 TOTAL REVENUES 17,500 EXPENDITURES Current Development services 15,320 TOTAL EXPENDITURES 15,320 _ EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES $2,180 65 VARIANCE FAVORABLE ACTUAL (UNFAVORABLE) $15,244 ($1,656) 515 (85) 15,759 (1,741) 15,216 104 15.216 104 $543 ($1637) r City of Cape Girardeau, Missouri PARKS AND RECREATION SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES — BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1997 BUDGET ACTUAL $290,827 5,233 2,393 298,453 874,937 (576,484) 605,000 605,000 VARIANCE FAVORABLE (UNFAVORABLE) ($18,173) 5,233 2,393 (10,547) 96,159 96,159 85,612 (45,000) (45,000) $28,516 $40,612 REVENUES 66 Charges for services $309,000 Miscellaneous — Interest TOTAL REVENUES 309,000 EXPENDITURES Current Parks and recreation 971,096 Debt service Interest and fiscal charges TOTAL EXPENDITURES 971,096 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (662096) OTHER FINANCING SOURCES (USES) Operating transfers in 650,000 TOTAL OTHER FINANCING SOURCES (USES) 650,000 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES r OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($12096) $290,827 5,233 2,393 298,453 874,937 (576,484) 605,000 605,000 VARIANCE FAVORABLE (UNFAVORABLE) ($18,173) 5,233 2,393 (10,547) 96,159 96,159 85,612 (45,000) (45,000) $28,516 $40,612 66 $290,827 5,233 2,393 298,453 874,937 (576,484) 605,000 605,000 VARIANCE FAVORABLE (UNFAVORABLE) ($18,173) 5,233 2,393 (10,547) 96,159 96,159 85,612 (45,000) (45,000) $28,516 $40,612 City of Cape Girardeau, Missouri HEALTH SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES — BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1997 BUDGET ACTUAL 67 $163,860 4,602 10,802 179,264 142,277 142,277 36,987 (11,907) (11,907) $25,080 VARIANCE FAVORABLE (UNFAVORABLE) ($11,615) (98) 3.052 (8,661) 27,113 250 27,363 18,702 (387) (387) REVENUES Taxes $175,475 Intergovernmental 4,700 Interest 7,750 TOTAL REVENUES 187,925 EXPENDITURES Current Public safety 169,390 Debt Service Interest and fiscal charges 250 TOTAL EXPENDITURES — 169,640 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 18,285 r OTHER FINANCING SOURCES (USES) Operating transfers out (11,520) r" TOTAL OTHER FINANCING SOURCES (USES) (11,520) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES $6,765 67 $163,860 4,602 10,802 179,264 142,277 142,277 36,987 (11,907) (11,907) $25,080 VARIANCE FAVORABLE (UNFAVORABLE) ($11,615) (98) 3.052 (8,661) 27,113 250 27,363 18,702 (387) (387) City of Cape Girardeau, Missouri MOTOR FUEL TAX SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES — BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1997 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) 68 REVENUES Intergovernmental $1,295,000 $1,313,999 $18,999 Interest 5,000 48,678 43,678 TOTAL REVENUES 1,300,000 1,362,677 62,677 EXPENDITURES Current Public works 10,000 15,391 (5,391) Debt Service Interest an d fiscal charges TOTAL EXPENDITURES 10,000 15,391 (5,391) EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 1,290,000 1,347,286 57,286 - OTHER FINANCING SOURCES (USES) Operating transfers out (895,000) (885,000) 10,000 TOTAL OTHER FINANCING SOURCES (USES) (895,000) (885,000) 10,000 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES r OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES $395,000 $462,286 $67,286 68 69 City of Cape Girardeau, Missouri CAPITAL IMPROVEMENT SALES TAX SPECIAL REVENUE FUND FLOOD CONTROL PROJECTS SCHEDULE OF REVENUES AND EXPENDITURES — BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1997 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) REVENUES Tates $1,750,000 $1,670,107 ($79,893) Miscellaneous — — — Interest 103,500 141,882 38,382 TOTAL REVENUES 1,853,500 1,811,989 (41,511) EXPENDITURES Current Public works 102,400 — 102,400 Debt Service Interest and fiscal charges TOTAL EXPENDITURES 102,400 102,400 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 1,751,100 1,811,989 60,889 OTHER FINANCING SOURCES (USES) O peratin g transfers out (1,937,400) (1,333,486) 603,914 TOTAL OTHER FINANCING SOURCES (USES) (1,937,400) (1,333,486) 603,914 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($1863001 $478 503 $664,803 69 City of Cape Girardeau, Missouri 70 CAPITAL IMPROVEMENT SALES TAX SPECIAL REVENUE FUND WATER PROJECTS SCHEDULE OF REVENUES AND EXPENDITURES — BUDGET ANO ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1997 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) REVENUES _ Capital Improvements $ — $274,676 $274,676 Interest 477 477 TOTAL REVENUES 275,155 275,155 EXPENDITURES Public works r TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES $0 $275.155 $275,155 70 City of Cape Girardeau, Missouri TRANSPORTATION SALES TAX TRUST SPECIAL REVENUE FUND _ SCHEDULE OF REVENUES AND EXPENDITURES — BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1997 VARIANCE FAVORABLE ACTUAL (UNFAVORABLE) $3,232,939 ($267,061) BUDGET 141,359 3,374,298 REVENUES 770,782 3,572,818 Taxes $3,500,000 2,603,516 Interest 140,000 (10,000) 140,000 (10,000) TOTAL REVENUES 3,500,000 EXPENDITURES Current Public works 4,343,600 TOTAL EXPENDITURES 4,343,600 EXCESS (DEFICIENCY) OF REVENUES �. OVER (UNDER) EXPENDITURES (843,600) OTHER FINANCING SOURCES (USES) Operating transfers In 150,000 TOTAL OTHER FINANCING SOURCES (USES) 150,000 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES 693600 71 VARIANCE FAVORABLE ACTUAL (UNFAVORABLE) $3,232,939 ($267,061) 141,359 141,359 3,374,298 (125,702) 770,782 3,572,818 770,782 3,572,818 2,603,516 3,447,116 140,000 (10,000) 140,000 (10,000) 2743516_ $3437116 r City of Cape Girardeau, Missoud FLOOD PROTECTION SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES — BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 70, 1997 BUDGET r REVENUES �. interest S TOTAL REVENUES EXPENDITURES Current AdminlstreWe wNicas TOTAL EXPENDITURES .. EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES £ — r 72 VARIANCE FAVORABLE ACTUAL (UNFAVORABLE)_ $280 $280 2� 280 __280 5280 City or Cape Girardeau, Missouri VISION 2000 SPECIAL REVENUE FUND r SCHEDULE OF REVENUES AND EXPENDITURES — BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1997 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) REVENUES Miscellaneous $4,825 $3,082 ($1,743) Interest 40 40 TOTAL REVENUES 4,825 3,122 (1,703) EXPENDITURES Current Development services 5,000 3,410 1,590 r TOTAL EXPENDITURES 5,000 3,410 1,590 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES ($175) ($288) ($113) r 73 + + City of Cape Girardeau, Missouri DEBT SERVICE FUND COMPARATIVE BALANCE SHEET JUNE 30, 1997 AND 1996 + 1997 + ASSETS + Cash and cash equivalents $1,425,737 Investments 2,060,523 Receivables, net of allowances for doubtful receivables + Real estate, personal property and merchant fazes 12,071 Special assessments receivable 712,644 Interest receivable 28,827 Total assets $4,239,802 LIABILITIES AND FUND BALANCES Accounts payable $2,167 Interest payable 285 Due to other funds — Deferred revenue 716,316 Total liabilities 718,768 Fund Balances + Reserved for debt service 3,521,034 Total fund balances 3,521,034 Total liabilities and fund balances $4,239,802 74 1996 $824,740 2,137,084 12,863 662,534 30.193 —$3 667 414 34,914 673,006 707,920 2,959,494 2,959,494 $3,667,414 I i 1 1 1 1 i 1 1 I I I 1 I I I 1 I 1 City of Cape GYardeau. Mineud CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET June W. 1807 (YARN CarnparSSre Ta61s for June 30, 1885) General Carp Capital Flood Street FAU Street CDBG Perls Water TGIDIS Im1.lrueamerrt ikmeOl Imnrwemer113 (rants (rent ImQovements PrDecte 5-30-W S-30-88 ASSETS C2stlandcasnequMIent5 $0,990 $]98,09] $248,444 $ - $1]8,5]4 $298,033 § - $1,528,138 $4,394,565 ItNes"ern5 - 343,165 - - - - - 343,165 880.141 Grants recarvabla 340,750 - - 216.375 28,325 - - 585,450 446.261 Special aseeesrrenl5 I..,.ble - - 86,438 5.084 - - - 71,522 99,794 Int are et receivable 5 1,363 - - - - - 1,368 22951 Noms r9cl3Vdbe 4,032 41032 8.065 Total..sets 5347745 $1,140625 $]14882 $221,459 $210,931 5298.033 S - $2,5338]5 55.6331]] IJABIUTIES AND FUND BALANCES ACCJurnspa,mbe $51325 $3,646 $1960 $78.500 $120 $8,979 $149,246 S291,778 $415.311 Due to olber governments - - - - 1000 - - 1.000 1,000 Due to other funds 1]0,29] - - 136.988 43,687 - 143,434 496,324 58,144 Deterred revenue - 81065 65.346 5,084 78,495 98,907 TORI IIeblIM. 221,622 11.713 67,306 220,5]0 44,]2] 8,979 292.680 68],59] 573,362 Fund balance.; Reserved for debt service 219 - - - - - - 219 835,752 Reserve$ for bond capital expendilurea 6,776 - - - - _ _ e.]]8 1,691.428 Reserved la econornic da, ban repymrt. - - - - 77,208 - - 77,2e8 94358 Reea adl for encumrrance5 20,762 56.370 - 24.665 22,116 12.]8] 1,678,]7] 1813.457 4,075891 Unrese,eed 98,386 1.072.542 247,576 (23,]]6) 68,820 2]8.26] (1989,457) (231,642) (1,236,814) Total fund Oelancs. 126,123 1,128512 247,576 889 168304 289,054 (292680) 1,668.0]8 5,280,415 To at Ilablillim and fund balances $347745 $1.140.825 $314,882 $221,459 $210_931 $29,090 > $2.533.8]5 55.633.7-/] I 1 1 1 1 1 1 1 f 1 t 1 1 1 { 1 1 I 1 City N Cep• Gimrelesu, Mimauri CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES FOR THE FISCAL YEAR ENDED JUNE 30, 1997 GENERAL CORP FAU CAPITAL FLOOD STREET STREET CORO PAR( WATER TOTALS IMPROVEMENT CONTROL IMPROVEMENTS GRANTS GRANT IMPROVEMENTS PROJECTS 1998-1997 REVENUES Intergovernmental 1297731 E- E- $573.& E262.5)s $- - $1.114,203 Interest 120,362 93,670 30,613 1,891 to,M2 10.421 - 2m,579 Special assessments - 9'334 23,383 5,094 Miami TOTAL REVENUES 411,093 179,800 53,805 651,011 2e3.2m 10.421 1.489,633 EXPENDITURES Capital 0u ay 3,378,555 802,360 e70.7Q 935,530 393,001 21,939 292,178 e,511,m2 Debt saMca mor85t and fiscal charges 65,557 m 10,823 2,613 6,193 502 54,772 � a TOTAL EXPENDITURES 3,445,415 902.453 570,749 867,457 310.610 27,088 292930 6,589,151 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (3.031.322) (722,51a) (616.54931 (3m,u5) (47 31 e) 18.e7 (292.930) (S,Gees31) OTHER FINANCING SOURCES (USES) Operatingtranefust, - - - 25,000 28,232 20,000 - 73232 Operating 0ansfers ma - (30,500) - - (06235) - (75,736) Bond proceeds 1,365,000 - - - 180,000 1 5CW5 TOTAL OTHER FINANCING SOURCES (USES) 1,345.000 - 130,500) 25.000 25,232 130.765 1.502.197 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES (1,938,32) (?2,54)) (617,313) (a41,11e7 (t 8,051) 119,080 (29;850) (3,591,331) FUND BALANCES, JULY 1 1.815,4u 1,551,ae1 581,819 362,335 185,288 170.30 S2eg112 FUND BALANCES, JUNE 30 12919 1125912 5217.5!9 559 193201 93051 (5282.8801 15550]5 City of Cape Girardeau, Missouri GENERAL CAPITAL IMPROVEMENT FUND SCHEDULE OF REVENUES AND EXPENDITURES — BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1997 BUDGET ACTUAL REVENUES Intergovernmental $— Interest TOTALREVENUES EXPENDITURES Capital outlay 397,000 Debt service Interest an d fiscal charges TOTAL EXPENDITURES 397,000 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (397,000) OTHER FINANCING SOURCES (USES) Operating transfers In 65,000 Bond proceeds TOTAL OTHER FINANCING SOURCES (USES) 65,000 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($332000) 77 $287,731 123,362 411,093 338,934 65,557 404,491 6,602 1,345,000 1,345,000 VARIANCE FAVORABLE (UNFAVORABLE) $287,731 123,362 411,093 58,066 (65,557) Q,491) 403,602 (65,000) 1,345,000 1,280,000 $1,351,602 $1.683.602 City of Cape Girardeau. Mlsaouri + CORP FLOOD CONTROL CAPITAL PROJECT FUND SCHEDULE OF REVENUES AND EXPENDITURES — BUDGET AND ACTUAL (BUDGET BASIS) .. FOR THE FISCAL YEAR ENDED JUNE 30, 1997 + VARIANCE FAVORABLE BUDGET ACTUAL JUNFAYOflABt.E + T 78 REVENUES + intergovernmental $449,600 89,570 ($360,030) Interest 37,500 90,334 `52,834 TOTAL REVENUES 487,100 179,903 307,197) EXPENDITURES Capital Outlay 1.976,800 951,554 1,025,246 Debi wMce Interest an d I SCei charges TOTAL EXPENDITURES 1,976,800 951,623 1,025,177 + EXCESS (DEFICIENCY) OF REVENUES OYER (UNDER) EXPENDITURES {1,489.700) {771,720) 717,980 + OTHER FINANCING SOURCES (USES) Operating transfers in + TOTAL OTHER FINANCING SOURCES (USES) — — — + EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES 1$14897001 ($771720)$117980 78 City of Cape Girardeau, Missouri STREET IMPROVEMENT FUND SCHEDULE OF REVENUES AND EXPENDITURES — BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1997 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) REVENUES Interest $23,000 $30,513 $7,513 Special assessments 29,000 23,393 (5,607) TOTAL REVENUES SQ000 53,905 1,905 EXPENDITURES Capital outlay 190,100 134,002 56,098 Debt senlce Interest an d fiscal charges TOTAL EXPENDITURES 190,100 134,002 56,098 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (138,100) (80,097) 58,003 OTHER FINANCING SOURCES (USES) — Operatingtransfersin — — — Operatingtransfersout (42,000) (30,500) 11,500 TOTAL OTHER FINANCING SOURCES (USES) (42,000) (30,500) 11,500 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($180,1001 ($110,597) ---$69 503 79 ` City of Cape Girardeau, Missourl FAU STREET GRANTS FUND SCHEDULE OF REVENUES AND EXPENDITURES — BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1997 BUDGET ACTUAL 80 $573,936 1,991 5,084 581,011 499,641 10,923 510,564 70,447 25,000 25,000 VARIANCE FAVORABLE (UNFAVORABLE) ($103,354) (3.009) 5,084 (101,279) 412,459 (10,923) 401,536 300,257 $95,447 $300,257 REVENUES Intergovernmental $677,290 Interest 5,000 ,. Special assessments TOTAL REVENUES 682,290 EXPENDITURES Capital outlay 912,100 Interest and fiscal charges TOTAL EXPENDITURES 912,100 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (229,810) `. OTHER FINANCING SOURCES (USES) Operating transfers in 25,000 TOTAL OTHER FINANCING SOURCES r (USES) 25,000 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($204,810) 80 $573,936 1,991 5,084 581,011 499,641 10,923 510,564 70,447 25,000 25,000 VARIANCE FAVORABLE (UNFAVORABLE) ($103,354) (3.009) 5,084 (101,279) 412,459 (10,923) 401,536 300,257 $95,447 $300,257 City of Cape Girardeau, Missouri COMMUNITY DEVELOPMENT BLOCK GRANT FUND SCHEDULE OF REVENUES AND EXPENDITURES — r BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1997 VARIANCE FAVORABLE ACTUAL (UNFAVORABLE) $252,576 ($97,424) 10,722 r 263,298 BUDGET 321,617 r REVENUES (2,613) 324,230 Intergovernmental $350,000 139,718 Interest (21,768) 28,232 TOTAL REVENUES 350,000 EXPENDITURES r Capital outlay 550,650 Debt service Interest an d fiscal charges TOTAL EXPENDITURES 550,650 EXCESS (DEFICIENCY) OF REVENUES _ OVER (UNDER) EXPENDITURES (200,650) r OTHER FINANCING SOURCES (USES) Operating transfers In 50,000 TOTAL OTHER FINANCING SOURCES r (USES) 50,000 EXCESS (DEFICIENCY) OF REVENUES _ AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($150650) r 81 VARIANCE FAVORABLE ACTUAL (UNFAVORABLE) $252,576 ($97,424) 10,722 10,722 263,298 (86,702) 321,617 229,033 2,613 (2,613) 324,230 226,420 (60,932) 139,718 28,232 (21,768) 28,232 (21,768) ($32,700) $117949 r City of Cape Girardeau, Missouri PARK IMPROVEMENTS FUND SCHEDULE OF REVENUES AND EXPENDITURES — BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1997 BUDGET ACTUAL REVENUES Intergovernmental $— Interest Q000 TOTAL REVENUES 2000, EXPENDITURES Capital outlay 290,000 Debt service Interest and fiscal charges TOTAL EXPENDITURES 290,000 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (288,000) OTHER FINANCING SOURCES (USES) Operating transfers in 65,000 Operating transfers out (45,235) Bond proceeds 150,000 TOTAL OTHER FINANCING SOURCES (USES) 169,765 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($118235) 82 x- 10,421 10,421 34,755 5,108 39,863 (29,442) 20,000 (45,235) 160,000 134,765 VARIANCE FAVORABLE (UNFAVORABLE) 8,421 8,421 255,245 (5,108) 250,137 258,558 (45,000) 10,000 (35,000) $105,323 $223,558 City of Cape Girardeau, Missouri WATER IMPROVEMENT PROJECTS SCHEDULE OF REVENUES AND EXPENDITURES — BUDGET AND ACTUAL (BUDGET BASIS) FROM INCEPTION AND FOR THE FISCAL YEAR ENDED JUNE 30, 1997 PROJECT PRIOR CURRENT TOTAL BUDGET YEARS YEAR TO DATE 83 REVENUES Interest $700,000 $ — $ — $ — TOTAL REVENUES 700,000 EXPENDITURES Capital outlay 26,500,000 — 1,968,956 1,968,956 Debt service Interest and fiscal charges 502 502 TOTAL EXPENDITURES 26,500,000 1,969,458 1,969,458 EXCESS (DEFICIENCY) OF REVENUES ` OVER (UNDER) EXPENDITURES (25,800,000) (1,969,458) (1,969,458) OTHER FINANCING SOURCES (USES) Operating transfers In 1,000,000 — — — Bond proceeds 24,800,000 TOTAL OTHER FINANCING SOURCES (USES) 25,800,000 ` EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES $ — $ — ($1.969.4581 ($1 969458) 83 Total liabilities and fund equity $53,40],329 $155]8954 $2022910 $424850 $84006 $71 51 ,8,049 $70,596,01] 84 City of Cape Girardeau, Missouri ENTEHPHISE FUNDS COMBINING BALANCE SHEET June 30, 11397 (With Comparative Totals for June 30, 1996) Solid Gulf Softball l'otals Sewer Water Waste Curse Com 6-30-97 6 -30 -an ASSETS Cash and cash equivalents $11,354 $583,569 $595,]]9 $6],414 $38,639 $1,296,755 $1)88,533 Investments 1,147,135 - 121,854 - - 1,2611,989 1,268,989 UtllBy charges receivable (net of allowance for doubtful receivables) 307,742 488,391 229,523 - - 1,025,656 1,163,109 (rants receivable 90,435 275,738 - - - 366,1]3 291,575 Special assessments receivable 116,134 - - - - 116,134 IQ,764 Intereslrecelvable 38],1]5 5,447 5,901 - - 398,523 401,958 Other receivables 5,613 197,440 34,067 2,637 503 240,260 50,048 Imemorles - 108,729 - 2,494 - 111223 109,211 Restricted assets sa Cash and cash equlvalems 23,022,171 2,091,849 15,986 - - 25,130,006 26,626,260 Investments 510,500 49,000 80,500 - - 640,000 2,626,864 Prepald Items 656,314 244.406 23,347 481 238 924,786 1,046,765 26,254,573 4,044,569 1,106,99 73,026 39,380 31,518,505 35,519,095 Property, plant and equipment Lend 135,869 - 112,240 - - 2411,109 24,109 BuRdIngs 8,156,62] 198,266 726,231 3,549 - 9,081,673 9,064,673 Iravemerds other buildings mp 21,488,373 10,953,403 83,122 362,925 4,89 32,892,680 30,120,736 Equipment 1,146,913 65,386 1,404,518 430,231 53,844 3,693,692 3,274,665 Constudlon In progress ,46,743 1,36,124 7.8a 867 4,6813549 37,388,525 13,178,179 2,326,111 ]96,]05 58,701 53,748,221 4],416,]32 Less accumulated depreciation 10,235,769 1,643,794 1,410,159 444,881 14,075 13,748,677 12,339,810 2],152,]56 11,534,385 915,953 351,824 44,626 39,999,544 35,0]6,922 Total .... ts 553.40]329 $15578954 $2022910 $424850 $84006 $71518049 $]059601] LIABILITIES AND FUND EQUITY Accounts payable $574,159 $319,452 $50,842 $11,325 $18,892 $%3,670 $1,062,192 Acoued Ilabllkles as Selades,payroll taxes and benefits 53,605 1,352 45,354 18,372 19,090 137,773 133,230 Notes Payable - - 34,646 - - 34,646 40,413 Interest payable 432,570 232.429 11,078 - - 6]6,07] 374,789 Other llabllltes 25,172 1]5,]90 57 224 - 201,243 158,606 Due to other fund. 59,246 - - - - 59,246 1,650,191 Due to other gwemments - 114,296 - - - 114,296 133,3]1 Advance tam other funds 337,500 - 907,000 39,000 190,000 1,867,500 1,6]],500 Current potion of long-term debt 89,435 375,000 169,800 - - 1,36,235 1,156,125 Long-term debt net of current potlon w Revenue bonds payable 29,939,205 11,091,405 - - - 41.030,610 40,769,810 Leasehold revenue bands payable 1,445,181 - 141,926 - - 1,587,107 2,17),0]5 Certificates of participation 1,710,000 83,000 495,000 - - 3,040,007 3,2110,000 Estimated landfill closure and past -closure care cost liability 822,960 822,960 815,258 Total liabilities 35,867,073 13,144,724 2,]40,663 419,921 20,982 52400,363 53,428,]60 Fund equity _ Contributed capital 16,739,900 1,93,546 288,585 645 31126 18,9]0,8]2 17,394,915 Retained earnings Reservadfor debtsavice 30,000 - - - - 30,000 2,333 Unreserved 770,356 495,684 (1,006,338) 4,264 14],ID2 116,884 (256.021) r. Total fund equity 1],540,256 2,438230 (71],]53) 4,99 143,976 19,117,686 1],167,25] Total liabilities and fund equity $53,40],329 $155]8954 $2022910 $424850 $84006 $71 51 ,8,049 $70,596,01] 84 City of Capa Skase... Miwoud ENTERPRISE FINDS COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANCES IN RETAINED EARNINGS FOR THE FISCAL YEAR ENDED JUNE 30, 1997 85 SOLID GOLF SOFTBALL TOi'ALS SEWER WATER WASTE COURSE COMPLEX 1996-1997 OPERATING REVENUES Resldentlet hinges 51,438,806 52.319,249 sl=,325 Canmerdel durpM 914,335 54.525,443 17,441 - - 2457.189 Tunsfer daticn d+arpee - - 675.696 - 675,636 Egelpment Mlsa 7,971 - 7371 Cmeasww W.V. - - - 74056 13,311 97,369 GO muse fees - - - 399,751 - 390,751 Wow wapwaaa _ - - - 45,131 0.5,131 ONar fees and charges 37,762 157,662 33,818 - - 229,462 Other mlacalaneo0a 32.21] 9,313 _ 12.9J21 IG66 6 41,176 TOTAL OPERATING REVENUES 2,423,120 4,011_943 2,227,158 483.446 56,448 9,^04,115 OPERATING EXPENSES Peroonnel aerv. 751,278 78.351 816.646 212,297 156255 2016,827 Matedalund Pplies 86,099 67,412 58.266 49,440 26025 287,242 Cufaaceaisevlcea 224,923 2.418.593 786.562 38,741 20,482 3,689.301 General merffihg expanses 26,737 Y45,456 40,107 49,615 12,927 270,742 Smalal V0lacfs expense 32152 - 85,T72 4,945 3,981 126,850 In46ma1..N expensea 65,QT2 2a,615 160,742 52,283 7,325 314,037 Depredation expense 795561 391,306 221,]26 57,326 ],000 1472.921 .... TOTAL OPERATING EXPENSES 1,985,82'2 3.129.733 2.167,821 458,549 235,995 7,977,920 OPERATING INCOME (LOSS) 437,296 862210 59.33] 24,&97n 547) _L226 195 NON-OPERATING REVFNUE (F7(PENSES) interest Inman; 1,499,277 166254 53,542 2,'.'.96 99 1,721,470 Sees grates heal - - - - (1831 Fode"A Want, - - 12.356 - - 12,358 Sea of Teed asaab - - 1,366 2,660 - 4,026 Companseflan fordemegoe - 1,406 3,043 - - 4,449 Gain on sale c4 Psetl.seats - _ _ _. _ 0 Issuance cost amutimdon (661962) (30.239) (7,121) - - (104.242) Interest and handling coeb JLZX.666„ (765.6611. _ (99.`434) 121,.E 110,69]1, 12.667,6071 TOTAL NON-OPERATING REVENUE (FT(PENSES) (358,474) 6128,241) (38,346)(16,070) 170,5981 11,049,]291 INCOME (LOSS) BEFORE OPERATING TRANSFERS 78,824 253,969 22,99Y 9,827 (168,145) 176466 Operating tranafeto in - - _"„_ 50,000 207,500 217,100 NET INCOME ¢OSS) 78,824 253.969 22.991 18,a27 18,955 393,568 RETAINED EARNINGS (DEFICIT). JULY 1 721,532 241,715 {1,010,329) (ter 5431 (165.067) (227,682) PRIOR PERIOD ADJUSTMENT �..._ {19 C00} __^ (190m) RETAINED EARNINGS (DEFICfT), 324E3D 5600358 $495684 _45400633ej $4.284 {St47 i0Z} 51� 85 CM or Cepe c9«oeeu, Mlaeourl ENTERPRISE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR INE FISCAL YEAR ENDED JUNE W. 1997 SEI EB WATER SOD) WASTE CASH FLOWS FROM OPERATING ACDNDES: SOFTBALL COMM FY Op fing IncooN(loss) 607.290 Mjudmeds To mmoclle operMln9 Income to 559.337 Mesh prm4d.6 Ma Iingectivil ' i DN chdflon 295.561 CMM1 op«.6n9,m. �A nI ]26 CIA'. In esnN Mq eelMNev: 7,600 c&sc ..e In... N.ene6x (I" prcmm) aecmme N in.m Y 12,350 pllv®MI esl�Inp Id nem. - I.. Insawrnl.9e,We 14260 I..s (aewaase) lo.m IlHllmv 60.50 I..e Itl«lee•eJ blenall poen u. mn curs (563) NET CASH P;rmMED IF! (USED IF4 OPETNIWO - AClBTBEB - CASH FLOWS FROM NONCAPITAL ITNANCING ACTATTES: - Opentln9 mortem M h«o o luM 9,90 NET CASH PROVIDED Be (USER Ito BY NONCAPITAL 1T. 1 FNANCNO ACRYTRES (147) 23.693 (13.001) CASH FLOWS FROM CAPITAL AHO RELATED FINANCING 145959 ACTVITES: 14.992 Pm 1. O.reloper. 1922.319) PM.kal .IEonlmenuvE cks R.12J) PNcp.l p.M on lmm purcleve 6«em 5.460 Prl..0I,Ia. COP PIIm"I PItl on SHE 7,762 Prock.1 pld.., Ian 6 not. payed. on 0M ti IrRrtN pNtl on o«pe and aollge6ane pn« 1. u,w'.. � from«her,o-n-ts Pu .. d Nva me,0 pnm loom COP Won- 321,518 hnm Beledme«v � Contp Comprm9al Mr Jnapm 150796 NET CASH PROVIDED RF (USED Ip CARTAL AND RELATED FINANCING ACTNTIES CASH FLOWS FROM INVESTING ACTIVITIES: PUNeee d 4nmerv�N Pmofetle 6om vele of lm'eHmelRv IM«e+m Y.evlmmib Z)7,100 Ov«nlpeld«eN � Im«ml messeembd. NET CASH PR RFDM FIY (USED IN) INVESTING ACTIVITIES INCREASE (DECREASE) N CASH AND CASH EQUIVALENTS CASH AND CASH EQUIVALENTS, JULY 1 217,160 CASHANOCASHEQUIVARETTS, JUNE30 SEI EB WATER SOD) WASTE CALF COURSE SOFTBALL COMM FY TOTALS IM -11@7 607.290 5862210 559.337 S24,097 4In517) sl2 .195 295.561 Jnl." nI ]26 57,329 7,600 1,472921 (I" - 12,350 - - 12,125 14260 P9spW1 60.50 9.om (563) (119.710) - (1,610) - 002) - PA12) 9,90 (3.141) 1T. 1 - (147) 23.693 (13.001) Po,9947 145959 (3515) 14.992 fal" 1922.319) 63.957 R.12J) 11,902) 5.460 (35).X77) 7,762 7.702 321,518 111e620 y733 74,364 150796 1.fi924fl5 1�000 Z)7,100 217.4W 10,600 217,160 217,1W 136,5.7 _ _ _ _ Im.W) 195,000) 955.ouo) _ _ _ PRO.") Nv542) - (136.se3) _ _ pm.I25) 11W,Wo) - O0.000) - - 1140.000) (32.000) - _ _ _ 62.000) - 04,14) (5.767) - - H9.wl) (760.574) (723002) (100,715) 91.026) (10,607) (1616,021) 255.539 4 ,.73 - - 741.009 0.493.591) (907247) 923910) 62477) (7.065) 15.601260) 2430 7615 - 9.925 1,460 3.011 4.N9 (5.590.651) t 012,489 N95.fi02) (65,W)11 7,762) (7.612.364) 664,166 1,122.696 - - - 1,906664 1,459,072 97.679 21664 - - 1,577,615 24," 76,915 33.4s2 2. 99 139.600 10,699 to,W6 2.356.562 1299,492 54.316 2.96 W 3,714,767 P.910,571) 973.631 (110.553) 9.622 36.609 26.944,096 1.701.762 722.319_ 46.592 N,414,IW tas, 3, 25 52675,_415 5611 ]65 X414 M639 526426.761 91 City of Cuuu Glruda9u, Missouri SEWER FUND SCHEDULE OF REVENUES AND EXPENSES— BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1997 87 VARIANCE FAVORABLE BUDGET ACTUAL _(UNFAVORABLE) OPERATING REVENUES Redden6al clurpes $1,465,000 $1,436,606 ($26,194) CommerddcMrgee 9W,000 914,335 (45,665) Otherleseandcharges 35,000 37,762 2,762 Othermlecelleneous 37,393 32$17 (5,176) TOTAL OPERATING REVENUES 2,497,393 2,423,13! (74,273) OPERATING EJ(PENSES Personnel.,A... 752.591 7517/8 1,313 Met."..nd suUgliee 98,610 89989 9x1 CONncluel.em... 221,743 224,784 (3,041) GeneN opem6np expeneee 35,386 28,737 6,619 Sp Ial p J.de expense 35,700 3,401 32,299 Internal service expense 126,545 65,072 61,473 Capital0otlay 14$67,015 3,641,763 10,625,252 TOTAL OPERATING EXPENSES 15537,790 4,805,024 10,732,766 OPERATING INCOME (LOSS) (13,010,397) (2.381 ,904) 19659493 NON—OPERATING REVENUE (EXPENSES) Int ... 9 Income 678,750 1,499,277 631,527 518N grams 125,000 (163) 1125,183) Federal prams 200.000 255.536 55,538 Impedleee 209000 138,520 (61,480) Principal payment. (/30,542) (730,542) — Intered and handling code (385,102) (731590) (346,486) TOTAL NON—OPERATING REVENUE (EXPENSES) 288,106 431,016 142,912 NET INCOME (LOSS) (312752$91) ts1,950.606) 510,001,405 87 City of Cape Girardeau, Missouri WATER FUND SCHEDULE OF REVENUES AND EXPENSES— BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1997 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) OPERATING REVENUES RaaldenWl chargee $2,410,000 $2,319,99 ($90,701) Commerclelcherges 1.690,069 1,525,443 (74,557) Other fees and chargee 157,500 157,882 382 Othermleoelleneou. 5,000 9,318 4,319 TOTAL OPERATING REVENUES 4,172,500 4,011,943 (1W,557) OPERATING EXPENSES Personnel service. 80,660 78,351 2,309 Materials and supplies 74,538 65,707 8,831 Contractual services 2,690,995 2,414,672 276,323 Gen. d oieemgng expense. 15,642 145,456 5,186 Internal service expense 20,335 28,615 ((8,280) Capital outlay 1,070,638 1,696,091 64547 TOTAL OPERATING EXPENSES 4,W7,8W 3,738,892 348,916 OPERATING INCOME (LOSS) 84,692 273,051 186,359 NON—OPERATING REVENUE (EXPENSES) Intend income 97,500 166,254 68,754 Federal grant. — 447,830 447,830 Compensation in, damages — 1,406 1,406 Principal paymerrts (299,125) (299,114) 11 Interest and handling costs (723,075) (728,028) L4,953) TOTAL NON—OPERATING REVENUE (EXPENSES) (924,700) )411 A52) 513,048 NET INCOME (LOSS) ($840008) 151386011 $701.407 89 City of Cape Glradeau, Missouri SOLID WASTE FUND SCHEDULE OF REVENUES AND EXPENSES- BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE W. 1997 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) OPERATING REVENUES R.ddentbl chargee $1$61,W0 S1b02.3!i ($59,175) Commercial chargee 30,000 17,411 (12,589) Transfer station charges 628.000 675,636 (152,364) Olhxfee..adaherpea 35,000 33,818 (1,182) Other miscellaneous 2,500 (2,032) (4,532) TOTAL OPERATING REVENUES 2457,000 2,227,158 (229,642) se OPERATING EXPENSES Personnel servicee 81 89,129 52,116 Materiels and supplies 61,310 59$56 2,052 Corsnctuel eam... 908,319 792,786 115,533 General operating expenses 59,618 41,607 18211 Special pmleas emense 50,000 50,546 (546) Internal seMce emensa 20,335 160,742 43593 C.Pfial outlay 485,400 164,188 321,212 TOTAL OPERATING EXPENSES 2,650,49 2,098,256 552,173 OPERATING INCOME (LOSS) (193,429) 128,902 322,331 NON-OPERATING REVENUE (EXPENSES) Interest Income 19$00 53,542 34,042 Federal Brants - 12,358 12,356 Compensation for damages - 3,643 3,043 Sale of Porad asset. - 1,366 1,366 Principal payments (170,600) Q70,583) 17 Interest and handling costs (97,350) (t01,418) (4,068) TOTAL NON-OPERATING REVENUE (EXPENSES) (248,450) (201,692) 46,758 a NET INCOME (LOSS) ($441 879) ($72790) $369,059 89 City of CWe Glrwdoau, Missouri GOLF COURSE FUND SCHEDULE OF REVENUES AND EXPENSES— BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE W, 1997 E $24,669 VARIANCE FAVORABLE ACTUAL BUDGET $7,971 OPERATING REVENUES 74,958 10A58 EQulpmert soles $19,OW 1,666 Concesslon mvenuw 64,0W 381146 Goll course fees 371,3W 48,648 Othermlwelleneoue 38,741 565 TOTAL OPERATING REVENUES 445,3W 4,945 OPERATING EXPENSES 52283 (3,983) Perwnnsl wMces 22.479 _ 453,475 Mat.M. end supplies 48278 61.239 Cortradual wMcee 39,306 2,660 General operating expenses 53,155 (1,528) Special pro)ada egxnw 6,200 13,901 Internal s . expense 48,3W (40,000) Capital outlet' 60,850 TOTAL OPERATING EXPENSES 476,568 OPERATING INCOME (LOSS) (31,268) ,w NON—OPERATING REVENUE (EXPENSES) Interest income — 5a10 of Axed assets — Interest and hendllnD costs R 9.5m) r TOTAL NON—OPERATING REVENUE (EXPENSES) (19,SW) INCOME (LOSS) BEFORE OPERATING TRANSFERS (50,768) Opo afl,trenefen In 5.000 NET INCOME (LOSS) ($768) 90 E $24,669 VARIANCE FAVORABLE ACTUAL (UNFAVORABLE) $7,971 ($2,029) 74,958 10A58 399,751 28,451 1,666 11666 463,446 381146 212,297 6,182 48,648 (370) 38,741 565 43,985 9,170 4,945 1,255 52283 (3,983) 52576 8,04 _ 453,475 23,093 29,971 61.239 2,98 2,298 2,660 2,660 (21,028) (1,528) (16,070) 3,430 13,901 6/,669 10,000 (40,000) E $24,669 91 City of Caper Glrnnfaau, Missouri SOFTBALL COMPLEX FUND SCHEDULE OF REVENUES AND EXPENSES— BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1997 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) OPERATING REVENUES Equipment sale. $1,000 $ — ($1,000) Concession swam.. 40,000 13,311 86,689) Softball complex fees 82,000 45,131 (36,869) Other miscellaneous 6 6 TOTAL OPERATING REVENUES 123,000 58,448 (64,552) OPERATING EXPENSES Personnel seMces 16,011 158,255 7,756 Meterkleend..Mile. 22,1 9, 24265 8,073) Contractual service a 22,186 20,092 2,104 General operating expenses 31,386 12,927 18,459 Special Projects expense 7,500 3,981 3,519 Internal service expense 4,125 7,325 (3,200) Capital 0utlay 5,400 7,965 (1,665) TOTAL OPERATING EXPENSES 258,800 233,900 24,900 OPERATING INCOME (LOSS) (135,800) (175,452) (39.652) NON—OPERATING REVENUE (EXPENSES) Interest Income — 99 99 Interest and handling costs (6,750) (10,697) )1,907) TOTAL NON—OPERATING REVENUE (EXPENSES) (8,750) (10,598) (I846) INCOME (LOSS) BEFORE OPERATING TRANSFERS (144,550) (186,050) (41,500) Operating transform in 145,500 207,100 61,600 NET INCOME (LOSS) $950 $21,()50 $20.100 91 r r City of Cape Girwcoau, Missolrl INTERNAL SI]IVICE MNIXi COWININO DN_ANCE St LET June W. 1897 (Wfli Comparal1w Totals to .fune 30, 1 9 err Employe..' Data Fleet Fringe Risk Equipment Totals Rocessing Monanumont Benefit Management Replacement 6-30-97 6-30-80 ASSETS Lash and cash equisalems $290,196 $103,468 $1,945,cm $1,120,960 $88,661 $2,648,880 $2,174,278 r Imashnants - - - 180,963 - 180,963 2)9,952 Interestreoesable - - - 1,538 - 1,538 31600 Other receivables 176 10,061 1,144 2,802 - 14,183 105,321 yrvenmdes - 8,014 - - - 8,014 9,465 r Restkted losses Cash and cash equivalents 423,293 - - - 363,484 706,]]7 - Prepeldltems 19,853 1,602 551166 12,493 69,114 72,291 733,520 123,145 1,046,744 1,361,429 461,631 3,729,469 2,644,9,47 Property, plant and equipment Lead - 37,500 - - - 37,500 37,500 Buildings - 421,178 - - - 421,178 416,109 Imp-Owments Otho buildings - 104,903 - - - 104,903 27,206 F,qupm.M 1,097,266 220,421 - - 196,8871,522,434 1,255,590 ConstruMon In pugess - 6134fi 61346 77,697 r 1,097,206 798.348 - - 196,607 2,092,361 1,814,102 Less accurnoated depreciation 73,767 357,379 44,367 1,132,513 935,151 366,439 440,969 152,440 959,848 678,951 Toted suets $1.099.959 A561114 $LO46]44 $1.361.429 E61 ].W1 E4.689317 $3523858 L NB LIFRES ANO 9JNO EQIITY Accolxrts payable $7,620 $69,508 $11ki'KI $2 B,683 $923 $472,125 $565,448 Acauad llabllNas Salarles.payroll tastes and benefits 1,839 24,840 - - - 2,679 28,504 ytlersst Payable 1,724 14 - - I'm 3,511 - Odw liabilities - 50 - - - 50 5,498 Out to other gosammems - 2,8.51 - - - 2,651 - Ctrtent ponan of long-term debt 55,000 - - - 55,000 110,000 - ess Long-term debt net of corent potion CeUBcetes of parecilastlan 379,589 3&9,325 76,914 Total lleblllies 445,772 97,263 165,391 220,683 447,021 1,364,130 599,49) Retained earnings Lireserved 654,187 466,851 681,353 1,132,746 170,050 3,305,187 2,924,408 Total load aq.Ity 65,187 466,851 881,353 1,132,746 170,050 3,305,167 2,924,408 Total l leb111tlas and fund equity $1099959 _$564l 14 $1046744 $1361429 $617071 $4689317 $3,523656 92 CRY Of CSRe Glrwdwu, MIS Bowl INTERNAL SE.CE FUNDS CONFINING STATEMENT OF REVENUES, EISPENSES AND GRANGES IN RETAINED EARNINGS r FOR TIRE FISCAL YEAR ENDED JUNE W. 1D37 93 EMPLOYEES' DATA FLEET FRINGE RISK EQUIPMENT TOTALS PRONG MANAGEMENT BENEFIT MANAGEMENT RFN ACEMFNT IBES -1891 OPERATING REVENUES 11Se10epNlmerlml semcaa 5267,01 8x3,720 8$81188 5179,163 552,399 52,7%.569 DOW mme16MWe 91" 25 225 - - 9'_551 TOTAL OPE/ATNO REVENUM 276.361 ]03,]16 1'2`815`1 11 379.1W 52389 2,766,1X) OPERATING EXPENSES PmwmN eTNCee S9,6L0 378.918 TUTOR 58g.36p Metmweem euTptlee 53% 235104 - - - 24650 cmNecpnlwmcee 66.565 040, 1=,516 250,963 - 1,102259 GenNN us 1)39 - 1.690 - 7,475 Imemd eaNmm .rSwB - 2.0R - - - 2,011 Depec660n wmlee 118159 31.712 15516 199,511 TOTAL OPERATING E%PE14SEB 255,650 798.928 1.169.35/ 255788 16.516 '2�1�38- r OPERATING INCOME ILOSS) 20]11 (f,1W) 95,151 123]13 5,853 211.%1 NON-OPERATING REVENUES (pNENSES) IrvWN!force 13.475 2,112 61,094 69.93f 716 115131 COmpeluLLbn 1p Glmepe 2.780 3,770 6.560 lewelce.O.I..Wtr60Oe R56I - - - (253) �) ImelealNp ne11Gl41a coeb (1618) (IM) _ _ (3.661) P.3e21 TOTAL NOM-WERATINO REVENUES (WEIISES) 11391 2.612 61`5 _W 9-14 2569 1�etO INCOME QOSS) W FORE OPERATING TRANSFERS 35,102 (1,169) 157.616 193117 5152 392.661 Opsebq "re. In 181.598 161.596 OpaelYq YenpOR ON1( 13.SN)1( 733FG) NET INCOME Q_OSS) 35,102 (1,168) (16.152) 193,217 170.050 389779 RETNNEDEARNINGS (DDRCrr), JULY 1 619.055 166019 sv,� 939,199 - 292,100 _ RETNNEDFAn,mBCS pFACII), JUNE W 5654,187 5468.851 5661.359 $1,132,716 $170.050 S3 187 93 94 ON.C.P. DIn• NTEIMKSEINCE .uran FMM C UMNNDOTATE ENT C CASHFLCVS FOP THE FL4,µ YFM ENUEp.UNE R tw] EYPI. .TA FIEEi FNNC£ q61(EDIIPYENI TpiNB PrLrF�c..a �m��.j y.N �.'NFFD_ M9tlM�sfftR S PLA' MENLI®t-1wL CASH FLOW9 FIYlY p£MTN[i ACTNRI®: f CPN•IMp l�mm•(IwH 520.]11 (53.1 585,15. 512J,313 6.P81 SZtl1,N11 AQut��b b �.dle gaetlne Ilmmeb rel m.nP�•d YS OP•ntlne•.UN11m Oaq lelbl tIB,2d] 3.,]13 - - •BSIe f1WA11 L In•WeanOYdln4[ pma®I eeP•••+hnn rc4wd• V 117al (I A19 ]e,am 13,3zi - fel,t3) � Qrvr)1ar bYN•'ury - 1/51 _ _ _ ft,A51 I w (mme.n�•• 4u••p Io) h�nft nb PY[LY He,.D B,]TEFRI.) (42,M %3 OwTL9 es hn.®In®)h•ml.escm5r R,loal ao5 ait�) N=T CASH EAO MD IW OI M OPNIATINO ♦CHWTIES t3o,ffA TI N6 IN,e)o 0,369 W.. MI,475 GASH FLOW S FNOY NONWITAL FINANCING AC'NMIES: Lts•tlryb•M•n oulboew lun6 - - H13588I - I.l.. I311� MU CASH PROVIDED DY (UWD IN) NONCAPNA FNANCNGACSWITEB - - 11]3�/JI - le"!M CASH FLOWSF C TK AND HH)FNAICNO ACMITIM. RYdPI Pleon•nxwben A.,,b%— h. - Hen hb•llwa PlpMs4la OdlPtlm. - IFA) - - tie 3z Pu nw ofnree Aer• (ll.wt) M,1)1) - - a13wR C r Rou•a hom CCP Mun® 4a,31 - - - .3i,5" .ua) &v,N] P[ved M1Om mYalu••h IS,PI M.1 ConP^.[lbn bo[my� �]0 __ - X3]0 Qa_feA NET CA^.H N1ONL® IW OBEO M C Tx Ma IEIAWD FN CNOAC: NRF9 �I _pE9 WW2 SSR. CASH mms FEgY INVESTING ACTMT" W tus ollmaMrunb Rtt'eebfrom Wollmasinwlb w, - 99,8% hw•f on Ynmlrrenn 13,M3el 12,301 Dnmhn hbn• 1175 _11313 e1.oW X015 )tB 10813 NET fA91E R MN M ABED IN) INVESTING ACTNHE 1�,475 _I12 9+.w. im. 71e 20,1. INMEASE (DEMIEASE) IN CASH AND CASH EOIIVAIENTS 513,.1 8.853 19281 2M.MI IW,1JB 12 on CASH MD CASH EOONAJ8IT5, J T1 lw.ft 0,515 1p27,33e M,5" 3,111$]0 CASH MD CASH EWNAL M.&WE]e 1113,1.1 51 10 tlw ®3 H�1m V..] _f1..5,WJ 94 City of Cape Girardeau, Missouri DATA PROCESSING FUND SCHEDULE OF REVENUES AND EXPENSES— BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 197 41 VARIANCE FAVORABLE BUDGET ACTUAL UNFAVORABLE) OPERATING REVENUES InlerdepeNnentel wMcee $290,008 227.061 (522,9391 Other miscellaneous 9,300 $9,300 TOTAL OPERATING REVENUES 290,000 278,361 (13,839) OPERATING EXPENSES Parscnnel wMce. 6,497 59AM 8,67 Material. and suppli.. 6,515 8)99 (2,2B4) Contractual wMces 72,770 68$65 4,215 General operating expense. 2,424 5,341 (2,917) Capkel outlay 255,000 31 A40 223,160 TOTAL OPERATING EXPENSES 405,206 174,145 231,061 OPERATING INCOME (LOSS) (115,20(1) 102,216 217,422 NON—OPERATING REVENUE (EXPENSES) Interest Income — 13,475 13,475 Compensation for damages — 2,790 2790 Bond proceeds — 435,000 435,000 I..uence costs —1c 2723) (12723) TOTAL NON—OPERATING REVENUE (EXPENSES) 43,542 438,542 NET INCOME (LOSS) ($115,206) $540758 $655.964 41 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, 1991 96 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) OPERATING REVENUES Intard"unn natal eeMcae $893,000 $793,720 ($99,280) Othermiscelleneous 26 26 TOTAL OPERATING REVENUES 693,000 793,746 FJ9,254) a. OPERATING EXPENSES Personnel eeMoee 427,360 379,919 47,461 Metarlalsand supplee 271,335 239,354 31,981 Corimctual seMces 145,133 141,712 3,421 General operetln9 expenses 2,904 1,739 1,165 Intamal saints expense 3,545 2,014 1,501 Capital outlay 42,500 32,022 10,478 TOTAL OPERATING EXPENSES 892,797 796,790 96,007 OPERATING INCOME (LOSS) 203 (3044) (3247) NON—OPERATING REVENUE (EXPENSES) Interest income — 2,112 2,112 Pdndpal payments — (407) (407) Interest end Mndlirg coats — (1no) D WI TOTAL NON—OPERATING REVENUE(EXPENSES) — 1,W5 1,W5 NET INCOME (LOSS) 5203 ($1,439) 61.6421 96 VARIANCE FAVORABLE (UNFAVORABLE) $299,373 225 299,598 (44,457) (241,353( (285,810) 13,788 21.894 21,894 35,682 $35.682 City of Cope Olrmduou, Missouri EMPLOYEES' FRINGE BENEFIT FUND SCHEDULE OF REVENUES AND EXPENSES— BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1997 BUDGET ACTUAL OPERATING REVENUES InterdepaNnentel seMcee $964,913 $1 p64,286 Other mlseelbneoue 225 TOTAL OPERATING REVENUES 964,913 1,264,511 _ OPERATING EXPENSES Personnel wMcae 102,384 146,841 Coitr,ctual seMcee 781,163 1,(#2,516 r TOTAL OPERATING EXPENSES 883,547 1,16935] OPERATING INCOME (LOSS) 81,366 95,154 NON—OPERATING REVENUE (EXPENSES) Interest Income 40,000 61,094 TOTAL NON—OPERATING REVENUE (EXPENSES) 40,000 61,894 INCOME (LOSS) BEFORE OPERATING TRANSFERS 121,366 19,048 Operslirg transfer, out (173,500) (173500) NET INCOME (LOSS) 1$52.1341 ($16.452) r 97 VARIANCE FAVORABLE (UNFAVORABLE) $299,373 225 299,598 (44,457) (241,353( (285,810) 13,788 21.894 21,894 35,682 $35.682 City of Cape Glrwdoau, Missouri RISK MANAGEMENT FUND SCHEOULE OF REVENUES AND EXPENSES— BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED JUNE 30, 1997 VARIANCE FAVORABLE ACTUAL BUDGET $379,103 ($10,332) OPERATING REVENUES (10,332) 250,900 Interdepeltrnentel services $389,435 (4,890) TOTAL OPERATING REVENUES 389,435 123,313 OPERATING EXPENSES 69,934 44,934 Contracluel saNcas 1,115,000 $193247 General operating ezpeneee — TOTAL OPERATING EXPENSES 1,115,000 OPERATING INCOME (LOSS) (]25,565) NON—OPERATING REVENUE (EXPENSES) Interest Income 25,000 TOTAL NON—OPERATING REVENUE (EXPENSES) 25,000 NET INCOME (LOSS) 15]00565) y8 VARIANCE FAVORABLE ACTUAL (UNFAVORABLE) $379,103 ($10,332) 3]9,103 (10,332) 250,900 864,100 4,890 (4,890) 2M,790 859,210 123,313 848,878 69,934 44,934 69,934 44,934 $193247 $893,812 99 City of Caps Otr:u c;oau, MleseuH EQUIPMENT RI-I'MCEMENT FUND w SCHEDULE OF REVENUES AND EXPENSES - DODGE] AND AQTUAL (RUDOET BASIS) FOR THE FISCAL YUR ENDED JUNE 30, 1997 VARIANCE FAVORABLE WUGEI ACTUAL (UNFAVORABLE) OPERATING REVENUES Inteed.p.lDnental .anioa. 5329.323 352,39i'? Jj58:2{I � TOTAL OPERATING REVENUES _12&323 52,399 ns,924 OPERATING EXPENSES C:ap9alOWay 010.350 _ 213,997 - 596,353 TOTAL OPERATING EXPENSES _ 610,359 _ 213,997 598,353 i OPERATING INCOME (LOSS) 6102J)_ {1615911 Si9A29 NON-OPERATING REVENUE (EXPENSESI IMemi lneome - 7716 716 At. COmp.mallon for dam0R85 - 3,TItl 3,no umdpirmseG5 69&506 445,W0 (247,5W) InlemLL end handling coat. (116,500) - 118,500 L.Uann wet. _(103 (13430f066 rr TOTAL NON—OPERATING REVENUE (EXPENSES)563,650 `436_656 (121594 INCOME (LOSS) BEFORE OPERATING TRANSFERS (117,377) 274.458 391,835 Cpera9ng nnslor,l _117,377 161596 _ 44,221 NET INCOME (LOSS) _ E _ X9,36_ p56 436056 w 99 100 City of Cape Girardeau, Mitsoud AGENCYFUNDS COMBINING BAUNCE SHEET June W. 1997 (With Comparative Totals for June 30, 1996) Park Arena Deferred Development Totals Ubrary Improvement Compensation Foundetlon 6-30-97 a-30-98 ASSETS Cash and cash equNeiente S395,339 $20,495 $ - §59,947 3475,761 5498,905 ImesMenN - - 2,105,065 - 2,105,065 1,598,987 Rece"bles, net of allowances for doubtful rmelvablee Real eget. tax 15,473 - - - 15,473 16,256 Personal property test 3,962 - - - 3,962 2,825 Other moolvables 102 102 7,804 Total wets $414,876 $2,495 §2105085§59�Q $2,60,383 $2,124777 UABIUTIES Accounts payable $9,446 3- $- $- $9,446 $W,251 Aoomed IIabllNes Bated., payroll taxa. and benefac 9,323 — — — 9,323 10,620 Other llebllifl. 396,10] 20,495 — 59,97 76,549 419,919 Advance from other funds — — — — — 75,000 Deferred compensation due emptoyaes 2,105,065 2,105,065 1,59,987 Total liabilities $414,876 320.495 §2,105,065 E 52.600,383 $2.12/777 100 CBYol4epe a—deeu. nle.oud m.m Co INwa RTA) WWOFCHANCESINASSETSANDLIA LmER 04.7x] ALL AGENCY FONDS FOR THE EIOGLTEAR ENOEO LNE S0. 1807 P-1 Alone MeneE 0.wl,-d Llb 1 1 e�—..d Caw rounaeual Tom A99E1H 2,804 Cash _df mob..Ndxl. ei«Imenb Acebebr, nd of I—c«1x cl-Mul recolu be Raw.... Rdsmd PWmry ml OBw lacaNNr T"«Me At Jet, 1.1008 AedWom CM end —4 ..N.. Rec"blo ., notwenm. dello cl-Wul b " ..l«eNWb. A b W Alemel POM11Y lea ouw a«dvebb. Ceeb end mob.,Nebnb Iweetmenh N%ehabb, nM delonenu Iv dalN ".lN1Ene R,W nom RopellYna 0.rr.Nvebbe CM end mb..N.. Iw.ebronb , d-b.l. nd dJwrenc« In Reales wNvmb. Reales... m p«eneel PmerlY.e ONer receNWbe T.. as. al Jun. ]0. 1001 LMWIMN eM«c... Jdv 1 I m Acade. PYebb .Creed 1..... Seam, canal I.w and bmebb Cmx I.b81b. A... bom Ma Md. pbrmd wmpee. on due emple3ee. T.I. RB a JuIY 1, 1811 Addm.. Accmecl Accweb Ilda. SNII«, pYlNl lid3 Hld bfBmY AA ce Aemnee rtomom ansa b edls d a D.brmmmven..nm os emvlorm« Tatledd.e- DoledmL Accum.mpbb aehalu. peydod.«. eed bendh Mx.blly. A. -nam Mer Mde u rmdmmvee.eumdueemvio5ses T. delMiw. S,ueves . n88 1) A..e,Seed. PYeb. ' erlle flit. v. nd Oenma Ad .-h✓m Adxnce nom Mer bods .—d wmv.e«6w ane CmvloYe.. Tut 1114.11... Juin m, 166) .98250 m.m e- 04.7x] 1 W t 7 ,me,ofi 1e250 - - - 10259 2,804 2,804 "MI. ,n2 it m e) iB] 1 t31 {Bt9,6y {33,311 {- {BT wI {)St,WI om6]e - ode A)6 470.050 4.,M 111.77 m - w n2]61`m X09 ywt P.P.{I ee2]se] 6x7,111 i- 9lzaan am.ns tro,61B 1W,BtB 511 ...7 µ)1,)01 2,111,113 - i.l 11.11! 15173 tp1 - 102 14679 E20— 1W085 FSB B4) QBW]At 1N¢51 f- t- t- iAR31 mtp .7) 21sT, - .72. 418.018 RApoo - - ]l D. 1,580¢]) 1.560.69) HIS _115 .n2 111.187 se)S T f2 fy41 f25f,511 #7,112 i- f302m f]O1 X10 x]46]4 - - - 2]404 411.]8] 2Bpz) - 120)6 571,2]] 602 AWB W0,078 M2. 81$73P VeA.. .71,1I i- 630311 p13.n4 2]5..71 ],82,534 ]I A. - 1.All 47.,9v1 fel�M X810 6- il�l91 SI Ism 19 {fi A4! 6- t- 6- EBA49 6.]YJ x,10)07 40.065 - BB047 4I9$K - ��m3 21yM`N5 WB`> X6'1 101 r City of Cape Girardeau, Missouri SCHEDULE OF GENERAL FIXED ASSETS BY SOURCE June 30, 1997 GENERAL FIXED ASSETS Land $2,073,938 Buildings 8,867,406 Improvements other than buildings 4,527,283 Machinery and equipment 1,555,874 Contruction in progress 5,208 TOTAL GENERAL FIXED ASSETS $17 029 709 INVESTMENT IN GENERAL FIXED ASSETS BY SOURCE General fund $4,008,487 Special revenue funds 10,588,676 Capital projects funds 2,432,546 TOTAL INVESTMENT IN GENERAL FIXED ASSETS J17,0 29,709 102 City of Cape Guards.., Missouri 103 SCHEDULE OF GENERAL FIXED ASSETS - BY FUNCTION AND ACTIVITY June 30, 1997 se Improvements Machinery Construction Other Then and In Function and Activity Land Buildings B.ildings Eguipmont Progress Total ADMINISTRATIVE SERVICES Human msources f- E- E- $1,169 $- $1,169 City manager 200,000 111,618 - 2,333 - 313,951 City attorney - - - 1,160 - 1,180 Intardepadmental 67,340 - 32,190 23,266 - 122,798 Fin... - - - 1,135 - 1,135 CVB - - - 6,253 - 6,253 Airport 354,649 181,044 3,856,430 232,048 4,624,171 ass TOTAL ADMINISTRATIVE SERVICES 621,989 292,662 3,868,620 267,386 50]0,65] DEVELOPMENT SERVICES Planning services - - - 5,232 - 5,232 Inspection services - - - - - 0 Community information program - - - 1,307 - 1,307 Engieering..Mona 44,337 44,337 as TOTAL DEVELOPMENT SERVICES 50,876 50,876 PARKS AND RECREATION Park maintenance 855,238 192,704 - 105,786 - 1,153,728 ass Arena maintenance - - - 22,620 - 22,620 Recreation - - - 364 - 364 Cemetery 4,120 4,544 - 28,567 - 37,231 Central pool - 625,057 2.226 4,049 - 631.332 C.paha pool - - 6,178 - - 6,08 Osage Community Centre - 2,744,610 - 45,036 - 2,789,646 Softball Comple, 2,476,058 6,]6] 2,482,825 TOTAL PARKS AND RECREATION 859,358 6,042,973 8,404 213,189 7,123,924 PUBLIC SAFETY Mlnlclpal crud - - - 441 - 441 Health - - - 15,286 - 15,286 Police 17,500 237,500 1,686 8],1]4 - 343,860 Fire 210,950 841,410 8,237 550,989 1,611,586 TOTAL PUBLIC SAFETY 228,450 1,0]8,910 9,923 653,890 1,9]1,1]3 PUBLIC WORKS Street - - - 278,964 - 278,964 Stormweter 91,569 91,569 as TOTAL PUBLIC WORKS 370,533 370.533 CAPITAL OUTLAY General capital Improvements 10,000 1,413,972 551,235 - 5,208 1,980,415 as Park Improvements 354,141 36,889 69,101 462,131 TOTAL CAPITAL OUTLAY 364,141 1,452,861 620,336 5,208 2.442.546 ` TOTAL GENERAL FIXED ASSETS $2,073,938 $6 86] 406 $4,527,283 $1,555,874 $5,208 $17,029,709 103 104 City of Cape Kdrwiloau, Missoxrl SCHEDULE OF CHANGES IN GENERAL FIXED ASSETS - BY FUNCTION AND ACTIVITY FOR THE FISCAL YEAR ENDED JUNE M. 1 MY Genera] Feed General Rred Assets Depre.ImM Assets Func on and Activity June 30 1996 Add9ona Deduclims EES June 30, 1997 ADMINISTRATIVE SERVICES a FUmen resort.. E- SI,385 E- $216 $1,169 City manager 324,505 - - 10,554 313,951 City eOOneY - 1,452 - 272 1,180 IMardapadmentel 95,119 32,]35 - 5,058 122,798 Flrence 1,426 - - 291 1,135 CVB 4,265 2,983 - 995 6,253 Mrpw 2,205543 2,589,6]] 172,049 4.624,171 TOTAL ADMINISTRATIVE SERVICES 2,631,858 2,628,232 189,433 5,0]0,65] _ DEVELOPMENT SERVICES PIBMhg seMWB 7,127 - - 1,695 5232 lupecibn aervl.e 917 - - 917 0 Commvlity lMomellon saNce - 1,400 - 93 1,307 Engineedn9..M.c . 53,129 1,480 10272 44,337 TOTAL DEVELOPMENT SERVICES 61,173 2,860 13,1]7 50,876 r PARKS AND RECREATION Pak malmarance 1,204,493 8,930 2.782 56,913 1,153,728 Arena maintenance 1,208 23,650 - 2,238 22,620 Reoaatlm 02 6 - - 238 364 ++ Cemetery 41,010 4,939 1,806 6,912 37,231 Camel pool 65],]14 2,313 - 28,695 6311= Oapshe pool - 6,336 - 156 6,178 Osage Community Came - 2,806,533 - 16,887 2,769,646 Soltnie Complex 2,496,895 14,070 2,462,825 TOTAL PARKS AND RECREATION 1,905,027 5,349,596 4,588 126,111 7,123,924 PLIC SAFETY Municipal could 576 - - 135 441 HeeM 15,417 4,315 - 4,446 15,286 Poli. 425,743 7,436 - 89,319 343,860 File 1)350]5 6,087 129,576 1,611,586 TOTAL PUBLIC SAFETY 2,176,811 17,838 223,476 1,971,173 PUBLIC WORKS Steel 294,608 60,067 - 75,731 278,964 Srrmw w 78,302 43,530 W.Mi 91,569 TOTAL PUBLIC WORKS 372,918 183,617 185,994 370,533 CAPITAL OUTLAY Gerleml cepiml Improvements 6,55$924 3,349,795 7,842,125 81,179 1,980,415 Park rnpr ments 470,817 81686 462,131 TOTAL CAPITAL OUTLAY 7,024741 3,349795 7,842,125 89,865 2,442,546 TOTAL GENERAL FIXED ASSETS $141]2520 j11.451.95875.846.713 x]48056 51]029]09 104 City of Cape Girardeau, Missouri r SCHEDULE OF CHANGES IN LONG—TERM DEBT FOR THE FISCAL YEAR ENDED JUNE 30, 1997 General General Long—term Long—term Debt Debt July 1. 1996 Additions Retirements June W. 1997 GENERAL LONG—TERM DEBT Leasehold revenue bonds payable $10,214,870 $— $2,430,876 $7,783,994 CertlBcates of panlcipallon payable 3,325,000 2550,000 170,000 5,705,000 General obligation refunding bonds payable 3,390,000 — 327,000 3,070,000 Accrued benefits 545,991 — 1,928 544,063 Due to other governments—State energy loan 81,841 — 30,172 51,669 TOTAL GENERAL LONG—TERM DEBT $17,557702 $2,550,000 $2,952,976 $17,154,726 105 City of Cape Girardeau, Missouri STATEMENT OF GENERAL LONG—TERM DEBT JUNE 30, 1997 10104 $1,843,362 AMOUNT AVAILABLE AND TO BE PROVIDED FOR THE 5,940,633 PAYMENT OF GENERAL LONG—TERM DEBT LEASEHOLD REVENUE BONDS Amount available In debt service fund 5,705,000 Amount to be provided 864,397 CERTIFICATES OF PARTICIPATION 2205,603 Amount available In debt service fund Amount to be provided 544,063 GENERAL OBLIGATION REFUNDING BONDS 51,669 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 _ Amount available In debt service fund Amount to be provided TOTAL AMOUNT AVAILABLE AND TO BE PROVIDED GENERAL LONG—TERM DEBT PAYABLE o Leasehold revenue bonds payable Cert9lcates of participation payable General obligation refunding bonds payable Accrued benefits Due to other governments—Stale energy loan TOTAL GENERAL LONG—TERM DEBT PAYABLE 10104 $1,843,362 5,940,633 $7,783,994 813,276 4,891,724 5,705,000 864,397 2205,603 3,070,000 544,063 544,063 51,669 51,669 $17154 226 $7,783,994 5,705,000 3,070,000 544,063 51,669 $17 154 726 Begley, Janssen, Young & Birk, LC CERTIFIED PUBLIC ACCOUNTANTS a 2103 THEMIS ST CAPE GIRARDEAU, MISSOURI 63701 TELEPHONE (573)3342845- FAR(573) 3344338 PARTNERS JOHN R. JANSSEN. CPA JENNIFER WESTRICH, CPA TERRY R. BEGLEY. CPA JEFF UNTERREINER, CPA LAWRENCE E. YOUNG. CPA CATHERINEA. WHITE KELVIN W. BIRK. CPA INDEPENDENT AUDITORS' REPORT ON COMPLIANCE ,o WITH REQUIREMENTS APPLICABLE TO EACH MAJOR PROGRAM AND INTERNAL CONTROL OVER COMPLIANCE IN ACCORDANCE WITH OMB CIRCULAR A-133 Honorable Mayor and Members of the City Council Cape Girardeau, Missouri Compliance We have audited the compliance of the City of Cape Girardeau, Missouri with the types of compliance requirements described in the U.S. Office of Management and Budget (OMB) Circular A-133 Compliance Supplement that are applicable to each of its major federal programs for the year ended June 30, 1997. The City of Cape Girardeau, Missouri's major federal programs are identified in the summary of the auditor's results section of the accompanying schedule of findings and questioned costs. Compliance with the requirements of laws, regulations, 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 opinion on the City of Cape Girardeau, Missouri's compliance based on our audit. We conducted our audit of compliance in accordance with generally accepted auditing standards; the standards applicable to financial audits contained in Government Auditing_ Standards, issued by the Comptroller General of the United States; and OMB Circular A-133, "Audits of States, Local Governments, and Non -Profit Organizations". Those standards and OMB Circular A-133 require that we plan and perform the audit to obtain reasonable assurance about whether noncompliance with the types of compliance requirements referred to above that could have a direct and material effect on a major federal program occurred. An audit includes.examining, on a test basis, evidence about the City of Cape Girardeau, Missouri's compliance with those requirements and performing such other procedures as we considered necessary in the circumstances. We believe that our audit provides a reasonable basis for our opinion. Our audit does not provide a legal determination of the City of Cape Girardeau, Missouri's compliance with those requirements. - In our opinion, the City of Cape Girardeau, Missouri complied, in all material respects, with the requirements referred to above that are applicable to each of its major federal programs for the year ended June 30, 1997. 108 Honorable MayorandMembers of the City Council City of Cape Girardeau, Missouri Page 2 Internal Control Over Compliance The management of the City of Cape Girardeau, Missouri is responsible for establishing and maintaining effective internal control over compliance with requirements of laws, regulations, 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 w could have a direct and material effect on a major federal program in order to determine our auditing procedures for the purpose of expressing our opinion on compliance and to test and report on internal control over compliance in accordance with OMB Circular A-133. our consideration of the internal 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 not reduce to a relatively low level the risk that noncompliance with applicable requirements of laws, regulations, contracts and grants that would be material in 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 material weaknesses. Schedule of F,ggPndikures o�deral Awards. We have audited the general purpose financial statements of the City of Cape Girardeau, Missouri as of and for the year ended June 30, 1997, and have issued our report thereon dated November 20, 1997. Our audit was performed for the purpose of forming an +• opinion on the general purpose financial statements taken as a whole. The accompanying schedule of: expenditures of federal awards is 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 ail material respects, in relation to the general purpose financial statements taken as a whole. This 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 & BIRK, LC Cape Girardeau, Missouri November 20, 1997 109 M Begley, Janssen, Young & Birk, LC CERTIFIED PUBLIC ACCOUNTANTS 2103 THEMIS ST CAPE GIRARDEAU, MISSOURI 63701 TELEPHONE (573) 30 2B,I5-FAX (5)3)33,14338 PARTNER$ r JOHN R. JANSSEN. CPA JENNIFER WE$TRICH, CPA TERRY R. BEGLEY CPA JEFF UNTERREINER, CPA LAWRENCE E YOUNG. CPA CATHERINE A. WHITE KELVIN W. BIRK, CPA INDEPENDENT AUDITORS' REPORT ON COMPLIANCE AND ON INTERNAL CONTROL OVER FINANCIAL REPORTING BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN r ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS Honorable Mayor and Members of the City Council City of Cape Girardeau, Missouri We have audited the financial statements of the City of Cape Girardeau, Missouri as of and for the year ended June 30, 1997, and have issued our report thereon dated November 20, 1997. We conducted our audit in accordance with generally accepted auditing standards and Government Auditing Standards, issued by the Comptroller General of the United States. Compliance As part of obtaining reasonable assurance about whether the City of Cape Girardeau, Missouri's financial statements are free of material misstatement, we performed tests of its compliance with certain provisions of laws, regulations, contracts and grants, noncompliance with which could have a direct and material effect on the determination of financial statement amounts. However, providing an opinion on compliance with those provisions was not an objective of our audit and, accordingly, we do not express such an opinion. The results of our tests disclosed no instances of noncompliance that are required to be reported under Government Auditing Standards. of Over Financial Report In planning and performing our audit, we considered the City of Cape Girardeau, Missouri's internal control over financial reporting in order to determine our auditing procedures for the purpose of expressing our opinion on the financial statements and not to provide assurance on the internal control over financial reporting. However, we noted a certain matter involving the internal control over financial reporting and its operation that we consider to be a reportable condition. Reportable conditions .. involve matters coming to our attention relating to significant deficiencies in the design or operation of the internal control over financial reporting that, in our judgment, could adversely affect the City of Cape Girardeau, Missouri's ability to record, process, summarize and report financial data consistent with the assertions of management in the financial statements. The reportable condition is described in the accompanying schedule of findings and questioned costs. 110 Honorable Mayor and Members of the ,r 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 material in 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. r This 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 & BIRK, LC Cape Girardeau, Missouri November 20, 1447 111 Federal Expenditures $ 447,830 252,969 195.580 896.37) 4,000 4.005 8,005 130,529 51,774 41,838 291280 515.421 3,263 13.000 531.684 39,608 13,915 221,846 272.045 547,414 City of Cape Girardeau, Missouri SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS June 30, 1997 Federal Program Federal Grantor/Pass-through CFDA or Award Grantor/Program Title Number Amount Department of Commerce Economic Development Administration Sudden and Severe Economic Dislocation Implementation Project Water Plant #1 11.307 $ 729,750 Wastewater Treatment Plant Access & Power Supply 11.307 392,000 Sprigg Street Elevation 11.307 425,750 Total Department of Commerce Department of Education Passed through Missouri Department of Education Passed through Cape Girardeau Public Schools Drug Free Schools Program 84.186 4,000 .� Passed through Missouri Slate Library Library Services & Construction Program 84.034 4,005 Total Department of Education Department of Housing and Urban Development Passed through Missouri Dept of Economic Development Community Development Block Grants 94 -ND -02 Locust/Maple 14.219 435,176 95 -ND -02 Locust/Maple 14.219 350,000 95 -ED -27 D & K Wholesale Drug 14.219 70,229 94 -DR -96 Flood Buyout Program 14.219 760,000 Subtotal R91 -SG -29-0103 Rental Rehab 14.230 171,070 Passed through Missouri Dept of Social Services Emergency Shelter Grant 14.231 13,000 Total Department of Housing and Urban Development r Department of the Interior Environmental Protection Agency Passed through Missouri Dept of Natural Resources SRF Loan Series 1991 A C295004-01 66.458 - SRF Loan Series 1993A C295004-02 66.458 - SRF Loan Series 1995D C295229-01 66.458 - SRF Loan Series 1996D C295229-02 66.458 - Subtotal 112 Federal Expenditures $ 447,830 252,969 195.580 896.37) 4,000 4.005 8,005 130,529 51,774 41,838 291280 515.421 3,263 13.000 531.684 39,608 13,915 221,846 272.045 547,414 113 City of Cape Girardeau, Missouri SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS June 30, 1997 Federal Program Federal Grantor/Pass-through CFDA or Award Federal Grantor/Program Title Number Amu n Expenditures Department of the Interior (Continued) Federal Emergency Management Agency Hazard Mitigation Assistance 83.519 $1,480,585 $1,128,172 Emergency Assistance 83.516 - 21.838 Total Department of the Interior 1697.424 Department of Justice Passed through Missouri Dept of Public Safety Victims of Crime Act (TY '95) 16.575 5,000 2,320 Victims of Crime Act (FY '96) 16.575 7,622 3.544 Total Department of Justice 5.864 .. Department of Transportation Federal Aviation Administration Airport Runway Remarking 953-77A 20.106 35,244 35,244 Airport Reconstruction & Expansion 935-77A 20.106 2,296,856 319,933 Subtotal 355,177 Federal Highway Administration Passed through Missouri Highway & Transportation Dept Off -System Bridge Replacement & Rehabilitation _ Hopper Road Bridge - BRO-BRM-016(18) 20.205 32,608 899 South Sprigg Street Bridge- FALL flM-1518(004) 20.205 451,960 378.355 Subtotal 379,254 Community Traffic Safety Program - 96-CP-09-07 20.600 59,750 34,500 Safe Communities Grant - 96-SA-09-8 20.600 104,647 30,940 Safe Communities Grant - 97-SA-09-2 20.600 160,520 52.422 Subtotal 117,862 + Public Taxi Coupon Transportation - MO- 18-X016-4CG 20.509 98,181 92,350 National ISE TE Recreation Trails Funding Program 20.219 449,600 89,570 Community Team Spirit Conference 20.601 40,000 4.515 Total Department of Transportation 1.038 728 TOTAL FEDERAL EXPENDITURES $4.178.084 113 114 THE CITY OF CAPE GIRARDEAU, MISSOURI SCHEDULE OF FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 1997 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 on 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 on compliance for the major federal award programs for the City of Cape Girardeau, Missouri expresses an unqualified opinion. 6. The programs tested as major programs included: Department of Housing and Urban Development Community Development Block Grants CFDA # 14.219 Department of the Interior Federal Emergency Management Agency CFDA # 83.519 Department of Transportation Federal Highway Administration CFDA # 20.205 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. 114 SCHEDULE OF FINDINGS AND QUESTIONED COSTS CONTINUED PAGE 2 B. FINDINGS -FINANCIAL STATEMENTS AUDIT 1. Cash Receipts Condition: The duties of handling cash receipts are not properly segregated. One individual is responsible for depositing daily receipts, reconciling the bank account and authorizing bank wire transfers. Criteria: Internal controls should be in place that provide reasonable assurance that receipts are properly deposited, wire transfers authorized and bank accounts independently reconciled. Effect: The lack of segregation of duties could result in undetected cash shortages. Recommendation: Procedures should be implemented to require the bank reconciliation function be completed by a person separate from the receipt and deposit functions. Also, procedures should be implemented to ensure that the City's bank confirms all wire transfers with the Finance Director, as previously agreed. Response: We concur with the recommendation. Such procedures will be implemented. 115