|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended July 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 />June-20 2020
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 83,972,886.39 $ 84,144,038.99
<br />2,482,075.95
<br />3,737,721.23
<br />29,714.99
<br />193,873.38
<br />91,646.86
<br />7,694,799.82
<br />7,254,361.86
<br />1,034,866.18
<br />1,919,943.87
<br />974,619.85
<br />TOTAL CASH INFLOW $ 6,535,032.41 $ 18,878,591.58
<br />TOTAL CASH AVAILABLE $ 90,507,918.80 $ 103,022,630.57
<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 />891,197.94
<br />778,424.05
<br />16,771.49
<br />3,160.50
<br />393,750.05
<br />7,264.14
<br />(404.44)
<br />149.00
<br />5,532,990.88
<br />3,671,911.86
<br />16,771.49
<br />36,332.72
<br />2,819,021.27
<br />30,652.90
<br />(46,867.47)
<br />2,543,332.35
<br />878.50
<br />$ 2,090,312.73 $ 14,605,024.50
<br />$ 88,417,606.07
<br />4,444,719.68
<br />$ 66,647,291.93
<br />10,776,194.78
<br />(2,685,030.10)
<br />$ 74,738,456.61
<br />$ 88,417,606.07
<br />4,273,567.08
<br />73,537,171.61
<br />32,669,533.49
<br />(31,468,248.49)
<br />$ 74,738,456.61
<br />3
<br />Prepared by the City of Ramsey Finance Department
<br />8/5/2020
<br />
|