Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2009-08-04; City Council; 19921; Report on City investments as of 6/30/09
CITY OF CARLSBAD - AGENDA BILL s AB# MTG. DEPT. 19.921 8/4/09 TRS REPORT ON CITY INVESTMENTS AS OF JUNE 30, 2009 DEPT. HEAD jf%^ CITYATTY. 'd^ CITY MGR. UA— ~ 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 June 30, 2009 is summarized below. Pooled Investment Portfolio (Cash and Securities) Par Value Cost of Investments Amortized Cost (1) Market Value (2) Current Month 563,761,416 570,194,074 567,705,932 575,580,798 Prior Month 569,906,264 575,564,902 573,037,554 580,879,030 (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 6/30/09. The equity portion of the various funds in the total portfolio is summarized in the graph on the next page. Fund balances are restricted for various purposes. See Exhibit 7 for a more detailed breakdown. FUND EQUITY IN POOLED INVESTMENTS (Dollar Amounts in Millions) Special Revenue $ 46.4 Capital Projects $277 Genera Other $0.2 Internal Service$26Agencv $20 Enterprise $124.8 Total Treasurer's Investment Portfolio at Amortized Cost June 30, 2009 $567.7 million FOR CITY CLERKS USE ONLY. COUNCIL ACTION: APPROVED J!< DENIED D CONTINUED D WITHDRAWN D AMENDED D CONTINUED TO DATE SPECIFIC CONTINUED TO DATE UNKNOWN RETURNED TO STAFF OTHER - SEE MINUTES D D D D DEPARTMENT CONTACT: Nancy Sullivan (760) 602-2473 nsull@ci.carlsbad.ca.us PAGE 2 OF AB REPORT ON CITY INVESTMENTS AS OF JUNE 30. 2009 Pooled Investment Interest Income Cash Income Fiscal Year-to-Date * Current Month FYTD 23,857,927 Prior Month FYTD 22,223,301 Current Month Income 1 ,634,626 The cash income received is adjusted for any accrued interest purchased. Pooled Investment Performance/Measurement April 2009 May 2009 June 2009 Average Life (Years) 1.47 1.50 1.58 Average Yield To Maturity 3.33% 3.26% 2.97% Modified Duration 1.370 1.403 1.478 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 23,421 ,465 23,421,465 Prior Quarter 24,001 ,445 24,001 ,445 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. Fourth Quarter Transactions 7. Detailed Investment Report 8. Fund Equity in Pooled Investments 9. Corporate Note and Commercial Paper Ratings 10. Percentage Weightings By Corporate Note Issuer 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 JUNE 30, 2009 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 BANK ACCT Current Month 33,000 15,262,925 0 81,597,018 300,475,795 115,770,858 52,543,000 - 1,327,643 695,693 Prior Month 33,000 12,238,726 0 13,126,603 305,358,505 110,569,536 128,897,584 12,571 2,177,603 623,426 Current Month 33,000 15,255,270 0 81 ,596,230 306,944,544 117,185,418 52,543,000 0 1,327,643 695,693 Prior Month 33,000 12,252,010 0 13,164,040 312,437,867 111,280,929 128,897,584 12,571 2,177,603 623,426 Cash Income Year to Date 547 0 0 36,040 17,826,282 4,265,676 1,718,803 2,971 7,610 0 Current Month 0.90 2.32 0.00 0.35 3.43 4.38 1.54 0.24 0.10 0.10 Prior Month 0.90 2.82 0.00 0.62 3.70 4.43 1.57 0.24 0.10 0.10 TOTALS $567,705,932 $573,037,554 $575,580,798 $580,879,030 $23,857,927 2.97%3.26% CD - Certificate of Deposit FN - Federal Discount Notes CP - Corporate Paper TR - US Treasury FA - Federal Agency CN - Corporate Notes LAIF - Local Agency Investment Fund Custody - Investment Cash account SWEEP - General Fund Overnight Cash acccount Bank Account - General Fund Cash account mx CD CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF JUNE 30,2009 BREAKDOWN OF MATURITIES BY CLASSIFICATION AND LENGTH OF TIME CLASS CD FN CP TR FA CN LAIF CUSTODY SWEEP BANKACCT TOTALS % TOTALS Total within One Year POLICY: WITHIN 6 MONTHS 7 MONTHS TO 1 YEAR 0 33,000 4,911,490 0 50,952,628 51,224,516 14,086,093 52,543,000 0 1,327,643 695,693 $175,741,063 (1) 30.8% (1) Not less than $130,125,000 to mature 997,329 0 25,567,822 41,135,170 7,120,941 0 0 0 0 $74,854,263 (1) 13.1% $250,595,326 (1) 44.0% within one year. (2/3rds 1 TO 5 YEARS 0 9,201,104 0 5,139,687 210,169,198 95,088,758 0 0 0 0 $319,598,748 56.1% of current year operating TOTAL 33,000 15,109,923 0 81,660,137 302,528,884 116,295,793 52,543,000 0 1,327,643 695,693 $570,194,074 100.0% budget of $195,180,000.00) % TOTAL 0.0% 2.7% 0.0% 14.3% 53.1% 20.4% (2) 9.2% 0.0% 0.2% 0.1% 100.0% m X DCI— 1 DO (2) Policy states that not more than 30% of portfolio is to be invested in corporate notes. ro YIELD COMPARISON PORTFOLIO EX-LAIF VS. LAIF JULY 1996-JUNE 2009 4.25 4.00 -*-LAF &&&&&& MARKET YIELD CURVE 6/30/07, 6/30/08, 6/30/09 Market Rates 3Mth 2Yr 5Yr 3Mth 2Yr 5Yr 10 Yr -•-06/30/2007 -*- 06/30/2008 -^-06/30/2009 4.86 1.73 .18 4.84 2.62 1.11 4.89 3.33 2.55 4.99 3.97 3.53 10 Yr X3:i—i 03 Cumulative Millions $ Cumulative Cash Income FY08-09 (June 09) 24 22 20 18 16 14 12 10 8 6 4 2 Z£ Monthly Interest IncomeMillions $ 2.65 1.7 2.3 185 r 1-64 2.12 1.6 1 .3 Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun [=3Interest Income -•*--Budget Actual 8 7 6 5 4 3 2 1 0 Xini—i DO City of Carlsbad TRANSACTIONS FOR PERIOD: 04/01/09 TO 06/30/2009 4th QUARTER 2008-2009 Trans Date BUYS APRIL 03/30/2009 04/16/2009 04/15/2009 04/16/2009 04/20/2009 04/16/2009 04/20/2009 04/15/2009 04/23/2009 04/29/2009 MAY 05/08/2009 05/08/2009 05/08/2009 05/08/2009 05/08/2009 04/30/2009 05/08/2009 05/08/2009 05/07/2008 05/07/2009 05/07/2009 05/07/2009 05/06/2009 04/28/2009 05/07/2009 05/08/2009 JUNE 05/29/2009 05/29/2009 05/29/2009 05/29/2009 05/29/2009 06/02/2009 06/02/2009 Investment Date 04/02/2009 04/17/2009 04/21/2009 04/21/2009 04/21/2009 04/22/2009 04/23/2009 04/27/2009 04/28/2009 04/30/2009 05/11/2009 05/11/2009 05/11/2009 05/11/2009 05/11/2009 05/05/2009 05/11/2009 05/12/2009 05/12/2009 05/12/2009 05/12/2009 05/12/2009 05/12/2009 05/14/2009 05/19/2009 05/19/2009 06/01/2009 06/01/2009 06/01/2009 06/01/2009 06/01/2009 06/03/2009 06/03/2009 Type CN FA CN CN TR FA CN FA CN TR TR TR TR FA FA CN FA FA CN CN CN CN FA FA FA FA TR FN FN FA FA FA FA Security ROYAL BANK OF CANADA FHLB TOYOTA FIN BERKSHIRE HATHAWAY US TREASURY FHLB BERKSHIRE HATHAWAY FHLMC CITIGROUP US TREASURY US TREASURY US TREASURY US TREASURY FHLB FAMCA BARCLAYS BANK FHLMC FNMA MET LIFE GLOBLE CHEVRON WAL-MART STORES 3M FFCB FNMA FNMA FNMA US TREASURY DN FHLBDN FHLBDN FHLB FHLB FHLB FHLB Call Date N/A N/A N/A N/A N/A N/A N/A 04/27/2010 N/A N/A N/A N/A N/A N/A N/A N/A N/A 05/12/2010 N/A N/A N/A N/A 08/06/2009 08/14/2009 05/19/2010 02/19/2010 N/A N/A N/A N/A N/A N/A N/A Par Value 1 ,000,000.00 1 ,000,000.00 2,000,000.00 1 ,000,000.00 3,000,000.00 3,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 1 ,000,000.00 1 ,000,000.00 1 ,575,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 3,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 2,000,000.00 2,000,000.00 2,000,000.00 Coupon 5.650% 5.250% 5.375% 4.000% 2.625% 1.125% 4.000% 1 .750% 2.875% 0.000% 0.000% 0.000% 2.000% 1 .375% 5.500% 2.700% 3.875% 1 .450% 5.125% 3.450% 4.250% 4.375% 2.875% 2% STEP 2.200% 2.320% 0.000% 0.000% 0.000% 1 .250% 1 .050% 1 .050% 4.375% Amount Cost 1 ,066,260.00 1 ,049,288.56 2,078,000.00 1 ,022,563.95 3,069,492.19 3,000,000.00 2,039,340.00 3,000,000.00 / 2,060,840.00 1,991,806.11 1 ,996,693.33 1 ,995,905.56 2,025,000.00 1,001,350.00 1 ,072,970.00 1 ,590,861 .34 1,063,510.00 1,000,000.00 1,020,480.00 3,103,177.11 1,047,829.91 2,121,417.76 3,000,000.00 2,000,000.00 2,000,000.00 1 ,000,000.00 1,997,315.00 1 ,997,240.00 997,329.44 2,014,960.00 2,008,660.00 2,007,180.00 2,101,180.00 Return Rate 2.659% 0.930% 3.372% 3.200% 0.529% 1.125% 3.300% 1 .750% 1 .680% 0.437% 0.315% 0.340% 0.411% 1 .305% 2.055% 2.330% 1 .928% 1 .450% 4.250% 2.180% 2.950% 2.850% 2.875% 3.162% 2.200% 2.320% 0.274% 0.374% 0.386% 0.700% 0.750% 0.800% 0.701% Investment Interest 63,690.00 11,086.44 142,375.00 96,769.38 17,911.66 50,625.00 198,882.22 118,125.00 89,458.61 8,193.89 3,306.67 4,094.44 7,173.91 25,653.47 46,807.78 104,626.16 67,701.81 29,000.00 107,217.92 187,485.39 3,187.50 251,186.41 343,562.50 320,000.00 154,000.00 87,000.00 2,685.00 2,760.00 2,670.56 19,276.11 21,906.67 23,270.00 20,104.72 1 1 2 1 3 3 2 3 2 2 2 2 2 1 1 1 1 1 1 Return ,129,950.00 ,060,375.00 ,220,375.00 ,119,333.33 ,087,403.85 ,050,625.00 ,238,222.22 ,118,125.00 ,150,298.61 ,000,000.00 ,000,000.00 ,000,000.00 ,032,173.91 ,027,003.47 ,119,777.78 ,695,487.50 ,131,211.81 ,029,000.00 ,127,697.92 3,290,662.50 1 2 3 2 2 1 2 2 1 2 2 2 2 ,051,017.41 ,372,604.17 ,343,562.50 ,320,000.00 ,154,000.00 ,087,000.00 ,000,000.00 ,000,000.00 rri,000,000.00 x ,034,236.11 ~ ,030,566.67 5 ,030,450.00 ~* ,121,284.72 ^ City of Carlsbad TRANSACTIONS FOR PERIOD: 04/01/09 TO 06/30/2009 4th QUARTER 2008-2009 Trans Date 06/02/2009 06/04/2009 06/04/2009 06/04/2009 06/04/2009 06/04/2009 06/04/2009 06/04/2009 06/04/2009 06/04/2009 06/04/2009 06/17/2009 06/17/2009 06/17/2009 06/17/2009 06/17/2009 06/17/2009 06/17/2009 06/17/2009 06/19/2009 06/19/2009 05/29/2009 06/23/2009 06/26/2009 06/26/2009 Investment Date 06/03/2009 06/05/2009 06/05/2009 06/05/2009 06/05/2009 06/05/2009 06/05/2009 06/05/2009 06/05/2009 06/05/2009 06/05/2009 06/18/2009 06/18/2009 06/18/2009 06/18/2009 06/18/2009 06/18/2009 06/18/2009 06/18/2009 06/22/2009 06/22/2009 06/22/2009 06/26/2009 06/29/2009 06/29/2009 TOTAL FOURTH QUARTER MATURITIES APRIL MAY •v. 04/07/2008 04/28/2004 05/05/2004 11/08/2007 06/11/2008 02/13/2008 12/15/2008 Type FA TR TR TR TR TR TR TR TR TR TR TR TR TR TR TR TR TR TR FA FA FA CN FA FA Security FNMA US TREASURY US TREASURY US TREASURY US TREASURY US TREASURY US TREASURY US TREASURY US TREASURY ' US TREASURY US TREASURY US TREASURY US TREASURY US TREASURY US TREASURY US TREASURY US TREASURY US TREASURY US TREASURY FHLB FFCB FHLB DN DN DN DN DN DN DN DN DN DN DN PROCTER & GAMBLE FFCB FHLB Call Date 04/01/2010 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 12/22/2009 N/A N/A N/A 2008-2009 FA FA FA FA FA FA CN FHLB FHLMC FHLMC FFC FNMA FHLB TOYOTA N/A 04/28/2006 N/A N/A N/A N/A N/A Par Value 2,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 4,000,000.00 5,000,000.00 4,000,000.00 4,000,000.00 4,000,000.00 2,000,000.00 3,000,000.00 3,000,000.00 5,000,000.00 4,000,000.00 2,000,000.00 146,575,000.00 2,000,000.00 5,000,000.00 5,000,000.00 2,000,000.00 1 ,005,000.00 1,000,000.00 999,960.00 Coupon 2.050% 2.125% 6.500% 1 .750% 4.000% 4.500% 2.875% 2.750% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 1.125% 3.875% 1 .5% STEP 4.600% 2.000% 1 .625% 3.250% STEP STEP 9.550% 4.250% 4.070% 3.834% Amount Cost 2,024,200.00 3,035,156.25 3,128,320.31 3,033,867.19 3,093,164.06 3,114,140.63 3,076,875.00 3,077,578.13 2,998,873.33 2,996,799.17 2,997,810.00 4,998,040.97 4,997,190.28 4,994,866.67 3,994,540.00 4,992,669.44 3,995,860.00 3,997,480.00 3,998,584.44 1 ,988,700.00 3,152,520.00 3,000,000.00 5,246,650.00 4,036,800.00 2,012,680.00 148,524,016.13 2,000,000.00 5,000,000.00 5,000,000.00 2,155,378.00 1,018,080.08 1,019,418.00 997,658.09 Return Rate 1 .377% 0.331% 0.342% 0.369% 0.382% 0.452% 0.469% 0.501% 0.132% 0.233% 0.183% 0.157% 0.172% 0.244% 0.274% 0.294% 0.233% 0.183% 0.142% 1 .420% 1 .490% 2.239% 3.420% 1.630% 1.315% 1.08% 3.25% 3.47% 4.26% 4.19% 2.82% 2.53% 4.00% Interest 50,738.89 28,593.75 7,425.55 9,165.60 10,114.63 13,155.57 15,331.49 17,684.30 1,126.67 3,200.83 2,190.00 1 ,959.03 2,809.72 5,133.33 5,460.00 7,330.56 4,140.00 2,520.00 1,415.56 55,112.50 100,323.75 202,500.00 800,488.89 167,200.00 54,847.78 4,201,762.62 18,597.22 875,000.00 1 ,075,000.00 133,244.22 26,547.63 33,152.83 37,827.50 Investment Return 2,074,938.89 3,063,750.00 3,135,745.86 3,043,032.79 3,103,278.69 3,127,296.20 3,092,206.49 3,095,262.43 3,000,000.00 3,000,000.00 3,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 4,000,000.00 5,000,000.00 4,000,000.00 4,000,000.00 4,000,000.00 2,043,812.50 3,252,843.75 3,202,500.00 6,047,138.89 4,204,000.00 2,067,527.78 152,725,778.75 2,018,597.22 5,875,000.00 6,075,000.00 2,288,622.22 1 ,044,627.71 1 ,052,570.83 1 ,035,485.59 City of Carlsbad TRANSACTIONS FOR PERIOD: 04/01/09 TO 06/30/2009 Trans Investment 4th QUARTER 2008-2009 03/14/2007 05/15/2007 07/25/2007 08/09/2007 03/05/2008 04/22/2008 TOTAL FOURTH QUARTER CALLS and /or SALES APRIL 08/16/2007 08/17/2007 04/27/2009 04/28/2006 04/18/2009 04/20/2006 04/21/2008 04/28/2008 MAY 11/13/2008 11/20/2008 05/12/2008 05/29/2008 JUNE 11/18/2009 11/19/2008 05/28/2008 06/10/2008 03/07/2007 03/15/2007 03/17/2008 03/18/2008 06/15/2009 06/30/2006 FA FA FA FA FA FA FHLB FHLB FHLB FHLB FHLB FHLMC 2008-2009 FA FA FA FA FA FA FA FA FA FA FA FHLMC FNMA FNMA FNMA FFCB FHLMC FHLMC FHLMC FHLMC FHLB FHLB TOTAL FOURTH QUARTER 2008-2009 Call Date N/A N/A N/A N/A N/A N/A 04/03/2009 04/06/2009 04/06/2009 04/28/2009 05/19/2009 05/29/2009 06/04/2009 06/10/2009 06/15/2009 06/26/2009 06/30/2009 Par Value 2,000,000.00 5,000,000.00 2,000,000.00 2,000,000.00 4,000,000.00 1,000,000.00 33,004,960.00 3,000,000.00 2,421,000.00 3,000,000.00 3,000,000.00 2,000,000.00 1 ,000,000.00 1 ,000,000.00 3,000,000.00 5,000,000.00 2,000,000.00 2,000,000.00 Coupon 5.250% 5.250% 5.250% 5.250% 5.250% 4.100% 5.250% 5.250% 5.250% 3.000% 2.875% 3.530% 5.400% 4.000% 5.030% 5.750% 5.650% Amount Cost 2,022,809.38 5,030,000.00 2,006,972.34 2,015,549.68 4,150,240.00 1,016,880.00 33,432,985.57 2,998,500.00 2,396,790.00 2,976,375.00 2,999,250.00 1 ,000,000.00 1,000,000.00 1,016,580.00 2,998,500.00 5,000,000.00 2,075,680.00 2,000,000.00 Return Rate 4.71% 4.94% 5.05% 4.80% 2.23% 2.65% 3.88% 5.26% 5.48% 5.43% 3.01% 2.88% 3.53% 4.88% 4.72% 5.03% 4.76% 5.65% Interest 212,857.29 514,687.50 190,485.99 177,825.32 116,343.33 30,864.44 3,442,433.27 730,375.00 651,955.12 805,000.00 180,750.00 1,114,840.28 114,725.00 174,670.00 714,000.00 1,068,875.00 415,625.56 565,000.00 Investment Return 2,235,666.67 5,544,687.50 2,197,458.33 2,193,375.00 4,266,583.33 1 ,047,744.44 36,875,418.84 3,728,875.00 3,048,745.12 3,781 ,375.00 3,180,000.00 2,114,840.28 1,114,725.00 1,191,250.00 3,712,500.00 6,068,875.00 2,491 ,305.56 2,565,000.00 27,421,000.00 26,461,675.00 4.76% 6,535,815.96 32,997,490.96 INVESTMENT REPORT AS OF JUNE 30,2009 INVESTMENT DATE 02/13/2008 05/05/2008 07/25/2007 08/09/2007 04/04/2008 01/22/2008 10/27/2008 01/04/2008 03/13/2008 03/25/2008 05/15/2007 11/01/2006 01/22/2008 08/17/2007 03/14/2007 01/22/2008 02/01/2008 11/13/2007 03/19/2007 03/05/2008 01/22/2008 03/06/2008 01/28/2008 01/31/2008 01/22/2008 01/22/2008 01/22/2008 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 f 04/22/2008 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 SECURITY FHLMC3.25% NON-CALL FHLB 5.375% NON-CALL FFCB5.15% NON-CALL FFCB 5.150% NON-CALL FHLB 3.1% NON-CALL FHLB 4.180% NON-CALL FHLB 3.10% NON-CALL FHLMC 4.375% NON-CALL FHLMC 4.375% NON-CALL FHLMC 4.375% NON-CALL HUD 4.430% NON-CALL FHLB 5.25% NON-CALL FHLB 5.25% NON-CALL FFCB 5.00% NON-CALL FHLB 4.378% NON-CALL FHLB 4.375% NON-CALL FHLB 5.25% NON-CALL FHLMC 3.5$ NON-CALL FHLB 5.0% NON-CALL FFCB 5.00% NON-CALL FNMA4.0% NON-CALL FFCB 4.350% NON-CALL FFCB 4.125% NON-CALL FHLB 4.25% NON-CALL FNMA4.0% NON-CALL FHLMC 4.125% NON-CALL FHLB 5.0% NON-CALL 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 PAR VALUE 2,000,000.00 3,000,000.00 1 ,000,000.00 2,000,000.00 2,000,000.00 500,000.00 1,000,000.00 1 ,270,000.00 1 ,000,000.00 2,000,000.00 1 ,000,000.00 5,000,000.00 2,000,000.00 3,000,000.00 2,000,000.00 3,000,000.00 1 ,000,000.00 1,000,000.00 3,000,000.00 2,000,000.00 500,000.00 1 ,000,000.00 2,000,000.00 1 ,000,000.00 2,000,000.00 2,080,000.00 3,000,000.00 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 INVESTED AMOUNT 2,020,560.00 3,103,028.04 1 ,001 ,858.80 2,012,808.76 2,019,092.00 508,810.00 1,000,000.00 1,286,826.23 1,027,740.00 2,052,000.00 990,198.00 5,048,115.85 2,070,366.00 3,000,000.00 1 ,984,643.55 3,070,602.00 1,041,519.37 990,283.25 3,014,820.00 2,090,620.00 508,645.00 1,031,080.00 2,049,060.00 1,024,930.00 2,038,020.00 2,124,168.80 3,114,720.00 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 RETURN RATE 2.500% 2.450% 5.050% 4.800% 2.350% 2.981% 3.100% 3.500% 2.320% 2.400% 4.900% 4.870% 2.891% 5.000% 4.705% 2.890% 2.600% 4.040% 4.790% 2.160% 2.986% 2.434% 2.711% 2.805% 2.916% 2.918% 2.900% 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% INTEREST 70,801.11 90,471.96 100,425.92 187,755.13 61 ,680.22 22,830.28 23,250.00 70,530.37 32,659.31 65,881 .94 107,754.22 676,675.82 90,925.67 300,000.00 233,377.28 144,137.58 43,073.96 75,536.19 365,596.67 72,713.33 26,688.33 41,420.00 98,752.50 50,861 .67 107,313.33 112,177.87 168,196.67 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 INVESTMENT RETURN 2,091,361.11 3,193,500.00 1,102,284.72 2,200,563.89 2,080,772.22 531 ,640.28 1 ,023,250.00 1 ,357,356.60 1 ,060,399.31 2,117,881.94 1 ,097,952.22 5,724,791 .67 2,161,291.67 3,300,000.00 2,218,020.83 3,214,739.58 1,084,593.33 1,065,819.44 3,380,416.67 2,163,333.33 535,333.33 1,072,500.00 2,147,812.50 1,075,791.67 2,145,333.33 2,236,346.67 3,282,916.67 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 TERM (Days) 512 438 726 711 475 552 273 573 504 492 809 1,008 561 731 912 598 588 687 928 597 645 610 655 652 664 666 689 728 746 743 501 770 767 758 709 498 715 821 1,013 749 x:ci—i DO INVESTMENT REPORT AS OF JUNE 30,2009 INVESTMENT DATE TYPE SECURITY 05/05/2008 FA FHLB 7.625% NON-CALL 12/21/2007 FA FNMA 3.625% NON-CALL 03/16/2009 FA FHLB 1.250% NON-CALL 02/26/2008 FA FHLB 4.25% NON-CALL 05/08/2008 FA FHLB 3.00% NON-CALL 04/17/2009 FA FHLB 5.25% NON-CALL 08/05/2008 FA FHLMC 3.50% NON-CALL 10/09/2007 FA FHLB 4.5% NON-CALL 07/25/2007 FA FNMA 5.125% NON-CALL 07/15/2008 FA FFCB 3.200% NON-CALL 03/12/2008 FA FHLB 4.44% NON-CALL 02/20/2008 FA FNMA 4.70% NON-CALL 02/13/2008 FA FHLB 5.00% NON-CALL 10/30/2007 FA FHLB 4.7% NON-CALL 02/12/2008 FA FHLB 3.190% CALL 8/12/08 09/18/2007 FA FHLMC 5.125% NON-CALL 09/26/2007 FA FHLB 5.125% NON-CALL 05/08/2008 FA FHLB 3.00% NON-CALL 12/05/2008 FA FHLB 3.375% NON-CALL 03/11/2009 FA FHLB 1.4% NON-CALL 09/26/2007 FA FFCB 5.25% NON-CALL 06/01/2009 FA FHLB 1.25% NON-CALL 05/05/2008 FA FHLB 4.375% NON-CALL 04/22/2009 FA FHLB 1.125% NON-CALL 06/03/2009 FA FHLB 4.375% NON-CALL 06/01/2009 FA FHLB 1.050% NON-CALL 06/03/2009 FA FHLB 1.050% NON-CALL 12/23/2008 FA FHLB 1.70% CALL 12/30/09 12/05/2008 FA FHLMC 4.50% NON-CALL 01/20/2009 FA FHLMC 2.0% CALL 4/20/09 06/03/2009 FA FNMA 2.050% CALL 4/1/10 05/11/2009 FA FHLB 1.375% NON-CALL 02/20/2008 FA FHLB 2.875% NON-CALL 05/12/2009 FA FNMA 1.45% CALL 11/20/2007 FA FHLB 4.5% CALL 11/20/09 01/28/2008 FA FHLB 4.5% CALL 11/20/09 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 08/07/2008 FA FNMA 4.00% CALL 07/07/09 PAR VALUE 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 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 1,000,000.00 3,000,000.00 1 ,000,000.00 2,000,000.00 3,000,000.00 2,000,000.00 1 ,000,000.00 1 ,000,000.00 2,000,000.00 2,000,000.00 INVESTED AMOUNT 3,273,695.78 1 ,996,499.26 1,000,000.00 1 ,030,795.00 999,862.00 1 ,049,288.56 3,010,680.00 2,991,510.00 1 ,000,640.00 1 ,000,000.00 1 ,043,000.00 3,134,430.00 2,688,248.25 1 ,009,328.80 3,000,000.00 3,048,120.00 2,034,188.23 1,994,876.00 2,032,660.00 2,000,000.00 2,041,700.00 2,014,960.00 1 ,032,893.26 3,000,000.00 2,101,180.00 2,008,660.00 2,007,180.00 1 ,000,000.00 3,119,880.00 3,000,000.00 2,024,200.00 1 ,001 ,350.00 2,993,378.76 1 ,000,000.00 2,016,000.00 3,078,630.00 1 ,988,700.00 1 ,020,930.00 1,055,434.00 2,132,207.14 1,996,500.00 RETURN RATE 2.950% 3.700% 1.250% 2.849% 3.005% 0.930% 3.300% 4.610% 5.100% 3.200% 2.559% 2.786% 2.710% 4.337% 3.190% 4.530% 4.500% 3.115% 2.420% 1 .400% 4.490% 0.700% 2.980% 1.125% 0.701% 0.750% 0.800% 1 .700% 2.470% 2.000% 1 .377% 1 .305% 2.950% 1 .450% 4.252% 3.651% 1 .420% 4.761% 3.345% 2.720% 4.063% INTEREST 189,522.97 180,118.80 15,625.00 66,482.78 62,888.00 11,086.44 185,028.33 373,365.00 150,405.14 64,000.00 62,326.67 209,453.33 175,897.58 121,226.76 239,250.00 402,452.92 268,756.21 145,457.34 86,402.50 41,922.22 269,508.33 19,276.11 74,901.88 50,625.00 20,104.72 21 ,906.67 23,270.00 34,000.00 154,245.00 120,000.00 50,738.89 25,653.47 270,402.49 (891 ,000.00) 299,000.00 368,370.00 55,112.50 181,976.25 106,732.67 154,501.19 236,833.33 INVESTMENT RETURN 3,463,218.75 2,176,618.06 1,015,625.00 1,097,277.78 1 ,062,750.00 1 ,060,375.00 3,195,708.33 3,364,875.00 1,151,045.14 1 ,064,000.00 1,105,326.67 3,343,883.33 2,864,145.83 1,130,555.56 3,239,250.00 3,450,572.92 2,302,944.44 2,140,333.34 2,119,062.50 2,041 ,922.22 2,311,208.33 2,034,236.11 1,107,795.14 3,050,625.00 2,121,284.72 2,030,566.67 2,030,450.00 1,034,000.00 3,274,125.00 3,120,000.00 2,074,938.89 1,027,003.47 3,263,781.25 109,000.00 2,315,000.00 3,447,000.00 2,043,812.50 1,202,906.25 1,162,166.67 2,286,708.33 2,233,333.33 TERM (Davs) 739 889 457 836 764 420 680 987 1,077 730 866 889 898 1,015 912 1,070 1,080 855 644 548 1,083 500 900 548 506 532 530 737 741 730 667 717 1,115 730 1,277 1,208 711 1,379 1,128 996 1,064 INVESTMENT REPORT AS OF JUNE 30,2009 INVESTMENT DATE TYPE SECURITY 03/09/2007 FA FNMA 3.64% NON-CALL 08/01/2007 FA FAMCA5.50% NON-CALL 08/31/2007 FA FAMCA5.50% NON-CALL 05/08/2008 FA FAMCA5.5% NON-CALL 03/31/2009 FA FFCB 3.625% NON-CALL 05/11/2009 FA FAMCA 5.50% NON-CALL 04/27/2009 FA FHLMC 1.75% CALL 4/27/10 06/29/2009 FA FHLB 1.625% 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 08/26/2008 FA FNMA 4.0% CALL 8/26/09 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 03/15/2007 FA FHLB 4.875% NON-CALL 10/05/2007 FA FHLB 4.9% CALL 10/05/09 10/19/2007 FA FHLB 5.00% CALL 10/19/09 03/05/2008 FA FHLB 5.30% CALL 10/27/09 03/19/2007 FA FHLB 4.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 07/25/2007 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 06/22/2009 FA FHLB 1.50% CALL Quarterly 12/10/2007 FA FHLB 5.58% CALL 7/20/10 08/05/2008 FA FFCB 3.950% NON-CALL 07/30/2007 FA FHLB 5.52% CALL 7/30/10 08/13/2008 FA FHLB 4.35% CALL 8/13/10 01/29/2009 FA FHLB 4.625% NON-CALL 02/27/2009 FA FNMA 2.625% CALL 8/27/10 09/10/2007 FA FNMA 5.20% CALL 9/13/09 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 PAR VALUE 2,000,000.00 3,000,000.00 629,000.00 2,000,000.00 1 ,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 1 ,000,000.00 2,000,000.00 3,000,000.00 1,000,000.00 3,000,000.00 3,000,000.00 2,000,000.00 3,000,000.00 2,000,000.00 3,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 1,000,000.00 1,000,000.00 3,000,000.00 3,000,000.00 1,000,000.00 2,000,000.00 1,770,000.00 2,000,000.00 2,000,000.00 2,000,000.00 1,000,000.00 2,000,000.00 1,175,000.00 1,000,000.00 INVESTED AMOUNT 1,909,480.00 3,034,380.00 644,775.32 2,116,712.00 1 ,044,420.00 1,072,970.00 3,000,000.00 2,012,680.00 3,111,810.00 1,097,950.00 3,152,520.00 999,500.00 2,018,200.00 3,032,352.00 1,077,520.00 3,117,300.00 3,018,777.00 2,000,000.00 3,000,000.00 2,085,000.00 3,009,690.00 4,036,800.00 2,000,000.00 3,000,000.00 999,687.50 1 ,987,880.00 2,130,980.00 1 ,005,040.00 1 ,005,254.43 3,050,958.11 3,000,000.00 1,037,000.00 2,002,900.00 1,770,000.00 1,999,500.00 2,150,960.00 2,000,000.00 1 ,000,000.00 2,000,000.00 1,238,814.19 1,022,730.00 RETURN RATE 4.805% 5.175% 4.781% 3.545% 1 .639% 2.050% 1 .750% 1.315% 4.800% 1.818% 1 .490% 4.018% 4.773% 4.730% 1 .958% 4.390% 4.720% 4.900% 5.000% 4.033% 4.795% 1 .630% 5.000% 5.000% 5.006% 5.015% 5.235% 5.255% 5.250% 3.900% 2.239% 4.677% 3.910% 5.520% 4.357% 2.391% 2.625% 5.200% 2.710% 3.640% 3.889% INTEREST 406,997.78 618,286.67 118,184.21 233,760.22 85,530.00 46,807.78 118,125.00 54,847.78 648,148.33 49,313.89 100,323.75 120,500.00 432,911.11 640,148.00 53,868.89 522,075.00 647,473.00 392,000.00 600,000.00 301,311.11 672,403.75 167,200.00 500,000.00 750,000.00 246,979.17 489,057.50 524,632.22 256,692.64 256,478.21 460,552.31 202,500.00 220,300.00 310,466.67 488,520.00 348,500.00 176,901.11 183,750.00 260,000.00 190,000.00 192,237.89 160,020.00 INVESTMENT RETURN 2,316,477.78 3,652,666.67 762,959.53 2,350,472.22 1,129,950.00 1,119,777.78 3,118,125.00 2,067,527.78 3,759,958.33 1,147,263.89 3,252,843.75 1,120,000.00 2,451,111.11 3,672,500.00 1,131,388.89 3,639,375.00 3,666,250.00 2,392,000.00 3,600,000.00 2,386,31 1 .1 1 3,682,093.75 4,204,000.00 2,500,000.00 3,750,000.00 1,246,666.67 2,476,937.50 2,655,612.22 1,261,732.64 1,261,732.64 3,511,510.42 3,202,500.00 1 ,257,300.00 2,313,366.67 2,258,520.00 2,348,000.00 2,327,861.11 2,183,750.00 1 ,260,000.00 2,190,000.00 1,431,052.08 1,182,750.00 TERM (Days) 1,588 1,444 1,414 1,163 836 795 821 758 1,610 934 794 1,095 1,649 1,639 959 1,416 1,665 1,461 1,461 1,331 1,705 932 1,827 1,827 1,802 1,788 1,764 1,780 1,780 1,424 1,096 1,684 1,448 1,827 1,461 1,294 1,277 1,827 1,280 1,593 1,484 INVESTMENT REPORT AS OF JUNE 30, 2009 INVESTMENT DATE 05/11/2009 10/29/2007 12/10/2007 10/22/2007 11/28/2007 12/06/2007 06/03/2008 05/19/2009 12/21/2007 12/21/2007 01/23/2008 01/14/2008 05/19/2009 03/10/2008 05/12/2009 05/14/2008 11/10/2008 12/03/2008 08/27/2008 11/12/2008 12/17/2008 11/12/2008 11/19/2008 11/26/2008 01/20/2009 02/12/2009 03/26/2009 05/14/2009 10/23/2008 06/01/2009 06/01/2009 03/12/2009 02/11/2009 02/18/2009 02/25/2009 03/02/2009 03/02/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 FN FN FN FN FN FN FN FN FN SECURITY FHLMC 3.875% NON-CALL FHLMC5.05% CALL 10/15/09 FFCB4.5% NON-CALL FHLB5.00% CALL 4/22/10 FNMA 5.00% CALL 10/30/09 FNMA 5.00% CALL 10/30/09 FNMA 6.41% NON-CALL FNMA 2.2% CALL 5/19/10 FHLMC 4.375% CALL 12/21/09 FHLMC 4.375% CALL 12/21/09 FHLB4.7% CALL 1/7/10 FHLB4.25% CALL 10/14/08 FNMA 2.32% CALL 2/19/10 FHLB3.50% NON-CALL FFCB 2.875% CALL 8/6/09 FHLB 4.00% CALL 5/15/10 FHLB 5.375% NON-CALL FFCB 4.625% CALL 7/8/10 FNMA 4.375% NON-CALL FHLB 4.0% NON-CALL FHLB 4.375% NON-CALL FNMA 4.05% CALL 9/18/09 FHLMC 50.5% CALL 9/25/09 FHLB 3.5% CALL 11/26/10 FHLB 3.125% NON-CALL FNMA 2.00% CALL 2/12/10 FHLMC 2.50% CALL 6/26/09 STEP FNMA 2.0% CALL 8/14/09 FHLBN 0% NON-CALL FHLBN 0% NON-CALL 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 PAR VALUE 1,000,000.00 1 ,000,000.00 2,000,000.00 2,000,000.00 3,000,000.00 2,000,000.00 1,807,000.00 2,000,000.00 5,000,000.00 4,000,000.00 2,000,000.00 3,000,000.00 1 ,000,000.00 3,000,000.00 3,000,000.00 2,000,000.00 1,000,000.00 2,000,000.00 2,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 2,000,000.00 3,000,000.00 2,000,000.00 SUB-TOTAL 297,781 ,000.00 3,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 2,000,000.00 2,000,000.00 SUB-TOTAL 16,000,000.00 INVESTED AMOUNT 1,063,510.00 1,006,875.00 2,034,780.00 2,000,000.00 3,033,000.00 2,030,000.00 1 ,990,388.82 2,000,000.00 5,000,000.00 4,000,000.00 2,056,800.00 3,000,000.00 1 ,000,000.00 2,963,940.00 3,000,000.00 2,000,000.00 1,065,788.37 2,053,420.00 2,035,600.00 1 ,007,890.00 2,154,940.00 1 ,987,600.00 1,022,910.00 2,000,000.00 2,047,941.08 2,000,000.00 3,000,000.00 2,000,000.00 302,528,884.30 2,914,250.00 1,997,240.00 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 15,109,923.00 RETURN RATE 1 .928% 4.892% 4.100% 5.000% 4.746% 4.653% 3.890% 2.200% 4.675% 4.675% 4.061% 4.250% 2.320% 3.765% 2.874% 4.000% 3.800% 3.983% 3.970% 3.818% 2.625% 4.192% 5.500% 4.361% 2.600% 3.500% 4.208% 2.000% 3.429% 3.109% 0.274% 0.386% 2.200% 2.300% 2.710% 2.850% 3.000% 3.050% 2.320% INTEREST 67,701 .81 243,661.11 401,970.00 500,000.00 705,333.33 460,000.00 331,405.40 154,000.00 1,168,750.00 935,000.00 409,022.22 637,500.00 87,000.00 560,476.67 343,562.50 320,000.00 181,163.02 371 ,823.06 392,177.78 184,776.67 259,712.78 405,250.00 243,840.00 440,000.00 258,135.31 355,000.00 615,000.00 320,000.00 34,312,075.37 171,500.00 2,760.00 2,670.56 43,630.00 110,760.00 83,286.44 173,720.00 181,320.00 206,180.00 975,827.00 INVESTMENT RETURN 1,131,211.81 1,250,536.11 2,436,750.00 2,500,000.00 3,738,333.33 2,490,000.00 2,321 ,794.22 2,154,000.00 6,168,750.00 4,935,000.00 2,465,822.22 3,637,500.00 1 ,087,000.00 3,524,416.67 3,343,562.50 2,320,000.00 1,246,951.39 2,425,243.06 2,427,777.78 1,192,666.67 2,414,652.78 2,392,850.00 1 ,266,750.00 2,440,000.00 2,306,076.39 2,355,000.00 3,615,000.00 2,320,000.00 336,840,959.67 3,085,750.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 2,000,000.00 2,000,000.00 16,085,750.00 TERM (Days) 1,238 1,813 1,773 1,827 1,798 1,790 1,624 1,280 1,827 1,827 1,811 1,827 1,372 1,824 1,455 1,826 1,677 1,678 1,785 1,759 1,731 1,771 1,771 1,826 1,788 1,826 1,826 1,826 1,112 343 184 253 744 908 1,178 1,171 1,166 1,314 807 INVESTMENT REPORT AS OF JUNE 30, 2009 INVESTMENT DATE 06/05/2009 06/18/2009 06/18/2009 06/18/2009 06/18/2009 06/05/2009 05/11/2009 06/05/2009 06/18/2009 06/01/2009 06/18/2009 05/11/2009 06/18/2009 06/18/2009 06/05/2009 06/05/2009 05/11/2009 06/05/2009 04/30/2009 06/05/2009 06/05/2009 04/21/2009 06/05/2009 06/05/2009 11/10/2008 11/12/2008 03/02/2009 04/24/2007 05/23/2007 11/03/2006 11/01/2007 01/30/2008 01/31/2008 04/09/2008 TYPI TR TR TR TR TR TR TR TR TR 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 SECURITY US TREASURY00% US TREASURY 00% US TREASURY 00% US TREASURY 00% US TREASURY 00% US TREASURY 00% US TREASURY 00% US TREASURY 00% US TREASURY 00% US TREASURY 00% US TREASURY 00% US TREASURY 00% US TREASURY 00% US TREASURY 00% US TREASURY 2.125% US TREASURY 6.50% US TREASURY 2.0% US TREASURY 1.750% US TREASURY 00% US TREASURY 4.0% US TREASURY 4.50% US TREASURY 2.625% US TREASURY 2.8750% US TREASURY 2.750% US TREASURY 3.125% US TREASURY 3.125% SUB-TOTAL WELLS FARGO BANK 9218910637 SUB-TOTAL BANK OF AMERICA 4.625% NON-CALL WAL-MART 6.875% NON-CALL MERRILL LYNCH 4.125% NON-CALL GENERAL ELECTRIC 5.250% NON-CALL BERKSHIRHATWY4.125% NON-CALL BERKSHIRHATWY 4.125% NON-CALL WELLS FARGO CO 4.2% NON-CALL PAR VALUE 113,781,000.00 3,000,000.00 4,000,000.00 5,000,000.00 5,000,000.00 4,000,000.00 3,000,000.00 2,000,000.00 3,000,000.00 5,000,000.00 2,000,000.00 4,000,000.00 2,000,000.00 4,000,000.00 5,000,000.00 3,000,000.00 3,000,000.00 2,000,000.00 3,000,000.00 2,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 1 ,000,000.00 1 ,000,000.00 81,000,000.00 33,000.00 33,000.00 2,000,000.00 5,000,000.00 5,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 1 ,000,000.00 INVESTED AMOUNT 317,638,807.30 2,998,873.33 3,998,584.44 4,998,040.97 4,997,190.28 3,997,480.00 2,997,810.00 1,996,693.33 2,996,799.17 4,994,866.67 1,997,315.00 3,995,860.00 1,995,905.56 3,994,540.00 4,992,669.44 3,035,156.25 3,128,320.31 2,025,000.00 3,033,867.19 1,991,806.11 3,093,164.06 3,114,140.63 3,069,492.19 3,076,875.00 3,077,578.13 1,031,328.00 1 ,030,781 .25 81,660,137.31 33,000.00 33,000.00 1,983,918.00 5,187,303.82 4,884,751.43 2,030,120.00 2,040,548.16 2,038,582.81 1,018,383.81 RETURN RATE 0.132% 0.142% 0.157% 0.172% 0.183% 0.183% 0.315% 0.233% 0.244% 0.274% 0.233% 0.340% 0.274% 0.294% 0.331% 0.342% 0.411% 0.369% 0.437% 0.382% 0.452% 0.529% 0.469% 0.501% 2.430% 2.452% 0.346% 0.900% 0.900% 5.000% 5.060% 5.000% 4.450% 3.050% 3.100% 3.120% INTEREST 35,287,902.37 1,126.67 1,415.56 1 ,959.03 2,809.72 2,520.00 2,190.00 3,306.67 3,200.83 5,133.33 2,685.00 4,140.00 4,094.44 5,460.00 7,330.56 28,593.75 7,425.55 7,173.91 9,165.60 8,193.89 10,114.63 13,155.57 17,911.66 15,331.49 17,684.30 118,792.86 121,777.13 422,692.15 620.00 620.00 226,519.50 573,720.49 703,633.99 178,713.33 121,014.34 122,750.52 55,816.19 INVESTMENT RETURN 352,926,709.67 3,000,000.00 4,000,000.00 5,000,000.00 5,000,000.00 4,000,000.00 3,000,000.00 2,000,000.00 3,000,000.00 5,000,000.00 2,000,000.00 4,000,000.00 2,000,000.00 4,000,000.00 5,000,000.00 3,063,750.00 3,135,745.86 2,032,173.91 3,043,032.79 2,000,000.00 3,103,278.69 3,127,296.20 3,087,403.85 3,092,206.49 3,095,262.43 1,150,120.86 1,152,558.38 82,082,829.46 33,620.00 33,620.00 2,210,437.50 5,761,024.31 5,588,385.42 2,208,833.33 2,161,562.50 2,161,333.33 1 ,074,200.00 TERM (Davs) 1,919 104 91 91 119 126 146 192 167 154 179 162 220 182 182 240 255 293 299 343 314 344 405 390 421 1,755 1,783 345 365 365 832 810 1,042 726 716 715 646 INVESTMENT REPORT AS OF JUNE 30,2009 INVESTMENT PATE TYPE SECURITY 12/15/2008 CN TOYOTA 3.834% NON-CALL 03/19/2008 CN GOLDMAN SACHS 4.50% NON-CALL 11/01/2007 CN WAL-MART 4.125% NON-CALL 03/19/2008 CN WAL-MART 4.125% NON-CALL 02/03/2006 CN US BANCORP 4.50% NON-CALL 01/31/2008 CN WELLS FARGO 4.625% NON-CALL 03/16/2007 CN WAL-MART 4.75% NON-CALL 10/11/2007 CN WAL-MART 4.75% NON-CALL 09/28/2007 CN NEW YORK LIFE 4.625% NON-CALL 02/17/2006 CN CITIGROUP 5.125% NON-CALL 03/30/2006 CN CITIGROUP 5.125% NON-CALL 06/20/2006 CN CITIGROUP 5.125% NON-CALL 04/19/2006 CN HOME DEPOT 5.20% NON-CALL 06/12/2006 CN GENERAL ELECTRIC 5.50% NON-CALL 04/16/2007 CN GENERAL ELECTRIC 5.50% NON-CALL 04/21/2009 CN TOYOTA FIN 5.375% NON-CALL 05/21/2007 CN TOYOTA 5.450% NON-CALL 04/02/2009 CN ROYAL BANK OF CANADA 5.65% NON-CALL 05/30/2008 CN WELLS FARGO CO 5.30% NON-CALL 05/30/2008 CN GENWORTH GLOBAL 5.375% NON-CALL 05/12/2009 CN MET LIFE GLOBAL FUNDING 5.125% NON-CALI 05/29/2007 CN GENERAL ELECTRIC 5.50% CALL 11/15/08 04/28/2009 CN CITIGROUP 2.875% NON-CALL 03/20/2007 CN GENERAL ELECTRIC 5.875% NON-CALL 10/11/2007 CN GENERAL ELETRIC 5.875% NON-CALL 11/15/2007 CN GENERAL ELETRIC 5.875% NON-CALL 05/12/2009 CN CHEVRON 3.450% NON-CALL 05/05/2009 CN BARCLAYS BANK 2.7% NON-CALL 04/21/2009 CN BERKSHIRHATWY4.00% NON-CALL 04/23/2009 CN BERKSHIRHATWY4.00% NON-CALL 04/30/2008 CN PRINCIPAL LIFE INC 4.5% NON-CALL 08/31/2007 CN GENERAL ELECTRIC 6.00% NON-CALL 05/30/2008 CN GENERAL ELECTRIC 6.00% NON-CALL 07/17/2008 CN PROTECTIVE LIFE 5.050% NON-CALL 08/31/2007 CN JOHNSON & JOHNSON 5.15% NON-CALL 10/31/2007 CN GENERAL ELECTRIC 5.250% NON-CALL 11/23/2007 CN GENERAL ELECTRIC 5.250% NON-CALL 01/30/2008 CN WELLS FARGO 5.250% NON-CALL 04/24/2008 CN MET LIFE GLOBAL FUNDING 5.125% NON-CALI 05/07/2008 CN MET LIFE GLOBAL FUNDING 5.125% NON-CALI 05/12/2009 CN WAL-MART 4.250% NON-CALL PAR VALUE 1,000,080.00 1 ,000,000.00 1,000,000.00 2,000,000.00 3,000,000.00 2,000,000.00 3,000,000.00 2,000,000.00 1 ,000,000.00 5,000,000.00 2,000,000.00 2,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 2,000,000.00 4,000,000.00 1 ,000,000.00 1 ,000,000.00 2,000,000.00 1 ,000,000.00 1,850,000.00 2,000,000.00 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 INVESTED AMOUNT 997,777.82 1,025,648.53 991,910.00 2,060,389.92 2,952,150.09 2,063,614.72 3,002,689.16 1 ,993,580.00 987,620.00 5,000,000.00 1,991,793.10 1 ,969,446.60 2,974,590.00 3,006,145.34 3,048,646.38 2,078,000.00 4,054,280.00 1,066,260.00 1,032,919.79 2,016,628.76 1 ,020,480.00 1 ,850,000.00 2,060,840.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 RETURN RATE 4.000% 3.300% 4.448% 2.750% 4.900% 3.300% 4.720% 4.870% 5.090% 5.125% 5.220% 5.500% 5.400% 5.450% 5.050% 3.372% 5.070% 2.659% 4.200% 5.100% 4.250% 5.500% 1 .680% 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% INTEREST 34,892.59 75,101.47 118,090.00 127,985.08 653,849.91 169,690.84 483,790.01 276,642.22 145,734.17 1,279,114.58 507,609.68 507,178.40 784,610.00 798,687.99 616,853.62 142,375.00 815,903.33 63,690.00 138,741.32 344,093.46 107,217.92 453,918.06 89,458.61 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 INVESTMENT RETURN 1,032,670.41 1,100,750.00 1,110,000.00 2,188,375.00 3,606,000.00 2,233,305.56 3,486,479.17 2,270,222.22 1,133,354.17 6,279,114.58 2,499,402.78 2,476,625.00 3,759,200.00 3,804,833.33 3,665,500.00 2,220,375.00 4,870,183.33 1,129,950.00 1,171,661.11 2,360,722.22 1,127,697.92 2,303,918.06 2,150,298.61 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 TERM (Days) 519 818 973 834 1,637 921 1,248 1,039 1,053 1,823 1,782 1,700 1,777 1,781 1,473 748 1,458 839 1,183 1,203 911 1,631 955 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 INVESTMENT REPORT AS OF JUNE 30,2009 INVESTMENT DATE 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 O O O O 0 O O O SECURITY ALLSTATE LIFE 5.375% NON-CALL NEW YORK LIFE 4.650% NON-CALL BERKSHIRHATWY4.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 PAR VALUE 2,000,000.00 1 1,000,000.00 LL 1,000,000.00 2,000,000.00 \LL 5,000,000.00 1 ,000,000.00 SUB-TOTAL 1 1 4,381 ,080.00 694,900.00 f ACCOUNT 1 ,327,642.81 793.42 - 13,652,000.00 RPORATION 1 1 ,365,000.00 RATION 9,705,000.00 17,821,000.00 SUB-TOTAL 54,566,336.23 INVESTED AMOUNT 2,023,559.81 1,006,649.66 1,023,835.68 2,121,417.76 5,246,650.00 1,003,190.00 116,295,792.84 694,900.00 1 ,327,642.81 793.42 - 13,652,000.00 1 1 ,365,000.00 9,705,000.00 17,821,000.00 54,566,336.23 RETURN RATE 5.100% 4.500% 4.000% 2.850% 3.420% 3.130% 4.384% 0.100% 0.100% 0.000% 0.240% 1.540% 1.540% 1.540% 1.540% 1.487% INTEREST 504,981.86 225,850.34 177,542.10 251,186.41 800,488.89 155,565.56 19,451,281.67 1.90 3.64 - - 584.00 486.17 415.16 762.34 2,253.21 INVESTMENT RETURN 2,528,541.67 1,232,500.00 1,201,377.78 2,372,604.17 6,047,138.89 1,158,755.56 135,747,074.51 694,901 .90 1 ,327,646.45 793.42 - 13,652,584.00 11,365,486.17 9,705,415.16 17,821,762.34 54,568,589.44 TERM (Davs) 1,796 1,826 1,604 1,556 1,664 1,812 1,325 1 1 1 1 1 1 1 1 GRAND TOTAL 563,761,416.23 570,194,073.68 2.967% 20,128,696.67 625,358,823.08 EXHIBIT 8 CITY OF CARLSBAD Fund Equity in Pooled Investments AS OF JUNE 30, 2009 Cash Balance by Fund: General 73,392,667 Special Revenue 46,457,900 Debt Service 5,218,256 Capital Projects: General Capital Construction 65,684,192 Traffic Impact Fees 14,475,155 Public Facilities Fees 42,508,604 Park Development 2,339,620 Transnet Taxes 5,559,718 Drainage Fees 8,281,522 Special Districts 86,295,338 Infrastructure Replacement 46,681,798 Other Capital Construction 5,190,892 Total 277,016,839 Enterprise: Carlsbad Municipal Water District 62,676,130 Sewer Fund 52,635,054 Solid Waste 7,010,857 Storm Water 1,562,131 Golf Course 930,692 Total 124,814,864 Internal Service 26,088,798 Agency Funds 20,054,637 Redevelopment Funds (1) 0 Misc. Special Funds 0 Total General Ledger Balance ** 573,043,961 Reconciling Adjustments (2) (5,338,029) Total Treasurer's Investment Portfolio at Amortized Cost 567,705,932 (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 07/09/09 EXHIBIT 9 CITY OF CARLSBAD INVESTMENT PORTFOLIO As of June 30, 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) Moodv's S&P BARCLAYS BANK AAA AAA BERKSHIRE HATHAWAY AA2 AAA CHEVRON AA1 AA GENERAL ELECTRIC AA2 AA+ JOHNSON & JOHNSON AAA AAA MET LIFE GLOBAL AA2 AA- NEW YORK LIFE AAA AAA PROCTER & GAMBLE AA3 AA- ROYAL BANK OF CANADA AAA AA- 3M AA2 AA- TOYOTA AA1 AA US BANCORP AA3 AA WAL-MART AA2 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 Rating * ALL STATE LIFE BANK OF AMERICA CITIGROUP GENWORTH GLOBAL GOLDMAN SACHS HOME DEPOT MERRILL LYNCH PRINCIPAL LIFE PROTECTIVE LIFE WELLS FARGO Moodv's A1 AA3 A3 A2 A1 BAA1 A2 AA3 A2 A1 S&P AA- A+ A A A BBB+ A A+ AA- AA Purchased 05/30/2008 04/24/2007 06/20/2006 05/07/2008 03/19/2008 06/12/2006 11/03/2006 04/30/2008 07/17/2008 01/30/2008 Carrying Value 2,018,355 1 ,999,372 1 1 ,043,398 2,010,930 1,010,947 2,991 ,298 4,992,257 1 ,000,000 3,000,000 5,085,340 Market Value 2,067,980 2,003,800 1 1 ,031 ,730 1 ,901 ,480 1,024,710 3,105,330 5,007,100 1 ,022,200 2,895,240 5,155,160 * 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. CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF JUNE 30, 2009 WEIGHTINGS FOR CORPORATE AND FEDERAL AGENCY ISSUERS EXHIBIT 10 PERCENTAGE WEIGHTINGS BY CORPORATE NOTE ISSUER ALL STATE LIFE BANK OF AMERICA BARCLAYS BANK BERKSHIRE HATHAWAY CHEVRON CrTIGROUP GENERAL ELECTRIC CAP GENWORTH GLOBAL GOLDMAN SACHS HOME DEPOT JOHNSON & JOHNSON MERRILL LYNCH MET LIFE GLOBAL FUND NEW YORK LIFE PRINCIPAL LIFE PROCTER & GAMBLE PROTECTIVE LIFE ROYAL BANK OF CANADA 3M TOYOTA US BANKCORP WAL-MART WELLS FARGO PERCENTAGE WEIGHTINGS BY FEDERAL AGENCY ISSUER FAMCA FICO FEDERAL FARM CREDO" BANK FEDERAL HOME LOAN BANK DISCOUNT NOTE FEDERAL HOME LOAN BANK FEDERAL HOME LOAN MORTGAGE CORP FEDERAL NATIONAL MORTGAGE ASSOC HOUSING URBAN DEVELOPMENT (HUD) 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,983,918.00 1,590,861.34 8,164,870.82 3,103,177.11 11,022,079.70 27,489,704.89 2,016,628.76 1,025,648.53 2,974,590.00 1,017,457.28 4,884,751.43 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,121,417.76 7,130,057.82 2,952,150.09 15,286,892.81 5,157,732.51 CY ISSUER Investment Cost 6,868,837.32 9,201,103.56 37,506,367.56 5,908,819.44 156,857,532.56 58,426,225.78 39,748,743.08 990,198.00 2,130,980.00 81,660,137.31 Percent of Portfolio' 0.35% 0.35% 0.28% 1.43% 0.54% 1.93% 4.82% 0.35% 0.18% 0.52% 0.18% 0.86% 0.71% 0.35% 0.18% 0.92% 0.53% 0.19% 0.37% 1.25% 0.52% 2.68% 0.90% Percent of Portfolio" 1.20% 1.61% 6.58% 1 .04% 27.51% 10.25% 6.97% 0.17% 0.37% 14.32% $570,194,073.68 City of Carlsbad Bond Proceeds Investment Report June 30, 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 Reserve Fund Trinity Plus Investment Agreement 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 fc CPFA Golf Course Bonds Capitalized Interest Fund Reserve Fund Other BNY Hamilton Money Market BNY Hamilton Money Market BNY Hamilton Money Market Stated Int. Rate 1.51% 1.51% N/A 6.40% 5.83% 6.03% N/A 1.51% 5.36% N/A various various 1.51% various various various various various Maturity Date N/A $ N/A $ N/A $ 09/02/1 1 $ 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 $ N/A $ $ Par Value 945,658 $ 1,180,088 $ 277,633 $ 892,500 $ 869,896 $ 1 ,292,770 $ 4,600,217 $ 2,456,075 $ 953,706 $ 2,700,175 $ 780,104 $ 24,506 $ 89,540 $ 1,071,117 $ 4,044,741 $ $ 1 ,238,329 $ 4,407 $ 23,421,465 $ Cost Fiscal Agent: 945,658 1,180,088 Fiscal Agent: 277,633 892,500 Fiscal Agent: 869,896 Fiscal Agent: 1 ,292,770 Fiscal Agent: 4,600,217 2,456,075 Fiscal Agent: 953,706 Fiscal Agent: 2,700,175 780,104 24,506 Fiscal Agent: 89,540 1,071,117 4,044,741 Fiscal Agent: 1 ,238,329 4,407 23,421,465 Source BNY Western Trust LAIF LAIF US Bank AIM Instit. Fund Services JP Morgan/Chase Bank 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 QIC 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 BNY Western Trust Xn:i—iD3 City of Carlsbad Summary of Outstanding Housing Loans As of June 30,2009 Loans Issued by Loans issued by Developer Loan amount Developer loan due to City amount due to City Borrower 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 Development City-wide (CHAP) Calavera Hills Cherry Tree Walk Serrano Rancho Carlsbad Solamar Homeless shelter Laurel Tree Rancho Carrillo Vista Las Flores Poinsettia Station Villa Loma La Costa Paloma Mariposa Apts Mulberry at Bressi Ranch Village by the Sea Cassia Heights Laguna Point The Bluffs Roosevelt St. Condos Hunter's Point Various Purpose Sale Sale Sale Sale Sale Sale Shelter Rentals Rentals Rentals Rentals Rentals Rentals Rentals Sale Sale Rentals Sale Sale Sale Rentals Assistanc 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 t of loans Issued 133 5 42 90 22 9 1 2 1 1 1 2 1 1 100 11 1 3 8 1 1 1 City to 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 13,000 Developer to # of loans homeowners outstanding 38 150,000 1 452,600 14 4,050,000 34 15 1 1 2 1 1 1 2 1 1 19,660,200 100 4,087,200 7 1 3 8 1 1 1 City loan repaid loan repaid to City to City (1,243,073.00) $ (60,000) (120,000) (302,400) (283,250) (840,133) (2,520,000) (256,410) (135,065) (352,122) (1,481,610) (696,061) (recorded as AR) $436,927.00 $ 15,000 151,200 509,867 496,123 12,661 200,000 781,878 1,157,584 363,948 920,000 730,390 1,373,939 1,060,000 1,840,000 220,000 1,454,276 210,000 200,000 797,539 1,932,000 13,000 (not on City's books) 436,927 30,000 45,000 169,350 320,550 1,530,000 2,039,867 496,123 12,661 200,000 781,878 1,157,584 363,948 920,000 730,390 1,373,939 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 13,000 Type of Loan Payment deferred 15 years. No interest is due unless home is sold before 1 6th year Payment deferred 30 years. No interest is due unless home is sold before 31 th 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 31 th 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 SAB 19,183 /R2007-255 Refer to Council Resolutions 05-264 & 06-160 Refer to Agenda Bill 1 9,41 5 / Resolution 2008- 121 437 $ 20,243,206 $ 28,400,000 235 $ (5,366,874) $(2,923,250) $ 14,876,332 $ 25,476,750 $ 40,353,082 During the 4th quarter of FY2008-09, a $198,750 payment related to the Villa Loma Apts project was received from Bridge Housing and the first loan for the Down Payment & Closing Cost Assistance program ($13,000) was issued. Also, $17,414 in CHAP payments were received. The total combined outstanding loan balance is now $14,876,332. m X3Ci— i DO ro