|
<br />CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended August 31, 2007
<br />
<br />c,. \
<br />
<br /> August-07 2007
<br /> CURRENT MONTH YEAR-TO-DATE
<br />ICASH AND TEMPORARY INVESTMENTS ~
<br />BEGINNING BALANCE $ 46,461,503.01 $ 42,982,917.84
<br />CASH INFLOWS:
<br />Daily Deposit 1,045,264.11 6,358,210.09
<br />Tax Settlements 6,215,811.47
<br />Municipal Center Proceeds held with Trust Agent 222,253.23 3,849,236.31
<br />Bond Proceeds 1,703,575.55
<br />Interest Earnings [Net ofInterest Paid on Investments] 213,180.64 1,186,797.25
<br />NSF/Expired City Checks [More than 6 months]
<br />TOTAL CASH INFLOW $ 1,480,697.98 $ 19,313,630.67
<br />TOTAL CASH A V AILABLE $ 47,942,200.99 $ 62,296,548.51
<br />CASH OUTFLOWS:
<br />Prepaid Checks 843,537.69 $ 5,223,771.34
<br />Bills Lists 684,235.00 4,269,160.37
<br />Pay Estimates 596,440.75 2,728,018.71
<br />Payroll - Net 260,023.29 2,351,471.89
<br />Void Checks/Dormant Checks Paid (24,625.38)
<br />Debt Service 2,190,728.82
<br />Miscellaneous [Bank Charges; etc.] 58.50
<br />TOTAL CASH OUTFLOW $ 2,384,236.73 $ 16,738,584.25
<br />POOLED CASH AND TEMPORARY INVESTMENTS
<br />ENDING BALANCE I $ 45,557,964.26 I I $ 45,557,964.26 I
<br />MEMO - NET 2007 CASH INFLOW ( OUTFLOW) (903,538.75) 2,575,046.42
<br />
<br />IINVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE $ 44,730,871.65 $ 40,468,547.40
<br />Purchases 3,500,000.00 26,698,540.44
<br />Maturities/Sales (4,373,723.86) (23,309,940.05)
<br />ENDING BALANCE 1$ 43,857,147.79 I I $ 43,857,147.79 ,
<br />
<br />Prepared by the City of Ramsey Finance Department
<br />09/04/2007
<br />
<br />-3-
<br />
|