|
<br />C,- \
<br />
<br />CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended May 31, 2007
<br />
<br /> May-07 2007
<br /> CURRENT MONTH YEAR-TO-DATE
<br />ICASH AND TEMPORARY INVESTMENTS I
<br />BEGINNING BALANCE $ 43,321,662.58 $ 42,982,917.84
<br />CASH INFLOWS:
<br />Daily Deposit 520,934.74 3,577,796.80
<br />Tax Settlements 94,501.17
<br />Municipal Center Proceeds held with Trust Agent 252,490.88 3,626,983.08
<br />Bond Proceeds 1,703,575.55
<br />Interest Earnings [Net of Interest Paid on Investments] 141,192.04 654,991.71
<br />NSF/Expired City Checks [More than 6 months]
<br />TOTAL CASH INFLOW $ 914,617.66 $, 9,657,848.31
<br />TOTAL CASH AVAILABLE $ 44,236,280.24 $ 52,640,766.15
<br />CASH OUTFLOWS:
<br />Prepaid Checks 520,256.88 $ 2,945,781.36
<br />Bills Lists 386,289.79 2,369,793.09
<br />Pay Estimates 105,794.70 1,428,506.17
<br />Payroll - Net 391,165.90 1,500,501.89
<br />Void CheckslDormant Checks IPaid (125.00) (21,528.66)
<br />Debt Service 180,465.00 1,765,279.33
<br />Miscellaneous [Bank Charges;! etc.] 58.50 58.50
<br /> !
<br />TOTAL CASH OUTFLOW $ 1,583,905.77 $ 9,988,391.68
<br />POOLED CASH AND TEMPORARY INVESTMENTS
<br />ENDING BALANCE I I $ 42,652,374.47 I I $ 42,652,374.471
<br /> I
<br /> i
<br /> I
<br />MEMO - NET 2007 CASH ~OW (OUTFLOW) (669,288.11) (330,543.37)
<br />
<br />IINVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE $ 41,773,477.60 $ 40,468,547.40
<br />Purchases 500,000.00 12,357,244.44
<br />Maturities/Sales (1,263,397.23) (11,815,711.47)
<br />ENDING BALANCE 1$ 41,010,080.37 I I $ 41,010,080.37 I
<br />
<br />Prepared by the City of Ramsey Finance Department
<br />06/05/2007
<br />
<br />-3-
<br />
|