|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended July 31, 2018
<br />CASH 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 />July-18
<br />CURRENT MONTH
<br />2018
<br />YEAR-TO-DATE
<br />$ 70,604,268.33 $ 69,531,209.52
<br />766,344.09 5,796,052.48
<br />2,522,301.96 2,544,668.18
<br />19,377.97 1,041,673.62
<br />186,599.76 1,687,249.55
<br />72,092.33 661,871.99
<br />1,161,022.39 5,461,022.39
<br />$ 4,727,738.50 $ 17,192,538.21
<br />$ 75,332,006.83 $ 86,723,747.73
<br />452,339.74 4,388,702.07
<br />550,223.35 4,072,901.98
<br />828,919.15 1,815,138.04
<br />4,792.06 33,639.11
<br />342,609.89 2,453,482.38
<br />2,279.61 27,382.90
<br />(704.95) (100,184.89)
<br />36,292.50 917,080.66
<br />63.00 413.00
<br />2,216,814.35 $ 13,608,555.25
<br />73,115,192.48 1 I $
<br />2,510,924.15
<br />$ 59,596,437.08
<br />8,224,000.00
<br />(2,470,553.60)
<br />1 $ 65,349,883.48 1 1 $
<br />Prepared by the City of Ramsey Finance Department
<br />8/6/2018
<br />73,115,192.48 1
<br />3,583,982.96
<br />61,031,260.23
<br />20,791,000.00
<br />(16,472,376.75)
<br />65,349,883.48 1
<br />
|