|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended August 31, 2017
<br />August-17 2017
<br />CURRENT MONTH YEAR-TO-DATE
<br />CASH AND TEMPORARY INVESTMENTS I
<br />BEGINNING BALANCE $ 66,435,869.64 $ 64,912,887.39
<br />CASH INFLOWS:
<br />Daily Deposit
<br />Tax Settlements
<br />U/B Receipts
<br />Credit Cards
<br />Interest Earnings [Net of Interest Paid on Investments]
<br />Bond Proceeds
<br />310,658.28
<br />666,226.12
<br />740,613.96
<br />96,938.06
<br />863,473.61
<br />5,127,344.36
<br />6,218,640.94
<br />2,076,006.20
<br />1,896,210.05
<br />61 0,665.34
<br />863,473.61
<br />TOTAL CASH INFLOW $ 2,677,910.03 $ 16,792,340.50
<br />TOTAL CASH AVAILABLE $ 69,113,779.67 $ 81,705,227.89
<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 2017 CASH INFLOW ( OUTFLOW)
<br />!INVESTMENT PORTFOLIO SUMMARY I
<br />605,092.67
<br />354,489.86
<br />6,336.60
<br />317,259.46
<br />4,994.59
<br />(429.30)
<br />65,178.75
<br />28.00
<br />5,316,672.27
<br />3,929,573.84
<br />896,908.58
<br />36,078.41
<br />2,628,314.00
<br />38,180.36
<br />(44,945.81)
<br />1,143,245.01
<br />372.19
<br />$ 1,352,950.63 $ 13,944,398.85
<br />$ 67,760,829.04 I I $ 67,760,829.04 I
<br />1,324,959.40 2,847,941.65
<br />BEGINNING BALANCE $ 59,658,682.81 57,425,022.30
<br />Purchases 2,518,000.00 17,068,000.00
<br />Maturities/Sales (1,501,538.83) (13,817,878.32)
<br />ENDING BALANCE I $ 60,675,143.98 I I $ 60,675,143.98 I
<br />Prepared by the City of Ramsey Finance Department
<br />9/6/2017
<br />
|