Loading...
HomeMy WebLinkAboutItem 4.08 Investment Report 1stQtr CITY CLERK , File # D~~[Q]-~[Q] AGENDA STATEMENT CITY COUNCIL MEETING DATE: November 6, 2007 SUBJECT: City Treasurer's Investment Report for I st Quarter 2007-2008 Report Prepared by Paul S. Rankin, Administrative Services Dir.1?Ifl- ATTACHMENTS: Quarterly Investment Report For The Period Ending September 30, 2007 . QAJ~ RECOMMENDA TIO~'\\' "Receive the Report FINANCIAL STATEMENT: See Report DESCRIPTION: The attached Investment Report details the City's investments as of September 30, 2007, in accordance with the requirements forreporting investments. REPORT FORMAT The format of the 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 1st QUARTER RESULTS As shown on the Portfolio Summary the total investments as of September 30, 2007 were approximately $100.6 million. The Yield to Maturity was calculated at 4.582% and the weighted average maturity of the portfolio was 1,106 days (3.0 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 slightly more than one year at 407 days. As noted in the summary the Market Value at September 30,2007 was slightly more than the Par Value. (Par Value = $100,590,779 and Market Value = $100,649,859) If the City holds all securities until maturity as expected, the full par value will be received. ------------------------------------------------------------------------------------------------------------- COpy TO: Page 1 of3 ITEM NO. 'f.<g G:\lnvestments\FY 2007-08\September2007 Ag Stmt\Ag_ Stmt_l stQtr _ Sept_ 07 .doc 'tY/ The following Table displays the comparative results based on information in the Portfolio Summary for the first quarter of the previous year to the current year. COMPARISON OF PORTFOLIO MEASURES 1 st Quarter FY 2006/07 vs. 1 st Quarter 2007/08 $100,590,779 1,106 days (3.03 yrs) 4.582% As noted in the Table the total portfolio is lower than one year ago. The total portfolio will fluctuate based on both additional contributions to reserves at year end; as well as expenditures made from reserves. In the final quarter of Fiscal Year 2006/07 there were several one-time expenses or transfers 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 of the CalPERS Side Fund obligation ($3,569,754). INVESTMENT ACTIVITY DURING THE QUARTER Staff will continue to highlight as part ofthe Staff report changes in individual securities due to Maturities, Called Securities, and New Investments. During the first quarter none ofthe securities matured or were called. Staff purchased four new investments with a combined par value of $6.5 million during the quarter: INVESTMENTS PURCHASED DURING THE FIRST UARTER FNMA 8/31/2007 $1,500,000 04/05/2010 4.81 4.69% N/A FFCB 8/31/2007 $1,000,000 04/25/2011 4.80 4.75 % N/A FNMA 9/1 0/2007 $2,000,000 09/10/2012 5.20 5.20% 9/10/2009 FNMA 9/13/2007 $2,000,000 05/14/2010 4.75 4.53% N/A Total $6,500,000 The securities which were purchased included one which has a one-time call provision in 2009. The types of securities purchased were selected to continue to diversify the investments among different issuers. All are AAA rated securities issued by agencies ofthe Federal government. The portfolio tracking software assists with reporting the value of securities that were purchased at a discount or premium. For example the FNMA security purchased has a coupon and pays interest at a rate of 4.81 %. However, it was purchased at a premium which will produce an effective rate ofretum of 4.69%. The financial records will account for the premium over the life of the security, instead of recognizing the entire amount at the time of purchase. These factors will be accounted for in the quarterly investment reports. 2 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 aswell as the composition of the portfolio. The following are key highlights ofthe portfolio: . At September 30, 2007 (26%) of the portfolio was immediately available in LAIF and Money Market instruments. This represents a smaller proportion of the portfolio than the 41 % reported as of June 30, 2007. . Federal Agency Securities represented 74% ofthe Portfolio. This is a change from June 30, 2007 when 59% ofthe portfolio was reported in this category. . The federal securities were issued by five different issuers. . 59% of the funds are invested for one year or less. This is up slightly from the 57% reported as of June 30, 2007. . 33% ofthe funds are invested in securities with maturities of 3 years or more. MONTHLY TRANSACTIONS Section III of the Report provides a list of transactions related to investments in the City portfolio for each month ofthe fourth quarter (July, August and September 2007). This schedule provides compliance with the Government Code requirement to disclose monthly transaction data. It is proposed to incorporate it as part of the quarterly investment report rather than individual monthly reports. It is recommended that the City Council receive the report. 3 I~ If CITY OF DUBLIN QUARTERLY INVESTMENT REPORT First Quarter Fiscal Year 2007-2008 September 30, 2007 Presented To City Council November 6, 2007 Section 1 - Portfolio Information . Portfolio Summary (Includes the Par Value; Market Yalue; 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 \ \-l.D- 0' y,~ A~Y\ YV\a.J,\ t- - t: Z CI) :J ~ al Ol ~ ca C ; U-~ o 0 >- 0 t:::.... Ot:: o a.. t-- ~g caN Eo EM ~ ... CI)~ o E CI) ,2- t::g. OCl) a.. .::: o ~ ~tr >:~ co M ,Siii III 0 >.""": ca- C~ .2 - - o 0 - ~t:: o 0 ll. ..ll: CI) o ~ 0- a:I~ ..... <lJ .::.:: <lJ "" = ~ ~ ~;, CI) ~ ;iii ~> E ... CI) I- III - C CI) E - III CI) > C or- o ~ 1.O '<t C\! 1.O or- o N '<t 1.O C\! I'- '<t C"') N I'- co '<t 0) I'- I'- C"') N o N o C"') ~ ~ o 'C"') o '<t o I'- I'- 0 co 0 C"'). N '<t '<t N I'- co '<t 0> I'- I'- C"') N o N o 0 o 0 o 0 o co o 0 I'- 0) co C"') C"') N '<t '<t N I'- co ~ 0) I'- I'- C"') N o N o 0 o 0 o 0 o 0 0" 0 I'- 0 co co C"') or- '<t '<t N I'- CD .::s:. L- CI:l ~ >. Q) c o ~ u. <( ....J '<t 1.O C"') '<t N 1.O 1.O o o 1.O >. c..> c Q) Ol <t: co L- Q) "0 Q) u.. ~ o N CIO It) ~ I'- o "I:t co o ..... ..... ~ o o. o ci o ..... ..... en N N Ilt ..... ..... ~ o o ..... tA- CIO ~ en It) ~ en "I:t ~ o o ..... tA- CIO ~ en ..... .....~ o en Ilt o o ..... tA- ca - o I- "I:t C! o CIO "I:t M ..... en "I:t o ci CIO "I:t M ..... en - III CI) ... CI) - C "C CI) ~ ... CJ CJ <C "C C ca .r; III ca o - III CI) ... CI) - C "C CI) ~ ... CJ CJ <C ~ o N CIO It) ~ 0) ~ ..... o "I:t '" oS !: o S .~ '" - :><: 0) !: i3 ~ .S :: ~ 0);; ;> CIl o 0) '" ..... 0)"'0 ..... !: .z '" ;.a U) !: ~ 0) '" 0..- :><: 0) 0) - "'O~ 0) U ..... ..... a~ ..... 0.. .~ ~ ..... 1;1 "@ _"'0 0) !: 0) '" S >; B .~ CO '.... IJ... :-g "S ;:l 0) gg ~ '" o 0) G::: 6 ~~ ~ :.=: u..o 0) ;:l ~Q ;:l,- 0' 0 .gc '" '.... 0) U "'0 0) os: oS 80S 0.. ..... - ~ .q 0) ..... u .z 1;1 '" ..... s- '- S o 0 '" u .'!:l !: '" ..... "'0 0) 0) a oS '" CIlQ !: 0) ;e g ;:l '" - 0) g ;> ..... .5 en,- Q 0 0) 0) g;; ","'0 ~] .5 ~ '-"'0 o !: 0) '" ~ .el "'0 !: 0) 0) "5 g '" '" 0) 0) ...c: ;> E-< .5 co o ..... ..... ..... en N N Ilt ..... ..... co o o ..... tA- N It) ai M M M co Ilt ..... o ..... tA- CIO "I:t ai ..... ..... o en It) o o ..... tA- CI) ~ "Ciii c> ca III .r;- III c ca CI) 0.5 ca III _ CI) o > I- C ~ E-< <x: Q ~ o E-< U ~ ...... Q U) . ~ U > ~ ~ U) ~ ;, ~ ~ E-< U) ~ ~ Q <x: ~- ~ Z ~ U) .....l ::J <x: IJ... ;?~II (l) Cl 1lI ,a.. lfj - c - Q) 5i E..... zEu;o ...IO)Q)o >N alenC ~ :JC'Cl 0 cC: C'? C'Cl ..!!? (j; u. == nl.c Oo-E ~~~.s 0- ~ 0 C. 1: .- Q) o "0,00 a.:e o a.. ~.s. "i: co ,30 '" :a; ~'5 :a;cr I-w >-", CD o!!! -'" U)() ,.,..., "'-' 0'" :a; E CIl I- -g~ nia:: U) CIl CIl U)- '" '" .<::0 f: ::J D. CIlCll ClU "'c '- '" CIl- > '" <(Ill CIl ::J iii > .., o o III CIl ::J iii > ... ~ '" :a; CIl ::J iii > '- '" D. '- CIl ::J U) .!!! 'It 1: CIl .5 U) CIl > .= (J) 1: ::l o U u <l; Q; .:.: '- 1lI :2: >. (l) r::' o :2: D. c;; ::> () ~ ~I ~ ~I ~I o 0 o N o 0 Lt:i u-) o 00 o ..,. ~ N 00 '" "'. ~- ro "'. o 00 o ..,. r---: N 00 '" ~ "'. r;- ro "'. o 00 o ..,. r-..: N CO '" ~~ "'. "- "- a 0 o 0 ~ ~ o 0 r:::: t::: o 0 .Q :E t o D. Vl :;; '0 0 5 0 u.. en :5 ::l E E ::J W o '0 U u: ..,. CD ..,. ..,. o 0 o 0 ..,. CD ..,. ..,. o 0 o 0 en en >- >- en.en co ..,. ai .... .... ..; N o N" co <t ai .... .... ..; N o N co <t ai .... .... ..; N o N ~ en eO N CD <to U; u) CIl Cl E CIl > <( " c '" iii o 15 ::J en u. <( -l ~I ~ ~I ~I o ..,. N .0 o 0 o 0 o c:i o 0 o 0 r--- ...: 00 co M M ..j ..j N N o 0 o 0' o c:i o 0 o 0 r---.h ...: co co M M -v- ~- N N o o 6 o o r-: r ~ ..j N "- a o ~ o j;:: o u.. 3 M ..,. o o '" ..,. o o en >- en co m ex) co (X).co m CD 0 0 oggC;oggggggc;oo ~NN~~~NN~NNNNN 'Q'WOC;lO ~aMmmtoOm N~t:!N~Nfa~~of?~me o 00000 oo~ 0<0000 0 OCJ>O>VLONO vocoa('-..v Lri ..0 -.i u:i ~ (") M 000 00'" NON cv:l ~ ~ 000 '" co 00 '" 0 lri ui ..0 1000"I""""Q)NM!'--O(J)Q) ~~~~g.(y)~CJ>~t! NN cooomomm c;gggc;ggaooo 55 ~ ~ ~ ~ ~ ~. ~ ~ ~ f5 w~~~~~~~~m~ 00 00000000 000 '" N CD NO'" u:iLriLri m-q-IODLOCO (") 0) t-- I': "d'" co V Oh ,..... m m "....... o N (<; o ;0 o 000000 OOvt-LOLO LOMo>t-Nlt) M M ...t ...t ui (V') o N N~~ ~oCD '" N 00 a 0 N 0 N g g g M <.0 N ll? ..0 ...t Lri v "- 0 N ~q;;::.~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ "<t.f: ~ ~ ~ ~ ~ ~ ~ ~ (V) ~ ~ ~ ~ f3 ~1O~~M('O')~~~CO~~~~~~~~t--~t--~~m~m 0000000 OLOlOLOONO "Q"CDOOOOOv ui ...t ..r to ..r M M 000001.0 aOLOIOCON NON C"') ...... M...t...tLrill"lll"l o 00 o '" o ID o '" o '" ci~ o '" o "'. N '; ) 0000 1"---000 MOOO LODOO LO_OO 0 0- a. ci 0000 O.LOOO. No) o 0 co o 0 oON OOCD 00'" 0- a. M- 000 000 ri N- ri 00 00 00 00 00 ciei 00 0 ~ 0 N. LO. IDO ""':&.ri N'" "'''' 00- ci '" 0 "'0 ~ N- 00000 00000 o 0 0 0' 0 R ~ ~ ~ C;; M- (f-; cO LO- ci 88080. C\I- N. NN 000 00 o. &.ri 0 0 N"- '" /'- "- cO ri ro 00 '" co ..,. 00 '" C\ioo 00 00 Lf:i 0 "- 0 M "'. c.ci'~ CD "- '" N v. 000 000 000 N N N 00 CD '" C\I- ..0 ..0 O~'" 000 M N- M o o ci o o ....- co ~I N 000000 000000 000000 o a a o. 0 0 000000 0- 0- 0- 0- "0- ci oaoooe ~_~~~e_~ o o 6 o o ci o o ",. 0000000000 0000000000 000000 ci06 0 0000000000 0000000000 ci ci 0- 0- 0- ci ci 0- ci ci 00000000000 O-N-~ ~ ~~- ~-riri~- 000 000 000 000 000 0- ci 0- 000 000 M N- 1.0- co cD t-- t-- o 0 a 0 o 000 NNNN :;;rmo:;;r N c:;; c:;; '" ..,. 00 00 N N mm t--"","M(",) CDF'--F'--COt--t--V"","F'--t--t--vt--t--I"---t-- 0000 0000000000000000 0000 0000000000000000 ~~~~ ~~~~.~~~~~~~~~~~~ ~;~CDCD~N-O-Q~N~Qg-CD~g~og~g~CD~oo ~ooo 00 0000' 00000 -c:;; 00 en .... ..t co <t u) <t '" ..j M c. (; Ui-E-E-E ~~~~~ .::L .::L .::L .:.t. .:.t. .:.t. c: c: c: c c: c rornrnrocorn Illmmmmm ccc:ccc co co m CtI co m 000000 -'-'-'-'-'-' W W w- Q) OJ eLl EEEEEE 000000 :C:C:CIII CIl Cl E CIl > <( " t: '" iii B .c ::J en 7ii:O:O:O .aQ)~~ '3 0, U U o E E E .~Ciiroro <(u..u..u.. ~m~~ WIDOJW "'0"0"'0"0 OJ OJ Q.) Q.) LLu..LLLL '6 Q) o E eo' u.. 000 "'NCD NO'" LriLrilri 000 000 000 000 000 ci ci 0- 000 000 (V')- M(Y')- 000 000 o c:i ci '" .... '<t N_ 0 CD ; gf g 000 criMM L, x x C c '" '" mm c c '" '" o 0 -'-' Q) Q) E E o 0 II x x x c C C '" '" '" mmm c c c '" '" '" o 0 0 -'-'-' Q) Q) CIl E E E o 0 0 I I I. rom~roro7iirorororororo IDIDW IDIDW IDWW IDWID "'0"0"'0"0"0"0"0"0"'0"0"0"0 Q) W eLl ID W Q} (]) (l) Q) Q) ,Q) Q) LL..LLLLu..LLU-u...u...u..u..u..u.. OONt--O)f'-..O) ggggg.gg "","0 LO<D N N C'1 C'1 C'1 M o 0" 0 a 0 0 000000 co 00 LULU LUZ XX "';;; "'''' ~~~ 000 000 0'00 00'" "''''0 MMll"l 0000000 aLOI.OOO~OI.O OC\lI.OOCONf'..; ..oLricv:iLri-.:iLriv " ooo>(Ooocomol"- OO~~OOM<DO~ ggo8gg~~g~ OOvI"--OO(Y') O(Y'). cio-~ ~o-o. oo-.::t.o a 888 ogg.~_~g 0 t.riLO-~MC\I-LO. C\I-N 000 000 ci06 "'OCD "''''CD N t---I"-- "''''0 "''''0 "'I!t'-....t "('-- 000 000 600 "'coo "'M<t ai~...r ("") ,0 (t) 00'" (t). N...r 00 00 00 00 00 0- 0- 00 00 lJ)- T"""- o 0 o 0 .0 c:i co, '" 00 '" co- M o U; N o a a a o o. a ~ c:i 00 0 000 0 000 0_ o-cioo 000 0 OLO.OO N N. N @-@-~~ U U U U C> C> C> C> ~~~~ c c: c: c roromro .3.3.3 .3 rom mmm ro ~~~~.~.~g~~g oooorom~""m~ I I I ,I Z Z Z Z Z Z ~~~~~~~~~ffi "0"0"0"0"0"0"0"0"0"'0 Q)Q)(])Q)Q)W(])Q)(])(l) u..u.u.u..I,J...1J...1J...u...u...u... COMI"--Mc.oCO a~~8~~ 000000 ~ c c: c c- c c: (1) en C/') en C/') en f/) (/) en (/) en U) <( <( <( <( <( <( en 0> c> en en c> ~~~~~~ ""'" co N V MvLnLO 000 a o 00 0 '" '" :co: :1!i~ ",u.. '" CD M M ~ ~ M '" co ""'" I'-- ""'" I- L{) 0: '" mso<( <{CD<{:2; COLLoocn m<DcnlO M M M M (") ("') M ;;; (J) (l) :;:; 0;: ::l u (l) CI) t: o 0- :l o U >. u r:: (l) ~~~ ~~~~~~~0~~z~~"'g8 ~!1-X XCDXX"'~I9:iO~~~~~~~ (l) '" Xm",XXXXXXXXXXXX '0 ;;; ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ .~ ~ MMMMMMM(,,)MMMMMM~MMMMM o 0 o 0 ci ci N 0 o. eO '" o o 0_ NN m m o 0 8'b t ( <t III M ..t N co III ..t N III III .... o <t o o lit CD o ~ M <t ..; <t .... o o N <to .... c;; N N lit ~ ~ CD 00 o ~ '>. o o ci co o ai' M N of .... co <t ai '" . co ai' <t to o o ... o o ci o o o co ~ ..j .... co <t ai .... .... o en '" 0" o ... o N ci '" en cO .... M ai' CD o en ..; CD o en" M <t ai' o ~ CIl Cl E CIl > <( " c '" J9 o 15 ::J en CIl C1 E CIl > <( " c '" iii o I- .~ I ::c => o - o .2:- i:3 Z ..J m ::J c u. o ~ () (I) Q.t/) >.- ~c: >.Q) .as sm c > (I)': E Q) -> rn .- (1)- > u c<( f'o. o o N o C") ... Q) .c E Q) - c. Q) en =4> "'., (.) "C Q, =4> "'.... 0'" o .a-s "C ca EO '" ::iE ....4> c.... 4>'" I::CI:: ::l o 4> ::l c;; > "" o o llJ 4>4> III., ~ "C .,Q, ... ::l Q, 4> ::l c;; > ... '" Q, ... 4> ::l III .!!! "C C ::l IL 'II: .... C 4> S III 4> > .5 Q, in ~ o " C ::I U. ~ Gl C Gl C) o o o o o o o o o 00 00 00 o 0 o 0 00 o 0 o 0 00 000 000 000 000 000 000 000 000 000 ~ o <Xl o Cf> o cri o I{) o Cf> 6.... o Cf> o "'. N a. o o Cl :E _ ~ ~ ~ (j .g E Cl (;j <t u.. m m Co Q) '0 '0 Ql Ql IL u.. ,:,t..::&:..::t:.::t: c: c c c ro co co ro CllCllalal .... o o N o M 0; o .... Cf> 00 00 N N 05 CD ~ ~ o Cf>00 goo NNN O>Mlt> e 0 .,.-It>CO 00 000 000 000 000 000 000 000 o 0 0 000 ~ <Xl .... Cf> 000 000 ~ N N m t::: ~ ~ ~ U1 C; 0 Cf> o ,0 ~ o com .,.-cocoCX)OOC1)m 08800g888g8 ~~~~~~~~~~~ N~~~~N;a~~25~ o 00000 .,.- 00 00 NN coo o co 05 00 .,.-NC\looooo>ommoo 00088808800 N~NNN~C\INC\lN~ Oi('l)li)cot:::('I)0505t:::~LO ~~CD~~~~~~LO~ .,.-000 000000 OOOOOOOOOOOOLOOOOOOOOOOOOOO O~LOLOONOOO~LOOON~NWOOLOOLOLOOO~OLO ~mooaOO~"'-NON('I) NOLOLO('I)OONLOOOON~ ~~~m~~~~~~~~~~~~~M~~~~~~~~ coo r....:Lri N I{) MI{) cOci Cf>0 Cf>0 .,.--C\i 000 ....00 Mod I{) 00 ~oo 0- ci 000 0_ ~_ ~ o co 0 o 0 OND o co 0 OMO 0- f.'I"i ci 000 000 N- cri M 00 00 00 00 00 0- 0 00 00 ('1)- ('1)- oomwoo oo~ 00 ggc;ggg 00"'IT_~00 ggo~g-g 000_000 LO- to ('1)- N Lri" wmo~ ('I) CD a ('I) oir....:ocri .q-('I)oo> ('I) ~ 0 M a:i "f!!t'- 0- 0- ~_ g_ g 0 NN 000 0 0000 0000 0000 0000 ci ci ci 0- '0000 0 0_ -r- 0 0 Nct)- M- 00000000 00000000 00000000 00000000 00000000 ci 6 cio- ci 60 ci 00000000 ~~~~o_~_~o_ ooaoaooooooooooocoaoaoooco ooaacoaoocaoooacoaaooaoooa aooaaoaacoaoooaooaaoaoaooo oooaaoooaooooaooaaoaoo"'IToao O~OOMmoooooooooooaaaMooamLOOO g~~~~gggggggMgggggNWgg~~g~ ommcicioooooooooaoaaocioamciao ommaoooooooaoooaoooaoomoaa .,.- .,.- -r- .,.- 00 00 00 00 00 0- 0 <Xl 0 o Ntri 000000 000000 oaoooa 000000 00_0000 a-coacia 000000 oocaao MN-M-M-MM 000 000 aoo 000 000 0- 0 ci 000 000 LO- to ~ 0000 000 a 0000 0000 00_ 0 0 o-ocio 000 0 OLOOO C\I- ~N- N 000 000 000 000 000 cicici 000 000 M- C\I- LO- a. a. a. a. o 0 0 0 ~~~~~~~~~~~~~~~~~~~.~~ ~~~~~~~~~~~:E:E:E:E<t<t<t<t<t<t c c: c: c: c: c c: c: c c c: c c: c: c:.g>.g> .g>gg 9 ~~~~~~~~~~3~3333~~~~~~ ~~~ ~~~ ~~~ ~~~ ~~~ ~~~~~~~ u..XXIIXIIIXIIIXXIZZZZZZ m~~~m~~mm~~~me~~~e~m~~ W Q)Q) Q) IDQ) Q) WID Q) Q)Q) ID Q)Q) Q) Q)Q) Q) CuQ) Q) ~~~~~~~~~~~~uu~~~~~~uu (1)Q)Q) Q)C1)Q.1 Q)Q)Q) QJQ)Q) Q.JQ)Q) Q)Q)Q) Q)C1)Q) Q) ~~~~~~~~~~~~~~~~~~~~~~ :0:0 ~ ~ 00 E E III III LL LL ~~ Ql Ql '0 '0 Ql Ql LLLL 00000000000000000000000000 00000000000000000000000000 II) ~ "t: ::I C,) Gl (/) 0 C ;g o 0 Co ::I o o >. C,) c:: Gl CI < ONJ"o...m~m ~88~C;0 000000 g~88888~~~~~8~~8~~~ ~ooo~oo~o~~o~~~~~o~ " C ::I U. m OOOON oo~ "f!!t'''f!!t'~NOO mLOLOON I~WW~~LLM~~I~WLLZZaaCf>a ~~R~~X~~~~<Xl~~6~~~~~~~ Gll{) XCf>Cf>XXXXXXXXXXXX ~M ~~~~~~~g~~~~~~~~ ~M MMMMMMMMMMMMMMMM MCf> ICI:: ~~ Cf>LL I{) co MM MM co.q-~oo::t 1-1{)Cl::Cf> a1~~<( <tco<t::2; co~com 0'> tOm 1.0 (")M("")M C;; M MMM MMM MMM MM o o o o o o o o o 0; o N 0 (5 0 N N o 0 N 05 ~ o 0 Lf~l( ~ ~ is ,2 "0 1:: o 0.. ~ CO; -r ... o o N .; ... M -r CO; -r ... o o N .; ... o '0 o 0 ci ci o 0 o 0 o C <Xl <Xl .... .... .; .; ... .... c;; ~ o 0 :0 I- ::l 1Il "C C ::l IL E CI> c CI> C) ~ ~ ,...:,...: ~<5 u-I~ g: g. j:'a:: o ..,. N ,;.: ~ r-- o o ~ 25 iD " o C :J a:: 5~'1 QUARTERLY INVESTMENT REPORT First Quarter Fiscal Year 2007-2008 September 30, 2007 Section II - Investment Charts INVESTMENT CHARTS FOR THE QUARTER ENDING SEPTEMBER 30, 2007 l.o Ob ( r INVESTMENTS BY TYPE (September 30, 2007) MONEY MARKET 2% I FEDERAL SECURITIESJ 74% LAIF /~ 24% FEDERAL SECURITIES BY ISSUER (September 30, 2007) FNMA 20% FHLMC 19% FARMAC 3% FFCB r 9% FHLB 49% INVESTMENT CHARTS FOR THE QUARTER ENDING SEPTEMBER 30,2007 7't> \ ( $30,000,000 '$25,000,000 $20,000,000 - $15,000,000 $10,000,000 - $5,000,000 FEDERAL SECURITIES CALLABLE vs NON-CALLABLE CALLABLE 35% NON-CALLABLE 65% September 30, 2007 - Portfolio Maturities $0 No Maturity (l Yr or Less) (l Yr - 2 Yr) (2 Yr - 3 Yr) (3 Yr - 4 Yr) (4 Yr - 5 Yr) Date QUARTERLY INVESTMENT REPORT First Quarter Fiscal Year 2007-2008 September 30, 2007 Section III - Listing of Monthly Investment Transactions ~~'l , ., 0 0 0 0 0 00 '" '" '" '" '" 0 0 0 0 ~ u; ~ CO > 0- c u 0 0 0 0 0 '" 00 00 00 00 CO 0 0 0 0 '" '" ~ ,..; :0 c ci r-: r-: r-: ci M '<i ... '<i '<i ~ ci ci 0 0 .,; .,; en ~ z <( f'- f'- '" 00 00 CI) '" '" '" '" '" 0 0 0 00 00 CO .., ::> iii ~ <0 00 00 00 .., .., 0 0 0 ~ ... 0 ii:' :;i 0 III N N N 0 0; .,; 0 M ..; ai ai 00- 0; M ..; ai ,2 -'> '0 ~ ~ ~ 0 '" ... '" I'- ... Ol Ol Ol <0 I'- ... '" u.1 1:: V '" '" '" .., .., .., Ol ..,.- ..,. Ol <0_ co ..,. :g 0:: 0 ~ M ",- ..; ",- M M M M ..; 0; <0 .,; .,; '" III ",- t:: a. a. '" '" M "'''' .., ..,. 0 ;;:-~ (3 0- -' 'C <0 co I'- ... U; ~ ; q~/( ., <0 co "! "! '" > r-: r-: ;;; ~ .,; en 00 "0; Ol en .., 00 CI) ~ u '" N '" N ~- ~- ... ., M ..,- 0; a> t:: ~ ..,- 0:: ..,. v '" N ~ V ... ..,. II) III ~ 2 .E III 0 0 0 0 0 0 0 iii 0 0 0 c::> 0 0 0 ~ ci ci 0 0 0 ci ci f! 0 0 0 0 0 0 0 0 0 0 'C 0 0 cD cD cD ;: 0 0 Ol en en ~ '" 0_ '" ... ... M ..; ..; ..... ~O ._ 0 >N Z:;:l -(.)or- ffi<t~ ::> C')- s::: ::::J C ._ .., LL~ og~ ~J:O ~~N -J:or- o f1> ns~ o ::::J .., J!l 0 0 0 0 0 0 0 0 0 0 0 0 0 0 c;; ci 0 0 0 ci ci ci 0 0 0 0 0 0 C- o 0 '" II) '" ., cD ",- N ..; ..; c ~ I'- '" :! :! Q. "0; u ., 0:: C Q) I'- I'- 0'" 0 0 "- '" 0 0 t>c ~ ~ '" 0 0 III C ;:::: ;:::: f! 0 0 I- ...., 0 ~I 0 c... I'- ... ., '" 0 0 1::0:: .,; iii ::> (J g ..,. ~ ..,. 0 0 ., ::> (i) u u C ., >- '" III III iii III Cl C .2 :0 "C C "0 w C 0 'C ~ ::> u.. .l!! 0 C 0 '" 0- r::: III iii - :J 0 "0 2 > 'II: 0 r::: 0 ... 0 :J .a Cl C <( U. ::> ., I; III en S - III :J Q) :0 III -'" ~ ., ... E 0 ., > III :J 0 Qj C ~ ~ ::>- "0 "0 III .!!! >- () ii: Q) r::: 0 ~ I'- ... I'- I'- I'- I'- I'- I'- I'- I'- iU 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ~ ~ '" N '" ~ '" ~ ~ '" - 0 '" N c; c; (0 '" m 0 0 0 M '" 0 0 t- ;:::: ;:::: ;:::: ;:::: ;:::: ;:::: ;:::: ;:::: ;:::: ;:::: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ~I 0 0 0 0 0 ~I 0 '" '" '" '" II) '" '" '" M ... '" '" '" '" '" '" '" '" N '" .,; .,; .,; .,; iii .,; .,; .,; .,; iii <0 M ..,. ..,. 0 0 0 ., 0 ., (i) u (i) u C C >- '" >- '" III iii III iii III III Cl Cl C C :0 :0 C C W W ~ 'C ;; 'C 0 0 C 0 C '" '" 19 iii 0 '0 0{) :lS :lS ... ::> ::> :: III III f'- co .., 0 0 v V N 0 0 N 0 u. 0 \::! ~ <( ~ 0 ,!C; ...J CD ro :3",- 0 c: ::> 0:: , 111 () () () () '" '" 0 0 0 0 0 0 0 0 0 .... .... ~ 0 0 0 0 () .... > a. .!: u () 0 0 () 00 (X) M M M M M M M M M <t <t 0 0 0 0 () <t .-: .-: :0 e ,..: ..: ..: ,..: ~ -<i N N N ..: N N N N ..: <<i ..; en 0 0 0 0 0 ..; Z <( r-: r-: l'G 00 (X) (X) 00 '" '" <D <D <D M <D ~ N N <t (X) 00 00 0 0 0 0 0 .... ei ::::l C;; ~ ..... M 00 0 0 (X) .... (X) '" .... <t ..... ..... 0 0 0 0 () M CL t;i 0 lD N N N rl ..; M ro ro en e en .n- M l!). N M ..; ..; N N N N N ,.: .2 -' > '0 ; ; .... N M M (X) ." (X) U; ~ ." ." l!) 00 .... N N l!) <D 00 M :E u..1 "5 <t <t M <t <t <t <t <t <t '" <t ." ." en 00 <t ." .". 0 0 'OJ- ..; M M ..; ..; M ..; M M M M M N N .n- ",. e ro <D 0 0:: a. Z;o ;;:; t:: ~~ M '" '" N N M 0 i:3 a. -' 'C (X) 00 '" '" () M l D~ tI 111 <D 00 ... 'OJ- () ..... > 0 0 ..: ,..: 0 cO '0; ." en 0 () en u <D. 00 N N 00 111 ... i. ..,.: -i' = 0:: ..... N u; l!! ~ .5 1/1 () 0 0 0 0 M M 0 0 ..... 'OJ- c;; () 0 0 0 0 (X) 00 '" 0 0 '" M == 0 .n 0 0 .n 0 0 en 0 0 en 0 l'G .... ." 0 .... <D () (X) 0 0 .00 en -5 (X) "'. (X) N N 00 0 0 ..... en C; cti ..,.: en N U; e e ..... ..; 5 0 N '" 0 0 '" () ~ o. "'. '" N '" ." 00 N N N N .n- o ..; ..... ..... J!l () 0 0 0 0 () 0 () () () () 0 0 0, () 0 () () '(jj 0 0 0 .n 0 .,; 0 0 .,; 0 0 0 .... '" N 0 () N Co '" 00. (X) N 'OJ- 0 () 'OJ- 111 e .n- = e 0 = c '" U; N N ... 'OJ- 00 ..... o. C!. ..... ..... ..... ..... 0 0 ~ N '> or- Z CO') +:: - -oJ (.) In m <( ::::l C) ::>> C) ::::l 0 C <( LL. :.i 0 (.) ..... CI) 0 ~ .c: 0 () N - () .c: or- U) - as In () ::::l C) ::::l <( ... Co '0; U 111 0:: e ., .... .... .... .... .... .... .... .... .... .... ....' .... .... .... .... .... .... ni 0'" 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ,_ l'G 0 0 0 0 0 0 0 0 () () 0 0 0 0 0 0 0 'tic ~ ~ ~ ~ ~ N N N N ~ ~ ~ ~ ~ N N ~ - l'G C; C; C; C; C; ;0 j;: j;: M ;;:; ;;:; ;;:; co j;: N 0 1/1 0 0 0 N M 0 0 N l- e ;0 co co co co co co co co co co co co co co co co l'G 0 0 0 0 () 0 0 0 0 0 0 0 0 0 0 0 0 ~ "'111 0 ~I () 0 0 0 0 0 0 0 0 0 0 ~I () 0 0 0 51 () e_ .... '" '" '" ... ... ... ... ... ... ... ... 'OJ- '" '" '" M 11ll'G 0 () N N N N N N N N N N N N N N N ::0:: .n .,; .n .n .n .n .n .n .n .n .n .n .,; .n .n .n .,; ::I U Q ... <D '" ~ ... ... ... 0 () 0 0 111 0 111 0 111 ::I u; U u; U u; U u e e e 111 >- l'G >- l'G >- l'G Ul Ul c;; Ul c;; Ul c;; lD lD lD 0> 0> .0> e ,2 e r:: :c :c :c 'C e (5 e e e 'W 'E w W ::I C; 'C C; 'C C; 'C LL III 0 e 0 0 e 0 e ... l'G a. l'G l'G t: III c;; c;; 5 ::J '> 0 "C :s '0 'It t: 0 .s '" u :E ... - u ::J .c C) .c e <( U. ::I ::I ::I :: 111 Ul l/) Ul Ul .5 ... lU ::J .... 1Il :c 0 1/1 ~ ::J ~ 00 M 0 111 ... E 'OJ- ... N ... > lU () () () N 111 .5 :i!: ::J () Cii () u. () ~ ::I (5 ..... "C ..... ;;: ..... ~ 1/1 !!J. >- U u: 1Il ...J Q; t: U. m 0 3 0 :i!: c :J 0:: , CIl <:> <:> <:> <:> <:> <:> <:> to- ... lJ) lJ) lJ) lJ) lJ) lJ) co co <:> <:> <:> <:> <:> <:> co > a. .!:: (,) <:> <:> <:> <:> 0 0 <:> 'ot "'" It) It) It) It) It) It) "'" 'ot <:> 0 0 0 0 <:> 'ot ~ ~ :0 I: ...: ....: ....: ....: ....: ....: ...: cD cD M M M cD cD cD N N 0 6 6 6 6 0 ai .Z c:( ,..: ,..: CIl co co co co co co co co co It) It) It) N N N lJ) '" <:> 0 0 0 0 <:> to- 15 ..: :J n; ~ ~ ~ 0 0 0 lJ) lJ) ('") It)_ "t <:> 0 0 0 0 <:> to- CL " 0 lD N N N N N N- N ..; ..; cri ..; ..; m m m ;;; ~ N ...: ...: ...: ...: ..: Q .Q ..J > - ~ ~ ~ ;;; 0> "'" 'ot <D CD ... 0 ... N :: co <D ('") co co co co ~ :E u.1 '5 0 It) <>>. <>>. '" 0> 0> 0 <:> 0 0> ('") ('") .., ..; ..; ..; N N N N <Ji on N ..f "",- ..: <Ji a: Cl. .?;- 1:: ~~ N N N N N N N 0 (3 a. ..J I lJbl I "C N N N N <:> 'ot CIl N N ~ <:> .., > ....: ...: ....: ...: 0 .j 'ijj N N CD <D '" (,) CD <D co co 'ot CIl ..: ot "",- ot m 0:: ~ N ... III E CIl ~ III <:> <:> 0 <:> 0 <:> :: ~ <:> 0 <:> ~ n; 0 0 0 <:> 0 0 ~ 0 0 <:> ~ ~ 6 6 6 0 6 0 cD cD 6 6 0 cD f! 0 0 0 <:> 0 <:> ('") .., 0 0 <:> .., 0 0 0 <:> 0 CD ... .., <:> 0 <:> .., "C Q Q 6 Q 6 6 ...: cri on 6 on ..; oS 0 N It) to- o ;; ('") 'ot N It) to- '" CD N CD "t <:> <:> 0_ 0 <:> II) ~ N N ..: N ..; ai J!l <:> 0 0 0 <:> 0 <:> <:> <:> 0 0 0 <:> 0 <:> <:> '(ij 0 6 ..; 6 iii 6 0 iii 0 0 ... 0 to- o <:> to- e. 0 co 0 "!. 0 <:> "!. CIl on cD' 6 6 Q 0 .... .... N ... It) II) <:> 0 II) ...... 0_ 0 .... ""'- "t II) 0 N ..; ..: 0 N 0 ~CZ 'S;: a> Z .c ~ E :J CJ <( a> m - c. ::) C) a> C c en u. ~ 0 CJ ...... Q) 0 ~ .c 0 0 N - 0 .c - tn nI ... a> 0 .c E a> - c. a> en ... e. 'ijj (,) CIl 0:: I: CIl ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... n; 0'" 0 0 0 0 0 0 <:> <:> <:> <:> <:> 0 0 0 0 0 0 ,_ CIl 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 ~ ~ ~ ~ ~ ~ ~ N ~ N ~ ~ ~ N N N N ... CIl ~ ~ CD <:> ;; "'" ;::: 0 2; ('") ('") ('") ;::: M ;::: 2; 0 III 0 N 0 0 0 N ('") .- I: lJ) 0> m m m m m m m m m m m m m m m CIl 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <:> ~ "'CIl <:> 0 0 <:> ~I <:> 0 0 0 0 0 0 0 ~I <:> 0 <:> 0 ~I 0 1:... 0 0 0 <:> 0 N N N N N N N N ('") ('") ('") "'" CIl CIl 0 0 0 <:> 0 0 0 0 0 0 0 0 0 N N N N 1::0:: ..; ..; ..; ..; iii ..; ..; ..; ..; ..; ..; ..; iii ..; ..; ..; iii ::l U 9 "'" CD ('") ~ "'" "'" "'" 0 0 0 'I: 0 CIl <:> CIl 0 CIl ::l Ui (,) Ui (,) Ui (,) (,) I: I: I: CIl >- CIl >- CIl >- CIl en en n; en n; en n; lD lD lD Cl Cl Cl I: .2 I: I: '6 '6 '6 "C I: ~ I: I: W W W I: ;; ;; ;; ::l "C "C "C LL .l!l 0 I: 0 0 I: <:> I: CIl a. CIl CIl C VI n; n; ]i :J '> 0 " '0 S .3 '" "" 0 C ~ 0 '": ... 0 :J C> .0 .0 I: c:( IL ::l ::l ::l CIl en (/) en en S Q) 1'0 => r-- :c 0 III "" ; ~ <D ('") 0 CIl ... E 'ot "'" N ... > 1'0 0 0 0 N CIl .E :!: :J 0 Qi 0 IL 0 N ::l (5 .... .... ~ 25 III " <( !!J. >- U u: ...J Q) Q; C IL ro 0 <( 0 :!: ...J c: :J a: