|
C.., I
<br />CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended July 31, 2007
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE
<br />CASH INFLOWS:
<br />Daily Deposit
<br />Tax Settlements
<br />Municipal Center Proceeds held with Trust Agent
<br />Bond Proceeds
<br />Interest Earnings [Net of Interest Paid on Investments]
<br />NSF/Expired City Checks [More than 6 months]
<br />TOTAL CASH INFLOW
<br />TOTAL CASH AVAILABLE
<br />CASH OUTFLOWS:
<br />Prepaid Checks
<br />Bills Lists
<br />Pay Estimates
<br />Payroll - Net
<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 2007 CASH INFLOW ( OUTFLOW)
<br />INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities /Sales
<br />ENDING BALANCE
<br />July -07 2007
<br />CURRENT MONTH YEAR -TO -DATE
<br />$ 44,567,456.49 $ 42,982,917.84
<br />530,901.33
<br />$ 40,468,547.40
<br />5,312,960.98
<br />3,269,310.30
<br />(2,287,004.64)
<br />6,215,811.47
<br />$ 44,730,871.65
<br />$ 44,730,871.65
<br />3,626,983.08
<br />1,703,575.55
<br />154,156.28
<br />973,616.61
<br />$ 3,954,367.91
<br />$
<br />17,832,947.69
<br />$ 48,521,824.40
<br />$
<br />60,815,865.53
<br />1,062,016.81
<br />$
<br />4,380,233.65
<br />406,404.60
<br />3,638,728.71
<br />265,270.24
<br />2,131,577.96
<br />326,966.78
<br />2,090,703.92
<br />(1,096.72)
<br />(24,625.38)
<br />53,803.34
<br />2,190,728.82
<br />-
<br />58.50
<br />$ 2,113,365.05
<br />$
<br />14,407,406.18
<br />$ 46,408,459.35 $ 46,408,459.35
<br />1,841,002.86 3,425,541.51
<br />$ 41,711,580.29
<br />$ 40,468,547.40
<br />5,306,296.00
<br />23,198,540.44
<br />(2,287,004.64)
<br />(18,936,216.19)
<br />$ 44,730,871.65
<br />$ 44,730,871.65
<br />Prepared by the City of Ramsey Finance Department
<br />08/01/2007 —3—
<br />
|