|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended May 31, 2018
<br />May-18 2018
<br />CURRENT MONTH YEAR-TO-DATE
<br />CASH AND TEMPORARY INVESTMENTS I
<br />BEGINNING BALANCE $ 66,735,041.13 $ 69,531,209.52
<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 />2,479,928.11
<br />453,555.80
<br />526,019.38
<br />111,202.33
<br />4,598,642.28
<br />22,366.22
<br />978,955.05
<br />1,358,713.28
<br />427,201.71
<br />TOTAL CASH INFLOW $ 3,570,705.62 $ 7,385,878.54
<br />TOTAL CASH AVAILABLE $ 70,305,746.75 $ 76,917,088.06
<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 2018 CASH INFLOW ( OUTFLOW)
<br />!INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />1,192,206.70 3,312,946.29
<br />532,789.32 2,745,660.13
<br />128,022.00 645,909.25
<br />5,084.82 20,980.75
<br />327,049.43 1, 612, 900.42
<br />2,934.43 21,699.87
<br />(110.19) (98,099.89)
<br />343,698.16 880,788.16
<br />59.50 290.50
<br />$ 2,531,734.17 $ 9,143,075.48
<br />$ 67,774,012.58 I I $ 67,774,012.58 I
<br />1,038,971.45 (1,757,196.94)
<br />$ 61,765,872.18 61,031,260.23
<br />Purchases 1,993,000.00 9,073,000.00
<br />Maturities/Sales (1,949,171.93) (8,294,559.98)
<br />ENDING BALANCE ( $ 61,809,700.25 I I $ 61,809,700.25 I
<br />Prepared by the City of Ramsey Finance Department
<br />6/6/2018
<br />
|