|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended February 28, 2018
<br />CASH AND TEMPORARY INVESTMENTS
<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 />February-18 2018
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 68,685,446.58 $ 69,531,209.52
<br />425,221.68
<br />440,446.21
<br />482,414.97
<br />112,206.57
<br />1,382,172.08
<br />22,366.22
<br />455,772.59
<br />571,412.47
<br />169,203.88
<br />TOTAL CASH INFLOW $ 1,460,289.43 $ 2,600,927.24
<br />TOTAL CASH AVAILABLE $ 70,145,736.01 $ 72,132,136.76
<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
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />684,856.73 1,170,623.57
<br />730,157.99 1,057,337.09
<br />51,678.41 510,842.15
<br />2,730.44 5,600.79
<br />324,673.81 642,140.96
<br />2,894.01 6,540.83
<br />(51,464.87) (51,501.62)
<br />390,287.50
<br />56.00 112.00
<br />$ 1,745,582.52 $ 3,731,983.27
<br />$ 68,400,153.49
<br />(285,293.09)
<br />$ 61,530,677.23
<br />1,909,000.00
<br />(1,090,949.32)
<br />$ 62,348,727.91
<br />Prepared by the City of Ramsey Finance Department
<br />3/5/2018
<br />$ 68,400,153.49
<br />(1,131,056.03)
<br />61,031,260.23
<br />4,306,000.00
<br />(2,988,532.32)
<br />$ 62,348,727.91
<br />
|