|
Ref. Line R
<br />48
<br />49
<br />50
<br />51
<br />52
<br />53
<br />54
<br />55
<br />56
<br />57
<br />58
<br />59
<br />60
<br />61
<br />62
<br />63
<br />64
<br />65
<br />66
<br />67
<br />68
<br />69
<br />70
<br />71
<br />72
<br />73
<br />74
<br />Capital Expenditures
<br />Tamarack SWA Projects
<br />Private Land Projects
<br />CREP
<br />Ovid?
<br />Other
<br />Total Cap. Expend.
<br />Net Revenue Exo After Capital Exo
<br />Transfers to Reserve
<br />Summary Cash Flow
<br />Balance Beg. of Month
<br />Rev.
<br />Oper Costs
<br />Cap Exp
<br />Transf. to Reserve
<br />Balance End of Month
<br />2007 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
<br />240,000
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />120,000
<br />120,000
<br />400,000
<br />0
<br />0
<br />0
<br />0
<br />100,000
<br />100,000
<br />100,000
<br />100,000
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0-
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />640,000
<br />0
<br />0
<br />0
<br />0
<br />100,000
<br />100,000
<br />100,000
<br />100,000
<br />0
<br />0
<br />120,000
<br />120,000
<br />417,900
<br />357,900
<br />383,100
<br />386,100
<br />- 21,900 - 161,900 - 161,400 - 112,400 -1 12 4DO
<br />- 12,400
<br />- 30,400
<br />71,800 - 168,200
<br />500,000 0 0 500,000
<br />JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
<br />133,200
<br />491,100
<br />874,200
<br />760,300
<br />738,400
<br />576,500
<br />415,100
<br />302,700
<br />190,300
<br />177,900
<br />147,500
<br />219,300
<br />403,000
<br />403,000
<br />403,000
<br />3,000
<br />3,000
<br />3,000
<br />0
<br />0
<br />0
<br />0
<br />240,000
<br />0
<br />- 45,100
<br />- 19,900
<br />- 16,900
<br />- 24,900
<br />- 64,900
<br />- 64,400
<br />- 12,400
<br />- 12,400
<br />- 12,400
<br />- 30,400
<br />- 48,200
<br />- 48,200
<br />0
<br />0
<br />0
<br />0-
<br />100,000
<br />- 100,000
<br />- 100,000
<br />- 100,000
<br />0
<br />0-
<br />120,000
<br />- 120,000
<br />0
<br />0 -500,060
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />491,100
<br />874,200
<br />760,300
<br />738,400
<br />576,500
<br />415,100
<br />302,700
<br />190,300
<br />177,900
<br />147,500
<br />219,300
<br />51,100
<br />Reserve Fund
<br />28
<br />Tamarack Utilities Pumping 14 -16 wells
<br />25,35
<br />1/2 time worker for each
<br />38
<br />Private Utilities Pumping 3 -6 wells
<br />38
<br />Starting Oct Pump 6 wells
<br />39
<br />Leased Water Tam If - Private Recharge Plans
<br />51
<br />Drill 3 -4 wells
<br />Balance Beg. of Month
<br />0
<br />0
<br />0
<br />501,875
<br />503,757
<br />505,646
<br />507,542
<br />509,446
<br />511,356
<br />513,274
<br />515,198
<br />517,130
<br />Transf. in
<br />0
<br />0
<br />500;000
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />Investment Income at 4.50%
<br />19,070 0
<br />0
<br />1,875
<br />1,882
<br />1,889
<br />1,896
<br />1,903
<br />1,910
<br />1,918
<br />1,925
<br />1,932
<br />1,939
<br />Transf. Out
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />Balance End of Month
<br />0
<br />0
<br />501,875
<br />503,757
<br />505,646
<br />507,542
<br />509,446
<br />511,356
<br />513,274
<br />515,198
<br />517,130
<br />519,070
<br />Notes: Reference line # above
<br />28
<br />Tamarack Utilities Pumping 14 -16 wells
<br />25,35
<br />1/2 time worker for each
<br />38
<br />Private Utilities Pumping 3 -6 wells
<br />38
<br />Starting Oct Pump 6 wells
<br />39
<br />Leased Water Tam If - Private Recharge Plans
<br />51
<br />Drill 3 -4 wells
<br />66,71
<br />Assume $500 k per year, four years, $2 M total
<br />67 Proof of end cash bal 51,100
<br />
|