|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended May, 2012
<br />CASH AND TEMPORARY INVESTMENTS I
<br />BEGINNING BALANCE
<br />CASH INFLOWS:
<br />May-12 2012
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 41,901,246.81 $ 45,949,302.73
<br />Daily Deposit 234,387.40 3,051,647.08
<br />Tax Settlements 89,679.38
<br />U/B Receipts 658,054.50 1,437,343.06
<br />Credit Cards 49,942,69 152,353.46
<br />Interest Earnings [Net of Interest Paid on Investments] 17,669.33 392,496.76
<br />Bond Proceeds '
<br />TOTAL CASH INFLOW $ 960,053.92 $ 5,123,519.74
<br />TOTAL CASH AVAILABLE $ 42,861,300.73 $ 51,072,822.47
<br />CASH OUTFLOWS:
<br />Prepaid Checks 520,607.69 $ 3,433,402.97
<br />Bills Lists 427,630.24. 2,520,255.35
<br />F&C Draws 435,678.63
<br />Pay Estimates 75,050.00 1,316,386.00
<br />Credit Cards 533.66 4,069.66
<br />Payroll - Net 241,305,49 1,433,512.93
<br />Flex Reimbursement 5,239,48 39,826.68
<br />Void Checks/Dormant Checks Paid (134.00) (3,859.00)
<br />Debt Service - 302,173.75
<br />Miscellaneous [Bank Charges; etc.] 109.95 417.28
<br />TOTAL CASH OUTFLOW $ 1,270,342.51 $ 9,481,864.25
<br />POOLED CASH AND TEMPORARY INVESTMENTS
<br />ENDING BALANCE I $ 41,590,958.22 I J $ 41,590,958.22
<br />MEMO - NET 2012 CASH INFLOW ( OUTFLOW) (310,288.59) (4,358,344.51)
<br />INVESTMENT PORTFOLIO SUMMARY I
<br />BEGINNING BALANCE $ 34,470,326.53 $ 42,230,022.32
<br />Purchases 9,463,000.00
<br />Maturities/Sales (52,516.79) (17,275,212.58)
<br />ENDING BALANCE
<br />34,417,809.74 I ( $ 34,417,809.74
<br />Prepared by the City of Ramsey Finance Department
<br />6/19/2012
<br />
|