City of Medina Attachment H
<br /> Water Capital Improvement Fund Cash Flow 0402
<br /> Assumptions:
<br /> 1 Other revenue increase 2.00% 2.130% 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% 2.00%
<br /> 2 Other expense increase 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.001/6 3.00%
<br /> 3 Investment Rate 3.00% 3.00% .3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00%
<br /> 4
<br /> 5
<br /> 6 Actual Projected
<br /> 7 Cash Flow Statement 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020
<br /> 8
<br /> 9 Connect/Reconnect fees 374,498 319,140 342,268 1,417,833 1,394,540 897,755 574,091 275,564 319,929 192,850 433,914 103,098 111,346 120,253 129,874 140,264
<br /> 10 Miscellaneous 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
<br /> 11 Special Assessments 42468 28,_57 28_,557 9.563 0
<br /> 12 Total Revenue 416,966 347,697 370,825 1,427,396 1,394,540 897,755 574,091 275,564 319,929 192,850 433,914 103,098 111,346 120,253 129,874 140,264
<br /> 13
<br /> 14 Current Expenditures 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
<br /> 15 Capital Outlay-paid with cash 94,731 0 0 0 674,918 0 0 0 0 621,141 0 0 0 0 0 0
<br /> 16 Total Capital Improvements 94,731 0 0 0 674,918 9 0 0 0 621,141 0 0 0 0 0 0
<br /> 17
<br /> 18 Investment Income 7,994 21,466 18,055 24,780 55,234 65,363 81,139 87,681 85,473 84,541 55,152 56,769 45,479 34,137 22,711 11,229
<br /> 19 Transfers In
<br /> 20 Transfers Out-Debt Service Series 2005A - (482,870) (164,686) (165,164) (165,348) (165,388) (165,270) (164,992) (164,570) (164,002) (163,290) (164,310) (162,989) (163,369) (163,442) (163,200)
<br /> 21 Transfers Out-Debt Service Series 2007 (271,878) (271,878) (271,878) (271,878) (271,878) (271,878) (271,878) (271,878) (271,878) (271,878) (271,878) (271,878) (271,878)
<br /> 22 Transfers Out-Debt Service Series 2015 (100,019) (100,019) (100,019) (100,019) (100,019)
<br /> 23 Annual Net Cash Flow 330,229 (113,707) 224,193 1,015,134 337,630 525,853 218,083 (73,625) (31,045) (979,629) 53,899 (376,339) (378,060) (380,875) (382,753) (383,605)
<br /> 24
<br /> 25 Beginning Cash Balance 355,298 715,527 601,820 826,013 1,841,148 2,178,778 2,704,631 2,922,714 2,849,089 2,818,044 1,838,415 1,892,314 1,515,975 1,137,914 757,039 374,286
<br /> 26 Ending Cash'Balanu 715,527 001,820 8260138 1,841,148 2 178,776 2J%G31 4922714 J 2,849,009 2,818,044 1838,415 1,04314 1,515,975 1,137,914" 757,039 %374,386 (9.319
<br /> 27
<br /> 28
<br /> 29 Connection Charge 3,580 3,940 4,689 5,064 5,469 5,906 6,379 6,889 7,440 8,035 8,678 9,373 Assumes 6%annual increases in 2017 and after
<br />
|