HomeMy WebLinkAbout2010-08-24; City Council; 20338; Report on City Investments June 30, 2010CITY OF CARLSBAD - AGENDA BILL
8
AB#
MTG.
DEPT.
20,338
8/24/10
TRS
REPORT ON CITY INVESTMENTS
AS OF JUNE 30, 2010
DEPT. HEA0 MftyV-
CITY ATTY. Yfev ,
CITY MGR. //A^L—
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, 2010 is summarized below.
Pooled Investment Portfolio (Cash and Securities)
Par Value
Cost of Investments
Amortized Cost (1)
Market Value (2)
Current Month
566,617,265
574,649,669
571,405,529
580,413,816
Prior Month
569,860,753
578,123,043
574,856,279
583,139,405
(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/10.
The equity portion of the various funds in the total portfolio is summarized in the graph below.
Fund balances are restricted for various purposes. See Exhibit 8 for a more detailed breakdown.
FUND EQUITY IN POOLED INVESTMENTS
(Dollar Amounts in Millions)
General Special Revenue
$73.4 _ $49
Internal Service $28
Agency $js
Enterprise $I25
Capital Projects
$280
Total Treasurer's Investment Portfolio at Amortized Cost
June 30,2010 $571.4 million
FOR CITY CLERKS USE ONLY.
COUNCIL ACTION: APPROVED %
DENIED D
CONTINUED D
WITHDRAWN D
AMENDED D
CONTINUED TO DATE SPECIFIC D
CONTINUED TO DATE UNKNOWN D
RETURNED TO STAFF D
OTHER - SEE MINUTES 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. 2010
Pooled Investment Interest Income
Cash Income Fiscal
Year-to-Date *
Current
Month FYTD
18,322,449
Prior
Month FYTD
16,907,078
Current Month
Income
1,415,371
*The cash income received is adjusted for any accrued interest purchased.
Pooled Investment Performance/Measurement
April 2010
May 2010
June 2010
Average Life
(Years)
1.53
1.46
1.46
Average Yield
To Maturity
2.35%
2.26%
2.24%
Modified Duration
1.460
1.397
1.401
All pooled investments have been made in accordance with the City's Investment Policy adopted
January 2, 1985 and last revised March 23, 2010. All investments were initially made in
accordance with the City's Investment Policy. Events subsequent to the purchase might have
resulted in some investments not being in compliance with the current policy. These events are
typically a change in the City's Investment Policy, a change in the credit rating subsequent to a
purchase, or a temporary reduction in total portfolio assets. See Exhibit 9 for details.
The pooled investment portfolio has the ability to meet the City's cash flow demands for the next
six (6) months.
Investment Portfolio for Bond Proceeds
Par Value
Cost
Current Quarter
21,541,369
21,541,369
Prior Quarter
21,533,504
21,533,504
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
3
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF JUNE 30, 2010
BREAKDOWN BY AMORTIZED COST, MARKET VALUE, CASH INCOME, AND AVERAGE YIELD BY CLASS
AVERAGE YIELD
Class
CD
FN
CP
TR
FA
CN
LAIF
CUSTODY
SWEEP
BANKACCT
TOTALS
Current Month
0
11,443,730
0
86,245,438
294,106,683
97,678,413
78,008,263
45,787
3,294,803
582,412
$571,405,529
Prior Month
0
11,419,433
0
97,290,198
282,045,186
103,926,709
72,224,888
5,071,878
2,154,100
723,886
$574,856,279
CD - Certificate of Deposit
FN - Federal Discount Notes
CP - Corporate Paper
Current Month
0
11,696,280
0
86,476,260
299,644,768
100,665,243
78,008,263
45,787
3,294,803
582,412
$580,413,816
TR - US Treasury
FA - Federal Agency
CN - Corporate Notes
Prior Month
0
11,631,440
0
97,467,000
286,836,433
107,029,779
72,224,888
5,071,878
2,154,100
723,886
$583,139,405
Cash Income
Year to Date
228
0
0
1,240,747
11,030,472
5,409,435
639,537
119
1,911
0
$18,322,449
Current Month Prior
0.00
2.58
0.00
0.56
2.53
4.21
0.56
0.05
0.10
0.10
2.24%
LAIF - Local Agency Investment Fund
Custody - Investment Cash account
SWEEP - General Fund Overnight Cash acccount
Month
0.00
2.58
0.00
0.53
2.63
4.17
0.56
0.05
0.10
0.10
2.26%
rn
X:ri— i
CO
Bank Account - General Fund Cash account
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF JUNE 30, 2010
BREAKDOWN OF MATURITIES BYCLASSIFICA TIONAND LENGTH OF TIME
CLASS
CD
FN
CP
TR
FA
CN
LAIF
CUSTODY
SWEEP
BANK ACCT
TOTALS
% TOTALS
Total within One
WITHIN 6 MONTHS
0
0
0
40,319,455
41,311,945
14,051,954
78,008,263
45,787
3,294,803
582,412
$177,614,618 (1)
30.9%
Year
7 MONTHS TO 1 YEAR
0
956,370
0
27,132,188
10,192,000
24,122,901
0
0
0
0
$62,403,459 (1)
10.9%
$240,018,077 (1)
1 TO 5 YEARS
0
10,126,814
0
19,140,662
244,955,353
60,408,763
0
0
0
0
$334,631,591
58.2%
TOTAL
0
11,083,184
0
86,592,305
296,459,297
98,583,618
78,008,263
45,787
3,294,803
582,412
$574,649,669
100.0%
% TOTAL
0.0%
1.9%
0.0%
15.1%
51.6%
17.2% (2)
13.6%
0.0%
0.6%
0.1%
100.0%
41.8%
POLICY: (1) Not less than $126,950,000 to mature within one year. (2/3rds of current year operating budget of $190,416,000.00)
(2) Policy states that not more than 30% of portfolio is to be invested in corporate notes.x3:t—i
CD
YIELD COMPARISON
PORTFOLIO EX-LAIF VS. LAIF
JULY 1996 -JUNE 20 10
MARKET YIELD CURVE
6/30/08, 6/30/09, 6/30/10
Market Rates
3Mth 2Yr 5Yr
3Mth 2Yr 5Yr 10 Yr
—06/30/2008
-*- 06/30/2009
~o» -06/30/2010
1.73
.18
.17
2.62
1.11
.60
3.33
2.56
1.77
3.97
3.53
2.93
10 Yr
X
1CI—I
CO
Cumulative
Millions $
Cumulative Cash Income
FY09-10
(June 2010)
20
18
16
14
12
10
8
6
4
1.99
1.6 1.38 1'47
1.17
Monthly Interest Income
Millions $
1.24 1'42
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
i—=i Interest Income —*-- Budget Actual
8
3
2
1
X^cI—t
D3
City of Carlsbad
TRANSACTIONS FOR PERIOD:
04/01/10 TO 06/30/10 4TH QUARTER 2009-2010
Trans
Date
BUYS
APRIL
04/02/2010
03/23/2010
04/21/2010
MAY
05/06/2010
05/17/2010
05/19/2010
05/19/2010
05/19/2010
JUNE
06/03/2010
06/03/2010
06/03/2010
06/03/2010
06/03/2010
06/03/2010
06/03/2010
06/03/2010
06/07/2010
Investment
Date
04/02/2010
04/15/2010
04/22/2010
05/17/2010
05/20/2010
05/20/2010
05/20/2010
05/25/2010
06/04/2010
06/04/2010
06/04/2010
06/04/2010
06/04/2010
06/04/2010
06/04/2010
06/04/2010
06/08/2010
TOTAL FOURTH QUARTER
MATURITIES
APRIL
MAY
JUNE
r\
04/22/2008
01/28/2008
04/30/2009
06/05/2009
07/22/2009
03/02/2010
07/25/2007
04/22/2008
05/05/2008
12/21/2007
11/24/2009
06/05/2009
04/21/2009
12/15/2008
02/27/2008
03/16/2009
05/08/2008
Maturity
Date
05/02/2010
10/15/2013
10/28/2014
05/17/2012
06/01/2014
02/26/2015
06/08/2012
06/25/2013
08/15/2012
07/27/2012
08/28/2012
09/14/2012
10/29/2012
07/28/2014
09/29/2014
04/29/2015
07/28/2014
2009-2010
04/07/2010
04/28/2010
04/08/2010
04/15/2010
04/30/2010
04/02/2010
05/03/2010
05/11/2010
05/14/2010
05/28/2010
05/20/2010
05/15/2010
05/31/2010
05/18/2010
06/11/2010
06/16/2010
06/11/2010
Type
CD
FA
FA
FA
CN
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
TR
TR
TR
CD
FA
FA
FA
FA
TR
TR
TR
CN
FA
FA
FA
Security
WELLS FARGO CO
FHLB
FHLB
FFCB
MICROSOFT
FNMA
FHLB
FFCB
FHLB
FHLMC
FHLB
FHLB
FHLB
FNMA
FNMA
FNMA
FNMA
FFCB
FHLMC
US TREASURY
US TREASURY
US TREASURY
WELLS FARGO CO
FFCB
FFCB
FHLB
FNMA
US TREASURY
US TREASURY
US TREASURY
TOYOTA
FHLB
FHLB
FHLB
Call
Date
N/A
N/A
10/28/2011
05/17/2011
N/A
08/26/2010
N/A
N/A
N/A
N/A
N/A
N/A
N/A
07/28/2011
09/29/2010
10/29/2012
07/28/201 1
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
Par
Value
33,000.00
2,000,000.00
2,000,000.00
3,000,000.00
2,000,000.00
2,000,000.00
5,000,000.00
2,000,000.00
1 ,000,000.00
5,000,000.00
4,000,000.00
5,000,000.00
3,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
44,033,000.00
2,000,000.00
1,500,000.00
2,000,000.00
3,000,000.00
5,000,000.00
33,000.00
2,000,000.00
1,000,000.00
3,000,000.00
2,000,000.00
3,000,000.00
3,000,000.00
3,000,000.00
1,000,080.00
1 ,000,000.00
1 ,000,000.00
1 ,000,000.00
Coupon
0.500%
2.000%
2% STEP
1.140%
2.950%
2.125%STEP
1.375%
1 .375%
2.400%
1.125%
1.100%
2.000%
1.375%
3.000%
3.125%
2% STEP
3.000%
2.375%
4.020%
0.000%
4.000%
2.125%
0.500%
4.780%
5.320%
7.625%
3.625%
0.000%
4.500%
2.625%
3.834%
4.250%
1.250%
3.000%
Amount
(Cost)
33,000.00
2,000,000.00
2,015,640.00
3,000,000.00
2,072,820.00
2,007,000.00
5,036,422.30
1 ,993,760.00
1 ,027,049.96
5,004,198.09
4,000,013.10
5,091,850.00
3,012,394.24
2,037,406.00
2,017,420.00
2,018,771.34
2,040,000.00
44,407,745.03
1,984,800.00
1 ,537,935.00
1,991,806.11
3,093,164.06
5,069,531.25
33,000.00
1,981,720.00
1,050,120.00
3,273,695.78
1,996,499.26
2,998,156.25
3,114,140.63
3,069,492.19
997,777.82
1 ,030,795.00
1 ,000,000.00
999,862.00
Return
Rate
0.500%
2.000%
2.950%
1.140%
2.005%
3.192%
1.015%
1.479%
1.150%
1.085%
1.100%
1.180%
1.200%
2.522%
2.908%
2.780%
2.488%
1.674%
2.776%
2.850%
0.437%
0.382%
0.325%
0.500%
5.135%
2.790%
2.950%
3.700%
0.127%
0.452%
0.529%
4.000%
2.849%
1 .250%
3.005%
Interest
1.42
140,000.00
270,026.67
68,400.00
164,982.78
230,802.78
104,515.20
91,031.67
25,683.37
116,583.16
98,253.57
135,927.78
86,720.34
21 1 ,594.00
252,545.28
277,339.77
208,333.33
2,482,741.12
108,220.83
97,740.00
8,193.89
10,114.63
12,754.76
1.42
283,304.44
59,087.78
189,522.97
180,118.80
1,843.75
13,155.57
17,911.66
34,892.59
66,482.78
15,625.00
62,888.00
Investment
Return
33,001.42
2,140,000.00
2,285,666.67
3,068,400.00
2,237,802.78
2,237,802.78
5,140,937.50
2,084,791.67
1 ,052,733.33
5,120,781.25
4,098,266.67
5,227,777.78
3,099,114.58
2,249,000.00
2,269,965.28
2,296,111.11
2,248,333.33
46,890,486.15
2,093,020.83
1,635,675.00
2,000,000.00
3,103,278.69
5,082,286.01
33,001.42
2,265,024.44
1,109,207.78
3,463,218.75
2,176,618.06
3,000,000.00
3,127,296.20
3,087,403.85
1,032,670.41
1,097,277.78
1,015,625.00
1 ,062,750.00
CO
City of Carlsbad
TRANSACTIONS FOR PERIOD:
04/01/10 TO 06/30/10 4TH QUARTER 2009-2010
Trans
Date
Investment
Date
04/17/2009
08/05/2008
10/09/2007
12/24/2009
06/05/2009
09/16/2009
03/19/2008
TOTAL FOURTH QUARTER
CALLS and / or SALES
APRIL
MAY
JUNE
10/22/2007
10/13/2009
06/03/2009
04/27/2009
05/12/2009
05/14/2008
08/17/2009
02/24/2010
05/19/2009
12/30/2009
11/06/2009
06/26/2009
03/10/2010
Maturity
Date
06/11/2010
06/16/2010
06/22/2010
06/24/2010
06/30/2010
06/30/2010
06/15/2010
2009-2010
10/22/2012
10/13/2010
04/01/2011
07/27/201 1
05/12/2011
05/14/2013
05/17/2012
11/18/2014
11/19/2012
12/30/2014
06/29/2012
01/15/2014
06/10/2013
Type
FA
FA
FA
TR
TR
TR
TR
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
CN
FA
Security
FHLB
FHLMC
FHLB
US TREASURY
US TREASURY
US TREASURY
GOLDMAN SACHS
FHLB
FHLB
FMNA
FHLMC
FNMA
FHLB
FHLMC
FHLMC
FNMA
FNMA
FHLMC
PROCTER & GAMBLE
FHLMC
Call
Date
N/A
N/A
N/A
N/A
N/A
N/A
N/A
04/22/2010
04/13/2010
04/01/2010
04/27/2010
05/12/2010
05/15/2010
05/17/2010
05/18/2010
05/19/2010
06/30/2010
06/29/2010
06/28/2010
06/10/2010
Par
Value
1,000,000.00
3,000,000.00
3,000,000.00
6,000,000.00
3,000,000.00
2,000,000.00
1,000,000.00
53,533,080.00
2,000,000.00
2,000,000.00
2,000,000.00
3,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
1 ,000,000.00
5,000,000.00
1 ,000,000.00
Coupon
5.250%
3.500%
4.500%
0.000%
2.875%
2.875%
4.500%
5.000%
0.35% STEP
2.050%
1.750%
1.450%
4.000%
2.000%
3.125%
2.200%
2.300%
2.450%
4.600%
2.000%
Amount
(Cost)
1 ,049,288.56
3,010,680.00
2,991,510.00
5,995,298.33
3,076,875.00
2,040,781.25
1,025,648.53
54,412,577.02
2,000,000.00
2,000,000.00
2,024,200.00
3,000,000.00
1,000,000.00
2,000,000.00
1 ,997,500.00
2,010,896.00
2,000,000.00
2,000,000.00
1,011,600.00
5,246,650.00
1,000,000.00
Return
Rate
0.930%
3.300%
4.610%
0.157%
0.469%
0.282%
3.300%
1.643%
5.000%
0.550%
1.377%
1.750%
1.450%
4.000%
2.047%
3.000%
2.200%
3.150%
1 .997%
3.420%
2.000%
Interest
11,086.44
185,028.33
373,365.00
4,701.67
15,331.49
4,531.25
75,101.47
1,831,004.52
500,000.00
11,000.00
50,738.89
118,125.00
29,000.00
320,000.00
112,500.00
284,937.33
154,000.00
315,000.00
53,256.94
800,488.89
65,000.00
Investment
Return
1 ,060,375.00
3,195,708.33
3,364,875.00
6,000,000.00
3,092,206.49
2,045,312.50
1,100,750.00
56,243,581.54
2,500,000.00
2,011,000.00
2,074,938.89
3,118,125.00
1,029,000.00
2,320,000.00
2,110,000.00
2,295,833.33
2,154,000.00
2,315,000.00
1,064,856.94
6,047,138.89
1,065,000.00
TOTAL FOURTH QUARTER 2009-2010 27,000,000.00 27,290,846.00 4.258% 2,814,047.05 30,104,893.05
INVESTMENT REPORT
AS OF JUNE 30, 2010
INVESTMENT
DATE
07/25/2007
07/15/2008
03/12/2008
02/20/2008
02/13/2008
10/30/2007
02/12/2008
09/18/2007
09/26/2007
05/08/2008
12/05/2008
03/11/2009
09/26/2007
06/01/2009
05/05/2008
04/22/2009
06/03/2009
06/01/2009
06/03/2009
12/05/2008
02/20/2008
05/11/2009
06/22/2009
08/31/2007
05/08/2008
09/17/2008
03/09/2007
08/01/2007
08/31/2007
05/08/2008
03/31/2009
05/11/2009
12/30/2009
06/29/2009
10/01/2009
03/19/2007
01/23/2009
06/22/2009
03/05/2007
03/15/2007
01/23/2009
10/30/2007
12/08/2009
03/15/2007
02/11/2010
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
FNMA5.125% NON-CALL
FFCB 3.200% NON-CALL
FHLB4.44% NON-CALL
FNMA4.70% NON-CALL
FHLB5.00% NON-CALL
FHLB4.7% NON-CALL
FHLB3.190% CALL 8/12/08
FHLMC 5.125% NON-CALL
FHLB5.125% NON-CALL
FHLB3.00% NON-CALL
FHLB 3.375% NON-CALL
FHLB1.4% NON-CALL
FFCB 5.25% NON-CALL
FHLB 1.25% NON-CALL
FHLB 4.375% NON-CALL
FHLB 1.125% NON-CALL
FHLB 4.375% NON-CALL
FHLB 1.050% NON-CALL
FHLB 1.050% NON-CALL
FHLMC 4.50% NON-CALL
FHLB 2.875% NON-CALL
FHLB 1.375% NON-CALL
FHLB 1.125% NON-CALL
FHLB 5.275% NON-CALL
FHLB 5.25% NON-CALL
FHLB 5.25% NON-CALL
FNMA3.64% NON-CALL
FAMCA5.50% NON-CALL
FAMCA5.50% NON-CALL
FAMCA5.5% NON-CALL
FFCB 3.625% NON-CALL
FAMCA 5.50% NON-CALL
FHLMC 5.25% NON-CALL
FHLB 1.625% NON-CALL
FHLB 1.375% NON-CALL
FHLB 5.75% NON-CALL
FHLB 5.75% NON-CALL
FFCB 3.875% NON-CALL
FHLB 5.00% NON-CALL
FHLB 5.00% NON-CALL
FHLB 5.00% NON-CALL
FHLMC 5.50% NON-CALL
FFCB 1.128% NON-CALL
FHLB 4.875% NON-CALL
FFCB .950% CALL 4/26/10
PAR
VALUE
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
3,000,000.00
3,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
3,000,000.00
629,000.00
2,000,000.00
1,000,000.00
1,000,000.00
1,737,000.00
2,000,000.00
1,000,000.00
3,000,000.00
1,000,000.00
3,000,000.00
2,000,000.00
3,000,000.00
1,000,000.00
3,000,000.00
3,000,000.00
3,000,000.00
4,000,000.00
INVESTED
AMOUNT
1,000,640.00
1,000,000.00
1,043,000.00
3,134,430.00
2,688,248.25
1,009,328.80
3,000,000.00
3,048,120.00
2,034,188.23
1,994,876.00
2,032,660.00
2,000,000.00
2,041,700.00
2,014,960.00
1,032,893.26
3,000,000.00
2,101,180.00
2,008,660.00
2,007,180.00
3,119,880.00
2,993,378.76
1,001,350.00
1,988,700.00
1,020,930.00
1,055,434.00
2,132,207.14
1,909,480.00
3,034,380.00
644,775.32
2,116,712.00
1,044,420.00
1,072,970.00
1,853,035.07
2,012,680.00
1,006,100.00
3,111,810.00
1,097,950.00
3,152,520.00
2,018,200.00
3,032,352.00
1,077,520.00
3,117,300.00
3,014,854.10
3,018,777.00
4,002,000.00
RETURN
RATE
5.100%
3.200%
2.559%
2.786%
2.710%
4.337%
3.190%
4.530%
4.500%
3.115%
2.420%
1.400%
4.490%
0.700%
2.980%
1.125%
0.701%
0.750%
0.800%
2.470%
2.950%
1.305%
1.420%
4.761%
3.345%
2.720%
4.805%
5.175%
4.781%
3.545%
1.639%
2.050%
0.900%
1.315%
1.375%
4.800%
1.818%
1.490%
4.773%
4.730%
1.958%
4.390%
0.850%
4.720%
0.921%
INTEREST
150,405.14
64,000.00
62,326.67
209,453.33
175,897.58
121,226.76
239,250.00
402,452.92
268,756.21
145,457.34
86,402.50
41,922.22
269,508.33
19,276.11
74,901.88
50,625.00
20,104.72
21,906.67
23,270.00
154,245.00
270,402.49
25,653.47
55,112.50
181,976.25
106,732.67
154,501.19
406,997.78
618,286.67
118,184.21
233,760.22
85,530.00
46,807.78
25,313.30
54,847.78
19,261.11
648,148.33
49,313.89
100,323.75
432,911.11
640,148.00
53,868.89
522,075.00
46,552.13
647,473.00
62,916.67
INVESTMENT
RETURN
1,151,045.14
1,064,000.00
1,105,326.67
3,343,883.33
2,864,145.83
1,130,555.56
3,239,250.00
3,450,572.92
2,302,944.44
2,140,333.34
2,119,062.50
2,041 ,922.22
2,311,208.33
2,034,236.11
1,107,795.14
3,050,625.00
2,121,284.72
2,030,566.67
2,030,450.00
3,274,125.00
3,263,781.25
1,027,003.47
2,043,812.50
1,202,906.25
1,162,166.67
2,286,708.33
2,316,477.78
3,652,666.67
762,959.53
2,350,472.22
1,129,950.00
1,119,777.78
1,878,348.37
2,067,527.78
1,025,361.11
3,759,958.33
1,147,263.89
3,252,843.75
2,451,111.11
3,672,500.00
1,131,388.89
3,639,375.00
3,061,406.23
3,666,250.00
4,064,916.67
TERM
(Days)
1,077
730
866
889
898
1,015
912
1,070
1,080
855
644
548
1,083
500
900
548
506
532
530
741
1,115
717
711
1,379
1,128
996
1,588
1,444
1,414
1,163
836
795
565
758
673
1,610
934
794
1,649
1,639
959
1,416
664
1,665
622
x
1CI—I
DO
INVESTMENT REPORT
AS OF JUNE 30, 2010
INVESTMENT
DATE TYPE SECURITY
12/07/2009 FA FHLB 4.25% NON-CALL
12/08/2009 FA FHLB 4.25% NON-CALL
03/19/2007 FA FHLB 4.875% NON-CALL
12/30/2009 FA FNMA 1.0% NON-CALL
12/09/2009 FA FFCB .875% NON-CALL
06/29/2009 FA FFCB 2.0% NON-CALL
05/21/2007 FA FFCB 4.875% NON-CALL
05/17/2010 FA FFCB 1.14% CALL 5/17/11
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
05/20/2010 FA FHLB 1.375% NON-CALL
10/20/2009 FA FFCB 2.125% NON-CALL
11/25/2009 FA FFCB 5.45% NON-CALL
01/20/2010 FA FHLMC 5.125% NON-CALL
10/19/2009 FA FFCB 1.55% CALL 10/19/10
01/19/2010 FA FHLMC 1.625% CALL 7/19/10
12/10/2007 FA FHLB 5.58% CALL 7/20/10
01/20/2010 FA FNMA 1.5% CALL 7/20/10
08/05/2008 FA FFCB 3.950% NON-CALL
03/24/2010 FA FHLB 1.25% NON-CALL
08/12/2009 FA FHLB 2.0% CALL 7/27/10
10/27/2009 FA FNMA 1.70% CALL 10/27/10
06/04/2010 FA FHLMC 1.125% NON-CALL
07/30/2007 FA FHLB 5.52% CALL 7/30/10
12/24/2009 FA FNMA 5.00% NON-CALL
01/25/2010 FA FAMCA 2.1% NON-CALL
01/20/2010 FA FNMA 1.75% NON-CALL
03/16/2010 FA FNMA 1.75% NON-CALL
08/13/2008 FA FHLB 4.35% CALL 8/13/10
01/29/2009 FA FHLB 4.625% NON-CALL
12/24/2009 FA FHLB 4.625% NON-CALL
06/04/2010 FA FHLB 2.4% NON-CALL
11/17/2009 FA FHLB 1.75% CALL 8/17/10
02/27/2009 FA FNMA 2.625% CALL 8/27/10
06/04/2010 FA FHLB 1.1 % NON-CALL
09/04/2009 FA FNMA 2.50% CALL 9/7/10
05/05/2008 FA FHLB 5.00% NON-CALL
08/22/2008 FA FHLB 4.5% NON-CALL
06/04/2010 FA FHLB 2.00% NON-CALL
03/08/2010 FA FHLMC 2.125% NON-CALL
10/01/2009 FA FFCB 1.80% NON-CALL
11 /25/2009 FA FFCB 1.80% NON-CALL
12/24/2009 FA FHLMC 2.0% CALL 9/28/10
PAR
VALUE
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
2,000,000.00
3,000,000.00
1,000,000.00
1,000,000.00
3,000,000.00
5,000,000.00
3,000,000.00
2,000,000.00
1,000,000.00
3,000,000.00
3,000,000.00
1,000,000.00
1,250,000.00
2,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
5,000,000.00
1,770,000.00
1,037,000.00
1,000,000.00
1,000,000.00
3,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
4,000,000.00
2,000,000.00
1,175,000.00
1,000,000.00
5,000,000.00
3,000,000.00
1,000,000.00
3,000,000.00
3,000,000.00
INVESTED
AMOUNT
1,061,850.00
2,126,060.00
3,009,690.00
2,994,090.00
997,136.00
4,036,800.00
1,987,880.00
3,000,000.00
2,130,980.00
3,399,498.48
1,005,040.00
1,005,254.43
3,050,958.11
5,036,422.30
3,049,023.21
2,210,347.28
1 ,092,760.00
2,995,200.00
3,000,000.00
1 ,037,000.00
1,249,375.00
2,002,900.00
2,000,352.89
1,988,600.00
998,800.00
5,004,198.09
1,770,000.00
1,127,519.73
1,015,908.69
1,009,004.81
3,034,050.00
1,999,500.00
2,150,960.00
1,078,810.00
1,027,049.96
2,000,000.00
2,000,000.00
4,000,013.10
2,000,000.00
1,238,814.19
1,022,730.00
5,091,850.00
3,058,800.00
1,003,470.00
3,032,750.01
3,014,100.00
RETURN
RATE
1.020%
0.956%
4.795%
1.105%
1.020%
1.630%
5.015%
1.140%
5.235%
1.534%
5.255%
5.250%
3.900%
1.015%
1.496%
1.280%
1.320%
1.610%
1.625%
4.677%
1.520%
3.910%
1.243%
2.200%
.745%
.085%
5.520%
.567%
.460%
.390%
.268%
4.357%
2.391%
1.567%
1.150%
1.750%
2.625%
1.100%
2.500%
3.640%
3.889%
.180%
.336%
.680%
.405%
.824%
INTEREST
20,552.78
38,509.44
672,403.75
62,826.67
20,364.00
167,200.00
489,057.50
68,400.00
524,632.22
128,989.85
256,692.64
256,478.21
460,552.31
104,515.20
120,622.62
70,024.94
34,653.19
132,675.00
121,875.00
220,300.00
47,500.00
310,466.67
58,188.78
129,733.33
47,950.00
116,583.16
488,520.00
44,578.33
37,466.31
35,717.41
91,950.00
348,500.00
176,901.11
43,367.08
25,683.37
96,250.00
183,750.00
98,253.57
150,416.67
192,237.89
160,020.00
135,927.78
102,877.08
50,180.00
120,099.99
151,566.67
INVESTMENT
RETURN
1,082,402.78
2,164,569.44
3,682,093.75
3,056,916.67
1,017,500.00
4,204,000.00
2,476,937.50
3,068,400.00
2,655,612.22
3,528,488.33
1,261,732.64
1,261,732.64
3,511,510.42
5,140,937.50
3,169,645.83
2,280,372.22
1,127,413.19
3,127,875.00
3,121,875.00
1,257,300.00
1 ,296,875.00
2,313,366.67
2,058,541.67
2,118,333.33
1,046,750.00
5,120,781.25
2,258,520.00
1,172,098.06
1 ,053,375.00
1 ,044,722.22
3,126,000.00
2,348,000.00
2,327,861.11
1,122,177.08
1,052,733.33
2,096,250.00
2,183,750.00
4,098,266.67
2,150,416.67
1,431,052.08
1,182,750.00
5,227,777.78
3,161,677.08
1,053,650.00
3,152,850.00
3,165,666.67
TERM
(Days)
708
707
1,705
693
730
932
1,788
731
1,764
947
1,780
1,780
1,424
750
972
939
907
1,004
912
1,684
912
1,448
856
1,080
1,004
784
1,827
952
928
933
878
1,461
1,294
965
803
1,004
1,277
816
1,099
1,593
1,484
833
928
1,089
1,034
1,009
INVESTMENT REPORT
AS OF JUNE 30, 2010
INVESTMENT
DATE
05/11/2009
12/10/2007
12/07/2009
06/04/2010
06/03/2008
12/14/2009
01/14/2008
10/20/2009
11/25/2009
03/10/2008
11/25/2009
08/26/2009
10/20/2009
10/20/2009
11/10/2008
08/13/2009
12/24/2009
05/25/2010
12/28/2009
12/03/2008
08/27/2008
08/21/2009
01/26/2010
02/19/2010
08/19/2009
02/26/2010
02/26/2010
11/12/2008
03/10/2010
12/17/2008
03/24/2010
02/23/2010
04/15/2010
10/19/2009
11/26/2008
01/20/2009
02/12/2010
02/12/2010
03/24/2010
10/20/2009
01/21/2010
06/04/2010
06/08/2010
11/05/2009
03/24/2010
03/24/2010
TYPI
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
FA
SECURITY
FHLMC 3.875% NON-CALL
FFCB4.5% NON-CALL
FNMA 1.875% CALL 10/29/10
FHLB 1.375% NON-CALL
FNMA 6.41% NON-CALL
FHLB 1.0% CALL 12/14/11 STEP
FHLB 4.25% CALL 10/14/08
FFCB 5.15% NON-CALL
FHLB 2.0% CALL 8/25/10
FHLB 3.50% NON-CALL
FHLB 2.35% CALL 9/15/10
FHLMC 2.5% CALL 4/8/11
FHLMC 4.25% NON-CALL
FHLMC 4.0% NON-CALL
FHLB 5.375% NON-CALL
FHLB 4.25% NON-CALL
FNMA 2.125% CALL 12/24/10
FFCB 1.375% NON-CALL
FHLB 1.85% NON-CALL
FFCB 4.625% CALL 7/8/10
FNMA 4.375% NON-CALL
FHLMC 2.4% CALL 7/23/10
FHLB 2.125% CALL 1/26/11
FHLMC 1.0% CALL 2/15/11
FFCB 2.7% NON-CALL
FNMA 2.05% CALL 8/26/10
FHLMC 2.125% CALL 8/26/10
FHLB 4.0% NON-CALL
FHLB 2.1% CALL
FHLB 4.375% NON-CALL
FHLMC 4.125% NON-CALL
FFCB 3.875% NON-CALL
FHLB 2.00% NON-CALL
FFCB 5.350% NON-CALL
FHLB 3.5% CALL 11/26/10
FHLB 3.125% NON-CALL
FFCB 3.00% NON-CALL
FNMA 2.125% CALL 10/28/11
FHLB 2.5% NON-CALL
FFCB 4.375% NON-CALL
FNMA 3.03% CALL 7/21/10
FNMA 3.00% CALL 7/28/11
FNMA 3.00% CALL 7/28/11
FNMA 3.3% CALL 7/30/10
FHLB 5.5% NON-CALL
FHLB 5.25% NON-CALL
PAR
VALUE
1,000,000.00
2,000,000.00
1,000,000.00
3,000,000.00
1,807,000.00
1,000,000.00
3,000,000.00
1,000,000.00
1,000,000.00
3,000,000.00
1,000,000.00
2,000,000.00
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
2,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
3,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
3,000,000.00
3,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
1,100,000.00
3,000,000.00
2,000,000.00
INVESTED
AMOUNT
1,063,510.00
2,034,780.00
1,003,900.00
3,012,394.24
1,990,388.82
999,500.00
3,000,000.00
1,102,490.00
999,531.25
2,963,940.00
1 ,009,500.00
2,008,000.00
536,967.86
532,794.50
1 ,065,788.37
2,130,988.03
1 ,000,000.00
1 ,993,760.00
1,987,226.45
2,053,420.00
2,035,600.00
1,991,200.00
2,000,000.00
1 ,000,000.00
1,005,669.88
2,000,000.00
1,000,000.00
1,007,890.00
1,000,000.00
2,154,940.00
3,222,330.00
1,065,180.00
2,000,000.00
2,235,072.36
2,000,000.00
2,047,941.08
1,028,536.49
1,014,759.55
3,016,423.52
3,234,480.00
1,001,875.00
2,037,406.00
2,040,000.00
1,110,340.00
3,395,255.41
2,231,960.00
RETURN
RATE
1.928%
4.100%
1.736%
1.200%
3.890%
1.673%
4.250%
1.926%
2.015%
3.765%
2.051%
2.384%
2.100%
2.120%
3.800%
2.450%
2.125%
1 .479%
2.040%
3.983%
3.970%
2.518%
2.125%
2.054%
2.550%
2.050%
2.125%
3.818%
2.100%
2.625%
1.930%
2.000%
2.000%
2.264%
4.361%
2.600%
2.250%
3.167%
2.363%
2.595%
2.985%
2.522%
2.488%
3.084%
2.323%
2.490%
INTEREST
67,701.81
401,970.00
50,370.83
86,720.34
331,405.40
50,500.00
637,500.00
67,316.94
65,468.75
560,476.67
68,180.56
172,833.33
39,296.03
40,094.39
181,163.02
195,081.41
74,375.00
91,031.67
142,273.55
371,823.06
392,177.78
197,066.67
148,750.00
72,388.89
102,330.12
143,500.00
74,375.00
184,776.67
73,500.00
259,712.78
211,826.25
75,181.11
140,000.00
193,522.08
440,000.00
258,135.31
91,463.51
121,601.56
300,034.82
381,665.83
134,475.00
211,594.00
208,333.33
161,580.83
328,452.92
237,040.00
INVESTMENT
RETURN
1,131,211.81
2,436,750.00
1,054,270.83
3,099,114.58
2,321,794.22
1,050,000.00
3,637,500.00
1,169,806.94
1,065,000.00
3,524,416.67
1,077,680.56
2,180,833.33
576,263.89
572,888.89
1,246,951.39
2,326,069.44
1,074,375.00
2,084,791.67
2,129,500.00
2,425,243.06
2,427,777.78
2,188,266.67
2,148,750.00
1,072,388.89
1,108,000.00
2,143,500.00
1,074,375.00
1,192,666.67
1,073,500.00
2,414,652.78
3,434,156.25
1,140,361.11
2,140,000.00
2,428,594.44
2,440,000.00
2,306,076.39
1,120,000.00
1,136,361.11
3,316,458.34
3,616,145.83
1,136,350.00
2,249,000.00
2,248,333.33
1,271,920.83
3,723,708.33
2,469,000.00
TERM
(Days)
1,238
1,773
1,057
878
1,624
1,096
1,827
1,206
1,188
1,824
1,206
1,321
1,310
1,331
1,677
1,401
1,278
1,127
1,278
1,678
1,785
1,432
1,277
1,273
1,461
1,277
1,277
1,759
1,280
1,731
1,283
1,322
1,279
1,463
1,826
1,788
1,461
1,536
1,542
1,714
1,642
1,515
1,511
1,728
1,603
1,633
INVESTMENT REPORT
AS OF JUNE 30, 2010
INVESTMENT
DATE
03/22/2010
03/24/2010
09/24/2009
06/04/2010
04/22/2010
05/20/2010
03/09/2010
03/12/2010
06/04/2010
03/12/2009
02/11/2009
02/18/2009
02/25/2009
03/02/2009
03/02/2009
03/09/2010
06/05/2009
09/16/2009
11/24/2009
11/24/2009
12/24/2009
07/22/2009
09/02/2009
11/24/2009
01/20/2010
09/02/2009
11/24/2009
02/12/2010
10/01/2009
10/19/2009
10/19/2009
12/30/2009
10/28/2009
09/24/2009
10/28/2009
11/24/2009
01/20/2010
11/24/2009
02/23/2010
TYPE
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
TR
TR
TR
TR
SECURITY
FNMA 2.570% CALL
FFCB 3.0% NON-CALL
FNMA 2.0% CALL 9/23/1 1 STEP
FNMA 3.125% CALL 9/29/10
FHLB 2.0% CALL 10/28/11 STEP
FNMA 2.125% QRTLY CALL STEP
FNMA 3.0% CALL
FHLMC 1 .0% STEP CALL 3/23/1 1
FNMA 2.00% CALL 10/29/12 STEP
SUB-TOTAL
FICO STRIP 0.00% NON-CALL
FICO STRIP 0.00% NON-CALL
FICO STRIP 0.00% NON-CALL
FICO STRIP 0.00% NON-CALL
FICO 0.0% NON-CALL
FICO 0.0% NON-CALL
FICO 0.0% NON-CALL
SUB-TOTAL
Federal Investments Total
US TREASURY 2.750%
US TREASURY 2.750%
US TREASURY 00%
US TREASURY 00%
US TREASURY 00%
US TREASURY 2.00%
US TREASURY 1.50%
US TREASURY 1.50%
US TREASURY 0.0%
US TREASURY 1.25%
US TREASURY 1.25%
US TREASURY .875%
US TREASURY 0.875%
US TREASURY 0.875%
US TREASURY 0.875%
US TREASURY 0.875%
US TREASURY 0.875%
US TREASURY 1.1 250%
US TREASURY 1.1 250%
US TREASURY 1.1 250%
US TREASURY 1.00%
US TREASURY 1 .00%
US TREASURY 1.00%
PAR
VALUE
2,000,000.00
2,000,000.00
3,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
4,000,000.00
2,000,000.00
290,055,000.00
1,000,000.00
2,000,000.00
1 ,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
12,000,000.00
302,055,000.00
3,000,000.00
2,000,000.00
4,000,000.00
2,000,000.00
5,000,000.00
3,000,000.00
5,000,000.00
2,000,000.00
4,000,000.00
5,000,000.00
3,000,000.00
2,000,000.00
3,000,000.00
3,000,000.00
3,000,000.00
4,000,000.00
3,000,000.00
4,000,000.00
3,000,000.00
4,000,000.00
1,000,000.00
5,000,000.00
3,000,000.00
INVESTED
AMOUNT
2,000,000.00
2,047,400.80
3,000,000.00
2,017,420.00
2,015,640.00
2,007,000.00
1 ,000,000.00
4,000,000.00
2,018,771.34
296,459,297.16
956,370.00
1 ,889,240.00
916,713.56
1 ,826,280.00
1,818,680.00
1,793,820.00
1,882,080.00
11,083,183.56
307,542,480:72
3,077,578.13
2,042,343.75
3,994,500.00
1,996,801.67
4,990,520.83
3,052,031.25
5,062,500.00
2,023,125.00
3,991,946.67
5,048,828.13
3,029,179.69
2,010,100.00
3,014,531.25
3,012,656.25
3,011,718.75
4,010,625.00
3,008,320.31
4,018,593.75
3,018,398.44
4,037,343.75
1,005,625.00
5,031,445.31
3,016,170.00
RETURN
RATE
2.570%
2.440%
3.163%
2.908%
2.950%
3.192%
3.000%
3.400%
2.780%
2.526%
2.200%
2.300%
2.710%
2.850%
3.000%
3.050%
1.850%
2.576%
0.501%
0.317%
0.183%
0.193%
0.254%
0.537%
0.419%
0.259%
0.244%
0.461%
0.291%
0.301%
0.509%
0.544%
0.587%
0.661%
0.699%
0.859%
0.755%
0.538%
0.630%
0.641%
0.660%
INTEREST
231,300.00
222,265.87
479,833.33
252,545.28
270,026.67
308,083.33
150,000.00
680,000.00
277,339.77
27,334,958.56
43,630.00
110,760.00
83,286.44
173,720.00
181,320.00
206,180.00
117,920.00
916,816.44
28,251,775.00
17,684.30
5,631.79
5,500.00
3,198.33
9,479.17
19,444.16
24,524.46
4,886.05
8,053.33
28,869.96
8,935.06
5,321.27
20,421.20
21,012.23
24,103.07
33,125.00
33,421.49
60,889.95
38,096.13
34,680.71
9,673.91
56,814.36
31,797.03
INVESTMENT
RETURN
2,231,300.00
2,269,666.67
3,479,833.33
2,269,965.28
2,285,666.67
2,315,083.33
1,150,000.00
4,680,000.00
2,296,111.11
323,794,255.72
1,000,000.00
2,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
12,000,000.00
335,794,255.72
3,095,262.43
2,047,975.54
4,000,000.00
2,000,000.00
5,000,000.00
3,071,475.41
5,087,024.46
2,028,011.05
4,000,000.00
5,077,698.09
3,038,114.75
2,015,421.27
3,034,952.45
3,033,668.48
3,035,821.82
4,043,750.00
" 3,041,741.80
4,079,483.70
3,056,494.57
4,072,024.46
1,015,298.91
5,088,259.67
3,047,967.03
TERM
(Days)
1,645
1,643
1,825
1,578
1,650
1,743
1,826
1,837
1,790
1,209
744
908
1,178
1,171
1,166
1,314
1,206
1,098
2,307
421
318
275
303
187
435
424
341
302
454
371
322
487
469
497
456
580
644
610
583
557
645
584
INVESTMENT REPORT
AS OF JUNE 30,2010
INVESTMENT
DATE
03/24/2010
11/10/2008
11/12/2008
11/01/2007
03/19/2008
02/03/2006
01/31/2008
03/16/2007
10/11/2007
09/28/2007
02/17/2006
03/30/2006
06/20/2006
04/19/2006
06/12/2006
04/16/2007
04/21/2009
05/21/2007
04/02/2009
05/30/2008
05/30/2008
05/12/2009
05/29/2007
08/14/2009
04/28/2009
08/17/2009
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
02/08/2010
07/17/2008
08/31/2007
10/31/2007
11/23/2007
01/30/2008
04/24/2008
TYPE
TR
TR
TR
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
•CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
CN
SECURITY
US TREASURY 1.00%
US TREASURY 3.125%
US TREASURY 3.125%
SUB-TOTAL
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-CALi
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
BERKSHIRHATWY4.00% NON-CALL
BERKSHIRHATWY4.00% NON-CALL
PRINCIPAL LIFE INC 4.5% NON-CALL
GENERAL ELECTRIC 6.00% NON-CALL
GENERAL ELECTRIC 6.00% NON-CALL
GENERAL ELECTRIC 6.00% NON-CALL
PROTECTIVE LIFE 5.050% NON-CALL
JOHNSON & JOHNSON 5.15% NON-CALL
GENERAL ELECTRIC 5.250% NON-CALL
GENERAL ELECTRIC 5.250% NON-CALL
WELLS FARGO 5.250% NON-CALL
MET LIFE GLOBAL FUNDING 5.125% NON-CAU
PAR
VALUE
8,000,000.00
1,000,000.00
1,000,000.00
86,000,000.00
1,000,000.00
2,000,000.00
3,000,000.00
2,000,000.00
3,000,000.00
2,000,000.00
1,000,000.00
5,000,000.00
2,000,000.00
2,000,000.00
3,000,000.00
3,000,000.00
3,000,000.00
2,000,000.00
4,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
1,850,000.00
2,000,000.00
2,000,000.00
2,250,000.00
5,956,000.00
3,000,000.00
2,000,000.00
3,000,000.00
1,575,000.00
1,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
3,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
INVESTED
AMOUNT
8,025,312.50
1,031,328.00
1,030,781.25
86,592,304.68
991,910.00
2,060,389.92
2,952,150.09
2,063,614.72
3,002,689.16
1,993,580.00
987,620.00
5,000,000.00
1,991,793.10
1,969,446.60
2,974,590.00
3,006,145.34
3,048,646.38
2,078,000.00
4,054,280.00
1,066,260.00
1,032,919.79
2,016,628.76
1,020,480.00
1,850,000.00
2,066,260.00
2,060,840.00
2,427,570.00
6,187,688.40
3,089,347.40
2,089,414.35
3,103,177.11
1,590,861.34
1,022,563.95
2,039,340.00
1 ,000,000.00
1,033,437.31
1,052,958.51
2,174,860.00
3,000,000.00
1,017,457.28
2,036,663.70
2,065,283.50
1,042,814.41
1,003,232.48
RETURN
RATE
0.801%
2.430%
2.452%
0.561%
4.448%
2.750%
4.900%
3.300%
4.720%
4.870%
5.090%
5.125%
5.220%
5.500%
5.400%
5.450%
5.050%
3.372%
5.070%
2.659%
4.200%
5.100%
4.250%
5.500%
1.500%
1.680%
1.800%
4.970%
5.100%
4.700%
2.180%
2.330%
3.200%
3.300%
4.500%
5.200%
4.550%
2.167%
5.050%
4.750%
4.830%
4.500%
4.240%
5.050%
INTEREST
102,864.30
118,792.86
121,777.13
848,997.25
118,090.00
127,985.08
653,849.91
169,690.84
483,790.01
276,642.22
145,734.17
1,279,114.58
507,609.68
507,178.40
784,610.00
798,687.99
616,853.62
142,375.00
815,903.33
63,690.00
138,741.32
344,093.46
107,217.92
453,918.06
69,073.33
89,458.61
99,695.62
1,483,867.09
676,360.93
409,960.65
187,485.39
104,626.16
96,769.38
198,882.22
178,375.00
253,896.02
189,541.49
107,473.33
605,158.33
237,753.83
484,836.30
449,799.83
205,539.76
251 ,024.46
INVESTMENT
RETURN
8,128,176.80
1,150,120.86
1,152,558.38
87,441,301.93
1,110,000.00
2,188,375.00
3,606,000.00
2,233,305.56
3,486,479.17
2,270,222.22
1,133,354.17
6,279,114.58
2,499,402.78
2,476,625.00
3,759,200.00
3,804,833.33
3,665,500.00
2,220,375.00
4,870,183.33
1,129,950.00
1,171,661.11
2,360,722.22
1,127,697.92
2,303,918.06
2,135,333.33
2,150,298.61
2,527,265.62
7,671,555.49
3,765,708.33
2,499,375.00
3,290,662.50
1,695,487.50
1,119,333.33
2,238,222.22
1,178,375.00
1,287,333.33
1,242,500.00
2,282,333.33
3,605,158.33
1,255,211.11
2,521,500.00
2,515,083.33
1,248,354.17
1,254,256.94
TERM
(Days)
586
1,755
1,783
553
973
834
1,637
921
1,248
1,039
1,053
1 ,823
1,782
1,700
1,777
1,781
1,473
748
1,458
839
1,183
1,203
911
1,631
824
955
857
1,793
1,588
1,553
1,026
1,035
1,090
1,088
1,447
1,750
1,477
858
1,459
1,811
1,815
1,792
1,728
1,812
INVESTMENT REPORT
AS OF JUNE 30, 2010
INVESTMENT
DATE
05/07/2008
05/12/2009
05/30/2008
05/09/2008
12/23/2008
05/12/2009
05/29/2009
05/20/2010
TYPI
CN
CN
CN
CN
CN
CN
CN
CN
0
O
0
0
O
0
0
O
SECURITY
MET LIFE GLOBAL FUNDING 5
WAL-MART 4.250% NON-CALL
ALLSTATE LIFE 5.375% NON-CALL
NEW YORK LIFE 4.650% NON-CALL
BERKSHIRHATWY4.60% NON-CALL
3 M 4.375% NON-CALL
WAL-MART 3.20% NON-CALL
MICROSOFT 2.95% 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
>/o NON-CALl
L
.L
SUB-TOTAL
r ACCOUNT
RPORATION
'RATION
SUB-TOTAL
PAR
VALUE
2,000,000.00
1,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
96,631,000.00
581,847.00
3,294,803.36
564.98
45,786.50
21,862,000.00
14,238,000.00
20,279,262.89
21,629,000.00
81,931,264.73
INVESTED
AMOUNT
2,019,402.04
1,047,829.91
2,023,559.81
1,006,649.66
1,023,835.68
2,121,417.76
1,003,190.00
2,072,820.00
98,583,618.46
581,847.00
3,294,803.36
564.98
45,786.50
21,862,000.00
14,238,000.00
20,279,262.89
21,629,000.00
81,931,264.73
RETURN
RATE
4.900%
2.950%
5.100%
4.500%
4.000%
2.850%
3.130%
2.005%
4.214%
0.100%
0.100%
0.000%
0.050%
0.560%
0.560%
0.560%
0.560%
0.538%
INTEREST
485,410.46
118,982.59
504,981.86
225,850.34
177,542.10
251,186.41
155,565.56
164,982.78
16,999,855.42
1.59
9.03
-
0.06
340.08
221.48
315.46
336.45
1,224.15
INVESTMENT
RETURN
2,504,812.50
1,166,812.50
2,528,541.67
1,232,500.00
1,201,377.78
2,372,604.17
1,158,755.56
2,237,802.78
115,583,473.88
581,848.59
3,294,812.39
564.98
45,786.56
21,862,340.08
14,238,221.48
20,279,578.35
21,629,336.45
81,932,488.88
TERM
(Days)
1,799
1,434
1,796
1,826
1,604
1,556
1,812
1,473
1,397
1
1
1
1
1
1
1
1
GRAND TOTAL 566,617,264.73 574,649,668.59 2.237% 46,101,851.82 620,751,520.41
EXHIBIT 8
CITY OF CARLSBAD
Fund Equity in Pooled Investments
AS OF JUNE 30, 2010
Cash Balance by Fund:
General 74,985,965
Special Revenue 49,792,998
Debt Service 0
Capital Projects:
General Capital Construction 68,248,103
Traffic Impact Fees 16,534,847
Public Facilities Fees 44,533,967
Park Development 2,390,826
Transnet Taxes 6,262,503
Drainage Fees 6,666,787
Special Districts 74,638,845
Infrastructure Replacement 54,043,257
Redevelopment 2,469,326
Other Capital Construction 5,096,581
Total 280,885,041
Enterprise:
Carlsbad Municipal Water District 66,953,962
Sewer Fund 48,691,966
Solid Waste 7,015,553
Storm Water 2,290,073
Golf Course 221,892
Total 125,173,447
Internal Service 28,871,203
Agency Funds 16,191,526
Misc. Special Funds 0
Total General Ledger Balance ** 575,900,180
Reconciling Adjustments (1) (4,494,652)
Total Treasurer's Investment Portfolio at Amortized Cost 571,405,529
(1) The Reconciling Adjustments consist of differences between the General Ledger which is prepared
on an accrual basis and the Treasurer's report which is prepared on the cash basis. Accrued Interest,
amortized premium or discounts and outstanding checks and deposits in transit are not included in the
Treasurer's summary. Differences between the time journal entries are posted and the time this
report is produced may also be a component of the adjustment.
** Figures based on best estimate at the time report run on 7/09/10
17
EXHIBIT 9
CITY OF CARLSBAD INVESTMENT PORTFOLIO
As of June 30, 2010
CORPORATE NOTE AND COMMERCIAL PAPER RATINGS
Corporate Note Investments Meeting the Current Investment Policy:
(Ratings must be AA or better by both Moody's and S&P)
Moodv's S&P
AAA
AA2
AA1
AA2
AAA
AA3
AAA
AAA
AAA
AAA
AA2
AA1
AA2
AAA
AA-
AA
AA+
AAA
AA-
AAA
AAA
AA-
AAA
AA-
AA
AA
BARCLAYS BANK
BERKSHIRE HATHAWAY
CHEVRON
GENERAL ELECTRIC
JOHNSON & JOHNSON
MET LIFE GLOBAL
MICROSOFT
NEW YORK LIFE
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
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
BAA1
AA3
A2
AA3
A1
S&P
AA-
A
A
BBB+
A+
AA-
A+
AA-
Purchased
05/30/2008
06/20/2006
05/07/2008
06/12/2006
04/30/2008
07/17/2008
02/03/2006
01/30/2008
Carrying
Value
2,013,564
11,028,378
2,005,974
2,996,519
1,000,000
3,000,000
2,999,171
4,035,296
Market
Value
2,192,940
11,223,190
2,044,660
3,075,540
1,021,980
3,141,120
3,006,450
4,116,840
EXHIBIT 10
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF JUNE 30, 2010
WEIGHTINGS FOR CORPORATE AND FEDERAL AGENCY ISSUERS
PERCENTAGE WEIGHTINGS BY CORPORATE NOTE ISSUER
ALL STATE LIFE
BARCLAYS BANK
BERKSHIRE HATHAWAY
CHEVRON
CITIGROUP
GENERAL ELECTRIC CAP
GENWORTH GLOBAL
HOME DEPOT
JOHNSON & JOHNSON
MET LIFE GLOBAL FUND
MICROSOFT
NEW YORK LIFE
PRINCIPAL LIFE
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
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
4,085,739.63
3,103,177.11
11,022,079.70
27,634,444.89
2,016,628.76
2,974,590.00
1,017,457.28
4,043,114.52
2,072,820.00
1,994,269.66
1,000,000.00
3,000,000.00
1,066,260.00
2,066,260.00
2,121,417.76
8,559,850.00
2,952,150.09
10,099,588.99
4,139,348.92
ENCY ISSUER
Investment Cost
7,884,746.01
11,083,183.55
56,371,790.13
137,274,436.77
41,662,995.52
47,734,850.25
5,530,478.48
86,592,304.68
Percent of Portfoli
0.35%
0.28%
0.71%
0.54%
1.92%
4.81%
0.35%
0.52%
0.18%
0.70%
0.36%
0.35%
0.17%
0.52%
0.19%
0.36%
0.37%
1.49%
0.51%
1.76%
0.72%
Percent of Portfolio**
1.37%
1.93%
9.81%
23.89%
7.25%
8.31%
0.96%
15.07%
$574,649,668.59
City of Carlsbad
Summary of Outstanding Housing Loans
As of June 30, 2010
Updated on: 07/09/2010
Borrower
Individual homebuyers
Individual homebuyers
Individual homebuyers
Individual homebuyers
Individual homebuyers
Individual homebuyers
Catholic Charities
Development
City-wide (CHAP)
Calavera Hills
Cherry Tree Walk
Serrano
Rancho Carlsbad
Solamar
Homeless shelter
CB Laurel Tree Apartment: Laurel Tree
CB Housing Partnership
Pacific Vista Las Flores
Poinsettta 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
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
Glen Ridge
Purpose
Sale
Sale
Sale
Sale
Sale
Sale
Shelter
Rentals
Rentals
Rentals
Rentals
Rentals
Rentals
Rentals
Sale
Sale
Rentals
Sale
Sale
Sale
Rentals
Assistance
Rentals
First date
issued
06/28/99
10/15/99
06/28/99
05/25/01
05/20/99
09/26/88
09/19/97
12/24/98
03/05/01
02/27/01
10/21/99
11/04/94
07/15/03
09/15/04
04/29/05
10/28/05
03/07/06
07/06/06
06/14/07
08/30/07
08/19/08
06/25/09
10/05/09
Loans issued by Loan amount Developer loan
# of City to Loans issued Developer due to City amount due to
loans developers/ by Developer # of loans City loan loan repaid to (recorded as City (not on City's
issued homeowners to homeowners outstanding repaid to City City AR) books)
133
5
42
90
22
9
1
2
1
1
1
2
1
1
100
11
1
3
8
1
1
4
1
441 $
$1,680,000 $
75,000 150,000
453,600 452,600
1,350,000 4,050,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 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
21.291,706 $ 28,400,000
38
1
14
34
15
1
1
2
1
1
1
2
1
1
100
7
1
3
8
1
1
1
1
236
($1,315,797) $ - $364,202.80 $
(60,000) (120,000) 15,000
(302,400) (283,250) 151,200
(840,133) (2,520.000) . 509,867
(256,410) - 496,123
(135.065) - 12.661
200,000
(408,778) - 725,222
1,157,584
363,948
920.000
(1,725,986) - 486,014
(1,022,966) - 1.047,034
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
$ (6,067,535) $ (2,923,250) $ 15,224,171 $
364,203
30,000 45,000
169,350 320,550
1,530,000 2,039,867
496,123
12,661
200,000
725,222
1,157,584
363,948
920,000
486,014
1,047,034
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
25,476,750 $ 40,700.921
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 31th year
Payment deferred 30 years. No interest is
due unless home is sold before 31th year
Payment deferred 30 years. No interest is
due unless home is sold before 31th year
Principal is due when home is sold
Principal is due when home is sold
Principal is due when property is sold
Principal and 3% interest each year for 30
years when surplus cash is available
Principal and 3% interest each year for 55
years when surplus cash is available
Principal and 3% interest each year for 55
vears 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 15
years when surplus cash is available
Principal and 3% interest each year for 55
years when surplus cash is available
mncipai ana JYO interest eacn year tor SD
years when surplus cash is available
Payment deferred 30 years. No interest is
due unless home is sold before 31th year
Payment deferred 30 years. No interest is
due unless home is sold before 31th year
Principal and 3% interest each year for 55
years when surplus cash is available
Payment deferred 45 years. No interest is
due unless home is sold before 46th year
Payment deferred 30 years. No interest is
due unless home is sold before 31th year
Refer to Agenda Bill 18.569 / Resolution
2006-131 & AB 19.183/R2007-255
Refer to AB18.251 / Resolution 2005-264
Refer to Agenda Bill 1 9,41 5 / Resolution
2008-121
Refer to Agenda Bill 397 / Resolution 435rr
^<
H
During the 4th quarter of FY2009-10, $16,773.11 was received for CHAP payments. A $50,939 principal payment was received for the Laurel Tree development; a $244,375.92 principal payment was received for the Villa Loma development; and a $175,174 principal payment was Da
received for the La Costa Paloma development. The current outstanding ioan balance is now $15,224,171. '—'
1—>roo
City of Carlsbad
Bond Proceeds Investment Report
June 30, 2010
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.56%
0.56%
N/A
5.83%
6.03%
N/A
0.56%
5.36%
N/A
various
various
0.56%
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
954,117
1,190,644
277,790
921,351
1,292,770
4,602,814
2,478,045
953,706
1,926,459
771,235
24,492
12,829
1,068,180
3,828,612
1,238,325
21,541,369
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
Cost
Fiscal Agent:
954,117
1,190,644
Fiscal Agent:
277,790
Fiscal Agent:
921,351
Fiscal Agent:
1,292,770
Fiscal Agent:
4,602,814
2,478,045
Fiscal Agent:
953,706
Fiscal Agent:
1,926,459
771,235
24,492
Fiscal Agent:
12,829
1,068,180
3,828,612
Fiscal Agent:
1,238,325
21,541,369
Source
BNY Western Trust
LAIF
LAIF
US Bank
AIM Instit. Fund Services
BNY Western Trust
HSBC Bank of New York
BNY Western Trust
HSBC Bank of New York
BNY Western Trust
AIM Instit. Fund Services
LAIF
BNY Western Trust
GIC
BNY Western Trust
AIM Instit. Fund Services
BNY Western Trust
BNY Western Trust
BNY Western Trust
LAIF
BNY Western Trust
LAIF/BNY
BNY Western Trust
BNY Western Trust
BNY Western Trust X:Ei—i
CO
H:\Long Term DebttQuarterty Investment Reports\Qtr Inv Rpt.xlsx