|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended May 31, 2020
<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 />May-20 2020
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 81,820,839.52 $ 84,144,038.99
<br />726,518.27
<br />414,277.60
<br />653,741,01
<br />117,458,51
<br />3,552,345.52
<br />116,640.63
<br />916,746.75
<br />1,611,629.38
<br />685,967.36
<br />TOTAL CASH INFLOW $ 1,911,995.39 $ 6,883,329.64
<br />TOTAL CASH AVAILABLE $ 83,732,834.91 $ 91,027,368.63
<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 2019 CASH INFLOW ( OUTFLOW)
<br />INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />636,903,48
<br />358,150,93
<br />4,179.49
<br />552,559,11
<br />3,677.44
<br />(355.36)
<br />1,888,907,09
<br />149.00
<br />4,006,362,01
<br />2,421,171.43
<br />22,735.72
<br />2,027,066.15
<br />19,231,71
<br />(45,596.21)
<br />2,287,004.59
<br />729.50
<br />$ 3,444,171.18 $ 10,73 8,704, 90
<br />$ 80,288,663.73
<br />(1,532,175.79)
<br />$ 69,530,014.74
<br />3,700,000.00
<br />(6,943,030.51)
<br />$ 66,286,984.23
<br />Prepared by the City of Ramsey Finance Department
<br />6/2/2020
<br />$ 80,288,663.73
<br />(3,855,375.26)
<br />73,537,171.61
<br />16,925,000.00
<br />(24,175,187.38)
<br />$ 66,286,984.23
<br />
|