|
<br />~Ol
<br />
<br />CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended May 31,2010
<br />
<br /> May-l0 2010
<br /> CURRENT MONTH YEAR-TO-DATE
<br />ICASH AND TEMPORARY INVESTMENTS I
<br />BEGINNING BALANCE $ 42,664,616.55 $ 46,312,884.11
<br />CASH INFLOWS:
<br />Daily Deposit 147,774.52 2,569,400.93
<br />Tax Settlements 111,377.11
<br />U/B Receipts 517,487.42 1,333,297.24
<br />Bond Proceeds
<br />Interest Earnings [Net ofInterest Paid on Investments] 82,035.58 366,015.33
<br />NSF/Expired City Checks [More than 6 months]
<br />TOTAL CASH INFLOW $ 747,297.52 $ 4,380,090.61
<br />TOTAL CASH AVAILABLE $ 43,411,914.07 $ 50,692,974.72
<br />CASH OUTFLOWS:
<br />Prepaid Checks 491,280.45 $ 3,673,218.20
<br />Bills Lists 529,842.77 2,109,759.33
<br />Pay Estimates 470,245.47 1,121,466.04
<br />Payroll - Net 255,042.45 1,520,166.30
<br />Flex Reimbursement 7,585.08 47,655.83
<br />Void Checks/Dormant Checks Paid (2,526.33)
<br />Debt Service 565,317.50
<br />Miscellaneous [Bank Charges; etc.]
<br />TOTAL CASH OUTFLOW $ 1,753,996.22 $ 9,035,056.87
<br />POOLED CASH AND TEMPORARY INVESTMENTS
<br />ENDING BALANCE 1 $ 41,657,917.851 I $ 41,657,917.851
<br />MEMO - NET 2010 CASH INFLOW ( OUTFLOW) (1,006,698.70) (4,654,966.26)
<br />
<br />~INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE $ 41,502,700.30 $ 42,964,161.67
<br />Purchases 21,440.63 5,506,440.63
<br />Maturities/Sales (2,399,697.90) (9,346,159.27)
<br />ENDING BALANCE 1$ 39,124,443.03 I 1$ 39,124,443.03 1
<br />
<br />Prepared by the City of Ramsey Finance Department
<br />6/11/2010
<br />
|