|
Cash Flow Worksheet
<br />Local Agency: City of Colton
<br />All Cash and Investments (from 6/30197 audit)
<br />50,225,432
<br />Less: Restricted Cash
<br />Restricted General Fund
<br />1,732,132
<br />Special Revenue Fund
<br />4,673,672
<br />Internal Services Fund
<br />1,319,977
<br />Debt Service Fund
<br />12,293,536
<br />Trust and Agency Funds)
<br />11,179,836
<br />Enterprise Funds(s)
<br />12,362,097
<br />Other (specify) Capital Projects
<br />- 6,364,665
<br />Other (specify)
<br />Other (specify)
<br />Adjusted Available Cash (711197)
<br />= 299,517
<br />(a) Adjusted Available Cash (711197) must equal Juty, 1997 Beginning Cash Balance on 197-98 AcluaVEslimaled Cash Flow.
<br />(b) June, 1998 Ending Cash Balance must equal July, 1998 Beginning Cash Balance, H not, please explain adjustments.
<br />(c) Circle'A' for Actual or'E' /or Estimated! fgurea.
<br />1998 -99
<br />Cash FlowProjection
<br />1997 TRAN
<br />Adjusted
<br />1998-99 Cash Flows will be automatically prepared based on the 1997-98 Actual/Estimated Cash Flow, 8 the following information is provided:
<br />Beginning
<br />(+) plus
<br />(-) minus
<br />Ending
<br />Actuall (+) Amount/
<br />Ending
<br />Month
<br />Cash Balance
<br />Receipts
<br />Disbursements
<br />Cash Balance
<br />Estimated (c) (-) Pledges
<br />Cash Balance
<br />July, 1997 (a) $299,517
<br />$586,907
<br />$1,118,825
<br />($232,401)
<br />A
<br />($232,401)
<br />August, 1997
<br />(232,401)
<br />662,996
<br />1,318,815
<br />(888,220)
<br />A
<br />(888,220)
<br />September, 1997
<br />(888,220)
<br />1,187,768
<br />1,310,925
<br />(1,011,377)
<br />A
<br />(1,011,377)
<br />October, 1997
<br />(1,011,377)
<br />1,548,083
<br />1,399,091
<br />(862,385)
<br />A
<br />(862,385)
<br />November, 1997
<br />(862,385)
<br />1,521,198
<br />1,307,366
<br />(648,553)
<br />A
<br />(646,553)
<br />December_. 1997
<br />(648,553)
<br />1,998,147
<br />2,330,026
<br />(980,432)
<br />A
<br />(980,432)
<br />Decemi 1997
<br />(980,432)
<br />0
<br />0
<br />(980,432)
<br />A
<br />(980,432)
<br />January, 1998
<br />(980,432)
<br />1,371,650
<br />1,503,962
<br />(1,112,744)
<br />A
<br />(1,112,744)
<br />February, 1998
<br />(1,112,744)
<br />1,773,397
<br />1,376,465
<br />(715,812)
<br />A
<br />(715,812)
<br />March, 1998
<br />(715,812)
<br />1,530,734
<br />1,286,822
<br />(473,900)
<br />A
<br />(473,900)
<br />April, 1998
<br />(473,900)
<br />1,734,758
<br />1,318,359
<br />(57,501)
<br />E
<br />(57,501)
<br />May, 1998
<br />(57,501)
<br />1,544,272
<br />1,390,918
<br />95,853
<br />E
<br />95,853
<br />June, 1998
<br />95,853
<br />1,340,253
<br />1,636,589
<br />(200,483)
<br />E
<br />(200,483)
<br />Total
<br />$16,800,163
<br />$17,300,163
<br />1,666,165
<br />1,229,635
<br />(147,194)
<br />(a) Adjusted Available Cash (711197) must equal Juty, 1997 Beginning Cash Balance on 197-98 AcluaVEslimaled Cash Flow.
<br />(b) June, 1998 Ending Cash Balance must equal July, 1998 Beginning Cash Balance, H not, please explain adjustments.
<br />(c) Circle'A' for Actual or'E' /or Estimated! fgurea.
<br />1998 -99
<br />Cash FlowProjection
<br />1998-99 Cash Flows will be automatically prepared based on the 1997-98 Actual/Estimated Cash Flow, 8 the following information is provided:
<br />Estimated 1998-99 General Fund Receipts
<br />$16,135,876
<br />Estimated 1998-99 General Fund Disbursements
<br />$16,135,876
<br />1999 TRAN
<br />Adjusled
<br />Beginning
<br />(+) plus
<br />(-) minus
<br />Ending
<br />Pledge Factor
<br />l+) Amount/
<br />Ending
<br />Month Cash Balance
<br />Receipts
<br />Disbursements
<br />Cash Balance
<br />I% of repayment)
<br />(-) Pledges
<br />Cash Balance
<br />July, 1998 (b) ($200,483)
<br />$563,700
<br />$1,043,529
<br />($680,312)
<br />$2,040,000
<br />$1,359,688
<br />August, 1998 (660,312)
<br />636,781
<br />1,230,060
<br />(1,273,591)
<br />766,409
<br />September, 1998 (1,273,591)
<br />1,140,803
<br />1,222,701
<br />(1,355,488)
<br />684,512
<br />October, 1998 (1,355,488)
<br />1,466,871
<br />1,304,933
<br />(1,173,551)
<br />866,449
<br />November, 1998 (1,173,551)
<br />1,461,049
<br />1,219,381
<br />(931,883)
<br />1,108,117
<br />December_-_, 1998 (931,883)
<br />1,919,139
<br />2,173,217
<br />(1,185,961)
<br />854,039
<br />December=_, 1998 (1,185,961)
<br />0
<br />0
<br />(1,185,961)
<br />854,039
<br />January, 1999 (1,185,961)
<br />1,317,414
<br />1402,747
<br />(1,271,293)
<br />30%
<br />(612,000)
<br />156,707
<br />February, 1999 (1,271,293)
<br />1,703,276
<br />1,283,830
<br />(851,847)
<br />576,153
<br />March, 1999 (851,847)
<br />1,470,208
<br />1,202,085
<br />(583,724)
<br />844,276
<br />April, 1999 (583,724)
<br />1,666,165
<br />1,229,635
<br />(147,194)
<br />1,280,806
<br />May, 1999 (147,194)
<br />1,483,211
<br />1,297,310
<br />38,706
<br />70eh
<br />(1,428,000)
<br />38,706
<br />June, 1989 38,706
<br />1,287,259
<br />1,526,448
<br />(200,483)
<br />(200,483)
<br />Total
<br />$16,135,876
<br />$16,135,876
<br />(a) Adjusted Available Cash (711197) must equal Juty, 1997 Beginning Cash Balance on 197-98 AcluaVEslimaled Cash Flow.
<br />(b) June, 1998 Ending Cash Balance must equal July, 1998 Beginning Cash Balance, H not, please explain adjustments.
<br />(c) Circle'A' for Actual or'E' /or Estimated! fgurea.
<br />
|