|
CITY OF RAMSEY
<br /> REPORT OF POOLED CASH FLOWS
<br /> Period Ended March 31, 2017
<br /> March-17 2017
<br /> CURRENT MONTH YEAR-TO-DATE
<br /> CASH AND TEMPORARY INVESTMENTS
<br /> BEGINNING BALANCE $ 63,475,202.33 $ 64,912,887.39
<br /> CASH INFLOWS:
<br /> Daily Deposit 467,591.02 1,325,274.05
<br /> Tax Settlements - 158,808.75
<br /> U/B Receipts 89,208.61 794,569.88
<br /> Credit Cards 134,808.70 339,134.76
<br /> Interest Earnings [Net of Interest Paid on Investments] 64,988.82 199,293.38
<br /> Bond Proceeds
<br /> TOTAL CASH INFLOW $ 756,597.15 $ 2,817,080.82
<br /> r
<br /> t
<br /> TOTAL CASH AVAILABLE $ 64,231,799.48 $ 67,729,968.21
<br /> CASH OUTFLOWS:
<br /> Prepaid Checks 546,336.03 1,796,012.45
<br /> Bills Lists 710,799.03 1,554,231.42
<br /> Pay Estimates 90,176.95 373,863.95
<br /> Credit Cards 7,027.76 11,048.55
<br /> Payroll -Net 304,602.89 890,289.74
<br /> Flex Reimbursement 8,354.29 14,752.57
<br /> Void Checks/Dormant Checks Paid (604.83) (1,404.83)
<br /> Debt Service 149,672.50 675,615.00
<br /> Miscellaneous [Bank Charges;etc.] 24.50 149.00
<br /> I'
<br /> i'
<br /> TOTAL CASH OUTFLOW $ 1,816,389.12 $ 5,314,557.85
<br /> F
<br /> POOLED CASH AND TEMPORARY INVESTMENTS
<br /> ENDING BALANCE $ 62,415,410.36 r$ 62,415,410.36
<br /> MEMO-NET 2017 CASH INFLOW(OUTFLOW) (1,059,791.97) (2,497,477.03)
<br /> INVESTMENT PORTFOLIO SUMMARY
<br /> BEGINNING BALANCE $ 58,000,465.90 57,425,022.30 Ih,'
<br /> Purchases 1,050,000.00 4,004,000.00
<br /> Maturities/Sales (3,053,766.52) (5,432,322.92)
<br /> c
<br /> ENDING BALANCE $ 55,996,699.38 $ 55,996,699.38
<br /> Prepared by the City of Ramsey Finance Department
<br /> 4/3/2017
<br />
|