|
Exhibit 1.00
<br />Estimated Monthly Cash Flow Schedule
<br />City of Gem Lake
<br />Cash Flow Before Issuance of Certificates (General Fund) 1, 2 and 3
<br />Estimated Receipts
<br />Estimated Disbursements
<br />Certificate Earnings on
<br />Total
<br />Certificate
<br />Total
<br />Beginning
<br />Ending
<br />Mo \ Year
<br />Balance
<br />Other Proceeds Proceeds
<br />Receipts
<br />Other Pa ments
<br />Disbursmts.
<br />Balance
<br />1 \ 2007
<br />$73,120
<br />$16,555 $0 $0
<br />$16,555
<br />$31,024 $0
<br />$31,024
<br />$58,651
<br />2 \ 2007
<br />58,651
<br />9,246 0 0
<br />9,246
<br />63,934 0
<br />63,934
<br />3,963
<br />3 \ 2007
<br />3,963
<br />4,773 0 0
<br />4,773
<br />43,506 0
<br />43,506
<br />(34,770)
<br />4 \ 2007
<br />(34,770)
<br />11,372 0 0
<br />11,372
<br />40,340 0
<br />40,340
<br />(63,738)
<br />5 \ 2007
<br />(63,738)
<br />1,871 0 0
<br />1,871
<br />57,523 0
<br />57,523
<br />(119,390)
<br />6 \ 2007
<br />(119,390)
<br />111,162 0 0
<br />111,162
<br />43,356 0
<br />43,356
<br />(51,584)
<br />7 \ 2007
<br />(51,584)
<br />70,108 0 0
<br />70,108
<br />41,904 0
<br />41,904
<br />(23,380)
<br />8 \ 2007
<br />(23,380)
<br />1,726 0 0
<br />1,726
<br />82,582 0
<br />82,582
<br />(104,236)
<br />9 \ 2007
<br />(104,236)
<br />35,750 0 0
<br />35,750
<br />41,581 0
<br />41,581
<br />(110,067)
<br />10 \ 2007
<br />(110,067)
<br />4,209 0 0
<br />4,209
<br />41,675 0
<br />41,675
<br />(147,533)
<br />11 \ 2007
<br />(147,533)
<br />80,104 0 0
<br />80,104
<br />35,192 0
<br />35,192
<br />(102,621)
<br />12 \ 2007
<br />102,621
<br />33,915 0 0
<br />33.915
<br />35,000 0
<br />35,000
<br />103.706
<br />Fiscal Year Totals
<br />$380,791 $0 $0
<br />$380,791
<br />$557,617 $0
<br />$557,617
<br />Exhibit 2.00
<br />Estimated Monthly Cash Flow Schedule
<br />City of Gem Lake
<br />Cash Flow After Issuance of Certificates (General Fund) 1, 2 and 3
<br />Certificate Amount: $155,000 Est. Investment Interest Rate: 5.50% Est. Borrowing Rate: 3.75%
<br />Estimated Receipts
<br />Estimated Disbursements
<br />Certificate
<br />Earnings on
<br />Total
<br />Certificate
<br />Total
<br />Beginning
<br />Ending
<br />Mo\
<br />Year
<br />Balance
<br />Other
<br />Proceeds
<br />Proceeds
<br />Receipts
<br />Other
<br />Payments
<br />Disbursmts.
<br />Balance
<br />1 \
<br />2007
<br />$73,120
<br />$16,555
<br />$0
<br />$0
<br />$16,555
<br />$31,024
<br />$0
<br />$31,024
<br />$58,651
<br />2 \
<br />2007
<br />58,651
<br />9,246
<br />145,000
<br />269
<br />154,515
<br />63,934
<br />0
<br />63,934
<br />149,232
<br />3 \
<br />2007
<br />149,232
<br />4,773
<br />0
<br />665
<br />5,438
<br />43,506
<br />0
<br />43,506
<br />111,163
<br />4 \
<br />2007
<br />111,163
<br />11,372
<br />0
<br />509
<br />11,881
<br />40,340
<br />0
<br />40,340
<br />82,705
<br />5 \
<br />2007
<br />82,705
<br />1,871
<br />0
<br />379
<br />2,250
<br />57,523
<br />0
<br />57,523
<br />27,432
<br />6 \
<br />2007
<br />27,432
<br />111,162
<br />0
<br />126
<br />111,288
<br />43,356
<br />0
<br />43,356
<br />95,364
<br />7 \
<br />2007
<br />95,364
<br />70,108
<br />0
<br />437
<br />70,545
<br />41,904
<br />0
<br />41,904
<br />124,005
<br />8 \
<br />2007
<br />124,005
<br />1,726
<br />0
<br />568
<br />2,294
<br />82,582
<br />0
<br />82,582
<br />43,717
<br />9 \
<br />2007
<br />43,717
<br />35,750
<br />0
<br />200
<br />35,950
<br />41,581
<br />0
<br />41,581
<br />38,087
<br />10 \
<br />2007
<br />38,087
<br />4,209
<br />0
<br />175
<br />4,384
<br />41,675
<br />0
<br />41,675
<br />795
<br />11 \
<br />2007
<br />795
<br />80,104
<br />0
<br />4
<br />80,108
<br />35,192
<br />0
<br />35,192
<br />45,711
<br />12 \
<br />2007
<br />45,711
<br />33,915
<br />0
<br />210
<br />34.125
<br />35,000
<br />0
<br />35,000
<br />44.835
<br />Fiscal Year Totals
<br />$380,791
<br />$145,000
<br />$3,541
<br />$529,332
<br />$557,617
<br />$0
<br />$557,617
<br />IS�EHLERS
<br />8 ASSOCIATES INC
<br />Prepared by: Ehlers & Associates, Inc,
<br />Preliminary: For Discussion Purposes ONLY 12/8/2006
<br />
|