|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended April 30, 2021
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE (Includes PTV Bond Proceeds)
<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-int
<br />April-21 2021
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 90,370,381.38 $ 95,116,775.37
<br />1,037,406.61
<br />12,044.55
<br />140,065.66
<br />64,495.75
<br />3,402,710.05
<br />374,749.21
<br />505,570.81.
<br />1,078,586.49
<br />286,814.52
<br />859.12
<br />TOTAL CASH INFLOW $ 1,254,012.57 $ 5,649,290.20
<br />TOTAL CASH AVAILABLE $ 91,624,393.95 $ 100,766,065.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 2021 CASH INFLOW ( OUTFLOW)
<br />INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />723,051.51
<br />459,285.72
<br />1,858,316.19
<br />3,960.00
<br />587,315.55
<br />3,531.13
<br />(682.13)
<br />393.02
<br />4,069,188.80
<br />2,588,169.79
<br />4,303,934.06
<br />21,174.50
<br />1,774,429.04
<br />19, 763.24
<br />(870.33)
<br />1,053.51
<br />$ 3,63 5,170.99 $ 12,776, 842.61
<br />$ 87,989,222.96
<br />(2,381,158.42)
<br />$ 73,035,382.11
<br />2,080,569.60
<br />(2,030,661.59)
<br />$ 73,085,290.12
<br />$ 87,989,222.96
<br />(7,127,552.41)
<br />73,628,220.22
<br />36,030,228.96
<br />(36,573,159.06)
<br />$ 73,085,290.12
<br />Prepared by the City of Ramsey Finance Department
<br />5/6/2021
<br />
|