The URL can be used to link to this page

Home My WebLink AboutItem 4.04 Investment Report 4th Qtr CITY CLERK File # D[2]~[ll]-~[ll] AGENDA STATEMENT CITY COUNCIL MEETING DATE: August 21, 2007 SUBJECT: City Treasurer's Investment Report for 4th Quarter 2006-2007 Report Prepared by Paul S. Rankin, Administrative Services Dir. f~ ATTACHMENTS: Quarterly Investment Report For The Period Ending June 30, 2007 N: \R (i l>J'>'" RECOMMENDATIO~ IV Receive the Report ""'0"",_.,-.... FINANCIAL STATEMENT: See Report DESCRIPTION: The attached Investment Report ,details the City's investments as of June 30, 2007, in accordance with the requirements for reporting investments. The format of this report differs from previous reports. The modifications have incorporated suggested revisions from the PFM Investment Study as well as use of the new portfolio management software system. The changes are intended to add information which is helpful in monitoring the performance of invested funds. REPORT FORMAT The format ofthe report consist of the following components: Section 1 - Portfolio Information . Portfolio Summary (This includes the Par Value; Market Value; and Yield) . Portfolio Details (Includes a listing of individual securities and investments) . Investments By Type (Listing of Federal Securities including call date if applicable) Section II - Investment Charts Section III - Listing of Investment Transactions by Month FOURTH QUARTER RESULTS As shown on the Portfolio Summary the total investments as of June 30, 2007 were approximately $114.3 million. The Yield to Maturity was calculated at 4.681 % and the weighted average maturity of the portfolio was 901 days (2.5 years). The report also displays the weighted average maturity based on the Call date. If all securities were assumed to be called the portfolio average drops to less than one year at COPY TO: Page 1 of3 ITEM NO. tf 1- G:\Investments\FY 2006-07\4 June 2007\Agenda Report\Ag_ Stmt_ 4thQtr ~une2007 .doc 356 days. As noted in the summary the Market Value at June 30, 2007 was less than the Par Value. If the City holds all securities until maturity as expected, the full par value will be received. The following Table displays the comparative results based on information in the Portfolio Summary for each of the four quarters in Fiscal Year 2006-2007. COMPARISON OF PORTFOLIO MEASURES OVER FISCAL YEAR $118,018,682 882 days (2.42 yrs) 4.307% $114,590,968 909 days (2.49 yrs) 4.445% $114,290,811 901 days (2.47 yrs) 4.681 % As noted in the Table the total portfolio remains relatively close in size to where it was at the end of the third quarter. However, it has increased by approximately $3,247,171 since the end ofthe first quarter. The City has also achieved higher yields each quarter due largely to the economy and ability to invest at higher rates. Over the past year the average term has decreased slightly from 2.63 years at the end of the first quarter to 2.47 years as of June 30, 2007. INVESTMENT ACTIVITY DURING THE QUARTER Staff will continue to highlight as part of the Staff report changes in individual securities due to Maturities, Called Securities, and New Investments. A total of$12 million in securities either matured or were called during the quarter as described below: INVESTMENTS MATURED DURING THE FOURTH QUARTER FHLB FNMA FHLB Total $3,000,000 $3,000,000 $2,000,000 $8,000,000 04/27/2007 05/11/2007 05/18/2007 3.150% 3.250% 3.000% INVESTMENTS CALLED DURING THE FOURTH QUARTER FNMA FHLB Total $2,000,000 $2,000,000 $4,000,000 04/26/2011 06/15/2009 04/26/2007 06/15/2007 5.670% 5.375% 2~~ Staff purchased three new investments with a combined par value of $8 million during the quarter: INVESTMENTS PURCHASED DURING THE FOURTH UARTER FHLB 5/3/2007 $3,000,000 05/03/2012 5.020% 5.020% One Time 5/3/2010 FHLB 6/15/2007 $3,000,000 06/15/2012 5.560% 5.560% One Time 6/15/2010 FNMA 6/27/2007 $2,000,000 05/14/2010 5.080% 5.320% (Purchased N/A at a Discount Total $8,000,000 The securities which were purchased included two which have a one-time call provision in 2010. The types of securities purchased were selected to continue to diversify the investments among different issuers. All are AAA rated securities issued by agencies of the Federal government. The new tracking software will also simplify the tracking and reporting of securities purchased at a discount or premium. For example the FNMA security purchased has a coupon and pays interest at a rate of 5.08%. However, it was purchased at a discount which will produce an effective rate of return of 5.321 %. The financial records will account for the discount over the life of the security, instead of recognizing the entire discount at the time of purchase. These factors will be accounted for in the quarterly investment reports. In addition to typical expenditures during the fourth quarter, the City had cash flow needs to make several one-time expenditures or transfers of City funds totaling $16.9 million including: a) Acquisition of property for the Heritage Park ($7,865,000); transfer of funds to the CalPERS OPEB Trust ($5,468,611) ; and Pre-payment ofthe CalPERS Side Fund obligation ($3,569,754). This impacted the placement of additional investments. COMPOSITION OF PORTFOLIO Section II of the Report contains charts which assist with reviewing the portfolio. The Charts focus on key factors to monitor including the investment maturities as well as the composition of the portfolio. The following are key highlights of the portfolio: . At June 30, 2007 (41%) of the portfolio was immediately available in LAIF and Money Market instruments. . Federal Agency Securities represented 59% ofthe Portfolio. . The federal securities were issued by five different issuers. . 57% ofthe funds are invested for one year or less. . 16% ofthe funds are invested in securities with maturities of between 3 and 5 years. MONTHLY TRANSACTIONS Section III of the Report provides a list of transactions related to investments in the City portfolio for each month of the fourth quarter (April, May and June 2007). This is a new schedule in order to assure that the City fully complies with the requirement to disclose monthly transaction data. It is proposed to incorporate it as part of the quarterly investment report rather than individual monthly reports. In the coming months Staff will continue to examine opportunities to enhance the information provided. It is recommended that the City Council receive the report. 313 I~l\ CITY OF DUBLIN QUARTERLY INVESTMENT REPORT Fourth Quarter Fiscal Year 2006-2007 June 30, 2007 Presented To City Council August 21, 2007 Section 1 - Portfolio Information · Portfolio Summary (Includes the Par Value; Market Value; and Yield) · Portfolio Details (Includes a listing of individual securities and investments) · Investments By Type (Listing of Federal Securities including call date if applicable) Section II - Investment Charts Section III - Listing of Monthly Investment Transactions ~~-# Lf.Lf &1~IP7~ ATTA~BMENT_ - s::: Z (I) :J ~ co C) ::) C'CS C ; LL~ o 0 >- .- ~.E Ot:: o D.. ~r--. C'CSO EO EN ~o tJ)M o (I) s::: o ~ -'"") t:: o D.. :> 0.- _ :J :l!: C" I-w )-an CD C") .so; 11)0 >,-= l'll- O~ o ....= o~ ?fe. 0 Q. ~ CLl o :J 00; lD> ..... ~ ~ ~ ... = =-; ~> CLl :J ;0; ~> E ~ CLl I- II) - c CLl E - II) CLl > C l"- I.!) ...... u1 o ...... ('I) ...... ~ ('I) I.!) "<t ...... ...... ...... o CD ...... ...... N I.!) (j) l"- I.!) o N o ~ I.!) (j) C") I.!) co I.!) o ...... co N ...... CD CD o CD o co o ...... o ...... o co co "<t (j) co (j) CD (j) I"- ('I) CD co I.!) o ...... co N ...... CD CD o 0 o ~ o ('I) o (j) o ('I) co ('I) (j) 0 (j) co 0) CD ('I) CD co I.!) o ...... co N ...... CD CD o 0 o 0 o 0 o 0 o 0 co c5 (j) co (j) CD 0) I"- ('I) CD - Q) ~ "- co ~ >- Q) I:: o ~ u. <C ....J >- t.l I:: Q) C) <( ~ Q) "0 Q) U. ~ o ...... co CD ..j. CD an C") ...... o en ~ o o o c:i o ...... "I:t '<:I: N N CD an"' en N ..,f ...... ...... tIT co O'! C") o N ..,f ...... "I:t M ...... ...... tIT co an o ...... co o en N ..,f ...... ...... tIT 0; - o I- - II) CLl ~ CLl - C "0 CLl :J ~ (J (J <( "0 C l'll .e II) l'll o I.!) ~ "<t N o N ('I) I.!) ~ "<t N o N ('I) "0 Q) ::l "- t.l .t.l <( - C)(/) I:: Q) "- "0 Q) 1::- W I:: ('I) ('I) 0> ...... N c5 CD N ...... ('I) ('I) (j) ...... N c5 CD N co I"- ('I) "<t N N (j) N ...... co I"- ('I) "<t N N (j) N ro - o - .D ::l CJ) ll) .J:: E--< ~ o ...... co CD ..j. vi ~ o S .~ en - X ll) vi I::: I::: .s .~ .... ~ ll)"5 ;;. CO o ll) en .... ll)"O E ; ;.a VJ I::: ~ ll) <<l 0........ X ll) ll) ...... "O~ ll) () ...... ..... ~~ ..... 0.. .~ Cl::t ~~ ......"0 ll) I::: ll) <<l S >; o () ...... ..... CO ..... p... :s!i:J ;::l ll) .S' S ............ ~ en o ll) ~ ~ ~';;; ro~ ()~ ll) ;::l ~Q ;::l'+-< 0"'0 ~c <<l ..... ll)U "0 ll) ";; ;9 8;9 0.. ..... "~ ~ .... () ;::l I::: ~ .;S so. '+-< S o 0 en () ~ I::: ro ..... "0 ll) ll) ~ o:Ss ~ ~ :B S .zt; g ~ "- .S en~ '+-< i:J 0 ll) ll) S...... .......g en ll) ll).J:: ~ () ..... en '+-<"0 o I::: ll) <<l :is "0 I::: ll) ll) -5B en en ll)~ 15 .S CD an C") ...... o en N ~ CD CD co ...: co an_ an ...... ...... tIT CD ~ " "I:t "I:t cD o " ..,f ...... ...... tIT co an c:i ...... co_ o en N ..,f ...... ...... tIT CLl :J "00; c> l'll II) .e- ll) C ell CLl 0.5 0; :g - > o C I- ex err/I c\- o o ~ C'b~ ~~ Q ~ o E--< U gj ...... Q CIl ~ U ~ ~ CIl ~ > ~ E--< CIl ...... ~ ::8 . ~ ~" ~ II) - r:: - CI) a; E zE';) ..J CI) CLl co C) > ::) C'CS r:: C ~ LL==~ OOS >-:: CLl ~.EC Ot::O o 0 0..1:: o a. Ql Cl m a.. u> :E:; I-C'" >-W ll) '" o!! -01 "'U >-- 01': 001 :a: E '" I- "C'" "'- _01 010:: en ...... o o N o C'? CLl r:: :J .., '" '" "'.... 01 01 .<::0 e ::I a.. '" '" 0'" 01 C .. .. "'- > .. <(10 >-'" ........ 'i: ca EO 01 :a: ~ ~I ~ ~I ~I o 0 I'- 10 0", lri Lri '" ::I fti > ". o o 10 o co o 10 ~ M to '" ~ CD N 0- ; ~ (")- (f')R '" ::I c; > .... '" -t: .. :E o to o 10 t-..:M to '" CD N- 0- o .... '" ",- C')R '" ::I c; > .. 01 a.. o to o 10 r-...: M to '" ~ CD_ NO ~ ~ ~ M- CD CD o 0 o 0 ~~ o Q ;::: I'- o 0 .. '" ::I '" .!!! .2 :Q 1:: o a.. "' ;;: -g 0 ~ ~ ~ t '" ~ > ~ ~ ~ ::r (j) C (5 "0 t't1 () u: S o :E ::I 1Il 'It i: CIl .5 '" CIl > ..5 .... '" .... .... o 0 o 0 III 1:: :I o (.) (.) <{ - Ql .l<: ... m :1E >- Ql t: o :E .... CD .... .... o 0 o 0 00 iii >- >- 0000 a.. (ij ~ U co '" ~ CIO N .... co co" CIO '" ~ CIO "," ~ ~ CIO '" ci .... CIO N .... '" ~ .., '" ,..: '" .... CIO- co '" ..,," '" u. <( ..J CD a a ~ C; ;::: a u.. ~ .., .... a a '" .... a o iii >- CIl ~I ~ ~I ....1 a .., '" ori a 0 a 0 ci c:i a 0 a 0 co- ctJ'" 0> 0> '" ." m- a) '" .., o 0 a 0 o ci a 0 a 0 co- cQ '" ." 0> ." 0)- 0)" '" .., a 0 a 0 o c:i a 0 a 0 co- af 0> ." 0> ." ai a) '" .., .., .., M .., .... ~ '" CIO ~ .., CIl o E '" > <( "C c 01 c; o :E ::I 1Il CXJCXJCXJcoCXJooroG)mCJ)mmmoooo ~N gggggggggggggooooooooo ~~~~~~~a~~~~a~~~~~~~~~ 8~~~~~~~~~O~~~~~~~~N~~ N g .... 10 Mer) 0<00000 amoooLO ON (Y) 0 N ("jariMCV)~1.(j ~~~(Oo; N("')M('f') ~ ~-~ 000000 00 'VIOLOl.Oo)f'.-NCOCO mtOC"IJC")COI"--M__O -q:M~lri-.:t..q:LriLritri 00000__ ~~~~fgM U') 10 t.ri to aD ~ ~N~LO~~~~lOm~~U')ONI"--MCXJ~~~~__ ~~N~N~~MI"--NNo)V~tO~NvNNNNN ~~~tO~~~I"--~~~~~~q~~~~co~~~ 8<O",,"M~~ CD ex) co 0> "'CDI'- to co CD (0 Ln '1""""_ ~~~go ~_ co co. 0 0.. U) OOOOOOOOOOOOOOOOLOooaoo NO ClOe COLC) lOl.Ol.O LOLOO CO CON LOlOa N(Q ~L()~m~MONOl.ONC')~OO___~N~OLO MM(,,)~MM~Lri~M~~~~~~~~~~~~ 00 a a 00 a a a a o~ 0-' 00 .., 0 N-t()- o (I") 0 a. 0 0 o 0000 OMoeeo ocooooo ONOODe o~ r--: 0- o~ o~ ci omooooo om~o_o~o m~ tri (\f N 00 o a 00 010 a ,-R r-: I'- '" .... 0> N~ "V'~ 000 0 000 0 ciooo .q- CO 0 li') LOR f"--. 0 f"--. ~('fD-O- ~ m OJ co OJ 0)_0) OJ 00- ~~ 00000000 ~ooooooo aoaciocicid 00000000 a~ooooo~oo g 2f g ~~fg g ~~g~ l.Oooooo~,-o N~tO- m- N~ LO N-N- ........ 00. 00 ~~ .'" i:O~ .0 a (I') 000 COOOa NaCO LOOOO co_ooo o 2f ~5f g- o_ 00 0 U")- to (Y)- <X> CD co", C;;~ ~'" to cO '" ~ mo T""'- ri Noe voo ",,"00)(000 r....:or--:cOcio (f') O"'d"' moo NO<OLOOO ,,- o~ (t)- o~ 0- 0- aJOOOOo (J)_OO~O_OO N ri NA eti N- a a ....0 Mci "'co "'to ('f)R coA ....'" ~ '" (,f ~~ 000 000 000 "''''a 0>0> ,.....- ci crf 0> CD 0> 0> coco ~oq: 0-000000 0000000 0000006 r---ooNN(f)(0 LO~LOCO (O"It'i"'-- ~ (\f l.Ii a:i 0- (f)- CXJ~ 0) 00 co como> 00 O)O)_mO)_O)mm_ N N- ~N a a 00 do a", lOll) r--: ('f)- I'-tO '" 0> N-~- 000 000 000 000 000 o~ 0- Oh 000 Oh 0 0 LO- 1.0- 000 o 0.0 ddd a 00 000 0- ci 0- 000 000 M- N- (f')- 000 000 ddd 000 000 0- 0- 0- 000 a a a N N(f)- a 00 a 00 cidd 000 000 0- 0- 0- 000 a 00 NR c? N- (I") (OM "d"M,..,.. f'.."'d"'-q-cor--- 00000000000 00000000000 ~~NNNNN~N~N "d"moi'05mot--mmo ~~~ ~~~ ~o~o ~-a~ o~oo 0' 0 <r- r-r-,..,..,.....(Oco.............. 00000000 00000000 NNNNN~~~ t::UiUi:;a:a;.'VMtO ~~~~~~~~ 0000 '-00 .1'- a a ~ CD Q '" a c. c. c. () (; (; ~u ~-E"::'::: ()~ 5i U~'::':::"2 ~~~&l~ ~~~ ~~~ &l ffi ffi fij :c ffi ~ ffi ~ ; ~ffi ~ ooo~ooo 0 00 ~~ -J()-J ~~-.2~ ~~~ ~ EE~g~EE EgEE ~~~.f~~~~~~~~ ~~mm(ij~memmm~ IDID Q;euQ; ID<DQ> euQ3<o Q) ~~~~as~-g~~~~i LL.LL.u..u..u.u..u..u..u...u.u..LL. III ~ ';: :I (,) Ql CJ) t: o C. :I o (.) >- (,) C Ql Cl <{ (ij ... Ql 'tl Ql U. I'-CO 00 00 ~ a O>'-~N~~~~~gM~~~~~~~~~ 00000'0000000000000 ~oo~ooo~oo~o~~ooo~o c. c. o 0 -Ec;,~"2-2"2-E~ :~~~~&l~~ .~o.c::oo~~~ ()...J~...J-Ju...J~ EID.2IDIDgIDo ~ ~ ~ ~J .f ~ ~ e~m~em Q) Q) <0 Q) Q) Q; "'0 "'0 "C "0 "'0 "0 Q) Q) Q) ID Q) Q) u.. u. u.. u.. u.. u.. (ij m e co ID Q5 Q) cv "0'0"0"0 Q) Q) Q) Q) lJ..u..LL.u. NO~co~mm~g~~~~o~~~~~~z ~m:a:~:a:~~""u:a:~~w~mo::~z~~z CD"'XXXNN:a:....IOCO~XN~~~X~~~ xx'" ~XX"'Xu..XX~XtoXX X"'X MOO MMM CX)MLO COC:OM MMCX) (])MM MM~ M MN C'l(l')M NMM NMM (Y)MN ('f)(W')M C""JC""J(") M M~C;;MM~MMMMC;;MC;;C;;C;;C;;~~MMM o a '" o 0 ~ o ci ~ o 0 .... o 0 CIO o~ 0- "fItt'" o a CIO o a c.o C"i (f')- ....... '" a a 0 o 0 .." OOM I'- '" '" 0_ ~ M -.:r ro- ("1" ll) 0 0 m 0 CIO (,f M- <Ii co a a 0 o a 0 o d c:i o a 0 a a 0 0- 0- 0 o a CIO 0_ 0 CD M ('1)- ,..: '" ". ". C C '" '" m m c c '" <ll o 0 ~ ~ ID Q) E E o 0 ~ ~ '" "<t a a ~I I ! O')f ZI WI -J_i X, C")! C""Jt ~I '" Si~ .... <X> c.o -i '" '" .., c; ." .." .." N N co ui' ." N "$," .... CIO '" M o '" i. .." ..,- .... .... CIO '" ci .... CIO Q ~ '" ..; .... .... o. co -i .... o ~ '" .." ui' co .... .... ori o .." o .., co ~ N .... .. o E CIl > <( "C c '" c; o :E ::I rn CIl .0 E '" > <( "C C 01 S o I- .S I :0 :J o - o z- U Z -I CO ::) C LL o ~ o Q) Q.tn >.- I-C >.Q) .oS tn tn -Q) s::: > (I) C E Q) - > tn .- (1)1) >c::( s::: t-- o o N o C") Q) C :J .., =.. "'''' 0"': D. =.. "''l;j 00 ~s .~ ca :>0 'l;j :E -.. 1:_ ..'" l:tl:: :> o .. :> t;j > .... o o lD .... 1/1'" ~L: ~D. :> D. .. :> ~ .. '" D. .. .. :> 1/1 .!Il 'C I: :> lL 'II: - I: .. .5 1/1 .. > .E D. iij ~ o o o o o o o o ci o o 0 o 0 o 0 o 0 o 0 o 0 o 0 o 0 o 0 000 000 000 000 o 00 000 000 000 000 ~ ~ ~ .... o o ~ o '" <0 o .... '" o 0 o 0 N N Oi CD ~ ~ ~ 0 '" 0 0 o ~ ~ 000 N N N Oi M ii) ~~ID o 0 wm wwoocomm oggc;gggggg ~~~~~~~~a1a1 ~~~~~~~~O~ o OOOOT'"'__T'"' 000 000 000 000 000 000 000 000 000 "'....'" 000 000 NNN Oir:::.a= ~~~ 000 00 c; c; N N IDo ~ en 00 NNoooomommo c;c;c;gggc;ggc; a1~~~~~a;~~~ ~~<o~a~~~~ii) T""OOO 00000 OOOOOOOOOOO~OOOOOOOOOO O~~~NOOO~~CON~NIDOO~O~~CO ~mooo~ NONM NO~~MOON~O ~~~~MMM~~~~~~~~MM~~~M~ o '" '" 6 M ~ o CD o N 0- r--: o '" o "'_ N '<t 0 CD 0 M g g u") 0 cO 0 0 "'00 "'Ou") ~NN 00 00 00 00 00 00- 00 00 m- "f'""- 0000000 oooomoo 0000""':00 oooo~oo OOOOIDOO 0- 0- 0 0 cri 0 0 00000000 000000 N- I.ti cri N cri cri M 00 00 00 00 00 00 00 00 cril.ti OMCOO OIDNO ONNO o~coo OID_NO ci 0 <0 0- 80_og ~- cri N 0000000000000000000000 0000000000000000000000 0000000000000000000000 ooooooooooooooooooooo~ OMCOMOOOOOOOWOOOOOMOOOO> g~~~gggggggMgggggNIDgg~ ommoooooooooooooooooom oo>mooooooooooooooooooo> T'"' "f'"" "f'"" T'"' T'"' T'"' 0000000 0000000 0000000 0000000 0000000 ci ci ci 0- ci ci ci 0000000 OOOOLOOO (\rN-NNNai~ a. o ()~"2"2 C)mmm ~(O(O(O ~:.o:.o:.o .a ~ of!! of!! "5 0 .2 E E E en Co Co Co <(lLlLlL ~~~~ Q) Q) Q) 0> '"0 "0 "0"0 Q)Q)Q)(l) u.u.u.u.. -'" -'" -'" c c c <<S <<S <<S (0(0(0 C C C <<S <<S <<S o 0 0 -' -' -' OJ OJ OJ E E E o 0 0 :J::J::J: m~~ Q; Q) Q) 1:1 1:1 1:1 0>, Q) Q) lLlLlL 000000 000000 000000 000000 00000_0 00-0-0-00- coooooo 00000 N- ~- M- N- M- M- 000 000 ooc 000 000 ci ci 0- 000 000 M- M- t.ti 000000 000000 cccooo 000000 000000 ci 0- 0 ci 0- ci 000000 00_0000 t.ti M~ N I.ti N a. a. a. a. o 0 0 0 ~.::.t:.~~.::.t:.~~~UUU() C C C C C C C C C) C) 0 0 ,!g,!g,!g,!g,!g,!g,!g,!g~~~~ ccc ccc ccc c:c:c:: mmm mmm mmm mmm .9.9.9.s.9.9.9.9.9.9.9.9mm<<i ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ .~ .~ .~ 000000000000101010 :J::J::J::J::J::J::J::J::J::J::J::J:ZZZ ~~~~~<<i~~~~~ 0> Q) Q) Q) Q) Q; Q) Q) Q) Q) Q) "0"0"0"0"0"0"0"0"0"0"0 Q)Q)Q) Q)Q)Q) Q)(l)Q) Q)Q) U.U.u..LLLLLLLLu..U.U.u.. "'U") lL'" :2;:2; XX "'''' '" '" '" '" MM '<t'<tu") "'(O:J:C) ~?:~tl:: NooI..., xxxx ('I') M M ('I') MMMM MMMC;; ~el)U") ZZO ZW(O ~-'''' xxx "''''''' "''''N M;;;C:; c c c Ul Ul Ul Ul Ul Ul <(<(<( C) C) C) ~~~ ~~~~ "0 "0 "0 "0 Q) Q) Q) 0> u..u.u.u.. 0000000000000000000000 0000000000000000000000 ~~88~~~~g8ggggg~~~g~~~ ~oooo~~oooooooooooo~~~ 'tl c: :J II.. ~ Gl 'c: Gl C) 'tl c: :J II.. Me;; N'" WlL -'~ C):J: xx '" '" "'''' C;;C:; u")~s~~~ S?OD.'<t:2;(O ~~~~:f~ COCOCOLOtOO> NNNMMM ;::;C;;C;;C;;MC;; ON O'<t 0""': 0'" ON 0- r--: 0'" Oel) t.ti~ 4~: 11 z <( "'": "'": _ .1"'- I"'- o .Q ~ o a. CD ~ ... ... <0 oF <0 CD ,.: CD CD ~ ... ... <0 oF <0 CD ,.: CD C> C> .,; C> C> c:i <0 CD ,.: CD C> C> .,; C> C> c:i <0 CD ,.: CD t;j i :> tIl 'C c :> lL ~ .. c .. C) ~ I- ~~ u..1 ~ ct: a. "- Q) i="ct: o N '" ;..: .... o o ~ '" ~ o CD 10 o c: :J ct: QUARTERLY INVESTMENT REPORT Fourth Quarter Fiscal Year 2006-2007 June 30, 2007 Section II - Investment Charts 5~/I (, ~ \\ INVESTMENT CHARTS FOR THE QUARTER ENDING JUNE 30, 2007 INVESTMENTS BY TYPE (June 30, 2007) MONEY MARKET 6% ~ FEDERAL SECURITIES 59% LAIF 35% FEDERAL SECURITIES BY ISSUER (June 30, 2007) FHLMC 21% FNMA 13% FARMAC 3% FHLB 54% FFCB 9% $50,000,000 $45,000,000 $40,000,000 $35,000,000 $38,000,000 $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 INVESTMENT CHARTS FOR THE QUARTER ENDING JUNE 30, 2007 "1,11 FEDERAL SECURITIES CALLABLE vs NON-CALLABLE CALLABLE 35% NON-CALLABLE 65% June 30, 2007 - Portfolio Maturities $0 No Maturity (1 Yr or Less) (1 Yr - 2 Yr) (2 Yr - 3 Yr) (3 Yr - 4 Yr) (4 Yr - 5 Yr) Date QUARTERLY INVESTMENT REPORT Fourth Quarter Fiscal Year 2006-2007 June 30, 2007 Section III - Listing of Monthly Investment Transactions g, ~. II 9 ~~.~ 1 I Gl I~ 0 0 0 C) '" N N N N N N N N N N '" C) 0 CD CD CD <D co .~ , f.) 0 0 0 C) <D CD 0 0 0 0 0 0 0 0 0 0 C) 0 10 10 10 .... .... :c e ,...: ,...: ,...: ..: ci ci N N N N N N N N N N ci 0 ,,; ,,; ,,; .,.; cO Z ~ ..-.: '" - I'- => ftj co 00 00 00 co co 00 N N I'- N N N N ..... ..... ..... 0 0 ..... ..... ..... ..... '" 0 iL ..: ... ... ..... ..... 10 0 .....- 0 0 ..... ..... 0> ~ .... C) 0 10 10 10 .... "!. " 0 III N N N N ",. = cri cD 0) ..... "" "" a a r-: ui iii a a M M M M ... .Q -'> - ... t: t: t: t: en 0> 0 00 ..... 00 00 ~ ... 00 ..... .... C) 0 0> 0> 0> en co ;g <LIt 0 .... N (<) (<) ~ ~ ... 10 .... ... "'- 0> CD CD <D en tt: 0 z. = cri cri N N N C"i..o ui ui iii "" (<) M "" 0) en ,.: t: 0.. a. U ... ... '" (<) (<) (<) (<) '" .... 0 ~~ a. -' "l:l 0> en 0 C) '" <D .... Gl CD <D '<l; '<I: 10 .... <D > ,,; .,.; ,,; .,.; ci '0; 0> en :; :; ..... .... '" f.) 10 .... ..... .... 10 .... en Gl r-: ,.: r-: ,.: M ..; = It: (<) '" 0> en (<) .... (<) '" .... II) ~ J!l .E II) 0 C) 0 C) 0 ftj 0 C) 0 C) C) ~ ci ci 0 ci ci 0 C) 0 0 C) 0 "l:l a a a ;; 0 C) C) ~ 10 .... .... .l!l 0 C) 0 0 0 0 0 0 0 0 0 0 0 C) C) '0; 0 C) 0 0 0 0 0 0 0 0 C) 0 0 C) C) 0 ci 0 0 0 0 0 0 0 0 ci 0 0 ci ci 0 0 0 0 10 10 0 0 0 10 0 .... 0 0 C) .... c. 0 0 10 ..... N 0 ..... 0 N 10 en 0 0 C) en Gl a o. N cri cD a cD a .....- r-: = a a a = c 0 C) 00 00 0 0 10 0 ~ 00 <D 0 0 C) <D 0 C) 0 0 .... ..... 0 ..... ... "" -i' N M iii ui iii iii ... ,... ~g 'S: N Z ~ 0 :J (,) M CO <C 'i: ::) C) c.. C s::: <C LL :.i2 0 (,) ,... (I) 0 ~ .c: 0 (.) N - (.) .c: - 0 C'CS "i: (.) c.. <C .... c. '0; f.) Gl It: eGl ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... ..... Cii 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 0 0 0 0 0 0 0 0 0 0 tlc ~ ~ ~ ~ ~ ~ N N N N N N N N N N N - '" C; C; 00 C; N 0> m m u; u; ;::: ;::: ;::: ~ M M ro 0 II) ... 0 !2 0 N N N N N 0 ... ... l- e ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ f! 0 0 0 0 0 ~ 0 0 0 0 0 0 0 I- ....Gl 0 0 ~I 0 0 0 0 0 0 0 0 0 0 ~I C) 0 0 0 !I C) e.... 00 <Xl co 10 .... 10 10 10 10 10 10 10 ~ (<) (<) <'> '" Gl'" 0 0 0 ... ... 0> 0> 0> en tit: .n .n iii .n .n .n .n .n .n .n .n .n iii -i -i -i -i :0 (J 9 ... '" (<) ~ ... ~ ... 0 0 0 ';: 0 Gl 0 Gl 0 Gl :0 u; f.) u; f.) u; f.) f.) e e e Gl >- '" >- '" >- '" II) II) ftj II) ftj II) ftj III III III Cl Cl Cl e ,2 e e '5 '5 '5 "l:l e ~ e e e W W W :0 C; "l:l C; "l:l C; "l:l IL J!l 0 e 0 0 e 0 e t:: '" a. '" '" => I/) ftj '> ftj :B 0 'tl '0 I '0 '" 'II: t.l C 15 0 I~ 15 .s N .... t.l => Cl .Q r'.: e <C u.. :0 :0 :0 0 Gl II) C/) II) II) .5 - III ::::l I'- Q) :c 0 II) ~ ~ ~ '" 0 Gl .. E .... N > III C) 0 C) N Gl e :iE => C) (jj C) u.. ~ Q :0- '0 ... 'tl ... ~ <Xl II) 0 !!l >- 0 u:: iD Q) C u.. iii 0 <( 0 :iE c ..J :J tt: .f: I :0 :J o '0 z-. (3 a-~ .- 0 Z.2: N - ~ -U""" -1<cC'? ~C)~ C .: :i! LL.lr::: O~~ >-.1:0 I-ON -- 0.1:""" tn >- C'CS CG O:i! Gl U c: .. ii lD "C Gl > "iij U Gl II:: OJ E Gl :E III ii == f! "C :5 ~ J!l "0; o a. Gl o .... a. oiij U Gl II:: C:Gl .21ii tio .. III c: f! ~ 1:.!! Gl" t:1I:: ::l U Q ~ ::l U Gl (/) 'It .... c: Gl .s III Gl > Gl c: ::l- III !!l 0000 o 000 ,...: .....: .....:,....: co co coco ~ ~ <r- <r- NO, ('.r N- N t:r::r:::.~ I~NN:: I N <0 N I'-- M V 1'--1'--1'-- 000 000 ~~~ 000 iOii5ii5 000 00 CO I'-- 00 ..nLD V V o o Ci) >- (/) o o - Gl ..ll: .. "' :z ~ c o :z 13 o o ... o 0 o 0 o c o 0 o 0 ci c:i o 0 lO_ Il).. ~I~ Gl U c: .. ii lD Cl :S 02 ~ ~ c: 0 .. a.. ~ ~ .g C) (/) rn ::> ~ Cij "'0 u: o o ..: CCl ... N ... "!. ... ... NNIO U')lt)IOl.C)lt)lt) lOlt)LO CO~~~~~~~~~~ ~~C;;C;; "'I:t-vcoco t.D 1.0- oi 0)- ......r---J'-..r--- Lt)U')l.C)U') u) ..0 ..0 N- '" "! N to- M ... o o o ~ ~ CO '" .o CO a:i co- .o", <01'-- NN <r- T"" <e- T"" MOO C") M co lO C") M 00- ~ c.i ci C")COMM ...... ....... co ro ..0 1.0- U')~ ,....: 000 000 cicici 000 o ~ 1.0 0- 1.0 a:i o~v o N ......r---....................r---r---....................r--- 00000000000 00000000000 ~~~~~~~.~~~~ ii5ii51.01.01.O iOiOlii ii5LaLa 00000000000 '" <0 oi .o '" ... o o 6 o o o o o M 00000 00000 cicicioci I.OI.00lOI.O ......._ NO....... r--- co 0- 0- (\1- a:i r---ooo...,.-v o M 0000000000 0)0>0>0)0)0>0>0>0>0> ~ ~ ~ to..n..n..nLri..o..o..nLriLri <0 V o o Ci) I~ ~ o o ... ... o o ... MC;; '" CO ..0 C")- v'" coco r-: r---- ~I~ ll) "! ... .., CCl M Ol CCl ,.: .., ... oi ll) '" ..; o o o o o C o o M o o o o o t .., ..; Gl U c: .. ii lD Cl c: '5 c: W "C c: .. ii "0 1:5 ::l (/) U) 0 0 0 0 It) 0 00 0 cnc:icio c ...... 0 00 0 U) 0 0 0 0 Macici 0 en lO U') lO It) (D co co co to en ~ ...,.- 1.0- .n M M M C") M <0 .o oi I'-- .o M V CO ,..: I'-- I'-- I'-- 000 000 N N N ~ to La o 0 N La i:O La 000 o 0 '" '" Ol Ol -oi -oi .., V o o Ci) >- (/) o o LL ~ .., V o ~ LL C( oJ 00 00 ci 0 o 0 00 ci 0- 00 o CO M Sl5 ll) ... cO ... o <Ii ll) to- ..; ll) o o o ll) "! ... CCl o ai ... ... ll) oi to- ll) M ... CCl ,.: ... ll) oi to- ll) M ... .., N ... o o o o o C o CCl ..,- o o o o o t ... '" 0; - o I- Gl U c: .. ii lD Cl c: '5 c: W "C c: .. ! ~ ::l (/) Jo r&~")' ) I > a.. . . ~ <( ,..:..,..: o .Q :E 1:: o a.. CL lB ..J> u.1 'E a: a. ~~ ..J N N .-.: o " o o C! !2 ro o Qj OJ o c ::> a: ., <:> 0 0 0 <:> CO CO <:> 0 0.0 0 0 0 0 0 <:> l~ ~ I I I~ lO .... .... .... .... .... .... .... .... .... .... <:> '" .5 , <.> <:> 0 0 <:> <:> <D <D ~ <D <D <D <D <D <D <D lO '" <:> 0 0 0 0 0 0 0 0 c::i c::i :0 I: ...: ...: ...: ...: ...: <<i <D <<i <<i <<i <<i <<i <<i <<i ,,; M M c::i c::i c::i c::i d d d d d <:> a; l'Cl co co co co co ;;; Cl Cl Cl Cl Cl .... .... .... .... lO N '" <:> 0 0 0 0 0 0 0 0 0 ::l a; ... ... ... co '" ... Cl .... .... Cl ,.... <D CD 0 0 0 0 0 0 0 0 0 ..; <=> 0 CD N N N N '" M M oj M ,-: ,....' ,-: 6 6 0 ,,; N 0 <=> <=> 0 6 6 0 a:i a:i a:i a:i '" ... '0 ... ... <D ~ ... '" Cl c;:; <D (; (; (; ,.... ... '" Cl 0 0 '" lO co ~ :: ,.... '" Cl Cl '" CD "', N. .... co co Cl 0 N '": N N '" CD .... co co '" Cl Cl .... cD Z' ... :: N M M t: ,-: ,-: ,-: co' lO' ,-: ,-: ,-: lO on M M M on lO' .; uS ,-: uS ,-: ,,; ,,; M .... ... M '" M '" M '" '" '" '" C3 "C co co '" '" 0 ,.... 0 '" ., N '" Cl '" c::i .,; > d d ... ... '0; ... lO '" <D CD ,.... <.> '" '" ,.... ,,.... .; ., co' ..; ",' on It: ,.... .... .... N '" ... '" f ., :E '" 0 0 0 0 <D CD 0 0 0 0 CD 0 0 0 a; 0 0 0 0 '" '" 0 0 0 0 c::i M 3: d c::i d d ...: to M d d d 0 '" E 0 0 0 0 co '" '" 0 0 0 0 ~ 0 0 0 0 M 0 0 0 N ... "C 0 <=> 0 0 ,-: N .... 0 0 N 0 ... .s lO '" 0 <D co ... '" 0 ,.... '" ~ ... 0 0 0 O. "'. 0 N lO N t: ~ ,,; .... ",' t: ... N ... J!l 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 0 0 0 0 0 0 c::i c::i 0 d c::i d d d d d d c::i d d d d 0 '" 0 0 0 0 0 lO 0 0 '" 0 0 0 0 0 M C. 0 0 <D 0 0 ,.... '" '" M 0 0 0 0 <=> <=> ., Cl 6 <=> M .,f 0 ",' ,,; oj <=> 0 0 6 0 '" .... lO '" .... '" 0 '" '" .... .... '" 0 <D <D M '" "!. "!. 0 ... M "'. ,.... o. 0 ",' ..; N ",' N ..... ~ 0 0 'S; N Z ;l O~ ...J (J M CO <C tU ::) C) c: :::s C s::: .., LL :i 0 (J ..... Q) 0 >- .s::: 0 ~ 0 N - 0 .s::: - t/) C'CS tU 0 c: :J .., Q. a; <.> ., It: I: ., ,.... ,.... ,.... ,.... ,.... ,.... ,.... ,.... ,.... ,.... ,.... ,.... ,.... ,.... ,.... ,.... ,.... ,.... ,.... ,.... ,.... ,.... ,.... ia 0'" 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ,_ l'Cl 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - "Cl ~ ~ N ~ ~ N ~ N ~ N N N ~ N N N N N ~ ~ N N ~ 0 l'Cl (; co Oi (; ~ .... i:O '" i:O i:O <0 <D ;::: ;::: ~ ;::: (;) '" co N <0 0 I- '" ~ N e 0 ... ... N ~ N N N 0 0 ... ... ... ~ ~ '" I: <0 <0 <0 <0 <0 <0 <0 <0 8 <0 8 <0 <0 <0 co '.CO <0 <0 E <D <D <D <D <D 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o 0 0 0 0 0 t- o ...., 0 0 ~I 0 0 0 0 0 0 0 0 0 0 0 0 ~I 0 0 0 0 0 0 0 0 0 M 1:... ,.... ,.... ,.... '" '" '" '" '" '" '" '" '" '" '" '" '" '" '" '" '" '" '" '" '" "l'Cl 0 0 0 N N N N N N N N <'! N N '" '" '" '" '" '" '" '" N .,; ::It: to to .,; to to to to to to to to '" to to .,; ... ... ... ... ... ... ... to ::l (,,) 9 .... <D '" ~ .... .... .... 0 0 0 ., 'C 0 ., 0 ., 0 <.> :I (jj <.> (jj <.> (jj I: <.> I: I: l'Cl ., >- l'Cl >- l'Cl >- a; t/) t/) a; t/) a; t/) CD CD CD Cl Cl Cl I: I: ,2 I: '6 '6 '6 I: "C I: ~ I: W I: W W "C :I (; "C (; "C (; I: L1. III 0 c 0 0 I: 0 l'Cl 1: l'Cl D.. l'Cl ~ ::l Ul ~ .... ~ 0 '0 > .s 'It l..l c: .s 0 ~ .c ... l..l ::l .c C) :I I: oCt: u.. ::l :I t/) ., t/) rn t/) E a; C'll ~ U; ..II: :c .... ~ CD M ., ... E .... .... .... .. > C'll 0 0 0 ., I: ::E ::l 0 a; 0 u.. 0 :1- ... ... ... '" >. '0 '0 <( !!! CI) 0 u: ...J c: u.. 0 <( ::E ...J