|
copy of Storm Forecast 091310.xls
<br />Stormwater Operating and Capital Funds (531, 535) Six-Year Financial Forecast
<br />working version September 2010
<br />Major Issues for this Fund
<br />The challenge for this fund is to secure sufficient resources to support the Stormwater Management Program while maintaining reasonable user fees. The FY10 budget included a sh
<br />$400,000 transfer to the Road Fund. The FYI 1 budget assumes a cumulative shift of $437,000 from the General Fund, a $300,000 decrease in funding for stream corridor acquisitio:
<br />Fund 131. This forecast assumes no rate increase in FYI 1, and 5.5% rate increases through the forecast period. The forecast assumes an ongoing payment to Road Fund at roughly f
<br />and Stormwater Management Team review this forecast and associated rate assumptions.
<br />unaudited
<br />Actual Actual Actual Actual Actual Actual Actual FY11
<br />FY04 FY05 FY06 FY07 FY08 FY09 FY10 Projection FY12 FY13
<br />Resources
<br />Beginning Working Capital
<br />Revenues
<br />Stormwater User Fees
<br />Other
<br />Total Resources
<br />6,862,750 6,650,372 6,659,834 7,362,972 7,707,699 7,818,116 7,091,875 7,968,960 3,281,555 2,552,997
<br />8,086,294 8,563,261 8,975,914 10,418205 10,977,586 11,492,832 12,140,818 11,695,437 12,809,000 13,513,000
<br />1,046,606 1,959,379 1,044,368 781,156 921,941 963,281 767,993 2,147,034 179,342 183,342
<br />Total Revenue 9,132,900 10,522,640 10,020,282 11,199,361 11,899,527 12,456,113 12,908,811 13,842,471 12,988,342 13,696,342
<br />15,995,650 17,173,012 16,680,116 18,562,333 19,607,226 20,274,229 20,000,687 21,811,431 16,269,897 16,249,339
<br />Requirements
<br />Expenditures
<br />Utility Operating.
<br />7,233,257
<br />.7,341,130
<br />7,379,181
<br />8,805,304
<br />9,060,833
<br />8,938,217
<br />9,423,548
<br />10,804,987
<br />11,323,800
<br />11,663,300
<br />Capital Projects Program
<br />1,530,160
<br />2,645,851
<br />1,482,043
<br />1,543,938
<br />2,147,227
<br />3,349,387
<br />1,275,879
<br />6,852,889
<br />1,480,000
<br />1,630,000
<br />Non-Dept (CSA and transfers to Road Ops)
<br />581,861
<br />526,196
<br />455,919
<br />505,392
<br />581,050
<br />894,750
<br />1,332,300
<br />872,000
<br />913,100
<br />940,100
<br />Total Expenditures
<br />9,345,278
<br />10,513,177
<br />9,317,143
<br />10,854,634
<br />11,789,110
<br />13,182,354
<br />12,031,726
<br />18,529,876
<br />13,716,900
<br />14,233,400
<br />Annual Surplus/(Deficit)
<br />" (212,378)
<br />9,463
<br />703,138 '
<br />344,727
<br />110,417
<br />(726,241)
<br />877,085
<br />(4,687,405)
<br />(728,558)
<br />(537,05
<br />Ending Fund Balance
<br />Capital Balance Available
<br />4,239,619
<br />3,863,766
<br />3,691,781
<br />3,652,861
<br />3,351,549
<br />2,933,049
<br />3,544,906
<br />-
<br />-
<br />-
<br />Operating Balance Available
<br />2,410,753
<br />2,796,069
<br />3,671,192
<br />4,054,838
<br />4,466,567
<br />4,158,826
<br />4,424,054
<br />-3,281,555
<br />2,552,997
<br />2,015,939
<br />Net Ending Fund Balance
<br />6,650,372
<br />6,659,835
<br />7,362,972
<br />7,707,699
<br />7,818,116
<br />7,091,875
<br />7,968,960.
<br />3,281,555
<br />2,552,997
<br />2,015,939
<br />Total Requirements
<br />15,995,650
<br />17,173,012
<br />16,680,116
<br />18,562,333
<br />19,607,226
<br />20,274,229
<br />20,000,687
<br />21,811,431
<br />16,269,897
<br />16,249,339
<br />perating Balance Available *
<br />1,302,376
<br />1,298,188
<br />1,292,697
<br />1,538,992
<br />1,606,980
<br />1,638,828
<br />1,792,641
<br />1,946,165
<br />2,039,483
<br />2,100,567
<br />JAmount Above or (Below) Target * 1,108,377 1,497,881 2,378,495 2,515,846 2,859,587 2,519,998 2,631,413 1,335,391 513,514 (84,628)
<br />* Operating Fund 535 only; Capital Fund 531 has no target balance available.
<br /># months Op Exp (incl CSA &p/thrus) in Op BA: 5.7 5.3 5.6 5.1 4.9 3.4 2.5 1.9
<br />Page 1 of 2
<br />
|