Firm Aooroach to the Rate Analvsis
<br />9
<br />Position: The cash position in the Water Utility continues to increase
<br />from a level of $477,000 in 2006 to a projected $700,000 in 2012.
<br />800,000
<br />700,000
<br />600,000
<br />500,000
<br />400,000
<br />300,000
<br />200,000
<br />100,000
<br />Water Fund
<br />Cash & Investments
<br />3,000
<br />2,500
<br />2,000
<br />1,500
<br />1,000
<br />500
<br />i
<br />Springsted
<br />Position: Measured in days of operations, the Water Utility's cash
<br />balance follows a similar pattern. Operating cash went from a level of
<br />1,158 days in 2006 to a level of 2,183 days in 2010. If the activity in the
<br />Water Fund is as budgeted in 2011 and 2012, the day's cash would rise
<br />to the equivalent of 2,117 days of operations.
<br />Water Fund
<br />Days Cash
<br />2006 2007 2008 2009 2010 ' 2011 2012
<br />City of Pequot Lakes, Minnesota. Proposal to Provide a Utility Rate Analysis - Water and Sewer
<br />2006
<br />2007 2008
<br />2009
<br />2010
<br />2011
<br />2012
<br />Days Cash
<br />2006
<br />2007
<br />2008
<br />2009
<br />2010
<br />2011
<br />2012
<br />Cash and Equivalents
<br />477,282
<br />555,811
<br />585,608
<br />616,750
<br />655,386
<br />681,756
<br />702,236
<br />Operating Expenditures
<br />312,495
<br />186,655
<br />172,915
<br />159,829
<br />175,831
<br />188,287
<br />187,327
<br />Depreciation
<br />(162,030)
<br />(81,414)
<br />(65,639)
<br />(66,082)
<br />(66,267)
<br />(66,267)
<br />(66,267)
<br />Net Operating Expenditures
<br />150,465
<br />105,241
<br />107,276
<br />93,747
<br />109,564
<br />122,020
<br />121,060
<br />Days Cash
<br />1,158
<br />1,928
<br />1,992
<br />2,401
<br />2,183
<br />2,039
<br />2,117.
<br />3,000
<br />2,500
<br />2,000
<br />1,500
<br />1,000
<br />500
<br />i
<br />Springsted
<br />Position: Measured in days of operations, the Water Utility's cash
<br />balance follows a similar pattern. Operating cash went from a level of
<br />1,158 days in 2006 to a level of 2,183 days in 2010. If the activity in the
<br />Water Fund is as budgeted in 2011 and 2012, the day's cash would rise
<br />to the equivalent of 2,117 days of operations.
<br />Water Fund
<br />Days Cash
<br />2006 2007 2008 2009 2010 ' 2011 2012
<br />City of Pequot Lakes, Minnesota. Proposal to Provide a Utility Rate Analysis - Water and Sewer
<br />
|