Loading...
HomeMy WebLinkAbout1997-06-03; City Council; 14186; REPORT ON CITY INVESTMENTS AS OF APRIL 30, 1997I 8 9 J g CIT F CARLSBAD - AGEND BILL AB# Ir,ra6 TITLE: MTG. 6/3/97 REPORT ON CITY INVESTMENTS AS OF APRIL 30, 1997 c L DEPT. TRS CITY MGR: d RECOMMENDED ACTION: Accept and file report. ITEM EXPLANATION: The City’s Investment Policy requires the City Treasurer to report to the City Council 01 Council each month on the investments held. In summary, the City’s investment portfolio as of April 30, 1997 is as follows: monthly basis the status of the City’s investment portfolio. This report is presented - [ - Investment Portfolio (Cash and Securities) Current Month Prior Month Par Value Cost of Investments 180,384,088 189,191,072 178,725,372 187,765,022 Market Value (2) 180,291,445 188,853,027 Amortized Cost (1) 180,410,324 188,968,603 (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 Wells Fargo’s custodial report as of 4/30/97. P 6 9 6 dS 8% uo ZH DH - I Interest Income Current Current Income Month FYTD Month FYTD Month Prior Cash Income Fiscal 1,133,899 9,948,860 11,082,759 Year-to-Date Total Income Over The Life 26,179,907 27,539,290 Of The Investment If Held To Maturity G 0 0 PAGE TWO OF AGENDA BILL NO. 14; 1 f& Investment Performance 1 Average Life IYears) Average Yield February 1997 5.75 1.45 March 1997 5.83‘ 1.52 April 1997 5.80‘ 1.53 All investments have been made in accordance with the City’s Investment Policy adopted Jan 2, 1985 and last revised September IO, 1996. All investments were initially made in accord: with the City’s Investment Policy. Events subsequent to the purchase might have resulted in s investments not being in compliance with the current policy. These events are typically a chan! the City’s Investment Policy or a change in the credit rating subsequent to a purchase. See Er 8 and 9 for details. Investment portfolio has the ability to meet the City’s cash flow demands for the next six months. EXHIBITS: 1. Investment Portfolio Breakdown By Book Value, Market Value, Cash Income, and Avel Yield 2. Investment Portfolio Breakdown Of Maturities 3. Yield Comparison Graph 4. Cumulative Cash Income Graph 5. Second Quarter Transactions 6. Investment Report 7. Reconciliation of Fund Source to Investment Portfolio 8. Corporate Note Ratings 9. Percentage Weightings By Corporate Note Issuer , 0 0 Exh ib : 0 0 R 0 PI 3 z E 2 9 2 3 8 H m E5 n 3 * 0 E t" Q\ s 0" tn ii a 2 3 0 tl 3 8 M R a3 r3 s k E @ $ P P 0 % 0 G 3 E$ s 3 4 Fr R s 3 4 s k 0 0 Q b4 E 8 8 a3 9 g ?.E k a8 E 8s 2g I4 *- E !B L 3 k i I/ 4s 3 $1 u* 9 E WE 3k $L 15 34 .y 0 .I E s u 4 g .E 9 L A& 3 gl a aq U B k u Zl B 2 4 2 0 0 0 0 0 c3 u 0 0 0 0 8 0 0 0 0 0 2 0 0 0 co : 0 d 0 0 -? 2 3 0 h d F t- t- a, Y 8 00 2 m : d- P m co 0- ;A ji '", a* 3 rcI m m W 3 3 00 m m a* 3 hl :* 0 0 m 0, W m 2 co m m Q', g 0 m r- 3 ". 10 3 m 2 hl m t d W 3 m W m 3 0 m 3 m ** Ls 3 W m 7 3 CCI Ls 0 r- r c'! m 10 hl W d rcI z 00 ?5 0 0 M K 3 r- t" hl 0 0. 3 m m d x d * m " 30 m 8 3 b m 3 3 W d m, 3 m 5 co m '? 3 : 3 W 2- Q\ W* 3 d- 0 t" d m* ", 3 m * m 3 :* F hl d 0 2 d- m* 3 m * m :* F P PJ p* k 5 0 W 9 m 2 m t- 3 t- UY m 3 0, Q* m 3 m 0 3 0 00, 3 W m 0, an 3 m 3 0 m 3 0 00, 3 8 3 to In 81 "I v; 01 q co !I h m 7 30 !I m Y 4 m m 0 rcI u h s m h 2 s m m : h m z* 00 0, 3 3 €e i-" ", ry) m 2- 2 69 hl hl z- :* \3 00 €e 3 m * *.. 3 h 2- 00 w €9 I? c\1 m m co 00 €9 0, m* 3 rn GI 2 g m e 0 Exhibit ; 4 i5 k 0 rh E s I4 0 E 0 54 6 P !+ 8 5! e VI k 3 8 n +7 4 PI & z T k E 3 1 u; e 2 Q 3 4 v 8 e * s 0 E P of of 3 0- i rr) a 2 2 0 i3 Q SS$$SS$$ Vo* v.91 %:$:As $1 S 3mN3 8 8 s 3 $1 d 0 H 2 0 0 N m vi o\ N, :- vi m 2 o\, m m m 3 m 3 vi 3 N- W \o N -* m d vi 3 h 00, d- o\ :* :- c- N m 0 o\ 0 "p' 00, 3 4 o\ vi c: m 2- 3 W 00 w I 63 ~coovimccoc1 & * t-mm m $ M m~m 3 N m d In g 3 m ;* 8 00, 2 QI ; 2- vi N3 m w cc) 2 d 0 rnm 3 mmm N cocmm\oooo1 N s :* 2- x r, 0 zsn 2 o., P m :- 2 * 0- N vl 2 d 0 rnm 3 mmm N cocmm\oooo1 N s :* 2- x r, 0 zsn 2 o., P m :- 2 * 0- N vl CII ~. -I ~CONc-" 2 m"s;8g;:: 00 S mo\ 2;NP-om N vi E t' 3 o\- :e ", m, vi vi, m -c;+ W B z x ;!. 2- 2 2 2- B( \o, m H 2. 3 3 P-- 3 69 a\ b u 2le2Besq .kg4 Ya" E2 0 2 s V 4 c1 b 2 F9 0 0 Exh - z Ok m7 & ~% 4 +2 k 4& &E 2 8: 0 a2 0 3; n Es dE mE HA Om F L 4 I- Q) 7 \ 8 c, - 3 7 k a m e F 8 c, v) I I I 1 I II a3 I -. 1 ~cv~(oQ)oo~cDv) I- GGG ujuirriuiuj 0 0 Exhib i E" 0 0 a c! H m c6 r) + 0 el+ + w e6 E' 3 r) - c., 3 8 8 L 0 a, F4 F m s b J 3 fii [: F - cvoooCD*cv FF U "" - b :Q) rL ;? - i r- 6, -s (rz I ,7 i ,CD 0) 7-w I 4 L - CD 0) 3 -7 " - I e e Exhibit ".-r.00IC0"0 mmm~oo.Nom.-o "-doo-oV-d 0 0 m co k9 9kk (DWCDNO~~O~V- m """88gc8kg8 * w 7-0 om- + r N 8 00 " 2 m- 8 z? Fss 3 9 r mo ssz $2 ~.~.~".~"".~.-."" 2 " % u) 2 N. .-"NPT"PV" E51 dddtio-~6aKdm ?- ? ; 8 10 UJ gp W$ w 2$8S$$!$6$26 N N I- m. N. L" a. m. 0. W 0 F - m N- N- N- N. W- m- ---~OOICO--O o o I- mmm~oo~mm~o 9 9 m "dGid04&iGd 0 0 0. W(D(DN~~PCPVN o, - Ty gar; - UJt 00- $1 ddddo6dtim(D-d z E N m W? 0. -. IC. m. 0. m. .- "" rmm r g 5: $55 r 0 m- - 7 sssskskkss$. O~NOo00000m mmLowmt(Dm-om oooornwtnmr.~~~ dGdddddddGd Eg 2 I- k 8s sss k g 8 8E E68 s 0 s 3 BI :3 " T W 2 $2 222 2 0 0 0 2 0 2 0 OD In k 3; SF$ OOONOOONOOO 2 OOOUOOOOOOO 0~ddO00~0Od mmmmmmo~mmm mmmm.m~mo~m~mmm F -m -m 0 w VOlNVLlU7NNClt.b a a% ? 'T FJ QUl ONb 9 0 0 ~.fi~.Hamgazm~. x 2 8 E ;. E. ;. z z. $. 0 I- F 0 !. 6. 5. %. E. %. 2 22 $$$ 0 0 ? 0 9 0 - NN "7 s 0 00 OVIIC) s 2 5 - E ggggggggggg 20 IChIChOWtOONOIC s kk css mmmmom~~owom ddddddddd&d 0 00 e 0 0 s 2 * 0 v) 0 00000000000 00000000000 00000000000 ._ 0 + 8 00 H 00 888 0. 0. 0. 0. 0. 0. 8 0 0 0 00 000 x x E. x 8. E. 6 z- x x 00000000000 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0 0 0 0 mal 00000000000 Z' 0 0 ; ?;I ."."."~+.""+."."; h % 2 m T- s * NN NNN 0 9 $ ... E m D rn IC zzzzzzzzzzz d 9s d6d z zz zzz 2 2 m- -@I 666s64664s6 - 0 .- e - - 0 mama 228% 0) m g h hh ssg kt. 6 CPSCh 3 tVP"n ?2 5 $ ee ;?Q u) soy;^^: $ >> www 5 lolnlnln -*!+!ssg s!$skj2+" c "owdgg:? y "" $33 w &&&&P2&Y:s& lY mmmmdwmd+wm 3333>S3>Uh3 3 33 G33 3 U ss$si2sdsgs 2 $2 $22 F EF 52: N %%%:gE:g2$% 0 3 mm 33 zmv) 333 c q EEFE42E455E + 2-+ 02-I- 1 - wwww: WeP $? z(Dw A d ssss;%OmoW : n no !+!$ 222 sss $ h IC m rn K + s 8s > >> Q>> Q (D (DID K KK UKlY 0 mm 7 - lnln w 3 0 s KlYKKlYQKK~~lY 2 +2-+2-Kz2-Kmz+ a t 2 n z z K Err ZKK $2 eeeeeeeeeee h n8 z p- 2 L 8 22 $cJ$ K B 4 mmmmhomhm~m 0000-00t~~0 VtVVo~~WICmu 0000-000000 !g $5 IChh zgg h 2: $CP 2 g 281 CQQQQcQzcqQ I- $ 35 ww 0 00 2 - r m m v % m m bi.hf.r.bICr.hr.l. m h (Dm lD(Du) - eeeeeeeeeee % 6 r mmmICICOQWNP0 w K r Kg 121 VttVttttttV QePsecCcQQQ I- f ss sss E 5 5 z 2 $2 4 Of @J &$$f$$$$$$$ n .. ue n u "F'F 0 i &:. 3s ga ,L? $ 6:l g# Kj# K .,+ @$ u) c gg !?E 0 ?;$; g y ;i;: >$'? K w 00000000000 a e 0 00 000 $! z z a n 'I n 5 &;' z x: In ($ g !&, i e In= 3 Lg NNNUtWPICIC-P = :+t z &! .I.!: Pees?eQczcQe &, VVttttVtttV 0 ._ 0 *tf 00000000000 u) p: LL :& 81: * s fi :% * w z 5 ;Ai > % s Tap 2 s s -I :rp- a 2 2 FI4 22 2 e ,& 2 2 e "a z 2 2 0 0 Exhibit r - - - mmm-mwmrmwwr~~o-m~~mw~~o~~wmom~m~~~~~~~mmwmh~ 7 v w TC Io, ~~~ss~~~~s~ss~~~s~~s~s~~~~~~~~~~~~~.~.~~.~~.~.~.~.~.~. a c; gij r ."" 7" 7 ""~"""""~"""""~ r tom~~mommooom~~~mowm~oo~o~~ooom~moo~moombmomww ~~~~qqp.~qqq~~-~-tomm~oo~owmooom~moo~moomw~o~mm X C: c wmmo~QmmN~oh~-w~od~~~owo~~o~om~~~~m~oa~-~o~oo Cmo~rNwmm~ompmwNm~mmoo-ommooomowoommoo~~~~~~~ - N s' 3; ;6;;;; @j&+@j~"<.-""" "NNr"""~NN~"N"rNr" w N t- ~~~n~8~~ssx~s~gas~~qs~~~~~~~~~~~~~~~~~~~~~~~~ "dddidddN~d~Nm,~o~~m~~~~~~o~om~~~~~~oam~m~~oo : ? 3xgg~~~~~~~~~~~~~~~g~~~~~~~~~~~~~~~~~~~~~~~~~ 5 e c3 ~6! d~ddi;i~d~~~d~,~~~~~~~~w~~m~~~-~w~o~o~m~m~~~m~m~m~m~N~~~m~~~w~m~~m~ mmtowhtom~~~~Ntom~oQrmmm~~~o~mo~rn~o~~orno-~omm~~~ ~~~o~~oo~~~q~~v~vr~~~oom~~~m~o~o~oomm~~~~oa~.~- m P q Z N z b z 4 I/ "NOOON~~~~~NN,N,r~,toN.N.P.P~N~-.r~O~h~N.N~m~(D.(D~~~N~~~(D~N.~~~.~.~.~.m. 0. r ~~~hm~~~mcowb~~om~mmmmmo~~~h-o~moo mN~~P~~~9~~g~~W~~r9E~~~~~~~~~~~~~~~~~~~~~~~~~ 9 $ PO E m - z 7777~7~~~77777ss774~777777~777777777777777777 gggg~~gPgRgRggoogge~g~~gRggg~gg~gg~gg~ggggeR~ 8 7 0 s $51 ~d~dwddd~ddwdd~dd~d~www~wwwwwwd~w~www~dw~wwww ~mww~~mm~~~~r~~m~~mroo~~m~wm~w~m~~ooo~m-mmmm~ ~~mw~mm~to-~m~oobm~.~~~~~m~w~w~~~mmmmoto~~o--moo 2 r o K 2, UK ~oooooo~ooooomomqq-mm~~oooooowooomoooooooooooo tooooooooooooooomoommo~ooooooooooooooooooooooo 4 w' ~~mmhmmmooomommm~mmbmm "9mmmmwm~hoooomqqmb~mo~~~g~~~6~~~~~~~~~~~3~~~ .- : ~o~ddom~o~od~~d-oo~~~~oodooomodo~odoood~o~o~~ .-N " *- 0' N- " 7- r r NN r <<<@i<"-@i < N.- r @i 3 Q S~XKS~~~XXXXX$E~X42X~~~X~~~~~~S~~X~~XX~X~R~~X rPto~~m~mooo~o(~~Nommmrw~o~mwmmm~mmo~ooo~om-wmo 2 E 2 m (D za gg n-- Et I-n. Ed za ih I'LL $0 za >v) L a z 3 I OOOoOOOOOOOoOOOOOOCbooooooooooooooooooooooooo oo~o~o~oo~odoodo~o~~oo~oooooo~o~oodooo~o~oaoa OOOOOOOOOOOOOOOOOOPtooooooooooooooooooooooooo 5 21 n3 oooooooooooooooooom~oooooooohoooooooooooooooo ~~~~pph~$~~~090~~~b~~0~~~000~~00~~~~0300~3~0~ 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- w- a- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- OOOOOOOOOOOOOOOOOONNooooooooooooooooooooooooo oooooooooooooooooommooooooooooooooooooooooooo - 3 B 0 2 2 m L 2 IC oe h ww 4 % am $ggXgSggg $3 id j 0 e!? w 4 ,N$S s meaa a:: c?s>wh:sas SZm5Z& 0 z h "-Qh=yeaQ: gj 21% :& g w &=5 0 h - ? e ZP s '9 - dysn+$?!?!s?r- 51 A 2 $dgs l=eg po4~A==izs5q5zz~ o;$$$daQaQL=wd2~~i $2 &+,,,,, <;,zq=3 ,s5s$;<ww z&.E.j=XS ~g~~~~~~~~s~~~~~g~~,.,,-,,,,, e~ssmSsSa~~~~~~ss~eer-=bm~~~S~~~~~~~oo~$ ,mmm~ooaooe~~~'g~j~~~~~~88 aaa -3sgg s~,,,~znz~~~,,,nm3~j~~n~~~~~~~~~~~~-o~ msgz?azass:g:YY to 6$+kqNm$2N G7m-t,.o um2d2I2toNmhhmmTCm o"'~~~~~~s~9~~~~~_a~b~~s~~'9~~o~~~ .\o r"h$7Egg:: ~~~=Y~~tE~~~tEtEt~~Y~~~~t~t~~~~~E~~t~~~t=~~~t ;I ~~~~~~~~~~~~~~~~u~uuuuuuuuuuuuuu~ a~aaa~a~~a~~a~aaa~aaaaaaaaaauaaaa~a~aa~~a~a~~ UUUUU~U~~~~~ : e~e??!?e?e?eee?ee?e?e??ee~a?a~~~~?a~~a?a~a~a~~ NQtoNmmm*mmmNNNNOmw--mm-b~mo~~~-m~~~N~~~~m~~*~ h~mmm~~~~~~m~~~mmmmmmmmmo~~~~oo~o~o~r~~r~~~NN $1 P9CPP~CrPerrppy~=p??=~???~~~~??~?~??~~~~~~~~~ ~~88888~866n~~~~~~86~8~~~~~~~~~~~~~~~~~~~~~~~ v) &NO Oo~wmf~~~~~~mmmmjO~gmmmmazo~zoz ~SS"SmZl-JZ'$ do zoWgeu~ Olm"" ewsNAaoZz 00 ozaa-l~l z~gg~~~ 3u++nw+2"3 aW~W777Wm-==~~b0d=~==woma~ 3RbR3~~"mww9w$owmm~~~o~~~~~~~~~=s~ STw%: mozzQoas+777m"~. o~a:Nm+ a~~~zzz"e~nnss~saQ"nn~smN o-e~ o~ 0%; ,~,,on,=,-J=~~I~~~=oo,,,~~121L,,~I,=2,d=~l~,=~ ~~amm.~amm~a~a~~aa~~m~rnaa~aI~=ma~~aamma~~a~aa 0 oooww=-m(D,,tow h ww w mo p.9 3 g. mo m 0, " 9 ' m 08 g NI 2 < 5 z 3 v) bI m, Si 3; WL 3: O< 7. $i a(: >> 31 mLI ac 3; ee mu 3: EP hf e5 a1 2$ ?-, z w c ~~8~88~~~~~~~~~-wmm~m~--moo~~m~"hom~ow(~-owm~~ ............................................. 88888868~888bfg8861fff8~6~66~~88~~8888~8g~666 !?s wa z dl $55 ma mm~~h(~rwbhb,r-~~~-mmmmm~~m~-mm------r~mmrn~m~~ oO~-OoOoooOroOo-oOoooooooooooooo"ooooooo-ooo oc Ee ..."...."....==$?=~~?a~=~c?~c?=~~c?a~=~aa~~~c??! > z 0 e A ," N-~~~~~oN~NNN~NNN~N~~ d 5: g ~~-mmtm~~m~om~m~~-t~~ v ~a~~~~848~R6666S~~~8~~~ g ~N~~~-~IC~IC~IC~-~~~~-O~ Eij " mm~n-o~~~~mmmm~~.m~~.o~yo.mm.m. .- -7 r "" " mrbm~orNmmmmmm---~~~o m 00 o ONIC~O~~NONN~O~Q~~O~O~ ~~"mqo~.m~9ma!m~m~mqm.~o - 2~ 0 ON~~O~~N~~NN~~~N-PO~O~ 5 ~~~~~o~~oNIccIc~-~-~~-o tmmm*lno~-m~~~~~~~~~~~ E 00 8 bb~~~~-~~arnc~rnoorn~corn d~m~oww~~~~~~~~~~~~QQ wz'm~~~.-~cm~rn~~~~---,,_, m. 0.0. o. 9m.qrn~q~.~m~.bo-~op-,~~~o $$ C~NN~N~OO~M~M~M~~~~N~~- XX~X~XX~e~-9090e09~~tr o ". gg 99 g 9 ~~s~~R~~~~~~~ps~6~~$~ T"~.O"O-iTk09?T N.O"*. x PII~ m N---N--N~N~--;,N-N;~-~ n~Oorn~N~~;,~,~,,,~,66~~ 0 5" - m-t~oo~Nmmmomm~--mm~o IC 00 o ON~~O~~N~NN~O~~~~O~O~ ~mt~~gm-ornto-~~~rnto-~~h ~~rnm~rn~~-m~mm~m~-~m~-~ - ICO IC ~h-m~mm~~t~hm~t~~b~to~ a wo.m~m~mm~o~~m~oNmomm~m E. Sa$ c x%~~.~~~.S.sPg.~~.xa~~~%s~ m d m- d .j 0- m- 05 -- 0- 0- 0- 0- a- ui d d m- a- d ui - w~~~~~~~~~~~~~~~~~N~~~ E- .- N -~mmr~m-om~m~o-r-hpm~ .-w .-NNrNr Nr-rnmNm-N--. g ~~mo-r.mmo~rn~t~~b--~m-n N z """~"~~m9Nr"""mmmNsN0 " a!? a! 0lq"0m~Nm~Nq"qN-q0"0" I----- -rN E8 " z ~2~~~g2~2g~~~~~~~~~~~ g gg 2 2~2~g222~~~g~2~~2g22g =~1~mICmoc~hmmqqmqqqqq0"~ ~~~ddddmdddd,o~o~mmmmnmm ~~~mmN~wmmNo* 'OOLDNoNO* 4 LD g$ ~~ * 2 IC'hm-w~~m~otICmrmo~rO~ 2~~6~~6262a~~aE~~~$g~ a 0000NObONOmm00000t00O r 00 0 00000000h000000000000 ~~OQ~~ICO~~IC~OOOOON~OO NO N oooooooo~wooooooooooo ~=6~$86~898868686688~~~ m Na m mmmom~rm~~Normtoo~moo v) IC m ." 0- N' m- -- ui d d m- 0- f rc- m- 0- r m m o m wOqm.mqm~m.oo.oooqmmmmm.oom q qm r- mm~oooom~~oooomoo.qmo~ za >E" r "t""? - 7 r m 0 m IC r .-- 7- N- " -- " m- N- -- " -- 7- N r N t ID 000000000000000000000 0 00 0 000000000000000000000 2s 000000000000000000000 0 00 0 000000000000000000000 000000000000000000000 000000000000000000000 g gg 0 0000000OOddddddddddd~ WOOOOOOOOOOOOOOOOOOOOO ooddddddddddddddddood 0. 90. g. OOOoOOOOO~OoOOOOOOoOo 000000000000000000000 0- 0- 0- 0- a- 0- 0- 0- r; 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- Qs aAooooooooooooooooooooo 8 88 o oooooooommooooooooooo ; =! aao.o~o~oooooooooooooooooo o. 0.0. 0- oo~ooooo~-oooooooooo~ ~ >NN~N;~-N~;;;;;;--;;N-;-.; t et m ~;;;N.;;N~~N-.;-.;;N-;N;P.~ kQ n ~~~e~~~~~~~$~~sa~s~~~ ; gg 2 ~~~&~$$$~6~~~$~~~~~~~ ?5""""""""" z. z.2. N. m~m~m~~~o~mln~oommmoqo.-.qm. m &Dl - ~ za 0 zi CLL z: za IC" ~~~~>i=>mmmmmmmmmmmmm ~~~g%gs~~~~~~~~$$$$~m~ "oocICc""-"-ooooo naoooanananaoaonanw~~ .?*D'elDlnm.?*D'e.?.?*D'e 0 0 0 0 gg(I)(I)(I)mv)~~~~~~~r.~~- a &KdddK~K~K6666g$g$aya wwwww~---~~mmmmm~g~ ~~CCCCC~~~~~~~~dddN~~ >>00000>>t>>>>tt>~-~m (1)(1)(1)(1)(1)~(1)~~~~~~~~~~~~~~ nKZZZZZKnKnKnn~nnn~~d 9g39gg~~ggggggg~gg333 ~~~~~~~~~~~~~~~~~~~~~ mm~m~mmmm~mmmmmm~m~~~ keee?2eeeeeeeeeeeeeem ~~~~~~%~%~%~g~~%%%g~~~ I mmm 33 33>>3>3>3>33>33333c~c 2 3 v) L hm e: =a mr IC vm ww 33 00 II zz an 33 JJ i En ww IS aE 3 z 0 (I) 3 -I (Do -JJ< 1 2% i<Umw 1 8s 55 yc y a=ooz=S 204: m(9 awmm:=q zgog qzy 00 $5 -3 a.za--~s$o~$$~ an z gk~3ss.a ew ~o~:>w~zzm~,m $e,al r. "I-oUg$$ iJ 4 gezz J0-I e z ?NZZ8& 73 wS$a!3m an-ICwIC %55%y$$p;p3pb! 'aag~q~$~s~awgg; a~=-a~~ som2s=q$aiiu+?wQm w3zzt m(~)wnm-w--~~~moa -nNNwFa&3dN<3a~~; bza .,ma ;3u~~$sa"dgdLd .wnas&ww: gg$:4%gF~sgg$wK mo-L~aa( ~&~~~~~PI,,~(I)o.,,~~zzl =ooo~n woo$g &g; aa~zlar~~~z~~~8~sgs~~( ~~~8aCaoooa~naa88w8001 m~@u>>o+3F~tYmmYmoo( ~~~~Sa~ee~~s~~~%%a%~a! +oK= ain6ngg?N3=I PK~KnKnKnnnKnnnnn~nnnn oo >CCCCCCCCCCCCCCC.~CCCC aa zzzzzzzzzzzzzzzzzzzzz- oooooooooooooooooooooi I- WI c ecee~eee~eee~eeeeeeee ~a8~66666888888888g~~8g an ~~c~~c~~mmmmmmmmmmmrnmrnm~ ICr. hch~~r.~~r.mmmmmmmmmmmmmmc ~~~~~~~~~~~~~~~~~~~~~~~ ee 2s ~$~~~$~s~~~$~~$$~~$~~~ as ~~~o--N--NNwIc~NN~~~~~~ 000----0000000-00000oc e==9e=e~====oC~o=o=qC: or P z c 88~~86666666666666f66 ..................... IC+ w~w~mm~r.cc~~mmmt~~~~~~u Yo W mt~~omomt-tttmmmm~~t~o 2s =e eeeeee~eeee$e?eeeeeegs B=C=~=CeCe~==Cq$=gCee~ 9eee=e=e=CqqC=eeoe==e t~mmmm~mmmootm~m~t~-rp ~mmm-tm--~mm~~t~omtt~c 0000-00000000-00-000-c ~~1$8666~688898a88888~g~ ut 00 z 0 0 aaa"N0mtOtha I ~~.xa~~~.~.~.~.~.s~. ; l-X-l-7-l- lid """""" 7 00Pmt0r-00Pr.- (D m0-0~ N m oo~mmo-om~a- o qqqr?oq 2 2 w~o(~~o(~~(~r-mo.q-m zKw-do.N.r-o.m.m.m(Dm.P. a. m~m-q-. a. a- +3m~~m*mrnm~rnot 8 %ZZkS! E 6 ~~~~~.xzxzx~~.Lz z. mmq--o. --- m. "Z? z' g$$$$$uig&i$&js 6 zzvzz m m ZK (D "NP N ootm~or-oo~r- a ma-~v m (D $gg~~~gggz-pg f mmmmw ww.-.mm.okovwy7T q m*o*m 3 m 2 KOP~-~N-~O*~-~*VN~ NmnN 9 N. r2&88$84z2Ki4% F r m m 9?-.9?979"3'47 c9 '4rqqr??T '4 m. z z r- N z ssssssssss.?.? oooooooooogg g sssss s k I- m(DmmQ(Db(D(D(D~< 2 22222 2 2 I;~o~ss%J~~q~~:s r- Pm--- (DONNN (D O m m w K ssssgssssgss ; ;lz8rx8 $ m o,ZRS8Z~$4~4Se : 48888 g g wz?~.*.~.a.q(D.q?qo.m Q v.eqa-0. z. 2 ~~~gps%28s6z6 q7qmm.mo-o-a ij S~CG~ "0U)O Z. 4 >s"wN.-.- r r" za s "LN? 4 g &s Zd E2 00, n- +n Ern K kt5 za >w 000000000000 000000000000 w8g8888g88g88 2i888.88.S.88Z888 000000000000 K 3 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- > .- 7 N N 7 N .-- N- " " " " 2 2 a2 02 00 0 zzgz >oooo -J2z <ass ;ZZqO ,XS?S QQjZ %%Es ;:?q 88F(D 223k &&zg H2g 88;g ipgs looam rcmw ZZYQ 2 a 2 ZiR 0s 2 22 _I &6- J za"jy13 gs%n<i $gs;ZQ- $S?;Gs& 00 ~3%r23wN W~(DJ'W'ti3 g?=~~&.?nu Na:d2$kz TrnQ3aW2 muizrraocdE ;$<p&;y WW~Z~~W~ ~3~00~30 zno~marrz oooav)+o< nzuzuwzm g$qgz so0 w'?l=m -0 oz3<a=w 0 x 0. N. 0 e P m g z 3 (I) *POTO NNOOO LDkoko moomo -. 9 0. '4 0. mmomo moor-o m a- '9 " 9 "N* " !- z 3 0 0 2 5.5 g$ 9 Zn $@j %$kg4 8E.9;; 5g3s6 Y=a>, maE20 [L+ww <<so>- JPUUU la--- WOQ<Q 302ld m ? m N 2 m 0 r m 2 L 0 3 v) P- N r. 9: 0- m -. m m 7 7 2 2 z Q a (3 n ~000000000000 wI nzzzzzzzzzzzz 00000 c FFQ?QF?F?QQF ~u0000-00000~0 an 00000"""N w~mmrmmrmm~m zra"jzsss-.G2G>a ""0070"0N z ; Ep$$$z$zgz$ =Po6~:6ggggg=~ ~?Q?!?c4Qs??q2 > c dl z - 0 a 0 3 s E e U h 7 - 0 0 Exh Reconciliation of Fund Source to Investment PortFolio As of April 30,1997 Cash Balance by Fund: General Special Revenue Debt Service Capital Projects: General Capital Construction TIF PFF Park Development Other Capital Construction Carlsbad Municipal Water District Sewer Fund Solid Waste Golf Course Total Internal Service Redevelopment Funds (1) Agency Funds Misc. Special Funds Enterprise: 21,145,535 13,232,995 3,365,872 4,095,887 3,313,824 13,454,105 4,563,047 48,525,368 24,970,342 27,646,449 80,702 2,582,723 55,280,216 10,497,970 8,951,710 0 Total General Ledger Balance 186,426,527 Amortization of discounts and premiums Deposits in transit Outstanding checks Wire in/(out) not recorded Other Net adjustments per bank statement 115,576 2,426,500 Total adjustments 2,542,076 Total Treasurer's Investment Portfolio 188,968,603 (1) Redevelopment Fund Balances are interspersed throughout all funds. ** Figures based on best estimate at the time report run on 5/12/97. %Y OF CARLSBAD INVESTMENT PORTFOLIO 0 Exhil AS OFAPRIL 30,1997 CORPORATE NOTE AND COMMERCIAL PAPER RATINGS Corporate Note Investments Meeting the Current Investment Policy: (Ratings must be AA or better by both Moody’sand S&P) Moody’s - S&P ASSOC CORP OF N A BANCONE CAMPBELLS SOUP DETROIT SEWER DUKE POWER FCC NATIONAL BANK GENERAL ELECTRIC CREDIT KENTUCKY UTILITIES NATIONAL RURAL UTILITIES NORWEST PROCTOR & GAMBLE ST PAUL CO TOYOTA WAL-MART STORES WISCONSIN ELECTRIC AA3 AA3 AA3 AAA AA2 AA3 AAA AA2 AA3 AA3 AA2 AA3 AAA AA2 AA2 AA- AA- AA- AAA AA- AA- AAA AA- AA AA- AA AA AAA AA AA+ Commercial Paper Investments Meeting the Current Investment Policy: (Ratings must be Alp1 or better by both Moody’sand S&P) (Ratings of other debt must be AA or better by both Moody’sand S&P) MERRILL LYNCH P1 A1 Other Debt: AA3lAA- Investments Made Under a Previous Investment Policy (Ratings must be A or better) Prior to 2/13/96 Moody’s - S&P FORD MOTORS CREDIT SOUTHERN CALIF ED A1 A+ A2 A+ Investments with Subsequent Changes in Credit Rating * Maturity Carrying Moody’s - S&P Date Purchased - Value DIGITAL EQUIP BA 1 BB+ 11/15/97 A2/A- 1,007,589 DONNELLY A1 A+ 12/01/00 AA3/AA- 1,110,779 UNION PACIFIC AA3 A 03/15/01 AA2/AA- 1,999,771 * The City’s Investment Policy allows the City Treasurer to determine the course of action that would correct exceptions to the policy. All 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. @IT* OF CARLSBAD INVESTMENT PO a OLIO Exhibit AS OFAPRIL 30,1997 PERCENTAGE WIGHTINGS BY CORPORATE NOTE ISSUER Investments Meeting the Current Investment Policv (Percentage Less Than 5%) Investment Cost Percent of Portfo ASSOCIATES COW NA BANCONE CAMPBELLS SOUP DETROIT SEWER DIGITAL EQUIP DONNELLY DUKE POWER FCC NATIONAL BANK FORD MOTORS CREDIT GENERAL ELECTRIC CREDIT KENTUCKY UTILITIES NATIONAL RURAL UTILITIES NORWEST PROCTOR & GAMBLE SOUTHERN CALIF ED ST PAUL CO TOYOTA UNION PACIFIC WAL-MART STORES WISCONSIN ELECTRIC 8,039,266.00 997,870.00 2,062,700.00 1,014,980.00 1,053,390.00 1,145,610.00 2,048,020.00 975,690.00 1,957,160.00 9,108,300.00 2,024,340.00 3,019,970.00 5,066,190.00 2,256,561.60 1,000,000.00 2,042,260.00 5,530,503.57 1,997,320.00 2,491,325.00 1,000,560.00 Investments Made Under a Previous Investment Policy Percentage Limited to 10%) Prior to 2/13/96 Investment Cost NIA Percent of Portfo Total Portfolio $188