|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended May 31, 2017
<br />May-17 2017
<br />CURRENT MONTH YEAR-TO-DATE
<br />.CASH AND TEMPORARY INVESTMENTS I
<br />BEGINNING BALANCE $ 61,842,912.34 $ 64,912,887.39
<br />CASH INFLOWS:
<br />Daily Deposit 468,222.44 2,355,303.02
<br />Tax Settlements 158,808.75
<br />U/B Receipts 491,687.12 1,311,529.84
<br />Credit Cards 470,106.44 871,149.65
<br />Interest Earnings [Net of Interest Paid on Investments] 87,129.73 349,450.76
<br />Bond Proceeds
<br />TOTAL CASH INFLOW $ 1,517,145.73 $ 5,046,242.02
<br />TOTAL CASH AVAILABLE $ 63,360,058.07 $ 69,959,129.41
<br />CASH OUTFLOWS:
<br />Prepaid Checks 651,022.35 2,837,714.64
<br />Bills Lists 554,316.84 2,672,698.60
<br />Pay Estimates 24,516.55 410,413.44
<br />Credit Cards 1,870.38 15,773.93
<br />Payroll - Net 310,449.45 1,511,459.33
<br />Flex Reimbursement 7,202.61 25,928.01
<br />Void Checks/Dormant Checks Paid (1,413.62)
<br />Debt Service 63,281.25 738,896.25
<br />Miscellaneous [Bank Charges; etc.] 28.00 288.19
<br />TOTAL CASH OUTFLOW $ 1,612,687.43 $ 8,211,758.77
<br />POOLED CASH AND TEMPORARY INVESTMENTS
<br />ENDING BALANCE I $ 61,747,370.64 I I $ 61,747,370.64 I
<br />MEMO - NET 2017 CASH INFLOW ( OUTFLOW) (95,541.70) (3,165,516.75)
<br />'INVESTMENT PORTFOLIO SUMMARY I
<br />BEGINNING BALANCE
<br />$ 55,996,699.38 57,425,022.30
<br />Purchases 2,400,000.00 6,404,000.00
<br />Maturities/Sales (691,872.68) (6,124,195.60)
<br />ENDING BALANCE
<br />$ 57,704,826.70 I I $ 57,704,826.70
<br />Prepared by the City of Ramsey Finance Department
<br />6/1/2017
<br />
|