|
<br />c--.'
<br />
<br />CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended December 31,2007
<br />
<br /> December-07 2007
<br /> CURRENT MONTH YEAR- TO-DATE
<br />~CASH AND TEMPORARY INVESTMENTS I
<br />BEGINNING BALANCE $ 46,178,631.96 $ 42,982,917.84
<br />CASH INFLOWS:
<br />Daily Deposit 1,505,557.87 14,796,711.69
<br />Tax Settlements 5,583,395.80 11,799,207.27
<br />Municipal Center Proceeds held with Trust Agent 631,873.17 4,481,109.48
<br />Bond Proceeds 1,703,575.55
<br />Interest Eamings[Net of Interest Paid on Investments] 213,617.31 1,827,114.06
<br />NSFlExpired City Checks [More than 6 months]
<br />TOTAL CASHINFLOW $ 7,934,444.15 $ 34,607,718.05
<br />TOTAL CASH AVAILABLE $ 54,113,076.11 - $ 77,590,635.89
<br />CASH OUTFLOWS:
<br />Prepaid Checks 442,824.12 $ 7,723,904.15
<br />Bills Lists 718,584.32 6,183,716.85
<br />Pay Estimates 500,272.65 4,226,510.75
<br />Payroll - Net 255,725.90 3,588,328.58
<br />Void Checks/Dormant Checks Paid (93,654.13) (134,180.35)
<br />Debt Service 63,024.29 3,775,998.45
<br />Miscellaneous [Bank Charges; etc.] 58.50
<br />TOTAL CASH OUTFLOW $ 1,886,777.15 $ 25,364,336.93
<br />POOLED CASH AND TEMPORARY INVESTMENTS
<br />ENDING BALANCE I $ 52,226,298.96 I I $ 52,226,298.96 I
<br />MEMO - NET 2007 CASH INFLOW ( OUTFLOW) 6,047,667.00 9,243,381.12
<br />
<br />lINVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE $ 44,727,101.39 $ 40,468,547.40
<br />Purchases 6,750,000.00 49,598,540.44
<br />Maturities/Sales (2,600,472.16) (41,190,458.61)
<br />ENDING BALANCE 1$ 48,876,629.23 I 1$ 48,876,629.23 I
<br />
<br />Prepared by the City of Ramsey Finance Department
<br />01/02/2008
<br />
<br />-3-
<br />
|