|
CITY OF RAMSEY
<br /> t
<br /> REPORT OF POOLED CASH FLOWS
<br /> Period Ended December 31 2016
<br /> December-16 2016 i
<br /> CURRENT MONTH YEAR-TO-DATE
<br /> CASH AND TEMPORARY INVESTMENTS
<br /> 1
<br /> BEGINNING BALANCE $ 61,883,647.39 $ 61,390,441.49
<br /> i-
<br /> CASH INFLOWS:
<br /> Daily Deposit 781,280.99 6,743,738.89
<br /> 5,265,581.91 11 214
<br /> Tax Settlements >446.22
<br /> UB Receipts 84,550.83 3,760,318.88
<br /> Credit Cards 78,070.61 1,484,136.91
<br /> Interest Earnings [Net of Interest Paid on Investments] 96,516.13 832,072.37
<br /> Bond Proceeds 1,673,368.95
<br /> TOTAL CASH INFLOW $ 6,306,000.47 $ 25,708,082.22
<br /> TOTAL CASH AVAILABLE $ 68,189,647.86 $ 87,098,523.71
<br /> CASH OUTFLOWS:
<br /> Prepaid Checks 708,215.46 $ 6,780,618.57
<br /> Bills Lists 491,365.40 5,395,836.27
<br /> Pay Estimates 393,656.35 3,547,237.63
<br /> Credit Cards 8,534.72 51,356.87
<br /> Payroll -Net 462,997.65 3,923,978.46
<br /> Flex Reimbursement 5,490.56 60,320.67
<br /> Void Checks/Dormant Checks Paid (3,127.23) (51,542.22)
<br /> Debt Service 1,209,627.51 2,477,830.02 1
<br /> Miscellaneous [Bank Charges;etc.] - -
<br /> TOTAL CASH OUTFLOW $ 3,276,760.42 $ 22,185,636.27
<br /> POOLED CASH AND TEMPORARY INVESTMENTS
<br /> ENDING BALANCE 64,912,887.44 64,912,887.44 I°
<br /> MEMO-.NET 2016 CASH INFLOW(OUTFLOW) 3,029,240.05 3,522,445.95
<br /> t
<br /> INVESTMENT PORTFOLIO SUMMARY
<br /> BEGINNING BALANCE $ 56,449,194.74 54,272,507.58
<br /> G
<br /> Purchases 4,153,000.00 27,777,000.00
<br /> 3,177,172.39 24,624,485.23
<br /> Maturities/Sates ( ) ( ) �
<br /> ENDING BALANCE �— 57,425,022.35 57,425,022.35
<br /> i'
<br /> i
<br /> Prepared by the City of Ramsey Finance Department
<br /> 1/3/2017
<br />
|