Loading...
III(B) Approval And Acceptance Of Quarterly Financial Report ' Agenda 8-15-2000 "CENTER OF GOOD LIVING-PRIDE OF WEST ORANGE" Item I�I B MAYOR• OMMISSIONER Ocoee S.SCOTT VANDERGRIFT ° •�o CITY OF OCOEE COMMISSIONERS �'r L Q 150 N.LAKESHORE DRIVE DANNY HOWELL v p SCOTT ANDERSON �, OCOEE,FLORIDA 34761-2258 RUSTY JOHNSON �yj•�� '~'` ``,? (407)656-2322 NANCY J.PARKER OF 000V CITY MANAGER ELLIS SHAPIRO MEMORANDUM TO: The Honorable Mayor and Board of City Commissioners FROM: Wanda B. Horton, Finance Director DATE: ' August 8, 2000 , RE: Quarterly Financial Review, Third Quarter FY00 Finance has completed its evaluation and analysis of the FY00 third quarter revenues and expenditures. The report will be on the August 15, 2000 consent agenda. Should you have any questions or want additional information, please give Donald Carter or me a call. ' POVVIT Protect Ilcaeµ s Water Itesa:rcas : : CITY . . , . . . OF OCOEE , • . . . . .. . . .. ,.... ..„ _ . . . , ., , . .. . . , ., , . . , . . . ,. QUARTFJRLY REPORT THIRD QUARTER ,„,,,,,„,:7,,,, . FISCAL YEAR 1999-2000 Yn • „`5 :,„,„,,,..„,„,„,:,:: r�++Jt°. ..,,...,. v.� UftiY?S` • < " ,,/ it f a"s'w 2 ) a `J s .14 sn'F « may', <':�.''.. i:'' �."?+ y.S r` 414,1p 5„t„,.,,,..„ ....,r, i,„,.r,„,:,,, ,,..,, k,1.4.„,,,:„:, a� _ '�zs• _ it c r< AM ffY• rY: b c3., /bgZ F�,.OS '. J y ��f�µ Hta„„‘„ �i,, a:� i r/ r>rPft .y^.a,:xK,K.i, :an'.. :v=r;}`:, .. :. "`k?b. Cy sib: NIP O ' . I. $%6 Prepared by the 4 ti S. r - fs sus Finance � ;� fy/i/' Iv ,�'``�'2P. fW.�<���,/�y a,;`.:�'3;' s,3� �i�ni3" >;,::� 'T�p i�rvm-p}�TA S )Oyi Oy t'/. ;,:.Y+vjv £fftk K/`�a J r L V a tment O z • AUGUST 2000 TABLE OF CONTENTS Quarterly Overview General Fund 1-2 Revenue Comparison Graph 3 • Revenue Analysis Report 4 Revenue Graphs 5-7 Residential Building Permit Graph 8 Commercial Building Permit Graph 9 Expenditure Comparison Graphs 10 Expenditures Analysis Report 11 Capital Purchase Report 12 Budget Transfers 13-14 Stormwater Fund 15 Revenue Analysis Report 16 Revenue Graph 17 Expenditure Comparison Graphs 18 Expenditure Analysis Report .19 Capital Purchase Report 20 Water/Waste Water Fund 21 Revenue Analysis Report 22 Revenue Graph 23 Expenditure Comparison Graphs 24 Expenditure Analysis Report .25 Budget Transfers 26 Solid Waste Fund 27 Revenue Analysis Report 28 Revenue Graph 29 Expenditure Comparison Graphs 30 Expenditure Analysis Report .31 Supplemental Information 32 General Capital Projects 33 Transportation Projects 34 Stormwater Capital Improvements 35 Water/Wastewater Capital Improvements 36 Debt Statement 37 Investments 38-40 Road Impact Fee Status Report 41 Fire Impact Fee Status Report 42 Police Impact Fee Status Report 43 Recreational Impact Fee Status Report 44 MAYOR•COMMISSIONER Ocoee "CENTER OF GOOD LIVING_PRIDE OF WEST ORANGE" S.SCOTT VANDERGRIFT Ptii `�° CITY OF OCOEE DANNYHOWELL D SCOTT ANDERSON 1 SO N.LAKESHORE DRIVE OCOEE,FLORIDA 34761-2258 COMMISSIONERS RUSTY JOHNSON (414- � `''`` ?� (407)656-2322 NANCY J.PARKER O �`, F GOOD CITY MANAGER ELLIS SHAPIRO Quarterly Financial Report Fiscal Year 1999/2000 Third Quarter The City of Ocoee is a municipal corporation of the State of Florida operating under a commission/manager form of government. A residential community, the City has a land area of approximately 20 square miles. Ocoee is home to approximately 22,746 residents ranking third in population of the cities in Orange County. Ocoee has ten parks and an 18-hole public golf course. Recreational facilities include a multi-purpose recreational complex, tennis courts, outdoor basketball courts, baseball fields and a football field. The City provides water and wastewater services, garbage collection, and police and fire protection to its residents. In 1987 Ocoee began a phenomenal growth pattern which continues today. To meet the increasing demands of travel within Ocoee city limits, the City built Clarke Road which begins at the East-West Expressway and State Road 50 and runs north to the City's current limits. Plans are underway for future expansion to lengthen the road to the city limits of Apopka. The City recently secured funding for design, construction and improvements to Maguire Road, Professional Parkway and other roadways. Ad Valorem taxes are levied at the rate of 4 mils which has remained unchanged for more than ten years. The city currently employs 292 individuals. The Quarterly Financial Report presents the results of financial activity of the City for the preceding three months. This third quarter report summarizes the activity for the months of April, May and June, 2000. Revenues and receipts are presented for the General, StormWater, Water/Wastewater, and Solid Waste funds. Actual receipts (revenues) and expenditures are compared to the adopted budget to assess potential overages/shortages in budgeted line items. Comparisons with figures for last fiscal year are included to indicate the differences by year in the adopted versus actual, since budgeting techniques remained relatively uniform from one fiscal year to the next. The Capital Projects Report, Debt Statement, Impact Fee Reports, and Investment Schedule are included as part of the Quarterly Financial Report. POW i ,,,,P,C#(1..„S';1'?tcr'Presourer.;:> . MAYOR•COMMISSIONER Ocoee "CENTER OF GOOD LIVING-PRIDE OF WEST ORANGE" S.SCOTT VANDERGRIFT prip COMMISSIONERS r:1 CITY OF OCOEE DANNYHOWELL 4 1 SO N.LAKESHORE DRIVE COMMISSIONERS ANDERSON v o RUSTY JOHNSON r,� OCOEE,FLORIDA 34761-2258NANCY 1.PARKER I. e_3_.).P (407)656-2322 F4 OF GOOV CITY MANAGER — ELLIS SHAPIRO Revenues are compared to expenditures in order to determine how daily operations may be affected by shifts in income-producing sources. This difference is important in cash flow management to ensure revenues are available for budgeted expenditures. Table 1 shows revenues currently exceed expenditures in all funds. It is important to note that the budgeted cash carryforward for the funds has been posted to the revenue accounts. TABLE 1 :; Revenue-vs Expenditures by Fund Fund ,. Revenues : :Expenditures General Fund $13,138,062 $11,362,980 StormWater Utility $788,080 $673,434 Water/Wastewater Utility $4,105,863 $3,555,221 Solid Waste Utility $1,229,492 $1,012,504 Expenditures are grouped into four categories: Personal Services, Operating Expenses, Capital Outlay, and Transfers Out. Funds are earmarked for expenditures either through the budget process, the capital improvements element of the Comprehensive Plan, bond indebtedness, impact fee restrictions, water deposit repayments, or loan restrictions. Pow ii Plcteci llCOWS W ter Resunlc;:s MAYOR•COMMISSIONER "CENTER OF GOOD LIVING-PRIDE OF WEST ORANGE" Ocoee S.SCOTT VANDERGRIFT COMMISSIONERS T O CITY OF OCOEE DANNY HOWELL Q 150 N. LAKESHORE DRIVE SCOTT ANDERSON v p OCOEE,FLORIDA 34761-2258 RUSTY JOHNSON 41.4 `J��� (407)656-2322 NANCY J.PARKER Op GOOD CITY MANAGER ELLIS SHAPIRO • General Fund • The General Fund is the principal operating fund of the City. The General Fund budget for FY99-00 is $16,635,965. All general tax revenues and other receipts that are not allocated by law or contractual agreement to another fund are reported in this fund with the related expenditures. General Fund accounts for the activity of sixteen departments. • Revenue Analysis • The graph on page 3 provides a comparison of revenue receipts in dollars for third quarter fiscal years 1998/1999 and 1999/2000. Revenue receipts in dollars are higher for the current year due to the increased budget from last year. Current year revenue receipts are detailed on page 4 and charted on pages 5-7. Overall, General Fund revenue receipts at the end of this quarter are as anticipated with 78.9% realized compared to 80.1% at the end of third quarter last year. Receipts for Property Taxes are $3,310,793 (96.33%) collected compared with $3,098,273 (97.3%) last year. Franchise Tax receipts consisting of revenues from electric, telephone, gas, and cable are below anticipated at 62.8% realized. Revenue for Utility Taxes ($1,356,746) overall is below anticipated with 67.63% of budgeted realized. Licenses and Permits are significantly above anticipated primarily due to the receipt of Occupational Licenses, Electrical Permits, Plan Review Fees, and Right of Way Utilization Permits. Building Permit revenue is below anticipated with 65 residential and 0 commercial building permits issued for third quarter FY2000 compared with 95 Residential and 0 Commercial for FY1999. Three years of building permit activity are graphed on pages 8-9. intergovernmental Revenues are funds received from other governmental agencies. Receipts for third quarter FY2000 are below anticipated with 72.9% realized. Operating Revenue for Windermere Fire protection is due in two installments- February and May, with the capital charge due in October and March. Installments are current. The City entered into an interlocal agreement on May 19, 1998 with Orange County to provide fire protection to the County of a specified contract area. The agreement commenced on June 1, 1998 and ends on September 30, 2000. For the period June 1, 1998 through September 30, 1998 the City received base compensation of$100,000 from the County. Base compensation for fiscal years 1999 and 2000 is $300,000 annually. The annual payments are to be made in ten monthly installments beginning on December 1st of each PowT > Reso tf.m; MAYOR•COMMISSIONER 10.-coe9 "CENTER OF GOOD L/V/NG-PR/DE OF WEST ORANGE" S.SCOTT VANDERGRIFT .% ' qrs,44 �'��� � f�Y CITY OF OCOEE COMMISSIONERS DANNYHOWELL t"� a 150 N.LAKESHORE DRIVE • SCOTT ANDERSON RUSTY JOHNSON (,� ?V OCOEE, 07)656IDA 2322 34761-2258 NANCY J.PARKER �� OF GOO�` CITY MANAGER — ELLIS SHAPIRO fiscal year. Installments have been received when due for this fiscal year. The COPS FAST Grant is a quarterly reimbursement grant. The third quarter reimbursement request of$67,677 has not been received yet. Revenues for Cigarette Tax ( $69,671) and State Revenue-Cigarette Tax ($235,138) are just below anticipated. County Six Cent Gas Tax (Local Option Gas Tax), State Revenue- Gas Tax, and Half-Cent Sales Tax have been received as anticipated. Other Governmental Revenue consists of the Local Law Enforcement Block Grant (LLEBG) and a $50,000 Byrne Grant for computers in the police department. This revenue is 89% realized. The required 25% match for the Byrne Grant is reflected in the department expenditures. Charges for Services consisting of zoning, annexation, development review, program activity and sale of maps and publication fees are 76.18% realized. Fines and Forfeitures at 91% collected ($140,000) and False Alarm Fees at 113%collected ($6000) are above anticipated. Miscellaneous Revenue consisting of returned check charges, special street lighting fees, and administrative fees for police security is 172% realized. The re- budget revenue is designated for a) a laptop computer in the Fire department, b) an above ground lift in the Fleet Maintenance department, and c) netting at Sorenson Field in the Recreation Department. Interest earnings are 128% realized with $138,365 received. Transfers in are slightly above anticipated with 79% realized. . Expenditure Analysis Page 10 contains pie charts indicating the composition of expenditures for third quarter 1998/1999 and 1999/2000 for the General Fund. The Budget versus Expenditure report (page I l) shows for each department, the amount spent and percentage of the budget the amount represents for the quarter. The variation in the percentages represents the timing and types of expenditures for the departments, i.e.- dues, contracts and capital items. Overall, expenditures for General Fund are 69% of budgeted. Capital Outlay expenditures for General Fund are detailed on page 12. Blanket purchase orders continue to be utilized to help expedite receipt of goods and services necessary for the day to day operations of the City. Budget transfers authorized by the City Commission from contingency appear on page 13-14 for the quarter. POW 2 • • CITY OF OCOEE THIRD QUARTER REVENUE COMPARISON $4,000,000 $3,500,000 $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 — o I I I-1 I-1 PROPERTY TAX FRANCHISE TAX UTILITY TAX LICENSE& INTER- CHARGES FOR FINES 8 MISCELLANEOUS TRANSFERS IN PERMITS GOVERNMENTAL SERVICES FORFEITURES REVENUE REVENUE ❑Fiscal Year 98-99 ■Fiscal Year 99-00 • CITY OF OCOEE REVENUE ANALYSIS REPORT GENERAL FUND THIRD QUARTER 1999-2000 REVENUE 3a RECEIVED ' :=z PERCENTAGE c> � BUDGET=�==��'- -. DESCRIPTION-_' AMOUNT': THIRD QUARTER REALIZED= ;'`A BEGINNING CASH BALANCE $530,000 $530,000 100.00% PROPERTY TAXES 3,437,020 3,310,793 96.33% FRANCHISE TAXES 1,431,560 899,622 62.84% UTILITY TAXES 2,006,000 1,356,746 67.63% LICENSES AND PERMITS 1,085,100 821,537 75.71% INTERGOVERNMENTAL REVENUE 5,322,375 3,883,915 72.97% CHARGES FOR SERVICE 150,550 114,687 76.18% FINES AND FORFEITURES 155,500 141,377 90.92% MISCELLANEOUS REVENUE 212,400 268,800 126.55% TRANSFERS IN 2,305,460 1,810,585 78.53% GENERAL FUND TOTALS $16,635,965 $13,138,062 78.97% 4 • Property Taxes Franchise Taxes Third Quarter Third Quarter o 3.7/0 37.2% 96.3% 62.8% Franchise Fees are being received slightly 96.3% of Property Tax Revenue has below anticipated with 62.8% realized. Last been received compared to 97.3% for year's third quarter receipts were 68.4% of third quarter last year. the budgeted amount. Utility Taxes Licenses and Permits Third Quarter Third Quarter 32.4% 24.3% 67.6% Utility Taxes are being received slightly below anticipated with 67.6% realized. 75.7% of the revenue from licenses This is slightly down from the 69.0% and permits has been°received. This received last year at this time. is down from the 94.4/o realized last year in the third quarter. 5 Intergovernmental Revenue Charges for Services Third Quarter Third Quarter 27.0% 23.8% • 73.0/0 76.2/0 73% of Intergovernmental Revenue has Charges for Services are being been received. This is up slightly from realized slightly above anticipated the 72.3% received for the third quarter with 76.2% received compared with last vaar This is helnw antirinafPri Fines and Forfeitures Miscellaneous Revenue Third Quarter Third Quarter 9.1% 0.0% way, i 90.9% ~fig'' 100.0% Fines and Forfeitures are above anticipated with 90.9% received. This Over 100% of Miscellaneous is down from 100% collected in third Revenues have been received. 6 Fund Transfers Third Quarter 21.5% 78.5% Fund Transfers are made on a monthly basis and are as expected. 7 CITY OF OCOEE . RESIDENTIAL BUILDING PERMIT ACTIVITY 50 - ...._... . 45 • 40 = - ir eh ..: .. 35 • 30 . a i • 25 : M 4 • \ 4: . :' E y • ,�4 • ` a M •� ?i . 1' s 15 . \ • \ ! • • r K 5• a '. w i 0 • 1 I I I a ,t I i sa i I r I I { o U d N N .a 2 ' • Q N Z Q LL d N • ®Fiscal Year 97-98 ®Fiscal Year 98-99 0 Fiscal Year 99-00 8 CITY OF OCOEE COMMERCIAL BUILDING PERMIT ACTIVITY 5 • • 4.5 •• 3.5 • • • 2.5 2 1.5 • • • 0.5 • • • • • �e n 0 `x i - • - I I i i . October November December January February March April May June July August September Fiscal Year 97-98 IN Fiscal Year 98-99 0 Fiscal Year 99-00 9 CITY OF OCOEE THIRD QUARTER EXPENDITURE COMPARISON GENERAL FUND FY 98/99-FY99-00 Fiscal Year 98-99 Fiscal Year 99-00 Third Quarter Expenditures Third Quarter Expenditures Capital Outlay Transfers Out Capital Outlay 13 Oransfers Out p Y o 11 2/o 6.0% ° 1 % �• �' = sys y & ff56`Y •a� rt ry r x K> 4� c r 4`� w .r� v # z y trrx r ° ? }SJ e a7gss r ^ ` 19.2/o t 3'ss s c �' rs5`' ��a rL r.T » r ctz f C. % 3 n a "'•"a Operating y Operating 7 Expenses c' Expenses 16.0% 65.0% 68.6% Personal Services Personal Services 10 CITY OF OCOEE EXPENDITURE ANALYSIS REPORT GENERAL FUND THIRD QUARTER 1999/2000 '-' ,_ B:UDGET IEXPEN$ED AS OF:" PERCENT '. �a ,Ye DEPARTMENT AMOUNT`: SI THIRD:QUARTER USE® -` :.¢ 511-00 Legislative $185,889 $112,539 61% 512-00 City Manager 212,315 154,252 73% 512-01 Community Relations 159,071 131,893 83% 512-02 Information Systems 236,470 152,770 65% 512-10 City Clerk 294,790 180,157 61 513-00 Finance Administration 458,631 314,084 68% 513-30 Human Resources 325,050 242,497 75% 514-00 Legal 285,000 136,505 48% 515-00 Planning 439,083 318,683 73% 516-00 General Government Services 2,190,682 1,446,167 66% 517-00 Public Works Administration 188,855 135,696 72% 519-00 Building Maintenance 311,975 217,742 70% 521-00 Law Enforcement 4,124,670 2,891,844 70% 522-00 Fire Control 3,067,845 2,255,596 74% 524-00 Protective Inspections 808,044 598,478 74% 529-00 Communications 507,330 346,693 68% 539-00 Cemetery 8,630 4,215 49% 541-10 Public Works-Traffic Operations 212,265 125,987 59% 541-20 Public Works-Street Maintenance 975,880 551,310 56% 541-30 Public Works-Park Maintenance 746,205 492,335 66% 541-40 Public Works-Fleet Maintenance 125,085 77,749 62% 546-00 Engineering 57,980 16,479 28% 572-00 Recreation 714,220 459,309 64% TOTAL GENERAL FUND $16,635,965 $11,362,980 68% 11 CITY OF OCOEE CAPITAL PURCHASES GENERAL FUND THIRD QUARTER 1999/2000 . BUDGETED..:.:.. AGTUAL ,.:�,`§' E -NC�. DEPARTMENT . , .ITEM PURCHASED'` AMOUNT- . :' ' ;COST=` ., ?DIFFERE CITY CLERK LAPTOP COMPUTER $3,100.00 $3,100.00 $0.00 FIRE CONTROL MOBILE RADIO $2,700.00 $2,304.90 $395.10 FIRE CONTROL (2) MSA AIR PACKS $5,200.00 $4,704.68 $495.32 FIRE CONTROL SOFTWARE FIRE CODES $2,000.00 $2,034.83 ($34.83) PW-PARK MAINTENANCE IRRIGATION WELL-PARKSIDE $6,000.00 $5,170.50 $829.50 PW-PARK MAINTENANCE. FENCE @ TIGER MINOR $3,000.00 $1,617.50 $1,382.50 PW-PARK MAINTENANCE TOP DRESSER $7,000.00 $9,450.00 ($2,450.00) PW-PARK MAINTENANCE AERATOR $8,000.00 $4,950.00 $3,050.00 12 CITY OF OCOEE GENERAL FUND BUDGET TRANSFERS FISCAL YEAR 1999-2000 THIRD QUARTER :DEPARTMENTAL ACCOUNT NUMBER • AGCOUNT.NUMBER; AMOUNTOF -BUDGET TRANSFER TRANSFERRED FROM .. TRANSFERRED TO TRANSFER ' LEGISLATIVE 001-516-00-4900 001-511-00-8200 $2,000.00 HISTORICAL TRIBUTE- CONTINGENCY COMMUNITY PROMOTIONS OCOEE HIGH SCHOOL LEGISLATIVE • 001-516-00-4900 001-511-00-8200 $2,000.00 DONATION TO ODYSSEY OF THE CONTINGENCY COMMUNITY PROMOTIONS MIND PROGRAM LEGISLATIVE 001-516-00-4900 001-511-00-8200 $1,000.00 SHIRTS FOR CITRUS CONTINGENCY COMMUNITY PROMOTIONS ELEMENTARY SCHOOL LEGISLATIVE 001-516-00-4900 001-511-00-8200 $1,500.00 OCOEE HIGH SCHOOL REUNION CONTINGENCY COMMUNITY PROMOTIONS LEGISLATIVE 001-516-00-4900 001-511-00-3128 $750.00 AD FOR OPENING OF WESTERN CONTINGENCY PROFESSIONAL SERVICES OTHER BELTWAY LEGISLATIVE 001-516-00-4900 001-511-00-5402 $6,644.08 WEST ORANGE AIRPORT CONTINGENCY PROFESSIONAL DUES AUTHORITY GENERAL GOVERNMENT 001-524-00-5290 001-516-00-4900 $3,255.84 RETURN UNUSED MOUSE TRAPS ANIMAL CONTROL EXPENSE CONTINGENCY FACILITIES MAINTENANCE 001-516-00-4900 001-519-00-6302 $4,550.00 A/C REPAIRS @ POLICE STATION CONTINGENCY CAPITAL IMPROVEMENTS PROTECTIVE INSPECTION 001-516-00-4900 001-524-00-5405 $300.00 CODE ENFORCEMENT BOARD CONTINGENCY TRAINING EXPENSE MEMBER, DENISE LENKO TO ATTEND FACE CONFERENCE PUBLIC WORKS- PARKS 001-516-00-4900 001-541-30-5304 $5,000.00 BEACH SAND FOR STARKE LAKE CONTINGENCY LANDSCAPE/TREE MAINT. 13 CITY OF OCOEE GENERAL FUND BUDGET TRANSFERS FISCAL YEAR 1999-2000 THIRD QUARTER DEPARTMENTAL . ACCOUNT NUMBER' ACC.OUNT.NUMBER r; ,AMO.UNT,.OF . BUDGET TRANSFER 'TRANSFERRED FROM., TRANSFERRED TO TRANSFER'' _ EXPLANATION .x:a PUBLIC WORKS-PARKS 001-516-00-4900 001-541-30-5304 $1,700.00 TREE REMOVAL @ CONTINGENCY LANDSCAPE/TREE MAINT. 126 N BLUFORD AVE. PUBLIC WORKS- PARKS 001-516-00-4900 001-541-30-5304 $1,700.00 TREE REMOVAL @ CONTINGENCY LANDSCAPE/TREE MAINT. 20 E MCKEY ST. • 14 MAYOR•COMMISSIONER Ocoee "CENTER OF GOOD LIVING-PRIDE OF WEST ORANGE" S.SCOTT VANDERGRIFT 0 pci COMMISSIONERS CITY OF OCOEE DANNYHOWELL 150 N.LAKESHORE DRIVE SCOTT ANDERSON D RUSTY JOHNSON �, v OCOEE, 34761-2258 �y� ,�� (407)656-2322 NANCY J.PARKER ��Op GOO CITY MANAGER ELLIS SHAPIRO StormWater Utility Fund The Stormwater fund accounts for the stormwater utility fee revenues and the related expenditures for drainage, stormwater, and other related projects. Monthly fees are assessed at $5.00 per Equivalent Residential Unit (ERU). The Stormwater fund is divided into two divisions- Utility Engineering and Utility Operations. The Utility Engineering division primarily accounts for expenditures related to the studies and compliance requirements of the City's StormWater system. The Utility Operating division maintains over fifty retention ponds This division is responsible for vegetation control in and around the ponds, swales and wet areas. This division repairs the pipes, inlets and fencing that surrounds these areas. Currently there are 4'/2 employees in this fund. As of June 30, 2000 there were 8296 Stormwater accounts compared to 7847 accounts at June 30, 1999 representing a 6% increase in customer base. The Stormwater fund budget for fiscal year 1999-2000 is $1,017,800. Revenue Analysis Current year revenue receipts are detailed on page 16 and charted on pages 17. Stormwater Fund revenues are 77.4% realized overall compared to 76.8%for third quarter last year. Charges for Services ($781,453) are 77.2% realized compared with 74.5% for third quarter last year. Interest Earnings are above anticipated with 107% realized. Expenditure Analysis Page 18 contains pie charts indicating the composition of expenditures for third quarter 1998/1999 and 1999/2000 for the Stormwater Fund. The Budget versus Expenditure report (page 19) shows the amount spent and percentage of the budget the amount represents for the quarter. Expenditures for the Stormwater Fund are 66% overall. Capital Outlay expenditures are detailed on page 20. Transfers are made monthly for the debt service on the 1999 Capital Improvement Bond Issue. The annual debt service for this fiscal year is $210,490. Funds are also transferred to the Utility Inspections division to cover the cost of the Drainage Inspector. POW 15 Protect 2e's Vf'Ite:Resm.ITns CITY OF OCOEE REVENUE ANALYSIS STORMWATER UTILITY FUND THIRD QUARTER 1999-2000 REVENUE :BUDGET RECEIVED ":`, :` PERCENTAGE DESCRIPTION : " AMOUNT THIRD QUARTER` .,REALIZD CHARGES FOR SERVICES $1,012,800 $781,453 77.16% MISCELLANEOUS REVENUE 5,000 6,627 132.54% STORMWATER UTILITY FUND TOTALS $1,017,800 $788,080 77.43% 16 Stormwater Fund Revenues Third Quarter 22.6% • 77.4% Stormwater Fund Revenues are currently being received slightly above anticipated, with77.4% realized. 17 CITY OF OCOEE THIRD QUARTER EXPENDITURE COMPARISON STORMWATER UTILITY FUND FY98/99-FY99/00 Fiscal Year 98-99 Fiscal Year 99-00 Third Quarter Expenditures Third Quarter Expenditures Personal Services Personal Services Transfers Out 21.4% Transfers Out 24% 43.2% ,. a� any , r4, ::rsre % .. ',f a 3 -4 a`m�• ''�s" r >�` fir" ¢ y ��` S� �•s��i z� `Y ,, rr�&:' '�c � ,�.j� r� din � a *,i ,?�;o`.^� -7.:" yi . :',,"y. x r w .-- a' 51% r .� y,x L j >�rrf �.: aY.. / , „ 24% r �4,; *,-,f, : - r y t 2 Operating Capital Outlay Operating Capital Outlay 1% Expenses Expenses 16.5% 18.9% 18 CITY OF OCOEE EXPENDITURE ANALYSIS REPORT STORMWATER FUND THIRD QUARTER 1999/2000 �'‘'.::,•EXPENSED AS OF DEPARTMENT AMOUNT:: THIRD QUARTER ; :`USED: :: i 538-10 Engineering/Inspections $605,040 $394,099 65% 538-20 Utility Operating 412,760 279,335 68% TOTAL STORMWATER FUND $1,017,800 $673,434 66% 19 CITY OF OCOEE CAPITAL PURCHASES STORMWATER FUND THIRD QUARTER 1999/2000 BUDGETED' • -ACTUAL. ; DEPARTMENT ITEM PURCHASED" . AMOUNT COST DIFFERENCE UTILITY OPERATING CONFINED SPACE SYSTEM $4,000.00 $3,985.00 $15.00 20 MAYOR•COMMISSIONER Ocoee "CENTER OF GOOD LIVING-PRIDE OF WEST ORANGE" S.SCOTT VANDERGRIFT O a COMMISSIONERS w tar carat _ CITY OF OCOEE DANNY HOWELL a 150 N.07)656 23 DRIVE SCOTT ANIONERS DERSON RUSTY JOHNSON n� OCOEE,FLORIDA 34761-2258NANCY J.PARKER :* y_y-ls' (407)656 2322OF GO CITY MANAGER ELLIS SHAPIRO Water/Wastewater Utility Fund The Water/Wastewater fund is an enterprise fund. Operations of this fund are financed and managed in a manner similar to private business enterprise. This fund accounts for the operations of the City's water system and wastewater collection and treatment plant. All activities necessary to provide these services are reported in this fund. The 1999-2000 budget for this fund is $5,336,320. There were 8754 and 5238 water and wastewater customers at June 30, 2000 respectively compared to 8294 and 4806 customers at June 30, 1999. This represents a 6% increase for Water and a 9% increase for Wastewater customer base. Revenue Analysis Current year revenue receipts are detailed on page 22 and charted on pages 23. Revenue for the Water/Wastewater Fund is 76.9% realized compared to 76.5% for third quarter last year. Water Utility Fees ($1,473,023) are 73% realized while Wastewater Utility Fees ($1,505,506) are 76% realized. Revenue and Maintenance Fees include annual and monthly billings for Water (92% realized) and Wastewater (87% realized). Receipts for Water Connection Fees and Other Water Charges (cut-off/cut-on activity and late fees) are 48% and 75% respectively. The re-budget funds are designated for a) the public relations campaign and water rate study, b) equipment in the Water Utilities division, and c) connection of the community center lift station in the Wastewater Utility division. Interest earnings are 74% realized. Transfers In reflects the funds from the Stormwater fund for expenditures related to inspections and the lease revenue from the General Fund for the site of the recreation facility. Expenditure Analysis Page 24 contains pie charts indicating the composition of expenditures for third quarter 1998/1999 and 1999/2000. The Budget versus Expenditure report (page 25) shows the amount spent and percentage of the budget the amount represents for the quarter. Actual expenditures for the third quarter are 67% overall. The public relations campaign and water rate study are funded in professional services in the Administration division. A portion of the annual debt service payment for the 1997 bond issue is funded in the Water Operating and Wastewater Operating divisions. POW 21 CITY OF OCOEE REVENUE ANALYSIS REPORT WATER/WASTE WATER UTILITY FUND THIRD QUARTER 1999-2000 " REVENUE - BUDGET ; s-RECEIVED°-: PERCENTAGE! DESCRIPTION ,AMOUNT .:` ,: THIRD:QUARTER.: REALIZED BEGINNING CASH BALANCE $475,000 $475,000 100.00% TAXES 193,465 143,246 74.04% CHARGES FOR SERVICES 4,386,000 3,286,366 74.93% MISCELLANEOUS REVENUE 171,815 157,709 91.79% TRANSFERS IN 110,040 43,542 39.57% WATER UTILITY FUND TOTALS $5,336,320 $4,105,863 76.94% 22 Water/Wastewater Fund Revenues Third Quarter 23.1% 3 { nts �:YrY � 76.9% Water and Wastewater revenues are being received as anticipated. Both water fees and waste water fees collections reflect this with 73% and 76% realized. 23 CITY OF OCOEEE THIRD QUARTER EXPENDITURE COMPARISON WATER/WASTEWATER UTILITY FUND FY98/99-FY99/00 Fiscal Year 98-99 Fiscal Year 99-00 Third Quarter Expenditures Third Quarter Expenditures 35.9% Personal Services Transfers Out ° Personal Services 32.3/o Transfers Out 36.9% 39.3% r 4y y a c. ki ; a r v A v cu akGf a s H xa 1}r yy Jy$ pwx s.a Y • ; , yr y - • - S =`3 ryj 0.0% 3.1% 24 1% Capital Outlay Capital Outlay Operating Expenses Operating Expenses 28.3/° 24 CITY OF OCOEE EXPENDITURE ANALYSIS REPORT WATER/WASTEWATER FUND THIRD QUARTER 1999/2000 6UI GET: 'EXPENSED AS`OF.: PERCENT DEPARTMENT AMOUNT THIRD;eQUARTER: v: , USED 531-00 WaterWastewater Administration $874,510 $486,916 56% 533-00 Water Operating 2,460,285 1,724,919 70% 535-00 Wastewater Operating 1,757,900 1,213,162 69% 537-00 Utility Inspections 243,625 130,224 53% TOTAL WATER/WASTEWATER FUND $5,336,320 $3,555,221 67% • 25 CITY OF OCOEE WATER/WASTEWATER UTILITY FUND BUDGET TRANSFERS FISCAL YEAR 1999-2000 THIRD QUARTER DEPARTMENTAL ACCOUNT NUMBER ACCOUNT NUMBER - AMOUNT OF I• BUDGET TRANSFER TRANSFERRED FROM TRANSFERRED TO : TRANSFER EXPLANATION'. WATER/WASTE WATER 401-531-00-4900 401-531-00-3128 $14,020.00 WATER USAGE ANALYSIS ADMINISTRATION CONTINGENCY PROFESSIONAL SERVICES OTHER 26 MAYOR•COMMISSIONER Ocoee "CENTER OF GOOD LIVING-PRIDE OF WEST ORANGE" S.SCOTT VANDERGRIFT O� /pp COMMISSIONERS ci CITY OF OCOEE COMMISSIONERS a Icb 150 N.LAKESHORE DRIVE SCOTT ANDERSON RUSTY JOHNSON r, OCOEE,FLORIDA 34761-2258 NANCY J.PARKER 'may �� (407)656-2322 l�4 OF GOO �`� CITY MANAGER ELLIS SHAPIRO Solid Waste Fund The Solid Waste fund is an enterprise fund. Operations of this fund are financed and managed in a manner similar to private business enterprise. This fund accounts for the collection of commercial and residential garbage which is disposed of at a landfill. All activities necessary to provide such service are accounted for in this fund. The city contracts out the collection of commercial and yard waste refuse. There were 7908 solid waste residential accounts at June 30, 2000 compared with 7669 accounts at June 30,1999 representing a 4% increase. The budget for fiscal year 1999-2000 is $1,598,000. Revenue Analysis Current year revenue receipts are detailed on page 28 and charted on pages 29. Solid Waste Fund revenues are 76.9% realized compared with 76.6% for third quarter last year. Solid Waste Fees ($1,065,954) are 74% realized which is slightly below anticipated. Franchise Fee revenue ($138,678) is 116% realized. This is due to the receipt of franchise fees outstanding from last year. Interest earnings exceed expected with $20,990 realized. Expenditure Analysis Page 30 contains pie charts indicating the composition of expenditures for third quarter 1998/1999 and 1999/2000. The Budget versus Expenditure report(page 31) shows the amount spent and percentage of the budget the amount represents for the quarter. Expenditures for the third quarter are 63% of budgeted. Principal and interest payments for garbage trucks, a pick up truck, and a recycle truck are budgeted in this fund. POWT% 27 Prefect tlenee's Water Reswif :t,. CITY OF OCOEE REVENUE ANALYSIS REPORT SOLID WASTE UTILITY FUND THIRD QUARTER 1999-2000 REVENUE, BUDGETa" ;:: RECEIVED_.: : PERCENTAGE' DESCRIPTION _ AMOUNT ': THIRD QUARTER. REALIZED FRANCHISE FEES $120,000 $138,678 115.57% INTER GOVERNMENT SERVICES 5,000 1,737 34.74% CHARGES FOR SERVICES 1,450,000 1,066,024 73.52% MISCELLANEOUS REVENUE 18,000 23,053 - 128.07% TRANSFERS IN 5,000 0 0.00% SOLID WASTE FUND TOTALS $1,598,000 $1,229,492 76.94% 28 Solid Waste Fund Revenues Third Quarter 23.1% 76.9% Solid Waste revenues are being received as anticipated. 73.5% of solid waste fees have been collected compared to 75% for third quarter last year. 29 CITY OF OCOEE THIRD QUARTER EXPENDITURE COMPARISON SOLID WASTE UTILITY FUND FY98/99-FY99/00 Fiscal Year 98-99 Fiscal Year 99-00 Third Quarter Expenditures Third Quarter Expenditures Transfers Out 33Ser Transfers Out 34.6% Personal Services 14.8% 14.2% Personal Services Capital � � r s! e %£ F � almommo..__' �, }' Eea Capital Outlay x s` fY z Outlay v x r T k • � 4 y;• 0.0% 11.6% % • , .r: Operating Expenses5 1 ° Operating Expenses 39.8/o 30 CITY OF OCOEE EXPENDITURE ANALYSIS REPORT SOLID WASTE FUND THIRD QUARTER 1999/2000 BUDGET." EXPENSED AS.OF. PERCENT ;,; DEPARTMENT AMOUNT THIRD QUARTER, °= • .USED 534-10 Solid Waste-Residential $1,108,620 $709,867 64% 534-20 Solid Waste-Recycling 296,380 194,013 65% 534-30 Solid Waste-Yard Waste 193,000 108,624 56% TOTAL SOLID WASTE UTILITY FUND $1,598,000 $1,012,504 63% 31 MAYOR•COMMISSIONER Ocoee "CENTER OF GOOD LIVING-PRIDE OF WEST ORANGE" S.SCOTT VANDERGRIFT O� 17:1)1 COMMISSIONERS �, , CITY OF OCOEE DANNYHOWELL w150 N.LAKESHORE DRIVE SCOTT ANDERSON RUSTYJOHNSON �, OCOEE,FLORIDA 34761-2258 NANCY J.PARKER `yl (407)656-2322 L E,p QfGOO • CITY MANAGER — ELLIS SHAPIRO Supplemental Information Capital projects financed through bond issues are tracked by phase and expenditures; these have been listed on pages 33-36. The Debt Statement (page 37) details outstanding obligations of the City used to finance these projects and the source of security for the debt. Currently, the City has $50,625,000 in outstanding debt. The investment portfolio which contained $26,390,078 at June 30, 2000 is detailed on pages 38-40. Funds invested with Merrill Lynch and Raymond James are primarily in mutual funds. Funds invested with SunTrust consist of government backed notes. All investments are in accordance with the City's adopted investment policy. Funds necessary for operations are taken from the investments in a timely manner. Impact Fee activity is detailed on pages 41-44 for Road, Fire,-Police, and Recreation. Debt Service is currently paid out of road impact fees (Clarke Road and the 1998 Transportation Bond Issue), police impact fees (police building-current/future), fire impact fees (fire stations), and recreation impact fees (recreation facility). POW 32 Park;(:,(knee's -t r R4:Snurin3 • CITY OF OCOEE GENERAL CAPITAL PROJECTS THIRD QUARTER FY 1999-2000 "CUMULATIVE. r • BUDGETED- EXPENSES :,?` ":PERCENT" ACTIVE/- °° START DATED PROJECT NAME FUNDS,; . `AS='UF'6/30/p0 ?: "`_ .USED '. INACTIVE; CQMPLETION" PUBLIC WORKS FACILITY $2,139,776 $1,617,073 75.6% ACTIVE 98-2000 FIRE STATION#1 $1,000,000 $33,348 3.3% ACTIVE 99-2001 POLICE STATION $1,000,000 $29,436 2.9% ACTIVE 99-2001 BEECH MULTIPURPOSE FACILITY PHASE 2 $1,100,000 $277,540 25.2% ACTIVE 99-2000 PARK LAND-SOUTH $550,000 $478,881 87.1% ACTIVE 99-2000 33 CITY OF OCOEE TRANSPORTATION CAPITAL PROJECTS • THIRD QUARTER FY 1999-2000 - BUDGETED - EXPENSES `., ''.PERCENT: ACTIVE/ = ' - START DATE/. I . . PROJECT NAME ' FUNDS ' AS OF6-30-00 . . `-USED -:': ,:: INACTIVE COMPLETION MAGUIRE ROAD - PHASE 1 $5,071,000 $2,092,720 41.3% ACTIVE 97-2000 MAGUIRE ROAD- PHASE 2 $2,740,727 $395,054 14.4% ACTIVE 98-2000 MAGUIRE ROAD - PHASE 3 $1,438,299 $288,058 20.0% ACTIVE 98-2000 MAINE STREET PROJECT $2,250,000 $30,670 1.4% ACTIVE 98-2000 PROFESSIONAL PKWY PROJECT $4,474,852 $100,005 2.2% ACTIVE 98-2000 WHITE RD/ORLANDO AVE PROJECT $500,000 $376,442 75.3% ACTIVE 98-2000 WURST ROAD PROJECT $600,000 $11,910 2.0% ACTIVE 99-2000 A.D. MIMS ROAD PROJECT $700,000 $19,559 2.8% ACTIVE 99-2000 MAGUIRE ROAD - PHASE 4 $1,411,602 $160,061 11.3% ACTIVE 99-2000 MAGUIRE ROAD - PHASE 5 $33,888 $37,506 110.7% ACTIVE 99-2000 34 CITY OF OCOEE STORMWATER CAPITAL PROJECTS THIRD QUARTER FY 1999-2000 . .:: .-' BUDGETED. EXPENSES ,`... PERCENT C . ACTIVE/; :,START DATE/,I j PROJECT,NAME FUNDS ` AS OF 6-30-00: ' USED' INACTIVE COMPLETION 1 PIONEER KEY II $150,000 $32,773 21.8% ACTIVE 2000-2002 STARKE LAKE DRAIN WELLS $250,000 $0 0.0% ACTIVE 2000-2002 REFLECTIONS SUBDIVISION $70,000 $0 0.0% ACTIVE 2000-2002 PIONEER KEY I $66,566 $14,090 21.2% INACTIVE 97-?? BLUFORD AVE/ORLANDO AVE INTERSECTION $59,139 $18,001 30.4% INACTIVE 97-?? FRANKLIN ST AREA $46,006 $17,825 38.7% INACTIVE 97-?? GROUP 4 PROJECTS $454,395 $65,546 14.4% INACTIVE 97-?? 35 CITY OF OCOEE WATER/WASTEWATER CAPITAL PROJECTS THIRD QUARTER FY 1999-2000 ` CUiMULATIVE ` BUDGETED =: EXPENSES ' - PERCENT ACTIVE/. ' START DATE/ 1 ' PROJECT NAME FUNDS. AS OF6-30-00., USED ' INACTIVE `:COMPLETION WATER DISTRIBUTION SYSTEM (PHASES I, II, III) $4,977,183 $3,220,849 64.7% ACTIVE 97-2000 REUSE WATER PROGRAM $3,857,000 $4,045,305 104.9% ACTIVE 97-2000 EFFLUENT DISPOSAL SYSTEM $432,400 $222,159 51.4% ACTIVE 98-2000 MAINTENANCE FACILITY $500,000 $268,013 53.6% ACTIVE 98-2000 REUSE RETROFIT PROGRAM $1,050,000 $109,895 10.5% INACTIVE 99-2000 MAGUIRE ROAD UTILITY LINE $500,000 $112,768 22.6% ACTIVE 99-2001 MISCELLANEOUS WTP PROJECTS $320,000 $17,760 5.6% ACTIVE 98-2000 36 CITY OF OCOEE DEBT STATEMENT AS OF JUNE 30, 2000 General General Fund Utility Fund Source Obligation Revenue Revenue of Direct City Debt Debt Debt Debt Security Transportation Refunding and Local Option Gas Tax and Improvement Revenue Bonds, Public Service Taxes Series 1990 due 10/1/2015 $1,490,000 Stormwater Utility Bonds, Series 1996 $ 1,905,000 Stormwater Utility Fees Capital Improvement Revenue Bond Covenant to budget and Series 1999, due 10/01/2028 11,255,000 appropriate annually from non-ad valorem revenues and impact fees • Transportation Refunding and Local Option Gas Tax and Improvement Revenue Bonds, Public Service Taxes Series 1998, due 10/01/2017 19,105,000 Water and Sewer System Refunding Net Revenues and Impact and Improvement Bonds, Series Fees 1993 due 10/1/2017 7,175,000 • Water and Sewer System Improvement Net Revenues and Impact Revenue Bonds, Series 1997 Fees due 10/1/2027 9,695,000 Total Direct Debt $ -0- $ 31,850,000 $ 18,775,000 37 CITY OF OCOEE INVESTMENTS AS OF JUNE 30, 2000 INVESTED WITH FUND ACCOUNT rt RATE . MATURITY- `. AMOUNT :.. I. 'NUMBER DATE . ' : I MERRILL LYNCH 001 -GENERAL FUND 762-04471 6.39 - $279,591.47 MERRILL LYNCH 103-STORMWATER UTILITY 762-04471 6.39 - $50,191.96 MERRILL LYNCH 106-ROAD IMPACT 762-04461 6.39 - $301,757.20 MERRILL LYNCH 106-ROAD IMPACT 762-04471 6.39 - $400,095.98 MERRILL LYNCH 106-ROAD IMPACT 762-04462 6.39 - $2,415,043.80 MERRILL LYNCH 107-FIRE IMPACT 762-04462 6.39 - $625,281.11 MERRILL LYNCH 107-FIRE IMPACT 762-04471 6.39 - $453,226.10 MERRILL LYNCH 108-POLICE IMPACT 762-04471 6.39 - $75,420.35 MERRILL LYNCH 110-RECREATION IMPACT 762-04462 6.39 - $305,510.31 MERRILL LYNCH 302-CAPITAL IMPROVEMENTS BOND 762-04471 6.39 - $1,142,336.18 MERRILL LYNCH 312-STORMWATER IMPROVEMENT 762-04471 6.39 - $148,800.31 MERRILL LYNCH 401 -WATER 0&M 762-04462 6.39 - $68,919.13 MERRILL LYNCH 401 -WATER 0&M 762-04471 6.39 - $230,081.96 MERRILL LYNCH 401 -WATER 0&M 762-04A31 6.39 - $182,116.64 MERRILL LYNCH 402-SOLID WASTE UTILITY - 762-04471 6.39 - $48,994.70 MERRILL LYNCH 404-WATER IMPROVEMENT 762-04462 6.39 - $135,416.09 MERRILL LYNCH 405-WASTE WATER CAPITAL FUND 762-04471 6.39 - $301,361.69 MERRILL LYNCH 406-WATER DEBT SERVICE 762-04A30 6.39 - $53,537.54 MERRILL LYNCH 407-WASTEWATER R&R 762-04471 6.39 - $627,866.59 MERRILL LYNCH 410-WATER R&R 762-04471 6.39 - $319,959.75 MERRILL LYNCH 410-WATER R&R 762-04462 6.39 - $349,268.70 TOTAL $8,514,777.56 38 CITY OF OCOEE - INVESTMENTS AS OF JUNE 30, 2000 !INVESTED WITH : FUND. ACCOUNT RATE ::.,MATURITY. AMOUNT ` NUMBER DATE . s! RAYMOND JAMES 001 -GENERAL FUND .10041873 6.00 - $223,774.81 RAYMOND JAMES 401 -WASTEWATER 10041873 6.00 - $55,252.59 RAYMOND JAMES 404-WATER CAPITAL FUND 10041873 6.00 - $70,059.73 RAYMOND JAMES 405-WASTEWATER CAPITAL FUND 10041873 6.00 - $341,569.68 TOTAL $690,656.81 SUNTRUST 001 -GENERAL FUND 4444 5.18 10/27/00 $297,656.40 SUNTRUST 001 -GENERAL FUND 4444 4.94 09/18/00 $295,013.79 SUNTRUST 001 -GENERAL FUND 4444 6.07 10/26/00 $374,145.14 SUNTRUST 001 -GENERAL FUND 4444 5.61 07/06/00 $294,049.00 SUNTRUST 106-ROAD IMPACT 4444 5.19 02/23/01 $587,245.00 SUNTRUST 106-ROAD IMPACT 4444 5.18 10/27/00 $446,484.60 SUNTRUST 106-ROAD IMPACT 4444 6.01 09/15/00 $350,000.00 SUNTRUST 204-STORMWATER DEBT SERVICE 4522 5.32 10/19/01 $207,822.45 SUNTRUST 301 -TRANSPORTATION BOND 4494 4.94 09/18/00 $1,987,582.64 SUNTRUST 301 -TRANSPORTATION BOND 4494 5.85 07/13/00 $1,458,700.00 SUNTRUST 301 -TRANSPORTATION BOND 4494 6.45 11/30/00 $1,937,816.67 SUNTRUST 301 -TRANSPORTATION BOND 4494 5.22 10/13/00 $1,489,687.50 SUNTRUST 301 -TRANSPORTATION BOND 4494 6.16 11/06/00 $966,353.33 SUNTRUST 302-CAPITAL IMPROVEMENTS BOND 4444 5.12 11/24/00 $1,289,844.40 SUNTRUST 312-STORMWATER IMPROVEMENTS 4444 4.94 09/18/00 $24,584.48 SUNTRUST 315-CAPITAL PROJECTS 4444 5.27 01/12/01 $396,472.40 SUNTRUST 401 -WATER O&M 4444 4.94 09/18/00 $98,337.93 SUNTRUST 404-WATER CAPITAL 4444 4.94 09/18/00 $73,753.45 SUNTRUST 405-WATER/WASTEWATER CAPITAL 4444 5.19 02/23/01 $200,909.00 _ SUNTRUST 405-WATER/WASTEWATER CAPITAL 4444 6.01 09/15/00 $150,000.00 39 CITY OF OCOEE INVESTMENTS AS OF JUNE 30, 2000 !INVESTED WITH • FUND ACCOUNT RATE MATURITY AMOUNT ;::' NUMBER DATE SUNTRUST . 405-WATER/WASTEWATER CAPITAL 4444 4.94 09/18/00 $73,753.45 SUNTRUST 407-WASTEWATER R&R 4444 5.19 02/23/01 $200,909.00 SUNTRUST 407-WASTEWATER R&R 4444 6.01 09/15/00 $109,573.26 SUNTRUST 407-WASTEWATER R&R 4444 4.94 09/18/00 $55,676.48 SUNTRUST 412-WATERNVASTEWATER BOND 4494 5.21 11/02/00 $599,454.17 SUNTRUST 412-WATERNVASTEWATER BOND 4624 5.72 08/10/00 $777,876.89 SUNTRUST 412-WATERNVASTEWATER BOND 4624 5.61 07/06/00 $490,081.67 SUNTRUST 412-WATER/WASTEWATER BOND 4624 5.39 08/31/00 $493,389.86 SUNTRUST 412-WATERNVASTEWATER BOND 4624 6.07 10/12/00 $971,322.22 SUNTRUST 412-WATERNVASTEWATER BOND 4624 5.67 09/14/00 $486,148.47 TOTAL • $17,184,643.65 GRAND TOTAL $26,390,078.02 40 CITY OF OCOEE IMPACT FEE STATUS REPORT THIRD QUARTER - FISCAL YEAR 1999-2000 ROAD IMPACT FEES-FUND 106 BALANCE FORWARD $5,543,448 CURRENT QUARTER REVENUE $79,073 CURRENT QUARTER EXPENDITURE ($328,014) ENCUMBERED ($17,600) INTEREST EARNED $99,277 ENDING BALANCE AT 6/30/00 $5,376,184 41 CITY OF OCOEE IMPACT FEE STATUS REPORT THIRD QUARTER-FISCAL YEAR 1999-2000 FIRE IMPACT FEES-FUND 107 DISTRICT 1 DISTRICT 2 DISTRICT 3 DISTRICT 4 RESTRICTED BALANCE FORWARD $382,123 $11,683 $450,756 $708,520 $45,579 CURRENT QUARTER REVENUE RESIDENTIAL $903 $420 $8,634 $23,089 $5,652 NON RESIDENTIAL $33,262 $0 $1,558 $0 $0 TOTAL CURRENT QUARTER REVENUE $34,165 $420 $10,192 $23,089 $5,652 CURRENT QUARTER EXPENDITURE RESIDENTIAL $18 $0 $0 $0 $0 NON RESIDENTIAL $0 $0 $0 $0 $0 TOTAL CURRENT QUARTER EXPENDITURE $18 $0 $0 $0 $0 ENCUMBERED $0 $0 $0 $0 $0 INTEREST EARNED $12,410 $378 $14,364 $22,409 $789 ENDING BALANCE AT 6/30/00 $428,716 $12,481 $475,312 $754,018 $52,020 ** Restricted funds are comprised of Windermere R & R 42 CITY OF OCOEE IMPACT FEE STATUS REPORT THIRD QUARTER - FISCAL YEAR 1999-2000 POLICE IMPACT FEES-FUND 108 BALANCE FORWARD $253,825 CURRENT QUARTER REVENUE RESIDENTIAL $11,599 NON RESIDENTIAL $10,243 TOTAL CURRENT QUARTER REVENUE $21,842 CURRENT QUARTER EXPENDITURE ($23,172) ENCUMBERED $0 INTEREST EARNED $5,466 ENDING BALANCE AT 6/30/00 $257,961 43 CITY OF OCOEE IMPACT FEE STATUS REPORT THIRD QUARTER - FISCAL YEAR 1999-2000 RECREATIONAL IMPACT FEES -FUND 110 COMMUNITY NORTH EAST NORTH WEST SOUTH BALANCE FORWARD $192,761 $135,683 $18,404 $222,971 CURRENT QUARTER REVENUE $5,280 $3,162 - $96 $1,080 CURRENT QUARTER EXPENDITURE ($2,670) $0 $0 $0 ENCUMBERED $0 $0 $0 $0 INTEREST EARNED $6,059 $4,594 $633 $7,601 ENDING BALANCE AT 6/30/00 $201,430 $143,439 $19,133 $231,652 44