|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended July 31, 2015
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE
<br />CASH INFLOWS:
<br />Daily Deposit
<br />Tax Settlements
<br />UB Receipts
<br />Credit Cards
<br />Interest Earnings [Net of Interest Paid on Investments]
<br />Bond Proceeds
<br />July -15 2015
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 59,569,346.20 $ 48,282,687.30
<br />417,232.25
<br />1,958,522.37
<br />26,851.86
<br />49,781.53
<br />36,261.53
<br />9,452,208.64
<br />5,689,070.87
<br />1,547,570.38
<br />504,679.65
<br />390,727.09
<br />5,061,557.86
<br />TOTAL CASH INFLOW $ 2,488,649.54 $ 22,645,814.49
<br />TOTAL CASH AVAILABLE $ 62,057,995.74 $ 70,928,501.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 2015 CASH INFLOW ( OUTFLOW)
<br />INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />625,373.72 $ 3,428,771.30
<br />852,176.81 3,318,965.32
<br />649,717.32 1,531,731.57
<br />1,206.81 16,589.85
<br />432,791.91 2,220,308.25
<br />2,458.16 38,269.76
<br />(2,536.16) (15,266.57)
<br />52,292.50 944,617.64
<br />$ 2,613,481.07 $ 11,483,987.12
<br />$ 59,444,514.67
<br />(124,831.53)
<br />$ 45,437,071.44
<br />2,694,000.00
<br />(256,408.27)
<br />]
<br />$ 47,874,663.17
<br />Prepared by the City of Ramsey Finance Department
<br />8/18/2015
<br />$ 59,444,514.67
<br />11,161,827.37
<br />43,917,588.88
<br />11,541,000.00
<br />(7,583,925.71)
<br />$ 47,874,663.17
<br />
|