|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended November 30, 2018
<br />November-18 2018
<br />CURRENT MONTH YEAR-TO-DATE
<br />CASH AND TEMPORARY INVESTMENTS I
<br />BEGINNING BALANCE $ 73,073,429.43 $ 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 />885,216.69
<br />5,857,936.43
<br />718,742.68
<br />859,510.18
<br />107,715.20
<br />11,069,844.77
<br />12,702,604.61
<br />2,443,740.00
<br />3,619,547.20
<br />1,090,373.21
<br />1,161,022.39
<br />TOTAL CASH INFLOW $ 8,429,121.18 $ 32,087,132.18
<br />TOTAL CASH AVAILABLE $ 81,502,550.61 $ 101,618,341.70
<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 />944,873.75 8,308,455.27
<br />415,919.73 5,984,517.66
<br />517,753.92 3,249,742.61
<br />4,461.44 58,247.73
<br />526,917.61 4,010,131.79
<br />8,340.91 42,990.36
<br />(102,528.38)
<br />1,888,793.76 2,870,693.17
<br />63.00 665.00
<br />$ 4,307,124.12 $ 24,422,915.21
<br />POOLED CASH AND TEMPORARY INVESTMENTS
<br />ENDING BALANCE I $ 77,195,426.49 I I $ 77,195,426.49
<br />MEMO - NET 2018 CASH INFLOW ( OUTFLOW) 4,121,997.06 7,664,216.97
<br />INVESTMENT PORTFOLIO SUMMARY I
<br />BEGINNING BALANCE $ 67,465,454.82 61,031,260.23
<br />Purchases 27,080,000.95
<br />Maturities/Sales (1,400,049.24) (22,045,855.60)
<br />ENDING BALANCE I $ 66,065,405.58 I I $ 66,065,405.58 I
<br />Prepared by the City of Ramsey Finance Department
<br />12/6/2018
<br />
|