|
City of Sample Minnesota
<br />Water Fund
<br />Cash Flow Projections - Scenario 2 - 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 10%10%
<br />USAGE RATES 10%10%
<br />BASE FEE 10%10%
<br />METER FEE 0%3%
<br />Cash Flows from Operating Activities
<br />OVERALL % INCREASE -5.50%15.77%12.72%9.18%
<br />Receipts from customers and users 1,504,003$ 1,421,231$ 1,645,426$ 1,854,668$ 2,024,898$
<br />WAC Revenue 103,097 178,200 144,583 454,500 454,500
<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,081,769 1,208,026
<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,077
<br />Net cash from investing activities 23,910 10,922 21,335 21,081 24,077
<br />Net Increase (Decrease)
<br />in Cash and Cash Equivalents 309,293 53,437 (25,349) 299,551 5,661,688
<br />Cash and Cash Equivalents, January 1 1,770,720 2,080,013 2,133,450 2,108,101 2,407,652
<br />Cash and Cash Equivalents, December 31 2,080,013$ 2,133,450$ 2,108,101$ 2,407,652$ 8,069,340$
<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$ 787,302$ 6,140,451$
<br />Average quarterly bill (11,000 gallons)43.54$ 50.39$ 55.26$
<br />Average percentage increase 16%10%
<br />Average quarterly dollar increase 6.85$ 4.86$
<br />Average annual dollar increase 27.42$ 19.46$
<br />Five year average capital expenses 3,116,877$ 3,116,877$
<br />Actual
<br />RATE STUDY PROJECTIONS
<br />Sample
<br />26
|