Loading...
HomeMy WebLinkAboutItem 4.04 Investment Rept 4th Qtr CITY CLERK File # D[2]~~-~~ AGENDA STATEMENT CITY COUNCIL MEETING DATE: August 5, 2008 SUBJECT: City Treasurer's Investment Report for 4th Quarter 2007-2008 Report Prepared by Paul S. Rankin, Administrative Services Dir. ~ A TT ACHMENTS: Quarterly Investment Report For The Period Ending June 30, 2008 RECOMMENDATIoNtV~Receive the Report \ FINANCIAL STATEMENT: See Report DESCRIPTION: The attached Investment Report details the City's investments as of June 30, 2008, in accordance with the requirements for reporting 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 4th QUARTER RESULTS As shown on the Portfolio Summary the total investments as of June 30, 2008 were approximately $124.2 million. The "Yield to Maturity" was calculated at 3.589% and the weighted average maturity of the portfolio was 691 days (1.89 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 less than one year at 305 days. The Market Value at June 30, 2008 was approximately $616,092 more than the Par Value. (Par Value = $124,192,095 and Market Value = $124,808,187) The typical approach used by the City is to hold investments until maturity. The City does not typically 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. ------------------------------------------------------------------------------------------------------------- COpy TO: Page 1 of 4 ITEM NO. H- G:\lnvestments\FY 2007-08Vune 2008 Stmt\AL Stmt_ 4rdQtr _Jun_ 08.doc The following Table displays the comparative results based on information in the Portfolio Summary for the fourth quarter of the previous year compared to the current year. COMPARISON OF PORTFOLIO MEASURES 4th Quarter FY 2006/07 vs. 4th Quarter 2007/08 Quarter 4 2006/07 (A ril- June 2007) Quarter 4 2007/08 (A ril- June 2007) $114,290,811 901 days (2.47 yrs) 4.681 % $124,192,095 691 days (1.89 yrs) 3.579% The total portfolio is approximately $9.9 million more than one year ago. The total portfolio will fluctuate throughout the year. In February 2008, pursuant to a funding agreement with the Lin family the City received approximately $11.2 million to finance the construction of the Fallon Road / Interstate 580 Interchange Project. These funds will be expended as construction of the project proceeds over the next year. Without the receipt ofthis one-time capital project funds the total portfolio would have decreased for this quarter compared to one year ago. The average maturity of the investments held decreased over the previous quarter extending to 2.47 years compared to 1.89 years as of June 30, 2008. During the past year there have been significant fluctuations in the interest paid on investments. In June of 2007 the Local Agency Investment Fund (LAIF) and Money Market investments had interest rates in excess of 5%. As of June 30, 2008 the rates on these investments were between 2.58% and 3.1 %, which resulted in lower quarterly yield on the portfolio. As part of the fourth quarter report information related to the entire Fiscal Year is provided. The following Table displays the comparative results based on information in the Portfolio Summary for each of the four quarters in Fiscal Year 2007-2008. PORTFOLIO MEASURES Fiscal Year 2007/2008 By Quarter Quarter 1 $100,590,779 1,106 days (3.03 yrs) 4.582% (Jul- Se t 2007) Quarter 2 $107,554,065 1,023 days (2.80 yrs) 4.480% (Oct - Dec 2007) Quarter 3 $118,018,240 649 days (1.78 yrs) 4.046% (J an - March 2008) Quarter 4 $124,192,095 691 days (1.89 yrs) 3.579% (A ril- June 2008) 2007/2008 Avera e $112,588,795 4.17% G"I"",",=""'FY2007 -08"""' 2008 S""M,_ s,.. _ 4nlQtr _1""_ 08 do, d) i 4 INVESTMENT ACTIVITY DURING THE QUARTER This report discloses changes in individual securities due to Maturities, Called Securities, and New Investments. A total of$ 12,000,000 in securities either matured or were called during the quarter. As shown below two of the transactions were due to maturing investments, while one security was called prior to its stated maturity date. INVESTMENTS MATURED DURING THE FOURTH 5,000,000 2,000,000 $7,000,000 4/28/2008 6/26/2008 3.50% 4.95% FHLMC FFCB Total 4/7 /2004 5,000,000 4/7 /2009 3.55% April 7, 2008 FNMA TOTAL CALLED $5,000,000 Staff purchased seven new investments during the quarter with a combined par value of $21 million as outlined below: INVESTMENTS PURCHASED DURING THE FOURTH UARTER FHLB 4/02/2008 3,000,000 3/09/2012 3.50% 3.300% N/A FHLB 4/02/2008 3,000,000 11/03/2009 3.50% 2.500% N/A FHLB 4/07/2008 3,000,000 1/07/2011 3.00% 3.000% 1/0712009 FHLB 4/09/2008 3,000,000 1/09/2012 3.41% 3.410% 1/09/2009 FHLB 4/1612008 3,000,000 10/28/201 0 3.125% 3.125% 10/2812008 FHLB 5/1312008 3,000,000 5/13/2013 4.00% 4.000% 11/13/2009 FHLMC 6/0312008 3,000,000 6/1012013 4.05% 4.113% 6/1012011 Total $21,000,000 All except two securities purchased have a one-time call provision as shown in the Table above. All of the securities are AAA rated securities. Six of the seven securities were issued by the Federal Home Loan Bank (FHLB) and one was issued by Federal Home Loan Mortgage Corporation (FHLMC) agencies of the Federal government. For those securities which show a different coupon rate than the "Effective Yield", they were purchased at either a premium or discount. This adjusts the rate earned to an amount that was offered in the market on the date of purchase. USE OF ADDITIONAL INVESTMENT POOL - California Asset Mana ement Pro ram CAMP The City Investment policy allows for participation in the California Asset Management Program (CAMP). This investment vehicle is a Joint Powers Authority established in 1989 by California Treasurers and Finance Directors to serve local agencies. The JP A uses an independent investment advisor PFM to manage the G:\lnvestments\FY 2007-08Vune 2008 Stmt\Ag_Stmt_ 4rdQtr_Jun_08.doc ~~L( investments. During this quarter the City proceeded with the use of the CAMP short-term cash reserve account. This fund is Standard & Poor's AAA rated and strives to maintain a $1.00 per share net asset value similar to a money market fund. This account will be used as a liquid alternative to other money market accounts and LAIF. The LAIF account has a maximum limit of$40 million. In previous reports the City had funds invested in the Columbia Funds Money Market Account, all funds were withdrawn in May from Columbia Funds. At that time the Columbia investment was earning 2.32% and CAMP was earning 2.78%. CAMP will offer the City an additional liquid investment that can also offer diversity to the City investment portfolio. 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, 2008 (48%) ofthe portfolio was immediately available in LAIF, CAMP, and Money Market instruments. This represents a decrease of 5% from the previous quarter as the City Treasurer placed new investments for those that had matured or were called. · Federal Securities now represent 52% of the portfolio compared to 47% reported as of March 31, 2008. · There was diversity in the issuers of the federal securities held in the portfolio. A total of four different issuers were represented. (FNMA-21 %; FHLB - 53%; FFCB-15% and FHLMC-l1 %). The percentage shares held in FNMA and FHLMC decreased from amounts reported in March. · 49% of the funds are invested for one year or less. This is very close to the 60% reported as of March 31,2008. · 25% of the 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 of the second quarter (April, May and June 2008). This schedule provides compliance with the Government Code requirement to disclose monthly transaction data. It is incorporated as part ofthe quarterly investment report rather than individual monthly reports. It is recommended that the City Council receive the report. G:\Investments\FY 2007-08Vune 2008 Stmt\Ag_Stmt_ 4rdQtr_Jun_08.doc ){ ~Lf r~ I~ CITY OF DUBLIN QUARTERLY INVESTMENT REPORT Fourth Quarter Fiscal Year 2007-2008 June 30, 2008 Presented To City Council August 5, 2008 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 :I-1~ -* 1/' 4 '€ I!(IO~ i ATTACHMENT. CITY OF DUBLIN Portfolio Management Portfolio Summary June 30, 2008 Investments Par Market Book Value Value Value 15,390,620.38 15,390,620.38 15,390,620.38 40,000,000.00 40,000,000.00 40,000,000.00 4,646,474.86 4,646,474.86 4,646,474.86 64,155,000.00 64,771,091.95 64,246,852.41 $124,192,095.24 $124,808,187.19 $124,283,947.65 Money Market LAIF Calif Asset Mgt Pgm (CAMP) Federal Agency Coupon Total Cash and Accrued Interest Accrued Interest (1) 452,777.87 452,777.87 Total Cash and Investments Value $124,192,095.24 $125,260,965.06 $124,736,725.52 %of Term I Days to YTM/C Portfolio Days Mat./Call 365 Equiv. 12.38 1 2.580 32.18 1 1 3.110 3.74 1 1 2.510 51.69 1337 588 4.188 100.00% 691 305 3.579% __ ______ ___..___ ____._u_ ___.._ __'__~__ '_____'___.___ ____._________ _,_____ 691 305 3.579% The schedule of investments, including the dates of maturity, provide adequate cash flow liquidity to meet anticipated expenditures over the next six months. The investments and schedule of investments are in compliance with the City of Dublin Investment Policy, and all applicable laws and regulations. PA~~K-:~D~IVESERVICESDIRECTOR DA-=t/~/\!)& (I) Accrued Interest represents the portion of interest earned as of the end of the quarter, that will be paid in a future month. Federal Securities typically pay interest twice a year (6 month intervals) and LA IF interest is distributed quarterly approximately 15 days following the end of the quarter. o ,J .~ GJ CUSIP Investment # Issuer Average Balance CITY OF DUBLIN Portfolio Management Portfolio Details - Investments June 30, 2008 Page 1 Purchase Date Market Value Stated Book Value Rate Days to YTM/C Maturity Term Mat./Ca11l65 Equiv Date Par Value Money Market Accounts SYS10044 SYS10046 LAIF SYS10043 CAMP SYS10076 10044 10046 Columbia Funds Fidelity US Govt Portfolio Subtotal and Average 14,499,084.60 07/01/2007 07/01/2007 0.00 15,390,620.38 15,390,620.38 0.00 15,390,620.38 15,390,620.38 0.00 15.390,620.38 15,390,620.38 2.260 2.580 2.260 2.580 LAIF Subtotal and Average 40,000,000.00 2.580 10043 -- -"-- --- ~"--"-------'--'---"-'-- ----_._'--._------'_.'-. .-.------------..---..-------.---------.--.------------------------ 07/01/2007 3.110 3.110 10076 California Asset Management Pr Subtotal and Average 5,666,474.86 40,000,000.00 40,000,000.00 40,000,000.00 40,000,000.00 40,000,000.00 40,000,000.00 3.110 OS/23/2008 4,646,474.86 4,646,474.86 4,646,474.86 4,646,474.86 4,646,474.86 2.510 2.510 4,646,474.86 2.510 -----~-----. -_..~--_._~.__._.---~---_.__.._--_.._._.._.~------_._-._-_..._--~.__._---_.._-,--_..__._--_.--_.__._--~-------"---'--'-'~---'-' --- ---.-.--....-.--.---.- --------"-- Federal Agency Coupon Securities 31331XEE8 31331XNE8 31331XWU2 31331XRQ7 31331YYW4 3133XJRG5 3133XGLE2 3133XHKF8 3133XKNN1 3133XLEN9 3133XNST7 3133XQHT2 3133XQ4C3 3133X9BF6 3133XQJM5 3133XQUH3 3133XQYCO 3128X4C90 3128X2PQ2 3128X7WV2 31398ABT8 3136F6W54 31398AGR7 Run Date: 07/28/2008 - 17:34 10032 10037 10049 10055 10061 10035 10036 10039 10041 10042 10058 10063 10065 10066 10068 10069 10070 10027 10033 10074 10034 10048 10052 Federal Farm Credit Bank Federal Farm Credit Bank Federal Farm Credit Bank Federal Farm Credit Bank Federal Farm Credit Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Mtg Corp Federal Home Loan Mtg Corp Federal Home Loan Mtg Corp Federal National Mtg Assn Federal National Mtg Assn Federal National Mtg Assn 01/10/2007 2,000,000.00 2,051,260.00 1,998,914.80 4.850 1,045 507 4.890 11/20/2009 02/14/2007 2,000,000.00 2,078,120.00 2,000,430.13 5.050 1.448 945 5.040 02/01/2011 08/31/2007 1,000,000.00 1,033,750.00 1,001,226.99 4.800 1,333 1,028 4.750 04/25/2011 11/15/2007 1,655,000.00 1,712,411.95 1,679,996.65 4.850 1,210 981 4.240 03/09/2011 03/24/2008 3,000,000.00 2,978,430.00 3,000,00000 2.625 730 266 2.625 03/24/2010 02/06/2007 2,000,000.00 2,026,880.00 2,000,000.00 5.180 1,277 220 5.180 08/06/2010 01/26/2007 3,000,000.00 3,113,430.00 3,002,504.95 5.125 1,323 801 5.080 09/10/2010 11/09/2006 3,000,000.00 3,070,320.00 3,000,000.00 5.250 1,826 496 5.250 11/09/2011 05/03/2007 3,000,000.00 3,083,430.00 3,000,000.00 5.020 1,827 671 5.020 05/03/2012 06/15/2007 3,000,000.00 3,124,680.00 3,000,000.00 5.560 1,827 714 5.560 06/15/2012 12/27/2007 2,000,000.00 2,017,500.00 2,000,000.00 4.420 1,827 909 4.420 12/27/2012 04/07/2008 3,000,000.00 2,954,070.00 3,000,000.00 3.000 1,005 190 3.001 01/07/2011 04/03/2008 3,000,000.00 2,959,680.00 3,020,482.71 3.500 1.436 1,347 3.300 03/09/2012 04/03/2008 3,000,000.00 3,019,680.00 3,039,092.74 3.500 579 490 2.500 11/03/2009 04/09/2008 3,000,000.00 2,915,640.00 3,000,000.00 3.410 1,370 192 3.411 01/09/2012 04/28/2008 3,000,000.00 2,983,140.00 3,000,000.00 3.125 913 119 3.125 10/28/2010 05/13/2008 3,000,000.00 2,974,680.00 3,000,000.00 4.000 1,826 500 4.000 05/13/2013 01/10/2007 1,000,000.00 1,014,210.00 1,000,647.65 5.050 775 237 4.940 02/23/2009 03/06/2007 3,000,000.00 3,091,650.00 3,009,965.87 5.000 1,060 577 4.770 01/29/2010 06/10/2008 3,000,000.00 2,982,96000 2,991,660.94 4050 1,826 1,074 4.113 06/10/2013 06/27/2007 2,000,000.00 2,038,120.00 1,991,685.17 5.080 1,052 317 5.321 05/14/2010 08/31/2007 1,500,000.00 1,543,590.00 1,502,90187 4.810 948 643 4.690 04/05/2010 09/10/2007 2,000,00000 2,041,880.00 2,000,000.00 5.200 1,827 436 5.200 09/10/2012 ~ Portfolio DINV ~ AP PM (PRF _PM2) 7.1.1 ---- C\0 Recart Ver. 7.1.1 CITY OF DUBLIN Portfolio Management Portfolio Details - Investments June 30, 2008 Page 2 Average Purchase Stated Days to YTM/C Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Term Mat./CaIB65 Equiv Date Federal Agency Coupon Securities 31359MA94 10054 Federal National Mtg Assn 09/13/2007 2,000,000.00 2,056,260.00 2,007,341.94 4.750 950 658 4.530 04/20/2010 3136F8U37 10059 Federal National Mtg Assn 02/08/2008 3,000,000.00 2,966,250.00 3,000,000.00 3.570 1,461 587 3.570 02/08/2012 3136F82S3 10060 Federal National Mtg Assn 02/22/2008 3,000,000.00 2,939,070.00 3,000,000.00 3.300 1,461 601 3.300 02/22/2012 --- Subtotal and Average 65,018,069.91 64,155,000.00 64,771,091.95 64,246,852.41 1,337 588 4.188 Total and Average 125,183,629.37 124,192,095.24 124,808,187.19 124,283,947.65 691 305 3.579 Run Date: 07/28/2008 - 17:34 Portfolio DINV J::::- AP PM (PRF _PM2) 711~ G; CITY OF DUBLIN Portfolio Management Portfolio Details - Cash June 30, 2008 Page 3 CUSIP Investment # Issuer Average Balance Purchase Date Par Value Market Value Stated Book Value Rate Days to YTMfC Term Mat.lCal165 Equiv Average Balance 0.00 Accrued Interest at Purchase 150,762.38 150,762.38 0 0 Ending Accrued Interest 302,015.49 302,015.49 ~'_.--'- ~--'--~--_.'~--- Subtotal 452,777.87 452,777.87 124,192,095.24 125,260,965.06 124,736,725.52 691 305 3.579 Total Cash and Investment Value 125,183,629.37 Run Date 07/28/2008 - 17:34 ~ Portfolio DIN~ AP ______ PM (PRF_PM2) 7.1.1 \.)-) CITY OF DUBLIN City of Dublin Investments by Type Active Investments June 30,2008 Purchase Current Maturity Call Call CUSIP Investment # Fund Issuer Par Value Price Book Value Rate Date Date Price Fund: General Fund --,-'--------- ~----- -~-._- ._~...__.- ------- -- -"------ --~--- Federal Agency Coupon Securities 3128X4C90 10027 001 Federal Home Loan Mtg Corp 1,000,000.00 100.2130000 1,000,647.65 5.050 02/23/2009 3133X9BF6 10066 001 Federal Home Loan Bank 3,000,000.00 101.5410000 3,039,092.74 3.500 11/03/2009 31331XEE8 10032 001 Federal Farm Credit Bank 2,000,000.00 99.8880000 1,998,91480 4.850 . 11/20/2009 3128X2PQ2 10033 001 Federal Home Loan Mtg Corp 3,000,000.00 100.6100000 3,009,96587 5.000 01/29/2010 31331YYW4 10061 001 Federal Farm Credit Bank 3,000,000.00 100.0000000 3,000,00000 2.625 03/24/2010 03/24/2009 100.0000000 3136F6W54 10048 001 Federal National Mtg Assn 1,500,000.00 100.2850000 1,502,901.87 4.810 04/05/2010 31359MA94 10054 001 Federal National Mtg Assn 2,000,000.00 100.5300000 2,007,341.94 4.750 04/20/2010 31398ABT8 10034 001 Federal National Mtg Assn 2,000,000.00 99.3594000 1,991,685.17 5.080 05/14/2010 05/14/2009 100.0000000 3133XJRG5 10035 001 Federal Home Loan Bank 2,000,000.00 100.0000QOO 2,000,000.00 5.180 08/06/2010 02/06/2009 100.0000000 3133XGLE2 10036 001 Federal Home Loan Bank 3,000,000.00 100.1380000 3,002,504.95 5.125 09/10/2010 3133XQUH3 10069 001 Federal Home Loan Bank 3,000,00000 100.0000000 3,000,000.00 3.125 10/28/2010 10/28/2008 100.0000000 3133XQHT2 10063 001 Federal Home Loan Bank 3,000,000.00 100.0000000 3,000,000.00 3.000 01/07/2011 01/07/2009 100.0000000 31331XNE8 10037 001 Federal Farm Credit Bank 2,000,000.00 100.0330000 2,000,430.13 5.050 02/01/2011 31331XRQ7 10055 001 Federal Farm Credit Bank 1,655,000.00 101.8630000 1,679,996.65 4.850 03/09/2011 31331XWU2 10049 001 Federal Farm Credit Bank 1,000,000.00 100.1590000 1,001,226.99 4.800 04/25/2011 3133XHKF8 10039 001 Federal Home Loan Bank 3,000,000.00 100.0000000 3,000,000.00 5.250 11/09/2011 11/09/2009 100.0000000 3133XQJM5 10068 001 Federal Home Loan Bank 3,000,000.00 100.0000000 3,000,000.00 3.410 01/09/2012 01/09/2009 100.0000000 3136F8U37 10059 001 Federal National Mtg Assn 3,000,000.00 100.0000000 3,000,000.00 3.570 02/08/2012 02/08/2010 100.0000000 3136F82S3 10060 001 Federal National Mtg Assn 3,000,000.00 100.0000000 3,000,000.00 3.300 02/22/2012 02/22/2010 100.0000000 3133XQ4C3 10065 001 Federal Home Loan Bank 3,000,000.00 100.7280000 3,020,482.71 3.500 03/09/2012 3133XKNN1 10041 001 Federal Home Loan Bank 3,000,000.00 100 0000000 3,000,000.00 5.020 05/03/2012 05/03/2010 100.0000000 3133XLEN9 10042 001 Federal Home Loan Bank 3,000,000.00 100.0000000 3,000,000.00 5.560 06/15/2012 06/15/2010 100.0000000 31398AGR7 10052 001 Federal National Mtg Assn 2,000,000.00 100.0000000 2,000,000.00 5.200 09/10/2012 09/10/2009 100.0000000 3133XNST7 10058 001 Federal Home Loan Bank 2,000,000.00 100.0000000 2,000,000.00 4.420 12/27/2012 12/27/2010 100.0000000 3133XQYCO 10070 001 Federal Home Loan Bank 3,000,000.00 100.0000000 3,000,000.00 4.000 05/13/2013 11/13/2009 100.0000000 3128X7WV2 10074 001 Federal Home Loan Mtg Corp 3,000,000.00 99.7187500 2,991,660.94 4.050 06/10/2013 06/10/2011 100.0000000 General Fund Subtotal 64,155,000.00 64,246,852.41 Total 64,155,000.00 64,246,852.41 Run Date: 07/24/2008 - 14:02 ~ ~ Portfolio DIN~ AP , DT(PRF_DT) 7.1.1 -- Report Ver. 7.1.1 l>v QUARTERLY INVESTMENT REPORT Fourth Quarter Fiscal Year 2007-2008 June 30, 2008 Section II - Investment Charts "'l OJ.. I?J INVESTMENT CHARTS FOR THE QUARTER ENDING JUNE 30, 2008 FEDERAL SECURITIES 52% FHLMC 11% INVESTMENTS BY TYPE (June 30, 2008) MONEY MARKET 12% LA IF 32% I CAMP 4% FEDERAL SECURITIES BY ISSUER (June 30,2008) FNMA 21% FFCB 15% FHLB 53% "I (~ ,( I 3 \ INVESTMENT CHARTS FOR THE QUARTER ENDING JUNE 30, 2008 $70,000,000 $60,000,000 $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 NON-CALLABLE 42% $60,037,095 $0 FEDERAL SEC~ CALLABLE \S NON-CALLABLE CALLABLE 58% June 30, 2008 - Portfolio Maturities ---- ------.------ ----""--------..._-----.------- --- $16,500,000 $15,655,000$21,000,000 $1,000,000 No Maturity (I Yr or Less) (I Yr - 2 Yr) (2 Yr - 3 Yr) (3 Yr - 4 Yr) (4 Yr _ 5 Yr) Date ~~13 QUARTERLY INVESTMENT REPORT Fourth Quarter Fiscal Year 2007-2008 June 30, 2008 Section III - Listing of Monthly Investment Transactions IO~ 13 CITY OF DUBLIN Cash/Checking Activity April 1, 2008 - April 30, 2008 Investment # Current R"tp. Withdrawals Fund Secu rity Receipt Deposits Interest Balance Money Market Accounts Columbia Funds City of Dublin 4,698.06 - ---..---.------'--.------..------- --"--- - -- -.-".-----.--..--------".---,-.---- ----- ---'- -----...-------.--------..----'-...---..--.----.---. 10044 001 SYS10044 2.850 04/01/2008 2.260 04/01/2008 2.260 04/22/2008 2.260 04/30/2008 2.260 0.00 11,000,000.00 9,543.03 Subtotal and Ending Balance 11,000,000.00 Fidelity US Govt Portfolio --- - ---'-' ----..--, - --, -- --'.- -' --..-------".-- --------..-.-.------.--.----_____.______.__.__._n__._____.________________.__.._____.___ _' .__.__._._,__..___....__ 10046 001 SYS10046 2.910 04/01/2008 2.290 04/01/2008 2.290 04/03/2008 2.290 04/03/2008 2.290 04/03/2008 2.290 04/03/2008 2.290 04/07/2008 2.290 04/07/2008 2.290 04/07/2008 2.290 04/07/2008 2.290 04/08/2008 2.290 04/08/2008 2.290 04/09/2008 2.290 04/10/2008 2.290 04/21/2008 2.290 04/25/2008 2.290 04/28/2008 2.290 04/28/2008 2.290 04/29/2008 2.290 12,985,186.11 3,000,000.00 15,122,903.33 49,333.16 3,046,230.00 43,750.00 3,021,840.00 10,208.33 3,000,000.00 5,000,000.00 36,075.00 88,750.00 875.00 875.00 3,000,000.00 2,700,000.00 47,500.00 24,000.00 87,986.11 5,000,000.00 Subtotal and Ending Balance LAIF LAIF 1,942,187.00 1,942,187.00 1,942,187.00 12,942,187.00 12,942,187.00 12,942,187.00 20,921,052.60 20,970,385.76 20,970,385.76 17,924,155.76 17,880,405.76 14,858,565.76 14,848,357.43 11,848,357.43 16,848,357.43 16.884,432.43 16.973,182.43 16.974,057.43 16,973,182.43 13,973,182.43 16,673,182.43 16,720,682.43 16,744,682.43 16,832,66854 21,832,668.54 18,832,668.54 18,832,668.54 383,339.50 __ __ __'___ ----___'__0. _____ __'_____, __,___._ _____ __ __ ______.___ _ ____________,___ ___._____.__.__.__._________._.____._..___~__..__.._______._._._..___ ___.__ __._. __..__..__.._ 10043 001 SYS10043 4.180 04/15/2008 4.180 04/21/2008 4.180 0.00 383,339.50 383,339.50 - Subtotal and Ending Balance 40,000,000.00 40,383,339.50 40,000,000.00 40,000,000.00 Total 446,913.75 .~ " 23,985,186.11 15,506,242.83 Run Date: 07/2412008 - 13:50 71,774,855.54 Portfolio DINV AP LP IPRF LPl 7.11 Report Ver. 7.1.1 0:> Issuer Investment # Fund Security 10 Balance Money Market Accounts Columbia Funds 10044 001 SYS 1 0044 Subtotal and Ending Balance Fidelity US Govt Portfolio 10046 001 SYS10046 Subtotal and Ending Balance CAMP California Asset Management Pr ---- -.--_.----_.-._---------- 10076 001 SYS10076 Run Date: 07/24/2008 - 13: 52 3,000,000.00 3,500,000.00 6,442,187.00 13,435.80 0.00 12,942,187.00 -- ----..---,- --.- .-.-....-- ..- - 34,128.49 52,500.00 75,300.00 78,750.00 3,000,000.00 50,800.00 48,500.00 305,850.00 3,000,000.00 CITY OF DUBLIN Cash/Checking Activity May 1,2008 - May 31,2008 Current Rate Receipt 2.260 05/07/2008 2.260 0512112008 2.260 OS/23/2008 2.260 OS/2312008 2.260 2.290 0510112008 2.320 0510112008 2.320 05/0512008 2.320 05105/2008 2.320 05/09/2008 2.320 05113/2008 2.320 05/1412008 2.320 0512012008 Deposits Withdrawals Interest City of Dublin 12,942,187.00 9,942,187.00 6,442,18700 0.00 0.00 0.00 18,832,668.54 18,866,797.03 18,866,797.03 18,919.297.03 18,994,597.03 19,073,347.03 16,073,347.03 16,124,147.03 16,172,647.03 0.00 6,442,18700 4,28786 6,446,474.86 6,446,47486 6,446,474.86 51,852.15 22,619,121.89 Portfolio DINV AP ~ OS/2312008 6,442,187.00 05/3012008 2.780 05/31/2008 Subtotal and Ending Balance 2.780 6,442,187.00 0.00 Total 6,748,037.00 15,942,187,00 LP (PRF LP\ 7.11,~ Report Ver. 7.1.1 ~ , -- \.).) CITY OF DUBLIN Cash/Checking Activity June 1, 2008 - June 30, 2008 Issuer Investment # Current Transaction Security 10 Rate Date Comment Deposits Withdrawals Interest Received Balance Fund Money Market Accounts Fidelity US Govt Portfolio -- --- -----..-- 10046 001 SYS10046 Subtotal and Ending Balance 2.580 06/01/2008 2.580 06/02/2008 2.580 06/10/2008 purchase cusip 3128x7wv2 2.580 06/16/20083133xlen9 2.580 06/26/2008 Maturity 31331xjp8 2.580 06/26/200831331xjp8 2.580 06/27/2008 3133xnst7 2.580 2,991,562.50 32,435.85 32,43585 2,991,562.50 83,400.00 2,000,000.00 49,500.00 44,200.00 2,177,100.00 LAIF LAIF City of Dublin 16,172,647.03 16,172,647.03 16,205,082.88 13,213,520.38 13,296,920.38 15,296,920.38 15,346,420.38 15,390,620.38 15,390,620.38 __ __.__ .___._._.___.__.._______..._~____________..___ ~___._.._______.__.._ __..__,___ ____n_ __ _ ____ ._._______..____ ___ _._ __________._ --.-.--------..-.-----.- --"----------.---- - -- -- -------------- 10043 SYS10043 001 Subtotal and Ending Balance 3.11 0 06/30/2008 3.110 0.00 0.00 0.00 CAMP California Asset Management Pr . -_.._-----_.__._~_._._----~_._._------_._-_._-~-----_.--------.-----------.--..---.-.-.--.---------------.-.----..---.---.-...-----. ----.'-- -- 10076 001 SYS10076 Subtotal and Ending Balance 2.510 06/01/2008 2.510 06/18/2008 2.510 0.00 1,800,000.00 1,800,000.00 0.00 60,037,095.24 40,000,000.00 40,000,000.00 40,000,000.00 6,446,474.86 6,446,474.86 4,646,474.86 4,646,474.86 Total 2,177,100.00 4,791,562.50 32,435.85 Run Date 07/28/2008 - 1729 --- ~ Portfolio DINV~ A~ LP(PRF_LP) 71.1_ RepartVer. 7.ulv