|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended July, 2012
<br />July-12 2012
<br />CURRENT MONTH YEAR-TO-DATE
<br />CASH AND TEMPORARY INVESTMENTS I
<br />BEGINNING BALANCE $ 41,165,564.29 $ 45,949,302.73
<br />CASH INFLOWS:
<br />Daily Deposit 631,217.52 4,163,618.67
<br />Tax Settlements 2,901,718.04 6,271,397.42
<br />UB Receipts 30,493.95 1,525,429.41
<br />Credit Cards 14,195.96 195,413.84
<br />Interest Earnings [Net of Interest Paid on Investments] 73,371.00 557,586.75
<br />Bond Proceeds 12,137.35
<br />TOTAL CASH INFLOW $ 3,650,996.47 $ 12,725,583.44
<br />TOTAL CASH AVAILABLE $ 44,816,560.76 $ 58,674,886.17
<br />CASH OUTFLOWS:
<br />Prepaid Checks
<br />Bills Lists
<br />F&C Draws
<br />Ramsey Rail - Northstar
<br />Pay Estimates
<br />Credit Cards
<br />Payroll - Net
<br />Flex Reimbursement
<br />Void Checks/Dormant Checks Paid
<br />Debt Service
<br />Miscellaneous [Bank Charges; etc.]
<br />TOTAL CASH OUTFLOW
<br />POOLED CASH AND TEMPORARY INVESTMENTS
<br />ENDING BALANCE
<br />MEMO - NET 2012 CASH INFLOW ( OUTFLOW)
<br />INVESTMENT PORTFOLIO SUMMARY I
<br />1,190,764.07 $ 3,790,215.72
<br />423,417.24 3,644,743.81
<br />122,651.74 781,853.68
<br />3,562,500.00
<br />251,466.52 1,939,799.82
<br />1,012.44 6,700.59
<br />277,618.83 1,965,929.46
<br />5,280.73 53,037.53
<br />(716.48) (7,035.44)
<br />112,083.33 503,663.33
<br />85.25 580.58
<br />$ 2,383,663.67 $ 16,241,989.08
<br />$ 42,432,897.09 I I $ 42,432,897.09 I
<br />1,267,332.80 (3,516,405.64)
<br />BEGINNING BALANCE $ 33,839,661.44 $ 42,230,022.32
<br />Purchases 900,000.00 10,888,000.00
<br />Maturities/Sales (2,287,667.36) (20,666,028.24)
<br />ENDING BALANCE I $ 32,451,994.08 I I $ 32,451,994.08 I
<br />Prepared by the City of Ramsey Finance Department
<br />8/1/2012
<br />
|