|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended March 31, 2021
<br />March-21 2021
<br />CURRENT MONTH YEAR-TO-DATE
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE (Includes PW Bond Proceeds) $ 91,514,695.31 $ 95,116,775.37
<br />CASH INFLOWS:
<br />Daily Deposit 336,584.84 2,365,303.44
<br />Tax Settlements - 374,749.21
<br />U/B Receipts 47,402.56 493,526.26
<br />Credit Cards (Includes Utility Billing) 156,973.58 938,520.83
<br />Interest Earnings [Net of Interest Paid on Investments] 88,473.77 222,318.77
<br />Bond Proceeds-int 859.12
<br />TOTAL CASH INFLOW $ 629,434.75 $ 4,395,277.63
<br />TOTAL CASH AVAILABLE
<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 />$ 92,144,130.06 $ 99,512,053.00
<br />550,045.99
<br />587,639.18
<br />221,757.91
<br />9,198.99
<br />397,247.03
<br />7,707.08
<br />152.50
<br />3,346,137.29
<br />2,128,884.07
<br />2,445,617.87
<br />17,214.50'
<br />1,187,113.4.9
<br />16,232.11
<br />(188.20)
<br />660.49
<br />$ 1,773,748.68 $ 9,141,671.62
<br />$ 90,370,381.38
<br />$ 90,370,381.38
<br />(1,144,313.93) (4,746,393.99)
<br />$ 73,482,986.46 73,628,220.22
<br />4,545,000.00
<br />(4,992,604.35)
<br />$ 73,035,382.11
<br />33,949,659.36
<br />(34,542,497.47)
<br />$ 73,035,382.11
<br />Prepared by the City of Ramsey Finance Department
<br />4/7/2021
<br />
|