Loading...
HomeMy WebLinkAboutDocumentation_Miscellaneous_Tab 5_5/20/1996 Memorandum To: Public Works Committee Members From: Thomas G. Bradford, Village Manager f ' ' Date: May 17, 1996 Subject: Available Revenues for Proposed Public Works Projects Without the benefit of the Director of Finance and the Director of Public Works, both of whom are on vacationyas of this writing, I have reviewed the General Fund balance and the Capital Improvement Fund balances in order to derive an estimate of fund availability for the Public Works projects to be reviewed by you at your meeting on May 20. My analysis is detailed under the heading of "Revenues" on the attached spreadsheet entitled "Stormwater Utility Capital Projections" . As you can see, I have culled all the capital improvement accounts to derive as much funding as possible from this source and have taken $170, 000 from the General Fund Undesignated Balance. Using $170,000 of the General Fund Undesignated Balance is estimated to bring the balance to $573, 375 . I contemplate requesting an additional $30, 000 for a computer network system throughout the Village facilities . The Early Retirement Incentive Program may require an additional $50,000 . With the hurricane season upon us and the need to anticipate the use of at least $50, 000 to balance the budget for FY 1997 , I do not believe it would be prudent to use any more of this General Fund Undesignated Balance. I have prioritized the Public Works drainage projects based upon my opinion of urgency. You and others may feel differently. Notice that I have given you two (2) 'scenarios relative to expenditures, one being on a cash basis, the other on'' a debt service basis . There are pros and cons to each, which I am sure we. will discuss at your meeting and at the forthcoming Stormwater Utility Board Meeting. • However, please keep in mind the following when considering the same. The amount of debt ($391,500) is not worth a bond issue. However., if packaged with other Village needs, such as new facilities, these become a bondable group of projects . Since we are nowhere near finalizing anything relative to our facilities, a loan from a bank could be done at this time and 'rolled-over into a bigger bond package once the facility decisions have been made. Banks may not go beyond ten (10) years in a loan for such purposes . A debt service schedule for a 10-year loan and a 15-year bond have been included with your package. TGB/krb Attachment STORMWATER UTILITY CAPITAL PROJECTIONS PROJECT EXPENDITURES FY96 FY97 FY98 FY99 FY00 FY01 Prioritized on cash basis ; Dover Ditch Maintenance Dredge 110000 0 0 0 0 0 Tequesta Drive Drainage Diversion 70000 0 0 0 0 0 Seabrook Road North 139000 0 0 0 0 0 Shay Place 0 40000 0 0 0 0 Seabrook Road South 0 41500 33000 33000- 0 0 North Dover Road 0 0 63000 0 0 0 Country Club Drive 0 0 0 45000 0 0 Cypress Drive 0 0 0 0 55000 0 Riverside Drive 0 0 0 0 0 81000 TOTAL 319000 81500, 96000 78000 55000 81000 PROJECT EXPENDITURES FY96 FY97 FY98 FY99 FY00 FY01 Prioritized on debt service basis Dover Ditch Maintenance Dredge 110000 0 0 0 0 0 Tequesta Drive Drainage Diversion 70000 0 0 0 0 0 Seabrook Road North .139000 0. 0 0 0 0 Shay Place - 0 40000 ' 0 0 0 0 Seabrook Road South 0 107500 0 0 0 0 North Dover Road 0 63000 0 0 0 0 Country Club Drive 0 45000 0 , 0 0 0 Cypress Drive 0 55000 _ 0 0 0 0 Riverside Drive 0 81000 0 0 0 0 Debt Service Expense 0 0 57245 57245 57245 57245 . TOTAL 319000 391500 57245 57245 57245 57245 REVENUES FY96 FY97 FY98 FY99 FY00 FY01 Tequesta Branch Library 45000 0 0 0 0 0 Tequesta Drive Pathway 7500 _ 0 0 0 _ 0 0 Village Hall Parking Lot 6000 0 0 0 0 0 Village Hall Landscape 5000 0 0 0 0 0 Tequesta Drive Bridge 5000 0 0 0 0 0 Dover Ditch 40000 0 0 0 0 0 Country Club Drainage Ponds 38000 -_ 0 0 0 - 0 0 Drainage System Improvements 2500 0 0 0 0 0 General Fund Undesignated Balance 170000 0 0 0 0 0 Stormwater Utility Fees .— 0 40000_ _ 40000 70000 - 60000 60000 TOTAL 319000 40000 40000 70000 60000 60000 Interest Vision - 1 Amortization Schedule Loan or Annuity. Variables : Start Date: May 17, 1996 End Date : 'May 17, 2006 Start Payment: May 17, 1996 No. of Payments : 10 Start Interest: May 17, 1996 Interest Rate: - 6 . 500% Payment Freq. :, Annual Initial Principal : $411500 .00 Compound Freq. : Annually Payment Amount: $57241.58 Days in Mo. /Yr. : Actual No. Balloon: $0 .00 Payment Mode: In Arrears Amortization Method: Simple Int. • Payment Interest Interest No. Date Amount Amount Rate/Yr. Principal Balance May 17, 1996, 0 . 00 0 .00 0 . 000 0 . 00 411500 .00 1 May 17, 1997 57241 .58 26747 .50, 6 . 500 30494 . 08 381005 .92 2 May 17 , 1998 57241. 58 24765 .38 6 . 500 32476 .20 348529 .72 - 3 May 17, 1999 57241 . 58 22654 .43 6 . 500 34587 . 15 313942 .58 4 May 17 , 2000 57241 . 58 20406 .27 6 .500 36835 .31 277107 .26 5 May 17, 2001. 57241.58 18011 .97 6 . 500 39229 . 61 237877 .66 6 May 17, .2002 57241 . 58 15462 .05 6 .500 41779 . 53 196098 .12 7 May 17, 2003 57241.,58 12746 .38 6 .500 44495 .20 151602 .92 8 .May 17, 2004 57241 . 58 9854 .19 6 . 500 47387 .39 104215 .53 9 May 17, 2005 57241 .58 6774 . 01 6 . 500 50467 . 57 53747 . 96 10 May 17, 2006. , 57241.58 3493 .62 6 . 500 53747 . 96 0 .00 1 Interest Vision Amortization Schedule Loan or Annuity Variables : Start Date: May 17, 1996 End Date: May 17, 2011' Start Payment: May 17, 1996 No. of Payments : 15 Start Interest: May 17, 1996 Interest Rate: 6 . 500% Payment Freq. : Annual Initial Principal: $411500 .00 Compound Freq. : Annually Payment Amount: $43764 . 17 Days in Mo. /Yr. : Actual No. Balloon: $0 .00 . Payment Mode: In Arrears • Amortization Method: Simple Int. Payment . Interest Interest , No. Date Amount Amount Rate/Yr. Principal Balance May 17, 1996 0 .00 0 .00 0 .000 0 .00 411500 .00 1 May 17 , 1997 43764 . 17 26747 .50 6 .500 17016 .67 394483 .33 2 May 17, 1998 43764 . 17 25641.42 6•.500 18122 .75 376360 .58 3 May 17, 1999 43764 . 17 24463 .44 6 .500 19300 .73 357059 . 84 4 May 17, 2000 43764 . 17 23208 . 89 6 .500 • 20555 .28 336504 . 56 5 May 17, 2001 43764 .17 21872 . 80 6 .500 21891 .37 314613 . 19 6 May 17, 2002 43764 . 17 20449 . 86 . 6 .500 23314 .31 291298 . 88 7 May 17, 2003 43764 .17 18934 .43 6 .500 . 24829 .74 266469 .13 8 May 17 , 2004 43764 . 17 17320 .49 6 .500 26443 . 68 240025 . 46 9 May 17,• 2005 43764 . 17 15601 . 65. 6 .500 2.8162 . 52' 211862 . 94 10 May 17, 2006 43764 . 17 13771 .09 6 .500 29993 .08 181869 .8.6 11 May 17, 2007 43764 . 17 ` 11821 . 54 6 .500 31942 . 63 149927 .23 12 May 17, 2008 43764 .17 9745 .27 6 .500 34018 .90 1159.08 .33 13 May 17, 2009 43764 . 17 7534 . 04 6 .500 36230 . 13 79678 .20 14 May 17, 2010 43764 .17 5179 .08 6 .500 38585 . 09 41093 . 12 15 May 17, 2011 43764 . 17 2671 .05 6 . 500 ' 41093 . 12 . 0 .00 • Post-it'Fax Note 7671 Dabs—,a 1,631,610 / 'wait cu. Aloa Opt. To: Tom Bradford Phone• Nunn., 7 From: Al'Oslund �. 71-- Date: May 15, 1996 `�� Gze 3 3 �" Re: Proposed Capital Improvement Projects -4'4k):1. t t- ! ..� 'c...x, y -..r. r'.w .£ .....r•+.+M.....,.o...x:<� w �::M �1.� ( � +. 1 r �G •rtidb ...,a...i�•M.w .....c + y w...w w•rA-•-•xr f h -Y F ^'•'/ a,o- ..;w'.».wy. ^v-w a + ' =y Place-add storm sewer positive outfall to $40,000 Seabrook Rd. rdquesta Drive•add storm drainage from $70,000 aeabrook Rd. to Short Ave. —leabrook Rd. North-add storm drainage from $139,000 Qonstitution Park North to Willow. Add curb& %Vter from Tequesta Dr. North to Wiow. Seabrook Rd. North-landscape&Irrigation from $60,000 Tequesta Dr. to Willow both sides of road 9iabrook Rd. South-repair storm drainage line • $100,000 firm Tequesta Dr. to Dover Ditch []ever Ditch-maintenance dredge ditch from $110,000 , 1f est of Seabrook Rd.West to River (` untry Club Drive-add storm drainage from $45,000 North of Country Club entrance North to Tequesta Circle. Fprth Dover Road-add storm drainage from — $83,000 200'+1-West of Seabrook Rd.,West to Garden • SI. Add curb, gutter&parking from Seabrook to t3itrden St. —vpress Drive-add storm drainage&connect to $55,000 eliisting storm drainage on Tequesta Dr. Turtle Creek Entrance-modify Turtle Creek $45,000 entrance to make It a 4-way stop on Country Cpb Drive • Rfierside Drive-add storm drainage from Dover $81,000 DNch North to Tequesta Drive Includes curb& Witter 1 .