CITY OF BURLINGTON
WATER CASH FLOW
BUDGET FOR THE YEAR 2008
Anticipated Proposed Proposed Proposed
Actual Actual Budget Actual Budget Budget Budget
2005 2006 2007 2007 2008 2009 2010
Cash Flows fromOperating Activities
Operating Income  $  #######  $        554,914  $       713,739  $        727,666  $       710,068  $      705,209  $       673,605
Adjustments to reconcile net operating income ( loss)
   to net cash provided by (Used for)operating activities
Depreciation #######       341,444      375,000       375,000      385,000     395,000      405,000
Depreciation charged to sewer department           -                   -                  -                  -                  -                   -                 -
Collection of prior year billing adjustments           -                   -                  -                  -                  -                   -                 -
Changes in operating assets and liabilities
Accounts and other receivables           -                   -                  -                  -                  -                 -                 -  
Due from other funds           -                   -                  -                  -                  -                 -                 -  
Inventories           -                   -                  -                  -                  -                 -                 -  
Accounts Payable   50,139                 -                  -                  -                  -                 -                 -  
Accrued Payroll     7,192                 -                  -                  -                  -                 -                 -  
Due to other Funds           -                   -                  -                  -                  -                 -                 -  
Compensated Absences           -                   -                  -                  -                  -                 -                 -  
Accrued Taxes #######                 -                  -                  -                  -                 -                 -  
Net Cash Provided by (used for) Operating Activities #######       896,358   1,088,739    1,102,666   1,095,068  1,100,209   1,078,605
Cash Flows from Capital and Related Financing Activities
Proceeds from borrowing           -  
Principal paid on bonds and notes #######      (190,000)     (190,000)     (190,000)     (200,000)    (205,000)    (210,000)
Principal paid on advance from municipality           -                   -                  -                  -                  -                   -                 -
Advance to other funds (Sewer debt repayment to Water)   60,000         60,000        60,000         60,000        60,000       60,000        60,000
Advance to Wastewater Dept. for Debt Service Reserve        (92,000)                -                  -                   -                 -
Repayment from Wastewater Dept. for Debt Service Reserve        92,000         92,000                -                   -                 -
Acquisition and construction of utility plant           -  
Meters           -          (70,000)       (75,000)       (75,000)       (80,000)      (80,000)        85,000
Hydrants           -            (6,169)       (10,000)         (7,000)       (10,000)      (10,000)        10,000
Aeration Covers           -            (4,200)                -                  -                  -                   -                 -
Air Conditioning at City Hall           -            (2,138)                -                  -                  -                 -                 -  
New Roof on City Hall           -            (2,593)                -                  -                  -                   -                 -
New Carpeting at City Hall           -                   -                  -                  -                  -             (675)                 -
Small Gen Set           -            (5,000)                -                  -                  -                   -                 -
Fox River Crossing           -          (86,000)                -                  -                  -                   -                 -
Well No. 11 and Reservoir           -        (466,000)  (1,600,000)  (1,600,000)                -                   -                 -
State Street Main Replacement           -        (441,000)                -                  -                  -                 -                 -  
Robert Street Main Replacement           -          (59,000)                -                  -                  -                 -                 -  
McHenry and Market Street Main Replacement           -          (52,000)                -                  -                  -                 -                 -  
Rehab Well No. 7           -          (75,000)                -                  -                  -                 -                 -  
Roof on Well No. 8           -                   -         (30,000)       (15,000)                -                 -                 -  
Service Vehicle           -                   -         (32,500)       (32,500)                -                 -                 -  
Randolph Street Main Replacement           -                   -       (269,092)     (245,821)                -                 -                 -  
Schemmer Street Main Replacement           -                   -                  -                  -       (263,000)                 -                 -
Lewis Street Main Replacement           -                   -         (71,476)       (50,000)                -                   -                 -
Dunford Drive Tank Painting           -                   -                  -                  -       (225,000)                 -                 -
Dunford Drive Advertising Revenue                 -                  -        175,000                 -                 -
Hydrant painting           -                   -         (22,000)       (22,000)       (22,000)      (10,000)                 -
Seal Coating Dunford & Well #9         (3,500)
Spare Transaucers for Reservoirs         (5,000)
Dialer Upgrade to 32 Channel         (2,500)
E. State (Main to Wis.) DOT         (7,000)      (77,000)
Dodge (Jeff. To Chest.) DOT       (14,000)    (152,000)
Sno-Blower         (2,000)
Herman Street Main Replacement     (160,000)
Page 93
Cash Flows from Capital and Related Financing Activities (Cont.)
Special Assessments #######       146,703        42,727         20,000        18,900       18,900        18,900
Interest paid on long term debt #######      (128,378)     (123,478)     (123,478)     (118,284)    (112,314)    (105,782)
Salvage           -                   -                  -                  -                  -                   -                 -
Insurance proceeds           -                   -                  -                  -                  -                   -                 -
Cost of Removal           -                   -                  -                  -                  -                   -                 -
Net Cash Used for Capital and Related Financing        
Activities     7,373   (1,472,775)  (2,228,819)  (2,188,799)     (858,384)    (568,089)    (141,882)
Cash Flows from Investing Activities
Interest Income - Sewer debt   21,600                 -          17,280                -                  -                   -                 -
Interest Income   67,945       114,628        63,146         44,872        60,000 60,000        50,000
Net Cash Provided by (Used for) Investing Activities   89,545       114,628        80,426         44,872        60,000       60,000        50,000
Net Increase (Decrease) in Cash and Cash Equivalents #######      (461,789)  (1,059,654)  (1,041,261)      296,684     592,120      986,723
Cash and Cash Equivalents - January 1 #######    3,190,359   2,728,571    2,728,571   1,687,309  1,983,993   2,576,113
Cash and Cash Equivalents - December 31  $  #######  $     2,728,571  $    1,668,917  $     1,687,309  $    1,983,993  $   2,576,113  $    3,562,836
Unrestricted Cash  $  #######  $     2,285,315  $    1,246,846    2,109,380  $    1,562,164  $   2,154,668   3,141,436
Restricted Cash - For Debt Payment #######       443,256      422,071 [1]       422,071      421,829     421,446      421,400
Total Cash and Cash Equivalents  $  #######  $     2,728,571  $    1,668,917  $     2,531,451  $    1,983,993  $   2,576,113  $    3,562,836
   
25% of Operating Expenses (net of depreciation)        298,769      262,499       292,228      292,228     300,897      316,356
Page 94
[1]
 :
From 2006 Strategic Planning Session
[2]
 :
342500 1/6th and 1/12th per month
[3]
 :
Need to account for new bonds in this portion,… check with Romenesko for new version of his spreadsheet