Laserfiche WebLink
City of Medina Attachment G <br /> Projected Cash Flow-Hamel Water System <br /> Water Operating Fund#601 Notes: 1. Full Debt service for Series 2005 Water Treatment Plant bonds and proposed Series 2007 bonds paid from Fund#601. Portion of debt service transferred in from capital fund. <br /> Portion of debt service transferred in from capital fund. <br /> Assumptions: <br /> 1 Other revenue increase 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% <br /> 2 Other expense increase 3.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% <br /> 3 Investment Rate 2.50% 2.50% 3.00% 3.50% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% <br /> 4 <br /> 5 Cash Flow Statement Approved Anticipated <br /> 6 2004 2005 2006 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 <br /> 7 Operating Revenue <br /> 8 Water sales 273,740 364,220 375,000 456,562 463,720 524,149 649,657 777,689 873,712 953,562 1,019,033 1,089,937 1,155,719 1,237,502 <br /> 9 Meter sales 19,381 20,495 25,000 25,000 25,500 26,010 26,530 27,061 27,602 28,154 28,717 29,291 29,877 30,475 <br /> 10 Penalties,Taxes and Surcharge 0 13,400 13,400 13,668 13,941 14,220 14,505 14,795 15,091 15,392 15,700 16,014 16,335 <br /> 11 Water Reconnect Fees 3 306 9 310 3.150 3 150 3313 3.277 3 343 3 410 3.478 3 547 3.618 3 691 3 765 3640 <br /> 12 Total Operating Revenue 296,427 394,025 416,550 498,112 506,101 567,378 693,750 822,664 919,587 1,000,354 1,066,760 1,138,620 1,205,375 1,288,152 <br /> 13 <br /> 14 Existing Operating Expenses(excl.depreciation) 5%Increase pus$26,000 due m new star. <br /> 15 Personal services 49,438 86,373 89,370 106,569 119,83 125,830 132,122 138,728 145,664 152,948 160,595 168,625 177,056 185,909 <br /> 16 Contractual ine.in Line 22 0 14,220 16,817 14,931 15,678 16,461 17,284 18,149 19,056 20,009 21,009 22,060 23,163 <br /> 17 Insurance Operating P-are 90% 2,345 2,983 5,175 5,175 5,434 5,705 5,991 6,290 6,605 6,935 7,282 7,646 8,028 8,430 <br /> 18 Materials and Supplies of 2006 budgeted revenue 37,988 42,000 37,800 38,323 39,690 41,675 43,758 45,946 48,243 50,656 53,188 55,848 58,640 61,572 <br /> 19 Utilities and e,yeanses,the estimated 27,575 48,404 31,500 31,500 33,075 34,729 36,465 38,288 40,203 42,213 44,324 46,540 48,867 51,310 <br /> u <br /> 20 Water Meters for resale am atmbuted m Hamel 17,898 22,500 22,500 23,625 24,806 26,047 27,349 28,716 30,152 31,660 33,243 34,905 36,650 <br /> 21 ConsukinglEngineering way '2o04am <br /> 2005 spelt-srdme <br /> 31,138 27,848 15,000 15,000 15,750 16,538 17,364 18,233 19,144 20,101 21,107 22,162 23,270 24,433 <br /> 22 Repairs and Maintenance HomingWe am 30,537 19,965 8,100 8,100 8,505 8,930 9,377 9,846 10,338 10,855 11,398 11,967 12,566 13,194 <br /> 23 Miscellaneous Independence Own. 0 10800 10.800 11340 11907 12.502 13.127 13784 14473 15.197 15.957 16754 17592 <br /> 24 Subtotal before treatment 245,471 234,465 254,783 272,188 285,798 300,088 315,092 330,847 347,389 364,758 382,996 402,146 422,253 <br /> 25 Hamel Treatment Plant Operating Costs 0 0 24,600 24,600 125,000 131,250 137,813 144,703 151,938 159,535 167,512 175,888 184,682 193,916 <br /> 261 Treatment Plant#2 operations 0 0 0 0 0 0 0 0 0 0 0 4 25,000 75,000 <br /> 26 Total Operating Expenses 0 245,471 259,065 279,383 397,188 417,048 437,900 459,795 482,785 506,924 532,270 558,884 611,828 691,169 <br /> 27 <br /> 28 Net cash flows from operating activity 296,427 148,564 157,485 218,729 108,912 150,330 255,850 362,869 436,802 493,430 534,490 579,736 593,548 596,982 <br /> 29 <br /> 30 Non-Operating Revenue <br /> 31 Investment Income 17,852 101,588 120,146 120,146 34,635 103,739 29,355 25,887 26,826 29,968 32,207 38,368 46,041 37,681 <br /> 32 Bond Proceeds 4,711,824 3,527,496 971,410 <br /> 33 Transfer in from Connection Fund for debt service Sedes 2005 482,870 482,870 164,686 165,164 165,348 165,388 165,270 164,992 164,570 164,002 163,290 164,310 <br /> 34 Transfer in from Connection Fund for debt service Series 2007 271,878 271,878 271,878 271,878 271,878 271,878 271,878 271,878 271,878 <br /> 35 Transfer in from Connection Fund for debt service Series 2015 100,019 <br /> 36 Total Non-Operating Revenue 17,852 4,813,412 603,016 603,016 3,726,817 540,781 466,581 463,153 463,973 466,838 468,654 474,247 1,452,619 573,887 <br /> 37 <br /> 38 Capital Expenses for Water System Improvements <br /> 39 Capital Improvements-Paid with Cash 25,000 0 75,000 75,000 36,400 37,856 84,365 40,945 42,583 132,858 46,058 47,900 604,908 51,809 <br /> 40 Capital Improvements-Paid with bond proceeds 980,000 2,379,520 971,410 <br /> 41 Water Treatment Plant Const. 2,154,978 3,200,000 3,200,000 <br /> 42 Debt Service for Treatment Plant-2005(100%) 500,791 500,791 412,165 413,360 413,820 413,920 413,624 412,930 411,874 410,455 408,674 411,224 <br /> 43 Debt Service for Well and Water Tower-2007(100%) 0 339,847 339,847 339,847 339,847 339,847 339,847 339,847 339,847 339,847 <br /> 44 Debt Service for Treatment Plant Expansion-2015(100%) 0 0 2 4 2 4 P. 4 0 104,018 <br /> 45 Total 25,000 2,154,878 3,775,791 3,775,791 1,428,565 3,170,583 838,032 794,712 796,054 885,636 797,778 798,202 2,324,839 902,898 <br /> 46 <br /> 47 Net cash flow after capital expenditures 289,279 2,806,988 (3,015,290) (2,954,047) 2,407,184 (2,479,472) (115.501) 31,310 104,722 74,632 205,366 255,782 (278,672) 267,971 <br /> 48 <br /> 49 Beginning Cash Balance 1 1,197866 4,004.854 4,004,854 1,050,807 3,457,971_ 978,499 862,898 894,208 998,929 1,073,562 1,278,927 1,534,709 1,256,037 <br /> Average quarter residential b81 72.60 82.04 82.04 00.25 98.66 "7011.39 108.46 `' 111.78" 117.37 123.24 129.40 135.87 r' 142.67 <br /> 2121/2007 <br />