The URL can be used to link to this page

Home My WebLink About1998-1999.AuditorReportFINANCIAL STATEMENTS AND INDEPENDENT AUDITORS' REPORT CITY OF CAPE GIRARDEAU, MISSOURI June 30, 1999 CONTENTS FINANCIAL SECTION Page Independent Auditors' Report 7 GENERAL PURPOSE FINANCIAL STATEMENTS Combined Balance Sheet - All Fund Types and Account Groups 10 Combined Statement of Revenues, Expenditures and Changes in Fund Balance - All Governmental Fund Types 12 Combined Statement of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual (Budget Basis) - All Governmental Fund Types 13 Combined Statement of Revenues, Expenses and Changes in Retained Earnings - All Proprietary Fund Types 15 Combined Statement of Cash Flows - All Proprietary Fund Types 16 Notes to Financial Statements 17 COMBINING AND INDIVIDUAL FUND FINANCIAL STATEMENTS GENERAL FUND Comparative Balance Sheet 63 Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 64 SPECIAL REVENUE FUNDS Combining Balance Sheet 65 Combined Statement of Revenues, Expenditures and Changes in Fund Balance 66 Convention/Visitors Special Revenue Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 67 CONTENTS - CONTINUED SPECIAL REVENUE FUNDS - Continued y Airport Special Revenue Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 68 Downtown Business Special Revenue Fund - Schedule of Revenues and Expenditures - .. Budget and Actual (Budget Basis) 69 Parks and Recreation Special Revenue Fund - „� Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 70 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 Capital Improvement Sales Tax Special Revenue Fund - .� Water Projects Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 74 Transportation Sales Tax Trust Special Revenue Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 75 r Flood Protection Special Revenue Fund - Schedule of Revenues and Expenditures - ... Budget and Actual (Budget Basis) 76 Vision 2000 Special Revenue Fund - Schedule of Revenues and Expenditures - ` Budget and Actual (Budget Basis) 77 DEBT SERVICE FUND Debt Service Fund - Comparative Balance Sheet 78 c CONTENTS - CONTINUED CAPITAL PROJECTS FUND Combining Balance Sheet 79 Combining Statement of Revenues, Expenditures and Changes in Fund Balance 80 General Capital Improvement Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 81 .. Corp Flood Control Capital Project Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 82 Street Improvements Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 83 FAU Street Grants Fund - ,� Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 84 Community Development Block Grant Fund - "" Schedule of Revenues and Expenditures - Budget and Actual (Budget Sasis) 85 Park Improvements Fund - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 86 Water Improvement Projects - Schedule of Revenues and Expenditures - Budget and Actual (Budget Basis) 87 r ENTERPRISE FUNDS .. Combining Balance Sheet 88 Combining Statement of Revenues, Expenses and Changes in Retained Earnings 89 Combining Statement of Cash Flows gp �^ Sewer Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 91 r CONTENTS - CONTINUED Water Fund _ Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 92 Solid Waste Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 93 + Golf Course Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 94 Softball Complex Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 95 INTERNAL SERVICE FUNDS Combining Balance Sheet 96 Combining Statement of Revenues, Expenses _ and Changes in Retained Earnings 97 Combining Statement of Cash Flows 98 Data Processing Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 99 ,� Fleet Management Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 100 Employees' Fringe Benefit Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 101 Risk Management Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 102 Equipment Replacement Fund Schedule of Revenues and Expenses - Budget and Actual (Budget Basis) 103 AGENCY FUNDS Combining Balance Sheet 104 Combining Statement of Changes in Assets and Liabilities - All Agency Funds 105 CONTENTS - CONTINUED FIXED ASSETS Schedule of General Fixed Assets by Source 106 Schedule of General Fixed Assets - By Function and Activity 107 Schedule of Changes in General Fixed Assets - By Function and Activity 108 LONG-TERM DEBT Schedule of Changes in Long -Term Debt 109 Statement of General Long -Term Debt 110 SINGLE AUDIT SECTION Independent Auditors' Report on Compliance With Requirements Applicable to Each Major Program And Internal Control Over Compliance In Accordance With OMB Circular A-133 112 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 115 Schedule of Expenditures of Federal Awards 117 Schedule of Findings and Questioned Costs 120 C Begley, Janssen, Young & Birk, LC CERTIFIED PUBLIC ACCOUNTANTS 2103 THEWS ST. -CAPE GnARDEAU, Mi,4',SCURt63701 TEtEPRONE(573j3342845 EAX($i30344338 TERRY R. BEGLEY, CPA JEFF UNTER.REINER. CPA LAWRENCE E. YOUNG, CPA CATHERINE A. WHITE, CPA KELVIN W, BIRK, CPA DEBORAH E DENEKE JOHN R. JANSSEN, CPA INDEPENDENT AUDITORS' REPORT ON THE GENERAL PURPOSE FINANCIAL STATEMENTS AND SUPPLEMENTARY INFORMATION Honorable Mayor and Members of the City Council City of Cape Girardeau, Missouri We have audited the accompanying general purpose financial statements of the City of Cape Girardeau, Missouri as of June 30, 1999, and for the year then ended as listed in the table of contents. These general purpose financial statements are the responsibility of the City of Cape Girardeau, Missouri's management. our responsibility is to express an opinion on these general purpose financial statements based on our audit. ,r We conducted our audit in accordance with generally accepted auditing standards and the standards applicable to financial audits contained inGovernment Aud+t�na S- nC3 ^baby, issued by the Comptroller General of the United ,States. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the general purpose financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the general purpose financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall general purpose financial statement presentation. We believe that our audit provides a reasonable basis for our opinion. In our opinion, the general purpose financial statements referred to above present fairly, in all material respects, the financial position of the City of Cape Girardeau, Missouri as of June 30, 1999, and the results of its operations and cash flows of its proprietary fund types for the year then ended in conformity with generally accepted accounting principles. y" In accordance with CQv=Me=A tuna °ran�j, dam, we have also issued our report dated December 27, 1999 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. Honorable Mayor and. Members of the City Council City of Cape Girardeau, Missouri Page 2 Our audit was made for the purpose of forming an opinion on the general purpose financial statements taken as a whole. The combining, individual fund and account group financial statements and schedules listed in the table of contents are presented for .. purposes of additional analysis and are not a required part of the general purpose financial statements of the City of Cape Girardeau, Missouri. Such information has been subjected to the auditing procedures applied in the audit of the general purpose financial statements and, in our opinion, is fairly presented in all material respects in relation to the general purpose financial statements taken as a whole. BEGLEY, JANSSEN, YOUNG& BIRK, LC ,, Cape Girardeau, Missouri December 27, 1999 8 GENERAL PURPOSE FINANCIAL STATEMENTS THE NOTES 10 111E FINANCIAL STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT, City or Gape Girardeau, Missouri COMBINED BALANCE SHEET ALL FUND TYPES AND ACCOUNT GROUPS June 30, 1999 Fldudery Govemmenlal Fund Type. PropNlery Fund Type, Fund Type Account Group. Conor" General Spedal Debt Cep11N internal Flaed LonPTerm a iolala ]Mem andum Onlyf Gan enl Revenue 5. rk POT... EnEs Om. $ervee Aoencv Assets Oebl 081]0/99 061]0/9B ASSETS AND OTHER DEBITS Au Pmled In aM mvemmenl. $1894,143 8115]8959 51,226985 13,531,0)9 9]0]8.480 13603,909 3221439 S S $24.5914]4 $20038,351 FE,1ed call and clan a9-Tame 393,169 23 939326 16442 21,315 11 A. 24,394,590 - Nm-po0bd mveetmen' - 1951.5 274,043 - ](0,141 - - 3301,449 ]051629 Rayoreal ,net of elbwal ,Id doubtful mm- am(-pool eslme, personal y.,ad,, eMr-a.-Is loses 47,6]0 9,219 14055 21.621 - 09,524 92338 Sales as. 635,099 630.228 - _ 1255.321 1215753 Fladahm. lase. 1019,365 - _ _ - 1019 365 1 093 652 ...Fadlel tav revivable 3,551 _ - 5652 357,10 Restaurant lv mceiva6le - 46 329 - - a6 129 50 313 U1i11ty fArtpe. receivable - - 1,163.513 - - 1,16]530 1003.516 Spacielemenmenla mcalvabM 1M, 252 15515 440,119 25.858 19.181 - 121526 BOT, IJ9 _ InlBresl I.A.E. 302,551 39505 4,194 45,013 a, 810 - 476213 411,7 IJ O 01.1 I.-Numms 45,915 24,139 259 10,115 112,426 41,245 302 - 242,461 229051 Hole, lecenabb .1mg-marmorn., renmeblm Moml fuel tae Bd 395 _ _ 6a 396 Ba 126 Molw y.E.la I..... fees 13952 - _ _ 13951 16231 Moln vebido solea tae - 25 301 - _ 25.301 26 863 Gnarl le m-thre 161650 58,602 159412 - - - 395612 463.8 Oue bond d111e,lunds 1,523.503 - _ - 1,523593 2(a. 211 Advances to oIran fund, 1,&6],500 1661,500 1061.500 Imenlmi., 216 19.196 IW 320 34. - - - 130.2 144050 He.ukled ....1, Non -pooled cash and comb eyuivelaM. 171543 259 111.802 11 2a6 613 Nm pooled A.Um ms - 13193284 - 13193.184 .2,195 F.Wd-an and nvealmenis - 1,105,430 - - 1705,438 1,344,254 Papamo soma 64AM 19.149 123520 58328 - - .5833 9,16861 Fbed ay.ls net or acaLmumlad depucialiom - - 55.539.114 1999 a42 16036274 13511490 68 158..2 011ier debits' .-pal-radn'e 101 dabl,ervtc. - - - 3593604 3591 614 3.59] 68 ana-1 to be provaea ror redromam AT9enmal b1--debt _ _ _ 33931562 3]93L.2 10612.123 ..-11. be pmvbed mr iNmB payment of compensated ab,ences 602,162 ES 161 Total eesele end other debits 51610.00 112599,253 $44122631 $218344421 5154929501 H,939,M9 $162,050 $16038,214 $30,133413 1101,533490 SIM pl1951 THE NOTES 10 111E FINANCIAL STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT, THE NOTES TO THE FINANCIAL STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT. sty ul cap. co-arE..v, Ml..uutl COMBINED BALANCE SHEET ALL FUND TYPES AND ACCOUNT GROUPS Jun. J0, 1999 Fmu.I., Governmental Fund Types PARdidery Fund Types Fund Type Amount Groups ..neral General Special Debt Capital Imam., Flaed LG Tunn ouT IF Memorandum Qnnlyl General REve_ Service Prost. Erdw rise §snit. AyencY pssa. Debt 06130199 06,30196 LIABILITIES, EQUITY AND OTHER CREDITS wmlule.: Avqumf....de SWI 05 8322.821 981341 1722,223 51.155,373 5515,20) 817.574 5 $ $3.135486 $a 027,7M A—d albacles S.wSO..paym0 lases aM banalila 331,612 14.0)9 - 178.771 33014 12,525 0)216] 1233]90 1.151.465 N ....... We - 21630 _ 21630 28,402 InlelesI p ... be 3,291 205 - 676CW 11,933 - - 1191509 555,264 .In., hid ilnlee 1]4,443 1],X9 293795 57 ]31,959 121 ]026 1024263 Qua b OF: Bovernmanls 205 - � 2707 241]68 2012 - - 26,330 55.322 113518 Due Wailes lwds - 53615 1469968 _ 1.523583 2054,211 ACvent ban.1a - 1152X3 - 1,657 END 1667,SW F, Ou CmeM podim Ol bnB Calm de0l - - 1,1]0,039 120,0)0 400),0)1 5,181 0)9 4 W292 Ldn9'tan m debt net OF d mlrenl Is.bn Panama blas payable - - 41477,014 _ 24,935013 65.412014 41272427 LeasNwpleyenue blas payable 727,933 2344015 2421948 530) )23 .— Care bsolpadlWund. 2535 WJ 539.313 - 0)45 boo 1,419313 0294.125 Generaladgelgn leluMing Mads "WEM - 2040000 2.040 CCO 2.395.343 Es6metad Ia." closul. aM gsl ao—o, mal lMinde, - - 300,000 - - - y. NED ADI 0elared cWnpenaafpn due empmyeas Del.rred l evnnus 153,364 233 7S8 SID 960 35,415 X 925 58] 837 N7 Total llablllees 951,119 ]5?300 '04,045 811.960 51697.212 1222329 762058 - 38,133,413 94846.524 73 892 Equity and PIMP credie: vnlm 0.1 n ...... I bred assets - - 160]0,2]4 - 16036274 IF .5 SEA Cunlnbded cabll.I - 23020TR - 2],028,]]4 20905660 R."Ped eaud,,f Reserved - 143333 _ 183.333 31 FE] Utteserved - - - 583,182 3.116.140 - 4299.922 3609.091 Pond Balances Resolved 1,698.163 .7 Fly 3,816592 25,910,415 - - 31934829 0,3556.2 Unserved 4,]51526 11,339205 1,110,102 172. .34 13 W7, 300 Total eFully and MM1e,—dua 6..609 11646865 3618,592 27,020,517 23.795.289 3]16]40 16038274 92685. .2 .11 Total l l abllllle. equity and other cndlle $7 610 $120599253 1(122637 527,034477 1754492MI 54939069 5762058 $160036274 $30.13),413 $147,532490 5135507957 THE NOTES TO THE FINANCIAL 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, 1999 GOVERNMENTAL FUND TYPES TOTALS SPECIAL DEBT CAPITAL (MEMORANDUM GENERAL REVENUE SERVICE PROJECTS ONLYI REVENUES Taxes $11,159,913 $8486235 $354,033 S- $20000,181 Licenses and permits 1,093,273 8,523 - - 1,101796 Intergovernmental 633,459 1459463 8,373 340,538 2,441833 Charges for services 351,555 459,294 - - 810,849 Interdepartmental services 536,191 - - - 536,191 Fines and forfeitures 872,91 - - - 872,571 Miscellaneous 76,385 135,511 40,000 - 251,896 Investment revenue 298,947 555,783 176,114 66,353 1,197,197 Special assessments 8,128 38,820 95,766 16.557 159,271 TOTAL REVENUES 15.030422 11,243,629 674,286 423.448 27,371,785 EXPENDITURES Current Administrative services 1.471,857 985.556 - - 249,513 Development sernces 1.421.674 10.946 - - 1432,620 Parks and recreation 1,125.497 1,099,904 - - 2,225,401 Public safety 7,813,813 235,783 - - 8049,596 Public worts 1812,838 2,931,109 - - 4]43,947 Coning 94,860 - - - 94,860 Capital outlay - - - 2260.049 2260,049 Debt service Principal - 12,796 2,507,314 - 2,520.110 Interest and fiscal charges 4,623 677,920 20,533 703,076 TOTAL EXPENDITURES 13.740,539 5,280.817 3.185.234 2280,582 24.487.172 .� EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 1,289,883 5,962,812 (2,510,948) (189,134) 2884,613 OTHER FINANCING SOURCES (USES) Operating transfers in 914,500 1202 267 2,535,909 2.820,825 7.573 501 Operating transfers out (2,467,681) (5.616,390) - (9,534) ($141,605) Bond proceeds - 105,193 - 25.350.773 25455,966 TOTAL OTHER FINANCING SOURCES (USES) (1,553,181) (4208,930) 2,535.909 28 114064 24 887 862 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES (263,298) 1,753,882 24,961 26 256 930 27.772 475 FUND BALANCES, JULY 1 -(RESTATED) 6,912,987 10,092983 3,593631 763.587 21 363,188 PRIOR PERIOD ADJUSTMENT FUND BALANCES, JUNE 30 $6,649,689 $11,846,865 $3.618,592 $27020,517 549,135663 12 REVENUES Taxes Licenses and permits Intergovernmental Charges for services interdepartmental services Fines and forfeitures Miscellaneous Investment revenue Special assessments TOTAL REVENUES EXPENDITURES Curtent Adm ni frative services Development sanices Parks and recreation Public si Public ecres CO'a"e" Debt aervite Principal Interest and fiscal charges TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Operating transfers in Operating lmnster9 out Advance repayment Bond proceeds TOTAL OTHER FINANCING SOURCES (USES) + EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND r OTHER FINANCING USES FUND BALANCES, JULY i -(RESTATED) PRIOR PERIOD ADJUSTMENT FUND BALANCES, JUNE 30 City of Cape Girardeau, Missoun COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL (BUDGET OASIS) - ALL GOVERNMENTAL FUND TYPES FOR THE FISCAL YEAR ENDED June 30,1999 GENERALFUND 13, 919 922 13.715.501 VARIANCE 518023 1 324 260 FAVORABLE DODGE ACTUAL NNFAVORABLEI $11,146.510 $11.159913 $13403 988 900 1.093,273 104,373 384075 833a59 249,384 311,135 351,555 40,420 a93.500 536,191 42,691 280000 822,521 92,521 81,800 26,385 (5.415) 246025 308.386 62.361 6,000 8,128 2,128 14437.945 15039,881 601.916 1494.326 1471,368 23,008 1,532,671 1413,109 119,562 1,128,929 1,122.337 6592 2,806,202 7728,238 27969 1,860,289 1035,189 25,100 96,950 94860 2090 13, 919 922 13.715.501 204, 321 518023 1 324 260 806 237 914,500 911.500 NFAVORABLEI (2,981,302) (2.467681) 513,621 $5,364208 200,000 200000 (2066002) (1553.181) 713621 (1,548.]79) 11306,111 VARIANCE (28,921) 1,519,050 FAVORABLE 6912,987 ACTUAL(U NFAVORABLEI 6912967 - (31]8.963) $5,364208 8.523 4.523 $6884066 $1,519,858 32,002 13 SPECIAL REVENUE FUNDS 11 110,696 11306,111 VARIANCE FAVORABLE BUDGET ACTUAL(U NFAVORABLEI $8665.203 58466240 (31]8.963) 4.000 8.523 4.523 1427.460 1459462 32,002 559.000 459,294 (99 706) 177,483 94,331 (3.152) 277,550 218261 440.211 11 110,696 11306,111 195,415 1,178628 985,629 191.047 27 800 16945 16.855 1,101 096 1099,632 1,484 247712 235,783 511.929 5,809600 2.533,970 3.275.630 13,500 12,296 204 4,623 (4623) 8 676.384 4,083,378 3 993,006 2,234,312 6422733 4,106421 1797093 1,302,267 (494,826) (6,170,150) (5,616,390) 553.760 105,193 105,193 (4.323.052) (4.200,930) 164.127 (2,138,745) 2213.803 a,352,548 10,092983 10092,903 - $7,954,238 $12.306286 $4,352540 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,1999 ANNUALLY BUDGETED DEBT SERVICE FUND CAPITAL PROJECTS FUNDS VARIANCE VARIANCE FAVORABLE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) BUDGET ACTUAL (UNFAVORABLE) REVENUES Taves $346673 $354,434 $5361 S- $- S Intergovernmental ],500 8373 $73 1.15710 346537 (775 203) r MiS¢Ilaneous 40000 40000 - - Investmentrevenue 202800 212.106 9308 7500 69,415 61915 Special assessments 67500 95,766 28,266 15.000 16,558 1558 TOTAL REVENUES 666473 710,281 43,808 1.138,240 426,510 (711 730) EXPENDITURES Capiod 0uday - - - 2772.200 1,497421 1,274,779 INRA service Prinuipal 2507,300 2,507,314 (14) - InteRslandfisup horges 573,515 6P,920 (4.405) 1866 (1,866) TOTAL EXPENDITURES 3.180.815 3,185,234 (4.419) 2.772200 1499,287 1272,913 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (2,514 342) (2474,953) 39,389 it 633,960) (1072777) 561,183 OTHER FINANCING SOURCES (USES) Operating transfers In 2.541875 2.535,909 (5.966) 1,250090 787,535 (462,555) Operating transfers out - - (63,500) (57.534) 5966 Bond prot4etls 235,710 235710 TOTAL OTHER FINANCING SOURCES (USES) 2,541875 2,535,909 (5956) 1,186.590 965.711 (220879) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES 27,533 60,956 33,423 (447,370t (107,066) 340.304 FUND BALANCES, JULY I - (RESTATED) 6593,601 3,593,631 1,51],181 1.513,161 FUND BALANCES, JUNE 30 $3.621.164 53654,587 $33423 $1065,1111 $1406,115 $340304 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,1999 PROPRIETARY FUND TYPES 15 TOTALS (MEMORANDUM ONLY) 1998-1999 $5.455.502 2,579,903 584.9]] 11.626 113,080 398.252 61,504 242.915 3,078,103 52.544 12,6]0,416 2.911,510 922.48fi 862,1]5 2]8,506 noes 336.398 2,165,681 5,469 11552.029 1,026.382 1,124,523 7.155 24.172 4178 28 700 (101,208) (2274691) (1,167071) (1606¢4) 741,604 (173.500) 407,420 4.075 835 S,1.483 255 INTERNAL ENTERPRISE SERVICE OPERATING REVENUES Residential charges 55,455502 $ Cwnmerioal Charges 2.679,903 - Translersta4onshaMes 584,977 Equipment sales 11,626 Concession revenues 113,060 Gong Course fees 398,262 - SoBttall mmplex lees 61504 - OtherfeesaMeharges 242,915 - InterdepaMlentals - 3.078 103 Other misselMneouS 52,239 305 TOTAL OPERATING REVENUES 9,600,008 3,078408 OPERATING EXPENSES Personnel .,1. 2,290,289 621,221 Materials and rupsws 692,629 284,807 Conlredual services 3.166,838 1,695,332 General operating excesses 249413 29.093 Special prgMs vpense 114,804 - Intemalsern.expenses 334116 2,282 Depredation amounts 1,788,159 377 522 Capital Outlay 5 469 TOTAL OPERAPNG EXPENSES 8,641767 3.010262 OPERATING INCOME (LOSS) 958.241 68,146 NON-OPERATING REVENUES (EXPENSES) ImeSpnenl revenue 981612 142911 LOeat gents 2,155 - FedemIglants - - Sale of dN P." 1.368 22764 Comlreatu0n for damages 4.278 - Sale of fixM assets 26 700 - Issuancecostamsnonton (96051) (5,157) Interest and handling eo5t5 (2.235467) (39.224) TOTAL NON OPERATING REVENUES (EXPENSES) (1,308 385) 121,314 INCOME (LOSS) BEFORE OPERATING TRANSFERS (350.144) 189,460 Operating transfers in 241 NM 500 000 Operating transfers out (173,500) NET INCOME iLO55) (108540) $15960 RETAINED EARNINGS (DEFICIT), JULY1 875055 3.200760 PRIOR PERIOD ADJUSTMENT RETAINED EARNINGS (DEFICIT), JUNE30 S766 515 $3,716740 15 TOTALS (MEMORANDUM ONLY) 1998-1999 $5.455.502 2,579,903 584.9]] 11.626 113,080 398.252 61,504 242.915 3,078,103 52.544 12,6]0,416 2.911,510 922.48fi 862,1]5 2]8,506 noes 336.398 2,165,681 5,469 11552.029 1,026.382 1,124,523 7.155 24.172 4178 28 700 (101,208) (2274691) (1,167071) (1606¢4) 741,604 (173.500) 407,420 4.075 835 S,1.483 255 + City of Cape Girardeau, Missouri COMBINED STATEMENT OF CASH FLOWS - ALL PROPRIETARY FUND TYPES FOR THE FISCAL YEAR ENDED June 30, 1999 PROPRIETARY FUND TYPES TOTALS INTERNAL (MEMORANDUM ONLYI + ENTERPRISE SERVICE 1998-1999 CASH FLOWS FROM OPERATING ACTIVITIES: Operating income (lass) $958,241 $68.146 $1,026,387 + Adjustments to reconcile operating Income to net cash provided by operating activities: Depreciation 1788,159 377.522 2.165681 Cash operating grants received 7,155 - 7,155 + Change in assets and liabilities: (Increase) decrease in accounts receivable 123.496 557 124,053 (Increase) decrease in inventory 9,559 3.748 13.307 (Increase) decrease In prepaid items 5,794 (21,981) (16,187) + Increase (decrease) In accounts payable 4,682 (605,672) (600,990) Increase (decrease) in accrued liabilities (65,937) 301.481 235,544 Increase (decrease) In landfill postclosure care costs (71,800) - (71,800) + NET CASH PROVIDED BY (USED IN) OPERATING ACTIVITIES 2,759,349 123,801 2,883,150 + DASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES: Operating transfers in from other funds 241,604 500,000 741,604 Operating transfers out to other funds (173,500) (173,500) + NET CASH PROVIDED BY (USED IN) NONCAPITAL FINANCING ACTIVITIES 241,604 326,500 568,104 CASH FLOWS FROM CAPITAL AND RELATED FINANCING + ACTIVITIES: Proceeds from developers 190 688 - 190,488 Principal paid on revenue bonds (445,000) - (445,000) Principal paid on lease purchase bonds (627 686) - (627,686) + Principal paid on COP bonds (255 000) (110,000) (365.000) Principal paid on SRF bonds (123,000) - (123,000) Principal paid on energy loan 8 note payable on land (6,764) (424) (1.188) Interest paid on bonds and obligations (1,231,120) (39,886) (1,271,006) Purchase of fixed assets (5,737,411) (600,857) (6.338,268) + Proceeds from sale of assets 49,244 22.184 72,028 Compensation for damages 4,278 4,278 + NET CASH PROVIDED BY (USED IN) CAPITAL AND RELATED FINANCING ACTIVITIES (8,181971) (728,383) (8.910,354) CASH FLOWS FROM INVESTING ACTIVITIES: Purchase of investments (1,386062) (200,141) (1,586,203) + Proceeds from sale of investments 1,266468 - 1,266.468 Interest on investments 890,314 12,724 903,038 Overnight Interest 179,266 138,828 318,094 Interest on assessments 4,672 - 4,672 _ FMV adjustments to cash (4,427) (12,307) (16,734) NET CASH PROVIDED BY (USED IN) INVESTING + ACTIVITIES 950,231 (60,896) 889,335 INCREASE (DECREASE) IN CASH AND CASH EQUIVALENTS (4,230.787) (338,978) (4,569,765) + CASH AND CASH EQUIVALENTS, JULY 1 20.247.036 2.970.541 23,217,577 CASH AND CASH EQUIVALENTS, JUNE 30 516,016,249 $2,631,563 $18,641,812 THE NOTES TO THE FINANCIAL STATEMENTS ARE AN INTEGRAL PART OF THIS STATEMENT. 16 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES The City of Cape Girardeau, Missouri operates under a charter which went into effect April 12, 1982. The City operates under a Council -Manager form of government and provides the following services as authorized by its charter: public safety (police and fire), highways and streets, water, sanitation, health and social services, culture -recreation, public improvement, planning and zoning and general administrative services. The financial statements of the City have been prepared in conformity with generally accepted accounting principles (GAAP), as applied to 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. 0 1. Reporting Entity In evaluating how to define the City, for financial reporting purposes, management has considered all potential component units. Generally, component units are legally separate organizations for which the elected officials of the City are financially accountable. The Cape Girardeau (Missouri) Public Facilities Authority (CGPFA) is a blended component unit which is part of the City's operations and so the financial statements of the CGPFA are included in the accompanying financial statements of the City of Cape Girardeau. 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 Starnes of Missouri. The CGPFA board of directors consist of city officials and city council members. Due to the significant city influence and financial accountability, the activities of the CGPFA are blended with the financial presentation of the City. The corporation was used to execute the bond indentures for the purpose of issuing and securing the Series 1993 Bonds, Series 1994A Bonds, and Series 1997A and 1997B Bonds. These bonds were used to finance construction and improvements to sewer, solid waste, street, airport, flood control and other capital improvement projects. The bond payments are obligations of the CGPFA. The CGPFA has entered into a Lease Purchase Agreement with the City from which the lease payments will be used solely to retire the debt. Although they are not a component unit of the City, the City handles the funds of and provides accounting and other services for several entities. Since these funds we held in the City's name, these entities are shown as Agency Funds in the financial statements. 17 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30. 1999 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 1. Reporting Entity - Continued .� Beginning January 1, 1996 the Transportation Sales Tax Trust Fund was established as a special revenue fund. The fund was established to collect and expend a sales tax that was approved by a public vote in August 1995 and became effective January 1, 1996. The tax is restricted to being expended on street and sidewalk improvements and will expire in five years. 2. Fund Accounting The accounts of the City are organized on the basis of funds and account groups, each of which is considered a separate accounting entity. The operations of each fund are accounted for with a separate set of self -balancing accounts that comprise its assets, liabilities, fund equity, revenues and expenditures or expenses as appropriate. Government resources are allocated to and accounted for in individual funds based upon the purpose for which they are to be spent and the means by which spending activities are controlled. The various funds we grouped, in the financial statements in this report, into fund categories. GOVERNMENTAL FUND TYPES General Fund - The General Fund is the general operating fund of the City. All financial resources, except those required to be accounted for in another fund, are accounted for in the General Fund. Special Revenue Funds - Special Revenue Funds are used to account for the proceeds of specific revenue sources (other than expendable trust or major capital projects) are legally restricted to expenditures for specified purposes. Debt Service Fund - The Debt Service fund is used to account for the accumulation of resources for, and the payment of, general long-term debt principal, interest, and related costs. Capital 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. 13M City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 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 Funds - Enterprise Funds are used to account for operations that are financed and operated in a manner similar to private business enterprises - where the intent of the governing body is that the costs (expenses including depreciation) of providing goods or services to the general public on a continuing basis be financed or recovered primarily through user charges; or where the governing body has decided that periodic determination of revenues collected, expenses paid, and/or net income is appropriate for capital maintenance, public policy, management control, accountability, or other purposes. Internal Service Funds - Internal Service Funds are used to account for the financing of goods or services provided by one department to other departments of the City, on a cost - reimbursement basis. FIDUCIARY FUNDS Trust and Agency Funds - Trust and Agency Funds are used to account for assets held by the City in a trustee capacity or as an agent for individuals, private organizations, other governments, and /or other funds. Agency Funds are custodial in nature and do not involve measurement of results of operations. GENERAL FIXED ASSETS AND GENERAL LONG-TERM DEBT ACCOUNT GROUPS General Fixed Assets (GFA) - The General Fixed Assets Account Group is used to account for fixed assets used in 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 Long -Term Debt Account Group - The General Long -Term Debt Account Group is used to account for long-term liabilities to be financed from governmental funds. 19 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 3. Fixed Assets General Fixed Assets Account Group - Fixed assets used in governmental fund type operations are accounted for in the General Fixed Assets Account Group, rather than in governmental funds. Public domain (infrastructure) general fixed assets, including roads, bridges, curbs and gutters, streets and sidewalks, drainage systems and lighting systems, are not capitalized along with other general fixed assets. Depreciation has been provided on all capitalized assets, except for land. All fixed assets are valued at historical cost or estimated historical cost if actual historical cost is not available. Donated assets are valued at their estimated fair value on the date donated. Repairs and maintenance are recorded as expenditures; renewals and betterments are capitalized. Proprietary Funds - Additions to the Proprietary Funds are recorded at cost or, if contributed property, at their estimated fair value at time of contribution. Repairs and maintenance are recorded as expenses; renewals and betterments are capitalized. The sale or disposal of fixed assets is recorded by removing cost and accumulated depreciation from the accounts and charging the resulting gain or loss to income. Depreciation of all exhaustible fixed assets used by Proprietary Funds is charged as an expense against their operations. Accumulated depreciation is reported on Proprietary Fund balance sheets. Depreciation has been provided over the estimated useful lives using the straight-line method. The estimated useful lives are as follows. Buildings 25-50 years Improvements 10-40 years Equipment 3-10 years When applicable, interest costs are capitalized on self -constructed fixed assets. 4. Basis of Accounting The accounting and financial reporting treatment applied to a fund is determined by its measurement focus. All governmental funds are accounted for using a current financial resources measurement focus. With this measurement focus, only current assets and current liabilities generally are included on the balance sheet. Operating statements of these funds present increases (i.e., revenues and other financing sources) and decreases (i.e., expenditures and other financing uses) in net current assets. All proprietary funds are accounted for on a flow of economic resources measurement focus. With this measurement focus, all assets and liabilities associated with the operation of these funds are included on the balance sheet. Fund equity (i.e., net total assets) is segregated into contributed capital and retained earnings components. Proprietary fund type operating statements present increases (e.g., revenues) and decreases (e.g., expenses) in net total assets. 20 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 4. Basis of Accounting - Continued The modified accrual basis of accounting is used by all governmental fund types and agency funds. Under the modified accrual basis of accounting, revenues are recognized when susceptible to accrual (i.e., when they become both measurable and available.) "Measurable' means the amount of the transaction can be determined and "available' means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. The City considers revenue to be available if it is collected within 30 days after year-end. Expenditures are recorded when the related fund liability is incurred. Principal and interest on long- term debt are recorded as fund liabilities when due or when amounts have been accumulated in the debt service fund for payments to be made early in the following year. Those revenues susceptible to accrual are property taxes, franchise taxes, special assessments, licenses, interest revenue and charges for services. Sales taxes collected and held by the state at year-end on behalf of the City also are recognized as revenue. Fines and permit revenues are not susceptible to accrual because generally they are not measurable until received in cash. The accrual basis of accounting is utilized by proprietary funds. Under this method, revenues are recorded when 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 a liability for deferred revenue is removed from the combined balance sheet and revenue is recognized. 5. Encumbrances Encumbrances represent commitments related to unperformed contracts for goods or services. Encumbrance accounting is utilized in all funds. Encumbrances outstanding at the end of the year in the governmental funds are reported as reservations of fund balances and do not constitute expenditures or liabilities because the commitments will be carried forward and honored during the subsequent year. Encumbrances outstanding in the proprietary funds do not constitute expenses but will be honored in the subsequent year. 21 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 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. 22 City of Cape Girardeau. Missouri NOTES TO FINANCIAL STATEMENTS June 30. 1999 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 6. Budgets and Budgetary Accounting Additional budget appropriations by department made throughout the ,year are as follows: Administrative Services $ 115,000 .� Contingency 65,000 Developmental Services 7,500 Capital improvement Sales Tax -Flood Control Fund 265,000 FAU Street Project Fund 392,000 General Fund Transfers 65,000 Hazard Mitigation 170,000 Interdepartmental Services 82,920 Data Processing Internal Service Fund 50,000 Employee Fringe Benefit Fund 245,000 Parks and Recreation 45,000 Public Safety 93,800 Public works 527,359 $2 123 579 The above appropriations included the following: (1) $115,000 for the Airport Fund to cover .� construction of a smoke house at the airport restaurant and the purchase of a hanger (2) $65,000 to contingency expense in the General Fund to cover cleanup expenses from a May 17" storm (3) $7,500 to Vision 2000 Fund to cover additional operating expenses (4) $265,000 for the Capital Improvement Sales Tax (Flood Control) Fund to cover additional costs of the Middle Street drainage project (5) $392,000 for the FAU Street Projects Fund to cover additional costs of the Hopper Road bridge replacement (6) $65,000 increase in general fund transfers out to cover $10,000 cost of construction of smoke house in the Airport Fund and $55,000 in additional operating expenses in the Softball Complex Fund (7) $170,000 increase for grant funded hazard mitigation projects in the General Fund (8) $82,920 increase in interdepartmental services in the General Fund to cover $22,920 unexpected increased costs of the subsidized taxi coupon program and $60.000 additional internal salaries for capital projects (9) $50,000 for the purchase of various computer equipment (10) $245,000 for additional operating expenses in the Employee Fringe Benefits Fund (11) $45,000 for additional operating expenses in the Softball Complex Fund (12) $93,800 for public safety expenditures in the General Fund and Health Fund totaling $73,800 and $20,000 respectively (13) $527,359 for public works expenditures of $25,200 in the General Fund for replacement of Nash Road railroad crossing; $161,559 in the Solid Waste Fund to cover increased contract hauling and disposal and special hazardous waste disposal; $340,000 in the Water Fund to cover the costs of the Notre Dame High School water main extension and additional cost of the Twin Lake water system. Reductions of $60,000 and $18,050 were made to the respective budgets of Engineering and contingency in the General Fund. 23 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 6. Budgets and Budgetary Accounting - Continued -t For the yew ended June 30, 1999 the fund expenditures for Capital Improvement Sales Tax -Water Projects, Vision 2000, Park Improvements, Golf Course, Softball Complex, and Employee Fringe Benefit funds exceeded their approved budgets by $3,904, $576, $16,910, $3,451, $11,333, and $99,252, respectively. _ The Combined Statement of Revenues, Expenditures, and Changes in Fund Balance -All Governmental Fund Types reports revenues and expenditures on the modified accrual basis of accounting in accordance with GAAP. The Combined Statement of Revenues, Expenditures, and Changes in Fund Balance -Budget and Actual (Budget Basis) for all governmental fund types is prepared on a budgetary basis which includes encumbrances as expenditures. The following reconciliation adjusts GAAP basis to budget basis: Excess (Deficiency) of Revenues and Other Financing Sources over (under) Expenditures and Other Financintt Use Special Debt Capital General Revenue Service Projects GAAP Basis $ (263,298) $1,753,882 S 24,961 526,256,930 24 Increase due to Prior year encumbrances Administrative Services 22.305 15.941 - - Development services 11,550 - - - Parks and recreation 11,429 1-538 - - Public Safety 29,120 - - - Public Works 649 1,383,469 - - COPi al outlay - - - 941,729 Contract appropriated from next year's budget - - - - Advancerepayment 200,000 - - - Adjust investments to market 9,439 62,480 35,995 5,217 284,492 L463.428 35,995 946,946 Decrease due to Year-end encumbrances Administrative services 1,504 15,915 - - Development services 2,984 - - - Parks and recreation 8,270 1,265 - - Public safety 14.356 - - - Public works 23,001 471,327 - - Capital outlay - - - 1,892,052 Water Improvements Fund not budgeted annually - - - 25,418,890 Contract appropriated from last years budget 515,000 54115 1,003507 27,310,942 Budget Basis 5(28-921) 52.213.803 S 60.956 $ (107.066) 24 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 6. Budgets and Budgetary Accounting - Continued The individual proprietary schedules of comparing budget to actual is reported on a budgetary basis that uses the modified accrual basis of accounting with the exception of encumbrances. Encumbrances are reported as expenses in the year of encumbrance. Solid Golf Softball Sewer Water Waste Course Complex GA.APBusis 5 (566.518) $293,245 4218,180 $(32,578) $(20,869) Increase due to Prior year encumbrances Materials and supplies 1,421 345 87 - 800 Contractual services - 367 - - - General operating expenses - - - 246 Capital outlay 3,120,291 528,633 5,173 - - Special projects 22,296 - 7,500 - - Depreciation 1,069,495 441,554 206,012 62,592 8,506 Impact fees 190,488 - - - - Special assessments 20,710 - - - Interest paid less than accrued 143,748 - - - - Interest cost amortized 803,711 - - - - Cost of bond refunding amortization 20,394 43,914 633 - - Amortizedbondpremiumidiscount 1,206 607 75 - - Issv¢nce cost amortization 67,563 26,213 2,275 - Asset dispositions - 16,377 2,780 - - Adjustinvestmentstomarket 13.227 36,116 7,508 357 34 5.474550 1,094,126 232.043 63,195 9.340 Decrease due to Year-end encumbrances Materials and supplies - 2.053 638 4.085 327 Contractual services 4,301 37,238 15,718 1,460 - Capital outlay 2,258 386 201,568 4,650 - - Special projects - - - - 273 Landfill closure and maintenance costs - - 4,954 - Interest paid more than accrual - 7,475 2,466 - - Bond principal paid 841,277 475,950 386,172 - Capital outlays 4,796,170 855250 8,512 77,479 - Amount deferred for future debt service for capital appreciation bonds: Construction fund 111,504 - - - - Interest subsidy received. 619,431 - - - - Adjustment to liability for future landfill postclosure maintenance costs - - 66.846 - - Deferred revenues 54 6.666 71125 - - V 8,631,223 1.586100 56L681 83.014 600 Budget Basis5(3,723.191) 5 C198,829)4(I 11,458) 5 >I-2.397) $(12129) 25 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE A - SUMMARY" OF SIGNIFICANT ACCOUNTING POLICIES - Continued + 6. Budgets and Budgetary Accounting - Continued 26 Net Income ( Loss) Data Fleet Employee Risk Equipment Pme ssln Mana,ement F= manaRement Replacement GAAP Basis $(65,069) $23,739 S(144,942) S159,867 S 542,365 Increase due to: _ Prior year encumbrances Material and supplies 115 45 - - - Contractual services 17 - - - - ,� Capital outlays 227,457 3,825 - - - Depreciation 194,865 42,531 - - 140,126 Interest paid less than accrued - - - - 104 Issuance cost amortization 2,612 - - - 2,545 Amortized bond premium/discount 89 - - - 99 Adjust investment to market 431 60 4,028 6,664 1,133 425,586 46,461 4,028 6,664 144,007 Decrease due to: Year-end encumbrances Materials and supplies - 731 - - - Contractual services 58 - - - - Capital outlays 84,466 7,200 - - 148,291 Interest paid more than accrued 954 2 - - - Principal paid 55,000 424 - - 55,000 _ Capital outlays 256,757 22,241 321,859 397,235 30,598 525,150 Budget Basis $(36,718) S 39,602 $(140,914) S166.531 5161,222 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. 26 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS a June 30, 1999 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued S. Compensated Absences Vested or accumulated vacation pay for proprietary funds is recorded as an expense and liability of those funds as the benefits accrue to employees. Amounts of vested or accumulated vacation leave of governmental funds that are not expected to be liquidated within the current year are reported in the general long-term debt account group. Employees may accumulate up to 30 days vacation, for which they we compensated upon termination or retirement. Employees are not compensated for accumulated sick leave upon termination or retirement. 9. Bond Discounts/Issuance Costs In governmental fund types, bond discounts and issuance costs are recognized in the current period. Bond discounts and issuance costs for proprietary fund types are deferred and amortized over the term of the bonds. Bond discounts are presented as a reduction of the face amount of bonds payable whereas issuance costs are recorded as deferred charges. 10. Total Columns - Memorandum Ord 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. Interfund eliminations have not been made in the aggregation of this data. 11. Cash and Investments The city maintains an internal investment pool for the majority of its non -restricted cash and investments and a small portion of its restricted cash and investments. Investment revenue is allocated to each fund based on its average equity balance in the pool. Cash includes amounts in repurchase agreements and other short-term investments with a maturity date within three months of the date of purchase. 27 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 11. Cash and Investments Continued The City's investment policy authorizes it to invest its available operating and reserve funds in (1) obligations of the United States or its agencies and 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 securities dealers. All other cash and investments are valued at cost or amortized cost. 12. Comparative Data Comparative totals for the prior year have been presented in the accompanying financial statements in order to provide an understanding of changes in the City's financial position and operations. However, presentation of prior year totals by fund type have not been presented in each of the statements since their inclusion would make the statements unduly complex and difficult to read. 13. Prepaid Items Payments made to vendors for services that will benefit periods beyond June 30, 1999 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. 28 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued r 15. Long-term Obligations Long-term debt is recognized as a liability of a governmental fund when due, or when resources have been accumulated in the debt service fund for payment early in the following year. For other longterm 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 longterm debt account group. Long-term liabilities expected to be financed from proprietary fund operations are accounted for in the appropriate proprietary fund. 16. Interfund Transactions Quasi -external transactions are accounted for as revenues, expenditures or expenses. Transactions that constitute reimbursements to a fund for expenditures/expenses initially made from it that are properly applicable to another fund, are recorded as expenditures/expenses in the reimbursing fund and as reductions of expenditures/expenses in the fund that is reimbursed. All other interfund transactions, except quasi -external transactions and reimbursements, are reported as transfers. Nonrecurring or nonroutine permanent transfers of equity are reported as residual equity transfers. All other interfund transfers are reported as operating transfers. 17. Short-term Interfund Receivables/Payables During the course of operations, numerous transactions occur between individual funds for goods provided or services rendered. These receivables and payables are classified as "due from other funds" or "due to other funds" on the balance sheet. Short-term interfund loans are classified as "interfund receivables/payables". .� 18. Advances to Other Funds Noncurrent portions of long-term interfund loan receivables are reported as advances and are offset equally by a fund balance reserve account which indicates that they do not constitute expendable available financial resources and therefore are not available for appropriation. 29 City oCCape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE A - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued 19. Post -Employment Health Care Benefits In addition to the pension benefits described in Note FE it is the City's policy to provide postretirement health care benefits to employees who retire from the City with five or more years of service and who are eligible for LAGERS retirement (Note H). Currently, twenty-one employees meet those eligibility requirements. The City provides health care coverage for them until age 65. The cost of retirees' health care benefits is recognized as an expenditure as premiums are paid. For the year ending June 30, 1999, those costs totaled $47,064. COBRA Benefits - Under the Consolidated Omnibus Budget Reconciliation Act (COBRA), the City provides health care benefits to eligible former employees and eligible dependents. Certain requirements are outlined by the federal government for this coverage. The premium is paid in full by the insured on or before the tenth (10th) day of the month for the actual month covered. This program is offered for a duration of 18 months after the termination date. There is no associated cost to the City under this program, and there were two participants in the program as of June 30, 1999. NOTE B - DEPOSITS AND INVESTMENTS 1. Deposits At June 30, 1999, the carrying amount of the City's deposits was $8,547,202 and the bank balance was $8,541,330 which excludes $5,872 of petty cash funds held at various City locations. The deposits are categorized in accordance with risk factors created by governmental reporting standards. a Carrying Bank Amount Balance Category #1 $8,182,877 $8,182,877 Category 92 159,481 153,609 Category 93 204,844 204,844 $8,547,202 $8,541330 Category 91 includes deposits covered by deposit insurance or collateral held by the City in the City's name. Category #2 includes deposits covered by collateral held by the financial institution's trust department in the City's name. Category 03 includes deposits which are uncollateralized or the collateral is held by the financial institution's trust department but not in the City's time. 30 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30. 1999 NOTE B - DEPOSITS AND INVESTMENTS - Continued 2. Investments Investments made by the City are summarized below. The investments that are represented by specific identifiable investment securities me classified as to credit risk by the three categories described below: Category At 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 93 Uninsured and unregistered, with securities held by the counter -party, or by its department or agent but not in the City's time. Category Carrying Fair 41 42 43 Value Value .. Repurchase Agreements $ 2,364,290 $- $- $ 2,364,290 $ 2,364,290 U.S. Government Securities 17,114,566 17,114.566 17,114,566 $19,478,856 $- $- 19,478,856 19,478,856 Money Market Account U.S. Government Securities 1,922,031 1,922,031 State Revolving Fund Program 36,022,456 36,022,456 $57,423,343 557,423,343 31 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS ,r June 30, 1999 NOTE C - PROPERTY TAXES Property taxes attach as an enforceable lien on property as of January 1. Taxes were levied on August 17, 1998, for collection during this fiscal year and were due on or before December 31. Most of the y taxes are collected in November and December. The tax rates assessed at the time were as follows: 32 City Revenue $ .32/100.00 assessed valuation Library Tax .17/100.00 assessed valuation Public Health Tax .06/100.00 assessed valuation Debt Service Tax .10/100.00 assessed valuation Special Business District .79/100.00 assessed valuation 42 (Ad Valorem) Property tax receivable balances as of June 30, 1999 are as follows: Downtown .� Business Debt General District Health Service Library Total Current property tax $32,387 $ 468 $ 6,121 $10,270 $16,956 $66,202 Delinquent property tax 34,766 714 5,417 11,304 16,794 68,995 Reserve for doubtful Property taxes 23,523 (85)(3,417) (7,519)11,129 4( 5,673) Net property tax receivable $43,630 $ 1,097 $ 8.121 $14.055 $22,621 $89524 NOTE D - CHANGES IN FIXED ASSETS A summary of the general fixed assets account group for the year ended June 30, 1999 is as follows: Balance Accumulated Balance July I, 1998 Additions Deductions Depreciation lune 30, 1999 Land $ 2,086,593 $- $- $- S 2,086,593 Buildings 8,795.255 115,356 - 390,653 8,519,958 Improvements other Than buildings 4,328,851 41,127 - 255,497 4,114,481 Equipment 1,472,472 147,390 68,620 256,977 1294,265 Construction in progress 22,344 14,426 13,793 22,977 Total general fixed assets $16,705,5 15 $ 318,299 $ 82,413 5903,127 $16,038,274 32 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE D - CHANGES IN FIXED ASSETS - Continued Additions and deletions to the Enterprise Funds for the fiscal year 1999 were $7,706,112 and $104,807 respectively. Additions and deletions to the Intemal Service Funds were $873,159 and $0 respectively. A summary of the proprietary fund type fixed assets for the year ended June 30, 1999 is as follows: Enterprise Internal Fund Service Fund Land $ 248,109 $ 37,500 Buildings 9,168,573 421,821 Improvements other than building 43,732,315 113,749 Equipment 7,463,345 3,221,266 Construction in progress 11,752,757 10,234 $72,365,099 $ 3,804,570 Less: accumulated depreciation 16,825,325 1,805,128 $55,539,774 $ 1 999,442 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, 1999. General Leaehold Certificates Obugmion Revenue Or Revenue Unused Paid Due In Giber [fonds Bonds Panicipmion Bonds Leave Governments Tmal Gencml long-¢rm debt payable at July 1, 1998 %2.940.000 $6,132,230 $5,295,000 - $561051 539.125 $14.969.406 Rcuremcmu (345,000) (1,"!12,314) (450,000) - (12.795) (2,520,109) Amount Added 350.000 39.116 25884.116 Geneva) lone -term _21495,000 debt payable at June 30, 1999 $2,395D00 $4.769.916 $4.845,000 $25491DDD $602.167 526.330 $38.03,413 33 Principal payments are made annually on November 1, and interest payments are made semi-annually on May I and November 1. 34 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE E - LONGTERM OBLIGATIONS - Continued The following is a summary of bond transactions in the Proprietary Funds of the City for the year ended June 30, 1999. a Leasehold Certificates Revenue Revenue of Bonds Bonds Participation Total Bonds payable at July 1,1998 $41,845,408 $1,604,785 $3,809,124 $47,259,317 Discount Amortization & Issue Cost 54,896 11,933 188 67,017 Bonds Issued - - - - Accumulated Interest 803,711 - - 803,711 Bonds Retired (573,000)62( 7,686) 360,000 (1,560,686) Bonds payable at June 30, 1999 $42,131,015 $989,032 $3,449,312 $46,569,359 Bonds payable at June 30, 1999 are comprised of the following individual issues. $ 2,395,000 1993 General Obligation Refunding Bonds due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total 2000 4.50% $355,000 $108,488 $463,488 2001 4.70 370,000 91,805 461,805 2002 4.90 390,000 73,555 463,555 2003 5.00 405,000 53,875 458,875 2004 5.00 425,000 33,125 458,125 2006 5.00 450,000 11,250 461,250 $2,395,000 $ 372 098 $2,767,098 Principal payments are made annually on November 1, and interest payments are made semi-annually on May I and November 1. 34 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE E - LONG TERNI OBLIGATIONS - Continued On April 20, 1993, the City of Cape Girardeau issued $3,690,000 of General Obligation Refunding Bonds Series 1993 with interest rates varying from 3.75% to 5.50%. The refunding bonds constitute general obligations of the City and 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. These bonds are dated September I, 1993. The proceeds of the bond issue were used to defease (in - substance) the $1,170,000 1986 Sewerage System Revenue Bonds. Principal payments are made annually on March 1, and interest payments are made semi-annually on Much 1, and September 1. 35 $ 875,000 Series 1993 Sewerage System Revenue Bonds due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total + 2000 4.800% $100,000 $ 45,431 $ 145,431 2001 5.000 110,000 40,631 150,631 2002 5.125 115,000 35,131 150,131 2003 5.250 120,000 29,238 149,238 2004 5.300 135,000 22,938 157,938 2005 5.350 140,000 15,783 155,783 2006 5.350 155.000 8,293 163.293 $ 875,000 $ 197,445 $ 1,072,445 These bonds are dated September I, 1993. The proceeds of the bond issue were used to defease (in - substance) the $1,170,000 1986 Sewerage System Revenue Bonds. Principal payments are made annually on March 1, and interest payments are made semi-annually on Much 1, and September 1. 35 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 1, and interest payments we 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. 36 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 2.780.000 Waterworks System Revenue Bonds Series 1992 due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total i 2000 5.90% $ 320,000 $ 191,048 $ 511,048 2001 6.00 370,000 172,167 542,167 2002 6.10 425,000 149,968 574,968 2003 7.45 485,000 124,042 609,042 2004 7.45 555,000 87,910 642,910 2005 7.45 625,000 46,563 671,563 $2,780,000 $ 771,698 $3,551,698 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 1, and interest payments we 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. 36 Principal payments we made annually on March 1, and interest payments are made semi-annually on March l and September 1. On December 1, 1995 the City of Cape Girardeau issued $9,095,000 of Waterworks System Refunding Revenue Bonds Series 1995 with interest rates varying from 3.9% to 5.2%. The bonds are special limited obligations of the City payable solely from the net income and revenues derived by the City from the operation of the Waterworks System after payment of costs of operation and maintenance. The bonds were issued to provide the City with funds to defease $8,090,000 principal amount of Waterworks System Revenue Bonds, Series 1992. The City transferred net proceeds of $8,711,864 to Mercantile Bank of St. Louis National Association, St. Louis, Missouri (the "Escrow Agent"), for deposit into an Escrow Fund established under an Escrow Trust Agreement dated December 1, 1995 (the "Escrow Trust Agreement') between the City and the Escrow Agent. The proceeds were used to purchase direct obligations of, or obligations the principal of and interest on which are unconditionally guaranteed by, the United States of America. The refunded bonds shall be payable from the maturing principal of the Escrowed Securities, together with the earnings thereon for the period beginning March 1. 1996, and continuing through March 1, 2002, the date on which the Refunded Bonds will be redeemed. 37 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 8.710.000Waterworks System Refunding Revenue Bonds Series 1995 due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total 2000 4.300% $ 80,000 $ 433,907 $ 513,907 2001 4.400 85,000 430,468 515,468 2002 4.500 90,000 426,727 516,727 2003 4.500 90,000 422,678 512,678 2004 4.600 95,000 418,627 513,627 2005 4.750 100,000 414,258 514,258 _ 2006 4.875 810,000 409,507 1,219,507 2007 5.000 890,000 370,020 1,260,020 2008 5.000 980,000 325,520 1,305,520 2009 5.200 1,010,000 276,520 1,286,520 2010 5.000 1,065,000 224,000 1,289,000 .. 2011 5.000 1,120,000 170,750 1,290,750 2012 5.000 2,295,000 114,750 2,409,750 $8,710,000 $4,437,732 $13,147,732 Principal payments we made annually on March 1, and interest payments are made semi-annually on March l and September 1. On December 1, 1995 the City of Cape Girardeau issued $9,095,000 of Waterworks System Refunding Revenue Bonds Series 1995 with interest rates varying from 3.9% to 5.2%. The bonds are special limited obligations of the City payable solely from the net income and revenues derived by the City from the operation of the Waterworks System after payment of costs of operation and maintenance. The bonds were issued to provide the City with funds to defease $8,090,000 principal amount of Waterworks System Revenue Bonds, Series 1992. The City transferred net proceeds of $8,711,864 to Mercantile Bank of St. Louis National Association, St. Louis, Missouri (the "Escrow Agent"), for deposit into an Escrow Fund established under an Escrow Trust Agreement dated December 1, 1995 (the "Escrow Trust Agreement') between the City and the Escrow Agent. The proceeds were used to purchase direct obligations of, or obligations the principal of and interest on which are unconditionally guaranteed by, the United States of America. The refunded bonds shall be payable from the maturing principal of the Escrowed Securities, together with the earnings thereon for the period beginning March 1. 1996, and continuing through March 1, 2002, the date on which the Refunded Bonds will be redeemed. 37 City of Cape Girardeau. Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 2,130 000 Sewerage System Revenue Bonds (State Revolving Fund Program) Series 1991 due as follows: r Year Ending Interest Principal Interest June 30 Rate Due Due Total 2000 6.300% S 85,000 $ 144,834 $ 229,834 2001 6.400 95,000 139,479 234,479 2002 6.500 100,000 133,399 233,399 2003 6.600 105,000 126,899 231,899 2004 6.875 110,000 119,969 229,969 _ 2005 6.875 120,000 112,406 232,406 2006 6.875 130,000 104,156 234,156 _ 2007 6.875 135,000 95,219 230,219 2008 6.875 145,000 85,937 230,937 2009 6.875 155,000 75,969 230,969 2010 6.875 165,000 65,312 230,312 2011 6.875 175,000 53,969 228,969 2012 6.875 190,000 41,937 231,937 2013 6.875 205,000 28,875 233,875 2014 6.875 215,000 14,781 229,781 $2,130,000 $1,343,141 $3473,141 These bonds are dated December 1, 1991. The proceeds of the bond issue will be used to extend and improve the existing sewerage facilities serving the City. Principal payments are made annually on June 1, and interest payments are made semi-annually on June 1 and December 1. The interest due on the 1991 Sewer System Revenue Bonds will be subsidized by interest earnings on a reserve fund held by the bond issue's trustee. As the City is reimbursed for sewer project expenditures from the construction funds held by the trustee, the Department of Natural Resources deposits an amount equal to approximately 51.907% of the reimbursement into the reserve fund. The maximum amount of funds that will be advanced to the reserve fund will be $1,250,000. As bonds are paid off 50% of the amount of bonds paid off will be repaid to the Department of Natural Resources out of the reserve fund. The balance of the reserve fund at June 30, 1999 was $712,798. The reserve fund yields 6.71%. 38 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 433,000 Sewerage System Revenue Bonds (State Revolving Fund Program) Series 1993 due as follows: These bonds are dated August 1, 1993. The proceeds of the bond issue were used to extend and improve the existing sewerage facilities serving the City. Principal payments are made annually on March 1, and interest payments are made semi-annually on March 1 and September 1. The interest due on the 1993 Sewer System Revenue Bonds will be subsidized by interest earnings on a reserve fund held by the bond issue's trustee. As the City is reimbursed for sewer project expenditures from the construction funds held by the trustee, the Department of Natural Resources 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, 1999 was $310.909. The reserve fund yields 5.15%. 39 Year Ending Interest Principal Interest June 30 Rate Due Due Total 2000 4.250% $ 19,000 $ 21,739 $ 40,739 2001 4.400 19,000 20,917 39,917 2002 4.550 20,000 20,044 40,044 2003 4.700 21,000 19,096 40,096 2004 4.800 22,000 18,074 40,074 _ 2005 4.900 23,000 16,983 39,983 2006 5.000 24,000 15,819 39,819 _ 2007 5.100 25,000 14,582 39,582 2008 5.200 27,000 13,242 40,242 2009 5.250 28,000 11,805 39,805 2010 5.400 30,000 10,260 40,260 2011 5.400 31,000 8,613 39,613 2012 5.400 33,000 6,885 39,885 2013 5.400 35,000 5,049 40,049 2014 5.400 37,000 3,106 40,106 2015 5.400 39,000 1.053 40,053 $ 433.000 $ 207,267 $ 640,267 These bonds are dated August 1, 1993. The proceeds of the bond issue were used to extend and improve the existing sewerage facilities serving the City. Principal payments are made annually on March 1, and interest payments are made semi-annually on March 1 and September 1. The interest due on the 1993 Sewer System Revenue Bonds will be subsidized by interest earnings on a reserve fund held by the bond issue's trustee. As the City is reimbursed for sewer project expenditures from the construction funds held by the trustee, the Department of Natural Resources 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, 1999 was $310.909. The reserve fund yields 5.15%. 39 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 11,419,302 Water Pollution Control Revenue Bonds (State Revolving Fund Program) Series 1995D due as follows: These bonds are dated June 1, 1995. The proceeds of the bond issue will be used for the extension and improvement of the existing sewerage system serving the City. Principal and interest payments will be made annually on January I beginning in the year 1998. The interest due on the 1995D Water Pollution Control Revenue Bonds will be subsidized by interest �— earnings on a reserve fund held by the bond issue's trustee. As the City is reimbursed for sewer project expenditures from the construction funds, the Department of Natural Resources will deposit an amount equal to 70% of the disbursement into the reserve fund. The maximum amount of funds that will be advanced to the reserve fund will be 70% of the principal amount less the original issue discount. As bonds are paid off 70% of the amount of bonds will be repaid to the Department of Natural Resources out of the reserve fund. The balance of the reserve fund at June 30, 1999 was $7,962,647. 40 Year Ending Interest Principal Interest June 30 Rate Due Due Total 2000 4.950% $ 20,057 $ 4,943 $ 25,000 2001 5.100 913,209 291.791 1,205,000 2002 5.250 913,677 366,323 1,280,000 2003 5.300 918,381 441,619 1360,000 2004 5.400 924,769 530,231 1,455,000 2005 5.500 928,413 626,587 1,555,000 2006 5.650 932,824 742,176 1,675,000 2007 5.750 937,566 862,434 1,800,000 2008 5.850 943,267 996,733 1,940,000 2009 5.950 946,770 1,143,230 2,090,000 2010 6.050 722,409 992,591 1,715,000 2011 6.100 413,574 636,426 1,050,000 2012 6.150 380,828 654,172 1,035,000 2013 6.150 354,978 670,022 1,025,000 2014 6.200 326,281 683,719 1,010,000 2015 6.200 303,920 696,080 1,000,000 2016 6.250 278,844 706,156 985,000 2017 6.250 259,535 715.465 975,000 $11,419,302 $11.760,698 $23,180,000 These bonds are dated June 1, 1995. The proceeds of the bond issue will be used for the extension and improvement of the existing sewerage system serving the City. Principal and interest payments will be made annually on January I beginning in the year 1998. The interest due on the 1995D Water Pollution Control Revenue Bonds will be subsidized by interest �— earnings on a reserve fund held by the bond issue's trustee. As the City is reimbursed for sewer project expenditures from the construction funds, the Department of Natural Resources will deposit an amount equal to 70% of the disbursement into the reserve fund. The maximum amount of funds that will be advanced to the reserve fund will be 70% of the principal amount less the original issue discount. As bonds are paid off 70% of the amount of bonds will be repaid to the Department of Natural Resources out of the reserve fund. The balance of the reserve fund at June 30, 1999 was $7,962,647. 40 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE E - LONG-TERM OBLIGATION - Continued $ 13,535,000 Sewerage System Revenue Bonds (State Revolving Fund Program) Series 1996 due as follows: The interest due on the 1996 Sewerage System Revenue Bonds will be subsidized by interest earnings on a reserve fund held by the bond issues trustee. As the City is reimbursed for sewer project expenditures from the construction funds, the Department of Natural Resources will deposit an amount equal to 70% of the disbursement into the reserve fund. The maximum amount of funds that will be advanced to the reserve will be $9,474,500. As bonds are paid off 70% of the amount of bonds will be repaid to the Department of Natural Resources out of the reserve fund. The balance of the reserve fund at June 30, 1999 was $4,576,811. 41 Year Ending Interest Principal Interest June 30 Rate Due Due Total 2000 4.500% $ 25,000 $ 760,761 $ 785,761 2001 4.650 25,000 759,636 784,636 2002 4.800 575,000 758,474 1,333,474 2003 4.900 585,000 730,874 1,315,874 2004 5.000 590,000 702,209 1,292,209 2005 5.150 600,000 672,709 1,272,709 2006 5.250 610,000 641,809 1,251,809 2007 5.350 690,000 609,784 1,299,784 2008 5.500 700,000 572,869 1,272,869 2009 5.600 715,000 534,369 1,249,369 2010 5.700 730,000 494,329 1,224,329 2011 5.875 745,000 452,719 1,197,719 2012 5.875 765,000 408,950 1,173,950 2013 5.875 780,000 364,006 1,144,006 2014 5.875 800,000 318,181 1,118,181 2015 5.875 875,000 271,181 1,146,181 2016 5.900 895,000 219,775 1,114,775 2017 5.900 920,000 166,970 1,086,970 2018 5.900 945,000 112,690 1,057,690 2019 5.900 965,000 56,935 1,021,935 $13,535.000 $9,609230 $23,144,230 ,r These bonds are dated June 1, 1996. The proceeds of the bond issue will be used for the extension and improvement of the existing sewerage system serving the City. Principal payments will be made annually on January 1 beginning in the year 2000. Interest is paid semi-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 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 advanced to the reserve will be $9,474,500. As bonds are paid off 70% of the amount of bonds will be repaid to the Department of Natural Resources out of the reserve fund. The balance of the reserve fund at June 30, 1999 was $4,576,811. 41 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE E - LONG-TERM OBLIGATION - Continued $25,495,000 Waterworks System Revenue Bonds ( State Revolving Fund Program) Series 1998 due as follows: Year Ending Interest Principal Interest ' June 30 Rate Due Due Total _ 2000 3.450% $ 560,000 $ 1,283,357 $ 1,843,357 2001 3.650 660,000 1,165,317 1,825,317 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 2006 4.000 870,000 1,024,995 1,894,995 2007 4.100 920,000 990,195 1,910,195 2008 4.200 1,000,000 952,475 1,952,475 2009 4.300 1,025,000 910,475 1,935,475 2010 4.375 1,080,000 866,400 1,946,400 2011 5.250 1,110,000 819,150 1,929,150 2012 5.250 1,215,000 760,875 1,975,875 2013 5.250 1,300,000 697,087 1,997,087 2014 5.250 2,350,000 628,838 2,978,838 _ 2015 5.250 2,445,000 505,462 2,950,462 2016 5.250 2,550,000 377,100 2,927,100 2017 4.500 2,655,000 243,225 2,898,225 2018 4.500 2,750,000 123,750 2,873,750 $25,495,000 $15,749,914 $41,244,914 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 1 and July 1 beginning on July 1, 1999. The interest due on the 1998 Waterworks System Revenue Bonds will be subsidized by interest earnings on a reserve fund held by the bond issues trustee. As the City is reimbursed for waterworks system expenditures from the construction funds, the Department of Natural Resources will deposit an amount equal to 33.41% of the disbursement into the reserve fund. The maximum amount of funds that will be advanced to the reserve will be $8,517,235. As bonds are paid off, 33.41% of the amount of bonds will be repaid to the Department of Natural Resources out of the reserve fund. The balance of .. the reserve fund at lune 30, 1999 was $547,410. 42 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE E - LONG-TERM OBLIGATION - Continued $ 5,425,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 2000 4.400% $ 2,915,000 $ 246,485 $ 3,161,485 2001 4.500 705,000 118,225 823,225 2002 4.625 720,000 86,500 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 $5,425,000 $ 561,660 $5,986,660 The bonds are obligations of the Cape Girardeau (Missouri) Public Facilities Authority (CGPFA). The CGPFA has entered into a Lease Purchase Agreement with the City of Cape Girardeau, Missouri. Principal and interest will be paid by CGPFA from rental and other receipts from the City. The purpose of the bonds was to (1) pay the costs of various street improvements for the City, (2) defease $10,410,000 outstanding principal amount of Building and Equipment Leasehold Revenue Bonds of the Authority and (3) pay the costs of issuance of the Series 1993 Bonds. The bond principal is allocated as follows: $1,005,084 - Sewer Fund; and $4,419,916 - General Long- term Debt Account Group. Principal payments are made annually on March l and interest payments are made semi-annually on March 1 and September 1. 43 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE E - LONG-TERNI OBLIGATION - Continued $350 000 City of Cape Girardeau, Missouri Lease Purchase Agreement dated June 17 1999 due as follows: Year Ending Interest Principal Interest June 30 Rate Due Due Total 2000 5.000% $ 22,000 $ 13,806 $ 35,806 2001 5.000 23,000 16,400 39,400 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 $350,000 $ 120.456 $ 470,456 The bonds are the obligations 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 propose of the bonds 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 bond principal is allocated $350,000 to the General Long -Term, Debt Account Group. Principal payments are made annually on April 1 and interest payments are made semi-annually on April 1 and October 1. 44 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 2,685,000 Certificates of Participation (Convention and Visitors Recreation Facilities Project) Series 1993. Year Ending Interest Principal Interest June 30 Rate Due Due Total 2000 4.700% $ 295,000 $ 135,013 $ 430,013 2001 4.800 345,000 121,148 466,148 _ 2002 5.000 400,000 104,588 504,588 2003 5.000 455,000 84,588 539,588 2004 5.125 510,000 61,838 571,838 2005 5.250 680,000 35,700 715,700 ,. $ 2,685,000 $ 542,875 $3,227,875 The certificates are obligations of the City of Cape Girardeau, Missouri. Under a Lease Purchase Agreement between the City and the Cape Girardeau (Missouri) Public Facility Authority (the "Corporation"), the Corporation will assign the right to receive rental and other receipts from the City to Union Planters Bank of Cape Girardeau County ( the "Trustee"). The purpose of the 1993 Series certificates is for the acquisition, construction, furnishing, and equipping of a convention and recreational center, softball and soccer fields, and improvements to the City Hall. The bond liability for the Series 1993 certificates is recorded in the General Long -Term Debt Account Group. Principal payments are made annually on April 1, and interest payments are made semi-annually on April 1, and October 1. 45 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30. 1999 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 2,790,000 Certificates of Participation (Twin Lakes Project), Series 1994A. Year Ending Interest Principal Interest June 30 Rate Due Due Total 2000 5.000% $ 255,000 $ 146,260 $ 401,260 2001 5.100 260,000 133,255 393,255 2002 5.200 275,000 119,475 394,475 2003 5.350 280,000 104,835 384,835 2004 5.450 290,000 89,443 379,443 2005 5.550 300,000 73,215 373,215 2006 5.650 310,000 56,132 366,132 2007 5.750 600,000 30,125 630,125 2008 5.800 70,000 10,845 80,845 2009 5.850 70,000 6,768 76,768 2010 5.900 80,000 2,360 82,360 $2,790,000 $ 772,713 $3,562,713 The certificates are obligations of the City of Cape Girardeau, Missouri. Under a Lease Purchase Agreement between the City and the Cape Girardeau (Missouri) Public Facilities Authority (the "Corporation'), the Corporation will assign the right to receive rental and other receipts from the City to Union Planters Bank of Cape Girardeau County (the "Trustee"). The purpose of the 1994A Series certificates is to (1) pay the costs of certain improvements to the City's waterworks and sewerage systems and costs associated with the closing of a City waste disposal site, (2) establish a debt service reserve fund for the Series 1994A Certificates, and (3) pay the costs of issuance of the Series 1994A Certificates. The bond liability for the Series 1994A Certificates is recorded in the Sewer, Water, and Solid Waste Funds. Principal payments are made annually on October 1, and interest payments are made semi-annually on April I and October I. 46 ' City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 2.205,000 Certificates of Participation (Capital Improvements Projects), Series 1997A. Year Ending Interest Principal Interest June 30 Rate Due Due Total 2000 4.625% $ 245,000 $ 107,594 $ 352,594 2001 4.750 255,000 96,262 351,262 2002 4.800 270,000 84,150 354,150 2003 4.900 275,000 71,190 346,190 2004 4.900 285,000 57,715 342,715 2005 5.000 490,000 43,750 533,750 2006 5.000 50,000 19,250 69,250 2007 5.000 335,000 16,750 351,750 $2,205,000 $ 496,661 $2,701,661 The certificates are obligations of the City of Cape Girardeau, Missouri under a Lease Purchase Agreement between the City and the Cape Girardeau (Missouri) Public Facilities Authority (the "Corporation'), the Corporation will assign the right to receive rental and other receipts from the City to Union Planters National Bank (the "Trustee"). The purpose of the 1997A Series certificates is to (1) pay the costs of completing the construction, furnishing and equipping of a convention and recreational facility that constituted part of the 1993 project, (2) pay the costs of acquiring, constructing, furnishing and equipping various equipment and capital improvement projects, (3) fund the debt service requirements for the Series 1997A Certificates, and (4) pay the costs of issuance of the Series 1997A Certificates. The bond liability for the Series 1997A Certificates is recorded in the General Long -Term Debt Account Group, Data Processing and the Equipment Replacement Fund. Principal payments are made annually on April 1, and interest payments are made semi-annually on April 1 and October 1. 47 The certificates are obligations of the City of Cape Girardeau, Missouri under a Lease Purchase Agreement between the City and the Cape Girardeau (Missouri) Public Facilities Authority (the "Corporation"), the Corporation will assign the right to receive rental and other receipts from the City to Union Planters National Bank (the "Trustee"). The purpose of the 1997B Series certificates is to (1) defease $755,000 outstanding principal amount of Cape Girardeau (Missouri) Public Facilities Authority, Building and Equipment Leasehold Revenue Bonds (Airport Improvement Project) Series 1990B, and (2) pay the costs of issuance of the Series 1997B Certificates. The bond liability for the Series 19978 Certificates is recorded in the General Long -Term Debt Account Group. Principal payments are made annually on April 1, and interest payments are made semi-annually on April I and October 1. 48 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE E - LONG-TERM OBLIGATIONS - Continued $ 615,000 Certificates of Participation (Capital Improvements Projects). Series 1997B. Year Ending Interest Principal Interest June 30 Rate Due Due Total 2000 4.700% $ 80,000 $ 30,270 $ 110,270 2001 4.800 80,000 26,510 106,510 2002 4.900 80,000 21670 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 $615,000 $ 122,950 $ 737,950 The certificates are obligations of the City of Cape Girardeau, Missouri under a Lease Purchase Agreement between the City and the Cape Girardeau (Missouri) Public Facilities Authority (the "Corporation"), the Corporation will assign the right to receive rental and other receipts from the City to Union Planters National Bank (the "Trustee"). The purpose of the 1997B Series certificates is to (1) defease $755,000 outstanding principal amount of Cape Girardeau (Missouri) Public Facilities Authority, Building and Equipment Leasehold Revenue Bonds (Airport Improvement Project) Series 1990B, and (2) pay the costs of issuance of the Series 1997B Certificates. The bond liability for the Series 19978 Certificates is recorded in the General Long -Term Debt Account Group. Principal payments are made annually on April 1, and interest payments are made semi-annually on April I and October 1. 48 The cash available to service Revenue Bonds are $3,026,649 and $1,117,501 for the Sewer Fund and Water Fund respectively. 49 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30. 1999 NOTE E - LONG-TERM[ OBLIGATIONS - Continued The annual requirements to amortize all debt outstanding as of June 30, 1999 including total interest payments of $47,066,538 are as follows: General Leasehold Certificates Year Ending Obligation Revenue Revenue of June 30 Bonds Bonds Bonds Participation Total 2000 $ 463,488 $ 4,095,077 $ 3,197,291 $ 1,294,137 $ 9,049,993 2001 461,805 5,297,615 862,625 1,317,175 7,939,220 2002 463,555 5,964,971 845,750 1,355,883 8,630,159 2003 458,875 6,063,992 512,250 1,374,363 8,409,480 2004 458,125 6,189,152 258,050 1,393,496 8,298,823 2005 461,250 6,309,097 543,450 1,837,915 9,151,712 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,567361 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 $ 2767,098 $109,454,427 $ 6,457,116 $10230,199 $128,908,840 The cash available to service Revenue Bonds are $3,026,649 and $1,117,501 for the Sewer Fund and Water Fund respectively. 49 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE E - LONG-TERNI OBLIGATIONS - Continued The cash available to service the Leasehold Revenue Bonds in the Enterprise Funds and the General Long-terrn Debt Account Group are $290,920 and $1,936,940 respectively. The cash available to service the Certificates of Participation in the Proprietary Funds and the General Long-term Debt Account Group are $486,534 and $890366 respectively. Included in restricted cash on the balance sheet of the Proprietary Funds is $9,791,297 which is the balance in the various project accounts which represent incomplete projects at June 30 1999. If the project funds are not used, the remaining balance can be applied against debt. The City is in compliance with all significant limitations and restrictions contained in the various bond indentures. During the fiscal year ended June 30, 1996, the City defeased (in -substance) $8,090,000 of Water Revenue Bonds. New debt was issued and the proceeds were used to purchase U.S. government securities that were placed in trust funds. The investments and fixed earnings from the investments are sufficient to fully service the defeased debt until the debt is called at par on March 1, 2002. For financial reporting purposes, the debt has been considered defeased and therefore removed as a liability on the face of the balance sheets In June 1997 the City of Cape Girardeau issued Certificates of Participation to defease (in -substance) $755,000 of Building & Equipment Leasehold Bonds, Series 1990B. On September I, 1997 the refunded bonds were called for redemption at a price of 1005%. As a result of the in -substance defeasance, the City reduced its total debt service requirements by $77,270, which resulted in an economic gain (difference between the present value of the debt service payments on the old and new debt) of $32,708. NOTE F - CAPITAL LEASE OBLIGATIONS ,. In prior years, the City acquired certain equipment under capital leases. The assets and liabilities under capital leases were recorded at the lower of the present value of the minimum lease payments or the fair value of the asset. The assets are amortized over their estimated productive lives. Current amortization expense is included in depreciation expense. No capital lease obligation existed as of June 30, 1999. City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE G - DEFICIT FUND BALANCES/RETAINED EARNINGS The following individual funds have deficit fund balances/retained earnings at June 30, 1999. Enterprise Funds Solid Waste Fund $ 166,669 Golf Course Fund 53,430 Softball Complex Fund 175,941 NOTE H - PENSION PLAN 1. Plan Description The City of Cape Girardeau participates to the Missouri Local Government Employees Retirement System (LAGERS), an agent multiple -employer public employee retirement system that acts as a common investment and administrative agent for local government entities in Missouri. LAGERS is a defined benefit pension plan which provides retirement, disability, and death benefits to plan members and beneficiaries. LAGERS was created and is governed by statute, Section RSMo. 70.600 - 70.755. As such, it is the system's responsibility to administer the law in accordance with the expressed intent of the General Assembly. The plan is qualified under the Internal Revenue Code Section 401A and it is tax exempt. The Missouri Local Government Employees Retirement System issues a publicly available financial report that includes financial statements and required supplementary information. That report may be obtained by writing to LAGERS, PO Box 1665, Jefferson City, MO 65103 or by calling 1-800-447- 4334. 2. Funding Policy The City of Cape Girardeau's full-time employees do not contribute to the pension plan. The political ,., subdivision is required by state statute to contribute at an actuarially determined rate; the current rate is 8.3% (general), 8.0% (police) and 15.3% (fire) of annual covered payroll. The contribution requirements of plan members are determined by the governing body of the political subdivision. The contribution provisions of the political subdivision are established by state statute. 51 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE H - PENSION PLAN - Continued r 3. Annual Pension Cost For 1999, the political subdivision's annual pension cost of $935,802 was equal to the required and actual contributions. The required contribution was determined as part of the February 28, 1997 and/or 1998 annual actuarial valuation using the entry age actuarial cost method. The actuarial assumptions included (a) a rate of return on the investment of present and future assets of 7.0% per year, compounded annually, before retirement and 4.0% per year, compounded annually, after retirement, (b) projected salary increases of 4.0% per year, compounded annually, attributable to inflation, (e) additional projected salary increases ranging from 0.0% to 4.0% per ,year, depending on age, attributable to seniority/merit, and (d) pre -and post-retirement mortality based on the 1984 Group Annuity Mortality table set back no years for men and 6 years for women. The actuarial value of assets was determined using techniques that smooth the effects of short-temr volatility in the market value of investments over a five-year period. The unfunded actuarial accrued liability is being amortized as a level percentage of projected payroll on an open basis. The amortization period at February 28, 1999 was 15 years. 52 Three -Year Trend Information Fiscal Annual Percentage Net Year Pension Of APC Pension Ending Cost APC Contributed Obligation r 06/30/97 753,807 100% 0 06/30/98 887,717 100% 0 06/30/99 935,802 100% 0 52 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, 1996 annual actuarial valuations. NOTE I - INTEREST EXPENSE Interest cost, including handling charges, totaling $2,778,841, excluding $198,926 ofinterfund interest, was incurred during the year ended June 30, 1999. No interest cost was capitalized as part of the cost of assets constructed during the period. 53 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE H - PENSION PLAN - Continued 3. Annual Pension Cost— Continued Required Supplementary Information Schedule of Funding Progress (a) (b) (b -a) (a/h) (c) (b-a)/c) Entry Age Unfunde UAL as a _ d Actuarial Actuarial Actuarial Accrued Annual Percentage of Valuation Value Accrued Liability Funded Covered Covered Date of Assets Liability (UAL) Ratio Payroll Payroll 02/28/97 $13,511,019 $14,466,970 $955,951 93% $8,725,334 11% 02/28/98 15,866,088 15,663,640 (202,448) 101% 9,166,334 ( 2%) 02/28/99 17,502,029 16,952,486 (549,543) 103% 9,497,630 ( 6%) 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, 1996 annual actuarial valuations. NOTE I - INTEREST EXPENSE Interest cost, including handling charges, totaling $2,778,841, excluding $198,926 ofinterfund interest, was incurred during the year ended June 30, 1999. No interest cost was capitalized as part of the cost of assets constructed during the period. 53 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE J - INTERFUND RECEIVABLES AND PAYABLES The following is a summary of interfund balances as of June 30, 1999: Due to/from other funds: Due to Due for. General Fund S 1,523,583 $ - CDBG Fund - 53,615 Sewer Fund 1,469.968 5 1.523.583 $ 1,523583 Advance to/from other funds: 54 Advances from Advances to General Fund E [,667,500 $ - Sewer Fund 337,500 Solid Waste Fund 750,000 Golf Course Fund 390,000 Softball Complex Fund 190,000 $1.667.500 $1,667,500 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 lune 30, 1999 was as follows: Softball Sewer Water Solid Waste Golf Ccume Complex Total Fund Fund Fund Fund Fund Eutermis Operating revenues $2,431,579 $4,307,995 $2,275,554 $469,677 $115.203 $9,600,008 Depreciation 1,069,495 441,554 206,012 62,592 8,506 1 ]88,159 r Operating lneorre(Loss) 75,764 910,810 243,245 (19,138) (252,440) 958,241 Operating transfers in - - - - 241,604 241,604 Net Income (Loss) (566518) 293,245 218,180 (32,578) (20,869) (108,540) Current Capital Contributions 605.881 1,517,225 - - - 2,123,106 Property, Plant and Equipment Additions 5,255,154 2,364,967 8,512 77,479 - 7,706,112 Deletions - (73,687) (15,358) (13,762) - (104,807) Net Working Capital 11549,692 2,106,763 239,246 (399,810) (200,379) 13,295,512 Total Assets 54,799,334 18,435,007 1,808.004 396,956 53,200 75,492.501 Bonds and Other Long -Term Liabilities Payable from Operating Revenues 33,205,824 11,109.123 425,000 - - 44,739,947 Total Equity $17,774,119 16,124,854 $ 121,916 $ (32,785) S (172,815) 821795,289 54 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE L - RESERVATION OF FUND EQUITY At June 30, 1999, the City had reserved its fund equity as follows: .� General Fund Reserved for prepaid items S 64,836 Reserved for advance 1,667,500 Reserved for mausoleum maintenance 67,584 Reserved for police projects 48,128 Reserved for encumbrances 50,115 $ 1,899,163 Special Revenue Funds ConventiowVisitors Fund Reserved for prepaid items $ 1,915 Reserved for encumbrances 5,732 Airport Reserved for prepaid items 16,554 Reserved for encumbrances 10,183 Parks and Recreation Fund Reserved for prepaid items 469 Reserved for encumbrances 1,265 Health Reserved for prepaid items 211 Motor Fuel Tax Reserved for encumbrances 3,625 Capital Improvement Sales Tax (Flood Control) Reserved for encumbrances 49,263 Transportation Sales Tax Trust Fund Reserved for encumbrances 418,442 S 507,659 r Debt Service Fund Reserved for debt service $ 3,618 592 Capital Projects Funds General Capital Improvement Fund Reserved for encumbrances 34,758 Street Improvements Reserved for encumbrances 12,258 FAU Street Grants Fund .. Reserved for encumbrances 695,484 Community Development Block Grant Fund Reserved for economic development loan repayments 95,121 Reserved for encumbrances 37,867 Park Improvements Reserved for encumbrances 6,403 Water Projects Fund Reserved for encumbrances 1,105,285 Reserved for bond capital expenditures 23,923,239 $ 25,910,415 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE M - RESERVED RETAINED EARNINGS AND RESTRICTED ASSET ACCOUNTS As of June 30, 1999, the reserved portion of retained earnings for the Enterprise Funds are as follows: Sewer Fund Reserved for debt service $ 33,333 Water Fund Reserved for debt service 150,000 Total reserved retained eamings $183,333 At June 30, 1999, the City has restricted assets in its Proprietary Funds as follows: NOTE N - LANDFILL CLOSURE AND POSTCLOSURE CARE COST State and federal laws and regulations require the City to place a final cover on its landfill when closed and perform certain maintenance and monitoring functions at the landfill site for thirty years after closure. The City closed its landfill in the fiscal year ending June 30, 1994, and an expense provision and related liability were recognized at that time based on the future closure and postclosure care costs that were estimated to be incurred new or after the date the landfill no longer accepted waste. The entire amount of the estimated total costs for landfill closure and postclosure care costs was recognized in prior years since the recognition is based on landfill capacity used to date and the landfill was filled to capacity in prior years. The estimated total future liability for landfill postclosure care costs is $300,000 as of June 30, 1999, 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, 1999. However, the actual cost of closure and postclosure care may be higher due to inflation, changes in technology, or changes in landfill laws and regulations. The City of Cape Girardeau has used the option of a Contract of Obligation as the financial assurance instrument for the landfill. The City issued bonds in October 1994 from which the proceeds have been used to pay the closure costs. 56 Revenue Bond Bond Sinking and Construction Reserve Fund Total Sewer Fund $9,468,446 $3,618,538 $13,086,984 Water Fund 322,846 1,155,967 1,478,813 Solid Waste Fund 4 110,964 110,968 Data Processing Fund - 127 127 Equipment Replacement Fund 2 130 132 $9,791,298 S4,885,726 514,677,024 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 new or after the date the landfill no longer accepted waste. The entire amount of the estimated total costs for landfill closure and postclosure care costs was recognized in prior years since the recognition is based on landfill capacity used to date and the landfill was filled to capacity in prior years. The estimated total future liability for landfill postclosure care costs is $300,000 as of June 30, 1999, 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, 1999. However, the actual cost of closure and postclosure care may be higher due to inflation, changes in technology, or changes in landfill laws and regulations. The City of Cape Girardeau has used the option of a Contract of Obligation as the financial assurance instrument for the landfill. The City issued bonds in October 1994 from which the proceeds have been used to pay the closure costs. 56 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE O - RISK MANAGEMENT The government is exposed to various risks of loss related to torts; theft of, damage to and destruction of assets; errors and omissions; natural disasters and employee health benefits. These risks, with the .� exception of those discussed in the following paragraphs, are covered by commercial insurance. Settled claims have not exceeded this commercial coverage in any of the past three fiscal years The City is a member of the Missouri Public Entity Risk Management Fund, a not-for-profit public entity insurance pool established by the state legislature. Through this pool the City receives coverage for general liability, law enforcement liability, vehicle loss and accident liability, errors and omissions, and employee benefit liability. Risks for these coverages are spread across members of the fund. Currently the fund is comprised of 580 Missouri counties, municipalities and, special districts. Premiums for these coverages are actuarially determined based on actual claims of the pool and individual claims of the City. Each year, portions of premiums not required because of below expected claims are returned to the members. The City has received refunds of premiums in each of the last five years and has used them to offset the cost of the succeeding year's premiums. The City has established self-insurance plans for employees' health insurance and workers' compensation. Both of these are accounted for using internal service funds. Under each plan the City is substantially self-insured and uses an administrator to handle claims management. From July 1, 1998 to December 31, 1998 the City's health insurance plan was a minimum premium plan administered by Continental Assurance Company, which had a "A" rating, by A. M. Best. Under this plan the City paid the administrator a monthly premium for claims administration, claims pooling, and final claims coverage. The City reimbursed the administrator for claims paid up to $50,000 annually per employee and approximately $800,000 annually for all employees. Rates were charged by the internal service fund to the other city funds to cover this maximum liability. All claims liabilities had been paid at the end of this year. Since January 1, 1999, the City converted its health insurance plan to traditional health insurance provided by Missouri Consolidated. Rates were charged by the internal service fund to cover the cost of the premiums. The City's workmen's compensation plan is administered by Galligher Bassett Inc. Under this plan the City pays the administrator a per claim fee to administer it's claims. All claims are paid directly by the City. The City has purchased insurance coverage from Safety National Casualty Corp. that limits the maximum claims to $225,000 and $275,000 per regular employee and police employee respectively. Additionally, $1,000,000 in coverage is provided for annual claims in excess of $535,000. Rates are charged by the internal service fund to the other city funds based on rates and experience factors established by the National Council on Compensation Insurance. Safety National is rated "A- 8" by A. M. Best. 57 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 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: 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, 1999, utility receivables totaled $1,874,951. On the financial statements, the utility receivables are shown net of the allowance for doubtful accounts of $711,421. This results in net utility receivable of $1,163,530. 37 CLAIMS LIABILITIES RECONCILIATION Health Workers' Insurance Compensation Total Balance, July 1, 1996 $ 208,126 $ 191,420 $ 399,546 Provision for Incurred Claims 647,134 173,081 820,215 Payment of Claims (720,066) (207,562) (927,628) Balance, July 1, 1997 135,194 $ 156,939 $ 292,133 Provision for Incurred Claims 989,135 403,511 1,392,646 Payment of Claims (904,329) (171,454) (1,075,783) Balance June 30, 1998 220,000 $ 388,996 $ 608,996 Provision for Incurred Claims 478,229 121,155 599,384 Payments of Claims (698,229) (212,946) (911,175) Balance June 30, 1999 $ 297,205 $ 297,205 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, 1999, utility receivables totaled $1,874,951. On the financial statements, the utility receivables are shown net of the allowance for doubtful accounts of $711,421. This results in net utility receivable of $1,163,530. 37 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE Q - COMMITMENTS AND CONTINGENCIES 1. Litigation — Various claims and lawsuits are pending against the City. In the opinion of City management, the potential loss on all claims and lawsuits will not be significant to the City's financial statements. 2. Grant Audit The City receives Federal and State Grants for specific purposes that are subject to review and audit by various Federal and State agencies. Such audits could result in a request for reimbursement by any of the Federal and State agencies for expenditures disallowed under the terms and conditions of the appropriate agency. In the opinion of City management, such disallowances, if any, will not be significant. 3. Construction Commitments As of June 30, 1999, the City had construction commitments outstanding of $4,585,118 4. Encumbrances As of June 30, 1999, the City had encumbrances outstanding of $5,202,207 5. Environmental Remediation City management is aware of one instance of environmental contamination of City owned property. City management is actively resolving these concerns. A Plan Of Action has been approved by the Missouri Department of Natural Resources ("DNR") for the contamined site. 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. 59 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June30,1999 NOTE R - CONTRIBUTED CAPITAL The changes in the contributed capital accounts for the enterprise funds were as follows: NOTE T — RETAINED EARNINGS RESTATEMENT Retained earnings of the Solid Waste Fund were restated as of June 30, 1998. Retained earnings were increased $434,278 as a result of the correction of an erroneous estimate of future liability for landfill postclosure care costs. This liability was originally estimated at $806,078 for the year ended June 30, 1998 and has subsequently been corrected to $371,800, as a result of a discovery that personnel expense had been incorrectly allocated. 60 Solid Golf Softball Sources Sewer Water Waste Course Complex Total Beginning Balance July 1, 1998 $17,013,831 S 3.599.481 5 288,585 S 645 S 1126 $20,905,668 Contributing Sources: Donated asset by developers 415,393 207,738 - - - 623,131 Connection Fees 190,488 - - - - 190,488 State & Federal Grants 1.309.487 1.309 487 Ending Balance, June 30. 1999 $17,619.712 S 5,116.706 $ 288,585 $ 645 $ 3,126 S23.028,774 NOTE S - EXCESS OF EXPENDITURES/EXPENSES OVER APPROPRIATIONS For the year ended June 30, 1999 expenditures/expenses exceeded appropriations in the individual funds as follows: Budget Actual Variance Capital Improvement Sales Tax -Water Proi. $- $ 3,904 $ 3,904 Vision 2000 10,000 10,576 576 Park Improvements Fund 20,000 36,910 16,910 Golf Course Fund 505,539 508,990 3,451 Softball Complex Fund 347,604 358,937 11,333 Employee Fringe Benefit Fund 1,272,894 1,372,146 99,252 NOTE T — RETAINED EARNINGS RESTATEMENT Retained earnings of the Solid Waste Fund were restated as of June 30, 1998. Retained earnings were increased $434,278 as a result of the correction of an erroneous estimate of future liability for landfill postclosure care costs. This liability was originally estimated at $806,078 for the year ended June 30, 1998 and has subsequently been corrected to $371,800, as a result of a discovery that personnel expense had been incorrectly allocated. 60 City of Cape Girardeau, Missouri NOTES TO FINANCIAL STATEMENTS June 30, 1999 NOTE U — YEAR 2000 The year 2000 issue is the result of shortcomings in many electronic data processing systems and other electronic equipment that may adversely affect the City of Cape Girardeau's operations after December 31, 1999. The City completed an inventory of it's computer and financial reporting systems prior to 1998 and by the end of 1997 had recommended and committed to purchase software and hardware that would enable the City to have year 2000 compliant computer and financial reporting systems by the year 2000. Total cost of these changes exceeded $850,000. All major software changes have now been installed and testing and validation of the software has been completed. In addition an employee team was formed in November 1998 to access the City's vulnerabilities to the year 2000 issue in other electronic equipment systems throughout the City. This team reviewed the City's water, sewer, solid waste collection, fleet fueling and public safety systems. All systems known to be non-compliant have been replaced at this time. Emergency power supplies have also been obtained to insure an uninterrupted power supply for crucial city services. At this time, all city systems are believed to be year 2000 compliant. However, emergency procedures have been developed to handle potential unexpected year 2000 issues. Because of the unprecedented nature of the year 2000 issue, its effects and the success of related remediation efforts will not be fully determinable until the year 2000 and thereafter. Management cannot assure that the City is or will be year 2000 ready, that the City's remediation efforts will be successful in whole or in part, or that parties with whom the City does business will be year 2000 ready. 61 COMBINING AND INDIVIDUAL FUND FINANCIAL STATEMENTS City of Cape Girardeau, Missouri GENERALFUND COMPARATIVE BALANCE SHEET JUNE 30, 1999 AND 1998 + 63 1999 1998 $1,894,143 $2,516,802 43,630 ASSETS + Pooled rash and investments 640,708 Receivables, net of allowances for 1,079,365 doubtful receivables + Real estate, personal property 71,230 and merchant taxes 382,551 Sales tax + Franchise tax 38,876 Special assessments receivable 167,658 Interest receivable ,. Other receivables 1,359,545 Intergovernmental receivables 1,667,500 Grants receivable + Due from other funds Advances to other funds 64,836 Inventories Prepaid items + Total assets LIABILITIES AND FUND BALANCES + Accounts payable Accrued liabilities Salaries, payroll taxes and benefits _ Other liabilities Due to other governments Defamed revenue Total liabilities Fund Balances Reserved for prepaid items Reserved for advances Reserved for mausoleum maintenance Reserved for police projects Reserved for encumbrances + Unreserved + Total fund balances Total liabilities and fund balances + 63 1999 1998 $1,894,143 $2,516,802 43,630 43.468 635,099 640,708 1,079,365 1,093,662 106,252 71,230 200 382,551 286,013 45,975 38,876 167,658 195,279 1,523,583 1,359,545 1,667,500 1,867,500 216 122 64,836 64,272 $7,610,808 $8,177477 $301495 $651,176 331,612 322,797 174,443 165,089 205 200 153,364 125,227 961,119 1,264,489 64,836 64,271 1,667.500 1,867,500 67,584 63,834 48,128 45,458 50,115 75,053 4,751,526 4,796,872 6,649,689 6,912,988 $7,610,808 $8,177477 CID of Cape Glrallou. Missoutl GENERAL FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June M 1999 VARIANCE FAVORABLE BUDGET ACTUAL LUNFAVORABLEI REVENUES Tato $11165510 $11,159.913 $1]40] limnDes end pntrvu 869,9YJ 1,083,273 1M.373 IntMowmmenul 3&0]5 .'159 21B.]94 C5n9.. br-ce, 311135 351.555 40,420 IMeNepanmental sem¢s 493,500 536.191 42,691 Flnes end torle,Wms ]Bgm 8]25]1 92.571 Mimeiiana g 81 B]0 ]5305 (5.415) Imnlmenl revenue 246.025 30.386 62,381 SP -144x.41010. 6CM a120 2,128 r TOTAL REVENUES 14A37 945 15 N9861 601,916 EXPENDITURES Ganem � PGminiftA4w xni[ea Cln count 21.010 I7,156 3.854 Human M -S I87.. 169,143 (BA) City menaper tefi.29] 20.016 (6.]19) Pup. awarmeaa N.990 49.993 5 N C, anomry 184,147 183,110 1029 Fina 384.856 379.382 S.A. Inwdepenmmul 485,810 4W.553 15,257 T.W administntiw xrvlxs 1 193]0 14]1]90 ryCW Cewkgrorit ve PunNne Dm9m�a 26s,oe1 277a5s 7,71e lmpemm aemr<a 340.366 301.129 39.237 En9inemn9 D . 49349H 435.830 57 A. Cammuniry and eralomic development 81. MASS (2,895) PuIHc dansponalim 333.730 311882 17,848 TOW demlcpment ew.+us 1,532671 1131 D3 119.552 P. maiH-An- 050559 650,371 187 Cemetery 1314" 124,98 6.182 F.iry meimmanx 14].3]1 147426 (57) Taw Pv4a aW NNAAA an 1.128,929 1122337 6.592 P.. we, M-Ripal mud 2014969 107.RO 14 ]W P.- 4384658 1379,071 S.I. Fn ],049.0]9 3,0474554 2,325 Harald W59aam 170,DW 164050 5550 T. A.Nlb-I., 7.80ST07 ],778.738 27 969 Pmlm wpb Sb t 1sn zq 1.523011 4A.224 $bmmvler 288042 312.165 (23,124) T.1 pblic wort 1000289 1,835.109 25100 Cmdn9enry 95950 94,000 ?090 Dmt 5410 mlentl and I -X Uaryea T. deft aenir< TOTAL EXPENDITURES 13919,922 13,715 WI 200,321 EXCESS CEFICIENCq OF REVENUES OVER (UNDER) EXPENDITURES 518.023 184260 8M.z37 OTHER FINANCING SOURCES (USES) Oplab,g Fanslenin 911500 914. - OperzGn9XX-1rs oul F2.W1,02) GA67 0I) 513.621 bvenc< repayment 2L OO) 203.030 TOTAL OTHER FINANCING SOURCES NSES) (1.055802) 0.353]01) 713621 EXCESS (OEF)CIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER UJNDER) EXPENDITURES AND OTHER FINANCING USES (51 548]]9) MA 921) $t 519656 64 Lily of l IAL REVENUEFUNDS SPECIAL REVENUE FSHEE COMBINING BALANCE SHEET Juno ]0,1998 (WIIM1 Com1ara6v Toth foNum 10,188$1 Capital C.0'. Downtown Improve nl Improv...nl Cont/ H., fl..,....ilnasa Part. and Motu $alae Tia Sala. Ta[ Transportation Flood Vlilon jotala A',.Jr DINOW NeaI1M1 Fuel,ia9 1FIood Cgntrpl IVAN., Proache� E�ptgtlo0 jDOO 9_60ol$9 6IID190 ASSETS Pooled -N, a no mveslmenl5 $596911 $81197 S26908 5170269 $2,5335 807161 $192541] S1100,b3 16.585254 "IS S1 715 $115]8.959 $8 828034 NOrpao,ad bvesMenlS - - - - _ _ _ _ _ _ 1002,263 Newry -Dies, nal of al—n— for dwodw I....m.. Neal exlau ia. - 109] 6426 _ - 7,523 11]]0 P-r—I niopeny lav - 1695 - - _ 1.691 1,)32 r ....11. 364 - - - 3657 ]5140 Neilawanl ha recervaDle ,6 ,]29 _ - - 46 329 W 373 MD1or Wel lee 84,]95 84396 8186 Motor aeM1lcle !cense lees 1399 - - - - 13 951 IB 231 Mmor venme..1., tan 25301 - _ 25301 26%3 011w—waDles 090 16273 a 2 - _ 2,,139 162II Saha lax - - - 159203 15832 312CA3 630,226 635045 S .... I aa ... smenli - _ _ - ]5". 75.516 1]0]9 - _ - - - - 23224 G anlsrecaIraole vaole 6,102 62 - _ _ - 66002 194]9 311, ]5] - _ _ _ - 19]96 19]]0 .....orws Prepay aami 1915 16554 - 469 211 19,149 17 MO ar 5 Oue Bom ..Plund VI 694 66fi Total .... a 56172]3 $184881 $28005 $1]5]12 $253669 SWC821 $2084,820 $1]56,)05 569]433 S419 $1]15 $12599253 $11 485 198 LIABILITIES AND FUND BALANCES A." $21233 $31105 $ � 261970 $9615 1450 $22]3] $3,90, 2)0.328 $ � $419 $422.21 $13fi1393 AoG .11edBlbs $elulin. ,paym4lsses ant oerreM1l. 5,319 12896 - 53 B2] 227 - - - ]49]9 67 611 InmreA p%axle - - - 3,291 - 3291 - 011liaolln., 213 2]30 - 15126 t]$9 1901 OH—cl..venue 111]_"`6 33,7% 109] 6932 1,305 75,382 2]]]98 61410 Total H.HH.H.. 133_941 8027 1 09 13_915 1904 1450 22131 1,195 3,15 710 419 2523BB 1 392215 I.- Dalanw. N—I.d for prepaJ llama 1655, - 469 211 - _ - 1]234 11059 R.aened far encumorarcvs ],61] 10, 1. - 1265 - ]625 49,263 - 416262 - 190425 1400949 Unreserved 53685 ]8_127 26908 W1 2]3621 95_]46 2012620 1 251 510 6209281 419 1$3fi 11]392% 8 679]5 Total .no oafs.[.. 54_]]2 1- 2_909 ])9)24,832 95_3]1 2 051603 1,251 510 662)123 419 1_35 11 B46 865 10092983 Total llaollllles and fond balance. 56]]2)] $1134,801 $26 W5 $1)557$2 $253 SUB $960821 $20046N1 $1258,)05 56,W3433 N19 $1115 $12599253 $11485,198 I I I I i I i i i I t i I I I I i I I SPECIAL REVENUE FUNDS COMBINED STATEMENT OF REVENUES. EXPENDITURES AND MANGES IN 'FUND BALANCE FOR THE FISCAL YEAR ENDED I.- )0.1999 CAPITAL CAPITAL OOWNIpYN IMPROVEMENT IMPROVEMENT IRANSPORTAUON CONVEN➢ONI BUSINE55 PARRSAND MOTOR SALES U9 SALES TAY SALES FLOOD VISION TOTALS lyf$IQN ABUT . PI ICI RECREATE? HETI TV"16 FLOOD COHIR0. PROJFf NALFER�i $) L P4L CJ 1I �X REVENUES .' fYll'. 1 $21.]]0 S- M S}t}S S- SLSe},91] SI 811 S9] 11 ITALIA, J� S- 1. 1,M IT, I." PII 15.}10 93.. 50}5 1 "..IBM41II.Fl CAegee lw aemcee RSET BI,}JS - I.S.I. 11A1.4NPI U—N AS}] - 9 5}] Il).0] l}dl BBS. IJSyI 2. B 121A A."IB 12.310 A,'., IJ2B1p 1N,]19 3 11 SpeaY uaevmemf � � � )qB}O}O 11 B}, TOTAL REVENUES 1 034 539 250,]5. }S W] ] Sb BY.R] 1/18659 1US 732 1.9499 ]gISB9] 1 9865 11346}9 EFPENOITURES CunPl AJI A -, F7. ALP .. 9158 Oer bprmnl 6 I.. 1PPo.PM- 1 S P.IRBY _ }3511] DS)BJ P. xwu - II IN 40),W }51},151 - � ID9 .1 B— a IPIe�eSIeM M1tol Ner9ea ]IB _I AN 23 TOTAL EXPENDITURES 270.649 7280522 7x0 I,C99,SO1 y]p 1139} 407W 309VI }51}.151 10576 5.]BOe EXCESS URFICIENCYI OF REVENUES OVER NNDERI EXPENDITURES 1031190 Ill. "BU 2S PUP 3, }TAC .]5 ]111 T.". IBb 019 I.J.]]9 xl 11,1111 556 }013 OTHER FINANCING SOURCES IUSE51 OPn.0q U.0:1.n IP "11. B]] }C0 l.,. Ome': G nPYen om 16BS,ro]1 - 11po1 GWl ne10,5w1 2.T32.1 (1 IT 3901 BPP6 wo<9.6. VD5.193 B5 NU TOTAL OTHER FINANCING SOURCES JSESI RB5¢a1 "I SJU m]xW IT., .1 I161a sm1 (2 Gl.}.) 1. 8661 µxF,AV) EXCESS (DEFICIENCY) OF REVENUES FINANCING SOURCES OVEN1HER IUNOERI EwEN01TUNES AM. DINER FINANCING USES eB 89] 49,425 ]]Bb '0.171) }y0 "1.1 118]]9 181}101 IBN,]]9 11 9958 1)488] FUND BALAN CES, JULY 1-1RESTATED) /1} 5.}9 ],}10 05911 231 A9x a ].110.]V 1 110]88 5030981 I,1., 1009}903 PRIOR PI=ADJUSTMENT FUND BALANCES, JUNE 10 $54333] $101,854 S]B.901 $35797 13]],00} $959371 $3 BI 013 SI}51ITT $5$5 B3�l23 SOB S1I]e 511840183 City of Cape Girardeau, Missouri CONVENTIONNISITORS SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 1999 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI REVENUES Taxes $985,000 $977809 ($7,191) Intergovernmental - 15,240 $15,240 Charges for services 5,500 6,981 1,481 Miscellaneous 52,177 4,994 (47,183) Investment revenue 10,000 32,458 22,458 TOTAL REVENUES 1,052.677 1,037,482 (15,195) EXPENDITURES Current Administrative services 342,373 261,103 81,270 TOTAL EXPENDITURES 342,373 261,103 81,270 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 710,304 776,379 66,075 OTHER FINANCING SOURCES (USES) _ Operating transfers out (665,000) (665,000) - TOTAL OTHER FINANCING SOURCES (USES) (665,000) (665.000) - EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES $45,304 $111,379 $66,075 67 + City of Cape Girardeau, Missouri AIRPORT SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) + FOR THE FISCAL YEAR ENDED June 30,199S BUDGET $107,860 140.800 106.200 354,860 834,303 13,500 847,803 (492,943) 422,803 377,943 ($115,000) 68 ACTUAL $62,500 67,234 117 403 3.531 rb7r7%Y:', 724,526 12,796 719 738,041 (487,373) 422,400 105,193 527,593 $40,220 VARIANCE FAVORABLE (UNFAVORABLEI ($45,360) (73,566) 11,203 3.531 (104_192) 109,777 704 (719) 109.762 5,570 (403) 44,860 105,193 149,650 $155,220 + 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 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 BUDGET $107,860 140.800 106.200 354,860 834,303 13,500 847,803 (492,943) 422,803 377,943 ($115,000) 68 ACTUAL $62,500 67,234 117 403 3.531 rb7r7%Y:', 724,526 12,796 719 738,041 (487,373) 422,400 105,193 527,593 $40,220 VARIANCE FAVORABLE (UNFAVORABLEI ($45,360) (73,566) 11,203 3.531 (104_192) 109,777 704 (719) 109.762 5,570 (403) 44,860 105,193 149,650 $155,220 ,. 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, 1999 + VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI REVENUES Taxes $17,841 $23,370 $5,529 Investment revenue 300 689 389 TOTALREVENUES 18,141 24,059 5,918 EXPENDITURES Current Development services 17,600 369 17,431 TOTAL EXPENDITURES 17,800 369 17,431 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES $341 $23,690 $23,349 69 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, 1999 VARIANCE 70 FAVORABLE + BUDGET ACTUAL (UNFAVORABLEI REVENUES Charges for services $412,700 $385,079 ($27,621) Miscellaneous 14,106 4,260 (9,846) + Investment re venue - 7,901 7,901 TOTAL REVENUES 426,806 397,240 (29,566) ` EXPENDITURES Current Parks and recreation 1,101,096 1,099,632 1,464 TOTAL EXPENDITURES 1,101,096 1,099,632 1,464 ` EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (674,290) (702,392) (28,102) OTHER FINANCING SOURCES (USES) Operating transfers In 674,290 673,200 (1,090) TOTAL OTHER FINANCING SOURCES (USES) 674,290 673,200 (1,090) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND + OTHER FINANCING USES $- ($29,192) ($29,192) 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, 1999 REVENUES Taxes Licenses and permits Intergovernmental Charges for services Investment revenue TOTAL REVENUES EXPENDITURES Current Public safety a 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 $209,202 4,000 4,600 2,500 10,250 230,552 747,712 747,712 (517,160) 500,000 500,000 ($17,160) 7t VARIANCE FAVORABLE ACTUAL (UNFAVORABLE) $212,265 8,523 5,025 13 461 239,274 235,783 235,783 3,491 $3,491 $3,063 4,523 425 (2,500) 3.211 8,722 511,929 511,929 520,651 (500,000) (500,000) $20,651 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, 1999 BUDGET $1,315,000 33.000 1,348,000 50,000 50,000 1,298,000 (1,396,500) (1,396,500) ($98,500) 72 ACTUAL $1,376,697 76 951 1,453.648 15,017 15.017 1,438,631 (1,301,600) (1,301,600) $137,031 VARIANCE FAVORABLE (UNFAVORABLE] $61 ,697 43.951 105,648 34,983 34,983 140,631 94,900 94,900 $235,531 REVENUES Intergovernmental Investment revenue TOTAL REVENUES EXPENDITURES Current Public works TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES r 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 BUDGET $1,315,000 33.000 1,348,000 50,000 50,000 1,298,000 (1,396,500) (1,396,500) ($98,500) 72 ACTUAL $1,376,697 76 951 1,453.648 15,017 15.017 1,438,631 (1,301,600) (1,301,600) $137,031 VARIANCE FAVORABLE (UNFAVORABLE] $61 ,697 43.951 105,648 34,983 34,983 140,631 94,900 94,900 $235,531 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, 1999 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) REVENUES Taxes $1,863,290 $1,842,914 ($20,376) Investment revenue 115,000 146,910 31,910 TOTAL REVENUES 1,978,290 1,989,824 11,534 r EXPENDITURES Current Public works 545,200 456,830 88,370 TOTAL EXPENDITURES 545,200 456.830 88,370 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 1,433,090 1532,994 99,904 OTHER FINANCING SOURCES (USES) Operating transfers out (1,930,500) (1,616,500) 314,000 TOTAL OTHER FINANCING SOURCES (USES) (1,930,500) (1,616.500) 314,000 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($497,410) ($83,506) $413,904 r 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, 1999 VARIANCE FAVORABLE BUDGET ACTUAL _U( NFAVORABLE) REVENUES Taxes $1,863,290 $1,841,598 ($21,692) Investment revenue - 116,836 116,838 TOTAL REVENUES 1,863,290 1,958,436 95,146 EXPENDITURES Interest and fiscal charges 3,904 (3,904) TOTAL EXPENDITURES 3,904 (3,904) EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 1,863,290 1,954532 91,242 OTHER FINANCING SOURCES (USES) Operating transfers out (2,133,290) (2,033,290) 100,000 TOTAL OTHER FINANCING SOURCES (USES) (2,133,290) (2033,290) 100,000 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($270,000) ($78,758) $191,242 74 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, 1999 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI REVENUES Taxes $3,726,580 $3,588,284 ($138,296) Miscellaneous - 38,820 38,820 Investment revenue 109,000 319,487 210,467 TOTAL REVENUES 3,835,580 3,946,591 111,011 EXPENDITURES Current Public works 5,214400 2,062,123 3,152277 TOTAL EXPENDITURES 5,214,400 2,062,123 3,152,277 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (1,378,820) 1,884,468 3,263,288 OTHER FINANCING SOURCES (USES) Operating transfers in 200,000 200,000 TOTAL OTHER FINANCING SOURCES (USES) 200,000 200,000 .� EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($1,178,820) $2,084,468 $3,263,288 75 City of Cape Girardeau, Missouri FLOOD PROTECTION SPECIAL REVENUE FUND SCHEDULE OF REVENUES AND EXPENDITURES BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 1999 REVENUES Investment revenue TOTAL REVENUES EXPENDITURES Current Administrative services TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER(UNDER) EXPENDITURES BUDGET 76 $23 $23 VARIANCE FAVORABLE ACTUAL (UNFAVORABLE) $23 $23 23 23 $23 $23 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, 1999 BUDGET $2.500 2,500 10,000 10.000 (7,500) ($7,500) 77 ACTUAL $8,854 12 8,866 10,576 10,576 (1,710) 6,667 6,667 $4,957 VARIANCE FAVORABLE (UNFAVORABLEI $6,354 12 6,366 (576) (576) 5,790 6,667 6,667 $12,457 REVENUES Miscellaneous Investment revenue TOTAL REVENUES EXPENDITURES Current Development services TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Operating transfers in TOTAL OTHER FINANCING SOURCES (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES BUDGET $2.500 2,500 10,000 10.000 (7,500) ($7,500) 77 ACTUAL $8,854 12 8,866 10,576 10,576 (1,710) 6,667 6,667 $4,957 VARIANCE FAVORABLE (UNFAVORABLEI $6,354 12 6,366 (576) (576) 5,790 6,667 6,667 $12,457 City of Cape Girardeau, Missouri DEBT SERVICE FUND COMPARATIVE BALANCE SHEET JUNE 30, 1999 AND 1998 78 1999 1,226,985 393,769 1,957,265 14,055 490,719 1. SCS $800 285 502,960 504.045 3,618,592 1998 $3,093,152 480,935 13,795 587,971 1R VN 285 598,437 1 S.' ..11 $4,192,354 ASSETS + Pooled cash and investments Non -pooled cash and cash equivilents Non -pooled investments Receivables, net of allowances for doubtful receivables Real estate, personal property and merchant taxes Special assessments receivable Interest receivable Other receivable Total assets LIABILITIES AND FUND BALANCES Accounts payable Interest payable Deferred revenue Total liabilities Fund Balances Reserved for debt service _ Unreserved Total fund balances Total liabilities and fund balances 78 1999 1,226,985 393,769 1,957,265 14,055 490,719 1. SCS $800 285 502,960 504.045 3,618,592 1998 $3,093,152 480,935 13,795 587,971 1R VN 285 598,437 1 S.' ..11 $4,192,354 City at Cape Girardeau, Missouri CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET June 30, 1999 (With Compendia. Totals for Jun. 30, 1998) Garel Corp Capital Flood Street FAU Street CDBG Park Water Totals Improvement Control Improvements Gra n3 Grant Improvements Projects 06130199 06130/98 ASSETS Pooled cash and Investments $265,239 $299,554 $267,463 $386,198 $206,275 Non-haoletl cash and cash equlvelents 10 - - 16,126 $369,639 1]43,110 $3,53)4)9 $1,118,523 - 1 23.923,239 23,939,3)6 349,171 Non forced Investments 150,043 - 150.043 Grants receivable - 61,530 - 77,762 20,100 - - 159,412 133,940 Speaal assessments receivable 25,858 - _ 25,858 42,046 Interest receivable 5 472 - 3,)1)4,1 Other receivable - 18,115 - 94 16,115 1.Jfi2 - Notes receivable Total asset. $265,254 $511,599 $293,321 $463.980 $250.617 $369,640 $25670,066 $2),834,4)) $1645,042 LIABILITIES AND FUND BALANCES d Accems payable $- $951 $34]12 $40,019 $199 $58 $646,264 $722.223 $132,060 Due to other governments - - 2]0) - 2]0) 2,20) Due to other funds - - 53,615 - 53615 695,216 Deterred revenue 11,489 23,926 35415 51,973 Total liabilities 12,440 58,638 40,019 56,521 58 646,284 613,960 881 556 Fund balances Reserved for debt service - - - 977 Reserved for bond capital expenditures - - - - Reserved for economic devloan repymnls - - - - 95,121 - - - 23.923,239 - 24018.360 6,414 69,004 Reserved for encumbrances 34,)58 - 12,256 695,484 3).86] 6,403 1,105,205 1092,055 941]31 Unreserved 230,496 499,159 223,425 (271523) 71,100 363,179 (4,742) 1,110,102 (274,540) Total fund balances 265154 499,159 234,683 423,961 204,096 369_582 25,023,782 2),020,51) 763,586 Total liabilities and fund balances $265,254 $511599 $293,321 $463,980 $260,617 $359,640 $25.670,066 $2),8344)) $1,645.042 1 I 1 1 1 1 1 1 1 1 1 1 1 1 1 I 1 i 1 Cly of Cape Girardeau, Missouri CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES FOR THE FISCAL YEAR ENDED June 30, 1999 GENERAL CORP FAU CAPITAL FLOOD STREET STREET CDBG PARK WATER TOTALS IMPROVEMENT CONTROL IMPROVEMENTS GRANTS GRANT IMPROVEMENTS PROJECTS 19981.99_9 REVENUES Inlergovemm¢nldl E- $145,365 $ 541913 1111,280 & $]40,530 Inveslmenl Rvenue 4 76 15)21 12.923 10,432 6,88 06 1,914 66,353 zenls Spetlal assesm is,]9J 15 55] 16,557 TOTAL REVENUES 4 761 161,009 30,350 54,836 163,692 6,006 1,914 423448 EXPENDITURES Capital outlay 4640 527,319 99788 52,109 107,463 30507 1]58.223 2.260049 Debt zenke interest and fiscal chatq¢5 1866 10667 20533 TOTAL EXPENDITURES 4,64D 527,319 99,700 52,109 189,329 30,50] 1,3]6,690 2200,582 To O EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 121 (366,230) (69.438) 2]2] (25.637) (2],)01) (1,3]4,9]6) (105),t]4) OTHER FINANCING SOURCES (USES) Operating transfers in 171 930 300,000 75.000 143,400 36.205 61000 3033,290 2,020,825 Operating transfers out (16 534) - (41 000) - (5],5]4 Bono proceeds 235,]10 25,115,063 25,350,]]3 TOTAL OTHER FINANCING SOURCES (USES) 171 930 300,000 58466 143,400 35205 255,)10 2],140,353 20,114064 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES 172 051 (66,230) (10972) 146,127 10,568 232009 257]3,32] 26.256 930 FUND BALANCES. JULY 1 ,(RESTATED) 93,203 565,389 245655 27],0]4 193,528 137,573 (249,595) 263,582 FUND BALANCES, JUNE 30 $265254 $499,159 $234683 $423,961 S204,096 $369,582 $25,021.202 $2],020.517 r City of Cape Girardeau, Missouri GENERAL CAPITAL IMPROVEMENT FUND SCHEDULE OF REVENUES AND EXPENDITURES - r BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 1999 81 VARIANCE FAVORABLE r BUDGET ACTUAL IUNFAVORABLEI r REVENUES Intergovernmental $403,740 $- $ (403,740) Investment revenue 5,215 5,215 TOTAL REVENUES 403,740 5,215 (398,525) EXPENDITURES r Capital outlay 620,530 22,948 597,582 TOTAL EXPENDITURES 620,530 22,948 597,582 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (216,790) (17,733) 199,057 OTHER FINANCING SOURCES (USES) Operating transfers in 216790 171,930 (44,860) Operating transfers out - TOTAL OTHER FINANCING SOURCES (USES) 216,790 171.930 (44,860) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES r OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES $- $154,197 $154,197 81 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, 1999 REVENUES Intergovernmental Investment revenue 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 TOTAL OTHER FINANCING SOURCES (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES BUDGET 614.000 614,000 (614,000) 614,000 614,000 $ 82 VARIANCE FAVORABLE ACTUALUI NFAVORABLEI $145,365 16.195 161,560 417,034 417,034 (255.474) 300,000 300,000 544,526 $145,365 16.195 161,560 196,966 196,966 358,526 314,000 314,000 544, 526 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, 1999 BUDGET $7,500 15,000 22,500 224,900 224.900 (202 400) 224,900 (22,500) 202,400 83 ACTUAL $14,955 16,558 31,513 73,191 73,191 (41,678) 75,000 (16,534) 58,466 $16788 VARIANCE FAVORABLE (UNFAVORABLE) $7,455 1.558 9,013 151,709 151,709 160.722 (149,900) 5,966 (143,934) $16,788 REVENUES Investment revenue Special assessments + TOTAL REVENUES EXPENDITURES Capital outlay TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Operating transfers in Operating transfers out TOTAL OTHER FINANCING SOURCES (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES BUDGET $7,500 15,000 22,500 224,900 224.900 (202 400) 224,900 (22,500) 202,400 83 ACTUAL $14,955 16,558 31,513 73,191 73,191 (41,678) 75,000 (16,534) 58,466 $16788 VARIANCE FAVORABLE (UNFAVORABLE) $7,455 1.558 9,013 151,709 151,709 160.722 (149,900) 5,966 (143,934) $16,788 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, 1999 BUDGET $265,500 265,500 745,900 745,900 (480,400) 86,400 88.400 ($392,000) 84 VARIANCE FAVORABLE ACTUAL (UNFAVORABLEI 541,913 14.192 56,105 735,608 735,608 (679,503) 143,400 143.400 ($536,103) ($223,587) 14.192 (209,395) 10,292 10,292 (199,103) 55,000 55.000 ($144,103) REVENUES Intergovernmental Investment revenue Special assessments TOTAL REVENUES EXPENDITURES Capital outlay 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 BUDGET $265,500 265,500 745,900 745,900 (480,400) 86,400 88.400 ($392,000) 84 VARIANCE FAVORABLE ACTUAL (UNFAVORABLEI 541,913 14.192 56,105 735,608 735,608 (679,503) 143,400 143.400 ($536,103) ($223,587) 14.192 (209,395) 10,292 10,292 (199,103) 55,000 55.000 ($144,103) City of Cape Girardeau, Missouri COMMUNITY DEVELOPMENT BLOCK GRANT FUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGETANDACTUAL(BUDGETBASIS) FOR THE FISCAL YEAR ENDED June 30, 1999 r REVENUES Intergovernmental Investment revenue TOTAL REVENUES EXPENDITURES r Capital outlay Debt service Interest and fiscal charges r TOTAL EXPENDITURES EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Operating transfers in r TOTAL OTHER FINANCING SOURCES (USES) EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND r OTHER FINANCING USES BUDGET $446.500 446,500 546,870 546,870 (100,370) 45,000 45,000 ($55,370) 85 VARIANCE FAVORABLE ACTUAL (UNFAVORABLEI $153,259 11.458 164,717 211,730 1,866 213,596 (48,879) 36,205 36,205 ($12,674) ($293,241) 11,458 (281.783) 335,140 (1,866) 333,274 51,491 (8,795) (8,795) $42,696 City of Cape Girardeau, Missouri PARKIMPROVEMENTSFUND SCHEDULE OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 1999 REVENUES Investment revenue TOTAL REVENUES EXPENDITURES Capital outlay 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 BUDGET 20,000 (20,000) 61,000 (41,000) 20,000 86 VARIANCE FAVORABLE ACTUAL (UNFAVORABLE) $7.400 7,400 36,910 36,910 (29,510) 61,000 (41,000) 235,710 255,710 $226,200 $7.400 7,400 (16,910) (16,910) (9,510) 235.710 235,710 $229,200 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, 1999 87 PROJECT PRIOR CURRENT TOTAL BUDGET YEARS YEAR TO DATE r REVENUES Interest $- $176 $2,156 $2,332 TOTAL REVENUES 176 2,156 2,332 EXPENDITURES Capital outlay 26,500,000 2,246,570 7712.952 3,959,522 Debt service Interest and fiscal charges - 28,161 18,667 46,828 TOTAL EXPENDITURES 26,500,000 2,274,731 1,731,619 4,006,350 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (26,500,000) (2274,555) (1,729,463) (4,D04,018) OTHER FINANCING SOURCES (USES) Operating transfers in - 774,402 2,033,290 2,807,692 Bond proceeds - 25,115,063 25,115,063 r TOTAL OTHER FINANCING SOURCES (USES) 774,402 27,148,353 27,922,755 EXCESS (DEFICIENCY) OF REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER FINANCING USES ($26,500,000) ($1,500,153) $25,418,890 $23,918,737 87 Clry of Cape Girardeau, Missouri ENTERPRISE FUNDS COMBINING BALANCE SHEET June 30,1999 (04116 Comparative To rls for June 30,1998) Solid Goll Softball Totals seven Water Wast. Course C..'I. 0613059, 06130198 ASSETS Pooled orifi and investments $1]119]5 $998423 $244,982 $4I 851 $25249 $3028400 $1624,026 Nonpwled Halt B easfi equivalents 16,442 - - - - 16442 15,530 Non -pool.. invesMenls - 12]4,151 Utility Ua,es recervable(ne, of allowance for doubtful nnon-Ess) 326,023 W,W8 293019 - - 1.1635b 1083516 Grams onamoible 14849 Spedal a$ mparneds receivable 29.181 - - - 29,181 99892 Interest receivable 22.550 19,449 3,014 - - 45013 93,402 Other usbal bks 2.877 73,316 35459 224 - 112,426 162322 're Due from to, funds - - - - - lurverfores - Ill 840 - 102320 116,929 ResNtted duels Norpoolel cash and arab equivalen 127,543 - 122,543 171,267 Nmpwiesim-stmenis 12620,945 342,371 30,468 - - 12293.281 18386212 Pooled saalt and inves mantis 480.4% 1.138..2 Bo,5C0 - 1.705,4M 354,512 Prepaid! items 522.201 187,654 12,862 466 332 223,520 826,046 15,359,083 3307,293 1,204]34 49,931 25586 19.952,222 24,382,214 P.". plant and'p,srem Lend 1]5.869 - 112,240 - - 248.109 248.f. BuIMln9s 8.129,238 202,851 732,181 53,802 - 9.1[6,42 9009.289 ImprovemenLL Wllx 1uikn95 33522,238 13,067,412 83,122 375356 4,052 42102,985 L7,3E.340 Equip t 1165,291 922,W2 1,437361 431912 56110 4082.626 39:6.194 ConsWdion In pm9ress 8622.494 3280,283 11752,252 14220,432 51,550,630 12,522,520 2364,904 861,020 60962 22365.093 64.299.022 Less ammulated deprecation 12,120,329 240,]14 1752234 514045 33353 16.025.325 15.122812 39434251 15,122214 W2670 342025 22614 55539.224 49.622060 Tonal assets $54,299,334 $10435 W2 $1808,004 $396,956 $532W $25492.501 s74,044, 224 LIABILITIES AND FUND EQUITY AcmunO payable $281636 $241248 $85646 $28225 $12918 $1.155.323 $1,150,690 Aced lhbllend, Salanes.Wyroll lazes and bel 64.699 4,031 62.383 29,611 18,047 178,771 152610 Notes Payable - - 21638 21630 28402 Interest payable 450928 216216 6,356 - - 626043 54219] Other liabirms 54]61 232962 65 1,405 293298 246.910 Due to after funs 1469,966 - - 1469,958 1,358.995 Due to other 9ovemmenls 24(trt8 - - 24068 69250 Advance from other funds 332,503 250000 390,000 190004 1 6650] 1662540 Mile Current don-mn oflm9'tenn debt 6EO.o39 425 W] JS.. 1,170099 1449929 Lon, term debt me of anenl l ornor Revenue bonds payable 31,052,891 10,424,123 - 41472,014 41222408 Leasehold revenue minds payable 222933 - - 222933 977,807 Cenirosm. of Fort icipaem 1,125 WO 685.00) 425,IXp - - 2.535" 229(f Deferred revenues - - - 50 50 E#waled Landfill Closure and posbclosen, eat boun iabilily 3()0 YA,LN 321800 Total liabilities 32,025215 12,310.153 1686048 449.241 226015 51692212 52204052 Fund equity Contributed refusal 12,619212 5.116206 288505 645 3126 23,023,774 20905 668 Reamed earnings Reserved for debt service 33.3]3 104.040 153.333 181.11f37 Unreserved 121,074 858,148 (166,669) (`+3.430) (125941) 583182 693,387 Total fund yor lty 17,224,119 6124,04 121916 (52285) (1 T2 23795289 21780.222 Total lablllOes and fund equity $54799.334 $10435 W2 $1 B.... $396,956 ISO 2W $25492501 $240Ea)74 88 i City of Cape Girardeau, Missouri ENTERPRISE FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS FOR THE FISCAL YEAR ENDED June 30. 1999 89 SOLID GOLF SOFTBALL TOTALS SEWER WATER WASTE COURSE COMPLEX 1998-1999 OPERATING REVENUES Residential charges $1,426720 $2.408902 $1619,880 5- S- $5455,502 Commeroal charges 943597 1,713,503 22,703 - - 2679903 Transfer station Warges - - 564.977 - - 584 977 Equipment sales - - 7.135 4,491 11626 Concession revenues - - - 64.009 49,071 113,060 Golf course fees - - - 398,262 - 398,262 Softball complex fees - - - 61,504 61,504 Other foes and diaMei 36405 173,823 32,687 - - 242,915 Other miscellaneous 24757 11,767 15,307 271 137 52,239 TOTAL OPERATING REVENUES 2,431579 4,307,995 2,275,554 469,677 115,203 9.600 008 OPERATING EXPENSES Personnel services 619,110 102.390 912,182 242,097 213,702 2,290289 Materials and supWies 220,066 295,372 55.177 71,129 50,935 692679 Contractual services 91888 2,352,031 689,524 21.387 12,008 3,166.836 General operating expenses 22,567 120,373 16.828 45,363 44,282 249413 Sall projects, expense 39684 40,497 23.618 6,683 4,322 114804 Internal parody expenses 93005 44.960 128,966 38,764 26419 A4116 depreciation expense 1,069.495 441,554 206012 52,592 8,506 1,786159 Capital outlay 5.469 5469 TOTAL OPERATING EXPENSES 2355,815 3,397.185 2,032309 488,815 367,643 8,641,767 OPERATING INCOME (LOSS) 75764 910,810 243.245 (19,130) (252440) 958,241 NON-OPERATING REVENUE (EXPENSES) _ Investment revenue 815,774 108,664 53,068 3,721 365 961 612 Local grants - - 7,155 7.155 Federal grants - - - - - Sale of city properly 861 - 507 - 1 366 Compensation for damages 913 1,109 - 2.176 - 1270 Sale of fixed assets - 29,623 (923) - 28.700 Issuancepoat imom7ation (67,563) (26,213) (2,275) - (M.051) Interest and handling posts (1392187) (730,828) (82,090) (19,844) (10,418) (2 235467) ' TOTAL NON-OPERATING REVENUE (EXPENSES) (842,282) (61,565) (25,065) (13,440) (10,033) (1308.365) INCOME (LOSS) BEFORE OPERATING TRANSFERS (566518) 293245 218,180 (32,576) (262473) (350.144) Operating 12nsfers m 241 604 241 604 NET INCOME (LOSS) (566,518) 293,245 210,180 (32.576) (20,669) (108,540) RETAINED EARNINGS (DEFICIT), JULY1 720,925 714,903 (384,849) (20,852) (155 072) 075.055 PRIOR PERIOD ADJUSTMENT RETAINED EARNINGS (DEFICIT), JUNE30 $154,407 $1008,148 (8166.669) ($53430) ($175,941) $766.515 89 C", al Cape Girardeau, Mi .... I ENTERPRISE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE FISCAL YEAR ENDED June Id. 1199 0 90 SOLID GOLF SOFTBALL TOTALS SEWER _WATER WASTE COURSED COMPLEX 1996_1999 CASH FLOWS FROM OPERATING AO¶VITES: Operalmgmaoma(loss) 525,]64 3910, ST. 52a32a5 1$19130) (3252,0001 $950,241 Adjustments to mwnnle lerating Inoome to netsn promdad h, opard, avlimLas: Depraeialien 1Jag 495 "1, 55a AM 012 62592 BS6 1768,159 i Caro operd","anu red i'. - ],155 - - 2.155 Change In asses and 1iab saes: "oon9ee10e¢08Y In aCCeunb nada aEe SH A 115.729 (73,G8)1 (12) - 12J a. (Intoes.) des, ...In Inventory - 7J. - 2,120 - 9 558 ( Imase) deveaul In pmpalE }dns a07 P.d 4728 12 (158) 5,294 Man s.(deureefe)In—unb,... to. (12,th (26341) 51,696 11,1x8 b 4,662 se(.ese)d—ad liadis.a 125,065 (10,]061 (105$23) 6,049 12,200) 165,9]2) Increase(deaev I -dell Fpsbmeure dere nista (71 800) (71 LOU) NET CASH PROVIDED BY (USED IN) OPERATING Me ACTIVITIES 1]00.9]2 1039600 162328 62621 f�li U32) 2.259349 CASH FLOWS FROM NONCARTAL FINANCING ACTIVITIES: Oparaing hanAea m Irani Omar Nnds 241,604 241 600 NET CASH PROVIDED BY (USED IN) BY NONCAPITAL FINANCING ACTIVITIES 201 EW 2a15b CASH FLOWS FROM CAPITAL AND RELATE0 FINANCING ACTNTES: Proceeds hoon dere does 1.4. 199,400 Prccpa paw nd on"ona M'ds (..) (350000) - - 14050001 Plrcpel pa. on base purchase no. (4622221 (144409) - 18z, ME, PHKipel pa. on COP (14O,.) (BO,OD]) (350]3) 1255, WC) Prodded pad on SRF (123,0]7 1123, WO) Pnnoipal pad on -M,1 '.an S volas pllaCle on land - - (A 7.) (626a) nishoo pa, on Wrgs and ooll"Mona (49,220) IF.7021 (816x8) (19,044) (1O,a10 (1231,120) punches. .1 shed aaseb (41%123) 18552421 IS 512) 17747W - 15232,411) mceeds hdn a ale dl dose, 661 .W0 1856 W2 a9$4 Compan-101 lm damage, 913 1 169 2126 4.228 NET CASH PROVIDED BY (USED IN) CAPITAL AND RELATED FINANCING ACTIVITIES SASS ].I19� f275 677) 1. El (10416) 16, 181 971) Me CASH FLOWS FROM INVESTING ACTVITES: Pu lo. o/Inveslmen, (272 S.) (1, I IJ. 520) (1 386.2) Plvdaede lmm vle olmvedmenls 1 "a Go - 121844 - - 12.. 6 642462 3603] 1101a - 09,514 O-Va J-1en 33239 91,919 49520 4DE0 450 129266 4672 4622 FMVser." ato-so 4,281 IS 471) (1SUI USE) 1651 fa a27) NET CASH PROVIDED BY JU$EO IN) INVESTING ACTIVITIES 1 756249 1991 255)- 1606]1 U 72 385 S. 231 INCREASE DEGREASE) IN CASH AND CASH EQUIVALENTS (2770,215) (148]495) 13282 (26,096) 114.261) 4 11207) CASH AND CASH EQUIVALENTS. JULY 1 16697620 2724259 1.166 25949 40010 202470]fi CASH AND CASH EQUIVALENTS, JUNE 3O $13 926 905 $1.240294 $775450 347$51 $25249 $16016,249 90 91 City of Cape Girardeau, Missouri SEWERFUND SCHEDULE OF REVENUES AND EXPENSES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 1999 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) OPERATING REVENUES Residential charges $1449,513 $1419,750 ($29.763) Commercial charges 932,354 950,615 16,261 Other lees and charges 40.000 36,405 (3,595) Other miscellaneous 62,500 24,757 (37 743) TOTAL OPERATING REVENUES 2484,367 2,431,527 (52,840) OPERATING EXPENSES Personnel services 842,772 819,110 23,662 Materials and supplies 236,725 218,646 18,079 Contractual services 113 091 96,188 16,903 General operating expenses 31,435 22,567 8.868 Special projects expense 27,250 17,388 9,862 Internal service expense 109,030 93,005 16,025 Capital outlay 9,153,370 3,934,367 5,219,003 TOTAL OPERATING EXPENSES 10.513.673 5,201271 5,312402 OPERATING INCOME (LOSS) (8,029,306) (2769,744) 5,259,562 NON-OPERATING REVENUE (EXPENSES) Investment revenue 240,000 717,497 477,497 State grants 154,050 - (154,050) Federal grants 200,000 - (200,000) Impact fees 125,000 190488 65488 Sale of city property - 881 881 Compensation for damages - 913 913 Gain on sale of fixed assets - - - Sewer assessments 15.000 20,710 5,710 Principal payments (837,434) (841,277) (3,843) Interest and handling costs (620,288) (1,042,659) (422.371) TOTAL NON-0PERATING REVENUE (EXPENSES) (723,672) (953,447) (229.775) NET INCOME (LOSS) (8,752,978) ($3723,191) 55,029,787 91 92 City of Cape Girardeau, Missouri WATER FUND SCHEDULE OF REVENUES AND EXPENSES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 30, 1999 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI OPERATING REVENUES Residential charges $2483217 $2407,855 (95,362) Commercial charges 1,633,254 1,707,882 74,628 Other fees and charges 166,000 173,823 7,823 Other miscellanepus 5,000 11,767 6,767 TOTAL OPERATING REVENUES 4,287,471 4,301,327 13.856 OPERATING EXPENSES Personnel services 102,091 102,397 (306) Materials and supplies 287,200 297,080 (9,880) Contractual services 2,507,560 2,388,902 118.658 General operating expenses 129,750 120,373 9,377 Spedal projects expense 45.000 40,497 4,503 Internal service expense 52,482 44,960 7,522 Capital outlay 484,015 528,184 (44,169) TOTAL OPERATING EXPENSES 3,606,098 3.522.393 85,705 OPERATING INCOME (LOSS) 679,373 778,934 99,561 NON-0PERATING REVENUE (EXPENSES) Investment revenue 102,575 144,780 42,205 Federal grants - - - Compensation for damages - 1.189 1,189 Gain on sale of fixed assets - 46,000 46.000 Prinapal payments (475,950) (475,950) - Interestandhandlingcosts (689,880) (693,782) (3,902) TOTAL NON-OPERATING REVENUE (EXPENSES) (1,063,255) (977,763) 85,492 NET INCOME (LOSS) (383,882) (5198,829) 5185,053 92 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, 1999 93 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) OPERATING REVENUES Residential charges $1604,315 $1,59],182 (57.133) r. Commercial charges 17,000 25,831 8,831 Transfer station charges 384,948 532,822 147,874 Other fees and charges 35.000 32,687 (2,313) Other miscellaneous 2,500 15,307 12,807 TOTAL OPERATING REVENUES 2,043,763 2,203.829 160,066 OPERATING EXPENSES Personnel services 908,644 915,639 (6,995) Materials and supplies 79,563 55,938 23,625 Contractual services 728,483 706.530 21,953 General operating expenses 32,500 16,828 15,672 Special projects expense 78,714 82,963 (4,249) Internal service expense 185,870 128,968 56,902 Capital outlay 31,700 7,989 23,711 TOTAL OPERATING EXPENSES 2,045.474 1,914,855 130619 OPERATING INCOME (LOSS) (1,711) 288,974 290,685 NON-0PERATING REVENUE (EXPENSES) Investment revenue 29,150 60,577 31,427 Local grants - 7,155 7,155 Federal grants - - - Saleofcityproperty - 1,856 1,856 Principal payments (179,400) (386,172) (206,772) Interest and handling costs (88,540) (83,848) 4,692 TOTAL NON-OPERATING REVENUE (EXPENSES) (238,790) (400,432) (161642) NET INCOME(LOSS) (240,501) ($111458) $129,043 93 _ 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, 1999 VARIANCE FAVORABLE BUDGET ACTUAL fUNFAVORABLEI OPERATING REVENUES Equipment sales 58,000 $],135 ($865) Concession revenues 76,000 64,009 (1 1991) Golf course fees 436,050 398,262 (37788) Other miscellaneous 271 271 TOTAL OPERATING REVENUES 520,050 469677 (50.373) OPERATING EXPENSES Personnel services 246,760 242,896 3,864 Materials and supplies 55,214 75,214 (20,000) Contractual services 23,700 22,837 863 General operating expenses 52,600 45,117 7,483 Spectral projects expense 6,200 6,683 (483) r Internal service expense 49,089 38.764 10,325 Capital outlay 71,976 77,479 (5,503) TOTAL OPERATING EXPENSES 505,539 508,990 (3451) OPERATING INCOME (LOSS) 14511 (39.313) (53,824) NON-OPERATING REVENUE (EXPENSES) Investment revenue - 4,077 4,077 Sale of city property - 507 507 Compensation for damages 2,176 2,176 Sale of fixed assets - - - Interest and handling costs (19,500) (19.844) (344) TOTAL NON-OPERATING REVENUE (EXPENSES) (19,500) (13,084) 6,416 INCOME (LOSS) BEFORE OPERATING TRANSFERS (4.989) (52,397) (47,408) Operating transfers in NET INCOME (LOSS) (4,989) ($52,397) ($47408) 94 95 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, 1999 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI OPERATING REVENUES Equipment sales $5,000 54,491 (5509) Concession revenues 52,000 49,071 (2,929) Softball complex fees 70,000 61,504 (8,496) Other miscellaneous 137 137 TOTAL OPERATING REVENUES 127,000 115,203 (11,797) OPERATING EXPENSES Personnel services 211,007 213,702 (2,695) Materials and supplies 57.047 50,462 6.585 Contractual services 12,200 12,008 192 General operating expenses 34,950 44,282 (9,332) Special projects expense 3,000 4,595 (1,595) Internal service expense 24,900 28,419 (3,519) Capital outlay 4,500 5,469 (969) TOTAL OPERATING EXPENSES 347,604 358,937 (11,333) OPERATING INCOME (LOSS) (220,604) (243.734) (23,130) NON-0PERATING REVENUE (EXPENSES) Interest Income - 419 419 Interest and handling costs (11,000) (10418) 582 TOTAL NON-OPERATING REVENUE (EXPENSES) (11,000) (9,999) 1.001 INCOME (LOSS) BEFORE OPERATING TRANSFERS (231,604) (253,733) (22,129) Operating transfers in 186,604 241 604 55,000 NET INCOME (LOSS) (45,000) (512,129) $32,871 95 96 City of Cape Girards, Missouri INTERNAL SERVICE FUNDS COMBINING BALANCE SHEET June 30, 1919 rWiN Comparative ToGIs for June 30, 1998) Employees, Data Fleet Fringe Risk Equipment Totals probinisma Manaaement Benefit Manaaement Reolacemmt 06/30199 06130/98 ASSETS P-1. rash and investments $75.637 $154,677 5486,321 31,410,268 U77086 $2603989 $2691611 Non-pwle0 rash and rash tyWvalems - 27315 - 27315 6 815 Non-pooled mvestmenu - - 200,141 - 200,141 - Interest no ivable - - - 4.869 t 4870 1303 Other unbeivables 5.132 6,959 6646 22,508 - 41345 41802 Inventones - 3480 - - - 3,480 7220 Restricted assets Non-pn ied rash and rash equivalents 127 - - 132 259 290,116 Prepaid items 47,129 1,458 1.783 969 5.989 58,328 41.507 128025 166.574 522065 1638755 484,208 2,939,527 ]062,282 PropeM, dant and equipment Land 37,S O - - - 37,500 37,500 Buildings 643 421.178 - - - 421.821 421821 Improvements other buadings - 111.749 - - 113.749 111,749 Equipment 1922,507 315,581 983,178 3,221,266 2.630,644 Construction in progress 10,234 10234 1.923.150 098.242 - - 983,170 ],804,570 3.203.714 i Less accumulaed depreciation 1,068.869 439,495 296764 1,805,128 1427.606 854-281 458747 686,414 1.999 4,42 1775,108 Total assets $91 $6251321 $522065 $1638.755 $1,170.622 H.939069 H838390 LIABILITIES AND FUND EOUITf _ Accounts payable $78.150 $54,339 i $36.531 $38.975 $217.995 $214,672 Accrued liabilities Salaneepayral taxes and benefits 5,084 za, 730 - - - 33,514 29.542 Interest Payable 5,852 10 - - 6,071 11.933 12786 Other lob ties 57 - - 57 53 Estimated burns payadle - - - 297205 - 297,205 fad 996 Due In her govemments - 2012 - 2012 2436 Current portion of long-tem Oehl 60000 - 60000 120000 110000 Long-lane debt net of count portion CertRrales of pares pation 264 781 274,532 $39313 559.124 Total liabilities 413867 95.140 333736 379.578 1323,329 1637609 Retained eamings Unressrved 568,439 530,173 522,065 1305.019 791044 3,716740 3,200701 Tomil fund equity 588439 530.173 522065 1,305.019 791044 3.716.740 3200.701 Total liabilities and fund equity $962306 £625321 $522065 $1636755 $1.170.622 H, 939.069 $4,038390 96 Blry OI Cape GRandrau, Missouri INTERNAL SERVICE FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS FOR THE FISCAL YEAR ENDED June 30,1999 97 EMPLOYEES' DATA FLEET FRINGE RISK EQUIPMENT TOTALS PROCESSING MANAGEMENT BENEFIT MANAGEMENT REPLACEMENT 1998-1999 OPERATING REVENUES "Pird... intend, -"-a $303325 $933.367 $1359,596 $276.815 $165000 $3078101 Olen mismllanepus 300 5 305 TOTAL OPERATING REVENUES 303 625 933,372 13595% 276.815 165.0]0 3,076408 OPERATING EXPENSES Pawnnel--. 93,559 438325 84,0 7 - 621221 Materials and supplies 6297 276510 - - 2U 807 Contract servws 90.391 145,208 1,286ID9 171.629 - 1695337 General apereling expenses 98T 3,614 - 24,492 - 29,093 Internal service aspmses - 2,282 - - 2,282 Oepeaafun..pens. 194,865 42531 140,126 3]],522 TOTAL OPERATING EXPENSES 393399 930,4]0 1372,146 198121 100.126 3,010.262 OPERATING INCOME (LOSS) (49 770) 24.902 (12,550) Sal 2a874 ill NON-OPERATING REVENUES (EXPENSES) nvesMenl revenue 4936 644 41,106 711 17,048 LQ 911 Sale at ce, al 520 - 22260 22704 _ issuardes msl earn ...n (2,612) 12,505) (5.157) Interest and handling trusts (17621) (2327) (19.276) (39224) TOTAL NON-OPERATING REVENUES (EXPENSES) (15.295) (1,163) 41.108 79,173 12091 121.314 INCOME (LOSS) BEFORE OPERATING TRANSFERS (65,069) 23739 28,558 159867 02365 189460 OPoraling lranslen In - - 5w D00 5X) DM oaralmp van nm out (173500) (113,5001 NET INCOME (LOSS) (65069) 23739 (144942) 159,867 542.365 515900 RETAINED EARNINGS (DEFICIT), JULY1 633500 505.434 FIT W7 1145.152 248679 320.780 RETAINED EARNINGS (DEFICIT), JUNE $560,439 $530,173 $522.065 $1305,019 $791044 $3]16.740 P 97 + Clty of Cape Girardea, M'naoun INTERNAL SERVICE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE FISCAL YEAR ENDED lune 30, 1999 + EMPLOYEES' DATA FLEET FRINGE RISK EQUIPMENT TOTALS PROCESSING MANAGEMENT BENEFIT MANAGEMENT REPLACEMENT 1998-1999 + CASH FLOWS FROM OPERATING ACTIVITIES: On.1e11ng lrcgm I ... ) 1349]]41 $24, WC ($12,550) .0,694 $2,1 07a ¢8.107 Mjusimenb lO—nab F.'sun, m o nrash provided by operatng actadM Deprecat'on 1. %5 42,531 - 1a0.12fi 3]]522 + Chong— aes.l. and AN,,As. (Increase) decreaaeln armunts recamadle ]n 043 (201) - 557 (Increase) de Ge aaem.....I., - C 74 - - 3148 Increase) decrease In p.p.. s—, (20,994) 756 11 ]83) - - 1219011 In—M, (deaeasel in .—ta peyadle 20,162 141992) (248,105) 1369$92) 38,9]5 1605 6]21 + "'pass,...... ...cvuM llaMulles 18]13 5 m] 2.72Fl 301461 NET CASH PROVIDED 0Y (USES IN) OPERATING AOTNTES 143,428 30009 (2� B,dfia 20] 9]5 123601 Ase CASH FLOWS FROM NONCAPITAL FINANCING ACTVMES: Opmalmg nansleso Yon oNer funds - - - SN.OW 500000 Opermmg enders out to Olner funds t]3`�M- 1173.5001 + NET CASH PROVIDED BY (USED ]NJ NONCAPITAL FINANCING ACTIVITIES 1 ]3�500)- $p0,p00 326500 CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES: + PreetJpan, - COP (55 000) - - 156007) If10, 0.U) P,rdoad pals - —,,Y ben 6 Mie Mandl On land - (@Q - - 1424) Inness, Pa. -Conde .M OOIIgaLms (18,006) (2,52]) - - (19073) (]9 066) PVN.»M foes AMM. 1256, 757) (22,240) - (921907) (607,85]) Preceada Iron, .ale Wessel¢ - 520 - 212. 22,704 + NET CASH PROVIDED BY (USED IN) CAPITAL AND RELATED FINANCING ACTIVITIES (3$243) 124,4 - (3]3 6691 l CASH FLOWS FROM INVESTING ACTIVITIES: + Purchase of --Imams - - 1207,141) (200,141) en b $95 5,6w 66J9 12 724 0-mag"-mag"l"anset 5.172 760 45,1. ]S,i NI 12 574 136026 FM adjustments la rash 1$21 (116) (40as� I. "i 11.029) (12.]1 + NET CASH PROVIDED BY IUSEO IN)INVESTING ACTIVITIES 5005 fide 41,108 (125,83]) 10,104 1608%) INCREASE (DECREASE) IN CASH AND CASH EQUIVALENTS (181 510) 6,162 3794,057) (117,373) 5484. 1996,9]81 + CASH AND CASH EQUIVALENTS, JULY t 25]5]4 146495 908,107 1521601 126]20 29]0,$41 CASH AND CASH EQUIVALENTS, JUNE 30 $75]64 $1. 6]] $513636 $1410268 54]12 16 $2631%3 98 City of Cape Girardeau, Missouri DATA PROCESSING FUND SCHEDULE OF REVENUES AND EXPENSES - BUDGET AND ACTUAL (BUDGET BASIS) FOR THE FISCAL YEAR ENDED June 39, 1999 VARIANCE FAVORABLE BUDGET ACTUAL IUNFAVORABLEI 99 OPERATING REVENUES Interdepartmental services $342000 $343,325 $1,325 Other miscellaneous 300 300 TOTAL OPERATING REVENUES 342,000 343625 1,625 OPERATING EXPENSES Personnel services 114,370 98,858 15,512 Materials and supplies 6,200 8,182 (1,982) Contractual services 88,400 90,432 (2,032) General operating expenses 1,900 987 913 Capital outlay 125.000 113 766 11.234 r TOTAL OPERATING EXPENSES 335,870 312,225 23,645 OPERATING INCOME (LOSS) 6,130 31,400 25,270 NON-OPERATING REVENUE (EXPENSES) Investment revenue - 5,368 5,368 Principal payments (55,000) (55.000) - Interestandhandlingcosts (18,150) (10486) (336) TOTAL NON-OPERATING REVENUE (EXPENSES) (73,150) (68,118) 5,032 NET INCOME (LOSS) (567,020) ($36,718) $30.302 r 99 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, 1999 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLE) OPERATING REVENUES Interdepartmental services $944,000 $933,367 ($10,633) Other miscellaneous 5 5 TOTAL OPERATING REVENUES 944,000 933,372 (10628) r OPERATING EXPENSES Personnel services 469,179 438,326 30,853 Materials and supplies 304,375 277,196 27,179 Contractual services 120,975 145,208 (24,233) General operating expenses 2,500 3,614 (1,114) Internal service expense 2,282 2,282 - Capital outlay 28,150 25,615 2,535 TOTAL OPERATING EXPENSES 927,461 892,241 35,220 OPERATING INCOME (LOSS) 16,539 41,131 24,592 NON-OPERATING REVENUE (EXPENSES) Investment revenue - 704 704 Sale of dry property - 520 520 PrinGpal payments - (424) (424) Interest and handling at. (2.329) (2,329) TOTAL NON-OPERATING REVENUE (EXPENSES) (1,529) (1,529) r INCOME (LOSS) BEFORE OPERATING TRANSFERS 16,539 39,602 23,063 Operating transfers in NET INCOME(LOSS) $16,539 $39,602 $23,063 100 101 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, 1999 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI OPERATING REVENUES Interdepartmental services $1075,819 51,359,596 $283,777 TOTAL OPERATING REVENUES 1075,819 1,359,596 283,777 OPERATING EXPENSES Personnel services - 84,037 (84,037) Contractual services 1,272,894 1,288,109 (15.215) TOTAL OPERATING EXPENSES 1,272,894 1,372,146 (99,252) OPERATING INCOME (LOSS) (197,075) (12.550) 164,525 NON-OPERATING REVENUE (EXPENSES) Investment revenue 49,500 45.136 (4,364) TOTAL NON-OPERATING REVENUE (EXPENSES) 49.500 45.136 (4.364) INCOME (LOSS) BEFORE OPERATING TRANSFERS (147,575) 32,586 180,161 Operating transfers out (173,500) (173,500) NET INCOME (LOSS) ($321,075) ($140,914) $180,161 101 + 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, 1999 1O2 VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI OPERATING REVENUES Interdepartmental services $248,675 $276,815 $28.140 TOTAL OPERATING REVENUES 248,6]5 276,815 28.140 OPERATING EXPENSES Contractual services 315,000 171,629 143,371 General operating expenses 24,492 (24492) TOTAL OPERATING EXPENSES 315,000 196.121 118,879 OPERATING INCOME (LOSS) (66,325) 80,694 147,019 .� NON-OPERATING REVENUE (EXPENSES) Investment revenue 66,000 85,837 19,837 TOTAL NON-OPERATING REVENUE (EXPENSES) 66.000 85,837 19,837 NET INCOME (LOSS) (5325) $166,531 $166.856 1O2 + 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, 1999 + VARIANCE FAVORABLE BUDGET ACTUAL (UNFAVORABLEI 103 OPERATING REVENUES Interdepartmental services $225,000 $164,999 ($60,001) + TOTAL OPERATING REVENUES 225,000 164,999 (60,001) OPERATING EXPENSES + Capital outlay 526000 470,150 55,850 TOTAL OPERATING EXPENSES 526.000 470,150 55,850 OPERATING INCOME (LOSS) (301,000) (305,151) (4,151) NON-OPERATING REVENUE (EXPENSES) + Investment revenue 10.000 18,182 8.182 Sale of city, property - 22,264 22.264 Principal payments (55,000) (55000) - Interest and handling costs (18.750) (19,073) (323) TOTAL NON-OPERATING REVENUE (EXPENSES) (63.750) (33627) 30,123 INCOME (LOSS) BEFORE OPERATING TRANSFERS (364,750) (338,778) 25972 Operating transfers in 500,000 500.000 NET INCOME (LOSS) $135,250 $161222 $25972 + 103 104 City of Cape Girardeau, Missouri AGENCVFUNDS COMBINING BALANCE SHEET June 30, 1999 (With Comparative Totals for June 30, 1998) Park Arena Development Totals + Library Improvement Foundation 06130/99 06130/98 ASSETS + Pooled cash and investments $546,367 $63,012 $112,060 $721,439 $607,923 Non -pooled investments 17,696 - - 17,696 - Receivables, net of allowances for doubtful receivables Real estate tax 18,334 - - 18,334 17,229 Personal property tax 4,287 - - 4,287 4,744 Other receivables 112 190 302 102 Total assets $586,796 $63,202 $112,060 $762,058 $629,998 .� LIABILITIES Accounts payable $5,839 7.027 $4,708 $17,574 $8,843 Accrued liabilities Salanes, payroll taxes and benefits 12,525 - - 12,525 10,854 Other liabilities 568432 56,175 107,352 731,959 610,301 Deferred compensation due employees - - y Total liabilities $566,796 $63,202 $112060 $762,058 $629.998 104 Gp .f C, GIII-11, M,111.1 COMBINING STATEMENT OF CHANGES IN ASSETS AND LABILTHES ALL AGENCY FONDS FON THE FISCAL YEAR ENDED JUNE 30, 1999 _ P:� ue„N ILIl 4 T.aa ASSETS _aNulvl 1998 900 SBe,]99 3591%J NmpodMM1 lJ. "devm w M �m�ade 1],229 S T PMMNNI wopaM Iu- - v,]H ORM m' flk, 102 1102 im+I A ... H........... 1514 211 Sw 988 S.1. £029590 PoMM ON aM FIII v1 1 .z2i92 $3SE250 5191590 116]BBV NortplulMmMFI - 22 797 I aYwm[n lw ervemdea NRNM _ G 437417 - 427 417 PwMmY W y - 15] 255 Cvxlliveda+ xwI M t50 1]a0 TWIaGONaru .1 1a4 SYA HB 1191598 52,2+2BM rI0.I PWeO0M aM nva+mvn411 0 D 5274, 2l4 11SH1.1 W1 N.- R—M.+. mI NMW—it, wIgW9 B.Y.Nb. 12MyG 4B 11l rmd wcperryW )Il -11CI 112 0W1wneWe 1a0 1a0 T-1.1-1 it 6]1995 131a 31 $2110509 +i JumN 1999 SNU.]0l 13 $11, I'll 41S 8096 - 2090 A. Persona pmpMly e20i - a 2B] ONet lsulvadee 11l 150 ]02 T.FI n+m tl Jum l0, 1999 S586 796 LI Cal $t t3C80 17SF.IS .ABN➢ES __ .11.1',1 199e me payed. S0, J12 L N91 SBYJ SYawL IM, Wea aM —I 1OBN DAM, R.I.. 9BB Ba.J00 ,I., 11+694.. M 1.1, 1, 19N UU 4 211S]0988 SN,199 SJa]+0+ 250]]0 N]]C9 N+1 CIO SMan, w9+o03N AMA n44em6N 150.901 1%901 Du.ILANG, J]15D] J9J,02s z0+,W2 2,OR JJ7 TNRIRMM.. U 87SLMCSu0J9s 5228111 S30M]]1 0.MIom van. pryade FOR 117 Sa9Ja1 5]9W2 H]2]12 SM.Ie.F FAIII—antiI 5519] - -1112. Gme111aduWe y39001C 1. All 71S 92< 609 TOY. GebUon. 5190 12,11l 111 Ba+n 9 11 IS ]02] .1. SP, SA F. SMw.tl WY I+Wee m4 M,.E. 12525 G .mr.iadYOee ]I?,959 T..I RwwIiG-al1.— ..1999 5585,]96 ME 202 1111 5]02FIR 105 City of Cape Girardeau, Missouri SCHEDULE OF GENERAL FIXED ASSETS BY SOURCE June 30, 1999 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 Donated assets TOTAL INVESTMENT IN GENERAL FIXED ASSETS 106 $2,086,593 8,519,957 4,114 482 1,294,265 y IO,UJO,Gl4 $3,703,023 10,351,749 2,082,313 (98,811) $16,038,274 ' City of Cape Girardeau, Missouri SCHEDULE OF GENERAL FIXED ASSETS - BY FUNCTION AND ACTT June 30, 1999 Improvements Machinery Construction Other Than and In Function and Activity Land Buildings Build Equipment Proposes Total ADMINISTRATIVE SERVICES Human resources S- S- $- $707 $- $707 City manager 200.000 92,212 - 854 - 293,066 Maintenance - - 2.901 - 2,901 City attorney - - - 2,128 - 2,128 Interdepartmental 67,340 - 25.643 14,246 - 107,229 Finance - - - 578 - 578 CVS - 146,973 16,534 14,426 177,933 Airport 354,649 263,029 3.466,558 188,591 4.272,827 TOTAL ADMINISTRATIVE SERVICES 621,989 502,214 3.495.102 223,638 14.426 4,89,369 DEVELOPMENT SERVICES Planning services - - - 6,345 - 6,345 Inspections - - - 1,110 - 1,110 Community information program - - - 14,838 - 14,838 Engineering services 45,932 45.932 TOTAL DEVELOPMENT SERVICES 68.225 63225 PARKS AND RECREATION Park maintenance 855,238 290.719 13.883 69.741 - 1,229,581 Arena maintenance - - 18.141 - 18,141 Municipal band - - 2455 - 2,455 Recreation - - - 1,223 - 1223 Cemetery 4.120 3,886 - 14744 - 22,750 Central pool - 569.503 3.994 2554 - 5761,051 Casaba pool - - 4,910 - - 4,910 Osage Community Centre - 2,563,292 - 76,399 - 2.639,691 Softball Complex 2,310,065 21,773 2.331838 TOTAL PARKS AND RECREATION 859,358 5737 465 22,787 207,030 6.826.640 PUBLIC SAFETY Municipal court - - - 170 170 - Health - - - 7,931 - 7,931 Police 23.400 187,525 1,337 151,501 - 363763 Fire 217.705 741,589 6.827 431,339 1,397460 TOTAL PUBLIC SAFETY 241,105 929.114 8.164 590,941 1769,324 PUBLIC WORKS Street - - - 161,229 - 161,229 Sternness, 43,202 43,202 TOTAL PUBLIC WORKS 204,431 204,431 CAPITAL OUTLAY General capital improvements 10,000 1,316,808 506,716 - 8,551 1,842,075 Park improvements 354,141 34,356 81713 470,210 TOTAL CAPITAL OUTLAY 364.141 1351,164 588.429 8.551 2312.285 TOTAL GENERAL FIXED ASSETS $2,086.593 $8.519,957 S4,114,482 51,294265 $22,977 $16.038174 107 108 City of Cape Girardeau, Missouri SCHEDULE OF CHANGES IN GENERAL FIXED ASSETS - BY FUNCTION AND ACTIVITY FOR THE FISCAL YEAR ENDED JUNE 30, 1998 General Fixed General Fixed Assets Depreciation Assets Function and Activity 06130198 Additions Deductions Expense 06130199 ADMINISTRATIVE SERVICES Human resources 8938 $- S 8231 $707 City manager 303,397 - 10331 293.066 Facility maintenance 3,249 - - 348 2,901 City anomey 890 1,911 - 673 2.128 Interdepartmental 115,013 - - 7784 109,229 _ Finance 844 - - 266 578 CVB 159,160 25,830 - 7,057 177.933 Airport 4399,573 117473 244,219 4.272,827 TOTAL ADMINISTRATIVE SERVICES 4.983,064 145.214 270.909 4,857,369 DEVELOPMENT SERVICES Planning serncss 3.336 4,400 - 1,391 6,345 Inspections - 1,315 - 205 1,110 Community information service 16,905 2,289 - 4,356 14,838 Engineering semces 42,764 13,094 9.926 45.932 TOTAL DEVELOPMENT SERVICES 63,005 21,098 15,878 68,225 PARKS AND RECREATION Park maintenance 1262,829 22,852 - 61.150 1,229,581 Arena maintenance 20,065 680 - 2,604 18,141 _ Municipal band - 2.455 - - 2455 Reueatipn 887 680 - 344 1,223 Cemetery 30,385 - - 7.635 22750 Central pool 604,801 - - 28,750 576,051 Capons pool 5.544 - 634 4910 Osage Community Cento 2726,913 17,484 - 104,706 2,639,691 Softball Complex 2417722 85884 2,331,838 TOTAL PARKS AND RECREATION 7,069,196 49,151 291707 6.820640 PUBLIC SAFETY i Municipal court 305 - - 135 170 Health 11,555 - - 3,624 7.931 Police 429.772 20,431 - 86.440 363.763 Fire 1493,647 35.567 131754 1,397,460 a. TOTAL PUBLIC SAFETY 1935279 55998 221.953 1769,324 PUBLIC WORKS Street 213,395 7,718 - 59884 161.229 _ Stonnwater 62,447 1,200 20445 43,202 TOTAL PUBLIC WORKS 275,842 8,918 80.329 204 431 CAPITAL OUTLAY General capital improvements 1,924,197 - - 82.122 1842075 Park Improvements 454,933 24,127 8850 470,210 TOTAL CAPITAL OUTLAY 2,379.130 24,122 90,972 2312,285 TOTAL GENERAL FIXED ASSETS S16,705 516 5304506 S- 8971748 $16,038.274 108 City of Cape Girardeau, Missouri SCHEDULE OF CHANGES IN LONG-TERM DEBT FOR THE FISCAL YEAR ENDED June 30, 1999 General Geneal Long-term Long-term Debt Debt July 11998 Additions Retirements June 301999 GENERAL LONG-TERM DEBT Revenue bonds payable $- $25,495,000 $- 525.495,000 Leasehold revenue bonds payable 6,132,230 350,000 1,712,314 4,769,916 Certi4wtes of participation payable 5295,000 - 450,000 4,845,000 General obligation refunding bonds payable 2,740,000 - 345,000 2,395 000 Accrued benefits 563,051 39,116 - 602,167 Due to other governments -State energy loan 39.125 12,795 26,330 TOTAL GENERAL LONG-TERM DEBT $14,769.406 $25,884,116 $2,520,109 $38,133,413 City of Cape Girardeau, Missouri STATEMENT OF GENERAL LONG-TERM DEBT June 30,1999 AMOUNT AVAILABLE AND TO BE PROVIDED FORTH E 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 DUE TO OTHER GOVERNMENTS -STATE ENERGY LOAN Amount available in debt service fund Amount to be provided TOTAL AMOUNT AVAILABLE AND TO BE PROVIDED GENERAL LONGTERM DEBT PAYABLE Revenue bonds payable Leasehold revenue bonds payable Certificates of participation payable General obligation refunding bons payable Accrued benefits Due to other governments -State energy loan TOTAL GENERAL LONG-TERM DEBT PAYABLE It0 25,495,000 $25495,000 $1,977,112 2,792,804 $4,769916 889,281 3,955.719 4,845,000 787,988 1,607.012 2,395,000 602,167 602,167 26,330 26,330 $38,133,413 S25495 000 4,769,916 4 845 000 2.395,000 602.167 26 330 538,133,413 SINGLE AUDIT SECTION Begley-, Janssen, Young & Birk, LC CERTIFIED PUBLIC ACCOUNTANTS 2103 THEMIS STCAPEGI RARDEAU. MISSOURI 63901 TELEPHONE (573) 334-2845 - FAX (573) 334-4338 MEMBERS TERRY R. BEGLEY, CPA JEFF UNTERREINER, CPA LAWRENCE E. YOUNG, CPA CATHERINE A. WHITE. CPA KELVIN W BIRK, CPA DEBORAH E DENEKE ` JOHN R. JANSSEN, CPA INDEPENDENT AUDITORS' REPORT ON COMPLIANCE WITH REQUIREMENTS APPLICABLE TO EACH MAJOR PROGRAM AND INTERNAL CONTROL OVER COMPLIANCE IN ACCORDANCE WITH OMB CIRCULAR A-133 Honorable Mayor and Members of the City Council 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, 1999. The City of Cape Girardeau, Missouri's major federal programs are identified in the summary of the auditor's results section of the accompanying schedule of findings and questioned costs. Compliance with the requirements of laws, regulations, contracts and grants applicable to each of its major federal programs is the responsibility of the City of Cape Girardeau, Missouri's management. Our responsibility is to express an opinion on the City of Cape Girardeau, Missouri's compliance based on our audit. D We conducted our audit of compliance in accordance with generally accepted auditing standards; the standards applicable to financial audits contained in Government A d' na Standards, issued by the Comptroller General of the United States; and OMB Circular A-133, "Audits of States, Local Governments, and Non -Profit Organizations". Those standards and OMB Circular A-133 require that we plan and perform the audit to obtain reasonable assurance about whether noncompliance with the types of compliance requirements referred to above that could have a direct and material effect on a major federal program occurred. An audit includes examining, on a test basis, evidence about the City of Cape Girardeau, Missouri's compliance with those requirements and performing such other procedures as we considered necessary in the circumstances. We believe that our audit provides a reasonable basis for our opinion. Our audit does not provide a legal determination of the City of Cape Girardeau, Missouri's compliance with those requirements. In our opinion, the City of Cape Girardeau, Missouri complied, in all material respects, with the requirements referred to above that are applicable to each of its major federal programs for the year ended June 30, 1999. 112 Honorable Mayor and Members of the City Council City of Cape Girardeau, Missouri Page 2 Internal Control Over Compliance The management of the City of Cape Girardeau, Missouri 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. We noted a certain matter involving the internal control over compliance 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 compliance that, in our judgement, could adversely affect the City of Cape Girardeau, Missouri's ability to administer a major federal program in accordance with the applicable requirements of laws, regulations, contracts and grants. The reportable condition is described in the accompanying schedule of findings and questioned costs. 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 the 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. Our consideration of the internal control over compliance would not necessarily disclose all matters in the internal control that might be reportable condition that are also considered to be material weakness. However, we believe that the reportable condition described above is not a material weakness. Schedule of Expenditures of Federal Awards We have audited the general purpose financial statements of the City of Cape Girardeau, Missouri as of and for the year ended June 30, 1999 and have issued our report thereon dated December 27, 1999. Our audit was performed for the purpose of forming an opinion on the general purpose financial statements taken as a whole. The accompanying schedule of expenditures of federal awards is presented for purposes of additional analysis as required by OMB Circular A-133 and is not a required part of the general purpose financial statements. Such information has been subjected to the auditing procedures applied in the audit of the general purpose financial statements and, in our opinion, is fairly stated, in all material respects, in relation to the general purpose financial statements taken as a whole. 113 Honorable Mayor and Members of the City Council City of Cape Girardeau, Missouri Page 3 This report is intended for the information of the City Council, management of the City of Cape Girardeau, Missouri, and federal awarding agencies and pass-through entities. However, this report is a matter of public record and its distribution is not limited. a BEGLEY, JANSSEN, YOUNG & BIRK, LC u Cape Girardeau, Missouri December 27, 1999 114 Begley, Janssen, Young & Birk, LC ^ CERTIFIED PUBLIC ACCOUNTANTS 2103THEMISST- CAPE GIRARDF!All, UISSOUAIG3T01 TELEPHONE (51-3) 334 -2245 -FAX (g73) 3311-4338 ^ MEMBERS TERRY R. BEGLEY, CPALAWREJEFF UNTERR EIN ER. CVA KELVIN ELVIN W W B E. IRK, CPA YOUNG, CPA CATHERINE A. WHITE, CPA K DEBORAH E OEN EKE JOHN R. JANSSEN, CVA tt5 INDEPENDENT AUDITORS' REPORT ON COMPLIANCE AND ON INTERNAL CONTROL OVER FINANCIAL REPORTING BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH C''$gNMEN'"_�'irZTING 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, 1999, and have issued our report thereon dated December 27, 1999. We conducted our audit in accordance with generally accepted ^ auditing standards and Government Auditing Standards, issued by the Comptroller General of the United States. .. Compi iaryr� 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 T�rnaJ on ro"I Ov * Finan gal Reno ing in planning and performing our audit, we considered the City of ^ Cape Girardeau, Missouri's internal control over financial reporting in order to determine our auditing procedures for the purpose of expressing our opinion on the financial statements and ^ not to provide assurance on the internal control over financial reporting. However, we noted a certain matter involving the internal control over financial reporting and its operation that we consider to be a reportable condition. Reportable conditions ^ involve matters coming to our attention relating to significant deficiencies in the design or operation of the internal control over financial reporting that, in our judgment, could adversely ^ affect the City of Cape Girardeau, Missouri's ability to record, process, summarize and report financial data consistent with the assertions of management in the financial statements. The reportable condition is described in the accompanying schedule of -� findings and questioned costs. tt5 Honorable Mayor and Members of the City Council City of Cape Girardeau, Missouri Page 2 A material weakness is a condition in which the design or operation of one or more of the internal control components does not reduce to a relatively low level the risk that misstatements in amounts that would be material in relation to the financial statements being audited may occur and not be detected within a timely period by employees in the normal course of performing their assigned functions. Our consideration of the internal control over financial reporting would not necessarily disclose all matters in the internal control that might be reportable conditions and, accordingly, would not necessarily disclose all reportable conditions that are also considered to be material weaknesses. However, we believe that the reportable condition described above is not a material weakness. This report is intended for the information of the City Council, management of the City of Cape Girardeau, Missouri, and federal awarding agencies and pass-through entities. However, this report is a matter of public record and its distribution is not limited. BEGLEY, J.ANSSEN, YOUNG & BIRK, LC ( Cape Girardeau, Missouri December 27, 1999 116 City of Cape Girardeau, Missouri SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS For the Year Ended June 30, 1999 Federal Federal Grantor/Pass-through CFDA Federal Grantor/Program Title Number Expenditures The accompanying notes are an integral part of this schedule. to Department of Education Passed through Missouri State Library .� Basic Equipment Grant S -BE -12 84.034A $ 12,149 Basic Equipment Grant 7-02-500-08 84.034A 721 Total Department of Education 12.870 Department of Housing and Urban Development Passed through Missouri Dept of Economic Development Community Development Block Grants 95 -ND -02 Locust/Maple 14.219 120,044 97 -ND -003 Jefferson/Shawnee Parkway 14.219 15,100 _ 94 -DR -96 Flood Buyout Program 14.219 83.376 Subtotal 218.520 Passed through Missouri Dept of Social Services Emergency Shelter Grant 14.231 23,666 Total Department of Housing and Urban Development 242,186 r Department of the Interior Environmental Protection Agency Passed through Missouri Dept of Natural Resources SRF Loan Series 1991A C295004-01 66.458 39,588 SRF Loan Series 1993A C295004-02 66.458 12,964 SRF Loan Series 1995D C295229-01 66.458 395,731 SRF Loan Series 1996D C295229-02 66.458 165,542 SRF Loan Series I998B DW291010-01 66.458 �1 ,118 Subtotal 623,943 Federal Emergency Management Agency Hazes EMK-98-PA-0003 83.535 13,924 Project impact - 99 - GR -0028 83.551 7,901 Project Impact - 97 - GR -0038 83.521 41,834 National Park Department Historic Preservation Grant 29-97-12028-462 15.904 11 700 Total Department of the Interior 699.302 The accompanying notes are an integral part of this schedule. to a City of Cape Girardeau, Missouri SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS '— For the Year Ended June 30, 1999 Federal Federal Grantor/Pass-through CFDA Federal Grantor/Program Title Numbe Expenditures I18 Department of Justice Office of Justice Programs Local Law Enforcement Block Grant 97 -LB -VX -3234 16.592 $ 18,207 Juvenile Police Officer Grant 16.540 30,974 Weed and Seed Grant 99-WS-GX-0007 16.595 12.535 COPS More 98 Award 99 -CM -X-1820 16.710 288 COPS Universal Hiring Grant 97-UM-WX-0055 16.710 23.776 Subtotal 24.064 Passed through Missouri Dept of Public Safety State Services to Victims Funds 99-SSVF-0007 16.575 1,573 Victims of Crime Act (FY `97) 16.575 13.285 Subtotal 14.858 Total Department of Justice 100.638 Department of Transportation Safe Communities Grant - 99 -SA -09-2 20.600 52,628 Safe Communities Grant - 98 -SA -09-2 20.600 50.315 Subtotal 102,943 Public Taxi Coupon Transportation - MO -1 8-X01 8-4CG 20.509 99,725 National ISE TE Recreation Trails Funding Program 20.219 145.365 Community Team Spirit Conference 98-YA-03-04 20.601 9,534 " Community Team Spirit Conference 99-YA-03-06 20.601 2.262 Subtotal 11.796 Federal Highway Administration Passed through Missouri Highway and Transportation Dept Hopper Road Bridge BRO-BRM-016(18) 20.205 38.454 Total Department of Transportation 398.283 TOTAL FEDERAL EXPENDITURES $ 1.453.279 The accompanying notes are an integral part of this schedule. I18 City of Cape Girardeau, Missouri SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS For the Year Ended June 30, 1999 NOTE A - BASIS OF PRESENTATION The accompany schedule of expenditures of federal awards includes the 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 financial statements. Liq + THE CITY OF CAPE GIRARDEAU, MISSOURI SCHEDULE OF FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 1999 r A. SUMMARY OF AUDIT RESULTS 1. The auditor's report expresses an unqualified opinion on the statements of the City of Cape Girardeau, Missouri. 2. One reportable condition disclosed during the audit of the financial statements was reported in the Independent Auditors' Report on Compliance and on Internal Control over Financial Reporting Based on an Audit of Financial Statements Performed in Accordance with Government Auditing Standards. 3. No instances of noncompliance material to the financial statements were disclosed during the audit. 4. One reportable condition disclosed during the audit of the major federal award programs is reported in the Independent Auditors' Report on Compliance with Requirements Applicable to each Major Program and Internal Control over Compliance in Accordance with OMB Circular A-133. 5. The auditor's report on compliance for the major federal award programs for the City of Cape Girardeau, Missouri expresses an unqualified opinion. 6. Audit findings relative to the major federal award programs for the City of Cape Girardeau, Missouri are reported in this schedule. 7. The programs tested as major programs included: Department of Housing and Urban Development Community Development Block Grants CFDA # 14.219 Department of Transportation National ISE TE Recreation Trails Funding Program CFDA # 20.219 Department of Justice Community Oriented Policing Services (COPS) Grants CFDA # 16.710 120 SCHEDULE OF FINDINGS AND QUESTIONED COSTS CONTINUED PAGE 2 8. The threshold for distinguishing Type A and 3 programs was $300,000 in federal expenditures. 9. The City of Cape Girardeau, Missouri was determined to be a low-risk auditee. 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. Eft.: 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 employees. Recommendation: The City should comply with all aspects of the adopted Investment Policy. The Investment Committee should reinstate its quarterly meetings in order to effectively determine investments 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. C. FINDINGS AND QUESTIONED COSTS -MAJOR FEDERAL AWARD PROGRAMS 1. Department of Justice - Community Oriented Policing Services (COPS) Grants - CFDA # 16.710 Condition: Controls are not in place to provide _ reasonable assurance that cost principles are followed. Procedures should be in place to correctly identify allowed costs and compute for accuracy. Criteria: Allowed costs must be reasonable and necessary and conform to the limitations set forth in the grant documents. 121 SCHEDULE OF FINDINGS AND QUESTIONED COSTS CONTINUED PAGE 3 Effect: Unallowed costs could be submitted for reimbursement or maximum federal awards may not be expended. Recommendation: Procedures should be established so that personnel involved in the administration of the program be thoroughly familiar with the applicable rules, regulations and provisions of the grant award. Response: We concur with the recommendation. Such procedures will be implemented. 122