|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended March 31, 2018
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE
<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 />TOTAL CASH INFLOW
<br />TOTAL CASH AVAILABLE
<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 2018 CASH INFLOW ( OUTFLOW)
<br />INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />March-18 2018
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 68,400,153.49 $ 69,531,209.52
<br />465,816.85
<br />52,743.96
<br />107,123.80
<br />73,613.33
<br />1,847, 988.93
<br />22,366.22
<br />508,516.55
<br />678,536.27
<br />242,817.21
<br />699,297.94 $ 3,300,225.18
<br />$ 69,099,451.43 $ 72,831,434.70
<br />578,445.01 1,749,068.58
<br />682,448.14 1,739,785.23
<br />510,842.15
<br />7,212.55 12,813.34
<br />322,330.72 964,471.68
<br />6,777.40 13,318.23
<br />(46,009.21) (97,510.83)
<br />146,802.50 537,090.00
<br />59.50 171.50
<br />$ 1,698,066.61 $ 5,430,049.88
<br />$ 67,401,384.82
<br />(998,768.67)
<br />$ 62,348,727.91
<br />449,000.00
<br />(1,099,464.45)
<br />$ 61,698,263.46
<br />Prepared by the City of Ramsey Finance Department
<br />4/3/2018
<br />$ 67,401,384.82
<br />(2,129,824.70)
<br />61,031,260.23
<br />4,755,000.00
<br />(4,087,996.77)
<br />$ 61,698,263.46
<br />
|