City of Pleasanton Water Rate Study
<br />2. Revenue Requirement Projection
<br />Revenue Requirements
<br />Zone 7 Purchased Water
<br />Pleasanton
<br />O &M
<br />Capital
<br />Subtotal
<br />Total Revenue Requirements
<br />Annual change
<br />Rate Revenue
<br />From FY 2009 -10 Rates
<br />From Rate Increases
<br />Total Rate Revenue
<br />Annual change
<br />Annual Surplus or Deficit
<br />Operating Fund Balance
<br />Annual change
<br />March 18, 2010
<br />Figure 2 -1. Financial Trends
<br />Actual Actual Actual Budgeted Projected
<br />2005-06 2006-07 2007.08 2005-09 2009-10
<br />54,154.360
<br />52,335.140
<br />56,489,500
<br />515,140,634
<br />$4.522.759
<br />$2.323,173
<br />56,845,932
<br />516,834,727
<br />11.2%
<br />$91,622 (5628.102)
<br />Source: Rev Reqmt 15Mar10.xls, 2- Revenue Requirements.
<br />Figure 2 -2. Zone 7 Projected Rate Increases
<br />CY 2010
<br />CY 2011
<br />CY 2012
<br />CY 2013
<br />CY 2014
<br />CY 2015
<br />8.25%
<br />8.25%
<br />8.25%
<br />7.25%
<br />6.00%
<br />6.50%
<br />Projected
<br />2010-11
<br />58,651.134 59.988,795 $10.987,367 510.711.032 $12.192.455 $13.354,041
<br />$4,481,933 $4,885,221 $5.326,805 14,564,522
<br />$2.335.090 52.322,059 $1.600.000 51.600.000
<br />$6,817,023 $7,207,280 56,926,805 56,164,522
<br />$17,804,390 517,918,312 519,119,260 319,518,663
<br />5.8% 0.6% 6.7% 2.1%
<br />316.360.445 316,550,936
<br />30 $3.368,005
<br />515,232,256 $16,206,625 516,402,888 515,692,363 516,360,445 $19,918,941
<br />6.4% 1.2% -4.3% 4.3% 21.8%
<br />(51,401.502) (.2,225949) (52.758815) $400.379
<br />310,775,777 $11,002,186 $10,124,734 58,356,607 35,674,921 35,407,348
<br />2.1% -8.0% -17.5% 32.1 -4.7%
<br />Change From Change From
<br />2005.06 To 2005-06 To
<br />2009-10 2010 -11
<br />41% 54%
<br />28% 10%
<br />-31% -31%
<br />7% -5%
<br />26% 29%
<br />7%
<br />-47%
<br />31%
<br />-50%
<br />Page 10 HF&H Consultants, LLC
<br />
|