|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended May 31, 2019
<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-19 2019
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 75,251,508.77 $ 77,758,879.57
<br />704,836.38
<br />485,847.88
<br />600,340.48
<br />61,862.56
<br />3,089,708.77
<br />120,738.68
<br />1,004,255.18
<br />1,502,694.06
<br />613,616.01
<br />TOTAL CASH INFLOW $ 1,852,887.30 $ 6,331,012.70
<br />TOTAL CASH AVAILABLE $ 77,104,396.07 $ 84,089,892.27
<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 />767,971.69
<br />685,087.33
<br />247,970.36
<br />5,240.73
<br />518,442.48
<br />5,771.35
<br />(36,072.93)
<br />57,631.25
<br />87.50
<br />2,811,262.39
<br />3,280,142.28
<br />660,096.44
<br />23,766.52
<br />1,880,520.42
<br />24,143.25
<br />(45,385.59)
<br />602,681.25
<br />399.00
<br />$ 2,252,129.76 $ 9,237,625.96
<br />$ 74,852,266.31
<br />(399,242.46)
<br />$ 66,898,092.74
<br />3,175,000.00
<br />(3,200,043.31)
<br />$ 66,873,049.43
<br />Prepared by the City of Ramsey Finance Department
<br />6/3/2019
<br />$ 74,852,266.31
<br />(2,906,613.26)
<br />66,545,332.76
<br />13,910,000.00
<br />(13,582,283.33)
<br />$ 66,873,049.43
<br />
|