The URL can be used to link to this page

Home My WebLink About2001-2002.AuditReportCITY OF CAPE GIRARDEAU, MISSOURI FINANCIAL STATEMENTS June 30, 2002 BEUSSINK, HEY, ROE, SEABAUGH & STRODER, L.L.C. Certified Public Accountants CITY OF CAPE GIRARDEAU MISSOURI TABLE OF CONTENTS FINANCIAL SECTION Paee No. INDEPENDENT AUDITORS' REPORT 1-2 GENERAL PURPOSE FINANCIAL STATEMENTS COMBINED BALANCE SHEET—ALL FUND TYPES AND ACCOUNT GROUPS 3-4 COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE—ALL GOVERNMENTAL FUND TYPES 5 COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE — BUDGET (BUDGET BASIS) AND ACTUAL - ALL GOVERNMENTAL FUND TYPES 6-7 COMBINED STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS —ALL PROPRIETARY FUND TYPES 8 COMBINED STATEMENT OF CASH FLOWS — ALL PROPRIETARY FUND TYPES 9 NOTES TO FINANCIAL STATEMENTS 10-53 COMBINING AND INDIVIDUAL FUND STATEMENTS GENERAL FUND 54 COMPARATIVE BALANCE SHEET SCHEDULE OF REVENUES AND EXPENDITURES BUDGET AND ACTUAL (BUDGET BASIS) 55 SPECIAL REVENUE FUNDS COMBINING BALANCE SHEET 56 COMBINING STATEMENT OF REVENUES, EXPENDII ORES AND CHANGES IN FUND BALANCE 57 CONVENTION/VISITORS SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES — BUDGET AND ACTUAL (BUDGET BASIS) 58 0 w AIRPORT SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) 59 DOWNTOWN BUSINESS DISI 'RICTSPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES -BUDGET AND ACTUAL (BUDGET BASIS) 60 PARKS AND RECREATION SPECIAL REVENUE FUND .. SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) 61 HEALTH SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES -BUDGET AND ACTUAL (BUDGET BASIS) 62 MOTOR FUEL TAX SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET - AND ACTUAL (BUDGET BASIS) 63 CAPITAL IMPROVEMEN"I SALES TAX SPECIAL REVENUE FUND FLOOD CONTROL PROJ ECTS SCHEDULE OF REVENUES AND EXPENDITURES- BUDGET AND ACTUAL.., (BUDGET BASIS) 64 CAPITAL IMPROVEMEN"L SALES TAX SPECIAL REVENUE FUND WATER PROJECTS SCHEDULE OF REVENUES AND EXPENDITURES -BUDGET AND ACTUAL (BUDGET BASIS) 65 CAPITAL IMPROVEMENT SALES TAX SPECIAL REVENUE FUND SEWER SYSTEM IMPROVEMENTS SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL.. (BUDGET BASIS) 66 'I RANSPORTAITON SALES TAX TRUST SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES -BUDGET AND ACTUAL (BUDGET BASIS) 67 TRANSPORTATION SALES TAX TRUST II SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES -BUDGET AND ACT URAL (BUDGET BASIS) 68 FLOOD PROTECTION SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) 69 w VISION 2000 SPECIAL REVENUE FUND _ SCHEDULE OF REVENUES ,AND EXPENDITURES - BUDGET SCHEDULE OF REVENUES AND EXPENDITURES - AND ACTUAL BUDGET BASIS) 70 DEBT SERVICE FUND COMPARATIVE BALANCE SHEET 71 CAP 'AL PROJECT FUNDS COMBINING BALANCE SHEET 72 r COMBINING STATEMENT OF REVENUES, EXPENDITURES AND AND ACTUAL (BUDGET BASIS) CHANGES N FUND BALANCE 73 GENERAL CAPITAL IMPROVEMENT FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) 74 CORI' FLOOD CONTROL. CAPITAL PROJECT FUND SCHEDULE OF REVENUES AND EXPENDITURES- BUDGET AND ACTUAL (BUDGET BASIS) 75 STREET IMPROVEMENTS FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) 76 FAU STREET GRANTS FUND SCHEDULE OF REVENUES AND EXPENDITURES -BUDGET AND ACTUAL. (BUDGET BASIS) 77 COMMUNITY DEVELOPMENT BLOCK GRANT FUND y SCHEDULE OF REVENUES AND EXPENDITURES - BUDGE `F AND ACTUAL (BUDGET BASIS) 78 PARKIMPROVEMENTSFUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) 79 WATER IMPROVEMENT PROJECTS SCHEDULE OF REVENUES AND EXPENDITURES -BUDGET AND ACTUAL. (BUDGET BASIS) 80 EN'I ERPRISE FUNDS COMBINING BALANCE SHEET81 COMBINING STATEMENF OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS 82 COMBINING STATEMENT OF CLASH FLOWS 83 SEWER FUND SCHEDULE OF REVENUES AND EXPENSES - BUDGET AND ACTUAL (BUDGET BASIS) 84 WATER FUND SCHEDULE OF REVENUES AND EXPENSES -BUDGET AND ACTUAL (BUDGET BASIS) 85 ,. SOLID WASTE FUND .. SCHED13LEOFREVENUES AND EXPENSES -BUDGET 93 AND ACTUAL (BUDGET BASIS) 86 ... GOLD COURSE FUND SCHEDULE OF REVENUES AND EXPENSES - BUDGET 94 AND ACTUAL (BUDGET BASIS) 87 RISK MANAGEMENT FUND SOFTBALL COMPLEX FUND SCHEDULE OF REVENUES AND EXPENSES - BUDGE`F 95 AND ACTUAL (BUDGET BASIS) 88 INTERNAL SERVICE FUNDS COMBINING BALANCE SHEET 89 COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS 90 COMBINING STATEMENT OF CASH FLOWS 91 DATA PROCESSING FUND SCHEDULE OF REVENUES AND EXPENSES - BUDGET AND ACTUAL (BUDGET BASIS) 92 FLEET MANAGEMENT FUND SCHEDULE OF REVENUES AND EXPENSES -BUDGET AND ACTUAL., (BUDGET BASIS) 93 EMPLOYEES' FRINGE BENEFIT FUND SCHEDULE OF REVENUES AND EXPENSES -BUDGET AND ACTUAL.. (BUDGET BASIS) 94 RISK MANAGEMENT FUND SCHEDULE OF REVENUES AND EXPENSES - BUDGET . AND ACTUAL (BUDGET BASIS) 95 EQUIPMENT REPLACEMENT FUND SCHEDULE OF REVENUES AND EXPENSES - BUDGET AND ACTUAL (BUDGETBASIS) 96 w AGENCY FUNDS COMBINING BALANCE SHEET 97 COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES -ALL AGENCY FUNDS 98 FIXED ASSETS SCHEDULE OF GENERAL FIXED ASSETS -BYSOURCES 99 SCHEDULE OF GENERAL FIXED ASSETS -BY FUNCTION AND ACTIVITY 100 SCHEDULE OF CHANGES IN GENERAL FIXED ASSETS - BY FUNCTION AND ACTIVITY 101 LONGtERM DEBT SCHEDULE OF CHANGES IN LONG-TERM DEBT 102 STATEMENT OF GENERAL LONG-TERM DEBT 103 SINGLE AUDIT SE " ION REPORT ON COMPLIANCE WITH REQUIREMENTS APPLICABLE TO EACH MAJOR PROGRAM AND INTERNAL CONTROL OVER COMPLIANCE 1N ACCORDANCE WITH OMB CIRCULAR A -I33 104-105 REPORT ON COMPLIANCE AND ON INTERNAL CONTROL OVER FINANCIAL REPORTING BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS 106-107 SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS 108-110 NOTES TO SCHEDULE OF EXPENDITURE OF FEDERAL AWARDS 111 SCHEDULE OF FINDINGS AND QUESTIONED COSTS 112.113 SUMMARY SCHEDULE OF PRIOR AUDIT FINDINGS 114 BEUSSINK, HEY, ROE, SEABAUGH & STRODER, L.L.C. Certified Public Accountants 4018 Sycamore 16 So. Silver Springs Road Y Missouri ri Hope Cairo, Illinois 62914 Cape Girardeau, Missouri 63703 Telephone 618 734-3300 Telephone 573 334-7971 Jackson, Missouri 63755 P ( ) P ( ) Telephone (573)243-3991 Facsimile (618) 734-3303 Facsimile (573) 334-8875 Facsimile (573)143-3186 INDEPENDENT AUDITORS' REPORT Honorable Mayor and Members of the City Council City of Cape Girardeau, Missouri We have audited the accompanying general purpose financial statements of City of Cape Girardeau, Missouri, as of and for the year ended June 30, 2002, as listed in the table of contents. These general purpose financial statements are the responsibility of the City'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 auditing standards generally accepted in the United Slates of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the general purpose financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the general purpose financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall general purpose financial statement presentation. We believe that our audit provides a reasonable basis for our opinion. In our opinion the general purpose financial statements referred to above present fairly, in all material respects, the financial position of City of Cape Girardeau, Missouri as of June 3Q 2001 and the results of its operations and the cash flows of its proprietary fund types for the year then ended, in conformity with accounting principles generally accepted in the United States of America. In accordance with Government Auditing Standards, we have also issued a report dated November 4, 2002, on our consideration of the City's internal control over financial reporting and our tests of its compliance with certain provisions of laws, regulations, contracts, and grants. That report is an integral part of an audit performed in accordance with Government .Judiiin„ Standards and should be read in conjunction with this report in considering the results of our audit. Our audit was performed for the purpose of forming an opinion on the general purpose financial statements taken as a whole. The combining and 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 City of Cape Girardeau, Missouri. The accompanying schedule of expenditures of federal awards is presented for proposes of additional analysis as required by U.S. Office of Management and Budget Circular A-133, Audits of States, Local Governments, and Non-Prola Organizations, and is also not a required part of the general purpose financial statements of 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 stated in all material respects, in relation to the general purpose financial statements taken as a whole. BEUSSINK, HEY, ROE, SEABAUGH & STRODER, L.L.C. n Cape Girardeau, Missouri November 4, 2002 2 GENERAL PURPOSE FINANCIAL STATEMENTS 0 0 1 1 I 1 1 1 i { 1 1 1 1 i City If GiIIIIII COM91NE0 BALANCE SHEET ALL FUND TYPES AND ACCOUNT GROUPS June 30, 2002 THI-Ar, Gnr ill Fund rr na Types Pum "I Aaa m cr General General Spealal Bell CAP,lal Inlemal Flxed Long-Termiolale M-1-d m Only) con"eve- S-Au Poet= En,� Be'..e Afeeto g-Me pet= 06130/02 Weld, ASSETS AND OTHER DEBITS Asscle: In- I'lnz $2P10Ill 5OSI6,e32 S82'23d $5029,E52 $2 E6 5231, dB $¢21,193 S ¢ S2OJo2,026 $22,2]9,195 NCIKane d Ef1h con , enE - - 923540 BJob ill ,C75 19388 11 do 1 - 10 No' FnpvJ lme TAH, - - 93212E '5b,363 231,721 - 7413550 1,372516 14, 1 254 ncI01 All ..'ancee Iw 814110 RIll ez es' c� pe local prcbeM cn a nls c¢ .e 39 867 IS. 22,049 - - 21796 - - 95581 71E13 $ales lax 128716 522854 1951570 1.213,896 d ¢bu-,leape 1,258,123 - _ _ _ - - 1258.126 1 "1 lil Novel--1,In, le"'We - 58,961 - _ _ _ L-, ort EA r,celva lle - fi9,3ID - _ _ - - - - - IS Ili 69,310 1ITT 5635 U:llycb,,q sre Ivbble 1 b8ill - ".138.196 "2C'. 544 Buere'ass es1b,1A exivaoe 344,529 433,323 356.936 73037 503,536 - - - - '567 1,493.100 -' wile 395,397 1,929 15119 1323 252[0 Q2 66 - - JIf 450,034 Olnerrbr,,lez P,290 176,366 210 _ 112,363 43,404 11 - - 1,350193 452951 L56 214 lvgooemno nurlrecavabins IMoSr4e , ler W 5319 - d345C E6IPA Aalcr typica be,ee lees - 14550 - - - - - 14554 15,195 1 � - 11116 - , 2'566 21222 G-P,¢cattyGez 79 TIT 231 749 165509 18525 - - - 594551 H., Olin, S ade wa'o,:o 111. - - _ _ _ - - A, J10 769525 - ollll, Olber Nide 1,667,500 - _ 140030 - - - 1,S02,500 IEET.SJ0 i - 115 65052 - - 135715 1830 - - - 200787 191,416 Re;.f Cod aezelz 'eeb and COST eOw Men, - - - - 122157 59 - - 122,246 Not lolled I ...1-le - - _ 1771W4 1 7 727,974 131250 13,944,064 Pn,ICC azn and 111.111"He - _ _ 1,520,566 - - 1520,516 1752,110 P„edlle- 81,66E 31130 - - 598,275 PI13 - - - 128 SE1 803,512 H,cc ee¢e'S Lou of ece mule leo Indica aron - - - _ 83170,Ill 1243363 - 1A550,926 - 99,9E9Ill 92,351,189 iddec A11.11 J-1,11d lir l,lt- ce _ _ _ - - - 2787,504 2787 504 2p23,954 ATocrtto beO-d CT to, letirri of-e na-terndebt - - - - - - - 29,780.1 83 15 ]30,i b3 294194/5 Am non p�dr]el for If- wpayn..1 ...... 1of mc.oeneeled.1.Bnme 7-0856 730555 591421 TOT" ¢neem an10N e1 idble '1' 9I6 613231355 TV ITE $1191.379 $101907639 $4.G43 5,09' $46W b321l 143 5190159589 -16 _BJ 5185YR_09^,203 11It NGTES TO THE FINANCIAL 5iA1 FMENTS ARE AN'MEGRAL PART OF THIS STATEMENT i 1 i t 1 1 1 1 1 i Y 1 Y i t t i 1 t Pty or cape Gi,a.aeao. Mlesoan COMBINED BALANCE SHEET ALL FUND TYPES ANO ACCOUNT GROUPS Jpne ]0. 2002 Flood aly Govemmealal rona Types Proorl rvIttl Types Fane Type Accoao z Goaera, Genual Special Debt Capital Imam., HIM Long-Tem Totals Memorandum Opv Genera palSconce Pm)e End Service Aoencv Ad is Debt filo 30 00 06130101 LIABILITIES, EQUITY AND OTHER CREDITS 'AddIdIde A..... R pe,f,,A $371,91.1 $1. 2]9 S $516,162 56641765 SEDGTw $37 131 S $- $2]06,190 $3511]21 ACCITed liab, It 11 Sale, es. 111`11 Imes all Ce^elrya 1601] 29,367 - - 11',482 23309 1,127 - )30,➢56 926,330 066,037 Nines o9,,. - $ Gayafe - 3291 7.722 - 7.C17 2570 _ _ _ ] 00]559 III 1.57 7, OPULableias 16,153 21,46 389102 9012]A - - 1,332191 .11465 L271 Od Oae b, 162 - 2,20] 20,yS9 630 . - - 11FOX. R,iY6 32226 Peyeole 11 ILAvemme¢s - fiO,JJC - - _ _ _ - C32 EO.OJO - o,ton olunas CA- gonion al longue oetr. uuld1- pe,2Cld - _ 2]66,600 - - 230,000 3,196,000 3,340,000 teesenma pones paynbe - 169.151 - - _ 225,000 111.151 211,000 d .1 6adTmas d peniopd1 _ _ _ _ _ 95000 - T20,D00 015,000 715,000 Gen ooliabl unemg Cone, F-I'd _ _ _ _ _ 1.01 aJ5 COO141 ]90.000 P3ywla lOaNd, yovemmoCs - _ _ _ _ - GO 6,510 5517 - Longsrn aebin6 Jfcunenl c0[ion F Rsvenoe bones 1.1.61, - _ - - 45,325,957 - - - 22850.906 60,175967 70270,658 Lease.cl .,A... ConaA Feyfle - _ _ _ _ 1,112000 1412,000 1,053,160 ,o,,dRes or "o'no, - 1,255000 191747 _ - 52110. 6209712 4714625 Gen , 1Ii9A,on re1,I bones dd,,1, - - - - _ _ _ 825,0. t71 COO 1,280,000 Pd,d1a la old, evemnenl5 - _ _ _ ]S,Ia,35,100 - Ad,aw.lmn aNe,lonas - 1A) WC - - 1 .7 ICC - - - 1,007,500 1,657,500 Es. noel. pre oldoale It Iablray - - .3 CIL - - - - 1`.004 202,000 Ooo,ol2rtrenuea 217 1, 101051 026640 2963] 1,L]5.16] 116]]80 Total liabllales 111,819 1193,602 331.3$2 758,106 fi3,al, 296 313919 943,001 _ ]3]9551.3 91,2..17 9CO29e19 So.", aad.mer Fleal, Invest vent, genal,,]asses - _ _ _ _ 14650.925 - 11.,550,926 15,111,910 C.,'. IT, ...pdel 44215,232 - 11235,232 ]7,899,982 Rel. Led ,amino, Rese,,O - - - - 3,013,648 - - - 3 141 CO0 1,09596 .......ea 1327,458 1NC7.V1.- 5.191,532 5,155,81] FundGAlences. RaAer� 1600780 5,1.73,373 2282,501 ],970544 - - _ _ - 16,912201 19,409.993 U.,eA„re] 1051108 6A70 COO 719162 _ _ _11313,323 16.311186 T.Al epa Ty and o Ut, clef Ts 5722,109 120`623 2787331 _1,1fi2,16J 1E fi0fi]O 3362,'74 1/550921 II1a9572 Fall 7. Total llablli0ez, equity and 'the, cmalts SECO, 906 $13,23],]55 $1121,311 $11920.270 $10"907639 51,685,993 $3`.1 $11.5.0925 $33,29351] $"90.11Ilfa $189.5203 ➢IE NOTES TO THE FINANCIR STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT. J City of Cape Girardeau, Missouri COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES ALL GOVERNMENTAL FUND TYPES FOR THE FISCAL YEAR ENDED June 30, 3002 GOVERNMENTAL FUND TYPES TOTALS SPECIAL DEBT CAPITAL (MEMORANDUM GENERAL REVENUE SERVICE PROJECTS ONLY) ' REVENUES Taxes $11,]]3,350 $9,095.967 $400,761 5- 521.2]0,0]8 Loan., and permits 1,057,618 8,656 - - 1,066,274 Intergovernmental 622,988 1,776,575 9,558 620,282 3,029,403 Charges for eervicos 370,715 983.738 - - 1,354,453 Interdepartmental services 724,064 - - - 724,064 Fines and forfeitures 831,407 - - - 831,407 Miscellaneous 134,464 171,879 67,310 - 373.653 Investment revenue 226,171 590,235 141,679 657,908 1,615,993 Special assessments 603 81.761 65]26 2.695 150,785 TOTAL REVENUES 15.741,380 12,708,811 685,034 1,280,885 30416,110 EXPENDITURES Current Admh,stestrve eervicos 1,734,963 1746,524 - 3,481487 Development services 1,551,213 28,453 - - 1579,666 Parks and recreation 1249,037 1,241233 - - 2,490,90 Public safety 8,447829 243,355 - - 8.691,184 .� Public works 1,987,227 4,745,422 - - 6732,649 Contingency 115,125 - - - 115,125 Capital outlay - - 7433,324 7,433,324 Debt service a Principal - 703,271 1,478,998 - 2,182,269 Interest and fiscal charges 985,465 496,272 5,69 1.487.364 TOTAL EXPENDITURES 15,085,394 9,693723 1,975270 7,438951 34,1:3,338 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 655,986 3,015,088 (1290,236) (6,158,066) (3,777.228) OTHER FINANCING SOURCES (USES) Operating transfers In 1,325.858 2,030,116 1,048,233 611,560 5.015,767 Operating transfers out (1.962,650) (4,28(1 (87,888) (1,737,074) (8,074,413) Bond proceeds - 2,101,468 643,441 - 2,744,909 Other loan proceeds 42,015 42,015 TOTAL OTHER FINANCING SOURCES (USES) (636.792) (113.202) 1.603,786 (1.125 514) (271722) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES 19,194 2,901 886 313,550 (7,283.580) (4,648,950) FUND BALANCES, JULY 1 5,712,994 9,141,787 2,473,954 18,445,744 35,774,479 PRIOR PERIOD ADJUSTMENT FUND BALANCES, JUNE 30 $5732,188 $12.043.673 $2,787,504 $11.162.164 $31.725529 J REVENUES Taxes Licenses and permits Intergovernmental Charges for services Interdepartmental services Fines and forfeitures Miscellaneous vestment revenue Special assessments TOTAL REVENUES EXPENDITURES Current Administratire services Development services Parks and recreation Public safety Public works Contingency Debt service Principal Interest and fiscal charges TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Operating transfers in Operating transfers out Bond proceeds Other loan proceeds TOTAL OTHER FINANCING SOURCES (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES FUND BALANCES, JULY i PRIOR PERIOD ADJUSTMENT FUND BALANCES, JUNE 30 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, 2002 1716595 GENERAL FUND 1,620,695 SPECIAL REVENUE FUNDS 113,653 1282,512 1,248,522 38.995 8,609,183 VARIANCE 139,055 2047,268 VARIANCE 55,510 107780 FAVORABLE 8345) 892523 FAVORABLE BUDGET ACTUAL NNFAVORABLE) BUDGET ACTUAL NNFAVORABLE) 511,912,086 $11,]]3,350 ($138.736) $9,194854 $9,095,967 ($98,887) 1,101,800 1,057.618 (44,182) 5,000 8,656 3656 94,004 622,988 48,984 1,869.750 1,776573 (93,124) ,393,705 320,215 (22,990) 559.600 983,239 424,139 255,250 224,064 (31,186) - - - 813,650 831,408 12,258 - - 66,356 134,464 68,108 156,180 171,029 15.699 242,980 213,317 (34,663) 151,940 517.408 365,460 1,000 603 (392) 3,065,000 81,761 (2,983139) 15,865,831 15228,522 (132.304) 15,002,324 12,635 986 (2.366.336) 1716595 1735,112 (18522) 1,620,695 1,552,942 113,653 1282,512 1,248,522 38.995 8,609,183 8,420.168 139,055 2047,268 1,991,258 55,510 107780 115,125 8345) 15,439618 15,117,672 321,346 5.682,902 426,813 610855 184,042 $5,656,965 $204,042 1,325.858 1,325858 10410 (1982,650) (1.982,650) 20.000 (656792) (636.292 20.600 (229,979) (25,937) 204,042 5.682,902 5882,902 - $5.452,923 $5,656,965 $204,042 2,001,294 1712,950 283,344 18.500 28,453 (9,953) 1,266.241 1249,653 25.588 256,284 246,374 10410 5,629,250 4,222,332 1406918 202,400 703,271 4,129 892523 985465 (87,942) 10826,992 9.194.498 1632494 4,125.332 3,441,488 (233,844) 1,358,935 2.03D 115 621,180 (4,261,822) (4,286801) 425,071 (70,647) 2,101,468 2,172,115 182,015 182,015 (3473,584) 26,797 3,506,381 701,748 3466.285 2,766537 6489,356 6,489,356 - $2,191,164 $9.952,641 $2266.532 REVENUES Taxes hangeremmental Miscellaneous Investment revenue + Special assessments TOTAL REVENUES EXPENDITURES Capital outlay Debt sarvipe Principal Interest and Local charges TOTAL EXPENDITURES + EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Operating transfers in + Operating till out Bond proceeds TOTAL OTHER FINANCING SOURCES + (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND + OTHER FINANCING USES FUND BALANCES, JULY 1 + FUND BALANCES, JUNE 30 Dlty 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, 2002 ANNUALLY BUDGETED DEBT SERVICE FUND CAPITAL PROJECTS FUNDS VARIANCE VARIANCE FAVORABLE FAVORABLE BUDGET ACTUAL (UNFAVORABLE I BUDGET ACTUAL (UNFAVORABLEI $396,589 $400,761 $4,172 $- $- $- 8250 9,550 808 1205,546 620,281 (585,265) 40,000 67309 27,309 - - - 151400 127,727 (23,673) 40,000 128,560 80.560 63,000 65,726 2,726 21695 2,695 659,739 1371,081 11,342 1,245,546 751,536 (494,010) - - - 2.202,480 883,458 1.319,022 1,462.398 1,478,990 (16,600) - - - 396,046 496.272 (100,224) 5,627 (6827) 1,858.446 1975270 (116,024) 2202,400 889,005 1.313,395 (1,198,707) (1,304.189) (105,402) (956,934) (137,549) 019.385 1048,250 1,048.233 (17) 308.442 308.866 424 (87,880) (87,888) (33,358) (33,358) - 643 441 643,441 1,046,250 1,603,786 555536 275,084 275,508 424 (150457) 299,597 450,054 (681,850) 137,959 819,809 2,473824 2.473024 2,198.190 2198,190 $2322,567 $2772,621 $450054 $1 516 340 $2,336,149 $619,809 Cur 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, 2002 8 TOTALS PROPRIETARY FUND TYPES (MEMORANDUM ONLY) INTERNAL ENTERPRISE SERVICE 20012002 i OPERATING REVENUES ResldenLal manges $5,816,478 5- $5816,478 Commercal"c"o, 2781,743 - 1701,743 Transfer station charges 519,012 519,812 Equipment sales 15,512 - 15,512 Concession revenues 135,010 - 135.018 Golf course fees 374,791 - 374.791 Softball complex fees 60,026 - 60,026 Other fees and charges 246,020 - 246,020 InterdepsHmental services - 3,642,627 3,642.827 Other miscellaneous 75.044 1,396 16440 TOTAL OPERATING REVENUES 16,024444 3,644.223 13668,667 OPERATING EXPENSES Personnel services 2,532,063 594,443 3.126,566 Materials and supplies 806,992 261,086 1,088,078 Contractual services 3,583.334 2,217.150 5,800.484 General operating expenses 315,672 20,273 335.945 Special projects expense 19,694 - 157,694 Internal service expenses 359,417 2,506 361,925 Door,, clion expense 2130,492 407,870 2,618,362 TOTAL OPERATING EXPENSES 9,085,664 3,603.320 13.468,994 OPERATING INCOME (LOSS) 138 (80 40,693 179,673 NON-OPERATING REVENUES (EXPENSES) vestment revenue 810,921 130,543 99,464 Federal grans, 110,175 - 110.175 Proceed, do are of asset, (369) (38 367) (39,756) Compensetied for tlamages 187 1,121 1300 cost amodisa ren (89,962) (2,426) (92,388) Interest antl hill casts (2,028.095) (20,317) (2,G45,412) a TOTAL NON-OPERATING REVENUES (EXPENSES) (1,109,153) 78554 (1,110.809) INCOME (LOSS) BEFORE OPERATING TRANSFERS (1,050,383) 119,447 (930,936) Operating transfers In 2,987,180 273,200 3.260 380 Operating transfers out (201 ]33) (291 Tia) NET INCOME (LOSS) 1,931 190,914 1127,711 RETAINED EARNINGS (DEFICIT), JULY 2o76 123 3,676,260 6,252303 PRIOR PERIOD ADJUSTMENT (141,814) (141 814) RETAINED EARNINGS(DEFICIT), JUNE30 $4,371106 $3,867.174 $8,238,280 8 THE NOTES TO THE F I NAN C I AL STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT - 9 City of Cape Girardeau, Missouri COMBINED STATEMENT OF CASH FLOWS. ALL PROPRIETARY FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 30, 2002 PROPRIETARY FUND TYPES TOTALS INTERNAL (MEMORANDUM ONLY) ENTERPRISE SERVICE 2001-2002 CASH FLOWS FROM OPERATING ACTIVITIES: Operating income (loss) 138,780 40,893 179,673 Adjustments to reconcile operating Income to " net cash provided by operating activities: Depreciation 2,130,492 487,870 2,618.362 Cash operating grants received 110,175 - 110,175 Change In assets and liabilities'. (Increase) decrease in accounts receivable 108,463 (134,098) (25,635) (Increase) decrease In inventory 4,997 1,249 6,246 (Increase) decrease In prepaid Items (687) 6,280 5.593 Increase (decrease) In accounts payable (333,501) (23,646) (357,147) Increase In accrued liabilities 341,352 (17,175) 324,177 Increase(decrease) in landfill postelosure care costs (64000) (84,000) NET CASH PROVIDED BY (USED IN) OPERATING ACTIVITIES 2436,071 361,373 2,797_444 CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES: Operating transfers in from other funds 2,987 180 273200 3260,380 Operating transfers out to other funds (201,733) (201.733) NET CASH PROVIDED BY (USED IN) NONCAPITAL FINANCING ACTIVITIES 2,967,180 71,467 3.050,647 + CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES: Principal paid on revenue bonds L.708 530) - (1,708.530) Principal paid on lease purchase bonds (260,071) - (268,071) i Principal paid on COP bonds - (129,878) (129,878) Principal paid on energy loan is note payable on land (6,379) - (6,379) Interest paid on bonds and obligations (2,028,095) (20,317) (2,048,412) Purchase of fixed assets (4,279629) (384,829) (4,664,458) Proceeds from sale of assets - 2,100 2,100 Connection fees 79,020 - 79,020 Grants for purchase of assets 7.500 - 7,500 Compensation for damages 187 1,121 1,308 r NET CASH PROVIDED BY (USED IN) CAPITAL AND RELATED FINANCING ACTIVITIES (8,203997) (531603) (8735.800) CASH FLOWS FROM INVESTING ACTIVITIES: y Proceeds from sale of Investments 16,152 - 10,152 Interest on invesbnents 543,084 7,765 550,869 0"Inigtt Interest 186,246 112.403 298,649 Interest on assessments 28,664 18,356 47,020 FMV adjustments to cash 50,776 50,776 NET CASH PROVIDED BY (USED IN) INVESTING ACTIVITIES 810.922 138.544 957,466 + INCREASE (DECREASE) IN CASH AND CASH EQUIVALENTS (1,961,824) 39,501 (1,922243) CASH AND CASH EQUIVALENTS, JULY 1 17,760,117 2,509,286 20,358403 CASH AND CASH EQUIVALENTS, JUNE 30 15,806,293 2,628.867 18435 160 THE NOTES TO THE F I NAN C I AL STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT - 9 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES The City of Cape Girardeau, Missouri (the City) 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 govermment 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. Reoortine Entih 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 of the City. The financial statements of the CGPFA are included in the accompanying financial statements of the City. Cape Girardeau (Missouri) Public Facilities Authority- As described in Note E, the City has entered into four lease agreements with the 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 consis's 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 CGPFA was organized to execute the bond indentures for the purpose of issuing and securing the Series 1993 Bonds, Series 1994A Bonds, and Series 1997A Bonds, and 19978 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 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 by the City, these entities are shown as Agency Funds in the financial statements. 10 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 2. Fund Accountin The accounts of the City are organized on the basis of funds and account groups, cacti 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 find of the City. All financial resources, except those required to be accounted for in another fund, are accounted for in the General Fund. Special Revenue Funds - Special Revenue Funds are used to account for the proceeds of specific revenue sources (other than expendable trust or major capital projects) 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. 11 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 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 and 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. Entetnrise Funds - Enterprise Funds are used to account for operations that are financed and operated in a nrarmer 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 arc 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 Account Grouo - The General Fixed Assets Account Group is used to account for fixed assets used in governmental fund type operations for control purposes. All fixed assets are recorded at historical cost or estimated historical cost if actual historical cost is not available. Donated fixed assets are recorded at their estimated fair value on the date of donation. Depreciation is recorded on general fixed assets. General Lone -Tenn Debt Account Grouu - The General Long -Tenn Debt Account Group 's used to account for long-term liabilities to be financed from governmental funds. 12 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 3. Fixed Assets General Fixed Assets Account Groun - 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 with other general fixed assets. Depreciation has been provided on all capitalized assets, except for land. All fixed assets are recorded at historical cost or estimated historical cost if actual historical cost is not available. Donated assets are recorded 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 bettemients 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 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 Accountine The accounting and financial reporting treatment applied to a fiord is determined by its measurement focus. All govemnremal 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. All proprietary funds are accounted for on a flow of economic resources measurement focus. With this measurement focus, all assets and liabilities associated with the operation of these funds are included on the balance sheet. Fund equity (i.e., net total assets) is segregated into contributed capital and retained earnings components. Proprietary fund type operating statements present increases (e.g., revenues) and decreases (e.g., expenses) in net total assets. 13 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 4. Basis of Accounting - Continued The modified accrual basis of accounting is used by all governmental fund types and agency funds. Under the modified accrual basis of accounting, revenues are recognized when susceptible to accrual (i.e., when they become both measurable and available.) "Measurable" means the amount of the transaction can be determined and "available" means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. The City considers revenue to be available if it is collected within 30 days after year-end. Expenditures are recorded when the related fund liability is incurred. Principal and interest on long- term debt are recorded as liabilities when due or when amounts have been accumulated in the debt service fund for payments to be made 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 earned and expenses are recorded at the time liabilities are incurred. The City reports deferred revenue on its combined balance sheet. Deferred revenues arise when a potential revenue docs not meet both the "measurable" and "available" criteria for recognition in the current period. Deferred revenues also arise when resources are received by the City before it has a legal claim to them, as when grant monies are received prior to the incurrence of qualifying expenditures. In subsequent periods, when both revenue recognition criteria are met, or when the City has a legal claim to the resources, the liability for deferred revenue is removed from the combined balance sheet and revenue is recognized. 5. Encumbrances Encumbrances represent commitments related to unperformed contracts for goods or services Encumbrance accounting is utilized in all funds. Encumbrances outstanding at the end of the year in the governmental funds are reported as reservations of fund balances and do not constitute expenditures or liabilities because the commitments will be carried forward and honored during the subsequent year. Encumbrances outstanding in the Proprietary Funds do not constitute expenses but will be honored in the subsequent year. 14 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 6. Budgets and Budgetary Accounfin2 The C:.ity adopts annual operating budgets for all funds. The City follows these procedures in establishing the budgetary data reflected in the financial statements. I. "Tire City Manager submits to the (.,try Council a proposed operating budget for the fiscal year 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 an ordinance. 4. 'rhe City Manager is authorized to transfer budgeted amounts between programs within any department, however, any revisions that alter Ole 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. 7. If, during the fiscal year, the City Manager certifies there are additional revenues to appropriate, unencumbered appropriation balances within a department, or an emergency situation the City Council may amend the initial budget by ordinance. The initial budget was adapted by the City Council on July 18, 2001 and amended on July 1, 2001 The amended budget is reflected in the financial statements. 15 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS ,Tune 30, 2002 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 6. Budgets and Budgetary Accounting - Continued y For the year ended June 30, 2002 the fund expenditures for Downtown Business District, Motor Fuel Tax, Capital Improvement Sales Tax -Water Projects, Transportation Sales Tax Trust, Vision 2000, Corp Flood Control Project, FAU Street Grant, Water Fund, and Equipment Replacement funds exceeded their approved budgets by, $9,210, $93,003, S80,738, $68,076, 5743, $3,416, $186, $696, and $1,120, 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 govemmental fund types is prepared on a budgetary basis which includes encumbrances as expenditures. The following reconciliation adjusts GAAP basis to budget basis: ,. Excess (Deficiency) of Revenues and Othcr Financing Sources over(undeq Eispcudirtges and Other Financing Use Special Debt Capital General Revenue Service Preiccts $3 GAAPBasls $19,194 $2,901,8X6 13.550 5(7,283,580) 16 Increase due to Prior year encumbrances Administrative Services 2,297 87,042 - - Development services 675 - - - Parks and reemafion 1,887 650 - - Pcblie Safety 23,102 2,262 - - Public Works 1,623 - - - Capituloutlay - 2,555,211 - 598,112 Advance from other funds - 140,000 - - Water Impmvcmcuts Fund not budgeted annually 7.099282 29584 2]85165 7.697.394 Decrease duc to: Year-end encumbrances .� Administrative services 2,451 58,468 - - Dwelopment services 6,505 - Parks and recreation 1,371 70 - - Public safety 45,380 5,281 - - Public works 6,153 - Capital outlay - 2,082,119 - 255,852 Adjust investments to market 12,855 72,828 13,953 20,003 74 71 5 1,118,766 13,953 275N55 Budget Basis - 9153 46R u85 99,$87 ,SIA] 959 16 ' City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE A- SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 6. Budeets and Budeetary Accounting - Continued The individual proprietary fund 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. y Net Income (Loss) Solid Golf Sonball Sewer Water Waste Course (mi GAAPBasIs $649,928 $1,174,697 5176,036 $(75,1181) Sl 1,217 Increase due to Prior year encumbrances .. Moteriuls and supplies _ _ _ 1,974 - General operating expenses _ _ _ 1,067 - Contractualserviccs 12,606 684 2,584 - - Spcciul projects - - 955 - 75 Capital Outlays 3,521,574 - 110,082 - - Depreciation 1361,217 543.344 162,499 50,697 12,735 Special assasmcnb 91,440 32,279 - - - sewcr connection fives 79,020 - - - Dcfcrrcm drcnucs - 72,337 9 - Local grants 9,888 - 7,500 Interest paid leas than accrued 350,632 - - Interest cost amortized 837,120 _ _ _ - ' Cost offend refunding amortization 9,486 49,413 - - - Amcrazed bond prentluMdi,ecant 289 - Issuance cost amonizution 70,634 18,893 435 - - Amounts deferred to be used for future debt ' Service on capital appreciation bonds: Construction Pond earnings 145,032 - - - - Difference between proceeds from sale of fixed assets and gain or Toss - 389 6,498,938 717,339 284.064 53,738 12810 Decrease due m Year-end encumbrances Mater..1, sad supplies - 4,516 517 - - Contmctualservjces 221 168 1,500 - - Special projects - - - - 104 Capital cull." 1,968378 - 9,280 - - + Landfill closure and maintenance costs - - 3,495 - - latcrest paid more than acantal - 9,992 _ _ Bond principal paid 2,357,602 515,000 6,379 - - Amortized Bond prem..an f,am it - 308 - _ _ Capital outlays 4,048,608 81,925 143,713 15.272 - Aii def fired for turn e debt service for capital appreciation bonds: Interest subsidy received. 397,216 Adjustment to liability for future landfill postdosum - - 60?05 - - ' Deferred revenues 7,611.3 - Adjust invesnnents to murkct 15.191 41,9840 11.659 378 319 8.794819 653889 237048 15X5(1 413 Budget Basis SUA11 9 3. _5 13.-14] --%2110 SQ0.919 ; 2%004 1) City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 6. Budgets and Budgetary Accounting - Continued 18 Net Income (Lossl Data Meet Emrlovtt- Risk E9ui,'n' � t'� M11vi� e : t2'i� !vlanaecnmm Rcolacc c i GAAP Basis S(96,537) S(22,643) 515,720 S(31,967) 5326,341 Increase due to: Prior year encumbrances Contractual services - - - 83 - Depreciation 199,727 44,404 - - 243,739 Difference between proceeds from sale of fixed assets and gain or loss 38,798 1,669 - - - Issuance cost amortization 1,299 - - - 1,127 Amortized bond premium/discount 44 - - 78 239,868 46,073 83 244,94 .. Decrease due to: Year-end encumbrances Material and supplies - 226 - - - Contractual services - 896 - - - Capital outlays - 7,745 - - 41,191 Interest paid more than accrued 780 2 - - 780 Principal paid 65,000 450 - - 65,000 Capital outlays 63,262 3,440 - - 318,129 Advance to other funds - - - - 140,000 Adjust investment to market 225 623 3,341 111 782782 2,53 129,267 13 382 3.341 11,782 567.630 Budget Basis S14,06 510,04812 3 9 _ 43 C, : 65 7. Inventories Inventories consist primarily of supplies, valued at cost. Cost is determined using a weighted average method. The cost of inventories is recorded as expenditures or expenses when consumed rather than when purchased. 18 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 8. Compensated Absences Vested or accumulated vacation pay for proprietary funds is recorded as an expense and liability of those funds as the benefits accrue to employees. Amounts of vested or accumulated vacation leave of governmental funds that are not expected to be liquidated within the current year are reported in the General Long -Term Debt Account Group. Employees- may accumulate up to 30 days vacation, for which they are compensated upon termination or retirement. Employees are not compensated for accumulated sick leave upon termination or retirement. 9. Bond Discounts/Issuance Costs In governmental fund types, bond discounts and issuance costs arc 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 columns do not present results of operations in eonfonuily with generally accepted accounting principles. Neither is such data comparable to a consolidation. Interfund eliminations have not been made in the aggregation of this data. 11. Cash and Investments The City maintains an internal investment pool for the majority of its non -restricted cash and investments and a small portion of its restricted cash and investments. Investment revenue is allocated to each fund based on its average equity balance in the pool. Cash includes amounts in repurchase agreements and other short-tenn investments with a maturity date within three months of the date of purchase. 19 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued IL Cash and Investments -Continued The City's investment policy authorizes it to invest its available operating and reserve funds in (1) obligations of the United States or its agencies and 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. Bond proceeds may be invested as allowed in the bond indenture. Investments, excluding certificates of deposit, with a maturity date of one year or more at the time of purchase are recorded at market value as determined by averaging market quotes received by two different securities dealers. All other cash and investments are recorded at cost or amortized cost. 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, 2002 are recorded as prepaid items. 14. Restricted Assets Certain proceeds of enterprise fund revenue bonds, as well as certain resources set aside for the repayment of such bonds, are classified as restricted assets on the balance sheet because their use is limited by applicable bond covenants. The "revenue bond construction" account is used to report those proceeds of revenue bond issuances that are restricted for use in construction. The "revenue bond current debt service" account is used to report resources set aside to make up potential future deficiencies in the revenue bond current debt service account. 20 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 15. Lone -term Oblieations Long -teen debt is recognized as a liability of a govertunental fund when due, or when resources have been accumulated in the debt service fiord for payment in the following year. For other long-term obligations, only that portion expected to be financed from expendable available financial resources is reported as a fund liability of a governmental fund. The remaining portion of such obligations is reported in the General Long -Teem Debt Account Group. Long-term liabilities expected to be financed from proprietary fund operations are accounted for in the appropriate proprietary fund. 16. Interfund Transactions Quasi -external 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 fund, are recorded as expenditures/expcnscs in the reimbursing fund and as reductions of expenditures/expenses in the fund that is reimbursed. All other intcrfund 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 inlerfund 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-temt interfund loans are classified as "interfund receivables/payables". 18. Advances to Other Funds Noncurrent portions of long -tern inlerfund 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. 21 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES -Continued 19. Post-Emplovment health Care Benefits In addition to the pension benefits described in Note H, it is the City's policy to provide postretirement health care benefits to employees who retire from the City with five or more years of service and who are eligible for LAGERS retirement (Note H). Currently, thirty-five employees meet those eligibility requirements. The City provides health care coverage for them until age 65. The cost of retirees' health care benefits is recognized as an expenditure as premiums are paid. For the year ending June 30, 2002, those costs totaled $101,148. COBRA Benefits - Under the Consolidated Omnibus Budget Reconciliation Act (COBRA), the City provides health care benefits to eligible former employees and eligible dependents. Certain requirements are outlined by the federal goverment 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. Thcre is no associated cost to the City under this program, and there were two participants in the program as of June 30, 2002. NOTE B - DEPOSITS AND INVESTMENTS 1. Deposits At June 30, 2002, the carrying amount of the City's deposits was $17,903,494 and the bank balance was $17,861,942, which excludes $5,728 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 $17,899,148 $17,857,596 Category #2 - - Category #3 4,346 4,346 $17.903.494 $17 86I 94? Category #1 includes deposits covered by deposit insurance or collateral held by the City in the City's name. Category #2 includes deposits covered by collateral held by the financial institution's trust department in the City's name. Category #3 includes deposits which are uneollateralized or the collateral is held by the financial institution's trust department but not in the City's name. 22 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE B - DEPOSITS AND INVESTMENTS - Continued 2. Investments 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 trust department or agent in the City's name. Category 03 Uninsured and unregistered, with securities held by the counter -party, or by its department or agent but not in the City's name. Cateeow Carrying Pair #1 #2 43 Value Value U.S. Government Securities $19,092,432 $- $- $19,092,432 $19,092,432 Municipal Bonds 87.193 87,193 87.193 $19179625 $19,179,625 19,t79,625 State Revolving Fund Program 9,250,231 9.250 231 $28,429.85 $28,429,856 23 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE C - PROPERTY TAXES - Property taxes attach as an enforceable lien on property as of.)unitary I. Taxes were levied on August 20, 2001, 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: Accunminred Balance General Revenue $ .3128/100.00 assessed valuation Deductions Public Health .0586/ 100.00 assess xi valuation Land Debt Service .1000/100.00 assessed valuation S- Special Business District .7838/100.00 assessed valuation - Baild9ngs #2 (Ad Valorem) 45,990 - Property tax receivable balances as of June 30, 2002 are as follows: I r1provcments 0111cr — Downtown Business Debt Than buildings General District Health Service Library Total - Current property tax $33,297 $ 2,678 $ 6,107 $19,191 $18,224 $79,497 Delinquent property tax 37,624 85 0,162 12,697 18,629 75,197 Reserve for doubtful 909,77; - Construction in progress — Property taxes (31,054 _(8L j5 Oy 78)9 8 LL O�Si� 6I Li 131 Net property tax receivable 39 Cj_7 $ 2.6'18 $ 7. f 91 . 2 049 121 � i 3 581 NOTE, D - CHANGES IN FIXED ASSETS - A summary of the General Fixed Assets Account Group for the year ended June 30, 2002 is as follows: Balance Accunminred Balance July 1.2001 Additions Deductions Depredation Ju re M 20112 Land S 2,598,805 S 39,275 S- 8- S2,638,080 - Baild9ngs 7,783,924 45,990 - 373,714 7,451,200 I r1provcments 0111cr Than buildings 3,714,688 107,949 - -'_64,110 3,558,527 Equipineat 954,283 221,778 86,781 179,509 909,77; - Construction in progress 88 21n 29,088 24.950 - 93 341 Total rmetal axed uvsets �144910 ,.$ 41 '� X9„ 31 �„5327�, 1i _I4 650920 24 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS ,lune 30, 2002 NOTE D - CHANGES IN FIXED ASSETS - Continued Additions and deletions to the Enterprise Funds for the fiscal year 2002 were $10,524,796 and $1,574 respectively. Additions and deletions to the Internal Service Funds were $384,831 and $170,446 respectively. A summary of the proprietary fund type fixed assets for the year ended June 30, 2002 is as follows: Enterprise Internal Fund Service Front + Land S 248,104 S 37,500 Buildings 9,263,141 449,603 Improvements other than building 59,512,421 113,749 Equipment 5,567,648 3,939,886 Construction in progress 31,354 927 $105,946,246 $4,540,738 Less: accumulated depreciation 22 476,160 1692385 ..83.470.08(ti $ 1.844,353 NOTE E - LONG-TERM OBLIGATIONS The following is a summary of transactions in the General Long-term Debt Account Group of the City for the year ended June 30, 2002. General Leasehold Certificates Obligmien Aevenuc Of 1 CIMIe Unused Paid Due to Other 6in� ids BgndS,ic(natjun Bond. Leave Governments Tota General long -Icon Debt payable at July 1, 2001 $1,670,000 $2,163,398 $3,785,000 $24,275,000 $681,424 S- 132,574,822 Reurements (390,000) (476,398) (620,000) (695,000) - (2,181,39s) Amount Added - ,� 2 815 004 - 49,432 4-06 KI 2 905 119 General long-term Debt payable at lune 36, 2002 51.2 0 0 $ 7 00 - J5„1 9, q ;v2,1 58t_1,Pa _ 40&t7 $.770 4? , $17 _20854, 25 Principal payments arc made annually on November 1, and interest payments are made semi-annually on May I and November 1. 26 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 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, 2002 ' Leasehold Certificates Revenue Revenue of Bonds Bonds Participation Total Bonds payable at July 1,2001 $49,803,658 $434,063 $1,674,625 551,912,346 Discount Amortization & Issue Cost 51,478 2,690 122 54,290 Bonds issued - - - - Accumulated Interest 841,831 - - 841,831 Bonds Retired f2 605,0001 _ 267 602 f i 30,00i}} (3 0(}2.602) Bonds payable at June 30, 2002 $48 091 967 69 5]$1.544,747 _�49 805 8L)5 Bonds payable at June 30, 2002 are comprised of the following individual issues. 000 1993 General Obligation Refunding Bonds due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total 2003 5.00% $ 405,000 $53,875 S 454,875 2004 5.00 425,000 33,125 458,125 2005 5.00 X150000I1�250 461,250 ti $t 28 000 598.250 J,� 37f� Principal payments arc made annually on November 1, and interest payments are made semi-annually on May I and November 1. 26 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 y NOTE E - LONG TERM OBLIGATIONS - Continued On April 20, 1993, the City issued $3,690,000 of General Obligation Refunding Bonds Series 1993 with interest rates varying from 3.75% to 5.50%. T'he 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 properly, real and personal, within the territorial limits of the City. The refunding bonds were issued to provide the City with fiords which together with other legally _ available finds 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. 550 000 Series 1993 Sewerye Svste It Revenue Bonds due as follows: Year Ending Interest Principal Interest June 30 Rate _Due Due Total 2003 5.250% $120,000 S29,238 $149,238 2004 5.300 135,000 22,938 157,938 2005 5.350 140,000 15,783 155,783 -" 2006 5.350 (55 0, 00 829-3 2 000 5'6.25262"25' ..._55 These bonds are dated September 1, 1993. The proceeds of the bond issue were used to defease (in - substance) the $1,170,000 1986 Sewerage System Revenue Bonds. Principal payments are made annually on March 1, and interest payments are made semi-annually on March 1, and September 1. 27 These bonds are 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 Jute "s, 1991 Principal payments are made annually on March I, 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 de£eased visa an in -substance defeasance during the fiscal year ended June 30, 1996. 28 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 w NOTE E - LONG-TERM OBLIGATIONS - Continued 1665 000 Waterworks System Revenue Bonds Series 1992 due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due, Total 2003 T45'Yo S 485,000 $124,042 $ 609,042 _ 2004 7.45 555,000 87,910 642,910 2005 7.45 625 000 46 ,5,153 671.563 '1 6, .6,5.040 _� 58 515 . 19S . 23 515 These bonds are 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 Jute "s, 1991 Principal payments are made annually on March I, 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 de£eased visa an in -substance defeasance during the fiscal year ended June 30, 1996. 28 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE E -LONG-TERM OBLIGATIONS - Continued $_ 8,__,455 OOU Watorworks Svstcm Refundine Revenue Bonds Series 1995 due as follows: Year Ending Interest principal Interest June 30 Rate Due Due Total _ 2003 4500% $ 90,000 $ 422,678 S 512,678 2004 4.600 95,000 418,627 519,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,2610,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 2295.000 I I4 950 2 409 750 %45_5 53,-146.(30 $1_i.60,1_O30 Principal payments are made annually on March 1, and interest payments are made semiannually on March 1 and September 1. On December 1, t995 the City issued $9,095,000 of Waterworks System Refunding Revenue Bonds Series 1995 with interest rates varying from 3.9% to 52%. 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. 29 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE E - LONG-TERM OBLIGATIONS - Continued S 1,850,000 Sewerage System Revenue Bonds (State Revolvin2 Fund Program) Series 1991 due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total 2003 6.600% $ 105,000 $ 126,899 S 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 1850 000 925 422 $2,775,429 These bonds are dated December I, 1991. 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 June 1, and interest payments are made semi-annually on June I 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 State of Missouri Department of Natural Resources deposits an amount equal to approximately 51.907% of the reimbmsement 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 retired 50°/, of the amount of bonds retired will be repaid to the State of Missouri Department of Natural Resources out of the reserve fund. The balance of the reserve fund at June 30, 2002 was S1,105,560. The reserve fund yields 6.71%. During the fiscal year-end .lune 30, 2001 certain bonds originally issued by the State Enviromnental Improvement and Energy Resources Authority as part of the State Revolving Fund Program were refunded. Annual debt service savings resulting from this transaction are to be used to offset City debt service payments due on Series 1991 Bonds. During the fiscal year ended June 30, 2002, City interest expense was reduced by $22,391 as a result of this transaction. Over the remaining life of these bonds, the City will receive net present value benefits of approximately $163,000 from this transaction. 30 y City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 375,000 Sewerage Svstem Revenue Bonds (State Revolving Fund Program) Series 1993 due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total 2003 4.700% S 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 $375,000 _$ 144.567 519 56 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 I and September 1. The interest due on the 1993 Sewer System Revenue Bonds will be subsidized by interest earnings on a reserve fund held by the bond issue's trustee. As the City is reimbursed for sewer project expenditures from the construction funds held by the trustee, the State of Missouri Department of Natural Resources will deposit an amount equal to approximately 70.00% of the reimbursement into the reserve fund. The maximum amount of funds that will be advanced to the reserve fund will be $350,000. As bonds are retired, 70% of the amount of bonds retired will be repaid to the State of Missouri Department of Natural Resources out of the reserve fund. The balance of the reserve fund at June 30, 2002 was $262,500. The reserve fund yields 5.15°%. 31 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS Jute 30, 2002 NOTE E - LONG-TERM OBLIGATIONS - Continued S 9,572359 Water Pollution Control Revenue Bonds (State Revolving Fund Programl Series 1995D due as follows: Year Ending Interest Principal Interest .lune 30 Rale Due Due Total 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 $9.572359 11.097,641 $20,670,00 These bonds are dated June I, 1995. The proceeds- of the bond issue were used for the extension and improvement of the existing sewerage system serving the City. Principal and interest payments will be made annually on January I beginning in 1998. r 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 State of Missouri 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 origir.d issue discount. As bonds are retired 70% of the amount of bonds retired will be repaid to the State of Missouri Department of Natural Resources out of the reserve fund. The balance of the reserve fund at June 30, 2002 was $6,700,651. The reserve fund yields 5.83%. 32 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE E - LONG-TERM OBLIGATION - Continued ' $ 12,910,000 Sewerage System Revenue Bonds (State Revolving Fund Program) Series 1996 due as follows: Year Ending Interest Principal Interest June 30 Rale Due Due Total 2003 4.900% $585,000 $730,874 S1,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 1021.935 $12.910.000 $7330359 $20240359 These bonds are dated June 1, 1996. The proceeds of the bond issue were 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 2000. Interest is paid semi- annually on January I and July I bcgimring in 1997. The interest due on the 1996 Sewerage 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, the State of Missouri 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 will be 59,474,500. As bonds are retired, 70% of the amount of bonds retired will be repaid to the Department of Natural Resources out of the reserve fund. The balance of the reserve fund at June 30, 2002 was $9,037,000. The reserve fund yields 5.70%. 33 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE E - LONG-TERM OBLIGATION - Continued During the fiscal year ended June 30, 2001 certain bonds originally issued by the State Environmental Improvement and Energy Resources Authority as part of the State Revolving Fund Program were refunded. Annual debt service savings resulting from this transaction are to be used to offset City debt service payments due on Series 1996 Bonds. During the fiscal year ended June 30, 2002, City interest expense was increased by $88,431 as a result of this transaction. Over the remaining life of these bonds, the City will receive net present value benefits of approximately $198,000 from this transaction. $ 8,355,000 Sewerage Svstem Revenue Bonds (State Revolving_ Fund Program) Series 2000 due as follows: These bonds are dated November I, 2000. 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 July t, and interest payments are made semi-annually on July 1 and January I. 34 Year Ending Interest Principal Interest June 30 Rate Due Due 'Dotal 2003 $- $447,930 $447,930 2004 4.400% 50,000 446,830 496,830 2005 4.400 50,000 444,630 494,630 2006 4.500 55,000 442,293 497,293 2007 4.500 120,000 438,355 558,355 2008 4.500 130,000 432,730 562,730 2009 4.600 145,000 426,470 571,470 2010 4.625 165,000 419,319 584,319 2011 4.700 185,000 411,156 596,156 2012 5.500 215,000 400,896 615,896 2013 5.500 230,000 388,659 618,659 2014 5.000 250,000 376,084 626,084 2015 5.625 275,000 362,099 637,099 2016 5.625 475,000 341,006 816,006 2017 5.625 555,000 312,037 867,037 2018 5.300 590,000 280,793 870,793 2019 5.400 1,590,000 222,228 1,812,228 2020 5.450 1,655,000 134,199 1,789,199 2021 5.500 1,620,000 44,550 1,664,550 $8,355,000 $6,772,264 $15.127 264 These bonds are dated November I, 2000. 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 July t, and interest payments are made semi-annually on July 1 and January I. 34 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE E - LONG-TERM OBLIGATION — Continued The interest due on the 2000 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 State of Missouri Department of Natural Resources deposits an amount equal to approximately 70% of the reimbursement into the reserve fund. The maximum amount of funds that will be advanced to the reserve fund will be $5,848,500. As bonds are retired 70% of the amount of bonds retired will be repaid to the State of Missouri Department of Natural Resources out of the reserve fund. The balance of the reserve fund at June 30, 2002 was $2,787,1 16. The reserve fund yields 6.71%. S23,580,000 Waterworks System Revenue Bonds (State Revolving Fund Program) Series 1998 due as follows: Year Ending Interest Principal Interest June 30, Rate Due Due Total 2003 3.800% $ 730,000 $ 1,115,165 $ 1,845,165 2004 3.900 770,000 1,087,425 1,857,425 2005 4.000 810,000 1,057,395 1,867,395 2006 4.000 870,000 1,024,995 1,894,995 2007 4.100 920,000 990,195 1,910,195 2008 4.200 1,000,000 952,475 1,952,475 2009 4.300 1,025,000 910,475 1,935,475 2010 4.375 1,080,000 866,400 1,946,400 2011 5.250 1,110,000 819,150 1,929,150 2012 5.250 1,215,000 760,875 1,975,875 2013 5.250 1,300,000 697,087 1,997,087 2014 5.250 2,350,000 628,838 2,978,838 2015 5.250 2,445,000 505,462 2,950,462 2016 5.250 2,550,000 377,100 2,927,100 2017 4.500 2,655,000 243,225 2,898,225 2018 4.500 2,750,000 123,750 2,873.750 $23.580.000 312160012 $35.740912 These bonds are dated December 1, 1998. Tire proceeds of the bond issue will be used for the extension and improvements to the waterworks system. 35 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE E - LONG-TERM OBLIGATION — Continued Principal payments will be made annually on January 1 beginning in 2000. Interest is paid semi- annually on January I and July I beginning on July 1, 1999. The interest due on the 1998 Waterworks 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 waterworks system expenditures from the construction funds, the Department of Natural Resources will deposit an amount equal to 33.41% of the disbursement into the reserve fund. The maximum amount of funds that will be advanced to the reserve will be $8,517,235. As bonds are paid off, 33.41% of the amount of bonds retired will be repaid to the Department of Natural Resources out of the reserve fund. The balance of the reserve fund at June 30, 2002 was $5,748,878. The reserve fund yields 4.71 %. a $ 1085,000 Building and Equipment Leasehold Refunding & Improvement Revenue Bonds (Capital Improvements Project), Series 1993 due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total 2003 4.750% $ 420,000 $ 3,200 $ 423,200 2004 5.000 185,000 33,250 218,250 2005 5.000 480,000 24,000 504.000 1.085.000 60,45 $1.145 450 The bonds arc obligations of the Cape Girardeau (Missouri) Public Facilities Authority (CGPFA). The CGPFA has entered into a Lease Purchase Agreement with the City. 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 ti e 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 outstanding bond principal is allocated as follows: $170,000 - Sewer Fund; and $915,000 - General Long-term Debt Account Group. Principal payments- are made annually on March I and interest payments are made semi-annually on March 1 and September 1. 36 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE E - LONG-TERM OBLIGATION - Continued $281,000 City of Cape Girardeau Missouri Lease Purchase Agreement dated lune 17 1999 due as follows: Year Ending Interest Principal Interest lune 30 Rate Due Due Total 2003 5.000% S 25,000 $ 14,050 $ 39,050 2004 5.000 27,000 12,800 39,800 2005 5.000 28,000 11,450 39,450 2006 5.000 29,000 10,050 39,050 2007 5.000 31,000 8,600 39,600 2008 5.000 33,000 7,050 40,050 2009 5.000 34,000 5,400 39,400 2010 5.000 36,000 3,700 39,700 2011 5.000 38,000 1,900 39,900 $281900 $ 75.000 $356000 'The lease agreement is the obligation of the City of Cape Girardeau, Missouri. Principal and interest will be paid by the City from proceeds of the site lease and the lease agreement. The purpose of the lease agreement was to (1) rehabilitate and otherwise improve the A. C. Brase Arena Building and (2) acquire a building at the Cape Girardeau Regional Airport known as the "Lipp's Hanger". The lease principal outstanding is allocated $281,000 to the General Long -Term Debt Account Group. Principal payments are made annually on April I and interest payments arc made semi-annually on April I and October 1. 37 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS .lune 30, 2002 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 491.000 Citv of Cape Girardeau Lease Purchase A reement dated March 31 2000 due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total . 2003 5.750% $ - S 28,232 $ 28,232 2004 5.750 - 28,233 28,233 2005 5.750 491,000 28,233 519,233 491 000 ' 84 618 579 698 Principal and interest will be paid by the City from proceeds of the site lease and the lease agreement. The propose of the lease agreement was to purchase approximately 12 acres in the south central portion of the City for the Public Works Department. The lease principal outstanding is allocated $491,000 to the General Long-term Debt Account Group. ` The principal payment is made at maturity and interest payments are made semi-annually on March I and September 1. 38 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 1 645 000 Certificates of Particil7atio ,,,(Convention and Visitors Recreation Facilities Projecll, Serics .1993.. Year finding Interest Principal Interest June 30 Rate Due Due Total 2003 5.000% $ 455,000 S 84,588 $ 539,588 2004 5.125 510,000 61,838 571,838 2005 5.250 6_?0 000 35,7(10 715,700 51.645.000 =182.126 .'14 827126 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, furnishing, and equipping of a convention and recreational center, softball and soccer fields, and improvements to the City Hall. The bond liability for the Series 1993 certificates is recordcd in the General Long -Term Debt Account Group. Principal payments are made annually on April 1, and interest payments are made semi -amorally on April I, and October I. 39 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 1,255,000 Certificates of Participation (Twin Lakes Project) Series 1994A Year Ending Interest Principal Interest June 30 Rate Due Due Total 2003 5.350% $- $ 71,828 $ 71,828 2004 5.450 - 71,828 71,828 2005 5.550 125,000 68,358 193,358 ., 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 $1.255,000 _$318_3;44 I S 3244 "rhe 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 I, and interest payments are made semi-annually on April 1 and October 1. 40 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE E - LONG-TERM OBLIGATIONS — Continued 1 435 000 Certificates rf Participation tCapitallmorovoments Projei;ts) Series 1937A. Year finding Interest Principal Interest June 30 Rate Due Due Total 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,250 2007 5.000 _ 335,000 16,750 351 750 $_ 1 ._435 000 S 208 655 $1,643,65 "file 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 Smile (the "Trustee"). The purpose of the 1997A Series certificates is to (1) pay the costs of completing the construction, furnishing and equipping of a convention and recreational facility that constituted part (if the 1993 project, (2) pay the costs of acquiring, constructing, furnishing and 'equipping various equipment and capital improvement projects, (3) fund the debt service requirements for the Series 1997A Certificates, and (4) pay the costs of issuance of the Series 1997A Certificates. _ The outstanding bond liability for the Series 1997A Certificates is allocated as follows: $ 1,145,00( - General Long -Term Debt Account Group, $140,000 - Data Processing and 8150,000 - Equipment Replacement Fund. Principal payments are made annually on April 1, and interest payments are made semi-annually on April I and October 1. 41 ' City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 375,000 Certificates of Participation (Capital Improvements Projects) Series I997B Year Ending Interest Principal Interest June 30, Rale Due Due Total 2003 5.000% S 85,000 $ 18,750 $ 103,750 2004 5.000 85,000 14,500 99,500 2005 5.000 205.000 10 250 215,250 The certificates are obligations of the City 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 I 997 Series certificates is to (1) defease $755,000 outstanding principal amount of Cape Girardeau (Missouri) Public Facilities Authority, Building and Equipment Leasehold Revenue Bonds (Airport Improvement Project) Series 1990B, and (2) pay the costs of issuance of the Series 1997B Certificates. The outstanding bond liability for the Series I 997 Certificates is recorded in the General Long -Tenn Debt Account Group. Principal payments are made annually on April 1, and interest payments are made semi-annually on April I and October 1. 42 43 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE E - LONG-TERM OBLIGATIONS - Continued $2,815,000 Certificates of Participation (Renaissance Aircraft) Series 2001 Year Ending Interest Principal Interest Joie 30 Rate Due Due Total 2003 S- $157,488 $157,488 2004 - 157,487 157,487 *2005 4.00% 90,000 157,487 247,487 *2006 4.25% 110,000 152,931 262,93t ,. *2007 4.30% 125,000 147,319 272,319 2008 4.55% 125,000 140,940 265,940 2009 4.625% 130,000 135,253 265,253 2010 4.80% 135,000 129,240 264,240 2011 5.00% 140,000 122,760 265,760 2012 5.80% 150,000 115,760 265,760 2013 5.80% 160,000 106,760 266,760 2014 5.80% 165,000 97,160 262,160 2015 5.80% 175,000 87,260 262,260 2016 5.80% 190,000 76,760 266,760 2017 5.80% 200,000 65,360 265,360 2018 6.00% 210,000 53,360 263,360 2019 6.00% 225,000 41,180 266,180 2020 6.00% 235,000 28,130 263,130 2021 6.00% 250.000 14,500 264,500 _ 2 815 000$1,987,135 $4,802,135 The certificates are obligations of the City under a Lease Purchase Agreement between the City and UMB Bank, NA. The Corporation also acts as the trustee who receives the rental payments for the benefit of the certificate holders. The purpose of the 2001 Series certificates is to construct and equip an airport manufacturing facility to be leased to Renaissance Aircraft, LLC. The outstanding bond liability for the Series 2001 Certificates is recorded in the General Long -Term Debt Account Group. Principal payments are made normally on April 1, and interest payments are made semi-annually on April I and October I. * Includes taxable certificates of $45,000, $50,000, and $55,000 in years 2005-2007 with 6.125% coupon. 43 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE E - LONG-TERM OBLIGATIONS - Continued The annual requirements to amortize all debt outstanding as of June 30, 2002 including total interest payments of $42,982,592 are as follows: The cash and investments available to service Revenue Bonds are $5,304,577 and $2,320,606 for the Sewer Fund and Water Fund, respectively. The cash and investments available to service the Leasehold Revenue Bonds in the Enterprise Funds and the General Long-term Debt Account Group are 5292,820 and $509,629 respectively. The cash and investments available to service the Certificates of Participation in the Proprietary Funds and the General Long-term Debt Account Group are $377,882 and $1,468,497 respectively. Included in restricted cash on the balance sheet of the Proprietary Funds is $4,456,757, which is the balance in the various project accounts which represent incomplete projects at June 30, 2002. If the y project funds are not used, the remaining balance can be applied against debt. 44 General Leasehold Certificates Year Ending Obligation Revenue Revenue of June 30 Bonds Bonds Bonds Participation Total 2003 $458,875 $6,511,922 $490,482 $1,218,844 $8,680,123 2004 458,125 6,685,982 286,283 1,243,368 8,673,758 2005 461,250 6,803,727 1,062,683 1,905,545 10,233,205 2006 - 6,975,872 39,050 698,313 7,713,235 2007 - 7,098,155 39,600 1,254,194 8,391,949 2008 - 7,304,773 40,050 346,785 7,691,608 2009 - 7,403,608 39,400 342,021 7,785,029 2010 - 7,029,620 39,700 346,600 7,415,920 2011 - 6,332,357 39,900 262,760 6,635,017 ' 2012 - 7,482,293 - 265,760 7,748,053 2013 - 5,058,676 - 266,760 5,325,436 2014 - 6,002,990 - 262,160 6,265,150 2015 - 5,773,795 - 262,260 6,036,055 2016 - 5,842,881 - 266,760 6,109,641 2017 - 5,827,232 - 265,360 6,092,592 2018 - 4,802,233 - 263,360 5,065,593 2019 - 2,834,163 - 266,180 3,100,343 2020 - 1,789,199 - 263,130 2,052,329 2021 1,664,550 264,500 1,929,050 1378.250 $109.224A28 $2,077,148 $10,264,660 $122 944.O8ti The cash and investments available to service Revenue Bonds are $5,304,577 and $2,320,606 for the Sewer Fund and Water Fund, respectively. The cash and investments available to service the Leasehold Revenue Bonds in the Enterprise Funds and the General Long-term Debt Account Group are 5292,820 and $509,629 respectively. The cash and investments available to service the Certificates of Participation in the Proprietary Funds and the General Long-term Debt Account Group are $377,882 and $1,468,497 respectively. Included in restricted cash on the balance sheet of the Proprietary Funds is $4,456,757, which is the balance in the various project accounts which represent incomplete projects at June 30, 2002. If the y project funds are not used, the remaining balance can be applied against debt. 44 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE F—PRIOR PERIOD ADJUSTMENT Beginning fund balance decreased and accumulated depreciation increased by $123,606 and $18,208 in the sewer and water funds respectively. Both of these adjustments resulted from constructed projects being completed in previous fiscal years and not being depreciated. NOTE G -DEFICIT FUND BALANCES/RETAINED EARNINGS The following individual funds have deficit fund balancesirctained earnings at June 30, 2002. Enterprise Funds Golf Course Fend $ 138,260 Softball Complex Fund 115,903 NOTE H - PENSION PLAN -� I. Pian Description The City of Cape Girardeau participates in the Missouri Local Govemmcnt Employees Retirement System (LAGERS), an agent multiple -employer public employee retirement system that acts as a conunon 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 401 A 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. FundinL Policy The City of Cape Girardeau's full-time employees do not contribute to the pension plan. The political subdivision is required to contribute at an actuarially detcmtined rate; the current rate is 9.0% (general), 8.2% (police) and 15.6% (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. 45 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE A - PENSION PLAN - Continued 3. Annual Pension Cost For 2002, the political subdivision's annual pension cost of $1,094,292 was equal to the required and actual contributions. The required contribution was determined as part of the February 29, 2000 and/or February 28, 2001 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.5% per year, ' compounded annually, (b) projected salary increases of 4.0% per year, compounded annually, attributable to inflation, (e) additional projected salary increases ranging from 0.0% to 4.2% per year, depending on age, attributable to seniority/merit, (d) pre- retirement mortality based on the 1983 Group ' Annuity Mortality table and post-retirement mortality based on the 1971 Group Annuity Mortality table projected to 2000 set back 1 year for men and 7 years for women. The actuarial value of assets was determined using techniques that smooth the effects of short-term volatility in the market value of investments over a five-year period. The unfunded actuarial accrued liability is being amortized as a level percentage of projected payroll on an open basis. The amortization period at February 28, 2002 was 15 years. Three -Year Trend Information Fiscal Annual Percentage Net Year Pension Of APC Pension Ending Cost(APCI Contributed Obligation 06/30/00 $ 924,313 100% $0 06/30/01 1,207,517 100% 0 06/30/02 1,094,292 100% 0 Required Supplementary Information Schedule of Funding Progress (a) (b) (b -a) (a/b) (c) [(b-a)/c)] Entry Age Unfunded UAL as a Actuarial Actuarial Actuarial Accrued Annual Percentage of Valuation Value Accrued Liability Funded Covered Covered Date of Assets Liability (UAL) Ratio Payroll Pavroll 02/28/00 20,882,363 18,314,435 (2,567,928) 114% 10,314,954 ( 25%) 02/29/01 22,858,664 20,495,003 (2,363,661) 112% 10,616,603 ( 22%) 02/28/02 25,373,273 21,626,719 (3,746,554) 117% 10,820,521 ( 35%) Note: The above assets and actuarial accrued liability do not include the assets and present value of benefits associated with the Benefit Reserve Fund and the Casualty Reserve Fund. The actuarial assumptions were changed in conjunction with the February 28, 2001 annual actuarial valuations. For a complete description of the actuarial assumptions used in the annual valuations, please contact the .. LAGERS office in Jefferson City. 46 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE I - INTEREST EXPENSE Interest cost, including handling charges, totaling $3,408,379 excluding $127,397 of interfimd interest, was incurred during the year ended June 30, 2002 No interest cost was capitalized as part of the cost of assets constructed during the period. NOTE. J - INTERFUND RECEIVABLES AND PAYABLES The following is a summary of inteafund balances as of June 30, 2002: Advance to/front other funds: 47 h Advo rtes from Adv_�n I '" (icncral Pund $ 667,500 $ - Equip mmit Rcplaccmatt Fund 140,000 sml,'Pund - 337,500 Airport Fund - 140,000 _ Solid Wa41a F.ud - 750,000 Gol f Course Fu nd - 390})00 Softball Complex Fund _„� 190 000 �j 8, �7 5�I(1 91 Nu7 5411 NOTE K - SEGMENT INFORMATION FOR ENTERPRISE FUNDS The City maintains five enterprise funds which provide sewer, water, solid waste, golf, and softball con7plex services. Segment information for the year ended June 30, 2002 was as follows: Softball Sewer Walcr Solid Waste Golff:ourse Cantplcx 'total F,md PimO Fuad Fund Fund I:'nternri_c Operating revenues $2,614,381 .$4,502,'106 $2,318750 5453,535 5135,072 510,024,444 Mpg .4600 1161,217 543,344 162,499 50,697 12,735 2,130,492 Operaling l ncome(L.,n) (263,7711) 532,486 176,623 (57,053) (249,506) 138,780 Opcmting bru,&rs in 1,611443 1,110,000 - 265,777 2,987,180 Na income Rao,,) 649;928 1,174,697 176-036 17501) 11,2i7 1936,79' Current Capital ComribWPons 103,928 6,223,927 7,500 - - 6,335,25, r, Property, Plant and Equipment Additions 4,060,059 6,305,752 147,713 15.272 - 10,524,790 Deletions (189) (1385) - - - (1,574) Nr, Working fat�ita! 9,096,859 1,100,476 924,007 (15,874) 22,256 11,527,, 24 '1 owl Assets 61,613,2,54 37,954,088 1,936,543 299,611 114,143 101,907,(539 nomL and OIImr Lang -Term DilbiliAcs Payhle fimn Operating Revenue' 39,269,482 9,981,636 2651100 - - 49516,118 Total Equity 520,928,927 $27,324A58 S(zo,121 S (138260) S (115,4031 S48,60fi343 47 h City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE L - RESERVATION OF FUND EQUITY ' At June 30, 2002, the City had reserved its fund equity as follows: oatemlFand R"'nad lar rntaguncy fund 5 2,789,690 Reserved for pigmid items 81,666 12escrved for advance 1 667, 500 Ra,u,i,ed for nlansnlatuu uninfenana HUAti Itererved fur encwnblanc-, 61,861 1__..4 Lt Tau Special limenue bands Cmrvcnllmi,% ;hors I and a It"."d fnr emergency fund s 66,397 Rcservcd It, prepaid items 2,425 Reamed for CnCi111Fun ncee 9,042 Rnsvrnd fnnii.er Cantpas 410,635 Al9utn Itcserved fur Prepaid items 12,071 Rlaotvcd lar cncumbrunccs 49,426 Rn,arved lbr l ung Tani Receivable 1,044,630 Rcaurved if,AiiTon Facdnies Putjeer 1,209,540 Pink, and Rcurcatiun Fund liescrved fnrprepaid hems 683 Rcservcd For cncun banes 70 I1 -1t6 ltoscrved far cntcrga¢y fund 42,023 R,,—udlor prepaid (ants gyp RusenedILr-an branco 5,281 Moloy Faal I a, Reserved tur awn obnnces 92,154 Cnpunl Inpnvemant Sales Tax p4'anu Pnjsfs) Racr.ad 16r cncrgenry fund 239,892 Capital Intpro.emen Sales Tax (I'I«xl Conlml) Reserved tur encumbrances 4,756 Capital Improvcnian Still, Tux(Sa,a, P,,,,,) Itcsaved fin anergency fund 298,248 Tnnsli...n Sudo Tux Trial Fund Ruscrvod fine,, nuhraual, 454,935 Tnnzponn(mn Salla Tux Trust bund II Itamncd for encu lfbnnces 1,S30,245 S.�4= Dant snnnti Fund Reserved fnr debt service $ 2,536,503 Rlacned fol emergency fond n51 001 s 287.504 Capital PnJcas Farads Oen n1 Capital Intpmvernem Fuld R ... -d lin cncmnbranue, S 15,444 Callinlarlity Development alwk Gnml Fund RcnW fur iii development lnai repnyincnts 36,839 lilactvcd till cncambnnee, 229,479 Park int nr ents R-cr,ed for unumbran— 10,2b7 .. Corp llWd Conlml Ru,ulvcd for n,,and novez 662 Wm®P11-1, Fund Rcservcd lm' u-nalbnuces 3677853 --J970 144 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE M - RESERVED RETAINED EARNINGS AND RESTRICTED ASSET ACCOUNTS As of June 30, 2002, the reserved portion of retained earnings for the Enterprise Funds are as follows: Smvcr Fund Reserved for debt service $ 105,000 Reserved for depreciation and replacement 127,000 Reserved for emergency fund 313,258 WaterFund Reserved for debt service 991,667 Reserved for depreciation and replacement 460,000 Reserved for emergency fund 719,831 Solid Waste Fund Reserved fo cau,igency fund 326.892 Total reserved retained earnings $3 Q43 648 At June 30, 2002, the City has restricted assets in its Proprietary Funds as follows NOTE N - 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, and an expense provision and related liability were recognized at that time based on the future closure and postclosure care costs that were estimated to 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 $207,000 as of June 30, 2002, 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, 2002. 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 has used the option of a Contract of Obligation as the financial assurance instrument for the landfill. 'Phe City issued bonds in October 1994 from which the proceeds have been used to pay the closure costs. 49 Depreciation Revenue Bond And Bond Sinking and Replacement (7wisttuction Reserve Fund Total SewerFund $127,000 $'4,456,757 $5,897,113 $10,480,870 Water Fund 460,000 - 2,385,509 2,845,509 Solid Waste Fund - - 94,448 94,448 Data Processing - - 29 29 Equipment Replacement Fund 30 30 $587,00 $4,456.7f7 $8 997 129 11 420 886 NOTE N - 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, and an expense provision and related liability were recognized at that time based on the future closure and postclosure care costs that were estimated to 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 $207,000 as of June 30, 2002, 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, 2002. 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 has used the option of a Contract of Obligation as the financial assurance instrument for the landfill. 'Phe City issued bonds in October 1994 from which the proceeds have been used to pay the closure costs. 49 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE O - RISK MANAGEMENT The City is exposed to various risks of loss related to torts; theft of, damage to and destruction of assets; errors and omissions; natural disasters and employee health benefits. These risks, with the exception of those discussed in the following paragraphs, are covered by commercial insurance. Settled claims have not exceeded this commercial coverage in any of the past nine 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 nine 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 workmen's compensation. Both of these are accounted for using internal service funds. Under each plan, the City is substantially self-insured and uses an administrator to handle claims management. The City provided health coverage to its employees through a self-insured plan from July 1, 2001 to December 31, 2001. Under this plan, the City paid Century Planners a monthly premium for claims administration. The City also purchased reinsurance from Perico LTD at an approximate annual cost of $150,000 to limit its claims exposure to $50,000 annually per insured and approximately $1,275,000 or 125% of actuarial expected claims for all insured. Other City funds were charged by the internal service fund at amounts that would cover actuarial expected claims of approximately $1,000,000, reinsurance costs, and claims administration costs. After December 31, 2001 the City provided health coverage to its employees through a minimum premium plan administered by Right Choice Managed Care, which had an "A-" rating by A.M. Best. Under this plan the City paid the administrator a monthly premium for claims administration, cost management, and specific and aggregate stop loss coverage. The City reimbursed the administrator for claims paid up to the specific stop loss amount of $75,000 annually per employee and up to the aggregate stop loss amount of approximately $1,100,000 annually for all employees. These limits apply only to claims made during the calendar year. Rates were charged by the internal service fund to the other city funds to cover the monthly premium to the administrator and claims up the aggregate stop loss amount. 50 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE O - RISK MANAGEMENT - Continued Corporate Claims Management, Inc administers the City's workmen's compensation plan. Under this plan, the City pays the administrator a per claim fee to administer its 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, for regular employees and police employees, respectively. Additionally, S 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-" by A. M. Best. Claims liability is estimated using data supplied by the administrator. The claims activity during the last four years is summarized as follows: CLAIMS LIABILITIES RECONCILIATION Health Workers' Insurance Compensation Total Balance, July 1, 1998 $ 220,000 $ 388,996 $ 608,996 Provision for Incurred Claims 478,229 121,155 599,384 Payment of Claims (698 2291 (212,946) (91 1,175) Balance June 30, 1999 $ - $ 297,205 S 297,205 Provision for Incurred Claims 778,268 252,105 1,030,373 Payments of Claims (628,268) (220602) (848,870) Balance June 30, 2000 $ 150,000 $ 328,708 $ 478,708 Provision for Incurred Claims 1,427,977 275,758 1,703,735 Payments of Claims (1,452977) (294,794) (1,747,771) Balance June 30, 2001 $ 125,000 $ 309,672 $ 434,672 Provision for Incurred Claims 1,274,192 327,400 1,601,592 Payments of Claims (1,274,192) (343045) (1,617237) Balance June 30, 2002 S 125 000 S 294,027 S 419 027 52 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE P - CONCENTRATION OF CREDIT RISK/BAD DEBT ALLOWANCE The City has uncollaterahzed 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 properly. The maximum accounting loss is the amount shown as utility charges receivable on the Combined Balance Sheet. At June 30, 2002, utility receivables totaled $2,142,491. On the financial statements, the utility receivables are shown net of the allowance for doubtful accounts of $1,004,295. This results in net utility receivable of $1,138,196. During the year ended June 30, 2002, the allowance was increased by $89,769 or approximately .9% of the current year's utility charges. The total allowance represents amounts accumulated since 1985. NOTE Q - COMMITMENTS AND CON'T'INGENCIES 1. Litigation 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, 2002, the City had construction commitments outstanding of $7,817,370. 4. Encumbrances As of June 30, 2002, the City had encumbrances outstanding of $8,176,243. 5. Environmental Remediation City management is aware of one instance of environmental contamination of City owned property. City management is actively resolving these concerns. A Plan Of Action has been approved by the Missouri Department of Natural Resources ("DNR") for the contamined site. ht the opinion of City management, the expenses associated with environmental remediation of these and other potential sites will not be significant to the City's financial statements. 52 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2002 NOTE R - CONTRIBUTED CAPITAL The changes in the contributed capital accounts for the enterprise funds were as follows: Solid Golf SofibalI Sources Sewer water Wamt Course ConC� Total Beginning Baluncc July 1, 2001 519,219,267 S 18,328,291 $297,090 $ 645 $ 54,689 $37,899,982 Contributing Scurccs: Donated ussct by &,elope,,, 15,020 16,220 - - - 31 '40 Connection Ices 74,020 - - _ 79,020 State & FMcra1 Grants 9-888 6,207,60 7,50( 6,124,995 finding Baluncc, lune 30, 2002 $1932),jo5 $24552118 53045911 S 649 S 546$ $44235217 53 City of Cape Girardeau, Missouri GENERALFUND COMPARATIVE BALANCE SHEET JUNE 30, 2002 AND 2001 2002 2001 ASSETS Pooled cash and investments $2,020,489 $1,788,143 Receivables, net of allowances for ,. doubtful receivables Real estate, personal property and merchant taxes 39,867 37,731 Sales tax 628,716 609,417 _ Franchise tax 1,258,126 1,258,818 Special assessments receivable 144,579 140,400 Interest receivable 395,397 351,912 Other receivables 17,890 25,232 Intergovernmental receivables Grants receivable 79,651 325,814 ,.. Receivable from other funds 60,000 - Advances to other funds 1,667,500 1,667,500 Inventories 115 197 Prepaid items 81,666 74,460 Total assets $6,393,996 $6,279,624 LIABILITIES AND FUND BALANCES Accounts payable $371,941 5330,493 Accrued liabilities Salaries, payroll taxes and benefits 26,017 25,426 Other liabilities 46,053 18,831 Due to other governments 162 205 Deferred revenue 217,635 191,675 y Total liabilities 661,808 566,630 Fund Balances Reserved for emergency fund 2,789,690 3,121,354 Reserved for prepaid items 81,666 74,459 Reserved for advances 1,667,500 1,667,500 Reserved for mausoleum maintenance 80,063 75,988 Reserved for encumbrances 61,861 29,584 Unreserved 1,051.408 744,109 Total fund balances 5,732,188 5,712.994 Total liabilities and fund balances $6,393,996 $6,279,624 54 City of0ape Girardeau, Missouri GENERALFUND SCHEDULE OF REVENUES AND EXPENDITURES a BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI REVENUES Tezes $11,912.086 $11773.%O (5136,736 License, ontl pc,r 1, 1,101,800 1,057,618 (44.182) Inlerg0venlmenlal 574,004 622,988 48,984 + Onar9es(or n0k,,c05 393,705 370 715 (22,990) InleNepaM1menlal services 755,250 724,064 (31,186) Fines and lodeitures 813,650 031 J08 17 758 Miscellaneous 66,356 134,454 68,108 Investment revenue 247960 21339 (34663) a Special assessments 1,000 603 (397) TOTAL REVENUES 15,865831 15,728,527 (137 304) EXPENDITURES ' Cumnt Adminllue.. sarvlres OAycoined 26,481 33,842 (7,361) Human resources 217380 216,924 464 City manager 224,339 224,590 (254) ' Public awareness 60,399 56,952 3.447 City attomey 200,327 190,019 1,300 Finan, 430,865 420,562 10,303 Irincepadournal 556.796 583225 (26,429) + Teal administrative services 1,716595 1 735117 (18,522) Oevelopmpnt services Planning services 351,965 364619 (12554) lick' ncn services 356.087 346,809 9,198 Engineering services 475.513 420,413 55.100 a Community and economic development 111250 116,501 (5251) Public transportation 375880 308,720 67,160 Total development servlms 1,670695 159042 113,653 Parks and recreation Parknouncrance 978,602 959,456 19,146 + Cemetery 142,670 137136 5,534 Facility maintenance 166245 151,930 14315 Total parks and recreation 1287517 1240,522 30,995 Public safely _ Municipal court 214501 214,646 (85) ' Polka 4,938,019 4,813,473 124546 Fire 3,301,503 3,367,201 14602 Hazard Mi0ua0on 75,000 74,700_ 292 Total public safety 5609 163 _ 0,470,100 139055 Public works ' Street 1698,140 1,670470 27,678 Slormwater 349,120 321288 27,832 Total pu06c works 20472688 1,991758 55,510 Contingency 107.780 115,125 (7,345) a TOTAL E%PENDITU RES 15,439,018 15117672 321346 EXCESS (DEFICIENCY) OF REVENUES a OVER (UNDER)EXPENDITURES 426810 610.855 184,042 OTHER FINANOING SOURCES (USES) Operating Uansfers o 1,325,858 ? 325,650 - + Opemtiog transfers cul (1982,650) (7962,650) 20,000 TOTAL OTHER FINANCING SOURCES (USES) J65. 791) (6367921 20,000 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER)EXPENDITURES AND OTHER FINANCING USES (3229 9791 (526937) $204,042 J5 t t 1 t i t e t Y t Gry al Po Glrnwau, Y VLREti`ExUE ftMOs� CGYBIDixC@YAxcE 6NEEi �wi,n Cump+rarvr"iwae�s Aan l¢xoeq dpo, 4WMai CgYN ownrwm M ImPrwam+m Impav+ ' Par�+stl YMw E>t.evin Snlae iaaPoPa,. raneponnlan ��: FLW Vn.m }dao aimw. Yn•XFL —t:! ' '*• 'SL^Y,=N Il='lSi1a'HI 1l_ tYa. m ^L^^ au5aN1 .luso o,A l'ubM=N R.tiYdY_ n55cTi 5Ngi59 $1¢255 5Id,9a 3a&f, Bt 32ew.�4V E.PS E1BBe Sv �Rwax sPNV,h 51tl:4su 3.Is,}11 "1"1 SisRPN l"i,.1 1., ,+V,M1«.a vsn P-11,11 P-ty Im 5. 56 Jp3 3�i SSdPBM SBttlo xi 36P.iJce A&:F90 6xeNe id+ xassry =i sd.,fi �� — �- �>= .2-2. unPienik5 nxp fUNO PYgNC35 56>5,P 31059] 5).e: 9?SS b3a6 L 15NSoa 319 b3x 335v aSYl's Eeoa )e0 52PSR bxrc,091 114,5 Av311tl+4ix x21 n,m ret u.iPsi °_ oum. .u. -. "l>,:a� o -,e �.._ ._ - _ -. oi_ e:'xao '➢�, » x _3 —P_E3 xaP, _ rzrexeP - - exnxa - - cw�.Fv - - - -� 11111 ..w zss u .. 1211111 121.p _ _ Pu K. - - ..w.e49 . _.,,,io_ av,eoP .a.. Pm.SPP asN zssrsm su zsli a,mP� =,_ .ma wue _ 5'.'a.ilR.. .._m. AA ANNEC, co.o�rx� fz. e.eeNONoxn„No oinx a...N�e AGE I'D mu...Enx ENDED ,.,.00. raoa DACIAI ox.*ow, NPrR'9kfx �.e^o.F �.rno�e,Ex'r x. x >ox. N - .No xow. x aED.-A. A LLao awo vaUao AIR <wroxt 3E<ac+±;RS x€^aex III V94- eaU L";SShSU�ti�s e8 xas -ACR "EI II $I. - N, ; - A � �, _ ..0 - RIO IYA 11 N, �i All —._— x�srvviYExmae.Nxax fxLm'x'IS)e[afNmrvNcS _ 1 �� _. ,� .- —. aeswNw_ aar .N �lY -11 " c<.,..r - E.r 1 6 1 "FI IIF - - - "I .>N.,,,,A - n1.1 - - awsE mx xr..xcno5«Nrccro Jrt _ 1 D2 —� —_f•�t � �._ �� i�91. _ __, _— _Nron ar AI—GEs ANNE RxlNU N O Ill NCA n0l�ry A xU Ai a dap aen mm5 wok e� ox ss 1ss 2MiIll umf FINANCINGUSES .2 'ER ;.SNUG lA A, IIEc dta'.91 -imU �Pf; ds. c. as, 1.+5+vB fllRse _ us 44NNag2. x n 594 .. .., .�_ i]�a`zae Sµ� EAG IC 171 INA ®�..— �_S..as W� �_ FuxU SnuxI Ss, Nxf JN f.NE", _Y461,'1 ,. x,.� cm".. �-.m ® City of Cape Girardeau, Missouri CONVENTIONNISITORS SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 BUDGET ACTUAL $1,248,000 $1,363,211 500 - 1,000 5,958 11,480 18,584 30,000 11.304 1,296,980 1,465,063 458,345 381,599 458.345 381.599 838,635 1,011,464 (620.000) (620,000) (620,000) (620,000) $218,635 $451,464 58 VARIANCE FAVORABLE (UNFAVORABLEI $115,211 (500) (1,042) 1,104 41,304 168,083 10,146 10,146 238,829 $238,829 REVENUES Taxes Intergovernmental Charges for services Miscellaneous Investment revenue TOTAL REVENUES EXPENDITURES Current Acrenistrative services a TOTAL EXPENDITURES i EXCESS(DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Operating transfers out TOTAL OTHER FINANCING SOURCES (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES City of Cape Girardeau, Missouri CONVENTIONNISITORS SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 BUDGET ACTUAL $1,248,000 $1,363,211 500 - 1,000 5,958 11,480 18,584 30,000 11.304 1,296,980 1,465,063 458,345 381,599 458.345 381.599 838,635 1,011,464 (620.000) (620,000) (620,000) (620,000) $218,635 $451,464 58 VARIANCE FAVORABLE (UNFAVORABLEI $115,211 (500) (1,042) 1,104 41,304 168,083 10,146 10,146 238,829 $238,829 59 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, 2002 VARIANCE FAVORABLE ® BUDGET ACTUAL (UNFAVORABLE) r REVENUES Intergovernmental revenue $269,000 $242,102 ($26,898) Charges forservirad 73,600 473,841 400,241 Miscellaneous 141,700 145,959 4,259 .. Investment revenue 2,500 27,093 24,593 TOTAL REVENUES 486,800 888,995 402.195 + EXPENDITURES Current Administrative services 1,542,949 11330,351 212,598 Debt Service + Principal 12,400 8,271 4,129 Interest end fiscal charges 7,705 14,909 (7,204) TOTAL EXPENDITURES 1,563,054 1,353,531 209,523 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (1,076,254) (464,536) 611718 OTHER FINANCING SOURCES (USES) Operating transfers In 407,194 407,194 - Bond proceeds (70,647) 2,101,468 2,172,115 + Other loan proceeds 182,015 182,015 TOTAL OTHER FINANCING SOURCES + (USES) 336,547 2,690,677 2,354,130 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES + OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES (5739,707) $2,226,141 $2,965.848 59 City of Cape Girardeau, Missouri DOWNTOWN BUSINESS DISTRICT SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 VARIANCE FAVORABLE BUDGET ACTUAL IUNFAVORABLEI REVENUES Taxes $16.400 $17,462 $1,062 Investment revenue 600 1,971 1,371 TOTAL REVENUES 17,000 19,433 2,433 EXPENDITURES Current Development services 17,000 26,210 (9,210) TOTAL EXPENDITURES 17,000 26,210 (9,210) r EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES $- ($6,777) ($6.777) 60 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, 2002 61 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI REVENUES Intergovernmental $- $1,256 $1,256 Charges for services 479.000 503,940 24,940 Miscellaneous 3.000 2,182 (818) Investment revenue 4,000 4.783 783 TOTAL REVENUES 486,000 512,161 26,161 EXPENDITURES Current Parks and recreation 1,266241 1240,653 25,588 TOTAL EXPENDITURES 1,266241 1,240,653 25,588 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (780,241) (728,492) 51,749 OTHER FINANCING SOURCES (USES) Operating transfers In 750,241 739,817 (10,424) TOTAL OTHER FINANCING SOURCES (USES) 750,241 739,817 (10,424) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($30,000) $11,325 $41,325 61 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, 2002 62 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) REVENUES Taxes $237,954 $240,500 $2,546 Licenses and perm;[. 5,000 8,656 3,656 InlergovernmerM1al 5,250 5,735 485 Miscellaneous - 3,003 3,003 Investmenlrevenue 15,840 35,400 19,560 TOTAL REVENUES 264,044 293,294 29,250 EXPENDITURES Current Public safely 256,784 246.374 10,410 TOTAL EXPENDITURES 256.784 246.374 10,410 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 7,260 46,920 39,660 OTHER FINANCING SOURCES (USES) Operating transfers out (280,000) (280,000) TOTAL OTHER FINANCING SOURCES (USES) (280,000) (280,000) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES X5272,]40 ($233,080) $39,660 62 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, 2002 BUDGET ACTUAL $1,425,000 $1,423,624 50,000 57,156 1,475,000 1 480,]80 93,003 93,003 1,4]5,000 1,38].]]] (1472,664) (1,472,664) (1,472,664) 11,472.664) $2,336 ($84,887) 63 VARIANCE FAVORABLE (UNFAVORABLE) ($1,3]6) ],156 5.780 (93,003) (93.003) (8],223) REVENUES Intergovernmental Investment revenue TOTAL REVENUES EXPENDITURES Current Public works TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Operating transfers out TOTAL OTHER FINANCING SOURCES _ (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES 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, 2002 BUDGET ACTUAL $1,425,000 $1,423,624 50,000 57,156 1,475,000 1 480,]80 93,003 93,003 1,4]5,000 1,38].]]] (1472,664) (1,472,664) (1,472,664) 11,472.664) $2,336 ($84,887) 63 VARIANCE FAVORABLE (UNFAVORABLE) ($1,3]6) ],156 5.780 (93,003) (93.003) (8],223) 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, 2002 64 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI REVENUES Intergovernmental $170.000 $12,515 ($157,485) Investment revenue 35,444 35,444 TOTAL REVENUES 170,000 47,959 (122,041) EXPENDITURES Current Public vmrks 375,450 14,132 361,318 TOTAL EXPENDITURES 375,450 14,132 361,318 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (205,450) 33,827 239,277 OTHER FINANCING SOURCES (USES) Operating transfers,n 87.888 87,888 TOTAL OTHER FINANCING SOURCES (USES) 87,888 87,888 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($206,450) $121,715 $327,155 64 City of Cape Girardeau, Missouri r CAPITAL IMPROVEMENT SALES TAX SPECIAL REVENUE FUND WATER PROJECTS SCHEDULE OF REVENUES AND EXPENDITURES - BUDGETAND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 r VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI REVENUES Taxes $1.963,750 $1,894,721 ($69,029) Investment revenue 14,500 82,970 68.470 TOTAL REVENUES 1,978,250 1,977.691 (559) EXPENDITURES a Debt Service Principal 695,000 695,000 - Interestandfiscalcharges 889,818 970,556 (80,738) TOTAL EXPENDITURES 1,584,818 1,665,556 (80.738) EXCESS (DEFICIENCY) OF REVENUES y OVER (UNDER) EXPENDITURES 393,432 312,135 (81,297) OTHER FINANCING SOURCES (USES) Operating transfers in - 593,716 593,716 Operating transfers out (383.432) (302,694) 80,738 TOTAL OTHER FINANCING SOURCES (USES) (383,432) 291,022 674,454 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES $10,000 $603,157 $593,157 65 City of Cape Girardeau, Missouri CAPITAL IMPROVEMENT SALES TAX SPECIAL REVENUE FUND SEWER SYSTEM IMPROVEMENTS SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) REVENUES Taxes $1,963.]50 $1,894,906 ($68.844) Investment revenue 34,500 48,752 14,252 I TOTAL REVENUES 1,998,250 1,943,658 (54,592) TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 1.998,250 1,943,658 (54.592) OTHER FINANCING SOURCES (USES) Operating transfers out (2,005,]]6) (1,611,443) 394,333 TOTAL OTHER FINANCING SOURCES (USES) (2,005,776) (1,611443) 394,333 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($),526) $332,215 $339,741 66 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, 2002 67 VARIANCE FAVORABLE BUDGET ACTUAL IUNFAVORABLEI REVENUES Inlergovennnental $- $91,344 $91,344 Investment revenue - 61,522 61,522 Spenlal assessments 3,065,000 81,]61 (2,983,239) TOTAL REVENUES 3,065,000 234,627 (2,830,373) EXPENDITURES Current Publlc works 1]],800 245,896 (68,076) TOTAL EXPENDITURES 1]],800 245,876 (68.076) EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 2,887,200 (11,249) (2,898,449) TOTAL OTHER FINANCING SOURCES (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES $2,887,200 ($11,249) ($2,898,449) 67 City of Cape Girardeau, Missouri TRANSPORTATION SALES TAX TRUST II SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 VARIANCE FAVORABLE BUDGET ACTUAL IUNFAVORABLEI REVENUES Taxes $3,765,000 $3,685,161 ($79,839) Investment revenue 84,912 84,912 TOTALREVENUES 3,765,000 3,770,073 5,073 EXPENDITURES Current Publicworks 5,126,000 3,919,321 1,205679 TOTAL EXPENDITURES 5.126,000 3,919,321 1,206,679 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (1,361,000) (149,248) 1,211,752 OTHER FINANCING SOURCES (USES) Operating transfers in 200,000 200000 TOTAL OTHER FINANCING SOURCES (USES) 200,000 200,000 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES($1,161,000) $50,752 $1,211.752 68 City of Cape Girardeau, Missouri FLOOD PROTECTION SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 09 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) REVENUES Investment revenue $- $26 $26 TOTAL REVENUES 26 26 TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES $- $26 $26 09 City of Cape Girardeau, Missouri VISION 2000 SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 BUDGET ACTUAL $- $2,151 ]5 REVENUES 1,500 Miscellaneous 1,500 Investment revenue (1,500) (17) 11500 TOTALREVENUES 1,500 EXPENDITURES Current Development services TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Operating transfers in ' TOTAL OTHER FINANCING SOURCES (USES) EXCESS (DEFICIENCY) OF REVENUES a AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES City of Cape Girardeau, Missouri VISION 2000 SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 BUDGET ACTUAL $- $2,151 ]5 2,226 1,500 2243 1,500 2,243 (1,500) (17) 11500 1,500 1,500 1,500 70 $- $1,483 VARIANCE FAVORABLE (UNFAVORABLEI $2,151 ]5 2,226 (]43) (]43) 1,483 $1,483 City of Cape Girardeau, Missouri DEBT SERVICE FUND COMPARATIVE BALANCE SHEET JUNE 30, 2002 AND 2001 2002 71 $821,234 973,540 982,428 22,049 306,936 15,419 260 $3,121,866 $7,722 326.640 334,362 2,536,503 251,001 2,787,504 $3,121,866 2001 $997,480 1,001,552 459,487 12,591 390,250 $285 400,472 400,757 2,198,337 275,617 2,473,954 $2,874,711 ASSETS Pooled cash and investments Non -pooled cash and cash equivilents Non -pooled investments Receivables, net of allowances for doubtful receivables Real estate, personal property and merchant taxes Special assessments receivable Interest receivable Other receivable Total assets LIABILITIES AND FUND BALANCES Interest payable Deferred revenue a Total liabilities Fund Balances Reserved for debt service Reserved for emergency fund Total fund balances Total liabilities and fund balances City of Cape Girardeau, Missouri DEBT SERVICE FUND COMPARATIVE BALANCE SHEET JUNE 30, 2002 AND 2001 2002 71 $821,234 973,540 982,428 22,049 306,936 15,419 260 $3,121,866 $7,722 326.640 334,362 2,536,503 251,001 2,787,504 $3,121,866 2001 $997,480 1,001,552 459,487 12,591 390,250 $285 400,472 400,757 2,198,337 275,617 2,473,954 $2,874,711 1 1 1 \ ! 1 1 1 1 i i 1 1 City of Cape Girardeau, Missouri CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET June 30, 2002 (With Comparative Totals for June 30, 2001) General Corp Capital Flood Street FAU Street CDBG Park Water Totals Improvement Control Improvements Grants Grant Improvements Protects 0130102 06130101 ASSETS Peeled cash and investments $298,120 $ 670,278 975,450 $352155 $105,892 $103,921 52.734,036 $5.039.852 46,043,8]4 Non -pooled cash and cash equivalents - - - - 1,8]8 32,981 6,435,2]] 6,470,136 13,083,691 Non -pealed Investments - 158,363 - - - - - 158,363 154,263 Grants receivable - 106,780 - 39,329 8,829 10571 - 165,509 269.672 Special assessments receivable - - ]9,03] - - - - ]9,03] 35732 Infemst receneble 127 77246 7,373 674 Tshl assets $298,120 $935,548 5854,487 $391,484 $115599 S14]4]3 59.176559 $11920,270 S1 9n587,906 LIABILITIES AND FUND BALANCES N Accounts payable $- $- $- $- $24.466 $24,375 $628,021 $676,862 $1,035806 Other llabllfies - - - - - - - - 66,918 Due to other governments - - - - 2,20] - - 27207 2,707 Deferred revenue ]9,03] 791037 35,732 Total liabilities 79,037 26,673 24,315 628,021 758 106 1142,163 Fund balances Reserved for academic devloan repymnh - - - - 367839 - - 36,839 1067949 Reserved for encumbrances 15444 662 - - 229,479 10,267 3,97,853 3,933,705 8,288,912 Uvesarved 282,676 934,886 775450 391,484 (175392) 112,831 4,870,685 7,191,620 10,049,682 Total fund balances 298,120 935548 775.450 391,484 89,926 123,D98 8.548,538 11,162.164 18.445,743 Total liabilities and fund balances $298,120 $935,548 5854,487 $391484 $116,599 $147,473 $9,176,559 $11,920,2]0 $19,587,906 L t Y 1 Y i i L i L 1 1 L L L 1 1 1 1 City of Cape Girardeau, Missouri CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES FOR THE FISCAL YEAR ENDED June 30, 2002 GENERAL CORP FAU CAPITAL FLOOD STREET STREET CDBG PARK WATER TOTALS IMPROVEMENT CONTROL IMPROVEMENTS GRANTS GRANT IMPROVEMENTS PROJECTS 2001-2002 REVENUES Intergovernmental $- $38666 $- $- $5]1,045 $10571 $- $620282 vestment revenue 18,99] 46,]]1 36.340 19.997 20,055 8401 509,347 657.908 Special assessments 2.695 2.695 TOTAL REVENUES 16.997 85,437 39035 19,997 591,100 18,972 509,34] 1280,885 EXPENDITURES Capital outlay 4,3]] 133,416 34015 186 932,963 124,760 6207,60] 7433,324 Debt service Interest and fisc61 charges - 5627 5,627 TOTAL EXPENDITURES 4,377 133,416 30,015 186 938590 124,760 6207,607 ]436951 V W EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 12.1320 (4],9]9) 9,020 19,811 (3,17 490) (105.788) (5,696.260) (6,158066) OTHER FINANCING SOURCES (USES) Operating transfers In 11.420 - 198.800 424 98.222 302,694 611,560 Operating transfers out - - - (33,358) (1703.716) (1737.074) TOTAL OTHER FINANCING SOURCES (USES) 11,420 196.600 424 64.064 (1401,022) (1,125.514) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES 24,040 (47,979) 207,020 19,811 (347,066) (40.924) (7,099,282) (7,283,580) FUND BALANCES, JULY 1 274,080 903,527 56.630 371.673 436,992 164.022 15,647,820 18,445,]44 FUN D BALANCES, JUN E 30 $298,120 $935548 $]]5450 5391484 $89926 5123098 $8,548,538 $11162,164 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, 2002 74 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) REVENUES Intergovernmental $388,890 $- ($388,890) Inveatmentrevenue 14,615 14,615 TOTAL REVENUES 388,890 14,615 (374,275) EXPENDITURES Capital outlay 480,360 4,377 475,983 TOTAL EXPENDITURES 480,360 4,377 475,983 EXCESS (DEFICIENCY) OF REVENUES OVER( UNDER) EXPENDITURES (91,490) 10,238 101,708 OTHER FINANCING SOURCES (USES) Traders in 11,420 11 420 TOTAL OTHER FINANCING SOURCES (USES) 11,420 11,420 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES )$80,050) $21,658 $101,708 74 City of Cape Girardeau, Missouri CORP FLOOD CONTROL CAPITAL PROJECT FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 BUDGET ACTUAL $- $38,666 25,000 40,758 25,000 79,424 130,000 133.416 130.000 133,416 (105,000) (53,992) (6106.000) ($58.992) 75 VARIANCE FAVORABLE (UNFAVORABLEI $38,666 15.]58 54,424 (3.416) (3,416) 51,008 $51008 REVENUES Intergovernmental revenue Investment revenue ' TOTAL REVENUES EXPENDITURES Capital outlay TOTAL EXPENDITURES ' EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES TOTAL OTHER FINANCING SOURCES ' (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES City of Cape Girardeau, Missouri CORP FLOOD CONTROL CAPITAL PROJECT FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 BUDGET ACTUAL $- $38,666 25,000 40,758 25,000 79,424 130,000 133.416 130.000 133,416 (105,000) (53,992) (6106.000) ($58.992) 75 VARIANCE FAVORABLE (UNFAVORABLEI $38,666 15.]58 54,424 (3.416) (3,416) 51,008 $51008 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, 2002 76 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) REVENUES vestment revenue $- $31,462 $31,462 Special assessments 2,695 2,695 TOTAL REVENUES 34,157 34,157 EXPENDITURES Capital outlay 198,800 28,565 170235 TOTAL EXPENDITURES 198,800 28,565 170.235 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (198,800) 5.592 204,392 OTHER FINANCING SOURCES (USES) Operating transfers In 198,800 198.800 TOTAL OTHER FINANCING SOURCES (USES) 198,800 198,800 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES $- $204.392 $204,392 76 City of Cape Girardeau, Missouri FAU STREET GRANTS FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 BUDGET ACTUAL $15,000 $17,186 15,000 REVENUES Investment revenue TOTAL REVENUES EXPENDITURES 17,000 Capital outlay TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES r OVER (UNDER) EXPENDITURES TOTAL OTHER FINANCING SOURCES (USES) EXCESS(DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES City of Cape Girardeau, Missouri FAU STREET GRANTS FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 BUDGET ACTUAL $15,000 $17,186 15,000 17,186 186 186 15,000 17,000 $15.000 $17,000 77 VARIANCE FAVORABLE (UNFAVORABLEI $2,186 2,186 (186) (186) 2,000 $2,000 s REVENUES Intergovernmental nvestment revenue TOTAL REVENUES EXPENDITURES Capital bulla, Debt service Interest and fiscal charges TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 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 City of Cape Girardeau, Missouri COMMUNITY DEVELOPMENT BLOCK GRANT FUND SCHEDULE OF REVENUES AND EXPENDITURES BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 BUDGET ACTUAL $478,000 $571,044 17,312 478,000 588,356 970,000 629,017 5,627 970,000 634,644 (492,000) (46,268) 424 (5492,000) ($45,864) 78 VARIANCE FAVORABLE (UNFAVORABLEI $93,044 17,312 110,356 340.983 (5,627) 335,3::6 445.712 424 424 $446.136 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, 2002 BUDGET ACTUAL $330,656 $10,571 22] + REVENUES Intergovernmental 8].89] Investment revenue 8],89] TOTAL REVENUES (84,664) EXPENDITURES Capital outlay a (33,358) (33,358) TOTAL EXPENDITURES ' EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES ' OTHER FINANCING SOURCES (USES) Operating transfers In Operating transfers out TOTAL OTHER FINANCING SOURCES (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES 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, 2002 BUDGET ACTUAL $330,656 $10,571 22] 338,656 1],]98 423.320 8].89] 423,320 8],89] (84,664) (70,099) 98,222 98,222 (33,358) (33,358) 64,864 64.864 ($18,800) ($5,235) 79 VARIANCE FAVORABLE (UNFAVORABLEI ($328,985) ],22] (329,858) 335,423 335.423 14,565 $14,565 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, 2002 PROJECT PRIOR CURRENT TOTAL BUDGET YEARS YEAR TO DATE REVENUES Interest $- $2,722,718 $480,074 $3,202,792 TOTAL REVENUES 2722,718 480,074 3,202,792 EXPENDITURES Capital Outlay 26,500,000 22,907,988 2,194,659 25,102,647 Debt service Interest and fiscal charges 46,828 46,828 a. TOTAL EXPENDITURES 26,500,000 22,954,816 2,194,659 25,149475 EXCESS (DEFICIENCY) OF REVENUES �. OVER (UNDER) EXPENDITURES (26,500,000) (20,232,098) (1,714,585) (21,946,683) OTHER FINANCING SOURCES (USES) .. Operating transfers in 1,300,000 5,227,692 302,694 5,530,386 Operating transfers out 25,200,000 (2,155,196) (1,703,716) (3,858,912) Bond proceeds 25,115,063 25,115,063 TOTAL OTHER FINANCING SOURCES (USES) 26,500,000 28,187,559 (1401,022) 26,786,537 y EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES $- $7,955,461 ($3,115,607) $4,839,854 8� City of Cape Grumman, Missouri ENTERPRISE FUNDS COMBINING BALANCE SHEET June 30, 2002 (With Comparative Totals for June 30, 2001) 81 Solid Golf Softball Totals Sewer Water Waste Course Connote1Q 13102 06/30101 ASSETS Pealed rash and investments $750,529 ` 792,9061 $746,2601 $17,442, $58,941-' $2366,078 1,037.356 Non Traded cash 6 cash oeulvalenla 19,380 ` - - 19.386 54.425 + Utility changes receivable (net of allowance for doubtful receivables) 332,396 595,959 209,841 - - 1,138.196 1,201,544 Spacial assossmonls receivable 375,461 120,375 - - 603,836 627,555 Interest receivable ],194 16,460 1 546 - 25,200 83,627 Other receivables 11,640 72,060 26604 159 - 112363 58,000 + Grant mein --les 94,829 12,22500 7,133500 - 2,986 117,675 34.998 Inventories - 131,763 - 3,952 - 135,715 140,713 Restricted as.ela Npmpopled cash and rash equmalanls 122187- - - - - 122,187 100,162 + on pr ed ime9men15 10,085,021+ 1 68255, 6,698+ - - 11,77],804 13,944,064 Pooled cash and lnveslm.nLs 273,662, 1,159,254+ 07,750' - 1520,666 1,752,110 Prepaid hams 462.048 124,213 11,195 444 375 51 687,548 12,534355 4719470 1,099.429 21,997 62302 18,437,553 20.602110 + PrapaM, plant and eeupmenl Land 135.869 - 112,240 - - 248.109 248,109 B 8,178,738 209477 812,404 53,802 7,720 9,263,141 9,254,881 I mpmvemenI, pllmr buildin95 42,894717 16.472,957 222,664 389,033 33050 59512,421 65803,007 'a prolamine 2,0<1,915 1.281.819 1,624,602 446322 170.989 5,567,648 4,708342 Locations -In prugress 12 264,881 19,090046 31 354 927 25405,118 65.017,121 37,054,299 2,771,910 891,157 211,759 105946.246 95,419457 + may accumulated coproducer, _15-9938,222- _ 3.019.681 1,934796 _623,543 159,910 22,476.160 20,205,039 49078899 33234618 837114 267.614 51.841 63,470,086 75114.418 Total assets $61.613,254 $37.954,088 $1,936.543 $289,611 5114,143 $101,907,639 $95,816,528 LIABILITIES AND FUND EQUITY + Accounts payable $256,059 $288,098 $83,132 $13,212 $24,264 $664,765 $9913,265 Accrued liabilities Sel-depaymll taxes and benefits a6,176 660 26.850 22,014 15,782 111,482 105,643 Notes Payable - 3 3 6,302 Interest payable 597.519 187,744 3.804 - 789,067 448,427 + Other liabilities 177,591 138,533 61.673 2.645 - 380,402 386,313 Due to other govemmenl, - 28,959 - - - 28.959 28,173 Current porion of long-term debt Revenue bonds payable 2,191,000 575.000 2766000 2.605,000 Leasehold revenue bonds payable 169,151 - - - 169,151 267.602 + Longterm debt net of current anchor Revenue bonds payable 35304,331 9,021,636 - - - 45,325.967 47,198,658 Le3eeho10 revenue bonds payable - - - - - - 166,460 CeNYicatas of prr icioali a 605,000 385,000 265,000 - - 1,255,000 1256,000 + Advance from other food, 337,500 - 750,000 390,000 190,000 1,667,500 1,667,500 Estimated tand011 dosore and .at absure care all finfacy 143.000 143,000 20,000 Total liabilities 40,684327 1,333422 427,871 230,046 53,301,296. 55,340,423 + Fond ecuty _10625.630 _ Contributed capital 19.323 195 24,552,110 304,590 645 54,689 44,235,29 37,899982 Retained earnings reserved far debt service 105,000 991,667 - - - 1,096,667 186,667 Reserved far reparation aha reptaremm,l 127,000 460,000 - - - 587,000 - Scabbard toromar9encylund 313,258 719,031 326.892 - - 1,359981 909,869 Unmsarced 1,060,474 604042 (26361)13�17( an had) 1327456 1,479,587 Total fund equity 20926927 27.320458 60312113�1115903) 48.606343 40476,105 Total liabilities and fund equity $61,613,254 $37,954,086 $1,995543 5289,515 $114,143 $101,90,639 $95016,528 81 82 City of Cape au. Missouri + ENTERPRISE FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGESIN RETAINED EARNINGS FOR THE FISCAL YEAR ENDED June 30, 2002 + SOLID GOLF SOFTBALL TOTALS SEWER WATER WASTE COURSE COMPLEX 2001-2002 OPERATING REVENUES Residential charges $1,524,225 $2,557,015 $1734438 It $- $5,816,478 '+ Commercial charges 976,754 1,780,913 24,076 - - 2,781.743 Transfer sta0on charges - - 519,812 - - 519,812 Equipment sales - - - 8.201 7,311 15,512 Concession revenues - - - 67,283 67,735 135,018 + Golf course fees - - - 374,791 - 374,791 Softball complex fees - - - - 60,026 60,026 Other fees and charges 47,399 159,430 39,191 - - 246,020 Other miacellaneooe 66,003 4,548 1,233 3,260 751044 + TOTAL OPERATING REVENUES 2,614,301 4502,706 2,318,750 453,535 135,072 10,024444 OPERATING EXPENSES Personnel services 930,340 115,934 993,221 267,577 274,991 2,532,063 + Materials and supplies 255,659 368,886 62,625 62,806 57,016 806,992 Contractual services 111.699 2,725,603 716,238 20,518 9,276 (1,583334 General operating expenses 35,804 152,341 32,625 45,109 49,793 315,672 Special projects expense 109,620 12,499 13,400 7,900 9,275 1576.94 + Internal service expenses 73,812 51,613 156,519 55,981 21,492 359.417 Depreciation expense 1,361,217 543,344 162,499 50,697 12,735 2,130,492 TOTAL OPERATING EXPENSES 2,878.151 3,970,220 2,142,121 510,588 384578 9,885,664 OPERATING INCOME (LOSS) (263,770) 532,486 176,623 (57,053) (249.506) 138780 NON-OPERATING REVENUE (EXPENSES) + linu"finenl revenue 575,649 182,511 55,674 2,891 2,196 818,921 Federal graals 94,829 12,225 135 - 2,986 110,175 Loss on sale of assets - (389) - - - (389) compensation for damages - - 181 - - 187 Issuance c0sl arniizalipn (f0,634) (18.893) (435) - - (89,962) Interest end handling casts1,29{ 7,589) (643243) (56,148) (20,919) (10,196) (2 028095) TOTAL NON-OPERATING REVENUE (EXPENSES) (697 745) (46'7789) (587) (18.028) (5014) (1,189,163) INCOME (LOSS) BEFORE OPERATING TRANSFERS (961,515) 64,697 176,036 (75,081) (254,520) (1,053,333) Operating transfers In 1511,443 1,110,000 _265 737 2987.180 + NET INCOME (LOSS) 649,928 1,174697 176.036 (75,081) 11,217 1,936797 RETAINED EARNINGS (DEFICIT), JULY1 1,079,410 1,619851 122,495 (63,824) (181,609) 2,96,123 + PRIOR PERIOD ADJUSTMENT (123.6U8) (18,206) (-41,314) RETAINED EARNINGS (DEFICIT), JUNE 30 $1,605732 $2,776.340 $298.531 ($138905) ($170.592) $4,371,106 82 83 Cy Of cape Glmmezq Missouri ENTERPRISE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE FISCAL YEAR ENOEO JUNE 30, 2002 SOLID GOLF SOFTBALL TOTALS EWER WATER WASTE COURSE COMPLEX jy Lfl 2QD� r CASH FLOWS FROM OPERATING ACTIVITIES'. OpoaL n OC.'ne;lossl (263,770) 132 nOF 1/0¢23 '17ni091 I2112rLEI I3F 711 AJ,Ime¢e 10 reronole omraJy mole Io rill,le a",T), ml"alim..es. D,P,, for, 1E6-.17 543,341 112Ile S1,E92 1273E 21.TO4TL '• GSL ov,'a'. ny grin's V1 J J1 01 B2S 12225 135 - 1986 1'.1115 ICI,,, n :u 01ie0Ji ties 0eaeas er e."]1, 163 A 12 :1,120 i , 175 (298`, 10AJor,, II asle e;—„II10 P—p' - 59 53 65261 15911 - 49%? U0)le, e.—n,.... .hl lbms 6211 (S) 9 5 I'll! in a¢onnlS he'll. "T Go') 135909 1171 3w 2114 I333b911 zo ossm eaenm 11 ev'u.a li JbI 326 744 291 6928 4419 1 6n s1 I 7e m.o.a:. 1,n1, voa 7oa4e aa ,�e B, Ifi/SC' _ wo NET CASH PROVIDED BY IUSED IN) OPERATING ACTIVITIES 1 103 046 1274375 291737 11 6931 _2324341 24A 071 CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES: Op.mung lrar A,F hlmm otherinn9r 111 14l 1 np000 215137 2 FF A y� NET CASH PROVIDED BY (USED IN) BY NONCAPITAL FINANCING ACTIVITIES _ 1611443_ ,1 mfiOE _ 205n7 1597100 CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES. cop if pail wrvwe v m Oonris (I"II'll [4Ei.11l) - - - 7m, (1TtP17h) P,OFilll Pmn on ahaLeoome 12E3,mU - - - 21F ellP crergy n8n pnyabc or.lanl nlo.. l JOEITS - i'OF') - h we, I p g Lois (1291 3891 16,12431 IG6,112) UG 110,9191 (101961 .e uFfi, hwo6 TO 038 7221 111,923) (141 ]12 I os rrzJ - 420lO,11 w2�9s4s1 .� '0r1✓ 79,020 11 LOT CL,, las. JI Fael assal5 - - 7500 - - 7.50c Compe:4aLon for la11.9es _ _ 1” NET CASH PROVIDED BY WSEO IN) CAPITAL AND i RELATED FINANCING ACTIVITIES 767 Fer, .$(,J_ 198 ffi2_ 3� i0.iIll CASH FLOWS FROM INVESTING ACTIVITIES'. HE ... 1,F sa ¢s tnvns �n 11152 '0.1 enls 0014 06 51420 - 5l308n Oh,.14-ITI— C1. 43377 44014 261J 1C/6 11611E a - - - nrI,LislmaVsflo 21499 - - 28654 FMV casn =910 LE49 _ JG L49 11 G6C 323 5h7?E NET CASH PROVIDED 9Y (USED IN) INVESTING ACTIVITIES 575649 111111 1 _ 55674. _.L 590 311 010922 INCREASE(DECREASE) IN CASH AND CASH EQUIVALENTS 11117311, 73N4 150859 13$0921 21 241 119618241 CASH AND CASH EQUIVALENTS, JULY 1 _117LIFEE _ 225_ 1591 609 BC9 $J 3WI _ _ 331090 _- —11,11 CASH ANO CASH EQUIVALENTS, JUNE 30112oC7fi7 �06384e1mb 540708 1/447 0 1 n__ kTLke i 83 84 City of Cape Girardeau, Missouri SEWERFUND SCHEDULE OF REVENUES AND EXPENSES- XPENSESBUDGET BUDGETAND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED Jr.. 30, 2002 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) OPERATING REVENUES Residential charges $1,460,000 $1,493,952 $33,952 Commercial charges 968,000 999,424 31,424 Other fees and charges 37,000 47.399 10,399 Other miswllane4us 40,000 66,003 26,003 „r TOTAL OPERATING REVENUES 2,505,000 2,606,778 _101,778 OPERATING EXPENSES _ Personnel services 903,959 930.341 (26386) Materials and supplies 239,032 255,659 (16,627) CgrMactoal services, 141,855 99.314 42,541 General Operating expenses 33,425 35,604 (2.379) r Special projects expense 40,400 109,620 (69,220) Internal service expense 86,014 73,812 12,202 Capltel outlay 2.694,277 2495,411 198.866 TOTAL OPERATING EXPENSES 4,138,958 3,999.061 _ 138.997 OPERATING INCOME {LOSS} (LG33,958) (1,393,183) 240.775 NON-OPERATING REVENUE (EXPENSES) investment revenuo 62,000 705,489 643,489 Federal grants - 104,718 104.718 ImPAO fees 150,000 79,020 (70980) Sewer assessments 57,000 91,440 94,440 Prinolpel payments (1,991,279) (2,357,602) (366,323) interest antl handling msis 1892.495) {497,2715 895,417 TOTAL NON-OPERATING REVENUE (EXPENSES) (2,614,774) 'L874213) 240,561 INCOME (LOSS) BEFORE OPERATING TRANSFERS (4,248732) (3.267,3%) 981,336 Optn.bng fransph, In 2,005,776 _ 1,611,443 (394.333) NET INCOME (LOSS) i",2242,9562 x$1,65, 9131 $S&I,W3 84 City of Cape Girardeau, Missouri ,. WATER FUND SCHEDULE OF REVENUES AND EXPENSES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI OPERATING REVENUES Residential charges $2,642,000 $2,585,426 ($56,574) Commercial charges 1.863,000 1,825,637 (37,363) Other fees and charges 172,500 159,430 (13,070) Other miscellaneous 13,500 4,548 (8,952) TOTAL OPERATING REVENUES 4,691,000 4,575,041 (115,959) OPERATING EXPENSES Personnel services 115,266 115,931 (665) Materials and supplies 336,390 373,462 (37,012) Contractual services 2,746,638 2,725,088 20,950 General operating expenses 133,500 152,341 (18,841) Special projects expense 45,000 12,499 32,501 Internal service expense 52,282 51,613 669 capital outlay 83,627 81,925 1.702 r TOTAL OPERATING EXPENSES 3.512.103 3512 799 (696) OPERATING INCOME (LOSS) 1,178,897 1,062242 (116,655) ' NON-OPERATING REVENUE (EXPENSES) nvestmentrevenue 117,000 140,532 23,532 Federal grants - 12,225 12,225 Water assessments 17,000 32,279 15,279 i Principal payments (515,000) (515,000) - Intereslandhandlingcosts (600,214) (604,131) (3,917) TOTAL NON-OPERATING REVENUE (EXPENSES) (981,214) (934,095) 47,119 INCOME (LOSS) BEFORE OPERATING TRANSFERS 197,683 $128,147 ($69,536) s Operating transfers in 1,110,000 1,110,000 NET INCOME (LOSS) $197,683 $1,238,147 $1,040,464 $'i City of Cape Girardeau, Missouri SOLID WASTE FUND SCHEDULE OF REVENUES AND EXPENSES. BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 VARIANCE FAVORABLE ACTUAL (UNFAVORABLEI $1,743.312 $5,812 26,955 3,955 508,068 (27,100) 39,191 4.941 1,233 (267) 2,318,759 (12,659) 994,258 37,594 63,160 29,590 717,592 BUDGET 32,625 OPERATING REVENUES 77,951 11,924 Residential charges $1,737,500 42,911 Commercial charges 23,000 322,916 Transfer station charges 535,168 Other fees and charges 34,250 Other miscellaneous 1,500 TOTAL OPERATING REVENUES 2,331,418 OPERATING EXPENSES Personnel services 1,031,852 Materials and supplies 92,750 Contractual services 754,635 General operating expenses 27,284 Special projects expense 89,875 Internal service expense 140,841 Capital outlay 270,695 TOTAL OPERATING EXPENSES 2,407,932 OPERATING INCOME (LOSS) (76,514) NON-OPERATING REVENUE (EXPENSES) Investment revenue 19,500 Local grants 7,500 Federal grants - Compensation far damages - Principal payments (6,379) Interest and handling costs (53,933) r TOTAL NON-OPERATING REVENUE (EXPENSES) (33,312) NET INCOME (LOSS) ($109,826) 86 VARIANCE FAVORABLE ACTUAL (UNFAVORABLEI $1,743.312 $5,812 26,955 3,955 508,068 (27,100) 39,191 4.941 1,233 (267) 2,318,759 (12,659) 994,258 37,594 63,160 29,590 717,592 37,043 32,625 (5,341) 77,951 11,924 156,519 (15.678) 42,911 227,784 2,085,016 322,916 233,743 310.257 44,014 24,514 7,500 - 135 135 187 187 (6,379) - (56.148) (2,215) (10,691) 22,621 City of Cape Girardeau, Missouri GOLF COURSE FUND SCHEDULE OF REVENUES AND EXPENSES. BUDGET AND ACTUAL (BUDGET BASIS( FOR THE FISCAL YEAR ENDED June 30, 2002 VARIANCE FAVORABLE BUDGET ACTUAL !UNFAVORABLE) OPERATING REVENUES Equipment sales $8,000 $8,201 $201 Concession revenues 73,000 67,283 (5717) Golf course fees 420,500 374,791 (45,709) Other miscellaneous 3,260 3,260 TOTAL OPERATING REVENUES 501,500 453,535 (47,965) OPERATING EXPENSES y Personnel services 267,337 267,577 (240) Materials and supplies 65,130 60,832 4,298 Contractual services 19,337 20,518 (1,181) Gen eraI opera0ng expenses 48,850 44,042 4,808 y Special projects expanse 6,700 7,900 (1,200) Internal service expense 59,700 55.981 3,719 Capital outlay 16,595 15,272 1,323 TOTAL OPERATING EXPENSES 483.649 472.122 11,527 ' OPERATING INCOME (LOSS) 17,851 (18,587) (36,438) NON-OPERATING REVENUE (EXPENSES) Investment rovenue 2,500 2,513 13 Interest and handling Coate (19,500) (20,919) (1.419) ' TOTAL NON-OPERATING REVENUE (EXPENSES) (17,000) (18,406) (1,406) INCOME (LOSS) BEFORE OPERATING TRANSFERS 851 (36,993) (37,844) NET INCOME (LOSS) $851 ($36.993) ($37,844) 87 City of Cape Girardeau, Missouri .. SOFTBALL COMPLEX FUND SCHEDULE OF REVENUES AND EXPENSES. BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 VARIANCE FAVORABLE ACTUAL (UNFAVORABLEI $7,311 ($4,689) 67,735 2,735 60,026 BUDGET 135,072 OPERATING REVENUES 224,991 14,084 Equipment sales $12,000 9,276 Concession revenues 65,000 (1,443) Softball complex lees 67,000 21.492 TOTAL OPERATING REVENUES 144,000 OPERATING EXPENSES Personnel services 239,075 Materials and supplies 56 950 Contractual services 10,502 General operating expenses 48,350 Special projects expense 10,000 a Internal service expense 25,260 TOTAL OPERATING EXPENSES 390,237 OPERATING INCOME (LOSS) (246,237) NON-OPERATING REVENUE (EXPENSES) Interest income Federal grants - Interest and handling costs (9,500) a TOTAL NON-OPERATING REVENUE (EXPENSES) (9,500) INCOME (LOSS) BEFORE OPERATING TRANSFERS (255,737) Operating transfers in 255,737 NET INCOME (LOSS) 88 VARIANCE FAVORABLE ACTUAL (UNFAVORABLEI $7,311 ($4,689) 67,735 2,735 60,026 0.974) 135,072 (8,928) 224,991 14,084 57,016 (66) 9,276 1,326 49,793 (1,443) 9,303 697 21.492 3.768 371,871 18,366 (236,799) 9,438 1,876 1,876 2,986 2,986 (10,196) (696) (5,334) 4,166 (242,133) 13,604 265,737 10.000 $23,604 $23,604 89 City of Cape Girardeau, Missouri INTERNAL SERVICE FUNDS a COMBINING BALANCE SHEET June 30, 2002 (With Comparative Totals for June 30, 2001) Employees' Data Fleet Fringe Risk Equipment Totals Manaoement Benefit Manaaemen( Reolacemenl 06130102 O030101 ASSETS Pooled moor antl investments $94,3681 $235,3431 $321,813r 1,3654]11 $369.5031 $2,386,498 2,378253 Non -p bi do,M1 and cash equivalents 10,5851 - - 10,505 10.585 Non pooled investments - - - 231,]251 - 231,725 200,360 I merest mceivable - - 4,766 - 4766 3647 Other receivables 5,132 5,290 10,234 22,648 - 43304 50,325 Advance to Other foods - - - - 140,000 140.000 - Inventories - 3,890 - - - 3.890 5,139 Restrictedassets N end rasM1 equ valents o1items 29 - - - 301 59 66 Prepaid aitl items 11,781 11]61 1994 - _ _ 967 2,171 16.013 25.519 111310 246,417 342.632 1,625.6]] 511,704 2,837,640 2,673,916 Properly, plant and equipment Land 31,500 37,500 37,500 643 440,960 - - - 449.603 449003 improvements ollmr bulMln9s - 113,749 - - - 113,749 113749 y Equip Equipmen! 1,547,208 445 455 - _ - 1.947,223 3939,886 3725.501 1,547,851 1,045,664 - 1,947223 4,540.738 4,326353 Less amumulated depreaetien 1,133]03 670,342 888,260 2,92385 2,334,482 414,068 375322 _ 1,050,963 1.848,353 1.991061 Total assets $526378 $621739 $342,632 $1,625.5]] $15]0,66] $4.685,093 $4,5-c,7]] LIABILITIES AND FUND EQUITY Accounts payable $6,338 $56,19] $15,276 $3,909 $ $81,720 $105,366 Accrued sources Salaries, payroll laxer and benefits 5,492 10,497 - - - 23,989 23,509 Interest payable 1715 3 - 1,861 3,579 5.142 Other liabilities 67 - - 67 63 Estimated claims payable - 125.000 284,027 - 419027 434,672 Due to other governments - 690 - 690 1,140 � Curtest gonion o(lonqlenn debt Confirm- of padicipenien 70000 - - 25.000 95000 125,000 Long foot debt not of cunenl pedion certificates pl panlclpallon 69,959 124,788 194.]4] 294,625 Total llabllitles 153,504 75454 140,276 297,936 151649 018619 _ 989,517 Retained gamin, Unreserved 3]1,8]4 546.206 203,3= 1,32].641 1,419018 3,067,174 3676,260 Total fund equity 3]1,074 546,285 202.356 1,32],641 1 419,018 3 174 3,670,260 Total liabilities and fund equity $525378 $621,]39 $342,632 $1,625.5]] $1,570,667 $4,605,993 54,605777 89 City of Cape GOardeau. Missouri INTERNAL SERVICE FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS FOR THE RSCAL YEAR ENDED Juue 00.2002 ,nr EMPLOYEES' DATA FLEET FRINGE, RISK EQNPMENT T6AL5 Pte` SSIN - MA A NEW Ni BENEFIT-ENMANAGEMENT SPLA MT 20311 002 OPERATING REVENUES I"EVop"'riumal sarvlcree 5392000 $986.772 $1,132012 $281,663 529EGE) 83,642,%2] ,her mispellltrreous 1306_ TOTAL OPERATING REVENUES 352.W0 m LUS 1132.012 2611iG3 290,980 _3,644,223 OPERATING EXPENSES pr,,.nuBr N,Eo6 1921511 501,432 - 594,413 Mal.,ols and sup plies 13.810 266,90 - 329 281,086 CuUE.uelservires 62.305 168.936 1,566,550 394369 2,217150 GeneIDl epe dUrg mpemas 6,592 I.E63 - 10,018 20.273 Intervlol service RWonses 2,506 1508 Depmtlatbn Gp.uso 199 727 44.404 - - 243.739 48?870 TOTAL OPERATING EXPENSES oWeN 390,L5 66550 404,706 243,139 3.603J30 + OPERATING INCOME (LOSS) _(A9.9d5) 1,716 165.462 _�23,04� 461$41 401993 NON OPERATING REVENUES (EXPENSES) .� InvbsYnenl rl o— 1.620 4,356 23,798 91,O75 ",733 138613 Gam mr Eale or rise's eon - - 600 Loss on sola o(assets (37293; (1,660) - - (3Q967) Compcnsumn brdamages 1 121 1,121 Issuflnpe test emprllzalion (1.299) (t.t2]) (2 sO') �r Inlore»l old handlluo costs _{9,fi15) _ (596) - __-_ �� _ 2(031]I TOTAL NON-OPERATING REVENUES (EXPENSES)(46,592) 9,812 23.1y8 91,0]6 6,4100 13 W4 INCOME(LOSSI BEFORE OPERATING TRANSFERS (A6,537) 5,590 189,220 (31.961) 53,141 119411 0peOlE9 F'G" In - 2731Ci1 273.2D0 OPeralin9lmrelarsour _— ___L28 233). _L173 WOL__..._ .... (201 ]33) ~ NET INCOME (LOSS) P%E3T) S2.SC3) imO, (EN,) 326.MI `3V,414 RETAINED EARNINGS (DEFIG IT), JULY1 49HAII 56892E 138636 1,359608 l,Nr 2,(122 3=f160_ s RETAINED EARNINGS(DEFIC IT), JUNE30 _ 53118]4 $546285 $2U2=356 $1327,641 E1419,U'I8 51=161,114 90 w. Clly of Cap, Glm.d—, Mino', OTERNA L SERVICE FUNDS N L OF CASH FLOWS FOR THE FISCAL YEAR ENDED JUNE )0, 20U2 SMILE DATA wOFES RISK EOOmMENT TOTALS PROC ESS NG MANAGEMENT MANAGEMEN! REPLACEMENT 32001VC2 CASH FI O WS FROM OPERATING ARM TIE S. C" �a1n9 �an asl 1 1,,, 1T ill To, 0I ITT rybtl 11,E;, xaBPA Nr ePm onm. O CI P 19e Lo atee6 1 IT IIaF,I 111 RU Feeneom 1,5 , ; lo we_ agJee 14Bl (l) 31 li F lill, 1G IF,, 21,11, a.np cu_J aO I�J11IIIJI HC�6 f5) 7_ ET DASA PROVIDED BY (USED IN) OPERATING � ACTIVITIES 111_1 1 TIC 71 U, "111 1 <If JO _ _ _tl_.. CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES 1PeI3e11 111[P611 .11A, I _ OHea']V-1111 ouoAIR, I IF IT 11" 1,FUJI _ __Jil 1 711, r R CASH PROVIDED BY IUSEO IN) NONOAPITAL FwaxnNG Aalvines 111 Dol 11.3G0 71 Al CASH FLOWS FROM CAPITAL AND RELATED FINANCING AT IFLUES 2—PPI PA d eewP tanFill, TIFF, am III i9 bn AFI - - eol fuel IbY.NIJI J TH, 11Ill, 2OB1I lJI1I 0C,1I I ITT Ild NET CASH PROVIDED BY USFn ]NJ CAPITAL ANO BELA I ED FINANCING ACTIVITIES LlClD3) FL.J i1 _ 1.YYJfLOI __JLI'1 CASH FLOWS FROM INVESTING ACTIVITIES'. 9ATI:r FIVE Ad,1111 PHI 1, -Sh =3, JP ��I" i 1 a J_y 1,1.. NFICASH vmFO BY (USED IN) INVESTING AwmrnEB _..yaA Jr, _ 3 ]511 BI BIr 1, c'. fL, ;a1 INCREASE DECREAGEI IN CASA AND CASH Ep UIVLL FLATS HILI A"I IT, IT Pe Jr.OlI CASH AND CASH COUIVALEN T G. JULY i X2050 J J.[ 2 ¢9 ], PC 'JJ1, 3 3hb CASH AND CASH EQUIVALENTS , JUNE O IMJ2JLS mit 91 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, 2002 92 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI OPERATING REVENUES Interdepartmental services $346,384 $352,000 $5,616 TOTAL OPERATING REVENUES 346,384 352,000 5,616 OPERATING EXPENSES Personnel services 92,580 92,512 68 Materials and supplies 15,300 13,810 1,490 Contractual services 88,384 87,305 1,079 General operating expenses 11,395 8,592 2,803 Capital outlay 63,495 63,262 233 TOTAL OPERATING EXPENSES 271.154 265,481 5,673 OPERATING INCOME (LOSS) 75,230 86,519 11,289 NON-OPERATING REVENUE (EXPENSES) Investment revenue - 1,396 1,396 Proceeds on sale classier, - 1,500 1,500 Principal payments (65,000) (86,000) - Interestandhendlingocsts (10,230) (10,351) (121) TOTAL NON-OPERATING REVENUE (EXPENSES) (75,230) (72,455) 2,775 INCOME (LOSS) BEFORE OPERATING TRANSFERS 14,064 14.064 NET INCOME (LOSS) 514,064 $14,064 92 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, 2002 VARIANCE FAVORABLE ACTUAL IUNFAVORABLEI $986,772 ($34,]4]) 11396 1,396 988,168 BUDGET 501,932 OPERATING REVENUES 267,172 34,998 Interdepartmental services $1,021,519 1,663 Other miscellaneous 2,508 - TOTAL OPERATING REVENUES 1,021,519 OPERATING EXPENSES Personnel services 532,128 Materials and supplles 302,170 Contractual services 140,766 General operating expenses 3,150 Internal service expense 2,508 Capital outlay 12,100 TOTAL OPERATING EXPENSES 992,822 OPERATING INCOME (LOSS) 28,697 NON-OPERATING REVENUE (EXPENSES) Investment revenue - Presages on sale of assets - Compensation lar damages - Prinotpelpayrnents (445) Interest and handling wets (20) TOTAL NON-OPERATING REVENUE (EXPENSES) (465) INCOME (LOSS) BEFORE OPERATING TRANSFERS 28,232 operating transfers out (26.232) NET INCOME (LOSS) 93 VARIANCE FAVORABLE ACTUAL IUNFAVORABLEI $986,772 ($34,]4]) 11396 1,396 988,168 (33,351) 501,932 30,196 267,172 34,998 169,832 (29,066) 1,663 1,487 2,508 - 11.185 915 954,292 38,530 33.876 5.179 3,733 3,733 600 600 1,121 1,121 (450) (5) (599) (579) 4,405 4.670 38,281 10,049 (28,233) (1) $10,048 $10,048 City of Cape Girardeau, Missouri EMPLOYEES' FRINGE BENEFIT FUND SCHEDULE OF REVENUES AND EXPENSES- BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI OPERATING REVENUES Interaepatlmental services $1,769,500 $1,732,012 ($37,480) TOTAL OPERATING REVENUES 1,769,500 1,732,012 (37,488) OPERATING EXPENSES Contractual services 1,676,000 1,566,550 109,450 TOTAL OPERATING EXPENSES 1,676,000 1,566,550 109,450 OPERATING INCOME (LOSS) 93,500 165,462 71,962 NON-OPERATING REVENUE (EXPENSES) Investment revenue 20,417 20,417 TOTAL NON-OPERATING REVENUE (EXPENSES) 20,417 20,417 INCOME (LOSS) BEFORE OPERATING TRANSFERS 93,500 185,879 92,379 Operating transfers out (173,500) (173,500) NET INCOME (LOSS) ($80,000) $12,379 $92,379 94 City of Cape Girardeau, Missouri RISK MANAGEMENT FUND SCHEDULE OF REVENUES AND EXPENSES. BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 VARIANCE FAVORABLE ACTUAL (UNFAVORABLEI $281,663 ($28,337) 281,663 (28,337) 328 BUDGET 394,277 OPERATING REVENUES 10,018 13,982 Interdepartmental services $310,000 (122,960) TOTAL OPERATING REVENUES 310,000 + 79,294 14,294 ($43,666) OPERATING EXPENSES Materials and supplies - Conlraclual services 436,000 Gen eral operating expenses 24,000 TOTAL OPERATING EXPENSES 460,000 OPERATING INCOME (LOSS) (150,000) NON-OPERATING REVENUE (EXPENSES) Invostn lrevenue 65,000 TOTAL NON-OPERATING REVENUE (EXPENSES) 65,000 NET INCOME (LOSS) ($85,000) 95 VARIANCE FAVORABLE ACTUAL (UNFAVORABLEI $281,663 ($28,337) 281,663 (28,337) 328 (328) 394,277 41.723 10,018 13,982 404,623 55,377 (122,960) 27,040 79,294 14,294 79,294 14,294 ($43,666) $41,334 City of Cape Girardeau, Missouri EQUIPMENT REPLACEMENT FUND SCHEDULE OF REVENUES AND EXPENSES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2002 96 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI OPERATING REVENUES Interdepartmental servlpes $320,000 $290,380 ($29,620) TOTAL OPERATING REVENUES 320,000 290,380 (29,620) OPERATING EXPENSES Capital outlay 358,200 359,320 (1,120) TOTAL OPERATING EXPENSES 358,200 359,320 (1,120) OPERATING INCOME (LOSS) (38,200) (68,940) (30,740) NON-OPERATING REVENUE (EXPENSES) Investment revenue 15,000 15,203 203 Principal payments (65,000) (65,000) - Interestandhandlingmsts (11,065) (10.808) 257 TOTAL NON-OPERATING REVENUE(EXPENSES) (61,065) (60.605) 460 INCOME (LOSS) BEFORE OPERATING TRANSFERS (99,265) (129,545) (30,280 Operating transfers in 273,200 273,200 - Operating Iranarara out (140,000) (140,000) NET INCOME (LOSS) $33,935 $3,655 ($30280) 96 97 City of Cape Girardeau, Missouri AGENCVFUNDS COMBINING BALANCE SHEET June 30, 2002 (With Comparative Totals for June 30, 2001) Park Arena Development Totals Library Improvement Foundation 66130102 06130101 ASSETS Pooled cash and investments $704,406 $120,050 $96.737 $921,193 $794,144 Nan -pooled investments 1 - - 1 1 Receivables, net of allowances for doubtful receivables Real estate tax 17,546 - - 17,546 16,141 Personal property tax 4,250 - - 4,250 3,602 Other receivables 11 11 8 Total assets $726,214 $120,050 $96,737 $943,001 $813,896 LIABILITIES Accounts payable $34,851 $375 $2,410 $37,636 $31,372 Accrued liabilities Salaries, payroll taxes and benefits 4,127 - - 4,127 2,662 Other liabilities 687,236 119,675 94,327 901,238 779,862 .. Total liabilities $726,214 $120,050 $96,737 $943,001 $813,896 97 98 Clly u Caps Glra rtleau, Rhode" r COMBINING STATEMENT OF CHANGES IN ASSETS AND LIp MUDE$ ALL AGENCY FUNDS FOR THE FISCAL YEAR ENDED JUNE a4 IDU] Pa", r Oevelopm enl Srus, ImpupormJ Founder on a Joel ASSETS Rapnces at 710, Poole, wall shot veelmantc $620,015 $116291 $5],838 $790.144 Nellrudetl mvaaxneess 1 _ 1 Ra6elhmes, at olamwenwa for boddl mdemahay Noel bstele tax 16141 _ _ 11 at let d..1p YPot, at 3,602 9,602 Is Cah—ewlvaolee _ 3 8 Total asset, It July 1. 2001 $6312 16] $116291 $57,838 $813P9e Anal oleo dean and In a estmonp $711964 $33,962 $196,$11 $946126] + on paned ants Ree vales lelat—andual. allrecemamea Reel ealele lax 46D368 - _ JpJle tan Pthe, 146082 146 082 EE, r ralpr be Oln er receivedes gg _ ID Totaletldil $1322503 $J1ely $195921 51.S52y06 bolster, Load,caa,ILI mvealmsnls $631,573 $30223 $157,022 $318818 Ndo-poord lnvwlal _ vedaz. net 1.1llowanws It ,Job" orva5lea Ra 453,1el - - 45896 adepeM1Yhe 145,4 $ - - ,3 1451434 r Cl or er...0-flea Total tlellar $1236 $30223 $167022 _ $1423 301 Balance, at Juilly do. ad dash all—b61men15 $704,406 $120,050 $96,717 $921,193 + Non pooled mveelnlenla lot auowenrea tet nbnh �vaddes, oe Real ¢e late hx 17.5a6 7686 'l al property las o1. _ 50 r Gine�radamaolee 11 11 Total assets at Jane 3Q all $7zG 214 $120,050 $ss 737 $943,001 LIABILITIES + Nala at JOY 1. 2001 Aclvdme payaop 0.31 $35t $I 38E $31373 SaedIaplmee lmenas, pay Ml Does an, benefit 2,662 - 2662 Other l Iturly$ 614068 115841 49,653 775, Ell IDIaI Ila011111es at July 1. 2001 $639 767 $116292 $57 838 $813897 Oaf Addpu,s payable $397,295 $601039 $134,101 $691,435 Let Is, + 3alatas, payroll Wass and deputy 146106 146108 Olnerl buttes 1334975 38449 311 237 1126661 Total supper- $16878376 SSB.a86 $486338 $2,463202 r PSLetsni ntspayable $3851481 $60011 $139,676 $585.112 Bahrtea�barrel Dealan bane86 14J.141 140 641 ONer liastle., 1 261 807 34716 937762 1604785_ i,lalelel... $1791929 $047 31 $447433 $2334 ple 3 2662 Dunt, paya0le $34.051 $376 $2,410 $97,656 Arehad eadbllaa r 9a er as, uay.. I lams and dene45 4127 Olne, llabl411ea 687236 119 675 94327 1 117 901258 Total llab3Rles at June 30 2002 $726214 8126650 391ede$9436801 98 City of Cape Girardeau, Missouri SCHEDULE OF GENERAL FIXED ASSETS BY SOURCE June 30, 2002 GENERAL FIXED ASSETS Land Buildings Improvements other than buildings Machinery and equipment Contruction in progress TOTAL GENERAL FIXED ASSETS INVESTMENT IN GENERAL FIXED ASSETS BY SOURCE General fund Special revenue funds Capital projects funds Enterprise funds Donated assets TOTAL INVESTMENT IN GENERAL FIXED ASSETS 99 $2,638,080 7,451,200 3,558,527 909,771 93,348 $14,650,926 $3,458,029 10,071,319 1,077,771 15,723 28,083 $14,650,926 City of Cape Girardeau, Missouri 100 SCHEDULE OF GENERAL FIXED ASSETS. BY FUNCTION AND ACTIVITY June 30, 2002 Improvements Machinery Construction Other Than and in Function and Activity Land Buildings Buildings Eoulpment Progress Total ADMINISTRATIVE SERVICES _ Human resources $- $- $- $- $- S - City manager 200,000 63,095 - - - 263,095 Maintenance - - 1,848 - - 1848 City attorney - - - 2,246 - 2,246 Interbepartmenlal 67,340 - 15,822 370 - 83,532 Finance - - - 16 - 16 CVR - 132,751 - 11,943 15,512 160,206 Airport 354,649 265.874 2950,723 152,044 - 3,723,290 Alrpo«FBO 94,532 94,532 TOTAL ADMINISTRATIVE SERVICES 621,989 461 720 2968,393 261,151 15,512 4,328,]65 DEVELOPMENT SERVICES Planning services - - - 19,579 - 19,5]9 Inspections - - 2,221 - 2221 Community information program - - - 1442 - 1.442 Vision 2000 - - 1,400 - - 1,400 _ Downtown Business District - - - - - - Engineeringservices - - - 29,427 - 29,427 Project Impact 4,172 _ 4,1]2 TOTAL DEVELOPMENT SERVICES 1,400 56,841 58241 PARKS AND RECREATION Parkmaintenance 765,638 235,400 3,095 28,106 - 1,032,239 Arena mXmlenance - - 96957 47,656 - 143,713 Municipal band - - - 1,713 - 1713 Recreation - - - 425 - 425 Cemetery 4,120 2,894 - 3,981 - 10,995 Central pool - 491,164 11,630 1,926 - 504720 Capaba pool - 3,465 2,992 - - 6,457 Osage Community Centre - 2,287,008 1 769 44,201 - 2,332,978 Softball Complex 2,061,076 13,038 2,074,114 TOTAL PARKS AND RECREATION ]69]58 5,081,007 115543 141,046 6,10].354 PUBLIC SAFETY Municipal court - - - 1,402 - 1,402 Health - - 8,537 - 8,53] Police 35,324 114,682 809 138,638 - 289,453 Fire 272093 595,178 9,510 266405 1,143.186 TOTAL PUBLIC SAFETY 3G]41] 709,860 10,319 414,982 1442578 PUBLIC WORKS Street - - - 32,925 - 32925 Slormwater - - 2.826 2,826 TOTAL PUBLIC WORKS 35,751 35,751 CAPITAL OUTLAY General capital improvements 495,175 1.171,059 405,]88 - 8,551 2,090,573 Park Improvements 443,]41 2],554 57,084 69285 597,664 TOTAL CAPITAL OUTLAY 938,916 1,198,613 462,8]2 ]],836 2 67823 r TOTAL GENERAL FIXED ASSETS $2.638,080 $],451,200 $3,558,527 $909,]]1 $93,348 $14,650,926 100 101 City of Cape Girardeau, Missouri .� SCHEDULE OF CHANGES IN GENERAL FIXED ASSETS. BY FUNCTION AND ACTIVITY FOR THE FISCAL YEAR ENDED JUNE 30, 2002 General Fixed General Fixed Assets Depreciation Assets Function and Activity 06130101 Additions Deductions Expense 06130102 ADMINISTRATIVE SERVICES I lumen resources $238 $ $- $238 5 - City manager 273,054 - - 9,959 263.095 Facility maintenance 2201 - - 353 1.848 City ettorncy 3,014 - 766 2,246 Inlerdepadnlental 91,468 - - 7,936 83,532 Finance 204 - - 188 16 CVB 168,438 - 8232 160206 Perpon 3,842,589 131,167 - 250.466 3,723,290 Airport FBO 98,312 3,780 94,532 TOTAL ADMINISTRATIVE SERVICES 4,381,206 229,479 281,920 4328.765 DEVELOPMENT SERVICES Planning services 22789 995 - 4,205 19,579 Inspections 3,230 - 1,015 (6) 2,221 Community information service 6,032 - - 4,590 1,442 Engineering services 32,863 7,797 - 11233 29,427 Project Impact 2,611 3,543 - 1.982 4,172 Vision 2000 1,706 - - 306 1,400 Capital Improvement 10,000 10,000 TOTAL DEVELOPMENT SERVICES 79,231 12,335 1,015 22,310 68241 PARKS AND RECREATION Perk maintenance 1,060,788 4,340 - 32,889 1,032,239 Arena maintenance 135,955 20,508 - 12.750 143713 Municipal band 1 961 - - 248 1,713 Recreation 691 - - 266 425 Cemetery 16142 - - 5,147 10,995 Central pool 527,361 7299 - 29,940 504,720 Capaho pool 7,532 - - 1, D75 6,457 Osage Community Centre 2,437,753 - - 104,775 2,332,978 Softball Complex 2,160.031 85,917 2,074,114 TOTAL PARKS AND RECREATION 6,348214 32,147 273,007 6.107.354 PUBLIC SAFETY Municipal court - 1,683 - 281 1402 Health 6086 5,496 - 3,045 8537 Police 315,739 45236 83,273 (11]51) 289453 Fire 1,209,843 59,389 126,048 1,143,186 TOTAL PUBLIC SAFETY 1,531,668 111,804 83,273 117,621 1442,578 PUBLIC WORKS Street 62,994 6,283 2,491 33,861 32,925 Stormwater 8,704 5,878 2,826 TOTAL PUBLIC WORKS 71,698 6,283 2,491 39739 35,751 CAPITAL OUTLAY General capital improvements 2,152,834 - - 82260 2,070,574 Parkimprovements 580,059 28,087 10483 597,663 TOTAL CAPITAL OUTLAY 2,732,893 28087 92,743 2,668237 TOTAL GENERAL FIXED ASSETS 515,144,910 $420,135 $86,779 $827,340 $14650926 101 + City of Cape Girardeau, Missouri SCHEDULE OF CHANGES IN LONG-TERM DEBT FOR THE FISCAL YEAR ENDED June 30, 20D2 General General Long-term Long-term Debt Debt '+ July 1 2001 Additions Retirements June 30, 2002 GENERAL LONG-TERM DEBT Revenue bonds payable $24,275,000 $- $695,000 $23.580,000 + Leasehold revenue bonds payable 2,163,398 - 476,398 1.687 000 Certificates of participation payable 3.785 000 2,815,000 620,000 5,980,000 General obligation refunding bonds payable 1,670,000 - 390,000 1,2K.000 Due to other governments 40,687 - 40,687 " Acrood benefits 681,424 49,432 730,056 TOTAL GENERAL LONG-TERM DEBT $32,574,822 $2.905,119 $2,181,398 $33 290,543 102 City of Cape Girardeau, Missouri STATEMENT OF GENERAL LONG-TERM DEBT June 30, 2002 + AMOUNT AVAILABLE AND TO BE PROVIDED FOR THE PAYMENT OF GENERAL LONG-TERM DEBT REVENUE BONDS + Amount available In debt service fund Amount to be provided LEASEHOLD REVENUE BONDS + Annountavauabie in debt service fund Amount m be Provided CERTIFICATES OF PARTICIPATION + Amount available in debt service fund Amounl to be provided GENERAL OBLIGATION REFUNDING BONDS y Amounl available In debt service fund Amount to be provided DUE TO OTHER GOVERNMENTS + Amount available in debt service fund Amount to be provided ACCRUED BENEFITS + Amount available In debt service fund Amount to be provided + TOTAL AMOUNT AVAILABLE AND TO BE PROVIDED GENERAL LONG-TERM DEBT PAYABLE + Revenue bonds payable Leasehold revenue bonds Payable Certificates of parlarpolum payable General obligation refunding bonds payable + Due to other governments -State energy loan Accrued fedora TOTAL GENERAL LONG-TERM DEBT PAYABLE $ 23,580,000 $23,580,000 525,390 1 161,610 1,687.000 1,468,154 4,511,846 5980,000 793,960 486,040 1.280,000 40687 40,687 730,856 730,856 $33,298,543 $23.580.000 1.68] 000 5,980,000 280,000 40.687 730,856 $33298,543 BEUSSINK, HEY, ROE, SEABAUGH & STRODER, L.L.C. Certified Public Accountants 16 So. Silver Springs Road 4018 Sycamore 105 So. Hope Cairo, Illinois 62914 Cape Girardwu, Missouri 63703 Jackson, Missouri 63755 Telephone (618) 734-3300 Telephone (573) 334-7971 Telephone (573) 243-3991 Facsimile (618) 734-3303 Facsimile (573) 334-8875 Facsimile (573) 243-3t86 REPORT ON COMPLIANCE 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 City of Cape Girardeau, Missouri Compliance We have audited the compliance of 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 its major federal program for the year ended .lune 30, 2002. City of Cape Girardeau, Missouri's major federal program is identified in the summary of auditors' results section of the accompanying Schedule of Findings and Questioned Costs. Compliance with the requirements of laws, regulations, contracts and grants applicable to its major federal program is the responsibility of City of Cape Girardeau, Missouri's management. Our responsibility is to express an opinion on City of Cape Girardeau, Missouri's compliance based on our audit. We conducted om- audit of compliance in accordance with auditing standards generally accepted in the United States of America; the standards applicable to financial audits contained in Govermnent Auditing Standards, issued by the Comptroller General of the United States; and OMB Circular A-133, Audits of States, Local Governments, and Non -Profit Organizalions. 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 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 docs not provide a legal determination on City of Cape Girardeau, Missouri's compliance with those requirements. 104 In our opinion, City of Cape Girardeau, Missouri complied, in all material respects, with the requirements referred to above that are applicable to its major federal program for the year ended .lune 30, 2002. Internal Control Over Compliance The management of 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 City of Cape Girardeau, Missouri's internal control over compliance with requirements that could have a direct and material effect on a major federal program in order to determine our auditing procedures for the purpose of expressing ora' opinion on compliance and to test and report on the internal control over compliance in accordance with OMB Circular A-133. Our consideration of the intemal 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. This report is intended solely for the information and use of the Honorable Mayor, Members of the City Council, federal awarding agencies, and pass-through entities and is not intended to be and should not be used by anyone other than these specified parties. BEUSSINK, HEY, ROE, SEAB/AUGH/& STRODER, L.L.C. atL.'w,i„l Hei ,( ��e,�C`k( ✓,�iiC1 `v��Ct. C: Cape Girardeau, Missouri l November 4, 2002 105 BEUSSINK, HEY, ROE, SEABAUGH & STRODER, L.L.C. Certified Public Accountants 4018 Sycamore 16 So. Silver Springs Road t05 So. hope Cairo, Illinois 62914 Cape Girardeau, Missouri 63703 Jackson, Missouri 63755 Telephone (618) 734-3300 Telephone (573) 334.7971 Telephone (573) 243-3991 Facsimile (618) 734-3303 Facsimile (573) 334-8875 Facsimile (573) 243-3186 REPORT ON COMPLIANCE AND ON INTERNAL CONTROL OVER FINANCIAL REPORTING BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH GOVERNMENT ACID/TING STANDARDS Honorable Mayor and Members of the City Council City of Cape Girardeau, Missouri We have audited the general purpose financial statements of City of Cape Girardeau, Missouri as of and for the year ended .June 30, 2002, and have issued our report thereon dated November 4, 2002. We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Compliance As part of obtaining reasonable assurance about whether City of Cape Girardeau, Missouri's general propose 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 would have a direct and material effect on the detemnination 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 Govei nmem Auditing Standards. Internal Control Over Financial Reporting In planning and performing our audit, we considered 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 general purpose financial statements and not to provide assurance on the internal control over financial reporting. However, we noted a matter invoking 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, 106 0 0 process, summarize and report financial data consistent with the assertions of management in the general purpose financial statements. Reportable conditions are described in the accompanying Schedule of Findings and Questioned Costs as item 02-1. 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 reportable conditions and, accordingly, would not necessarily disclose all reportable conditions that are also considered to be material weaknesses. However, we believe none of the reportable conditions described above is a material weakness. This report is intended solely for the information and use of the Honorable Mayor, Members of the City Council, federal awarding agencies, and pass-tlnougir entities and is not intended to be and should not be used by anyone other than these specified parties. BEUSSINK, HEY, ROE, SEABAUGH & STRODER, L.L.C. Cape Girardeau, Missouri November A, 2602 107 CITY OF CAPE GIRARDEAU, MISSOURI SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS For the Year Ended June 30, 2002 Federal CFDA Program Federal Grantor/Piss-Through Granter Program Title Number Number Disbursements U.S. DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT: Passed Through Missouri Department of Economic Development - Community Development Block Grants/ Stales Program (1) 14.228 01 -MO -01 $ 750,000 97 -ED -14 303,336 97 -ND -03 122,924 00 -Ell -14 111,384 $ 1,287,644 Emergency Shelter Grants Program (ESG) 14.231 ERO1640401 23,855 Self -Help Homeownership Opportunity Program 14.247 N/A 3'1,000 TOTAL U.S. DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT $ 1,341,499 U.S. DEPARTMENT OF JUSTICE: ' Gang -Free Schools and Communities- Community - Based Gang Intervention 16.544 N/A $ 6.360 Passed Through Missouri Department of PublicSafety - Parent & Child Together (PACT) Program 16.546 00-JIT5-02 $ 15,163 01-JJT5-01 39,762 54,925 .. Crime Victim Assistance 16.575 99-VOCA-0008 5,103 00-VOCA-0010 19,175 24,278 Local Law Enforcement Block Grants Program 16.592 00 -LB -BX -2495 22,035 99 -LB -VX -8973 805 22,840 Executive Office for Weed and Seed 16.595 N/A 4,603 Bulletproof Vest Partnership Program 16.607 N/A 6,033 The Accompanying Notes to Schedule of Expenditures of Federal Awards Are an Integral Part of This Report. 108 109 CITY OF CAPE GIRARDEAU, MISSOURI ,. SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS For the Year Ended June 30, 2002 Federal — CFDA Program Federal Grantor/Pass-Through Grantor Program Title Number Number Disbursements Public Safety Partnership and Community Policing Grants 16.710 1999CMWX1820 2,652 ' 1997UMWX0055 17,484 20,136 Police Cops 16.712 N/A 20,000 — TOTAL U.S. DEPARTMENT OF JUSTICE $ 159,175 - U.S. DEPARTMENT OF TRANSPORTATION: Airport Improvement Program 20.106 3-29-0013-11 $ 18,424 — 3-29-OOI3-08 23,639 3-29-0013-09 75,141 $ 117,204 Passed Through Missouri Department of ' Transportation - Highway Planning and Construction 20.205 STP -1500(009) 10,571 — Formula Grants for Other Than Urbanized Areas 20.509 MO -18-X022 145,743 State and Community Highway Safety 20.600 01 -SA -09-2 $ 23,560 02 -154 -AL -46 10,119 02 -SA -09-2 28,951 „ 01-YA-03-2 13,669 02-YA-03-2 2,206 78,505 Alcohol Transfer Funds (2) 20. 02 -154 -AL -40 $ 3,709 — 02 -154 -AL -5 740 02 -164 -AL -7 3,990 8,439 — TOTAL U.S. DEPARTMENT OF TRANSPORTATION $ 360,462 The Accompanying Notes to Schedule of Expenditures of Federal Awards Are an Integral Part of This Report. 109 CITY OF CAPE GIRARDEAU, MISSOURI SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS For the Year Ended June 30, 2002 Federal CFDA Program Federal Grantor/Pass-Throueh Grantor Promam Title Number Number Disbursements U.S. FEDERAL EMERGENCY MANAGEMENT AGENCY: Passed Through Missouri Stale Emergency Management Agency - Public Assistance Grants 83.544 FEMA 1412 -DR -MO $ 153,529 Project Impact 83.551 EMK 1999 -GR -0028 89,727 TOTAL U.S. FEDERAL EMERGENCY MANAGEMENT AGENCY S 243,256 TOTAL FEDERAL AWARDS $2,104,392 (1) Identified major program. (2) A CILIA number has not yet been assigned to this assistance. The Accompanying Notes to Schedule of Expenditures of Federal Awards Are an Integral Part of This Report. CI']Y OF CAP$ GIRARDAU MISSOURI NOTES TO SCHEDULE OF EXPENDITURES OF PEDPRAL AW,4RDS Year Ended June 30, 2002 1. SUMMARY OF SIGNII ICANT ACCOUNTING PC)LICIES: A. Put of Schedule and Reporting Entity: The accompanying Schedule of Expenditures of Federal Awards has been prepared to comply with OMB Circular A-133. This circular requires a Schedule of Expenditures of Federal Awards showing total expenditures for each federal financial assistance program as identified in the Catalog of Federal Domestic Assistance (CFDA) and identification of programs that have not been assigned a CFDA number as "Other Federal Assistance." The schedule includes all expenditures of federal awards administered by the City. B. Basis of Presentation: The schedule is presented in accordance with OMB Circular A-133, which defines federal financial assistance "...assistance that non4ederai entities receive or administer in the form of grants, loans, loan guarantees, property (including donated surplus property), cooperative agreements, interest subsidies, insurance, food commodities, direct appropriations, and other assistance, but does not include amounts received as reimbursement for services tendered to individuals." C. Basis of Accounting: The schedule is presented on the modified accrual basis of accounting, which recognizes expenditures when liabilities for goods and services are incurred. This is the same basis of accounting presented in the general purpose financial statements. CITY OF CAPE GIRARDEAU MISSOURI SCHEDULE OF FINDINGS AND QUESTIONED COSTS For the Year Ended June 30, 2002 112 i. SUMMARY OF AUDITORS' RESULTS: Financial Statements Type of Auditors' report issued: Unqualified Internal control over financial reporting: • Material weaknesses identified? yes X no • Reportable conditions identified that are not considered to be material weaknesses? yes X none reported Noncompliance material to financial statements noted? yes X no Federal Awards Internal control over major programs: • Material weaknesses identified? yes X no • Reportable conditions identified that are not considered to be material weaknesses? yes X none reported Type of Auditors' report issued on compliance for major programs: Unqualified Any audit findings disclosed that are required to be y reported in accordance with Section 510(a) of Circular A-133'? yes X no Identification of major programs. CFDA Number Name of Federal Program _ 14.228 Community Development Block Grants/State's Program _ Dollar threshold used to distinguish between type A and type B programs: 5300,000 _ Auditee qualified as low-risk auditee: __ yes X no 112 2. FINANCIAL., STATEMLNT FINDINGS: 02-1. Investment Policy Condition: Certain aspects of the investment policy of the City of Cape Girardeau, Missouri are not being followed. Criteria: Internal controls should be in place that provide reasonable assurance that investment objectives are carried out and that results are monitored. Effect: Noncompliance with internal controls could result in losses of City Funds arising from fraud, employee error, misrepresentation by third parties, unanticipated changes in financial markets, or imprudent actions by city employees. Recoppriedatio : The City should comply, consistently, with all aspects of the adopted investment policy. The investment comnottee should hold quarterly meetings in order to determine investment strategies and monitor results. It is also recommended that the committee submit a quarterly report to the City Manager, as outlined in the City's investment policy. Response: We concur with the recommendation. Such procedures will be implemented. This is a repeat of the prior year finding. 3. FEDERAL AWARD FINDINGS ANDOUESTtON6DC{3STS: No findings or questioned costs were noted that are required to be reported. 113 CITY OF CAPE GIRARDEAU MISSOURI SUMMARY SCHEDULE OF PRIOR AUDIT FINDINGS For the Year Ended June 30, 2002 01-1. Finding (Internal Control): Certain aspects of the investment policy of the City of Cape Girardeau, Missouri are not being followed. Recommendation: The City should comply, consistently, with all aspects of the adopted inventment policy. Status: Not implemented. See 02-1. 114