Loading...
HomeMy WebLinkAbout2010-05-25; City Council; 20242; Report City Investments as of April 30, 2010CITY OF CARLSBAD - AGENDA BILL 8 AB# MTG. DEPT. 20,242 5/25/10 TRS REPORT ON CITY INVESTMENTS AS OF APRIL 30, 2010 DEPT. HEAD fflS/f CITYATTY. <dfe CITY MGR. i (>^^ RECOMMENDED ACTION: Accept and file report. ITEM EXPLANATION: The City's Investment Policy requires the City Treasurer to report to the City Council on a monthly basis the status of the City's pooled investment portfolio. A quarterly report is also required for the investments of bond proceeds held separately. The City's pooled investment portfolio as of the month ended April 30, 2010 is summarized below. Pooled Investment Portfolio (Cash and Securities) Par Value Cost of Investments Amortized Cost (1) Market Value (2) Current Month 558,154,804 566,797,009 563,316,215 571,452,984 Prior Month 545,440,381 554,268,383 550,889,413 558,609,034 (1) The cost of investments adjusted for amortized premiums and discounts. (2) The amount at which the investments could be sold. Source of market values is Union Bank of California's custodial report as of 4/30/10. The equity portion of the various funds in the total portfolio is summarized in the graph on the next page. Fund balances are restricted for various purposes. See Exhibit 8 for a more detailed breakdown. The portfolio increase of $12 million from March to April is due to the receipt of property, highway users and redevelopment taxes and franchise fees during the month. FOR CITY CLERKS USE ONLY. COUNCIL ACTION: APPROVED IJ DENIED D CONTINUED D WITHDRAWN D AMENDED D CONTINUED TO DATE SPECIFIC CONTINUED TO DATE UNKNOWN RETURNED TO STAFF OTHER -SEE MINUTES COUNCIL RECEIVED REPORT D D D n DEPARTMENT CONTACT: Nancy Sullivan (760) 602-2473 Nancy.Sullivan@carlsbadca.gov PAGE 2 OF AB REPORT ON CITY INVESTMENTS AS OF APRIL 30, 2010 FUND EQUITY IN POOLED INVESTMENTS (Dollar Amounts in Millions) General Special Revenue S70 $48 Capital Projects $279.3 Internal Service Enterprise Total Treasurer's Investment Portfolio at Amortized Cost April 30, 2010 S563.3 million Pooled Investment Interest Income Cash Income Fiscal Year-to-Date * Current Month FYTD 15,671,694 Prior Month FYTD 14,384,338 Current Month Income 1,287,356 *The cash income received is adjusted for any accrued interest purchased. Pooled Investment Performance/Measurement February 2010 March 2010 April 2010 Average Life (Years) 1.50 1.64 1.53 Average Yield To Maturity 2.41% 2.42% 2.35% Modified Duration 1 .432 1.557 1.460 All pooled investments have been made in accordance with the City's Investment Policy adopted January 2, 1985 and last revised March 23, 2010. All investments were initially made in accordance with the City's Investment Policy. Events subsequent to the purchase might have resulted in some investments not being in compliance with the current policy. These events are typically a change in the City's Investment Policy, a change in the credit rating subsequent to a purchase, or a temporary reduction in total portfolio assets. See Exhibit 9 for details. The pooled investment portfolio has the ability to meet the City's cash flow demands for the next six (6) months. EXHIBITS FOR POOLED INVESTMENTS: 1. Investment Portfolio Breakdown By Amortized Cost, Market Value, Cash Income, and Average Yield 2. Investment Portfolio Breakdown Of Maturities 3. Yield Comparison Graph 4. Market Yield Curve 5. Cumulative Cash Income Graph 6. Fourth Quarter Transactions 7. Detailed Investment Report 8. Fund Equity in Pooled Investments 9. Corporate Note and Commercial Paper Ratings 10. Percentage Weightings By Corporate Note Issuer CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF APRIL 30, 2010 BREAKDOWN BY AMORTIZED COST, MARKET VALUE, CASH INCOME, AND AVERAGE YIELD BY CLASS AMORTIZED COST MARKET VALUE AVERAGE YIELD Class CD FN CP TR FA CN LAIF CUSTODY SWEEP BANK ACCT Current Month 33,000 11,394,327 0 106,346,207 287,196,934 102,910,022 52,625,482 400 2,276,863 532,979 Prior Month Current Month 33,000 11,370,031 0 116,417,051 295,882,565 102,965,465 19,455,089 2,300,000 2,058,021 408,191 33,000 11,564,860 0 106,476,950 291,612,516 106,329,934 52,625,482 400 2,276,863 532,979 Prior Month 33,000 11,485,060 0 116,527,660 300,038,776 106,303,236 19,455,089 2,300,000 2,058,021 408,191 Cash Income Year to Date Current Month Prior Month 228 0 0 930,326 9,413,525 4,686,425 639,537 100 1,554 0 0.05 2.58 0.00 0.51 2.71 4.21 0.56 0.05 0.10 0.10 0.05 2.58 0.00 0.50 2.70 4.21 0.56 0.05 0.10 0.10 TOTALS $563,316,215 $550,889,413 $571,452,984 $558,609,034 $15,671,694 2.35%2.42% CD - Certificate of Deposit FN - Federal Discount Notes CP - Corporate Paper TR - US Treasury FA - Federal Agency CN - Corporate Notes LAIF - Local Agency Investment Fund Custody - Investment Cash account SWEEP - General Fund Overnight Cash acccount Bank Account - General Fund Cash account mx CO CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF APRIL 30, 2010 BREAKDOWN OF MA TURITIES BY CLASSIFICA TION AND LENGTH OF TIME CLASS CD FN CP TR FA CN LAIF CUSTODY SWEEP BANK ACCT TOTALS % TOTALS Total within One WITHIN 6 MONTHS 33,000 0 0 46,534,144 52,560,395 16,075,380 52,625,482 400 2,276,863 532,979 $170,638,644 (1) 30.1% Year 7 MONTHS TO 1 YEAR 0 956,370 0 27,129,586 11,130,449 17,990,621 0 0 0 0 $57,207,026 (1) 10.1% $227,845,670 (1) 1 TO 5 YEARS 0 10,126,814 0 33,223,318 225,886,335 69,714,873 0 0 0 0 $338,951,340 59.8% TOTAL 33,000 11,083,184 0 106,887,048 289,577,179 103,780,875 52,625,482 400 2,276,863 532,979 $566,797,009 100.0% % TOTAL 0.0% 2.0% 0.0% 18.9% 51.1% 18. 3% (2) 9.3% 0.0% 0.4% 0.1% 100.0% 40.2% POLICY: (1) Not less than $126,950,000 to mature within one year. (2/3rds of current year operating budget of $190,416,000.00) (2) Policy states that not more than 30% of portfolio is to be invested in corporate notes.xn:i—i DO IN3 YIELD COMPARISON PORTFOLIO EX-LAIF VS. LAIF JULY 1996-APRIL 2010 MARKET YIELD CURVE 6/30/08,6/30/09,4/30/10 Market Rates 1 3Mth 2Yr 5Yr 3Mth 2Yr 5Yr 10 Yr — •- — *- o -06/30/2008 • 06/30/2009 04/30/2010 1.73 .18 .15 2 1 .62 .11 .96 3 2 2 .33 .56 .42 3 3 3 .97 .53 .65 10 Yr X:r DO Cumulative Millions $ Cumulative Cash Income FY09-10 (April 2010) 20 18 16 14 12 10 8 4 2 1.99 Monthly Interest Income Millions $ 1.61 1.6 1.38 1.31 1.88 1-47 1.17 1.29 Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun i=iInterest Income --•-•Budget Actual 8 7 6 5 4 3 2 1 0 Xn:i—i CO City of Carlsbad TRANSACTIONS FOR PERIOD: 04/01/10 TO 04/30/10 4TH QUARTER 2009-2010 Trans Date BUYS APRIL 04/02/2010 03/23/2010 04/21/2010 Investment Date 04/02/2010 04/15/2010 04/22/2010 TOTAL FOURTH QUARTER MATURITIES APRIL 04/22/2008 01/28/2008 04/30/2009 06/05/2009 07/22/2009 03/02/2010 TOTAL FOURTH QUARTER CALLS and / or SALES APRIL 10/22/2007 10/13/2009 06/03/2009 04/27/2009 TOTAL FOURTH QUARTER Maturity Date 05/02/2010 10/15/2013 10/28/2014 2009-2010 04/07/2010 04/28/2010 04/08/2010 04/15/2010 04/30/2010 04/02/2010 2009-2010 10/22/2012 10/13/2010 04/01/2011 07/27/201 1 2009-2010 Type CD FA FA FA FA TR TR TR CD FA FA FA FA Security WELLS FARGO CO FHLB FHLB FFCB FHLMC US TREASURY US TREASURY US TREASURY WELLS FARGO CO FHLB FHLB FMNA FHLMC Call Date N/A N/A 10/28/2011 N/A N/A N/A N/A N/A N/A 04/22/2010 04/13/2010 04/01/2010 04/27/2010 Par Value 33,000.00 2,000,000.00 2,000,000.00 4,033,000.00 2,000,000.00 1,500,000.00 2,000,000.00 3,000,000.00 5,000,000.00 33,000.00 13,533,000.00 2,000,000.00 2,000,000.00 2,000,000.00 3,000,000.00 9,000,000.00 Coupon 0.500% 2.000% 2% STEP 2.375% 4.020% 0.000% 4.000% 2.125% 0.500% 5.000% 0.35% STEP 2.050% 1.750% Amount (Cost) 33,000.00 2,000,000.00 2,015,640.00 4,048,640.00 1,984,800.00 1,537,935.00 1,991,806.11 3,093,164.06 5,069,531.25 33,000.00 13,710,236.42 2,000,000.00 2,000,000.00 2,024,200.00 3,000,000.00 9,024,200.00 Return Rate 0.500% 2.000% 2.950% 2.461% 2.776% 2.850% 0.437% 0.382% 0.325% 0.500% 0.993% 5.000% 0.550% 1 .377% 1 .750% 3.113% Interest 1.42 140,000.00 270,026.67 410,028.09 108,220.83 97,740.00 8,193.89 10,114.63 12,754.76 1.42 237,025.53 500,000.00 11,000.00 50,738.89 118,125.00 679,863.89 Investment Return 33,001.42 2,140,000.00 2,285,666.67 4,458,668.09 2,093,020.83 1,635,675.00 2,000,000.00 3,103,278.69 5,082,286.01 33,001.42 13,947,261.95 2,500,000.00 2,011,000.00 2,074,938.89 3,118,125.00 9,704,063.89 Xrni—i CO CTl INVESTMENT REPORT AS OF APRIL 30, 2010 INVESTMENT DATE 07/25/2007 04/22/2008 05/05/2008 12/21/2007 03/16/2009 02/26/2008 05/08/2008 04/17/2009 08/05/2008 10/09/2007 07/25/2007 07/15/2008 03/12/2008 02/20/2008 02/13/2008 10/30/2007 02/12/2008 09/18/2007 09/26/2007 05/08/2008 12/05/2008 03/11/2009 09/26/2007 06/01/2009 05/05/2008 04/22/2009 06/03/2009 06/01/2009 06/03/2009 12/05/2008 02/20/2008 05/11/2009 05/12/2009 06/22/2009 08/31/2007 05/08/2008 09/17/2008 03/09/2007 08/01/2007 08/31/2007 05/08/2008 03/31/2009 ~N 05/11/2009 ^ 12/30/2009 06/29/2009 TYPE FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA SECURITY FFCB 4.780% NON-CALL FFCB 5.320% NON-CALL FHLB 7.625% NON-CALL FNMA 3.625% NON-CALL FHLB 1.250% NON-CALL FHLB 4.25% NON-CALL FHLB 3.00% NON-CALL FHLB 5.25% NON-CALL FHLMC3.50% NON-CALL FHLB 4.5% NON-CALL FNMA 5.125% NON-CALL FFCB 3.200% NON-CALL FHLB 4.44% NON-CALL FNMA 4.70% NON-CALL FHLB 5.00% NON-CALL FHLB 4.7% NON-CALL FHLB 3.190% CALL 8/12/08 FHLMC 5.125% NON-CALL FHLB 5.125% NON-CALL FHLB 3.00% NON-CALL FHLB 3.375% NON-CALL FHLB 1.4% NON-CALL FFCB 5.25% NON-CALL FHLB 1.25% NON-CALL FHLB 4.375% NON-CALL FHLB 1.125% NON-CALL FHLB 4.375% NON-CALL FHLB 1.050% NON-CALL FHLB 1.050% NON-CALL FHLMC 4.50% NON-CALL FHLB 2.875% NON-CALL FHLB 1.375% NON-CALL FNMA 1.45% CALL FHLB 1.125% NON-CALL FHLB 5.275% NON-CALL FHLB 5.25% NON-CALL FHLB 5.25% NON-CALL FNMA 3.64% NON-CALL FAMCA5.50% NON-CALL FAMCA5.50% NON-CALL FAMCA5.5% NON-CALL FFCB 3.625% NON-CALL FAMCA 5.50% NON-CALL FHLMC 5.25% NON-CALL FHLB 1.625% NON-CALL PAR VALUE 2,000,000.00 1,000,000.00 3,000,000.00 2,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 3,000,000.00 3,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 3,000,000.00 2,550,000.00 1,000,000.00 3,000,000.00 3,000,00000 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 1,000,000.00 3,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 3,000,000.00 3,000,000.00 1,000,000.00 1,000,000.00 2,000,000.00 1,000,000.00 1,000,000.00 2,000,000.00 2,000,000.00 3,000,000.00 629,000.00 2,000,000.00 1,000,000.00 1,000,000.00 1,737,000.00 2,000,000.00 INVESTED AMOUNT 1,981,720.00 1,050,120.00 3,273,695.78 1,996,499.26 1,000,000.00 1,030,795.00 999,862.00 1,049,288.56 3,010,680.00 2,991,510.00 1,000,640.00 1,000,000.00 1,043,000.00 3,134,430.00 2,688,248.25 1,009,328.80 3,000,000.00 3,048,120.00 2,034,188.23 1,994,876.00 2,032,660.00 2,000,000.00 2,041,700.00 2,014,960.00 1,032,893.26 3,000,000.00 2,101,180.00 2,008,660.00 2,007,180.00 3,119,880.00 2,993,378.76 1,001,350.00 1,000,000.00 1,988,700.00 1,020,930.00 1,055,434.00 2,132,207.14 1,909,480.00 3,034,380.00 644,775.32 2,116,712.00 1 ,044,420.00 1,072,970.00 1,853,035.07 2,012,680.00 RETURN RATE 5.135% 2.790% 2.950% 3.700% 1 .250% 2.849% 3.005% 0.930% 3.300% 4.610% 5.100% 3.200% 2.559% 2.786% 2.710% 4.337% 3.190% 4.530% 4.500% 3.115% 2.420% 1.400% 4.490% 0.700% 2.980% 1.125% 0.701% 0.750% 0.800% 2.470% 2.950% 1.305% 1.450% 1.420% 4.761% 3.345% 2.720% 4.805% 5.175% 4.781% 3.545% 1 .639% 2.050% 0.900% 1.315% INTEREST 283,304.44 59,087.78 189,522.97 180,118.80 15,625.00 66,482.78 62,888.00 11,086.44 185,028.33 373,365.00 150,405.14 64,000.00 62,326.67 209,453.33 175,897.58 121,226.76 239,250.00 402,452.92 268,756.21 145,457.34 86,402.50 41,922.22 269,508.33 19,276.11 74,901.88 50,625.00 20,104.72 21,906.67 23,270.00 154,245.00 270,402.49 25,653.47 29,000.00 55,112.50 181,976.25 106,732.67 154,501.19 406,997.78 618,286.67 118,184.21 233,760.22 85,530.00 46,807.78 25,313.30 54,847.78 INVESTMENT RETURN 2,265,024.44 1,109,207.78 3,463,218.75 2,176,618.06 1,015,625.00 1,097,277.78 1,062,750.00 1,060,375.00 3,195,708.33 3,364,875.00 1,151,045.14 1,064,000.00 1,105,326.67 3,343,883.33 2,864,145.83 1,130,555.56 3,239,250.00 3,450,572.92 2,302,944.44 2,140,333.34 2,119,062.50 2,041,922.22 2,311,208.33 2,034,236.11 1,107,795.14 3,050,625.00 2,121,284.72 2,030,566.67 2,030,450.00 3,274,125.00 3,263,781.25 1,027,003.47 1,029,000.00 2,043,812.50 1,202,906.25 1,162,166.67 2,286,708.33 2,316,477.78 3,652,666.67 762,959.53 2,350,472.22 1,129,950.00 1,119,777.78 1,878,348.37 2,067,527.78 TERM (Days) 1,013 749 739 889 457 836 764 420 680 987 1,077 730 866 889 898 1,015 912 1,070 1,080 855 644 548 1,083 500 900 548 506 532 530 741 1,115 717 730 711 1,379 1,128 996 1,588 1,444 1,414 1,163 836 795 565 758 xrni—i DO INVESTMENT REPORT AS OF APRIL 30,2010 INVESTMENT DATE TYPE SECURITY 10/01/2009 FA FHLB 1.375% NON-CALL 03/19/2007 FA FHLB 5.75% NON-CALL 01/23/2009 FA FHLB 5.75% NON-CALL 06/22/2009 FA FFCB 3.875% NON-CALL 03/05/2007 FA FHLB 5.00% NON-CALL 03/15/2007 FA FHLB 5.00% NON-CALL 01/23/2009 FA FHLB 5.00% NON-CALL 10/30/2007 FA FHLMC 5.50% NON-CALL 12/08/2009 FA FFCB 1.128% NON-CALL 03/15/2007 FA FHLB 4.875% NON-CALL 02/11/2010 FA FFCB .950% CALL 4/26/10 12/07/2009 FA FHLB 4.25% NON-CALL 12/08/2009 FA FHLB 4.25% NON-CALL 03/19/2007 FA FHLB 4.875% NON-CALL 12/30/2009 FA FNMA 1.0% NON-CALL 12/09/2009 FA FFCB .875% NON-CALL 06/29/2009 FA FFCB 2.0% NON-CALL 05/21/2007 FA FFCB 4.875% NON-CALL 08/17/2009 FA FHLMC 2.0% CALL 5/17/10 07/25/2007 FA TVA 6.790% NON-CALL 10/19/2009 FA TVA 6.790% NON-CALL 07/25/2007 FA FHLB 5.375% NON-CALL 07/25/2007 FA FHLB 5.375% NON-CALL 07/15/2008 FA FHLB 4.375% NON-CALL 10/20/2009 FA FFCB 2.125% NON-CALL 11/25/2009 FA FFCB 5.45% NON-CALL 11/06/2009 FA FHLMC 2.45% CALL 6/29/10 03/24/2010 FA FHLB 1.25% NON-CALL 01/20/2010 FA FHLMC 5.125% NON-CALL 10/19/2009 FA FFCB 1.55% CALL 10/19/10 01/19/2010 FA FHLMC 1.625% CALL 7/19/10 12/10/2007 FA FHLB 5.58% CALL 7/20/10 01/20/2010 FA FNMA 1.5% CALL 7/20/10 08/05/2008 FA FFCB 3.950% NON-CALL 08/12/2009 FA FHLB 2.0% CALL 7/27/10 10/27/2009 FA FNMA 1.70% CALL 10/27/10 07/30/2007 FA FHLB 5.52% CALL 7/30/10 12/24/2009 FA FNMA 5.00% NON-CALL 01/25/2010 FA FAMCA 2.1% NON-CALL 01/20/2010 FA FNMA 1.75% NON-CALL 03/16/2010 FA FNMA 1.75% NON-CALL 08/13/2008 FA FHLB 4.35% CALL 8/13/10 01/29/2009 FA FHLB 4.625% NON-CALL 12/24/2009 FA FHLB 4.625% NON-CALL 11/17/2009 FA FHLB 1.75% CALL 8/17/10 02/27/2009 FA FNMA 2.625% CALL 8/27/10 PAR VALUE 1,000,000.00 3,000,000.00 1,000,000.00 3,000,000.00 2,000,000.00 3,000,000.00 1,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 4,000,000.00 1,000,000.00 2,000,000.00 3,000,000.00 3,000,000.00 1,000,000.00 4,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 3,000,000.00 1,000,000.00 1,000,000.00 3,000,000.00 3,000,000.00 2,000,000.00 1,000,000.00 2,000,000.00 1,000,000.00 3,000,000.00 3,000,000.00 1 ,000,000.00 1,250,000.00 2,000,000.00 2,000,000.00 1,000,000.00 1,770,000.00 1,037,000.00 1,000,000.00 1,000,000.00 3,000,000.00 2,000,000.00 2,000,000.00 1,000,000.00 2,000,000.00 2,000,000.00 INVESTED AMOUNT 1,006,100.00 3,111,810.00 1,097,950.00 3,152,520.00 2,018,200.00 3,032,352.00 1,077,520.00 3,117,300.00 3,014,854.10 3,018,777.00 4,002,000.00 1,061,850.00 2,126,060.00 3,009,690.00 2,994,090.00 997,136.00 4,036,800.00 1,987,880.00 1,997,500.00 2,130,980.00 3,399,498.48 1,005,040.00 1,005,254.43 3,050,958.11 3,049,023.21 2,210,347.28 1,011,600.00 2,000,352.89 1,092,760.00 2,995,200.00 3,000,000.00 1,037,000.00 1,249,375.00 2,002,900.00 1,988,600.00 998,800.00 1,770,000.00 1,127,519.73 1,015,908.69 1,009,004.81 3,034,050.00 1,999,500.00 2,150,960.00 1,078,810.00 2,000,000.00 2,000,000.00 RETURN RATE 1 .375% 4.800% 1.818% 1.490% 4.773% 4.730% 1.958% 4.390% 0.850% 4.720% 0.921% 1 .020% 0.956% 4.795% 1.105% 1.020% 1 .630% 5.015% 2.047% 5.235% 1 .534% 5.255% 5.250% 3.900% 1 .496% 1 .280% 1.997% 1 .243% 1 .320% 1.610% 1 .625% 4.677% 1 .520% 3.910% 2.200% 1 .745% 5.520% 1.567% 1.460% 1.390% 1.268% 4.357% 2.391% 1.567% 1.750% 2.625% INTEREST 19,261.11 648,148.33 49,313.89 100,323.75 432,911.11 640,148.00 53,868.89 522,075.00 46,552.13 647,473.00 62,916.67 20,552.78 38,509.44 672,403.75 62,826.67 20,364.00 167,200.00 489,057.50 112,500.00 524,632.22 128,989.85 256,692.64 256,478.21 460,552.31 120,622.62 70,024.94 53,256.94 58,188.78 34,653.19 132,675.00 121,875.00 220,300.00 47,500.00 310,466.67 129,733.33 47,950.00 488,520.00 44,578.33 37,466.31 35,717.41 91,950.00 348,500.00 176,901.11 43,367.08 96,250.00 183,750.00 INVESTMENT RETURN 1,025,361.11 3,759,958.33 1,147,263.89 3,252,843.75 2,451,111.11 3,672,500.00 1,131,388.89 3,639,375.00 3,061,406.23 3,666,250.00 4,064,916.67 1,082,402.78 2,164,569.44 3,682,093.75 3,056,916.67 1,017,500.00 4,204,000.00 2,476,937.50 2,110,000.00 2,655,612.22 3,528,488.33 1,261,732.64 1,261,732.64 3,511,510.42 3,169,645.83 2,280,372.22 1,064,856.94 2,058,541.67 1,127,413.19 3,127,875.00 3,121,875.00 1,257,300.00 1,296,875.00 2,313,366.67 2,118,333.33 1,046,750.00 2,258,520.00 1,172,098.06 1,053,375.00 1,044,722.22 3,126,000.00 2,348,000.00 2,327,861.11 1,122,177.08 2,096,250.00 2,183,750.00 TERM (Days) 673 1,610 934 794 1,649 1,639 959 1,416 664 1,665 622 708 707 1,705 693 730 932 1,788 1,004 1,764 947 1,780 1,780 1,424 972 939 966 856 907 1,004 912 1,684 912 1,448 1,080 1,004 1,827 952 928 933 878 1,461 1,294 965 1,004 1,277 INVESTMENT REPORT AS OF APRIL 30,2010 INVESTMENT DATE TYPE SECURITY 09/04/2009 FA FNMA 2.50% CALL 9/7/10 05/05/2008 FA FHLB 5.00% NON-CALL 08/22/2008 FA FHLB 4.5% NON-CALL 03/08/2010 FA FHLMC 2.125% NON-CALL 10/01/2009 FA FFCB 1.80% NON-CALL 11/25/2009 FA FFCB 1.80% NON-CALL 12/24/2009 FA FHLMC 2.0% CALL 9/28/10 05/11/2009 FA FHLMC 3.875% NON-CALL 12/10/2007 FA FFCB 4.5% NON-CALL 12/07/2009 FA FNMA 1.875% CALL 10/29/10 06/03/2008 FA FNMA 6.41% NON-CALL 05/19/2009 FA FNMA 2.2% CALL 5/19/10 12/14/2009 FA FHLB 1.0% CALL 12/14/11 STEP 01/14/2008 FA FHLB 4.25% CALL 10/14/08 10/20/2009 FA FFCB 5.15% NON-CALL 11/25/2009 FA FHLB 2.0% CALL 8/25/10 03/10/2008 FA FHLB 3.50% NON-CALL 11/25/2009 FA FHLB 2.35% CALL 9/15/10 08/26/2009 FA FHLMC 2.5% CALL 4/8/11 05/14/2008 FA FHLB 4.00% CALL 5/15/10 10/20/2009 FA FHLMC 4.25% NON-CALL 03/10/2010 FA FHLMC 2.0% CALL 10/20/2009 FA FHLMC 4.0% NON-CALL 11/10/2008 FA FHLB 5.375% NON-CALL 08/13/2009 FA FHLB 4.25% NON-CALL 12/24/2009 FA FNMA 2.125% CALL 12/24/10 12/28/2009 FA FHLB 1.85% NON-CALL 12/03/2008 FA FFCB 4.625% CALL 7/8/10 08/27/2008 FA FNMA 4.375% NON-CALL 08/21/2009 FA FHLMC 2.4% CALL 7/23/10 01/26/2010 FA FHLB 2.125% CALL 1/26/11 02/19/2010 FA FHLMC 1.0% CALL 2/15/11 08/19/2009 FA FFCB 2.7% NON-CALL 02/26/2010 FA FNMA 2.05% CALL 8/26/10 02/26/2010 FA FHLMC 2.125% CALL 8/26/10 11/12/2008 FA FHLB 4.0% NON-CALL 03/10/2010 FA FHLB 2.1% CALL 12/17/2008 FA FHLB 4.375% NON-CALL 03/24/2010 FA FHLMC 4.125% NON-CALL 02/23/2010 FA FFCB 3.875% NON-CALL 04/15/2010 FA FHLB 2.00% NON-CALL 10/19/2009 FA FFCB 5.350% NON-CALL 11/26/2008 FA FHLB 3.5% CALL 11/26/10 01/20/2009 FA FHLB 3.125% NON-CALL ^ 02/12/2010 FA FFCB 3.00% NON-CALL -- 02/12/2010 FA FNMA 2.125% CALL 10/28/11 PAR VALUE 2,000,000.00 1,175,000.00 1,000,000.00 3,000,000.00 1,000,000.00 3,000,000.00 3,000,000.00 1,000,000.00 2,000,000.00 1,000,000.00 1,807,000.00 2,000,000.00 1,000,000.00 3,000,000.00 1,000,000.00 1,000,000.00 3,000,000.00 1,000,000.00 2,000,000.00 2,000,000.00 500,000.00 1,000,000.00 500,000.00 1,000,000.00 2,000,000.00 1,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 1,000,000.00 1,000,000.00 2,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 2,000,000.00 3,000,000.00 1,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 1,000,000.00 1,000,000.00 INVESTED AMOUNT 2,000,000.00 1,238,814.19 1,022,730.00 3,058,800.00 1,003,470.00 3,032,750.01 3,014,100.00 1,063,510.00 2,034,780.00 1,003,900.00 1,990,388.82 2,000,000.00 999,500.00 3,000,000.00 1,102,490.00 999,531.25 2,963,940.00 1,009,500.00 2,008,000.00 2,000,000.00 536,967.86 1,000,000.00 532,794.50 1,065,788.37 2,130,988.03 1,000,000.00 1,987,226.45 2,053,420.00 2,035,600.00 1,991,200.00 2,000,000.00 1,000,000.00 1,005,669.88 2,000,000.00 1,000,000.00 1,007,890.00 1,000,000.00 2,154,940.00 3,222,330.00 1,065,180.00 2,000,000.00 2,235,072.36 2,000,000.00 2,047,941.08 1,028,536.49 1,014,759.55 RETURN RATE 2.500% 3.640% 3.889% 1.336% 1 .680% 1 .405% 1 .824% 1.928% 4.100% 1.736% 3.890% 2.200% 1.673% 4.250% 1.926% 2.015% 3.765% 2.051% 2.384% 4.000% 2.100% 2.000% 2.120% 3.800% 2.450% 2.125% 2.040% 3.983% 3.970% 2.518% 2.125% 2.054% 2.550% 2.050% 2.125% 3.818% 2.100% 2.625% 1.930% 2.000% 2.000% 2.264% 4.361% 2.600% 2.250% 3.167% INTEREST 150,416.67 192,237.89 160,020.00 102,877.08 50,180.00 120,099.99 151,566.67 67,701.81 401,970.00 50,370.83 331,405.40 154,000.00 50,500.00 637,500.00 67,316.94 65,468.75 560,476.67 68,180.56 172,833.33 320,000.00 39,296.03 65,000.00 40,094.39 181,163.02 195,081.41 74,375.00 142,273.55 371,823.06 392,177.78 197,066.67 148,750.00 72,388.89 102,330.12 143,500.00 74,375.00 184,776.67 73,500.00 259,712.78 211,826.25 75,181.11 140,000.00 193,522.08 440,000.00 258,135.31 91,463.51 121,601.56 INVESTMENT RETURN 2,150,416.67 1,431,052.08 1,182,750.00 3,161,677.08 1,053,650.00 3,152,850.00 3,165,666.67 1,131,211.81 2,436,750.00 1,054,270.83 2,321,794.22 2,154,000.00 1,050,000.00 3,637,500.00 1,169,806.94 1,065,000.00 3,524,416.67 1,077,680.56 2,180,833.33 2,320,000.00 576,263.89 1,065,000.00 572,888.89 1,246,951.39 2,326,069.44 1,074,375.00 2,129,500.00 2,425,243.06 2,427,777.78 2,188,266.67 2,148,750.00 1,072,388.89 1,108,000.00 2,143,500.00 1,074,375.00 1,192,666.67 1,073,500.00 2,414,652.78 3,434,156.25 1,140,361.11 2,140,000.00 2,428,594.44 2,440,000.00 2,306,076.39 1,120,000.00 1,136,361.11 TERM (Days) 1,099 1,593 1,484 928 1,089 1,034 1,009 1,238 1,773 1,057 1,624 1,280 1,096 1,827 1,206 1,188 1,824 1,206 1,321 1,826 1,310 1,188 1,331 1,677 1,401 1,278 1,278 1,678 1,785 1,432 1,277 1,273 1,461 1,277 1,277 1,759 1,280 1,731 1,283 1,322 1,279 1,463 1,826 1,788 1,461 1,536 INVESTMENT REPORT AS OF APRIL 30,2010 INVESTMENT DATE 03/24/2010 10/20/2009 01/21/2010 11/05/2009 03/24/2010 03/24/2010 03/22/2010 03/24/2010 09/24/2009 04/22/2010 02/24/2010 12/30/2009 03/09/2010 03/12/2010 03/12/2009 02/11/2009 02/18/2009 02/25/2009 03/02/2009 03/02/2009 03/09/2010 11/24/2009 06/05/2009 04/21/2009 12/24/2009 06/05/2009 09/16/2009 06/05/2009 09/16/2009 11/24/2009 11/24/2009 12/24/2009 07/22/2009 09/02/2009 11/24/2009 01/20/2010 >09/02/2009 11/24/2009 TYPE FA FA FA FA FA FA FA FA FA FA FA FA FA FA FN FN FN FN FN FN FN TR TR TR TR TR TR TR TR TR TR TR TR TR TR TR TR TR SECURITY FHLB 2.5% NON-CALL FFCB 4.375% NON-CALL FNMA 3.03% CALL 7/21/10 FNMA 3.3% CALL 7/30/10 FHLB 5.5% NON-CALL FHLB 5.25% NON-CALL FNMA 2.570% CALL FFCB 3.0% NON-CALL FNMA 2.0% CALL 9/23/1 1 STEP FHLB 2.0% CALL 10/28/11 STEP FHLMC 3.125% QUARTERLY CALL FNMA 2.3% QRTLY CALL STEP FNMA 3.0% CALL FHLMC 1 .0% STEP CALL 3/23/1 1 SUB-TOTAL FICO STRIP 0.00% NON-CALL FiCO STRIP 0.00% NON-CALL FICO STRIP 0.00% NON-CALL FICO STRIP 0.00% NON-CALL FICO 0.0% NON-CALL FICO 0.0% NON-CALL FICO 0.0% NON-CALL SUB-TOTAL Federal Investments Total US TREASURY 00% US TREASURY 4.50% US TREASURY 2.625% US TREASURY 0.0% US TREASURY 2.8750% US TREASURY 2.8750% US TREASURY 2.750% US TREASURY 2.750% US TREASURY 00% US TREASURY 00% US TREASURY 00% US TREASURY 2.00% US TREASURY 1.50% US TREASURY 1 .50% US TREASURY 0.0% US TREASURY 1.25% US TREASURY 1.25% PAR VALUE 3,000,000.00 3,000,000.00 1,000,000.00 1,100,000.00 3,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 3,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 1,000,000.00 4,000,000.00 283,055,000.00 1,000,000.00 2,000,000.00 1,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 12,000,000.00 295,055,000.00 3,000,000.00 3,000,000.00 3,000,000.00 6,000,000.00 3,000,000.00 2,000,000.00 3,000,000.00 2,000,000.00 4,000,000.00 2,000,000.00 5,000,000.00 3,000,000.00 5,000,000.00 2,000,000.00 4,000,000.00 5,000,000.00 3,000,000.00 INVESTED AMOUNT 3,016,423.52 3,234,480.00 1,001,875.00 1,110,340.00 3,395,255.41 2,231,960.00 2,000,000.00 2,047,400.80 3,000,000.00 2,015,640.00 2,010,896.00 2,000,000.00 1,000,000.00 4,000,000.00 289,577,178.73 956,370.00 1,889,240.00 916,713.56 1,826,280.00 1,818,680.00 1,793,820.00 1,882,080.00 11,083,183.56 300,660,362.29 2,998,156.25 3,114,140.63 3,069,492.19 5,995,298.33 3,076,875.00 2,040,781.25 3,077,578.13 2,042,343.75 3,994,500.00 1,996,801.67 4,990,520.83 3,052,031.25 5,062,500.00 2,023,125.00 3,991,946.67 5,048,828.13 3,029,179.69 RETURN RATE 2.363% 2.595% 2.985% 3.084% 2.323% 2.490% 2.570% 2.440% 3.163% 2.950% 3.000% 3.150% 3.000% 3.400% 2.710% 2.200% 2.300% 2.710% 2.850% 3.000% 3.050% 1 .850% 2.576% 0.127% 0.452% 0.529% 0.157% 0.469% 0.282% 0.501% 0.317% 0.183% 0.193% 0.254% 0.537% 0.419% 0.259% 0.244% 0.461% 0.291% INTEREST 300,034.82 381,665.83 134,475.00 161,580.83 328,452.92 237,040.00 231,300.00 222,265.87 479,833.33 270,026.67 284,937.33 315,000.00 150,000.00 680,000.00 28,110,151.57 43,630.00 110,760.00 83,286.44 173,720.00 181,320.00 206,180.00 117,920.00 916,816.44 29,026,968.01 1 ,843.75 13,155.57 17,911.66 4,701.67 15,331.49 4,531.25 17,684.30 5,631.79 5,500.00 3,198.33 9,479.17 19,444.16 24,524.46 4,886.05 8,053.33 28,869.96 8,935.06 INVESTMENT RETURN 3,316,458.34 3,616,145.83 1,136,350.00 1,271,920.83 3,723,708.33 2,469,000.00 2,231,300.00 2,269,666.67 3,479,833.33 2,285,666.67 2,295,833.33 2,315,000.00 1,150,000.00 4,680,000.00 317,687,330.30 1,000,000.00 2,000,000.00 1,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 12,000,000.00 329,687,330.30 3,000,000.00 3,127,296.20 3,087,403.85 6,000,000.00 3,092,206.49 2,045,312.50 3,095,262.43 2,047,975.54 4,000,000.00 2,000,000.00 5,000,000.00 3,071,475.41 5,087,024.46 2,028,011.05 4,000,000.00 5,077,698.09 3,038,114.75 TERM (Days) 1,542 1,714 1,642 1,728 1,603 1,633 1,645 1,643 1,825 1,650 1,728 1,826 1,826 1,837 1,191 744 908 1,178 1,171 1,166 1,314 1,206 1,098 2,289 177 344 405 182 390 287 421 318 275 303 187 435 424 341 302 454 371 INVESTMENT REPORT AS OF APRIL 30,2010 (A) INVESTMENT DATE 02/12/2010 10/01/2009 10/19/2009 10/19/2009 12/30/2009 10/28/2009 09/24/2009 10/28/2009 11/24/2009 01/20/2010 11/24/2009 02/23/2010 03/24/2010 11/10/2008 11/12/2008 04/02/2010 12/15/2008 03/19/2008 11/01/2007 03/19/2008 02/03/2006 01/31/2008 03/16/2007 10/11/2007 09/28/2007 02/17/2006 03/30/2006 06/20/2006 04/19/2006 06/12/2006 04/16/2007 04/21/2009 05/21/2007 04/02/2009 05/30/2008 05/30/2008 05/12/2009 05/29/2007 08/14/2009 04/28/2009 08/17/2009 J 03/20/2007 TYPE TR TR TR TR TR TR TR TR TR TR TR TR TR TR TR CD CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN SECURITY US TREASURY .875% US TREASURY 0.875% US TREASURY 0.875% US TREASURY 0.875% US TREASURY 0.875% US TREASURY 0.875% US TREASURY 1.1250% US TREASURY 1.1250% US TREASURY 1.1250% US TREASURY 1.00% US TREASURY 1.00% US TREASURY 1.00% US TREASURY 1.00% US TREASURY 3.125% US TREASURY 3.125% SUB-TOTAL WELLS FARGO BANK 9218910637 SUB-TOTAL TOYOTA 3.834% NON-CALL GOLDMAN SACHS 4.50% NON-CALL WAL-MART 4.125% NON-CALL WAL-MART 4.125% NON-CALL US BANCORP 4.50% NON-CALL WELLS FARGO 4.625% NON-CALL WAL-MART 4.75% NON-CALL WAL-MART 4.75% NON-CALL NEW YORK LIFE 4.625% NON-CALL CITIGROUP 5.125% NON-CALL CITIGROUP 5.125% NON-CALL CITIGROUP 5.125% NON-CALL HOME DEPOT 5.20% NON-CALL GENERAL ELECTRIC 5.50% NON-CALL GENERAL ELECTRIC 5.50% NON-CALL TOYOTA FIN 5.375% NON-CALL TOYOTA 5.450% NON-CALL ROYAL BANK OF CANADA 5.65% NON-CALL WELLS FARGO CO 5.30% NON-CALL GENWORTH GLOBAL 5.375% NON-CALL MET LIFE GLOBAL FUNDING 5.125% NON-CAL GENERAL ELECTRIC 5.50% CALL 11/15/08 SUNTRUST BANK 3.0% NON-CALL CITIGROUP 2.875% NON-CALL TOYOTA 5.25% NON-CALL GENERAL ELECTRIC 5.875% NON-CALL PAR VALUE 2,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 4,000,000.00 3,000,000.00 4,000,000.00 3,000,000.00 4,000,000.00 1,000,000.00 5,000,000.00 3,000,000.00 8,000,000.00 1,000,000.00 1,000,000.00 106,000,000.00 33,000.00 33,000.00 1,000,080.00 1,000,000.00 1,000,000.00 2,000,000.00 3,000,000.00 2,000,000.00 3,000,000.00 2,000,000.00 1,000,000.00 5,000,000.00 2,000,000.00 2,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 2,000,000.00 4,000,000.00 1,000,000.00 1,000,000.00 2,000,000.00 1,000,000.00 1,850,000.00 2,000,000.00 2,000,000.00 2,250,000.00 5,956,000.00 INVESTED AMOUNT 2,010,100.00 3,014,531.25 3,012,656.25 3,011,718.75 4,010,625.00 3,008,320.31 4,018,593.75 3,018,398.44 4,037,343.75 1,005,625.00 5,031,445.31 3,016,170.00 8,025,312.50 1,031,328.00 1,030,781.25 106,887,048.33 33,000.00 33,000.00 997,777.82 1,025,648.53 991,910.00 2,060,389.92 2,952,150.09 2,063,614.72 3,002,689.16 1,993,580.00 987,620.00 5,000,000.00 1,991,793.10 1,969,446.60 2,974,590.00 3,006,145.34 3,048,646.38 2,078,000.00 4,054,280.00 1 ,066,260.00 1,032,919.79 2,016,628.76 1,020,480.00 1,850,000.00 2,066,260.00 2,060,840.00 2,427,570.00 6,187,688.40 RETURN RATE 0.301% 0.509% 0.544% 0.587% 0.661% 0.699% 0.859% 0.755% 0.538% 0.630% 0.641% 0.660% 0.801% 2.430% 2.452% 0.514% 0.050% 0.050% 4.000% 3.300% 4.448% 2.750% 4.900% 3.300% 4.720% 4.870% 5.090% 5.125% 5.220% 5.500% 5.400% 5.450% 5.050% 3.372% 5.070% 2.659% 4.200% 5.100% 4.250% 5.500% 1.500% 1 .680% 1 .800% 4.970% INTEREST 5,321.27 20,421.20 21,012.23 24,103.07 33,125.00 33,421.49 60,889.95 38,096.13 34,680.71 9,673.91 56,814.36 31,797.03 102,864.30 118,792.86 121,777.13 906,472.64 620.00 620.00 34,892.59 75,101.47 118,090.00 127,985.08 653,849.91 169,690.84 483,790.01 276,642.22 145,734.17 1,279,114.58 507,609.68 507,178.40 784,610.00 798,687.99 616,853.62 142,375.00 815,903.33 63,690.00 138,741.32 344,093.46 107,217.92 453,918.06 69,073.33 89,458.61 99,695.62 1,483,867.09 INVESTMENT RETURN 2,015,421.27 3,034,952.45 3,033,668.48 3,035,821.82 4,043,750.00 3,041,741.80 4,079,483.70 3,056,494.57 4,072,024.46 1,015,298.91 5,088,259.67 3,047,967.03 8,128,176.80 1,150,120.86 1,152,558.38 107,793,520.97 33,620.00 33,620.00 1,032,670.41 1,100,750.00 1,110,000.00 2,188,375.00 3,606,000.00 2,233,305.56 3,486,479.17 2,270,222.22 1,133,354.17 6,279,114.58 2,499,402.78 2,476,625.00 3,759,200.00 3,804,833.33 3,665,500.00 2,220,375.00 4,870,183.33 1,129,950.00 1,171,661.11 2,360,722.22 1,127,697.92 2,303,918.06 2,135,333.33 2,150,298.61 2,527,265.62 7,671,555.49 TERM (Days) 322 487 469 497 456 580 644 610 583 557 645 584 586 1,755 1,783 505 30 30 519 818 973 834 1,637 921 1,248 1,039 1,053 1,823 1,782 1,700 1,777 1,781 1,473 748 1,458 839 1,183 1,203 911 1,631 824 955 857 1,793 INVESTMENT REPORT AS OF APRIL 30,2010 INVESTMENT DATE 10/11/2007 11/15/2007 05/12/2009 05/05/2009 04/21/2009 04/23/2009 04/30/2008 08/31/2007 05/30/2008 02/08/2010 07/17/2008 08/31/2007 10/31/2007 11/23/2007 01/30/2008 04/24/2008 05/07/2008 05/12/2009 05/30/2008 05/09/2008 12/23/2008 05/12/2009 06/26/2009 05/29/2009 TYPE CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN O O O O O O O O SECURITY GENERAL ELETRIC 5.875% NON-CALL GENERAL ELETRIC 5.875% NON-CALL CHEVRON 3.450% NON-CALL BARCLAYS BANK 2.7% NON-CALL BERKSHIRHATWY4.00% NON-CALL BERKSHIRHATWY4.00% NON-CALL PRINCIPAL LIFE INC 4.5% NON-CALL GENERAL ELECTRIC 6.00% NON-CALL GENERAL ELECTRIC 6.00% NON-CALL GENERAL ELECTRIC 6.00% NON-CALL PROTECTIVE LIFE 5.050% NON-CALL JOHNSON & JOHNSON 5.15% NON-CALL GENERAL ELECTRIC 5.250% NON-CALL GENERAL ELECTRIC 5.250% NON-CALL WELLS FARGO 5.250% NON-CALL MET LIFE GLOBAL FUNDING 5 MET LIFE GLOBAL FUNDING 5 WAL-MART 4.250% NON-CALL ALLSTATE LIFE 5.375% NON-CALL NEW YORK LIFE 4.650% NON-CALL BERKSHIRHATWY 4.60% NON-CALL 3 M 4.375% NON-CALL PROTER & GAMBLE 4.60% NON-CALL WAL-MART 3.20% NON-CALL WELLS FARGO BANK CORPORATE CASH MANAGEMENT ACCOUNT LIBRARY ACCOUNT UNION TRUST L A I F WATER DISTRICT L A I F PUBLIC IMPROVEMENT L A I F PUBLIC FINANCING CORPORATION L A I F CITY OF CARLSBAD 3ALL 3ALL ,LL ,LL i\LL CALL CALL CALL ALL sl-CALL I-CALL I-CALL i% NON-CAL i% NON-CAL L _L iLL ALL SUB-TOTAL T ACCOUNT 'RPORATION )RATION SUB-TOTAL PAR VALUE 3,000,000.00 2,000,000.00 3,000,000.00 1,575,000.00 1,000,000.00 2,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 2,000,000.00 3,000,000.00 1,000,000.00 2,000,000.00 2,000,000.00 1,000,000.00 1,000,000.00 2,000,000.00 1,000,000.00 2,000,000.00 1,000,000.00 1,000,000.00 2,000,000.00 5,000,000.00 1,000,000.00 101,631,080.00 532,336.00 2,276,863.22 642.92 400.00 12,534,240.85 14,738,384.67 10,357,262.87 14,995,593.53 55,435,724.06 INVESTED AMOUNT 3,089,347.40 2,089,414.35 3,103,177.11 1,590,861.34 1,022,563.95 2,039,340.00 1,000,000.00 1,033,437.31 1,052,958.51 2,174,860.00 3,000,000.00 1,017,457.28 2,036,663.70 2,065,283.50 1,042,814.41 1,003,232.48 2,019,402.04 1,047,829.91 2,023,559.81 1,006,649.66 1,023,835.68 2,121,417.76 5,246,650.00 1,003,190.00 103,780,874.81 532,336.00 2,276,863.22 642.92 400.00 12,534,240.85 14,738,384.67 10,357,262.87 14,995,593.53 55,435,724.06 RETURN RATE 5.100% 4.700% 2.180% 2.330% 3.200% 3.300% 4.500% 5.200% 4.550% 2.167% 5.050% 4.750% 4.830% 4.500% 4.240% 5.050% 4.900% 2.950% 5.100% 4.500% 4.000% 2.850% 3.420% 3.130% 4.207% 0.100% 0.100% 0.000% 0.050% 0.560% 0.560% 0.560% 0.560% 0.537% INTEREST 676,360.93 409,960.65 187,485.39 104,626.16 96,769.38 198,882.22 178,375.00 253,896.02 189,541.49 107,473.33 605,158.33 237,753.83 484,836.30 449,799.83 205,539.76 251,024.46 485,410.46 118,982.59 504,981.86 225,850.34 177,542.10 251,186.41 800,488.89 155,565.56 17,745,355.59 1.46 6.24 - 0.00 194.98 229.26 161.11 233.26 826.32 INVESTMENT RETURN 3,765,708.33 2,499,375.00 3,290,662.50 1,695,487.50 1,119,333.33 2,238,222.22 1,178,375.00 1,287,333.33 1,242,500.00 2,282,333.33 3,605,158.33 1,255,211.11 2,521,500.00 2,515,083.33 1,248,354.17 1,254,256.94 2,504,812.50 1,166,812.50 2,528,541.67 1,232,500.00 1,201,377.78 2,372,604.17 6,047,138.89 1,158,755.56 121,526,230.40 532,337.46 2,276,869.46 642.92 400.00 12,534,435.83 14,738,613.93 10,357,423.98 14,995,826.79 55,436,550.38 TERM (Days) 1,588 1,553 1,026 1,035 1,090 1,088 1,447 1,750 1,477 858 1,459 1,811 1,815 1,792 1,728 1,812 1,799 1,434 1,796 1,826 1,604 1,556 1,664 1,812 1,372 1 1 1 1 1 1 1 1 GRAND TOTAL 558,154,804.06 566,797,009.49 2.355% 47,680,242.56 614,477,252.05 EXHIBIT 8 CITY OF CARLSBAD Fund Equity in Pooled Investments AS OF APRIL 30, 2010 Cash Balance by Fund: General 70,383,062 Special Revenue 48,695,349 Debt Service 0 Capital Projects: General Capital Construction 68,253,060 Traffic Impact Fees 16,308,668 Public Facilities Fees 44,602,129 Park Development 2,381,108 Transnet Taxes 6,175,607 Drainage Fees 7,386,412 Special Districts 74,208,039 Infrastructure Replacement 53,865,151 Redevelopment 3,295,160 Other Capital Construction 2,886,030 Total 279,361,364 Enterprise: Carlsbad Municipal Water District 66,413,406 Sewer Fund 49,667,358 Solid Waste 7,093,603 Storm Water 2,383,119 Golf Course 217,880 Total 125,775,367 Internal Service 28,260,102 Agency Funds 13,878,256 Misc. Special Funds 0 Total General Ledger Balance ** 566,353,500 Reconciling Adjustments (1) (3,037,285) Total Treasurer's Investment Portfolio at Amortized Cost 563,316,215 (1) The Reconciling Adjustments consist of differences between the General Ledger which is prepared on an accrual basis and the Treasurer's report which is prepared on the cash basis. Accrued Interest, amortized premium or discounts and outstanding checks and deposits in transit are not included in the Treasurer's summary. Differences between the time journal entries are posted and the time this report is produced may also be a component of the adjustment. ** Figures based on best estimate at the time report run on 5/07/10 EXHIBIT 9 CITY OF CARLSBAD INVESTMENT PORTFOLIO As of April 30, 2010 CORPORATE NOTE AND COMMERCIAL PAPER RATINGS Corporate Note Investments Meeting the Current Investment Policy: (Ratings must be AA or better by both Moody's and S&P) Moody's S&P AAA AA2 AA1 AA2 AAA AA3 AAA AA3 AAA AAA AA2 AA1 AA2 AAA AA- AA AA+ AAA AA- AAA AA- AA- AAA AA- AA AA BARCLAYS BANK BERKSHIRE HATHAWAY CHEVRON GENERAL ELECTRIC JOHNSON & JOHNSON MET LIFE GLOBAL NEW YORK LIFE PROCTER & GAMBLE ROYAL BANK OF CANADA SUNTRUST BANK 3M TOYOTA WAL-MART Commercial Paper Investments Meeting the Current Investment Policy: (Ratings must be A1/P1 or better by both Moody's and S&P) (Ratings of other debt must be AA or better by Moody's and S&P) NONE Investments with Subsequent Changes in Credit Rating * ALL STATE LIFE CITIGROUP GENWORTH GLOBAL GOLDMAN SACHS HOME DEPOT PRINCIPAL LIFE PROTECTIVE LIFE US BANCORP WELLS FARGO * The City's Investment Policy allows the City Treasurer to determine the course of action that would correct exceptions to the policy. All of these investments are paying interest at the required times. The principal of all investments are considered secure. It is the intent of the City Treasurer to hold these assets in the portfolio until maturity unless events indicate they should be sold. loody's A1 A3 A2 A1 BAA1 AA3 A2 AA3 A1 S&P AA- A A A BBB+ A+ AA- A+ AA- Purchased 05/30/2008 06/20/2006 05/07/2008 03/19/2008 06/12/2006 04/30/2008 07/17/2008 02/03/2006 01/30/2008 Carrying Value 2,014,362 11,030,881 2,006,800 1,001,400 2,995,649 1,000,000 3,000,000 2,997,394 4,042,702 Market Value 2,195,920 11,284,610 2,075,820 1,003,220 3,105,360 1,024,020 2,959,890 3,025,800 4,148,230 CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF APRIL 30, 2010 WEIGHTINGS FOR CORPORATE AND FEDERAL AGENCY ISSUERS EXHIBIT 10 PERCENTAGE WEIGHTINGS BY CORPORATE NOTE ISSUER Investment Cost ALL STATE LIFE BARCLAYS BANK BERKSHIRE HATHAWAY CHEVRON CITIGROUP GENERAL ELECTRIC CAP GENWORTH GLOBAL GOLDMAN SACHS HOME DEPOT JOHNSON & JOHNSON MET LIFE GLOBAL FUND NEW YORK LIFE PRINCIPAL LIFE PROCTER & GAMBLE PROTECTIVE LIFE ROYAL BANK OF CANADA SUNTRUST BANK 3M TOYOTA US BANKCORP WAL-MART WELLS FARGO 2,023,559.81 1,590,861.34 4,085,739.63 3,103,177.11 11,022,079.70 27,634,444.89 2,016,628.76 1,025,648.53 2,974,590.00 1,017,457.28 4,043,114.52 1,994,269.66 1,000,000.00 5,246,650.00 3,000,000.00 1,066,260.00 2,066,260.00 2,121,417.76 9,557,627.82 2,952,150.09 10,099,588.99 4,139,348.92 PERCENTAGE WEIGHTINGS BY FEDERAL AGENCY ISSUER Investment Cost FAMCA 7,884,746.01 FICO 11,083,183.56 FEDERAL FARM CREDIT BANK 54,409,870.13 FEDERAL HOME LOAN BANK 131,451,858.50 FEDERAL HOME LOAN MORTGAGE CORP 47,227,408.43 FEDERAL NATIONAL MORTGAGE ASSOC 43,072,817.17 TVA 5,530,478.48 U.S.TREASURY 106,887,048.33 Total Portfolio * No more than 5% may be invested with a single corporate issuer. "There are no percentage limits on federal agency issuers. Percent of Portfolh 0.36% 0.28% 0.72% 0.55% 1.94% 4.88% 0.36% 0.18% 0.52% 0.18% 0.71% 0.35% 0.18% 0.93% 0.53% 0.19% 0.36% 0.37% 1.69% 0.52% 1.78% 0.73% Percent of Portfolio" 1.39% 1.96% 9.60% 23.19% 8.33% 7.60% 0.98% 18.86% $566,797,009.49 /7