Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2010-02-16; City Council; 20114; City Investments as of December 31, 2009
CITY OF CARLSBAD - AGENDA BILL AB# 20,114 MTG. 2/16/10 DEPT. TRS REPORT ON CITY INVESTMENTS AS OF DECEMBER 31, 2009 DEPT. HEAD /^//^f CITY ATTY. " rfg>^ CITYMGR. IAS- - 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 December 31, 2009 is summarized below. Pooled Investment Portfolio (Cash and Securities) Par Value Cost of Investments Amortized Cost (1) Market Value (2) Current Month 542,826,438 550,942,312 547,841,174 555,525,181 Prior Month 532,270,584 539,991,457 537,091,922 548,043,541 (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 12/31/09. 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) Special Revenue $46.1 General Other „, . $62.2 Internal Service $27.1 $13 Agency Capital Projects $ 267.7 Enterprise SI25.6 Total Treasurer's Investment Portfolio at Amortized Cost December 31, 2009 $547.8 million FOR CITY CLERKS USE ONLY. COUNCIL ACTION: APPROVED X DENIED D CONTINUED D WITHDRAWN D AMENDED D CONTINUED TO DATE SPECIFIC CONTINUED TO DATE UNKNOWN RETURNED TO STAFF OTHER -SEE MINUTES D Dnn DEPARTMENT CONTACT: Nancy Sullivan (760) 602-2473 nsull@ci.carlsbad.ca.us PAGE 2 OF AB REPORT ON CITY INVESTMENTS AS OF DECEMBER 31. 2009 Pooled Investment Interest Income Cash Income Fiscal Year-to-Date * Current Month FYTD 9,716,433 Prior Month FYTD 8,549,552 Current Month Income 1,166,881 *The cash income received is adjusted for any accrued interest purchased. Pooled Investment Performance/Measurement October 2009 November 2009 December 2009 Average Life (Years) 1.62 1.62 1.61 Average Yield To Maturity 2.63% 2.58% 2.51% Modified Duration 1.537 1.539 1.528 All pooled investments have been made in accordance with the City's Investment Policy adopted January 2, 1985 and last revised April 21, 2009. 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 21,610,233 21,610,233 Prior Quarter 22,417,213 22,417,213 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 EXHIBITS FOR POOLED INVESTMENTS: (continued) 6. Second 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 DECEMBER 31, 2009 BREAKDOWN BY AMORTIZED COST, MARKET VALUE, CASH INCOME, AND AVERAGE YIELD BY CLASS Class CD FN CP TR FA CN LAIF CUSTODY SWEEP BANKACCT AMORTIZED Current Month 33,000 10,421,202 0 112,635,560 286,942,782 105,951,272 28,972,609 134,029 2,129,250 621,470 COST MARKET Prior Month Current Month 33,000 12,398,785 0 108,744,432 274,835,443 106,004,758 32,739,670 205 1,905,593 430,036 33,000 10,550,680 0 112,611,600 291,335,946 109,136,597 28,972,609 134,029 2,129,250 621,470 VALUE Prior Month 33,000 12,641,440 0 108,974,200 281,324,302 109,995,095 32,739,670 205 1,905,593 430,036 AVERAGE YIELD Cash Income Year to Date Current Month Prior Month 177 0.90 0.90 0 0 377,694 6,139,545 2,662,580 535,414 86 938 0 2.50 0.00 0.47 2.90 4.20 0.61 0.05 0.13 0.13 2.13 0.00 0.47 3.06 4.20 0.63 0.07 0.10 0.10 TOTALS $547,841,174 $537,091,923 $555,525,181 $548,043,542 $9,716,433 2.51%2.58% 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 xrni—i DO CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF DECEMBER 31, 2009 BREAKDOWN OF MA TURITIES B Y 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 997,329 0 44,701,433 41,135,170 7,120,941 28,972,609 134,029 2,129,250 621,470 $125,845,232 (1) 22.8% Year 7 MONTHS TO 1 YEAR 0 0 0 34,317,408 43,311,945 14,051,954 0 0 0 0 $91,681,307 (1) 16.6% $217,526,539 (1) 1 TO 5 YEARS 0 9,201,104 0 34,225,742 204,458,293 85,530,635 0 0 0 0 $333,415,773 60.5% TOTAL 33,000 10,198,433 0 113,244,583 288,905,408 106,703,530 28,972,609 134,029 2,129,250 621,470 $550,942,312 100.0% % TOTAL 0.0% 1.9% 0.0% 20.6% 52.4% 19.4% (2) 5.3% 0.0% 0.4% 0.1% 100.0% POLICY: 39.5% (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. x:ni—i CO INi YIELD COMPARISON PORTFOLIO EX-LAIF VS. LAIF JULY 1996 - DECEMBER 2009 MARKET YIELD CURVE 6/30/08,6/30/09, 12/31/09 Market Rates 3Mth 2Yr 5Yr 3Mth 2Yr 5Yr 10 Yr -—06/30/2008 -*- 06/30/2009 ^•12/31/2009 1.73 .18 .05 2.62 1.11 1.14 3.33 2.56 2.68 3.97 3.53 3.84 10 Yr X ^I—I CO Cumulative Cash Income FY09-10 Cumulative /TA , OAAA \Millions $ (December 2009 ) 20 18 16 14 12 10 8 6 4 2, n Monthly Interest Income Millions $ o ^ ^~~+" ^^ ^^ ^^ ^e^^ 1.99 ^^^ — i 1 i» * ^^s*"^A f* A A f* A *»Ojg>^ 1-61 1.6 1.38 ^- ^ 1 17^^ I . I ff u - 7 6 r 5 r 3 2 1 n Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Interest Income --^-Budget Actual Xrr:i—i DOt—l —I cn oO City of Carlsbad TRANSACTIONS FOR PERIOD: 10/01/09 TO 12/31/09 2ND QUARTER 2009-2010 Trans Investment Date BUYS OCTOBER 09/30/2009 09/30/2009 09/30/2009 09/30/2009 10/16/2009 10/16/2009 10/16/2009 10/16/2009 10/16/2009 10/19/2009 10/19/2009 10/19/2009 10/19/2009 10/19/2009 10/19/2009 10/27/2009 10/27/2009 NOVEMBER 11/05/2009 11/05/2009 11/03/2009 11/05/2009 11/05/2009 11/23/2009 11/23/2009 11/23/2009 11/23/2009 11/23/2009 11/23/2009 11/23/2009 11/24/2009 11/24/2009 11/24/2009 DECEMBER 12/04/2009 12/04/2009 12/04/2009 1 2/07/2009 12/07/2009 12/04/2009 12/10/2009 12/04/2009 Date 10/01/2009 10/01/2009 10/01/2009 10/13/2009 10/19/2009 10/19/2009 10/19/2009 10/19/2009 10/19/2009 10/20/2009 10/20/2009 10/20/2009 10/20/2009 10/20/2009 10/27/2009 10/28/2009 10/28/2009 11/05/2009 11/06/2009 11/17/2009 11/17/2009 11/25/2009 11/24/2009 11/24/2009 11/24/2009 11/24/2009 11/24/2009 11/24/2009 11/24/2009 11/25/2009 11/25/2009 11/25/2009 12/07/2009 12/07/2009 12/07/2009 12/08/2009 12/08/2009 12/09/2009 12/14/2009 12/24/2009 Maturity Date 01/31/2011 08/05/2011 09/24/2012 10/13/2010 01/31/2011 05/23/2012 07/19/2012 10/21/2013 02/28/201 1 06/18/2012 02/07/2013 05/22/2013 06/12/2013 06/30/2014 07/27/2012 05/31/2011 06/30/2011 07/30/2014 06/29/2012 05/17/2013 08/17/2012 02/25/2013 09/23/2010 05/20/2010 08/26/2010 10/31/2010 11/30/2010 06/30/201 1 08/31/2011 03/15/2013 06/21/2012 09/24/2012 10/29/2012 08/26/2014 11/15/2011 11/15/2011 10/03/2011 12/09/2011 12/14/2012 06/24/2013 Type TR FA FA FA TR FA FA FA TR FA FA FA FA FA FA TR TR FA FA FA FA FA TR TR TR TR TR TR TR FA FA FA FA FA FA FA FA FA FA FA Security US TREASURY FHLB FFCB FHLB US TREASURY TVA FFCB FFCB US TREASURY FFCB FFCB FHLMC FHLMC FFCB FNMA US TREASURY US TREASURY FNMA FHLMC FHLB FHLB FHLB US TREASURY DISCOUI US TREASURY DISCOUi US TREASURY DISCOUI US TREASURY US TREASURY US TREASURY US TREASURY FHLB FFCB FFCB FNMA FHLMC FHLB FHLB FFCB FFCB FHLB FNMA Call Date N/A N/A N/A 04/13/10 N/A N/A 10/19/2010 N/A N/A N/A N/A N/A N/A N/A 10/27/2010 N/A N/A 07/30/2010 06/29/2010 02/17/2010 08/17/2010 08/25/2010 N/A N/A N/A N/A N/A N/A N/A 09/15/2010 N/A N/A 10/29/2010 08/26/2014 N/A N/A N/A N/A 12/14/2011 12/24/2010 Par Value 3,000,000.00 1,000,000.00 1,000,000.00 2,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 2,000,000.00 3,000,000.00 3,000,000.00 1,000,000.00 500,000.00 500,000.00 3,000,000.00 1,000,000.00 3,000,000.00 3,000,000.00 1,100,000.00 1 ,000,000.00 2,000,000.00 2,000,000.00 1,000,000.00 2,000,000.00 3,000,000.00 4,000,000.00 2,000,000.00 3,000,000.00 4,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 1,000,000.00 2,000,000.00 3,000,000.00 1 ,000,000.00 1,000,000.00 1,000,000.00 Coupon 0.875% 1.375% 1 .800% .35% STEP 0.875% 6.790% 1 .550% 5.350% 0.875% 2.125% 5.150% 4.250% 4.000% 4.375% 1 .700% 0.875% 1.125% 3.300% 2.450% 1.125%STEP 1 .750% 2.000% 0.000% 0.000% 0.000% 1 .500% 1 .250% 1.125% 1 .000% 2.350% 5.450% 1 .800% 1 .875% 2.25% STEP 4.250% 4.250% 1.125% 0.875% 1%STEP 2.125% Amount (Cost) 3,014,531.25 1,006,100.00 1,003,470.00 2,000,000.00 3,012,656.25 3,399,498.48 2,995,200.00 2,235,072.36 3,011,718.75 3,049,023.21 1,102,490.00 536,967.86 532,794.50 3,234,480.00 998,800.00 3,008,320.31 3,018,398.44 1,110,340.00 1,011,600.00 2,000,000.00 2,000,000.00 999,531.25 1,996,801.67 2,998,156.25 3,994,500.00 2,023,125.00 3,029,179.69 4,037,343.75 5,031,445.31 1,009,500.00 2,210,347.28 3,032,750.01 1,003,900.00 3,009,000.00 1,061,850.00 2,126,060.00 3,014,854.10 997,136.00 999,500.00 1 ,000,000.00 Return Rate 0.509% 1 .040% 1 .680% 0.550% 0.544% 1 .534% 1.610% 2.264% 0.587% 1 .496% 1 .926% 2.100% 2.120% 2.595% 1 .745% 0.699% 0.755% 3.084% 1 .997% 3.297% 1 .750% 2.015% 0.193% 0.127% 0.183% 0.259% 0.291% 0.538% 0.641% 2.051% 1 .280% 1 .405% 1 .736% 4.220% 1 .020% 0.956% 0.850% 1.020% 1 .673% 2.125% Interest 20,421.20 19,261.11 50,180.00 11,000.00 21,012.23 128,989.85 132,675.00 193,522.08 24,103.07 120,622.62 67,316.94 39,296.03 40,094.39 381,665.83 47,950.00 10,758.20 1 1 ,005.43 161,580.83 53,256.94 235,000.00 96,250.00 65,468.75 3,198.33 1,843.75 5,500.00 4,886.05 8,935.06 34,680.71 56,814.36 68,180.56 70,024.94 120,099.99 50,370.83 609,562.50 20,552.78 38,509.44 6,562.50 20,364.00 50,500.00 74,375.00 Investment Return 3,034,952.45 1,025,361.11 1 ,053,650.00 2,011,000.00 3,033,668.48 3,528,488.33 3,127,875.00 2,428,594.44 3,035,821.82 3,169,645.83 1,169,806.94 576,263.89 572,888.89 3,616,145.83 1,046,750.00 3,019,078.51 3,029,403.87 1,271,920.83 1,064,856.94 2,235,000.00 2,096,250.00 1,065,000.00 2,000,000.00 3,000,000.00 4,000,000.00 2,028,011.05 3,038,114.75 4,072,024.46 5,088,259.67 1,077,680.56 2,280,372.22 3,152,850.00 1,054,270.83 £n 3,618,562.50 ^ 1,082,402.78 5 2,164,569.44 !H 3,021,416.60 ch 1,017,500.00 1,050,000.00 1,074,375.00 City of Carlsbad TRANSACTIONS FOR PERIOD: 10/01/09 TO 12/31/09 2ND QUARTER 2009-2010 Trans Date 12/17/2009 12/10/2009 12/23/2009 12/23/2009 12/23/2009 12/23/2009 12/23/2009 12/22/2009 12/24/2009 12/29/2009 12/29/2009 12/29/2009 Investment Date 12/18/2009 12/30/2009 12/24/2009 12/24/2009 12/24/2009 12/24/2009 12/24/2009 12/29/2009 12/28/2009 12/30/2009 12/30/2009 12/30/2009 Maturity Date 08/26/2014 12/30/2014 09/28/2012 08/15/2012 08/02/2012 06/24/2010 09/23/2010 06/29/2012 06/28/2013 03/31/2011 11/23/2011 07/18/2011 Type FA FA FA FA FA TR TR FA FA TR FA FA Security FHLMC FNMA FHLMC FHLB FNMA US TREASURY US TREASURY FHLB FHLB US TREASURY FNMA FHLMC Call Date 02/26/2010 06/30/2010 09/28/2010 N/A N/A N/A N/A 03/29/2010 N/A N/A N/A N/A TOTAL SECOND QUARTER 2009-2010 Par Value 1,000,000.00 2,000,000.00 3,000,000.00 1,000,000.00 1,037,000.00 6,000,000.00 5,000,000.00 3,000,000.00 2,000,000.00 4,000,000.00 3,000,000.00 1,737,000.00 117,874,000.00 Coupon 2.25% STEP 2.3% STEP 2.000% 4.625% 5.000% 0.000% 0.000% 1 .450% 1 .850% 0.875% 1 .000% 5.250% Amount (Cost) 1,002,800.00 2,000,000.00 3,014,100.00 1,078,810.00 1,127,519.73 5,995,298.33 4,990,520.83 2,997,750.00 1,987,226.45 4,010,625.00 2,994,090.00 1,853,035.07 119,908,217.13 Return Rate 4.240% 3.150% 1 .824% 1 .567% 1 .567% 0.157% 0.254% 1.481% 2.040% 0.610% 1.105% 0.900% 1 .208% Interest 202,700.00 315,000.00 151,566.67 43,367.08 44,578.33 4,701.67 9,479.17 111,000.00 160,773.55 33,125.00 62,826.67 25,313.30 4,340,822.74 Investment Return 1,205,500.00 2,315,000.00 3,165,666.67 1,122,177.08 1,172,098.06 6,000,000.00 5,000,000.00 3,108,750.00 2,148,000.00 4,043,750.00 3,056,916.67 1,878,348.37 124,249,039.87 MATURITIES OCTOBER 11/01/2007 03/19/2007 03/05/2008 01/22/2008 10/23/2008 06/18/2009 06/18/2009 06/05/2009 NOVEMBER 03/06/2008 01/28/2008 01/31/2008 01/22/2008 01/22/2008 05/11/2009 06/05/2009 06/18/2009 06/01/2009 06/18/2009 DECEMBER 06/01/2009 01/22/2008 05/11/2009 06/15/2009 06/18/2009 10/27/2009 10/02/2009 10/23/2009 10/28/2009 10/01/2009 10/15/2009 10/22/2009 10/29/2009 11/06/2009 11/13/2009 11/13/2009 11/16/2009 11/18/2009 11/19/2009 11/19/2009 11/19/2009 11/27/2009 11/27/2009 12/02/2009 12/11/2009 12/17/2009 12/17/2009 12/17/2009 CN FA FA FA FN TR TR TR FA FA FA FA FA TR TR TR TR TR FN FA TR TR TR GENERAL ELECTRIC FHLB FFCB FNMA FHLBN US TREASURY US TREASURY US TREASURY FFCB FFCB FHLB FNMA FHLMC US TREASURY US TREASURY US TREASURY US TREASURY US TREASURY FHLBN FHLMC US TREASURY US TREASURY US TREASURY N/A NA NA NA NA NA NA NA 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 2,000,000. 3,000,000 2,000,000 500,000. .00 .00 .00 .00 3,000,000.00 5,000,000. 4,000,000 3,000,000 1,000,000 2,000,000 1,000,000 2,000,000 2,080,000 2,000,000 3,000,000 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 5,000,000.00 2,000,000 4,000,000 2,000,000 3,000,000 2,000,000 4,000,000 5,000,000 .00 .00 .00 .00 .00 .00 .00 5.250% 5.00% 5.00% 4.00% 0.00% 0.00% 0.00% 0.00% 4.350% 4.125% 4.250% 4.000% 4.125% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 5.00% 0.00% 0.00% 0.00% 2,030,120.00 3,014,820.00 2,090,620.00 508,645.00 2,914,250.00 4,997,190.28 3,997,480.00 2,997,810.00 1,031,080.00 2,049,060.00 1,024,930.00 2,038,020.00 2,124,168.80 1,996,693.33 2,996,799.17 4,994,866.67 1,997,315.00 3,995,860.00 1,997,240.00 3,114,720.00 1,995,905.56 3,994,540.00 4,992,669.44 4.450% 4.790% 2.160% 2.986% 3.109% 0.172% 0.183% 0.183% 2.43% 2.71% 2.81% 2.92% 2.92% 0.32% 0.23% 0.24% 0.27% 0.23% 0.27% 2.900% 0.340% 0.274% 0.294% 178,713.33 365,596.67 72,713.33 26,688.33 171,500.00 2,809.72 2,520.00 2,190.00 - 41,420.00 98,752.50 50,861.67 107,313.33 112,177.87 3,306.67 3,200.83 5,133.33 2,685.00 4,140.00 168,196.67 4,094.44 5,460.00 7,330.56 2,208,833.33 3,380,416.67 2,163,333.33 535,333.33 3,085,750.00 5,000,000.00 4,000,000.00 3,000,000.00 1,072,500.00 2,147,812.50 1,075,791.67 2,145,333.33 2,236,346.67 2,000,000.00 3,000,000.00 5,000,000.00 2,000,000.00 4,000,000.00 2,000,000.00 3,282,916.67 2,000,000.00 4,000,000.00 5,000,000.00 TOTAL SECOND QUARTER 2009-2010 62,580,000.00 62,894,803.25 1.28%1,436,804.25 64,334,367.50 o City of Carlsbad TRANSACTIONS FOR PERIOD: 10/01/09 TO 12/31/09 Trans investment Maturity Date Date Date Type CALLS and / or SALES OCTOBER 10/05/2007 10/29/2007 10/19/2007 03/05/2008 07/29/2009 11/28/2007 12/06/2007 NOVEMBER 08/13/2009 09/21/2009 11/20/2007 01/28/2008 08/27/2009 08/27/2009 07/22/2009 DECEMBER 12/21/2007 12/21/2007 06/22/2009 09/28/2009 12/30/2008 TOTAL SECOND QUARTER 2009-2010 2ND QUARTER 2009-2010 10/05/2011 10/15/2012 10/19/2011 10/27/2011 07/29/201 1 10/30/2012 10/30/2012 08/13/2012 08/17/2011 05/20/201 1 05/20/201 1 08/27/2014 02/27/2013 05/25/2012 12/21/2012 12/21/2012 06/22/2012 09/28/2012 12/30/2010 FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FA FHLB FHLMC FHLB FHLB FHLB FNMA FNMA FHLMC FHLMC FHLB FHLB FHLB FHLB FHLB FHLMC FHLMC FHLB FHLB FHLB Call Date 10/05/2009 10/15/2009 10/19/2009 10/27/2009 10/29/2009 10/30/2009 10/30/2009 11/13/2009 11/17/2009 11/20/2009 11/20/2009 11/27/2009 11/27/2009 11/27/2009 12/21/2009 12/21/2009 12/22/2009 12/28/2009 12/30/2009 Par Value 2,000,000.00 1,000,000.00 3,000,000.00 2,000,000.00 5,000,000.00 3,000,000.00 2,000,000.00 1,000,000.00 1,000,000.00 2,000,000.00 3,000,000.00 3,000,000.00 2,000,000.00 1,000,000.00 5,000,000.00 4,000,000.00 3,000,000.00 3,000,000.00 1,000,000.00 Coupon 4.900% 5.050% 5.000% 5.300% 0.500% 5.000% 5.000% 2.250% 1 .500% 4.500% 4.500% 3% STEP 2% STEP 1 .900% 4.375% STEP 4.375 STEP 1.5% STEP 1 .0% STEP 1 .700% Amount (Cost) 2,000,000.00 1,006,875.00 3,000,000.00 2,085,000.00 5,000,000.00 3,033,000.00 2,030,000.00 1,000,000.00 1,001,300.00 2,016,000.00 3,078,630.00 3,000,000.00 1,999,500.00 999,250.00 5,000,000.00 4,000,000.00 3,000,000.00 3,000,000.00 1,000,000.00 Return Rate 4.90% 4.89% 5.00% 4.03% 1.71% 4.75% 4.65% 2.25% 1 .43% 4.25% 3.65% 3.95% 2.95% 1 .93% 4.675% 4.675% 2.239% 2.357% 1 .700% Interest 392,000.00 243,661.11 600,000.00 301,311.11 171,875.00 705,333.33 460,000.00 67,500.00 27,283.33 299,000.00 368,370.00 600,000.00 208,000.00 54,741.66 56,687,750.00 935,000.00 202,500.00 213,750.00 34,000.00 Investment Return 2,392,000.00 1,250,536.11 3,600,000.00 2,386,311.11 5,171,875.00 3,738,333.33 2,490,000.00 1,067,500.00 1,028,583.33 2,315,000.00 3,447,000.00 3,600,000.00 2,207,500.00 1,053,991.66 61,687,750.00 4,935,000.00 3,202,500.00 3,213,750.00 1,034,000.00 47,000,000.00 47,249,555.00 3.62% 62,572,075.54 109,821,630.54 INVESTMENT REPORT AS OF DECEMBER 31, 2009 INVESTMENT DATE 02/01/2008 01/28/2008 01/31/2008 09/29/2008 01/28/2008 02/04/2008 02/13/2008 04/02/2008 10/30/2008 04/22/2008 01/28/2008 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 10/13/2009 06/01/2009 05/05/2008 04/22/2009 06/03/2009 06/01/2009 06/03/2009 12/05/2008 02/20/2008 06/03/2009 05/11/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 FHLMC 3.25% CALL 7/29/08 FHLB 3.875% NON-CALL FHLB 37.375% NON-CALL FHLMC 3.125% NON-CALL FNMA4.40% NON-CALL FHLB 2.375% NON-CALL FHLB 2.375% NON-CALL FHLB 2.750% NON-CALL FHLB 2.750% NON-CALL FFCB 2.375% NON-CALL FHLMC 4.02% NON-CALL 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 FHLMC 3.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 .35% CALL 4/13/10 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 FNMA 2.050% CALL 4/1/10 FHLB 1.375% NON-CALL PAR VALUE 3,000,000.00 1,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 3,000,000.00 2,000,000.00 1,500,000.00 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,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 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 2,000,000.00 1,000,000.00 INVESTED AMOUNT 3,000,000.00 1,020,550.00 2,177,668.00 2,997,750.00 2,064,240.00 1,989,880.00 1,994,095.84 1,006,020.00 2,978,060.95 1,984,800.00 1,537,935.00 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,000,000.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 2,024,200.00 1,001,350.00 RETURN RATE 3.250% 2.830% 2.841% 3.180% 2.821% 2.622% 2.520% 2.430% 3.300% 2.776% 2.850% 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.550% 0.700% 2.980% 1.125% 0.701% 0.750% 0.800% 2.470% 2.950% 1 .377% 1 .305% INTEREST 194,458.33 58,456.94 122,248.67 130,635.42 121,537.78 110,133.89 104,730.55 47,452.22 134,689.05 108,220.83 97,740.00 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 11,000.00 19,276.11 74,901.88 50,625.00 20,104.72 21,906.67 23,270.00 154,245.00 270,402.49 50,738.89 25,653.47 INVESTMENT RETURN 3,194,458.33 1,079,006.94 2,299,916.67 3,128,385.42 2,185,777.78 2,100,013.89 2,098,826.39 1,053,472.22 3,112,750.00 2,093,020.83 1,635,675.00 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,011,000.00 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 2,074,938.89 1,027,003.47 TERM (Days) 728 746 743 501 770 767 758 709 498 715 821 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 365 500 900 548 506 532 530 741 1,115 667 717 x^i—i CO INVESTMENT REPORT AS OF DECEMBER 31, 2009 INVESTMENT DATE TYPE SECURITY 05/12/2009 FA FNMA 1.45% CALL 06/22/2009 FA FHLB 1.125% NON-CALL 08/31/2007 FA FHLB 5.275% NON-CALL 05/08/2008 FA FHLB 5.25% NON-CALL 09/17/2008 FA FHLB 5.25% NON-CALL 03/09/2007 FA FNMA 3.64% NON-CALL 08/01/2007 FA FAMCA 5.50% NON-CALL 08/31/2007 FA FAMCA 5.50% NON-CALL 05/08/2008 FA FAMCA 5.5% NON-CALL 03/31/2009 FA FFCB 3.625% NON-CALL 05/11/2009 FA FAMCA 5.50% NON-CALL 12/30/2009 FA FHLMC 5.25% NON-CALL 04/27/2009 FA FHLMC 1.75% CALL 4/27/10 06/29/2009 FA FHLB 1.625% NON-CALL 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 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 03/26/2007 FA FHLMC 5.0% CALL 3/26/10 03/26/2007 FA FHLMC 5.0% CALL 3/26/10 04/20/2007 FA FHLMC 5.0% CALL 3/26/10 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 12/29/2009 FA FHLMC 1.45% CALL 3/29/10 10/19/2009 FA FFCB 1.55% CALL 10/19/10 12/10/2007 FA FHLB 5.58% CALL 7/20/10 PAR VALUE 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 3,000,000.00 2,000,000.00 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 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 3,000,000.00 1,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 3,000,000.00 3,000,000.00 1,000,000.00 INVESTED AMOUNT 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 3,000,000.00 2,012,680.00 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 1,061,850.00 2,126,060.00 3,009,690.00 2,994,090.00 997,136.00 4,036,800.00 2,000,000.00 3,000,000.00 999,687.50 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,997,750.00 2,995,200.00 1,037,000.00 RETURN RATE 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 .750% 1.315% 1 .375% 4.800% 1.818% 1 .490% 4.773% 4.730% 1 .958% 4.390% 0.850% 4.720% 1 .020% 0.956% 4.795% 1.105% 1 .020% 1 .630% 5.000% 5.000% 5.006% 5.015% 2.047% 5.235% 1 .534% 5.255% 5.250% 3.900% 1 .496% 1.280% 1.997% 1.481% 1.610% 4.677% INTEREST 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 118,125.00 54,847.78 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 20,552.78 38,509.44 672,403.75 62,826.67 20,364.00 167,200.00 500,000.00 750,000.00 246,979.17 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 111,000.00 132,675.00 220,300.00 INVESTMENT RETURN 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 3,118,125.00 2,067,527.78 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 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,500,000.00 3,750,000.00 1,246,666.67 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 3,108,750.00 3,127,875.00 1,257,300.00 TERM (Days) 730 711 1,379 1,128 996 1,588 1,444 1,414 1,163 836 795 565 821 758 673 1,610 934 794 1,649 1,639 959 1,416 664 1,665 708 707 1,705 693 730 932 1,827 1,827 1,802 1,788 1,004 1,764 947 1,780 1,780 1,424 972 939 966 913 1,004 1,684 INVESTMENT REPORT AS OF DECEMBER 31, 2009 INVESTMENT DATE TYPE SECURITY 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 07/21/2009 FA FHLB 2.0% CALL 2/10/10 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 09/04/2009 FA FNMA 2.50% CALL 9/7/10 03/12/2009 FA FHLMC 2.0% CALL 3/12/10 05/05/2008 FA FHLB 5.00% NON-CALL 08/22/2008 FA FHLB 4.5% 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 10/22/2007 FA FHLB 5.00% CALL 4/22/10 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/23/2008 FA FHLB 4.7% CALL 1/7/10 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 05/19/2009 FA FNMA 2.32% CALL 2/19/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 11/17/2009 FA FHLB 1.125% CALL 2/17/10 QRTLY 10/20/2009 FA FHLMC 4.25% NON-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 08/19/2009 FA FFCB 2.7% NON-CALL 11/12/2008 FA FHLB 4.0% NON-CALL PAR VALUE 2,000,000.00 2,000,000.00 1,000,000.00 1,770,000.00 1,037,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 2,000,000.00 2,000,000.00 1,175,000.00 1,000,000.00 1,000,000.00 3,000,000.00 3,000,000.00 1,000,000.00 2,000,000.00 2,000,000.00 1,000,000.00 1,807,000.00 2,000,000.00 1,000,000.00 2,000,000.00 3,000,000.00 1,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 2,000,000.00 500,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 1,000,000.00 1,000,000.00 INVESTED AMOUNT 2,002,900.00 1,988,600.00 998,800.00 1,770,000.00 1,127,519.73 1,999,500.00 1,999,500.00 2,150,960.00 1,078,810.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 1,238,814.19 1,022,730.00 1,003,470.00 3,032,750.01 3,014,100.00 1,063,510.00 2,034,780.00 2,000,000.00 1,003,900.00 1,990,388.82 2,000,000.00 999,500.00 2,056,800.00 3,000,000.00 1,102,490.00 999,531.25 1,000,000.00 2,963,940.00 1,009,500.00 2,008,000.00 2,000,000.00 2,000,000.00 536,967.86 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 1,005,669.88 1,007,890.00 RETURN RATE 3.910% 2.200% 1 .745% 5.520% 1.567% 2.090% 4.357% 2.391% 1.567% 1 .750% 2.625% 2.500% 2.710% 3.640% 3.889% 1 .680% 1 .405% 1.824% 1.928% 4.100% 5.000% 1 .736% 3.890% 2.200% 1 .673% 4.061% 4.250% 1 .926% 2.015% 2.320% 3.765% 2.051% 2.384% 4.000% 3.297% 2.100% 2.120% 3.800% 2.450% 2.125% 2.040% 3983% 3.970% 2.518% 2.550% 3.818% INTEREST 310,466.67 129,733.33 47,950.00 488,520.00 44,578.33 120,500.00 348,500.00 176,901.11 43,367.08 96,250.00 183,750.00 150,416.67 190,000.00 192,237.89 160,020.00 50,180.00 120,099.99 151,566.67 67,701.81 401,970.00 500,000.00 50,370.83 331,405.40 154,000.00 50,500.00 409,022.22 637,500.00 67,316.94 65,468.75 87,000.00 560,476.67 68,180.56 172,833.33 320,000.00 235,000.00 39,296.03 40,094.39 181,163.02 195,081.41 74,375.00 142,273.55 371,823.06 392,177.78 197,066.67 102,330.12 184,776.67 INVESTMENT RETURN 2,313,366.67 2,118,333.33 1,046,750.00 2,258,520.00 1,172,098.06 2,120,000.00 2,348,000.00 2,327,861.11 1,122,177.08 2,096,250.00 2,183,750.00 2,150,416.67 2,190,000.00 1,431,052.08 1,182,750.00 1,053,650.00 3,152,850.00 3,165,666.67 1,131,211.81 2,436,750.00 2,500,000.00 1,054,270.83 2,321,794.22 2,154,000.00 1,050,000.00 2,465,822.22 3,637,500.00 1,169,806.94 1,065,000.00 1,087,000.00 3,524,416.67 1,077,680.56 2,180,833.33 2,320,000.00 2,235,000.00 576,263.89 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 1,108,000.00 1,192,666.67 TERM (Days) 1,448 1,080 1,004 1,827 952 1,116 1,461 1,294 965 1,004 1,277 1,099 1,280 1,593 1,484 1,089 1,034 1,009 1,238 1,773 1,827 1,057 1,624 1,280 1,096 1,811 1,827 1,206 1,188 1,372 1,824 1,206 1,321 1,826 1,277 1,310 1,331 1,677 1,401 1,278 1,278 1,678 1,785 1,432 1,461 1,759 INVESTMENT REPORT AS OF DECEMBER 31, 2009 INVESTMENT DATE 12/17/2008 10/19/2009 11/26/2008 01/20/2009 02/12/2009 05/14/2009 10/20/2009 11/05/2009 12/07/2009 12/18/2009 09/24/2009 12/30/2009 06/01/2009 03/12/2009 02/11/2009 02/18/2009 02/25/2009 03/02/2009 03/02/2009 06/05/2009 07/22/2009 06/05/2009 05/11/2009 07/22/2009 06/05/2009 04/30/2009 06/05/2009 07/22/2009 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 TYPE 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 TR TR SECURITY FHLB 4.375% NON-CALL FFCB 5.350% NON-CALL FHLB 3.5% CALL 11/26/10 FHLB 3.125% NON-CALL FNMA2.00% CALL 2/12/10 FNMA 2.0% CALL 8/14/09 FFCB 4.375% NON-CALL FNMA 3.3% CALL 7/30/10 FHLMC 2.25% QRTLY CALL STEP FHLMC 2.25% QRTLY CALL STEP FNMA 2.0% CALL 9/23/1 1 STEP FNMA 2.3% QRTLY CALL STEP SUB-TOTAL FHLBN 0% NON-CALL FICOO.0% NON-CALL FICO STRIP 0.00% NON-CALL FiCO STRIP 0.00% NON-CALL FICO STRIP 0.00% NON-CALL FICOO.0% NON-CALL FICOO.0% NON-CALL SUB-TOTAL Federal Investments Total US TREASURY 2. 125% US TREASURY 2. 125% US TREASURY 6.50% US TREASURY 2.0% US TREASURY 2.0% US TREASURY 1.750% US TREASURY 00% US TREASURY 4.0% US TREASURY 2. 125% 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% 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 3,000,000.00 1,100,000.00 3,000,000.00 1,000,000.00 3,000,000.00 2,000,000.00 283,305,000.00 1,000,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 11,000,000.00 294,305,000.00 3,000,000.00 2,000,000.00 3,000,000.00 2,000,000.00 1,000,000.00 3,000,000.00 2,000,000.00 3,000,000.00 5,000,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 INVESTED AMOUNT 2,154,940.00 2,235,072.36 2,000,000.00 2,047,941.08 2,000,000.00 2,000,000.00 3,234,480.00 1,110,340.00 3,009,000.00 1,002,800.00 3,000,000.00 2,000,000.00 288,905,407.86 997,329.44 956,370.00 1,889,240.00 916,713.56 1,826,280.00 1,818,680.00 1,793,820.00 10,198,433.00 299,103,840.86 3,035,156.25 2,019,531.25 3,128,320.31 2,025,000.00 1,010,312.50 3,033,867.19 1,991,806.11 3,093,164.06 5,069,531.25 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 RETURN RATE 2.625% 2.264% 4.361% 2.600% 3.500% 2.000% 2.595% 3.084% 4.220% 4.240% 3.163% 3.150% 2.900% 0.386% 2.200% 2.300% 2.710% 2.850% 3.000% 3.050% 2.496% 0.331% 0.262% 0.342% 0.411% 0.303% 0.369% 0.437% 0.382% 0.325% 0.127% 0.452% 0.529% 0.157% 0.469% 0.282% 0.501% 0.317% 0.183% 0.193% INTEREST 259,712.78 193,522.08 440,000.00 258,135.31 355,000.00 320,000.00 381,665.83 161,580.83 609,562.50 202,700.00 479,833.33 315,000.00 29,507,819.66 2,670.56 43,630.00 110,760.00 83,286.44 173,720.00 181,320.00 206,180.00 801,567.00 30,309,386.66 28,593.75 2,775.38 7,425.55 7,173.91 1,861.41 9,165.60 8,193.89 10,114.63 12,754.76 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 INVESTMENT RETURN 2,414,652.78 2,428,594.44 2,440,000.00 2,306,076.39 2,355,000.00 2,320,000.00 3,616,145.83 1,271,920.83 3,618,562.50 1,205,500.00 3,479,833.33 2,315,000.00 318,413,227.52 1,000,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 11,000,000.00 329,413,227.52 3,063,750.00 2,022,306.63 3,135,745.86 2,032,173.91 1,012,173.91 3,043,032.79 2,000,000.00 3,103,278.69 5,082,286.01 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 TERM (Days) 1,731 1,463 1,826 1,788 1,826 1,826 1,714 1,728 1,723 1,712 1,825 1,826 1,157 253 744 908 1,178 1,171 1,166 1,314 962 2,119 240 193 255 293 221 299 343 314 282 177 344 405 182 390 287 421 318 275 303 INVESTMENT REPORT AS OF DECEMBER 31, 2009 INVESTMENT DATE 12/24/2009 07/22/2009 09/02/2009 11/24/2009 09/02/2009 11/24/2009 10/01/2009 10/19/2009 10/19/2009 12/30/2009 10/28/2009 09/24/2009 10/28/2009 11/24/2009 11/24/2009 11/10/2008 11/12/2008 03/02/2009 01/30/2008 01/31/2008 04/09/2008 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 TYPE TR TR 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 SECURITY US TREASURY 00% US TREASURY 2.00% US TREASURY 1.50% US TREASURY 1.50% US TREASURY 1.25% US TREASURY 1.25% 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 3.125% US TREASURY 3.125% SUB-TOTAL WELLS FARGO BANK 9218910637 SUB-TOTAL BERKSHIRHATWY 4.125% NON-CALL BERKSHIRHATWY4.125% NON-CALL WELLS FARGO CO 4.2% NON-CALL 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 PAR VALUE 5,000,000.00 3,000,000.00 5,000,000.00 2,000,000.00 5,000,000.00 3,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 5,000,000.00 1,000,000.00 1,000,000.00 112,000,000.00 33,000.00 33,000.00 2,000,000.00 2,000,000.00 1,000,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 INVESTED AMOUNT 4,990,520.83 3,052,031.25 5,062,500.00 2,023,125.00 5,048,828.13 3,029,179.69 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 5,031,445.31 1,031,328.00 1,030,781.25 113,244,583.08 33,000.00 33,000.00 2,040,548.16 2,038,582.81 1,018,383.81 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 RETURN RATE 0.254% 0.537% 0.419% 0.259% 0.461% 0.291% 0.509% 0.544% 0.587% 0.661% 0.699% 0.859% 0.755% 0.538% 0.641% 2.430% 2.452% 0.467% 0.900% 0.900% 3.050% 3.100% 3.120% 4.000% 3.300% 4.448% 2.750% 4900% 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% INTEREST 9,479.17 19,444.16 24,524.46 4,886.05 28,869.96 8,935.06 20,421.20 21,012.23 24,103.07 33,125.00 33,421.49 60,889.95 38,096.13 34,680.71 56,814.36 118,792.86 121,777.13 836,821.68 620.00 620.00 121,014.34 122,750.52 55,816.19 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 INVESTMENT RETURN 5,000,000.00 3,071,475.41 5,087,024.46 2,028,011.05 5,077,698.09 3,038,114.75 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 5,088,259.67 1,150,120.86 1,152,558.38 114,081,404.76 33,620.00 33,620.00 2,161,562.50 2,161,333.33 1,074,200.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 TERM (Days) 187 435 424 341 454 371 487 469 497 456 580 644 610 583 645 1,755 1,783 452 365 365 716 715 646 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 INVESTMENT REPORT AS OF DECEMBER 31, 2009 INVESTMENT DATE 05/29/2007 08/14/2009 04/28/2009 08/17/2009 03/20/2007 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 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 CN CN CN CN O O O O O O 0 O SECURITY 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 GENERAL ELETRIC 5.875% NON-CALL GENERAL ELETRIC 5.875% NON-CALL CHEVRON 3.450% NON-CALL BARCLAYS BANK 2.7% NON-CALL BERKSHIRHATWY 4.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 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 11/15/08 I-CALL :ALL ;ALL LL LL \LL CALL CALL ALL <l-CALL I-CALL I-CALL i% NON-CAL i% NON-CAL L _L ,LL ALL SUB-TOTAL T ACCOUNT 'RPORATION )RATION SUB-TOTAL PAR VALUE 1,850,000.00 2,000,000.00 2,000,000.00 2,250,000.00 5,956,000.00 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 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 104,631,080.00 620,767.00 2,129,249.93 703.42 134,028.52 10,605,000.00 6,847,038.82 7,700,000.00 3,820,570.40 31,857,358.09 INVESTED AMOUNT 1,850,000.00 2,066,260.00 2,060,840.00 2,427,570.00 6,187,688.40 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 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 106,703,529.59 620,767.00 2,129,249.93 703.42 134,028.52 10,605,000.00 6,847,038.82 7,700,000.00 3,820,570.40 31,857,358.09 RETURN RATE 5.500% 1.500% 1 .680% 1.800% 4.970% 5.100% 4.700% 2.180% 2.330% 3.200% 3.300% 4.500% 5.200% 4.550% 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.195% 0.130% 0.130% 0.000% 0.050% 0.610% 0.610% 0.610% 0.610% 0.566% INTEREST 453,918.06 69,073.33 89,458.61 99,695.62 1,483,867.09 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 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,937,463.31 2.21 7.58 - 0.19 179.70 116.02 130.47 64.74 500.91 INVESTMENT RETURN 2,303,918.06 2,135,333.33 2,150,298.61 2,527,265.62 7,671,555.49 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 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 124,640,992.90 620,769.21 2,129,257.51 703.42 134,028.71 10,605,179.70 6,847,154.84 7,700,130.47 3,820,635.14 31,857,859.00 TERM (Days) 1,631 824 955 857 1,793 1,588 1,553 1,026 1,035 1,090 1,088 1,447 1,750 1,477 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,343 1 1 1 1 1 1 1 1 GRAND TOTAL 542,826,438.09 550,942,311.62 2.508% 49,084,792.56 600,027,104.18 CITY OF CARLSBAD Fund Equity in Pooled Investments AS OF DECEMBER 31, 2009 EXHIBIT 8 Total Cash Balance by Fund: General Special Revenue Debt Service Capital Projects: General Capital Construction Traffic Impact Fees Public Facilities Fees Park Development Transnet Taxes Drainage Fees Special Districts Infrastructure Replacement Other Capital Construction Enterprise: Carlsbad Municipal Water District Sewer Fund Solid Waste Storm Water Golf Course Internal Service Agency Funds Redevelopment Funds (1) Misc. Special Funds Total General Ledger Balance ** Reconciling Adjustments (2) Total Treasurer's Investment Portfolio at Amortized Cost Total 65,411,542 16,024,851 43,445,427 2,319,792 5,940,722 7,961,846 73,072,740 53,643,525 (99,310) 67,224,877 49,405,508 7,033,118 1,725,538 233,792 62,213,137 46,075,221 6,690,145 267,721,136 125,622,833 27,105,703 12,983,759 0 0 548,411,935 (570,760) 547,841,174 (1) Redevelopment Fund Balances are interspersed throughout all funds. (2) 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 1/08/10 EXHIBIT 9 CITY OF CARLSBAD INVESTMENT PORTFOLIO As of December 31, 2009 CORPORA TE NOTE AND COMMERCIAL PAPER RA TINGS 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 AA2 AAA AA3 AAA AAA AA2 AA1 AA2 AAA AAA AA AA+ AAA AA- AAA AA- AA- AAA AA- AA AA BARCLAYS BANK BERKSHIRE HATHAWAY CHEVRON GENERAL ELECTRIC JOHNSONS 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. loodv'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,015,959 11,035,888 2,008,452 1,005,219 2,993,909 1,000,000 3,000,000 2,993,841 5,057,919 Market Value 2,134,940 11,346,020 2,046,500 1,018,020 3,113,040 1,020,970 2,924,760 3,074,190 5,178,700 CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF DECEMBER 31, 2009 WEIGHTINGS FOR CORPORATE AND FEDERAL AGENCY ISSUERS EXHIBIT 10 PERCENTAGE WEIGHTINGS BY CORPORATE NOTE ISSUER 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 PERCENTAGE WEIGHTINGS BY FEDERAL AGENCY ISSUER FAMCA FICO FEDERAL FARM CREDIT BANK FEDERAL HOME LOAN BANK DISCOUNT NOTE 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 1,590,861.34 8,164,870.82 3,103,177.11 11,022,079.70 25,459,584.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 5,157,732.51 ENCY ISSUER Investment Cost 6,868,83732 9,201,103.56 48,251,552.84 997,329.44 135,014,801.48 51,849,609.93 41,390,127.81 5,530,478.48 113,244,583.08 Percent of Portfolh 0.37% 0.29% 1 .48% 0.56% 2.00% 4.62% 0.37% 0.19% 0.54% 0.18% 0.73% 0.36% 0.18% 0.95% 0.54% 0.19% 0.38% 0.39% 1 .73% 0.54% 1 .83% 0.94% Percent of Portfolio** 1 .25% 1 .67% 8.76% 0.18% 24.51% 9.41% 7.51% 1.00% 20.55% $550,942,311.62 City of Carlsbad Bond Proceeds Investment Report December 31, 2009 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.61% 0.61% N/A 5.83% 6.03% N/A 0.61% 5.36% N/A various various 0.61% 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 951,359 1,187,202 277,714 895,254 1,292,770 4,601,558 2,470,880 953,706 1,925,933 771,242 24,492 12,759 1,068,189 3,938,850 1,238,325 21,610,233 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Cost Fiscal Agent: 951 ,359 1,187,202 Fiscal Agent: 277,714 Fiscal Agent: 895,254 Fiscal Agent: 1,292,770 Fiscal Agent: 4,601,558 2,470,880 Fiscal Agent: 953,706 Fiscal Agent: 1,925,933 771 ,242 24,492 Fiscal Agent: 12,759 1,068,189 3,938,850 Fiscal Agent: 1,238,325 21,610,233 Source BNY Western Trust LAIF LAIF US Bank AIM Instil. 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 iii ii X3:i—i 03 H:\Long Term Debt\Quarterly Investment Reports\Qtr Inv Rpt.xlsx City of Carlsbad Summary of Outstanding Housing Loans As of December 31, 2009 Updated on: 01/11/2010 Development #of First date loans Purpose issued issued Loans issued by Loan amount Developer loan City to Loans issued by due to City amount due to developers/ Developer to # of loans City loan repaid Developer loan (recorded as City (not on City's homeowners homeowners outstanding to City repaid to City AR) books)Type of Loan Individual homebuyers Individual homebuyers Individual homebuyers Individual homebuyers Individual homebuyers Individual homebuyers Catholic Charities CB Laurel Tree Apartments CB Housing Partnership Pacific Vista Las Flores Poinsettia Housing Assoc Bridge Housing Corp Dove Family Housing CIC Calavera LP Individual homebuyers Individual homebuyers El Camino Family Housing Individual homebuyers Individual homebuyers Habitat for Humanity CIC La Costa Down Payment & Closing Cost Assistance CIC Glen Ridge, LP City-wide (CHAP) Calavera Hills Cherry Tree Walk Serrano Rancho Carlsbad bolamar Homeless shelter Laurel Tree Rancho Carrillo Vista Las Flores Poinsettia Station Villa Lorna La Costa Paloma Manposa Apts Mulberry at Bressi Ranch Village by the Sea Cassia Heights Laguna Point The Bluffs Roosevelt St. Condos Hunter's Point Various Glen Ridge Sale Sale Sale Sale Sale bale Shelter Rentals Rentals Rentals Rentals Rentals Rentals Rentals Sale Sale Rentals Sale Sale Sale Rentals Assistance Rentals 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 133 5 42 90 22 9 1 2 1 1 1 2 1 1 100 11 1 3 8 1 1 4 1 $1,680,000 $ 75,000 150,000 453,600 452,600 1,350,000 4,050,000 752,533 14/./26 200,000 1,134,000 1,157,584 363,948 920,000 2,212,000 2,070,000 1,060,000 1,840,000 19,660,200 220,000 4,087,200 1,454,276 210,000 200,000 797,539 1,932,000 47,500 1,014,000 38 1 14 34 15 1 1 2 1 1 1 2 1 1 100 7 1 3 8 1 1 1 1 ($1,282,516) (60,000) (302,400) (840,133) (256,410) (13b,06b) - (357,839) - - - (1,481,610) (847,792) - - - - - . $ - $397,484.09 3 (120,000) 15,000 (283,250) 151,200 (2,520,000) 509,867 496,123 12,661 200,000 776,161 1,157,584 363,948 920,000 730,390 1,222,208 1,060,000 1,840,000 220,000 1,454,276 210,000 200,000 797,539 1,932,000 47,500 1,014,000 > - 397,484 30,000 45,000 169,350 320,550 1,530,000 2,039,867 496,123 12,661 200,000 776,161 1,157,584 363,948 920,000 730,390 1,222,208 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 47,500 1,014,000 Payment deferred 15 years No interest is due unless home is sold before 16th year Payment deferred 30 years. No interest re due unless home is sold before 31th year Payment deferred 30 years No interest is due unless home re sold before 31th year Payment deferred 30 years. No interest re due unless home is sold before 31th year Principal is due when home is sold Principal is due when home re 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 re sold before 46th year Payment deferred 30 years No interest e due unless home re sold before 31th year Refer to Agenda Bill 1 8,569 / Resolution 2006-1 31 & AB 1 9,1 83 / R2007-255 Refer to Council Resolutions 05-264 & 06- 160 i | i Refer to Agenda Bill 19,415 /Resolution ^^2008-121 ~ ro Refer to Agenda Bill 397 / Resolution 435 ' ! q ^s^- 441 $ 21,291,706 $ 28,400,000 236 $ (5,563,765) $ (2,923,250) $ 15,727,941 $ 25,476,750 $41,204,691 During the 2nd quarter of FY2009-10, approximately $22,920 was received in CHAP loan payments; principal payments totaling $101,731 were received for the La Costa Paloma development; a low/mod loan of $1,014,000 was issued for the Glen Ridge development; and three additional loans totaling $34,500 were issued for the DPCCA program. The total outstanding loan balance is now $15,727.941 .