Laserfiche WebLink
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 />