The URL can be used to link to this page

Water Operating CIPCity of Otsego Water Utility Fund Budget Summary December 31, 2016 Fund Account Description REVENUES 601 37150 Water Sales 601 37155 Water Sales - Irrigation 601 37160 Water NSF 601 31900 Penalties and Interest OPERATING 601 34109 Other Administrative Charges 601 34302 Water Meters 601 36100 Special Assessments 601 36102 Special Assessments - P & 1 601 36210 Investment Interest 601 36213 Change in Investments FMV 601 36232 Developer Contributions 601 37165 Water Tower Leases 601 37170 DNR Fees Collected 601 38990 Miscellaneous 601 38991 Refunds & Reimbursements NON -OPERATING TOTAL REVENUES EXPENDITURES 601 49400 101 Full -Time Employees 601 49400 102 FT Overtime 601 49400 104 Part -Time Employees 601 49400 119 Payroll Allocation 601 49400 121 PERA 601 49400 122 FICA 601 49400 123 Health 601 49400 130 Other Insurance 601 49400 140 Unemployment Compensation 601 49400 150 Workers Compensation PERSONAL SERVICES 601 49400 201 Office Supplies 601 49400 202 Fuel 601 49400 206 Postage 601 49400 210 Operating Supplies 601 49400 216 Chemical Supplies 601 49400 220 R & M Supplies 601 49400 225 Uniform/Clothing Allowance 601 49400 227 Safety Supplies 601 49400 228 Utility System Supplies 601 49400 240 Small Tools and Equipment 601 49400 298 Fleet Expenses SUPPLIES Actual Actual Actual Budget YTD - Sept Proposed 2012 2013 2014 2015 2015 2016 2015 Comments 2016 Comments 838,013 862,413 883,966 1,052,500 713,384 916,000 - 139,419 106,747 75,000 104,040 90,000 (85) 43 (565) - 67 - 30,047 35,281 35,000 25,513 30,000 837,928 1,031,921 1,025,429 1,162,500 843,003 1,036,000 1,684 15,313 15,225 - 3,000 - 57,219 70,313 70,056 68,000 56,200 85,000 79,090 72,224 (4,551) - 40,224 - 12,226 4,095 6,168 - 17,226 30,272 42,919 - (38,665) - - - 42,530 - - - 55,168 64,050 52,538 60,000 49,483 66,000 - 16,422 17,426 18,600 18,597 19,080 6,082 2,600 13,185 - 692 - 1,078 228,695 236,625 255,496 146,600 169,274 170,080 1,066,624 1,268,547 1,280,926 1,309,100 1,012,277 1,206,080 27,826 78,353 27,060 47,720 29,397 52,531 - - 709 1,100 1,015 1,250 - - 2,032 300 405 500 24,960 3,750 - - - - 2,008 4,979 2,080 3,662 2,989 4,034 1,921 5,613 2,086 3,758 2,309 4,152 2,458 5,257 3,087 8,679 - - 161 663 274 - 4,670 7,806 322 717 2,142 1,905 1,526 59,334 98,936 38,046 67,361 42,689 71,799 7,036 11,651 11,203 10,000 1,461 5,000 202 162 - 6,833 2,766 2,963 4,595 4,720 6,261 6,600 4,672 8,820 41,061 99,139 108,994 4,110 6,159 9,200 - - - 58,000 48,295 60,000 7,850 5,152 2,555 14,820 12,251 15,000 - 1,254 901 1,100 1,122 1,475 809 319 1,000 716 1,500 - - 45,000 57,221 67,500 8,065 4,929 500 749 20,000 - 3,322 2,600 544 2,600 60,744 130,951 138,484 150,563 135,956 194,058 2.5% Rate Increase (2/11/13) Currently Flat - Ehler's Plan is 2.50 % Conservative Increase Slight Decrease to be Conservative 170 Meters at $400 200 Meters at $425 Sprint / Verizon / Nextera 2,924 Connections at $6.36 3,000 Connections at $6.36 (9/29/15) 25 % of Utility Employees 25 % of Utility Employees Utility Total - $4,400 Utility Total - $5,000 Utility Total - $1,650 Utility Total - $2,000 7.50 % of Gross Wages 7.65% of Gross Wages Health / Dental / LTD / STD / Life Based on 7/1/15 - 7/1/16 Invoice General Office / Printer Ink / Envelopes / Folding Machine Maintenance 50% of 3,644 Gallons at $3.75 25% of 3,950 Gallons at $3.00 50% of 2,200 Monthly Bills at $0.49 50% of 3,000 Monthly Bills at $0.49 See Attachment See Attachment See Attachment Transducer / Variable Frequency Drive 1 Hanging Heaters / Chemical Pumps 50% of 4 Staff Allowances of $550 50% of 5 Staff Allowances of $550; Additional $200 for New Staff Arc Flash suit/traffic vest/ear plugs/glasses, Traffic Vests / Ear Plugs / Safety Glasses / 1 st aid kit supplies, insolated tools, trench 1st Aid Kits / Arc Flash PPE / Cones box (1/2), tripod 170 Meters at $260 225 Meters at $300 (200 New / 25 Replace) Hydrant king nut stop removal / Drill See Attachment 8 oil changes@ $40e, 4 fire rotate @ $15e, 8 oil changes@ $40e, 4 tire rotate @ $15e, Jet Vac oil $420, Crane truck cable, Air Jet Vac oil $420, Crane truck cable, Air Filter, Light, Battery, Brakes, wheel well Filter, Light, Battery , Brakes, wheel well paint, trany flush@$200.(1/2). Fuel moved paint, trany flush@$200.(1/2). Fuel moved to 402 to 402 U:\Budget\2016\Utility Funds\Water Water Fund Summary 601 49400 301 Legal 232 462 500 500 601 49400 302 Engineering Fees 7,145 1,920 42,550 15,000 35,939 5,000 WHP amendment 2 601 49400 303 Planning Fees 750 175 - 500 - - 601 49400 306 Permits & Fees 7,713 150 25,296 29,000 20,615 27,580 DNR Appropration 9000/Tierll DNR ($8,000) / Tier II (4 @ $100) / MDH 4x125=500/MDH connectionfees (6.36 per (3,000 @ $6.36) / Well Permits (2 @ $50) connection@2724 in 2014) estimating 2924 2015; 2 well maintenance permits 50e 601 49400 315 GIS Services 190 2,501 1,647 3,000 450 4,000 601 49400 320 Telephone - 2,181 2,593 2,301 2,031 3,420 2 hard lines @ 213.53/ mo=2562.36 50 % - Hard Lines ($220 Month) / Cell 4 cell = [(50+40(3)]x12=2040 Phones (5 @ $50 Month) / New Devices ($1,200) 601 49400 321 Mileage & Travel - 91 - - - - 601 49400 322 Utilities 50,368 54,189 69,607 57,000 42,475 59,000 601 49400 350 Print & Publishing 2,559 265 - 300 - 300 601 49400 355 Dues & Memberships 392 623 629 340 328 352 MRWA=$225/2 MMUA $404/2; AWWA $25 50%- MMUA ($400 / 3) / MRWA ($260) AWWA ($25) 601 49400 360 Education/Training/Conferences - 650 2,076 2,859 1,864 1,500 MMUA allocation for safety training = CEU (5 @ $300) 3718/2 250 x 4 = 1000 601 49400 361 Liability & Property Insurance 6,690 - 8,046 6,268 4,408 10,688 5% Increase + More In Depth Allocation 601 49400 375 Water Test Fee 437 16,240 - - - - Moved to Line Item 306 601 49400 390 Contracted Services 207,144 117,551 51,213 58,600 32,312 83,580 See Attachment See Attachment 601 49400 402 Repairs & Maintenance Services - 4,755 571 - - - 601 49400 410 Rentals - 38 - - 601 49400 437 Bank Service Charges - - - - 3,752 8,400 50 % - Credit Card Fees / PSN Online Payment Fees / ACH / Bank Service Charges @ $1,400 Monthly SERVICES & OTHER CHARGES 283,621 201,754 204,265 175,668 144,174 204,320 601 49400 420 Depreciation 473,379 475,224 472,761 502,200 - 510,000 Rough Estimate of 2 % Growth Rough Estimate of 2 % over 2015 Budget. 601 49400 501 Equipment - 320 - - 437,350 Based on Draft 2016 CIP 601 49400 602 Bond Interest - - - 424,914 - All Debt Service Paid from WAC Fund 601 49400 720 Operating Transfers 9,800 - 52,889 56,638 30,800 43,439 Reimburse General Fund ($56,638) Reimburse General Fund ($33,439) / Jet Vac Debt Transfer ($10,000) OTHER 483,179 475,544 525,650 983,752 30,800 990,789 TOTAL EXPENDITURES 886,878 907,184 906,446 1,377,344 353,619 1,460,966 CHANGE IN FUND NET ASSETS 179,745 361,362 374,480 (68,244) 658,658 (254,886) Fund Cash Balance 1,823,474 2,539,591 3,327,541 3,850,946 U:\Budget\2016\Utility Funds\Water Water Fund Summary 210 Operating Supplies 2016 Preventative Maintenance Oils / Grease / Filters / Gloves / Paint 500 Ball valves/torches/zip ties/tie downs 400 Laboratory - Reagents / pipet / wipes 200 Chem pump parts - diaphram/repair kit/4way valve/connector 1,000 Chlorine tubing 100 Chemical injection parts 400 EJ-1 Ejector 100 ppd (2) 900 Winter Items -Salt / Snow markers / Shovel 200 Hose / Hose repairs / Fittings 1,000 C - Fold Towels / Cleaning Supplies 100 Lighting - bulbs; driveway lights/WT lights/security lights 1,000 Lawn Maintenance -Trees/Mulch/Weed Spray 400 10 top bell water valves @ $80 each 800 Chemical room window film 100 Hydrants 1 nozzle, 4 main valve rubber, seats, 4 Flange Gaskets, 1 cane 1,200 Hydrant Traffic Flange Replacement 4 - 225e 900 Total 9,200 240 - Small Tools and Equipment Well House Chemical Feed Pumps 2 Chlorine Gas Regulator Heads WH3 - Chlorine feed regulator 2 Hi E Dry Dehumidifier- WH2 / WH4 Distribution Repairs - valve extentions, main parts 2016 2,400 2,400 3,000 6,800 4,000 Transducer - Well level monitoring 1,000 Hose Bander 200 Valve Cutter 200 Total 20,000 390 Contracted Services 2016 On Call Answering Service 800 IT - Computer/Software/Upgrades/Back Ups 5,000 Civic Systems 1,200 Itron - Meter reads maintenance agreement 2,500 2 Well Pump Pulls 6,000 Well 5 / Well 8 Instrumentation Services 5,000 Electrical Services 5,000 Generator Service - Preventative and Corrective Maintenance 2,000 2 portable gen sets Public Water System Testing - 15x9x12 Total Coliform 1,620 Population based - MDH Policy Security - Alarm Monitoring Water Locations 1,400 Lawn Spraying Water sites 200 3 Well Houses/ 3 WT Annual Fire Ext Testing / Replacement 100 Meter Testing - Municipal Wells / Residents 1,000 RPZ Testing - 4 bulk water meters 200 $50/insp; 2017@150/rebuild Well 3 motor replacement & Check valve Locates 26,000 Water Tower Inspections - $8,000 in 2020 for WTI/2/3 Water Tower 2 & 3 Cleaning 6,000 Water Tower Repairs - PSI control valve seat replacement 4,000 Water Main repair 12,000 Pavement Management - Fog Seal/Seal Coat 760 Pavement Management Document Alarm upgrage to 4G - ($450 per site) BS/WT1/WT2/WT3 1,800 Safety Management Program 1,000 Total 83,580 City of Otsego, Minnesota Capital Improvement Plan 2016 thru 2020 PROJECTS BY FUNDING SOURCE Source Project# Priority 2016 2017 2018 2019 2020 Total 601 - Water Utility Fund Water Tower#1 Rehabilitation 601-2016-01 n/a 428,600 428,600 West District Water Capacity 601-2018-01 n/a 689,585 689,585 Water Tower #2 Painting Touch -Ups 601-2019-01 n/a 250,000 250,000 Well #3 Rehabilitation 601-2020-01 n/a 150,000 150,000 Well Rehabilitation (#1,2,5,6) 601-2020-02 n/a 360,000 360,000 Ford F250 Extended + Plow FLEET-16-01 n/a 8,750 8,750 601 - Water Utility Fund Total 437,350 689,585 250,000 510,000 1,886,935 GRAND TOTAL 437,350 689,585 250,000 510,000 1,886,935 Monday, October 19, 2015 2016 thr, 2020 Capital Improvement Plan City of Otsego, Minnesota Project # 601-2016-01 Project Name Water Tower #1 Rehabilitation Description Water Tower #1 Interior and Exterior Painting Justification I Department Water Utility Contact Lead Utility Systems Operator Type Utility System Useful Life Category Water Utility System Priority n/a Total Project Cost: $428,600 Water Tower #1; a 400,000 gallon tower was built in 1999. The tower was removed from service in 2010 as water supply needs were meet hrough use of Water Tower #3; a 1,000,000 gallon hydropillar. Growth within the 'ublic Water System has reached Tower #3 well capacities requiring Water Tower #1 and its supply wells to return to service in '.016. Inspections conducted in 2009 ndicated a "fair to good" rating for the Exterior; a "failing rating for the Interior Wet & "fair" rating for the Interior Dry. Inspections completed in !015 identified indicated a "x" rating for the Exterior; a "x" rating for the Interior or Wet & a "x" rating for the Interior dry. 2015 Estimates - painting and epairs: Interior Wet Structure Repairs - ;20,100, Interior Wet Coating - Complete Replacement - $112,600 Total - ,132,700 Interior Dry Structure Repairs - $ 17,100, Interior Dry Coating - 'artial Replacement - $48,100 Total - $65,200 Exterior Coating Structure Repairs - $8,900, Exterior oating -Complete Replacement - $191,800 Total - $200,700 Mobilization - ;30,000 Total - $30,000 Total Project :stimate is $428,600 with a construction schedule of eight weeks. If completed the City would expect 20-25 years of service life from the new Expenditures 2016 2017 2018 2019 2020 Total Utility System 428,600 428,600 Total 428,600 428,600 Funding Sources 2016 2017 2018 2019 2020 Total 601 - Water Utility Fund 428,600 428,600 Total 428,600 428,600 Monday, October 19, 2015 2016 thr, 2020 Capital Improvement Plan City of Otsego, Minnesota Project # 601-2018-01 Project Name West District Water Capacity Description ,xpansion of well capacity for the West District to Riverwood and future development. direction from Ron, added 3% inflation on top of $650,000 for 2016 and 2017. Justification Department Water Utility Contact Lead Utility Systems Operator Type Utility System Useful Life Category Water Utility System Priority n/a Total Project Cost: $689,585 [be City Engineer estimates that the existing water system within the West District will reach its design capacity of 1,746 recs in 2016. This :stimate is based on the present rate of development, which is likely to accelerate as economic conditions improve. Development of a single :ommercial or industrial use with high water demands would also affect the available capacity of the water system within West District. The cost o drill another well and construct the necessary facilities to add water system capacity is estimated at $350,000. An alternative option is to :onnect Well #7 to the West District water system for a cost of $650,000. The alternative option would provide needed water capacity for the west ;ewer district and also address on -going water pressure issues experienced by water users at Riverwood National during periods of peak use. The )Ian would consist of a 16" waterline from 70th Street to 80th Street and a 12" waterline from 80th Street to 90th Street. project was originally scheduled for 2014. As discussed at the 2012 CIP meetings, an annual review of the continued water issues at rwood National will need to be done to determine the actual timeline of this project as well as review of the financing options. Sept. 2012 - This project was moved from 2012/2013 to 2013/2014. 2013 - project moved to the 2015 - 2016 time frame for further discussion. Expenditures 2016 2017 2018 2019 2020 Total Utility System 689,585 689,585 Total Funding Sources 2016 689,585 2017 2018 2019 689,585 2020 Total 601 - Water Utility Fund 689,585 689,585 Total 689,585 689,585 Monday, October 19, 2015 Capital Improvement Plan City of Otsego, Minnesota Project # 601-2019-01 Project Name Water Tower #2 Painting Touch -Ups Description Nater Tower #2 Painting & Maintenance. Justification 2016 thr, 2020 Department Water Utility Contact Lead Utility Systems Operator Type Utility System Useful Life Category Water Utility System Priority n/a Total Project Cost: $250,000 Water Tower #2; a fluted pedestal 1,000,000 gallon hydropillar was built in 2004. Inspections conducted in 2015 identified an overall Exterior rating of "good" with exception of "poor" for the bowl cone; a "fair to good" rating was provided for the Interior Wet & a "fair to good" rating for the Interior Dry. 2015 Estimates - painting and repairs: Interior Wet Structure Repairs - $7,700; Interior Wet Coating - Complete Repair - $70,100 Total - $77,800 Interior Dry Structure Repairs - $9,000; Interior Dry Coating - Spot Repair - $67,800 Total - $76,800 Exterior Structure Repairs - $4,500; Exterior Coating - Spot Repair - $63,300 Total - $67,800 Mobilization - $25,000 Total - $25,000 Total Project estimate is $247,400 with a construction schedule of four weeks. If completed the City would expect 10-15 years of service life from the new Expenditures 2016 2017 2018 2019 2020 Total Utility System 250,000 250,000 Total Funding Sources 2016 250,000 2017 2018 2019 2020 250,000 Total 601 - Water Utility Fund 250,000 250,000 Total 250,000 250,000 Monday, October 19, 2015 Capital Improvement Plan City of Otsego, Minnesota Project# 601-2020-01 Project Name Well #3 Rehabilitation 2016 thr, 2020 Department Water Utility Contact Lead Utility Systems Operator Type Utility System Useful Life 10 Category Water Utility System Priority n/a Total Project Cost: $150,000 Description [be proposed project provides inspection and maintenance to Well #3 aquifer and including equipment replacement of the well pump and motor, nultiple drop pipe sections, sealing of the aquifer base and redevelopment for additional production needs. Justification I Well #3 is a water supply source for the East Public Water System through Well House #2. The well was originally drilled in 2002 for an ndividual development, the aquifier was redeveloped and pump upgraded in 2007 for connection to Water Tower #3. The well motor was enlaced in 2014 from mechanical failures. Expenditures 2016 2017 2018 2019 2020 Total Utility System 150,000 150,000 Total Funding Sources 2016 150,000 2017 2018 2019 2020 150,000 Total 601 - Water Utility Fund 150,000 150,000 Total 150,000 150,000 Monday, October 19, 2015 2016 thr, 2020 Capital Improvement Plan City of Otsego, Minnesota Project# 601-2020-02 Project Name Well Rehabilitation (#1,2,5,6) Description 'ump and aquifer rehab schedule as follows: Department Water Utility Contact Lead Utility Systems Operator Type Utility System Useful Life Category Water Utility System Priority n/a Total Project Cost: $360,000 k) 2020 - scheduled maintenance of Well #2 - former project # UTIL-12-021- $70,000 3) 2020 - scheduled maintenance of Well #1 - former project # UTIL-12-022 - $70,000 2020 - scheduled maintenance of Well #5 - former project # UTIL-12-023 - $120,000 �) 2020 -scheduled maintenance of Well #6 - former project # UTIL-12-026 - $100,000 Justification k) Well #2 (School Knoll Park) has scheduled maintenance intervals of 15 years that includes service and repair of equipment and rehabilitation )f the aquifer. The project is required to maintain efficient operation of Well #2 as part of the City's water system. 3) Well #1 (Otsego Elementary) has scheduled maintenance intervals of 15 years that include service and repair of equipment and rehabilitation of he aquifer. The project is required to maintain efficient operation of Well #1 as part of the City's water system. ) Well #5 (West WWTF) has scheduled maintenance intervals of 15 years that include service and repair of equipment and rehabilitation of the tquifer. The project is required to maintain efficient operation of Well #5 as part of the City's water system. )) Well #6 (School Knoll Park) has scheduled maintenance intervals of 15 years that include service and repair of mechanical equipment and ehabilitation of the aquifer. The project is required to maintain efficient operation of Well #6 as part of the City's water system. gust 2012 - project dates changed as follows based on use: Item A) moved from 2015 to 2020 Item B) moved from 2015 to 2020 Item C) moved from 2015 to 2020 Item Dl moved from 2016 to 2020 Expenditures 2016 2017 2018 2019 2020 Total Utility System 360,000 360,000 Total Funding Sources 2016 360,000 2017 2018 2019 2020 360,000 Total 601 - Water Utility Fund 360,000 360,000 Total 360,000 360,000 Monday, October 19, 2015 Capital Improvement Plan City of Otsego, Minnesota Project # FLEET-16-01 Project Name Ford F250 Extended + Plow Description 'W#18 - Chevy 1/2 ton extended cab with 3/4 ton Ford extended cab. 2016 thr, 2020 Department Fleet Contact Lead Utility Systems Operator Type Vehicles Useful Life 10 Category Vehicles Priority n/a Total Project Cost: $35,000 Justification 1W#18 is a 2005 Chevy extended -cab 4x4 with a rating of 16 out of 17. Vehicle mileage as of July 2015 is 81,719 with concerning oil :onsumption. Staff recommends replacement of the vehicle with a 3/4 ton Ford extended Cab 4x4 w/plow package. The anticipated trade in 7alue of the 2005 vehicle is approximately $5000 for a total 3/4 ton purchase price of $35,000. Expenditures 2016 2017 2018 2019 2020 Total Vehicles 35,000 35,000 Total 35,000 35,000 Funding Sources 2016 2017 2018 2019 2020 Total 601 - Water Utility Fund 8,750 8,750 602 - Sanitary Sewer Utility 26,250 26,250 Fund Total 35,000 35,000 Monday, October 19, 2015 City of Otsego Water Utility Fund Cash Flow Summary Revised: October 16, 2015 Ratelncrease 2.50% 2.50% 2.50% 0.00% 0.00% 0.00% 0.00% 0.00% Base Charge $ 8.00 $ 8.20 $ 8.41 $ 8.62 $ 8.62 $ 8.62 $ 8.62 $ 8.62 $ 8.62 Consumption Charge (0-10) $ 1.60 $ 1.54 $ 1.58 $ 1.62 $ 1.62 $ 1.62 $ 1.62 $ 1.62 $ 1.62 Consumption Charge (10+) $ 1.60 $ 1.64 $ 1.68 $ 1.72 $ 1.72 $ 1.72 $ 1.72 $ 1.72 $ 1.72 Actual Actual Actual Projected Projected Projected Projected Projected Projected 2012 2013 2014 2015 2016 2017 2018 2019 2020 Comments Operating Revenues Water Sales $ 838,013 $ 862,413 $ 883,966 $ 916,000 $ 916,000 $ 916,000 $ 916,000 $ 916,000 $ 916,000 2015 Budget was $1,052,000 Water Sales - Irrigation - 139,419 106,747 75,000 90,000 90,000 90,000 90,000 90,000 Conservative Increase in 2016 Penalties and Interest - 30,047 35,281 35,000 30,000 30,000 30,000 30,000 30,000 Small Decrease in 2016 to be more Conservative. Other (85) 43 (565) Subtotal 837,928 1,031,922 1,025,429 1,026,000 1,036,000 1,036,000 1,036,000 1,036,000 1,036,000 Nonoperating Revenues Antenna Leases 55,168 64,050 52,538 60,000 66,000 66,000 66,000 66,000 66,000 2016 Projection - Then Flat Water Meter Sales 57,219 70,313 70,056 68,000 85,000 85,000 85,000 85,000 85,000 200 Meters @ $425. Special Assessments 91,316 76,319 1,617 - - - - - - Investment Interest (Net) 17,226 (8,393) 42,919 - - - - - - Other 7,766 34,335 88,366 18,600 19,080 19,080 19,080 19,080 19,080 Total 1,066,623 1,268,546 1,280,925 1,172,600 1,206,080 1,206,080 1,206,080 1,206,080 1,206,080 Expenses Personal Servcies 59,334 98,936 38,046 67,361 71,799 73,235 74,700 76,194 77,718 2016 Prelim Budget- Then 2 % Inflation Supplies 60,744 130,951 138,484 150,563 194,058 197,939 201,898 205,936 210,055 2016 Prelim Budget- Then 2 % Inflation Services & Other Charges 283,621 201,754 204,265 175,668 204,320 208,406 212,575 216,826 221,163 2016 Prelim Budget- Then 2 % Inflation Depreciation 473,379 475,224 472,761 502,200 510,000 510,000 510,000 510,000 510,000 2016 Projection - Then Flat Capital Outlay 8,550 24,519 18,055 - - - - - - Capital Outlay (CIP) - - - - 437,350 - 689,585 250,000 510,000 Based on Draft 2016 CIP Nonoperating - - - - - - - - - Transfers Out - - 52,889 56,638 33,439 40,000 40,000 40,000 40,000 Transfer to General Fund for staff reimbursement. Transfers Out - Jet Vac 9,800 30,800 10,000 9,800 9,600 8,200 Transfer to Debt Fund 399 for Jet Vac Total 895,428 931,384 924,500 983,230 1,460,966 1,039,381 1,738,357 1,307,156 1,568,935 Cash Balance - Beginning 1,166,092 1,823,474 2,539,591 3,327,541 4,019,111 4,274,225 4,950,924 4,928,647 5,337,572 Balance Sheet Effects 12,808 (96,269) (41,236) Revenues 1,066,623 1,268,546 1,280,925 1,172,600 1,206,080 1,206,080 1,206,080 1,206,080 1,206,080 Expenditures (895,428) (931,384) (924,500) (983,230) (1,460,966) (1,039,381) (1,738,357) (1,307,156) (1,568,935) Noncash - Depreciation 473,379 475,224 472,761 502,200 510,000 510,000 510,000 510,000 510,000 Cash Balance - Ending $ 1,823,474 $ 2,539,591 $ 3,327,541 $ 4,019,111 $ 4,274,225 $ 4,950,924 $ 4,928,647 $ 5,337,572 $ 5,484,717 Current Cash = $3,904,716 Water Utility 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 2012 2013 2014 2015 2016 2017 2018 2019 2020 Expenses ll� Operating Revenues tCash Balance - Ending City of Otsego Water Access Charge Fund 4Cash Flaw Summary Y YTD Revised: October 16, 2015 $ 31.7,334 Rate Increase 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Availability Charge $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 Connection Charge $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 $ 1,581.00 Estimated Hookups 150 110 120 130 145 150 160 170 170 170 170 170 170 170 Actual Actual Actual Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 Revenues WAC Fee $ 445,681 $ 365,555 $ 718,023 $ 474,300 $ 347,820 $ 379,440 $ 411,060 $ 458,490 $ 474,300 $ 505,920 $ 537,540 $ 537,540 $ 537,540 $ 537,540 $ 537,540 $ 537,540 $ 537,540 Special Assessments 8,885 122,795 32,538 49,935 33,013 30,305 10,176 9,780 - - - - - - - - - Investmentlnterest(Net) 42,691 (9,006) 43,905 - - - - - - - - - - - - - - Miscellaneous - - - - - - - - - - - - - - - - - Total 497,257 479,344 794,466 524,235 380,833 409,745 421,236 488,270 474,300 505,920 537,540 537,540 537,540 537,540 537,540 537,540 537,540 Expenses Debt Service - Principal 2,397,600 - - - - - - - - - - - - - - - - DebtService- Interest 424,914 334,158 334,002 - - - - - - - - - - - - - - Debt Principal (2009A) - - - - - - - - - - - - 270,000 567,000 588,600 864,000 - Debt Interest (2009A) - - - 93,820 93,820 93,820 93,820 93,820 93,820 93,820 93,820 93,820 93,820 83,020 59,773 35,640 - Debt Principal (2010C) - - - - 720,000 732,600 766,800 799,200 840,600 867,600 918,000 954,000 559,800 250,200 259,200 - - Debt Interest (2010C) - - - 268,300 268,300 253,980 224,676 194,004 162,036 136,818 93,438 65,439 35,388 17,195 8,813 - - Transfers Out Total 2,822,514 334,158 334,002 362,120 1,082,120 1,080,400 1,085,296 1,087,024 1,096,456 1,098,236 1,105,258 1,113,259 959,008 917,415 916,386 899,640 Cash Balance - Beginning 4,386,071 1,788,466 2,023,278 2,877,491 3,039,606 2,338,319 1,667,664 1,003,604 384,850 (237,306) (829,624) (1,397,342) (1,973,061) (2,394,529) (2,774,404) (3,153,250) (3,515,350) Balance Sheet Effects (272,348) 89,626 393,749 Revenues 497,257 479,344 794,466 524,235 380,833 409,745 421,236 468,270 474,300 505,920 537,540 537,540 537,540 537,540 537,540 537,540 537,540 Expenditures (2,822,514) (334,158) (334,002) (362,120) (1,082,120) (1,080,400) (1,085,296) (1,087,024) (1,096,456) (1,098,238) (1,105,258) (1,113,259) (959,008) (917,415) (916,386) (899,640) Cash Balance - Ending $ 1,788,466 $ 2,023,278 $ 2,877,491 $ 3,039,606 $ 2,338,319 $ 1,667,664 $ 1,003,604 $ 384,850 $ (237,306) $ (829,624) $ (1,397,342) $ (1,973,061) $ (2,394,529) $ (2,774,404) $ (3,153,250) $ (3,515,350) $ (2,977,810) Bonds Payable $ 9,957,600 $ 9,957,600 $ 9,957,600 $ 9,957,600 $ 9,237,600 $ 8,505,000 $ 7,738,200 $ 6,939,000 $ 6,098,400 $ 5,230,800 $ 4,312,800 $ 3,358,800 $ 2,529,000 $ 1,711,800 $ 864,000 $ - $ - Water Access Charges Fund $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 2012 2013. 2014 2015 2016 2017 2018 2019 2020 2022 2023 2024 2025 2026 2027 2028.. $(2,000,000) $(4,000,000) $(6,000,000) Bonds Payable -*--Cash Balance - Ending