Loading...
HomeMy WebLinkAboutItem FCITY OF SEAL BEACH ADMINISTRATIVE SERVICES DEPARTMENT MONTHLY INVESTMENT REPORT FEBRUARY, 2002 January Cash and Investments: February Cash and Investments: RDA Funds Trust and Agency Funds Assessment Districts Capital Projects Water Fund Sewer Fund Special Revenue Funds General Fund 4,900,184.41 214,913.37 (4,682.97) (2,726,458.86) 3,153,114.33 1,325,372.23 2,074,348.74 10,055,566.82 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 7,205,566.82 Page l $18,517,211.98 MONTHLY INVESTMENT REPORT MONTH: February-02 Page 1 %of Yield Earnings Earnings Interest Purchase Type of Investment Institution Investment Term: Portfolio Allowance Accrual Received Price Current Value Checking Bank of America open 3.10% 2.000% $172.92 $588,425.68 $588,425.68 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.0001. $9.09 $10,493.75 $10,493.75 Section 125 Public Commercial Wells Fargo Bank open 0.03% $1.98 $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 41.21% 2.967% $19,350.74 $7,826,387.68 $7,826,387.68 Investment Fund Agency Issue Federal Home Loan 10/25/2001 10/25/2004 4.000% $1,666.67 $500,000.00 $501,093.75 Bands Agency Issue Federal Home Loan 3/28/2001 9/28/2004 5.400% $2,250.00 $500,000.00 $501,250.00 Bonds Agency Issue Federal Home Loan 1/9/2002 7/9/2002 4.080% $1,700.00 $500,000.00 $501,093.75 Bonds Senior Notes Bear Steams Co. Unsecd 4/19/2001 7/15/2005 6.2509/6 $2,604.17 $500,000.00 $519,188.99 Agency Issue Federal Home Loan 11/8/2001 11/8/2004 4.000% $1,666.67 $500,000.00 $501,250.00 Bonds Agency Issue Federal Home Loan 12/6/2001 6/6/2005 4.065% $1,693.75 $500,000.00 $498,437.50 Bands Page 1 MONTHLY INVESTMENT REPORT MONTH: February-02 Type of Investment Institution %of Investment Term: Portfolio Yield Earnings Allowance Earnings Interest Accrual Received Purchase Price Cancer Value Agency Issue Federal Home Loan 10/11/2001 10 /11/2005 4.450% $1,854.17 $500,000.00 $499,531.25 Bonds Agency Issue FFBC Bonds 6 /14/2001 6/14/2005 5.560% $2,316.67 $500,000.00 $505,156.25 Agency issue Federal Home Loan 9/11/2001 3/11/2005 5.020% $2,091.67 $500,000.00 $500,468.75 Bonds Agency Issue Fannie Mae Medium 9/6/2001 9/6/2005 5.060% $2,108.33 $500,000.00 $507,187.50 Term Nate Agency Issue Famie Mae Medium 10/15/2001 4/15/2004 3.550% $1,479.17 $500,000.00 $501,718.75 Term Note Agency Issue FFBC Bonds 10/29/2001 4/29/2005 4.125% $1,718.75 $500,000.00 $499,687.50 Agency Issue Federal Home Loan 11/16/200111/16 /2005 4.140% $3,450.00 $1,000,000.00 $990,000.00 Bonds Agency Issue FFBC Bonds 12/6/2001 12/612004 4.250% $1,770.83 $500,000.00 $500,156.25 Agency Issue Federal Home Loan 12/20/2001 6/20/2005 4.800% $2,000.00 $500,000.00 $500,781.25 Bonds Agency Issue FFBC Bonds 12/4/2001 12/4/2006 5.100% $2,125.00 $500,000.00 $500,156.25 Agency Issue Federal Home Loan 1/11/200210/11/2005 5.060% $2,108.33 $500,000.00 $501,718.75 Bonds Agency Issue Federal Home Loan 1/2/2002 1/2/2007 5.180% $2,158.33 $500,000.00 $507,500.00 Bonds Agency Issue Federal Home Loan 2/26/200211/26/2004 4.000% $1,666.67 $500,000.00 $502,031.25 Page 2 MONTHLY INVESTMENT REPORT MONTH: February-02 %of Yield Earnings Earnings Interest Purchase Type of Investment Institution Investment Term: Portfolio Allowance Accrual Received Price Current Value Bonds Agency Issue Sallie Mae Medium 2/14/2002 2/14/2005 4.230% $1,762.50 $500,000.00 $502,500.00 Tenn Note Total Agency Issues 55.50% Subtotal Cash and Investments available for designated reserves and budgeted expenditures: $18,992,358.07 Prior month subtotal Cash and Investments available for designated reserves and budgeted expenditures; $18,517,211.98 Held with Trustee for 800 MHz: Federated Treasury U.S. Trust 1/1/2002 1/31/2002 5.400% $188.35 $140,436.84 Notes Project Fund Held by Trustee for 2000 Sewer COP's: BNY Wesmm Trust Company Project Account 1/1/2002 1/31/2002 4.60% $41.21 $2,317,220.28 Held by Trustee for 2000A for RDA BNY Western Trost Company Reserve Account 1/1/2002 1/31/2002 5.51% $35.45 $719,971.93 Held by Trustee for 200011 for RDA BNY Western Trust Company Reserve Account 1/1/2002 1/31/2002 5.51% $3.75 $66,796.38 Total Investment Portfolio 3.90% 2.00% $21,450,015.19 Page 3 MONTH: February-02 MONTHLY INVESTMENT REPORT %of Yield Earnings Earnings Interest Purchase Type of Investment Institution Investment Term: Portfolio Allowance Accrual Received Price Current Value In compliance with the California Code Section 53646 and Resolution Number 4552; the Treasurer of the City of Seal Beach hereby certifies that sufficient investment liquidity and anticipated revenue are available to meet the City's budgeted expenditure requirements for the next six months. Investments in the report meet the requirements of the City of Seal Beach's adopted invesunent policy. Respectfully submitted, Pamela Arends -King —4:r Director ofAdminig native Services/Treasurer Imo, Page 4 Aging Interval CITY OF SEAL BEACH ADMINISTRATIVE SERVICES DEPARTMENT MONTHLY AGING REPORT FEBRUARY, 2002 Percent of Date of Maturi Investments Portfolio Current Book Value Current Market Value 0 days 3/01/2002- 3/01/2002 6 44.50% $8,451,450.33 $8,451,450.33 1 -31 days 3/02/2002 - 3/31/2002 0 0.00% 32 -61 days 4/01/2002 -4/30/2002 0 0.00% 62 -153 days 5/01/2002- 7/31/2002 0 0.00% 154 -300 days 8/0112002- 12/31/2002 0 0.00% 301 -667 days 01/01/2003 - 12/31/2003 0 0.00% 668 -1033 days 01/01/2004 - 12/31/2004 7 18.47% $3,500,000.00 $3,508,593.75 1034 -1399 days 01/01/2005 - 12/31/2005 11 31.72% $6,000,000.00 $6,024,657.74 1400 days and after 01/01 /2006 - 2 5.31% $1,000,000.00 $1,007,656.25 Total 26 100.00% $18,951,45033 518,992 ,358.07 Page 1