Loading...
HomeMy WebLinkAboutItem ICITY OF SEAL BEACH ADMINISTRATIVE SERVICES DEPARTMENT MONTHLY INVESTMENT REPORT MARCH, 2002 February Cash and Investments March Cash and Investments: $18,992,358.07 RDA Funds 4,892,563.81 Trust and Agency Funds 215,113.37 Assessment Districts (4,682.97) Capital Projects (2,877,155.97) Water Fund 3,340,607.52 Sewer Fund 1,393,072.44 Special Revenue Funds 2,106,837.80 General Fund 9,813,909.80 Reserved for Compensated Absences (950,000.00) Designated for Change in Economic Conditions (1,000,000.00) Designated for Self- Insurance (900,000.00) Available General Fund Balance 6,963,909.80 Page l N q MONTH: March -02 MONTHLY INVESTMENT REPORT %of Yield Earnings Earnings Interest Purchase Type of Investment Institution Investment Term: Portfolio Allowance Accrual Received Price Current Value Checking Bank of America open 5.67% 2.000% $563.09 $1,069,669.76 $1,069,669.76 Savings Bank of America open 0.07% 2.000% $20.72 $12,429.98 $12,429.98 Checking Bank of America open 0.06% 2.000% $8.68 $11,069.20 $11,069.20 Section 125 Public Commercial Wells Fargo Bank open 0.03% $2.00 $6,599.53 $6,599.53 Checking 1963 Water Bonds Regular Savings Wells Fargo Bank open 0.04% 1.000% $9.59 $7,113.71 $7,113.71 Bixby Wall Maintenance State Pool Local Agency open 44.21% 2.861% $19,899.18 $8,346,387.68 $8,346,387.68 Investment Fund Agency Issue Federal Home Loan 10/25/2001 10/25/2004 4.000% $1,666.67 $500,000.00 5495,315.00 Bonds Agency Issue Federal Home Loan 3/28/2001 9/28/2004 5.400% $2,250.00 $500,000.00 CALLED Bonds Agency Issue Federal Home Loan 1/9/2002 719/2002 4.0800/6 $1,700.00 $500,000.00 $498,750.00 Bonds Senior Notes Bear Steams Co. Unsecd 4/19/2001 7/15/2005 6.250% $2,604.17 $500,000.00 $512,945.94 Agency Issue Federal Home Loan 11/812001 11/8/2004 4.000% $1,666.67 $500,000.00 $495,155.00 Bonds Agency Issue Federal Home Loan 12/6/2001 6/6/2005 4.065% $1,693.75 $500,000.00 $490,315.00 Bonds Agency Issue Federal Home Loan 10/11/2001 10 /I1 /2005 4.450% $1,854.17 $500,000.00 $492,190.00 Bonds Page 1 MONTH: March -02 MONTHLY INVESTMENT REPORT %of Yield Earnings Earnings Interest Purchase Type of Investment Institution Investment Tenn: Portfolio Allowance Accrual Received Price Current Value Agency Issue FFBC Bonds 6/14/2001 6/14/2005 5.560% $2,316.67 $500,000.00 $503180.00 Agency Issue Federal Home Loan 9/11/2001 3/11/2005 5.020% $2,091.67 $500,000.00 CALLED Bonds Agency Issue Fannie Mae Medium 9/6/2001 9/612005 5.060% $2,108.33 $500,000.00 $502,190.00 Term Now Agency Issue Fannie Mae Medium 10/15/2001 4/15/2004 3.550% $1,479.17 $500,000.00 $496,095.00 Term Now Agency Issue FFBC Bonds 10/29/2001 4/29/2005 4.125% $1,718.75 $500,000.00 $492,190.00 Agency Issue Federal Home Loan 11/16/200111/16 /2005 4.140% $3,450.00 $1,000,000.00 $972,810.00 Bonds Agency Issue FFBC Bonds 12/6/2001 12/6/2004 4.250% $1,770.83 $500,000.00 CALLED Agency Issue Federal Home Loan 12/20/2001 6/20/2005 4.800% $2,000.00 $500,0110.00 CALLED Bonds Agency Issue FFBC Bonds 12/4/2001 12/412006 5.100% $2,125.00 $500,000.00 $494,065.00 Agency Issue Federal Home Loan 1/11/200210/11/2005 5.060% $2,108.33 $500,000.00 $500,315.00 Bonds Agency Issue Federal Home Loan 1/2/2002 1/2/2007 5.180% $2,158.33 $500,000.00 $496,405.00 Bonds Agency Issue Federal Home Loan 2/26/2002 11/26/2004 4.000% $1,666.67 $500,000.00 $494,845.00 Bonds Agency Issue Sallie Mae Medium 2/14 /2002 2/14/2005 4.230% $1,762.50 $500,000.00 $495,625.00 Page 2 MONTH: March -02 MONTHLY INVESTMENT REPORT %of Yield Earnings Earnings Interest Purchase Tvoe of Investment Institution Investment Term: Portfolio Allowance Accrual Received Price Agency Issue FFBC Bonds 3/28/2002 9/28/2004 4.140% $1,725.00 $500,000.00 $497,50000 Agency Issue Fannie Mae Medium 3/29/2002 3/29/2006 4.000% variable $1,666.67 $500,000.00 $497,005.00 Term Now Total Agency Issues 49.93% Subtotal Cash and Investments available for designated reserves and budgeted a rPenditures: $18,880,265.80 Prior mouth subtotal Cash and Investments available for designated reserves and budgeted ex enditures: $/$992,358.07 Held by Trustee for 2000 Sewer COP's: BNY Western Trust Compnny 4.60% $6.15 $2,317,508.50 Project Account 3/1/2002 3/31/2002 Held by Trustee for 2000A for RDA BNY Western Trust Company 3/1/2002 3/31/2002 5.51% $31.49 $676,582.50 Reserve Account Held by Trustee for 200011 for RDA BNY Western Trust Company $3.28 $65,932.29 Reserve Account 3/1/2002 3/31/2002 5.51% Total Invesarent Portfolio 3.72% 2.00% $21,197,774.30 Page 3 MONTH: March -02 MONTHLY INVESTMENT REPORT %of Yield Earnings Earnings Interest Purchase m compimce wrw we -- - - -. - -- -- - City of Seal Beach hereby certifies that sufficient investment liquidity and anticipated revenue are available m meet the City's budgeted expeaditme requirement for the next six months. Investment in the report meet the requirement of the City of Seal Beach's adopted investment policy. Respectfully submitted, Pamela Arends-King U Director of Administrative Services/Treaanrer Page 4 CITY OF SEAL BEACH ADMINISTRATIVE SERVICES DEPARTMENT MONTHLY AGING REPORT MARCH, 2002 Percent of Current Current Azing Interval Date o(MaturitY mveswenu - - - -- 0 days 4/01/2002- 4/01/2002 6 50.07% $9,453,269.86 $9,453,269.86 1 -30 days 4/02/2002 - 4/30/2002 0 0.00% 31 -62 days 5/01/2002 - 5/31/2002 0 0.00% 63 -124 days 6/01/2002- 7/31/2002 0 0.00% 125 -275 days 8/0112002- 12/31/2002 0 0.00% 276 - 640 days 01/01/2003 - 12/31/2003 0 0.00% 641 -1006 days 01/01/2004 - 12/31/2004 6 15.77% $3,000,000.00 $2,977,660.00 107 -1371 days 01/01/2005 - 12/31/2005 9 26.28% $5,000,000.00 $4,961,860.94 1372 -1736 days 01/01/2006 - 12/31/2006 2 5.25% $1,000,000.00 $991,070.00 1737 days and after 01/01/2007 - 1 2.63% $500,000.00 $496,405.00 Total 24 100.00% $18,953,269.86 $1800,265.80 Page 1