|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended January 31, 2018
<br />January-18 2018
<br />CURRENT MONTH YEAR-TO-DATE
<br />CASH AND TEMPORARY INVESTMENTS I
<br />BEGINNING BALANCE $ 69,531,209.52 $ 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 />956,950.40
<br />22,366.22
<br />15,326.38
<br />88,997.50
<br />56,997,31
<br />956,950.40
<br />22,366.22
<br />15,326.38
<br />88,997,50
<br />56,997.31
<br />TOTAL CASH INFLOW $ 1,140,637.81 $ 1,140,637.81
<br />TOTAL CASH AVAILABLE $ 70,671,847,33 $ 70,671,847.33
<br />CASH OUTFLOWS:
<br />Prepaid Checks 485,766.84 485,766,84
<br />Bills Lists 327,179.10 327,179,10
<br />Pay Estimates 459,163.74 459,163.74
<br />Credit Cards 2,870.35 2,870.35
<br />Payroll - Net 317,467,15 317,467.15
<br />Flex Reimbursement 3,646.82 3,646.82
<br />Void Checks/Dormant Checks Paid (36.75) (36.75)
<br />Debt Service 390,287.50 390,287.50
<br />Miscellaneous [Bank Charges; etc.] 56.00 56.00
<br />TOTAL CASH OUTFLOW $ 1,986,400.75 $ 1,986,400.75
<br />POOLED CASH AND TEMPORARY INVESTMENTS
<br />ENDING BALANCE I $ 68,685,446.58 I I $ 68,685,446.58 I
<br />MEMO - NET 2018 CASH INFLOW ( OUTFLOW) (845,762.94) (845,762.94)
<br />'INVESTMENT PORTFOLIO SUMMARY I
<br />BEGINNING BALANCE
<br />$ 61,031,260.23 61,031,260.23
<br />Purchases 2,397,000.00 2,397,000.00
<br />Maturities/Sales (1,897,583.00) (1,897,583.00)
<br />ENDING BALANCE I $ 61,530,677.23 I I $ 61,530,677.23 I
<br />Prepared by the City of Ramsey Finance Department
<br />2/2/2018
<br />
|