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