|
CITY OF RAMSEY
<br />• REPORT OF POOLED CASH FLOWS
<br />Period Ended November 30, 2007
<br /> November-07 2007
<br /> CURRENT MONTH- YEAR-TO-DATE
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE $ 48,490,135..86 $ 42,982;917.84
<br />CASH INFLOWS:
<br />Daily Deposit ~ 423,506.80 1.3,291,153.82
<br />Tax Settlements - 6,215,811.47
<br />.Municipal Center Proceeds held with Trust Agent - 3,849,236.31
<br />Bond Proceeds 1,703,575.55
<br />Interest Earnings [Net of Interest Paid on Investments) 154,726.27 1,613,496.75
<br />NSF/Expired City Checks [More than 6 months]
<br />TOTAL CASH INFLOW $ 578,233.07 $ 26,673,273.90
<br />TOTAL CASH AVAILABLE $ 49,068,368.93 $ 69,656,191.74
<br />CASH OUTFLOWS:
<br />•
<br />Prepaid Checks 498,716.74 $ 7,284,511.18
<br />Bills Lists 406,207.80 .5,465,132.53
<br />Pay Estimates 50,798.35 3,726,238.10
<br />Payroll -Net 415,717.62 3,332,602.68
<br />.Void Checks/Dormant Checks Paid (517.73) (40,526.22)
<br />Debt Service 1,522,245.34 3,712,974.16
<br />Miscellaneous [Bank Charges; etc.] - 58.50
<br />TOTAL CASH OUTFLOW $ 2,893,168.12 $ 23,480,990.93
<br />POOLED CASH AND TEMPORARY INVESTMENTS
<br />ENDING BALANCE $ 46,175,200.81 $ 46,175,200.81
<br />MEMO -NET 2007 CASH INFLOW (OUTFLO~~ (2,314,935.05) 3,192,282.47
<br />INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />• ENDING BALANCE
<br />$ 40,722,387.09 $ 40,468,547.40
<br />6,550,000.00 42,848,540.44
<br />(2,545,285.70) (38,589,986.45)
<br />$ 44,727,101.39 ~ $ 44,727,101.39
<br />Prepared by the City of Ramsey Finance Department.
<br />12/04/2007 ,
<br />C-1
<br />-3-
<br />
|