|
<br />C-l
<br />
<br />.
<br />
<br />CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended December 31, 2006
<br />
<br /> December-06 2006
<br /> CURRENT MONTH YEAR-TO-DATE
<br /> ICASH AND TEMPORARY INVESTMENTS I
<br /> BEGINNING BALANCE $ 40,605,608.02 $ 49,665,371.16
<br /> CASH INFLOWS:
<br /> Daily Deposit 1,155,092.39 20,496,736.81
<br /> Tax Settlements 4,685,806.37 10,167,986.54
<br /> Municipal Center Proceeds held with Trust Agent 8,146,472.57
<br /> Bond Proceeds 1,011,205.97
<br /> Interest Earnings [Net ofInterest Paid on Investments] 176,679.73 1,718,436.07
<br /> NSF/Expired City Checks [More than 6 months]
<br /> TOTAL CASHINFLOW $ 6,017,578.49 $ 41,540,837.96
<br /> TOTAL CASH AVAILABLE $ 46,623,186.51 $ 91,206,209.12
<br /> CASH OUTFLOWS:
<br />. Prepaid Checks 359,389.22 $ 10,559,985.76
<br />BiBs Lists 1,232,152.58 8,463,281.04
<br /> Pay Estimates 598,804.63 22,858,720.69
<br /> Payron - Net 246,791.00 3,316,982.65
<br /> Void Checks/Donnant Checks Paid (317.61) (33,999.91)
<br /> Debt Service 1,218,949.29 3,073,821.49
<br /> Miscenaneous [Bank Charges; etc.]
<br /> TOTAL CASH OUTFLOW $ 3,655,7'69.11 $ 48,238,791.72
<br /> POOLED CASH AND TEMPORARY INVESTMENTS
<br /> ENDING BALANCE 1$ 42,967,417.40 I Is 42,967,417.40 I
<br /> MEMO - NET 2006 CASH INFLOW ( OUTFLOW) 2,361,809.38 (6,697,953.76)
<br />
<br />IINVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />
<br />Purchases
<br />Maturities/Sales.
<br />
<br />$' 38,758,926.27 $ 48,994,958.00
<br /> 5,250,000.00 23,139,000.00
<br /> (3,548,378.87) (31,673,410.60)
<br />I $ 40,460,547.40 I I $ 40;460,547.40 I
<br />
<br />ENDING BALANCE
<br />
<br />.
<br />
<br />Prepared by the City of Ramsey Finance Department
<br />01/05/2007
<br />
<br />-3-
<br />
|