Loading...
HomeMy WebLinkAbout4.04 Investment Report 1st Qtr~~~~ Off' nU~~~ /ii ~ 111 L~~ - ~ ~~~ DATE: TO: FROM: SUBJECT STAFF REPORT CITY COUNCIL CITY CLERK File #320-30 November 15, 2011 Honorable Mayor and City Councilmembers ~~ Joni Pattillo, City Manager ° ~' City Treasurer's Investment Report for 1st Quarter 2011-2012 Prepared by Paul S. Rankin, Administrative Services Director EXECUTIVE SUMMARY: The City's investment portfolio totals $104,369,517.28 (par value). As of September 30, 2011, funds were invested at an average yield of 1.322%. The portfolio includes both discretionary and restricted funds and the balance will fluctuate throughout the year. The report presented provides background on the City investment portfolio, as well as the investment results, as of September 30, 2011. FINANCIAL IMPACT: Investments are made in accordance with the City Investment Policy and State Law. Interest earned is apportioned between the Funds (i.e. General Fund, Gas Tax Fund, etc.) based upon the proportionate share of the total cash balance. The current earning rate is 1.332%. Actual revenue will be impacted by both the interest rate earned and the balance invested. RECOMMENDATION: Staff recommends that the City Council receive the Quarterly Investment Report. ~'~ ... , ~" M_ °~...,,..... ~ " ~ .. l a,ti~ .......~~ . Submitted By Reviewed By Administrative Services Director Assistant City Manager DESCRIPTION: The format of the quarterly report consists of the following components: Section I -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 (Includes a listing of Federal Securities including call date if applicable) Section II -Investment Charts Page 1 of 5 ITEM NO. 4.4 Section III -Listing of Investment Transactions by Month 1St QUARTER RESULTS As shown on the Portfolio Summary the total investments as of September 30, 2011 were approximately $104.4 million. The "Yield to Maturity" was calculated at 1.322% and the weighted average maturity of the portfolio was 605 days (1.66 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 maturity drops to 412 days (1.134 years). The Market Value, as of September 30, 2011, was approximately $1.4 million more than the Par Value (Par Value = $104,369,517 and Market Value = $105,776,447). The Par Value is the "face value" or principal amount at maturity of the note or bond. The typical investment approach used by the City is to hold investments until maturity. The City does not actively sell securities prior to their maturity. In the current market, the premature liquidation of a security would result in less interest income upon reinvestment, diluting any gain achieved from selling the investment prior to its stated maturity. The following Table displays the comparative results based on information in the Portfolio Summary for the most recent five quarters. This allows for a comparison to the most recent quarter as well as the same three month period one year ago. Table 1: COMPARISON OF PORTFOLIO MEASURES Most Recent Five Quarters 2010/11 2010/11 2010/11 2010/11 2011/12 Portfolio Quarter 1 Quarter 2 Quarter 3 Quarter 4 Quarter 1 Measure (Jul-Sept (Oct-Dec (Jan -Mar (Apr -Jun (Jul-Sept 2010) 2010) 2011) 2011) 2011) Par Value $90,326,716 $103,312,201 $96,536,664 $101,656,026 $104,369,517 Average 363 da~Ts 472 da~Ts 535 da~Ts 650 da~Ts 605 da~Ts Term (1 ~,~r.) (1.29 ~-~rs.) (1.47 ~-~rs.) (1.78 ~-~rs.) (1.66 ~-~rs.) Yield To 1.62 % 1.48 % 1.47 % 1.388 % 1.322 Maturit /Call As noted in Table 1, the total portfolio balance has increased from what was reported one year ago. The collection of one time payments, Impact Fees, and reductions in expenditures have contributed to the balances reported. The total portfolio will fluctuate between fiscal years based upon several factors including: planned expenditures, fluctuations in revenue collected, and differences in timing of both revenue and expenditures. The timing of revenue collection and issuance of payments also impacts the balance available to the portfolio. With recent building and development activity there has been additional revenues collected. The balance is also impacted by the lag in the billing for contract Police and Fire Services. The average maturity of the investments held has increased over the past year from 1 year to 1.66 years. This is, in part, as a result of placing new investments. Compared to the previous quarter the length of maturity dropped slightly from 1.78 years to 1.66 years. Page 2 of 5 INVESTMENT ACTIVITY DURING THE FIRST QUARTER This report discloses changes in individual securities due to Maturities, Called Securities, and New Investments. There were no securities which matured during the quarter. As shown below one transaction was due to an investment that was called prior to its stated maturity dates. TABLE 2: INVESTMENTS CALLED DURING THE FIRST QUARTER Original Date Maturity Coupon Type* Acquired Par Value Date Rate Call Date FHLB 12/21/2010 $4,000,000 12/23/2014 1.0% 8/19/2011 TOTAL $4,000,000 * FHLB =Federal Home Loan Bank; FFCB =Federal Farmers Credit Bank; FNMA =Federal National Mortgage Association or "Fannie Mae"; FHLMC =Federal Home Loan Mortgage Corporation or "Freddie Mac" Two new investments with a combined par value of $7,000,000 were purchased during the first quarter. TABLE 3: INVESTMENTS PURCHASED DURING THE FIRST QUARTER Type* Date Acquired Value at Maturity Maturity Date Coupon Rate Effective Yield with Premium / Discount Call Date FNMA 7/15/2011 $ 3,000,000 7/15/2015 1.50% N/A 7/15/2013 FFCB 9/6/2011 $ 4,000,000 9/6/2013 0.49% N/A 9/6/2012 Total $ 7,000,000 Both of the securities which were purchased have call provisions as shown in the Table above. Although securities can sell for either a premium or discount depending on the market on the day the security is purchased. The purchases made in the first quarter were completed without the payment of a premium or discount. The "premium" or "discount" is allocated over the life of the investment in the City accounting records. 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 September 30, 2011, 34.09% of the portfolio was immediately available in the Local Agency Investment Fund (LAIF) and Money Market instruments; this is slightly less than the 35.5% reported as of June 30, 2011. • Federal Agency Securities represented 65.63% of the Portfolio, which is slightly more than the 64.3% reported as of June 30, 2011. Page 3 of 5 • There was diversity in the issuers of the federal securities held in the portfolio. A total of four different issuers were represented. (FNMA-20%; FHLB - 58%; FFCB-12% and FHLMC-10%). • Securities issued by the Federal Home Loan Bank (FHLB) total $39.5 million as of September 30, 2011 and represent 37.9% of the total portfolio. The City investment policy states that the Treasurer shall strive to provide diversity among the debt issuers purchased. The investment policy suggests that the placement of investments strive to limit the maximum to 40% of the total portfolio. The changes in the portfolio holdings during the first quarter, brought resulted in the percentage concentration with a single issue being below the maximum target. In the June 30, 2011 report, FHLB securities represented 42.8% of the portfolio. • The investment policy also suggests that the City strive to limit callable securities to no more than 25% of the portfolio. As of June 30, 2011, the portfolio was slightly above the target at 26%. The changes of the holdings during the first quarter resulted in only 23% of the total portfolio being invested in callable securities. • 43.9% of the funds are invested for one year or less compared to 36% reported in this category as of June 30, 2011. • 27.3% of the funds are invested in securities with maturities of 3 years or more, compared to 29% reported in this category as of June 30, 2011. MONTHLY TRANSACTIONS Section III of the Report provides a list of transactions related to investments in the City portfolio for each month of the first quarter (July, August, and September). This schedule provides compliance with the Government Code requirement to disclose monthly transaction data. It is incorporated as part of the quarterly investment report rather than individual monthly reports. RECENT TRENDS COMPARED TO BUDGET The assumptions used to project Fiscal Year 2011-2012 revenue earned from investments, included a Local Agency Investment Fund (LAIF) return of 0.50% and an estimated total portfolio rate of 1.5%. As noted below the rate for LAIF during the first quarter was below this threshold. TABLE 4: Local Agency Investment Fund (LAIF) Quarterly Rate 2010/11 2010/11 2010/11 2010/11 2011/12 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Quarter 1 (Jul-Sept (Oct-Dec (Jan-Mar (Mar- June (Jul-Sept 2011) 2010 2010 2011 2011 LAIF 0.51% 0.46% 0.51 % 0.48 RATE 0.38 The total portfolio earnings of 1.322% is also below the FY 2011-12 budgetary assumption. On an annualized basis, this lower interest rate could cause a decrease in General Fund revenue of Page 4 of 5 $100,000 - $110,000. Since only one quarter of data is available for review, it is too early to recommend any adjustment at this time. It is anticipated that there will not be a rapid increase in interest rates over the next 1-2 years. Staff will continue to monitor conditions and provide updates as part of the investment report. NOTICING REQUIREMENTS/PUBLIC OUTREACH: None ATTACHMENTS: 1. Quarterly Investment Report For The Period Ending September 30, 2011 Page 5 of 5 CITY OF DUBLIN QUARTERLY INVESTMENT REPORT First Quarter Fiscal Year 2011-2012 September 30, 2011 Report Prepared October 31, 2011 Report Presented To City Council November 15, 2D11 Section I -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 ATTACHMENT 1 9 U `~ ~ s ~ ~ ~ ~ cfl th ra+ !6 „y U s~ ^ ~ 1 N ~ ~ l~- ^ O O ,Q \° ~ O O `1 Q7 O ~ r O ip ~ ~ ~ Q} ~ O Z ~ ~ N ~ M ~ ~ R f/? ~ O ~ O ~ `- /"' Q ~ y~. Q7 Q o a .~ a ~ ~, ~. ~ ti ~~ Q1 7 '~ d 7 C 0 0 o co CO N ° a cn ~ m ~ N O O O r^' e ry r r ~ ~ N ~ ~' I Y Y ~' t-" Lq N ~ ~O ~ to ~O O Cep ~ co ~ ~ 0 G T ~ r cO C~' ti N N ~ ~ ~ i e w r c c p 00 N d' LCY ~ ~ ~ N u '~ ~ ~ c+~ co ~ N N o CU N co 0 ~ m ~ ~ ~ a; ~o ~ ~ N I~ Cfl O N ~ ~ ~ ~ m cfl N O ti N [D N o9 O e0 N cf O 67 Cp [~ O CV I~ CO C? N Ss 3 lt7 ~ c ip N Ch O e- 67 M O N ti 4tJ 0 N N C'7 O O ~ ~ ~ ~ ~ ~ ~ ~ O U ~ ¢ ~ to a' ~ C O ~ V- Q ~ N ~ RS U ~ ~ ~ ~ ~ #~+ O ~ N N N N N d ~ ~ v ~ ~,,, x~. ~ v .~ a ~ f~ ~ R v ~ a 0 N N e~ N C}' ti7 O ~[? 'tea` to 0 0 O ~fi ~, M 0 CO O N ti 4A 6] (Q M d' O F}} d c ~ ~ rq s ~ y ~ ~ O ~ E.. C as E-' cri 0 X x a~ ~ ~ O a--+ ~ Q ~ V] ~ w "~ ~ ~ ~ p. ~ ~ ~ b cC ~ .ti C~ ~ U C6 '~ ~_ ~ ~ .~+ "t7 O U y o v °" 3 o °~ U .O ~' ~ ~ -~~ Q ~~ ~~ o O ~, ~ a ~ U '~ c~i q ~ .~ ~ `*~ ~' U_ O O > N ~ .~ O ~ ~ ~ ~ ~ W ~ ~ E-~ ~ ~ U ~ Fw ~ ~ ~ C O ~ O ~ ~ C ~ ~ '-. ~ ~~ ~~ ~ ~ ~ ~ ~ Q .~ a ~, U 3 m a~ ~. U v .~ [/] w 0 L L7 ,p .~ O 3 1 ~. C w O 4- O s b a~ N O G _O Q ~, y'~.s -~ W N a~ ,-> W ~ °+.' ~ ~ a~i -~ ~. U ~ U ~" .-, ~ ~ .~ ..~ z 0 0 a v v c 0 .~ ~+ tl) W ~ ~^ ~ r O ~_ ~ ; ~ g ~ ~ O ~ _ ~ ~ D ~ y ~ p ~ '~ ,~ ~ .~ ~ O ~ ~ V i 0 0. ~ ~ O ~' Q Q ~ Q M r M r d" r d' r N .r.. ~t r.. ('~ 'C"" N r ~ r M `t""' ~ ,,.... N ~"' M ~"' M s... ~ ~'"' d' l""" M ~"" ~ e^^' ACS ~"' CO Q.... ~ T a J Z z z ; o o o a o 0 o o o 0 0 0 0 0 0 0 0 0 0 0 0 •" N ~ a+ N ~ N ~ N ~ N ~ N ~ N ~ N ~ N C~I N N N ~ N ~ N ~ N N N ~ N N N ~ N ~ 16 (D M c}' M O O ~ f~ N ~ r 07 er M Q ~ N O in f~ Ca ~ Q ~ d7 N . r . N . M . M . N . N . t- . N . N . E C~ r . r . M . N . N . M . r . N . N ~ N r ~ O r O O r N DO Q O N r (fl O N r N r ~fJ N r 1~ O W E- - N CO DO ~-' r O5 CD r M ~f7 CO ~f7 X47 M Ln I~ M ~ ~7 iS? ~ N ~ In N N C4 - - 'N ' ' r M M O O et O G O O N N O CD r M N ~S7 N O N r O e . N . ~ O O O G Q O Y r r r r r ~ r N d- N r ~ r N ~ r U S ' p ++ r r r r r N ~ d' d ~f7 [.4 'cf' N CO r M r 'M ~ r M O N d" CO O OQ ~'N N ~ r r r M N r [~ I~ 6'J d' CD N r O] I~ O CO Ln M ~ N E r H ^~ M CO r ('~ r ~C] M O CD lf~ r CO l~ N Ca v-^ CO Ca Ct Cfl r r r r r ~~ ~ U [ r r r r r ~ tf3 1~ O >n CO ~ N Ca r M T M d' I~ Cb O I~ d" N Q r 'u? ' p ~. O e- N r M N r M I~ Q c7 O N r OQ GD Q OD a0 M LCS ' N O ' ]--~ .~ €~ Da Q r r M r r tf~ M O r (A L(7 r r C9 1~ r e- r r C9 ~ T M r f~ z^^ ~ r CTd - CD tli 3 ~ T w' N Ca CO ~ r w M r M ff') I.C) F,{) LI7 LC) lS7 l(J lf7 lC3 L!1 lf7 ],(j IS7 II} I.f) N N ~Cl r C r M M C Q ~' ,C,: O O r N N ]~ ~ N ~j N f~ ~.,:, N N N r; r N ~~ 0 0 C7 C C7 O r r r r r M r r e~' M r d" r ~ ~ ~ ~ i r N ~ r r; p ~ V I I ~ r CS) GT CAI O I~ 0 0 0 Cd 0 0 i~ O O f~ O DD O O lCl O O O N ~ N cJ N <t [ f~ tiE O O O O O N O O M O M M I~ Q Q O O C? O C7 M C c? N Dp N C ' CD tD 0 ~ 0 0 0 C*7 O C] ~I' CJ O (V CO O C7 0 ['7 O O C7 d- G 1~ ~ C4 CT~ C7 ~ r r O CO O O O d' O O I~ O O ~ N N O O M O O O l~ d7 O' iy ~t N n. : CO Q O ~ O O O 'ct O C7 cP O ~7' ~t W €1 0 0 0 0 0 O C9 u~ r ~ M CO .C1 G7 ~ 0 61 0 0 0 CD O O O O O N a1 a7 O O ~ O 0 0 ti ~ ~ CQ 3~ M N N 0 0 0 0 0 0 0 0 00 Q C57 C] W r O O r 0 0 0 67 N ~' ' p ~ t~ N N O Q O O O O 0 0 67 0 d7 0 0 0 ~ 0 0 O O O O U7 c'~ p C M M M M ~1' M ep M M ~- M N C*~ r ~t M G M ~ N ~ ~ M r DD r CP1 , G7 Cn 0 0 0 0 0 0 07 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CO N N ~ ' 1~ h 0 0 O Q O O Q O Q 0 0 0 0 0 0 0 0 0 0 0 0 C N ~ 0o N 4 CO ~A O O O O O O O O O O O O C7 C7 C7 0 C7 C7 C7 Ca C? G ' t~ , LQ C+7 O r-~ r Cp O O7 L(? d' CC} Lfl 'c1' ~Y' 1S7 O Ln In 0 r Q 00 O is f9 3d7 . M ~ E ~ ~ ~Y N 1~ ~ 00 r O C4 I~ ~ O CD C6 N ¢f' r_ Cfl I~ N CO CO r CO r r a7 Cri ~ I ~ M Ca 01 G7 077 f~ r 0 O O Lf7 [~ CO C*7 67 r M lC} a7 N DO O LCJ ~ ~ 0 fti tU Q J 0 ~ ir! N N 67 I~ O M N ~f7 M M DO CO a7 ~ a7 N ~-- r ad t-- ~' L(7 O O ~n :co N N rn o 0 0 0 0 0 0 0 0 0 0 r N ors o r O 0 0 r to f~ ~ M c~ er M M M rt' M d' ~ c*S tV c*i c~i M r v ri V M ~ M ~ o ~ ~-- oa r a7 ca m > o o n o o a a o 0 o o o 0 0 0 o o 0 o o a o ao N N ~ ~ ~ 0 0 0 0 0 0 0 0 0 O 0 0 O 0 O O 0 0 0 0 0 Q N CD N O O Cfl 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O O O C ~. ~ co M a -- T 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 © o o o o o O T' ~ > ~ N ~ co co o 0 o O O 0 o a o o to o 0 0 0 0 0 0 o 0 0 0 ~n' ~ M CD 'CA G~ ~ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ff~. (fl 3~ :M c'.t N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CD ' ~ Lt7 :ffl N N 0 0 0 0 0 0 0] 0 0] 0 0 0 0 0 0 0 0 0 0 0 ~ M ~ ~. ~' ~ M M M V' M ~ V ['~ N M M C~ ~ d' M ~f' M '~7 M ~ ~, M :M ~ i r' O OD CO r O O T O e-- 0 0 r 0 0 00 0a 0a O7 r CD r r r r Q d (~ r r r r r r r r r r r O a 0 0 r O r ~'"~ r r y c7 o o O o 0 0 0 o 0 0 0 0 o 0 0 0 0 a o o o ca o t9 p ~d N N N N N N N N N N N N N N N N N N N N N N N {p ti C") C6 C Cfl M ~ Q Q Q Lf] O N r r M ~ Ln CQ O a1 ~ O ~ 1~ O y , ^ „~.~, N, ~ C`] ~ Q N . r . M . M . r . N . r . N . N . N . ~' N . N . M . N . r . M . r . N . N . ~ ~ r r ~ r- ~ r-- N T O P^' LD CD CO CO l[] C~ Lf? N T Sti 67 N T CO 0 r CO I~ 0 r ° m C o ~ ~ 4 ~. c G ~ ~ p li ~ ~ 9 1 ~ ~ y ~ C ~ Q Q Q Q N CA C ' LO CG1 m CQ m 0~ L~] CO Cfl CC3 CO m CO m LO ~ ~ ~ ~ ~ ~ ~ U U U {.) J _...€ J _I J J J J J .J ...1 J J J J C ~ L~ L~ T 2 T T 2 2 ~ 2 S 2 2 2 2 2 S Z ~ Z Z J LL LL LL LI... Lr.. LL LL LL Li LL LL LL E.L 11. 1.L LL LJ._ Lt LL LL LL ~# C N Q a ~ m ,.• Q) 1 v7 I~ "~f' M M r T N O~ O Q U~ ui 1~ N I~ CO ~ ~ ~ N QI ~ •'S! p ~ w (~ ~ L 0 0 0 0 67 O O CO O d1 Q 0 ]~ DO 0D O C0 O O 0 CC, ~ ~ ro c,) :~ r O O r O t^^' O O r O O Q C] O Q r O r r r O i% ~' o ~ +, ,~ 0 o ca o ca o o o o o o o 0 0 o a o o o 0 o a ~ U J a G) LL Q. r r r r r r r r r r r 'r" T r" e^^ T e^' r r r r a. ~ n. ,o C7 ; y g ~ ~ ~ x ~ m ~ ~ 1" ~ ' ~ u. ~ ,~, ~ ~ ° ~r {~ u.. ~' co ^ N ~ a N ~ x [~' ~ ~' ~ ~' ~ Cl ;o a in ~ to ~ O }- ~. ~ _~ O ~ ~ Y r ~ r r f~ d- I` X ~Y ~ X X o ~ ~ N ~ .~ X X x ' ~ r X L.L LL LL LL o ~- r CJ t] ~ ~ ~ Q S Q t'7 M M ['~ M M C'~ M m M M M M M M M M M M M M M M M M M e~ M [ ~ M et' [+7 Lfl N CQ M CD ch CA M CO M ~-' sQ. ~` O Q ¢ ~ ~ ~ ~ vf. r r r r r r r r r s- e- e- !"' r e^^ r r r r r r 3 Q J U J t/) ~ ~ N ~ c+'7 M M M M M M M M M M M M M M M M M M M M V7 [- T ~"' T _ ~ l~I ~ S2 M w s.. 0 a} .~ ~ ~ ~ {a ~ ~ ~ to O O Q O 0 0 0 R Q O O O O O O V ~ r r r r r ~ r xa m z N - ~- r N N r-' cn 'r"' c*~ ~" r r r r ~ (~ ~ N N N t V N N ~+ R ~ V' d _ Q O tC) f~ ^ d 4f O N ~ +? ~ Q Z c^^ r ('7 C'7 ~F' ~f' N ~ C+7 N ~ Ch L{~ N C'~J C'J ~ d' M `~' ~ ~ Lfl ~ r O R"" O ~-^ O C^' O r O r O r O r O r a r O r O r O r O r O r d r Q r C7 r Q r O r O r CS 'L, ~ ~ N N N N N N N N N N N N N N N t1f N N N N R ~ M ~' c*7 O O ~ I` N ~ Y-- ~ ~' m O 67 {~ C) L47 ti 00 ~ R ^ rn N t-- ~ N ~ C~7 C7 N . N r" . N N . c~ r ~ r ~ M ~ N ~ N ~ c'7 ~ r ~ N ~ N ~ ; ~ N r ~L" C] r CD 4 r N OO O OO N ~"" t9 67 N Y._. N e^^ Ln N r.. ~ CO O CA M r t"7 t[? ~ L17 lf') 1ID L~ Lf7 LCJ LCJ lfJ lC3 L{1 ~ L(? ~ N N _ fi r- O O r N N 1~ f9 N ~,j N f~ ~ N N N T € ~ ~ o ~ U 0 1~ c~ o ca ao o o ~ o o r~ o ao o o ~n o 0 0 N y o co o o o N O a c~ O Ch m ti o~ 0 0 ca o o a c~ ~ . o v 0 0 o c*i o o v o o c~i m o 0 0 m o 0 o cr O Cta 0 0 0 ~ 0 0 ]` O O Lf~ N N C3 4 c~ 0 0 0 ~ a te' O C7 O d O C:] ~I C] ei' d' O f~ O 0 0 r 0 0 0 CD ~ O 0 O 0 0 O 0 C7 0 C7 00 0 0 0 0 G7 0 ~ 0 C7 0 d N p 67 O O r G7 0 C? O r 4 O 0 O 0 O 3 Q O C7 a7 0 4 0 0 0 0 67 0 0 0 6] O tI~ O a 0 0 0 67 ~ GJ d' c*~ c*1 crs c~7 ~' c~ ~ c+~ ch .-- ch N c~7 r '~7 M d' c+') ~t N ` O N Q O O C~7 0 O N C7 1~ M C'~ f~ 0 O c*7 O O O d7 .r+ Qj O OD 0 O O N 0 0 Q O 00 1~ 0 (~ O 0 0 0 0 0 0 O (~ r d r r r ~ r ~- C¢ r f~ O 0 ~,,,, r c^ T r r r 0 i.. a7 0 0] 07 0 67 0 O 07 V d 0 r O a7 r 0) r r- 67 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 0 C7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O 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 -? a ~ ca o o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 © ca o a a o o c o o~ 0 0 o O o o o 0 0 0 o a o a o o o a o a o a o o o a ~ ~ 0 0 o ca o o o o o 0 0 0 0 0 0 0 0" 0 0 o a o o ca o c Q 0 0 0 0 0 0 0 O O O O 0 0 0 0 C] O 0 0 0 O O O O O O ~ 0 0 0 0 o o 0 0 0 a o o o o o Ln sr~ o 0 0 0 0 0 0 0 ~ ~ ~t cr oo ch ri c~ d-- r7 d' v c~i N e-i c~ cn ~ ~ d= cri i.~ v c~ et ry r ~ ~ fB m OD m CGI m Lxl C6 Cfl o~ oO O] CO CO [Q ~ ~ Q Q Q Q ~ (~ V J J J J J J J J J J J J J J J ~ ~ ~ ~G 4 lL LL S T T 2 = 2 2 2 2 ~ ~ = = ~ ~ Z Z Z Z EL L3. Ll LL Ll. Lt. LL L.L L1 LL. lJ.,, I.L. L.L. LL i.L L.L LL LL L.L LL Li ~ la ~ ~ v ~ ~ N V ~ ~ 1~ ~ ~ M CrS r r N d7 O O Lf7 Lt7 I~ N I~ m Cfl ei' ~ cf Lf7 N 67 Q ~ O d7 V 07 0 " 07 C7 0~ c0 0 07 07 Cfl 1~ oo LO ~ O OO J O O O O ~ e^- 0 O 0 LL 0 0 r 0 O 0 r 0 Q 0 O 0 r 0 0 0 0 0 0 0 0 0 0 0 0 0 = r 0 0 4 = _ O O _ O O Z I r r ~ 'C"" 5.... t"". t... r.'.' r r r r r r r r L.~ r r L.l. 'r .e.... Y.. ~.'.. ur ~ n ~ ~ ~ ~ ~ N 6, ~ ~ o U ~ ¢ 07 ~ 0p ~ ~ o3 z (0 Y C4 ~ ~+rj N ~ l4 o a ~ ~ ~ m C7 ~ c~ ~ ~ --y Y Ln ~t €~ co d ~ X ~ ~ 2 ~ }- ~ e r r I~ I` X L` ~ X I~ ~ L+ ~ ~ .Z' X ~ ~ i.L l1. LJ,.. l.1., ~ ~ ( ~ Q M M c'') c~ M can c+] c'~7 c'7 c*~ M ('~ cY3 e+') tY7 d' eb cD [0 Cfl CO ~ , y C'7 C~ - C*7 C*7 M S+7 C+') L'7 C'~J C~ C'7 M CrJ M C~ C+') N C*3 CT7 C*7 C'') i .~ ~e-- LY7 r-- M r- C'') r^ M r- ['~3 r c'') r c+7 r M r C*7 r C*7 r C'7 r CrS r C'~J r C+') r CrJ r ['7 r M ~., r C'7 r- M e- f'7 e-- C+7 d R m .C C C O `O a d 0 c ,O R Z L as m s ~ ~ II m ~ C ~ ar ~ ~ _ °' `v o `~ S '~ m i ~ d ~ a °: ~ ~ u. u `-' m a L ~ a c ~ i0 O a1 U Y_ ~ •L~ yl VC L L LL. SC d ~ ~ O IMI W L u~ ~ ~ 11 ~ U ~ ~ N ~ ~ ~ a F N C ICJ C d 7 C v m L V C n u QUARTERLY INVESTMENT REPORT First Quarter Fiscal Year 2011-2012 September 30, 201'1 Section II ~- Investment Charts INVESTMENTS BY TYPE (September 30, 2011) MONEY MARxET FEDERAL .22°i° _---- r -= - - ~: - r ~~ ~ ~~ SECURITIES ::n 65.63% __ ~. LAIF 34.09% CAMP .06°10 FEDERAL SECURITIES BY ISSUER {September 30, 2011) FHLMC 10%_ FNMA 20% FFCB _12% 58% ~"EDER.~.E EC~~IE~ C ~LL~i,B~E ~ s r1''C}~'-~ ~:L ABLE (~t~er 30, 201) _.-, t 1~~ r t' ~~ \O\-C ALT. ABLE i ~,7°,'~ ~` ~L~ September 30, 20'11 -Portfolio Maturities $40,000,000 $35,869,517 $35,000,000 ~~- $30,000,000 $25,000,000 ,', $22,500,000 $19,000,000 $2a,ooo,ooo ~~: $15,000,000 $lo,000,000 $5,000,000 $10,000,000 No Maturity (1 Yr or Less) Date $11,000,000 $s,ooo,ooo ~- (1 Yr - 2 Yr) {2 Yr _ 3 Yr) {3 Yr - 4 Yr) (4 Yr - 5 Yr) QUARTERLY INVESTMENT REPORT First Quarter Fiscal Year 201'1-2012 September 30, 20'11 Section III Listing of Monthly Investment Transactions o ~ r ~ ~ ~ N ,.~'+ e"' '- M .. '~ ~ © Q }- ,~ ~J '~" O ~ O y v N U ~ U ~ t p ~ ~ U C~ V_ m ~w GD 'c1 ~ ~ M M ~ ~ V' ti Liz N y a n 'r O Q7 _ N 0 to t!J ~' M Cfl '~!' ti LLB ++ CJ O U -;` ~ ~ n U i* a N ~ Q U Q ~ ~ ca L ~ p 0 = Ll. ~ ~ ~ ~ L ~ ~ (U ~ M W ~ ~ ~ sw n m ~ cc ~ c m ~ ~ Gl l w N _ N . ~ W a t!J R ¢ ~ i _ ~ ~ d ~ lC ils ~ U V LC) Cb CQ Cn CO 03 N O C7 0 0 0 I~ ~ CD ~ r ~- ~ m ~ ~ ~ m Cfl Cfl S~ CL~ ~ i'7 C'7 ~ i'rJ ~ ~ ~ e i'7 O O Lt'7 C7 ~ Q 0 0 0 C'7 Q Liz CJ ~r o~ cn N r-~ T 0 't"' l^ ~ r r 0 't"" r^ 0 ~e- r N ~ N ~ N ~ N ~ N ~ . ~ N M ~ 1 LL O ~ ¢ Q U J CJ U ~ Q fA ~ ~ ~ ~ O O C - o n U L w UJ N ~- ~ ~ a-. C i6 N ~ ~ U `~- ~ ~.. ~ H""' ~, ~ O ~ C C C ~~ p 0 0 0 O O '~ O O ~O O O n n o o n ~ ~.. a. o~ a. c~ ~ ~ ~ ~ ~ ~ ~ sW c n n s~ ~ m a~ ~ m m ~ ~ ~ ~ ~ ~ L L= L C L t= L C L i= L ~ N ... N N O O p ~ 0 7 0 > 0 > o > n ~ ~ ~ ~ ~ ~ » » > ~ d 41 41 ~ ~ 43 -a :a ~ -~ -a -a LL fi [.~. I.t_ W.. 1%. co co 0o co co m o~ m d CO 00 CO ~ ~ CO sYj r CA C37 CA CS) CS7 ~ ~ q ti ti ti ~ ti O ti ~ ~ ~ ~ O ~ ~ ~,7 (p (fl r (4 CO Iti CS') OD Ln C1' N N N t'r} C7 C*~ C''7 C'7 i`7 M E9 ~ ~ ~ C'7 ~ i ~ 67 C7 C7 ffl C7 G7 C] O O O 0 o a o 0 0 ~ t~ ci ci o ui r~ o 0 o a ~. ~ o 0 0 o co o ~r o~ o ni N ° ~ ~ ° ~ o . i7 ~ C '> C") N r r Lp ~/ CO ti~ 0 0 0 0 4 Q 4 C7 tri C~ O i[} N © O " CO et o o et w o o c> w cfl m u> N N N tf~ EH .~"' '" ~,... .... t,... '"" .~...' ... [ 0 1 ~ [ Q r CrV N ~I N ~' d' CV CO r^^ ~. r^ r N ~ N ~ , ~ ti ~ ti .x Q ~ O s= Q Q m '~ Q O ~ (~ ~ O O O O _ ~ L ~ L ~ L ~ ~ p ~ C ~ R w V ~ SG i G W MM l.1.1 ai a~ ~ ~ _ _ LL! lif ~ ~ ~ S= i4 eC o ~ ~ ~ ~ o ~ J ~ J J ~ ~ ~ . LL LL LL li 3 ~ _ Q Q 4 Q Q N .l ~ ..~ 1 ...~ .~ a 0 .~ ro ru c m c m n a. c 0 0 D ~~ ~ ~ a N .~.' r' ~ M ~ ~ Q Q ~ w, ~ ~ O ~ O .X ~' V ~ U ~ U ~ C y L U ~ © I~ cfl i ~ ~ ` it ~ ~ ~ ~ CG ~ ~ CO '~ ~ } "~ a~ c U O q a r N O CA O C7 M ~ r ~ ~ ~ ~ M h h M M [~ N ~ 'C7' ti] M 'C 6F} N ~ ~ O O O O O N C? r a F o i a ~ w ~~ ~ ~ c m m m ~~ ~ ~ ~ ~ c~ ~ ~ c ~ `~ _ ~~ w ~ a~ ~ Q ~ ar •~ c4 .:° L ~ ~ w 4 t' .~ `«- r lE i6 ~ U U d v ~a ca a, a 0 W N m v e~ m ua c c~ 0 a+ n m c 0 C a F c c c a. s c 0 c '~ f~- 00 C9 Cp 6J 6J 6J O7 O1 61 d7 O d d d C Q N N 'ti' i`~- 3+ 1+ 1~ I~ ~ [~ O O O O C i N 00 CO N r- r r r (D CO t9 (Si C? C) O C 4s CD CO CO~ ]` 6] 6? 67 67 r t... r M O O O C ~U c!' ~i' cl' r r r Cfl r M M C9 ]ti O O d C '~ ~ M M M tY' ~Y" fit' CO fit' N N C1 !'7 M M C'7 CY : cQ W to Lfi ct7 ifi C) M I~ O N ~ !` ~ 00 <1 cG.::-` 0 0 r r r N N ~ 67 M CD OC I M M M M C~' O O tlD O ~ i d O CO d ~ O O CTi d ~ C7 C? I~ O L O O d d d O d a] d O ~S'7 t{) ~ ~ .Y. ~ T ~ N 7+ p M N y..":, ~ ~ ~ 0 O O tC3 47 0 C) O ~ N 0 C) N C4 C~U 0 O A O co7 O 4 N tD ~ r d C) O O Cfl r ~ GS O Q O O C) O O O C) 0 0 0 0 0 Q Q }~ +-~ N N N N N N N N N N N N O ~ a7 47 ~ d r O Y ~ ~ 6~ 6) ~ ~ ~ ~ C i~ 7 N w C ~ ~ ~ U ~ 1 M O N O) O . . o o n O o ca ~ . o © © © .«- ~ ~ S a ¢ Q Q o Q U a `~'` ~ ~ ~ ~+ d 0 O ~ C ? ¢ ¢ ~ ~ c c ~ OQ 0~ 00 ~ Od 0 0 0 0 O C ~ Q7 ~ C C C ~ O ~ O ~ ~ 0 ~ 0 ~ 0 ~ 0 ~ ~ ~ ti ti ,r ~ ~ ~ ~ ~ N ~ ~ N ~ y y N _ O i _ ~ p fll N ~ C ~ C C 0. c ~ ~ ~ C C ~ H H I- [- F N C' } C O O O O G O r .C.. ~ ._.t ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ p p 0 0 0 O O N W ~ ~ ~ ~ '~" O ~ O ~ O ~ 0 ~ 0 w ^ eC _ t~ ~ C 'C 'C 'C 'C 'K ~ cCf d. 0 0 0 0 o cG f~ ~ f!1 ~ lE ~ ~ O ~ d ~ ~ ~ ~ ~ C {l G LL G ~ ~ m ~ cn O c~s ~ ~ Ql Ql ~ N O ~ C l4 C ~ G ~ i ~ ~ ~ ~ ~ ~ ~ ~ ~_ ~ ~ Q~ Q~ Q) ~ ~ fp (17 '~ O > > > 7 ~ 'a ~ a ~ ~ ~ c~ c~ ~ c~ c~ ~ ~ ~ ~ » ~ » w ~ 'c p o C~ C7 C7 C7 C7 C7 c O p .~Q = ~' ~ . Y. ~ ~ ~ ...3 ._1 ....1 .._.! .~ J ~ '.'_' ~ ~ d Q7 ~ ~ ~ ~ O LC. W Ll.. I.I.. LL.. LL LL. ~ ~ ~ ~ ~ ~ ~ ~ -~ ~ rn a ¢ ¢ a a ¢ a ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ J J J J ~ J t~ Q F W 4 a E v %a vvi c 0 m FW • c m y a ~. s 0 c 0