CITY OF BURLINGTON
WASTEWATER 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  $  #######  $     1,273,858  $     1,215,562  $     1,052,058  $     1,126,910  $     1,140,142  $       1,286,909
Adjustments to reconcile net operating income ( loss)
   to net cash provided by (Used for)operating activities
Depreciation[1]           -      1,068,790    1,296,588    1,296,588    1,148,200    1,185,740      1,230,729
Changes in operating assets and liabilities
Accounts and other receivables           -                  -                  -                  -                   -                     -                    -
Due from other funds           -                  -                  -                  -                   -                     -                    -
Accounts Payable   67,186                -                  -                  -                   -                     -                    -
Accrued Payroll   13,725                -                  -                  -                   -                     -                    -
Deferred revenue     3,000                -                  -                  -                   -                     -                    -
Compensated Absences           -                  -                  -                  -                   -                     -                    -
Net Cash Provided by (used for) Operating Activities #######    2,342,647    2,512,150    2,348,646    2,275,110    2,325,882      2,517,638
Cash Flows from Capital and Related Financing Activities
Proceeds from borrowing[2]           -                  -      3,411,261    1,631,486    4,388,600 [3]       255,564                    -
Principal paid on Existing Debt Service (CWF)                -    (1,255,804)  (1,255,804)   (1,255,111)   (1,254,394)    (1,253,651)
Principal paid on Existing Debt Service (G.O.)                -       (185,000)     (185,000)      (205,000)      (230,000)       (225,000)
Principal Proposed (2007 CWF #1)                -                  -                  -          (21,636)        (22,172)         (22,720)
Principal Proposed (2007 CWF #2) #######                -                  -                  -          (20,038)        (20,534)         (21,042)
Principal Proposed (2007 CWF#3)           -                  -                  -                  -                   -        (164,657)       (169,035)
Advances to Other Funds (1)  (60,000)       (60,000)       (60,000)       (60,000)        (60,000)        (60,000)         (60,000)
Advance from Water Dept. for Debt Service Reserve         92,000                -                   -                     -                    -
Repayment to Water Dept. for. Debt Service Reserve                -         (92,000)       (92,000)                 -                     -                    -
Acquisition and construction of utility plant
Facilities Plan  (36,000)       (27,800)                -                  -                   -                     -                    -
Grit System Upgrade  (75,234)       (75,234)                -                  -                   -                     -                    -
Vehicle            -         (16,500)                -                  -                   -                     -                    -
Utility Cart           -           (6,785)                -                  -                   -                     -                    -
Phase I Design of Plant Addition           -                  -       (110,000)     (110,000)                 -                     -                    -
McHenry Street Main Replacement           -         (59,261)                -                  -                   -                   -                    -  
State Street Main Replacement           -       (628,000)                -                  -                   -                   -                    -  
Robert Street Main Replacement           -           (5,000)                -                  -                   -                   -                    -  
Lincoln Street Main Replacement           -       (139,600)                -                  -                   -                   -                    -  
Lewis Street Main Replacement           -                  -       (700,000)     (435,825)                 -                     -                    -
Randolph Street Main Replacement           -                  -       (167,000)       (80,000)                 -                     -                    -
Edward Street Main Replacement           -                  -                  -                  -                   -            (7,653)                    -
Maryland Avenue Main Replacement           -                  -                  -                   -  
Phase I Construction and Engineering  of Plant Addition           -                  -    (1,712,400)     (146,000)   (4,000,000)                   -                    -
Portable Trash Pump           -                  -         (23,000)       (15,000)                 -                     -                    -
Computer Upgrades           -                  -           (8,000)         (8,000)                 -                     -                    -
Pick Up Truck           -                  -                  -                  -          (28,000)                   -                    -
Jet-Vac Truck           -                  -                  -                  -                   -        (250,000)                    -
Quick View TV Stick           -                  -         (17,000)                -                   -                     -                    -
Schemmer Street                -                  -                  -          (30,000)                   -                    -
Hwy 83- Bypass                -                  -                  -        (350,000)                   -                    -
Herman Street                -                  -                  -                   -          (10,000)                    -
Storle Street                -                  -                  -                   -                     -       (110,823)
W. Chestnut/DOT                -                  -                  -                   -                     -         (25,000)
E. State/DOT                -                  -                  -            (8,600)        (93,945)                    -
Net capital contributions (Connection Fees) #######         69,659       138,000         63,000         87,000         69,000           69,000
Insurance proceeds           -                  -                  -                  -                   -                     -                    -
Interest paid on Existing Debt Service (CWF) #######     (311,676)     (273,861)     (187,431)      (148,276)      (107,713)         (65,690)
Interest paid on Existing Debt Service (G.O.)  (21,600)       (19,200)                -         (86,431)        (82,731)        (78,119)         (72,369)
Proposed (2007 CWF #1)                -                  -                  -          (13,645)        (13,109)         (12,560)
Proposed (2007 CWF #2)                -                  -                  -          (12,637)        (12,141)         (11,632)
Proposed (2007 CWF #3)           -                  -                  -                  -                   -        (106,440)       (102,061)
Net Cash Used for Capital and Related Financing
Activities #######  (1,187,397)  (1,054,804)     (967,005)   (1,760,074)   (2,106,313)    (2,082,583)
Page 87
Cash Flows from Investing Activities
Purchase of Investments           -                  -                  -                  -                   -                     -                    -
Sale of Investments           -             3,750                -                  -                   -                     -                    -
Investment Income   37,452         47,849         36,009           52,138         52,405           52,138
Net Cash Provided by (Used for) Investing Activities   37,452         51,599         36,009                -           52,138         52,405           52,138
Net Increase (Decrease) in Cash and Cash Equivalents #######    1,206,850    1,493,355    1,381,641       567,174       271,974         487,193
Cash and Cash Equivalents - January 1 #######    1,231,719    2,438,569    2,438,569    3,820,211    4,387,385      4,659,359
Cash and Cash Equivalents - December 31  $  #######  $     2,438,569  $     3,931,924    3,820,211  $     4,387,385    4,659,359      5,146,552
Restricted Cash Equivalents
Equipment Replacement Fund[4]  $  #######  $        410,134  $        430,641       430,641  $     5,058,927 $  10,204,200    16,118,290
Connection Fees[5]           -                  -                  -                  -                   -                     -                    -
Debt Service Reserve[6] #######       791,931       813,878       813,878       879,537    1,004,640         977,880
#######    1,202,065    1,244,519    1,244,519    5,938,464  11,208,840    17,096,170
Unrestricted Cash and Cash Equivalents #######    1,236,504    2,687,406    2,575,692   (1,551,079)   (6,549,481)  (11,949,618)
Unrestricted & Restricted Cash & Cash Equivalents  $  #######  $     2,438,569  $     3,931,924    3,820,211  $     4,387,385    4,659,359      5,146,552
25% of Operating Expense (net of depreciation) 470,059 476,839 490,594 490,594 520,274         522,873
(1)  This advance is a $60,000 payment each year back to Water Dept. until 2014.
Page 88
[1]
 :
Cash flow adds back in depreciation since depreciation is not a cash flow expense, but an accrual expense.
[2]
 :
Clean Water Fund loan for treatment plant expansion.  This fund provides money as the bills come in, so the borrowing (loan) is spread out over several years.  Cash flow based on Connie's WWTP  facilities study.  Also includes repayment of debt to water fund.  Capital improvement project costs- street projects 2006-2010. 
[3]
 :
4 loans = 506,650 + 772,000 + 1,000,000 +4,000,000= 6,275,650 over 07, 08, 09
[4]
 :
Why do we have this expense if we are providing regular maintenance of the system and rebuilding and adding to the system and equipment?   Is this an equipment replacement reserve required by some agreement? 
[5]
 :
Hook-up fees are included in the Wastewater Summary and then calculated on this cash flow spreadsheet as part of the Operating Income line item.
[6]
 :This is equal to the next years bond payments.

[7]
 :
1/6 upcoming interest payments and 1/12 of principal of upcoming year.

Romenesko thinks line item should be nothing.  We do not need to set aside reserve to gain balance… we have enough money.