|
City of Sample, Minnesota
<br />Water Fund
<br />Cash Flow Projections - Scenario 3 - Increase Spread Over Several Periods to Achieve Target
<br />For the Years Ending December 31, 2016 Through 2028
<br />Estimated Estimated Estimated
<br />2016 2017 2018 2019 2020
<br />PROJECTED RATE INCREASE 18%10%
<br />USAGE RATES 18%10%
<br />FIXED 18%10%
<br />Cash Flows from Operating Activities
<br />OVERALL % INCREASE -5.50%15.77%19.66%9.38%
<br />Receipts from customers and users 1,504,003$ 1,421,231$ 1,645,426$ 1,968,906$ 2,153,653$
<br />WAC Revenue 103,097 178,200 144,583 363,600 363,600
<br />Payments to suppliers (647,917) (754,263) (844,514) (869,849) (895,945)
<br />Payments to employees (287,937) (296,030) (340,524) (357,550) (375,427)
<br />Net cash from operating activities 671,246 549,138 604,972 1,105,106 1,245,881
<br />Cash Flows from Noncapital Financing Activities
<br />Advances to/from other funds 131,250 67,675 100,000 100,000 100,000
<br />Transfers to other funds (25,000) (25,000) (25,000) (25,000) (25,000)
<br />Intergovernmental grants 5,443 3,447 - - -
<br />Net cash from noncapital financing activities 111,693 46,122 75,000 75,000 75,000
<br />Cash Flows from Capital and Related Financing Activities
<br />Capital contributions 261,964 178,200 - - -
<br />Acquisitions of capital assets (53,117) (8,221) - (3,647,884) (4,360,750)
<br />Proceeds of bonds issued, net of issuance costs - - - 3,500,000 9,700,000
<br />Principal paid on long-term debt (610,000) (640,000) (660,000) (680,000) (820,617)
<br />Interest paid on long-term debt (96,403) (82,724) (66,655) (50,415) (164,048)
<br />Net cash from capital and related financing activities (497,556) (552,745) (726,655) (878,299) 4,354,586
<br />Cash Flows from Investing Activities
<br />Interest and dividends received 23,910 10,922 21,335 21,081 24,310
<br />Net cash from investing activities 23,910 10,922 21,335 21,081 24,310
<br />Net Increase (Decrease)
<br />in Cash and Cash Equivalents 309,293 53,437 (25,349) 322,888 5,699,776
<br />Cash and Cash Equivalents, January 1 1,770,720 2,080,013 2,133,450 2,108,101 2,430,990
<br />Cash and Cash Equivalents, December 31 2,080,013$ 2,133,450$ 2,108,101$ 2,430,990$ 8,130,766$
<br />Target Cash Reserve 1,247,871$ 1,319,174$ 1,344,115$ 1,620,351$ 1,928,888$
<br />Cash in Excess of Reserve 832,143$ 814,276$ 763,987$ 810,639$ 6,201,877$
<br />Average quarterly bill (11,000 gallons)43.54$ 53.58$ 58.93$
<br />Average percentage increase 23%10%
<br />Average quarterly dollar increase 10.04$ 5.36$
<br />Average annual dollar increase 40.15$ 21.43$
<br />Five year average capital expenses 3,116,877$ 3,116,877$
<br />Actual
<br />RATE STUDY PROJECTIONS
<br />Sample
<br />28
|