Loading...
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.