|
Street Light Utility Fund #603 - Working Capital
<br />Beginning Balance
<br />Utility Revenue
<br />From Utility Billings
<br />Contributions from Developers
<br />Interest Earnings 40,288.00
<br />Operating Expense
<br />(Personal Services, Supplies, Other
<br />Services & Charges)
<br />CIP Projects -Street Light Utility
<br />Sunwood Realignment
<br />Priority/Developer Street Lights
<br />(Sunwood realign booked 2x in 2013)
<br />Remaining Working Capital Balance
<br />(118,026)
<br />Act Actual Actual Actual Actual Actual Projected Projected
<br />2009 2010 2011 2012 2013 2014 2015
<br />1,091,042 1,107,885 1,167,489 1,204,373 1,228,198 1,010, 548 1,180, 207
<br />Projected Projected Projected Projected
<br />2016 2017 2018 2019
<br />1,189,910 1,191, 758
<br />172,897 179,272 178,850 178,365 200,558 187,500 175,000 175,000 175,000
<br />41,462.00 27,326.00
<br />(140,032) (144,930)
<br />19,641.10 (21,493.73)
<br />(147,533) (150,695)
<br />15,158.23 17, 703.10
<br />(143,000) (168,000)
<br />17,848.65 17,876.38
<br />(176,000) (185,000)
<br />1,184, 635 1,168,404
<br />175,000 175,000
<br />17,769.52 17,526.06
<br />(194,000) (200,000)
<br />$ (111,732)
<br />$ (78,316) $ (21,098) $ (24,362) $ (26,648) $ (134,287) $ 110,000 $ (15,000) $ (15,000) $ (15,000) $ (15,000) $ (15,000)
<br />1,107,885
<br />1,167,489 1,204,373
<br />1,228,198 1,010,548
<br />1,180,207 1,189,910
<br />*** This fund is created to offset the repairs of lights. The city currently has almost $1M of street lights (per 2013 audit
<br />which includes $388,000 of accum depr
<br />1,191,758 1,184,635
<br />1,168,404 1,145,930
<br />Page 205
<br />
|