|
CITY OF RAMSEY
<br /> REPORT OF POOLED CASH FLOWS
<br /> Period Ended July 31, 2016
<br /> July-16 2016
<br /> CURRENT MONTH YEAR-TO-DATE
<br /> CASH AND TEMPORARY INVESTMENTS
<br /> BEGINNING BALANCE $ 60,365,530.52 $ 61,390,441.49
<br /> CASH INFLOWS:
<br /> Daily Deposit 798,300.41 2,864,983.40
<br /> Tax Settlements 2,050,906.11 5,948,864.31
<br /> UB Receipts 59,172.52 1,617,388.99
<br /> Credit Cards 73,593.01 735,236.13
<br /> Interest Earnings[Net of Interest Paid on Investments] 43,914.30 458,889.63
<br /> Bond Proceeds 1,673,368.95 1,673,368.95
<br /> TOTAL CASH INFLOW $ 4,699,255.30 $ 13,298,731.41
<br /> TOTAL CASH AVAILABLE $ 65,064,785.82 $ 74,689,172.90
<br /> CASH OUTFLOWS:
<br /> Prepaid Checks 636,193.72 $ 3,388,519.57
<br /> Bills Lists 385,233.70 3,581,861.41
<br /> Pay Estimates - 884,331.12
<br /> Credit Cards 4,013.07 25,690.55
<br /> Payroll-Net 462,531.05 2,225,825.59
<br /> Flex Reimbursement 4,245.33 37,266.42
<br /> Void Checks/Dormant Checks Paid (168.53) (9,459.25)
<br /> Debt Service 45,942.50 1,028,342.51
<br /> Miscellaneous [Bank Charges;etc.] - -
<br /> TOTAL CASH OUTFLOW $ 1,537,990.84 $ 11,162,377.92
<br /> POOLED CASH AND TEMPORARY INVESTMENTS
<br /> ENDING BALANCE $ 63,526,794.98 $ 63,526,794.98
<br /> MEMO-NET 2016 CASH INFLOW(OUTFLOW) 3,161,264.46 2,136,353.49
<br /> INVESTMENT PORTFOLIO SUMMARY
<br /> BEGINNING BALANCE $ 50,060,409.47 54,272,507.58
<br /> Purchases 4,790,000.00 13,951,000.00
<br /> Maturities/Sales (1,078,980.65) (14,452,078.76) a
<br /> ENDING BALANCE $ 53,771,428.82 $ 53,771,428.82
<br /> Prepared by the City of Ramsey Finance Department
<br /> 8/2/2016
<br />
|