|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended April 30, 2018
<br />ICASH AND TEMPORARY INVESTMENTS I
<br />BEGINNING BALANCE
<br />CASH INFLOWS:
<br />Daily Deposit
<br />Tax Settlements
<br />U/B Receipts
<br />Credit Cards (Includes Utility Billing)
<br />Interest Earnings [Net of Interest Paid on Investments]
<br />Bond Proceeds
<br />TOTAL CASH INFLOW
<br />TOTAL CASH AVAILABLE
<br />CASH OUTFLOWS:
<br />Prepaid Checks
<br />Bills Lists
<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 2018 CASH INFLOW ( OUTFLOW)
<br />'INVESTMENT PORTFOLIO SUMMARY I
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />April-18
<br />CURRENT MONTH
<br />$ 67,401,384.82
<br />270,725.24
<br />16,882.70
<br />154,157.63
<br />73,175.91
<br />$ 514,941.48
<br />$ 67,916,326.30
<br />371,671.01
<br />473,085.58
<br />7,045.10
<br />3,082.59
<br />321,379.31
<br />5,447.21
<br />(478.87)
<br />59.50
<br />2018
<br />YEAR-TO-DATE
<br />$ 69,531,209.52
<br />2,118,714.17
<br />22,366.22
<br />525,399.25
<br />832,693.90
<br />315,993,12
<br />$ 3,815,166.66
<br />$ 73,346,376.18
<br />1,181,291.43 $
<br />66,735,034.87 ( I $
<br />(666,349.95)
<br />$ 61,698,263.46
<br />2,325,000.00
<br />(2,257,397.54)
<br />$ 61,765,865.92 I I $
<br />2,120,739.59
<br />2;212,870.81
<br />517, 887.25
<br />15,895.93
<br />1,285,850.99
<br />18,765.44
<br />(97,989.70)
<br />537,090.00
<br />231.00
<br />6,611,341.31
<br />66,735,034.87 I
<br />(2,796,174.65)
<br />61,031,260.23
<br />7,080,000.00
<br />(6,345,394.31)
<br />61,765,865.92 I
<br />Prepared by the City of Ramsey Finance Department
<br />5/1/2018
<br />
|