Loading...
94-07 v RESOLUTION NO. 94-7 A RESOLUTION OF THE CITY OF ATLANTIC BEACH APPROVING FACILITIES FOR THE ATLANTIC BEACH WASTEWATER TREATMENT PLANT PLAN FOR SUBMITTAL TO THE FLORIDA DEPARTMENT OF ENVIRONMENTAL PROTECTION FOR CONSIDERATION OF A LOAN TO BUILD THE WASTEWATER TREATMENT PLANT; NOW, THEREFORE, be it resolved by the City Commission of the City of Atlantic Beach, as follows: SECTION 1 . The City Commission, as the governing body of Atlantic Beach, approves the Facilities Plan for the Wastewater Treatment Plant. SECTION 2 . Appoints the City Manager to act as its representative with the Department of Environmental Protection for matters concerning the loan process . However, final approval of any contract for the loan must be approved by the Commission. SECTION 3 . The Facilities Plan is found to be consistent with the City' s Comprehensive Plan. SECTION 4 . The attached Capital Financing Plan Worksheets are to be considered as part of the Facilities Plan. SECTION 5. This resolution shall take effect immediately upon its final passage and adoption. ADOPTED by the City Commission of Atlantic Beach, Florida this 22 day of February 1994. L .AFACI D zm. - . ^aters •yor Pr•-tem/Presiding Officer Appr •ved as o form and correctness : /'an C. ;1e'sen, City Attorney ATTEST: Ifq4A 1$_241/ '.--C Maureen King, City Clerk EXHIBIT FPS-06La CAPITAL FINANCING PLAN WORKSHEETS CITY OF ATLANTIC BEACH Local Government Agency (SRF Project Sponsor) ROBERT S . KOSOY, P. E . , PUBLIC WORKS DIRECTOR ANN B. MEUSE. CPA, FINANCE DIRECTOR Authorized Representative and Title Capital Financing Plan Contact, Title, and Telephone Number (9014) 247-5800 1200 SANDPIPER LANE 800 SEMINOLE ROAD ALTERNATE CONTACT: Street Address or Other Mailing Address Street Address or Other Mailing Address THOMAS C . HAWK, P. E . ATLANTIC BEACH, FLORIDA 32233-4381 ATLANTIC BEACH, FLORIDA 32233-5445 PITMAN-HARTENSTEIN b ASSOC. , INC. 101 CENTURY 21 DRIVE SUITE 207 City, State, and Zip Code City, State, and Zip Code JACKSONVILLE, FL 32216 (904) 724-3546 The Department needs to know about the financial capabilities of potential State Revolving Fund (SRF) loan applicants. Therefore, a financial capability demonstration (and certification) is required well before the evaluation of the actual loan application. Chapter 17-503 of the Florida Administrative Code requires the submittal of this information to the Department no later than June 1 preceding the fiscal year during which a loan will be requested. It is expected that the revenues to be dedicated to repaying the loan will be generated either from water and sewer utility operations or from sewer utility operations alone. If the source of revenues will not be from such enterprises, this set of worksheets alone will not satisfy the Department's needs. (Please contact the Department for further guidance if dedicated revenues will be generated externally to such utilities.) This form solicits information for the next five years. Ordinarily, the five-year time frame will cover the period of interest to the Department; but, it will be necessary to provide additional yearly information until the reported data includes at least one full year of SRF project operation and one annual SRF repayment to the Department. Accordingly, attachments may be made to these worksheets. Please use the format established herein when preparing attachments. The worksheets have been developed to identify the minimum information needed. The completed worksheets should be used in disclosing SRF project financing to the public during the required dedicated revenue hearing. The worksheets can serve to identify the impacts of the SRF project on residential users and how the project fits into the local government's overall capital improvement program for the water and sewer utility (or sewer utility, as appropriate). Supplemental capital financing documentation may be submitted with these worksheets and may be presented at the required dedicated revenue hearing. FEB ' 3 1994 A. Household median annual income, average size, number in the utility service area, and population to be served. (Population to be served is determined by the number of households multiplied by the household size. This data is to be consistent with facilities planning projections.) If the data vary by district or zone, report the data according to district or zone on an attachment. Note: Indicate the actual fiscal years for Year 1 - Year 5 wherever they appear in the worksheets. Year 1 Year 2 Year 3 Year 4 Year 5 -'INCLUDES ATLANTIC BEACH WWTP & 1. Fiscal Year 95-96 96-97 97-98 98-99 99-2000 BUCCANEER WWTP SERVICE AREAS. 2. Household income ($/year) 18,000 WATER & WASTEWATER REVENUES FROM 3. Household size (people/household) 2 .5 BOTH SYSTEMS TO BE USED FOR 4. Number of households 10,332 10,4$2 10,642 10,798 10 OPERATING, NON-OPERATING AND ::5. Serviced population (people) 25,805 26,205 26,605 26,995 27,348 DEBT SERVICE. BREAKDOWN OF SYSTEM POPULATION ATTACHED. B. The revenues being dedicated to repayment of the SRF loan are: C. What projects (including the SRF project), are proposed that will be financed from the operation of the utility generating the revenues to be dedicated to repaying the SRF loan? Total annualized cost is the sum of annualized capital costs plus the annual operation, maintenance, and replacement (0/M & R) costs. Construction and related capital costs reported below must be annualized (and is to include the interest expenses associated with debt service) before adding to yearly 0/M & R costs (excludes debt service) to report the total annualized cost required below. Note that water facilities information is to be identified only if the dedicated revenues will be generated from operations of a water and sewer utility. Annualized , ::c Facilities Description Construction Construction and Annual Cost to Total Annualized :'::: SEE ATTACHMENT FOR Start Dates Related Capital Operate, Maintain, costs ($) DETAILS (Month/Year) Costs ($) and Replace ($) 0. Wastewater Treatment Plant 6/94 $348,800 1. Wastewater treatment plant 8/95 .$ 29,59 TOTAL WATER AND 2. Sites and easements - WASTEWATER OM&R FOR 3. Wastewater transmission system 5/93 $ 16,370 ATLANTIC BEACH & BUCCANE! 4. Wastewater collection system 11/93513,480 SYSTEMS . SEE ATTACHED 5. Wastewater reuse system N/A DISCOUNT RATE $%, 6. Stnrage Facility 4/94 S 5,200 ESCALATION RATE 5% 7. Water supply well 6/93 $ 6,750 PERIOD = 20 YEARS 8 Water treatment plant N/A STARTING 1995-1996 9. Sites and easements N/A 1995-1996 O&MR = 10. water distribution system 9/93 $ 43,900 $2,866,657 11. Water storage facilities 8/94 $ 59,200 12. Water Network Analysis 8/94 $ 4,900 Totals($) $573, 190 $4,401 ,690 $4,974,880 • • Identify which of the above wastewater facilities are to be financed with the SRF loan and combine (as appropriate) the associated costs: Description ITEM 0 - WASTEWATER TREATMENT PLANT - ATLANTIC BEACH $348 800 $1 Annualized Construction and Related Capital Costs Annual Costs for 0/M & R 22bdU() /year; Total Annualized Costs $1 ,575,6 0 0 Related Capital Costs ,$5, 188,900 /year, Construction and • -BASIS OF CALCULATION : ATLANTIC BEACH WASTEWATER EXPENSES X 0.75 TO CORRECT FOR WASTEWATER TREATMENT ONLY, ESCALATION @ 5%/YEAR. DISCOUNT RATE @ 8%. PERIOD = 20 YEARS Attachment to Item C — Page 2 — Capital Financing Plan Worksheets Annualized Construction Funding Interest Finance & Construction Item Description Project Cost Source Rate Period Related Costs Start Date 0 Wastewater Treatment Plant Atlantic Beach Wastewater Treatment Plant Expansion — Wet Process $4,326,700 — Engineering Design $376,000 — Inspection Services $80,000 — Engineering Construction Services $200,000 — Administration S36,000 — Loan Origination $170,200 Subtotal: $5,188,900 SRF 3% 20 Years $348,800 6/94 1 Wastewater Treatment Plant Buccaneer Wastewater Treatment Plant Chlorine Facilities $300,000 Barnett Loan 5.35% 15 Years $29,590 8/93 2 Sites and Easements None -- _— -- —— 3 Wastewater Transmission System Wetwell Rehabilitation $166,000 Barnett Loan 5.35% 15 Years $16,370 5/93 4 Wastewater Collection System Oak Harbor $600,000 SRF* 3% 20 Years $40,330 7/94 Sewer Rehabilitation $16,970 (Ahern,9th,17th,18th) $172,000 $1,180 11/93 Sewer Line(Church St) $12,000 6/94 Subtotal: $784,000 Barnett Loan 5.35% 15 Years $58,480 5 Wastewater Reuse None —— __ —— __ 6 Storage Facility P.W.Storage $53,000 Barnett Loan 5.35% 15 Years $5,200 4/94 7 Water Supply Well #3 Well at Assissi Lane Water Treatment Plant $68,400 Barnett Loan 5.35% 15 Years $6,750 6/93 8 Water Treatment Plant None —— —— _— —— 9 Sites and Easements None —— _— —— _— —— —— *Oak I'arbor Sewer Rehabilitation Project is applying fora separate SRF Lean.Oak I-larbor is not included in this application. Attachment to Item C — Page 2 — Capital Financing Plan Worksheets Annualized Construction Funding Interest Finance & Construction Item Description Project Cost Source Rate Period Related Costs Start Date 10 Water Distribution System Encoded Water Meters—Buccaneer $75,000 9/93 Encoded Water Meters—Atl.Bch. $80.000 9/93 Distribution 3rd&8th $130,000 9/93 Distribution Coquina $130,000 9/93 Distribution Church $30,000 1/94 Subtotal: $445,000 Barnett Loan 5.35% 15 Years $43,900 11 Water Storage Facilities No.3 Well Pant $600,000 Barnett Loan 5.35% 15 Years $59,200 8/94 12 Network Analysis Computer Hydraulic Analysis&Mapping $50,000 Barnett Loan 5.35% 15 Years $4,900 8/94 Totals: $7,655,300 $573,190 D. Ide a the SRF loan amount scheduled, or to be scheduled, on the project ority list; the interest rate established for the year preceding the submittal of the CFP, after adjusting downward to reflect the SRF subsidy; annual debt service, and expected pledged revenue coverage. Note that SRF repayments begin one year after construction completion. (It is recognized that the information to be provided arc best estimates only.) Amount $5; 188,900 ; interest rate 3 7.; annual debt service $348,800 ; loan repayment reserve $ pledged revenue coverage factor 120 7.; and annual repayments begin 1995 - 1996 (Date). E. Identify other anticipated debt which will be repaid from operations of the utility providing the dedicated revenues. Description Debt Amount($) Annual Revenue • Interest Coverage Annual Debt Service (S) Rate (%) Rate (V.) Year 1 Year 2 Year 3 Year 4 Year 5 Fiscal Year 1995-1996 1996-1997 1997-1998 1998-1999 1999-2000 1. BARNETT BANK LOAN :; $5,548,580 5. 35 1 .20 $27°T877-- $631 ,952 $631 ,952 $631 ,952 $631 ,952 2. 3. 4. Totals (S) 6,607, 181 $290,872 $631 ,952 $631 ,952 $631 ,952 $631 ,952 * MAXIMUM EXPECTED DEBT AMOUNT FOR ON-GOING CAPITAL IMPROVEMENT PROGRAM NON-_SRF FUNDED • AS PRESENTED IN ITEM C . ALSO INCLUDES REFUNDING OF BUCCANEER SYSTEM F. What is the existing debt for the utility providing the SRF dedicated revenues? Description Current Annual Revenue Debt Amount ($) Interest Coverage Annual Debt Service (S) Rate (7.) Rate (7.) Year 1 Year 2 Year 3 Year 4 Year 5 ,Fiscal Year 1995-1996 1996-1997 1997-1998 1998-1999 1999-2000 1. GULF BREEZE BOND _ 106,594 107,616 105,714 106,491 107, 105 2. LIBERTY NATIONAL 68,447 -0- -0- -=-- -0- 3. 4. 5. 6. Totals ($) 17b,041 107,616 105,714 106,491 107, 105 3 G. Identify the projected cornual expenses (costs) fur the utility pruvidiny SNI dedicated revenues. (SEE ATTACHED EXPENSE PROJECTIONS) 1. Existing facilities • Expense Category Year• 1 Year 2 Year 3 Year 4 Year S Fiscal Year 1995-1996 1996-1997 1997-1998 1998-1999 1999-2000 Operating ($) $2,866,657 $3,009,900 $3, 160,500 $3,318,500 $3,484,439 Non-operating (5) Other-- describe (5) -0- -0- -0- -0- -0- Totals (5) $2,866,657 $3,009,900 $3,160,500 $3,318,500 $3,484,439 2. SRF project (incremental expenses) ( INCREMENT FOR SLUDGE PROCESSING) Expense Category Year 1 Year 2 Year 3 Year 4 Year 5 Fiscal Year 1995-1996 1996-1997 1997-1998 1998-1999 1999-2000 Operating (5) —0— —0— —0— —0— —0— Non-operating (5) -0- -0- -0- -0- -0- . Other-- describe (5) -0- -0- -0- -0- -0- Totals (5) -0- -0- -0- -0- -0- 3. Non-SRF projects (if any) Expense Category Year 1 Year 2 Year 3 Year 4 Year 5 Fiscal Year 1995-1996 1996-1997 1997-1998 1998-1999 1999-2000 Operating (5) -0- -0- -0- -0- -0- Non-operating ($) -0- -0- -0- -0- -0- • Other-- describe (S) -0- -0- -0- -0- -0- Totals (S) -0- -0- -0- -0- -0- 4. All existing and planned facilities (existing facilities plus the SRF project plus other non-SRF projects) Expense Category Year 1 Year 2 Year 3 - Year 4 Year 5 Fiscal Year 1995-1995 1996-1997 1997-1998 1998-1999 1999-2000 Operating (5) $2,866,657 $3,009,900 $3, 160,500 $3,318,500 $3,484,439 Non-operating (5) -0- -0- -0- -O -0- Other-- describe (5) -0- -0- -0- -0- -U- Totals (T) $2,866,657 $3,009,900 $3, 160,500 $3,318,500 $3,474,439 4 H. For the utility providing the SRF dedicated revenues, identify the projected annual utility revenues assuming all the planned projects are constructed according to the schedule reported in Item C, above. Compare revenues to expenses identified in Subitern G.4, above, and explain (on an attachment) how any net toss is covered to keep the utility financially self-sufficient in each deficit year. (SEE ATTACHED REVENUE PROJECTIONS) Revenue Category Year 1 Year 2 Year 3 Year 4 Year 5 Fiscal Year 1995-1996 1996-1_997 1997-1998 1998-1 Operating 999 1 •99-2nn0 perating ($) 4,467,800 4,707,600 4,804,000 4,862,600 4 ,924,800 Non-operating ($) 425,800 425,800 419,400 Other-- describe (S) ___114,�oo 394,000 —0— —0— —0— —0— —0— Totals ($) 4,893,600 5. 133,400 5,223,400 5,526,600 5.318,800 I. Identify the projected annual expenses (costs) for the sewer (wastewater management) system, assuming all planned wastewater facilities will be constructed. These entries may be skipped if a sewer utility alone is providing the SRF dedicated revenues since the information already will have been presented in Subitern G.4, above. N/A Expense Category Year 1 Year 2 Year 3 Year 4 Year 5 Fiscal Year Operating ($) Non-operating ($) Other-- describe ($) Totals ($) J. Identify the projected annual revenues for the sewer (wastewater management) system, assuming all planned wastewater facilities will be constructed. Compare revenues to expenses identified in Item I, above, and explain (on an attachment) how any net loss is covered to keep the sewer system financially self•sufficient in each deficit year. These entries may be skipped if a sewer utility alone is providing the SRF dedicated revenues since the Information already will have been presented in Item 11, above. N/A Revenue Category Year 1 Year 2 Year 3 Year 4 Year 5 Fiscal Year Operating ($) Non-operating ($) Other-- describe ($) Totals ($) 5 K. Identify the average sewer system charge, fees, and assessments. If the utility service area encompasses districts or zones which will be subject to different service charges, fees, etc. attributable to the SRF project, it will be necessary to provide the data below for the district(s) or zone(s) responsible for SRF project expenses. Differential charges, fees, etc. should be explained on the attachment used to present the district or zone data. Description Year 1 Year 2 Year 3 Year 4 Year 5 Fiscal Year 1995-1996 1996-1997 1997-1998 1998-1999 1999-2000 1. Wastewater Management data a. Total estimated annual wastewater management costs S1 ,852,432 $1 ,445,000 $2,043,300 $2, 144,400 $2,251 ,600 * b. Non-residential share of total annual wastewater management costs 0% 0% 0% 0% 0% c. Residential share of total annual wastewater management costs 100% 100% 100% 100 100% d. Number of households 10.332 10,482 10,642 10 ,7q8 10,938 ** e. Average residential user charge /per month/customer 22 .91 23. 39 23,39 23 .38 23.37 *-' 2. Average connection fee per residential unit 500.00 500.00 500.00 500.00 500.00 *--- 3. Average impact fee per residential unit $1 ,250,00 $1 .250.00 Si ,250.00 Si ,250.00 51 ,250.00 4. Average Special assessment per residential unit • (identify basis below) N/A N/A N/A N/A N/A 5. Average capacity charge per residential unit (identify basis below) N/A N/A N/A N/A N/A 6. Other (describe) AVERAGE WATER CONNECTION FEE 525.00 525.00 525.00 525 .0n 525 nn 7. Other (describe) AVERAGE WATER IMPACT FEE 325.00 325.00 325.00_ 325.00 325 00 Describe basis for special assessments, such as cost per lot length NOT APPLICABLE Describe basis for capacity charge, such as cost per volume per day NOT APPLICABLE ., ATLANTIC BEACH, BUCCANEER & OAK HARBOR SYSTEM EXPENSES INCLUDE TREATMENT CULLECIION AND AUMINFSI}ATION ** FROM A.4 - INCREASE ATLANTIC BEACH & BUCCANEER SERVICE AREAS 1. Assuming all the planned wastewater facilities are constructed according to the schedule reported in Item C, above, identify the total annual residential (per household) user charge for sewer (wastewater management) service as a percent of median annual household income. Use the income data reported in Item A, above. The annual user charge will be the monthly amount reported pursuant to Item K.1.e, above, multiplied by twelve. Also report the construction and related capital costs for the SRF project (refer to Item C, above) on a per household basis. Note that the number of households reported in Item A, above, can be used directly (for either the user charge or the capital cost computation) only if the SRF project related costs will be borne by the utility service area as a whole. If capital cost sharing will vary by district or zone, report appropriate data according to district or zone on an attachment. Year 1 Year 2 Year 3 Year 4 Year 5 Fiscal Year 1995-1996 1996-1997 1997-1998 1998-1999 1999-2Q00 1. Annual user charge divided by household income (7.) 2. SRF project capital cost (not annualized data) per household ($) _637 .26 662. 57 657. 54 648,04 639,74 ***SUBTOTAL OF WASTEWATER OPERATING REVENUES FOR ATLANTIC BEACH, BUCCANEER & OAK HARBOR (ATTACHED) DIVIDED BY 1 .(1 X 12 MONTHS ****ES 4TED AVERAGE RESIDENTIAL CONNECTION FEE - VARIES TH ACTUAL CONSTRUCTION COST • M. If the proposed SRF wastewater facilities include collection sewers for any part of the utility service area, provide the following additional information for the affected households. Indicate whether these costs wilt be recovered over time (financed and billed to the customer by the local government). 1. Other costs per household associated with wastewater collection sewers Year 1 Year 2 Year 3 Year 4 Year 5 N/A Fiscal Year a. Service line (located on private property) b. Septic tank abandonment d. Other (describe) • Total Additional Cost per Household ($) • 2. Will these costs be financed by the local government and prorated billing used? YES NO N. Which, if any, of the following activities must be undertaken to implement the SRF project? 1. Acquire privately held land? YES _ NO XX 2. Acquire land held by another government entity? YES _ NO XX 3. Enter into interlocal or intergovernmental agreements? YES _ NO XX 4. Hold an election or public referendum? YES NO XX 5 Comply with special assessment or similar procedural requirements? YES _ NO XX 0. Attach a certification by the local government's chief financial officer or by an official authorized to comnit to the SRF funding that the local government has the financial capability to ensure adequate construction, operation, and maintenance of the sewer system. • 7 Atlantic Beach Revenues • Audit Proforma Projected 1991-1992 1992-1993 1993-1994 1994-1995 1995-1996 1996-1997 Operating Revenues - Water1997-1998 1998-1999 1999-2000 Minimum Water 5172,900 5261,100 Excess Water 5304,398 5329,408 5354,738 5380,433 5390,422 5312,400 5361,600 5404,397 5444,390 5550,291 $555.974 Set-vice Charges 54,300 57,700 5485,836 5529,115 5545,004 5550,291 57,500 Y7,500 57,500 $557,500 Cut -I Fees Charges 520,000 595,200 57,500 57,500 57,500 57,500 Cutinq Delinquent 530,000 530,000 530,000 530,000 530,000 515,600 513,500 514,000 514,000 514,000534,000 530,00014 Water Capital Improvement SO 522,000 514,000 514,000 514,000 510650 ' SubTotal 5525,200 542,588 525,298 518,200 518,200 517,290 5761,100 5802,883 5850,596 5910,274 009,650 513,6501 5979,247 51,004,217 51,009,650 51.018,717 Operating Revenues - Wastewater Base Sewer 5499,300 5505,500 Sewer Volume 5581,111 5635,300 5689,720 5710,664 5719,476 5541,700 5566,100 5637,656 5702,388 $810,637 5733,4291 SubTotal 51,041,000 51,071,600 5768,257 5793,016 5802,849 5810,637 51,218,767 51,337,687 51,457,977 51,503,680 51,522,325 51,537,092 $15.551,848 Non Operating Revenues - Water Connection Charges 578,200 554,400 568,796 ntest540,866 $29,400 546,000 534,200 529,400 527,930 � 530,000 530,000 $30,000 530,000 IntSul>'I'otal 5124,200 530,000 530,000 588,600 598,796 $70,866 $59,400 530,000 $52,050 $52,050 559,400 557,930 552,050 552.050 Non Operating Revenues Wastewater Connection Charges 5101,000 593,000 ntest - Unrestricted 565,520 538,920 528,000 $28,000 $26,600 593,400 563,000 590,000 590,000 $90,000 $90,000 Capital Facilities $109,000 $114,100 590,000 590,000 590,000 $90,000 $52,000 Special Assessments 5163,800 597,300 570,000 570,000 566,500 550,000 550,000 550,000 $50,500 $50,000 SubTotal 5303,400 5270,100 238,000 233, 00 213,500 213,500 5369,320 5276,220 5238,000 5238,000 $233,100 5213,500 5213.500 Population Estimate 14159 14627 Population Increase 14905 15105 15305 15495 15645 System Growth 468 278 200 200 15795 0.0331 190 150 150 Connection Increase 0.0190 0.0134 0.0132 0.0124 0.0097 Minimum Water 131.04 77.84 56 56 0.0096 0.0622 53.2 Excess Water 41.33% 0.0613 0.0628 0.0571 0.0000 42 42 8.00% 0.0833 0.0769 0.0000 0.0000 Base Wastewater0.0794 0.0735 0.0000 0.0000 0.0000 23.85% 0.0789 0.0710 0.0714 0.0000 Volume Sewer 9.33%85 0.0000 0.0000 0.0000 0.0894 0.0784 0.0796 0.0000 0.0000 0.0000 0.0000 • Buccaneer & Oak Harbor Revenues Audit Proforma Projected 1991-1992 1992-1993 1993-1994 1994-1995 199$-1996 O 1996-1997 1997-1998 1998-1999 1999-2000 Operating - Water Minimum Water $135,700 5138,000 Water 5165,574 5185,027 8203,172 5221,944 5229,699 5215,900 5304,700 5348,558 5396,899 8233.696 5237,692 Service Charges S4,900 54,000 2443,963 5494,257 5513,817 5522.757 S Delinquent Charges Charges 57,500 $7,500 $7,500 57,500 5531,500 Cut-In Pecs 510,000 56,300 830,000 330,000 57,500 57,500 57,500 54,300 557,300 530,000 530,000 530,000 530,000 Water Capital Improvement 514,000 514,000 514,000 514,000 570,000 SO $1,425 S35,035 535,490 518.200 814,000 518,000 SubTotal 5370,800 $511,425 518,200 518,200 518,200 518,200 5600,667 $668,916 5716,836 5785,901 8 S18,200 5813,216 5826,153 5339.038 Operating Revenues - Wastewater , Base Sewer 5462,000 5423,200 Base Volume 8500,501 5566,347 5628,143 5652,830 5664,385 5349,000 5511,000 5590,304 5674,149 5813,742 3,742 5827,657 SubTotal827,657 5811,000 5934,200 57$4,.55.2 5785,914 5799,82,5 51,090.805 51,240,496 •.81,382,695 51,438,744 51,464,210 51,489,687 51,515,161 Non Operating Revenues - Water Connection Charges Interest $57,120 $57,855 $29,925 $29,925 529,925 Included in Atlantic Beach 529,925 529,925 SubTotal 557,120 557,855 529,925 S29,925 529,925 S29,925 529,925 Non Operating Revenues Wastewater Connection Charges Interest - Unrestricted $54,400 $55,100 $28„500 $28,500 528,500 528,500 528,500 Included in Atlantic Beach Capital Facilities 565,600 $66,500 Capital asessments5134,750 5136,500 570,000 570,000 570,000 Included in Atlantic Beach 570,000 570,000 Sub'Potal 565,600 56 6,500 5189,150 5191,600 598,500 598,500 598,500 598,500 598,500 • Population Estimate 10125 Population Estimate 10510 10900 11100 11300 11500 385 390 200 11700 11900 System Growth Increase 200 200 200 200 Connection Increase • 0.0380 0.0371 0.0183 0.0180 0.0177 107.8 109.2 56 0.0174 0.01716 Minimum Water Rate Increase 51.66% 56 56 56 56 Excess Water Rate Increase 0.0766 0.0778 0.0785 0.0714 0.0000 10.00% 0.1041 0.0961 0.0992 0.0000 0.0000 Base Wastewater Rate Increase 29 81% 0.0919 0.0000 0.0000 0.0000 Volume Sewer er Ratecrc 0.0988 0.0888 0.0893 0.0000 0.0000 11.66% 0.1118 0.0980 0.0995 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 •Connection Increase Calculated on Population Increase,2.5 per capita per connection,70%new connections OperatingT±Epenses Audit Proforma Projected 1991-1992 1992-1993 1993-1994 1994-1995 1995-1996 1996-1997 1997-1998 1998-1999 1999-2000 Water Expenses Atlantic Beach Transfer to General Fund $63,407 $123,126 $129,282 $135,746 $142,534 $149,660 $157,143 $165,001 $173,251 Atlantic Beach Water $336,500 $390,400 $409,920 $430,416 $451,937 $474,534 $498,260 $523,173 $549,332 Buccaneer Transfer to General Fund $138,100 $119,000 $124,950 $131,198 $137,757 $144,645 $151,878 $159,471 $167,445 Buccaneer Water $216,700 $239,000 $250,950 $263,498 $276,672 $290,506 $305,031 $320,283 $336,297 Oak Harbor Transfer to General Fund $1,700 $2,400 $2,520 $2,646 $2,778 $2,917 $3,063 $3,216 $3,377 Oak Harbor Water $1,000 $2,200 $2,310 $2,426 $2,547 $2,674 $2,808 $2,948 $3,096 Subtotal Water Expenses: $757,407 $876,126 $919,932 $965,929 $1,014,225 $1,064,937 $1,118,183 $1,174,093 $1,232,797 Wastewater Expenses Atlantic Beach Transfer to General Fund $191,900 $246,800 $259,140 $272,097 $285,702 $299,987 $314,986 $330,736 $347,272 Atlantic Beach Wastewater $641,800 $673,500 $707,175 $742,534 $779,660 $818,643 $859,576 $902,554 $947,682 Buccaneer Transfer to General Fund $278,300 $309,300 $324,765 $341,003 $358,053 $375,956 $394,754 $414,492 $435,216 Buccaneer Wastewater $312,300 $349,300 $366,765 $385,103 $404,358 $424,576 $445,805 5468,095 $491,500 Oak I'arbor Transfer to General Fund $11,800 $13,300 $13,965 $14,663 $15,396 $16,166 $16,975 $17,823 $18,714 Oak Harbor Wastewater $107,800 $8,000 $8,400 $8,820 $9,261 $9,724 $10,210 $10,721 $11,257 Subtotal Wastewater Expense: $1,543,900 $1,600,200 $1,680,210 $1,764,221 $1,852,432 $1,945,053 $2,042,306 $2,144,421 $2,251,642 Total Utility Expense: $2,301,307 $2,476,326 $2,600,142 $2,730,149 $2,866,657 $3,009,990 $3,160,489 $3,318,514 $3,484,439 • Summary Audit Proforma Projected 1991-1992 - 1992-1993 1993-1994 1994-1995 1995-1996 1996-1997 1997-1998 1998-1999 1999-2000 Total Operating Revenue Water $896,000 $1,272,525 $1,403,550 $1,519,512 $1,627,110 $1,765,148 $1,817,433 $1,835,803 $1,857,805 Wastewater $1,852,000 $2,005,800 $2,309,572 $2,578,183 $2,840,672 $2,942,424 $2,986,535 $3,026,779 $3,067,009 Tota I: $2,748,000 $3,278,325 $3,713,122 $4,097,695 $4,467,782 $4,707,572 $4,803,968 $4,862,582 $4,924,814 'ictal Non Operating Revenue Water $124,200 $88,600 $155,916 $128,721 $89,325 $89,325 $87,855 $81,975 $81,975 Wastewater $369,000 $336,600 $558,470 $467,820 $336,500 $336,500 $331,600 $312,000 $312,000 Tota I: $493,200 $425,200 $714,386 $596,541 $425,825 $425,825 $419,455 $393,975 $393,975 Total Revenue $3,241,200 $3,703,525 $4,427,508 $4,694,236 $4,893,607 $5,133,397 $5,223,423 $5,256,557 $5,318,789 Total Operating Expenses Water $757,407 $876,126 $919,932 $965,929 $1,014,225 $1,064,937 $1,118,183 $1,174,093 $1,232,797 Wastewater $1,543,900 $1,600,200 $1,680,210 $1,764,221 $1,852,432 $1,945,053 $2,042,306 $2,144,421 $2,251,642 Total: $2,301,307 $2,476,326 $2,600,142 $2,730,150 $2,866,657 $3,009,990 $3,160,489 $3,318,514 $3,484,439 Net Revenue $939,893 $1,227,199 $1,827,366 $1,964,086 $2,026,950 $2,123,407 $2,062,934 $1,938,043 $1,834,350 Debt Service Liberty National $0 $69,446 $69,447 $0 $0 $0 SO Gulf Breeze $0 $108,231 $106,594 $107,616 $105,714 $106,491 $107,105 Barnett Bank $0 $227,045 $290,872 $631,952 $631,952 $631,952 $631,952 SRF- Oak Harbor(Not Included in this Request) $0 SO $40,330 $40,330 $40,330 $40,330 $40,330 SRP-Atlantic Beach WWTP Expansion $0 SO $348,800 $348,800 $348,800 $348,800 $348,800 Total Debt Service $0 $404,722 $856,043 $1,128,698 $1,126,796 $1,127,573 $1,128,187 Debt Service Coverage4.85 2.37 1.88 1.83 1.72 1.63 • General Notes 1. Projection of water and wastewater base charges and volume charges for revenue and expenses based upon fiscal year 1993-1994 preliminary audit (proforma). 2. Water and wastewater revenues and expenses include production, treatment, distribution, collection and support services. 3. Water and wastewater revenues increased by estimated annual system growth and existing rate structure increases. 4. Water and wastewater revenue rate increases are effective January of each fiscal year. Projections are adjusted to fiscal calendar year October 1 through September 30. 5. Buccaneer Water and Wastewater base charges and volume charges increase at 1.25 times the in-City rate increase. 6. Customer connections estimated at 2.5 persons/connection. 7. New construction connections estimated at 70 percent of customer connection increases. • $. Water Capital Improvement Revenues estimated at$325 per new construction connection. -410 P P 9. Water Connection Charges Revenues estimated at$525 per new construction connection. 10. Wastewater Connection Charges Revenues estimated at$500 per new construction connection. 11. Wastewater Capital Facilities Revenuew estimated at$1,250 per new construction connection. 12. System expenses increased at 5 percent per annum. Expenses do not include debt service or depreciation. 13. With the exception of additional sludge processing operation expense, capital improvements are not expected to significantly increase or decrease the basic operating expenses. 14. Transfer of General Fund covers prorated administrative expenses of Public Works, Finance, and City Manager offices. •