HomeMy WebLinkAbout1999-09-14; City Council; 15372; Report On City Investments July 31, 1999.
1 Q: . t
1
4B# 5332
VlTG. +j@‘i
DEPT. TRS
CITY OF CARLSBAD -AGENDA JILL
TITLE:
0 I
37 A I
REPORT ON CITY INVESTMENTS
AS OF July 31,1999
RECOMMENDED ACTION:
Accept and file report.
ITEM EXPLANATION:
The City’s Investment Policy requires the City Treasurer to report to the City Council on a
monthly basis the status of the City’s pooled investment portfolio. A quarterly report is also
required for the investments of bond proceeds held separately.
The City’s pooled investment portfolio as of the month ended July 31, 1999 is summarized
below.
(1) Of the $296 million in the investment portfolio, $42 million are General Fund dollars. The
balance of the funds are restricted for various purposes. See Exhibit 7 for a breakdown
of fund equities in the investment pool.
(2) The cost of investments adjusted for amortized premiums and discounts.
(3) The amount at which the investments could be sold. Source of market values is Union
Bank of California’s custodial report as of 7/31/99.
Year-to-Date l
*The cash income received is adjusted for any accrued interest purchased.
PAGE TWO OF AGENDA BILL NO. Is,3 3 ’
Pooled Investment Performance/Measurement
May 1999
June 1999
July 1999
Average Life
/Years)
1.84
1.89
1.87
Average Yield
5.59%
5.61%
5.62%
Modified Duration
1.64
1.69
1.66
All pooled investments have been made in accordance with the City’s Investment Policy adopted
January 2, 1985 and last revised February 16, 1999. All investments were initially made in
accordance with the City’s Investment Policy. Events subsequent to the purchase might have
resulted in some investments not being in compliance with the current policy. These events are
typically a change in the City’s Investment Policy or a change in the credit rating subsequent to a
. purchase. See Exhibit 8 for details.
The pooled investment portfolio has the ability to meet the City’s cash flow demands for the next six
(6) months.
EXHIBITS FOR POOLED INVESTMENTS:
1.
2.
3.
4,
5.
6.
7.
8.
9.
Investment Portfolio Breakdown By Book Value, Market Value, Cash Income, and Average Yield
Investment Portfolio Breakdown Of Maturities
Yield Comparison Graph
Cumulative Cash Income Graph
First Quarter Transactions
Detailed Investment Report
Fund Equity in Pooled Investments
Corporate Note and Commercial Paper Ratings
Percentage Weightings By Corporate Note Issuer
.-
is
4 z
0
0
0
0
0
6
s: d
8 d
0
0
0
0
0
2
8 d
8 d
0
0
0
0
0
3
Exhibit 1
Exhibit 2
%
Exhibit 3
z 0 m
r 1
&
4
e(
c
0
r)
n
1
Ia
a 7% xa W’
I # - f
2
-:
-k -a
-z -:
3 -0
-5 -7
-k -a
2 -:
3 -0
-Y -7
-k -a
-6 -F
3 -0
-3 -7
-k -a
-ii -S
-5 -0
5
Exhibit 4
t . . . *
,
I l . .
-2
. P E
- k a
. 5 E
.f
.g
8 P
s 2
z 0
9 cn
9 a
:
6
Exhibit 5
88
QE a a
Qg
-r- u-i-
2 0 8 .- P ; 2 j
-8 ti 8. fi5 23 > Ls I
$ s b I= 6 d ti
88 8
gg Q a- s
gBQ Q c9- w- ; r
888 ggg 88 8
9 9 9 QQ Q . ^ I 888 9 0 9 gg Q w cu-7 d m- w- r
8 8 8
z Q Q - s
Q Q Q G- ti ci-
Exhibit 6
*s *. ‘-e 9 N. OD - NY9N.SC”e--m.m.r.k mW~Or~~d~d~MNrWWWWOWW~ mw~uJmowrpuJw rCDONNWWO)OW ~~NNNrrOrrrmWNNrNNrrrr
goooooowo oooooowo Or-OOOOOONO rm00000000000 8888888880w00000000000000 9’.99999-.9 ocoooooobomoooooooooooooooo*ooooor-owoooooooooooo ~NNWNN~rm;;;W-~-N-N-N-;N-;~-N-N-N-N-~-N-N-~-~-N*~-N-~-N-N-W-N-~-W-W-~-~-N-~-~-~-N-~-~-~-~-N-N-N-N-~-~-
W
a
s
E W
O.-.-.-.-rrrrrrrrrNNNNNNNNNNNNNNNNNNNNNV,C,
~-W-;N-;;;;;N-;;N-;;N-;;; oi,-i,-i;.=.=;;Oi; ; %-- N-
*- kc- .F- ; ; +-- ; ; ti .-- .-- N‘;; 6; .-- .--
1 auuaaaaaaaaaa ILYYYYLILYYLLYL
qqsss
it!?? 666 39e $fg-$f ; tini
N- .-- ; ; ; ; ; .-- .-- ; ; ; N-
~~8 ’ 0’ . ui a$ c&J- g- ,- 9 *. m $j*o
?
:
f
f
c?*z ’ N 8
Exhibit 7
Fund Equity in Pooled Investments
AS OF JULY 31,1999
Cash Balance by Fund: General Special Revenue Debt Service Capital Projects:
General Capital Construction
Traffic Impact Fees
Public Facilities Fees Park Development Transnet Taxes Drainage Fees Special Districts
Other Capital Construction
Enterprise: Carlsbad Municipal Water District Sewer Fund Solid Waste
Golf Course
Internal Service Redevelopment Funds (1)
Agency Funds
Misc. Special Funds
87,028,195 11540,652
0
13,440,893 0
Total General Ledger Balance * 297,049,885
Amortization of discounts and premiums
Deposits in transit Outstanding checks Wire in/(out) not recorded Other Net adjustments per bank statement
Total adjustments (584,752)
Total Treasurer’s Investment Portfolio 298,46&l 13
Total
Total
42540,782 23,036.409 496,994
4,902,144 3,582,497 30552,532
7,203,076 12,226,227 6,243,114 52,203,070 2,053,270 118,965,939
36,911,455 44,621,870 2,328,303 2,966,566
46,594
(631,345)
(1) Redevelopment Fund Balances are interspersed throughout all funds. ** Figures based on best estimate at the time report run on 08/10/99.
-
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF JULY 31,1999
CORPORATE NOTE AND COMMERCL4L PAPER RATINGS
Corporate Note Investments Meeting the Current Investment Policy:
(Ratings must be AA or better by both Moody’s and S&P)
AMERITECH CAP
ASSOC CORP OF N A
CENT&U ILLINOIS LT
BAYER CORP
BAYER LND BANK
CITICORP
CITIGROUP
DUPONT
FCC NATIONAL BANK
FIRST NATIONAL BANK
FIRST USA BANK
GENERAL ELECTRIC CAPITAL
GENERAL ELECTRIC CREDIT
HEWLETT-PACKARD
KENTUCKY UTILITIES
MARGARETlEN FINL
MERRILL LYNCH MORGAN GUARANTY
NATIONAL RURAL UTILITIES
NORTHERN ILL GAS OKLAHOMA GAS & ELECT
REED ELSEVIER CAPITAL
SOUTHWESTERN BELL TOYOTA
TRAVELERS GROUP INC
WAL MART
Moodv’s s&p
AA3 AA+
AA3 AA-
AA2 AA-
AA2 AA
AAA AAA
AA3 AA-
AA2 AA-
AA3 AA-
AA2 AA-
AA2 AA-
AA2 AA-
AAA AAA
AAA AAA
AA2 AA+
AA2 AA
AA3 AA-
AA3 AA- AA3 AA+
AA3 AA
AA1 AA
AA3 AA-
AA3 AA-
AA3 AA
AAA AA1
AA2 AA-
AA2 AA
Commercial Paper Investments Meeting the Current Investment Policy:
(Ratings must be Al/P1 or better by both Moody’s and S&P)
(Ratings of other debt must be AA or better bv Moodv’s or S&P)
Investments with Subsequent Changes in Credit Rating l
Moody’s
AT&T Al
BANC ONE CORP AA3
DONNELLY Al
J P MORGAN Al
KAISER FOUND HSP A3
NORWEST AA3
ST PAUL CO Al
sgp
AA-
A+
A+
AA
A
A+
A+
Latest
Maturitv Date
06/01/01
03f25iO2
12/01/00
05/01/00
1 l/01/01
03/01/02
08/13/01
Purchased
AA3lAA-
AA3lAA-
AA3/AA-
AA3lAA
AA3iAA
AA3lAA-
AA3iAA
Exhibit 8
Carrying Market
a m
2,024,56 1 2,010,600
2,501,843 2,512,785
1,041,220 1,035,100
999,893 999,530
919,729 915,233
10,669,657 10,685,986
1,002,261 999,970
* The City’s Investment Policy allows the City Treasurer to determine the course of action that would correct exceptions
to the policy. All of these investments are paying interest at the required times. The principal of all investments are
considered secure. It is the intent of the City Treasurer to hold these assets in the portfolio until maturity unless events
indicate they should be sold.
-
CI’I - OF CARLSBAD INVESTMENT PORTFOLIO
AS OF JULY 341999
PERCENTAGE H?EIGHTmGS BY CORPORATE NOTE ISSUER
AMERlTBcHcAPlTAL
ASSOCIATES CORP NA
AT&T
BANC ONE
BAYER
BAYRR LND BK
CBNTRAL ILLINOIS LT
CITICORP
ClTIGROUP
DONNELLY
DUPONT
FCC NATIONAL BANK
FIRST USA BANK
FIRST NATIONAL BANK
GBNERALRLFcTRIccRRDIT
HEWLETT-PACKARD
J.P. MORGAN
KAISRRFOUDHSP
KBNTUCKY UTlLlTW
MARGARBTTBNFlNL
MERRKL LYNCH (in&da CP)
MORGAN GUARANTY
NATIONAL RURAL UTlLlTES
NORTHERN ILL GAS
NORWEST
OKLAHOMAGAS & ELBCTRIC
RRBD RLSERVIER CAFWAL
S0UTHWESTERNBlX.L
ST PAUL CO
TOYOTA
TluvRLBRs GROUPING
WALMART
Total Portfolio $2%,465,113.39
l No mom than 5% may be invested with a single issue.
&westment Cost
1,843,969.81
7,591,141.00
2,044,620.00
2,504,125.00
1,291,375.00,
515,512.50
1,014,650.00
1,006,100.00
2,013,580.00
1,145,610.00
1,168,073.48
975,690.OO
5039,195.oo
4,040,400.00
14,128,250.00
1,011,080.00
999,720.OO
954,187.50
2,024,340.00
1,023,210.00
8,915,960.39
1,995,580.00
3,727,967.96
715,349.40
10,756,869.00
1,012,500.00
2,020,720.00
3,084,830.00
1,004,920.00
2,012,800.00
1,105,341.85
1,522,920.00
Exhibit 9
percent of Portfolioa
0.62%
2.56%
0.69%
0.84%
0.44%
0.17%
0.34%
0.34%
0.68%
0.3%
0.3%
0.33%
0.69%
1.36%
4.77%
0.34%
0.34%
0.32%
0.68%
0.35%
3.01%
0.67%
1.26%
0.24%
3.63%
0.34%
0.68%
1.04%
0.34%
0.68%
0.37%
0.51%
/3