The URL can be used to link to this page

Home My WebLink About2000-2001.AuditReportFINANCIAL STATEMENTS AND INDEPENDENT AUDITORS' REPORT CITY OF CAPE GIRARDEAU, MISSOURI June 30, 2001 CONTENTS Pepe w FINANCIAL SECTION INDEPENDENT AUDITORS'REPORT 7 GENERAL PURPOSE FINANCIAL STATEMENTS r COMBINED BALANCE SHEET -ALL FUND TYPES AND ACCOUNT GROUPS 10 COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE -ALL GOVERNMENTAL FUND TYPES 12 COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET (BUDGET BASIS) AND ACTUAL - ,. ALL GOVERNMENTAL FUND TYPES 13 COMBINED STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS -ALL PROPRIETARY FUND TYPES 15 w COMBINED STATEMENT OF CASH FLOWS -ALL PROPRIETARY FUND TYPES 16 NOTES TO FINANCIAL STATEMENTS 18 COMBINING AND INDIVIDUAL FUND STATEMENTS r GENERAL FUND COMPARATIVE BALANCE SHEET 63 SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) 64 SPECIAL REVENUE FUNDS „ COMBINING BALANCE SHEET 65 COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE 66 CONVENTIONIVISITORS SPECIAL REVENUE FUND - SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) 67 AIRPORT SPECIAL REVENUE FUND - r SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) 68 �. DOWNTOWN BUSINESS DISTRICT SPECIAL REVENUE FUND - SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) 69 r PARKS AND RECREATION SPECIAL REVENUE FUND - SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) 70 CONTENTS COMBINING AND INDIVIDUAL FUND STATEMENTS -Continued Paoe HEALTH SPECIAL REVENUE FUND - SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) 71 MOTOR FUEL TAX SPECIAL REVENUE FUND - SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) 72 CAPITAL IMPROVEMENT SALES TAX SPECIAL REVENUE FUND - FLOOD CONTROL PROJECTS SCHEDULE OF REVENUES AND EXPENDITURES -BUDGET AND ACTUAL (BUDGET BASIS) 73 r CAPITAL IMPROVEMENT SALES TAX SPECIAL REVENUE FUND - WATER PROJECTS SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) 74 CAPITAL IMPROVEMENT SALES TAX SPECIAL REVENUE FUND - r SEWER SYSTEM IMPROVEMENTS SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) 75 r TRANSPORTATION SALES TAX TRUST SPECIAL REVENUE FUND - SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) 76 r TRANSPORTATION SALES TAX TRUST II SPECIAL REVENUE FUND - SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) 77 r FLOOD PROTECTION SPECIAL REVENUE FUND - SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET r AND ACTUAL (BUDGET BASIS) 78 VISION 2000 SPECIAL REVENUE FUND - SCHEDULE OF REVENUES AND EXPENDITURES -BUDGET AND ACTUAL (BUDGET BASIS) 79 DEBT SERVICE FUND r COMPARATIVE BALANCE SHEET 80 " CAPITAL PROJECT FUNDS r COMBINING BALANCE SHEET 81 COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE 82 r GENERAL CAPITAL IMPROVEMENT FUND- SCHEDULE OF REVENUES AND EXPENDITURES -BUDGET AND ACTUAL (BUDGET BASIS) 83 CONTENTS COMBINING AND INDIVIDUAL FUND STATEMENTS -Continued Paae CORP FLOOD CONTROL CAPITAL PROJECT FUND - SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET r AND ACTUAL (BUDGET BASIS) 84 STREET IMPROVEMENTS FUND - SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET r AND ACTUAL (BUDGET BASIS) 85 FAU STREET GRANTS FUND - "' SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) 86 COMMUNITY DEVELOPMENT BLOCK GRANT FUND - SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) 87 PARKIMPROVEMENTSFUND- SCHEDULE OF REVENUES AND EXPENDITURES -BUDGET AND ACTUAL (BUDGET BASIS) 88 4 WATER IMPROVEMENT PROJECTS - r SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) 89 r ENTERPRISE FUNDS " COMBINING BALANCE SHEET 90 r COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS 91 r COMBINING STATEMENT OF CASH FLOWS 92 SEWERFUND- r SCHEDULE OF REVENUES AND EXPENSES - BUDGET AND ACTUAL (BUDGET BASIS) 93 WATER FUND - r SCHEDULE OF REVENUES AND EXPENSES - BUDGET AND ACTUAL (BUDGET BASIS) 94 SOLID WASTE FUND - SCHEDULE OF REVENUES AND EXPENSES -BUDGET AND ACTUAL (BUDGET BASIS) 95 GOLF COURSE FUND - SCHEDULEOFREVENUESANDEXPENSES- BUDGET AND ACTUAL (BUDGET BASIS) 96 r SOFTBALL COMPLEX FUND- SCHEDULE OF REVENUES AND EXPENSES - BUDGET AND ACTUAL (BUDGET BASIS) 97 CONTENTS COMBINING AND INDIVIDUAL FUND STATEMENTS -Continued Page INTERNAL SERVICE FUNDS COMBINING BALANCE SHEET 98 COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS 99 COMBINING STATEMENT OF CASH FLOWS 100 DATA PROCESSING FUND - SCHEDULE OF REVENUES AND EXPENSES -BUDGET AND ACTUAL (BUDGET BASIS) 101 .. FLEET MANAGEMENT FUND - SCHEDULE OF REVENUES AND EXPENSES - BUDGET AND ACTUAL (BUDGET BASIS) 102 EMPLOYEES' FRINGE BENEFIT FUND - SCHEDULE OF REVENUES AND EXPENSES - BUDGET AND ACTUAL (BUDGET BASIS) 103 r RISK MANAGEMENT FUND - SCHEDULE OF REVENUES AND EXPENSES -BUDGET r AND ACTUAL (BUDGET BASIS) 104 EQUIPMENT REPLACEMENT FUND - SCHEDULE OF REVENUES AND EXPENSES - BUDGET AND ACTUAL (BUDGET BASIS) 105 AGENCYFUNDS r COMBINING BALANCE SHEET 106 COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES - ALL AGENCY FUNDS 107 FIXED ASSETS r SCHEDULE OF GENERAL FIXED ASSETS - BY SOURCES 108 SCHEDULE OF GENERAL FIXED ASSETS - BY FUNCTION AND ACTIVITY 109 SCHEDULE OF CHANGES IN GENERAL FIXED ASSETS - r BY FUNCTION AND ACTIVITY 110 LONG-TERM DEBT r SCHEDULE OF CHANGES IN LONG-TERM DEBT 111 STATEMENT OF GENERAL LONG-TERM DEBT 112 CONTENTS SINGLE AUDIT SECTION PdgE INDEPENDENT AUDITORS' REPORT ON COMPLIANCE WITH REQUIREMENTS APPLICABLE TO EACH MAJOR PROGRAM AND INTERNAL CONTROL OVER COMPLIANCE IN ACCORDANCE WITH OMB CIRCULAR A-133 114 INDEPENDENT AUDITORS' REPORT ON COMPLIANCE AND ON INTERNAL CONTROL OVER FINANCIAL REPORTING BASED ON AND AUDIT OF FINANANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS 116 SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS 118 SCHEDULE OF FINDINGS AND QUESTIONED COSTS 121 - STATUS OF PRIOR YEAR FINDINGS 123 KERBER, ECK & BRAECKEL LLP CCHIII ILU f011,C A4 C Ol NJ i.4l) C G G.,• i._. .. - ,,,,,.:��. 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 and the combining and ` individual fund and account group financial statements of the City of Cape Girardeau, Missouri, as of and for the year ended June 30, 2001, as listed in the table of contents. These general-purpose financial statements are the responsibility of the City of Cape Girardeau, Missouri's management. Our r 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 States ` 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 financial statements are r free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall financial statement presentation. We believe that our audit provides a reasonable basis for our ` opinion. In our opinion, the general-purpose financial statements referred to above present fairly, in all material �. respects, the financial position of the City of Cape Girardeau, Missouri, as of June 30, 2001, and the results of its operations 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 our report dated November 16, 2001 on our consideration of the City of Cape Girardeau, Missouri's internal control over financial reporting and our tests of its compliance with certain provisions of laws, regulations, contracts and grants. That report is an integral part of an audit performed in accordance with Government Auditing 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 of the City of Cape Girardeau, Missouri, taken as a whole. The combining and individual fund and account group financial statements listed in the table of contents are presented for purposes of additional analysis and are not a required part of the financial statements of the City of Cape Girardeau, Missouri. The accompanying schedule of expenditures of federal awards is presented for purposes of additional analysis as required by U.S. Office of Management and Budget Circular A-133, Audits of States, Local Governments, and Non -Profit Organizations, and is also no a required part of the general purpose financial statements of the City of Cape Girardeau, Missouri. Such information has been subjected to the auditing procedures applied in the audit of the general-purpose financial statements and, in our opinion, is fairly stated, in all material respects, in relation to the general- purpose financial statements taken as a whole. r Cape Girardeau, Missouri November 16, 2001 0 &4 F ZLP GENERAL PURPOSE FINANCIAL STATEMENTS E I r- r r- t, r- r r_ r _ r- r r if I- r __ r Cory of Cape Girardeau, Mlaaoud LOMBINEO BALANCE SHEET ALL FUND TWE$ AND ACCOUNT GROUPS June 30.2001 THE NOTES TO THE =1NANLIAL STATEb1ENTN ARE AN INTEGRAL PART OF THIN NTATEMENT Fiduciary Gwammenlal Fund Tvpas propdarery Fund Types Ford! Tp. AccountGIOuos General General Special OeEt Capital Intended Flied Long.Term met.'. .on ... I Raves 147,48 CEQ14L14 Pri8mex34 $rv3on An... Asset Debt 96130/01 d3t"', ASSETS AND OTMER DE61T5 Assals' o ed cash all vozsMenls $1769,143 $8,939948 $do, d. $6.043,674 $1,83].356 $$378,253 S7.1aA S $ $$2,119.196 $22,451,666 Non{ool en I'lland I ag soa v�env - - 1=1,552 13083,691 54.425 10.585 - - 1 -In 1 a 2,362,230 No ed mvesloarr - 459,487 154,263 300 360 - 014,110 1,643735 Recarva0bsn of of Owa-ce5'or dvOdul receaplves Feet ep:ale psomild pmFs,. all a nlh sed, 37Ti731 ] 12, 531 19743 - 77,603 86.182 Nelesias 609,417 604479 - - - _ _ - 1,213.896 1308,370 ea"I'de less 1,256,818 - - _ _ _ - 1,256,618 1003447 "telmmal lav saffelle - 1073 - - - _ _ 1f73 341 pesl9uant N, receivable - 56.3'5 56.315 57.565 U4diy charges receivable - - 1,2U1,d. - - 1201,544 1262144 $peoala leso-Hr alre 140,400 3. In, 390,250 35,732 69,555 - _ 1.IPF ,100 955,097 1' andal recevai 351,912 - 13091 174 83,627 3,647 - _ 452,951 531.100 0 her do, ound 25,232 102,381 260 - 58,008 50,325 8 - 236$14 191,865 :ergcv e_eroadad ma Motor duel - 86,148 8E 18 89.578 O .,for otlbe11 cense lees 15,195 - - - _ _ _ - 15'95 15,1o8 Moiorvebide sales lar, - 23,722 - - - - _ - 23722 25468 Grabs receivable ]25.814 130042 - 26968 34,998 - - 75c.526 299,968 Doe from other tones - _ _ - - 2,602226 M,dn-1oo herV1s 1,017,500 - - - - - - - 670 1650 1 Far vanloes 197 45 369 - - 140,713 5.13a - 191418 .500 136,842 Fralrated b No' pooled roan end ra sr ep mine. - - - - 180162 86 - - - 160,250 172,598 No, oured l nvesInt - - - - 13.944.064 - - 13944,064 10712354 Faced at oM m- er's - - 1152110 - - - 1752.the 1,704,106 P'epaid idem 74,460 16055 - - 687,546 25519 - - 803,582 795191 Fuel alostsr o a, -, or fa.M o d, tried 75214418 1991 IF, 15,144910 92,351089 79.40aeW mbar debits a'.dabla for dam's -r. - - - _ _ _ - 2,473.954 2,473854 2.451.104 AIZnit be ed for retirement nam of gerarel bngarm debt _ _ _ _ 29,419,445 2941 Shade 31467.168 mbe soared turf, he on y T end of compenaeled abaar:rs 6814z4 6814z4 650790 Total assets and Other debits 5699624 $10.337629 _L2 874 711 $19567906 Eedi 52834657` 4613,695 $15.144910 33244823 E18&095203 S1B4082905 THE NOTES TO THE =1NANLIAL STATEb1ENTN ARE AN INTEGRAL PART OF THIN NTATEMENT Clly of... G Lap.G Andel Mi..Osit COMBINED BALANCE SHEET ALL FUND TYPESAND ACC O UNT GROUPS Jona 30.2001 THE NOTES TO THE GINANC AL STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT. Finaclaly eoeeardesta Fund Twe. Proorlalary Fane Types Fund Type Account Groupe Gener.l General LIABILITIES EpUITY AND 0THE0. CREDITS General Special Revenue Bob, ServiceShoehorns CapNal Progol Internal $e d Aggingv Fhed A.... Long -Tom ..bq— Tattle Mamoran 60 ]p 01 06,3010 Liabilities', Z^ls, aEle Am_ Ileb Ryas $330,493 S."Ig9 S $1,036.806 $993365 $540.038 531,372 $- ¢ $3,541723 S2Far 665 $alnnav, cayvl Old, a.......I, dales oeMEle Mere,. payable OTe'IipOtl'. es B:e m a'.r gor.meents Gin mcee, luWs Advance LOM Mer funds O -Tina pads, of on, a— bear m,giarm dem nal o,'U^am porn, 25426 - 18.831 m6 - - 20.113 3291 19.122 - - - - 215 - - _ - - - 66.918 z]C1 - _ '05.643 6382 448427 386,313 z0,v6 1,667,500 2112 ,6,2 22509 - 5.142 F3 y140 125, OOO 2,662 - 119862 - - - - - - _ - IF' 42A - - 1 2181393 066,837 0 332 4A, 145 1,2]1.109 32,226 1,IN7,111 5.99.000 0Cria. 14.314 394.134 t156,8fi3 19,655 2602,228 1,661,500 4,607,000 Rare^la se^ds pavane Leasehold revenue dolls "I'll e Tell Acgler.'l.1 peyon GenZI 0Eli,Ach h1d, in9 - - _ - - - - 41,194 653 164410 1,255,0,0 - - 294,626 - - - - 23,580,000 1,687,000 3,155006 7C77afi58 1853460 <714,625 84 sue Old 2 592353 rAla 480 EOnds payable Fal nslad landml urns:-¢ and nn-,Inanre ' - - _ _ _ - 1380,00, 1389,000 11111 WO e na.enr Daie,,.—Ijor Al615 - 99905 - 4Oo472 35732 202000 - - EC7IOA 1,167784 266 C00 1.162963 Total llabllllles 55190 1 19240 400 ]51 1,142,163 55 .0 939,5'7 813.896 - 32-574.823 93,023449 91310426 Epmly and mbar credits: 1^ general seed asse6 ."rouf.d .pial Re191nedeamngl - - - - _ - - - _ 37,899,902 _ - - 1544910 - - 15144.910 31,899982 '5842743 26 510,848 Reserved "ra"'ed ,d Balances FA - - _ - - - 1096,536 1479587 - 3,Wfi350 _ - _ - - 1,096.535 5'55,041 1336,667 3 403,512 a—Ad Uneservad 4,968,335 744,109 3,571293 551C411 2,413954 6395,861 10,049.892 - _ _ _ 15409993 16.Eat ,406 26591,549 1A127ho] This am., and Plea, regain 5712994 9141700 2473.954 10445743 40416,105 3,676360 -5,144910 95071,754 92072479 TOIal 1leEilitias.,mty and error ,art, $199.624 $10337028 $2874711 $19631906 $95816528 Ong Day 171 $118,396 $15,144910 $3294823 $188095203 $154, 032 Kid THE NOTES TO THE GINANC AL STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT. 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, 2001 GOVERNMENTAL FUND TYPES TOTALS SPECIAL DEBT CAPITAL (MEMORANDUM GENERAL REVENUE SERVICE PROJECTS ONLY) 12 REVENUES We Taxes $11,686.703 $8.885,263 $382,051 $- $20,954,017 Licenses and permits 1,067.580 2,088 - - 1,069,668 Intergovernmental 862,511 1,947.990 9,075 390,868 3,230,444 Charges for services 311,388 604,418 - - 915,806 Interdepartmental services 734,244 - - - 734,244 Fines and forfeitures 690,744 - - - 690,744 Miscellaneous 107,967 160,272 40,000 - 308,239 Investment revenue 285,776 782,667 218,103 1,109423 2,395,969 Spei assessments 10 26,846 47,391 337 74,584 TOTAL REVENUES 15,766923 12,409,544 696.620 1,500,628 30,373,715 r EXPENDITURES Current Administrative services 1,795,703 1,098,448 - - 2,894,151 Develapmanl services 1,585,269 33.233 - - 1,618,502 Parks and recreation 1,192,497 1,260.825 - - 2,453.322 r Public safety 8,503,973 641,570 - - 9,145,543 Public works 1,948,312 7,550,639 - - 9,498,951 Contingency 41,647 - - - 41,647 Capital outlay - - - 9,433,779 9,433,779 I Debt service Principal - 680,376 1,328,617 - 2,008,993 �r Interest and fiscal charges 1,084,730 433,442 4.246 1,522,418 t TOTAL EXPENDITURES 15,067,401 12,349,821 1,762,059 9.438,025 38,617,306 be EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 699,522 59,723 (1,065,439) (,937.397) (8,243,591) OTHER FINANCING SOURCES (USES) Operating transfers in 910,350 2,304,993 1,088,289 1,174286 5,477,918 Operating transfers out (1,849,095) (4,424,483) (993,324) (,266.902) TOTAL OTHER FINANCING SOURCES be (USES) (938,745) (2,119,490) 1.088,289 180.962 (1,788,984) i. EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES (239,223) (2.059,767) 22,850 (7.756,435) (10032575) We FUND BALANCES, JULY 1 5.863,445 11,201,555 2451,104 26202,178 45,718,282 PRIOR PERIOD ADJUSTMENT 88,772 88,772 FUND BALANCES, JUNE 30 $5,712,994 $9,141,788 $2,473,954 $18,445.743 $35,774,479 12 REVENUES Taxes licenses and penmila - Intergpvenanentel Cbar9es for services Interdepartmental services Floes and forfeitures Miscellaneous Investment revenue ` Special assessments TOTAL REVENUES EXPENDITURES Current Adminlstre0ve services k Development serines Parks and reereation y Public safety Public-*. Contingency Debt service P-dipal Interest and (tical don, - TOTAL EXPENDITURES ` EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Operating transfers a r Operating transfers out TOTAL OTHER FINANCING SOURCES (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES r FUND BALANCES. JULY f ! PRIOR PERIOD ADJUSTMENT ` FUND BALANCES, JUNE 30 a. r 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, 2001 15.143.766 15054,883 VARIANCE 544,702 695,378 FAVORABLE BUDGET ACTUAL (UNFAVORABLE) (1876,659) $11807,508 $11,686703 ($120,805) 1,089,250 1,067,580 (21,670) 509,920 882,511 372,591 369,540 311.388 (58,152) 658750 734.244 75,494 900,000 690.744 (209,256) 70,000 107,967 37.967 275,000 269,114 (5,886) 8.500 10 (8490) 15,688,468 15.750,261 61.793 1,153,966 1.802.149 1)80,385 21.755 1,655,345 1580634 74,711 1 213, 351 1,194,212 19.139 0,460.165 8,513,294 (53,129) 1.982,765 1,944,711 38,954 3'000 41,647 (11,647) 15.143.766 15054,883 88.883 544,702 695,378 159,676 910,350 910,350 - (1876,659) (1,849,095) 27,564 (966.309) (936,745) 9564 (421,607) (243,367) 178.240 5,837,497 5637,497 - 88.772 88.772 $5,504,662 $5,682902 $118,240 13 SPECIAL REVENUE FUNDS 155,600 160272 VARIANCE 235',800 663,373 FAVORABLE BUDGET ACTUAL (UNFAVORABLE $7,683,069 $8,885.263 $1202,194 7,500 2.068 (5.412) 2,071,558 1,947,990 (123,588) 528,000 604,419 76,419 155,600 160272 4,672 235',800 663,373 427,573 2,935.000 26,846 (2,008154) 13616,527 12,290,251 (1,326,276) 1.324 176 1,177,025 147.151 62,500 33,233 29,267 1,244027 1,259.447 (15,420) 833,335 643.332 190,003 7,403,504 5,671,159 1,732,345 680,375 680,376 (1) 914.644 1,084730 (170086) 12 462.551 10549,302 1,913,259 1,153,966 1,740.949 586.983 1.34$519 2,304.993 956,474 (4452354) (4424,483) 27,871 (3,103.835) (2.119490) 964,345 (1,949,869) (378,541) 1,571,328 6,867,897 6.867.897 - $4,918,028 $6,489356 $1,571.328 EXPENDITURES Capital outlay Debt service Principal seInterest and fiscal charges TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES y OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Operating transfers in Operatin9(ransters out as Band proceeds i TOTAL OTHER FINANCING SOURCES (USES) ~ EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES Y 1 FUND BALANCES, JULY t r FUND BALANCES, JUNE 30 r V lai r 1328,617 1,328,61 - City at Cape Girardeau, Missouri 433442 4,382 1766,441 1762059 4,302 COMBINED STATEMENT OF REVENUES, EXPENDITURES AND (3.304) 1,088,310 LUM289 (21) 381.859 CHANGES IN FUND BALANCES (27,564) (36.850) (36,660) 345,000 BUDGET AND ACTUAL (BUDGET BASIS)- ALL GOVERNMENTAL FUND TYPES (1,842750) FOR THE FISCAL YEAR ENDED June 30, 2001 2,899465 2,899,465 $1,056,715 $2,198,190 $1,141475 ANNUALLY BUDGETED _ DEBT SERVICE FUND CAPITAL PROJECTS FUNDS VARIANCE VARIANCE FAVORABLE FAVORABLE BUDGET ACTUAL (UNFAVORABLE I BUDGET ACTUAL (UNFAVORABLEI REVENUES y Taxes $373,316 $382,051 $6.733 $ S $- Intergovernmental 8,400 9,075 075 1,023.100 390,868 (632,232) Miscellaneous 40,000 40,000 - - Investment revenue 158,832 162,347 3,515 85.W0 145,121 60,121 Syeclal assessments 68.000 47,391 (20,609) 5.000 337 (4,663) 4 TOTAL REVENUES 648,550 640,864 (7,686) 1,113.100 536.326 (576.774) EXPENDITURES Capital outlay Debt service Principal seInterest and fiscal charges TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES y OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Operating transfers in Operatin9(ransters out as Band proceeds i TOTAL OTHER FINANCING SOURCES (USES) ~ EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES Y 1 FUND BALANCES, JULY t r FUND BALANCES, JUNE 30 r V lai r 1328,617 1,328,61 - 437824 433442 4,382 1766,441 1762059 4,302 (1,117891) (1,121,195) (3.304) 1,088,310 LUM289 (21) 1088 310 1,088289 (21) (29.581) (32906) (3,325) 2.505930 2505.9'3 - $2,476,349 $2,473,024 ($3,325) 14 3,300.850 1,550 791 1 ]50,059 4.246 (4,246) 3 300 860 1.555.037 1,745.813 (2.167750) (1,918,711) 1,169,039 381.859 354,286 (27,564) (36.850) (36,660) 345,000 317436 (27564) (1,842750) (701275) 1.141.475 2,899465 2,899,465 $1,056,715 $2,198,190 $1,141475 City of Cape Girardeau, Missouri COMBINED STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS ALL PROPRIETARY FUND TYPES FOR THE FISCAL YEAR ENDED June 30. 2001 15 TOTALS MEMORANDUM ONLY 2000-2001 $5777.870 2,718,999 495,154 17,975 137,963 416,401 60,770 211,175 3490,577 93.124 13,420.008 3,055,123 1,052,393 5,609,993 382,659 42 711 355.479 2A78 191 12.977549 442459 1,194,660 29 546 161,748 36,073 (43,444) 656 (10 5801) 976.955) (703,517) (261,058) 1,990,773 (201,789) 1,527,926 4.740.179 (16.722) $6 252.383 PROPRIETARY FUND TYPES INTERNAL ENTERPRISE SERVICE OPERATING REVENUES Residential charges $5,777870 $- Commercial charges 2,718,999 - TransfersMlioollud,es 495,154 - Equipmenlseles 17,975 - Cimoessi0nrevenues 137,963 - Golfwurselees 416,401 - SoflballcomPlexfees 60770 - Other fees and char9es 211,175 - InteNepartmenlal services - 3.490,577 011ier miscellaneous 91,589 1,535 TOTAL OPERATING REVENUES 9,927,896 3492,112 OPERATING EXPENSES Personnel services 2,483,881 572,242 Materials and supplies 757,583 294,610 Contractual services 3,354.432 2,255561 General operating expenses 352.204 30,755 Special Projeds expense 42,711 Intemal service expenses 353.045 2434 Depreciation expense 2,016,015 462,176 TOTAL OPERATING EXPENSES 9,359871 3,617,678 OPERATING INCOME (LOSS) 568,025 (125,566) NON-0PERATING REVENUES (EXPENSES) Investment evenue 1,032,241 162,419 State O.nts 29,543 Federal grants 161,748 - Gainonsaleofassets 19,285 16,788 Loss on sale of assets (1122) (42,322) Compensation for damages 1,656 - Issuancecoslamortizatlon (103.488) (3.333) Interest and handling pests (1.950.074) (26,081) TOTAL NON-0PERATING REVENUES (EXPENSES) (810,986) 107,471 INCOME (LOSS) BEFORE OPERATING TRANSFERS (242.983) (16,095) Operating transfers in 1,909.808 80,965 Gpam6rg lrensfers 0nl (201,789) NET INCOME (LOSS) 1,666,845 (138919) RETAINED EARNINGS (DEFICIT), JULY1 925000 3,815,179 RESIDUAL EQUITY TRANSFER (NOTE) (15722) RETAINED EARNINGS (DEFICIT), JUNE 30 $2576,123 $3,676260 15 TOTALS MEMORANDUM ONLY 2000-2001 $5777.870 2,718,999 495,154 17,975 137,963 416,401 60,770 211,175 3490,577 93.124 13,420.008 3,055,123 1,052,393 5,609,993 382,659 42 711 355.479 2A78 191 12.977549 442459 1,194,660 29 546 161,748 36,073 (43,444) 656 (10 5801) 976.955) (703,517) (261,058) 1,990,773 (201,789) 1,527,926 4.740.179 (16.722) $6 252.383 City of Cape Girardeau, Missouri COMBINED STATEMENT OF CASH FLOWS -ALL PROPRIETARY FUND TYPES FOR THE FISCAL YEAR ENDED June 30. 2001 THE NOTES TO THE FINANCIAL STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT. 16 PROPRIETARY FUND TYPES TOTALS INTERNAL (MEMORANDUM ONLY) ENTERPRISE SERVICE 2000.2001 Cash Bows from operating activities Operating Income(Ioss) $568,024 (5125,566) $442,458 Adjustments to reconcile not Income to net cash provided by operating activities Depreciation and amortization 2,016,015 462,176 2,478.191 Deferred revenues 272,503 - 272,503 Cash operating Brants received 191,294 - 191,294 Change In assets and liabilities (Increase) Decrease in accounts receivable (493,667) (5,444) (499,111) (Increase) Decrease In inventory (33,128) 4,311 (28,757) (Increase) Decrease In prepaid expenses (69,081) 24,404 (44,677) Increase (Decrease) In accounts payable 308,723 25,675 334,398 Increase (Decrease) In accrued! liabilities (1,978,927) (4,050) (2,022,977) Increase (Decrease) in landfill postclosure care costs (81,000) (81,000) NET CASH PROVIDED BY (USED IN) OPERATING ACTIVITIES 700,756 341,566 1,042,322 Cash Bows from noncaplUl financing activities Operating transfers from oMer funds 1,909,808 80,965 1,990,773 Operating transfers to other funds (201789) (201,789) NET CASH PROVIDED BY (USED IN) NONCAPITAL FINANCING ACTIVITIES 1,909,808 (120,824) 1,788,984 Cash Bows from capital and related financing Proceeds from developers 1,059,004 - 1,059,004 Proceeds from Issuance of bonds 9,219,185 - 9,219,185 Principal paid on revenue bonds (565,000) - (565,000) Principal paid on lease purchase bonds (311,491) - (311,491) Principal paid on COP (1,280,000) (120,000) (1.400,000) Principal paid on SRF (1,280,070) - (1,280,070) Principal paid on energy loan 8 notes payable on land (7,932) - (7,932) Interest Paid on bonds and obligations (1,903,398) (25,936) (1,929,334) Purchase offixed assets (5,980,238) (280,669) (6,261,107) Proceeds from sale of assets 86,082 24,600 110,682 Compensation for damages 1,656 1,656 NET CASH USED BY CAPITAL AND RELATED FINANCING ACTIVITIES (962,202) (402,205) (1,364,407) Cash flows from investing activities Purchase of investments (592,087) - (592,007) Proceeds from sale of investments 595,581 - 595,581 Interest on Investments 680,327 100,436 780,763 Overnight interest 194,168 61,986 256,154 Interest on assessments 34,634 - 34,634 FMV adjustments to cash (2,646) (2,646) NET CASH PROVIDED BY (USED IN) INVESTING ACTIVITIES 912,623 159,776 1,072,399 NET INCREASE (DECREASE) IN CASH AND CASH EQUIVALENTS 2,560,985 (21,687) 2,539,298 Cash and cash equivalents at beginning of year 13455,022 2,410,613 15,865,635 Cash and cash equivalents at and of year $ 16,016,007 S 2,388,926 $ 18,404,933 THE NOTES TO THE FINANCIAL STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT. 16 r NOTES TO FINANCIAL STATEMENTS r r 17 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES The City of Cape Girardeau, Missouri operates under a charter which went into effect April 12, 1982. The City operates under a Council -Manager form of govemment 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. r The financial statements of the City have been prepared in conformity with generally accepted accounting principles (GAAP), as applied to government units. The Governmental Accounting Standards Board (GASB) is the accepted standard-setting body for establishing governmental accounting and financial reporting principles. The more significant accounting policies of the City are described below. r, 1. Reporting Enfi ' In evaluating how to define the City, for financial reporting purposes, management has considered all �. potential component units. Generally, component units are legally separate organisations for which the elected officials of the City are financially accountable. The Cape Girardeau (Missouri) Public Facilities Authority (CGPFA) is a blended component unit which is part of the City's operations and r so the financial statements of the CGPFA are included in the accompanying financial statements of the City of Cape Girardeau. Cape Girardeau (Missouri) Public Facilities Authority - As described in Note E, the City of Cape Girardeau, Missouri has entered into four lease agreements with the Cape Girardeau (Missouri) Public Facilities Authority (CGPFA). The CGPFA is a not-for-profit corporation organized and existing under Chapter 355 of the Revised Statues of Missouri. The CGPFA board of directors consists of city officials and city council members. Due to the significant city influence and financial accountability, the activities of the CGPFA are blended with the financial presentation of the City. The corporation was used to execute the bond indentures for the purpose of issuing and securing the Series 1993 Bonds, Series 1994A Bonds, and Series 1997A and 1997B Bonds. These bonds were used to finance construction and improvements to sewer, solid waste, street, airport, flood control and other capital improvement projects. The bond payments are obligations of the CGPFA. The CGPFA has entered into a Lease Purchase Agreement with the City Goin which the lease payments will be used solely to retire the debt. Although they ,no not a component unit of the City, the City handles the funds of and provides accounting and other services for several entities. Since these frmds are held in the City's name, these entities are shown as Agency Funds in the financial statements. r ' 18 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 1. Reaortine Entity - Continued Beginning January 1, 2001 the Transportation Sales Tax Trust Fund It was established as a special ` revenue fund. The fund was established to collect and expend a sales tax that was approved by a public vote in August 2000 and became effective January I, 2001. The tax is restricted to being expended on street and sidewalk improvements and will expire in five years. 2. Fund Accountine The accounts of the City are organized on the basis of funds and account groups, each of which is " considered a separate accounting entity. The operations of each fund are accounted for with a separate set of self -balancing accounts that comprise its assets, liabilities, fund equity, revenues and expenditures or expenses as appropriate. Government resources are allocated to and accounted for in individual funds based upon the purpose for which they are to be spent and the means by which spending activities are controlled. 'rhe various funds are grouped, in the financial statements in this report, into fund categories. GOVERNMENTAL FUND TYPES r General Fund - The General Fund is the general operating fund of the City. All financial resources, except those required to be accounted for in another fund, are accounted for in the ` General Fund. Special Revenue Funds - Special Revenue Funds are used to account for the proceeds of ` specific revenue sources (other than expendable trust or major capital projects) are legally restricted to expenditures for specified purposes. r r Debt Service Fund - The Debt Service fund is used to account for the accumulation of resources for, and the payment of, general long -tern 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. 19 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 2. Fund Accounting - 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. Enterprise Fonds - Enterprise Funds are used to account for operations that are financed and operated in a manner similar to private business enterprises - where the intent of the governing body is that the costs (expenses including depreciation) of providing goods or r services to the general public on a continuing basis be financed or recovered primarily through user charges; or where the governing body has decided that periodic determination of revenues collected, expenses paid, and/or net income is appropriate for capital maintenance, public policy, management control, accountability, or other purposes. Internal Service Funds - Internal Service Funds are used to account for the financing of goods or services provided by one department to other departments of the City, on a cost - reimbursement basis. ` FIDUCIARY FUNDS Tmst and Ageneev 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 - I he General Fixed Assets Account Group is used to account for fixed assets used in governmental fund type operations for control purposes. All ., fixed assets are valued at historical cost or estimated historical cost if actual historical cost is not available. Donated fixed assets are valued at their estimated fair value on the date of donation. Depreciation is recorded on general fixed assets. General Lom,=1con Debt Account Group - rhe General Lung -Fenn Debt Account Group is used to account for long-term liabilities to be financed from governmental funds. 20 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued ` 3. Fixed Assets General Fixed Assets Account Grouu - Fixed assets used in governmental fund type operations are ` accounted for in the General Fixed Assets Account Group, rather than in governmental funds. Public domain (infrastructure) general fixed assets, including roads, bridges, curbs and gutters, streets and ` sidewalks, drainage systems and lighting systems, are not capitalized along with other general fixed assets. Depreciation has been provided on all capitalized assets, except for land. All fixed assets are valued at historical cost or estimated historical cost if actual historical cost is not available. Donated assets are valued at their estimated fair value on the date donated. Repairs and maintenance are recorded as expenditures; renewals and betterments are capitalized. Proprietary Funds - Additions to the Proprietary Funds are recorded at cost or, if contributed property, at their estimated fair value at time of contribution. Repairs and maintenance are recorded as expenses; r renewals and betterments arc capitalized. The sale or disposal of fixed assets is recorded by removing cost and accumulated depreciation from the accounts and charging the resulting gain or loss to income. Depreciation of all exhaustible fixed assets used by Proprietary Funds is charged as an expense against their operations. Accumulated depreciation is reported on Proprietary Fund balance sheets. Depreciation has been provided over the estimated useful lives using the straight-line method. The estimated useful lives are as follows. Buildings 25-50 years ` Improvements 10-40 years Equipment 3-10 years When applicable, interest costs are capitalized on self -constructed fixed assets. 4. Basis of Accounting t The accounting and financial reporting treatment applied to a fund is determined by its measurement focus. All governmental funds are accounted for using a current financial resources measurement focus. With this measurement focus, only current assets and current liabilities generally are included on the balance sheet. Operating statements of these funds present increases (i.e., revenues and other financing sources) and decreases (i.e., expenditures and other financing uses) in net current assets. r All proprietary funds are accounted for on a flow of economic resources measurement focus. With this r 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. 21 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued A. 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. r Expenditures are recorded when the related fund liability is incurred. Principal and interest on long- term debt are recorded as fund liabilities when due or when amounts have been accumulated in the debt service fund for payments to be made early in the following year. Those revenues susceptible to accrual are property taxes, franchise taxes, special assessments, licenses, a 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. r The accrual basis of accounting is utilized by proprietary funds. Under this method, revenues are recorded when earned and expenses are recorded at the time liabilities are incurred. The City reports deferred revenue on its combined balance sheet. Deferred revenues arise when a potential revenue does not meet both the "measurable" and "available" criteria for recognition in the current period. Deferred revenues also arise when resources are received by the City before it has a legal claim to them, as when grant monies are received prior to the incurrence of qualifying expenditures. In subsequent periods, when both revenue recognition criteria 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. r 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. 22 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued ` 6. Budgets and Budgetary Accounting The City adopts annual operating budgets for all funds. The City follows these procedures in establishing the budgetary data reflected in the financial statements. 1. The City Manager submits to the City Council a proposed operating budget for the fiscal year commencing the following July 1. The operating budget includes proposed expenditures and the means of financing them. 2. Public hearings are conducted to obtain taxpayer comments. 3. Prior to July 1, the budget is legally enacted through passage of an ordinance. 4. The City Manager is authorized to transfer budgeted amounts between programs within any department, however, any revisions that alter the total appropriations of any department must be approved by the City Council. Departments may not legally exceed their appropriations without approval from the City Council. Appropriations expire at the end of the year, however, outstanding encumbrances at the end of the year are ` honored by the City. 5. Formal budgetary integration is employed as a management control device during the ` year for all funds. 6. Budgets for all funds are adopted on a budgetary basis. c 23 City of Cape Girardeau, Missouri NOTES TO FINANCIAL. STATEMENTS June 30, 2001 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 6. Budgets and Budgetary Accounting t Additional budget appropriations by department made throughout the year are as follows Public Safety -General Fund $ 118,325 Development Services -General Fund 20,000 General Fund Transfers 53,000 Administrative Services -Vision 2000 Fund 22,500 r Parks and Recreation -Parks and Recreation Fund 82,000 Capital Improvement—Parks Improvement Fund 105,000 Public Works -Sewer Fund 651,930 Public Works-WaterFund 220,214 Public Works -Solid Waste Fund 121,672 Employee Fringe Benefit Fund 342,000 3.641 The above appropriations included the following: (1) $118,325 for public safety expenditures that include $35,000 for grant funded project impact costs, $73,675 grant funded costs associated with the conversion of the police department's computer hardware and software systems, and $9,650 grant and donation funded costs of a communications conduit between fire station #1 and the police headquarters (2) $20,000 for development service expenditures to cover the annual payment required by a Radio and TV and Broadcasting Studio Cooperation Agreement entered into with the Cape Girardeau Public Schools in December of 2000 (3) $53,000 for general fund transfers to cover t. anticipated operating deficits in the Parks and Recreation, Vision 2000, and Golf funds (4) $22,500 for administrative service expenditures incurred by the Vision 2000 Fund for operating expenses including the completion of the garden at City Hall (5) $82,000 increase in parks and recreation - expenditures to cover additional personnel and operating expenses in various divisions of the Parks and Recreation Fund (6) $105,000 to cover the cost of the grant funded "Cape Woods Trail" project (7) $993,816 for public works expenditures to cover the additional debt service costs resulting from the November 2000 defeasance of a portion of the outstanding 1994 Certificates of Participation r from the unused portion of construction funds and (8) $342,000 for unanticipated claims against the City's self-insured health program. The following appropriation transfers were also made during the year: (1) $47,000 from development services - General Fund to interdepartmental services - General Fund to cover the personnel costs allocated to various city capital projects (2) $40,500 from public works - General Fund to public safety - General Fund to cover additional Fleet maintenance costs of the police and fire divisions (3) $23,000 parks and recreation - General Fund to parks and recreation - Golf Fund to cover additional Fleet maintenance costs (4) $20,000 from contingency - General Fund to r interdepartmental - Gencial Fund for additional operating expenditures. 24 r City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 6. Budgets and Budaetary Accounting - Continued For the year ended June 30, 2001 the fund expenditures for Parks and Recreation, Capital Improvement ` Sales Tax -Water Projects, Transportation Sales Tax "frust 11, Community Development Block Grants, and Equipment Replacement funds exceeded their approved budgets by, $15,420, $170,000, $461,266, $184,067, and $2,884. r The Combined Statement of Revenues, Expenditures, and Changes in Fund Balance -All Governmental Fund Types reports revenues and expenditures on the modified accrual basis of accounting in accordance with GAAP. The Combined Statement of Revenues, Expenditures, and Changes in Fund Balance -Budget and Actual (Budget Basis) for all governmental fund types is prepared on a budgetary basis which includes encumbrances as expenditures. The following reconciliation adjusts GAAP basis to budget basis: Excess (Deficiency) of Revenues and Other Financing Sources over (order) Fspeaditures and Other Flnanc ne U. Special Debt Capital Gene.] Revenue Serene, Pro'co GAAP Bn_ais $(239,223) $(2,059,767) $22,850 $(7,756,435) Increase due to Prior year encmnbranecs Administrative Services Developmcm services Parks and reencafion Public safety Public Works Capital outlay Water lmprovcmerus Fund not budgeted annually 17,615 Dccrvasadueit, rYana-end - encumbrances Adarini,f anve services r Development services Parks and uer.t it r Public safety 5,224 Public works r c,"nal outlay 4,434,692 Adjust invaan.unt, to nada 42,101 4.445 686 r Budget Btuis r 2,297 r - 17,615 8,465 - 5,310 172 2,029 13,780 500 - 5,224 - 4,434,692 - 42,101 4.445 686 2,297 87,042 - 675 - 1,887 650 - 23,102 2,262 - 1,623 - - 2,555,211 - 16661 _ 119,295 55756 46,215 2764460 55756 4'(243,367) _v(31S,51) _ $(32906) 25 r 73,173 592 641 7,665,814 598,112 12 542 610,654 $(701,275) City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued fi. Budgets and Budgetary Accounting - Continued The individual proprietary schedules of comparing budget to actual is reported on a budgetary basis that uses the modified accrual basis of accounting with the exception of encumbrances. Encumbrances are reported as expenses in the year of encumbrance. Net Income (Loss) Solid Golf Softball ScwcT Water Waste Course QJile, GAAP Basis $1,187,877 $306,039 $196,977 $(18,049) $(5,999) Increase due to Prior year, encumbrance, Materials and supplies 126 4,332 202 - 158 General operson, crpen,a - - 900 - - Contracmul carica - - 636 - - special pmjccte 3,290 - - - 64 Depreciation 1,267,885 517,541 156,574 58,007 16,008 Impactfes 155,563 - - - - Special usaxncnu, 307,794 111,849 - - - Deterred re,e nes 17,858 43,026 57,890 - - Locu1 grants - - 8,505 - - Bond proceeds 8,413,618 - - - - Interest paid less than accrual 54,272 - - - - Intcratcostemortiael 572,395 - - - - Cost of bond refunding amortlmtion 12,802 47,460 - - - Amorlizedbondpranimn/discount - 16 - - [,issuance cost interposition 78,182 23,212 2,074 - - Diflerencebetwan proceeds from sale of Fixed assets and gain or loss 119 21,33 10,883,90 747 436 249,11 58,00 Iy230 Decrease due to Year -cad encumbrances Materials and supplies - - - 1,974 - General operating expenses - - - 1,067 - Contractual services 12,606 684 2,584 - - Special projects - - 955 - 75 Landfill closure and mainhnei costs - - 7,912 - - interestpaid murethan accrual - 12,603 2,114 - - Amortivcd bond premiuMdiscount 2,383 Issuance cost paid 150,369 - - - - Boodprincipalpaid 2288,592 755,000 167,932 - - (',pitaloufl, s 2,988,015 84,443 236,136 18;179 7,325 Amoum def rued for fns, c debt scr,,icc for capital l in ,t Id,L_ C . uu,noii fund 75,137 - - - litcocss subsidyrc iced. 5%4480 Alla c st to limbila, lot Fine, land611 postclosse, aims nano a,N„ - - 73,088 - - AAiuninrest istomorkct 15725 79969 2819 403 _ 150 6 117 107_ 937 699 493 541.1 22423 7 550 Bad"(Bats _ %5,954,474 .115,776 $(48,446) $17,535 $2,681 26 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 6. Budgets and Budgetary Accounting - Continued 27 Net Income Q.oss) Data IIm Da'h"ce Rick F<�ulpmem Pcceg..as Manaec c, runs, Manaeemea ccn R,1 ep, GAAP Basis $(86,870) $4,500 $(178,397) $21,917 $99.931 Increase due to: Prior year encumbrances Material and supplies - 553 - - - Contractual services - - - 11,494 - Depreciation 207,355 45,365 - - 209,456 Difference between proceeds from sale of feed assets and gain or loss 14,300 - - - 35,834 Issuance cost amortization 1,734 - - - 1,599 Amortized bond premium/discount 59 - - - 85 223,448 45,918 - 11 494 246 974 Decrease due to: Year-end encumbrances Contractual services - - - 83 - Interest paid more than accrued 713 2 - - 713 Principal paid 60,000 441 - - 60,000 Capital outlays 63,976 15,673 - - 172,641 Adjust investment to market 638 352 6,982 16.628 2,04 125,32 16 468 6,982 16 711 235A 0 Budget Basis _ $11.2-51 $085,379) _$16,700 $111,505 7. Inventories Inventories consist primarily of supplies, valued at cost, which approximates market. Cost is determined using a weighted average method. The cost of inventories is recorded as expenditures or expenses when consumed rather than when purchased. 27 4 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued A. 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 [list are not expected to be liquidated within the current year are reported in the general long -tern debt account group. Employees may accumulate up to 30 days vacation, for which they are compensated upon termination or retirement. Employees are not compensated for accumulated sick leave upon termination or retirement. 9. Bond Discounts/Issuance Costs .. In governmental fund types, bond discounts and issuance costs are recognized in the current period. Bond discounts and issuance costs for proprietary fund types are deferred and amortized over the term " of the bonds. Bond discounts are presented as a reduction of the face amount of bonds payable whereas r issuance costs are recorded as deferred charges. 10. Total Columns - Memorandum Only r Total Columns are captioned "Memorandum Only" to indicate that they are presented only to facilitate financial analysis. Data in these columns do not present results of operations in conformity with generally accepted accounting principles. Neither is such data comparable to a consolidation. r Interfund eliminations have not been made in the aggregation of this data. r 11. Cash and Investments r 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 r to each fund based on its average equity balance in the pool. Cash includes amounts in repurchase agreements and other short-term investments with a maturity date within three months of the date of purchase. 28 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 11. Cash and Investments Continued The City's investment policy authorizes it to invest its available operating and reserve funds in (I) ` 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 valued at market value as determined by averaging market quotes received by two different r securities dealers. All other cash and investments are valued at cost or amortized cost. 12. Comparative Data r Comparative totals for the prior year have been presented in the accompanying financial statements in t 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, 2001 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, r r 29 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 15. Long-term Obligations Long-temt debt is recognized as a liability of a governmental fund when due, or when resources have been accumulated in the debt service fund for payment early in the following year. For other long-term obligations, only that portion expected to be financed from expendable available financial resources is .. reported as a fund liability of a governmental fund. 'The remaining portion of such obligations is reported in the general long-term debt account group. Long-term liabilities expected to be financed from proprietary fund operations are accounted for in the appropriate proprietary fund. r 16. Interfund Transactions r 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/expenses in the reimbursing fund and as r. reductions of expenditures/expenses in the fund that is reimbursed. All other interfund transactions, except quasi -external transactions and reimbursements, are reported as transfers. Nonrecurring or nonroutine permanent transfers of equity are reported as residual equity r transfers. All other interfund transfers are reported as operating transfers. 17. Short-term Interfund Receivables/Payables During the course of operations, numerous transactions occur between individual funds for goods provided or services rendered. These receivables and payables are classified as "due from other funds" r or "due to other funds" on the balance sheet. Short-term interfund loans are classified as "interfund receivables/payables". r 18. Advances to Other Funds Noncurrent portions of long-term interfund loan receivables are reported as advances and are offset r 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. 30 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued r r 19. Post -Employment Health Care Benefits In addition to the pension benefits described in Note H, it is the City's policy to provide postretirement health care benefits to employees who retire from the City with five or more years of service and who r are eligible for LAGERS retirement (Note H). Currently, thirty-six employees meet those eligibility requirements. The City provides health cart 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, 2001, those costs totaled $82,441. COBRA Benefits - Under the Consolidated Omnibus Budget Reconciliation Act (COBRA), the City provides health care benefits to eligible former employees and eligible dependents. Certain requirements are outlined by the federal government for this coverage. The premium is paid in full by t the insured on or before the tenth (10th) day of the month for the actual month covered. This program r is offered for a duration of 18 months after the tennination date. There is no associated cost to the City under this program, and there were two participants in the program as of June 30, 2001. r NOTE B - DEPOSITS AND INVESTMENTS 1. Deposits At June 30, 2001, the carrying amount of the City's deposits was $3,574,186 and the bank balance was $3,234,210, which excludes $6,462 of petty cash funds held at various City locations. The deposits are categorized in accordance with risk tactors created by governmental reporting standards. Carrying Bank Amount Balance Category#1 $3,567,724 $3,234,210 Category #2 6,462 - Category #3 - - 3 574 186 $3 234 210 r Category N 1 includes deposits covered by deposit insurance or collateral held by the City in the City's name. r Category f2 includes deposits covered by collateral held by the financial institution's trust department in the City's name. r Category 0 includes deposits which arc uncollatemlized or the collateral is held by the financial institution's trust department but not in the City's name. r r '_ 31 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE R - 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 41 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#3 Uninsured and unregistered, with securities held by the counter -party, or by its department or agent but not in the City's name. Cateeory Carrying Fair 41 #2 #3 Value Value Repurchase Agreements $ 1,907,297 $- $- $ 1,907,297 $1,907,297 U.S. Govemment Securities 13,414,348 - - 13,414,348 13,442,582 Certificates of Deposit 8,372,919 - - 8,372,919 8,372,919 Negotiable Certificate of Deposit 288,000 - - 288,000 288,000 Municipal Bonds _78 239 78,239 85,625 $2A.060 803 S- —$- $24,060,803 $24,096,423 Money Market Account U.S. Government Securities State Revolving Fund Program 32 703,162 703,162 25 281,835 25 281,835, $5ll (145 800 $50,081 420 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE C - PROPERTY TAXES Property taxes attach as an enforceable lien on property as of January 1. Taxes were levied on August 16, 1999, for collection during this fiscal year and were due on or before December 31. Most of the taxes are collected in November and December. The tax rates assessed at the time were as follows: City Revenue Library Tax Public Health Tax Debt Service Tax Special Business District #2 (Ad Valorem) S .32/100.00 assessed valuation .17/100.00 assessed valuation .06/100.00 assessed valuation .10/100.00 assessed valuation .79/100.00 assessed valuation Property tax receivable balances as of June 30, 2001 are as follows: Balance Accumulated Downtown July 1, 2000 Additions Deductions Depreciation June 30, 2001 Business Debt $ 2,597,199 $ 1,606 $- General District Health Service Library Total Current property tax $33,638 $ 612 $ 6,359 $10,671 $17,545 $68,825 Delinquent property tax 32,583 85 5,163 10,958 15,814 64,603 Reserve for doubtful 1,061,402 206,359 183,862 129,616 954,283 Construction in progress Property taxes2t 8 4901 (85) (4.596 (9.038)1( 3.616) 51 5.8251 Net property tax receivable 5317-31 __612 $ 6,926 $12,591 1 43_ _ $77,603 NOTE D - CHANGES IN FIXED ASSETS A summary of the general fixed assets account group for the year ended June 30, 2001 is as follows 33 Balance Accumulated Balance July 1, 2000 Additions Deductions Depreciation June 30, 2001 Land $ 2,597,199 $ 1,606 $- $- $ 2,598,805 Buildings 8,153,829 7,656 - 377,561 7,783,924 Improvements other Than buildings 3,905,188 123,878 58,942 250,436 3,719,688 Equipment 1,061,402 206,359 183,862 129,616 954,283 Construction in progress _ 125.125 99 2207 126,122 _ _ 88,21 'Poral general fixed assets $15,842,743 $42870fi $368926 $757,613 $15,144,910 33 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE D - CHANGES IN FIXED ASSETS - Continued Additions and deletions to the Enterprise Funds for the fiscal year 2001 were $15,988,073 and $577,452 respectively. Additions and deletions to the Internal Service Funds were $345,723 and $486,847 respectively. J1,1y1,2000 S2,040,000 A summary of the proprietary fund type fixed assets for the year ended June 30, 2001 is as follows: Rvi,t-1, Enterprise Internal Amount Added Fund Scrvice Fund Land $ 248,109 $ 37,500 Buildings 9,254,881 449,603 Improvements other than building 55,803,007 113,749 Equipment 4,708,342 3,725,501 Construction in progress 25,405,11 A $95,419,457 $ 4,326,353 Less: accumulated depreciation 20,205,039 2,334.492 _ 75 214418 $ 1,991,861 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, 2001. Gomm1 U.,ala ld Cctld,,W, Obligetial Revrnuc Or Revenue UnuWPald Due mOWrr Bunds Bonds Parturetin Bobd, f.rtvc Govern nc ttt gal Gcnemllongtcnn debt puyuble at J1,1y1,2000 S2,040,000 b2,5R5015 Rvi,t-1, (370000) (421,617) Amount Added - - GenemllnngIerm debt Pahl, m June 30, 1001 $1.670000 $1163398 84,345,000 $24,935,000 $651980 $ 13,277 534,569,072 (SN),000) (6611,000) - (13,277) (2.024,994) 30644 30,014 $3.785.000 $24,275.000 5681,424 34 S-_ $32.574.822 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE E - LONGTERM OBLIGATIONS - Continued The following is a smmnary ofbond transactions in the Proprietary Funds of the City for the year ended June 30, 2001. Bonds payable at June 30, 2001 are comprised of the following individual issues $ 1,670,0 0 1993 General Obheation RefundinC Bonds due as follows: Year Ending Interest Leasehold Certificates June 30 Revenue Revenue of Total 2002 Bonds Bonds Participation Total Bonds payable at 5.00 405,000 53,875 458,875 July 1,2000 $42,382,066 $735,338 $3,074,480 $46,191,884 Discount Amortization 5.00 450,000 11.250 461.250 & Issue Cost 111,406 5,108 145 116,659 Bonds Issued 8,355,000 - - 8,355,000 Accumulated Interest 864,186 - - 864,186 Bonds Retired19( 09 000) (306.3831 (1,400,000) ($3,615,383) Bonds payable at June 30, 2001 $49.803,658 --S434,0�3 -$I674625 $51 9]2.346 Bonds payable at June 30, 2001 are comprised of the following individual issues $ 1,670,0 0 1993 General Obheation RefundinC Bonds due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total 2002 4.90% $ 390,000 $ 73,555 $ 463,555 2003 5.00 405,000 53,875 458,875 2004 5.00 425,000 33,125 458,125 2005 5.00 450,000 11.250 461.250 _1.670000 $171805 x,841.805 Principal payments are made annually on November 1, and interest payments are made semi-annually on May 1 and November I. 35 �- City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 r NOTE E - LONGTERM OBLIGATIONS - Continued On April 20, 1993, the City of Cape Girardeau issued $3,690,000 of General Obligation Refunding t Bonds Series 1993 with interest rates varying from 3.75% to 5.50%. The refunding bonds constitute general obligations of the City and are payable as to both principal and interest from ad valorem taxes which may be levied without limitation as to rate or amount upon all the taxable tangible property, real and personal, within the territorial limits of the City. The refunding bonds were issued to provide the City with funds which together with other legally available funds of the City, were used to refund $3,580,000 principal amount of General Obligation Refunding Bonds, Series 1987, of the City and pay the costs of issuance of the bonds. S 665,000 Series 1993 Sewerage System Revenue Bonds due as follows: Year Ending Interest Principal Interest Julie 30 Rate Due Due Total 2002 5.125% $ 115,000 $ 35,131 $ 150,131 2003 5.250 120,000 29,238 149,238 2004 5.300 135,000 22,938 157,938 2005 5.350 140,000 15,783 155,783 2006 5.350 155,000 8,293 163,293 $ 665,000 $111,383 —S776,3B 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 I, and September I. 36 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 June 3, 1992. Principal payments are made annually on March I, and interest payments are made semi-annually on March 1 and September 1. Additional principal of $8,090,000 originally payable through the fiscal years ending June 30, 2006 to 2012, was defeased via an in -substance defeasance during the fiscal year ended June 30, 1996. 37 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE E - LONGTERM OBLIGATIONS - Continued $ 2,090.000 Waterworks System Revenue Bonds Series 1992 due as follows: Year Ending Interest Principal Interest ` June 30 Rate Due Due Total 2002 6.10% $ 425,000 $ 149,968 $ 574,968 2003 7.45 485,000 124,042 609,042 2004 7.45 555,000 87,910 642,910 2005 7.45 625.000 46,563 671,563 $2,090,000 $408,483 S1498,483 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 June 3, 1992. Principal payments are made annually on March I, and interest payments are made semi-annually on March 1 and September 1. Additional principal of $8,090,000 originally payable through the fiscal years ending June 30, 2006 to 2012, was defeased via an in -substance defeasance during the fiscal year ended June 30, 1996. 37 r City of Cape Girardeau, Missouri NO'rES TO FINANCIAL STATEMENTS June 30, 2001 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 8.545,000 Waterworks System Refunding Revenue Bonds Series 1995 due as follows: Year Ending Interest Principal June 30 Rate Due 2002 4.500% $ 90,000 2003 4.500 90,000 2004 4.600 95,000 2005 4.750 100,000 2006 4.875 810,000 2007 5.000 890,000 2008 5.000 980,000 2009 5.200 1,010,000 2010 5.000 1,065,000 2011 5.000 1,120,000 2012 5.000 2.295 000 Interest Due Total $ 426,727 $ 516,727 422,678 512,678 418,627 513,627 414,258 514,258 409,507 1,219,507 370,020 1,260,020 325,520 1,305,520 276,520 1,286,520 224,000 1,289,000 170,750 1,290,750 114,750 2,409,750 r $S,5-45.00 3 573 357 $12,118,357 Principal payments are made annually on March 1, and interest payments are made semi-annually on March I and September I. On December I, 1995 the City of Cape Girardeau issued $9,095,000 of Waterworks System Refunding Revenue Bonds Series 1995 with interest rates varying from 3.9% to 5.2%. The bonds ,. are special limited obligations of the City payable solely from the net income and revenues derived r by the City from the operation of the Waterworks System after payment of costs of operation and maintenance. i The bonds were issued to provide the City with funds to defcase $8,090,000 principal amount of Waterworks System Revenue Bonds, Series 1992. The City transferred net proceeds of $8,711,864 e to Mercantile Bank of St. Louis National Association, St. Louis, Missouri (the "Escrow Agent"), for deposit into an Escrow Fund established under an Escrow'1'rust Agreement dated December 1, 1995 (the "Escrow Trust Agreement") between the City and the Escrow Agent. The proceeds were used P to purchase direct obligations of, or obligations the principal of and interest on which are unconditionally guaranteed by, the United Slates of America. " The refunded bonds shall be payable from the maturing principal of the Escrowed Sa;uritica, .. together with the earnings thereon for the period beginning March I, 1996, and continuing through March I, 2002, the date on which the Refunded Bonds will be redeemed. r r i 38 r City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE E - LONG-TERM OBLIGATIONS - Continued S 1950,000 Seweracc System Revenue Bonds (State Revolving Fund Program) Series 1991 due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total 2002 6.500% $ 100,000 $ 133,399 $ 233,399 2003 6.600 105,000 126,899 231,899 2004 6.875 110,000 119,969 229,969 2005 6.875 120,000 112,406 232,406 2006 6.875 130,000 104,156 234,156 2007 6.875 135,000 95,219 230,219 2008 6.875 145,000 85,937 230,937 2009 6.875 155,000 75,969 230,969 2010 6.875 165,000 65,312 230,312 2011 6.875 175,000 53,969 228,969 2012 6.875 190,000 41,937 231,937 2013 0.875 205,000 28,875 233,875 2014 6.875 215.000 14,781 229,781 $1,950,000 $1058_828 3008828 These bonds are dated December I, 1991. The proceeds of the bond issue will be used to extend and ` improve the existing sewerage facilities serving the City. Principal payments are made annually on June 1, and interest payments are made semi-annually on June ` I and December I. r. The interest due on the 1991 Sewer System Revenue Bonds will be subsidized by interest earnings on a reserve fund held by the bond iss'ue's trustee. As the City is reimbursed for sewer project expenditures from the construction funds held by the trustee, the Department of Natural Resources deposits an amount equal to approximately 51.907% of the reimbursement into the reserve fund. The maximum amount of funds that will be advanced to the reserve fund will be $1,250,000. As bonds are paid off 50% of the amount of bonds paid off will be repaid to the Department of Natural Resources out of the r, reserve fund. The balance of the reserve fund at June 30, 2001 was $991,184. The reserve fund yields 6.7100/,. r. During the year 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 t savings resulting from this transaction are to be used to offset city debt service payments due on Series r 1991 Bonds. In the current year, city interest expense was reduced by $5,000 as a result of this transaction. Over the remaining life of these bonds the city will receive Net Present Valuc benclits of approximately $176,000 from this transaction. 39 r City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE E - LONG-TERM OBLIGATIONS - Continued S 395,000 Sewerage System Revenue Bonds (State Revolving Fund Program) Series 1993 due as follows: These bonds are dated August I, 1993. The proceeds of the bond issue were used to extend and improve the existing sewerage facilities serving the City. Principal payments are made annually on March 1, and interest payments are made semi-annually on March 1 and September 1. The interest due on the 1993 Sewer System Revenue Bonds will be subsidized by interest earnings on r, a reserve fund held by the bond issue's trustee. As the Cityis reimbursed for sewer project expenditures from the construction funds held by the trustee, the Department of Natural Resources will deposit an amount equal to approximately 70.00% of the reimbursement into the reserve fund. The maximum amount of funds that will be advanced to the reserve fund will be $350,000. As bonds are paid off, 70% of the amount of bonds paid off will be repaid to the Department of Natural Resources out of the reserve fund. The balance of the reserve fund at June 30, 2001 was $276,500. The reserve fund yields 5.15%. 40 Year Ending Interest Principal Interest r June 30 Rate Due Due Total r 2002 4.550% $ 20,000 $ 20,044 S 40,044 2003 4.700 21,000 19,096 40,096 2004 4.800 22,000 18,074 40,074 2005 4.900 23,000 16,983 39,983 2006 5.000 24,000 15,819 39,819 2007 5.100 25,000 14,582 39,582 2008 5.200 27,000 13,242 40,242 2009 5.250 28,000 11,805 39,805 2010 5.400 30,000 10,260 40,260 2011 5.400 31,000 8,613 39,613 r 2012 5.400 33,000 6,885 39,885 2013 5.400 35,000 5,049 40,049 2014 SA00 37,000 3,106 40,106 2015 5.400 39,00 1,053 40,053 395 000 $ 164_611 _ $ 559,611 These bonds are dated August I, 1993. The proceeds of the bond issue were used to extend and improve the existing sewerage facilities serving the City. Principal payments are made annually on March 1, and interest payments are made semi-annually on March 1 and September 1. The interest due on the 1993 Sewer System Revenue Bonds will be subsidized by interest earnings on r, a reserve fund held by the bond issue's trustee. As the Cityis reimbursed for sewer project expenditures from the construction funds held by the trustee, the Department of Natural Resources will deposit an amount equal to approximately 70.00% of the reimbursement into the reserve fund. The maximum amount of funds that will be advanced to the reserve fund will be $350,000. As bonds are paid off, 70% of the amount of bonds paid off will be repaid to the Department of Natural Resources out of the reserve fund. The balance of the reserve fund at June 30, 2001 was $276,500. The reserve fund yields 5.15%. 40 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE E - LONG-TERM OBLIGATIONS - Continued ` S 10,486 036 Water Pollution Control Revenue Bonds (State Revolving, Fund Profawn) Series 1995D due as follows - r These bonds are dated June 1, 1995. The proceeds of the bond issue will be used for the extension and improvement of the existing sewerage system serving the City. Principal and interest payments will be made annually on January 1 beginning in the year 1998. The interest due on the 1995D Water Pollution Control Revenue Bonds will be subsidized by interest earnings on a reserve fund held by the bond issue's trustee. As the City is reimbursed for sewer project expenditures from the construction funds, the Department of Natural Resources will deposit an amount r equal to 70% of the disbursement into the reserve fund. The maximum amount of funds that will be advanced to the reserve fund will be 70% of the principal amount less the original issue discount. As bonds are paid oIT 70% of the amount of bonds will be repaid to the Department of Natural Resources Y out of the reserve fund. The balance of -the reserve fund at June 30. 2001 was $7,340,225. The reserve �.. fund yields 5.83%. 41 Yew finding Interest Principal Interest e June 30 Rate Due Due Total 2002 5.250% 5 913,677 $ 366,323 51,280,000 2003 5.300 918,381 441,619 1,360,000 2004 5.400 924,769 530,231 1,455,000 2005 5.500 928,413 626,587 1,555,000 2006 5.650 932,824 742,176 1,675,000 2007 5.750 937,566 862,434 1,800,000 2008 5.850 943,267 996,733 1,940,000 2009 5.950 946,770 1,143,230 2,090,000 2010 6.050 722,409 992,591 1,715,000 2011 6.100 413,574 636,426 1,050,000 r 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 $ L 0 486 036 S 463=964 $21.950 000 r These bonds are dated June 1, 1995. The proceeds of the bond issue will be used for the extension and improvement of the existing sewerage system serving the City. Principal and interest payments will be made annually on January 1 beginning in the year 1998. The interest due on the 1995D Water Pollution Control Revenue Bonds will be subsidized by interest earnings on a reserve fund held by the bond issue's trustee. As the City is reimbursed for sewer project expenditures from the construction funds, the Department of Natural Resources will deposit an amount r equal to 70% of the disbursement into the reserve fund. The maximum amount of funds that will be advanced to the reserve fund will be 70% of the principal amount less the original issue discount. As bonds are paid oIT 70% of the amount of bonds will be repaid to the Department of Natural Resources Y out of the reserve fund. The balance of -the reserve fund at June 30. 2001 was $7,340,225. The reserve �.. fund yields 5.83%. 41 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE E - LONGTERM OBLIGATION - Continued $ 13,485 000 Sewerage System Revenue Bonds (State Revolving Fund Program) Series 1996 due as follows: These bonds are dated June 1, 1996. The proceeds of the bond issue will be used for the extension and improvement of the existing sewerage system serving the City. r Principal payments will be made annually on January 1 beginning in the year 2000. Interest is paid semi-annually on January 1 and July I beginning in the year 1997. The interest due on the 1996 Sewerage System Revenue Bonds will be subsidized by interest earnings r. on a reserve fund held by the bond issues trustee. As the City is reimbursed for sewer project expenditures from the construction funds, the Department of Natural Resources will deposit an amount equal to 70% of the disbursement into the reserve fund. The maximum amount of funds that will be r advanced to the reserve will be $9,474,500. As bonds are paid off 70°/, of the amount of bonds will be repaid to the Department of Natural Resources out of the reserve fund. The balance of the reserve fund at lune 30, 2001 was $9,076,855. 'Phe reserve fund yields 5.70%. r Year Ending Interest Principal Interest June30 Rate Due Due Total 2002 4.800% $575,000 $ 758,474 $1,333,474 2003 4.900 585,000 730,874 1,315,874 2004 5.000 590,000 702,209 1,292,209 2005 5.150 600,000 672,709 1,272,709 2006 5.250 610,000 641,809 1,251,809 r 2007 5.350 690,000 609,784 1,299,784 2008 5.500 700,000 572,869 1,272,869 ' 2009 5.600 715,000 534,369 1,249,369 2010 5.700 730,000 494,329 1,224,329 2011 5.875 745,000 452,719 1,197,719 2012 5.875 765,000 408,950 1,173,950 2013 5.875 780,000 364,006 1,144,006 2014 5.875 800,000 318,181 1,118,181 2015 5.875 875,000 271,181 1,146,181 2016 5.900 895,000 219,775 1,114,775 2017 5.900 920,000 166,970 1,086,970 2018 5.900 945,000 112,690 1,057,690 2019 5.900 965.000 56,935 1.021,935 &13 485 000 $8,088,833 $21,573,833 These bonds are dated June 1, 1996. The proceeds of the bond issue will be used for the extension and improvement of the existing sewerage system serving the City. r Principal payments will be made annually on January 1 beginning in the year 2000. Interest is paid semi-annually on January 1 and July I beginning in the year 1997. The interest due on the 1996 Sewerage System Revenue Bonds will be subsidized by interest earnings r. on a reserve fund held by the bond issues trustee. As the City is reimbursed for sewer project expenditures from the construction funds, the Department of Natural Resources will deposit an amount equal to 70% of the disbursement into the reserve fund. The maximum amount of funds that will be r advanced to the reserve will be $9,474,500. As bonds are paid off 70°/, of the amount of bonds will be repaid to the Department of Natural Resources out of the reserve fund. The balance of the reserve fund at lune 30, 2001 was $9,076,855. 'Phe reserve fund yields 5.70%. r 42 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 r NOTE E - LONG-TERM OBLIGATION—Continued ` During the year 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 W savings resulting from this transaction are to be used to offset city debt service payments due on Series 1996 Bonder. In the current year, city interest expense was reduced by $213,801 as a result of this transaction. Over the remaining life of these bonds the city will receive Net Present Value benefits of approximately $310,000 from this transaction. $24,275,000 Waterworks Svstem Revenue Bonds t State Revolving Fund Program) Series 1998 due as follows: r These bonds are dated December 1, 1998. The proceeds of the bond issue will be used for the extension and improvements to the waterworks system. Principal payments will be made annually on January 1 beginning in the year 2000. Interest is paid semi-annually on January I and July I beginning on July 1, 1999. 43 Year Ending Interest Principal Interest ° June 30 Rate Due Due Total r 2002 3.750% $ 695,000 $ 1,141,228 $ 1,836,228 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 n 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 ri 2009 4.300 1,025,000 910,475 1,935,475 2010 4.375 1,080,000 866,400 1,946,400 t. 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,75 $24,2753000 $13,301,240 $37,576,240 These bonds are dated December 1, 1998. The proceeds of the bond issue will be used for the extension and improvements to the waterworks system. Principal payments will be made annually on January 1 beginning in the year 2000. Interest is paid semi-annually on January I and July I beginning on July 1, 1999. 43 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE E - LONGTERM OBLIGATION —Continued fire 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 will be repaid to the Department of Natural Resources out of the reserve fund. The balance of the reserve fund at June 30, 2001 was $3,912,929. The reserve fund yields 4.71%. r r $ 1,805,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 r 2002 4.625% $ 720,000 $ 86,500 $ 806,500 2003 4.750 420,000 53,200 473,200 2004 5.000 185,000 33,250 218,250 2005 5.000 480,000 24,000 504,000 $1-80-5000 196,95 $-2001.95 The bonds are obligations of the Cape Girardeau (Missouri) Public Facilities Authority (CGPFA). The t" CGPFA has entered into a Lease Purchase Agreement with the City of Cape Girardeau, Missouri. r, Principal and interest will be paid by CGPFA from rental and other receipts from the City. The purpose of the bonds was to (1) pay the costs of various street improvements for the City, (2) defease r $10,410,000 outstanding principal amount of Building and Equipment Leasehold Revenue Bonds of r, the Authority and (3) pay the costs of issuance of the Series 1993 Bonds. The bond principal is allocated as follows: $437,602 - Sewer Fund; and $1,367,398 - General Long- term Debt Account Group. Principal payments are made annually on March 1 and interest payments are made semi-annually on March 1 and September I. 44 r City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE E - LONG-TERM OBLIGATION - Continued $305,000 Citv of Cane Girardeau. Missouri Lease Purchase Agreement dated June 17. 1999 due as follows Year Ending Interest Principal Interest June 30 Rate Due Due Total 2002 5.000% $ 24,000 $ 15,250 $ 39,250 2003 5.000 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 X05 000 90 250 _$39 5 250 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 is allocated $305,000 to the General Long -Tenn Debt Account Group. Principal payments are made annually on April I and interest payments are made semi-annually on April I and October I. 45 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 491,000 City of Cape Girardeau Lease Purchase Agreement dated March 31 2000 due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total 2002 5.750°°% $ - $ 28,232 $ 28,232 2003 5.750 - 28,232 28,232 2004 5.750 - 28,233 28,233 2005 5.750 491.000 28,233 519,233 $ 491.000 $112930 $603,930 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 purchase approximately 12 acres in the south central portion of the City for the Public Works Department. The lease principal 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 1 and September 1. 46 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 2,045,000 Certificates of Participation (Convention_ and Visitors Recreation Facilities Project), Series 1993. Year Ending Interest Principal Interest June 30 Rate Due Due Total 2002 5.000% $ 400,000 $ 104,588 $ 504,588 2003 5.000 455,000 84,588 539,588 2004 5.125 510,000 61,838 571,838 2005 5.250 680,000 35,700 715,70 S2045A00 286714 $2337.714 The certificates are obligations of the City of Cape Girardeau, Missouri. Under a Lease Purchase Agreement between the City and the Cape Girardeau (Missouri) Public Facility Authority (the "Corporation'), the Corporation will assign the right to receive rental and other receipts from the City to Union Planters Bank of Cape Girardeau County ( the "Trustee"). The purpose of the 1993 Series certificates is for the acquisition, construction, famishing, and equipping of a convention and recreational center, softball and soccer fields, and improvements to the City Hall. The bond liability for the Series 1993 certificates is recorded in the General Long-Tcmt Debt Account Group. Principal payments are made annually on April 1, and interest payments are made semi-annually on April 1, and October 1. 47 P City of Cape Girardeau, Missouri NO ITS TO FINANCIAL STATEMENTS June 30, 2001 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 2.275 000 Certificates of Participation (Twin Lakes Project) Series 1994A Year Ending Interest Principal Interest June 30 Rate Due Due Total 2002 5.200% $- $71,828 $71,828 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 3t0,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,36 $1,255 000 072 $1,645,072 t The certificates are obligations of the City of Cape Girardeau, Missouri. Under a Lease Purchase Agreement between the City and the Cape Girardeau (Missouri) Public Facilities Authority (the "Corporation'), the Corporation will assign the right to receive rental and other receipts from the City a to Union Planters Bank of Cape Girardeau County (the "Trustee"). The purpose of the 1994A Series r 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 1. reserve fund for the Series 1994A Certificates, and (3) pay the costs of issuance of the Series 1994A Certificates. s 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. r On November 7, 2000 the City transferred $1,022,500 in remaining construction funds and interest w. earnings from the original proceeds of the 1994A Series to the Dank of New YorkTrust Company, St. Louis, Missouri ("the Escrow Agent"), for deposit into an Escrow Fund established under an Escrow Trust Agreement dated November I, 2000. The proceeds were used to purchase direct obligations of, or obligations the principal of and interest on which are unconditionally guaianteed by, the United States of America. r 48 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE E - LONG-TERM OBLIGATIONS — Continued This transaction was used to decease $1,020,000 1994A Series certificates. Maturing principal of the r Escrowed Securities, together with the earnings thereon, will be used to pay the principal and applicable interest on certificates in amounts of $275,000 and $280,000 due October I, 2001 and October 1, 2002. Additionally they will be used to pay the interest on $290,000 certificates due October 1, 2003 and $175,000 certificates due October 1, 2004 and redeem the certificates at par on October 1, 2002. $ 1,705,000 Certificates of Participation (Capital Improvements Pro ects Series 1997A. Year Ending Interest Principal Interest June 30 Rate Due Due Total 2002 4.800% $ 270,000 $ 84,150 $ 354,150 2003 4.900 275,000 71,190 346,190 r 2004 4.900 285,000 57,715 342,715 2005 5.000 490,000 43,750 533,750 r 2006 5.000 505000 19,250 69,250 2007 5.000 335,000 16.750 351,750 r $1,705,000 292,805 $1,997,805 t. The certificates are obligations of the City of Cape Girardeau, Missouri under a Lease Purchase ` Agreement between the City and the Cape Girardeau (Missouri) Public Facilities Authority (the "Corporation'), the Corporation will assign the right to receive rental and other receipts from the City t to Union Planters National Bank (the "Trustee"). The purpose of the 1997A Series certificates is to (1) pay the costs of completing the construction, furnishing and equipping of a convention and recreational facility that constituted part of the 1993 project, (2) pay the costs of acquiring constructing, furnishing r and equipping various equipment and capital improvement projects, (3) fund the debt service requirements for the Series 1997A Certificates, and (4) pay the costs of issuance of the Series 1997A Certificates. The bond liability for the Series 1997A Certificates is recorded in the General Long -Tenn Debt Account Group, Data Processing and the Equipment Replacement Fund. Principal payments are made annually on April I, and interest payments are made semi-annually on April I and October I. " 49 r City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE E - LONG-TERM OBLIGATIONS - Continued ti $ 455,000 Certificates of Participation (Capital Improvements Projects) Series 19976. i Year Ending Interest Principal Interest June 30 Rate Due Due Total r 2002 4.900% $ 80,000 $ 22,670 $ 102,670 2003 5.000 85,000 18,750 103,750 ' 2004 5.000 85,000 14,500 99,500 2005 5.000 205,000 10 250 215.250 $455,000 _$06 1170 $521,170 The certificates are obligations of the City of Cape Girardeau, Missouri under a Lease Purchase Agreement between the City and the Cape Girardeau (Missouri) Public Facilities Authority (the t "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 1997B Series certificates is to (1) defease $755,000 outstanding principal amount of Cape Girardeau (Missouri) Public Facilities n Authority, Building and Equipment Leasehold Revenue Bonds (Airport Improvement Project) Series ti 1990B, and (2) pay the costs of issuance of the Series 19978 Certificates. t. The bond liability for the Series 1997B Certificates is recorded in the General Long -Term Debt Account r Group. Principal payments are made annually on April 1, and interest payments are made semi-annually on April 1 and October 1. 50 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE E - LONG-TERM OBLIGATIONS - Continued 'Phe annual requirements to amortize all debt outstanding as of June 30, 2001 including total interest payments of $43,531,490 are as follows: General Leasehold Certificates Year Ending Obligation Revenue Revenue of June 30 Bonds Bonds Bonds Participation Total 2002 $463,555 $5,964,971 $873,982 $1,033,236 $8,335,744 2003 458,875 6,063,992 540,482 1,061,356 8,124,705 2004 458,125 6,189,152 286,283 1,085,881 8,019,441 2005 461,250 6,309,097 1,062,683 1,658,058 9,491,088 2006 - 6,478,579 39,050 435,382 6,953,011 2007 - 6,539,800 39,600 981,875 7,561,275 2008 - 6,742,043 40,050 80,845 6,862,938 2009 - 6,832,138 39,400 76,768 6,948,306 2010 - 6,445,301 39,700 82,360 6,567,361 2011 - 5,736,201 39,900 - 5,776,101 2012 - 6,866,397 - - 6,866,397 2013 - 4,440,017 - - 4,440,017 2014 - 5,376,906 - - 5,376,906 2015 - 5,136,696 - - 5,136,696 2016 - 5,026,875 - - 5,026,875 2017 - 4,960,195 - - 4,960,195 2018 - 3,931,440 - - 3,931,440 2019 - 1,021,935 - - 1.021.935 $1841805 $100,461.735 53.001.130 X4,495,761 $111400.431 The cash and investments available to service Revenue Bonds are $4,735,527 and $1,147,378 for the Sewer Fund and Water Fund respectively. 51 t °i City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE E - LONG-TERM OBLIGATIONS - Continued The cash and investments available to service the Leasehold Revenue Bonds in the Enterprise Funds r and the General Long -tern Debt Account Group are $299,289 and $721,616 respectively. r The cash and investments available to service the Certificates of Participation in the Proprietary Funds and the General Long-term Debt Account Group are $415,615 and $937,632 respectively. Included in restricted cash on the balance sheet of the Proprietary Funds is $9,259,338 which is the balance in the various project accounts which represent incomplete projects at June 30, 2001. If the r project funds are not used, the remaining balance can be applied against debt. The City is in compliance with all significant limitations and restrictions contained in the various bond indentures. " During the fiscal year ended June 30, 1996, the City dcfcased (in -substance) $8,090,000 of Water Revenue Bonds. New debt was issued and the proceeds were used to purchase U.S. government r. securities that were placed in trust funds. The investments and fixed earnings from the investments are sufficient to fully service the defeased debt until the debt is called at par on March 1, 2002. For financial reporting purposes, the debt has been considered dcfcased and therefore removed as a liability on the face of the balance sheets NOTE F— PRIOR PERIOD ADJUSTMENT Beginning fund balance increased and other liabilities decreased $88,772 in the general fund. This resulted from the recognition of unspent donation and grant revenue that had been deferred in previous years by being recorded as a liability in error. 52 City of Cape Girardeau, Missouri _ NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE G - DEFICIT FUND BALANCES/RETAINED EARNINGS The following individual funds have deficit fund balances/retained earnings at June 30, 2001. r r Enterprise Funds Golf Course Fund S 63,824 i. Softball Complex Fund 181,809 NOTE 11 - PENSION PLAN 1. _Plan Description The City of Cape Girardeau participates to the Missouri Local Government Employees Retirement System (LAGERS), an agent multiple -employer public employee retirement system that acts as a common investment and administrative agent for local government entities in Missouri. LAGERS is a defined benefit pension plan which provides retirement, disability, and death benefits to plan members and beneficiaries. LAGERS was created and is governed by statute, Section RSMo. 70.600 - 70.755. As such, it is the system's responsibility to administer the law in accordance with the expressed intent of the General Assembly. The plan is qualified under the Internal Revenue Code Section 401A and it p is tax exempt. r The Missouri Local Government Employees Retirement System issues a publicly available financial ` report that includes financial statements and required supplementary information. That report may be obtained by writing to LAGERS, PO Box 1665, Jefferson City, MO 65102 or by calling 1-800-447- 4334. 2. Fundine Policy �. The City of Cape Girardeau's full-time employees do not contribute to the pension plan. The political subdivision is required by state statute to contribute at an actuarially determined rate; the current rate is 10% (general), 10.3% (police) and 17.7% (fire) of annual covered payroll. The contribution r requirements ofplan members are determined by the governing body of the political subdivision. The contribution provisions of the political subdivision are established by state statute. 53 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE H - PENSION PLAN - Continued i 3. Annual Pension Cost r For 2001, the political subdivision's annual pension cost of S 1,207,517 was equal to the required and actual contributions. The required contribution was determined as part of the February 28, 1999 and/or r 2000 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, before retirement and 4.0% per year, compounded annually, after retirement, (b) projected salary increases of 4.0% per year, compounded annually, attributable to inflation, (e) W additional projected salary increases ranging from 0.0% to 4.2% per year, depending on age, attributable to seniority/merit, and (d) pre -and post-retirement mortality based on the 1984 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 29, 2001 was 15 years. t Threc-Year Trend Information r Fiscal Annual Percentage Net Year Pension Of APC Pension Endine Cost (APC) Contributed Oblieation 06/30/99 935,802 100% 0 F 06/30/00 924,313 100% 0 W 06/30/01 1,207,517 100% 0 54 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 29, 2001 annual actuarial valuations. NOTE I - INTEREST EXPENSE Interest cost, including handling charges, totaling $3,295,389 excluding $203,984 of interfund interest, was incurred during the year ended June 30, 2001. No interest cost was capitalized as part of the cost of assets constructed during the period. 55 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE H - PENSION PLAN - Continued 3. Annual Pension Cost — Continued Required Supplementary Information Schedule of Fundine Proeress (a) (b) (b -a) (a/b) (c) (b-a)/c) Entry Age Unfunded UAL as a Actuarial Actuarial Actuarial Accrued Annual Percentage of Valuation Value Accrued Liability Funded Covered Covered Date of Assets Liability UAL Ratio Payroll Payroll 02/28/99 $17,502,029 $16,952,486 (S549,543) 114% $9,497,630 ( 6%) 02/28/00 20,882,363 18,314,435 (2,567,928) 133% 10,314,954 ( 25%) 02/29/01 22,858,664 20,495,003 (2,363,661) 112% 10,616,623 ( 22%) 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 29, 2001 annual actuarial valuations. NOTE I - INTEREST EXPENSE Interest cost, including handling charges, totaling $3,295,389 excluding $203,984 of interfund interest, was incurred during the year ended June 30, 2001. No interest cost was capitalized as part of the cost of assets constructed during the period. 55 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE J - INTERFUND RECEIVABLES AND PAYABLES The following is a summary of interfund balances as of June 30, 2001: Advance to/from other funds: Advances frmn Advanee, to General Fmnd $ 1,667,500 $ - Sewer Fund - 337,500 Solid Waste Fund - 750,000 Golf Coursc Fund - 390,11110 Sotiball Complex Fund - 190,000 $ 667 500 _ S1,607,50 NOTE K - SEGMENT INFORMATION FOR ENTERPRISE FUNDS The City maintains five enterprise funds which provide sewer, water, solid waste, golf, and softball complex services. Segment information for the year ended June 30, 2001 was as follows: Bonds and Other Long -Tenn Liabilities Payable Com Operating Revenues 40,780,189 10,447,532 265,000 - - 51,492,721 '1oml Fquity $20,298,677 $19,948,142 $ 419,585 $ (63,179) $ (127,120) $40,476,105 56 Softball Sewer Water solid Waste GalfCmrxe Complex fetal Fund Fund Fund Fund fund h Operating revenues $2,521,406 $4,505,291 $2,261,653 .$ 508,815 $ 130,731 $9,927,896 Depreciation 1,267,885 517,541 156,574 58,007 16,008 2,016,015 Operating Income (Lass) (1118,287) 771,651 171,709 (26,575) (240,473) 568,025 Operating transfers in 1,644,483 - - 23,000 242,325 1,909,808 Net Inconre(Los,) 1,187,877 306,039 196,977 (18,049) (5,999) 1,666,845 Current Capital Contrihitlons 1,059,004 10,210,062 8,505 - 51,563 11,329,134 Property, Plant and Fquilaent Additions 5,627,736 10,027,002 235,793 19,599 77,943 15,988,073 DelGicns (127,319) (56,058) (349,997) (41,811) (2,267) (577,452) Net Working Capital 12,221,169 2,389,866 35,684 (366,218) (191,696) 14,088,805 Total Assets 62,660,166 30,901,064 1,796,126 360,518 98,654 95,816,528 Bonds and Other Long -Tenn Liabilities Payable Com Operating Revenues 40,780,189 10,447,532 265,000 - - 51,492,721 '1oml Fquity $20,298,677 $19,948,142 $ 419,585 $ (63,179) $ (127,120) $40,476,105 56 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE L - RESERVATION OF FUND EQUITY Reserved for anagu,cy fund At June 30, 2001, the City had reserved its fund equity as follows: 69,397 GereralFund Re,crvod for energency fund S 3,121154 Poacrved for ,,and flan, 74,459 Reserved fnr advance 1,667,500 Reserved for mausoleum mint r ance 75,988 Reserved far awwnbrcn e, 29,584 S _.. 4.968_885 Special Revenue Fund, Cunventiar✓Vi,uu, Fund Reserved for anagu,cy fund b` 69,397 Reserved for prepaid inom 3,134 Reser d for efartubroar,, 16,700 Reserved for River Campos 266,9W Airpnn Reserved! fnr prepaid inarrs I0,463 Reserved fnr cneumhanct, ](1343 Parks and Recreut- Fund Rexerved for prcpafd innm 2,239 Racrved for eneumbronci7 650 Health RCYurmxl for emageney fund 38,128 Reserved fur preµrjd oan, 219 Reserved far eneambmnceu 2,262 Morar Fuel Tax Reserved for rneumbmnces 3,625 Caulil lmpmvanan Sri, T.. (A au,P lee") Rcscrvcd ffund 237,723 Capital Inlprovanalt Sales I ax (Flood Control) Reserved for enrunrhranecs 35.998 Capital Impmvunuu Sales'1 ix ( Snwa Pr..mts) Referred for emergency and 300.866 Travu,na im Sams Tax frust Fund Reserved for enemnhmnces 2,503,016 Tmnspuralnan Sales'1'ax I m,t Fund 11 Reserved! r encumhnmce, .12,681 s 3.571.293 Debt Service Fund Reserved far dent savfce $ 2,199,337 Rmcrred for emagcnuy fund 295,617 s__ 2,473,954 Capitol Projects Funds General Capital hnpmvenent Fund R-erved for avmmbmnees 15,444 Sncct lmpmvcmcnts Re,aucd fur encumbmncu 1,451 CommunityD—rik em Rlork Gnat bund Rweavvdlor cconoinic devclupeat loan rc,pavancir,a 106,949 RcycrvcdI rcnannbmnccn 533,425 Pd. hola oro R,,,a Idfor enannhmnus 47,129 Croy Fkra! Control R,,af rad 1'or enc ambtan¢s 662 water Pmje<I' 14md Kescrvad fnr or aria _ 7.61)0,80 1 57 i ` City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE M - RESERVED RETAINED EARNINGS AND RESTRICTED ASSET ACCOUNTS As of June 30, 2001, the reserved portion of retained earnings for the Enterprise Funds are as follows: Sewer Fund r Reserved for debt service $ 36,667 Water Fund ` Reserved for emergency fund 580,000 Reserved for debt service 150,000 F Solid Waste Fund r.. Reserved for emergency fund 329,86 Total reserved retained earnings $1,096.53 r At June 30, 2001, the City has restricted assets in its Proprietary Funds as follows: W-59337 $6,617,087 $15,876,424 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. 'Phe estimated total future liability for landfill postclosure care costs is $207,000 as of June 30, 2001, 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, 2001. However, the actual cost of closure and postclosure care may be higher due to inflation, changes in technology, m changes in landfill laws and regulations. The City of Cape Girardeau has used the option of a Contract of Obligation as the financial assurance inshumcnt for the landfill. The City issued bonds in October 1994 horn which the proceeds have been used to pay the closure costs. 58 Revenue Bond Bond Sinking and Construction Reserve Fund Total Sewer Food $9,259,337 $5,325,555 $14,584,892 Water Ford - 1,192,096 1,192,096 Solid Waste Fund - 99,348 99,348 Data Processing - 44 44 Equipment Replacement Fund 44 44 W-59337 $6,617,087 $15,876,424 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. 'Phe estimated total future liability for landfill postclosure care costs is $207,000 as of June 30, 2001, 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, 2001. However, the actual cost of closure and postclosure care may be higher due to inflation, changes in technology, m changes in landfill laws and regulations. The City of Cape Girardeau has used the option of a Contract of Obligation as the financial assurance inshumcnt for the landfill. The City issued bonds in October 1994 horn which the proceeds have been used to pay the closure costs. 58 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE O - RISK MANAGEMENT The government is exposed to various risks of loss related to torts; theft of, damage to and destruction ofassets; 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, r 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 years premiums. i The City has established self-insurance plans for employees" health insurance and workers' compensation. Both of these are accounted for using internal service funds. Under each plan the City ` is substantially self-insured and uses an administrator to handle claims management. The City provided health coverage to its employees through a self-insured plan. Under this plan, the ` City paid Century Planners a monthly premium for claims administration. The City also purchased r. 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. Corporate Claims Management, Inc administers the City's workmen's compensation plan. Under this y, plan the City pays the administrator a per claim fee to administer it's claims. All claims are paid directly by the City. The City has purchased insurance coverage from Safely National Casualty Corp. that limits the maximum claims to $225,000 and $275,000 per regular employee and police employee respectively. r Additionally, $1,000,000 in coverage is provided for annual claims in excess of $535,000. Rates are charged by the internal service fund to the other city funds based on rates and experience factors established by the National Council on Compensation Insurance. Safety National is rated "A- 8" by A. M. Best. 59 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE O - RISK MANAGEMENT - Continued Claims liability is estimated using data supplied by the administrator. The claims activity during the last three years is summarized as follows: CLAIMS LIABILITIES RECONCILIATION Balance, July 1, 1998 Provision for Incurred Claims Payment of Claims Balance June 30, 1999 Provision for Incurred Claims Payments of Claims Balance June 30, 2000 Provision for Incurred Claims Payments of Claims Balance June 30, 2001 Health Workers' Insurance Compensation Total $ 220,000 S 388,996 $ 608,996 478,229 121,155 599,384 (698,229) (212,946) (911,175) $ - $ 297,205 S 297,205 778,268 252,105 1,030,373 (628,268 (220 6021 (848,870) 150,000 328,708 478,708 1,427,977 275,758 1,703,735 (1,452,977 (294,794 (1,747,771 &_ _ _ 125,000 $ 309,672 $ 434 672 NOTE P - CONCENTRATION OF CREDIT RISK/BAD DEBT ALLOWANCE The City has uncollateralized utility accounts receivable generated within a limited geographical region primarily consisting of its city limits. The City also has taxes, special assessments, and user fees receivable which are concentrated among its citizens. Some of these items attach as liens against real and personal property. The maximum accounting loss is the amount shown as utility charges receivable on the Combined Balance Sheet. At June 30, 2001, utility receivables totaled $2,116,069. On the financial statements, the utility receivables are shown net of the allowance for doubtful accounts of $914,525. This results in net utility receivable of $1,201,544. In the current year the allowance was increased by $125,436 or approximately 1.4% of the current year's utility charges. The total allowance represents amounts accumulated since 1985. 60 City off Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30,2001 NOTE Q - COMMITMENTS AND CONTINGENCIES 1. Litisation r 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 speci ftc purposes that are subject to review and audit by W. 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 t appropriate agency. in the opinion of City management, such disallowances, if any, will not be significant. 3. Construction Commitments W As of June 30, 2001, the City had construction commitments outstanding of$14,387,485. ` 4. Encumbrances As of June 30, 2001, the City had encumbrances outstanding of $14,615,344. 5. Environmental Remediation r City trumagement is aware of one instance of environmental contamination of City owned property. City management is actively resolving these concems_ A Plan Of Action has been approved by the Missouri r„ Department of Natural Resources CDNR") for the contamined site. In the opinion of City management, the expenses associated with environmental remediation of these and other potential sites will not be significant to the City's financial statements. r 61 r City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 2001 NOTE R - CONTRIBUTED CAPITAL The changes in the contributed capital accounts for the enterprise funds were as follows 62 Solid Gulf Softball Source, Scwcr water Waste Course o olcx Total Beginning Balance July 1, 1999 $18,160,263 $ 8,118,229 $ 288,585 645 $ 3,126 %26,570,848 Contnbuting Source. Donated .sect by dcvclapers 188,046 428,097 - - - 616,143 Connection fee 155,563 - - - - 155,563 Special AsFcsssmcna 715,395 272,503 - - - 987,898 Donated A,en, - - - - 51,563 51,563 State & Federal Grant, q,509,46 ,505 9,517,96 Ending Balance, June 30, 2001 $19,219,267 $ 18,328,291 $ 297,090 $___045 $__ _ 54,689 $i7 899982 NOTE S - EXCESS OF EXPENDITURES/EXPENSES OVER APPROPRIATIONS For the year ended June 30, 2001 expenditures/expenses exceeded appropriations in the individual funds as follows: Budget Actual Variance Parks and Recreation $1,244,027 $1,259,447 $15,420 Capital Improvement Sales Tax-WaterTrail2,389,384 2,559,384 170,000 Transportation Sales Tax Trust II - 461,266 461,266 Community Development Block Grant 487,500 671,567 184,067 Equipment Replacement 243,415 246,299 2,884 62 City of Cape Girardeau, Missouri GENERALFUND COMPARATIVE BALANCE SHEET JUNE 30, 2001 AND 2000 LIABILITIES AND FUND BALANCES Accounts payable 2001 2000 ASSETS Pooled cash and investments $1,788,143 $615,216 Receivables, net of allowances for 18,831 108,648 doubtful receivables 205 205 Real estate, personal property - 425,000 and merchant taxes 37,731 41,333 Sales tax 609,417 655,874 Franchise tax 1,258,818 1,003,447 Special assessments receivable 140,400 121,372 Interest receivable 351,912 376,367 Other receivables 25,232 6,973 Intergovernmental receivables 75,988 71,531 Grants receivable 325,814 96,649 Due from other funds - 2,177,228 Advances to other funds 1,667,500 1,667,500 Inventories 197 129 Prepaid items 74,460 67,411 Total assets $6,279,624 $6,829,499 LIABILITIES AND FUND BALANCES Accounts payable $330,493 $250,027 Accrued liabilities Salaries, payroll taxes and benefits 25,426 17,025 Other liabilities 18,831 108,648 Due to other governments 205 205 Due to other funds - 425,000 Defamed revenue 191,675 165,149 Total liabilities 566,630 966,054 Fund Balances Reserved for emergency fund 3,121,354 3,085,288 Reserved for prepaid items 74,459 67,411 Reserved for advances 1,667,500 1,667,500 Reserved for mausoleum maintenance 75,988 71,531 Reserved for police projects - - Reserved for encumbrances 29,584 42,101 Unreserved 744,109 929,614 Total fund balances 5,712,994 5,863,445 Total liabilities and fund balances $6,279,624 $6,829,499 63 City of Cape Curr ntleau, Missouri GENERAL FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2001 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE REVENUES Taxes S11807,508 $11,686703 ($120,805) Licenses and pemdts 1089,250 1,06],580 (21,670) Inlergovernmenlal 509,920 882,511 372,591 Charges lar sevlces 369,540 311,388 (58152) Interdepartmental services 658750 734,244 75,494 Fines and fodeiwms 91 690,744 (209 gal Miscellaneous 70.000 107,967 37,967 Penta nl revenue 275,000 269,114 (58861 Special assessments 8.500 10 (8490) TOTAL REVENUES 15698,468 15.750,261 61,793 EXPENDITURES Current Administrative services City wu l 27,357 15,666 11,691 Human resources 210,540 212396 (1,856) City mawger 214,791 216.982 (2,191) Public awareness 58229 55.101 3,122 City attomey 197,955 201.746 (3791) Finance 413,614 414,322 (708) InlerdepaNnental 879,6631 684,172 15,488 Total adminisoub, Samces 1802.140 1, 780 Me 21,755 Development services Planning services 339,557 349,239 (9,682) Inspection seMces 359,076 342,260 16.816 Engineer, secure, 460,462 443,291 17,171 Community and economic development 146.257 154,740 (8,490) Panic transportation 350.000 291,104 58,896 Total development services 1655.345 1.580634 74711 Para and recreation Par maintenance 915.751 904,341 11.410 Cemetery 138,233 133,009 5.224 Facility malnlenona' 159,367 156.862 2,505 Total pars and recreation 1,213,351 1,194.212 19,139 Public safety Municipal court 212530 206865 5665 Police 4,893.605 4,948,976 (55,371) Fire 3,319,030 3,319,966 (936) Hai Mitigation _ 35,000 37,487 (2.487) Total public safety 8,460,165 8,513.294 (53,129) Public wri Streel 1,651,631 1,632,370 19,261 Slomiwaler 331,134 312341 18793 Total public wer5 1,982.765 1,944 711 38 D54 Contingency 30.000 41,647 IT 1,647) Debt Service Interest and fir'harge, Total debt service TOTAL EXPENDITURES 15,054,883 88,883 _15.143,766 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 544702 695378 150.676 OTHER FINANCING SOURCES (USES) Operating transfers In 910,350 910360 - Onemonglansf,,,ran _ 11,570,059) (18490951 27,564 TOTAL OTHER FINANCING SOURCES (USES) (966,309) (938 745 27,564 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES _ ($421 L07) ($243361) $178,240 64 .-, w. iSalflL[ll CM�uWm— oe e 3f41!!11^4 NVL4 EufLIM llcei.£sWmll weu.9.aleslal P+^-01Yv91 WUIm LaL_lW i3 90JP91 4fl�12Y izv5 , nsbAY �Yi MM lea f.W.ee m., 0.9 SteesaM ley ba,e Nms ib,4n s<b nebm,.0 te.x. Se17t. ll��. Sni.mo .xis,aN 15., Iel 21 2 11 12, 34 4 )b,`A: �c V�� s}gig• m..... Q� 2 Q74 m. eu.a r...=� r-� �� .� u..�.�. �� wenins>Ax�l Uxoausnv3 SAi_ex b_s.14 L fu1R lls+ 1 Se Ost U!3. 1 S Mwys Ntl zs 21 1 a y[_m e- R) 1 "1 121 141 i. .m 211 ae s12 ae. - b:o 2.111 11 71, �.�a..a, __ W,�. ,_ �_ .11 _.. Im �..� �� m� El usEE�C�ExrnaE REVENUES eRm.E enixa:E:o.:�::�::D U. nx,xcxO USES oe.0 Riei9 '21E1 i1CS, TODi,ll] 1.7E TO 2111 TOD EI I'S 'AT 11 U1231 cw.w a. 1 U4 aicss res: Ex.E D.LAx_ES JUL`f , .ESE DnuxcES. JUNE IF T —� E..E� �� RSl _F �_ 12. 137 1 IT OUT IS Al IT, �_ .M ✓ UMMM A. "FAIL UPI RULES I covem[o UEA Ei2xo11uxee sxo -1 THE FISCAL YEAS SUN DUE Al. 11 S.1 ...ET— M —PRODUCT IMPROVEMENT IMPROVEMENT i xx TRANSPORTATION caxvV ePJSI814I ��x�9a vex si nExiiOx, pavorti gEGgE9Lgry tlF�N 0y FLOOD[ fx vrto.[ci_ rt I �TUDUALS P8PIE4L4M RISE US' cl, Ill 12Z IS 411 5 3 FAX TOUTALAREVENUES I IF 111 L1,171 1 11711 1 'A 1 SO 271 2 IIAUCAI -1 CIA 11 12 1A CEIVUESTUITA I liO, 21 SIS TO OPT "I I SET E ESIUSCIExcvTDEREVExUES m m (UNDER) Exvummrtru 11 MI 711-1 Ill_ i 4C IFE]_. OU UFF OTHER rRANTIND A— aEEI1 ICX U 711171 M.171 2. DID — 2 SOL 113 nnxnxaxc sOurtoEi IUDb,i ,yzpJ El usEE�C�ExrnaE REVENUES eRm.E enixa:E:o.:�::�::D U. nx,xcxO USES oe.0 Riei9 '21E1 i1CS, TODi,ll] 1.7E TO 2111 TOD EI I'S 'AT 11 U1231 cw.w a. 1 U4 aicss res: Ex.E D.LAx_ES JUL`f , .ESE DnuxcES. JUNE IF T —� E..E� �� RSl _F �_ 12. 137 1 IT OUT IS Al IT, �_ City of Cape Girardeau, Missouri CONVENTIONIVISITORS SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2001 REVENUES Taxes Charges for services Miscellaneous Investment revenue TOTAL REVENUES EXPENDITURES Current Administrative services TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Operating panders out TOTAL OTHER FINANCING SOURCES (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) $1,208,000 $1,213,319 $5,319 7,000 7,022 22 15.000 8,080 (6,920) 25.000 71,245 46,245 1,255.000 1,299,666 44666 438,604 328.481 110.123 438,604 328,481 110,123 816,396 971,185 154,789 (610,000) (610,000) (610.000) (610,000) $206,396 $361,185 $154,789 61 REVENUES Intergovernmental revenue Charges for services Miscellaneous Investment revenue TOTAL REVENUES EXPENDITURES Current Administrative services Debt Service Principal 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 V City of Cape Girardeau, Missouri AIRPORT SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURE! BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2001 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) $286,558 $173,717 ($112,841) 76,000 83,453 7,453 137,600 129,116 (8,484) 3.500 2,730 (770) 503,668 389,016 (114,642) 885,572 848,544 37,028 20,375 20,376 (1) 5,260 5,346 (86) 911,207 874,266 36,941 (407,549) (485,250) (77,701) 408,348 408,348 408.348 408,348 $799 ($76,902) ($77.701) Z r 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, 2001 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI REVENUES Taxes $16,300 $20,139 $3,839 Investrnenl revenue 300 1,241 941 TOTALREVENUES 16,600 21,380 4,780 EXPENDITURES Current Development seniors 37,500 9,195 28,305 TOTAL EXPENDITURES 37,500 9,195 28,305 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES __J$20,900) $12,185 $33,085 69 r V r r City of Cape Girardeau, Missouri PARKS AND RECREATION SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2001 70 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) REVENUES Changes for services $445,000 $513,944 $68,944 Miscellaneous 3,000 5,625 2,625 Investment revenue 7,500 3,932 (3568) TOTAL REVENUES 455,500 523,501 68,001 EXPENDITURES Curren) Parks and recreation 1,244,027 1,259,447 (15.420) TOTAL EXPENDITURES 1244,027 1,259,447 (15420) EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (788,527) (735,946) 52,581 OTHER FINANCING SOURCES (USES) Operating transfers in 732,671 732,671 - Operating transfers out TOTAL OTHER FINANCING SOURCES (USES) 732,671 732,671 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES __($55 856) ($3,275) $52,581 70 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, 2001 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 _j$31],566) ($114,875) $202,691 71 VARIANCE FAVORABLE BUDGET ACTUAL IUNFAVORABLEI REVENUES Taxes $223,769 $229,277 $5,508 Licenses and permits 7,500 2.088 (5,412) Intergovernmental 255,000 255.446 446 Charges for services - - - Investment revenue 29,500 41,646 12,146 TOTAL REVENUES 515.769 528,457 12,688 EXPENDITURES Current Public safety 833.335 643.332 190,003 TOTAL EXPENDITURES 833,335 643.332 190,003 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (317,566) (114,875) 202,691 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 _j$31],566) ($114,875) $202,691 71 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, 2001 72 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) REVENUES Intergovemmentai $1410,000 $1,430,237 $20,239 Investment revenue 55,000 62,877 7,877 TOTAL REVENUES 1465,000 1,493,114 28,114 EXPENDITURES Curter Publicworks TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 1,465,000 1,493,114 28,114 OTHER FINANCING SOURCES (USES) Opera0ug transfers out (1,350,000) (1,350,000) TOTAL OTHER FINANCING SOURCES (USES) (1,350,000) (1,350,000) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES $115,000 $143,114 $28,114 72 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, 2001 REVENUES Taxes Intergovernmental Investment revenue TOTAL REVENUES EXPENDITURES Current Public works TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Operating Lansfers out TOTAL OTHER FINANCING SOURCES (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) ($618,611) ___L$89 078) $529,533 73 120,000 88,590 ($31410) 10,000 46,592 36.592 130,000 135.182 5,182 748,611 224,260 524,351 748,611 224.260 524,351 (618,611) (89,078) 529,533 ($618,611) ___L$89 078) $529,533 73 City of Cape Girardeau, Missouri CAPITAL IMPROVEMENT SALES TAX SPECIAL REVENUE FUND WATER PROJECTS SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2001 REVENUES Taxes Inves"enl revenue TOTAL REVENUES EXPENDITURES Debt Service Prinapal Interest and fiscal charges TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Operating transfers In Opeating transfers out TOTAL OTHER FINANCING SOURCES (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES VARIANCE FAVORABLE BUDGET ACTUAL IUNFAVORABLEI $1,970,000 $1,882,680 ($87,320) 20,000 85.696 65,696 1,990,000 1,968,376 (21,624) 660,000 660.000 - 909,384 1.079,384 (170.000) 1,569,384 1,739,384 (170,000) 420,616 228,992 (191,624) 956.474 956,474 (820,000) (820,000) (820,000) 136,474 956,474 ($399,384) $365,466 $764,850 74 r se Y r r r V Ise f r V he 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, 2001 REVENUES Taxes Investment revenue TOTAL REVENUES 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 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) $1,970,000 $1,885,096 ($M 904) 30,000 66,840 361840 2,000,000 1,951,936 (48,0(34) 2,000,000 1,951.936 (48,064) (1,672,354) (1,644,483) 27,871 (1,672,354) (1,644,483) 27,871 $327,646 $307,453 75 ____L$20 193) 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, 2001 REVENUES Taxes Investment revenue $penal assessments TOTAL REVENUES EXPENDITURES Current Public works 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 BUDGET $2.295,000 55,000 2,935,000 5,285,000 6,654,893 6,654,893 (1,369,893) 200,000 200.000 ACTUAL $2,223,413 269,233 26,846 2,519,492 4.985.633 4,985,633 (2,466,141) 200,000 200,000 VARIANCE FAVORABLE UNFAVORABLE ($]1,58]) 214,233 (2,900.154) (2,765,508) 1,669.260 1.669.260 (1,096,248) ($1 169893) ($2,266,141) ($1.096,248) 76 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, 2001 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES - 981,264 981,264 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 $- $981,264 $981,264 77 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI REVENUES Taxes $- $1,431,339 $1,431,339 Investment revenue - 11,191 11,191 Special assessments - - - Miscellaneous TOTAL REVENUES 1,442,530 1,442,530 EXPENDITURES Current Public works 461,266 (461,266) TOTAL EXPENDITURES 461,266 (461,266) EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES - 981,264 981,264 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 $- $981,264 $981,264 77 r 78 City of Cape Girardeau, Missouri r FLOOD PROTECTION SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS FOR THE FISCAL YEAR ENDED June 00, 2001 r f VARIANCE L FAVORABLE BUDGET ACTUAL (UNFAVORABLE r REVENUES Investment revenue $- $28 $28 r TOTAL REVENUES 28 28 p EXPENDITURES Current V Administrative services r TOTAL EXPENDITURES r EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES $- $28 $28 r r r 78 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, 2001 79 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI REVENUES Miscellaneous $- $17,451 $17,451 Investment revenue 122 122 TOTAL REVENUES - 17,573 17,573 EXPENDITURES Current Development services 25,000 24,038 962 TOTAL EXPENDITURES 25,000 24,038 962 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (25,000) (6,465) 18,535 OTHER FINANCING SOURCES (USES) Operating transfers in 7,500 7,500 - TOTAL OTHER FINANCING SOURCES (USES) 7,500 7,500 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES __JS17,500) $1,035 $18,535 79 City of Cape Girardeau, Missouri DEBT SERVICE FUND COMPARATIVE BALANCE SHEET JUNE 30, 2001 AND 2000 LIABILITIES AND FUND BALANCES Accounts payable 2001 2000 ASSETS 285 285 Pooled cash and investments $997,480 $988,048 Non -pooled cash and cash equivilents 1,001,552 109,945 Non -pooled investments 459,487 1,310,338 Receivables, net of allowances for 2,198,337 2,186,138 doubtful receivables 275,617 264,966 Real estate, personal property and merchant taxes 12,591 13,632 Special assessments receivable 390,250 438,031 Interest receivable 13,091 38,727 Other receivable 260 260 Total assets $2,874,711 $2,898,981 LIABILITIES AND FUND BALANCES Accounts payable $ - $ - Interest payable 285 285 Deferred revenue 400,472 447,592 Total liabilities 400,757 447,877 Fund Balances Reserved for debt service 2,198,337 2,186,138 Reserved for emergency fund 275,617 264,966 Unreserved Total fund balances 2,473,954 2,451,104 Total liabilities and fund balances $2,874,711 $2,898,981 Em City of Cape Girardeau, Missouri CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET June 30, 2001 (With Comparative Toole for June 30, 2000) General Corp Capital Flood Street FAU Street CDBG Park Water Totals Improve en[ Control ImorovemenU Grants Grant Improvements Proects 01630101 06130100 ASSETS Pooled cash and ovestmerts $274,080 $760,586 $567,630 $264,488 $418,436 $141,932 $3,616,722 $6,043,874 4,655,333 Nonpooledcash and cash equivelenis - - - - 5,709 72.132 13,005.850 13,083,691 22.104451 Nonyooled Investments - 154,263 - - - - - 154,263 140.682 Grafts receivable - 68,114 - 10],185 94,373 - - 269,672 172,068 Special assessments receivable - - 35,]32 - - - 35,732 9,317 Y.terest receivable _ 674 - _ - - - 674 569 Other receivable - - - - - - - - 18,115 Notes receivable Total assets 5274.080 5983,637 $503,362 $3]1.6]3 $518,518 $214,064 $16622,572 $19,587906 $27,100,555 o}IABILITIES AND FUND BALANCES Accounts payable $- $110 $- $- $78,819 550,043 5907,834 $1,036,806 $838739 Other liabilities - - - _ - - 66,918 66,918 2,388 Due to other governments 2707 - - 2707 2707 Due to other funds _ _ _ __ - - 45227 Deferred revenue - 35.732 357732 9,317 Total liabilities - 110 35,732 81,526 50,043 9]4,]52 1,142,163 898,378 Fund balances Reserved far debt service - - -- Reserved for bond capita expenditures - - - - -_ - - Reserved for economic dev lode repymnts - - - - 106.949 - - 106,949 100,677 Reserved for encumbrances 15.444 662 1,451 - 533425 4],129 ],690,801 87268,912 14,050554 Unreserved 258,636 982,865 566.179 3]1,6]320( 3,382) 116,892 ],95],019 10,049,882 12,050.946 Total fund balances 274,060 983,527 567,630 371,6]3 436,992 164,021 15,647,820 18445,743 26202.17] Total liabilities and fund balances $274,080 $983,637 $603,362 5371673 $518,518 $214,064 $16,622.572 $19,587,908 $2],100.555 F r_ r_e r T r ►- r r- r- r r- r_ r_ r. r- r - REVENUES Intergovernmen'al Investment revenue Seep, essessments TOTAL REVENUES EXPENDITURES Cap tai outlay Debt service Interest and fiscal afar,,, TOTAL EXPENDITURES 0 N EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Operating transfers in Operating I1 nsfers wi Bond proceed, 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 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, 2001 GENERAL CORP FAU CAPITAL FLOOD STREET STREET CDBG PARK WATER TOTALS IMPROVEMENT CONTROL IMPROVEMENTS GRANT GRANT IMPROVEMENTS PROJECTS 2000-2001 3- $6.584 $- $11,746 $372538 $- $ $390868 17,770 69491 19.530 18.058 22,046 10,788 951,760 1,109,423 337 337 17,770 76,055 19,867 29,804 394,584 10788 951,760 1,500628 - 615,508 108053 3774 170,679 127838 8.407,927 9433779 4.246 4.246 615,508 108053 3,774 174,925 127,836 8407.927 9,438.025 17,770 (539,453) 88,186 26,030 219.659 (117,050) (7.456,167) (7,937.397) - - 300.000 - 17,436 36,650 820,000 1,174.286 - - - (36,650) (956.474) (993.324) - 300,000 - 17,436 (136474) 180,962 17,770 (530,453) 211,614 26,030 237,095 (117,050) (7,592,641) (7,758.435) 256,310 1522980 355,816 345.643 199,897 281,071 23240461 26,202,178 $274,080 $963,527 5567,630 $371,673 $436,992 $164,021 $15,647,820 518445743 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, 2001 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI REVENUES Investment revenue $7,500 $16,059 $8,559 TOTAL REVENUES 7,500 16,059 8,559 EXPENDITURES Capital outlay 167,750 - 167,750 TOTAL EXPENDITURES _167,750 167,750 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (160,250) 16,059 176,309 OTHER FINANCING SOURCES (USES) Bond proceeds - TOTAL OTHER FINANCING SOURCES (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($160,250) $16,059 $176,309 83 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, 2001 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (1,055,000) (533.849) 521,151 OTHER FINANCING SOURCES (USES) Operating transfers in TOTAL OTHER FINANCING SOURCES (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES _ ($1,055.000)($533,649) $521,151 84 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) REVENUES Intergovernmental revenue $- $6,584 $6.584 Investment revenue 45,000 67,037 22,037 TOTAL REVENUES 45,000 73,621 28,621 EXPENDITURES Capital outlay 1,100.000 607,470 492,530 TOTAL EXPENDITURES 1,100,000 607,470 492,530 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (1,055,000) (533.849) 521,151 OTHER FINANCING SOURCES (USES) Operating transfers in TOTAL OTHER FINANCING SOURCES (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES _ ($1,055.000)($533,649) $521,151 84 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, 2001 85 VARIANCE FAVORABLE BUDGET ACTUAL UNFAVORABLEI REVENUES Intergovernmental $343.000 $- ($343.000) Investment revenue 10,000 17.598 7.598 Special assessments 5,000 337 (4,663) TOTAL REVENUES 358,000 17,935 (340.065) EXPENDITURES Capital outlay 983.800 107,890 875.910 TOTAL EXPENDITURES _ 983,800 107,890 875,910 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (625,800) (89,955) 535,845 OTHER FINANCING SOURCES (USES) Operating transfers in 300,000 300,000 TOTAL OTHER FINANCING SOURCES (USES) 300.000 300,000 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($325.800) $210,045 $535.645 85 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, 2001 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) REVENUES Intergovernmental $237,600 $11,746 ($225,854) Investment revenue 51000 15,702 10,702 TOTAL REVENUES 242,600 27,448 (215,152) EXPENDITURES Capital outlay 316,800 (3,915) 320,715 TOTAL EXPENDITURES 316,800 (3,915) 320,715 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (74,200) 31,363 105,563 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 __S74 200) $31,363 $105,563 86 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, 2001 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI REVENUES Intergovernmental $442,500 $372,538 ($69,962) Investment revenue 10,000 19,785 9.785 TOTALREVENUES 452,500 392,323 (60,177) EXPENDITURES Capital outlay 487,500 667,321 (179,621) Debt service Interest and fiscal charges 4,246 (4,246) TOTAL EXPENDITURES 487,500 671,567 (184,067) EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (35,000) (279244) (244,244) OTHER FINANCING SOURCES (USES) Operating transfers in 45,000 17,436 (27,564) TOTAL OTHER FINANCING SOURCES (USES) 45,000 17,436 (27,564) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES $10,000 ($261,808) ____L$271 808) 87 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, 2001 OTHER FINANCING SOURCES (USES) Operating transfers In 36,850 36,850 Operating transfers out (36,850) (36,850) TOTAL OTHER FINANCING SOURCES (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($237,500)($163,085) $74,415 In VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) REVENUES Investment revenue $],500 $8,940 $1,440 TOTAL REVENUES 7,500 8,940 1,440 EXPENDITURES Capital outlay 245,000 172,025 72,975 TOTAL EXPENDITURES 245,000 172,025 72,975 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (237,500) (163,085) 74,415 OTHER FINANCING SOURCES (USES) Operating transfers In 36,850 36,850 Operating transfers out (36,850) (36,850) TOTAL OTHER FINANCING SOURCES (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($237,500)($163,085) $74,415 In 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, 2001 REVENUES Interest TOTAL REVENUES EXPENDITURES Capital outlay Debt service 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 TOTAL OTHER FINANCING SOURCES (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES PROJECT PRIOR CURRENT TOTAL BUDGET YEARS YEAR TO DATE $- $9,268,360 ($1,312,699) $7,955,461 89 $- $1,777,798 $944,920 $2,722,718 1,777,798 944,920 2,722,718 26,500,000 20,786,643 2,121,345 22,907,988 46,828 46,828 26,500,000 20,833,471 2,121,345 22,954,816 (26,500,000) (19,055,673) (1,176,425) (20,232,098) 1,300,000 4,407,692 820,000 5,227,692 25,200,000 (1,198,722) (956,474) (2,155,196) 25,115,063 25,115,063 26,500,000 28,324,033 (136,474) 28,187,559 $- $9,268,360 ($1,312,699) $7,955,461 89 City of Cape Guides , Missouri ENTERPRISE FUNDS COMBINING BALANCE SHEET June 30, 2001 r. (With Comparative Totals for June 30, 2000) Solid Golf Softball Totals Sewer Water Waste Course Comets 06130/01 06130100 r ASSETS Poseed cash and Investments $89,328 $1,0]0,495 $590,501 553334 $33,698 $1,837,3% ` Non punded crash is rash equivalents 54,425 - - - 54,425 Utility charges receivable lnet de allowance for doubtful recovablos) 324,933 668,722 207,889 - - 1,201,566 Specal assessments receivable 466,901 160,654 - - - 627,555 Interest receivable 65,495 16.542 1,590 - - 83.627 y Other receivables 5,590 21,290 311,793 335 - 58.008 Grant receivables 34,998 - - - - 34,998 Inventions - 137.356 3,357 - 140,713 - Reenact assets Non pointed cash and barn cnuivaars, 180,162 - - - - 180,162 t� Non Ponled investments 13,864 35,[ 63,381 16,329 - - 13,944,064 Pooled rash and Investments 540,376 1,128.715 83,019 - 1752.110 Prepaid items 533,510 143.101 10,104 453 380 687,548 Y -' 16,160,072 3,410,256 940,225 57,479 34,078 20,602,110 ` Property, plant and equipment P Land 135,869 112,240 248.109 Buildings 18.179.738 202,851 810,770 53.802 7.720 9,254,881 y Improvements other buildings 39,626,486 15552665 215,450 375.356 33,050 55,803007 Equipment 1,393972 1206916 1,489738 446,727 170,989 4,700362 ConswNon In progress 11,617,616 13,787,500 25,405.118 S fi0,953.683 30749,932 2,628 198 875.885 211>59 95.419657 r Less accumulated depreciation 14,953,589 3259,124 1]72.297 572.846 147.183 20205039 46500094 2]490,808 __855,901 303,039 64.576 75,214418 Total assets 552 as)165 $30901064 $1796,126 $360,518 $98654 $95,816,528 r LIABILITIES AND FUND EQUITY Accounts payable $749,261 $152,109 $62,400 $12,866 $21,609 $998,265 Accoted liabilities Salaries, payroll taxes and benefits 44,169 509 27.749 18,971 14.165 105,643 Notes Payable - - 6.382 - 6,382 y Inlercit payable 246,507 197.736 3.804 - - 448,427 Other liablWies 203,404 126,783 54.206 1,840 - 386,313 Due To Fiber a., e Due to other governments - 28,173 - - - 28,173 Advance from other funds 337,500 - 750000 390500 190,000 1,661 Current potion of long ten, debt 2,357,602 515 000 - - - 2,872,W2 Lon9'term debt net of moms portion Revenue bons peyablo 37,651,126 9,547,532 - - - 47 198.658 f Leasehold re venue bonds Ca,able 165,460 - - - 166.460 of panldpatlon 605,000 385,000 265.000 - 1255,000 le, Crushed Deferred revenues - - - Estimated lend011 closure and post closure p rare cost liabiflry - 207,000 - 207,000 y Total liabilities 42,361489 10,952922 1376,541 423.697 225774 55,340423 Fund equity Contributed capital 19,219,267 18,328,291 297,090 6d5 54,689 37,899982 P Retained earnings r Resurved for debt service 36,667 150,000 - - - 186,667 Reserved for emerl lurid - 560,000 329869 909,669 Unmsavcd 1,042,743 889851 (r07 37u) (63 824)181 1809) 1479.667 F Total fund equity 20298677 19940.142 419.685 (63 iJ_121 71201 40476105 ase t Total liabilities and fund equity $62660166 $80,901 Tho $1,796,126 ¢164518 $96654 595816528 las 90 ase $2,646,389 123.683 282,165 59,300 111,769 R.852 17?596 10,712,354 1,704.106 637.363 1],416,141 240.109 9,242910 54,737,198 4639,080 11.141.534 80,008,831 18,659,886 61,338945 $78.755586 $689,543 104,621 14,314 383,908 324.987 2.132.001 1,887 1,667,500 475 383 40,473,065 428.955 2.275,000 288.050 51,259,244 26 570 847 186,667 1,150,000 (411,672) 27495842 -$78755,086 City of Cape Girardeau, Missouri r ENTERPRISE FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS FOR THE FISCAL YEAR ENDED June 30, 2001 si r SOLID GOLF SOFTBALL TOTALS r SEWER WATER WASTE COURSE COMPLEX 2000-2001 OPERATING REVENUES r Residential charges $14]8,1]9 $ 2,603,753 $ 1,695,938 $- $- $5,]]],8]0 r Commercial charges 961,959 1,]33,3]9 23,661 - - 2,718,999 Transfer station charges - - 495.154 - - 495,154 Equipment sales - - - 8,073 9,902 1],9]5 ! Concession revenues - - - ]8,10] 59,856 137,963 Golf course fees - - - 416,401 - 416,401 le" Softball complex fees - - - - 60,]]0 60,]]0 Other fees and charges 38,858 13],842 34,475 - - 211,175 Other miscellaneous 42410 30,317 12,425 6,234 203 91,589 y, TOTAL OPERATING REVENUES 2,521406 4,505,291 2,261,653 508,815 130,731 9,927,896 OPERATING EXPENSES Personnel services 896,346 112,8]4 993,462 261,343 219,856 2,483,881 Materials and supplies 224,257 328,850 76,302 78,011 50,163 ]5),583 r Contractual services 99,106 2,554,091 672,549 19,892 8,794 3.354.432 General operating expenses 46,368 162,686 50,127 49,373 43,650 352,204 Special prolacis expense 25.290 2,785 (3,686) 8439 9,883 42,711 Internal service expenses 70.441 54,813 144,616 60,325 22,850 353,045 r Depreciation expense 1,26],885 517,541 156,574 58,007 16,008 2,018015 TOTAL OPERATING EXPENSES 2,629.693 3,733.640 2,089,944 535,390 371204 9,359,871 r r OPERATING INCOME (LOSS) (108,287) ]]1,651 1]1,]119 (28575) (240473) 568.025 e NON-0PERATING REVENUE(EXPENSES) Investment revenue ]58,]49 221,608 47,011 2,577 2230 1,032,241 State grants - - 29,546 - - 29,546 Federal grants 161,748 - - - - 161,]48 a Gain on sale of assets 475 3,505 10,435 4,595 275 19285 Loss on sale of assets (119) (1,003) (1,122) y Compensation for damages - - 1,656 - - 1,656 Issuance cost amorliution (78.182) (23,212) (2,074) - - (103,468) Interest and handling costs (1,190,990) (861513) (60,369) (21,646) (10356) (1,950,874) TOTAL NON-OPERATING REVENUE (EXPENSES) (348,319) (465,612) 25,268 (14,4]4 (7851) (810,988) INCOME (LOSS) BEFORE OPERATING TRANSFERS (456,606) 306,039 196,917 (41,049) (248,324) (242963) r Operating touchers in 1644,483 23,000 242,325 1909,808 NET INCOME (LOSS) 1,187,877 306,039 196,977 (18,049) (5,999) 1666,845 RETAINED EARNINGS (DEFICIT), JULY (108 467) 1313,812 (58760) (45,71b) (175,610) 925,000 ' RESIDUAL EQUITY TRANSFER(NOTE) (15,122) (15,722) RETAINED EARNINGS(DEFICIT), ass JUNE 30 $1,079,410 $1619,851 $122,495 ($63,824) ($181809) $2576,123 si r City of Calx Girardeau, Missouri ENTERPRISE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE FISCAL YEAR ENDED June 30, 2001 92 Solid Golf Softball Totals Sewer Water Waste Course Complex 20008001 Cash flows from operating activities Operating Income (loss) 5 (108,288) S 771,651 $ 1]1,]09 $ (26,575) 8 (240,473) 5 568,024 Adjustments to reconcile net Income to net cash provided by operating activities Depreciation 1,267,805 54,541 156,574 58,007 16,008 2,016,015 Cash operating grants received 161.748 - 29,546 - - 191,294 Deferredieventme - 272,503 - - 272,503 Change in assets and liabilities (Increase) Decrease In accounts receivable (398,873) (123,093) 29,401 (302) - 93,667) (4 93,667) (increase) Decrease In Inventory - (32,800) (]28) - (increase) Decrease In prepaid expenses (92,711) 22,083 1,588 50 (91) (69,081) Increase (Decrease) In accounts payable 562,043 (53,05fi) (191,360) (12,7A) 3,873 308,723 Increase, (Decrease) In accrued liabilities (1,922,297) (101.612) 39,518 1,139 4,325 (1,978,927) Increase (Decrease) In IantKll poetclosere are costs (81,000) (81,000) Net cash provided by operating activities (530,493) 1,272,417 155,976 19,216 (216,358) 700,756 Cash flows from mencaplial financing activities Opaeting transfers from other funds 1,644,483 - - 23,000 242,325 1,909,808 Operating families to other funds Net cash used by noncaplal financing activities 1,644,483 - - 23,000 242,325 11909,008 Cash flows from ce fial and related financing Proceeds from developers 1,059,004 - - - - 1,059,004 Pmcceds from issuance of bonds 9,219,185 - - - - 9,219,185 Principal Paid on revenue bonds (110,000) (455,000) - - - (565,000) Principal paid on lease purchase bonds (311,491) - - - - (311,491) Principal pato on COP (820,000) (300,000) (160,000) - - (1,200,000) Principal Paid on SRF (1,280,070) - - - (1,280,070) Prinelpal Paid on energy loan 6 notes payable on land - (7,932) - - (7,932) Interest paid on bonds and obligations (1,190,990) (620,037) (60,369) (21,646h (10,356) (1,903,398) Purchase of gxetl assets (S,627,736) (89,443) (236,136) (19,598) (7,325) (5,980,238) Proceeds from sale of assets 119 3,505 77,589 4,595 274 86,082 CampensMion for damages 1,656 1,656 Net cash used by capital and related financing activities 938,021 (1,460,975) (385,192) (36,649) (17,407) (962,202) Cash flows from Investing activities Purchase of Inaestrnents (427,338) - (164,749) (592,007) Proceeds from sale of Investments 419,151 - 176,430 - - 595,581 Interest on Investments 618,058 61,469 - - 680,327 Oveml9htInterest 79,687 62,263 47,411 2,577 2,230 194,168 Interest on assessments 27.23 7,341 - - 34,634 NET CASH PROVIDED BY (USED IN) INVESTING ACTIVITIES 79,651 131.073 591092 2,577 2,230 912,623 NET INCREASE (DECREASE) IN CASH AND CASH EQUIVALENTS 2,769,662 (57,485) (170,124) 8,142 10,790 2,560,985 Cash and cash equivalents at beginning of year 11,418607 1,191361 776,954 45,192 22,908 13455022 Cash and cash equivalents at end of year $ 514,108,269 6 1,133,876 $ 606,83D $53334 S 33.698 516,016,007 92 V City of Cape Girardeau, Missouri SEWERFUND SCHEDULE OF REVENUES AND EXPENSES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2001 W VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) OPERATING REVENUES Residential charges $1,458,000 $1,498,409 $40,409 Commercial charges 998,000 959,587 (38,413) Other fees and charges 38,000 38,858 858 Other miscellaneous 35,000 42,410 7,410 TOTAL OPERATING REVENUES 2,529,000 2.539,264 10,264 OPERATING EXPENSES Personnel Services 900,109 896,346 3,763 Matenals and supplies 246,545 224,131 22,414 Contractual services 135,644 111,711 23,933 General operating expenses 31,335 46,368 (15,033) Spedal projects expense 35,500 22,000 13,500 Internal service expense 89,418 70,441 18,977 Capital outlay 13,590,700 2,988,015 10,602,685 TOTAL OPERATING EXPENSES 15,029,251 4,359,012 10,670,239 OPERATING INCOME (LOSS) (12,500,251) (1,819,748) 10,680,503 NON-OPERATING REVENUE (EXPENSES) Investment revenue 53,000 667,886 614,886 State grants 141.945 - (141,945) Federal grants - 161,748 161,748 Wiped fees 150,000 155,563 5.563 Compensation for damages - - - Gain on sale of assets - 475 475 Sewer assessments 7,000 307,794 300,794 Bond proceeds 8.250,000 8,413,618 163,618 Bondisspance costs - (150,369) (150,369) Principal payments (2,288,590) (2,288,592) (2) Interest and handling rusts (607,805) (1,138,384) (530,579) TOTAL NON-OPERATING REVENUE (EXPENSES) 5,705,550 6,129,739 424,189 INCOME (LOSS) BEFORE OPERATING TRANSFERS (6,794,701) 4,309,991 11,104,692 Operating transfers in 1,672,354 1,644,483 (27,871) NET INCOME (LOSS) ($5,122,347) $5,954,474 $11,076,821 W City of Cape Girardeau, Missouri WATER FUND SCHEDULE OF REVENUES AND EXPENSES. BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 2001 is VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE] OPERATING REVENUES Residential charges $2,569,000 $2,674,743 $105,743 Commercial charges 1,859,500 1,705.413 (154,087) Other fees and charges 174,000 137,842 (36,158) Other miscellaneous 4,000 30,317 26,317 TOTAL OPERATING REVENUES _ 4,606.500 4,548,315 (58,185) OPERATING EXPENSES Personnel services 116,861 112,873 3,988 Materials and supplies 314,700 324,518 (9,818) Contractual services 2,679,248 2,554,775 124,473 General operating expenses 128,500 162,686 (34,186) Speaal pmjecs expense 45,000 2.785 42,215 Internal service expense 49,548 54,813 (5,265) Capital outlay 86,950 89,443 (2493) TOTAL OPERATING EXPENSES 3,420,807 3,301,893 118,914 OPERATING INCOME (LOSS) 1,185,693 1246,422 60,729 NON-OPERATING REVENUE (EXPENSES) Investment revenue 119,500 141,641 22,141 Federal grants - - - Compensation for damages - - - Gain on sale of assets - 3,505 3,505 Water assessments - 111,849 111,849 Prindpal payments (755,000) (755,000) - interest and handling costs (637,414) (632641) 4,773 TOTAL NON-OPERATING REVENUE (EXPENSES) (1272,914) (1,130,646) 142,268 NET INCOME (LOSS) __($87,221) $115.776 $202.997 is 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, 2001 r v VARIANCE FAVORABLE r. BUDGET ACTUAL (UNFAVORABLE) e, OPERATING REVENUES Residential charges $1,680,500 $1,739,096 $58,596 Commercial charges 22,000 26.858 4,858 Transfer station charges 579,500 506,689 (72,811) Other fees and charges 33,500 34,475 975 Other mlemllaneous 14,500 12,425 (2,075) TOTAL OPERATING REVENUES 2,330,000 2,319.543 (10,457) lw OPERATING EXPENSES Personnel services 1,007 401 996.072 11,329 I Materials and supplies 91,700 76,623 15,077 y Contractual services 771,919 679,169 92,750 General operating expenses 32,178 49,333 (17,155) Special projects expense 90,450 70,357 20,093 Internal service expense 149,397 144,616 4,781 r Capital outlay 220,810 236,136 (15,326) TOTAL OPERATING EXPENSES 2,363,855 2252 306 111,549 OPERATING INCOME (LOSS) (33,855) 67,237 101,092 NON-OPERATING REVENUE (EXPENSES) Investment revenue 29,500 44,258 14,758 ` Loral grants 8,505 8,505 - State grants - 29,546 29,546 Federal grants Compensation for damages - 1,656 1,656 hisGain on sale of assets - 30,768 30,768 Principal payments (167,200) (167,932) (732) Interest no hall mots (67,072) 62,484 4,588 TOTAL NON-OPERATING REVENUE (EXPENSES) (198,267) 80,584 _(115,683) NET INCOME (LOSS) ($230,122) ($48,446) $181,676 Y r r r 96 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, 2001 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI OPERATING REVENUES ` Equipment sales $8,000 $8,073 $73 Concession revenues 70,000 78,107 8,107 Golf nurse fees 422,000 416,401 (5,599) Other miscellaneous 6,235 6,235 TOTAL OPERATING REVENUES 500,000 508,816 8,816 OPERATING EXPENSES Personnel services 262,357 261,342 1,015 Materials and supplies 68,725 79,985 (11260) ContracWal services 15,700 19,892 (4,192) r General operating expenses 49,350 50,440 (1,090) Spedel prolongs expense 6,700 8,439 (1,739) Internal service expense 77,761 60,326 17,436 Capital outlay 20,600 18,979 1,521 TOTAL OPERATING EXPENSES 501,093 499,402 1,691 r OPERATING INCOME (LOSS) (1,093) 9,414 10,507 NON-OPERATING REVENUE (EXPENSES) Investment revenue 2000, 2,172 172 Compensation for damages - - - r Gain on sale of assets - 4,595 4.595 Interest and handling costs (23,400) (21,646) 1.754 TOTAL NON-OPERATING REVENUE (EXPENSES) (21,400) (14,679) 6,521 f INCOME (LOSS) BEFORE OPERATING Ir TRANSFERS (22,493) (5,465) 17,028 Operating transfers in 23,000 23,000 NET INCOME (LOSS) $507 $17,535 $17,028 y r V 96 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, 2001 97 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI OPERATING REVENUES Equipment sales $10,000 $9,902 ($98) Concession revenues 59,000 59,856 856 Softball complex fees 63,060 60,770 (2,230) Other miscellaneous 202 202 TOTAL OPERATING REVENUES 132,000 130,730 (1,270) OPERATING EXPENSES Personnel services 222,873 219,856 3,017 Metedals and supplies 52,325 50,005 2.320 Contradual services 9,440 8,794 646 General operating expenses 44,100 43.650 450 Spebal projects expense 9,500 9.894 (394) Interest service expense 17,558 22,850 (5,292) Capital outlay 5,000 7,325 (2,325) TOTAL OPERATING EXPENSES 360,796 362,374 (1,578) OPERATING INCOME (LOSS) (228,796) (231,644) (2,848) NON-OPERATING REVENUE (EXPENSES) Interest reams - 2081 2,081 Gain on sale of assets - 275 275 Interest and handling costs (13,200) (10,356) 2844 TOTAL NON-OPERATING REVENUE (EXPENSES) (13,200) (8,000) 5.200 INCOME (LOSS) BEFORE OPERATING TRANSFERS (241,996) (239,644) 2,352 Operating transfers in 242,325 242,325 NET INCOME (LOSS) $329 $2,681 $2.352 97 L City of Cape Girardeau, Missouri INTERNAL SERVICE FUNDS COMBINING BALANCE SHEET June 30, 2001 (With Comparative Totals for June 30, 2000) Employees' Data Fleet Fringe Risk Equipment Totals poymbion Management Benefit Manaaemeni Replacement 06130/01 06130100 ASSETS P.I. cash antl inviourn is $79,354 $213,992 $291544 $1,471,250 $322,113 $2,376,253 $2,402,029 N.froled rash and cash equivalents - - 10,585 - 10565 8,585 Non-poolodinveslmenls - - 200,360 200,360 197,715 Interest receivable - - 3,647 - 3,647 3,647 OOrer receivables 5,132 10,451 10,810 23,932 - 50,325 44,880 vmares - 5.139 - - - 5139 9,510 Restricted III Nan -pooled cash and cash equivalents 44 - - - 44 68 2 Prepaid hems 19,901 1,352 969 3,297 25519_ 53256 104,431 230,934 312,939 1,700,158 325.454 2,673,916 2719,526 Property plant ane equipment Land - 37,500 - - 37500 37,500 Buildings 643 446,960 - - - 449 6C3 121,821 Impmisrummsother buildings - 113.749 - - - 113,749 113,749 Equipment 1651.321 445,085 - - 1,629,095 3,725501 3,680.335 Constmgtl0n m progress 14,072 1651964 1,045,294 - - 1629,095 4,326.353 4,467,477 Less accumulated depreciation 1,062632 627336 _- 644,521 2,3".34,492_ 2,244,173 589,332 417955 - 984,574 1991661 2223,304 Total assets $663,763 $648,889 $312,939 $1700,159 $1,310028 $4665777 $4.942930 LIABILITIES AND FUND EQUITY Accounts payable S12,886 $60299 $1,303 $30678 $- $105,366 $79691 Accrued liabilities Salarles.paymIl lases and benefits 5.056 181453 - - - 28,506 21,656 Interest Payable 2,495 6 - - 2.641 5,142 6,569 Other liabilities - 63 63 61 Estimated claims payable - 125,000 309,672 434672 476,708 Due to other governments - 1,140 - - - 1,140 1,560 Due to other funds Current portion of long term debt 60000 - - 65,000 125,000 120.000 Lgngto- debt net of cdrrgnl pori... Certificates Of paNclpation 144,915 1.4.9,710 294.625 419,482 Do. to other funds _ Total liabilities 225352 79,961 126,303 340550 217,351 989.517 1,127749 Retained earnings Unrearyod 468411 568,628 186,636 1,359,we 1,092,677 3.676,260 3815 181 Total fend equity 468,411 _ 568,928 186,636 1,359,608 1.092677 3.676.260 3815 18, Total liabilities and fund equity $693,768 $646889 $312,939 51,700,156 $1.310,028 $4,665,777 $4,942,930 L City of Cape Girardeau, Missouri INTERNAL SERVICE FUNDS COMBINING STATEMENT OF REVENUES. EXPENSES AND CHANGES IN RETAINED EARNMGS FOR THE FISCAL YEAR ENDED June 30, 2001 99 EMPLOYEES' DATA FLEET FRINGE RISK EQUIPMENT TOTALS PROCESSING MANAGEMENT BENEFIT MANAGEMENT REPLACEMENT 2000-2001 OPERATING REVENUES Inlees'"onenlal servres $341.640 $964.525 $1634492 $278,165 $251747 $3,490,577 011ier miscellaneous 1535 1,535 TOTAL OPERATING REVENUES 341,648 986060 1,634492 278,165 251,747 3492 112 OPERATING EXPENSES Pen'onnel services 95 429 476 813 - - - 572,242 Malenals and supplies 8,933 285,877 - - 294,010 CounaRual services 91309 152,323 1,661849 350,080 - 2255,561 General opeaGy expenses 1.027 1,056 7,411 20,161 - 30,455 Internal seMce expenses - 2.434 - - - 2,434 Depacdcon expense 207,355 45365 209456 462.176 TOTAL OPERATING EXPENSES 404,053 964668 1669,260 370241 209456 3,617,670 OPERATING INCOME (LOSS) (63.405) 21,392 (34768) ___(92.q76)_42,291 _(125565) NON-0PERATING REVENUES (EXPENSES) me. -X revenue 1684 3,696 29871 113.993 13,175 162,419 Gain on tale of assets - 8172 8.616 16 788 Loss on We of assets (14,300) (28,022) (42 322) assance cost amiladlon (1,734) - - - (1,599) (3,333) Interest and heading costs (12,580) (471) (13030) (20001) TOTAL NON,DPERATING REVENUES (EXPENSES) _G6,930) 11397 29,871 113, PRO (20060) 107,471 INCOME (LOSS) BEFORE OPERATING TRANSFERS (89,335) 32789 (4097) 21,917 21.431 (16,095) Operating transfers in 2465 - 76.500 80,965 Operating transfers out (28,289) (O3 E00) - (201,789) NET INCOME (LOSS) IN 870) 4,500 (178,397) 21,917 99,931 (136919) RETAINED EARNINGS (DEFICIT), JULY1 5552.1 564,428 365,033 1,337,691 992,746 3,815,179 RETAINED EARNINGS (DEFICIT), JUNE 30 $460,411 $568,928 $106,636 $1,359 608 $1,092,677 $3,676 260 99 City Of Cape Girardeau. Missouri INTERNAL SERVICE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE FISCAL YEAR ENDED June 30, 2001 100 Employees Data Fleet Fnnge Risk Equipment Totals Processing Management Benefit Management Replacement 2000-2001 Cash flows from operating activities Operating Income (loss) (562,405) $21,392 (534168) ($92,076) 542,291 ($125,566) Adjustments to reconcile net Income to net cash provided by operating activltles Depreciation and armumpation 207,355 45,365 - 209 456 All Change In assets and liabilities (Increase) Decrease In accounts receivable - (1752) (49) (3,643) - (S,M4) (Increase) Decrease In inventory - 4,371 - - - 4,371 (increase) Decrease In prepaid expenses 24,461 (57) - 24,404 Increase RD crsase)In accounts payable 4,411 9,635 903 10,726 25,675 Increase (Desserts) In accrued liabilities (1.116) 1,815 (25,000) (19,036) (713) (44,050) NET CASH PROVIDED BY (USED IN) OPERATING ACTIVITIES 172,706 80,769 (58,914) (106,029) 251,034 341,566 Cash Hous Ircm noncapltal financing activities Operating lranafem more other funds 2465 - 78,500 80.965 Operating tansters to other funds (213,289) (173,500) (201,789) NET CASH PROVIDED BY (USED IN) NONCAPITAL FINANCING ACTIVITIES 2.465 (28,289) (173,930) - 78,500 (120.824) Cash flows mom capital and related financing Principal paid on COP (60.000) - - - (60,000) (120.000) Interest paid on bonds and obligations (12.520) (471) - - (12,945) (25.936) Purchase offived assets (63,977) (18,213) - - (198,679) (280.869) Proceeds from sale of assets - 8.172 - - 16,428 24,600 NET CASH USED BY CAPITAL AND RELATED FINANCING ACTIVITIES (136,497) (19512) - - (255,196) 14(2205) Cash flows mom Investing activities Interest on investments 44 - 100,349 43 100,436 Overnight Interest 11640 3,696 29,871 13,645 131134 61,986 FMV adjustments to cash (2,646) 12,M) NET CASH PROVIDED BY (USED IN) INVESTING ACTIVITIES Large 3,696 29,871 1111348 13,177 159,776 NET INCREASE (DECREASE) IN CASH AND CASH EQUIVALENTS 0,358 45664 (202,543) 7,319 87.515 (21,6871 Cash and cash equivalents at beginning of year 39,040 10,328 504,672 1453.931 234642 2410.613 Cash and cash equivalents at end of year $ 79398 $ 213.992 5 302,129 5 1471250 S 322,157 5 2,388,926 100 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, 2001 101 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) OPERATING REVENUES Interdepartmental services $341,648 $341,647 ($1) Other miscellaneous - TOTAL OPERATING REVENUES 341,648 341,647 (1) OPERATING EXPENSES Personnel services 90,086 95,428 (5,342) Materials and supplies 5,900 8,933 (3,033) Contractual services 107,000 91,309 15,691 General operating expenses 6,050 1,027 5,023 Capital outlay 61,457 63,976 (2,519) TOTAL OPERATING EXPENSES 270,493 260.673 9,820 OPERATING INCOME (LOSS) 71,155 80,974 9,819 NON-OPERATING REVENUE (EXPENSES) Investment revenue - 1,045 1.045 Principal payments (12,830) (60,000) (47,170) Interest and handling ousts (60,500) (13,233) 47.267 TOTAL NON-OPERATING REVENUE (EXPENSES) (73,330) (72,188) 1,142 INCOME (LOSS) BEFORE OPERATING TRANSFERS (2175) 8,786 10,961 Operating transfers in 2,465 2,465 - NET INCOME (LOSS) $290 $11.251 $10,961 101 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, 2001 ME VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI OPERATING REVENUES Interdepartmental services $1,023,000 $984,526 ($38474) Other miscellaneous 1,535 1.535 TOTAL OPERATING REVENUES 1,023,000 985,061 (36,939) OPERATING EXPENSES Personnel services 529,802 476,814 52,988 Materials and supplies 300.695 285,324 15.371 Contractual services 142.825 152,323 (9,498) General operating expenses 3,150 1,856 1,294 Internal service expense 2,434 2,434 - Capilaloullay 14,300 15,673 (1,373) TOTAL OPERATING EXPENSES 993,206 934,424 58,782 OPERATING INCOME (LOSS) 29,794 51,637 21,843 NON-OPERATING REVENUE (EXPENSES) Investment revenue - 3,344 3,344 Gain of sale of assets - 8,172 8,172 Principal payments - (441) (441) Interest and handling costs (473) (473) TOTAL NON-OPERATING REVENUE (EXPENSES) 10,602 10,602 INCOME (LOSS) BEFORE OPERATING TRANSFERS 29,794 62,239 32,445 Operating transfers out (28,289) (28,289) NET INCOME (LOSS) $1,505 $33,950 $32.445 ME r 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, 2001 103 VARIANCE FAVORABLE BUDGET ACTUAL 1UNFAVORABLEI OPERATING REVENUES Interdepartmental services $1,509,240 $1,634,493 $125,253 TOTAL OPERATING REVENUES 1,509,240 1,634.493 125,253 OPERATING EXPENSES Personnel services - - - Conlradualservices 1,705,240 1,661,849 43.391 General operating expcnsos 7,411 (7,411) TOTAL OPERATING EXPENSES 1,705,240 1,669,260 35,980 OPERATING INCOME(LOSS) (196,000) (34,767) 161,233 NON-OPERATING REVENUE (EXPENSES) Investment revenue 27,500 22,888 (4,612) TOTAL NON-OPERATING REVENUE (EXPENSES) 27,500 22A88 (4,612) INCOME (LOSS) BEFORE OPERATING TRANSFERS (168,500) (11,879) 156,621 Operating transfers out -. _(173,500) (173,500) NET INCOME (LOSS) ($342,000) ($185,379) $156,621 103 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, 2001 104 VARIANCE FAVORABLE BUDGET ACTUAL IUNFAVORABLEI OPERATING REVENUES Interdepartmental semces $307,622 $278,164 ($29,458) Other miscellaneous TOTAL OPERATING REVENUES 307,622 278,164 (29,458) OPERATING EXPENSES Contredual services 379,122 338,668 40,454 General operating expenses 20,161 (20,161) TOTAL OPERATING EXPENSES 379,122 358,829 20.293 OPERATING INCOME (LOSS) (71,500) (80,665) (9,165) NON-OPERATING REVENUE (EXPENSES) Investment revenue 71,500 97,365 25,865 TOTAL NON-OPERATING REVENUE (EXPENSES) 71,500 97,365 25,865 NET INCOME (LOSS) $- $16,700 $16,700 104 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, 2001 L VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI OPERATING REVENUES Interdepartmental services $253,158 $251,745 ($1,413) TOTAL OPERATING REVENUES 253,158 251,745 (1,413) OPERATING EXPENSES Capltel outlay 169,500 172.641 (3,141) TOTAL OPERATING EXPENSES 169,500 172,641 (3,141) OPERATING INCOME (LOSS) 83,658 79,104 0,554) NON-OPERATING REVENUE (EXPENSES) Investment revenue 10,000 11,131 1,131 Gain on sale of assets 20,000 16,428 (3,572) Prindpal payments (60,000) (60,000) - Interestandhandlingcosm (13,915) (13,658) 257 TOTAL NON-OPERATING REVENUE (EXPENSES) (43.915) (46,099) (2,184) INCOME (LOSS) BEFORE OPERATING TRANSFERS 39,743 33,005 (6,738) Operating transfers in 78,500 78,500 NET INCOME (LOSS) $118,243 $111,505 ($6,738) 105 City of Cape Girardeau, Missouri AGENCVFUNDS COMBINING BALANCE SHEET June 30, 2001 (With Comparative Totals for June 30, 2000) Park Arena Development Totals Library Improvement Foundation 06/30101 06130100 ASSETS Pooled cash and investments $620,015 $116,291 $57,838 $794,144 $697,911 Non -pooled investments 1 - - 1 15,566 Receivables, net of allowances for doubtful receivables Real estate tax 16,141 - - 16,141 17,412 Personal property tax 3,602 - - 3,602 4,052 Other receivables 8 8 23 Total assets $639,767 $116,291 $57,838 $813,896 $734,964 LIABILITIES Accounts payable $23,037 $350 $7,985 $31,372 $26,089 Accrued liabilities Salaries, payroll taxes and beri 2,662 - - 2,662 3,037 Other liabilities 614,068 115,941 49,853 779,862 705,838 Total liabilities $639,767 $116,291 $57,838 $813,896 $734,964 106 Clly acapp GlraNesµ Mlssoun COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES ALL AGENCY FUNDS FOR THE FISCAL YEAR ENDED JUNE 30. 3001 Total assets at Jen, M,1005 $039161 3116291 $51036 $111.1 LIABItl _.Nl1 5000 [cants pa'aN. Are Deeelolaenr $6 601 $2ILI "Itbrry p—ere- F any Eation Tab le ASSETS Sables, papell laces ena Palet. Baan[ alull 12000 - 3i0W Odle, eat" PI.F., ab" aeamretna a $f99570 $112966 $1419]6 $6W 1911 Nompwl., lnve5lmenlv 15566 - $112,965 16,666 Race nolplal—bele, It Atha era a11om11 yeames Payable $415191 $56,315 $64.039 $199,119 P,bb-ll property It. 4,09 - - 4 P62 Diner....... It,, v n Tobl-1.1a .1July 1. 2000 $536623 -$112965 8843>6 $71.960 melons TUlal eyeelms $1ITS III $10245 Heal mats aea le.ealmenta p9L545 $5<,(i3C $101,362 $e94,541 ... a., a lnveslmen6 3.629 - - 3,629 e01een lolallowr—For $66 Lti5 V.211 4492936 Ireoles bet, We Real cal 169,169 1. 1177Ill- - .691160 pr ..aea—bay Rv 155603 - 171211 1561693 Dlner recerveDleS Ll Tplal abb.b. s 61 Total aaallbns $136 Pts --$,I L36 $101.062 $l11 2 T1 ,R1.re Pmlea w5n aeo .eveAmen6 $61]100 $1,"1 $126,900 S19]312 Nanymlea lm.. m..6 19,191 - 19,191 em .a0las a tolallowa... i RdPPr,.e Sada pay,,Ib—am—ya,. nes. -� m.ml Olnm I'll, IPI 61640 Ral 1901161 - T.1aIlo POmes aI 1110, 11161 Person a�p P."iea 1."1 - - 156,333 Otter receiveoles 76 - 71 TOOl Ill ... $1263131 $51,312 $115900 $1463 346 B.I.Pee. A lue. 103001 Peal alae.M s $,ILL15 $116,191 $5].636 $194111 Nan9.aea mves.1.nl 11 .eolaa.am- n a.�ow mn.....= 16111 - 11102 Fy—pay, lar 60 - - 9602 O Nenece1re61es 6 - - 6 Total assets at Jen, M,1005 $039161 3116291 $51036 $111.1 LIABItl _.Nl1 5000 [cants pa'aN. $11321 $6 601 $2ILI $26 090 Ay,Uea lla0i L0e5 Sables, papell laces ena Palet. 31031 - 3i0W Odle, eat" 519262 101 %1 111211 _115161_ FILM Ill a1 JUly 1, 2000 __$436,623 $112,965 $99171 $131,96. Atha era Payable $415191 $56,315 $64.039 $199,119 sal¢n ea� pa Noll tees a.0 UeneOk 200440 200,440 Olney to Plll Iles 6RJ04 11 SIF 141_93] L11 171 TUlal eyeelms $1ITS III $10245 $211616 $1"0,929 Cal eyaPle 569151 $66 Lti5 V.211 4492936 OeyrouaLe— aea LLnatte 1. 1177Ill- Oln¢ IeaOwlme 171211 _ _ 190,999 _ _ `593 Tplal abb.b. s $114 $66919 $239214 —'l I51 _ a1Jane 10 2001 82101 $350 $1,999 $Yl t, A.,,., 11 s Sada pay,,Ib—am—ya,. nes. -� Olnm I'll, IPI 61640 115941 49955 10214 T.1aIlo POmes aI 1110, 2001 $039,/61 $11019'_ $6!939 $113 Ill 107 City of Cape Girardeau, Missouri SCHEDULE OF GENERAL FIXED ASSETS BY SOURCE June 30, 2001 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 108 $2,598,805 7,783,924 3,719,688 954,283 88,210 $15,144,910 $3,647,325 10,021,769 1,423,432 15,723 36,661 $15,144,910 City of Cape Girardeau, Missourl v SCHEDULE OF GENERAL FIXED ASSETS - BY FUNCTION AND ACTIVITY June 30, 2001 y� Improvemenls Machinery Construcown Other Than and In Function and Activity Land Build Bullies Eauiament Progress Total I ,r ADMINISTRATIVE SERVICES Human resources $- $- $- $237 $- $237 City manager 200,000 72,801 - 253 - 273,054 1 Maintenance - - 2,200 - - 2200 City attorney - 3,014 - 3,014 r Interdepartmental 67,340 19,095 5033 - 91,468 Finance - - - 204 - 204 CVB - 138,250 - 14,676 15,512 168,438 Airport 354,649 235,452 3,062,444 172,045 18.000 3,842 590 r TOTAL ADMINISTRATIVE SERVICES 621,989 446,503 3,083,739 195.462 33,512 4,381205 r DEVELOPMENT SERVICES r Planning services - - - 22,789 - 22,789 Inspections - - - 3,230 - 3,230 Community Information program - - - 6,032 - 6,032 Vision 2000 - - 1,]06 - - 1,706 r Downtown Business District - - - - - - Ergineenng services - - - 32,863 - 32,863 Project Impact 2,611 2,611 TOTAL DEVELOPMENT SERVICES 1]06 67,525 69,231 PARKS AND RECREATION p Par, maintenance 765,638 251 483 3,761 39,906 - 1 060,788 Arena maintenance - - 103,448 32,507 - 135,955 r Municipal band - - - 1,961 - 1,961 Recreation - - - 691 - 691 Cemetery 4,120 3,225 - 8,797 - 16,142 Central pool - 519,688 4,906 2,767 - 527,361 r Capaha pool - 3.898 3,634 - - 7.532 Osage Community Centre - 2,379,102 1,973 56,678 - 2.43].]53 Softball Complex - 2,144.073 - 15,958 - 2,160,031 r TOTAL PARKS AND RECREATION ]69]58 5,301,469 11],]22 159,265 6,348214 r PUBLIC SAFETY 1 Mumospal court - - - - - Health - - - 6,086 - 6,086 r Police 35,324 140,167 986 134,313 4,950 315,740 Fire 232,818 646,320 10,771 319,934 1,209,843 r TOTAL PUBLIC SAFETY 268,142 ]86,48] 11]5] 460,333 4,950 1,531669 V PUBLIC WORKS f Street - - - 62,994 - 62,994 Stormwater 8,704 8,704 TOTAL PUBLIC WORKS 71,698 71,698 CAPITAL OUTLAY ` General copltal Improvements 495,1]5 1,219,643 439,465 - 8,551 2,162,834 Par, improvements 443,741 29822 65,299 41,197 580.059 TOTAL CAPITAL OUTLAY 938.916 1249465 504 7(34 49,748 2,742,893 r TOTAL GENERAL FIXED ASSETS $2598,805 $7,783,924 $3,719688 $954,283 588210 515,144910 109 City o/ Cape Girardeau, Missouri SCHEDULE OF CHANGES IN GENERAL FIXED ASSETS. BY FUNCTION AND ACTIVITY FOR THE FISCAL YEAR ENDED JUNE 30, 2001 110 General Fixed General Fixed Assets Depreciation Assets Function and Activity 06130100 Additions Deductions Expense 06130101 ADMINISTRATIVE SERVICES Human resources $475 $- $- 5237 $238 City manager 283.063 - 10,009 273,054 Facility maintenance 2,553 - - 352 2.201 City attorney 1452 2,314 - 752 3,014 Interdepartmental 99,407 - - 7,939 91,468 Finance 392 - - 188 204 CVB 169,941 6,585 - 8,088 168,438 Airport 4036215 50.674 244300 3,842,589 TOTAL ADMINISTRATIVE SERVICES 4,593,498 59,573 271,865 4 381 206 DEVELOPMENT SERVICES Planning services 11.268 14,169 - 2,648 22,789 Inspections 891 2620 15,536 (15,255) 3230 Community,rfn,mation service 10,745 - - 4,713 6032 Engineering services 38,452 8,985 23,472 (8898) 32,863 Project Impact - 3,032 - 421 2,611 Vision 2000 2011 - - 305 1706 Downtown Business District 23.792 - 23,942 (150) - Capital Improvement 10.000 - 10.000 TOTAL DEVELOPMENT SERVICES 97,159 28,806 62.950 (16216) 79,231 PARKS AND RECREATION Park maintenance 1200,669 14,911 124.600 30,192 1060,788 Arena maintenance 15,483 127,664 - 7,192 135,955 Municipal band 2,209 - - 248 1,961 Recreation 957 - - 266 691 Cemetery 21.288 - 5,146 16142 Central pool 557,118 - 29,757 527,361 Capaba pool 8,606 - - 1,074 7,532 Osage Community Centre 2.537,187 6,786 - 106.220 2437753 Softball Complex 2,245,946 85,915 2,160,031 TOTAL PARKS AND RECREATION 6,589,463 149,361 124,600 266,010 6,348214 PUBLIC SAFETY Municipal sour( 34 - - 34 - Health 10,399 - - 4313 6,086 Police 314,427 74684 27,702 45670 315,739 Fire 1302,556 49,147 85,000 56,860 1209843 TOTAL PUBLIC SAFETY 1,627416 123,831 112,702 106,877 1,531,668 PUBLIC WORKS Street 113577 1,963 21,152 31,394 62,994 Stormwater 24,642 - 0 11,000 4938 8,704 TOTAL PUBLIC WORKS 138219 1,963 _32,152 36,332 71.698 CAPITAL OUTLAY General capital improvements 2735,094 - - 82,260 2,152,834 Parklmpmvemenls 561,894 65.172 36,522 10485 580.059 TOTAL CAPITAL OUTLAY 2796,986 65,172 36,522 92745 2732,893 TOTAL GENERAL FIXED ASSETS $15,842,143 $428706 $368926 $757613 $15,144910 110 City of Cape Girardeau, Missouri SCHEDULE OF CHANGES IN LONG-TERM DEBT FOR THE FISCAL YEAR ENDED June 30, 2001 GENERAL LONG-TERM DEBT Revenue bonds payable Leasehold revenue bonds payable Certificates of partidpation payable General obligation refunding bonds payable Accrued benefits Due to other governments -State energy loan TOTAL GENERAL LONG-TERM DEBT General General Long-term Long-term Debt Debt July 1. 2000 Additions Retirements June 30 2001 $24,935,000 $- $660,000 2.585,015 - 421,617 4,345,000 - 560,000 2,040,000 - 370,000 650,780 30,644 - 13277 13,277 $34,569,072 $30.644 $2,024,894 111 $24,275,000 2,163,398 3,785,000 1,670,000 681,424 $32,574,822 City of Cape Girardeau, Missouri STATEMENT OF GENERAL LONG-TERM DEBT Jude 30, 2001 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 Amount available in debt service fund Amount to be provided CERTIFICATES OF PARTICIPATION Amount available in debt service fund Amount to be provided GENERAL OBLIGATION REFUNDING BONDS Amount available in debt service fund Amount to be provided ACCRUED BENEFITS Amount available in debt service fund Amount to be provided TOTAL AMOUNT AVAILABLE AND TO BE PROVIDED GENERAL LONG-TERM DEBT PAYABLE Revenue bonds payable Leasehold revenue bonds payable Cedificates of parlldpation payable General obligation refunding bonds payable Accrued benefits Due to other governments -State energy loan 14]/9ltlgNq:L\\4P. R3lIg3dE ]gS�Ya\%a\-1/4 112 r $24,275,000 $24,275,000 734,834 1,428.564 2163,398 937,595 2,847,405 3,785,000 801,526 868,474 1,670,000 681,424 681.424 $32,574,822 $24,275,000 2,163,398 3,785,000 1,670,000 681,424 $32.574,822 r SINGLE AUDIT SECTION 113 KERBER, ECK & BRAECKEL LLP (IRll,l,") FkB„( �, f,,,i N, N 911 r- _ roe . ..., nl V m r o INDEPENDENT AUDITORS' REPORT ON COMPLIANCE WITH REQUIREMENTS APPLICABLE TO EACH MAJOR PROGRAM AND INTERNAL CONTROL OVER COMPLIANCE IN ACCORDANCE WITH OMB CIRCULAR A-133 r Honorable Mayor and Members of the City Council City of Cape Girardeau, Missouri Compliance We have audited the compliance of the City of Cape Girardeau, Missouri with the types of compliance requirements described in the U. S. Office of Management and Budget (OMB) Circular A-133 Compliance Supplement that are applicable to each of its major federal programs for the year ended June 30, 2001. The City of Cape Girardeau, Missouri's major federal programs are identified in the summary of auditor's results section of the accompanying schedule of findings and questioned costs. r Compliance with the requirements of laws, regulations, contracts and grants applicable to each of its major federal programs is the responsibility of the City of Cape Girardeau, Missouri's management. Our responsibility is to express an opinion on the City of Cape Girardeau, Missouri's compliance based on our audit. We conducted our audit of compliance in accordance with auditing standards generally accepted in the United States of America; the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States; and OMB Circular A-133. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether noncompliance with the types of compliance requirements referred to above that could have a direct and material effect on a major federal program occurred. An audit includes examining, on a test basis, evidence about the City of Cape Girardeau, Missouri's compliance with those requirements and performing such other procedures as we considered necessary in the circumstances. We believe that our audit provides a reasonable basis for our opinion. Our audit does not provide a legal �. determination on the City of Cape Girardeau, Missouri's compliance with those requirements. In our opinion, the City of Cape Girardeau, Missouri complied, in all material respects, with the requirements referred to above that are applicable to each of its major federal programs for the year r ended June 30, 2001. Internal Control Over Compliance r The management of the City of Cape Girardeau, Missouri is responsible for establishing and maintaining effective internal control over compliance with requirements of laws, regulations, contracts and grants applicable to federal programs. In planning and performing our audit, we considered the City of Cape Girardeau, Missouri's internal control over compliance with requirements that could have a direct and material effect on a major federal program in order to determine our auditing procedures for the purpose of expressing our opinion on compliance and to test and report on internal control over compliance in accordance with OMB Circular A-133. 114 r INDEPENDENT AUDITORS' REPORT ON COMPLIANCE WITH REQUIREMENTS APPLICABLE TO EACH MAJOR PROGRAM AND INTERNAL CONTROL OVER COMPLIANCE IN ACCORDANCE WITH OMB CIRCULAR A-133 - CONTINUED Our consideration of the internal control over compliance would not necessarily disclose all matters in the internal control that might be material weaknesses. A material weakness is a condition in which the design or operation of one or more of the internal control components does not reduce to a relatively low level the risk that noncompliance with applicable requirements of laws, regulations, contracts and grants that would be material in relation to a major federal program being audited may occur and not be detected within a timely period by employees in the normal course of performing their assigned functions. We noted no matters involving the internal control over compliance and its operation that we consider to be material weaknesses. This report is intended for the information of the City Council, management of the City of Cape Girardeau, Missouri, and federal awarding agencies and pass-through entities and is not intended to be and should not be used by anyone other than these specified parties. However, this report is a matter of public record and its distribution is not limited. Cape Girardeau, Missouri November 16, 2001 115 r KERBER, ECK & BRAECKEL LLP 31 3-3 1�11_ mv: 1" F°0 P a e.,d 3P. in.,. ooMssoc nA INDEPENDENT AUDITORS' REPORT ON COMPLIANCE AND ON INTERNAL CONTROL OVER FINANCIAL REPORTING BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS Honorable Mayor and Members of the City Council City of Cape Girardeau, Missouri We have audited the financial statements of the City of Cape Girardeau, Missouri as of and for the year ended June 30, 2001, and have issued our report thereon dated November 16, 2001. 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 the City of Cape Girardeau, Missouri's financial statements are free of material misstatement, we performed tests of its compliance with certain provisions of laws, regulations, contracts and grants, noncompliance with which could have a direct and material effect on the determination of financial statement amounts. However, providing an opinion on compliance with those provisions was not an objective of our audit and, accordingly, we do not express such an opinion. The results of our tests disclosed no instances of noncompliance that are required to be reported under Government Auditing Standards. Internal Control Over Financial Reporting In planning and performing our audit, we considered the City of Cape Girardeau, Missouri's internal control over financial reporting in order to determine our auditing procedures for the purpose of expressing our opinion on the financial statements and not to provide assurance on the internal control over financial reporting. However, we noted a matter involving the internal control over financial reporting and its operation that we consider to be a reportable condition. Reportable conditions involve matters coming to our attention relating to significant deficiencies in the design or operation of the internal control over financial reporting that, in our judgment , could adversely affect the City of Cape Girardeau, Missouri's ability to record, process, summarize and report financial data consistent with the assertions of management in the general purpose financial statements. Reportable conditions are described in the accompanying schedule of findings and questioned costs. o 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 116 INDEPENDENT AUDITORS' REPORT ON COMPLIANCE AND ON INTERNAL CONTROL OVER FINANCIAL REPORTING BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH " GOVERNMENT AUDITING STANDARDS — CONTINUED 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 for the information of the City Council, management of the City of Cape Girardeau, Missouri, 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. However, this report is a matter of public record and its distribution is not limited. ZIP Cape Girardeau, Missouri November 16, 2001 r ' 117 City of Cape Girardeau, Missouri SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS For the Year Ended June 30, 2001 ' 118 Federal Federal Grantor/Pass-through CFDA Federal Grantor/Program Title Number Expenditures Department of Housing and Urban Development Passed through Missouri Dept of Economic Development Community Development Block Grants .. 97 -ND -003 Jefferson/Shawnee Parkway 14.219 $ 145,234 97 -ED -14 Biokyowa Rail 14.219 141,964 99 -PF -26 Innovative Grant - Old St. Francis Demolition 14.219 250,000 00 -ED -14 Renaissance Air 14.219 - ` Federal Home Loan Bank Board Southeast Neighborhood Restoration Project 991333 14.247 65,000 r Passed through Missouri Dept of Social Services Emergency Shelter Grant - ERO1640401 14.231 16,843 Emergency Shelter Grant - ERO1640348 14.231 3,081 Total Department of Housing and Urban Development 622,122 r Department of Interior « Federal Emergency Management Agency Project Impact 99 -GR -0028 83.551 266,504 ` Total Department of Interior 266,504 Department of Justice Office of Juvenile Justice and Delinquency Parents and Children Together (PACT) 99-JJT5-02 16.546 18,421 r. Parents and Children Together (PACT) 99-JJT5-01 16.546 31,367 Bureau of Alcohol Tobacco and Firearms Gang Resistance Education and Training Program 25.013 1,534 Passed through Missouri Department of Public Safety r Victims of Crime Act (FY 97) 97-VOCA-0174 16.575 5,608 Victims of Crime Act (FY 99) 99-VOCA-0008 16.575 15,783 Office of Justice Programs Local Law Enforcement Block Grant 99 -LB -VX -8973 16.592 38,424 Local Law Enforcement Block Grant 98 -LB -VX -3234 16.592 23,678 Weed and Seed Grant 16.595 10,681 Cops More 98 Award 99 CM X 1820 16.710 15,538 Cops Universal Hiring Grant 97-UM-WX-0055 16.710 51,120 ' Juvenile Police Officer Grant 98-JFJ7-33 16.540 43,872 National Institute of Justice Bulletproof Vest Partnership 16.607 2,533 Total Department of Justice 258,559 r ' 118 City of Cape Girardeau, Missouri SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS For the Year Ended June 30, 2001 119 Federal Federal Grantor/Pass-through CFDA Federal Grantor/Program Title Number Expenditures Department of Transportation Safe Communities Grant 01 -SA -09-2 20.600 56,671 Safe Communities Grant 00 -SA -09-2 20.600 25,362 Public Taxi Coupon Transportation TM184021AF1 20.509 96,296 National ISE TE Recreation Trail Funding Program 20.519 6,584 Community Team Spirit Conference 00-YA-03-6 20.601 15,089 Community Team Spirit Conference 01-YA-03-2 20.601 1,715 Federal Highway Administration Passed through Missouri Highway and Transportation Department Hopper Road Bridge BRO-BRM-016(18) 20.205 11,746 Federal Aviation Administration Airport Layout Plan Update 3-29-0013-08 20.106 12,534 Backup Runway Generator 3-29-0013-09 20.106 41,331 Total Department of Transportation 267,328 TOTAL FEDERAL FINANCIAL ASSISTANCE $ 1,414,513 119 City of Cape Girardeau, Missouri SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS For the Year Ended June 30, 2001 r NOTE A - BASIS OF PRESENTATION r The accompanying schedule of expenditures of federal awards includes federal grant activity of the City of Cape Girardeau, and is presented on the accrual basis of accounting. The information in this schedule is presented in accordance with the requirements of OMB Circular A-133, Audits of States, Local Governments, and Non -Profit Organizations. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of the accrual basis r financial statements. r 120 — City of Cape Girardeau, Missouri SCHEDULE OF FINDINGS AND QUESTIONED COSTS " For the Year Ended June 30, 2001 A. Summary of Audit Results r I . The auditors report expresses an unqualified opinion on the statements of the City of Cape Girardeau, Missouri. 2. One reportable condition disclosed during the audit of the financial statements is reported in the Independent Auditors' Report on Compliance and Internal Control over Financial Reporting Based on an Audit of Financial Statements Performed in accordance with Government Auditing .. Standards. This is a repeat of the prior year finding. ^ 3. No instances of noncompliance material to the financial statements were disclosed during the audit. 4. No reportable conditions were disclosed during the audit of the major federal award programs. 5. The auditors' report on compliance for the major federal award programs for the City of Cape Girardeau, Missouri expresses an unqualified opinion. r 6. The programs tested as major programs included: Department of the Interior r. Federal Emergency Management Agency Project Impact r CFDA # 20.205 Department of Housing and Urban Development r Passed Through Missouri Dept of Economic Development Community Development Block Grants CFDA#14.219 7. The threshold for distinguishing Type A and B programs was $300,000 in federal expenditures. 8. The City of Cape Girardeau, Missouri was determined to be a low-risk auditee. , r 121 r City of Cape Girardeau, Missouri SCHEDULE OF FINDINGS AND QUESTIONED COSTS For the Year Ended June 30, 2001 B. Findings -Financial Statements Audit 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. ` Recommendation: The City should comply, consistently, with all aspects of the adopted investment policy. The investment committee 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. r This is a repeat of the prior year finding. r C. Findings and Questioned Costs -Major Federal Award Programs None r 122 r r City of Cape Girardeau, Missouri STATUS OF PRIOR YEAR FINDINGS For the Year Ended June 30, 2001 The finding reported in the fiscal year ending June 30, 2000, related to the investment policies of the City is repeated in the current year report. 123