HomeMy WebLinkAbout2009-09-15; City Council; 19954; Report on city investments as of 7/31/091
CITY OF CARLSBAD - AGENDA BILL
AB#
MTG.
DEPT.
19,954
09/15/09
TRS
REPORT ON CITY INVESTMENTS
AS OF JULY 31 ,2009
DEPT. HEAD ^
CITY ATTY.
CITY MGR.
rw
/^^u^~
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 July 31, 2009 is summarized below.
Pooled Investment Portfolio (Cash and Securities)
Par Value
Cost of Investments
Amortized Cost (1)
Market Value (2)
Current Month
558,072,723
564,396,813
561 ,935,545
570,170,177
Prior Month
563,761,416
570,194,074
567,705,932
575,580,798
(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 7/31/09.
The equity portion of the various funds in the total portfolio is summarized in the graph below.
Fund balances are restricted for various purposes. See Exhibit 8 for a more detailed breakdown.
FUND EQUITY IN POOLED INVESTMENTS
(Dollar Amounts in Millions)
Special Revenue
$46.7
Capital Projects
$279.3
General
$63Other $35
Internal Service ,
$25.8
$19.6
Enterprise
$123.3
Total Treasurer's Investment Portfolio at Amortized Cost
July 31, 2009 $561.9 million
FOR CITY CLERKS USE ONLY.
COUNCIL ACTION: APPROVED D
DENIED D
CONTINUED D
WITHDRAWN D
AMENDED D
CONTINUED TO DATE SPECIFIC
CONTINUED TO DATE UNKNOWN
RETURNED TO STAFF
OTHER -SEE MINUTES
Council accepted tbe report.
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 JULY 31. 2009
Pooled Investment Interest Income
Cash Income Fiscal
Year-to-Date *
Current
Month FYTD
1 ,991 ,746
Prior
Month FYTD
0
Current Month
Income
1 ,991 ,746
Correction of $20193.37 done after report submitted to council.
The cash income received is adjusted for any accrued interest purchased.
Pooled Investment Performance/Measurement
May 2009
June 2009
July 2009
Average Life
(Years)
1.50
1.58
1.54
Average Yield
To Maturity
3.26%
2.97%
2.86%
Modified Duration
1.403
1.478
1.452
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.
EXHIBITS FOR POOLED INVESTMENTS:
1. Investment Portfolio Breakdown By Amortized Cost, Market Value, Cash Income, and Average Yield
2. Investment Portfolio Breakdown Of Maturities
3. Yield Comparison Graph
4. Market Yield Curve
5. Cumulative Cash Income Graph
6. First Quarter Transactions
7. Detailed Investment Report
8. Fund Equity in Pooled Investments
9. Corporate Note and Commercial Paper Ratings
10. Percentage Weightings By Corporate Note Issuer
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF JULY 31, 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,293,542
0
92,689,490
285,550,103
115,721,767
49,997,188
94,526
V
1 ,329,590
1 ,226,339
Prior Month 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
33,000
15,302,060
0
92,717,800
291 ,597,845
117,871,828
49,997,188
94,526
1,329,590
1 ,226,339
Prior 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
Cash Income
Year to Date Current Month Prior Month
50
0
0
43,874
1,200,284
337,714
429,907
3
133
0
0.90
2.32
0.00
0.35
3.43
4.38
1.05
0.19
0.10
0.10
0.90
2.32
0.00
0.35
3.43
4.38
1.54
0.24
0.10
0.10
TOTALS $561,935,545 $567,705,931 $570,170,177 $575,580,797 $2,01 1 ,965 2.86%2.97%
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
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF JULY 31, 2009
BREAKDOWN OF MATURITIES BY CLASSIFICATION AND LENGTH OF TIME
CLASS WITHIN 6 MONTHS 7 MONTHS TO 1 YEAR
CD
FN
CP
TR
FA
CN
LAIF
CUSTODY
SWEEP
BANKACCT
TOTALS
% TOTALS
Total within One Year
0
4,911,490
0
56,007,316
38,191,792
19,183,608
49,997,188
94,526
1,329,590
1,226,339
$170,941,849 (1)
30.3%
33,000
997,329
0
31,690,087
47,001,489
16,075,380
0
0
0
0
$95,797,286 (1)
17.0%
$266,739,134 (1)
1 TO 5 YEARS
0
9,201,104
0
5,114,141
202,305,630
81,036,805
0
0
0
0
$297,657,679
52.7%
TOTAL
33,000
15,109,923
0
92,811,544
287,498,910
116,295,793
49,997,188
94,526
1,329,590
.1,226,339
$564,396,813
100.0%
% TOTAL
0.0%
2.7%
0.0%
16.4%
50.9%
20.6% (2)
8.9%
0.0%
0.2%
0.2%
100.0%
47.3%
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.
t— i
DO
PG
YIELD COMPARISON
PORTFOLIO EX-LAIF VS. LAIF
JULY 1996 - JULY 2009
4.25
4.00
3.00
2.75
to
MARKET YIELD CURVE
6/30/08, 6/30/09, 7/31/09
Market Rates
3Mth 2Yr 5Yr
3Mth 2Yr 5Yr 10 Yr
—06/30/2008
-*• 06/30/2009
-^•07/31/2009
1.73
.18
.17
2.62
1.11
1.11
3.33
2.55
2.51
3.97
3.53
3.48
10 Yr
X3:i—ico
Cumulative
Millions $
Cumulative Cash Income
FY09-10
(July 09)
20
18
16
14
12
10
8
Monthly Interest Income
Millions $
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
i—3 Interest Income --•--Budget Actual
8
7
6
5
4
3
2
1
0
Xn:i—i
DO
I 1
—I
on
City of Carlsbad
TRANSACTIONS FOR PERIOD:
07/01/09 TO 1ST QUARTER 2009-2010
Trans
Date
BUYS
JULY
07/21/2009
07/21/2009
07/21/2009
07/21/2009
07/21/2009
07/13/2009
AUGUST
07/21/2009
07/21/2009
Investment
Date
07/22/2009
07/22/2009
07/22/2009
07/22/2009
07/22/2009
07/29/2009
08/13/2009
08/10/2009
TOTAL FIRST QUARTER
Type
TR
TR
TR
TR
TR
FA
FA
FA
Security
US TREASURY
US TREASURY
US TREASURY
US TREASURY
US TREASURY
FHLB
FHLMC
FHLB
Call
Date
N/A
N/A
N/A
N/A
N/A
10/29/2009
11/13/2009
02/10/2010
2009-2010
Par
Value
2,000,000.00
1 ,000,000.00
5,000,000.00
3,000,000.00
1 ,000,000.00
5,000,000.00
1 ,000,000.00
2,000,000.00
20,000,000.00
Coupon
2.125%
2.000%
2.125%
2.000%
1 .900%
.5% STEP
2.250%
2.000%
Amount
(Cost)
2,019,531.25
1,010,312.50
5,069,531 .25
3,052,031 .25
999,250.00
5,000,000.00
1 ,000,000.00
1 ,999,500.00
20,150,156.25
Return
Rate
0.26%
0.30%
0.33%
0.54%
1 .93%
1.71%
2.25%
2.01%
1 .035%
Interest
2,775.38
1,861.41
12,754.76
19,444.16
54,741 .66
171,875.00
67,500.00
120,500.00
451 ,452.37
Investment
Return
2,022,306.63
1,012,173.91
5,082,286.01
3,071,475.41
1,053,991.66
5,171,875.00
1 ,067,500.00
2,120,000.00
20,601 ,608.62
MATURITIES
JULY
AUGUST
02/13/2009
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
04/24/2007
05/23/2007
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
CN
CN
FHLMC
FHLB
FFCB
FFCB
FHLB
FHLB
FHLB
FHLMC
FHLMC
FHLMC
HUD
FHLB
FHLB
FFCB
BANK OF AMERICA
WAL-MART
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
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
5,000,000.00
3.250%
5.375%
5.150%
5.150%
3.100%
4.180%
3.100%
4.375%
4.375%
4.375%
4.430%
5.250%
2.891%
5.000%
4.625%
6.875%
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,983,918.00
5,187,303.82
2.50%
2.45%
5.05%
4.80%
2.35%
2.98%
3.10%
3.50%
2.32%
2.40%
4.90%
4.87%
2.89%
5.00%
5.00%
5.06%
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
226,519.50
573,720.49
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,210,437.50
5,761 ,024.31
xn:i—i
DO
TOTAL FIRST QUARTER 2009-2010 33,770,000.00 34,312,625.50 3.938% 2,701,881.94 37,014,507.44
City of Carlsbad
TRANSACTIONS FOR PERIOD:
07/01/09 TO 1ST QUARTER 2009-2010
Trans Investment
Date Date Type Security
CALLS and/or SALES
JULY
01/20/2009 FA FHLMC
08/07/2008 FA FNMA
TOTAL FIRST QUARTER 2009-2010
Call
Date
Par
Value
07/20/2009 3,000,000.00
07/07/2009 2,000,000.00
5,000,000.00
Coupon
2.000%
4.000%
Amount
(Cost)
Return
Rate Interest
Investment
Return
3,000,000.00 2.00% 120,000.00 3,120,000.00
1,996,500.00 4.06% 236,833.33 2,233,333.33
4,996,500.00 2.824% 356,833.33 5,353,333.33'
INVESTMENT REPORT
AS OF JULY 31,2009
INVESTMENT
DATE
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
04/22/2008
05/05/2008
12/21/2007
03/16/2009
02/26/2008
05/08/2008
04/17/2009
08/05/2008
10/09/2007
07/25/2007
07/15/2008
03/12/2008
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
SECURITY
HUD 4.430% NON-CALL
FHLB5.25% NON-CALL
FHLB5.25% NON-CALL
FFCB5.00% NON-CALL
FHLB 4.378% NON-CALL
FHLB 4.375% NON-CALL
FHLB 5.25% NON-CALL
FHLMC3.5$ NON-CALL
FHLB 5.0% NON-CALL
FFCB5.00% NON-CALL
FNMA4.0% NON-CALL
FFCB 4.350% NON-CALL
FFCB4.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
FHLB 7.625% NON-CALL
FNMA 3.625% NON-CALL
FHLB 1.250% NON-CALL
FHLB 4.25% NON-CALL
FHLB 3.00% NON-CALL
FHLB 5.25% NON-CALL
FHLMC 3.50% NON-CALL
FHLB 4.5% NON-CALL
FNMA 5.125% NON-CALL
FFCB 3.200% NON-CALL
FHLB 4.44% NON-CALL
PAR
VALUE
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
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
INVESTED
AMOUNT
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
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
RETURN
RATE
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%
2.950%
3.700%
1.250%
2.849%
3.005%
0.930%
3.300%
4.610%
5.100%
3.200%
2.559%
INTEREST
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
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
INVESTMENT
RETURN
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
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
TERM
(Days)
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
739
889
457
836
764
420
680
987
1,077
730
866
Xret—i
CO
INVESTMENT REPORT
AS OF JULY 31,2009
INVESTMENT
DATE TYPE SECURITY
02/20/2008 FA FNMA4.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 FHLMC5.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
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
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
07/29/2009 FA FHLB .500% QRTLY 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
PAR
VALUE
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
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
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
5,000,000.00
3,000,000.00
1 ,000,000.00
3,000,000.00
1 ,000,000.00
2,000,000.00
INVESTED
AMOUNT
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
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 ,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
5,000,000.00
3,111,810.00
1 ,097,950.00
3,152,520.00
999,500.00
2,018,200.00
RETURN
RATE
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%
1 .377%
1 .305%
2.950%
1 .450%
4.252%
3.651%
1.420%
4.761%
3.345%
2.720%
4.805%
5.175%
4.781%
3.545%
1 .639%
2.050%
1 .750%
1.315%
1.710%
4.800%
1.818%
1 .490%
4.018%
4.773%
INTEREST
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
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
406,997.78
618,286.67
118,184.21
233,760.22
85,530.00
46,807.78
118,125.00
54,847.78
171,875.00
648,148.33
49,313.89
100,323.75
120,500.00
432,911.11
INVESTMENT
RETURN
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,31 1 ,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
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,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
5,171,875.00
3,759,958.33
1,147,263.89
3,252,843.75
1,120,000.00
2,451,111.11
TERM
(Days)
889
898
1,015
912
1,070
1,080
855
644
548
1,083
500
900
548
506
532
530
737
741
667
717
1,115
730
1,277
1,208
711
1,379
1,128
996
1,588
1,444
1,414
1,163
836
795
821
758
730
1,610
934
794
1,095
1,649
INVESTMENT REPORT
AS OF JULY 31,2009
INVESTMENT
PATE TYPE SECURITY
03/15/2007 FA FHLB5.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/22/2009 FA FHLB 1.90% QRTLY 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
05/11/2009 FA FHLMC 3.875% NON-CALL
10/29/2007 FA FHLMC 5.05% CALL 10/15/09
12/10/2007 FA FFCB 4.5% NON-CALL
10/22/2007 FA FHLB 5.00% CALL 4/22/10
11 /28/2007 FA FNMA 5.00% CALL 10/30/09
12/06/2007 FA FNMA 5.00% CALL 10/30/09
06/03/2008 FA FNMA 6.41% NON-CALL
05/19/2009 FA FNMA 2.2% CALL 5/19/10
12/21/2007 FA FHLMC 4.375% CALL 12/21/09
12/21/2007 FA FHLMC 4.375% CALL 12/21/09
01/23/2008 FA FHLB 4.7% CALL 1/7/10
01/14/2008 FA FHLB 4.25% CALL 10/14/08
05/19/2009 FA FNMA 2.32% CALL 2/19/10
PAR
VALUE
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
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
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
INVESTED
AMOUNT
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
999,250.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
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
RETURN
RATE
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%
1.927%
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%
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%
INTEREST
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
54,741.66
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
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
INVESTMENT
RETURN
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,311.11
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,053,991.66
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
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
TERM
(Davs)
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,038
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
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
INVESTMENT REPORT
AS OF JULY 31, 2009
INVESTMENT
DATE
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
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
TYPE
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FA
FN
FN
FN
FN
FN
FN
FN
FN
FN
TR
TR
TR
TR
TR
TR
TR
TR
TR
TR
TR
SECURITY
FHLB3.50% NON-CALL
FFCB 2.875% CALL 8/6/09
FHLB4.00% CALL 5/1 5/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/1 8/09
FHLMC 50.5% CALL 9/25/09
FHLB 3.5% CALL 11/26/10
FHLB 3.1 25% NON-CALL
FNMA 2.00% CALL 2/1 2/10
FHLMC 2.50% CALL 6/26/09 STEP
FNMA 2.0% CALL 8/1 4/09
SUB-TOTAL
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
SUB-TOTAL
Federal Investments Total
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%
PAR
VALUE
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
283,01 1 ,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
16,000,000.00
299,011,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
INVESTED
AMOUNT
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
287,498,910.47
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
302,608,833.47
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
RETURN
RATE
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.427%
3.109%
0.274%
0.386%
2.200%
2.300%
2.710%
2.850%
3.000%
3.050%
2.320%
0.132%
0.142%
0.157%
0.172%
0.183%
0.183%
0.315%
0.233%
0.244%
0.274%
0.233%
INTEREST
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
33,455,572.46
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
34,431,399.46
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
INVESTMENT
RETURN
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
320,954,482.93
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
337,040,232.93
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
TERM
(Days)
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,154
343
184
253
744
908
1,178
1,171
1,166
1,314
807
1,961
104
91
91
119
126
146
192
167
154
179
162
o CM CM o cot en T^ co •* o cn CMCO1
CO CM
CMOCMcpcoincocncoco^-r^T-oocncococMMT— T— ^-T— T— r^cOCOCM^COlOSi-co CM 00CM O O CO t^
oooococoi-T-cnocni-oincnco-i-cococM oo OK- ooooioooc»O5Nocooojoo'*Ti-TfoocO'<t- oo in coocoO'-oooocoi^cot^cooocoincoo^ooooini-CMi-inh-in cn CM t •* CMo t~- CM in *- oCO •* CM CO i- •*
CMinCMCMCOOCOCMCMCOCO^— ^"O
in co" CM" co" CM"
uouNtcM.nrqcM
1- O T-
co" CM" co" in" co" co" co co co
§cn cn h~ in in SO O O i- r- CM
OT-cocoT-T-^-cMOOoocococQococncnT-cQooococof~coOT-coococoi^cot"-cn
CM" in" in" CM" CM" CM" T-" T-" T-" T-" CM" co" CM" co" CM" T-" co" CM"
^•ocomoomi-T-ocncoiot^cocnocococo•^•oior^coincnTfcococDi^inco-^cOi-coT-1 1
co to
S cn•t
crio1-cMSTj N-_ r^_ 10oi" co" T-^ ofT- T- CM in
d(dcji-:c>incriooinT-enocncoTrcncni^cocoi-ocnoocor^" " " " " " " " "co" co" oo"i^-oi^•- -
Ti-coi-ocDi^t-ioco" en" co" <0~ in" en" K
53a<
^ Np6^ 5^
S1" coin
xO vp?M I:N^P vP vP >^ sP -^ -^P ^O -^O•» o^tf^o^O^O^O^O^O^O^O^O^,s^jlO^^r-^csjcMi-coo^h-cMincM-. _. . _ ,, _.
3^|cocvjwcocvico*<tcoco^|COco^;iQ'^;ioio^;^;coddddddddddddddoddcsicMC)
vQxp^PNPspsPxpxOspsPvP^p^P-sp^pO^O^tf^O^tf^O^O^O^O^O^O^O^tf^O^O^8 8O i- i-iri m" iri Tt co co co Ifc\i
i^ cn CM CMCO O T- CM
§ttinmi-oocn-*-toincocnocoino•*CMCMCOOini-i-OCMCDi-Oi-CMO 8 8
. in o cn co i-oocMr^co'^i— ocMinoot—ooi— cor^o-^coincocMOT-coococo^-cni^i^cocMoOTj-D^~incoococooO'~mi— Tj-ooinocoN-in
g CMCOOCOT— T-CMCOOCMCnCMCOOOOOoq^q^-oooqcqinqcnqr^T^qqqT-;
cocoi— ococMcor^coocno^'cnooocoi-oincMtcooot^^-1-ooini-oococMOcncncot^i-ioincot^cocncOT-cocDincoor^
in cn co m o co ^ co cn ^ cn co ^ CM ^- o ^~COT— cMCM^-cocncncoi— cor^r^incocoi—OOT-OOOCnoOr-OOOOOOCOco CM co CM comcococococOT-T-cM
88888888888888888888
UJ o o o oo o o o
o o o o o oo o o o o oo o o o o o
co coco co
11
co coCo cO
r^ ^ o o co co r^ in T— o CM co CM co r*^ o T—oo oo co ^ co T~ cn CM 01 co m Co o cn oo o enT— 00 O O O O O) O O) O O5 O O O5 O5 O O5in Tt" CM" CM" CM" T-~ T-" CM" CM" CM" co" T-" in" T-"
888888888888888888
CMinincMCMCMT-T-T-T-CMCOCMCOCMT-inCM
5? 5? S?
888
rr or rrD 3 oco co co
111 LU LUrr cc rr
h- I- h-
W CO COD D D
g 1
CO
CO
CM CM CO CM CM T-
^p ^p t> ' s$>O^ .0 O^ O tf^in 5^ in m oCM o CM h» •"T- in cp coCM^CM'CMCMCMCOCO
^ s? s?5^ in in§CM CMf- •*-
rr oc rr tro 3 o 3 _ _
CO CO CO CO CO CO
LU LU LU LUrr oc rr cc\- \- i- i-
CO CO CO COD D D D
tr rr oc rr3 13 O D
EA2 %LU LU LUrr rr oc rri- i- i- H
CO CO CO CO3 3 ID 3
oc rr rr rrD 3 3 O
CO CO CO CO< < < <LU LU LU LUoc oc rr rr
I- I- h- I-
CO CO CO CO13 D D D
oc rr DC DC
O D 13 ID
CO CO CO CO< < < <LU UJ UJ UJOC OC OC DC
I- I- I- I-
CO CO CO COD D D D
CD
CO
COCOo
^oorr
Z
3LU
§
9
o
g
CMCD
^
^BANK OF AMERIC_i
O
O2
5?WAL-MART 6.875d
o
o
§
^Tj
MERRILL LYNCHO
zO
s?oinCMin
Orr
GENERAL ELECT<
ZOZ
InCM
^>_BERKSHIRHATW<
ZOZ
inCM
^j
^.BERKSHIRHATW_i
O
O
s?CM
•>t
O
WELLS FARGO C_i
Ozoz
TOYOTA 3.8347°=!
9
O
5?oin•>t
CO
GOLDMAN SACHi
o
Z
0^WAL-MART 4. 125<
OZ
gS
WAL-MART 4. 125_i
Ozo
5?o
US BANCORP 4.5_j
<o
o
s?inCMCO
WELLS FARGO 4$
o
- o
WAL-MART 4.757S
o
- o
WAL-MART 4.757=j
9
o
s?inCMCO•<t
NEW YORK LIFE9
o
s?CITIGROUP 5.126o
o
s?CITIGROUP 5.12Err oci- i-rrococncocDcococDCocl-l-HI-l-l-l-l-l-l-DC rr rr oc DC DC DC Qo zzzzzzzzzzzzzzzzzzoooooooooooooooooo
ooo^-^-1o S 5 5 ^ ^
CM CM CM CM CM CM CM
cS^^^^ra^o
CN|tOC\ICD^O>COlOCncOOOC\I O>COCOOCO<D O)CO^tO-<-a)(Diocqcoi-;^cqio ED-CO ^CO CD
CO COi— T-lOCDCDCDCOc\jO)'«toocoo)^'
iocor^odco'(ocrio>^I^OJ^tlOlOCOOiCOOJcoooiOi— r^-oor^ioo
w^OOCOCDiOi-^to
.--- -.—ooocncnf^inooocooo-^-oinooi-'-'- i-i-CMi-COCMtTCMCM'ti-inCMi-CMCOi-
oooocMocnoooooooooooinini^t^inooinooot^oooo-
ooooooooooinincoo'*inoinoo oco
oo'tcoooocncDoooooin-'-'<frinoo ooooOT-oO'<t'-i---oo t OOOCMoo co ocntCM T- en coen CD co h-h- in in h-
O) O O O OCM" co" co" CM" T"
coi-CMincDcoooooocnoooooo-r-oO'-in
T-" CM" i-~ T-~ CM" CD" co" CM" co" i-~
mOi-COCOTOT-'fCMOOOOOOOOOO CM CM T oo T- CM oW CM" in" T-~CMco"
in en
CO t- CM CM i- i- CM
8 8 8 8 §§§ 8 § 8 8 8 8 8 8 8 § 8 8 8 §§ 8 8 8 § 8 8 8 8 8 8 8 8 8 8 8 8
LUn oooooooo
oooooooooooooooooooooooooooooooooooooooooo
oCOo
CM•tT- enCD coin inin" en"o o o o o o o
CM" co" co" co" CM" •*" T-~
in
feCM in co CM co CO t- CM CM i-CM t- CM T-CITIGROUP 5.1 25% NON-CALLHOME DEPOT 5.20% NON-CALL=!GENERAL ELECTRIC 5.50% NON-CA=!GENERAL ELECTRIC 5.50% NON-CATOYOTA FIN 5.375% NON-CALLTOYOTA 5.450% NON-CALL_i
Oz
ROYAL BANK OF CANADA 5.65% NOWELLS FARGO CO 5.30% NON-CALL_,
<GENWORTH GLOBAL 5.375% NON-C9
O
MET LIFE GLOBAL FUNDING 5.125%CO
S2
GENERAL ELECTRIC 5.50% CALL 11,CITIGROUP 2.875% NON-CALL_,
i<r
GENERAL ELECTRIC 5.875% NON-C,_ii
GENERAL ELETRIC 5.875% NON-CAI_ii
GENERAL ELETRIC 5.875% NON-CAICHEVRON 3.450% NON-CALLBARCLAYS BANK 2.7% NON-CALLBERKSHIRHATWY4.00% NON-CALLBERKSHIRHATWY4.00% NON-CALLPRINCIPAL LIFE INC 4.5% NON-CALLi_i
GENERAL ELECTRIC 6.00% NON-CAi_i
GENERAL ELECTRIC 6.00% NON-CA1
PROTECTIVE LIFE 5.050% NON-CALl_it
<JOHNSON & JOHNSON 5.15% NON-CH
^GENERAL ELECTRIC 5.250% NON-C,-j
3
GENERAL ELECTRIC 5.250% NON-C,WELLS FARGO 5.250% NON-CALLo
o
MET LIFE GLOBAL FUNDING 5.125%O
O
MET LIFE GLOBAL FUNDING 5.125%WAL-MART 4.250% NON-CALLALLSTATE LIFE 5.375% NON-CALLNEW YORK LIFE 4.650% NON-CALLBERKSHIRHATWY4.60% NON-CALL3 M 4.375% NON-CALLi
PROTER & GAMBLE 4.60% NON-CALlWAL-MART 3.20% NON-CALLm
en
Oo
LU
LU
? = £< C/3 Zm < D
000
O LUDC \-o
£5DC DC
ollzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz>-OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOCJ o o o
LU "*- ""-" «5I i s s § s 55..Oi-i-OOOOO
75"
H
&, ON
PH r<
K (T)
**>S u>
H taC/5 Os Sz ^hH
LJ g
Z
UJ 2!
S
j{5 H
> a
Z
s
DC
z
^r
5 H
m S
DC
Q i-
H?« S11
UJDC 3
£S
ECURITY(/)
S
LOa
oin
d
5?
8
5
ain
CMin
Tt"en
94,525.90\hZ3IT
ZO
In
Sq.
§
en
inCO
SCM
5*
S
0
1—
^i
St--"COco0)"
^i
001^go"
&
DCh-W
Q
DC
LLJ
b
<
LL
S
O)
|^~
CDin
5?
gp
r^
t^
CO
CMCO
o"r~-•<t
,470,621 .67^
•z.O
h-CORPORAi—OVEMENcrQ.1
o
m
0.
LL
5
O)0
i
^~
COin
•*a
s?gq
*-,784.88CDCM
,126,784.88^
z
RPORATIOIO0
Oz
o
<z
LLo
m
DL
LL
00
in
CM"g
oo"
CO
COCMin
5?
Sq
r^,000.00CMcoo
oo",062,000.0000
LSBADDC<O
LL
0>-H
O
LL
S
S
CB"•*co_
CM"in
mN
in
3.
g
o
T^,643.07r>.•*coCM"m
,647,643.07S
i
0\CO
§
£
^^-_
oo"
CO
SJss
o"CM
S?CMCO00
CM
,812.948co•*"COin
fe
COCMh-_
CM"No_
B
<!
0
GRAND T'O O O O O
EXHIBIT 8
CITY OF CARLSBAD
Fund Equity in Pooled Investments
AS OF JULY 31, 2009
Cash Balance by Fund:
General 63,678,385
Special Revenue 46,692,693
Debt Service 6,657,897
Capital Projects:
General Capital Construction 64,744,345
Traffic Impact Fees 14,546,408
Public Facilities Fees 42,696,599
Park Development 2,327,364
Transnet Taxes 5,487,571
Drainage Fees 8,328,991
Special Districts 86,434,492
Infrastructure Replacement 53,272,462
Other Capital Construction 1,428,580
Total 279,266,813
Enterprise:
Carlsbad Municipal Water District 61,984,515
Sewer Fund 51,531,979
Solid Waste 7,031,949
Storm Water 1,851,381
Golf Course 941,368
Total 123,341,191
Internal Service 25,827,577
Agency Funds 19,638,316
Redevelopment Funds (1) 0
Misc. Special Funds 0
Total General Ledger Balance ** 565,102,872
Reconciling Adjustments (2) (3,167,327)
Total Treasurer's Investment Portfolio at Amortized Cost 561,935,545
(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 08/07/09
17
EXHIBIT 9
CITY OF CARLSBAD INVESTMENT PORTFOLIO
As of July 31, 2009
CORPORATE NOTE AND COMMERCIAL PAPER RATINGS
Corporate Note Investments Meeting the Current Investment Policy:
(Ratings must be AA or better by both Moody's and S&P)
Moodv's S&P
BARCLAYS BANK
BERKSHIRE HATHAWAY
CHEVRON
GENERAL ELECTRIC
JOHNSON & JOHNSON
MET LIFE GLOBAL
NEW YORK LIFE
PROCTER & GAMBLE
ROYAL BANK OF CANADA
3M
TOYOTA
US BANCORP
WAL-MART
AAA AAA
AA2 AAA
AA1 AA
AA2 AA+
AAA AAA
AA2 AA-
AAA AAA
AA3 AA-
AAA AA-
AA2 AA-
AA1 AA
AA3 AA
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 *
Moodv's S&P
ALL STATE LIFE
BANK OF AMERICA
CITIGROUP
GENWORTH GLOBAL
GOLDMAN SACHS
HOME DEPOT
MERRILL LYNCH
PRINCIPAL LIFE
PROTECTIVE LIFE
WELLS FARGO
A1 AA-
AA3 A+
A3 A
A2 A
A1 A
BAA1 BBB+
A2 A
AA3 A+
A2 AA-
A1 AA
Carrying
Purchased Value
05/30/2008 2,017,956
04/24/2007 1 ,999,961
06/20/2006 11,042,146
05/07/2008 2,010,517
03/19/2008 1,009,992
06/12/2006 2,991,733
11/03/2006 4,995,623
04/30/2008 1 ,000,000
07/17/2008 3,000,000
01/30/2008 5,080,770
Market
Value
2,093,920
2,000,000
11,128,750
1 ,906,700
1 ,029,060
3,115,680
5,005,550
1,021,800
2,904,000
5,171,120
* 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 JULY 31, 2009
WEIGHTINGS FOR CORPORATE AND FEDERAL AGENCY ISSUERS
EXHIBIT 10
PERCENTAGE WEIGHTINGS
ALL STATE LIFE
BANK OF AMERICA
BARCLAYS BANK
BERKSHIRE HATHAWAY
CHEVRON
CITIGROUP
GENERAL ELECTRIC CAP
GENWORTH GLOBAL
GOLDMAN SACHS
HOME DEPOT
JOHNSONS 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
BY CORPORATE NOTE ISSUER
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
PERCENTAGE WEIGHTINGS BY FEDERAL AGENCY ISSUER
Investment Cost
FAMCA 6,868,837.32
FICO 9,201,103.56
FEDERAL FARM CREDIT BANK 35,541,820.00
FEDERAL HOME LOAN BANK DISCOUNT NOTE 5,908,819.44
FEDERAL HOME LOAN BANK 155,175,732.52
FEDERAL HOME LOAN MORTGAGE CORP 49,039,099.55
FEDERAL NATIONAL MORTGAGE ASSOC 37,752,243.08
HOUSING URBAN DEVELOPMENT (HUD) 990,198.00
TVA 2,130,980.00
U.S.TREASURY , 92,811,543.56
Total Portfolio
* No more than 5% may be invested with a single corporate issuer.
"There are no percentage limits on federal agency issuers.
Percent of Portfolio
0.36%
0.35%
0.28%
1.45%
0.55%
1.95%
4.87%
0.36%
0.18%
0.53%
0.18%
0.87%
0.72%
0.35%
0.18%
0.93%
0.53%
0.19%
0.38%
1.26%
0.52%
2.71%
0.91%
Percent of Portfolio"
1.22%
1.63%
6.30%
1.05%
27.49%
8.69%
6.69%
0.18%
0.38%
16.44%
$564,396,812.94