|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended February 29, 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 />February-20 2020
<br />CURRENT MONTH YEAR-TO-DATE
<br />83,224,507.28 $ 84,144,038.99
<br />352,109.91
<br />437,511.64
<br />553,854.83
<br />125,650.63
<br />1,076,298.93
<br />116,640.63
<br />449,714.32
<br />680,997.35
<br />290,275.10
<br />TOTAL CASH INFLOW $ 1,469,127.01 $ 2,613,926.33
<br />TOTAL CASH AVAILABLE $ 84,693,634.29 $ 86,757,965.32
<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 />549,892.13
<br />910,318.19
<br />3,523.75
<br />369,911.55
<br />5,597.80
<br />170.50
<br />1,460,634.08
<br />1,337,442.70
<br />6,475.11
<br />734,347.72
<br />10,588.92
<br />(44,127.08)
<br />398,097.50
<br />286.00
<br />$ 1,839,413.92 $ 3,903,744.95
<br />$ 82,854,220.37
<br />(370,286.91)
<br />$ 71,976,135.35
<br />5,730,000.00
<br />(3,784,035.12)
<br />$ 73,922,100.23
<br />$ 82,854,220.37
<br />(1,289,818.62)
<br />73,537,171.61
<br />8,195,000.00
<br />(7,810,071.38)
<br />$ 73,922,100.23
<br />Prepared by the City of Ramsey Finance Department
<br />3/3/2020
<br />
|