HomeMy WebLinkAbout2001-06-26; City Council; 16240; Report On City Investments May 31, 20014B# lb, a$@
LIITG.
IEPT. TRS
TITLE:
REPORT ON CITY INVESTMENTS
AS OF MAY 31,200l
CITY OF CARLSBAD -AGENDA
CITY MGR:
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 May 31, 2001 is summarized below.
(1) The cost of investments adjusted for amortized premiums and discounts.
(2) The amount at which the investments could be sold. Source of market values is
Union Bank of California’s custodial report as of 5/31/01.
The equity portion of the various funds in the market value of the total portfolio is
summarized below:
Fund Eauitv in Pooled Investments I
1 Cash Balance bv Fund: I I
Debt Service
Capital Proiects
I Enterorise I 107.6:
t Intern’al Service I 12:577:816 I Aaencv Funds 10.753.489 1
R&onbling Adjustments 3:639:465
Total Treasurer’s Investment Portfolio at Market Value 369.044.512
Fund equity balances are restricted for various purposes as listed above. See Exhibit 7
for a more detailed breakdown.
PAGE TWO OF AGENDA BILL NO. 1 b ! a@
Pooled Investment Interest Income
*The cash income received is adjusted for any accrued interest purchased.
Pooled Investment Performance/Measurement
March 2001
April 2001
June 2001
Average Life
/Years)
1.52
1.61
1.84
Average Yield
6.23%
6.12%
6.05%
Modified Duration
1.36
1.43
1.62
All pooled investments have been made in accordance with the City’s Investment Policy adopted
January 2, 1985 and last revised January 9, 2001. 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, a change in the credit rating subsequent to a
purchase, or a temporary reduction in total portfolio assets. 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. Investment Portfolio Breakdown By Amortized Cost, Market Value, Cash Income, and Average Yield
2. Investment Portfolio Breakdown Of Maturities
3. Yield Comparison Graph
4. Cumulative Cash Income Graph
5. Fourth Quarter Transactions
6. Detailed Investment Report
7. Fund Equity in Pooled Investments
8. Corporate Note and Commercial Paper Ratings
9. Percentage Weightings By Corporate Note Issuer
EXHIBIT 1
9 z
s z
0
0
0
0
0
s
8 d
8 6
0
0
0
0
0
8 d
8 d
0
0
0
0
0
EXHIBIT 2
0
e
0
0 k
EXHIBIT 3
EXHIBIT 4
t
EXHIBIT 5
888888 dddddd 888888 Q o- d d d ui d - 8888E:8 z d ; ‘.j ti *i ti -
8888 88 88 dddd dddd 8888 8888 QQgQ s d d d d g g g g - - - - - 8888 ti ; Oj ; 9 9 9 9 QQEQ : NWrN ; cu’ ; ti - z
ssss ssss ssss zzzz zzzz zzzz
8888888 ggggggg
9 9 9 9 9 9 9
8288888 9 9 9 9 9 9 9 NNNN(3c)N
fmsw!s IZZZIIZ LLLlLlLlLlLl.L
8
EXHIBIT 6
x co0000bca0mb0m0*0m~m0cooowo~omo f-0000~~0mxn00000~rt00oot-ot-omo ce0000b0~~mmmoco~000co0oooo
~~ddddd~dd~.d~.ddddddd~~~~~~~~~ ~9999'9""999"~999~99999
rf-0mw0mNN000N0r-N~m~0~000000~b ~~~~0m0~~0~~00~000~0ooww
w N 0 m 7 m '0 co - IC y w- we o- N- (4 -a- rn- N-O- N- y b- we o- o-o- rn- ~9~ (9 I‘- o- N-O- 8 cowwmc9rm00 colcmcuww~oc\I ;s 00wr-000Nw
om G CC d d -- ui mm d ma ln w 0 bm om om om (4 T-
bm*o(vocnom~ % w m co 0 - (0 co m 10 co b f- 0 co m m w (0 v) Ic cD m co mm6t-6 ddrn-ddo-~-~-rn-~-; ~m~~wt*om~~~0ww0~~~~w~w~~mmmm~~o~mo~~ 8 CE838 -~~y~~--~~ym~~q~-~m~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
01OOOONWW ~bW000b~N~W00000COt~~~OWWO~OC.OO~~OOWO b0m000m~mwr-00w0~0m0*moooor-~~~~~ % 8PM888t3 8 8828
oooooowov)m 00W000t0~~8000000W0NWOW 000m00m0w--0000000000ooooo~ow*owoooooomooowo ~omowooooowoo~oqqq~q~~~~~~~~~~~ dd~ddd~d~ddddd~dd~dd~~~~~~~~~~~~~~~~~~~~~~OOOWWONOOO~W
$8 r~0W~O~WOrO~t~~WNNOOt 8 % oooNbomooocob OmNWtOW~O~~WW~~~W000~ CO--N 0 b 0 - m~o~w~o~o~u-~b~co~ ; < CO- .-- O- 6 d W- + cd d U-j cd O- ti wf rc‘ < ; rc‘ c d C,,- oi O- d cd O,- ‘.i W- ,-.j cd < d c‘,- d (d hi 0‘ 00‘ cd ci d cd ; cd ommooocommmw 9Q?o-t9999m o?qch 8 wowmmmwmoommoc4r-mwm s 838868s mowmmoatmwommoommo~m~ 8 m-cvmomtm~coNObNN m m m m 0 w m m m 0 m 0 m m~m~m~o~m o~o~rn-~~o~ --F70003- N N c- &W-ti,-i~- ,--& ,-.j .--‘-6; 0‘6; (? r dti,.j;titi;;.--.--d;C.j --P%-PI NNWVN
888800000000000000000000000000000000000000000000088888 000000000000000000000000000000000000000000000
dddddddddddddddddddddddddddddddddddddddd~~~~~~~~~~~~~~ 000000000000000000000000000000000000000000000000000000 9999999999999999999999999999999999999994~~~~~~~~~~~~~~ oooooowoooooooooooooooowowoooooooooowooooooooooooooooo oooooooooooooomooowoooo~o~oooooooooooooooooooooooooooo 9 9 9 9 9 9 7.9 9 9 9 9 9 9 t 9 9 9 k 9 ". 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 k 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 Y 9 -NNmOmr-*~NNWNNN-rNO~~N~~~N~~N~~~N*~~NNN~NN~NWN~~NNW~N
II
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu
Y
B i2R8f8 ;s o~~moo~o~wmmmo~o~~o~w 7 7 0 F 0 0 co 0 m o- a, N- w- v- vm t-- ‘-- v- oe v- N- N- N- be T- we me mm r--n! Y r - v-4; T-- T-- G- T-- ; ~-~r---r~rr~~r-r~~r~~~~~~~~~
8 woooot-womb ~oooowwoc9w 8 momom~m0w00w0~0m0 0000w-t0000b0r-000 i?8888$8ZZ~i?2~8~M888F?88888 ~~ddddd~~d~d~dddd~dd~~~~~~~~~ -~OU-,WOWNNOCQONObNWWWOVOOOOOO~~ ~dddd~d~~~~ddd~ddd~ddddd b0~0twvw~mrc900 9: ‘? 9 “. --e Or 9 00 7 ” r0 u? pl9 “! ‘4 9 =‘e N 9 -i “? I‘. “? 9 9 4 9 0 (4 r- 9 ‘Y 9 9 ‘? ‘-t ‘J-t n? (4 v? ‘4 9 n! 3 OOWbOOONW wwc9b000wr
XFi88~~~83~%wrnwc9wvmorn ~mwo~wwmww~~owmmfww~wmw~w~womwwo~~~~~~~~~~~ ---7tmu3~0m~~~~u30~~*mmmmwwo~-mo*~m~~o~w ‘T: Y. N “! “‘m N. ‘-m T. ‘-? 0 N. ? (4 ‘3 a? n! ‘-s N. ” 9 =? LD. 0 T ” ‘? P ‘2 (4 ‘4 =-I =? Lo c? ‘4 (4 9 “. c? c? 7 0 ‘4 n! 0 h! “. c9 ‘-. Lo r0 S Y “? rNN0~0rr00NNWNNN-rOm~~N-~~N~~NVV~N~~NNNNWNN~NWN*~NNWWN
oooooowouamo 00ul000t0r-r-0 8 00ce00m0m--00000000 00000W0NW0Wr0m0U,0 8 000000r0wm ooolnoovoow 8 xi888888888838 dd~ddd~d~~dddd~ddddd~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ wwmwoowv vovmoo-m 23 ~8~~8~~~~~~$8~58~X~%~~~~~~~~~~~~~~~~~~~~8~~~~ G rc‘ 6 G d d ai u-i + 16 0-i u-i cd d r.i 4 rc‘ 6 G L r-C 6 oi oi 6 16 cd oi ti ~5 ni ti rL u-i ai d ~6 ti 0‘ cd ti t-6 6 cd G cd
NNrNVNNr rNN-t-2.- OCO- t-Q.-VONrNOr---VrN
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu
wmm0w00mmmmmm0m0mmmmmmmomom~mbmmmomommomwowmmm mmmomoommmmmmomommmmmmmomommmmmmmomomm mmmomoommmmmmomommmmmmmomommmmmmmomomm8~~8~~~~o~888~8~ 8 mooom-m
%--;;;;;;;s--3--;;;7-;;T--;T-- ;
v-u-im-cic5w-c6cici~o-c.5m-;cciojo-ciLn- bWCJN,.,.?WNFromNm.-oat t m 9 ~9 m v? o? m r- a3.9 (4 T. 9 ro g 9 F rc C’-,NN000Wt000NW0NW‘-‘-,Wt
wooouJbl+obwo I 88828 oi$$ 7 0 ” m rc F- 3 Gddd&titidduid ‘$g~cr&g~tr&w~cpm~~~~ rVN”-,bWO 8 -!Y99hQ?997-!9 3 N t- meNmOmNvNm 8 OOFb 88
W.-N.-,-I-rbNrNOON room twwmwwmw~wwwN-mww-rnN-q F Y-F
~~~g$~*-e-?*-e-?-e***-ea* 5 0000000000000 booooowowwwowmo bbWU-,t-JWNNONWNWW088%~ 8 Fs9vss?999ks9r99999 uJwwbu3uJwwwwwwwwwwwww cd
8 .qgFs2$ woooooooouaoow k94?9999Ck99k ? wmoNooool-woow
=LOh’-~q=tN-tsN O’-?kN.“.cu.9k.k --Nrwoomm mv)booomw e99~99oz99~~e999e9e Nr.-NC9COVONNNrON-t00CQ- - 8
888888888888888 3 s dddddddddddddd 00000000000000 8 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 4 9 ooooooowooooooooooo oooooooooomooooooow 8 9 9 9 9 9 9 9 k 9 9 m 9 9 9 9 9 9 9 (4 0-t C+,NNC~O-,L-QWO-,C’,C~NNVC~NWV,VC, 8
I!
aaaaaaaaaaaaaaaaaaa uuuuuuuuuuuuuuuuuuu
0000000000000 NNNNNNNNNNQNNNQrr2Q saii5i3a~aiiiaam~za -WNNO -.--rNNNNN-N-.-ON.---O . . . . . . . ..r......ww. tf-wwmmo----3--7~m Lo
z T--
,
;sp Q d
a k
t
4
88$wboomwww r-w000~0wt-0m~-m~~-i-wm1-
dti+dGddidILd ‘99’?-!79199
v-NV)Ot-mwr V)WrNlcrWrCOW Nwwmvrwc9F)r
0 N N c) r 10 .--V-.--t-?N-V--- ,-.j .-- .-- ; ‘-.j ,Yj N r F N r r N ;,--;;;;;
00000w0r 999999Lno9 8 8 88 2g88888888 ooowowNmd~dd~dd~dddddd
8~868~~~X~~~~8668~8f~~ d ; w,‘- (d Pj W- b-i ‘6 ; =f -<&“itXi<dti,-6d;,“-Uj
8 mom-w-vw ~oor-rnwwwmrn~3-
ni m o~o~o~rn~u~ w~qm o~o~~-w~rn ~~o~o~o~~~o~w .-.-NV FF N-rr F--F-F
00000000
99999999 8 888888 8 888888
ooooooooddd’gggddddd 00000000000 8 8 999999999999999 ooooooowowoooooo-do-ddo-o- ooooooomo~ooooooooowoo O- O-O-O- OS O- Lo b- Om W Om Oa Oe (4 Om .-- O-O-O- “? ON “3 NrrrNN rr Nr.-rrrrrrrr
rrrr~rrrrrrrNNNNNNNNNN 000000000000000000000 000000000000000000000 8 NNNNNNNNNQNNNNNNNNQQqQ . . . . . . . . . ~woo~~w~~~~~~~~~~~rn~~~ wcyQ~zQ=::: ai;ji;iee bwwmmmo-F-7 ~ZZ$OO *wwwm-rr
886~~8~~8686566~888868 mmmmmommmmmmmmmmmmmmmm --~--Nrrrrrrrr-rrrr-rr
o--wowtoP-m 9Ta99k(99a! 8 cot-omboomc90 3 w--r-t-w000m00w ~rro?~~esqc?@? uJ~oo~*oNwmwd~ .9'9eqY9999-=?k
W000rN00,.0WWN ;5 m u? 9 9 7 t 9 o? (4 9 0 (4 t a, 9 00 m m a? ‘4 9 7 -c lcvvromooww
m r N m 7 m w m w m N 0 LO w 0 b 10 N m F Y r- w dri~d~ddddc6~d NNWWW~WWWW~~mrmV*Wwr~W~o~owwwWomNo~ Wm W NV V-t?- W We 0 We be ‘Ye W- V- V-N- We N- NW N- ‘1 C’-- N- b- I‘ (4 ” Vs Om Om ‘T- mm “O-N- Wm mNrNWNNWrmrr~N-mNNNN-VV~*N*WN
wmOwNlcmw lcOWbWOWWN mI-~~wwNwwoow
09s9r-sE9=!v! T”‘-‘-rc‘?9c?‘” $g$dNVOOOWWWdmwW
“99kYF9YS99k NWbrWWW0NOOm rNmwmr-bNwb wrwl-wwtwt00w
3888 WOONOOOO NVOONNOO ~00~0t0www0b 8 ooov)wv)mooo oowoi-om~l-ow 999rnc?T~.qqq
h 88 888888888888888888888888888888888 ddddddddddddddddddddddddddddddddddd 00000000000000000 ooooooooooooooooo8ooooooooooooooooo 00000000000000000 - d d d d d d ui d d d d d d d d d d d d d d d d d + d d d d d d d d
000000l-000000000000~0000~00000000 p- 9 9 “! “! 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 7 9 9 9 9 9 9 9 9 mN-NWNNW-m-rmN-ONNNN~~~~~NNVN
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz 00000000000000000000000000000000000
N.-N
0000000
mmw00m0mm0mm000000~00-00-00000~~~-~ mmmoomomm
Fund Equity in Pooled Investments
AS OF MAY 31,200l
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
Total
Total
Internal Service
Redevelopment Funds (1)
Agency Funds
Misc. Special Funds
Total General Ledger Balance **
Reconciling Adjustments
Total Treasurer’s Investment Portfolio at Market Value
60,765,752
29,721,366
1,962,522
10,647,503
5,762,441
30,538,874
7,764,117
I I ,630,370
7,015,503
66,523,387
2,102,431
141,984,626
46,655,064
55,667,455
3,304,067
2,012,886
107,639,473
12,577,816
0
10,753,489
0
365405,046
3,639,465
369,044,512
(1) Redevelopment Fund Balances are interspersed throughout all funds.
** Figures based on best estimate at the time report run on 6/7/01
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF MAY 31,200l
CORPORATE NOTE AND COMMERCIAL PAPER RATINGS
Corporate Note Investments Meeting the Current Investment Policy:
(Ratings must be AA or better by both Moody’s and S8P)
ABN AMRO BANK
ALLSTATE FINANCIAL
AMERITECH CAP
ASSOClATES CORP
BAYER CORP
BAYER LND BANK CITICORP CITIGROUP COMMERCIAL CREDIT CO
DEAN WITTER DISCV
DUPONT
GENERAL ELECTRIC CAPITAL
HEWLETT-PACKARD
JERSEY CENT P&L
MERRILL LYNCH
MORGAN STANLEY DEAN WllTER
NATIONAL RURAL UTILITIES
NORTHERN ILL GAS
OHIO BELL TEL
PITNEY BOWES INC
SBC COMMUNICATIONS
SOUTHERN NEW ENGLAND TEL
SOUTHWESTERN BELL
TOYOTA
TRAVELERS GROUP INC
Moodv’s s(bE
AA3 AA-
AA2 AA+
AA3 AA-
AA3 AA-
E.i Ei AA3 AA-
AA3 AA-
AA3 AA-
MA AM
AA2 AA-
AM AM
AA3 AA-
AA3 AA-
AA3 AA
AA1 AA
AA2 AA-
AA3 AA
AA3 AA-
AA3 AA-
AA2 AA-
AAA AA1
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 by Moody’s or S&P)
NONE
Investments with Subsequent Changes in Credit Rating l
Moodv’s s4le
AT&T A2 A
BANC ONE CORP AA3 A
CAMPBELL SOUP CO AA3 A+
FIRST USA BANK AA2 A+
KAISER FOUND HSP A3 A
NORWEST AA2 A+
ST PAUL CO AI A+
WACHOVIA CORP Al A+
Latest
-Date
06/01101 AA3lAA-
03l25iO2 AA3lAA-
10101/03 AA3lAA-
12/03/01 AA2lAA
I IIOIIOI AA3lAA
03/01102 AA3/AA-
08/I 3/01 AA3lAA
07/I 5105 AA3lAA-
Carrying
2,000,000
999,650
4,799,395
2,002,580
883,283
2,619,599
I ,000,222
4,021,073
EXHIBIT 8
Market
2,060,000
1,019,970
4.978,780
2,019,090
888,414
2,659,530
1,005,190
4,150,640
l The Ciis Investment Policy allows the City Treasurer to determine the course of action that would correct exc8ptbns
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.
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF MAY 31,200l EXHIBIT 9
PERCENTAGE WElGHnNGS BY CORPORATE NOTE 1SSUER
ABN AMRO BANK
ALLSTATE FINANCIAL
AMERITECH CAPITAL
ASSOCIATES CORP NA
AT&T
BANC ONE
BAYER
BAYER LND BK
CAMPBELL SOUP CO
CITIGROUP
COMM CREDIT
DEAN WITTER DISCV
DUPONT
FIRST USA BANK
GENERAL ELECTRIC CREDIT
HEWLETT-PACKARD CO
JERSEY CENT P&L
KAISER FOUD HSP
MERRILL LYNCH
MORGAN STANLEY DEAN WITTER
NATIONAL RURAL UTILITIES
NORTHERN ILL GAS
NORWEST
OHIO BELL TEL
PITNEY BOWES INC
SBC COMMUNICATIONS
SOUTHERN N/EW ENGLAND TEL
SOUTHWESTERN BELL
ST PAUL CO
TOYOTA
TRAVELERS GROUP INC
WACHOVIA CORP
Investment Cost Percent of Portfolio*
4,228,884.98 1.16%
6,024,601.35 1.65%
l&43,969.81 0.51%
10,945,308.13 3.00%
2,044,620.00 0.56%
997,870.OO 0.27%
1,291,375.00 0.35%
515.512.50 0.14%
4,695.372.02 1.29%
6,780,970.00 1.86%
4.197,556.00 1.15%
2,950.553.97 0.61%
1,168,073.48 0.32%
2.039,195.00 0.56%
4,005,826.08 1.10%
7,301,835.93 2.00%
2,974,560.00 0.82%
954,187.50 0.26%
9,272.283.27 2.54%
8.108,636.88 2.22%
1,731,047.96 0.47%
715,349.40 0.20%
2,759.726.W 0.76%
1,947,308.26 0.53%
1,919.298.74 0.53%
4,058,275.56 1.11%
1 ,113,832.90 0.31%
1,053,950.00 0.29%
1,004,92o.w 0.28%
2,012,800.00 0.55%
1 ,105.341.85 0.30%
4,023,404.94 1 .lO%
Total Portfolio $364.736,806.18
l No more than 5% may be invested with a single issue.