The URL can be used to link to this page

Home My WebLink About2011-11-08; City Council; 20736; REPORT ON CITY INVESTMENTS SEPTEMBER 30 2011CITY OF CARLSBAD - AGENDA BILL AB# MTG. DEPT. 20,736 11/8/11 TRS REPORT ON CITY INVESTMENTS AS OF SEPTEMBER 30, 2011 DEPT. HEAD "cU CITYATTY. (&> CITY MGR. (j/ — 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 September 30, 2011 is summarized below. Pooled Investment Portfolio (Cash and Securities) Par Value Cost of Investments Amortized Cost (1) Market Value (2) Current Month 577,413,874 583,401,174 579,868,637 585,168,084 Prior Month 575,024,868 581,094,248 577,362,020 583,762,721 (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 9/30/11. The equity portion of the various funds in the total portfolio is summarized in the graph below. Fund balances are restricted for various purposes. See Exhibit 8 for a more detailed breakdown. FUND EQUITY IN POOLED INVESTMENTS (Dollar Amounts in Millions) General Special Revenue $62.5 $ 54.6 Internal Service $32Agency 9 Enterprise$i35.5 Capital Projects $293.4 Total Treasurer's Investment Portfolio at Amortized Cost September 30, 2011 $579.9 million FOR CITY CLERKS USE ONLY. COUNCIL ACTION: APPROVED D DENIED D CONTINUED D WITHDRAWN D AMENDED D CONTINUED TO DATE SPECIFIC CONTINUED TO DATE UNKNOWN RETURNED TO STAFF OTHER - SEE MINUTESCouncil received the report. D D D D DEPARTMENT CONTACT: Nancy Sullivan (760) 602-2473 Nancv.Sullivan@carlsbadca.gov PAGE 2 OF AB REPORT ON CITY INVESTMENTS AS OF SEPTEMBER 30. 2011 Pooled Investment Interest Income Cash Income Fiscal Year-to-Date * Current Month FYTD 3,459,031 Prior Month FYTD 2,316,354 Current Month Income 1,142,677 *The cash income received is adjusted for any accrued interest purchased. Pooled Investment Performance/Measurement July 2011 August 201 1 September 201 1 Average Life (Years) 1.95 1.93 2.05 Average Yield To Maturity 1 .92% 1.87% 1.78% Modified Duration 1.865 1.853 1.965 All pooled investments have been made in accordance with the City's Investment Policy adopted January 2, 1985 and last revised June 21, 2011. 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. Investment Portfolio for Bond Proceeds Par Value Cost Current Quarter 17,735,893 17,735,893 Prior Quarter 17,634,669 17,634,669 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. First 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 EXHIBIT FOR INVESTMENTS OF BOND PROCEEDS HELD SEPARATELY: 11. Detailed Investment Report - Quarterly Report EXHIBIT FOR SUMMARY OF OUTSTANDING HOUSING LOANS: 12. Detail Of Outstanding Housing Loans - Quarterly Report CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF SEPTEMBER 30, 2011 BREAKDOWN BY AMORTIZED COST, MARKET VALUE, CASH INCOME, AND AVERAGE YIELD BY CLASS AVERAGE YIELD Class CD FN CP TR FA CN LAIF CUSTODY SWEEP BANKACCT TOTALS Current Month 3,475,000 16,735,321 0 10,026,394 343,677,352 83,503,696 116,974,000 2,028,312 2,537,556 911,006 $579,868,637 Prior Month 1,736,000 16,707,850 0 13,029,546 344,632,566 80,955,190 117,852,000 625 1,439,350 1,008,894 $577,362,020 CD - Certificate of Deposit FN - Federal Discount Notes CP - Corporate Paper Current Month 3,461,645 16,965,885 0 10,116,350 347,486,202 84,687,128 116,974,000 2,028,312 2,537,556 911,006 $585,168,084 TR - US Treasury FA - Federal Agency CN - Corporate Notes Prior Month 1,727,444 16,972,274 0 13,133,530 349,126,569 82,502,036 117,852,000 625 1,439,350 1,008,894 $583,762,721 Cash Income Year to Date 0 0 0 71,250 2,551,336 713,751 122,307 4 383 0 3,459,031 Current Month Prior Month 1.10 1.85 0.00 1.03 1.96 3.20 0.39 0.00 0.05 0.05 1.78% 1.15 1.85 0.00 1.03 2.07 3.35 0.39 0.00 0.05 0.05 1.87% LAIF - Local Agency Investment Fund Custody - Investment Cash account SWEEP - General Fund Overnight Cash acccount Bank Account - General Fund Cash account EXHIBIT CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF SEPTEMBER 30, 2011 BREAKDOWN OF MATURITIES BY CLASSIFICATION AND LENGTH OF TIME CLASS CD FN CP TR FA CN LAIF CUSTODY SWEEP BANK ACCT TOTALS % TOTALS Total within One POLICY: WITHIN 6 MONTHS 7 0 0 0 8,025,313 20,259,257 22,382,461 116,974,000 2,028,312 2,537,556 911,006 $173,117,905 (1) 29.7% Year (1) Not less than $129,000,000 (2) Policy states that not more MONTHS TO 1 YEAR 0 4,561,674 0 0 62,930,855 12,340,617 0 0 0 0 $79,833,146 (1) 13.7% $252,951,051 (1) 43.4% 1 TO 5 YEARS 3,475,000 11,557,329 0 2,062,109 263,214,255 50,141,430 0 0 0 0 $330,450,123 56.6% to mature within one year. (2/3 rds of current year operating than 30% of portfolio is to be invested in corporate notes. TOTAL 3,475,000 16,119,003 0 10,087,422 346,404,368 84,864,509 116,974,000 2,028,312 2,537,556 911,006 $583,401,174 100.0% budget of $193,817,000.00) % TOTAL 0.6% 2.8% 0.0% 1.7% 59.4% 14.6% (2) 20.1% 0.4% 0.4% 0.2% 100.0% WXa dd to YIELD COMPARISON PORTFOLIO EX-LAIF VS. LAIF JULY 1998 - SEPTEMBER 2011 H Xa Hw H 1-3 U) MARKET YIELD CURVE 6/30/10,6/30/11,9/30/11 3.5 2.5 1.5 1 0.5 Market Rates 3Mth 2Yr 5Yr 3Mth 2Yr 5Yr 10 Yr -—06/30/2010 -*- 06/30/2011 -^•09/30/2011 .17 .01 .02 .60 .46 .24 1.77 1.76 .95 2.93 3.16 1.92 10 Yr Xa Hw Cumulative Millions $ Cumulative Cash Income FY11-12 (September 2011 )Monthly Interest Income Millions $ It 12 10 8 6 4 2 i n ^^^ ^^^ ^^^ ^^^ 1.238 1^*^ 1-078 rJrT 1.143 ^ o 7 6 5 4 3 2 1 n Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun czziInterest Income --•--Budget Actual M Xa H H3 (Jl City of Carlsbad TRANSACTIONS FOR PERIOD: 07/01/11 TO 09/30/11 1ST QUARTER 2011-2012 Trans Date BUYS JULY 06/22/201 1 07/11/2011 06/30/201 1 07/13/2011 07/19/2011 07/22/201 1 06/29/201 1 06/29/201 1 07/12/2011 07/1 1/201 1 07/19/2011 07/26/2011 07/22/201 1 07/19/2011 07/29/201 1 AUGUST 07/29/201 1 07/27/201 1 08/03/201 1 08/08/201 1 08/10/2011 08/09/201 1 08/16/2011 08/12/2011 08/12/2011 08/15/2011 08/18/2011 08/17/2011 08/19/2011 08/24/201 1 08/12/2011 08/12/2011 08/12/2011 08/12/2011 08/12/2011 08/12/2011 08/16/2011 08/25/201 1 SEPTEMBER 09/01/2011 09/07/201 1 09/01/2011 Investment Date 07/11/2011 07/12/2011 07/18/2011 07/18/2011 07/20/201 1 07/25/201 1 07/26/201 1 07/26/201 1 07/26/201 1 07/27/2011 07/27/201 1 07/27/201 1 07/27/201 1 07/28/201 1 07/29/201 1 08/01/2011 08/03/201 1 07/27/201 1 08/10/2011 08/11/2011 08/15/2011 08/17/2011 08/18/2011 08/22/201 1 08/24/201 1 08/25/201 1 08/25/201 1 08/25/201 1 08/29/201 1 08/17/2011 08/17/2011 08/17/2011 08/17/2011 08/19/2011 08/19/2011 08/24/2011 08/26/201 1 09/09/2011 09/12/2011 09/15/2011 Type FA FA FA CN 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 CD CD CD CD CD CD CD FA FA CN FA Security FNMA FHLB FNMA GENERAL ELECTRIC FNMA FNMA FHLMC FHLMC FHLB FNMA FFCB FNMA FNMA FHLMC FHLB FFCB FHLB FNMA FNMA FHLB FFCB FHLMC FFCB FFCB FHLB FFCB FFCB FFCB FNMA AMERICAN EXPRESS BAW CIT BANK DISCOVER BANK ALLY BANK GE MONEY BANK GE CAPITAL FINANCIAL GOLDMAN SACHS BANK FNMA FHLB GENERAL ELECTRIC FNMA Call Date 01/11/2012 10/14/2011 01/18/2012 N/A 04/13/2012 N/A 10/26/2011 10/26/2011 08/26/2011 01/27/2012 07/27/2012 01/05/2012 01/27/2012 10/28/2011 08/04/201 1 08/01/2012 09/30/201 1 01/27/2012 05/23/2012 10/21/2011 08/15/2012 01/27/2012 11/18/2011 08/22/2012 02/24/2012 11/25/2011 11/25/2011 11/25/2011 08/24/2012 N/A N/A N/A N/A N/A N/A N/A 02/14/2012 03/09/2012 N/A 03/15/2012 Par Value 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,500,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 3,500,000.00 2,000,000.00 2,000,000.00 2,000,000.00 5,000,000.00 5,000,000.00 2,000,000.00 4,000,000.00 5,000,000.00 5,000,000.00 2,000,000.00 3,000,000.00 2,000,000.00 2,000,000.00 4,000,000.00 3,000,000.00 3,000,000.00 5,000,000.00 3,000,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 3,000,000.00 5,000,000.00 1,400,000.00 5,000,000.00 Coupon 1.75% STEP 1 .550% 2.100% 2.100% 2.000% 0.000% 2% STEP 2% STEP 2.250% 1.700% 1.550% 2.000% 1.550% 0.75% STEP 0.750% 1.000% 1%STEP 2.375% 2.000% 2.150% 1.750% 1 .75 STEP% 1 .370% 1 .500% 1.550% 1.370% 0.750% 0.850% 1%STEP 1.200% 1.100% 1.150% 1.150% 1.150% 1.150% 1.150% 0.75% STEP 0.625% STEP 2.950% 2.000% Amount (Cost) 2,000,000.00 1,997,500.00 1,991,000.00 2,037,760.00 2,019,620.00 2,419,825.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 3,500,000.00 1,999,800.00 2,000,000.00 2,000,000.00 5,000,000.00 5,000,000.00 2,000,000.00 4,031,120.00 5,039,000.00 5,014,050.00 2,000,000.00 3,011,250.00 2,000,000.00 2,000,000.00 4,000,000.00 3,000,000.00 3,000,000.00 5,000,000.00 3,000,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 3,003,480.00 4,990,000.00 1,427,513.33 5,034,900.00 Return Rate 2.138% 1 .580% 2.196% 1.320% 1.730% 1.020% 2.310% 2.310% 2.250% 1.700% 1.550% 2.002% 1.550% 1.266% 0.750% 1.000% 2.287% 2.209% 1.809% 2.090% 1 .750% 2.115% 1 .370% 1.500% 1.550% 1.370% 0.750% 0.850% 1.735% 1 .200% 1.100% 1.150% 1.150% 1.150% 1.150% 1.150% 1.607% 1.988% 2.500% 1.853% Interest 215,000.00 134,422.22 219,000.00 65,956.67 129,602.22 80,175.00 232,500.00 232,500.00 225,000.00 136,000.00 217,000.00 197,755.56 124,000.00 76,250.00 75,208.33 150,000.00 193,166.67 442,032.78 389,611.11 517,477.78 175,000.00 315,833.33 116,450.00 150,000.00 310,000.00 185,625.00 67,500.00 138,125.00 262,083.33 8,887.23 8,198.94 8,571.62 8,579.43 8,563.81 8,563.81 8,571.62 119,520.00 503,750.00 164,875.84 465,100.00 Investment Return 2,215,000.00 2,131,922.22 2,210,000.00 2,103,716.67 2,149,222.22 2,500,000.00 2,232,500.00 2,232,500.00 2,225,000.00 2,136,000.00 3,717,000.00 2,197,555.56 2,124,000.00 2,076,250.00 5,075,208.33 5,150,000.00 2,193,166.67 4,473,152.78 5,428,611.11 5,531,527.78 2,175,000.00 3,327,083.33 2,116,450.00 2,150,000.00 4,310,000.00 3,185,625.00 3,067,500.00 5,138,125.00 3,262,083.33 256,887.23 256,198.94 256,571.62 256,579.43 256,563.81 256,563.81 256,571.62 3,123,000.00 5,493,750.00 1,592,389.17 5,500,000.00 M Xa Hdd H t-3 City of Carlsbad TRANSACTIONS FOR PERIOD: 07/01/11 TO 09/30/11 1ST QUARTER 2011-2012 Trans Investment Date 09/09/201 1 09/08/201 1 09/08/201 1 09/07/201 1 08/23/201 1 09/13/2011 08/23/201 1 09/14/2011 09/19/2011 09/08/201 1 09/14/2011 09/07/201 1 09/01/2011 09/27/201 1 09/22/201 1 TOTAL FIRST MATURITIES JULY AUGUST SEPTEMBER Date 09/15/2011 09/16/2011 09/16/2011 09/16/2011 09/16/2011 09/16/2011 09/20/2011 09/21/2011 09/22/201 1 09/23/2011 09/23/2011 09/27/201 1 09/28/2011 09/29/201 1 09/30/2011 QUARTER 03/09/2007 08/01/2007 08/31/2007 05/08/2008 03/31/2009 05/11/2009 12/30/2009 04/02/2009 06/29/2009 01/20/2010 10/01/2009 03/19/2007 01/23/2009 06/22/2009 02/11/2009 11/24/2009 05/30/2008 03/05/2007 03/15/2007 01/23/2009 10/30/2007 05/30/2008 02/23/2010 Type CD CD CD FA FA CN FA CD CN CD CD FA FA FA CD 2011-2012 FA FA FA FA FA FA FA CN FA TR FA FA FA FA FN TR CN FA FA FA FA CN TR Security BANK OF THE WEST MERRICK BANK SAFRA NATIONAL BANK FNMA FHLB BERKSHIRE HATHAWAY FHLMC TRANS ALLIANCE BANK TOYOTA STATE BANK OF INDIA BMW BANK OF NORTH AM FHLMC FHLMC FNMA COMPASS BANK FNMA FAMCA FAMCA FAMCA FFCB FAMCA FHLMC ROYAL BANK OF CANADA FHLB US TREASURY FHLB FHLB FHLB FFCB FICO US TREASURY WELLS FARGO FHLB FHLB FHLB FHLMC GENWORTH GLOBAL US TREASURY Call Date N/A N/A N/A 03/16/2012 12/16/2011 N/A 12/20/2011 N/A N/A N/A N/A 12/27/2011 03/28/2012 03/28/2012 N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A Par Value 249,000.00 249,000.00 248,000.00 5,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 249,000.00 5,000,000.00 248,000.00 248,000.00 4,000,000.00 5,000,000.00 5,000,000.00 248,000.00 133,875,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 1,000,000.00 2,000,000.00 1,000,000.00 1,000,000.00 3,000,000.00 1,000,000.00 3,000,000.00 2,000,000.00 5,000,000.00 1,000,000.00 2,000,000.00 3,000,000.00 1,000,000.00 3,000,000.00 2,000,000.00 3,000,000.00 Coupon 1 .400% 0.700% 0.800% 1.450% 1.510% 3.200% 1%STEP 0.750% 2.000% 1.300% 1.350% 1.550% 1.35% STEP 1.25% STEP 1 .000% 3.640% 5.500% 5.500% 5.500% 3.625% 5.500% 5.250% 5.650% 1 .625% 1.000% 1.375% 5.750% 5.750% 3.875% 0.000% 1.000% 5.300% 5.000% • 5.000% 5.000% 5.500% 5.375% 1.000% Amount (Cost) 249,000.00 249,000.00 248,000.00 5,000,000.00 2,998,500.00 3,175,710.00 2,998,500.00 249,000.00 5,023,645.00 248,000.00 248,000.00 4,000,000.00 5,000,000.00 5,000,000.00 248,000.00 134,188,173.33 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 1,066,260.00 2,012,680.00 1,005,625.00 1,006,100.00 3,111,810.00 1,097,950.00 3,152,520.00 1,889,240.00 5,031,445.31 1,032,919.79 2,018,200.00 3,032,352.00 1,077,520.00 3,117,300.00 2,016,628.76 3,016,170.00 Return Rate 1.400% 0.700% 0.800% 1.450% 1.520% 1 .430% 1 .839% 0.750% 1.900% 1.300% 1.350% 1.550% 1.505% 1 .445% 1.000% 1.609% 4.805% 5.175% 4.781% 3.545% 1 .639% 2.050% 0.900% 2.659% 1.315% 0.630% 1.375% 4.800% 1.818% 1.490% 2.300% 0.641% 4.200% 4.773% 4.730% 1.958% 4.390% 5.100% 0.660% Interest 13,943.96 3,490.83 3,973.43 362,500.00 228,000.00 150,956.67 279,000.00 5,612.71 474,410.56 9,680.83 10,053.17 310,000.00 377,500.00 362,326.39 4,966.80 9,682,872.65 406,997.78 618,286.67 118,184.21 233,760.22 85,530.00 46,807.78 25,313.30 63,690.00 54,847.78 9,673.91 19,261.11 648,148.33 49,313.89 100,323.75 110,760.00 56,814.36 138,741.32 432,911.11 640,148.00 53,868.89 522,075.00 344,093.46 31,797.03 Investment Return 262,943.96 252,490.83 251,973.43 5,362,500.00 3,226,500.00 3,326,666.67 3,277,500.00 254,612.71 5,498,055.56 257,680.83 258,053.17 4,310,000.00 5,377,500.00 5,362,326.39 252,966.80 143,871,045.98 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 1,129,950.00 2,067,527.78 1,015,298.91 1,025,361.11 3,759,958.33 1,147,263.89 3,252,843.75 2,000,000.00 5,088,259.67 1,171,661.11 2,451,111.11 3,672,500.00 1,131,388.89 3,639,375.00 2,360,722.22 3,047,967.03 City of Carlsbad TRANSACTIONS FOR PERIOD: 07/01/11 TO 09/30/11 1ST QUARTER 2011-2012 Trans Date Investment Date Type TOTAL FIRST QUARTER 2011-2012 CALLS JULY 03/17/2011 03/01/2011 02/16/2011 05/05/201 1 03/29/201 1 10/19/2010 03/24/2011 01/25/2011 01/26/2011 06/16/2011 06/04/2010 06/08/2010 01/28/2011 10/15/2010 AUGUST 01/26/2011 12/01/2010 05/05/201 1 09/14/2010 11/16/2010 02/16/2011 10/28/2010 02/18/2011 08/18/2010 05/12/2011 06/01/2011 02/18/2011 04/13/2011 12/01/2010 11/17/2010 12/03/2010 06/06/2011 07/29/2011 03/29/201 1 08/25/201 1 02/25/201 1 02/25/201 1 05/25/201 1 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 FHLB FNMA FNMA FFCB FHLMC FHLMC FHLMC FNMA FHLB FNMA FNMA FNMA FHLMC FHLB FHLB FFCB FFCB FFCB FNMA FNMA FFCB FNMA FNMA FHLB FHLB FNMA FHLB FHLB FNMA FFCB FFCB FHLB FHLB FHLB FNMA FHLMC FHLB Call Date 07/01/2011 07/01/2011 07/01/2011 07/06/201 1 07/13/2011 07/19/2011 07/21/2011 07/25/201 1 07/26/201 1 07/27/201 1 07/28/201 1 07/28/201 1 07/28/201 1 07/29/201 1 08/02/201 1 08/10/2011 08/12/2011 08/12/2011 08/16/2011 08/16/2011 08/17/2011 08/18/2011 08/18/2011 08/18/2011 08/18/2011 08/18/2011 08/19/2011 08/19/2011 08/19/2011 08/22/201 1 08/22/201 1 08/23/201 1 08/24/201 1 08/24/201 1 08/25/201 1 08/25/201 1 08/25/201 1 Par Value 45,366,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 2,000,000.00 2,000,000.00 500,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 1,500,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,410,000.00 2,000,000.00 2,000,000.00 1,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 5,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 Coupon 2.000% 1 .500% 1 .200% 1 .500% 2.750% 0.5% STEP 2.500% 2.600% 2.590% 1.75% STEP 3.000% 3.000% 2.15% STEP 1 .450% 2.590% 1.600% 1.800% 1.875% 1.700% 2% STEP 0.875% 2.000% 1.500% 2.000% 2.000% 2% STEP 1%STEP 1%STEP 1.250% 1.850% 1.980% 0.750% 1 .820% 1 .820% 2.850% 2.000% 1.500% Amount (Cost) 46,360,493.25 2,007,940.00 2,000,000.00 1,989,940.00 2,000,000.00 1,999,000.00 1,000,000.00 1,999,500.00 2,000,000.00 500,000.00 2,001,500.00 2,037,406.00 2,040,000.00 2,000,000.00 2,009,400.00 1,500,000.00 2,000,000.00 2,000,000.00 2,000,000.00 1,997,000.00 2,000,000.00 2,000,000.00 2,000,000.00 1,999,500.00 1,996,000.00 2,408,795.00 2,000,000.00 1,957,500.00 1,000,000.00 2,006,760.00 1,998,000.00 2,000,000.00 5,000,000.00 1,976,000.00 2,006,000.00 2,000,000.00 2,000,000.00 2,000,000.00 Return Rate 2.893% 1.864% 1.500% 1.390% 1.500% 2.761% 1.021% 2.505% 2.600% 2.590% 2.677% 2.522% 2.488% 2.605% 1.322% 2.590% 1.600% 1.800% 1.875% 1.731% 2.718% 0.875% 2.000% 2.375% 2.045% 2.011% 2.700% 2.421% 2.746% 1.125% 1.873% 1.979% 0.750% 2.107% 1.757% 2.850% 2.000% 1.500% Interest 4,811,347.90 120,000.00 80,000.00 75,060.00 101,583.33 264,388.89 25,625.00 241,750.00 260,000.00 25,900.00 222,486.11 211,594.00 208,333.33 262,500.00 100,477.78 194,250.00 128,000.00 135,000.00 187,500.00 173,000.00 275,000.00 52,500.00 150,000.00 240,500.00 192,111.11 225,335.00 270,000.00 222,000.00 139,666.67 62,128.89 168,500.00 176,880.00 75,208.33 184,261.11 175,898.89 285,000.00 140,000.00 97,500.00 Investment Return 51,171,841.15 2,127,940.00 2,080,000.00 2,065,000.00 2,101,583.33 2,263,388.89 1,025,625.00 2,241,250.00 2,260,000.00 525,900.00 2,223,986.11 2,249,000.00 2,248,333.33 2,262,500.00 2,109,877.78 1,694,250.00 2,128,000.00 2,135,000.00 2,187,500.00 2,170,000.00 2,275,000.00 2,052,500.00 2,150,000.00 2,240,000.00 2,188,111.11 2,634,130.00 2,270,000.00 2,179,500.00 1,139,666.67 2,068,888.89 2,166,500.00 2,176,880.00 5,075,208.33 2,160,261.11 2,181,898.89 2,285,000.00 2,140,000.00 2,097,500.00 City of Carlsbad TRANSACTIONS FOR PERIOD: 07/01/11 TO 09/30/11 1ST QUARTER 2011-2012 Trans Investment Date Date 07/26/201 1 05/26/201 1 SEPTEMBER 10/06/2010 01/25/2011 05/12/2009 09/10/2010 03/09/201 1 03/25/201 1 03/23/201 1 09/24/2009 06/23/201 1 06/27/201 1 09/30/2010 09/30/2010 08/03/201 1 06/30/201 1 06/30/201 1 Type FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA Security FHLB FHLB FHLB FFCB CHEVRON FNMA FHLMC FHLMC FNMA FNMA FHLB FHLB ROYAL BANK OF CANADA FFCB FHLB FHLB FHLMC Call Date 08/26/2011 08/26/201 1 09/01/2011 09/01/2011 09/03/201 1 09/09/201 1 09/09/201 1 09/15/2011 09/23/201 1 09/23/201 1 09/23/2011 09/27/201 1 09/30/201 1 09/30/201 1 09/30/201 1 09/30/201 1 09/30/201 1 Par Value 2,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 900,000.00 2,000,000.00 3,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 3,000,000.00 2,000,000.00 Coupon 2.250% 2% STEP 1.400% 1.500% 3.450% 1.850% 2.5% STEP 2% STEP 2.200% 2% STEP 2.01% STEP 0.875% 1.75% STEP 1 .990% 1%STEP 2.200% 0.5%STEP Amount (Cost) 2,000,000.00 2,000,000.00 2,000,000.00 1,952,000.00 3,103,177.11 1,999,000.00 2,000,000.00 900,000.00 2,000,000.00 3,000,000.00 2,000,000.00 1,999,500.00 2,000,000.00 1,999,000.00 2,000,000.00 3,000,000.00 2,000,000.00 Return Rate 2.250% 2.320% 1.400% 2.063% 2.180% 1.861% 3.000% 2.790% 2.200% 3.163% 2.258% 0.885% 2.255% 2.001% 0.998% 2.200% 1.540% Interest 225,000.00 233,750.00 112,000.00 182,666.67 187,485.39 185,897.22 302,500.00 125,500.00 176,000^00 479,833.33 226,850.00 44,250.00 227,000.00 200,000.00 193,166.67 330,000.00 93,125.00 Investment Return 2,225,000.00 2,233,750.00 2,112,000.00 2,134,666.67 3,290,662.50 2,184,897.22 2,302,500.00 1,025,500.00 2,176,000.00 3,479,833.33 2,226,850.00 2,043,750.00 2,227,000.00 2,199,000.00 2,193,166.67 3,330,000.00 2,093,125.00 TOTAL FIRST QUARTER 2011-2012 109,310,000.00 109,382,918.11 2.0026% 9,674,962.72 119,057,880.83 INVESTMENT REPORT AS OF SEPTEMBER 30, 2011 INVESTMENT DATE 12/08/2009 03/15/2007 12/07/2009 12/08/2009 03/19/2007 12/30/2009 12/09/2009 06/29/2009 05/21/2007 07/25/2007 10/19/2009 07/25/2007 07/25/2007 07/15/2008 05/20/2010 10/20/2009 11/25/2009 01/20/2010 08/05/2008 03/24/2010 06/04/2010 12/24/2009 01/25/2010 01/20/2010 03/16/2010 01/29/2009 12/24/2009 06/04/2010 06/04/2010 05/05/2008 08/22/2008 06/04/2010 03/08/2010 10/01/2009 11/25/2009 05/11/2009 12/10/2007 06/04/2010 06/03/2008 12/14/2009 \^ 07/01/2010 f . ^ 01/14/2008 ^M 10/20/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 SECURITY FFCB 1.128% NON-CALL FHLB 4.875% NON-CALL FHLB 4.25% NON-CALL FHLB 4.25% NON-CALL FHLB 4.875% NON-CALL FNMA 1.0% NON-CALL FFCB .875% NON-CALL FFCB 2.0% NON-CALL FFCB 4.875% NON-CALL TVA 6.790% NON-CALL TVA 6.790% NON-CALL FHLB 5.375% NON-CALL FHLB 5.375% NON-CALL FHLB 4.375% NON-CALL FHLB 1.375% NON-CALL FFCB 2.125% NON-CALL FFCB 5.45% NON-CALL FHLMC 5.125% NON-CALL FFCB 3.950% NON-CALL FHLB 1.25% NON-CALL FHLMC 1.125% NON-CALL FNMA 5.00% NON-CALL FAMCA 2.1% NON-CALL FNMA 1.75% NON-CALL FNMA 1.75% NON-CALL FHLB 4.625% NON-CALL FHLB 4.625% NON-CALL FHLB 2.4% NON-CALL FHLB 1.1 % NON-CALL FHLB 5.00% NON-CALL FHLB 4.5% NON-CALL FHLB 2.00% NON-CALL FHLMC 2.125% NON-CALL FFCB 1.80% NON-CALL FFCB 1.80% NON-CALL FHLMC 3.875% NON-CALL FFCB 4.5% NON-CALL FHLB 1.375% NON-CALL FNMA 6.41% NON-CALL FHLB 1.0% CALL 12/14/11 STEP FHLMC 4.125% NON-CALL FHLB 4.25% CALL 10/14/08 FFCB 5.15% NON-CALL PAR VALUE 3,000,000.00 3,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 3,000,000.00 1,000,000.00 1,000,000.00 3,000,000.00 5,000,000.00 3,000,000.00 2,000,000.00 1,000,000.00 2,000,000.00 2,000,000.00 5,000,000.00 1,037,000.00 1,000,000.00 1,000,000.00 3,000,000.00 2,000,000.00 1,000,000.00 1,000,000.00 4,000,000.00 1,175,000.00 1,000,000.00 5,000,000.00 3,000,000.00 1,000,000.00 3,000,000.00 1,000,000.00 2,000,000.00 3,000,000.00 1,807,000.00 1,000,000.00 3,000,000.00 3,000,000.00 1,000,000.00 INVESTED AMOUNT 3,014,854.10 3,018,777.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 2,130,980.00 3,399,498.48 1,005,040.00 1 ,005,254.43 3,050,958.11 5,036,422.30 3,049,023.21 2,210,347.28 1,092,760.00 2,002,900.00 2,000,352.89 5,004,198.09 1,127,519.73 1,015,908.69 1,009,004.81 3,034,050.00 2,150,960.00 1,078,810.00 1 ,027,049.96 4,000,013.10 1,238,814.19 1,022,730.00 5,091,850.00 3,058,800.00 1,003,470.00 3,032,750.01 1,063,510.00 2,034,780.00 3,012,394.24 1,990,388.82 999,500.00 3,233,040.00 3,000,000.00 1,102,490.00 RETURN RATE 0.850% 4.720% 1 .020% 0.956% 4.795% 1.105% 1.020% 1.630% 5.015% 5.235% 1 .534% 5.255% 5.250% 3.900% 1.015% 1.496% 1.280% 1.320% 3.910% 1.243% 1.085% 1.567% 1.460% 1.390% 1 .268% 2.391% 1 .567% 1.150% 1.100% 3.640% 3.889% 1.180% 1.336% 1.680% 1.405% 1 .928% 4.100% 1 .200% 3.890% 1 .673% 0.939% 4.250% 1.926% INTEREST 46,552.13 647,473.00 20,552.78 38,509.44 672,403.75 62,826.67 20,364.00 167,200.00 489,057.50 524,632.22 128,989.85 256,692.64 256,478.21 460,552.31 104,515.20 120,622.62 70,024.94 34,653.19 310,466.67 58,188.78 116,583.16 44,578.33 37,466.31 35,717.41 91,950.00 176,901.11 43,367.08 25,683.37 98,253.57 192,237.89 160,020.00 135,927.78 102,877.08 50,180.00 120,099.99 67,701.81 401,970.00 86,720.34 331,405.40 50,500.00 72,897.50 637,500.00 67,316.94 INVESTMENT RETURN 3,061,406.23 3,666,250.00 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,655,612.22 3,528,488.33 1,261,732.64 1,261,732.64 3,511,510.42 5,140,937.50 3,169,645.83 2,280,372.22 1,127,413.19 2,313,366.67 2,058,541.67 5,120,781.25 1,172,098.06 1,053,375.00 1,044,722.22 3,126,000.00 2,327,861.11 1,122,177.08 1 ,052,733.33 4,098,266.67 1,431,052.08 1,182,750.00 5,227,777.78 3,161,677.08 1,053,650.00 3,152,850.00 1,131,211.81 2,436,750.00 3,099,114.58 2,321,794.22 1 ,050,000.00 3,305,937.50 3,637,500.00 1,169,806.94 TERM (Days) 664 1,665 708 707 1,705 693 730 932 1,788 1,764 947 1,780 1,780 1,424 750 972 939 907 1,448 856 784 952 928 933 878 1,294 965 803 816 1,593 1,484 833 928 1,089 1,034 1,238 1,773 878 1,624 1,096 904 1,827 1,206 W X K HoaH INVESTMENT REPORT AS OF SEPTEMBER 30, 2011 INVESTMENT DATE 10/07/2010 03/10/2008 10/20/2009 03/02/2011 10/20/2009 11/10/2008 08/13/2009 05/25/2010 12/28/2009 08/27/2008 08/19/2009 11/12/2008 12/17/2008 03/24/2010 02/23/2010 04/15/2010 10/19/2009 10/25/2010 01/20/2009 12/20/2010 02/12/2010 08/26/2011 09/17/2010 04/18/2011 11/24/2010 02/12/2010 03/24/2010 10/20/2009 07/28/2011 08/01/2011 03/24/2010 08/25/2011 09/08/2010 03/24/2010 03/24/2010 10/21/2010 04/27/2011 04/22/2010 10/29/2010 08/25/2011 06/15/2011 06/15/2011 ^ 04/26/2011 ^ 06/29/2011 TYPE SECURITY FA FFCB 3.4% NON-CALL FA FHLB3.50% NON-CALL FA FHLMC 4.25% NON-CALL FA FHLMC .625% CALL 5/23/11 QRTLY FA FHLMC 4.0% NON-CALL FA FHLB 5.375% NON-CALL FA FHLB 4.25% NON-CALL FA FFCB 1.375% NON-CALL FA FHLB 1.85% NON-CALL FA FNMA 4.375% NON-CALL FA FFCB 2.7% NON-CALL FA FHLB 4.0% NON-CALL FA FHLB 4.375% NON-CALL FA FHLMC 4.125% NON-CALL FA FFCB 3.875% NON-CALL FA FHLB 2.00% NON-CALL FA FFCB 5.350% NON-CALL FA FFCB .84% CALL 10/25/11 CONT FA FHLB 3.125% NON-CALL FA FFCB 1.375% CALL CONT FA FFCB 3.00% NON-CALL FA FNMA .75% CALL 2/14/12 QRTLY STEP FA FNMA 1.3% CALL 3/17/11 FA FHLMC 1.50% ONE CALL FA FNMA 1.0% CALL 10/25/11 FA FNMA 2.125% CALL 10/28/11 FA FHLB 2.5% NON-CALL FA FFCB 4.375% NON-CALL FA FHLMC .75% CALL QRTLY STEP FA FFCB 1.0% CALL 8/1/12 CONT FA FHLB 5.5% NON-CALL FA FFCB .75% CALL 11/25/11 CONT FA FNMA 1.50% CALL 3/8/11 FA FHLB 5.25% NON-CALL FA FFCB 3.0% NON-CALL FA FHLB 1.35% CALL 1/21/11 QRTLY FA FHLMC 2.0% QRTLY CALLS FA FHLB 2.0% CALL 10/28/11 STEP FA FHLMC 1.125% CALL 4/29/11 QRTLY STEP FA FFCB .85% CALL 11/25/11 CONT FA FHLB 1.00% CALL QRTLY STEP FA FFCB 1.37% CALL CONT FA FNMA 2.0% ONE CALL FA FHLMC 1.25% CALL 6/29/12 PAR VALUE 1 ,065,000.00 3,000,000.00 500,000.00 2,000,000.00 500,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 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,150,000.00 1,000,000.00 3,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 1,000,000.00 3,000,000.00 3,000,000.00 2,000,000.00 5,000,000.00 3,000,000.00 3,000,000.00 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 5,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 INVESTED AMOUNT 1,133,986.44 2,963,940.00 536,967.86 1,983,520.00 532,794.50 1,065,788.37 2,130,988.03 1,993,760.00 1,987,226.45 2,035,600.00 1,005,669.88 1 ,007,890.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,150,000.00 1,028,536.49 3,003,480.00 2,000,000.00 2,000,000.00 1,998,000.00 1,014,759.55 3,016,423.52 3,234,480.00 2,000,000.00 5,000,000.00 3,395,255.41 3,000,000.00 2,000,000.00 2,231,960.00 2,047,400.80 2,000,000.00 2,000,000.00 2,015,640.00 1,000,000.00 5,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 RETURN RATE 0.600% 3.765% 2.100% 1.000% 2.120% 3.800% 2.450% 1.479% 2.040% 3.970% 2.550% 3.818% 2.625% 1.930% 2.000% 2.000% 2.264% 0.840% 2.600% 1.375% 2.250% 1 .670% 1.300% 1 .500% 1 .030% 3.167% 2.363% 2.595% 0.750% 1.000% 2.323% 0.750% 1.500% 2.490% 2.440% 1.350% 2.000% 2.950% 1.553% 0.850% 1.634% 1.370% 2.000% 1.250% INTEREST 15,503.56 560,476.67 39,296.03 44,292.50 40,094.39 181,163.02 195,081.41 91,031.67 142,273.55 392,177.78 102,330.12 184,776.67 259,712.78 211,826.25 75,181.11 140,000.00 193,522.08 50,400.00 258,135.31 47,437.50 91,463.51 119,520.00 91,000.00 104,666.67 70,388.89 121,601.56 300,034.82 381,665.83 76,250.00 150,000.00 328,452.92 67,500.00 120,000.00 237,040.00 222,265.87 108,000.00 140,000.00 270,026.67 62,500.00 138,125.00 115,000.00 95,900.00 146,666.67 87,500.00 INVESTMENT RETURN 1,149,490.00 3,524,416.67 576,263.89 2,027,812.50 572,888.89 1,246,951.39 2,326,069.44 2,084,791.67 2,129,500.00 2,427,777.78 1,108,000.00 1,192,666.67 2,414,652.78 3,434,156.25 1,140,361.11 2,140,000.00 2,428,594.44 2,050,400.00 2,306,076.39 1,197,437.50 1,120,000.00 3,123,000.00 2,091,000.00 2,104,666.67 2,068,388.89 1,136,361.11 3,316,458.34 3,616,145.83 2,076,250.00 5,150,000.00 3,723,708.33 3,067,500.00 2,120,000.00 2,469,000.00 2,269,666.67 2,108,000.00 2,140,000.00 2,285,666.67 1,062,500.00 5,138,125.00 2,115,000.00 2,095,900.00 2,146,666.67 2,087,500.00 TERM (Days) 854 1,824 1,310 813 1,331 1,677 1,401 1,127 1,278 1,785 1,461 1,759 1,731 1,283 1,322 1,279 1,463 1,096 1,788 1,096 1,461 903 1,277 1,092 1,248 1,536 1,542 1,714 1,096 1,096 1,603 1,096 1,461 1,633 1,643 1,461 1,279 1,650 1,461 1,188 1,279 1,279 1,340 1,279 INVESTMENT REPORT AS OF SEPTEMBER 30, 2011 INVESTMENT DATE 03/30/2011 03/29/2011 02/02/2011 07/20/2011 05/10/2011 06/04/2010 02/28/2011 06/10/2011 06/29/2011 07/27/2011 07/27/2011 07/27/2011 03/30/2011 04/04/2011 09/14/2010 09/21/2010 07/12/2011 10/15/2010 10/15/2010 10/27/2010 10/28/2010 06/08/2011 10/29/2010 11/05/2010 11/10/2010 05/19/2011 05/17/2011 08/18/2011 11/23/2010 08/10/2011 12/28/2010 12/30/2010 08/25/2011 04/08/2011 04/25/2011 04/27/2011 05/03/2011 06/29/2011 06/29/2011 06/30/2011 07/27/2011 07/11/2011 ^ 07/18/2011 08/11/2011 TYPE SECURITY FA FHLB 1.75% ONE CALL 12/30/11 FA FFCB 2.1% CALL 1/5/12 CONT FA FFCB 2.0% CALL 2/2/12 CONT FA FNMA 2.0% CALL 4/13/12 ONE TIME FA FHLB 2.0% CALL ONE TIME FA FNMA 2.00% CALL 10/29/12 STEP FA FHLB 2.0% CALL 5/29/12 CONT FA FFCB 1.69% CALL CONT FA FFCB 1.6% CALL CONT FA FNMA 1.70% CALL 1/27/12 FA FFCB 1.550% CALL 7/2712 CONT FA FNMA 1.55% CALL 1/27/12 FA FHLB 2.0% NON-CALL FA FHLB 2.0% NON-CALL FA FH LB 1.74% CALL 9/14/12 FA FNMA 2.0% CALL 3/21/11 FA FHLB 1.55% CALL 10/14/11QRTLY FA FNMA 1.50% CALL 4/15/11 QRTLY STEP FA FNMA 1.50% CALL 4/15/11 QRTLY STEP FA FNMA 1.55% CALL 10/27/11 FA FNMA 1.50% CALL 4/28/11 FA FNMA 1.00% CALL QRTLY STEP FA FNMA 1.25% CALL 4/29/11 QRTLY STEP FA FNMA 1.25% CALL 5/5/11 QRTLY STEP FA FNMA 1.375% CALL 5/10/11 QRTLY FA FNMA 1.0% CALL QRTLY FA FHLB 1.55% CALL QRTLY FA FFCB 1.37% CALL 11/18/11 CONT FA FFCB 2.0% CALL 5/23/12 CONT FA FNMA 2.0% CALL 5/23/12 FA FHLMC2.05% ONE CALL 12/28/11 FA FAMCA2.57% CALL SEMI-ANNUAL FA FFCB 1.37% CALL 11/25/11 CONT FA FHLB 2.7% QRTLY CALLS FA FNMA 2.65% CALL 4/25/12 ONE TIME FA FHLB 2.5% NON-CALL FA FAMCA 2.55% CALL FA FHLMC2.10%CALL FA FNMA 1.50% CALL STEP FA FNMA 1.20% CALL STEP FA FNMA 2.0% CALL ONE TIME FA FNMA 1.75% CALL QRTLY STEP FA FNMA 2.10% CALL QRTLY FA FHLB 2.15% CALL 10/21/11 QRTLY PAR VALUE 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,235,000.00 2,000,000.00 2,000,000.00 2,000,000.00 3,500,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,600,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,155,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 5,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 2,000,000.00 2,000,000.00 4,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 5,000,000.00 INVESTED AMOUNT 2,000,000.00 2,000,000.00 2,000,000.00 2,019,620.00 2,011,380.00 2,018,771.34 2,235,000.00 2,000,000.00 2,000,000.00 2,000,000.00 3,500,000.00 2,000,000.00 1,999,000.00 2,000,000.00 2,000,000.00 2,000,000.00 1,997,500.00 2,000,000.00 2,600,000.00 1,998,000.00 1,999,000.00 1,995,000.00 2,155,000.00 2,000,000.00 1,998,740.00 1,993,000.00 1,976,000.00 2,000,000.00 2,000,000.00 5,039,000.00 2,000,000.00 1 ,999,000.00 3,000,000.00 2,000,000.00 1,999,000.00 2,000,000.00 2,000,000.00 2,000,000.00 4,000,000.00 2,000,000.00 1,999,800.00 2,000,000.00 1,991,000.00 5,014,050.00 RETURN RATE 1 .750% 2.100% 2.000% 1 .730% 1.850% 2.780% 2.000% 1.690% 1 .600% 1.700% 1.550% 1.550% 2.012% 2.000% 1.740% 2.000% 1.550% 2.034% 2.034% 1.579% 1.510% 1.000% 1.932% 1.789% 1.728% 2.147% 1.829% 1.370% 2.000% 1.809% 2.050% 2.581% 1.370% 2.700% 2.661% 2.500% 2.550% 2.100% 2.250% 2.545% 2.002% 2.138% 2.196% 2.090% INTEREST 131,250.00 158,200.00 160,000.00 129,602.22 146,397.78 277,339.77 190,099.17 135,106.11 128,000.00 136,000.00 217,000.00 124,000.00 174,333.33 176,000.00 174,000.00 200,000.00 134,422.22 205,000.00 266,500.00 157,000.00 151,000.00 189,027.78 210,112.50 180,000.00 173,760.00 193,944.44 163,586.11 116,450.00 200,000.00 389,611.11 205,000.00 258,000.00 185,625.00 270,000.00 266,000.00 250,000.00 254,858.33 210,000.00 450,000.00 258,000.00 197,755.56 215,000.00 219,000.00 517,477.78 INVESTMENT RETURN 2,131,250.00 2,158,200.00 2,160,000.00 2,149,222.22 2,157,777.78 2,296,111.11 2,425,099.17 2,135,106.11 2,128,000.00 2,136,000.00 3,717,000.00 2,124,000.00 2,173,333.33 2,176,000.00 2,174,000.00 2,200,000.00 2,131,922.22 2,205,000.00 2,866,500.00 2,155,000.00 2,150,000.00 2,184,027.78 2,365,112.50 2,180,000.00 2,172,500.00 2,186,944.44 2,139,586.11 2,116,450.00 2,200,000.00 5,428,611.11 2,205,000.00 2,257,000.00 3,185,625.00 2,270,000.00 2,265,000.00 2,250,000.00 2,254,858.33 2,210,000.00 4,450,000.00 2,258,000.00 2,197,555.56 2,215,000.00 2,210,000.00 5,531,527.78 TERM (Days) 1,371 1,378 1,461 1,363 1,441 1,790 1,551 1,460 1,461 1,461 1,461 1,461 1,583 1,607 1,826 1,826 1,555 1,826 1,826 1,826 1,826 1,603 1,826 1,826 1,826 1,635 1,646 1,553 1,826 1,566 1,826 1,826 1,645 1,837 1,827 1,827 1,826 1,827 1,827 1,827 1,805 1,827 1,827 1,806 INVESTMENT REPORT AS OF SEPTEMBER 30, 2011 INVESTMENT DATE 07/26/201 1 07/26/201 1 08/04/2011 08/17/2011 08/15/2011 08/22/2011 08/24/2011 08/29/2011 09/09/2011 09/15/2011 09/16/2011 09/16/2011 09/20/2011 09/27/2011 09/28/2011 09/29/2011 02/18/2009 02/25/2009 03/02/2009 03/02/2009 03/09/2010 01/18/2011 11/24/2010 03/09/2011 07/25/2011 03/24/2010 11/10/2008 11/12/2008 05/12/2009 05/29/2007 08/14/2009 -— 04/28/2009 V 08/17/2009 TYPE FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FN FN FN FN FN FA FN FN FN TR TR TR CN CN CN CN CN SECURITY FHLMC 2.0% CALL QRTLY STEP FHLMC 2.0% CALL QRTLY STEP FNMA 2.375% CALL 1/27/12 QRTLY FHLMC 1.75% CALL 1/27/12 STEP FFCB 1 .75% CALL 8/15/12 CONT FFCB 1 .5% CALL 8/22/12 CONT FHLB 1.55% CALL 2/24/12 CONT FHLB 1.0% CALL 8/24/12 QRTLY STEP FHLB .625% CALL 3/9/12 QRTLY STEP FNMA 2.0% CALL 3/15/12 FNMA 1.45% CALL 3/16/12 QRTLY FHLB 1.510% CALL 12/16/11 CONT FHLMC 1.0% CALL 12/20/11 QRTLY FHLMC 1 .55% CALL 12/27/1 1 CALL QRTLY FHLMC 1 .35% CALL 3/28/12 QRTLY STEP FNMA 1.25% CALL 3/28/12 STEP SUB-TOTAL 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 FICO 0.00% NON-CALL FNMAO% NON-CALL FNMA .00% NON-CALL FNMA 00% NON-CALL SUB-TOTAL Federal Investments Total US TREASURY 1.00% US TREASURY 3.125% US TREASURY 4.0% SUB-TOTAL MET LIFE GLOBAL FUNDING 5.125% NON-CALL GENERAL ELECTRIC 5.50% CALL 11/15/08 SUNTRUST BANK 3.0% NON-CALL CITIGROUP 2.875% NON-CALL TOYOTA 5.25% NON-CALL PAR VALUE 2,000,000.00 2,000,000.00 4,000,000.00 3,000,000.00 2,000,000.00 2,000,000.00 4,000,000.00 3,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 3,000,000.00 3,000,000.00 4,000,000.00 5,000,000.00 5,000,000.00 341,724,000.00 1,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 1,076,000.00 2,000,000.00 2,657,000.00 2,500,000.00 17,233,000.00 358,957,000.00 8,000,000.00 1,000,000.00 1,000,000.00 10,000,000.00 1,000,000.00 1,850,000.00 2,000,000.00 2,000,000.00 2,250,000.00 INVESTED AMOUNT 2,000,000.00 2,000,000.00 4,031,120.00 3,011,250.00 2,000,000.00 2,000,000.00 4,000,000.00 3,000,000.00 4,990,000.00 5,034,900.00 5,000,000.00 2,998,500.00 2,998,500.00 4,000,000.00 5,000,000.00 5,000,000.00 346,404,367.52 916,713.56 1,826,280.00 1,818,680.00 1,793,820.00 1,882,080.00 1,027,655.32 1,922,260.00 2,511,688.67 2,419,825.00 16,119,002.55 362,523,370.07 8,025,312.50 1,031,328.00 1,030,781.25 10,087,421.75 1,020,480.00 1,850,000.00 2,066,260.00 2,060,840.00 2,427,570.00 RETURN RATE 2.310% 2.310% 2.209% 2.115% 1 .750% 1 .500% 1.550% 1.735% 1.988% 1.853% 1.450% 1.520% 1 .839% 1 .550% 1 .505% 1 .445% 1 .957% 2.710% 2.850% 3.000% 3.050% 1.850% 1 .370% 1.100% 1.700% 1.020% 1.854% 0.801% 2.430% 2.452% 1.136% 4.250% 5.500% 1.500% 1 .680% 1 .800% INTEREST 232,500.00 232,500.00 442,032.78 315,833.33 175,000.00 150,000.00 310,000.00 262,083.33 503,750.00 465,100.00 362,500.00 228,000.00 279,000.00 310,000.00 377,500.00 362,326.39 28,661,476.82 83,286.44 173,720.00 181,320.00 206,180.00 117,920.00 96,689.36 155,480.00 290,622.66 80,175.00 1,385,393.46 30,046,870.28 102,864.30 118,792.86 121,777.13 343,434.29 107,217.92 453,918.06 69,073.33 89,458.61 99,695.62 INVESTMENT RETURN 2,232,500.00 2,232,500.00 4,473,152.78 3,327,083.33 2,175,000.00 2,150,000.00 4,310,000.00 3,262,083.33 5,493,750.00 5,500,000.00 5,362,500.00 3,226,500.00 3,277,500.00 4,310,000.00 5,377,500.00 5,362,326.39 375,065,844.34 1,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 1,124,344.68 2,077,740.00 2,802,311.33 2,500,000.00 17,504,396.01 392,570,240.35 8,128,176.80 1,150,120.86 1,152,558.38 10,430,856.04 1,127,697.92 2,303,918.06 2,135,333.33 2,150,298.61 2,527,265.62 TERM (Days) 1,827 1,827 1,819 1,806 1,827 1,827 1,827 1,822 1,827 1,827 1,735 1,827 1,827 1,827 1,827 1,826 - 1,178 1,171 1,166 1,314 1,206 1,228 1,319 1,214 1,171 1,219 1,219 586 1,755 1,783 1,375 911 1,631 824 955 857 INVESTMENT REPORT AS OF SEPTEMBER 30, 2011 INVESTMENT DATE 03/20/2007 10/11/2007 11/15/2007 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 03/18/2011 12/28/2010 04/24/2008 05/07/2008 05/12/2009 05/30/2008 05/09/2008 02/11/2011 12/23/2008 05/12/2009 07/18/2011 05/27/201 1 05/29/2009 05/20/2010 09/16/2011 02/09/2011 05/06/2011 12/15/2010 12/15/2010 05/06/2011 05/16/2011 06/17/2011 09/12/2011 09/22/201 1 tj 09/16/2011 Si 09/16/2011 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 CN CN CN CN CN CN CN CN CN CN CN CN CN CN CN CD CD SECURITY GENERAL ELECTRIC 5.875% NON-CALL GENERAL ELETRIC 5.875% NON-CALL GENERAL ELETRIC 5.875% 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 OF CONNECTICUT 5.01% NON-CALL ROYAL BANK OF CANADA 2.25% NON-CALL MET LIFE GLOBAL FUNDING 5.125% NON-CALL MET LIFE GLOBAL FUNDING 5.125% NON-CALL WAL-MART 4.250% NON-CALL ALLSTATE LIFE 5.375% NON-CALL NEW YORK LIFE 4.650% NON-CALL NEW YORK LIFE 4.650% NON-CALL BERKSHIRHATWY4.60% NON-CALL 3 M 4.375% NON-CALL GENERAL ELECTRIC 2.10% NON-CALL WAL-MART 3.20% NON-CALL WAL-MART 3.20% NON-CALL MICROSOFT 2.95% NON-CALL BERKSHIRE HATHAWAY 3.20% NON-CALL MET LIFE GLOBAL FUNDING 2.5% NON-CALL MET LIFE GLOBAL FUNDING 2.5% NON-CALL BARCLAYS BANK 3.10% NON-CALL ROYAL BANK OF CANADA 2.625% NON-CALL MASS MUTUAL GLOB 3.125% NON-CALL GENERAL ELECTRIC 2.95% NON-CALL GENERAL ELECTRIC 2.95% NON-CALL GENERAL ELECTRIC 2.95% NON-CALL TOYOTA 2.0% NON-CALL SAFRA NATIONAL BANK .80% MERRICK BANK .70% PAR VALUE 5,956,000.00 3,000,000.00 2,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 2,000,000.00 2,000,000.00 1,000,000.00 2,000,000.00 1,000,000.00 2,000,000.00 1,000,000.00 2,000,000.00 1,000,000.00 2,000,000.00 2,000,000.00 2,500,000.00 1,000,000.00 2,000,000.00 3,000,000.00 1,000,000.00 1,000,000.00 2,000,000.00 2,000,000.00 1,000,000.00 2,000,000.00 2,000,000.00 1 ,400,000.00 5,000,000.00 12,531,000.00 248,000.00 249,000.00 INVESTED AMOUNT 6,187,688.40 3,089,347.40 2,089,414.35 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 2,121,360.00 2,047,930.00 1,003,232.48 2,019,402.04 1,047,829.91 2,023,559.81 1 ,006,649.66 2,150,000.00 1,023,835.68 2,121,417.76 2,037,760.00 2,645,275.00 1,003,190.00 2,072,820.00 3,175,710.00 978,478.42 993,799.11 2,000,000.00 2,038,220.00 1,024,175.57 2,000,912.32 2,009,952.38 1,427,513.33 5,023,645.00 84,864,508.62 248,000.00 249,000.00 RETURN RATE 4.970% 5.100% 4.700% 2.330% 3.200% 3.300% 4.500% 5.200% 4.550% 2.167% 5.050% 4.750% 4.830% 4.500% 4.240% 1.561% 1.150% 5.050% 4.900% 2.950% 5.100% 4.500% 1.250% 4.000% 2.850% 1.320% 1.200% 3.130% 2.005% 1.430% 3.000% 2.650% 3.100% 2.220% 3.125% 2.940% 2.840% 2.500% 1.900% 3.201% 0.800% 0.700% INTEREST 1,483,867.09 676,360.93 409,960.65 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 58,165.00 51,695.00 251,024.46 485,410.46 118,982.59 504,981.86 225,850.34 23,766.67 177,542.10 251,186.41 65,956.67 92,058.33 155,565.56 164,982.78 150,956.67 137,493.80 116,131.45 310,000.00 225,009.16 130,164.71 292,940.46 278,819.84 164,875.84 474,410.56 11,410,174.58 3,973.43 3,490.83 INVESTMENT RETURN 7,671,555.49 3,765,708.33 2,499,375.00 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 2,179,525.00 2,099,625.00 1,254,256.94 2,504,812.50 1,166,812.50 2,528,541.67 1,232,500.00 2,173,766.67 1,201,377.78 2,372,604.17 2,103,716.67 2,737,333.33 1,158,755.56 2,237,802.78 3,326,666.67 1,115,972.22 1,109,930.56 2,310,000.00 2,263,229.16 1,154,340.28 2,293,852.78 2,288,772.22 1,592,389.17 5,498,055.56 96,274,683.20 251,973.43 252,490.83 TERM (Days) 1,793 1,588 1,553 1,035 1,090 1,088 1,447 1,750 1,477 858 1,459 1,811 1,815 1,792 1,728 657 808 1,812 1,799 1,434 1,796 1,826 818 1,604 1,556 904 1,084 1,812 1,473 1,244 1,693 1,607 1,826 1,826 1,805 1,820 1,788 1,701 1,820 1,691 731 731 INVESTMENT REPORT AS OF SEPTEMBER 30, 2011 INVESTMENT DATE 09/30/201 1 08/17/2011 08/17/2011 08/17/2011 08/17/2011 08/17/2011 08/19/2011 08/24/201 1 09/21/2011 09/23/201 1 09/23/2011 09/15/2011 TYPE CD CD CD CD CD CD CD CD CD CD CD CD O O O O O O O O SECURITY COMPASS BANK 1.0% AMERICAN EXPRES CENTURION BANK 1.20% CIT BANK 1.10% DISCOVER BANK 1.15% ALLY BANK 1.15% GE MONEY BANK 1.15% GE CAPITAL FINANCIAL INC 1.15% GOLDMAN SACHS BANK 1.15% TRANSPORTATION ALLIANCE BANK INC .75% STATE BANK OF INDIA 1.30% BMW BANK OF NORTH AMERICA 1.35% BANK OF THE WEST 1.4% WELLS FARGO BANK CORPORATE CASH MANAGEMENT ACCOUNT LIBRARY ACCOUNT UNION TRUST L A I F WATER DISTRICT L A I F PUBLIC IMPROVEMENT CORPORATION L A I F PUBLIC FINANCING CORPORATION L A I F CITY OF CARLSBAD .20% .75% SUB-TOTAL 3UNT ^TION N SUB-TOTAL PAR VALUE 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 249,000.00 248,000.00 248,000.00 249,000.00 3,475,000.00 910,666.00 2,537,556.15 339.60 2,028,311.95 36,719,000.00 19,516,000.00 26,193,000.00 34,546,000.00 122,450,873.70 INVESTED AMOUNT 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 249,000.00 248,000.00 248,000.00 249,000.00 3,475,000.00 910,666.00 2,537,556.15 339.60 2,028,311.95 36,719,000.00 19,516,000.00 26,193,000.00 34,546,000.00 122,450,873.70 RETURN RATE 1 .000% 1 .200% 1.100% 1.150% 1.150% 1.150% 1.150% 1.150% 0.750% 1 .300% 1 .350% 1 .400% 1 .096% 0.050% 0.050% 0.000% 0.000% 0.390% 0.390% 0.390% 0.390% 0.374% INTEREST 4,966.80 8,887.23 8,198.94 8,571.62 8,579.43 8,563.81 8,563.81 8,571.62 5,612.71 9,680.83 10,053.17 13,943.96 111,658.19 1.25 3.48 - 0.01 397.79 211.42 283.76 374.25 1,271.95 INVESTMENT RETURN 252,966.80 256,887.23 256,198.94 256,571.62 256,579.43 256,563.81 256,563.81 256,571.62 254,612.71 257,680.83 258,053.17 262,943.96 3,586,658.19 910,667.25 2,537,559.63 339.60 2,028,311.96 36,719,397.79 19,516,211.42 26,193,283.76 34,546,374.25 122,452,145.65 TERM (Days) 1,090 1,097 1,097 1,097 1,098 1,096 1,097 1,097 1,096 1,096 1,460 1,112 1 1 1 1 1 1 1 1 GRAND TOTAL 577,413,873.70 583,401,174.14 1.784% 41,913,409.29 625,314,583.43 EXHIBIT 8 CITY OF CARLSBAD Fund Equity in Pooled Investments AS OF SEPTEMBER 30, 2011 Cash Balance by Fund: General 62,472,665 Special Revenue 54,607,705 Debt Service 0 Capital Projects: General Capital Construction 58,980,101 Traffic Impact Fees 18,382,206 Public Facilities Fees 46,423,104 Park Development 2,730,508 Transnet Taxes 7,008,817 Drainage Fees 5,651,773 Special Districts 75,819,183 Infrastructure Replacement 69,129,890 Redevelopment 5,672,992 Other Capital Construction 3,629,039 Total 293,427,612 Enterprise: Carlsbad Municipal Water District 76,881,492 Sewer Fund 48,527,738 Solid Waste 7,212,649 Storm Water 2,532,261 Golf Course 347,916 Total 135,502,057 Internal Service 32,017,672 Agency Funds 2,702,651 Misc. Special Funds 0 Total General Ledger Balance ** 580,730,361 Reconciling Adjustments (1) (861,724) Total Treasurer's Investment Portfolio at Amortized Cost 579,868,637 (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 10/11/11 EXHIBIT 9 CITY OF CARLSBAD INVESTMENT PORTFOLIO As of September 30, 201 1 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) Moodv's S&P BARCLAYS BANK BERKSHIRE HATHAWAY CITIGROUP GENERAL ELECTRIC JOHNSON & JOHNSON MASS MUTUAL GLOBAL MET LIFE GLOBAL MET LIFE OF CONNECTICUT MICROSOFT NEW YORK LIFE ROYAL BANK OF CANADA SUNTRUST BANK 3M TOYOTA WAL-MART AA3 AA2 AAA AA2 AAA AA2 AA3 AA3 AAA AAA AA1 AAA AA2 AA2 AA2 AA- AA+ AA+ AA+ AAA AA+ AA- AA- AAA AA+ AA AA+ AA- AA AA 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 Moodv's ALL STATE LIFE A1 PRINCIPAL LIFE PROTECTIVE LIFE WELLS FARGO AA3 A2 A1 Rating * Latest Carrying S&P Maturity Date Value A+ 04/30/2013 2,007,574 A 04/16/2012 1,000,000 AA- 07/15/2012 3,000,000 AA- 10/23/2012 1,009,604 Market Value 2,119,620 1,003,850 3,032,490 1,042,470 * 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. EXHIBIT 10 CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF AUGUST 31, 2011 WEIGHTINGS FOR CORPORATE AND FEDERAL AGENCY ISSUERS PERCENTAGE WEIGHTINGS BY CORPORATE NOTE ISSUER ALL STATE LIFE BARCLAYS BANK BERKSHIRE HATHAWAY CITIGROUP GENERAL ELECTRIC CAP JOHNSONS JOHNSON MASS MUTUAL MET LIFE GLOBAL FUND MET LIFE OF CONNECTICUT MICROSOFT NEW YORK LIFE PRINCIPAL LIFE PROTECTIVE LIFE ROYAL BANK OF CANADA SUNTRUST BANK 3M TOYOTA WAL-MART WELLS FARGO PERCENTAGE WEIGHTINGS BY FEDERAL AGENCY ISSUER FAMCA FICO FEDERAL FARM CREDIT BANK FEDERAL HOME LOAN BANK FEDERAL HOME LOAN MORTGAGE CORP FEDERAL NATIONAL MORTGAGE ASSOC TVA U.S.TREASURY Total Portfolio * No more than 5% may be invested with a single corporate issuer. "There are no percentage limits on federal agency issuers. Investment Cost 2,023,559.81 3,590,861.34 7,261,449.63 2,060,840.00 29,055,791.20 1,017,457.28 1,024,175.57 6,015,392.05 2,121,360.00 2,072,820.00 3,156,649.66 1,000,000.00 3,000,000.00 4,086,150.00 2,066,260.00 2,121,417.76 7,451,215.00 4,696,294.91 1,042,814.41 ENCY ISSUER Investment Cost 5,014,908.69 9,265,228.88 78,866,516.57 114,175,949.07 51,737,670.45 97,932,617.92 5,530,478.48 10,087,421.75 Percent of Portfolio* 0.35% 0.62% 1.24% 0.35% 4.98% 0.17% 0.18% 1.03% 0.36% 0.36% 0.54% 0.17% 0.51% 0.70% 0.35% 0.36% 1.28% 0.80% 0.18% Percent of Portfolio" 0.86% 1.59% 13.52% 19.57% 8.87% 16.79% 0.95% 1.73% $583,401,174.14 Of' City of Carlsbad Bond Proceeds Investment Report September 30, 2011 Fund Type Assessment District 03-01 Project Fund Redemption Fund Investments (College/Cannon) LAIF LAIF Re-Assessment District 97-01 (Alga Road & College Blvd) Imprvmnt Fund - Alga AIM STIT Treasury Assessment District 95-01 Reserve Fund Assessment District 96-01 Reserve Fund Assessment District 02-01 Improvement Fund Redemption Fund EFJPA Reserve Fund (Carlsbad Ranch) Repub Natl Bank Repo Agreement (HSBC) (Rancho Carrillo) Repub Natl Bank Repo Agreement (HSBC) (Poinsettia Lane) AIM LAIF AIG Investment Agreement Communities Facilities District #3 Improvement Area 1 Project Fund AIM STIT Treasury Reserve Fund BNY Hamilton Money Market Other BNY Hamilton Money Market Communities Facilities District #3 Improvement Area 2 Project Fund LAIF Reserve Fund BNY Hamilton Money Market Other LAIF/BNY CPFA Golf Course Bonds Reserve Fund Other BNY Hamilton Money Market BNY Hamilton Money Market Stated Int. Rate 0.39% 0.39% N/A 5.83% 6.03% N/A 0.39% 5.36% N/A various various 0.39% various various various various Maturity Date N/A N/A N/A N/A 09/02/28 N/A N/A 08/01/14 N/A 09/01/36 N/A N/A 09/01/38 N/A N/A N/A Par Value $ 924,955 $ $ 1,198,121 $ $ 277,966 $ $ 1 ,004,294 $ $ 1,292,770 $ $ 4,445,677 $ $ 2,493,607 $ $ 953,706 $ $ 1,927,686 $ $ 777,965 $ $ - $ $ 12,909 $ $ 1,068,180 $ $ 86,558 $ $ 1,271,499 $ $ - $ $ 17,735,893 $ Cost Fiscal Agent: 924,955 1,198,121 Fiscal Agent: 277,966 Fiscal Agent: 1,004,294 Fiscal Agent: 1,292,770 Fiscal Agent: 4,445,677 2,493,607 Fiscal Agent: 953,706 Fiscal Agent: 1,927,686 777,965 Fiscal Agent: 12,909 1,068,180 86,558 Fiscal Agent: 1,271,499 17,735,893 Source BNY Western Trust LAIF LAIF US Bank AIM Instit. Fund Services BNY Western Trust HSBC Bank of New York BNY Western Trust HSBC Bank of New York BNY Western Trust AIM Instit. Fund Services LAIF BNY Western Trust GIC BNY Western Trust AIM Instit. Fund Services BNY Western Trust BNY Western Trust BNY Western Trust LAIF BNY Western Trust LAIF/BNY BNY Western Trust BNY Western Trust BNY Western Trust M Xffi Hw H H:\Long Term Debt\Quarterly Investment Reports\Qtr Inv Rpt.xlsx City of Carlsbad Summary of Outstanding Housing Loans As of September 30, 2011 Updated on: 10/11/2011 Loans issued by City to Loans issued by Loan amount due Developer loan amount Borrower Individual homebuyers Individual homebuyers Individual homebuyers Individual homebuyers Individual homebuyers Individual homebuyers Catholic Charities Development City-wide (CHAP) Calavera Hills Purpose Sale Sale Cherry Tree Walk Sale Serrano Rancho Carlsbad Solamar Homeless shelter CB Laurel Tree Apartmen Laurel Tree CB Housing Partnership Pacific Vista Las Flores Rancho Carrillo Vista Las Flores Sale Sale Sale Shelter Rentals Rentals Rentals Poinsettia Housing Assoc Poinsettia Station Rentals Bridge Housing Corp Dove Family Housing CIC Calavera LP Individual homebuyers Individual homebuyers Villa Loma La Costa Paloma Mariposa Apts Mulberry at Bressi Ranch Village by the Sea El Camino Family Housim Cassia Heights Individual homebuyers Individual homebuyers Habitat for Humanity CIC La Costa Down Payment & Closing Cost Assistance CIC Glen Ridge, LP Laguna Point The Bluffs Roosevelt St. Condos Hunter's Point Various Glen Ridge Rentals Rentals Rentals Sale Sale Rentals Sale Sale Sale Rentals Assistance Rentals First date issued 06/28/99 10/15/99 06/28/99 05/25/01 05/20/99 09/26/88 09/19/97 12/24/98 03/05/01 02/27/01 10/21/99 11/04/94 07/15/03 09/15/04 04/29/05 10/28/05 03/07/06 07/06/06 06/14/07 08/30/07 08/19/08 06/25/09 10/05/09 # of loans issued 133 5 42 90 22 9 1 2 1 1 1 2 1 1 100 11 1 3 8 1 1 11 1 developers/ homeowners $1,680,000 $ 75,000 453,600 1,350,000 752,533 147,726 200,000 1,134,000 1,157,584 363,948 920,000 2,212,000 2,070,000 1 ,060,000 1,840,000 220,000 1 ,454,276 210,000 200,000 797,539 1 ,932,000 143,600 1,014,000 Developer to # of loans City loan repaid to Developer loan homeowners outstanding City repaid to City 34 ($1,413,233) $ 150,000 1 (60,000) (120,000) 452,600 14 (302,400) (283,250) 4,050,000 33 (870,133) (2,610,000) 10 (404,370) 1 (135,065) 1 2 (408,778) 1 1 1 (21,837) 0 (2,212,000) 1 (1,220,188) 1 19,660,200 100 4,087,200 7 1 3 8 1 1 11 1 to City (recorded as AR) $266,767.02 $ 15,000 151,200 479.867 348,163 12,661 200,000 725,222 1,157,584 363,948 898,163 - 849,812 1,060,000 1,840,000 220,000 1,454,276 210,000 200.000 797,539 1,932,000 143,600 1,014,000 due to City (not on City's books) 266,767 30.000 45,000 169,350 320,550 1,440,000 1,919,867 348,163 12,661 200,000 725,222 1,157,584 363,948 898,163 - 849,812 1,060,000 19,660,200 21,500,200 4,087,200 4,307,200 1,454,276 210,000 200,000 797,539 1 .932,000 143.600 1,014,000 Type of Loan Payment deferred 15 years. No interest is ^ due unless home is sold before 16th year Payment deferred 30 years. No interest is due unless home is sold before 31th year Payment deferred 30 years. No interest is due unless home is sold before 31th year Payment deferred 30 years. No interest is due unless home is sold before 31th year Principal is due when home is sold Principal is due when home is sold Principal is due when property is sold Principal and 3% interest each year for 30 years when surplus cash is available Principal and 3% interest each year for 55 years when surplus cash is available Principal and 3% interest each year for 55 years when surplus cash is available Principal and 3% interest each year for 55 years when surplus cash is available Principal and 3% interest each year for 1 5 years when surplus cash is available Principal and 3% interest each year for 55 years when surplus cash is available Principal and 3% interest each year for 55 years when surplus cash is available Payment deferred 30 years. No interest is due unless home is sold before 31th year Payment deferred 30 years. No interest is due unless home is sold before 31th year Principal and 3% interest each year for 55 years when surplus cash is available Payment deferred 45 years. No interest is due unless home is sold before 46th year Payment deferred 30 years. No interest is due unless home is sold before 31th year Refer to Agenda Bill 18, 569 / Resolution 2006-131 & AB 19,183 / R2007-255 Refer to AB1 8,251 / Resolution 2005-264 Refer to Agenda Bill 19,415 / Resolution 2008-121 Refer to Agenda Bill 397 / Resolution 435 K 448 $ 21,387,806 S 28,400,000 234 $ (7.048,004) $ (3.013.250) $ 14.339.802 $ 25.386.750 $ 39,726.552 During the 1st quarter of FY2011-12, approximately $15,729 in CHAP loan payments was received; a $30,541 loan pay-off related to the Rancho Carlsbad development was received; and one DPCCA loan of $13,250 was issued. U to