|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period .Ended June 30, 2019
<br />June-19 2019
<br />CURRENT MONTH YEAR-TO-DATE
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE $ 74,852,266.31 $ 77,758,879.57
<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 />530,103.75
<br />4,500,000.00
<br />33,922.85
<br />99,748.95
<br />208,841.97
<br />3,619,812.52
<br />4,620,738.68
<br />1,038,178.03
<br />1,602,443.01
<br />822,457.98
<br />TOTAL CASH INFLOW $ 5,372,617.52 $ 11,703,630.22
<br />TOTAL CASH AVAILABLE $ 80,224,883.83 $ 89,462,509.79
<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 2019 CASH INFLOW ( OUTFLOW)
<br />INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />576,427.35
<br />572,394.68
<br />9,960.53
<br />386,338.16
<br />3,510.55
<br />(145.00)
<br />289,989.60
<br />94.50
<br />$ 1,838,570.37
<br />$ 78,386,313.46
<br />3,534,047.15
<br />$ 66,873,049.43
<br />6,625,000.00
<br />(3,726,039.75)
<br />$ 69,772,009.68
<br />Prepared by the City of Ramsey Finance Department
<br />7/16/2019
<br />3,387,689.74
<br />3,852,536.96
<br />660,096.44
<br />33,727.05
<br />2,266,858.58
<br />27,653.80
<br />(45,530.59)
<br />892,670.85
<br />493.50
<br />11,076,196.33
<br />$ 78,386,313.46
<br />627,433.89
<br />66,545,332.76
<br />20,535,000.00
<br />(17,308,323.08)
<br />$ 69,772,009.68
<br />
|